{"repo":"isaacbrodsky/h3-duckdb","free":true,"listed":false,"github":"https://github.com/isaacbrodsky/h3-duckdb","clone":"git clone https://github.com/isaacbrodsky/h3-duckdb.git","description":"Bindings for H3 to DuckDB","language":"C","stars":251,"topics":["duckdb","geospatial","h3","hexagon","spatial-indexing","duckdb-extension"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"This is a DuckDB extension that adds support for the H3 discrete global grid system, so you can index points and geometries to hexagons in SQL. Get started Load from the community extensions repository: Test running an H3 function: Or, using the integer API, which generally has better performance: Functions This extension implements the entire H3 API. The full list of functions is below. All functions support H3 indexes specified as UBIGINT ( uint64 ) or BIGINT ( int64 ), but the unsigned one is preferred and is returned when the extension can't detect which one to use. The unsigned and signed APIs are identical. All functions also support VARCHAR H3 index input and output. Full list of functions Function Description --: --- h3 latlng to cell Convert latitude/longitude coordinate to cell ID h3 latlng to cell string Convert latitude/longitude coordinate to cell ID (returns VARCHAR) h3 cell to lat Convert cell ID to latitude h3 cell to lng Convert cell ID to longitude h3 cell to latlng Convert cell ID to latitude/longitude h3 cell to boundary wkt Convert cell ID to cell boundary WKT h3 cell to boundary wkb Convert cell ID to cell boundary WKB h3 get resolution Get resolution number of cell ID h3 get base cell number Get base cell number of cell ID h3 get index digit Get specified indexing digit of a cell h3 string to h3 Convert VARCHAR cell ID to UBIGINT h3 h3 to string Convert BIGINT or UBIGINT cell ID to VARCHAR h3 is valid cell True if this is a valid cell ID h3 is valid ind","default_branch":null,"files":null,"tree":[],"storefront":"/r/isaacbrodsky","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/isaacbrodsky/h3-duckdb/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}