R interface for expDB which is used to store experiment-based data.
A SQLite database is used to store all information of experiment-based data.
ApSoils specify the soil name in the ApSoils which distribute with APSIM.
Sites collect the basic information about experiment fields, e.g. name, latitude, longitude, soil, etc. The soil must be the same in the table ApSoils.
The experiment-based data can be imported from a excel file which supports by readxl package. expDB is case-insensitive. The Australia style should be used for all date related fields (dd/mm/yyyy).
The processes of plant growth and development can be classified into several hierarchical levels, e.g. biosphere, ecosystem or cropping system, field or plot, whole plant, plant organ, cell, molecule, atom, and subatomic particle (Hodges 1991). We could collect data from field, plant, organ in an agricultural experiment. The values in the higher levels can be derived from lower levels. In most cases, we don't directly record data in levels above, but through specific protocol. These observations are used to derive values in other levels. For example, population is converted from the establishment counts; dry weights of leaves, stems, and heads are converted from quadrat harvest. An extra level, measurement is added into the convention.
|Levels | Prefix | Example | |------------|--------|----------------------| |Field | F_ | F_StemNumber | |Plant | P_ | P_StemNumber | |Organ | O_ | O_LeafArea | |Measurement | M_ | M_DryWeightGreenLeaf |
A list of traits are provided in the released version of expDB.
The low level function
dbGetPhenotype is provided to extract the raw observations from database. Some traits can be observed or calculated from other traits.
The plant population (
F_Population) is defined as the number of plants in unit area.
F_Population is retrived from database, then calculated from measurement establishment count (
M_EstablishmentCount) and row spacing (
RowSpacing). The density is assumed to equal to population if none of above traits are specified in the database.
Final leaf number (
O_FinalLeafNumber) is defined as the total completed leaf number of a fertile stem after head emergence (main stem and tillers).
O_FinalLeafNumber is retrived from database, then calculated from Haun Index. Huan Index is assumed the full expanded flag leaf is recorded. Consequently the maximum integer value in the observations is treated as the
The stem/tiller numbers are defined as the number stems/tillers per unit area and per plant. The relationships among 4 traits are as follows.
$$P_StemNumber = P_TillerNumber + 1$$ $$F_StemNumber = P_StemNumber \times F_Population$$ $$F_TillerNumber = P_TillerNumber \times F_Population$$ $$F_StemNumber = (P_TillerNumber + 1) \times F_Population$$
The stem/tiller numbers are retrived from observations, then calculated by other traits.
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.