EDIT

/**

* Copyright (C) 2009 EDIT

* European Distributed Institute of Taxonomy

* http://www.e-taxonomy.eu

*

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

package eu.etaxonomy.cdm.io.pesi.out;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.EnumSet;

import java.util.HashMap;

import java.util.HashSet;

import java.util.Map;

import java.util.Set;

import java.util.UUID;

import org.apache.commons.lang.StringUtils;

import org.apache.log4j.Logger;

import eu.etaxonomy.cdm.common.CdmUtils;

import eu.etaxonomy.cdm.io.berlinModel.BerlinModelTransformer;

import eu.etaxonomy.cdm.io.common.Source;

import eu.etaxonomy.cdm.io.common.mapping.UndefinedTransformerMethodException;

import eu.etaxonomy.cdm.io.common.mapping.out.ExportTransformerBase;

import eu.etaxonomy.cdm.io.pesi.erms.ErmsTransformer;

import eu.etaxonomy.cdm.io.pesi.faunaEuropaea.FaunaEuropaeaTransformer;

import eu.etaxonomy.cdm.io.pesi.out.PesiExportBase.PesiSource;

import eu.etaxonomy.cdm.model.common.CdmBase;

import eu.etaxonomy.cdm.model.common.Language;

import eu.etaxonomy.cdm.model.common.RelationshipBase;

import eu.etaxonomy.cdm.model.common.RelationshipTermBase;

import eu.etaxonomy.cdm.model.description.Feature;

import eu.etaxonomy.cdm.model.description.PresenceAbsenceTerm;

import eu.etaxonomy.cdm.model.location.Country;

import eu.etaxonomy.cdm.model.location.NamedArea;

import eu.etaxonomy.cdm.model.name.HybridRelationshipType;

import eu.etaxonomy.cdm.model.name.NameRelationshipType;

import eu.etaxonomy.cdm.model.name.NameTypeDesignationStatus;

import eu.etaxonomy.cdm.model.name.NomenclaturalCode;

import eu.etaxonomy.cdm.model.name.NomenclaturalStatusType;

import eu.etaxonomy.cdm.model.name.Rank;

import eu.etaxonomy.cdm.model.name.TaxonName;

import eu.etaxonomy.cdm.model.reference.Reference;

import eu.etaxonomy.cdm.model.reference.ReferenceType;

import eu.etaxonomy.cdm.model.taxon.Synonym;

import eu.etaxonomy.cdm.model.taxon.SynonymType;

import eu.etaxonomy.cdm.model.taxon.Taxon;

import eu.etaxonomy.cdm.model.taxon.TaxonBase;

import eu.etaxonomy.cdm.model.taxon.TaxonNode;

import eu.etaxonomy.cdm.model.taxon.TaxonRelationship;

import eu.etaxonomy.cdm.model.taxon.TaxonRelationshipType;

/**

 * @author e.-m.lee

 * @author a.mueller (update)

 * @since 16.02.2010

 */

public final class PesiTransformer extends ExportTransformerBase{

    private static final Logger logger = Logger.getLogger(PesiTransformer.class);

	public static final String AUCT_STRING = "auct.";

	//sourceRefUUIDs

	public static final UUID uuidSourceRefEuroMed = UUID.fromString("51b3900c-91e0-4cc5-94f3-577a352ca9c4");

	public static final UUID uuidSourceRefFaunaEuropaea = UUID.fromString("f27a5e67-d065-4b79-8d41-eabd3ae0edd0");

	public static final UUID uuidSourceRefErms = UUID.fromString("7744bc26-f914-42c4-b54a-dd2a030a8bb7");

	public static final UUID uuidSourceRefIndexFungorum = UUID.fromString("8de25d27-7d40-47f4-af3b-59d64935a843");

	public static final UUID uuidSourceRefAuct = UUID.fromString("5f79f96c-c100-4cd8-b78e-2b2dacf09a23");

	public static final UUID uuidSourceRefFaunaEuropaea_fromSql = UUID.fromString("6786d863-75d4-4796-b916-c1c3dff4cb70");

    public static final UUID uuidTaxonValuelessEuroMed = UUID.fromString("f0a9322b-a57e-447b-9a75-a909f2f2a994");

	public static final String SOURCE_STR_EM = "E+M";

	public static final String SOURCE_STR_FE = "FaEu";

	public static final String SOURCE_STR_IF = "IF";

	public static final String SOURCE_STR_ERMS = "ERMS";

	// status keys

	private static int QUALITY_STATUS_CHECKED_EDITOR_ERMS_1_1 = 0;

	private static int QUALITY_STATUS_ADD_BY_DBMT= 2;

	private static int QUALITY_STATUS_CHECKED_EDITOR = 3;

	private static int QUALITY_STATUS_EDITED_BY_DBMT = 4;

	private static int QUALITY_STATUS_THEMATIC_EDITOR = 5;

	// marker type

	public static final UUID uuidMarkerGuidIsMissing = UUID.fromString("24e70843-05e2-44db-954b-84df0d23ea20");

	public static final UUID uuidMarkerTypeHasNoLastAction = UUID.fromString("99652d5a-bc92-4251-b57d-0fec4d258ab7");

//	public static final UUID uuidMarkerFossil = UUID.fromString("761ce108-031a-4e07-b444-f8d757070312");

