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

171010

VegBank Data Dictionary: Field Details

Search for a VegBank Field (enter a word, field name, etc.):    <<Hide search Match any word Match whole words only Search for VegBank Field >>

Search VegBank Tables Here

Table (DB Name)	commInterpretation
Table	Community Interpretation
Field	Notes
DB Field Name	notes
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Notes pertaining to the classification analysis and decision.

 

Table (DB Name)	commInterpretation
Table	Community Interpretation
Field	Typal
DB Field Name	type
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This assignment is the type description for the community concept, as indicated in the publication referenced in commClass.classPublication_ID (NOT the commAuthority_ID of this commInterpretation table).

 

Table (DB Name)	commInterpretation
Table	Community Interpretation
Field	Nomenclatural Type
DB Field Name	nomenclaturalType
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Typal plot for the Braun-Blanquet community name.

 

Table (DB Name)	coverIndex
Table	Cover Index
Field	ID
DB Field Name	COVERINDEX_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the coverIndex table
Definition	Database generated identifier assigned to each unique coverclass associated index value.

 

Table (DB Name)	coverIndex
Table	Cover Index
Field	Cover Method
DB Field Name	COVERMETHOD_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	coverMethod.COVERMETHOD_ID
List?	no
Notes	Foreign key into the coverMethod table.
Definition	Links to a specific cover scale.

 

Table (DB Name)	coverIndex
Table	Cover Index
Field	Cover Code
DB Field Name	coverCode
Req'd?	required
Data Type	varchar (10)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The name or label used in the coverclass scale for this specific coverclass.

 

Table (DB Name)	coverIndex
Table	Cover Index
Field	Upper Limit
DB Field Name	upperLimit
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Upper limit, in percent, associated with the specific coverCode.

 

Table (DB Name)	coverIndex
Table	Cover Index
Field	Lower Limit
DB Field Name	lowerLimit
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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.

 

Table (DB Name)	coverIndex
Table	Cover Index
Field	Cover Percent
DB Field Name	coverPercent
Req'd?	required
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	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.

 

Table (DB Name)	coverIndex
Table	Cover Index
Field	Index Description
DB Field Name	indexDescription
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Description of the specific coverclass. This is particularly helpful in the case that there is no numeric value that can be applied.