VegBranch Loading Tables Overview -- Soil Data (F)
Navigation between loading tables:
Party Information | Species List | Plot Data | Plot Normalized | Presence Data | Strata Cover Data | Stem Data | Stem Classes | Soil Data | Disturbance Data | Community Concept | Plot Communities | User Defined Metadata
Jump to a different part of this page: Field Descriptions | Example Data
| Summary: | Data about the soils collected from a plot. |
| Description: | Soils data of standard types are listed in this table. For attributes that are not standard, userDefined fields must be used due to differences in methods of calculating soil variables. Each plot is linked to Plot Data by authorPlotCode. |
| Required in VegBranch: | Not required. |
| Represents VegBank Tables: | soilObs |
| VegBranch can generate for you: | no |
| Questions: | Were soils data collected on the plots? |
| Expertise Level: | medium |
Fields (Columns) in this table:
| » Required fields; you should always fill in values for these: | ||
| AuthorPlotCode text (100) |
Author's Plot number/code, or the original plot number if taken from literature. This "points" to the right plot in the Plot Data Loading Table. | |
| soilHorizon text (15) |
The horizon to which this observation applies. | |
| » Commonly used fields: | ||
| soilDepthTop Double |
The depth at which the horizon observation starts. | |
| soilDepthBottom Double |
The depth at which the horizon observation ends. | |
| soilColor text (30) |
Soil color (USDA guidelines recommended). | |
| soilOrganic Double |
Percent organic content of the soil (for methods see observation.methodsNarrative). | |
| soilTexture text (250) |
Soil texture class. | |
| soilSand Double |
Percent sand in the soil hoizon. | |
| soilSilt Double |
Percent silt in the soil horizon. | |
| soilClay Double |
Percent clay in the soil horizon. | |
| soilCoarse Double |
percent coarse fragments in the soil, prior to removal for textural analysis | |
| soilPH Double |
pH of the soil (for methods see observation.methodsNarrative). | |
| exchangeCapacity Double |
Cation exchange capacity (for methods see observation.methodsNarrative). | |
| baseSaturation Double |
Percent base saturation (for methods see observation.methodsNarrative). | |
| soilDescription Memo |
Text description of the soil. | |
| » Sometimes used fields: | ||
| UserDef1 Text (255) |
The value of the user-defined variable. | |
| UserDef2 Text (255) |
The value of the user-defined variable. | |
| UserDef3 Text (255) |
The value of the user-defined variable. | |
| UserDef4 Text (255) |
The value of the user-defined variable. | |
| UserDef5 Text (255) |
The value of the user-defined variable. | |
| UserDef6 Text (255) |
The value of the user-defined variable. | |
| UserDef7 Text (255) |
The value of the user-defined variable. | |
| UserDef8 Text (255) |
The value of the user-defined variable. | |
| UserDef9 Text (255) |
The value of the user-defined variable. | |
| UserDef10 Text (255) |
The value of the user-defined variable. | |
| UserDef11 Text (255) |
The value of the user-defined variable. | |
| UserDef12 Text (255) |
The value of the user-defined variable. | |
| UserDef13 Text (255) |
The value of the user-defined variable. | |
| UserDef14 Text (255) |
The value of the user-defined variable. | |
| UserDef15 Text (255) |
The value of the user-defined variable. | |
| UserDef16 Text (255) |
The value of the user-defined variable. | |
| UserDef17 Text (255) |
The value of the user-defined variable. | |
| UserDef18 Text (255) |
The value of the user-defined variable. | |
| UserDef19 Text (255) |
The value of the user-defined variable. | |
| UserDef20 Text (255) |
The value of the user-defined variable. | |
| UserDef21 Text (255) |
The value of the user-defined variable. | |
| UserDef22 Text (255) |
The value of the user-defined variable. | |
| UserDef23 Text (255) |
The value of the user-defined variable. | |
| UserDef24 Text (255) |
The value of the user-defined variable. | |
| UserDef25 Text (255) |
The value of the user-defined variable. | |
| UserDef26 Text (255) |
The value of the user-defined variable. | |
| UserDef27 Text (255) |
The value of the user-defined variable. | |
| UserDef28 Text (255) |
The value of the user-defined variable. | |
| UserDef29 Text (255) |
The value of the user-defined variable. | |
| UserDef30 Text (255) |
The value of the user-defined variable. | |
| UserDef31 Text (255) |
The value of the user-defined variable. | |
| UserDef32 Text (255) |
The value of the user-defined variable. | |
| UserDef33 Text (255) |
The value of the user-defined variable. | |
| UserDef34 Text (255) |
The value of the user-defined variable. | |
| UserDef35 Text (255) |
The value of the user-defined variable. | |
| » Internal VegBranch fields, please do not edit directly: | ||
| Z_SOIL_ID autoNumber |
Database generated identifier assigned to each unique soil observation. | |
Examples of this data table:
advanced example that uses User Defined Data:
| AuthorPlotCode | soilHorizon | soilColor | soilSand | soilSilt | soilClay | soilDescription | soilTexture | UserDef1 | UserDef2 |
|---|---|---|---|---|---|---|---|---|---|
| plt1 | A | brown | 41 | 45 | 4 | ||||
| plt1 | B | red | 1 | 9 | 90 | ||||
| plt1 | C | grey | 1 | 20 | 80 | ||||
| plt2 | fine sand | Sand | 54.243 | 64.122 | |||||
| plt3 | sandy loam | 23.112 | 61.79 |
Download this example as a .csv file
simple example with a very few fields:
| AuthorPlotCode | soilHorizon | soilColor | soilSand | soilSilt | soilClay | soilDescription | soilTexture |
|---|---|---|---|---|---|---|---|
| plt1 | A | brown | 41 | 45 | 4 | ||
| plt1 | B | red | 1 | 9 | 90 | ||
| plt1 | C | grey | 1 | 20 | 80 | ||
| plt2 | fine sand | Sand | |||||
| plt3 | sandy loam |
Download this example as a .csv file