DWI Insights

[seusilva]

What problem are we trying to solve?

We want to know if the police are making DWI arrests in areas where they are needed.

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

The visualization will provide insight for the police and policy makers. Alcohol related traffic fatalities are a significant public safety issue in Austin and we want to make sure that police resources are directed to areas where prevention can a difference.

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

Austin Planning and Zoning Department: Vision Zero

What help is needed at this time?

Person with spatial analysis skillset Pandas or agate (python) for statistics? Georeferencing tool and skillset to fit arrest and crash sites into regions Probably Leaflet for mapping Marketing help

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

?

Project management

Checklist for NEW ideas :baby:

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).

• [x] Create this idea issue
• [x] Flesh out the who, where, and what questions above
• [x] Start the conversation about this new idea on Slack (this project uses #general )
• [x] Respond with at least one update on this issue within the next month

Checklist for ACTIVE projects :fire:

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:

• [x] 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
• [x] Create a GitHub repository and Slack channel for work.
• [x] 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.
• [x] 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 team all at once
  • You'll need permission from a Slack admin, so just mention @leadership on Slack to get this set up.
  • This will make it easier to get the attention of the core contributors of your project in your project slack channel which may have some spectators or more casual contributors.
  • People can be added and removed to your group as contributors join and leave.
• [x] 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 :tada:

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.

• [x] In your README, link to the Open Austin Code of Conduct or write your own code of conduct.
• [x] Create file: LICENSE to give your project an open license, allowing for sharing and remixing.
• [ ] Create file: CONTRIBUTING.md so others know how they can contribute.
• [ ] Create an easily shareable project management artifact, like a Civic Tech Canvas or Open Canvas
• [ ] Create an issue on the open-austin.github.io repo with the title Add [my project] to projects page. An Open Austin leader will review this issue and post your project :balloon:
• [ ] Tell the City of Austin. If your idea is in a shareable format and can benefit people around the city, go to that site and follow the instructions on the bottom of the page to showcase your work there.

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.

[seusilva]

One of the results will be to produce data analysis and a map to identify gaps, disparities and patterns.

Alcohol related traffic fatalities are a significant public safety issue in Austin and we want to make sure that police resources are directed to areas where prevention can a difference.

[seusilva]

Key Activities Check on VisionZeroATX (a possible partner) website constraints. Identify mapping and data visualization and data analysis software. Identify data sources. Collect and prepare data for ATX Hack for Change. Ensure a permanent data source. Publish map and analysis. Determine how APD already targets DWI enforcement.

[decibel]

Austin city limits extend into Williamson county and possibly others. I suggest incorporating that into the project.

[mateoclarke]

Worth following this national project: http://blogs.microsoft.com/on-the-issues/2016/03/11/data-science-for-safer-streets-datakind-vision-zero-project-expands-to-three-new-cities/

[seusilva]

The idea has is roots in VisionZeroATX which I believe is part of the national network of Vision Zero cities.

[mateoclarke]

http://www.govtech.com/dc/articles/San-Jose-Calif-Uses-Data-to-Reduce-Traffic-Fatalities.html

[mateoclarke]

Hey @seusilva, are you or any of your other team members interested in taking this project to the ATX Hack for Change June 3-5th? If so, all you need to do is submit your idea to the project proposal Github page. Good news is it asks for much of the same info y'all have already filled out here. @mention me or shoot me an email if you have any questions at info@open-austin.org.

[durs125]

I looked at the DWI data from the Austin PD or 2015 and made a heat map of it. The worst cases are in the morning on Saturday when the buses do not run. https://durs.cartodb.com/viz/7a36ccca-3339-11e5-9a6f-0e43f3deba5a/public_map I would like to work on this project: Is there a slack channel?

[mscarey]

No, there's no slack channel right now. Feel free to make one! This was one of those projects we developed as a design concept, and I don't think anyone held even a single work session for it, so no one else even dug up that DWI data in your map. I do still think DWIs are particularly useful to map, moreso than other crimes, so the idea of a crime map just for DWIs kind of makes sense.

On Tue, Jun 7, 2016 at 7:03 PM, David Infortunio notifications@github.com wrote:

I looked at the DWI data from the Austin PD or 2015 and made a heat map of it. The worst cases are in the morning on Saturday when the buses do not run.

https://durs.cartodb.com/viz/7a36ccca-3339-11e5-9a6f-0e43f3deba5a/public_map I would like to work on this project.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/open-austin/project-ideas/issues/51#issuecomment-224450379, or mute the thread https://github.com/notifications/unsubscribe/ACGX3I4CjjH8u6JYut9H-kgaxTJe3wzBks5qJgbegaJpZM4HqFu4 .

[johndinning]

Very cool!

From: David Infortunio [mailto:notifications@github.com] Sent: Tuesday, June 07, 2016 7:04 PM To: open-austin/project-ideas Subject: Re: [open-austin/project-ideas] DWI Insights (#51)

I looked at the DWI data from the Austin PD or 2015 and made a heat map of it. The worst cases are in the morning on Saturday when the buses do not run. https://durs.cartodb.com/viz/7a36ccca-3339-11e5-9a6f-0e43f3deba5a/public_map I would like to work on this project.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/open-austin/project-ideas/issues/51#issuecomment-224450379, or mute the threadhttps://github.com/notifications/unsubscribe/AHMLFIbsQUO3BoEL0CwDbn6GwEiAqOE2ks5qJgbcgaJpZM4HqFu4.

[Woodley]

For some TXDOT DWI information, Check out the presentation from TXDOT Vision Zero which has some data and statistics.

2016 Meetings: Pedestrian Advisory Council June 07, 2016 https://www.austintexas.gov/cityclerk/boards_commissions/meetings/121_1.htm

Texas Motor Vehicle Crash Statistics - 2015. Statistics contained in these reports are generated from data provided by TxDOT's Crash Records Information System (CRIS)®. http://www.txdot.gov/government/enforcement/annual-summary.html

Many of these statistics are behavioral. A Place where TXDOT and its Data is Lacking in is:

• ENGINEERING: Bolster key initiatives for which Complete Street Design, Traffic Engineering, & Transportation Planning can prevent deadly or incapacitating collisions.

FHWA Pedestrian and Bicycle Crash Prediction Tool (PBCAT)

• Researchers at the University of North Carolina developed the PBCAT software package for FHWA to better understand these bicycle and pedestrian crashes and guide the selection of countermeasures. The data from the CR-3s were manually entered into the PBCAT software and exported to Excel® spreadsheets for further analyses.

On Wed, Jun 8, 2016 at 8:49 AM, johndinning notifications@github.com wrote:

Very cool!

From: David Infortunio [mailto:notifications@github.com] Sent: Tuesday, June 07, 2016 7:04 PM To: open-austin/project-ideas Subject: Re: [open-austin/project-ideas] DWI Insights (#51)

I looked at the DWI data from the Austin PD or 2015 and made a heat map of it. The worst cases are in the morning on Saturday when the buses do not run.

https://durs.cartodb.com/viz/7a36ccca-3339-11e5-9a6f-0e43f3deba5a/public_map I would like to work on this project.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub< https://github.com/open-austin/project-ideas/issues/51#issuecomment-224450379>, or mute the thread< https://github.com/notifications/unsubscribe/AHMLFIbsQUO3BoEL0CwDbn6GwEiAqOE2ks5qJgbcgaJpZM4HqFu4>.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/open-austin/project-ideas/issues/51#issuecomment-224594275, or mute the thread https://github.com/notifications/unsubscribe/AQ7i2OMMijmzaybiNzShymGfhYbka9hjks5qJshTgaJpZM4HqFu4 .

[durs125]

It would be nice if someone else could verify my data. I believe that there is new data out for the year 2016. It would be nice to see that the data for 2016 matched the data I had. Was there anything about there being better, more up to date information than the Austin data portal?

[amaliebarras]

@durs125 do you have a github repository for the work you've done?

[durs125]

No, I have not put it together yet. I am not sure when I will have time for it. I have been so busy with my regular life lately.

  From: Amalie Barras <notifications@github.com>

To: open-austin/project-ideas project-ideas@noreply.github.com Cc: David Infortunio durs125@yahoo.com; Mention mention@noreply.github.com Sent: Thursday, March 2, 2017 7:54 PM Subject: Re: [open-austin/project-ideas] DWI Insights (#51)

@durs125 do you have a github repository for the work you've done?— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[amaliebarras]

no prob @durs125 !

[tom-montgomery]

@johndinning hey man Im gonna look into reviving this. I'll get in touch if I get anywhere.

[werdnanoslen]

@tom-montgomery awesome! Let me know what support you'd like

[johndinning]

That's great @tom-montgomery! I'm gonna follow the thred and will help where I can.

[werdnanoslen]

I just added some steps y'all can take to the original post above to get you started. I also invited you both to join our Github team.

[tom-montgomery]

@werdnanoslen thanks, created the repo and started on data prep. i'll check out the steps you posted tomorrow.

[werdnanoslen]

awesome, go ahead and update/check the steps in the post as you complete them :)

[tom-montgomery]

created prototype maps for san antonio and the state (click left nav bar arrow for info) using arcgis and carto: State: https://tom-montgomery.carto.com/builder/3bb68e44-c461-47ba-beb2-483a5b37e067/embed San Antonio: https://tom-montgomery.carto.com/builder/57d7b3e1-37d5-4a17-a83f-2f2d727fca5a/embed

If anyone wants to work on improving it let me know

[twentysixmoons]

@tom-montgomery recently created a stellar Medium Article on the work done and at hand!

https://medium.com/open-austin/austin-crash-analytics-c0a94d0bc17e

[twentysixmoons]

Coming back here to Say @tom-montgomery did finish the Austin Map and also presented at GIS Day.

Here is the Austin map. https://tom-montgomery.carto.com/builder/dd690194-98e1-4d99-a497-fab8e56da040/embed

[mscarey]

I think this project should be considered wrapped up, with any similar work continuing in #139, scrAPD.