Project

General

Profile

Download (228 KB) Statistics
| Branch: | Revision:
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.HashSet;
17
import java.util.Map;
18
import java.util.Set;
19
import java.util.UUID;
20

    
21
import org.apache.commons.lang.StringUtils;
22
import org.apache.log4j.Logger;
23

    
24
import eu.etaxonomy.cdm.common.CdmUtils;
25
import eu.etaxonomy.cdm.io.berlinModel.BerlinModelTransformer;
26
import eu.etaxonomy.cdm.io.common.Source;
27
import eu.etaxonomy.cdm.io.common.mapping.UndefinedTransformerMethodException;
28
import eu.etaxonomy.cdm.io.common.mapping.out.ExportTransformerBase;
29
import eu.etaxonomy.cdm.io.common.mapping.out.IExportTransformer;
30
import eu.etaxonomy.cdm.io.pesi.erms.ErmsTransformer;
31
import eu.etaxonomy.cdm.io.pesi.faunaEuropaea.FaunaEuropaeaTransformer;
32
import eu.etaxonomy.cdm.model.common.CdmBase;
33
import eu.etaxonomy.cdm.model.common.Extension;
34
import eu.etaxonomy.cdm.model.common.Language;
35
import eu.etaxonomy.cdm.model.common.RelationshipBase;
36
import eu.etaxonomy.cdm.model.common.RelationshipTermBase;
37
import eu.etaxonomy.cdm.model.description.AbsenceTerm;
38
import eu.etaxonomy.cdm.model.description.Feature;
39
import eu.etaxonomy.cdm.model.description.PresenceAbsenceTermBase;
40
import eu.etaxonomy.cdm.model.description.PresenceTerm;
41
import eu.etaxonomy.cdm.model.location.NamedArea;
42
import eu.etaxonomy.cdm.model.location.TdwgArea;
43
import eu.etaxonomy.cdm.model.location.WaterbodyOrCountry;
44
import eu.etaxonomy.cdm.model.name.HybridRelationshipType;
45
import eu.etaxonomy.cdm.model.name.NameRelationshipType;
46
import eu.etaxonomy.cdm.model.name.NameTypeDesignationStatus;
47
import eu.etaxonomy.cdm.model.name.NomenclaturalCode;
48
import eu.etaxonomy.cdm.model.name.NomenclaturalStatusType;
49
import eu.etaxonomy.cdm.model.name.Rank;
50
import eu.etaxonomy.cdm.model.name.TaxonNameBase;
51
import eu.etaxonomy.cdm.model.occurrence.Fossil;
52
import eu.etaxonomy.cdm.model.reference.Reference;
53
import eu.etaxonomy.cdm.model.reference.ReferenceType;
54
import eu.etaxonomy.cdm.model.taxon.Synonym;
55
import eu.etaxonomy.cdm.model.taxon.SynonymRelationship;
56
import eu.etaxonomy.cdm.model.taxon.SynonymRelationshipType;
57
import eu.etaxonomy.cdm.model.taxon.Taxon;
58
import eu.etaxonomy.cdm.model.taxon.TaxonBase;
59
import eu.etaxonomy.cdm.model.taxon.TaxonRelationshipType;
60
import eu.etaxonomy.cdm.strategy.exceptions.UnknownCdmTypeException;
61

    
62
/**
63
 * @author e.-m.lee
64
 * @author a.mueller (update)
65
 * @date 16.02.2010
66
 *
67
 */
