Site Index by Plant Symbol

This script retrieves the site index by plant symbol.

Text highlighted in yellow in the example script can be changed for a particular State and plant symbol. 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 saversion AS Version, saverest AS Date, l.areasymbol AS Area_symbol, l.areaname AS Area_name,

musym AS Map_unit_symbol, mu.muname AS Map_unit_name, mu.mukey AS MUKEY, compname AS Component,

comppct_r AS Component_percentage, cof.plantsym AS Plant_symbol, cof.plantsciname AS Plant_sci_name,

cof.plantcomname AS Common_name, cof.siteindexbase AS Site_base, cof.siteindex_r AS Site_index

FROM sacatalog AS sac

INNER JOIN legend AS l ON l.areasymbol = sac.areasymbol AND l.areatypename = 'Non-MLRA Soil Survey Area'

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

LEFT OUTER JOIN component AS c ON c.mukey = mu.mukey

LEFT OUTER JOIN coforprod AS cof ON cof.cokey = c.cokey

WHERE sac.areasymbol LIKE 'WA%' AND cof.plantsym = 'PSME'

AND majcompflag = 'Yes' AND cof.siteindex_r > 0

Example Table Output

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

Version	Date	Area_symbol	Area_name	Map_unit_symbol	Map_unit_name	MUKEY	Component	Component_percentage	Plant_symbol	Plant_sci_name	Common_name	Site_base	Site_index
11	9/2/2014 7:27:13 PM	WA728	Quinault Indian Reservation, Washington	39	Oyhut complex, 1 to 15 percent slopes	78376	Oyhut	40	PSME	Pseudotsuga menziesii	Douglas-fir	King 1966 (795)	113
11	9/2/2014 7:27:13 PM	WA728	Quinault Indian Reservation, Washington	10	Grehalem silt loam, 0 to 3 percent slopes	78379	Grehalem	90	PSME	Pseudotsuga menziesii	Douglas-fir	King 1966 (795)	130
11	9/2/2014 7:27:13 PM	WA728	Quinault Indian Reservation, Washington	53	Solleks-Kestner complex, 15 to 50 percent slopes	709051	Solleks	50	PSME	Pseudotsuga menziesii	Douglas-fir	King 1966 (795)	115

Helping People Help the Land

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