VegBranch- loading table information - Stem Data
Login | Datasets | Logout
 

VegBranch Loading Tables Overview -- Stem Data (E)

Navigation between loading tables:
Party Information | Species List | Plot Data | Plot Normalized | Presence Data | Strata Cover Data | Stem Data | Stem Classes | Soil Data | Disturbance Data | Community Concept | Plot Communities | User Defined Metadata

Jump to a different part of this page: Field Descriptions | Example Data

Summary: Data about the stems that you measured on the plot.
Description: Each stem observed can have sizes listed (diameter and height), as well as X,Y coordinates, code, and health. You may also indicate multiple stems per size class, which is useful for those tallying stems in size classes.
Each plot is linked to Plot Data by authorPlotCode. Each plant has a plantCode here, which may either link directly to a plant in the vegbank_module or to a plantCode in the Species List Loading Table.
Required in VegBranch: At least one of the following is required: Cover Data, Stratum Cover Data, Stem Data. These are the three different options for referencing the plant taxa on your plot.
Represents VegBank Tables: stemCount, stemLocation (1).
VegBranch can generate for you: no
Questions: Were trees measured on the plots?
How many?
How big?
What kind?
Expertise Level: medium

Fields (Columns) in this table:

» Required fields; you should always fill in values for these:
AuthorPlotCode
  text (100)
Author's Plot number/code, or the original plot number if taken from literature. This "points" to the right plot in the Plot Data Loading Table.
PLANTCode
  text (255)
A code that refers to a plant concept. This code may be found in the Species List loading table. It may also link directly to a name in the vegbank module. For this reason, a species list loading table is not necessary, if your plants can be found in the vegbank module. Rules for how plant codes are looked up in the vegbank module may be found in the Translate Data Form, on the step where VegBranch matches your plants to VegBank plants.
stemCount
  Long Integer
The number of stems of a single species that have these specific stem diameter and height data in common. Default value is 1.
» Best Practice fields:
stemDiameter
  Double
The diameter of the stem in centimeters. When diameter classes are used, the stemDiameter is the midpoint between the low end and high end for the diameter class; the offset between this and the endpoints is stored in the stemDiameterAccuracy attribute.
» Commonly used fields:
stemDiameterAccuracy
  Double
The accuracy of the stem diameter measurements in centimeters. This represents the distance between the diameter class midpoint and endpoint.
» Sometimes used fields:
stemHeight
  Double
The measured height of the stem in meters. When height classes are used, the stemHeight is the midpoint between the low end and high end for the height class; the offset between this and the endpoint is stored in the stemHeightAccuracy field.
stemHeightAccuracy
  Double
The accuracy of the measured height of a stem, being the offset between the midpoint of the class and the endpoint, in meters.
StemCode
  text (20)
Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a fielddata entry with a stem in the database.
stemXPosition
  Double
The X-coordinate of the stem position in m. The user will enter the relative position of stems with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth.
stemYPosition
  Double
The Y-coordinate of the stem position, as stemXPosition.
stemHealth
  text (50)
Health of the stem referenced in this stemLocation record. Usually used to describe "dead" stems.
» Fields for expert users:
stratumIndex
  text (50)
OPTIONAL. References a StratumIndex (1-9) in Plot Data (or Normalized Plot Data) for this plot to link this stratum to the stratum definitions that table. Most of the time, stems are listed as belonging to the whole plot, not a particular stratum. In this case, leave this field blank, which signifies that record applies to the whole plot, not just to one stratum.
StemTaxonArea
  Double
Area of the plot used for this stem size to determine number of stems on a plot where the plot is subsampled differently by species and size. Leave blank if the full plot size was used, or as indicated by another size field, in observation or taxonObservation.
UserDef1
  Text (255)
The value of the user-defined variable.
UserDef2
  Text (255)
The value of the user-defined variable.
UserDef3
  Text (255)
The value of the user-defined variable.
UserDef4
  Text (255)
The value of the user-defined variable.
UserDef5
  Text (255)
The value of the user-defined variable.
UserDef6
  Text (255)
The value of the user-defined variable.
UserDef7
  Text (255)
The value of the user-defined variable.
UserDef8
  Text (255)
The value of the user-defined variable.
UserDef9
  Text (255)
The value of the user-defined variable.
UserDef10
  Text (255)
The value of the user-defined variable.
UserDef11
  Text (255)
The value of the user-defined variable.
UserDef12
  Text (255)
The value of the user-defined variable.
UserDef13
  Text (255)
The value of the user-defined variable.
UserDef14
  Text (255)
The value of the user-defined variable.
UserDef15
  Text (255)
The value of the user-defined variable.
UserDef16
  Text (255)
The value of the user-defined variable.
UserDef17
  Text (255)
The value of the user-defined variable.
UserDef18
  Text (255)
The value of the user-defined variable.
UserDef19
  Text (255)
The value of the user-defined variable.
UserDef20
  Text (255)
The value of the user-defined variable.
UserDef21
  Text (255)
The value of the user-defined variable.
UserDef22
  Text (255)
The value of the user-defined variable.
UserDef23
  Text (255)
The value of the user-defined variable.
UserDef24
  Text (255)
The value of the user-defined variable.
UserDef25
  Text (255)
The value of the user-defined variable.
» Internal VegBranch fields, please do not edit directly:
STEMID
  autoNumber
Database generated identifier assigned to each unique stem observation.

top


Examples of this data table:

Simple example of Stem Data:

AuthorPlotCodePLANTCodestemDiameterstemDiameterAccuracystemHeightstemHeightAccuracyStemTaxonAreastemCountStemCodestemXPositionstemYPositionstemHealth
plt1QUAL12.50.5   1RT-14243.282.3 
plt1QUAL7.50.5   4    
plt1ACRU3.20.15.10.5 1AC-431  dead
plt2CATO12.52.5  4517    

Download this example as a .csv file

top