ST_Geometry Constructor Syntax (VARCHAR Form) - Advanced SQL Engine - Teradata Database

Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
ufo1590694251930.ditamap
dita:ditavalPath
ufo1590694251930.ditaval
dita:id
B035-1181
lifecycle
previous
Product Category
Teradata Vantageā„¢
ST_Geometry ( wkt [, asrid ] )

Syntax Elements

wkt
A VARCHAR(64000) for the well-known text representation of the spatial type. The size of the wkt argument cannot exceed 64000 bytes.
When a well-known text representation is larger than 64000 bytes, use the CLOB version of the ST_Geometry constructor method.
For more information on well-known text formats, see Well-Known Text Format.
asrid
An optional INTEGER value for a spatial reference system identifier.
If this argument is omitted, the spatial reference system identifier is set to 0.