[postgis-users] ERROR: GEOS union() threw an error!

[Ethan Alpert]

Well issimple returns t for all.


spatialdb=> select issimple(the_geom) from snaps where stripid
='101001000351ED00';
 issimple 
----------
 t
 t
 t
(3 rows)

I do have geos 1.0 so I'll try that. Does upgrading geo require me to
rebuild postgis?

-e


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
strk at refractions.net
Sent: Tuesday, October 12, 2004 12:39 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] ERROR: GEOS union() threw an error!


On Tue, Oct 12, 2004 at 12:08:58PM -0600, Ethan Alpert wrote:
> 
> 
> Why does the following throw an error?

Run issimple() on them as the first thing when facing these problems. If
all input are simple try newer GEOS (if running GEOS-1.0.0). --strk;

> 
> Error Msg:
> 
> spatialdb=> select geomunion(the_geom) from snaps where 
> stripid='101001000351ED00';
> NOTICE:  TopologyException: no outgoing dirEdge found 
> (127.169,38.0556)
> ERROR:  GEOS union() threw an error!
> 
> 
> Here's the Geometries:
> 
> spatialdb=> select catfrag, stripid,AsText(the_geom) from snaps where 
> stripid='101001000351ED00'; -[ RECORD 1
>
]-----------------------------------------------------------------------
>
------------------------------------------------------------------------
> ---------------------------
> catfrag | 101001000351ED013757480
> stripid | 101001000351ED00
> astext  | POLYGON((126.9405 38.2139166666667,127.171686111111
> 38.2092055555556,127.168805555556 38.0372638888889,126.941602777778
> 38.0439083333333,126.9405 38.2139166666667))
> -[ RECORD 2
>
]-----------------------------------------------------------------------
>
------------------------------------------------------------------------
> ---------------------------
> catfrag | 101001000351ED022377883
> stripid | 101001000351ED00
> astext  | POLYGON((126.941597222222 38.0758111111111,127.169166666667
> 38.0698111111111,127.16855 37.9064833333333,126.942888888889
> 37.9145527777778,126.941597222222 38.0758111111111))
> -[ RECORD 3
>
]-----------------------------------------------------------------------
>
------------------------------------------------------------------------
> ---------------------------
> catfrag | 101001000351ED023757478
> stripid | 101001000351ED00
> astext  | POLYGON((126.941597222222 38.0758111111111,127.169166666667
> 38.0698111111111,127.16855 37.9064833333333,126.942888888889
> 37.9145527777778,126.941597222222 38.0758111111111))
> 
> 
> Here's where it get's odd:
> 
> spatialdb=> select geomunion(the_geom) from snaps where 
> catfrag='101001000351ED022377883' or catfrag='101001000351ED023757478'

> or catfrag='101001000351ED013757480';
> -[ RECORD 1
> ]---------------------------------------------------------------------
> --
>
------------------------------------------------------------------------
>
------------------------------------------------------------------------
> -----------------------------------------------------
> geomunion | SRID=4326;POLYGON((126.9405
> 38.2139166666667,127.171686111111 38.2092055555556,127.169113088743
> 38.0556206842087,127.16855 37.9064833333333,126.942888888889
> 37.9145527777778,126.941852819554 38.0439010209725,126.941602777778
> 38.0439083333333,126.9405 38.2139166666667))
> 
> 
> Why does this work when I manually query on the tables index? Note two

> of the geometries are the same. If I delete either the geomunion 
> works. The geometries are all SRID=4326
> 
> I'm running postgres 7.4.3 and postgis 0.8.2
> 
> Time for an upgrade? Very odd behavior...IMHO 
> _______________________________________________
> 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