15.10 - SPATIAL_REF_SYS Table - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

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:

  • DATUM
  • GEOCCS
  • GEOGCS
  • PROJCS
  • PARAMETER
  • PRIMEM
  • PROJECTION
  • SPHEROID
  • UNIT
  • Some items are composed of other items in a nested structure.