FOSS4G 2025

pgRouting basic workshop
2025-11-18 , WF710

This basic workshops takes you by the hand to start using pgRouting's basic routing functionpgr_dijkstra.


  1. Prepare Data

    1.1. Prepare the database
    1.2. Get the Workshop Data
    1.3. Upload data to the database
    1.4. Chapter: Appendix

  2. Pedestrian Routing

    2.1. pgr_dijkstra
    2.2. pgr_dijkstraCost

  3. Vehicle Routing

    3.1. Routing for vehicles
    3.2. Cost manipulations

  4. Graph views

    4.1. The graph requirements
    4.2. pgr_extractVertices
    4.3. pgr_connectedComponents
    4.4. Preparing the graphs

  5. SQL function

    5.1. The application requirements
    5.2. Additional information handling
    5.3. Geometry handling
    5.4. Creating an SQL Function

Software engineer and postdoctoral researcher at the University of Hawaii.

This speaker also appears in:

I am an Economist and Computer Scientist, pgRouting fan and developer.

Open Source Software advocate.

  • pgRouting project leader and developer since 2013 Including the subproducts:
  • 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.
This speaker also appears in: