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

detailtaxonimportancedba_tabledescriptionwhere_tablenametaxonimportance

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	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). Original Cover Code coverCode no varchar (10) denorm no The original cover code used by the author in the Cover Method for the plot. 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. Stratum Base Ht stratumBase no Float denorm no The Base of the Stratum in meters. Stratum Max Ht stratumHeight no Float denorm no The Tallest part of the Stratum in meters. this row embargoed. emb_taxonImportance no Integer denorm no This value mimics the default embargo value for the plot that this record belongs to.