StandRegisterFileSpecification
Jump to navigation
Jump to search
Notes:
- The file specification is also included in the Excel-file, in sheet Column Descriptions.
- Column order is irrelevant, the import function uses column names for matching. Optional columns can be be dropped, or left blank. It is important that the column names are correct.
- The fields MapId, StandId, and SubStandId are used to create a unique name for each treatment unit. StandId is mandatory, but MapId and SubStandId are optional. The unique name is created in the following format: MapId + Space + StandId + Space + SubStandId. Therefore the combination of the fields 1, 2 and 3 must be unique within a stand register. If MapId and SubStandId are not included or empty, StandId must be unique (except for when a row refers to an overstorey layer or layer with retention trees for a certain stand, in that case two or three rows refer to the same stand).
- Columns denoted as "Required..." in the table below are required if single tree-data should be simulated (with a Weibull-distribution, see below).
- Do not enter zeroes in cells unless the values should actually be zero. Leave the cells empty or remove columns for which you have no data.
- If "Maturity Class" is used, make sure it is correctly depicted, e.g. no overstorey data are allowed to describe a stand classified as K. The class R2 should be used with precaution (if treatment programs including cleaning should be generated, use class R1).
No | Field | Type (length) | Valid values | Required for generating tree list? | Description |
1 | MapId | int (max 5 pos) | 1-99999 | No | |
2 | StandId | string(25) | Yes | Identity of stand (sv: Avdelning) Mandatory! | |
3 | SubStandId | int (max 1 pos) | 0-9 | No | |
4 | AreaLevel2 | string(50) | No | Description for level two, to be used in any subdivision of the analysis area (for stratification purposes, etc.) | |
5 | AreaLevel3 | string(50) | No | Description for level three, to be used in any subdivision of the analysis area (for stratification purposes, etc.) | |
6 | Register | int | No | Register number (some users want this to use when defining forest domains in PlanWise, equivalent to UserDefined below) | |
7 | Layer | Int | 1,2,6 | No | 1 or blank = Main layer, 2 = Overstorey (seed trees or shelterwood), 6 = Nature conservation retention trees |
8 | Definition:CountyCode | Int | 1-31 | See comment | Mandatory only if no coordinates are given when using program version 2.1 or later. Mandatory in version 2.0 and earlier. Follow link to see codes. |
9 | Altitude | float | Yes | Altitude (h.a.m.s.l., m) | |
10 | Latitude | float | 54-70 | See comment | Latitude (° N, can be seen in the ClimateCode-map below). Mandatory only if no coordinates are given. |
11 | CoordEast | double | See comment | East coordinate, m (SWEREF99). Mandatory if any of CountyCode, Latitude and ClimateCode is missing. | |
12 | CoordNorth | double | See comment | North coordinate, m (SWEREF99). Mandatory if any of CountyCode, Latitude and ClimateCode is missing. | |
13 | DistanceToCoast | int | See comment | (km). Mandatory only if no coordinates are given when using program version 2.1 or later. Mandatory in version 2.0 and earlier. | |
14 | Definition:ClimateCode | Int | 1-6 | See comment | Mandatory only if no coordinates are given when using program version 2.1 or later. Mandatory in version 2.0 and earlier. Follow link to see codes. |
15 | SoilMoistureCode | Int | 1-5 | Yes | 1 = Dry |
2 = Mesic | |||||
3 = Mesic-moist | |||||
4 = Moist | |||||
5 = Wet | |||||
16 | VegetationType | Int | 1-18 | Yes | Follow link to see codes. |
17 | SKSManagementClass | char(2) | Code (ex. PG) | No | Type of management class according to "Skogsstyrelsens målklassning för Grön skogsbruksplan" ("Green Forest Management Plan") |
NO = "Naturvård orörd": Environmental goals with undisturbed forest | |||||
NS = "Naturvård skötsel": Environmental goals with adapted management | |||||
PF = "Produktion förstärkt hänsyn": Production goals with reinforced considerations | |||||
PG = "Produktion generell hänsyn": Production goals with general environmental considerations | |||||
18 | MaturityClass | char(2) | Code (ex. K1) | No | Maturity class (sv: Huggningsklass) |
K1 = Kalmark som är obehandlad eller ofullständigt behandlad (åtgärder kvarstår). Bare land, no regeneration. | |||||
K2 = Kalmark under föryngring, behandlad med nödvändiga återväxtåtgärder (åtgärder utförda). Bare land, regeneration treatments have been done. | |||||
R1 = Röjningsskog. Plantskog, skog vars huvudträdslag har en medelhöjd som är lägre än 1.3 m. Young stand, mean height of main species < 1.3 m. | |||||
R2 = Röjningsskog. Ungskog, skog vars huvudträdslag har en medelhöjd som är 1.3 m eller högre. Young stand, mean height of main species >= 1.3 m. | |||||
G1 = Yngre gallringsskog, skog som är yngre än lägsta tillåtna ålder för föryngringsavverkning. Young stand ready for first thinning. Mean arithmetic height >= 6-7 m. | |||||
G2 = Äldre gallringsskog, skog som snart uppnår lägsta ålder för föryngringsavverkning. Stand that will soon reach the minimum allowed final felling. Thinning can also be applied. | |||||
S1 = Skog som kan föryngringsavverkas. Yngre avverkningsbar skog som inte är att hänföra till S2. Stand that is eligible for final felling, minimum cutting age has been reached. | |||||
S2 = Skog som är mogen att föryngringsavverka. Skog som uppnått lämplig växttid eller som av andra skäl bör föryngringsavverkas. Stand that has reached its optimum MAI (Mean annual increment) and from a volume production maximization perspective should be clear cut. | |||||
S3 = Skog som är mogen att föryngringsavverka, men som inte bör föryngringsavverkas pga. naturvårdsskäl. Stand that can be clear cut, but should be avoided for some reason, for example nature conservation. | |||||
E1 = Restskog. | |||||
E2 = Gles skog eller skog av ett för marken olämpligt trädslag. | |||||
E3 = Hagmarkskog. | |||||
19 | EvenAgedCode | int | 1-3 | Yes | Not only reflecting the ages but also the stands' homogeneity regarding tree sizes (with impact on the diameter distribution, see below. |
1 = EvenAged | |||||
2 = MostlyEvenAged | |||||
3 = UnevenAged | |||||
20 | SoilBearingCapacity | Int | 1-5 | No | (sv: Grundförhållanden i "GYL") |
1 = Very good soil bearing. Normally soil is good for driving on during all year | |||||
2 = Good soil bearing. Normally soil is good for driving on during all year, with exception of while thowing in the ground and heavy autumn rains | |||||
3 = Medium good soil bearing. Be precautious during periods of high humidity in soil, especially in low terrain, heavy vehicles and many crossings | |||||
4 = Medium soil bearing. Reinforcement in soil is of great importance. When not frozen, the bearing is uncertain | |||||
5 = Very bad soil bearing. Vehicles are only to be used when soil is frozen | |||||
21 | Surface | int | 1-5 | No | (sv: Ytstruktur i "GYL") |
1 = No surface boulders | |||||
2 = Few boulders | |||||
3 = Scattered boulders | |||||
4 = Frequent boulders | |||||
5 = Large boulders | |||||
22 | Slope | int | 1-5 | No | (sv: Lutning i "GYL") |
1 = 0-10 % | |||||
2 = 10-20 % | |||||
3 = 20-33 % | |||||
4 = 33-50 % | |||||
5 = >50 % | |||||
23 | InventoryYear | int | Yes | Inventory year or date in format YYYY or YYYY-MM-DD | |
24 | OwnerType | int | 0-5 | No | |
0 = Unknown | |||||
1 = State | |||||
2 = Ecclesiastical | |||||
3 = OtherPublic | |||||
4 = Corporation | |||||
5 = Private | |||||
25 | SIS | double | Yes | Site index as determined by site factors (H100 or H50 (for birch and P. contorta), m) | |
26 | SiteIndexSpecies | int | Yes | Species for which SiteIndex refers to: | |
1 = Pine (or letter T) | |||||
2 = Spruce (or letter G) | |||||
3 = Birch (or letter B) | |||||
5 = Oak (or letters Ek) | |||||
6 = Beech (or letters Bok) | |||||
8 = P. contorta (or letter C) | |||||
NB: The system requires SI-values for either pine (T) or spruce (G). Hence, site indices for P. contorta will be converted to a corresponding value for pine; site indices for birch, oak, and beech will be converted to a corresponding value for spruce. | |||||
27 | TotalArea | double | No | ha | |
28 | ProdArea | double | Yes | Productive area (ha) | |
29 | ImpArea | double | No | Impediment area (ha) | |
30 | NCArea | double | No | Nature conservation area (ha), i.e. area set aside from timber production | |
31 | DGV | double | See comment | Mean diameter (basal area weighted, cm). For an established stand (mean height >= 7 m, at least two of DGV, DG, N and G must be entered) | |
32 | DG | double | See comment | Quadratic mean diameter (cm) (sv: Grundytemedelstammens diameter, normalt något mindre än den grundytevägda medeldiametern). For an established stand (mean height >= 7 m, at least two of DGV, DG, N and G must be entered) | |
33 | H | double | No | Mean height (basal area weighted, m) | |
34 | MeanAge | double | Yes | Mean tree total age (basal area weighted, years) | |
35 | N | double | See comment | Stem density (no of trees/ha, productive area). For an established stand (mean height >= 7 m, at least two of DGV, DG, N and G must be entered) | |
36 | G | float | See comment | Basal area (m2/ha, productive area). For an established stand (mean height >= 7 m, at least two of DGV, DG, N and G must be entered) | |
37 | V | double | No | Volume (m3sk/ha, productive area). Can be used to compare with volumes calulated with Heureka. | |
38 | CAI | double | No | Current annual volume increment (m3sk/ha, yr) | |
39 | PropPine | float | Yes | Proportion pine of basal area if mean height >7 m, otherwise prop. of stem density. Can be left empty if zero. | |
40 | PropSpruce | float | Yes | Can be left empty if zero. | |
41 | PropBirch | float | Yes | Can be left empty if zero. | |
42 | PropAspen | float | Yes | Can be left empty if zero. | |
43 | PropOak | float | Yes | Can be left empty if zero. | |
45 | PropBeech | float | Yes | Can be left empty if zero. | |
46 | PropDeciduous | float | Yes | (sv: Övrigt ädellöv) Can be left empty if zero. | |
47 | PropContorta | float | Yes | Can be left empty if zero. | |
48 | PropBroadleaf | float | Yes | (sv: Övrigt triviallöv) Can be left empty if zero. | |
48 | PropLarch | float | Yes | (sv: Lärk (europeisk eller sibirisk)) Can be left empty if zero. | |
49 | DiameterType | int | 0-1 | No | Indicator for which type of mean diameter is entered in fields DGPine to DGBroadLeaf. |
0 (default)= Diameter of mean basal area tree | |||||
1 = Basal area weighted mean diameter | |||||
50 | DGPine | float | No | Mean diameter pine (cm) | |
51 | DGSpruce | float | No | ||
52 | DGBirch | float | No | ||
53 | DGAspen | float | No | ||
54 | DGOak | float | No | ||
55 | DGBeech | float | No | ||
56 | DGDeciduous | float | No | ||
57 | DGContorta | float | No | ||
58 | DGBroadleaf | float | No | ||
59 | DGLarch | float | No | ||
60 | HPine | float | No | Mean height pine (basal area weighted, m) | |
61 | HSpruce | float | No | ||
62 | HBirch | float | No | ||
63 | HAspen | float | No | ||
64 | HOak | float | No | ||
65 | HBeech | float | No | ||
66 | HDeciduous | float | No | ||
67 | HContorta | float | No | ||
66 | HBroadleaf | float | No | ||
67 | HLarch | float | No | ||
68 | TerrainTransportDistance | int | No | One way average terrain transport distance from centre of stand to nearest road (meters) | |
69 | LastClearcutYear | int | No | Year when clearcut was last performed. Format YYYY | |
70 | LastThinningYear | int | No | Year or date when thinning was last performed. Format YYYY or YYYY-MM-DD | |
71 | LastFertilizationYear | int | No | Year or date when fertilization was last performed. Format YYYY or YYYY-MM-DD | |
72 | LastRegenerationYear | int | No | Year or date when regeneration was last performed. Format YYYY or YYYY-MM-DD | |
73 | RegenerationMethod | int | 0-2 | No | (Used if MaturityClass is entered and set to K1) |
0 = Natural regeneration | |||||
1 = Plantation | |||||
2 = Sowing | |||||
74 | RegenerationSpecies | int | 1-9 | No | Regeneration species (group code). Definition of species codes: Definition:SpeciesCode |
Can be used to control regeneration species on current bare land, if not site index species should be used. A preferable option is to use sheet TreatmentProposals instead. | |||||
75 | TreatmentProposal | int | 0 | No | Note: If treatment proposals are given, they should preferably be entered in sheet TretmentProposals in the Excel-file (see Heureka Helpdoc. Use number codes: Definition:TreatmentCode |
76 | TreatmentPriority | int | 0-4 | No | Note: If treatment proposals are given, they should preferably be entered in sheet TretmentProposals in the Excel-file (see Heureka Helpdoc |
0 = Not available | |||||
1 = Within 5 years | |||||
2 = Within 5 to 10 years | |||||
3 = Within 10 to 15 years | |||||
4 = Beyond 15 years | |||||
77 | Note | string(max) | No | ||
78 | UserDefinedVariable1 | int | No | Open for user defined setting. If you change the column heading to another name, it will be available when selecting data and in tables views etc. | |
79 | UserDefinedVariable2 | int | No | -"- | |
80 | UserDefinedVariable3 | int | No | -"- | |
81 | UserDefinedVariable4 | int | No | -"- | |
82 | UserDefinedVariable5 | int | No | -"- | |
83 | UserDefinedVariable6 | real | No | -"- | |
84 | UserDefinedVariable7 | real | No | -"- | |
85 | UserDefinedVariable8 | real | No | -"- | |
86 | UserDefinedVariable9 | real | No | -"- | |
87 | UserDefinedVariable10 | real | No | -"- | |
88 | DeadWoodTotal | real | No | Volume of dead wood (m3/ha) | |
89 | DeadWoodDecayClass1 | real | No | Volume of dead wood in decay class 0 (m3/ha). Note: Corresponds to DecayClass0 in the results! | |
90 | DeadWoodDecayClass2 | real | No | Volume of dead wood in decay class 1 (m3/ha). Note: Corresponds to DecayClass1 in the results! | |
91 | DeadWoodDecayClass3 | real | No | Volume of dead wood in decay class 2 (m3/ha). Note: Corresponds to DecayClass2 in the results! | |
92 | DeadWoodDecayClass4 | real | No | Volume of dead wood in decay class 3 (m3/ha). Note: Corresponds to DecayClass3 in the results! | |
93 | DeadWoodDecayClass5 | real | No | Volume of dead wood in decay class 4 (m3/ha). Note: Corresponds to DecayClass4 in the results! | |
94 | SpeciesUser | int | 11-97 | No | Species code for a species not included in the species groups above. |
95 | ProportionSpeciesUser | float | Yes | Proportion of species of SpeciesUser. Cf. PropPine above. Can be left blank if zero. | |
96 | MeanDiameterSpeciesUser | float | No | Mean diameter (cm) of species SpeciesUser. Cf. DgPine above. | |
97 | MeanHeightSpeciesUser | float | No | Mean height (m) of species of SpeciesUser. Cf. HPine above. | |
98 | RoadId1 | int | No | Column to place the id of a forest road connected to the stand. Forest roads are not handled explicitly in Heureka but the RoadId:s are available as parameters in the optimization model, for the advanced optimization modeler. | |
99 | RoadId2 | int | No | Column to place the id of an alternative forest road connected to the stand. Forest roads are not handled explicitly in Heureka but the RoadId:s are available as parameters in the optimization model, for the advanced optimization modeler. | |