[postgis-users] union operation

[Paragon Corporation]

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