Loading...
 
Description of iLand output tables

Outputs

More general information concerning storage locations and filename conventions is described in organizing outputs.
See also Debug Outputs for available high-resolution outputs (usually for debugging).
Outputs related to the agent based forest management engine are described at the ABE outputs page.

Tree Output

Table Name: tree
Output of indivdual trees. Use the filter property to reduce amount of data (filter by resource-unit, year, species, ...).
The output is triggered after the growth of the current season. Initial values (without any growth) are output as 'startyear-1'.

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
speciesstringtree species
idintegerid of the tree
xdoubleposition of the tree, x-direction (m)
ydoubleposition of the tree, y-direction (m)
dbhdoubledbh (cm) of the tree
heightdoubleheight (m) of the tree
basalAreadoublebasal area of tree in m2
volume_m3doublevolume of tree (m3)
leafArea_m2doublecurrent leaf area of the tree (m2)
foliageMassdoublecurrent mass of foliage (kg)
woodyMassdoublekg Biomass in woody department
fineRootMassdoublekg Biomass in fine-root department
coarseRootMassdoublekg Biomass in coarse-root department
lridoubleLightResourceIndex of the tree (raw light index from iLand, without applying resource-unit modifications)
lightResponsedoublelight response value (including species specific response to the light level)
stressIndexdoublescalar (0..1) indicating the stress level (see Mortality).
reserve_kgdoubleNPP currently available in the reserve pool (kg Biomass)


Tree Removed Output

Table Name: treeremoved
Output of removed indivdual trees. Use the filter property to reduce amount of data (filter by resource-unit, year, species, ...).
The output is triggered immediately when a tree is removed due to mortality or management.

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
speciesstringtree species
idintegerid of the tree
reasonintegerreason of removal: 0: mortality, 1: management, 2: disturbance
xdoubleposition of the tree, x-direction (m)
ydoubleposition of the tree, y-direction (m)
dbhdoubledbh (cm) of the tree
heightdoubleheight (m) of the tree
basalAreadoublebasal area of tree in m2
volume_m3doublevolume of tree (m3)
leafArea_m2doublecurrent leaf area of the tree (m2)
foliageMassdoublecurrent mass of foliage (kg)
woodyMassdoublekg Biomass in woody department
fineRootMassdoublekg Biomass in fine-root department
coarseRootMassdoublekg Biomass in coarse-root department
lridoubleLightResourceIndex of the tree (raw light index from iLand, without applying resource-unit modifications)
lightResponsedoublelight response value (including species specific response to the light level)
stressIndexdoublescalar (0..1) indicating the stress level (see Mortality).
reserve_kgdoubleNPP currently available in the reserve pool (kg Biomass)


Stand by species/RU

Table Name: stand
Output of aggregates on the level of RU x species. Values are always aggregated per hectare (of stockable area). Use the 'area' column to scale to the actual values on the resource unit.
The output is created after the growth of the year, i.e. output with year=2000 means effectively the state of at the end of the year 2000. The initial state (without any growth) is indicated by the year 'startyear-1'. You can use the 'condition' to control if the output should be created for the current year(see dynamic stand output)

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
speciesstringtree species
area_hadoublestockable forest area on the resource unit (in ha).
count_haintegertree count (living, >4m height) per ha
dbh_avg_cmdoubleaverage dbh (cm)
height_avg_mdoubleaverage tree height (m)
volume_m3doublevolume (geomery, taper factor) in m3
total_carbon_kgdoubletotal carbon in living biomass (aboveground compartments and roots) of all living trees (including regeneration layer) (kg/ha)
gwl_m3double'gesamtwuchsleistung' (total growth including removed/dead trees) volume (geomery, taper factor) in m3
basal_area_m2doubletotal basal area at breast height (m2)
NPP_kgdoublesum of NPP (aboveground + belowground) kg Biomass/ha
NPPabove_kgdoublesum of NPP (abovegroundground) kg Biomass/ha
LAIdoubleLeafareaindex (m2/m2)
cohort_count_haintegernumber of cohorts in the regeneration layer (<4m) /ha


Landscape aggregates per species

Table Name: landscape
Output of aggregates on the level of landscape x species. Values are always aggregated per hectare. The output is created after the growth of the year, i.e. output with year=2000 means effectively the state of at the end of the year 2000. The initial state (without any growth) is indicated by the year 'startyear-1'.You can use the 'condition' to control if the output should be created for the current year(see also dynamic stand output)

captiondatatypedescription
yearintegersimulation year
speciesstringtree species
count_haintegertree count (living, >4m height) per ha
dbh_avg_cmdoubleaverage dbh (cm)
height_avg_mdoubleaverage tree height (m)
volume_m3doublevolume (geomery, taper factor) in m3
total_carbon_kgdoubletotal carbon in living biomass (aboveground compartments and roots) of all living trees (including regeneration layer) (kg/ha)
gwl_m3double'gesamtwuchsleistung' (total growth including removed/dead trees) volume (geomery, taper factor) in m3
basal_area_m2doubletotal basal area at breast height (m2)
NPP_kgdoublesum of NPP (aboveground + belowground) kg Biomass/ha
NPPabove_kgdoublesum of NPP (abovegroundground) kg Biomass/ha
LAIdoubleLeafareaindex (m2/m2)
cohort_count_haintegernumber of cohorts in the regeneration layer (<4m) /ha


Aggregates of removed trees due to death, harvest, and disturbances per species

Table Name: landscape_removed
Aggregates of all removed trees due to 'natural' death, harvest, or disturbance per species and reason. All values are totals for the whole landscape.The user can select with options whether to include 'natural' death and harvested trees (which may slow down the processing). Set the setting in the XML project file 'includeNatural' to 'true' to include trees that died due to natural mortality, the setting 'includeHarvest' controls whether to include ('true') or exclude ('false') harvested trees.

captiondatatypedescription
yearintegersimulation year
speciesstringtree species
reasonstringResaon for tree death: 'N': Natural mortality, 'H': Harvest (removed from the forest), 'D': Disturbance (not salvage-harvested), 'S': Salvage harvesting (i.e. disturbed trees which are harvested), 'C': killed/cut down by management
countintegernumber of died trees (living, >4m height)
volume_m3doublesum of volume (geomery, taper factor) in m3
basal_area_m2doubletotal basal area at breast height (m2)


dynamic stand output by species/RU

Table Name: dynamicstand
Userdefined outputs for tree aggregates for each stand or species.
Technically, each field is calculated 'live', i.e. it is looped over all trees, and eventually the statistics (percentiles) are calculated. The aggregated values are not scaled to any area unit.

Specifying the aggregation

The by_species and by_ru option allow to define the aggregation level. When by_species is set to true, a row for each species will be created, otherwise all trees of all species are aggregated to one row. Similarly, by_ru=true means outputs for each resource unit, while a value of false aggregates over the full project area.

Specifying filters

You can use the 'rufilter' and 'treefilter' XML settings to reduce the limit the output to a subset of resource units / trees. Both filters are valid expressions (for resource unit level and tree level, respectively). For example, a treefilter of 'speciesindex=0' reduces the output to just one species.
The condition filter is (when present) evaluated and the output is only executed when condition is true (variable='year') This can be used to constrain the output to specific years (e.g. 'in(year,100,200,300)' produces output only for the given year.

Specifying data columns

Each field is defined as: field.aggregation (separated by a dot). A field is a valid expression. Aggregation is one of the following: mean, sum, min, max, p25, p50, p75, p5, 10, p90, p95 (pXX=XXth percentile), sd (std.dev.).
Complex expression are allowed, e.g: if(dbh>50,1,0).sum (-> counts trees with dbh>50)

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
speciesstringtree species
dbh_meandoubledbh
dbh_sddoubledbh
dbh_p5doubledbh
dbh_p25doubledbh
dbh_p75doubledbh
dbh_p95doubledbh
height_meandoubleheight
height_sddoubleheight
height_p5doubleheight
height_p25doubleheight
height_p75doubleheight
height_p95doubleheight
age_meandoubleage
age_sddoubleage
age_mindoubleage
age_maxdoubleage
if_dbh_10_1_0_sumdoubleif(dbh<10,1,0)
if_dbh_10_and_dbh_20_1_0_sumdoubleif(dbh>10 and dbh<20,1,0)
if_dbh_20_and_dbh_30_1_0_sumdoubleif(dbh>20 and dbh<30,1,0)
if_dbh_30_and_dbh_40_1_0_sumdoubleif(dbh>30 and dbh<40,1,0)
if_dbh_40_and_dbh_50_1_0_sumdoubleif(dbh>40 and dbh<50,1,0)
if_dbh_50_and_dbh_60_1_0_sumdoubleif(dbh>50 and dbh<60,1,0)
if_dbh_60_and_dbh_70_1_0_sumdoubleif(dbh>60 and dbh<70,1,0)
if_dbh_70_and_dbh_80_1_0_sumdoubleif(dbh>70 and dbh<80,1,0)
if_dbh_80_and_dbh_90_1_0_sumdoubleif(dbh>80 and dbh<90,1,0)
if_dbh_90_and_dbh_100_1_0_sumdoubleif(dbh>90 and dbh<100,1,0)
if_dbh_100_1_0_sumdoubleif(dbh>=100,1,0)


Production per month, species and resource unit

Table Name: production_month
Details about the 3PG production submodule on monthly basis and for each species and resource unit.

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
speciesstringtree species
monthintegermonth of year
tempResponsedoublemonthly average of daily respose value temperature
waterResponsedoublemonthly average of daily respose value soil water
vpdResponsedoublemonthly vapour pressure deficit respose.
co2Responsedoublemonthly response value for ambient co2.
nitrogenResponsedoubleyearly respose value nitrogen
radiation_m2doubleglobal radiation PAR in MJ per m2 and month
utilizableRadiation_m2doubleutilizable PAR in MJ per m2 and month (sum of daily rad*min(respVpd,respWater,respTemp))
GPP_kg_m2doubleGPP (without Aging) in kg Biomass/m2


Dead trees by species/RU

Table Name: standdead
Died trees in current year on the level of RU x species. The output is created after the growth of the year, i.e. the growth of year trees are dying in is included! NPP and NPP_kg are not recorded for trees that are removed during management.

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
speciesstringtree species
count_haintegertree count (that died this year)
dbh_avg_cmdoubleaverage dbh (cm)
height_avg_mdoubleaverage tree height (m)
volume_m3doublevolume (geomery, taper factor) in m3
basal_area_m2doubletotal basal area at breast height (m2)
NPP_kgdoublesum of NPP (aboveground + belowground) kg Biomass/ha
NPPabove_kgdoublesum of NPP (abovegroundground) kg Biomass/ha


Removed trees by species/RU

Table Name: management
Aggregates for trees that are removed in current year on the level of RU x species. All values are scaled to one hectare.The output is created after the growth of the year, i.e. the growth of the year in which trees are dying, is included!

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
speciesstringtree species
count_haintegertree count (living)
dbh_avg_cmdoubleaverage dbh (cm)
height_avg_mdoubleaverage tree height (m)
volume_m3doublevolume (geomery, taper factor) in m3
basal_area_m2doubletotal basal area at breast height (m2)


Sapling Output

Table Name: sapling
Output of the establishment/sapling layer per resource unit and species.
The output covers trees between a dbh of 1cm (height>1.3m) and the recruitment threshold (i.e. a height of 4m).Cohorts with a dbh < 1cm are counted in 'cohort_count_ha' but not used for average calculations.

You can specify a 'condition' to limit execution for specific time/ area with the variables 'ru' (resource unit id) and 'year' (the current year)

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
speciesstringtree species
count_haintegernumber of represented individuals per ha (tree height >1.3m).
count_small_haintegernumber of represented individuals per ha (with height <=1.3m).
cohort_count_haintegernumber of cohorts per ha.
height_avg_mdoublearithmetic average height of the cohorts (m)
age_avgdoublearithmetic average age of the sapling cohorts (years)
LAIdoubleleaf area index of the regeneration layer (m2/m2)


Sapling Details Output

Table Name: saplingdetail
Detailed output on indidvidual sapling cohorts.
For each occupied and living 2x2m pixel, a row is generated, unlessthe tree diameter is below the 'minDbh' threshold (cm). You can further specify a 'condition' to limit execution for specific time/ area with the variables 'ru' (resource unit id) and 'year' (the current year).

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
speciesstringtree species
n_representeddoublenumber of trees that are represented by the cohort (Reineke function).
dbhdoublediameter of the cohort (cm).
heightdoubleheight of the cohort (m).
ageintegerage of the cohort (years)


Carbon and nitrogen pools above and belowground per RU/yr

Table Name: carbon
Carbon and nitrogen pools (C and N) per resource unit / year and/or by landsacpe/year. On resource unit level, the outputs contain aggregated above ground pools (kg/ha) and below ground pools (kg/ha).
For landscape level outputs, all variables are scaled to kg/ha stockable area. The area column contains the stockable area (per resource unit / landscape) and can be used to scale to values to the actual value.
You can use the 'condition' to control if the output should be created for the current year(see also dynamic stand output).
The 'conditionRU' can be used to suppress resource-unit-level details; eg. specifying 'in(year,100,200,300)' limits output on reosurce unit level to the years 100,200,300 (leaving 'conditionRU' blank enables details per default).

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
area_hadoubletotal stockable area of the resource unit (ha)
stem_cdoubleStem carbon kg/ha
stem_ndoubleStem nitrogen kg/ha
branch_cdoublebranches carbon kg/ha
branch_ndoublebranches nitrogen kg/ha
foliage_cdoubleFoliage carbon kg/ha
foliage_ndoubleFoliage nitrogen kg/ha
coarseRoot_cdoublecoarse root carbon kg/ha
coarseRoot_ndoublecoarse root nitrogen kg/ha
fineRoot_cdoublefine root carbon kg/ha
fineRoot_ndoublefine root nitrogen kg/ha
regeneration_cdoubletotal carbon in regeneration layer (h<4m) kg/ha
regeneration_ndoubletotal nitrogen in regeneration layer (h<4m) kg/ha
snags_cdoublestanding dead wood carbon kg/ha
snags_ndoublestanding dead wood nitrogen kg/ha
snagsOther_cdoublebranches and coarse roots of standing dead trees, carbon kg/ha
snagsOther_ndoublebranches and coarse roots of standing dead trees, nitrogen kg/ha
downedWood_cdoubledowned woody debris (yR), carbon kg/ha
downedWood_ndoubledowned woody debris (yR), nitrogen kg/ga
litter_cdoublesoil litter (yl), carbon kg/ha
litter_ndoublesoil litter (yl), nitrogen kg/ha
soil_cdoublesoil organic matter (som), carbon kg/ha
soil_ndoublesoil organic matter (som), nitrogen kg/ha


Carbon fluxes per RU or landscape/yr

Table Name: carbonflow
Carbon fluxes per resource unit and year and/or aggregated for the full landscape. All values are reported on a per hectare basis (use the area provided in carbon or stand outputs to scale to realized values on the respective resource unit). For results limited to the project area, the data values need to be scaled to the stockable area.
For landsacpe level outputs, data is always given per ha of (stockable) project area (i.e. scaling with stockable area is already included).
Furthermore, the following sign convention is used in iLand: fluxes from the atmosphere to the ecosystem are positive, while C leaving the ecosystem is reported as negative C flux.
You can specify a 'condition' to limit output execution to specific years (variable 'year'). The 'conditionRU' can be used to suppress resource-unit-level details; eg. specifying 'in(year,100,200,300)' limits output on reosurce unit level to the years 100,200,300 (leaving 'conditionRU' blank enables details per default).

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
area_hadoubletotal stockable area of the resource unit (or landscape) (ha)
GPPdoubleactually realized gross primary production, kg C; GPP including the effect of decreasing productivity with age; note that a rough estimate of sapling GPP is added to the GPP of adult trees here.
NPPdoublenet primary production, kg C; calculated as NPP=GPP-Ra; Ra, the autotrophic respiration (kg C/ha) is calculated as a fixed fraction of GPP in iLand (see here for details).
Rhdoubleheterotrophic respiration, kg C; sum of C released to the atmosphere from detrital pools, i.e. snags, downed deadwood, litter, and mineral soil.
dist_lossdoubledisturbance losses, kg C; C that leaves the ecosystem as a result of disturbances, e.g. fire consumption
mgmt_lossdoublemanagement losses, kg C; C that leaves the ecosystem as a result of management interventions, e.g. harvesting
NEPdoublenet ecosytem productivity kg C, NEP=NPP - Rh - disturbance losses - management losses. Note that NEP is also equal to the total net changes over all ecosystem C pools, as reported in the carbon output (cf. Randerson et al. 2002)
cumNPPdoublecumulative NPP, kg C. This is a running sum of NPP (including tree NPP and sapling carbon gain).
cumRhdoublecumulative flux to atmosphere (heterotrophic respiration), kg C. This is a running sum of Rh.
cumNEPdoublecumulative NEP (net ecosystem productivity), kg C. This is a running sum of NEP (positive values: carbon gain, negative values: carbon loss).


Carbon input to the soil per RU/yr

Table Name: soilinput
The output contains all carbon inputs to the soil layer (per RU) and the climate modifier re. The data of the output can be used for estimating soil carbon parameters.

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
input_labdoubleinput for labile carbon (i.e. fine debris) in t/ha (scaled to full ha)
input_refdoubleinput for refractory carbon (i.e. coarse woody debris) in t/ha (scaled to full ha)
redoubleclimate factor 're' for snag/carbon decay


Water output

Table Name: water
Annual water cycle output on resource unit/landscape unit.
The output includes annual averages of precipitation, evapotranspiration, water excess, snow cover, and radiation input. The spatial resolution is landscape averages and/or resource unit level (i.e. 100m pixels). Landscape level averages are indicated by -1 for the 'ru' and 'index' columns.

You can specify a 'condition' to limit output execution to specific years (variable 'year'). The 'conditionRU' can be used to suppress resource-unit-level details; eg. specifying 'in(year,100,200,300)' limits output on reosurce unit level to the years 100,200,300 (leaving 'conditionRU' blank enables details per default).

captiondatatypedescription
yearintegersimulation year
ruintegerindex of ressource unit
ridintegerid of ressource unit (-1: no ids set)
stocked_areadoublearea (ha/ha) which is stocked (covered by crowns, absorbing radiation)
stockable_areadoublearea (ha/ha) which is stockable (and within the project area)
precipitation_mmdoubleAnnual precipitation sum (mm)
et_mmdoubleEvapotranspiration (mm)
excess_mmdoubleannual sum of water loss due to lateral outflow/groundwater flow (mm)
snowcover_daysintegerdays with snowcover >0mm
total_radiationdoubletotal incoming radiation over the year (MJ/m2), sum of data in climate input)
radiation_snowcoverintegersum of radiation input (MJ/m2) for days with snow cover
effective_laidoubleeffective LAI (m2/m2) including LAI of adult trees, saplings, and ground cover


Created by werner. Last Modification: Monday 26 of June, 2017 15:27:31 CEST by werner.