In this lesson, you will download an ESRI shapefile from the US Census website ( www2.census.gov). The shapefile you download represents the Massachusetts 5-digit code zip code information used during the 2002 census tabulation. Each zip code area is treated as either a polygon or multipolygon.
Create a local directory called c:\temp\massdata.
Go to the following URL: http://www2.census.gov/cgi-bin/shapefiles2009/national-files
On the right side of the page, in the State- and County-based Shapefiles dropdown, click Massachusetts, and then click Submit.
On the left side of the page, click 5-Digit ZIP Code Tabulation Area (2002), and then click Download Selected Files.
When prompted, save the zip file, multiple_tiger_files.zip, to c:\temp\massdata, and extract its contents. This creates a subdirectory called 25_MASSACHUSETTS containing another zip file called tl_2009_25_zcta5.zip.
Extract the contents of tl_2009_25_zcta5.zip to C:\temp\massdata.
This unpacks five files, including an ESRI shapefile (.shp) you will use to load the spatial data into the database.
Proceed to Lesson 3: Load the ESRI shapefile data.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|