Book

Spatial Data Management with DuckDB

From SQL Basics to Advanced Geospatial Analytics

by Qiusheng Wu · creator profile

Book website ↗Buy on Amazon ↗Download sample PDF ↓Message the author

Available translations

Unlock the power of DuckDB for modern geospatial analytics. This hands-on guide helps GIS professionals master efficient spatial data management, transforming massive real-world datasets into powerful insights using SQL, Python, and DuckDB’s spatial extension.

Table of contents

Part I: DuckDB Foundations

Getting Started with DuckDB
Essential SQL for Spatial Analysis
DuckDB Python Integration

Part II: Spatial Data Operations

Loading Spatial Data Formats
Exporting and Converting Spatial Data
Geometry Operations and Functions
Spatial Queries and Relationships
Advanced Spatial Joins
Interactive Data Visualization
Working with Vector Tiles and PMTiles

Part III: Real-World Geospatial Analytics

Analyzing the US National Wetlands Inventory
Analyzing Global Building Footprints
Analyzing NYC Taxi Data
Developing Interactive Dashboards with Voilà and Solara

$30

Minimum $25 · Suggested $30 · Max $35

Pay what you want above the minimum. Secure checkout via Stripe. You can re-download anytime from your dashboard.