Opened 10 years ago

Last modified 4 years ago

#1193 new enhancement

[raster] Add the possibility to aggregate values when rescaling with ST_Rescale()

Reported by: pracine Owned by: pracine
Priority: low Milestone: PostGIS Fund Me
Component: raster Version: main
Keywords: Cc:


It would be nice to be able to compute aggregate values when rescaling a raster like this:

So in addition to the standard resampling algorythms (NearestNeighbor?, Bilinear, Cubic, CubicSpline? and Lanczos) we could use "sum", "count", "mean", "max", "min", "median".

The count would count the number of pixel with value (ignoring nodata values).

Event if this operation is VERY similar to rescale it could be named ST_Aggregate instead. It would accept a size (in pixel) for the aggregate pixel area and an aggregate type (sum", "count", "mean", "max", "min", "median").

If the resample code base (based on GDAL) could be reuse or if a totally new function has to be written is to be determined.

Change History (3)

comment:1 Changed 10 years ago by Bborie Park

I don't think this will be possible using the established ST_Resample. Using ST_Aggregate is a better solution.

comment:2 Changed 9 years ago by pracine

Milestone: PostGIS Raster FuturePostGIS Future

comment:3 Changed 4 years ago by robe

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.