	//extension type uuids

	public static final UUID uuidExtCacheCitation = UUID.fromString("29656168-32d6-4301-9067-d57c63be5c67");

	//public static final UUID expertUserIdUuid = UUID.fromString("e25813d3-c67c-4585-9aa0-970fafde50b4");

	//public static final UUID speciesExpertUserIdUuid = UUID.fromString("6d42abd8-8894-4980-ae07-e918affd4172");

	public static final UUID uuidExtExpertName = BerlinModelTransformer.uuidExpertName;

	public static final UUID uuidExtSpeciesExpertName = BerlinModelTransformer.uuidSpeciesExpertName;

	public static final UUID uuidExtLastActionDate = UUID.fromString("8d0a7d81-bb83-4576-84c3-8c906ef039b2");

	public static final UUID uuidExtLastAction = UUID.fromString("bc20d5bc-6161-4279-9499-89ea26ce5f6a");

	public static final UUID uuidExtTaxComment = UUID.fromString("8041a752-0479-4626-ab1b-b266b751f816");

	public static final UUID uuidExtFauComment = UUID.fromString("054f773a-41c8-4ad5-83e3-981320c1c126");

	public static final UUID uuidExtFauExtraCodes = UUID.fromString("b8c7e77d-9869-4787-bed6-b4b302dbc5f5");

	// References

	private static int REF_ARTICLE_IN_PERIODICAL = 1;

	private static int REF_PART_OF_OTHER = 2;

	public static int REF_BOOK = 3;

	public static int REF_DATABASE = 4;

	private static int REF_INFORMAL = 5;

	private static int REF_NOT_APPLICABLE = 6;

	private static int REF_WEBSITE = 7;

	public static int REF_PUBLISHED_CD = 8;

	public static int REF_JOURNAL = 9;

	public static int REF_UNRESOLVED = 10;

	public static int REF_PUBLICATION = 11;

	public static String REF_STR_UNRESOLVED = "unresolved";

	private static int LANG_UNKNOWN = -99;

	private static int LANG_DUTCH = 11;

    private static int LANG_VALENCIAN = 65;

	private static int LANG_HIGH_ARAGONES = 66;

	private static int LANG_MAJORCAN = 67;

	// NameStatus

    public static UUID uuidNomStatusTemporaryName = UUID.fromString("aa6ada5a-ca21-4fef-b76f-9ae237e9c4ae");

	private static int NAME_ST_NOM_INVAL = 1;

	private static int NAME_ST_NOM_ILLEG = 2;

	private static int NAME_ST_NOM_NUD = 3;

	private static int NAME_ST_NOM_REJ = 4;

	private static int NAME_ST_NOM_REJ_PROP = 5;

	private static int NAME_ST_NOM_UTIQUE_REJ = 6;

	private static int NAME_ST_NOM_UTIQUE_REJ_PROP = 7;

	private static int NAME_ST_NOM_CONS = 8;

	private static int NAME_ST_NOM_CONS_PROP = 9;

	private static int NAME_ST_ORTH_CONS = 10;

	private static int NAME_ST_ORTH_CONS_PROP = 11;

	private static int NAME_ST_NOM_SUPERFL = 12;

	private static int NAME_ST_NOM_AMBIG = 13;

	private static int NAME_ST_NOM_PROVIS = 14;

	private static int NAME_ST_NOM_DUB = 15;

	private static int NAME_ST_NOM_NOV = 16;

	private static int NAME_ST_NOM_CONFUS = 17;

	private static int NAME_ST_NOM_ALTERN = 18;

	private static int NAME_ST_COMB_INVAL = 19;

	private static int NAME_ST_LEGITIMATE = 20; // PESI specific from here

	private static int NAME_ST_COMB_INED = 21;

	private static int NAME_ST_COMB_AND_STAT_INED = 22;

	private static int NAME_ST_NOM_AND_ORTH_CONS = 23;

	private static int NAME_ST_NOM_NOV_INED = 24;

	private static int NAME_ST_SP_NOV_INED = 25;

	private static int NAME_ST_ALTERNATE_REPRESENTATION = 26;

	private static int NAME_ST_TEMPORARY_NAME = 27;

	private static int NAME_ST_SPECIES_INQUIRENDA = 28;

	// TaxonStatus

	public static int T_STATUS_ACCEPTED = 1;

	public static int T_STATUS_SYNONYM = 2;

	public static int T_STATUS_PARTIAL_SYN = 3;

	public static int T_STATUS_PRO_PARTE_SYN = 4;

	public static int T_STATUS_UNRESOLVED = 5;

	private static int T_STATUS_ORPHANED = 6;

	public static int T_STATUS_UNACCEPTED = 7;

	private static int T_STATUS_NOT_ACCEPTED_VALUELESS = 8;

	// TypeDesginationStatus //	 -> not a table anymore

	private static int TYPE_BY_ORIGINAL_DESIGNATION = 1;

	private static int TYPE_BY_SUBSEQUENT_DESIGNATION = 2;

	private static int TYPE_BY_MONOTYPY = 3;

	private static String TYPE_STR_BY_ORIGINAL_DESIGNATION = "Type by original designation";

	private static String TYPE_STR_BY_SUBSEQUENT_DESIGNATION = "Type by subsequent designation";

