Calculates statistics for a specified set of bands in a raster object.
Syntax
raster ST_SummaryStats(raster raster_obj)
raster ST_SummaryStats(raster raster_obj, cstring statsOption)
raster ST_SummaryStats(raster raster_obj,
cstring bands,
cstring statsOption)Parameters
| Parameter | Description |
|---|---|
raster_obj | The name of the raster object. |
bands | The sequence numbers of the bands. Accepts an array of integers or an integer range. Sequence numbers start from 0. Examples: '0', '1-3', '1,2,3'. |
statsOptions | A JSON string specifying the statistics to calculate. |
The statsOptions parameter accepts the following field:
| Field | Type | Default | Description |
|---|---|---|---|
approx | Boolean | true | Specifies whether to use the sampling method to calculate statistics. true: uses sampling, results may be approximate. false: calculates all statistics. |
Examples
UPDATE raster_obj SET raster_obj=ST_SummaryStats(raster_obj) WHERE id = 1;
UPDATE rast SET rast=ST_SummaryStats(rast,'0-2','{"approx":false}') WHERE id = 1;
UPDATE rast SET rast=ST_SummaryStats(rast,'{"approx":false}') WHERE id = 1;