ST_MAKEPOLYGONORIENTED

Creates a Polygon from a LineString input, preserving the vertex order as given. Unlike ST_MAKEPOLYGON, this function does not reorder vertices to enforce a specific winding direction.

Syntax

ST_MAKEPOLYGONORIENTED(<geometry>)

Arguments

Return Type

Geometry.

Examples

SELECT ST_ASWKT(
  ST_MAKEPOLYGONORIENTED(TO_GEOMETRY('LINESTRING(0 0, 1 0, 1 2, 0 2, 0 0)'))
);

┌──────────────────────────────────┐
│             result               │
├──────────────────────────────────┤
│ POLYGON((0 0,1 0,1 2,0 2,0 0))  │
└──────────────────────────────────┘

-- Reversed winding order is preserved
SELECT ST_ASWKT(
  ST_MAKEPOLYGONORIENTED(TO_GEOMETRY('LINESTRING(0 0, 0 2, 1 2, 1 0, 0 0)'))
);

┌──────────────────────────────────┐
│             result               │
├──────────────────────────────────┤
│ POLYGON((0 0,0 2,1 2,1 0,0 0))  │
└──────────────────────────────────┘