<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Stephen<br>
<br>
Builarea only polygonize linestrings that are closed. And I don't want
one polygon but all possible polygons (pdf join for demo).<br>
<br>
Martin F<br>
<br>
Stephen Woodbridge a écrit :
<blockquote cite="mid:49B19AB3.1040503@swoodbridge.com" type="cite">Martin
Fafard wrote:
<br>
<blockquote type="cite">Hi
<br>
<br>
How to convert linestring to polygons? Linetrings are not "closed" but
snap each other.
<br>
</blockquote>
<br>
Look at
<br>
<br>
select ST_BuildArea(the_geom) from mytable where <select your
linestrings>;
<br>
<br>
you might need to collect(the_geom) if it is expecting a single object.
<br>
<br>
-Steve
<br>
<pre wrap="">
<hr size="4" width="90%">
No virus found in this incoming message.
Checked by AVG - <a class="moz-txt-link-abbreviated" href="http://www.avg.com">www.avg.com</a>
Version: 8.0.237 / Virus Database: 270.11.8/1987 - Release Date: 03/06/09 07:20:00
</pre>
</blockquote>
</body>
</html>