# NDoCH & CA Water Challenge: Code for California Brigades Coordination

**URL:** <https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233>\
**Category:** Event Planning\
**Tags:** ndoch, cawaterchallenge\
**Created:** [July 27, 2018, 5:37pm UTC](https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233 "2018-07-27T17:37:01Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![ramymik](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.codeforamerica.org/ramymik/32/106_2.png) [@ramymik](https://discourse.codeforamerica.org/u/ramymik)\
**Post date:** [July 27, 2018, 5:37pm UTC](https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233/1 "2018-07-27T17:37:01Z")

</div>

Hello! We’re using this thread to discuss planning for NDoCH in California and how we can focus on the California Water Data Challenge as a backbone for activities, or as an element of your NDoCH. We will be coordinating with GovOps and documenting OpenOakland’s plans here to be shared with all brigades so that they may be easily adopted by captains/leads

---

<div class="post-metadata">

**Author:** ![patwater31](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.codeforamerica.org/patwater31/32/173_2.png) [@patwater31](https://discourse.codeforamerica.org/u/patwater31)\
**Post date:** [July 27, 2018, 5:48pm UTC](https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233/2 "2018-07-27T17:48:50Z")

</div>

IDEA from John Kobara COO of California Community Foundation and super cool guy that is behind [LACounts.org](http://LACounts.org). Why not tie in water quality data to rank water districts similar to how Great Schools ranks school districts? Goal would be to create an index and ideally tie that into Zillow and other home sites 🙂

The datasets involved are a bit tricky to navigate though lots of potential. My sense is this is the most relevant: [https://www.waterboards.ca.gov/drinking\_water/certlic/drinkingwater/EDTlibrary.html](https://www.waterboards.ca.gov/drinking_water/certlic/drinkingwater/EDTlibrary.html)

See here for the full list of recommended datasets from the state: [https://docs.google.com/spreadsheets/d/1NhC1WyYVj2K4N-JpoYQk\_7W0ZAbDInjmiYirHUkBaOE/edit#gid=0](https://docs.google.com/spreadsheets/d/1NhC1WyYVj2K4N-JpoYQk_7W0ZAbDInjmiYirHUkBaOE/edit#gid=0)

---

<div class="post-metadata">

**Author:** ![jjia25](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.codeforamerica.org/jjia25/32/172_2.png) [@jjia25](https://discourse.codeforamerica.org/u/jjia25)\
**Post date:** [July 27, 2018, 9:24pm UTC](https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233/3 "2018-07-27T21:24:53Z")

</div>

Question for other brigades: Is NDoCH an event targeted towards the usual suspects, aka brigade members, or do you invite the greater community to NDoCH?

Asking because, while I like the Water Challenge theme, I’m thinking it would be a good idea for OpenOakland’s NDoCH to be something along the lines of a design-a-thon, some sort of event that takes in community input.

---

<div class="post-metadata">

**Author:** ![aaronhans](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.codeforamerica.org/aaronhans/32/175_2.png) [@aaronhans](https://discourse.codeforamerica.org/u/aaronhans)\
**Post date:** [July 31, 2018, 12:21am UTC](https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233/4 "2018-07-31T00:21:10Z")

</div>

Yotam and I from Open Oakland attended the Water Challenge kickoff in SF and started working with a volunteer from [https://www.communitywatercenter.org/](https://www.communitywatercenter.org/) to help them get cleaner data to analyze what is going on in specific water basins. We have done some processing on data from Human Right to Water(This is more recent than the dataset linked in the Water Challenge spreadsheet). They want to focus on a specific large water source that feeds many wells several of which are out of compliance and see if the contaminants and exceedance levels on the violating wells sharing the same water basin source are similar. Then they will use this data to get state funding for cleanup.

We are also toying with displaying exceedance levels as 3D elements on a map because the value measurements exceed the acceptable levels varies widely and maybe displaying historic violations because the set of current unique violations ~300 in CA according to Human Right to Water’s July data is much smaller than the full dataset which has over 5K violation records with older measurement dates.

---

<div class="post-metadata">

**Author:** ![ramymik](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.codeforamerica.org/ramymik/32/106_2.png) [@ramymik](https://discourse.codeforamerica.org/u/ramymik)\
**Post date:** [August 1, 2018, 4:08am UTC](https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233/5 "2018-08-01T04:08:43Z")

</div>

Agreed, and the Water Challenge should be more than just crunching the data, so we are planning to deal with more of the awareness aspect of the challenge as well

---

<div class="post-metadata">

**Author:** ![patwater31](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.codeforamerica.org/patwater31/32/173_2.png) [@patwater31](https://discourse.codeforamerica.org/u/patwater31)\
**Post date:** [August 7, 2018, 5:53pm UTC](https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233/6 "2018-08-07T17:53:28Z")

</div>

@aaronhans Does the code for this project live somewhere publicly available? Curious to learn more

@ramymik how many folks are you anticipating on Saturday out of curiosity?

And @jjia25 great idea!

---

<div class="post-metadata">

**Author:** ![jjia25](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.codeforamerica.org/jjia25/32/172_2.png) [@jjia25](https://discourse.codeforamerica.org/u/jjia25)\
**Post date:** [August 7, 2018, 6:11pm UTC](https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233/7 "2018-08-07T18:11:10Z")

</div>

29 people RSVP’d but we might get walk-ins. Demand is always impossible to predict: [https://www.meetup.com/OpenOakland/events/252957402/](https://www.meetup.com/OpenOakland/events/252957402/)

---

<div class="post-metadata">

**Author:** ![patwater31](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.codeforamerica.org/patwater31/32/173_2.png) [@patwater31](https://discourse.codeforamerica.org/u/patwater31)\
**Post date:** [October 31, 2018, 9:02pm UTC](https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233/8 "2018-10-31T21:02:56Z")

</div>

Congrats to Open Oakland and Code4Sac for winning awards at this years challenge!

---

<div class="post-metadata">

**Author:** ![Mari](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.codeforamerica.org/mari/32/992_2.png) [@Mari](https://discourse.codeforamerica.org/u/Mari)\
**Post date:** [July 1, 2023, 7:03am UTC](https://discourse.codeforamerica.org/t/ndoch-ca-water-challenge-code-for-california-brigades-coordination/233/9 "2023-07-01T07:03:30Z")

</div>