@ / />-AnalyticDB(AnalyticDB)-阿里云帮助中心

Checks if a grid object contains a geometry object.

Syntax

boolean @>(geomgrid grid, geometry geom);
boolean @>(geometry geom, geomgrid grid);
boolean @>(geomgrid grid1, geomgrid grid2);

Parameters

Parameter Name	Description
grid	The grid object.
geom	The geometry object.

Description

The spatial reference of the geometric object must be CGC2000 (SRID=4490).

Examples

select ST_gridfromtext('G001331032213300013') @>
      ST_geomfromtext('POINT(116.31522216796875 39.910277777777778)',4490) as t;

 t
---------------
 f
 
select ST_gridfromtext('G00133103221330') @>
       ST_gridfromtext('G001331032213300013') as t
                    
 t 
-------------
 t