[postgis-users] ST_Union (8.4) and TopologyException

Simon Greener simon at spatialdbadvisor.com
Tue Aug 4 16:51:23 PDT 2009

I have been trying out the new ST_Union in 1.4 and have a question.

I note that, whenever I hit an error like this:

NOTICE:  TopologyException: found non-noded intersection between 5.74214e+006 7.36573e+006, 5.74304e+006 7.36666e+006 and 5.74339e+006 7.36629e+006, 5.74304e+006 7.36666e+006 5.74304e+006 7.36666e+006

ST_Union fails to produce a result.

Is there anything I can do to address this TopologyException issue within PostGIS.

SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
  Email: simon at spatialdbadvisor.com
  Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)

More information about the postgis-users mailing list