68
public final class PesiTransformer extends ExportTransformerBase implements IExportTransformer{
69
	private static final Logger logger = Logger.getLogger(PesiTransformer.class);
70

    
71
	public static final String AUCT_STRING = "auct.";
72
	
73
	
74
	//source identifiers
75
	public static final int SOURCE_EM = 1;
76
	public static final int SOURCE_FE = 2;
77
	public static final int SOURCE_IF = 3;
78
	public static final int SOURCE_ERMS = 4;
79
	
80
	//sourceRefUUIDs
81
	public static final UUID uuidSourceRefEuroMed = UUID.fromString("0603a84a-f024-4454-ab92-9e2ac0139126");
82
	public static final UUID uuidSourceRefFaunaEuropaea = UUID.fromString("6786d863-75d4-4796-b916-c1c3dff4cb70");
83
	public static final UUID uuidSourceRefErms = UUID.fromString("7744bc26-f914-42c4-b54a-dd2a030a8bb7");
84
	public static final UUID uuidSourceRefIndexFungorum = UUID.fromString("8de25d27-7d40-47f4-af3b-59d64935a843");
85
	public static final UUID uuidSourceRefAuct = UUID.fromString("5f79f96c-c100-4cd8-b78e-2b2dacf09a23");
86
	
87
	public static final String SOURCE_STR_EM = "E+M";
88
	public static final String SOURCE_STR_FE = "FaEu";
89
	public static final String SOURCE_STR_IF = "IF";
90
	public static final String SOURCE_STR_ERMS = "ERMS";
91

    
92
	// status keys
93
	public static int QUALITY_STATUS_CHECKED_EDITOR_ERMS_1_1 = 0;
94
	public static int QUALITY_STATUS_ADD_BY_DBMT= 2;
95
	public static int QUALITY_STATUS_CHECKED_EDITOR = 3;
96
	public static int QUALITY_STATUS_EDITED_BY_DBMT = 4;
97
	
98
	// marker type
99
	public static final UUID uuidMarkerGuidIsMissing = UUID.fromString("24e70843-05e2-44db-954b-84df0d23ea20");
100
	public static final UUID uuidMarkerTypeHasNoLastAction = UUID.fromString("99652d5a-bc92-4251-b57d-0fec4d258ab7");
101
//	public static final UUID uuidMarkerFossil = UUID.fromString("761ce108-031a-4e07-b444-f8d757070312");
102
	
103
	
104
	//extension type uuids
105
	public static final UUID cacheCitationUuid = UUID.fromString("29656168-32d6-4301-9067-d57c63be5c67");
106
	//public static final UUID expertUserIdUuid = UUID.fromString("e25813d3-c67c-4585-9aa0-970fafde50b4");
107
	//public static final UUID speciesExpertUserIdUuid = UUID.fromString("6d42abd8-8894-4980-ae07-e918affd4172");
108
	public static final UUID expertNameUuid = BerlinModelTransformer.uuidExpertName;
109
	public static final UUID speciesExpertNameUuid = BerlinModelTransformer.uuidSpeciesExpertName; 
110
	public static final UUID lastActionDateUuid = UUID.fromString("8d0a7d81-bb83-4576-84c3-8c906ef039b2");
111
	public static final UUID lastActionUuid = UUID.fromString("bc20d5bc-6161-4279-9499-89ea26ce5f6a");
112
	public static final UUID taxCommentUuid = UUID.fromString("8041a752-0479-4626-ab1b-b266b751f816");
113
	public static final UUID fauCommentUuid = UUID.fromString("054f773a-41c8-4ad5-83e3-981320c1c126");
114
	public static final UUID fauExtraCodesUuid = UUID.fromString("b8c7e77d-9869-4787-bed6-b4b302dbc5f5");
115

    
116
	// References
117
	public static int REF_ARTICLE_IN_PERIODICAL = 1;
118
	public static int REF_PART_OF_OTHER = 2;
119
	public static int REF_BOOK = 3;
120
	public static int REF_DATABASE = 4;
121
	public static int REF_INFORMAL = 5;
122
	public static int REF_NOT_APPLICABLE = 6;
123
	public static int REF_WEBSITE = 7;
124
	public static int REF_PUBLISHED = 8;
125
	public static int REF_JOURNAL = 9;
126
	public static int REF_UNRESOLVED = 10;
127
	public static int REF_PUBLICATION = 11;
128

    
129
	public static String REF_STR_ARTICLE_IN_PERIODICAL = "Article in periodical";
130
	public static String REF_STR_PART_OF_OTHER = "Part of other";
131
	public static String REF_STR_BOOK = "Book";
132
	public static String REF_STR_DATABASE = "Database";
133
	public static String REF_STR_INFORMAL = "Informal";
134
	public static String REF_STR_NOT_APPLICABLE = "Not applicable";
135
	public static String REF_STR_WEBSITE = "Website";
136
	public static String REF_STR_PUBLISHED = "Published";
137
	public static String REF_STR_JOURNAL = "Journal";
138
	public static String REF_STR_UNRESOLVED = "Unresolved";
139
	public static String REF_STR_PUBLICATION = "Publication";
140
	
141
	// NameStatus
142
	public static int NAME_ST_NOM_INVAL = 1;
143
	public static int NAME_ST_NOM_ILLEG = 2;
144
	public static int NAME_ST_NOM_NUD = 3;
145
	public static int NAME_ST_NOM_REJ = 4;
146
	public static int NAME_ST_NOM_REJ_PROP = 5;
147
	public static int NAME_ST_NOM_UTIQUE_REJ = 6;
148
	public static int NAME_ST_NOM_UTIQUE_REJ_PROP = 7;
149
	public static int NAME_ST_NOM_CONS = 8;
150
	public static int NAME_ST_NOM_CONS_PROP = 9;
151
	public static int NAME_ST_ORTH_CONS = 10;
152
	public static int NAME_ST_ORTH_CONS_PROP = 11;
153
	public static int NAME_ST_NOM_SUPERFL = 12;
154
	public static int NAME_ST_NOM_AMBIG = 13;
155
	public static int NAME_ST_NOM_PROVIS = 14;
156
	public static int NAME_ST_NOM_DUB = 15;
157
	public static int NAME_ST_NOM_NOV = 16;
158
	public static int NAME_ST_NOM_CONFUS = 17;
159
	public static int NAME_ST_NOM_ALTERN = 18;
160
	public static int NAME_ST_COMB_INVAL = 19;
161
	public static int NAME_ST_LEGITIMATE = 20; // PESI specific from here
162
	public static int NAME_ST_COMB_INED = 21;
163
	public static int NAME_ST_COMB_AND_STAT_INED = 22;
164
	public static int NAME_ST_NOM_AND_ORTH_CONS = 23;
165
	public static int NAME_ST_NOM_NOV_INED = 24;
166
	public static int NAME_ST_SP_NOV_INED = 25;
167
	public static int NAME_ST_ALTERNATE_REPRESENTATION = 26;
168
	public static int NAME_ST_TEMPORARY_NAME = 27;
169
	public static int NAME_ST_SPECIES_INQUIRENDA = 28;
170

    
171
	// TaxonStatus
172
	public static int T_STATUS_ACCEPTED = 1;
173
	public static int T_STATUS_SYNONYM = 2;
174
	public static int T_STATUS_PARTIAL_SYN = 3;
175
	public static int T_STATUS_PRO_PARTE_SYN = 4;
176
	public static int T_STATUS_UNRESOLVED = 5;
177
	public static int T_STATUS_ORPHANED = 6;
178
	public static int T_STATUS_UNACCEPTED = 7;
179
	
180
	public static String T_STATUS_STR_ACCEPTED = "Accepted";
181
	public static String T_STATUS_STR_SYNONYM = "Synonym";
182
	public static String T_STATUS_STR_PARTIAL_SYN = "Partial Synonym";
183
	public static String T_STATUS_STR_PRO_PARTE_SYN = "Pro Parte Synonym";
184
	public static String T_STATUS_STR_UNRESOLVED = "Unresolved";
185
	public static String T_STATUS_STR_ORPHANED = "Orphaned";
186
	public static String T_STATUS_STR_UNACCEPTED = "Unaccepted";
187
	
188
	// TypeDesginationStatus
189
	public static int TYPE_BY_ORIGINAL_DESIGNATION = 1;
190
	public static int TYPE_BY_SUBSEQUENT_DESIGNATION = 2;
191
	public static int TYPE_BY_MONOTYPY = 3;
192
	
193
	public static String TYPE_STR_BY_ORIGINAL_DESIGNATION = "Type by original designation";
194
	public static String TYPE_STR_BY_SUBSEQUENT_DESIGNATION = "Type by subsequent designation";
195
	public static String TYPE_STR_BY_MONOTYPY = "Type by monotypy";
196
	
197
	// RelTaxonQualifier
198
	public static int IS_BASIONYM_FOR = 1;
199
	public static int IS_LATER_HOMONYM_OF = 2;
200
	public static int IS_REPLACED_SYNONYM_FOR = 3;
201
	public static int IS_VALIDATION_OF = 4;
202
	public static int IS_LATER_VALIDATION_OF = 5;
203
	public static int IS_TYPE_OF = 6;
204
	public static int IS_CONSERVED_TYPE_OF = 7;
205
	public static int IS_REJECTED_TYPE_OF = 8;
206
	public static int IS_FIRST_PARENT_OF = 9;
207
	public static int IS_SECOND_PARENT_OF = 10;
208
	public static int IS_FEMALE_PARENT_OF = 11;
209
	public static int IS_MALE_PARENT_OF = 12;
210
	public static int IS_CONSERVED_AGAINST = 13;
211
	public static int IS_REJECTED_IN_FAVOUR_OF = 14;
212
	public static int IS_TREATED_AS_LATER_HOMONYM_OF = 15;
213
	public static int IS_ORTHOGRAPHIC_VARIANT_OF = 16;
214
	public static int IS_ALTERNATIVE_NAME_FOR = 17;
215
	public static int HAS_SAME_TYPE_AS = 18;
216
	public static int IS_LECTOTYPE_OF = 61;
217
	public static int TYPE_NOT_DESIGNATED = 62;
218
	public static int IS_TAXONOMICALLY_INCLUDED_IN = 101;
219
	public static int IS_SYNONYM_OF = 102;
220
	public static int IS_MISAPPLIED_NAME_FOR = 103;
221
	public static int IS_PRO_PARTE_SYNONYM_OF = 104;
222
	public static int IS_PARTIAL_SYNONYM_OF = 105;
223
	public static int IS_HETEROTYPIC_SYNONYM_OF = 106;
224
	public static int IS_HOMOTYPIC_SYNONYM_OF = 107;
225
	public static int IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF = 201;
226
	public static int IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF = 202;
227
	public static int IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF = 203;
228
	public static int IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF = 204;
229
	public static int IS_INFERRED_EPITHET_FOR = 301;
230
	public static int IS_INFERRED_GENUS_FOR = 302;
231
	public static int IS_POTENTIAL_COMBINATION_FOR = 303;
232

    
233
		
234
	//namespaces
235
	public static String STR_NAMESPACE_NOMINAL_TAXON = "Nominal taxon from TAX_ID:";
236
	public static String STR_NAMESPACE_INFERRED_EPITHET = "Inferred epithet from TAX_ID:";
237
	public static String STR_NAMESPACE_INFERRED_GENUS = "Inferred genus from TAX_ID:";
238
	public static String STR_NAMESPACE_POTENTIAL_COMBINATION = "Potential combination from TAX_ID:";
239

    
240

    
241
	// Kingdoms
242
	public static int KINGDOM_NULL = 0;
243
	public static int KINGDOM_ANIMALIA = 2;
244
	public static int KINGDOM_PLANTAE = 3;
245
	public static int KINGDOM_FUNGI = 4;
246
	public static int KINGDOM_PROTOZOA = 5;
247
	public static int KINGDOM_BACTERIA = 6;
248
	public static int KINGDOM_CHROMISTA = 7;
249

    
250
	// Animalia Ranks
251
	public static int Animalia_Kingdom = 10;
252
	public static int Animalia_Subkingdom = 20;
253
	public static int Animalia_Superphylum = 23;
254
	public static int Animalia_Phylum = 30;
255
	public static int Animalia_Subphylum = 40;
256
	public static int Animalia_Infraphylum = 45;
257
	public static int Animalia_Superclass = 50;
258
	public static int Animalia_Class = 60;
259
	public static int Animalia_Subclass = 70;
260
	public static int Animalia_Infraclass = 80;
261
	public static int Animalia_Superorder = 90;
262
	public static int Animalia_Order = 100;
263
	public static int Animalia_Suborder = 110;
264
	public static int Animalia_Infraorder = 120;
265
	public static int Animalia_Section = 121;
266
	public static int Animalia_Subsection = 122;
267
	public static int Animalia_Superfamily = 130;
268
	public static int Animalia_Family = 140;
269
	public static int Animalia_Subfamily = 150;
270
	public static int Animalia_Tribe = 160;
271
	public static int Animalia_Subtribe = 170;
272
	public static int Animalia_Genus = 180;
273
	public static int Animalia_Subgenus = 190;
274
	public static int Animalia_Species =220;
275
	public static int Animalia_Subspecies = 230;
276
	public static int Animalia_Natio = 235;
277
	public static int Animalia_Variety = 240;
278
	public static int Animalia_Subvariety = 250;
279
	public static int Animalia_Forma = 260;
280

    
281
	public static String Animalia_STR_Kingdom = "Kingdom";
282
	public static String Animalia_STR_Subkingdom = "Subkingdom";
283
	public static String Animalia_STR_Superphylum = "Superphylum";
284
	public static String Animalia_STR_Phylum = "Phylum";
285
	public static String Animalia_STR_Subphylum = "Subphylum";
286
	public static String Animalia_STR_Infraphylum = "Infraphylum";
287
	public static String Animalia_STR_Superclass = "Superclass";
288
	public static String Animalia_STR_Class = "Class";
289
	public static String Animalia_STR_Subclass = "Subclass";
290
	public static String Animalia_STR_Infraclass = "Infraclass";
291
	public static String Animalia_STR_Superorder = "Superorder";
292
	public static String Animalia_STR_Order = "Order";
293
	public static String Animalia_STR_Suborder = "Suborder";
294
	public static String Animalia_STR_Infraorder = "Infraorder";
295
	public static String Animalia_STR_Section = "Section";
296
	public static String Animalia_STR_Subsection = "Subsection";
297
	public static String Animalia_STR_Superfamily = "Superfamily";
298
	public static String Animalia_STR_Family = "Family";
299
	public static String Animalia_STR_Subfamily = "Subfamily";
300
	public static String Animalia_STR_Tribe = "Tribe";
301
	public static String Animalia_STR_Subtribe = "Subtribe";
302
	public static String Animalia_STR_Genus = "Genus";
303
	public static String Animalia_STR_Subgenus = "Subgenus";
304
	public static String Animalia_STR_Species = "Species";
305
	public static String Animalia_STR_Subspecies = "Subspecies";
306
	public static String Animalia_STR_Natio = "Natio";
307
	public static String Animalia_STR_Variety = "Variety";
308
	public static String Animalia_STR_Subvariety = "Subvariety";
309
	public static String Animalia_STR_Forma = "Forma";
310
	
311
	// Animalia Rank Abbreviations only for used Ranks
312
	public static String Animalia_Abbrev_Subgenus = "subg.";
313
	public static String Animalia_Abbrev_Species = "sp.";
314
	public static String Animalia_Abbrev_Subspecies = "subsp.";
315
	public static String Animalia_Abbrev_Variety = "var.";
316
	public static String Animalia_Abbrev_Subvariety = "subvar.";
317
	public static String Animalia_Abbrev_Forma = "f.";
318

    
319
	// Plantae Ranks
320
	public static int Plantae_Kingdom = 10;
321
	public static int Plantae_Subkingdom = 20;
322
	public static int Plantae_Division = 30;
323
	public static int Plantae_Subdivision = 40;
324
	public static int Plantae_Class = 60;
325
	public static int Plantae_Subclass = 70;
326
	public static int Plantae_Order = 100;
327
	public static int Plantae_Suborder = 110;
328
	public static int Plantae_Family = 140;
329
	public static int Plantae_Subfamily = 150;
330
	public static int Plantae_Tribe	= 160;
331
	public static int Plantae_Subtribe = 170;
332
	public static int Plantae_Genus = 180;
333
	public static int Plantae_Subgenus = 190;
334
	public static int Plantae_Section = 200;
335
	public static int Plantae_Subsection = 210;
336
	public static int Plantae_Series = 212;
337
	public static int Plantae_Subseries	= 214;
338
	public static int Plantae_Aggregate	= 216;
339
	public static int Plantae_Coll_Species = 218;
340
	public static int Plantae_Species = 220;
341
	public static int Plantae_Grex = 225;
342
	public static int Plantae_Subspecies = 230;
343
	public static int Plantae_Proles = 232;
344
	public static int Plantae_Race = 234;
345
	public static int Plantae_Convarietas = 236;
346
	public static int Plantae_Variety = 240;
347
	public static int Plantae_Subvariety = 250;
348
	public static int Plantae_Forma	= 260;
349
	public static int Plantae_Subforma = 270;
350
	public static int Plantae_Forma_spec = 275;
351
	public static int Plantae_Taxa_infragen = 280;
352
	public static int Plantae_Taxa_infraspec = 285;
353
	
354
	public static String Plantae_STR_Kingdom = "Kingdom";
355
	public static String Plantae_STR_Subkingdom = "Subkingdom";
356
	public static String Plantae_STR_Division = "Division";
357
	public static String Plantae_STR_Subdivision = "Subdivision";
358
	public static String Plantae_STR_Class = "Class";
359
	public static String Plantae_STR_Subclass = "Subclass";
360
	public static String Plantae_STR_Order = "Order";
361
	public static String Plantae_STR_Suborder = "Suborder";
362
	public static String Plantae_STR_Family = "Family";
363
	public static String Plantae_STR_Subfamily = "Subfamily";
364
	public static String Plantae_STR_Tribe	= "Tribe";
365
	public static String Plantae_STR_Subtribe = "Subtribe";
366
	public static String Plantae_STR_Genus = "Genus";
367
	public static String Plantae_STR_Subgenus = "Subgenus";
368
	public static String Plantae_STR_Section = "Section";
369
	public static String Plantae_STR_Subsection = "Subsection";
370
	public static String Plantae_STR_Series = "Series";
371
	public static String Plantae_STR_Subseries	= "Subseries";
372
	public static String Plantae_STR_Aggregate	= "Aggregate";
373
	public static String Plantae_STR_Coll_Species = "Coll. Species";
374
	public static String Plantae_STR_Species = "Species";
375
	public static String Plantae_STR_Grex = "Grex";
376
	public static String Plantae_STR_Subspecies = "Subspecies";
377
	public static String Plantae_STR_Proles = "Proles";
378
	public static String Plantae_STR_Race = "Race";
379
	public static String Plantae_STR_Convarietas = "Convariety";
380
	public static String Plantae_STR_Variety = "Variety";
381
	public static String Plantae_STR_Subvariety = "Subvariety";
382
	public static String Plantae_STR_Forma	= "Forma";
383
	public static String Plantae_STR_Subforma = "Subforma";
384
	public static String Plantae_STR_Forma_spec = "Forma spec.";
385
	public static String Plantae_STR_Taxa_infragen = "Tax. infragen.";
386
	public static String Plantae_STR_Taxa_infraspec = "Tax. infraspec.";
387
	
388
	// Plantae Rank Abbreviations
389
	public static String Plantae_Abbrev_Kingdom = "reg.";
390
	public static String Plantae_Abbrev_Subkingdom = "subreg.";
391
	public static String Plantae_Abbrev_Division = "div.";
392
	public static String Plantae_Abbrev_Subdivision = "subdiv.";
393
	public static String Plantae_Abbrev_Class = "cl.";
394
	public static String Plantae_Abbrev_Subclass = "subcl.";
395
	public static String Plantae_Abbrev_Order = "ordo";
396
	public static String Plantae_Abbrev_Suborder = "subor.";
397
	public static String Plantae_Abbrev_Family = "fam.";
398
	public static String Plantae_Abbrev_Subfamily = "subfam.";
399
	public static String Plantae_Abbrev_Tribe	= "trib.";
400
	public static String Plantae_Abbrev_Subtribe = "subtrib.";
401
	public static String Plantae_Abbrev_Genus = "gen.";
402
	public static String Plantae_Abbrev_Subgenus = "subg.";
403
	public static String Plantae_Abbrev_Section = "sect.";
404
	public static String Plantae_Abbrev_Subsection = "subsect.";
405
	public static String Plantae_Abbrev_Series = "ser.";
406
	public static String Plantae_Abbrev_Subseries	= "subser.";
407
	public static String Plantae_Abbrev_Aggregate	= "aggr.";
408
	public static String Plantae_Abbrev_Coll_Species = "coll. sp.";
409
	public static String Plantae_Abbrev_Species = "sp.";
410
	public static String Plantae_Abbrev_Grex = "grex";
411
	public static String Plantae_Abbrev_Subspecies = "subsp.";
412
	public static String Plantae_Abbrev_Proles = "prol.";
413
	public static String Plantae_Abbrev_Race = "race";
414
	public static String Plantae_Abbrev_Convarietas = "convar.";
415
	public static String Plantae_Abbrev_Variety = "var.";
416
	public static String Plantae_Abbrev_Subvariety = "subvar.";
417
	public static String Plantae_Abbrev_Forma	= "f.";
418
	public static String Plantae_Abbrev_Subforma = "subf.";
419
	public static String Plantae_Abbrev_Forma_spec = "f.spec.";
420
	public static String Plantae_Abbrev_Taxa_infragen = "t.infgen.";
421
	public static String Plantae_Abbrev_Taxa_infraspec = "t.infr.";
422
	
423
	// Fungi Ranks
424
	public static int Fungi_Kingdom = 10;
425
	public static int Fungi_Subkingdom = 20;
426
	public static int Fungi_Division = 30;
427
	public static int Fungi_Subdivision = 40;
428
	public static int Fungi_Class	= 60;
429
	public static int Fungi_Subclass = 70;
430
	public static int Fungi_Order	= 100;
431
	public static int Fungi_Suborder = 110;
432
	public static int Fungi_Family = 140;
433
	public static int Fungi_Subfamily = 150;
434
	public static int Fungi_Tribe = 160;
435
	public static int Fungi_Subtribe = 170;
436
	public static int Fungi_Genus = 180;
437
	public static int Fungi_Subgenus = 190;
438
	public static int Fungi_Section = 200;
439
	public static int Fungi_Subsection = 210;
440
	public static int Fungi_Species = 220;
441
	public static int Fungi_Subspecies = 230;
442
	public static int Fungi_Variety = 240;
443
	public static int Fungi_Subvariety = 250;
444
	public static int Fungi_Forma	= 260;
445
	public static int Fungi_Subforma = 270;
446
	
447
	//Protozoa Ranks
448
	public static int Protozoa_Kingdom = 10;
449
	public static int Protozoa_Subkingdom = 20;
450
	public static int Protozoa_Phylum = 30;
451
	public static int Protozoa_Subphylum = 40;
452
	public static int Protozoa_Superclass = 50;
453
	public static int Protozoa_Class	= 60;
454
	public static int Protozoa_Subclass = 70;
455
	public static int Protozoa_Infraclass = 80;
456
	public static int Protozoa_Superorder = 90;
457
	public static int Protozoa_Order	= 100;
458
	public static int Protozoa_Suborder = 110;
459
	public static int Protozoa_Infraorder = 120;
460
	public static int Protozoa_Superfamily = 130;
461
	public static int Protozoa_Family = 140;
462
	public static int Protozoa_Subfamily = 150;
463
	public static int Protozoa_Tribe	= 160;
464
	public static int Protozoa_Subtribe = 170;
465
	public static int Protozoa_Genus	= 180;
466
	public static int Protozoa_Subgenus = 190;
467
	public static int Protozoa_Species = 220;
468
	public static int Protozoa_Subspecies = 230;
469
	public static int Protozoa_Variety = 240;
470
	public static int Protozoa_Forma	= 260;
471
	
472
	// Bacteria Ranks
473
	public static int Bacteria_Kingdom = 10;
474
	public static int Bacteria_Subkingdom = 20;
475
	public static int Bacteria_Phylum = 30;
476
	public static int Bacteria_Subphylum	= 40;
477
	public static int Bacteria_Superclass = 50;
478
	public static int Bacteria_Class	= 60;
479
	public static int Bacteria_Subclass = 70;
480
	public static int Bacteria_Infraclass = 80;
481
	public static int Bacteria_Superorder = 90;
482
	public static int Bacteria_Order	= 100;
483
	public static int Bacteria_Suborder = 110;
484
	public static int Bacteria_Infraorder = 120;
485
	public static int Bacteria_Superfamily = 130;
486
	public static int Bacteria_Family = 140;
487
	public static int Bacteria_Subfamily	= 150;
488
	public static int Bacteria_Tribe	= 160;
489
	public static int Bacteria_Subtribe = 170;
490
	public static int Bacteria_Genus	= 180;
491
	public static int Bacteria_Subgenus = 190;
492
	public static int Bacteria_Species = 220;
493
	public static int Bacteria_Subspecies = 230;
494
	public static int Bacteria_Variety = 240;
495
	public static int Bacteria_Forma	= 260;
496

    
497
	public static String Bacteria_STR_Kingdom = "Kingdom";
498
	public static String Bacteria_STR_Subkingdom = "Subkingdom";
499
	public static String Bacteria_STR_Phylum = "Phylum";
500
	public static String Bacteria_STR_Subphylum = "Subphylum";
501
	public static String Bacteria_STR_Superclass = "Superclass";
502
	public static String Bacteria_STR_Class = "Class";
503
	public static String Bacteria_STR_Subclass = "Subclass";
504
	public static String Bacteria_STR_Infraclass = "Infraclass";
505
	public static String Bacteria_STR_Superorder = "Superorder";
506
	public static String Bacteria_STR_Order = "Order";
507
	public static String Bacteria_STR_Suborder = "Suborder";
508
	public static String Bacteria_STR_Infraorder = "Infraorder";
509
	public static String Bacteria_STR_Superfamily = "Superfamily";
510
	public static String Bacteria_STR_Family = "Family";
511
	public static String Bacteria_STR_Subfamily = "Subfamily";
512
	public static String Bacteria_STR_Tribe = "Tribe";
513
	public static String Bacteria_STR_Subtribe = "Subtribe";
514
	public static String Bacteria_STR_Genus = "Genus";
515
	public static String Bacteria_STR_Subgenus = "Subgenus";
516
	public static String Bacteria_STR_Species = "Species";
517
	public static String Bacteria_STR_Subspecies = "Subspecies";
518
	public static String Bacteria_STR_Variety = "Variety";
519
	public static String Bacteria_STR_Forma = "Forma";
520

    
521
	// Chromista Ranks
522
	public static int Chromista_Kingdom = 10;
523
	public static int Chromista_Subkingdom = 20;
524
	public static int Chromista_Infrakingdom = 25;
525
	public static int Chromista_Phylum = 30;
526
	public static int Chromista_Subphylum = 40;
527
	public static int Chromista_Superclass = 50;
528
	public static int Chromista_Class = 60;
529
	public static int Chromista_Subclass = 70;
530
	public static int Chromista_Infraclass = 80;
531
	public static int Chromista_Superorder = 90;
532
	public static int Chromista_Order = 100;
533
	public static int Chromista_Suborder = 110;
534
	public static int Chromista_Infraorder = 120;
535
	public static int Chromista_Superfamily	= 130;
536
	public static int Chromista_Family = 140;
537
	public static int Chromista_Subfamily = 150;
538
	public static int Chromista_Tribe = 160;
539
	public static int Chromista_Subtribe = 170;
540
	public static int Chromista_Genus = 180;
541
	public static int Chromista_Subgenus = 190;
542
	public static int Chromista_Section = 200;
543
	public static int Chromista_Subsection = 210;
544
	public static int Chromista_Species	= 220;
545
	public static int Chromista_Subspecies = 230;
546
	public static int Chromista_Variety	= 240;
547
	public static int Chromista_Subvariety = 250;
548
	public static int Chromista_Forma = 260;
549
	
550
	// NoteCategory
551
	public static int NoteCategory_description = 1;
552
	public static int NoteCategory_ecology = 4;
553
	public static int NoteCategory_phenology	= 5;
554
	public static int NoteCategory_general_distribution_euromed = 10;
555
	public static int NoteCategory_general_distribution_world = 11;
556
	public static int NoteCategory_Common_names = 12;
557
	public static int NoteCategory_Occurrence = 13;
558
	public static int NoteCategory_Maps =14;
559
	public static int NoteCategory_Link_to_maps = 20;
560
	public static int NoteCategory_Link_to_images = 21;
561
	public static int NoteCategory_Link_to_taxonomy = 22;
562
	public static int NoteCategory_Link_to_general_information = 23;
563
	public static int NoteCategory_undefined_link = 24;
564
	public static int NoteCategory_Editor_Braces = 249;
565
	public static int NoteCategory_Editor_Brackets = 250;
566
	public static int NoteCategory_Editor_Parenthesis = 251;
567
	public static int NoteCategory_Inedited = 252;
568
	public static int NoteCategory_Comments_on_editing_process = 253;
569
	public static int NoteCategory_Publication_date = 254;
570
	public static int NoteCategory_Morphology = 255;
571
	public static int NoteCategory_Acknowledgments = 257;
572
	public static int NoteCategory_Original_publication = 258;
573
	public static int NoteCategory_Type_locality	= 259;
574
	public static int NoteCategory_Environment = 260;
575
	public static int NoteCategory_Spelling = 261;
576
	public static int NoteCategory_Systematics = 262;
577
	public static int NoteCategory_Remark = 263;
578
	public static int NoteCategory_Date_of_publication = 264;
579
	public static int NoteCategory_Additional_information = 266;
580
	public static int NoteCategory_Status = 267;
581
	public static int NoteCategory_Nomenclature = 268;
582
	public static int NoteCategory_Homonymy = 269;
583
	public static int NoteCategory_Taxonomy = 270;
584
	public static int NoteCategory_Taxonomic_status = 272;
585
	public static int NoteCategory_Authority	= 273;
586
	public static int NoteCategory_Identification = 274;
587
	public static int NoteCategory_Validity = 275;
588
	public static int NoteCategory_Classification = 276;
589
	public static int NoteCategory_Distribution = 278;
590
	public static int NoteCategory_Synonymy = 279;
591
	public static int NoteCategory_Habitat = 280;
592
	public static int NoteCategory_Biology = 281;
593
	public static int NoteCategory_Diagnosis	= 282;
594
	public static int NoteCategory_Host = 283;
595
	public static int NoteCategory_Note = 284;
596
	public static int NoteCategory_Rank = 285;
597
	public static int NoteCategory_Taxonomic_Remark = 286;
598
	public static int NoteCategory_Taxonomic_Remarks = 287;
599

    
600
	
601
	public static String NoteCategory_STR_description = "description";
602
	public static String NoteCategory_STR_ecology = "ecology";
603
	public static String NoteCategory_STR_phenology	= "phenology";
604
	public static String NoteCategory_STR_general_distribution_euromed = "general distribution (Euro+Med)";
605
	public static String NoteCategory_STR_general_distribution_world = "general distribution (world)";
606
	public static String NoteCategory_STR_Common_names = "Common names";
607
	public static String NoteCategory_STR_Occurrence = "Occurrence";
608
	public static String NoteCategory_STR_Maps = "Maps";
609
	public static String NoteCategory_STR_Link_to_maps = "Link to maps";
610
	public static String NoteCategory_STR_Link_to_images = "Link to images";
611
	public static String NoteCategory_STR_Link_to_taxonomy = "Link to taxonomy";
612
	public static String NoteCategory_STR_Link_to_general_information = "Link to general information";
613
	public static String NoteCategory_STR_undefined_link = "undefined link";
614
	public static String NoteCategory_STR_Editor_Braces = "Editor_Braces";
615
	public static String NoteCategory_STR_Editor_Brackets = "Editor_Brackets";
616
	public static String NoteCategory_STR_Editor_Parenthesis = "Editor_Parenthesis";
617
	public static String NoteCategory_STR_Inedited = "Inedited";
618
	public static String NoteCategory_STR_Comments_on_editing_process = "Comments on editing process";
619
	public static String NoteCategory_STR_Publication_date = "Publication date";
620
	public static String NoteCategory_STR_Morphology = "Morphology";
621
	public static String NoteCategory_STR_Acknowledgments = "Acknowledgments";
622
	public static String NoteCategory_STR_Original_publication = "Original publication";
623
	public static String NoteCategory_STR_Type_locality	= "Type locality";
624
	public static String NoteCategory_STR_Environment = "Environment";
625
	public static String NoteCategory_STR_Spelling = "Spelling";
626
	public static String NoteCategory_STR_Systematics = "Systematics";
627
	public static String NoteCategory_STR_Remark = "Remark";
628
	public static String NoteCategory_STR_Date_of_publication = "Date of publication";
629
	public static String NoteCategory_STR_Additional_information = "Additional information";
630
	public static String NoteCategory_STR_Status = "Status";
631
	public static String NoteCategory_STR_Nomenclature = "Nomenclature";
632
	public static String NoteCategory_STR_Homonymy = "Homonymy";
633
	public static String NoteCategory_STR_Taxonomy = "Taxonomy";
634
	public static String NoteCategory_STR_Taxonomic_status = "Taxonomic status";
635
	public static String NoteCategory_STR_Authority	= "Authority";
636
	public static String NoteCategory_STR_Identification = "Identification";
637
	public static String NoteCategory_STR_Validity = "Validity";
638
	public static String NoteCategory_STR_Classification = "Classification";
639
	public static String NoteCategory_STR_Distribution = "Distribution";
640
	public static String NoteCategory_STR_Synonymy = "Synonymy";
641
	public static String NoteCategory_STR_Habitat = "Habitat";
642
	public static String NoteCategory_STR_Biology = "Biology";
643
	public static String NoteCategory_STR_Diagnosis	= "Diagnosis";
644
	public static String NoteCategory_STR_Host = "Host";
645
	public static String NoteCategory_STR_Note = "Note";
646
	public static String NoteCategory_STR_Rank = "Rank";
647
	public static String NoteCategory_STR_Taxonomic_Remark = "Taxonomic Remark";
648
	public static String NoteCategory_STR_Taxonomic_Remarks = "Taxonomic Remarks";
649
	
650
	
651
	// Language
652
	public static int Language_Albanian = 1;
653
	public static int Language_Arabic = 2;
654
	public static int Language_Armenian = 3;
655
	public static int Language_Azerbaijan = 4;
656
	public static int Language_Belarusian = 5;
657
	public static int Language_Bulgarian = 6;
658
	public static int Language_Catalan = 7;
659
	public static int Language_Croat = 8;
660
	public static int Language_Czech = 9;
661
	public static int Language_Danish = 10;
662
	public static int Language_Dutch = 11;
663
	public static int Language_English = 12;
664
	public static int Language_Euskera = 13;
665
	public static int Language_Estonian = 14;
666
	public static int Language_Finnish = 15;
667
	public static int Language_French = 16;
668
	public static int Language_Georgian = 17;
669
	public static int Language_German = 18;
670
	public static int Language_Greek = 19;
671
	public static int Language_Hungarian = 20;
672
	public static int Language_Icelandic = 21;
673
	public static int Language_Irish_Gaelic = 22;
674
	public static int Language_Israel_Hebrew = 23;
675
	public static int Language_Italian = 24;
676
	public static int Language_Latvian = 25;
677
	public static int Language_Lithuanian = 26;
678
	public static int Language_Macedonian = 27;
679
	public static int Language_Maltese = 28;
680
	public static int Language_Moldovian = 29;
681
	public static int Language_Norwegian = 30;
682
	public static int Language_Polish = 31;
683
	public static int Language_Portuguese = 32;
684
	public static int Language_Roumanian = 33;
685
	public static int Language_Russian = 34;
686
	public static int Language_Russian_Caucasian = 35;
687
	public static int Language_Russian_Altaic_kalmyk_oirat = 36;
688
	public static int Language_Russian_Altaic_karachay_balkar = 37;
689
	public static int Language_Russian_Altaic_kumyk = 38;
690
	public static int Language_Russian_Altaic_nogai = 39;
691
	public static int Language_Russian_Altaic_north_azerbaijani = 40;
692
	public static int Language_Russian_Indo_european_russian = 41;
693
	public static int Language_Russian_Indo_european_kalmyk_oirat = 42;
694
	public static int Language_Russian_Indo_european_osetin = 43;
695
	public static int Language_Russian_North_caucasian_abaza = 44;
696
	public static int Language_Russian_North_caucasian_adyghe = 45;
697
	public static int Language_Russian_North_caucasian_chechen = 46;
698
	public static int Language_Russian_North_caucasian_kabardian = 47;
699
	public static int Language_Russian_North_caucasian_lak = 48;
700
	public static int Language_Russian_North_caucasian_avar = 49;
701
	public static int Language_Russian_North_caucasian_in = 50;
702
	public static int Language_Russian_Uralic_chuvash = 51;
703
	public static int Language_Russian_Uralic_udmurt = 52;
704
	public static int Language_Serbian = 53;
705
	public static int Language_Slovak = 54;
706
	public static int Language_Slovene = 55;
707
	public static int Language_Spanish_Castillian = 56;
708
	public static int Language_Swedish = 57;
709
	public static int Language_Turkish = 58;
710
	public static int Language_Ukraine = 59;
711
	public static int Language_Welsh = 60;
712
	public static int Language_Corsican = 61;
713

    
714
	public static String STR_LANGUAGE_ALBANIAN = "Albanian";
715
	public static String STR_LANGUAGE_ARABIC = "Arabic";
716
	public static String STR_LANGUAGE_ARMENIAN = "Armenian";
717
	public static String STR_LANGUAGE_AZERBAIJAN = "Azerbaijan";
718
	public static String STR_LANGUAGE_BELARUSIAN = "Belarusian";
719
	public static String STR_LANGUAGE_BULGARIAN = "Bulgarian";
720
	public static String STR_LANGUAGE_CATALAN = "Catalan";
721
	public static String STR_LANGUAGE_CROAT = "Croat";
722
	public static String STR_LANGUAGE_CZECH = "Czech";
723
	public static String STR_LANGUAGE_DANISH = "Danish";
724
	public static String STR_LANGUAGE_DUTCH = "Dutch";
725
	public static String STR_LANGUAGE_ENGLISH = "English";
726
	public static String STR_LANGUAGE_EUSKERA = "Euskera";
727
	public static String STR_LANGUAGE_ESTONIAN = "Estonian";
728
	public static String STR_LANGUAGE_FINNISH = "Finnish";
729
	public static String STR_LANGUAGE_FRENCH = "French";
730
	public static String STR_LANGUAGE_GEORGIAN = "Georgian";
731
	public static String STR_LANGUAGE_GERMAN = "German";
732
	public static String STR_LANGUAGE_GREEK = "Greek";
733
	public static String STR_LANGUAGE_HUNGARIAN = "Hungarian";
734
	public static String STR_LANGUAGE_ICELANDIC = "Icelandic";
735
	public static String STR_LANGUAGE_IRISH_GAELIC = "Irish Gaelic";
736
	public static String STR_LANGUAGE_ISRAEL_HEBREW = "Israel (Hebrew)";
737
	public static String STR_LANGUAGE_ITALIAN = "Italian";
738
	public static String STR_LANGUAGE_LATVIAN = "Latvian";
739
	public static String STR_LANGUAGE_LITHUANIAN = "Lithuanian";
740
	public static String STR_LANGUAGE_MACEDONIAN = "Macedonian";
741
	public static String STR_LANGUAGE_MALTESE = "Maltese";
742
	public static String STR_LANGUAGE_MOLDOVIAN = "Moldovian";
743
	public static String STR_LANGUAGE_NORWEGIAN = "Norwegian";
744
	public static String STR_LANGUAGE_POLISH = "Polish";
745
	public static String STR_LANGUAGE_PORTUGUESE = "Portuguese";
746
	public static String STR_LANGUAGE_ROUMANIAN = "Roumanian";
747
	public static String STR_LANGUAGE_RUSSIAN = "Russian";
748
	public static String STR_LANGUAGE_RUSSIAN_CAUCASIAN = "Russian Caucasian";
749
	public static String STR_LANGUAGE_RUSSIAN_ALTAIC_KALMYK_OIRAT = "Russian (Altaic, kalmyk-oirat)";
750
	public static String STR_LANGUAGE_RUSSIAN_ALTAIC_KARACHAY_BALKAR = "Russian (Altaic, karachay-balkar)";
751
	public static String STR_LANGUAGE_RUSSIAN_ALTAIC_KUMYK = "Russian (Altaic, kumyk)";
752
	public static String STR_LANGUAGE_RUSSIAN_ALTAIC_NOGAI = "Russian (Altaic, nogai)";
753
	public static String STR_LANGUAGE_RUSSIAN_ALTAIC_NORTH_AZERBAIJANI = "Russian (Altaic, north azerbaijani)";
754
	public static String STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_RUSSIAN = "Russian (Indo-european, russian)";
755
	public static String STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_KALMYK_OIRAT = "Russian (Indo-european, kalmyk-oirat)";
756
	public static String STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_OSETIN = "Russian (Indo-european, osetin)";
757
	public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_ABAZA = "Russian (North caucasian, abaza)";
758
	public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_ADYGHE = "Russian (North caucasian, adyghe)";
759
	public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_CHECHEN = "Russian (North caucasian, chechen)";
760
	public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_KABARDIAN = "Russian (North caucasian, kabardian)";
761
	public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_LAK = "Russian (North caucasian, lak)";
762
	public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_AVAR = "Russian (North caucasian, avar)";
763
	public static String STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_IN = "Russian (North caucasian, in)";
764
	public static String STR_LANGUAGE_RUSSIAN_URALIC_CHUVASH = "Russian (Uralic, chuvash)";
765
	public static String STR_LANGUAGE_RUSSIAN_URALIC_UDMURT = "Russian (Uralic, udmurt)";
766
	public static String STR_LANGUAGE_SERBIAN = "Serbian";
767
	public static String STR_LANGUAGE_SLOVAK = "Slovak";
768
	public static String STR_LANGUAGE_SLOVENE = "Slovene";
769
	public static String STR_LANGUAGE_SPANISH_CASTILLIAN = "Spanish, Castillian";
770
	public static String STR_LANGUAGE_SWEDISH = "Swedish";
771
	public static String STR_LANGUAGE_TURKISH = "Turkish";
772
	public static String STR_LANGUAGE_UKRAINE = "Ukraine";
773
	public static String STR_LANGUAGE_WELSH = "Welsh";
774
	public static String STR_LANGUAGE_CORSICAN = "Corsican";
775

    
776
	
777
	// FossilStatus
778
	public static int FOSSILSTATUS_RECENT_ONLY = 1;
779
	public static int FOSSILSTATUS_FOSSIL_ONLY = 2;
780
	public static int FOSSILSTATUS_RECENT_FOSSIL = 3;
781
	
782
	public static String STR_RECENT_ONLY = "recent only";
783
	public static String STR_FOSSIL_ONLY = "fossil only";
784
	public static String STR_RECENT_FOSSIL = "recent + fossil";
785

    
786
	// SourceUse
787
	public static int ORIGINAL_DESCRIPTION = 1;
788
	public static int BASIS_OF_RECORD = 2;
789
	public static int ADDITIONAL_SOURCE = 3;
790
	public static int SOURCE_OF_SYNONYMY = 4;
791
	public static int REDESCRIPTION = 5;
792
	public static int NEW_COMBINATION_REFERENCE = 6;
793
	public static int STATUS_SOURCE = 7;
794
	public static int NOMENCLATURAL_REFERENCE = 8;
795
	
796
	public static String STR_ORIGINAL_DESCRIPTION = "original description";
797
	public static String STR_BASIS_OF_RECORD = "basis of record";
798
	public static String STR_ADDITIONAL_SOURCE = "additional source";
799
	public static String STR_SOURCE_OF_SYNONYMY = "source of synonymy";
800
	public static String STR_REDESCRIPTION = "redescription";
801
	public static String STR_NEW_COMBINATION_REFERENCE = "new combination reference";
802
	public static String STR_STATUS_SOURCE = "status source";
803
	public static String STR_NOMENCLATURAL_REFERENCE = "nomenclatural reference";
804

    
805
	// Area
806
	public static int AREA_EAST_AEGEAN_ISLANDS = 1;
807
	public static int AREA_GREEK_EAST_AEGEAN_ISLANDS = 2;
808
	public static int AREA_TURKISH_EAST_AEGEAN_ISLANDS = 3;
809
	public static int AREA_ALBANIA = 4;
810
	public static int AREA_AUSTRIA_WITH_LIECHTENSTEIN = 5;
811
	public static int AREA_AUSTRIA = 6;
812
	public static int AREA_LIECHTENSTEIN = 7;
813
	public static int AREA_AZORES = 8;
814
	public static int AREA_CORVO = 9;
815
	public static int AREA_FAIAL = 10;
816
	public static int AREA_GRACIOSA = 11;
817
	public static int AREA_SAO_JORGE = 12;
818
	public static int AREA_FLORES = 13;
819
	public static int AREA_SAO_MIGUEL = 14;
820
	public static int AREA_PICO = 15;
821
	public static int AREA_SANTA_MARIA = 16;
822
	public static int AREA_TERCEIRA = 17;
823
	public static int AREA_BELGIUM_WITH_LUXEMBOURG = 18;
824
	public static int AREA_BELGIUM = 19;
825
	public static int AREA_LUXEMBOURG = 20;
826
	public static int AREA_BOSNIA_HERZEGOVINA = 21;
827
	public static int AREA_BALEARES = 22;
828
	public static int AREA_IBIZA_WITH_FORMENTERA = 23;
829
	public static int AREA_MALLORCA = 24;
830
	public static int AREA_MENORCA = 25;
831
	public static int AREA_GREAT_BRITAIN = 26;
832
	public static int AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION = 27;
833
	public static int AREA_BULGARIA = 28;
834
	public static int AREA_BELARUS = 29;
835
	public static int AREA_CANARY_ISLANDS = 30;
836
	public static int AREA_GRAN_CANARIA = 31;
837
	public static int AREA_FUERTEVENTURA_WITH_LOBOS = 32;
838
	public static int AREA_GOMERA = 33;
839
	public static int AREA_HIERRO = 34;
840
	public static int AREA_LANZAROTE_WITH_GRACIOSA = 35;
841
	public static int AREA_LA_PALMA = 36;
842
	public static int AREA_TENERIFE = 37;
843
	public static int AREA_MONTENEGRO = 38;
844
	public static int AREA_CORSE = 39;
845
	public static int AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS = 40;
846
	public static int AREA_CZECH_REPUBLIC = 41;
847
	public static int AREA_CROATIA = 42;
848
	public static int AREA_CYPRUS = 43;
849
	public static int AREA_FORMER_CZECHOSLOVAKIA = 44;
850
	public static int AREA_DENMARK_WITH_BORNHOLM = 45;
851
	public static int AREA_ESTONIA = 46;
852
	public static int AREA_FAROE_ISLANDS = 47;
853
	public static int AREA_FINLAND_WITH_AHVENANMAA = 48;
854
	public static int AREA_FRANCE = 49;
855
	public static int AREA_CHANNEL_ISLANDS = 50;
856
	public static int AREA_FRENCH_MAINLAND = 51;
857
	public static int AREA_MONACO = 52;
858
	public static int AREA_GERMANY = 53;
859
	public static int AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS = 54;
860
	public static int AREA_IRELAND = 55;
861
	public static int AREA_REPUBLIC_OF_IRELAND = 56;
862
	public static int AREA_NORTHERN_IRELAND = 57;
863
	public static int AREA_SWITZERLAND = 58;
864
	public static int AREA_NETHERLANDS = 59;
865
	public static int AREA_SPAIN = 60;
866
	public static int AREA_ANDORRA = 61;
867
	public static int AREA_GIBRALTAR = 62;
868
	public static int AREA_KINGDOM_OF_SPAIN = 63;
869
	public static int AREA_HUNGARY = 64;
870
	public static int AREA_ICELAND = 65;
871
	public static int AREA_ITALY = 66;
872
	public static int AREA_ITALIAN_MAINLAND = 67;
873
	public static int AREA_SAN_MARINO = 68;
874
	public static int AREA_FORMER_JUGOSLAVIA = 69;
875
	public static int AREA_LATVIA = 70;
876
	public static int AREA_LITHUANIA = 71;
877
	public static int AREA_PORTUGUESE_MAINLAND = 72;
878
	public static int AREA_MADEIRA_ARCHIPELAGO = 73;
879
	public static int AREA_DESERTAS = 74;
880
	public static int AREA_MADEIRA = 75;
881
	public static int AREA_PORTO_SANTO = 76;
882
	public static int AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA = 77;
883
	public static int AREA_MOLDOVA = 78;
884
	public static int AREA_NORWEGIAN_MAINLAND = 79;
885
	public static int AREA_POLAND = 80;
886
	public static int AREA_THE_RUSSIAN_FEDERATION = 81;
887
	public static int AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND = 82;
888
	public static int AREA_CENTRAL_EUROPEAN_RUSSIA = 83;
889
	public static int AREA_EASTERN_EUROPEAN_RUSSIA = 84;
890
	public static int AREA_KALININGRAD = 85;
891
	public static int AREA_NORTHERN_EUROPEAN_RUSSIA = 86;
892
	public static int AREA_NORTHWEST_EUROPEAN_RUSSIA = 87;
893
	public static int AREA_SOUTH_EUROPEAN_RUSSIA = 88;
894
	public static int AREA_ROMANIA = 89;
895
	public static int AREA_FORMER_USSR = 90;
896
	public static int AREA_RUSSIA_BALTIC = 91;
897
	public static int AREA_RUSSIA_CENTRAL = 92;
898
	public static int AREA_RUSSIA_SOUTHEAST = 93;
899
	public static int AREA_RUSSIA_NORTHERN = 94;
900
	public static int AREA_RUSSIA_SOUTHWEST = 95;
901
	public static int AREA_SARDEGNA = 96;
902
	public static int AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN = 97;
903
	public static int AREA_SELVAGENS_ISLANDS = 98;
904
	public static int AREA_SICILY_WITH_MALTA = 99;
905
	public static int AREA_MALTA = 100;
906
	public static int AREA_SICILY = 101;
907
	public static int AREA_SLOVAKIA = 102;
908
	public static int AREA_SLOVENIA = 103;
909
	public static int AREA_SERBIA_WITH_MONTENEGRO = 104;
910
	public static int AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO = 105;
911
	public static int AREA_SWEDEN = 106;
912
	public static int AREA_EUROPEAN_TURKEY = 107;
913
	public static int AREA_UKRAINE_INCLUDING_CRIMEA = 108;
914
	public static int AREA_CRIMEA = 109;
915
	public static int AREA_UKRAINE = 110;
916
	public static int AREA_GREEK_MAINLAND = 111;
917
	public static int AREA_CRETE = 112;
918
	public static int AREA_DODECANESE_ISLANDS = 113;
919
	public static int AREA_CYCLADES_ISLANDS = 114;
920
	public static int AREA_NORTH_AEGEAN_ISLANDS = 115;
921
	public static int AREA_VATICAN_CITY = 116;
922
	public static int AREA_FRANZ_JOSEF_LAND = 117;
923
	public static int AREA_NOVAYA_ZEMLYA = 118;
924
	public static int AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN = 119;
925
	public static int AREA_AZERBAIJAN = 120;
926
	public static int AREA_NAKHICHEVAN = 121;
927
	public static int AREA_ALGERIA = 122;
928
	public static int AREA_ARMENIA = 123;
929
	public static int AREA_CAUCASUS_REGION = 124;
930
	public static int AREA_EGYPT = 125;
931
	public static int AREA_GEORGIA = 126;
932
	public static int AREA_ISRAEL_JORDAN = 127;
933
	public static int AREA_ISRAEL = 128;
934
	public static int AREA_JORDAN = 129;
935
	public static int AREA_LEBANON = 130;
936
	public static int AREA_LIBYA = 131;
937
	public static int AREA_LEBANON_SYRIA = 132;
938
	public static int AREA_MOROCCO = 133;
939
	public static int AREA_NORTH_CAUCASUS = 134;
940
	public static int AREA_SINAI = 135;
941
	public static int AREA_SYRIA = 136;
942
	public static int AREA_TUNISIA = 137;
943
	public static int AREA_ASIATIC_TURKEY = 138;
944
	public static int AREA_TURKEY = 139;
945
	public static int AREA_NORTHERN_AFRICA = 140;
946
	public static int AREA_AFRO_TROPICAL_REGION = 141;
947
	public static int AREA_AUSTRALIAN_REGION = 142;
948
	public static int AREA_EAST_PALAEARCTIC = 143;
949
	public static int AREA_NEARCTIC_REGION = 144;
950
	public static int AREA_NEOTROPICAL_REGION = 145;
951
	public static int AREA_NEAR_EAST = 146;
952
	public static int AREA_ORIENTAL_REGION = 147;
953
	public static int AREA_EUROPEAN_MARINE_WATERS = 148;
954
	public static int AREA_MEDITERRANEAN_SEA = 149;
955
	public static int AREA_WHITE_SEA = 150;
956
	public static int AREA_NORTH_SEA = 151;
957
	public static int AREA_BALTIC_SEA = 152;
958
	public static int AREA_BLACK_SEA = 153;
959
	public static int AREA_BARENTS_SEA = 154;
960
	public static int AREA_CASPIAN_SEA = 155;
961
	public static int AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE = 156;
962
	public static int AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE = 157;
963
	public static int AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE = 158;
964
	public static int AREA_ENGLISH_CHANNEL = 159;
965
	public static int AREA_ADRIATIC_SEA = 160;
966
	public static int AREA_BISCAY_BAY = 161;
967
	public static int AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE = 162;
968
	public static int AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE = 163;
969
	public static int AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE = 164;
970
	public static int AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE = 165;
971
	public static int AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE = 166;
972
	public static int AREA_TIRRENO_SEA = 167;
973
	public static int AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE = 168;
974
	public static int AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE = 169;
975
	public static int AREA_IRISH_SEA = 170;
976
	public static int AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE = 171;
977
	public static int AREA_NORWEGIAN_SEA = 172;
978
	public static int AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE = 173;
979
	public static int AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE = 174;
980
	public static int AREA_SKAGERRAK = 175;
981
	public static int AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE = 176;
982
	public static int AREA_WADDEN_SEA = 177;
983
	public static int AREA_BELT_SEA = 178;
984
	public static int AREA_MARMARA_SEA = 179;
985
	public static int AREA_SEA_OF_AZOV = 180;
986
	public static int AREA_AEGEAN_SEA = 181;
987
	public static int AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE = 182;
988
	public static int AREA_SOUTH_BALTIC_PROPER = 183;
989
	public static int AREA_BALTIC_PROPER = 184;
990
	public static int AREA_NORTH_BALTIC_PROPER = 185;
991
	public static int AREA_ARCHIPELAGO_SEA = 186;
992
	public static int AREA_BOTHNIAN_SEA = 187;
993
	public static int AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE = 188;
994
	public static int AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE = 189;
995
	public static int AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE = 190;
996
	public static int AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE = 191;
997
	public static int AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE = 192;
998
	public static int AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART = 193;
999
	public static int AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE = 194;
1000
	public static int AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE = 195;
1001
	public static int AREA_BALEAR_SEA = 196;
1002
	public static int AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE = 197;
1003
	public static int AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE = 198;
1004
	public static int AREA_TRANSCAUCASUS = 199;
1005
	
1006
	public static int AREA_UNITED_KINGDOM = 203;
1007
	public static int AREA_DENMARK_COUNTRY = 204;
1008
	public static int AREA_TURKEY_COUNTRY = 205;
1009
	public static int AREA_SPAIN_COUNTRY = 206;
1010
	public static int AREA_GREECE_COUNTRY = 207;
1011
	public static int AREA_PORTUGAL_COUNTRY = 208;
1012

    
1013

    
1014
	public static String STR_AREA_EAST_AEGEAN_ISLANDS = "East Aegean Islands";
1015
	public static String STR_AREA_GREEK_EAST_AEGEAN_ISLANDS = "Greek East Aegean Islands";
1016
	public static String STR_AREA_TURKISH_EAST_AEGEAN_ISLANDS = "Turkish East Aegean Islands";
1017
	public static String STR_AREA_ALBANIA = "Albania";
1018
	public static String STR_AREA_AUSTRIA_WITH_LIECHTENSTEIN = "Austria with Liechtenstein";
1019
	public static String STR_AREA_AUSTRIA = "Austria";
1020
	public static String STR_AREA_LIECHTENSTEIN = "Liechtenstein";
1021
	public static String STR_AREA_AZORES = "Azores";
1022
	public static String STR_AREA_CORVO = "Corvo";
1023
	public static String STR_AREA_FAIAL = "Faial";
1024
	public static String STR_AREA_GRACIOSA = "Graciosa";
1025
	public static String STR_AREA_SAO_JORGE = "São Jorge";
1026
	public static String STR_AREA_FLORES = "Flores";
1027
	public static String STR_AREA_SAO_MIGUEL = "São Miguel";
1028
	public static String STR_AREA_PICO = "Pico";
1029
	public static String STR_AREA_SANTA_MARIA = "Santa Maria";
1030
	public static String STR_AREA_TERCEIRA = "Terceira";
1031
	public static String STR_AREA_BELGIUM_WITH_LUXEMBOURG = "Belgium with Luxembourg";
1032
	public static String STR_AREA_BELGIUM = "Belgium";
1033
	public static String STR_AREA_LUXEMBOURG = "Luxembourg";
1034
	public static String STR_AREA_BOSNIA_HERZEGOVINA = "Bosnia-Herzegovina";
1035
	public static String STR_AREA_BALEARES = "Baleares";
1036
	public static String STR_AREA_IBIZA_WITH_FORMENTERA = "Ibiza with Formentera";
1037
	public static String STR_AREA_MALLORCA = "Mallorca";
1038
	public static String STR_AREA_MENORCA = "Menorca";
1039
	public static String STR_AREA_GREAT_BRITAIN = "Great Britain";
1040
	public static String STR_AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION = "Baltic states (Estonia, Latvia, Lithuania) and Kaliningrad region";
1041
	public static String STR_AREA_BULGARIA = "Bulgaria";
1042
	public static String STR_AREA_BELARUS = "Belarus";
1043
	public static String STR_AREA_CANARY_ISLANDS = "Canary Islands";
1044
	public static String STR_AREA_GRAN_CANARIA = "Gran Canaria";
1045
	public static String STR_AREA_FUERTEVENTURA_WITH_LOBOS = "Fuerteventura with Lobos";
1046
	public static String STR_AREA_GOMERA = "Gomera";
1047
	public static String STR_AREA_HIERRO = "Hierro";
1048
	public static String STR_AREA_LANZAROTE_WITH_GRACIOSA = "Lanzarote with Graciosa";
1049
	public static String STR_AREA_LA_PALMA = "La Palma";
1050
	public static String STR_AREA_TENERIFE = "Tenerife";
1051
	public static String STR_AREA_MONTENEGRO = "Montenegro";
1052
	public static String STR_AREA_CORSE = "Corse";
1053
	public static String STR_AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS = "Crete with Karpathos, Kasos & Gavdhos";
1054
	public static String STR_AREA_CZECH_REPUBLIC = "Czech Republic";
1055
	public static String STR_AREA_CROATIA = "Croatia";
1056
	public static String STR_AREA_CYPRUS = "Cyprus";
1057
	public static String STR_AREA_FORMER_CZECHOSLOVAKIA = "Former Czechoslovakia";
1058
	public static String STR_AREA_DENMARK_WITH_BORNHOLM = "Denmark with Bornholm";
1059
	public static String STR_AREA_ESTONIA = "Estonia";
1060
	public static String STR_AREA_FAROE_ISLANDS = "Faroe Islands";
1061
	public static String STR_AREA_FINLAND_WITH_AHVENANMAA = "Finland with Ahvenanmaa";
1062
	public static String STR_AREA_FRANCE = "France";
1063
	public static String STR_AREA_CHANNEL_ISLANDS = "Channel Islands";
1064
	public static String STR_AREA_FRENCH_MAINLAND = "French mainland";
1065
	public static String STR_AREA_MONACO = "Monaco";
1066
	public static String STR_AREA_GERMANY = "Germany";
1067
	public static String STR_AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS = "Greece with Cyclades and more islands";
1068
	public static String STR_AREA_IRELAND = "Ireland";
1069
	public static String STR_AREA_REPUBLIC_OF_IRELAND = "Republic of Ireland";
1070
	public static String STR_AREA_NORTHERN_IRELAND = "Northern Ireland";
1071
	public static String STR_AREA_SWITZERLAND = "Switzerland";
1072
	public static String STR_AREA_NETHERLANDS = "Netherlands";
1073
	public static String STR_AREA_SPAIN = "Spain";
1074
	public static String STR_AREA_ANDORRA = "Andorra";
1075
	public static String STR_AREA_GIBRALTAR = "Gibraltar";
1076
	public static String STR_AREA_KINGDOM_OF_SPAIN = "Kingdom of Spain";
1077
	public static String STR_AREA_HUNGARY = "Hungary";
1078
	public static String STR_AREA_ICELAND = "Iceland";
1079
	public static String STR_AREA_ITALY = "Italy";
1080
	public static String STR_AREA_ITALIAN_MAINLAND = "Italian mainland";
1081
	public static String STR_AREA_SAN_MARINO = "San Marino";
1082
	public static String STR_AREA_FORMER_JUGOSLAVIA = "Former Jugoslavia";
1083
	public static String STR_AREA_LATVIA = "Latvia";
1084
	public static String STR_AREA_LITHUANIA = "Lithuania";
1085
	public static String STR_AREA_PORTUGUESE_MAINLAND = "Portuguese mainland";
1086
	public static String STR_AREA_MADEIRA_ARCHIPELAGO = "Madeira";
1087
	public static String STR_AREA_DESERTAS = "Desertas";
1088
	public static String STR_AREA_MADEIRA = "Madeira";
1089
	public static String STR_AREA_PORTO_SANTO = "Porto Santo";
1090
	public static String STR_AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA = "The former Jugoslav Republic of Makedonija";
1091
	public static String STR_AREA_MOLDOVA = "Moldova";
1092
	public static String STR_AREA_NORWEGIAN_MAINLAND = "Norwegian mainland";
1093
	public static String STR_AREA_POLAND = "Poland";
1094
	public static String STR_AREA_THE_RUSSIAN_FEDERATION = "The Russian Federation";
1095
	public static String STR_AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND = "Novaya Zemlya & Franz-Joseph Land";
1096
	public static String STR_AREA_CENTRAL_EUROPEAN_RUSSIA = "Central European Russia";
1097
	public static String STR_AREA_EASTERN_EUROPEAN_RUSSIA = "Eastern European Russia";
1098
	public static String STR_AREA_KALININGRAD = "Kaliningrad";
1099
	public static String STR_AREA_NORTHERN_EUROPEAN_RUSSIA = "Northern European Russia";
1100
	public static String STR_AREA_NORTHWEST_EUROPEAN_RUSSIA = "Northwest European Russia";
1101
	public static String STR_AREA_SOUTH_EUROPEAN_RUSSIA = "South European Russia";
1102
	public static String STR_AREA_ROMANIA = "Romania";
1103
	public static String STR_AREA_FORMER_USSR = "Former USSR";
1104
	public static String STR_AREA_RUSSIA_BALTIC = "Russia Baltic";
1105
	public static String STR_AREA_RUSSIA_CENTRAL = "Russia Central";
1106
	public static String STR_AREA_RUSSIA_SOUTHEAST = "Russia Southeast";
1107
	public static String STR_AREA_RUSSIA_NORTHERN = "Russia Northern";
1108
	public static String STR_AREA_RUSSIA_SOUTHWEST = "Russia Southwest";
1109
	public static String STR_AREA_SARDEGNA = "Sardegna";
1110
	public static String STR_AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN = "Svalbard with Björnöya and Jan Mayen";
1111
	public static String STR_AREA_SELVAGENS_ISLANDS = "Selvagens Islands";
1112
	public static String STR_AREA_SICILY_WITH_MALTA = "Sicily with Malta";
1113
	public static String STR_AREA_MALTA = "Malta";
1114
	public static String STR_AREA_SICILY = "Sicily";
1115
	public static String STR_AREA_SLOVAKIA = "Slovakia";
1116
	public static String STR_AREA_SLOVENIA = "Slovenia";
1117
	public static String STR_AREA_SERBIA_WITH_MONTENEGRO = "Serbia with Montenegro";
1118
	public static String STR_AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO = "Serbia including Vojvodina and with Kosovo";
1119
	public static String STR_AREA_SWEDEN = "Sweden";
1120
	public static String STR_AREA_EUROPEAN_TURKEY = "European Turkey";
1121
	public static String STR_AREA_UKRAINE_INCLUDING_CRIMEA = "Ukraine including Crimea";
1122
	public static String STR_AREA_CRIMEA = "Crimea";
1123
	public static String STR_AREA_UKRAINE = "Ukraine";
1124
	public static String STR_AREA_GREEK_MAINLAND = "Greek mainland";
1125
	public static String STR_AREA_CRETE = "Crete";
1126
	public static String STR_AREA_DODECANESE_ISLANDS = "Dodecanese Islands";
1127
	public static String STR_AREA_CYCLADES_ISLANDS = "Cyclades Islands";
1128
	public static String STR_AREA_NORTH_AEGEAN_ISLANDS = "North Aegean Islands";
1129
	public static String STR_AREA_VATICAN_CITY = "Vatican City";
1130
	public static String STR_AREA_FRANZ_JOSEF_LAND = "Franz Josef Land";
1131
	public static String STR_AREA_NOVAYA_ZEMLYA = "Novaya Zemlya";
1132
	public static String STR_AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN = "Azerbaijan including Nakhichevan";
1133
	public static String STR_AREA_AZERBAIJAN = "Azerbaijan";
1134
	public static String STR_AREA_NAKHICHEVAN = "Nakhichevan";
1135
	public static String STR_AREA_ALGERIA = "Algeria";
1136
	public static String STR_AREA_ARMENIA = "Armenia";
1137
	public static String STR_AREA_CAUCASUS_REGION = "Caucasus region";
1138
	public static String STR_AREA_EGYPT = "Egypt";
1139
	public static String STR_AREA_GEORGIA = "Georgia";
1140
	public static String STR_AREA_ISRAEL_JORDAN = "Israel-Jordan";
1141
	public static String STR_AREA_ISRAEL = "Israel";
1142
	public static String STR_AREA_JORDAN = "Jordan";
1143
	public static String STR_AREA_LEBANON = "Lebanon";
1144
	public static String STR_AREA_LIBYA = "Libya";
1145
	public static String STR_AREA_LEBANON_SYRIA = "Lebanon-Syria";
1146
	public static String STR_AREA_MOROCCO = "Morocco";
1147
	public static String STR_AREA_NORTH_CAUCASUS = "North Caucasus";
1148
	public static String STR_AREA_SINAI = "Sinai";
1149
	public static String STR_AREA_SYRIA = "Syria";
1150
	public static String STR_AREA_TUNISIA = "Tunisia";
1151
	public static String STR_AREA_ASIATIC_TURKEY = "Asiatic Turkey";
1152
	public static String STR_AREA_TURKEY = "Turkey";
1153
	public static String STR_AREA_NORTHERN_AFRICA = "Northern Africa";
1154
	public static String STR_AREA_AFRO_TROPICAL_REGION = "Afro-tropical region";
1155
	public static String STR_AREA_AUSTRALIAN_REGION = "Australian region";
1156
	public static String STR_AREA_EAST_PALAEARCTIC = "East Palaearctic";
1157
	public static String STR_AREA_NEARCTIC_REGION = "Nearctic region";
1158
	public static String STR_AREA_NEOTROPICAL_REGION = "Neotropical region";
1159
	public static String STR_AREA_NEAR_EAST = "Near East";
1160
	public static String STR_AREA_ORIENTAL_REGION = "Oriental region";
1161
	public static String STR_AREA_EUROPEAN_MARINE_WATERS = "European Marine Waters";
1162
	public static String STR_AREA_MEDITERRANEAN_SEA = "Mediterranean Sea";
1163
	public static String STR_AREA_WHITE_SEA = "White Sea";
1164
	public static String STR_AREA_NORTH_SEA = "North Sea";
1165
	public static String STR_AREA_BALTIC_SEA = "Baltic Sea";
1166
	public static String STR_AREA_BLACK_SEA = "Black Sea";
1167
	public static String STR_AREA_BARENTS_SEA = "Barents Sea";
1168
	public static String STR_AREA_CASPIAN_SEA = "Caspian Sea";
1169
	public static String STR_AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE = "Portuguese Exclusive Economic Zone";
1170
	public static String STR_AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE = "Belgian Exclusive Economic Zone";
1171
	public static String STR_AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE = "French Exclusive Economic Zone";
1172
	public static String STR_AREA_ENGLISH_CHANNEL = "English Channel";
1173
	public static String STR_AREA_ADRIATIC_SEA = "Adriatic Sea";
1174
	public static String STR_AREA_BISCAY_BAY = "Biscay Bay";
1175
	public static String STR_AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE = "Dutch Exclusive Economic Zone";
1176
	public static String STR_AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE = "United Kingdom Exclusive Economic Zone";
1177
	public static String STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE = "Spanish Exclusive Economic Zone";
1178
	public static String STR_AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE = "Egyptian Exclusive Economic Zone";
1179
	public static String STR_AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE = "Grecian Exclusive Economic Zone";
1180
	public static String STR_AREA_TIRRENO_SEA = "Tirreno Sea";
1181
	public static String STR_AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE = "Icelandic Exclusive Economic Zone";
1182
	public static String STR_AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE = "Irish Exclusive economic Zone";
1183
	public static String STR_AREA_IRISH_SEA = "Irish Sea";
1184
	public static String STR_AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE = "Italian Exclusive Economic Zone";
1185
	public static String STR_AREA_NORWEGIAN_SEA = "Norwegian Sea";
1186
	public static String STR_AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE = "Moroccan Exclusive Economic Zone";
1187
	public static String STR_AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE = "Norwegian Exclusive Economic Zone";
1188
	public static String STR_AREA_SKAGERRAK = "Skagerrak";
1189
	public static String STR_AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE = "Tunisian Exclusive Economic Zone";
1190
	public static String STR_AREA_WADDEN_SEA = "Wadden Sea";
1191
	public static String STR_AREA_BELT_SEA = "Belt Sea";
1192
	public static String STR_AREA_MARMARA_SEA = "Marmara Sea";
1193
	public static String STR_AREA_SEA_OF_AZOV = "Sea of Azov";
1194
	public static String STR_AREA_AEGEAN_SEA = "Aegean Sea";
1195
	public static String STR_AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE = "Bulgarian Exclusive Economic Zone";
1196
	public static String STR_AREA_SOUTH_BALTIC_PROPER = "South Baltic proper";
1197
	public static String STR_AREA_BALTIC_PROPER = "Baltic Proper";
1198
	public static String STR_AREA_NORTH_BALTIC_PROPER = "North Baltic proper";
1199
	public static String STR_AREA_ARCHIPELAGO_SEA = "Archipelago Sea";
1200
	public static String STR_AREA_BOTHNIAN_SEA = "Bothnian Sea";
1201
	public static String STR_AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE = "German Exclusive Economic Zone";
1202
	public static String STR_AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE = "Swedish Exclusive Economic Zone";
1203
	public static String STR_AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE = "Ukrainian Exclusive Economic Zone";
1204
	public static String STR_AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE = "Madeiran Exclusive Economic Zone";
1205
	public static String STR_AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE = "Lebanese Exclusive Economic Zone";
1206
	public static String STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART = "Spanish Exclusive Economic Zone [Mediterranean part]";
1207
	public static String STR_AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE = "Estonian Exclusive Economic Zone";
1208
	public static String STR_AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE = "Croatian Exclusive Economic Zone";
1209
	public static String STR_AREA_BALEAR_SEA = "Balear Sea";
1210
	public static String STR_AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE = "Turkish Exclusive Economic Zone";
1211
	public static String STR_AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE = "Danish Exclusive Economic Zone";
1212
	public static String STR_AREA_TRANSCAUCASUS = "Transcaucasus";
1213
	
1214
	public static String STR_AREA_UNITED_KINGDOM = "United Kingdom";
1215
	public static String STR_AREA_DENMARK = "Denmark";
1216
	public static String STR_AREA_TURKEY_COUNTRY = "Turkey (country)";
1217
	public static String STR_AREA_SPAIN_COUNTRY = "Spain (country)";
1218
	public static String STR_AREA_GREECE_COUNTRY = "Greece (country)";
1219
	public static String STR_AREA_PORTUGAL_COUNTRY = "Portugal (country)";
1220

    
1221

    
1222
	
1223
	// OccurrenceStatus
1224
	public static int STATUS_PRESENT = 1;
1225
	public static int STATUS_ABSENT = 2;
1226
	public static int STATUS_NATIVE = 3;
1227
	public static int STATUS_INTRODUCED = 4;
1228
	public static int STATUS_NATURALISED = 5;
1229
	public static int STATUS_INVASIVE = 6;
1230
	public static int STATUS_MANAGED = 7;
1231
	public static int STATUS_DOUBTFUL = 8;
1232

    
1233
	public static String STR_STATUS_PRESENT = "Present";
1234
	public static String STR_STATUS_ABSENT = "Absent";
1235
	public static String STR_STATUS_NATIVE = "Native";
1236
	public static String STR_STATUS_INTRODUCED = "Introduced";
1237
	public static String STR_STATUS_NATURALISED = "Naturalised";
1238
	public static String STR_STATUS_INVASIVE = "Invasive";
1239
	public static String STR_STATUS_MANAGED = "Managed";
1240
	public static String STR_STATUS_DOUBTFUL = "Doubtful";
1241

    
1242
	private Map<String, Integer> tdwgKeyMap = new HashMap<String, Integer>();
1243
	private Map<String, String> tdwgLabelMap = new HashMap<String, String>();
1244
	private Map<Integer, String> nameStatusCacheMap  = new HashMap<Integer, String>();
1245
	private Map<Integer, String> qualityStatusCacheMap  = new HashMap<Integer, String>();
1246
	private Map<Integer, String> taxRelQualifierCacheMap  = new HashMap<Integer, String>();
1247
	private Map<Integer, String> taxRelZooQualifierCacheMap  = new HashMap<Integer, String>();
1248
	
1249
	
1250
	private Source destination;
1251
	
1252
	public PesiTransformer(Source destination) {
1253
		super();
1254
		this.destination = destination;
1255
		fillMaps();
1256
	}
1257

    
1258
	private void fillMaps() {
1259
		//TDWG
1260
		try {
1261
			String sql = " SELECT AreaId, AreaName, AreaTdwgCode, AreaEmCode, AreaFaEuCode FROM Area";
1262
			ResultSet rs = destination.getResultSet(sql);
1263
			while (rs.next()){
1264
				String tdwg = rs.getString("AreaTdwgCode");
1265
				Integer id = rs.getInt("AreaId");
1266
				String label = rs.getString("AreaName");
1267
				
1268
				if (StringUtils.isNotBlank(tdwg)){
1269
					this.tdwgKeyMap.put(tdwg, id);
1270
					this.tdwgLabelMap.put(tdwg, label);
1271
				}
1272
			}
1273
			//nameStatusCache
1274
			sql = " SELECT NomStatusId, NomStatus FROM NameStatus ";
1275
			rs = destination.getResultSet(sql);
1276
			while (rs.next()){
1277
				Integer key = rs.getInt("NomStatusId");
1278
				String cache = rs.getString("NomStatus");
1279
				if (StringUtils.isNotBlank(cache)){
1280
					this.nameStatusCacheMap.put(key, cache);
1281
				} 
1282
			}
1283
			//qualityStatusCache
1284
			sql = " SELECT QualityStatusId,QualityStatus FROM QualityStatus ";
1285
			rs = destination.getResultSet(sql);
1286
			while (rs.next()){
1287
				Integer key = rs.getInt("QualityStatusId");
1288
				String cache = rs.getString("QualityStatus");
1289
				if (StringUtils.isNotBlank(cache)){
1290
					this.qualityStatusCacheMap.put(key, cache);
1291
				} 
1292
			}
1293
			//qualityStatusCache
1294
			sql = " SELECT QualifierId, Qualifier, ZoologQualifier FROM RelTaxonQualifier ";
1295
			rs = destination.getResultSet(sql);
1296
			while (rs.next()){
1297
				Integer key = rs.getInt("QualifierId");
1298
				String cache = rs.getString("Qualifier");
1299
				if (StringUtils.isNotBlank(cache)){
1300
					this.taxRelQualifierCacheMap.put(key, cache);
1301
				}
1302
				String zoologCache = rs.getString("ZoologQualifier");
1303
				if (StringUtils.isNotBlank(zoologCache)){
1304
					this.taxRelZooQualifierCacheMap.put(key, zoologCache);
1305
				}
1306
			}
1307
			
1308
			
1309
					
1310
		} catch (SQLException e) {
1311
			logger.error("SQLException when trying to read area map", e);
1312
			e.printStackTrace();
1313
		}
1314
		
1315
	}
1316

    
1317
	/**
1318
	 * Converts the databaseString to its abbreviation if its known.
1319
	 * Otherwise the databaseString is returned.
1320
	 * @param databaseString
1321
	 * @return
1322
	 */
1323
	public static String databaseString2Abbreviation(String databaseString) {
1324
		String result = databaseString;
1325
		if (databaseString.equals("Fauna Europaea database")) {
1326
			result = "FaEu";
1327
		}
1328
		return result;
1329
	}
1330
	
1331
	/**
1332
	 * Returns the OccurrenceStatusId for a given PresenceAbsenceTerm.
1333
	 * @param term
1334
	 * @return
1335
	 * @throws UnknownCdmTypeException 
1336
	 */
1337
	public static String presenceAbsenceTerm2OccurrenceStatusCache(PresenceAbsenceTermBase<?> term) {
1338
		String result = null;
1339
		if (term == null){
1340
			return null;
1341
		//present
1342
		}else if (term.isInstanceOf(PresenceTerm.class)) {
1343
			PresenceTerm presenceTerm = CdmBase.deproxy(term, PresenceTerm.class);
1344
			if (presenceTerm.equals(PresenceTerm.PRESENT()) || 
1345
					presenceTerm.equals(PresenceTerm.INTRODUCED_DOUBTFULLY_INTRODUCED()) || 
1346
					presenceTerm.equals(PresenceTerm.NATIVE_DOUBTFULLY_NATIVE())) {
1347
				result = STR_STATUS_PRESENT;
1348
			} else if (presenceTerm.equals(PresenceTerm.NATIVE())) {
1349
				result = STR_STATUS_NATIVE;
1350
			} else if (presenceTerm.equals(PresenceTerm.INTRODUCED()) || 
1351
					presenceTerm.equals(PresenceTerm.INTRODUCED_ADVENTITIOUS()) ||
1352
					presenceTerm.equals(PresenceTerm.INTRODUCED_UNCERTAIN_DEGREE_OF_NATURALISATION())) {
1353
				result = STR_STATUS_INTRODUCED;
1354
			} else if (presenceTerm.equals(PresenceTerm.NATURALISED()) 
1355
					|| presenceTerm.equals(PresenceTerm.INTRODUCED_NATURALIZED())) {
1356
				result = STR_STATUS_NATURALISED;
1357
			} else if (presenceTerm.equals(PresenceTerm.INVASIVE())) {
1358
				result = STR_STATUS_INVASIVE;
1359
			} else if (presenceTerm.equals(PresenceTerm.CULTIVATED())) {
1360
				result = STR_STATUS_MANAGED;
1361
			} else if (presenceTerm.equals(PresenceTerm.PRESENT_DOUBTFULLY())||
1362
					presenceTerm.equals(PresenceTerm.INTRODUCED_PRESENCE_QUESTIONABLE()) ||
1363
					presenceTerm.equals(PresenceTerm.NATIVE_PRESENCE_QUESTIONABLE() )) {
1364
				result = STR_STATUS_DOUBTFUL;
1365
			} else {
1366
				logger.error("PresenceTerm could not be translated to datawarehouse occurrence status id: " + presenceTerm.getLabel());
1367
			}
1368
		//absent	
1369
		} else if (term.isInstanceOf(AbsenceTerm.class)) {
1370
			AbsenceTerm absenceTerm = CdmBase.deproxy(term, AbsenceTerm.class);
1371
			if (absenceTerm.equals(AbsenceTerm.ABSENT()) || absenceTerm.equals(AbsenceTerm.NATIVE_FORMERLY_NATIVE()) ||
1372
					absenceTerm.equals(AbsenceTerm.CULTIVATED_REPORTED_IN_ERROR()) || absenceTerm.equals(AbsenceTerm.INTRODUCED_REPORTED_IN_ERROR()) ||
1373
					absenceTerm.equals(AbsenceTerm.INTRODUCED_FORMERLY_INTRODUCED()) || absenceTerm.equals(AbsenceTerm.NATIVE_REPORTED_IN_ERROR() ) ) {
1374
				result = STR_STATUS_ABSENT;
1375
			} else {
1376
				logger.error("AbsenceTerm could not be translated to datawarehouse occurrence status id: " + absenceTerm.getLabel());
1377
			}
1378
		}
1379
		return result;
1380
	}
1381
	
1382
	/**
1383
	 * Returns the OccurrenceStatusId for a given PresenceAbsenceTerm.
1384
	 * @param term
1385
	 * @return
1386
	 * @throws UnknownCdmTypeException 
1387
	 */
1388
	public static Integer presenceAbsenceTerm2OccurrenceStatusId(PresenceAbsenceTermBase<?> term) {
1389
		Integer result = null;
1390
		if (term == null){
1391
			return null;
1392
		//present
1393
		}else if (term.isInstanceOf(PresenceTerm.class)) {
1394
			PresenceTerm presenceTerm = CdmBase.deproxy(term, PresenceTerm.class);
1395
			if (presenceTerm.equals(PresenceTerm.PRESENT()) || 
1396
					presenceTerm.equals(PresenceTerm.INTRODUCED_DOUBTFULLY_INTRODUCED()) || 
1397
					presenceTerm.equals(PresenceTerm.NATIVE_DOUBTFULLY_NATIVE())) {
1398
				result = STATUS_PRESENT;
1399
			} else if (presenceTerm.equals(PresenceTerm.NATIVE())) {
1400
				result = STATUS_NATIVE;
1401
			} else if (presenceTerm.equals(PresenceTerm.INTRODUCED()) || 
1402
					presenceTerm.equals(PresenceTerm.INTRODUCED_ADVENTITIOUS()) ||
1403
					presenceTerm.equals(PresenceTerm.INTRODUCED_UNCERTAIN_DEGREE_OF_NATURALISATION())) {
1404
				result = STATUS_INTRODUCED;
1405
			} else if (presenceTerm.equals(PresenceTerm.NATURALISED()) 
1406
					|| presenceTerm.equals(PresenceTerm.INTRODUCED_NATURALIZED())) {
1407
				result = STATUS_NATURALISED;
1408
			} else if (presenceTerm.equals(PresenceTerm.INVASIVE())) {
1409
				result = STATUS_INVASIVE;
1410
			} else if (presenceTerm.equals(PresenceTerm.CULTIVATED())) {
1411
				result = STATUS_MANAGED;
1412
			} else if (presenceTerm.equals(PresenceTerm.PRESENT_DOUBTFULLY())||
1413
					presenceTerm.equals(PresenceTerm.INTRODUCED_PRESENCE_QUESTIONABLE()) ||
1414
					presenceTerm.equals(PresenceTerm.NATIVE_PRESENCE_QUESTIONABLE() )) {
1415
				result = STATUS_DOUBTFUL;
1416
			} else {
1417
				logger.error("PresenceTerm could not be translated to datawarehouse occurrence status id: " + presenceTerm.getLabel());
1418
			}
1419
		//absent	
1420
		} else if (term.isInstanceOf(AbsenceTerm.class)) {
1421
			AbsenceTerm absenceTerm = CdmBase.deproxy(term, AbsenceTerm.class);
1422
			if (absenceTerm.equals(AbsenceTerm.ABSENT()) || absenceTerm.equals(AbsenceTerm.NATIVE_FORMERLY_NATIVE()) ||
1423
					absenceTerm.equals(AbsenceTerm.CULTIVATED_REPORTED_IN_ERROR()) || absenceTerm.equals(AbsenceTerm.INTRODUCED_REPORTED_IN_ERROR()) ||
1424
					absenceTerm.equals(AbsenceTerm.INTRODUCED_FORMERLY_INTRODUCED()) || absenceTerm.equals(AbsenceTerm.NATIVE_REPORTED_IN_ERROR() ) ) {
1425
				result = STATUS_ABSENT;
1426
			} else {
1427
				logger.error("AbsenceTerm could not be translated to datawarehouse occurrence status id: " + absenceTerm.getLabel());
1428
			}
1429
		}
1430
		return result;
1431
	}
1432
	
1433
//	/**
1434
//	 * Returns the AreaCache for a given Area.
1435
//	 * @param area
1436
//	 * @return
1437
//	 */
1438
//	public static String area2AreaCache(NamedArea area) {
1439
//		NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
1440
//		if (area == null) {
1441
//			return null;
1442
//		} else if (area.isInstanceOf(TdwgArea.class)) {
1443
//			
1444
//			// 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
1445
//			if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI")) { return STR_AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1446
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI-OO")) { return STR_AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1447
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1448
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB")) { return STR_AREA_ALBANIA; }
1449
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB-OO")) { return STR_AREA_ALBANIA; }
1450
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT")) { return STR_AREA_AUSTRIA_WITH_LIECHTENSTEIN; }
1451
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-AU")) { return STR_AREA_AUSTRIA; }
1452
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-LI")) { return STR_AREA_LIECHTENSTEIN; }
1453
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO")) { return STR_AREA_AZORES; }
1454
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO-OO")) { return STR_AREA_AZORES; }
1455
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_CORVO; }
1456
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FAIAL; }
1457
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_GRACIOSA; }
1458
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_SAO_JORGE; }
1459
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FLORES; }
1460
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_SAO_MIGUEL; }
1461
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_PICO; }
1462
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_SANTA_MARIA; }
1463
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_TERCEIRA; }
1464
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM")) { return STR_AREA_BELGIUM_WITH_LUXEMBOURG; }
1465
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-BE")) { return STR_AREA_BELGIUM; }
1466
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-LU")) { return STR_AREA_LUXEMBOURG; }
1467
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-BH")) { return STR_AREA_BOSNIA_HERZEGOVINA; }
1468
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL")) { return STR_AREA_BALEARES; }
1469
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL-OO")) { return STR_AREA_BALEARES; }
1470
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_IBIZA_WITH_FORMENTERA; }
1471
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_MALLORCA; }
1472
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_MENORCA; }
1473
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB")) { return STR_AREA_GREAT_BRITAIN; }
1474
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB-OO")) { return STR_AREA_GREAT_BRITAIN; }
1475
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT")) { return STR_AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION; }
1476
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL")) { return STR_AREA_BULGARIA; }
1477
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL-OO")) { return STR_AREA_BULGARIA; }
1478
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR")) { return STR_AREA_BELARUS; }
1479
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR-OO")) { return STR_AREA_BELARUS; }
1480
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY")) { return STR_AREA_CANARY_ISLANDS; }
1481
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY-OO")) { return STR_AREA_CANARY_ISLANDS; }
1482
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_GRAN_CANARIA; }
1483
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FUERTEVENTURA_WITH_LOBOS; }
1484
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_GOMERA; }
1485
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_HIERRO; }
1486
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_LANZAROTE_WITH_GRACIOSA; }
1487
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_LA_PALMA; }
1488
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_TENERIFE; }
1489
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MN")) { return STR_AREA_MONTENEGRO; }
1490
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR")) { return STR_AREA_CORSE; }
1491
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR-OO")) { return STR_AREA_CORSE; }
1492
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI")) { return STR_AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
1493
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI-OO")) { return STR_AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
1494
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-CZ")) { return STR_AREA_CZECH_REPUBLIC; }
1495
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-CR")) { return STR_AREA_CROATIA; }
1496
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP")) { return STR_AREA_CYPRUS; }
1497
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP-OO")) { return STR_AREA_CYPRUS; }
1498
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE")) { return STR_AREA_FORMER_CZECHOSLOVAKIA; }
1499
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN")) { return STR_AREA_DENMARK_WITH_BORNHOLM; }
1500
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN-OO")) { return STR_AREA_DENMARK_WITH_BORNHOLM; }
1501
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-ES")) { return STR_AREA_ESTONIA; }
1502
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR")) { return STR_AREA_FAROE_ISLANDS; }
1503
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR-OO")) { return STR_AREA_FAROE_ISLANDS; }
1504
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN")) { return STR_AREA_FINLAND_WITH_AHVENANMAA; }
1505
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN-OO")) { return STR_AREA_FINLAND_WITH_AHVENANMAA; }
1506
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA")) { return STR_AREA_FRANCE; }
1507
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-CI")) { return STR_AREA_CHANNEL_ISLANDS; }
1508
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-FR")) { return STR_AREA_FRENCH_MAINLAND; }
1509
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-MO")) { return STR_AREA_MONACO; }
1510
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER")) { return STR_AREA_GERMANY; }
1511
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER-OO")) { return STR_AREA_GERMANY; }
1512
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC")) { return STR_AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
1513
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC-OO")) { return STR_AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
1514
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE")) { return STR_AREA_IRELAND; }
1515
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-IR")) { return STR_AREA_REPUBLIC_OF_IRELAND; }
1516
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-NI")) { return STR_AREA_NORTHERN_IRELAND; }
1517
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI")) { return STR_AREA_SWITZERLAND; }
1518
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI-OO")) { return STR_AREA_SWITZERLAND; }
1519
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET")) { return STR_AREA_NETHERLANDS; }
1520
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET-OO")) { return STR_AREA_NETHERLANDS; }
1521
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA")) { return STR_AREA_SPAIN; }
1522
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-AN")) { return STR_AREA_ANDORRA; }
1523
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-GI")) { return STR_AREA_GIBRALTAR; }
1524
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-SP")) { return STR_AREA_KINGDOM_OF_SPAIN; }
1525
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN")) { return STR_AREA_HUNGARY; }
1526
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN-OO")) { return STR_AREA_HUNGARY; }
1527
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE")) { return STR_AREA_ICELAND; }
1528
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE-OO")) { return STR_AREA_ICELAND; }
1529
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA")) { return STR_AREA_ITALY; }
1530
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-IT")) { return STR_AREA_ITALIAN_MAINLAND; }
1531
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-SM")) { return STR_AREA_SAN_MARINO; }
1532
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG")) { return STR_AREA_FORMER_JUGOSLAVIA; }
1533
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LA")) { return STR_AREA_LATVIA; }
1534
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LI")) { return STR_AREA_LITHUANIA; }
1535
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR")) { return STR_AREA_PORTUGUESE_MAINLAND; }
1536
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR-OO")) { return STR_AREA_PORTUGUESE_MAINLAND; }
1537
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR")) { return STR_AREA_MADEIRA_ARCHIPELAGO; }
1538
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR-OO")) { return STR_AREA_MADEIRA_ARCHIPELAGO; }
1539
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MA")) { return STR_AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA; }
1540
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-MO")) { return STR_AREA_MOLDOVA; }
1541
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR")) { return STR_AREA_NORWEGIAN_MAINLAND; }
1542
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR-OO")) { return STR_AREA_NORWEGIAN_MAINLAND; }
1543
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL")) { return STR_AREA_POLAND; }
1544
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL-OO")) { return STR_AREA_POLAND; }
1545
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return STR_AREA_THE_RUSSIAN_FEDERATION; }
1546
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB")) { return STR_AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
1547
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB-OO")) { return STR_AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
1548
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC")) { return STR_AREA_CENTRAL_EUROPEAN_RUSSIA; }
1549
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC-OO")) { return STR_AREA_CENTRAL_EUROPEAN_RUSSIA; }
1550
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE")) { return STR_AREA_EASTERN_EUROPEAN_RUSSIA; }
1551
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE-OO")) { return STR_AREA_EASTERN_EUROPEAN_RUSSIA; }
1552
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-KA")) { return STR_AREA_KALININGRAD; }
1553
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN")) { return STR_AREA_NORTHERN_EUROPEAN_RUSSIA; }
1554
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN-OO")) { return STR_AREA_NORTHERN_EUROPEAN_RUSSIA; }
1555
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW")) { return STR_AREA_NORTHWEST_EUROPEAN_RUSSIA; }
1556
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW-OO")) { return STR_AREA_NORTHWEST_EUROPEAN_RUSSIA; }
1557
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return STR_AREA_SOUTH_EUROPEAN_RUSSIA; }
1558
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS-OO")) { return STR_AREA_SOUTH_EUROPEAN_RUSSIA; }
1559
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM")) { return STR_AREA_ROMANIA; }
1560
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM-OO")) { return STR_AREA_ROMANIA; }
1561
//			
1562
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR")) { return STR_AREA_SARDEGNA; }
1563
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR-OO")) { return STR_AREA_SARDEGNA; }
1564
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA")) { return STR_AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
1565
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA-OO")) { return STR_AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
1566
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL")) { return STR_AREA_SELVAGENS_ISLANDS; }
1567
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL-OO")) { return STR_AREA_SELVAGENS_ISLANDS; }
1568
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC")) { return STR_AREA_SICILY_WITH_MALTA; }
1569
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-MA")) { return STR_AREA_MALTA; }
1570
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-SI")) { return STR_AREA_SICILY; }
1571
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-SK")) { return STR_AREA_SLOVAKIA; }
1572
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SL")) { return STR_AREA_SLOVENIA; }
1573
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CS")) { return STR_AREA_SERBIA_WITH_MONTENEGRO; }
1574
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SE")) { return STR_AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
1575
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE")) { return STR_AREA_SWEDEN; }
1576
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE-OO")) { return STR_AREA_SWEDEN; }
1577
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE")) { return STR_AREA_EUROPEAN_TURKEY; }
1578
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE-OO")) { return STR_AREA_EUROPEAN_TURKEY; }
1579
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY")) { return STR_AREA_CRIMEA; }
1580
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY-OO")) { return STR_AREA_CRIMEA; }
1581
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-UK")) { return STR_AREA_UKRAINE; }
1582
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRE")) { return STR_AREA_GREEK_MAINLAND; }
1583
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-KRI")) { return STR_AREA_CRETE; }
1584
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-DOD")) { return STR_AREA_DODECANESE_ISLANDS; }
1585
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-CYC")) { return STR_AREA_CYCLADES_ISLANDS; }
1586
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-AEG")) { return STR_AREA_NORTH_AEGEAN_ISLANDS; }
1587
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-VC")) { return STR_AREA_VATICAN_CITY; }
1588
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FRANZ_JOSEF_LAND; }
1589
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_NOVAYA_ZEMLYA; }
1590
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AZ")) { return STR_AREA_AZERBAIJAN; }
1591
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-NA")) { return STR_AREA_NAKHICHEVAN; }
1592
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG")) { return STR_AREA_ALGERIA; }
1593
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG-OO")) { return STR_AREA_ALGERIA; }
1594
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AR")) { return STR_AREA_ARMENIA; }
1595
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("33")) { return STR_AREA_CAUCASUS_REGION; }
1596
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY")) { return STR_AREA_EGYPT; }
1597
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY-OO")) { return STR_AREA_EGYPT; }
1598
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL")) { return STR_AREA_ISRAEL_JORDAN; }
1599
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-IS")) { return STR_AREA_ISRAEL; }
1600
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-JO")) { return STR_AREA_JORDAN; }
1601
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-LB")) { return STR_AREA_LEBANON; }
1602
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBY-OO")) { return STR_AREA_LIBYA; }
1603
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS")) { return STR_AREA_LEBANON_SYRIA; }
1604
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MOR")) { return STR_AREA_MOROCCO; }
1605
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NCS")) { return STR_AREA_NORTH_CAUCASUS; }
1606
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN")) { return STR_AREA_SINAI; }
1607
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN-OO")) { return STR_AREA_SINAI; }
1608
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-SY")) { return STR_AREA_SYRIA; }
1609
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN")) { return STR_AREA_TUNISIA; }
1610
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN-OO")) { return STR_AREA_TUNISIA; }
1611
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUR-OO")) { return STR_AREA_ASIATIC_TURKEY; }
1612
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("20")) { return STR_AREA_NORTHERN_AFRICA; }
1613
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AFR")) { return STR_AREA_AFRO_TROPICAL_REGION; }
1614
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUS")) { return STR_AREA_AUSTRALIAN_REGION; }
1615
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_EAST_PALAEARCTIC; }
1616
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEA")) { return STR_AREA_NEARCTIC_REGION; }
1617
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEO")) { return STR_AREA_NEOTROPICAL_REGION; }
1618
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NRE")) { return STR_AREA_NEAR_EAST; }
1619
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ORR")) { return STR_AREA_ORIENTAL_REGION; }
1620
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS")) { return STR_AREA_TRANSCAUCASUS; }
1621
//			
1622
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return STR_AREA_EUROPEAN_MARINE_WATERS; }
1623
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||
1624
//					(namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return STR_AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
1625
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return STR_AREA_WHITE_SEA; }
1626
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return STR_AREA_NORTH_SEA; }
1627
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return STR_AREA_BALTIC_SEA; }
1628
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||
1629
//					(namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return STR_AREA_BLACK_SEA; } // abbreviated label missing
1630
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return STR_AREA_BARENTS_SEA; }
1631
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
1632
//					(namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return STR_AREA_CASPIAN_SEA; } // abbreviated label missing
1633
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return STR_AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1634
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return STR_AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1635
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return STR_AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
1636
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return STR_AREA_ENGLISH_CHANNEL; }
1637
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return STR_AREA_ADRIATIC_SEA; }
1638
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return STR_AREA_BISCAY_BAY; }
1639
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return STR_AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
1640
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return STR_AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
1641
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1642
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return STR_AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1643
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return STR_AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1644
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return STR_AREA_TIRRENO_SEA; }
1645
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return STR_AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
1646
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return STR_AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
1647
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return STR_AREA_IRISH_SEA; }
1648
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return STR_AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1649
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return STR_AREA_NORWEGIAN_SEA; }
1650
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return STR_AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
1651
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return STR_AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1652
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return STR_AREA_SKAGERRAK; }
1653
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return STR_AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1654
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return STR_AREA_WADDEN_SEA; }
1655
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return STR_AREA_BELT_SEA; }
1656
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return STR_AREA_MARMARA_SEA; }
1657
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return STR_AREA_SEA_OF_AZOV; }
1658
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return STR_AREA_AEGEAN_SEA; }
1659
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return STR_AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1660
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return STR_AREA_SOUTH_BALTIC_PROPER; }
1661
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return STR_AREA_BALTIC_PROPER; }
1662
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return STR_AREA_NORTH_BALTIC_PROPER; }
1663
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return STR_AREA_ARCHIPELAGO_SEA; }
1664
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return STR_AREA_BOTHNIAN_SEA; }
1665
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return STR_AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
1666
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return STR_AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
1667
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return STR_AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1668
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return STR_AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
1669
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return STR_AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
1670
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
1671
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return STR_AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1672
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return STR_AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1673
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return STR_AREA_BALEAR_SEA; }
1674
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return STR_AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
1675
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return STR_AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1676
//			else {
1677
//				logger.error("Unknown NamedArea Area: " + area.getTitleCache());
1678
//			}
1679
//		}else if (namedArea.isInstanceOf(WaterbodyOrCountry.class)){
1680
//			if ((namedArea.equals(WaterbodyOrCountry.UKRAINE()))) { return STR_AREA_UKRAINE_INCLUDING_CRIMEA; }
1681
//			else if (namedArea.equals(WaterbodyOrCountry.AZERBAIJANREPUBLICOF())) { return STR_AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1682
//			else if (namedArea.equals(WaterbodyOrCountry.GEORGIA())) { return STR_AREA_GEORGIA; }
1683
//			else {
1684
//				logger.warn("Unknown NamedArea Area: " + area.getTitleCache());
1685
//			}
1686
//		}else {
1687
//			if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidMadeira))){ return STR_AREA_MADEIRA; }
1688
//			else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidDesertas))) { return STR_AREA_DESERTAS; }
1689
//			else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidPortoSanto))) { return STR_AREA_PORTO_SANTO; }
1690
//			else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaBaltic))) { return STR_AREA_RUSSIA_BALTIC; }
1691
//			else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthEast))) { return STR_AREA_RUSSIA_SOUTHEAST; }
1692
//			else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthWest))) { return STR_AREA_RUSSIA_SOUTHWEST; }
1693
//			else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidUssr))) { return STR_AREA_FORMER_USSR; }
1694
//			else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaCentral))) { return STR_AREA_RUSSIA_CENTRAL; }
1695
//			else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaNorthern))) { return STR_AREA_RUSSIA_NORTHERN; }
1696
//			else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkey))) { return STR_AREA_TURKEY; }
1697
//			else if ((namedArea.getUuid().equals(BerlinModelTransformer.uuidEastAegeanIslands))) { return STR_AREA_EAST_AEGEAN_ISLANDS; }
1698
//			
1699
//			else {
1700
//				logger.warn("Unknown NamedArea Area: " + area.getTitleCache());
1701
//			}
1702
//		}
1703
//		return null; // Actually the export has to stop here because AreaFk's are not allowed to be NULL.
1704
//	}
1705

    
1706
	@Override
