No video of the event yet, sorry!

The PostgreSQL database server, with the PostGIS extension, supports storing and managing geospatial data such as points, lines, and polygons. This capability enables effective interaction with and analysis of GIS data. For example, it can ingest OpenStreetMap (OSM) data, which can then be visualized on maps or used in various applications. These applications include understanding driving patterns, gathering intelligence about specific locations, generating administrative hierarchies for countries, and much more. I would like to demonstrate various tools and extensions that can be used to load OSM data and how to apply various GIS functions to this data using real-world use cases.