How is the database of the growth simulator SIBYLA structured ?

The database of the growth simulator SIBYLA is of Microsoft Access type, starting from the version 97. It consists of tables and code lists. Its relation structure is shown in the picture below: 

Table STRUGEN Table DESCRIPTION Table MIXTURE Table FREQUENCY Table INDIVIDUAL Table PLOTS Table TERRAIN Table SURFACE Table SITES Table DAMAGE Table PROGNOSIS Table THINNINGS Table CUTTING Table YARDING Table CONVERSION Table MARKS Table iPIX Table COVER Table HERBS Table INITIAL Table TREES Table ELEMENTS Table Biomass Table Biodiversity Table Production Table Returns Table Costs Table Summary

Figure 1 Database structure of the growth simulator SIBYLA

Description of tables required for the generator of inputs

Table STRUGEN

This table defines basic data for generated simulation plots at stand level.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

area

double precision real number

area of the simulation plot in hectares (by default 0.25 ha); The area has to be entered when forest structure is generated from frequencies or from tree data with missing coordinates

orgArea

double precision real number

original area of the forest stand in hectares, which is represented by the simulation plot

mixture

string

degree of mixture of filling tree species: SLIGHT, MODERATE, MIDDLE, STRONG, VERYSTRONG alebo TOTAL

repeatStructure

long integer number

number of prognosis generation repetitions: 1 to 20

filter

long integer number

identifier of the forest stand selection for structure generation: 0 = stand is not selected, 1 = stand is selected

Table DESCRIPTION

This table defines all necessary basic information for the generation of structure at storey and tree species level.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

species

string

tree species abbreviation as specified in the tree species code list

source

string

source data for generating structure of the simulation plot: TREE (tree data), fDHQ (frequency data: diameter-height-quality), fDQ (frequency data: diameter-quality), fDH (frequency data: diameter-height), fD (frequency data:diameter), STAND (stand data), NATURAL (parameters of the selection forest)

d

double precision real number

tree species mean diameter in cm

sr

double precision real number

degree of diameter variability: 1 to 3, where 1 = minimum, 3 = maximum, by default 2

sd

double precision real number

Coefficient of diameter variation in per cent (if the coefficient is unknown, it is set to 0, and its value is derived from the value of sr)

Vha

double precision real number

tree species stand volume per hectare in m3

h

double precision real number

tree species mean height in m

t

long integer number

mean age of tree species in years

ASort

double precision real number

proportion of trees of quality degree A in per cent

BSort

double precision real number

proportion of trees of quality degree B in per cent

CSort

double precision real number

proportion of trees of quality degree C in per cent

DSort

double precision real number

proportion of trees of quality degree D in per cent

damage

double precision real number

percentage of damaged trees in the stand

heightCurve

string

type of the height curve: UNIFORM (uniform height curve), TARIFF (height tariff)

model

string

typ of the selection forest model: LIOCURT (Liocurt frequency function), MEYER (Meyer frequency function)

percentage

double precision real number

proportion of a tree species from the number of trees in per cent

dmax

double precision real number

maximum diameter (dimension of rotation type) in cm for the model by Liocurt

nmax

long integer number

number of trees with maximum diameter for the model by Liocurt: 1 to 10

quotient

double precision real number

quotient q for Liocurt model: 1.25 to 1.45

type

string with max. 50 characters

type of the selection forest for Meyer model: A, B, C, D or E

absTariff

double precision real number

mean tree height of the selection forest with diameter 50 cm

relTariff

double precision real number

relative height tariff: 1 to 20

dclass

double precision real number

classifying diameter of the selection forest (quadratic mean diameter + 8 cm)

hclass

double precision real number

classifying height of the selection forest (mean height of trees with classifying diameter)

Table MIXTURE

This table defines one or more aggregated groups for the generation of structure at storey and tree species level.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

species

string

tree species abbreviation as specified in tree species code list (in addition, the value NONE is also permitted, if we want to generate the existence of the clearing in the simulation plot)

group

string

shape of the generated group: CIRCLE, STRIP

xCoord

double precision real number

relative x-coordinate <0;1> of the circle centre or the strip centroid

yCoord

double precision real number

relative y-coordinate <0;1> of the circle centre or the strip centroid

width

double precision real number

diameter of the circle or the width of the strip in metres

angle

double precision real number

angle of strip rotation counterclockwise around the centroid starting from the positive part of axis y <0;180) in degrees

Table FREQUENCY

This table defines the frequency data of diameter, height, and quality for structure generation.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

species

string

tree species abbreviation as specified in the tree species code list

d

double precision real number

middle of the diameter class in cm (10,14,...,90); if the row is recorded due to the measurement of height for mean stem, it is also possible to enter values -3,-2,-1,0,1,2,3, which stand for the differences from mean stem diameter in centimetres

n

long integer number

number of trees in the diameter class d occurring in the simulation plot; if we want to record repeated height measurements for the same diameter class, in every repeated row with the same value of d the number is equal to 0

nA0

long integer number

number of undamaged trees in the diameter class d of quality degree A found in the simulation plot

nA1

long integer number

number of damaged trees in the diameter class d of quality degree A found in the simulation plot

nB0

long integer number

number of undamaged trees in the diameter class d of quality degree B found in the simulation plot

nB1

long integer number

number of damaged trees in the diameter class d of quality degree B found in the simulation plot

nC0

long integer number

number of undamaged trees in the diameter class d of quality degree C found in the simulation plot

nC1

long integer number

number of damaged trees in the diameter class d of quality degree C found in the simulation plot

nD0

long integer number

number of undamaged trees in the diameter class d of quality degree D found in the simulation plot

nD1

long integer number

number of damaged trees in the diameter class d of quality degree D found in the simulation plot

h

double precision real number

tree height of the diameter class (also repeated), if d represents the middle of the diameter class (10,14,...,90); or mean stem height (also repeated), if d is from the range -3,-2,-1,0,1,2 or 3 

Table INDIVIDUAL

This table defines the characteristics of individual trees at storey level (all unknown characteristics are generated).

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

number

long integer number

unique number of a tree in the stand – COMPULSORY FIELD !!!

species

string

tree species abbreviation as specified in the tree species code list – COMPULSORY FIELD !!!

dbh

double precision real number

tree diameter at 1.3 m height (in cm) - COMPULSORY FIELD !!!

h

double precision real number

tree height (in m) – if unknown, enter 0

cd

double precision real number

largest crown diameter (in m) - if unknown, enter 0

ch

double precision real number

height to crown base (in m) - if unknown, enter 0

t

long integer number

tree age in years - if unknown, enter 0

x

double precision real number

horizontal x-coordinate of the tree in the plot - if unknown, enter 0 (if the coordinate is known and is equal to 0, enter a value close to 0, e.g. 0.001, or the original coordinate will be substituted by a generated one)

y

double precision real number

