Hydrologic Soils Group

This script retrieves the Hydrologic soils group for mapunits within an area.

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 areasymbol AS Area_symbol, areaname AS Area_name, mu.mukey AS MUKEY, musym AS Map_unit_symbol,

muname AS Map_unit_name, CASE WHEN localphase IS NULL THEN compname ELSE compname + ', ' + localphase END AS Component_name_and_phase,

comppct_r AS Component_percentage, (mu.muacres*co.comppct_r/100) AS Component_acres, hydgrp AS Hydrologic_Soil_Group

FROM legend AS l

INNER JOIN mapunit AS mu ON l.lkey = mu.lkey AND areasymbol = 'CT600'

INNER JOIN component AS co ON mu.mukey = co.mukey AND majcompflag = 'yes'

ORDER BY areasymbol, musym

Example Table Output

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

Area_symbol	Area_name	MUKEY	Mapu_unit_symbol	Map_unit_name	Component_name_and_phase	Component_percentage	Component_acres	Hydrologic_Soil_Group
CT600	State of Connecticut	285930	10	Raynham silt loam	Raynham	80	1659	C/D
CT600	State of Connecticut	285931	100	Suncook loamy fine sand	Suncook	80	3492	A
CT600	State of Connecticut	285932	101	Occum fine sandy loam	Occum	80	4214	B

Helping People Help the Land

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