Analyze spatial data with DuckDB spatial extension and Overture Maps.
npx skills add https://github.com/vathymut/copilot-skills --skill spatial-vathymut
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
This Skill simplifies the process of querying and analyzing spatial data, using DuckDB's spatial extension and Overture Maps' global dataset.
Use the spatial skill to find the nearest coffee shop to the coordinates 40.7128, -74.0060.
High-intent search queries and answers about installing and using this skill.
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.
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.
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.
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.
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.
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.
nq-rdlEnable DuckDB spatial extension to analyze Overture Maps geospatial data.
jaechang-hitsPerform geospatial vector data analysis with pandas-based spatial operations.
Imad-OuteAnalyze and visualize geographic vector data with GeoPandas in Python.
LeonChaoXRead, transform, and analyze geographic vector data with GeoPandas.
