On Tue, Oct 04, 2011 at 05:20:15AM -0700, G. van Es wrote: > Danke Birgit, > > Good point about the validity of the geometry! However in my case just by > experiment I have deleted all records where > st_isvalid(ST_GeomFromEWKT(st_asewkt(the_geom)))='f' > From the 11mio records a little over 800 where invalid and deleted. > > > Still my original query crashes on:NOTICE: TopologyException: side location > conflict at 129105 515684 ERROR: GEOS Intersection() threw an error! > > > All intersection parameters are like ST_SnapToGrid(the_geom, 0.000001) so > that doesn't resolve the issue either. Although it makes some difference on > which object the process crashes. > > Any ideas are still very welcome.
Note that ST_SnapToGrid can also introduce invalidities, try ST_IsValid on the return from ST_SnapToGrid. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
