[postgis-users] error with overlay and disjoint

Emilia Venturato venturato at faunalia.it
Mon Oct 17 07:05:56 PDT 2005

Hi all,

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).
I try:

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.
(Emi)Lia Venturato
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 mailing list