[postgis-users] ST_Insersection problem
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
More information about the postgis-users