Tags detected on website but not in R

Analysis and Data
1

Question: Why would detections not get pulled in through R but show up on the website?

Example: I’ve got this code to pull in ovenbird data and it only filters out detections with runLen <=2.

Filter the data

tbl.cswg ← tbl(sql.motus, “alltags”) %>% filter(speciesID %in% c(16930)) %>% collect()%>% as.data.frame()%>% mutate(ts = as_datetime(ts, tz = “UTC”, origin = “1970-01-01”))

filter runlength < 3

df.cswg ← filter(tbl.cswg, runLen > 2) saveRDS(df.cswg, “./data/df_OVEN.RDS”) #change species to four letter AOU colldata<-readRDS(“./data/df_OVEN.RDS”)

tags detected

tagIDs<-colldata %>% ### collects all the tags detected count(motusTagID) In my list of motusTagIDs I don’t see this tag 34097. But on the website I can find it: https://motus.org/data/tagDeploymentDetections?id=24713

Why is that? The detections at the release site (Honey Hut) and nearby (Cleveland Lakefront) seem like they could be legit. I’ve 9 GRCA with the same problem.

2

Can you edit your post to put the code blocks between lines with ```, e.g.:

    ```
    place code here
    ```

The way I would troubleshoot this is to query the sqlite database you have directly. Something like:

sqlite3 SG-FDA2RPZ20386.motus "select * from runs where motusTagID = 34097"

That will tell you whether the data exists in your DB…