The DB2GSE.SPATIAL_REF_SYS catalog view
Query the DB2GSE.SPATIAL_REF_SYS catalog view to retrieve information about spatial reference systems.
When you create a spatial reference system, IBM® Spatial Support for Db2 for z/OS® registers it by recording its identifier and information related to it in a catalog table.
The following table describes the columns from the catalog table
that comprise the DB2GSE.SPATIAL_REF_SYS catalog view.
| Name | Data Type | Nullable? | Content |
|---|---|---|---|
| SRID | INTEGER | No | User-defined identifier for this spatial reference system. |
| SR_NAME | VARCHAR(128) | No | Name of this spatial reference system. |
| CSID | INTEGER | No | Numeric identifier for the coordinate system that underlies this spatial reference system. |
| CS_NAME | VARCHAR(128) | No | Name of the coordinate system that underlies this spatial reference system. |
| AUTH_NAME | VARCHAR(128) | Yes | Name of the organization that sets the standards for this spatial reference system. |
| AUTH_SRID | INTEGER | Yes | The identifier that the organization specified in the AUTH_NAME column assigns to this spatial reference system. |
| SRTEXT | VARCHAR(2048) | No | Annotation text for this spatial reference system. |
| FALSEX | DOUBLE | No | A number that, when subtracted from a negative X coordinate value, leaves a non-negative number (that is, a positive number or a zero). |
| FALSEY | DOUBLE | No | A number that, when subtracted from a negative Y coordinate value, leaves a non-negative number (that is, a positive number or a zero). |
| XYUNITS | DOUBLE | No | A number that, when multiplied by a decimal X coordinate or a decimal Y coordinate, yields an integer that can be stored as a 32–bit data item. |
| FALSEZ | DOUBLE | No | A number that, when subtracted from a negative Z coordinate value, leaves a non-negative number (that is, a positive number or a zero). |
| ZUNITS | DOUBLE | No | A number that, when multiplied by a decimal Z coordinate, yields an integer that can be stored as a 32–bit data item. |
| FALSEM | DOUBLE | No | A number that, when subtracted from a negative measure, leaves a non-negative number (that is, a positive number or a zero). |
| MUNITS | DOUBLE | No | A number that, when multiplied by a decimal measure, yields an integer that can be stored as a 32–bit data item. |