Hi All,

I've got a table (a view actually) with two multipolygon geometry columns: wkb_geom_extent and wkb_geom_digitized.

They contain polygons representing the footprint of images and the areas digitized in the images.

So the view looks like:
v_images
image_id:    wkb_geom_extent:    wkb_geom_digitized:
1                   xxxxx          xxxx
2                   xxxxx
3                   xxxxxx         xxxxx


I want to calculate the area digitized in each of the images and since some of the polygons representing the area digitized could have be sloppily defined to extend outside of the image footprint , I thought I would intersect the two geometries:

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

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

This may be due to some problems in my geometries, but I thought I would check to see if my query was reasonable...

Thanks!

--
Best Regards,
Brent Fraser


_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to