Project

General

Profile

Download (115 KB) Statistics
| Branch: | Revision:
1
// $Id$
2
/**
3
* Copyright (C) 2009 EDIT
4
* European Distributed Institute of Taxonomy
5
* http://www.e-taxonomy.eu
6
*
7
* The contents of this file are subject to the Mozilla Public License Version 1.1
8
* See LICENSE.TXT at the top of this package for the full license terms.
9
*/
10
package eu.etaxonomy.cdm.io.pesi.out;
11

    
12
import java.sql.ResultSet;
13
import java.sql.SQLException;
14
import java.util.BitSet;
15
import java.util.HashMap;
16
import java.util.HashSet;
17
import java.util.Map;
18
import java.util.Set;
19
import java.util.UUID;
20

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

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

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

    
67
	public static final String AUCT_STRING = "auct.";
68

    
69

    
70
	//source identifiers
71
	public static final int SOURCE_EM = 1;
72
	public static final int SOURCE_FE = 2;
73
	public static final int SOURCE_IF = 3;
74
	public static final int SOURCE_ERMS = 4;
75

    
76
	//sourceRefUUIDs
77
	public static final UUID uuidSourceRefFaunaEuropaea = UUID.fromString("6786d863-75d4-4796-b916-c1c3dff4cb70");
78
	public static final UUID uuidSourceRefErms = UUID.fromString("7744bc26-f914-42c4-b54a-dd2a030a8bb7");
79
	public static final UUID uuidSourceRefIndexFungorum = UUID.fromString("8de25d27-7d40-47f4-af3b-59d64935a843");
80
	public static final UUID uuidSourceRefAuct = UUID.fromString("5f79f96c-c100-4cd8-b78e-2b2dacf09a23");
81

    
82
	public static final String SOURCE_STR_EM = "E+M";
83
	public static final String SOURCE_STR_FE = "FaEu";
84
	public static final String SOURCE_STR_IF = "IF";
85
	public static final String SOURCE_STR_ERMS = "ERMS";
86

    
87
	// status keys
88
	public static int QUALITY_STATUS_CHECKED_EDITOR_ERMS_1_1 = 0;
89
	public static int QUALITY_STATUS_ADD_BY_DBMT= 2;
90
	public static int QUALITY_STATUS_CHECKED_EDITOR = 3;
91
	public static int QUALITY_STATUS_EDITED_BY_DBMT = 4;
92

    
93
	// marker type
94
	public static final UUID uuidMarkerGuidIsMissing = UUID.fromString("24e70843-05e2-44db-954b-84df0d23ea20");
95
	public static final UUID uuidMarkerTypeHasNoLastAction = UUID.fromString("99652d5a-bc92-4251-b57d-0fec4d258ab7");
96
//	public static final UUID uuidMarkerFossil = UUID.fromString("761ce108-031a-4e07-b444-f8d757070312");
97

    
98

    
99
	//extension type uuids
100
	public static final UUID cacheCitationUuid = UUID.fromString("29656168-32d6-4301-9067-d57c63be5c67");
101
	//public static final UUID expertUserIdUuid = UUID.fromString("e25813d3-c67c-4585-9aa0-970fafde50b4");
102
	//public static final UUID speciesExpertUserIdUuid = UUID.fromString("6d42abd8-8894-4980-ae07-e918affd4172");
103
	public static final UUID expertNameUuid = BerlinModelTransformer.uuidExpertName;
104
	public static final UUID speciesExpertNameUuid = BerlinModelTransformer.uuidSpeciesExpertName;
105
	public static final UUID lastActionDateUuid = UUID.fromString("8d0a7d81-bb83-4576-84c3-8c906ef039b2");
106
	public static final UUID lastActionUuid = UUID.fromString("bc20d5bc-6161-4279-9499-89ea26ce5f6a");
107
	public static final UUID taxCommentUuid = UUID.fromString("8041a752-0479-4626-ab1b-b266b751f816");
108
	public static final UUID fauCommentUuid = UUID.fromString("054f773a-41c8-4ad5-83e3-981320c1c126");
109
	public static final UUID fauExtraCodesUuid = UUID.fromString("b8c7e77d-9869-4787-bed6-b4b302dbc5f5");
110

    
111
	// References
112
	public static int REF_ARTICLE_IN_PERIODICAL = 1;
113
	public static int REF_PART_OF_OTHER = 2;
114
	public static int REF_BOOK = 3;
115
	public static int REF_DATABASE = 4;
116
	public static int REF_INFORMAL = 5;
117
	public static int REF_NOT_APPLICABLE = 6;
118
	public static int REF_WEBSITE = 7;
119
	public static int REF_PUBLISHED = 8;
120
	public static int REF_JOURNAL = 9;
121
	public static int REF_UNRESOLVED = 10;
122
	public static int REF_PUBLICATION = 11;
123
	public static String REF_STR_UNRESOLVED = "unresolved";
124

    
125
	// NameStatus
126
	public static int NAME_ST_NOM_INVAL = 1;
127
	public static int NAME_ST_NOM_ILLEG = 2;
128
	public static int NAME_ST_NOM_NUD = 3;
129
	public static int NAME_ST_NOM_REJ = 4;
130
	public static int NAME_ST_NOM_REJ_PROP = 5;
131
	public static int NAME_ST_NOM_UTIQUE_REJ = 6;
132
	public static int NAME_ST_NOM_UTIQUE_REJ_PROP = 7;
133
	public static int NAME_ST_NOM_CONS = 8;
134
	public static int NAME_ST_NOM_CONS_PROP = 9;
135
	public static int NAME_ST_ORTH_CONS = 10;
136
	public static int NAME_ST_ORTH_CONS_PROP = 11;
137
	public static int NAME_ST_NOM_SUPERFL = 12;
138
	public static int NAME_ST_NOM_AMBIG = 13;
139
	public static int NAME_ST_NOM_PROVIS = 14;
140
	public static int NAME_ST_NOM_DUB = 15;
141
	public static int NAME_ST_NOM_NOV = 16;
142
	public static int NAME_ST_NOM_CONFUS = 17;
143
	public static int NAME_ST_NOM_ALTERN = 18;
144
	public static int NAME_ST_COMB_INVAL = 19;
145
	public static int NAME_ST_LEGITIMATE = 20; // PESI specific from here
146
	public static int NAME_ST_COMB_INED = 21;
147
	public static int NAME_ST_COMB_AND_STAT_INED = 22;
148
	public static int NAME_ST_NOM_AND_ORTH_CONS = 23;
149
	public static int NAME_ST_NOM_NOV_INED = 24;
150
	public static int NAME_ST_SP_NOV_INED = 25;
151
	public static int NAME_ST_ALTERNATE_REPRESENTATION = 26;
152
	public static int NAME_ST_TEMPORARY_NAME = 27;
153
	public static int NAME_ST_SPECIES_INQUIRENDA = 28;
154

    
155
	// TaxonStatus
156
	public static int T_STATUS_ACCEPTED = 1;
157
	public static int T_STATUS_SYNONYM = 2;
158
	public static int T_STATUS_PARTIAL_SYN = 3;
159
	public static int T_STATUS_PRO_PARTE_SYN = 4;
160
	public static int T_STATUS_UNRESOLVED = 5;
161
	public static int T_STATUS_ORPHANED = 6;
162
	public static int T_STATUS_UNACCEPTED = 7;
163
	public static int T_STATUS_NOT_ACCEPTED = 8;
164

    
165
	// TypeDesginationStatus //	 -> not a table anymore
166
	public static int TYPE_BY_ORIGINAL_DESIGNATION = 1;
167
	public static int TYPE_BY_SUBSEQUENT_DESIGNATION = 2;
168
	public static int TYPE_BY_MONOTYPY = 3;
169
	public static String TYPE_STR_BY_ORIGINAL_DESIGNATION = "Type by original designation";
170
	public static String TYPE_STR_BY_SUBSEQUENT_DESIGNATION = "Type by subsequent designation";
171
	public static String TYPE_STR_BY_MONOTYPY = "Type by monotypy";
172

    
173
	// RelTaxonQualifier
174
	public static int IS_BASIONYM_FOR = 1;
175
	public static int IS_LATER_HOMONYM_OF = 2;
176
	public static int IS_REPLACED_SYNONYM_FOR = 3;
177
	public static int IS_VALIDATION_OF = 4;
178
	public static int IS_LATER_VALIDATION_OF = 5;
179
	public static int IS_TYPE_OF = 6;
180
	public static int IS_CONSERVED_TYPE_OF = 7;
181
	public static int IS_REJECTED_TYPE_OF = 8;
182
	public static int IS_FIRST_PARENT_OF = 9;
183
	public static int IS_SECOND_PARENT_OF = 10;
184
	public static int IS_FEMALE_PARENT_OF = 11;
185
	public static int IS_MALE_PARENT_OF = 12;
186
	public static int IS_CONSERVED_AGAINST = 13;
187
	public static int IS_REJECTED_IN_FAVOUR_OF = 14;
188
	public static int IS_TREATED_AS_LATER_HOMONYM_OF = 15;
189
	public static int IS_ORTHOGRAPHIC_VARIANT_OF = 16;
190
	public static int IS_ALTERNATIVE_NAME_FOR = 17;
191
	public static int HAS_SAME_TYPE_AS = 18;
192
	public static int IS_LECTOTYPE_OF = 61;
193
	public static int TYPE_NOT_DESIGNATED = 62;
194
	public static int IS_TAXONOMICALLY_INCLUDED_IN = 101;
195
	public static int IS_SYNONYM_OF = 102;
196
	public static int IS_MISAPPLIED_NAME_FOR = 103;
197
	public static int IS_PRO_PARTE_SYNONYM_OF = 104;
198
	public static int IS_PARTIAL_SYNONYM_OF = 105;
199
	public static int IS_HETEROTYPIC_SYNONYM_OF = 106;
200
	public static int IS_HOMOTYPIC_SYNONYM_OF = 107;
201
	public static int IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF = 201;
202
	public static int IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF = 202;
203
	public static int IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF = 203;
204
	public static int IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF = 204;
205
	public static int IS_INFERRED_EPITHET_FOR = 301;
206
	public static int IS_INFERRED_GENUS_FOR = 302;
207
	public static int IS_POTENTIAL_COMBINATION_FOR = 303;
208

    
209

    
210
	//namespaces
211
	public static String STR_NAMESPACE_NOMINAL_TAXON = "Nominal taxon from TAX_ID:";
212
	public static String STR_NAMESPACE_INFERRED_EPITHET = "Inferred epithet from TAX_ID:";
213
	public static String STR_NAMESPACE_INFERRED_GENUS = "Inferred genus from TAX_ID:";
214
	public static String STR_NAMESPACE_POTENTIAL_COMBINATION = "Potential combination from TAX_ID:";
215

    
216

    
217
	// Kingdoms
218
	public static int KINGDOM_NULL = 0;
219
	public static int KINGDOM_ANIMALIA = 2;
220
	public static int KINGDOM_PLANTAE = 3;
221
	public static int KINGDOM_FUNGI = 4;
222
	public static int KINGDOM_PROTOZOA = 5;
223
	public static int KINGDOM_BACTERIA = 6;
224
	public static int KINGDOM_CHROMISTA = 7;
225

    
226
	// Kingdoms
227
	public static Map<String, Integer> pesiKingdomMap = new HashMap<String, Integer>();
228

    
229

    
230
    public static String KINGDOM_PLANTAE_STRING = "Plantae";
231
    public static String KINGDOM_FUNGI_STRING = "Fungi";
232
    public static String KINGDOM_PROTOZOA_STRING = "Protozoa";
233
    public static String kINGDOM_BACTERIA_STRING = "Bacteria";
234
    public static String KINGDOM_CHROMISTA_STRING = "Chromista";
235

    
236
	// Animalia Ranks
237
	public static int Animalia_Kingdom = 10;
238
	public static int Animalia_Subkingdom = 20;
239
	public static int Animalia_Superphylum = 23;
240
	public static int Animalia_Phylum = 30;
241
	public static int Animalia_Subphylum = 40;
242
	public static int Animalia_Infraphylum = 45;
243
	public static int Animalia_Superclass = 50;
244
	public static int Animalia_Class = 60;
245
	public static int Animalia_Subclass = 70;
246
	public static int Animalia_Infraclass = 80;
247
	public static int Animalia_Superorder = 90;
248
	public static int Animalia_Order = 100;
249
	public static int Animalia_Suborder = 110;
250
	public static int Animalia_Infraorder = 120;
251
	public static int Animalia_Section = 121;
252
	public static int Animalia_Subsection = 122;
253
	public static int Animalia_Superfamily = 130;
254
	public static int Animalia_Family = 140;
255
	public static int Animalia_Subfamily = 150;
256
	public static int Animalia_Tribe = 160;
257
	public static int Animalia_Subtribe = 170;
258
	public static int Animalia_Genus = 180;
259
	public static int Animalia_Subgenus = 190;
260
	public static int Animalia_Species =220;
261
	public static int Animalia_Subspecies = 230;
262
	public static int Animalia_Natio = 235;
263
	public static int Animalia_Variety = 240;
264
	public static int Animalia_Subvariety = 250;
265
	public static int Animalia_Forma = 260;
266

    
267
	// Plantae Ranks
268
	public static int Plantae_Kingdom = 10;
269
	public static int Plantae_Subkingdom = 20;
270
	public static int Plantae_Phylum = 20;
271
	public static int Plantae_Subphylum = 20;
272
	public static int Plantae_Division = 30;
273
	public static int Plantae_Subdivision = 40;
274
	public static int Plantae_Class = 60;
275
	public static int Plantae_Subclass = 70;
276
	public static int Plantae_Superorder = 90;
277
	public static int Plantae_Order = 100;
278
	public static int Plantae_Suborder = 110;
279
	public static int Plantae_Family = 140;
280
	public static int Plantae_Subfamily = 150;
281
	public static int Plantae_Tribe	= 160;
282
	public static int Plantae_Subtribe = 170;
283
	public static int Plantae_Genus = 180;
284
	public static int Plantae_Subgenus = 190;
285
	public static int Plantae_Section = 200;
286
	public static int Plantae_Subsection = 210;
287
	public static int Plantae_Series = 212;
288
	public static int Plantae_Subseries	= 214;
289
	public static int Plantae_Aggregate	= 216;
290
	public static int Plantae_Coll_Species = 218;
291
	public static int Plantae_Species = 220;
292
	public static int Plantae_Grex = 225;
293
	public static int Plantae_Subspecies = 230;
294
	public static int Plantae_Proles = 232;
295
	public static int Plantae_Race = 234;
296
	public static int Plantae_Convarietas = 236;
297
	public static int Plantae_Variety = 240;
298
	public static int Plantae_Subvariety = 250;
299
	public static int Plantae_Forma	= 260;
300
	public static int Plantae_Subforma = 270;
301
	public static int Plantae_Forma_spec = 275;
302
	public static int Plantae_Taxa_infragen = 280;
303
	public static int Plantae_Taxa_infraspec = 285;
304

    
305
	// Fungi Ranks
306
	public static int Fungi_Kingdom = 10;
307
	public static int Fungi_Subkingdom = 20;
308
	public static int Fungi_Division = 30;
309
	public static int Fungi_Subdivision = 40;
310
	public static int Fungi_Class	= 60;
311
	public static int Fungi_Subclass = 70;
312
	public static int Fungi_Order	= 100;
313
	public static int Fungi_Suborder = 110;
314
	public static int Fungi_Family = 140;
315
	public static int Fungi_Subfamily = 150;
316
	public static int Fungi_Tribe = 160;
317
	public static int Fungi_Subtribe = 170;
318
	public static int Fungi_Genus = 180;
319
	public static int Fungi_Subgenus = 190;
320
	public static int Fungi_Section = 200;
321
	public static int Fungi_Subsection = 210;
322
	public static int Fungi_Species = 220;
323
	public static int Fungi_Subspecies = 230;
324
	public static int Fungi_Variety = 240;
325
	public static int Fungi_Subvariety = 250;
326
	public static int Fungi_Forma	= 260;
327
	public static int Fungi_Subforma = 270;
328
	public static int Fungi_Forma_spec = 275;
329

    
330
	//Protozoa Ranks
331
	public static int Protozoa_Kingdom = 10;
332
	public static int Protozoa_Subkingdom = 20;
333
	public static int Protozoa_Phylum = 30;
