pgRouting Workshop

“FOSS4G routing with pgRouting”.

Workshop introduction

• 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

Basic

• 1. Prepare Data
  • 1.1. Prepare the database
  • 1.2. Get the Workshop Data
  • 1.3. Upload data to the database
  • 1.4. Chapter: Appendix
• 2. Pedestrian Routing
  • 2.1. pgr_dijkstra
  • 2.2. pgr_dijkstraCost
• 3. Vehicle Routing
  • 3.1. Routing for vehicles
  • 3.2. Cost manipulations
• 4. SQL function
  • 4.1. The application requirements
  • 4.2. Preparing processing graphs
  • 4.3. Geometry handling
  • 4.4. Creating the Function
• 5. pl/pgsql function
  • 5.1. Requirements for routing from A to B
  • 5.2. The Vertex Table
  • 5.3. wrk_fromAtoB function
• 6. Appendix: Basic workshop solutions
  • 6.1. Solutions to pedestrian
  • 6.2. Solutions to vehicle
  • 6.3. Solutions to sql_function
  • 6.4. Solutions to plpgsql_function

Advanced

• 1. Create a Network Topology
  • 1.1. Load network data
  • 1.2. Create a Routing Network Topology
  • 1.3. Verify the Routing Network Topology
  • 1.4. Analyze and Adjust the Routing Network Topology

United Nations Sustainable Development Goals

• 1. Data for Sustainable Development Goals
  • 1.1. Work Directory for pgRouting data manipulation
  • 1.2. Mumbai database
  • 1.3. Bangladesh database
  • 1.4. Appendix
• 2. Achieving Sustainable Development Goals with pgRouting
  • 2.1. History
  • 2.2. United Nations
  • 2.3. What are the Sustainable Development Goals?
  • 2.4. Target Audience
  • 2.5. Prerequisites for UN SDG Exercises
• 3. Good Health and Well Being
  • 3.1. Problem: Estimation of Population Served by Hospitals
  • 3.2. Pre-processing roads and buildings data
  • 3.3. Finding the roads served by the hospitals
  • 3.4. Calculating the total population served by the hospital
• 4. Affordable and Clean Energy
  • 4.1. Problem: Optimising the Electricity Distribution Network
  • 4.2. Pre-processing roads data
  • 4.3. pgr_connectedComponents for preprocessing roads
  • 4.4. Extract connected components of roads
  • 4.5. pgr_kruskalDFS
  • 4.6. Exercise 10: Find the minimum spanning tree
  • 4.7. Comparison between Total and Optimal lengths
  • 4.8. Further possible extensions to the exercise
• 5. Sustainable Cities and Communities
  • 5.1. Problem: City getting affected by rain or not
  • 5.2. Choose a city
  • 5.3. Pre-processing waterways data
  • 5.4. pgr_connectedComponents for preprocessing waterways
  • 5.5. Exercise 8: Get the Connected Components of Waterways
  • 5.6. Exercise 9: Creating buffer around the city
  • 5.7. Exercise 11: Finding the components intersecting the buffer
  • 5.8. Exercise 12: Get the rain zones
  • 5.9. Exercise 13: Create a union of rain zones
• 6. Appendix: OSGeo UN Challenge Workshop Solutions
  • 6.1. Solutions to Chapter 3: sdg3-health
  • 6.2. Solutions to sdg7-energy
  • 6.3. Solutions to sdg11-cities

Interaction with other software

• 1. Using Qgis
  • 1.1. Set Up QGIS
  • 1.2. Add a postGIS Layer
  • 1.3. Format a Routing Layer
  • 1.4. Copy/Paste Format
  • 1.5. Save the project
• 2. WMS server with GeoServer
  • 2.1. Connect to the administration page
  • 2.2. Create the layer
• 3. OpenLayers Based Routing Interface
  • 3.1. OpenLayers introduction
  • 3.2. Creating a minimal map
  • 3.3. WMS GET parameters
  • 3.4. Select “start” and “destination”
  • 3.5. Clear the results
  • 3.6. Summary (full example)

Examples from the Internet

• 1. Boost Dijkstra Example
• 2. Internet Examples
• 3. Wikipedia Dijkstra Example

Appendices

• 1. Appendix: Installation
• 2. Appendix: osm2pgrouting Import Tool
• 3. Video Tutorials for Workshop
  • 3.1. Chapter 4