This repo accompanies the publication "Low-Cost, Open Source Wireless Sensor Network for Real-Time, Scalable Groundwater Monitoring" and contains all the scripts necessary to build an interactive web dashboard for a groundwater observatory.
As an example, please see the Cosumnes River Groundwater Observatory, a project of UC Water.
The clean folder contains scripts that are automatically run every day at 04:00:00 UTC. Together these scripts:
- extract data from Solinst hardware
- clean and transform the data (i.e. - adjust for reference elevation, baromaetric pressure)
- generate a report of remaining battery life and recent monitoring well data and email that report to a contact list
- push a clean version of the database to the cloud
- save versions of the database every 7 days to the cloud
The dashboard folder contains (among other files), the three files comprising an R Shiny App:
global.Rserver.Rui.R
Together, these files build the web dashboard.
We use the open source version of Shiny Server to host the app, which can take place on a cloud computing environment of your choice (e.g., AWS, Azure, Google Cloud).
Project specific note to a future maintainer: Log in at https://shiny.lawr.ucdavis.edu/rstudio/, and note that the app files are located at /srv/shiny-server/gw_obs.
This work is licensed under a Creative Commons Attribution 4.0 International License.
If you aim to set of a monitoring well network of your own, this software is free to use for commercial and non-commercial purposes. Please reference this work in your derivative products.
You will need a skilled R programmer familiar with Shiny to integrate your hardware with this software.
The log.md file in the main directory is a daily log of activities during the process of building the app and contains valuable insights for those following in these footsteps.