Project

General

Profile

task #9658

Cleanup authors with protected names and authors

Added by Andreas Müller 6 months ago. Updated 6 months ago.

Status:
New
Priority:
New
Category:
data
Target version:
Start date:
06/08/2021
Due date:
% Done:

0%

Severity:
normal

Description

copied from #9364

In some databases there are many names with protected caches which may lead to problems when searching for names.

SELECT tn.id, tn.titleCache, tn.nameCache, tn.protectedTitleCache, tn.protectedNameCache, tn.protectedFullTitleCache, tn.protectedAuthorshipCache , tn.*
FROM TaxonName tn
WHERE tn.protectednamecache = 1 OR tn.protectedtitlecache = 1 OR tn.protectedFullTitleCache = 1 OR tn.protectedAuthorshipCache ;

Especially interesting might be those having an "&" in the protected nameCache which indicates that there is authorship in the nameCache which should not happen.

Also many Teams have a protected nomenclatural title which is in most cases not necessary.

SELECT ab.id, ab.DTYPE, ab.titleCache, ab.nomenclaturaltitle, ab.protectedtitlecache, ab.protectednomenclaturaltitlecache, ab.*
FROM AgentBase ab
WHERE
-- ab.protectedtitlecache = 1 OR
 ab.protectednomenclaturaltitlecache = 1
ORDER BY ab.nomenclaturaltitle

However, in most cases this is not critical.


Related issues

Related to Edit - task #9650: Update all titleCaches after upgrade of cache strategies and formatters In Progress 06/03/2021
Copied from Edit - task #9364: Cleanup authors with multiple & and protected names and teams Closed 12/22/2020

History

#1 Updated by Andreas Müller 6 months ago

  • Copied from task #9364: Cleanup authors with multiple & and protected names and teams added

#2 Updated by Andreas Müller 6 months ago

Protected Names (still without fulltitlecache and authorshipcache):

Bromeliaceae: 584
Cichorieae: 476
Cuba: 567
Campanula: 28
Caryo_amaranth: 18
Nepenthes: 8
caryo_genrea: 1
caryo_spp: 268
Greece: 3
Palmae: 66
casearia: 7
COL: >500000
Corvidae: 87
Cyprus: 97 (mostly hybrids)
Diptera: 3
E+M: 801 (mostly hybrids)
E+M cauc: 4
Fl dAfrique Central: 5190
myristicacea: 1
Phycobank: 245 => WHK
Salvador: 3 (ok, highest taxa, but ask Walter)

Guianas: 1487 !!
Flora Malesiana: 535
FM-clean: 2
FM propective: 84
Gabon: 90

RL: All, but many in Animalia, GermanSL, Moose, Standardliste + Plantae(?)

Globis: 7483
Edapho: 4
PiB: All, but most in Ants
Vibrant: 24165

#3 Updated by Andreas Müller 6 months ago

Protected Teams(nomenclaturalTitle):

AlgaTerra: >14000
Cichorieae: 8487
Cuba: 14
Campanula: 1171
Caryo_amaranth: 113
Nepenthes: 65
caryo_genrea: 128
caryo_spp: 126
Palmae: 12592
casearia: 1
COL: >1900000
Corvidae: 487
Cyprus: 1
Diptera: 365
E+M: 16
E+M cauc: 2
Fl dAfrique Central: 25925
Phycobank: 270
Salvador: 19
Mexiko: 101

Guianas: 14465
Flora Malesiana: >121000
FM-clean: 16
FM propective: 55
Gabon: 12940

RL: All, but many in Armeria, Moose, Standardliste + Plantae(?)

Globis: 7483
PiB: few, mostly in chenopodium and spiders
Vibrant: 41202

#4 Updated by Andreas Müller 6 months ago

  • Related to task #9650: Update all titleCaches after upgrade of cache strategies and formatters added

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)