Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 17 » SQL Anywhere Server - Spatial Data Support » Spatial data

Tutorial: Experimenting with the spatial features

This tutorial allows you to experiment with the spatial features.

Prerequisites

To perform this tutorial, you must have the following privileges:

  • MANAGE ANY SPATIAL OBJECT system privilege
  • CREATE TABLE system privilege
  • WRITE FILE system privilege
  • SELECT privilege on the GROUPO.SpatialContacts table
  1. Lesson 1: Install additional units of measure and spatial reference systems
    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.
  2. Lesson 2: Download the ESRI shapefile data
    Download an ESRI shapefile from the US Census website.
  3. Lesson 3: Load the ESRI shapefile data
    Determine the columns in the ESRI shapefile and use that information to create a table that you will load the data into.
  4. Lesson 4: Query spatial data
    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.
  5. Lesson 5: Output spatial data to SVG
    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.
  6. Lesson 6: Project spatial data
    Project data into a spatial reference system that uses the flat-Earth model so that you can calculate area and distance measurements.