[postgis-users] TopologyException with geomunion

[strk at refractions.net]

Put your geometries in a table and produce a dump of it:
pg_dump -Fc -t <yourtable> <yourdb> > unionbug.dump

Then feel free to send the dump to me.

--strk;



On Thu, Nov 03, 2005 at 10:26:01AM +0000, David Orme wrote:
> Hi,
> 
> Sorry I forgot to put on the version data:
> 
> range_maps=# select postgis_full_version();
>                                          postgis_full_version
> ------------------------------------------------------------------------ 
> ------------------------------
> POSTGIS="1.0.4" GEOS="2.1.4" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS  
> DBPROC="0.3.0" RELPROC="0.3.0"
> (1 row)
> 
> It is all built on a Apple G5 running Tiger.
> 
> The multipolygons are very large - the two  as HEXWKB are nearly 12  
> MB - I'm going to be very unpopular if I post that! What's the best  
> way of getting them to you?
> 
> Cheers,
> David
> 
> 
> 
> 
> On 3 Nov 2005, at 09:48, strk at refractions.net wrote:
> 
> >Can you provide the HEXWKB (canonical output)
> >of the geometries triggering the error
> >if this happens with GEOS-2.1.4 ?
> >--strk;
> >
> >On Wed, Nov 02, 2005 at 03:32:32PM +0000, David Orme wrote:
> >
> >>Hi all,
> >>
> >>I've run into an exception when trying to union two multipolygons.
> >>The features are both simple and valid:
> >>
> >>range_maps=# select isvalid(geom), issimple(geom) from viverrid_psar
> >>where node_number in (-3,-21);
> >>isvalid | issimple
> >>---------+----------
> >>t       | t
> >>t       | t
> >>(2 rows)
> >>
> >>
> >>but when I try and union these I get the following:
> >>
> >>range_maps=# insert into viverrid_psar (taxon_name, node_number,
> >>subclades, branch_length,  n_tips, n_subclades, node_height,
> >>richness, geom)values ('',-2,'{-3,-21}',9.9,31,2,18.1,31,(select
> >>geomunion(geom) from viverrid_PSAR where node_number in (-3,-21)));
> >>NOTICE:  TopologyException: Directed Edge visited twice during ring-
> >>building at  (1.13203e+07,402571)
> >>ERROR:  GEOS union() threw an error!
> >>
> >>I don't think I'm doing something dumb, but I thought I'd check
> >>before I start posting bug reports..
> >>
> >>Cheers,
> >>David
> >>
> >>
> >>_______________________________________________
> >>postgis-users mailing list
> >>postgis-users at postgis.refractions.net
> >>http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >_______________________________________________
> >postgis-users mailing list
> >postgis-users at postgis.refractions.net
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users