Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Support for Bing Tile functions #1327

Open
atiannicelli opened this issue Apr 9, 2024 · 2 comments
Open

Add Support for Bing Tile functions #1327

atiannicelli opened this issue Apr 9, 2024 · 2 comments

Comments

@atiannicelli
Copy link

It would be super helpful to add functionality to support the bing tile functions to this API like Presto has as listed here: https://prestodb.io/docs/current/functions/geospatial.html#bing-tiles

As part of an effort to detect overlap of 2.9 buildings with water globally I find I need to bucket my queries on quadkey. This has worked great, but unfortunately it only works if the dataset already has quadkeys for all features. I would love the ability to generate bing tiles and quadkeys natively in the Sedona API.

The highest priority function for me is the geometry_to_bing_tiles function that produces a list of quadkeys that the geometry passed in touches.

For now I am having to define a UDF to generate quadkeys and call it to convert geometry to quadkeys.

@jiayuasu
Copy link
Member

@atiannicelli Do you have an example of the UDF you implement? We can help you import that to Sedona.

@atiannicelli
Copy link
Author

once I finalize it and test it I will post what I have

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants