ST_IsSimple() method

Determines whether the geometry value is simple (containing no self intersections or other irregularities).

Syntax

geometry-expression.ST_IsSimple()

Returns

BIT Returns 1 if the geometry value is simple, otherwise 0.

Examples

Example 1 – The following returns the result 29 because the corresponding multi linestring contains two lines which cross.
```
SELECT ShapeID FROM SpatialShapes WHERE Shape.ST_IsSimple() = 0
```

Standards

SQL/MM (ISO/IEC 13249-3: 2006) 5.1.8

Parent topic: ST_Geometry type

Created December 19, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com