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

421010

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)	soilTaxon
Table	Soil Taxon
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)	stemCount
Table	Stem Count
Field	ID
DB Field Name	STEMCOUNT_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary Key for the stemSize table.
Definition	Database generated identifier assigned to each unique stem tally.

 

Table (DB Name)	stemCount
Table	Stem Count
Field	Taxon Importance
DB Field Name	TAXONIMPORTANCE_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	taxonImportance.taxonImportance_ID
List?	no
Notes	Foreign key into the taxonImportance table
Definition	Foreign key into the taxonImportance table, thereby associating a taxon identification with the tree stem(s).

 

Table (DB Name)	stemCount
Table	Stem Count
Field	DBH
DB Field Name	stemDiameter
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The diameter of the stem in centimeters. When diameter classes are used, the stemDiameter is the midpoint between the low end and high end for the diameter class; the offset between this and the endpoints is stored in the stemDiameterAccuracy attribute.

 

Table (DB Name)	stemCount
Table	Stem Count
Field	DBH err
DB Field Name	stemDiameterAccuracy
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The accuracy of the stem diameter measurements in centimeters. This represents the distance between the diameter class midpoint and endpoint.

 

Table (DB Name)	stemCount
Table	Stem Count
Field	Ht.
DB Field Name	stemHeight
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The measured height of the stem in meters. When height classes are used, the stemHeight is the midpoint between the low end and high end for the height class; the offset between this and the endpoint is stored in the stemHeightAccuracy field.

 

Table (DB Name)	stemCount
Table	Stem Count
Field	Ht. Err
DB Field Name	stemHeightAccuracy
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The accuracy of the measured height of a stem, being the offset between the midpoint of the class and the endpoint, in meters.

 

Table (DB Name)	stemCount
Table	Stem Count
Field	#
DB Field Name	stemCount
Req'd?	required
Data Type	Integer
Misc Flag	n/a
References	n/a
List?	no
Notes	The default value is 1. This field is not logically necessary, but allows for more compact entry and storage of tree stem tally data.
Definition	The number of stems of a single species that have these specific stem diameter and height data in common.

 

Table (DB Name)	stemCount
Table	Stem Count
Field	Stem Taxon Area
DB Field Name	stemTaxonArea
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the area in m2 used to infer the presence of the stem(s) referenced in this record. Overrides similar area field in taxonObservation, taxonImportance, and/or observation. RESERVED VALUE: -1 is used to indicate no known boundaries were used while collecting this stem size.

 

Table (DB Name)	stemLocation
Table	Stem Location
Field	ID
DB Field Name	STEMLOCATION_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary Key for the stemLocation table.
Definition	Database generated identifier assigned to each unique stem observation.