[postgis-users] TopologyException: no outgoing dirEdge found

[John Powell]

I was having this error and in my case it was to do with consecutive
identical polygons. 

I ran 

delete from geom_table using (select t1.id as delid from geom_table t1,
geom_table t2 where t1.id<>t2.id and st_equals(t1.g,t2.g)='t' group by
t1.id) as dupes where geom_table.id=dupes.delid;

to remove all the duplicates. After that ST_Multi(ST_Union(geom)) worked as
expected.



Andreas Laggner wrote:
> 
> Hi,
> 
> does someone know what´s behind this Error?
> NOTICE: TopologyException: no outgoing dirEdge found 
> (3.5888e+006,5.82215e+006)
> ERROR: GEOS union() threw an error!
> 
> I tried the functions Intersection() and Union() with different datasets 
> from differnet regions (65 to 6000 polygons) in many combinations and i 
> always get this error (even if the data isvalid and issimple). With 
> google search i found some hints: Maybe to high precision is the reason 
> for this???
> I want to intersect whole germany with postgis and i did not realize a 
> small municipality so far! I tried WinXP with PostgreSQL8.1 and Linux 
> with PostgreSQL8.2 (new installation with highest version of postgis 
> available).
> 
> My SQL statements:
> create table intersect_gf2(gid integer) with oids;
> select 
> addgeometrycolumn('','intersect_gf2','the_geom','31467','MULTIPOLYGON',2);
> insert into intersect_gf2 select t1.gid,geomunion(t1.the_geom, 
> t2.the_geom) from gf_veg1 t1, gf_corine t2;
> insert into intersect_gf2 select t1.gid,intersection(t1.the_geom, 
> t2.the_geom) from gf_buk t1, gf_veg2 t2;
> 
> hasta luego Andreas
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://old.nabble.com/TopologyException%3A-no-outgoing-dirEdge-found-tp12052295p26440921.html
Sent from the PostGIS - User mailing list archive at Nabble.com.