(Webinar) Routing with PostGIS and OpenStreetMap

I am excited to be presenting Routing with PostGIS and OpenStreetMap at PostgresConf South Africa 2021! The talk is scheduled for Tuesday October 5, 2021, 3:10 PM SAST (7:10 AM MST).

This page has the resources used during this session.

Downloads for session

Scripts used for the demo:

• PgOSM Flex routing queries (.sql)

Links

Links from the slides in the order they appeared.

• https://blog.rustprooflabs.com/2020/11/postgis-trajectory-intro
• https://docs.pgrouting.org/3.1/en/pgr_nodeNetwork.html
• https://docs.pgrouting.org/latest/en/pgr_dijkstra.html
• https://www.youtube.com/watch?v=GazC3A4OQTE
• https://github.com/rustprooflabs/pgosm-flex
• https://github.com/rustprooflabs/pgosm-flex/blob/main/flex-config/helpers.lua#L284-L316
• https://osm2pgsql.org/doc/manual.html#type-conversions
• https://github.com/rustprooflabs/pgosm-flex#basic-docker-usage
• https://github.com/rustprooflabs/pgosm-flex#basic-docker-usage
• https://download.geofabrik.de/
• https://download.geofabrik.de/north-america/us/district-of-columbia-latest.osm.pbf
• https://blog.rustprooflabs.com/category/pgosm-flex
• https://github.com/rustprooflabs/srid-bbox
• https://postgis-osm.com/