DocsICP FilingConsole
Documentation

&&&

Updated at:
Copy as MD
Product
My Favorites

Determines whether the spatial extent of the geographic grid object intersects with a 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 geometric object must use the CGC2000 spatial reference (SRID=4490).

Examples

SELECT ST_GridFromText('GZ00262064446046072072') &&&
'srid=4490;POINT(116.31522216796875 39.910277777777778 1001.8)'::geometry;
 st_3dintersects 
-----------------
 f

SELECT ST_GridFromText('GZ00262064') &&& ST_GridFromText('GZ00262063');
 st_3dintersects 
-----------------
 t