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

351010

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)	plot
Table	Plot
Field	Author Zone
DB Field Name	authorZone
Req'd?	no
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Original UTM zone reported by the author

 

Table (DB Name)	plot
Table	Plot
Field	Author Datum
DB Field Name	authorDatum
Req'd?	no
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Original datum reported by the author

 

Table (DB Name)	plot
Table	Plot
Field	Author Location
DB Field Name	authorLocation
Req'd?	no
Data Type	varchar (200)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Original location as described by author (e.g. Town-Range-Section)

 

Table (DB Name)	plot
Table	Plot
Field	Location Narrative
DB Field Name	locationNarrative
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Text description that provides information useful for plot relocation.

 

Table (DB Name)	plot
Table	Plot
Field	Plot Rationale Narrative
DB Field Name	plotRationaleNarrative
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Text description about why the plot was placed where it was.

 

Table (DB Name)	plot
Table	Plot
Field	Azimuth
DB Field Name	azimuth
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This element stores the azimuth of the x-axis used to describe the relative coordinate system for plot shape (dsgpoly) and other spatial information about the plot. Typically the azimuth is parallel to the long axis of the plot (in the case of a rectangle).

 

Table (DB Name)	plot
Table	Plot
Field	DSG Polygon
DB Field Name	dsgpoly
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This field is a text string containing the points circumscribing a plot area. These points are anticipated to have been collected using tapes, GPS, or calculated from the plot shape and area. Points are X-Y coordinates in m relative to plot origin.

 

Table (DB Name)	plot
Table	Plot
Field	Shape
DB Field Name	shape
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	open
Notes	open list
Definition	Shape of the plot area.
open List of Values: Value Description Sorting Rectangular   1 Square   2 Circle   3 Transect/Strip   4 Plotless   5 Diffuse   6 Other   7

 

Table (DB Name)	plot
Table	Plot
Field	Area
DB Field Name	area
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Total area of the plot in m2. If many subplots, this area includes the subplots and the interstitial space. RESERVED VALUE: -1 is used to indicate that the plot had no boundaries.

 

Table (DB Name)	plot
Table	Plot
Field	Stand Size
DB Field Name	standSize
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	The extent of this community occurrence in relation to the plot size: very extensive (>1000x plot), extensive (>100x plot), large (10-100x plot), small (3-10x plot), very small (1-3x plot).
closed List of Values: Value Description Sorting Very Extensive greater than 1000x plot size 1 Extensive greater than 100x plot size 2 Large 10-100x plot size 3 Small 3-10x plot size 4 Very small 1-3x plot size 5 Inclusion less than 1x plot size 6