Syntax - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Geospatial Data Types

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K


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.