{ "_id": "6a48e118b5e98c4082a0183b", "Type": "Package", "Package": "duckh3", "Title": "H3 Extension of 'DuckDB'", "Version": "0.1.0", "Authors@R": "c(\nperson(\n\"Adrián\", \"Cidre González\",\nemail = \"adrian.cidre@gmail.com\",\nrole = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-3310-3052\")\n),\nperson(\n\"Egor\", \"Kotov\", ,\n\"kotov.egor@gmail.com\",\nrole = \"aut\",\ncomment = c(ORCID = \"0000-0001-6690-5345\")\n),\nperson(\n\"Rafael H. M.\", \"Pereira\", ,\n\"rafa.pereira.br@gmail.com\",\nrole = \"aut\",\ncomment = c(ORCID = \"0000-0003-2125-7465\")\n))", "Description": "Fast & memory-efficient functions to analyze and\nmanipulate large data sets. It leverages the fast analytical\ncapabilities of 'DuckDB' and its spatial extension (see\n) while\nmaintaining compatibility with R’s spatial data ecosystem to\nwork with spatial vector data.", "URL": "https://cidree.github.io/duckh3/, https://github.com/Cidree/duckh3", "BugReports": "https://github.com/Cidree/duckh3/issues", "Encoding": "UTF-8", "License": "GPL (>= 3)", "Config/testthat/edition": "3", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "Config/pak/sysreqs": "libabsl-dev cmake libgdal-dev gdal-bin libgeos-dev\nlibicu-dev libzstd-dev libssl-dev libproj-dev libsqlite3-dev\nlibudunits2-dev xz-utils", "Repository": "https://cidree.r-universe.dev", "Date/Publication": "2026-04-25 09:42:28 UTC", "RemoteUrl": "https://github.com/cidree/duckh3", "RemoteRef": "HEAD", "RemoteSha": "59de57c82f3ba9ab5b0df53ecdbcd3b520d9045a", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-04 10:17:54 UTC", "User": "root" }, "Author": "Adrián Cidre González [aut, cre] (ORCID:\n),\nEgor Kotov [aut] (ORCID: ),\nRafael H. M. Pereira [aut] (ORCID:\n)", "Maintainer": "Adrián Cidre González ", "_user": "cidree", "_type": "src", "_file": "duckh3_0.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/b3d0429779f0561b2f75fa248736cd5a7ac5a944250f3bf96801cba215f84be4", "_filesize": 1794985, "_sha256": "b3d0429779f0561b2f75fa248736cd5a7ac5a944250f3bf96801cba215f84be4", "_expires": "2026-10-12T10:31:50.000Z", "_created": "2026-07-04T10:17:54.000Z", "_published": "2026-07-04T10:31:52.019Z", "_jobs": [ { "job": 85124288349, "time": 140, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8080811950" }, { "job": 85124288268, "time": 140, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8080812014" }, { "job": 85124288278, "time": 79, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8080883249" }, { "job": 85124288277, "time": 107, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8080880427" }, { "job": 85124066052, "time": 220, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8080796125" }, { "job": 85124288273, "time": 157, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8080813752" }, { "job": 85124288281, "time": 89, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8080806484" }, { "job": 85124288305, "time": 77, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8080805096" }, { "job": 85124288285, "time": 79, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8080805140" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/cidree/actions/runs/28703005185", "_status": "success", "_upstream": "https://github.com/cidree/duckh3", "_commit": { "id": "59de57c82f3ba9ab5b0df53ecdbcd3b520d9045a", "author": "Cidree ", "committer": "Cidree ", "message": "docs: Tag blog post in news\n", "time": 1777110148 }, "_maintainer": { "name": "Adrián Cidre González", "email": "adrian.cidre@gmail.com", "login": "cidree", "linkedin": "in/adrian-cidre", "description": "R | Shiny | Google Earth Engine | Python | Remote Sensing | Data science & Analytics", "uuid": 96820235, "orcid": "0000-0002-3310-3052" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "cli", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "duckdb", "role": "Imports" }, { "package": "duckspatial", "version": ">= 1.0.0", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "sf", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "cidree", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-10", "n": 21 }, { "week": "2026-13", "n": 2 }, { "week": "2026-14", "n": 4 }, { "week": "2026-15", "n": 1 }, { "week": "2026-16", "n": 3 }, { "week": "2026-17", "n": 3 } ], "_tags": [ { "name": "v0.1.0", "date": "2026-04-22" } ], "_stars": 14, "_contributors": [ { "user": "cidree", "count": 42, "uuid": 96820235 } ], "_userbio": { "uuid": 96820235, "type": "user", "name": "Adrian Cidre", "followers": 89, "description": "R | Shiny | Google Earth Engine | Python | Remote Sensing | Data science & Analytics" }, "_downloads": { "count": 492, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/duckh3" }, "_devurl": "https://github.com/cidree/duckh3", "_pkgdown": "https://cidree.github.io/duckh3/", "_searchresults": 20, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/duckh3.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/cidree/duckh3", "_realowner": "cidree", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2026-04-24" } ], "_exports": [ "ddbh3_bigint_to_strings", "ddbh3_create_conn", "ddbh3_default_conn", "ddbh3_get_center_child", "ddbh3_get_child_pos", "ddbh3_get_children", "ddbh3_get_icosahedron_faces", "ddbh3_get_n_children", "ddbh3_get_parent", "ddbh3_get_resolution", "ddbh3_h3_to_lat", "ddbh3_h3_to_lon", "ddbh3_h3_to_points", "ddbh3_h3_to_spatial", "ddbh3_h3_to_vertex", "ddbh3_h3_to_vertexes", "ddbh3_is_h3", "ddbh3_is_pentagon", "ddbh3_is_res_class_iii", "ddbh3_is_vertex", "ddbh3_lonlat_to_h3", "ddbh3_lonlat_to_spatial", "ddbh3_points_to_h3", "ddbh3_points_to_spatial", "ddbh3_strings_to_bigint", "ddbh3_vertex_to_lat", "ddbh3_vertex_to_lon", "ddbh3_vertex_to_spatial" ], "_help": [ { "page": "ddbh3_create_conn", "title": "Create a DuckDB connection with spatial and h3 extensions", "topics": [ "ddbh3_create_conn" ] }, { "page": "ddbh3_default_conn", "title": "Get or create default DuckDB connection", "topics": [ "ddbh3_default_conn" ] }, { "page": "ddbh3_get_child_pos", "title": "Get the position of an H3 cell within its parent", "topics": [ "ddbh3_get_child_pos" ] }, { "page": "ddbh3_get_hierarchy", "title": "Get parent and children H3 cells", "topics": [ "ddbh3_get_center_child", "ddbh3_get_children", "ddbh3_get_hierarchy", "ddbh3_get_n_children", "ddbh3_get_parent" ] }, { "page": "ddbh3_get_icosahedron_faces", "title": "Get the icosahedron faces of H3 cell indexes", "topics": [ "ddbh3_get_icosahedron_faces" ] }, { "page": "ddbh3_get_resolution", "title": "Get the resolution of H3 cell indexes", "topics": [ "ddbh3_get_resolution" ] }, { "page": "ddbh3_h3_to", "title": "Convert H3 string or UBIGINT indexes to other representations", "topics": [ "ddbh3_bigint_to_strings", "ddbh3_h3_to", "ddbh3_h3_to_lat", "ddbh3_h3_to_lon", "ddbh3_h3_to_points", "ddbh3_h3_to_spatial", "ddbh3_strings_to_bigint" ] }, { "page": "ddbh3_is", "title": "Check properties of H3 cell indexes", "topics": [ "ddbh3_is", "ddbh3_is_h3", "ddbh3_is_pentagon", "ddbh3_is_res_class_iii", "ddbh3_is_valid", "ddbh3_is_vertex" ] }, { "page": "ddbh3_lonlat_to", "title": "Convert longitude and latitude to H3 cell representations", "topics": [ "ddbh3_lonlat_to", "ddbh3_lonlat_to_h3", "ddbh3_lonlat_to_spatial" ] }, { "page": "ddbh3_points_to", "title": "Convert spatial points to H3 cell representations", "topics": [ "ddbh3_points_to", "ddbh3_points_to_h3", "ddbh3_points_to_spatial" ] }, { "page": "ddbh3_vertex", "title": "Convert H3 cell indexes to vertex representations", "topics": [ "ddbh3_h3_to_vertex", "ddbh3_h3_to_vertexes", "ddbh3_vertex", "ddbh3_vertex_to_lat", "ddbh3_vertex_to_lon", "ddbh3_vertex_to_spatial" ] } ], "_pkglogo": "https://github.com/cidree/duckh3/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/cidree/duckh3/raw/HEAD/README.md", "_rundeps": [ "arrow", "assertthat", "bit", "bit64", "blob", "class", "classInt", "cli", "cpp11", "DBI", "dbplyr", "dplyr", "duckdb", "duckspatial", "e1071", "generics", "geoarrow", "glue", "jsonlite", "KernSmooth", "lifecycle", "magrittr", "MASS", "nanoarrow", "pillar", "pkgconfig", "proxy", "purrr", "R6", "Rcpp", "rlang", "s2", "sf", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "units", "utf8", "uuid", "vctrs", "withr", "wk" ], "_score": 4.924279286061882, "_indexed": true, "_nocasepkg": "duckh3", "_universes": [ "cidree" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-07-04T10:20:16.000Z", "distro": "resolute", "commit": "59de57c82f3ba9ab5b0df53ecdbcd3b520d9045a", "fileid": "https://r2.ropensci.org/499f0f527198cad8846a3b89c855d98314347edd4f65b023a87e21e821d83f2b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28703005185" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-07-04T10:20:16.000Z", "distro": "resolute", "commit": "59de57c82f3ba9ab5b0df53ecdbcd3b520d9045a", "fileid": "https://r2.ropensci.org/02f44a4f8f5b89dd46ac1d7ce7111a1d8e0d8e0c216cbfbb30c86440c9a550c4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28703005185" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-07-04T10:31:17.000Z", "commit": "59de57c82f3ba9ab5b0df53ecdbcd3b520d9045a", "fileid": "https://r2.ropensci.org/a419e39250f198c9de45f400a6f07d67c62e9c667b5a6e9a9760cd9a39e197f9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28703005185" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0", "date": "2026-07-04T10:30:50.000Z", "commit": "59de57c82f3ba9ab5b0df53ecdbcd3b520d9045a", "fileid": "https://r2.ropensci.org/5980a81487384934edde76f042e08450cdc8671dae37a1f42d3e6f82f0019bfe", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28703005185" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-07-04T10:20:49.000Z", "commit": "59de57c82f3ba9ab5b0df53ecdbcd3b520d9045a", "fileid": "https://r2.ropensci.org/63d35c273f5bdad7069c639b25fb212db08c9d32169bca9eab407f7988fb579d", "status": "success", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28703005185" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-07-04T10:19:11.000Z", "commit": "59de57c82f3ba9ab5b0df53ecdbcd3b520d9045a", "fileid": "https://r2.ropensci.org/b33ddb42f507c643134304f6e50eb16deb3c1d207437dcb0c8cc4aa6c3d50881", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28703005185" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-07-04T10:19:04.000Z", "commit": "59de57c82f3ba9ab5b0df53ecdbcd3b520d9045a", "fileid": "https://r2.ropensci.org/5198068a53846046cee081c178a98f74677540b0dca79a467a4ab6d40e0e61d5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28703005185" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-07-04T10:19:05.000Z", "commit": "59de57c82f3ba9ab5b0df53ecdbcd3b520d9045a", "fileid": "https://r2.ropensci.org/2dff425a74a92bc2b7ed38bfe94ff9feda93845d964fea53329d885a0443f21a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/28703005185" } ] }