{
  "_id": "6ae917d8818c9e3ef6dbe9f4",
  "Type": "Package",
  "Package": "duckh3",
  "Title": "H3 Extension of 'DuckDB'",
  "Version": "0.2.0.9003",
  "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<https://duckdb.org/community_extensions/extensions/h3>) 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 libxml2-dev libzstd-dev libssl-dev libproj-dev\nlibsqlite3-dev libudunits2-dev",
  "Repository": "https://cidree.r-universe.dev",
  "Date/Publication": "2026-10-25 06:58:38 UTC",
  "RemoteUrl": "https://github.com/cidree/duckh3",
  "RemoteRef": "HEAD",
  "RemoteSha": "cb79e7afb53b4b7051d66cd98c7d55db4fdc511c",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-11-02 22:33:38 UTC",
    "User": "root"
  },
  "Author": "Adrián Cidre González [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-3310-3052>),\nEgor Kotov [aut] (ORCID: <https://orcid.org/0000-0001-6690-5345>),\nRafael H. M. Pereira [aut] (ORCID:\n<https://orcid.org/0000-0003-2125-7465>)",
  "Maintainer": "Adrián Cidre González <adrian.cidre@gmail.com>",
  "_user": "cidree",
  "_type": "src",
  "_file": "duckh3_0.2.0.9003.tar.gz",
  "_fileid": "https://r2.ropensci.org/d9bad6d186889ed4ea9e60456b1a19248c628c19712d583bf161a3810804e5bd",
  "_filesize": 1852262,
  "_sha256": "d9bad6d186889ed4ea9e60456b1a19248c628c19712d583bf161a3810804e5bd",
  "_expires": "2027-02-10T23:08:06.000Z",
  "_created": "2026-11-02T22:33:38.000Z",
  "_published": "2026-11-02T23:08:08.685Z",
  "_upstream": "https://github.com/cidree/duckh3",
  "_status": "success",
  "_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"
  },
  "_jobs": [
    {
      "job": 125596736339,
      "time": 164,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13185531051"
    },
    {
      "job": 125596736200,
      "time": 233,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13184094958"
    },
    {
      "job": 125596735963,
      "time": 1913,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13185619560"
    },
    {
      "job": 125596736150,
      "time": 88,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13185193067"
    },
    {
      "job": 125594040111,
      "time": 334,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13185008083"
    },
    {
      "job": 125596736100,
      "time": 121,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "13185068085"
    },
    {
      "job": 125596736120,
      "time": 99,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13185317557"
    },
    {
      "job": 125596736283,
      "time": 122,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13184963949"
    },
    {
      "job": 125596736138,
      "time": 105,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13185103417"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cidree/actions/runs/41537760887",
  "_commit": {
    "id": "cb79e7afb53b4b7051d66cd98c7d55db4fdc511c",
    "author": "Adrian Cidre <96820235+Cidree@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #15 from Cidree/test/issue-8\n\ntest: Add unit tests for new functions (#8)",
    "time": 1792911518
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_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
    },
    {
      "week": "2026-43",
      "n": 6
    }
  ],
  "_tags": [
    {
      "name": "v0.1.0",
      "date": "2026-04-22"
    },
    {
      "name": "v0.2.0",
      "date": "2026-10-11"
    }
  ],
  "_stars": 14,
  "_contributors": [
    {
      "user": "cidree",
      "count": 74,
      "uuid": 96820235
    },
    {
      "user": "rafapereirabr",
      "count": 7,
      "uuid": 7448421
    }
  ],
  "_userbio": {
    "uuid": 96820235,
    "type": "user",
    "name": "Adrian Cidre",
    "followers": 93,
    "description": "R | Shiny | Google Earth Engine | Python | Remote Sensing | Data science & Analytics"
  },
  "_downloads": {
    "count": 363,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/duckh3"
  },
  "_devurl": "https://github.com/cidree/duckh3",
  "_pkgdown": "https://cidree.github.io/duckh3/",
  "_searchresults": 28,
  "_rbuild": "4.6.2",
  "_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_child_pos_to_cell",
    "ddbh3_create_conn",
    "ddbh3_default_conn",
    "ddbh3_get_base_cell_number",
    "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_grid_disk",
    "ddbh3_grid_disk_distances",
    "ddbh3_grid_distance",
    "ddbh3_grid_path_cells",
    "ddbh3_grid_ring",
    "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_max_grid_disk_size",
    "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_child_pos_to_cell",
      "title": "Get an H3 child cell from a parent and child position",
      "topics": [
        "ddbh3_child_pos_to_cell"
      ]
    },
    {
      "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_base_cell_number",
      "title": "Get the base cell number of an H3 cell",
      "topics": [
        "ddbh3_get_base_cell_number"
      ]
    },
    {
      "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_grid_disk",
      "title": "Get H3 grid neighborhoods (disks, rings, and distances)",
      "topics": [
        "ddbh3_grid_disk",
        "ddbh3_grid_disk_distances",
        "ddbh3_grid_ring"
      ]
    },
    {
      "page": "ddbh3_grid_distance",
      "title": "Get the grid distance between two H3 cells",
      "topics": [
        "ddbh3_grid_distance"
      ]
    },
    {
      "page": "ddbh3_grid_path_cells",
      "title": "Find a grid path connecting two H3 cells",
      "topics": [
        "ddbh3_grid_path_cells"
      ]
    },
    {
      "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_max_grid_disk_size",
      "title": "Get the maximum grid disk size for a given distance k",
      "topics": [
        "ddbh3_max_grid_disk_size"
      ]
    },
    {
      "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.292256071356476,
  "_indexed": true,
  "_nocasepkg": "duckh3",
  "_universes": [
    "cidree"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.2.0.9003",
      "date": "2026-11-02T22:38:09.000Z",
      "distro": "resolute",
      "commit": "cb79e7afb53b4b7051d66cd98c7d55db4fdc511c",
      "fileid": "https://r2.ropensci.org/8b8db22780e7ed1d9a69eae964cea60e688b9edaedd358c74f15ee9cea407b97",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/41537760887"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.2.0.9003",
      "date": "2026-11-02T22:38:29.000Z",
      "distro": "resolute",
      "commit": "cb79e7afb53b4b7051d66cd98c7d55db4fdc511c",
      "fileid": "https://r2.ropensci.org/89d783f39945b08baeef89a89f80641c4449daa8b027a178e2d6c068bad2db47",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/41537760887"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.2.0.9003",
      "date": "2026-11-02T23:07:19.000Z",
      "commit": "cb79e7afb53b4b7051d66cd98c7d55db4fdc511c",
      "fileid": "https://r2.ropensci.org/df9a151e696741865c5aa9fd1ed8f3de51924df19d6aa680702ad628ebcb1772",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/41537760887"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.2.0.9003",
      "date": "2026-11-02T22:37:01.000Z",
      "commit": "cb79e7afb53b4b7051d66cd98c7d55db4fdc511c",
      "fileid": "https://r2.ropensci.org/6ba147baa3b931fca5c8522c7ae35ba1b4f6d538f4faacc474721edb6adcb331",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/41537760887"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.2.0.9003",
      "date": "2026-11-02T22:37:47.000Z",
      "commit": "cb79e7afb53b4b7051d66cd98c7d55db4fdc511c",
      "fileid": "https://r2.ropensci.org/d6a135735fe820de563f67a5966ddcf969cd6b68bf2ec5d3e254039912e5d52e",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/41537760887"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.2.0.9003",
      "date": "2026-11-02T22:36:58.000Z",
      "commit": "cb79e7afb53b4b7051d66cd98c7d55db4fdc511c",
      "fileid": "https://r2.ropensci.org/f71e07753e6de905e4e7971178aad2d324ca5cc8ff437bfce90f1de641dfd826",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/41537760887"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.2.0.9003",
      "date": "2026-11-02T22:36:57.000Z",
      "commit": "cb79e7afb53b4b7051d66cd98c7d55db4fdc511c",
      "fileid": "https://r2.ropensci.org/1740f111ffd003699e4de21c2af81cd0d087a458ea87ea3e06076f78d044f72c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/41537760887"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.2.0.9003",
      "date": "2026-11-02T22:36:53.000Z",
      "commit": "cb79e7afb53b4b7051d66cd98c7d55db4fdc511c",
      "fileid": "https://r2.ropensci.org/ad3c1285565ed322f0a038c7d0714e6d85a4968c50e1d60c735616e0e486bd6d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cidree/actions/runs/41537760887"
    }
  ]
}