Productivity Index in Notes for Ponded Map Units by Area Symbol
This script retrieves the acres, farm class, land capability, class and productivity index for ponded map units.
Text highlighted in yellow in the example script can be changed for a particular State and for part of the map unit 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,
farmlndcl AS Farm_Class, compname AS Component, slope_l AS Low_slope, 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
'OH%'
INNER JOIN mutext AS mt ON mt.mukey = m.mukey AND muname LIKE
'%ponded%'
AND mapunittextkind LIKE 'miscellaneous notes' AND textcat = 'PI'
INNER JOIN component AS c ON c.mukey = m.mukey AND majcompflag LIKE 'Yes'
ORDER BY slope_l, 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 |
Component |
Low_slope |
Non_Irrigated_Class |
PI |
Sandusky County, Ohio |
Tp |
Toledo silty clay loam, ponded |
3064 |
Not prime farmland |
Toledo |
0 |
4w |
56 |
Helping People Help the Land
USDA is an equal opportunity provider, employer, and lender.