In April of 2020, New Castle County (NCCo) Executive Matt Meyer announced a partnership with Biobot Analytics, Inc. to begin regular analysis of county and city of Wilmington wastewater in order to estimate the level of novel coronavirus in the sewer service area. In August, those efforts are being continued through a parternship with the University of Delaware's newly created Center for Environmental and Wastewater-based Epidemiological Research (CEWER). NCCo tasked CompassRed with creating an interactive dashboard for this information (previously presented to the public in an Excel file).
This dashboard was created using R's application framework shiny. Main R packages used are:
tidyverse: data manipulation and transformationleaflet: choropleth map (OpenStreetMap)ggplot2andplotly: bar and trendline chartsshinycssloadersandbsplus: front-end improvementsshinyjs: sending JavaScript to the browser and back to the R server
Additionally, QGIS was used for transforming county shape data (geodatabase format) into .geojson format for use in leaflet mapping.
- Live app running on shinyapps.io
- Raw data
- New Castle County, Delaware (NCCo)
- Biobot Analytics
- University of Delaware's Center for Environmental and Wastewater Epidemiological Research (CEWER)
- CompassRed
Requires .Renviron with LOCAL variable set to TRUE or FALSE