Project

General

Profile

Download (199 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.util.UUID;
13

    
14
import org.apache.log4j.Logger;
15

    
16
import eu.etaxonomy.cdm.io.pesi.erms.ErmsTransformer;
17
import eu.etaxonomy.cdm.model.common.CdmBase;
18
import eu.etaxonomy.cdm.model.common.ExtensionType;
19
import eu.etaxonomy.cdm.model.common.Language;
20
import eu.etaxonomy.cdm.model.common.RelationshipBase;
21
import eu.etaxonomy.cdm.model.common.RelationshipTermBase;
22
import eu.etaxonomy.cdm.model.description.AbsenceTerm;
23
import eu.etaxonomy.cdm.model.description.Feature;
24
import eu.etaxonomy.cdm.model.description.PresenceAbsenceTermBase;
25
import eu.etaxonomy.cdm.model.description.PresenceTerm;
26
import eu.etaxonomy.cdm.model.location.NamedArea;
27
import eu.etaxonomy.cdm.model.location.TdwgArea;
28
import eu.etaxonomy.cdm.model.name.BacterialName;
29
import eu.etaxonomy.cdm.model.name.BotanicalName;
30
import eu.etaxonomy.cdm.model.name.NameRelationshipType;
31
import eu.etaxonomy.cdm.model.name.NameTypeDesignationStatus;
32
import eu.etaxonomy.cdm.model.name.NomenclaturalCode;
33
import eu.etaxonomy.cdm.model.name.NomenclaturalStatusType;
34
import eu.etaxonomy.cdm.model.name.Rank;
35
import eu.etaxonomy.cdm.model.name.TaxonNameBase;
36
import eu.etaxonomy.cdm.model.name.ZoologicalName;
37
import eu.etaxonomy.cdm.model.occurrence.Fossil;
38
import eu.etaxonomy.cdm.model.reference.Reference;
39
import eu.etaxonomy.cdm.model.reference.ReferenceType;
40
import eu.etaxonomy.cdm.model.taxon.Synonym;
41
import eu.etaxonomy.cdm.model.taxon.SynonymRelationshipType;
42
import eu.etaxonomy.cdm.model.taxon.Taxon;
43
import eu.etaxonomy.cdm.model.taxon.TaxonBase;
44
import eu.etaxonomy.cdm.model.taxon.TaxonRelationshipType;
45
import eu.etaxonomy.cdm.strategy.exceptions.UnknownCdmTypeException;
46

    
47
/**
48
 * @author e.-m.lee
49
 * @date 16.02.2010
50
 *
51
 */
52
public final class PesiTransformer {
53
	private static final Logger logger = Logger.getLogger(PesiTransformer.class);
54

    
55
	public static final String auctString = "auct.";
56
	
57
	public static final UUID cacheCitationUuid = UUID.fromString("29656168-32d6-4301-9067-d57c63be5c67");
58
	public static final UUID expertUserIdUuid = UUID.fromString("e25813d3-c67c-4585-9aa0-970fafde50b4");
59
	public static final UUID speciesExpertUserIdUuid = UUID.fromString("6d42abd8-8894-4980-ae07-e918affd4172");
60
	public static final UUID expertNameUuid = UUID.fromString("24becb79-a90c-47d3-be35-efc87bb48fd3");
61
	public static final UUID speciesExpertNameUuid = UUID.fromString("2e8153d2-7412-49e4-87e1-5c38f4c5153a");
62
	public static final UUID lastActionDateUuid = UUID.fromString("8d0a7d81-bb83-4576-84c3-8c906ef039b2");
63
	public static final UUID lastActionUuid = UUID.fromString("bc20d5bc-6161-4279-9499-89ea26ce5f6a");
64
	public static final UUID taxCommentUuid = UUID.fromString("8041a752-0479-4626-ab1b-b266b751f816");
65
	public static final UUID fauCommentUuid = UUID.fromString("054f773a-41c8-4ad5-83e3-981320c1c126");
66
	public static final UUID fauExtraCodesUuid = UUID.fromString("b8c7e77d-9869-4787-bed6-b4b302dbc5f5");
67

    
68
	// References
69
	public static int REF_ARTICLE_IN_PERIODICAL = 1;
70
	public static int REF_PART_OF_OTHER = 2;
71
	public static int REF_BOOK = 3;
72
	public static int REF_DATABASE = 4;
73
	public static int REF_INFORMAL = 5;
74
	public static int REF_NOT_APPLICABLE = 6;
75
	public static int REF_WEBSITE = 7;
76
	public static int REF_PUBLISHED = 8;
77
	public static int REF_JOURNAL = 9;
78
	public static int REF_UNRESOLVED = 10;
79
	public static int REF_PUBLICATION = 11;
80

    
81
	public static String REF_STR_ARTICLE_IN_PERIODICAL = "Article in periodical";
82
	public static String REF_STR_PART_OF_OTHER = "Part of other";
83
	public static String REF_STR_BOOK = "Book";
84
	public static String REF_STR_DATABASE = "Database";
85
	public static String REF_STR_INFORMAL = "Informal";
86
	public static String REF_STR_NOT_APPLICABLE = "Not applicable";
87
	public static String REF_STR_WEBSITE = "Website";
88
	public static String REF_STR_PUBLISHED = "Published";
89
	public static String REF_STR_JOURNAL = "Journal";
90
	public static String REF_STR_UNRESOLVED = "Unresolved";
91
	public static String REF_STR_PUBLICATION = "Publication";
92
	
93
	// NameStatus
94
	public static int NAME_ST_NOM_INVAL = 1;
95
	public static int NAME_ST_NOM_ILLEG = 2;
96
	public static int NAME_ST_NOM_NUD = 3;
97
	public static int NAME_ST_NOM_REJ = 4;
98
	public static int NAME_ST_NOM_REJ_PROP = 5;
99
	public static int NAME_ST_NOM_UTIQUE_REJ = 6;
100
	public static int NAME_ST_NOM_UTIQUE_REJ_PROP = 7;
101
	public static int NAME_ST_NOM_CONS = 8;
102
	public static int NAME_ST_NOM_CONS_PROP = 9;
103
	public static int NAME_ST_ORTH_CONS = 10;
104
	public static int NAME_ST_ORTH_CONS_PROP = 11;
105
	public static int NAME_ST_NOM_SUPERFL = 12;
106
	public static int NAME_ST_NOM_AMBIG = 13;
107
	public static int NAME_ST_NOM_PROVIS = 14;
108
	public static int NAME_ST_NOM_DUB = 15;
109
	public static int NAME_ST_NOM_NOV = 16;
110
	public static int NAME_ST_NOM_CONFUS = 17;
111
	public static int NAME_ST_NOM_ALTERN = 18;
112
	public static int NAME_ST_COMB_INVAL = 19;
113
	public static int NAME_ST_LEGITIMATE = 20; // PESI specific from here
114
	public static int NAME_ST_COMB_INED = 21;
115
	public static int NAME_ST_COMB_AND_STAT_INED = 22;
116
	public static int NAME_ST_NOM_AND_ORTH_CONS = 23;
117
	public static int NAME_ST_NOM_NOV_INED = 24;
118
	public static int NAME_ST_SP_NOV_INED = 25;
119
	public static int NAME_ST_ALTERNATE_REPRESENTATION = 26;
120
	public static int NAME_ST_TEMPORARY_NAME = 27;
121
	public static int NAME_ST_SPECIES_INQUIRENDA = 28;
122

    
123
	public static String NAME_ST_STR_NOM_INVAL = "Nom. Inval.";
124
	public static String NAME_ST_STR_NOM_ILLEG = "Nom. Illeg.";
125
	public static String NAME_ST_STR_NOM_NUD = "Nom. Nud.";
126
	public static String NAME_ST_STR_NOM_REJ = "Nom. Rej.";
127
	public static String NAME_ST_STR_NOM_REJ_PROP = "Nom. Rej. Prop.";
128
	public static String NAME_ST_STR_NOM_UTIQUE_REJ = "Nom. Utique Rej.";
129
	public static String NAME_ST_STR_NOM_UTIQUE_REJ_PROP = "Nom. Utique Rej. Prop.";
130
	public static String NAME_ST_STR_NOM_CONS = "Nom. Cons.";
131
	public static String NAME_ST_STR_NOM_CONS_PROP = "Nom. Cons. Prop.";
132
	public static String NAME_ST_STR_ORTH_CONS = "Orth. Cons.";
133
	public static String NAME_ST_STR_ORTH_CONS_PROP = "Orth. Cons. Prop.";
134
	public static String NAME_ST_STR_NOM_SUPERFL = "Nom. Superfl.";
135
	public static String NAME_ST_STR_NOM_AMBIG = "Nom. Ambig.";
136
	public static String NAME_ST_STR_NOM_PROVIS = "Nom. Provis.";
137
	public static String NAME_ST_STR_NOM_DUB = "Nom. Dub.";
138
	public static String NAME_ST_STR_NOM_NOV = "Nom. Nov.";
139
	public static String NAME_ST_STR_NOM_CONFUS = "Nom. Confus.";
140
	public static String NAME_ST_STR_NOM_ALTERN = "Nom. Altern.";
141
	public static String NAME_ST_STR_COMB_INVAL = "Comb. Inval.";
142
	public static String NAME_ST_STR_LEGITIMATE = "Legitim"; 
143
	public static String NAME_ST_STR_COMB_INED = "Comb. Ined."; // PESI specific from here
144
	public static String NAME_ST_STR_COMB_AND_STAT_INED = "Comb. & Stat. Ined.";
145
	public static String NAME_ST_STR_NOM_AND_ORTH_CONS = "Nom. & Orth. Cons.";
146
	public static String NAME_ST_STR_NOM_NOV_INED = "Nom. Nov. Ined.";
147
	public static String NAME_ST_STR_SP_NOV_INED = "Sp. Nov. Ined.";
148
	public static String NAME_ST_STR_ALTERNATE_REPRESENTATION = "Alternate Representation";
149
	public static String NAME_ST_STR_TEMPORARY_NAME = "Temporary Name";
150
	public static String NAME_ST_STR_SPECIES_INQUIRENDA = "Species Inquirenda";
151

    
152
	// TaxonStatus
153
	public static int T_STATUS_ACCEPTED = 1;
154
	public static int T_STATUS_SYNONYM = 2;
155
	public static int T_STATUS_PARTIAL_SYN = 3;
156
	public static int T_STATUS_PRO_PARTE_SYN = 4;
157
	public static int T_STATUS_UNRESOLVED = 5;
158
	public static int T_STATUS_ORPHANED = 6;
159
	
160
	public static String T_STATUS_STR_ACCEPTED = "Accepted";
161
	public static String T_STATUS_STR_SYNONYM = "Synonym";
162
	public static String T_STATUS_STR_PARTIAL_SYN = "Partial Synonym";
163
	public static String T_STATUS_STR_PRO_PARTE_SYN = "Pro Parte Synonym";
164
	public static String T_STATUS_STR_UNRESOLVED = "Unresolved";
165
	public static String T_STATUS_STR_ORPHANED = "Orphaned";
166
	
167
	// TypeDesginationStatus
168
	public static int TYPE_BY_ORIGINAL_DESIGNATION = 1;
169
	public static int TYPE_BY_SUBSEQUENT_DESIGNATION = 2;
170
	public static int TYPE_BY_MONOTYPY = 3;
171
	
172
	public static String TYPE_STR_BY_ORIGINAL_DESIGNATION = "Type by original designation";
173
	public static String TYPE_STR_BY_SUBSEQUENT_DESIGNATION = "Type by subsequent designation";
174
	public static String TYPE_STR_BY_MONOTYPY = "Type by monotypy";
175
	
176
	// RelTaxonQualifier
177
	public static int IS_BASIONYM_FOR = 1;
178
	public static int IS_LATER_HOMONYM_OF = 2;
179
	public static int IS_REPLACED_SYNONYM_FOR = 3;
180
	public static int IS_VALIDATION_OF = 4;
181
	public static int IS_LATER_VALIDATION_OF = 5;
182
	public static int IS_TYPE_OF = 6;
183
	public static int IS_CONSERVED_TYPE_OF = 7;
184
	public static int IS_REJECTED_TYPE_OF = 8;
185
	public static int IS_FIRST_PARENT_OF = 9;
186
	public static int IS_SECOND_PARENT_OF = 10;
187
	public static int IS_FEMALE_PARENT_OF = 11;
188
	public static int IS_MALE_PARENT_OF = 12;
189
	public static int IS_CONSERVED_AGAINST = 13;
190
	public static int IS_REJECTED_IN_FAVOUR_OF = 14;
191
	public static int IS_TREATED_AS_LATER_HOMONYM_OF = 15;
192
	public static int IS_ORTHOGRAPHIC_VARIANT_OF = 16;
193
	public static int IS_ALTERNATIVE_NAME_FOR = 17;
194
	public static int HAS_SAME_TYPE_AS = 18;
195
	public static int IS_LECTOTYPE_OF = 61;
196
	public static int TYPE_NOT_DESIGNATED = 62;
197
	public static int IS_TAXONOMICALLY_INCLUDED_IN = 101;
198
	public static int IS_SYNONYM_OF = 102;
199
	public static int IS_MISAPPLIED_NAME_FOR = 103;
200
	public static int IS_PRO_PARTE_SYNONYM_OF = 104;
201
	public static int IS_PARTIAL_SYNONYM_OF = 105;
202
	public static int IS_HETEROTYPIC_SYNONYM_OF = 106;
203
	public static int IS_HOMOTYPIC_SYNONYM_OF = 107;
204
	public static int IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF = 201;
205
	public static int IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF = 202;
206
	public static int IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF = 203;
207
	public static int IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF = 204;
208
	public static int IS_INFERRED_EPITHET_FOR = 301;
209
	public static int IS_INFERRED_GENUS_FOR = 302;
210
	public static int IS_POTENTIAL_COMBINATION_FOR = 303;
211

    
212
	public static String STR_IS_BASIONYM_FOR = "is basionym for";
213
	public static String STR_IS_LATER_HOMONYM_OF = "is later homonym of";
214
	public static String STR_IS_REPLACED_SYNONYM_FOR = "is replaced synonym for";
215
	public static String STR_IS_VALIDATION_OF = "is validation of";
216
	public static String STR_IS_LATER_VALIDATION_OF = "is later validation of";
217
	public static String STR_IS_TYPE_OF = "is type of";
218
	public static String STR_IS_CONSERVED_TYPE_OF = "is conserved type of";
219
	public static String STR_IS_REJECTED_TYPE_OF = "is rejected type of";
220
	public static String STR_IS_FIRST_PARENT_OF = "is first parent of";
221
	public static String STR_IS_SECOND_PARENT_OF = "is second parent of";
222
	public static String STR_IS_FEMALE_PARENT_OF = "is female parent of";
223
	public static String STR_IS_MALE_PARENT_OF = "is male parent of";
224
	public static String STR_IS_CONSERVED_AGAINST = "is conserved against";
225
	public static String STR_IS_REJECTED_IN_FAVOUR_OF = "is rejected in favour of";
226
	public static String STR_IS_TREATED_AS_LATER_HOMONYM_OF = "is treated as later homonym of";
227
	public static String STR_IS_ORTHOGRAPHIC_VARIANT_OF = "is orthographic variant of";
228
	public static String STR_IS_ALTERNATIVE_NAME_FOR = "is alternative name for";
229
	public static String STR_HAS_SAME_TYPE_AS = "has same type as";
230
	public static String STR_IS_LECTOTYPE_OF = "is lectotype of";
231
	public static String STR_TYPE_NOT_DESIGNATED = "type not designated";
232
	public static String STR_IS_TAXONOMICALLY_INCLUDED_IN  = "is taxonomically included in";
233
	public static String STR_IS_SYNONYM_OF = "is synonym of";
234
	public static String STR_IS_MISAPPLIED_NAME_FOR = "is misapplied name for";
235
	public static String STR_IS_PRO_PARTE_SYNONYM_OF = "is pro parte synonym of";
236
	public static String STR_IS_PARTIAL_SYNONYM_OF = "is partial synonym of";
237
	public static String STR_IS_HETEROTYPIC_SYNONYM_OF = "is heterotypic synonym of";
238
	public static String STR_IS_HOMOTYPIC_SYNONYM_OF = "is homotypic synonym of";
239
	public static String STR_IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF = "is pro parte and homotypic synonym of";
240
	public static String STR_IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF = "is pro parte and heterotypic synonym of";
241
	public static String STR_IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF = "is partial and homotypic synonym of";
242
	public static String STR_IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF = "is partial and heterotypic synonym of";
243
	public static String STR_IS_INFERRED_EPITHET_FOR = "is inferred epithet for";
244
	public static String STR_IS_INFERRED_GENUS_FOR = "is inferred genus for";
245
	public static String STR_IS_POTENTIAL_COMBINATION_FOR = "is potential combination for";
246

    
247
	// Kingdoms
248
	public static int KINGDOM_NULL = 0;
249
	public static int KINGDOM_ANIMALIA = 2;
250
	public static int KINGDOM_PLANTAE = 3;
251
	public static int KINGDOM_FUNGI = 4;
252
	public static int KINGDOM_PROTOZOA = 5;
253
	public static int KINGDOM_BACTERIA = 6;
254
	public static int KINGDOM_CHROMISTA = 7;
255

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

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

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

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

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

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

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

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

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

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

    
1008

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

    
1208

    
1209
	
1210
	// OccurrenceStatus
1211
	public static int STATUS_PRESENT = 1;
1212
	public static int STATUS_ABSENT = 2;
1213
	public static int STATUS_NATIVE = 3;
1214
	public static int STATUS_INTRODUCED = 4;
1215
	public static int STATUS_NATURALISED = 5;
1216
	public static int STATUS_INVASIVE = 6;
1217
	public static int STATUS_MANAGED = 7;
1218
	public static int STATUS_DOUBTFUL = 8;
1219

    
1220
	public static String STR_STATUS_PRESENT = "Present";
1221
	public static String STR_STATUS_ABSENT = "Absent";
1222
	public static String STR_STATUS_NATIVE = "Native";
1223
	public static String STR_STATUS_INTRODUCED = "Introduced";
1224
	public static String STR_STATUS_NATURALISED = "Naturalised";
1225
	public static String STR_STATUS_INVASIVE = "Invasive";
1226
	public static String STR_STATUS_MANAGED = "Managed";
1227
	public static String STR_STATUS_DOUBTFUL = "Doubtful";
1228

    
1229

    
1230
	/**
1231
	 * Converts the databaseString to its abbreviation if its known.
1232
	 * Otherwise the databaseString is returned.
1233
	 * @param databaseString
1234
	 * @return
1235
	 */
1236
	public static String databaseString2Abbreviation(String databaseString) {
1237
		String result = databaseString;
1238
		if (databaseString.equals("Fauna Europaea database")) {
1239
			result = "FaEu";
1240
		}
1241
		return result;
1242
	}
1243
	
1244
	/**
1245
	 * Returns the OccurrenceStatusCache for a given PresenceAbsenceTerm.
1246
	 * @param term
1247
	 * @return
1248
	 * @throws UnknownCdmTypeException 
1249
	 */
1250
	public static String presenceAbsenceTerm2OccurrenceStatusCache(PresenceAbsenceTermBase<?> term) {
1251
		String result = null;
1252
		if (term.isInstanceOf(PresenceTerm.class)) {
1253
			PresenceTerm presenceTerm = CdmBase.deproxy(term, PresenceTerm.class);
1254
			if (presenceTerm.equals(PresenceTerm.PRESENT())) {
1255
				result = STR_STATUS_PRESENT;
1256
			} else if (presenceTerm.equals(PresenceTerm.NATIVE())) {
1257
				result = STR_STATUS_NATIVE;
1258
			} else if (presenceTerm.equals(PresenceTerm.INTRODUCED())) {
1259
				result = STR_STATUS_INTRODUCED;
1260
			} else if (presenceTerm.equals(PresenceTerm.NATURALISED())) {
1261
				result = STR_STATUS_NATURALISED;
1262
			} else if (presenceTerm.equals(PresenceTerm.INVASIVE())) {
1263
				result = STR_STATUS_INVASIVE;
1264
			} else if (presenceTerm.equals(PresenceTerm.INTRODUCED_CULTIVATED())) {
1265
				result = STR_STATUS_MANAGED;
1266
			} else if (presenceTerm.equals(PresenceTerm.PRESENT_DOUBTFULLY())) {
1267
				result = STR_STATUS_DOUBTFUL;
1268
			} else {
1269
				logger.error("PresenceTerm could not be translated to datawarehouse occurrence status id: " + presenceTerm.getLabel());
1270
			}
1271
		} else if (term.isInstanceOf(AbsenceTerm.class)) {
1272
			AbsenceTerm absenceTerm = CdmBase.deproxy(term, AbsenceTerm.class);
1273
			if (absenceTerm.equals(AbsenceTerm.ABSENT())) {
1274
				result = STR_STATUS_ABSENT;
1275
			} else {
1276
				logger.error("AbsenceTerm could not be translated to datawarehouse occurrence status id: " + absenceTerm.getLabel());
1277
			}
1278
		}
1279
		return result;
1280
	}
1281

    
1282
	/**
1283
	 * Returns the OccurrenceStatusId for a given PresenceAbsenceTerm.
1284
	 * @param term
1285
	 * @return
1286
	 * @throws UnknownCdmTypeException 
1287
	 */
1288
	public static Integer presenceAbsenceTerm2OccurrenceStatusId(PresenceAbsenceTermBase<?> term) {
1289
		Integer result = null;
1290
		if (term.isInstanceOf(PresenceTerm.class)) {
1291
			PresenceTerm presenceTerm = CdmBase.deproxy(term, PresenceTerm.class);
1292
			if (presenceTerm.equals(PresenceTerm.PRESENT())) {
1293
				result = STATUS_PRESENT;
1294
			} else if (presenceTerm.equals(PresenceTerm.NATIVE())) {
1295
				result = STATUS_NATIVE;
1296
			} else if (presenceTerm.equals(PresenceTerm.INTRODUCED())) {
1297
				result = STATUS_INTRODUCED;
1298
			} else if (presenceTerm.equals(PresenceTerm.NATURALISED())) {
1299
				result = STATUS_NATURALISED;
1300
			} else if (presenceTerm.equals(PresenceTerm.INVASIVE())) {
1301
				result = STATUS_INVASIVE;
1302
			} else if (presenceTerm.equals(PresenceTerm.CULTIVATED())) {
1303
				result = STATUS_MANAGED;
1304
			} else if (presenceTerm.equals(PresenceTerm.PRESENT_DOUBTFULLY())) {
1305
				result = STATUS_DOUBTFUL;
1306
			} else {
1307
				logger.error("PresenceTerm could not be translated to datawarehouse occurrence status id: " + presenceTerm.getLabel());
1308
			}
1309
		} else if (term.isInstanceOf(AbsenceTerm.class)) {
1310
			AbsenceTerm absenceTerm = CdmBase.deproxy(term, AbsenceTerm.class);
1311
			if (absenceTerm.equals(AbsenceTerm.ABSENT())) {
1312
				result = STATUS_ABSENT;
1313
			} else {
1314
				logger.error("AbsenceTerm could not be translated to datawarehouse occurrence status id: " + absenceTerm.getLabel());
1315
			}
1316
		}
1317
		return result;
1318
	}
1319
	
1320
	/**
1321
	 * Returns the AreaCache for a given Area.
1322
	 * @param area
1323
	 * @return
1324
	 */
1325
	public static String area2AreaCache(NamedArea area) {
1326
		if (area == null) {
1327
			return null;
1328
		} else if (area.isInstanceOf(TdwgArea.class)) {
1329
			NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
1330

    
1331
			// 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
1332
			if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_EAST_AEGEAN_ISLANDS; }
1333
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI")) { return STR_AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1334
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI-OO")) { return STR_AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1335
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1336
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB")) { return STR_AREA_ALBANIA; }
1337
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB-OO")) { return STR_AREA_ALBANIA; }
1338
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT")) { return STR_AREA_AUSTRIA_WITH_LIECHTENSTEIN; }
1339
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-AU")) { return STR_AREA_AUSTRIA; }
1340
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-LI")) { return STR_AREA_LIECHTENSTEIN; }
1341
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO")) { return STR_AREA_AZORES; }
1342
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO-OO")) { return STR_AREA_AZORES; }
1343
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_CORVO; }
1344
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FAIAL; }
1345
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_GRACIOSA; }
1346
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_SAO_JORGE; }
1347
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FLORES; }
1348
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_SAO_MIGUEL; }
1349
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_PICO; }
1350
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_SANTA_MARIA; }
1351
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_TERCEIRA; }
1352
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM")) { return STR_AREA_BELGIUM_WITH_LUXEMBOURG; }
1353
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-BE")) { return STR_AREA_BELGIUM; }
1354
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-LU")) { return STR_AREA_LUXEMBOURG; }
1355
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-BH")) { return STR_AREA_BOSNIA_HERZEGOVINA; }
1356
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL")) { return STR_AREA_BALEARES; }
1357
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL-OO")) { return STR_AREA_BALEARES; }
1358
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_IBIZA_WITH_FORMENTERA; }
1359
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_MALLORCA; }
1360
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_MENORCA; }
1361
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB")) { return STR_AREA_GREAT_BRITAIN; }
1362
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB-OO")) { return STR_AREA_GREAT_BRITAIN; }
1363
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT")) { return STR_AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION; }
1364
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL")) { return STR_AREA_BULGARIA; }
1365
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL-OO")) { return STR_AREA_BULGARIA; }
1366
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR")) { return STR_AREA_BELARUS; }
1367
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR-OO")) { return STR_AREA_BELARUS; }
1368
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY")) { return STR_AREA_CANARY_ISLANDS; }
1369
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY-OO")) { return STR_AREA_CANARY_ISLANDS; }
1370
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_GRAN_CANARIA; }
1371
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FUERTEVENTURA_WITH_LOBOS; }
1372
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_GOMERA; }
1373
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_HIERRO; }
1374
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_LANZAROTE_WITH_GRACIOSA; }
1375
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_LA_PALMA; }
1376
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_TENERIFE; }
1377
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MN")) { return STR_AREA_MONTENEGRO; }
1378
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR")) { return STR_AREA_CORSE; }
1379
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR-OO")) { return STR_AREA_CORSE; }
1380
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI")) { return STR_AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
1381
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI-OO")) { return STR_AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
1382
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-CZ")) { return STR_AREA_CZECH_REPUBLIC; }
1383
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-CR")) { return STR_AREA_CROATIA; }
1384
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP")) { return STR_AREA_CYPRUS; }
1385
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP-OO")) { return STR_AREA_CYPRUS; }
1386
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE")) { return STR_AREA_FORMER_CZECHOSLOVAKIA; }
1387
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN")) { return STR_AREA_DENMARK_WITH_BORNHOLM; }
1388
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN-OO")) { return STR_AREA_DENMARK_WITH_BORNHOLM; }
1389
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-ES")) { return STR_AREA_ESTONIA; }
1390
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR")) { return STR_AREA_FAROE_ISLANDS; }
1391
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR-OO")) { return STR_AREA_FAROE_ISLANDS; }
1392
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN")) { return STR_AREA_FINLAND_WITH_AHVENANMAA; }
1393
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN-OO")) { return STR_AREA_FINLAND_WITH_AHVENANMAA; }
1394
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA")) { return STR_AREA_FRANCE; }
1395
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-CI")) { return STR_AREA_CHANNEL_ISLANDS; }
1396
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-FR")) { return STR_AREA_FRENCH_MAINLAND; }
1397
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-MO")) { return STR_AREA_MONACO; }
1398
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER")) { return STR_AREA_GERMANY; }
1399
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER-OO")) { return STR_AREA_GERMANY; }
1400
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC")) { return STR_AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
1401
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC-OO")) { return STR_AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
1402
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE")) { return STR_AREA_IRELAND; }
1403
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-IR")) { return STR_AREA_REPUBLIC_OF_IRELAND; }
1404
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-NI")) { return STR_AREA_NORTHERN_IRELAND; }
1405
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI")) { return STR_AREA_SWITZERLAND; }
1406
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI-OO")) { return STR_AREA_SWITZERLAND; }
1407
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET")) { return STR_AREA_NETHERLANDS; }
1408
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET-OO")) { return STR_AREA_NETHERLANDS; }
1409
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA")) { return STR_AREA_SPAIN; }
1410
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-AN")) { return STR_AREA_ANDORRA; }
1411
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-GI")) { return STR_AREA_GIBRALTAR; }
1412
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-SP")) { return STR_AREA_KINGDOM_OF_SPAIN; }
1413
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN")) { return STR_AREA_HUNGARY; }
1414
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN-OO")) { return STR_AREA_HUNGARY; }
1415
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE")) { return STR_AREA_ICELAND; }
1416
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE-OO")) { return STR_AREA_ICELAND; }
1417
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA")) { return STR_AREA_ITALY; }
1418
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-IT")) { return STR_AREA_ITALIAN_MAINLAND; }
1419
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-SM")) { return STR_AREA_SAN_MARINO; }
1420
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG")) { return STR_AREA_FORMER_JUGOSLAVIA; }
1421
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LA")) { return STR_AREA_LATVIA; }
1422
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LI")) { return STR_AREA_LITHUANIA; }
1423
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR")) { return STR_AREA_PORTUGUESE_MAINLAND; }
1424
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR-OO")) { return STR_AREA_PORTUGUESE_MAINLAND; }
1425
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR")) { return STR_AREA_MADEIRA; }
1426
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR-OO")) { return STR_AREA_MADEIRA; }
1427
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_DESERTAS; }
1428
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_PORTO_SANTO; }
1429
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MA")) { return STR_AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA; }
1430
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-MO")) { return STR_AREA_MOLDOVA; }
1431
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR")) { return STR_AREA_NORWEGIAN_MAINLAND; }
1432
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR-OO")) { return STR_AREA_NORWEGIAN_MAINLAND; }
1433
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL")) { return STR_AREA_POLAND; }
1434
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL-OO")) { return STR_AREA_POLAND; }
1435
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return STR_AREA_THE_RUSSIAN_FEDERATION; }
1436
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB")) { return STR_AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
1437
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB-OO")) { return STR_AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
1438
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC")) { return STR_AREA_CENTRAL_EUROPEAN_RUSSIA; }
1439
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC-OO")) { return STR_AREA_CENTRAL_EUROPEAN_RUSSIA; }
1440
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE")) { return STR_AREA_EASTERN_EUROPEAN_RUSSIA; }
1441
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE-OO")) { return STR_AREA_EASTERN_EUROPEAN_RUSSIA; }
1442
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-KA")) { return STR_AREA_KALININGRAD; }
1443
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN")) { return STR_AREA_NORTHERN_EUROPEAN_RUSSIA; }
1444
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN-OO")) { return STR_AREA_NORTHERN_EUROPEAN_RUSSIA; }
1445
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW")) { return STR_AREA_NORTHWEST_EUROPEAN_RUSSIA; }
1446
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW-OO")) { return STR_AREA_NORTHWEST_EUROPEAN_RUSSIA; }
1447
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return STR_AREA_SOUTH_EUROPEAN_RUSSIA; }
1448
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS-OO")) { return STR_AREA_SOUTH_EUROPEAN_RUSSIA; }
1449
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM")) { return STR_AREA_ROMANIA; }
1450
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM-OO")) { return STR_AREA_ROMANIA; }
1451
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FORMER_USSR; }
1452
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_RUSSIA_BALTIC; }
1453
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC")) { return STR_AREA_RUSSIA_CENTRAL; }
1454
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_RUSSIA_SOUTHEAST; }
1455
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN")) { return STR_AREA_RUSSIA_NORTHERN; }
1456
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_RUSSIA_SOUTHWEST; }
1457
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR")) { return STR_AREA_SARDEGNA; }
1458
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR-OO")) { return STR_AREA_SARDEGNA; }
1459
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA")) { return STR_AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
1460
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA-OO")) { return STR_AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
1461
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL")) { return STR_AREA_SELVAGENS_ISLANDS; }
1462
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL-OO")) { return STR_AREA_SELVAGENS_ISLANDS; }
1463
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC")) { return STR_AREA_SICILY_WITH_MALTA; }
1464
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-MA")) { return STR_AREA_MALTA; }
1465
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-SI")) { return STR_AREA_SICILY; }
1466
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-SK")) { return STR_AREA_SLOVAKIA; }
1467
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SL")) { return STR_AREA_SLOVENIA; }
1468
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CS")) { return STR_AREA_SERBIA_WITH_MONTENEGRO; }
1469
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SE")) { return STR_AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
1470
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE")) { return STR_AREA_SWEDEN; }
1471
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE-OO")) { return STR_AREA_SWEDEN; }
1472
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE")) { return STR_AREA_EUROPEAN_TURKEY; }
1473
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE-OO")) { return STR_AREA_EUROPEAN_TURKEY; }
1474
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_UKRAINE_INCLUDING_CRIMEA; }
1475
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY")) { return STR_AREA_CRIMEA; }
1476
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY-OO")) { return STR_AREA_CRIMEA; }
1477
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-UK")) { return STR_AREA_UKRAINE; }
1478
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRE")) { return STR_AREA_GREEK_MAINLAND; }
1479
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-KRI")) { return STR_AREA_CRETE; }
1480
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-DOD")) { return STR_AREA_DODECANESE_ISLANDS; }
1481
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-CYC")) { return STR_AREA_CYCLADES_ISLANDS; }
1482
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-AEG")) { return STR_AREA_NORTH_AEGEAN_ISLANDS; }
1483
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-VC")) { return STR_AREA_VATICAN_CITY; }
1484
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_FRANZ_JOSEF_LAND; }
1485
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_NOVAYA_ZEMLYA; }
1486
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZ")) { return STR_AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1487
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AZ")) { return STR_AREA_AZERBAIJAN; }
1488
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-NA")) { return STR_AREA_NAKHICHEVAN; }
1489
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG")) { return STR_AREA_ALGERIA; }
1490
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG-OO")) { return STR_AREA_ALGERIA; }
1491
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AR")) { return STR_AREA_ARMENIA; }
1492
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("33")) { return STR_AREA_CAUCASUS_REGION; }
1493
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY")) { return STR_AREA_EGYPT; }
1494
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY-OO")) { return STR_AREA_EGYPT; }
1495
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_GEORGIA; }
1496
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL")) { return STR_AREA_ISRAEL_JORDAN; }
1497
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-IS")) { return STR_AREA_ISRAEL; }
1498
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-JO")) { return STR_AREA_JORDAN; }
1499
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-LB")) { return STR_AREA_LEBANON; }
1500
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBY-OO")) { return STR_AREA_LIBYA; }
1501
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS")) { return STR_AREA_LEBANON_SYRIA; }
1502
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MOR")) { return STR_AREA_MOROCCO; }
1503
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NCS")) { return STR_AREA_NORTH_CAUCASUS; }
1504
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN")) { return STR_AREA_SINAI; }
1505
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN-OO")) { return STR_AREA_SINAI; }
1506
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-SY")) { return STR_AREA_SYRIA; }
1507
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN")) { return STR_AREA_TUNISIA; }
1508
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN-OO")) { return STR_AREA_TUNISIA; }
1509
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_ASIATIC_TURKEY; }
1510
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_ASIATIC_TURKEY; }
1511
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUR")) { return STR_AREA_TURKEY; }
1512
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUR-OO")) { return STR_AREA_TURKEY; }
1513
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("20")) { return STR_AREA_NORTHERN_AFRICA; }
1514
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AFR")) { return STR_AREA_AFRO_TROPICAL_REGION; }
1515
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUS")) { return STR_AREA_AUSTRALIAN_REGION; }
1516
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return STR_AREA_EAST_PALAEARCTIC; }
1517
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEA")) { return STR_AREA_NEARCTIC_REGION; }
1518
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEO")) { return STR_AREA_NEOTROPICAL_REGION; }
1519
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NRE")) { return STR_AREA_NEAR_EAST; }
1520
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ORR")) { return STR_AREA_ORIENTAL_REGION; }
1521
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return STR_AREA_EUROPEAN_MARINE_WATERS; }
1522
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||
1523
					(namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return STR_AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
1524
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return STR_AREA_WHITE_SEA; }
1525
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return STR_AREA_NORTH_SEA; }
1526
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return STR_AREA_BALTIC_SEA; }
1527
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||
1528
					(namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return STR_AREA_BLACK_SEA; } // abbreviated label missing
