[postgis-users] row-wise geometry intersecting

[Puneet Kishor]

On Jun 12, 2012, at 1:52 PM, Brent Fraser <bfraser at geoanalytic.com> wrote:

> SELECT image_id, ST_Intersection(wkb_geom_extent, wkb_geom_digitized) as image_area FROM v _images

The query looks fine, but what do you want to accomplish with it? It will give you the area of the intersection, if any.


> 
> but I get an error:
> 
> NOTICE:  TopologyException: side location conflict at -17.2242 79.1865
> ERROR:  GEOS Intersection() threw an error!
> ********** Error **********
> ERROR: GEOS Intersection() threw an error!
> SQL state: XX000

Ha! I got the same error the other day, and, iirc, it was because of the dreaded self-intersections.







--
Puneet Kishor
http://punkish.org