Map Units by County or State
This script retrieves a list of map units by the county symbol from the overlap tables but can be changed to include the whole state.
Text highlighted in yellow in the example script can be changed for a particular soil survey area code or the whole 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 lo.areasymbol County_symbol, lo.areaname AS County_name, m.mukey AS MUKEY,
m.musym AS Map_unit_symbol, m.muname AS Map_unit_name, mo.areaovacres AS Area_acres, farmlndcl AS Farm_class
FROM legend AS l
INNER JOIN laoverlap AS lo ON l.lkey = lo.lkey AND lo.areatypename='County or Parish'
AND lo.areasymbol LIKE
'IL001'
INNER JOIN muaoverlap AS mo ON lo.lareaovkey = mo.lareaovkey
INNER JOIN mapunit AS m ON mo.mukey = m.mukey AND l.lkey = m.lkey
ORDER BY m.musym
Example Table Output
Description of tables and columns can be found on this link:
Table and Column Descriptions
|
County_symbol |
County_name |
MUKEY |
Map_unit_symbol |
Map_unit_name |
Area_acres |
Farm_class |
|
IL001 |
Adams |
2378671 |
1070A |
Beaucoup silty clay loam, undrained, 0 to 2 percent slopes, occasionally flooded |
1315 |
Not prime farmland |
|
IL001 |
Adams |
2378564 |
6B2 |
Fishhook silt loam, 2 to 5 percent slopes, eroded |
1501 |
Farmland of statewide importance |
|
IL001 |
Adams |
2378575 |
17A |
Keomah silt loam, 0 to 2 percent slopes |
11046 |
Prime farmland if drained |
Helping People Help the Land
USDA is an equal opportunity provider, employer, and lender.