pgRouting Workshop Manual

“FOSS4G routing with pgRouting tools, OpenStreetMap road data and GeoExt”, primarly written for the FOSS4G2011 Workshop.

Contents

• 1. Introduction
• 2. About
  • 2.1. pgRouting
  • 2.2. OpenStreetMap
  • 2.3. osm2pgrouting
  • 2.4. GeoExt
• 3. Installation and Requirements
  • 3.1. pgRouting
  • 3.2. Workshop
  • 3.3. Database from Template
  • 3.4. Load Functions
  • 3.5. Data
• 4. osm2pgrouting Import Tool
  • 4.1. Create routing database
  • 4.2. Run osm2pgrouting
• 5. Create a Network Topology
  • 5.1. Load network data
  • 5.2. Calculate topology
  • 5.3. Add indices
• 6. Shortest Path Search
  • 6.1. Dijkstra
  • 6.2. A-Star
  • 6.3. Shooting-Star
• 7. Advanced Routing Queries
  • 7.1. Weighted costs
  • 7.2. Restricted access
• 8. Server side script with PHP
  • 8.1. Closest edge
  • 8.2. Routing query
  • 8.3. GeoJSON output
• 9. GeoExt Browser Client
  • 9.1. Routing method selection
  • 9.2. Select the start and final destination
  • 9.3. Call and receive data from web service
  • 9.4. Trigger the web service call
  • 9.5. What’s next ?
  • 9.6. Full source code