pacificclimate / climate-explorer-data-prep

0 stars 0 forks source link

fdETCCDI HadGEM data has incorrect emissions scenarios #111

Open corviday opened 4 years ago

corviday commented 4 years ago
SELECT 
  COUNT(emissions.emission_short_name),
  emissions.emission_short_name,
  models.model_short_name
FROM 
  ce_meta.data_file_variables, 
  ce_meta.data_files, 
  ce_meta.models, 
  ce_meta.runs, 
  ce_meta.emissions
WHERE 
  data_files.run_id = runs.run_id AND
  data_files.data_file_id = data_file_variables.data_file_id AND
  runs.model_id = models.model_id AND
  emissions.emission_id = runs.emission_id AND
  data_file_variables.netcdf_variable_name = 'fdETCCDI' AND 
  models.model_short_name LIKE 'HadGEM%'
GROUP BY model_short_name, emission_short_name;
count emission_short_name model_short_name
15 historical, rcp45 HadGEM2-ES
17 historical, rcp85 HadGEM2-ES
3 historical,rcp85 HadGEM2-CC
18 historical, rcp45 HadGEM2-CC
16 historical, rcp85 HadGEM2-CC
3 historical,rcp85 HadGEM2-ES

Likely an artifact of having to process the 2070-2099 climatology seperately. Needs to be updated, or PCEX, which has built-in assumptions about how emissions scenarios are phrased, will be confused.

corviday commented 4 years ago

I've updated the files, but not yet the entries in the database.