HOME HELP FEEDBACK SUBSCRIPTIONS ARCHIVE SEARCH TABLE OF CONTENTS		QUICK SEARCH:   [advanced] Author: Keyword(s): Year:  Vol:  Page:

This Article Figures Only Full Text Free Full Text (PDF) Free Alert me when this article is cited Alert me if a correction is posted Services Similar articles in this journal Similar articles in ISI Web of Science Alert me to new issues of the journal Download to citation manager Citing Articles Citing Articles via HighWire Citing Articles via ISI Web of Science (1) Citing Articles via Google Scholar Google Scholar Articles by Ali, I. Articles by Mckinion, J. M. Search for Related Content PubMed Articles by Ali, I. Articles by Mckinion, J. M. Agricola Articles by Ali, I. Articles by Mckinion, J. M. Related Collections Soybean Cotton Crop Models Soil Physics

Agronomic Modeling

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

^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

^* Corresponding author (jiqbal{at}msa-msstate.ars.usda.gov)

Received for publication February 4, 2004. 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.

Abbreviations: CGI, Common Gateway Interface • DBI, database interface • DBMS, database management system • GUI, graphical user interface • HTML, Hypertext Markup Language • K_s, saturated hydraulic conductivity • RDBMS, relational database management system

This article has been cited by other articles:

				L. Bechini and C. O. Stockle Integration of a Cropping Systems Simulation Model and a Relational Database for Simple Farm-Scale Analyses Agron. J., August 10, 2007; 99(5): 1226 - 1237. [Abstract] [Full Text] [PDF]