334
	public static int Protozoa_Subphylum = 40;
335
	public static int Protozoa_Superclass = 50;
336
	public static int Protozoa_Class	= 60;
337
	public static int Protozoa_Subclass = 70;
338
	public static int Protozoa_Infraclass = 80;
339
	public static int Protozoa_Superorder = 90;
340
	public static int Protozoa_Order	= 100;
341
	public static int Protozoa_Suborder = 110;
342
	public static int Protozoa_Infraorder = 120;
343
	public static int Protozoa_Superfamily = 130;
344
	public static int Protozoa_Family = 140;
345
	public static int Protozoa_Subfamily = 150;
346
	public static int Protozoa_Tribe	= 160;
347
	public static int Protozoa_Subtribe = 170;
348
	public static int Protozoa_Genus	= 180;
349
	public static int Protozoa_Subgenus = 190;
350
	public static int Protozoa_Species = 220;
351
	public static int Protozoa_Subspecies = 230;
352
	public static int Protozoa_Variety = 240;
353
	public static int Protozoa_Forma	= 260;
354

    
355
	// Bacteria Ranks
356
	public static int Bacteria_Kingdom = 10;
357
	public static int Bacteria_Subkingdom = 20;
358
	public static int Bacteria_Phylum = 30;
359
	public static int Bacteria_Subphylum	= 40;
360
	public static int Bacteria_Superclass = 50;
361
	public static int Bacteria_Class	= 60;
362
	public static int Bacteria_Subclass = 70;
363
	public static int Bacteria_Infraclass = 80;
364
	public static int Bacteria_Superorder = 90;
365
	public static int Bacteria_Order	= 100;
366
	public static int Bacteria_Suborder = 110;
367
	public static int Bacteria_Infraorder = 120;
368
	public static int Bacteria_Superfamily = 130;
369
	public static int Bacteria_Family = 140;
370
	public static int Bacteria_Subfamily	= 150;
371
	public static int Bacteria_Tribe	= 160;
372
	public static int Bacteria_Subtribe = 170;
373
	public static int Bacteria_Genus	= 180;
374
	public static int Bacteria_Subgenus = 190;
375
	public static int Bacteria_Species = 220;
376
	public static int Bacteria_Subspecies = 230;
377
	public static int Bacteria_Variety = 240;
378
	public static int Bacteria_Forma	= 260;
379

    
380
	// Chromista Ranks
381
	public static int Chromista_Kingdom = 10;
382
	public static int Chromista_Subkingdom = 20;
383
	public static int Chromista_Infrakingdom = 25;
384
	public static int Chromista_Phylum = 30;
385
	public static int Chromista_Subphylum = 40;
386
	public static int Chromista_Superclass = 50;
387
	public static int Chromista_Class = 60;
388
	public static int Chromista_Subclass = 70;
389
	public static int Chromista_Infraclass = 80;
390
	public static int Chromista_Superorder = 90;
391
	public static int Chromista_Order = 100;
392
	public static int Chromista_Suborder = 110;
393
	public static int Chromista_Infraorder = 120;
394
	public static int Chromista_Superfamily	= 130;
395
	public static int Chromista_Family = 140;
396
	public static int Chromista_Subfamily = 150;
397
	public static int Chromista_Tribe = 160;
398
	public static int Chromista_Subtribe = 170;
399
	public static int Chromista_Genus = 180;
400
	public static int Chromista_Subgenus = 190;
401
	public static int Chromista_Section = 200;
402
	public static int Chromista_Subsection = 210;
403
	public static int Chromista_Species	= 220;
404
	public static int Chromista_Subspecies = 230;
405
	public static int Chromista_Variety	= 240;
406
	public static int Chromista_Subvariety = 250;
407
	public static int Chromista_Forma = 260;
408

    
409
	// NoteCategory
410
	public static int NoteCategory_description = 1;
411
	public static int NoteCategory_ecology = 4;
412
	public static int NoteCategory_phenology	= 5;
413
	public static int NoteCategory_general_distribution_euromed = 10;
414
	public static int NoteCategory_general_distribution_world = 11;
415
	public static int NoteCategory_Common_names = 12;
416
	public static int NoteCategory_Occurrence = 13;
417
	public static int NoteCategory_Maps =14;
418
	public static int NoteCategory_Link_to_maps = 20;
419
	public static int NoteCategory_Link_to_images = 21;
420
	public static int NoteCategory_Link_to_taxonomy = 22;
421
	public static int NoteCategory_Link_to_general_information = 23;
422
	public static int NoteCategory_undefined_link = 24;
423
	public static int NoteCategory_Editor_Braces = 249;
424
	public static int NoteCategory_Editor_Brackets = 250;
425
	public static int NoteCategory_Editor_Parenthesis = 251;
426
	public static int NoteCategory_Inedited = 252;
427
	public static int NoteCategory_Comments_on_editing_process = 253;
428
	public static int NoteCategory_Publication_date = 254;
429
	public static int NoteCategory_Morphology = 255;
430
	public static int NoteCategory_Acknowledgments = 257;
431
	public static int NoteCategory_Original_publication = 258;
432
	public static int NoteCategory_Type_locality	= 259;
433
	public static int NoteCategory_Environment = 260;
434
	public static int NoteCategory_Spelling = 261;
435
	public static int NoteCategory_Systematics = 262;
436
	public static int NoteCategory_Remark = 263;
437
	public static int NoteCategory_Date_of_publication = 264;
438
	public static int NoteCategory_Additional_information = 266;
439
	public static int NoteCategory_Status = 267;
440
	public static int NoteCategory_Nomenclature = 268;
441
	public static int NoteCategory_Homonymy = 269;
442
	public static int NoteCategory_Taxonomy = 270;
443
	public static int NoteCategory_Taxonomic_status = 272;
444
	public static int NoteCategory_Authority	= 273;
445
	public static int NoteCategory_Identification = 274;
446
	public static int NoteCategory_Validity = 275;
447
	public static int NoteCategory_Classification = 276;
448
	public static int NoteCategory_Distribution = 278;
449
	public static int NoteCategory_Synonymy = 279;
450
	public static int NoteCategory_Habitat = 280;
451
	public static int NoteCategory_Biology = 281;
452
	public static int NoteCategory_Diagnosis	= 282;
453
	public static int NoteCategory_Host = 283;
454
	public static int NoteCategory_Note = 284;
455
	public static int NoteCategory_Rank = 285;
456
	public static int NoteCategory_Taxonomic_Remark = 286;
457
	public static int NoteCategory_Taxonomic_Remarks = 287;
458

    
459
	public static int NoteCategory_Conservation_Status= 301;
460
	public static int NoteCategory_Use = 302;
461
	public static int NoteCategory_Comments = 303;
462

    
463

    
464
	// Language
465
	public static int Language_Albanian = 1;
466
	public static int Language_Arabic = 2;
467
	public static int Language_Armenian = 3;
468
	public static int Language_Azerbaijan = 4;
469
	public static int Language_Belarusian = 5;
470
	public static int Language_Bulgarian = 6;
471
	public static int Language_Catalan = 7;
472
	public static int Language_Croat = 8;
473
	public static int Language_Czech = 9;
474
	public static int Language_Danish = 10;
475
	public static int Language_Dutch = 11;
476
	public static int Language_English = 12;
477
	public static int Language_Euskera = 13;
478
	public static int Language_Estonian = 14;
479
	public static int Language_Finnish = 15;
480
	public static int Language_French = 16;
481
	public static int Language_Georgian = 17;
482
	public static int Language_German = 18;
483
	public static int Language_Greek = 19;
484
	public static int Language_Hungarian = 20;
485
	public static int Language_Icelandic = 21;
486
	public static int Language_Irish_Gaelic = 22;
487
	public static int Language_Israel_Hebrew = 23;
488
	public static int Language_Italian = 24;
489
	public static int Language_Latvian = 25;
490
	public static int Language_Lithuanian = 26;
491
	public static int Language_Macedonian = 27;
492
	public static int Language_Maltese = 28;
493
	public static int Language_Moldovian = 29;
494
	public static int Language_Norwegian = 30;
495
	public static int Language_Polish = 31;
496
	public static int Language_Portuguese = 32;
497
	public static int Language_Roumanian = 33;
498
	public static int Language_Russian = 34;
499
	public static int Language_Russian_Caucasian = 35;
500
	public static int Language_Russian_Altaic_kalmyk_oirat = 36;
501
	public static int Language_Russian_Altaic_karachay_balkar = 37;
502
	public static int Language_Russian_Altaic_kumyk = 38;
503
	public static int Language_Russian_Altaic_nogai = 39;
504
	public static int Language_Russian_Altaic_north_azerbaijani = 40;
505
	public static int Language_Russian_Indo_european_russian = 41;
506
	public static int Language_Russian_Indo_european_kalmyk_oirat = 42;
507
	public static int Language_Russian_Indo_european_osetin = 43;
508
	public static int Language_Russian_North_caucasian_abaza = 44;
509
	public static int Language_Russian_North_caucasian_adyghe = 45;
510
	public static int Language_Russian_North_caucasian_chechen = 46;
511
	public static int Language_Russian_North_caucasian_kabardian = 47;
512
	public static int Language_Russian_North_caucasian_lak = 48;
513
	public static int Language_Russian_North_caucasian_avar = 49;
514
	public static int Language_Russian_North_caucasian_in = 50;
515
	public static int Language_Russian_Uralic_chuvash = 51;
516
	public static int Language_Russian_Uralic_udmurt = 52;
517
	public static int Language_Serbian = 53;
518
	public static int Language_Slovak = 54;
519
	public static int Language_Slovene = 55;
520
	public static int Language_Spanish_Castillian = 56;
521
	public static int Language_Swedish = 57;
522
	public static int Language_Turkish = 58;
523
	public static int Language_Ukraine = 59;
524
	public static int Language_Welsh = 60;
525
	public static int Language_Corsican = 61;
526

    
527
	// FossilStatus
528
	public static int FOSSILSTATUS_RECENT_ONLY = 1;
529
	public static int FOSSILSTATUS_FOSSIL_ONLY = 2;
530
	public static int FOSSILSTATUS_RECENT_FOSSIL = 3;
531
	public static String STR_FOSSIL_ONLY = "fossil only";  //still used for Index Fungorum
532

    
533
	// SourceUse
534
	public static int ORIGINAL_DESCRIPTION = 1;
535
	public static int BASIS_OF_RECORD = 2;
536
	public static int ADDITIONAL_SOURCE = 3;
537
	public static int SOURCE_OF_SYNONYMY = 4;
538
	public static int REDESCRIPTION = 5;
539
	public static int NEW_COMBINATION_REFERENCE = 6;
540
	public static int STATUS_SOURCE = 7;
541
	public static int NOMENCLATURAL_REFERENCE = 8;
542
	public static String STR_NOMENCLATURAL_REFERENCE = "nomenclatural reference";
543

    
544
	// Area
545
	public static int AREA_EAST_AEGEAN_ISLANDS = 1;
546
	public static int AREA_GREEK_EAST_AEGEAN_ISLANDS = 2;
547
	public static int AREA_TURKISH_EAST_AEGEAN_ISLANDS = 3;
548
	public static int AREA_ALBANIA = 4;
549
	public static int AREA_AUSTRIA_WITH_LIECHTENSTEIN = 5;
550
	public static int AREA_AUSTRIA = 6;
551
	public static int AREA_LIECHTENSTEIN = 7;
552
	public static int AREA_AZORES = 8;
553
	public static int AREA_CORVO = 9;
554
	public static int AREA_FAIAL = 10;
555
	public static int AREA_GRACIOSA = 11;
556
	public static int AREA_SAO_JORGE = 12;
557
	public static int AREA_FLORES = 13;
558
	public static int AREA_SAO_MIGUEL = 14;
559
	public static int AREA_PICO = 15;
560
	public static int AREA_SANTA_MARIA = 16;
561
	public static int AREA_TERCEIRA = 17;
562
	public static int AREA_BELGIUM_WITH_LUXEMBOURG = 18;
563
	public static int AREA_BELGIUM = 19;
564
	public static int AREA_LUXEMBOURG = 20;
565
	public static int AREA_BOSNIA_HERZEGOVINA = 21;
566
	public static int AREA_BALEARES = 22;
567
	public static int AREA_IBIZA_WITH_FORMENTERA = 23;
568
	public static int AREA_MALLORCA = 24;
569
	public static int AREA_MENORCA = 25;
570
	public static int AREA_GREAT_BRITAIN = 26;
571
	public static int AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION = 27;
572
	public static int AREA_BULGARIA = 28;
573
	public static int AREA_BELARUS = 29;
574
	public static int AREA_CANARY_ISLANDS = 30;
575
	public static int AREA_GRAN_CANARIA = 31;
576
	public static int AREA_FUERTEVENTURA_WITH_LOBOS = 32;
577
	public static int AREA_GOMERA = 33;
578
	public static int AREA_HIERRO = 34;
579
	public static int AREA_LANZAROTE_WITH_GRACIOSA = 35;
580
	public static int AREA_LA_PALMA = 36;
581
	public static int AREA_TENERIFE = 37;
582
	public static int AREA_MONTENEGRO = 38;
583
	public static int AREA_CORSE = 39;
584
	public static int AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS = 40;
585
	public static int AREA_CZECH_REPUBLIC = 41;
586
	public static int AREA_CROATIA = 42;
587
	public static int AREA_CYPRUS = 43;
588
	public static int AREA_FORMER_CZECHOSLOVAKIA = 44;
589
	public static int AREA_DENMARK_WITH_BORNHOLM = 45;
590
	public static int AREA_ESTONIA = 46;
591
	public static int AREA_FAROE_ISLANDS = 47;
592
	public static int AREA_FINLAND_WITH_AHVENANMAA = 48;
593
	public static int AREA_FRANCE = 49;
594
	public static int AREA_CHANNEL_ISLANDS = 50;
595
	public static int AREA_FRENCH_MAINLAND = 51;
596
	public static int AREA_MONACO = 52;
597
	public static int AREA_GERMANY = 53;
598
	public static int AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS = 54;
599
	public static int AREA_IRELAND = 55;
600
	public static int AREA_REPUBLIC_OF_IRELAND = 56;
601
	public static int AREA_NORTHERN_IRELAND = 57;
602
	public static int AREA_SWITZERLAND = 58;
603
	public static int AREA_NETHERLANDS = 59;
604
	public static int AREA_SPAIN = 60;
605
	public static int AREA_ANDORRA = 61;
606
	public static int AREA_GIBRALTAR = 62;
607
	public static int AREA_KINGDOM_OF_SPAIN = 63;
608
	public static int AREA_HUNGARY = 64;
609
	public static int AREA_ICELAND = 65;
610
	public static int AREA_ITALY = 66;
611
	public static int AREA_ITALIAN_MAINLAND = 67;
612
	public static int AREA_SAN_MARINO = 68;
613
	public static int AREA_FORMER_JUGOSLAVIA = 69;
614
	public static int AREA_LATVIA = 70;
615
	public static int AREA_LITHUANIA = 71;
616
	public static int AREA_PORTUGUESE_MAINLAND = 72;
617
	public static int AREA_MADEIRA_ARCHIPELAGO = 73;
618
	public static int AREA_DESERTAS = 74;
619
	public static int AREA_MADEIRA = 75;
620
	public static int AREA_PORTO_SANTO = 76;
621
	public static int AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA = 77;
622
	public static int AREA_MOLDOVA = 78;
623
	public static int AREA_NORWEGIAN_MAINLAND = 79;
624
	public static int AREA_POLAND = 80;
625
	public static int AREA_THE_RUSSIAN_FEDERATION = 81;
626
	public static int AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND = 82;
627
	public static int AREA_CENTRAL_EUROPEAN_RUSSIA = 83;
628
	public static int AREA_EASTERN_EUROPEAN_RUSSIA = 84;
629
	public static int AREA_KALININGRAD = 85;
630
	public static int AREA_NORTHERN_EUROPEAN_RUSSIA = 86;
631
	public static int AREA_NORTHWEST_EUROPEAN_RUSSIA = 87;
632
	public static int AREA_SOUTH_EUROPEAN_RUSSIA = 88;
633
	public static int AREA_ROMANIA = 89;
634
	public static int AREA_FORMER_USSR = 90;
635
	public static int AREA_RUSSIA_BALTIC = 91;
