it seems strange to me that folks would want to see numbers just to see numbers. my first post in this thread was to say that robotpie seemed to have a point that number of taxa might be a better reflection of the spirit of iNat than simply number of observations. so maybe that’s the kind of metric that we should pay more attention to?
anyway, below are the folks with the most distinct taxa in a day, based on that old copy of the AWS Open Data Set (from 2021-04-15). note that this is a simple distinct taxon count, not a count of “leaf taxa” that some of the iNat pages show. @yayemaster might be interested to see who shows up on this list.
seems like you’re one of the few to have achieved that.
| Observer ID | Observer Login | Obs Date | Taxon Count | Obs Count |
|---|---|---|---|---|
| 547666 | biobank-lantauhk | 2017-07-26 | 1656 | 2740 |
| 547666 | biobank-lantauhk | 2018-06-05 | 1433 | 3217 |
| 147168 | eric_keith | 2019-04-26 | 632 | 701 |
| 2928255 | yayemaster | 2020-09-06 | 611 | 1055 |
| 661392 | nicklambert | 2020-05-24 | 576 | 817 |
| 35766 | bonnieeamick | 2020-07-05 | 537 | 860 |
| 999066 | alexis_orion | 2020-06-14 | 522 | 1027 |
| 2928255 | yayemaster | 2020-08-16 | 516 | 993 |
| 35766 | bonnieeamick | 2020-07-26 | 515 | 789 |
| 14812 | gwark | 2018-07-13 | 508 | 558 |
here’s the SQL query:
SELECT observer_id, observed_on, COUNT(DISTINCT taxon_id) as taxon_count, COUNT(*) obs_count
FROM observations
GROUP BY observer_id, observed_on
ORDER BY COUNT(DISTINCT taxon_id) DESC
LIMIT 10