horizontal y-coordinate of the tree in the plot - if unknown, enter 0 (if the coordinate is known and is equal to 0, enter a value close to 0, e.g. 0.001, or the original coordinate will be substituted by a generated one)

quality

string

tree quality degree: A, B, C, D - if unknown, enter question mark (?)

damage

long integer number

tree damage: 0 (undamaged), 1 (damaged) - if unknown, enter -1

mark

long integer number

tree mark: 0 (unmarked), 1 (future crop tree), -1 (tree chosen for thinning)

mortality

long integer number

Age of tree death in years – if the tree is alive, enter 0

 

Description of input tables

Table PLOTS

This table defines basic information about the simulation plot at stand level.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

xSide

double precision real number

side length of the simulation plot in the direction of the axis x in metres

ySide

double precision real number

side length of the simulation plot on the axis y in metres

area

double precision real number

area of the simulation plot in hectares

orgArea

double precision real number

original area of the forest stand, which is represented by the simulation plot (important information for the creation of the table Summary)

cover

long integer number

sequential number of the soil coverage texture for the visualisation using VRML (numbers from 0 to 26 are allowed; texture types are saved in the directory of the program installation .\FOREST\TEXTURY\KRAJINA\ with the file names cover[0..26].JPG)

status

long integer number

last status of the plot during the simulation (automatically filled by the program); by default 0 = the plot is in the status before simulation, other possibilities: 1= stand after simulation and after calculation of tables Production, Biomass and Returns; 2 = status 1 complemented with the calculated table Biodiversity; 3 = status 1 complemented with the calculated table Costs; 4 = stand after simulation and calculation of all output tables

source

string

source of input data of the simulation plot: GENERATOR = automatically filled in by the structure generator; if the user enters the information he can enter any text

filter

long integer number

indicator of the forest stand selection for next simulation: 0 = stand is not selected, 1 = stand is selected

Table TERRAIN

This table defines basic terrain characteristics (terrain model) at stand level. 

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

xDimension

long integer number

number of points in the terrain grid along the axis x (by default 11)

yDimension

long integer number

number of points in the terrain grid along the axis y (by default 11)

xSpacing

double precision real number

distance between the points of the terrain grid along the axis x in metres (by default 5 m)

ySpacing

double precision real number

distance between the points of the terrain grid along the axis y in metres (by default 5 m)

Table SURFACE

This table defines detailed characteristics of the terrain grid (terrain model) at stand level. abuľka definuje na úrovni porastu podrobné charakteristiky terénnej siete (modelu terénu).

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

point

long integer number

sequential number of the point within the terrain grid (see Figure 2)

xCoord

double precision real number

x-coordinate of the point in metres súradnica

yCoord

double precision real number

y-coordinate of the point in metres

elevation

double precision real number

elevation of the point in metres

 

Figure 2 Defining terrain in table SURFACE

 

Table SITES

This table defines basic site characteristics at stand level. 

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

series

long integer number

sequential number of the series with the same site data (1..n)

duration

long integer number

the length of the series (duration) in years

inputs

string

type of input data: DETAILED data (site characteristics), GENERALIZED data (for site generation)

ecoregion

string

code of forest ecoregion

altitude

double precision real number

altitude of the centre of the simulation plot in metres

aspect

double precision real number

average aspect of the simulation plot in degrees (azimuth from north)

slope

double precision real number

average slope of the simulation plot in degrees

year

long integer number

calendar year when the simulation starts (year for which input data are valid)

type

string

code of forest ecoregion

N2O

double precision real number

NOx content in air (ppb)

CO2

double precision real number

CO2 content in air (ppm)

nutrient

double precision real number

soil nutrient supply (relative value in the range from 0 to 1)

season

double precision real number

number of days of the vegetation period (days with daily mean temperature above 10°C)

amplitude

double precision real number

annual temperature amplitude (the difference between annual minimum and maximum temperature in °C)

temperature

double precision real number

daily mean temperature in vegetation period in °C (April to September)

moisture

double precision real number

soil moisture (relative value in the range from 0 to 1)

rainfall

double precision real number

precipitation amount in vegetation period in mm (from April to September)

filter

long integer number

indicator of forest stand selection for next simulation: 0 = stand is not selected, 1 = stand is selected

Table DAMAGE

This table defines basic characteristics for the disturbance model defined by a user (explicit model) at stand and tree species level.  

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

series

long integer number

sequential number of 5-year series for the identification of the influence of injurious agents

species

string

tree species abbreviation as specified in the tree species code list

factor

string

type of injurious agent: NONE, WIND, SNOW, ICING, STEMINSECT (bark miners and timber borers), CROWNINSECT (defoliators and other insects), FUNGI (wood-destroying fungi), AIRPOLLUTION, FIRE, DROUGHT, STEAL (illegal cutting), OTHER

expectation

double precision real number

occurrence risk of an injurious agent in per cent (0-100%)

mortAverage

double precision real number

relative average amount of dead trees in percentage from stand volume

mortDeviation

double precision real number

standard deviation of the amount of dead trees

propagation

string

type of the propagation of an injurious agent in the stand: INDIVIDUAL (scattered or individual), SPOTTED, LOCAL

firstYear

long integer number

sequential number within a 5-year series that specifies the beginning of the influence of the injurious agent (1 to 5)

lastYear

long integer number

sequential number within a 5-year series that specifies the end of the influence of the injurious agent (1 to 5, lastYear must be equal to or greater than firstYear)

selection

string

type of individual tree selection for individual propagation: RANDOM, DEFINED (defined by a user)

link

string

logical connector for a joint influence of selectors: AND, OR

dbh

long integer number

influence of the selector „tree diameter“: 0 (no influence), 1 (positive), -1 (NOT = negative)

h

long integer number

influence of the selector „tree height“: 0 (no influence), 1 (positive), -1 (NOT = negative)

hd

long integer number

influence of the selector „height diameter ratio“: 0 (no influence), 1 (positive), -1 (NOT = negative)

cd

long integer number

influence of the selector „crown diameter“: 0 (no influence), 1 (positive), -1 (NOT = negative)

cl

long integer number

influence of the selector „crown length“: 0 (no influence), 1 (positive), -1 (NOT = negative)

cld

long integer number

influence of the selector „coefficient of crown shape“: 0 (no influence), 1 (positive), -1 (NOT = negative)

vitality

long integer number

influence of the selector „tree vitality“: 0 (no influence), 1 (positive), -1 (NOT = negative)

biosoc

long integer number

influence of the selector „bio-sociological position of the tree“: 0 (no influence), 1 (positive), -1 (NOT = negative)

ccl

long integer number

influence of the selector „competition pressure“: 0 (no influence), 1 (positive), -1 (NOT = negative)

quality

long integer number

influence of the selector „tree quality“: 0 (no influence), 1 (positive), -1 (NOT = negative)

score