636
	public static int AREA_RUSSIA_CENTRAL = 92;
637
	public static int AREA_RUSSIA_SOUTHEAST = 93;
638
	public static int AREA_RUSSIA_NORTHERN = 94;
639
	public static int AREA_RUSSIA_SOUTHWEST = 95;
640
	public static int AREA_SARDEGNA = 96;
641
	public static int AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN = 97;
642
	public static int AREA_SELVAGENS_ISLANDS = 98;
643
	public static int AREA_SICILY_WITH_MALTA = 99;
644
	public static int AREA_MALTA = 100;
645
	public static int AREA_SICILY = 101;
646
	public static int AREA_SLOVAKIA = 102;
647
	public static int AREA_SLOVENIA = 103;
648
	public static int AREA_SERBIA_WITH_MONTENEGRO = 104;
649
	public static int AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO = 105;
650
	public static int AREA_SWEDEN = 106;
651
	public static int AREA_EUROPEAN_TURKEY = 107;
652
	public static int AREA_UKRAINE_INCLUDING_CRIMEA = 108;
653
	public static int AREA_CRIMEA = 109;
654
	public static int AREA_UKRAINE = 110;
655
	public static int AREA_GREEK_MAINLAND = 111;
656
	public static int AREA_CRETE = 112;
657
	public static int AREA_DODECANESE_ISLANDS = 113;
658
	public static int AREA_CYCLADES_ISLANDS = 114;
659
	public static int AREA_NORTH_AEGEAN_ISLANDS = 115;
660
	public static int AREA_VATICAN_CITY = 116;
661
	public static int AREA_FRANZ_JOSEF_LAND = 117;
662
	public static int AREA_NOVAYA_ZEMLYA = 118;
663
	public static int AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN = 119;
664
	public static int AREA_AZERBAIJAN = 120;
665
	public static int AREA_NAKHICHEVAN = 121;
666
	public static int AREA_ALGERIA = 122;
667
	public static int AREA_ARMENIA = 123;
668
	public static int AREA_CAUCASUS_REGION = 124;
669
	public static int AREA_EGYPT = 125;
670
	public static int AREA_GEORGIA = 126;
671
	public static int AREA_ISRAEL_JORDAN = 127;
672
	public static int AREA_ISRAEL = 128;
673
	public static int AREA_JORDAN = 129;
674
	public static int AREA_LEBANON = 130;
675
	public static int AREA_LIBYA = 131;
676
	public static int AREA_LEBANON_SYRIA = 132;
677
	public static int AREA_MOROCCO = 133;
678
	public static int AREA_NORTH_CAUCASUS = 134;
679
	public static int AREA_SINAI = 135;
680
	public static int AREA_SYRIA = 136;
681
	public static int AREA_TUNISIA = 137;
682
	public static int AREA_ASIATIC_TURKEY = 138;
683
	public static int AREA_TURKEY = 139;
684
	public static int AREA_NORTHERN_AFRICA = 140;
685
	public static int AREA_AFRO_TROPICAL_REGION = 141;
686
	public static int AREA_AUSTRALIAN_REGION = 142;
687
	public static int AREA_EAST_PALAEARCTIC = 143;
688
	public static int AREA_NEARCTIC_REGION = 144;
689
	public static int AREA_NEOTROPICAL_REGION = 145;
690
	public static int AREA_NEAR_EAST = 146;
691
	public static int AREA_ORIENTAL_REGION = 147;
692
	public static int AREA_EUROPEAN_MARINE_WATERS = 148;
693
	public static int AREA_MEDITERRANEAN_SEA = 149;
694
	public static int AREA_WHITE_SEA = 150;
695
	public static int AREA_NORTH_SEA = 151;
696
	public static int AREA_BALTIC_SEA = 152;
697
	public static int AREA_BLACK_SEA = 153;
698
	public static int AREA_BARENTS_SEA = 154;
699
	public static int AREA_CASPIAN_SEA = 155;
700
	public static int AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE = 156;
701
	public static int AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE = 157;
702
	public static int AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE = 158;
703
	public static int AREA_ENGLISH_CHANNEL = 159;
704
	public static int AREA_ADRIATIC_SEA = 160;
705
	public static int AREA_BISCAY_BAY = 161;
706
	public static int AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE = 162;
707
	public static int AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE = 163;
708
	public static int AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE = 164;
709
	public static int AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE = 165;
710
	public static int AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE = 166;
711
	public static int AREA_TIRRENO_SEA = 167;
712
	public static int AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE = 168;
713
	public static int AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE = 169;
714
	public static int AREA_IRISH_SEA = 170;
715
	public static int AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE = 171;
716
	public static int AREA_NORWEGIAN_SEA = 172;
717
	public static int AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE = 173;
718
	public static int AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE = 174;
719
	public static int AREA_SKAGERRAK = 175;
720
	public static int AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE = 176;
721
	public static int AREA_WADDEN_SEA = 177;
722
	public static int AREA_BELT_SEA = 178;
723
	public static int AREA_MARMARA_SEA = 179;
724
	public static int AREA_SEA_OF_AZOV = 180;
725
	public static int AREA_AEGEAN_SEA = 181;
726
	public static int AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE = 182;
727
	public static int AREA_SOUTH_BALTIC_PROPER = 183;
728
	public static int AREA_BALTIC_PROPER = 184;
729
	public static int AREA_NORTH_BALTIC_PROPER = 185;
730
	public static int AREA_ARCHIPELAGO_SEA = 186;
731
	public static int AREA_BOTHNIAN_SEA = 187;
732
	public static int AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE = 188;
733
	public static int AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE = 189;
734
	public static int AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE = 190;
735
	public static int AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE = 191;
736
	public static int AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE = 192;
737
	public static int AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART = 193;
738
	public static int AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE = 194;
739
	public static int AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE = 195;
740
	public static int AREA_BALEAR_SEA = 196;
741
	public static int AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE = 197;
742
	public static int AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE = 198;
743
	public static int AREA_TRANSCAUCASUS = 199;
744

    
745
	public static int AREA_GEORGIA_G = 200;
746
	public static int AREA_ABKHAZIA = 201;
747
	public static int AREA_ADZARIA = 202;
748

    
749
	public static int AREA_UNITED_KINGDOM = 203;
750
	public static int AREA_DENMARK_COUNTRY = 204;
751
	public static int AREA_TURKEY_COUNTRY = 205;
752
	public static int AREA_SPAIN_COUNTRY = 206;
753
	public static int AREA_GREECE_COUNTRY = 207;
754
	public static int AREA_PORTUGAL_COUNTRY = 208;
755

    
756
	// OccurrenceStatus
757
	public static int STATUS_PRESENT = 1;
758
	public static int STATUS_ABSENT = 2;
759
	public static int STATUS_NATIVE = 3;
760
	public static int STATUS_INTRODUCED = 4;
761
	public static int STATUS_NATURALISED = 5;
762
	public static int STATUS_INVASIVE = 6;
763
	public static int STATUS_MANAGED = 7;
764
	public static int STATUS_DOUBTFUL = 8;
765

    
766
	private final Map<String, Integer> tdwgKeyMap = new HashMap<String, Integer>();
767
	private final Map<Integer, String> areaCacheMap = new HashMap<Integer, String>();
768
	private final Map<Integer, String> languageCacheMap  = new HashMap<Integer, String>();
769
	private final Map<Integer, String> featureCacheMap  = new HashMap<Integer, String>();
770
	private final Map<Integer, String> nameStatusCacheMap  = new HashMap<Integer, String>();
771
	private final Map<Integer, String> qualityStatusCacheMap  = new HashMap<Integer, String>();
772
	private final Map<Integer, String> taxonStatusCacheMap  = new HashMap<Integer, String>();
773
	private final Map<Integer, String> taxRelQualifierCacheMap  = new HashMap<Integer, String>();
774
	private final Map<Integer, String> taxRelZooQualifierCacheMap  = new HashMap<Integer, String>();
775
	private final Map<Integer, String> sourceUseCacheMap  = new HashMap<Integer, String>();
776
	private final Map<Integer, String> fossilStatusCacheMap  = new HashMap<Integer, String>();
777
	private final Map<Integer, String> typeDesigStatusCacheMap  = new HashMap<Integer, String>();
778
	private final Map<Integer, String> sourceCategoryCacheMap  = new HashMap<Integer, String>();
779
	private final Map<Integer, String> occurrenceStatusCacheMap  = new HashMap<Integer, String>();
780
	private final Map<Integer, Map<Integer, String>> rankCacheMap  = new  HashMap<Integer, Map<Integer, String>>();
781
	private final Map<Integer, Map<Integer, String>> rankAbbrevCacheMap  = new  HashMap<Integer, Map<Integer, String>>();
782

    
783

    
784
	private final Source destination;
785

    
786
	public PesiTransformer(Source destination) {
787
		super();
788
		this.destination = destination;
789
		fillMaps();
790
	}
791

    
792
	private void fillMaps() {
793
		//TDWG
794
		try {
795
			String sql = " SELECT AreaId, AreaName, AreaTdwgCode, AreaEmCode, AreaFaEuCode FROM Area";
796
			ResultSet rs = destination.getResultSet(sql);
797
			while (rs.next()){
798
				String tdwg = rs.getString("AreaTdwgCode");
799
				Integer id = rs.getInt("AreaId");
800
				String label = rs.getString("AreaName");
801

    
802
				if (StringUtils.isNotBlank(tdwg)){
803
					this.tdwgKeyMap.put(tdwg, id);
804
				}
805
				this.areaCacheMap.put(id, label);
806
			}
807

    
808
			//rankCache
809
			sql = " SELECT KingdomId, RankId, Rank, RankAbbrev, Kingdom  FROM Rank";
810
			rs = destination.getResultSet(sql);
811
			while (rs.next()){
812
				String rank = rs.getString("Rank");
813
				String abbrev = rs.getString("RankAbbrev");
814
				Integer rankId = rs.getInt("RankId");
815
				Integer kingdomId = rs.getInt("KingdomId");
816
				String kingdom = rs.getString("Kingdom");
817

    
818
				//rank str
819
				Map<Integer, String> kingdomMap = rankCacheMap.get(kingdomId);
820
				if (kingdomMap == null){
821
					kingdomMap = new HashMap<Integer, String>();
822
					rankCacheMap.put(kingdomId, kingdomMap);
823
				}
824
				kingdomMap.put(rankId, rank);
825

    
826
				if (rank.equals("Kingdom")){
827
				    pesiKingdomMap.put(kingdom, kingdomId);
828
				}
829

    
830
				//rank abbrev
831
				Map<Integer, String> kingdomAbbrevMap = rankAbbrevCacheMap.get(kingdomId);
832
				if (kingdomAbbrevMap == null){
833
					kingdomAbbrevMap = new HashMap<Integer, String>();
834
					rankAbbrevCacheMap.put(kingdomId, kingdomAbbrevMap);
835
				}
836
				if (StringUtils.isNotBlank(abbrev)){
837
					kingdomAbbrevMap.put(rankId, abbrev);
838
				}
839

    
840
			}
841

    
842

    
843

    
844

    
845
			//languageCache
846
			fillSingleMap(languageCacheMap,"Language");
847

    
848
			//feature / note category
849
			fillSingleMap(featureCacheMap,"NoteCategory");
850

    
851
			//nameStatusCache
852
			fillSingleMap(nameStatusCacheMap,"NameStatus", "NomStatus");
853

    
854
			//qualityStatusCache
855
			fillSingleMap(qualityStatusCacheMap,"QualityStatus");
856

    
857
			//taxonStatusCache
858
			fillSingleMap(taxonStatusCacheMap,"TaxonStatus", "Status");
859

    
860
			//sourceUse
861
			fillSingleMap(sourceUseCacheMap,"SourceUse");
862

    
863
			//fossil status
864
			fillSingleMap(fossilStatusCacheMap,"FossilStatus");
865

    
866
			//fossil status
867
			fillSingleMap(typeDesigStatusCacheMap,"FossilStatus");
868

    
869
			//fossil status
870
			fillSingleMap(occurrenceStatusCacheMap,"OccurrenceStatus");
871

    
872
			//source category
873
			fillSingleMap(sourceCategoryCacheMap,"SourceCategory", "Category", "SourceCategoryId");
874

    
875
			//RelTaxonQualifier
876
			sql = " SELECT QualifierId, Qualifier, ZoologQualifier FROM RelTaxonQualifier ";
877
			rs = destination.getResultSet(sql);
878
			while (rs.next()){
879
				Integer key = rs.getInt("QualifierId");
880
				String cache = rs.getString("Qualifier");
881
				if (StringUtils.isNotBlank(cache)){
882
					this.taxRelQualifierCacheMap.put(key, cache);
883
				}
884
				String zoologCache = rs.getString("ZoologQualifier");
885
				if (StringUtils.isNotBlank(zoologCache)){
886
					this.taxRelZooQualifierCacheMap.put(key, zoologCache);
887
				}
888
			}
889
			rs = null;
890
		} catch (SQLException e) {
891
			logger.error("SQLException when trying to read area map", e);
892
			e.printStackTrace();
893
		}
894

    
895
	}
896

    
897
	private void fillSingleMap(Map<Integer, String> map, String tableName) throws SQLException {
898
		fillSingleMap(map, tableName, tableName,  tableName + "Id");
899
	}
900

    
901
	private void fillSingleMap(Map<Integer, String> map, String tableName, String attr) throws SQLException {
902
			fillSingleMap(map, tableName, attr,  attr + "Id");
903
	}
904

    
905
	private void fillSingleMap(Map<Integer, String> map, String tableName, String attr, String idAttr) throws SQLException {
906
		String sql;
907
		ResultSet rs;
908
		sql = " SELECT %s, %s FROM %s ";
909
		sql = String.format(sql, idAttr, attr, tableName);
910
		rs = destination.getResultSet(sql);
911
		while (rs.next()){
912
			Integer key = rs.getInt(idAttr);
913
			String cache = rs.getString(attr);
914
			if (StringUtils.isNotBlank(cache)){
915
				map.put(key, cache);
916
			}
917
		}
918
	}
919

    
920
	/**
921
	 * Converts the databaseString to its abbreviation if its known.
922
	 * Otherwise the databaseString is returned.
923
	 * @param databaseString
924
	 * @return
925
	 */
926
	public static String databaseString2Abbreviation(String databaseString) {
927
		String result = databaseString;
928
		if (databaseString.equals("Fauna Europaea database")) {
929
			result = "FaEu";
930
		}
931
		return result;
932
	}
933

    
934

    
935
	/**
936
	 * Returns the OccurrenceStatusId for a given PresenceAbsenceTerm.
937
	 * @param term
938
	 * @return
939
	 * @throws UnknownCdmTypeException
940
	 */
941
	public static Integer presenceAbsenceTerm2OccurrenceStatusId(PresenceAbsenceTerm term) {
942
		Integer result = null;
943
		if (term == null){
944
			return null;
945
		//present
946
		}else if (term.isInstanceOf(PresenceAbsenceTerm.class)) {
947
			PresenceAbsenceTerm presenceTerm = CdmBase.deproxy(term, PresenceAbsenceTerm.class);
948
			if (presenceTerm.equals(PresenceAbsenceTerm.PRESENT()) ||
949
					presenceTerm.equals(PresenceAbsenceTerm.INTRODUCED_DOUBTFULLY_INTRODUCED()) ||
950
					presenceTerm.equals(PresenceAbsenceTerm.NATIVE_DOUBTFULLY_NATIVE())) {
951
				result = STATUS_PRESENT;
952
			} else if (presenceTerm.equals(PresenceAbsenceTerm.NATIVE())) {
953
				result = STATUS_NATIVE;
954
			} else if (presenceTerm.equals(PresenceAbsenceTerm.INTRODUCED()) ||
955
					presenceTerm.equals(PresenceAbsenceTerm.CASUAL()) ||
956
					presenceTerm.equals(PresenceAbsenceTerm.INTRODUCED_UNCERTAIN_DEGREE_OF_NATURALISATION())) {
957
				result = STATUS_INTRODUCED;
958
			} else if (presenceTerm.equals(PresenceAbsenceTerm.NATURALISED())
959
					|| presenceTerm.equals(PresenceAbsenceTerm.NATURALISED())) {
960
				result = STATUS_NATURALISED;
961
			} else if (presenceTerm.equals(PresenceAbsenceTerm.INVASIVE())) {
962
				result = STATUS_INVASIVE;
963
			} else if (presenceTerm.equals(PresenceAbsenceTerm.CULTIVATED())) {
964
				result = STATUS_MANAGED;
965
			} else if (presenceTerm.equals(PresenceAbsenceTerm.PRESENT_DOUBTFULLY())||
966
					presenceTerm.equals(PresenceAbsenceTerm.INTRODUCED_PRESENCE_QUESTIONABLE()) ||
967
					presenceTerm.equals(PresenceAbsenceTerm.NATIVE_PRESENCE_QUESTIONABLE() )) {
968
				result = STATUS_DOUBTFUL;
969
			//absent
970
			}else if (presenceTerm.equals(PresenceAbsenceTerm.ABSENT()) || presenceTerm.equals(PresenceAbsenceTerm.NATIVE_FORMERLY_NATIVE()) ||
971
					presenceTerm.equals(PresenceAbsenceTerm.CULTIVATED_REPORTED_IN_ERROR()) || presenceTerm.equals(PresenceAbsenceTerm.INTRODUCED_REPORTED_IN_ERROR()) ||
972
					presenceTerm.equals(PresenceAbsenceTerm.INTRODUCED_FORMERLY_INTRODUCED()) || presenceTerm.equals(PresenceAbsenceTerm.NATIVE_REPORTED_IN_ERROR() ) ) {
973
				result = STATUS_ABSENT;
974
			} else {
975
				logger.error("PresenceAbsenceTerm could not be translated to datawarehouse occurrence status id: " + presenceTerm.getLabel());
976
			}
977
		}
978
		return result;
979
	}
