@@>

更新时间:
复制 MD 格式

Checks if the spatial extent of the geographic grid object contains the geometric 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.

Description

The spatial reference of the geometric object must be CGC2000 (SRID=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