Project

General

Profile

task #6481

Sort out synonym relationships with 2 invalid taxa (Edaphobase)

Added by Andreas Müller about 2 years ago. Updated 30 days ago.

Status:
In Progress
Priority:
Highest
Category:
data
Start date:
03/02/2017
Due date:
% Done:

70%

Severity:
critical
Tags:

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 2 years ago

  • Description updated (diff)

#2 Updated by Andreas Müller about 2 years ago

  • Description updated (diff)

#3 Updated by Andreas Müller about 2 years ago

  • Description updated (diff)

#4 Updated by Andreas Müller about 2 years ago

  • Description updated (diff)

#5 Updated by Andreas Müller about 2 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 2 years ago

  • Target version changed from Release 4.7 to Release 4.8

#7 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 4.8 to Release 4.9

#8 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 4.9 to Release 4.10

#9 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 4.10 to Release 4.11

#10 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 4.11 to Release 4.12

#11 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 4.12 to Release 4.13

#12 Updated by Andreas Müller about 1 year ago

  • Target version changed from Release 4.13 to Release 4.14

#13 Updated by Andreas Müller about 1 year ago

  • Target version changed from Release 4.14 to Release 5.0

#14 Updated by Andreas Müller about 1 year ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 70

#15 Updated by Andreas Müller 10 months ago

  • Target version changed from Release 5.0 to Release 5.1

#16 Updated by Andreas Müller 9 months ago

  • Target version changed from Release 5.1 to Release 5.2

#17 Updated by Andreas Müller 7 months ago

  • Target version changed from Release 5.2 to Release 5.3

#18 Updated by Andreas Müller 7 months 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 1 month ago

  • Target version changed from Release 5.5 to Release 5.6

#20 Updated by Andreas Müller 30 days ago

  • Target version changed from Release 5.6 to Reviewed Next Major Release

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)