FOSS4G - Blazing Fast Geospatial SQL in DuckDB

https://is1-ssl.mzstatic.com/image/thumb/Podcasts115/v4/9c/b6/c0/9cb6c025-e88f-6474-85ce-4b689ff7a07b/mza_717437012762022933.jpg/600x600bb.jpg

Project Geospatial

362 episodes

2 days ago

Project Geospatial is a non-profit media organization committed to growth, innovation and collaboration among academic, commercial and government partners in the geospatial industry. We believe a revolution is coming in geospatial technology – big data is democratizing, satellites are shrinking, and the science of where has never been more important to the health and future of our planet. We provide a leading voice in geospatial industry trends, insights and cross-industry applications to help inspire and conspire with the next generation of great geospatial ideas.

Technology

RSS

All content for Project Geospatial is the property of Project Geospatial and is served directly from their servers with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.

Technology

https://d3t3ozftmdmh3i.cloudfront.net/staging/podcast_uploaded_episode/2586904/2586904-1737316579834-8b9f55ce142ca.jpg

FOSS4G - Blazing Fast Geospatial SQL in DuckDB - Isaac Brodsky

Project Geospatial

26 minutes 43 seconds

1 year ago

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