Published December 6, 2022
| Version 1.0.0
Dataset
Open
Real-Time Sensor Network of Detroit Green Infrastructure: Datasets and Code
Description
- MonitoredRainGardens_PaperTable.xlsx: Excel spreadsheet where the "Garden" sheet contains the 14 monitored green infrastructure (GI) sites with their design and physiographic features and the "Field Log" sheet contains the installation and field maintenance trips.
- WaterWells.xlsx: an Excel file containing all of the water wells in the Detroit region uses for interpolating groundwater levels.
- GI_GIS_Analysis.aparx: ArcGIS Pro project file which includes the 14 monitored GI sites and the GIS data for Detroit (percent imperviousness, elevation, slope, land use type, wells, interpolated groundwater levels, hydrologic soil group).
- Code.zip: Zip folder containing another folder titled "Code" which holds: (1) a folder titled "SensorData" containing 16 csv files with the raw pressure transducer data for the 16 monitored GI sites during the measurement period (including the two excluded sites); (2) a csv file titled "MonitoredRainGardens.csv" containing the 16 monitored green infrastructure (GI) sites with their design and physiographic features used in the correlation analysis; (3) a csv file titled "storm_constants.csv" which contain the computed decay constants for every storm in every GI during the measurement period; (4) a csv file titled "GLWA_RainGaugesforStudy.csv" that contains rainfall from 9 rain gauges during the measurement period; (5) a Jupyter notebook titled "estimate_decay_constants.ipynb" which provides the code for calculating the decay constants for the monitored GI; (6) a Jupyter notebook titled "storm_constants.ipynb" which provides the code for analyzing the decay constants including the correlation analysis and surface plots; and (7) a Jupiter notebook titled "modeled_response.ipynb" which provides the code for plotting the drawdown curves based on the decay constant.
Files
Code.zip
Additional details
Funding
- U.S. National Science Foundation
- CAREER: Toward a theory for smart stormwater systems 1750744
- U.S. National Science Foundation
- SCC-IRG Track 1: Overcoming Social and Technical Barriers for the Broad Adoption of Smart Stormwater Systems 1737432