	private static String TYPE_STR_BY_MONOTYPY = "Type by monotypy";

	// RelTaxonQualifier

	private static int IS_BASIONYM_FOR = 1;

	private static int IS_LATER_HOMONYM_OF = 2;

	private static int IS_REPLACED_SYNONYM_FOR = 3;

	private static int IS_VALIDATION_OF = 4;

	private static int IS_LATER_VALIDATION_OF = 5;

	private static int IS_TYPE_OF = 6;

	private static int IS_CONSERVED_TYPE_OF = 7;

	private static int IS_REJECTED_TYPE_OF = 8;

	private static int IS_FIRST_PARENT_OF = 9;

	private static int IS_SECOND_PARENT_OF = 10;

	private static int IS_FEMALE_PARENT_OF = 11;

	private static int IS_MALE_PARENT_OF = 12;

	private static int IS_CONSERVED_AGAINST = 13;

	private static int IS_REJECTED_IN_FAVOUR_OF = 14;

	private static int IS_TREATED_AS_LATER_HOMONYM_OF = 15;

	private static int IS_ORTHOGRAPHIC_VARIANT_OF = 16;

	private static int IS_ALTERNATIVE_NAME_FOR = 17;

	private static int HAS_SAME_TYPE_AS = 18;

	private static int IS_ORIGINAL_SPELLING_FOR = 19;

	private static int IS_BLOCKING_NAME_FOR = 20;

	private static int IS_LECTOTYPE_OF = 61;

	private static int TYPE_NOT_DESIGNATED = 62;

	public static int IS_TAXONOMICALLY_INCLUDED_IN = 101;

	public static int IS_SYNONYM_OF = 102;

	private static int IS_MISAPPLIED_NAME_FOR = 103;

	private static int IS_PRO_PARTE_SYNONYM_OF = 104;

	private static int IS_PARTIAL_SYNONYM_OF = 105;

	private static int IS_HETEROTYPIC_SYNONYM_OF = 106;

	private static int IS_HOMOTYPIC_SYNONYM_OF = 107;

	private static int IS_PRO_PARTE_MISAPPLIED_NAME_FOR = 108;

	private static int IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF = 201;

	private static int IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF = 202;

	private static int IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF = 203;

	private static int IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF = 204;

	private static int IS_INFERRED_EPITHET_FOR = 301;

	private static int IS_INFERRED_GENUS_FOR = 302;

	private static int IS_POTENTIAL_COMBINATION_FOR = 303;

	//namespaces

	public static String STR_NAMESPACE_NOMINAL_TAXON = "Nominal taxon from TAX_ID:";

	public static String STR_NAMESPACE_INFERRED_EPITHET = "Inferred epithet from TAX_ID:";

	public static String STR_NAMESPACE_INFERRED_GENUS = "Inferred genus from TAX_ID:";

	public static String STR_NAMESPACE_POTENTIAL_COMBINATION = "Potential combination from TAX_ID:";

	// Kingdoms

	private static final int KINGDOM_NULL = 0;

	private static final int KINGDOM_ANIMALIA = 2;

	private static final int KINGDOM_PLANTAE = 3;

	private static final int KINGDOM_FUNGI = 4;

	private static final int KINGDOM_PROTOZOA = 5;

	private static final int KINGDOM_BACTERIA = 6;

	private static final int KINGDOM_CHROMISTA = 7;

	// Kingdoms

	private static Map<String, Integer> pesiKingdomMap = new HashMap<>();

	//Kingdom title

    private static String KINGDOM_PLANTAE_STRING = "Plantae";

    private static String KINGDOM_FUNGI_STRING = "Fungi";

    private static String KINGDOM_PROTOZOA_STRING = "Protozoa";

    private static String kINGDOM_BACTERIA_STRING = "Bacteria";

    private static String KINGDOM_CHROMISTA_STRING = "Chromista";

	//ranks of all kingdoms

    private static int Kingdom = 10;

    private static int Subkingdom = 20;

    private static int Phylum = 30;  //Phylum and Division is same (#8541) according to ICNAFP

    private static int Division = 30;

    private static int Subphylum = 40;  //See above comment

    private static int Subdivision = 40;

    private static int Class = 60;

    private static int Subclass = 70;

    private static int Order = 100;

    private static int Suborder = 110;

    private static int Family = 140;

    private static int Subfamily = 150;

    private static int Tribe = 160;

    private static int Subtribe = 170;

    private static int Genus = 180;

    private static int Subgenus = 190;

    private static int Species =220;

    private static int Subspecies = 230;

    private static int Variety = 240;

    private static int Forma = 260;

    //ranks of some kingdoms

    private static int Infrakingdom = 25; //2,3,5,7

    private static int Infraphylum = 45;  //2,7

    private static int Superclass = 50;   //2,5,6,7

    private static int Infraclass = 80;   //2,5,6,7

    private static int Superorder = 90;   //2,3,5,6,7

    private static int Infraorder = 120;  //2,5,6,7

    private static int Superfamily = 130; //2,5,6,7

    private static int Bot_Section = 200;    //3,4,7

    private static int Bot_Subsection = 210; //3,4,7

    private static int Subvariety = 250;     //2,3,4,7

    private static int Subform = 270;        //2,3,4

    private static int Forma_spec = 275;     //3,4,5,7

    // Animalia Ranks

