Hi Salas,
did you check if your geometries are all valid (with function
st_isvalid(geometry))?
Regards,
Birgit.
On 24.09.2010 16:33, salas wrote:
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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
