Write the SQL code to unnest Twitter data from scanner feeds

[CharlotteJackson]

What is the Task

Extract the Tweet text, datetime, and reply text (if any) to enable geo-coding and matching to the 911 calls data

Why do we want to do this

To help classify 911 calls as vehicle-only or pedestrian

How can I get started?

Charlotte needs to review the json functions available in Postgresql

Definition of Done

When there's a script running on Ec2 that automatically unnests the streaming tweets being ingested into the S3 bucket

[CharlotteJackson]

script written, it just needs to be automated