Mast head image

Crop Yields by Land Capability Class

This script retrieves the low, RV, and high yield by land capability class.


Text highlighted in yellow in the example script can be changed for a particular State, crop, or land capability class. 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.areasymbol AS Area_symbol, l.areaname AS Area_name, musym AS Map_unit_symbol, muname AS Map_unit_name,

m.mukey AS MUKEY, cropname AS Crop, nonirryield_l AS Low_yield, nonirryield_r AS RV_yield, nonirryield_h AS High_yield, yldunits AS Units

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 nirrcapcl IN ('5', '6','7','8')

LEFT OUTER JOIN mucropyld AS mc ON mc.mukey = m.mukey

WHERE (cropname LIKE 'corn' OR cropname LIKE 'soybeans' OR cropname LIKE '%wheat%')

ORDER BY areasymbol, musym

Example Table Output

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

Area_symbol Area_name Map_unit_symbol Map_unit_name MUKEY Crop Low_yield RV_yield High_yield Units
OH005 Ashland County, Ohio CkD Chili and Conotton gravelly loams, 12 to 18 percent slopes 288150 Winter wheat 26 Bu
OH113 Montgomery County, Ohio MnD3 Miamian-Losantville clay loams, 12 to 18 percent slopes, severely eroded 1590115 Corn 60 60 60 Bu
OH113 Montgomery County, Ohio MnD3 Miamian clay loam, shallow to dense till substratum, 12 to 18 percent slopes, severely eroded 170280 Soybeans 22 22 22 Bu



Helping People Help the Land

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