1. Introduction

pgRouting adds routing functionality to PostGIS.

Please see the contents for full content of FOSS4G Prizren workshop. This workshop covers two levels for using pgRouting: Basic and Advanced.

1.1. Basic

will demonstrate the routing functionality by providing examples using OpenStreetMap road network data from Prizren. Covering topics from how to prepare the data, making routing queries, understanding the results, up to writing a custom ‘plpgsql’ function that can be integrated with other FOSS tools.

  • Installing pgRouting.

  • Creating a routing topology.

  • Importing OpenStreetMap road network data.

  • Using pgRouting algorithms.

  • Writing advanced queries.

  • Writing a custom PostgreSQL stored procedure in plpgsql


  • Workshop level: basic.

  • Previous knowledge: SQL (PostgreSQL, PostGIS)

  • Equipments: OSGeoLive (16.0)

1.2. Advanced

pgRouting is an extendible open-source library that provides a variety of tools for graph algorithms, this is not limited to routing vehicles. The advanced section covers several graph problems that can be solved using pgRouting.


  • Workshop level: Advanced.

  • Previous knowledge: SQL (PostgreSQL, PostGIS, pgRouting)

  • Equipments: OSGeoLive (16.0)

1.3. Aknowledments

Sponsored by

Paragon Corporation

Developers & presenters of FOSS4G Prizren workshop:

  • Vicky Vergara Is a freelance developer from Mexico. She’s the core developer of pgRouting project and GSoC Mentor. OSGeo Charter member.

  • Ramón Ríos Is a freelance developer from Mexico. Lead engenieer for ParkUpFront

Past and present tutors and developers

Daniel Kastl, José Ríos, Ko Nagase, Stephen Woodbridge, Swapnil Joshi, Rajat Shinde, Ramón Ríos, Rohith Reddy, Vicky Vergara

Past and present supporters

Georepublic, Paragon Corporation


This work is licensed under a Creative Commons Attribution-Share Alike 3.0 License.


1.4. Become a sponsor

The Linux Foundation Open Collective OSGeo Foundation