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