task #7816
Updated by Andreas Müller over 5 years ago
In E+M most nomenclatural status have a reference. In most cases it is one of the references 7000000, 7100000, 7200000, ... In >400 cases it is 500001 "Euro+Med version 1.2 2004.". In 5 cases it is another reference. ~~~ 9337 KÜPFER, P. - Recherches sur les liens de parenté entre la flore orophile des Alpes et celle des Pyrénées. Boissiera 23: [1]-322, 10 tab. 1974. 6432904 Greuter, W., Burdet, H. M. & Long, G. - Med-Checklist 3 Genève & Berlin 1986. 7004900 MacNeill - Notes Royal Bot. Gard. Edinburgh 24 1962. 7200815 Feddes Repert. 84:464. 1973 7201080 Naturalia Monspel., Sér. Bot. 16: 107 (1965) ~~~ We need to decide if these reference should be used as they are or if some of them can be removed. Maybe also some can be replaced by the more specific last scrutiny references. But this is not trivial as during the import of the nom status the last scrutiny is not yet known in the CDM database. ~~~ SELECT NomStatusRefFk, count(*) as n FROM NomStatusRel rel WHERE rel.NomStatusRefFk IS NOT NULL AND rel.NameFk IN (SELECT NameID From v_cdm_exp_namesAll) GROUP BY NomStatusRefFk ORDER BY n ~~~ ~~Also Also we need to add missing references to the import.~~ import.