VegBank Data Dictionary - Search Fields
| Search VegBank Tables Here |
«previous | page 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | next» |
Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
---|---|---|---|---|---|---|---|
Soil Observation | Soil PH | soilPH | no | Float | n/a | no | pH of the soil (for methods see observation.methodsNarrative). |
Soil Observation | Exchange Capacity | exchangeCapacity | no | Float | n/a | no | Cation exchange capacity (for methods see observation.methodsNarrative). |
Soil Observation | Base Saturation | baseSaturation | no | Float | n/a | no | Percent base saturation (for methods see observation.methodsNarrative). |
Soil Observation | Soil Description | soilDescription | no | text | n/a | no | Text description of the soil. |
Soil Taxon | ID | SOILTAXON_ID | no | serial | PK | no | Database assigned value for a unique soil type |
Soil Taxon | Soil Code | soilCode | no | varchar (15) | n/a | no | SCS Code |
Soil Taxon | Soil Name | soilName | no | varchar (100) | n/a | no | Name of soil type |
Soil Taxon | Soil Level | soilLevel | no | Integer | n/a | no | Hierarchical level; 1=Order, 2=Suborder, 3=GreatGroup, 4=SubGroup, 5=Family, 6=Series |
Soil Taxon | Soil Parent | SOILPARENT_ID | no | Integer | FK | no | 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. |
Soil Taxon | Soil Framework | soilFramework | no | varchar (33) | n/a | no | 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. |