This topic describes the &&& operator. This operator specifies whether the spatial range of a geographic grid intersects with a geometry.
Syntax
bool &&&(geometry geom3d, geomgrid gridcode);
bool &&&(geomgrid gridcode, geometry geom3d);
bool &&&(meshgeom geom3d, geomgrid gridcode);
bool &&&(geomgrid gridcode, meshgeom geom3d);
bool &&&(sfmesh geom3d, geomgrid gridcode);
bool &&&(geomgrid gridcode, sfmesh geom3d);
bool &&&(vomesh geom3d, geomgrid gridcode);
bool &&&(geomgrid gridcode, vomesh geom3d);
bool &&&(geomgrid gridcode1, geomgrid gridcode2);Parameters
Parameter | Description |
gridcode/gridcode1/gridcode2 | The geographic grid object. |
geom3d | The 3D geometry. |
Description
This operator returns the spatial relationship between a grid and a geometry. The geometry must use the CGC2000 spatial reference system. In addition, the spatial reference system identifier (SRID) of the geometry must be 4490.
Examples
SELECT ST_GridFromText('GZ00262064446046072072') &&&
'srid=4490;POINT(116.31522216796875 39.910277777777778 1001.8)'::geometry;
st_3dintersects
-----------------
f
SELECT ST_GridFromText('GZ00262064') &&& ST_GridFromText('GZ00262063');
st_3dintersects
-----------------
t