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 » Getting started with spatial data

 

Creating a spatial reference system (Sybase Central)

You can 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

DBA authority or a member of the SYS_SPATIAL_ADMIN_ROLE group.

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

Context and remarks

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

 Create a spatial reference system (Sybase Central)
  1. In Sybase Central, connect to the database as a user with DBA authority, or as a member of the SYS_SPATIAL_ADMIN_ROLE group.

  2. In the left pane, right-click Spatial Reference Systems » New » Spatial Reference System.

  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.

Next

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

Example

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

  1. Connect to the database as a user with DBA authority, or as a member of the SYS_SPATIAL_ADMIN_ROLE group.

  2. In the left pane, right-click Spatial Reference Systems » New » Spatial Reference System.

  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.

    The Choose A Spatial Reference System page from the Create Spatial Reference System Wizard.
  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.

    The Choose A Line Interpretation page from the Create Spatial Reference System Wizard.
  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.


 See also