8 ms·

To see specific zip codes, download zip[0]. UCMR3_ZipCodes.txt has all the zip codes and you can cross reference UCMR3_All.txt using PWSID to get facility ID; t

To see specific zip codes, download zip[0]. UCMR3_ZipCodes.txt has all the zip codes and you can cross reference UCMR3_All.txt using PWSID to get facility ID; then cross reference UCMR3_DRT.txt using the facility ID to get the disinfection type. Details about the disinfection type can be found in a pdf within the zip file. [0]https://www.epa.gov/sites/production/files/2015-09/ucmr-3-occurrence-data.zip https://www.epa.gov/sites/production/files/2015-09/ucmr-3-oc...

tbrock 10y ago
crap, my zipcode is on there... does this mean i'm going to die?
- deleted 10y ago
  [deleted]
- InclinedPlane 10y ago
  Yes. Valar Morghulis.
- ianlevesque 10y ago
  Not sure if you're joking, since we're all dying, but if you really want to know what it means see my other comment.
- buzzybee 10y ago
  When you get deep into these widespread public health issues you start to realize that there's always going to be at least one that you or your locale is at risk for. If it's not the water, it's the food. If it's not the food, it's the air. If it's not the air, it's the soil. If it's not the soil, it's your building. And so on... The best you can do, in the end, is to avoid paranoia or panic and just aim for some systematic detection, mitigation and prevention processes in your household. With a little luck and a good system, you cheat death or disability, temporarily. You cannot create an ironclad guarantee of safety, but there are many things that you can do something about.
  - tim333 10y ago
    I figure tallying the top ones based on impact on life expectancy makes some sense. The list is probably going to be dominated by the top two or three items. Probably obesity (4 years?) followed by air pollution (1 year maybe) in my case. Not much point worrying about the barely detectable stuff.
- honkhonkpants 10y ago
  Do you live anywhere near a dry cleaner, fuel station, military base, rail yard, airport, freeway, smelter, or mine? If so you are doomed.
corpus 10y ago
I'll paypal $50 to the first person who can write a script or web interface which just takes a zip-code and returns a list of infections based on this data.
- seanp2k2 10y ago
  I'll try to get something up on GitHub when I'm back by a computer. Give it to the EFF if I win :)
- amenghra 10y ago
  Go to https://www3.epa.gov/enviro/myenviro/ https://www3.epa.gov/enviro/myenviro/ and put your zip code in there.
- gricardo99 10y ago
  If you download the zip, here's a bash one-liner (replace 48103 with zip of interest): for pwsid in $(grep 48103 UCMR3_ZipCodes.txt | cut -f 1);do for fid in $(grep $pwsid UCMR3_All.txt | cut -f 4);do grep $fid UCMR3_DRT.txt | cut -f 6;done;done | sort | uniq
  - corpus 10y ago
    ok this guy wins :) email me at okthisguywins@gmail.com with your paypal details / or pay request. thanks! p.s. every zip code i've tried has a bunch of findings. anyone have a zip code without one?
    - gricardo99 10y ago
      Thanks, that's very generous. I updated the bash line to include filtering on "=". From reading other comments, "which means at or above minimum reporting level". But more importantly, the line I had was reporting the "Disinfectant Type" not the "Contaminant"! If you're feeling really charitable, I'll pay it forward and second another comment: send the donation to EFF.
  - gricardo99 10y ago
enlightenedfool 10y ago
I found disinfectant type CAOF in my region. What does that mean? I couldn't gather. But the map shows that contaminants are not detected
- stokedmartin 10y ago
  CAOF (Chloramine, formed from offsite hypochlorite)
  - gricardo99 10y ago
    That just "cleans" the water, mostly for microbiological contaminants. You'll want to look-up what "Contaminants" were found in your water.
gricardo99 10y ago
You might be interested in the Disinfectant Type used by your water district, but I think most people are interested in knowing the "Contaminant" detected in their water.

tbrock 10y ago

crap, my zipcode is on there... does this mean i'm going to die?

deleted 10y ago
[deleted]
InclinedPlane 10y ago
Yes. Valar Morghulis.
ianlevesque 10y ago
Not sure if you're joking, since we're all dying, but if you really want to know what it means see my other comment.
buzzybee 10y ago
When you get deep into these widespread public health issues you start to realize that there's always going to be at least one that you or your locale is at risk for. If it's not the water, it's the food. If it's not the food, it's the air. If it's not the air, it's the soil. If it's not the soil, it's your building. And so on... The best you can do, in the end, is to avoid paranoia or panic and just aim for some systematic detection, mitigation and prevention processes in your household. With a little luck and a good system, you cheat death or disability, temporarily. You cannot create an ironclad guarantee of safety, but there are many things that you can do something about.
- tim333 10y ago
  I figure tallying the top ones based on impact on life expectancy makes some sense. The list is probably going to be dominated by the top two or three items. Probably obesity (4 years?) followed by air pollution (1 year maybe) in my case. Not much point worrying about the barely detectable stuff.
honkhonkpants 10y ago
Do you live anywhere near a dry cleaner, fuel station, military base, rail yard, airport, freeway, smelter, or mine? If so you are doomed.

corpus 10y ago

I'll paypal $50 to the first person who can write a script or web interface which just takes a zip-code and returns a list of infections based on this data.

seanp2k2 10y ago
I'll try to get something up on GitHub when I'm back by a computer. Give it to the EFF if I win :)
amenghra 10y ago
Go to https://www3.epa.gov/enviro/myenviro/ https://www3.epa.gov/enviro/myenviro/ and put your zip code in there.
gricardo99 10y ago
If you download the zip, here's a bash one-liner (replace 48103 with zip of interest): for pwsid in $(grep 48103 UCMR3_ZipCodes.txt | cut -f 1);do for fid in $(grep $pwsid UCMR3_All.txt | cut -f 4);do grep $fid UCMR3_DRT.txt | cut -f 6;done;done | sort | uniq
- corpus 10y ago
  ok this guy wins :) email me at okthisguywins@gmail.com with your paypal details / or pay request. thanks! p.s. every zip code i've tried has a bunch of findings. anyone have a zip code without one?
  - gricardo99 10y ago
    Thanks, that's very generous. I updated the bash line to include filtering on "=". From reading other comments, "which means at or above minimum reporting level". But more importantly, the line I had was reporting the "Disinfectant Type" not the "Contaminant"! If you're feeling really charitable, I'll pay it forward and second another comment: send the donation to EFF.
- gricardo99 10y ago

enlightenedfool 10y ago

I found disinfectant type CAOF in my region. What does that mean? I couldn't gather. But the map shows that contaminants are not detected

stokedmartin 10y ago
CAOF (Chloramine, formed from offsite hypochlorite)
- gricardo99 10y ago
  That just "cleans" the water, mostly for microbiological contaminants. You'll want to look-up what "Contaminants" were found in your water.

gricardo99 10y ago

You might be interested in the Disinfectant Type used by your water district, but I think most people are interested in knowing the "Contaminant" detected in their water.