tag:selfsolved.com,2005:/problems/postgis-st_intersects-fails-with/sSolutions for: postgis ST_Intersects fails with invalid multipolygons | SelfSolveda SelfSolved feed2011-07-14T18:47:41Z1SelfSolvedtag:selfsolved.com,2005:Array/69923144390000kueda SELECT ST_IsValid(geom) FROM your_table WHERE id = XXX;
This guy wrote a handy function to fix geoms: http://www.kappasys.ch/pgtools/cleangeometry/cleanGeometry.sql. Download it and
psql your_database < cleanGeometry.sql UPDATE your_table SET geom = cleanGeometry(geom) WHERE id = XXX;]]>