On 19 August 2010 04:26, David Epstein <[email protected]> wrote: > Hello, > > I have a postGIS polygon layer with about 320,000 rows. I am trying to > return a table with object_number and the average area of the > surrounding (touching) polygons. I am getting this error: > > > NOTICE: Â TopologyException: side location conflict 1.34593e+07 289017 > ERROR: Â GEOS touches() threw an error! > > ********** Error ********** > > ERROR: GEOS touches() threw an error! > SQL state: XX000 > > > I have tried to simplify the geometry many different times. Nothing > seems to solve the problem. I can process the first 20,000 rows > (object_number < 20000) but something is causing problems after that. I > have pasted the script below, any suggestions would be welcomed! > > Thank you, > -david > > > SELECT p1.ogc_fid, avg(p2.shape_area) > FROM parcels09_d3_v2_simplify as p1, parcels09_d3_v2_simplify as p2 > WHERE st_touches(p1.wkb_geometry, p2.wkb_geometry) > GROUP BY p1.ogc_fid > ORDER BY p1.ogc_fid > >
Hi, Are your geometries valid (st_isValid(), st_isValidReason()) ? Nicolas _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
