Small Water Systems Risk Scores and Indicators

This file contains drought and water shortage risk scores for small water systems (community water systems and schools). This workbook includes underlying risk factors used to calculate risk scores, and associated data dictionary. Each record contains the attributes of the water supplier examined (e.g., county, type of water system, name, public water system identification number) and the final risk scores that range from 0 to 100, with 100 as the highest risk and 0 as the lowest risk. Data of underlying risk factors are included, in both units of the original data and rescaled and/or normalized scores that range from zero to one. Please see methods report for full technical description of each indicator, including the origin of the source data and the processing steps conducted. Methods and report available for download at: https://water.ca.gov/Programs/Water-Use-And-Efficiency/Making-Conservation-a-California-Way-of-Life/County-Drought-Planning. Link to access the interactive online tool to explore the underlying risk indicators for each water system is posted at the same page: https://dwr.maps.arcgis.com/apps/MapSeries/index.html?appid=3353b370f7844f468ca16b8316fa3c7b To use this dataset in ArcGIS, please download Water System boundaries (as a single shapefile) from: https://gis.data.ca.gov/datasets/fbba842bf134497c9d611ad506ec48cc_0, then open the shapefile in ArcGIS and relate it with the Join tool to this data file in the workbook here using the PWSID attribute as the join field.