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 coverIndex
Table Cover Index
Notes This table stores the definitions of each coverclass unit associated with each coverclass method.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID COVERINDEX_ID no serial PK no Database generated identifier assigned to each unique coverclass associated index value.
Cover Method COVERMETHOD_ID required Integer FK no Links to a specific cover scale.
Cover Code coverCode required varchar (10) n/a no The name or label used in the coverclass scale for this specific coverclass.
Upper Limit upperLimit no Float n/a no Upper limit, in percent, associated with the specific coverCode.
Lower Limit lowerLimit no Float n/a no This is the lower limit, in percent, associated with a specific coverCode. Where a cover scale has a non-quantitative lower or upper value, as in the "+" of the Braun-Blanquet scale, it is necessary to provide an approximation with "0" being the lower limit of the bottom most class.
Cover Percent coverPercent required Float n/a no A middle value (usually mean or geometric mean) between the upperLimit and lowerLimt stored by the database for each taxon observation and used for all coverclass conversions and interpretations. This is assigned by the author of the cover class schema.
Index Description indexDescription no text n/a no Description of the specific coverclass. This is particularly helpful in the case that there is no numeric value that can be applied.