databendlabs / databend

𝗗𝗮𝘁𝗮, 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 & 𝗔𝗜. Modern alternative to Snowflake. Cost-effective and simple for massive-scale analytics. https://databend.com
https://docs.databend.com
Other
7.83k stars 747 forks source link

Tracking: geo h3 functions #6390

Closed ariesdevil closed 1 year ago

ariesdevil commented 2 years ago

Summary Support Geography functions

Implemented:

Not implemented:

nange commented 1 year ago

I'd like to try: h3ToGeo, h3ToGeoBoundary, h3kRing.

nange commented 1 year ago

I'll continue to take: h3IsValid, h3GetResolution, h3EdgeLengthM, h3EdgeLengthKm.

nange commented 1 year ago

I'll contine to take: h3GetBaseCell, h3HexAreaM2, h3HexAreaKm2, h3IndexesAreNeighbors, h3ToChildren, h3ToParent.

nange commented 1 year ago

I'll continue to take: h3ToString, stringToH3, h3IsResClassIII, h3IsPentagon, h3GetFaces, h3CellAreaM2, h3CellAreaRads2 .

nange commented 1 year ago

I'll continue to take: h3_to_center_child, h3_exact_edge_length_m, h3_exact_edge_length_km, h3_exact_edge_length_rads, h3_num_hexagons, h3_line, h3_distance, h3_hex_ring, h3_get_unidirectional_edge.

nange commented 1 year ago

Hi @ariesdevil , I didn't find out the document about h3_edge_angle. Could you please provide a Ref or more infomation?

ariesdevil commented 1 year ago

@nange https://clickhouse.com/docs/en/sql-reference/functions/geo/h3#h3edgeangle

ariesdevil commented 1 year ago

close with https://github.com/datafuselabs/databend/pull/12456