1707
	public String getCacheByPresenceAbsenceTerm(PresenceAbsenceTermBase status) throws UndefinedTransformerMethodException {
1708
		return presenceAbsenceTerm2OccurrenceStatusCache(status);
1709
	}
1710
	
1711
	@Override
1712
	public Object getKeyByPresenceAbsenceTerm(PresenceAbsenceTermBase status) throws UndefinedTransformerMethodException {
1713
		return presenceAbsenceTerm2OccurrenceStatusId(status);
1714
	}
1715
	
1716
	
1717
	
1718
	@Override
1719
	public String getCacheByNamedArea(NamedArea area) throws UndefinedTransformerMethodException {
1720
		NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
1721

    
1722
		if (namedArea == null) {
1723
			return null;
1724
		//TDWG areas
1725
		} else if (namedArea.isInstanceOf(TdwgArea.class)) {
1726
			String abbrevLabel = namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel();
1727
			String result = this.tdwgLabelMap.get(abbrevLabel);
1728
			if (result == null){
1729
				logger.warn("Unknown TDWGArea: " + namedArea.getTitleCache());
1730
			}
1731
			return result;
1732
		//countries & Waterbodies
1733
		}else if (namedArea.isInstanceOf(WaterbodyOrCountry.class)){
1734
			if (namedArea.equals(WaterbodyOrCountry.UKRAINE())) { return STR_AREA_UKRAINE_INCLUDING_CRIMEA; }
1735
			else if (namedArea.equals(WaterbodyOrCountry.AZERBAIJANREPUBLICOF())) { return STR_AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1736
			else if (namedArea.equals(WaterbodyOrCountry.GEORGIA())) { return STR_AREA_GEORGIA; }
1737
			else if (namedArea.equals(WaterbodyOrCountry.RUSSIANFEDERATION())) { return STR_AREA_THE_RUSSIAN_FEDERATION; }
1738
			else if (namedArea.equals(WaterbodyOrCountry.UNITEDKINGDOMOFGREATBRITAINANDNORTHERNIRELAND())) { return STR_AREA_UNITED_KINGDOM; }
1739
			else if (namedArea.equals(WaterbodyOrCountry.DENMARKKINGDOMOF())) { return STR_AREA_DENMARK; }
1740
			else if (namedArea.equals(WaterbodyOrCountry.TURKEYREPUBLICOF())) { return STR_AREA_TURKEY_COUNTRY; }
1741
			else {
1742
				logger.warn("Unknown Waterbody/Country: " + namedArea.getTitleCache());
1743
			}
1744
		}else{  //Non TDWG, non country
1745
			//E+M
1746
			if ( namedArea.getUuid().equals(BerlinModelTransformer.uuidMadeira)){ return STR_AREA_MADEIRA; }
1747
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidDesertas)) { return STR_AREA_DESERTAS; }
1748
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPortoSanto)) { return STR_AREA_PORTO_SANTO; }
1749
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFlores)) { return STR_AREA_FLORES; }
1750
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCorvo)) { return STR_AREA_CORVO; }
1751
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFaial)) { return STR_AREA_FAIAL; }
1752
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGraciosa)) { return STR_AREA_GRACIOSA; }
1753
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSaoJorge)) { return STR_AREA_SAO_JORGE; }
1754
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSaoMiguel)) { return STR_AREA_SAO_MIGUEL; }
1755
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPico)) { return STR_AREA_PICO; }
1756
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSantaMaria)) { return STR_AREA_SANTA_MARIA; }
1757
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTerceira)) { return STR_AREA_TERCEIRA; }
1758
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGranCanaria)) { return STR_AREA_GRAN_CANARIA; }
1759
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFuerteventura)) { return STR_AREA_FUERTEVENTURA_WITH_LOBOS; }
1760
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGomera)) { return STR_AREA_GOMERA; }
1761
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHierro)) { return STR_AREA_HIERRO; }
1762
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLanzaroteWithGraciosa)) { return STR_AREA_LANZAROTE_WITH_GRACIOSA; }
1763
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLaPalma)) { return STR_AREA_LA_PALMA; }
1764
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTenerife)) { return STR_AREA_TENERIFE; }
1765
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidIbizaWithFormentera)) { return STR_AREA_IBIZA_WITH_FORMENTERA; }
1766
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMallorca)) { return STR_AREA_MALLORCA; }
1767
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMenorca)) { return STR_AREA_MENORCA; }
1768
			
