ST_Count
Name
ST_Count — Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata value.
Synopsis
bigint
ST_Count
(
raster
rast
, integer
nband=1
, boolean
exclude_nodata_value=true
)
;
bigint
ST_Count
(
raster
rast
, boolean
exclude_nodata_value
)
;
Description
Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified
nband
defaults to 1.
![[Note]](./images/note.png)
|
|
|
If
|
Changed: 3.1.0 - The ST_Count(rastertable, rastercolumn, ...) variants removed. Use ST_CountAgg instead.
Availability: 2.0.0
Examples
--example will count all pixels not 249 and one will count all pixels. --
SELECT rid, ST_Count(ST_SetBandNoDataValue(rast,249)) As exclude_nodata,
ST_Count(ST_SetBandNoDataValue(rast,249),false) As include_nodata
FROM dummy_rast WHERE rid=2;
rid | exclude_nodata | include_nodata
-----+----------------+----------------
2 | 23 | 25