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

CodePlexUS 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 2008State 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 2008Version 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!

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

comments powered by Disqus