09-09, 09:00–12:00 (America/Chicago), South Classroom
pgRouting is a PostgreSQL extension that extends PostGIS extension for network routing.
I am here, want to go there, how do I do it?
This workshop will teach you the basics of using SQL for pedestrian and vehicle routing.
pgRouting is a PostgreSQL extension that extends PostGIS extension for network routing.
I am here, want to go there, how do I do it?
This 3-hour hands-on workshop will teach you the basics of using SQL for pedestrian and vehicle routing.
You'll learn how:
- To upload data and prepare it for routing.
- Use the data to route pedestrians and vehicles.
- Interact with PostGIS to get information of the route.
-
Prepare Data
1.1. Prepare the database
1.2. Get the Workshop Data
1.3. Upload data to the database
1.4. Chapter: Appendix -
Pedestrian Routing
2.1. pgr_dijkstra
2.2. pgr_dijkstraCost -
Vehicle Routing
3.1. Routing for vehicles
3.2. Cost manipulations -
SQL function
4.1. The application requirements
4.2. Preparing processing graphs
4.3. Geometry handling
4.4. Creating the Function
