Login | Datasets | Logout
 

VegBank Data Dictionary: Tables

  Search for a VegBank Table (enter a word, field name, etc.):    <<Hide search
Match any word
Match whole words only

   Search VegBank Fields Here

Show field labels | Show database names

DB Table Name soilObs
Table Soil Observation
Notes This table stores observation on soil horizons made during the plot observation event.
Description soilObs is child of observation in recognition of the fact that the horizons observed vary among plot observation events as a results of real change plus changes in investigators, methods and circumstances.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID SOILOBS_ID no serial PK no Database generated identifier assigned to each unique soil observation.
Observation OBSERVATION_ID required Integer FK no Link to the observation event to which this soil observation is associated.
Soil Horizon soilHorizon required varchar (15) n/a closed The horizon to which this observation applies.
Soil Depth Top soilDepthTop no Float n/a no The depth at which the horizon observation starts.
Soil Depth Bottom soilDepthBottom no Float n/a no The depth at which the horizon observation ends.
Soil Color soilColor no varchar (30) n/a no Soil color (USDA guidelines recommended).
Soil Organic soilOrganic no Float n/a no Percent organic content of the soil (for methods see observation.methodsNarrative).
Soil Texture soilTexture no varchar (50) n/a closed Soil texture class.The texture classes sands, loamy sands, and sandy loams (plural terms) correspond to sand, loamy sand, and sandy loam (singular terms) in the textural triangle.
Soil Sand soilSand no Float n/a no Percent sand in the soil horizon.
Soil Silt soilSilt no Float n/a no Percent silt in the soil horizon.
Soil Clay soilClay no Float n/a no Percent clay in the soil horizon.
Soil Coarse soilCoarse no Float n/a no percent coarse fragments in the soil, prior to removal for textural analysis
Soil PH soilPH no Float n/a no pH of the soil (for methods see observation.methodsNarrative).
Exchange Capacity exchangeCapacity no Float n/a no Cation exchange capacity (for methods see observation.methodsNarrative).
Base Saturation baseSaturation no Float n/a no Percent base saturation (for methods see observation.methodsNarrative).
Soil Description soilDescription no text n/a no Text description of the soil.