Executing tagme() for project fails with 'Join columns must be present in data'

150 views
Skip to first unread message

Rich Schramm

unread,
Apr 20, 2022, 11:39:22 AM4/20/22
to Motus Wildlife Tracking System
Im a new motus user.  Project is USFWS MB R9 Shorebird Project (#337)
 Im trying to load our project via tagme() and it fails with error shown below.

My suspicion is the root cause is our project consists of three receivers but as yet we have no birds tagged and registered.  I am able to load each receiver via tagme().   So Im not sure if this is expected behavior or a bug.  Where is the proper place to report?

> proj.num <- 337  ## "USFW MB R9 Shorebird Project"
> sql.motus <- tagme(projRecv = proj.num, new = TRUE,  update = TRUE, dir = "databases/") 

Please enter a value for login name at motus.org
==>
(myusername)
Please enter a value for password at motus.org
==>
(mypassword)
Checking for new data in project 337
Updating metadata
activity:     0 new batch records to check
nodeData:     0 new batch records to check
Fetching deprecated batches
Error in `dplyr::anti_join()`:
! Join columns must be present in data.
x Problem with `batchID`.
Run `rlang::last_error()` to see where the error occurred.


> rlang::last_error()
<error/rlang_error>
Error in `dplyr::anti_join()`:
! Join columns must be present in data.
x Problem with `batchID`.
---
Backtrace:
 1. motus::tagme(...)
 6. dplyr:::anti_join.data.frame(b, ., by = "batchID")
Run `rlang::last_trace()` to see the full context.

> rlang::last_trace()
<error/rlang_error>
Error in `dplyr::anti_join()`:
! Join columns must be present in data.
x Problem with `batchID`.
---
Backtrace:
     ▆
  1. ├─motus::tagme(...)
  2. │ └─motus:::fetchDeprecated(src = rv)
  3. │   └─... %>% dplyr::mutate(removed = 0)
  4. ├─dplyr::mutate(., removed = 0)
  5. ├─dplyr::anti_join(b, ., by = "batchID")
  6. └─dplyr:::anti_join.data.frame(b, ., by = "batchID")
  7.   └─dplyr:::join_filter(x, y, by = by, type = "anti", na_matches = na_matches)
  8.     └─dplyr:::join_cols(tbl_vars(x), tbl_vars(y), by = by, error_call = error_call)
  9.       └─dplyr:::standardise_join_by(...)
 10.         └─dplyr:::check_join_vars(by$x, x_names, error_call = error_call)
 11.           └─rlang::abort(bullets, call = error_call)

failedRun.txt

Josh Sayers

unread,
Apr 20, 2022, 11:42:15 AM4/20/22
to Motus Wildlife Tracking System

Hi Rich,


That does appear to be a bug with the latest motus package version. It should be resolved within the next few days.


 However, this shouldn’t affect you that much at the moment anyway.


Calling tagme() on a project number will only download the data for that project’s tags, and in this case there isn't anything to download. If you want to download the detection data for your receivers, then doing that individually as you have been (or looping through a list) is the way to access that.


cheers

Josh

Rubega, Margaret

unread,
Apr 20, 2022, 11:59:27 AM4/20/22
to motu...@googlegroups.com
Hello Motus Folks,

A group of us working on putting up Motus towers near Mono Lake, California are finding that some of our best options for siting are on private land. Even when owners are willing it seems like this might involve some legal complexity/need for advance agreement. Does anyone have MOU(s) with private landowners that you'd be willing to share as examples? It would be great not to have to reinvent any wheels.

Margaret Rubega
(she/her/hers)
Professor
CT State Ornithologist
Curator, Ornithology Collections
Dept Ecology and Evolutionary Biology
University of Connecticut
margare...@uconn.edu
@profrubega
860-486-4502

From: motu...@googlegroups.com <motu...@googlegroups.com> on behalf of Rich Schramm <schr...@gmail.com>
Sent: Tuesday, April 19, 2022 3:24 PM
To: Motus Wildlife Tracking System <motu...@googlegroups.com>
Subject: [motus-wts] Executing tagme() for project fails with 'Join columns must be present in data'
 

*Message sent from a system outside of UConn.*

--
The Motus Wildlife Tracking System (Motus) is an international collaborative research network that uses coordinated automated radio telemetry to facilitate research and education on the ecology and conservation of migratory animals. Motus is a program of Birds Canada in partnership with collaborating researchers and organizations. Learn more at https://motus.org
---
You received this message because you are subscribed to the Google Groups "Motus Wildlife Tracking System" group.
To unsubscribe from this group and stop receiving emails from it, send an email to motus-wts+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/motus-wts/9c57505b-1b43-45cd-80d5-8ae646073b7fn%40googlegroups.com.

Stuart Mackenzie

unread,
Apr 20, 2022, 2:51:59 PM4/20/22
to motu...@googlegroups.com

Dear Margaret,


Great question that we should all approach very carefully. The specific agreements or arrangements are very site specific – some landowners have existing processes to accommodate this, many private landowners do not so custom agreements tend to be the approach. I have attached two examples:  One that is our most complex legal document, and another more simple. What is often the most important is to offer liability insurance in some form to cover any potential damage or injury caused by the station. This is described in the enclosed.  

Willistown Conservation Trust and other collaborators may be able to share copies of their own agreements.

 

Cheers,


Stu

 

 

Stuart A. Mackenzie

Director of Strategic Assets

Birds Canada | Oiseaux Canada

PO Box 160, 115 Front Rd. Port Rowan, Ontario. N0E 1M0.

Office: (519)-586-3531 X 162 | Mobile:820-6040

smack...@birdscanada.org| birdscanada.org |motus.org|birdscanada.org/lpbo

 

Motus_ Licence of Occupation.docx
Motus_LandownerAgreement_Generic.docx

Degroote, Lucas

unread,
Apr 20, 2022, 3:08:51 PM4/20/22
to motu...@googlegroups.com

Here’s Carnegie’s.




The information contained in this message and/or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. Any views expressed in this message are those of the individual sender.
2018 PARC Site License for Motus Bird Tracking Program.docx

Matt Webb

unread,
Apr 26, 2022, 7:19:12 PM4/26/22
to Motus Wildlife Tracking System
Margaret,

Attached is our general MOU that we use for our stations.  Many station hosts have added their own language or needs to this, but this is the template we work from.

Matt


Matthew M Webb

Avian Ecologist and Motus Wildlife Tracking System Coordinator

Bird Conservancy of the Rockies

Motus project #281

970.482.1707 x36 (office)

970.405.7155 (mobile - use this number!)


Connect with us on Facebook and Twitter


MOU_BCR_GeneralMotus.docx

Rubega, Margaret

unread,
Apr 27, 2022, 8:55:16 AM4/27/22
to motu...@googlegroups.com
Thanks Matt.

Margaret Rubega
(she/her/hers)
Professor
CT State Ornithologist
Curator, Ornithology Collections
Dept Ecology and Evolutionary Biology
University of Connecticut
margare...@uconn.edu
@profrubega
860-486-4502

From: motu...@googlegroups.com <motu...@googlegroups.com> on behalf of Matt Webb <matt...@birdconservancy.org>
Sent: Tuesday, April 26, 2022 6:32 PM

To: Motus Wildlife Tracking System <motu...@googlegroups.com>
Subject: Re: [motus-wts] RE: MOUs for towers on private land?
 

Adam Smith

unread,
May 6, 2022, 11:35:07 AM5/6/22
to Motus Wildlife Tracking System
Josh,

I'm getting this same error with the most recent beta package... receiver specific download for CTT-8E20667AE036, which does have detections reported online...

Reported column at issue is `batchID`

Any updates?

Thanks,
Adam

Denis Lepage

unread,
May 6, 2022, 11:56:46 AM5/6/22
to motu...@googlegroups.com

The issue is related to deprecated batches. A fix should be available shortly.

For now you should be able to use tagme(..., skipDeprecated = TRUE) to skip the deprecated check and avoid the problem until the fix is available.

We will report again when the update has been made.


Denis Lepage
http://avibase.ca
http://ebird.ca





-------- Original message --------
From: Adam Smith <avianmi...@gmail.com>
Date: 5/6/22 11:35 (GMT-05:00)
To: Motus Wildlife Tracking System <motu...@googlegroups.com>
Subject: [motus-wts] Re: Executing tagme() for project fails with 'Join columns must be present in data'

Josh,

I'm getting this same error with the most recent beta package... receiver specific download for CTT-8E20667AE036, which does have detections reported online...

Reported column at issue is `batchID`

Any updates?

Thanks,
Adam

On Wednesday, April 20, 2022 at 11:42:15 AM UTC-4 Josh Sayers wrote:

Hi Rich,


That does appear to be a bug with the latest motus package version. It should be resolved within the next few days.


However, this shouldn’t affect you that much at the moment anyway.


Calling tagme() on a project number will only download the data for that project’s tags, and in this case there isn't anything to download. If you want to download the detection data for your receivers, then doing that individually as you have been (or looping through a list) is the way to access that.


cheers

Josh

On Wednesday, April 20, 2022 at 11:39:22 AM UTC-4 schr...@gmail.com wrote:
Im a new motus user. Project is USFWS MB R9 Shorebird Project (#337)
Im trying to load our project via tagme() and it fails with error shown below.

My suspicion is the root cause is our project consists of three receivers but as yet we have no birds tagged and registered. I am able to load each receiver via tagme(). So Im not sure if this is expected behavior or a bug. Where is the proper place to report?

> proj.num <- 337 ## "USFW MB R9 Shorebird Project"
> sql.motus <- tagme(projRecv = proj.num, new = TRUE, update = TRUE, dir = "databases/")

Please enter a value for login name at motus.org<http://motus.org>
==>
(myusername)
Please enter a value for password at motus.org<http://motus.org>
--
The Motus Wildlife Tracking System (Motus) is an international collaborative research network that uses coordinated automated radio telemetry to facilitate research and education on the ecology and conservation of migratory animals. Motus is a program of Birds Canada in partnership with collaborating researchers and organizations. Learn more at https://motus.org
---
You received this message because you are subscribed to the Google Groups "Motus Wildlife Tracking System" group.
To unsubscribe from this group and stop receiving emails from it, send an email to motus-wts+...@googlegroups.com<mailto:motus-wts+...@googlegroups.com>.
To view this discussion on the web visit https://groups.google.com/d/msgid/motus-wts/b68971c4-1f09-4b71-8883-82e6da9a2c9bn%40googlegroups.com<https://groups.google.com/d/msgid/motus-wts/b68971c4-1f09-4b71-8883-82e6da9a2c9bn%40googlegroups.com?utm_medium=email&utm_source=footer>.
Reply all
Reply to author
Forward
0 new messages