Crop Yield by Area Symbol

This script retrieves crop yields by area symbol.

Text highlighted in yellow in the example script can be changed for a particular area, or you can use wildcards to get an entire State. 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 areasymbol AS Area_symbol, areaname AS Area_name, l.tabularversion AS Version, musym AS Map_unit_symbol,

m.mukey AS MUKEY, cropname AS Crop, yldunits AS Units, nonirryield_r AS Non_irrigated, irryield_r AS Irrigated

FROM legend AS l

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

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

Example Table Output

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

Area_symbol	Area_name	Version	Map_unit_symbol	MUKEY	Crop	Units	Non_irrigated	Irrigated
TX299	Llano County, Texas	11	BaC	369778	Corn	Bu	65
TX299	Llano County, Texas	11	BaC	369778	Grain sorghum	Bu	55
TX299	Llano County, Texas	11	CaB	369781	Peanuts	Lbs	1200	3000

Helping People Help the Land

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