About Us | Help Videos | Contact Us | Subscriptions



This article in AJ

  1. Vol. 96 No. 6, p. 1706-1710
    Received: Feb 4, 2004

    * Corresponding author(s): jiqbal@msa-msstate.ars.usda.gov
Request Permissions


Soil Physical Properties Web Database for GOSSYM and GLYCIM Crop Simulation Models

  1. Ishtiaq Alia,
  2. Frank D. Whislera,
  3. Javed Iqbal *b,
  4. Johnie N. Jenkinsc and
  5. James M. Mckinionc
  1. a Dep. of Plant and Soil Sci., Mississippi State Univ., Box 9555, Mississippi State, MS 39762
    b Dep. of Agric. and Biol. Eng., Mississippi State Univ., Mississippi State, MS 39762
    c USDA-ARS Genet. and Precis. Agric. Unit, Mississippi State, MS 39762


Knowledge of soil physical properties is needed for various kinds of environmental studies, including crop simulation where the intended users are agronomists, consultants, and growers. However, acquiring and tabulating a complete set of soils analysis data for a particular region is expensive and laborious. This paper describes the construction of a web-based soil physical properties database to meet data requirements of users of cotton (Gossypium hirsutum L.) and soybean [Glycine max (L.) Merr.] crop simulation models (GOSSYM and GLYCIM, respectively) in addition to providing a generic data file of soil physical properties. The data are comprised of undisturbed samples of 1074 soil horizons (or about 300 sample sites) collected from farmers' fields using a tractor-mounted hydraulic probe. Standard laboratory analyses were performed to determine the various soil physical properties. An Oracle8 relational database management system was designed and implemented to store and deliver the soil physical properties using a client/server approach. A Perl database interface was used for the server-side database connectivity to build the soil files. The database accepts queries on several attributes, including sampling location, soil series name, state, county, farm, etc. This web-based database of soil physical properties was successfully implemented and tested and is available online at www.msstate.edu/~ia3/ (verified 11 Aug. 2004) without any restriction of identification or password.

  Please view the pdf by using the Full Text (PDF) link under 'View' to the left.

Copyright © 2004. American Society of AgronomyAmerican Society of Agronomy