Syntax

Teradata Vantageā„¢ Geospatial Data Types

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K


catalog_name
The name of the catalog.

The value can be an empty string ('') for Teradata.

schema_name
The name of the database in which the table specified by table_name is defined.
table_name
The name of the table that has a column defined as an ST_Geometry type.
geom_column_name
The name of the column in the table specified by table_name that is defined as an ST_Geometry type.
srid
The spatial reference system identifier used for the coordinate geometry in the table_name table.
geom_type
The geometry type that column specified by geom_column_name represents.

Valid values include:

  • 'ST_Geometry'
  • 'ST_Point'
  • 'ST_LineString'
  • 'ST_Polygon'
  • 'ST_GeometryCollection'
  • 'ST_MultiPoint'
  • 'ST_MultiLineString'
  • 'ST_MultiPolygon'
  • 'GeoSequence'
UxMin_v
The lower left X coordinate of the MBR of the universe for all values in the new ST_Geometry column.
UyMin_v
The lower left Y coordinate of the MBR of the universe for all values in the new ST_Geometry column.
UxMax_v
The upper right X coordinate of the MBR of the universe for all values in the new ST_Geometry column.
UyMax_v
The upper right Y coordinate of the MBR of the universe for all values in the new ST_Geometry column.