Project

General

Profile

Actions

task #6557

closed

Import Bogota data

Added by Andreas Müller over 5 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Highest
Category:
data
Target version:
-
Start date:
Due date:
% Done:

80%

Estimated time:
40:00 h
Severity:
major
Tags:

Description

Import checklist and later import specimen data

Open issues:

  • capital family names
  • deduplication
  • improve sec reference
  • homotypische Gruppen => #6576
  • Autonyme und ähnliche "None" names => decision by users if further automization necessary
  • line no in original source
  • nameCache of hybrids is empty e.g. Mentha aquatica L. x Mentha spicata L. #6578

Files

Bogota Import.msg (82.5 KB) Bogota Import.msg Mail to Grischa after import Andreas Müller, 05/04/2017 12:26 AM

Related issues

Related to EDIT - task #6137: Urgent importsIn ProgressAndreas Müller

Actions
Related to EDIT - feature request #6576: Implement operation that guesses all basionyms for a syonymyClosedAndreas Müller

Actions
Related to EDIT - feature request #6577: Make sp. nov. parsableClosedAndreas Müller

Actions
Related to EDIT - bug #6578: Implement name cache for hybrid formulasResolvedAndreas Müller

Actions
Related to EDIT - task #6606: Import Bogota specimen dataClosedAndreas Müller

Actions
Actions #1

Updated by Andreas Müller over 5 years ago

Actions #2

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions #3

Updated by Andreas Müller over 5 years ago

  • % Done changed from 0 to 30
Actions #4

Updated by Andreas Müller over 5 years ago

  • Status changed from New to In Progress
  • Priority changed from New to Highest
Actions #5

Updated by Andreas Müller over 5 years ago

  • Target version changed from Release 4.8 to Release 4.7
Actions #6

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions #7

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions #8

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions #9

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions #10

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions #11

Updated by Andreas Müller over 5 years ago

Actions #12

Updated by Andreas Müller over 5 years ago

  • Status changed from In Progress to Resolved
  • % Done changed from 30 to 50
Actions #13

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
  • % Done changed from 50 to 30
Actions #14

Updated by Andreas Müller over 5 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)

Actions #15

Updated by Andreas Müller over 5 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
Actions #16

Updated by Andreas Müller over 5 years ago

Actions #17

Updated by Andreas Müller over 5 years ago

  • Related to bug #6578: Implement name cache for hybrid formulas added
Actions #18

Updated by Andreas Müller over 5 years ago

  • Description updated (diff)
Actions #19

Updated by Andreas Müller over 5 years ago

  • % Done changed from 30 to 50
Actions #20

Updated by Andreas Müller over 5 years ago

  • Related to task #6606: Import Bogota specimen data added
Actions #21

Updated by Andreas Müller over 5 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.

Actions #23

Updated by Andreas Müller over 5 years ago

  • Status changed from Resolved to Closed
  • Target version deleted (Release 4.7)
Actions

Also available in: Atom PDF