Parent Material by Area Symbol

This script retrieves the parent material group name and its component parts by area symbol.

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, musym AS Map_unit_symbol, m.mukey AS MUKEY, c.cokey AS COKEY, compname AS Component_name,

comppct_r AS Component_percent, pmgroupname AS Parent_material, pmorder AS Parent_material_order, pmmodifier AS Texture_modifer,

pmgenmod AS General_modifier, pmkind AS Kind, pmorigin AS Origin

FROM legend AS l

INNER JOIN mapunit AS m ON l.lkey=m.lkey AND l.areasymbol LIKE 'NV767'

INNER JOIN component AS c ON m.mukey=c.mukey AND compkind = 'series'

LEFT OUTER JOIN copmgrp AS cpg ON c.cokey = cpg.cokey AND cpg.rvindicator='yes'

LEFT OUTER JOIN copm AS cpm ON cpg.copmgrpkey=cpm.copmgrpkey

ORDER BY areasymbol, musym, comppct_r DESC, pmorder ASC

Example Table Output

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

Area_symbol	Map_unit_symbol	MUKEY	COKEY	Component_name	Component_percent	Parent_material	Parent_material_order	Kind	Origin
NV767	010	478720	14293345	Boulflat	60	residuum and colluvium derived from mixed rocks, loess and volcanic ash		Residuum	Mixed
NV767	430	2928264	14295186	Graley	35	colluvium over residuum weathered from andesite	1	Colluvium
NV767	430	2928264	14295186	Graley	35	colluvium over residuum weathered from andesite	2	Residuum	Andesite

Helping People Help the Land

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