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

From Agri4castWiki
Jump to: navigation, search
Line 30: Line 30:
 
select
 
select
 
       crop_no,
 
       crop_no,
       ddmm,                               -- day converted to mmdd format
+
       ddmm,                               -- day converted to mmdd format
 
       grid_no,
 
       grid_no,
 
       smu_no,
 
       smu_no,
Line 37: Line 37:
 
       ...
 
       ...
 
from CROP_YIELD
 
from CROP_YIELD
where year between start year and end year -- day converted to yyyy format
+
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
 
group by crop_no, ddmm, grid_no, smu_no    -- day converted to mmdd format
 
</pre>
 
</pre>
Line 67: Line 67:
 
group by crop_no, ddmm, grid_no            -- day converted to mmdd format
 
group by crop_no, ddmm, grid_no            -- day converted to mmdd format
 
</pre>
 
</pre>
 +
  
 
'''{{Object|LONG_TERM_AVERAGE_NUTS_YIELD}}:'''
 
'''{{Object|LONG_TERM_AVERAGE_NUTS_YIELD}}:'''
 +
<pre>
 
select
 
select
 
       crop_no,
 
       crop_no,
Line 92: Line 94:
 
where year between start year and end year -- day converted to yyyy format
 
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
 
group by crop_no, ddmm, nuts_code          -- day converted to mmdd format
 +
</pre>
 
}}
 
}}
  
 
[[Category:Weather Monitoring]]
 
[[Category:Weather Monitoring]]

Revision as of 11:15, 17 June 2011



The calculation of long term averages is done for each crop indicator and for each individual geographical feature on a 10 daily base.

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
  • Total water requirement
  • Total water consumption
  • Relative soil moisture
  • Crop development stage

Besides the average also minimum, maximum, standard deviation and count are calculated (grid and nuts resolution only).

The data are stored in separate tables:

Two versions of each table exist; one for yields based on observed weather and one for yields based on ECMWF forcasted weather (HIS model).