Schedule - PGConf.EU 2023
PostGIS and pgRouting: Extensions for spatial data in PostgreSQL
In modern applications, geographical and spatial data are rapidly gaining importance. This leads to the requirement to efficiently store and process such data within a database. The PostgreSQL extension PostGIS, is specially designed for handling geographical and spatial data, fulfills this requirement. Combining PostGIS with the pgRouting extension, results in a very powerful routing tool, all within a PostgreSQL database. We now have the ability to process and analyze spatial data, and we can find answers to questions such as "What is the shortest or the fastest route from Point A to Point B?".
Both PostGIS and pgRouting are open-source tools released under the GNU General Public License. Maintenance and development has been ensured and driven on by a large community for the past 23 years. These extensions, both can be activated directly within PostgreSQL, making the enhanced DB a highly suitable basis for a variety of applications.
In this talk, I will provide a brief introduction to PostGIS and pgRouting, show practical examples from my daily work with geographic data, and we will explore potential use cases for PostGIS and pgRouting.