Purpose
The information_schema.ST_SPATIAL_REFERENCE_SYSTEMS view provides information about the current spatial reference coordinate system supported by the system.
Note
This view is introduced since OceanBase Database V3.2.4.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SRS_ID | bigint(20) unsigned | NO | The ID of the spatial coordinate system. |
| SRS_NAME | varchar(128) | NO | The name of the spatial coordinate system. |
| ORGANIZATION | varchar(256) | YES | The organization name of the coordinate system that the spatial coordinate system is based on. |
| ORGANIZATION_COORDSYS_ID | bigint(20) unsigned | YES | The organization ID of the coordinate system that the spatial coordinate system is based on. |
| DEFINITION | varchar(4096) | NO | The definition of the spatial coordinate system, which is an SRS WKT string in the Open Geospatial Consortium (OGC) format. |
| DESCRIPTION | varchar(2048) | YES | The description of the spatial coordinate system. For the inherent coordinate system of the system, the value is NULL. |