Difference between revisions of "Calculation of Climatology"

From Agri4castWiki
Jump to: navigation, search
Line 15: Line 15:
  
 
Besides the average also minimum, maximum, standard deviation and count are calculated (observed weather only).These data are stored in:
 
Besides the average also minimum, maximum, standard deviation and count are calculated (observed weather only).These data are stored in:
*{{Object|WEATHER_OBS_GRID_LTA}}
+
* WEATHER_OBS_GRID_LTA
*{{Object|WEATHER_OBS_REGIONCOVER_LTA}}
+
* WEATHER_OBS_REGIONCOVER_LTA
*{{Object|WEATHER_ERA_GRID_LTA}}
+
* WEATHER_ERA5_GRID_LTA
*{{Object|WEATHER_ERA_REGIONCOVER_LTA}}
+
* WEATHER_ERA5_REGIONCOVER_LTA
  
To properly compare threshold-indicators like rainy days, hot days, cold days and tempature sums (above or below a minimum threshold), calculated over a certain period, with the long term average these long term average values should not be derived from climatology. This would lead to underestimation of the extremes. In stead first the threshold-indicator must be calculated for each historic year and the outcome must be averaged over all historic years. To enhance performance in visualization additional data are stored on the long term average tables that express the chance of an event e.g. the chance that a certain day has a rainfall event larger than 5 mm. Similary the average temperature above a threshold is stored. Using these additional data 'average' values of threshold-indicators can be calculated properly without accessing data of all historic years. In detail:  
+
To properly compare threshold-indicators at grid level like rainy days, hot days, cold days and tempature sums (above or below a minimum threshold), calculated over a certain period, with the long term average these long term average values should not be derived from climatology. This would lead to underestimation of the extremes. In stead first the threshold-indicator must be calculated for each historic year and the outcome must be averaged over all historic years. To enhance performance in visualization additional data are stored on the long term average tables that express the chance of an event e.g. the chance that a certain day has a rainfall event larger than 5 mm. Similary the average temperature above a threshold is stored. Using these additional data 'average' values of threshold-indicators can be calculated properly without accessing data of all historic years. In detail:  
 
*fraction of days with daily maximum temperature greater than 25 °C
 
*fraction of days with daily maximum temperature greater than 25 °C
 
*fraction of days with daily maximum temperature greater than 30 °C
 
*fraction of days with daily maximum temperature greater than 30 °C
Line 42: Line 42:
 
*average temperature above 8 degrees Celsius
 
*average temperature above 8 degrees Celsius
 
*average temperature above 10 degrees Celsius
 
*average temperature above 10 degrees Celsius
 +
*fraction of days with snow greater than 1 cm
 +
*fraction of days with snow greater than 5 cm
 +
*fraction of days with snow greater than 10 cm
 +
*fraction of days with snow greater than 15 cm
 +
*fraction of days with relative humidity greater than 70%
 +
*fraction of days with relative humidity greater than 75%
 +
*fraction of days with relative humidity greater than 80%
 +
*fraction of days with relative humidity greater than 85%
 +
*fraction of days with relative humidity greater than 90%
 +
*fraction of days with relative humidity greater than 95%
  
 
The data are stored in separate tables:
 
The data are stored in separate tables:
*{{Object|WEATHER_OBS_GRID_LTA_THRESHOLD}}
+
*THRESHOLD_OBS_GRID_LTA
*{{Object|WEATHER_OBS_REGCOV_LTA_THRSHLD}}
+
*THRESHOLD_ERA_GRID_LTA
*{{Object|WEATHER_ERA_GRID_LTA_THRESHOLD}}
 
