The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Maybe you can post those values somewhere on hotscripts or something similar to that. I doubt that the person who started this thread is seeking the information but it would be good to have it somewhere just in case someone else does.

Sure, what would you like? After looking at my files, I have a really accurate datafile (52,600 US Zipcodes with lats, longs, states, GMT offsets) but they are nowhere near SQL ready, so you will have to either edit the file or write a script to get them into a table. I also have a flatfile with just cities and zips. I have another datafile that is SQL ready, but it only has zips, lats and longs and is only 42,000 lines, so I am not sure how accurate it is. I also have a MySQL command line that will pull all records in a client table that are within a proximity to a supplied zip code using spherical surface distance of the Earth.

Probably the first option, and I'll just write something to carve it up however I want it. And the mysql command line too.

I use winrar 3.2 for compressed files so a zip or rar is good.

Thanks

As for the thread dying, I've been interested in this topic for a few years so it's in my subscribed threads and I always check back whenever someone posts to it

OK, give me a couple of days. The file I have that is the most accurate is now in two formats; MySQL AND flat text. The MySQL ready version is formatted to insert with my table name. I can run a dump to get the table structure and zip data all in one file (but again, it will have my table name in it). How do you want it?

The file is about 970K gzipped. Extracted and installed it is about 3.5 MB.

Good luck!

PS If anyone is looking for a goodwill gesture to offer for this data, my automotive forum just went up and could use some members

Hey thanks!

I lurk these forums a lot looking for code help and today they provided me with a free zip database that I thought was going to be impossible to find. I thought I'd register and say thanks for the help

p.s. - I'd help by joining the auto forum but I have absolutely no interest in automotive stuff so I don't think it'd do much good sorry.

Taking the Zip Code data down...

Hi everyone. I hope the zipcode data has been helpful. I am going to be taking the data down tonight. There has been an awful lot of folks downloading the thing, so I believe I am going to take it a step further and package a locator. I am finishing up a class right now that will search the database for clients that are in a proximity to a user. That is what I was looking for originally.

Can I get an opinion? If this data was sold at a fair price (say $10), would you have considered buying it? All responses are welcome. Thanks for your feedback.