Nub contains 107 times the form Fusarium oxysporum f. sp

11409
Reporter: mdoering
Assignee: mdoering
Type: Bug
Summary: Nub contains 107 times the form Fusarium oxysporum f. sp
Priority: Critical
Status: Open
Created: 2012-06-11 16:46:36.103
Updated: 2013-12-09 14:02:09.564
        
Description: Nub contains duplicates of some hundred species or infraspecific names.
The worst case is Fusarium oxysporum f. sp which exists 107 times as a form with the same classification in the nub.

Other name ids that occur many times in the nub:
  NAME_ID |  count()
   367975 |    10
  6660935 |    10
  7198552 |    10
  7782146 |    10
  9553912 |    10
  9595792 |    10
  9645838 |    10
 11464009 |    10
 11465337 |    10
 11522101 |    10
 11541187 |    10
 11573328 |    10
 11574140 |    10
 11575179 |    10
 11461516 |    11
 11551065 |    11
 11551715 |    11
 11553000 |    11
 11553003 |    11
  6611446 |    12
 11499297 |    12
 11509981 |    12
 11538208 |    12
 11541703 |    12
 11575061 |    12
 11464092 |    13
 11597479 |    13
  6629834 |    14
 11499289 |    14
 11499694 |    14
 11523412 |    14
 11536164 |    14
   360759 |    15
 11504829 |    18
 11552582 |    20
  7791292 |    23
 11536165 |    24
  7759794 |    25
 11575046 |    26
  9562077 |    57
  6579794 |   107]]>
    

Author: mdoering@gbif.org
Created: 2012-06-11 16:47:29.329
Updated: 2012-06-11 16:47:29.329
        
clb-indexing=# select * from name_string where id=6579794;
   id    |     scientific_name      | canonical_name_fk | canonical_full_name_fk | type |          modified          | manually_curated
---------+--------------------------+-------------------+------------------------+------+----------------------------+------------------
 6579794 | Fusarium oxysporum f. sp |           3335002 |                3335002 |    6 | 2012-05-26 02:55:45.790107 | f


clb-indexing=# select * from name_string where id=9562077;
   id    |      scientific_name       | canonical_name_fk | canonical_full_name_fk | type |          modified          | manually_curated
---------+----------------------------+-------------------+------------------------+------+----------------------------+------------------
 9562077 | Puccinia rubigo-vera f. sp |           1991549 |                1991549 |    6 | 2012-05-26 05:23:36.917498 | f


clb-indexing=# select * from name_string where id=11575046;
    id    |                             scientific_name                             | canonical_name_fk | canonical_full_name_fk | type |          modified          | manually_curated
----------+-------------------------------------------------------------------------+-------------------+------------------------+------+----------------------------+------------------
 11575046 | Chilostoma (Cingulifera) subsp. cingulatum cingulatum (S. Studer, 1820) |          11575039 |               11575039 |    0 | 2012-05-30 19:36:53.966103 | f

clb-indexing=# select * from name_string where id=7759794;
   id    |                scientific_name                | canonical_name_fk | canonical_full_name_fk | type |          modified          | manually_curated
---------+-----------------------------------------------+-------------------+------------------------+------+----------------------------+------------------
 7759794 | Chenopodium ambrosioides L. var. ambrosioides |           7610936 |                7759793 |    0 | 2012-05-26 01:48:15.687062 | f


clb-indexing=# select * from name_string where id=360759;
   id   |           scientific_name           | canonical_name_fk | canonical_full_name_fk | type |          modified          | manually_curated
--------+-------------------------------------+-------------------+------------------------+------+----------------------------+------------------
 360759 | Centaurea phrygia L. subsp. phrygia |            360757 |                 360758 |    0 | 2012-05-26 01:41:50.982697 | f