How to use the <@@ operator in GeomGridSQL-阿里云帮助中心

Checks if the first object is spatially contained within the second object.

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 Name	Description
gridcode/gridcode1/gridcode2	The geographic grid object.
geom3d	The 3D geometry object.

Description

The geometry object must use the CGC2000 spatial reference system. Its spatial reference identifier (SRID) must be 4490.

Example

SELECT ST_GridFromText('GZ0026206435') <@@ ST_GridFromText('GZ002620643');
 st_3dwithin 
-----------------
 t