Zip Code Database with Spatial Data

[Jared Kuolt]

Hey all,

I've just committed a new version of The Zip Code Database Project on
SourceForge.

http://zips.sourceforge.net/

What is it? From the home page:
"The Zip Code Database project exists to provide US Zip Codes in their
entirety; latitude and longitude coordinates included! The download
includes an SQL file to dump directly into your database. It currently
works with MySQL, but it should be rather easy to port to another
database."

There is also a Python snippet on how to calculate distances.

Just thought I'd give you all a heads up. A little over a year ago I
almost purchased this data when I luckily stumbled upon census data
that carries all this information.

It's public domain so have all the fun you want with it.

Jared

[Kevin Dangoor]

Hi Jared,

Neat. Good to know this is available. I've used a database like this
(and I believe it was purchased), to do location-based lookups in the
past.

Now that you've mentioned it here, you can make an SQLObject class for
the data and move it into a csv file or something... then it can be
database agnostic and ready to plug in to TurboGears ;)

Kevin