	private static int Superphylum = 28;

	private static int Subterclass = 85;

	private static int Parvorder = 122;

	private static int Animalia_Section = 125;

	private static int Animalia_Subsection = 127;

	private static int Natio = 235;

	// Plantae Ranks

	private static int Series = 212;

	private static int Subseries	= 214;

	private static int Aggregate	= 216;

	private static int Coll_Species = 218;

	private static int Grex = 225;

	private static int Proles = 232;

	private static int Race = 234;

	private static int Convarietas = 236;

	private static int Taxa_infragen = 280;

	private static int Taxa_infraspec = 285;

	//NoteCategory

	private static int NoteCategory_description = 1;

	public static int NoteCategory_ecology = 4;

	private static int NoteCategory_phenology	= 5;

	private static int NoteCategory_general_distribution_euromed = 10;

	private static int NoteCategory_general_distribution_world = 11;

	private static int NoteCategory_Common_names = 12;

	private static int NoteCategory_Occurrence = 13;

	private static int NoteCategory_Maps =14;

	private static int NoteCategory_Link_to_maps = 20;

	private static int NoteCategory_Link_to_images = 21;

	public static int NoteCategory_Link_to_taxonomy = 22;

	public static int NoteCategory_Link_to_general_information = 23;

	public static int NoteCategory_undefined_link = 24;

	private static int NoteCategory_Editor_Braces = 249;

	private static int NoteCategory_Editor_Brackets = 250;

	private static int NoteCategory_Editor_Parenthesis = 251;

	private static int NoteCategory_Inedited = 252;

	private static int NoteCategory_Comments_on_editing_process = 253;

	private static int NoteCategory_Publication_date = 254;

	private static int NoteCategory_Morphology = 255;

	private static int NoteCategory_Acknowledgments = 257;

	private static int NoteCategory_Original_publication = 258;

	private static int NoteCategory_Type_locality	= 259;

	private static int NoteCategory_Environment = 260;

	private static int NoteCategory_Spelling = 261;

	private static int NoteCategory_Systematics = 262;

	private static int NoteCategory_Remark = 263;

	private static int NoteCategory_Additional_information = 266;

	private static int NoteCategory_Status = 267;

	private static int NoteCategory_Nomenclature = 268;

	private static int NoteCategory_Homonymy = 269;

	private static int NoteCategory_Taxonomy = 270;

	private static int NoteCategory_Taxonomic_status = 272;

	private static int NoteCategory_Authority	= 273;

	private static int NoteCategory_Identification = 274;

	private static int NoteCategory_Validity = 275;

	private static int NoteCategory_Classification = 276;

	private static int NoteCategory_Distribution = 278;

	private static int NoteCategory_Synonymy = 279;

	private static int NoteCategory_Habitat = 280;

	private static int NoteCategory_Biology = 281;

	private static int NoteCategory_Diagnosis	= 282;

	private static int NoteCategory_Host = 283;

	private static int NoteCategory_Note = 284;

	private static int NoteCategory_Rank = 285;

	private static int NoteCategory_Taxonomic_Remark = 286;

	private static int NoteCategory_Taxonomic_Remarks = 287;

	private static int NoteCategory_Etymology = 288;

    private static int NoteCategory_Type_species = 289;

	private static int NoteCategory_Depth_Range = 290;

	private static int NoteCategory_Grammatical_Gender = 291;

	private static int NoteCategory_Introduced_Species_Remark = 292;

	private static int NoteCategory_Alien_Species = 293;

	private static int NoteCategory_Dimensions = 294;

    private static int NoteCategory_New_Combination = 295;

    private static int NoteCategory_Original_Combination = 296;

	private static int NoteCategory_Conservation_Status= 301;

	private static int NoteCategory_Use = 302;

	private static int NoteCategory_Comments = 303;

    private static int NoteCategory_Diet = 304;

    private static int NoteCategory_Fossil_Range = 305;

    private static int NoteCategory_Original_Description = 306;

    private static int NoteCategory_Reproduction = 307;

    private static int NoteCategory_Specimen = 308;

    private static int NoteCategory_Type_Specimen = 309;

    private static int NoteCategory_Type_Material = 310;

    private static int NoteCategory_Editors_Comment = 311;

    private static int NoteCategory_Syntype = 312;

	// FossilStatus

	private static int FOSSILSTATUS_RECENT_ONLY = 1;

	private static int FOSSILSTATUS_FOSSIL_ONLY = 2;

	private static int FOSSILSTATUS_RECENT_FOSSIL = 3;

	public static String STR_FOSSIL_ONLY = "fossil only";  //still used for Index Fungorum

	// SourceUse

	private static int ORIGINAL_DESCRIPTION = 1;

	private static int BASIS_OF_RECORD = 2;

	private static int ADDITIONAL_SOURCE = 3;

	private static int SOURCE_OF_SYNONYMY = 4;

	private static int REDESCRIPTION = 5;

	private static int NEW_COMBINATION_REFERENCE = 6;

	private static int STATUS_SOURCE = 7;

	public static int NOMENCLATURAL_REFERENCE = 8;

	public static String STR_NOMENCLATURAL_REFERENCE = "nomenclatural reference";

	// Area

	private static int AREA_EAST_AEGEAN_ISLANDS = 1;

