Navigation :

ST_Intersects

ST_Intersects
Prev 9.13. 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

ST_Intersection , ST_Disjoint

Prev Up Next
ST_Disjoint Home ST_Overlaps