Parent Material-Landform by Area Symbol

This script retrieves the top parent material group name for the first landform by area symbol.

Text highlighted in yellow in the example script can be changed for a particular area; e.g., 'NE109' can be substituted for 'MO123'. Also, you can use wildcards to get the entire State; e.g., 'MO%' will extract the whole 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

legend.areasymbol AS Area_symbol,

mapunit.mukey AS MUKEY,

mapunit.musym AS Map_unit_symbol,

mapunit.muname AS Map_unit_name,

component.comppct_r AS Component_percent,

component.compname AS Component_name,

component.compkind AS Component_kind,

component.drainagecl AS Drainage_class,

(SELECT TOP 1 copmgrp.pmgroupname

FROM copmgrp

WHERE component.cokey = copmgrp.cokey AND copmgrp.rvindicator='yes') AS Parent_material,

(SELECT TOP 1 cogeomordesc.geomfname

FROM cogeomordesc

WHERE component.cokey = cogeomordesc.cokey AND cogeomordesc.rvindicator='yes' AND cogeomordesc.geomftname = 'Landform') AS Landform

FROM legend

INNER JOIN mapunit ON legend.lkey = mapunit.lkey AND legend.areasymbol= 'MO123'

INNER JOIN component ON mapunit.mukey = component.mukey

ORDER BY mapunit.muname

Example Table Output

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

Area_symbol	MUKEY	Map_unit_symbol	Map_unit_name	Component_percent	Component_name	Component_kind	Drainage_class	Parent_material	Landform
MO123	2501691	73156	Alred-Gepp complex, 8 to 15 percent slopes, stony	5	Rueter	Series	Somewhat excessively drained	slope alluvium over residuum weathered from dolomite	ridges
MO123	2501209	77008	Taumsauk-Irondale-Rock outcrop complex, 15 to 45 percent slopes, extremely stony	21	Rock outcrop	Miscellaneous area			mountain slopes
MO123	2501198	77006	Roselle silt loam, 3 to 8 percent slopes	96	Roselle	Series	Moderately well drained	slope alluvium over residuum weathered from granite	mountain slopes

Helping People Help the Land

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