1769
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUssr)) { return STR_AREA_FORMER_USSR; }
1770
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaBaltic)) { return STR_AREA_RUSSIA_BALTIC; }
1771
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthEast)) { return STR_AREA_RUSSIA_SOUTHEAST; }
1772
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthWest)) { return STR_AREA_RUSSIA_SOUTHWEST; }
1773
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaCentral)) { return STR_AREA_RUSSIA_CENTRAL; }
1774
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaNorthern)) { return STR_AREA_RUSSIA_NORTHERN; }
1775
			
1776
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkey)) { return STR_AREA_TURKEY; }
1777
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEastAegeanIslands)) { return STR_AREA_EAST_AEGEAN_ISLANDS; }
1778
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFlores)) { return STR_AREA_FLORES; }
1779
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkishEastAegeanIslands)) { return STR_AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1780
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSerbiaMontenegro)) { return STR_AREA_SERBIA_WITH_MONTENEGRO; }
1781
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSerbia)) { return STR_AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
1782
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCaucasia)) { return STR_AREA_CAUCASUS_REGION; }
1783
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUkraineAndCrimea)) { return STR_AREA_UKRAINE_INCLUDING_CRIMEA; }
1784
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAzerbaijanNakhichevan)) { return STR_AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1785
			
1786
			
1787
			//FE
1788
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaAFR)) { return STR_AREA_AFRO_TROPICAL_REGION; }
1789
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaAUS)) { return STR_AREA_AUSTRALIAN_REGION; }
1790
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaEPA)) { return STR_AREA_EAST_PALAEARCTIC; }
1791
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_AEG)) { return STR_AREA_NORTH_AEGEAN_ISLANDS; }
1792
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_CYC)) { return STR_AREA_CYCLADES_ISLANDS; }
1793
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_DOD)) { return STR_AREA_DODECANESE_ISLANDS; }
1794
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_CR)){ return STR_AREA_CRETE;}
1795
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNAF)) { return STR_AREA_NORTHERN_AFRICA; }
1796
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNEA)) { return STR_AREA_NEARCTIC_REGION; }
1797
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNEO)) { return STR_AREA_NEOTROPICAL_REGION; }
1798
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNRE)) { return STR_AREA_NEAR_EAST; }
1799
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaORR)) { return STR_AREA_ORIENTAL_REGION; }
1800
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaUA)){ return STR_AREA_UKRAINE;}
1801
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaRU_NOZ)) { return STR_AREA_NOVAYA_ZEMLYA;}
1802
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaRU_FJL)){ return STR_AREA_FRANZ_JOSEF_LAND;}
1803
			
