StandRegisterFileSpecification

From Heureka Wiki
Revision as of 10:32, 25 September 2017 by Peder (talk | contribs)
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
Template:AUTOINCREMENT MapId int (max 5 pos) 1-99999 No
Template:AUTOINCREMENT StandId string(25) Yes Identity of stand (sv: Avdelning) Mandatory!
Template:AUTOINCREMENT SubStandId int (max 1 pos) 0-9 No
Template:AUTOINCREMENT AreaLevel2 string(50) No Description for level two, to be used in any subdivision of the analysis area (for stratification purposes, etc.)
Template:AUTOINCREMENT AreaLevel3 string(50) No Description for level three, to be used in any subdivision of the analysis area (for stratification purposes, etc.)
Template:AUTOINCREMENT Register int No Register number (some users want this to use when defining forest domains in PlanWise, equivalent to UserDefined below)
Template:AUTOINCREMENT Layer Int 1,2,6 No 1 or blank = Main layer, 2 = Overstorey (seed trees or shelterwood), 6 = Nature conservation retention trees
Template:AUTOINCREMENT 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.
Template:AUTOINCREMENT Altitude float Yes Altitude (h.a.m.s.l., m)
Template:AUTOINCREMENT Latitude float 54-70 See comment Latitude (° N, can be seen in the ClimateCode-map below). Mandatory only if no coordinates are given.
Template:AUTOINCREMENT CoordEast double See comment East coordinate, m (SWEREF99). Mandatory if any of CountyCode, Latitude and ClimateCode is missing.
Template:AUTOINCREMENT CoordNorth double See comment North coordinate, m (SWEREF99). Mandatory if any of CountyCode, Latitude and ClimateCode is missing.
Template:AUTOINCREMENT 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.
Template:AUTOINCREMENT 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.
Template:AUTOINCREMENT SoilMoistureCode Int 1-5 Yes 1 = Dry
2 = Mesic
3 = Mesic-moist
4 = Moist
5 = Wet
Template:AUTOINCREMENT VegetationType Int 1-18 Yes Follow link to see codes.
Template:AUTOINCREMENT BottomLayer Int 1-6 See comment (Bottenskiktstyp). Follow link to see codes. Required only if SiteIndex (SIS) should be calculated by the program.
Template:AUTOINCREMENT SoilWaterCode Int 1-3 See comment (Rörligt markvatten). Follow link to see codes. Required only if SiteIndex (SIS) should be calculated by the program.
Template:AUTOINCREMENT SoilDepthCode Int 1-4 See comment (Jorddjup) Follow link to see codes. Required only if SiteIndex (SIS) should be calculated by the program.
Template:AUTOINCREMENT SoilTextureCode Int 1-8 See comment (Jordtextur). Follow link to see codes. Required only if SiteIndex (SIS) should be calculated by the program.
Template:AUTOINCREMENT 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
Template:AUTOINCREMENT 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.
Template:AUTOINCREMENT 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
Template:AUTOINCREMENT BlueTargetClass char(2) or integer Code (ex. VS) or integer No Blue target class (Blå målklass) according to WWF. You can enter a code such as "VO". If a stand consists of multiple classes, you can enter the sum of the numeric codes, for example VS and VO can be entered as 12 (4 + 8). Heureka has a GIS function (the BufferZone tool in the map window) to create buffer zone of varying widths depending on the class value of the intersecting water streams. Alternative columns names are "BlaMalklass", "BlueTargetClass" and "BlueGoalClass" and "BlueTarget". The value is not used in Heureka per se, other than that you can used in forest domain and report conditions.
None or blank = No specific water protection or no class assigned
VG or 1 = Water environment with general management consideration
VF or 2 = Water environment with enforced management considerations
VS or 4 = Water environment with specific management actions
VO or 8 = Water environment to be set aside and left unmanaged
Template:AUTOINCREMENT 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
24 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
Template:AUTOINCREMENT Slope int 1-5 No (sv: Lutning i "GYL")
1 = 0-10 %
2 = 10-20 %
3 = 20-33 %
4 = 33-50 %
5 = >50 %
Template:AUTOINCREMENT InventoryYear int Yes Inventory year or date in format YYYY or YYYY-MM-DD
Template:AUTOINCREMENT OwnerType int 0-5 No
0 = Unknown
1 = State
2 = Ecclesiastical
3 = OtherPublic
4 = Corporation
5 = Private
Template:AUTOINCREMENT SIS double Yes Site index as determined by site factors (H100 or H50 (for birch and P. contorta), m)
Template:AUTOINCREMENT 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.
Template:AUTOINCREMENT TotalArea double No ha
Template:AUTOINCREMENT ProdArea double Yes Productive area (ha)
Template:AUTOINCREMENT ImpArea double No Impediment area (ha)
Template:AUTOINCREMENT NCArea double No Nature conservation area (ha), i.e. area set aside from timber production
Template:AUTOINCREMENT 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)
Template:AUTOINCREMENT 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)
Template:AUTOINCREMENT H double No Mean height (basal area weighted, m)
Template:AUTOINCREMENT MeanAge double Yes Mean tree total age (basal area weighted, years)
Template:AUTOINCREMENT 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)
Template:AUTOINCREMENT 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)
Template:AUTOINCREMENT V double No Volume (m3sk/ha, productive area). Can be used to compare with volumes calulated with Heureka.
Template:AUTOINCREMENT CAI double No Current annual volume increment (m3sk/ha, yr)
Template:AUTOINCREMENT PropPine float Yes Proportion pine of basal area if mean height >7 m, otherwise prop. of stem density. Can be left empty if zero.
Template:AUTOINCREMENT PropSpruce float Yes Can be left empty if zero.
Template:AUTOINCREMENT PropBirch float Yes Can be left empty if zero.
Template:AUTOINCREMENT PropAspen float Yes Can be left empty if zero.
Template:AUTOINCREMENT PropOak float Yes Can be left empty if zero.
Template:AUTOINCREMENT PropBeech float Yes Can be left empty if zero.
Template:AUTOINCREMENT PropDeciduous float Yes (sv: Övrigt ädellöv) Can be left empty if zero.
Template:AUTOINCREMENT PropContorta float Yes Can be left empty if zero.
Template:AUTOINCREMENT PropBroadleaf float Yes (sv: Övrigt triviallöv) Can be left empty if zero.
Template:AUTOINCREMENT PropLarch float Yes (sv: Lärk (europeisk eller sibirisk)) Can be left empty if zero.
Template:AUTOINCREMENT 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
Template:AUTOINCREMENT DGPine float No Mean diameter pine (cm)
Template:AUTOINCREMENT DGSpruce float No
Template:AUTOINCREMENT DGBirch float No
Template:AUTOINCREMENT DGAspen float No
Template:AUTOINCREMENT DGOak float No
Template:AUTOINCREMENT DGBeech float No
Template:AUTOINCREMENT DGDeciduous float No
Template:AUTOINCREMENT DGContorta float No
Template:AUTOINCREMENT DGBroadleaf float No
Template:AUTOINCREMENT DGLarch float No
Template:AUTOINCREMENT HPine float No Mean height pine (basal area weighted, m)
Template:AUTOINCREMENT HSpruce float No
Template:AUTOINCREMENT HBirch float No
Template:AUTOINCREMENT HAspen float No
Template:AUTOINCREMENT HOak float No
Template:AUTOINCREMENT HBeech float No
Template:AUTOINCREMENT HDeciduous float No
Template:AUTOINCREMENT HContorta float No
Template:AUTOINCREMENT HBroadleaf float No
Template:AUTOINCREMENT HLarch float No
Template:AUTOINCREMENT TerrainTransportDistance int No One way average terrain transport distance from centre of stand to nearest road (meters)
Template:AUTOINCREMENT LastClearcutYear int No Year when clearcut was last performed. Format YYYY
Template:AUTOINCREMENT LastThinningYear int No Year or date when thinning was last performed. Format YYYY or YYYY-MM-DD
Template:AUTOINCREMENT LastFertilizationYear int No Year or date when fertilization was last performed. Format YYYY or YYYY-MM-DD
Template:AUTOINCREMENT LastRegenerationYear int No Year or date when regeneration was last performed. Format YYYY or YYYY-MM-DD
Template:AUTOINCREMENT RegenerationMethod int 0-2 No (Used if MaturityClass is entered and set to K1)
0 = Natural regeneration
1 = Plantation
2 = Sowing
Template:AUTOINCREMENT RegenerationSpecies int 1-10 No Regeneration species (group code).
Very useful for controlling what regeneration species to use in PlanWise. Ensure that setting SpeciesToPlant in the Regeneration Settings form in PlanWise is set to Regeneration Species. Note! In versions prior to 2.5, it was only used to determine what species to use when regenerating bare land in period 0.
Template:AUTOINCREMENT 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
Template:AUTOINCREMENT 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
Template:AUTOINCREMENT Note string(max) No
Template:AUTOINCREMENT 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.
Template:AUTOINCREMENT UserDefinedVariable2 int No -"-
Template:AUTOINCREMENT UserDefinedVariable3 int No -"-
Template:AUTOINCREMENT UserDefinedVariable4 int No -"-
Template:AUTOINCREMENT UserDefinedVariable5 int No -"-
Template:AUTOINCREMENT UserDefinedVariable6 real No -"-
Template:AUTOINCREMENT UserDefinedVariable7 real No -"-
Template:AUTOINCREMENT UserDefinedVariable8 real No -"-
Template:AUTOINCREMENT UserDefinedVariable9 real No -"-
Template:AUTOINCREMENT UserDefinedVariable10 real No -"-
Template:AUTOINCREMENT
DeadWoodTotal
real No Volume of dead wood (m3/ha)
Template:AUTOINCREMENT DeadWoodDecayClass1 real No Volume of dead wood in decay class 0 (m3/ha). Note: Corresponds to DecayClass0 in the results!
Template:AUTOINCREMENT DeadWoodDecayClass2 real No Volume of dead wood in decay class 1 (m3/ha). Note: Corresponds to DecayClass1 in the results!
Template:AUTOINCREMENT DeadWoodDecayClass3 real No Volume of dead wood in decay class 2 (m3/ha). Note: Corresponds to DecayClass2 in the results!
Template:AUTOINCREMENT DeadWoodDecayClass4 real No Volume of dead wood in decay class 3 (m3/ha). Note: Corresponds to DecayClass3 in the results!
Template:AUTOINCREMENT DeadWoodDecayClass5 real No Volume of dead wood in decay class 4 (m3/ha). Note: Corresponds to DecayClass4 in the results!
Template:AUTOINCREMENT SpeciesUser int 11-97 No Species code for a species not included in the species groups above.
Template:AUTOINCREMENT ProportionSpeciesUser float Yes Proportion of species of SpeciesUser. Cf. PropPine above. Can be left blank if zero.
Template:AUTOINCREMENT MeanDiameterSpeciesUser float No Mean diameter (cm) of species SpeciesUser. Cf. DgPine above.
Template:AUTOINCREMENT MeanHeightSpeciesUser float No Mean height (m) of species of SpeciesUser. Cf. HPine above.
Template:AUTOINCREMENT 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.
Template:AUTOINCREMENT 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.
Template:AUTOINCREMENT (from version 2.5) SetAsideType int 0-3 No Introduced in version 2.4.0.10. Values: Definition:SetAsideType. See usage in the Help documention