1529
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return STR_AREA_BARENTS_SEA; }
1530
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
1531
					(namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return STR_AREA_CASPIAN_SEA; } // abbreviated label missing
1532
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return STR_AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1533
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return STR_AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1534
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return STR_AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
1535
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return STR_AREA_ENGLISH_CHANNEL; }
1536
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return STR_AREA_ADRIATIC_SEA; }
1537
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return STR_AREA_BISCAY_BAY; }
1538
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return STR_AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
1539
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return STR_AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
1540
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1541
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return STR_AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1542
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return STR_AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1543
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return STR_AREA_TIRRENO_SEA; }
1544
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return STR_AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
1545
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return STR_AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
1546
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return STR_AREA_IRISH_SEA; }
1547
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return STR_AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1548
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return STR_AREA_NORWEGIAN_SEA; }
1549
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return STR_AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
1550
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return STR_AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1551
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return STR_AREA_SKAGERRAK; }
1552
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return STR_AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1553
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return STR_AREA_WADDEN_SEA; }
1554
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return STR_AREA_BELT_SEA; }
1555
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return STR_AREA_MARMARA_SEA; }
1556
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return STR_AREA_SEA_OF_AZOV; }
1557
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return STR_AREA_AEGEAN_SEA; }
1558
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return STR_AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1559
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return STR_AREA_SOUTH_BALTIC_PROPER; }
1560
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return STR_AREA_BALTIC_PROPER; }
1561
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return STR_AREA_NORTH_BALTIC_PROPER; }
1562
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return STR_AREA_ARCHIPELAGO_SEA; }
1563
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return STR_AREA_BOTHNIAN_SEA; }
1564
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return STR_AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
1565
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return STR_AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
1566
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return STR_AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1567
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return STR_AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
1568
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return STR_AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
1569
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return STR_AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
1570
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return STR_AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1571
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return STR_AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1572
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return STR_AREA_BALEAR_SEA; }
1573
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return STR_AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
1574
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return STR_AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1575
			else {
1576
				logger.error("Unknown NamedArea Area: " + area.getTitleCache());
1577
				return null; // Actually the export has to stop here because AreaFk's are not allowed to be NULL.
1578
			}
