15.10 - ST_Dimension - Teradata Database

Teradata Database SQL Geospatial Types

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

Returns the dimension of the ST_Geometry type.

Returns a SMALLINT value:

  • 0, for a 0-dimensional geometry
  • 1, for a 1D geometry
  • 2, for a 2D geometry
  • -1, if the input geometry is empty
  • All ST_Geometry types.

       SELECT skey 
       FROM sample_shapes
       WHERE shape.ST_Dimension() = 1
       ORDER BY skey;