-
Notifications
You must be signed in to change notification settings - Fork 1
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Duplicate detections in 2010_phd_reubens_sync #78
Comments
These are not that easy to handle, as this was a mistake of Vemco. Thus although the tag Ids are the same, these tags were put in the water as different tags. Thus I can't remove any tag/animal from the DB. |
Changed in DB:
|
@jreubens, we now have 2,226 duplicated rows (1,113 duplicates) all around the recovery/release date, for almost all tags. This is odd, because in the animals table, none of the recovery/release dates overlap anymore, while in the detections it seem they do, for 2011-03-11 and 2011-03-12:
|
I discussed this with Aubri and he told it is very hard to find this out. I guess this has lower priority and suggest we take the first detection of the two... |
2010_phd_reubens_sync
contains 77.426 detections with duplicatepk
(38713 to be removed). This seems to be caused by 2 tags:A69-1303-65302
: is listed 3 times in tags: 96 (AVAILABLE), 67 (ENDED), 85 (AVAILABLE). I don't think the tag should be listed as AVAILABLE twice, but that does not seem to be causing the issue, becauseA69-1303-65301
is also listed twice as available. The issue seems to be with85
: all duplicates are coming from this tag.734
and2159
are complete duplicates. I would suggest to remove 2159The text was updated successfully, but these errors were encountered: