task #7369
closedHandle taxonomically valueless taxa correctly
100%
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.
Related issues