<html><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:10pt"><div><span>Grazie Sandro,</span></div><div><br><span></span></div><div><span>Indeed SnapToGrid did introduce some invalidities. By removing them as well the query runs fine. Now we have to analyse the geometries which has been excluded and see if we need them or not.</span></div><div><br><span></span></div><div><span>Thank you and others for your thoughts.</span></div><div><br><span></span></div><div><span>Ge<br></span></div><div><br><span></span></div><div><br></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Sandro Santilli <strk@keybit.net><br><b><span style="font-weight: bold;">To:</span></b> G. van Es
<gves2000@yahoo.com>; PostGIS Users Discussion <postgis-users@postgis.refractions.net><br><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, October 4, 2011 3:40 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] ST_Insersection problem<br></font><br>
On Tue, Oct 04, 2011 at 05:20:15AM -0700, G. van Es wrote:<br>> Danke Birgit,<br>> <br>> 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'<br>> From the 11mio records a little over 800 where invalid and deleted. <br>> <br>> <br>> Still my original query crashes on:NOTICE: TopologyException: side location conflict at 129105 515684 ERROR: GEOS Intersection() threw an error!<br>> <br>> <br>> 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.<br>> <br>> Any ideas are still very welcome.<br><br>Note that ST_SnapToGrid can also introduce invalidities, try ST_IsValid<br>on the return from ST_SnapToGrid. <br><br>--strk;<br><br>
() Free GIS & Flash consultant/developer<br> /\ http://strk.keybit.net/services.html<br><br><br></div></div></div></body></html>