All Products
Search

This Product

    PolarDB:&&&

    Document Center

    PolarDB:&&&

    Last Updated:Mar 28, 2026

    Returns true if the spatial range of a geographic grid intersects with a geometry, and false otherwise.

    All geometries must use the CGC2000 spatial reference system with a Spatial Reference System Identifier (SRID) of 4490.

    Syntax

    -- geomgrid ↔ standard geometry
bool &&&(geometry geom3d, geomgrid gridcode);
bool &&&(geomgrid gridcode, geometry geom3d);

-- geomgrid ↔ mesh geometry
bool &&&(meshgeom geom3d, geomgrid gridcode);
bool &&&(geomgrid gridcode, meshgeom geom3d);

-- geomgrid ↔ surface mesh
bool &&&(sfmesh geom3d, geomgrid gridcode);
bool &&&(geomgrid gridcode, sfmesh geom3d);

-- geomgrid ↔ volumetric mesh
bool &&&(vomesh geom3d, geomgrid gridcode);
bool &&&(geomgrid gridcode, vomesh geom3d);

-- geomgrid ↔ geomgrid
bool &&&(geomgrid gridcode1, geomgrid gridcode2);

    Parameters

    ParameterDescription
    gridcode / gridcode1 / gridcode2The geographic grid object.
    geom3dThe 3D geometry.

    Usage notes

    • The geometry must use the CGC2000 spatial reference system. The SRID must be 4490.

    • Returns true if the spatial ranges intersect, and false if they do not.

    Examples

    Example 1: Check if a grid intersects a point (result: false)

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

    Example 2: Check if two grids intersect (result: true)

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