[postgis-users] How to eliminate small gaps produced by ST_union?

[Paul Ramsey]

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.thomsen at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>