<html><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:10pt"><div><span>I'm interested in the area of the intersection so a boolean answer will not do. The example query is the one I use to prevent my screen from filling with a few hundred-thousands records.</span></div><div><br></div><div>I have simplified all geometries to POLYGON (no MULTI, no Collection), still st_intersection crashes.<br></div><div>My conclusion that it is a bug either in PG or GEOS, which also is mentioned in the manual. <br></div><div><br></div><div>So for any idea about a workaround I would be very happy to know about it.</div><div><br></div><div>Ger<br><span></span></div><div><span><br></span></div><div><br></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span
style="font-weight:bold;">From:</span></b> Sandro Santilli <strk@keybit.net><br><b><span style="font-weight: bold;">To:</span></b> G. van Es <gves2000@yahoo.com>; PostGIS Users Discussion <postgis-users@postgis.refractions.net><br><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, September 20, 2011 2:14 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] ST_Insersection problem<br></font><br>On Tue, Sep 20, 2011 at 03:45:49AM -0700, G. van Es wrote:<br><br>> Given the following query<br>> select count(st_intersection(tbl_a.the_geom,tbl_b.the_geom)) from tbl_a, tbl_b;<br>> <br>> will result in this error message<br>> <br>> NOTICE: TopologyException: found non-noded intersection between LINESTRING (62723.7 426635, 62722.5 426634) and LINESTRING (62723.7 426635, 62726.2 426632) at 62723.7 426635<br>...<br>> Does anyone know a solution or workaround for this
problem?<br><br>If that's the real query you're needlessly requesting computation of<br>the intersection space, which is having robustness issues.<br>Maybe you want to use ST_Intersects(A, B), which doesn't have the<br>robustness issue and is likely also faster.<br><br>--strk;<br><br> () Free GIS & Flash consultant/developer<br> /\ <a href="http://strk.keybit.net/services.html" target="_blank">http://strk.keybit.net/services.html</a><br><br><br></div></div></div></body></html>