ST_IsValidDetail

Returns a row, containing a boolean valid stating if a geometry is valid, a string reason stating why it is invalid and a geometry location pointing out where it is invalid. This function is a combination of ST_IsValid and ST_IsValidReason. The flags parameter is a bitfield with the following options:

0 (default): Use usual OGC SFS (Simple Features Specification) validity semantics.
1: “ESRI flag”, Accepts certain self-touching rings as valid, which are considered invalid under OGC standards.

Signatures

ST_IsValidDetail(geom: Geometry)

ST_IsValidDetail(geom: Geometry, flag: Integer)

Parameters

geom

Geometry

required

The input geometry.

flag

Integer

The validation flag.

Return type

A struct containing the result fields.

Example

SELECT ST_IsValidDetail(ST_GeomFromWKT('POLYGON ((30 10, 40 40, 20 40, 30 10, 10 20, 30 10))'))

+-----+---------------------------------------------------------+-------------+
|valid|reason                                                   |location     |
+-----+---------------------------------------------------------+-------------+
|false|Ring Self-intersection at or near point (30.0, 10.0, NaN)|POINT (30 10)|
+-----+---------------------------------------------------------+-------------+

ST_IsValid

ST_IsValidReason

⌘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