View Javadoc

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.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.ReferenceBase;
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 ReferenceBase ReferenceBase}.
2978 	 * @return The {@link SourceCategory SourceCategory} representation in PESI.
2979 	 */
2980 	public static Integer reference2SourceCategoryFK(ReferenceBase<?> 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 ReferenceBase ReferenceBase}.
3019 	 * @return The {@link SourceCategoryCache SourceCategoryCache}.
3020 	 */
3021 	public static String getSourceCategoryCache(ReferenceBase<?> 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 }