980

    
981

    
982
	@Override
983
	public String getCacheByPresenceAbsenceTerm(PresenceAbsenceTerm status) throws UndefinedTransformerMethodException {
984
		if (status == null){
985
			return null;
986
		}else{
987
			return this.occurrenceStatusCacheMap.get(getKeyByPresenceAbsenceTerm(status));
988
		}
989
	}
990

    
991
	@Override
992
	public Object getKeyByPresenceAbsenceTerm(PresenceAbsenceTerm status) throws UndefinedTransformerMethodException {
993
		return presenceAbsenceTerm2OccurrenceStatusId(status);
994
	}
995

    
996

    
997

    
998
	@Override
999
	public String getCacheByNamedArea(NamedArea namedArea) throws UndefinedTransformerMethodException {
1000
		NamedArea area = CdmBase.deproxy(namedArea, NamedArea.class);
1001
		if (area == null){
1002
			return null;
1003
		}else{
1004
			return this.areaCacheMap.get(getKeyByNamedArea(area));
1005
		}
1006
	}
1007

    
1008

    
1009
	@Override
1010
	public Object getKeyByNamedArea(NamedArea area) throws UndefinedTransformerMethodException {
1011
		NamedArea namedArea = CdmBase.deproxy(area, NamedArea.class);
1012

    
1013
		if (area == null) {
1014
			return null;
1015
		//TDWG areas
1016
		} else if (area.getVocabulary().getUuid().equals(NamedArea.uuidTdwgAreaVocabulary)) {
1017
			String abbrevLabel = namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel();
1018
			Integer result = this.tdwgKeyMap.get(abbrevLabel);
1019
			if (result == null){
1020
				logger.warn("Unknown TDWGArea: " + area.getTitleCache());
1021
			}
1022
			return result;
1023
		//countries
1024
		}else if (namedArea.isInstanceOf(Country.class)){
1025
			if (namedArea.equals(Country.UKRAINE())) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
1026
			else if (namedArea.equals(Country.AZERBAIJANREPUBLICOF())) { return AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1027
			else if (namedArea.equals(Country.GEORGIA())) { return AREA_GEORGIA; }
1028
			else if (namedArea.equals(Country.RUSSIANFEDERATION())) { return AREA_THE_RUSSIAN_FEDERATION; }
1029
			else if (namedArea.equals(Country.UNITEDKINGDOMOFGREATBRITAINANDNORTHERNIRELAND())) { return AREA_UNITED_KINGDOM; }
1030
			else if (namedArea.equals(Country.DENMARKKINGDOMOF())) { return AREA_DENMARK_COUNTRY; }
1031
			else if (namedArea.equals(Country.TURKEYREPUBLICOF())) { return AREA_TURKEY_COUNTRY; }
1032
			else {
1033
				logger.warn("Unknown Country: " + area.getTitleCache());
1034
			}
1035
		}else{  //Non TDWG, non country
1036
			//EM
1037
//			if ( namedArea.getUuid().equals(BerlinModelTransformer.uuidMadeira)){ return AREA_MADEIRA; }
1038
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidDesertas)) { return AREA_DESERTAS; }
1039
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPortoSanto)) { return AREA_PORTO_SANTO; }
1040
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFlores)) { return AREA_FLORES; }
1041
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCorvo)) { return AREA_CORVO; }
1042
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFaial)) { return AREA_FAIAL; }
1043
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGraciosa)) { return AREA_GRACIOSA; }
1044
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSaoJorge)) { return AREA_SAO_JORGE; }
1045
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSaoMiguel)) { return AREA_SAO_MIGUEL; }
1046
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPico)) { return AREA_PICO; }
1047
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSantaMaria)) { return AREA_SANTA_MARIA; }
1048
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTerceira)) { return AREA_TERCEIRA; }
1049
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGranCanaria)) { return AREA_GRAN_CANARIA; }
1050
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFuerteventura)) { return AREA_FUERTEVENTURA_WITH_LOBOS; }
1051
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGomera)) { return AREA_GOMERA; }
1052
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHierro)) { return AREA_HIERRO; }
1053
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLanzaroteWithGraciosa)) { return AREA_LANZAROTE_WITH_GRACIOSA; }
1054
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLaPalma)) { return AREA_LA_PALMA; }
1055
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTenerife)) { return AREA_TENERIFE; }
1056
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidIbizaWithFormentera)) { return AREA_IBIZA_WITH_FORMENTERA; }
1057
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMallorca)) { return AREA_MALLORCA; }
1058
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMenorca)) { return AREA_MENORCA; }
1059
//
1060
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUssr)) { return AREA_FORMER_USSR; }
1061
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaBaltic)) { return AREA_RUSSIA_BALTIC; }
1062
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthEast)) { return AREA_RUSSIA_SOUTHEAST; }
1063
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaSouthWest)) { return AREA_RUSSIA_SOUTHWEST; }
1064
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaCentral)) { return AREA_RUSSIA_CENTRAL; }
1065
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRussiaNorthern)) { return AREA_RUSSIA_NORTHERN; }
1066
//
1067
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkey)) { return AREA_TURKEY; }
1068
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEastAegeanIslands)) { return AREA_EAST_AEGEAN_ISLANDS; }
1069
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTurkishEastAegeanIslands)) { return AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1070
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSerbiaMontenegro)) { return AREA_SERBIA_WITH_MONTENEGRO; }
1071
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSerbia)) { return AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
1072
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCaucasia)) { return AREA_CAUCASUS_REGION; }
1073
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUkraineAndCrimea)) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
1074
//			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAzerbaijanNakhichevan)) { return AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1075

    
1076
			if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEM)) {
1077
//				logger.warn("E+M area not available in PESI");
1078
				return null;
1079
			}
1080
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEUR)) { logger.warn("EUR area not available in PESI"); return null; }
1081
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAb)) { return AREA_AZERBAIJAN_INCLUDING_NAKHICHEVAN; }
1082
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAb_A)) { return AREA_AZERBAIJAN; }
1083
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAb_N)) { return AREA_NAKHICHEVAN; }
1084
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAE)) { return AREA_EAST_AEGEAN_ISLANDS; }
1085
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAE_G)) { return AREA_GREEK_EAST_AEGEAN_ISLANDS; }
1086
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAE_T)) { return AREA_TURKISH_EAST_AEGEAN_ISLANDS; }
1087
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAg)) { return AREA_ALGERIA; }
1088
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAl)) { return AREA_ALBANIA; }
1089
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAr)) { return AREA_ARMENIA; }
1090
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAu)) { return AREA_AUSTRIA_WITH_LIECHTENSTEIN; }
1091
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAu_A)) { return AREA_AUSTRIA; }
1092
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAu_L)) { return AREA_LIECHTENSTEIN; }
1093
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAz)) { return AREA_AZORES; }
1094
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAz_C)) { return AREA_CORVO; }
1095
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAz_F)) { return AREA_FAIAL; }
1096
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAz_G)) { return AREA_GRACIOSA; }
1097
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAz_J)) { return AREA_SAO_JORGE; }
1098
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAz_L)) { return AREA_FLORES; }
1099
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAz_M)) { return AREA_SAO_MIGUEL; }
1100
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAz_P)) { return AREA_PICO; }
1101
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAz_S)) { return AREA_SANTA_MARIA; }
1102
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidAz_T)) { return AREA_TERCEIRA; }
1103
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBe)) { return AREA_BELGIUM_WITH_LUXEMBOURG; }
1104
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBe_B)) { return AREA_BELGIUM; }
1105
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBe_L)) { return AREA_LUXEMBOURG; }
1106
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBH)) { return AREA_BOSNIA_HERZEGOVINA; }
1107
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBl)) { return AREA_BALEARES; }
1108
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBl_I)) { return AREA_IBIZA_WITH_FORMENTERA; }
1109
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBl_M)) { return AREA_MALLORCA; }
1110
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBl_N)) { return AREA_MENORCA; }
1111
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBr)) { return AREA_GREAT_BRITAIN; }
1112
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBt)) { return AREA_BALTIC_STATES_ESTONIA_LATVIA_LITHUANIA_AND_KALININGRAD_REGION; }
1113
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBu)) { return AREA_BULGARIA; }
1114
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidBy)) { return AREA_BELARUS; }
1115
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCa)) { return AREA_CANARY_ISLANDS; }
1116
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCa_C)) { return AREA_GRAN_CANARIA; }
1117
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCa_F)) { return AREA_FUERTEVENTURA_WITH_LOBOS; }
1118
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCa_G)) { return AREA_GOMERA; }
1119
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCa_H)) { return AREA_HIERRO; }
1120
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCa_L)) { return AREA_LANZAROTE_WITH_GRACIOSA; }
1121
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCa_P)) { return AREA_LA_PALMA; }
1122
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCa_T)) { return AREA_TENERIFE; }
1123
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCc)) { return AREA_CAUCASUS_REGION; }
1124
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCg)) { return AREA_MONTENEGRO; }
1125
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCo)) { return AREA_CORSE; }
1126
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCr)) { return AREA_CRETE_WITH_KARPATHOS_KASOS_AND_GAVDHOS; }
1127
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCs)) { return AREA_CZECH_REPUBLIC; }
1128
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCt)) { return AREA_CROATIA; }
1129
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCy)) { return AREA_CYPRUS; }
1130
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidCz)) { return AREA_FORMER_CZECHOSLOVAKIA; }
1131
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidDa)) { return AREA_DENMARK_WITH_BORNHOLM; }
1132
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEg)) { return AREA_EGYPT; }
1133
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidEs)) { return AREA_ESTONIA; }
1134
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFa)) { return AREA_FAROE_ISLANDS; }
1135
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidFe)) { return AREA_FINLAND_WITH_AHVENANMAA; }
1136
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGa)) { return AREA_FRANCE; }
1137
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGa_C)) { return AREA_CHANNEL_ISLANDS; }
1138
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGa_F)) { return AREA_FRENCH_MAINLAND; }
1139
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGa_M)) { return AREA_MONACO; }
1140

    
1141
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGe)) { return AREA_GERMANY; }
1142
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGg)) { return AREA_GEORGIA; }
1143

    
1144
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGg_G)) { return AREA_GEORGIA_G; }
1145
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGg_A)) { return AREA_ABKHAZIA; }
1146
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGg_D)) { return AREA_ADZARIA; }
1147

    
1148
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidGr)) { return AREA_GREECE_WITH_CYCLADES_AND_MORE_ISLANDS; }
1149
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHb)) { return AREA_IRELAND; }
1150
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHb_E)) { return AREA_REPUBLIC_OF_IRELAND; }
1151
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHb_N)) { return AREA_NORTHERN_IRELAND; }
1152
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHe)) { return AREA_SWITZERLAND; }
1153
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHo)) { return AREA_NETHERLANDS; }
1154
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHs)) { return AREA_SPAIN; }
1155
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHs_A)) { return AREA_ANDORRA; }
1156
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHs_G)) { return AREA_GIBRALTAR; }
1157
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHs_S)) { return AREA_KINGDOM_OF_SPAIN; }
1158
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidHu)) { return AREA_HUNGARY; }
1159
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidIJ)) { return AREA_ISRAEL_JORDAN; }
1160
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidIr)) { return AREA_ISRAEL; }
1161
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidIs)) { return AREA_ICELAND; }
1162
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidIt)) { return AREA_ITALY; }
1163
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidIt_I)) { return AREA_ITALIAN_MAINLAND; }
1164
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidIt_S)) { return AREA_SAN_MARINO; }
1165
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidJo)) { return AREA_JORDAN; }
1166
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidJu)) { return AREA_FORMER_JUGOSLAVIA; }
1167
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLa)) { return AREA_LATVIA; }
1168
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLe)) { return AREA_LEBANON; }
1169
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLi)) { return AREA_LIBYA; }
1170
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLS)) { return AREA_LEBANON_SYRIA; }
1171
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLt)) { return AREA_LITHUANIA; }
1172
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidLu)) { return AREA_PORTUGUESE_MAINLAND; }
1173
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMa)) { return AREA_MOROCCO; }
1174
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMd)) { return AREA_MADEIRA; }
1175
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMd_D)) { return AREA_DESERTAS; }
1176
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMd_M)) { return AREA_MADEIRA; }
1177
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMd_P)) { return AREA_PORTO_SANTO; }
1178
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMk)) { return AREA_THE_FORMER_JUGOSLAV_REPUBLIC_OF_MAKEDONIJA; }
1179
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidMo)) { return AREA_MOLDOVA; }
1180
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidNo)) { return AREA_NORWEGIAN_MAINLAND; }
1181
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidPo)) { return AREA_POLAND; }
1182
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRf)) { return AREA_THE_RUSSIAN_FEDERATION; }
1183
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRf_A)) { return AREA_NOVAYA_ZEMLYA_AND_FRANZ_JOSEPH_LAND; }
1184
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRf_C)) { return AREA_CENTRAL_EUROPEAN_RUSSIA; }
1185
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRf_CS)) { return AREA_NORTH_CAUCASUS; }
1186
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRf_E)) { return AREA_EASTERN_EUROPEAN_RUSSIA; }
1187
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRf_K)) { return AREA_KALININGRAD; }
1188
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRf_N)) { return AREA_NORTHERN_EUROPEAN_RUSSIA; }
1189
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRf_NW)) { return AREA_NORTHWEST_EUROPEAN_RUSSIA; }
1190
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRf_S)) { return AREA_SOUTH_EUROPEAN_RUSSIA; }
1191
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRm)) { return AREA_ROMANIA; }
1192
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRs)) { return AREA_FORMER_USSR; }
1193
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRs_B)) { return AREA_RUSSIA_BALTIC; }
1194
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRs_C)) { return AREA_RUSSIA_CENTRAL; }
1195
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRs_E)) { return AREA_RUSSIA_SOUTHEAST; }
1196
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRs_K)) { return AREA_CRIMEA; }
1197
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRs_N)) { return AREA_RUSSIA_NORTHERN; }
1198
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidRs_W)) { return AREA_RUSSIA_SOUTHWEST; }
1199
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSa)) { return AREA_SARDEGNA; }
1200
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSb)) { return AREA_SVALBARD_WITH_BJORNOYA_AND_JAN_MAYEN; }
1201
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSg)) { return AREA_SELVAGENS_ISLANDS; }
1202
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSi)) { return AREA_SICILY_WITH_MALTA; }
1203
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSi_M)) { return AREA_MALTA; }
1204
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSi_S)) { return AREA_SICILY; }
1205
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSk)) { return AREA_SLOVAKIA; }
1206
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSl)) { return AREA_SLOVENIA; }
1207
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSM)) { return AREA_SERBIA_WITH_MONTENEGRO; }
1208
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSn)) { return AREA_SINAI; }
1209
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSr)) { return AREA_SERBIA_INCLUDING_VOJVODINA_AND_WITH_KOSOVO; }
1210
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSu)) { return AREA_SWEDEN; }
1211
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidSy)) { return AREA_SYRIA; }
1212
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTcs)) { return AREA_TRANSCAUCASUS; }
1213
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTn)) { return AREA_TUNISIA; }
1214
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTu)) { return AREA_TURKEY; }
1215
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTu_A)) { return AREA_ASIATIC_TURKEY; }
1216
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidTu_E)) { return AREA_EUROPEAN_TURKEY; }
1217
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUk)) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
1218
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUk_K)) { return AREA_CRIMEA; }
1219
			else if (namedArea.getUuid().equals(BerlinModelTransformer.uuidUk_U)) { return AREA_UKRAINE; }
