16.20 - Geospatial Metadata - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Geospatial Data Types

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

SQL/MM Spatial defines two tables (or views) that provide additional information about columns of type ST_Geometry and the spatial reference systems.

Table Description
GEOMETRY_COLUMNS Table Provides metadata for every table column defined as ST_Geometry.

Teradata provides stored procedures to add and drop geometry metadata in this table. For more information on these procedures, see AddGeometryColumn Stored Procedure, AddGeometryColumn_3D Stored Procedure, and DropGeometryColumn Stored Procedure

SPATIAL_REF_SYS Table Contains information about each spatial reference system.

During installation, the Database Initialization Program (DIP) utility executes a script that populates the SPATIAL_REF_SYS table.

For more information on DIP, see Teradata Vantageā„¢ - Database Utilities , B035-1102 .

The GEOMETRY_COLUMNS and SPATIAL_REF_SYS tables and associated stored procedures are defined in the SYSSPATIAL database.

For more information , see Geospatial Metadata (SYSSPATIAL Database).