search

rilldata / rill

Rill is a tool for effortlessly transforming data sets into powerful, opinionated dashboards using SQL. BI-as-code.
https://www.rilldata.com
Apache License 2.0
1.71k stars 116 forks source link

Support for spatial data #2654

Open frafra opened 1 year ago

frafra commented 1 year ago

Is your feature request related to a problem? Please describe. I am not able to handle or import spatial data.

Describe the solution you'd like Being able to install and enable the spatial extension, use st_read over a spatial file to import it, see geometries instead of binary blobs.

Describe alternatives you've considered

Additional context https://duckdb.org/2023/04/28/spatial

magorlick commented 1 year ago

Thank you for the feature request @frafra! We don't currently have enabling this feature on our roadmap, but I would love to hear more about your use case to see where this might fit in. What are you currently using spatial data for in your work?

frafra commented 1 year ago

Hi @magorlick and thanks for your interest. We would like to use rill for handling data from https://metro.strava.com/: they deliver a zip file containing a shapefile and a CSV file, which need to be joined together to carry any kind of analysis. Showing a preview of such geometry using OpenStreetMap tiles or some aerial imagery would help greatly. Such kind of analysis is currently done using Postgres/PostGIS + QGIS.

We also handle NetCDF files and other spatial sources as well.