[postgis-users] ST_Insersection problem

G. van Es gves2000 at yahoo.com
Tue Sep 20 03:45:49 PDT 2011

Hello Group,

We are using "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" and having a problem with ST_Intersection().

Given the following query
select count(st_intersection(tbl_a.the_geom,tbl_b.the_geom)) from tbl_a, tbl_b;

will result in this error message

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

ERROR: GEOS Intersection() threw an error!
SQL status:XX000

After the NOTICE message we expect the query to continue but it doesn't.  Both tables have all records st_isvalid='t'.

Does anyone know a solution or workaround for this problem?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110920/6b75bb40/attachment.html>

More information about the postgis-users mailing list