[postgis-users] TopologyException

Arnaud Lesauvage thewild at freesurf.fr
Thu Mar 2 07:44:01 PST 2006

Hi list !

The following error is raised :

TopologyException: no outgoing dirEdge found 
ERROR:  GEOS Intersection() threw an error!

when I try to run this statement :

SELECT DISTINCT(c1.handle) AS handle
FROM cells_temp AS c1
INNER JOIN cells_temp AS c2
ON (c1.cell_geometry && c2.cell_geometry AND c1.handle!=c2.handle
AND IsValid(c1.cell_geometry) AND IsValid(c2.cell_geometry)
AND Relate(c1.cell_geometry,c2.cell_geometry,'2********'))
WHERE Area(Intersection(c1.cell_geometry,c2.cell_geometry))>0.5

I wrote this query to get all the geometries that overlap with 
another geometry from the table (i.e. the surface of the 
intersection is greater than 0.5 square meters).

If I remove the Intersection(c1.cell_geometry,c2.cell_geometry), 
the query runs fine !
IsValid returns true for the entire table !

Does anyone have a hint about what is going on ?

Thanks a lot !


More information about the postgis-users mailing list