Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add drinking water data #10

Open
ezufall opened this issue Aug 17, 2022 · 1 comment
Open

Add drinking water data #10

ezufall opened this issue Aug 17, 2022 · 1 comment
Assignees

Comments

@ezufall
Copy link
Collaborator

ezufall commented Aug 17, 2022

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)

@ezufall ezufall assigned tylerandrewscott and ezufall and unassigned ezufall Aug 17, 2022
@tylerandrewscott
Copy link
Collaborator

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants