SYSGEO.ST_COORDINATE_SYSTEMS catalog view

Use the SYSGEO.ST_COORDINATE_SYSTEMS catalog view to retrieve information about coordinate systems.

The SYSGEO.ST_COORDINATE_SYSTEMS view lists predefined coordinate systems for informational purposes, and can be used as a reference when you create a custom spatial reference system.

For a description of columns in this view, see the following table.

Table 1. Columns in the SYSGEO.ST_COORDINATE_SYSTEMS catalog view
Name	Data type	Nullable?	Content
COORDSYS_NAME	VARCHAR(128)	No	Name of this coordinate system. The name is unique within the database.
COORDSYS_TYPE	VARCHAR(128)	No	Type of this coordinate system: PROJECTED Two-dimensional. GEOGRAPHIC Three-dimensional. Uses X and Y coordinates. GEOCENTRIC Three-dimensional. Uses X, Y, and Z coordinates. UNSPECIFIED Abstract or non-real world coordinate system. The value for this column is obtained from the DEFINITION column.
DEFINITION	VARCHAR(2048)	No	Well-known text format of the definition of this coordinate system.
ORGANIZATION	VARCHAR(128)	Yes	Name of the organization (for example, a standards body such as the European Petrol Survey Group, or ESPG) that defined this coordinate system. This column is null if the ORGANIZATION_COORDSYS_ID column is null.
ORGANIZATION_ COORDSYS_ID	INTEGER	Yes	Numeric identifier assigned to this coordinate system by the organization that defined the coordinate system. This identifier and the value in the ORGANIZATION column uniquely identify the coordinate system unless the identifier and the value are both null. If the ORGANIZATION column is null, then the ORGANIZATION_COORDSYS_ID column is also null.
DESCRIPTION	VARCHAR(256)	Yes	Description of the coordinate system that indicates its application.