VegBank Data Dictionary: Field Details

Javascript is disabled! Some VegBank functions will not work without it. More info...

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 VegBank Tables Here

««more pages

«previous | 21 | 22 | page 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | next»
records 221 through 230 of 503

Table (DB Name)	observation
Table	Observation
Field	Previous Observation
DB Field Name	PREVIOUSOBS_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	observation.OBSERVATION_ID
List?	no
Notes	Recursive foreign key
Definition	Link to data from the previous observation of this plot.

Table (DB Name)	observation
Table	Observation
Field	Plot
DB Field Name	PLOT_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plot.PLOT_ID
List?	no
Notes	Foreign key into the plot table.
Definition	Link to data and metadata that do not change between observations and which are stored in the plot table.

Table (DB Name)	observation
Table	Observation
Field	Project
DB Field Name	PROJECT_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	project.PROJECT_ID
List?	no
Notes	Foreign key into the project table.
Definition	Link between an observation and the project within which the observation was made

Table (DB Name)	observation
Table	Observation
Field	Author Observation Code
DB Field Name	authorObsCode
Req'd?	no
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the code or name that the author uses to identify this plot observation event. Where a plot has only one observation, this will often equal plot.authorPlotCode.

Table (DB Name)	observation
Table	Observation
Field	Observation Start Date
DB Field Name	obsStartDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	default = current year
Definition	The date of the observation, or the first day if the observation spanned more than one day.

Table (DB Name)	observation
Table	Observation
Field	Observation End Date
DB Field Name	obsEndDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	If the observation event spanned more than a single day, this is the last day on which observations were made.

Table (DB Name)

observation

Table

Observation

Field

Date Accuracy

DB Field Name

dateAccuracy

Req'd?

Data Type

varchar (30)

Misc Flag

n/a

References

n/a

List?

closed

Notes

closed list

Definition

Estimated accuracy of the observation date.

closed List of Values:
Value	Description	Sorting
Exact	The exact date of the observation - within one day.	1
One week		2
One month	Within one month of the observation.	3
Three months		4
One year		5
Three years		6
Ten years		7
Greater than ten years		8

Table (DB Name)	observation
Table	Observation
Field	Date Entered into VegBank
DB Field Name	dateEntered
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Date that the observation was added to VegBank

Table (DB Name)	observation
Table	Observation
Field	Cover Method
DB Field Name	COVERMETHOD_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	coverMethod.COVERMETHOD_ID
List?	no
Notes	Foreign key into the coverMethod table.
Definition	Link to the scale used to estimate taxon cover. The database stores estimated cover to the nearest percent, but the conversion details are recovered by reference to the specific scale employed.