Areas by National Symbol

This script retrieves all areas where a national map unit is located.

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.nationalmusym AS National_symbol, m.musym AS Local_symbol,

m.muname AS Map_unit_name, l.areasymbol AS Survey_symbol, l.areaname AS Survey_name

FROM legend AS l

INNER JOIN mapunit AS m ON m.lkey=l.lkey AND m.nationalmusym= '2vxq7'

Example Table Output

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

National_symbol	Local_symbol	Map_unit_name	Survey_symbol	Survey_name
2vxq7	73055	Alred-Rueter complex, 15 to 35 percent slopes, very stony	MO023	Butler County, Missouri
2vxq7	73055	Alred-Rueter complex, 15 to 35 percent slopes, very stony	MO187	St. Francois County, Missouri
2vxq7	73055	Alred-Rueter complex, 15 to 35 percent slopes, very stony	MO055	Crawford County, Missouri

Helping People Help the Land

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