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 soilTaxon
Table Soil Taxon
Notes This table stores the valid soilTaxon records that may be used to describe the soil of a plot.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID SOILTAXON_ID no serial PK no Database assigned value for a unique soil type
Soil Code soilCode no varchar (15) n/a no SCS Code
Soil Name soilName no varchar (100) n/a no Name of soil type
Soil Level soilLevel no Integer n/a no Hierarchical level; 1=Order, 2=Suborder, 3=GreatGroup, 4=SubGroup, 5=Family, 6=Series
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 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.
Accession Code accessionCode no varchar (100) n/a no Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).