17.10 - Additional Transform Groups for ST_Geometry Data - 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)
To accommodate importing and exporting geospatial data from and to other types and formats, Vantage provides other transform groups for the ST_Geometry type.
  • To override the default CLOB/WKT transform for geospatial data for the current session, use the SET TRANSFORM GROUP FOR TYPE statement.
  • To override the default CLOB/WKT transform for geospatial data for a particular user or profile, specify the transform to use in the CREATE/MODIFY USER and CREATE/MODIFY PROFILE statements.
For more information about these SQL statements, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

The following table lists the transform groups that are available for the ST_Geometry type.

Transform Group Import/Export Type Default Format
ST_WellKnownText CLOB

(Latin character set)

Yes WKT

This corresponds to the ST_GEOMETRY_IO transform group in previous database releases.

ST_WellKnownBinary BLOB No Well-known binary (WKB)
TD_GEO_VARCHAR VARCHAR(64000)

(Latin character set)

No WKT
TD_GEO_VARBYTE VARBYTE(64000) No WKB
ST_WellKnownTextSRID CLOB

(Latin character set)

No Extended WKT (WKT and SRID)
ST_WellKnownBinarySRID BLOB No Extended WKB (WKB and SRID)
TD_GEO_VARCHAR_SRID VARCHAR(64000)

(Latin character set)

No Extended WKT
TD_GEO_VARBYTE_SRID VARBYTE(64000) No Extended WKB

For more information on the WKT, WKB, and extended formats, see Geospatial Data Formats.