{ "_id": "6ad345414bc68bd0bd9bdc7d", "Type": "Package", "Package": "duckh3", "Title": "H3 Extension of 'DuckDB'", "Version": "0.2.0.9000", "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)", "Config/roxygen2/version": "8.1.1", "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-10-17 09:39:23 UTC", "RemoteUrl": "https://github.com/cidree/duckh3", "RemoteRef": "HEAD", "RemoteSha": "642b5d93c5af96cd7ac3e7d7d62ec3b381fb1494", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-17 09:46:13 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.2.0.9000.tar.gz", "_fileid": "https://r2.ropensci.org/504f69472e21a2c3601e4681b6d16b6896e257c10974d8183c34b2747aca2abb", "_filesize": 1808735, "_sha256": "504f69472e21a2c3601e4681b6d16b6896e257c10974d8183c34b2747aca2abb", "_expires": "2027-01-25T09:52:00.000Z", "_created": "2026-10-17T09:46:13.000Z", "_published": "2026-10-17T09:52:01.698Z", "_buildurl": "https://github.com/r-universe/cidree/actions/runs/39022170591", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 117366657886, "time": 122, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12097620961" }, { "job": 117366657901, "time": 168, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12096978623" }, { "job": 117366657863, "time": 99, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "12096844237" }, { "job": 117366657960, "time": 104, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12097442437" }, { "job": 117366038841, "time": 205, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12096872354" }, { "job": 117366657952, "time": 123, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12097191719" }, { "job": 117366657896, "time": 62, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12096714886" }, { "job": 117366657959, "time": 83, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "12096623670" }, { "job": 117366657976, "time": 80, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12096739991" } ], "_upstream": "https://github.com/cidree/duckh3", "_commit": { "id": "642b5d93c5af96cd7ac3e7d7d62ec3b381fb1494", "author": "Adrian Cidre <96820235+Cidree@users.noreply.github.com>", "committer": "GitHub ", "message": "Merge pull request #7 from Cidree/issue-6\n\nRemove arrow lambda for compatibility with duckdb 2.0", "time": 1792229963 }, "_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": "bit64", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "duckdb", "version": ">= 1.5.6", "role": "Imports" }, { "package": "duckspatial", "version": ">= 1.3.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 }, { "week": "2026-40", "n": 1 }, { "week": "2026-41", "n": 3 }, { "week": "2026-42", "n": 1 } ], "_tags": [ { "name": "v0.1.0", "date": "2026-04-22" }, { "name": "v0.2.0", "date": "2026-10-11" } ], "_stars": 14, "_contributors": [ { "user": "cidree", "count": 57, "uuid": 96820235 } ], "_userbio": { "uuid": 96820235, "type": "user", "name": "Adrian Cidre", "followers": 92, "description": "R | Shiny | Google Earth Engine | Python | Remote Sensing | Data science & Analytics" }, "_downloads": { "count": 346, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/duckh3" }, "_devurl": "https://github.com/cidree/duckh3", "_pkgdown": "https://cidree.github.io/duckh3/", "_searchresults": 22, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/duckh3.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md" ], "_homeurl": "https://github.com/cidree/duckh3", "_realowner": "cidree", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2026-04-24" }, { "version": "0.2.0", "date": "2026-10-11" } ], "_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_lines_to_h3", "ddbh3_lines_to_spatial", "ddbh3_lonlat_to_h3", "ddbh3_lonlat_to_spatial", "ddbh3_points_to_h3", "ddbh3_points_to_spatial", "ddbh3_polygons_to_h3", "ddbh3_polygons_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_geom_to", "title": "Convert polygon or linestring geometries to H3 cell representations", "topics": [ "ddbh3_geom_to", "ddbh3_lines_to_h3", "ddbh3_lines_to_spatial", "ddbh3_polygons_to_h3", "ddbh3_polygons_to_spatial" ] }, { "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", "nanoarrow", "pillar", "pkgconfig", "proxy", "purrr", "R6", "Rcpp", "rlang", "s2", "sf", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "units", "utf8", "uuid", "vctrs", "withr", "wk" ], "_score": 5.141763230275788, "_indexed": true, "_nocasepkg": "duckh3", "_universes": [ "cidree" ], "_previous": "0.2.0", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.0.9000", "date": "2026-10-17T09:48:20.000Z", "distro": "resolute", "commit": "642b5d93c5af96cd7ac3e7d7d62ec3b381fb1494", "fileid": "https://r2.ropensci.org/42120f3db8c5aad04226045130969a51801a970dee239ece8c0c9f866ad7c55d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/39022170591" }, { "r": "4.6.1", "os": "linux", "version": "0.2.0.9000", "date": "2026-10-17T09:49:03.000Z", "distro": "resolute", "commit": "642b5d93c5af96cd7ac3e7d7d62ec3b381fb1494", "fileid": "https://r2.ropensci.org/3f7533f3cefa4e813d502701ba4f3ddb06a3bef9b887473eaec508765f3cb774", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/39022170591" }, { "r": "4.5.3", "os": "mac", "version": "0.2.0.9000", "date": "2026-10-17T09:48:26.000Z", "commit": "642b5d93c5af96cd7ac3e7d7d62ec3b381fb1494", "fileid": "https://r2.ropensci.org/d4a0abb3e6cc58c6dec017ecd22b1296dc10cb71af75906d886eb9662e31609e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/39022170591" }, { "r": "4.6.1", "os": "mac", "version": "0.2.0.9000", "date": "2026-10-17T09:51:21.000Z", "commit": "642b5d93c5af96cd7ac3e7d7d62ec3b381fb1494", "fileid": "https://r2.ropensci.org/a02373168187eca1a6d0de48c7287a2706f81ab75af5776d955ebb4286e8ad70", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/39022170591" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.0.9000", "date": "2026-10-17T09:48:33.000Z", "commit": "642b5d93c5af96cd7ac3e7d7d62ec3b381fb1494", "fileid": "https://r2.ropensci.org/0d0cba24ef0475605f2205a3e301e21e64f68e5eeb5c8abf628a73579dfdb94d", "status": "success", "buildurl": "https://github.com/r-universe/cidree/actions/runs/39022170591" }, { "r": "4.7.0", "os": "win", "version": "0.2.0.9000", "date": "2026-10-17T09:47:12.000Z", "commit": "642b5d93c5af96cd7ac3e7d7d62ec3b381fb1494", "fileid": "https://r2.ropensci.org/dcfbcee17233e9667a8d6622111c7ad193ba4fffb7faccc130c183e06d267541", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/39022170591" }, { "r": "4.5.3", "os": "win", "version": "0.2.0.9000", "date": "2026-10-17T09:47:24.000Z", "commit": "642b5d93c5af96cd7ac3e7d7d62ec3b381fb1494", "fileid": "https://r2.ropensci.org/318eb4ddfd33f22fc9721eb2014fb4ac3d00ffc3a38bb3de8d18fd1edfb00b19", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/39022170591" }, { "r": "4.6.1", "os": "win", "version": "0.2.0.9000", "date": "2026-10-17T09:47:25.000Z", "commit": "642b5d93c5af96cd7ac3e7d7d62ec3b381fb1494", "fileid": "https://r2.ropensci.org/198b67e1d216775baa849b03c432f84581073697eb40ae078432e804107d2ef6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cidree/actions/runs/39022170591" } ] }