Dynamic Aggregations With pg_tileserv
2025-11-04 , Lake Fairfax

Learn how PostgreSQL, PostGIS, and pg_tileserv can power dynamic, filterable geospatial visualizations at scale. This talk will demonstrate how function layers can be used to generate interactive aggregations, supporting on-the-fly visualization to enhance data exploration.


Mapping applications sometimes need to visualize millions of data points without sacrificing performance or user interactivity. In this talk, we will share a real-world use case where PostgreSQL, PostGIS, and pg_tileserv were combined to create dynamic, filterable aggregation layers. Using function layers, we built a simple stack that supports on-the-fly visualizations, allowing users to explore data with responsive, interactive aggregations. I’ll walk through the design choices, including hex bins, square grids, and dot grids, and discuss the benefits of dynamic filtering for real-time data exploration. Whether you're building a data-heavy GIS application or looking to enhance your digital cartography toolkit, this talk will provide practical insights and code snippets to tackle similar challenges.

Brad Andrick is a Senior Software Engineer at Earth Genome, where he builds software at the intersection of geospatial technology, AI, and user experience to bridge Earth data with real-world decision-making. With over a decade of experience in digital cartography, UI/UX, and full-stack development, Brad has worked with startups, nonprofits, government agencies, and Fortune 500 companies to deliver impactful geospatial applications. His current work aims to turn complex environmental data into insights that support a more sustainable and resilient future.