[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