[postgis-users] union operation

[Suhr, Ralf]

Your have some invalid geometries.

Use 
update table set geom = cleangeometry(geom) where isvalid(geom) = FALSE;

The SQL-Function can be found at
http://www.sogis1.so.ch/sogis/dl/postgis/cleanGeometry.sql

Gr Ralf

-----Ursprüngliche Nachricht-----
Von: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] Im Auftrag von Nathan Widmyer
Gesendet: Freitag, 7. August 2009 00:41
An: PostGIS Users Discussion
Betreff: [postgis-users] union operation


I have many polygons I'm trying to make a union of.  The polygons have a high possibility of shared vertices which causes the "NOTICE:
TopologyException: found non-noded intersection between ..." error.

How can I avoid this error?

I did find a reasonable query that used linework which solved that problem, but was problematic in other ways I think (I forgot those other circumstances). _______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users