Legend

SACATALOG

(Survey Area Catalog)

sacatalogkey (PK)

areasymbol (AK1)

SAINTERP

(Survey Area Interpretation)

sainterpkey (PK)

sacatalogkey (FK1)

LEGEND (copy 1)

(Legend)

lkey (PK)

areasymbol (AK1)

DISTMD

(Distribution Metadata)

distmdkey (PK)

sacatalogkey

DISTLEGENDMD

(Distribution LegendMetadata)

distlegendmdkey (PK)

distmdkey (FK1)

lkey (FK2)

DISTINTERPMD

(Distribution Interp Metadata)

distinterpmdkey (PK)

distmdkey (FK1)

distmdkey

distmdkey

SAPOLYGON

(Survey Area Polygon)

lkey (FK1)

areasymbol (FK2)

MUPOLYGON

(Mapunit Polygon)

mukey (FK1)

areasymbol (FK2)

MULINE

(Mapunit Line)

mukey (FK1)

areasymbol (FK2)

MUPOINT

(Mapunit Point)

mukey (FK1)

areasymbol (FK2)

FEATLINE

(Feature Line)

featkey (FK1)

areasymbol (FK2)

FEATPOINT

(Feature Point)

featkey (FK1)

areasymbol (FK2)

FEATDESC

(Feature Description)

featkey (PK)

areasymbol (FK1)

lkey

featkey

featkey

MAPUNIT (copy 1)

(Mapunit)

mukey (PK)

lkey (FK1)

lkey mukey

mukey

mukey

LEGEND (copy 2)

(Legend)

lkey (PK)

areasymbol (AK1)

MAPUNIT (copy 2)

(Mapunit)

mukey (PK)

lkey (FK1)

LEGENDTEXT

(Legend Text)

legtextkey (PK)

lkey (FK1)

LAOVERLAP

(Legend Area Overlap)

lareaovkey (PK)

lkey (FK1)

lkey

lkey lkey

MUAOVERLAP

(Mapunit Area Overlap)

muareaovkey (PK)

lareaovkey (FK1)

mukey (FK2)

lareaovkey

mukey

MUAGGATT

(Mapunit Aggregated Attribute)

mukey (PK)(FK1) mukey

MUCROPYLD

(Mapunit Crop Yield)

mucrpyldkey (PK)

mukey (FK1)

MUTEXT

(Mapunit Text)

mutextkey (PK)

mukey (FK1)

mukey

mukey

COMPONENT

(Component)

cokey (PK)

mukey (FK1)

mukey

COCROPYLD

(Component Crop Yield)

cocropyldkey (PK)

cokey (FK1)

COCANOPYCOVER

(Component Canopy Cover)

cocanopycovkey (PK)

cokey (FK1)

CHORIZON

(Horizon)

chkey (PK)

cokey (FK1)

cokey

CODIAGFEATURES

(Component Diagnostic Features)

codiagfeatkey (PK)

cokey (FK1)

COECOCLASS

(Component Ecological Classification)

coecoclasskey (PK)

cokey (FK1)

COEROSIONACC

(Component Erosion Accelerated)

coeroacckey (PK)

cokey (FK1)

COEPLANTS

(Component Existing Plants)

coeplantskey (PK)

cokey (FK1)

COFORPROD

(Component Forest Productivity)

cofprodkey (PK)

cokey (FK1)

COFORPRODO

(Component Forest Productivity 

Other)

cofprodokey (PK)

cofprodkey (FK1)

COGEOMORDESC

(Component Geomorphic Description)

cogeomdkey (PK)

cokey (FK1)

COSURFMORPHGC

(Component Three Dimensional 

Surface Morphometry)

cosurfmorgckey (PK)

cogeomdkey (FK1)

COSURFMORPHHPP

(Component Two Dimensional 

Surface Morphometry)

cosurfmorhppkey (PK)

cogeomdkey (FK1)

COSURFMORPHMR

(Component Microrelief Surface 

Morphometry)

cosurfmormrkey (PK)

cogeomdkey (FK1)

COSURFMORPHSS

(Component Slope Shape Surface 

Morphometry)

cosurfmorsskey (PK)

cogeomdkey (FK1)

COHYDRICCRITERIA

(Component Hydric Criteria)

cohydcritkey (PK)

cokey (FK1)

COINTERP

(Component Interp)

cointerpkey (PK)

cokey (FK1)

COMONTH

(Component Month)

comonthkey (PK)

cokey (FK1)

COSOILMOIST

(Component Soil Moisture)

cosoilmoistkey (PK)

comonthkey (FK1)

COSOILTEMP

(Component Soil Temperature)

cosoiltempkey (PK)

comonthkey (FK1)

COPMGRP

(Component Parent Material Group)

copmgrpkey (PK)

cokey (FK1)

COPM

(Component Parent Material)

copmkey (PK)

copmgrpkey (FK1)

COPWINDBREAK

(Component Potential Windbreak)

copwindbreakkey (PK)

cokey (FK1)

CORESTRICTIONS

(Component Restrictions)

