15.10 - ST_Geometry Constructor (BLOB Form) - Teradata Database

Teradata Database SQL Geospatial Types

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

Constructor method that returns a specified ST_Geometry value.

 

Argument …

Specifies …

wkb

a BLOB for the well-known binary representation of the spatial type.

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

For details on well-known binary formats, see “Well-Known Binary Representation” on page 198.

asrid

an optional INTEGER value for a spatial reference system identifier.

If this argument is omitted, the spatial reference system identifier is set to 0.

Use this form of ST_Geometry to construct all ST_Geometry types.

   USING (a INTEGER,
          b BLOB(60000))
   INSERT INTO sample_shapes VALUES (:a, NEW ST_Geometry(:b));