The DB2GSE.ST_COORDINATE_SYSTEMS catalog view

Query the DB2GSE.ST_COORDINATE_SYSTEMS catalog view to retrieve information about registered coordinate systems.

IBM® Spatial Support for Db2 for z/OS® automatically registers coordinate systems in the IBM Spatial Support for Db2 for z/OS catalog at the following times:

When you enable a database for spatial operations.
When users define additional coordinate systems to the database.

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

Table 1. Columns in the DB2GSE.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 representation 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.