	private static int AREA_GREEK_EAST_AEGEAN_ISLANDS = 2;

	private static int AREA_TURKISH_EAST_AEGEAN_ISLANDS = 3;

	private static int AREA_ALBANIA = 4;

	private static int AREA_AUSTRIA_WITH_LIECHTENSTEIN = 5;

	private static int AREA_AUSTRIA = 6;

	private static int AREA_LIECHTENSTEIN = 7;

	private static int AREA_AZORES = 8;

	private static int AREA_CORVO = 9;

	private static int AREA_FAIAL = 10;

	private static int AREA_GRACIOSA = 11;

	private static int AREA_SAO_JORGE = 12;

	private static int AREA_FLORES = 13;

	private static int AREA_SAO_MIGUEL = 14;

	private static int AREA_PICO = 15;

	private static int AREA_SANTA_MARIA = 16;

	private static int AREA_TERCEIRA = 17;

	private static int AREA_BELGIUM_WITH_LUXEMBOURG = 18;

	private static int AREA_BELGIUM = 19;

	private static int AREA_LUXEMBOURG = 20;

	private static int AREA_BOSNIA_HERZEGOVINA = 21;

	private static int AREA_BALEARES = 22;

	private static int AREA_IBIZA_WITH_FORMENTERA = 23;

	private static int AREA_MALLORCA = 24;

	private static int AREA_MENORCA = 25;

	private static int AREA_GREAT_BRITAIN = 26;

	private static int AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION = 27;

	private static int AREA_BULGARIA = 28;

	private static int AREA_BELARUS = 29;

	private static int AREA_CANARY_ISLANDS = 30;

	private static int AREA_GRAN_CANARIA = 31;

	private static int AREA_FUERTEVENTURA_WITH_LOBOS = 32;

	private static int AREA_GOMERA = 33;

	private static int AREA_HIERRO = 34;

	private static int AREA_LANZAROTE_WITH_GRACIOSA = 35;

	private static int AREA_LA_PALMA = 36;

	private static int AREA_TENERIFE = 37;

	private static int AREA_MONTENEGRO = 38;

	private static int AREA_CORSE = 39;

	private static int AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS = 40;

	private static int AREA_CZECH_REPUBLIC = 41;

	private static int AREA_CROATIA = 42;

	private static int AREA_CYPRUS = 43;

	private static int AREA_FORMER_CZECHOSLOVAKIA = 44;

	private static int AREA_DENMARK_WITH_BORNHOLM = 45;

	private static int AREA_ESTONIA = 46;

	private static int AREA_FAROE_ISLANDS = 47;

	private static int AREA_FINLAND_WITH_AHVENANMAA = 48;

	private static int AREA_FRANCE = 49;

	private static int AREA_CHANNEL_ISLANDS = 50;

	private static int AREA_FRENCH_MAINLAND = 51;

	private static int AREA_MONACO = 52;

	private static int AREA_GERMANY = 53;

	private static int AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS = 54;

	private static int AREA_IRELAND = 55;

	private static int AREA_REPUBLIC_OF_IRELAND = 56;

	private static int AREA_NORTHERN_IRELAND = 57;

	private static int AREA_SWITZERLAND = 58;

	private static int AREA_NETHERLANDS = 59;

	private static int AREA_SPAIN = 60;

	private static int AREA_ANDORRA = 61;

	private static int AREA_GIBRALTAR = 62;

	private static int AREA_KINGDOM_OF_SPAIN = 63;

	private static int AREA_HUNGARY = 64;

	private static int AREA_ICELAND = 65;

	private static int AREA_ITALY = 66;

	private static int AREA_ITALIAN_MAINLAND = 67;

	private static int AREA_SAN_MARINO = 68;

	private static int AREA_FORMER_JUGOSLAVIA = 69;

	private static int AREA_LATVIA = 70;

	private static int AREA_LITHUANIA = 71;

	private static int AREA_PORTUGUESE_MAINLAND = 72;

	private static int AREA_MADEIRA_ARCHIPELAGO = 73;

	private static int AREA_DESERTAS = 74;

	private static int AREA_MADEIRA = 75;

	private static int AREA_PORTO_SANTO = 76;

	private static int AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA = 77;

	private static int AREA_MOLDOVA = 78;

	private static int AREA_NORWEGIAN_MAINLAND = 79;

	private static int AREA_POLAND = 80;

	private static int AREA_THE_RUSSIAN_FEDERATION = 81;

	private static int AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND = 82;

	private static int AREA_CENTRAL_EUROPEAN_RUSSIA = 83;

	private static int AREA_EASTERN_EUROPEAN_RUSSIA = 84;

	private static int AREA_KALININGRAD = 85;

	private static int AREA_NORTHERN_EUROPEAN_RUSSIA = 86;

	private static int AREA_NORTHWEST_EUROPEAN_RUSSIA = 87;

	private static int AREA_SOUTH_EUROPEAN_RUSSIA = 88;

	private static int AREA_ROMANIA = 89;

	private static int AREA_FORMER_USSR = 90;

	private static int AREA_RUSSIA_BALTIC = 91;

	private static int AREA_RUSSIA_CENTRAL = 92;

	private static int AREA_RUSSIA_SOUTHEAST = 93;

	private static int AREA_RUSSIA_NORTHERN = 94;