1804
			
1805
			
1806
			//ERMS
1807
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return STR_AREA_EUROPEAN_MARINE_WATERS; }
1808
			else if ( //(namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||    !! NPE
1809
					(namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return STR_AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
1810
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return STR_AREA_WHITE_SEA; }
1811
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return STR_AREA_NORTH_SEA; }
1812
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return STR_AREA_BALTIC_SEA; }
1813
			else if ( //(namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||      !! NPE
1814
					(namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return STR_AREA_BLACK_SEA; } // abbreviated label missing
1815
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return STR_AREA_BARENTS_SEA; }
1816
			else if ( // (namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||      !! NPE
1817
					(namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return STR_AREA_CASPIAN_SEA; } // abbreviated label missing
1818
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return STR_AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1819
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return STR_AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1820
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return STR_AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
1821
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return STR_AREA_ENGLISH_CHANNEL; }
1822
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return STR_AREA_ADRIATIC_SEA; }
1823
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return STR_AREA_BISCAY_BAY; }
1824
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return STR_AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
1825
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return STR_AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
1826
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1827
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return STR_AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1828
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return STR_AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1829
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return STR_AREA_TIRRENO_SEA; }
1830
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return STR_AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
1831
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return STR_AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
1832
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return STR_AREA_IRISH_SEA; }
1833
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return STR_AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1834
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return STR_AREA_NORWEGIAN_SEA; }
1835
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return STR_AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
1836
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return STR_AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1837
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return STR_AREA_SKAGERRAK; }
1838
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return STR_AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1839
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return STR_AREA_WADDEN_SEA; }
1840
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return STR_AREA_BELT_SEA; }
1841
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return STR_AREA_MARMARA_SEA; }
1842
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return STR_AREA_SEA_OF_AZOV; }
1843
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return STR_AREA_AEGEAN_SEA; }
1844
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return STR_AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1845
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return STR_AREA_SOUTH_BALTIC_PROPER; }
1846
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return STR_AREA_BALTIC_PROPER; }
1847
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return STR_AREA_NORTH_BALTIC_PROPER; }
1848
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return STR_AREA_ARCHIPELAGO_SEA; }
1849
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return STR_AREA_BOTHNIAN_SEA; }
1850
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return STR_AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
1851
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return STR_AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
1852
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return STR_AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1853
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return STR_AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
1854
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return STR_AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
1855
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
1856
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return STR_AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1857
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return STR_AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1858
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return STR_AREA_BALEAR_SEA; }
1859
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return STR_AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
1860
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return STR_AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1861
			
1862
			else {
1863
				logger.warn("Unknown NamedArea Area: " + namedArea.getTitleCache());
1864
			}
1865

    
1866
		}
1867
		return null;
1868
	}
1869
	
1870
	
1871
	@Override
1872
	public Object getKeyByNamedArea(NamedArea area) throws UndefinedTransformerMethodException {
1873
		NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
1874

    
1875
		if (area == null) {
1876
			return null;
1877
		//TDWG areas
1878
		} else if (area.isInstanceOf(TdwgArea.class)) {
1879
			String abbrevLabel = namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel();
1880
			Integer result = this.tdwgKeyMap.get(abbrevLabel);
1881
			if (result == null){
1882
				logger.warn("Unknown TDWGArea: " + area.getTitleCache());
1883
			}
1884
			return result;
1885
		//countries & Waterbodies
1886
		}else if (namedArea.isInstanceOf(WaterbodyOrCountry.class)){
1887
			if (namedArea.equals(WaterbodyOrCountry.UKRAINE())) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
1888
			else if (namedArea.equals(WaterbodyOrCountry.AZERBAIJANREPUBLICOF())) { return AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1889
			else if (namedArea.equals(WaterbodyOrCountry.GEORGIA())) { return AREA_GEORGIA; }
1890
			else if (namedArea.equals(WaterbodyOrCountry.RUSSIANFEDERATION())) { return AREA_THE_RUSSIAN_FEDERATION; }
1891
			else if (namedArea.equals(WaterbodyOrCountry.UNITEDKINGDOMOFGREATBRITAINANDNORTHERNIRELAND())) { return AREA_UNITED_KINGDOM; }
1892
			else if (namedArea.equals(WaterbodyOrCountry.DENMARKKINGDOMOF())) { return AREA_DENMARK_COUNTRY; }
1893
			else if (namedArea.equals(WaterbodyOrCountry.TURKEYREPUBLICOF())) { return AREA_TURKEY_COUNTRY; }
1894
			else {
1895
				logger.warn("Unknown Waterbody/Country: " + area.getTitleCache());
1896
			}
1897
		}else{  //Non TDWG, non country
1898
			//EM
1899
			if ( namedArea.getUuid().equals(BerlinModelTransformer.uuidMadeira)){ return AREA_MADEIRA; }
1900
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidDesertas)) { return AREA_DESERTAS; }
1901
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPortoSanto)) { return AREA_PORTO_SANTO; }
1902
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFlores)) { return AREA_FLORES; }
1903
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCorvo)) { return AREA_CORVO; }
1904
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFaial)) { return AREA_FAIAL; }
1905
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGraciosa)) { return AREA_GRACIOSA; }
1906
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSaoJorge)) { return AREA_SAO_JORGE; }
1907
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSaoMiguel)) { return AREA_SAO_MIGUEL; }
1908
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPico)) { return AREA_PICO; }
1909
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSantaMaria)) { return AREA_SANTA_MARIA; }
1910
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTerceira)) { return AREA_TERCEIRA; }
1911
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGranCanaria)) { return AREA_GRAN_CANARIA; }
1912
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFuerteventura)) { return AREA_FUERTEVENTURA_WITH_LOBOS; }
1913
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGomera)) { return AREA_GOMERA; }
1914
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHierro)) { return AREA_HIERRO; }
1915
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLanzaroteWithGraciosa)) { return AREA_LANZAROTE_WITH_GRACIOSA; }
1916
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLaPalma)) { return AREA_LA_PALMA; }
1917
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTenerife)) { return AREA_TENERIFE; }
1918
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidIbizaWithFormentera)) { return AREA_IBIZA_WITH_FORMENTERA; }
1919
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMallorca)) { return AREA_MALLORCA; }
1920
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMenorca)) { return AREA_MENORCA; }
1921
			
1922
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUssr)) { return AREA_FORMER_USSR; }
1923
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaBaltic)) { return AREA_RUSSIA_BALTIC; }
1924
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthEast)) { return AREA_RUSSIA_SOUTHEAST; }
1925
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthWest)) { return AREA_RUSSIA_SOUTHWEST; }
1926
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaCentral)) { return AREA_RUSSIA_CENTRAL; }
1927
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaNorthern)) { return AREA_RUSSIA_NORTHERN; }
1928
			
1929
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkey)) { return AREA_TURKEY; }
1930
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEastAegeanIslands)) { return AREA_EAST_AEGEAN_ISLANDS; }
1931
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkishEastAegeanIslands)) { return AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1932
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSerbiaMontenegro)) { return AREA_SERBIA_WITH_MONTENEGRO; }
1933
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSerbia)) { return AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
1934
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCaucasia)) { return AREA_CAUCASUS_REGION; }
1935
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUkraineAndCrimea)) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
1936
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAzerbaijanNakhichevan)) { return AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1937
			
1938
			//FE
1939
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaAFR)) { return AREA_AFRO_TROPICAL_REGION; }
1940
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaAUS)) { return AREA_AUSTRALIAN_REGION; }
1941
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaEPA)) { return AREA_EAST_PALAEARCTIC; }
1942
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_AEG)) { return AREA_NORTH_AEGEAN_ISLANDS; }
1943
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_CYC)) { return AREA_CYCLADES_ISLANDS; }
1944
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_DOD)) { return AREA_DODECANESE_ISLANDS; }
1945
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_CR)) { return AREA_CRETE; }
1946
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_GRC)) { return AREA_GREEK_MAINLAND; }
1947
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNAF)) { return AREA_NORTHERN_AFRICA; }
1948
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNEA)) { return AREA_NEARCTIC_REGION; }
1949
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNEO)) { return AREA_NEOTROPICAL_REGION; }
1950
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNRE)) { return AREA_NEAR_EAST; }
1951
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaORR)) { return AREA_ORIENTAL_REGION; }
1952
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaUA)) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
1953
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaRU_FJL)) { return AREA_FRANZ_JOSEF_LAND; }
1954
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaRU_NOZ)) { return AREA_NOVAYA_ZEMLYA; }
1955
			
1956

    
1957
			//ERMS
1958
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return AREA_EUROPEAN_MARINE_WATERS; }
1959
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||
1960
					(namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
1961
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return AREA_WHITE_SEA; }
1962
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return AREA_NORTH_SEA; }
1963
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return AREA_BALTIC_SEA; }
1964
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||
1965
					(namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return AREA_BLACK_SEA; } // abbreviated label missing
1966
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return AREA_BARENTS_SEA; }
1967
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
1968
					(namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return AREA_CASPIAN_SEA; } // abbreviated label missingelse if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1969
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1970
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
1971
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return AREA_ENGLISH_CHANNEL; }
1972
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return AREA_ADRIATIC_SEA; }
1973
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return AREA_BISCAY_BAY; }
1974
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
1975
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
1976
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1977
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1978
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1979
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return AREA_TIRRENO_SEA; }
1980
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
1981
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
1982
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return AREA_IRISH_SEA; }
1983
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1984
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return AREA_NORWEGIAN_SEA; }
1985
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
1986
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1987
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return AREA_SKAGERRAK; }
1988
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1989
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return AREA_WADDEN_SEA; }
1990
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return AREA_BELT_SEA; }
1991
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return AREA_MARMARA_SEA; }
1992
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return AREA_SEA_OF_AZOV; }
1993
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return AREA_AEGEAN_SEA; }
1994
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1995
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return AREA_SOUTH_BALTIC_PROPER; }
1996
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return AREA_BALTIC_PROPER; }
1997
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return AREA_NORTH_BALTIC_PROPER; }
1998
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return AREA_ARCHIPELAGO_SEA; }
1999
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return AREA_BOTHNIAN_SEA; }
2000
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
2001
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
2002
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2003
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
2004
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
2005
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
2006
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2007
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2008
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return AREA_BALEAR_SEA; }
2009
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
2010
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
2011

    
2012
			
2013
			else {
2014
				logger.warn("Unknown NamedArea Area: " + area.getTitleCache());
2015
			}
2016

    
2017
		}
2018
		return null;
2019
	}
2020
	
2021
	
2022
//	/**
2023
//	 * Returns the AreaId for a given Area.
2024
//	 * @param area
2025
//	 * @return
2026
//	 */
2027
//	public static Integer area2AreaId(NamedArea area) {
2028
//		NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
2029
//
2030
//		if (area == null) {
2031
//			return null;
2032
//		} else if (area.isInstanceOf(TdwgArea.class)) {
2033
//			
2034
//			// 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
2035
//			if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI")) { return AREA_GREEK_EAST_AEGEAN_ISLANDS; }
2036
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI-OO")) { return AREA_GREEK_EAST_AEGEAN_ISLANDS; }
2037
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
2038
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB")) { return AREA_ALBANIA; }
2039
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB-OO")) { return AREA_ALBANIA; }
2040
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT")) { return AREA_AUSTRIA_WITH_LIECHTENSTEIN; }
2041
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-AU")) { return AREA_AUSTRIA; }
2042
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-LI")) { return AREA_LIECHTENSTEIN; }
2043
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO")) { return AREA_AZORES; }
2044
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO-OO")) { return AREA_AZORES; }
2045
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_CORVO; }
2046
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FAIAL; }
2047
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_GRACIOSA; }
2048
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_SAO_JORGE; }
2049
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FLORES; }
2050
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_SAO_MIGUEL; }
2051
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_PICO; }
2052
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_SANTA_MARIA; }
2053
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_TERCEIRA; }
2054
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM")) { return AREA_BELGIUM_WITH_LUXEMBOURG; }
2055
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-BE")) { return AREA_BELGIUM; }
2056
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-LU")) { return AREA_LUXEMBOURG; }
2057
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-BH")) { return AREA_BOSNIA_HERZEGOVINA; }
2058
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL")) { return AREA_BALEARES; }
2059
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL-OO")) { return AREA_BALEARES; }
2060
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_IBIZA_WITH_FORMENTERA; }
2061
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_MALLORCA; }
2062
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_MENORCA; }
2063
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB")) { return AREA_GREAT_BRITAIN; }
2064
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB-OO")) { return AREA_GREAT_BRITAIN; }
2065
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT")) { return AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION; }
2066
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL")) { return AREA_BULGARIA; }
2067
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL-OO")) { return AREA_BULGARIA; }
2068
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR")) { return AREA_BELARUS; }
2069
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR-OO")) { return AREA_BELARUS; }
2070
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY")) { return AREA_CANARY_ISLANDS; }
2071
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY-OO")) { return AREA_CANARY_ISLANDS; }
2072
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_GRAN_CANARIA; }
2073
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FUERTEVENTURA_WITH_LOBOS; }
2074
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_GOMERA; }
2075
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_HIERRO; }
2076
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_LANZAROTE_WITH_GRACIOSA; }
2077
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_LA_PALMA; }
2078
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_TENERIFE; }
2079
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MN")) { return AREA_MONTENEGRO; }
2080
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR")) { return AREA_CORSE; }
2081
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR-OO")) { return AREA_CORSE; }
2082
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI")) { return AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
2083
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI-OO")) { return AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
2084
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-CZ")) { return AREA_CZECH_REPUBLIC; }
2085
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-CR")) { return AREA_CROATIA; }
2086
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP")) { return AREA_CYPRUS; }
2087
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP-OO")) { return AREA_CYPRUS; }
2088
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE")) { return AREA_FORMER_CZECHOSLOVAKIA; }
2089
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN")) { return AREA_DENMARK_WITH_BORNHOLM; }
2090
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN-OO")) { return AREA_DENMARK_WITH_BORNHOLM; }
2091
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-ES")) { return AREA_ESTONIA; }
2092
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR")) { return AREA_FAROE_ISLANDS; }
2093
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR-OO")) { return AREA_FAROE_ISLANDS; }
2094
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN")) { return AREA_FINLAND_WITH_AHVENANMAA; }
2095
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN-OO")) { return AREA_FINLAND_WITH_AHVENANMAA; }
2096
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA")) { return AREA_FRANCE; }
2097
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-CI")) { return AREA_CHANNEL_ISLANDS; }
2098
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-FR")) { return AREA_FRENCH_MAINLAND; }
2099
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-MO")) { return AREA_MONACO; }
2100
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER")) { return AREA_GERMANY; }
2101
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER-OO")) { return AREA_GERMANY; }
2102
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC")) { return AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
2103
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC-OO")) { return AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
2104
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE")) { return AREA_IRELAND; }
2105
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-IR")) { return AREA_REPUBLIC_OF_IRELAND; }
2106
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-NI")) { return AREA_NORTHERN_IRELAND; }
2107
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI")) { return AREA_SWITZERLAND; }
2108
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI-OO")) { return AREA_SWITZERLAND; }
2109
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET")) { return AREA_NETHERLANDS; }
2110
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET-OO")) { return AREA_NETHERLANDS; }
2111
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA")) { return AREA_SPAIN; }
2112
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-AN")) { return AREA_ANDORRA; }
2113
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-GI")) { return AREA_GIBRALTAR; }
2114
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-SP")) { return AREA_KINGDOM_OF_SPAIN; }
2115
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN")) { return AREA_HUNGARY; }
2116
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN-OO")) { return AREA_HUNGARY; }
2117
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE")) { return AREA_ICELAND; }
2118
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE-OO")) { return AREA_ICELAND; }
2119
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA")) { return AREA_ITALY; }
2120
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-IT")) { return AREA_ITALIAN_MAINLAND; }
2121
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-SM")) { return AREA_SAN_MARINO; }
2122
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG")) { return AREA_FORMER_JUGOSLAVIA; }
2123
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LA")) { return AREA_LATVIA; }
2124
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LI")) { return AREA_LITHUANIA; }
2125
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR")) { return AREA_PORTUGUESE_MAINLAND; }
2126
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR-OO")) { return AREA_PORTUGUESE_MAINLAND; }
2127
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR")) { return AREA_MADEIRA_ARCHIPELAGO; }
2128
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR-OO")) { return AREA_MADEIRA_ARCHIPELAGO; }
2129
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MA")) { return AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA; }
2130
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-MO")) { return AREA_MOLDOVA; }
2131
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR")) { return AREA_NORWEGIAN_MAINLAND; }
2132
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR-OO")) { return AREA_NORWEGIAN_MAINLAND; }
2133
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL")) { return AREA_POLAND; }
2134
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL-OO")) { return AREA_POLAND; }
2135
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return AREA_THE_RUSSIAN_FEDERATION; }
2136
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB")) { return AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
2137
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB-OO")) { return AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
2138
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC")) { return AREA_CENTRAL_EUROPEAN_RUSSIA; }
2139
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC-OO")) { return AREA_CENTRAL_EUROPEAN_RUSSIA; }
2140
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE")) { return AREA_EASTERN_EUROPEAN_RUSSIA; }
2141
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE-OO")) { return AREA_EASTERN_EUROPEAN_RUSSIA; }
2142
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-KA")) { return AREA_KALININGRAD; }
2143
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN")) { return AREA_NORTHERN_EUROPEAN_RUSSIA; }
2144
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN-OO")) { return AREA_NORTHERN_EUROPEAN_RUSSIA; }
2145
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW")) { return AREA_NORTHWEST_EUROPEAN_RUSSIA; }
2146
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW-OO")) { return AREA_NORTHWEST_EUROPEAN_RUSSIA; }
2147
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return AREA_SOUTH_EUROPEAN_RUSSIA; }
2148
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS-OO")) { return AREA_SOUTH_EUROPEAN_RUSSIA; }
2149
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM")) { return AREA_ROMANIA; }
2150
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM-OO")) { return AREA_ROMANIA; }
2151
//			
2152
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR")) { return AREA_SARDEGNA; }
2153
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR-OO")) { return AREA_SARDEGNA; }
2154
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA")) { return AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
2155
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA-OO")) { return AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
2156
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL")) { return AREA_SELVAGENS_ISLANDS; }
2157
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL-OO")) { return AREA_SELVAGENS_ISLANDS; }
2158
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC")) { return AREA_SICILY_WITH_MALTA; }
2159
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-MA")) { return AREA_MALTA; }
2160
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-SI")) { return AREA_SICILY; }
2161
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-SK")) { return AREA_SLOVAKIA; }
2162
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SL")) { return AREA_SLOVENIA; }
2163
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CS")) { return AREA_SERBIA_WITH_MONTENEGRO; }
2164
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SE")) { return AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
2165
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE")) { return AREA_SWEDEN; }
2166
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE-OO")) { return AREA_SWEDEN; }
2167
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE")) { return AREA_EUROPEAN_TURKEY; }
2168
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE-OO")) { return AREA_EUROPEAN_TURKEY; }
2169
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY")) { return AREA_CRIMEA; }
2170
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY-OO")) { return AREA_CRIMEA; }
2171
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-UK")) { return AREA_UKRAINE; }
2172
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRE")) { return AREA_GREEK_MAINLAND; }
2173
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-KRI")) { return AREA_CRETE; }
2174
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-DOD")) { return AREA_DODECANESE_ISLANDS; }
2175
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-CYC")) { return AREA_CYCLADES_ISLANDS; }
2176
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-AEG")) { return AREA_NORTH_AEGEAN_ISLANDS; }
2177
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-VC")) { return AREA_VATICAN_CITY; }
2178
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FRANZ_JOSEF_LAND; }
2179
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_NOVAYA_ZEMLYA; }
2180
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AZ")) { return AREA_AZERBAIJAN; }
2181
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-NA")) { return AREA_NAKHICHEVAN; }
2182
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG")) { return AREA_ALGERIA; }
2183
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG-OO")) { return AREA_ALGERIA; }
2184
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AR")) { return AREA_ARMENIA; }
2185
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("33")) { return AREA_CAUCASUS_REGION; }
2186
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY")) { return AREA_EGYPT; }
2187
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY-OO")) { return AREA_EGYPT; }
2188
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL")) { return AREA_ISRAEL_JORDAN; }
2189
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-IS")) { return AREA_ISRAEL; }
2190
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-JO")) { return AREA_JORDAN; }
2191
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-LB")) { return AREA_LEBANON; }
2192
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBY-OO")) { return AREA_LIBYA; }
2193
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS")) { return AREA_LEBANON_SYRIA; }
2194
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MOR")) { return AREA_MOROCCO; }
2195
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MOR-OO")) { return AREA_MOROCCO; }
2196
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NCS")) { return AREA_NORTH_CAUCASUS; }
2197
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN")) { return AREA_SINAI; }
2198
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN-OO")) { return AREA_SINAI; }
2199
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-SY")) { return AREA_SYRIA; }
2200
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN")) { return AREA_TUNISIA; }
2201
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN-OO")) { return AREA_TUNISIA; }
2202
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_ASIATIC_TURKEY; }
2203
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUR-OO")) { return AREA_ASIATIC_TURKEY; }
2204
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("20")) { return AREA_NORTHERN_AFRICA; }
2205
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AFR")) { return AREA_AFRO_TROPICAL_REGION; }
2206
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUS")) { return AREA_AUSTRALIAN_REGION; }
2207
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_EAST_PALAEARCTIC; }
2208
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEA")) { return AREA_NEARCTIC_REGION; }
2209
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEO")) { return AREA_NEOTROPICAL_REGION; }
2210
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NRE")) { return AREA_NEAR_EAST; }
2211
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ORR")) { return AREA_ORIENTAL_REGION; }
2212
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS")) { return AREA_TRANSCAUCASUS; }
2213
//			
2214
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return AREA_EUROPEAN_MARINE_WATERS; }
2215
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||
2216
//					(namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
2217
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return AREA_WHITE_SEA; }
2218
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return AREA_NORTH_SEA; }
2219
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return AREA_BALTIC_SEA; }
2220
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||
2221
//					(namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return AREA_BLACK_SEA; } // abbreviated label missing
2222
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return AREA_BARENTS_SEA; }
2223
//			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
2224
//					(namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return AREA_CASPIAN_SEA; } // abbreviated label missing
2225
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
2226
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2227
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
2228
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return AREA_ENGLISH_CHANNEL; }
2229
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return AREA_ADRIATIC_SEA; }
2230
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return AREA_BISCAY_BAY; }
2231
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
2232
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
2233
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
2234
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2235
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2236
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return AREA_TIRRENO_SEA; }
2237
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
2238
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
2239
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return AREA_IRISH_SEA; }
2240
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2241
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return AREA_NORWEGIAN_SEA; }
2242
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
2243
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2244
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return AREA_SKAGERRAK; }
2245
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2246
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return AREA_WADDEN_SEA; }
2247
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return AREA_BELT_SEA; }
2248
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return AREA_MARMARA_SEA; }
2249
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return AREA_SEA_OF_AZOV; }
2250
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return AREA_AEGEAN_SEA; }
2251
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2252
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return AREA_SOUTH_BALTIC_PROPER; }
2253
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return AREA_BALTIC_PROPER; }
2254
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return AREA_NORTH_BALTIC_PROPER; }
2255
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return AREA_ARCHIPELAGO_SEA; }
2256
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return AREA_BOTHNIAN_SEA; }
2257
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
2258
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
2259
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2260
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
2261
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
2262
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
2263
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2264
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
2265
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return AREA_BALEAR_SEA; }
2266
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
2267
//			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
2268
//			else {
2269
//				logger.warn("Unknown TDWGArea: " + area.getTitleCache());
2270
//			}
2271
//		}else if (namedArea.isInstanceOf(WaterbodyOrCountry.class)){
2272
//			if (namedArea.equals(WaterbodyOrCountry.UKRAINE())) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
2273
//			else if (namedArea.equals(WaterbodyOrCountry.AZERBAIJANREPUBLICOF())) { return AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
2274
//			else if (namedArea.equals(WaterbodyOrCountry.GEORGIA())) { return AREA_GEORGIA; }
2275
//			else {
2276
//				logger.warn("Unknown Waterbody/Country: " + area.getTitleCache());
2277
//			}
2278
//		}else{  //Non TDWG
2279
//			if ( namedArea.getUuid().equals(BerlinModelTransformer.uuidMadeira)){ return AREA_MADEIRA; }
2280
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidDesertas)) { return AREA_DESERTAS; }
2281
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPortoSanto)) { return AREA_PORTO_SANTO; }
2282
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaBaltic)) { return AREA_RUSSIA_BALTIC; }
2283
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthEast)) { return AREA_RUSSIA_SOUTHEAST; }
2284
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthWest)) { return AREA_RUSSIA_SOUTHWEST; }
2285
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUssr)) { return AREA_FORMER_USSR; }
2286
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaCentral)) { return AREA_RUSSIA_CENTRAL; }
2287
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaNorthern)) { return AREA_RUSSIA_NORTHERN; }
2288
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkey)) { return AREA_TURKEY; }
2289
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEastAegeanIslands)) { return AREA_EAST_AEGEAN_ISLANDS; }
2290
//			
2291
//			else {
2292
//				logger.warn("Unknown NamedArea Area: " + area.getTitleCache());
2293
//			}
2294
//
2295
//		}
2296
//		return null;
2297
//
2298
//	}
2299

    
2300
	/**
2301
	 * Returns the PESI SourceUseId for a given CDM sourceUseId.
2302
	 * @param sourceUseId
2303
	 * @return
2304
	 */
