Skip to main content
Returns the areal geometry formed by the constituent linework of the input geometry. ST_BuildArea

​
Signatures

ST_BuildArea (A: Geometry)

​
Parameters

​
A
Geometry
required
The input geometry.

​
Return type

The resulting geometry.

​
Example

SELECT ST_BuildArea(
    ST_GeomFromWKT('MULTILINESTRING((0 0, 20 0, 20 20, 0 20, 0 0),(2 2, 18 2, 18 18, 2 18, 2 2))')
) AS geom


+----------------------------------------------------------------------------+
|geom                                                                        |
+----------------------------------------------------------------------------+
|POLYGON((0 0,0 20,20 20,20 0,0 0),(2 2,18 2,18 18,2 18,2 2))                |
+----------------------------------------------------------------------------+