Login | Datasets | Logout
Jump to... Home PLOT search PLANT search COMMUNITY search Simple search Manage datasets Tutorial About FAQ ------- Site map VegBranch Data dictionary ERD

detaildba_tabledescription155155

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 for VegBank Table >>

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.