15.10 - GEOMETRY_COLUMNS Table - Teradata Database

Teradata Database SQL Geospatial Types

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

Provides metadata for every table column defined as ST_Geometry.

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.

    To add geometry metadata for an ST_Geometry column to the GEOMETRY_COLUMNS table, you can use the SYSSPATIAL.AddGeometryColumn stored procedure.

    To drop geometry metadata from the GEOMETRY_COLUMNS table, you can use the SYSSPATIAL.DropGeometryColumn stored procedure.

    For details, see “AddGeometryColumn Stored Procedure” on page 216 and “DropGeometryColumn Stored Procedure” on page 220.