[postgis-users] Problem with the overlap operator && (?)

Rob Tester robtester at gmail.com
Tue Nov 14 20:21:27 PST 2006


I recently (with my install of 1.1.5) have run into something that is
puzzling me about the overlaps operator. I have two tables that I am
comparing the geometry objects using the following SQL:

select overlaps(a.wkb_geometry,b.wkb_geometry),a.primaryKey,b.primaryKey
from az_cr9 a,az_kz b where a.primaryKey=2203 and b.primaryKey=293546 and
a.wkb_geometry&&b.wkb_geometry

This returns one row:

f;2203;293546

My question is how does the overlaps operator return TRUE and the overlaps
function return FALSE. In fact the two geometries in question do not close
to each other. Is this operator broken?

This query returns no rows as expected:

select
overlaps(a.wkb_geometry,b.wkb_geometry),a.cr_id,b.ogc_fid,b.blockgroupid,
b.blockid
from az_carrierroute9 a,az_kz_calculated_test b where a.ogc_fid=2203 and
b.ogc_fid=293546 and overlaps(a.wkb_geometry,b.wkb_geometry)


Any help on this?

Rob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061114/7a43befb/attachment.html>


More information about the postgis-users mailing list