search

NHMDenmark / Mass-Digitizer

Common repo for the DaSSCo team
Apache License 2.0
1 stars 0 forks source link

Truncated full name author names in taxonname table #477

Closed jlegind closed 7 months ago

jlegind commented 8 months ago

Describe the bug By chance I found two cases of truncated author names: Dermatohomoeus pilosus (Hlisnikovsky palustris (Kiesenwetter

To Reproduce Steps to reproduce the behavior:

  1. SQL: SELECT * FROM taxonname where author LIKE '%(Kiesenwetter';

Expected behavior Assuming the author name, if begun with a paranthesis, must end with one as well: Then the author name should be =
(Kiesenwetter, 1844) or similar pattern.

Please complete the following information:

I will submit a SQL query that identifies all author names having the truncated issue at a later date.

FedorSteeman commented 7 months ago

@jlegind Will you add more information? I've already discovered the highlighted taxon in the taxon spine:

SYNONYM,SPECIES,"Philhygra palustris (Kiesenwetter, 1844)",Arthropoda,Insecta,Coleoptera,Staphylinidae,Atheta,,Atheta palustris,"(Kiesenwetter, 1844)",,,Species,220,Philhygra palustris,(Kiesenwetter,Philhygra,,137565,

It's line 41899 in this file:

https://github.com/NHMDenmark/Mass-Digitizer/blob/main/data/taxon%20spines/Entomology/NHMD%20Entomology%20selected%20names.csv

The source of the truncation is Specify.

image

So ideally the responsibility of collection staff.

FedorSteeman commented 7 months ago

@bhsi-snm told me to close the issue, since it has nothing to do with the digi app.