[postgis-users] st_union exception

Martin Davis mbdavis at refractions.net
Thu Jan 15 09:48:10 PST 2009


Is this an older version of PostGIS/GEOS?  I believe that most of these 
kinds of problems were addressed in a release of GEOS last year.

Mark Mitchell wrote:
> Anyone get an error similar to this when unioning a bunch of polygons
> with st_union?
>
> NOTICE:  TopologyException: no outgoing dirEdge found (-149.073,61.6101,61.6101)
> ERROR:  GEOS union() threw an error!
>
> I must say before I get into the details only a few of you will read
> that portion that I've used postgis for a while now (since 1.1.5) and
> it is *PHENOMENAL*.  I don't want my only posts to this list in that
> time frame to be negative -- can't tell you how much
> faster/better/intuitive I've found postgis over very expensive
> commercial alternatives :-).
>
>
> My query is similar to the following:
>
> SELECT st_multi(st_union(poly)) from (select ... (a bunch of polys) ... ) a;
>
> The subselect is operating on a fairly dynamic table, and I've gone
> months without any problems (with many different sets of polygons too)
>
> I tried st_isvalid() on all polygons returned from the subselect, and
> all are valid, and are all non-null...
> If I have duplicate (or close to duplicate) polygons returned, is that
> going to potentially screw up st_union()?
>
>
> I'm running Ubuntu server (x64) 8.04 LTS, and am using the packages
> for GEOS and postgis from their universe repo:
>
> postgis 1.3.3
> libgeos 2.2.3
>
> (postgresql 8.3)
>
>
> Thanks for the help!
>
> -Mark
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>   

-- 
Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022




More information about the postgis-users mailing list