17.10 - Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)
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