15.10 - ST_Geometry Constructor (ST_Point Form) - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Returns an ST_Geometry value that represents a 2D or 3D ST_Point.

 

Argument …

Specifies …

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.

Note: 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.

Note: asrid is required if you also pass a zcoord argument.

Use this constructor to construct an ST_Geometry that represents a 2D or 3D ST_Point.

   INSERT INTO sample_shapes 
   VALUES (1101, NEW ST_Geometry('ST_POINT', 1E1, 2E1));
   SELECT NEW ST_Geometry('ST_Point', 10.0, 20.0);   
   SELECT NEW ST_Geometry('ST_Point', 10.0, 20.0, 1699);
   SELECT NEW ST_Geometry('ST_Point', 10.0, 20.0, 5.0, 1699);