[postgis-users] ST_Insersection problem

[Sandro Santilli]

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