Project

General

Profile

task #6277

task #6009: Import the IAPT database into a cdm instance

task #6034: DataCleaning after final import

use nomenclatural reference as sec. references instead of IAPT

Added by Andreas Kohlbecker over 3 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Highest
Category:
Import
Start date:
12/13/2016
Due date:
% Done:

100%


Description

use nomenclatural reference as sec. references for all taxa which have the IAPT as sec reference

this can be done using the following sql script:

update TaxonBase t set t.sec_id =
    ( select r.id from TaxonNameBase n
      join Reference r on  n.nomenclaturalReference_id = r.id
      where n.id = t.name_id
    )
  where sec_id = 14 and ( select r.id from TaxonNameBase n
      join Reference r on  n.nomenclaturalReference_id = r.id
      where n.id = t.name_id
    ) is not null;


update TaxonBase t set t.titleCache = null
where t.protectedTitleCache = 0 and t.sec_id is not null;

Related issues

Related to Edit - feature request #6278: add sec reference as class attribute to all taxon markup Closed 12/13/2016

History

#1 Updated by Andreas Kohlbecker over 3 years ago

  • Description updated (diff)
  • Status changed from New to In Progress

#2 Updated by Andreas Kohlbecker over 3 years ago

  • Status changed from In Progress to Feedback
  • Assignee changed from Andreas Kohlbecker to Wolf-Henning Kusber
  • % Done changed from 0 to 30

script applied to the test database.

@Henning: Please take a look at the data in the editor and check if the data is corrupted.

#3 Updated by Wolf-Henning Kusber over 3 years ago

The data looks quiete good, e.g.
Achnanthes boudoui Metzeltin & Lange-Bert. sec. Metzeltin & Lange-Bert., 1998

Formally it is

Genus specificepithet nomenclatural Author team (according to Brummitt & Powell standard) sec. nomenclatural Author team, Year

This works for me (for the IAPT data)

The only thing is, that normally the sec. reference should have bibliographic authors,
e.g. Metzeltin D. & Lange-Bertalot H., 1998

Bibliographic authors are missing in the IAPT database, as far as I know.

#4 Updated by Andreas Kohlbecker over 3 years ago

  • Status changed from Feedback to Closed
  • Assignee changed from Wolf-Henning Kusber to Andreas Kohlbecker

Wolf-Henning Kusber wrote:

The only thing is, that normally the sec. reference should have bibliographic authors,
e.g. Metzeltin D. & Lange-Bertalot H., 1998

Bibliographic authors are missing in the IAPT database, as far as I know.
The authorstring that has been imported in this case was: Metzeltin & Lange-Bert. so there is no further detail on the autors. Any additional data must be entered manually.

I will close the ticket as solved.

#5 Updated by Andreas Kohlbecker over 3 years ago

  • % Done changed from 30 to 100

#6 Updated by Andreas Kohlbecker over 3 years ago

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)