Querying OpenStreetMap Changesets with Amazon Athena

[This is a cross-posting with MaptimeMileHigh! Please only RSVP once either here or there.]

Did you know that OSM data is available as an open dataset on Amazon Web Services? Updated weekly, the files are transcoded into the .orc format whichcan be easily queried by Amazon Athena (PrestoDB). These files live on S3 and anyone can create a database table that reads from these files, meaning no need to download or parse any OSM data, that part is done!

Jennings Anderson is going to walk us through how to do this, with a focus on querying changesets in OSM. Yep, now you can investigate the records of how OSM data has been changing with many implications for research.

You will not want to miss this presentation!

For suggestions on what you'd like to see Jennings take a deeper dive on querying, please post ideas on our (MaptimeMileHigh) slack channel. Message Diane if you're not already part of that space!

For more background, see Jennings' post here: https://www.openstreetmap.org/user/Jennings%20Anderson/diary/394762

See you in 2021! Let's welcome this new year!!!

(p.s. We're staying virtual until explicitly noted. Register to see the zoom link and the passcode for this event will be in the comments the day of!)