Difference between revisions of "StandRegisterFileSpecification"
Jump to navigation
Jump to search
Line 324: | Line 324: | ||
| 88||DeadWoodTotal||real||||No||Volume of dead wood (m<sup>3</sup>/ha) | | 88||DeadWoodTotal||real||||No||Volume of dead wood (m<sup>3</sup>/ha) | ||
|-style = "vertical-align: top;" | |-style = "vertical-align: top;" | ||
− | | 89||DeadWoodDecayClass1||real||||No||Volume of dead wood in decay class | + | | 89||DeadWoodDecayClass1||real||||No||Volume of dead wood in [[Definition:DecayClass|decay class 0]] (m<sup>3</sup>/ha). Note: Corresponds to DecayClass0 in the results! |
|-style = "vertical-align: top;" | |-style = "vertical-align: top;" | ||
− | | 90||DeadWoodDecayClass2||real||||No||Volume of dead wood in decay class | + | | 90||DeadWoodDecayClass2||real||||No||Volume of dead wood in [[Definition:DecayClass|decay class 1]] (m<sup>3</sup>/ha). Note: Corresponds to DecayClass1 in the results! |
|-style = "vertical-align: top;" | |-style = "vertical-align: top;" | ||
− | | 91||DeadWoodDecayClass3||real||||No||Volume of dead wood in decay class | + | | 91||DeadWoodDecayClass3||real||||No||Volume of dead wood in [[Definition:DecayClass|decay class 2]] (m<sup>3</sup>/ha). Note: Corresponds to DecayClass2 in the results! |
|-style = "vertical-align: top;" | |-style = "vertical-align: top;" | ||
− | | 92||DeadWoodDecayClass4||real||||No||Volume of dead wood in decay class | + | | 92||DeadWoodDecayClass4||real||||No||Volume of dead wood in [[Definition:DecayClass|decay class 3]] (m<sup>3</sup>/ha). Note: Corresponds to DecayClass3 in the results! |
|-style = "vertical-align: top;" | |-style = "vertical-align: top;" | ||
− | | 93||DeadWoodDecayClass5||real||||No||Volume of dead wood in decay class | + | | 93||DeadWoodDecayClass5||real||||No||Volume of dead wood in [[Definition:DecayClass|decay class 4]] (m<sup>3</sup>/ha). Note: Corresponds to DecayClass4 in the results! |
|-style = "vertical-align: top;" | |-style = "vertical-align: top;" | ||
| 94||[[Definition:SpeciesCode|SpeciesUser]]||int||[[Definition:SpeciesCode|11-97]]||No||Species code for a species not included in the species groups above. | | 94||[[Definition:SpeciesCode|SpeciesUser]]||int||[[Definition:SpeciesCode|11-97]]||No||Species code for a species not included in the species groups above. |
Revision as of 11:36, 4 March 2016
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. | ||