OSM data processing with PostgreSQL/PostGIS

Room: Hörsaal Ost

Sunday, 15:00


slides


Back to schedule
  • Jochen Topf

The PostgreSQL database with the PostGIS extension has always played an important role in the OpenStreetMap project. The main OSM database is a PostgreSQL database, tile rendering is most often done from a PostgreSQL database, data analysis and data transformations using current or historical OSM data can be done with PostgreSQL. But understanding what the database can and can not do isn't always easy. And there are a ton of tools, from osm2pgsql to Imposm to Osmosis to Osmium and beyond that "do things" with OSM and PostgreSQL databases. It can be daunting to understand what they all do and where their place in the larger OSM ecosystem is. This talk is an introduction into some of the concepts of SQL and geographical data in an SQL database as well as a whirlwind tour about uses of PostgreSQL in the OSM context. We'll talk about use cases from rendering, to data analysis to routing. We'll talk about the data models that enable those use cases and the software that implements them. And we'll also talk about where the limits are and what things can better be done outside the database. The audience will walk a way with an idea of how things fit together and how to approach their own projects using PostgreSQL.