15.10 - Geospatial Metadata - Teradata Database

Teradata Database SQL Geospatial Types

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

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

Provides metadata for every table column defined as ST_Geometry.

To add geometry metadata to the GEOMETRY_COLUMNS table for a new ST_Geometry column, you can use the AddGeometryColumn stored procedure. To drop geometry metadata from the GEOMETRY_COLUMNS table, you can use the DropGeometryColumn stored procedure.

SPATIAL_REF_SYS

Contains information about each spatial reference system.

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

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

For details, see “Metadata (SYSSPATIAL Database)” on page 212.