[postgis-users] Convert linestring to polygon

[strk at refractions.net]

A better alternative is 'BuildArea(Geometry)'.

	Availability: 1.1.0 - requires GEOS >= 2.1.0.

You'd collect() the input and pass the collection to BuildArea.

--strk;

On Thu, Apr 13, 2006 at 09:39:52AM +0200, Bart van den Eijnden (OSGIS) wrote:
> Yes, look for a function called polygonize.
> 
> Polygonize(geometry set)
> 
>     Aggregate. Creates a GeometryCollection containing possible polygons
> formed from the costituent linework of a set of geometries.
> 
>     Availability: 1.0.0RC1 - requires GEOS >= 2.1.0.
> 
> Best regards,
> Bart
> 
> > I have a postgis table containing linestring geometries.
> > Some of these linestrings are in fact closed polygon.
> > Is there a function to convert these closed linestring to a polygon?