This item represents the SSURGO schema of the CRdb database.
This schema is a SDM derivative, provided originally in .mdb format, (MS-Access files), that was imported into SQLServer.
Current SOILS related services, which used to use SSURGO are in the process of transitioning over to using SDM, and at some point SSURGO will be deprecated.
Copies of this schema are currently deployed to NRCS by CSU.
The following tables are found in "SSURGO":
Table Name |
chaashto |
chconsistence |
chdesgnsuffix |
chfrags |
chorizon |
chpores |
chstruct |
chstructgrp |
chtext |
chtexture |
chtexturegrp |
chtexturemod |
chunified |
cocanopycover |
cocropyld |
codiagfeatures |
coecoclass |
coeplants |
coerosionacc |
coforprod |
coforprodo |
cogeomordesc |
cohydriccriteria |
cointerp |
comonth |
component |
copm |
copmgrp |
copwindbreak |
corestrictions |
cosoilmoist |
cosoiltemp |
cosurffrags |
cosurfmorphgc |
cosurfmorphhpp |
cosurfmorphmr |
cosurfmorphss |
cotaxfmmin |
cotaxmoistcl |
cotext |
cotreestomng |
cotxfmother |
distinterpmd |
distlegendmd |
distmd |
featdesc |
laoverlap |
legend |
legendtext |
mapunit |
mdstatdomdet |
mdstatdommas |
mdstatidxdet |
mdstatidxmas |
mdstatrshipdet |
mdstatrshipmas |
mdstattabcols |
mdstattabs |
mlra_9 |
month |
muaggatt |
muaoverlap |
mucropyld |
mutext |
sacatalog |
sainterp |
sdvalgorithm |
sdvattribute |
sdvfolder |
sdvfolderattribute |
soilmu_a |
soilmu_l |
soilmu_p |
soilsa_a |
soilsf_l |
soilsf_p |