{ "_id": "6ab6869499f7aa8c6aa2eb92", "Package": "inbodb", "Title": "Connect to and Retrieve Data from Databases on the INBO Server", "Version": "0.1.0", "Authors@R": "c(\nperson(\"Els\", \"Lommelen\", , \"els.lommelen@inbo.be\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-3481-5684\", affiliation = \"Research Institute for Nature and Forest (INBO)\")),\nperson(\"Hans\", \"Van Calster\", , \"hans.vancalster@inbo.be\", role = \"aut\",\ncomment = c(ORCID = \"0000-0001-8595-8426\", affiliation = \"Research Institute for Nature and Forest (INBO)\")),\nperson(\"Els\", \"De Bie\", , \"els.debie@inbo.be\", role = \"aut\",\ncomment = c(ORCID = \"0000-0001-7679-743X\", affiliation = \"Research Institute for Nature and Forest (INBO)\")),\nperson(\"Floris\", \"Vanderhaeghe\", , \"floris.vanderhaeghe@inbo.be\", role = \"aut\",\ncomment = c(ORCID = \"0000-0002-6378-6229\", affiliation = \"Research Institute for Nature and Forest (INBO)\")),\nperson(\"Frederic\", \"Piesschaert\", , \"frederic.piesschaert@inbo.be\", role = \"aut\",\ncomment = c(ORCID = \"0000-0002-5843-646X\", affiliation = \"Research Institute for Nature and Forest (INBO)\")),\nperson(\"Toon\", \"Westra\", , \"toon.westra@inbo.be\", role = \"aut\",\ncomment = c(ORCID = \"0000-0003-2478-9459\", affiliation = \"Research Institute for Nature and Forest (INBO)\")),\nperson(\"Stijn\", \"Van Hoey\", , \"stijnvanhoey@gmail.com\", role = \"ctb\",\ncomment = c(ORCID = \"0000-0001-6413-3185\")),\nperson(\"Research Institute for Nature and Forest (INBO)\", , , \"info@inbo.be\", role = c(\"cph\", \"fnd\", \"pbl\"),\ncomment = c(ROR = \"00j54wy13\"))\n)", "Description": "A bundle of functions to connect to and retrieve data from\ndatabases on the INBO server, with dedicated functions to query\nsome of these databases.", "License": "GPL-3", "URL": "https://github.com/inbo/inbodb, https://inbo.github.io/inbodb/", "BugReports": "https://github.com/inbo/inbodb/issues", "VignetteBuilder": "knitr", "Config/citeme/communities": "inbo", "Config/citeme/keywords": "sql; databases; queries", "Config/roxygen2/version": "8.1.0", "Encoding": "UTF-8", "Language": "en-GB", "Roxygen": "list(markdown = TRUE)", "Config/pak/sysreqs": "make unixodbc-dev", "Repository": "https://inbo.r-universe.dev", "Date/Publication": "2026-09-25 14:14:01 UTC", "RemoteUrl": "https://github.com/inbo/inbodb", "RemoteRef": "HEAD", "RemoteSha": "3468eef04f95f220eba57aeec9b57da82e2ce2fe", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-25 14:28:10 UTC", "User": "root" }, "Author": "Els Lommelen [aut, cre] (ORCID:\n, affiliation: Research\nInstitute for Nature and Forest (INBO)),\nHans Van Calster [aut] (ORCID: ,\naffiliation: Research Institute for Nature and Forest (INBO)),\nEls De Bie [aut] (ORCID: ,\naffiliation: Research Institute for Nature and Forest (INBO)),\nFloris Vanderhaeghe [aut] (ORCID:\n, affiliation: Research\nInstitute for Nature and Forest (INBO)),\nFrederic Piesschaert [aut] (ORCID:\n, affiliation: Research\nInstitute for Nature and Forest (INBO)),\nToon Westra [aut] (ORCID: ,\naffiliation: Research Institute for Nature and Forest (INBO)),\nStijn Van Hoey [ctb] (ORCID: ),\nResearch Institute for Nature and Forest (INBO) [cph, fnd, pbl] (ROR:\n)", "Maintainer": "Els Lommelen ", "_user": "inbo", "_type": "src", "_file": "inbodb_0.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/951525a857e177dbaebf248512194e082f31f8e0cc6f6d0ae8eade579b764016", "_filesize": 1384914, "_sha256": "951525a857e177dbaebf248512194e082f31f8e0cc6f6d0ae8eade579b764016", "_expires": "2027-01-03T14:34:58.000Z", "_created": "2026-09-25T14:28:10.000Z", "_published": "2026-09-25T14:35:00.463Z", "_jobs": [ { "job": 108112951247, "time": 156, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "10870052673" }, { "job": 108112951156, "time": 189, "config": "linux-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "10869734179" }, { "job": 108112951254, "time": 123, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "10869942875" }, { "job": 108112951255, "time": 120, "config": "macos-release-arm64", "r": "4.6.1", "check": "WARNING", "artifact": "10870144318" }, { "job": 108111409664, "time": 245, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10869422407" }, { "job": 108112951121, "time": 120, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10870223185" }, { "job": 108112951386, "time": 101, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "10869534279" }, { "job": 108112951256, "time": 86, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "WARNING", "artifact": "10869539206" }, { "job": 108112951221, "time": 101, "config": "windows-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "10869728912" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/inbo/actions/runs/36147216413", "_status": "success", "_upstream": "https://github.com/inbo/inbodb", "_commit": { "id": "3468eef04f95f220eba57aeec9b57da82e2ce2fe", "author": "Els Lommelen ", "committer": "GitHub ", "message": "Merge pull request #79 from inbo/rework_gha\n\nRework gha", "time": 1790345641 }, "_maintainer": { "name": "Els Lommelen", "email": "els.lommelen@inbo.be", "login": "elslommelen", "description": "", "uuid": 18716476, "orcid": "0000-0002-3481-5684" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.2.0", "role": "Depends" }, { "package": "assertthat", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "odbc", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "ggplot2", "role": "Suggests" }, { "package": "kableExtra", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "sf", "role": "Suggests" }, { "package": "tidyr", "role": "Suggests" } ], "_owner": "inbo", "_selfowned": true, "_usedby": 1, "_updates": [ { "week": "2026-17", "n": 1 }, { "week": "2026-20", "n": 1 }, { "week": "2026-25", "n": 1 }, { "week": "2026-39", "n": 1 } ], "_tags": [ { "name": "v0.0.8", "date": "2026-04-21" }, { "name": "v0.0.9", "date": "2026-05-12" }, { "name": "v0.0.10", "date": "2026-06-17" }, { "name": "v0.1.0", "date": "2026-09-25" } ], "_topics": [ "database" ], "_stars": 1, "_contributors": [ { "user": "elslommelen", "count": 262, "uuid": 18716476 }, { "user": "hansvancalster", "count": 71, "uuid": 18713718 }, { "user": "elsdebie", "count": 58, "uuid": 42178245 }, { "user": "fredericpiesschaert", "count": 56, "uuid": 9843453 }, { "user": "toonhub", "count": 44, "uuid": 22740566 }, { "user": "florisvdh", "count": 13, "uuid": 19164640 }, { "user": "damianooldoni", "count": 2, "uuid": 33662631 }, { "user": "peterdesmet", "count": 1, "uuid": 600993 } ], "_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/inbodb" }, "_devurl": "https://github.com/inbo/inbodb", "_pkgdown": "https://inbo.github.io/inbodb/", "_searchresults": 130, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/inbodb.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md" ], "_cranurl": false, "_exports": [ "connect_inbo_dbase", "dbDisconnect", "dbFetch", "get_florabank_observations", "get_florabank_taxon_ifbl_year", "get_florabank_traits", "get_inboveg_classification", "get_inboveg_header", "get_inboveg_layer_cover", "get_inboveg_layer_qualifier", "get_inboveg_ppa", "get_inboveg_qualifier", "get_inboveg_recording", "get_inboveg_relation_recording", "get_inboveg_survey", "get_meetnetten_locations", "get_meetnetten_observations", "get_meetnetten_schemes", "get_meetnetten_visits", "get_taxonlijsten_features", "get_taxonlijsten_items", "get_taxonlijsten_lists" ], "_help": [ { "page": "connect_inbo_dbase", "title": "Connect to an INBO database", "concept": [ "connection" ], "topics": [ "connect_inbo_dbase" ] }, { "page": "dbDisconnect-OdbcConnection-method", "title": "Close database connection", "concept": [ "connection" ], "topics": [ "dbDisconnect,OdbcConnection-method" ] }, { "page": "dbFetch-OdbcResult-method", "title": "Fetch query result from database", "concept": [ "connection" ], "topics": [ "dbFetch,OdbcResult-method" ] }, { "page": "get_florabank_observations", "title": "Get all validated observations for one or more taxa from the florabank database", "concept": [ "florabank" ], "topics": [ "get_florabank_observations" ] }, { "page": "get_florabank_taxon_ifbl_year", "title": "Get unique combinations of taxon, IFBL-square and year.", "concept": [ "florabank" ], "topics": [ "get_florabank_taxon_ifbl_year" ] }, { "page": "get_florabank_traits", "title": "Query the florabank to get taxon trait values for (a) taxon trait(s)", "concept": [ "florabank" ], "topics": [ "get_florabank_traits" ] }, { "page": "get_inboveg_classification", "title": "Query classification information from INBOVEG", "concept": [ "inboveg" ], "topics": [ "get_inboveg_classification" ] }, { "page": "get_inboveg_header", "title": "Query header information from INBOVEG", "concept": [ "inboveg" ], "topics": [ "get_inboveg_header" ] }, { "page": "get_inboveg_layer_cover", "title": "Query layer information of the cover for recordings (relevé) from INBOVEG", "concept": [ "inboveg" ], "topics": [ "get_inboveg_layer_cover" ] }, { "page": "get_inboveg_layer_qualifier", "title": "Query layer qualifier information of recordings (relevé) from INBOVEG", "concept": [ "inboveg" ], "topics": [ "get_inboveg_layer_qualifier" ] }, { "page": "get_inboveg_ppa", "title": "Query PPA (point-plant distance) information from INBOVEG", "concept": [ "inboveg" ], "topics": [ "get_inboveg_ppa" ] }, { "page": "get_inboveg_qualifier", "title": "Query qualifier information of recordings (relevé) from INBOVEG", "concept": [ "inboveg" ], "topics": [ "get_inboveg_qualifier" ] }, { "page": "get_inboveg_recording", "title": "Query recording (relevé) information from INBOVEG", "concept": [ "inboveg" ], "topics": [ "get_inboveg_recording" ] }, { "page": "get_inboveg_relation_recording", "title": "Query relation (Parent - Child) information of recordings (relevé) from INBOVEG", "concept": [ "inboveg" ], "topics": [ "get_inboveg_relation_recording" ] }, { "page": "get_inboveg_survey", "title": "Query survey information from INBOVEG", "concept": [ "inboveg" ], "topics": [ "get_inboveg_survey" ] }, { "page": "get_meetnetten_locations", "title": "Query monitoring scheme locations from Meetnetten", "concept": [ "meetnetten" ], "topics": [ "get_meetnetten_locations" ] }, { "page": "get_meetnetten_observations", "title": "Query observation data from Meetnetten", "concept": [ "meetnetten" ], "topics": [ "get_meetnetten_observations" ] }, { "page": "get_meetnetten_schemes", "title": "Overview of monitoring schemes in the Meetnetten database", "concept": [ "meetnetten" ], "topics": [ "get_meetnetten_schemes" ] }, { "page": "get_meetnetten_visits", "title": "Query visit data from Meetnetten", "concept": [ "meetnetten" ], "topics": [ "get_meetnetten_visits" ] }, { "page": "get_taxonlijsten_features", "title": "Query to extract Taxonlist features from 'D0156_00_Taxonlijsten'", "concept": [ "taxonlijsten" ], "topics": [ "get_taxonlijsten_features" ] }, { "page": "get_taxonlijsten_items", "title": "Query to extract the taxa on a taxonlist from 'D0156_00_Taxonlijsten'", "concept": [ "taxonlijsten" ], "topics": [ "get_taxonlijsten_items" ] }, { "page": "get_taxonlijsten_lists", "title": "Query to extract Taxonlijsten from 'D0156_00_Taxonlijsten'", "concept": [ "taxonlijsten" ], "topics": [ "get_taxonlijsten_lists" ] } ], "_readme": "https://github.com/inbo/inbodb/raw/HEAD/README.md", "_rundeps": [ "assertthat", "bit", "bit64", "blob", "cli", "DBI", "dplyr", "generics", "glue", "hms", "lifecycle", "magrittr", "odbc", "pillar", "pkgconfig", "R6", "Rcpp", "rlang", "tibble", "tidyselect", "utf8", "vctrs", "withr" ], "_vignettes": [ { "source": "get_data_inboveg.Rmd", "filename": "get_data_inboveg.html", "title": "How to retrieve data from the INBOVEG database", "author": "Els De Bie, Hans Van Calster, Jo Loos", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Aim", "Packages and connection", "Functionality", "Survey information", "Header information", "Recording information", "Classification information", "Qualifiers information", "Layer information", "Layer qualifiers", "Parent-child relationships between recordings", "Processing the retrieved data", "More complex queries", "Closing the connection" ], "created": "2021-01-08 17:13:34", "modified": "2026-04-21 16:15:38", "commits": 8 }, { "source": "get_data_meetnetten.Rmd", "filename": "get_data_meetnetten.html", "title": "How to retrieve data from the Meetnetten database", "author": "Toon Westra, Frederic Piesschaert", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Aim", "Packages and connection", "Functionality", "Information on monitoring schemes", "Locations and sublocation of monitoring schemes", "Visits", "Observations", "Closing the connection", "Data policy" ], "created": "2024-08-22 14:22:03", "modified": "2025-02-19 15:39:13", "commits": 2 }, { "source": "get_data_taxonlijsten.Rmd", "filename": "get_data_taxonlijsten.html", "title": "How to retrieve data from the Taxonlijsten database", "author": "Frederic Piesschaert, Dirk Maes, Els Lommelen", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Aim", "Data issues or missing taxonlist", "Packages and connection", "Functionality", "Taxonlists overview", "Taxonlist features", "Taxonlist items", "More complex queries", "Closing the connection", "Database philosophy", "Taxonlijst", "TaxonlijstVersie", "Taxonlijstitem", "TaxonlijstitemInterpretatie", "Taxon", "Kenmerk (= feature)", "Kenmerkwaarde", "TaxonlijstItemAttribuut", "Full data model" ], "created": "2024-08-22 14:22:03", "modified": "2026-04-21 16:15:38", "commits": 3 }, { "source": "odbc_query_problem.Rmd", "filename": "odbc_query_problem.html", "title": "odbc query problem", "engine": "knitr::rmarkdown", "headings": [ "Description of the problem", "Some background on SQL Server and odbc data types", "Consulting data types" ], "created": "2020-04-27 09:46:11", "modified": "2024-08-22 14:22:03", "commits": 4 } ], "_score": 6.3392526340327, "_indexed": true, "_nocasepkg": "inbodb", "_universes": [ "inbo", "elslommelen" ], "_previous": "0.0.10", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-09-25T14:30:43.000Z", "distro": "resolute", "commit": "3468eef04f95f220eba57aeec9b57da82e2ce2fe", "fileid": "https://r2.ropensci.org/2bab3bba28fdf9015f0d1cb42d25808c8208f8d85ec9d8df801190dd19a630d5", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/36147216413" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-09-25T14:31:19.000Z", "distro": "resolute", "commit": "3468eef04f95f220eba57aeec9b57da82e2ce2fe", "fileid": "https://r2.ropensci.org/e20d3a3b0ce4f4ed948ccef8c23c6e7c5399a5287a7cb4f1d704bf4829b2b776", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/36147216413" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-09-25T14:32:09.000Z", "commit": "3468eef04f95f220eba57aeec9b57da82e2ce2fe", "fileid": "https://r2.ropensci.org/eaf9fc97c27bd7ae1335d645a2d619c7944226e5775701995aa14565877c5790", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/36147216413" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0", "date": "2026-09-25T14:34:01.000Z", "commit": "3468eef04f95f220eba57aeec9b57da82e2ce2fe", "fileid": "https://r2.ropensci.org/1bdc935204c278c2cac68dea03266fb7f0547c85f4e2252715f7d8212679d570", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/36147216413" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-09-25T14:30:33.000Z", "commit": "3468eef04f95f220eba57aeec9b57da82e2ce2fe", "fileid": "https://r2.ropensci.org/67fabab4664d5fc6d0ef1ca1a4ffa69346ddae77c5d787116646633ea45e90c3", "status": "success", "buildurl": "https://github.com/r-universe/inbo/actions/runs/36147216413" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-09-25T14:29:42.000Z", "commit": "3468eef04f95f220eba57aeec9b57da82e2ce2fe", "fileid": "https://r2.ropensci.org/9e82dac19157d9b541b4251f9867b48bdb16d23211ad99a7cdc83f04fb1c5601", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/36147216413" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-09-25T14:29:29.000Z", "commit": "3468eef04f95f220eba57aeec9b57da82e2ce2fe", "fileid": "https://r2.ropensci.org/359aeca1b412ccf7752d0fb130ded45ff8fa4efd395725869e61778837e9bef6", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/36147216413" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-09-25T14:29:43.000Z", "commit": "3468eef04f95f220eba57aeec9b57da82e2ce2fe", "fileid": "https://r2.ropensci.org/9e47dc6d25b1b8465e695e11dc15e61852c5d0f970c30d2b69d729903166b13b", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/36147216413" } ] }