Login | Datasets | Logout

VegBank Data Dictionary: Tables

  Search for a VegBank Table (enter a word, field name, etc.):    <<Hide search
Match any word
Match whole words only

   Search VegBank Fields Here

Show field labels | Show database names

DB Table Name stemLocation
Table Stem Location
Notes This table is intended to store location information about individual tree stems.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID STEMLOCATION_ID no serial PK no Database generated identifier assigned to each unique stem observation.
Stem Count STEMCOUNT_ID required Integer FK no Foreign key into the stemSize table, thereby assigning a location to a particular stem of a specific size
Stem Code stemCode no varchar (20) n/a no Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a field data entry with a stem in the database.
Stem X Position stemXPosition no Float n/a no 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.
Stem Y Position stemYPosition no Float n/a no The Y-coordinate of the stem position, as above.
Stem Health stemHealth no varchar (50) n/a open Health of the stem referenced in this stemLocation record. Usually used to describe "dead" stems.