FOSS4G 2023 workshops

pgRouting Basic Workshop
2023-06-27, 09:00–13:00 (Europe/Tirane), UBT D / N113 - Second Floor

pgRouting (http://www.pgrouting.org/) is an open-source library that provides a variety of graph algorithms tools as an extension of a PostGIS (http://www.postgis.org/) enabled database on PostgreSQL.


About pgRouting:

pgRouting is an Open Source Software, available under the GPLv2 license and is supported and maintained by Georepublic, Paragon Corporation and a broad user community.
pgRouting is a part of OSGeo Community Projects of the OSGeo Foundation and included on OSGeoLive.

About Workshop:

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

Website: http://www.pgrouting.org

OSGeoLive: https://live.osgeo.org/en/overview/pgrouting_overview.html

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’.

Economist and Computer Scientist, pgRouting fan and developer.

Open Source Software advocate.

  • pgRouting project leader and developer since 2013 Including:
  • pgRouting,
  • pgRoutingLayers,
  • osm2pgRouting.
  • Google Summer of Code mentor since 2015
  • FOSS4G speaker since 2015
  • PSC member of OSGeoLive
  • PSC member of pgRouitng
  • PSC member of mobilityDB
  • Currently member of the Board of Directors of the OSGeo Foundation.