Dominant Land Capability Class by Slope Range
This script retrieves the dominant land capability class by slope range in the map unit name and the available water capacity in inches to a depth of 100 cm.
Text highlighted in yellow in the example script can be changed for a particular State and for a particular slope range in 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.areasymbol AS Area_symbol, l.areaname AS Area_name, m.musym AS Map_unit_symbol, m.mukey AS MUKEY,
m.muname AS Map_unit_name, CAST(ROUND((mua.aws0100wta/2.54),2) AS VARCHAR(6)) AS Inches_water_to_100cm, niccdcd AS Dominant_nonir_land_class
FROM legend l
INNER JOIN mapunit m ON l.lkey = m.lkey AND l.areasymbol LIKE
'OH%'
AND m.muname LIKE
'%3 to 8%'
INNER JOIN muaggatt mua ON m.mukey = mua.mukey AND mua.aws0100wta < 9
ORDER BY areaname, m.musym
Example Table Output
Description of tables and columns can be found on this link:
Table and Column Descriptions
|
Area_symbol |
Area_name |
Map_unit_symbol |
MUKEY |
Map_unit_name |
Inches_water_to_100cm |
Dominant_nonir_land_class |
|
OH001 |
Adams County, Ohio |
PtB |
170114 |
Plainfield sand, 3 to 8 percent slopes |
2.45 |
4 |
|
OH013 |
Belmont County, Ohio |
DkB |
537072 |
Dekalb loam, 3 to 8 percent slopes |
2.57 |
2 |
|
OH019 |
Carroll County, Ohio |
BkB |
537963 |
Berks channery silt loam, 3 to 8 percent slopes |
3.45 |
2 |
Helping People Help the Land
USDA is an equal opportunity provider, employer, and lender.