2305
	public static Integer sourceUseIdSourceUseId(Integer sourceUseId) {
2306
		// TODO: CDM sourceUseId and PESI sourceUseId are equal for now.
2307
		Integer result = null;
2308
		switch (sourceUseId) {
2309
			case 3: return ADDITIONAL_SOURCE;
2310
			case 4: return SOURCE_OF_SYNONYMY;
2311
			case 8: return NOMENCLATURAL_REFERENCE;
2312
		}
2313
		return result;
2314
	}
2315
	
2316
	/**
2317
	 * Returns the SourceUseCache for a tiven sourceUseId.
2318
	 * @param sourceUseId
2319
	 * @return
2320
	 */
2321
	public static String sourceUseId2SourceUseCache(Integer sourceUseId) {
2322
		// TODO: CDM sourceUseId and PESI sourceUseId are equal for now.
2323
		String result = null;
2324
		switch (sourceUseId) {
2325
			case 3: return STR_ADDITIONAL_SOURCE;
2326
			case 4: return STR_SOURCE_OF_SYNONYMY;
2327
			case 8: return STR_NOMENCLATURAL_REFERENCE;
2328
		}
2329
		return result;
2330
	}
2331
	
2332
	/**
2333
	 * Returns the FossilStatusCache to a given Fossil.
2334
	 * @param fossil
2335
	 * @return
2336
	 */
2337
	public static String fossil2FossilStatusCache(Fossil fossil) {
2338
		String result = null;
2339
		return result;
2340
	}
2341

    
2342
	/**
2343
	 * Returns the FossilStatusId to a given Fossil.
2344
	 * @param fossil
2345
	 * @return
2346
	 */
2347
	public static Integer fossil2FossilStatusId(Fossil fossil) {
2348
		Integer result = null;
2349
		return result;
2350
	}
2351
	
2352
	
2353
	
2354
	@Override
2355
	public Object getKeyByLanguage(Language language) throws UndefinedTransformerMethodException {
2356
		return language2LanguageId(language);
2357
	}
2358

    
2359
	@Override
2360
	public String getCacheByLanguage(Language language) throws UndefinedTransformerMethodException {
2361
		return language2LanguageCache(language);
2362
	}
2363

    
2364
	/**
2365
	 * Returns the LanguageCache to a given Language.
2366
	 * @param language
2367
	 * @return
2368
	 */
2369
	public static String language2LanguageCache(Language language) {
2370
		if (language == null ) {
2371
			return null;
2372
		}
2373
		if (language.equals(Language.ALBANIAN())) {
2374
			return STR_LANGUAGE_ALBANIAN;
2375
		} else if (language.equals(Language.ARABIC())) {
2376
			return STR_LANGUAGE_ARABIC;
2377
		} else if (language.equals(Language.ARMENIAN())) {
2378
			return STR_LANGUAGE_ARMENIAN;
2379
		} else if (language.equals(Language.AZERBAIJANI())) {
2380
			return STR_LANGUAGE_AZERBAIJAN;
2381
		} else if (language.equals(Language.BELORUSSIAN())) {
2382
			return STR_LANGUAGE_BELARUSIAN;
2383
		} else if (language.equals(Language.BULGARIAN())) {
2384
			return STR_LANGUAGE_BULGARIAN;
2385
		} else if (language.equals(Language.CATALAN_VALENCIAN())) {
2386
			return STR_LANGUAGE_CATALAN;
2387
		} else if (language.equals(Language.CROATIAN())) {
2388
			return STR_LANGUAGE_CROAT;
2389
		} else if (language.equals(Language.CZECH())) {
2390
			return STR_LANGUAGE_CZECH;
2391
		} else if (language.equals(Language.DANISH())) {
2392
			return STR_LANGUAGE_DANISH;
2393
		} else if (language.equals(Language.DUTCH_MIDDLE())) {
2394
			return STR_LANGUAGE_DUTCH;
2395
		} else if (language.equals(Language.ENGLISH())) {
2396
			return STR_LANGUAGE_ENGLISH;
2397
//		} else if (language.equals(Language.)) {
2398
//			return STR_LANGUAGE_EUSKERA;
2399
		} else if (language.equals(Language.ESTONIAN())) {
2400
			return STR_LANGUAGE_ESTONIAN;
2401
		} else if (language.equals(Language.FINNISH())) {
2402
			return STR_LANGUAGE_FINNISH;
2403
		} else if (language.equals(Language.FRENCH())) {
2404
			return STR_LANGUAGE_FRENCH;
2405
		} else if (language.equals(Language.GEORGIAN())) {
2406
			return STR_LANGUAGE_GEORGIAN;
2407
		} else if (language.equals(Language.GERMAN())) {
2408
			return STR_LANGUAGE_GERMAN;
2409
		} else if (language.equals(Language.GREEK_MODERN())) {
2410
			return STR_LANGUAGE_GREEK;
2411
		} else if (language.equals(Language.HUNGARIAN())) {
2412
			return STR_LANGUAGE_HUNGARIAN;
2413
		} else if (language.equals(Language.ICELANDIC())) {
2414
			return STR_LANGUAGE_ICELANDIC;
2415
		} else if (language.equals(Language.IRISH())) {
2416
			return STR_LANGUAGE_IRISH_GAELIC;
2417
		} else if (language.equals(Language.HEBREW())) {
2418
			return STR_LANGUAGE_ISRAEL_HEBREW;
2419
		} else if (language.equals(Language.ITALIAN())) {
2420
			return STR_LANGUAGE_ITALIAN;
2421
		} else if (language.equals(Language.LATVIAN())) {
2422
			return STR_LANGUAGE_LATVIAN;
2423
		} else if (language.equals(Language.LITHUANIAN())) {
2424
			return STR_LANGUAGE_LITHUANIAN;
2425
		} else if (language.equals(Language.MACEDONIAN())) {
2426
			return STR_LANGUAGE_MACEDONIAN;
2427
		} else if (language.equals(Language.MALTESE())) {
2428
			return STR_LANGUAGE_MALTESE;
2429
		} else if (language.equals(Language.MOLDAVIAN())) {
2430
			return STR_LANGUAGE_MOLDOVIAN;
2431
		} else if (language.equals(Language.NORWEGIAN())) {
2432
			return STR_LANGUAGE_NORWEGIAN;
2433
		} else if (language.equals(Language.POLISH())) {
2434
			return STR_LANGUAGE_POLISH;
2435
		} else if (language.equals(Language.PORTUGUESE())) {
2436
			return STR_LANGUAGE_PORTUGUESE;
2437
		} else if (language.equals(Language.ROMANIAN())) {
2438
			return STR_LANGUAGE_ROUMANIAN;
2439
		} else if (language.equals(Language.RUSSIAN())) {
2440
			return STR_LANGUAGE_RUSSIAN;
2441
//		} else if (language.equals(Language.)) {
2442
//			return STR_LANGUAGE_RUSSIAN_CAUCASIAN;
2443
//		} else if (language.equals(Language.)) {
2444
//			return STR_LANGUAGE_RUSSIAN_ALTAIC_KALMYK_OIRAT;
2445
//		} else if (language.equals(Language.)) {
2446
//			return STR_LANGUAGE_RUSSIAN_ALTAIC_KARACHAY_BALKAR;
2447
//		} else if (language.equals(Language.)) {
2448
//			return STR_LANGUAGE_RUSSIAN_ALTAIC_KUMYK;
2449
//		} else if (language.equals(Language.)) {
2450
//			return STR_LANGUAGE_RUSSIAN_ALTAIC_NOGAI;
2451
//		} else if (language.equals(Language.)) {
2452
//			return STR_LANGUAGE_RUSSIAN_ALTAIC_NORTH_AZERBAIJANI;
2453
//		} else if (language.equals(Language.)) {
2454
//			return STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_RUSSIAN;
2455
//		} else if (language.equals(Language.)) {
2456
//			return STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_KALMYK_OIRAT;
2457
//		} else if (language.equals(Language.)) {
2458
//			return STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_OSETIN;
2459
//		} else if (language.equals(Language.)) {
2460
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_ABAZA;
2461
//		} else if (language.equals(Language.)) {
2462
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_ADYGHE;
2463
//		} else if (language.equals(Language.)) {
2464
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_CHECHEN;
2465
//		} else if (language.equals(Language.)) {
2466
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_KABARDIAN;
2467
//		} else if (language.equals(Language.)) {
2468
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_LAK;
2469
//		} else if (language.equals(Language.)) {
2470
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_AVAR;
2471
//		} else if (language.equals(Language.)) {
2472
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_IN;
2473
//		} else if (language.equals(Language.)) {
2474
//			return STR_LANGUAGE_RUSSIAN_URALIC_CHUVASH;
2475
//		} else if (language.equals(Language.)) {
2476
//			return STR_LANGUAGE_RUSSIAN_URALIC_UDMURT;
2477
		} else if (language.equals(Language.SERBIAN())) {
2478
			return STR_LANGUAGE_SERBIAN;
2479
		} else if (language.equals(Language.SLOVAK())) {
2480
			return STR_LANGUAGE_SLOVAK;
2481
		} else if (language.equals(Language.SLOVENIAN())) {
2482
			return STR_LANGUAGE_SLOVENE;
2483
		} else if (language.equals(Language.SPANISH_CATALAN())) {
2484
			return STR_LANGUAGE_SPANISH_CASTILLIAN;
2485
		} else if (language.equals(Language.SWEDISH())) {
2486
			return STR_LANGUAGE_SWEDISH;
2487
		} else if (language.equals(Language.TURKISH())) {
2488
			return STR_LANGUAGE_TURKISH;
2489
		} else if (language.equals(Language.UKRAINIAN())) {
2490
			return STR_LANGUAGE_UKRAINE;
2491
		} else if (language.equals(Language.WELSH())) {
2492
			return STR_LANGUAGE_WELSH;
2493
		} else if (language.equals(Language.CORSICAN())) {
2494
			return STR_LANGUAGE_CORSICAN;
2495
		} else {
2496
			logger.debug("Unknown Language: " + language.getTitleCache());
2497
			return null;
2498
		}
2499
	}
2500
	
2501
	/**
2502
	 * Returns the identifier of the given Language.
2503
	 * @param language
2504
	 * @return
2505
	 */
2506
	public static Integer language2LanguageId(Language language) {
2507
		if (language == null ) {
2508
			return null;
2509
		}
2510
		if (language.equals(Language.ALBANIAN())) {
2511
			return Language_Albanian;
2512
		} else if (language.equals(Language.ARABIC())) {
2513
			return Language_Arabic;
2514
		} else if (language.equals(Language.ARMENIAN())) {
2515
			return Language_Armenian;
2516
		} else if (language.equals(Language.AZERBAIJANI())) {
2517
			return Language_Azerbaijan;
2518
		} else if (language.equals(Language.BELORUSSIAN())) {
2519
			return Language_Belarusian;
2520
		} else if (language.equals(Language.BULGARIAN())) {
2521
			return Language_Bulgarian;
2522
		} else if (language.equals(Language.CATALAN_VALENCIAN())) {
2523
			return Language_Catalan;
2524
		} else if (language.equals(Language.CROATIAN())) {
2525
			return Language_Croat;
2526
		} else if (language.equals(Language.CZECH())) {
2527
			return Language_Czech;
2528
		} else if (language.equals(Language.DANISH())) {
2529
			return Language_Danish;
2530
		} else if (language.equals(Language.DUTCH_MIDDLE())) {
2531
			return Language_Dutch;
2532
		} else if (language.equals(Language.ENGLISH())) {
2533
			return Language_English;
2534
//		} else if (language.equals(Language.)) {
2535
//			return Language_Euskera;
2536
		} else if (language.equals(Language.ESTONIAN())) {
2537
			return Language_Estonian;
2538
		} else if (language.equals(Language.FINNISH())) {
2539
			return Language_Finnish;
2540
		} else if (language.equals(Language.FRENCH())) {
2541
			return Language_French;
2542
		} else if (language.equals(Language.GEORGIAN())) {
2543
			return Language_Georgian;
2544
		} else if (language.equals(Language.GERMAN())) {
2545
			return Language_German;
2546
		} else if (language.equals(Language.GREEK_MODERN())) {
2547
			return Language_Greek;
2548
		} else if (language.equals(Language.HUNGARIAN())) {
2549
			return Language_Hungarian;
2550
		} else if (language.equals(Language.ICELANDIC())) {
2551
			return Language_Icelandic;
2552
		} else if (language.equals(Language.IRISH())) {
2553
			return Language_Irish_Gaelic;
2554
		} else if (language.equals(Language.HEBREW())) {
2555
			return Language_Israel_Hebrew;
2556
		} else if (language.equals(Language.ITALIAN())) {
2557
			return Language_Italian;
2558
		} else if (language.equals(Language.LATVIAN())) {
2559
			return Language_Latvian;
2560
		} else if (language.equals(Language.LITHUANIAN())) {
2561
			return Language_Lithuanian;
2562
		} else if (language.equals(Language.MACEDONIAN())) {
2563
			return Language_Macedonian;
2564
		} else if (language.equals(Language.MALTESE())) {
2565
			return Language_Maltese;
2566
		} else if (language.equals(Language.MOLDAVIAN())) {
2567
			return Language_Moldovian;
2568
		} else if (language.equals(Language.NORWEGIAN())) {
2569
			return Language_Norwegian;
2570
		} else if (language.equals(Language.POLISH())) {
2571
			return Language_Polish;
2572
		} else if (language.equals(Language.PORTUGUESE())) {
2573
			return Language_Portuguese;
2574
		} else if (language.equals(Language.ROMANIAN())) {
2575
			return Language_Roumanian;
2576
		} else if (language.equals(Language.RUSSIAN())) {
2577
			return Language_Russian;
2578
//		} else if (language.equals(Language.)) {
2579
//			return Language_Russian_Caucasian;
2580
//		} else if (language.equals(Language.)) {
2581
//			return Language_Russian_Altaic_kalmyk_oirat;
2582
//		} else if (language.equals(Language.)) {
2583
//			return Language_Russian_Altaic_karachay_balkar;
2584
//		} else if (language.equals(Language.)) {
2585
//			return Language_Russian_Altaic_kumyk;
2586
//		} else if (language.equals(Language.)) {
2587
//			return Language_Russian_Altaic_nogai;
2588
//		} else if (language.equals(Language.)) {
2589
//			return Language_Russian_Altaic_north_azerbaijani;
2590
//		} else if (language.equals(Language.)) {
2591
//			return Language_Russian_Indo_european_russian;
2592
//		} else if (language.equals(Language.)) {
2593
//			return Language_Russian_Indo_european_kalmyk_oirat;
2594
//		} else if (language.equals(Language.)) {
2595
//			return Language_Russian_Indo_european_osetin;
2596
//		} else if (language.equals(Language.)) {
2597
//			return Language_Russian_North_caucasian_abaza;
2598
//		} else if (language.equals(Language.)) {
2599
//			return Language_Russian_North_caucasian_adyghe;
2600
//		} else if (language.equals(Language.)) {
2601
//			return Language_Russian_North_caucasian_chechen;
2602
//		} else if (language.equals(Language.)) {
2603
//			return Language_Russian_North_caucasian_kabardian;
2604
//		} else if (language.equals(Language.)) {
2605
//			return Language_Russian_North_caucasian_lak;
2606
//		} else if (language.equals(Language.)) {
2607
//			return Language_Russian_North_caucasian_avar;
2608
//		} else if (language.equals(Language.)) {
2609
//			return Language_Russian_North_caucasian_in;
2610
//		} else if (language.equals(Language.)) {
2611
//			return Language_Russian_Uralic_chuvash;
2612
//		} else if (language.equals(Language.)) {
2613
//			return Language_Russian_Uralic_udmurt;
2614
		} else if (language.equals(Language.SERBIAN())) {
2615
			return Language_Serbian;
2616
		} else if (language.equals(Language.SLOVAK())) {
2617
			return Language_Slovak;
2618
		} else if (language.equals(Language.SLOVENIAN())) {
2619
			return Language_Slovene;
2620
		} else if (language.equals(Language.SPANISH_CATALAN())) {
2621
			return Language_Spanish_Castillian;
2622
		} else if (language.equals(Language.SWEDISH())) {
2623
			return Language_Swedish;
2624
		} else if (language.equals(Language.TURKISH())) {
2625
			return Language_Turkish;
2626
		} else if (language.equals(Language.UKRAINIAN())) {
2627
			return Language_Ukraine;
2628
		} else if (language.equals(Language.WELSH())) {
2629
			return Language_Welsh;
2630
		} else if (language.equals(Language.CORSICAN())) {
2631
			return Language_Corsican;
2632
		} else {
2633
			logger.debug("Unknown Language: " + language.getTitleCache());
2634
			return null;
2635
		}
2636
	}
2637
	
2638
	/**
2639
	 * Returns the NodeCategoryCache for a given TextData.
2640
	 * @param feature
2641
	 * @return
2642
	 */
2643
	public static String textData2NodeCategoryCache(Feature feature) {
2644
		if (feature == null) {
2645
			return null;
2646
		}
2647
		
2648
		if (feature.equals(Feature.DESCRIPTION())) {
2649
			return NoteCategory_STR_description;
2650
		} else if (feature.equals(Feature.ECOLOGY())) {
2651
			return NoteCategory_STR_ecology;
2652
		} else if (feature.equals(Feature.PHENOLOGY())) {
2653
			return NoteCategory_STR_phenology;
2654
		} else if (feature.equals(Feature.COMMON_NAME())) {
2655
			return NoteCategory_STR_Common_names;
2656
		} else if (feature.equals(Feature.OCCURRENCE())) {
2657
			return NoteCategory_STR_Occurrence;
2658
		} else if (feature.getUuid().equals(ErmsTransformer.uuidRemark)) {
2659
			return NoteCategory_STR_Remark;
2660
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAdditionalinformation)) {
2661
			return NoteCategory_STR_Additional_information;
2662
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSpelling)) {
2663
			return NoteCategory_STR_Spelling;
2664
		} else if (feature.getUuid().equals(ErmsTransformer.uuidDateofPublication)) {
2665
			return NoteCategory_STR_Date_of_publication;
2666
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSystematics)) {
2667
			return NoteCategory_STR_Systematics;
2668
		} else if (feature.getUuid().equals(ErmsTransformer.uuidClassification)) {
2669
			return NoteCategory_STR_Classification;
2670
		} else if (feature.getUuid().equals(ErmsTransformer.uuidEnvironment)) {
2671
			return NoteCategory_STR_Environment;
2672
		} else if (feature.getUuid().equals(ErmsTransformer.uuidHabitat)) {
2673
			return NoteCategory_STR_Habitat;
2674
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAuthority)) {
2675
			return NoteCategory_STR_Authority;
2676
		} else if (feature.getUuid().equals(ErmsTransformer.uuidMorphology)) {
2677
			return NoteCategory_STR_Morphology;
2678
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemarks)) {
2679
			return NoteCategory_STR_Taxonomic_Remarks;
2680
		} else if (feature.getUuid().equals(ErmsTransformer.uuidNote)){
2681
			return NoteCategory_STR_Note;
2682
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomy)) {
2683
			return NoteCategory_STR_Taxonomy;
2684
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicstatus)) {
2685
			return NoteCategory_STR_Taxonomic_status;
2686
		} else if (feature.getUuid().equals(ErmsTransformer.uuidStatus)){
2687
			return NoteCategory_STR_Status;
2688
		} else if (feature.getUuid().equals(ErmsTransformer.uuidRank)) {
2689
			return NoteCategory_STR_Rank;
2690
		} else if (feature.getUuid().equals(ErmsTransformer.uuidHomonymy)) {
2691
			return NoteCategory_STR_Homonymy;
2692
		} else if (feature.getUuid().equals(ErmsTransformer.uuidNomenclature)) {
2693
			return NoteCategory_STR_Nomenclature;
2694
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemark)) {
2695
			return NoteCategory_STR_Taxonomic_Remark;
2696
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAcknowledgments)){
2697
			return NoteCategory_STR_Acknowledgments;
2698
		} else if (feature.getUuid().equals(ErmsTransformer.uuidOriginalpublication)) {
2699
			return NoteCategory_STR_Original_publication;
2700
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTypelocality)) {
2701
			return NoteCategory_STR_Type_locality;
2702
		} else if (feature.getUuid().equals(ErmsTransformer.uuidValidity)) {
2703
			return NoteCategory_STR_Validity;
2704
		} else if (feature.getUuid().equals(ErmsTransformer.uuidIdentification)) {
2705
			return NoteCategory_STR_Identification;
2706
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSynonymy)) {
2707
			return NoteCategory_STR_Synonymy;
2708
//		} else if (feature.equals(Feature.CITATION())) {
2709
//			return;
2710
			
2711
			// TODO: Unknown NodeCategories
2712
//			NoteCategory_STR_general_distribution_euromed = 10;
2713
//			NoteCategory_STR_general_distribution_world = 11;
2714
//			NoteCategory_STR_Common_names = 12;
2715
//			NoteCategory_STR_Maps =14;
2716
//			NoteCategory_STR_Link_to_maps = 20;
2717
//			NoteCategory_STR_Link_to_images = 21;
2718
//			NoteCategory_STR_Link_to_taxonomy = 22;
2719
//			NoteCategory_STR_Link_to_general_information = 23;
2720
//			NoteCategory_STR_undefined_link = 24;
2721
//			NoteCategory_STR_Editor_Braces = 249;
2722
//			NoteCategory_STR_Editor_Brackets = 250;
2723
//			NoteCategory_STR_Editor_Parenthesis = 251;
2724
//			NoteCategory_STR_Inedited = 252;
2725
//			NoteCategory_STR_Comments_on_editing_process = 253;
2726
//			NoteCategory_STR_Publication_date = 254;
2727
//			NoteCategory_STR_Distribution = 278;
2728
//			NoteCategory_STR_Biology = 281;
2729
//			NoteCategory_STR_Diagnosis	= 282;
2730
//			NoteCategory_STR_Host = 283;
2731
		
2732
 		} else {
2733
			logger.debug("Unknown Feature.");
2734
			return null;
2735
		}
2736
	}
2737

    
2738
	/**
2739
	 * Returns the NodeCategoryFk for a given TextData.
2740
	 * @param feature
2741
	 * @return
2742
	 */
2743
	public static Integer feature2NodeCategoryFk(Feature feature) {
2744
		if (feature == null) {
2745
			return null;
2746
		}
2747

    
2748
		if (feature.equals(Feature.DESCRIPTION())) {
2749
			return NoteCategory_description;
2750
		} else if (feature.equals(Feature.ECOLOGY())) {
2751
			return NoteCategory_ecology;
2752
		} else if (feature.equals(Feature.PHENOLOGY())) {
2753
			return NoteCategory_phenology;
2754
		} else if (feature.equals(Feature.COMMON_NAME())) {
2755
			return NoteCategory_Common_names;
2756
		} else if (feature.equals(Feature.OCCURRENCE())) {
2757
			return NoteCategory_Occurrence;
2758
		} else if (feature.equals(Feature.DISTRIBUTION())) {
2759
			return NoteCategory_Distribution;
2760
		} else if (feature.getUuid().equals(ErmsTransformer.uuidRemark)) {
2761
			return NoteCategory_Remark;
2762
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAdditionalinformation)) {
2763
			return NoteCategory_Additional_information;
2764
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSpelling)) {
2765
			return NoteCategory_Spelling;
2766
		} else if (feature.getUuid().equals(ErmsTransformer.uuidDateofPublication)) {
2767
			return NoteCategory_Date_of_publication;
2768
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSystematics)) {
2769
			return NoteCategory_Systematics;
2770
		} else if (feature.getUuid().equals(ErmsTransformer.uuidClassification)) {
2771
			return NoteCategory_Classification;
2772
		} else if (feature.getUuid().equals(ErmsTransformer.uuidEnvironment)) {
2773
			return NoteCategory_Environment;
2774
		} else if (feature.getUuid().equals(ErmsTransformer.uuidHabitat)) {
2775
			return NoteCategory_Habitat;
2776
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAuthority)) {
2777
			return NoteCategory_Authority;
2778
		} else if (feature.getUuid().equals(ErmsTransformer.uuidMorphology)) {
2779
			return NoteCategory_Morphology;
2780
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemarks)) {
2781
			return NoteCategory_Taxonomic_Remarks;
2782
		} else if (feature.getUuid().equals(ErmsTransformer.uuidNote)){
2783
			return NoteCategory_Note;
2784
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomy)) {
2785
			return NoteCategory_Taxonomy;
2786
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicstatus)) {
2787
			return NoteCategory_Taxonomic_status;
2788
		} else if (feature.getUuid().equals(ErmsTransformer.uuidStatus)){
2789
			return NoteCategory_Status;
2790
		} else if (feature.getUuid().equals(ErmsTransformer.uuidRank)) {
2791
			return NoteCategory_Rank;
2792
		} else if (feature.getUuid().equals(ErmsTransformer.uuidHomonymy)) {
2793
			return NoteCategory_Homonymy;
2794
		} else if (feature.getUuid().equals(ErmsTransformer.uuidNomenclature)) {
2795
			return NoteCategory_Nomenclature;
2796
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemark)) {
2797
			return NoteCategory_Taxonomic_Remark;
2798
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAcknowledgments)){
2799
			return NoteCategory_Acknowledgments;
2800
		} else if (feature.getUuid().equals(ErmsTransformer.uuidOriginalpublication)) {
2801
			return NoteCategory_Original_publication;
2802
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTypelocality)) {
2803
			return NoteCategory_Type_locality;
2804
		} else if (feature.getUuid().equals(ErmsTransformer.uuidValidity)) {
2805
			return NoteCategory_Validity;
2806
		} else if (feature.getUuid().equals(ErmsTransformer.uuidIdentification)) {
2807
			return NoteCategory_Identification;
2808
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSynonymy)) {
2809
			return NoteCategory_Synonymy;
2810
		} else if (feature.equals(Feature.CITATION())) {
2811
			return null;  //citations are handled differently
2812
			
2813
			// TODO: Unknown NodeCategories
2814
//			NoteCategory_general_distribution_euromed = 10;
2815
//			NoteCategory_general_distribution_world = 11;
2816
//			NoteCategory_Common_names = 12;
2817
//			NoteCategory_Maps =14;
2818
//			NoteCategory_Link_to_maps = 20;
2819
//			NoteCategory_Link_to_images = 21;
2820
//			NoteCategory_Link_to_taxonomy = 22;
2821
//			NoteCategory_Link_to_general_information = 23;
2822
//			NoteCategory_undefined_link = 24;
2823
//			NoteCategory_Editor_Braces = 249;
2824
//			NoteCategory_Editor_Brackets = 250;
2825
//			NoteCategory_Editor_Parenthesis = 251;
2826
//			NoteCategory_Inedited = 252;
2827
//			NoteCategory_Comments_on_editing_process = 253;
2828
//			NoteCategory_Publication_date = 254;
2829
//			NoteCategory_Distribution = 278;
2830
//			NoteCategory_Biology = 281;
2831
//			NoteCategory_Diagnosis	= 282;
2832
//			NoteCategory_Host = 283;
2833

    
2834
		}else{
2835
			logger.warn("Unhandled Feature: " + feature.getTitleCache());
2836
			return null;
2837
		}
