Ralf, This is pretty cool by the way. I tried it on some of my problem geometries and it worked great.
Thanks, Regina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Suhr, Ralf Sent: Friday, August 07, 2009 3:15 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] union operation 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: [email protected] [mailto:[email protected]] 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
