ST_SPATIAL_REFERENCE_SYSTEMS catalog view
The ST_SPATIAL_REFERENCE_SYSTEMS catalog view contains information about registered spatial reference systems.
Each spatial reference system represents a coordinate system. The spatial reference system also includes factors to convert coordinates that use the coordinate system into values that the database can process with maximum efficiency. Db2® for i supports a single spatial reference system.
Authorization: None required.
The following table describes the columns in the view. The system name is ST_REFSYS. The schema is QSYS2.
| Column Name | System Column Name | Data Type | Description |
|---|---|---|---|
| SPATIAL_REFERENCE_SYSTEM_NAME | SRS_NAME | VARCHAR(128) | Name of the spatial reference system. This name is unique within the database. |
| SPATIAL_REFERENCE_SYSTEM_ID | SRS_ID | INTEGER | Numeric identifier of the spatial reference system. Each spatial reference system has a unique numeric identifier. |
| MIN_X | MIN_X | DOUBLE | Minimum possible value for X coordinates in the geometries to which this spatial reference system applies. |
| MAX_X | MAX_X | DOUBLE | Maximum possible value for X coordinates in the geometries to which this spatial reference system applies. |
| MIN_Y | MIN_Y | DOUBLE | Minimum possible value for Y coordinates in the geometries to which this spatial reference system applies. |
| MAX_Y | MAX_Y | DOUBLE | Maximum possible value for Y coordinates in the geometries to which this spatial reference system applies. |
| COORDSYS_NAME | COORD_NAME | VARCHAR(128) | Identifying name of the coordinate system on which this spatial reference system is based. |