Group of Interpretation Ratings for Map Units by Area Symbol
This script retrieves the rating for any lawn interpretation by area symbol. It retrieves all major components.
Text highlighted in yellow in the example script can be changed for a particular area or particular interpretation. Run the "list of Interpretations" script to find the list of Interpretations that are in your area. 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 page.
Soil Data Access Query site
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, c.majcompflag AS Major_Component,
ci.mrulename AS Rule_name, ci.ruledepth AS Rule_depth, 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
'MO123'
INNER JOIN component AS c ON m.mukey = c.mukey AND c.majcompflag='yes'
INNER JOIN cointerp AS ci ON c.cokey = ci.cokey AND ci.ruledepth=0 AND mrulename LIKE
'%lawn%'
ORDER by m.musym, c.comppct_r
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 |
Major_Component |
Rule_name |
Rule_depth |
Rating |
Rating_class |
|
MO123 |
73055 |
2501597 |
Rueter |
35 |
Yes |
ENG - Lawn, Landscape, Golf Fairway |
0 |
1 |
Very limited |
|
MO123 |
73267 |
2502210 |
Scholten |
20 |
Yes |
ENG - Lawn, Landscape, Golf Fairway |
0 |
0.88 |
Somewhat limited |
|
MO123 |
99006 |
2501255 |
Psamments |
90 |
Yes |
ENG - Lawn, Landscape, Golf Fairway |
0 |
1 |
Very limited |
Helping People Help the Land
USDA is an equal opportunity provider, employer, and lender.