task #9658: Cleanup authors with protected names and authors - EDIT - EDIT Project Management

Actions

Copy link

task #9658

open

Cleanup authors with protected names and authors

Added by Andreas Müller over 3 years ago. Updated over 1 year ago.

Status:

New

Priority:

New

Assignee:

Andreas Müller

Category:

data

Target version:

Release 5.51

Start date:

Due date:

% Done:

Estimated time:

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

Actions

Copy link

Updated by Andreas Müller over 3 years ago

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

Actions

Copy link

Updated by Andreas Müller over 3 years 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
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
Vibrant: 24165

Actions

Copy link

Updated by Andreas Müller over 3 years ago

Protected Teams(nomenclaturalTitle):

AlgaTerra: >14000
Cichorieae: 8487
Cuba: 14
Campanula: 1171
Caryo_amaranth: 113
Nepenthes: 65
Caryo_genera: 128
Caryo_spp: 126
Palmae: 12592
Casearia: 1
Col: >1900000
Corvidae: 487
Cyprus: 1
Diptera: 365
E+M: 16
E+M cauc: 2
Phycobank: 270
Salvador: 19
Mexiko: 101