On Jun 12, 2012, at 1:52 PM, Brent Fraser <bfra...@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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users