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. | |
Examples of this data table:
Simple example of Stem Data:
| AuthorPlotCode | PLANTCode | stemDiameter | stemDiameterAccuracy | stemHeight | stemHeightAccuracy | StemTaxonArea | stemCount | StemCode | stemXPosition | stemYPosition | stemHealth |
|---|---|---|---|---|---|---|---|---|---|---|---|
| plt1 | QUAL | 12.5 | 0.5 | 1 | RT-142 | 43.2 | 82.3 | ||||
| plt1 | QUAL | 7.5 | 0.5 | 4 | |||||||
| plt1 | ACRU | 3.2 | 0.1 | 5.1 | 0.5 | 1 | AC-431 | dead | |||
| plt2 | CATO | 12.5 | 2.5 | 45 | 17 |
Download this example as a .csv file