Currently, the docs for
ST_Resample() give options for
NearestNeighbor (English or American spelling),
Lanczos resampling algorithm.
In the same page, they give a link (http://www.gdal.org/gdalwarp.html) to the GDAL warp resampling methods in which
average is an option. However, after running it with
average as a parameter for the
st_resample function, it spit out the same raster (values are the same) with a different pixel size. The funny thing is, running
st_valuecount on the two rasters gives the identical number of pixels too which doesn't make sense.
I would like to resample my 10m raster to a 30m raster resolution by calculating the average within each 30m grid. Any ideas?