GPS

Stats per year:

year	total rows	cumulative	outliers	rows sans outliers
2013	113816	113816	2	113814*
2014	404405	518221	45	404360*
2015	850640	1368861	122	850518*
2016	4303218	5672079	197	4303021
2017	2731329	8403408	91	2731238
2018	2432294	10835702	172	2432122
2019	1702317	12538019	193	1702124
totals	12538019	12538019	822	12537197

rows sans outliers* is correctly reported as number of locations for each file, but the summary statistics are incorrect:

locations: 15431782 should be 12537197. Up until upload for 2018, the number was consistently 3062309 records too much, which was the number of records that remained when all GPS files were removed. With the 2019 upload the number dropped slightly.
outliers: 786 should be 822. Up until upload for 2018, this was correct. None of the outliers for 2019 seem to be included

peterdesmet commented 4 years ago

GPS stats are now ok: 12537197 (822)

peterdesmet commented 4 years ago

Acceleration stats are 165045907, but should be 165913191.

peterdesmet commented 4 years ago

Acc data was not associated to 3 indiv:

indiv	tag	gps	acc
H908153	6327	assoc	assoc
H908154	6323	assoc	not assoc
H908155	6325	assoc	not assoc
H908156	6322	assoc	assoc
H908157	6321	assoc	not assoc

This has now been fixed by Martin.

inbo / bird-tracking