US Zip/City/County/State spatial data all ready for your SQL Server 2008… Just download, SQLCMD/import and go
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
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 www.census.gov and imported using the SQL Server 2008 Spatial Tools (www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx>) by Morten Nielsen
…
”
…”
US Census Data for SQL Server 2008 – State and County Table
“…
source code, 1785K, uploaded Today …
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: <conceptdev.blogspot.com/2007/12/sql-server-2008-geometry-stunion.html>
…”
US Census Data for SQL Server 2008 – Version 0.0.1.0
“…
source code, 1528K, uploaded Today – …
source code, 7148K, uploaded Today -…
source code, 12258K, uploaded Today – …
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!