1579
		}
1580
		return null; // Actually the export has to stop here because AreaFk's are not allowed to be NULL.
1581
		
1582
	}
1583
	
1584
	/**
1585
	 * Returns the AreaId for a given Area.
1586
	 * @param area
1587
	 * @return
1588
	 */
1589
	public static Integer area2AreaId(NamedArea area) {
1590
		if (area == null) {
1591
			return null;
1592
		} else if (area.isInstanceOf(TdwgArea.class)) {
1593
			NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
1594

    
1595
			// 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
1596
			if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_EAST_AEGEAN_ISLANDS; }
1597
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI")) { return AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1598
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EAI-OO")) { return AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1599
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1600
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB")) { return AREA_ALBANIA; }
1601
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALB-OO")) { return AREA_ALBANIA; }
1602
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT")) { return AREA_AUSTRIA_WITH_LIECHTENSTEIN; }
1603
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-AU")) { return AREA_AUSTRIA; }
1604
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUT-LI")) { return AREA_LIECHTENSTEIN; }
1605
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO")) { return AREA_AZORES; }
1606
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZO-OO")) { return AREA_AZORES; }
1607
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_CORVO; }
1608
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FAIAL; }
1609
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_GRACIOSA; }
1610
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_SAO_JORGE; }
1611
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FLORES; }
1612
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_SAO_MIGUEL; }
1613
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_PICO; }
1614
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_SANTA_MARIA; }
1615
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_TERCEIRA; }
1616
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM")) { return AREA_BELGIUM_WITH_LUXEMBOURG; }
1617
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-BE")) { return AREA_BELGIUM; }
1618
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BGM-LU")) { return AREA_LUXEMBOURG; }
1619
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-BH")) { return AREA_BOSNIA_HERZEGOVINA; }
1620
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL")) { return AREA_BALEARES; }
1621
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BAL-OO")) { return AREA_BALEARES; }
1622
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_IBIZA_WITH_FORMENTERA; }
1623
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_MALLORCA; }
1624
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_MENORCA; }
1625
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB")) { return AREA_GREAT_BRITAIN; }
1626
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRB-OO")) { return AREA_GREAT_BRITAIN; }
1627
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT")) { return AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION; }
1628
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL")) { return AREA_BULGARIA; }
1629
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BUL-OO")) { return AREA_BULGARIA; }
1630
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR")) { return AREA_BELARUS; }
1631
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLR-OO")) { return AREA_BELARUS; }
1632
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY")) { return AREA_CANARY_ISLANDS; }
1633
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CNY-OO")) { return AREA_CANARY_ISLANDS; }
1634
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_GRAN_CANARIA; }
1635
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FUERTEVENTURA_WITH_LOBOS; }
1636
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_GOMERA; }
1637
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_HIERRO; }
1638
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_LANZAROTE_WITH_GRACIOSA; }
1639
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_LA_PALMA; }
1640
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_TENERIFE; }
1641
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MN")) { return AREA_MONTENEGRO; }
1642
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR")) { return AREA_CORSE; }
1643
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("COR-OO")) { return AREA_CORSE; }
1644
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI")) { return AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
1645
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRI-OO")) { return AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
1646
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-CZ")) { return AREA_CZECH_REPUBLIC; }
1647
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-CR")) { return AREA_CROATIA; }
1648
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP")) { return AREA_CYPRUS; }
1649
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CYP-OO")) { return AREA_CYPRUS; }
1650
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE")) { return AREA_FORMER_CZECHOSLOVAKIA; }
1651
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN")) { return AREA_DENMARK_WITH_BORNHOLM; }
1652
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("DEN-OO")) { return AREA_DENMARK_WITH_BORNHOLM; }
1653
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-ES")) { return AREA_ESTONIA; }
1654
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR")) { return AREA_FAROE_ISLANDS; }
1655
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FOR-OO")) { return AREA_FAROE_ISLANDS; }
1656
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN")) { return AREA_FINLAND_WITH_AHVENANMAA; }
1657
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FIN-OO")) { return AREA_FINLAND_WITH_AHVENANMAA; }
1658
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA")) { return AREA_FRANCE; }
1659
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-CI")) { return AREA_CHANNEL_ISLANDS; }
1660
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-FR")) { return AREA_FRENCH_MAINLAND; }
1661
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("FRA-MO")) { return AREA_MONACO; }
1662
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER")) { return AREA_GERMANY; }
1663
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GER-OO")) { return AREA_GERMANY; }
1664
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC")) { return AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
1665
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRC-OO")) { return AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
1666
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE")) { return AREA_IRELAND; }
1667
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-IR")) { return AREA_REPUBLIC_OF_IRELAND; }
1668
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("IRE-NI")) { return AREA_NORTHERN_IRELAND; }
1669
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI")) { return AREA_SWITZERLAND; }
1670
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWI-OO")) { return AREA_SWITZERLAND; }
1671
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET")) { return AREA_NETHERLANDS; }
1672
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NET-OO")) { return AREA_NETHERLANDS; }
1673
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA")) { return AREA_SPAIN; }
1674
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-AN")) { return AREA_ANDORRA; }
1675
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-GI")) { return AREA_GIBRALTAR; }
1676
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SPA-SP")) { return AREA_KINGDOM_OF_SPAIN; }
1677
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN")) { return AREA_HUNGARY; }
1678
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("HUN-OO")) { return AREA_HUNGARY; }
1679
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE")) { return AREA_ICELAND; }
1680
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ICE-OO")) { return AREA_ICELAND; }
1681
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA")) { return AREA_ITALY; }
1682
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-IT")) { return AREA_ITALIAN_MAINLAND; }
1683
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-SM")) { return AREA_SAN_MARINO; }
1684
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG")) { return AREA_FORMER_JUGOSLAVIA; }
1685
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LA")) { return AREA_LATVIA; }
1686
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-LI")) { return AREA_LITHUANIA; }
1687
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR")) { return AREA_PORTUGUESE_MAINLAND; }
1688
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POR-OO")) { return AREA_PORTUGUESE_MAINLAND; }
1689
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR")) { return AREA_MADEIRA; }
1690
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MDR-OO")) { return AREA_MADEIRA; }
1691
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_DESERTAS; }
1692
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_PORTO_SANTO; }
1693
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-MA")) { return AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA; }
1694
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-MO")) { return AREA_MOLDOVA; }
1695
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR")) { return AREA_NORWEGIAN_MAINLAND; }
1696
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NOR-OO")) { return AREA_NORWEGIAN_MAINLAND; }
1697
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL")) { return AREA_POLAND; }
1698
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("POL-OO")) { return AREA_POLAND; }
1699
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return AREA_THE_RUSSIAN_FEDERATION; }
1700
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB")) { return AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
1701
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("WSB-OO")) { return AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
1702
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC")) { return AREA_CENTRAL_EUROPEAN_RUSSIA; }
1703
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC-OO")) { return AREA_CENTRAL_EUROPEAN_RUSSIA; }
1704
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE")) { return AREA_EASTERN_EUROPEAN_RUSSIA; }
1705
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUE-OO")) { return AREA_EASTERN_EUROPEAN_RUSSIA; }
1706
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLT-KA")) { return AREA_KALININGRAD; }
1707
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN")) { return AREA_NORTHERN_EUROPEAN_RUSSIA; }
1708
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN-OO")) { return AREA_NORTHERN_EUROPEAN_RUSSIA; }
1709
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW")) { return AREA_NORTHWEST_EUROPEAN_RUSSIA; }
1710
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUW-OO")) { return AREA_NORTHWEST_EUROPEAN_RUSSIA; }
1711
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS")) { return AREA_SOUTH_EUROPEAN_RUSSIA; }
1712
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUS-OO")) { return AREA_SOUTH_EUROPEAN_RUSSIA; }
1713
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM")) { return AREA_ROMANIA; }
1714
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ROM-OO")) { return AREA_ROMANIA; }
1715
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FORMER_USSR; }
1716
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_RUSSIA_BALTIC; }
1717
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUC")) { return AREA_RUSSIA_CENTRAL; }
1718
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_RUSSIA_SOUTHEAST; }
1719
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("RUN")) { return AREA_RUSSIA_NORTHERN; }
1720
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_RUSSIA_SOUTHWEST; }
1721
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR")) { return AREA_SARDEGNA; }
1722
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SAR-OO")) { return AREA_SARDEGNA; }
1723
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA")) { return AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
1724
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SVA-OO")) { return AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
1725
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL")) { return AREA_SELVAGENS_ISLANDS; }
1726
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SEL-OO")) { return AREA_SELVAGENS_ISLANDS; }
1727
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC")) { return AREA_SICILY_WITH_MALTA; }
1728
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-MA")) { return AREA_MALTA; }
1729
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIC-SI")) { return AREA_SICILY; }
1730
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CZE-SK")) { return AREA_SLOVAKIA; }
1731
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SL")) { return AREA_SLOVENIA; }
1732
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CS")) { return AREA_SERBIA_WITH_MONTENEGRO; }
1733
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("YUG-SE")) { return AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
1734
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE")) { return AREA_SWEDEN; }
1735
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SWE-OO")) { return AREA_SWEDEN; }
1736
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE")) { return AREA_EUROPEAN_TURKEY; }
1737
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUE-OO")) { return AREA_EUROPEAN_TURKEY; }
1738
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
1739
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY")) { return AREA_CRIMEA; }
1740
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("KRY-OO")) { return AREA_CRIMEA; }
1741
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("UKR-UK")) { return AREA_UKRAINE; }
1742
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GRE")) { return AREA_GREEK_MAINLAND; }
1743
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-KRI")) { return AREA_CRETE; }
1744
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-DOD")) { return AREA_DODECANESE_ISLANDS; }
1745
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-CYC")) { return AREA_CYCLADES_ISLANDS; }
1746
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("GR-AEG")) { return AREA_NORTH_AEGEAN_ISLANDS; }
1747
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ITA-VC")) { return AREA_VATICAN_CITY; }
1748
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_FRANZ_JOSEF_LAND; }
1749
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_NOVAYA_ZEMLYA; }
1750
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AZ")) { return AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1751
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AZ")) { return AREA_AZERBAIJAN; }
1752
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-NA")) { return AREA_NAKHICHEVAN; }
1753
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG")) { return AREA_ALGERIA; }
1754
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ALG-OO")) { return AREA_ALGERIA; }
1755
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TCS-AR")) { return AREA_ARMENIA; }
1756
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("33")) { return AREA_CAUCASUS_REGION; }
1757
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY")) { return AREA_EGYPT; }
1758
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("EGY-OO")) { return AREA_EGYPT; }
1759
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_GEORGIA; }
1760
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL")) { return AREA_ISRAEL_JORDAN; }
1761
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-IS")) { return AREA_ISRAEL; }
1762
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("PAL-JO")) { return AREA_JORDAN; }
1763
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-LB")) { return AREA_LEBANON; }
1764
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBY-OO")) { return AREA_LIBYA; }
1765
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS")) { return AREA_LEBANON_SYRIA; }
1766
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MOR")) { return AREA_MOROCCO; }
1767
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NCS")) { return AREA_NORTH_CAUCASUS; }
1768
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN")) { return AREA_SINAI; }
1769
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("SIN-OO")) { return AREA_SINAI; }
1770
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("LBS-SY")) { return AREA_SYRIA; }
1771
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN")) { return AREA_TUNISIA; }
1772
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUN-OO")) { return AREA_TUNISIA; }
1773
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_ASIATIC_TURKEY; }
1774
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_ASIATIC_TURKEY; }
1775
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUR")) { return AREA_TURKEY; }
1776
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TUR-OO")) { return AREA_TURKEY; }
1777
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("20")) { return AREA_NORTHERN_AFRICA; }
1778
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AFR")) { return AREA_AFRO_TROPICAL_REGION; }
1779
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("AUS")) { return AREA_AUSTRALIAN_REGION; }
1780
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("TODO")) { return AREA_EAST_PALAEARCTIC; }
1781
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEA")) { return AREA_NEARCTIC_REGION; }
1782
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NEO")) { return AREA_NEOTROPICAL_REGION; }
1783
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("NRE")) { return AREA_NEAR_EAST; }
1784
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("ORR")) { return AREA_ORIENTAL_REGION; }
1785
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return AREA_EUROPEAN_MARINE_WATERS; }
1786
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||
1787
					(namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
1788
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return AREA_WHITE_SEA; }
1789
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return AREA_NORTH_SEA; }
1790
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return AREA_BALTIC_SEA; }
1791
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||
1792
					(namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return AREA_BLACK_SEA; } // abbreviated label missing
1793
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return AREA_BARENTS_SEA; }
1794
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
1795
					(namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return AREA_CASPIAN_SEA; } // abbreviated label missing
1796
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1797
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1798
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
1799
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return AREA_ENGLISH_CHANNEL; }
1800
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return AREA_ADRIATIC_SEA; }
1801
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return AREA_BISCAY_BAY; }
1802
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
1803
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
1804
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1805
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1806
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1807
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return AREA_TIRRENO_SEA; }
1808
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
1809
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
1810
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return AREA_IRISH_SEA; }
1811
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1812
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return AREA_NORWEGIAN_SEA; }
1813
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
1814
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1815
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return AREA_SKAGERRAK; }
1816
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1817
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return AREA_WADDEN_SEA; }
1818
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return AREA_BELT_SEA; }
1819
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return AREA_MARMARA_SEA; }
1820
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return AREA_SEA_OF_AZOV; }
1821
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return AREA_AEGEAN_SEA; }
1822
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1823
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return AREA_SOUTH_BALTIC_PROPER; }
1824
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return AREA_BALTIC_PROPER; }
1825
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return AREA_NORTH_BALTIC_PROPER; }
1826
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return AREA_ARCHIPELAGO_SEA; }
1827
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return AREA_BOTHNIAN_SEA; }
1828
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
1829
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
1830
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1831
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
1832
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
1833
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
1834
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1835
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1836
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return AREA_BALEAR_SEA; }
1837
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
1838
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1839
			else {
1840
				logger.error("Unknown NamedArea Area: " + area.getTitleCache());
1841
			}
1842
		}
1843
		return null;
1844

    
1845
	}
