Definition

Teradata Vantageā„¢ Geospatial Data Types

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K
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)
);
Column Description
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 include:
  • 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.