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) |
he 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 non-geographic 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 used 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: 1/f = (semi-major-axis) / (semi-major-axis - semi-minor-axis) |
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. |