Parent Material-Landform-Texture

This script retrieves the texture of the surface layer, the parent material name and the first landform by State and soil name.

Text highlighted in yellow in the example script can be changed for a particular State and soil name. 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, m.mukey AS MUKEY, musym AS Map_unit_symbol, muname AS Map_unit_name,

comppct_r AS Component_percentage, compname AS Component_name, compkind AS Component_kind,

drainagecl AS Drainage_class, hzname AS Horizon_name, hzdept_r AS Top_depth, hzdepb_r AS Bottom_depth,

om_r AS Organic_matter, sandtotal_r AS Sand, silttotal_r AS Silt, claytotal_r AS Clay,

(SELECT top 1 texture FROM chorizon

LEFT OUTER JOIN chtexturegrp ON chorizon.chkey = chtexturegrp.chkey

WHERE rvindicator = 'yes' AND chorizon.chkey = h.chkey ORDER BY rvindicator DESC) AS Texture,

(SELECT TOP 1 copmgrp.pmgroupname

FROM copmgrp

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

(SELECT TOP 1 cogeomordesc.geomfname

FROM cogeomordesc

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

FROM legend AS l

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

INNER JOIN component AS c ON m.mukey = c.mukey AND Majcompflag='yes' AND compname LIKE 'clarksville'

LEFT OUTER JOIN chorizon AS h ON h.cokey = c.cokey

WHERE hzdept_r = 0 AND l.areasymbol LIKE 'MO%'

AND c.cokey = (SELECT TOP 1 component.cokey FROM component WHERE component.mukey=m.mukey

ORDER BY component.comppct_r DESC)

ORDER BY compname, comppct_r DESC, areasymbol

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_percentage	Component_name	Component_kind	Drainage_class	Horizon_name	Bottom_depth	Organic_matter	Sand	Silt	Clay	Texture	Parent_material	Landform
MO023	2502504	73395	Clarksville very gravelly silt loam, 3 to 8 percent slopes	90	Clarksville	Series	Somewhat excessively drained	Oi	2	50	21.2	67.5	11.3	SPM	slope alluvium over residuum weathered from cherty limestone	interfluves
MO023	2534369	73014	Clarksville very gravelly silt loam, 8 to 15 percent slopes	90	Clarksville	Series	Somewhat excessively drained	A	8	4.5	22	70	8	GRV-SIL	slope alluvium over residuum weathered from dolomite	hillslopes
MO023	2534364	73014	Clarksville very gravelly silt loam, 8 to 15 percent slopes	90	Clarksville	Series	Somewhat excessively drained	A	8	4.5	22	70	8	GRV-SIL	slope alluvium over residuum weathered from dolomite	hillslopes

Helping People Help the Land

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