Agronomic data: advances in documentation and protocols for exchange and use

Abstract Data from agronomy experiments are typically collected and stored in a number of minimally documented computer files, with additional information being entered and archived in field books or diaries. Data manipulation is generally cumbersome and error-prone, and data loss is frequent. Modern database technology has the potential to resolve these issues. However, experience gained by an international network of experimenters and crop modellers (the International Benchmark Sites Network for Agrotechnology Transfer; IBSNAT) in using a database for agronomic experiments conducted by many workers at different sites highlighted problems of data entry, quality control, and changing requirements for storage and output variables. In an attempt to minimize these problems, IBSNAT reduced its focus on a central database, but considerably enhanced its effort on the design and use of a set of simple, standard experiment documentation and results files that could be established and edited easily, transferred directly among workers, used as inputs to analytical software and crop models, and read by database and spreadsheet software. The standard files which were developed, and which were used in a software package termed DSSAT V3, have recently been upgraded by a consortium of experimenters and modellers (the International Consortium for Agricultural Systems Applications; ICASA). These new files are described briefly here. The ICASA files constitute an advance in the potential for good documentation and storage of agronomic data, but only partly solve the problem of overall data management and use. There is still need for central and local databases that facilitate both the searching of information from different experiments, and the examination of relationships that may be apparent in a large array of data. A number of such databases have been developed for specific applications, and a few of these are briefly touched upon. In particular, recent work with one large database currently being developed by a number of international Agricultural Research Centers, National Research Organizations, and Universities, (the International Crop Information System, ICIS), is briefly described.

[1]  R. Kent Crookston,et al.  Mycorrhizae: Possible Explanation for Yield Decline with Continuous Corn and Soybean , 1992 .

[2]  John V. Carlis,et al.  A Database for Agroecological Research Data: I. Data Model , 1999 .

[3]  F. Ewert,et al.  The effects of climatic variation in Europe on the yield response of spring wheat cv. Minaret to elevated CO2 and O3: an analysis of open-top chamber experiments by means of two crop growth simulation models , 1999 .

[4]  Graeme L. Hammer,et al.  APSIM: a novel software system for model development, model testing and simulation in agricultural systems research , 1996 .

[5]  V. Barnett,et al.  Testing winter wheat simulation models' predictions against observed UK grain yields , 1998 .

[6]  Will Steffen,et al.  Global change and terrestrial ecosystems , 1996 .

[7]  James W. Jones,et al.  An international collaborative network for agricultural systems applications (ICASA) , 2001 .

[8]  B. D. Soane,et al.  Soil compaction in crop production , 1994 .

[9]  James W. Jones,et al.  Decision support system for agrotechnology transfer: DSSAT v3 , 1998 .

[10]  B. D. Soane,et al.  Soil compaction problems in world agriculture. , 1994 .

[11]  R. Engel,et al.  Critical tissue concentration and chloride requirements for wheat , 1998 .

[12]  James W. Jones,et al.  Systems approaches for the design of sustainable agro-ecosystems , 2001 .

[13]  G. Hoogenboom,et al.  Understanding Options for Agricultural Production , 1998, Systems Approaches for Sustainable Agricultural Development.

[14]  John V. Carlis,et al.  A database for agroecological research data : II. A relational implementation , 1999 .

[15]  O. K. Chung,et al.  Relational Database System for Summarization and Interpretation of Hard Winter Wheat Regional Quality Data , 1999 .

[16]  P. Vijaya Kumar,et al.  Radiation and water use efficiencies of rainfed castor beans (Ricinus communis L.) in relation to different weather parameters , 1996 .

[17]  P. N. Fox,et al.  Integrating research on genetic resources with the international wheat information system , 1997 .

[18]  J. Goudriaan.  Predicting crop yields under global change. , 1996 .

[19]  M. S. Townsend,et al.  The ALFALFA CATALOG software package , 1994 .

[20]  H. J. W. Mutsaers,et al.  Are Simulation Models Ready for Agricultural Research in Developing Countries , 1999 .

[21]  K. Boote,et al.  Physiology and modelling of traits in crop plants: implications for genetic improvement , 2001 .

[22]  Rattan Lal,et al.  Axle load and tillage effects on crop yields on a Mollic Ochraqualf in Northwest Ohio , 1996 .

[23]  Brian Keating,et al.  Approaches to modular model development , 2001 .

[24]  J. Porter,et al.  A comparison of the models AFRCWHEAT2, CERES-Wheat, Sirius, SUCROS2 and SWHEAT with measurements from wheat grown under drought , 1998 .

[25]  D. K. Mulitze.  AGROBASE/4: A Microcomputer Database Management and Analysis System for Plant Breeding and Agronomy , 1990 .