[postgis-users] ST_Insersection problem

Sandro Santilli strk at keybit.net
Tue Oct 4 06:40:42 PDT 2011

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. 


  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html

More information about the postgis-users mailing list