15.10 - ST_WKTToSQL - Teradata Database

Teradata Database SQL Geospatial Types

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

Returns a specified ST_Geometry value.

 

Argument …

Specifies …

awkt

a geometry value specified in the well-known text (WKT) format.

The data type of awkt is CLOB.

The maximum size of awkt is approximately 16 MB (the exact maximum is 16 MB ‑ 1 KB), allowing for a representation of approximately one million points.

For details on WKT formats, see “Well-Known Text Representation” on page 194.

Returns an ST_Geometry value.

All ST_Geometry types.

Teradata Database provides this method because it is in the SQL/MM Spatial standard, where it is defined to implement transform functionality that allows importing the ST_Geometry type to the server.

For best performance, use a constructor method instead of ST_WKTToSQL to construct an instance of ST_Geometry.

   USING (a INTEGER,
          b CLOB(60000))
   INSERT INTO sample_shapes VALUES (:a, 
      new ST_Geometry('POINT(1 2)').ST_WKTToSQL(:b));