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

Add CSV and Gzipped CSV output of Service Requests #1074

Closed
mattyweb opened this issue Apr 6, 2021 · 0 comments · Fixed by #1075
Closed

Add CSV and Gzipped CSV output of Service Requests #1074

mattyweb opened this issue Apr 6, 2021 · 0 comments · Fixed by #1075
Assignees
@mattyweb
Labels
Size: 5pt Can be done in 19-30 hours

Comments

@mattyweb
Copy link
Collaborator

mattyweb commented Apr 6, 2021

Currently there isn't a good way to get all the service requests out of the database. While it's technically possible to iterated through all the data from the /requests endpoint this isn't a very efficient approach for 6+ million records.

Being able to efficiently pull all the requests into pandas will be hugely useful for reporting and AI/ML activities.
@mattyweb mattyweb added the Size: 5pt Can be done in 19-30 hours label Apr 6, 2021
@mattyweb mattyweb self-assigned this Apr 6, 2021
mattyweb added a commit that referenced this issue Apr 6, 2021
@mattyweb
Add CSV and Gzipped CSV output of Service Requests
bb3ac47 
Fixes #1074
@mattyweb mattyweb mentioned this issue Apr 6, 2021
Merged
mattyweb added a commit that referenced this issue Apr 6, 2021
@mattyweb
Add CSV and Gzipped CSV output of Service Requests
58cfd40 
Fixes #1074
mattyweb added a commit that referenced this issue Apr 7, 2021
@mattyweb
Add CSV and Gzipped CSV output of Service Requests
55d64de 
Fixes #1074
@mattyweb mattyweb added this to the Initial v2 Launch milestone Apr 7, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mattyweb mattyweb

Labels
Size: 5pt Can be done in 19-30 hours
Projects
P: 311: Project Board
Status: Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add CSV and Gzipped CSV output of Service Requests hackforla/311-data
1 participant
@mattyweb