1. Introduction

Abstract

pgRouting adds routing functionality to PostGIS. This introductory workshop will demonstrate the routing functionality by providing practical examples using OpenStreetMap road network data. It will be covering topics starting from preparing the data, making routing queries, writing custom ‘plpgsql’ functions up to integrating pgRouting with other FOSS4G tools.

Road networks navigation require complex graph algorithms. pgRouting is an extendible open-source library that provides a variety of tools for graph algorithms, including shortest path search, as an extension of PostgreSQL and PostGIS.

The workshop will focus on real road networks of the FOSS4G Firenze surrounding area. It will cover the following topics:

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

Please see the contents for full content of this workshop.

Prerequisites

  • Workshop level: intermediate.

  • Attendee’s previous knowledge: SQL (PostgreSQL, PostGIS)

  • Equipments: This workshop uses OSGeoLive (15.0)

Authors

Alphabetical Order:

  • Daniel Kastl is founder and CEO of Georepublic and works in Germany and Japan. He is moderating and promoting the pgRouting community and development since the beginning of the project, and he’s an active OSM contributor in Japan. OSGeo Charter member.

  • Ko Nagase works at Georepublic and works in Japan. tests of pgRouting project on Windows and Mac OSX environment. One of the contributors of pgRoutingLayers for QGIS. OSGeo Charter member.

  • Stephen Woodbridge works at the greater Boston, MA area. He was a pgrouting PSC member and developer. He develops solutions for mapping, geocoding, reverse geocoding, routing and processing of remote sensing imagery. OSGeo Charter member.

  • Vicky Vergara works at Georepublic and works in Mexico. She’s the core developer of pgRouting project and GSoC Mentor. OSGeo Charter member.

License

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

../_images/license.png

Supported by

Georepublic Paragon Corporation