Feature request: linking to interactive WASM duckdb database to filter a lonboard view?

[jaanli]

It would be amazing to unlock interactive filtering of lonboard maps based on visualizations such as histograms of certain columns in a geoparquet dataframe.

Would this be possible??

Might be able to help implement.

https://uwdata.github.io/mosaic/ uses WASM duckdb and could be interesting to try to link to a geoparquet file, to update the lonboard view upon a SQL query returning a new result after a user selecting something on a dashboard.

[kylebarron]

The upcoming release has a DataFilterExtension, which performs filtering on the GPU. I briefly looked into mosaic but it seemed that the returned filters were only in SQL text, which would be awful to parse.

If you do some exploration feel free to come back and update with your results

[jaanli]

That sounds awesome - excited to try the filtering extension and will keep you posted as I try Mosaic + Protomaps for deploying exploratory data analyses done in lonboard 🙏

[jaanli]

@kylebarron the DataFilterExtension looks cool! Running into an issue though, will open up a separate issue.

But this is exactly the type of functionality I hope to support by linking lonboard to https://uwdata.github.io/mosaic/ (or Protomaps for hosting these dashboards on the web..).

[kylebarron]

This is prototyped in #610 though it doesn't work reliably yet