Real-Time Sensor Network of Detroit Green Infrastructure: Datasets and Code
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.
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).
WaterWells.xlsx: an Excel file containing all of the water wells in the Detroit region uses for interpolating groundwater levels.
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.