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);
Syntax Elements
- 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:
- DATUM
- GEOCCS
- GEOGCS
- PROJCS
- PARAMETER
- PRIMEM
- PROJECTION
- SPHEROID
- UNIT