Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Spatial Data Support » Using spatial data » Tutorial: Experimenting with the spatial features


Lesson 2: Download the ESRI shapefile data

In this lesson, you will download an ESRI shapefile from the US Census website ([external link] 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.

 Download sample spatial data
  1. Create a local directory called c:\temp\massdata.

  2. Go to the following URL: [external link]

  3. On the right side of the page, in the State- and County-based Shapefiles dropdown, click Massachusetts, and then click Submit.

  4. On the left side of the page, click 5-Digit ZIP Code Tabulation Area (2002), and then click Download Selected Files.

  5. When prompted, save the zip file,, to c:\temp\massdata, and extract its contents. This creates a subdirectory called 25_MASSACHUSETTS containing another zip file called

  6. Extract the contents of to C:\temp\massdata.

    This unpacks five files, including an ESRI shapefile (.shp) you will use to load the spatial data into the database.

  7. Proceed to Lesson 3: Load the ESRI shapefile data.