Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Page 1 of 2 12 LastLast
Results 1 to 10 of 20

Drawing Drivetime Zones Around a List of Lat/Lon's

This is a discussion on Drawing Drivetime Zones Around a List of Lat/Lon's within the MapForums Plus Downloads forums, part of the MapForums Plus category; This was prepared by request, it allows you to set up a list of lat/lon's in Excel and draw drive-time ...

  1. #1
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,068
    Blog Entries
    4

    Drawing Drivetime Zones Around a List of Lat/Lon's

    This was prepared by request, it allows you to set up a list of lat/lon's in Excel and draw drive-time zones around each location. You can specify the color and number of minutes for each location.

    Enjoy!

    Eric
    Attached Images Attached Images
    Attached Files Attached Files
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,068
    Blog Entries
    4

    Re: Drawing Drivetime Zones Around a List of Lat/Lon's

    I created a new version of this for a MapForums Plus member who wanted to be able to specify an existing map and add the new drivetime zones on top of the existing map. If this would be useful to anybody let me know and I'll post the new version.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    nolster is offline Junior Member White Belt
    Join Date
    Aug 2012
    Posts
    4

    Re: Drawing Drivetime Zones Around a List of Lat/Lon's

    Could this marco be adjusted to provide the option to hide the drivetime size label? I saw that this option exists on the circle around a long/lat. The labels are hiding the drive zones in my application.

    Thank you.

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,068
    Blog Entries
    4

    Re: Drawing Drivetime Zones Around a List of Lat/Lon's

    Hi Nolster!

    Thanks for your patience.

    I have added this as an option for each row, see attached.

    Drivetimes_Around_LatLon_v2.zip

    Just fill in "FALSE" for all the rows if you do not want the Size to show for any of the drivetime zones.

    Eric

    Drivetimes_Around_LatLon_v2.zip
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  5. #5
    nolster is offline Junior Member White Belt
    Join Date
    Aug 2012
    Posts
    4

    Re: Drawing Drivetime Zones Around a List of Lat/Lon's

    Now that all of the drive time labels are hidden, I can see there is an issue with borders. This I fixed myself, just manually making the border color the same as the zone color inside the VB code. Works great at this point. Thank you for your help.

    BTW - we are mapping nationwide, to show clients points of presence coverage against contracted drive time. Works incredible.

  6. #6
    Kirsten Tisdale is offline Junior Member Yellow Belt
    Join Date
    Aug 2009
    Posts
    20

    Re: Drawing Drivetime Zones Around a List of Lat/Lon's

    Eric

    This looks like just what I need - I'm not a VBA expert, so it would be good to have some guidance on three points - any changes required for 2013 version, any changes required for Europe map and how could I make it use postcodes rather than lat long. Very many thanks in advance.


    Kirsten

  7. #7
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,068
    Blog Entries
    4

    Re: Drawing Drivetime Zones Around a List of Lat/Lon's

    Do you mind to share 10 or so sample postcodes? I will prepare a new tool that works with postcodes and test to make sure it works properly with MP13EU.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  8. #8
    Kirsten Tisdale is offline Junior Member Yellow Belt
    Join Date
    Aug 2009
    Posts
    20

    Re: Drawing Drivetime Zones Around a List of Lat/Lon's

    Eric

    Thanks for this - here are some sample postcodes:
    G31 4EB
    LS11 5BJ
    CV3 4AR
    OX4 3JP
    TQ2 7AN
    TR10 9LY
    NR6 5DT
    CT11 7PR
    E10 5NH
    RG30 4EL

    Kirsten

  9. #9
    Kirsten Tisdale is offline Junior Member Yellow Belt
    Join Date
    Aug 2009
    Posts
    20

    Re: Drawing Drivetime Zones Around a List of Lat/Lon's

    Sorry - should have looked at preview first - these should read, for example, G31 4EB.

  10. #10
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,068
    Blog Entries
    4

    Re: Drawing Drivetime Zones Around a List of Lat/Lon's

    I took a quick stab at this, see attached.

    This doesn't have all the bells & whistles of some similar tools I did recently e.g. all the options in this tool -- Draw Circles from Addresses v3.0 but let me know if you want them and I can certainly add them for you.

    Eric
    Attached Files Attached Files
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automate drivetime zones
    By econalan in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 08-30-2005, 01:20 PM
  2. Exclusive Drivetime zones
    By IamRascal in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-24-2005, 12:18 PM
  3. Drivetime Zones
    By Anonymous in forum Wish List
    Replies: 2
    Last Post: 01-03-2003, 04:23 PM
  4. Find Nearby and DriveTime zones.
    By DaveB in forum Wish List
    Replies: 0
    Last Post: 12-20-2002, 09:30 AM
  5. Exporting info outside drivetime zones
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 10-08-2002, 11:21 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58