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 11

Export Zip Codes Along A Route

This is a discussion on Export Zip Codes Along A Route within the MapPoint Desktop Discussion forums, part of the Map Forums category; Here is what we would like to do: Use the route planner to generate a route as well as a ...

  1. #1
    mxracer is offline Junior Member White Belt
    Join Date
    Jul 2009
    Posts
    1

    Export Zip Codes Along A Route

    Here is what we would like to do:

    Use the route planner to generate a route as well as a boundary around that route. Let's say the route would be from Boston to New York and we want to have a 25 mile boundary along that route. Now, I want to export all zip codes that either fall within that boundary or cross that boundary. The catch is, I don't want this from data I've already imported, I just want the standard zip codes already in MapPoint.

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Export Zip Codes Along A Route

    Hi,

    Programatically this is possible. You make a shape around the route and get all zip code.

  3. #3
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: Export Zip Codes Along A Route

    Wilfried, is it possible to give some general guidance on how you would draw up a shape like this along a route using code. I had a similar issue a few months back and couldnít come up with a solution so I ended up drawing free form sausage shapes!! The other idea I had was to set waypoints at small intervals along the route and then find postcode (zip) centroids within 25km of each one but again I couldnít figure out how to add in the waypoints.

    Rgds
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: Export Zip Codes Along A Route

    Depends on how accurate and how bendy the roads are!

    You need some locations along the route. The individual directions have locations but these are for views of that particular direction. These might be good enough but there's no guarantee that they'll actually be on the road route.

    The alternative would be to set the route to "shortest distance" and add lots of rest stops (every few minutes). Then extract the locations for each rest stop. These will be on the route.

    Then you use some geometry to find two points on each side of these central points. Then connect up into a polygon. You will need to code the geometry yourself - finding the normal to the route is probably a good start, then project outwards.
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  5. #5
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: Export Zip Codes Along A Route

    I did try the ‘rest stops at tiny intervals’ strategy, with the idea being to identify each postcode sector centroid within 25km of a rest stop and then sift out duplicates. If I recall rightly what happened, on motorways and fast dual-carriageways the rest stops become much further apart because of the scarcity of junctions and when you plot the results the sausage gets very narrow along these stretches!!
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  6. #6
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Export Zip Codes Along A Route

    Hi,

    I think the thechnique that Richard describes is the best one to go

  7. #7
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: Export Zip Codes Along A Route

    This is a bit academic but another question. If you calculate a route from A to B and then trace that route with the scribble or freeform tool, is it possible to work out latitude and longitudes for points along that line, say at 1km intervals. I can see how that would then be a basis for drawing an accurate shape around the route and calculating zips.
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  8. #8
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: Export Zip Codes Along A Route

    Iíve just realised that itís possible to draw the sausage shape along a route by using Find Nearby on the route. Therefore it must be straightforward with some code to output all the zip centroids falling into the shape.
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  9. #9
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Export Zip Codes Along A Route

    Hi David,

    I thought that this was the problem:

    " The catch is, I don't want this from data I've already imported, I just want the standard zip codes already in MapPoint."

    Mike Mattys

  10. #10
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: Export Zip Codes Along A Route

    davidb: If there is a long distance between two points, then why not simply interpolate between the two points?

    To do it properly, you should interpolate along a great circle arc, but for the tens of miles at a 'temperate' latitude (doesn't work for polar regions!) that I think we're talking about, then a simple linear interpolation should be okay.
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

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. Does MapPoint 2006 export Zip Codes to Excel (if territories are counties)?
    By SentryEquip in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-25-2008, 02:41 PM
  2. Draw shape, select zip codes and export to SQL
    By mmartin in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-02-2007, 04:24 PM
  3. Export Zip Codes To Excel
    By JimS in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 01-24-2006, 01:46 PM
  4. Export Zip Codes to Excel Problem
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-09-2004, 04:24 PM
  5. Find and Export of ZIP Codes
    By Anonymous in forum Wish List
    Replies: 1
    Last Post: 01-16-2003, 06:22 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 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132