Land Capbability Class by Soil Name

This script retrieves the land capability class by the component name.

Text highlighted in yellow in the example script can be changed for a particular State and soil name. Examples can be found on the Tips page.

Tips Page

Copy the example script below and paste it into the query page on the Soil Data Access site.

Soil Data Access Query Page

Example Script

SELECT l.areaname AS Area_name, musym aS Map_unit_symbol, muname AS Map_unit_name, muacres AS Acres, m.mukey AS MUKEY,

compname AS Component, taxclname AS Taxonomy, (nirrcapcl + nirrcapscl) AS Non_irrigated_capability_class, farmlndcl AS Farm_land_class

FROM legend AS l

INNER JOIN mapunit AS m ON m.lkey = l.lkey AND areasymbol LIKE 'OH%'

INNER JOIN component AS c ON c.mukey = m.mukey AND majcompflag LIKE 'yes'

AND compname IN ('Martisco', 'McGuffey', 'Olentangy', 'Risingsun', 'Roundhead')

ORDER BY compname, areasymbol, musym

Example Table Output

Description of tables and columns can be found on this link: Table and Column Descriptions

Area_name	Map_unit_symbol	Map_unit_name	Acres	MUKEY	Component	Taxonomy	Non_irrigated_capability_class	Farm_land_class
Logan County, Ohio	Ma	Martisco mucky silt loam	359	171131	Martisco	Fine-silty, carbonatic, mesic Histic Humaquepts	4w	Farmland of local importance
Williams County, Ohio	Ma	Martisco muck	116	168175	Martisco	Fine-silty, carbonatic, mesic Histic Humaquepts	3w	Not prime farmland
Hardin County, Ohio	Mc	McGuffey muck	2946	168946	McGuffey	Fine, illitic, calcareous, mesic Histic Humaquepts	3w	Prime farmland if drained

Helping People Help the Land

USDA is an equal opportunity provider, employer, and lender.