Actions
task #7891
opendeduplicate names
Start date:
Due date:
% Done:
0%
Estimated time:
Description
The phycobank db contains 117 cases of potentially duplicate names which need to be checked. See attached spreadsheet
17 of these cases are names which are empty.
Duplicate names can be found by
SELECT COUNT(*), genusOrUninomial, infraGenericEpithet, specificEpithet, infraSpecificEpithet
FROM TaxonName
GROUP BY genusOrUninomial, infraGenericEpithet, specificEpithet, infraSpecificEpithet
HAVING COUNT(*)>1;
Files
Actions