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

271010

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)	observation
Table	Observation
Field	Soil Taxon
DB Field Name	SOILTAXON_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	soilTaxon.SOILTAXON_ID
List?	no
Notes	hierarchy
Definition	Foreign key into table of soil taxa within the USDA classification hierarchy, including Order, Suborder, Greatgroup, Subgroup, Family and Series.

 

Table (DB Name)	observation
Table	Observation
Field	Soil Taxon Source
DB Field Name	soilTaxonSrc
Req'd?	no
Data Type	varchar (200)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	How was the soil taxon determined (e.g., field observation, map, other sources)?
closed List of Values: Value Description Sorting Field observation   1 USDA county soil survey   2 Other soil map   3

 

Table (DB Name)	observation
Table	Observation
Field	Percent Bedrock
DB Field Name	percentBedRock
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Percent of surface that is exposed bedrock.

 

Table (DB Name)	observation
Table	Observation
Field	Percent Rock / Gravel
DB Field Name	percentRockGravel
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Percent of surface that is exposed rock and gravel.

 

Table (DB Name)	observation
Table	Observation
Field	Percent Wood
DB Field Name	percentWood
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Percent of surface that is wood.

 

Table (DB Name)	observation
Table	Observation
Field	Percent Litter
DB Field Name	percentLitter
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Percent of surface that is litter.

 

Table (DB Name)	observation
Table	Observation
Field	Percent Bare Soil
DB Field Name	percentBareSoil
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Percent of surface that is bare soil.

 

Table (DB Name)	observation
Table	Observation
Field	Percent Water
DB Field Name	percentWater
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Percent of surface that is water.

 

Table (DB Name)	observation
Table	Observation
Field	Percent Other
DB Field Name	percentOther
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Percent of surface that belong to an additional itemized category

 

Table (DB Name)	observation
Table	Observation
Field	Name Other
DB Field Name	nameOther
Req'd?	no
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name of additional itemized ground cover category (e.g., beer cans).