15.10 - ST_GeometryType - Teradata Database

Teradata Database SQL Geospatial Types

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

Returns the ST_Geometry type of the ST_Geometry value.

Returns a VARCHAR(128) value that indicates the ST_Geometry type. The return value can be any of these strings:

  • 'ST_Point'
  • 'ST_LineString'
  • 'ST_Polygon'
  • 'ST_MultiPoint'
  • 'ST_MultiLineString'
  • 'ST_MultiPolygon'
  • 'ST_GeomCollection'
  • 'GeoSequence'
  • All ST_Geometry types.

       SELECT skey
       FROM sample_shapes
       WHERE shape.ST_GeometryType() = 'ST_LineString';