17.05 - Syntax - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1181-170K
ST_Geometry ( geomtype, xcoord, ycoord, [, zcoord ] [, asrid ] )
geomtype
A VARCHAR(80) for the type of spatial object to create.

The geomtype argument must be set to 'ST_POINT'.

xcoord
A FLOAT value for the x coordinate of the point. The value should be entered in floating point format.
ycoord
A FLOAT value for the y coordinate of the point. The value should be entered in floating point format.
zcoord
A FLOAT value for the z coordinate of the point, if the point is represented in 3D space. The value should be entered in floating point format.
If you specify a zcoord, you must also specify an asrid.
asrid
An optional INTEGER value for the spatial reference system identifier.

If this argument is omitted, the spatial reference system identifier is set to 0.

asrid is required if you also pass a zcoord argument.