Project

General

Profile

Actions

task #7891

open

deduplicate names

Added by Andreas Kohlbecker over 5 years ago. Updated about 1 year ago.

Status:
New
Priority:
New
Category:
Datacleaning
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Tags:

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

duplicate-names.ods (15.7 KB) duplicate-names.ods Andreas Kohlbecker, 11/07/2018 04:05 PM
Actions #2

Updated by Andreas Kohlbecker over 5 years ago

  • Category set to Datacleaning
Actions #3

Updated by Andreas Kohlbecker over 5 years ago

  • Description updated (diff)
Actions #4

Updated by Andreas Kohlbecker over 5 years ago

  • Description updated (diff)
Actions #5

Updated by Andreas Müller about 1 year ago

  • Tags set to phycobank
Actions

Also available in: Atom PDF