Empty value for `receiver_id` in `acoustic.receivers`

inbo / etn

R package to access data from the European Tracking Network

https://inbo.github.io/etn/

MIT License

6 stars 5 forks source link

Empty value for `receiver_id` in `acoustic.receivers` #333

Open PietrH opened 1 month ago

PietrH commented 1 month ago

The function list_receiver_ids() uses a very simple SQL query:

SELECT DISTINCT receiver FROM acoustic.receivers

One of the expectations we have for the result is that there will be no empty NA values. However, this test is currently failing.

Why would there ever be empty receiver_id's in this table?

PietrH commented 1 month ago

@PieterjanVerhelst Do you know why this could happen?

PieterjanVerhelst commented 4 weeks ago

That is indeed strange. Could you provide the network project codes for which the receiver id is empty? I can try to reproduce the example in RStudio.

CLAUMEMO commented 2 weeks ago

It is an error on our side. They are receivers from the OTN exchange. Since April (release 3.1.0) there is a receivers model table, and that was not updated in the OTN-ETN exchange scripts. @paulfvliz is working on that now :)

PietrH commented 2 weeks ago

Thanks for the update, please let me know when this is fixed so I can turn our test back on :)