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

[Andreas Laggner]

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

-- 
Dipl. Geoökologe Andreas Laggner
Institut für Ländliche Räume (LR)
Bundesforschungsanstalt für Landwirtschaft (FAL)

Institute of Rural Studies
Federal Agricultural Research Centre (FAL)

Bundesallee 50
D-38116 Braunschweig

Tel.: (+49) (0)531 596 5515
Fax: (+49) (0)531 596 5599
E-mail: andreas.laggner at fal.de
Homepage: http://www.lr.fal.de/