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 taxonImportance
Table Taxon Importance
Notes This table stores information about the importance (i.e. cover, basal area, biomass) of each taxon observed on a plot. Records may be limited to one stratum or apply to all strata.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
Taxon Importance ID taxonImportance_ID required serial PK no Database generated number which uniquely identifies this record of the table.
Taxon taxonObservation_ID required Integer FK no Foreign Key into the TaxonObservation table to link to the information about the taxon for which this importance value applies.
Stratum stratum_ID no Integer FK no 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.
Cover cover no Float n/a no Cover, in percent, of the taxon (potentially limitied to one stratum if stratum_ID has a value).
Basal Area basalArea no Float n/a no Total basal area of the species in m2/ha (potentially limitied to one stratum if stratum_ID has a value).
Biomass biomass no Float n/a no The biomass of the species in g/m2 (potentially limitied to one stratum if stratum_ID has a value).
Inference Area inferenceArea no Float n/a no 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.