2022-08-26, 14:45–15:15 (Europe/Rome), Room Verde
For over a decade now osm2pgsql has been the standard tool for importing OpenStreetMap data into a PostgreSQL/PostGIS database for rendering of raster tiles and many other use cases. Thanks to several improvements in the last years centered around a flexible configuration language and new geoprocessing capabilities, osm2pgsql is now also a great base for creating a vector tile toolchain. It can easily handle imports of a small country in a few minutes as well as scale to a planet-sized database with minutely updates from OSM.
The talk will introduce some of the new features that allow you to customize the database table layout and contents. It will outline the few steps needed to create your very own custom vector tiles based on OpenStreetMap data. We'll see how you can use the configuration language to clean up OSM data on import and prepare it for fast access with a vector tile server like T-Rex.
Jochen Topf has been active in OpenStreetMap for many years as mapper and software developer. He is the author of the "Flex" output in osm2pgsql and maintainer of the Osmium framework and many other OSM related software. In his professional live he works as a software developer and consultant in the OSM and GIS world.