Task 5: Get familiar with pgRouting

[KC1706]

• 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

[KC1706]

1.Prepare Data

Downloaded data form OSGeoLive website

Upload Data to Database

List of Relations

[KC1706]

2. Pedestrian Routing:-

Get the vertex identifiers

Exercise 1 [Single Pedestrian Routing]:-

Exercise 2 [Many Pedestrians going to the same destination]:-

Exercise 3 [Many Pedestrians departing from the same location];-

Exercise 4 [Many Pedestrians going to different destinations]:-

Exercise 5 [Combination of routes]:-

Exercise 6 [Time for many Pedestrians going to different destinations]:-

[KC1706]

3. 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]:-

Exercise 6 [Time in seconds of penalized route using a view]:-

[KC1706]

4.SQL function

Exercise 1: Get additional information

Exercise 2: Route geometry (human readable)

Exercise 3: Route geometry (binary format)

Exercise 4: Route geometry directionality

Exercise 5: Using the geometry (azimuth)

Exercise 6: Using the function

[KC1706]

4.Routing Using Points

Exercise 1: Get the nearest edge

Exercise 2: Point routing

Exercise 3: Creating the point routing function

Exercise 4: Using wrk_withPoints