H3Geo utilities - Githubissues

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

29.95k stars 3.79k forks source link

H3Geo utilities #109716

Open Defman opened 1 year ago

Defman commented 1 year ago

Is your feature request related to a problem? Please describe.

We at Doubble uses H3Geo indices to perform range selects. It would be awesome if cockroach supported/implemented some utility functions.

Describe the solution you'd like

Similar to the Postgres extension h3-pg

Describe alternatives you've considered

Doing the calculations client side, requires a lot of back and fourth and is infeasible in a lot of siturations/quries.

Additional context

h3-go

Jira issue: CRDB-31064

blathers-crl[bot] commented 1 year ago

Hello, I am Blathers. I am here to help you get the issue triaged.

I was unable to automatically find someone to ping.

If we have not gotten back to your issue within a few business days, you can try the following:

Join our community slack channel and ask on #cockroachdb.
Try find someone from here if you know they worked closely on the area and CC them.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}

rafiss commented 1 year ago

Moving this to SQL Queries, since this is about adding support for a "hierarchical hexagonal geospatial indexing system". (https://github.com/zachasme/h3-pg)