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

191010

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)	disturbanceObs
Table	Disturbance 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 that points to the parent observation for this disturbance record
Definition	Link to the observation event with which this report of a disturbance event is associated.

 

Table (DB Name)	disturbanceObs
Table	Disturbance Observation
Field	Disturbance Type
DB Field Name	disturbanceType
Req'd?	required
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	The type of disturbance being reported
closed List of Values: Value Description Sorting Animal, general   1 Grazing, domestic stock   2 Grazing, native ungulates   3 Herbivory, invertebrate   4 Herbivory, vertebrates   5 Human, general   6 Cultivation   7 Fire suppression   8 Herbicide or chemical   9 Mowing   10 Roads and vehicular traffic   11 Timber harvest, general   12 Timber harvest, clearcut   13 Timber harvest, selective   14 Trampling and trails   15 Natural, general   16 Avalanche and snow   17 Cryoturbation   18 Erosion   19 Floods   23 Hydrologic alteration   24 Ice   25 Mass movements (landslides)   26 Plant disease   27 Salt spray   28 Tides   29 Wind, chronic   30 Wind event   31 Fire, general   35 Fire, canopy   36 Fire, ground   37 Other disturbances   40 unknown   50

 

Table (DB Name)	disturbanceObs
Table	Disturbance Observation
Field	Disturbance Intensity
DB Field Name	disturbanceIntensity
Req'd?	no
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	Intensity or degree of the disturbance.
closed List of Values: Value Description Sorting High   1 Medium   2 Low   3 None No disturbance of this type was observed on the plot. This may be a useful observation where certain types of disturbance are expected, but no signs of such disturbance were found. 4

 

Table (DB Name)	disturbanceObs
Table	Disturbance Observation
Field	Disturbance Age
DB Field Name	disturbanceAge
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Estimated time in years since the disturbance event.

 

Table (DB Name)	disturbanceObs
Table	Disturbance Observation
Field	Disturbance Extent
DB Field Name	disturbanceExtent
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Percent of the plot that experienced the event.

 

Table (DB Name)	disturbanceObs
Table	Disturbance Observation
Field	Disturbance Comment
DB Field Name	disturbanceComment
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Text description of details of the disturbance and its impact on the vegetation.

 

Table (DB Name)	graphic
Table	Graphic
Field	ID
DB Field Name	GRAPHIC_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key the graphic table
Definition	Database generated identifier assigned to each unique graphic idem.

 

Table (DB Name)	graphic
Table	Graphic
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 from a graphic file to a specific plot observation.

 

Table (DB Name)	graphic
Table	Graphic
Field	Graphic Name
DB Field Name	graphicName
Req'd?	no
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name of the graphic file.

 

Table (DB Name)	graphic
Table	Graphic
Field	Graphic Location
DB Field Name	graphicLocation
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Where the graphic is located, if not in the database