FOSS4G - Blazing Fast Geospatial SQL in DuckDB - Isaac Brodsky

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