task #6557
Import Bogota data
80%
Description
Import checklist and later import specimen data
Open issues:
Related issues
Associated revisions
ref #6557 first bogotaChecklist import version
fix #6557 implement basionym relation creator
ref #6557 improvement to bogotaChecklist import
ref #6557 add name deduplication do ImportDeduplicationHelper
ref #6557 add name deduplication to Bogota import and improved source handling
fix #6557 final import for flora bogota checklist
History
#1 Updated by Andreas Müller almost 3 years ago
- Related to task #6137: Urgent imports added
#2 Updated by Andreas Müller almost 3 years ago
- Description updated (diff)
#3 Updated by Andreas Müller almost 3 years ago
- % Done changed from 0 to 30
#4 Updated by Andreas Müller almost 3 years ago
- Status changed from New to In Progress
- Priority changed from New to Highest
#5 Updated by Andreas Müller almost 3 years ago
- Target version changed from Release 4.8 to Release 4.7
#6 Updated by Andreas Müller almost 3 years ago
- Description updated (diff)
#7 Updated by Andreas Müller almost 3 years ago
- Description updated (diff)
#8 Updated by Andreas Müller almost 3 years ago
- Description updated (diff)
#9 Updated by Andreas Müller almost 3 years ago
- Description updated (diff)
#10 Updated by Andreas Müller almost 3 years ago
- Description updated (diff)
#11 Updated by Andreas Müller almost 3 years ago
- Related to feature request #6576: Implement operation that guesses all basionyms for a syonymy added
#12 Updated by Andreas Müller almost 3 years ago
- Status changed from In Progress to Resolved
- % Done changed from 30 to 50
Applied in changeset cdmlib|4cd473206ecc56a523020c28166c0750afc1484f.
#13 Updated by Andreas Müller almost 3 years ago
- Description updated (diff)
- % Done changed from 50 to 30
#14 Updated by Andreas Müller almost 3 years ago
- Description updated (diff)
Name.titleCache duplicates:
SELECT titleCache, count(*) as n
FROM TaxonNameBase
GROUP BY titleCache
Having n > 1
some are hybrid parents, some are duplicates (synonyms + accepted infraspecific)
#15 Updated by Andreas Müller almost 3 years ago
Homonyme and similar:
SELECT tnb.titleCache, tnb.nameCache
FROM TaxonNameBase tnb INNER JOIN
(SELECT nameCache
FROM TaxonNameBase
GROUP BY nameCache
Having count(*) > 1
) as drv ON tnb.nameCache = drv.nameCache
ORDER BY tnb.nameCache, tnb.titleCache
#16 Updated by Andreas Müller almost 3 years ago
- Related to feature request #6577: Make sp. nov. parsable added
#17 Updated by Andreas Müller almost 3 years ago
- Related to bug #6578: Implement name cache for hybrid formulas added
#18 Updated by Andreas Müller almost 3 years ago
- Description updated (diff)
#19 Updated by Andreas Müller almost 3 years ago
- % Done changed from 30 to 50
Applied in changeset cdmlib-apps|f7802e9485fc42ca4716224ffc524e5022effa4f.
#20 Updated by Andreas Müller over 2 years ago
- Related to task #6606: Import Bogota specimen data added
#21 Updated by Andreas Müller over 2 years ago
- % Done changed from 50 to 80
Created new ticket for specimen data #6606.
Still need to add logfile mail to Grischa and then can close this ticket.
#22 Updated by Andreas Müller over 2 years ago
- File Bogota Import.msg added
#23 Updated by Andreas Müller over 2 years ago
- Status changed from Resolved to Closed
- Target version deleted (
Release 4.7)
