1. Introduction

Abstract

pgRouting adds routing functionality to PostGIS. This introductory workshop will show you how. Providing practical examples using OpenStreetMap road network data. Covering from how to prepare the data, make routing queries, write a custom ‘plpgsql’ functions up to draw your route in a web-mapping application. In other words, integrating pgRouting with other FOSS4G tools.

Navigation for road networks requires complex routing algorithms that support turn restrictions and even time-dependent attributes. pgRouting is an extendible open-source library that provides a variety of tools for shortest path search as extension of PostgreSQL and PostGIS.

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

  • Installing pgRouting,
  • Creating a routing topology,
  • Using pgRouting algorithms,
  • Importing OpenStreetMap road network data,
  • Writing advanced queries,
  • Writing a custom PostgreSQL stored procedure in ‘plpgsql’,
  • Building a simple browser application,
  • Building a basic map interface with OpenLayers 3.

Prerequisites

  • Workshop level: intermediate.
  • Attendee’s previous knowledge: SQL (PostgreSQL, PostGIS), Javascript, HTML.
  • Equipments: This workshop uses OSGeo Live (Version 11.0)

Presenters and 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 iMaptools in the greater Boston, MA area. He is 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 iMapTools