1846

    
1847
	/**
1848
	 * Returns the PESI SourceUseId for a given CDM sourceUseId.
1849
	 * @param sourceUseId
1850
	 * @return
1851
	 */
1852
	public static Integer sourceUseIdSourceUseId(Integer sourceUseId) {
1853
		// TODO: CDM sourceUseId and PESI sourceUseId are equal for now.
1854
		Integer result = null;
1855
		switch (sourceUseId) {
1856
			case 3: return ADDITIONAL_SOURCE;
1857
			case 4: return SOURCE_OF_SYNONYMY;
1858
			case 8: return NOMENCLATURAL_REFERENCE;
1859
		}
1860
		return result;
1861
	}
1862
	
1863
	/**
1864
	 * Returns the SourceUseCache for a tiven sourceUseId.
1865
	 * @param sourceUseId
1866
	 * @return
1867
	 */
1868
	public static String sourceUseId2SourceUseCache(Integer sourceUseId) {
1869
		// TODO: CDM sourceUseId and PESI sourceUseId are equal for now.
1870
		String result = null;
1871
		switch (sourceUseId) {
1872
			case 3: return STR_ADDITIONAL_SOURCE;
1873
			case 4: return STR_SOURCE_OF_SYNONYMY;
1874
			case 8: return STR_NOMENCLATURAL_REFERENCE;
1875
		}
1876
		return result;
1877
	}
1878
	
1879
	/**
1880
	 * Returns the FossilStatusCache to a given Fossil.
1881
	 * @param fossil
1882
	 * @return
1883
	 */
1884
	public static String fossil2FossilStatusCache(Fossil fossil) {
1885
		String result = null;
1886
		return result;
1887
	}
1888

    
1889
	/**
1890
	 * Returns the FossilStatusId to a given Fossil.
1891
	 * @param fossil
1892
	 * @return
1893
	 */
1894
	public static Integer fossil2FossilStatusId(Fossil fossil) {
1895
		Integer result = null;
1896
		return result;
1897
	}
1898
	
1899
	/**
1900
	 * Returns the LanguageCache to a given Language.
1901
	 * @param language
1902
	 * @return
1903
	 */
1904
	public static String language2LanguageCache(Language language) {
1905
		if (language == null ) {
1906
			return null;
1907
		}
1908
		if (language.equals(Language.ALBANIAN())) {
1909
			return STR_LANGUAGE_ALBANIAN;
1910
		} else if (language.equals(Language.ARABIC())) {
1911
			return STR_LANGUAGE_ARABIC;
1912
		} else if (language.equals(Language.ARMENIAN())) {
1913
			return STR_LANGUAGE_ARMENIAN;
1914
		} else if (language.equals(Language.AZERBAIJANI())) {
1915
			return STR_LANGUAGE_AZERBAIJAN;
1916
		} else if (language.equals(Language.BELORUSSIAN())) {
1917
			return STR_LANGUAGE_BELARUSIAN;
1918
		} else if (language.equals(Language.BULGARIAN())) {
1919
			return STR_LANGUAGE_BULGARIAN;
1920
		} else if (language.equals(Language.CATALAN_VALENCIAN())) {
1921
			return STR_LANGUAGE_CATALAN;
1922
		} else if (language.equals(Language.CROATIAN())) {
1923
			return STR_LANGUAGE_CROAT;
1924
		} else if (language.equals(Language.CZECH())) {
1925
			return STR_LANGUAGE_CZECH;
1926
		} else if (language.equals(Language.DANISH())) {
1927
			return STR_LANGUAGE_DANISH;
1928
		} else if (language.equals(Language.DUTCH_MIDDLE())) {
1929
			return STR_LANGUAGE_DUTCH;
1930
		} else if (language.equals(Language.ENGLISH())) {
1931
			return STR_LANGUAGE_ENGLISH;
1932
//		} else if (language.equals(Language.)) {
1933
//			return STR_LANGUAGE_EUSKERA;
1934
		} else if (language.equals(Language.ESTONIAN())) {
1935
			return STR_LANGUAGE_ESTONIAN;
1936
		} else if (language.equals(Language.FINNISH())) {
1937
			return STR_LANGUAGE_FINNISH;
1938
		} else if (language.equals(Language.FRENCH())) {
1939
			return STR_LANGUAGE_FRENCH;
1940
		} else if (language.equals(Language.GEORGIAN())) {
1941
			return STR_LANGUAGE_GEORGIAN;
1942
		} else if (language.equals(Language.GERMAN())) {
1943
			return STR_LANGUAGE_GERMAN;
1944
		} else if (language.equals(Language.GREEK_MODERN())) {
1945
			return STR_LANGUAGE_GREEK;
1946
		} else if (language.equals(Language.HUNGARIAN())) {
1947
			return STR_LANGUAGE_HUNGARIAN;
1948
		} else if (language.equals(Language.ICELANDIC())) {
1949
			return STR_LANGUAGE_ICELANDIC;
1950
		} else if (language.equals(Language.IRISH())) {
1951
			return STR_LANGUAGE_IRISH_GAELIC;
1952
		} else if (language.equals(Language.HEBREW())) {
1953
			return STR_LANGUAGE_ISRAEL_HEBREW;
1954
		} else if (language.equals(Language.ITALIAN())) {
1955
			return STR_LANGUAGE_ITALIAN;
1956
		} else if (language.equals(Language.LATVIAN())) {
1957
			return STR_LANGUAGE_LATVIAN;
1958
		} else if (language.equals(Language.LITHUANIAN())) {
1959
			return STR_LANGUAGE_LITHUANIAN;
1960
		} else if (language.equals(Language.MACEDONIAN())) {
1961
			return STR_LANGUAGE_MACEDONIAN;
1962
		} else if (language.equals(Language.MALTESE())) {
1963
			return STR_LANGUAGE_MALTESE;
1964
		} else if (language.equals(Language.MOLDAVIAN())) {
1965
			return STR_LANGUAGE_MOLDOVIAN;
1966
		} else if (language.equals(Language.NORWEGIAN())) {
1967
			return STR_LANGUAGE_NORWEGIAN;
1968
		} else if (language.equals(Language.POLISH())) {
1969
			return STR_LANGUAGE_POLISH;
1970
		} else if (language.equals(Language.PORTUGUESE())) {
1971
			return STR_LANGUAGE_PORTUGUESE;
1972
		} else if (language.equals(Language.ROMANIAN())) {
1973
			return STR_LANGUAGE_ROUMANIAN;
1974
		} else if (language.equals(Language.RUSSIAN())) {
1975
			return STR_LANGUAGE_RUSSIAN;
1976
//		} else if (language.equals(Language.)) {
1977
//			return STR_LANGUAGE_RUSSIAN_CAUCASIAN;
1978
//		} else if (language.equals(Language.)) {
1979
//			return STR_LANGUAGE_RUSSIAN_ALTAIC_KALMYK_OIRAT;
1980
//		} else if (language.equals(Language.)) {
1981
//			return STR_LANGUAGE_RUSSIAN_ALTAIC_KARACHAY_BALKAR;
1982
//		} else if (language.equals(Language.)) {
1983
//			return STR_LANGUAGE_RUSSIAN_ALTAIC_KUMYK;
1984
//		} else if (language.equals(Language.)) {
1985
//			return STR_LANGUAGE_RUSSIAN_ALTAIC_NOGAI;
1986
//		} else if (language.equals(Language.)) {
1987
//			return STR_LANGUAGE_RUSSIAN_ALTAIC_NORTH_AZERBAIJANI;
1988
//		} else if (language.equals(Language.)) {
1989
//			return STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_RUSSIAN;
1990
//		} else if (language.equals(Language.)) {
1991
//			return STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_KALMYK_OIRAT;
1992
//		} else if (language.equals(Language.)) {
1993
//			return STR_LANGUAGE_RUSSIAN_INDO_EUROPEAN_OSETIN;
1994
//		} else if (language.equals(Language.)) {
1995
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_ABAZA;
1996
//		} else if (language.equals(Language.)) {
1997
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_ADYGHE;
1998
//		} else if (language.equals(Language.)) {
1999
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_CHECHEN;
2000
//		} else if (language.equals(Language.)) {
2001
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_KABARDIAN;
2002
//		} else if (language.equals(Language.)) {
2003
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_LAK;
2004
//		} else if (language.equals(Language.)) {
2005
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_AVAR;
2006
//		} else if (language.equals(Language.)) {
2007
//			return STR_LANGUAGE_RUSSIAN_NORTH_CAUCASIAN_IN;
2008
//		} else if (language.equals(Language.)) {
2009
//			return STR_LANGUAGE_RUSSIAN_URALIC_CHUVASH;
2010
//		} else if (language.equals(Language.)) {
2011
//			return STR_LANGUAGE_RUSSIAN_URALIC_UDMURT;
2012
		} else if (language.equals(Language.SERBIAN())) {
2013
			return STR_LANGUAGE_SERBIAN;
2014
		} else if (language.equals(Language.SLOVAK())) {
2015
			return STR_LANGUAGE_SLOVAK;
2016
		} else if (language.equals(Language.SLOVENIAN())) {
2017
			return STR_LANGUAGE_SLOVENE;
2018
		} else if (language.equals(Language.SPANISH_CATALAN())) {
2019
			return STR_LANGUAGE_SPANISH_CASTILLIAN;
2020
		} else if (language.equals(Language.SWEDISH())) {
2021
			return STR_LANGUAGE_SWEDISH;
2022
		} else if (language.equals(Language.TURKISH())) {
2023
			return STR_LANGUAGE_TURKISH;
2024
		} else if (language.equals(Language.UKRAINIAN())) {
2025
			return STR_LANGUAGE_UKRAINE;
2026
		} else if (language.equals(Language.WELSH())) {
2027
			return STR_LANGUAGE_WELSH;
2028
		} else if (language.equals(Language.CORSICAN())) {
2029
			return STR_LANGUAGE_CORSICAN;
2030
		} else {
2031
			logger.debug("Unknown Language: " + language.getTitleCache());
2032
			return null;
2033
		}
2034
	}
2035
	
2036
	/**
2037
	 * Returns the identifier of the given Language.
2038
	 * @param language
2039
	 * @return
2040
	 */
2041
	public static Integer language2LanguageId(Language language) {
2042
		if (language == null ) {
2043
			return null;
2044
		}
2045
		if (language.equals(Language.ALBANIAN())) {
2046
			return Language_Albanian;
2047
		} else if (language.equals(Language.ARABIC())) {
2048
			return Language_Arabic;
2049
		} else if (language.equals(Language.ARMENIAN())) {
2050
			return Language_Armenian;
2051
		} else if (language.equals(Language.AZERBAIJANI())) {
2052
			return Language_Azerbaijan;
2053
		} else if (language.equals(Language.BELORUSSIAN())) {
2054
			return Language_Belarusian;
2055
		} else if (language.equals(Language.BULGARIAN())) {
2056
			return Language_Bulgarian;
2057
		} else if (language.equals(Language.CATALAN_VALENCIAN())) {
2058
			return Language_Catalan;
2059
		} else if (language.equals(Language.CROATIAN())) {
2060
			return Language_Croat;
2061
		} else if (language.equals(Language.CZECH())) {
2062
			return Language_Czech;
2063
		} else if (language.equals(Language.DANISH())) {
2064
			return Language_Danish;
2065
		} else if (language.equals(Language.DUTCH_MIDDLE())) {
2066
			return Language_Dutch;
2067
		} else if (language.equals(Language.ENGLISH())) {
2068
			return Language_English;
2069
//		} else if (language.equals(Language.)) {
2070
//			return Language_Euskera;
2071
		} else if (language.equals(Language.ESTONIAN())) {
2072
			return Language_Estonian;
2073
		} else if (language.equals(Language.FINNISH())) {
2074
			return Language_Finnish;
2075
		} else if (language.equals(Language.FRENCH())) {
2076
			return Language_French;
2077
		} else if (language.equals(Language.GEORGIAN())) {
2078
			return Language_Georgian;
2079
		} else if (language.equals(Language.GERMAN())) {
2080
			return Language_German;
2081
		} else if (language.equals(Language.GREEK_MODERN())) {
2082
			return Language_Greek;
2083
		} else if (language.equals(Language.HUNGARIAN())) {
2084
			return Language_Hungarian;
2085
		} else if (language.equals(Language.ICELANDIC())) {
2086
			return Language_Icelandic;
2087
		} else if (language.equals(Language.IRISH())) {
2088
			return Language_Irish_Gaelic;
2089
		} else if (language.equals(Language.HEBREW())) {
2090
			return Language_Israel_Hebrew;
2091
		} else if (language.equals(Language.ITALIAN())) {
2092
			return Language_Italian;
2093
		} else if (language.equals(Language.LATVIAN())) {
2094
			return Language_Latvian;
2095
		} else if (language.equals(Language.LITHUANIAN())) {
2096
			return Language_Lithuanian;
2097
		} else if (language.equals(Language.MACEDONIAN())) {
2098
			return Language_Macedonian;
2099
		} else if (language.equals(Language.MALTESE())) {
2100
			return Language_Maltese;
2101
		} else if (language.equals(Language.MOLDAVIAN())) {
2102
			return Language_Moldovian;
2103
		} else if (language.equals(Language.NORWEGIAN())) {
2104
			return Language_Norwegian;
2105
		} else if (language.equals(Language.POLISH())) {
2106
			return Language_Polish;
2107
		} else if (language.equals(Language.PORTUGUESE())) {
2108
			return Language_Portuguese;
2109
		} else if (language.equals(Language.ROMANIAN())) {
2110
			return Language_Roumanian;
2111
		} else if (language.equals(Language.RUSSIAN())) {
2112
			return Language_Russian;
2113
//		} else if (language.equals(Language.)) {
2114
//			return Language_Russian_Caucasian;
2115
//		} else if (language.equals(Language.)) {
2116
//			return Language_Russian_Altaic_kalmyk_oirat;
2117
//		} else if (language.equals(Language.)) {
2118
//			return Language_Russian_Altaic_karachay_balkar;
2119
//		} else if (language.equals(Language.)) {
2120
//			return Language_Russian_Altaic_kumyk;
2121
//		} else if (language.equals(Language.)) {
2122
//			return Language_Russian_Altaic_nogai;
2123
//		} else if (language.equals(Language.)) {
2124
//			return Language_Russian_Altaic_north_azerbaijani;
2125
//		} else if (language.equals(Language.)) {
2126
//			return Language_Russian_Indo_european_russian;
2127
//		} else if (language.equals(Language.)) {
2128
//			return Language_Russian_Indo_european_kalmyk_oirat;
2129
//		} else if (language.equals(Language.)) {
2130
//			return Language_Russian_Indo_european_osetin;
2131
//		} else if (language.equals(Language.)) {
2132
//			return Language_Russian_North_caucasian_abaza;
2133
//		} else if (language.equals(Language.)) {
2134
//			return Language_Russian_North_caucasian_adyghe;
2135
//		} else if (language.equals(Language.)) {
2136
//			return Language_Russian_North_caucasian_chechen;
2137
//		} else if (language.equals(Language.)) {
2138
//			return Language_Russian_North_caucasian_kabardian;
2139
//		} else if (language.equals(Language.)) {
2140
//			return Language_Russian_North_caucasian_lak;
2141
//		} else if (language.equals(Language.)) {
2142
//			return Language_Russian_North_caucasian_avar;
2143
//		} else if (language.equals(Language.)) {
2144
//			return Language_Russian_North_caucasian_in;
2145
//		} else if (language.equals(Language.)) {
2146
//			return Language_Russian_Uralic_chuvash;
2147
//		} else if (language.equals(Language.)) {
2148
//			return Language_Russian_Uralic_udmurt;
2149
		} else if (language.equals(Language.SERBIAN())) {
2150
			return Language_Serbian;
2151
		} else if (language.equals(Language.SLOVAK())) {
2152
			return Language_Slovak;
2153
		} else if (language.equals(Language.SLOVENIAN())) {
2154
			return Language_Slovene;
2155
		} else if (language.equals(Language.SPANISH_CATALAN())) {
2156
			return Language_Spanish_Castillian;
2157
		} else if (language.equals(Language.SWEDISH())) {
2158
			return Language_Swedish;
2159
		} else if (language.equals(Language.TURKISH())) {
2160
			return Language_Turkish;
2161
		} else if (language.equals(Language.UKRAINIAN())) {
2162
			return Language_Ukraine;
2163
		} else if (language.equals(Language.WELSH())) {
2164
			return Language_Welsh;
2165
		} else if (language.equals(Language.CORSICAN())) {
2166
			return Language_Corsican;
2167
		} else {
2168
			logger.debug("Unknown Language: " + language.getTitleCache());
2169
			return null;
2170
		}
2171
	}
2172
	
2173
	/**
2174
	 * Returns the NodeCategoryCache for a given TextData.
2175
	 * @param feature
2176
	 * @return
2177
	 */
