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

Creating a spatial reference system

Create a spatial reference system (SRS) that uses an existing one as a template on which to base your settings using the Create Spatial Reference System Wizard.

Prerequisites

You must have the MANAGE ANY SPATIAL OBJECT or CREATE ANY OBJECT system privilege.

The unit of measure that you want to associate with the SRS must already exist.

Context

When you create a spatial reference system, you use an existing one as a template on which to base your settings. Therefore, choose a spatial reference system that is similar to the one you want to create. Later, you can edit the settings.

Procedure

  1. In SQL Central, connect to the database.
  2. In the left pane, right-click Start of the navigation path Spatial Reference Systems Next navigation step New Next navigation step Spatial Reference System End of the navigation path.
  3. Select Let Me Choose From The List Of All Predefined Spatial Reference Systems, and then click Next.
  4. Follow the instructions in the wizard.
  5. When you create a spatial reference system based on an existing spatial reference system, you set the SRID value to be 1000000000 plus the Well Known value.
    Note When assigning a SRID, review the recommendations provided for ranges of numbers to avoid. These recommendations are found in the IDENTIFIED clause of the CREATE SPATIAL REFERENCE SYSTEM statement.
  6. The definition for the spatial reference system appears.
  7. If you are satisfied with the definition for the spatial reference system, click Finish.

Results

The new spatial reference system is added to the database.

Example

This example creates a spatial reference system based on an existing one.

  1. Connect to the database.

  2. In the left pane, right-click Start of the navigation path Spatial Reference Systems Next navigation step New Next navigation step Spatial Reference System End of the navigation path.

  3. Select Let Me Choose From The List Of All Predefined Spatial Reference Systems, and then click Next.

    The Choose A Spatial Reference System window appears.

  4. To create a spatial reference system based on the NAD83 spatial reference system, type NAD83. As you type a name or ID in the Choose A Predefined Spatial Reference System field, the list of spatial reference systems moves to display the spatial reference system you want to use as a template.

  5. Click NAD83 and then click Next.

    The Choose a Line Interpretation window appears.

  6. Click Round Earth to select it as the line interpretation.

  7. Specify NAD83custom in the Name field.

  8. When you create a spatial reference system based on an existing spatial reference system, you set the SRID value to be 1000000000 plus the Well Known value. For example, change the value in the Spatial Reference System ID field from 4269 to 1000004269.

    Note When assigning a SRID, review the recommendations provided for ranges of numbers to avoid. These recommendations are found in the IDENTIFIED clause of the CREATE SPATIAL REFERENCE SYSTEM statement.
  9. Click Next.

    The Specify a Comment window appears.

  10. Optionally, specify a description for the spatial reference system, and then click Next.

  11. Click Finish.

    The definition for the spatial reference system appears.

  12. Click Finish.

Next Steps

You can define the tables that use the spatial reference system.