Repository navigation
CoP: Data Science: Identify overall trends in DUI arrests by council region #109
Description
Dependency
Access to clean 311 data from 311-data-org team This product should NOT be correlated with 311 data
Project one sheet (can continue issue w/o completion of one sheet template)
Overview
Investigate areas of high and low documented DUI arrests. Link this data back to 311 data to provide insight for councils.
Action Items
- Revise the overview to remove correlation with NCs
- Find available data sources and add to Resources section below
- Determine is this is one-time or ongoing project (and assign appropriate label)
- Write one-sheet
- Define stakeholder
- Summarize project including value add - needs to be informed by a ux interview with some NC leaders
- Define project 6 month roadmap
- Detail history (if any)
- Define tools to be used to visualize combined data
- Create issues for the following
- EDA (Exploratory Data Analysis) of DUI data
- Investigate areas of high and low DUI citations
- Investigate correlation of DUI with population and percentage of stops
- Investigate correlation between DUI and collision data
Resources/Instructions
Sofia says, in order to determine if its a one time project, that we should see how much data there is.
Resume Skill
Perform EDA and independent analysis into public safety data
stakeholders are nc who might do outreach campaings (e.g., offering uber vouchers to bar tender to give patrons, etc).
Activity
JRHutson commentedon Feb 16, 2020
Have completed initial analysis comparing rate of DUI's in each neighborhood district over time as well as areas most impacted during an overall drop from 2013 to 2016.
Need to identify source of population data per neighborhood district.
JRHutson commentedon Feb 17, 2020
Identified dataset for population by NC District. Added to Resources Markdown document.
JRHutson commentedon Feb 23, 2020
There are outliers, but the overall trend seems to associate presence of Liquor Stores with DUI's. This is looking only at 2019 arrest rate since the business data is not historic.JRHutson commentedon Mar 3, 2020
There is some correlation between population density and DUI's but it doesn't account for the neighborhoods with the highest numbers.JRHutson commentedon Mar 3, 2020
I need to investigate the poverty numbers that came from the city data portal. It seems unlikely that the neighborhood with the lowest poverty level still has 75% of residents below the poverty line.JRHutson commentedon Mar 18, 2020
Pulled raw data from Census.gov site and ran calculation of percent below poverty line by neighborhood. The only unexpected outlier was the neighborhood with over 50% below poverty line. After investigation, the neighborhood boundaries line up with the UCLA campus boundaries, so the numbers are being influenced by students without income.
johnr54321 commentedon Mar 27, 2020
It looks like you're continuing on this. Have you found anything you feel like we should incorporate into the site?
JRHutson commentedon Mar 28, 2020
@johnr54321 There are definitely neighborhoods where DUI arrests are more prevalent. If there is interest from the Councils, I could see it being integrated either as a point layer or heat map. I know the city also has a campaign meant to reduce pedestrian fatalities. That was another dataset that could be of interest to the target audience.
johnr54321 commentedon Apr 5, 2020
@JRHutson Do you have something visual (like maps, pins, or chart) on the DUI's? Also, was wondering if you had access to a dataset on cellphone movement.
JRHutson commentedon Apr 5, 2020
@johnr54321 I'll send you some examples via Slack. I'm assuming you're looking for general examples to get feedback from the NC contacts on what they would find useful.
I have not seen any datasets on CellPhone movement publicly available.
akhaleghi commentedon Oct 1, 2021
Get status update from Regan to see if this project is completed
JRHutson commentedon Oct 4, 2021
@akhaleghi what I had been working on is in a repo under my account. Happy to fork it to the Hack For LA account incase the code could be useful to anyone. I got it to a point that there was some insight but not a finalized presentation.
https://github.com/JRHutson/dui_analysis
28 remaining items
ExperimentsInHonesty commentedon Mar 29, 2024
None of the top comment are checked off. This issue needs a whole re-write so that someone could actually pick it up. I am happy to give a clinic in how to do that to @akhaleghi and @TaniaKhan04 . Please make an appointment with me.
ExperimentsInHonesty commentedon Mar 29, 2024
@loboramiro are you clear on what you need to do on this issue, or do you need us to do a rewrite first?
loboramiro commentedon Mar 30, 2024
@ExperimentsInHonesty I think a rewrite would be helpful
[-]Identify overall trends in DUI arrests by council region[/-][+]CoP: Data Science: Identify overall trends in DUI arrests by council region[/+]