1220

    
1221

    
1222

    
1223
			/*FE
1224
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaAFR)) { return AREA_AFRO_TROPICAL_REGION; }
1225
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaAUS)) { return AREA_AUSTRALIAN_REGION; }
1226
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaEPA)) { return AREA_EAST_PALAEARCTIC; }
1227
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_AEG)) { return AREA_NORTH_AEGEAN_ISLANDS; }
1228
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_CYC)) { return AREA_CYCLADES_ISLANDS; }
1229
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_DOD)) { return AREA_DODECANESE_ISLANDS; }
1230
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_CR)) { return AREA_CRETE; }
1231
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaGR_GRC)) { return AREA_GREEK_MAINLAND; }
1232
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNAF)) { return AREA_NORTHERN_AFRICA; }
1233
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNEA)) { return AREA_NEARCTIC_REGION; }
1234
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNEO)) { return AREA_NEOTROPICAL_REGION; }
1235
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaNRE)) { return AREA_NEAR_EAST; }
1236
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaORR)) { return AREA_ORIENTAL_REGION; }
1237
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaUA)) { return AREA_UKRAINE_INCLUDING_CRIMEA; }
1238
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaRU_FJL)) { return AREA_FRANZ_JOSEF_LAND; }
1239
			else if (namedArea.getUuid().equals(FaunaEuropaeaTransformer.uuidAreaRU_NOZ)) { return AREA_NOVAYA_ZEMLYA; }
1240
*/
1241

    
1242
			//ERMS
1243
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEuropeanMarineWaters)) { return AREA_EUROPEAN_MARINE_WATERS; }
1244
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("MES") ||
1245
					(namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea))) { return AREA_MEDITERRANEAN_SEA; } // abbreviated label missing
1246
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWhiteSea)) { return AREA_WHITE_SEA; }
1247
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthSea)) { return AREA_NORTH_SEA; }
1248
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticSea)) { return AREA_BALTIC_SEA; }
1249
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("BLS") ||
1250
					(namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return AREA_BLACK_SEA; } // abbreviated label missing
1251
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return AREA_BARENTS_SEA; }
1252
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
1253
					(namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return AREA_CASPIAN_SEA; } // abbreviated label missingelse if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1254
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1255
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
1256
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return AREA_ENGLISH_CHANNEL; }
1257
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAdriaticSea)) { return AREA_ADRIATIC_SEA; }
1258
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBiscayBay)) { return AREA_BISCAY_BAY; }
1259
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDutchExclusiveEconomicZone)) { return AREA_DUTCH_EXCLUSIVE_ECONOMIC_ZONE; }
1260
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
1261
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1262
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1263
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1264
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return AREA_TIRRENO_SEA; }
1265
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
1266
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
1267
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishSea)) { return AREA_IRISH_SEA; }
1268
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidItalianExclusiveEconomicZone)) { return AREA_ITALIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1269
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianSea)) { return AREA_NORWEGIAN_SEA; }
1270
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMoroccanExclusiveEconomicZone)) { return AREA_MOROCCAN_EXCLUSIVE_ECONOMIC_ZONE; }
1271
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorwegianExclusiveEconomicZone)) { return AREA_NORWEGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1272
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSkagerrak)) { return AREA_SKAGERRAK; }
1273
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisianExclusiveEconomicZone)) { return AREA_TUNISIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1274
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidWaddenSea)) { return AREA_WADDEN_SEA; }
1275
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBeltSea)) { return AREA_BELT_SEA; }
1276
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMarmaraSea)) { return AREA_MARMARA_SEA; }
1277
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaofAzov)) { return AREA_SEA_OF_AZOV; }
1278
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAegeanSea)) { return AREA_AEGEAN_SEA; }
1279
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgarianExclusiveEconomicZone)) { return AREA_BULGARIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1280
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthBalticproper)) { return AREA_SOUTH_BALTIC_PROPER; }
1281
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalticProper)) { return AREA_BALTIC_PROPER; }
1282
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthBalticproper)) { return AREA_NORTH_BALTIC_PROPER; }
1283
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidArchipelagoSea)) { return AREA_ARCHIPELAGO_SEA; }
1284
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBothnianSea)) { return AREA_BOTHNIAN_SEA; }
1285
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGermanExclusiveEconomicZone)) { return AREA_GERMAN_EXCLUSIVE_ECONOMIC_ZONE; }
1286
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSwedishExclusiveEconomicZone)) { return AREA_SWEDISH_EXCLUSIVE_ECONOMIC_ZONE; }
1287
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUkrainianExclusiveEconomicZone)) { return AREA_UKRAINIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1288
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMadeiranExclusiveEconomicZone)) { return AREA_MADEIRAN_EXCLUSIVE_ECONOMIC_ZONE; }
1289
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidLebaneseExclusiveEconomicZone)) { return AREA_LEBANESE_EXCLUSIVE_ECONOMIC_ZONE; }
1290
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZoneMediterraneanpart)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE_MEDITERRANEAN_PART; }
1291
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonianExclusiveEconomicZone)) { return AREA_ESTONIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1292
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatianExclusiveEconomicZone)) { return AREA_CROATIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1293
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return AREA_BALEAR_SEA; }
1294
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
1295
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1296
			else {
1297
				logger.warn("Unknown NamedArea Area: " + area.getTitleCache());
1298
			}
1299

    
1300
		}
1301
		return null;
1302
	}
1303

    
1304

    
1305
	/**
1306
	 * Returns the PESI SourceUseId for a given CDM sourceUseId.
1307
	 * @param sourceUseId
1308
	 * @return
1309
	 */
1310
	public static Integer sourceUseIdSourceUseId(Integer sourceUseId) {
1311
		// TODO: CDM sourceUseId and PESI sourceUseId are equal for now.
1312
		Integer result = null;
1313
		switch (sourceUseId) {
1314
			case 3: return ADDITIONAL_SOURCE;
1315
			case 4: return SOURCE_OF_SYNONYMY;
1316
			case 8: return NOMENCLATURAL_REFERENCE;
1317
		}
1318
		return result;
1319
	}
1320

    
1321

    
1322
	/**
1323
	 * Returns the FossilStatusCache to a given Fossil.
1324
	 * @param fossil
1325
	 * @return
1326
	 */
1327
	public static String fossil2FossilStatusCache(DerivedUnit fossil) {
1328
		String result = null;
1329
		return result;
1330
	}
1331

    
1332
	/**
1333
	 * Returns the FossilStatusId to a given Fossil.
1334
	 * @param fossil
1335
	 * @return
1336
	 */
1337
	public static Integer fossil2FossilStatusId(DerivedUnit fossil) {
1338
		Integer result = null;
1339
		return result;
1340
	}
1341

    
1342

    
1343

    
1344
	@Override
1345
	public Object getKeyByLanguage(Language language) throws UndefinedTransformerMethodException {
1346
		return language2LanguageId(language);
1347
	}
1348

    
1349
	@Override
1350
	public String getCacheByLanguage(Language language) throws UndefinedTransformerMethodException {
1351
		if (language == null){
1352
			return null;
1353
		}else{
1354
			return this.languageCacheMap.get(getKeyByLanguage(language));
1355
		}
1356
	}
1357

    
1358

    
1359
	/**
1360
	 * Returns the identifier of the given Language.
1361
	 * @param language
1362
	 * @return
1363
	 */
1364
	public static Integer language2LanguageId(Language language) {
1365
		if (language == null ) {
1366
			return null;
1367
		}
1368
		if (language.equals(Language.ALBANIAN())) {
1369
			return Language_Albanian;
1370
		} else if (language.equals(Language.ARABIC())) {
1371
			return Language_Arabic;
1372
		} else if (language.equals(Language.ARMENIAN())) {
1373
			return Language_Armenian;
1374
		} else if (language.equals(Language.AZERBAIJANI())) {
1375
			return Language_Azerbaijan;
1376
		} else if (language.equals(Language.BELORUSSIAN())) {
1377
			return Language_Belarusian;
1378
		} else if (language.equals(Language.BULGARIAN())) {
1379
			return Language_Bulgarian;
1380
		} else if (language.equals(Language.CATALAN_VALENCIAN())) {
1381
			return Language_Catalan;
1382
		} else if (language.equals(Language.CROATIAN())) {
1383
			return Language_Croat;
1384
		} else if (language.equals(Language.CZECH())) {
1385
			return Language_Czech;
1386
		} else if (language.equals(Language.DANISH())) {
1387
			return Language_Danish;
1388
		} else if (language.equals(Language.DUTCH_MIDDLE())) {
1389
			return Language_Dutch;
1390
		} else if (language.equals(Language.ENGLISH())) {
1391
			return Language_English;
1392
//		} else if (language.equals(Language.)) {
1393
//			return Language_Euskera;
1394
		} else if (language.equals(Language.ESTONIAN())) {
1395
			return Language_Estonian;
1396
		} else if (language.equals(Language.FINNISH())) {
1397
			return Language_Finnish;
1398
		} else if (language.equals(Language.FRENCH())) {
1399
			return Language_French;
1400
		} else if (language.equals(Language.GEORGIAN())) {
1401
			return Language_Georgian;
1402
		} else if (language.equals(Language.GERMAN())) {
1403
			return Language_German;
1404
		} else if (language.equals(Language.GREEK_MODERN())) {
1405
			return Language_Greek;
1406
		} else if (language.equals(Language.HUNGARIAN())) {
1407
			return Language_Hungarian;
1408
		} else if (language.equals(Language.ICELANDIC())) {
1409
			return Language_Icelandic;
1410
		} else if (language.equals(Language.IRISH())) {
1411
			return Language_Irish_Gaelic;
1412
		} else if (language.equals(Language.HEBREW())) {
1413
			return Language_Israel_Hebrew;
1414
		} else if (language.equals(Language.ITALIAN())) {
1415
			return Language_Italian;
1416
		} else if (language.equals(Language.LATVIAN())) {
1417
			return Language_Latvian;
1418
		} else if (language.equals(Language.LITHUANIAN())) {
1419
			return Language_Lithuanian;
1420
		} else if (language.equals(Language.MACEDONIAN())) {
1421
			return Language_Macedonian;
1422
		} else if (language.equals(Language.MALTESE())) {
1423
			return Language_Maltese;
1424
		} else if (language.equals(Language.MOLDAVIAN())) {
1425
			return Language_Moldovian;
1426
		} else if (language.equals(Language.NORWEGIAN())) {
1427
			return Language_Norwegian;
1428
		} else if (language.equals(Language.POLISH())) {
1429
			return Language_Polish;
1430
		} else if (language.equals(Language.PORTUGUESE())) {
1431
			return Language_Portuguese;
1432
		} else if (language.equals(Language.ROMANIAN())) {
1433
			return Language_Roumanian;
1434
		} else if (language.equals(Language.RUSSIAN())) {
1435
			return Language_Russian;
1436
//		} else if (language.equals(Language.)) {
1437
//			return Language_Russian_Caucasian;
1438
//		} else if (language.equals(Language.)) {
1439
//			return Language_Russian_Altaic_kalmyk_oirat;
1440
//		} else if (language.equals(Language.)) {
1441
//			return Language_Russian_Altaic_karachay_balkar;
1442
//		} else if (language.equals(Language.)) {
1443
//			return Language_Russian_Altaic_kumyk;
1444
//		} else if (language.equals(Language.)) {
1445
//			return Language_Russian_Altaic_nogai;
1446
//		} else if (language.equals(Language.)) {
1447
//			return Language_Russian_Altaic_north_azerbaijani;
1448
//		} else if (language.equals(Language.)) {
1449
//			return Language_Russian_Indo_european_russian;
1450
//		} else if (language.equals(Language.)) {
1451
//			return Language_Russian_Indo_european_kalmyk_oirat;
1452
//		} else if (language.equals(Language.)) {
1453
//			return Language_Russian_Indo_european_osetin;
1454
//		} else if (language.equals(Language.)) {
1455
//			return Language_Russian_North_caucasian_abaza;
1456
//		} else if (language.equals(Language.)) {
1457
//			return Language_Russian_North_caucasian_adyghe;
1458
//		} else if (language.equals(Language.)) {
1459
//			return Language_Russian_North_caucasian_chechen;
1460
//		} else if (language.equals(Language.)) {
1461
//			return Language_Russian_North_caucasian_kabardian;
1462
//		} else if (language.equals(Language.)) {
1463
//			return Language_Russian_North_caucasian_lak;
1464
//		} else if (language.equals(Language.)) {
1465
//			return Language_Russian_North_caucasian_avar;
1466
//		} else if (language.equals(Language.)) {
1467
//			return Language_Russian_North_caucasian_in;
1468
//		} else if (language.equals(Language.)) {
1469
//			return Language_Russian_Uralic_chuvash;
1470
//		} else if (language.equals(Language.)) {
1471
//			return Language_Russian_Uralic_udmurt;
1472
		} else if (language.equals(Language.SERBIAN())) {
1473
			return Language_Serbian;
1474
		} else if (language.equals(Language.SLOVAK())) {
1475
			return Language_Slovak;
1476
		} else if (language.equals(Language.SLOVENIAN())) {
1477
			return Language_Slovene;
1478
		} else if (language.equals(Language.SPANISH_CASTILIAN())) {
1479
			return Language_Spanish_Castillian;
1480
		} else if (language.equals(Language.SWEDISH())) {
1481
			return Language_Swedish;
1482
		} else if (language.equals(Language.TURKISH())) {
1483
			return Language_Turkish;
1484
		} else if (language.equals(Language.UKRAINIAN())) {
1485
			return Language_Ukraine;
1486
		} else if (language.equals(Language.WELSH())) {
1487
			return Language_Welsh;
1488
		} else if (language.equals(Language.CORSICAN())) {
1489
			return Language_Corsican;
1490
		} else {
1491
			logger.debug("Unknown Language: " + language.getTitleCache());
1492
			return null;
1493
		}
1494
	}
1495

    
1496
	/**
1497
	 * Returns the NodeCategoryCache for a given TextData.
1498
	 * @param feature
1499
	 * @return
1500
	 */
1501
	@Override
1502
    public String getCacheByFeature(Feature feature) {
1503
		if (feature == null){
1504
			return null;
1505
		}else{
1506
			return this.featureCacheMap.get(feature2NoteCategoryFk(feature));
1507
		}
1508
	}
1509

    
1510
	/**
1511
	 * Returns the NodeCategoryFk for a given TextData.
1512
	 * @param feature
1513
	 * @return
1514
	 */
