ST_IsValidReason

Returns text stating if the geometry is valid. If not, it provides a reason why it is invalid. The function can be invoked with just the geometry or with an additional flag. The flag alters the validity checking behavior. 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_IsValidReason (A: Geometry)

ST_IsValidReason (A: Geometry, flag: Integer)

Parameters

Geometry

required

The input geometry.

flag

Integer

The validation flag.

Return type

A string representation.

Examples

for valid geometry

SELECT ST_IsValidReason(ST_GeomFromWKT('POLYGON ((100 100, 100 300, 300 300, 300 100, 100 100))')) as validity_info

Valid Geometry

for invalid geometries

SELECT gid, ST_IsValidReason(geom) as validity_info
FROM Geometry_table
WHERE ST_IsValid(geom) = false
ORDER BY gid

gid  |                  validity_info
-----+----------------------------------------------------
5330 | Self-intersection at or near point (32.0, 5.0, NaN)
5340 | Self-intersection at or near point (42.0, 5.0, NaN)
5350 | Self-intersection at or near point (52.0, 5.0, NaN)

ST_IsValidDetail

ST_MakeValid

⌘I

Wherobots Cloud REST API

WherobotsDB

Vector tiles (PMTiles)

Havasu (Iceberg) table management

GeoStats and Map Matching

Rasterflow

Signatures

Parameters

Return type

Examples

for valid geometry

for invalid geometries

​Signatures

​Parameters

​Return type

​Examples

​for valid geometry

​for invalid geometries

Signatures

Parameters

Return type

Examples

for valid geometry

for invalid geometries