<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><font size="2"><span style="font-family: verdana,helvetica,sans-serif;">Hello Group,</span><br style="font-family: verdana,helvetica,sans-serif;"><br style="font-family: verdana,helvetica,sans-serif;"><span style="font-family: verdana,helvetica,sans-serif;">We are using "<span style="font-style: italic;">POSTGIS="1.5.1" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.6" USE_STATS</span>" and having a problem with ST_Intersection().</span><br style="font-family: verdana,helvetica,sans-serif;"><br style="font-family: verdana,helvetica,sans-serif;"><span style="font-family: verdana,helvetica,sans-serif;">Given the following query</span><br style="font-family: verdana,helvetica,sans-serif;"><span style="font-family: verdana,helvetica,sans-serif; font-style: italic;">select
count(st_intersection(tbl_a.the_geom,tbl_b.the_geom)) from tbl_a, tbl_b</span>;<br style="font-family: verdana,helvetica,sans-serif;"><br style="font-family: verdana,helvetica,sans-serif;"><span style="font-family: verdana,helvetica,sans-serif;">will result in this error message</span><br style="font-family: verdana,helvetica,sans-serif;"><br style="font-family: verdana,helvetica,sans-serif;"><span style="font-family: verdana,helvetica,sans-serif; font-style: italic;">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</span><br style="font-family: verdana,helvetica,sans-serif; font-style: italic;"><br style="font-family: verdana,helvetica,sans-serif; font-style: italic;"><span style="font-family: verdana,helvetica,sans-serif; font-style: italic;">ERROR: GEOS Intersection() threw an error!</span><br style="font-family:
verdana,helvetica,sans-serif; font-style: italic;"><span style="font-family: verdana,helvetica,sans-serif; font-style: italic;">SQL status:XX000</span><br style="font-family: verdana,helvetica,sans-serif;"><br style="font-family: verdana,helvetica,sans-serif;"><br style="font-family: verdana,helvetica,sans-serif;"><span style="font-family: verdana,helvetica,sans-serif;">After the NOTICE message we expect the query to continue but it doesn't. Both tables have all records st_isvalid='t'.</span><br style="font-family: verdana,helvetica,sans-serif;"><br style="font-family: verdana,helvetica,sans-serif;"><span style="font-family: verdana,helvetica,sans-serif;">Does anyone know a solution or workaround for this problem?</span><br style="font-family: verdana,helvetica,sans-serif;"><br style="font-family: verdana,helvetica,sans-serif;"><span style="font-family: verdana,helvetica,sans-serif;">Thanks,</span><br style="font-family:
verdana,helvetica,sans-serif;"><br style="font-family: verdana,helvetica,sans-serif;"><span style="font-family: verdana,helvetica,sans-serif;">Ge</span><br style="font-family: verdana,helvetica,sans-serif;"></font><br><br></div></div></body></html>