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_tabledescriptioncoverindexwhere_tablenamecoverIndex

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