{
  "_id": "6ac62097f511ae58c09a686f",
  "Package": "naturdata",
  "Title": "Tools For Working With Naturdata_kalo",
  "Version": "0.4.17",
  "Authors@R": "person(\"Lars\", \"Dalby\", , \"lars.dalby@ecos.au.dk\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-7270-6999\"))",
  "Description": "This R package provides tools for working with the\nnaturdata_kalo database",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "Config/testthat/edition": "3",
  "LazyData": "true",
  "Config/roxygen2/version": "8.1.0",
  "Config/pak/sysreqs": "make libicu-dev unixodbc-dev",
  "Repository": "https://ldalby.r-universe.dev",
  "Date/Publication": "2026-10-06 07:24:26 UTC",
  "RemoteUrl": "https://gitlab.au.dk/ecos/tools/r-pkgs/naturdata",
  "RemoteRef": "HEAD",
  "RemoteSha": "0ec42c36c0b82ad78947ff7da34e435aad7be93c",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-07 09:05:06 UTC",
    "User": "root"
  },
  "Author": "Lars Dalby [aut, cre] (ORCID: <https://orcid.org/0000-0002-7270-6999>)",
  "Maintainer": "Lars Dalby <lars.dalby@ecos.au.dk>",
  "_user": "ldalby",
  "_type": "src",
  "_file": "naturdata_0.4.17.tar.gz",
  "_fileid": "https://r2.ropensci.org/10bab0ec130bd80ff9a79493caca2fc398d33736d62eb1cd778e1f2556f7b774",
  "_filesize": 256692,
  "_sha256": "10bab0ec130bd80ff9a79493caca2fc398d33736d62eb1cd778e1f2556f7b774",
  "_expires": "2027-01-15T10:36:04.000Z",
  "_created": "2026-10-07T09:05:06.000Z",
  "_published": "2026-10-07T10:36:06.908Z",
  "_buildurl": "https://github.com/r-universe/ldalby/actions/runs/37595473323",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 112715853612,
      "time": 118,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11472172677"
    },
    {
      "job": 112715853663,
      "time": 125,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11471603121"
    },
    {
      "job": 112715853889,
      "time": 108,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11475623501"
    },
    {
      "job": 112715853949,
      "time": 104,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11475931549"
    },
    {
      "job": 112710628998,
      "time": 214,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11471687008"
    },
    {
      "job": 112715853680,
      "time": 103,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11471758703"
    },
    {
      "job": 112715853707,
      "time": 84,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11471437679"
    },
    {
      "job": 112715853679,
      "time": 82,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11471712387"
    },
    {
      "job": 112715853631,
      "time": 88,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11471432754"
    }
  ],
  "_upstream": "https://gitlab.au.dk/ecos/tools/r-pkgs/naturdata",
  "_commit": {
    "id": "0ec42c36c0b82ad78947ff7da34e435aad7be93c",
    "author": "Lars Dalby <lars@bios.au.dk>",
    "committer": "Lars Dalby <lars@bios.au.dk>",
    "message": "Merge branch 'development' into 'main'\n\nGeneralise db helpers beyond NOVANA\n\nSee merge request ecos/tools/r-pkgs/naturdata!62",
    "time": 1791271466
  },
  "_maintainer": {
    "name": "Lars Dalby",
    "email": "lars.dalby@ecos.au.dk",
    "orcid": "0000-0002-7270-6999"
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.2.0",
      "role": "Depends"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "lifecycle",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "odbc",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "RSQLite",
      "role": "Imports"
    },
    {
      "package": "stringi",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "wk",
      "role": "Imports"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    }
  ],
  "_owner": "gitlab-r-pkgs",
  "_selfowned": false,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-41",
      "n": 1
    }
  ],
  "_tags": [],
  "_userbio": {
    "uuid": 2366579,
    "type": "user",
    "name": "Lars Dalby",
    "followers": 7,
    "description": "Data scientist, ecologist, PhD.\r\n\r\n"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/naturdata"
  },
  "_searchresults": 0,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/naturdata.html",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_cranurl": false,
  "_exports": [
    "ndb_aggregate_pinpoint",
    "ndb_append_coords",
    "ndb_calc_avg",
    "ndb_calc_cover_ratio",
    "ndb_calc_jord_cn",
    "ndb_calc_n_arter",
    "ndb_calc_n_store_stammer",
    "ndb_calc_weighted_assessment",
    "ndb_clean_artsliste",
    "ndb_clean_kemi",
    "ndb_clean_lysaaben_struktur",
    "ndb_clean_plantekemi",
    "ndb_clean_skov_doedtved",
    "ndb_clean_skov_struktur",
    "ndb_clean_stamdata",
    "ndb_connect",
    "ndb_create_tbl",
    "ndb_disconnect",
    "ndb_filter_artsliste",
    "ndb_filter_lysaaben_prog",
    "ndb_filter_novana",
    "ndb_filter_skov_prog",
    "ndb_get",
    "ndb_get_artsliste_pf",
    "ndb_get_artsnavne",
    "ndb_get_artsscorer",
    "ndb_get_arttraits",
    "ndb_get_doedtved",
    "ndb_get_ellenberg",
    "ndb_get_laver",
    "ndb_get_lysaaben_struktur",
    "ndb_get_mosser",
    "ndb_get_novana_aktids",
    "ndb_get_plantekemi",
    "ndb_get_schema",
    "ndb_get_skov_struktur",
    "ndb_get_skov_trae_diam_naturtype",
    "ndb_get_skov_traeregistrering",
    "ndb_get_stamdata",
    "ndb_get_tbl",
    "ndb_label",
    "ndb_rename",
    "ndb_to_percent",
    "ndb_update_import_job",
    "ndb_write_artsliste",
    "ndb_write_to_db"
  ],
  "_datasets": [
    {
      "name": "ndb_labels",
      "title": "Naturdata_kalo labels",
      "object": "ndb_labels",
      "class": [
        "character"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    },
    {
      "name": "ndb_names",
      "title": "Naturdata_kalo names",
      "object": "ndb_names",
      "class": [
        "character"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    },
    {
      "name": "nogo_naturtyper",
      "title": "No-go naturtyper",
      "object": "nogo_naturtyper",
      "class": [
        "numeric"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "get_condition",
      "title": "Generate a condition string",
      "topics": [
        "get_condition"
      ]
    },
    {
      "page": "ndb_aggregate_pinpoint",
      "title": "Calculate number of pins hit by an aggregated species group",
      "topics": [
        "ndb_aggregate_pinpoint"
      ]
    },
    {
      "page": "ndb_append_coords",
      "title": "Extract x and y from WKT",
      "topics": [
        "ndb_append_coords"
      ]
    },
    {
      "page": "ndb_calc_avg",
      "title": "Calculate the average across multiple columns",
      "topics": [
        "ndb_calc_avg"
      ]
    },
    {
      "page": "ndb_calc_cover_ratio",
      "title": "Calculate the cover ratio",
      "topics": [
        "ndb_calc_cover_ratio"
      ]
    },
    {
      "page": "ndb_calc_jord_cn",
      "title": "Calculate jord_CN",
      "topics": [
        "ndb_calc_jord_cn"
      ]
    },
    {
      "page": "ndb_calc_n_arter",
      "title": "Calculate the number of unique species observations",
      "topics": [
        "ndb_calc_n_arter"
      ]
    },
    {
      "page": "ndb_calc_n_store_stammer",
      "title": "Calculate the number of large trunks",
      "topics": [
        "ndb_calc_n_store_stammer"
      ]
    },
    {
      "page": "ndb_calc_weighted_assessment",
      "title": "Calculate an area weighted assessment",
      "topics": [
        "ndb_calc_weighted_assessment"
      ]
    },
    {
      "page": "ndb_clean_artsliste",
      "title": "Function to clean the artsliste table",
      "topics": [
        "ndb_clean_artsliste"
      ]
    },
    {
      "page": "ndb_clean_kemi",
      "title": "Function to clean the raw.kemi table",
      "topics": [
        "ndb_clean_kemi"
      ]
    },
    {
      "page": "ndb_clean_lysaaben_struktur",
      "title": "Function to clean the raw.lysaaben_struktur table",
      "topics": [
        "ndb_clean_lysaaben_struktur"
      ]
    },
    {
      "page": "ndb_clean_plantekemi",
      "title": "Function to clean the plantekemi table",
      "topics": [
        "ndb_clean_plantekemi"
      ]
    },
    {
      "page": "ndb_clean_skov_doedtved",
      "title": "Function to clean the skov_doedtved table",
      "topics": [
        "ndb_clean_skov_doedtved"
      ]
    },
    {
      "page": "ndb_clean_skov_struktur",
      "title": "Function to clean the skov_struktur table",
      "topics": [
        "ndb_clean_skov_struktur"
      ]
    },
    {
      "page": "ndb_clean_stamdata",
      "title": "Function to clean the raw.stamdata table",
      "topics": [
        "ndb_clean_stamdata"
      ]
    },
    {
      "page": "ndb_connect",
      "title": "Connect to naturdata_kalo",
      "topics": [
        "ndb_connect"
      ]
    },
    {
      "page": "ndb_create_tbl",
      "title": "Create and write table",
      "topics": [
        "ndb_create_tbl"
      ]
    },
    {
      "page": "ndb_disconnect",
      "title": "Disconnect from database",
      "topics": [
        "ndb_disconnect"
      ]
    },
    {
      "page": "ndb_filter_artsliste",
      "title": "Filter the artsliste table",
      "topics": [
        "ndb_filter_artsliste"
      ]
    },
    {
      "page": "ndb_filter_lysaaben_prog",
      "title": "Filter to only program IDs for lysåben",
      "topics": [
        "ndb_filter_lysaaben_prog"
      ]
    },
    {
      "page": "ndb_filter_novana",
      "title": "Filter to only NOVANA activities",
      "topics": [
        "ndb_filter_novana"
      ]
    },
    {
      "page": "ndb_filter_skov_prog",
      "title": "Filter to only skov programs",
      "topics": [
        "ndb_filter_skov_prog"
      ]
    },
    {
      "page": "ndb_get",
      "title": "Get a specified table from the database",
      "topics": [
        "ndb_get"
      ]
    },
    {
      "page": "ndb_get_artsgruppe",
      "title": "Get the artsgruppe_planter table",
      "topics": [
        "ndb_get_artsgruppe"
      ]
    },
    {
      "page": "ndb_get_artsliste_pf",
      "title": "Get the artsliste table",
      "topics": [
        "ndb_get_artsliste_pf"
      ]
    },
    {
      "page": "ndb_get_artsnavne",
      "title": "Get the list of species names",
      "topics": [
        "ndb_get_artsnavne"
      ]
    },
    {
      "page": "ndb_get_artsscorer",
      "title": "Get the list of artsscorer per species",
      "topics": [
        "ndb_get_artsscorer"
      ]
    },
    {
      "page": "ndb_get_arttraits",
      "title": "Get the list of traits",
      "topics": [
        "ndb_get_arttraits"
      ]
    },
    {
      "page": "ndb_get_doedtved",
      "title": "Get the skov doedtved table",
      "topics": [
        "ndb_get_doedtved"
      ]
    },
    {
      "page": "ndb_get_ellenberg",
      "title": "Get the Ellenberg values",
      "topics": [
        "ndb_get_ellenberg"
      ]
    },
    {
      "page": "ndb_get_laver",
      "title": "Get the list of lichen species names",
      "topics": [
        "ndb_get_laver"
      ]
    },
    {
      "page": "ndb_get_lysaaben_struktur",
      "title": "Get the lysaaben struktur table",
      "topics": [
        "ndb_get_lysaaben_struktur"
      ]
    },
    {
      "page": "ndb_get_mosser",
      "title": "Get the artsnavne table only of bryophytes",
      "topics": [
        "ndb_get_mosser"
      ]
    },
    {
      "page": "ndb_get_novana_aktids",
      "title": "Get the list of aktId's from NOVANA",
      "topics": [
        "ndb_get_novana_aktids"
      ]
    },
    {
      "page": "ndb_get_plantekemi",
      "title": "Get the plantekemi table",
      "topics": [
        "ndb_get_plantekemi"
      ]
    },
    {
      "page": "ndb_get_schema",
      "title": "Get the database schema",
      "topics": [
        "ndb_get_schema"
      ]
    },
    {
      "page": "ndb_get_skov_struktur",
      "title": "Get the skov struktur table",
      "topics": [
        "ndb_get_skov_struktur"
      ]
    },
    {
      "page": "ndb_get_skov_trae_diam_naturtype",
      "title": "Get the trae diameter per naturtype table",
      "topics": [
        "ndb_get_skov_trae_diam_naturtype"
      ]
    },
    {
      "page": "ndb_get_skov_traeregistrering",
      "title": "Get the skov traeregistrering table",
      "topics": [
        "ndb_get_skov_traeregistrering"
      ]
    },
    {
      "page": "ndb_get_stamdata",
      "title": "Get the stamdata table",
      "topics": [
        "ndb_get_stamdata"
      ]
    },
    {
      "page": "ndb_get_tbl",
      "title": "Get table from the database and filter",
      "topics": [
        "ndb_get_tbl"
      ]
    },
    {
      "page": "ndb_label",
      "title": "Given the variable name, return the label",
      "topics": [
        "ndb_label"
      ]
    },
    {
      "page": "ndb_labels",
      "title": "Naturdata_kalo labels",
      "topics": [
        "ndb_labels"
      ]
    },
    {
      "page": "ndb_names",
      "title": "Naturdata_kalo names",
      "topics": [
        "ndb_names"
      ]
    },
    {
      "page": "ndb_rename",
      "title": "Rename either a data.frame or vector",
      "topics": [
        "ndb_rename"
      ]
    },
    {
      "page": "ndb_to_percent",
      "title": "Convert from m^{2} cover to percent",
      "topics": [
        "ndb_to_percent"
      ]
    },
    {
      "page": "ndb_update_import_job",
      "title": "Update the import.jobs table",
      "topics": [
        "ndb_update_import_job"
      ]
    },
    {
      "page": "ndb_write_artsliste",
      "title": "Write artsliste to database",
      "topics": [
        "ndb_write_artsliste"
      ]
    },
    {
      "page": "ndb_write_to_db",
      "title": "Write table to database",
      "topics": [
        "ndb_write_to_db"
      ]
    },
    {
      "page": "nogo_naturtyper",
      "title": "No-go naturtyper",
      "topics": [
        "nogo_naturtyper"
      ]
    },
    {
      "page": "replace_na_if",
      "title": "Replace NA values based on a set of conditions",
      "topics": [
        "replace_na_if"
      ]
    }
  ],
  "_readme": "https://gitlab.au.dk/ecos/tools/r-pkgs/naturdata/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "DBI",
    "dbplyr",
    "dplyr",
    "fastmap",
    "generics",
    "glue",
    "hms",
    "lifecycle",
    "lubridate",
    "magrittr",
    "memoise",
    "odbc",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "Rcpp",
    "rlang",
    "RSQLite",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "timechange",
    "utf8",
    "vctrs",
    "withr",
    "wk"
  ],
  "_score": 1.6989700043360187,
  "_indexed": false,
  "_nocasepkg": "naturdata",
  "_universes": [
    "ldalby"
  ],
  "_previous": "0.4.16",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.4.17",
      "date": "2026-10-07T09:14:25.000Z",
      "distro": "resolute",
      "commit": "0ec42c36c0b82ad78947ff7da34e435aad7be93c",
      "fileid": "https://r2.ropensci.org/9855fee2caf9ce2e5ab6d1c64ec35d87e3023344bcacbdcc60c7774768eb9a1e",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/ldalby/actions/runs/37595473323"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.4.17",
      "date": "2026-10-07T09:14:31.000Z",
      "distro": "resolute",
      "commit": "0ec42c36c0b82ad78947ff7da34e435aad7be93c",
      "fileid": "https://r2.ropensci.org/975a6b446a62c168a922cfdb8161d828b19956789632defabbc3b9395a54a523",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/ldalby/actions/runs/37595473323"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.4.17",
      "date": "2026-10-07T10:35:05.000Z",
      "commit": "0ec42c36c0b82ad78947ff7da34e435aad7be93c",
      "fileid": "https://r2.ropensci.org/1091321b687392d20b143686a1fc91cd6a155132f7bc2bf8f74e2bc829a5bd45",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/ldalby/actions/runs/37595473323"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.4.17",
      "date": "2026-10-07T10:35:27.000Z",
      "commit": "0ec42c36c0b82ad78947ff7da34e435aad7be93c",
      "fileid": "https://r2.ropensci.org/be19093bf927b1df10b3d885ec9e5b599fbf2cb851d5526a1d254fc44e51f6db",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/ldalby/actions/runs/37595473323"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.4.17",
      "date": "2026-10-07T09:14:26.000Z",
      "commit": "0ec42c36c0b82ad78947ff7da34e435aad7be93c",
      "fileid": "https://r2.ropensci.org/a09deb04f965f24f064562adb1ba22313988d2a16ff0085bd91b33aa85667314",
      "status": "success",
      "buildurl": "https://github.com/r-universe/ldalby/actions/runs/37595473323"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.4.17",
      "date": "2026-10-07T09:06:34.000Z",
      "commit": "0ec42c36c0b82ad78947ff7da34e435aad7be93c",
      "fileid": "https://r2.ropensci.org/ab47837b0e4b822c613546c8def3c30daa513957c466b593e0a01d8e09965cbe",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/ldalby/actions/runs/37595473323"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.4.17",
      "date": "2026-10-07T09:06:32.000Z",
      "commit": "0ec42c36c0b82ad78947ff7da34e435aad7be93c",
      "fileid": "https://r2.ropensci.org/dcbe256e6c43d4dfa4583f1c919e945600ab6b73f5f1b888c5a8b7b3b8b01896",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/ldalby/actions/runs/37595473323"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.4.17",
      "date": "2026-10-07T09:06:41.000Z",
      "commit": "0ec42c36c0b82ad78947ff7da34e435aad7be93c",
      "fileid": "https://r2.ropensci.org/774030f7f0bb8b5df46761bdc5a8cfc4c13ea214c2cde43b7fe1a78815963a57",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/ldalby/actions/runs/37595473323"
    }
  ]
}