[postgis-users] Re: st_union exception

Martin Davis mbdavis at refractions.net
Thu Jan 15 11:59:52 PST 2009


I have to confess I'm not sure what the best or most current version is 
- perhaps the list can help out?

Mark Mitchell wrote:
> It is an older version of PostGIS/GEOS (1.3.3 and 2.2.3) -- which
> version of GEOS are you using?
>
> -Mark
>
>   
>> 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
>>     
> _______________________________________________
> 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