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 5 of 5

Want to Purchase Zip Code Mileage Table

This is a discussion on Want to Purchase Zip Code Mileage Table within the MapPoint Desktop Discussion forums, part of the Map Forums category; We require a flat file that contains mileage (route miles) between all US 5 digit zip codes, as well as ...

  1. #1
    FreightDude is offline Junior Member White Belt
    Join Date
    Aug 2006
    Posts
    1

    Want to Purchase Zip Code Mileage Table

    We require a flat file that contains mileage (route miles) between all US 5 digit zip codes, as well as 3 digit to 5 digit zips.

    The problem is that we calculate that it will take us thousands of hours to run the calculations in MapPoint to generate the 5 x 5 table. We started using MapPoint, but I am open to any economical solution.

    Ideally, does anyone know where we could purchase such a file that has already been created (for a reasonable amount - we were already sticker shocked by some large vendors).

    Second best is a software tool that would allow help us accomplish this quick and easy that either works with OR without MapPoint.

  2. #2
    goenba is offline Junior Member White Belt
    Join Date
    Sep 2006
    Posts
    1

    More infor needed

    Could you be a little more specific in what you need. I have an Access DB that has the Long & Lat for most all of the known zip codes (42,800 records), and with that I can give you the distance from point a to b. The problem is, I believe that my miles are "as the crow flies", so I'm not sure that this would be what you need.
    Just what are you looking to do?
    BJ

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

    So that's about 0.9 billion routes!

    You're going to need a very fast route finder (significantly faster than anything I've seen) if you're going to calculate all of them.

    I suggest you use straight lines (at, say 1000/second, that still comes to 254 hours computation time), or look at your real needs. Eg. you could compute them as needed and cache the results.

    Another thought: 0.9 billion routes, excluding indices/etc, that comes to about 7 GB of memory/disk if you use doubles. If you go for '4 byte floats', that is still 3.5GB...

    We do sell a mileage chart computation program (MileCharter), but the above statistics are beyond MileCharter and MapPoint - as well as Excel which is the usual form of output.

    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  4. #4
    rcmtnbike is offline Junior Member White Belt
    Join Date
    Oct 2008
    Posts
    1

    Re: Want to Purchase Zip Code Mileage Table

    I'm looking for a tool that has driving distances from a distinct set 10 zip codes to every other zip code in the U.S.

    A comprehensive zipcode excel file with milage between every zip code to other zip codes would also work

    Does anyone have a chart - can not use a calculator

  5. #5
    lfdmike's Avatar
    lfdmike is offline Member Green Belt
    Join Date
    May 2004
    Posts
    56
    Blog Entries
    7

    Re: Want to Purchase Zip Code Mileage Table

    Lets see. 1 zip code per row, 10 zips as columns. ~ 430k formulas.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Performance: UDL vs Access Linked table
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-19-2004, 04:19 PM
  2. question before purchase
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-07-2004, 02:59 PM
  3. Import a Table From Microsoft Access
    By awiora in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-21-2003, 08:51 AM
  4. Trying to add pushpins for specific table data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-02-2002, 08:37 PM
  5. Where in the UK can I purchase a manual for Mappoi....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-10-2001, 09:45 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