#118: postgis ST_Intersects fails with invalid multipolygons
Solved!on July 14, 2011, 06:47 PM UTC — from 
kueda ( 1,121 views )
kueda ( 1,121 views )
But it fails silently, often only intersecting with one of the constituent polygons if the polgyon as a whole is invalid.
clean it up
- kueda on July 14, 2011, 06:47 PM UTC
To test whether the geom is valid:
This guy wrote a handy function to fix geoms: http://www.kappasys.ch/pgtools/cleangeometry/cleanGeometry.sql. Download it and
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.sqlUPDATE your_table SET geom = cleanGeometry(geom) WHERE id = XXX;