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