The pgRouting Workshop
2021-09-27, 14:00–18:00, Berta Cáceres

The workshop will cover basic functions based on the Dijkstra Algorithm to get a route.
Route's costs can be in distance units, in time units in money units.
Get some basic knowledge of what the back-end functions on the database should look like and create a small front end to use with the back-end functionality.
We will use the FOSS4G Argentina area with OSGeoLive 14.


The topics that we will cover:
- Installation of OSGeoLive
- Prepare data
- pgRouting algorithms
- Advanced routing queries
- Writing an SQL stored procedure
- Writing a pgsql-sql stored procedure
- Using QGIS


Authors and Affiliations

Rajat Shinde (1), Vicky Vergara (2),
(1) Indian Institute of Technology Bombay, India (2) Georepublic, México

Level

2 - Basic. General basic knowledge is required.

Requirements for the Attendees

Review the following
SQL from PosgreSQL:
- https://www.postgresql.org/docs/current/sql-select.html
- https://www.postgresql.org/docs/current/sql-createfunction.html
- https://www.postgresql.org/docs/current/sql-createview.html
pgRouting on OSGeoLive:
- https://live.osgeo.org/en/quickstart/virtualization_quickstart.html
- https://live.osgeo.org/en/quickstart/pgrouting_quickstart.html

Please keep handy a link to the pgRouting complete documentation
- https://docs.pgrouting.org/latest/en/index.html

Started participating in pgRouting as a translator in 2013, becoming the main developer in 2015 and also on the same year I officially became a member of the OSGeo community as a Charter Member.

(Ph.D Student, IIT Bombay)

(Charter Member, OSGeo)

(Ardent follower of open source geospatial, FOSS4G)

(Always Student, Sometimes Mentor)

(More, http://home.iitb.ac.in/~rajatshinde/)