Skip to article frontmatterSkip to article content
Site not loading correctly?

This may be due to an incorrect BASE_URL configuration. See the MyST Documentation for reference.

Spatial Data Management with DuckDB

image image

Introduction

Welcome to the official website for Spatial Data Management with DuckDB: From SQL Basics to Advanced Geospatial Analytics. This website contains all the code examples featured in the book, designed to help you learn and apply DuckDB for geospatial analysis.

Get the Book

PDF and EPUB Editions

Cite the Book

If you use this book in your research or teaching, please consider citing it as follows:

Wu, Q. (2025). Spatial Data Management with DuckDB: From SQL Basics to Advanced Geospatial Analytics. Independently published. PDF edition ISBN 979-8993859705; Print edition ISBN 979-8274710572. https://duckdb.gishub.org

book cover

Table of Contents

How to Run Code Examples

The code examples are organized into folders, each corresponding to a chapter in the book. The code examples are written in Python and can be run using MyBinder, Google Colab, or Docker.

Using MyBinder

The code examples can be run using MyBinder.

image

Using Google Colab

The code examples can be run using Google Colab.

image

Video Tutorials

Complementing the written content, this book is supported by a comprehensive series of video tutorials that walk through key concepts and provide additional examples: https://tinyurl.com/duckdb-spatial-videos.

The videos are designed to complement, not replace, the written material. They’re particularly helpful for:

The playlist is organized to follow the book’s structure. You can watch them in order as you progress through the book, or jump to specific topics as needed.

The videos were created in Fall 2023 when I was teaching the Spatial Data Management course at the University of Tennessee. Although the course has concluded, the videos remain relevant and can be used as a reference for the book. Additional videos will be added in the future.

About the Author

Dr. Qiusheng Wu is an Associate Professor in the Department of Geography & Sustainability at the University of Tennessee, Knoxville. He is also an Amazon Scholar. Dr. Wu’s research focuses on advancing open-source geospatial analytics through cloud computing and GeoAI. He is the creator and maintainer of several widely used open-source Python packages, including Geemap, Leafmap, SAMGeo, and GeoAI, which integrate cloud-based geospatial platforms with AI-powered analysis and visualization. Dr. Wu’s work bridges remote sensing, Earth observation, and artificial intelligence to make large-scale geospatial data more accessible, reproducible, and intelligent for researchers, educators, and practitioners worldwide. His open-source projects can be found on GitHub at https://github.com/opengeos.

This book embraces the principles of open science and open education. To support transparency, learning, and reuse, the code examples in this book are released under a Creative Commons Attribution 4.0 International (CC BY 4.0) license. This means you are free to copy, modify, and distribute the code, even for commercial purposes, as long as appropriate credit is given.

Please attribute code usage by citing the book or linking to the GitHub repository:

Wu, Q. (2025). Spatial Data Management with DuckDB: From SQL Basics to Advanced Geospatial Analytics. Independently published. PDF edition ISBN 979-8993859705; Print edition ISBN 979-8274710572. https://duckdb.gishub.org

While the code is freely available, the text, figures, and images in this book are copyrighted by the author and may not be reproduced, redistributed, or modified without explicit permission. This includes all written content, custom diagrams, and embedded visualizations unless otherwise noted.

If you wish to reuse or adapt any non-code material from the book (for example, for teaching, presentations, or publications), please contact the author to request permission.

This dual licensing approach helps balance open access to learning materials with the protection of original creative work. Thank you for respecting these terms and supporting the open-source geospatial community.

Preface
Preface