Project

General

Profile

task #7816

Handle nomStatus references correctly

Added by Andreas Müller 8 months ago. Updated 12 days ago.

Status:
New
Priority:
Priority14
Category:
cdmadapter
Start date:
10/10/2018
Due date:
% Done:

20%

Estimated time:
1.50 h
Severity:
normal
Tags:

Description

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 we need to add missing references to the import.

History

#1 Updated by Andreas Müller 8 months ago

  • Description updated (diff)

#2 Updated by Andreas Müller 8 months ago

  • Description updated (diff)

#3 Updated by Andreas Müller 8 months ago

  • % Done changed from 0 to 20
  • Estimated time set to 1.50 h

#4 Updated by Andreas Müller 12 days ago

  • Target version changed from Euro+Med Migration to Euro+Med post migration

We will decide this only after migration

#5 Updated by Andreas Müller 12 days ago

  • Priority changed from Highest to Priority14

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)