Licensing A project of Ecotrust
Identification_Information Abstract Purpose Supplemental Information Data_Quality_Information Spatial_Data_Organization_Information Entity_and_Attribute_Information Detailed Description Overview Distribution_Information Metadata_Reference_Section
Citation_Information Originator: U.S. Department of Agriculture, Natural Resources Conservation Service Publication Date: 1994 Title: National Map Unit Interpretation Record (MUIR) Database Publication Information Publication Place: Fort Worth, Texas Publisher: U.S. Department of Agriculture, Natural Resources Conservation Service Description Abstract: This data set is a collection of soil and soil-related properties, interpretations, and performance data for a soil survey area and its map units, map unit components, and component layers. This data set has been developed by the National Cooperative Soil Survey and is a dynamic soil information and database. Information contained within the MUIR database have been reviewed and certified in accordance with National Cooperative Soil Survey data quality standards. MUIR data contains about 88 estimated soil physical and chemical properties, interpretations, and performance data. Examples are available water capacity; soil reaction; soil erodibility factors (K, Kf, and T); hydric soil ratings; ponding, flooding, water table depth, and duration; bedrock; interpretations for sanitary facilities, building site development, engineering, cropland, woodland, and recreational development; and yields for common crops, site indices of common trees, and potential production of rangeland plants. Purpose: MUIR depicts information about soil features on or near the surface of the Earth. These data are collected as part of the National Cooperative Soil Survey. Time Period of Content Single Date/Time Calendar Date: 1994 Currentness Reference: publication date Status Progress: Approximately 80 percent of the United States, by county. Maintenance and Update Frequency: Published yearly. Spatial Domain Bounding Coordinates The bounds of the MUIR data are those of individual soil survey areas. In many cases, the soil survey area boundaries correspond with the county boundaries. In other cases, the soil survey areas may comprise only a portion of a county or may comprise an area larger than a single county (e.g. 2 or more counties). A few soil survey areas correspond to some other geopolitical boundary, such as a National Forest or a National Park. Keywords Theme Theme Keyword Thesaurus: None Theme Keyword: Soils Theme Keyword: Attribute data Theme Keyword: Soil properties Theme Keyword: Soil survey Theme Keyword: Interpretations Theme Keyword: Performance data Place Place Keyword Thesaurus: Counties and County Equivalents of the United States and the District of Columbia (FIPS Pub 6-3) Place Keyword: e.g. Virginia Place Keyword Thesaurus: Counties and County Equivalents of the United States and the District of Columbia (FIPS Pub 6-3) Place Keyword: e.g. Roanoke County and the Cities of Roanoke and Salem Access Constraints: None Use Constraints: The U.S. Department of Agriculture, Natural Resources Conservation Service should be acknowledged as the data source in products derived from these data. This data set is not designed for use as a primary regulatory tool in permitting or citing decisions, but may be used as a reference source. This is public information and may be interpreted by organizations, agencies, agencies, units of government, or others, based on needs; however, they are responsible for the appropriate application. Federal, State, or local regulatory bodies are not to reassign to the Natural Resources Conservation Service any authority for the decisions that they make. The Natural Resources Conservation Service will not perform any evaluations of these maps for purposes related solely to State or local regulatory programs. MUIR data should be used in conjuntion with soil survey maps. The soil survey maps indicate the geographic location and extent of the soil map units within the soil survey area. Mapping scales generally range from 1:12000 to 1:31680. The maps meet or exceed the national NRCS mapping specifications. MUIR data are intended to be used by landowners, county and local governments, and other natural resource managers for basic land use planning. It is not intended to be used for site-specific land use suitability determinations, such as approval, siting, and sizing of septic tank absorption fields. The use of these data is not restricted and may be interpreted by organizations, agencies, units of government, or others; however, they are responsible for its appropriate application. Federal, State, or local regulatory bodies are not to reassign to the Natural Resources Conservation Service any authority for the decisions that they make. The Natural Resources Conservation Service will not perform any evaluations of these maps for purposes related solely to state or local regulatory programs. Some of the data elements in the MUIR may contain incomplete or missing data. In some cases, the soil property represented by the data element is not appropriate to the soil survey areas, and has, therefore, been intentially left blank (e.g.gypsuml and gypsumh). In other situations, the data are actively being edited and are incomplete, as of the data of the data download for the National MUIR database. These data files are periodically updated. Files are dated, and users are responsible for obtaining the latest version of the data. Point of Contact (National MUIR) Contact Organization Primary Contact Organization: U.S. Department of Agriculture, Natural Resources Conservation Service Contact Position: Jon D. Vrana, NRCS National Soil Survey Database Coordinator Contact Address Address Type: mailing address Address: Federal Building, Room 152 Address: 100 Centennial Mall North City: Lincoln State or Province: Nebraska Postal Code: 68508-3866 Contact Voice Telephone: 402 437 5423 Contact Facsimile Telephone: 402 437 5336 Contact TDD/TTY: 202 720 7808
Attribute_Accuracy
Attribute Accuracy Report: Attribute accuracy is tested by
automated data validation procedures, including data type,
data length, data range, key data field, and null key fields.
In addition, soil scientists performed manual comparison with
the official published soil survey. In addition, the attributes are
tested against a master set of valid attributes. All attribute data
conform to the attribute codes in the signed classification
and correlation document and amendments and are current as of
the date of download from the State Soil Survey Database, contained
within each state.
Logical Consistency Report: none
Completeness Report:
Most MUIR data exist in the database as a range of soil properties,
depicting the range for the soil survey area. Data are obtained from
a combination of field observations, site descriptions and transects,
and laboratory analyses.
Some of the data elements in the MUIR may contain incomplete or missing
data. In some cases, the soil property represented by the data element
is not appropriate to the soil survey areas, and has, therefore, been
intentially left blank (e.g.gypsuml and gypsumh). In other situations,
the data are actively being edited and are incomplete, as of the date
that the data was downloaded to the National MUIR database.
In making the soil survey, soil scientists observed landforms and
landscape features, such as steepness, length, and shape of slopes;
the general pattern of drainage; the kinds of crops and native plants
growing on the soils; and the kinds of bedrock. They observed and
studied many soil profiles. Samples of some of the soils in the area
are collected for laboratory analyses and for engineering tests. Soil
boundaries were drawn on the soil maps and a locally tailored MUIR
database was constructed, based on these observations and the resulting
landscape model the soil scientist developed.
Specific limits were established on the classification of
soils and the design and name of map units. These limits are
outlined in U.S. Department of Agriculture. 1975. Soil
Taxonomy: A basic system of soil classification for making and
interpreting soil surveys. Soil Conserv. Serv., U.S. Dep.
Agric. Handb. 436.; U.S. Department of Agriculture. 1992. Keys
to Soil Taxonomy. SMSS Technical Monograph No. 19. Soil Surv.
Staff, Soil Conserv. Serv.; U.S. Department of Agriculture.
1993. National Soil Survey Handbook, title 430-VI. Soil Surv.
Staff, Soil Conserv. Serv.; and U.S. Department of
Agriculture. 1993. Soil Survey Manual. Soil Surv. Staff, U.S.
Dep. Agric. Handbook 18.
The actual composition and interpretative purity of the map unit
delineations were based on statistical analyses of field observations
and transect data. Adherence to National Cooperative Soil Survey
standards and procedures is based on peer review, quality control,
and quality assurance. Quality control is outlined in the
memorandum of understanding for the soil survey area and in documents
that reside with the Natural Resources Service state soil scientist.
Four kinds of map units are used in soil survey: consociations,
complexes, associations, and undifferentiated groups.
Consociations - Consociations are named for the dominant soil.
In a consociation, delineated areas are dominated by a single
soil taxon and similar soils. At least one half of the pedons
in each delineation are of the same soil components so similar
to the named soil that major interpretations are not affected
significantly. The total amount of dissimilar inclusions of
other components in a map unit generally does not exceed about
15 percnet if limiting and 25 percent if not limiting. A single
component of a dissimilar limiting inclusion generally does not
exceed 10 percent if very contrasting.
Complexes and associations - Complexes and associations are
named for two or more dissimilar components with the
dominant component listed first. They occur in a regularly
repeating pattern. The major components of a complex cannot
be mapped separately at the scale of about 1:24,000. The
major components of an association can be separated at a
scale of about 1:24,000. In each delineation of either a
complex or an association, each major component is normally
present, though their proportions may vary appreciably from
one delineation to another. The total amount of inclusions
in a map unit that are dissimilar to any of the major
components does not exceed 15 percent, if limiting, and 25
percent, if nonlimiting. A single kind of dissimilar
limiting inclusion usually does not exceed 10 percent.
Undifferentiated Groups - Undifferentiated groups consist
of two or more components that do not always occur together
in the same delineation, but are included in the same named
map unit because use and management are the same or similar
for common uses. Every delineation has at least one of the
major components and some may have all of them. The same
principles regarding proportions of inclusions apply to
undifferentiated groups as to consociations.
Minimum documentation consists of three complete soil profile
descriptions that are collected for each soil added to the
legend, one additional per 3,000 acres mapped; three 10-
observation transects per each map unit, one additional 10-point
transect per 3,000 acres.
A defined standard or level of confidence in the interpretive
purity of the map unit delineations is attained by adjusting
the kind and intensity of field investigations. Field
investigations and data collection are carried out in
sufficient detail to name map units and to identify, accurately
and consistently, areas of about 6 acres.
Adherence to National Cooperative Soil Survey standards
and procedures is based on peer review, quality control, and
quality assurance. Quality control is outlined in documents
that reside with the Natural Resources Conservation Service state
soil scientist.
Positional Accuracy
Horizontal Positional Accuracy
Horizontal Positional Accuracy Report:
Lineage
Source Information
Source Citation
Originator: U.S Department of Agriculture, Natural Resources
Conservation Service
Title: Soil Interpretations Record (SIR)
Geospatial Data Presentation Form: attribute data
Publication Information
Publication Place:
Publisher:
Type of Source Media: electronic files (ASCII, tab-delimited)
Source Currentness Reference: publication date
Source Citation Abbreviation: SCS2
Source Contribution: reference information for
development of map unit interpretation record (MUIR)
data (soil properties for total soil and by soil layer,
for phases of soil series)
Source Citation
Originator: U.S Department of Agriculture, Natural Resources
Conservation Service
Title: Map Unit Use File (MUUF, SOI6)
Geospatial Data Presentation Form: attribute data
Publication Information
Publication Place:
Publisher:
Type of Source Media: electronic files (ASCII, tab-delimited)
Source Currentness Reference: publication date
Source Citation Abbreviation: SCS2
Source Contribution: reference information for
development of map unit interpretation record (MUIR)
data (soil survey area-specific information to tailor
Soil Interpretations Record (SIR) data to reflect local
conditions). Information includes, but is not limited to,
state, soil survey area identification number, soil survey
area name, map unit symbol and name, soil component name,
linkage to the specific SIR records, layer-tailoring criteria,
etc.
Process Step
Process Description: Field procedures for the second order
soil survey are determined by field observations and by
interpretation of remotely sensed data. Boundaries were
verified at closely spaced intervals, and the soils in
each delineation were identified by traversing and
transecting the landscape. Soil scientists described and
sampled the soils, analyzed samples in the laboratory,
and statistically analyzed the data. The classification
and map unit names were finalized at the final correlation,
if the soil survey has been correlated and published. The
information is subject to change prior to final correlation
and publication.
Process Date: e.g. 1990
Source Used Citation Abbreviation: NRCS1
Process Step
Process Description: Soil Interpretation Records (SIR) were
created and edited for each soil in the United States. These
records contain approximately 88 soil and nonsoil properties,
interpretations, and yield and production information, and
represent an aggregation of ranges of properties for everywhere
that the soil is found.
Process Date: 1994
Source Used Citation Abbreviation: NRCS1
Process Step
Process Description: Map Unit Records (SOI-6) were created
and edited for each map unit in every soil survey area in
the United States. Basically, the SOI-6 is a form to query
the SIR database to initially generate a preliminary Map
Unit Interpretation Record (MUIR) database. A national
collection of the SOI-6 records is contained in the Map
Unit Use Files (MUUF) database. The SOI-6 form is used by
the soil scientist to select and tailor the SIR data record
to reflect local soil conditions. Properties tailorable through
this process step include soil surface texture and thickness,
all soil layer thickness, drainage, prime farmland status,
and other selected properties.
Process Date: e.g. 1994.
Source Used Citation Abbreviation: NRCS1
Process Step
Process Description: Map Unit Interpretation Record (MUIR)
data were created for each and every soil survey contained
within the National Map Unit Interpetation Record (MUIR)
database. The creation, editing, error-checking, and
maintenance of the SOI-6 and SIR databases were the responsibility
of the NRCS State Soil Scientist and the State Soil Survey Database
(SSSD) Manager. The processing of the SOI-6 (or MUUF) and SIR
databases and the generation of the MUIR occured at the
Statistical Laboratory, Iowa State University, Ames, Iowa.
Process Date: e.g. 1994.
Source Used Citation Abbreviation: NRCS1
Process Step
Process Description: Map Unit Interpretation Record (MUIR)
data were validated and downloaded in the appropriate pipe-
delimited ASCII file format, utilizing the 1995 NRCS Field
Office Computing System (FOCS) Soil database format. The
validation and downloading software are contained within
within the NRCS State Soil Survey Database (SSSD) software.
Process Date: e.g. 1994.
Source Used Citation Abbreviation: NRCS1
Spatial Data Organization Information
Overview_Description Entity_and_Attribute_Overview: Map Unit Delineations are closed polygons that may be dominated by a single soil or nonsoil component, plus allowable similar or dissimilar soils, or they can be geographic mixtures of groups of soils or soils and nonsoils. The state, soil survey area id symbol, and map unit symbol uniquely identify each closed delineation, map unit and form the key to uniquely link to a map unit name. These set of data elements also form the key for linking information in the Map Unit Interpretations Record tables. Map Unit Delineations are described by the Map Unit Interpretations Record database. This attribute database gives the proportionate extent of the component soils and the properties for each soil. The database contains both estimated and measured data on the physical and chemical soil properties and soil interpretations for engineering, water management, recreation, agronomic, woodland, range and wildlife uses of the soil. The Soil Map Unit Interpretations Record database consist of the following relational tables(found in tabdir directory): codes (database codes) - stores information on all codes used in the database comp (map unit component) - stores information which will apply to a specific component of a soil map unit compyld (component crop yield) - stores crop yield information for soil map unit components ewoodlnd (existing woodland productivity) - store information on common indicator trees for soil map unit components forest (forest understory) - stores information for plant cover as forest understory for soil map unit components hydcomp (hydric soil component information) - stores data and information related to the hydric classification, criteria, landform, etc. inclusn (map unit inclusions) - stores the names of soils included in the soil map units interp (interpretation) - stores soil interpretation ratings (both limitation ratings and suitability ratings) to soil map unit components layer (soil layer) - stores characteristics which apply to soil layers for soil map unit components mapunit (map unit) - stores information which applies to all components of a soil map unit mucoacre (map unit county acres) - stores the number of acres for the map unit within the county muyld (map unit yield) - stores crop yield information for the soil map unit. plantcom (plant composition) - stores plant symbols and percent of plant composition associated with components of soil map units plantnm (plant name) - stores the common and scientific names for plants used in the database pwoodlnd (woodland) - store information on potential indicator trees for soil map unit components rangenm (range name) - stores the range site name. rsprod (range site production) - stores range site production information for soil map unit components sdbcodes (soil database codes) - stores database data dictionary information ssacoac (soil survey area county acreage) - stores the acreage for the county within the boundary of the soil survey area ssarea (soil survey area) - stores information that will apply to an entire soil survey area taxclass (taxonomic classification) - stores the taxonomic classification for soils in the database windbrk (windbreak) - stores information on recommended windbreak plants for soil map unit components wlhabit (wildlife habitat) - stores wildlife habitat information for soil map unit components woodmgt (woodland management) - stores woodland management information for soil map unit components yldunits (yield units) - stores crop names and the units used to measure yield Entity and Attribute Detail Citation U.S. Department of Agriculture. 1975. Soil Taxonomy: A basic system of soil classification for making and interpreting soil surveys. Soil Conserv. Serv., U.S. Dep. Agric. Handb. 436. U.S. Department of Agriculture. 1992. Keys to Soil Taxonomy. SMSS Technical Monograph No. 19. Soil Surv. Staff, Soil Conserv. Serv. U.S. Department of Agriculture. 1993. National Soil Survey Handbook, title 430-VI. Soil Surv. Staff, Soil Conserv. Serv. U.S. Department of Agriculture. 1993. Soil Survey Manual. Soil Surv. Staff, U.S. Dep. Agric. Handbook 18. U.S. Department of Agriculture. 1993. National Soil Survey Handbook, title 430-VI. Soil Surv. Staff, Soil Conserv. Serv. U.S. Department of Agriculture. State Soil Survey Database Data Dictionary. Soil Conserv. Serv. Distribution_Information Distributor Contact Organization Primary Contact Organization: U.S. Department of Agriculture, Natural Resources Conservation Service, National Cartography and GIS Center Contact Address Address Type: mailing address Address: P.O. Box 6567 City: Fort Worth State or Province: Texas Postal Zone: 76115 Contact Voice Telephone: 817 334 5559 Contact Facsimile Telephone: 817 334 5469 Resource Description: National MUIR Database Distribution Liability: Although these data have been processed successfully on a computer system at the U.S Department of Agriculture, no warranty expressed or implied is made by the Agency regarding the utility of the data on any other system, nor shall the act of distribution constitute any such warranty. The U.S. Department of Agriculture will warrant the delivery of this product in computer-readable format, and will offer appropriate adjustment of credit when the product is determined unreadable by correctly adjusted computer input peripherals, or when the physical medium is delivered in damaged condition. Request for adjustment of credit must be made within 90 days from the date of this shipment from the ordering site. The U.S. Department of Agriculture, nor any of its agencies are liable for misuse of the data. It is also not liable for damage, transmission of viruses, or computer contamination through the distribution of these data sets. The U.S. Department of Agriculture prohibits discrimination in its programs on the basis of race, color, national origin, sex, religion, age, disability, political beliefs, and marital or familial status. (Not all prohibited bases apply to all programs.) Standard Order Process Non-digital Form: Not available Digital Form Digital Transfer Information Format Name: ASCII Format Content Information: keys and attributes Transfer Size: 1.6 Digital Form Digital Transfer Information Format Name: ARCE Format Content Information: spatial, keys, and attributes Format Specification: Single precision Transfer Size: Digital Transfer Option Offline Option Offline Media: 8mm cartridge tape Recording Capacity Recording Density: 2.3 Recording Density Units: gigabytes Recording Format: tar Digital Transfer Option Offline Option Offline Media: 1/4-inch cartridge tape Recording Capacity Recording Density: 150 Recording Density Units: megabytes Recording Format: tar Fees: The charge for one data set (CD-ROM) is $50.00. A data set is national coverage with state-wide format and includes only attribute data. Spatial data are not included within the MUIR database. Ordering Instructions: Call or write to organizations listed under Distributor. The Map Unit Interpretations Record attribute soil data are available in variable length, tab delimited, ASCII or ARC Export files upon request. The MUIR data currently are only available on CD-ROM in a pipe-delimited (|) ASCII format without headers. Header files, with data element names and one row of dashes also accompany the data on the CD, but are in separate files. Turnaround: 10 working days Metadata_Reference_Section Metadata Date: 19950817 Metadata Review Date: 19950817 Metadata Future Review Date: 19951001 Metadata Contact Contact Organization Primary Contact Organization: U.S. Department of Agriculture, Natural Resources Conservation Service Contact Position: National Soil Survey Database Coordinator Contact Address Address Type: mailing address Address: Federal Building, Room 152 Address: 100 Centennial Mall North City: Lincoln State or Province: Nebraska Postal Code: 68508-3866 Contact Voice Telephone: 402 437 5423 Contact Facsimile Telephone: 402 437-5336 Metadata Standard Name: Content Standards for MUIR Metadata Metadata Standard Version: 19940608
The NRCS national MUIR database is a collection of soil survey attribute information. The general structural hierarchy of the information is by soil survey area, map units within the survey area, and map unit components within the map unit. To effectively download and use the data, one must understand the basic structure of the relational tables containing this information. Below is a listing of the tables, with a brief description, arranged to show their general relationship. Clicking on a table name will take you to a more detailed description of that table. These attribute tables can be found in the tabdir directory under tualatin/geomorph (one directory down from the location of the data layer).
ssarea -- soil survey area table | ssacoac -- soil survey acreage by county table mapunit -- soil survey map unit table | mucoacre -- map unit acreage by county table | muyld -- map unit crop yields table comp -- map unit components table | layer -- soil profile layers table | compyld -- component crop yields table | interp -- use interpretations table | woodmgt -- woodland management table | ewoodlnd -- existing woodland species table | pwoodlnd -- potential woodland species to plant table | windbrk -- windbreak species table | wlhabit -- wildlife habitat table | rsprod -- range site productivity table | plantcom -- rangeland native plants table | forest -- woodland native plants inclusn -- additional minor components table hydcomp -- hydric soil components table Also included are several lookup tables for decoding information. elements -- contains data element descriptions sdbcodes -- contains database data dictionary lookup lists taxclass -- contains the soil classification yldunits -- contains the units of measure for the crops rangenm -- contains the official range site names and codes plsciname -- contains the scientific plant names plcomname -- contains the common plant names
Notes: An asterisk '*' before a column name indicates that this is a key column for the table, and will be NOT NULL. A data type such as number(4,2) represents a number that has up to four digits, two of which are to the right of the decimal point.
TABLE: comp name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym mapunit symbol char(6) *seqnum sequence number number(2) compname component name char(30) s5id Soils-5 record number char(6) comppct component percent number(3) slopel low slope number(3) slopeh high slope number(3) surftex surface soil texture char(8) otherph class-determining phase criteria char(40) compkind kind of component char(1) compacre component acres number(6) clascode classification code char(20) anflood annual flooding frequency char(5) anflodur annual flooding duration char(11) anflobeg beginning flooding month char(3) anfloend ending flooding month char(3) wtdepl shallowest water table depth number(2,1) wtdeph deepest water table depth number(2,1) wtkind water table kind char(5) wtbeg beginning water table month char(3) wtend ending water table month char(3) pnddepl shallowest ponding depth number(2,1) pnddeph deepest ponding depth number(2,1) pnddur duration of ponding char(11) pndbeg beginning month for ponding char(3) pndend ending month for ponding char(3) rockdepl shallowest bedrock depth number(2) rockdeph deepest bedrock depth number(2) rockhard bedrock hardness char(5) pandepl shallowest cemented pan depth number(2) pandeph deepest cemented pan depth number(2) panhard cemented pan thickness char(5) subinitl initial subsidence (low) number(2) subinith initial subsidence (high) number(2) subtotl total subsidence (low) number(2) subtoth total subsidence (high) number(2) hydgrp hydrologic group char(3) frostact frost action char(8) drainage drainage class char(5) hydric hydric soil rating char(1) corcon concrete corrosivity char(8) corsteel steel corrosivity char(8) clnirr non-irrigated capability class char(1) clirr irrigated capability class char(1) sclnirr non-irrigated capability subclass char(2) sclirr irrigated capability subclass char(2) TABLE: elements name description type -------------------------------------------------------------- *col data element name char(11) *tables database table names char(200) ellabel long data element name char(100) domid domain id char(11) eldesc data element description long TABLE: compyld name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) *cropname cropname char(30) nirryld non-irrigated yield number(6,2) irryld irrigated yield number(6,2) TABLE: ewoodlnd name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) *plantsym plant symbol char(8) *treeseq tree sequence number number(2) sitind site index number(3) woodprod productivity class number(2) TABLE: forest name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) *plantsym plant symbol char(8) plantcov plant ground cover number(3) TABLE: hydcomp name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) condition land condition char(1) landfmlo local landform char(2) hydcrit FSA hydric soils criteria classif. char(20) onsite onsite char(1) TABLE: inclusn name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) inclsoil included soil name char(35) inclpct included soil percent number(2) hydric hydric soil rating char(1) condition land condition char(1) landfmlo local landform char(2) hydcrit fsa hydric soils criteria classif. char(20) onsite onsite char(1) TABLE: interp name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) *grpcode use group number (1-26) char(2) rating rating limitations (1-11) char(2) restct1 restriction one char(2) restct2 restriction two char(2) restct3 restriction three char(2) TABLE: layer name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) *layernum layer number number(2) s5id soils-5 record number char(6) layerid layer identification number number(3) laydepl shallowest layer depth number(2) laydeph deepest layer depth number(2) texture USDA texture string char(26) kfact K erosion factor with rock fragments number(2,2) kffact K erosion factor rock fragments free number(2,2) tfact T erosion factor number(1) weg wind erosion group char(2) inch10l rock fract > 10" (pct) (low) number(2) inch10h rock fract > 10" (pct) (high) number(2) inch3l rock fract 3"-10" (pct) (low) number(2) inch3h rock fract 3"-10" (pct) (high) number(2) no4l sieve #4 pct (low) number(3) no4h sieve #4 pct (high) number(3) no10l sieve #10 pct (low) number(3) no10h sieve #10 pct (high) number(3) no40l sieve #40 pct (low) number(3) no40h sieve #40 pct (high) number(3) no200l sieve #200 pct (low) number(3) no200h sieve #200 pct (high) number(3) clayl clay pct (low) number(3) clayh clay pct (high) number(3) lll liquid limit (low) number(3) llh liquid limit (high) number(3) pil plasticity index (low) number(3) pih plasticity index (high) number(3) unified unified soil classification char(20) aashto AASHTO soil classification char(25) aashind AASHTO group index number(3) awcl available water capacity (low) number(3,2) awch available water capacity (high) number(3,2) bdl moist bulk density (low) number(3,2) bdh moist bulk density (high) number(3,2) oml organic matter (low) number(4,1) omh organic matter (high) number(4,1) phl soil reaction (pH) (low) number(3,1) phh soil reaction (pH) (high) number(3,1) salinl soil salinity (low) number(3) salinh soil salinity (high) number(3) sarl sodium absorption ratio (low) number(3) sarh sodium absorption ratio (high) number(3) cecl cation exchange capacity (low) number(4,1) cech cation exchange capacity (high) number(4,1) caco3l calcium carbonate (low) number(3) caco3h calcium carbonate (high) number(3) gypsuml gypsum pct (low) number(2) gypsumh gypsum pct (high) number(2) perml permeability (low) number(4,2) permh permeability (high) number(4,2) shrinksw shrink-swell potential char(9) wei wind erosion index number(3) TABLE: mapunit name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym mapunit symbol char(6) muname mapunit name char(130) mukind mapunit kind char(1) mlra major land resource area char(4) primfml prime farmland classif. char(1) muacres mapunit acres number(6) TABLE: mucoacre name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *cntycode county (FIPS) code number(3) mucoacre mapunit county acres number(6) TABLE: muyld name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *cropname cropname char(30) nirryld non-irrigated yield number(6,2) irryld irrigated yield number(6,2) TABLE: plantcom name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) *plantsym plant symbol char(8) plantpct composition (pct) number(3) TABLE: plcomname name description type -------------------------------------------------------------- *plantsym plant symbol char(8) *state state code (alpha FIPS) char(2) comname common plant name char(35) TABLE: plsciname name description type -------------------------------------------------------------- *plantsym plant symbol char(8) sciname scientific plant name char(45) TABLE: pwoodlnd name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) *plantsym plant symbol char(8) *treeseq tree sequence number number(2) TABLE: rangenm name description type -------------------------------------------------------------- *rsid range site identification char(10) rsname range site name char(100) TABLE: rsprod name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) *rsid range site identification char(10) rsname range site name char(100) prodfav potential prod, favorable years number(5) prodnorm potential prod, normal years number(5) produnfv potential prod, unfavorable years number(5) TABLE: sdbcodes name description type -------------------------------------------------------------- *domid domain ID char(11) *code database code char(30) codename long name for the code char(140) codedesc narrative description of code long TABLE: ssacoac name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *cntycode county (FIPS) code number(3) cntyname county name char(30) ssacoac SSA county acres number(8) TABLE: ssarea name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) ssaname soil survey area name char(135) ssaacres soil survey area acres number(8) cordate correlation date char(5) status SSA status char(2) edstat SSA editing status char(5) eddate date SSA data edited char(8) TABLE: taxclass name description type -------------------------------------------------------------- *clascode code for the taxonomic classification char(20) class taxonomic classification of the soil char(120) soilordr soil order char(1) suborder suborder char(3) grtgroup great group char(5) subgroup subgroup char(4) partsize particle size char(3) minalogy minalogy char(2) reaction reaction char(2) soiltemp soil temperature char(2) otherfam other family char(2) TABLE: windbrk name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) *plantsym plant symbol char(8) wndbrkht windbreak height number(2) TABLE: wlhabit name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) wlgrain grain & seed char(9) wlgrass grass & legume char(9) wlherb herbaceous plants char(9) wlhard hardwood trees char(9) wlconif coniferous trees char(9) wlshrub shrubs char(9) wlwetplt wetland plants char(9) wlshlwat shallow water char(9) wlopen openland wildlife char(9) wlwood woodland wildlife char(9) wlwet wetland wildlife char(9) wlrange rangeland wildlife char(9) TABLE: woodmgt name description type -------------------------------------------------------------- *state state code (alpha FIPS) char(2) *ssaid soil survey area ID number(3) *musym map unit symbol char(6) *seqnum sequence number number(2) *ordsym ordination symbol char(3) wderosn erosion hazard char(8) wdequip equipment restrictions char(8) wdseed seeding mortality char(8) wdwind windthrow hazard char(8) wdplant plant competition char(8) TABLE: yldunits name description type -------------------------------------------------------------- *cropname common crop name char(30) yldunits units used to record the yield char(9)