2178
	public static String textData2NodeCategoryCache(Feature feature) {
2179
		if (feature == null) {
2180
			return null;
2181
		}
2182
		
2183
		if (feature.equals(Feature.DESCRIPTION())) {
2184
			return NoteCategory_STR_description;
2185
		} else if (feature.equals(Feature.ECOLOGY())) {
2186
			return NoteCategory_STR_ecology;
2187
		} else if (feature.equals(Feature.PHENOLOGY())) {
2188
			return NoteCategory_STR_phenology;
2189
		} else if (feature.equals(Feature.COMMON_NAME())) {
2190
			return NoteCategory_STR_Common_names;
2191
		} else if (feature.equals(Feature.OCCURRENCE())) {
2192
			return NoteCategory_STR_Occurrence;
2193
		} else if (feature.getUuid().equals(ErmsTransformer.uuidRemark)) {
2194
			return NoteCategory_STR_Remark;
2195
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAdditionalinformation)) {
2196
			return NoteCategory_STR_Additional_information;
2197
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSpelling)) {
2198
			return NoteCategory_STR_Spelling;
2199
		} else if (feature.getUuid().equals(ErmsTransformer.uuidDateofPublication)) {
2200
			return NoteCategory_STR_Date_of_publication;
2201
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSystematics)) {
2202
			return NoteCategory_STR_Systematics;
2203
		} else if (feature.getUuid().equals(ErmsTransformer.uuidClassification)) {
2204
			return NoteCategory_STR_Classification;
2205
		} else if (feature.getUuid().equals(ErmsTransformer.uuidEnvironment)) {
2206
			return NoteCategory_STR_Environment;
2207
		} else if (feature.getUuid().equals(ErmsTransformer.uuidHabitat)) {
2208
			return NoteCategory_STR_Habitat;
2209
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAuthority)) {
2210
			return NoteCategory_STR_Authority;
2211
		} else if (feature.getUuid().equals(ErmsTransformer.uuidMorphology)) {
2212
			return NoteCategory_STR_Morphology;
2213
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemarks)) {
2214
			return NoteCategory_STR_Taxonomic_Remarks;
2215
		} else if (feature.getUuid().equals(ErmsTransformer.uuidNote)){
2216
			return NoteCategory_STR_Note;
2217
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomy)) {
2218
			return NoteCategory_STR_Taxonomy;
2219
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicstatus)) {
2220
			return NoteCategory_STR_Taxonomic_status;
2221
		} else if (feature.getUuid().equals(ErmsTransformer.uuidStatus)){
2222
			return NoteCategory_STR_Status;
2223
		} else if (feature.getUuid().equals(ErmsTransformer.uuidRank)) {
2224
			return NoteCategory_STR_Rank;
2225
		} else if (feature.getUuid().equals(ErmsTransformer.uuidHomonymy)) {
2226
			return NoteCategory_STR_Homonymy;
2227
		} else if (feature.getUuid().equals(ErmsTransformer.uuidNomenclature)) {
2228
			return NoteCategory_STR_Nomenclature;
2229
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemark)) {
2230
			return NoteCategory_STR_Taxonomic_Remark;
2231
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAcknowledgments)){
2232
			return NoteCategory_STR_Acknowledgments;
2233
		} else if (feature.getUuid().equals(ErmsTransformer.uuidOriginalpublication)) {
2234
			return NoteCategory_STR_Original_publication;
2235
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTypelocality)) {
2236
			return NoteCategory_STR_Type_locality;
2237
		} else if (feature.getUuid().equals(ErmsTransformer.uuidValidity)) {
2238
			return NoteCategory_STR_Validity;
2239
		} else if (feature.getUuid().equals(ErmsTransformer.uuidIdentification)) {
2240
			return NoteCategory_STR_Identification;
2241
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSynonymy)) {
2242
			return NoteCategory_STR_Synonymy;
2243
//		} else if (feature.equals(Feature.CITATION())) {
2244
//			return;
2245
			
2246
			// TODO: Unknown NodeCategories
2247
//			NoteCategory_STR_general_distribution_euromed = 10;
2248
//			NoteCategory_STR_general_distribution_world = 11;
2249
//			NoteCategory_STR_Common_names = 12;
2250
//			NoteCategory_STR_Maps =14;
2251
//			NoteCategory_STR_Link_to_maps = 20;
2252
//			NoteCategory_STR_Link_to_images = 21;
2253
//			NoteCategory_STR_Link_to_taxonomy = 22;
2254
//			NoteCategory_STR_Link_to_general_information = 23;
2255
//			NoteCategory_STR_undefined_link = 24;
2256
//			NoteCategory_STR_Editor_Braces = 249;
2257
//			NoteCategory_STR_Editor_Brackets = 250;
2258
//			NoteCategory_STR_Editor_Parenthesis = 251;
2259
//			NoteCategory_STR_Inedited = 252;
2260
//			NoteCategory_STR_Comments_on_editing_process = 253;
2261
//			NoteCategory_STR_Publication_date = 254;
2262
//			NoteCategory_STR_Distribution = 278;
2263
//			NoteCategory_STR_Biology = 281;
2264
//			NoteCategory_STR_Diagnosis	= 282;
2265
//			NoteCategory_STR_Host = 283;
2266
		
2267
 		} else {
2268
			logger.debug("Unknown Feature.");
2269
			return null;
2270
		}
2271
	}
2272

    
2273
	/**
2274
	 * Returns the NodeCategoryFk for a given TextData.
2275
	 * @param feature
2276
	 * @return
2277
	 */
2278
	public static Integer textData2NodeCategoryFk(Feature feature) {
2279
		if (feature == null) {
2280
			return null;
2281
		}
2282

    
2283
		if (feature.equals(Feature.DESCRIPTION())) {
2284
			return NoteCategory_description;
2285
		} else if (feature.equals(Feature.ECOLOGY())) {
2286
			return NoteCategory_ecology;
2287
		} else if (feature.equals(Feature.PHENOLOGY())) {
2288
			return NoteCategory_phenology;
2289
		} else if (feature.equals(Feature.COMMON_NAME())) {
2290
			return NoteCategory_Common_names;
2291
		} else if (feature.equals(Feature.OCCURRENCE())) {
2292
			return NoteCategory_Occurrence;
2293
		} else if (feature.getUuid().equals(ErmsTransformer.uuidRemark)) {
2294
			return NoteCategory_Remark;
2295
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAdditionalinformation)) {
2296
			return NoteCategory_Additional_information;
2297
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSpelling)) {
2298
			return NoteCategory_Spelling;
2299
		} else if (feature.getUuid().equals(ErmsTransformer.uuidDateofPublication)) {
2300
			return NoteCategory_Date_of_publication;
2301
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSystematics)) {
2302
			return NoteCategory_Systematics;
2303
		} else if (feature.getUuid().equals(ErmsTransformer.uuidClassification)) {
2304
			return NoteCategory_Classification;
2305
		} else if (feature.getUuid().equals(ErmsTransformer.uuidEnvironment)) {
2306
			return NoteCategory_Environment;
2307
		} else if (feature.getUuid().equals(ErmsTransformer.uuidHabitat)) {
2308
			return NoteCategory_Habitat;
2309
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAuthority)) {
2310
			return NoteCategory_Authority;
2311
		} else if (feature.getUuid().equals(ErmsTransformer.uuidMorphology)) {
2312
			return NoteCategory_Morphology;
2313
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemarks)) {
2314
			return NoteCategory_Taxonomic_Remarks;
2315
		} else if (feature.getUuid().equals(ErmsTransformer.uuidNote)){
2316
			return NoteCategory_Note;
2317
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomy)) {
2318
			return NoteCategory_Taxonomy;
2319
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicstatus)) {
2320
			return NoteCategory_Taxonomic_status;
2321
		} else if (feature.getUuid().equals(ErmsTransformer.uuidStatus)){
2322
			return NoteCategory_Status;
2323
		} else if (feature.getUuid().equals(ErmsTransformer.uuidRank)) {
2324
			return NoteCategory_Rank;
2325
		} else if (feature.getUuid().equals(ErmsTransformer.uuidHomonymy)) {
2326
			return NoteCategory_Homonymy;
2327
		} else if (feature.getUuid().equals(ErmsTransformer.uuidNomenclature)) {
2328
			return NoteCategory_Nomenclature;
2329
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemark)) {
2330
			return NoteCategory_Taxonomic_Remark;
2331
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAcknowledgments)){
2332
			return NoteCategory_Acknowledgments;
2333
		} else if (feature.getUuid().equals(ErmsTransformer.uuidOriginalpublication)) {
2334
			return NoteCategory_Original_publication;
2335
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTypelocality)) {
2336
			return NoteCategory_Type_locality;
2337
		} else if (feature.getUuid().equals(ErmsTransformer.uuidValidity)) {
2338
			return NoteCategory_Validity;
2339
		} else if (feature.getUuid().equals(ErmsTransformer.uuidIdentification)) {
2340
			return NoteCategory_Identification;
2341
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSynonymy)) {
2342
			return NoteCategory_Synonymy;
2343
//		} else if (feature.equals(Feature.CITATION())) {
2344
//			return;
2345
			
2346
			// TODO: Unknown NodeCategories
2347
//			NoteCategory_general_distribution_euromed = 10;
2348
//			NoteCategory_general_distribution_world = 11;
2349
//			NoteCategory_Common_names = 12;
2350
//			NoteCategory_Maps =14;
2351
//			NoteCategory_Link_to_maps = 20;
2352
//			NoteCategory_Link_to_images = 21;
2353
//			NoteCategory_Link_to_taxonomy = 22;
2354
//			NoteCategory_Link_to_general_information = 23;
2355
//			NoteCategory_undefined_link = 24;
2356
//			NoteCategory_Editor_Braces = 249;
2357
//			NoteCategory_Editor_Brackets = 250;
2358
//			NoteCategory_Editor_Parenthesis = 251;
2359
//			NoteCategory_Inedited = 252;
2360
//			NoteCategory_Comments_on_editing_process = 253;
2361
//			NoteCategory_Publication_date = 254;
2362
//			NoteCategory_Distribution = 278;
2363
//			NoteCategory_Biology = 281;
2364
//			NoteCategory_Diagnosis	= 282;
2365
//			NoteCategory_Host = 283;
2366

    
2367
		}else{
2368
			logger.warn("Unknown Feature.");
2369
			return null;
2370
		}
2371
	}
2372

    
2373
	/**
2374
	 * Returns the string representation for a given rank.
2375
	 * @param rank
2376
	 * @param pesiKingdomId
2377
	 * @return
2378
	 */
2379
	public static String rank2RankCache(Rank rank, Integer pesiKingdomId) {
2380
		String result = null;
2381
		if (rank == null) {
2382
			return null;
2383
		}
2384
		
2385
		// We differentiate between Animalia and Plantae only for now.
2386
		if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_ANIMALIA) {
2387
			if (rank.equals(Rank.KINGDOM())) {
2388
				result = Animalia_STR_Kingdom;
2389
			} else if (rank.equals(Rank.SUBKINGDOM())) {
2390
				result = Animalia_STR_Subkingdom;
2391
			} else if (rank.equals(Rank.SUPERPHYLUM())) {
2392
				result = Animalia_STR_Superphylum;
2393
			} else if (rank.equals(Rank.PHYLUM())) {
2394
				result = Animalia_STR_Phylum;
2395
			} else if (rank.equals(Rank.SUBPHYLUM())) {
2396
				result = Animalia_STR_Subphylum;
2397
			} else if (rank.equals(Rank.INFRAPHYLUM())) {
2398
				result = Animalia_STR_Infraphylum;
2399
			} else if (rank.equals(Rank.SUPERCLASS())) {
2400
				result = Animalia_STR_Superclass;
2401
			} else if (rank.equals(Rank.CLASS())) {
2402
				result = Animalia_STR_Class;
2403
			} else if (rank.equals(Rank.SUBCLASS())) {
2404
				result = Animalia_STR_Subclass;
2405
			} else if (rank.equals(Rank.INFRACLASS())) {
2406
				result = Animalia_STR_Infraclass;
2407
			} else if (rank.equals(Rank.SUPERORDER())) {
2408
				result = Animalia_STR_Superorder;
2409
			} else if (rank.equals(Rank.ORDER())) {
2410
				result = Animalia_STR_Order;
2411
			} else if (rank.equals(Rank.SUBORDER())) {
2412
				result = Animalia_STR_Suborder;
2413
			} else if (rank.equals(Rank.INFRAORDER())) {
2414
				result = Animalia_STR_Infraorder;
2415
			} else if (rank.equals(Rank.SECTION_ZOOLOGY())) {
2416
				result = Animalia_STR_Section;
2417
			} else if (rank.equals(Rank.SUBSECTION_ZOOLOGY())) {
2418
				result = Animalia_STR_Subsection;
2419
			} else if (rank.equals(Rank.SUPERFAMILY())) {
2420
				result = Animalia_STR_Superfamily;
2421
			} else if (rank.equals(Rank.FAMILY())) {
2422
				result = Animalia_STR_Family;
2423
			} else if (rank.equals(Rank.SUBFAMILY())) {
2424
				result = Animalia_STR_Subfamily;
2425
			} else if (rank.equals(Rank.TRIBE())) {
2426
				result = Animalia_STR_Tribe;
2427
			} else if (rank.equals(Rank.SUBTRIBE())) {
2428
				result = Animalia_STR_Subtribe;
2429
			} else if (rank.equals(Rank.GENUS())) {
2430
				result = Animalia_STR_Genus;
2431
			} else if (rank.equals(Rank.SUBGENUS())) {
2432
				result = Animalia_STR_Subgenus;
2433
			} else if (rank.equals(Rank.SPECIES())) {
2434
				result = Animalia_STR_Species;
2435
			} else if (rank.equals(Rank.SUBSPECIES())) {
2436
				result = Animalia_STR_Subspecies;
2437
//			} else if (rank.equals(Rank.)) { // not yet specified
2438
//				result = Animalia_STR_Natio;
2439
			} else if (rank.equals(Rank.VARIETY())) {
2440
				result = Animalia_STR_Variety;
2441
			} else if (rank.equals(Rank.SUBVARIETY())) {
2442
				result = Animalia_STR_Subvariety;
2443
			} else if (rank.equals(Rank.FORM())) {
2444
				result = Animalia_STR_Forma;
2445
			} else {
2446
				//TODO Exception
2447
				logger.warn("Rank for Kingdom Animalia not yet supported in CDM: "+ rank.getLabel());
2448
				return null;
2449
			}
2450
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_PLANTAE) {
2451
			if (rank.equals(Rank.KINGDOM())) {
2452
				result = Plantae_STR_Kingdom;
2453
			} else if (rank.equals(Rank.SUBKINGDOM())) {
2454
				result = Plantae_STR_Subkingdom;
2455
			} else if (rank.equals(Rank.DIVISION())) {
2456
				result = Plantae_STR_Division;
2457
			} else if (rank.equals(Rank.SUBDIVISION())) {
2458
				result = Plantae_STR_Subdivision;
2459
			} else if (rank.equals(Rank.CLASS())) {
2460
				result = Plantae_STR_Class;
2461
			} else if (rank.equals(Rank.SUBCLASS())) {
2462
				result = Plantae_STR_Subclass;
2463
			} else if (rank.equals(Rank.ORDER())) {
2464
				result = Plantae_STR_Order;
2465
			} else if (rank.equals(Rank.SUBORDER())) {
2466
				result = Plantae_STR_Suborder;
2467
			} else if (rank.equals(Rank.FAMILY())) {
2468
				result = Plantae_STR_Family;
2469
			} else if (rank.equals(Rank.SUBFAMILY())) {
2470
				result = Plantae_STR_Subfamily;
2471
			} else if (rank.equals(Rank.TRIBE())) {
2472
				result = Plantae_STR_Tribe;
2473
			} else if (rank.equals(Rank.SUBTRIBE())) {
2474
				result = Plantae_STR_Subtribe;
2475
			} else if (rank.equals(Rank.GENUS())) {
2476
				result = Plantae_STR_Genus;
2477
			} else if (rank.equals(Rank.SUBGENUS())) {
2478
				result = Plantae_STR_Subgenus;
2479
			} else if (rank.equals(Rank.SECTION_BOTANY())) {
2480
				result = Plantae_STR_Section;
2481
			} else if (rank.equals(Rank.SUBSECTION_BOTANY())) {
2482
				result = Plantae_STR_Subsection;
2483
			} else if (rank.equals(Rank.SERIES())) {
2484
				result = Plantae_STR_Series;
2485
			} else if (rank.equals(Rank.SUBSERIES())) {
2486
				result = Plantae_STR_Subseries;
2487
//			} else if (rank.equals(Rank.)) { // not yet specified
2488
//				result = Plantae_STR_Aggregate;
2489
//			} else if (rank.equals(Rank.)) { // not yet specified
2490
//				result = Plantae_STR_Coll_Species;
2491
			} else if (rank.equals(Rank.SPECIES())) {
2492
				result = Plantae_STR_Species;
2493
			} else if (rank.equals(Rank.SUBSPECIES())) {
2494
				result = Plantae_STR_Subspecies;
2495
//			} else if (rank.equals(Rank.)) { // not yet specified
2496
//				result = Plantae_STR_Proles;
2497
//			} else if (rank.equals(Rank.)) { // not yet specified
2498
//				result = Plantae_STR_Race;
2499
			} else if (rank.equals(Rank.CONVAR())) {
2500
				result = Plantae_STR_Convarietas;
2501
			} else if (rank.equals(Rank.VARIETY())) {
2502
				result = Plantae_STR_Variety;
2503
			} else if (rank.equals(Rank.SUBVARIETY())) {
2504
				result = Plantae_STR_Subvariety;
2505
			} else if (rank.equals(Rank.FORM())) {
2506
				result = Plantae_STR_Forma;
2507
			} else if (rank.equals(Rank.SUBFORM())) {
2508
				result = Plantae_STR_Subforma;
2509
//			} else if (rank.equals(Rank.)) { // not yet specified
2510
//				result = Plantae_STR_Forma_spec;
2511
//			} else if (rank.equals(Rank.)) { // not yet specified
2512
//				result = Plantae_STR_Taxa_infragen;
2513
//			} else if (rank.equals(Rank.)) { // not yet specified
2514
//				result = Plantae_STR_Taxa_infraspec;
2515
			} else {
2516
				//TODO Exception
2517
				logger.warn("Rank for Kingdom Plantae not yet supported in CDM: "+ rank.getLabel());
2518
				return null;
2519
			}
2520
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_BACTERIA) {
2521
			if (rank.equals(Rank.KINGDOM())) { result = Bacteria_STR_Kingdom; }
2522
			else if (rank.equals(Rank.SUBKINGDOM())) { result = Bacteria_STR_Subkingdom; }
2523
			else if (rank.equals(Rank.PHYLUM())) { result = Bacteria_STR_Phylum; }
2524
			else if (rank.equals(Rank.SUBPHYLUM())) { result = Bacteria_STR_Subphylum; }
2525
			else if (rank.equals(Rank.SUPERCLASS())) { result = Bacteria_STR_Superclass; }
2526
			else if (rank.equals(Rank.CLASS())) { result = Bacteria_STR_Class; }
2527
			else if (rank.equals(Rank.SUBCLASS())) { result = Bacteria_STR_Subclass; }
2528
			else if (rank.equals(Rank.INFRACLASS())) { result = Bacteria_STR_Infraclass; }
2529
			else if (rank.equals(Rank.SUPERORDER())) { result = Bacteria_STR_Superorder; }
2530
			else if (rank.equals(Rank.ORDER())) { result = Bacteria_STR_Order; }
2531
			else if (rank.equals(Rank.SUBORDER())) { result = Bacteria_STR_Suborder; }
2532
			else if (rank.equals(Rank.INFRAORDER())) { result = Bacteria_STR_Infraorder; }
2533
			else if (rank.equals(Rank.SUPERFAMILY())) { result = Bacteria_STR_Superfamily; }
2534
			else if (rank.equals(Rank.FAMILY())) { result = Bacteria_STR_Family; }
2535
			else if (rank.equals(Rank.SUBFAMILY())) { result = Bacteria_STR_Subfamily; }
2536
			else if (rank.equals(Rank.TRIBE())) { result = Bacteria_STR_Tribe; }
2537
			else if (rank.equals(Rank.SUBTRIBE())) { result = Bacteria_STR_Subtribe; }
2538
			else if (rank.equals(Rank.GENUS())) { result = Bacteria_STR_Genus; }
2539
			else if (rank.equals(Rank.SUBGENUS())) { result = Bacteria_STR_Subgenus; }
2540
			else if (rank.equals(Rank.SPECIES())) { result = Bacteria_STR_Species; }
2541
			else if (rank.equals(Rank.SUBSPECIES())) { result = Bacteria_STR_Subspecies; }
2542
			else if (rank.equals(Rank.VARIETY())) { result = Bacteria_STR_Variety; }
2543
			else if (rank.equals(Rank.FORM())) { result = Bacteria_STR_Forma; }
2544
		} else {
2545
			//TODO Exception
2546
			logger.warn("Kingdom not yet supported in CDM: "+ pesiKingdomId);
2547
			return null;
2548
		}
