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.
|
|
|
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