*{{Object|WEATHER_ERA_REGCOV_LTA_THRSHLD}}
 
  
{{Hidden
+
At regional level the threshold indicators are limited to:
|pseudo code
+
*average temperature above 0 degrees Celsius
|
+
*average temperature above 2 degrees Celsius
'''{{Object|WEATHER_OBS_GRID_LTA}} or {{Object|WEATHER_ERA_GRID_LTA}}:'''
+
*average temperature above 4 degrees Celsius
<pre>
+
*average temperature above 6 degrees Celsius
select
+
*average temperature above 8 degrees Celsius
      idgrid,
+
*average temperature above 10 degrees Celsius
      mmdd,                                -- day converted to mmdd format
 
      average(indicator_1),
 
      average(indicator_2),
 
      ...
 
      max(indicator_1),                   
 
      max(indicator_2),                   
 
      ...                                 
 
      min(indicator_1),                 
 
      min(indicator_2),                   
 
      ...                               
 
      stddev(indicator_1),               
 
      stddev(indicator_2),               
 
      ...                                 
 
      count(indicator_1),                 
 
      count(indicator_2),                 
 
      ...                                 
 
from WEATHER_OBS_GRID                      -- or WEATHER_ERA_GRID
 
where year between start year and end year  -- day converted to yyyy format
 
group by mmdd and idgrid                    -- day converted to mmdd format
 
</pre>
 
  
'''{{Object|WEATHER_OBS_GRID_LTA_THRESHOLD}} or {{Object|WEATHER_ERA_GRID_LTA_THRESHOLD}}:'''
+
The data are stored in separate tables:
<pre>
+
*THRESHOLD_OBS_REGION_LTA
select
+
*THRESHOLD_ERA_REGION_LTA
      idgrid,
 
      idthreshold                          -- unique definition of indicator and its threshold e.g rainy day above 5 mm
 
      mmdd,                                -- day converted to mmdd format
 
      average(case when indicator_1 >= threshold_1 then 1 else 0 end),
 
      ...                                 
 
from WEATHER_OBS_GRID                      -- or WEATHER_ERA_GRID
 
where year between start year and end year  -- day converted to yyyy format
 
group by mmdd and idgrid                    -- day converted to mmdd format
 
</pre>
 
 
 
'''{{Object|WEATHER_OBS_REGIONCOVER_LTA}} or {{Object|WEATHER_ERA_REGIONCOVER_LTA}}:'''
 
<pre>
 
select
 
      idregion,
 
      mmdd                                          -- day converted to mmdd format
 
      idcover,
 
      average(indicator_1),
 
      average(indicator_2),
 
      ...
 
      max(indicator_1),                           
 
      max(indicator_2),                             
 
      ...                                           
 
      min(indicator_1),                           
 
      min(indicator_2),                           
 
      ...                                         
 
      stddev(indicator_1),                         
 
      stddev(indicator_2),                         
 
      ...                                           
 
      count(indicator_1),                         
 
      count(indicator_2),                         
 
      ...                                         
 
from WEATHER_OBS_REGIONCOVER                        -- or WEATHER_ERA_REGIONCOVER
 
where year between start year and end year          -- day converted to yyyy format
 
group by mmdd, idregion, idcover                    -- day converted to mmdd format
 
</pre>
 
 
 
'''{{Object|WEATHER_OBS_REGCOV_LTA_THRSHLD}} or {{Object|WEATHER_ERA_REGCOV_LTA_THRSHLD}}:'''
 
<pre>
 
select
 
      idregion,
 
      idcover,
 
      idthreshold                          -- unique definition of indicator and its threshold e.g rainy day above 5 mm
 
      mmdd,                                -- day converted to mmdd format
 
      average(value)                                 
 
from WEATHER_OBS_REGCOV_THRESHOLDS            -- or WEATHER_ERA_REGCOV_THRESHOLDS
 
where year between start year and end year    -- day converted to yyyy format
 
group by mmdd, idregion, idcover, idthreshold  -- day converted to mmdd format
 
</pre>
 
  
}}
+
Note this only implemented for Europe and window Russia, Ukraine and Kazakstan
  
  
 
====Reference weather====
 
