Name
ST_Intersects — Return true if raster rastA spatially intersects raster rastB.
Synopsis
boolean ST_Intersects(
raster
rastA
,
integer
nbandA
,
raster
rastB
,
integer
nbandB
);
boolean ST_Intersects(
raster
rastA
,
raster
rastB
);
boolean ST_Intersects(
raster
rast
,
integer
nband
,
geometry
geommin
);
boolean ST_Intersects(
raster
rast
,
geometry
geommin
,
integer
nband=NULL
);
boolean ST_Intersects(
geometry
geommin
,
raster
rast
,
integer
nband=NULL
);
Description
Return true if raster rastA spatially intersects raster rastB. If the band number is not provided (or set to NULL), only the convex hull of the raster is considered in the test. If the band number is provided, only those pixels with value (not NODATA) are considered in the test.
![[Note]](../images/note.png)
|
|
|
This function will make use of any indexes that may be available on the rasters. |
Enhanced: 2.0.0 support raster/raster intersects was introduced.
![[Warning]](../images/warning.png)
|
|
|
Changed: 2.1.0 The behavior of the ST_Intersects(raster, geometry) variants changed to match that of ST_Intersects(geometry, raster). |
Examples
-- different bands of same raster
SELECT ST_Intersects(rast, 2, rast, 3) FROM dummy_rast WHERE rid = 2;
st_intersects
---------------
t