Creating a Spatial Reference System

Create a spatial reference system on a specified resource.

Prerequisites
Database Version Spatial Reference System Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • You are a member of the SYS_SPATIAL_ADMIN_ROLE group
SAP Sybase IQ 16.0 You must have one of:
  • MANAGE ANY SPATIAL OBJECT system privilege
  • CREATE ANY OBJECT system privilege
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Schema Objects > Spatial Support, and then select Spatial Reference Systems.
  3. Click the arrow next to Spatial Reference Systems and select New.
    The Create Spatial Reference System Wizard appears.
  4. On the Welcome page of the wizard, specify:
    Option Description
    Select a resource on which the spatial reference system will be created Select a resource from the list.
    (Multiplex only) Select a multiplex server on which the spatial reference system will be created Select a multiplex server from the list.
    How would you like to choose the spatial reference system? Indicate the method to locate the predefined spatial reference system.
  5. Click Next.
  6. Select either a predefined spatial referenced system, or well-known text.
    Option Description
    If you select a predefined spatial reference system
    • Browse the list and select a system.
    If you select well-known text
    • Paste the well-known text definition and click Validate. The Matching Predefined SRS page appears.
    • Browse the list and select a system.
  7. Click Next.
  8. On the Line Interpretation page:
    Option Description
    Line interpretation method Valid values are:
    • Round earth – Geographical or projected spatial reference systems.
    • Planar – Projected spatial reference systems.
    Name Specify a unique name for the spatial reference system to a maximum of 128 characters.
    Spatial reference system ID Specify a unique ID for the spatial reference system.
    To reduce the possibility of choosing a spatial reference system ID reserved by a defining authority such as OGC or other vendors, do not choose numbers in ranges:
    • 0-32,767 (reserved by EPSG)
    • 2,147,483,547-2,147,483,647 (reserved by SAP)
  9. Click Next.
  10. (Optional) On the Comment page, specify a comment for the spatial reference system.
  11. Click Finish.
Parent topic: Spatial Support
Related concepts
Spatial Units of Measure
Related tasks
Deleting a Spatial Reference System
Generating Spatial Reference System DDL Commands
Viewing or Modifying Spatial Reference System Properties
Deleting a Spatial Unit of Measure
Generating Spatial Unit of Measure DDL Commands
Viewing or Modifying Spatial Unit of Measure Properties
Authenticating a Login Account for a Managed Resource
Related reference
Spatial Support Privilege Summary