	private static int AREA_RUSSIA_SOUTHWEST = 95;

	private static int AREA_SARDEGNA = 96;

	private static int AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN = 97;

	private static int AREA_SELVAGENS_ISLANDS = 98;

	private static int AREA_SICILY_WITH_MALTA = 99;

	private static int AREA_MALTA = 100;

	private static int AREA_SICILY = 101;

	private static int AREA_SLOVAKIA = 102;

	private static int AREA_SLOVENIA = 103;

	private static int AREA_SERBIA_WITH_MONTENEGRO = 104;

	private static int AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO = 105;

	private static int AREA_SWEDEN = 106;

	private static int AREA_EUROPEAN_TURKEY = 107;

	private static int AREA_UKRAINE_INCLUDING_CRIMEA = 108;

	private static int AREA_CRIMEA = 109;

	private static int AREA_UKRAINE = 110;

	private static int AREA_GREEK_MAINLAND = 111;

	private static int AREA_CRETE = 112;

	private static int AREA_DODECANESE_ISLANDS = 113;

	private static int AREA_CYCLADES_ISLANDS = 114;

	private static int AREA_NORTH_AEGEAN_ISLANDS = 115;

	private static int AREA_VATICAN_CITY = 116;

	private static int AREA_FRANZ_JOSEF_LAND = 117;

	private static int AREA_NOVAYA_ZEMLYA = 118;

	private static int AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN = 119;

	private static int AREA_AZERBAIJAN = 120;

	private static int AREA_NAKHICHEVAN = 121;

	private static int AREA_ALGERIA = 122;

	private static int AREA_ARMENIA = 123;

	private static int AREA_CAUCASUS_REGION = 124;

	private static int AREA_EGYPT = 125;

	private static int AREA_GEORGIA = 126;

	private static int AREA_ISRAEL_JORDAN = 127;

	private static int AREA_ISRAEL = 128;

	private static int AREA_JORDAN = 129;

	private static int AREA_LEBANON = 130;

	private static int AREA_LIBYA = 131;

	private static int AREA_LEBANON_SYRIA = 132;

	private static int AREA_MOROCCO = 133;

	private static int AREA_NORTH_CAUCASUS = 134;

	private static int AREA_SINAI = 135;

	private static int AREA_SYRIA = 136;

	private static int AREA_TUNISIA = 137;

	private static int AREA_ASIATIC_TURKEY = 138;

	private static int AREA_TURKEY = 139;

	private static int AREA_NORTHERN_AFRICA = 140;

	private static int AREA_AFRO_TROPICAL_REGION = 141;

	private static int AREA_AUSTRALIAN_REGION = 142;

	private static int AREA_EAST_PALAEARCTIC = 143;

	private static int AREA_NEARCTIC_REGION = 144;

	private static int AREA_NEOTROPICAL_REGION = 145;

	private static int AREA_NEAR_EAST = 146;

	private static int AREA_ORIENTAL_REGION = 147;

	private static int AREA_EUROPEAN_MARINE_WATERS = 148;

	private static int AREA_MEDITERRANEAN_SEA = 149;

	private static int AREA_WHITE_SEA = 150;

	private static int AREA_NORTH_SEA = 151;

	private static int AREA_BALTIC_SEA = 152;

	private static int AREA_BLACK_SEA = 153;

	private static int AREA_BARENTSZ_SEA = 154;

	private static int AREA_CASPIAN_SEA = 155;

	private static int AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE = 156;

	private static int AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE = 157;

	private static int AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE = 158;

	private static int AREA_ENGLISH_CHANNEL = 159;

	private static int AREA_ADRIATIC_SEA = 160;

	private static int AREA_BISCAY_BAY = 161;

	private static int AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE = 162;

	private static int AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE = 163;

	private static int AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE = 164;

	private static int AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE = 165;

	private static int AREA_GREEK_EXCLUSIVE_ECONOMIC_ZONE = 166;

	private static int AREA_TIRRENO_SEA = 167;

	private static int AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE = 168;

	private static int AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE = 169;

	private static int AREA_IRISH_SEA = 170;

	private static int AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE = 171;

	private static int AREA_NORWEGIAN_SEA = 172;

	private static int AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE = 173;

	private static int AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE = 174;

	private static int AREA_SKAGERRAK = 175;

	private static int AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE = 176;

	private static int AREA_WADDEN_SEA = 177;

	private static int AREA_BELT_SEA = 178;

	private static int AREA_MARMARA_SEA = 179;

	private static int AREA_SEA_OF_AZOV = 180;

	private static int AREA_AEGEAN_SEA = 181;

	private static int AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE = 182;

	private static int AREA_SOUTH_BALTIC_PROPER = 183;

	private static int AREA_BALTIC_PROPER = 184;

	private static int AREA_NORTH_BALTIC_PROPER = 185;

	private static int AREA_ARCHIPELAGO_SEA = 186;

	private static int AREA_BOTHNIAN_SEA = 187;

	private static int AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE = 188;

	private static int AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE = 189;

	private static int AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE = 190;

	private static int AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE = 191;

	private static int AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE = 192;

	private static int AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART = 193;

	private static int AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE = 194;

	private static int AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE = 195;

	private static int AREA_BALEAR_SEA = 196;

	private static int AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE = 197;

	private static int AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE = 198;

