PostGIS
Name
&&&(gidx,geometry) — Returns TRUE if a n-D float precision bounding
box (GIDX) intersects a geometry’s (cached) n-D bounding box.
Description
The &&& operator returns TRUE if the n-D bounding box A
intersects the cached n-D bounding box of geometry B, using float
precision. This means that if A 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_MakePoint(1,1,1) AS overlaps;
overlaps
----------
t
(1 row)