PostGIS

ST_Intersects

Prev

12.17. Raster and Raster Band Spatial Relationships

Next

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

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

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

See Also

Prev

Up

Next

ST_Disjoint

Home

ST_Overlaps