corestrictkey (PK)

cokey (FK1)

COSURFFRAGS

(Component Surface Fragments)

cosurffragskey (PK)

cokey (FK1)

COTXFMOTHER

(Component Taxonomic Family 

Other)

cotaxfokey (PK)

cokey (FK1)

COTAXFMMIN

(Component Taxonomic Family 

Other)

cotaxfmminkey (PK)

cokey (FK1)

COTAXMOISTCL

(Component Taxonomic Moisture 

Class)

cotaxmckey (PK)

cokey (FK1)

COTEXT

(Component Text)

cotextkey (PK)

cokey (FK1)

COTREESTOMNG

(Component Trees to Manage)

cotreestomngkey (PK)

cokey (FK1)

CHAASHTO

(Horizon AASHTO)

chaashtokey (PK)

chkey (FK1)

CHCONSISTENCE

(Horizon Consistence)

chconsistkey (PK)

chkey (FK1)

CHDESGNSUFFIX

(Horizon Designation Suffix)

chdesgnsfxkey (PK)

chkey (FK1)

CHFRAGS

(Horizon Fragments)

chfragskey (PK)

chkey (FK1)

CHPORES

(Horizon Pores)

chporeskey (PK)

chkey (FK1)

CHSTRUCTGRP

(Horizon Structure Group)

chstructgrpkey (PK)

chkey (FK1)

CHSTRUCT

(Horizon Structure)

chstructkey (PK)

chstructgrpkey (FK1)

CHTEXT

(Horizon Text)

chtextkey (PK)

chkey (FK1)

CHTEXTUREGRP

(Horizon Texture Group)

chtgkey (PK)

chkey (FK1)

CHTEXTURE

(Horizon Texture)

chtkey (PK)

chtgkey (FK1)

CHTEXTUREMOD

(Horizon Texture Modifier)

chtexmodkey (PK)

chtkey (FK1)

CHUNIFIED

(Horizon Unified)

chunifiedkey (PK)

chkey (FK1)

chkey

chkey

chkey

chkey

chkey

chkey

chstructgrpkey

chkey

chkey

chkey

chtgkey

chtkey

cokey

cokey

cokey

cokey

cokey

cokey

cokey

cofprodkey

cokey

cogeomdkey

cogeomdkey

cogeomdkey

cogeomdkey

cokey

cokey

cokey

cokey

cokey

cokey

cokey

cokey

cokey

cokey

cokey

cokey

comonthkey

comonthkey

copmgrpkey

SSURGO 2.2 Data Model – Diagram 1 of 2

TABLEPHYSICALNAME

(Table Logical Name)

columnphysicalname (PK)

columnphysicalname (AKn)

columnphysicalname (FKn)

Table contains soil survey area 

metadata.

Table contains soil tabular data.

Table contains soil spatial data and 

includes a geometry column. Table 

is not present in a SSURGO 

template database but the 

corresponding data is provided.*

TABLE A

A record in table A is related to one or 

more records in table B.

TABLE B

A record in table B is related to one 

and only one record in table A.

join column physical name

TABLE A

A record in table A is related to zero 

or more records in table B.

TABLE B

A record in table B is related to one 

and only one record in table A.

join column physical name

TABLE A

A record in table A is related to zero 

or one record in table B.

TABLE B

A record in table B is related to one 

and only one record in table A.

join column physical name

Table contains soil spatial data but 

does not include a geometry 

column. This data may be 

imported into a SSURGO template 

database.**

TABLEPHYSICALNAME (copy n) - this is the nth copy of 

this table in this diagram, but all copies represent the 

same table in the database

columnphysicalname (PK) - column participates in primary 

key

columnphysicalname (AKn) – column participates in 

alternate unique key n

columnphysicalname (FKn) - column participates in 

foreign key n

Only those columns that participate in primary keys, major 

alternate unique keys and foreign keys are shown.

All columns that participate in a particular primary key, 

major alternate unique key or foreign key are included in 

this diagram.

For this data model, any column name that occurs in more 

than one table represents exactly the same concept in 

each table in which it occurs.

*Spatial data is provided either in ArcView Shape File format, as an ArcInfo Coverage or in ArcInfo Interchange format. 

The corresponding spatial tables do not appear in a SSURGO template database unless you have access to ArcGIS 

and use ArcCatalog to convert that database to a personal geodatabase, and then explicitly import the corresponding 

feature classes.

**Spot feature descriptions may be imported into a SSURGO template database, but they are not automatically 

imported with the soil tabular data. The macro “Import Feature Descriptions” must be used to import spot feature 

descriptions.

sacatalogkey = lkey

Table contains soil survey area 

metadata. (Table is obsolete but is 

retained for backwards 

compatabililty with SSURGO 2.0.)

The primary purpose of this data model is to show how tables are related. A table in this 

model shows only a handful of the columns that exist in that table. No diagram exists that 

shows all of the columns in a table. For the complete set of columns in a table, please see 

the tabular report titled “SSURGO Metadata – Table Columns”.

Soil Tabular and Spatial Data Tables