Monday, April 28, 2008

Free US ZIP Code Database as CSV

Mapping Hacks - CivicSpace ZIP Code Database

"About four years ago, Civic Space Labs commissioned me to provide them with a freely available database of US ZIP code centroids. For a while, it was hosted on their site, but at some point the link was broken. Since then, I’ve gotten about an email a month from people looking for the database.

For future reference, the free US ZIP code centroid database is now hosted here on the Mapping Hacks site. From the README:

The ZIP code database contained in ‘zipcode.csv’ contains 43204 ZIP
codes for the continental United States, Alaska, Hawaii, Puerto Rico,
and American Samoa. The database is in comma separated value format,
with columns for ZIP code, city, state, latitude, longitude, timezone
(offset from GMT), and daylight savings time flag (1 if DST is observed
in this ZIP code and 0 if not).

This database was composed using ZIP code gazetteers from the US Census
Bureau from 1999 and 2000, augmented with additional ZIP code information
from the Census Bureau’s TIGER/Line 2003 data set. Timezone information
was added using cartographic data sets from nationalatlas.gov. The
database is guaranteed to exclusively contain information gathered from
sources in the public domain, and thus be legal to redistribute.

The database is believed to contain over 98% of the ZIP Codes in current
use in the United States. ...

...

The database and this README are copyright 2004 CivicSpace Labs, Inc.,
and are published under a Creative Commons Attribution-ShareAlike
license, which requires that all updates must be released under the same
license....

..."

This could come in handy...

Hook in the LinqToCSV project (via WindowsClient.net - LINQ to CSV library) and you've got a real winner.

 

Related Past Post XRef:
The Code Project - ZIP Code Utility
USZip Web Service by WebServiceX.Net

13 comments:

  1. I wrote a small article on how to use CC-licensed data to create a geo-location application:

    ReplyDelete
  2. I hit all your links to their end and found none of this zipcode info you are touting. Bummer. I could have used them.

    ReplyDelete
  3. Go to the original article (link at the top) and then click on its "free US ZIP code centroid database" link. That links directly to the Zip dnowload...

    I did not link directly to the download as I didn't want to leach their traffic too much...

    ReplyDelete
  4. Pando, I think the correct link for your geo-location application is, http://ergo.rydlr.net/?p=35, right?

    ReplyDelete
  5. awesome we need this shit all the time in data analysis

    ReplyDelete
  6. You can find the geo-location formula written in several programming languages free from the following URL.

    http://www.zipcodeworld.com/developers.htm

    ReplyDelete
  7. Hi, I cannot seem to find the zip code file anymore. I clicked on the link at the top as Greg said on April 29, but there is no link there as he stated. So it must have moved again. Anybody know where it is now?

    Thanks,
    Scott

    ReplyDelete
  8. @Scott,
    Yeah, it looks like the post, link and download have been pulled.

    Hopefully someone cached the data somewhere and can repost it.

    If/when I find it I'll update this post.

    Thanks for pointing out it's gone....

    ReplyDelete
  9. Okay, found the data...

    On the top of the page, in the header, there's a geodata link.

    This will take you to a list of their geodata files.

    The one you want is the http://mappinghacks.com/data/zipcode.zip

    I hope this helps,
    Greg

    ReplyDelete
  10. The CSV zip code DB is way-useful stuff, dude. Thanks much for putting this out there. Now if only I can figure out how to import a CSV into Derby/Java DB, my weekend will be complete...

    ReplyDelete
  11. You can get the free monthly updates database list from the following URL.

    http://www.zipcodeworld.com/zipcodefree.htm

    ReplyDelete
  12. Here is a free one that is kept up-to-date. http://greatdata.com (see free menu at top)

    ReplyDelete
  13. better yet, here is the direct link: http://greatdata.com/free-zip-code-database

    ReplyDelete

NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...

ALL comments are moderated. I will review every comment before it will appear on the blog.

Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...

I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...

Please see my comment policy for more information if you are interested.

Thanks,
Greg

PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...