2022-08-23, 09:00–13:00 (Europe/Rome), 211
pgRouting (http://www.pgrouting.org/) is an open-source library that provides a variety of graph algorithms tools as an extension of a PostGIS (http://www.postgis.org/) enabled database on PostgreSQL.
pgRouting is an Open Source Software, available under the GPLv2 license and is supported and maintained by Georepublic (http://georepublic.info/), iMaptools (http://imaptools.com/), Paragon Corporation (https://www.paragoncorporation.com/) and a broad user community.
pgRouting is a part of OSGeo Community Projects (http://wiki.osgeo.org/wiki/OSGeo_Community_Projects) of the OSGeo Foundation (https://www.osgeo.org/) and included on OSGeoLive (https://live.osgeo.org/en/overview/pgrouting_overview.html).
Have you ever thought about how the expected time of arrival of the pizza is computed or how the rivers are channeled to minimize the flow of floodwater?, then you might find some ideas for solving this kind of problems using pgRouting. In this introductory workshop, you will learn the basic functionality of pgRouting by providing practical examples using OpenStreetMap (http://www.openstreetmap.org/) road network data. It will cover topics starting from how to prepare the data, make pgRouting queries, write a custom ‘plpgsql’ function on the database up to draw your results in a web-mapping application. In other words, up to integrating pgRouting with other FOSS4G tools.
The workshop will focus on the shortest path search with pgRouting in real road networks near the FOSS4G venue. It will cover the following topics:
1. Installing pgRouting.
2. Creating a routing topology.
3. Using pgRouting algorithms.
4. Importing OpenStreetMap road network data.
5. Writing advanced queries.
6. Writing a custom PostgreSQL stored procedure in ‘plpgsql’.
Prerequisites * Workshop level: intermediate. * Attendee’s previous knowledge: SQL (PostgreSQL, PostGIS). * Equipment: This workshop uses OSGeoLive (Version 15.0)
Exploring new opportunities and responsibilities.
Ph.D. Candidate - Indian Institute of Technology Bombay, India, Prime Minister's Research Fellow.
Vice President - OSGeo Board of Directors
OSGeo Google Summer of Code Organization Administrator
Love to play flute and read books. :)