Summary/Goals: The goal of this project is to develop a web-based, multi-user database and provide geospatial and temporal data to support the data needs for the hydrology related SAHRA research, including scientific results measured or generated by SAHRA researchers. With Geographical Information System (GIS) tools, spatial and temporal patterns of environmental data stored in the enterprise database can be more easily discovered, which is very important for developing local and regional hydrologic models.
Activities and outcomes during past year:
In 2008, we have completed the following tasks:
1. Developed and implemented data tools for automated collection and storing in the database for USGS stream flows, NWS global station data, BofR reservoir data and NRCS snow data. Data are downloaded ones a week for the Colorado basin and ones a month for the Rio Grande basin;
2. Developed and implemented data tools for automated collection and storing in the database for gridded reanalysis data (NARR) used in the VIC, BSWB and HyMOD models. Data are downloaded ones a week for the Colorado and upper Rio Grande basins;
3. Additionally, tools for downloading, processing and analysis of MODIS and GRACE gridded data sets. Aggregated data for selected basins are stored in the database;
4. Design and implementation of the Terrestrial Water Storage Dynamics (TWS) website. The website presents the near real-time TWS data for the Colorado basin computed by two models (VIC and BSWB) interfaced with the database together with the GRACE observed gravity field data;
5. Water quality and chemistry data for the San Pedro, Rio Grande and Jemez River basins were transformed, quality controlled, loaded to the database and metadata were created using ISO 19139 schema;
6. Developed and implemented data web services compatible with the CUAHSI prototype standards (WaterML, ODM and WaterOneFlow). Data web services are part of the SAHRA Geodatabase website and are used to query and access data stored in the database.
7. Testing and implementation of the data access interface is in progress;
8. Published the Downscaled Climate Scenario Data on the SAHRA Geodatabase website.
Plans for the upcoming year:
In 2009, we plan to conduct the following activities:
1. Transform and load data generated by SAHRA research to the database from the Vales Caldera, upper San Pedro, Rio Grande and Colorado River sites.
2. Develop data description (metadata) and complete data quality control for loaded data;
3. Testing and deployment of the SAHRA data access interface (April);
4. Investigation of alternative data sources (MODIS, soil moisture and in-situ meteorological and snow measurements) to improve TWS estimation and prediction;
5. Update of the spatial and temporal data stored in the database.