	private static int AREA_TRANSCAUCASUS = 199;

	private static int AREA_GEORGIA_G = 200;

	private static int AREA_ABKHAZIA = 201;

	private static int AREA_ADZARIA = 202;

	private static int AREA_UNITED_KINGDOM = 203;

	private static int AREA_DENMARK_COUNTRY = 204;

	private static int AREA_TURKEY_COUNTRY = 205;

	private static int AREA_SPAIN_COUNTRY = 206;

	private static int AREA_GREECE_COUNTRY = 207;

	private static int AREA_PORTUGAL_COUNTRY = 208;

	//continued ERMS areas without variables

	//...

	private static int AREA_WALES = 293;

	//new E+M areas

	private static int AREA_SERBIA = 294;

	private static int AREA_KOSOVO = 295;

	//FauEu area UUIDs

    private static UUID uuidAreaAD = UUID.fromString("38dd31d2-8275-4b05-8b85-eb71a390d67f");

    private static UUID uuidAreaAFR = UUID.fromString("c3123386-51a4-42a4-9ff4-b3905b18a83c");//x

    private static UUID uuidAreaAL = UUID.fromString("84c54f15-fc90-44bb-a45d-26b7daa26ceb");

    private static UUID uuidAreaAT = UUID.fromString("d285e4a5-d027-4610-a4ff-f5e6dd16cdc3");

    private static UUID uuidAreaAUS = UUID.fromString("930e6455-de5e-4002-bfc3-45eecd07e4f3");//x

    private static UUID uuidAreaBA = UUID.fromString("946a06ea-200f-409e-bb2f-05e64e55ed41");

    private static UUID uuidAreaBE = UUID.fromString("f914f7fd-d5a3-4165-8409-004f197ae4e9");

    private static UUID uuidAreaBG = UUID.fromString("9586daca-a739-4d28-836e-6d15861375e1");

    private static UUID uuidAreaBY = UUID.fromString("b6f94a56-990d-41da-8e92-abf757afeca1");

    private static UUID uuidAreaCH = UUID.fromString("cccc1da5-6a0e-47c2-900e-e274fd593ff0");

    private static UUID uuidAreaCY = UUID.fromString("78950366-3f15-48bb-80c9-8b24afedcd3c");

    private static UUID uuidAreaCZ = UUID.fromString("d1221dbc-a7c5-4805-b7c8-15ae56557825");

    private static UUID uuidAreaDE = UUID.fromString("6f31223e-9a10-4c97-b482-85d96f195a23");

    private static UUID uuidAreaDK_DEN = UUID.fromString("4ed51fa9-f89a-47c8-a9ce-43d462f74c53");

    private static UUID uuidAreaDK_FOR = UUID.fromString("272874cf-b6f7-4805-8a0c-1a0efbbf0a21");

    private static UUID uuidAreaEE = UUID.fromString("1472705d-c94e-41e8-9482-adb46f201f71");

    private static UUID uuidAreaEPA = UUID.fromString("2f162235-6c5a-4ad4-8ba0-8dca28826dab");//x

    private static UUID uuidAreaES_BAL = UUID.fromString("d5466ee2-38fa-47e8-8109-008b71a2f47b");

    private static UUID uuidAreaES_CNY = UUID.fromString("1f19cdaa-af1e-406c-bb58-25f17ee00228");

    private static UUID uuidAreaES_SPA = UUID.fromString("d3cc7b05-b506-44b7-a49a-77d36974bd5f");

    private static UUID uuidAreaFI = UUID.fromString("93d6e2ba-308b-4d57-851c-94583e139806");

    private static UUID uuidAreaFR_COR = UUID.fromString("f7088b27-805f-46df-916f-eeed47a2e336");

    private static UUID uuidAreaFR_FRA = UUID.fromString("83d2df98-c0b4-4ad8-9a02-7cdfcfa74371");

    private static UUID uuidAreaGB_CI = UUID.fromString("a97807d0-e7e2-4ee0-8567-07f3a72d91bb");

    private static UUID uuidAreaGB_GI = UUID.fromString("4441b42a-7c9f-4a39-89d6-5c9c9dab9c05");

    private static UUID uuidAreaGB_GRB = UUID.fromString("94561875-19a6-4bf4-ade7-340c245ffd67");

    private static UUID uuidAreaGB_NI = UUID.fromString("791be300-6e86-4253-b1ba-aef46ea6bfb9");

    private static UUID uuidAreaGR_AEG = UUID.fromString("efb2f01a-f01e-4da2-ba02-464b0e1687e5");//x

    private static UUID uuidAreaGR_CYC = UUID.fromString("f9ad21b1-c9ed-4062-9086-cba6e6ef353b");//x

    private static UUID uuidAreaGR_DOD = UUID.fromString("7a84feae-9d93-4408-8122-e82b9485fc0f");//x

    private static UUID uuidAreaGR_GRC = UUID.fromString("a392dbac-8671-40e6-95c7-a0d2db8f7d9c");//x

    private static UUID uuidAreaGR_KRI = UUID.fromString("ed8e7bcd-2267-4953-b422-bc2ff45238f7");//x

    private static UUID uuidAreaHR = UUID.fromString("83323e5b-8a62-4784-956a-5f21ddc853b9");