2549
		return result;
2550
	}
2551
	
2552
	/**
2553
	 * Returns the abbreviation for a given rank.
2554
	 * @param rank
2555
	 * @param pesiKingdomId
2556
	 * @return
2557
	 */
2558
	public static String rank2RankAbbrev(Rank rank, Integer pesiKingdomId) {
2559
		String result = null;
2560
		if (rank == null) {
2561
			return null;
2562
		}
2563
		
2564
		// We differentiate between Animalia and Plantae only for now.
2565
		if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_ANIMALIA) {
2566
			if (rank.equals(Rank.SUBGENUS())) {
2567
				result = Animalia_Abbrev_Subgenus;
2568
			} else if (rank.equals(Rank.SPECIES())) {
2569
				result = Animalia_Abbrev_Species;
2570
			} else if (rank.equals(Rank.SUBSPECIES())) {
2571
				result = Animalia_Abbrev_Subspecies;
2572
//			} else if (rank.equals(Rank.)) { // not yet specified
2573
//				result = Animalia_STR_Natio;
2574
			} else if (rank.equals(Rank.VARIETY())) {
2575
				result = Animalia_Abbrev_Variety;
2576
			} else if (rank.equals(Rank.SUBVARIETY())) {
2577
				result = Animalia_Abbrev_Subvariety;
2578
			} else if (rank.equals(Rank.FORM())) {
2579
				result = Animalia_Abbrev_Forma;
2580
			} else {
2581
				//TODO Exception
2582
				logger.warn("Abbreviation for Rank of Kingdom Animalia not supported in CDM: "+ rank.getLabel());
2583
				return null;
2584
			}
2585
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_PLANTAE) {
2586
			if (rank.equals(Rank.KINGDOM())) {
2587
				result = Plantae_Abbrev_Kingdom;
2588
			} else if (rank.equals(Rank.SUBKINGDOM())) {
2589
				result = Plantae_Abbrev_Subkingdom;
2590
			} else if (rank.equals(Rank.DIVISION())) {
2591
				result = Plantae_Abbrev_Division;
2592
			} else if (rank.equals(Rank.SUBDIVISION())) {
2593
				result = Plantae_Abbrev_Subdivision;
2594
			} else if (rank.equals(Rank.CLASS())) {
2595
				result = Plantae_Abbrev_Class;
2596
			} else if (rank.equals(Rank.SUBCLASS())) {
2597
				result = Plantae_Abbrev_Subclass;
2598
			} else if (rank.equals(Rank.ORDER())) {
2599
				result = Plantae_Abbrev_Order;
2600
			} else if (rank.equals(Rank.SUBORDER())) {
2601
				result = Plantae_Abbrev_Suborder;
2602
			} else if (rank.equals(Rank.FAMILY())) {
2603
				result = Plantae_Abbrev_Family;
2604
			} else if (rank.equals(Rank.SUBFAMILY())) {
2605
				result = Plantae_Abbrev_Subfamily;
2606
			} else if (rank.equals(Rank.TRIBE())) {
2607
				result = Plantae_Abbrev_Tribe;
2608
			} else if (rank.equals(Rank.SUBTRIBE())) {
2609
				result = Plantae_Abbrev_Subtribe;
2610
			} else if (rank.equals(Rank.GENUS())) {
2611
				result = Plantae_Abbrev_Genus;
2612
			} else if (rank.equals(Rank.SUBGENUS())) {
2613
				result = Plantae_Abbrev_Subgenus;
2614
			} else if (rank.equals(Rank.SECTION_BOTANY())) {
2615
				result = Plantae_Abbrev_Section;
2616
			} else if (rank.equals(Rank.SUBSECTION_BOTANY())) {
2617
				result = Plantae_Abbrev_Subsection;
2618
			} else if (rank.equals(Rank.SERIES())) {
2619
				result = Plantae_Abbrev_Series;
2620
			} else if (rank.equals(Rank.SUBSERIES())) {
2621
				result = Plantae_Abbrev_Subseries;
2622
//			} else if (rank.equals(Rank.)) { // not yet specified
2623
//				result = Plantae_Abbrev_Aggregate;
2624
//			} else if (rank.equals(Rank.)) { // not yet specified
2625
//				result = Plantae_Abbrev_Coll_Species;
2626
			} else if (rank.equals(Rank.SPECIES())) {
2627
				result = Plantae_Abbrev_Species;
2628
			} else if (rank.equals(Rank.SUBSPECIES())) {
2629
				result = Plantae_Abbrev_Subspecies;
2630
//			} else if (rank.equals(Rank.)) { // not yet specified
2631
//				result = Plantae_Abbrev_Proles;
2632
//			} else if (rank.equals(Rank.)) { // not yet specified
2633
//				result = Plantae_Abbrev_Race;
2634
			} else if (rank.equals(Rank.CONVAR())) {
2635
				result = Plantae_Abbrev_Convarietas;
2636
			} else if (rank.equals(Rank.VARIETY())) {
2637
				result = Plantae_Abbrev_Variety;
2638
			} else if (rank.equals(Rank.SUBVARIETY())) {
2639
				result = Plantae_Abbrev_Subvariety;
2640
			} else if (rank.equals(Rank.FORM())) {
2641
				result = Plantae_Abbrev_Forma;
2642
			} else if (rank.equals(Rank.SUBFORM())) {
2643
				result = Plantae_Abbrev_Subforma;
2644
//			} else if (rank.equals(Rank.)) { // not yet specified
2645
//				result = Plantae_Abbrev_Forma_spec;
2646
//			} else if (rank.equals(Rank.)) { // not yet specified
2647
//				result = Plantae_Abbrev_Taxa_infragen;
2648
//			} else if (rank.equals(Rank.)) { // not yet specified
2649
//				result = Plantae_Abbrev_Taxa_infraspec;
2650
			} else {
2651
				//TODO Exception
2652
				logger.warn("Abbreviation for Rank of Kingdom Plantae not supported in CDM: "+ rank.getLabel());
2653
				return null;
2654
			}
2655
		} else {
2656
			//TODO Exception
2657
			logger.warn("Kingdom not yet supported in CDM: "+ pesiKingdomId);
2658
			return null;
2659
		}
2660
		return result;
2661
	}
2662

    
2663
	/**
2664
	 * Returns the identifier of a PESI specific kingdom for a given CDM nomenclatural code.
2665
	 * @param nomenclaturalCode
2666
	 * @return KINGDOM_ANIMALIA for NomenclaturalCode.ICZN, KINGDOM_PLANTAE for NomenclaturalCode.ICBN
2667
	 */
2668
	public static Integer nomenClaturalCode2Kingdom(NomenclaturalCode nomenclaturalCode) {
2669
		Integer result = null;
2670
		// TODO: This needs to be refined. For now we differentiate between Animalia and Plantae only.
2671
		if (nomenclaturalCode.equals(NomenclaturalCode.ICZN)) {
2672
			result = KINGDOM_ANIMALIA;
2673
		} else if (nomenclaturalCode.equals(NomenclaturalCode.ICBN)) {
2674
			result = KINGDOM_PLANTAE;
2675
		} else if (nomenclaturalCode.equals(NomenclaturalCode.ICNB)) {
2676
			result = KINGDOM_BACTERIA;
2677
//		} else if (nomenclaturalCode.equals(NomenclaturalCode.)) { // Biota
2678
//			result = 
2679
		} else {
2680
			logger.error("NomenclaturalCode not yet considered: " + nomenclaturalCode.getUuid() + " (" +  nomenclaturalCode.getTitleCache() + ")");
2681
		}
2682
		return result;
2683
	}
2684

    
2685
	/**
2686
	 * Returns the NomenclaturalCode for a given TaxonNameBase.
2687
	 * @param taxonName
2688
	 * @return
2689
	 */
2690
	public static NomenclaturalCode getNomenclaturalCode(TaxonNameBase taxonName) {
2691
		NomenclaturalCode code = null;
2692
		if (taxonName.isInstanceOf(ZoologicalName.class)) {
2693
			code = NomenclaturalCode.ICZN;
2694
		} else if (taxonName.isInstanceOf(BotanicalName.class)) {
2695
			code = NomenclaturalCode.ICBN;
2696
		} else if (taxonName.isInstanceOf(BacterialName.class)) {
2697
			code = NomenclaturalCode.ICNB;
2698
//		} else if (taxonName.isInstanceOf(NonViralName.class)) { // Biota
2699
//			code = NomenclaturalCode.
2700
		} else {
2701
			logger.error("NomenclaturalCode could not be determined for this TaxonName: " + taxonName.getUuid() + " (" + taxonName.getTitleCache() + ")");
2702
			logger.error("");
2703
		}
2704
		return code;
2705
	}
2706
	
2707
	/**
2708
	 * Returns the RankId for a Rank.
2709
	 * @param rank
2710
	 * @return
2711
	 */
2712
	public static Integer rank2RankId (Rank rank, Integer pesiKingdomId) {
2713
		Integer result = null;
2714
		if (rank == null) {
2715
			return null;
2716
		}
2717
		
2718
		// We differentiate between Animalia and Plantae only for now.
2719
		if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_ANIMALIA) {
2720
			if (rank.equals(Rank.KINGDOM())) {
2721
				result = Animalia_Kingdom;
2722
			} else if (rank.equals(Rank.SUBKINGDOM())) {
2723
				result = Animalia_Subkingdom;
2724
			} else if (rank.equals(Rank.SUPERPHYLUM())) {
2725
				result = Animalia_Superphylum;
2726
			} else if (rank.equals(Rank.PHYLUM())) {
2727
				result = Animalia_Phylum;
2728
			} else if (rank.equals(Rank.SUBPHYLUM())) {
2729
				result = Animalia_Subphylum;
2730
			} else if (rank.equals(Rank.INFRAPHYLUM())) {
2731
				result = Animalia_Infraphylum;
2732
			} else if (rank.equals(Rank.SUPERCLASS())) {
2733
				result = Animalia_Superclass;
2734
			} else if (rank.equals(Rank.CLASS())) {
2735
				result = Animalia_Class;
2736
			} else if (rank.equals(Rank.SUBCLASS())) {
2737
				result = Animalia_Subclass;
2738
			} else if (rank.equals(Rank.INFRACLASS())) {
2739
				result = Animalia_Infraclass;
2740
			} else if (rank.equals(Rank.SUPERORDER())) {
2741
				result = Animalia_Superorder;
2742
			} else if (rank.equals(Rank.ORDER())) {
2743
				result = Animalia_Order;
2744
			} else if (rank.equals(Rank.SUBORDER())) {
2745
				result = Animalia_Suborder;
2746
			} else if (rank.equals(Rank.INFRAORDER())) {
2747
				result = Animalia_Infraorder;
2748
			} else if (rank.equals(Rank.SECTION_ZOOLOGY())) {
2749
				result = Animalia_Section;
2750
			} else if (rank.equals(Rank.SUBSECTION_ZOOLOGY())) {
2751
				result = Animalia_Subsection;
2752
			} else if (rank.equals(Rank.SUPERFAMILY())) {
2753
				result = Animalia_Superfamily;
2754
			} else if (rank.equals(Rank.FAMILY())) {
2755
				result = Animalia_Family;
2756
			} else if (rank.equals(Rank.SUBFAMILY())) {
2757
				result = Animalia_Subfamily;
2758
			} else if (rank.equals(Rank.TRIBE())) {
2759
				result = Animalia_Tribe;
2760
			} else if (rank.equals(Rank.SUBTRIBE())) {
2761
				result = Animalia_Subtribe;
2762
			} else if (rank.equals(Rank.GENUS())) {
2763
				result = Animalia_Genus;
2764
			} else if (rank.equals(Rank.SUBGENUS())) {
2765
				result = Animalia_Subgenus;
2766
			} else if (rank.equals(Rank.SPECIES())) {
2767
				result = Animalia_Species;
2768
			} else if (rank.equals(Rank.SUBSPECIES())) {
2769
				result = Animalia_Subspecies;
2770
//			} else if (rank.equals(Rank.)) { // not yet specified
2771
//				result = Animalia_Natio;
2772
			} else if (rank.equals(Rank.VARIETY())) {
2773
				result = Animalia_Variety;
2774
			} else if (rank.equals(Rank.SUBVARIETY())) {
2775
				result = Animalia_Subvariety;
2776
			} else if (rank.equals(Rank.FORM())) {
2777
				result = Animalia_Forma;
2778
			} else {
2779
				//TODO Exception
2780
				logger.warn("Rank for Kingdom Animalia not yet supported in CDM: "+ rank.getLabel());
2781
				return null;
2782
			}
2783
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_PLANTAE) {
2784
			if (rank.equals(Rank.KINGDOM())) {
2785
				result = Plantae_Kingdom;
2786
			} else if (rank.equals(Rank.SUBKINGDOM())) {
2787
				result = Plantae_Subkingdom;
2788
			} else if (rank.equals(Rank.DIVISION())) {
2789
				result = Plantae_Division;
2790
			} else if (rank.equals(Rank.SUBDIVISION())) {
2791
				result = Plantae_Subdivision;
2792
			} else if (rank.equals(Rank.CLASS())) {
2793
				result = Plantae_Class;
2794
			} else if (rank.equals(Rank.SUBCLASS())) {
2795
				result = Plantae_Subclass;
2796
			} else if (rank.equals(Rank.ORDER())) {
2797
				result = Plantae_Order;
2798
			} else if (rank.equals(Rank.SUBORDER())) {
2799
				result = Plantae_Suborder;
2800
			} else if (rank.equals(Rank.FAMILY())) {
2801
				result = Plantae_Family;
2802
			} else if (rank.equals(Rank.SUBFAMILY())) {
2803
				result = Plantae_Subfamily;
2804
			} else if (rank.equals(Rank.TRIBE())) {
2805
				result = Plantae_Tribe;
2806
			} else if (rank.equals(Rank.SUBTRIBE())) {
2807
				result = Plantae_Subtribe;
2808
			} else if (rank.equals(Rank.GENUS())) {
2809
				result = Plantae_Genus;
2810
			} else if (rank.equals(Rank.SUBGENUS())) {
2811
				result = Plantae_Subgenus;
2812
			} else if (rank.equals(Rank.SECTION_BOTANY())) {
2813
				result = Plantae_Section;
2814
			} else if (rank.equals(Rank.SUBSECTION_BOTANY())) {
2815
				result = Plantae_Subsection;
2816
			} else if (rank.equals(Rank.SERIES())) {
2817
				result = Plantae_Series;
2818
			} else if (rank.equals(Rank.SUBSERIES())) {
2819
				result = Plantae_Subseries;
2820
//			} else if (rank.equals(Rank.)) { // not yet specified
2821
//				result = Plantae_Aggregate;
2822
//			} else if (rank.equals(Rank.)) { // not yet specified
2823
//				result = Plantae_Coll_Species;
2824
			} else if (rank.equals(Rank.SPECIES())) {
2825
				result = Plantae_Species;
2826
			} else if (rank.equals(Rank.SUBSPECIES())) {
2827
				result = Plantae_Subspecies;
2828
//			} else if (rank.equals(Rank.)) { // not yet specified
2829
//				result = Plantae_Proles;
2830
//			} else if (rank.equals(Rank.)) { // not yet specified
2831
//				result = Plantae_Race;
2832
			} else if (rank.equals(Rank.CONVAR())) {
2833
				result = Plantae_Convarietas;
2834
			} else if (rank.equals(Rank.VARIETY())) {
2835
				result = Plantae_Variety;
2836
			} else if (rank.equals(Rank.SUBVARIETY())) {
2837
				result = Plantae_Subvariety;
2838
			} else if (rank.equals(Rank.FORM())) {
2839
				result = Plantae_Forma;
2840
			} else if (rank.equals(Rank.SUBFORM())) {
2841
				result = Plantae_Subforma;
2842
//			} else if (rank.equals(Rank.)) { // not yet specified
2843
//				result = Plantae_Forma_spec;
2844
//			} else if (rank.equals(Rank.)) { // not yet specified
2845
//				result = Plantae_Taxa_infragen;
2846
//			} else if (rank.equals(Rank.)) { // not yet specified
2847
//				result = Plantae_Taxa_infraspec;
2848
			} else {
2849
				//TODO Exception
2850
				logger.warn("Rank for Kingdom Plantae not yet supported in CDM: "+ rank.getLabel());
2851
				return null;
2852
			}
2853
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_BACTERIA) {
2854
			if (rank.equals(Rank.KINGDOM())) { result = Bacteria_Kingdom; }
2855
			else if (rank.equals(Rank.SUBKINGDOM())) { result = Bacteria_Subkingdom; }
2856
			else if (rank.equals(Rank.PHYLUM())) { result = Bacteria_Phylum; }
2857
			else if (rank.equals(Rank.SUBPHYLUM())) { result = Bacteria_Subphylum; }
2858
			else if (rank.equals(Rank.SUPERCLASS())) { result = Bacteria_Superclass; }
2859
			else if (rank.equals(Rank.CLASS())) { result = Bacteria_Class; }
2860
			else if (rank.equals(Rank.SUBCLASS())) { result = Bacteria_Subclass; }
2861
			else if (rank.equals(Rank.INFRACLASS())) { result = Bacteria_Infraclass; }
2862
			else if (rank.equals(Rank.SUPERORDER())) { result = Bacteria_Superorder; }
2863
			else if (rank.equals(Rank.ORDER())) { result = Bacteria_Order; }
2864
			else if (rank.equals(Rank.SUBORDER())) { result = Bacteria_Suborder; }
2865
			else if (rank.equals(Rank.INFRAORDER())) { result = Bacteria_Infraorder; }
2866
			else if (rank.equals(Rank.SUPERFAMILY())) { result = Bacteria_Superfamily; }
2867
			else if (rank.equals(Rank.FAMILY())) { result = Bacteria_Family; }
2868
			else if (rank.equals(Rank.SUBFAMILY())) { result = Bacteria_Subfamily; }
2869
			else if (rank.equals(Rank.TRIBE())) { result = Bacteria_Tribe; }
2870
			else if (rank.equals(Rank.SUBTRIBE())) { result = Bacteria_Subtribe; }
2871
			else if (rank.equals(Rank.GENUS())) { result = Bacteria_Genus; }
2872
			else if (rank.equals(Rank.SUBGENUS())) { result = Bacteria_Subgenus; }
2873
			else if (rank.equals(Rank.SPECIES())) { result = Bacteria_Species; }
2874
			else if (rank.equals(Rank.SUBSPECIES())) { result = Bacteria_Subspecies; }
2875
			else if (rank.equals(Rank.VARIETY())) { result = Bacteria_Variety; }
2876
			else if (rank.equals(Rank.FORM())) { result = Bacteria_Forma; }
2877
		} else {
2878
			//TODO Exception
2879
			logger.warn("Kingdom not yet supported in CDM: "+ pesiKingdomId);
2880
			return null;
2881
		}
2882
		return result;
2883
	}
2884

    
2885
	/**
2886
	 * 
2887
	 * @param nameTypeDesignationStatus
2888
	 * @return
2889
	 */
2890
	public static Integer nameTypeDesignationStatus2TypeDesignationStatusId(NameTypeDesignationStatus nameTypeDesignationStatus) {
2891
		if (nameTypeDesignationStatus == null) {
2892
			return null;
2893
		}
2894
		if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.ORIGINAL_DESIGNATION())) {
2895
			return TYPE_BY_ORIGINAL_DESIGNATION;
2896
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.SUBSEQUENT_DESIGNATION())) {
2897
			return TYPE_BY_SUBSEQUENT_DESIGNATION;
2898
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.MONOTYPY())) {
2899
			return TYPE_BY_MONOTYPY;
2900
		} else {
2901
			//TODO Figure out a way to handle this gracefully.
2902
			logger.warn("Name Type Designation Status not yet supported in PESI: "+ nameTypeDesignationStatus.getLabel());
2903
			return null;
2904
		}
2905

    
2906
	}
2907

    
2908
	/**
2909
	 * 
2910
	 * @param nameTypeDesignationStatus
2911
	 * @return
2912
	 */
2913
	public static String nameTypeDesignationStatus2TypeDesignationStatusCache(NameTypeDesignationStatus nameTypeDesignationStatus) {
2914
		if (nameTypeDesignationStatus == null) {
2915
			return null;
2916
		}
2917
		if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.ORIGINAL_DESIGNATION())) {
2918
			return TYPE_STR_BY_ORIGINAL_DESIGNATION;
2919
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.SUBSEQUENT_DESIGNATION())) {
2920
			return TYPE_STR_BY_SUBSEQUENT_DESIGNATION;
2921
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.MONOTYPY())) {
2922
			return TYPE_STR_BY_MONOTYPY;
2923
		} else {
2924
			//TODO Figure out a way to handle this gracefully.
2925
			logger.warn("Name Type Designation Status not yet supported in PESI: "+ nameTypeDesignationStatus.getLabel());
2926
			return null;
2927
		}
2928

    
2929
	}
2930

    
2931
	/**
2932
	 * 
2933
	 * @param taxonBase
2934
	 * @return
2935
	 */
2936
	public static Integer taxonBase2statusFk (TaxonBase<?> taxonBase){
2937
		if (taxonBase == null){return null;}		
2938
		if (taxonBase.isInstanceOf(Taxon.class)){
2939
			return T_STATUS_ACCEPTED;
2940
		}else if (taxonBase.isInstanceOf(Synonym.class)){
2941
			return T_STATUS_SYNONYM;
2942
		}else{
2943
			logger.warn("Unknown ");
2944
			return T_STATUS_UNRESOLVED;
2945
		}
2946
		//TODO 
2947
//		public static int T_STATUS_PARTIAL_SYN = 3;
2948
//		public static int T_STATUS_PRO_PARTE_SYN = 4;
2949
//		public static int T_STATUS_UNRESOLVED = 5;
2950
//		public static int T_STATUS_ORPHANED = 6;
2951
	}
2952

    
2953
	/**
2954
	 * 
2955
	 * @param taxonBase
2956
	 * @return
2957
	 */
2958
	public static String taxonBase2statusCache (TaxonBase<?> taxonBase){
2959
		if (taxonBase == null){return null;}
2960
		if (taxonBase.isInstanceOf(Taxon.class)){
2961
			return T_STATUS_STR_ACCEPTED;
2962
		}else if (taxonBase.isInstanceOf(Synonym.class)){
2963
			return T_STATUS_STR_SYNONYM;
2964
		}else{
2965
			logger.warn("Unknown ");
2966
			return T_STATUS_STR_UNRESOLVED;
2967
		}
2968
		//TODO 
2969
//		public static int T_STATUS_STR_PARTIAL_SYN = 3;
2970
//		public static int T_STATUS_STR_PRO_PARTE_SYN = 4;
2971
//		public static int T_STATUS_STR_UNRESOLVED = 5;
2972
//		public static int T_STATUS_STR_ORPHANED = 6;
2973
	}
2974
		
2975
	/**
2976
	 * Returns the {@link SourceCategory SourceCategory} representation of the given {@link ReferenceType ReferenceType} in PESI.
2977
	 * @param reference The {@link Reference Reference}.
2978
	 * @return The {@link SourceCategory SourceCategory} representation in PESI.
2979
	 */
2980
	public static Integer reference2SourceCategoryFK(Reference<?> reference) {
2981
		if (reference == null){
2982
			return null;
2983
		} else if (reference.getType().equals(ReferenceType.Article)) {
2984
			return REF_ARTICLE_IN_PERIODICAL;
2985
		} else if (reference.getType().equals(ReferenceType.Book)) {
2986
			return REF_BOOK;
2987
		} else if (reference.getType().equals(ReferenceType.Database)) {
2988
			return REF_DATABASE;
2989
		} else if (reference.getType().equals(ReferenceType.WebPage)) {
2990
			return REF_WEBSITE;
2991
		} else if (reference.getType().equals(ReferenceType.CdDvd)) {
2992
			return REF_NOT_APPLICABLE;
2993
		} else if (reference.getType().equals(ReferenceType.Journal)) {
2994
			return REF_JOURNAL;
2995
		} else if (reference.getType().equals(ReferenceType.Generic)) {
2996
			return REF_UNRESOLVED;
2997
		} else if (reference.getType().equals(ReferenceType.PrintSeries)) {
2998
			return REF_PUBLISHED;
2999
		} else if (reference.getType().equals(ReferenceType.Proceedings)) {
3000
			return REF_PUBLISHED;
3001
		} else if (reference.getType().equals(ReferenceType.Patent)) {
3002
			return REF_NOT_APPLICABLE;
3003
		} else if (reference.getType().equals(ReferenceType.PersonalCommunication)) {
3004
			return REF_INFORMAL;
3005
		} else if (reference.getType().equals(ReferenceType.Report)) {
3006
			return REF_NOT_APPLICABLE;
3007
		} else if (reference.getType().equals(ReferenceType.Thesis)) {
3008
			return REF_NOT_APPLICABLE;
3009
		} else {
3010
			//TODO Figure out a way to handle this gracefully.
3011
			logger.warn("Reference type not yet supported in PESI: "+ reference.getClass().getSimpleName());
3012
			return null;
3013
		}
3014
	}
3015
	
3016
	/**
3017
	 * Returns the {@link SourceCategoryCache SourceCategoryCache}.
3018
	 * @param reference The {@link Reference Reference}.
3019
	 * @return The {@link SourceCategoryCache SourceCategoryCache}.
3020
	 */
3021
	public static String getSourceCategoryCache(Reference<?> reference) {
3022
		if (reference == null){
3023
			return null;
3024
		} else if (reference.getType().equals(ReferenceType.Article)) {
3025
			return REF_STR_ARTICLE_IN_PERIODICAL;
3026
		} else if (reference.getType().equals(ReferenceType.Book)) {
3027
			return REF_STR_BOOK;
3028
		} else if (reference.getType().equals(ReferenceType.Database)) {
3029
			return REF_STR_DATABASE;
3030
		} else if (reference.getType().equals(ReferenceType.WebPage)) {
3031
			return REF_STR_WEBSITE;
3032
		} else if (reference.getType().equals(ReferenceType.CdDvd)) {
3033
			return REF_STR_NOT_APPLICABLE;
3034
		} else if (reference.getType().equals(ReferenceType.Journal)) {
3035
			return REF_STR_JOURNAL;
3036
		} else if (reference.getType().equals(ReferenceType.Generic)) {
3037
			return REF_STR_UNRESOLVED;
3038
		} else if (reference.getType().equals(ReferenceType.PrintSeries)) {
3039
			return REF_STR_PUBLISHED;
3040
		} else if (reference.getType().equals(ReferenceType.Proceedings)) {
3041
			return REF_STR_PUBLISHED;
3042
		} else if (reference.getType().equals(ReferenceType.Patent)) {
3043
			return REF_STR_NOT_APPLICABLE;
3044
		} else if (reference.getType().equals(ReferenceType.PersonalCommunication)) {
3045
			return REF_STR_INFORMAL;
3046
		} else if (reference.getType().equals(ReferenceType.Report)) {
3047
			return REF_STR_NOT_APPLICABLE;
3048
		} else if (reference.getType().equals(ReferenceType.Thesis)) {
3049
			return REF_STR_NOT_APPLICABLE;
3050
		} else {
3051
			//TODO Figure out a way to handle this gracefully.
3052
			logger.warn("Reference type not yet supported in PESI: "+ reference.getClass().getSimpleName());
3053
			return null;
3054
		}
3055
	}
3056

    
3057
	/**
3058
	 * 
3059
	 * @param status
3060
	 * @return
3061
	 */
3062
	public static String nomStatus2NomStatusCache(NomenclaturalStatusType status) {
3063
		if (status == null){
3064
			return null;
3065
		}
3066
		if (status.equals(NomenclaturalStatusType.INVALID())) {return NAME_ST_STR_NOM_INVAL;
3067
		}else if (status.equals(NomenclaturalStatusType.ILLEGITIMATE())) {return NAME_ST_STR_NOM_ILLEG;
3068
		}else if (status.equals(NomenclaturalStatusType.NUDUM())) {return NAME_ST_STR_NOM_NUD;
3069
		}else if (status.equals(NomenclaturalStatusType.REJECTED())) {return NAME_ST_STR_NOM_REJ;
3070
		}else if (status.equals(NomenclaturalStatusType.REJECTED_PROP())) {return NAME_ST_STR_NOM_REJ_PROP;
3071
		}else if (status.equals(NomenclaturalStatusType.UTIQUE_REJECTED())) {return NAME_ST_STR_NOM_UTIQUE_REJ;
3072
		}else if (status.equals(NomenclaturalStatusType.UTIQUE_REJECTED_PROP())) {return NAME_ST_STR_NOM_UTIQUE_REJ_PROP;
3073
		}else if (status.equals(NomenclaturalStatusType.CONSERVED())) {return NAME_ST_STR_NOM_CONS;
3074
	
3075
		}else if (status.equals(NomenclaturalStatusType.CONSERVED_PROP())) {return NAME_ST_STR_NOM_CONS_PROP;
3076
		}else if (status.equals(NomenclaturalStatusType.ORTHOGRAPHY_CONSERVED())) {return NAME_ST_STR_ORTH_CONS;
3077
		}else if (status.equals(NomenclaturalStatusType.ORTHOGRAPHY_CONSERVED_PROP())) {return NAME_ST_STR_ORTH_CONS_PROP;
3078
		}else if (status.equals(NomenclaturalStatusType.SUPERFLUOUS())) {return NAME_ST_STR_NOM_SUPERFL;
3079
		}else if (status.equals(NomenclaturalStatusType.AMBIGUOUS())) {return NAME_ST_STR_NOM_AMBIG;
3080
		}else if (status.equals(NomenclaturalStatusType.PROVISIONAL())) {return NAME_ST_STR_NOM_PROVIS;
3081
		}else if (status.equals(NomenclaturalStatusType.DOUBTFUL())) {return NAME_ST_STR_NOM_DUB;
3082
		}else if (status.equals(NomenclaturalStatusType.NOVUM())) {return NAME_ST_STR_NOM_NOV;
3083
	
3084
		}else if (status.equals(NomenclaturalStatusType.CONFUSUM())) {return NAME_ST_STR_NOM_CONFUS;
3085
		}else if (status.equals(NomenclaturalStatusType.ALTERNATIVE())) {return NAME_ST_STR_NOM_ALTERN;
3086
		}else if (status.equals(NomenclaturalStatusType.COMBINATION_INVALID())) {return NAME_ST_STR_COMB_INVAL;
3087
		}else if (status.equals(NomenclaturalStatusType.LEGITIMATE())) {return NAME_ST_STR_LEGITIMATE;
3088
		
3089
		// The following are non-existent in CDM
3090
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_STR_COMB_INED;
3091
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_STR_COMB_AND_STAT_INED;
3092
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_STR_NOM_AND_ORTH_CONS;
3093
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_STR_NOM_NOV_INED;
3094
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_STR_SP_NOV_INED;
3095
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_STR_ALTERNATE_REPRESENTATION;
3096
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_STR_TEMPORARY_NAME;
3097
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_STR_SPECIES_INQUIRENDA;
3098

    
3099
		//TODO
3100
		}else {
3101
			//TODO Exception
3102
			logger.warn("NomStatus type not yet supported by PESI export: "+ status);
3103
		return null;
3104
	}
3105
	}
3106
	
3107
	/**
3108
	 * 
3109
	 * @param status
3110
	 * @return
3111
	 */
