You can get the free monthly updates database list from the following URL.
Now if only I can figure out how to import a CSV into Derby/Java DB, my weekend will be complete. The CSV zip code DB is way-useful stuff, dude. The one you want is the I hope this helps, Greg This will take you to a list of their geodata files. On the top of the page, in the header, there's a geodata link. Hopefully someone cached the data somewhere and can repost it.
Wed May 28, 09:00:00 AM Yeah, it looks like the post, link and download have been pulled. Anybody know where it is now? Thanks, Scott I clicked on the link at the top as Greg said on April 29, but there is no link there as he stated. Hi, I cannot seem to find the zip code file anymore. You can find the geo-location formula written in several programming languages free from the following URL.
Pando, I think the correct link for your geo-location application is,, right?Īwesome we need this shit all the time in data analysis I did not link directly to the download as I didn't want to leach their traffic too much. Go to the original article (link at the top) and then click on its "free US ZIP code centroid database" link. I hit all your links to their end and found none of this zipcode info you are touting. I wrote a small article on how to use CC-licensed data to create a geo-location application: Hook in the LinqToCSV project (via - LINQ to CSV library) and you've got a real winner. License, which requires that all updates must be released under the same The database and this README are copyright 2004 CivicSpace Labs, Inc.,Īnd are published under a Creative Commons Attribution-ShareAlike The database is believed to contain over 98% of the ZIP Codes in current Sources in the public domain, and thus be legal to redistribute. Theĭatabase is guaranteed to exclusively contain information gathered from Lines of data that can be viewed as spreadsheet, or imported to database server. SQL CREATE and multiple-row INSERT statements for SQL Server and MySQL.
Was added using cartographic data sets from . Download PDF files 10.62 MB - download size (zipped file) US Zip Codes can be downloaded in the following formats: SQL. This database was composed using ZIP code gazetteers from the US Censusīureau from 19, augmented with additional ZIP code informationįrom the Census Bureau’s TIGER/Line 2003 data set. (offset from GMT), and daylight savings time flag (1 if DST is observed With columns for ZIP code, city, state, latitude, longitude, timezone The database is in comma separated value format, The ZIP code database contained in ‘zipcode.csv’ contains 43204 ZIPĬodes for the continental United States, Alaska, Hawaii, Puerto Rico,Īnd American Samoa. Since then, I’ve gotten about an email a month from people looking for the database.įor future reference, the free US ZIP code centroid database is now hosted here on the Mapping Hacks site. For a while, it was hosted on their site, but at some point the link was broken. "About four years ago, Civic Space Labs commissioned me to provide them with a freely available database of US ZIP code centroids. If not available this field is set to 0.Mapping Hacks - CivicSpace ZIP Code Database The average (mean) household income for the record (based on US Census ZCTAs) using the latest 5 year estimates from the American Community Survey. The total number of households for the record (based on US Census ZCTAs) using the latest 5 year estimates from the American Community Survey. The total population for the record (based on US Census ZCTAs) using the latest 2014 population estimates. The type of record: Standard, Unique (used for a single high-volume address), PO Box or Military. The WGS83 longitude coordinate for the center point of the zip code. The WGS83 latitude coordinate for the center point of the zip code. The full-length name of the state for the record.
The 2 character state abbreviation for the record as defined in ISO 3166-2. The name of the county or local government area for the record. The primary city associated with each record, as designated by the USPS. This field contains all 5-digit zip codes currently in active use by the USPS. It includes all Standard, Unique, PO Box and Military zip codes coded in line with USPS standards.
The data contains a total of 41,850 unique records and provides full coverage of all 50 states, the District of Columbia, and outlying US territories (American Samoa, Guam, Northern Mariana Islands, Puerto Rico and the Virgin Islands).