DB2GSE.SPATIAL_REF_SYS catalog view
Use the DB2GSE.SPATIAL_REF_SYS catalog view to obtain information about spatial reference systems that are registered in Db2® Spatial Extender .
Important: This catalog view has been
deprecated and replaced by the DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS catalog view.
For a description of columns in this view, see the following table.
| Name | Data Type | Nullable? | Content |
|---|---|---|---|
| SRID | INTEGER | No | User-defined identifier for this spatial reference system. |
| SR_NAME | VARCHAR(64) | 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(64) | No | Name of the coordinate system that underlies this spatial reference system. |
| AUTH_NAME | VARCHAR(256) | 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 | FLOAT | 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 | FLOAT | 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 | FLOAT | No | A number that, when multiplied by a decimal X coordinate or a decimal Y coordinate, yields an integer. |
| FALSEZ | FLOAT | 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 | FLOAT | No | A number that, when multiplied by a decimal Z coordinate, yields an integer. |
| FALSEM | FLOAT | No | A number that, when subtracted from a negative measure, leaves a non-negative number (that is, a positive number or a zero). |
| MUNITS | FLOAT | No | A number that, when multiplied by a decimal measure, yields an integer. |