Document Type
Dataset
Description
Sustainable urban systems require appropriately sized infrastructure. However, when cities face economic and population decline, hardened infrastructure - such as drinking water distribution systems – is difficult and costly to modify. This dataset provides the results of a modeling exercise performed using EPANET (Version 2.2) to examine potential scenarios for rightsizing water infrastructure in a shrinking city. The modeling was performed utilizing a full-scale, calibrated hydraulic model of the drinking water distribution system in Flint, Michigan obtained through a Memorandum of Understanding between the City of Flint and Wayne State University.
For this analysis, in addition to a base model, we evaluate six scenarios involving either only decommissioning of pipes alone or both decommissioning and downscaling replacement of pipes. Model scenarios were run for three weeks (504 hours). The first two weeks (335 hours) were used to stabilize the system. System conditions (e.g., pressure in pounds per square inch (psi) and water age (hours)) at 15,936 locations in the system were recorded every hour, resulting in 168 measurements for each location in the system, a total of 2,677,248 measurements per hour. The minimum and maximum pressure, maximum water age (95th percentile), average pressure, and average water age (50th percentile) are computed during the third week of simulation.
This dataset describes theoretical changes associated with each scenario as well as the pressure and water age resulting from EPANET modeling. Additionally, socio-economic data are also included. This dataset is paired with a second dataset available at https://doi.org/10.22237/waynestaterepo/data/1729036800/a.
894 record dataset
Data Dictionary:
GEOID: 14-digit Census Bureau geographic identifier based on 2010 Census;
Scenario: Model Scenario (0-6);
MinP: Minimum Water Pressure (psi);
MaxP: Maximum Water Pressure (psi);
AvgP: Average Water Pressure (psi);
Ag50: Average Water Age (hrs);
Ag95: Maximum Water Age (hrs);
AgChn50: Change in Water Age (hrs) From Base Model (Scenario 0);
AgChn95: Change in Water Age (hrs) From Base Model (Scenario 0);
PercVacant: Percent Vacant Parcels in Census Tract;
Distress: Distressed Communities Index (DCI) [Sadler RC, Gilliland JA, Arku, G. An application of the edge effect in measuring accessibility to multiple food retailer types in Southwestern Ontario, Canada. International journal of health geographics. 2011; 10, 1-15.];
PrcNW: Percent Non-White [U.S. Census Bureau, 2016-2020 American Community Survey 5-Year Estimates. Available at: www.data.census.gov. Accessed: 7 July 2024]
DOI
10.22237/waynestaterepo/data/1729036800/b
File Format
text/csv
File Size
129kb
License
Author[s] release this dataset under a Creative Commons Attribution 4.0 International License (CC-BY 4.0, https://creativecommons.org/licenses/by/4.0/), which grants the public rights to reuse and redistribute this data provided 1) appropriate attribution is given to the author[s]; and 2) a link to the source of the data and to the CC-BY 4.0 license is included.
Disciplines
Civil Engineering | Construction Engineering and Management | Environmental Engineering | Urban Studies and Planning
Recommended Citation
Sadler, Richard Casey; Koo, Hyun Jeong; Allamy, Basheer; and McElmurry, Shawn P., "Scenario Analysis of Drinking Water Infrastructure Rightsizing in Flint, Michigan: Model Census Tract Results" (2024). Open Data at Wayne State. 5.
https://digitalcommons.wayne.edu/open_data/5
Included in
Civil Engineering Commons, Construction Engineering and Management Commons, Environmental Engineering Commons, Urban Studies and Planning Commons
Comments
Richard Casey Sadler: ORCID 0000-0002-5130-8561
Hyun Jeong Koo: ORCID 0000-0003-1178-8609
Basheer Allamy
Shawn P. McElmurry: ORCID 0000-0001-7398-431X