Zip Codes Database Table MySQL Export (2006 version with Latitude & Longitude)
As I had promised to myself and a few others. Here is a 2006 Zip Codes Database MySQL Export with latitude and longitude coordinates.
I had been looking for a zip radius solution for one of my projects and I ran into micah's zip code class online. The class is very nicely done; and I am very grateful for people like him who share their work with the world.
But I did notice that the database table for zip codes being used was a bit outdated; I tried to find a mysql export, or as I like to childishly snicker "dump", with the 2006 zip code public data I had found online. I could not find one readily, so I offered some time to transfer the data to a mysql friendly format that would work with micah's solution (If you would like examples on how I made a zip radius search with Micah's class just let me know!).
It is late and I still have much else to do. I have been able to transfer the data, but I do not have time to break it up into 5 mysql files. If you are kind enough to do so, please send me a zip and I will post it here. Thanks for reading. If you would like to support me, please link me, digg me, or perhaps click on one of the sponsors of which you find legitimate interest.
Without further ado, here is the zip code table export.
zip_codes_2006.zip
Labels: 2006, Codes, Database, Export, Latitude, Longitude, mysql, Radius, Table, Zip, Zip Radius Search