ST_MakeValid¶

Creates a valid representation of an invalid geometry.

Usage¶

geometry ST_MakeValid(geom: geometry)
geometry ST_MakeValid(geom: geometry, keepCollapsed: boolean)

Arguments¶

geom (geometry): Input geometry
keepCollapsed (boolean)

Description¶

Collapsed geometries are either converted to empty (keepCollapsed=false) or a valid geometry of lower dimension (keepCollapsed=true). Default is keepCollapsed=false.

Examples¶

SELECT ST_MakeValid(ST_GeomFromWKT('LINESTRING(1 1, 1 1)'));

┌────────────────────────────────────────────────────────────┐
│ st_makevalid(st_geomfromwkt(Utf8("LINESTRING(1 1, 1 1)"))) │
│                          geometry                          │
╞════════════════════════════════════════════════════════════╡
│ POINT(1 1)                                                 │
└────────────────────────────────────────────────────────────┘