Martin, You could try closing the polygons with ST_AddPoint and then use ST_Polygonize. http://postgis.refractions.net/documentation/manual-svn/ST_AddPoint.html http://postgis.refractions.net/documentation/manual-svn/ST_Polygonize.html Leo
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Martin Fafard Sent: Friday, March 06, 2009 5:03 PM To: Stephen Woodbridge Cc: PostGIS Users Discussion Subject: Re: [postgis-users] Linestrings to polygons 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
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
