If you don't mind altering your other edges somewhat in the process,
dilate/erode will blow those away,

http://blog.opengeo.org/2010/11/22/removing-complexities/

P.

On Thu, Oct 25, 2012 at 10:44 AM, Bo Victor Thomsen
<bo.victor.thom...@gmail.com> wrote:
>
> Try to use function st_cleanpolygon or st_buffer with a radius of 0.0.
>
> Regards
> Bo Victor Thomsen
> Aestas-GIS
> Denmark
>
> Den 25-10-2012 18:54, Alexandre Neto skrev:
>
> 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.
>
> I used ST_Union like this:
>
> SELECT ST_Union(the_geom)
> FROM table;
>
> Small gaps similar to lines appear in the result. This happens when the 
> adjacent polygons do not share the exact same vertices.
>
>
> Is there a way to eliminate this "gaps" or "small angles" within Postgis?
>
> 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.
>
> Thanks in advance,
>
> Alexandre Neto
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to