[postgis-users] box3d overlap

Martijn Meijers b.m.meijers at tudelft.nl
Fri Jun 20 03:00:43 PDT 2014


Hi,

I am rather puzzled by the following:

select 'BOX3D(0 0 0, 10 10 10)'::box3d &&& 'BOX3D(0 0 90, 10 10 
100)'::box3d;
  ?column?
----------
  t

select st_overlaps('BOX3D(0 0 0, 10 10 10)'::box3d, 'BOX3D(0 0 90, 10 10 
100)'::box3d);
  st_overlaps
-------------
  f

select st_intersects('BOX3D(0 0 0, 10 10 10)'::box3d, 'BOX3D(0 0 90, 10 
10 100)'::box3d);
  st_intersects
---------------
  t
(1 row)


Should these queries not all return false (as the boxes do not share any 
space)?
Or is it because these functions do not (yet) support 3D (and operate on 
the projected 2D primitives)?
If so, I find the documentation for the &&& operator rather confusing...


Martijn

-- 
Martijn Meijers

mailto:b.m.meijers at tudelft.nl
http://www.gdmc.nl/martijn

GIS-technology
Faculty of Architecture and the Built Environment
Delft University of Technology

P.O. Box 5030 | Jaffalaan 9 (Building 30)
2600 GA Delft | 2628 BX Delft
The Netherlands

tel (+31) 15 2785642
fax (+31) 15 2782745



More information about the postgis-users mailing list