Hydric Soil List by State
This scripts retrieves by State a list of soils that have a hydric rating of "yes".
Text highlighted in yellow in the example script can be changed for a particular area, e.g. 'MO123' can be substituted for 'NE109'. Also, you can use wildcards to get the entire State e.g., 'MO%' will extract the state of Missouri. More 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 DISTINCT Compname AS Component_name
FROM legend AS l
INNER JOIN mapunit AS m ON l.lkey = m.lkey
LEFT OUTER JOIN component AS c ON m.mukey = c.mukey
WHERE hydricrating = 'yes' AND LEFT(l.areasymbol,2) LIKE
'WI'
GROUP BY Compname
ORDER BY Compname
Example Table Output
Description of tables and columns can be found on this link:
Table and Column Descriptions
|
Component_name |
|
Ackmore |
|
Adder |
|
Adrain |
Helping People Help the Land
USDA is an equal opportunity provider, employer, and lender.