cdm-pesi/src/main/java/eu/etaxonomy/cdm/io/pesi/out/PesiTransformer.java

   1 // $Id$
   2 /**
   3 * Copyright (C) 2009 EDIT
   4 * European Distributed Institute of Taxonomy
   5 * http://www.e-taxonomy.eu
   6 *
   7 * The contents of this file are subject to the Mozilla Public License Version 1.1
   8 * See LICENSE.TXT at the top of this package for the full license terms.
   9 */
  10 package eu.etaxonomy.cdm.io.pesi.out;
  11
  12 import java.sql.ResultSet;
  13 import java.sql.SQLException;
  14 import java.util.BitSet;
  15 import java.util.HashMap;
  16 import java.util.Map;
  17 import java.util.UUID;
  18
  19 import org.apache.commons.lang.StringUtils;
  20 import org.apache.log4j.Logger;
  21
  22 import eu.etaxonomy.cdm.common.CdmUtils;
  23 import eu.etaxonomy.cdm.io.berlinModel.BerlinModelTransformer;
  24 import eu.etaxonomy.cdm.io.common.Source;
  25 import eu.etaxonomy.cdm.io.common.mapping.UndefinedTransformerMethodException;
  26 import eu.etaxonomy.cdm.io.common.mapping.out.ExportTransformerBase;
  27 import eu.etaxonomy.cdm.io.common.mapping.out.IExportTransformer;
  28 import eu.etaxonomy.cdm.io.pesi.erms.ErmsTransformer;
  29 import eu.etaxonomy.cdm.io.pesi.faunaEuropaea.FaunaEuropaeaTransformer;
  30 import eu.etaxonomy.cdm.model.common.CdmBase;
  31 import eu.etaxonomy.cdm.model.common.Language;
  32 import eu.etaxonomy.cdm.model.common.RelationshipBase;
  33 import eu.etaxonomy.cdm.model.common.RelationshipTermBase;
  34 import eu.etaxonomy.cdm.model.description.AbsenceTerm;
  35 import eu.etaxonomy.cdm.model.description.Feature;
  36 import eu.etaxonomy.cdm.model.description.PresenceAbsenceTermBase;
  37 import eu.etaxonomy.cdm.model.description.PresenceTerm;
  38 import eu.etaxonomy.cdm.model.location.NamedArea;
  39 import eu.etaxonomy.cdm.model.location.TdwgArea;
  40 import eu.etaxonomy.cdm.model.location.WaterbodyOrCountry;
  41 import eu.etaxonomy.cdm.model.name.HybridRelationshipType;
  42 import eu.etaxonomy.cdm.model.name.NameRelationshipType;
  43 import eu.etaxonomy.cdm.model.name.NameTypeDesignationStatus;
  44 import eu.etaxonomy.cdm.model.name.NomenclaturalCode;
  45 import eu.etaxonomy.cdm.model.name.NomenclaturalStatusType;
  46 import eu.etaxonomy.cdm.model.name.Rank;
  47 import eu.etaxonomy.cdm.model.occurrence.Fossil;
  48 import eu.etaxonomy.cdm.model.reference.Reference;
  49 import eu.etaxonomy.cdm.model.reference.ReferenceType;
  50 import eu.etaxonomy.cdm.model.taxon.Synonym;
  51 import eu.etaxonomy.cdm.model.taxon.SynonymRelationship;
  52 import eu.etaxonomy.cdm.model.taxon.SynonymRelationshipType;
  53 import eu.etaxonomy.cdm.model.taxon.Taxon;
  54 import eu.etaxonomy.cdm.model.taxon.TaxonBase;
  55 import eu.etaxonomy.cdm.model.taxon.TaxonRelationshipType;
  56 import eu.etaxonomy.cdm.strategy.exceptions.UnknownCdmTypeException;
  57
  58 /**
  59  * @author e.-m.lee
  60  * @author a.mueller (update)
  61  * @date 16.02.2010
  62  *
  63  */
  64 public final class PesiTransformer extends ExportTransformerBase implements IExportTransformer{
  65         private static final Logger logger = Logger.getLogger(PesiTransformer.class);
  66
  67         public static final String AUCT_STRING = "auct.";
  68
  69
  70         //source identifiers
  71         public static final int SOURCE_EM = 1;
  72         public static final int SOURCE_FE = 2;
  73         public static final int SOURCE_IF = 3;
  74         public static final int SOURCE_ERMS = 4;
  75
  76         //sourceRefUUIDs
  77         public static final UUID uuidSourceRefEuroMed = UUID.fromString("0603a84a-f024-4454-ab92-9e2ac0139126");
  78         public static final UUID uuidSourceRefFaunaEuropaea = UUID.fromString("6786d863-75d4-4796-b916-c1c3dff4cb70");
  79         public static final UUID uuidSourceRefErms = UUID.fromString("7744bc26-f914-42c4-b54a-dd2a030a8bb7");
  80         public static final UUID uuidSourceRefIndexFungorum = UUID.fromString("8de25d27-7d40-47f4-af3b-59d64935a843");
  81
  82         public static final String SOURCE_STR_EM = "E+M";
  83         public static final String SOURCE_STR_FE = "FaEu";
  84         public static final String SOURCE_STR_IF = "IF";
  85         public static final String SOURCE_STR_ERMS = "ERMS";
  86
  87         // status keys
  88         public static int QUALITY_STATUS_CHECKED_EDITOR_ERMS_1_1 = 0;
  89         public static int QUALITY_STATUS_ADD_BY_DBMT= 2;
  90         public static int QUALITY_STATUS_CHECKED_EDITOR = 3;
  91         public static int QUALITY_STATUS_EDITED_BY_DBMT = 4;
  92
  93
  94
  95         //extension type uuids
  96         public static final UUID cacheCitationUuid = UUID.fromString("29656168-32d6-4301-9067-d57c63be5c67");
  97         //public static final UUID expertUserIdUuid = UUID.fromString("e25813d3-c67c-4585-9aa0-970fafde50b4");
  98         //public static final UUID speciesExpertUserIdUuid = UUID.fromString("6d42abd8-8894-4980-ae07-e918affd4172");
  99         public static final UUID expertNameUuid = BerlinModelTransformer.uuidExpertName;
 100         public static final UUID speciesExpertNameUuid = BerlinModelTransformer.uuidSpeciesExpertName;
 101         public static final UUID lastActionDateUuid = UUID.fromString("8d0a7d81-bb83-4576-84c3-8c906ef039b2");
 102         public static final UUID lastActionUuid = UUID.fromString("bc20d5bc-6161-4279-9499-89ea26ce5f6a");
 103         public static final UUID taxCommentUuid = UUID.fromString("8041a752-0479-4626-ab1b-b266b751f816");
 104         public static final UUID fauCommentUuid = UUID.fromString("054f773a-41c8-4ad5-83e3-981320c1c126");
 105         public static final UUID fauExtraCodesUuid = UUID.fromString("b8c7e77d-9869-4787-bed6-b4b302dbc5f5");
 106
 107         // References
 108         public static int REF_ARTICLE_IN_PERIODICAL = 1;
 109         public static int REF_PART_OF_OTHER = 2;
 110         public static int REF_BOOK = 3;
 111         public static int REF_DATABASE = 4;
 112         public static int REF_INFORMAL = 5;
 113         public static int REF_NOT_APPLICABLE = 6;
 114         public static int REF_WEBSITE = 7;
 115         public static int REF_PUBLISHED = 8;
 116         public static int REF_JOURNAL = 9;
 117         public static int REF_UNRESOLVED = 10;
 118         public static int REF_PUBLICATION = 11;
 119
 120         public static String REF_STR_ARTICLE_IN_PERIODICAL = "Article in periodical";
 121         public static String REF_STR_PART_OF_OTHER = "Part of other";
 122         public static String REF_STR_BOOK = "Book";
 123         public static String REF_STR_DATABASE = "Database";
 124         public static String REF_STR_INFORMAL = "Informal";
 125         public static String REF_STR_NOT_APPLICABLE = "Not applicable";
 126         public static String REF_STR_WEBSITE = "Website";
 127         public static String REF_STR_PUBLISHED = "Published";
 128         public static String REF_STR_JOURNAL = "Journal";
 129         public static String REF_STR_UNRESOLVED = "Unresolved";
 130         public static String REF_STR_PUBLICATION = "Publication";
 131
 132         // NameStatus
 133         public static int NAME_ST_NOM_INVAL = 1;
 134         public static int NAME_ST_NOM_ILLEG = 2;
 135         public static int NAME_ST_NOM_NUD = 3;
 136         public static int NAME_ST_NOM_REJ = 4;
 137         public static int NAME_ST_NOM_REJ_PROP = 5;
 138         public static int NAME_ST_NOM_UTIQUE_REJ = 6;
 139         public static int NAME_ST_NOM_UTIQUE_REJ_PROP = 7;
 140         public static int NAME_ST_NOM_CONS = 8;
 141         public static int NAME_ST_NOM_CONS_PROP = 9;
 142         public static int NAME_ST_ORTH_CONS = 10;
 143         public static int NAME_ST_ORTH_CONS_PROP = 11;
 144         public static int NAME_ST_NOM_SUPERFL = 12;
 145         public static int NAME_ST_NOM_AMBIG = 13;
 146         public static int NAME_ST_NOM_PROVIS = 14;
 147         public static int NAME_ST_NOM_DUB = 15;
 148         public static int NAME_ST_NOM_NOV = 16;
 149         public static int NAME_ST_NOM_CONFUS = 17;
 150         public static int NAME_ST_NOM_ALTERN = 18;
 151         public static int NAME_ST_COMB_INVAL = 19;
 152         public static int NAME_ST_LEGITIMATE = 20; // PESI specific from here
 153         public static int NAME_ST_COMB_INED = 21;
 154         public static int NAME_ST_COMB_AND_STAT_INED = 22;
 155         public static int NAME_ST_NOM_AND_ORTH_CONS = 23;
 156         public static int NAME_ST_NOM_NOV_INED = 24;
 157         public static int NAME_ST_SP_NOV_INED = 25;
 158         public static int NAME_ST_ALTERNATE_REPRESENTATION = 26;
 159         public static int NAME_ST_TEMPORARY_NAME = 27;
 160         public static int NAME_ST_SPECIES_INQUIRENDA = 28;
 161
 162         // TaxonStatus
 163         public static int T_STATUS_ACCEPTED = 1;
 164         public static int T_STATUS_SYNONYM = 2;
 165         public static int T_STATUS_PARTIAL_SYN = 3;
 166         public static int T_STATUS_PRO_PARTE_SYN = 4;
 167         public static int T_STATUS_UNRESOLVED = 5;
 168         public static int T_STATUS_ORPHANED = 6;
 169         public static int T_STATUS_UNACCEPTED = 7;
 170
 171         public static String T_STATUS_STR_ACCEPTED = "Accepted";
 172         public static String T_STATUS_STR_SYNONYM = "Synonym";
 173         public static String T_STATUS_STR_PARTIAL_SYN = "Partial Synonym";
 174         public static String T_STATUS_STR_PRO_PARTE_SYN = "Pro Parte Synonym";
 175         public static String T_STATUS_STR_UNRESOLVED = "Unresolved";
 176         public static String T_STATUS_STR_ORPHANED = "Orphaned";
 177         public static String T_STATUS_STR_UNACCEPTED = "Unaccepted";
 178
 179         // TypeDesginationStatus
 180         public static int TYPE_BY_ORIGINAL_DESIGNATION = 1;
 181         public static int TYPE_BY_SUBSEQUENT_DESIGNATION = 2;
 182         public static int TYPE_BY_MONOTYPY = 3;
 183
 184         public static String TYPE_STR_BY_ORIGINAL_DESIGNATION = "Type by original designation";
 185         public static String TYPE_STR_BY_SUBSEQUENT_DESIGNATION = "Type by subsequent designation";
 186         public static String TYPE_STR_BY_MONOTYPY = "Type by monotypy";
 187
 188         // RelTaxonQualifier
 189         public static int IS_BASIONYM_FOR = 1;
 190         public static int IS_LATER_HOMONYM_OF = 2;
 191         public static int IS_REPLACED_SYNONYM_FOR = 3;
 192         public static int IS_VALIDATION_OF = 4;
 193         public static int IS_LATER_VALIDATION_OF = 5;
 194         public static int IS_TYPE_OF = 6;
 195         public static int IS_CONSERVED_TYPE_OF = 7;
 196         public static int IS_REJECTED_TYPE_OF = 8;
 197         public static int IS_FIRST_PARENT_OF = 9;
 198         public static int IS_SECOND_PARENT_OF = 10;
 199         public static int IS_FEMALE_PARENT_OF = 11;
 200         public static int IS_MALE_PARENT_OF = 12;
 201         public static int IS_CONSERVED_AGAINST = 13;
 202         public static int IS_REJECTED_IN_FAVOUR_OF = 14;
 203         public static int IS_TREATED_AS_LATER_HOMONYM_OF = 15;
 204         public static int IS_ORTHOGRAPHIC_VARIANT_OF = 16;
 205         public static int IS_ALTERNATIVE_NAME_FOR = 17;
 206         public static int HAS_SAME_TYPE_AS = 18;
 207         public static int IS_LECTOTYPE_OF = 61;
 208         public static int TYPE_NOT_DESIGNATED = 62;
 209         public static int IS_TAXONOMICALLY_INCLUDED_IN = 101;
 210         public static int IS_SYNONYM_OF = 102;
 211         public static int IS_MISAPPLIED_NAME_FOR = 103;
 212         public static int IS_PRO_PARTE_SYNONYM_OF = 104;
 213         public static int IS_PARTIAL_SYNONYM_OF = 105;
 214         public static int IS_HETEROTYPIC_SYNONYM_OF = 106;
 215         public static int IS_HOMOTYPIC_SYNONYM_OF = 107;
 216         public static int IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF = 201;
 217         public static int IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF = 202;
 218         public static int IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF = 203;
 219         public static int IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF = 204;
 220         public static int IS_INFERRED_EPITHET_FOR = 301;
 221         public static int IS_INFERRED_GENUS_FOR = 302;
 222         public static int IS_POTENTIAL_COMBINATION_FOR = 303;
 223
 224
 225         //namespaces
 226         public static String STR_NAMESPACE_NOMINAL_TAXON = "Nominal taxon from TAX_ID:";
 227         public static String STR_NAMESPACE_INFERRED_EPITHET = "Inferred epithet from TAX_ID:";
 228         public static String STR_NAMESPACE_INFERRED_GENUS = "Inferred genus from TAX_ID:";
 229         public static String STR_NAMESPACE_POTENTIAL_COMBINATION = "Potential combination from TAX_ID:";
 230
 231
 232         // Kingdoms
 233         public static int KINGDOM_NULL = 0;
 234         public static int KINGDOM_ANIMALIA = 2;
 235         public static int KINGDOM_PLANTAE = 3;
 236         public static int KINGDOM_FUNGI = 4;
 237         public static int KINGDOM_PROTOZOA = 5;
 238         public static int KINGDOM_BACTERIA = 6;
 239         public static int KINGDOM_CHROMISTA = 7;
 240
 241         // Animalia Ranks
 242         public static int Animalia_Kingdom = 10;
 243         public static int Animalia_Subkingdom = 20;
 244         public static int Animalia_Superphylum = 23;
 245         public static int Animalia_Phylum = 30;
 246         public static int Animalia_Subphylum = 40;
 247         public static int Animalia_Infraphylum = 45;
 248         public static int Animalia_Superclass = 50;
 249         public static int Animalia_Class = 60;
 250         public static int Animalia_Subclass = 70;
 251         public static int Animalia_Infraclass = 80;
 252         public static int Animalia_Superorder = 90;
 253         public static int Animalia_Order = 100;
 254         public static int Animalia_Suborder = 110;
 255         public static int Animalia_Infraorder = 120;
 256         public static int Animalia_Section = 121;
 257         public static int Animalia_Subsection = 122;
 258         public static int Animalia_Superfamily = 130;
 259         public static int Animalia_Family = 140;
 260         public static int Animalia_Subfamily = 150;
 261         public static int Animalia_Tribe = 160;
 262         public static int Animalia_Subtribe = 170;
 263         public static int Animalia_Genus = 180;
 264         public static int Animalia_Subgenus = 190;
 265         public static int Animalia_Species =220;
 266         public static int Animalia_Subspecies = 230;
 267         public static int Animalia_Natio = 235;
 268         public static int Animalia_Variety = 240;
 269         public static int Animalia_Subvariety = 250;
 270         public static int Animalia_Forma = 260;
 271
 272         public static String Animalia_STR_Kingdom = "Kingdom";
 273         public static String Animalia_STR_Subkingdom = "Subkingdom";
 274         public static String Animalia_STR_Superphylum = "Superphylum";
 275         public static String Animalia_STR_Phylum = "Phylum";
 276         public static String Animalia_STR_Subphylum = "Subphylum";
 277         public static String Animalia_STR_Infraphylum = "Infraphylum";
 278         public static String Animalia_STR_Superclass = "Superclass";
 279         public static String Animalia_STR_Class = "Class";
 280         public static String Animalia_STR_Subclass = "Subclass";
 281         public static String Animalia_STR_Infraclass = "Infraclass";
 282         public static String Animalia_STR_Superorder = "Superorder";
 283         public static String Animalia_STR_Order = "Order";
 284         public static String Animalia_STR_Suborder = "Suborder";
 285         public static String Animalia_STR_Infraorder = "Infraorder";
 286         public static String Animalia_STR_Section = "Section";
 287         public static String Animalia_STR_Subsection = "Subsection";
 288         public static String Animalia_STR_Superfamily = "Superfamily";
 289         public static String Animalia_STR_Family = "Family";
 290         public static String Animalia_STR_Subfamily = "Subfamily";
 291         public static String Animalia_STR_Tribe = "Tribe";
 292         public static String Animalia_STR_Subtribe = "Subtribe";
 293         public static String Animalia_STR_Genus = "Genus";
 294         public static String Animalia_STR_Subgenus = "Subgenus";
 295         public static String Animalia_STR_Species = "Species";
 296         public static String Animalia_STR_Subspecies = "Subspecies";
 297         public static String Animalia_STR_Natio = "Natio";
 298         public static String Animalia_STR_Variety = "Variety";
 299         public static String Animalia_STR_Subvariety = "Subvariety";
 300         public static String Animalia_STR_Forma = "Forma";
 301
 302         // Animalia Rank Abbreviations only for used Ranks
 303         public static String Animalia_Abbrev_Subgenus = "subg.";
 304         public static String Animalia_Abbrev_Species = "sp.";
 305         public static String Animalia_Abbrev_Subspecies = "subsp.";
 306         public static String Animalia_Abbrev_Variety = "var.";
 307         public static String Animalia_Abbrev_Subvariety = "subvar.";
 308         public static String Animalia_Abbrev_Forma = "f.";
 309
 310         // Plantae Ranks
 311         public static int Plantae_Kingdom = 10;
 312         public static int Plantae_Subkingdom = 20;
 313         public static int Plantae_Division = 30;
 314         public static int Plantae_Subdivision = 40;
 315         public static int Plantae_Class = 60;
 316         public static int Plantae_Subclass = 70;
 317         public static int Plantae_Order = 100;
 318         public static int Plantae_Suborder = 110;
 319         public static int Plantae_Family = 140;
 320         public static int Plantae_Subfamily = 150;
 321         public static int Plantae_Tribe = 160;
 322         public static int Plantae_Subtribe = 170;
 323         public static int Plantae_Genus = 180;
 324         public static int Plantae_Subgenus = 190;
 325         public static int Plantae_Section = 200;
 326         public static int Plantae_Subsection = 210;
 327         public static int Plantae_Series = 212;
 328         public static int Plantae_Subseries     = 214;
 329         public static int Plantae_Aggregate     = 216;
 330         public static int Plantae_Coll_Species = 218;
 331         public static int Plantae_Species = 220;
 332         public static int Plantae_Grex = 225;
 333         public static int Plantae_Subspecies = 230;
 334         public static int Plantae_Proles = 232;
 335         public static int Plantae_Race = 234;
 336         public static int Plantae_Convarietas = 236;
 337         public static int Plantae_Variety = 240;
 338         public static int Plantae_Subvariety = 250;
 339         public static int Plantae_Forma = 260;
 340         public static int Plantae_Subforma = 270;
 341         public static int Plantae_Forma_spec = 275;
 342         public static int Plantae_Taxa_infragen = 280;
 343         public static int Plantae_Taxa_infraspec = 285;
 344
 345         public static String Plantae_STR_Kingdom = "Kingdom";
 346         public static String Plantae_STR_Subkingdom = "Subkingdom";
 347         public static String Plantae_STR_Division = "Division";
 348         public static String Plantae_STR_Subdivision = "Subdivision";
 349         public static String Plantae_STR_Class = "Class";
 350         public static String Plantae_STR_Subclass = "Subclass";
 351         public static String Plantae_STR_Order = "Order";
 352         public static String Plantae_STR_Suborder = "Suborder";
 353         public static String Plantae_STR_Family = "Family";
 354         public static String Plantae_STR_Subfamily = "Subfamily";
 355         public static String Plantae_STR_Tribe  = "Tribe";
 356         public static String Plantae_STR_Subtribe = "Subtribe";
 357         public static String Plantae_STR_Genus = "Genus";
 358         public static String Plantae_STR_Subgenus = "Subgenus";
 359         public static String Plantae_STR_Section = "Section";
 360         public static String Plantae_STR_Subsection = "Subsection";
 361         public static String Plantae_STR_Series = "Series";
 362         public static String Plantae_STR_Subseries      = "Subseries";
 363         public static String Plantae_STR_Aggregate      = "Aggregate";
 364         public static String Plantae_STR_Coll_Species = "Coll. Species";
 365         public static String Plantae_STR_Species = "Species";
 366         public static String Plantae_STR_Grex = "Grex";
 367         public static String Plantae_STR_Subspecies = "Subspecies";
 368         public static String Plantae_STR_Proles = "Proles";
 369         public static String Plantae_STR_Race = "Race";
 370         public static String Plantae_STR_Convarietas = "Convariety";
 371         public static String Plantae_STR_Variety = "Variety";
 372         public static String Plantae_STR_Subvariety = "Subvariety";
 373         public static String Plantae_STR_Forma  = "Forma";
 374         public static String Plantae_STR_Subforma = "Subforma";
 375         public static String Plantae_STR_Forma_spec = "Forma spec.";
 376         public static String Plantae_STR_Taxa_infragen = "Tax. infragen.";
 377         public static String Plantae_STR_Taxa_infraspec = "Tax. infraspec.";
 378
 379         // Plantae Rank Abbreviations
 380         public static String Plantae_Abbrev_Kingdom = "reg.";
 381         public static String Plantae_Abbrev_Subkingdom = "subreg.";
 382         public static String Plantae_Abbrev_Division = "div.";
 383         public static String Plantae_Abbrev_Subdivision = "subdiv.";
 384         public static String Plantae_Abbrev_Class = "cl.";
 385         public static String Plantae_Abbrev_Subclass = "subcl.";
 386         public static String Plantae_Abbrev_Order = "ordo";
 387         public static String Plantae_Abbrev_Suborder = "subor.";
 388         public static String Plantae_Abbrev_Family = "fam.";
 389         public static String Plantae_Abbrev_Subfamily = "subfam.";
 390         public static String Plantae_Abbrev_Tribe       = "trib.";
 391         public static String Plantae_Abbrev_Subtribe = "subtrib.";
 392         public static String Plantae_Abbrev_Genus = "gen.";
 393         public static String Plantae_Abbrev_Subgenus = "subg.";
 394         public static String Plantae_Abbrev_Section = "sect.";
 395         public static String Plantae_Abbrev_Subsection = "subsect.";
 396         public static String Plantae_Abbrev_Series = "ser.";
 397         public static String Plantae_Abbrev_Subseries   = "subser.";
 398         public static String Plantae_Abbrev_Aggregate   = "aggr.";
 399         public static String Plantae_Abbrev_Coll_Species = "coll. sp.";
 400         public static String Plantae_Abbrev_Species = "sp.";
 401         public static String Plantae_Abbrev_Grex = "grex";
 402         public static String Plantae_Abbrev_Subspecies = "subsp.";
 403         public static String Plantae_Abbrev_Proles = "prol.";
 404         public static String Plantae_Abbrev_Race = "race";
 405         public static String Plantae_Abbrev_Convarietas = "convar.";
 406         public static String Plantae_Abbrev_Variety = "var.";
 407         public static String Plantae_Abbrev_Subvariety = "subvar.";
 408         public static String Plantae_Abbrev_Forma       = "f.";
 409         public static String Plantae_Abbrev_Subforma = "subf.";
 410         public static String Plantae_Abbrev_Forma_spec = "f.spec.";
 411         public static String Plantae_Abbrev_Taxa_infragen = "t.infgen.";
 412         public static String Plantae_Abbrev_Taxa_infraspec = "t.infr.";
 413
 414         // Fungi Ranks
 415         public static int Fungi_Kingdom = 10;
 416         public static int Fungi_Subkingdom = 20;
 417         public static int Fungi_Division = 30;
 418         public static int Fungi_Subdivision = 40;
 419         public static int Fungi_Class   = 60;
 420         public static int Fungi_Subclass = 70;
 421         public static int Fungi_Order   = 100;
 422         public static int Fungi_Suborder = 110;
 423         public static int Fungi_Family = 140;
 424         public static int Fungi_Subfamily = 150;
 425         public static int Fungi_Tribe = 160;
 426         public static int Fungi_Subtribe = 170;
 427         public static int Fungi_Genus = 180;
 428         public static int Fungi_Subgenus = 190;
 429         public static int Fungi_Section = 200;
 430         public static int Fungi_Subsection = 210;
 431         public static int Fungi_Species = 220;
 432         public static int Fungi_Subspecies = 230;
 433         public static int Fungi_Variety = 240;
 434         public static int Fungi_Subvariety = 250;
 435         public static int Fungi_Forma   = 260;
 436         public static int Fungi_Subforma = 270;
 437
 438         //Protozoa Ranks
 439         public static int Protozoa_Kingdom = 10;
 440         public static int Protozoa_Subkingdom = 20;
 441         public static int Protozoa_Phylum = 30;
 442         public static int Protozoa_Subphylum = 40;
 443         public static int Protozoa_Superclass = 50;
 444         public static int Protozoa_Class        = 60;
 445         public static int Protozoa_Subclass = 70;
 446         public static int Protozoa_Infraclass = 80;
 447         public static int Protozoa_Superorder = 90;
 448         public static int Protozoa_Order        = 100;
 449         public static int Protozoa_Suborder = 110;
 450         public static int Protozoa_Infraorder = 120;
 451         public static int Protozoa_Superfamily = 130;
 452         public static int Protozoa_Family = 140;
 453         public static int Protozoa_Subfamily = 150;
 454         public static int Protozoa_Tribe        = 160;
 455         public static int Protozoa_Subtribe = 170;
 456         public static int Protozoa_Genus        = 180;
 457         public static int Protozoa_Subgenus = 190;
 458         public static int Protozoa_Species = 220;
 459         public static int Protozoa_Subspecies = 230;
 460         public static int Protozoa_Variety = 240;
 461         public static int Protozoa_Forma        = 260;
 462
 463         // Bacteria Ranks
 464         public static int Bacteria_Kingdom = 10;
 465         public static int Bacteria_Subkingdom = 20;
 466         public static int Bacteria_Phylum = 30;
 467         public static int Bacteria_Subphylum    = 40;
 468         public static int Bacteria_Superclass = 50;
 469         public static int Bacteria_Class        = 60;
 470         public static int Bacteria_Subclass = 70;
 471         public static int Bacteria_Infraclass = 80;
 472         public static int Bacteria_Superorder = 90;
 473         public static int Bacteria_Order        = 100;
 474         public static int Bacteria_Suborder = 110;
 475         public static int Bacteria_Infraorder = 120;
 476         public static int Bacteria_Superfamily = 130;
 477         public static int Bacteria_Family = 140;
 478         public static int Bacteria_Subfamily    = 150;
 479         public static int Bacteria_Tribe        = 160;
 480         public static int Bacteria_Subtribe = 170;
 481         public static int Bacteria_Genus        = 180;
 482         public static int Bacteria_Subgenus = 190;
 483         public static int Bacteria_Species = 220;
 484         public static int Bacteria_Subspecies = 230;
 485         public static int Bacteria_Variety = 240;
 486         public static int Bacteria_Forma        = 260;
 487
 488         public static String Bacteria_STR_Kingdom = "Kingdom";
 489         public static String Bacteria_STR_Subkingdom = "Subkingdom";
 490         public static String Bacteria_STR_Phylum = "Phylum";
 491         public static String Bacteria_STR_Subphylum = "Subphylum";
 492         public static String Bacteria_STR_Superclass = "Superclass";
 493         public static String Bacteria_STR_Class = "Class";
 494         public static String Bacteria_STR_Subclass = "Subclass";
 495         public static String Bacteria_STR_Infraclass = "Infraclass";
 496         public static String Bacteria_STR_Superorder = "Superorder";
 497         public static String Bacteria_STR_Order = "Order";
 498         public static String Bacteria_STR_Suborder = "Suborder";
 499         public static String Bacteria_STR_Infraorder = "Infraorder";
 500         public static String Bacteria_STR_Superfamily = "Superfamily";
 501         public static String Bacteria_STR_Family = "Family";
 502         public static String Bacteria_STR_Subfamily = "Subfamily";
 503         public static String Bacteria_STR_Tribe = "Tribe";
 504         public static String Bacteria_STR_Subtribe = "Subtribe";
 505         public static String Bacteria_STR_Genus = "Genus";
 506         public static String Bacteria_STR_Subgenus = "Subgenus";
 507         public static String Bacteria_STR_Species = "Species";
 508         public static String Bacteria_STR_Subspecies = "Subspecies";
 509         public static String Bacteria_STR_Variety = "Variety";
 510         public static String Bacteria_STR_Forma = "Forma";
 511
 512         // Chromista Ranks
 513         public static int Chromista_Kingdom = 10;
 514         public static int Chromista_Subkingdom = 20;
 515         public static int Chromista_Infrakingdom = 25;
 516         public static int Chromista_Phylum = 30;
 517         public static int Chromista_Subphylum = 40;
 518         public static int Chromista_Superclass = 50;
 519         public static int Chromista_Class = 60;
 520         public static int Chromista_Subclass = 70;
 521         public static int Chromista_Infraclass = 80;
 522         public static int Chromista_Superorder = 90;
 523         public static int Chromista_Order = 100;
 524         public static int Chromista_Suborder = 110;
 525         public static int Chromista_Infraorder = 120;
 526         public static int Chromista_Superfamily = 130;
 527         public static int Chromista_Family = 140;
 528         public static int Chromista_Subfamily = 150;
 529         public static int Chromista_Tribe = 160;
 530         public static int Chromista_Subtribe = 170;
 531         public static int Chromista_Genus = 180;
 532         public static int Chromista_Subgenus = 190;
 533         public static int Chromista_Section = 200;
 534         public static int Chromista_Subsection = 210;
 535         public static int Chromista_Species     = 220;
 536         public static int Chromista_Subspecies = 230;
 537         public static int Chromista_Variety     = 240;
 538         public static int Chromista_Subvariety = 250;
 539         public static int Chromista_Forma = 260;
 540
 541         // NoteCategory
 542         public static int NoteCategory_description = 1;
 543         public static int NoteCategory_ecology = 4;
 544         public static int NoteCategory_phenology        = 5;
 545         public static int NoteCategory_general_distribution_euromed = 10;
 546         public static int NoteCategory_general_distribution_world = 11;
 547         public static int NoteCategory_Common_names = 12;
 548         public static int NoteCategory_Occurrence = 13;
 549         public static int NoteCategory_Maps =14;
 550         public static int NoteCategory_Link_to_maps = 20;
 551         public static int NoteCategory_Link_to_images = 21;
 552         public static int NoteCategory_Link_to_taxonomy = 22;
 553         public static int NoteCategory_Link_to_general_information = 23;
 554         public static int NoteCategory_undefined_link = 24;
 555         public static int NoteCategory_Editor_Braces = 249;
 556         public static int NoteCategory_Editor_Brackets = 250;
 557         public static int NoteCategory_Editor_Parenthesis = 251;
 558         public static int NoteCategory_Inedited = 252;
 559         public static int NoteCategory_Comments_on_editing_process = 253;
 560         public static int NoteCategory_Publication_date = 254;
 561         public static int NoteCategory_Morphology = 255;
 562         public static int NoteCategory_Acknowledgments = 257;
 563         public static int NoteCategory_Original_publication = 258;
 564         public static int NoteCategory_Type_locality    = 259;
 565         public static int NoteCategory_Environment = 260;
 566         public static int NoteCategory_Spelling = 261;
 567         public static int NoteCategory_Systematics = 262;
 568         public static int NoteCategory_Remark = 263;
 569         public static int NoteCategory_Date_of_publication = 264;
 570         public static int NoteCategory_Additional_information = 266;
 571         public static int NoteCategory_Status = 267;
 572         public static int NoteCategory_Nomenclature = 268;
 573         public static int NoteCategory_Homonymy = 269;
 574         public static int NoteCategory_Taxonomy = 270;
 575         public static int NoteCategory_Taxonomic_status = 272;
 576         public static int NoteCategory_Authority        = 273;
 577         public static int NoteCategory_Identification = 274;
 578         public static int NoteCategory_Validity = 275;
 579         public static int NoteCategory_Classification = 276;
 580         public static int NoteCategory_Distribution = 278;
 581         public static int NoteCategory_Synonymy = 279;
 582         public static int NoteCategory_Habitat = 280;
 583         public static int NoteCategory_Biology = 281;
 584         public static int NoteCategory_Diagnosis        = 282;
 585         public static int NoteCategory_Host = 283;
 586         public static int NoteCategory_Note = 284;
 587         public static int NoteCategory_Rank = 285;
 588         public static int NoteCategory_Taxonomic_Remark = 286;
 589         public static int NoteCategory_Taxonomic_Remarks = 287;
 590
 591
 592         public static String NoteCategory_STR_description = "description";
 593         public static String NoteCategory_STR_ecology = "ecology";
 594         public static String NoteCategory_STR_phenology = "phenology";
 595         public static String NoteCategory_STR_general_distribution_euromed = "general distribution (Euro+Med)";
 596         public static String NoteCategory_STR_general_distribution_world = "general distribution (world)";
 597         public static String NoteCategory_STR_Common_names = "Common names";
 598         public static String NoteCategory_STR_Occurrence = "Occurrence";
 599         public static String NoteCategory_STR_Maps = "Maps";
 600         public static String NoteCategory_STR_Link_to_maps = "Link to maps";
 601         public static String NoteCategory_STR_Link_to_images = "Link to images";
 602         public static String NoteCategory_STR_Link_to_taxonomy = "Link to taxonomy";
 603         public static String NoteCategory_STR_Link_to_general_information = "Link to general information";
 604         public static String NoteCategory_STR_undefined_link = "undefined link";
 605         public static String NoteCategory_STR_Editor_Braces = "Editor_Braces";
 606         public static String NoteCategory_STR_Editor_Brackets = "Editor_Brackets";
 607         public static String NoteCategory_STR_Editor_Parenthesis = "Editor_Parenthesis";
 608         public static String NoteCategory_STR_Inedited = "Inedited";
 609         public static String NoteCategory_STR_Comments_on_editing_process = "Comments on editing process";
 610         public static String NoteCategory_STR_Publication_date = "Publication date";
 611         public static String NoteCategory_STR_Morphology = "Morphology";
 612         public static String NoteCategory_STR_Acknowledgments = "Acknowledgments";
 613         public static String NoteCategory_STR_Original_publication = "Original publication";
 614         public static String NoteCategory_STR_Type_locality     = "Type locality";
 615         public static String NoteCategory_STR_Environment = "Environment";
 616         public static String NoteCategory_STR_Spelling = "Spelling";
 617         public static String NoteCategory_STR_Systematics = "Systematics";
 618         public static String NoteCategory_STR_Remark = "Remark";
 619         public static String NoteCategory_STR_Date_of_publication = "Date of publication";
 620         public static String NoteCategory_STR_Additional_information = "Additional information";
 621         public static String NoteCategory_STR_Status = "Status";
 622         public static String NoteCategory_STR_Nomenclature = "Nomenclature";
 623         public static String NoteCategory_STR_Homonymy = "Homonymy";
 624         public static String NoteCategory_STR_Taxonomy = "Taxonomy";
 625         public static String NoteCategory_STR_Taxonomic_status = "Taxonomic status";
 626         public static String NoteCategory_STR_Authority = "Authority";
 627         public static String NoteCategory_STR_Identification = "Identification";
 628         public static String NoteCategory_STR_Validity = "Validity";
 629         public static String NoteCategory_STR_Classification = "Classification";
 630         public static String NoteCategory_STR_Distribution = "Distribution";
 631         public static String NoteCategory_STR_Synonymy = "Synonymy";
 632         public static String NoteCategory_STR_Habitat = "Habitat";
 633         public static String NoteCategory_STR_Biology = "Biology";
 634         public static String NoteCategory_STR_Diagnosis = "Diagnosis";
 635         public static String NoteCategory_STR_Host = "Host";
 636         public static String NoteCategory_STR_Note = "Note";
 637         public static String NoteCategory_STR_Rank = "Rank";
 638         public static String NoteCategory_STR_Taxonomic_Remark = "Taxonomic Remark";
 639         public static String NoteCategory_STR_Taxonomic_Remarks = "Taxonomic Remarks";
 640
 641
 642         // Language
 643         public static int Language_Albanian = 1;
 644         public static int Language_Arabic = 2;
 645         public static int Language_Armenian = 3;
 646         public static int Language_Azerbaijan = 4;
 647         public static int Language_Belarusian = 5;
 648         public static int Language_Bulgarian = 6;
 649         public static int Language_Catalan = 7;
 650         public static int Language_Croat = 8;
 651         public static int Language_Czech = 9;
 652         public static int Language_Danish = 10;
 653         public static int Language_Dutch = 11;
 654         public static int Language_English = 12;
 655         public static int Language_Euskera = 13;
 656         public static int Language_Estonian = 14;
 657         public static int Language_Finnish = 15;
 658         public static int Language_French = 16;
 659         public static int Language_Georgian = 17;
 660         public static int Language_German = 18;
 661         public static int Language_Greek = 19;
 662         public static int Language_Hungarian = 20;
 663         public static int Language_Icelandic = 21;
 664         public static int Language_Irish_Gaelic = 22;
 665         public static int Language_Israel_Hebrew = 23;
 666         public static int Language_Italian = 24;
 667         public static int Language_Latvian = 25;
 668         public static int Language_Lithuanian = 26;
 669         public static int Language_Macedonian = 27;
 670         public static int Language_Maltese = 28;
 671         public static int Language_Moldovian = 29;
 672         public static int Language_Norwegian = 30;
 673         public static int Language_Polish = 31;
 674         public static int Language_Portuguese = 32;
 675         public static int Language_Roumanian = 33;
 676         public static int Language_Russian = 34;
 677         public static int Language_Russian_Caucasian = 35;
 678         public static int Language_Russian_Altaic_kalmyk_oirat = 36;
 679         public static int Language_Russian_Altaic_karachay_balkar = 37;
 680         public static int Language_Russian_Altaic_kumyk = 38;
 681         public static int Language_Russian_Altaic_nogai = 39;
 682         public static int Language_Russian_Altaic_north_azerbaijani = 40;
 683         public static int Language_Russian_Indo_european_russian = 41;
 684         public static int Language_Russian_Indo_european_kalmyk_oirat = 42;
 685         public static int Language_Russian_Indo_european_osetin = 43;
 686         public static int Language_Russian_North_caucasian_abaza = 44;
 687         public static int Language_Russian_North_caucasian_adyghe = 45;
 688         public static int Language_Russian_North_caucasian_chechen = 46;
 689         public static int Language_Russian_North_caucasian_kabardian = 47;
 690         public static int Language_Russian_North_caucasian_lak = 48;
 691         public static int Language_Russian_North_caucasian_avar = 49;
 692         public static int Language_Russian_North_caucasian_in = 50;
 693         public static int Language_Russian_Uralic_chuvash = 51;
 694         public static int Language_Russian_Uralic_udmurt = 52;
 695         public static int Language_Serbian = 53;
 696         public static int Language_Slovak = 54;
 697         public static int Language_Slovene = 55;
 698         public static int Language_Spanish_Castillian = 56;
 699         public static int Language_Swedish = 57;
 700         public static int Language_Turkish = 58;
 701         public static int Language_Ukraine = 59;
 702         public static int Language_Welsh = 60;
 703         public static int Language_Corsican = 61;
 704
 705         public static String STR_LANGUAGE_ALBANIAN = "Albanian";
 706         public static String STR_LANGUAGE_ARABIC = "Arabic";
 707         public static String STR_LANGUAGE_ARMENIAN = "Armenian";
 708         public static String STR_LANGUAGE_AZERBAIJAN = "Azerbaijan";
 709         public static String STR_LANGUAGE_BELARUSIAN = "Belarusian";
 710         public static String STR_LANGUAGE_BULGARIAN = "Bulgarian";
 711         public static String STR_LANGUAGE_CATALAN = "Catalan";
 712         public static String STR_LANGUAGE_CROAT = "Croat";
 713         public static String STR_LANGUAGE_CZECH = "Czech";
 714         public static String STR_LANGUAGE_DANISH = "Danish";
 715         public static String STR_LANGUAGE_DUTCH = "Dutch";
 716         public static String STR_LANGUAGE_ENGLISH = "English";
 717         public static String STR_LANGUAGE_EUSKERA = "Euskera";
 718         public static String STR_LANGUAGE_ESTONIAN = "Estonian";
 719         public static String STR_LANGUAGE_FINNISH = "Finnish";
 720         public static String STR_LANGUAGE_FRENCH = "French";
 721         public static String STR_LANGUAGE_GEORGIAN = "Georgian";
 722         public static String STR_LANGUAGE_GERMAN = "German";
 723         public static String STR_LANGUAGE_GREEK = "Greek";
 724         public static String STR_LANGUAGE_HUNGARIAN = "Hungarian";
 725         public static String STR_LANGUAGE_ICELANDIC = "Icelandic";
 726         public static String STR_LANGUAGE_IRISH_GAELIC = "Irish Gaelic";
 727         public static String STR_LANGUAGE_ISRAEL_HEBREW = "Israel (Hebrew)";
 728         public static String STR_LANGUAGE_ITALIAN = "Italian";
 729         public static String STR_LANGUAGE_LATVIAN = "Latvian";
 730         public static String STR_LANGUAGE_LITHUANIAN = "Lithuanian";
 731         public static String STR_LANGUAGE_MACEDONIAN = "Macedonian";
 732         public static String STR_LANGUAGE_MALTESE = "Maltese";
 733         public static String STR_LANGUAGE_MOLDOVIAN = "Moldovian";
 734         public static String STR_LANGUAGE_NORWEGIAN = "Norwegian";
 735         public static String STR_LANGUAGE_POLISH = "Polish";
 736         public static String STR_LANGUAGE_PORTUGUESE = "Portuguese";
 737         public static String STR_LANGUAGE_ROUMANIAN = "Roumanian";
 738         public static String STR_LANGUAGE_RUSSIAN = "Russian";
 739         public static String STR_LANGUAGE_RUSSIAN_CAUCASIAN = "Russian Caucasian";
 740         public static String STR_LANGUAGE_RUSSIAN_ALTAIC_KALMYK_OIRAT = "Russian (Altaic, kalmyk-oirat)";
 741         public static String STR_LANGUAGE_RUSSIAN_ALTAIC_KARACHAY_BALKAR = "Russian (Altaic, karachay-balkar)";
 742         public static String STR_LANGUAGE_RUSSIAN_ALTAIC_KUMYK = "Russian (Altaic, kumyk)";
 743         public static String STR_LANGUAGE_RUSSIAN_ALTAIC_NOGAI = "Russian (Altaic, nogai)";
 744         public static String STR_LANGUAGE_RUSSIAN_ALTAIC_NORTH_AZERBAIJANI = "Russian (Altaic, north azerbaijani)";
 745         public static String STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_RUSSIAN = "Russian (Indo-european, russian)";
 746         public static String STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_KALMYK_OIRAT = "Russian (Indo-european, kalmyk-oirat)";
 747         public static String STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_OSETIN = "Russian (Indo-european, osetin)";
 748         public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_ABAZA = "Russian (North caucasian, abaza)";
 749         public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_ADYGHE = "Russian (North caucasian, adyghe)";
 750         public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_CHECHEN = "Russian (North caucasian, chechen)";
 751         public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_KABARDIAN = "Russian (North caucasian, kabardian)";
 752         public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_LAK = "Russian (North caucasian, lak)";
 753         public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_AVAR = "Russian (North caucasian, avar)";
 754         public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_IN = "Russian (North caucasian, in)";
 755         public static String STR_LANGUAGE_RUSSIAN_URALIC_CHUVASH = "Russian (Uralic, chuvash)";
 756         public static String STR_LANGUAGE_RUSSIAN_URALIC_UDMURT = "Russian (Uralic, udmurt)";
 757         public static String STR_LANGUAGE_SERBIAN = "Serbian";
 758         public static String STR_LANGUAGE_SLOVAK = "Slovak";
 759         public static String STR_LANGUAGE_SLOVENE = "Slovene";
 760         public static String STR_LANGUAGE_SPANISH_CASTILLIAN = "Spanish, Castillian";
 761         public static String STR_LANGUAGE_SWEDISH = "Swedish";
 762         public static String STR_LANGUAGE_TURKISH = "Turkish";
 763         public static String STR_LANGUAGE_UKRAINE = "Ukraine";
 764         public static String STR_LANGUAGE_WELSH = "Welsh";
 765         public static String STR_LANGUAGE_CORSICAN = "Corsican";
 766
 767
 768         // FossilStatus
 769         public static int FOSSILSTATUS_RECENT_ONLY = 1;
 770         public static int FOSSILSTATUS_FOSSIL_ONLY = 2;
 771         public static int FOSSILSTATUS_RECENT_FOSSIL = 3;
 772
 773         public static String STR_RECENT_ONLY = "recent only";
 774         public static String STR_FOSSIL_ONLY = "fossil only";
 775         public static String STR_RECENT_FOSSIL = "recent + fossil";
 776
 777         // SourceUse
 778         public static int ORIGINAL_DESCRIPTION = 1;
 779         public static int BASIS_OF_RECORD = 2;
 780         public static int ADDITIONAL_SOURCE = 3;
 781         public static int SOURCE_OF_SYNONYMY = 4;
 782         public static int REDESCRIPTION = 5;
 783         public static int NEW_COMBINATION_REFERENCE = 6;
 784         public static int STATUS_SOURCE = 7;
 785         public static int NOMENCLATURAL_REFERENCE = 8;
 786
 787         public static String STR_ORIGINAL_DESCRIPTION = "original description";
 788         public static String STR_BASIS_OF_RECORD = "basis of record";
 789         public static String STR_ADDITIONAL_SOURCE = "additional source";
 790         public static String STR_SOURCE_OF_SYNONYMY = "source of synonymy";
 791         public static String STR_REDESCRIPTION = "redescription";
 792         public static String STR_NEW_COMBINATION_REFERENCE = "new combination reference";
 793         public static String STR_STATUS_SOURCE = "status source";
 794         public static String STR_NOMENCLATURAL_REFERENCE = "nomenclatural reference";
 795
 796         // Area
 797         public static int AREA_EAST_AEGEAN_ISLANDS = 1;
 798         public static int AREA_GREEK_EAST_AEGEAN_ISLANDS = 2;
 799         public static int AREA_TURKISH_EAST_AEGEAN_ISLANDS = 3;
 800         public static int AREA_ALBANIA = 4;
 801         public static int AREA_AUSTRIA_WITH_LIECHTENSTEIN = 5;
 802         public static int AREA_AUSTRIA = 6;
 803         public static int AREA_LIECHTENSTEIN = 7;
 804         public static int AREA_AZORES = 8;
 805         public static int AREA_CORVO = 9;
 806         public static int AREA_FAIAL = 10;
 807         public static int AREA_GRACIOSA = 11;
 808         public static int AREA_SAO_JORGE = 12;
 809         public static int AREA_FLORES = 13;
 810         public static int AREA_SAO_MIGUEL = 14;
 811         public static int AREA_PICO = 15;
 812         public static int AREA_SANTA_MARIA = 16;
 813         public static int AREA_TERCEIRA = 17;
 814         public static int AREA_BELGIUM_WITH_LUXEMBOURG = 18;
 815         public static int AREA_BELGIUM = 19;
 816         public static int AREA_LUXEMBOURG = 20;
 817         public static int AREA_BOSNIA_HERZEGOVINA = 21;
 818         public static int AREA_BALEARES = 22;
 819         public static int AREA_IBIZA_WITH_FORMENTERA = 23;
 820         public static int AREA_MALLORCA = 24;
 821         public static int AREA_MENORCA = 25;
 822         public static int AREA_GREAT_BRITAIN = 26;
 823         public static int AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION = 27;
 824         public static int AREA_BULGARIA = 28;
 825         public static int AREA_BELARUS = 29;
 826         public static int AREA_CANARY_ISLANDS = 30;
 827         public static int AREA_GRAN_CANARIA = 31;
 828         public static int AREA_FUERTEVENTURA_WITH_LOBOS = 32;
 829         public static int AREA_GOMERA = 33;
 830         public static int AREA_HIERRO = 34;
 831         public static int AREA_LANZAROTE_WITH_GRACIOSA = 35;
 832         public static int AREA_LA_PALMA = 36;
 833         public static int AREA_TENERIFE = 37;
 834         public static int AREA_MONTENEGRO = 38;
 835         public static int AREA_CORSE = 39;
 836         public static int AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS = 40;
 837         public static int AREA_CZECH_REPUBLIC = 41;
 838         public static int AREA_CROATIA = 42;
 839         public static int AREA_CYPRUS = 43;
 840         public static int AREA_FORMER_CZECHOSLOVAKIA = 44;
 841         public static int AREA_DENMARK_WITH_BORNHOLM = 45;
 842         public static int AREA_ESTONIA = 46;
 843         public static int AREA_FAROE_ISLANDS = 47;
 844         public static int AREA_FINLAND_WITH_AHVENANMAA = 48;
 845         public static int AREA_FRANCE = 49;
 846         public static int AREA_CHANNEL_ISLANDS = 50;
 847         public static int AREA_FRENCH_MAINLAND = 51;
 848         public static int AREA_MONACO = 52;
 849         public static int AREA_GERMANY = 53;
 850         public static int AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS = 54;
 851         public static int AREA_IRELAND = 55;
 852         public static int AREA_REPUBLIC_OF_IRELAND = 56;
 853         public static int AREA_NORTHERN_IRELAND = 57;
 854         public static int AREA_SWITZERLAND = 58;
 855         public static int AREA_NETHERLANDS = 59;
 856         public static int AREA_SPAIN = 60;
 857         public static int AREA_ANDORRA = 61;
 858         public static int AREA_GIBRALTAR = 62;
 859         public static int AREA_KINGDOM_OF_SPAIN = 63;
 860         public static int AREA_HUNGARY = 64;
 861         public static int AREA_ICELAND = 65;
 862         public static int AREA_ITALY = 66;
 863         public static int AREA_ITALIAN_MAINLAND = 67;
 864         public static int AREA_SAN_MARINO = 68;
 865         public static int AREA_FORMER_JUGOSLAVIA = 69;
 866         public static int AREA_LATVIA = 70;
 867         public static int AREA_LITHUANIA = 71;
 868         public static int AREA_PORTUGUESE_MAINLAND = 72;
 869         public static int AREA_MADEIRA_ARCHIPELAGO = 73;
 870         public static int AREA_DESERTAS = 74;
 871         public static int AREA_MADEIRA = 75;
 872         public static int AREA_PORTO_SANTO = 76;
 873         public static int AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA = 77;
 874         public static int AREA_MOLDOVA = 78;
 875         public static int AREA_NORWEGIAN_MAINLAND = 79;
 876         public static int AREA_POLAND = 80;
 877         public static int AREA_THE_RUSSIAN_FEDERATION = 81;
 878         public static int AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND = 82;
 879         public static int AREA_CENTRAL_EUROPEAN_RUSSIA = 83;
 880         public static int AREA_EASTERN_EUROPEAN_RUSSIA = 84;
 881         public static int AREA_KALININGRAD = 85;
 882         public static int AREA_NORTHERN_EUROPEAN_RUSSIA = 86;
 883         public static int AREA_NORTHWEST_EUROPEAN_RUSSIA = 87;
 884         public static int AREA_SOUTH_EUROPEAN_RUSSIA = 88;
 885         public static int AREA_ROMANIA = 89;
 886         public static int AREA_FORMER_USSR = 90;
 887         public static int AREA_RUSSIA_BALTIC = 91;
 888         public static int AREA_RUSSIA_CENTRAL = 92;
 889         public static int AREA_RUSSIA_SOUTHEAST = 93;
 890         public static int AREA_RUSSIA_NORTHERN = 94;
 891         public static int AREA_RUSSIA_SOUTHWEST = 95;
 892         public static int AREA_SARDEGNA = 96;
 893         public static int AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN = 97;
 894         public static int AREA_SELVAGENS_ISLANDS = 98;
 895         public static int AREA_SICILY_WITH_MALTA = 99;
 896         public static int AREA_MALTA = 100;
 897         public static int AREA_SICILY = 101;
 898         public static int AREA_SLOVAKIA = 102;
 899         public static int AREA_SLOVENIA = 103;
 900         public static int AREA_SERBIA_WITH_MONTENEGRO = 104;
 901         public static int AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO = 105;
 902         public static int AREA_SWEDEN = 106;
 903         public static int AREA_EUROPEAN_TURKEY = 107;
 904         public static int AREA_UKRAINE_INCLUDING_CRIMEA = 108;
 905         public static int AREA_CRIMEA = 109;
 906         public static int AREA_UKRAINE = 110;
 907         public static int AREA_GREEK_MAINLAND = 111;
 908         public static int AREA_CRETE = 112;
 909         public static int AREA_DODECANESE_ISLANDS = 113;
 910         public static int AREA_CYCLADES_ISLANDS = 114;
 911         public static int AREA_NORTH_AEGEAN_ISLANDS = 115;
 912         public static int AREA_VATICAN_CITY = 116;
 913         public static int AREA_FRANZ_JOSEF_LAND = 117;
 914         public static int AREA_NOVAYA_ZEMLYA = 118;
 915         public static int AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN = 119;
 916         public static int AREA_AZERBAIJAN = 120;
 917         public static int AREA_NAKHICHEVAN = 121;
 918         public static int AREA_ALGERIA = 122;
 919         public static int AREA_ARMENIA = 123;
 920         public static int AREA_CAUCASUS_REGION = 124;
 921         public static int AREA_EGYPT = 125;
 922         public static int AREA_GEORGIA = 126;
 923         public static int AREA_ISRAEL_JORDAN = 127;
 924         public static int AREA_ISRAEL = 128;
 925         public static int AREA_JORDAN = 129;
 926         public static int AREA_LEBANON = 130;
 927         public static int AREA_LIBYA = 131;
 928         public static int AREA_LEBANON_SYRIA = 132;
 929         public static int AREA_MOROCCO = 133;
 930         public static int AREA_NORTH_CAUCASUS = 134;
 931         public static int AREA_SINAI = 135;
 932         public static int AREA_SYRIA = 136;
 933         public static int AREA_TUNISIA = 137;
 934         public static int AREA_ASIATIC_TURKEY = 138;
 935         public static int AREA_TURKEY = 139;
 936         public static int AREA_NORTHERN_AFRICA = 140;
 937         public static int AREA_AFRO_TROPICAL_REGION = 141;
 938         public static int AREA_AUSTRALIAN_REGION = 142;
 939         public static int AREA_EAST_PALAEARCTIC = 143;
 940         public static int AREA_NEARCTIC_REGION = 144;
 941         public static int AREA_NEOTROPICAL_REGION = 145;
 942         public static int AREA_NEAR_EAST = 146;
 943         public static int AREA_ORIENTAL_REGION = 147;
 944         public static int AREA_EUROPEAN_MARINE_WATERS = 148;
 945         public static int AREA_MEDITERRANEAN_SEA = 149;
 946         public static int AREA_WHITE_SEA = 150;
 947         public static int AREA_NORTH_SEA = 151;
 948         public static int AREA_BALTIC_SEA = 152;
 949         public static int AREA_BLACK_SEA = 153;
 950         public static int AREA_BARENTS_SEA = 154;
 951         public static int AREA_CASPIAN_SEA = 155;
 952         public static int AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE = 156;
 953         public static int AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE = 157;
 954         public static int AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE = 158;
 955         public static int AREA_ENGLISH_CHANNEL = 159;
 956         public static int AREA_ADRIATIC_SEA = 160;
 957         public static int AREA_BISCAY_BAY = 161;
 958         public static int AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE = 162;
 959         public static int AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE = 163;
 960         public static int AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE = 164;
 961         public static int AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE = 165;
 962         public static int AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE = 166;
 963         public static int AREA_TIRRENO_SEA = 167;
 964         public static int AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE = 168;
 965         public static int AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE = 169;
 966         public static int AREA_IRISH_SEA = 170;
 967         public static int AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE = 171;
 968         public static int AREA_NORWEGIAN_SEA = 172;
 969         public static int AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE = 173;
 970         public static int AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE = 174;
 971         public static int AREA_SKAGERRAK = 175;
 972         public static int AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE = 176;
 973         public static int AREA_WADDEN_SEA = 177;
 974         public static int AREA_BELT_SEA = 178;
 975         public static int AREA_MARMARA_SEA = 179;
 976         public static int AREA_SEA_OF_AZOV = 180;
 977         public static int AREA_AEGEAN_SEA = 181;
 978         public static int AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE = 182;
 979         public static int AREA_SOUTH_BALTIC_PROPER = 183;
 980         public static int AREA_BALTIC_PROPER = 184;
 981         public static int AREA_NORTH_BALTIC_PROPER = 185;
 982         public static int AREA_ARCHIPELAGO_SEA = 186;
 983         public static int AREA_BOTHNIAN_SEA = 187;
 984         public static int AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE = 188;
 985         public static int AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE = 189;
 986         public static int AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE = 190;
 987         public static int AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE = 191;
 988         public static int AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE = 192;
 989         public static int AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART = 193;
 990         public static int AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE = 194;
 991         public static int AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE = 195;
 992         public static int AREA_BALEAR_SEA = 196;
 993         public static int AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE = 197;
 994         public static int AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE = 198;
 995         public static int AREA_TRANSCAUCASUS = 199;
 996
 997
 998         public static String STR_AREA_EAST_AEGEAN_ISLANDS = "East Aegean Islands";
 999         public static String STR_AREA_GREEK_EAST_AEGEAN_ISLANDS = "Greek East Aegean Islands";
1000         public static String STR_AREA_TURKISH_EAST_AEGEAN_ISLANDS = "Turkish East Aegean Islands";
1001         public static String STR_AREA_ALBANIA = "Albania";
1002         public static String STR_AREA_AUSTRIA_WITH_LIECHTENSTEIN = "Austria with Liechtenstein";
1003         public static String STR_AREA_AUSTRIA = "Austria";
1004         public static String STR_AREA_LIECHTENSTEIN = "Liechtenstein";
1005         public static String STR_AREA_AZORES = "Azores";
1006         public static String STR_AREA_CORVO = "Corvo";
1007         public static String STR_AREA_FAIAL = "Faial";
1008         public static String STR_AREA_GRACIOSA = "Graciosa";
1009         public static String STR_AREA_SAO_JORGE = "São Jorge";
1010         public static String STR_AREA_FLORES = "Flores";
1011         public static String STR_AREA_SAO_MIGUEL = "São Miguel";
1012         public static String STR_AREA_PICO = "Pico";
1013         public static String STR_AREA_SANTA_MARIA = "Santa Maria";
1014         public static String STR_AREA_TERCEIRA = "Terceira";
1015         public static String STR_AREA_BELGIUM_WITH_LUXEMBOURG = "Belgium with Luxembourg";
1016         public static String STR_AREA_BELGIUM = "Belgium";
1017         public static String STR_AREA_LUXEMBOURG = "Luxembourg";
1018         public static String STR_AREA_BOSNIA_HERZEGOVINA = "Bosnia-Herzegovina";
1019         public static String STR_AREA_BALEARES = "Baleares";
1020         public static String STR_AREA_IBIZA_WITH_FORMENTERA = "Ibiza with Formentera";
1021         public static String STR_AREA_MALLORCA = "Mallorca";
1022         public static String STR_AREA_MENORCA = "Menorca";
1023         public static String STR_AREA_GREAT_BRITAIN = "Great Britain";
1024         public static String STR_AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION = "Baltic states (Estonia, Latvia, Lithuania) and Kaliningrad region";
1025         public static String STR_AREA_BULGARIA = "Bulgaria";
1026         public static String STR_AREA_BELARUS = "Belarus";
1027         public static String STR_AREA_CANARY_ISLANDS = "Canary Islands";
1028         public static String STR_AREA_GRAN_CANARIA = "Gran Canaria";
1029         public static String STR_AREA_FUERTEVENTURA_WITH_LOBOS = "Fuerteventura with Lobos";
1030         public static String STR_AREA_GOMERA = "Gomera";
1031         public static String STR_AREA_HIERRO = "Hierro";
1032         public static String STR_AREA_LANZAROTE_WITH_GRACIOSA = "Lanzarote with Graciosa";
1033         public static String STR_AREA_LA_PALMA = "La Palma";
1034         public static String STR_AREA_TENERIFE = "Tenerife";
1035         public static String STR_AREA_MONTENEGRO = "Montenegro";
1036         public static String STR_AREA_CORSE = "Corse";
1037         public static String STR_AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS = "Crete with Karpathos, Kasos & Gavdhos";
1038         public static String STR_AREA_CZECH_REPUBLIC = "Czech Republic";
1039         public static String STR_AREA_CROATIA = "Croatia";
1040         public static String STR_AREA_CYPRUS = "Cyprus";
1041         public static String STR_AREA_FORMER_CZECHOSLOVAKIA = "Former Czechoslovakia";
1042         public static String STR_AREA_DENMARK_WITH_BORNHOLM = "Denmark with Bornholm";
1043         public static String STR_AREA_ESTONIA = "Estonia";
1044         public static String STR_AREA_FAROE_ISLANDS = "Faroe Islands";
1045         public static String STR_AREA_FINLAND_WITH_AHVENANMAA = "Finland with Ahvenanmaa";
1046         public static String STR_AREA_FRANCE = "France";
1047         public static String STR_AREA_CHANNEL_ISLANDS = "Channel Islands";
1048         public static String STR_AREA_FRENCH_MAINLAND = "French mainland";
1049         public static String STR_AREA_MONACO = "Monaco";
1050         public static String STR_AREA_GERMANY = "Germany";
1051         public static String STR_AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS = "Greece with Cyclades and more islands";
1052         public static String STR_AREA_IRELAND = "Ireland";
1053         public static String STR_AREA_REPUBLIC_OF_IRELAND = "Republic of Ireland";
1054         public static String STR_AREA_NORTHERN_IRELAND = "Northern Ireland";
1055         public static String STR_AREA_SWITZERLAND = "Switzerland";
1056         public static String STR_AREA_NETHERLANDS = "Netherlands";
1057         public static String STR_AREA_SPAIN = "Spain";
1058         public static String STR_AREA_ANDORRA = "Andorra";
1059         public static String STR_AREA_GIBRALTAR = "Gibraltar";
1060         public static String STR_AREA_KINGDOM_OF_SPAIN = "Kingdom of Spain";
1061         public static String STR_AREA_HUNGARY = "Hungary";
1062         public static String STR_AREA_ICELAND = "Iceland";
1063         public static String STR_AREA_ITALY = "Italy";
1064         public static String STR_AREA_ITALIAN_MAINLAND = "Italian mainland";
1065         public static String STR_AREA_SAN_MARINO = "San Marino";
1066         public static String STR_AREA_FORMER_JUGOSLAVIA = "Former Jugoslavia";
1067         public static String STR_AREA_LATVIA = "Latvia";
1068         public static String STR_AREA_LITHUANIA = "Lithuania";
1069         public static String STR_AREA_PORTUGUESE_MAINLAND = "Portuguese mainland";
1070         public static String STR_AREA_MADEIRA_ARCHIPELAGO = "Madeira";
1071         public static String STR_AREA_DESERTAS = "Desertas";
1072         public static String STR_AREA_MADEIRA = "Madeira";
1073         public static String STR_AREA_PORTO_SANTO = "Porto Santo";
1074         public static String STR_AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA = "The former Jugoslav Republic of Makedonija";
1075         public static String STR_AREA_MOLDOVA = "Moldova";
1076         public static String STR_AREA_NORWEGIAN_MAINLAND = "Norwegian mainland";
1077         public static String STR_AREA_POLAND = "Poland";
1078         public static String STR_AREA_THE_RUSSIAN_FEDERATION = "The Russian Federation";
1079         public static String STR_AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND = "Novaya Zemlya & Franz-Joseph Land";
1080         public static String STR_AREA_CENTRAL_EUROPEAN_RUSSIA = "Central European Russia";
1081         public static String STR_AREA_EASTERN_EUROPEAN_RUSSIA = "Eastern European Russia";
1082         public static String STR_AREA_KALININGRAD = "Kaliningrad";
1083         public static String STR_AREA_NORTHERN_EUROPEAN_RUSSIA = "Northern European Russia";
1084         public static String STR_AREA_NORTHWEST_EUROPEAN_RUSSIA = "Northwest European Russia";
1085         public static String STR_AREA_SOUTH_EUROPEAN_RUSSIA = "South European Russia";
1086         public static String STR_AREA_ROMANIA = "Romania";
1087         public static String STR_AREA_FORMER_USSR = "Former USSR";
1088         public static String STR_AREA_RUSSIA_BALTIC = "Russia Baltic";
1089         public static String STR_AREA_RUSSIA_CENTRAL = "Russia Central";
1090         public static String STR_AREA_RUSSIA_SOUTHEAST = "Russia Southeast";
1091         public static String STR_AREA_RUSSIA_NORTHERN = "Russia Northern";
1092         public static String STR_AREA_RUSSIA_SOUTHWEST = "Russia Southwest";
1093         public static String STR_AREA_SARDEGNA = "Sardegna";
1094         public static String STR_AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN = "Svalbard with Björnöya and Jan Mayen";
1095         public static String STR_AREA_SELVAGENS_ISLANDS = "Selvagens Islands";
1096         public static String STR_AREA_SICILY_WITH_MALTA = "Sicily with Malta";
1097         public static String STR_AREA_MALTA = "Malta";
1098         public static String STR_AREA_SICILY = "Sicily";
1099         public static String STR_AREA_SLOVAKIA = "Slovakia";
1100         public static String STR_AREA_SLOVENIA = "Slovenia";
1101         public static String STR_AREA_SERBIA_WITH_MONTENEGRO = "Serbia with Montenegro";
1102         public static String STR_AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO = "Serbia including Vojvodina and with Kosovo";
1103         public static String STR_AREA_SWEDEN = "Sweden";
1104         public static String STR_AREA_EUROPEAN_TURKEY = "European Turkey";
1105         public static String STR_AREA_UKRAINE_INCLUDING_CRIMEA = "Ukraine including Crimea";
1106         public static String STR_AREA_CRIMEA = "Crimea";
1107         public static String STR_AREA_UKRAINE = "Ukraine";
1108         public static String STR_AREA_GREEK_MAINLAND = "Greek mainland";
1109         public static String STR_AREA_CRETE = "Crete";
1110         public static String STR_AREA_DODECANESE_ISLANDS = "Dodecanese Islands";
1111         public static String STR_AREA_CYCLADES_ISLANDS = "Cyclades Islands";
1112         public static String STR_AREA_NORTH_AEGEAN_ISLANDS = "North Aegean Islands";
1113         public static String STR_AREA_VATICAN_CITY = "Vatican City";
1114         public static String STR_AREA_FRANZ_JOSEF_LAND = "Franz Josef Land";
1115         public static String STR_AREA_NOVAYA_ZEMLYA = "Novaya Zemlya";
1116         public static String STR_AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN = "Azerbaijan including Nakhichevan";
1117         public static String STR_AREA_AZERBAIJAN = "Azerbaijan";
1118         public static String STR_AREA_NAKHICHEVAN = "Nakhichevan";
1119         public static String STR_AREA_ALGERIA = "Algeria";
1120         public static String STR_AREA_ARMENIA = "Armenia";
1121         public static String STR_AREA_CAUCASUS_REGION = "Caucasus region";
1122         public static String STR_AREA_EGYPT = "Egypt";
1123         public static String STR_AREA_GEORGIA = "Georgia";
1124         public static String STR_AREA_ISRAEL_JORDAN = "Israel-Jordan";
1125         public static String STR_AREA_ISRAEL = "Israel";
1126         public static String STR_AREA_JORDAN = "Jordan";
1127         public static String STR_AREA_LEBANON = "Lebanon";
1128         public static String STR_AREA_LIBYA = "Libya";
1129         public static String STR_AREA_LEBANON_SYRIA = "Lebanon-Syria";
1130         public static String STR_AREA_MOROCCO = "Morocco";
1131         public static String STR_AREA_NORTH_CAUCASUS = "North Caucasus";
1132         public static String STR_AREA_SINAI = "Sinai";
1133         public static String STR_AREA_SYRIA = "Syria";
1134         public static String STR_AREA_TUNISIA = "Tunisia";
1135         public static String STR_AREA_ASIATIC_TURKEY = "Asiatic Turkey";
1136         public static String STR_AREA_TURKEY = "Turkey";
1137         public static String STR_AREA_NORTHERN_AFRICA = "Northern Africa";
1138         public static String STR_AREA_AFRO_TROPICAL_REGION = "Afro-tropical region";
1139         public static String STR_AREA_AUSTRALIAN_REGION = "Australian region";
1140         public static String STR_AREA_EAST_PALAEARCTIC = "East Palaearctic";
1141         public static String STR_AREA_NEARCTIC_REGION = "Nearctic region";
1142         public static String STR_AREA_NEOTROPICAL_REGION = "Neotropical region";
1143         public static String STR_AREA_NEAR_EAST = "Near East";
1144         public static String STR_AREA_ORIENTAL_REGION = "Oriental region";
1145         public static String STR_AREA_EUROPEAN_MARINE_WATERS = "European Marine Waters";
1146         public static String STR_AREA_MEDITERRANEAN_SEA = "Mediterranean Sea";
1147         public static String STR_AREA_WHITE_SEA = "White Sea";
1148         public static String STR_AREA_NORTH_SEA = "North Sea";
1149         public static String STR_AREA_BALTIC_SEA = "Baltic Sea";
1150         public static String STR_AREA_BLACK_SEA = "Black Sea";
1151         public static String STR_AREA_BARENTS_SEA = "Barents Sea";
1152         public static String STR_AREA_CASPIAN_SEA = "Caspian Sea";
1153         public static String STR_AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE = "Portuguese Exclusive Economic Zone";
1154         public static String STR_AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE = "Belgian Exclusive Economic Zone";
1155         public static String STR_AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE = "French Exclusive Economic Zone";
1156         public static String STR_AREA_ENGLISH_CHANNEL = "English Channel";
1157         public static String STR_AREA_ADRIATIC_SEA = "Adriatic Sea";
1158         public static String STR_AREA_BISCAY_BAY = "Biscay Bay";
1159         public static String STR_AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE = "Dutch Exclusive Economic Zone";
1160         public static String STR_AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE = "United Kingdom Exclusive Economic Zone";
1161         public static String STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE = "Spanish Exclusive Economic Zone";
1162         public static String STR_AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE = "Egyptian Exclusive Economic Zone";
1163         public static String STR_AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE = "Grecian Exclusive Economic Zone";
1164         public static String STR_AREA_TIRRENO_SEA = "Tirreno Sea";
1165         public static String STR_AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE = "Icelandic Exclusive Economic Zone";
1166         public static String STR_AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE = "Irish Exclusive economic Zone";
1167         public static String STR_AREA_IRISH_SEA = "Irish Sea";
1168         public static String STR_AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE = "Italian Exclusive Economic Zone";
1169         public static String STR_AREA_NORWEGIAN_SEA = "Norwegian Sea";
1170         public static String STR_AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE = "Moroccan Exclusive Economic Zone";
1171         public static String STR_AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE = "Norwegian Exclusive Economic Zone";
1172         public static String STR_AREA_SKAGERRAK = "Skagerrak";
1173         public static String STR_AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE = "Tunisian Exclusive Economic Zone";
1174         public static String STR_AREA_WADDEN_SEA = "Wadden Sea";
1175         public static String STR_AREA_BELT_SEA = "Belt Sea";
1176         public static String STR_AREA_MARMARA_SEA = "Marmara Sea";
1177         public static String STR_AREA_SEA_OF_AZOV = "Sea of Azov";
1178         public static String STR_AREA_AEGEAN_SEA = "Aegean Sea";
1179         public static String STR_AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE = "Bulgarian Exclusive Economic Zone";
1180         public static String STR_AREA_SOUTH_BALTIC_PROPER = "South Baltic proper";
1181         public static String STR_AREA_BALTIC_PROPER = "Baltic Proper";
1182         public static String STR_AREA_NORTH_BALTIC_PROPER = "North Baltic proper";
1183         public static String STR_AREA_ARCHIPELAGO_SEA = "Archipelago Sea";
1184         public static String STR_AREA_BOTHNIAN_SEA = "Bothnian Sea";
1185         public static String STR_AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE = "German Exclusive Economic Zone";
1186         public static String STR_AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE = "Swedish Exclusive Economic Zone";
1187         public static String STR_AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE = "Ukrainian Exclusive Economic Zone";
1188         public static String STR_AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE = "Madeiran Exclusive Economic Zone";
1189         public static String STR_AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE = "Lebanese Exclusive Economic Zone";
1190         public static String STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART = "Spanish Exclusive Economic Zone [Mediterranean part]";
1191         public static String STR_AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE = "Estonian Exclusive Economic Zone";
1192         public static String STR_AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE = "Croatian Exclusive Economic Zone";
1193         public static String STR_AREA_BALEAR_SEA = "Balear Sea";
1194         public static String STR_AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE = "Turkish Exclusive Economic Zone";
1195         public static String STR_AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE = "Danish Exclusive Economic Zone";
1196         public static String STR_AREA_TRANSCAUCASUS = "Transcaucasus";
1197
1198
1199
1200         // OccurrenceStatus
1201         public static int STATUS_PRESENT = 1;
1202         public static int STATUS_ABSENT = 2;
1203         public static int STATUS_NATIVE = 3;
1204         public static int STATUS_INTRODUCED = 4;
1205         public static int STATUS_NATURALISED = 5;
1206         public static int STATUS_INVASIVE = 6;
1207         public static int STATUS_MANAGED = 7;
1208         public static int STATUS_DOUBTFUL = 8;
1209
1210         public static String STR_STATUS_PRESENT = "Present";
1211         public static String STR_STATUS_ABSENT = "Absent";
1212         public static String STR_STATUS_NATIVE = "Native";
1213         public static String STR_STATUS_INTRODUCED = "Introduced";
1214         public static String STR_STATUS_NATURALISED = "Naturalised";
1215         public static String STR_STATUS_INVASIVE = "Invasive";
1216         public static String STR_STATUS_MANAGED = "Managed";
1217         public static String STR_STATUS_DOUBTFUL = "Doubtful";
1218
1219         private Map<String, Integer> tdwgKeyMap = new HashMap<String, Integer>();
1220         private Map<String, String> tdwgLabelMap = new HashMap<String, String>();
1221         private Map<Integer, String> nameStatusCacheMap  = new HashMap<Integer, String>();
1222         private Map<Integer, String> qualityStatusCacheMap  = new HashMap<Integer, String>();
1223         private Map<Integer, String> taxRelQualifierCacheMap  = new HashMap<Integer, String>();
1224         private Map<Integer, String> taxRelZooQualifierCacheMap  = new HashMap<Integer, String>();
1225
1226
1227         private Source destination;
1228
1229         public PesiTransformer(Source destination) {
1230                 super();
1231                 this.destination = destination;
1232                 fillMaps();
1233         }
1234
1235         private void fillMaps() {
1236                 //TDWG
1237                 try {
1238                         String sql = " SELECT AreaId, AreaName, AreaTdwgCode, AreaEmCode, AreaFaEuCode FROM Area";
1239                         ResultSet rs = destination.getResultSet(sql);
1240                         while (rs.next()){
1241                                 String tdwg = rs.getString("AreaTdwgCode");
1242                                 Integer id = rs.getInt("AreaId");
1243                                 String label = rs.getString("AreaName");
1244
1245                                 if (StringUtils.isNotBlank(tdwg)){
1246                                         this.tdwgKeyMap.put(tdwg, id);
1247                                         this.tdwgLabelMap.put(tdwg, label);
1248                                 }
1249                         }
1250                         //nameStatusCache
1251                         sql = " SELECT NomStatusId, NomStatus FROM NameStatus ";
1252                         rs = destination.getResultSet(sql);
1253                         while (rs.next()){
1254                                 Integer key = rs.getInt("NomStatusId");
1255                                 String cache = rs.getString("NomStatus");
1256                                 if (StringUtils.isNotBlank(cache)){
1257                                         this.nameStatusCacheMap.put(key, cache);
1258                                 }
1259                         }
1260                         //qualityStatusCache
1261                         sql = " SELECT QualityStatusId,QualityStatus FROM QualityStatus ";
1262                         rs = destination.getResultSet(sql);
1263                         while (rs.next()){
1264                                 Integer key = rs.getInt("QualityStatusId");
1265                                 String cache = rs.getString("QualityStatus");
1266                                 if (StringUtils.isNotBlank(cache)){
1267                                         this.qualityStatusCacheMap.put(key, cache);
1268                                 }
1269                         }
1270                         //qualityStatusCache
1271                         sql = " SELECT QualifierId, Qualifier, ZoologQualifier FROM RelTaxonQualifier ";
1272                         rs = destination.getResultSet(sql);
1273                         while (rs.next()){
1274                                 Integer key = rs.getInt("QualifierId");
1275                                 String cache = rs.getString("Qualifier");
1276                                 if (StringUtils.isNotBlank(cache)){
1277                                         this.taxRelQualifierCacheMap.put(key, cache);
1278                                 }
1279                                 String zoologCache = rs.getString("ZoologQualifier");
1280                                 if (StringUtils.isNotBlank(zoologCache)){
1281                                         this.taxRelZooQualifierCacheMap.put(key, zoologCache);
1282                                 }
1283                         }
1284
1285
1286
1287                 } catch (SQLException e) {
1288                         logger.error("SQLException when trying to read area map", e);
1289                         e.printStackTrace();
1290                 }
1291
1292         }
1293
1294         /**
1295          * Converts the databaseString to its abbreviation if its known.
1296          * Otherwise the databaseString is returned.
1297          * @param databaseString
1298          * @return
1299          */
1300         public static String databaseString2Abbreviation(String databaseString) {
1301                 String result = databaseString;
1302                 if (databaseString.equals("Fauna Europaea database")) {
1303                         result = "FaEu";
1304                 }
1305                 return result;
1306         }
1307
1308         /**
1309          * Returns the OccurrenceStatusId for a given PresenceAbsenceTerm.
1310          * @param term
1311          * @return
1312          * @throws UnknownCdmTypeException
1313          */
1314         public static String presenceAbsenceTerm2OccurrenceStatusCache(PresenceAbsenceTermBase<?> term) {
1315                 String result = null;
1316                 if (term == null){
1317                         return null;
1318                 //present
1319                 }else if (term.isInstanceOf(PresenceTerm.class)) {
1320                         PresenceTerm presenceTerm = CdmBase.deproxy(term, PresenceTerm.class);
1321                         if (presenceTerm.equals(PresenceTerm.PRESENT()) ||
1322                                         presenceTerm.equals(PresenceTerm.INTRODUCED_DOUBTFULLY_INTRODUCED()) ||
1323                                         presenceTerm.equals(PresenceTerm.NATIVE_DOUBTFULLY_NATIVE())) {
1324                                 result = STR_STATUS_PRESENT;
1325                         } else if (presenceTerm.equals(PresenceTerm.NATIVE())) {
1326                                 result = STR_STATUS_NATIVE;
1327                         } else if (presenceTerm.equals(PresenceTerm.INTRODUCED()) ||
1328                                         presenceTerm.equals(PresenceTerm.INTRODUCED_ADVENTITIOUS()) ||
1329                                         presenceTerm.equals(PresenceTerm.INTRODUCED_UNCERTAIN_DEGREE_OF_NATURALISATION())) {
1330                                 result = STR_STATUS_INTRODUCED;
1331                         } else if (presenceTerm.equals(PresenceTerm.NATURALISED())
1332                                         || presenceTerm.equals(PresenceTerm.INTRODUCED_NATURALIZED())) {
1333                                 result = STR_STATUS_NATURALISED;
1334                         } else if (presenceTerm.equals(PresenceTerm.INVASIVE())) {
1335                                 result = STR_STATUS_INVASIVE;
1336                         } else if (presenceTerm.equals(PresenceTerm.CULTIVATED())) {
1337                                 result = STR_STATUS_MANAGED;
1338                         } else if (presenceTerm.equals(PresenceTerm.PRESENT_DOUBTFULLY())||
1339                                         presenceTerm.equals(PresenceTerm.INTRODUCED_PRESENCE_QUESTIONABLE()) ||
1340                                         presenceTerm.equals(PresenceTerm.NATIVE_PRESENCE_QUESTIONABLE() )) {
1341                                 result = STR_STATUS_DOUBTFUL;
1342                         } else {
1343                                 logger.error("PresenceTerm could not be translated to datawarehouse occurrence status id: " + presenceTerm.getLabel());
1344                         }
1345                 //absent
1346                 } else if (term.isInstanceOf(AbsenceTerm.class)) {
1347                         AbsenceTerm absenceTerm = CdmBase.deproxy(term, AbsenceTerm.class);
1348                         if (absenceTerm.equals(AbsenceTerm.ABSENT()) || absenceTerm.equals(AbsenceTerm.NATIVE_FORMERLY_NATIVE()) ||
1349                                         absenceTerm.equals(AbsenceTerm.CULTIVATED_REPORTED_IN_ERROR()) || absenceTerm.equals(AbsenceTerm.INTRODUCED_REPORTED_IN_ERROR()) ||
1350                                         absenceTerm.equals(AbsenceTerm.INTRODUCED_FORMERLY_INTRODUCED()) || absenceTerm.equals(AbsenceTerm.NATIVE_REPORTED_IN_ERROR() ) ) {
1351                                 result = STR_STATUS_ABSENT;
1352                         } else {
1353                                 logger.error("AbsenceTerm could not be translated to datawarehouse occurrence status id: " + absenceTerm.getLabel());
1354                         }
1355                 }
1356                 return result;
1357         }
1358
1359         /**
1360          * Returns the OccurrenceStatusId for a given PresenceAbsenceTerm.
1361          * @param term
1362          * @return
1363          * @throws UnknownCdmTypeException
1364          */
1365         public static Integer presenceAbsenceTerm2OccurrenceStatusId(PresenceAbsenceTermBase<?> term) {
1366                 Integer result = null;
1367                 if (term == null){
1368                         return null;
1369                 //present
1370                 }else if (term.isInstanceOf(PresenceTerm.class)) {
1371                         PresenceTerm presenceTerm = CdmBase.deproxy(term, PresenceTerm.class);
1372                         if (presenceTerm.equals(PresenceTerm.PRESENT()) ||
1373                                         presenceTerm.equals(PresenceTerm.INTRODUCED_DOUBTFULLY_INTRODUCED()) ||
1374                                         presenceTerm.equals(PresenceTerm.NATIVE_DOUBTFULLY_NATIVE())) {
1375                                 result = STATUS_PRESENT;
1376                         } else if (presenceTerm.equals(PresenceTerm.NATIVE())) {
1377                                 result = STATUS_NATIVE;
1378                         } else if (presenceTerm.equals(PresenceTerm.INTRODUCED()) ||
1379                                         presenceTerm.equals(PresenceTerm.INTRODUCED_ADVENTITIOUS()) ||
1380                                         presenceTerm.equals(PresenceTerm.INTRODUCED_UNCERTAIN_DEGREE_OF_NATURALISATION())) {
1381                                 result = STATUS_INTRODUCED;
1382                         } else if (presenceTerm.equals(PresenceTerm.NATURALISED())
1383                                         || presenceTerm.equals(PresenceTerm.INTRODUCED_NATURALIZED())) {
1384                                 result = STATUS_NATURALISED;
1385                         } else if (presenceTerm.equals(PresenceTerm.INVASIVE())) {
1386                                 result = STATUS_INVASIVE;
1387                         } else if (presenceTerm.equals(PresenceTerm.CULTIVATED())) {
1388                                 result = STATUS_MANAGED;
1389                         } else if (presenceTerm.equals(PresenceTerm.PRESENT_DOUBTFULLY())||
1390                                         presenceTerm.equals(PresenceTerm.INTRODUCED_PRESENCE_QUESTIONABLE()) ||
1391                                         presenceTerm.equals(PresenceTerm.NATIVE_PRESENCE_QUESTIONABLE() )) {
1392                                 result = STATUS_DOUBTFUL;
1393                         } else {
1394                                 logger.error("PresenceTerm could not be translated to datawarehouse occurrence status id: " + presenceTerm.getLabel());
1395                         }
1396                 //absent
1397                 } else if (term.isInstanceOf(AbsenceTerm.class)) {
1398                         AbsenceTerm absenceTerm = CdmBase.deproxy(term, AbsenceTerm.class);
1399                         if (absenceTerm.equals(AbsenceTerm.ABSENT()) || absenceTerm.equals(AbsenceTerm.NATIVE_FORMERLY_NATIVE()) ||
1400                                         absenceTerm.equals(AbsenceTerm.CULTIVATED_REPORTED_IN_ERROR()) || absenceTerm.equals(AbsenceTerm.INTRODUCED_REPORTED_IN_ERROR()) ||
1401                                         absenceTerm.equals(AbsenceTerm.INTRODUCED_FORMERLY_INTRODUCED()) || absenceTerm.equals(AbsenceTerm.NATIVE_REPORTED_IN_ERROR() ) ) {
1402                                 result = STATUS_ABSENT;
1403                         } else {
1404                                 logger.error("AbsenceTerm could not be translated to datawarehouse occurrence status id: " + absenceTerm.getLabel());
1405                         }
1406                 }
1407                 return result;
1408         }
1409
1410 //      /**
1411 //       * Returns the AreaCache for a given Area.
1412 //       * @param area
1413 //       * @return
1414 //       */
1415 //      public static String area2AreaCache(NamedArea area) {
1416 //              NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
1417 //              if (area == null) {
1418 //                      return null;
1419 //              } else if (area.isInstanceOf(TdwgArea.class)) {
1420 //
1421 //                      // TODO: Areas identified by the string "TODO" (for now) have to be identified correctly after additions have been made to the list of NamedArea's according to specific imports, i.e. euro+med
1422 //                      if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI")) { return STR_AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1423 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI-OO")) { return STR_AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1424 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1425 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB")) { return STR_AREA_ALBANIA; }
1426 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB-OO")) { return STR_AREA_ALBANIA; }
1427 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT")) { return STR_AREA_AUSTRIA_WITH_LIECHTENSTEIN; }
1428 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-AU")) { return STR_AREA_AUSTRIA; }
1429 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-LI")) { return STR_AREA_LIECHTENSTEIN; }
1430 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO")) { return STR_AREA_AZORES; }
1431 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO-OO")) { return STR_AREA_AZORES; }
1432 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_CORVO; }
1433 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FAIAL; }
1434 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_GRACIOSA; }
1435 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_SAO_JORGE; }
1436 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FLORES; }
1437 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_SAO_MIGUEL; }
1438 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_PICO; }
1439 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_SANTA_MARIA; }
1440 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_TERCEIRA; }
1441 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM")) { return STR_AREA_BELGIUM_WITH_LUXEMBOURG; }
1442 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-BE")) { return STR_AREA_BELGIUM; }
1443 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-LU")) { return STR_AREA_LUXEMBOURG; }
1444 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-BH")) { return STR_AREA_BOSNIA_HERZEGOVINA; }
1445 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL")) { return STR_AREA_BALEARES; }
1446 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL-OO")) { return STR_AREA_BALEARES; }
1447 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_IBIZA_WITH_FORMENTERA; }
1448 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_MALLORCA; }
1449 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_MENORCA; }
1450 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB")) { return STR_AREA_GREAT_BRITAIN; }
1451 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB-OO")) { return STR_AREA_GREAT_BRITAIN; }
1452 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT")) { return STR_AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION; }
1453 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL")) { return STR_AREA_BULGARIA; }
1454 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL-OO")) { return STR_AREA_BULGARIA; }
1455 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR")) { return STR_AREA_BELARUS; }
1456 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR-OO")) { return STR_AREA_BELARUS; }
1457 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY")) { return STR_AREA_CANARY_ISLANDS; }
1458 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY-OO")) { return STR_AREA_CANARY_ISLANDS; }
1459 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_GRAN_CANARIA; }
1460 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FUERTEVENTURA_WITH_LOBOS; }
1461 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_GOMERA; }
1462 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_HIERRO; }
1463 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_LANZAROTE_WITH_GRACIOSA; }
1464 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_LA_PALMA; }
1465 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_TENERIFE; }
1466 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MN")) { return STR_AREA_MONTENEGRO; }
1467 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR")) { return STR_AREA_CORSE; }
1468 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR-OO")) { return STR_AREA_CORSE; }
1469 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI")) { return STR_AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
1470 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI-OO")) { return STR_AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
1471 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-CZ")) { return STR_AREA_CZECH_REPUBLIC; }
1472 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-CR")) { return STR_AREA_CROATIA; }
1473 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP")) { return STR_AREA_CYPRUS; }
1474 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP-OO")) { return STR_AREA_CYPRUS; }
1475 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE")) { return STR_AREA_FORMER_CZECHOSLOVAKIA; }
1476 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN")) { return STR_AREA_DENMARK_WITH_BORNHOLM; }
1477 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN-OO")) { return STR_AREA_DENMARK_WITH_BORNHOLM; }
1478 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-ES")) { return STR_AREA_ESTONIA; }
1479 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR")) { return STR_AREA_FAROE_ISLANDS; }
1480 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR-OO")) { return STR_AREA_FAROE_ISLANDS; }
1481 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN")) { return STR_AREA_FINLAND_WITH_AHVENANMAA; }
1482 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN-OO")) { return STR_AREA_FINLAND_WITH_AHVENANMAA; }
1483 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA")) { return STR_AREA_FRANCE; }
1484 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-CI")) { return STR_AREA_CHANNEL_ISLANDS; }
1485 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-FR")) { return STR_AREA_FRENCH_MAINLAND; }
1486 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-MO")) { return STR_AREA_MONACO; }
1487 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER")) { return STR_AREA_GERMANY; }
1488 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER-OO")) { return STR_AREA_GERMANY; }
1489 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC")) { return STR_AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
1490 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC-OO")) { return STR_AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
1491 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE")) { return STR_AREA_IRELAND; }
1492 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-IR")) { return STR_AREA_REPUBLIC_OF_IRELAND; }
1493 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-NI")) { return STR_AREA_NORTHERN_IRELAND; }
1494 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI")) { return STR_AREA_SWITZERLAND; }
1495 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI-OO")) { return STR_AREA_SWITZERLAND; }
1496 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET")) { return STR_AREA_NETHERLANDS; }
1497 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET-OO")) { return STR_AREA_NETHERLANDS; }
1498 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA")) { return STR_AREA_SPAIN; }
1499 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-AN")) { return STR_AREA_ANDORRA; }
1500 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-GI")) { return STR_AREA_GIBRALTAR; }
1501 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-SP")) { return STR_AREA_KINGDOM_OF_SPAIN; }
1502 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN")) { return STR_AREA_HUNGARY; }
1503 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN-OO")) { return STR_AREA_HUNGARY; }
1504 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE")) { return STR_AREA_ICELAND; }
1505 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE-OO")) { return STR_AREA_ICELAND; }
1506 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA")) { return STR_AREA_ITALY; }
1507 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-IT")) { return STR_AREA_ITALIAN_MAINLAND; }
1508 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-SM")) { return STR_AREA_SAN_MARINO; }
1509 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG")) { return STR_AREA_FORMER_JUGOSLAVIA; }
1510 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LA")) { return STR_AREA_LATVIA; }
1511 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LI")) { return STR_AREA_LITHUANIA; }
1512 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR")) { return STR_AREA_PORTUGUESE_MAINLAND; }
1513 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR-OO")) { return STR_AREA_PORTUGUESE_MAINLAND; }
1514 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR")) { return STR_AREA_MADEIRA_ARCHIPELAGO; }
1515 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR-OO")) { return STR_AREA_MADEIRA_ARCHIPELAGO; }
1516 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MA")) { return STR_AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA; }
1517 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-MO")) { return STR_AREA_MOLDOVA; }
1518 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR")) { return STR_AREA_NORWEGIAN_MAINLAND; }
1519 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR-OO")) { return STR_AREA_NORWEGIAN_MAINLAND; }
1520 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL")) { return STR_AREA_POLAND; }
1521 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL-OO")) { return STR_AREA_POLAND; }
1522 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return STR_AREA_THE_RUSSIAN_FEDERATION; }
1523 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB")) { return STR_AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
1524 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB-OO")) { return STR_AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
1525 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC")) { return STR_AREA_CENTRAL_EUROPEAN_RUSSIA; }
1526 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC-OO")) { return STR_AREA_CENTRAL_EUROPEAN_RUSSIA; }
1527 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE")) { return STR_AREA_EASTERN_EUROPEAN_RUSSIA; }
1528 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE-OO")) { return STR_AREA_EASTERN_EUROPEAN_RUSSIA; }
1529 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-KA")) { return STR_AREA_KALININGRAD; }
1530 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN")) { return STR_AREA_NORTHERN_EUROPEAN_RUSSIA; }
1531 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN-OO")) { return STR_AREA_NORTHERN_EUROPEAN_RUSSIA; }
1532 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW")) { return STR_AREA_NORTHWEST_EUROPEAN_RUSSIA; }
1533 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW-OO")) { return STR_AREA_NORTHWEST_EUROPEAN_RUSSIA; }
1534 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return STR_AREA_SOUTH_EUROPEAN_RUSSIA; }
1535 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS-OO")) { return STR_AREA_SOUTH_EUROPEAN_RUSSIA; }
1536 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM")) { return STR_AREA_ROMANIA; }
1537 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM-OO")) { return STR_AREA_ROMANIA; }
1538 //
1539 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR")) { return STR_AREA_SARDEGNA; }
1540 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR-OO")) { return STR_AREA_SARDEGNA; }
1541 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA")) { return STR_AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
1542 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA-OO")) { return STR_AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
1543 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL")) { return STR_AREA_SELVAGENS_ISLANDS; }
1544 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL-OO")) { return STR_AREA_SELVAGENS_ISLANDS; }
1545 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC")) { return STR_AREA_SICILY_WITH_MALTA; }
1546 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-MA")) { return STR_AREA_MALTA; }
1547 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-SI")) { return STR_AREA_SICILY; }
1548 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-SK")) { return STR_AREA_SLOVAKIA; }
1549 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SL")) { return STR_AREA_SLOVENIA; }
1550 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CS")) { return STR_AREA_SERBIA_WITH_MONTENEGRO; }
1551 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SE")) { return STR_AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
1552 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE")) { return STR_AREA_SWEDEN; }
1553 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE-OO")) { return STR_AREA_SWEDEN; }
1554 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE")) { return STR_AREA_EUROPEAN_TURKEY; }
1555 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE-OO")) { return STR_AREA_EUROPEAN_TURKEY; }
1556 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY")) { return STR_AREA_CRIMEA; }
1557 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY-OO")) { return STR_AREA_CRIMEA; }
1558 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-UK")) { return STR_AREA_UKRAINE; }
1559 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRE")) { return STR_AREA_GREEK_MAINLAND; }
1560 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-KRI")) { return STR_AREA_CRETE; }
1561 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-DOD")) { return STR_AREA_DODECANESE_ISLANDS; }
1562 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-CYC")) { return STR_AREA_CYCLADES_ISLANDS; }
1563 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-AEG")) { return STR_AREA_NORTH_AEGEAN_ISLANDS; }
1564 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-VC")) { return STR_AREA_VATICAN_CITY; }
1565 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FRANZ_JOSEF_LAND; }
1566 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_NOVAYA_ZEMLYA; }
1567 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AZ")) { return STR_AREA_AZERBAIJAN; }
1568 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-NA")) { return STR_AREA_NAKHICHEVAN; }
1569 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG")) { return STR_AREA_ALGERIA; }
1570 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG-OO")) { return STR_AREA_ALGERIA; }
1571 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AR")) { return STR_AREA_ARMENIA; }
1572 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("33")) { return STR_AREA_CAUCASUS_REGION; }
1573 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY")) { return STR_AREA_EGYPT; }
1574 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY-OO")) { return STR_AREA_EGYPT; }
1575 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL")) { return STR_AREA_ISRAEL_JORDAN; }
1576 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-IS")) { return STR_AREA_ISRAEL; }
1577 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-JO")) { return STR_AREA_JORDAN; }
1578 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-LB")) { return STR_AREA_LEBANON; }
1579 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBY-OO")) { return STR_AREA_LIBYA; }
1580 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS")) { return STR_AREA_LEBANON_SYRIA; }
1581 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MOR")) { return STR_AREA_MOROCCO; }
1582 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NCS")) { return STR_AREA_NORTH_CAUCASUS; }
1583 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN")) { return STR_AREA_SINAI; }
1584 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN-OO")) { return STR_AREA_SINAI; }
1585 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-SY")) { return STR_AREA_SYRIA; }
1586 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN")) { return STR_AREA_TUNISIA; }
1587 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN-OO")) { return STR_AREA_TUNISIA; }
1588 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUR-OO")) { return STR_AREA_ASIATIC_TURKEY; }
1589 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("20")) { return STR_AREA_NORTHERN_AFRICA; }
1590 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AFR")) { return STR_AREA_AFRO_TROPICAL_REGION; }
1591 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUS")) { return STR_AREA_AUSTRALIAN_REGION; }
1592 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_EAST_PALAEARCTIC; }
1593 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEA")) { return STR_AREA_NEARCTIC_REGION; }
1594 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEO")) { return STR_AREA_NEOTROPICAL_REGION; }
1595 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NRE")) { return STR_AREA_NEAR_EAST; }
1596 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ORR")) { return STR_AREA_ORIENTAL_REGION; }
1597 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS")) { return STR_AREA_TRANSCAUCASUS; }
1598 //
1599 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return STR_AREA_EUROPEAN_MARINE_WATERS; }
1600 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||
1601 //                                      (namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return STR_AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
1602 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return STR_AREA_WHITE_SEA; }
1603 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return STR_AREA_NORTH_SEA; }
1604 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return STR_AREA_BALTIC_SEA; }
1605 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||
1606 //                                      (namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return STR_AREA_BLACK_SEA; } // abbreviated label missing
1607 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return STR_AREA_BARENTS_SEA; }
1608 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
1609 //                                      (namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return STR_AREA_CASPIAN_SEA; } // abbreviated label missing
1610 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return STR_AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1611 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return STR_AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1612 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return STR_AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
1613 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return STR_AREA_ENGLISH_CHANNEL; }
1614 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return STR_AREA_ADRIATIC_SEA; }
1615 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return STR_AREA_BISCAY_BAY; }
1616 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return STR_AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
1617 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return STR_AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
1618 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1619 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return STR_AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1620 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return STR_AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1621 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return STR_AREA_TIRRENO_SEA; }
1622 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return STR_AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
1623 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return STR_AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
1624 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return STR_AREA_IRISH_SEA; }
1625 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return STR_AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1626 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return STR_AREA_NORWEGIAN_SEA; }
1627 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return STR_AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
1628 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return STR_AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1629 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return STR_AREA_SKAGERRAK; }
1630 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return STR_AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1631 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return STR_AREA_WADDEN_SEA; }
1632 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return STR_AREA_BELT_SEA; }
1633 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return STR_AREA_MARMARA_SEA; }
1634 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return STR_AREA_SEA_OF_AZOV; }
1635 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return STR_AREA_AEGEAN_SEA; }
1636 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return STR_AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1637 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return STR_AREA_SOUTH_BALTIC_PROPER; }
1638 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return STR_AREA_BALTIC_PROPER; }
1639 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return STR_AREA_NORTH_BALTIC_PROPER; }
1640 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return STR_AREA_ARCHIPELAGO_SEA; }
1641 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return STR_AREA_BOTHNIAN_SEA; }
1642 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return STR_AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
1643 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return STR_AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
1644 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return STR_AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1645 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return STR_AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
1646 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return STR_AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
1647 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
1648 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return STR_AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1649 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return STR_AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1650 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return STR_AREA_BALEAR_SEA; }
1651 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return STR_AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
1652 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return STR_AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1653 //                      else {
1654 //                              logger.error("Unknown NamedArea Area: " + area.getTitleCache());
1655 //                      }
1656 //              }else if (namedArea.isInstanceOf(WaterbodyOrCountry.class)){
1657 //                      if ((namedArea.equals(WaterbodyOrCountry.UKRAINE()))) { return STR_AREA_UKRAINE_INCLUDING_CRIMEA; }
1658 //                      else if (namedArea.equals(WaterbodyOrCountry.AZERBAIJANREPUBLICOF())) { return STR_AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1659 //                      else if (namedArea.equals(WaterbodyOrCountry.GEORGIA())) { return STR_AREA_GEORGIA; }
1660 //                      else {
1661 //                              logger.warn("Unknown NamedArea Area: " + area.getTitleCache());
1662 //                      }
1663 //              }else {
1664 //                      if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidMadeira))){ return STR_AREA_MADEIRA; }
1665 //                      else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidDesertas))) { return STR_AREA_DESERTAS; }
1666 //                      else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidPortoSanto))) { return STR_AREA_PORTO_SANTO; }
1667 //                      else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaBaltic))) { return STR_AREA_RUSSIA_BALTIC; }
1668 //                      else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthEast))) { return STR_AREA_RUSSIA_SOUTHEAST; }
1669 //                      else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthWest))) { return STR_AREA_RUSSIA_SOUTHWEST; }
1670 //                      else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidUssr))) { return STR_AREA_FORMER_USSR; }
1671 //                      else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaCentral))) { return STR_AREA_RUSSIA_CENTRAL; }
1672 //                      else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaNorthern))) { return STR_AREA_RUSSIA_NORTHERN; }
1673 //                      else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkey))) { return STR_AREA_TURKEY; }
1674 //                      else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidEastAegeanIslands))) { return STR_AREA_EAST_AEGEAN_ISLANDS; }
1675 //
1676 //                      else {
1677 //                              logger.warn("Unknown NamedArea Area: " + area.getTitleCache());
1678 //                      }
1679 //              }
1680 //              return null; // Actually the export has to stop here because AreaFk's are not allowed to be NULL.
1681 //      }
1682
1683         @Override
1684         public String getCacheByPresenceAbsenceTerm(PresenceAbsenceTermBase status) throws UndefinedTransformerMethodException {
1685                 return presenceAbsenceTerm2OccurrenceStatusCache(status);
1686         }
1687
1688         @Override
1689         public Object getKeyByPresenceAbsenceTerm(PresenceAbsenceTermBase status) throws UndefinedTransformerMethodException {
1690                 return presenceAbsenceTerm2OccurrenceStatusId(status);
1691         }
1692
1693
1694
1695         @Override
1696         public String getCacheByNamedArea(NamedArea area) throws UndefinedTransformerMethodException {
1697                 NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
1698
1699                 if (namedArea == null) {
1700                         return null;
1701                 //TDWG areas
1702                 } else if (namedArea.isInstanceOf(TdwgArea.class)) {
1703                         String abbrevLabel = namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel();
1704                         String result = this.tdwgLabelMap.get(abbrevLabel);
1705                         if (result == null){
1706                                 logger.warn("Unknown TDWGArea: " + namedArea.getTitleCache());
1707                         }
1708                         return result;
1709                 //countries & Waterbodies
1710                 }else if (namedArea.isInstanceOf(WaterbodyOrCountry.class)){
1711                         if (namedArea.equals(WaterbodyOrCountry.UKRAINE())) { return STR_AREA_UKRAINE_INCLUDING_CRIMEA; }
1712                         else if (namedArea.equals(WaterbodyOrCountry.AZERBAIJANREPUBLICOF())) { return STR_AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1713                         else if (namedArea.equals(WaterbodyOrCountry.GEORGIA())) { return STR_AREA_GEORGIA; }
1714                         else if (namedArea.equals(WaterbodyOrCountry.RUSSIANFEDERATION())) { return STR_AREA_THE_RUSSIAN_FEDERATION; }
1715                         else {
1716                                 logger.warn("Unknown Waterbody/Country: " + namedArea.getTitleCache());
1717                         }
1718                 }else{  //Non TDWG, non country
1719                         //E+M
1720                         if ( namedArea.getUuid().equals(BerlinModelTransformer.uuidMadeira)){ return STR_AREA_MADEIRA; }
1721                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidDesertas)) { return STR_AREA_DESERTAS; }
1722                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPortoSanto)) { return STR_AREA_PORTO_SANTO; }
1723
1724                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUssr)) { return STR_AREA_FORMER_USSR; }
1725                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaBaltic)) { return STR_AREA_RUSSIA_BALTIC; }
1726                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthEast)) { return STR_AREA_RUSSIA_SOUTHEAST; }
1727                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthWest)) { return STR_AREA_RUSSIA_SOUTHWEST; }
1728                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaCentral)) { return STR_AREA_RUSSIA_CENTRAL; }
1729                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaNorthern)) { return STR_AREA_RUSSIA_NORTHERN; }
1730
1731                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkey)) { return STR_AREA_TURKEY; }
1732                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEastAegeanIslands)) { return STR_AREA_EAST_AEGEAN_ISLANDS; }
1733                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFlores)) { return STR_AREA_FLORES; }
1734                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkishEastAegeanIslands)) { return STR_AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1735                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSerbiaMontenegro)) { return STR_AREA_SERBIA_WITH_MONTENEGRO; }
1736                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSerbia)) { return STR_AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
1737                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCaucasia)) { return STR_AREA_CAUCASUS_REGION; }
1738
1739
1740                         //FE
1741                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaAFR)) { return STR_AREA_AFRO_TROPICAL_REGION; }
1742                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaAUS)) { return STR_AREA_AUSTRALIAN_REGION; }
1743                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaEPA)) { return STR_AREA_EAST_PALAEARCTIC; }
1744                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_AEG)) { return STR_AREA_NORTH_AEGEAN_ISLANDS; }
1745                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_CYC)) { return STR_AREA_CYCLADES_ISLANDS; }
1746                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_DOD)) { return STR_AREA_DODECANESE_ISLANDS; }
1747                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNAF)) { return STR_AREA_NORTHERN_AFRICA; }
1748                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNEA)) { return STR_AREA_NEARCTIC_REGION; }
1749                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNEO)) { return STR_AREA_NEOTROPICAL_REGION; }
1750                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNRE)) { return STR_AREA_NEAR_EAST; }
1751                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaORR)) { return STR_AREA_ORIENTAL_REGION; }
1752
1753
1754                         //ERMS
1755                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return STR_AREA_EUROPEAN_MARINE_WATERS; }
1756                         else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||
1757                                         (namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return STR_AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
1758                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return STR_AREA_WHITE_SEA; }
1759                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return STR_AREA_NORTH_SEA; }
1760                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return STR_AREA_BALTIC_SEA; }
1761                         else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||
1762                                         (namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return STR_AREA_BLACK_SEA; } // abbreviated label missing
1763                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return STR_AREA_BARENTS_SEA; }
1764                         else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
1765                                         (namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return STR_AREA_CASPIAN_SEA; } // abbreviated label missing
1766                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return STR_AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1767                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return STR_AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1768                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return STR_AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
1769                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return STR_AREA_ENGLISH_CHANNEL; }
1770                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return STR_AREA_ADRIATIC_SEA; }
1771                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return STR_AREA_BISCAY_BAY; }
1772                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return STR_AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
1773                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return STR_AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
1774                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1775                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return STR_AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1776                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return STR_AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1777                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return STR_AREA_TIRRENO_SEA; }
1778                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return STR_AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
1779                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return STR_AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
1780                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return STR_AREA_IRISH_SEA; }
1781                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return STR_AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1782                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return STR_AREA_NORWEGIAN_SEA; }
1783                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return STR_AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
1784                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return STR_AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1785                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return STR_AREA_SKAGERRAK; }
1786                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return STR_AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1787                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return STR_AREA_WADDEN_SEA; }
1788                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return STR_AREA_BELT_SEA; }
1789                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return STR_AREA_MARMARA_SEA; }
1790                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return STR_AREA_SEA_OF_AZOV; }
1791                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return STR_AREA_AEGEAN_SEA; }
1792                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return STR_AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1793                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return STR_AREA_SOUTH_BALTIC_PROPER; }
1794                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return STR_AREA_BALTIC_PROPER; }
1795                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return STR_AREA_NORTH_BALTIC_PROPER; }
1796                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return STR_AREA_ARCHIPELAGO_SEA; }
1797                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return STR_AREA_BOTHNIAN_SEA; }
1798                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return STR_AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
1799                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return STR_AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
1800                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return STR_AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1801                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return STR_AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
1802                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return STR_AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
1803                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
1804                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return STR_AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1805                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return STR_AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1806                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return STR_AREA_BALEAR_SEA; }
1807                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return STR_AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
1808                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return STR_AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1809
1810                         else {
1811                                 logger.warn("Unknown NamedArea Area: " + namedArea.getTitleCache());
1812                         }
1813
1814                 }
1815                 return null;
1816         }
1817
1818
1819         @Override
1820         public Object getKeyByNamedArea(NamedArea area) throws UndefinedTransformerMethodException {
1821                 NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
1822
1823                 if (area == null) {
1824                         return null;
1825                 //TDWG areas
1826                 } else if (area.isInstanceOf(TdwgArea.class)) {
1827                         String abbrevLabel = namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel();
1828                         Integer result = this.tdwgKeyMap.get(abbrevLabel);
1829                         if (result == null){
1830                                 logger.warn("Unknown TDWGArea: " + area.getTitleCache());
1831                         }
1832                         return result;
1833                 //countries & Waterbodies
1834                 }else if (namedArea.isInstanceOf(WaterbodyOrCountry.class)){
1835                         if (namedArea.equals(WaterbodyOrCountry.UKRAINE())) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
1836                         else if (namedArea.equals(WaterbodyOrCountry.AZERBAIJANREPUBLICOF())) { return AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1837                         else if (namedArea.equals(WaterbodyOrCountry.GEORGIA())) { return AREA_GEORGIA; }
1838                         else if (namedArea.equals(WaterbodyOrCountry.RUSSIANFEDERATION())) { return AREA_THE_RUSSIAN_FEDERATION; }
1839                         else {
1840                                 logger.warn("Unknown Waterbody/Country: " + area.getTitleCache());
1841                         }
1842                 }else{  //Non TDWG, non country
1843                         if ( namedArea.getUuid().equals(BerlinModelTransformer.uuidMadeira)){ return AREA_MADEIRA; }
1844                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidDesertas)) { return AREA_DESERTAS; }
1845                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPortoSanto)) { return AREA_PORTO_SANTO; }
1846
1847                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUssr)) { return AREA_FORMER_USSR; }
1848                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaBaltic)) { return AREA_RUSSIA_BALTIC; }
1849                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthEast)) { return AREA_RUSSIA_SOUTHEAST; }
1850                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthWest)) { return AREA_RUSSIA_SOUTHWEST; }
1851                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaCentral)) { return AREA_RUSSIA_CENTRAL; }
1852                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaNorthern)) { return AREA_RUSSIA_NORTHERN; }
1853
1854                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkey)) { return AREA_TURKEY; }
1855                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEastAegeanIslands)) { return AREA_EAST_AEGEAN_ISLANDS; }
1856                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkishEastAegeanIslands)) { return AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1857                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFlores)) { return AREA_FLORES; }
1858                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSerbiaMontenegro)) { return AREA_SERBIA_WITH_MONTENEGRO; }
1859                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSerbia)) { return AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
1860                         else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCaucasia)) { return AREA_CAUCASUS_REGION; }
1861
1862                         //FE
1863                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaAFR)) { return AREA_AFRO_TROPICAL_REGION; }
1864                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaAUS)) { return AREA_AUSTRALIAN_REGION; }
1865                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaEPA)) { return AREA_EAST_PALAEARCTIC; }
1866                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_AEG)) { return AREA_NORTH_AEGEAN_ISLANDS; }
1867                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_CYC)) { return AREA_CYCLADES_ISLANDS; }
1868                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_DOD)) { return AREA_DODECANESE_ISLANDS; }
1869                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNAF)) { return AREA_NORTHERN_AFRICA; }
1870                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNEA)) { return AREA_NEARCTIC_REGION; }
1871                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNEO)) { return AREA_NEOTROPICAL_REGION; }
1872                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNRE)) { return AREA_NEAR_EAST; }
1873                         else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaORR)) { return AREA_ORIENTAL_REGION; }
1874
1875                         //ERMS
1876                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return AREA_EUROPEAN_MARINE_WATERS; }
1877                         else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||
1878                                         (namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
1879                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return AREA_WHITE_SEA; }
1880                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return AREA_NORTH_SEA; }
1881                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return AREA_BALTIC_SEA; }
1882                         else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||
1883                                         (namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return AREA_BLACK_SEA; } // abbreviated label missing
1884                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return AREA_BARENTS_SEA; }
1885                         else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
1886                                         (namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return AREA_CASPIAN_SEA; } // abbreviated label missingelse if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1887                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1888                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
1889                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return AREA_ENGLISH_CHANNEL; }
1890                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return AREA_ADRIATIC_SEA; }
1891                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return AREA_BISCAY_BAY; }
1892                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
1893                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
1894                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1895                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1896                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1897                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return AREA_TIRRENO_SEA; }
1898                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
1899                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
1900                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return AREA_IRISH_SEA; }
1901                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1902                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return AREA_NORWEGIAN_SEA; }
1903                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
1904                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1905                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return AREA_SKAGERRAK; }
1906                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1907                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return AREA_WADDEN_SEA; }
1908                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return AREA_BELT_SEA; }
1909                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return AREA_MARMARA_SEA; }
1910                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return AREA_SEA_OF_AZOV; }
1911                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return AREA_AEGEAN_SEA; }
1912                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1913                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return AREA_SOUTH_BALTIC_PROPER; }
1914                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return AREA_BALTIC_PROPER; }
1915                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return AREA_NORTH_BALTIC_PROPER; }
1916                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return AREA_ARCHIPELAGO_SEA; }
1917                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return AREA_BOTHNIAN_SEA; }
1918                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
1919                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
1920                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1921                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
1922                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
1923                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
1924                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1925                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1926                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return AREA_BALEAR_SEA; }
1927                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
1928                         else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1929
1930
1931                         else {
1932                                 logger.warn("Unknown NamedArea Area: " + area.getTitleCache());
1933                         }
1934
1935                 }
1936                 return null;
1937         }
1938
1939
1940 //      /**
1941 //       * Returns the AreaId for a given Area.
1942 //       * @param area
1943 //       * @return
1944 //       */
1945 //      public static Integer area2AreaId(NamedArea area) {
1946 //              NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
1947 //
1948 //              if (area == null) {
1949 //                      return null;
1950 //              } else if (area.isInstanceOf(TdwgArea.class)) {
1951 //
1952 //                      // TODO: Areas identified by the string "TODO" (for now) have to be identified correctly after additions have been made to the list of NamedArea's according to specific imports, i.e. euro+med
1953 //                      if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI")) { return AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1954 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI-OO")) { return AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1955 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1956 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB")) { return AREA_ALBANIA; }
1957 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB-OO")) { return AREA_ALBANIA; }
1958 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT")) { return AREA_AUSTRIA_WITH_LIECHTENSTEIN; }
1959 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-AU")) { return AREA_AUSTRIA; }
1960 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-LI")) { return AREA_LIECHTENSTEIN; }
1961 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO")) { return AREA_AZORES; }
1962 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO-OO")) { return AREA_AZORES; }
1963 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_CORVO; }
1964 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FAIAL; }
1965 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_GRACIOSA; }
1966 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_SAO_JORGE; }
1967 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FLORES; }
1968 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_SAO_MIGUEL; }
1969 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_PICO; }
1970 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_SANTA_MARIA; }
1971 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_TERCEIRA; }
1972 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM")) { return AREA_BELGIUM_WITH_LUXEMBOURG; }
1973 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-BE")) { return AREA_BELGIUM; }
1974 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-LU")) { return AREA_LUXEMBOURG; }
1975 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-BH")) { return AREA_BOSNIA_HERZEGOVINA; }
1976 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL")) { return AREA_BALEARES; }
1977 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL-OO")) { return AREA_BALEARES; }
1978 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_IBIZA_WITH_FORMENTERA; }
1979 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_MALLORCA; }
1980 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_MENORCA; }
1981 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB")) { return AREA_GREAT_BRITAIN; }
1982 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB-OO")) { return AREA_GREAT_BRITAIN; }
1983 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT")) { return AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION; }
1984 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL")) { return AREA_BULGARIA; }
1985 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL-OO")) { return AREA_BULGARIA; }
1986 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR")) { return AREA_BELARUS; }
1987 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR-OO")) { return AREA_BELARUS; }
1988 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY")) { return AREA_CANARY_ISLANDS; }
1989 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY-OO")) { return AREA_CANARY_ISLANDS; }
1990 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_GRAN_CANARIA; }
1991 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FUERTEVENTURA_WITH_LOBOS; }
1992 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_GOMERA; }
1993 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_HIERRO; }
1994 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_LANZAROTE_WITH_GRACIOSA; }
1995 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_LA_PALMA; }
1996 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_TENERIFE; }
1997 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MN")) { return AREA_MONTENEGRO; }
1998 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR")) { return AREA_CORSE; }
1999 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR-OO")) { return AREA_CORSE; }
2000 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI")) { return AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
2001 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI-OO")) { return AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
2002 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-CZ")) { return AREA_CZECH_REPUBLIC; }
2003 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-CR")) { return AREA_CROATIA; }
2004 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP")) { return AREA_CYPRUS; }
2005 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP-OO")) { return AREA_CYPRUS; }
2006 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE")) { return AREA_FORMER_CZECHOSLOVAKIA; }
2007 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN")) { return AREA_DENMARK_WITH_BORNHOLM; }
2008 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN-OO")) { return AREA_DENMARK_WITH_BORNHOLM; }
2009 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-ES")) { return AREA_ESTONIA; }
2010 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR")) { return AREA_FAROE_ISLANDS; }
2011 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR-OO")) { return AREA_FAROE_ISLANDS; }
2012 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN")) { return AREA_FINLAND_WITH_AHVENANMAA; }
2013 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN-OO")) { return AREA_FINLAND_WITH_AHVENANMAA; }
2014 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA")) { return AREA_FRANCE; }
2015 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-CI")) { return AREA_CHANNEL_ISLANDS; }
2016 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-FR")) { return AREA_FRENCH_MAINLAND; }
2017 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-MO")) { return AREA_MONACO; }
2018 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER")) { return AREA_GERMANY; }
2019 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER-OO")) { return AREA_GERMANY; }
2020 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC")) { return AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
2021 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC-OO")) { return AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
2022 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE")) { return AREA_IRELAND; }
2023 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-IR")) { return AREA_REPUBLIC_OF_IRELAND; }
2024 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-NI")) { return AREA_NORTHERN_IRELAND; }
2025 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI")) { return AREA_SWITZERLAND; }
2026 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI-OO")) { return AREA_SWITZERLAND; }
2027 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET")) { return AREA_NETHERLANDS; }
2028 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET-OO")) { return AREA_NETHERLANDS; }
2029 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA")) { return AREA_SPAIN; }
2030 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-AN")) { return AREA_ANDORRA; }
2031 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-GI")) { return AREA_GIBRALTAR; }
2032 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-SP")) { return AREA_KINGDOM_OF_SPAIN; }
2033 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN")) { return AREA_HUNGARY; }
2034 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN-OO")) { return AREA_HUNGARY; }
2035 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE")) { return AREA_ICELAND; }
2036 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE-OO")) { return AREA_ICELAND; }
2037 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA")) { return AREA_ITALY; }
2038 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-IT")) { return AREA_ITALIAN_MAINLAND; }
2039 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-SM")) { return AREA_SAN_MARINO; }
2040 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG")) { return AREA_FORMER_JUGOSLAVIA; }
2041 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LA")) { return AREA_LATVIA; }
2042 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LI")) { return AREA_LITHUANIA; }
2043 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR")) { return AREA_PORTUGUESE_MAINLAND; }
2044 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR-OO")) { return AREA_PORTUGUESE_MAINLAND; }
2045 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR")) { return AREA_MADEIRA_ARCHIPELAGO; }
2046 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR-OO")) { return AREA_MADEIRA_ARCHIPELAGO; }
2047 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MA")) { return AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA; }
2048 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-MO")) { return AREA_MOLDOVA; }
2049 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR")) { return AREA_NORWEGIAN_MAINLAND; }
2050 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR-OO")) { return AREA_NORWEGIAN_MAINLAND; }
2051 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL")) { return AREA_POLAND; }
2052 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL-OO")) { return AREA_POLAND; }
2053 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return AREA_THE_RUSSIAN_FEDERATION; }
2054 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB")) { return AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
2055 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB-OO")) { return AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
2056 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC")) { return AREA_CENTRAL_EUROPEAN_RUSSIA; }
2057 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC-OO")) { return AREA_CENTRAL_EUROPEAN_RUSSIA; }
2058 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE")) { return AREA_EASTERN_EUROPEAN_RUSSIA; }
2059 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE-OO")) { return AREA_EASTERN_EUROPEAN_RUSSIA; }
2060 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-KA")) { return AREA_KALININGRAD; }
2061 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN")) { return AREA_NORTHERN_EUROPEAN_RUSSIA; }
2062 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN-OO")) { return AREA_NORTHERN_EUROPEAN_RUSSIA; }
2063 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW")) { return AREA_NORTHWEST_EUROPEAN_RUSSIA; }
2064 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW-OO")) { return AREA_NORTHWEST_EUROPEAN_RUSSIA; }
2065 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return AREA_SOUTH_EUROPEAN_RUSSIA; }
2066 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS-OO")) { return AREA_SOUTH_EUROPEAN_RUSSIA; }
2067 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM")) { return AREA_ROMANIA; }
2068 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM-OO")) { return AREA_ROMANIA; }
2069 //
2070 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR")) { return AREA_SARDEGNA; }
2071 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR-OO")) { return AREA_SARDEGNA; }
2072 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA")) { return AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
2073 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA-OO")) { return AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
2074 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL")) { return AREA_SELVAGENS_ISLANDS; }
2075 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL-OO")) { return AREA_SELVAGENS_ISLANDS; }
2076 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC")) { return AREA_SICILY_WITH_MALTA; }
2077 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-MA")) { return AREA_MALTA; }
2078 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-SI")) { return AREA_SICILY; }
2079 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-SK")) { return AREA_SLOVAKIA; }
2080 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SL")) { return AREA_SLOVENIA; }
2081 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CS")) { return AREA_SERBIA_WITH_MONTENEGRO; }
2082 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SE")) { return AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
2083 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE")) { return AREA_SWEDEN; }
2084 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE-OO")) { return AREA_SWEDEN; }
2085 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE")) { return AREA_EUROPEAN_TURKEY; }
2086 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE-OO")) { return AREA_EUROPEAN_TURKEY; }
2087 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY")) { return AREA_CRIMEA; }
2088 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY-OO")) { return AREA_CRIMEA; }
2089 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-UK")) { return AREA_UKRAINE; }
2090 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRE")) { return AREA_GREEK_MAINLAND; }
2091 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-KRI")) { return AREA_CRETE; }
2092 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-DOD")) { return AREA_DODECANESE_ISLANDS; }
2093 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-CYC")) { return AREA_CYCLADES_ISLANDS; }
2094 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-AEG")) { return AREA_NORTH_AEGEAN_ISLANDS; }
2095 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-VC")) { return AREA_VATICAN_CITY; }
2096 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FRANZ_JOSEF_LAND; }
2097 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_NOVAYA_ZEMLYA; }
2098 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AZ")) { return AREA_AZERBAIJAN; }
2099 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-NA")) { return AREA_NAKHICHEVAN; }
2100 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG")) { return AREA_ALGERIA; }
2101 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG-OO")) { return AREA_ALGERIA; }
2102 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AR")) { return AREA_ARMENIA; }
2103 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("33")) { return AREA_CAUCASUS_REGION; }
2104 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY")) { return AREA_EGYPT; }
2105 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY-OO")) { return AREA_EGYPT; }
2106 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL")) { return AREA_ISRAEL_JORDAN; }
2107 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-IS")) { return AREA_ISRAEL; }
2108 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-JO")) { return AREA_JORDAN; }
2109 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-LB")) { return AREA_LEBANON; }
2110 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBY-OO")) { return AREA_LIBYA; }
2111 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS")) { return AREA_LEBANON_SYRIA; }
2112 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MOR")) { return AREA_MOROCCO; }
2113 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MOR-OO")) { return AREA_MOROCCO; }
2114 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NCS")) { return AREA_NORTH_CAUCASUS; }
2115 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN")) { return AREA_SINAI; }
2116 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN-OO")) { return AREA_SINAI; }
2117 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-SY")) { return AREA_SYRIA; }
2118 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN")) { return AREA_TUNISIA; }
2119 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN-OO")) { return AREA_TUNISIA; }
2120 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_ASIATIC_TURKEY; }
2121 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUR-OO")) { return AREA_ASIATIC_TURKEY; }
2122 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("20")) { return AREA_NORTHERN_AFRICA; }
2123 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AFR")) { return AREA_AFRO_TROPICAL_REGION; }
2124 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUS")) { return AREA_AUSTRALIAN_REGION; }
2125 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_EAST_PALAEARCTIC; }
2126 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEA")) { return AREA_NEARCTIC_REGION; }
2127 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEO")) { return AREA_NEOTROPICAL_REGION; }
2128 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NRE")) { return AREA_NEAR_EAST; }
2129 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ORR")) { return AREA_ORIENTAL_REGION; }
2130 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS")) { return AREA_TRANSCAUCASUS; }
2131 //
2132 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return AREA_EUROPEAN_MARINE_WATERS; }
2133 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||
2134 //                                      (namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
2135 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return AREA_WHITE_SEA; }
2136 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return AREA_NORTH_SEA; }
2137 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return AREA_BALTIC_SEA; }
2138 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||
2139 //                                      (namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return AREA_BLACK_SEA; } // abbreviated label missing
2140 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return AREA_BARENTS_SEA; }
2141 //                      else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
2142 //                                      (namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return AREA_CASPIAN_SEA; } // abbreviated label missing
2143 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
2144 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2145 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
2146 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return AREA_ENGLISH_CHANNEL; }
2147 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return AREA_ADRIATIC_SEA; }
2148 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return AREA_BISCAY_BAY; }
2149 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
2150 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
2151 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
2152 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2153 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2154 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return AREA_TIRRENO_SEA; }
2155 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
2156 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
2157 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return AREA_IRISH_SEA; }
2158 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2159 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return AREA_NORWEGIAN_SEA; }
2160 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
2161 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2162 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return AREA_SKAGERRAK; }
2163 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2164 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return AREA_WADDEN_SEA; }
2165 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return AREA_BELT_SEA; }
2166 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return AREA_MARMARA_SEA; }
2167 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return AREA_SEA_OF_AZOV; }
2168 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return AREA_AEGEAN_SEA; }
2169 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2170 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return AREA_SOUTH_BALTIC_PROPER; }
2171 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return AREA_BALTIC_PROPER; }
2172 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return AREA_NORTH_BALTIC_PROPER; }
2173 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return AREA_ARCHIPELAGO_SEA; }
2174 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return AREA_BOTHNIAN_SEA; }
2175 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
2176 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
2177 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2178 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
2179 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
2180 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
2181 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2182 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2183 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return AREA_BALEAR_SEA; }
2184 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
2185 //                      else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
2186 //                      else {
2187 //                              logger.warn("Unknown TDWGArea: " + area.getTitleCache());
2188 //                      }
2189 //              }else if (namedArea.isInstanceOf(WaterbodyOrCountry.class)){
2190 //                      if (namedArea.equals(WaterbodyOrCountry.UKRAINE())) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
2191 //                      else if (namedArea.equals(WaterbodyOrCountry.AZERBAIJANREPUBLICOF())) { return AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
2192 //                      else if (namedArea.equals(WaterbodyOrCountry.GEORGIA())) { return AREA_GEORGIA; }
2193 //                      else {
2194 //                              logger.warn("Unknown Waterbody/Country: " + area.getTitleCache());
2195 //                      }
2196 //              }else{  //Non TDWG
2197 //                      if ( namedArea.getUuid().equals(BerlinModelTransformer.uuidMadeira)){ return AREA_MADEIRA; }
2198 //                      else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidDesertas)) { return AREA_DESERTAS; }
2199 //                      else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPortoSanto)) { return AREA_PORTO_SANTO; }
2200 //                      else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaBaltic)) { return AREA_RUSSIA_BALTIC; }
2201 //                      else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthEast)) { return AREA_RUSSIA_SOUTHEAST; }
2202 //                      else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthWest)) { return AREA_RUSSIA_SOUTHWEST; }
2203 //                      else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUssr)) { return AREA_FORMER_USSR; }
2204 //                      else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaCentral)) { return AREA_RUSSIA_CENTRAL; }
2205 //                      else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaNorthern)) { return AREA_RUSSIA_NORTHERN; }
2206 //                      else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkey)) { return AREA_TURKEY; }
2207 //                      else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEastAegeanIslands)) { return AREA_EAST_AEGEAN_ISLANDS; }
2208 //
2209 //                      else {
2210 //                              logger.warn("Unknown NamedArea Area: " + area.getTitleCache());
2211 //                      }
2212 //
2213 //              }
2214 //              return null;
2215 //
2216 //      }
2217
2218         /**
2219          * Returns the PESI SourceUseId for a given CDM sourceUseId.
2220          * @param sourceUseId
2221          * @return
2222          */
2223         public static Integer sourceUseIdSourceUseId(Integer sourceUseId) {
2224                 // TODO: CDM sourceUseId and PESI sourceUseId are equal for now.
2225                 Integer result = null;
2226                 switch (sourceUseId) {
2227                         case 3: return ADDITIONAL_SOURCE;
2228                         case 4: return SOURCE_OF_SYNONYMY;
2229                         case 8: return NOMENCLATURAL_REFERENCE;
2230                 }
2231                 return result;
2232         }
2233
2234         /**
2235          * Returns the SourceUseCache for a tiven sourceUseId.
2236          * @param sourceUseId
2237          * @return
2238          */
2239         public static String sourceUseId2SourceUseCache(Integer sourceUseId) {
2240                 // TODO: CDM sourceUseId and PESI sourceUseId are equal for now.
2241                 String result = null;
2242                 switch (sourceUseId) {
2243                         case 3: return STR_ADDITIONAL_SOURCE;
2244                         case 4: return STR_SOURCE_OF_SYNONYMY;
2245                         case 8: return STR_NOMENCLATURAL_REFERENCE;
2246                 }
2247                 return result;
2248         }
2249
2250         /**
2251          * Returns the FossilStatusCache to a given Fossil.
2252          * @param fossil
2253          * @return
2254          */
2255         public static String fossil2FossilStatusCache(Fossil fossil) {
2256                 String result = null;
2257                 return result;
2258         }
2259
2260         /**
2261          * Returns the FossilStatusId to a given Fossil.
2262          * @param fossil
2263          * @return
2264          */
2265         public static Integer fossil2FossilStatusId(Fossil fossil) {
2266                 Integer result = null;
2267                 return result;
2268         }
2269
2270
2271
2272         @Override
2273         public Object getKeyByLanguage(Language language) throws UndefinedTransformerMethodException {
2274                 return language2LanguageId(language);
2275         }
2276
2277         @Override
2278         public String getCacheByLanguage(Language language) throws UndefinedTransformerMethodException {
2279                 return language2LanguageCache(language);
2280         }
2281
2282         /**
2283          * Returns the LanguageCache to a given Language.
2284          * @param language
2285          * @return
2286          */
2287         public static String language2LanguageCache(Language language) {
2288                 if (language == null ) {
2289                         return null;
2290                 }
2291                 if (language.equals(Language.ALBANIAN())) {
2292                         return STR_LANGUAGE_ALBANIAN;
2293                 } else if (language.equals(Language.ARABIC())) {
2294                         return STR_LANGUAGE_ARABIC;
2295                 } else if (language.equals(Language.ARMENIAN())) {
2296                         return STR_LANGUAGE_ARMENIAN;
2297                 } else if (language.equals(Language.AZERBAIJANI())) {
2298                         return STR_LANGUAGE_AZERBAIJAN;
2299                 } else if (language.equals(Language.BELORUSSIAN())) {
2300                         return STR_LANGUAGE_BELARUSIAN;
2301                 } else if (language.equals(Language.BULGARIAN())) {
2302                         return STR_LANGUAGE_BULGARIAN;
2303                 } else if (language.equals(Language.CATALAN_VALENCIAN())) {
2304                         return STR_LANGUAGE_CATALAN;
2305                 } else if (language.equals(Language.CROATIAN())) {
2306                         return STR_LANGUAGE_CROAT;
2307                 } else if (language.equals(Language.CZECH())) {
2308                         return STR_LANGUAGE_CZECH;
2309                 } else if (language.equals(Language.DANISH())) {
2310                         return STR_LANGUAGE_DANISH;
2311                 } else if (language.equals(Language.DUTCH_MIDDLE())) {
2312                         return STR_LANGUAGE_DUTCH;
2313                 } else if (language.equals(Language.ENGLISH())) {
2314                         return STR_LANGUAGE_ENGLISH;
2315 //              } else if (language.equals(Language.)) {
2316 //                      return STR_LANGUAGE_EUSKERA;
2317                 } else if (language.equals(Language.ESTONIAN())) {
2318                         return STR_LANGUAGE_ESTONIAN;
2319                 } else if (language.equals(Language.FINNISH())) {
2320                         return STR_LANGUAGE_FINNISH;
2321                 } else if (language.equals(Language.FRENCH())) {
2322                         return STR_LANGUAGE_FRENCH;
2323                 } else if (language.equals(Language.GEORGIAN())) {
2324                         return STR_LANGUAGE_GEORGIAN;
2325                 } else if (language.equals(Language.GERMAN())) {
2326                         return STR_LANGUAGE_GERMAN;
2327                 } else if (language.equals(Language.GREEK_MODERN())) {
2328                         return STR_LANGUAGE_GREEK;
2329                 } else if (language.equals(Language.HUNGARIAN())) {
2330                         return STR_LANGUAGE_HUNGARIAN;
2331                 } else if (language.equals(Language.ICELANDIC())) {
2332                         return STR_LANGUAGE_ICELANDIC;
2333                 } else if (language.equals(Language.IRISH())) {
2334                         return STR_LANGUAGE_IRISH_GAELIC;
2335                 } else if (language.equals(Language.HEBREW())) {
2336                         return STR_LANGUAGE_ISRAEL_HEBREW;
2337                 } else if (language.equals(Language.ITALIAN())) {
2338                         return STR_LANGUAGE_ITALIAN;
2339                 } else if (language.equals(Language.LATVIAN())) {
2340                         return STR_LANGUAGE_LATVIAN;
2341                 } else if (language.equals(Language.LITHUANIAN())) {
2342                         return STR_LANGUAGE_LITHUANIAN;
2343                 } else if (language.equals(Language.MACEDONIAN())) {
2344                         return STR_LANGUAGE_MACEDONIAN;
2345                 } else if (language.equals(Language.MALTESE())) {
2346                         return STR_LANGUAGE_MALTESE;
2347                 } else if (language.equals(Language.MOLDAVIAN())) {
2348                         return STR_LANGUAGE_MOLDOVIAN;
2349                 } else if (language.equals(Language.NORWEGIAN())) {
2350                         return STR_LANGUAGE_NORWEGIAN;
2351                 } else if (language.equals(Language.POLISH())) {
2352                         return STR_LANGUAGE_POLISH;
2353                 } else if (language.equals(Language.PORTUGUESE())) {
2354                         return STR_LANGUAGE_PORTUGUESE;
2355                 } else if (language.equals(Language.ROMANIAN())) {
2356                         return STR_LANGUAGE_ROUMANIAN;
2357                 } else if (language.equals(Language.RUSSIAN())) {
2358                         return STR_LANGUAGE_RUSSIAN;
2359 //              } else if (language.equals(Language.)) {
2360 //                      return STR_LANGUAGE_RUSSIAN_CAUCASIAN;
2361 //              } else if (language.equals(Language.)) {
2362 //                      return STR_LANGUAGE_RUSSIAN_ALTAIC_KALMYK_OIRAT;
2363 //              } else if (language.equals(Language.)) {
2364 //                      return STR_LANGUAGE_RUSSIAN_ALTAIC_KARACHAY_BALKAR;
2365 //              } else if (language.equals(Language.)) {
2366 //                      return STR_LANGUAGE_RUSSIAN_ALTAIC_KUMYK;
2367 //              } else if (language.equals(Language.)) {
2368 //                      return STR_LANGUAGE_RUSSIAN_ALTAIC_NOGAI;
2369 //              } else if (language.equals(Language.)) {
2370 //                      return STR_LANGUAGE_RUSSIAN_ALTAIC_NORTH_AZERBAIJANI;
2371 //              } else if (language.equals(Language.)) {
2372 //                      return STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_RUSSIAN;
2373 //              } else if (language.equals(Language.)) {
2374 //                      return STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_KALMYK_OIRAT;
2375 //              } else if (language.equals(Language.)) {
2376 //                      return STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_OSETIN;
2377 //              } else if (language.equals(Language.)) {
2378 //                      return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_ABAZA;
2379 //              } else if (language.equals(Language.)) {
2380 //                      return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_ADYGHE;
2381 //              } else if (language.equals(Language.)) {
2382 //                      return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_CHECHEN;
2383 //              } else if (language.equals(Language.)) {
2384 //                      return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_KABARDIAN;
2385 //              } else if (language.equals(Language.)) {
2386 //                      return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_LAK;
2387 //              } else if (language.equals(Language.)) {
2388 //                      return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_AVAR;
2389 //              } else if (language.equals(Language.)) {
2390 //                      return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_IN;
2391 //              } else if (language.equals(Language.)) {
2392 //                      return STR_LANGUAGE_RUSSIAN_URALIC_CHUVASH;
2393 //              } else if (language.equals(Language.)) {
2394 //                      return STR_LANGUAGE_RUSSIAN_URALIC_UDMURT;
2395                 } else if (language.equals(Language.SERBIAN())) {
2396                         return STR_LANGUAGE_SERBIAN;
2397                 } else if (language.equals(Language.SLOVAK())) {
2398                         return STR_LANGUAGE_SLOVAK;
2399                 } else if (language.equals(Language.SLOVENIAN())) {
2400                         return STR_LANGUAGE_SLOVENE;
2401                 } else if (language.equals(Language.SPANISH_CATALAN())) {
2402                         return STR_LANGUAGE_SPANISH_CASTILLIAN;
2403                 } else if (language.equals(Language.SWEDISH())) {
2404                         return STR_LANGUAGE_SWEDISH;
2405                 } else if (language.equals(Language.TURKISH())) {
2406                         return STR_LANGUAGE_TURKISH;
2407                 } else if (language.equals(Language.UKRAINIAN())) {
2408                         return STR_LANGUAGE_UKRAINE;
2409                 } else if (language.equals(Language.WELSH())) {
2410                         return STR_LANGUAGE_WELSH;
2411                 } else if (language.equals(Language.CORSICAN())) {
2412                         return STR_LANGUAGE_CORSICAN;
2413                 } else {
2414                         logger.debug("Unknown Language: " + language.getTitleCache());
2415                         return null;
2416                 }
2417         }
2418
2419         /**
2420          * Returns the identifier of the given Language.
2421          * @param language
2422          * @return
2423          */
2424         public static Integer language2LanguageId(Language language) {
2425                 if (language == null ) {
2426                         return null;
2427                 }
2428                 if (language.equals(Language.ALBANIAN())) {
2429                         return Language_Albanian;
2430                 } else if (language.equals(Language.ARABIC())) {
2431                         return Language_Arabic;
2432                 } else if (language.equals(Language.ARMENIAN())) {
2433                         return Language_Armenian;
2434                 } else if (language.equals(Language.AZERBAIJANI())) {
2435                         return Language_Azerbaijan;
2436                 } else if (language.equals(Language.BELORUSSIAN())) {
2437                         return Language_Belarusian;
2438                 } else if (language.equals(Language.BULGARIAN())) {
2439                         return Language_Bulgarian;
2440                 } else if (language.equals(Language.CATALAN_VALENCIAN())) {
2441                         return Language_Catalan;
2442                 } else if (language.equals(Language.CROATIAN())) {
2443                         return Language_Croat;
2444                 } else if (language.equals(Language.CZECH())) {
2445                         return Language_Czech;
2446                 } else if (language.equals(Language.DANISH())) {
2447                         return Language_Danish;
2448                 } else if (language.equals(Language.DUTCH_MIDDLE())) {
2449                         return Language_Dutch;
2450                 } else if (language.equals(Language.ENGLISH())) {
2451                         return Language_English;
2452 //              } else if (language.equals(Language.)) {
2453 //                      return Language_Euskera;
2454                 } else if (language.equals(Language.ESTONIAN())) {
2455                         return Language_Estonian;
2456                 } else if (language.equals(Language.FINNISH())) {
2457                         return Language_Finnish;
2458                 } else if (language.equals(Language.FRENCH())) {
2459                         return Language_French;
2460                 } else if (language.equals(Language.GEORGIAN())) {
2461                         return Language_Georgian;
2462                 } else if (language.equals(Language.GERMAN())) {
2463                         return Language_German;
2464                 } else if (language.equals(Language.GREEK_MODERN())) {
2465                         return Language_Greek;
2466                 } else if (language.equals(Language.HUNGARIAN())) {
2467                         return Language_Hungarian;
2468                 } else if (language.equals(Language.ICELANDIC())) {
2469                         return Language_Icelandic;
2470                 } else if (language.equals(Language.IRISH())) {
2471                         return Language_Irish_Gaelic;
2472                 } else if (language.equals(Language.HEBREW())) {
2473                         return Language_Israel_Hebrew;
2474                 } else if (language.equals(Language.ITALIAN())) {
2475                         return Language_Italian;
2476                 } else if (language.equals(Language.LATVIAN())) {
2477                         return Language_Latvian;
2478                 } else if (language.equals(Language.LITHUANIAN())) {
2479                         return Language_Lithuanian;
2480                 } else if (language.equals(Language.MACEDONIAN())) {
2481                         return Language_Macedonian;
2482                 } else if (language.equals(Language.MALTESE())) {
2483                         return Language_Maltese;
2484                 } else if (language.equals(Language.MOLDAVIAN())) {
2485                         return Language_Moldovian;
2486                 } else if (language.equals(Language.NORWEGIAN())) {
2487                         return Language_Norwegian;
2488                 } else if (language.equals(Language.POLISH())) {
2489                         return Language_Polish;
2490                 } else if (language.equals(Language.PORTUGUESE())) {
2491                         return Language_Portuguese;
2492                 } else if (language.equals(Language.ROMANIAN())) {
2493                         return Language_Roumanian;
2494                 } else if (language.equals(Language.RUSSIAN())) {
2495                         return Language_Russian;
2496 //              } else if (language.equals(Language.)) {
2497 //                      return Language_Russian_Caucasian;
2498 //              } else if (language.equals(Language.)) {
2499 //                      return Language_Russian_Altaic_kalmyk_oirat;
2500 //              } else if (language.equals(Language.)) {
2501 //                      return Language_Russian_Altaic_karachay_balkar;
2502 //              } else if (language.equals(Language.)) {
2503 //                      return Language_Russian_Altaic_kumyk;
2504 //              } else if (language.equals(Language.)) {
2505 //                      return Language_Russian_Altaic_nogai;
2506 //              } else if (language.equals(Language.)) {
2507 //                      return Language_Russian_Altaic_north_azerbaijani;
2508 //              } else if (language.equals(Language.)) {
2509 //                      return Language_Russian_Indo_european_russian;
2510 //              } else if (language.equals(Language.)) {
2511 //                      return Language_Russian_Indo_european_kalmyk_oirat;
2512 //              } else if (language.equals(Language.)) {
2513 //                      return Language_Russian_Indo_european_osetin;
2514 //              } else if (language.equals(Language.)) {
2515 //                      return Language_Russian_North_caucasian_abaza;
2516 //              } else if (language.equals(Language.)) {
2517 //                      return Language_Russian_North_caucasian_adyghe;
2518 //              } else if (language.equals(Language.)) {
2519 //                      return Language_Russian_North_caucasian_chechen;
2520 //              } else if (language.equals(Language.)) {
2521 //                      return Language_Russian_North_caucasian_kabardian;
2522 //              } else if (language.equals(Language.)) {
2523 //                      return Language_Russian_North_caucasian_lak;
2524 //              } else if (language.equals(Language.)) {
2525 //                      return Language_Russian_North_caucasian_avar;
2526 //              } else if (language.equals(Language.)) {
2527 //                      return Language_Russian_North_caucasian_in;
2528 //              } else if (language.equals(Language.)) {
2529 //                      return Language_Russian_Uralic_chuvash;
2530 //              } else if (language.equals(Language.)) {
2531 //                      return Language_Russian_Uralic_udmurt;
2532                 } else if (language.equals(Language.SERBIAN())) {
2533                         return Language_Serbian;
2534                 } else if (language.equals(Language.SLOVAK())) {
2535                         return Language_Slovak;
2536                 } else if (language.equals(Language.SLOVENIAN())) {
2537                         return Language_Slovene;
2538                 } else if (language.equals(Language.SPANISH_CATALAN())) {
2539                         return Language_Spanish_Castillian;
2540                 } else if (language.equals(Language.SWEDISH())) {
2541                         return Language_Swedish;
2542                 } else if (language.equals(Language.TURKISH())) {
2543                         return Language_Turkish;
2544                 } else if (language.equals(Language.UKRAINIAN())) {
2545                         return Language_Ukraine;
2546                 } else if (language.equals(Language.WELSH())) {
2547                         return Language_Welsh;
2548                 } else if (language.equals(Language.CORSICAN())) {
2549                         return Language_Corsican;
2550                 } else {
2551                         logger.debug("Unknown Language: " + language.getTitleCache());
2552                         return null;
2553                 }
2554         }
2555
2556         /**
2557          * Returns the NodeCategoryCache for a given TextData.
2558          * @param feature
2559          * @return
2560          */
2561         public static String textData2NodeCategoryCache(Feature feature) {
2562                 if (feature == null) {
2563                         return null;
2564                 }
2565
2566                 if (feature.equals(Feature.DESCRIPTION())) {
2567                         return NoteCategory_STR_description;
2568                 } else if (feature.equals(Feature.ECOLOGY())) {
2569                         return NoteCategory_STR_ecology;
2570                 } else if (feature.equals(Feature.PHENOLOGY())) {
2571                         return NoteCategory_STR_phenology;
2572                 } else if (feature.equals(Feature.COMMON_NAME())) {
2573                         return NoteCategory_STR_Common_names;
2574                 } else if (feature.equals(Feature.OCCURRENCE())) {
2575                         return NoteCategory_STR_Occurrence;
2576                 } else if (feature.getUuid().equals(ErmsTransformer.uuidRemark)) {
2577                         return NoteCategory_STR_Remark;
2578                 } else if (feature.getUuid().equals(ErmsTransformer.uuidAdditionalinformation)) {
2579                         return NoteCategory_STR_Additional_information;
2580                 } else if (feature.getUuid().equals(ErmsTransformer.uuidSpelling)) {
2581                         return NoteCategory_STR_Spelling;
2582                 } else if (feature.getUuid().equals(ErmsTransformer.uuidDateofPublication)) {
2583                         return NoteCategory_STR_Date_of_publication;
2584                 } else if (feature.getUuid().equals(ErmsTransformer.uuidSystematics)) {
2585                         return NoteCategory_STR_Systematics;
2586                 } else if (feature.getUuid().equals(ErmsTransformer.uuidClassification)) {
2587                         return NoteCategory_STR_Classification;
2588                 } else if (feature.getUuid().equals(ErmsTransformer.uuidEnvironment)) {
2589                         return NoteCategory_STR_Environment;
2590                 } else if (feature.getUuid().equals(ErmsTransformer.uuidHabitat)) {
2591                         return NoteCategory_STR_Habitat;
2592                 } else if (feature.getUuid().equals(ErmsTransformer.uuidAuthority)) {
2593                         return NoteCategory_STR_Authority;
2594                 } else if (feature.getUuid().equals(ErmsTransformer.uuidMorphology)) {
2595                         return NoteCategory_STR_Morphology;
2596                 } else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemarks)) {
2597                         return NoteCategory_STR_Taxonomic_Remarks;
2598                 } else if (feature.getUuid().equals(ErmsTransformer.uuidNote)){
2599                         return NoteCategory_STR_Note;
2600                 } else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomy)) {
2601                         return NoteCategory_STR_Taxonomy;
2602                 } else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicstatus)) {
2603                         return NoteCategory_STR_Taxonomic_status;
2604                 } else if (feature.getUuid().equals(ErmsTransformer.uuidStatus)){
2605                         return NoteCategory_STR_Status;
2606                 } else if (feature.getUuid().equals(ErmsTransformer.uuidRank)) {
2607                         return NoteCategory_STR_Rank;
2608                 } else if (feature.getUuid().equals(ErmsTransformer.uuidHomonymy)) {
2609                         return NoteCategory_STR_Homonymy;
2610                 } else if (feature.getUuid().equals(ErmsTransformer.uuidNomenclature)) {
2611                         return NoteCategory_STR_Nomenclature;
2612                 } else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemark)) {
2613                         return NoteCategory_STR_Taxonomic_Remark;
2614                 } else if (feature.getUuid().equals(ErmsTransformer.uuidAcknowledgments)){
2615                         return NoteCategory_STR_Acknowledgments;
2616                 } else if (feature.getUuid().equals(ErmsTransformer.uuidOriginalpublication)) {
2617                         return NoteCategory_STR_Original_publication;
2618                 } else if (feature.getUuid().equals(ErmsTransformer.uuidTypelocality)) {
2619                         return NoteCategory_STR_Type_locality;
2620                 } else if (feature.getUuid().equals(ErmsTransformer.uuidValidity)) {
2621                         return NoteCategory_STR_Validity;
2622                 } else if (feature.getUuid().equals(ErmsTransformer.uuidIdentification)) {
2623                         return NoteCategory_STR_Identification;
2624                 } else if (feature.getUuid().equals(ErmsTransformer.uuidSynonymy)) {
2625                         return NoteCategory_STR_Synonymy;
2626 //              } else if (feature.equals(Feature.CITATION())) {
2627 //                      return;
2628
2629                         // TODO: Unknown NodeCategories
2630 //                      NoteCategory_STR_general_distribution_euromed = 10;
2631 //                      NoteCategory_STR_general_distribution_world = 11;
2632 //                      NoteCategory_STR_Common_names = 12;
2633 //                      NoteCategory_STR_Maps =14;
2634 //                      NoteCategory_STR_Link_to_maps = 20;
2635 //                      NoteCategory_STR_Link_to_images = 21;
2636 //                      NoteCategory_STR_Link_to_taxonomy = 22;
2637 //                      NoteCategory_STR_Link_to_general_information = 23;
2638 //                      NoteCategory_STR_undefined_link = 24;
2639 //                      NoteCategory_STR_Editor_Braces = 249;
2640 //                      NoteCategory_STR_Editor_Brackets = 250;
2641 //                      NoteCategory_STR_Editor_Parenthesis = 251;
2642 //                      NoteCategory_STR_Inedited = 252;
2643 //                      NoteCategory_STR_Comments_on_editing_process = 253;
2644 //                      NoteCategory_STR_Publication_date = 254;
2645 //                      NoteCategory_STR_Distribution = 278;
2646 //                      NoteCategory_STR_Biology = 281;
2647 //                      NoteCategory_STR_Diagnosis      = 282;
2648 //                      NoteCategory_STR_Host = 283;
2649
2650                 } else {
2651                         logger.debug("Unknown Feature.");
2652                         return null;
2653                 }
2654         }
2655
2656         /**
2657          * Returns the NodeCategoryFk for a given TextData.
2658          * @param feature
2659          * @return
2660          */
2661         public static Integer feature2NodeCategoryFk(Feature feature) {
2662                 if (feature == null) {
2663                         return null;
2664                 }
2665
2666                 if (feature.equals(Feature.DESCRIPTION())) {
2667                         return NoteCategory_description;
2668                 } else if (feature.equals(Feature.ECOLOGY())) {
2669                         return NoteCategory_ecology;
2670                 } else if (feature.equals(Feature.PHENOLOGY())) {
2671                         return NoteCategory_phenology;
2672                 } else if (feature.equals(Feature.COMMON_NAME())) {
2673                         return NoteCategory_Common_names;
2674                 } else if (feature.equals(Feature.OCCURRENCE())) {
2675                         return NoteCategory_Occurrence;
2676                 } else if (feature.equals(Feature.DISTRIBUTION())) {
2677                         return NoteCategory_Distribution;
2678                 } else if (feature.getUuid().equals(ErmsTransformer.uuidRemark)) {
2679                         return NoteCategory_Remark;
2680                 } else if (feature.getUuid().equals(ErmsTransformer.uuidAdditionalinformation)) {
2681                         return NoteCategory_Additional_information;
2682                 } else if (feature.getUuid().equals(ErmsTransformer.uuidSpelling)) {
2683                         return NoteCategory_Spelling;
2684                 } else if (feature.getUuid().equals(ErmsTransformer.uuidDateofPublication)) {
2685                         return NoteCategory_Date_of_publication;
2686                 } else if (feature.getUuid().equals(ErmsTransformer.uuidSystematics)) {
2687                         return NoteCategory_Systematics;
2688                 } else if (feature.getUuid().equals(ErmsTransformer.uuidClassification)) {
2689                         return NoteCategory_Classification;
2690                 } else if (feature.getUuid().equals(ErmsTransformer.uuidEnvironment)) {
2691                         return NoteCategory_Environment;
2692                 } else if (feature.getUuid().equals(ErmsTransformer.uuidHabitat)) {
2693                         return NoteCategory_Habitat;
2694                 } else if (feature.getUuid().equals(ErmsTransformer.uuidAuthority)) {
2695                         return NoteCategory_Authority;
2696                 } else if (feature.getUuid().equals(ErmsTransformer.uuidMorphology)) {
2697                         return NoteCategory_Morphology;
2698                 } else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemarks)) {
2699                         return NoteCategory_Taxonomic_Remarks;
2700                 } else if (feature.getUuid().equals(ErmsTransformer.uuidNote)){
2701                         return NoteCategory_Note;
2702                 } else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomy)) {
2703                         return NoteCategory_Taxonomy;
2704                 } else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicstatus)) {
2705                         return NoteCategory_Taxonomic_status;
2706                 } else if (feature.getUuid().equals(ErmsTransformer.uuidStatus)){
2707                         return NoteCategory_Status;
2708                 } else if (feature.getUuid().equals(ErmsTransformer.uuidRank)) {
2709                         return NoteCategory_Rank;
2710                 } else if (feature.getUuid().equals(ErmsTransformer.uuidHomonymy)) {
2711                         return NoteCategory_Homonymy;
2712                 } else if (feature.getUuid().equals(ErmsTransformer.uuidNomenclature)) {
2713                         return NoteCategory_Nomenclature;
2714                 } else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemark)) {
2715                         return NoteCategory_Taxonomic_Remark;
2716                 } else if (feature.getUuid().equals(ErmsTransformer.uuidAcknowledgments)){
2717                         return NoteCategory_Acknowledgments;
2718                 } else if (feature.getUuid().equals(ErmsTransformer.uuidOriginalpublication)) {
2719                         return NoteCategory_Original_publication;
2720                 } else if (feature.getUuid().equals(ErmsTransformer.uuidTypelocality)) {
2721                         return NoteCategory_Type_locality;
2722                 } else if (feature.getUuid().equals(ErmsTransformer.uuidValidity)) {
2723                         return NoteCategory_Validity;
2724                 } else if (feature.getUuid().equals(ErmsTransformer.uuidIdentification)) {
2725                         return NoteCategory_Identification;
2726                 } else if (feature.getUuid().equals(ErmsTransformer.uuidSynonymy)) {
2727                         return NoteCategory_Synonymy;
2728                 } else if (feature.equals(Feature.CITATION())) {
2729                         return null;  //citations are handled differently
2730
2731                         // TODO: Unknown NodeCategories
2732 //                      NoteCategory_general_distribution_euromed = 10;
2733 //                      NoteCategory_general_distribution_world = 11;
2734 //                      NoteCategory_Common_names = 12;
2735 //                      NoteCategory_Maps =14;
2736 //                      NoteCategory_Link_to_maps = 20;
2737 //                      NoteCategory_Link_to_images = 21;
2738 //                      NoteCategory_Link_to_taxonomy = 22;
2739 //                      NoteCategory_Link_to_general_information = 23;
2740 //                      NoteCategory_undefined_link = 24;
2741 //                      NoteCategory_Editor_Braces = 249;
2742 //                      NoteCategory_Editor_Brackets = 250;
2743 //                      NoteCategory_Editor_Parenthesis = 251;
2744 //                      NoteCategory_Inedited = 252;
2745 //                      NoteCategory_Comments_on_editing_process = 253;
2746 //                      NoteCategory_Publication_date = 254;
2747 //                      NoteCategory_Distribution = 278;
2748 //                      NoteCategory_Biology = 281;
2749 //                      NoteCategory_Diagnosis  = 282;
2750 //                      NoteCategory_Host = 283;
2751
2752                 }else{
2753                         logger.warn("Unhandled Feature: " + feature.getTitleCache());
2754                         return null;
2755                 }
2756         }
2757
2758         /**
2759          * Returns the string representation for a given rank.
2760          * @param rank
2761          * @param pesiKingdomId
2762          * @return
2763          */
2764         public static String rank2RankCache(Rank rank, Integer pesiKingdomId) {
2765                 String result = null;
2766                 if (rank == null) {
2767                         return null;
2768                 }
2769
2770                 // We differentiate between Animalia and Plantae only for now.
2771                 if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_ANIMALIA) {
2772                         if (rank.equals(Rank.KINGDOM())) {
2773                                 result = Animalia_STR_Kingdom;
2774                         } else if (rank.equals(Rank.SUBKINGDOM())) {
2775                                 result = Animalia_STR_Subkingdom;
2776                         } else if (rank.equals(Rank.SUPERPHYLUM())) {
2777                                 result = Animalia_STR_Superphylum;
2778                         } else if (rank.equals(Rank.PHYLUM())) {
2779                                 result = Animalia_STR_Phylum;
2780                         } else if (rank.equals(Rank.SUBPHYLUM())) {
2781                                 result = Animalia_STR_Subphylum;
2782                         } else if (rank.equals(Rank.INFRAPHYLUM())) {
2783                                 result = Animalia_STR_Infraphylum;
2784                         } else if (rank.equals(Rank.SUPERCLASS())) {
2785                                 result = Animalia_STR_Superclass;
2786                         } else if (rank.equals(Rank.CLASS())) {
2787                                 result = Animalia_STR_Class;
2788                         } else if (rank.equals(Rank.SUBCLASS())) {
2789                                 result = Animalia_STR_Subclass;
2790                         } else if (rank.equals(Rank.INFRACLASS())) {
2791                                 result = Animalia_STR_Infraclass;
2792                         } else if (rank.equals(Rank.SUPERORDER())) {
2793                                 result = Animalia_STR_Superorder;
2794                         } else if (rank.equals(Rank.ORDER())) {
2795                                 result = Animalia_STR_Order;
2796                         } else if (rank.equals(Rank.SUBORDER())) {
2797                                 result = Animalia_STR_Suborder;
2798                         } else if (rank.equals(Rank.INFRAORDER())) {
2799                                 result = Animalia_STR_Infraorder;
2800                         } else if (rank.equals(Rank.SECTION_ZOOLOGY())) {
2801                                 result = Animalia_STR_Section;
2802                         } else if (rank.equals(Rank.SUBSECTION_ZOOLOGY())) {
2803                                 result = Animalia_STR_Subsection;
2804                         } else if (rank.equals(Rank.SUPERFAMILY())) {
2805                                 result = Animalia_STR_Superfamily;
2806                         } else if (rank.equals(Rank.FAMILY())) {
2807                                 result = Animalia_STR_Family;
2808                         } else if (rank.equals(Rank.SUBFAMILY())) {
2809                                 result = Animalia_STR_Subfamily;
2810                         } else if (rank.equals(Rank.TRIBE())) {
2811                                 result = Animalia_STR_Tribe;
2812                         } else if (rank.equals(Rank.SUBTRIBE())) {
2813                                 result = Animalia_STR_Subtribe;
2814                         } else if (rank.equals(Rank.GENUS())) {
2815                                 result = Animalia_STR_Genus;
2816                         } else if (rank.equals(Rank.SUBGENUS())) {
2817                                 result = Animalia_STR_Subgenus;
2818                         } else if (rank.equals(Rank.SPECIES())) {
2819                                 result = Animalia_STR_Species;
2820                         } else if (rank.equals(Rank.SUBSPECIES())) {
2821                                 result = Animalia_STR_Subspecies;
2822 //                      } else if (rank.equals(Rank.)) { // not yet specified
2823 //                              result = Animalia_STR_Natio;
2824                         } else if (rank.equals(Rank.VARIETY())) {
2825                                 result = Animalia_STR_Variety;
2826                         } else if (rank.equals(Rank.SUBVARIETY())) {
2827                                 result = Animalia_STR_Subvariety;
2828                         } else if (rank.equals(Rank.FORM())) {
2829                                 result = Animalia_STR_Forma;
2830                         } else {
2831                                 //TODO Exception
2832                                 logger.warn("Rank for Kingdom Animalia not yet supported in CDM: "+ rank.getLabel());
2833                                 return null;
2834                         }
2835                 } else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_PLANTAE) {
2836                         if (rank.equals(Rank.KINGDOM())) {
2837                                 result = Plantae_STR_Kingdom;
2838                         } else if (rank.equals(Rank.SUBKINGDOM())) {
2839                                 result = Plantae_STR_Subkingdom;
2840                         } else if (rank.equals(Rank.DIVISION())) {
2841                                 result = Plantae_STR_Division;
2842                         } else if (rank.equals(Rank.SUBDIVISION())) {
2843                                 result = Plantae_STR_Subdivision;
2844                         } else if (rank.equals(Rank.CLASS())) {
2845                                 result = Plantae_STR_Class;
2846                         } else if (rank.equals(Rank.SUBCLASS())) {
2847                                 result = Plantae_STR_Subclass;
2848                         } else if (rank.equals(Rank.ORDER())) {
2849                                 result = Plantae_STR_Order;
2850                         } else if (rank.equals(Rank.SUBORDER())) {
2851                                 result = Plantae_STR_Suborder;
2852                         } else if (rank.equals(Rank.FAMILY())) {
2853                                 result = Plantae_STR_Family;
2854                         } else if (rank.equals(Rank.SUBFAMILY())) {
2855                                 result = Plantae_STR_Subfamily;
2856                         } else if (rank.equals(Rank.TRIBE())) {
2857                                 result = Plantae_STR_Tribe;
2858                         } else if (rank.equals(Rank.SUBTRIBE())) {
2859                                 result = Plantae_STR_Subtribe;
2860                         } else if (rank.equals(Rank.GENUS())) {
2861                                 result = Plantae_STR_Genus;
2862                         } else if (rank.equals(Rank.SUBGENUS())) {
2863                                 result = Plantae_STR_Subgenus;
2864                         } else if (rank.equals(Rank.SECTION_BOTANY())) {
2865                                 result = Plantae_STR_Section;
2866                         } else if (rank.equals(Rank.SUBSECTION_BOTANY())) {
2867                                 result = Plantae_STR_Subsection;
2868                         } else if (rank.equals(Rank.SERIES())) {
2869                                 result = Plantae_STR_Series;
2870                         } else if (rank.equals(Rank.SUBSERIES())) {
2871                                 result = Plantae_STR_Subseries;
2872                         } else if (rank.equals(Rank.SPECIESAGGREGATE() )) {
2873                                 result = Plantae_STR_Aggregate;
2874                         } else if (rank.equals(Rank.SPECIESGROUP())) {
2875                                 logger.warn("Rank Species Group not yet implemented");
2876                                 result = null;
2877                         } else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankCollSpecies)) {
2878                                 result = Plantae_STR_Coll_Species;
2879                         } else if (rank.equals(Rank.SPECIES())) {
2880                                 result = Plantae_STR_Species;
2881                         } else if (rank.equals(Rank.SUBSPECIES())) {
2882                                 result = Plantae_STR_Subspecies;
2883                         } else if (rank.equals(Rank.GREX())) {
2884                                 result = Plantae_STR_Grex;
2885                         } else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankProles)) {
2886                                 result = Plantae_STR_Proles;
2887                         } else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankRace)) {
2888                                 result = Plantae_STR_Race;
2889                         } else if (rank.equals(Rank.CONVAR())) {
2890                                 result = Plantae_STR_Convarietas;
2891                         } else if (rank.equals(Rank.VARIETY())) {
2892                                 result = Plantae_STR_Variety;
2893                         } else if (rank.equals(Rank.SUBVARIETY())) {
2894                                 result = Plantae_STR_Subvariety;
2895                         } else if (rank.equals(Rank.FORM())) {
2896                                 result = Plantae_STR_Forma;
2897                         } else if (rank.equals(Rank.SUBFORM())) {
2898                                 result = Plantae_STR_Subforma;
2899 //                      } else if (rank.equals(Rank.)) { // not yet specified
2900 //                              result = Plantae_STR_Forma_spec;
2901                         } else if (rank.equals(Rank.INFRAGENERICTAXON())) {
2902                                 result = Plantae_STR_Taxa_infragen;
2903                         } else if (rank.equals(Rank.INFRASPECIFICTAXON())) {
2904                                 result = Plantae_STR_Taxa_infraspec;
2905                         } else {
2906                                 //TODO Exception
2907                                 logger.warn("Rank for Kingdom Plantae not yet supported in CDM: "+ rank.getLabel());
2908                                 return null;
2909                         }
2910                 } else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_BACTERIA) {
2911                         if (rank.equals(Rank.KINGDOM())) { result = Bacteria_STR_Kingdom; }
2912                         else if (rank.equals(Rank.SUBKINGDOM())) { result = Bacteria_STR_Subkingdom; }
2913                         else if (rank.equals(Rank.PHYLUM())) { result = Bacteria_STR_Phylum; }
2914                         else if (rank.equals(Rank.SUBPHYLUM())) { result = Bacteria_STR_Subphylum; }
2915                         else if (rank.equals(Rank.SUPERCLASS())) { result = Bacteria_STR_Superclass; }
2916                         else if (rank.equals(Rank.CLASS())) { result = Bacteria_STR_Class; }
2917                         else if (rank.equals(Rank.SUBCLASS())) { result = Bacteria_STR_Subclass; }
2918                         else if (rank.equals(Rank.INFRACLASS())) { result = Bacteria_STR_Infraclass; }
2919                         else if (rank.equals(Rank.SUPERORDER())) { result = Bacteria_STR_Superorder; }
2920                         else if (rank.equals(Rank.ORDER())) { result = Bacteria_STR_Order; }
2921                         else if (rank.equals(Rank.SUBORDER())) { result = Bacteria_STR_Suborder; }
2922                         else if (rank.equals(Rank.INFRAORDER())) { result = Bacteria_STR_Infraorder; }
2923                         else if (rank.equals(Rank.SUPERFAMILY())) { result = Bacteria_STR_Superfamily; }
2924                         else if (rank.equals(Rank.FAMILY())) { result = Bacteria_STR_Family; }
2925                         else if (rank.equals(Rank.SUBFAMILY())) { result = Bacteria_STR_Subfamily; }
2926                         else if (rank.equals(Rank.TRIBE())) { result = Bacteria_STR_Tribe; }
2927                         else if (rank.equals(Rank.SUBTRIBE())) { result = Bacteria_STR_Subtribe; }
2928                         else if (rank.equals(Rank.GENUS())) { result = Bacteria_STR_Genus; }
2929                         else if (rank.equals(Rank.SUBGENUS())) { result = Bacteria_STR_Subgenus; }
2930                         else if (rank.equals(Rank.SPECIES())) { result = Bacteria_STR_Species; }
2931                         else if (rank.equals(Rank.SUBSPECIES())) { result = Bacteria_STR_Subspecies; }
2932                         else if (rank.equals(Rank.VARIETY())) { result = Bacteria_STR_Variety; }
2933                         else if (rank.equals(Rank.FORM())) { result = Bacteria_STR_Forma; }
2934                 } else {
2935                         //TODO Exception
2936                         logger.warn("Kingdom not yet supported in CDM: "+ pesiKingdomId);
2937                         return null;
2938                 }
2939                 return result;
2940         }
2941
2942         /**
2943          * Returns the abbreviation for a given rank.
2944          * @param rank
2945          * @param pesiKingdomId
2946          * @return
2947          */
2948         public static String rank2RankAbbrev(Rank rank, Integer pesiKingdomId) {
2949                 String result = null;
2950                 if (rank == null) {
2951                         return null;
2952                 }
2953
2954                 // We differentiate between Animalia and Plantae only for now.
2955                 if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_ANIMALIA) {
2956                         if (rank.equals(Rank.SUBGENUS())) {
2957                                 result = Animalia_Abbrev_Subgenus;
2958                         } else if (rank.equals(Rank.SPECIES())) {
2959                                 result = Animalia_Abbrev_Species;
2960                         } else if (rank.equals(Rank.SUBSPECIES())) {
2961                                 result = Animalia_Abbrev_Subspecies;
2962 //                      } else if (rank.equals(Rank.)) { // not yet specified
2963 //                              result = Animalia_STR_Natio;
2964                         } else if (rank.equals(Rank.VARIETY())) {
2965                                 result = Animalia_Abbrev_Variety;
2966                         } else if (rank.equals(Rank.SUBVARIETY())) {
2967                                 result = Animalia_Abbrev_Subvariety;
2968                         } else if (rank.equals(Rank.FORM())) {
2969                                 result = Animalia_Abbrev_Forma;
2970                         } else {
2971                                 //TODO Exception
2972                                 logger.warn("Abbreviation for Rank of Kingdom Animalia not supported in CDM: "+ rank.getLabel());
2973                                 return null;
2974                         }
2975                 } else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_PLANTAE) {
2976                         if (rank.equals(Rank.KINGDOM())) {
2977                                 result = Plantae_Abbrev_Kingdom;
2978                         } else if (rank.equals(Rank.SUBKINGDOM())) {
2979                                 result = Plantae_Abbrev_Subkingdom;
2980                         } else if (rank.equals(Rank.DIVISION())) {
2981                                 result = Plantae_Abbrev_Division;
2982                         } else if (rank.equals(Rank.SUBDIVISION())) {
2983                                 result = Plantae_Abbrev_Subdivision;
2984                         } else if (rank.equals(Rank.CLASS())) {
2985                                 result = Plantae_Abbrev_Class;
2986                         } else if (rank.equals(Rank.SUBCLASS())) {
2987                                 result = Plantae_Abbrev_Subclass;
2988                         } else if (rank.equals(Rank.ORDER())) {
2989                                 result = Plantae_Abbrev_Order;
2990                         } else if (rank.equals(Rank.SUBORDER())) {
2991                                 result = Plantae_Abbrev_Suborder;
2992                         } else if (rank.equals(Rank.FAMILY())) {
2993                                 result = Plantae_Abbrev_Family;
2994                         } else if (rank.equals(Rank.SUBFAMILY())) {
2995                                 result = Plantae_Abbrev_Subfamily;
2996                         } else if (rank.equals(Rank.TRIBE())) {
2997                                 result = Plantae_Abbrev_Tribe;
2998                         } else if (rank.equals(Rank.SUBTRIBE())) {
2999                                 result = Plantae_Abbrev_Subtribe;
3000                         } else if (rank.equals(Rank.GENUS())) {
3001                                 result = Plantae_Abbrev_Genus;
3002                         } else if (rank.equals(Rank.SUBGENUS())) {
3003                                 result = Plantae_Abbrev_Subgenus;
3004                         } else if (rank.equals(Rank.SECTION_BOTANY())) {
3005                                 result = Plantae_Abbrev_Section;
3006                         } else if (rank.equals(Rank.SUBSECTION_BOTANY())) {
3007                                 result = Plantae_Abbrev_Subsection;
3008                         } else if (rank.equals(Rank.SERIES())) {
3009                                 result = Plantae_Abbrev_Series;
3010                         } else if (rank.equals(Rank.SUBSERIES())) {
3011                                 result = Plantae_Abbrev_Subseries;
3012                         } else if (rank.equals(Rank.SPECIESAGGREGATE() )) {
3013                                 result = Plantae_Abbrev_Aggregate;
3014                         } else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankCollSpecies)) {
3015                                 result = Plantae_Abbrev_Coll_Species;
3016                         } else if (rank.equals(Rank.SPECIES())) {
3017                                 result = Plantae_Abbrev_Species;
3018                         } else if (rank.equals(Rank.GREX())) {
3019                                 result = Plantae_Abbrev_Grex;
3020                         } else if (rank.equals(Rank.SUBSPECIES())) {
3021                                 result = Plantae_Abbrev_Subspecies;
3022                         } else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankProles)) {
3023                                 result = Plantae_Abbrev_Proles;
3024                         } else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankRace)) {
3025                                 result = Plantae_Abbrev_Race;
3026                         } else if (rank.equals(Rank.CONVAR())) {
3027                                 result = Plantae_Abbrev_Convarietas;
3028                         } else if (rank.equals(Rank.VARIETY())) {
3029                                 result = Plantae_Abbrev_Variety;
3030                         } else if (rank.equals(Rank.SUBVARIETY())) {
3031                                 result = Plantae_Abbrev_Subvariety;
3032                         } else if (rank.equals(Rank.FORM())) {
3033                                 result = Plantae_Abbrev_Forma;
3034                         } else if (rank.equals(Rank.SUBFORM())) {
3035                                 result = Plantae_Abbrev_Subforma;
3036 //                      } else if (rank.equals(Rank.)) { // not yet specified
3037 //                              result = Plantae_Abbrev_Forma_spec;
3038                         } else if (rank.equals(Rank.INFRAGENERICTAXON())) {
3039                                 result = Plantae_Abbrev_Taxa_infragen;
3040                         } else if (rank.equals(Rank.INFRASPECIFICTAXON())) {
3041                                 result = Plantae_Abbrev_Taxa_infraspec;
3042                         } else {
3043                                 //TODO Exception
3044                                 logger.warn("Abbreviation for Rank of Kingdom Plantae not supported in CDM: "+ rank.getLabel());
3045                                 return null;
3046                         }
3047                 } else {
3048                         //TODO Exception
3049                         logger.warn("Kingdom not yet supported in CDM: "+ pesiKingdomId);
3050                         return null;
3051                 }
3052                 return result;
3053         }
3054
3055         /**
3056          * Returns the identifier of a PESI specific kingdom for a given CDM nomenclatural code.
3057          * @param nomenclaturalCode
3058          * @return KINGDOM_ANIMALIA for NomenclaturalCode.ICZN, KINGDOM_PLANTAE for NomenclaturalCode.ICBN
3059          */
3060         public static Integer nomenClaturalCode2Kingdom(NomenclaturalCode nomenclaturalCode) {
3061                 Integer result = null;
3062                 // TODO: This needs to be refined. For now we differentiate between Animalia and Plantae only.
3063                 if (nomenclaturalCode.equals(NomenclaturalCode.ICZN)) {
3064                         result = KINGDOM_ANIMALIA;
3065                 } else if (nomenclaturalCode.equals(NomenclaturalCode.ICBN)) {
3066                         result = KINGDOM_PLANTAE;
3067                 } else if (nomenclaturalCode.equals(NomenclaturalCode.ICNB)) {
3068                         result = KINGDOM_BACTERIA;
3069 //              } else if (nomenclaturalCode.equals(NomenclaturalCode.)) { // Biota
3070 //                      result =
3071                 } else {
3072                         logger.error("NomenclaturalCode not yet considered: " + nomenclaturalCode.getUuid() + " (" +  nomenclaturalCode.getTitleCache() + ")");
3073                 }
3074                 return result;
3075         }
3076
3077         /**
3078          * Returns the RankId for a Rank.
3079          * @param rank
3080          * @return
3081          */
3082         public static Integer rank2RankId (Rank rank, Integer pesiKingdomId) {
3083                 Integer result = null;
3084                 if (rank == null) {
3085                         return null;
3086                 }
3087
3088                 // We differentiate between Animalia and Plantae only for now.
3089                 if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_ANIMALIA) {
3090                         if (rank.equals(Rank.KINGDOM())) {
3091                                 result = Animalia_Kingdom;
3092                         } else if (rank.equals(Rank.SUBKINGDOM())) {
3093                                 result = Animalia_Subkingdom;
3094                         } else if (rank.equals(Rank.SUPERPHYLUM())) {
3095                                 result = Animalia_Superphylum;
3096                         } else if (rank.equals(Rank.PHYLUM())) {
3097                                 result = Animalia_Phylum;
3098                         } else if (rank.equals(Rank.SUBPHYLUM())) {
3099                                 result = Animalia_Subphylum;
3100                         } else if (rank.equals(Rank.INFRAPHYLUM())) {
3101                                 result = Animalia_Infraphylum;
3102                         } else if (rank.equals(Rank.SUPERCLASS())) {
3103                                 result = Animalia_Superclass;
3104                         } else if (rank.equals(Rank.CLASS())) {
3105                                 result = Animalia_Class;
3106                         } else if (rank.equals(Rank.SUBCLASS())) {
3107                                 result = Animalia_Subclass;
3108                         } else if (rank.equals(Rank.INFRACLASS())) {
3109                                 result = Animalia_Infraclass;
3110                         } else if (rank.equals(Rank.SUPERORDER())) {
3111                                 result = Animalia_Superorder;
3112                         } else if (rank.equals(Rank.ORDER())) {
3113                                 result = Animalia_Order;
3114                         } else if (rank.equals(Rank.SUBORDER())) {
3115                                 result = Animalia_Suborder;
3116                         } else if (rank.equals(Rank.INFRAORDER())) {
3117                                 result = Animalia_Infraorder;
3118                         } else if (rank.equals(Rank.SECTION_ZOOLOGY())) {
3119                                 result = Animalia_Section;
3120                         } else if (rank.equals(Rank.SUBSECTION_ZOOLOGY())) {
3121                                 result = Animalia_Subsection;
3122                         } else if (rank.equals(Rank.SUPERFAMILY())) {
3123                                 result = Animalia_Superfamily;
3124                         } else if (rank.equals(Rank.FAMILY())) {
3125                                 result = Animalia_Family;
3126                         } else if (rank.equals(Rank.SUBFAMILY())) {
3127                                 result = Animalia_Subfamily;
3128                         } else if (rank.equals(Rank.TRIBE())) {
3129                                 result = Animalia_Tribe;
3130                         } else if (rank.equals(Rank.SUBTRIBE())) {
3131                                 result = Animalia_Subtribe;
3132                         } else if (rank.equals(Rank.GENUS())) {
3133                                 result = Animalia_Genus;
3134                         } else if (rank.equals(Rank.SUBGENUS())) {
3135                                 result = Animalia_Subgenus;
3136                         } else if (rank.equals(Rank.SPECIES())) {
3137                                 result = Animalia_Species;
3138                         } else if (rank.equals(Rank.SUBSPECIES())) {
3139                                 result = Animalia_Subspecies;
3140 //                      } else if (rank.equals(Rank.)) { // not yet specified
3141 //                              result = Animalia_Natio;
3142                         } else if (rank.equals(Rank.VARIETY())) {
3143                                 result = Animalia_Variety;
3144                         } else if (rank.equals(Rank.SUBVARIETY())) {
3145                                 result = Animalia_Subvariety;
3146                         } else if (rank.equals(Rank.FORM())) {
3147                                 result = Animalia_Forma;
3148                         } else {
3149                                 //TODO Exception
3150                                 logger.warn("Rank for Kingdom Animalia not yet supported in CDM: "+ rank.getLabel());
3151                                 return null;
3152                         }
3153                 } else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_PLANTAE) {
3154                         if (rank.equals(Rank.KINGDOM())) {
3155                                 result = Plantae_Kingdom;
3156                         } else if (rank.equals(Rank.SUBKINGDOM())) {
3157                                 result = Plantae_Subkingdom;
3158                         } else if (rank.equals(Rank.DIVISION())) {
3159                                 result = Plantae_Division;
3160                         } else if (rank.equals(Rank.SUBDIVISION())) {
3161                                 result = Plantae_Subdivision;
3162                         } else if (rank.equals(Rank.CLASS())) {
3163                                 result = Plantae_Class;
3164                         } else if (rank.equals(Rank.SUBCLASS())) {
3165                                 result = Plantae_Subclass;
3166                         } else if (rank.equals(Rank.ORDER())) {
3167                                 result = Plantae_Order;
3168                         } else if (rank.equals(Rank.SUBORDER())) {
3169                                 result = Plantae_Suborder;
3170                         } else if (rank.equals(Rank.FAMILY())) {
3171                                 result = Plantae_Family;
3172                         } else if (rank.equals(Rank.SUBFAMILY())) {
3173                                 result = Plantae_Subfamily;
3174                         } else if (rank.equals(Rank.TRIBE())) {
3175                                 result = Plantae_Tribe;
3176                         } else if (rank.equals(Rank.SUBTRIBE())) {
3177                                 result = Plantae_Subtribe;
3178                         } else if (rank.equals(Rank.GENUS())) {
3179                                 result = Plantae_Genus;
3180                         } else if (rank.equals(Rank.SUBGENUS())) {
3181                                 result = Plantae_Subgenus;
3182                         } else if (rank.equals(Rank.SECTION_BOTANY())) {
3183                                 result = Plantae_Section;
3184                         } else if (rank.equals(Rank.SUBSECTION_BOTANY())) {
3185                                 result = Plantae_Subsection;
3186                         } else if (rank.equals(Rank.SERIES())) {
3187                                 result = Plantae_Series;
3188                         } else if (rank.equals(Rank.SUBSERIES())) {
3189                                 result = Plantae_Subseries;
3190                         } else if (rank.equals(Rank.SPECIESAGGREGATE() )) {
3191                                 result = Plantae_Aggregate;
3192                         } else if (rank.equals(Rank.SPECIESGROUP())) {
3193                                 logger.warn("Rank Species Group not yet implemented");
3194                                 result = null;
3195                         } else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankCollSpecies)) {
3196                                 result = Plantae_Coll_Species;
3197                         } else if (rank.equals(Rank.SPECIES())) {
3198                                 result = Plantae_Species;
3199                         } else if (rank.equals(Rank.SUBSPECIES())) {
3200                                 result = Plantae_Subspecies;
3201                         } else if (rank.equals(Rank.GREX())) {
3202                                 result = Plantae_Grex;
3203                         } else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankProles) ) {
3204                                 result = Plantae_Proles;
3205                         } else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankRace)) {
3206                                 result = Plantae_Race;
3207                         } else if (rank.equals(Rank.CONVAR())) {
3208                                 result = Plantae_Convarietas;
3209                         } else if (rank.equals(Rank.VARIETY())) {
3210                                 result = Plantae_Variety;
3211                         } else if (rank.equals(Rank.SUBVARIETY())) {
3212                                 result = Plantae_Subvariety;
3213                         } else if (rank.equals(Rank.FORM())) {
3214                                 result = Plantae_Forma;
3215                         } else if (rank.equals(Rank.SUBFORM())) {
3216                                 result = Plantae_Subforma;
3217 //                      } else if (rank.equals(Rank.)) { // not yet specified
3218 //                              result = Plantae_Forma_spec;
3219                         } else if (rank.equals(Rank.INFRAGENERICTAXON())) {
3220                                 result = Plantae_Taxa_infragen;
3221                         } else if (rank.equals(Rank.INFRASPECIFICTAXON())) {
3222                                 result = Plantae_Taxa_infraspec;
3223                         } else {
3224                                 //TODO Exception
3225                                 logger.warn("Rank for Kingdom Plantae not yet supported in CDM: "+ rank.getLabel());
3226                                 return null;
3227                         }
3228                 } else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_BACTERIA) {
3229                         if (rank.equals(Rank.KINGDOM())) { result = Bacteria_Kingdom; }
3230                         else if (rank.equals(Rank.SUBKINGDOM())) { result = Bacteria_Subkingdom; }
3231                         else if (rank.equals(Rank.PHYLUM())) { result = Bacteria_Phylum; }
3232                         else if (rank.equals(Rank.SUBPHYLUM())) { result = Bacteria_Subphylum; }
3233                         else if (rank.equals(Rank.SUPERCLASS())) { result = Bacteria_Superclass; }
3234                         else if (rank.equals(Rank.CLASS())) { result = Bacteria_Class; }
3235                         else if (rank.equals(Rank.SUBCLASS())) { result = Bacteria_Subclass; }
3236                         else if (rank.equals(Rank.INFRACLASS())) { result = Bacteria_Infraclass; }
3237                         else if (rank.equals(Rank.SUPERORDER())) { result = Bacteria_Superorder; }
3238                         else if (rank.equals(Rank.ORDER())) { result = Bacteria_Order; }
3239                         else if (rank.equals(Rank.SUBORDER())) { result = Bacteria_Suborder; }
3240                         else if (rank.equals(Rank.INFRAORDER())) { result = Bacteria_Infraorder; }
3241                         else if (rank.equals(Rank.SUPERFAMILY())) { result = Bacteria_Superfamily; }
3242                         else if (rank.equals(Rank.FAMILY())) { result = Bacteria_Family; }
3243                         else if (rank.equals(Rank.SUBFAMILY())) { result = Bacteria_Subfamily; }
3244                         else if (rank.equals(Rank.TRIBE())) { result = Bacteria_Tribe; }
3245                         else if (rank.equals(Rank.SUBTRIBE())) { result = Bacteria_Subtribe; }
3246                         else if (rank.equals(Rank.GENUS())) { result = Bacteria_Genus; }
3247                         else if (rank.equals(Rank.SUBGENUS())) { result = Bacteria_Subgenus; }
3248                         else if (rank.equals(Rank.SPECIES())) { result = Bacteria_Species; }
3249                         else if (rank.equals(Rank.SUBSPECIES())) { result = Bacteria_Subspecies; }
3250                         else if (rank.equals(Rank.VARIETY())) { result = Bacteria_Variety; }
3251                         else if (rank.equals(Rank.FORM())) { result = Bacteria_Forma; }
3252                 } else {
3253                         //TODO Exception
3254                         logger.warn("Kingdom not yet supported in CDM: "+ pesiKingdomId);
3255                         return null;
3256                 }
3257                 return result;
3258         }
3259
3260         /**
3261          *
3262          * @param nameTypeDesignationStatus
3263          * @return
3264          */
3265         public static Integer nameTypeDesignationStatus2TypeDesignationStatusId(NameTypeDesignationStatus nameTypeDesignationStatus) {
3266                 if (nameTypeDesignationStatus == null) {
3267                         return null;
3268                 }
3269                 if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.ORIGINAL_DESIGNATION())) {
3270                         return TYPE_BY_ORIGINAL_DESIGNATION;
3271                 } else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.SUBSEQUENT_DESIGNATION())) {
3272                         return TYPE_BY_SUBSEQUENT_DESIGNATION;
3273                 } else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.MONOTYPY())) {
3274                         return TYPE_BY_MONOTYPY;
3275                 } else {
3276                         //TODO Figure out a way to handle this gracefully.
3277                         logger.warn("Name Type Designation Status not yet supported in PESI: "+ nameTypeDesignationStatus.getLabel());
3278                         return null;
3279                 }
3280
3281         }
3282
3283         /**
3284          *
3285          * @param nameTypeDesignationStatus
3286          * @return
3287          */
3288         public static String nameTypeDesignationStatus2TypeDesignationStatusCache(NameTypeDesignationStatus nameTypeDesignationStatus) {
3289                 if (nameTypeDesignationStatus == null) {
3290                         return null;
3291                 }
3292                 if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.ORIGINAL_DESIGNATION())) {
3293                         return TYPE_STR_BY_ORIGINAL_DESIGNATION;
3294                 } else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.SUBSEQUENT_DESIGNATION())) {
3295                         return TYPE_STR_BY_SUBSEQUENT_DESIGNATION;
3296                 } else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.MONOTYPY())) {
3297                         return TYPE_STR_BY_MONOTYPY;
3298                 } else {
3299                         //TODO Figure out a way to handle this gracefully.
3300                         logger.warn("Name Type Designation Status not yet supported in PESI: "+ nameTypeDesignationStatus.getLabel());
3301                         return null;
3302                 }
3303
3304         }
3305
3306         /**
3307          *
3308          * @param taxonBase
3309          * @return
3310          */
3311         public static Integer taxonBase2statusFk (TaxonBase<?> taxonBase){
3312                 if (taxonBase == null){return null;}
3313                 if (taxonBase.isInstanceOf(Taxon.class)){
3314                         return T_STATUS_ACCEPTED;
3315                 }else if (taxonBase.isInstanceOf(Synonym.class)){
3316                         return T_STATUS_SYNONYM;
3317                 }else{
3318                         logger.warn("Unknown ");
3319                         return T_STATUS_UNRESOLVED;
3320                 }
3321                 //TODO
3322 //              public static int T_STATUS_PARTIAL_SYN = 3;
3323 //              public static int T_STATUS_PRO_PARTE_SYN = 4;
3324 //              public static int T_STATUS_UNRESOLVED = 5;
3325 //              public static int T_STATUS_ORPHANED = 6;
3326         }
3327
3328         /**
3329          *
3330          * @param taxonBase
3331          * @return
3332          */
3333         public static String taxonBase2statusCache (TaxonBase<?> taxonBase){
3334                 if (taxonBase == null){return null;}
3335                 if (taxonBase.isInstanceOf(Taxon.class)){
3336                         return T_STATUS_STR_ACCEPTED;
3337                 }else if (taxonBase.isInstanceOf(Synonym.class)){
3338                         return T_STATUS_STR_SYNONYM;
3339                 }else{
3340                         logger.warn("Unknown ");
3341                         return T_STATUS_STR_UNRESOLVED;
3342                 }
3343                 //TODO
3344 //              public static int T_STATUS_STR_PARTIAL_SYN = 3;
3345 //              public static int T_STATUS_STR_PRO_PARTE_SYN = 4;
3346 //              public static int T_STATUS_STR_UNRESOLVED = 5;
3347 //              public static int T_STATUS_STR_ORPHANED = 6;
3348         }
3349
3350         /**
3351          * Returns the {@link SourceCategory SourceCategory} representation of the given {@link ReferenceType ReferenceType} in PESI.
3352          * @param reference The {@link Reference Reference}.
3353          * @return The {@link SourceCategory SourceCategory} representation in PESI.
3354          */
3355         public static Integer reference2SourceCategoryFK(Reference<?> reference) {
3356                 if (reference == null){
3357                         return null;
3358                 } else if (reference.getType().equals(ReferenceType.Article)) {
3359                         return REF_ARTICLE_IN_PERIODICAL;
3360                 } else if (reference.getType().equals(ReferenceType.Book)) {
3361                         return REF_BOOK;
3362                 } else if (reference.getType().equals(ReferenceType.BookSection)) {
3363                         return REF_PART_OF_OTHER;
3364                 } else if (reference.getType().equals(ReferenceType.Database)) {
3365                         return REF_DATABASE;
3366                 } else if (reference.getType().equals(ReferenceType.WebPage)) {
3367                         return REF_WEBSITE;
3368                 } else if (reference.getType().equals(ReferenceType.CdDvd)) {
3369                         return REF_NOT_APPLICABLE;
3370                 } else if (reference.getType().equals(ReferenceType.Journal)) {
3371                         return REF_JOURNAL;
3372                 } else if (reference.getType().equals(ReferenceType.Generic)) {
3373                         return REF_UNRESOLVED;
3374                 } else if (reference.getType().equals(ReferenceType.PrintSeries)) {
3375                         return REF_PUBLISHED;
3376                 } else if (reference.getType().equals(ReferenceType.Proceedings)) {
3377                         return REF_PUBLISHED;
3378                 } else if (reference.getType().equals(ReferenceType.Patent)) {
3379                         return REF_NOT_APPLICABLE;
3380                 } else if (reference.getType().equals(ReferenceType.PersonalCommunication)) {
3381                         return REF_INFORMAL;
3382                 } else if (reference.getType().equals(ReferenceType.Report)) {
3383                         return REF_NOT_APPLICABLE;
3384                 } else if (reference.getType().equals(ReferenceType.Thesis)) {
3385                         return REF_NOT_APPLICABLE;
3386                 } else {
3387                         logger.warn("Reference type not yet supported in PESI: "+ reference.getType());
3388                         return null;
3389                 }
3390         }
3391
3392         /**
3393          * Returns the {@link SourceCategoryCache SourceCategoryCache}.
3394          * @param reference The {@link Reference Reference}.
3395          * @return The {@link SourceCategoryCache SourceCategoryCache}.
3396          */
3397         public static String getSourceCategoryCache(Reference<?> reference) {
3398                 if (reference == null){
3399                         return null;
3400                 } else if (reference.getType().equals(ReferenceType.Article)) {
3401                         return REF_STR_ARTICLE_IN_PERIODICAL;
3402                 } else if (reference.getType().equals(ReferenceType.Book)) {
3403                         return REF_STR_BOOK;
3404                 } else if (reference.getType().equals(ReferenceType.BookSection)) {
3405                         return REF_STR_PART_OF_OTHER;
3406                 } else if (reference.getType().equals(ReferenceType.Database)) {
3407                         return REF_STR_DATABASE;
3408                 } else if (reference.getType().equals(ReferenceType.WebPage)) {
3409                         return REF_STR_WEBSITE;
3410                 } else if (reference.getType().equals(ReferenceType.CdDvd)) {
3411                         return REF_STR_NOT_APPLICABLE;
3412                 } else if (reference.getType().equals(ReferenceType.Journal)) {
3413                         return REF_STR_JOURNAL;
3414                 } else if (reference.getType().equals(ReferenceType.Generic)) {
3415                         return REF_STR_UNRESOLVED;
3416                 } else if (reference.getType().equals(ReferenceType.PrintSeries)) {
3417                         return REF_STR_PUBLISHED;
3418                 } else if (reference.getType().equals(ReferenceType.Proceedings)) {
3419                         return REF_STR_PUBLISHED;
3420                 } else if (reference.getType().equals(ReferenceType.Patent)) {
3421                         return REF_STR_NOT_APPLICABLE;
3422                 } else if (reference.getType().equals(ReferenceType.PersonalCommunication)) {
3423                         return REF_STR_INFORMAL;
3424                 } else if (reference.getType().equals(ReferenceType.Report)) {
3425                         return REF_STR_NOT_APPLICABLE;
3426                 } else if (reference.getType().equals(ReferenceType.Thesis)) {
3427                         return REF_STR_NOT_APPLICABLE;
3428                 } else {
3429                         logger.warn("Reference type not yet supported in PESI: "+ reference.getType());
3430                         return null;
3431                 }
3432         }
3433
3434         /**
3435          *
3436          * @param status
3437          * @return
3438          */
3439         public String getCacheByNomStatus(NomenclaturalStatusType status) {
3440                 if (status == null){
3441                         return null;
3442                 }else{
3443                         return this.nameStatusCacheMap.get(nomStatus2nomStatusFk(status));
3444                 }
3445         }
3446
3447         /**
3448          *
3449          * @param status
3450          * @return
3451          */
3452         public static Integer nomStatus2nomStatusFk (NomenclaturalStatusType status){
3453                 if (status == null){
3454                         return null;
3455                 }
3456                 if (status.equals(NomenclaturalStatusType.INVALID())) {return NAME_ST_NOM_INVAL;
3457                 }else if (status.equals(NomenclaturalStatusType.ILLEGITIMATE())) {return NAME_ST_NOM_ILLEG;
3458                 }else if (status.equals(NomenclaturalStatusType.NUDUM())) {return NAME_ST_NOM_NUD;
3459                 }else if (status.equals(NomenclaturalStatusType.REJECTED())) {return NAME_ST_NOM_REJ;
3460                 }else if (status.equals(NomenclaturalStatusType.REJECTED_PROP())) {return NAME_ST_NOM_REJ_PROP;
3461                 }else if (status.equals(NomenclaturalStatusType.UTIQUE_REJECTED())) {return NAME_ST_NOM_UTIQUE_REJ;
3462                 }else if (status.equals(NomenclaturalStatusType.UTIQUE_REJECTED_PROP())) {return NAME_ST_NOM_UTIQUE_REJ_PROP;
3463                 }else if (status.equals(NomenclaturalStatusType.CONSERVED())) {return NAME_ST_NOM_CONS;
3464
3465                 }else if (status.equals(NomenclaturalStatusType.CONSERVED_PROP())) {return NAME_ST_NOM_CONS_PROP;
3466                 }else if (status.equals(NomenclaturalStatusType.ORTHOGRAPHY_CONSERVED())) {return NAME_ST_ORTH_CONS;
3467                 }else if (status.equals(NomenclaturalStatusType.ORTHOGRAPHY_CONSERVED_PROP())) {return NAME_ST_ORTH_CONS_PROP;
3468                 }else if (status.equals(NomenclaturalStatusType.SUPERFLUOUS())) {return NAME_ST_NOM_SUPERFL;
3469                 }else if (status.equals(NomenclaturalStatusType.AMBIGUOUS())) {return NAME_ST_NOM_AMBIG;
3470                 }else if (status.equals(NomenclaturalStatusType.PROVISIONAL())) {return NAME_ST_NOM_PROVIS;
3471                 }else if (status.equals(NomenclaturalStatusType.DOUBTFUL())) {return NAME_ST_NOM_DUB;
3472                 }else if (status.equals(NomenclaturalStatusType.NOVUM())) {return NAME_ST_NOM_NOV;
3473
3474                 }else if (status.equals(NomenclaturalStatusType.CONFUSUM())) {return NAME_ST_NOM_CONFUS;
3475                 }else if (status.equals(NomenclaturalStatusType.ALTERNATIVE())) {return NAME_ST_NOM_ALTERN;
3476                 }else if (status.equals(NomenclaturalStatusType.COMBINATION_INVALID())) {return NAME_ST_COMB_INVAL;
3477                 }else if (status.equals(NomenclaturalStatusType.LEGITIMATE())) {return NAME_ST_LEGITIMATE;
3478
3479                 }else if (status.getUuid().equals(BerlinModelTransformer.uuidNomStatusCombIned)) {return NAME_ST_COMB_INED;
3480                 }else if (status.getUuid().equals(BerlinModelTransformer.uuidNomStatusNomOrthCons)) {return NAME_ST_NOM_AND_ORTH_CONS;
3481                 }else if (status.getUuid().equals(BerlinModelTransformer.uuidNomStatusSpNovIned)) {return NAME_ST_SP_NOV_INED;
3482
3483
3484                 // The following are non-existent in CDM
3485 //              }else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_COMB_AND_STAT_INED;
3486 //              }else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_NOM_NOV_INED;
3487 //              }else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_ALTERNATE_REPRESENTATION;
3488 //              }else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_TEMPORARY_NAME;
3489 //              }else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_SPECIES_INQUIRENDA;
3490
3491                 //TODO
3492                 }else {
3493                         //TODO Exception
3494                         logger.warn("NomStatus type not yet supported by PESI export: "+ status);
3495                         return null;
3496                 }
3497         }
3498
3499         /**
3500          * Returns the RelTaxonQualifierCache for a given taxonRelation.
3501          * @param relation
3502          * @return
3503          */
3504         public String getCacheByRelationshipType(RelationshipBase relation, NomenclaturalCode code){
3505                 if (relation == null){
3506                         return null;
3507                 }else{
3508                         String result;
3509                         Integer key = taxonRelation2RelTaxonQualifierFk(relation);
3510                         if (code.equals(NomenclaturalCode.ICZN)){
3511                                 result = this.taxRelZooQualifierCacheMap.get(key);
3512                                 if (result == null){
3513                                         this.taxRelQualifierCacheMap.get(key);
3514                                 }
3515                         }else{
3516                                 result = this.taxRelQualifierCacheMap.get(key);
3517                         }
3518                         return result;
3519                 }
3520         }
3521
3522         /**
3523          * Returns the RelTaxonQualifierFk for a TaxonRelation.
3524          * @param relation
3525          * @return
3526          */
3527         public static Integer taxonRelation2RelTaxonQualifierFk(RelationshipBase<?,?,?> relation) {
3528                 if (relation == null) {
3529                         return null;
3530                 }
3531                 RelationshipTermBase<?> type = relation.getType();
3532                 if (type.equals(TaxonRelationshipType.MISAPPLIED_NAME_FOR())) {
3533                         return IS_MISAPPLIED_NAME_FOR;
3534                 } else if (type.equals(SynonymRelationshipType.SYNONYM_OF())) {
3535                         SynonymRelationship synRel = CdmBase.deproxy(relation, SynonymRelationship.class);
3536                         if (synRel.isProParte()){
3537                                 return IS_PRO_PARTE_SYNONYM_OF;
3538                         }else if (synRel.isPartial()){
3539                                 return IS_PARTIAL_SYNONYM_OF;
3540                         }else{
3541                                 return IS_SYNONYM_OF;
3542                         }
3543                 } else if (type.equals(SynonymRelationshipType.HOMOTYPIC_SYNONYM_OF())) {
3544                         SynonymRelationship synRel = CdmBase.deproxy(relation, SynonymRelationship.class);
3545                         if (synRel.isProParte()){
3546                                 return IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF;
3547                         }else if (synRel.isPartial()){
3548                                 return IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF;
3549                         }else{
3550                                 return IS_HOMOTYPIC_SYNONYM_OF;
3551                         }
3552                 } else if (type.equals(SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF())) {
3553                         SynonymRelationship synRel = CdmBase.deproxy(relation, SynonymRelationship.class);
3554                         if (synRel.isProParte()){
3555                                 return IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF;
3556                         }else if (synRel.isPartial()){
3557                                 return IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF;
3558                         }else{
3559                                 return IS_HETEROTYPIC_SYNONYM_OF;
3560                         }
3561                 } else if (type.equals(SynonymRelationshipType.INFERRED_EPITHET_OF())) {
3562                         return IS_INFERRED_EPITHET_FOR;
3563                 } else if (type.equals(SynonymRelationshipType.INFERRED_GENUS_OF())) {
3564                         return IS_INFERRED_GENUS_FOR;
3565                 } else if (type.equals(SynonymRelationshipType.POTENTIAL_COMBINATION_OF())) {
3566                         return IS_POTENTIAL_COMBINATION_FOR;
3567                 } else if (type.equals(NameRelationshipType.BASIONYM())) {
3568                         return IS_BASIONYM_FOR;
3569                 } else if (type.equals(NameRelationshipType.LATER_HOMONYM())) {
3570                         return IS_LATER_HOMONYM_OF;
3571                 } else if (type.equals(NameRelationshipType.REPLACED_SYNONYM())) {
3572                         return IS_REPLACED_SYNONYM_FOR;
3573                 } else if (type.equals(NameRelationshipType.VALIDATED_BY_NAME())) {
3574                         return IS_VALIDATION_OF;
3575                 } else if (type.equals(NameRelationshipType.LATER_VALIDATED_BY_NAME())) {
3576                         return IS_LATER_VALIDATION_OF;
3577                 } else if (type.equals(NameRelationshipType.CONSERVED_AGAINST())) {
3578                         return IS_CONSERVED_AGAINST;
3579                 } else if (type.equals(NameRelationshipType.TREATED_AS_LATER_HOMONYM())) {
3580                         return IS_TREATED_AS_LATER_HOMONYM_OF;
3581                 } else if (type.equals(NameRelationshipType.ORTHOGRAPHIC_VARIANT())) {
3582                         return IS_ORTHOGRAPHIC_VARIANT_OF;
3583                 } else if (type.equals(NameRelationshipType.ALTERNATIVE_NAME())) {
3584                         return IS_ALTERNATIVE_NAME_FOR;
3585                 } else if (type.equals(HybridRelationshipType.FEMALE_PARENT())) {
3586                         return IS_FEMALE_PARENT_OF;
3587                 } else if (type.equals(HybridRelationshipType.MALE_PARENT())) {
3588                         return IS_MALE_PARENT_OF;
3589                 } else if (type.equals(HybridRelationshipType.FIRST_PARENT())) {
3590                         return IS_FIRST_PARENT_OF;
3591                 } else if (type.equals(HybridRelationshipType.SECOND_PARENT())) {
3592                         return IS_SECOND_PARENT_OF;
3593
3594                 } else {
3595                         logger.warn("No equivalent RelationshipType found in datawarehouse for: " + type.getTitleCache());
3596                 }
3597
3598                 // The following have no equivalent attribute in CDM
3599 //              IS_TYPE_OF
3600 //              IS_CONSERVED_TYPE_OF
3601 //              IS_REJECTED_TYPE_OF
3602 //              IS_REJECTED_IN_FAVOUR_OF
3603 //              HAS_SAME_TYPE_AS
3604 //              IS_LECTOTYPE_OF
3605 //              TYPE_NOT_DESIGNATED
3606
3607
3608                 return null;
3609         }
3610
3611         /**
3612          * Returns the StatusFk for a given StatusCache.
3613          * @param StatusCache
3614          * @return
3615          */
3616         public Integer StatusCache2StatusFk(String StatusCache) {
3617                 Integer result = null;
3618                 if (StatusCache.equalsIgnoreCase("Checked by Taxonomic Editor: included in ERMS 1.1")) {
3619                         return 0;
3620                 } else if (StatusCache.equalsIgnoreCase("Added by Database Management Team")) {
3621                         return 2;
3622                 } else if (StatusCache.equalsIgnoreCase("Checked by Taxonomic Editor")) {
3623                         return 3;
3624                 } else if (StatusCache.equalsIgnoreCase("Edited by Database Management Team")) {
3625                         return 4;
3626                 } else {
3627                         logger.error("StatusFk could not be determined. StatusCache unknown: " + StatusCache);
3628                 }
3629
3630                 return result;
3631         }
3632
3633         /**
3634          * Returns the FossilStatusFk for a given FossilStatusCache.
3635          * @param fossilStatusCache
3636          * @return
3637          */
3638         public Integer FossilStatusCache2FossilStatusFk(String fossilStatusCache) {
3639                 Integer result = null;
3640                 if (fossilStatusCache.equalsIgnoreCase("recent only")) {
3641                         return 1;
3642                 } else if (fossilStatusCache.equalsIgnoreCase("fossil only")) {
3643                         return 2;
3644                 } else if (fossilStatusCache.equalsIgnoreCase("recent + fossil")) {
3645                         return 3;
3646                 } else {
3647                         logger.error("FossilStatusFk could not be determined. FossilStatusCache unknown: " + fossilStatusCache);
3648                 }
3649
3650                 return result;
3651         }
3652
3653         /**
3654          * Returns the NoteCategoryFk for a given UUID representing an ExtensionType.
3655          * @param uuid
3656          * @return
3657          */
3658         public static Integer getNoteCategoryFk(UUID uuid) {
3659                 Integer result = null;
3660                 if (uuid.equals(taxCommentUuid)) {
3661                         result = 270;
3662                 } else if (uuid.equals(fauCommentUuid)) {
3663                         result = 281;
3664                 } else if (uuid.equals(fauExtraCodesUuid)) {
3665                         result = 278;
3666                 }
3667                 return result;
3668         }
3669
3670         /**
3671          * Returns the NoteCategoryCache for a given UUID representing an ExtensionType.
3672          * @param uuid
3673          * @return
3674          */
3675         public static String getNoteCategoryCache(UUID uuid) {
3676                 String result = null;
3677                 if (uuid.equals(taxCommentUuid)) {
3678                         result = "Taxonomy";
3679                 } else if (uuid.equals(fauCommentUuid)) {
3680                         result = "Biology";
3681                 } else if (uuid.equals(fauExtraCodesUuid)) {
3682                         result = "Distribution";
3683                 }
3684                 return result;
3685         }
3686
3687         public static Integer getQualityStatusKeyBySource(BitSet sources) {
3688                 if (sources.get(SOURCE_EM)){
3689                         return QUALITY_STATUS_ADD_BY_DBMT;
3690                 }else{
3691                         return null;   // TODO needs to be implemented for others
3692                 }
3693         }
3694
3695         @Override
3696         public String getQualityStatusCacheByKey(Integer qualityStatusId) throws UndefinedTransformerMethodException {
3697                 if (qualityStatusId == null){
3698                         return null;
3699                 }else{
3700                         return this.qualityStatusCacheMap.get(qualityStatusId);
3701                 }
3702         }
3703
3704         public static String getOriginalDbBySources(BitSet sources) {
3705                 String result = "";
3706                 if (sources.get(SOURCE_EM)){
3707                         result = CdmUtils.concat(",", result,  SOURCE_STR_EM);
3708                 }
3709                 if (sources.get(SOURCE_FE)){
3710                         result = CdmUtils.concat(",", result,  SOURCE_STR_FE);
3711                 }
3712                 if (sources.get(SOURCE_IF)){
3713                         result = CdmUtils.concat(",", result,  SOURCE_STR_IF);
3714                 }
3715                 if (sources.get(SOURCE_ERMS)){
3716                         result = CdmUtils.concat(",", result,  SOURCE_STR_ERMS);
3717                 }
3718
3719                 return result;
3720         }
3721
3722
3723 }