    private static UUID uuidAreaHU = UUID.fromString("ab6985e7-e718-4bcb-bc84-55e563870998");

    private static UUID uuidAreaIE = UUID.fromString("6a623016-2cd7-4391-8bc9-ae8af50060b4");

    private static UUID uuidAreaIS = UUID.fromString("b8469350-7c87-4202-9cb1-5f0ad11ec89c");

    private static UUID uuidAreaIT_ITA = UUID.fromString("43df04d6-90b4-4cf4-8dfc-f60ae921f92c");

    private static UUID uuidAreaIT_SAR = UUID.fromString("f68d9695-238d-4684-901a-f4bbc24813ee");

    private static UUID uuidAreaIT_SI = UUID.fromString("1889a571-d12a-48f1-a49f-112e60c699ef");

    private static UUID uuidAreaLI = UUID.fromString("ebad24b5-559e-46c4-8b0d-87107e05169e");

    private static UUID uuidAreaLT = UUID.fromString("d00df2a8-8d5d-4c36-b3a2-4afc9006be70");

    private static UUID uuidAreaLU = UUID.fromString("65bbbb63-3351-4fda-a8f8-50557bc34e0d");

    private static UUID uuidAreaLV = UUID.fromString("997d97ea-4678-4e01-9a81-518c09da7d7c");

    private static UUID uuidAreaMC = UUID.fromString("0debabad-e7e2-4aad-b959-876d3d85a4b1");

    private static UUID uuidAreaMD = UUID.fromString("7a4ffe59-f8d6-4a58-bb4e-449fbe8420b3");

    private static UUID uuidAreaMK = UUID.fromString("40140714-6214-4338-bc45-f85455f7eaed");

    private static UUID uuidAreaMT = UUID.fromString("b36c2f47-47d5-497f-9235-2faf0d9a6e6c");

    private static UUID uuidAreaNAF = UUID.fromString("e3b2193d-e23a-47a7-9bf5-7f7eebe61afb");//x

    private static UUID uuidAreaNEA = UUID.fromString("d6082e94-7289-45a3-a298-5cb730cfbd7f");//x

    private static UUID uuidAreaNEO = UUID.fromString("7a530ae7-d070-49aa-8496-7b06c4ed735b");//x

    private static UUID uuidAreaNL = UUID.fromString("7b74033f-ada3-4956-87b7-ec9bf0cb4c76");

    private static UUID uuidAreaNO_NOR = UUID.fromString("11b26fc9-3da4-4323-8b03-e960e8b1c914");

    private static UUID uuidAreaNO_SVA = UUID.fromString("9a3fe056-2011-4b02-a416-59de00eaf533");

    private static UUID uuidAreaNRE = UUID.fromString("5e005e59-b313-4c5b-8702-c2f88317db25");//x

    private static UUID uuidAreaORR = UUID.fromString("2047d0dd-12dc-4454-8344-07ad52fa0af0");//x

    private static UUID uuidAreaPL = UUID.fromString("68edc557-dbed-494e-9549-6746f11fb904");

    private static UUID uuidAreaPT_AZO = UUID.fromString("6f5e4eb5-83c8-4baf-99f2-cb6e25d8ac9d");

    private static UUID uuidAreaPT_MDR = UUID.fromString("97bed937-f4ad-4b42-ba0c-8832816fa234");

    private static UUID uuidAreaPT_POR = UUID.fromString("09107b85-2bdb-4534-a51c-8d02cdd71590");

    private static UUID uuidAreaPT_SEL = UUID.fromString("e067287c-50c6-4e54-9859-91aa15aa289a");

    private static UUID uuidAreaRO = UUID.fromString("de3e2ca8-d2ea-4c1f-8a19-a7a0b5daf39d");

    private static UUID uuidAreaRU_FJL = UUID.fromString("2b79434b-df7d-4dc5-996f-1ca4227f6e0e");//x

    private static UUID uuidAreaRU_KGD = UUID.fromString("227a661b-91de-489c-88ed-6b72f78481f0");

    private static UUID uuidAreaRU_NOZ = UUID.fromString("2b26f68a-fdac-41ab-bce0-105b24d7eb26");//x

    private static UUID uuidAreaRU_RUC = UUID.fromString("235748eb-9eef-48a8-9b9a-c4abd00b6244");

    private static UUID uuidAreaRU_RUE = UUID.fromString("5ad5b07e-518f-44ee-ac96-c7608d93e757");

    private static UUID uuidAreaRU_RUN = UUID.fromString("05d35653-9f67-442c-8d99-4a7ae68cf5d1");

    private static UUID uuidAreaRU_RUS = UUID.fromString("98b00cf8-7bd6-4f44-885c-0927bbc1d456");

    private static UUID uuidAreaRU_RUW = UUID.fromString("ae84bc08-957a-4c62-a828-1fb3fc2f0c3e");

    private static UUID uuidAreaSE = UUID.fromString("8ff37027-4832-4ce1-9f25-e21eaf26299c");

    private static UUID uuidAreaSI = UUID.fromString("0b76b448-5564-415c-bc18-727c37e62bf1");

    private static UUID uuidAreaSK = UUID.fromString("e966cd7c-3e68-4153-887b-54920eb6eb47");

    private static UUID uuidAreaSM = UUID.fromString("c40b8a71-c50c-4636-96de-be0bb48ed025");