====Reference weather====
Long term average values of daily station observations are calculated and stored in table {{Object|WEATHER_OBS_STATION_LTA}} (see also [[Interpolation of observed weather#General selection of weather stations (temporal availability)|interpolation of observed weather]]).
+
Long term average values of daily station observations are calculated and stored in table WEATHER_OBS_STATION_LTA (see also [[Interpolation of observed weather#General selection of weather stations (temporal availability)|interpolation of observed weather]]).
  
 
{{non_expert_box|[[Software Tools#ReferenceWeather|ReferenceWeather]]}}
 
{{non_expert_box|[[Software Tools#ReferenceWeather|ReferenceWeather]]}}
  
 
[[Category:Weather Monitoring]]
 
[[Category:Weather Monitoring]]

Revision as of 11:34, 22 October 2021



The calculation of climatology is done for each weather indicator and for each individual geographical feature on a daily basis. For each grid cell, administrative region or agri-environmental region there are 366 values per indicator; for each day of the year one.

For the following basic parameters average values are calculated:

  • Precipitation
  • Temperature (daily maximum, daily minimum and daily average)
  • Dewpoint temperature (forecasted weather only)
  • Vapour pressure
  • Wind speed
  • Snow depth
  • Calculated radiation at surface (observed), global radiation (forecasted)
  • E0 (daily transpiration of water surface)
  • ES0 (daily transpiration of wet bare soil)
  • ET0 (daily transpiration of crop canopy; evapotranspiration)

Besides the average also minimum, maximum, standard deviation and count are calculated (observed weather only).These data are stored in:

  • WEATHER_OBS_GRID_LTA
  • WEATHER_OBS_REGIONCOVER_LTA
  • WEATHER_ERA5_GRID_LTA
  • WEATHER_ERA5_REGIONCOVER_LTA

To properly compare threshold-indicators at grid level like rainy days, hot days, cold days and tempature sums (above or below a minimum threshold), calculated over a certain period, with the long term average these long term average values should not be derived from climatology. This would lead to underestimation of the extremes. In stead first the threshold-indicator must be calculated for each historic year and the outcome must be averaged over all historic years. To enhance performance in visualization additional data are stored on the long term average tables that express the chance of an event e.g. the chance that a certain day has a rainfall event larger than 5 mm. Similary the average temperature above a threshold is stored. Using these additional data 'average' values of threshold-indicators can be calculated properly without accessing data of all historic years. In detail:

  • fraction of days with daily maximum temperature greater than 25 °C
  • fraction of days with daily maximum temperature greater than 30 °C
  • fraction of days with daily maximum temperature greater than 35 °C
  • fraction of days with daily maximum temperature greater than 40 °C
  • fraction of days with daily minimum temperature less than 0 °C
  • fraction of days with daily minimum temperature less than -8 °C
  • fraction of days with daily minimum temperature less than -10 °C
  • fraction of days with daily minimum temperature less than -18 °C
  • fraction of days with daily minimum temperature less than -20 °C
  • fraction of days with rainfall greater than 1 mm
  • fraction of days with rainfall greater than 3 mm
  • fraction of days with rainfall greater than 5 mm
  • fraction of days with rainfall greater than 10 mm
  • fraction of days with rainfall greater than 15 mm
  • fraction of days with rainfall greater than 30 mm
  • average temperature above 0 degrees Celsius
  • average temperature above 2 degrees Celsius
  • average temperature above 4 degrees Celsius
  • average temperature above 6 degrees Celsius
  • average temperature above 8 degrees Celsius
  • average temperature above 10 degrees Celsius
  • fraction of days with snow greater than 1 cm
  • fraction of days with snow greater than 5 cm
  • fraction of days with snow greater than 10 cm
  • fraction of days with snow greater than 15 cm
  • fraction of days with relative humidity greater than 70%
  • fraction of days with relative humidity greater than 75%
  • fraction of days with relative humidity greater than 80%
  • fraction of days with relative humidity greater than 85%
  • fraction of days with relative humidity greater than 90%
  • fraction of days with relative humidity greater than 95%

The data are stored in separate tables:

  • THRESHOLD_OBS_GRID_LTA
  • THRESHOLD_ERA_GRID_LTA

At regional level the threshold indicators are limited to:

  • average temperature above 0 degrees Celsius
  • average temperature above 2 degrees Celsius
  • average temperature above 4 degrees Celsius
  • average temperature above 6 degrees Celsius
  • average temperature above 8 degrees Celsius
  • average temperature above 10 degrees Celsius

The data are stored in separate tables:

  • THRESHOLD_OBS_REGION_LTA
  • THRESHOLD_ERA_REGION_LTA

Note this only implemented for Europe and window Russia, Ukraine and Kazakstan


Reference weather

Long term average values of daily station observations are calculated and stored in table WEATHER_OBS_STATION_LTA (see also interpolation of observed weather).

Green orange red.gif

More information
ReferenceWeather