Spatial GeoJSON Analysis

Run spatial SQL queries on GeoJSON files and visualize results on an interactive map.

Data Source
Local path or remote URL
Centers the map and provides coordinates
SQL Query
Use {SOURCE} as a placeholder for the GeoJSON path above.
Initializing DuckDB…
Spatial functions
  • ST_Read('url') — read GeoJSON, Shapefile, etc.
  • ST_Area(geom) — area of geometry
  • ST_Centroid(geom) — centroid point
  • ST_AsText(geom) — WKT representation
  • ST_AsGeoJSON(geom) — GeoJSON string
  • ST_Within(g1, g2) — containment test
  • ST_MakeEnvelope(xmin,ymin,xmax,ymax) — bounding box
  • ST_Distance(g1, g2) — distance between geometries
Results
Run a query to see results here.
Map