3. Video Tutorials for Workshop¶
3.1. Chapter 4¶
Video for section 4.1: Prepare the database.
Video for section 4.2: Get the Workshop Data.
Video for section 4.3: Upload Data to the database.
-
Chapters
- 1. Prepare Data
- 2. Pedestrian Routing
- 3. Vehicle Routing
- 4. SQL function
- 5. pl/pgsql function
- 6. Appendix: Basic workshop solutions
- 1. Data for Sustainable Development Goals
- 2. Achieving Sustainable Development Goals with pgRouting
- 3. Good Health and Well Being
- 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
- Page
- « 2. Appendix: ...