Productivity Index by Area Symbol

This script retrieves the productivity index in the text notes.

Text highlighted in yellow in the example script can be changed for a particular area symbol. 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,

farmlndcl AS Farm_Class, compname AS First_Component, nirrcapcl + nirrcapscl AS Non_Irrigated_Class, textsubcat AS PI

FROM legend AS l

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

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

AND cokey = (SELECT TOP 1 c.cokey FROM component c WHERE c.mukey=m.mukey ORDER BY c.comppct_r DESC)

LEFT OUTER JOIN mutext AS mt ON mt.mukey = m.mukey

WHERE mapunittextkind LIKE 'miscellaneous notes' AND textcat = 'PI'

ORDER BY 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	Farm_Class	First_Component	Non_Irrigated_Class	PI
Adams County, Ohio	AaA	Aaron silt loam, 0 to 2 percent slopes	1666	All areas are prime farmland	Aaron	2w	72
Adams County, Ohio	AaB	Aaron silt loam, 2 to 6 percent slopes	3227	All areas are prime farmland	Aaron	2e	69
Adams County, Ohio	BkD	Berks silt loam, 15 to 25 percent slopes	4621	Not prime farmland	Berks	4e	45

Helping People Help the Land

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