Growing Degree Day

From HiveTool
Revision as of 04:29, 26 November 2018 by Paul (talk | contribs)
Jump to: navigation, search

Plants grow in a cumulative stepwise manner which is strongly influenced by ambient temperature. Growing Degree Days (GDD), also called Growing Degree Units (GDU) or Heat Units (HU), are based on the observation that within limits, plants grow faster when warm and more slowly when cold. Below a base temperature (Tbase), the plant is dormant and little growth occurs. Since growth depends on the accumulation of specific quantities of heat, by accumulating Growing Degree Days it is possible to predict when events such as bud break (nectar flows) will occur during a growing season regardless of differences in temperatures from year to year.

A simple theoretical formula for GDD at time t is:

GDD integral.png

where:
Tt = temperature at time t
Tbase = temperature below which plant growth is zero.


In addition to the value of Tbase, the selection of t=0 will also change the value of accumulated GDD:

  1. Coldest day of the year
  2. Shortest day of the year
  3. Arbitrary Gregorian calendar date (e.g. January 1)


Each plant species has it's own upper air temperature threshold, Tcap. At temperatures above Tcap the plant does not grow any faster. Tcap varies for each species.

In addition to selection of Tbase, Tbase and and when t=0, different methods exist for calculating heat units depending on a) the crop or biological organism of interest and b) the whim or personal preference of the researcher.

One method of approximating GDD for each day is the average of the daily maximum and minimum temperatures above Tbase.

GDD average.png


Before calculating the average:

  • Any temperature below Tbase is set to Tbase.
  • Any temperature above Tcap is set to Tcap.

If the mean daily temperature is lower than the base temperature then GDD=0.

Some warm temperate and tropical plants have significant requirements for days above 30 °C to mature fruit or seeds.

The method most commonly used in the U.S. for determining heat unit accumulation relative to corn phenology is the formula first suggested by the National Oceanic and Atmospheric Administration. The “modified growing degree day formula” calculates daily accumulation of GDD’s as the average daily temperature minus 50° F.


Calculate Growing Degree Day (GDD) for each hive and add to database.


Centigrade
Tbase = 10
Tmax  = 30


SET @gdd_total:=0;
SELECT
  q1.doy,
  q1.gdd,
  round(@gdd_total := @gdd_total + q1.gdd) as gdd_tot
FROM
 (SELECT DAYOFYEAR(DATE_FORMAT(`hive_observation_time_local`, '%Y-%m-%d')) AS doy,
  (least(greatest(max(wx_temp_c),10),30) - least(greatest(min(wx_temp_c),10),30))/2 AS gdd
  from HIVE_DATA 
  where hive_id=10 group by DATE_FORMAT(`hive_observation_time_local`, '%Y-%m-%d') ) AS q1



SELECT hive_id, DAYOFYEAR(DATE_FORMAT(`hive_observation_time_local`, '%Y-%m-%d')) AS doy,
  (least(greatest(max(wx_temp_c),10),30) - least(greatest(min(wx_temp_c),10),30))/2 AS gdd
  from HIVE_DATA group by DATE_FORMAT(`hive_observation_time_local`, '%Y-%m-%d'), hive_id