Difference between revisions of "Calculation of long term average crop indicators"

From Agri4castWiki
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{Scientific}}
 
{{Scientific}}
The calculation of long term averages is done for each crop indicator and for each individual geographical feature on a 10 daily base. A dedicated software package called [[LTA_YIELD]] is developed to do all calculations.
+
The calculation of 10-daily statistics over the entire archive, such as the long term averages, minimum, maximum, standard deviation and count, is done for each crop indicator and for each individual geographical feature. A dedicated software package called [[LTA_YIELD]] is developed to do all calculations.
  
 
For the following basic parameters average values are calculated:
 
For the following basic parameters average values are calculated:
Line 9: Line 9:
 
* Potential Leaf Area Index
 
* Potential Leaf Area Index
 
* Water limited Leaf Area Index
 
* Water limited Leaf Area Index
 +
* Crop development stage (DVS)
 +
* Relative soil moisture
 +
* Total water consumption
 
* Total water requirement
 
* Total water requirement
* Total water consumption
+
* volumetric soil moisture content in rooted zone (FSM)
* Relative soil moisture
+
* volumetric soil moisture content in not rooted zone (FSMUR)
* Crop development stage
+
* Leaves died by cold
 
+
* Run off
Besides the average also minimum, maximum, standard deviation and count are calculated (grid and nuts resolution only).
+
* Soil evaporation
 
+
* Loss to subsoil
The data are stored in separate tables:
 
*{{Object|LONG_TERM_AVERAGE_CROP_YIELD}}
 
*{{Object|LONG_TERM_AVERAGE_GRID_YIELD}}
 
*{{Object|LONG_TERM_AVERAGE_NUTS_YIELD}}
 
 
 
Two versions of each table exist; one for yields based on observed weather and one for yields based on ECMWF forcasted weather (HIS model).
 
 
 
{{Hidden
 
|pseudo code
 
|
 
'''{{Object|LONG_TERM_AVERAGE_CROP_YIELD}}:'''
 
<pre>
 
select
 
      crop_no,
 
      ddmm,                              -- day converted to mmdd format
 
      grid_no,
 
      smu_no,
 
      average(indicator_1),
 
      average(indicator_2),
 
      ...
 
from CROP_YIELD
 
where year between start year and end year -- day converted to yyyy format
 
group by crop_no, ddmm, grid_no, smu_no    -- day converted to mmdd format
 
</pre>
 
 
 
'''{{Object|LONG_TERM_AVERAGE_GRID_YIELD}}:'''
 
<pre>
 
select
 
      crop_no,
 
      mmdd,                              -- day converted to mmdd format
 
      grid_no,
 
      average(indicator_1),
 
      average(indicator_2),
 
      ...
 
      min(indicator_1),
 
      min(indicator_2),
 
      ...             
 
      max(indicator_1),
 
      max(indicator_2),
 
      ...             
 
      stddev(indicator_1),
 
      stddev(indicator_2),
 
      ...               
 
      count(indicator_1),
 
      count(indicator_2),
 
      ...               
 
      DECADE                              -- day converted to dekad in year (1-36)
 
from GRID_YIELD
 
where year between start year and end year -- day converted to yyyy format
 
group by crop_no, ddmm, grid_no            -- day converted to mmdd format
 
</pre>
 
  
 +
The 10-daily statistics based on weather observations is stored in tables:
 +
*{{Object|SIMYIELD_EMU_LTA}}
 +
*{{Object|SIMYIELD_GRID_LTA}}
 +
*{{Object|SIMYIELD_REGION_LTA}}
  
'''{{Object|LONG_TERM_AVERAGE_NUTS_YIELD}}:'''
+
The 10-daily statistics based on forecasted weather is stored in tables:
<pre>
+
*{{Object|SIMYIELD_HIS_EMU_LTA}}
select
+
*{{Object|SIMYIELD_HIS_GRID_LTA}}
      crop_no,
+
*{{Object|SIMYIELD_HIS_REGION_LTA}}
      mmdd,                              -- day converted to mmdd format
 
      nuts_code,
 
      average(indicator_1),
 
      average(indicator_2),
 
      ...
 
      min(indicator_1),
 
      min(indicator_2),
 
      ...             
 
      max(indicator_1),
 
      max(indicator_2),
 
      ...             
 
      stddev(indicator_1),
 
      stddev(indicator_2),
 
      ...               
 
      count(indicator_1),
 
      count(indicator_2),
 
      ...               
 
      DECADE                              -- day converted to dekad in year (1-36)
 
from NUTS_YIELD
 
where year between start year and end year -- day converted to yyyy format
 
group by crop_no, ddmm, nuts_code          -- day converted to mmdd format
 
</pre>
 
}}
 
  
 
[[Category:Weather Monitoring]]
 
[[Category:Weather Monitoring]]

Latest revision as of 17:01, 3 February 2014



The calculation of 10-daily statistics over the entire archive, such as the long term averages, minimum, maximum, standard deviation and count, is done for each crop indicator and for each individual geographical feature. A dedicated software package called LTA_YIELD is developed to do all calculations.

For the following basic parameters average values are calculated:

  • Potential above ground biomass
  • Water limited above ground biomass
  • Potential storage organs biomass
  • Water limited storage organs biomass
  • Potential Leaf Area Index
  • Water limited Leaf Area Index
  • Crop development stage (DVS)
  • Relative soil moisture
  • Total water consumption
  • Total water requirement
  • volumetric soil moisture content in rooted zone (FSM)
  • volumetric soil moisture content in not rooted zone (FSMUR)
  • Leaves died by cold
  • Run off
  • Soil evaporation
  • Loss to subsoil

The 10-daily statistics based on weather observations is stored in tables:

The 10-daily statistics based on forecasted weather is stored in tables: