Actions
bug #7406
open[CHECK] Check if all original source names of occurrences are correctly imported
Status:
Resolved
Priority:
Highest
Assignee:
Category:
cdmadapter
Target version:
Start date:
Due date:
% Done:
90%
Estimated time:
2:00 h
Severity:
normal
Found in Version:
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
Updated by Andreas Müller almost 6 years ago
- Priority changed from Highest to Priority14
Updated by Andreas Müller over 5 years ago
- Target version changed from Euro+Med Portal Release to Euro+Med Migration
Updated by Andreas Müller over 5 years 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
Updated by Andreas Müller over 5 years ago
- Related to task #7798: [AM, ERS]: Import (freetext) nameInSource correctly added
Updated by Andreas Müller over 5 years ago
- Priority changed from Priority14 to Highest
Updated by Andreas Müller about 5 years 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
Updated by Andreas Müller about 5 years 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.
Updated by Andreas Müller about 5 years ago
- Status changed from In Progress to Resolved
- % Done changed from 0 to 90
Should be resolved. Check again before closing.
Actions