This topic describes the ST_Contains function. This function checks whether a raster object contains another raster object or a geometry object in the same spatial reference system.
Syntax
boolST_Contains(raster rast1, raster rast2);
boolST_Contains(raster rast, geometry geom);
boolST_Contains(geometry geom,raster rast);Parameters
Parameter | Description |
rast1 | Raster object 1. |
rast2 | Raster object 2. |
rast | The raster object. |
geom | The geometric object. |
Examples
SELECT a.id FROM tbl_a a, tbl_b b WHERE ST_Contains(a.rast, b.rast);
id
----
1
(1 row)