Each row of the ST_SPATIAL_REFERENCE_SYSTEMS system view describes an SRS defined in the database. This view offers a slightly different amount of information than the SYSSPATIALREFERENCESYSTEM system view.
Column name  Data type  Description 

object_id  UNSIGNED BIGINT  For system use only. 
owner  UNSIGNED INT  The owner of the SRS. 
srs_name  CHAR(128)  The name of the SRS. 
srs_id  INTEGER  The numeric identifier (SRID) for the spatial reference system. 
srs_type  CHAR(11) 
The type of SRS as defined by the SQL/MM standard. Values can be one of:
If srs_type is empty, the type is unspecified. 
round_earth  CHAR(1)  Whether the SRS type is ROUND EARTH (Y) or PLANAR (N). 
axis_order  CHAR(12)  Describes how the database server interprets points with regards to latitude and longitude (for example when using the ST_Lat and ST_Long methods). For nongeographic spatial reference systems, the axis order is x/y/z/m. For geographic spatial reference systems, the default axis order is long/lat/z/m; lat/long/z/m is also supported. 
snap_to_grid  DOUBLE  Defines the size of the grid SQL Anywhere uses when performing calculations. 
tolerance  DOUBLE  Defines the precision to use when comparing points. 
semi_major_axis  DOUBLE  Distance from center of the ellipsoid to the equator for a ROUND EARTH SRS. 
semi_minor_axis  DOUBLE  Distance from center of the ellipsoid to the poles for a ROUND EARTH SRS. 
inv_flattening  DOUBLE 
The inverse flattening used for the ellipsoid in a ROUND EARTH SRS. This is a ratio created by the following equation: 
min_x  DOUBLE  The minimum x value allowed in coordinates. 
max_x  DOUBLE  The maximum x value allowed in coordinates. 
min_y  DOUBLE  The minimum y value allowed in coordinates. 
max_y  DOUBLE  The maximum y value allowed in coordinates. 
min_z  DOUBLE  The minimum z value allowed in coordinates. 
max_z  DOUBLE  The maximum z value allowed in coordinates. 
min_m  DOUBLE  The minimum m value allowed in coordinates. 
max_m  DOUBLE  The maximum m value allowed in coordinates. 
min_lat  DOUBLE  The minimum latitude value allowed for coordinates. 
max_lat  DOUBLE  The maximum latitude value allowed for coordinates. 
min_long  DOUBLE  The minimum longitude value allowed in coordinates. 
max_long  DOUBLE  The maximum longitude value allowed in coordinates. 
organization  LONG VARCHAR  The name of the organization that created the coordinate system used by the spatial reference system. 
organization_coordsys_id  INTEGER  The ID given to the coordinate system by the organization that created it. 
linear_unit_of_measure  CHAR(128)  The linear unit of measurement used by the SRS. 
angular_unit_of_measure  CHAR(128)  The angular unit of measurement used by the SRS. 
polygon_format  LONG VARCHAR  The orientation of the rings in a polygon. One of CounterClockwise, ClockWise, or EvenOdd. 
storage_format  LONG VARCHAR  Whether the data is stored in normalized format (Internal), unnormalized format (Original), or both (Mixed). 
definition  LONG VARCHAR  Additional definition settings. 
transform_definition  LONG VARCHAR  Transform definition settings for use when transforming data from this SRS to another. 
description  LONG VARCHAR  Description of the SRS. 
Discuter à propos de cette page dans DocCommentXchange.

Copyright © 2013, SAP AG ou société affiliée SAP  SAP Sybase SQL Anywhere 16.0 