Contains information about each spatial reference system.
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. |
||