Task 5: Getting familiar with pgRouting

[bedupako12mas]

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

[bedupako12mas]

Step 1: Prepare data

Click to view screenshots


[bedupako12mas]

Step 2: Pedestrian Routing

Click to view screenshots

 ## Exercise 1: Single pedestrian routing

[bedupako12mas]

Step 3: Vehicle Routing

Click to view screenshots

## Routing for vehicles ### Exercise 1: Vehicle routing - going  ### Exercise 2: Vehicle routing - returning  ### Exercise 3: Vehicle routing when time is money  ## Cost Manipulations ### Exercise 4: Vehicle routing without penalization  ### Exercise 5: Vehicle routing with penalization  

[bedupako12mas]

Step 4: SQL Function

Click to view screenshots

## Preparing processing graphs ### Exercise 1: Creating a view for routing  ### Exercise 2: Limiting the road network within an area  ### Exercise 3: Creating a materialized view for routing pedestrians  ### Exercise 4: Testing the views for routing    ### Exercise 5: Get additional information  ## Geometry Handling ### Exercise 6: Route geometry (human readable)  ### Exercise 7: Route geometry (binary format)  ### Exercise 8: Route geometry directionality   ### Exercise 9: Using the geometry  ## Creating the Function ### Exercise 10: Function for an application   ### Exercise 11: Using the function        

[bedupako12mas]

Step 5: pl/pqsql function

Click to view screenshots

## Requirements for routing from A to B  ## The Vertex Table ### Exercise 1: Number of vertices     ### Exercise 2: Vertices on a table    ### Exercise 3: Nearest Vertex     ### Exercise 4: Nearest vertex function  ### Exercise 5: Test nearest vertex function     ## wrk_fromAtoB function ### Exercise 6: Creating the main function   ### Exercise 7: Using the main function