README.txt for STATSGO scripts ------------------------------ NOTE: This file is available in HTML format, from URL http://dbwww.essc.psu.edu/doc/statsgo/statsgo_scripts.html. This directory contains scripts for extracting various soil physical and hydraulic properties from the STATSGO database. There are three sets of scripts: o Perl scripts for extracting the properties from the STASTGO data for one state and writing the results for each mapunit to an ASCII file. o Arc/Info AML scripts to define items for INFO tables to receive the data values. o Perl scripts for packing the ASCII-format tables into the binary format needed for ingest by INFO, using the INFO commands SELECT GET COPY The individual scripts are listed below under the soil property to which they apply. For completeness, this directory also includes files used to specify standard layers and soil texture and rock fragment classes. These files are: fragclass.ascii Numeric codes, abbreviations, and names of standard rock-fragment classes. fragtextdef.ascii Standard texture and fragment abbreviations assigned to each STATSGO combined texture and fragment specifier, in format used by scripts. stdlayer.ascii Specification of standard soil layers. stdlayer.dat Standard soil layers, in format used by scripts. textclass.ascii Numeric codes, abbreviations, and names of standard soil-texture classes. INFO table interface -------------------- openinfo.pl This Perl subroutine is used by all the get_ scripts to extract specified data items (fields) form the INFO database records in the STATSGO data sets. Available water capacity ------------------------ get_awc.pl Determine mean available water capacity (AWC) for specified column depths for each mapunit. def_awc_items.aml Define INFO table items for AWC. pack_awc.pl Pack output from get_awc.pl into binary format specified by def_awc_items.pl. Bulk density and porosity ------------------------- get_bd_poros.pl Determine mean bulk density (BD) and porosity for standard layer for each mapunit. def_bd_items.aml Define INFO table items for BD. def_poros_items.aml Define INFO table items for porosity. pack_bd_poros.pl Pack output from get_bd_poros.pl into binary formats specified by AML scripts. Hydrologic soil group percent ---------------------------- get_hsgpct.pl Determine percent of each hydrologic soil group (HSG), and also of all-water components, in each mapunit. def_hsgpct_ Define INFO table items for HSG and water items.aml percent. pack_hsgpct.pl Pack output from get_hsgpct.pl into binary formats specified by def_hsgpct_items.aml. Permeability rate ----------------- get_perm.pl Determine mean permeability rate for each standard layer of each mapunit. def_perm_items.aml Define INFO table items for soil permeability. pack_perm.pl Pack output from get_perm.pl into binary format specified by def_perm_items.aml. pH -- get_ph.pl Determine mean pH for each standard layer of each mapunit. def_ph_items.aml Define INFO table items for pH. pack_ph.pl Pack output from get_ph.pl into binary format specified by def_ph_items.aml. Plasticity index ---------------- get_plast.pl Determine mean plasticity index for each standard layer of each mapunit. def_plast_items.aml Define INFO table items for plasticity index. pack_plast.pl Pack output from get_plast.pl into binary format specified by def_plast_items.aml. Rock volume percent ------------------- get_rockvol.pl Determine percent by volume of rock fragments in each standard layer of each mapunit. def_rockvol_ Define INFO table items for rock volume. items.aml pack_rockvol.pl Pack output from get_rockvol.pl into binary format specified by def_rockvol_items.aml. Soil erodibility factor ----------------------- get_kfact.pl Determine soil erodibility factors (KFACT and KFFACT) for each standard layer of each mapunit. def_kfact_items.aml Define INFO table items for soil erodibiltiy. pack_kfact.pl Pack output from get_kfact.pl into binary format specified by def_kfact_items.aml. Soil fractions (sand/silt/clay) ------------------------------- get_fract.pl Determine percent of sand, silt, and clay in each standard layer of each mapunit. def_fract_items.aml Define INFO table items for soil fractions. pack_fract.pl Pack output from get_fract.pl into binary format specified by def_fract_items.aml. Soil texture, rock fragments, and depth to bedrock -------------------------------------------------- get_fragtext.pl Determine dominant texture and rock fragment class for each standard layer, and also mean depth to bedrock, for each mapunit. def_rockfrag_ Define INFO table items for dominant rock items.aml fragment class abbreviations and numeric codes for each standard layer. def_soiltext_ Define INFO table items for dominant soil items.aml texture class abbreviations and numeric codes for each standard layer. pack_fragtext.pl Pack output from get_fragtext.pl into binary formats specified by AML scripts. The INFO tables for rock fragment and soil texture classes each include mean depth to bedrock as one item.