Getting started with Open Street Map data can be an intimidating process. With so many data formats to choose from, how does one pick the correct one and get started? In this talk, I guide listeners through one possible way to organise and process this data using PostgreSQL and Python.
The talk starts off with an introduction of OSM data and how it's structured. From there, we learn how to import this data to a PostgreSQL database and learn about how this data is structured with the PostGIS extension. We'll go over some amazing open source tools that give us the ability to do this, specifically osmium and osm2pgsql.
Afterwards, I cover how to structure a Python project for analysing this data and show how this project structure can enable us to easily repeat and share our analysis projects. To close out the talk, I introduce an example use case.
I am originally from the United States (Portland, Oregon) but now live in Kiel, Germany. I recently completed a masters program at Kiel University called, "Sustainability, Society and the Environment" where I specifically focused on sustainable mobility in cities. Before that, I worked as a software engineer for several companies and have been programming in Python for close to 10 years now. Additionally, I am an amateur musician and started playing guitar at the age of 15.