spatial

Analyze spatial data with DuckDB spatial extension and Overture Maps.

Updated Apr 19, 2026

Search Tags:#DuckDB #GIS #spatial analysis #geographic data #Overture Maps

Ready to run

npx skills add https://github.com/vathymut/copilot-skills --skill spatial-vathymut

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: spatial
Source: https://github.com/vathymut/copilot-skills/tree/main/.github/skills/spatial
Command: npx skills add https://github.com/vathymut/copilot-skills --skill spatial-vathymut

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb, h3, httpfs, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the process of querying and analyzing spatial data, using DuckDB's spatial extension and Overture Maps' global dataset.

Core Features & Use Cases

Spatial Data Analysis: Perform operations like distance calculations, containment checks, and density analysis.
Data Conversion: Convert spatial file formats like GeoJSON, Shapefile, and GeoPackage.
Use Case: When you need to find the closest restaurant to a user's location or analyze the distribution of buildings in a city.

Quick Start

Use the spatial skill to find the nearest coffee shop to the coordinates 40.7128, -74.0060.

Frequently Asked Questions about spatial

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I perform spatial data analysis using DuckDB and Overture Maps?▼

Spatial data analysis using DuckDB and Overture Maps is facilitated by querying geographic datasets directly to perform distance calculations, containment checks, and spatial joins. It handles global geographic data for location-based operations.

Can I convert spatial file formats like GeoJSON and Shapefile with this approach?▼

Converting spatial file formats like GeoJSON, Shapefile, and GeoPackage is natively supported. You can load, transform, and export these geographic data formats directly within DuckDB to streamline your spatial data pipeline.

What's the best way to find the nearest point of interest to specific coordinates?▼

Finding the nearest point of interest to specific coordinates requires executing distance calculations against geographic data. Using DuckDB's spatial extension, you can query Overture Maps data to locate nearby buildings or restaurants efficiently.

Do I need to install specific extensions to run spatial joins in DuckDB?▼

Running spatial joins in DuckDB requires specific extensions including spatial, h3, and httpfs. These dependencies enable geographic data processing, hexagonal indexing, and direct remote file access for your spatial queries.

Does DuckDB support geographic data analysis for large global datasets?▼

DuckDB supports geographic data analysis for large global datasets by leveraging Overture Maps. It processes spatial queries, performs density analysis, and calculates containment across massive geographic scales efficiently.

What are the limitations of using DuckDB for geographic queries?▼

Limitations of using DuckDB for geographic queries depend on the spatial extension's capabilities for complex geometries. While it handles distance calculations and spatial joins well, highly specialized GIS topology operations may require dedicated geographic information systems.