Project

General

Profile

bug #7096

Add second symbol attribute to DefinedTermBase

Added by Andreas Müller about 1 year ago. Updated 6 months ago.

Status:
Resolved
Priority:
Highest
Category:
cdm
Target version:
Start date:
11/27/2017
Due date:
% Done:

70%

Severity:
normal
Found in Version:
Tags:

Description

In Cuba checklist we need 1 symbol for the short representations string, another one for the representation in the distribution editor.

A project may define which symbol to use for which use-case. Symbols are project specific, and not globally defined for the given vocabulary.

Before closing: adapt Cuba symbols and switch cuba to symbol2.

Associated revisions

Revision 432e932d (diff)
Added by Andreas Müller 7 months ago

fix #7096 Add second symbol attribute to DefinedTermBase

Revision 4cc1a141 (diff)
Added by Andreas Müller 7 months ago

ref #7096 add symbol2 to xmltype

History

#2 Updated by Andreas Müller about 1 year ago

  • Status changed from New to In Progress
  • Priority changed from New to Highest

#3 Updated by Andreas Müller 10 months ago

After doing so revert idInVocabulary in Cuba Database

NOT complete !!!

REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2062, 'native', 'n');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2056, 'naturalised', 'na');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2059, 'introduced: adventitious (casual)', 'ia');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2049, 'introduced: uncertain degree of naturalisation', 'ip');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2052, 'introduced: cultivated', 'ic');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2209, 'endemic, doubtfully present', '?e');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2063, 'doubtfully present', 'pd');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2216, 'endemic: reported in error', '-e');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2047, 'native: formerly native', 'ne');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2217, 'naturalised: reported in error', '-n');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2219, 'casual alien: reported in error', '-a');
REPLACE INTO `DefinedTermBase` (`id`, `titleCache`, `idInVocabulary`) VALUES (2218, 'not native but possibly naturalised: reported in error', '-p');

#4 Updated by Andreas Müller 10 months ago

id titleCache idInVocabulary symbol n vocabulary_id
2065 endemic e 2975 30
2062 native n 35746 30
2061 native: doubtfully native nd D 883 30
2056 naturalised na n 2 30
2060 introduced: naturalized in n 2735 30
2059 introduced: adventitious (casual) ia a 76 30
2051 cultivated c c 1632 30
2209 endemic, doubtfully present ?e ?● 9 30
2054 native: presence questionable nq ? 167 30
2214 naturalised, presence questionable ?n ?n 2 30
2050 cultivated, presence questionable cq ?c 1 30
2216 endemic: reported in error –e –● 1 30
2046 reported in error f 53 30
2045 native: reported in error nf 111 30
2233 doubtfully native: reported in error -d –d 1 30
2217 naturalised: reported in error -n –n 26 30
2219 casual alien: reported in error -a –a 3 30
2042 cultivated: reported in error cf 36 30
2210 not native but possibly naturalised p p 2617 56
2211 rare casual alien (a) (a) 39 56
2212 occasionally cultivated (c) (c) 256 56
2215 frequent casual alien, doubtfully present ?p ?p 2 56
2218 not native but possibly naturalised: reported in error -p –p 11 56

#5 Updated by Andreas Müller 10 months ago

2056 naturalised was mistakenly created

#6 Updated by Andreas Müller 7 months ago

  • Tags set to cuba, euro+med

#7 Updated by Andreas Müller 7 months ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 50

#8 Updated by Andreas Müller 7 months ago

  • Description updated (diff)

#10 Updated by Andreas Müller 6 months ago

  • % Done changed from 50 to 70

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)