Project

General

Profile

Actions
Copy link

task #6557

closed

Import Bogota data

Added by Andreas Müller over 7 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Highest
Assignee:
Andreas Müller
Category:
data
Target version:
-
Start date:
Due date:
% Done:

80%

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

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
Copy link
 #1

Updated by Andreas Müller over 7 years ago

Actions
Copy link
 #2

Updated by Andreas Müller over 7 years ago

  • Description updated (diff)
Actions
Copy link
 #3

Updated by Andreas Müller over 7 years ago

  • % Done changed from 0 to 30
Actions
Copy link
 #4

Updated by Andreas Müller over 7 years ago

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

Updated by Andreas Müller over 7 years ago

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

Updated by Andreas Müller over 7 years ago

  • Description updated (diff)
Actions
Copy link
 #7

Updated by Andreas Müller over 7 years ago

  • Description updated (diff)
Actions
Copy link
 #8

Updated by Andreas Müller over 7 years ago

  • Description updated (diff)
Actions
Copy link
 #9

Updated by Andreas Müller over 7 years ago

  • Description updated (diff)
Actions
Copy link
 #10

Updated by Andreas Müller over 7 years ago

  • Description updated (diff)
Actions
Copy link
 #11

Updated by Andreas Müller over 7 years ago

Actions
Copy link
 #12

Updated by Andreas Müller over 7 years ago

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

Updated by Andreas Müller over 7 years ago

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

Updated by Andreas Müller over 7 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
Copy link
 #15

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

Updated by Andreas Müller over 7 years ago

Actions
Copy link
 #17

Updated by Andreas Müller over 7 years ago

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

Updated by Andreas Müller over 7 years ago

  • Description updated (diff)
Actions
Copy link
 #19

Updated by Andreas Müller over 7 years ago

  • % Done changed from 30 to 50
Actions
Copy link
 #20

Updated by Andreas Müller about 7 years ago

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

Updated by Andreas Müller about 7 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
Copy link
 #23

Updated by Andreas Müller about 7 years ago

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

Also available in: Atom PDF