On Tue, Sep 20, 2011 at 03:45:49AM -0700, G. van Es wrote: > 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 ... > Does anyone know a solution or workaround for this problem?
If that's the real query you're needlessly requesting computation of the intersection space, which is having robustness issues. Maybe you want to use ST_Intersects(A, B), which doesn't have the robustness issue and is likely also faster. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users