State and County Table

Rating: No reviews yet
Downloads: 3856
Released: Apr 18, 2009
Updated: Apr 20, 2009 by jstawski
Dev status: Alpha Help Icon

Recommended Download

Source Code State Table
source code, 1785K, uploaded Apr 19, 2009 - 1518 downloads

Other Available Downloads

Source Code County Table
source code, 14132K, uploaded Apr 18, 2009 - 1476 downloads
Source Code City Table
source code, 21860K, uploaded Apr 20, 2009 - 862 downloads

Release Notes

The State, County, and City Table are based on the 2000 Census Data and was normalized to the best of my knowledge. Please note that the the County and City table require the State table. All 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

Please note that the geom column of the State table which was derived from the union of all the counties is not as precise as I would like it to be. This results in a problem when trying to create a geography object from the geometry column.

Reviews for this release

No reviews yet for this release.