Count Number of Map Units by Area Symbol
This script counts the number of map units by area symbol for the whole United States
Text highlighted in yellow in the example script can be changed to 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 areasymbol AS Area_symbol, COUNT(musym) as Count_sym
FROM legend AS l
INNER JOIN mapunit AS mu ON mu.lkey = l.lkey AND l.areasymbol <>
'US'
AND l.areatypename = 'Non-MLRA Soil Survey Area'
GROUP BY Areasymbol
ORDER BY Count_sym ASC
Example Table Output
Description of tables and columns can be found on this link:
Table and Column Descriptions
|
Area_symbol |
Count_sym |
|
VA001 |
23 |
|
TN179 |
105 |
|
MO135 |
106 |
Helping People Help the Land
USDA is an equal opportunity provider, employer, and lender.