Is DuckDB the Secret to Unlocking Your GIS Potential?

In this video, @mehdio walks you through the absolute basics of working with geospatial data and introduces the DuckDB spatial extension. By the end of the video, you will create your own heatmap using DuckDB, Python, and MotherDuck for sharing and cloud scalability.

📓 Resources

➡️ Follow Us

0:00 Intro
0:56 Geospatial Basics
3:18 Tools you need
5:24 Building your first heatmap with Python and DuckDB
13:59 Wrapping up

#duckdbspatial #gis #geospatial #dataengineering

[rueclarkprod]

Thanks for sharing- particularly the Lonboard integration, python libraries converting to GeoJSON before rendering slows my workflows down so much. Often open geospatial data is supplied in formats other than GeoJSON- if you're planning to release more DuckDB geospatial content it would be cool to explore some of the other formats, particularly Shapefile and GeoPackage as the two other most common formats. Since GeoPackage is based on SQLite, DuckDB can attach the file as a database and read/write transactionally! I

[abc_cba]

Would we have full fledged projects as tutorials in the coming days?
Maybe, integrating Duck DB with Spark, Kafka, Apache Druid, Apache Pinot, etc?

I would love to see tutorials because, you're a genius tutor, I expect nothing less.

[GuglielmoCelata]

Thank you for the video. It’s so clear.
I signal that Lonboard has currently an issue (version 0.9 and 0.10) and it is impossible to see the maps.

[ricardomartinez]

Hello, let´s think about those organizations that have outputs in GEOPACKAGE. Would it be possible to see a video on how to perform a pipeline to convert geopackages to geoparquet efficiently, use basic spatial functions on DuckDB such as dissolve geometric features based on columns (group by, geometries), and store them on disk as geoparquets and geopackages ? Polygons geometries are challenging, as their geometry column can be huge.
Exporting back to geopackage is important because, as mention before, organizations still use geopackage, thus, they expect geopackages . Maybe this is a good use case. Thank you.

[zulhishamtan]

Thanks for the sharing the lonboard library. By the way, how to save the map as html file like folium

[gobajoseph]

Please add piste in parameters for audio translation