long integer number

influence of the selector „tree score of existence“: 0 (no influence), 1 (positive), -1 (NOT = negative)

spotCount

long integer number

number of spots: (1 to 4)

locality

string

shape of the plot for local propagation: CIRCLE, STRIP, ELLIPSE

location

string

type of plot location: RANDOM, DEFINED by a user

xCoord

double precision real number

relative x-coordinate of the plot centre (circle or ellipse), or the point in the strip (0 to 1)

yCoord

double precision real number

relative y-coordinate of the plot centre (circle or ellipse), or the point in the strip (0 to 1)

rotation

double precision real number

azimuth (angle) of the strip axis (positive y axis) rotation clockwise from north in degrees

axisRatio

double precision real number

flattenning ratio of the elliptical plot, i.e. ratio between the smallest and the largest diameter of the ellipse (the value is larger than 0 and smaller than 1)

Table PROGNOSIS

This table defines the number and the length of simulation periods and the interval between thinnings at stand level.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

periode

long integer number

sequential number of the period starting from 1

interval

long integer number

the length of the period in years (can also equal 0, mainly in the periods with thinning treatments – when the field thinning = 1); by default odd periods of the length 0 years are alternated with even periods of 5-year length with inactivated thinning

thinning

long integer number

activates thinnings in the period: 0 = no thinning, 1 = thinning

filter

long integer number

indicator of forest stand selection for the next simulation: 0 = stand is not selected, 1 = stand is selected

Table THINNINGS

This table defines the type of thinning or felling treatment for the thinning model at stand, period, and tree species level.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

periode

long integer number

sequential number of the period

species

string

tree species abbreviation as specified in the tree species code list

mortality

string

dead trees during the thinning: CUT (cut all trees before thinning), KEEP (leave them in the stand, or let the thinning treatment remove them)

type

string

treatment type: NONE (no thinning), FROMBELOW (thinning from below), FROMABOVE (thinning from above), NEUTRAL (neutral thinning), CROPTREES (method of future crop trees), TARGETDIAMETER (method of target diameter), TARGETCURVE (method of target frequency curve), CLEARCUTTING (method of a cutting element), BYLIST (thinning by list) 

scoreMargin

double precision real number

marginal existence score (0 to 1)

intensity

string

intensity of the thinning treatment: CONSTANT (constant in all periods; valid for the thinning from below, from above, and neutral thinning), CURVE (defined as a dynamic thinning by regression; valid for the thinning from below, from above, and neutral thinning, and for the method of target frequency curve), QUOTIENT (defined by Liocurt quotient; valid only for the method of target frequency curve)

constantType

string

type of the constant that defines treatment intensity: PROPORTION (thinning percentage from volume), DENSITY (stand density of the dominant crop), VOLUME (volume of secondary crop in m3)

constantSize

double precision real number

absolute value of the constant cutting in the units of the parameter that is specified in the previous field

cropCount

long integer number

number of future crop trees (target or promising trees) per hectare at 100% tree species proportion

cropDistance

double precision real number

average distance of future crop trees (FCT) in metres; if the value is greater than 0, future crop trees are determined on the base of cropDistance value, otherwise they are determined from cropCount

cropSelection

string

selection of future crop trees (FCT): NEW (during the thinning FCTs are re-evaluated and re-selected, OLD (FCTs marked in the previous period are used during the thinning)

cropType

string

selection type of future crop trees: RADIUS (method of the clearing radius), AMOUNT (method of the degree of release), AVALUE (method of the marginal distance)

cropRadius

double precision real number

clearing radius in metres

cropAmount

long integer number

degree of release as a number of removed trees per one future crop tree

cropAvalue

string

A-value (4 to 9) according to the method of marginal distance

targetDiameter

double precision real number

target diameter in cm for the method of target diameter or the dimension of the rotation type for the removal curve according to Liocurt

targetRatio

double precision real number

target percentage of the trees with the target diameter

targetCount

long integer number

number of trees with the dimension of the rotation type that are left in the stand required for the geometrical series according to Liocurt

curveType

string

curve type from the table: POLYNOM, LOGISTIC, CHAPMANRICHARDS, KORF, REINEKE, WEIBULL, MEYER

curveDependent

string

dependent variable of the curve: PROPORTION (thinning percentage), DENSITY (stand density of the dominant crop), VOLUME (stand volume of the main crop), BASALAREA (basal area of the main crop), TREECOUNT (number of trees of the main crop)

curveIndependent

string

independent variable of the curve: AGE (age), MEANDIAMETER (mean diameter), MEANHEIGHT (mean height), DOMINANTHEIGHT (top height), DIAMETERCLASS (diameter class) 

A0

double precision real number

value of coefficient a0 in the regression curve

A1

double precision real number

value of coefficient a1 in the regression curve

A2

double precision real number

value of coefficient a2 in the regression curve

A3

double precision real number

value of coefficient a3 in the regression curve

A4

double precision real number

value of coefficient a4 in the regression curve

A5

double precision real number

value of coefficient a5 in the regression curve

A6

double precision real number

value of coefficient a6 in the regression curve

multiplier

double precision real number

multiplier (index) that relatively multiplies the value derived from the curve

additivity

double precision real number

additivity (value) that absolutely moves the value derived from the curve

clearType

string

type of a cutting element: CIRCLE (patch cutting), STRIP (strip cutting)

clearXCoord

double precision real number

relative x-coordinate of the circle centre or the point situated on the strip axis (0 to 1)

clearYCoord

double precision real number

relative y-coordinate of the circle centre or the point situated on the strip axis (0 to 1)

clearWidth1

double precision real number

diameter of the inside circle of the patch or the width of the inside strip in metres

clearWidth2

double precision real number

diameter of the outside circle of the patch or the width of the outside strip in metres

clearDirection

double precision real number

azimuth (angle) of the strip axis (positive y axis) rotation clockwise from north in degrees

clearMarginalHeight

double precision real number

minimum tree height in metres specifying the marginal height below which trees are not removed (e.g. protection of natural regeneration)

Table MARKS

This table specifies the thinning by list (BYLIST) defined by a user at stand and period level. This variant is used for the simulation of e.g. permanent research plots, since in such cases we know which trees were marked as future crop trees, or which trees were selected for thinning. The table is also used in the case of interactive thinning, which is allowed only for the first period if the period length is equal to 0 years. In such a case, the user selects and marks the trees manually in the virtual reality, and the table MARKS is created by the program SIBYLA automatically.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

periode

long integer number

sequential number of the period starting from 1

number

long integer number

unique number of the tree in the stand (stand)

mark

long integer number

tree mark: 0 (unmarked), 1 (future crop tree), -1 (tree chosen for thinning)

Table CUTTING

This table defines individual methods, technologies, and activities during tree cutting, which are used for the output rates at stand and period level.

Field name

Field type

Field content

stand

string

unique identifier (name or number) of the stand

periode

long integer number

sequential number of the period starting from 1

method

string

tree cutting method: TREE, STEM, LOG

break

long integer number

work breaks: 0 (no breaks), 1 (with a break)

treeclass

long integer number

tree growth class: 1 to 3

rSlope

long integer number

percentage bonus for steep slope (max. 25%)

rTerrain

long integer number

percentage bonus for the broken terrain (max. 10%)

rShrub

long integer number

percentage bonus for the bushiness (max. 15%)

rSnow

long integer number

percentage bonus for the snow cover (max. 40%)

rWeather

long integer number

percentage bonus for severe weather (max. 13%)

rDecay

long integer number

percentage bonus for half-rotten trees (max. 10%)

rBranches

long integer number

percentage bonus for great branchiness (max. 10%)

rDensity

long integer number

percentage bonus for a very dense stand (max. 15%)

rCalamity

long integer number

percentage bonus for salvage cutting (max. 30%)

rOther

long integer number

other bonuses (max. 70%)

filter

long integer number

indicator of forest stand selection for the next cost calculation: 0 = stand is not selected, 1 = stand is selected

Table YARDING

This table defines individual methods, technologies, and activities during tree yarding, which are used for the output rates at stand and period level.

Field name

Field type

Field content

stand

string

unique identifier (name or number) of the stand

periode

long integer number

sequential number of the period starting from 1

horse

double precision real number

percentual proportion of horse utilisation

tractor

double precision real number

percentual proportion of tractor utilisation

cable

double precision real number

percentual proportion of cableway crane utilisation

tractorType

string

tractor type: LKT, UKT

cableType

string

cableway crane type: VLU, LANOR, KSK

horse_Load

long integer number

load preparation for a horse: 0 = no, 1 = yes

horse_Drive

long integer number

driving with a horse: 0 = no, 1 = yes

tractor_Extraction

long integer number

extraction with a tractor: 0 = no, 1 = yes

tractor_Skidding

long integer number

skidding with a tractor: 0 = no, 1 = yes

tractor_Unload

long integer number

unloading of a tractor: 0 = no, 1 = yes

horseCount

long integer number

number of horses: 1 or 2

horseCategory

long integer number

horse category: 1 = light, 2 = middle, 3 = heavy

tractorCrew

long integer number

tractor crew size: 1 or 2

unloadType

long integer number

type of unloading: 1 = only unloading, 2 = unloading and sorting, 3 = unloading and rolling, 4 = everything

cableCrew

long integer number

cableway crew size: 2 (only for LANOR), 3, 4 (only for KSK)

cableMethod

string

cableway method: STEM (stem or assortments), TREE (only for KSK)

extractionDistance

double precision real number

average extraction distance in metres

skiddingDistance

double precision real number

average skidding distance in metres

slope

double precision real number

average slope in per cent

direction

string

terrain: DOWN (downhill), UP (uphill)

rHorse

long integer number

percentage overplus for a horse (max. 250%)

rTractor1

long integer number

percentage overplus for extracting with a tractor (max. 130%)

rTractor2

long integer number

percentage overplus for skidding with a tractor (max. 150%)

rTractor3

long integer number

percentage overplus for unloading (max. 25%)

rCable

long integer number

percentage overplus for a cableway crane (max. 150%)

filter

long integer number

indicator of forest stand selection for the next cost calculation: 0 = stand is not selected, 1 = stand is selected

Table CONVERSION

This table defines individual methods, technologies, and activities during wood conversion, which are used for the output rates at stand and period level.

Field name

Field type

Field content

stand

string

unique identifier (name or number) of the stand

periode

long integer number

sequential number of the period starting from 1

chunk

double precision real number

percentage of chunkwood (round billets)

chunk_Rollout

long integer number

manual rolling out of chunkwood: 0 = no, 1 = yes

chunk_Measuring

long integer number

measuring chunkwood: 0 = no, 1 = yes

chunk_Cutting

long integer number

cutting chunkwood: 0 = no, 1 = yes

chunk_Sorting

long integer number

sorting chunkwood: 0 = no, 1 = yes

chunk_Loading

long integer number

loading chunkwood: 0 = no, 1 = yes

chunk_Movement

long integer number

moving chunkwood: 0 = no, 1 = yes

chunk_Heaping

long integer number

heaping chunkwood: 0 = no, 1 = yes

split

double precision real number

percentage of split billets

split_Hand

long integer number

manual splitting: 0 = no, 1 = yes

split_Machine

long integer number

mechanised splitting: 0 = no, 1 = yes

split_Sorting

long integer number

sorting of split billets: 0 = no, 1 = yes

split_Loading

long integer number

loading of split billets: 0 = no, 1 = yes

split_Movement

long integer number

moving split billets: 0 = no, 1 = yes

log_Rollout

long integer number

manual rolling out of logs: 0 = no, 1 = yes

log_Measuring

long integer number

manual measuring of logs: 0 = no, 1 = yes

log_Cutting

long integer number

cutting of logs (without mechanisation): 0 = no, 1 = yes

log_Processing

long integer number

processing of logs (cutting with mechanisation): 0 = no, 1 = yes

log_Conversion

long integer number

conversion of logs to transport lengths: 0 = no, 1 = yes

log_Movement

long integer number

manual movement of logs: 0 = no, 1 = yes

log_Heaping

long integer number

manual heaping of logs: 0 = no, 1 = yes

chungLength

long integer number

length of chunkwood: 1 or 2

logLength

double precision real number

log length in metres

distance

double precision real number

movement distance for logs and cordwood in metres

type

long integer number

wood conversion type: constant 1

rLog

long integer number

overplus for logs (max. 70%)

rChunk

long integer number

overplus for chunkwood (max. 60%)

rSplit

long integer number

overplus for split billets (max. 130%)

filter

long integer number

indicator of forest stand selection for the next cost calculation: 0 = stand is not selected, 1 = stand is selected

Table iPIX

This table defines spherical photographs, which are linked to the visualisation of the simulation plot at stand and period level.  

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

periode

long integer number

sequential number of the period starting from 1

number

long integer number

sequential number of the spherical photograph iPIX 

xCoord

double precision real number

x-coordinate of the point on the photograph (in metres)

yCoord

double precision real number

y-coordinate of the point where the photograph was taken (in metres)

fileName

string

File name and the path; the file has to be saved in the database directory (e.g. foto1.jpg), or in the sub-directory of the database directory (e.g. iPIX\foto1.ipx)

Table COVER

This table defines individual plots at stand level with different composition of herbs, fungi, and shrubs.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

part

long integer number

number of the stand part (rectangular plot): 1 to n

xFirst

double precision real number

x-coordinate of the first corner of the rectangular plot in metres (left bottom corner)

yFirst

double precision real number

y-coordinate of the first corner of the rectangular plot in metres (left bottom corner)

xLast

double precision real number

x-coordinate of the last corner of the rectangular plot in metres (right top corner)

yLast

double precision real number

y-coordinate of the last corner of the rectangular plot in metres (right top corner)

Table HERBS

This table defines the occurrence of particular herbs, fungi, and shrubs at stand level.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

part

long integer number

number of the stand part

herb

string

Latin name of the plant (blanks and dashes are substituted by the symbol "_") 

ratio

double precision real number

percentual proportion of the plant (coverage in % from the stand part)

meanHeight

double precision real number

average plant height in cm

meanWidth

double precision real number

average plant width in cm

Table INITIAL

This table defines initial tree data of the simulation plot at the level of stand, storey, and generated structure. The table usually results from the generation of forest structure, and hence, is not created by a user. If the user has all information about the simulation plot (except the optional information), he can directly fill in the table. In such a case, it is not necessary to use the tables of the input generator, and the module Generator.  

Field name

Field type

Field content

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

structure

long integer number

sequential number of the generated structure (1 to 20)

number

long integer number

unique number of the tree in the stand

name

string

tree species abbreviation as specified in the tree species code list

t

long integer number

tree age in years – OPTIONAL (if unknown, use 0)

dbh

double precision real number

tree diameter at 1.3m height (in cm)

h

double precision real number

tree height (in m)

cd

double precision real number

largest crown diameter (in cm)

ch

double precision real number

height to crown base (in m)

x

double precision real number

horizontal x-coordinate of the tree in the plot

y

double precision real number

horizontal y-coordinate of the tree in the plot

z

double precision real number

altitude of the tree foot in metres – OPTIONAL (only informative, e.g. the value from field measurements; during the simulation this altitude is derived from tables TERRAIN and SURFACE, hence, if unknown, the value 0 is used)

mark

long integer number

tree mark: 0 (unmarked), 1 (future crop tree), -1 (tree chosen for thinning)

mortality

long integer number

age of tree death in years – if alive, the value 0 is used

quality

string

tree quality degree: A, B, C, D

damage

long integer number

tree damage: 0 (undamaged), 1 (damaged)

rid

automatic number

relative identifier automatically inserted by the program independently of a user

 

Description of output tables

Table TREES

This table contains output production characteristics of individual trees.

Field name

Field type

Field content

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

structure

long integer number

sequential number of the generated structure (1 to 20)

prognosis

long integer number

sequential number of the prognosis (1 to 20)

periode

long integer number

sequential number of the period starting from 1

number

long integer number

unique number of the tree in the stand

name

string

tree species abbreviation as specified in the tree species code list

t

long integer number

tree age in years

dbh

double precision real number

tree diameter at 1.3m height (in cm) 

h

double precision real number

tree height (in m) 

cd

double precision real number

largest crown diameter (in cm)

ch

double precision real number

height to crown base (in m)

x

double precision real number

horizontal x-coordinate of the tree in the plot

y

double precision real number

horizontal y-coordinate of the tree in the plot

z

double precision real number

altitude of the tree foot in metres

mark

long integer number

tree mark: 0 (unmarked), 1 (future crop tree), -1 (tree chosen for thinning)

mortality

long integer number

age of tree death in years (if alive, the value equals 0)

mortReason

string

cause of tree death: UNKNOWN (tree was already dead at the beginning of the simulation), NATIVE (natural mortality), WIND, SNOW, ICING, STEMINSECT (bark miners and timber borers), CROWNINSECT (defoliators and other insects), FUNGI (wood-decaying fungi), AIRPOLLUTION, FIRE, DROUGHT, STEAL (illegal cutting), OTHER

quality

string

tree quality degree: A, B, C, D

damage

long integer number

tree damage: 0 (undamaged), 1 (damaged)

biosoc

long integer number

bio-sociological position of the tree: 1 (dominant tree), 2 (co-dominant tree), 3 (intermediate tree), 4 (shaded tree)

score

double precision real number

tree score of existence (0 to 1)

volume

double precision real number

volume of the timber to the top of 7 cm inside bark in m3

I6

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class 6 in m3

I5

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class 5 in m3

I4

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class  4 in m3

I3

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class  3 in m3

I2

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class  2 in m3

I1

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class  1 in m3

II6

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class  6 in m3

II5

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class  5 in m3

II4

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class  4 in m3

II3

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class  3 in m3

II2

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class  2 in m3

II1

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class  1 in m3

IIIA6

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class  6 in m3

IIIA5

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class  5 in m3

IIIA4

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class  4 in m3

IIIA3

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class  3 in m3

IIIA2

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class  2 in m3

IIIA1

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class  1 in m3

IIIB6

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class  6 in m3

IIIB5

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class  5 in m3

IIIB4

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class  4 in m3

IIIB3

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class  3 in m3

IIIB2

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class  2 in m3

IIIB1

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class  1 in m3

V

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class V in m3

VI

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class VI in m3

rest

double precision real number

volume of the residue timber to the top of 7 cm inside bark in m3

filter

long integer number

indicator of forest stand selection for the next visualisation of the results: 0 = stand is not selected, 1 = stand is selected

rid

automatic number

relative identifier automatically inserted by the program independently of a user

Table ELEMENTS

This table contains output characteristics of biomass and the content of chemical elements of individual trees.

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

structure

long integer number

sequential number of the generated structure (1 to 20)

prognosis

long integer number

sequential number of the prognosis (1 to 20)

periode

long integer number

sequential number of the period starting from 1

number

long integer number

unique number of the tree in the stand

name

string

tree species abbreviation as specified in the tree species code list

vBark

double precision real number

volume of the timber to the top of 7 cm outside bark in m3

rootstump

double precision real number

dry matter biomass of roots and stump in kg

stemwood

double precision real number

dry matter biomass of stem wood in kg

stembark

double precision real number

dry matter biomass of stem bark in kg 

branches

double precision real number

dry matter biomass of bark and wood of branches in kg

foliage

double precision real number

dry matter biomass of foliage (leaves or needles) in kg

C

double precision real number

carbon content in kg

N

double precision real number

nitrogen content in kg

P

double precision real number

phosphorus content in kg

K

double precision real number

potassium content in kg

Ca

double precision real number

calcium content in kg

Mg

double precision real number

magnesium content in kg

S

double precision real number

sulphur content in kg

Fe

double precision real number

iron content in kg

Mn

double precision real number

manganese content in kg

Cu

double precision real number

copper content in kg

Zn

double precision real number

zinc content in kg

Mo

double precision real number

molybdenum content in kg

B

double precision real number

boron content in kg

Cl

double precision real number

chlorine content in kg

Pb

double precision real number

lead content in kg

As

double precision real number

arsenic content in kg

Cr

double precision real number

chromium content in kg

Cd

double precision real number

cadmium content in kg

Ni

double precision real number

nikel content in kg

Si

double precision real number

silicon content in kg

Al

double precision real number

aluminium content in kg

Na

double precision real number

sodium content in kg

Ti

double precision real number

titanium content in kg

Co

double precision real number

cobalt content in kg

ash

double precision real number

ash content in kg
tH2O double precision real number potential amount of transpired water in liters per year

rid

automatic number

relative identifier automatically inserted by the program independently of a user

Table Biomass

This table contains summary output about the biomass and the content of chemical elements in individual stand components of the simulation plot.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

structure

long integer number

sequential number of the generated structure (1 to 20)

prognosis

long integer number

sequential number of the prognosis (1 to 20)

periode

long integer number

sequential number of the period starting from 1

part

string

code of the stand component: ALL (dominant crop), MAIN (main crop), CUTTING (secondary crop), MORTALITY (dead trees), TARGET (future crop trees)

species

string

tree species abbreviation as specified in the tree species code list (in addition, the abbreviation sum is used representing the output for all tree species together)

rootstump

double precision real number

dry matter biomass of roots and stump in kg per hectare

stemwood

double precision real number

dry matter biomass of stem wood in kg per hectare

stembark

double precision real number

dry matter biomass of stem bark in kg per hectare

branches

double precision real number

dry matter biomass of wood and bark of branches in kg per hectare

foliage

double precision real number

dry matter biomass of foliage (leaves or needles) in kg per hectare

fulltree

double precision real number

dry matter biomass of the whole tree in kg per hectare

C

double precision real number

carbon content in kg per hectare

N

double precision real number

nitrogen content in kg per hectare

P

double precision real number

phosphorus content in kg per hectare

K

double precision real number

potassium content in kg per hectare

Ca

double precision real number

calcium content in kg per hectare

Mg

double precision real number

magnesium content in kg per hectare

S

double precision real number

sulphur content in kg per hectare

Fe

double precision real number

iron content in kg per hectare

Mn

double precision real number

manganese content in kg per hectare

Cu

double precision real number

copper content in kg per hectare

Zn

double precision real number

zinc content in kg per hectare

Mo

double precision real number

molybdenum content in kg per hectare

B

double precision real number

boron content in kg per hectare

Cl

double precision real number

chlorine content in kg per hectare

Pb

double precision real number

lead content in kg per hectare

As

double precision real number

arsenic content in kg per hectare

Cr

double precision real number

chromium content in kg per hectare

Cd

double precision real number

cadmium content in kg per hectare

Ni

double precision real number

nikel content in kg per hectare

Si

double precision real number

silicon content in kg per hectare

Al

double precision real number

aluminium content in kg per hectare

Na

double precision real number

sodium content in kg per hectare

Ti

double precision real number

titanium content in kg per hectare

Co

double precision real number

cobalt content in kg per hectare
ash double precision real number ash content in kg per hectare

tH2O

double precision real number

potential amount of transpired water in liters per year

Table Biodiversity

This table containts output characterising stand biodiversity.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

structure

long integer number

sequential number of the generated structure (1 to 20)

prognosis

long integer number

sequential number of the prognosis (1 to 20)

periode

long integer number

sequential number of the period starting from 1

SpeciesCount

long integer number

number of tree species (tree species richness)

R1

double precision real number

index of tree species richness R1

R2

double precision real number

index of tree species richness R2

lambda

double precision real number

index of tree species heterogeneity lambda

H

double precision real number

index of tree species heterogeneity H' (entropy)

E1

double precision real number

index of tree species evenness E1

E5

double precision real number

index of tree species evenness E5

R

double precision real number

index of horizontal structure R (Clark-Evans index)

TMd

double precision real number

index of diameter differentiation

TMh

double precision real number

index of height differentiation

APi

double precision real number

index of vertical structure ("Arten Profil" index by Pretzsch)

A

double precision real number

tree species diversity according to Jaehne and Dohrenbusch

S

double precision real number

diversity of vertical structure according to Jaehne and Dohrenbusch

V

double precision real number

diversity of tree spatial distribution according to Jaehne and Dohrenbusch

K

double precision real number

diversity of crown differentiation according to Jaehne and Dohrenbusch

B

double precision real number

total diversity according to Jaehne and Dohrenbusch

Table Production

This table containts output characterising production of individual stand components of the simulation plot.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

structure

long integer number

sequential number of the generated structure (1 to 20)

prognosis

long integer number

sequential number of the prognosis (1 to 20)

periode

long integer number

sequential number of the period starting from 1

part

string

code of the stand component: ALL (dominant crop), MAIN (main crop), CUTTING (secondary crop), MORTALITY (dead trees), TARGET (future crop trees)

species

string

tree species abbreviation as specified in the tree species code list (in addition, the abbreviation sum is used representing the output for all tree species together)

t

long integer number

mean age in years

d

double precision real number

mean diameter in cm

sd

double precision real number

standard deviation of mean diameter in cm

h

double precision real number

mean height in metres

v

double precision real number

mean stem volume in m3

Nha

long integer number

number of trees per hectare

Gha

double precision real number

basal area per hectare in m2

Vha

long integer number

stand volume per hectare in m3

PCAha

double precision real number

crown projection area of trees per hectare in m2

CC

double precision real number

crown closure in per cent

SDI

double precision real number

SDI index (Stand Density Index)

rSDI

double precision real number

relative SDI index (stand density)

Table Returns

This table containts output characterising revenues from individual stand components of the simulation plot.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

structure

long integer number

sequential number of the generated structure (1 to 20)

prognosis

long integer number

sequential number of the prognosis (1 to 20)

periode

long integer number

sequential number of the period starting from 1

part

string

code of the stand component: ALL (dominant crop), MAIN (main crop), CUTTING (secondary crop), MORTALITY (dead trees), TARGET (future crop trees)

species

string

tree species abbreviation as specified in the tree species code list (in addition, the abbreviation sum is used representing the output for all tree species together)

v_I6

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class 6 in m3.ha-1

v_I5

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class 5 in m3.ha-1

v_I4

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class 4 in m3.ha-1

v_I3

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class 3 in m3.ha-1

v_I2

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class 2 in m3.ha-1

v_I1

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class I and diameter class 1 in m3.ha-1

v_II6

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class 6 in m3.ha-1

v_II5

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class 5 in m3.ha-1

v_II4

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class 4 in m3.ha-1

v_II3

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class 3 in m3.ha-1

v_II2

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class 2 in m3.ha-1

v_II1

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class II and diameter class 1 in m3.ha-1

v_IIIA6

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class 6 in m3.ha-1

v_IIIA5

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class 5 in m3.ha-1

v_IIIA4

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class 4 in m3.ha-1

v_IIIA3

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class 3 in m3.ha-1

v_IIIA2

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class 2 in m3.ha-1

v_IIIA1

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIA and diameter class 1 in m3.ha-1

v_IIIB6

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class 6 in m3.ha-1

v_IIIB5

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class 5 in m3.ha-1

v_IIIB4

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class 4 in m3.ha-1

v_IIIB3

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class 3 in m3.ha-1

v_IIIB2

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class 2 in m3.ha-1

v_IIIB1

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class IIIB and diameter class 1 in m3.ha-1

v_V

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class V in m3.ha-1

v_VI

double precision real number

volume of the timber to the top of 7 cm inside bark of quality class VI in m3.ha-1

v_rest

double precision real number

volume of the residual timber to the top of 7 cm inside bark in m3.ha-1

p_I6

double precision real number

price of quality class I and diameter class 6 in EUR.ha-1

p_I5

double precision real number

price of quality class I and diameter class 5 in EUR.ha-1

p_I4

double precision real number

price of quality class I and diameter class 4 in EUR.ha-1

p_I3

double precision real number

price of quality class I and diameter class 3 in EUR.ha-1

p_I2

double precision real number

price of quality class I and diameter class 2 in EUR.ha-1

p_I1

double precision real number

price of quality class I and diameter class 1 in EUR.ha-1

p_II6

double precision real number

price of quality class II and diameter class 6 in EUR.ha-1

p_II5

double precision real number

price of quality class II and diameter class 5 in EUR.ha-1

p_II4

double precision real number

price of quality class II and diameter class 4 in EUR.ha-1

p_II3

double precision real number

price of quality class II and diameter class 3 in EUR.ha-1

p_II2

double precision real number

price of quality class II and diameter class 2 in EUR.ha-1

p_II1

double precision real number

price of quality class II and diameter class 1 in EUR.ha-1

p_IIIA6

double precision real number

price of quality class IIIA and diameter class 6 in EUR.ha-1

p_IIIA5

double precision real number

price of quality class IIIA and diameter class 5 in EUR.ha-1

p_IIIA4

double precision real number

price of quality class IIIA and diameter class 4 in EUR.ha-1

p_IIIA3

double precision real number

price of quality class IIIA and diameter class 3 in EUR.ha-1

p_IIIA2

double precision real number

price of quality class IIIA and diameter class 2 in EUR.ha-1

p_IIIA1

double precision real number

price of quality class IIIA and diameter class 1 in EUR.ha-1

p_IIIB6

double precision real number

price of quality class IIIB and diameter class 6 in EUR.ha-1

p_IIIB5

double precision real number

price of quality class IIIB and diameter class 5 in EUR.ha-1

p_IIIB4

double precision real number

price of quality class IIIB and diameter class 4 in EUR.ha-1

p_IIIB3

double precision real number

price of quality class IIIB and diameter class 3 in EUR.ha-1

p_IIIB2

double precision real number

price of quality class IIIB and diameter class 2 in EUR.ha-1

p_IIIB1

double precision real number

price of quality class IIIB and diameter class 1 in EUR.ha-1

p_V

double precision real number

price of quality class V in EUR.ha-1

p_VI

double precision real number

price of quality class VI in EUR.ha-1

p_rest

double precision real number

price or residues in EUR.ha-1

Table Costs

This table containts output characterising costs within individual stand components of the simulation plot.

Field name

Field type

Field content

rid

automatic number

relative identifier automatically inserted by the program independently of a user

stand

string

unique identifier (name or number) of the stand

storey

long integer number

numerical identification of forest stand layers (storey): 0 = no storey is distinguished, 1 to 9 = storey identifiers

structure

long integer number

sequential number of the generated structure (1 to 20)

prognosis

long integer number

sequential number of the prognosis (1 to 20)

periode

long integer number

sequential number of the period starting from 1

part

string

code of the stand component: ALL (dominant crop), MAIN (main crop), CUTTING (secondary crop), MORTALITY (dead trees), TARGET (future crop trees)

species

string

tree species abbreviation as specified in the tree species code list (in addition, the abbreviation sum is used representing the output for all tree species together)

wages_cutting

double precision real number

direct costs for cutting in EUR.ha-1

wages_transport

double precision real number

direct costs for yarding in EUR.ha-1

wages_conversion

double precision real number

direct costs for wood conversion in EUR.ha-1

overall_cost

double precision real number

overall direct costs in EUR.ha-1

Table Summary

This table contains selected summary output for all simulated stands together.

Field name

Field type

Field content

structure

long integer number

sequential number of the generated structure (1 to 20)

prognosis

long integer number

sequential number of the prognosis (1 to 20)

periode

long integer number

sequential number of the period starting from 1

part

string

code of the stand component: ALL (dominant crop), MAIN (main crop), CUTTING (secondary crop), MORTALITY (dead trees), TARGET (future crop trees)

species

string

tree species abbreviation as specified in the tree species code list (in addition, the abbreviation sum is used representing the output for all tree species together)

stand_count

long integer number

total number of simulation plots (stands)

area_total

double precision real number

total original area of all stands in hectares that are represented by simulation plots

V_total

double precision real number

total volume of all stands in m3 that are represented by simulation plots

G_total

double precision real number

total basal area of all stands in m2 that are represented by simulation plots

V_ha

long integer number

total volume in m3 per hectare

G_ha

double precision real number

total basal area in m2 per hectare

percentage

double precision real number

relative tree species proportion (from 0 to 1)

v1

double precision real number

total volume of age class 1 in m3 (1-10 years)

v2

double precision real number

total volume of age class 2 in m3 (11-20 years)

v3

double precision real number

total volume of age class 3 in m3 (21-30 years)

v4

double precision real number

total volume of age class 4 in m3 (31-40 years)

v5

double precision real number

total volume of age class 5 in m3 (41-50 years)

v6

double precision real number

total volume of age class 6 in m3 (51-60 years)

v7

double precision real number

total volume of age class 7 in m3 (61-70 years)

v8

double precision real number

total volume of age class 8 in m3 (71-80 years)

v9

double precision real number

total volume of age class 9 in m3 (81-90 years)

v10

double precision real number

total volume of age class 10 in m3 (91-100 years)

v11

double precision real number

total volume of age class 11 in m3 (101-110 years)

v12

double precision real number

total volume of age class 12 in m3 (111-120 years)

v13

double precision real number

total volume of age class 13 in m3 (121-130 years)

v14

double precision real number

total volume of age class 14 in m3 (131-140 years)

v15

double precision real number

total volume of age class 15 in m3 (141-150 years)

v15_plus

double precision real number

total volume of age class 15+ in m3 (151 and more years)

s1

double precision real number

total area of age class 1 in hectares (1-10 years)

s2

double precision real number

total area of age class 2 in hectares (11-20 years)

s3

double precision real number

total area of age class 3 in hectares (21-30 years)

s4

double precision real number

total area of age class 4 in hectares (31-40 years)

s5

double precision real number

total area of age class 5 in hectares (41-50 years)

s6

double precision real number

total area of age class 6 in hectares (51-60 years)

s7

double precision real number

total area of age class 7 in hectares (61-70 years)

s8

double precision real number

total area of age class 8 in hectares (71-80 years)

s9

double precision real number

total area of age class 9 in hectares (81-90 years)

s10

double precision real number

total area of age class 10 in hectares (91-100 years)

s11

double precision real number

total area of age class 11 in hectares (101-110 years)

s12

double precision real number

total area of age class 12 in hectares (111-120 years)

s13

double precision real number

total area of age class 13 in hectares (121-130 years)

s14

double precision real number

total area of age class 14 in hectares (131-140 years)

s15

double precision real number

total area of age class 15 in hectares (141-150 years)

s15_plus

double precision real number

total area of age class 15+ in hectares (151 and more years)

v_I

double precision real number

total volume of quality class I in m3.ha-1

v_II

double precision real number

total volume of quality class II in m3.ha-1

v_IIIA

double precision real number

total volume of quality class IIIA in m3.ha-1

v_IIIB

double precision real number

total volume of quality class IIIB in m3.ha-1

v_V

double precision real number

total volume of quality class V in m3.ha-1

v_VI

double precision real number

total volume of quality class VI in m3.ha-1

v_rest

double precision real number

total volume of residues in m3.ha-1

returns_ha

double precision real number

total gross earnings in EUR.ha-1 (earnings from timber assortments)

wages_cutting_ha

double precision real number

total direct costs for cutting in EUR.ha-1

wages_transport_ha

double precision real number

total direct costs for yarding in EUR.ha-1

wages_conversion_ha

double precision real number

total direct costs for wood conversion in EUR.ha-1

overall_cost_ha

double precision real number

summary overall direct costs in EUR.ha-1

 

Description of database code lists

Tree species code list (code_SPECIES)

This code list contains the list of available tree species.

tree species code

English name

Latin name

production similarity (model)

produkcna príbuznosť

SM

Norway spruce 

Picea abies

spruce

SP

Blue spruce

Picea pungens

spruce

JD

Silver fir

Abies alba

fir

JO

Grand fir

Abies grandis

fir

BO

Scots and European black pine 

Pinus silvestris, nigra

pine

VJ

Weymouth pine

Pinus strobus

pine

LB

Cembra pine

Pinus cembre

pine

SC

larch

Larix sp.

pine

DG

Douglas fir

Pseudotsuga sp.

fir

TS

yew

Taxus baccata

fir

BK

beech

Fagus sp.

beech

DB

oak

Quercus sp.

oak

HB

hornbeam

Carpinus betulus

beech

JVp

Field maple

Acer campestre

beech

JVh

Sycamore

Acer pseudoplatanus

beech

JVm

Norway maple

Acer platanoides

beech

JS

ash

Fraxinus sp.

oak

BT

elm

Ulmus sp.

oak

LP

lime

Tilia sp.

beech

AG

robinia

Robinia sp.

oak

BR

birch

Betula sp.

beech

TP

poplar

Populus sp.

beech

OS

aspen

Populus tremula

beech

VR

willow

Salix sp.

beech

JL

alder

Alnus sp.

beech

CS

cherry

Cerasus sp.

beech

JR

rowan

Sorbus sp.

beech

OR

walnut

Juglans sp.

beech

GS

chestnut

Castanea sp.

beech

PT

plane

Platanus sp.

beech

Code list named code_TARIFF

This code list contains wage tariffs T (EUR.h-1) for basic operations (performance): CUTTING, YARDING, CONVERSION.

Code list named code_INDICES

This code list contains the reduction coefficient of compensation for the chain-saw (CHAINSAW) KJMP and the coefficient of funds contribution (TAX) KMOSP.

Code list named code_MATERIAL

This code list contains material costs in EUR per unit (m3 or reduced man-hour) for individual performances.

performance

activity performed with

unit

HORSE

horse

EUR.m-3

UKT

common wheeled tractor

EUR.m-3

LKT

forest wheeled tractor

EUR.m-3

CABLE

cableway crane

EUR.m-3

CHAINSAW

chain-saw

EUR.rNh-1

Code list named code_PRICES

This code list contains the price of assortments (belonging to a particular quality and diameter class) in EUR per m3. 

Field name

Field type

Field content

species

string

tree species abbreviation as specified in tree species code list

I1

long integer number

price of quality class I and diameter class 1 in EUR.m-3 

I2

long integer number

price of quality class I and diameter class 2 in EUR.m-3

I3

long integer number

price of quality class I and diameter class 3 in EUR.m-3

I4

long integer number

price of quality class I and diameter class 4 in EUR.m-3

I5

long integer number

price of quality class I and diameter class 5 in EUR.m-3

I6

long integer number

price of quality class I and diameter class 6 in EUR.m-3

II1

long integer number

price of quality class II and diameter class 1 in EUR.m-3

II2

long integer number

price of quality class II and diameter class 2 in EUR.m-3

II3

long integer number

price of quality class II and diameter class 3 in EUR.m-3

II4

long integer number

price of quality class II and diameter class 4 in EUR.m-3

II5

long integer number

price of quality class II and diameter class 5 in EUR.m-3

II6

long integer number

price of quality class II and diameter class 6 in EUR.m-3

IIIA1

long integer number

price of quality class IIIA and diameter class 1 in EUR.m-3

IIIA2

long integer number

price of quality class IIIA and diameter class 2 in EUR.m-3

IIIA3

long integer number

price of quality class IIIA and diameter class 3 in EUR.m-3

IIIA4

long integer number

price of quality class IIIA and diameter class 4 in EUR.m-3

IIIA5

long integer number

price of quality class IIIA and diameter class 5 in EUR.m-3

IIIA6

long integer number

price of quality class IIIA and diameter class 6 in EUR.m-3

IIIB1

long integer number

price of quality class IIIB and diameter class 1 in EUR.m-3

IIIB2

long integer number

price of quality class IIIB and diameter class 2 in EUR.m-3

IIIB3

long integer number

price of quality class IIIB and diameter class 3 in EUR.m-3

IIIB4

long integer number

price of quality class IIIB and diameter class 4 in EUR.m-3

IIIB5

long integer number

price of quality class IIIB and diameter class 5 in EUR.m-3

IIIB6

long integer number

price of quality class IIIB and diameter class 6 in EUR.m-3

V

long integer number

price of quality class V in EUR.m-3

VI

long integer number

price of quality class VI in EUR.m-3

rest

long integer number

price of residues in EUR.m-3

Code lists of output rates

These code lists contain settings required for the derivation of man-time from output rates. Their name begins with the characters vn_ that are followed by the Slovak name of the performance (activity).

Note: Non-professional changes in these code lists can cause the corruption of the module calculating the costs !!!

© Copyright doc. Ing. Marek Fabrika, PhD.

© Translated by Dr. Ing. Katarína Merganičová - FORIM