Guess 141 names have an incorrect language ‘und’ and lexicon ‘Русский’. Probably this update will violate unique constraints…
I think that the records with
language=‘und’ and lexicon=‘Русский’
should be
language=‘ru’ and lexicon=‘Russian’
Seems to be 141 records.
Update VernacularNames
Set language=‘ru’,
lexicon=‘Russian’
Where language=‘und’
and lexicon=‘Русский’
They are dated around 2019-04-01T14:50:08Z, so the tap might be closed later in 2019. You can find the records in the file with the lexicon-is-not-in-english-file: VernacularNames-.csv
Also the lexicon ‘‘other’’ is remarkable… often related to (imports of) VernacularNames
VernacularNames source
http://www.catalogueoflife.org/annual-checklist/details/species/id/10073534/common/100107 and the Vernacular name is often Lampalampa. Maybe delete these entries?
@jwidness Maybe remove your Tonga/Tongan entries in the post above?