pgRouting Workshop

“FOSS4G routing with pgRouting”.

Workshop introduction

• 1. Introduction
  • 1.1. Basic
  • 1.2. Advanced
  • 1.3. Aknowledments
  • 1.4. Become a sponsor
• 2. OSGeoLive Installation
  • 2.1. Install VirtualBox.
  • 2.2. OSGeoLive on a VirtualBox
  • 2.3. Ubuntu installation
• 3. Software and Data Overview
  • 3.1. pgRouting Overview
  • 3.2. osm2pgrouting Overview
  • 3.3. OpenStreetMap Overview

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. Graph views
  • 4.1. The graph requirements
  • 4.2. pgr_extractVertices
  • 4.3. pgr_connectedComponents
  • 4.4. Preparing the graphs
• 5. SQL function
  • 5.1. The application requirements
  • 5.2. Additional information handling
  • 5.3. Geometry handling
  • 5.4. Creating the Function
• 6. pl/pgsql function
  • 6.1. Requirements for routing from A to B
  • 6.2. The Vertices Table
  • 6.3. wrk_fromAtoB function

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. PostreSQL basics
  • 3.3. Preparing roads and buildings data
  • 3.4. Find the roads served by the hospitals
  • 3.5. 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_kruskalDFS
  • 4.4. Exercise 3: Find the minimum spanning tree
  • 4.5. Comparison between Total and Optimal lengths
  • 4.6. 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. Prepare the database
  • 5.4. Processing waterways data
  • 5.5. Exercise 6: Get the Connected Components of Waterways
  • 5.6. Exercise 8: Finding the components intersecting the buffer
  • 5.7. Exercise 9: Get the rain zones
  • 5.8. Exercise 10: Create a union of rain zones

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)
• 4. Create a Network Topology
  • 4.1. Load network data
  • 4.2. Create a Routing Network Topology
  • 4.3. Verify the Routing Network Topology
  • 4.4. Analyze and Adjust the Routing Network Topology

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