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

Lead plumbing data requests #89

Closed
mscarey opened this issue Feb 4, 2017 · 6 comments
Closed

Lead plumbing data requests #89

mscarey opened this issue Feb 4, 2017 · 6 comments
Assignees
Labels
Data Liberation Data wrangling Health Inactive A project that hasn't had movement in awhile or is lacking a strong project champion Policy Research Writing / Content
Milestone

Comments

@mscarey
Copy link
Contributor

mscarey commented Feb 4, 2017

What problem are we trying to solve?

We don't know which buildings/areas in Austin are served by lead pipes, so it's hard for people to evaluate their health risks.

Who will benefit (directly and indirectly) from this project?

People who want to determine whether the plumbing system serving their home is safe. Also people who want to research schools, workplaces, etc.

Links to any research/data available/articles

Here's an example of a good lead disclosure map, from Washington DC.

A Vox article with an overview of the issue nationally.

A recent KXAN article about lead plumbing in Travis County.

Austin's current water quality reports and a 2014 water quality report.

The TCEQ test result search screen.

The Austin Water page about lead. This says that 90 percent of lead tests of customers' taps showed less than 1 part per billion of lead. There's no known safe level of lead in drinking water, but the EPA limit is 15 parts per billion.

Instructions for a public record request (topic: Water Utility Records). We haven't requested anything yet.

What are the next steps (validation, research, coding, design)?

This will probably be mostly a research and policy project. First, we should determine exactly what data is already available to the public about lead positive test results and infrastructure (where lead pipes are located) in Austin/Travis County. Then we can make contact with government agencies to ask for more data, maybe using public records requests. To limit the scope of the project, I think it should cover just lead pipes, not lead paint.

One basic question is whether there are any city-owned or county-owned lead pipes, or whether the only lead pipes are privately owned.

What help is needed at this time?

Research and policy help.

@werdnanoslen
Copy link
Member

@mscarey any updates on your research or policy questions? I can help track down some leads to get you going.

@mscarey
Copy link
Contributor Author

mscarey commented Apr 6, 2017

The only public records request I've done was to get the results of the AISD campus lead testing (which I think was exclusively of water fountains). The response was in PDFs, and they said the lead levels were below the threshold of 1 part per billion for all but two campuses, Zavala (4.3 ppb) and Barrington (4.8 ppb). When the test result was less than 1 ppb, no other number was reported. For Zavala, the offending water fountain apparently was removed, and subsequent testing at several sites showed less than 1 ppb. I don't know what follow-up there was at Barrington.

HB 2395 is pending in the Legislature to require school campus lead testing, but there's a fiscal note that says it would cost $22 million, so that might be an obstacle.

The big database of lead testing results is from the TCEQ. It's a little bit obscure, and I'm not sure how to link the test results to locations. I also think KXAN already accomplished that in the article linked above. The data for Austin Water may not have been updated since the KXAN article. I think they just don't test every year.

That still leaves the question of where lead pipes are actually located. I don't think there's anything online that we could use to make a service line map like DC has. We could ask Austin Water what records they have, but I haven't approached them.

@werdnanoslen
Copy link
Member

@mscarey need any help on this project? I know you're working on InfluenceTX a lot these days, so just checking that your last comment is still the current to-do for this project?

@werdnanoslen werdnanoslen modified the milestones: Active, Backlog Sep 23, 2017
@mscarey
Copy link
Contributor Author

mscarey commented Sep 28, 2017

Yeah, I haven't been working on this. I think this page means there are no new test results in the past few years. I think AISD may have some new test results since our public records request, but I doubt they found any more high lead levels.

@mscarey mscarey added the Inactive A project that hasn't had movement in awhile or is lacking a strong project champion label Apr 7, 2019
@mscarey
Copy link
Contributor Author

mscarey commented Apr 7, 2019

No one is actively working on this, and I think it's likely that there's no lead pipe dataset in existence for Austin, so it may not be possible to create anything like DC's map.

@mscarey
Copy link
Contributor Author

mscarey commented Apr 8, 2019

I'm closing this in favor of #131

@mscarey mscarey closed this as completed Apr 8, 2019
@mscarey mscarey mentioned this issue Apr 8, 2019
17 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Data Liberation Data wrangling Health Inactive A project that hasn't had movement in awhile or is lacking a strong project champion Policy Research Writing / Content
Projects
None yet
Development

No branches or pull requests

4 participants