Tutorial: Experimenting with the spatial features

This tutorial allows you to experiment with some of the spatial features in SAP Sybase IQ. To do so, you will first load an ESRI shapefile into your sample database (demo.db) to give you some valid spatial data to experiment with.

The tutorial is broken into the following parts:

• Lesson 1: Install additional units of measure and spatial reference systems
  This lesson shows you how to use the sa_install_feature system procedure to install many predefined units of measure and spatial reference systems you will need later in this tutorial.
• Lesson 2: Download the ESRI shapefile data
  
• Lesson 3: Load the ESRI shapefile data
  This lesson shows you how to determine the columns in the ESRI shapefile and use that information to create a table that you will load the data into.
• Lesson 4: Query spatial data
  This lesson shows you how to use some of the spatial methods to query the data in a meaningful context. You will also learn how to calculate distances, which requires you to add units of measurement to your database.
• Lesson 5: Output spatial data to SVG
  In this lesson, you create an SVG document to view a multipolygon expressed in WKT. You can export geometries to SVG format for viewing in Interactive SQL or in an SVG-compatible application.
• Lesson 6: Project spatial data
  This lesson shows you how to project data into a spatial reference system that uses the flat-Earth model so that you can calculate area and distance measurements.