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

[Kevin Neufeld]

Hi Andreas,

I was wondering if you were still having problems with this.  If so, can 
you isolate the geometries that are causing the error?  This would help 
in tracking down the problem and perhaps with regression tests later.

Cheers,

-------------
Kevin Neufeld
Software Developer
Refractions Research Inc.
300-1207 Douglas St.
Victoria, B.C., V8W 2E7

Phone: (250) 383-3022
Email: kneufeld at refractions.net


Andreas Laggner wrote:
> Hi users and developers,
>
> with the approach from Kevin 
> http://postgis.refractions.net/support/wiki/index.php?ExamplesOverlayTables 
> i have a similar problem, it seems to me something in the data causes 
> that, but what is it and how can i find it??
>
> I first do:
> -- 1. Extract the linework from the polygons (you may wish to add any 
> interior rings to this query)
>
> CREATE TABLE all_lines AS
>   SELECT St_ExteriorRing (the_geom) AS the_geom FROM ffh_singlerep
>   UNION ALL
>   SELECT St_ExteriorRing (the_geom) AS the_geom FROM spa_singlerep;
>
> that works good, but this query:
> -- 2. Node the linework
>
> CREATE TABLE noded_lines AS
>   SELECT St_Union(the_geom) AS the_geom
>   FROM all_lines;
>
> ends up with this Error:
> NOTICE:  St9bad_alloc
> ERROR: GEOS union() threw an error!
> SQL Status:XX000
>
> Cheers      Andreas
>