Skip to main content

spatial-databases

Spatial databases, GIS, location queries, and geospatial data

Source facts

Repository
NeuralBlitz/Mito
Last source activity
March 22, 2026 at 13:29
Detected SKILL.md language
English
Stars
0
Forks
0

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

Showing SKILL.md

SKILL.md
Source instructions · Read-only preview
name
spatial-databases
description
Spatial databases, GIS, location queries, and geospatial data
license
MIT
compatibility
opencode
metadata
{"audience":"developers","category":"databases"}
## What I do - Query spatial data efficiently - Implement location-based queries and services - Design spatial indexes - Work with geographic coordinate systems - Process geospatial data ## When to use me When building location-based services, GIS applications, or any system requiring spatial queries. ## Key Concepts ### Spatial Data Types - Points, Lines, Polygons - MultiPoint, MultiLine, MultiPolygon - Geometry vs Geography - Z coordinates (3D) - M coordinates (measures) ### Coordinate Systems - WGS84 (EPSG:4326) - Web Mercator (EPSG:3857) - UTM zones - Coordinate transformations - Projected vs geographic CRS ### Spatial Indexing - R-trees - Quadtrees - Geohash - H3 (Uber's hexagonal hierarchy) - Index optimization ### Spatial Functions - Distance calculations - Area computations - Buffer operations - Union/Intersection - Point-in-polygon - Nearest neighbor ### Common Queries - Find points within radius - Find polygons containing point - K-nearest neighbors - Route between points - Spatial joins - Heatmap generation ### Database Support - PostGIS (PostgreSQL) - MySQL spatial extensions - SQL Server spatial - Oracle Spatial - MongoDB geospatial - Redis geospatial ### Use Cases - Ride-sharing/mapping - Store locators - Geofencing - Asset tracking - Weather analytics - Urban planning
View on GitHub