FOSS4G routing with pgRouting tools and OpenStreetMap road data

Important

The content of this page is outdated and is for archiving purposes only.

Presenters

• Claude Philipona (Camptocamp SA)
• Daniel Kastl (Georepublic UG and Georepublic Japan)

Further authors

• Frédéric Junod (Camptocamp SA)
• Anton Patrushev (Georepublic UG and Georepublic Japan)

Contents

• Introduction
  • Abstract
  • Description
• About pgRouting
• About Mapfish
• About OpenStreetMap
• Installation of pgRouting
  • Install required packages
  • Compile pgRouting core (with TSP and DD flag on)
  • Setup PostgreSQL
  • Create routing database
• Load your network data and create a network topology
  • Load the network data
  • Create network topology
  • Add indices
• pgRouting with Dijkstra algorithm
  • Shortest Path Dijkstra core function
  • Dijkstra Wrapper functions
• pgRouting with A-Star algorithm
  • Prepare routing table for A-Star
  • Shortest Path A-Star core function
  • Wrapper function WITH bounding box
• pgRouting with Shooting-Star algorithm
  • Prepare routing table for Shooting-Star
  • Shortest Path Shooting-Star core function
  • Wrapper function WITH bounding box
• osm2pgrouting data converter
  • How to install (Ubuntu 8.04)
  • How to use
• Advanced usage of pgRouting shortest path search

Workplace Access

• Download the compressed VMware image from http://download.osgeo.org/pgrouting/foss4g2008/ and extract the file
• Start VM Player and load the workshop virtual machine
• If root access is required, use

username: pgrouting
password: foss4g