2026-08-31 –, 603
pgRouting is an open-source extension for the PostgreSQL database and PostGIS extension that adds geospatial routing and network analysis capabilities.
In this workshop we will learn how create graphs and analyze for pedestrian and vehicles, and use them for routing them with the pgr_dijkstra function.
Introduction
- Basic
- Acknowledgments
- Software and Data Overview
Basic workshop
- Prepare Data
- Prepare the database
- Get the Workshop Data
- Upload data to the database
- Graphs
- The graph requirements
- Configuration from osm2pgrouting
pgr_extractVerticespgr_connectedComponents- Preparing the graphs
pgr_dijkstraCostMatrix- Pedestrian Routing
pgr_dijkstrapgr_dijkstraCost- Vehicle Routing
- Routing for vehicles
- Cost manipulations
- SQL function
- The function requirements
- Additional information handling
- Geometry handling
- Routing using points
- Requirements for routing lat,lon points
Need to have an OSGeo ID for connecting to the online OSGeoLive service from OSGeo.
What skills do participants require to have?:Basic SQL knowledge
Link to software source code:
Biography:
I am an Economist and Computer Scientist, pgRouting fan and developer.
Open Source Software advocate.
- pgRouting project leader and developer since 2013 Including:
- pgRouting,
- pgRoutingLayers,
- osm2pgRouting.
- Google Summer of Code mentor since 2015
- FOSS4G speaker since 2015
- PSC member of OSGeoLive
- Currently member of the Board of Directors of the OSGeo Foundation.