pgRouting Basic Workshop
07-15, 09:00–13:00 (Europe/Sarajevo), PA02

pgRouting is an open-source library that provides a variety of graph algorithms tools as an extension of a PostGIS enabled database on PostgreSQL.

In this introductory workshop, the basic functionality of pgRouting by providing practical examples using OpenStreetMap road network data from Mostar, Bosnia-Herzegovina. It will cover topics starting from how to prepare the data, make pgRouting queries, work on the overloads of the functions.

The workshop will focus on the shortest path search with pgRouting in real road networks near the FOSS4G venue. It will cover the following topics:

  1. Installing pgRouting.
  2. Creating a routing topology.
  3. Using pgRouting algorithms.
  4. Importing OpenStreetMap road network data.
  5. Writing advanced queries.
  6. Writing a custom PostgreSQL stored procedure in ‘plpgsql’.

Bonus: If there's enough time and interest we can also apply pgRouting other use cases. eg. FTTH, etc

What topics do you plan to cover in your workshop? –
  • pgRouting
  • PostgreSQL
  • PostGIS
 Level of the workshop –

beginner

 Coding knowledge required? –

Not necessary

 Link to software source code repository –

https://github.com/pgRouting
Enock Seth Nyamador

Enock Seth Nyamador is a FOSS4G and Open Data Consultant and advocate. He is an active OpenStreetMap contributor and OSGeo Charter member, as well as a member of the OSGeo Marketing Committee and OSGeoLive PSC. He also participates in the Free software and Free content movements.

This speaker also appears in: