When you enable a database for spatial operations, DB2 Spatial Extender
registers the coordinate systems that you can use in a catalog table.
Selected columns from this table comprise the
DB2GSE.COORD_REF_SYS catalog view, which is described in Table 34.
Table 34. Columns in the DB2GSE.COORD_REF_SYS catalog view
| Name | Data Type | Nullable? | Content |
|---|---|---|---|
| SCID | INTEGER | No | Unique numeric identifier for this coordinate system. |
| SC_NAME | VARCHAR(64) | No | Name of this coordinate system. |
| AUTH_NAME | VARCHAR(256) | Yes | Name of the organization that compiled this coordinate system adheres to; for example, the European Petroleum Survey Group (EPSG). |
| AUTH_SRID | INTEGER | Yes | A numeric identifier assigned to this coordinate system by the organization specified in the AUTH_NAME column. |
| DESC | VARCHAR(256) | Yes | Description of this coordinate system. |
| SRTEXT | VARCHAR(2048) | No | Annotation text for this coordinate system. |