[postgis-users] box3d overlap

[Nicklas Avén]

Hallo Martijn


Here is more than one problem I think.


In the case of ST_Overlaps and ST_Intersects they only work on 2d.


ST_3DIntersects work on 3d or actually 2.5d because the function doesn't understand volumes which a box is. 
I am actually not sure how the box is casted before feeded as a geoemtry to the functions. Someone might answer that.


About the behavior of &&& I am also confused, and maybe suspects something not working as expected.
I thought &&&-operator would work on the box type.


/Nicklas












2014-06-20 Martijn Meijers  wrote:

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
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140620/fba99110/attachment.html>