[postgis-users] problem to obtain intersection: TopologyException

salas fsalas at geocuba.cu
Fri Sep 24 07:33:41 PDT 2010


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100924/dda72de6/attachment.html>


More information about the postgis-users mailing list