Prairie Hills Soils Consulting
Interpreting soils information from the USDA Soils Database to meet customer's planning needs for urban and farming uses since 1980
Kansas Land Capability Class
Custom SQL design
Consulting Services
Assisting customers in developing SQL queries to mine soil properties and soil interpretations to meet customer demands.
 
Assisting customers in understanding soil properties and building soil interpretations to meet their needs.
Weighted Average Clay Content
Here is an example of the map unit weighted average for clay content across the US
Drainage Class
And example of the USDA Drainage Class for the dominant component of the map unit across the US
Hydrologic Soil Group
The Engineering Hydrologic Soil Group interpretation as presented for the dominant component within the map unit across the US
SQL examples
  1. Generic County SQL
    SELECT FROM (mapunit INNER JOIN ((legend INNER JOIN laoverlap ON legend.lkey = laoverlap.lkey and laoverlap.areatypename ='County Or Parish' and LEFT(legend.areasymbol, 1) like '[A-N]') INNER JOIN muaoverlap ON laoverlap.lareaovkey = muaoverlap.lareaovkey) ON mapunit.mukey = muaoverlap.mukey) INNER JOIN component c ON mapunit.mukey = c.mukey and c.cokey = (SELECT TOP 1 component.cokey FROM component WHERE component.mukey=mapunit.mukey ORDER BY component.comppct_r DESC) INNER JOIN chorizon ch ON c.cokey=ch.cokey and hzdept_r = (select MIN(hzdept_r) FROM chorizon WHERE hzname != 'O%' and chorizon.cokey = ch.cokey) INNER JOIN chtexturegrp on ch.chkey=chtexturegrp.chkey and rvindicator = 'yes' INNER JOIN chtexture on chtexture.chtgkey=chtexturegrp.chtgkey ORDER BY laoverlap.areasymbol, mapunit.musym, c.comppct_r DESC
  2. Generic Horizon Level Data
    select areasymbol, areaname, m.mukey, musym, muname, muacres, comppct_r, compname, compkind, texdesc, hzname, hzdept_r, hzdepb_r, kffact, kwfact, om_r from legend l inner join mapunit m on l.lkey=m.lkey and areasymbol like 'IL007' inner join component c on m.mukey=c.mukey and c.cokey = (SELECT TOP 1 component.cokey FROM component WHERE component.mukey=m.mukey ORDER BY component.comppct_r DESC) INNER JOIN chorizon ch ON c.cokey = ch.cokey and hzdept_r = (select MIN(hzdept_r) FROM chorizon WHERE hzname not like 'O%' and chorizon.cokey = ch.cokey ) INNER JOIN chtexturegrp on ch.chkey=chtexturegrp.chkey and rvindicator = 'yes' ORDER by mukey
Structured Query Language is used to mine the information from the USDA Soils Database
Foremost authority in mining soil information from the USDA NRCS soils publication database 
Providing an extensive consultation with clients to explain the information contained in the USDA Soils Database and how it can be used to assist customers in broad land use planning.  Contact me to see how my expertise can assist your teams in wise planning using the USDA NRCS web soil survey, soil data mart, soil data access, and GIS tools.