Everyone talks about hexagons, few actually run them at scale. In this session I’ll walk through how we built real-world data pipelines on top of PostGIS and H3, handling rasters, road networks, admin boundaries, and noisy global datasets. No hype: just SQL functions, ETL patterns, and lessons learned when hexagons meet terabytes. If you care about population grids, isochrones, coverage models, or how to not blow up your database with multi-resolution rollups, this talk is for you.

Speaker:
Darafei Praliaskouski, Maumap.com

More than 20 years ago, IGN, the reference public operator for geographic and forest information in France, made a strategic decision to adopt PostgreSQL as its primary database engine for the central geographical database, complemented by its spatial extension, PostGIS. This pioneering choice, driven by the need for a robust, open-source solution capable of handling large-scale and complex geospatial data, laid the foundation for a long-term commitment to open standards and scalable technologies.

This talk will revisit the motivations behind that initial decision, highlighting the early use cases and technical challenges faced at that time.

Speaker:
Cedric Duprez, IGN

In this talk, we share how we built geospatial embeddings directly into Geobase.app, our geospatial backend. By extending PostGIS with PGVector, we enabled semantic search and similarity queries over maps, rasters, and vector datasets. We’ll walk through the technical design choices from embedding generation to storage and retrieval and show how these capabilities power real-world use cases such as neighborhood similarity, environmental monitoring, and AI-driven geospatial assistants. The session will highlight lessons learned in integrating modern AI/ML methods with a Postgres-native stack, making advanced retrieval workflows accessible to developers and analysts.

Speaker:
Shoaib Burq, geobase.app

NIBIO has been using PostGIS Topology for many years, and I think we’re starting to gain some experience in how to take advantage of its strengths and overcome some of its weaknesses. Let’s look at how we’re doing this and what results we’re getting from it.

Speaker:
Lars Aksel Opsahl, NIBIO.NO

Developed as separate systems for analytics and transactions, Snowflake now unites data workloads with their newest offering, Snowflake Postgres. Let’s look at how you can use PostGIS (from any host) and Snowflake together. We’ll look at how to connect data from PostGIS to Snowflake and even show off how to use both together in projects using QGIS and more.

Speaker:
Fawad Qureshi, Snowflake

Often in geospatial, we focus on details, missing the bigger picture. Building efficient workflows, using PostgreSQL, Python, Blender, QGIS, and open-source tools, helps tell data stories about interconnected issues like deforestation and pollution, examining urban form, morphometrics, social demographics, and climate risk.

Speaker:
Bonny P. McClain, Grapheme Consulting, Inc,

Climate datasets are often massive, multidimensional, and complex — ranging from satellite observations to station-based indicators. This talk will demonstrate how PostGIS, combined with the H3 hexagonal grid system, can unlock new ways of managing, analyzing, and visualizing climate data. We’ll explore workflows for storing gridded datasets in PostGIS, aggregating drought indices like SPI or NDVI into H3 cells, and enabling scalable spatial queries for drought monitoring, exposure mapping, and climate risk assessment. The session highlights real-world use cases and shows how spatial databases can bridge the gap between raw climate data and actionable insights.

Speaker:
Alper Dincer, Bergmen Ltd.

Explore how PostGIS and PostgreSQL can be leveraged to optimize sales distribution, routing, and performance monitoring in Kenya’s GSM telecommunication market. The focus is on a location intelligence system developed to support Sales Commandos—mobile sales agents who distribute SIM cards and airtime across multiple outlets and markets.

Speaker:
Adam Kipkemei, Telkom

PostGIS has long been the backbone of spatial databases, but the rise of AI is transforming how we query and interact with maps. In this talk, Mamata Akella and Jaime Sánchez from Felt will show how PostGIS can be paired with AI through natural language and the use of clever system prompts and structured evaluations so that LLMs can think spatially. They will share how Felt ( a collaborative, cloud-native GIS platform and a new Snowflake partner) leverages PostGIS to enable teams to build, test, and refine AI-driven mapping workflows together. Attendees will see how evaluating and improving LLMs’ understanding of maps and PostGIS operations can unlock more reliable, domain-specific results, while broadening the impact of PostGIS across organizations.

