15.10 - ST_IsSimple - Teradata Database

Teradata Database SQL Geospatial Types

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

Tests if an ST_Geometry value has no anomalous geometric points, such as self intersection tangency.

Returns an INTEGER value:

  • 1, if the geometry is simple, with no anomalous points
  • 0, if the geometry is not simple
  • Any ST_Geometry type.

       SELECT skey
       FROM sample_shapes
       WHERE shape.ST_IsSimple() = 0
       ORDER BY skey;