Project

General

Profile

task #7891

Updated by Andreas Kohlbecker over 5 years ago

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  

 ~~~sql 
 SELECT COUNT(*), genusOrUninomial, infraGenericEpithet, specificEpithet, infraSpecificEpithet  
 FROM TaxonName 
 GROUP BY genusOrUninomial, infraGenericEpithet, specificEpithet, infraSpecificEpithet 
 HAVING COUNT(*)>1; 
 ~~~

Back