Project

General

Profile

bug #7406

[CHECK] Check if all original source names of occurrences are correctly imported

Added by Andreas Müller about 1 year ago. Updated about 2 months ago.

Status:
Resolved
Priority:
Highest
Category:
cdmadapter
Target version:
Start date:
05/09/2018
Due date:
% Done:

90%

Estimated time:
2.00 h
Severity:
normal
Found in Version:
Tags:

Description

For Bellis perennis var. hybrida this is currently not the case (see distribution for Bellis perennis in Sicily (ref: Giardina, G., Raimondo, F. M. & Spadaro, V.: A catalogue of plants growing in Sicily Bocconea 20. 2008, 70220)

SELECT s.*, n.* 
FROM emOccurrenceSource s
INNER JOIN Name n ON s.OldNameFk = n.NameID 
WHERE s.OldName = 'Bellis perennis var. hybrida' AND SourceNumber = '70220' OR s.OldNameFk = 117931

Related issues

Related to Edit - task #7798: [AM, ERS]: Import (freetext) nameInSource correctly Resolved 09/29/2018

History

#2 Updated by Andreas Müller 12 months ago

  • Priority changed from Highest to Priority14

#3 Updated by Andreas Müller 8 months ago

  • Target version changed from Euro+Med Portal Release to Euro+Med Migration

#4 Updated by Andreas Müller 8 months ago

  • Subject changed from [E+M] Check if all original source names of occurrences are correctly imported to [CHECK] Check if all original source names of occurrences are correctly imported

#5 Updated by Andreas Müller 8 months ago

  • Related to task #7798: [AM, ERS]: Import (freetext) nameInSource correctly added

#6 Updated by Andreas Müller 8 months ago

  • Priority changed from Priority14 to Highest

#7 Updated by Andreas Müller about 2 months ago

It looks like this is correct now. However, there were >3500 duplicates in emOccurrenceSource with same OccFk, SourceNumber and 1 side has no oldName and no oldNameFk.
I deleted them all

Potential candidates (uncomment for stricter rules)

SELECT os1.*, os2.OccurrenceSourceId, os2.OccurrenceFk, os2.Source, os2.OldName, os2.OldNameFk, os2.PreferredReferenceFlag
FROM emOccurrenceSource os1 INNER JOIN emOccurrenceSource os2 ON os1.OccurrenceFk = os2.OccurrenceFk 
AND os1.SourceNumber = os2.SourceNumber -- AND (os1.Source=os2.Source OR os1.Source IS NULL AND os2.Source IS NULL) 
AND os1.OccurrenceSourceId <>  os2.OccurrenceSourceId AND (os1.OldName IS NULL AND os1.OldNameFK IS NULL )
-- AND os1.PreferredReferenceFlag IS NULL
ORDER BY os1.SourceNumber

#8 Updated by Andreas Müller about 2 months ago

  • Status changed from New to In Progress

Check results for bellis perennis in Sicily if no duplicate sources exist anymore. The duplicates can not be seen in BM Editor by the way.

#9 Updated by Andreas Müller about 2 months ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 90

Should be resolved. Check again before closing.

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)