hackforla / hackforla/data-science

CoP: Data Science: Analyze correlations between metro locations and 311-data requests

Open
#107 34 comments 0 reactions 0 assignees View on GitHub
assigned complexity: missing epic feature: guide milestone: missing project duration: unknown project: metro 311 correlation role: CoP lead role: data analysis size: epic size: missing
Dominant language
Jupyter Notebook
Stars
33
Forks
22
PR merge metrics
No merged PRs in 30d

Description

### Overview
Investigate whether there are meaningful trends associated with metro stops and metro lines with regards to requests tracked by 311-data in LA County.

## Action Items
- [x] Define requirements for 311 data (adding notes to the resources section and discussing at the Data Science CoP meeting
- [x] Do you need a one-time or ongoing dump of the data?
- [x] Do you need subset of data (i.e. certain years) or the entire data set (approx. 4 million rows or 11 GB)?
- [x] If a subset is needed, please define subset characteristics (i.e. date range, etc.)
- [x] Do you need online access via an API or a download of data?
- [ ] Add dependency label and put in the icebox until 311 data is provided
- [x] Find available data sources and add to Resources section below
- [ ] Determine is this is one-time or ongoing project (and assign appropriate label)
- [x] Write one-sheet
- [ ] Define stakeholder
- [ ] Summarize project including value add
- [ ] Define project 6 month roadmap
- [ ] Detail history (if any)
- [x] Define tools to be used to visualize combined data
- [ ] Create issues for the following
- [x] EDA (Exploratory Data Analysis) of metro data
- [ ] Identify correlations between distance from metro stop and request type
- [ ] Determine if correlations observed are solely due to metro stop or are more broadly associated with population density or other factors
- [ ] Combine geolocation data for metro lines with district types
- [ ] Compare correlations/trends between different districts within each type
- [ ] Compare LA county data with other California counties, compare with district types within county. (Post MVP)
- [ ] Compare with statewide trends and within district types. (Post MVP)

## Resources
Information about 311 Data [here](https://github.com/hackforla/311-data)
Access 311 data [here](https://dev-api.311-data.org/docs#/default/get_report_reports_get)
http://geohub.lacity.org/datasets/metro-rail-lines-stops
https://developer.metro.net/docs/gis-data/overview/
District types issue: https://github.com/hackforla/data-science/issues/118

use 2019 data for 311
streetlights
crime
metrostops

tools
google colab, sklearn, pandas

### Work in progress

- [Progress summary- 311 data Project](https://docs.google.com/presentation/d/1-_aHHT8vqmi9eYivKjLmlZ7MkFUbl-2SDNUFlhEfk7o/edit#slide=id.g11faff46142_0_44)
-

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.