Hi, I have a table 'municipio' with a geometric column (the_geom). I want to get a view with the resultant of the interception between the the_geom column and a polygon.
The query: ---------- SELECT ST_Dump(ST_Intersection(the_geom, GeomFromText('MULTIPOLYGON(((177056.442675 283157.030268, 283157.030268 192559.320783, 192559.320783 293446.551137, 177056.442675 293446.551137, 177056.442675 283157.030268)))',2085))) FROM municipio WHERE the_geom IS NOT NULL AND ST_Intersects(the_geom, GeomFromText('MULTIPOLYGON(((177056.442675 283157.030268, 283157.030268 192559.320783, 192559.320783 293446.551137, 177056.442675 293446.551137, 177056.442675 283157.030268)))',2085)) = TRUE return an error: ---------------- NOTICE: TopologyException: found non-noded intersection between 178970 311240, 178977 311221 and 178976 311224, 178971 311238 178972 311234 ERROR: GEOS Intersection() threw an error! ********** Error ********** ERROR: GEOS Intersection() threw an error! SQL state: XX000 What's the problem ???? The WHERE statemente ((the_geom, GeomFromText( ...) ) ensure the intersection Best regards, Salas
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users