Flooding Acres for STATSGO

This script retrieves the map unit acres for flooded map units.

This script needs to be run in queue because it will exceed the 10,000 row limit.

Text highlighted in yellow in the example script can be changed for 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 m.musym AS Map_unit_symbol, m.muname AS Map_unit_name, m.muacres AS Map_unit_Acres, c.compname AS Component_name,

c.comppct_r AS Component_percentage, (m.muacres*c.comppct_r/100) AS Component_acres, cm.flodfreqcl AS Flooding_class

FROM legend AS l

INNER JOIN mapunit AS m ON m.lkey = l.lkey

LEFT OUTER JOIN component AS c ON c.mukey = m.mukey

LEFT OUTER JOIN comonth AS cm ON cm.cokey = c.cokey

WHERE cm.flodfreqcl IN ('Occasional', 'Very Frequent', 'Frequent', 'Rare', 'Very rare', 'Common') AND l.areasymbol = 'US'

GROUP BY m.mukey, m.musym, m.muname, m.muacres, c.compname, c.comppct_r, cm.flodfreqcl

ORDER BY m.muname, c.compname, c.comppct_r DESC

Example Table Output

Description of tables and columns can be found on this link: Table and Column Descriptions

Map_unit_symbol	Map_unit_name	Map_unit_Acres	Component_name	Component_percentage	Component_acres	Flooding_class
74698	Baylock silt loam, 0 to 3 percent slopes, rarely flooded	1075	Baylock	95	1021	Rare
74698	Baylock silt loam, 0 to 3 percent slopes, rarely flooded	1075	Secesh	3	32	Occasional
76045	Sandbur-Wideman-Relfe complex, 1 to 3 percent slopes, frequently flooded	40	Relfe	25	10	Frequent

Helping People Help the Land

USDA is an equal opportunity provider, employer, and lender.