Single Interpretation rating of Map Units by State
This script retrieves the interpretation rating for a single interpretation for the dominant component in Missouri.
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 l.areasymbol AS Area_symbol, m.musym AS Map_unit_symbol, m.mukey AS MUKEY, c.compname AS Component_name, c.comppct_r AS Component_percent, ci.mrulename AS Rule_name, interplr AS Rating, interplrc AS Rating_class
FROM legend AS l
INNER JOIN mapunit AS m ON l.lkey = m.lkey AND l.areasymbol LIKE
'MO%'
INNER JOIN component AS c ON m.mukey = c.mukey AND c.majcompflag='yes' AND c.cokey = (SELECT TOP 1 c2.cokey FROM component AS c2 WHERE c2.mukey=m.mukey
ORDER BY c2.comppct_r DESC )
INNER JOIN cointerp AS ci ON c.cokey = ci.cokey AND ci.ruledepth=0 AND mrulename = 'FOR - Black Walnut Suitability Index (MO)'
ORDER BY musym
Example Table Output
Description of tables and columns can be found on this link:
Table and Column Descriptions
|
Area_symbol |
Map_unit_symbol |
MUKEY |
Component_name |
Component_percent |
Rule_name |
Rating |
Rating_class |
|
MO173 |
67060 |
2575455 |
Landes |
90 |
FOR - Black Walnut Suitability Index (MO) |
0.797 |
Moderately suited |
|
MO037 |
10000 |
2521021 |
Arisburg |
90 |
FOR - Black Walnut Suitability Index (MO) |
0.549 |
Somewhat suited |
|
MO073 |
67095 |
2575513 |
Racoon |
85 |
FOR - Black Walnut Suitability Index (MO) |
0 |
Unsuited |
Helping People Help the Land
USDA is an equal opportunity provider, employer, and lender.