1515
	public static Integer feature2NoteCategoryFk(Feature feature) {
1516
		if (feature == null) {
1517
			return null;
1518
		}
1519

    
1520
		if (feature.equals(Feature.DESCRIPTION())) {
1521
			return NoteCategory_description;
1522
		} else if (feature.equals(Feature.ECOLOGY())) {
1523
			return NoteCategory_ecology;
1524
		} else if (feature.equals(Feature.PHENOLOGY())) {
1525
			return NoteCategory_phenology;
1526
		} else if (feature.equals(Feature.COMMON_NAME())) {
1527
			return NoteCategory_Common_names;
1528
		} else if (feature.equals(Feature.OCCURRENCE())) {
1529
			return NoteCategory_Occurrence;
1530
		} else if (feature.equals(Feature.DISTRIBUTION())) {
1531
			return NoteCategory_Distribution;
1532
		} else if (feature.getUuid().equals(ErmsTransformer.uuidRemark)) {
1533
			return NoteCategory_Remark;
1534
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAdditionalinformation)) {
1535
			return NoteCategory_Additional_information;
1536
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSpelling)) {
1537
			return NoteCategory_Spelling;
1538
		} else if (feature.getUuid().equals(ErmsTransformer.uuidDateofPublication)) {
1539
			return NoteCategory_Date_of_publication;
1540
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSystematics)) {
1541
			return NoteCategory_Systematics;
1542
		} else if (feature.getUuid().equals(ErmsTransformer.uuidClassification)) {
1543
			return NoteCategory_Classification;
1544
		} else if (feature.getUuid().equals(ErmsTransformer.uuidEnvironment)) {
1545
			return NoteCategory_Environment;
1546
		} else if (feature.getUuid().equals(ErmsTransformer.uuidHabitat)) {
1547
			return NoteCategory_Habitat;
1548
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAuthority)) {
1549
			return NoteCategory_Authority;
1550
		} else if (feature.getUuid().equals(ErmsTransformer.uuidMorphology)) {
1551
			return NoteCategory_Morphology;
1552
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemarks)) {
1553
			return NoteCategory_Taxonomic_Remarks;
1554
		} else if (feature.getUuid().equals(ErmsTransformer.uuidNote)){
1555
			return NoteCategory_Note;
1556
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomy)) {
1557
			return NoteCategory_Taxonomy;
1558
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicstatus)) {
1559
			return NoteCategory_Taxonomic_status;
1560
		} else if (feature.getUuid().equals(ErmsTransformer.uuidStatus)){
1561
			return NoteCategory_Status;
1562
		} else if (feature.getUuid().equals(ErmsTransformer.uuidRank)) {
1563
			return NoteCategory_Rank;
1564
		} else if (feature.getUuid().equals(ErmsTransformer.uuidHomonymy)) {
1565
			return NoteCategory_Homonymy;
1566
		} else if (feature.getUuid().equals(ErmsTransformer.uuidNomenclature)) {
1567
			return NoteCategory_Nomenclature;
1568
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTaxonomicRemark)) {
1569
			return NoteCategory_Taxonomic_Remark;
1570
		} else if (feature.getUuid().equals(ErmsTransformer.uuidAcknowledgments)){
1571
			return NoteCategory_Acknowledgments;
1572
		} else if (feature.getUuid().equals(ErmsTransformer.uuidOriginalpublication)) {
1573
			return NoteCategory_Original_publication;
1574
		} else if (feature.getUuid().equals(ErmsTransformer.uuidTypelocality)) {
1575
			return NoteCategory_Type_locality;
1576
		} else if (feature.getUuid().equals(ErmsTransformer.uuidValidity)) {
1577
			return NoteCategory_Validity;
1578
		} else if (feature.getUuid().equals(ErmsTransformer.uuidIdentification)) {
1579
			return NoteCategory_Identification;
1580
		} else if (feature.getUuid().equals(ErmsTransformer.uuidSynonymy)) {
1581
			return NoteCategory_Synonymy;
1582
		} else if (feature.equals(Feature.CITATION())) {
1583
			return null;  //citations are handled differently
1584
		} else if (feature.getUuid().equals(BerlinModelTransformer.uuidFeatureMaps)){
1585
			return NoteCategory_Link_to_maps;
1586
		} else if (feature.getUuid().equals(BerlinModelTransformer.uuidFeatureUse)){
1587
			return NoteCategory_Use;
1588
		} else if (feature.getUuid().equals(BerlinModelTransformer.uuidFeatureComments)){
1589
			return NoteCategory_Comments;
1590
		} else if (feature.getUuid().equals(BerlinModelTransformer.uuidFeatureConservationStatus)){
1591
			return NoteCategory_Conservation_Status;
1592

    
1593
		//E+M
1594
		} else if (feature.getUuid().equals(BerlinModelTransformer.uuidFeatureDistrEM)){
1595
			return NoteCategory_general_distribution_euromed;
1596
		} else if (feature.getUuid().equals(BerlinModelTransformer.uuidFeatureDistrWorld)){
1597
			return NoteCategory_general_distribution_world;
1598
		} else if (feature.getUuid().equals(BerlinModelTransformer.uuidFeatureEditorBrackets)){
1599
			return NoteCategory_Editor_Brackets;
1600
		} else if (feature.getUuid().equals(BerlinModelTransformer.uuidFeatureEditorParenthesis)){
1601
			return NoteCategory_Editor_Parenthesis;
1602
		} else if (feature.getUuid().equals(BerlinModelTransformer.uuidFeatureInedited)){
1603
			return NoteCategory_Inedited;
1604
		} else if (feature.getUuid().equals(BerlinModelTransformer.uuidFeatureCommentsEditing)){
1605
			return NoteCategory_Comments_on_editing_process;
1606

    
1607

    
1608
			// TODO: Unknown NoteCategories
1609
//			NoteCategory_Common_names = 12;
1610
//			NoteCategory_Maps =14;
1611

    
1612
//			NoteCategory_Link_to_images = 21;
1613
//			NoteCategory_Link_to_taxonomy = 22;
1614
//			NoteCategory_Link_to_general_information = 23;
1615
//			NoteCategory_undefined_link = 24;
1616
//			NoteCategory_Editor_Braces = 249;
1617

    
1618
//			NoteCategory_Publication_date = 254;
1619
//			NoteCategory_Distribution = 278;
1620
//			NoteCategory_Biology = 281;
1621
//			NoteCategory_Diagnosis	= 282;
1622
//			NoteCategory_Host = 283;
1623

    
1624
		}else{
1625
			logger.warn("Unhandled Feature: " + feature.getTitleCache());
1626
			return null;
1627
		}
1628
	}
1629

    
1630
	/**
1631
	 * Returns the string representation for a given rank.
1632
	 * @param rank
1633
	 * @param pesiKingdomId
1634
	 * @return
1635
	 */
1636
	public String getCacheByRankAndKingdom(Rank rank, Integer pesiKingdomId) {
1637
		if (rank == null){
1638
			return null;
1639
		}else{
1640
			return this.rankCacheMap.get(pesiKingdomId).get(rank2RankId(rank, pesiKingdomId));
1641
		}
1642
	}
1643

    
1644
	/**
1645
	 * Returns the abbreviation for a given rank.
1646
	 * Currently unused.
1647
	 * @param rank
1648
	 * @param pesiKingdomId
1649
	 * @return
1650
	 */
1651
	public String getCacheAbbrevByRankAndKingdom(Rank rank, Integer pesiKingdomId) {
1652
		if (rank == null){
1653
			return null;
1654
		}else{
1655
			return this.rankAbbrevCacheMap.get(pesiKingdomId).get(rank2RankId(rank, pesiKingdomId));
1656
		}
1657
	}
1658

    
1659
	/**
1660
	 * Returns the identifier of a PESI specific kingdom for a given CDM nomenclatural code.
1661
	 * @param nomenclaturalCode
1662
	 * @return KINGDOM_ANIMALIA for NomenclaturalCode.ICZN, KINGDOM_PLANTAE for NomenclaturalCode.ICBN
1663
	 */
1664
	public static Integer nomenClaturalCode2Kingdom(NomenclaturalCode nomenclaturalCode) {
1665
		Integer result = null;
1666
		// TODO: This needs to be refined. For now we differentiate between Animalia and Plantae only.
1667
		if (nomenclaturalCode.equals(NomenclaturalCode.ICZN)) {
1668
			result = KINGDOM_ANIMALIA;
1669
		} else if (nomenclaturalCode.equals(NomenclaturalCode.ICNAFP)) {
1670
			result = KINGDOM_PLANTAE;
1671
		} else if (nomenclaturalCode.equals(NomenclaturalCode.ICNB)) {
1672
			result = KINGDOM_BACTERIA;
1673
//		} else if (nomenclaturalCode.equals(NomenclaturalCode.)) { // Biota
1674
//			result =
1675
		} else {
1676
			logger.error("NomenclaturalCode not yet considered: " + nomenclaturalCode.getUuid() + " (" +  nomenclaturalCode.getTitleCache() + ")");
1677
		}
1678
		return result;
1679
	}
1680

    
1681
	/**
1682
	 * Returns the RankId for a Rank.
1683
	 * @param rank
1684
	 * @return
1685
	 */
1686
	public static Integer rank2RankId (Rank rank, Integer pesiKingdomId) {
1687
		Integer result = null;
1688
		if (rank == null) {
1689
			return null;
1690
		}
1691

    
1692
		// We differentiate between Animalia and Plantae only for now.
1693
		if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_ANIMALIA) {
1694
			if (rank.equals(Rank.KINGDOM())) {
1695
				result = Animalia_Kingdom;
1696
			} else if (rank.equals(Rank.SUBKINGDOM())) {
1697
				result = Animalia_Subkingdom;
1698
			} else if (rank.equals(Rank.SUPERPHYLUM())) {
1699
				result = Animalia_Superphylum;
1700
			} else if (rank.equals(Rank.PHYLUM())) {
1701
				result = Animalia_Phylum;
1702
			} else if (rank.equals(Rank.SUBPHYLUM())) {
1703
				result = Animalia_Subphylum;
1704
			} else if (rank.equals(Rank.INFRAPHYLUM())) {
1705
				result = Animalia_Infraphylum;
1706
			} else if (rank.equals(Rank.SUPERCLASS())) {
1707
				result = Animalia_Superclass;
1708
			} else if (rank.equals(Rank.CLASS())) {
1709
				result = Animalia_Class;
1710
			} else if (rank.equals(Rank.SUBCLASS())) {
1711
				result = Animalia_Subclass;
1712
			} else if (rank.equals(Rank.INFRACLASS())) {
1713
				result = Animalia_Infraclass;
1714
			} else if (rank.equals(Rank.SUPERORDER())) {
1715
				result = Animalia_Superorder;
1716
			} else if (rank.equals(Rank.ORDER())) {
1717
				result = Animalia_Order;
1718
			} else if (rank.equals(Rank.SUBORDER())) {
1719
				result = Animalia_Suborder;
1720
			} else if (rank.equals(Rank.INFRAORDER())) {
1721
				result = Animalia_Infraorder;
1722
			} else if (rank.equals(Rank.SECTION_ZOOLOGY())) {
1723
				result = Animalia_Section;
1724
			} else if (rank.equals(Rank.SUBSECTION_ZOOLOGY())) {
1725
				result = Animalia_Subsection;
1726
			} else if (rank.equals(Rank.SUPERFAMILY())) {
1727
				result = Animalia_Superfamily;
1728
			} else if (rank.equals(Rank.FAMILY())) {
1729
				result = Animalia_Family;
1730
			} else if (rank.equals(Rank.SUBFAMILY())) {
1731
				result = Animalia_Subfamily;
1732
			} else if (rank.equals(Rank.TRIBE())) {
1733
				result = Animalia_Tribe;
1734
			} else if (rank.equals(Rank.SUBTRIBE())) {
1735
				result = Animalia_Subtribe;
1736
			} else if (rank.equals(Rank.GENUS())) {
1737
				result = Animalia_Genus;
1738
			} else if (rank.equals(Rank.SUBGENUS())) {
1739
				result = Animalia_Subgenus;
1740
			} else if (rank.equals(Rank.SPECIES())) {
1741
				result = Animalia_Species;
1742
			} else if (rank.equals(Rank.SUBSPECIES())) {
1743
				result = Animalia_Subspecies;
1744
//			} else if (rank.equals(Rank.)) { // not yet specified
1745
//				result = Animalia_Natio;
1746
			} else if (rank.equals(Rank.VARIETY())) {
1747
				result = Animalia_Variety;
1748
			} else if (rank.equals(Rank.SUBVARIETY())) {
1749
				result = Animalia_Subvariety;
1750
			} else if (rank.equals(Rank.FORM())) {
1751
				result = Animalia_Forma;
1752
			} else {
1753
				//TODO Exception
1754
				logger.warn("Rank for Kingdom Animalia not yet supported in CDM: "+ rank.getLabel());
1755
				return null;
1756
			}
1757
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_PLANTAE) {
1758
			if (rank.equals(Rank.KINGDOM())) {
1759
				result = Plantae_Kingdom;
1760
			} else if (rank.equals(Rank.SUBKINGDOM())) {
1761
				result = Plantae_Subkingdom;
1762
			}else if (rank.equals(Rank.PHYLUM())) {
1763
				result = Plantae_Phylum;
1764
			}else if (rank.equals(Rank.SUBPHYLUM())) {
1765
				result = Plantae_Subphylum;
1766
			}else if (rank.equals(Rank.DIVISION())) {
1767
				result = Plantae_Division;
1768
			} else if (rank.equals(Rank.SUBDIVISION())) {
1769
				result = Plantae_Subdivision;
1770
			} else if (rank.equals(Rank.CLASS())) {
1771
				result = Plantae_Class;
1772
			} else if (rank.equals(Rank.SUBCLASS())) {
1773
				result = Plantae_Subclass;
1774
			} else if (rank.equals(Rank.SUPERORDER())) {
1775
				result = Plantae_Superorder;
1776
			} else if (rank.equals(Rank.ORDER())) {
1777
				result = Plantae_Order;
1778
			} else if (rank.equals(Rank.SUBORDER())) {
1779
				result = Plantae_Suborder;
1780
			} else if (rank.equals(Rank.FAMILY())) {
1781
				result = Plantae_Family;
1782
			} else if (rank.equals(Rank.SUBFAMILY())) {
1783
				result = Plantae_Subfamily;
1784
			} else if (rank.equals(Rank.TRIBE())) {
1785
				result = Plantae_Tribe;
1786
			} else if (rank.equals(Rank.SUBTRIBE())) {
1787
				result = Plantae_Subtribe;
1788
			} else if (rank.equals(Rank.GENUS())) {
1789
				result = Plantae_Genus;
1790
			} else if (rank.equals(Rank.SUBGENUS())) {
1791
				result = Plantae_Subgenus;
1792
			} else if (rank.equals(Rank.SECTION_BOTANY())) {
1793
				result = Plantae_Section;
1794
			} else if (rank.equals(Rank.SUBSECTION_BOTANY())) {
1795
				result = Plantae_Subsection;
1796
			} else if (rank.equals(Rank.SERIES())) {
1797
				result = Plantae_Series;
1798
			} else if (rank.equals(Rank.SUBSERIES())) {
1799
				result = Plantae_Subseries;
1800
			} else if (rank.equals(Rank.SPECIESAGGREGATE() )) {
1801
				result = Plantae_Aggregate;
1802
			} else if (rank.equals(Rank.SPECIESGROUP())) {
1803
				logger.warn("Rank Species Group not yet implemented");
1804
				result = null;
1805
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankCollSpecies)) {
1806
				result = Plantae_Coll_Species;
1807
			} else if (rank.equals(Rank.SPECIES())) {
1808
				result = Plantae_Species;
1809
			} else if (rank.equals(Rank.SUBSPECIES())) {
1810
				result = Plantae_Subspecies;
1811
			} else if (rank.equals(Rank.GREX())) {
1812
				result = Plantae_Grex;
1813
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankProles) ) {
1814
				result = Plantae_Proles;
1815
			} else if (rank.getUuid().equals(BerlinModelTransformer.uuidRankRace)) {
1816
				result = Plantae_Race;
1817
			} else if (rank.equals(Rank.CONVAR())) {
1818
				result = Plantae_Convarietas;
1819
			} else if (rank.equals(Rank.VARIETY())) {
1820
				result = Plantae_Variety;
1821
			} else if (rank.equals(Rank.SUBVARIETY())) {
1822
				result = Plantae_Subvariety;
1823
			} else if (rank.equals(Rank.FORM())) {
1824
				result = Plantae_Forma;
1825
			} else if (rank.equals(Rank.SUBFORM())) {
1826
				result = Plantae_Subforma;
1827
//			} else if (rank.equals(Rank.)) { // not yet specified
1828
//				result = Plantae_Forma_spec;
1829
			} else if (rank.equals(Rank.INFRAGENERICTAXON())) {
1830
				result = Plantae_Taxa_infragen;
1831
			} else if (rank.equals(Rank.INFRASPECIFICTAXON())) {
1832
				result = Plantae_Taxa_infraspec;
1833
			} else {
1834
				//TODO Exception
1835
				logger.warn("Rank for Kingdom Plantae not yet supported in CDM: "+ rank.getLabel());
1836
				return null;
1837
			}
1838
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_BACTERIA) {
1839
			if (rank.equals(Rank.KINGDOM())) { result = Bacteria_Kingdom; }
1840
			else if (rank.equals(Rank.SUBKINGDOM())) { result = Bacteria_Subkingdom; }
1841
			else if (rank.equals(Rank.PHYLUM())) { result = Bacteria_Phylum; }
1842
			else if (rank.equals(Rank.SUBPHYLUM())) { result = Bacteria_Subphylum; }
1843
			else if (rank.equals(Rank.SUPERCLASS())) { result = Bacteria_Superclass; }
1844
			else if (rank.equals(Rank.CLASS())) { result = Bacteria_Class; }
1845
			else if (rank.equals(Rank.SUBCLASS())) { result = Bacteria_Subclass; }
1846
			else if (rank.equals(Rank.INFRACLASS())) { result = Bacteria_Infraclass; }
1847
			else if (rank.equals(Rank.SUPERORDER())) { result = Bacteria_Superorder; }
1848
			else if (rank.equals(Rank.ORDER())) { result = Bacteria_Order; }
1849
			else if (rank.equals(Rank.SUBORDER())) { result = Bacteria_Suborder; }
1850
			else if (rank.equals(Rank.INFRAORDER())) { result = Bacteria_Infraorder; }
1851
			else if (rank.equals(Rank.SUPERFAMILY())) { result = Bacteria_Superfamily; }
1852
			else if (rank.equals(Rank.FAMILY())) { result = Bacteria_Family; }
1853
			else if (rank.equals(Rank.SUBFAMILY())) { result = Bacteria_Subfamily; }
1854
			else if (rank.equals(Rank.TRIBE())) { result = Bacteria_Tribe; }
1855
			else if (rank.equals(Rank.SUBTRIBE())) { result = Bacteria_Subtribe; }
1856
			else if (rank.equals(Rank.GENUS())) { result = Bacteria_Genus; }
1857
			else if (rank.equals(Rank.SUBGENUS())) { result = Bacteria_Subgenus; }
1858
			else if (rank.equals(Rank.SPECIES())) { result = Bacteria_Species; }
1859
			else if (rank.equals(Rank.SUBSPECIES())) { result = Bacteria_Subspecies; }
1860
			else if (rank.equals(Rank.VARIETY())) { result = Bacteria_Variety; }
1861
			else if (rank.equals(Rank.FORM())) { result = Bacteria_Forma; }
1862
		} else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_FUNGI) {
1863
            if (rank.equals(Rank.KINGDOM())) { result = Fungi_Kingdom; }
1864
            else if (rank.equals(Rank.SUBKINGDOM())) { result = Fungi_Subkingdom; }
1865
            else if (rank.equals(Rank.DIVISION())) { result =  Fungi_Division;}
1866
            else if (rank.equals(Rank.SUBDIVISION())) { result =  Fungi_Subdivision;}
1867
            else if (rank.equals(Rank.CLASS())) { result = Fungi_Class; }
1868
            else if (rank.equals(Rank.SUBCLASS())) { result = Fungi_Subclass; }
1869
            else if (rank.equals(Rank.ORDER())) { result = Fungi_Order; }
1870
            else if (rank.equals(Rank.SUBORDER())) { result = Fungi_Suborder; }
1871

    
1872
            else if (rank.equals(Rank.FAMILY())) { result = Fungi_Family; }
1873
            else if (rank.equals(Rank.SUBFAMILY())) { result = Fungi_Subfamily; }
1874
            else if (rank.equals(Rank.TRIBE())) { result = Fungi_Tribe; }
1875
            else if (rank.equals(Rank.SUBTRIBE())) { result = Fungi_Subtribe; }
1876
            else if (rank.equals(Rank.GENUS())) { result = Fungi_Genus; }
1877
            else if (rank.equals(Rank.SUBGENUS())) { result = Fungi_Subgenus; }
1878
            else if (rank.equals(Rank.SECTION_BOTANY())) { result = Fungi_Section;}
1879
            else if (rank.equals(Rank.SUBSECTION_BOTANY())) { result = Fungi_Subsection;}
1880
            else if (rank.equals(Rank.SPECIES())) { result = Fungi_Species; }
1881
            else if (rank.equals(Rank.SUBSPECIES())) { result = Fungi_Subspecies; }
1882
            else if (rank.equals(Rank.VARIETY())) { result = Fungi_Variety; }
1883
            else if (rank.equals(Rank.SUBVARIETY())) { result = Fungi_Subvariety; }
1884
            else if (rank.equals(Rank.FORM())) { result = Fungi_Forma; }
1885
            else if (rank.equals(Rank.SUBFORM())) { result = Fungi_Subforma;}
1886
        }else if (pesiKingdomId != null && pesiKingdomId.intValue() == KINGDOM_CHROMISTA) {
1887
            if (rank.equals(Rank.KINGDOM())) { result = Chromista_Kingdom; }
1888
            else if (rank.equals(Rank.SUBKINGDOM())) { result = Chromista_Subkingdom; }
1889

    
1890
            else if (rank.equals(Rank.CLASS())) { result = Chromista_Class; }
1891
            else if (rank.equals(Rank.SUBCLASS())) { result = Chromista_Subclass; }
1892
            else if (rank.equals(Rank.ORDER())) { result = Chromista_Order; }
1893
            else if (rank.equals(Rank.SUBORDER())) { result = Chromista_Suborder; }
1894
            else if (rank.equals(Rank.INFRAORDER())) { result = Chromista_Infraorder; }
1895
            else if (rank.equals(Rank.SUPERFAMILY())) { result = Chromista_Superfamily; }
1896
            else if (rank.equals(Rank.FAMILY())) { result = Chromista_Family; }
1897
            else if (rank.equals(Rank.SUBFAMILY())) { result = Chromista_Subfamily; }
1898
            else if (rank.equals(Rank.TRIBE())) { result = Chromista_Tribe; }
1899
            else if (rank.equals(Rank.SUBTRIBE())) { result = Chromista_Subtribe; }
1900
            else if (rank.equals(Rank.GENUS())) { result = Chromista_Genus; }
1901
            else if (rank.equals(Rank.SUBGENUS())) { result = Chromista_Subgenus; }
1902
            else if (rank.equals(Rank.SECTION_BOTANY())) { result = Chromista_Section;}
1903
            else if (rank.equals(Rank.SUBSECTION_BOTANY())) { result = Chromista_Subsection;}
1904
            else if (rank.equals(Rank.SPECIES())) { result = Chromista_Species; }
1905
            else if (rank.equals(Rank.SUBSPECIES())) { result = Chromista_Subspecies; }
1906
            else if (rank.equals(Rank.VARIETY())) { result = Chromista_Variety; }
1907
            else if (rank.equals(Rank.SUBVARIETY())) { result = Chromista_Subvariety; }
1908
            else if (rank.equals(Rank.FORM())) { result = Chromista_Forma; }
1909

    
1910

    
1911

    
1912
        }else{
1913
			//TODO Exception
1914
			logger.warn("Kingdom not yet supported in CDM: "+ pesiKingdomId);
1915
			return null;
1916
		}
1917
		return result;
1918

    
1919
	}
1920

    
1921
	/**
1922
	 *
1923
	 * @param nameTypeDesignationStatus
1924
	 * @return
1925
	 */
1926
	public static Integer nameTypeDesignationStatus2TypeDesignationStatusId(NameTypeDesignationStatus nameTypeDesignationStatus) {
1927
		if (nameTypeDesignationStatus == null) {
1928
			return null;
1929
		}
1930
		if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.ORIGINAL_DESIGNATION())) {
1931
			return TYPE_BY_ORIGINAL_DESIGNATION;
1932
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.SUBSEQUENT_DESIGNATION())) {
1933
			return TYPE_BY_SUBSEQUENT_DESIGNATION;
1934
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.MONOTYPY())) {
1935
			return TYPE_BY_MONOTYPY;
1936
		} else {
1937
			//TODO Figure out a way to handle this gracefully.
1938
			logger.warn("Name Type Designation Status not yet supported in PESI: "+ nameTypeDesignationStatus.getLabel());
1939
			return null;
1940
		}
1941

    
1942
	}
1943

    
1944
	/**
1945
	 *
1946
	 * @param nameTypeDesignationStatus
1947
	 * @return
1948
	 */
1949
	public static String nameTypeDesignationStatus2TypeDesignationStatusCache(NameTypeDesignationStatus nameTypeDesignationStatus) {
1950
		if (nameTypeDesignationStatus == null) {
1951
			return null;
1952
		}
1953
		if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.ORIGINAL_DESIGNATION())) {
1954
			return TYPE_STR_BY_ORIGINAL_DESIGNATION;
1955
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.SUBSEQUENT_DESIGNATION())) {
1956
			return TYPE_STR_BY_SUBSEQUENT_DESIGNATION;
1957
		} else if (nameTypeDesignationStatus.equals(NameTypeDesignationStatus.MONOTYPY())) {
1958
			return TYPE_STR_BY_MONOTYPY;
1959
		} else {
1960
			//TODO Figure out a way to handle this gracefully.
1961
			logger.warn("Name Type Designation Status not yet supported in PESI: "+ nameTypeDesignationStatus.getLabel());
1962
			return null;
1963
		}
1964

    
1965
	}
1966

    
1967
	/**
1968
	 * @see PesiTaxonExport#doPhaseUpdates(PesiExportState) for further transformation
1969
	 * @param taxonBase
1970
	 * @return
1971
	 */
1972
	public static Integer taxonBase2statusFk (TaxonBase<?> taxonBase){
1973
		if (taxonBase == null){
1974
			return null;
1975
		}
1976
		if (taxonBase.isInstanceOf(Taxon.class)){
1977
			Taxon taxon = CdmBase.deproxy(taxonBase, Taxon.class);
1978
			if (taxon.getTaxonNodes().size() == 0){
1979
				return T_STATUS_NOT_ACCEPTED;
1980
			}else{
1981
				return T_STATUS_ACCEPTED;
1982
			}
1983
		}else if (taxonBase.isInstanceOf(Synonym.class)){
1984
			return T_STATUS_SYNONYM;
1985
		}else{
1986
			logger.warn("Unknown ");
1987
			return T_STATUS_UNRESOLVED;
1988
		}
1989
		//TODO
1990
//		public static int T_STATUS_PARTIAL_SYN = 3;
1991
//		public static int T_STATUS_PRO_PARTE_SYN = 4;
1992
//		public static int T_STATUS_UNRESOLVED = 5;
1993
//		public static int T_STATUS_ORPHANED = 6;
1994
	}
1995

    
1996
//	/**
1997
//	 *
1998
//	 * @param taxonBase
1999
//	 * @return
2000
//	 */
2001
//	public static String taxonBase2statusCache (TaxonBase<?> taxonBase){
2002
//		if (taxonBase == null){return null;}
2003
//		if (taxonBase.isInstanceOf(Taxon.class)){
2004
//			Taxon taxon = CdmBase.deproxy(taxonBase, Taxon.class);
2005
//			if (taxon.getTaxonNodes().size() == 0){
2006
//				return T_STATUS_STR_NOT_ACCEPTED;
2007
//			}else{
2008
//				return T_STATUS_STR_ACCEPTED;
2009
//			}
2010
//		}else if (taxonBase.isInstanceOf(Synonym.class)){
2011
//			return T_STATUS_STR_SYNONYM;
2012
//		}else{
2013
//			logger.warn("Unknown ");
2014
//			return T_STATUS_STR_UNRESOLVED;
2015
//		}
2016
//		//TODO
2017
//		public static int T_STATUS_STR_PARTIAL_SYN = 3;
2018
//		public static int T_STATUS_STR_PRO_PARTE_SYN = 4;
2019
//		public static int T_STATUS_STR_UNRESOLVED = 5;
2020
//		public static int T_STATUS_STR_ORPHANED = 6;
2021
//	}
2022

    
2023
	/**
2024
	 * Returns the {@link SourceCategory SourceCategory} representation of the given {@link ReferenceType ReferenceType} in PESI.
2025
	 * @param reference The {@link Reference Reference}.
2026
	 * @return The {@link SourceCategory SourceCategory} representation in PESI.
2027
	 */
2028
	public static Integer reference2SourceCategoryFK(Reference reference) {
2029
		if (reference == null){
2030
			return null;
2031
		} else if (reference.getType().equals(ReferenceType.Article)) {
2032
			return REF_ARTICLE_IN_PERIODICAL;
2033
		} else if (reference.getType().equals(ReferenceType.Book)) {
2034
			return REF_BOOK;
2035
		} else if (reference.getType().equals(ReferenceType.BookSection)) {
2036
			return REF_PART_OF_OTHER;
2037
		} else if (reference.getType().equals(ReferenceType.Section)) {
2038
			return REF_PART_OF_OTHER;
2039
		} else if (reference.getType().equals(ReferenceType.Database)) {
2040
			return REF_DATABASE;
2041
		} else if (reference.getType().equals(ReferenceType.WebPage)) {
2042
			return REF_WEBSITE;
2043
		} else if (reference.getType().equals(ReferenceType.CdDvd)) {
2044
			return REF_NOT_APPLICABLE;
2045
		} else if (reference.getType().equals(ReferenceType.Journal)) {
2046
			return REF_JOURNAL;
2047
		} else if (reference.getType().equals(ReferenceType.Generic)) {
2048
			return REF_UNRESOLVED;
2049
		} else if (reference.getType().equals(ReferenceType.PrintSeries)) {
2050
			return REF_PUBLISHED;
2051
		} else if (reference.getType().equals(ReferenceType.Proceedings)) {
2052
			return REF_PUBLISHED;
2053
		} else if (reference.getType().equals(ReferenceType.Patent)) {
2054
			return REF_NOT_APPLICABLE;
2055
		} else if (reference.getType().equals(ReferenceType.PersonalCommunication)) {
2056
			return REF_INFORMAL;
2057
		} else if (reference.getType().equals(ReferenceType.Report)) {
2058
			return REF_NOT_APPLICABLE;
2059
		} else if (reference.getType().equals(ReferenceType.Thesis)) {
2060
			return REF_NOT_APPLICABLE;
2061
		} else {
2062
			logger.warn("Reference type not yet supported in PESI: "+ reference.getType());
2063
			return null;
2064
		}
2065
	}
2066

    
2067
	/**
2068
	 * Returns the {@link SourceCategoryCache SourceCategoryCache}.
2069
	 * @param reference The {@link Reference Reference}.
2070
	 * @return The {@link SourceCategoryCache SourceCategoryCache}.
2071
	 */
2072
	public String getCacheByReference(Reference reference) {
2073
		if (reference == null){
2074
			return null;
2075
		}else{
2076
			return this.sourceCategoryCacheMap.get(reference2SourceCategoryFK(reference));
2077
		}
2078
	}
2079

    
2080
	/**
2081
	 *
2082
	 * @param status
2083
	 * @return
2084
	 */
2085
	@Override
2086
    public String getCacheByNomStatus(NomenclaturalStatusType status) {
2087
		if (status == null){
2088
			return null;
2089
		}else{
2090
			return this.nameStatusCacheMap.get(nomStatus2nomStatusFk(status));
2091
		}
2092
	}
2093

    
2094
	/**
2095
	 *
2096
	 * @param status
2097
	 * @return
2098
	 */
