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
Decision gist · record as of 2026-04-23
Spatial answers geographic queries about places, buildings, and distances using DuckDB and free Overture Maps data. 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.
Use it when
- Spatial calculates distances between coordinates or addresses by leveraging DuckDB's spatial computation engine.
- Spatial handles geographic file format conversions, including Shapefile to GeoJSON, GeoJSON to Shapefile.
Verify before relying
Read SKILL.md below before installing (3 files). Open directory: indexed for reading, not audited.
Similar skills
Install
duckdb/duckdb-skills/spatial · repository language: Shell
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently 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)
File tree — 3 files
skills/spatial/SKILL.md
skills/spatial/references/functions.md
skills/spatial/references/overture.md
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Find places, buildings, or points of interest near a location”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Convert any data file to another format—CSV, Parquet, JSON, Excel, GeoJSON, and more—in a single DuckDB command. Handles both local and remote files, with support for partitioning and compression options when needed.
read-file uses DuckDB to load and analyze data files across multiple formats—CSV, JSON, Parquet, Avro, Excel, spatial, and SQLite—from local paths or remote sources like S3 and HTTPS. It automatically detects file type, retrieves schema and row counts, and displays sample rows to help you understand your dataset at a glance.
Google Maps equips AI agents with geospatial reasoning—geocoding, nearby discovery, routing, and elevation queries. Chain multiple tools to answer complex location questions: find what's nearby, compare distances across points, optimize multi-stop itineraries, and surface travel times and directions. Works across Claude Code, Cursor, VS Code Copilot, and other supported agents.
Build well-structured database schemas from requirements through deployment. This skill guides you through normalization, relationship design, index optimization, and reversible migrations—covering relational databases like PostgreSQL and MySQL, document stores like MongoDB, and ORMs including Prisma, Drizzle, and TypeORM.
seo-maps brings structured local SEO auditing to Claude Code, helping you evaluate Google Business Profile optimization and the factors that influence local search rankings. Run parallel analysis across technical elements, content quality, schema markup, and location-specific signals to identify gaps and improvement opportunities.
Local Search queries Google Maps to find businesses, restaurants, and services by name or location. Use text search for keyword-based discovery, nearby search to find places within a radius, or place details to get comprehensive information including hours, ratings, reviews, and amenities. Choose between partial ($0.02) and full ($0.05–$0.08) data tiers based on your needs.