All Products
Search
Document Center

PolarDB:ST_Intersects

Last Updated:Aug 22, 2024

This topic describes the ST_Intersects function. This function checks whether a raster object intersects with another raster object or a geometry object in the same spatial reference system.

Syntax

boolST_Intersects(raster rast1, raster rast2);
boolST_Intersects(raster rast, geometry geom);
boolST_Intersects(geometry geom,raster rast);

Parameters

Parameter

Description

rast1

Raster object 1.

rast2

Raster object 2.

rast

The raster object.

geom

The geometry object.

Examples

SELECT a.id FROM tbl_a a, tbl_b b WHERE ST_Intersects(a.rast, b.rast);
 id
----
  1
(1 row)