Spacial Data: S2 cell ID
- Dominant language
- Rust
- Stars
- 9.3k
- Forks
- 2.4k
- Avg merge
- 3d 7h
- Merged PRs (30d)
- 344
Description
### Is your feature request related to a problem or challenge?
Within InfluxDB a community user is trying to derive a S2 cell ID within a new column based on the lon and lat. Currently, data fusion does not support specific geo-based functions within SQL
### Describe the solution you'd like
Would it be possible to expand the scope of data fusion to include domain-specific logic like this? Simular functions currently exist in clickhouse: https://clickhouse.com/docs/en/sql-reference/functions/geo/s2
& big query:
https://cloud.google.com/bigquery/docs/geospatial-data
### Describe alternatives you've considered
We could potentially look to include this within the influxdb code base but I thought this might benefit from a wider discussion based upon https://github.com/apache/arrow-datafusion/issues/7859
### Additional context
_No response_
Contributor guide
Research direction
The issue names no files, tests, or entry points. Start by reviewing DataFusion's SQL function and geospatial support boundaries, then define the supported S2 behavior and validation needed before implementation.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- rust, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100