CREATE TABLE SYSSPATIAL.SPATIAL_REF_SYS, FALLBACK ( SRID INTEGER NOT NULL PRIMARY KEY, AUTH_NAME CHARACTER VARYING(256) CHARACTER SET LATIN, AUTH_SRID INTEGER, SRTEXT CHARACTER VARYING(2048) CHARACTER SET LATIN) PRIMARY INDEX (AUTH_SRID);
| Column | Description | ||
|---|---|---|---|
| SRID | Spatial reference system identifier. | ||
| AUTH_NAME | Name of the standard or standards body that is being cited for this reference system. | ||
| AUTH_SRID | Identifier of the spatial reference as defined by the authority cited in AUTH_NAME. The table specifies a nonunique primary index (NUPI) on this column. |
||
| SRTEXT | WKT representation of a geographic (latitude-longitude), a projected (X, Y), or a geocentric (X, Y, Z) coordinate system. The coordinate system is composed of several items, where each item has a keyword in uppercase followed by the defining, comma-delimited, parameters of the item in brackets. The list of keywords is:
Some items are composed of other items in a nested structure. |