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

441010

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)	stratum
Table	Stratum Definition
Field	Stratum Cover
DB Field Name	stratumCover
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Cover of the vegetation within the given stratum in percent.

 

Table (DB Name)	stratumMethod
Table	Stratum Method
Field	ID
DB Field Name	STRATUMMETHOD_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary Key for the stratumMethod table.
Definition	Database generated identifier assigned to each unique stratum methodology.

 

Table (DB Name)	stratumMethod
Table	Stratum Method
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	Link to a publication defining the stratum method.

 

Table (DB Name)	stratumMethod
Table	Stratum Method
Field	Stratum Method Name
DB Field Name	stratumMethodName
Req'd?	required
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name of the stratum method (e.g., Braun-Blanquet, TNC-ABI, NC Vegetation Survey #1, NC Vegetation Survey #2, etc.)

 

Table (DB Name)	stratumMethod
Table	Stratum Method
Field	Stratum Method Description
DB Field Name	stratumMethodDescription
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This field describes the general methods used for strata. For example, this field should distinguish as to whether strata are defined as including all foliage on plants that predominantly occupy the stratum regardless of the height of that foliage, or only the foliage that actually occurs within a specified vertical slice of the community.

 

Table (DB Name)	stratumMethod
Table	Stratum Method
Field	Stratum Assignment
DB Field Name	stratumAssignment
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
Definition	The way that an individual's cover is assigned to the different stratum. Some methodologies allow an individul to span multiple strata and have stratumCover values in each stratum. Other methodologies require that all cover from an individual be assigned to the upper-most stratum. Further information about the specifics of stratum Methodologies that deviate from the standard practice of the stratumMethod referened in the field stratumMethod_ID should be described in methodNarrative.
closed List of Values: Value Description Sorting predominant stratum Each individual is assigned to one and only one stratum in which it most significantly occurs. Generally, this is the tallest stratum that the individual occupies. 1 soley height determined Individuals are included in each stratum they occupy, allowing one individual to be assigned to multiple strata, if it crosses the height boundary between strata. 2

 

Table (DB Name)	stratumMethod
Table	Stratum Method
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)	stratumType
Table	Stratum Type
Field	ID
DB Field Name	STRATUMTYPE_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the stratum table.
Definition	Database assigned value for a unique existence of a stratum within a plot observation.

 

Table (DB Name)	stratumType
Table	Stratum Type
Field	Stratum Method
DB Field Name	STRATUMMETHOD_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	stratumMethod.STRATUMMETHOD_ID
List?	no
Notes	Foreign key into the stratumMethod table.
Definition	This attribute will link to the stratum to the stratum methodology used.

 

Table (DB Name)	stratumType
Table	Stratum Type
Field	Stratum Index
DB Field Name	stratumIndex
Req'd?	no
Data Type	varchar (10)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Short code used to identify the stratum