{
  "_id": "6abe389999f7aa8c6aa53f06",
  "Package": "n2khelper",
  "Title": "Auxiliary Functions for the Analysis and Reporting of the Natura\n2000 Monitoring",
  "Version": "0.5.0",
  "Authors@R": "c(\nperson(\"Thierry\", \"Onkelinx\", , \"thierry.onkelinx@inbo.be\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0001-8804-4216\")),\nperson(\"Research Institute for Nature and Forest\", , , \"info@inbo.be\", role = c(\"cph\", \"fnd\"))\n)",
  "Description": "Auxiliary functions for analysing Natura 2000 monitoring\ndata.",
  "License": "GPL-3",
  "URL": "https://doi.org/10.5281/zenodo.835732",
  "BugReports": "https://github.com/inbo/n2khelper/issues",
  "Remotes": [
    "tidyverse/lubridate"
  ],
  "Encoding": "UTF-8",
  "Language": "eng",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.1.2",
  "Collate": "'check_character.R' 'check_dataframe_covariate.R'\n'check_dataframe_variable.R' 'check_dbtable.R'\n'check_dbtable_variable.R' 'check_id.R' 'check_path.R'\n'check_single_posix.R' 'check_single_probability.R'\n'connect_result.R' 'cut_date.R' 'get_nbn_key.R'\n'get_nbn_key_multi.R' 'get_nbn_name.R' 'git_connect.R'\n'gitconnection_class.R' 'git_connection.R' 'is_chartor.R'\n'match_nbn_key.R' 'odbc_connect.R' 'odbc_get_id.R'\n'odbc_get_multi_id.R' 'odbc_insert.R'\n'read_object_environment.R'",
  "Config/pak/sysreqs": "make libgit2-dev libicu-dev libssh2-1-dev\nunixodbc-dev libssl-dev",
  "Repository": "https://inbo.r-universe.dev",
  "Date/Publication": "2022-03-24 09:55:13 UTC",
  "RemoteUrl": "https://github.com/inbo/n2khelper",
  "RemoteRef": "HEAD",
  "RemoteSha": "3f02dbac8397a6d9a825620ef7851805fd4760e4",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-01 10:37:09 UTC",
    "User": "root"
  },
  "Author": "Thierry Onkelinx [aut, cre] (ORCID:\n<https://orcid.org/0000-0001-8804-4216>),\nResearch Institute for Nature and Forest [cph, fnd]",
  "Maintainer": "Thierry Onkelinx <thierry.onkelinx@inbo.be>",
  "_user": "inbo",
  "_type": "src",
  "_file": "n2khelper_0.5.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/5fd77f73bb2bee37dc8e337dc10166f6c91ca59f95b03532a1484d7bf23e353c",
  "_filesize": 245575,
  "_sha256": "5fd77f73bb2bee37dc8e337dc10166f6c91ca59f95b03532a1484d7bf23e353c",
  "_expires": "2027-01-09T10:40:23.000Z",
  "_created": "2026-10-01T10:37:09.000Z",
  "_published": "2026-10-01T10:40:25.598Z",
  "_jobs": [
    {
      "job": 110330067699,
      "time": 159,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11155905119"
    },
    {
      "job": 110330067822,
      "time": 147,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11155511714"
    },
    {
      "job": 110330067775,
      "time": 104,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11155042808"
    },
    {
      "job": 110330067688,
      "time": 94,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11155371015"
    },
    {
      "job": 110328934888,
      "time": 203,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11154689884"
    },
    {
      "job": 110330067712,
      "time": 144,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11155700575"
    },
    {
      "job": 110330067823,
      "time": 86,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11154968600"
    },
    {
      "job": 110330067813,
      "time": 78,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11154879215"
    },
    {
      "job": 110330067805,
      "time": 78,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11155027901"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/inbo/actions/runs/36849896951",
  "_status": "success",
  "_upstream": "https://github.com/inbo/n2khelper",
  "_commit": {
    "id": "3f02dbac8397a6d9a825620ef7851805fd4760e4",
    "author": "Thierry Onkelinx <ThierryO@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #21 from inbo/checklist\n\nVersion 0.5.0",
    "time": 1648115713
  },
  "_maintainer": {
    "name": "Thierry Onkelinx",
    "email": "thierry.onkelinx@inbo.be",
    "login": "thierryo",
    "mastodon": "@ThierryO@fosstodon.org",
    "orcid": "0000-0001-8804-4216",
    "description": "",
    "uuid": 446636
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.2.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "RODBC",
      "role": "Imports"
    },
    {
      "package": "RPostgreSQL",
      "role": "Imports"
    },
    {
      "package": "assertthat",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "git2r",
      "role": "Imports"
    },
    {
      "package": "lazyeval",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "odbc",
      "role": "Imports"
    },
    {
      "package": "plyr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    },
    {
      "package": "tibble",
      "role": "Suggests"
    }
  ],
  "_owner": "inbo",
  "_selfowned": true,
  "_usedby": 1,
  "_updates": [],
  "_tags": [],
  "_topics": [
    "natura2000"
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "thierryo",
      "count": 388,
      "uuid": 446636
    },
    {
      "user": "hansvancalster",
      "count": 1,
      "uuid": 18713718
    }
  ],
  "_userbio": {
    "uuid": 2735610,
    "type": "organization",
    "name": "Research Institute for Nature and Forest (INBO)",
    "followers": 61,
    "description": "Open source, data and science initiatives of the Research Institute for Nature and Forest (INBO)"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/n2khelper"
  },
  "_devurl": "https://github.com/inbo/n2khelper",
  "_searchresults": 1,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/n2khelper.html",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md"
  ],
  "_cranurl": false,
  "_exports": [
    "check_character",
    "check_dataframe_covariate",
    "check_dataframe_variable",
    "check_dbtable",
    "check_dbtable_variable",
    "check_id",
    "check_path",
    "check_single_posix",
    "check_single_probability",
    "connect_nbn",
    "connect_result",
    "connect_ut_db",
    "cut_date",
    "get_nbn_key",
    "get_nbn_key_multi",
    "get_nbn_name",
    "git_connect",
    "git_connection",
    "is_chartor",
    "match_nbn_key",
    "odbc_connect",
    "odbc_get_id",
    "odbc_get_multi_id",
    "odbc_insert",
    "read_object_environment"
  ],
  "_help": [
    {
      "page": "check_character",
      "title": "Check if the object is a character",
      "topics": [
        "check_character"
      ]
    },
    {
      "page": "check_dataframe_covariate",
      "title": "Check if the covariates are available in a dataframe",
      "topics": [
        "check_dataframe_covariate"
      ]
    },
    {
      "page": "check_dataframe_variable",
      "title": "Check if a data.frame contains variables",
      "topics": [
        "check_dataframe_variable"
      ]
    },
    {
      "page": "check_dbtable",
      "title": "Check if a table is available in a given ODBC connection",
      "topics": [
        "check_dbtable"
      ]
    },
    {
      "page": "check_dbtable_variable",
      "title": "Check if a variable is available in a given table",
      "topics": [
        "check_dbtable_variable"
      ]
    },
    {
      "page": "check_id",
      "title": "Test if an id exists in a given field of the table",
      "topics": [
        "check_id"
      ]
    },
    {
      "page": "check_path",
      "title": "check if a path is an exisiting file or directory",
      "topics": [
        "check_path"
      ]
    },
    {
      "page": "check_single_posix",
      "title": "Check if the object is a single POSIX",
      "topics": [
        "check_single_posix"
      ]
    },
    {
      "page": "check_single_probability",
      "title": "Check if the object is a single probability",
      "topics": [
        "check_single_probability"
      ]
    },
    {
      "page": "connect_nbn",
      "title": "Open a trusted connection to the NBN database",
      "topics": [
        "connect_nbn"
      ]
    },
    {
      "page": "connect_result",
      "title": "Opens an ODBC connection to the 'results' database",
      "topics": [
        "connect_result"
      ]
    },
    {
      "page": "connect_ut_db",
      "title": "connect to the unit test database",
      "topics": [
        "connect_ut_db"
      ]
    },
    {
      "page": "cut_date",
      "title": "Split dates into periods within each year",
      "topics": [
        "cut_date"
      ]
    },
    {
      "page": "get_nbn_key",
      "title": "Get the NBN key of a species",
      "topics": [
        "get_nbn_key"
      ]
    },
    {
      "page": "get_nbn_key_multi",
      "title": "Try multiple languages to get a matching NBN key",
      "topics": [
        "get_nbn_key_multi"
      ]
    },
    {
      "page": "get_nbn_name",
      "title": "Get the name associated with an NBN key",
      "topics": [
        "get_nbn_name"
      ]
    },
    {
      "page": "git_connect",
      "title": "Returns the path of the datasource within the git repository",
      "topics": [
        "git_connect"
      ]
    },
    {
      "page": "gitConnection-class",
      "title": "The gitConnection class",
      "topics": [
        "gitConnection-class",
        "git_connection"
      ]
    },
    {
      "page": "is_chartor",
      "title": "Test if the argument is either character or factor",
      "topics": [
        "is_chartor"
      ]
    },
    {
      "page": "match_nbn_key",
      "title": "Merge NBN keys into a species dataframe",
      "topics": [
        "match_nbn_key"
      ]
    },
    {
      "page": "odbc_connect",
      "title": "connect to a data source through ODBC",
      "topics": [
        "odbc_connect"
      ]
    },
    {
      "page": "odbc_get_id",
      "title": "Get the id of the matching records",
      "topics": [
        "odbc_get_id"
      ]
    },
    {
      "page": "odbc_get_multi_id",
      "title": "Get the corresponding id's",
      "topics": [
        "odbc_get_multi_id"
      ]
    },
    {
      "page": "odbc_insert",
      "title": "Append a data.frame to a table through an ODBC connection",
      "topics": [
        "odbc_insert"
      ]
    },
    {
      "page": "read_object_environment",
      "title": "Read an object from an environment",
      "topics": [
        "read_object_environment"
      ]
    }
  ],
  "_readme": "https://github.com/inbo/n2khelper/raw/HEAD/README.md",
  "_rundeps": [
    "assertthat",
    "bit",
    "bit64",
    "blob",
    "cli",
    "cpp11",
    "DBI",
    "dplyr",
    "generics",
    "git2r",
    "glue",
    "hms",
    "lazyeval",
    "lifecycle",
    "lubridate",
    "magrittr",
    "odbc",
    "pillar",
    "pkgconfig",
    "plyr",
    "purrr",
    "R6",
    "Rcpp",
    "rlang",
    "RODBC",
    "RPostgreSQL",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "timechange",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_score": 2.1760912590556813,
  "_indexed": true,
  "_nocasepkg": "n2khelper",
  "_universes": [
    "inbo",
    "thierryo"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.5.0",
      "date": "2026-10-01T10:39:39.000Z",
      "distro": "resolute",
      "commit": "3f02dbac8397a6d9a825620ef7851805fd4760e4",
      "fileid": "https://r2.ropensci.org/787e3785efc3269fec6b5060d97043fddbebb4e4232733e3782988bddfba07a1",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/36849896951"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.5.0",
      "date": "2026-10-01T10:39:25.000Z",
      "distro": "resolute",
      "commit": "3f02dbac8397a6d9a825620ef7851805fd4760e4",
      "fileid": "https://r2.ropensci.org/04ca95e3b6ffb71f26a992815917542518ced81edefb04c67f13212a70db5502",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/36849896951"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.5.0",
      "date": "2026-10-01T10:38:52.000Z",
      "commit": "3f02dbac8397a6d9a825620ef7851805fd4760e4",
      "fileid": "https://r2.ropensci.org/5cdfb3ae02a38c5cdbed324f19d540e0c56fb6e13ccc1d297be5eb38418a90c7",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/36849896951"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.5.0",
      "date": "2026-10-01T10:38:40.000Z",
      "commit": "3f02dbac8397a6d9a825620ef7851805fd4760e4",
      "fileid": "https://r2.ropensci.org/9a0c0f7f13b78ab8bad3d9aaa89d1161835c80ffeab8e003f46c733899b40a0d",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/36849896951"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.5.0",
      "date": "2026-10-01T10:39:49.000Z",
      "commit": "3f02dbac8397a6d9a825620ef7851805fd4760e4",
      "fileid": "https://r2.ropensci.org/80ca1181e48f58ff8ce4ddab0e5643d25c6cf3eb0ebbd3b80ce7dd3c475e5b41",
      "status": "success",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/36849896951"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.5.0",
      "date": "2026-10-01T10:38:15.000Z",
      "commit": "3f02dbac8397a6d9a825620ef7851805fd4760e4",
      "fileid": "https://r2.ropensci.org/7c5d67dd68a609881891b2062dc5de0fefb4b28b10f9fd3050294054a856ddf6",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/36849896951"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.5.0",
      "date": "2026-10-01T10:38:12.000Z",
      "commit": "3f02dbac8397a6d9a825620ef7851805fd4760e4",
      "fileid": "https://r2.ropensci.org/9447d8a7c83c06540b81f2047f217a43a110bfb87f1f7e00156185779e463dda",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/36849896951"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.5.0",
      "date": "2026-10-01T10:38:09.000Z",
      "commit": "3f02dbac8397a6d9a825620ef7851805fd4760e4",
      "fileid": "https://r2.ropensci.org/af38e09b09efee02f059dcd692ebf1fae3ef13b616fc985f59d7d904db318d88",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/36849896951"
    }
  ]
}