Dataset Open Access
Real-Time Sensor Network of Detroit Green Infrastructure: Datasets and Code
Mason, Brooke;
Schmidt, Jacquelyn;
Kerkez, Branko
- 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.
Files
(2.3 MB)
| Name | Size | |
|---|---|---|
|
detroit_gi_code.zip
md5:4fd127cc31a1cfdb5230c0e0d6f3c93e |
1.6 MB | Download |
|
GI_DrawdownRates_PerStorm.xlsx
md5:1e949d628a2bc4ffd14598ef6f3414b6 |
174.1 kB | Download |
|
GI_GIS_Analysis.aprx
md5:08a2d505ad66a43dcec82ed4862ed7d1 |
477.9 kB | Download |
|
MonitoredRainGardens_PaperTable.xlsx
md5:f37c3f402f4d71f64b81dcd25c80998d |
14.4 kB | Download |
80
24
views
downloads
| All versions | This version | |
|---|---|---|
| Views | 80 | 48 |
| Downloads | 24 | 14 |
| Data volume | 14.9 MB | 9.0 MB |
| Unique views | 64 | 44 |
| Unique downloads | 7 | 4 |
Indexed in
- Publication date:
- December 5, 2022
- DOI:
-
- Keyword(s):
- green infrastructure wireless sensor networks stormwater smart water systems smart cities real-time data
- Grants:
-
National Science Foundation:
- SCC-IRG Track 1: Overcoming Social and Technical Barriers for the Broad Adoption of Smart Stormwater Systems (1737432)
- Communities:
- License (for files):
- Creative Commons Attribution 4.0 International