DOI: 10.5281/zenodo.14618746
title: US Drinking Water Utility Climate Change Projections and Combined Hazard Index Scores

description: This dataset includes climate change hazard projections and combined climate hazard index values for 42,786 drinking water utilities accross the contiguous United States (US). The projections are compiled from multiple sources, including the Climate Mapping for Resilience and Adaptation tool (CMRA) and Climate Risk and Resilience Portal (ClimRR), and use mid-century (2050) Representative Concentration Pathway 4.5 CMIP5 Localized Constructed Analogs (LOCA) CMIP5 Projections for North America. The included climate hazards are extreme heat, energy demand, freeze-thaw cycles, extreme precipitation, wildfires, water supply stress, and sea level rise. Each row of the dataset corresponds to a different community water system within the contiguous US, each identified using their assigned Public Water System Identification number More details about the data sources and modeled combined climate hazard index can be found in the future publication:

Lyle, Z. J., VanBriesen, J.M., & Samaras, C.  "Climate change hazard index reveals combined risks to United States drinking water utilities".

 

The columns in the database are as follows:

pwsid: Public Water System Identification Number

primacy_agency_code: Two character postal code for the state or territory having regulatory oversight for the water system.

pws_name: Name of the water system

State: State in which water system is located

city_served: City in which water system is located

County: County in which water system is located

population_served_count: Number of customers served by water system

service_connections_count: Number of service connections maintained by water system

service_area_type_code: Service area type code

owner_type_code: Code that dentifies the ownership category of the water system consisting of: F (Federal Government), L (Local Government), M (Public/Private), N (Native American), P (Private), or S (State Government)

is_wholesaler_ind: Indicates whether the system is a wholesaler of water

primacy_type: Code that indicates if the water system is regulated by a state, tribal, or territorial primacy program. Note that EPA direct implementation programs, except for Wyoming, are tribal primacy programs

primary_source_code: The code showing the differentiation between the sources of water: ground water (GW),groundwater purchased (GWP), surface water (SW), surface water purchased (SWP), groundwater under influence of surface water (GU), or purchased ground water under influence of surface water source (GUP)

tier:

centroid_lat: Latitude ocation of water system

centroid_lon: Longitude ocation of water system

NOAA.Region: NOAA Climate Region in which water system is located

heat_index: Extreme heat index value

energydemand_index: Energy demand index value, using regression model developed by Sowby & Burian, 2018

FT_index: Freeze-Thaw cycle index value

extremeprecip_index: Extreme precipitation index value

waterrisk_index: Water stress index value, using Dickson, K. E. & Dzombak, D. A. (2019)

SLR_index: Sea level rise index value

wildfirerisk_index: Wildfire index value

hazard_index: Combined climate change hazard index value, normalized from 0 to 1

hazard_index_group: Classification group for combined climate change hazard index value (minimal, low, moderate, high)

heat_threshold: Binary value indicating whether PWS exceeded risk threshold level for extreme heat (0 indicating no, 1 indicating yes)

precip_threshold: Binary value indicating whether PWS exceeded risk threshold level for extreme precipitation (0 indicating no, 1 indicating yes)

SLR_threshold: Binary value indicating whether PWS exceeded risk threshold level for sea level rise (0 indicating no, 1 indicating yes)

wildfire_threshold: Binary value indicating whether PWS exceeded risk threshold level for wildfires (0 indicating no, 1 indicating yes)

FT_threshold: Binary value indicating whether PWS exceeded risk threshold level for freeze-thaw cycles (0 indicating no, 1 indicating yes)

waterstress_threshold: Binary value indicating whether PWS exceeded risk threshold level for water stress (0 indicating no, 1 indicating yes)

energydemand_threshold: Binary value indicating whether PWS exceeded risk threshold level for enegery demand (0 indicating no, 1 indicating yes)

sum: Total number of climate hazard risk threshold values exceeded

exposure: Product of combined climate change hazard index value and population served