<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Try to use function <b>st_cleanpolygon</b>
or <b>st_buffer</b> with a radius of 0.0. <br>
<br>
Regards<br>
Bo Victor Thomsen<br>
Aestas-GIS<br>
Denmark<br>
<br>
Den 25-10-2012 18:54, Alexandre Neto skrev:<br>
</div>
<blockquote
cite="mid:CA+H0G_E5baYo3PZFEgWPXxEcQFv+AY7nwC=rzoV9stuzbPW3=w@mail.gmail.com"
type="cite">I'm trying to Aggregate\Dissolve a set of adjacent,
but not touching polygons in Postgis. The geometries were created
editing the Postgis table in QGIS created, with snapping and avoid
overlap in the layer.
<div><br>
</div>
<div>I used ST_Union like this:
<div>
<div><br>
</div>
<div>
<div>SELECT ST_Union(the_geom)</div>
<div>FROM table;</div>
</div>
<div><br>
</div>
<div>Small gaps similar to lines appear in the result. This
happens when the adjacent polygons do not share the exact
same vertices.
<div>
<br>
</div>
<div><img src="cid:part1.09050906.06000007@gmail.com"
alt="Inline image 2"><br>
</div>
<div>Is there a way to eliminate this "gaps" or "small
angles" within Postgis?</div>
<div><br>
</div>
<div>I know that v.clean in GRASS can eliminate small
angles, and correct topology, but that would mean I needed
to copy the features to GRASS, correct them and copy it
back to Postgis.</div>
<div><br>
</div>
<div>Thanks in advance,</div>
<div><br>
</div>
<div>Alexandre Neto </div>
<div><br>
</div>
<div>
<div><br>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</body>
</html>