Closed CharlotteJackson closed 3 years ago
Write SQL code to extract the relevant Citizen alerts data from the API responses
To help classify 911 calls as vehicle-only or pedestrian
check API structure, review Postgresql JSON functions
When we've got a feed set up from Citizen S3 JSONs to PostGIS DB
What is the Task
Write SQL code to extract the relevant Citizen alerts data from the API responses
Why do we want to do this
To help classify 911 calls as vehicle-only or pedestrian
How can I get started?
check API structure, review Postgresql JSON functions
Definition of Done
When we've got a feed set up from Citizen S3 JSONs to PostGIS DB