pgRouting Workshop Manual

“FOSS4G routing with pgRouting, OpenStreetMap road data and OpenLayers 3”, primarly written for the FOSS4G2013 Workshop.

Contents

• 1. Introduction
• 2. About
  • 2.1. pgRouting
  • 2.2. OpenStreetMap
  • 2.3. osm2pgrouting
  • 2.4. OpenLayers 3
• 3. Installation and Requirements
  • 3.1. pgRouting
  • 3.2. Workshop
  • 3.3. Add pgRouting Functions to database
  • 3.4. Data
• 4. Create a Network Topology
  • 4.1. Load network data
  • 4.2. Calculate topology
  • 4.3. Add indices
• 5. pgRouting Algorithms
  • 5.1. Shortest Path Dijkstra
  • 5.2. Shortest Path A*
  • 5.3. Multiple Shortest Paths with kDijkstra
• 6. osm2pgrouting Import Tool
  • 6.1. Create routing database
  • 6.2. Run osm2pgrouting
• 7. Advanced Routing Queries
  • 7.1. Weighted costs
  • 7.2. Restricted access
• 8. Writing a pl/pgsql Wrapper
  • 8.1. Return route with network geometry
  • 8.2. Visualize the result
  • 8.3. Simplified input parameters and geometry output
  • 8.4. Route between lat/lon points and return ordered geometry with heading
• 9. WMS server with GeoServer
  • 9.1. Connect to the administration page
  • 9.2. Create the layer
• 10. OpenLayers 3 Browser Client
  • 10.1. OpenLayers 3 introduction
  • 10.2. Creating a minimal map
  • 10.3. WMS GET parameters
  • 10.4. Select the start and final destination
  • 10.5. Clear the results