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

161010

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)	commClass
Table	Community Classification
Field	Expert System
DB Field Name	expertSystem
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Description of any automated expert system used in classification.

 

Table (DB Name)	commClass
Table	Community Classification
Field	Classification Publication
DB Field Name	classPublication_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	Foreign key into the reference table
Definition	Link to a publication wherein the observation was classified.

 

Table (DB Name)	commClass
Table	Community Classification
Field	Classification Notes
DB Field Name	classNotes
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Notes about the classification event by the parties participating in the event. This might include the purpose or rationale for the classification.

 

Table (DB Name)	commClass
Table	Community Classification
Field	Accession Code
DB Field Name	accessionCode
Req'd?	no
Data Type	varchar (100)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).

 

Table (DB Name)	commInterpretation
Table	Community Interpretation
Field	ID
DB Field Name	COMMINTERPRETATION_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary Key for the communityInterpretation table.
Definition	Database generated identifier assigned to each unique assignment of a community concept to a plot observation.

 

Table (DB Name)	commInterpretation
Table	Community Interpretation
Field	Community Classification
DB Field Name	COMMCLASS_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	commClass.COMMCLASS_ID
List?	no
Notes	Foreign key into the commClassification table.
Definition	Link to the commClassification table identifying the specific classification event.

 

Table (DB Name)	commInterpretation
Table	Community Interpretation
Field	Community Concept
DB Field Name	COMMCONCEPT_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	commConcept.COMMCONCEPT_ID
List?	no
Notes	Foreign key into the commConcept table.
Definition	Link to the communityConcept table identifying the specific community concept being applied.

 

Table (DB Name)	commInterpretation
Table	Community Interpretation
Field	Class Fit
DB Field Name	classFit
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	Indicates the degree of fit with the community concept being assigned. Values derive from Gopal, S., and Woodcock, C. (1994), Theory and methods for accuracy assessment of thematic maps using fuzzy sets. Photogrammetric Engineering and Remote Sensing 60(2):181-188.
closed List of Values: Value Description Sorting Absolutely wrong (Absolutely doesn't fit) This answer is absolutely unacceptable. Unambiguously incorrect. 1 Understandable but wrong (Doesn't fit but is close) Not a good answer. There is something about the plot that makes the answer understandable, but there is clearly a better answer. This answer would pose a problem for users. Incorrect. 2 Reasonable or acceptable answer (Possibly fits) Maybe not the best possible answer but it is acceptable; this answer does not pose a problem to the user. Correct. 3 Good answer (Fits reasonably well) Good match with the concept. Unambiguously correct. 4 Absolutely correct (Fits well) No doubt about the match. Perfect fit. 5

 

Table (DB Name)	commInterpretation
Table	Community Interpretation
Field	Class Confidence
DB Field Name	classConfidence
Req'd?	no
Data Type	varchar (15)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	Indicates the degree of confidence of the interpreter(s) in the interpretation made. This can reflect the level of familiarity with the classification or the sufficiency of information about the plot (e.g., High, Moderate, Low).
closed List of Values: Value Description Sorting High The party making the community interpretation has a high confidence in the accuracy of this interpretation. A party can have high confidence that a plot has a fit of "absolutely wrong" for a particular community. 1 Medium The party making the community interpretation has a medium amount of confidence in the accuracy of this interpretation. 2 Low The party making the community interpretation has a low confidence in the accuracy of this interpretation. 3

 

Table (DB Name)	commInterpretation
Table	Community Interpretation
Field	Community Authority Reference
DB Field Name	commAuthority_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	Foreign key into the reference table
Definition	Link to the reference from which information on the community concept was obtained during the classification event. (A case could be made for this being moved to reference.)