[postgis-users] Linestrings to polygons
woodbri at swoodbridge.com
Fri Mar 6 17:00:54 PST 2009
Martin Fafard wrote:
> 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.
> Martin F
> Stephen Woodbridge a écrit :
>> Martin Fafard wrote:
>>> 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
>> you might need to collect(the_geom) if it is expecting a single object.
>> 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
More information about the postgis-users