US Drinking Water Utility Climate Change Projections and Combined Hazard Index Scores

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