To extract soil data needed for building a PLET model from NRCS's Soil Data Access web-based custon query interface, paste the SQL query below into the query box at https://sdmdataaccess.nrcs.usda.gov/ To modify this query to get data for another area, replace 'Hamilton County, Ohio' with the name of the desired 'soil survey area' and state. SQL Query begins on the next line: SELECT l.areaname, musym, muname, muacres, mu.mukey, compname, hydgrp, hzdept_r, hzdepb_r, cht.texture, kwfact FROM legend l INNER JOIN mapunit mu ON mu.lkey = l.lkey LEFT JOIN component c ON c.mukey = mu.mukey LEFT JOIN chorizon ch ON ch.cokey = c.cokey LEFT JOIN chtexturegrp cht ON cht.chkey = ch.chkey WHERE l.areaname LIKE 'Hamilton County, Ohio' AND majcompflag = 'Yes' AND cht.rvindicator = 'yes' AND c.cokey = (SELECT TOP 1 c.cokey FROM component c WHERE c.mukey=mu.mukey AND compkind NOT LIKE 'miscellaneous area' ORDER BY c.comppct_r DESC) ORDER BY l.areaname, musym, compname, hzdept_r