Geospatial Metadata (SYSSPATIAL Database) | Teradata Vantage - 17.10 - Geospatial Metadata (SYSSPATIAL Database) - 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)

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.