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.

Sign up for GitHub

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

Jump to bottom

Tracking: geo h3 functions #6390

Closed
38 tasks done
ariesdevil opened this issue Jul 1, 2022 · 8 comments · Fixed by #12331 or #12456
Closed
38 tasks done

Tracking: geo h3 functions #6390

ariesdevil opened this issue Jul 1, 2022 · 8 comments · Fixed by #12331 or #12456
Labels
A-query Area: databend query C-function Category: Functions good first issue Category: good first issue

Comments

@ariesdevil
Copy link
Collaborator

ariesdevil commented Jul 1, 2022 •
edited
Loading

Summary
Support Geography functions

Implemented:

  • h3_is_valid
  • h3_get_resolution
  • h3_edge_length_m
  • h3_edge_length_km
  • geo_to_h3
  • h3_to_geo
  • h3_to_geo_boundary
  • h3_k_ring
  • h3_get_base_cell
  • h3_hex_area_m2
  • h3_hex_area_km2
  • h3_indexes_are_neighbors
  • h3_to_children
  • h3_to_parent
  • h3_to_string
  • string_to_h3
  • h3_is_res_class_iii
  • h3_is_pentagon
  • h3_get_faces
  • h3_cell_area_m2
  • h3_cell_area_rads2
  • h3_get_resolution
  • 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
  • h3_edge_angle
  • h3_unidirectional_edge_is_valid
  • h3_get_origin_index_from_unidirectional_edge
  • h3_get_destination_index_from_unidirectional_edge
  • h3_get_indexes_from_unidirectional_edge
  • h3_get_unidirectional_edges_from_hexagon
  • h3_get_unidirectional_edge_boundary

Not implemented:
@ariesdevil ariesdevil added A-query Area: databend query C-function Category: Functions labels Jul 1, 2022
@ariesdevil ariesdevil mentioned this issue Jul 1, 2022
Merged
@ariesdevil ariesdevil changed the title Support Geography functions Tracking: geo h3 functions Apr 24, 2023
@ariesdevil ariesdevil mentioned this issue Apr 24, 2023
Closed
4 tasks
@ariesdevil ariesdevil added the good first issue Category: good first issue label Apr 25, 2023
@nange
Copy link
Contributor

nange commented Jul 18, 2023

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

@nange nange mentioned this issue Jul 19, 2023
Merged
@nange
Copy link
Contributor

nange commented Jul 27, 2023

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

@nange nange mentioned this issue Jul 27, 2023
Merged
@nange
Copy link
Contributor

nange commented Jul 28, 2023

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

@nange nange mentioned this issue Jul 31, 2023
Merged
@nange
Copy link
Contributor

nange commented Aug 1, 2023

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

@nange nange mentioned this issue Aug 2, 2023
Merged
@ariesdevil ariesdevil reopened this Aug 2, 2023
@nange
Copy link
Contributor

nange commented Aug 7, 2023

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 nange mentioned this issue Aug 8, 2023
Merged
@nange
Copy link
Contributor

nange commented Aug 10, 2023

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

@ariesdevil
Copy link
Collaborator Author

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

@nange nange mentioned this issue Aug 14, 2023
Merged
@ariesdevil
Copy link
Collaborator Author

close with #12456

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-query Area: databend query C-function Category: Functions good first issue Category: good first issue
Projects
None yet
Milestone
No milestone
2 participants
@nange @ariesdevil