<html>
<head>
</head>
<body>Hallo Martijn
<div><br />
</div>
<div>Here is more than one problem I think.</div>
<div><br />
</div>
<div>In the case of ST_Overlaps and ST_Intersects they only work on 2d.</div>
<div><br />
</div>
<div>ST_3DIntersects work on 3d or actually 2.5d because the function doesn't understand volumes which a box is. </div>
<div>I am actually not sure how the box is casted before feeded as a geoemtry to the functions. Someone might answer that.</div>
<div><br />
</div>
<div>About the behavior of &&& I am also confused, and maybe suspects something not working as expected.</div>
<div>I thought &&&-operator would work on the box type.</div>
<div><br />
</div>
<div>/Nicklas</div>
<div><br />
</div>
<div><br />
</div>
<div><br />
</div>
<div><br />
</div>
<div><br />
</div>
<div><br />
<br />
2014-06-20 Martijn Meijers wrote:<br />
<br />
Hi,<br />
><br />
>I am rather puzzled by the following:<br />
><br />
>select 'BOX3D(0 0 0, 10 10 10)'::box3d &&& 'BOX3D(0 0 90, 10 10 <br />
>100)'::box3d;<br />
> ?column?<br />
>----------<br />
> t<br />
><br />
>select st_overlaps('BOX3D(0 0 0, 10 10 10)'::box3d, 'BOX3D(0 0 90, 10 10 <br />
>100)'::box3d);<br />
> st_overlaps<br />
>-------------<br />
> f<br />
><br />
>select st_intersects('BOX3D(0 0 0, 10 10 10)'::box3d, 'BOX3D(0 0 90, 10 <br />
>10 100)'::box3d);<br />
> st_intersects<br />
>---------------<br />
> t<br />
>(1 row)<br />
><br />
><br />
>Should these queries not all return false (as the boxes do not share any <br />
>space)?<br />
>Or is it because these functions do not (yet) support 3D (and operate on <br />
>the projected 2D primitives)?<br />
>If so, I find the documentation for the &&& operator rather confusing...<br />
><br />
><br />
>Martijn<br />
><br />
>-- <br />
>Martijn Meijers<br />
><br />
>mailto:b.m.meijers@tudelft.nl<br />
>http://www.gdmc.nl/martijn<br />
><br />
>GIS-technology<br />
>Faculty of Architecture and the Built Environment<br />
>Delft University of Technology<br />
><br />
>P.O. Box 5030 | Jaffalaan 9 (Building 30)<br />
>2600 GA Delft | 2628 BX Delft<br />
>The Netherlands<br />
><br />
>tel (+31) 15 2785642<br />
>fax (+31) 15 2782745<br />
><br />
>_______________________________________________<br />
>postgis-users mailing list<br />
>postgis-users@lists.osgeo.org<br />
>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br />
><br />
>
</div>
</body>
</html>