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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
