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

Teradata Vantageā„¢ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)
ST_Geometry ( geomtype, xcoord, ycoord, [, zcoord ] [, asrid ] )

Syntax Elements

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.