Spatial SQL Playground

Live

Load a GeoJSON or CSV file, then query it with SQL — including spatial functions like ST_Area, ST_Length, and ST_Distance. Everything runs in-browser — no data leaves your device.

SQL SQLite GeoJSON Spatial
Loading SQL engine…

Schema

No data loaded.
ST_Area(geom)m²
ST_Length(geom)meters
ST_Perimeter(geom)meters
ST_Distance(g1,g2)km
ST_X(geom)longitude
ST_Y(geom)latitude
ST_GeomType(geom)type string
ST_IsValid(geom)1 or 0

Pass the geometry column as the argument. Area and length return metric units.

Load Data

Drop a GeoJSON or CSV file here, or click to browse

Loaded as table features

or paste

SQL Query

Ctrl+Enter to run

Related Tools

GeoJSON Viewer

Visualize on map

CSV → GeoJSON

Build from coordinates

Bounding Box

Extract extent