This topic describes the @@> operator. This operator indicates whether the spatial range represented by a 3D 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 function 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_3dcontains
-----------------
t
SELECT ST_GridFromText('GZ00262064') @@> ST_GridFromText('GZ002620643');
st_3dcontains
-----------------
t