tylerandrewscott
commented
1 year ago ok I made a script that grabs drinking water data -- the end just creates a summary dataframe but doesn't save it or merge it, since I didn't want to overbuild something that didnt' fit into your current workflow. this can be played with a bit, right now it creates a count of PWS by GSA, health violation count (2014-2018) by GSA, and proportion of service connections reliant on groundwater by GSA. all adjustable. PWS boundary from state, other two files are downloaded to temp directories, not saved.
including 1) measure of problem eg # violations, 2) measure of systems, eg count and/or consolidation, and 3) measure of source, eg what % relies on GW. Consider option to aggregate CWS data by GSP area, using Vanderbilt CWS shapefiles (https://lab.vanderbilt.edu/dwjlab/research/united-states-community-water-system-cws-estimated-service-area-boundary-esab-geospatial-database/) and GSP_submitted shapefiles (on Box under data_spatial_raw or downloadable at https://sgma.water.ca.gov/webgis/?jsonfile=https%3a%2f%2fsgma.water.ca.gov%2fportal%2fresources%2fjs%2fmapconfigs%2fGspSubmittalsConfig.js&_dc=0.23941161367525954)