demo D314
Spatial filtering pushed into DuckDB from a GeoParquet file: JavaScript Data Grid Demo
A small GeoParquet file of country locations, read by DuckDB’s spatial extension in the browser; drawing a box on the map pushes a within-the-box filter into the engine, and lastPlan shows the generated SQL
duckdbAdapter({ spatial: true }) · withinBbox · lastPlan()
This reads a GeoParquet file with DuckDB running in the browser and pushes each spatial filter, a box, a polygon or a radius, into DuckDB's own spatial functions. It shows that the browser never loads more than the page in view, even when the question is geographic.
Loading a live grid…
Spatial filtering pushed into DuckDB from a GeoParquet file
The query plan shown beside the grid names the spatial function DuckDB ran, so the reader can see the filter left the browser rather than trusting that it did.