StandRegisterFileSpecification

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.
16	VegetationType	Int	1-18	Yes	Follow link to see codes.
17	BottomLayer	Int	1-6	See comment	Follow link to see codes. (Bottenskiktstyp). Required only if SiteIndex (SIS) should be calculated by the program.
18	SoilTextureCode	Int	1-8	See comment	Follow link to see codes. (Jordtextur). Required only if SiteIndex (SIS) should be calculated by the program.
19	SoilWaterCode	Int	1-3	See comment	Follow link to see codes. (Rörligt markvatten). Required only if SiteIndex (SIS) should be calculated by the program.
20	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
21	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.
22	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
23	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
24	Slope	int	1-5	No	(sv: Lutning i "GYL")
					1 = 0-10 %
					2 = 10-20 %
					3 = 20-33 %
					4 = 33-50 %
					5 = >50 %
25	InventoryYear	int		Yes	Inventory year or date in format YYYY or YYYY-MM-DD
26	OwnerType	int	0-5	No
					0 = Unknown
					1 = State
					2 = Ecclesiastical
					3 = OtherPublic
					4 = Corporation
					5 = Private
27	SIS	double		Yes	Site index as determined by site factors (H100 or H50 (for birch and P. contorta), m)
28	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.
29	TotalArea	double		No	ha
30	ProdArea	double		Yes	Productive area (ha)
31	ImpArea	double		No	Impediment area (ha)
32	NCArea	double		No	Nature conservation area (ha), i.e. area set aside from timber production
33	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)
34	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)
35	H	double		No	Mean height (basal area weighted, m)
36	MeanAge	double		Yes	Mean tree total age (basal area weighted, years)
37	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)
38	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)
39	V	double		No	Volume (m3sk/ha, productive area). Can be used to compare with volumes calulated with Heureka.
40	CAI	double		No	Current annual volume increment (m3sk/ha, yr)
41	PropPine	float		Yes	Proportion pine of basal area if mean height >7 m, otherwise prop. of stem density. Can be left empty if zero.
42	PropSpruce	float		Yes	Can be left empty if zero.
43	PropBirch	float		Yes	Can be left empty if zero.
44	PropAspen	float		Yes	Can be left empty if zero.
45	PropOak	float		Yes	Can be left empty if zero.
46	PropBeech	float		Yes	Can be left empty if zero.
47	PropDeciduous	float		Yes	(sv: Övrigt ädellöv) Can be left empty if zero.
48	PropContorta	float		Yes	Can be left empty if zero.
49	PropBroadleaf	float		Yes	(sv: Övrigt triviallöv) Can be left empty if zero.
50	PropLarch	float		Yes	(sv: Lärk (europeisk eller sibirisk)) Can be left empty if zero.
51	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
53	DGPine	float		No	Mean diameter pine (cm)
54	DGSpruce	float		No
55	DGBirch	float		No
56	DGAspen	float		No
57	DGOak	float		No
58	DGBeech	float		No
59	DGDeciduous	float		No
60	DGContorta	float		No
61	DGBroadleaf	float		No
62	DGLarch	float		No
63	HPine	float		No	Mean height pine (basal area weighted, m)
64	HSpruce	float		No
65	HBirch	float		No
66	HAspen	float		No
67	HOak	float		No
68	HBeech	float		No
69	HDeciduous	float		No
70	HContorta	float		No
71	HBroadleaf	float		No
72	HLarch	float		No
73	TerrainTransportDistance	int		No	One way average terrain transport distance from centre of stand to nearest road (meters)
74	LastClearcutYear	int		No	Year when clearcut was last performed. Format YYYY
75	LastThinningYear	int		No	Year or date when thinning was last performed. Format YYYY or YYYY-MM-DD
76	LastFertilizationYear	int		No	Year or date when fertilization was last performed. Format YYYY or YYYY-MM-DD
77	LastRegenerationYear	int		No	Year or date when regeneration was last performed. Format YYYY or YYYY-MM-DD
78	RegenerationMethod	int	0-2	No	(Used if MaturityClass is entered and set to K1)
					0 = Natural regeneration
					1 = Plantation
					2 = Sowing
79	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.
80	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
81	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
81	Note	string(max)		No
82	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.
83	UserDefinedVariable2	int		No	-"-
84	UserDefinedVariable3	int		No	-"-
85	UserDefinedVariable4	int		No	-"-
86	UserDefinedVariable5	int		No	-"-
87	UserDefinedVariable6	real		No	-"-
88	UserDefinedVariable7	real		No	-"-
89	UserDefinedVariable8	real		No	-"-
90	UserDefinedVariable9	real		No	-"-
91	UserDefinedVariable10	real		No	-"-
92	DeadWoodTotal	real		No	Volume of dead wood (m3/ha)
93	DeadWoodDecayClass1	real		No	Volume of dead wood in decay class 0 (m3/ha). Note: Corresponds to DecayClass0 in the results!
94	DeadWoodDecayClass2	real		No	Volume of dead wood in decay class 1 (m3/ha). Note: Corresponds to DecayClass1 in the results!
95	DeadWoodDecayClass3	real		No	Volume of dead wood in decay class 2 (m3/ha). Note: Corresponds to DecayClass2 in the results!
96	DeadWoodDecayClass4	real		No	Volume of dead wood in decay class 3 (m3/ha). Note: Corresponds to DecayClass3 in the results!
97	DeadWoodDecayClass5	real		No	Volume of dead wood in decay class 4 (m3/ha). Note: Corresponds to DecayClass4 in the results!
98	SpeciesUser	int	11-97	No	Species code for a species not included in the species groups above.
99	ProportionSpeciesUser	float		Yes	Proportion of species of SpeciesUser. Cf. PropPine above. Can be left blank if zero.
100	MeanDiameterSpeciesUser	float		No	Mean diameter (cm) of species SpeciesUser. Cf. DgPine above.
101	MeanHeightSpeciesUser	float		No	Mean height (m) of species of SpeciesUser. Cf. HPine above.
102	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.
103	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.
104 (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