PostGIS
Name
&&&(gidx,gidx) — Returns TRUE if two n-D float precision bounding
boxes (GIDX) intersect each other.
Description
The &&& operator returns TRUE if two n-D bounding boxes A and B
intersect each other, using float precision. This means that if A (or B)
is a (double precision) box3d, it will be internally converted to a
float precision 3D bounding box (GIDX)
|
Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. Requires PostgreSQL 9.5+.
This
method supports Circular Strings and Curves.
This
function supports Polyhedral surfaces.
This
function supports Triangles and Triangulated Irregular Network Surfaces
(TIN).
This
function supports 3d and will not drop the z-index.
Examples
SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&& ST_3DMakeBox(ST_MakePoint(1,1,1), ST_MakePoint(3,3,3)) AS overlaps;
overlaps
----------
t
(1 row)