FOSS4G - Blazing Fast Geospatial SQL in DuckDB - Isaac Brodsky

Project Geospatial

Isaac Brodsky discusses the integration of H3, an open-source hierarchical hexagonal grid system, with DuckDB, an analytical SQL database, to enhance geospatial data analysis. This combination enables efficient querying and manipulation of diverse datasets in real-time. Highlights 🚀 H3 is an innovative grid system from Uber for geospatial data analysis. 💻 DuckDB serves as a powerful, single-node SQL engine for high-performance analytics. 🔄 The H3 and DuckDB integration simplifies complex geospatial queries. 📊 DuckDB extensions enhance functionality, allowing seamless data manipulation. 🌐 Uses include real-time querying of Overture places data for points of interest. ⏱️ Demonstrates rapid data processing and visualization capabilities. 📦 Supports integration with cloud storage for efficient data management. For more content like this check out www.projectgeospatial.com #GeospatialAnalytics #DataScience #H3 #DuckDB #OpenSource #SQL #FOSS4G2024