All Interpretations for One Map Unit in One Area

This script retrieves all the interpretation rating classes and ratings for one map unit in one area.

Text highlighted in yellow in the example script can be changed for a particular area or map unit. 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 DISTINCT areasymbol AS Area_symbol, musym AS Map_unit_symbol, mrulename AS Main_rule_name,

rulename AS Sub_rule_name,ruledepth AS Rule_depth, interphrc AS Rating_Class, interphr AS Rating

FROM legend AS l

INNER JOIN mapunit AS m ON l.lkey = m.lkey

INNER JOIN component AS c ON m.mukey = c.mukey

INNER JOIN cointerp AS ci ON c.cokey = ci.cokey

WHERE c.majcompflag ='yes'

AND l.areasymbol LIKE 'NE109'

AND m.musym LIKE '7050'

ORDER BY mrulename, ruledepth, rulename

Example Table Output

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

Area_symbol	Map_unit_symbol	Main_rule_name	Sub_rule_name	Rule_depth	Rating_class	Rating
NE109	7050	AGR - Pesticide Loss Potential-Leaching	AGR - Pesticide Loss Potential-Leaching	0	Somewhat limited	0.5
NE109	7050	AGR - Pesticide Loss Potential-Leaching	Depth to High Water Table (Leaching)	1	Wetness	0.5
NE109	7050	AWM - Irrigation Disposal of Wastewater	AWM - Irrigation Disposal of Wastewater	0	Somewhat limited	0.857
NE109	7050	AWM - Irrigation Disposal of Wastewater	Flooding > Rare Freq.	1	Flooding	0.6
NE109	7050	AWM - Irrigation Disposal of Wastewater	AWM - Irrigation Disposal of Wastewater	1	Slow water movement	0.857

Helping People Help the Land

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