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


_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to