[postgis-users] TopologyException

strk at refractions.net strk at refractions.net
Thu Mar 2 07:50:53 PST 2006


GEOS is still not fully robust.
I'm seeking for examples of such exceptions,
if you can produce the smallest possible dataset raising
the exception that'll help.

I'm working on this right now, and I have a single
real test (valid geoms raising an exception on overlay op)

--strk;

On Thu, Mar 02, 2006 at 04:44:01PM +0100, Arnaud Lesauvage wrote:
> Hi list !
> 
> The following error is raised :
> 
> TopologyException: no outgoing dirEdge found 
> (742602,5.08777e+006,5.08777e+006)
> 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 !
> 
> Regards
> --
> Arnaud
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
----------------------------------------------------------------------
State-collected Geographic Data is public property !
Reject the INSPIRE directive.
Sign the petition: http://petition.publicgeodata.org



More information about the postgis-users mailing list