Detailed Soil Surveys Data Model

The detailed soil survey data available on this site has the following data structure. Click on each table to get its description.

Map Unit Table (MAPUNIT) Polygon Attribute Table (PAT) Soil Layer Table (LAYER) Soil Name Table(NAME) Component Table (CMP)

Select each table to get its description

this graph shows the relationships and contents of five tables, the mandatory and optional fields are listed here.

there are four statements to describe the relationships among the tables

  • PAT is related to MAPUNIT by mapunit
  • PAT is related to CMP by mapunit
  • CMP is related to NAME by soiltype
  • NAME is related to LAYER by soiltype

PAT has the following fields:

  • mandatory LAND_AREA
  • mandatory WATER_AREA
  • mandatory POLYGON_AREA
  • mandatory MAPUNIT

MAPUNIT has the following fields:

  • mandatory MAPUNIT
  • optional INTERP
  • optional SLC-V2.2
  • optional OLDMAPUNITNOM

CMP has the following fields

  • mandatory MAPUNIT
  • mandatory CMP
  • mandatory PERCENT
  • mandatory SLOPE
  • mandatory STONINESS
  • mandatory SOILTYPE
  • optional CLI
  • optional EROSION
  • optional SALINITY
  • optional ROCKINESS
  • optional SLOPE_LENGTH

NAME has the following fields

  • mandatory SOILTYPE
  • mandatory LU_FLAG
  • mandatory SOILNAME
  • mandatory SOILNAME
  • mandatory KIND
  • mandatory WATERTBL
  • mandatory ROOTRESTRI
  • mandatory RESTR_TYPE
  • mandatory DRAINAGE
  • mandatory MDEP1
  • mandatory MDEP2
  • mandatory MDEP3
  • mandatory ORDER
  • mandatory S_GROUP
  • mandatory G_GROUP
  • mandatory ORDER3
  • mandatory S_GROUP3
  • mandatory G_GROUP3
  • mandatory PROFILE
  • optional PHYSICAL
  • optional CHEMICAL
  • optional US_ORDER
  • optional US_S_GROUP
  • optional US_G_GROUP

LAYER has the following fields:

  • mandatory SOILTYPE
  • mandatory LAYER_NO
  • mandatory HZN_LIT
  • mandatory HZN_MAS
  • mandatory HZN_SUF
  • mandatory HZN_MOD
  • mandatory UDEPTH
  • mandatory LDEPTH
  • optional COFRAG
  • optional DOMSAND
  • optional VFSAND
  • optional TSAND
  • optional TSILT
  • optional TCLAY
  • optional ORGCARG
  • optional PHCA
  • optional PH2
  • optional BASES
  • optional CEC
  • optional KSAT
  • optional KP0
  • optional KP10
  • optional KP33
  • optional KP1500
  • optional BD
  • optional EC
  • optional CACO3
  • optional VONPOST
  • optional WOOD
  • optional LAYER_KEY

The Detailed Soil Surveys Data Model is similar to the SLC Data Model:

Relation between the SLC Data Model and the Detailed Data Model. Description of this image follows.

this graph shows that the SLC data model is similar to the Detailed Soil Surveys Data Model

but the two models are not practically joined

the SLC data model has the structure

  • SLC Coverage has a Polygon Attribute Table (PAT)
  • PAT is related to CMP by SL
  • CMP is related to NAME by SOILTYPE
  • NAME is related to LAYER by SOILTYPE
  • NAME is related to the Pedon Database by PROFILE

the Detailed Soil Coverage data model has a similar structure

  • the Detailed Soil Coverage has a Polygon Attribute Table (PAT)
  • PAT is related to CMP by MAPUNIT
  • CMP is related to NAME by SOILTYPE
  • NAME is related to LAYER by SOILTYPE
  • NAME is related to the Pedon Database by PROFILE