2838
	}
2839

    
2840
	/**
2841
	 * Returns the string representation for a given rank.
2842
	 * @param rank
2843
	 * @param pesiKingdomId
2844
	 * @return
2845
	 */
2846
	public static String rank2RankCache(Rank rank, Integer pesiKingdomId) {
2847
		String result = null;
2848
		if (rank == null) {
2849
			return null;
2850
		}
2851
		
2852
		// We differentiate between Animalia and Plantae only for now.
2853
		if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_ANIMALIA) {
2854
			if (rank.equals(Rank.KINGDOM())) {
2855
				result = Animalia_STR_Kingdom;
2856
			} else if (rank.equals(Rank.SUBKINGDOM())) {
2857
				result = Animalia_STR_Subkingdom;
2858
			} else if (rank.equals(Rank.SUPERPHYLUM())) {
2859
				result = Animalia_STR_Superphylum;
2860
			} else if (rank.equals(Rank.PHYLUM())) {
2861
				result = Animalia_STR_Phylum;
2862
			} else if (rank.equals(Rank.SUBPHYLUM())) {
2863
				result = Animalia_STR_Subphylum;
2864
			} else if (rank.equals(Rank.INFRAPHYLUM())) {
2865
				result = Animalia_STR_Infraphylum;
2866
			} else if (rank.equals(Rank.SUPERCLASS())) {
2867
				result = Animalia_STR_Superclass;
2868
			} else if (rank.equals(Rank.CLASS())) {
2869
				result = Animalia_STR_Class;
2870
			} else if (rank.equals(Rank.SUBCLASS())) {
2871
				result = Animalia_STR_Subclass;
2872
			} else if (rank.equals(Rank.INFRACLASS())) {
2873
				result = Animalia_STR_Infraclass;
2874
			} else if (rank.equals(Rank.SUPERORDER())) {
2875
				result = Animalia_STR_Superorder;
2876
			} else if (rank.equals(Rank.ORDER())) {
2877
				result = Animalia_STR_Order;
2878
			} else if (rank.equals(Rank.SUBORDER())) {
2879
				result = Animalia_STR_Suborder;
2880
			} else if (rank.equals(Rank.INFRAORDER())) {
2881
				result = Animalia_STR_Infraorder;
2882
			} else if (rank.equals(Rank.SECTION_ZOOLOGY())) {
2883
				result = Animalia_STR_Section;
2884
			} else if (rank.equals(Rank.SUBSECTION_ZOOLOGY())) {
2885
				result = Animalia_STR_Subsection;
2886
			} else if (rank.equals(Rank.SUPERFAMILY())) {
2887
				result = Animalia_STR_Superfamily;
2888
			} else if (rank.equals(Rank.FAMILY())) {
2889
				result = Animalia_STR_Family;
2890
			} else if (rank.equals(Rank.SUBFAMILY())) {
2891
				result = Animalia_STR_Subfamily;
2892
			} else if (rank.equals(Rank.TRIBE())) {
2893
				result = Animalia_STR_Tribe;
2894
			} else if (rank.equals(Rank.SUBTRIBE())) {
2895
				result = Animalia_STR_Subtribe;
2896
			} else if (rank.equals(Rank.GENUS())) {
2897
				result = Animalia_STR_Genus;
2898
			} else if (rank.equals(Rank.SUBGENUS())) {
2899
				result = Animalia_STR_Subgenus;
2900
			} else if (rank.equals(Rank.SPECIES())) {
2901
				result = Animalia_STR_Species;
2902
			} else if (rank.equals(Rank.SUBSPECIES())) {
2903
				result = Animalia_STR_Subspecies;
2904
//			} else if (rank.equals(Rank.)) { // not yet specified
2905
//				result = Animalia_STR_Natio;
2906
			} else if (rank.equals(Rank.VARIETY())) {
2907
				result = Animalia_STR_Variety;
2908
			} else if (rank.equals(Rank.SUBVARIETY())) {
2909
				result = Animalia_STR_Subvariety;
2910
			} else if (rank.equals(Rank.FORM())) {
2911
				result = Animalia_STR_Forma;
2912
			} else {
2913
				//TODO Exception
2914
				logger.warn("Rank for Kingdom Animalia not yet supported in CDM: "+ rank.getLabel());
2915
				return null;
2916
			}
2917
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_PLANTAE) {
2918
			if (rank.equals(Rank.KINGDOM())) {
2919
				result = Plantae_STR_Kingdom;
2920
			} else if (rank.equals(Rank.SUBKINGDOM())) {
2921
				result = Plantae_STR_Subkingdom;
2922
			} else if (rank.equals(Rank.DIVISION())) {
2923
				result = Plantae_STR_Division;
2924
			} else if (rank.equals(Rank.SUBDIVISION())) {
2925
				result = Plantae_STR_Subdivision;
2926
			} else if (rank.equals(Rank.CLASS())) {
2927
				result = Plantae_STR_Class;
2928
			} else if (rank.equals(Rank.SUBCLASS())) {
2929
				result = Plantae_STR_Subclass;
2930
			} else if (rank.equals(Rank.ORDER())) {
2931
				result = Plantae_STR_Order;
2932
			} else if (rank.equals(Rank.SUBORDER())) {
2933
				result = Plantae_STR_Suborder;
2934
			} else if (rank.equals(Rank.FAMILY())) {
2935
				result = Plantae_STR_Family;
2936
			} else if (rank.equals(Rank.SUBFAMILY())) {
2937
				result = Plantae_STR_Subfamily;
2938
			} else if (rank.equals(Rank.TRIBE())) {
2939
				result = Plantae_STR_Tribe;
2940
			} else if (rank.equals(Rank.SUBTRIBE())) {
2941
				result = Plantae_STR_Subtribe;
2942
			} else if (rank.equals(Rank.GENUS())) {
2943
				result = Plantae_STR_Genus;
2944
			} else if (rank.equals(Rank.SUBGENUS())) {
2945
				result = Plantae_STR_Subgenus;
2946
			} else if (rank.equals(Rank.SECTION_BOTANY())) {
2947
				result = Plantae_STR_Section;
2948
			} else if (rank.equals(Rank.SUBSECTION_BOTANY())) {
2949
				result = Plantae_STR_Subsection;
2950
			} else if (rank.equals(Rank.SERIES())) {
2951
				result = Plantae_STR_Series;
2952
			} else if (rank.equals(Rank.SUBSERIES())) {
2953
				result = Plantae_STR_Subseries;
2954
			} else if (rank.equals(Rank.SPECIESAGGREGATE() )) {
2955
				result = Plantae_STR_Aggregate;
2956
			} else if (rank.equals(Rank.SPECIESGROUP())) {
2957
				logger.warn("Rank Species Group not yet implemented");
2958
				result = null;
2959
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankCollSpecies)) { 
2960
				result = Plantae_STR_Coll_Species;
2961
			} else if (rank.equals(Rank.SPECIES())) {
2962
				result = Plantae_STR_Species;
2963
			} else if (rank.equals(Rank.SUBSPECIES())) {
2964
				result = Plantae_STR_Subspecies;
2965
			} else if (rank.equals(Rank.GREX())) {
2966
				result = Plantae_STR_Grex;
2967
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankProles)) {
2968
				result = Plantae_STR_Proles;
2969
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankRace)) {
2970
				result = Plantae_STR_Race;
2971
			} else if (rank.equals(Rank.CONVAR())) {
2972
				result = Plantae_STR_Convarietas;
2973
			} else if (rank.equals(Rank.VARIETY())) {
2974
				result = Plantae_STR_Variety;
2975
			} else if (rank.equals(Rank.SUBVARIETY())) {
2976
				result = Plantae_STR_Subvariety;
2977
			} else if (rank.equals(Rank.FORM())) {
2978
				result = Plantae_STR_Forma;
2979
			} else if (rank.equals(Rank.SUBFORM())) {
2980
				result = Plantae_STR_Subforma;
2981
//			} else if (rank.equals(Rank.)) { // not yet specified
2982
//				result = Plantae_STR_Forma_spec;
2983
			} else if (rank.equals(Rank.INFRAGENERICTAXON())) { 
2984
				result = Plantae_STR_Taxa_infragen;
2985
			} else if (rank.equals(Rank.INFRASPECIFICTAXON())) { 
2986
				result = Plantae_STR_Taxa_infraspec;
2987
			} else {
2988
				//TODO Exception
2989
				logger.warn("Rank for Kingdom Plantae not yet supported in CDM: "+ rank.getLabel());
2990
				return null;
2991
			}
2992
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_BACTERIA) {
2993
			if (rank.equals(Rank.KINGDOM())) { result = Bacteria_STR_Kingdom; }
2994
			else if (rank.equals(Rank.SUBKINGDOM())) { result = Bacteria_STR_Subkingdom; }
2995
			else if (rank.equals(Rank.PHYLUM())) { result = Bacteria_STR_Phylum; }
2996
			else if (rank.equals(Rank.SUBPHYLUM())) { result = Bacteria_STR_Subphylum; }
2997
			else if (rank.equals(Rank.SUPERCLASS())) { result = Bacteria_STR_Superclass; }
2998
			else if (rank.equals(Rank.CLASS())) { result = Bacteria_STR_Class; }
2999
			else if (rank.equals(Rank.SUBCLASS())) { result = Bacteria_STR_Subclass; }
3000
			else if (rank.equals(Rank.INFRACLASS())) { result = Bacteria_STR_Infraclass; }
3001
			else if (rank.equals(Rank.SUPERORDER())) { result = Bacteria_STR_Superorder; }
3002
			else if (rank.equals(Rank.ORDER())) { result = Bacteria_STR_Order; }
3003
			else if (rank.equals(Rank.SUBORDER())) { result = Bacteria_STR_Suborder; }
3004
			else if (rank.equals(Rank.INFRAORDER())) { result = Bacteria_STR_Infraorder; }
3005
			else if (rank.equals(Rank.SUPERFAMILY())) { result = Bacteria_STR_Superfamily; }
3006
			else if (rank.equals(Rank.FAMILY())) { result = Bacteria_STR_Family; }
3007
			else if (rank.equals(Rank.SUBFAMILY())) { result = Bacteria_STR_Subfamily; }
3008
			else if (rank.equals(Rank.TRIBE())) { result = Bacteria_STR_Tribe; }
3009
			else if (rank.equals(Rank.SUBTRIBE())) { result = Bacteria_STR_Subtribe; }
3010
			else if (rank.equals(Rank.GENUS())) { result = Bacteria_STR_Genus; }
3011
			else if (rank.equals(Rank.SUBGENUS())) { result = Bacteria_STR_Subgenus; }
3012
			else if (rank.equals(Rank.SPECIES())) { result = Bacteria_STR_Species; }
3013
			else if (rank.equals(Rank.SUBSPECIES())) { result = Bacteria_STR_Subspecies; }
3014
			else if (rank.equals(Rank.VARIETY())) { result = Bacteria_STR_Variety; }
3015
			else if (rank.equals(Rank.FORM())) { result = Bacteria_STR_Forma; }
3016
		} else {
3017
			//TODO Exception
3018
			logger.warn("Kingdom not yet supported in CDM: "+ pesiKingdomId);
3019
			return null;
3020
		}
3021
		return result;
3022
	}
3023
	
3024
	/**
3025
	 * Returns the abbreviation for a given rank.
3026
	 * @param rank
3027
	 * @param pesiKingdomId
3028
	 * @return
3029
	 */
3030
	public static String rank2RankAbbrev(Rank rank, Integer pesiKingdomId) {
3031
		String result = null;
3032
		if (rank == null) {
3033
			return null;
3034
		}
3035
		
3036
		// We differentiate between Animalia and Plantae only for now.
3037
		if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_ANIMALIA) {
3038
			if (rank.equals(Rank.SUBGENUS())) {
3039
				result = Animalia_Abbrev_Subgenus;
3040
			} else if (rank.equals(Rank.SPECIES())) {
3041
				result = Animalia_Abbrev_Species;
3042
			} else if (rank.equals(Rank.SUBSPECIES())) {
3043
				result = Animalia_Abbrev_Subspecies;
3044
//			} else if (rank.equals(Rank.)) { // not yet specified
3045
//				result = Animalia_STR_Natio;
3046
			} else if (rank.equals(Rank.VARIETY())) {
3047
				result = Animalia_Abbrev_Variety;
3048
			} else if (rank.equals(Rank.SUBVARIETY())) {
3049
				result = Animalia_Abbrev_Subvariety;
3050
			} else if (rank.equals(Rank.FORM())) {
3051
				result = Animalia_Abbrev_Forma;
3052
			} else {
3053
				//TODO Exception
3054
				logger.warn("Abbreviation for Rank of Kingdom Animalia not supported in CDM: "+ rank.getLabel());
3055
				return null;
3056
			}
3057
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_PLANTAE) {
3058
			if (rank.equals(Rank.KINGDOM())) {
3059
				result = Plantae_Abbrev_Kingdom;
3060
			} else if (rank.equals(Rank.SUBKINGDOM())) {
3061
				result = Plantae_Abbrev_Subkingdom;
3062
			} else if (rank.equals(Rank.DIVISION())) {
3063
				result = Plantae_Abbrev_Division;
3064
			} else if (rank.equals(Rank.SUBDIVISION())) {
3065
				result = Plantae_Abbrev_Subdivision;
3066
			} else if (rank.equals(Rank.CLASS())) {
3067
				result = Plantae_Abbrev_Class;
3068
			} else if (rank.equals(Rank.SUBCLASS())) {
3069
				result = Plantae_Abbrev_Subclass;
3070
			} else if (rank.equals(Rank.ORDER())) {
3071
				result = Plantae_Abbrev_Order;
3072
			} else if (rank.equals(Rank.SUBORDER())) {
3073
				result = Plantae_Abbrev_Suborder;
3074
			} else if (rank.equals(Rank.FAMILY())) {
3075
				result = Plantae_Abbrev_Family;
3076
			} else if (rank.equals(Rank.SUBFAMILY())) {
3077
				result = Plantae_Abbrev_Subfamily;
3078
			} else if (rank.equals(Rank.TRIBE())) {
3079
				result = Plantae_Abbrev_Tribe;
3080
			} else if (rank.equals(Rank.SUBTRIBE())) {
3081
				result = Plantae_Abbrev_Subtribe;
3082
			} else if (rank.equals(Rank.GENUS())) {
3083
				result = Plantae_Abbrev_Genus;
3084
			} else if (rank.equals(Rank.SUBGENUS())) {
3085
				result = Plantae_Abbrev_Subgenus;
3086
			} else if (rank.equals(Rank.SECTION_BOTANY())) {
3087
				result = Plantae_Abbrev_Section;
3088
			} else if (rank.equals(Rank.SUBSECTION_BOTANY())) {
3089
				result = Plantae_Abbrev_Subsection;
3090
			} else if (rank.equals(Rank.SERIES())) {
3091
				result = Plantae_Abbrev_Series;
3092
			} else if (rank.equals(Rank.SUBSERIES())) {
3093
				result = Plantae_Abbrev_Subseries;
3094
			} else if (rank.equals(Rank.SPECIESAGGREGATE() )) { 
3095
				result = Plantae_Abbrev_Aggregate;
3096
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankCollSpecies)) { 
3097
				result = Plantae_Abbrev_Coll_Species;
3098
			} else if (rank.equals(Rank.SPECIES())) {
3099
				result = Plantae_Abbrev_Species;
3100
			} else if (rank.equals(Rank.GREX())) {
3101
				result = Plantae_Abbrev_Grex;
3102
			} else if (rank.equals(Rank.SUBSPECIES())) {
3103
				result = Plantae_Abbrev_Subspecies;
3104
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankProles)) {
3105
				result = Plantae_Abbrev_Proles;
3106
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankRace)) {
3107
				result = Plantae_Abbrev_Race;
3108
			} else if (rank.equals(Rank.CONVAR())) {
3109
				result = Plantae_Abbrev_Convarietas;
3110
			} else if (rank.equals(Rank.VARIETY())) {
3111
				result = Plantae_Abbrev_Variety;
3112
			} else if (rank.equals(Rank.SUBVARIETY())) {
3113
				result = Plantae_Abbrev_Subvariety;
3114
			} else if (rank.equals(Rank.FORM())) {
3115
				result = Plantae_Abbrev_Forma;
3116
			} else if (rank.equals(Rank.SUBFORM())) {
3117
				result = Plantae_Abbrev_Subforma;
3118
//			} else if (rank.equals(Rank.)) { // not yet specified
3119
//				result = Plantae_Abbrev_Forma_spec;
3120
			} else if (rank.equals(Rank.INFRAGENERICTAXON())) { 
3121
				result = Plantae_Abbrev_Taxa_infragen;
3122
			} else if (rank.equals(Rank.INFRASPECIFICTAXON())) { 
3123
				result = Plantae_Abbrev_Taxa_infraspec;
3124
			} else {
3125
				//TODO Exception
3126
				logger.warn("Abbreviation for Rank of Kingdom Plantae not supported in CDM: "+ rank.getLabel());
3127
				return null;
3128
			}
3129
		} else {
3130
			//TODO Exception
3131
			logger.warn("Kingdom not yet supported in CDM: "+ pesiKingdomId);
3132
			return null;
3133
		}
3134
		return result;
3135
	}
3136

    
3137
	/**
3138
	 * Returns the identifier of a PESI specific kingdom for a given CDM nomenclatural code.
3139
	 * @param nomenclaturalCode
3140
	 * @return KINGDOM_ANIMALIA for NomenclaturalCode.ICZN, KINGDOM_PLANTAE for NomenclaturalCode.ICBN
3141
	 */
3142
	public static Integer nomenClaturalCode2Kingdom(NomenclaturalCode nomenclaturalCode) {
3143
		Integer result = null;
3144
		// TODO: This needs to be refined. For now we differentiate between Animalia and Plantae only.
3145
		if (nomenclaturalCode.equals(NomenclaturalCode.ICZN)) {
3146
			result = KINGDOM_ANIMALIA;
3147
		} else if (nomenclaturalCode.equals(NomenclaturalCode.ICBN)) {
3148
			result = KINGDOM_PLANTAE;
3149
		} else if (nomenclaturalCode.equals(NomenclaturalCode.ICNB)) {
3150
			result = KINGDOM_BACTERIA;
3151
//		} else if (nomenclaturalCode.equals(NomenclaturalCode.)) { // Biota
3152
//			result = 
3153
		} else {
3154
			logger.error("NomenclaturalCode not yet considered: " + nomenclaturalCode.getUuid() + " (" +  nomenclaturalCode.getTitleCache() + ")");
3155
		}
3156
		return result;
3157
	}
3158
	
3159
	/**
3160
	 * Returns the RankId for a Rank.
3161
	 * @param rank
3162
	 * @return
3163
	 */
3164
	public static Integer rank2RankId (Rank rank, Integer pesiKingdomId) {
3165
		Integer result = null;
3166
		if (rank == null) {
3167
			return null;
3168
		}
3169
		
3170
		// We differentiate between Animalia and Plantae only for now.
3171
		if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_ANIMALIA) {
3172
			if (rank.equals(Rank.KINGDOM())) {
3173
				result = Animalia_Kingdom;
3174
			} else if (rank.equals(Rank.SUBKINGDOM())) {
3175
				result = Animalia_Subkingdom;
3176
			} else if (rank.equals(Rank.SUPERPHYLUM())) {
3177
				result = Animalia_Superphylum;
3178
			} else if (rank.equals(Rank.PHYLUM())) {
3179
				result = Animalia_Phylum;
3180
			} else if (rank.equals(Rank.SUBPHYLUM())) {
3181
				result = Animalia_Subphylum;
3182
			} else if (rank.equals(Rank.INFRAPHYLUM())) {
3183
				result = Animalia_Infraphylum;
3184
			} else if (rank.equals(Rank.SUPERCLASS())) {
3185
				result = Animalia_Superclass;
3186
			} else if (rank.equals(Rank.CLASS())) {
3187
				result = Animalia_Class;
3188
			} else if (rank.equals(Rank.SUBCLASS())) {
3189
				result = Animalia_Subclass;
3190
			} else if (rank.equals(Rank.INFRACLASS())) {
3191
				result = Animalia_Infraclass;
3192
			} else if (rank.equals(Rank.SUPERORDER())) {
3193
				result = Animalia_Superorder;
3194
			} else if (rank.equals(Rank.ORDER())) {
3195
				result = Animalia_Order;
3196
			} else if (rank.equals(Rank.SUBORDER())) {
3197
				result = Animalia_Suborder;
3198
			} else if (rank.equals(Rank.INFRAORDER())) {
3199
				result = Animalia_Infraorder;
3200
			} else if (rank.equals(Rank.SECTION_ZOOLOGY())) {
3201
				result = Animalia_Section;
3202
			} else if (rank.equals(Rank.SUBSECTION_ZOOLOGY())) {
3203
				result = Animalia_Subsection;
3204
			} else if (rank.equals(Rank.SUPERFAMILY())) {
3205
				result = Animalia_Superfamily;
3206
			} else if (rank.equals(Rank.FAMILY())) {
3207
				result = Animalia_Family;
3208
			} else if (rank.equals(Rank.SUBFAMILY())) {
3209
				result = Animalia_Subfamily;
3210
			} else if (rank.equals(Rank.TRIBE())) {
3211
				result = Animalia_Tribe;
3212
			} else if (rank.equals(Rank.SUBTRIBE())) {
3213
				result = Animalia_Subtribe;
3214
			} else if (rank.equals(Rank.GENUS())) {
3215
				result = Animalia_Genus;
3216
			} else if (rank.equals(Rank.SUBGENUS())) {
3217
				result = Animalia_Subgenus;
3218
			} else if (rank.equals(Rank.SPECIES())) {
3219
				result = Animalia_Species;
3220
			} else if (rank.equals(Rank.SUBSPECIES())) {
3221
				result = Animalia_Subspecies;
3222
//			} else if (rank.equals(Rank.)) { // not yet specified
3223
//				result = Animalia_Natio;
3224
			} else if (rank.equals(Rank.VARIETY())) {
3225
				result = Animalia_Variety;
3226
			} else if (rank.equals(Rank.SUBVARIETY())) {
3227
				result = Animalia_Subvariety;
3228
			} else if (rank.equals(Rank.FORM())) {
3229
				result = Animalia_Forma;
3230
			} else {
3231
				//TODO Exception
3232
				logger.warn("Rank for Kingdom Animalia not yet supported in CDM: "+ rank.getLabel());
3233
				return null;
3234
			}
3235
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_PLANTAE) {
3236
			if (rank.equals(Rank.KINGDOM())) {
3237
				result = Plantae_Kingdom;
3238
			} else if (rank.equals(Rank.SUBKINGDOM())) {
3239
				result = Plantae_Subkingdom;
3240
			} else if (rank.equals(Rank.DIVISION())) {
3241
				result = Plantae_Division;
3242
			} else if (rank.equals(Rank.SUBDIVISION())) {
3243
				result = Plantae_Subdivision;
3244
			} else if (rank.equals(Rank.CLASS())) {
3245
				result = Plantae_Class;
3246
			} else if (rank.equals(Rank.SUBCLASS())) {
3247
				result = Plantae_Subclass;
3248
			} else if (rank.equals(Rank.ORDER())) {
3249
				result = Plantae_Order;
3250
			} else if (rank.equals(Rank.SUBORDER())) {
3251
				result = Plantae_Suborder;
3252
			} else if (rank.equals(Rank.FAMILY())) {
3253
				result = Plantae_Family;
3254
			} else if (rank.equals(Rank.SUBFAMILY())) {
3255
				result = Plantae_Subfamily;
3256
			} else if (rank.equals(Rank.TRIBE())) {
3257
				result = Plantae_Tribe;
3258
			} else if (rank.equals(Rank.SUBTRIBE())) {
3259
				result = Plantae_Subtribe;
3260
			} else if (rank.equals(Rank.GENUS())) {
3261
				result = Plantae_Genus;
3262
			} else if (rank.equals(Rank.SUBGENUS())) {
3263
				result = Plantae_Subgenus;
3264
			} else if (rank.equals(Rank.SECTION_BOTANY())) {
3265
				result = Plantae_Section;
3266
			} else if (rank.equals(Rank.SUBSECTION_BOTANY())) {
3267
				result = Plantae_Subsection;
3268
			} else if (rank.equals(Rank.SERIES())) {
3269
				result = Plantae_Series;
3270
			} else if (rank.equals(Rank.SUBSERIES())) {
3271
				result = Plantae_Subseries;
3272
			} else if (rank.equals(Rank.SPECIESAGGREGATE() )) {
3273
				result = Plantae_Aggregate;
3274
			} else if (rank.equals(Rank.SPECIESGROUP())) {
3275
				logger.warn("Rank Species Group not yet implemented");
3276
				result = null;
3277
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankCollSpecies)) { 
3278
				result = Plantae_Coll_Species;
3279
			} else if (rank.equals(Rank.SPECIES())) {
3280
				result = Plantae_Species;
3281
			} else if (rank.equals(Rank.SUBSPECIES())) {
3282
				result = Plantae_Subspecies;
3283
			} else if (rank.equals(Rank.GREX())) {
3284
				result = Plantae_Grex;
3285
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankProles) ) {
3286
				result = Plantae_Proles;
3287
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankRace)) {
3288
				result = Plantae_Race;
3289
			} else if (rank.equals(Rank.CONVAR())) {
3290
				result = Plantae_Convarietas;
3291
			} else if (rank.equals(Rank.VARIETY())) {
3292
				result = Plantae_Variety;
3293
			} else if (rank.equals(Rank.SUBVARIETY())) {
3294
				result = Plantae_Subvariety;
3295
			} else if (rank.equals(Rank.FORM())) {
3296
				result = Plantae_Forma;
3297
			} else if (rank.equals(Rank.SUBFORM())) {
3298
				result = Plantae_Subforma;
3299
//			} else if (rank.equals(Rank.)) { // not yet specified
3300
//				result = Plantae_Forma_spec;
3301
			} else if (rank.equals(Rank.INFRAGENERICTAXON())) { 
3302
				result = Plantae_Taxa_infragen;
3303
			} else if (rank.equals(Rank.INFRASPECIFICTAXON())) { 
3304
				result = Plantae_Taxa_infraspec;
3305
			} else {
3306
				//TODO Exception
3307
				logger.warn("Rank for Kingdom Plantae not yet supported in CDM: "+ rank.getLabel());
3308
				return null;
3309
			}
