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

461010

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)	taxonInterpretation
Table	Taxon Interpretation
Field	Taxon Observation
DB Field Name	TAXONOBSERVATION_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	taxonObservation.TAXONOBSERVATION_ID
List?	no
Notes	Foreign key into the taxonObservation table.
Definition	Link to a particular taxon observation.

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	Stem Location
DB Field Name	stemLocation_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	stemLocation.STEMLOCATION_ID
List?	no
Notes	Foreign key into the StemLocation table.
Definition	StemLocation record of a particular stem that is to be interpreted by this taxonInterpretation record.

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	Plant Concept
DB Field Name	PLANTCONCEPT_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plantConcept.PLANTCONCEPT_ID
List?	no
Notes	Foreign key into the plantConcept table.
Definition	Link to a taxon in the plantConcept table. The entry in the plantConcept table will in turn point to a reference and a name used in the reference, thereby defining the taxon concept. The name that should be applied to the plantConcept will be party specific and will be found in the plantUsage table. For other than legacy data, the first interpretation recorded for a taxon observation should be redundant with the information contained in taxonObservation.PLANTNAME_ID + PLANTREFERENCE_ID.

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	Interpretation Date
DB Field Name	interpretationDate
Req'd?	required
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The date that the interpretation was made.

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	Plant Name
DB Field Name	PLANTNAME_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	plantName.PLANTNAME_ID
List?	no
Notes	Foreign key into the taxonName table.
Definition	Foreign key into the plantName (in the plantTaxa database) table to identify the name applied by the interpreter to the plantConcept. This field is not needed except in cases where there is a publication associated with the interpretation.

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
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	Foreign key that identifies the party that made the interpretation, which could be the observation author.

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	Role
DB Field Name	ROLE_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	aux_Role.ROLE_ID
List?	no
Notes	Foreign key into aux_Role table
Definition	Foreign key that identifies the role of the party making the interpretation (e.g., plot author, publication author, database manager, automated, plot contributor).

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	Interpretation Type
DB Field Name	interpretationType
Req'd?	no
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	Categories for the interpretation (e.g., author, computer generated, simplified for comparative analysis, correction, finer resolution).
closed List of Values: Value Description Sorting Author Ideally, the field workers who sampled to plot, but it could also be the person who compiled and submitted the plot to the database, or the person who published the plot. 1 Computer (automated) Automated taxonomic change following a taxonomic revision. 2 Simplification for analysis This is for the case where one marks up a plot to reflect the interpretaions used in an analysis of multiple plots where the plots had to have a common taxonomy for comparison purposes. These interpretations are of relatively limited value except for documenting the analysis conducted, and many times this is better done in the supplemental material attached to the paper than in the plot database. 3 Correction A new interpretation was made because the interpreter has reason to believe that another determination was incorrect or of different certainty than stated. 4 Taxonomic revision Changes in interpretation made to reflect taxonomic changes. 5 Finer resolution The interpreter has reason to believe that determination can be made at a finer level of taxonomic resolution. 6

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	Reference
DB Field Name	reference_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	Foreign key into the reference table.
Definition	Foreign key into reference table, which identifies a publication in which the interpretation was formally made, or in which the plot was used in a formal analysis.

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	Original Interpretation
DB Field Name	originalInterpretation
Req'd?	required
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This interpretation corresponds to the original interpretation of the plot author, as best as can be determined. There is no requirement that the authority match the authority of the author; only that the concepts are synonymous.