pgRouting Workshop

“FOSS4G routing with pgRouting”.

Contents

• 1. Introduction
• 2. About The Workshop
  • 2.1. pgRouting Overview
  • 2.2. osm2pgrouting Overview
  • 2.3. OpenStreetMap Overview
• 3. Installation
  • 3.1. OSGeoLive on a VirtualBox
• 4. Prepare Data
  • 4.1. Prepare the database
  • 4.2. Get the Workshop Data
  • 4.3. Upload Data to the database
  • 4.4. Chapter: Appendix
• 5. pgRouting Algorithms
  • 5.1. pgr_dijkstra
  • 5.2. pgr_dijkstraCost
• 6. Advanced Routing Queries
  • 6.1. Routing for Vehicles
  • 6.2. Cost Manipulations
• 7. Writing a SQL Stored Procedures
  • 7.1. The application requirements
  • 7.2. Geometry handling
  • 7.3. Creating a Function
• 8. Writing a pl/pgsql Stored Procedures
  • 8.1. Requirements for Routing from A to B
  • 8.2. The Vertex Table
  • 8.3. wrk_fromAtoB function
• 9. Using Qgis
  • 9.1. Set Up QGIS
  • 9.2. Add a postGIS Layer
  • 9.3. Format a Routing Layer
  • 9.4. Copy/Paste Format
  • 9.5. Save the project
• 10. WMS server with GeoServer
  • 10.1. Connect to the administration page
  • 10.2. Create the layer
• 11. OpenLayers Based Routing Interface
  • 11.1. OpenLayers introduction
  • 11.2. Creating a minimal map
  • 11.3. WMS GET parameters
  • 11.4. Select “start” and “destination”
  • 11.5. Clear the results
  • 11.6. Summary (full example)
• 12. Create a Network Topology
  • 12.1. Load network data
  • 12.2. Create a Routing Network Topology
  • 12.3. Verify the Routing Network Topology
  • 12.4. Analyze and Adjust the Routing Network Topology
• 13. Appendix: Workshop Solutions
  • 13.1. pgRouting Algorithms Solutions
  • 13.2. Advanced Routing Queries Solutions
  • 13.3. Solutions to Writing a SQL Stored Procedures Chapter
  • 13.4. Solutions to Writing a pl/pgsql Stored Procedures Chapter
• 14. Appendix: Installation
• 15. Appendix: osm2pgrouting Import Tool
• 16. Video Tutorials for Workshop
  • 16.1. Chapter 4
• 17. Internet Examples