Project

General

Profile

task #7369

Updated by Andreas Müller almost 6 years ago

Currently 268 taxa in E+M have an IsExcludedMarker with Extension "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 theses taxa should be included in the taxon tree somehow. 


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

 ~~~ sql 
 SELECT     syn.FullNameCache,    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 
 WHERE          (pt.RIdentifier IN (452426)) OR 
                          (pt.IsExcludedExtension IS NOT NULL) OR 
                          (pt.IsExcludedMarker = 1) 
 ORDER BY pt.IsExcludedExtension 
 ~~~ 



 






Back