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

481010

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	Notes Public
DB Field Name	notesPublic
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	TRUE indicates that public notes pertaining to this plot exist in "vegPlot.note"

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	Notes Mgt
DB Field Name	notesMgt
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	TRUE indicates that nonpublic management notes pertaining to this plot exist in "vegPlot.note"

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
Field	Revisions
DB Field Name	revisions
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	TRUE indicates that revisions exist in vegPlot.Revision

 

Table (DB Name)	taxonInterpretation
Table	Taxon Interpretation
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)	taxonObservation
Table	Taxon Observation
Field	ID
DB Field Name	TAXONOBSERVATION_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key of the table.
Definition	Database generated identifier assigned to each unique observation of a taxon in a plot.

 

Table (DB Name)	taxonObservation
Table	Taxon Observation
Field	Observation
DB Field Name	OBSERVATION_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	observation.OBSERVATION_ID
List?	no
Notes	Foreign key into the Observation table.
Definition	Link to the parent observation event of this taxon observation.

 

Table (DB Name)	taxonObservation
Table	Taxon Observation
Field	Author Plant Name
DB Field Name	authorPlantName
Req'd?	no
Data Type	varchar (255)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The taxon name that the author of the plot used to refer to a taxon observed within the plot.

 

Table (DB Name)	taxonObservation
Table	Taxon Observation
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	The authority for the taxon that was used by the plot author. If the authority is unknown the author of the plot is the authority. For other than legacy data, this field plus plantName_ID will be sufficient to determine taxonInterpretation.plantConcept_ID.

 

Table (DB Name)	taxonObservation
Table	Taxon Observation
Field	Taxon Inference Area
DB Field Name	taxonInferenceArea
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	The area used to infer the presence of the taxon, if not the same as observation.taxonInferenceArea.
Definition	This is the area in m2 used to infer the presence of a given taxon. Generally this should be equal to observation.taxonInferenceArea, but at times this area may be larger or smaller for a specific taxon. RESERVED VALUE: -1 is used to indicate that no known plot boundaries were used when recording this species on the plot. That is, this species may occur outside the plot area as indicated in the plot and observation tables.

 

Table (DB Name)	taxonObservation
Table	Taxon Observation
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).