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

detailsoilobsdba_tabledescriptionwhere_tablenamesoilobs

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 for VegBank Table >>

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. this row embargoed. emb_soilObs no Integer denorm no This value mimics the default embargo value for the plot that this record belongs to.