[postgis-users] Intersection() error

[Kevin Neufeld]

Are your input geometries valid? 

We're going to need more information if we're to help you.  Perhaps 
isolate the two geometries that are causing the error and if they are 
small enough, post the WKT representation here.

-- Kevin

Gustavo Martinez wrote:
> Hi,
>
> I am trying to calculate the area of the intersection of several polygons with 
> the following query:
>
> select idrectangulos, nro_rct, area(geom)/1000000 as total, 
> area(st_intersection(geom,(select geom from zonas where cat=9)))/1000000 as 
> rio, 
> area(st_intersection(geom,(select geom from zonas where cat=1)))/1000000 as 
> zcp,
> area(st_intersection(geom,(select geom from zonas where cat=3)))/1000000 as 
> zee,
> area(st_intersection(geom,(select geom from zonas where cat=2)))/1000000 as 
> pcia
> from rectangulos
>
> However, I got the following error:
>
> NOTICE:  TopologyException: no outgoing dirEdge found 
> (-68.3024,-52.6125,-52.6125)
>
> ERROR:  GEOS Intersection() threw an error!
>
> How can I handle this?
> Thanks
>
>
> Gustavo
>
>