Project

General

Profile

task #7758

Manual cleanup after E+M import

Added by Andreas Müller 10 months ago. Updated 8 months ago.

Status:
New
Priority:
Highest
Category:
data
Start date:
09/13/2018
Due date:
% Done:

0%

Severity:
normal
Tags:

Description

The following tasks should be done manually after final E+M import:

  • remaining issues from logfile
  • deduplicate blocking names and handle preliminary ones
  • handle remaining taxon relationship notes
  • generally check remaining notes also for technical/editorial
  • move "n.v." notes from taxon name to nomenclatural source (for now, all n.v. end up in name annotations but the better place are probably nom.source annotations)
  • deduplicate agents (see #7758#note-5)
  • deduplicate source numbers (ReferenceSourceNumbers.xlsx)

ReferenceSourceNumbers.xlsx (41.6 KB) Andreas Müller, 11/06/2018 06:05 PM

History

#1 Updated by Andreas Müller 10 months ago

  • Description updated (diff)

#2 Updated by Andreas Müller 10 months ago

  • Description updated (diff)

#3 Updated by Andreas Müller 10 months ago

  • Description updated (diff)

#4 Updated by Andreas Müller 10 months ago

  • Description updated (diff)

#5 Updated by Andreas Müller 9 months ago

Clean up Agent duplicates:


SELECT osb.id, ab.id, ab.DTYPE, osb.idInSource, osb.idNamespace,  ab.titleCache, ab.nomenclaturalTitle, ab.protectedTitleCache, 
   ab.protectedNomenclaturalTitleCache, ab.familyName, ab.givenName, ab.initials, ab.*
FROM AgentBase ab LEFT OUTER JOIN AgentBase_OriginalSourceBase MN ON MN.AgentBase_id = ab.id 
LEFT OUTER JOIN OriginalSourceBase osb ON osb.id = MN.sources_id
WHERE  (1 = 1) 
-- AND idNamespace like 'Author%'
AND titleCache IN (SELECT titleCache FROM (
SELECT a.titleCache, a.nomenclaturalTitle, count(*) n
FROM AgentBase a
GROUP BY a.titleCache, a.nomenclaturalTitle, a.DTYPE
HAVING n > 1) as drv )

ORDER BY ab.nomenclaturalTitle, ab.titleCache, length(idInSource), idInSource

#6 Updated by Andreas Müller 9 months ago

  • Description updated (diff)

#7 Updated by Andreas Müller 9 months ago

#8 Updated by Andreas Müller 8 months ago

Make Strid & Kit Tan a BookSection

in Strid & Kit Tan, Mount. Fl. Greece 1: 570. 1986 | Euphorbia myrsinites subsp. rechingeri (Greuter) Aldén in Strid & Kit Tan, Mount. Fl. Greece 1: 570. 1986
in Strid & Kit Tan, Mount. Fl. Greece 1: 575. 1986 | Euphorbia amygdaloides subsp. heldreichii (Orph. ex Boiss.) Aldén in Strid & Kit Tan, Mount. Fl. Greece 1: 575. 1986
in Strid & Kit Tan, Mount. Fl. Greece 2: 123. 1991 | Satureja montana subsp. macedonica (Formánek) Baden in Strid & Kit Tan, Mount. Fl. Greece 2: 123. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 125. 1991 | Satureja parnassica subsp. athoa (K. Malý) Baden in Strid & Kit Tan, Mount. Fl. Greece 2: 125. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 126. 1991 | Satureja horvatii subsp. macrophylla (Halácsy) Baden in Strid & Kit Tan, Mount. Fl. Greece 2: 126. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 156. 1991 | Thymus sibthorpii var. grisebachii (Ronniger) Jalas & Baden in Strid & Kit Tan, Mount. Fl. Greece 2: 156. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 156. 1991 | Thymus sibthorpii var. substriatus (Borbás) Baden in Strid & Kit Tan, Mount. Fl. Greece 2: 156. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 157. 1991 | Thymus thracicus var. nobilis (Ronniger) Baden in Strid & Kit Tan, Mount. Fl. Greece 2: 157. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 160. 1991 | Thymus longicaulis var. ocheus (Heldr. & Sart. ex Boiss.) Baden in Strid & Kit Tan, Mount. Fl. Greece 2: 160. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 679. 1991 | Fritillaria mutabilis Kamari in Strid & Kit Tan, Mount. Fl. Greece 2: 679. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 680. 1991 | Fritillaria thessala (Boiss.) Kamari in Strid & Kit Tan, Mount. Fl. Greece 2: 680. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 682. 1991 | Fritillaria thessala subsp. ionica (Halácsy) Kamari in Strid & Kit Tan, Mount. Fl. Greece 2: 682. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 682. 1991 | Fritillaria thessala subsp. reiseri Kamari in Strid & Kit Tan, Mount. Fl. Greece 2: 682. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 689. 1991 | Ornithogalum fimbriatum subsp. gracilipes (Zahar.) Landström in Strid & Kit Tan, Mount. Fl. Greece 2: 689. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 691. 1991 | Ornithogalum exscapum var. collinum (Guss.) Stearn in Strid & Kit Tan, Mount. Fl. Greece 2: 691. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 74. 1991 | Teucrium montanum subsp. helianthemoides (Adamovic) Baden in Strid & Kit Tan, Mount. Fl. Greece 2: 74. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 88. 1991 | Sideritis clandestina subsp. peloponnesiaca (Boiss. & Heldr.) Baden in Strid & Kit Tan, Mount. Fl. Greece 2: 88. 1991
in Strid & Kit Tan, Mount. Fl. Greece 2: 91. 1991 | Sideritis perfoliata subsp. athoa (Papan. & Kokkini) Baden in Strid & Kit Tan, Mount. Fl. Greece 2: 91. 1991

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)