Navigation :

ST_DFullyWithin

ST_DFullyWithin
Prev   10.17. Raster and Raster Band Spatial Relationships   Next

Name

ST_DFullyWithin — Return true if rasters rastA and rastB are fully within the specified distance of each other.

Synopsis

boolean ST_DFullyWithin ( raster rastA , integer nbandA , raster rastB , integer nbandB , double precision distance_of_srid ) ;

boolean ST_DFullyWithin ( raster rastA , raster rastB , double precision distance_of_srid ) ;

Description

Return true if rasters rastA and rastB are fully within the specified distance of each 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.

The distance is specified in units defined by the spatial reference system of the rasters. For this function to make sense, the source rasters must both be of the same coordinate projection, having the same SRID.

[Note]

This operand 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_DFullyWithin(ST_Polygon(raster), geometry).

Availability: 2.1.0

Examples 

SELECT r1.rid, r2.rid, ST_DFullyWithin(r1.rast, 1, r2.rast, 1, 3.14) FROM dummy_rast r1 CROSS JOIN dummy_rast r2 WHERE r1.rid = 2;

 rid | rid | st_dfullywithin
-----+-----+-----------------
   2 |   1 | f
   2 |   2 | t

See Also

ST_Within , ST_DWithin

Prev   Up   Next
ST_DWithin  Home  Chapter 11. PostGIS Extras