This item represents the SSURGO schema of the CRdb database used in development, and still in use by some "production" services located on staging ports at CSU. Therefore, do NOT delete this schema from the "Conservation Resources" databases located on the bare-metal and VM SQL Servers.
- This Schema is no longer in use at NRCS, as of 19 January 2017.
- This schema is an 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 entirely at CSU.
- Copies of this schema are currently deployed and in use by clients at 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 |