1a.Objectives (from AD-416):
To develop and implement a database management system (DBMS) and applications for the ARS-USDA Grazinglands Research Laboratory (GRL) to store, provide data quality assessment and visualization tools, and serve as the interface for STEWARDS, GRACENET, and MESONET data migration for the purpose of enhancing research capabilities in natural resource conservation.
1b.Approach (from AD-416):
Skills in database design and implementation, data manipulation and visualization, and statistics will be used for this project. Knowledge of Delphi and Java programming will be used to develop supporting applications. A structured query language (SQL) database will be designed and implemented under PostgreeSQL or MySQL. This DBMS should be able to allow for data migration with STEWARDS and GRACENET, and from MICRONET. Other source of data such as USGS stream gage data may be incorporated in future developments. Windows and Web applications will be implemented as the DBMS interface to provide data quality assessment tools and data visualization, and to assist with data input and migration.
This project was initiated in late June. Data has been prepared, formatted, and uploaded into the STEWARDS database. New data evaluation tools were developed, implemented, and used to provide additional screening and quality assurance of the data uploaded into STEWARDS. The data evaluation tools will be showcased at the annual meeting of the Soil and Water Conservation Society in Fort Worth, TX, July 2012.