ST_MakeValid

Given an invalid geometry, create a valid representation of the geometry. Collapsed geometries are either converted to empty (keepCollapsed=false) or a valid geometry of lower dimension (keepCollapsed=true). Default is keepCollapsed=false.

Signatures

ST_MakeValid (A: Geometry)

ST_MakeValid (A: Geometry, keepCollapsed: Boolean)

Parameters

Geometry

required

The input geometry.

keepCollapsed

Boolean

The keep collapsed value.

Return type

The resulting geometry.

Example

WITH linestring AS (
    SELECT ST_GeomFromWKT('LINESTRING(1 1, 1 1)') AS geom
) SELECT ST_MakeValid(geom), ST_MakeValid(geom, true) FROM linestring

+------------------+------------------------+
|st_makevalid(geom)|st_makevalid(geom, true)|
+------------------+------------------------+
|  LINESTRING EMPTY|             POINT (1 1)|
+------------------+------------------------+

In Sedona up to and including version 1.2 the behaviour of ST_MakeValid was different.

Be sure to check you code when upgrading. The previous implementation only worked for (multi)polygons and had a different interpretation of the second, boolean, argument. It would also sometimes return multiple geometries for a single geometry input.

ST_IsValidReason

ST_BoundingDiagonal

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Example

​Signatures

​Parameters

​Return type

​Example

Signatures

Parameters

Return type

Example