Task 5: Get familiar with pgRouting

[dextroflask]

• Follow the workshop
• Workshop introduction
  • Do not use OSGeoLive. As a developer you should be able to follow the workshop with he installation done on task 3
  • Install other requirements
• Basic
  • Prepare data
    • Instead of city_routing use <your-git-nick>-routing
  • Pedestrian Routing
  • Vehicle Routing
  • SQL function
  • pl/pgsql function
• Make screenshots of your work, make sure that <your-git-nick>-routing is visible
• Put the link of this issue on a comment of the issue of task 1

[dextroflask]

Step 1: Prepare Data

---

Comparing OSM ID with ID Assigned by PGRouting :

---

[dextroflask]

Pedestrian Routing

Exercise 1 : Single Pedestrian Routing : From node 20979 to 717

---

Exercise 2 : Many Pedestrian to Same Destination :

---

Exercise 3 : Many Pedestrain Departing from same location :

---

Exercise 4 : Many Pedestrian going to different destination :

---

Exercise 5 : Combination of Routes

---

Exercise 6 : Time for many Pedestrians going to different destinations

Exercise 7 : Many Pedestrians going to different destinations summarizing the total cost per departure

[dextroflask]

Vehicle Routing

Exercise 1 : Vehicle Routing - going

---

Exercise 2 : Vehicle Routing - returning

---

Exercise 3 : Vehicle Routing when time is Money

---

Exercise 4 : Vehicle Routing without Penalization

---

Exercise 5 : Vehicle Routing with Penalization

[dextroflask]

SQL Function

Exercise 1 : Get Additional Information

---

Exercise 2 : Route Geometry (human readable)

---

Exercise 3 : Route Geometry ( binary )

---

Exercise 4 : Route Geometry Directionality

---

Exercise 5 : Using the Geometry

---

Exercise 6 : Function for an Application

---

Exercise 7 : Using the Function

---

[dextroflask]

pl/pgsql Functions

Exercise 1 : Create Vertices Table

---

Exercise 2 : Nearest Vertex

---

Exercise 3 : Nearest Vertex Function

---

Exercise 4 : Test nearest vertex function

---

Exercise 5 : Creating the main function

---

Exercise 6 : Using the main function

---