16.20 - Extended Well-Known Text Format - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Geospatial Data Types

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1181-162K
Language
English (United States)

The EWKT format simply prepends an SRID identifier to the existing WKT formats.

Format

SRID=srid_value;WKT

srid_value
An integer value greater than or equal to zero.

Usage Notes

As is the case for WKT, spaces are ignored.

To import or export geospatial data in EWKT format, you must use one of the "SRID" transform groups included with Teradata Database. For more information on transform groups, see ST_Geometry Type Transforms.

Examples: EWKT Format for Geospatial Data

The following are valid geospatial data in EWKT format.

SRID=12;POINT(10 20)
SRID=35234;LINESTRING(10 20, 40 50)
SRID   =  112   ;   POINT(10 20)