County-level EDGES Files
The US Census' TIGER/Line Shapefiles represent over 3,200 individual files with cartographical information for every county in every state of the US. The files are very large, and require a certain level of technical expertise to extract the embedded information out of the shapefile format the TIGER files are distributed in.
OpenPHI has pre-processed one of the most important files of the TIGER dataset for each county. We now distribute these files for free in a database-friendly (SQL) format for easy integration with your own systems and applications. See US Census Geocoding for more details.
Use for Free
These files are available at no charge, under the terms of the GNU Affero General Public License.
Disclaimer
Neither this website nor the files below are endorsed by the U.S. Census Bureau.
TIGER and TIGER/Line are registered trademarks of the U.S. Census Bureau; ZCTA is also a trademark of the U.S. Census Bureau.
"By law, Title 17 U.S.C., Section 105, copyright protection is not available for any work of the United States Government. Thus, the Government is precluded from copyrighting its publications. Consequently, you are free to reproduce census materials as you see fit. The U.S. Census Bureau requests that any repackaging of the TIGER/Line Shapefile data (and documentation) and other files accompanying it for distribution include a conspicuously placed statement to this effect on the product's cover, the first page of the website, or elsewhere of comparable visibility."
Use Case: Carrying county-level Census 2009 GIS data in your mobile device
The files below can be downloaded to mobile phones and similar portable devices. Once downloaded to the device, a simple viewer app, tied to the device's built-in GPS, can show the user where he is in relation to the Census file. Without querying any server-based geocoding / geolocation service.
All running locally in the device for faster performance, and with complete privacy. This type of local data can open the door to new services and applications that commercial users may find of interest.
Second version updated on 02/05/2010
This second version of the files include all alternate names for each street in every county. For example:
- "E Santa Fe Street" in Olathe, KS 66061 also goes by the name of "E 175th St"
- "US Hwy 56" and "W 199th St" and "W Morgan St" in Johnson county, Kansas refer to the same stretch of road
- In Autauga County, Abalama, a single TLID ('607454390') has 03 FULLNAME values assigned to it: 'S MEMORIAL DR'; 'US HWY 31'; and 'US HWY 82'
We generated these new files by cross-matching every single TLID in the EDGES file against the FEATNAMES file for every county in the country. Enjoy.
Technical Details
The files below are compatible with SQLite, a free, incredibly small, embeddable, fully capable SQL server. You can easily convert an entire SQLite database to an ASCII text file to export an SQLite database into other popular SQL database engines.
Please download SQLite Database Browser, a free multi-platform SQLite file browser
Select state of interest below:
