Navigation :

ST_Overlaps

ST_Overlaps
Prev   10.17. Raster and Raster Band Spatial Relationships   Next

Name

ST_Overlaps — Return true if raster rastA and rastB intersect but one does not completely contain the other.

Synopsis

boolean ST_Overlaps ( raster rastA , integer nbandA , raster rastB , integer nbandB ) ;

boolean ST_Overlaps ( raster rastA , raster rastB ) ;

Description

Return true if raster rastA spatially overlaps raster rastB. This means that rastA and rastB intersect but one does not completely contain the other. 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.

[Note]

To test the spatial relationship of a raster and a geometry, use ST_Polygon on the raster, e.g. ST_Overlaps(ST_Polygon(raster), geometry).

Availability: 2.1.0

Examples 

-- comparing different bands of same raster
SELECT ST_Overlaps(rast, 1, rast, 2) FROM dummy_rast WHERE rid = 2;

 st_overlaps
-------------
 f

See Also

ST_Intersects

Prev   Up   Next
ST_Intersects  Home  ST_Touches