ST_SPATIAL_REFERENCE_SYSTEMS consolidated view

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.

Note: Spatial data, spatial references systems, and spatial units of measure can be used only in the catalog store.

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: GEOGRAPHIC – This is for SRSs based on georeferenced coordinate systems with axes of latitude, longitude (and elevation). These SRSs are of type PLANAR or ROUND EARTH. PROJECTED – This is for SRSs based on georeferenced coordinate systems that do not have axes of latitude and longitude. These SRSs are of type PLANAR. ENGINEERING – This is for SRSs based on non-georeferenced coordinate systems. These SRSs are of type PLANAR. GEOCENTRIC – Unsupported. COMPOUND – Unsupported. VERTICAL – Unsupported. 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.