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

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

Share

COinS