By signing up, you agree to the Code of Conduct, which applies to all online and in-person spaces managed by the Public Lab community and non-profit.

As an open source community, we believe in open licensing of content so that other members of the community can leverage your work legally -- with attribution, of course. By joining the Public Lab site, you agree to release the content you post here under a Creative Commons Attribution Sharealike license, and the hardware designs you post under the CERN Open Hardware License 1.1 (full text). This has the added benefit that others must share their improvements in turn with you.

While many states offer well water testing, the data on what's in the water is only shared with homeowners, or shared publicly by zip code (at least in Wisconsin). Does anyone know of a place where well water data is compiled? Are there examples of community created maps or databases for local well water testing results?

From Jerry Shannon - @jerry_shannon :
How public is it? Is this something for anyone to access or for use by a specific community group? I could imagine using something like @OpenDataKit and @onadata, which gives you a way to dynamically access the data. Or @fulcrumapp, though that has a cost.

From Jerry Shannon @jerry_shannon : If the goal is to make results easily visible, I'd think about a @LeafletJS map hosted on @github. The dataset could go in the repo and be dynamically updated as results come in. A Shiny app from @rstudio would be another option. Both would have front end technical investment.

You find anything else on this? I'd be interested in learning along with you.

Some reactions / questions:
-- It looks like most of the feedback you got from twitter was more about the techs/platforms. In terms of getting the data...

-- Are you looking at private or gov't data? Private could be a company like mytapscore.com or a lab like awslab.com which does the actual testing (mytapscore just packages things). People go to these when they're gov't doesn't offer tests and/or if they're offered but it'd take long / involves beaucracy, etc. If gov't data, I imagine there's variance by state. In CA, local water utilities offer tests and they report certain things up to the state. Not sure exactly what that looks like (yet).

-- Data ownership and privacy issues are involved here... I'm not sure it's clear to anyone whose "data" well water testing belongs to. By default, I think it belongs to the home owner. (My parallel is in the still developing world of healthcare: a test on whether or not you have cancer is first and foremost yours and hospital can't just share that with people without your consent.) The reason this matters: Home / property values go down with bad results; and there are privacy + stigma concerns to consider if you can ID an individual who has, say, lead poisoning. --> So stuff that is released is aggregated enough to not be identifiable. But not everyone releases data. And I think there are different data types / standards among those that do.

-- I'd love to learn more about the Wisconsin zip-code level data you mentioned. Can you share a link?

Ah I was hoping to have a fix on the line breaks before I share back with the group asking about this, no luck yet! But::

I think they're interested in using the data collected from people who get their personal home wells tested by the state. The home owners own the data (and the state?)- like you mentioned. But I believe they're interested in sharing and showing results from people who willingly get their water tested, and then submit their data to a public database. Just trying to see here if anyone knows of groups who are doing this - exploring what it might look like, what challenges they might run into. They're trying to get more granular on environmental exposures, I believe in this instance related to large scale farming operations.