3112
	public static Integer nomStatus2nomStatusFk (NomenclaturalStatusType status){
3113
		if (status == null){
3114
			return null;
3115
		}
3116
		if (status.equals(NomenclaturalStatusType.INVALID())) {return NAME_ST_NOM_INVAL;
3117
		}else if (status.equals(NomenclaturalStatusType.ILLEGITIMATE())) {return NAME_ST_NOM_ILLEG;
3118
		}else if (status.equals(NomenclaturalStatusType.NUDUM())) {return NAME_ST_NOM_NUD;
3119
		}else if (status.equals(NomenclaturalStatusType.REJECTED())) {return NAME_ST_NOM_REJ;
3120
		}else if (status.equals(NomenclaturalStatusType.REJECTED_PROP())) {return NAME_ST_NOM_REJ_PROP;
3121
		}else if (status.equals(NomenclaturalStatusType.UTIQUE_REJECTED())) {return NAME_ST_NOM_UTIQUE_REJ;
3122
		}else if (status.equals(NomenclaturalStatusType.UTIQUE_REJECTED_PROP())) {return NAME_ST_NOM_UTIQUE_REJ_PROP;
3123
		}else if (status.equals(NomenclaturalStatusType.CONSERVED())) {return NAME_ST_NOM_CONS;
3124
		
3125
		}else if (status.equals(NomenclaturalStatusType.CONSERVED_PROP())) {return NAME_ST_NOM_CONS_PROP;
3126
		}else if (status.equals(NomenclaturalStatusType.ORTHOGRAPHY_CONSERVED())) {return NAME_ST_ORTH_CONS;
3127
		}else if (status.equals(NomenclaturalStatusType.ORTHOGRAPHY_CONSERVED_PROP())) {return NAME_ST_ORTH_CONS_PROP;
3128
		}else if (status.equals(NomenclaturalStatusType.SUPERFLUOUS())) {return NAME_ST_NOM_SUPERFL;
3129
		}else if (status.equals(NomenclaturalStatusType.AMBIGUOUS())) {return NAME_ST_NOM_AMBIG;
3130
		}else if (status.equals(NomenclaturalStatusType.PROVISIONAL())) {return NAME_ST_NOM_PROVIS;
3131
		}else if (status.equals(NomenclaturalStatusType.DOUBTFUL())) {return NAME_ST_NOM_DUB;
3132
		}else if (status.equals(NomenclaturalStatusType.NOVUM())) {return NAME_ST_NOM_NOV;
3133
		
3134
		}else if (status.equals(NomenclaturalStatusType.CONFUSUM())) {return NAME_ST_NOM_CONFUS;
3135
		}else if (status.equals(NomenclaturalStatusType.ALTERNATIVE())) {return NAME_ST_NOM_ALTERN;
3136
		}else if (status.equals(NomenclaturalStatusType.COMBINATION_INVALID())) {return NAME_ST_COMB_INVAL;
3137
		}else if (status.equals(NomenclaturalStatusType.LEGITIMATE())) {return NAME_ST_LEGITIMATE;
3138
		
3139
		// The following are non-existent in CDM
3140
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_COMB_INED;
3141
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_COMB_AND_STAT_INED;
3142
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_NOM_AND_ORTH_CONS;
3143
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_NOM_NOV_INED;
3144
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_SP_NOV_INED;
3145
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_ALTERNATE_REPRESENTATION;
3146
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_TEMPORARY_NAME;
3147
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_SPECIES_INQUIRENDA;
3148

    
3149
		//TODO
3150
		}else {
3151
			//TODO Exception
3152
			logger.warn("NomStatus type not yet supported by PESI export: "+ status);
3153
			return null;
3154
		}
3155
	}
3156
	
3157
	/**
3158
	 * Returns the RelTaxonQualifierCache for a given taxonRelation.
3159
	 * @param relation
3160
	 * @return
3161
	 */
3162
	public static String taxonRelation2RelTaxonQualifierCache(RelationshipBase<?,?,?> relation){
3163
		if (relation == null) {
3164
			return null;
3165
		}
3166
		RelationshipTermBase<?> type = relation.getType();
3167
		if (type.equals(TaxonRelationshipType.MISAPPLIED_NAME_FOR())) {
3168
			return STR_IS_MISAPPLIED_NAME_FOR;
3169
		} else if (type.equals(SynonymRelationshipType.SYNONYM_OF())) {
3170
			return STR_IS_SYNONYM_OF;
3171
		} else if (type.equals(SynonymRelationshipType.HOMOTYPIC_SYNONYM_OF())) {
3172
			return STR_IS_HOMOTYPIC_SYNONYM_OF;
3173
		} else if (type.equals(SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF())) {
3174
			return STR_IS_HETEROTYPIC_SYNONYM_OF;
3175
		} else if (type.equals(SynonymRelationshipType.INFERRED_EPITHET_OF())) {
3176
			return STR_IS_INFERRED_EPITHET_FOR;
3177
		} else if (type.equals(SynonymRelationshipType.INFERRED_GENUS_OF())) {
3178
			return STR_IS_INFERRED_GENUS_FOR;
3179
		} else if (type.equals(SynonymRelationshipType.POTENTIAL_COMBINATION_OF())) {
3180
			return STR_IS_POTENTIAL_COMBINATION_FOR;
3181
		} else if (type.equals(NameRelationshipType.BASIONYM())) {
3182
			return STR_IS_BASIONYM_FOR;
3183
		} else if (type.equals(NameRelationshipType.LATER_HOMONYM())) {
3184
			return STR_IS_LATER_HOMONYM_OF;
3185
		} else if (type.equals(NameRelationshipType.REPLACED_SYNONYM())) {
3186
			return STR_IS_REPLACED_SYNONYM_FOR;
3187
		} else if (type.equals(NameRelationshipType.VALIDATED_BY_NAME())) {
3188
			return STR_IS_VALIDATION_OF;
3189
		} else if (type.equals(NameRelationshipType.LATER_VALIDATED_BY_NAME())) {
3190
			return STR_IS_LATER_VALIDATION_OF;
3191
		} else if (type.equals(NameRelationshipType.CONSERVED_AGAINST())) {
3192
			return STR_IS_CONSERVED_AGAINST;
3193
		} else if (type.equals(NameRelationshipType.TREATED_AS_LATER_HOMONYM())) {
3194
			return STR_IS_TREATED_AS_LATER_HOMONYM_OF;
3195
		} else if (type.equals(NameRelationshipType.ORTHOGRAPHIC_VARIANT())) {
3196
			return STR_IS_ORTHOGRAPHIC_VARIANT_OF;
3197
		} else if (type.equals(NameRelationshipType.ALTERNATIVE_NAME())) {
3198
			return STR_IS_ALTERNATIVE_NAME_FOR;
3199
		} else {
3200
			logger.warn("No equivalent RelationshipType found in datawarehouse for: " + type.getTitleCache());
3201
		}
3202
			
3203
		// The following have no equivalent attribute in CDM
3204
//		IS_TYPE_OF
3205
//		IS_CONSERVED_TYPE_OF
3206
//		IS_REJECTED_TYPE_OF
3207
//		IS_FIRST_PARENT_OF
3208
//		IS_SECOND_PARENT_OF
3209
//		IS_FEMALE_PARENT_OF
3210
//		IS_MALE_PARENT_OF
3211
//		IS_REJECTED_IN_FAVOUR_OF
3212
//		HAS_SAME_TYPE_AS
3213
//		IS_LECTOTYPE_OF
3214
//		TYPE_NOT_DESIGNATED
3215
//		IS_PRO_PARTE_SYNONYM_OF
3216
//		IS_PARTIAL_SYNONYM_OF
3217
//		IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF
3218
//		IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF
3219
//		IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF
3220
//		IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF
3221

    
3222
		return null;
3223
	}
3224
	
3225
	/**
3226
	 * Returns the RelTaxonQualifierCache for a given zoological taxonRelation.
3227
	 * @param relation
3228
	 * @return
3229
	 */
3230
	public static String zoologicalTaxonRelation2RelTaxonQualifierCache(RelationshipBase<?,?,?> relation){
3231
		if (relation == null) {
3232
			return null;
3233
		}
3234
		RelationshipTermBase<?> type = relation.getType();
3235
		if (type.equals(TaxonRelationshipType.MISAPPLIED_NAME_FOR())) {
3236
			return STR_IS_MISAPPLIED_NAME_FOR;
3237
		} else if (type.equals(SynonymRelationshipType.SYNONYM_OF())) {
3238
			return STR_IS_SYNONYM_OF;
3239
		} else if (type.equals(SynonymRelationshipType.HOMOTYPIC_SYNONYM_OF())) {
3240
			return "is objective synonym of";
3241
		} else if (type.equals(SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF())) {
3242
			return "is subjective synonym of";
3243
		} else if (type.equals(SynonymRelationshipType.INFERRED_EPITHET_OF())) {
3244
			return STR_IS_INFERRED_EPITHET_FOR;
3245
		} else if (type.equals(SynonymRelationshipType.INFERRED_GENUS_OF())) {
3246
			return STR_IS_INFERRED_GENUS_FOR;
3247
		} else if (type.equals(SynonymRelationshipType.POTENTIAL_COMBINATION_OF())) {
3248
			return STR_IS_POTENTIAL_COMBINATION_FOR;
3249
		} else if (type.equals(NameRelationshipType.BASIONYM())) {
3250
			return "is original combination for";
3251
		} else if (type.equals(NameRelationshipType.LATER_HOMONYM())) {
3252
			return STR_IS_LATER_HOMONYM_OF;
3253
		} else if (type.equals(NameRelationshipType.REPLACED_SYNONYM())) {
3254
			return STR_IS_REPLACED_SYNONYM_FOR;
3255
		} else if (type.equals(NameRelationshipType.VALIDATED_BY_NAME())) {
3256
			return STR_IS_VALIDATION_OF;
3257
		} else if (type.equals(NameRelationshipType.LATER_VALIDATED_BY_NAME())) {
3258
			return STR_IS_LATER_VALIDATION_OF;
3259
		} else if (type.equals(NameRelationshipType.CONSERVED_AGAINST())) {
3260
			return STR_IS_CONSERVED_AGAINST;
3261
		} else if (type.equals(NameRelationshipType.TREATED_AS_LATER_HOMONYM())) {
3262
			return STR_IS_TREATED_AS_LATER_HOMONYM_OF;
3263
		} else if (type.equals(NameRelationshipType.ORTHOGRAPHIC_VARIANT())) {
3264
			return STR_IS_ORTHOGRAPHIC_VARIANT_OF;
3265
		} else if (type.equals(NameRelationshipType.ALTERNATIVE_NAME())) {
3266
			return STR_IS_ALTERNATIVE_NAME_FOR;
3267
		} else {
3268
			logger.warn("No equivalent RelationshipType found in datawarehouse for: " + type.getTitleCache());
3269
		}
3270
			
3271
		// The following have no equivalent attribute in CDM
3272
//		IS_TYPE_OF
3273
//		IS_CONSERVED_TYPE_OF
3274
//		IS_REJECTED_TYPE_OF
3275
//		IS_FIRST_PARENT_OF
3276
//		IS_SECOND_PARENT_OF
3277
//		IS_FEMALE_PARENT_OF
3278
//		IS_MALE_PARENT_OF
3279
//		IS_REJECTED_IN_FAVOUR_OF
3280
//		HAS_SAME_TYPE_AS
3281
//		IS_LECTOTYPE_OF
3282
//		TYPE_NOT_DESIGNATED
3283
//		IS_PRO_PARTE_SYNONYM_OF
3284
//		IS_PARTIAL_SYNONYM_OF
3285
//		IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF
3286
//		IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF
3287
//		IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF
3288
//		IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF
3289

    
3290
		return null;
3291
	}
3292
	
3293
	/**
3294
	 * Returns the RelTaxonQualifierFk for a TaxonRelation.
3295
	 * @param relation
3296
	 * @return
3297
	 */
3298
	public static Integer taxonRelation2RelTaxonQualifierFk(RelationshipBase<?,?,?> relation) {
3299
		if (relation == null) {
3300
			return null;
3301
		}
3302
		RelationshipTermBase<?> type = relation.getType();
3303
		if (type.equals(TaxonRelationshipType.MISAPPLIED_NAME_FOR())) {
3304
			return IS_MISAPPLIED_NAME_FOR;
3305
		} else if (type.equals(SynonymRelationshipType.SYNONYM_OF())) {
3306
			return IS_SYNONYM_OF;
3307
		} else if (type.equals(SynonymRelationshipType.HOMOTYPIC_SYNONYM_OF())) {
3308
			return IS_HOMOTYPIC_SYNONYM_OF;
3309
		} else if (type.equals(SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF())) {
3310
			return IS_HETEROTYPIC_SYNONYM_OF;
3311
		} else if (type.equals(SynonymRelationshipType.INFERRED_EPITHET_OF())) {
3312
			return IS_INFERRED_EPITHET_FOR;
3313
		} else if (type.equals(SynonymRelationshipType.INFERRED_GENUS_OF())) {
3314
			return IS_INFERRED_GENUS_FOR;
3315
		} else if (type.equals(SynonymRelationshipType.POTENTIAL_COMBINATION_OF())) {
3316
			return IS_POTENTIAL_COMBINATION_FOR;
3317
		} else if (type.equals(NameRelationshipType.BASIONYM())) {
3318
			return IS_BASIONYM_FOR;
3319
		} else if (type.equals(NameRelationshipType.LATER_HOMONYM())) {
3320
			return IS_LATER_HOMONYM_OF;
3321
		} else if (type.equals(NameRelationshipType.REPLACED_SYNONYM())) {
3322
			return IS_REPLACED_SYNONYM_FOR;
3323
		} else if (type.equals(NameRelationshipType.VALIDATED_BY_NAME())) {
3324
			return IS_VALIDATION_OF;
3325
		} else if (type.equals(NameRelationshipType.LATER_VALIDATED_BY_NAME())) {
3326
			return IS_LATER_VALIDATION_OF;
3327
		} else if (type.equals(NameRelationshipType.CONSERVED_AGAINST())) {
3328
			return IS_CONSERVED_AGAINST;
3329
		} else if (type.equals(NameRelationshipType.TREATED_AS_LATER_HOMONYM())) {
3330
			return IS_TREATED_AS_LATER_HOMONYM_OF;
3331
		} else if (type.equals(NameRelationshipType.ORTHOGRAPHIC_VARIANT())) {
3332
			return IS_ORTHOGRAPHIC_VARIANT_OF;
3333
		} else if (type.equals(NameRelationshipType.ALTERNATIVE_NAME())) {
3334
			return IS_ALTERNATIVE_NAME_FOR;
3335
		} else {
3336
			logger.warn("No equivalent RelationshipType found in datawarehouse for: " + type.getTitleCache());
3337
		}
3338

    
3339
		// The following have no equivalent attribute in CDM
3340
//		IS_TYPE_OF
3341
//		IS_CONSERVED_TYPE_OF
3342
//		IS_REJECTED_TYPE_OF
3343
//		IS_FIRST_PARENT_OF
3344
//		IS_SECOND_PARENT_OF
3345
//		IS_FEMALE_PARENT_OF
3346
//		IS_MALE_PARENT_OF
3347
//		IS_REJECTED_IN_FAVOUR_OF
3348
//		HAS_SAME_TYPE_AS
3349
//		IS_LECTOTYPE_OF
3350
//		TYPE_NOT_DESIGNATED
3351
//		IS_PRO_PARTE_SYNONYM_OF
3352
//		IS_PARTIAL_SYNONYM_OF
3353
//		IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF
3354
//		IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF
3355
//		IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF
3356
//		IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF
3357

    
3358
		return null;
3359
	}
3360
	
3361
	/**
3362
	 * Returns the QualityStatusFk for a given QualityStatusCache.
3363
	 * @param qualityStatusCache
3364
	 * @return
3365
	 */
3366
	public Integer QualityStatusCache2QualityStatusFk(String qualityStatusCache) {
3367
		Integer result = null;
3368
		if (qualityStatusCache.equalsIgnoreCase("Checked by Taxonomic Editor: included in ERMS 1.1")) {
3369
			return 0;
3370
		} else if (qualityStatusCache.equalsIgnoreCase("Added by Database Management Team")) {
3371
			return 2;
3372
		} else if (qualityStatusCache.equalsIgnoreCase("Checked by Taxonomic Editor")) {
3373
			return 3;
3374
		} else if (qualityStatusCache.equalsIgnoreCase("Edited by Database Management Team")) {
3375
			return 4;
3376
		} else {
3377
			logger.error("QualityStatusFk could not be determined. QualityStatusCache unknown: " + qualityStatusCache);
3378
		}
3379
		
3380
		return result;
3381
	}
3382
	
3383
	/**
3384
	 * Returns the FossilStatusFk for a given FossilStatusCache.
3385
	 * @param fossilStatusCache
3386
	 * @return
3387
	 */
3388
	public Integer FossilStatusCache2FossilStatusFk(String fossilStatusCache) {
3389
		Integer result = null;
3390
		if (fossilStatusCache.equalsIgnoreCase("recent only")) {
3391
			return 1;
3392
		} else if (fossilStatusCache.equalsIgnoreCase("fossil only")) {
3393
			return 2;
3394
		} else if (fossilStatusCache.equalsIgnoreCase("recent + fossil")) {
3395
			return 3;
3396
		} else {
3397
			logger.error("FossilStatusFk could not be determined. FossilStatusCache unknown: " + fossilStatusCache);
3398
		}
3399
		
3400
		return result;
3401
	}
3402

    
3403
	/**
3404
	 * Returns the NoteCategoryFk for a given UUID representing an ExtensionType.
3405
	 * @param uuid
3406
	 * @return
3407
	 */
3408
	public static Integer getNoteCategoryFk(UUID uuid) {
3409
		Integer result = null;
3410
		if (uuid.equals(taxCommentUuid)) {
3411
			result = 270;
3412
		} else if (uuid.equals(fauCommentUuid)) {
3413
			result = 281;
3414
		} else if (uuid.equals(fauExtraCodesUuid)) {
3415
			result = 278;
3416
		}
3417
		return result;
3418
	}
3419
	
3420
	/**
3421
	 * Returns the NoteCategoryCache for a given UUID representing an ExtensionType.
3422
	 * @param uuid
3423
	 * @return
3424
	 */
3425
	public static String getNoteCategoryCache(UUID uuid) {
3426
		String result = null;
3427
		if (uuid.equals(taxCommentUuid)) {
3428
			result = "Taxonomy";
3429
		} else if (uuid.equals(fauCommentUuid)) {
3430
			result = "Biology";
3431
		} else if (uuid.equals(fauExtraCodesUuid)) {
3432
			result = "Distribution";
3433
		}
3434
		return result;
3435
	}
3436
	
3437
}
(15-15/15)