{ "_id": "6a102f1eacfb0bcc41c94b4a", "Package": "inbodb", "Title": "Connect to and Retrieve Data from Databases on the INBO Server", "Version": "0.0.9", "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\"),\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/checklist/communities": "inbo", "Config/checklist/keywords": "sql; databases; queries", "Config/roxygen2/version": "8.0.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-05-12 16:20:59 UTC", "RemoteUrl": "https://github.com/inbo/inbodb", "RemoteRef": "HEAD", "RemoteSha": "65796375a0474ed6cb64d9b481b99ee0376af13e", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-12 17:17:41 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] (ROR:\n)", "Maintainer": "Els Lommelen ", "MD5sum": "c3fe30a6a479a5cad0dc6b1d7e35ddd8", "_user": "inbo", "_type": "src", "_file": "inbodb_0.0.9.tar.gz", "_fileid": "6be4aa27b20ac7a622c63777989869b7c62f329402a85cca86b8694f7b5a85a4", "_filesize": 1383277, "_sha256": "6be4aa27b20ac7a622c63777989869b7c62f329402a85cca86b8694f7b5a85a4", "_created": "2026-05-12T17:17:41.000Z", "_published": "2026-05-22T10:25:34.528Z", "_distro": "noble", "_jobs": [ { "job": 77361318971, "time": 145, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6951041236" }, { "job": 77361319458, "time": 149, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6951042599" }, { "job": 77361319487, "time": 79, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6951017573" }, { "job": 77361319396, "time": 100, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6951025031" }, { "job": 77361318313, "time": 208, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6950986320" }, { "job": 77361318675, "time": 106, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7158293129" }, { "job": 77361319257, "time": 92, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6951022268" }, { "job": 77361319353, "time": 92, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6951022341" }, { "job": 77361319456, "time": 110, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6951030423" } ], "_buildurl": "https://github.com/r-universe/inbo/actions/runs/25750266084", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/inbo/inbodb", "_commit": { "id": "65796375a0474ed6cb64d9b481b99ee0376af13e", "author": "Els Lommelen ", "committer": "GitHub ", "message": "Merge pull request #69 from inbo/bugfix\n\nBugfix", "time": 1778602859 }, "_maintainer": { "name": "Els Lommelen", "email": "els.lommelen@inbo.be", "login": "elslommelen", "uuid": 18716476, "orcid": "0000-0002-3481-5684" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.5.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 } ], "_tags": [ { "name": "v0.0.8", "date": "2026-04-21" }, { "name": "v0.0.9", "date": "2026-05-12" } ], "_topics": [ "database" ], "_stars": 0, "_contributors": [ { "user": "elslommelen", "count": 235, "uuid": 18716476 }, { "user": "hansvancalster", "count": 61, "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": 1, "uuid": 33662631 }, { "user": "peterdesmet", "count": 1, "uuid": 600993 } ], "_userbio": { "uuid": 2735610, "type": "organization", "name": "Research Institute for Nature and Forest (INBO)", "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": 121, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/inbodb.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_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.007064656378332, "_indexed": true, "_nocasepkg": "inbodb", "_universes": [ "inbo", "elslommelen" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.9", "date": "2026-05-12T17:20:04.000Z", "distro": "noble", "commit": "65796375a0474ed6cb64d9b481b99ee0376af13e", "fileid": "766bf8ac2b9566aa7cbc40b80859ea4075a07fb41ee31b1113d831496915c49d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750266084" }, { "r": "4.6.0", "os": "linux", "version": "0.0.9", "date": "2026-05-12T17:20:07.000Z", "distro": "noble", "commit": "65796375a0474ed6cb64d9b481b99ee0376af13e", "fileid": "a2199c82703db8a66812d6f5c71e90ec962e38e45de992c9c0f4145177442c4f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750266084" }, { "r": "4.5.3", "os": "mac", "version": "0.0.9", "date": "2026-05-12T17:19:10.000Z", "commit": "65796375a0474ed6cb64d9b481b99ee0376af13e", "fileid": "4d721b6b2068e51d0a78048818472dee787b9f3521872904c8edd658a4932558", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750266084" }, { "r": "4.6.0", "os": "mac", "version": "0.0.9", "date": "2026-05-12T17:19:25.000Z", "commit": "65796375a0474ed6cb64d9b481b99ee0376af13e", "fileid": "9ad19594f4023713836b560481b6c1c62852dcd9c4531e1da76f382a00c5bc94", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750266084" }, { "r": "4.7.0", "os": "win", "version": "0.0.9", "date": "2026-05-12T17:19:08.000Z", "commit": "65796375a0474ed6cb64d9b481b99ee0376af13e", "fileid": "734c0949a946a088142fcd5739c60d776d87eaf5a649f8aeceac16f0bb73ef0e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750266084" }, { "r": "4.5.3", "os": "win", "version": "0.0.9", "date": "2026-05-12T17:19:09.000Z", "commit": "65796375a0474ed6cb64d9b481b99ee0376af13e", "fileid": "7a74525590ecc56c39a44673908a7bbabb9f74a86b581370e9cc7c462c400519", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750266084" }, { "r": "4.6.0", "os": "win", "version": "0.0.9", "date": "2026-05-12T17:19:30.000Z", "commit": "65796375a0474ed6cb64d9b481b99ee0376af13e", "fileid": "d45d33df4483adb9a03b31b2cc11035c4a5a1992a00ad825485953ae3e703f7b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750266084" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.9", "date": "2026-05-22T10:25:10.000Z", "commit": "65796375a0474ed6cb64d9b481b99ee0376af13e", "fileid": "4302c26e8f7bdc9c06acf31e148c6cd161796654dbf8637ba8865feb191cd012", "status": "success", "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750266084" } ] }