Squirrel table: squirrel ID = 25098 Bk!/R! M7054/M7055
Not in squirrel_alias table nor in historic_squirrel_ids
In midden_cones table in krsp_suppl, there are two records for the same midden a year apart from each other with two different squirrel IDs but the tags M7054/M7055. Neither of the squirrel IDs in midden_cones for M7054/5 at KL F18. appear in the census table, nor the juvenile table (checked in case these were juvs that showed up later).
Squirrel ID = 25098 who was Bk!/R! in 2020 with tags M7054/M7075 appears in census at KL F18. and the same squirrel ID (= 25098) appears in 2021 censuses at KL F18. as B!/B!. From the trapping table, it appears that it's likely the tags were misread in 2020; they appear correct at the end of 2020 (trapping record 169669).
Solution:
Since the problem lies within a supplementary table, having squirrel_ids 25175 and 25185 put into historic_squirrel_ids for Squirrel ID = 25098 should allow this to be fixed easily in R or the squirrel IDs for midden_cones should be directly changed to 25098.
Squirrel table: squirrel ID = 25098 Bk!/R! M7054/M7055
Not in squirrel_alias table nor in historic_squirrel_ids
In midden_cones table in krsp_suppl, there are two records for the same midden a year apart from each other with two different squirrel IDs but the tags M7054/M7055. Neither of the squirrel IDs in midden_cones for M7054/5 at KL F18. appear in the census table, nor the juvenile table (checked in case these were juvs that showed up later).
midden_cones records: 2416 (year = 2020): KL F18. squirrel_id = 25175 2697 (year = 2021): KL F18. squirrel_id = 25185
Squirrel ID = 25098 who was Bk!/R! in 2020 with tags M7054/M7075 appears in census at KL F18. and the same squirrel ID (= 25098) appears in 2021 censuses at KL F18. as B!/B!. From the trapping table, it appears that it's likely the tags were misread in 2020; they appear correct at the end of 2020 (trapping record 169669).
Solution: Since the problem lies within a supplementary table, having squirrel_ids 25175 and 25185 put into historic_squirrel_ids for Squirrel ID = 25098 should allow this to be fixed easily in R or the squirrel IDs for midden_cones should be directly changed to 25098.