AnsweredAssumed Answered

Build a model to calculate monthly average from daily rainfall rasters

Question asked by jessica.m.moran on May 22, 2018
Latest reply on May 24, 2018 by xander_bakker

Hi All,


I have rainfall rasters for each day of the decade 2000 - 2009. Each file is named with the format rYYYYMMDD (eg r20001224 is the rainfall raster for Dec 24th 2000).


I would like to create 'monthly average rainfall' rasters for each month in this decade (10 years x 12 months = 120 rasters).


Rather than manually selecting each daily raster in a month, is there a way to get ArcGIS to select rasters with a common prefix as the input to Raster Calculator? i.e. generate a new raster by averaging all rasters named 'r200001__' (from January 2000). 


Ideally, I would like to iterate this process in Model Builder using the Raster Calculator. I'm inexperienced with python coding, but I'm happy to learn if it's the only/best way.

Any advice is appreciated!