Speakers:
Jaime Sanchez & Mamata Akella, Felt

Points, lines, and polygons in a database aren’t cool. Rasters in a database may be even less cool. You know what’s cool? Transforming PostGIS into a Magic Answer Machine. In this talk we’ll show not only how to access and use Data That Lives Somewhere Else but also analyze and understand that data by dynamically accessing some of the AI models you both love and fear. We’ll be doing all of this while living inside the PostGIS database and using just SQL to access an ever-expanding universe of outside tools and data.

Speaker:
Brian Timoney, IQGeo

Explore how PostGIS and Apache Sedona enable scaled spatial SQL workloads. Learn to process data from various sources, transfer PostGIS knowledge to Sedona, and push results back to PostGIS. This empowers cloud-native geospatial workflows and AI applications.

Speaker:
Matt Forrest, Wherobots

Osm2pgsql imports OpenStreetMap (OSM) data into a PostGIS database and keeps it up to date. This flexible tool allows on-the-fly transformations, cleaning, filtering, and normalization using Lua scripting to fit database schemas for projects and analysis.

Speaker:
Jochen Topf, OpenStreetMap

An exploration of distance isochrones for epidemiology, streamlining roadway access disparity identification for public health emergencies. This project uses PostGIS, PGRouting, and OpenStreetMap data to visualize access patterns via Dijkstra routing, with a focus on epidemiological applications.

Speaker:
Samuel Mather, Mastery School of Hawken

PostGIS opened eyes to SQL’s magic, fulfilling Postgres’s vision. Many extensions followed, often leveraging PostGIS. This presentation will showcase PostgreSQL’s capabilities with PostGIS and other extensions, demonstrating features impossible elsewhere. It will also explore necessary PostgreSQL enhancements for PostGIS and other extensions to reach new heights.

Speaker:
Regina Obe, Paragon Corporation

PostGIS plays a crucial role at State Farm, powering our geospatial platform that serves thousands of daily users Our system processes millions of geospatial requests per day, enabling us to answer the question of where. Today, I’m excited to share how we leverage PostGIS at State farm and the impact it has had on our organization.

Speaker:
Michael Keller, State Farm

Making good maps is hard. Learn ways to help your maps communicate better. The talk will focus on visual communication concepts and give examples in QGIS.

Speaker:
Michele Tobias, UC Davis DataLab

Building Agentic Experiences with PostGIS and CARTO in Snowflake. Learn to create geospatial reasoning within Snowflake, grounding LLMs with PostGIS for accurate analysis. Integrate CARTO for intelligent, location-aware applications combining natural language and powerful spatial data.

Speaker:
Ryan Miller, CARTO

pg_lake is a new open source extension connecting Postgres to object storage. It has robust geospatial support for working directly with Shapefiles, GeoJSON, and GeoParquet. We’ll look at pg_lake, how it works, and see a few demos of working with geospatial data in S3.

Speaker:
Elizabeth Christensen, Snowflake

Hydraulic models typically utilize conceptual stream centerlines to represent channel sections via straight lines. This presentation will show how linear referencing using PostGIS can duplicate a published stream dataset via ogr_fdw connections to an Excel spreadsheet and a File GeoDatabase to exactly mimic the stream reference to the hydraulic model.

Speaker:
Bruce Rindahl, Mile High Flood District

AI agents, already used for SQL, will soon write, execute, and interpret spatial queries, iterating multiple times to deliver finished work. See how AI agents leverage PostGIS for spatial data, drawing from experience building agents in QGIS and Mundi.ai.

Speaker:
Brendan Ashworth, Bunting Labs

PostGIS releases once a year, and each year brings a few notable new features or enhancements. The projects surrounding PostGIS, like GEOS, Proj, and PostgreSQL are also advancing, and this talk will highlight notable new features in those projects too.

Speaker:
Paul Ramsey, Snowflake