• Sign in to Neowin Faster!

    Create an account on Neowin to contribute and support the site.

  • 0
Sign in to follow this  

Zip Code Distances?

Question

mFC_    0

hi everyone,

i was wondering if anyone has some across any software/database dump/whatever which contains all US zip codes and the distances between them? i'd like to implement something like this in a project i'm working on, but haven't come across a free solution just yet. any help would be greatly appreciated!

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
PKHelloNasty    0

http://hostip.info - IP Lookup

http://www.cfdynamics.com/zipbase/ - Zipcode database

You doubt you will ever find a database that has the distances of all the zip codes, thats just a waste of space (in most cases). However you can easily find the latitude and longitude of these zip codes and calculate the distance fairly easy.

If you need help getting the text version of the DB into a MySQL Table.. try SQLYog. I believe it will allow for comma seperated variables.

Share this post


Link to post
Share on other sites
  • 0
mFC_    0

i got it all figured out more or less

i found a listing for $5 which offers free updates (which seem kind of trivial at the moment) and i got that all loaded into mysql with a quick php script i wrote

took me a little while to get a query working which calculated a proper distance, but it does work :)

i checked out the website on your profile too, pretty slick!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.