Analyze MILLIONS of points in SECONDS (on your computer) with DuckDB for GIS

Video Description

🚀 Ready to move beyond desktop GIS? Step into the Spatial Lab: a global community for ambitious geospatial professionals who want to break out of outdated workflows and join the top 5% of the field. 👉 Join Spatial Lab: https://forrest.nyc/spatial-lab/ 🎓 Want structured, career-changing learning? 🚀 Modern GIS Accelerator: https://forrest.nyc/accelerator/ — master Python, Spatial SQL & cloud workflows in 2 weeks 🧭 Career Compass: https://forrest.nyc/career-compass/ — fast, practical steps to land the GIS role you want 🪄 AI Copilot for GIS: https://forrest.nyc/ai-copilot-for-gis/ — learn to integrate AI into your geospatial workflows & boost your productivity 📰 Weekly modern GIS insights: https://forrest.nyc ⚡️ Spots for the next live cohort and mentorship cycle are closing soon, join now to lock in your place and momentum. DuckDB is an incredibly powerful analytical database that can run right on your computer and allows you to analyze LOTS of data. Plus it is very easy to install and it now has support for GIS and geospatial analysis. This coding tutorial will walk you through the setup and different use cases for DuckDB for GIS 0:00 Intro 2:55 Setting up 5:52 Installing spatial and H3 extensions 10:27 Reading geospatial data 18:17 Native DuckDB geometries speed test 24:34 Using H3 and DuckDB in Python 27:42 Resources and wrap-up Download the data in the tutorials here: ➡️ NYC 311 Data: https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9 ➡️ NYC Neighborhoods Data: https://github.com/HodgesWardElliott/custom-nyc-neighborhoods 🔌 DuckDB spatial Extension: https://github.com/duckdblabs/duckdb_spatial 🔌 DuckDB H3 Extension: https://github.com/isaacbrodsky/h3-duckdb Guides and resources from the video: 🌎 Geospatial DuckDB from Mark Litwintschik: https://tech.marksblogg.com/duckdb-geospatial-gis.html ☠️ Big Data is Dead: https://motherduck.com/blog/big-data-is-dead/ 🐤 DuckDB for Beginners from @motherduckdb : https://www.youtube.com/watch?v=ZX5FdqzGT1E CONNECT WITH ME 📸 Instagram: https://www.instagram.com/matt_forrest/ 💼 LinkedIn: https://www.linkedin.com/in/mbforr/ 📧 Newsletter: https://forrest.nyc 🌐 Website: https://forrest.nyc Other courses to get started with GIS, spatial data science, and data science (affiliate links): Geographic Information Systems (GIS) Specialization from UC Davis: https://imp.i384100.net/n1Kyxo Spatial Data Science and Applications from Yonsei University: https://imp.i384100.net/9W6E6W Python for Everybody from University of Michigan: https://imp.i384100.net/BX3P31 Remote Sensing Image Acquisition, Analysis and Applications: https://imp.i384100.net/Xxe4Ay #gis #python #sql