Edit geometries

The following functions are available to edit geometries:

Function

Description

ST_AddPoint

Add a point to a Geometry

ST_CollectionExtract

Filter a Geometry with its dimension

ST_Densify

Insert extra vertices along the line segments of a Geometry

ST_FlipCoordinates

Flip the X and Y coordinates of a Geometry

ST_ForcePolygonCW

Forces (Multi)Polygons to use a clockwise orientation

ST_ForcePolygonCCW

Forces (Multi)Polygons to use a counter-clockwise orientation

ST_Normalize

Return a Geometry with a normal form

ST_RemoveDuplicatedCoordinates

Remove duplicated coordinates from a Geometry

ST_RemoveHoles

Remove a Geometry’s holes

ST_RemovePoints

Return a Geometry with vertices less

ST_RemoveRepeatedPoints

Remove repeated points from a Geometry

ST_Reverse

Reverse the vertex order of a Geometry