[postgis-users] ST_Insersection problem

[G. van Es]

Well, ST_SnapToGrid seems to work a little better we get now TopologyException: side location conflict at 59647.5 392932

Still GOES seems to crash on Intersection()......  It's a bit funny since all data is produced by PostGis and now PostGis can't handle it's own data.

Ge



________________________________
From: Sandro Santilli <strk at keybit.net>
To: G. van Es <gves2000 at yahoo.com>; PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Sent: Tuesday, September 20, 2011 3:07 PM
Subject: Re: [postgis-users] ST_Insersection problem

On Tue, Sep 20, 2011 at 06:04:47AM -0700, G. van Es wrote:
> I'm interested in the area of the intersection so a boolean answer will not do. The example query is the one I use to prevent my screen from filling with a few hundred-thousands records.
> 
> I have simplified all geometries to POLYGON (no MULTI, no Collection), still st_intersection crashes.
> 
> My conclusion that it is a bug either in PG or GEOS, which also is mentioned in the manual.
> 
> So for any idea about a workaround I would be very happy to know about it.

Try passing the geometries trough ST_SnapToGrid, making sure they remain valid.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\  http://strk.keybit.net/services.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110920/3e4751d2/attachment.html>