[postgis-users] error with overlay and disjoint
venturato at faunalia.it
Mon Oct 17 07:05:56 PDT 2005
I'm trying to extract from a postgis table (the_geom of table1: 25.000
records) all the id of that records wich overlay (also partially) with a
study_area (the_geom of table2).
select a.id, disjoint (a.the_geom, b.the_geom) from table1 a, table2 b where
disjoint (a.the_geom, b.the_geom) is false;
select a.id, overlay (a.the_geom, b.the_geom) from table1 a, table2 b where
overlay (a.the_geom, b.the_geom) is true;
In both queries, I had an error:
ERROR: GEOS disjoin() threw an error!
ERROR: GEOS overlay() threw an error!
I tryed with a subsample (900 records) and the select worked.
Have you same suggestion? Could it be a problem in the (too large?) number of
Thank you in advance.
venturato at faunalia.it venturato at jabber.org www.faunalia.it
Piazza Garibaldi 4 56025 Pontedera (PI) Italy
Tel: (+39) 347-2770007 Fax (+39) 0587-213742
Linux User: 388585 http://counter.li.org
More information about the postgis-users