Real-Time Sensor Network of Detroit Green Infrastructure: Datasets and Code
MonitoredRainGardens_PaperTable.xlsx: Excel spreadsheet containing the 16 monitored green infrastructure (GI) sites with their design and site characteristics.
GI_GIS_Analysis.aparx: ArcGIS Pro project file which includes the site characteristics and locations of the 16 monitored GI sites, GIS data for Detroit (percent imperviousness, elevation, slope, land use type, wells, interpolated groundwater levels, hydrologic soil group), and the K-Nearest Neighbors model of estimated drawdown rates and model uncertainty for Detroit.
GI_DrawdownRates_PerStorm.xlsx: Excel spreadsheet containing the calculated mean drawdown rates for each site and each storm during summer 2021.
detroit_gi_code.zip: Zip folder containing a folder titled sensor_data which holds: (1) 16 csv files with the raw pressure transducer data for the 16 monitored GI sites during summer 2021; (2) csv file of the sensor and camera data for sensor validation; (3) 2 csv files containing the 16 monitored green infrastructure (GI) sites with their design and site characteristics. It also includes a Jupiter notebook file titled paper_code.ipynb which contains all the code used for the paper including: (1) reading the data; (2) drawdown rate calculations; (3) machine learning prediction of drawdown rates; (4) estimating error of prediction; (5) plotting paper figures.