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.GEOMETRY_COLUMNS, FALLBACK (
  F_TABLE_CATALOG CHARACTER VARYING(256) CHARACTER SET LATIN NOT NULL,
  F_TABLE_SCHEMA CHARACTER VARYING(128) CHARACTER SET UNICODE NOT NULL,
  F_TABLE_NAME CHARACTER VARYING(128) CHARACTER SET UNICODE NOT NULL,
  F_GEOMETRY_COLUMN CHARACTER VARYING(128) CHARACTER SET UNICODE NOT NULL,
  COORD_DIMENSION INTEGER,
  SRID INTEGER REFERENCES SPATIAL_REF_SYS,
  GEOM_TYPE CHARACTER VARYING(30) CHARACTER SET LATIN NOT NULL,
  UxMin FLOAT,
  UyMin FLOAT,
  UxMax FLOAT,
  UyMax FLOAT,
  CONSTRAINT GC_PK PRIMARY KEY
    (F_TABLE_CATALOG, F_TABLE_SCHEMA, F_TABLE_NAME, F_GEOMETRY_COLUMN)
);

Syntax Elements

F_TABLE_CATALOG
Catalog name (can be "" for Teradata).
F_TABLE_SCHEMA
Database name.
F_TABLE_NAME
Table name.
F_GEOMETRY_COLUMN
Column name that is declared as ST_Geometry.
COORD_DIMENSION
Number of coordinates used in the ST_Geometry values, usually corresponding to the number of dimensions in the spatial reference system.
SRID
Spatial reference system identifier used for the coordinate geometry in this table. It is a foreign key reference to the SPATIAL_REF_SYS table.
GEOM_TYPE
Geometry type that this column represents. Valid values:
  • GEOMETRY
  • POINT
  • LINESTRING
  • POLYGON
  • GEOMETRYCOLLECTION
  • MULTIPOINT
  • MULTILINESTRING
  • MULTIPOLYGON
  • GEOSEQUENCE
UxMin
Lower left X coordinate of the MBR for the universe that includes all values that this column might hold.
UyMin
Lower left Y coordinate of the MBR for the universe that includes all values that this column might hold.
UxMax
Upper right X coordinate of the MBR for the universe that includes all values that this column might hold.
UyMax
Upper right Y coordinate of the MBR for the universe that includes all values that this column might hold.