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

241010

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)	observation
Table	Observation
Field	Overall Taxon Cover Values are Automatically Calculated?
DB Field Name	autoTaxonCover
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	default = FALSE
Definition	TRUE indicates that taxonObservation.taxonCover was automatically calculated from the values of all stratumObservation.taxonStratumCover

 

Table (DB Name)	observation
Table	Observation
Field	Stratum Method
DB Field Name	STRATUMMETHOD_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	stratumMethod.STRATUMMETHOD_ID
List?	no
Notes	Foreign key into the stratumMethod table
Definition	Link to the definitions of strata used in recording taxon-specific values of cover.

 

Table (DB Name)	observation
Table	Observation
Field	Method Narrative
DB Field Name	methodNarrative
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Additional metadata helpful for understanding how the data were collected during the observation event.

 

Table (DB Name)	observation
Table	Observation
Field	Taxon Observation Area
DB Field Name	taxonObservationArea
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	default = plot.area
Definition	the total surface area (in m^2) used for cover estimates and for which a complete species list is provided. If subplots were used, this would be the total area of the subplots without interstitial space. RESERVED VALUE: -1 is used to indicate the complete list of species had no known boundaries.

 

Table (DB Name)	observation
Table	Observation
Field	Stem Size Limit
DB Field Name	stemSizeLimit
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Lower diameter limit in centimeters for inclusion of a tree in the stem count (stemCount).

 

Table (DB Name)	observation
Table	Observation
Field	Stem Observation Area
DB Field Name	stemObservationArea
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	default = plot.area
Definition	the total surface area (in m^2) observed for recording woody stem data. RESERVED VALUE: -1 means no known area.

 

Table (DB Name)	observation
Table	Observation
Field	Stem Sample Method
DB Field Name	stemSampleMethod
Req'd?	no
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list; default = full census
Definition	The method used to obtain basal area or tree stem data (e.g., full census, point quarter, random pairs, Bitterlich, other).
closed List of Values: Value Description Sorting Full census   1 Point quarter   2 Random pairs   3 Bitterlich   4 Other   5 Subsample census   6

 

Table (DB Name)	observation
Table	Observation
Field	Original Data Location
DB Field Name	originalData
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Location where the hard data reside and any access instructions.

 

Table (DB Name)	observation
Table	Observation
Field	Effort Level
DB Field Name	effortLevel
Req'd?	no
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	This is the effort spent making the observations as estimated by the party that submitted the data (e.g., Very thorough, Average, Hurried description).
closed List of Values: Value Description Sorting Very thorough   1 Accurate   2 Hurried or incomplete   3

 

Table (DB Name)	observation
Table	Observation
Field	Plot Validation Level
DB Field Name	plotValidationLevel
Req'd?	no
Data Type	Integer
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	Quality of plot as determined by an automated filter system, including values such as (1) sufficient for determining type occurrence, (2) sufficient for inclusion in a classification revision, and (3) fully compliant with recommendations.
closed List of Values: Value Description Sorting -1 observation has not yet been fully rectified by user and is not complete. -1 1 sufficient for determining type occurrence 1 2 sufficient for inclusion in a classification revision 2 3 sufficient for classification and meets best practices 3