[postgis-users] Linestrings to polygons

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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



  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090306/4e58d510/attachment.html>