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

detaildba_tabledescriptiontaxonimportancewhere_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). 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.