[postgis-users] problem to obtain intersection: TopologyException

[Birgit Laggner]

  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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100927/24f1537c/attachment.html>