3310
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_BACTERIA) {
3311
			if (rank.equals(Rank.KINGDOM())) { result = Bacteria_Kingdom; }
3312
			else if (rank.equals(Rank.SUBKINGDOM())) { result = Bacteria_Subkingdom; }
3313
			else if (rank.equals(Rank.PHYLUM())) { result = Bacteria_Phylum; }
3314
			else if (rank.equals(Rank.SUBPHYLUM())) { result = Bacteria_Subphylum; }
3315
			else if (rank.equals(Rank.SUPERCLASS())) { result = Bacteria_Superclass; }
3316
			else if (rank.equals(Rank.CLASS())) { result = Bacteria_Class; }
3317
			else if (rank.equals(Rank.SUBCLASS())) { result = Bacteria_Subclass; }
3318
			else if (rank.equals(Rank.INFRACLASS())) { result = Bacteria_Infraclass; }
3319
			else if (rank.equals(Rank.SUPERORDER())) { result = Bacteria_Superorder; }
3320
			else if (rank.equals(Rank.ORDER())) { result = Bacteria_Order; }
3321
			else if (rank.equals(Rank.SUBORDER())) { result = Bacteria_Suborder; }
3322
			else if (rank.equals(Rank.INFRAORDER())) { result = Bacteria_Infraorder; }
3323
			else if (rank.equals(Rank.SUPERFAMILY())) { result = Bacteria_Superfamily; }
3324
			else if (rank.equals(Rank.FAMILY())) { result = Bacteria_Family; }
3325
			else if (rank.equals(Rank.SUBFAMILY())) { result = Bacteria_Subfamily; }
3326
			else if (rank.equals(Rank.TRIBE())) { result = Bacteria_Tribe; }
3327
			else if (rank.equals(Rank.SUBTRIBE())) { result = Bacteria_Subtribe; }
3328
			else if (rank.equals(Rank.GENUS())) { result = Bacteria_Genus; }
3329
			else if (rank.equals(Rank.SUBGENUS())) { result = Bacteria_Subgenus; }
3330
			else if (rank.equals(Rank.SPECIES())) { result = Bacteria_Species; }
3331
			else if (rank.equals(Rank.SUBSPECIES())) { result = Bacteria_Subspecies; }
3332
			else if (rank.equals(Rank.VARIETY())) { result = Bacteria_Variety; }
3333
			else if (rank.equals(Rank.FORM())) { result = Bacteria_Forma; }
3334
		} else {
3335
			//TODO Exception
3336
			logger.warn("Kingdom not yet supported in CDM: "+ pesiKingdomId);
3337
			return null;
3338
		}
3339
		return result;
3340
	}
3341

    
3342
	/**
3343
	 * 
3344
	 * @param nameTypeDesignationStatus
3345
	 * @return
3346
	 */
3347
	public static Integer nameTypeDesignationStatus2TypeDesignationStatusId(NameTypeDesignationStatus nameTypeDesignationStatus) {
3348
		if (nameTypeDesignationStatus == null) {
3349
			return null;
3350
		}
3351
		if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.ORIGINAL_DESIGNATION())) {
3352
			return TYPE_BY_ORIGINAL_DESIGNATION;
3353
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.SUBSEQUENT_DESIGNATION())) {
3354
			return TYPE_BY_SUBSEQUENT_DESIGNATION;
3355
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.MONOTYPY())) {
3356
			return TYPE_BY_MONOTYPY;
3357
		} else {
3358
			//TODO Figure out a way to handle this gracefully.
3359
			logger.warn("Name Type Designation Status not yet supported in PESI: "+ nameTypeDesignationStatus.getLabel());
3360
			return null;
3361
		}
3362

    
3363
	}
3364

    
3365
	/**
3366
	 * 
3367
	 * @param nameTypeDesignationStatus
3368
	 * @return
3369
	 */
3370
	public static String nameTypeDesignationStatus2TypeDesignationStatusCache(NameTypeDesignationStatus nameTypeDesignationStatus) {
3371
		if (nameTypeDesignationStatus == null) {
3372
			return null;
3373
		}
3374
		if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.ORIGINAL_DESIGNATION())) {
3375
			return TYPE_STR_BY_ORIGINAL_DESIGNATION;
3376
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.SUBSEQUENT_DESIGNATION())) {
3377
			return TYPE_STR_BY_SUBSEQUENT_DESIGNATION;
3378
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.MONOTYPY())) {
3379
			return TYPE_STR_BY_MONOTYPY;
3380
		} else {
3381
			//TODO Figure out a way to handle this gracefully.
3382
			logger.warn("Name Type Designation Status not yet supported in PESI: "+ nameTypeDesignationStatus.getLabel());
3383
			return null;
3384
		}
3385

    
3386
	}
3387

    
3388
	/**
3389
	 * 
3390
	 * @param taxonBase
3391
	 * @return
3392
	 */
3393
	public static Integer taxonBase2statusFk (TaxonBase<?> taxonBase){
3394
		if (taxonBase == null){return null;}		
3395
		if (taxonBase.isInstanceOf(Taxon.class)){
3396
			return T_STATUS_ACCEPTED;
3397
		}else if (taxonBase.isInstanceOf(Synonym.class)){
3398
			return T_STATUS_SYNONYM;
3399
		}else{
3400
			logger.warn("Unknown ");
3401
			return T_STATUS_UNRESOLVED;
3402
		}
3403
		//TODO 
3404
//		public static int T_STATUS_PARTIAL_SYN = 3;
3405
//		public static int T_STATUS_PRO_PARTE_SYN = 4;
3406
//		public static int T_STATUS_UNRESOLVED = 5;
3407
//		public static int T_STATUS_ORPHANED = 6;
3408
	}
3409

    
3410
	/**
3411
	 * 
3412
	 * @param taxonBase
3413
	 * @return
3414
	 */
3415
	public static String taxonBase2statusCache (TaxonBase<?> taxonBase){
3416
		if (taxonBase == null){return null;}
3417
		if (taxonBase.isInstanceOf(Taxon.class)){
3418
			return T_STATUS_STR_ACCEPTED;
3419
		}else if (taxonBase.isInstanceOf(Synonym.class)){
3420
			return T_STATUS_STR_SYNONYM;
3421
		}else{
3422
			logger.warn("Unknown ");
3423
			return T_STATUS_STR_UNRESOLVED;
3424
		}
3425
		//TODO 
3426
//		public static int T_STATUS_STR_PARTIAL_SYN = 3;
3427
//		public static int T_STATUS_STR_PRO_PARTE_SYN = 4;
3428
//		public static int T_STATUS_STR_UNRESOLVED = 5;
3429
//		public static int T_STATUS_STR_ORPHANED = 6;
3430
	}
3431
		
3432
	/**
3433
	 * Returns the {@link SourceCategory SourceCategory} representation of the given {@link ReferenceType ReferenceType} in PESI.
3434
	 * @param reference The {@link Reference Reference}.
3435
	 * @return The {@link SourceCategory SourceCategory} representation in PESI.
3436
	 */
3437
	public static Integer reference2SourceCategoryFK(Reference<?> reference) {
3438
		if (reference == null){
3439
			return null;
3440
		} else if (reference.getType().equals(ReferenceType.Article)) {
3441
			return REF_ARTICLE_IN_PERIODICAL;
3442
		} else if (reference.getType().equals(ReferenceType.Book)) {
3443
			return REF_BOOK;
3444
		} else if (reference.getType().equals(ReferenceType.BookSection)) {
3445
			return REF_PART_OF_OTHER;
3446
		} else if (reference.getType().equals(ReferenceType.Database)) {
3447
			return REF_DATABASE;
3448
		} else if (reference.getType().equals(ReferenceType.WebPage)) {
3449
			return REF_WEBSITE;
3450
		} else if (reference.getType().equals(ReferenceType.CdDvd)) {
3451
			return REF_NOT_APPLICABLE;
3452
		} else if (reference.getType().equals(ReferenceType.Journal)) {
3453
			return REF_JOURNAL;
3454
		} else if (reference.getType().equals(ReferenceType.Generic)) {
3455
			return REF_UNRESOLVED;
3456
		} else if (reference.getType().equals(ReferenceType.PrintSeries)) {
3457
			return REF_PUBLISHED;
3458
		} else if (reference.getType().equals(ReferenceType.Proceedings)) {
3459
			return REF_PUBLISHED;
3460
		} else if (reference.getType().equals(ReferenceType.Patent)) {
3461
			return REF_NOT_APPLICABLE;
3462
		} else if (reference.getType().equals(ReferenceType.PersonalCommunication)) {
3463
			return REF_INFORMAL;
3464
		} else if (reference.getType().equals(ReferenceType.Report)) {
3465
			return REF_NOT_APPLICABLE;
3466
		} else if (reference.getType().equals(ReferenceType.Thesis)) {
3467
			return REF_NOT_APPLICABLE;
3468
		} else {
3469
			logger.warn("Reference type not yet supported in PESI: "+ reference.getType());
3470
			return null;
3471
		}
3472
	}
3473
	
3474
	/**
3475
	 * Returns the {@link SourceCategoryCache SourceCategoryCache}.
3476
	 * @param reference The {@link Reference Reference}.
3477
	 * @return The {@link SourceCategoryCache SourceCategoryCache}.
3478
	 */
3479
	public static String getSourceCategoryCache(Reference<?> reference) {
3480
		if (reference == null){
3481
			return null;
3482
		} else if (reference.getType().equals(ReferenceType.Article)) {
3483
			return REF_STR_ARTICLE_IN_PERIODICAL;
3484
		} else if (reference.getType().equals(ReferenceType.Book)) {
3485
			return REF_STR_BOOK;
3486
		} else if (reference.getType().equals(ReferenceType.BookSection)) {
3487
			return REF_STR_PART_OF_OTHER;
3488
		} else if (reference.getType().equals(ReferenceType.Database)) {
3489
			return REF_STR_DATABASE;
3490
		} else if (reference.getType().equals(ReferenceType.WebPage)) {
3491
			return REF_STR_WEBSITE;
3492
		} else if (reference.getType().equals(ReferenceType.CdDvd)) {
3493
			return REF_STR_NOT_APPLICABLE;
3494
		} else if (reference.getType().equals(ReferenceType.Journal)) {
3495
			return REF_STR_JOURNAL;
3496
		} else if (reference.getType().equals(ReferenceType.Generic)) {
3497
			return REF_STR_UNRESOLVED;
3498
		} else if (reference.getType().equals(ReferenceType.PrintSeries)) {
3499
			return REF_STR_PUBLISHED;
3500
		} else if (reference.getType().equals(ReferenceType.Proceedings)) {
3501
			return REF_STR_PUBLISHED;
3502
		} else if (reference.getType().equals(ReferenceType.Patent)) {
3503
			return REF_STR_NOT_APPLICABLE;
3504
		} else if (reference.getType().equals(ReferenceType.PersonalCommunication)) {
3505
			return REF_STR_INFORMAL;
3506
		} else if (reference.getType().equals(ReferenceType.Report)) {
3507
			return REF_STR_NOT_APPLICABLE;
3508
		} else if (reference.getType().equals(ReferenceType.Thesis)) {
3509
			return REF_STR_NOT_APPLICABLE;
3510
		} else {
3511
			logger.warn("Reference type not yet supported in PESI: "+ reference.getType());
3512
			return null;
3513
		}
3514
	}
3515

    
3516
	/**
3517
	 * 
3518
	 * @param status
3519
	 * @return
3520
	 */
3521
	public String getCacheByNomStatus(NomenclaturalStatusType status) {
3522
		if (status == null){
3523
			return null;
3524
		}else{
3525
			return this.nameStatusCacheMap.get(nomStatus2nomStatusFk(status)); 
3526
		}
3527
	}
3528
	
3529
	/**
3530
	 * 
3531
	 * @param status
3532
	 * @return
3533
	 */
3534
	public static Integer nomStatus2nomStatusFk (NomenclaturalStatusType status){
3535
		if (status == null){
3536
			return null;
3537
		}
3538
		if (status.equals(NomenclaturalStatusType.INVALID())) {return NAME_ST_NOM_INVAL;
3539
		}else if (status.equals(NomenclaturalStatusType.ILLEGITIMATE())) {return NAME_ST_NOM_ILLEG;
3540
		}else if (status.equals(NomenclaturalStatusType.NUDUM())) {return NAME_ST_NOM_NUD;
3541
		}else if (status.equals(NomenclaturalStatusType.REJECTED())) {return NAME_ST_NOM_REJ;
3542
		}else if (status.equals(NomenclaturalStatusType.REJECTED_PROP())) {return NAME_ST_NOM_REJ_PROP;
3543
		}else if (status.equals(NomenclaturalStatusType.UTIQUE_REJECTED())) {return NAME_ST_NOM_UTIQUE_REJ;
3544
		}else if (status.equals(NomenclaturalStatusType.UTIQUE_REJECTED_PROP())) {return NAME_ST_NOM_UTIQUE_REJ_PROP;
3545
		}else if (status.equals(NomenclaturalStatusType.CONSERVED())) {return NAME_ST_NOM_CONS;
3546
		
3547
		}else if (status.equals(NomenclaturalStatusType.CONSERVED_PROP())) {return NAME_ST_NOM_CONS_PROP;
3548
		}else if (status.equals(NomenclaturalStatusType.ORTHOGRAPHY_CONSERVED())) {return NAME_ST_ORTH_CONS;
3549
		}else if (status.equals(NomenclaturalStatusType.ORTHOGRAPHY_CONSERVED_PROP())) {return NAME_ST_ORTH_CONS_PROP;
3550
		}else if (status.equals(NomenclaturalStatusType.SUPERFLUOUS())) {return NAME_ST_NOM_SUPERFL;
3551
		}else if (status.equals(NomenclaturalStatusType.AMBIGUOUS())) {return NAME_ST_NOM_AMBIG;
3552
		}else if (status.equals(NomenclaturalStatusType.PROVISIONAL())) {return NAME_ST_NOM_PROVIS;
3553
		}else if (status.equals(NomenclaturalStatusType.DOUBTFUL())) {return NAME_ST_NOM_DUB;
3554
		}else if (status.equals(NomenclaturalStatusType.NOVUM())) {return NAME_ST_NOM_NOV;
3555
		
3556
		}else if (status.equals(NomenclaturalStatusType.CONFUSUM())) {return NAME_ST_NOM_CONFUS;
3557
		}else if (status.equals(NomenclaturalStatusType.ALTERNATIVE())) {return NAME_ST_NOM_ALTERN;
3558
		}else if (status.equals(NomenclaturalStatusType.COMBINATION_INVALID())) {return NAME_ST_COMB_INVAL;
3559
		}else if (status.equals(NomenclaturalStatusType.LEGITIMATE())) {return NAME_ST_LEGITIMATE;
3560
		
3561
		}else if (status.getUuid().equals(BerlinModelTransformer.uuidNomStatusCombIned)) {return NAME_ST_COMB_INED;
3562
		}else if (status.getUuid().equals(BerlinModelTransformer.uuidNomStatusNomOrthCons)) {return NAME_ST_NOM_AND_ORTH_CONS;
3563
		}else if (status.getUuid().equals(BerlinModelTransformer.uuidNomStatusSpNovIned)) {return NAME_ST_SP_NOV_INED;
3564
		
3565
		
3566
		// The following are non-existent in CDM
3567
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_COMB_AND_STAT_INED;
3568
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_NOM_NOV_INED;
3569
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_ALTERNATE_REPRESENTATION;
3570
		}else if (status.getUuid().equals(FaunaEuropaeaTransformer.uuidNomStatusTempNamed)) {return NAME_ST_TEMPORARY_NAME;
3571
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_SPECIES_INQUIRENDA;
3572

    
3573
		//TODO
3574
		}else {
3575
			//TODO Exception
3576
			logger.warn("NomStatus type not yet supported by PESI export: "+ status);
3577
			return null;
3578
		}
3579
	}
3580
	
3581
	/**
3582
	 * Returns the RelTaxonQualifierCache for a given taxonRelation.
3583
	 * @param relation
3584
	 * @return
3585
	 */
3586
	public String getCacheByRelationshipType(RelationshipBase relation, NomenclaturalCode code){
3587
		if (relation == null){
3588
			return null;
3589
		}else{
3590
			String result; 
3591
			Integer key = taxonRelation2RelTaxonQualifierFk(relation);
3592
			if (code.equals(NomenclaturalCode.ICZN)){
3593
				result = this.taxRelZooQualifierCacheMap.get(key);
3594
				if (result == null){
3595
					this.taxRelQualifierCacheMap.get(key); 
3596
				}
3597
			}else{
3598
				result = this.taxRelQualifierCacheMap.get(key); 
3599
			}
3600
			return result;
3601
		}
3602
	}
3603
	
3604
	/**
3605
	 * Returns the RelTaxonQualifierFk for a TaxonRelation.
3606
	 * @param relation
3607
	 * @return
3608
	 */
3609
	public static Integer taxonRelation2RelTaxonQualifierFk(RelationshipBase<?,?,?> relation) {
3610
		if (relation == null) {
3611
			return null;
3612
		}
3613
		RelationshipTermBase<?> type = relation.getType();
3614
		if (type.equals(TaxonRelationshipType.MISAPPLIED_NAME_FOR())) {
3615
			return IS_MISAPPLIED_NAME_FOR;
3616
		} else if (type.equals(SynonymRelationshipType.SYNONYM_OF())) {
3617
			SynonymRelationship synRel = CdmBase.deproxy(relation, SynonymRelationship.class);
3618
			if (synRel.isProParte()){
3619
				return IS_PRO_PARTE_SYNONYM_OF;
3620
			}else if (synRel.isPartial()){
3621
				return IS_PARTIAL_SYNONYM_OF;
3622
			}else{
3623
				return IS_SYNONYM_OF;
3624
			}
3625
		} else if (type.equals(SynonymRelationshipType.HOMOTYPIC_SYNONYM_OF())) {
3626
			SynonymRelationship synRel = CdmBase.deproxy(relation, SynonymRelationship.class);
3627
			if (synRel.isProParte()){
3628
				return IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF;
3629
			}else if (synRel.isPartial()){
3630
				return IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF;
3631
			}else{
3632
				return IS_HOMOTYPIC_SYNONYM_OF;
3633
			}
3634
		} else if (type.equals(SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF())) {
3635
			SynonymRelationship synRel = CdmBase.deproxy(relation, SynonymRelationship.class);
3636
			if (synRel.isProParte()){
3637
				return IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF;
3638
			}else if (synRel.isPartial()){
3639
				return IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF;
3640
			}else{
3641
				return IS_HETEROTYPIC_SYNONYM_OF;
3642
			}
3643
		} else if (type.equals(SynonymRelationshipType.INFERRED_EPITHET_OF())) {
3644
			return IS_INFERRED_EPITHET_FOR;
3645
		} else if (type.equals(SynonymRelationshipType.INFERRED_GENUS_OF())) {
3646
			return IS_INFERRED_GENUS_FOR;
3647
		} else if (type.equals(SynonymRelationshipType.POTENTIAL_COMBINATION_OF())) {
3648
			return IS_POTENTIAL_COMBINATION_FOR;
3649
		} else if (type.equals(NameRelationshipType.BASIONYM())) {
3650
			return IS_BASIONYM_FOR;
3651
		} else if (type.equals(NameRelationshipType.LATER_HOMONYM())) {
3652
			return IS_LATER_HOMONYM_OF;
3653
		} else if (type.equals(NameRelationshipType.REPLACED_SYNONYM())) {
3654
			return IS_REPLACED_SYNONYM_FOR;
3655
		} else if (type.equals(NameRelationshipType.VALIDATED_BY_NAME())) {
3656
			return IS_VALIDATION_OF;
3657
		} else if (type.equals(NameRelationshipType.LATER_VALIDATED_BY_NAME())) {
3658
			return IS_LATER_VALIDATION_OF;
3659
		} else if (type.equals(NameRelationshipType.CONSERVED_AGAINST())) {
3660
			return IS_CONSERVED_AGAINST;
3661
		} else if (type.equals(NameRelationshipType.TREATED_AS_LATER_HOMONYM())) {
3662
			return IS_TREATED_AS_LATER_HOMONYM_OF;
3663
		} else if (type.equals(NameRelationshipType.ORTHOGRAPHIC_VARIANT())) {
3664
			return IS_ORTHOGRAPHIC_VARIANT_OF;
3665
		} else if (type.equals(NameRelationshipType.ALTERNATIVE_NAME())) {
3666
			return IS_ALTERNATIVE_NAME_FOR;
3667
		} else if (type.equals(HybridRelationshipType.FEMALE_PARENT())) {
3668
			return IS_FEMALE_PARENT_OF;
3669
		} else if (type.equals(HybridRelationshipType.MALE_PARENT())) {
3670
			return IS_MALE_PARENT_OF;
3671
		} else if (type.equals(HybridRelationshipType.FIRST_PARENT())) {
3672
			return IS_FIRST_PARENT_OF;
3673
		} else if (type.equals(HybridRelationshipType.SECOND_PARENT())) {
3674
			return IS_SECOND_PARENT_OF;
3675
		} else if (type.getUuid().equals(ErmsTransformer.uuidTaxRelTypeIsTaxonSynonymOf)) {
3676
			return IS_SYNONYM_OF;
3677
		} else {
3678
			logger.warn("No equivalent RelationshipType found in datawarehouse for: " + type.getTitleCache());
3679
		}
3680

    
3681
		// The following have no equivalent attribute in CDM
3682
//		IS_TYPE_OF
3683
//		IS_CONSERVED_TYPE_OF
3684
//		IS_REJECTED_TYPE_OF
3685
//		IS_REJECTED_IN_FAVOUR_OF
3686
//		HAS_SAME_TYPE_AS
3687
//		IS_LECTOTYPE_OF
3688
//		TYPE_NOT_DESIGNATED
3689

    
3690

    
3691
		return null;
3692
	}
3693
	
3694
	/**
3695
	 * Returns the StatusFk for a given StatusCache.
3696
	 * @param StatusCache
3697
	 * @return
3698
	 */
3699
	public Integer StatusCache2StatusFk(String StatusCache) {
3700
		Integer result = null;
3701
		if (StatusCache.equalsIgnoreCase("Checked by Taxonomic Editor: included in ERMS 1.1")) {
3702
			return 0;
3703
		} else if (StatusCache.equalsIgnoreCase("Added by Database Management Team")) {
3704
			return 2;
3705
		} else if (StatusCache.equalsIgnoreCase("Checked by Taxonomic Editor")) {
3706
			return 3;
3707
		} else if (StatusCache.equalsIgnoreCase("Edited by Database Management Team")) {
3708
			return 4;
3709
		} else {
3710
			logger.error("StatusFk could not be determined. StatusCache unknown: " + StatusCache);
3711
		}
3712
		
3713
		return result;
3714
	}
3715
	
3716
	/**
3717
	 * Returns the FossilStatusFk for a given FossilStatusCache.
3718
	 * @param fossilStatusCache
3719
	 * @return
3720
	 */
3721
	public Integer FossilStatusCache2FossilStatusFk(String fossilStatusCache) {
3722
		Integer result = null;
3723
		if (fossilStatusCache.equalsIgnoreCase("recent only")) {
3724
			return 1;
3725
		} else if (fossilStatusCache.equalsIgnoreCase("fossil only")) {
3726
			return 2;
3727
		} else if (fossilStatusCache.equalsIgnoreCase("recent + fossil")) {
3728
			return 3;
3729
		} else {
3730
			logger.error("FossilStatusFk could not be determined. FossilStatusCache unknown: " + fossilStatusCache);
3731
		}
3732
		
3733
		return result;
3734
	}
3735

    
3736
	/**
3737
	 * Returns the NoteCategoryFk for a given UUID representing an ExtensionType.
3738
	 * @param uuid
3739
	 * @return
3740
	 */
3741
	public static Integer getNoteCategoryFk(UUID uuid) {
3742
		Integer result = null;
3743
		if (uuid.equals(taxCommentUuid)) {
3744
			result = 270;
3745
		} else if (uuid.equals(fauCommentUuid)) {
3746
			result = 281;
3747
		} else if (uuid.equals(fauExtraCodesUuid)) {
3748
			result = 278;
3749
		}
3750
		return result;
3751
	}
3752
	
3753
	/**
3754
	 * Returns the NoteCategoryCache for a given UUID representing an ExtensionType.
3755
	 * @param uuid
3756
	 * @return
3757
	 */
3758
	public static String getNoteCategoryCache(UUID uuid) {
3759
		String result = null;
3760
		if (uuid.equals(taxCommentUuid)) {
3761
			result = "Taxonomy";
3762
		} else if (uuid.equals(fauCommentUuid)) {
3763
			result = "Biology";
3764
		} else if (uuid.equals(fauExtraCodesUuid)) {
3765
			result = "Distribution";
3766
		}
3767
		return result;
3768
	}
3769

    
3770
	public static Integer getQualityStatusKeyBySource(BitSet sources, TaxonNameBase<?,?> taxonName) {
3771
		if (sources.get(SOURCE_EM)){
3772
			return QUALITY_STATUS_ADD_BY_DBMT;
3773
		}else if (sources.get(SOURCE_ERMS)){
3774
			Set<String> statusSet = getAllQualityStatus(taxonName);
3775
			if (statusSet.size() > 1){
3776
				logger.warn("ERMS TaxonName has more than 1 quality status: " + taxonName.getTitleCache() + "; lisd=" + taxonName.getLsid());
3777
			}
3778
			if (statusSet.contains("Checked by Taxonomic Editor: included in ERMS 1.1")){
3779
				return QUALITY_STATUS_CHECKED_EDITOR_ERMS_1_1;
3780
			}else if (statusSet.contains("Added by Database Management Team")){
3781
				return QUALITY_STATUS_ADD_BY_DBMT;
3782
			}else if (statusSet.contains("Checked by Taxonomic Editor")){
3783
				return QUALITY_STATUS_CHECKED_EDITOR;
3784
			}else if (statusSet.contains("Edited by Database Management Team")){
3785
				return QUALITY_STATUS_EDITED_BY_DBMT;
3786
			}else{
3787
				logger.warn("Unknown ERMS quality status: " + statusSet.iterator().next() + " for taxon name " + taxonName.getTitleCache());
3788
				return null;
3789
			}
3790
		}else{
3791
			return null;   // TODO needs to be implemented for others 
3792
		}
3793
	}
3794

    
3795
	
3796
	private static Set<String> getAllQualityStatus(TaxonNameBase<?, ?> taxonName) {
3797
		Set<String> result = new HashSet<String>();
3798
		for (TaxonBase<?> taxonBase : taxonName.getTaxonBases()){
3799
			result.addAll(taxonBase.getExtensions(ErmsTransformer.uuidQualityStatus));
3800
		}
3801
		return result;
3802
	}
3803

    
3804
	@Override
3805
	public String getQualityStatusCacheByKey(Integer qualityStatusId) throws UndefinedTransformerMethodException {
3806
		if (qualityStatusId == null){
3807
			return null;
3808
		}else{
3809
			return this.qualityStatusCacheMap.get(qualityStatusId); 
3810
		}
3811
	}
3812

    
3813
	public static String getOriginalDbBySources(BitSet sources) {
3814
		String result = "";
3815
		if (sources.get(SOURCE_EM)){
3816
			result = CdmUtils.concat(",", result,  SOURCE_STR_EM);
3817
		}
3818
		if (sources.get(SOURCE_FE)){
3819
			result = CdmUtils.concat(",", result,  SOURCE_STR_FE);
3820
		}
3821
		if (sources.get(SOURCE_IF)){
3822
			result = CdmUtils.concat(",", result,  SOURCE_STR_IF);
3823
		}
3824
		if (sources.get(SOURCE_ERMS)){
3825
			result = CdmUtils.concat(",", result,  SOURCE_STR_ERMS);
3826
		}
3827
		
3828
		return result;
3829
	}
3830

    
3831
	
3832
}
(17-17/17)