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.

Sign up for GitHub

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

Jump to bottom

Austin Lead Map #131

Open
2 of 17 tasks
lizita opened this issue Oct 24, 2018 · 11 comments
Open
2 of 17 tasks

Austin Lead Map #131

lizita opened this issue Oct 24, 2018 · 11 comments
Labels
Inactive A project that hasn't had movement in awhile or is lacking a strong project champion

Comments

@lizita
Copy link

lizita commented Oct 24, 2018 •
edited
Loading

What problem are you trying to solve?

There is no comprehensive map of lead concentrations in soils in Austin. Lead is toxic when ingested - especially for children, damaging nervous system development.

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

All of us! Identifying areas of high lead concentrations would benefit the public health of Austin by reducing exposure. Analysis of the data could be used to support cleanup programs or funding of community initiatives in areas with higher concentrations.

What other resources/tools are currently serving the same need? How does your project set itself apart?

TCEQ regulates lead in soil and DSHS regulates lead-based paint abatement. The City of Austin has a Brownfields program that host a "soil kitchen" with the EPA every year to collect and test soil samples. They release the results as a spreadsheet with the street and cross street - but not spatially mapped.

Where can we find any research/data available/articles?

http://www.austintexas.gov/soilkitchen
https://environmenttexas.org/programs/txe/get-lead-out

What help do you need now?

Cleaning up the data - I compiled all of the four years of data into a google sheet with four tabs. I geocoded it using this tutorial: http://willgeary.github.io/data/2016/11/04/Geocoding-with-Google-Sheets.html, but there are still a lot of wrong locations. I also think I hit the limit on addresses you can geocode with the google API, so maybe someone else could do the rest? Eventually I want to put it in ArcPro, maybe make a viewer?

Here's the google sheet: https://docs.google.com/spreadsheets/d/1V6lZ9BT3ZH6d5v0YIjERR7cE7qKN_M9iXq8RXhndM5w/edit?usp=sharing

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

Definitely validation, I think we might be able to work with the Brownfields office to fill in some of the empty fields and correct ones that don't make sense. Anyone with skills in GIS could help with making the map. Designing a viewer or way to make it interactive would be next.

How can we contact you outside of Github(list social media or places you're present)?

I'm on the slack (Junebug) and you can also email me at [email protected]

Project management

Checklist for NEW ideas 👶

Hey, you're official! You're now part of the growing civic hacking community in Austin. Here's a few things to get started (a couple you've probably already done).

  • Create this idea issue
  • Flesh out the who, where, and what questions above
  • Start the conversation about this idea on Slack Replace this link to the #general channel with your project's preferred channel.

Checklist for ACTIVE projects 🔥

Let's get this project started! When this idea starts taking off, the Projects Core Team will start helping this project's lead(s) out with project management and connecting you to resources you may need. To get there, please complete and check off the following:

  • Post an update at least once a month to this issue. Use BASEDEF for ideas, but it's ok even if your update is just "nothing new happened this month" or "we saw a small increase in traffic to our app this month". If there's no activity for two months, that's no problem, life happens. We'll just label this as backlog so others know you'll get back to it when you have the time. If nobody hears from you at all in more than two months, we may mark it as abandoned so that others can pick up this idea and run with it.
  • Take 30 minutes to complete Open Leadership 101
  • Create a GitHub repository. Ask for help setting up permissions if you want your repository to be within the Open Austin Github organization.
  • Create a README file in your project repository. This file should help newcomers understand what your project is, why it's important, and kinds of help you're looking for.
  • Create issues to describe each task that you plan to do or need help with and how a contributor can get started on that task. You might start and stop a lot, so consider issues as your to-do list.
  • Create a team for your core contributors
    • This will make it easier for you to manage your github repo access. People on a team have the same level of access. Admin access will allow your trusted contributors to make changes as needed.
    • You can remove and add people to your team as needed.
    • View some of our teams: https://github.com/orgs/open-austin/teams
    • Note: You can also allow collaborators outside of your team and give them more limited access.
  • Create a user group in Slack so you can "@" your core contributors all at once, without bothering other people who use the Slack channel. You'll need permission from a Slack admin, so just mention @Leadership on Slack to get this set up.
  • Create a Google Drive, Dropbox, or other cloud storage to share larger files. Github and Data.World are good for code and data, respectively, especially when you need version control. But they're not good for very large files, documentation, articles, etc. A cloud storage option will allow you to easily share, create, and collaborate on documents with your team and help organize ideas and thoughts.
    • Doing this early on can help your team stay organized and to onboard new contributors who wouldn't have access to files you all have shared over email.

Checklist for FEATURED Projects 🎉

To have your project FEATURED on Open-Austin.org, complete the following documentation. In past projects, well-documented featured projects have more contributions than other projects.

If you get stuck at any point, feel free to reach out to the leadership team on Slack by adding @Leadership to your message. We're here to help you make real changes to our city.
@nicholasl
Copy link

Awesome idea! I worked in real estate and there is also a federally required lead disclosure on properties to 1980 or so. Portland and other cities are also interested in educating home gardeners, especially ones growing near homes.

I'd like to help and learn maps and GIS, I have a list of all of the Austin STR/AirBnb permit addresses that I'd also like to visualize.

I could host a meetup on South First or where are y'all meeting?

@lizita
Copy link
Author

lizita commented Oct 26, 2018

I'm east, but maybe we could meet downtown? The central library is a good spot. Maybe we could drum up some more interest and then plan a work session.

@nicholasl
Copy link

nicholasl commented Oct 27, 2018 via email

@ecglover8
Copy link

I'm interested in helping with this. Are you still looking for bodies? I can help with cleanup of the raw data.

@lizita
Copy link
Author

lizita commented Nov 5, 2018

Yes! I added the geocode tab like in the geocode tutorial above, but it didn't work for all of the data. I think I used up all of the google streets API I was allowed. Is there a work-around for this? You could also check the addresses and coordinates to make sure they match for the ones that are geocoded.

@lizita
Copy link
Author

lizita commented Nov 9, 2018

Update - Thanks for finishing up the geocoding on the rest of the data! Next step- add as an XY event layer to ArcPro. Do y'all have AcrGIS? Should we use QGIS? I've never used it but pretty similar I think.

@ecglover8
Copy link

Will you be at the meeting on Tuesday night? I'm not a huge fan of keeping the data in Google sheets and using ArcGIS.

@nicholasl
Copy link

nicholasl commented Nov 10, 2018 via email

@lizita
Copy link
Author

lizita commented Nov 13, 2018

I'll be there tonight. It's at the old central library - 800 Guadalupe - at 6:30

@lizita lizita closed this as completed Nov 13, 2018
@lizita lizita reopened this Nov 13, 2018
@mscarey mscarey mentioned this issue Apr 8, 2019
Closed
@mscarey
Copy link
Contributor

mscarey commented Apr 8, 2019

Since we have two inactive projects about mapping data about lead contamination, I'm closing the other one, #89. There are some research links in that thread, but they may not be 100% relevant because it dealt with lead pipes rather than lead in soil or paint.

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

nicholasl commented Mar 22, 2020 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Inactive A project that hasn't had movement in awhile or is lacking a strong project champion
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@mscarey @nicholasl @ecglover8 @lizita