Geospatial Metadata (SYSSPATIAL Database) | Teradata Vantage - 17.10 - Geospatial Metadata (SYSSPATIAL Database) - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

The SYSSPATIAL database contains two tables that provide additional information about columns of type ST_Geometry and the spatial reference systems. These tables follow the definitions provided by the SQL/MM Spatial standard.

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.