{ "_id": "6a0f72c5acfb0bcc41c5ff47", "Package": "birdscanR", "Title": "Migration Traffic Rate Calculation Package for 'Birdscan MR1'\nRadars", "Version": "0.3.0.9029", "Authors@R": "c(\nperson(\"Birgen\", \"Haest\", , \"birgen.haest@vogelwarte.ch\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-8739-6460\")),\nperson(\"Fabian\", \"Hertner\", , \"fabian.hertner@swiss-birdradar.com\", role = c(\"aut\")),\nperson(\"Baptiste\", \"Schmid\", , \"baptiste.schmid@vogelwarte.ch\", role = c(\"ctb\"),\ncomment = c(ORCID = \"0000-0002-7736-7527\")),\nperson(\"Peter\", \"Desmet\", , \"peter.desmet@inbo.be\", role = c(\"ctb\"),\ncomment = c(ORCID = \"0000-0002-8442-8025\")),\nperson(\"Bart\", \"Kranstauber\", , \"b.kranstauber@uva.nl\", role = c(\"ctb\"),\ncomment = c(ORCID = \"0000-0001-8303-780X\")),\nperson(\"Damiano\", \"Preatoni\", , \"damiano.preatoni@uninsubria.it\", role = c(\"ctb\"),\ncomment = c(ORCID = \"0000-0001-8760-1316\")),\nperson(\"Johannes\", \"De Groeve\", , \"j.degroeve@uva.nl\", role = c(\"ctb\"),\ncomment = c(ORCID = \"0000-0002-1274-3237\")),\nperson(\"Felix\", \"Liechti\", , \"felix.liechti@swiss-birdradar.com\", role = c(\"ctb\"),\ncomment = c(ORCID = \"0000-0001-9473-0837\")),\nperson(\"Swiss Ornithological Institute\", role = \"cph\",\ncomment = c(ROR = \"03mcsbr76\")),\nperson(\"Swiss Birdradar Solution AG\", role = \"cph\",\ncomment = \"https://swiss-birdradar.com\")\n)", "Description": "Extract data from 'Birdscan MR1' 'SQL' vertical-looking\nradar databases, filter, and process them to Migration Traffic\nRates (# objects per hour and km) or density (# objects per\nkm3) of, for example birds, and insects. Object classifications\nin the 'Birdscan MR1' databases are based on the dataset of\nHaest et al. (2021) ). Migration\nTraffic Rates and densities can be calculated separately for\ndifferent height bins (with a height resolution of choice) as\nwell as over time periods of choice (e.g., 1/2 hour, 1 hour, 1\nday, day/night, the full time period of observation, and\nanything in between). Two plotting functions are also included\nto explore the data in the 'SQL' databases and the resulting\nMigration Traffic Rate results. For details on the Migration\nTraffic Rate calculation procedures, see Schmid et al. (2019)\n.", "License": "GPL (>= 3)", "URL": "https://github.com/BirdScanCommunity/birdscanR,\nhttps://birdscancommunity.github.io/birdscanR/", "BugReports": "https://github.com/BirdScanCommunity/birdscanR/issues", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "LazyData": "true", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "Config/pak/sysreqs": "libabsl-dev cmake libgdal-dev gdal-bin libgeos-dev\nlibicu-dev unixodbc-dev libssl-dev libproj-dev libsqlite3-dev\nlibudunits2-dev libx11-dev", "Repository": "https://birdscancommunity.r-universe.dev", "Date/Publication": "2026-05-21 19:55:07 UTC", "RemoteUrl": "https://github.com/birdscancommunity/birdscanr", "RemoteRef": "HEAD", "RemoteSha": "c2ac13e25247c38aff12e23a74ef4ea5a1c6fb55", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-21 20:56:30 UTC", "User": "root" }, "Author": "Birgen Haest [aut, cre] (ORCID:\n),\nFabian Hertner [aut],\nBaptiste Schmid [ctb] (ORCID: ),\nPeter Desmet [ctb] (ORCID: ),\nBart Kranstauber [ctb] (ORCID: ),\nDamiano Preatoni [ctb] (ORCID: ),\nJohannes De Groeve [ctb] (ORCID:\n),\nFelix Liechti [ctb] (ORCID: ),\nSwiss Ornithological Institute [cph] (ROR: ),\nSwiss Birdradar Solution AG [cph] (https://swiss-birdradar.com)", "Maintainer": "Birgen Haest ", "MD5sum": "f6d9a74ffe5758784699239ba054c63e", "_user": "birdscancommunity", "_type": "src", "_file": "birdscanR_0.3.0.9029.tar.gz", "_fileid": "749881cb15fa236cc9c586b285cd52d5c7b8f0de21ee2a1ee032d929846d8d6e", "_filesize": 11429396, "_sha256": "749881cb15fa236cc9c586b285cd52d5c7b8f0de21ee2a1ee032d929846d8d6e", "_created": "2026-05-21T20:56:30.000Z", "_published": "2026-05-21T21:01:57.036Z", "_distro": "noble", "_jobs": [ { "job": 77267776843, "time": 185, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7147122164" }, { "job": 77267776933, "time": 163, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7147114945" }, { "job": 77267776881, "time": 102, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7147096193" }, { "job": 77267776936, "time": 108, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7147097860" }, { "job": 77266880791, "time": 316, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7147036048" }, { "job": 77267776925, "time": 121, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7147102827" }, { "job": 77267776906, "time": 126, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7147103132" }, { "job": 77267777783, "time": 106, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7147098779" }, { "job": 77267776964, "time": 109, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7147099708" } ], "_buildurl": "https://github.com/r-universe/birdscancommunity/actions/runs/26252466538", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/birdscancommunity/birdscanr", "_commit": { "id": "c2ac13e25247c38aff12e23a74ef4ea5a1c6fb55", "author": "Birgen Haest ", "committer": "GitHub ", "message": "Merge pull request #91 from BirdScanCommunity/addTestDatabase\n\nAdd test database - This closes #82", "time": 1779393307 }, "_maintainer": { "name": "Birgen Haest", "email": "birgen.haest@vogelwarte.ch", "login": "birgenh", "description": "", "uuid": 15121366, "orcid": "0000-0002-8739-6460" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "DBI", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "ggplot2", "role": "Imports" }, { "package": "grDevices", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "modi", "role": "Imports" }, { "package": "reshape2", "role": "Imports" }, { "package": "RODBC", "role": "Imports" }, { "package": "RPostgreSQL", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "rstudioapi", "role": "Imports" }, { "package": "sp", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "suntools", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "yaml", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "birdscancommunity", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-21", "n": 4 }, { "week": "2025-22", "n": 5 }, { "week": "2025-26", "n": 2 }, { "week": "2025-27", "n": 8 }, { "week": "2025-28", "n": 5 }, { "week": "2025-41", "n": 4 }, { "week": "2025-45", "n": 1 }, { "week": "2025-48", "n": 3 }, { "week": "2026-06", "n": 2 }, { "week": "2026-21", "n": 3 } ], "_tags": [], "_stars": 3, "_contributors": [ { "user": "birgenh", "count": 406, "uuid": 15121366 }, { "user": "peterdesmet", "count": 49, "uuid": 600993 }, { "user": "fabian-hertner", "count": 17, "uuid": 79193325 }, { "user": "baptischmi", "count": 13, "uuid": 12291183 }, { "user": "jedgroev", "count": 1, "uuid": 8254678 } ], "_userbio": { "uuid": 78589098, "type": "organization", "name": "BirdScan Community" }, "_downloads": { "count": 274, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/birdscanR" }, "_devurl": "https://github.com/birdscancommunity/birdscanr", "_pkgdown": "https://birdscancommunity.github.io/birdscanR/", "_searchresults": 6, "_rbuild": "4.6.0", "_assets": [ "extra/birdscanR.html", "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/birdscancommunity/birdscanr", "_realowner": "birdscancommunity", "_cranurl": true, "_releases": [ { "version": "0.1.2", "date": "2023-02-17" }, { "version": "0.2.0", "date": "2023-10-06" }, { "version": "0.3.0", "date": "2024-07-05" } ], "_exports": [ "addDayNightInfoPerEcho", "compileData", "computeDensity", "computeMTR", "convertTimeZone", "createTimeRangeForPlot", "createVPTS", "dbConnectBirdscanSQL", "extractDbData", "filterData", "filterEchoData", "filterProtocolData", "filterSpeedFeature37", "getBatClassification", "getCollectionTable", "getEchoFeatures", "getEchoValidationTable", "getManualVisibilityTable", "getProtocolTable", "getRadarTable", "getRfClassification", "getSiteTable", "getTimeBinsTable", "getVisibilityTable", "loadManualBlindTimes", "mergeVisibilityAndManualBlindTimes", "plotExploration", "plotLongitudinalMTR", "QUERY", "reclassToBats", "saveMTR", "savePlotToFile", "twilight" ], "_datasets": [ { "name": "classAbbreviations", "title": "Default class abbreviations table of the birdscanR package", "object": "classAbbreviations", "class": [ "data.frame" ], "fields": [ "class", "abbr" ], "rows": 9, "table": true, "tojson": true }, { "name": "manualBlindTimes", "title": "Example file on how to include manual blind times for your 'Birdscan MR1' database.", "object": "manualBlindTimes", "class": [ "data.frame" ], "fields": [ "V1", "V2", "V3" ], "rows": 3, "table": true, "tojson": true } ], "_help": [ { "page": "addDayNightInfoPerEcho", "title": "addDayNightInfoPerEcho", "concept": [ "manipulation functions" ], "topics": [ "addDayNightInfoPerEcho" ] }, { "page": "CH_Sempach_2024_SEP24_25_DataExtract", "title": "Example Birdscan MR1 data extract from Sempach, Switzerland", "concept": [ "sample data" ], "topics": [ "CH_Sempach_2024_SEP24_25_DataExtract" ] }, { "page": "classAbbreviations", "title": "Default class abbreviations table of the birdscanR package", "concept": [ "sample data" ], "topics": [ "classAbbreviations" ] }, { "page": "compileData", "title": "compileData", "concept": [ "write file functions" ], "topics": [ "compileData" ] }, { "page": "computeDensity", "title": "computeDensity", "concept": [ "manipulation functions" ], "topics": [ "computeDensity" ] }, { "page": "computeMTR", "title": "computeMTR", "concept": [ "manipulation functions" ], "topics": [ "computeMTR" ] }, { "page": "convertTimeZone", "title": "Converts timestamps from radar time zone to an user-defined time zone", "concept": [ "manipulation functions" ], "topics": [ "convertTimeZone" ] }, { "page": "createTimeRangeForPlot", "title": "Create Time Range for Plot", "concept": [ "plot functions" ], "topics": [ "createTimeRangeForPlot" ] }, { "page": "createVPTS", "title": "createVPTS", "concept": [ "manipulation functions" ], "topics": [ "createVPTS" ] }, { "page": "dbConnectBirdscanSQL", "title": "Connect to a Birdscan SQL database", "concept": [ "read SQL database functions" ], "topics": [ "dbConnectBirdscanSQL" ] }, { "page": "extractDbData", "title": "Extract DB Data", "concept": [ "read SQL database functions" ], "topics": [ "extractDbData" ] }, { "page": "filterData", "title": "filterData", "concept": [ "filter functions" ], "topics": [ "filterData" ] }, { "page": "filterEchoData", "title": "filterEchoData", "concept": [ "filter functions" ], "topics": [ "filterEchoData" ] }, { "page": "filterProtocolData", "title": "filterProtocolData", "concept": [ "filter functions" ], "topics": [ "filterProtocolData" ] }, { "page": "filterSpeedFeature37", "title": "Filter outliers in Speed feature (collection.feature37)", "concept": [ "manipulation functions" ], "topics": [ "filterSpeedFeature37" ] }, { "page": "getBatClassification", "title": "Get a BirdScan 'batClassification' table", "concept": [ "read SQL database functions" ], "topics": [ "getBatClassification" ] }, { "page": "getCollectionTable", "title": "Get BirdScan collection table", "concept": [ "read SQL database functions" ], "topics": [ "getCollectionTable" ] }, { "page": "getEchoFeatures", "title": "Get BirdScan echo features", "concept": [ "read SQL database functions" ], "topics": [ "getEchoFeatures" ] }, { "page": "getEchoValidationTable", "title": "Get a BirdScan echo validation table", "concept": [ "read SQL database functions" ], "topics": [ "getEchoValidationTable" ] }, { "page": "getManualVisibilityTable", "title": "Get manual visibility table", "concept": [ "read file functions" ], "topics": [ "getManualVisibilityTable" ] }, { "page": "getProtocolTable", "title": "Get BirdScan protocol table", "concept": [ "read SQL database functions" ], "topics": [ "getProtocolTable" ] }, { "page": "getRadarTable", "title": "Get a BirdScan radar table", "concept": [ "read SQL database functions" ], "topics": [ "getRadarTable" ] }, { "page": "getRfClassification", "title": "Get a BirdScan 'rfClassification' table", "concept": [ "read SQL database functions" ], "topics": [ "getRfClassification" ] }, { "page": "getSiteTable", "title": "Get BirdScan site table", "concept": [ "read SQL database functions" ], "topics": [ "getSiteTable" ] }, { "page": "getTimeBinsTable", "title": "Get BirdScan time bins table", "concept": [ "read SQL database functions" ], "topics": [ "getTimeBinsTable" ] }, { "page": "getVisibilityTable", "title": "Get BirdScan visibility table", "concept": [ "read SQL database functions" ], "topics": [ "getVisibilityTable" ] }, { "page": "loadManualBlindTimes", "title": "loadManualBlindTimes", "concept": [ "sample data" ], "topics": [ "loadManualBlindTimes" ] }, { "page": "manualBlindTimes", "title": "Example file on how to include manual blind times for your 'Birdscan MR1' database.", "concept": [ "sample data" ], "topics": [ "manualBlindTimes" ] }, { "page": "mergeVisibilityAndManualBlindTimes", "title": "mergeVisibilityAndManualBlindTimes", "concept": [ "manipulation functions" ], "topics": [ "mergeVisibilityAndManualBlindTimes" ] }, { "page": "plotExploration", "title": "plotExploration", "concept": [ "plot functions" ], "topics": [ "plotExploration" ] }, { "page": "plotLongitudinalMTR", "title": "plotLongitudinalMTR", "concept": [ "plot functions" ], "topics": [ "plotLongitudinalMTR" ] }, { "page": "QUERY", "title": "Query 'SQL' database", "concept": [ "read SQL database functions" ], "topics": [ "QUERY" ] }, { "page": "reclassToBats", "title": "integrate bat classification", "concept": [ "manipulation functions" ], "topics": [ "reclassToBats" ] }, { "page": "saveMTR", "title": "saveMTR", "concept": [ "write file functions" ], "topics": [ "saveMTR" ] }, { "page": "savePlotToFile", "title": "savePlotToFile", "concept": [ "write file functions" ], "topics": [ "savePlotToFile" ] }, { "page": "twilight", "title": "Get the nautical, civil, and solar dawn and dusk for a given timerange and locations.", "concept": [ "manipulation functions" ], "topics": [ "twilight" ] } ], "_readme": "https://github.com/birdscancommunity/birdscanr/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "class", "classInt", "cli", "clipr", "cpp11", "crayon", "DBI", "dplyr", "e1071", "farver", "generics", "ggplot2", "glue", "gtable", "hms", "isoband", "KernSmooth", "labeling", "lattice", "lifecycle", "magrittr", "MASS", "modi", "norm", "pillar", "pkgconfig", "plyr", "prettyunits", "progress", "proxy", "purrr", "R6", "RColorBrewer", "Rcpp", "readr", "reshape2", "rlang", "RODBC", "RPostgreSQL", "rstudioapi", "s2", "S7", "scales", "sf", "sp", "stringi", "stringr", "suntools", "tibble", "tidyr", "tidyselect", "tzdb", "units", "utf8", "vctrs", "viridisLite", "vroom", "withr", "wk", "yaml" ], "_vignettes": [ { "source": "extractingSingleTableFromTheSqlDatabase.Rmd", "filename": "extractingSingleTableFromTheSqlDatabase.html", "title": "Guide to extracting specific tables from a Birdscan MR1 SQL database", "author": "Birgen Haest, Fabian Hertner, Baptiste Schmid", "engine": "knitr::rmarkdown", "headings": [ "Summary", "Before we get started", "Examples", "Extracting the bat classification table", "Extracting the echo collection table", "Extracting specific echo features form the echo_rffeature_map table", "Extracting information on the study site" ], "created": "2025-07-03 15:46:17", "modified": "2025-10-10 12:15:05", "commits": 3 }, { "source": "birdscanR.Rmd", "filename": "birdscanR.html", "title": "Introduction to birdscanR", "author": "Birgen Haest, Baptiste Schmid, Fabian Hertner", "engine": "knitr::rmarkdown", "headings": [ "Summary", "Before we get started", "Step 1: Extract the relevant data from the SQL database (or load it from a )", "Step 2: (optional) Join the bat classification with the base MR1 classification output", "Step 3: Filter the extracted data to what you are interested in", "Step 4: Calculate the activity or migration traffic rates", "Create some plots to explore the calculated activity / migration traffic rates" ], "created": "2025-05-13 08:31:40", "modified": "2026-02-04 08:38:15", "commits": 6 } ], "_score": 6.079181246047625, "_indexed": true, "_nocasepkg": "birdscanr", "_universes": [ "birdscancommunity", "birgenh" ], "_previous": "0.3.0.9028", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.0.9029", "date": "2026-05-21T21:01:02.000Z", "distro": "noble", "commit": "c2ac13e25247c38aff12e23a74ef4ea5a1c6fb55", "fileid": "693d054a718e4add84ece4ee950f7c456e73edfd7467a9e5f010682eb4666262", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/birdscancommunity/actions/runs/26252466538" }, { "r": "4.6.0", "os": "linux", "version": "0.3.0.9029", "date": "2026-05-21T21:00:44.000Z", "distro": "noble", "commit": "c2ac13e25247c38aff12e23a74ef4ea5a1c6fb55", "fileid": "15d492e5c491c084b73c258a1efde0904a6b5e0640291172dbe8f292816101f7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/birdscancommunity/actions/runs/26252466538" }, { "r": "4.5.3", "os": "mac", "version": "0.3.0.9029", "date": "2026-05-21T20:59:53.000Z", "commit": "c2ac13e25247c38aff12e23a74ef4ea5a1c6fb55", "fileid": "149c0a6015dd8d557c9778b3a86aee2ee35cdca32e0225373bca44fd10596333", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/birdscancommunity/actions/runs/26252466538" }, { "r": "4.6.0", "os": "mac", "version": "0.3.0.9029", "date": "2026-05-21T20:59:53.000Z", "commit": "c2ac13e25247c38aff12e23a74ef4ea5a1c6fb55", "fileid": "f5e1a79748a51a5be4c7b2edf38c519797898889b15446c31bc244382d01891b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/birdscancommunity/actions/runs/26252466538" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.0.9029", "date": "2026-05-21T21:00:32.000Z", "commit": "c2ac13e25247c38aff12e23a74ef4ea5a1c6fb55", "fileid": "983cf60861e64a01560c866129ccab3fa9c0f60393c34da23a9d6bb9b65011da", "status": "success", "buildurl": "https://github.com/r-universe/birdscancommunity/actions/runs/26252466538" }, { "r": "4.7.0", "os": "win", "version": "0.3.0.9029", "date": "2026-05-21T20:59:52.000Z", "commit": "c2ac13e25247c38aff12e23a74ef4ea5a1c6fb55", "fileid": "d1221788ff9f2e498b2692f23c552c9529f175bdff4cb3e8470aea7691cc7bbc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/birdscancommunity/actions/runs/26252466538" }, { "r": "4.5.3", "os": "win", "version": "0.3.0.9029", "date": "2026-05-21T20:59:45.000Z", "commit": "c2ac13e25247c38aff12e23a74ef4ea5a1c6fb55", "fileid": "a291d38fc34644a98a89b180a97de692029439253dac26c72dc50440726b8f43", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/birdscancommunity/actions/runs/26252466538" }, { "r": "4.6.0", "os": "win", "version": "0.3.0.9029", "date": "2026-05-21T20:59:43.000Z", "commit": "c2ac13e25247c38aff12e23a74ef4ea5a1c6fb55", "fileid": "5259fdb41df783fe165527dcf39b5b77efbbeb804a7bed7d379398d4937e20c6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/birdscancommunity/actions/runs/26252466538" } ] }