This topic describes the <@@ operator. This operator specifies whether the spatial range of a geographic grid is included by 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 'srid=4490;POINT(116.31522216796875 39.910277777777778 1001.8)'::geometry,
<@@ ST_GridFromText('GZ00262064446046072072');
st_3dwithin
-----------------
t
SELECT ST_GridFromText('GZ0026206435') <@@ ST_GridFromText('GZ002620643');
st_3dwithin
-----------------
t