The mentioned function
Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a raster or raster coverage.
I have an image of land cover classes (a discrete dataset), returning the mean does not make much sense since there are only classes (essentially integer numbers).
The procedure is like this: the image is clipped (using ST_clip) to the extent of a polygon (representing multiple farm fields) and then the dominant (majority) land cover class should be determined.
- How to get the majority from the
- How to modify
ST_SummaryStatsAgg()to calculate the majority?
- Is there another function/procedure that gives me the result that I want?