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

[Ethan Alpert]

But I shouldn't have to rebuild postgres right? 

-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 1:08 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] ERROR: GEOS union() threw an error!


On Tue, Oct 12, 2004 at 12:59:00PM -0600, Ethan Alpert wrote:
> 
> 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?

Unfortunately YES.
--strk;

> 
> -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
> _______________________________________________
> 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