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

451010

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)	stratumType
Table	Stratum Type
Field	Stratum Name
DB Field Name	stratumName
Req'd?	no
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name associated with this stratum by the stratumMethod

 

Table (DB Name)	stratumType
Table	Stratum Type
Field	Stratum Description
DB Field Name	stratumDescription
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This field describes the specific stratum. For example, a value of "F" under stratumIndex might have a stratumName = "Floating" and a stratumDescription = "foliage floating on or near the surface of water"

 

Table (DB Name)	taxonImportance
Table	Taxon Importance
Field	Taxon Importance ID
DB Field Name	taxonImportance_ID
Req'd?	required
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database generated number which uniquely identifies this record of the table.

 

Table (DB Name)	taxonImportance
Table	Taxon Importance
Field	Taxon
DB Field Name	taxonObservation_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	taxonObservation.TAXONOBSERVATION_ID
List?	no
Notes	n/a
Definition	Foreign Key into the TaxonObservation table to link to the information about the taxon for which this importance value applies.

 

Table (DB Name)	taxonImportance
Table	Taxon Importance
Field	Stratum
DB Field Name	stratum_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	stratum.STRATUM_ID
List?	no
Notes	n/a
Definition	Foreign Key into the stratum table, if this record is limited to the importance of a taxon in one stratum. If null, all values in this record speak of the importance of the entire taxon across all strata.

 

Table (DB Name)	taxonImportance
Table	Taxon Importance
Field	Cover
DB Field Name	cover
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Cover, in percent, of the taxon (potentially limitied to one stratum if stratum_ID has a value).

 

Table (DB Name)	taxonImportance
Table	Taxon Importance
Field	Basal Area
DB Field Name	basalArea
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Total basal area of the species in m2/ha (potentially limitied to one stratum if stratum_ID has a value).

 

Table (DB Name)	taxonImportance
Table	Taxon Importance
Field	Biomass
DB Field Name	biomass
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The biomass of the species in g/m2 (potentially limitied to one stratum if stratum_ID has a value).

 

Table (DB Name)	taxonImportance
Table	Taxon Importance
Field	Inference Area
DB Field Name	inferenceArea
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	The area used to infer the importance values of the taxon, if not the same as observation.taxonInferenceArea.
Definition	This is the area in m2 used to infer the importance values (i.e. cover, biomass, basal area) in this record. RESERVED VALUE: -1 is used to indicate no plot boundaries were used when estimating importance values.

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	ID
DB Field Name	TAXONINTERPRETATION_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the TaxonInterpretation table.
Definition	Database generated identifier assigned to each unique interpretation of a taxon.