Sunday, April 19, 2009

US Zip/City/County/State spatial data all ready for your SQL Server 2008… Just download, SQLCMD/import and go

CodePlex - US Census Data for SQL Server 2008

Project Description
This is a repository for US Census Data for SQL Server 2008 with spatial information. Some of the data that is and will be included will be for states, counties, cities, and zip codes. The project will be updated as the data is available in SQL Server 2008 format.

Please note that this tables contain geometry data types made for the "Flat Earth Model."

Data downloaded from http://www.census.gov and imported using the SQL Server 2008 Spatial Tools (http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx) by Morten Nielsen

Florida

FloridaCounties "

…”

US Census Data for SQL Server 2008 - State and County Table

“…

State Table
source code, 1785K, uploaded Today

County Table
source code, 14132K, uploaded Sat

Release Notes

The State and County Table are based on the 2000 Census Data and was normalized to the best of my knowledge. Please note that the the County table requires the State table. Both scripts contain the create and insert of the data.

The State geometry was derived by grouping all of the counties of each state using the User Defined Function found here: http://conceptdev.blogspot.com/2007/12/sql-server-2008-geometry-stunion.html

…”

US Census Data for SQL Server 2008 - Version 0.0.1.0

"...

State
source code, 1528K, uploaded Today - ...

County
source code, 7148K, uploaded Today -...

City
source code, 12258K, uploaded Today - ...

ZipCode
source code, 42531K, uploaded Today - ...

Release
Notes

Changes:
Added the ZipCode table
Modified all scripts
to include the spatial index
Compressed the files to a rar to make the files
smaller#

..."

A number of the podcasts I listen to have been covering SQL Server 2008’s spatial data type, so when I saw this I knew I had capture the data and mention it…

Update 4/20/2009 @ 7:15am:
There's now a City table/download (21860K) too... ;)
Update 4/20/2009 @ 4:20PM:
Added 0.0.1.0 block, which includes ZipCode data!

1 comment:

Unknown said...

Awesome gathering of US data. Is there a geography version of this data also, I can really get some use of this data but I was not able to convert it to geography with my knowledge so far.
Thanks