[postgis-users] Linestrings to polygons

Martin Fafard martin.fafard at geoprojection.com
Fri Mar 6 14:03:02 PST 2009


Stephen

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

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 
> Version: 8.0.237 / Virus Database: 270.11.8/1987 - Release Date: 03/06/09 07:20:00
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090306/e56e626f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: linestrings_to_polygons.pdf
Type: application/pdf
Size: 4026 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090306/e56e626f/attachment.pdf>


More information about the postgis-users mailing list