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
Results 1 to 3 of 3

Straight Line Distance Between Zip Codes

This is a discussion on Straight Line Distance Between Zip Codes within the MapForums Plus Downloads forums, part of the MapForums Plus category; Here's a little Access database for calculating the straight line distance between zip codes. It uses MapPoint to get the ...

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

    Straight Line Distance Between Zip Codes

    Here's a little Access database for calculating the straight line distance between zip codes. It uses MapPoint to get the lat/lon (geocode) of the zip code. It just puts in 0 if it can't find the zip code. Also, there is a routine to try to standardize the zip code and it writes the formatted zip code back into the original table.

    Your database must be placed in a table called ZipCodeList with columns ZipA, ZipB, and StraightLineDistance.

    There is a macro "Run Program" which kicks off the code.

    See screenshots of the sample data before and after the program is run.

    Let me know if you would like help with this or have any questions!

    Eric
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Eric Frost; 05-10-2009 at 01:01 PM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  2. #2
    flystol is offline Junior Member White Belt
    Join Date
    Apr 2009
    Posts
    4

    Re: Straight Line Distance Between Zip Codes

    Eric, this is a great little program and does exactly what I need. Thanks so much for your help on this problem.

    flystol

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

    Re: Straight Line Distance Between Zip Codes

    Ah - awesome. I was afraid it's a little specific in terms of general needs in the MapPoint Community to add to our Downloads section...

    I can think of lots of slight variations that would require only minor code changes. If any other MapForums Plus subscriber needs something similar let me know know and I'll take a stab!

    Happy Mothers Day!

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

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Distance between post codes
    By nick72blue in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 01-16-2010, 04:56 AM
  2. How to get distance by zip codes data?
    By Catkins in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-18-2007, 04:33 AM
  3. calculate straight line distance
    By frizzello in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 12-14-2006, 12:58 PM
  4. Narrowing down lists with zip codes/distance
    By nicholali in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-10-2006, 10:15 AM
  5. Points in a straight line
    By Dazzer in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 05-25-2004, 11:27 AM

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