************************************************** * File structure of the Hyytiälä field database. * ************************************************** The manual photogrammetric update in winter 2011-12 formed the base file. New measurement data added as new columns. The file contains 2 sheets: $PLOT_DATA and $TREE_DATA. These contain plots-specific and tree-specific variables, respectively. Log of changes: 16.8.2013 File created: Added 2012 and 2013 field measurements into the 2011 base file. 28.10.2013 Corrected P1 corner coordinates and removed one tree in AH1. 21.11.2013 Corrected one tree in marv4_143. 6.8.2014 Added summer 2014 measurements. 8.8.2014 Added photo-status "O0" (not checked) for the new trees positioned in 2013-2014 Added dummy variables indicating if the tree was measured in 2012, 2013 or 2014. Trees in clearcut plot marv1_103 marked as measured in 2013 and tree status changed to 31. 19.8.2014 Some trees in plot FT_2006 were missing measurement year, added! ********************************************************************************************************** * $PLOT_DATA * * Fields below denote: (1) column index in the excel-file, (2) name of the variable, (3) description * * NoData is coded as -99 (numeric data) or empty cell (text strings) in the excel-file * ********************************************************************************************************** 1 plot Plot code 2 age Average age 3 agevar Age variation (standard deviation) 4 Site Site type 5 Site+ Further definition of site type 6 SiteIndex Site type in numeric form 7 Soil Soil type (peat/mineral) 8 Notes_ADS40 Notes made in the ADS40-study (2009) 9 last_meas_yr Year of latest field measurements prior to 2012 10 mapping_yr Year when the trees were mapped first time 11 d13_lim Lower limit for the dbh of mapped trees 12 type Type of plot (1=rectangular; 2=circular; 3=no boders defined) 13 corner1_x x coordinate of the 1. corner 14 corner1_y y coordinate of the 1. corner 15 corner2_x x coordinate of the 2. corner 16 corner2_y y coordinate of the 2. corner 17 corner3_x x coordinate of the 3. corner 18 corner3_y y coordinate of the 3. corner 19 corner4_x x coordinate of the 4. corner 20 corner4_y y coordinate of the 4. corner 21 center_x x coordinate of the plot center (Rectangular plots: center of gravity of the corners; Circular plots: center; No borders defined: center of gravity for the trees) 22 center_y y coordinate of the plot center 23 radius plot radius (for circular plots) 24 width plot width (for rectangular plots) 25 height plot height (for rectangular plots) 26 Notes_2011 Notes made in 2011 when updating the database 27 Changes_2010_11 0=no changes during winter 2010-11; 1=some changes during winter 2010-11 28 Type_of_changes Explanation of the changes 29 meas_2012 Field-measured in 2012 (0 = not measured, 1 = measured) 30 meas_2013 Field-measured in 2013 (0 = not measured, 1 = measured) 31 meas_2014 Field-measured in 2014 (0 = not measured, 1 = measured) ********************************************************************************************************** * $TREE_DATA * * Fields below denote: (1) column index in the excel-file, (2) name of the variable, (3) description * * NoData is coded as -99 (numeric data) or empty cell (text strings) in the excel-file * ********************************************************************************************************** 1) Latest field data prior to 2012 + the database update in winter 2011-2012 (no field visit, visual photo interpretation) 1 Serial serial nr of the tree 2 plot plot id 3 tree tree id 4 Code Tree code (individual code for each tree) 5 geoloc_type geolocation method 1=tacheometer 2=photogrammeteric (LiDAR monoplotting or photo only multiple images) 3=trilateration/triangulation 4=GPS 6 x x-coordinate 7 y y-coordinate 8 z_top tree top z-coordinate 9 z_gnd ground z coordinate (If measured with tacheometer. Otherwise -99) 10 meas_yr year of last field measurements 11 sp tree species (field measurement) 12 status tree status (field measurement) 13 d13 tree dbh (field measurement) 14 h tree height (field measurement) 15 hc crown base height (field measurement) 16 age tree age (field measurement) 17 Notes notes from field measurements 18 h_ADS40 Tree height from ASD40-study 19 h_Nasl Tree height predicted by Näslund model 20 x_new Updated treetop x (same as old x if new status is O0, O3 or O4) 21 y_new Updated treetop y (same as old y if new status is O0, O3 or O4) 22 z_new Updated treetop z (same as old z if new status is O0, O3 or O4) 23 status_new Updated tree status: O0=tree not checked (under h-limit) O1=tree detected, status unchanged O2= tree detected, dead after the last field measurement O3=tree disappeared(snow damage/cut etc. O4=tree not seen in aerial img/LiDAR data O5=tree detected but not seen clearly, new measurement may be uncertain O6=tree detected, trunk broken O7=new tree measured 24 Change_2010-11 Changes during winter 2010-11: -99=not checked 0=no change during winter 2010-11 1=disappeared during winter 2010-11 25 Site Site type 26 Soil Soil type (mineral/peat) 27 drained Draining status 1=drained 0=not drained 28 siteIndex Site type in numeric form 2) Field measurement data 2012 (Students measurements in FOR110) 29 puidenluku_2012 Was the tree measured for basic variables (sp, status, d13) -99 = plot not visited 0 = plot visited, tree not measured 1 = measured 30 sp_2012 Species 31 status_2012 Status 32 d13_2012 DBH [mm] 33 h_2012 Height [m] 34 hc_2012 Crown base height [m] 35 notes_2012 Notes made in the field 36 x_Resect_2012 X-coordinate from trilateration (for new trees positioned in 2012) 37 y_Resect_2012 Y-coordinate from trilateration (for new trees positioned in 2012) 3) Field measurement data 2013 (Field campaign (MM-Säätiö) + FOR110) 38 puidenluku_2013 Was the tree measured for basic variables (sp, status, d13) -99 = plot not visited 0 = plot visited, tree not measured 1 = measured 39 sp_2013 Species 40 status_2013 Status 41 d13_2013 DBH [mm] 42 h_2013 Height [m] 43 hc_2013 Crown base height [m] 44 katk_kork_2013 Breaking height from ground, estimated for broken trees [m] 45 latv_poikki_2013 Breaking height from top, estimated for broken trees [m] 46 dcr_2013 Crown radius, measured for some small bushes [cm] 47 hars_2013 Defoliation degree, estimated visually, in plot MARV1_10_6 only 48 dupl_2013 Is the same tree belonging to 2 plots? 0=only one plot or first measurement of this tree 1=this tree was already measured in some other plot: ignore to avoid duplicates 49 notes_2013 Notes made in the field 50 x_Resect_2013 X-coordinate from trilateration (for new trees positioned in 2013) 51 y_Resect_2013 Y-coordinate from trilateration (for new trees positioned in 2013) 4) Field measurement data 2014 a) Puidenluku (i.e. basic d13 measurements and crown classification) by FOR110-students/researchers 52 puidenluku_2014 Indication if the tree was measured for basic variables (species, status, d13) in 2014 and who did the measurements. Spruce on some of the plots have also branch type classified. -99 = plot not visited 0 = plot visited, tree not measured 1 = measured by FOR110 students 2 = measured by Ilkka Korpela, Aarne Hovi 3 = measured by Hyytiälä summer workers 53 sp_2014 Tree species 54 status_2014 Crown status 55 d13_2014 Diameter at breast height [mm] 56 break_h_2014 For broken trees. Visual estimate of the height at which the tree was broken. Some students' measurements are missing this information. 57 branch_type_2014 Visual classification of branch type for spruce, performed only on some of the plots: L = laakatyyppi ("Plattentyp") H = harjatyyppi ("Bürstentyp") K = kampatyyppi ("Kammtyp") On some of the plots, a -/+ sign was used to indicate the uncertainty of the visual assessment, for example: L+ = laakatyyppi: clear case, could not be confused with any other type L- = laakatyyppi: not very clear, could be confused with some other type 58 notes_2014 Notes made during the field campaign b) Height and crown base height measurements by students in FOR110 59 meas_h_hc_FOR110_2014 Indication if the height (h) and crown base height (hc) were measured: -99 = plot not visited 0 = plot visited, tree not measured 1 = measured 60 h_FOR110_2014 Tree height [m] 61 hc_FOR110_2014 Crown base height [m] c) Crown base height measurements by Aarne Hovi (height measured only for broken and non-photo-visible trees) 62 meas_hc_2014 Indication if the crown base height (hc) was measured: -99 = plot not visited 0 = plot visited, tree not measured 1 = measured 63 h_2014 Tree height [m] 64 hc_2014 Crown base height [m] 65 understory_2014 Visual estimate of the understory trees under the projected crown area: 0 = No understory 1 = Some understory 2 = Understory reaches the crown base height 66 neighbors_2014 Visual estimate of the crown contact with neighbors: 0 = No contact 1 = Crown touches the neighboring tree crown(s) 2 = Neigthbor(s) very close, restricting the growth of the branches 67 notes_hc_2014 Notes made during field campaign d) Tree coordinates (For new trees only. Geolocation method added to the "geoloc_type" field in column 5) 68 x_2014 x coordinate 69 y_2014 y coordinate