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

491010

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)	taxonAlt
Table	Taxon Alt
Field	ID
DB Field Name	taxonAlt_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database generated number to uniquely identify this record, and thus taxonGroup.

 

Table (DB Name)	taxonAlt
Table	Taxon Alt
Field	Taxon Interpretation
DB Field Name	taxonInterpretation_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	taxonInterpretation.TAXONINTERPRETATION_ID
List?	no
Notes	n/a
Definition	Links to the taxonInterpretation for which several plantConcepts are grouped to form an irregular taxon. The plantConcept referenced here is one member of the group.

 

Table (DB Name)	taxonAlt
Table	Taxon Alt
Field	Plant Concept
DB Field Name	plantConcept_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plantConcept.PLANTCONCEPT_ID
List?	no
Notes	n/a
Definition	Links to the plantConcept that is part of the taxonGroup formed by all records in this table with the same taxonInterpretation_ID.

 

Table (DB Name)	taxonAlt
Table	Taxon Alt
Field	Taxon Fit
DB Field Name	taxonAltFit
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
Definition	Indicates the degree of fit with the plant 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)	taxonAlt
Table	Taxon Alt
Field	Taxon Confidence
DB Field Name	taxonAltConfidence
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
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 taxon 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 taxon interpretation has a medium amount of confidence in the accuracy of this interpretation. 2 Low The party making the taxon interpretation has a low confidence in the accuracy of this interpretation. 3

 

Table (DB Name)	taxonAlt
Table	Taxon Alt
Field	Taxon Alt Notes
DB Field Name	taxonAltNotes
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	These are notes that the interpreter has included with the interpretation (generally, the reason for the interpretation).

 

Table (DB Name)	telephone
Table	Telephone
Field	ID
DB Field Name	TELEPHONE_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the telephone table.
Definition	Database generated identifier assigned to each unique telephone contact record.

 

Table (DB Name)	telephone
Table	Telephone
Field	Party
DB Field Name	PARTY_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	party.PARTY_ID
List?	no
Notes	Foreign key into the party table
Definition	This is the 'link' between a PARTY and an entry in the TELEPHONE table.

 

Table (DB Name)	telephone
Table	Telephone
Field	Phone Number
DB Field Name	phoneNumber
Req'd?	required
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Telephone number.

 

Table (DB Name)	telephone
Table	Telephone
Field	Phone Type
DB Field Name	phoneType
Req'd?	required
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	This is the type of telephone: home, work, fax, cell, secretary, other.
closed List of Values: Value Description Sorting Work   1 Home   2 Cell   3 Fax   4 Secretary   5 Not specified   6