hackforla / hackforla/lucky-parking

Add coordinates for missing lat/lon

Open
#164 8 comments 0 reactions 0 assignees View on GitHub
complexity: medium feature: database missing: milestone role: data scientist size: 2pt
Dominant language
Jupyter Notebook
Stars
37
Forks
60
Avg merge
13h 32m
Merged PRs (30d)
5

Description

### Overview
We need to add lat/long coordinates to the data set we get from the city so that a higher % of parking violations and summary statistics display on the map.

### Details
Around 15% of data points do not have coordinates. Analyze these missing data points and identify what % we could reliably tag.

### Action items
- [x] Download the data and remove the data with lat/long to make the new data set
- [ ] Analyze dataset and missing coordinate records
- [ ] Geocode using address information in batches to avoid paid tier
- [ ] Save code and analysis as Jupyter notebook in Notebooks folder of citation analysis branch
- [ ] Save dataset to Google Drive (add Drive link in Resource section below)
- [ ] Map the data
- [ ] Identify which addresses did not get properly geocoded
- [ ] Discuss results with the team

### Resources/Instructions

- Citation analysis branch for getting access to Lucky Parking's cleaned data README: https://github.com/hackforla/lucky-parking/tree/citation-analysis
- Notebooks folder: https://github.com/hackforla/lucky-parking/tree/citation-analysis/notebooks
- Google Drive Folder for Lat / Long analysis: https://drive.google.com/drive/u/0/folders/1IgPOBy86s3kcDJ5cG3afqoTz4BtRwjdX
- Possible package to use: https://geocoder.readthedocs.io/
- Tutorial: https://towardsdatascience.com/geocode-with-python-161ec1e62b89

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.