Pretty strong updates today. First off, Jonathan Colson was kindly enough to provide a distance calculation function for Excel. (http://zips.sourceforge.net/#dist_calc)
Peter Santoro has graciously donated a bash script that converts from CSV to SQL Inserts. It is generic SQL and should work in every SQL-compliant database. (http://zips.sourceforge.net/mkzipsql.sh)
Finally, I've added a FAQ to the site.
Thanks to Rob Sterner we have the distance calculation written out in Java! See it here: http://zips.sourceforge.net/#dist_calc
The Zip Code Database Project has now ported all US Zip Code data (with latitude and longitude coordinates) to the comma-separated-values file format. This should greatly increase the adoptability for anyone in need of this data.
The two releases today are identical except one is in the zip format, the other in gzip.
Pick which one fits you best.
Have a great day!
After a while of stagnation, the Zip Code Database Project has been revamped. The Zip Code Database Project exists to provide accurate US Zip Code data including city/state names and spatial data (useful for distance calculation). Please take a look and spread the word!
The first MySQL supported release by the The Zip Code Database Project. This inserts all US Zip Codes with latitude and longitude into a MySQL database. Included is a distance calculator. ENJOY!
The Zip Code Database project has released it's first product for PHP5 and SQLite. It is deemed stable, even though PHP5 is technically not stable itself.