To put both the public and local area datasets at the fingertips of investigators, we created the HydroDaVE (Hydrologic Database and Visual Explanations) managed service platform to store and serve local area data and combine them on the fly with data from public data portals.
HydroDaVE consists of three major components: (1) HydroDaVE Server with established web services to serve hydrologic, hydrogeologic, and climatic data that are stored in SQL databases; (2) HydroDaVE Manager (HDM) to remotely manage datasets on the HydroDaVE Server; and (3) HydroDaVE Explorer (HDX), a cloud-connected application with an intuitive map-based interface to visualize and analyze the data (e.g., multiple time-series charts, Piper and Stiff diagrams, geological cross-sections), and to create reports. Both HDM and HDX communicate with the HydroDaVE Server via the web services, which in turn interact with the backend SQL databases.
In addition to the localized data stored on the HydroDaVE Server, HDX can concurrently visualize time series data from the USGS Water Services and the Water Quality Portal of the NWQMC. Moreover, HDX visualizes a great number of gridded climatic datasets, including precipitation, daily minimum and maximum temperature from PRISM (OSU), NEXRAD (NWS), and CMIP3/CMIP5 (IPCC).
HydroDaVE is implemented at watershed-scale and provides integration of a variety of resource data. HydroDaVE is used by government agencies to manage their data and perform complex calculations. This paper provides an overview of the HydroDaVE design and examples of how HydroDaVE has been implemented in Southern California and subsequently used to design monitoring programs, resolve disputes regarding sources of contamination, and a groundwater model application.