Map Units by MLRA
This script retrieves a list of map units by the MLRA overlap table.
Text highlighted in yellow in the example script can be changed for a particular MLRA. 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 AS MLRA_symbol, lo.areaname AS MLRA_name, mo.mukey AS MUKEY,
m.musym AS Map_unit_symbol, m.muname AS Map_unit_name, m.muacres AS Area_acres
FROM laoverlap AS lo
INNER JOIN muaoverlap AS mo ON mo.lareaovkey = lo.lareaovkey and lo.areasymbol=
'131A'
AND lo.areatypename='MLRA'
INNER JOIN mapunit AS m ON m.mukey = mo.mukey
ORDER BY m.muname
Example Table Output
Description of tables and columns can be found on this link:
Table and Column Descriptions
|
MLRA_symbol |
MLRA_name |
MUKEY |
Map_unit_symbol |
Map_unit_name |
Area_acres |
|
131A |
Southern Mississippi River Alluvium |
894220 |
86005 |
Acadia silt loam, 0 to 1 percent slopes, rarely flooded |
3483 |
|
131A |
Southern Mississippi River Alluvium |
2500781 |
86001 |
Calhoun silt loam, 0 to 1 percent slopes, occasionally flooded |
60536 |
|
131A |
Southern Mississippi River Alluvium |
577965 |
28B |
Overcup silt loam, 1 to 3 percent slopes |
1301 |
Helping People Help the Land
USDA is an equal opportunity provider, employer, and lender.