Re: Bats' recommended_taxon_list_item_keys
If I run the following:
select distinct preferred_name, recommended_taxon_list_item_key
from index_taxon_name
where preferred_name = 'Pipistrellus pipistrellus'
I get the following results back:
preferred_name recommended_taxon_list_item_key
Pipistrellus pipistrellus EHSSYS0000000581
Pipistrellus pipistrellus NBNSYS0000094681
Pipistrellus pipistrellus NBNSYS0000142091
Pipistrellus pipistrellus NBNSYS0000143852
Pipistrellus pipistrellus NBNSYS0000146665
Pipistrellus pipistrellus NBNSYS0000146691
Pipistrellus pipistrellus NBNSYS0000154169
Pipistrellus pipistrellus NBNSYS0000154576
Pipistrellus pipistrellus NBNSYS0000172745
Pipistrellus pipistrellus NBNSYS0000172993
Pipistrellus pipistrellus NBNSYS0000172997
Pipistrellus pipistrellus NBNSYS0000175671
Pipistrellus pipistrellus NBNSYS0000175923
Pipistrellus pipistrellus NBNSYS0200003611
Pipistrellus pipistrellus NHMSYS0000332505
Pipistrellus pipistrellus NHMSYS0000332675
Pipistrellus pipistrellus NHMSYS0000332720
Pipistrellus pipistrellus NHMSYS0000377356
Pipistrellus pipistrellus NHMSYS0000527962
Pipistrellus pipistrellus NHMSYS0001684425
Pipistrellus pipistrellus NHMSYS0001771253
It looks like this taxon and some others (I've noticed various bats so far) aren't getting their recommended_taxon_list_item_keys mapped properly (there should only ever be one recommended key per taxon, surely?).
Update: Plecotus auritus is the other taxon I have found that seems to have several RTLIKs
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital