Project

General

Profile

task #7369

ERS: Handle taxonomically valueless taxa correctly

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

Status:
In Progress
Priority:
Priority13
Category:
cdmadapter
Target version:
Start date:
04/25/2018
Due date:
% Done:

40%

Estimated time:
2.00 h
Severity:
normal
Tags:

Description

Currently 268 taxa in E+M have an IsExcludedMarker with IsExcludedExtension "not accepted: taxonomically valueless local or singular biotype" or "provisional: probably a taxonomically valueless local or singular biotype"

In the BM dataportal this is shown as the taxon status (e.g. http://ww2.bgbm.org/EuroPlusMed/PTaxonDetail.asp?NameCache=Rubus%20trachyadenes&PTRefFk=7300000 ).

These taxa do not have parent taxa.

We need to decide how to store this information.

Solutions:

1) Adding 2 marker types and the information as markers
2) Using extensions or annotations with the given full text
3) extend the doubtful flag to an enumeration to allow multiple states like "doubtful","taxonomically valueless","probably taxonomically valueless", ...

Also we need to decide if these taxa should be included in the taxon tree somehow.

Currently only those taxa having synonyms or misapplied names are attached to the tree (as root taxa) - need to check why.

taxa in BM

SELECT  n.FullNameCache,  pt.*
FROM  PTaxon AS pt INNER JOIN Name n ON n.NameId = pt.PTNameFk
WHERE (pt.IsExcludedExtension IS NOT NULL) OR (pt.IsExcludedMarker = 1)
ORDER BY pt.IsExcludedExtension

Note: These taxa may have synonyms and 1x even a misapplied name

SELECT  acc.FullNameCache, syn.FullNameCache syn,  rel.RelPTaxonId, rel.RelQualifierFk, pt.PTNameFk, pt.PTRefFk, pt.Detail, pt.RIdentifier, pt.IdInSource, pt.StatusFk, pt.DoubtfulFlag, pt.NamePhrase, pt.UseNameCacheFlag, pt.Created_When, pt.Updated_When, 
                         pt.Created_Who, pt.Updated_Who, pt.Notes, pt.PublishFlag, pt.TreeIndex, pt.IndexNameString, pt.InMCLArea, pt.FamilyCache, pt.LastScrutinyFk, pt.SpeciesExpertFk, pt.IsExcludedMarker, pt.IsExcludedExtension, 
                         pt.UUID
FROM            PTaxon AS pt INNER JOIN
                         RelPTaxon AS rel ON rel.PTNameFk2 = pt.PTNameFk AND rel.PTRefFk2 = pt.PTRefFk
                         INNER JOIN Name syn ON syn.NameID = rel.PTNameFk1
                         INNER JOIN Name acc ON acc.NameId = rel.PTNameFk2
WHERE  (pt.IsExcludedExtension IS NOT NULL) OR (pt.IsExcludedMarker = 1)
ORDER BY pt.IsExcludedExtension, acc.FullNameCache

In the publication script they are all set to publish = 1

Also have in mind that they need to be exported to PESI.

Associated revisions

Revision 961bb5d1 (diff)
Added by Andreas Müller 11 months ago

ref #7369 implement taxonomically valueless taxa with markers

Revision 5f492efb (diff)
Added by Andreas Müller 11 months ago

ref #7369 add uuids for taxonomic valueless marker to BM transformer

Revision 9d9a4a86 (diff)
Added by Andreas Müller 11 months ago

ref #7369 remove unwanted commits

History

#1 Updated by Andreas Müller 11 months ago

  • Description updated (diff)

#2 Updated by Andreas Müller 11 months ago

  • Description updated (diff)

#3 Updated by Andreas Müller 11 months ago

  • Description updated (diff)

#4 Updated by Andreas Müller 11 months ago

first implementation with markers now available

#5 Updated by Andreas Müller 11 months ago

  • Status changed from New to In Progress
  • Priority changed from New to Highest
  • % Done changed from 0 to 40

#6 Updated by Andreas Müller 11 months ago

  • Estimated time set to 2.00 h

#7 Updated by Andreas Müller 10 months ago

  • Description updated (diff)

#8 Updated by Andreas Müller 10 months ago

  • Description updated (diff)

#9 Updated by Andreas Müller 10 months ago

  • Description updated (diff)

#11 Updated by Andreas Müller 10 months ago

  • Description updated (diff)

#12 Updated by Andreas Müller 6 months ago

  • Target version changed from Euro+Med Portal Release to Euro+Med Migration

#13 Updated by Andreas Müller 6 months ago

  • Description updated (diff)

#14 Updated by Andreas Müller 6 months ago

  • Subject changed from [E+M] Handle taxonomically valueless taxa correctly to ERS: Handle taxonomically valueless taxa correctly
  • Priority changed from Highest to Priority13

#15 Updated by Andreas Müller 6 months ago

ERS (2015-08-15):

zum Thema Rubus lässt sich sagen:

die 19 Taxa, die im Baum direkt unter Plantae included sind (so sieht es jedenfalls aus), gehören zu einer Gruppe von insgesamt 232 Rubus-Taxa. Die anderen scheinen als orphaned importiert worden zu sein, warum diese 19 nicht orphaned sind, verstehe ich nicht. Ich sehe keinen Unterschied zu den anderen Rubus dieser Gruppe.

Hintergrund: diese Taxa sollen zwar über die Suche gefunden werden, aber nicht Bestandteil des Taxon Tree sein, also über das Browsen nicht zu finden sein. So ist es im Berlin-Model implementiert: Diese Arten haben keine Eltern, sondern hängen "in der Luft", sind aber akzeptiert. Wenn man also im Portal danach sucht, erhält man den Namen und die Verbreitung angezeigt, zusammen mit der Nachricht NOT ACCEPTED: TAXONOMICALLY VALUELESS LOCAL OR SINGULAR BIOTYPE

etwa Rubus abietinus Sudre http://ww2.bgbm.org/EuroPlusMed/PTaxonDetail.asp?NameCache=Rubus%20abietinus&PTRefFk=7300000

Wenn ich es richtig verstehe, werden ja orphaned taxa im CDM eigentlich nicht unterstützt, oder? Jedenfalls kann man sie mit dem EDITor zwar finden, aber nicht editieren (da erhält man eine Fehlermeldung). Insofern ist die jetzt für die 19 Taxa implementierte Lösung, sie allesamt direkt unter Plantae zu hängen, gar nicht so schlecht, denn sie sollen eben nicht neben den anderen Rubus-Taxa stehen. Jedenfalls wüsste ich nicht, was man sonst mit ihnen machen soll. Eventuell kann man sie innerhalb der Plantae unter eine Zwischenstufe hängen wie "Rubus biotypes" oder so ähnlich.

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)