This is so cool, if we could get a similar data made available for GCC my life would be so easier 😀
[via] Geeks are Sexy
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
source code, 1785K, uploaded Today …
source code, 14132K, uploaded Sat …
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
source code, 1528K, uploaded Today – …
source code, 7148K, uploaded Today -…
source code, 12258K, uploaded Today – …
source code, 42531K, uploaded Today – …
Added the ZipCode table
Modified all scripts
to include the spatial index
Compressed the files to a rar to make the files
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!