task #6481
Sort out synonym relationships with 2 invalid taxa (Edaphobase)
70%
Description
Synonymbeziehungen (congruent) mit 2 invaliden Taxa:
LÖSUNG: Diese Taxa scheinen alle in 2 Beziehungen zu sein, 1 davon zum jetzt akzeptierten Taxon
Für einige Fälle gilt das aber nicht. Siehe Query in Kommentar unten
42 haben gleichen parent, davon alles Species mit Parent Gattung.
SELECT sr.synonym_role, s.parent_taxon_fk synParent, t.parent_taxon_fk accParent, s.display_string syn, t.display_string acc, p.display_string par, s.tax_rank_fk synRank, t.tax_rank_fk accRank, p.tax_rank_fk parRank, s.name synName, t.name accName, p.name parName, s.taxon_id synId, t.taxon_id accId, p.valid, sr2.synonym_role, t2.valid, t2.display_string FROM tax_taxon s INNER JOIN tax_synonym sr ON s.taxon_id = sr.a_taxon_fk_taxon_id INNER JOIN tax_taxon t ON t.taxon_id = sr.b_taxon_fk_taxon_id INNER JOIN tax_taxon p ON s.parent_taxon_fk = p.taxon_id LEFT OUTER JOIN tax_synonym sr2 ON t.taxon_id = sr2.a_taxon_fk_taxon_id INNER JOIN tax_taxon t2 ON t2.taxon_id = sr2.b_taxon_fk_taxon_id WHERE s.valid = false AND t.valid = false AND sr.synonym_role = 11614 AND s.parent_taxon_fk = t.parent_taxon_fk AND t.name = t2.name ORDER BY t2.tax_rank_fk
davon 3 Duplikate:
- "Acanthopetalum cycladicum (Verhoeff, 1901)"->"Acanthopetalum Verhoeff, 1900"; Doppelte Synonymbeziehung => Beziehung löschen
- OK: "Hypoaspis elongata nomen nudum [Götz, 1952]";"Hypoaspis angustiscutata Willmann, 1951" => nomen nudum
- OK: "Hypoaspis macroanalis nomen nudum [Bernhard, 1955]";"Hypoaspis claviger (Berlese, 1883)" => nomen nudum
davon 2 Parents sind invalid: "Paragarmania"(89826), "Thyropisthus"(51958)
davon eine ganze Reihe, bei denen der acc Name mehrfach vorkommt (kein Widerspruch)
davon alle 42 a Taxa in weiterer synonymBeziehung zu jeweils validem Taxon
davon 22 mit gleichem Namen als Umkombination von a->a2 zu anderer Gattung (16), Subspecies (2) Varietät (3) oder in Gruppe mit sensu Gisin (1)
- => (Voll) Importlösung: Synonymbeziehung1 auflösen und stattdessen direkte Beziehung zu Validem Taxon erzeugen; a und a2 als homotypische synonyme
davon 20 mit unterschiedlichem Namen
- davon 8 orthographische Varianten zwischen acc1 und acc2 (Nopoiulus kochi/kochii; Acanthopetalum cycladicum/cycladium; bradae/bradeae)
- davon 4 Umkombinationen mit subterranea/subterraneus; brigdamensis/brigdammense
- davon 1 orthographisch Variante zwischen syn und acc1: Haploporatia simile/similis
- davon 1 gleicher Name syn/acc aber unterschiedliche Autoren: "Onychiurus fimetarius (Linnaeus, 1766) Stach, 1934"->"Onychiurus fimetarius (Stach, 1934)"
=> Lösungen siehe Excelfile InvalidInvalidSynRelation
190 haben nicht gleichen parent
- 1 mit valid ist auch invalid (3er Synonymkette) => ebenfalls umhängen zu 4 Taxon in Reihe
- 100 mit syn2.name = acc.name
- Vermutlich alles Umkombinationen, evtl. einige orth.Var. dabei
SELECT sr.synonym_role, s.parent_taxon_fk synParent, t.parent_taxon_fk accParent, s.tax_rank_fk synRank, t.tax_rank_fk accRank, p.tax_rank_fk parRank, s.name synName, t.name syn2Name, p.name parName, s.taxon_id synId, t.taxon_id syn2Id, t2.taxon_id validId, p.valid parValid, p2.valid par2Valid,p3.valid par3Valid, sr2.synonym_role, t2.valid t2Valid, p.display_string par,p2.display_string par2, s.display_string syn, t.display_string syn2, t2.display_string acc FROM tax_taxon s INNER JOIN tax_synonym sr ON s.taxon_id = sr.a_taxon_fk_taxon_id INNER JOIN tax_taxon t ON t.taxon_id = sr.b_taxon_fk_taxon_id LEFT JOIN tax_taxon p ON s.parent_taxon_fk = p.taxon_id LEFT JOIN tax_taxon p2 ON t.parent_taxon_fk = p2.taxon_id LEFT OUTER JOIN tax_synonym sr2 ON t.taxon_id = sr2.a_taxon_fk_taxon_id LEFT JOIN tax_taxon t2 ON t2.taxon_id = sr2.b_taxon_fk_taxon_id LEFT JOIN tax_taxon p3 ON t2.parent_taxon_fk = p3.taxon_id WHERE s.valid = false AND t.valid = false AND sr.synonym_role = 11614 AND s.parent_taxon_fk <> t.parent_taxon_fk AND t2.valid = true AND t.name = t2.name ORDER BY p.valid, t2.tax_rank_fk
History
#1 Updated by Andreas Müller about 4 years ago
- Description updated (diff)
#2 Updated by Andreas Müller about 4 years ago
- Description updated (diff)
#3 Updated by Andreas Müller about 4 years ago
- Description updated (diff)
#4 Updated by Andreas Müller about 4 years ago
- Description updated (diff)
#5 Updated by Andreas Müller about 4 years ago
- Description updated (diff)
Fälle für die die Lösung nicht gilt:
SELECT sr.synonym_role, s.parent_taxon_fk synParent, t.parent_taxon_fk accParent,
s.tax_rank_fk synRank, t.tax_rank_fk accRank, p.tax_rank_fk parRank, s.name synName, t.name syn2Name, p.name parName, s.taxon_id synId, t.taxon_id syn2Id, t2.taxon_id validId,
p.valid parValid, p2.valid par2Valid,p3.valid par3Valid,
sr2.synonym_role, t2.valid t2Valid, p.display_string par,p2.display_string par2, s.display_string syn, t.display_string syn2, t2.display_string acc
FROM tax_taxon s
INNER JOIN tax_synonym sr ON s.taxon_id = sr.a_taxon_fk_taxon_id
INNER JOIN tax_taxon t ON t.taxon_id = sr.b_taxon_fk_taxon_id
LEFT JOIN tax_taxon p ON s.parent_taxon_fk = p.taxon_id
LEFT JOIN tax_taxon p2 ON t.parent_taxon_fk = p2.taxon_id
LEFT OUTER JOIN tax_synonym sr2 ON t.taxon_id = sr2.a_taxon_fk_taxon_id
LEFT JOIN tax_taxon t2 ON t2.taxon_id = sr2.b_taxon_fk_taxon_id
LEFT JOIN tax_taxon p3 ON t2.parent_taxon_fk = p3.taxon_id
WHERE s.valid = false AND t.valid = false AND sr.synonym_role = 11614
AND s.taxon_id NOT IN (
SELECT srsr.a_taxon_fk_taxon_id
FROM tax_synonym srsr INNER JOIN tax_taxon tt ON tt.taxon_id = srsr.b_taxon_fk_taxon_id
WHERE tt.valid = true
)
#6 Updated by Andreas Müller almost 4 years ago
- Target version changed from Release 4.7 to Release 4.8
#7 Updated by Andreas Müller almost 4 years ago
- Target version changed from Release 4.8 to Release 4.9
#8 Updated by Andreas Müller almost 4 years ago
- Target version changed from Release 4.9 to Release 4.10
#9 Updated by Andreas Müller over 3 years ago
- Target version changed from Release 4.10 to Release 4.11
#10 Updated by Andreas Müller over 3 years ago
- Target version changed from Release 4.11 to Release 4.12
#11 Updated by Andreas Müller over 3 years ago
- Target version changed from Release 4.12 to Release 4.13
#12 Updated by Andreas Müller about 3 years ago
- Target version changed from Release 4.13 to Release 4.14
#13 Updated by Andreas Müller about 3 years ago
- Target version changed from Release 4.14 to Release 5.0
#14 Updated by Andreas Müller about 3 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 70
#15 Updated by Andreas Müller almost 3 years ago
- Target version changed from Release 5.0 to Release 5.1
#16 Updated by Andreas Müller almost 3 years ago
- Target version changed from Release 5.1 to Release 5.2
#17 Updated by Andreas Müller over 2 years ago
- Target version changed from Release 5.2 to Release 5.3
#18 Updated by Andreas Müller over 2 years ago
- Subject changed from Sort out synonym relationships with 2 invalid taxa to Sort out synonym relationships with 2 invalid taxa (Edaphobase)
- Target version changed from Release 5.3 to Release 5.5
#19 Updated by Andreas Müller about 2 years ago
- Target version changed from Release 5.5 to Release 5.6
#20 Updated by Andreas Müller about 2 years ago
- Target version changed from Release 5.6 to Reviewed Next Major Release