Skip to content

ST_IsSimple

Tests if geometry’s only self-intersections are at boundary points.

Usage

boolean ST_IsSimple(geom: geometry)

Arguments

  • geom (geometry): Input geometry

Description

Returns true if the geometry has no anomalous geometric points such as self-intersections or self-tangency.

Examples

SELECT ST_IsSimple(
  ST_GeomFromWKT('POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))')
);
┌─────────────────────────────────────────────────────────────────────────┐
 st_issimple(st_geomfromwkt(Utf8("POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))"))) 
                                 boolean                                 
╞═════════════════════════════════════════════════════════════════════════╡
 true                                                                    
└─────────────────────────────────────────────────────────────────────────┘