{ "_id": "6a328e133efcd9bda438e19b", "Package": "inbodb", "Title": "Connect to and Retrieve Data from Databases on the INBO Server", "Version": "0.0.10", "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-06-17 07:43:08 UTC", "RemoteUrl": "https://github.com/inbo/inbodb", "RemoteRef": "HEAD", "RemoteSha": "fe551aa70ad8615b29ac4da289498748d15399ea", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-17 11:58:50 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": "5d1f455b671ea7eaefaa241b5c656a74", "_user": "inbo", "_type": "src", "_file": "inbodb_0.0.10.tar.gz", "_fileid": "62a32e0e20c57d2ab4e7848ceae35fdf2c06dbaead33cd3853579715a00528a3", "_filesize": 1383588, "_sha256": "62a32e0e20c57d2ab4e7848ceae35fdf2c06dbaead33cd3853579715a00528a3", "_created": "2026-06-17T11:58:50.000Z", "_published": "2026-06-17T12:07:47.173Z", "_distro": "noble", "_jobs": [ { "job": 81889057949, "time": 140, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "7694688908" }, { "job": 81889057989, "time": 138, "config": "linux-release-x86_64", "r": "4.6.0", "check": "WARNING", "artifact": "7694691384" }, { "job": 81889057980, "time": 104, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "7694760661" }, { "job": 81889058075, "time": 122, "config": "macos-release-arm64", "r": "4.6.0", "check": "WARNING", "artifact": "7694818717" }, { "job": 81888358103, "time": 227, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7694637232" }, { "job": 81889058004, "time": 116, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7694679754" }, { "job": 81889057966, "time": 88, "config": "windows-devel", "r": "4.7.0", "check": "WARNING", "artifact": "7694670786" }, { "job": 81889058118, "time": 81, "config": "windows-oldrel", "r": "4.5.3", "check": "WARNING", "artifact": "7694667062" }, { "job": 81889058186, "time": 110, "config": "windows-release", "r": "4.6.0", "check": "WARNING", "artifact": "7694674354" } ], "_buildurl": "https://github.com/r-universe/inbo/actions/runs/27687067848", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/inbo/inbodb", "_commit": { "id": "fe551aa70ad8615b29ac4da289498748d15399ea", "author": "Els Lommelen ", "committer": "GitHub ", "message": "Merge pull request #71 from inbo/bugfix\n\nBugfix: solve encoding problem", "time": 1781682188 }, "_maintainer": { "name": "Els Lommelen", "email": "els.lommelen@inbo.be", "login": "elslommelen", "description": "", "uuid": 18716476, "orcid": "0000-0002-3481-5684" }, "_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 } ], "_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" } ], "_topics": [ "database" ], "_stars": 0, "_contributors": [ { "user": "elslommelen", "count": 243, "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)", "followers": 58, "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": 125, "_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.19728055812562, "_indexed": true, "_nocasepkg": "inbodb", "_universes": [ "inbo", "elslommelen" ], "_previous": "0.0.9", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.10", "date": "2026-06-17T12:01:03.000Z", "distro": "noble", "commit": "fe551aa70ad8615b29ac4da289498748d15399ea", "fileid": "7b65395e3103b971abce6f1b6d4488c59cca043c62dd1cd50cf5a79ffb4b107f", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/27687067848" }, { "r": "4.6.0", "os": "linux", "version": "0.0.10", "date": "2026-06-17T12:01:08.000Z", "distro": "noble", "commit": "fe551aa70ad8615b29ac4da289498748d15399ea", "fileid": "bbfd87da6425ab7fe82bb401c40ed0cf2396203f1104c2f21478f02951fcc5aa", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/27687067848" }, { "r": "4.5.3", "os": "mac", "version": "0.0.10", "date": "2026-06-17T12:04:21.000Z", "commit": "fe551aa70ad8615b29ac4da289498748d15399ea", "fileid": "4d964d2df880a23f679a38a9ac2a570b394af60db41297fe578a6d0fb94744a7", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/27687067848" }, { "r": "4.6.0", "os": "mac", "version": "0.0.10", "date": "2026-06-17T12:06:56.000Z", "commit": "fe551aa70ad8615b29ac4da289498748d15399ea", "fileid": "fd3092d0e493c8836d1133eaf8838594a7014db910a4408e02d32bea2e0af1e2", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/27687067848" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.10", "date": "2026-06-17T12:01:02.000Z", "commit": "fe551aa70ad8615b29ac4da289498748d15399ea", "fileid": "04132df566aee4e4992ce8986d3316f21ed0ab792285c5cbe25bc9a514d00f63", "status": "success", "buildurl": "https://github.com/r-universe/inbo/actions/runs/27687067848" }, { "r": "4.7.0", "os": "win", "version": "0.0.10", "date": "2026-06-17T12:00:05.000Z", "commit": "fe551aa70ad8615b29ac4da289498748d15399ea", "fileid": "c7a20d5f120e42bd9dfc64917972a5894d717fe46b48603c5997b955d2605201", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/27687067848" }, { "r": "4.5.3", "os": "win", "version": "0.0.10", "date": "2026-06-17T11:59:57.000Z", "commit": "fe551aa70ad8615b29ac4da289498748d15399ea", "fileid": "867285c3dd7681b069f967fa7a973cd5834d0dea884a506711e03fda9e3af061", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/27687067848" }, { "r": "4.6.0", "os": "win", "version": "0.0.10", "date": "2026-06-17T12:00:18.000Z", "commit": "fe551aa70ad8615b29ac4da289498748d15399ea", "fileid": "bcd7e9143a5f985a53d75ed2cf6ede827e6869e0a6aabee94bec06759f86d9be", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/inbo/actions/runs/27687067848" } ] }