Definition - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ Geospatial Data Types

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K
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:
  • DATUM
  • GEOCCS
  • GEOGCS
  • PROJCS
  • PARAMETER
  • PRIMEM
  • PROJECTION
  • SPHEROID
  • UNIT

Some items are composed of other items in a nested structure.