I have function which calculates monthly means from an image collection

var UK_SST = ee.ImageCollection('NOAA/CDR/SST_WHOI/V2').select('sea_surface_temperature')
    .filterDate(ee.Date('1990-01-01'), ee.Date('2019-01-01'))

// month data for dataset

var startyear = 1990; 
var endyear = 2019; 

var startmonth = 1;
var endmonth = 12;

var startdate = ee.Date.fromYMD(startyear, startmonth, 1);
var enddate = ee.Date.fromYMD(endyear , endmonth, 1);

var years = ee.List.sequence(startyear, endyear);

var months = ee.List.sequence(1, 12);
var monthlySST =  ee.ImageCollection.fromImages(
  years.map(function (y) {
    return months.map(function(m) {
      var w = UK_SST.filter(ee.Filter.calendarRange(y, y, 'year'))
                .filter(ee.Filter.calendarRange(m, m, 'month'))
      return w.set('year', y)
          .set('month', m)
          .set('system:time_start', ee.Date.fromYMD(y, m, 1));


I'm looking to set the band value as a property so I can export the image collection as a csv with the band values contained. However, when I try to set this

  .set("sst_mean", w.get("sea_surface_temperature"))

In this part of the function.

  return w.set('year', y)
          .set('month', m)
          .set("sst_mean", res.get("sea_surface_temperature"))
          .set('system:time_start', ee.Date.fromYMD(y, m, 1));

Nothing gets set. Any ideas?

1 Answer 1


Your w is an image where each pixel contains monthly means. Maybe you're looking the mean across your entire ROI? If so, you have to call w.reduceRegion().

Try something like this:

// Picking the scale from the first image in the collection
var scale = UK_SST.first().projection().nominalScale()

var months = ee.List.sequence(1, 12);
var monthlySST =  ee.FeatureCollection(
  years.map(function (y) {
    return ee.FeatureCollection(months.map(function(m) {
      var w = UK_SST.filter(ee.Filter.calendarRange(y, y, 'year'))
                .filter(ee.Filter.calendarRange(m, m, 'month'))
      var dict = w.reduceRegion({
        reducer: ee.Reducer.mean(),
        geometry: ROI,
        scale: scale,
        maxPixels: 1e13
      var sst_mean = ee.Algorithms.If(
      return ee.Feature(null, {
        'sst_mean': sst_mean,
          'year': y,
          'month': m,
          'system:time_start': ee.Date.fromYMD(y, m, 1)


  • Thanks Daniel. Unfortunately when I run this I get the error 'User memory limit exceeded'. code.earthengine.google.com/4a36bb31a2f7ae260f91f18e77057e5a Mar 20, 2020 at 16:19
  • Try to export the results instead of printing. Mar 20, 2020 at 19:45
  • Exporting doesn't seem to work, file just continues. Could it be that the shapefile/asset i'm using for my ROI is too big? A much smaller shapefile from another region seems to work fine. Mar 23, 2020 at 9:30
  • That was the issue, so our code works perfectly! Mar 23, 2020 at 13:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.