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

411010

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)	soilObs
Table	Soil Observation
Field	Soil PH
DB Field Name	soilPH
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	pH of the soil (for methods see observation.methodsNarrative).

 

Table (DB Name)	soilObs
Table	Soil Observation
Field	Exchange Capacity
DB Field Name	exchangeCapacity
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Cation exchange capacity (for methods see observation.methodsNarrative).

 

Table (DB Name)	soilObs
Table	Soil Observation
Field	Base Saturation
DB Field Name	baseSaturation
Req'd?	no
Data Type	Float
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Percent base saturation (for methods see observation.methodsNarrative).

 

Table (DB Name)	soilObs
Table	Soil Observation
Field	Soil Description
DB Field Name	soilDescription
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Text description of the soil.

 

Table (DB Name)	soilTaxon
Table	Soil Taxon
Field	ID
DB Field Name	SOILTAXON_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the aux_Soil table.
Definition	Database assigned value for a unique soil type

 

Table (DB Name)	soilTaxon
Table	Soil Taxon
Field	Soil Code
DB Field Name	soilCode
Req'd?	no
Data Type	varchar (15)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	SCS Code

 

Table (DB Name)	soilTaxon
Table	Soil Taxon
Field	Soil Name
DB Field Name	soilName
Req'd?	no
Data Type	varchar (100)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name of soil type

 

Table (DB Name)	soilTaxon
Table	Soil Taxon
Field	Soil Level
DB Field Name	soilLevel
Req'd?	no
Data Type	Integer
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Hierarchical level; 1=Order, 2=Suborder, 3=GreatGroup, 4=SubGroup, 5=Family, 6=Series

 

Table (DB Name)	soilTaxon
Table	Soil Taxon
Field	Soil Parent
DB Field Name	SOILPARENT_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	soilTaxon.SOILTAXON_ID
List?	no
Notes	n/a
Definition	Parent soil taxon in the soil taxon hierarchy for this particular framwork. For example, in USDA soils list, the parent of a soil SubGroup would be the GreatGroup.

 

Table (DB Name)	soilTaxon
Table	Soil Taxon
Field	Soil Framework
DB Field Name	soilFramework
Req'd?	no
Data Type	varchar (33)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	System in which this soil taxon is part. This field may be used to separate multiple soil taxonomic systems. Each unique soil taxonomic system should have all its soilTaxon records with the same soilFramework value. Correlation of different framework taxa is not currently possible.