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

431010

VegBank Data Dictionary: Field Details

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

Search VegBank Tables Here

Table (DB Name)	stemLocation
Table	Stem Location
Field	Stem Count
DB Field Name	STEMCOUNT_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	stemCount.STEMCOUNT_ID
List?	no
Notes	Foreign key into the stemSize table
Definition	Foreign key into the stemSize table, thereby assigning a location to a particular stem of a specific size

 

Table (DB Name)	stemLocation
Table	Stem Location
Field	Stem Code
DB Field Name	stemCode
Req'd?	no
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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.

 

Table (DB Name)	stemLocation
Table	Stem Location
Field	Stem X Position
DB Field Name	stemXPosition
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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.

 

Table (DB Name)	stemLocation
Table	Stem Location
Field	Stem Y Position
DB Field Name	stemYPosition
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The Y-coordinate of the stem position, as above.

 

Table (DB Name)	stemLocation
Table	Stem Location
Field	Stem Health
DB Field Name	stemHealth
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	open
Notes	n/a
Definition	Health of the stem referenced in this stemLocation record. Usually used to describe "dead" stems.
open List of Values: Value Description Sorting dead stem is dead 1 uprooted, but alive stem is uprooted, but still alive 2 leaning stem leans in a non-trivial manner 3

 

Table (DB Name)	stratum
Table	Stratum Definition
Field	ID
DB Field Name	STRATUM_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the stratum table.
Definition	Database assigned value for a unique existence of a stratum within a plot observation.

 

Table (DB Name)	stratum
Table	Stratum Definition
Field	Observation
DB Field Name	OBSERVATION_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	observation.OBSERVATION_ID
List?	no
Notes	Foreign key into the observation table.
Definition	Link to the plot observation event with which this stratum observation is associated.

 

Table (DB Name)	stratum
Table	Stratum Definition
Field	Stratum Type
DB Field Name	STRATUMTYPE_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	stratumType.STRATUMTYPE_ID
List?	no
Notes	Foreign key into the stratumType table.
Definition	This attribute will link to the definition of the specific stratum observed.

 

Table (DB Name)	stratum
Table	Stratum Definition
Field	Stratum Height
DB Field Name	stratumHeight
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Average height to the top of the stratum in meters.

 

Table (DB Name)	stratum
Table	Stratum Definition
Field	Stratum Base
DB Field Name	stratumBase
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Average height of the bottom of the stratum in meters.