[postgis-users] Linestrings to polygons

[Stephen Woodbridge]

Martin Fafard wrote:
>   Stephen
> 
> Builarea only polygonize linestrings that are closed. And I don't want 
> one polygon but all possible polygons (pdf join for demo).

Have you tried using it?
I think it will do what you want.

The only caveat is the the line strings need to be noded at all 
intersections. If they are then it should work.

-Steve

> Martin F
> 
> Stephen Woodbridge a écrit :
>> Martin Fafard wrote:
>>> Hi
>>>
>>> How to convert linestring to polygons? Linetrings are not "closed" 
>>> but snap each other.
>>
>> Look at
>>
>> select ST_BuildArea(the_geom) from mytable where <select your 
>> linestrings>;
>>
>> you might need to collect(the_geom) if it is expecting a single object.
>>
>> -Steve
>>  
>>
>> No virus found in this incoming message.
>> Checked by AVG - www.avg.com <http://www.avg.com> 
>> Version: 8.0.237 / Virus Database: 270.11.8/1987 - Release Date: 03/06/09 07:20:00
>>
>>