search

pacificclimate / climate-explorer-frontend

6 stars 1 forks source link

Add clear statement of data provenance to Help #207

Open rod-glover opened 5 years ago

rod-glover commented 5 years ago

It's not yet clear to me whether all the data we present is, for example, downscaled (and that all by BCCAQ v2), or whether we present other data as well, and if so in what cases. Research this and document it in Help.

corviday commented 5 years ago

All data in the current default ensemble, ce_files, should be either downscaled output or indices derived from downscaled output. We do have some non-downscaled output indexed, in the all_GCM_files ensemble, but we're not currently using it.

SELECT dISTINCT
  grids.cell_avg_area_sq_km, 
  ensembles.ensemble_name
FROM 
  ce_meta.ensemble_data_file_variables, 
  ce_meta.ensembles, 
  ce_meta.data_file_variables, 
  ce_meta.grids
WHERE 
  ensemble_data_file_variables.data_file_variable_id = data_file_variables.data_file_variable_id AND
  ensembles.ensemble_id = ensemble_data_file_variables.ensemble_id AND
  data_file_variables.grid_id = grids.grid_id
ORDER BY 
  ensembles.ensemble_name;
cell_avg_area_sq_km ensemble_name
50.3769761 all_CLIMDEX_files
39.1264624427 all_CLIMDEX_files
39.1264624427 all_downscale_files
63195.5916396 all_files
23809.133655 all_files
67525.9255288 all_files
27952.9094026 all_files
24943.4500577 all_files
2498.26621146 all_files
50.3769761 all_files
4445.88319573 all_files
55923.0249809 all_files
39.1264624427 all_files
9272.34170328 all_files
37282.0166539 all_files
39788.9358574 all_files
15684.9702695 all_files
37230.1086836 all_files
10023.4067549 all_files
18447.7806963 all_files
73782.3415959 all_files
39.1264624427 ce_files
39.1264624427 climdex_climos
39.1264624427 extreme_precipitation
39.1264624427 test_precipitation

The metadata database doesn't track which downscaling algorithm was used, though, so I don't know of a similarly easy way to answer that question. (Though I think we can tell from this that none of the data in this database is BCCAQ version 2, which is a much finer grid than BCCAQ version 1.)

corviday commented 5 years ago

I was wrong. The return_period and degree_day datasets are BCCAQv2.