spatial
Spatial handles geographic questions by combining DuckDB's spatial functions with Overture Maps, a free global dataset accessible via S3. Ask about nearby places, distances between points, or analyze your own GeoJSON, Shapefile, or GPX files—the skill manages spatial joins, containment checks, and format conversions.
Spatial answers geographic queries about places, buildings, and distances using DuckDB and free Overture Maps data.
AI-generated summary based on this skill's SKILL.md
Install
duckdb/duckdb-skills/spatial · repository language: Shell
git clone https://github.com/duckdb/duckdb-skills
cp -r duckdb-skills/skills/spatial ~/.claude/skills/spatialFrequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
What can Spatial help me find near a location?
Spatial helps you find places, buildings, or points of interest near a location by combining DuckDB's spatial functions with Overture Maps data. You can search for restaurants, hospitals, stores, roads, and other POIs closest to your coordinates or address, including distance-filtered results like "find closest hospital within 5km."
How far is it between two addresses using Spatial?
Spatial calculates distances between coordinates or addresses by leveraging DuckDB's spatial computation engine. Provide two lat/lng coordinate pairs or addresses, and Spatial computes the distance between them, supporting queries like "distance between two lat long" or distance calculations across your own datasets.
Can Spatial convert shapefile to geojson?
Spatial handles geographic file format conversions, including Shapefile to GeoJSON, GeoJSON to Shapefile, and GPX to GeoJSON transformations. Load your file and Spatial manages the conversion, letting you work with your preferred format for mapping and analysis.
What spatial analysis can Spatial perform on my data?
Spatial analyzes spatial relationships including containment checks (which points fall inside a polygon), point density analysis, and geographic hotspot identification. It supports spatial joins between datasets, bounding box queries to count points within regions, and filtering data using geographic boundaries.
What data sources does Spatial access?
Spatial combines DuckDB's spatial functions with Overture Maps, a free global dataset of places, buildings, and geographic features accessible via S3. You can also load and query your own GeoPackage files, Shapefiles, GeoJSON, GPX files, and other spatial formats for custom analysis.
Is Spatial free to use?
Spatial is released under the MIT license and uses Overture Maps, which is freely accessible. You can use Spatial to query global geographic data and analyze your own spatial files without licensing restrictions.
SKILL.md
rendered from the published skill — quoted content, verbatim
You are answering spatial questions using DuckDB's spatial extension and, when needed, Overture Maps as a free global data source.
Question or file: $0
Additional context: ${1:-}
Step 1 — Understand what the user needs
Classify the question:
| Pattern | Data source | Key functions |
|---|---|---|
| "Find X near Y" (no user file) | Overture Maps on S3 | ST_Distance_Spheroid, bbox filtering |
| "How far between A and B" | Geocode or user data | ST_Distance_Spheroid |
| "Which points fall inside |
(truncated - see the full file via the links below)
Read as markdown · JSON record · Browse the source repository
File tree — 3 files
skills/spatial/SKILL.md
skills/spatial/references/functions.md
skills/spatial/references/overture.md