16.20 - Syntax - 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)


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.