FOSS4G 2024 Workshop

pgRouting basic workshop
12-02, 09:00–13:00 (America/Belem), Room Açaí (C Block)

Learn the basics of pgRouting.
Representing a city as a graph for pedestrians and vehicles.


  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. SQL function

    4.1. The application requirements
    4.2. Preparing processing graphs
    4.3. Geometry handling
    4.4. Creating the Function

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.