Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Critical Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Checklistbank
    • Labels:

      Description

      Some 20.000 backbone taxa are lacking a kingdom_fk even though they link to a kingdom via the parent classification. This is both true on prod and uat and included current as well as deleted taxa, so it seems this existed for some time.

      Example is Cienkowskia aethiopica Solms which should be a plant:
      http://www.gbif.org/species/8438688
      http://www.gbif.org/species/8438688/classification

      prod_checklistbank2=> select count(*), deleted is not null, rank from name_usage where dataset_key = nubKey() and kingdom_fk is null group by 2,3;
       count | ?column? |    rank    
      -------+----------+------------
         271 | t        | FORM
         334 | f        | VARIETY
          40 | t        | SUBSPECIES
       13473 | t        | SPECIES
          59 | f        | UNRANKED
         561 | t        | VARIETY
          33 | f        | SUBSPECIES
       10888 | f        | SPECIES
          35 | t        | UNRANKED
          82 | f        | FORM
      

        Gliffy Diagrams

        Issue Links

          Activity

          Hide
          Markus Döring added a comment -

          This is still true for the January 2017 backbone

          uat_checklistbank=# select count(*), deleted is not null AS del, rank from name_usage where dataset_key = nubKey() and kingdom_fk is null group by 2,3 order by rank, del;
           count | del |    rank    
          -------+-----+------------
           25247 | f   | SPECIES
           13786 | t   | SPECIES
            1295 | f   | SUBSPECIES
              39 | t   | SUBSPECIES
             822 | f   | VARIETY
             566 | t   | VARIETY
             146 | f   | FORM
             269 | t   | FORM
             176 | f   | UNRANKED
              40 | t   | UNRANKED
          
          Show
          Markus Döring added a comment - This is still true for the January 2017 backbone uat_checklistbank=# select count(*), deleted is not null AS del, rank from name_usage where dataset_key = nubKey() and kingdom_fk is null group by 2,3 order by rank, del; count | del | rank -------+-----+------------ 25247 | f | SPECIES 13786 | t | SPECIES 1295 | f | SUBSPECIES 39 | t | SUBSPECIES 822 | f | VARIETY 566 | t | VARIETY 146 | f | FORM 269 | t | FORM 176 | f | UNRANKED 40 | t | UNRANKED

            People

            • Assignee:
              Markus Döring
              Reporter:
              Markus Döring
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: