December 8, 2021
Fertilizer Recommendation Support Tool (FRST): Building a Database for both Legacy and Future Data
Dr. Sarah Lyons
Research Scholar,
Crop and Soil Sciences
ABSTRACT
As part of the Fertilizer Recommendation Support Tool (FRST) project, the FRST database was developed to collect and preserve U.S. soil test correlation and calibration data. The FRST database, initially built in Microsoft Excel, was developed for soil-test P and K correlation and calibration data, but with enough flexibility to allow for future changes and additions including metadata fields, nutrients, and production systems. Data were collected in both raw and summarized forms from many different sources, including but not limited to journal articles, extension and research bulletins, conference proceedings, dissertations and theses, spreadsheets, and word-processing documents. There were many challenges in developing a database with such a diverse set of data, including the regular need for changes and additions to accommodate legacy, current, and future datasets, a lack of dataset completeness particularly for older studies, and developing clear and consistent nomenclature. The FRST database currently has nearly 1,300 trials representing 17 crops and 34 states. The input and contributions provided by the more than 80 FRST collaborative scientists were instrumental in building the FRST database.