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

UPDATE
City table is now available!

Installation:
After downloading the files I recommend installing them through SQLCMD because the files are too big to open in an editor. The command line I use is:
sqlcmd -S ServerName -d DatabaseName -U UserName -P Password -i "FileName"
ie:
sqlcmd -S localhost -d MyDatabase -U MyUser -P MyPassword -i "c:\dbo.table.state.sql"

Sample Data:

States:
Florida.jpg

Counties:
FloridaCounties.jpg

Last edited Apr 20, 2009 at 4:15 AM by jstawski, version 10