2099
	public static Integer nomStatus2nomStatusFk (NomenclaturalStatusType status){
2100
		if (status == null){
2101
			return null;
2102
		}
2103
		if (status.equals(NomenclaturalStatusType.INVALID())) {return NAME_ST_NOM_INVAL;
2104
		}else if (status.equals(NomenclaturalStatusType.ILLEGITIMATE())) {return NAME_ST_NOM_ILLEG;
2105
		}else if (status.equals(NomenclaturalStatusType.NUDUM())) {return NAME_ST_NOM_NUD;
2106
		}else if (status.equals(NomenclaturalStatusType.REJECTED())) {return NAME_ST_NOM_REJ;
2107
		}else if (status.equals(NomenclaturalStatusType.REJECTED_PROP())) {return NAME_ST_NOM_REJ_PROP;
2108
		}else if (status.equals(NomenclaturalStatusType.UTIQUE_REJECTED())) {return NAME_ST_NOM_UTIQUE_REJ;
2109
		}else if (status.equals(NomenclaturalStatusType.UTIQUE_REJECTED_PROP())) {return NAME_ST_NOM_UTIQUE_REJ_PROP;
2110
		}else if (status.equals(NomenclaturalStatusType.CONSERVED())) {return NAME_ST_NOM_CONS;
2111

    
2112
		}else if (status.equals(NomenclaturalStatusType.CONSERVED_PROP())) {return NAME_ST_NOM_CONS_PROP;
2113
		}else if (status.equals(NomenclaturalStatusType.ORTHOGRAPHY_CONSERVED())) {return NAME_ST_ORTH_CONS;
2114
		}else if (status.equals(NomenclaturalStatusType.ORTHOGRAPHY_CONSERVED_PROP())) {return NAME_ST_ORTH_CONS_PROP;
2115
		}else if (status.equals(NomenclaturalStatusType.SUPERFLUOUS())) {return NAME_ST_NOM_SUPERFL;
2116
		}else if (status.equals(NomenclaturalStatusType.AMBIGUOUS())) {return NAME_ST_NOM_AMBIG;
2117
		}else if (status.equals(NomenclaturalStatusType.PROVISIONAL())) {return NAME_ST_NOM_PROVIS;
2118
		}else if (status.equals(NomenclaturalStatusType.DOUBTFUL())) {return NAME_ST_NOM_DUB;
2119
		}else if (status.equals(NomenclaturalStatusType.NOVUM())) {return NAME_ST_NOM_NOV;
2120

    
2121
		}else if (status.equals(NomenclaturalStatusType.CONFUSUM())) {return NAME_ST_NOM_CONFUS;
2122
		}else if (status.equals(NomenclaturalStatusType.ALTERNATIVE())) {return NAME_ST_NOM_ALTERN;
2123
		}else if (status.equals(NomenclaturalStatusType.COMBINATION_INVALID())) {return NAME_ST_COMB_INVAL;
2124
		}else if (status.equals(NomenclaturalStatusType.LEGITIMATE())) {return NAME_ST_LEGITIMATE;
2125

    
2126
		}else if (status.getUuid().equals(BerlinModelTransformer.uuidNomStatusCombIned)) {return NAME_ST_COMB_INED;
2127
		}else if (status.getUuid().equals(BerlinModelTransformer.uuidNomStatusNomOrthCons)) {return NAME_ST_NOM_AND_ORTH_CONS;
2128
		}else if (status.getUuid().equals(BerlinModelTransformer.uuidNomStatusSpNovIned)) {return NAME_ST_SP_NOV_INED;
2129

    
2130

    
2131
		// The following are non-existent in CDM
2132
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_COMB_AND_STAT_INED;
2133
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_NOM_NOV_INED;
2134
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_ALTERNATE_REPRESENTATION;
2135
		}else if (status.getUuid().equals(FaunaEuropaeaTransformer.uuidNomStatusTempNamed)) {return NAME_ST_TEMPORARY_NAME;
2136
//		}else if (status.equals(NomenclaturalStatusType.)) {return NAME_ST_SPECIES_INQUIRENDA;
2137

    
2138
		//TODO
2139
		}else {
2140
			//TODO Exception
2141
			logger.warn("NomStatus type not yet supported by PESI export: "+ status);
2142
			return null;
2143
		}
2144
	}
2145

    
2146
	/**
2147
	 * Returns the RelTaxonQualifierCache for a given taxonRelation.
2148
	 * @param relation
2149
	 * @return
2150
	 */
2151
	public String getCacheByRelationshipType(RelationshipBase relation, NomenclaturalCode code){
2152
		if (relation == null){
2153
			return null;
2154
		}else{
2155
			String result;
2156
			Integer key = taxonRelation2RelTaxonQualifierFk(relation);
2157
			if (code.equals(NomenclaturalCode.ICZN)){
2158
				result = this.taxRelZooQualifierCacheMap.get(key);
2159
				if (result == null){
2160
					this.taxRelQualifierCacheMap.get(key);
2161
				}
2162
			}else{
2163
				result = this.taxRelQualifierCacheMap.get(key);
2164
			}
2165
			return result;
2166
		}
2167
	}
2168

    
2169
	/**
2170
	 * Returns the RelTaxonQualifierFk for a TaxonRelation.
2171
	 * @param relation
2172
	 * @return
2173
	 */
2174
	public static Integer taxonRelation2RelTaxonQualifierFk(RelationshipBase<?,?,?> relation) {
2175
		if (relation == null) {
2176
			return null;
2177
		}
2178
		RelationshipTermBase<?> type = relation.getType();
2179
		if (type.equals(TaxonRelationshipType.MISAPPLIED_NAME_FOR())) {
2180
			return IS_MISAPPLIED_NAME_FOR;
2181
		} else if (type.equals(SynonymRelationshipType.SYNONYM_OF())) {
2182
			SynonymRelationship synRel = CdmBase.deproxy(relation, SynonymRelationship.class);
2183
			if (synRel.isProParte()){
2184
				return IS_PRO_PARTE_SYNONYM_OF;
2185
			}else if (synRel.isPartial()){
2186
				return IS_PARTIAL_SYNONYM_OF;
2187
			}else{
2188
				return IS_SYNONYM_OF;
2189
			}
2190
		} else if (type.equals(SynonymRelationshipType.HOMOTYPIC_SYNONYM_OF())) {
2191
			SynonymRelationship synRel = CdmBase.deproxy(relation, SynonymRelationship.class);
2192
			if (synRel.isProParte()){
2193
				return IS_PRO_PARTE_AND_HOMOTYPIC_SYNONYM_OF;
2194
			}else if (synRel.isPartial()){
2195
				return IS_PARTIAL_AND_HOMOTYPIC_SYNONYM_OF;
2196
			}else{
2197
				return IS_HOMOTYPIC_SYNONYM_OF;
2198
			}
2199
		} else if (type.equals(SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF())) {
2200
			SynonymRelationship synRel = CdmBase.deproxy(relation, SynonymRelationship.class);
2201
			if (synRel.isProParte()){
2202
				return IS_PRO_PARTE_AND_HETEROTYPIC_SYNONYM_OF;
2203
			}else if (synRel.isPartial()){
2204
				return IS_PARTIAL_AND_HETEROTYPIC_SYNONYM_OF;
2205
			}else{
2206
				return IS_HETEROTYPIC_SYNONYM_OF;
2207
			}
2208
		} else if (type.equals(SynonymRelationshipType.INFERRED_EPITHET_OF())) {
2209
			return IS_INFERRED_EPITHET_FOR;
2210
		} else if (type.equals(SynonymRelationshipType.INFERRED_GENUS_OF())) {
2211
			return IS_INFERRED_GENUS_FOR;
2212
		} else if (type.equals(SynonymRelationshipType.POTENTIAL_COMBINATION_OF())) {
2213
			return IS_POTENTIAL_COMBINATION_FOR;
2214
		} else if (type.equals(NameRelationshipType.BASIONYM())) {
2215
			return IS_BASIONYM_FOR;
2216
		} else if (type.equals(NameRelationshipType.LATER_HOMONYM())) {
2217
			return IS_LATER_HOMONYM_OF;
2218
		} else if (type.equals(NameRelationshipType.REPLACED_SYNONYM())) {
2219
			return IS_REPLACED_SYNONYM_FOR;
2220
		} else if (type.equals(NameRelationshipType.VALIDATED_BY_NAME())) {
2221
			return IS_VALIDATION_OF;
2222
		} else if (type.equals(NameRelationshipType.LATER_VALIDATED_BY_NAME())) {
2223
			return IS_LATER_VALIDATION_OF;
2224
		} else if (type.equals(NameRelationshipType.CONSERVED_AGAINST())) {
2225
			return IS_CONSERVED_AGAINST;
2226
		} else if (type.equals(NameRelationshipType.TREATED_AS_LATER_HOMONYM())) {
2227
			return IS_TREATED_AS_LATER_HOMONYM_OF;
2228
		} else if (type.equals(NameRelationshipType.ORTHOGRAPHIC_VARIANT())) {
2229
			return IS_ORTHOGRAPHIC_VARIANT_OF;
2230
		} else if (type.equals(NameRelationshipType.ALTERNATIVE_NAME())) {
2231
			return IS_ALTERNATIVE_NAME_FOR;
2232
		} else if (type.equals(HybridRelationshipType.FEMALE_PARENT())) {
2233
			return IS_FEMALE_PARENT_OF;
2234
		} else if (type.equals(HybridRelationshipType.MALE_PARENT())) {
2235
			return IS_MALE_PARENT_OF;
2236
		} else if (type.equals(HybridRelationshipType.FIRST_PARENT())) {
2237
			return IS_FIRST_PARENT_OF;
2238
		} else if (type.equals(HybridRelationshipType.SECOND_PARENT())) {
2239
			return IS_SECOND_PARENT_OF;
2240
		} else if (type.getUuid().equals(ErmsTransformer.uuidTaxRelTypeIsTaxonSynonymOf)) {
2241
			return IS_SYNONYM_OF;
2242
		} else {
2243
			logger.warn("No equivalent RelationshipType found in datawarehouse for: " + type.getTitleCache());
2244
		}
2245

    
2246
		// The following have no equivalent attribute in CDM
2247
//		IS_TYPE_OF
2248
//		IS_CONSERVED_TYPE_OF
2249
//		IS_REJECTED_TYPE_OF
2250
//		IS_REJECTED_IN_FAVOUR_OF
2251
//		HAS_SAME_TYPE_AS
2252
//		IS_LECTOTYPE_OF
2253
//		TYPE_NOT_DESIGNATED
2254

    
2255

    
2256
		return null;
2257
	}
2258

    
2259
	/**
2260
	 * Returns the StatusFk for a given StatusCache.
2261
	 * @param StatusCache
2262
	 * @return
2263
	 */
2264
	public Integer StatusCache2StatusFk(String StatusCache) {
2265
		Integer result = null;
2266
		if (StatusCache.equalsIgnoreCase("Checked by Taxonomic Editor: included in ERMS 1.1")) {
2267
			return 0;
2268
		} else if (StatusCache.equalsIgnoreCase("Added by Database Management Team")) {
2269
			return 2;
2270
		} else if (StatusCache.equalsIgnoreCase("Checked by Taxonomic Editor")) {
2271
			return 3;
2272
		} else if (StatusCache.equalsIgnoreCase("Edited by Database Management Team")) {
2273
			return 4;
2274
		} else {
2275
			logger.error("StatusFk could not be determined. StatusCache unknown: " + StatusCache);
2276
		}
2277

    
2278
		return result;
2279
	}
2280

    
2281
	/**
2282
	 * Returns the FossilStatusFk for a given FossilStatusCache.
2283
	 * @param fossilStatusCache
2284
	 * @return
2285
	 */
2286
	public Integer FossilStatusCache2FossilStatusFk(String fossilStatusCache) {
2287
		Integer result = null;
2288
		if (fossilStatusCache.equalsIgnoreCase("recent only")) {
2289
			return 1;
2290
		} else if (fossilStatusCache.equalsIgnoreCase("fossil only")) {
2291
			return 2;
2292
		} else if (fossilStatusCache.equalsIgnoreCase("recent + fossil")) {
2293
			return 3;
2294
		} else {
2295
			logger.error("FossilStatusFk could not be determined. FossilStatusCache unknown: " + fossilStatusCache);
2296
		}
2297

    
2298
		return result;
2299
	}
2300

    
2301
	/**
2302
	 * Returns the NoteCategoryFk for a given UUID representing an ExtensionType.
2303
	 * @param uuid
2304
	 * @return
2305
	 */
2306
	public static Integer getNoteCategoryFk(UUID uuid) {
2307
		Integer result = null;
2308
		if (uuid.equals(taxCommentUuid)) {
2309
			result = 270;
2310
		} else if (uuid.equals(fauCommentUuid)) {
2311
			result = 281;
2312
		} else if (uuid.equals(fauExtraCodesUuid)) {
2313
			result = 278;
2314
		}
2315
		return result;
2316
	}
2317

    
2318
	/**
2319
	 * Returns the NoteCategoryCache for a given UUID representing an ExtensionType.
2320
	 * @param uuid
2321
	 * @return
2322
	 */
2323
	public static String getNoteCategoryCache(UUID uuid) {
2324
		String result = null;
2325
		if (uuid.equals(taxCommentUuid)) {
2326
			result = "Taxonomy";
2327
		} else if (uuid.equals(fauCommentUuid)) {
2328
			result = "Biology";
2329
		} else if (uuid.equals(fauExtraCodesUuid)) {
2330
			result = "Distribution";
2331
		}
2332
		return result;
2333
	}
2334

    
2335
	public static Integer getQualityStatusKeyBySource(BitSet sources, TaxonNameBase<?,?> taxonName) {
2336
		if (sources.get(SOURCE_EM)){
2337
			return QUALITY_STATUS_ADD_BY_DBMT;
2338
		}else if (sources.get(SOURCE_ERMS)){
2339
			Set<String> statusSet = getAllQualityStatus(taxonName);
2340
			if (statusSet.size() > 1){
2341
				logger.warn("ERMS TaxonName has more than 1 quality status: " + taxonName.getTitleCache() + "; lisd=" + taxonName.getLsid());
2342
			}
2343
			if (statusSet.contains("Checked by Taxonomic Editor: included in ERMS 1.1")){
2344
				return QUALITY_STATUS_CHECKED_EDITOR_ERMS_1_1;
2345
			}else if (statusSet.contains("Added by Database Management Team")){
2346
				return QUALITY_STATUS_ADD_BY_DBMT;
2347
			}else if (statusSet.contains("Checked by Taxonomic Editor")){
2348
				return QUALITY_STATUS_CHECKED_EDITOR;
2349
			}else if (statusSet.contains("Edited by Database Management Team")){
2350
				return QUALITY_STATUS_EDITED_BY_DBMT;
2351
			}else{
2352
				logger.warn("Unknown ERMS quality status: " + statusSet.iterator().next() + " for taxon name " + taxonName.getTitleCache());
2353
				return null;
2354
			}
2355
		}else{
2356
			return null;   // TODO needs to be implemented for others
2357
		}
2358
	}
2359

    
2360

    
2361
	private static Set<String> getAllQualityStatus(TaxonNameBase<?, ?> taxonName) {
2362
		Set<String> result = new HashSet<String>();
2363
		for (TaxonBase<?> taxonBase : taxonName.getTaxonBases()){
2364
			result.addAll(taxonBase.getExtensions(ErmsTransformer.uuidQualityStatus));
2365
		}
2366
		return result;
2367
	}
2368

    
2369
	@Override
2370
	public String getQualityStatusCacheByKey(Integer qualityStatusId) throws UndefinedTransformerMethodException {
2371
		if (qualityStatusId == null){
2372
			return null;
2373
		}else{
2374
			return this.qualityStatusCacheMap.get(qualityStatusId);
2375
		}
2376
	}
2377

    
2378

    
2379
	public Object getSourceUseCacheByKey(Integer sourceUseFk) {
2380
		if (sourceUseFk == null){
2381
			return null;
2382
		}else{
2383
			return this.sourceUseCacheMap.get(sourceUseFk);
2384
		}
2385
	}
2386

    
2387
	@Override
2388
	public String getTaxonStatusCacheByKey(Integer taxonStatusId) throws UndefinedTransformerMethodException {
2389
		if (taxonStatusId == null){
2390
			return null;
2391
		}else{
2392
			return this.taxonStatusCacheMap.get(taxonStatusId);
2393
		}
2394
	}
2395

    
2396
	public static String getOriginalDbBySources(BitSet sources) {
2397
		String result = "";
2398
		if (sources.get(SOURCE_EM)){
2399
			result = CdmUtils.concat(",", result,  SOURCE_STR_EM);
2400
		}
2401
		if (sources.get(SOURCE_FE)){
2402
			result = CdmUtils.concat(",", result,  SOURCE_STR_FE);
2403
		}
2404
		if (sources.get(SOURCE_IF)){
2405
			result = CdmUtils.concat(",", result,  SOURCE_STR_IF);
2406
		}
2407
		if (sources.get(SOURCE_ERMS)){
2408
			result = CdmUtils.concat(",", result,  SOURCE_STR_ERMS);
2409
		}
2410

    
2411
		return result;
2412
	}
2413

    
2414
    /**
2415
     * @param titleCache
2416
     */
2417
    public static Integer pesiKingdomId(String titleCache) {
2418
        return pesiKingdomMap.get(titleCache);
2419

    
2420
    }
2421

    
2422

    
2423

    
2424
}
(12-12/12)