ST_MAKEVALID ​

Creates a valid representation of an invalid GEOGRAPHY while preserving all input vertices.

If the input GEOGRAPHY is already valid, it is returned unchanged.

See also:

• ST_ISVALID

Syntax ​

ST_MAKEVALID(<input>)

Arguments ​

• <input>: The GEOGRAPHY object to be validated

Returns ​

Returns a valid GEOGRAPHY object. The output may be:

• The same GEOGRAPHY if the input was already valid
• A collection of geographies with equal or lower dimensions
• A GEOGRAPHY of lower dimension in case of dimensional collapse
• A multi-geometry if self-intersections are present

Example ​

SELECT ST_AsText(ST_MakeValid('POLYGON((1 1, -1 1, 1 -1, -1 -1, 1 1))'::GEOGRAPHY));
-- MULTIPOLYGON(((-1 1,1 1,0 0,-1 1)),((-1 -1,0 0,1 -1,-1 -1)))