Project

General

Profile

« Previous | Next » 

Revision fa27ce80

Added by Andreas Müller over 4 years ago

ref #1444, ref #8508, ref #8509 improve ERMS distribution pipeline

View differences:

cdm-pesi/src/main/java/eu/etaxonomy/cdm/io/pesi/erms/ErmsDistributionImport.java
61 61
	@Override
62 62
	protected String getRecordQuery(ErmsImportConfigurator config) {
63 63
		String strRecordQuery =
64
			" SELECT dr.*, tu.tu_acctaxon, tu.id " +
64
			" SELECT dr.*, ISNULL(ISNULL(tu.tu_acctaxon, tu.tu_accfinal), tu.id) acctaxon" +
65 65
			" FROM dr INNER JOIN tu ON dr.tu_id = tu.id " +
66 66
			" WHERE ( dr.id IN (" + ID_LIST_TOKEN + ") )";
67 67
		return strRecordQuery;
......
118 118
			Set<String> areaIdSet = new HashSet<>();
119 119
			Set<String> sourceIdSet = new HashSet<>();
120 120
			while (rs.next()){
121
				handleForeignKey(rs, taxonIdSet,"tu_acctaxon" );
121
				handleForeignKey(rs, taxonIdSet,"acctaxon" );
122 122
				handleForeignKey(rs, areaIdSet, "gu_id");
123 123
				handleForeignKey(rs, sourceIdSet, "source_id");
124 124
			}
cdm-pesi/src/main/java/eu/etaxonomy/cdm/io/pesi/erms/ErmsTransformer.java
54 54
    public static final UUID uuidRankSubterclass = UUID.fromString("39257363-913b-4b3a-a536-b415360dfc8c");
55 55
    public static final UUID uuidRankParvorder = UUID.fromString("d26b8cae-96f9-4aee-81f2-98e36f1db7c3");
56 56

  
57

  
58 57
	//language uuids
58
    public static final UUID uuidAdriaticSea = UUID.fromString("da376165-f970-4f0c-99db-773686d66591");
59
    public static final UUID uuidAegeanSea = UUID.fromString("65d6c443-225f-4ac0-9c86-da51502b46df");
60
    public static final UUID uuidArchipelagoSea = UUID.fromString("d9ea9d63-ec4d-4b01-967d-13f28b09a715");
61
    public static final UUID uuidBalticProper = UUID.fromString("12ddfcad-bf8f-43d8-a772-15ae69d37b20");
62
    public static final UUID uuidBalearSea = UUID.fromString("478f30f0-01b1-4772-9d01-3a0a571f41c3");
63
    public static final UUID uuidBalticSea = UUID.fromString("0031cda2-4b27-49de-afa3-fdec75ee5060");
64
    public static final UUID uuidBarentsSea = UUID.fromString("b6fd9a4d-0ad0-4481-a0b4-5dd71c8fda8b");
65
    public static final UUID uuidBelgianExclusiveEconomicZone = UUID.fromString("02138b0f-cee1-4c56-ae12-72a5b36839af");
66
    public static final UUID uuidBeltSea = UUID.fromString("780f4144-f157-45e8-ae42-cacb3ec369ba");
67
    public static final UUID uuidBiscayBay = UUID.fromString("36ffc01e-85a2-4f71-91fd-012d0b1eeff5");
68
    public static final UUID uuidBlackSea = UUID.fromString("1f110909-7462-4ee8-a7ff-9f976701dd1d");
69
    public static final UUID uuidBothnianSea = UUID.fromString("926f7fa3-b0a4-4763-85eb-4c3804a72333");
70
    public static final UUID uuidBulgarianExclusiveEconomicZone = UUID.fromString("13e5aa21-3971-4d06-bc34-ed75a31c2f66");
71
    public static final UUID uuidCaspianSea = UUID.fromString("0d3c3850-0cec-48d0-ac0d-9cbcc2c60552");
72
    public static final UUID uuidCroatianExclusiveEconomicZone = UUID.fromString("028b045a-b1bd-4a72-a4c2-a3d0473b8257");
73
    public static final UUID uuidDanishExclusiveEconomicZone = UUID.fromString("53d5a8bd-804b-4cbb-b5ad-f47ff6433db0");
74
    public static final UUID uuidDutchExclusiveEconomicZone = UUID.fromString("a1bd019e-e2af-41c8-a5e4-c7245b575759");
75
    public static final UUID uuidEgyptianExclusiveEconomicZone = UUID.fromString("e542bcfd-0ff1-49ac-a6ae-c0b3db39e560");
76
    public static final UUID uuidEnglishChannel = UUID.fromString("3ed96112-bb4a-47df-b489-2c198d6f0fd2");
77
    public static final UUID uuidEstonianExclusiveEconomicZone = UUID.fromString("ed17f07b-357f-4b4a-9653-3a564fdd32e5");
59 78
	public static final UUID uuidEuropeanMarineWaters = UUID.fromString("47389e42-3b3c-4873-bded-ac030db86462");
60
	public static final UUID uuidMediterraneanSea = UUID.fromString("bde8a624-23c4-4ac3-b381-11287f5d656a");
61
	public static final UUID uuidWhiteSea = UUID.fromString("bf14bfb6-8925-4696-911c-56d3e90d4491");
62
	public static final UUID uuidNorthSea = UUID.fromString("d5ea2d46-ed97-4996-8702-0619231626b6");
63
	public static final UUID uuidBalticSea = UUID.fromString("0031cda2-4b27-49de-afa3-fdec75ee5060");
64
	public static final UUID uuidBlackSea = UUID.fromString("1f110909-7462-4ee8-a7ff-9f976701dd1d");
65
	public static final UUID uuidBarentsSea = UUID.fromString("b6fd9a4d-0ad0-4481-a0b4-5dd71c8fda8b");
66
	public static final UUID uuidCaspianSea = UUID.fromString("0d3c3850-0cec-48d0-ac0d-9cbcc2c60552");
67
	public static final UUID uuidPortugueseExclusiveEconomicZone = UUID.fromString("642336f3-41cb-4546-9a1c-ffeccbad2ef5");
68
	public static final UUID uuidBelgianExclusiveEconomicZone = UUID.fromString("02138b0f-cee1-4c56-ae12-72a5b36839af");
69 79
	public static final UUID uuidFrenchExclusiveEconomicZone = UUID.fromString("9f6a61c0-c329-4a61-a47a-f5f383737c36");
70
	public static final UUID uuidEnglishChannel = UUID.fromString("3ed96112-bb4a-47df-b489-2c198d6f0fd2");
71
	public static final UUID uuidAdriaticSea = UUID.fromString("da376165-f970-4f0c-99db-773686d66591");
72
	public static final UUID uuidBiscayBay = UUID.fromString("1461cf85-e0b4-4ac3-bdf5-efe6053af174");
73
	public static final UUID uuidDutchExclusiveEconomicZone = UUID.fromString("a1bd019e-e2af-41c8-a5e4-c7245b575759");
74
	public static final UUID uuidUnitedKingdomExclusiveEconomicZone = UUID.fromString("18ab29c0-3104-4102-ada8-6711fcdbdbb8");
75
	public static final UUID uuidSpanishExclusiveEconomicZone = UUID.fromString("68c2823a-2173-4c31-89e8-bc1439abf448");
76
	public static final UUID uuidEgyptianExclusiveEconomicZone = UUID.fromString("e542bcfd-0ff1-49ac-a6ae-c0b3db39e560");
77
	public static final UUID uuidGrecianExclusiveEconomicZone = UUID.fromString("1d14857c-30be-4d3a-bae9-8e79da0d9d1d");
78
	public static final UUID uuidTirrenoSea = UUID.fromString("6e4f8a9d-ca6e-4b23-9211-446fac35a052");
80
	public static final UUID uuidGermanExclusiveEconomicZone = UUID.fromString("a6dbea03-090f-4f5f-bf5e-27a00ab4cc1d");
79 81
	public static final UUID uuidIcelandicExclusiveEconomicZone = UUID.fromString("a121a8fb-6287-4661-9228-0816affdf3f5");
80 82
	public static final UUID uuidIrishExclusiveeconomicZone = UUID.fromString("c8fe2626-53d2-4eaa-962b-99662470b96e");
81 83
	public static final UUID uuidIrishSea = UUID.fromString("9e972ad5-b153-419e-ab7e-935b93ff881b");
82 84
	public static final UUID uuidItalianExclusiveEconomicZone = UUID.fromString("10557c6f-a33f-443a-ad8b-cd31c105bddd");
83
	public static final UUID uuidNorwegianSea = UUID.fromString("c6c44372-a963-41b2-8c12-a0b46425c523");
85
	public static final UUID uuidLebaneseExclusiveEconomicZone = UUID.fromString("d9f7dc8b-9041-4206-bf5f-5226c42a5978");
86
	public static final UUID uuidMadeiranExclusiveEconomicZone = UUID.fromString("c00f442a-4c08-4452-b979-825fa3ff97b2");
87
	public static final UUID uuidMarmaraSea = UUID.fromString("3db5d470-3265-4187-ba5a-01ecfb94ce6e");
88
	public static final UUID uuidMediterraneanSea = UUID.fromString("bde8a624-23c4-4ac3-b381-11287f5d656a");
84 89
	public static final UUID uuidMoroccanExclusiveEconomicZone = UUID.fromString("e62e5cc2-922f-4807-abd6-1b4bffbced49");
90
	public static final UUID uuidNorthBalticproper = UUID.fromString("183ec305-1e9e-4cb1-93cc-703bd64de28f");
91
	public static final UUID uuidNorthSea = UUID.fromString("d5ea2d46-ed97-4996-8702-0619231626b6");
92
	public static final UUID uuidNorwegianSea = UUID.fromString("c6c44372-a963-41b2-8c12-a0b46425c523");
85 93
	public static final UUID uuidNorwegianExclusiveEconomicZone = UUID.fromString("bd317f3e-9719-4943-ae3e-19ff0c9761be");
86
	public static final UUID uuidSkagerrak = UUID.fromString("5f63ece2-d112-4b39-80a0-bffb6c78654c");
87
	public static final UUID uuidTunisianExclusiveEconomicZone = UUID.fromString("b5972b59-6a36-45ea-88f7-0c520c99b99d");
88
	public static final UUID uuidWaddenSea = UUID.fromString("ae0c4555-8e19-479d-8a4f-e1b62939c09b");
89
	public static final UUID uuidBeltSea = UUID.fromString("780f4144-f157-45e8-ae42-cacb3ec369ba");
90
	public static final UUID uuidMarmaraSea = UUID.fromString("3db5d470-3265-4187-ba5a-01ecfb94ce6e");
94
	public static final UUID uuidPortugueseExclusiveEconomicZone = UUID.fromString("642336f3-41cb-4546-9a1c-ffeccbad2ef5");
91 95
	public static final UUID uuidSeaofAzov = UUID.fromString("5b02cb7e-8a83-446c-af47-936a2ea31a8a");
92
	public static final UUID uuidAegeanSea = UUID.fromString("65d6c443-225f-4ac0-9c86-da51502b46df");
93
	public static final UUID uuidBulgarianExclusiveEconomicZone = UUID.fromString("13e5aa21-3971-4d06-bc34-ed75a31c2f66");
96
	public static final UUID uuidSkagerrak = UUID.fromString("5f63ece2-d112-4b39-80a0-bffb6c78654c");
94 97
	public static final UUID uuidSouthBalticproper = UUID.fromString("1c2a672d-4948-455d-9877-42a8da1ff1d0");
95
	public static final UUID uuidBalticProper = UUID.fromString("12ddfcad-bf8f-43d8-a772-15ae69d37b20");
96
	public static final UUID uuidNorthBalticproper = UUID.fromString("183ec305-1e9e-4cb1-93cc-703bd64de28f");
97
	public static final UUID uuidArchipelagoSea = UUID.fromString("d9ea9d63-ec4d-4b01-967d-13f28b09a715");
98
	public static final UUID uuidBothnianSea = UUID.fromString("926f7fa3-b0a4-4763-85eb-4c3804a72333");
99
	public static final UUID uuidGermanExclusiveEconomicZone = UUID.fromString("a6dbea03-090f-4f5f-bf5e-27a00ab4cc1d");
100
	public static final UUID uuidSwedishExclusiveEconomicZone = UUID.fromString("94b0e605-d241-44e1-a301-d8911c34fdef");
101
	public static final UUID uuidUkrainianExclusiveEconomicZone = UUID.fromString("b7335968-e34f-412c-91a5-5dc0b73310e7");
102
	public static final UUID uuidMadeiranExclusiveEconomicZone = UUID.fromString("c00f442a-4c08-4452-b979-825fa3ff97b2");
103
	public static final UUID uuidLebaneseExclusiveEconomicZone = UUID.fromString("d9f7dc8b-9041-4206-bf5f-5226c42a5978");
98
	public static final UUID uuidSpanishExclusiveEconomicZone = UUID.fromString("68c2823a-2173-4c31-89e8-bc1439abf448");
104 99
	public static final UUID uuidSpanishExclusiveEconomicZoneMediterraneanpart = UUID.fromString("94ccf304-9687-41b6-a14b-019509adb723");
105
	public static final UUID uuidEstonianExclusiveEconomicZone = UUID.fromString("ed17f07b-357f-4b4a-9653-3a564fdd32e5");
106
	public static final UUID uuidCroatianExclusiveEconomicZone = UUID.fromString("028b045a-b1bd-4a72-a4c2-a3d0473b8257");
107
	public static final UUID uuidBalearSea = UUID.fromString("478f30f0-01b1-4772-9d01-3a0a571f41c3");
100
	public static final UUID uuidSwedishExclusiveEconomicZone = UUID.fromString("94b0e605-d241-44e1-a301-d8911c34fdef");
101
	public static final UUID uuidTirrenoSea = UUID.fromString("6e4f8a9d-ca6e-4b23-9211-446fac35a052");
102
	public static final UUID uuidTunisianExclusiveEconomicZone = UUID.fromString("b5972b59-6a36-45ea-88f7-0c520c99b99d");
108 103
	public static final UUID uuidTurkishExclusiveEconomicZone = UUID.fromString("3d552e73-2bf5-4f36-8a91-94fbead970e5");
109
	public static final UUID uuidDanishExclusiveEconomicZone = UUID.fromString("53d5a8bd-804b-4cbb-b5ad-f47ff6433db0");
104
	public static final UUID uuidUkrainianExclusiveEconomicZone = UUID.fromString("b7335968-e34f-412c-91a5-5dc0b73310e7");
105
	public static final UUID uuidUnitedKingdomExclusiveEconomicZone = UUID.fromString("18ab29c0-3104-4102-ada8-6711fcdbdbb8");
106
	public static final UUID uuidWaddenSea = UUID.fromString("ae0c4555-8e19-479d-8a4f-e1b62939c09b");
107
	public static final UUID uuidWhiteSea = UUID.fromString("bf14bfb6-8925-4696-911c-56d3e90d4491");
110 108

  
109
	public static final UUID uuidAlboranSea = UUID.fromString("a4f1ef1e-0bda-4be0-95f9-59ed4f536fb6");
110
	public static final UUID uuidAlgeria = UUID.fromString("d254b5bb-e24c-4f79-88dd-80a75cd935db");
111
	public static final UUID uuidAngola = UUID.fromString("fdb74fd7-e6a1-48ff-8721-f1db6e0d93ee");
112
	public static final UUID uuidAustralianExclusiveEconomicZone = UUID.fromString("de8f70b9-3cac-48d5-b456-5cd489df5c26");
113
	public static final UUID uuidAzoresExclusiveEconomicZone = UUID.fromString("e0297e2c-d28a-46aa-8b30-694148b0640d");
114
	public static final UUID uuidBahamas = UUID.fromString("3e7eb2e5-975b-433c-9dc0-106ba16fd6e4");
115
	public static final UUID uuidBalearicSea = UUID.fromString("f2eb56e0-0eac-4def-8143-c87f8bd04613");
111 116
	public static final UUID uuidBayOfBiscay = UUID.fromString("36ffc01e-85a2-4f71-91fd-012d0b1eeff5");
117
	public static final UUID uuidBelgium = UUID.fromString("4480742d-d760-4ec8-8ee6-24b889143ec1");
118
	public static final UUID uuidBelize = UUID.fromString("d70dcf11-143c-48ce-bb8d-436600e3eb64");
119
	public static final UUID uuidBrazil = UUID.fromString("597c66d5-528f-4eaa-aa71-c4ffc7d3d226");
120
	public static final UUID uuidBulgaria = UUID.fromString("27dc2a12-943a-4e9f-88ac-70896f857bc5");
121
	public static final UUID uuidCanada = UUID.fromString("65dd3c29-3cd0-4233-bd0e-b112bb27e519");
122
	public static final UUID uuidCaribbeanSea = UUID.fromString("a1f1d511-2e62-4a73-a399-90bfffd8af56");
123
    public static final UUID uuidCapeVerde = UUID.fromString("4704c7ff-cd3d-4460-81d6-a925b81657e1");
124
	public static final UUID uuidCapeVerdeanExclusiveEconomicZone = UUID.fromString("1c951957-630a-4467-87be-ac9daba184a4");
125
	public static final UUID uuidChile = UUID.fromString("a191ee04-2a58-47fd-aa12-566c9f16ee02");
126
	public static final UUID uuidColombia = UUID.fromString("b1719057-9f4a-4042-8f85-7097afca2ba8");
127
	public static final UUID uuidCostaRica = UUID.fromString("acbe3731-8568-400c-b666-dfdbc8f5cc9f");
128
	public static final UUID uuidCroatia = UUID.fromString("f9d6a5ac-590e-4618-8fe1-a047fd9e1b32");
129
	public static final UUID uuidCuba = UUID.fromString("17ae1220-7cc2-4dc5-bdd5-b852889b7dda");
130
	public static final UUID uuidDenmark = UUID.fromString("3338dd30-98cd-4469-96b1-d8b79ae42ed5");
131
	public static final UUID uuidEgypt = UUID.fromString("830d2178-722e-4668-922b-380501b031dd");
132
	public static final UUID uuidEstonia = UUID.fromString("7b2953cc-7ee7-45cf-b0e6-db229b0d88a3");
133
	public static final UUID uuidFaeroeExclusiveEconomicZone = UUID.fromString("b9a80017-0177-4d1e-83e2-d93d2e764b92");
134
	public static final UUID uuidFrance = UUID.fromString("b7876595-230d-4ac8-bbcf-0a271221aeb0");
135
	public static final UUID uuidGhana = UUID.fromString("b550ba30-41b8-485a-a1de-ba79b4b6e152");
136
	public static final UUID uuidGreece = UUID.fromString("c004a689-048b-4541-9371-063bca1ab20e");
112 137
	public static final UUID uuidGreekExclusiveEconomicZone = UUID.fromString("6e587a2b-d681-46d3-bede-30411b0707a9");
113
	public static final UUID uuidTyrrhenianSea = UUID.fromString("26c39604-b7fd-425a-93a5-958774261d04");
114
	public static final UUID uuidBaeltSea = UUID.fromString("66ebf77f-77c1-4aea-8610-7c679835caee");
115
	public static final UUID uuidSeaOfMarmara = UUID.fromString("326da4d1-0c6c-4621-baf5-fdd04b0dc26c");
116
	public static final UUID uuidAzoresExclusiveEconomicZone = UUID.fromString("e0297e2c-d28a-46aa-8b30-694148b0640d");
117
	public static final UUID uuidIsraeliExclusiveEconomicZoneMediterranean = UUID.fromString("d947e1c1-6d7b-47e1-ad91-703d15c5c55b");
138
	public static final UUID uuidGulfOfBothnia = UUID.fromString("e0126fd6-a163-4483-92e4-abe1a96ed025");
139
	public static final UUID uuidGulfOfFinland = UUID.fromString("d312ff30-18d0-4f8a-9c80-3a06772cefbb");
140
	public static final UUID uuidGulfOfGuinea = UUID.fromString("ea6f3983-64ad-46c4-832a-51bed6507d95");
141
	public static final UUID uuidGulfOfMexico = UUID.fromString("9693deb4-82ed-40fa-822c-b5016d7fccf0");
142
	public static final UUID uuidGulfOfRiga = UUID.fromString("c16dd324-850a-4dfc-8f3b-6718c8614cae");
143
	public static final UUID uuidIceland = UUID.fromString("c3075a02-2aad-4745-9d40-45c498599b72");
144
	public static final UUID uuidIonianSea = UUID.fromString("ff4fa153-5174-48fb-9eaa-0b391ba96153");
145
	public static final UUID uuidIreland = UUID.fromString("f8e878b1-517d-420d-9445-cf92e7c8f986");
146
	public static final UUID uuidIsraeliExclusiveEconomicZone = UUID.fromString("2eb96b7c-4634-44be-a68b-1ea36593ba4a");
147
	public static final UUID uuidItaly = UUID.fromString("a8b1ade2-a70c-4902-b375-670d779a5078");
148
	public static final UUID uuidJamaica = UUID.fromString("3a0b6181-3c91-44b6-8844-a61242adddd2");
149
	public static final UUID uuidKattegat = UUID.fromString("c96bcfa2-20fc-4a23-9b1b-0da899b389c2");
150
	public static final UUID uuidLevantineSea = UUID.fromString("04fd2746-5a6e-4392-9881-0e75a2f060e9");
151
	public static final UUID uuidLigurianSea = UUID.fromString("9dcbf18e-3483-4ba8-84a4-c3c7ca2be297");
152
	public static final UUID uuidMalteseExclusiveEconomicZone = UUID.fromString("450a1f9b-6d63-4c9f-9488-b800547c5c21");
153
	public static final UUID uuidMauritanianExclusiveEconomicZone = UUID.fromString("7e9a12c3-31ee-4e09-bec0-dce173d1096e");
154
	public static final UUID uuidMediterraneanSea_EasternBasin = UUID.fromString("a67dfa4d-4a96-403b-a64c-1e294826c2ed");
155
	public static final UUID uuidMediterraneanSea_WesternBasin = UUID.fromString("b3e81fa7-ee7a-45d2-965c-88020f9ee1ea");
156
	public static final UUID uuidMexico = UUID.fromString("a9be5a5c-99ec-4627-9892-104a0c175118");
157
	public static final UUID uuidMorocco = UUID.fromString("4948e1ef-f61e-462f-9920-ab44c71ca2ae");
158
	public static final UUID uuidNetherlands = UUID.fromString("8d4152fb-bf29-4a24-a772-62ccb4a8c02f");
159
	public static final UUID uuidNewZealand = UUID.fromString("f3ff8497-00e0-4d45-9d14-eb80fea0fee0");
160
	public static final UUID uuidNewZealandExclusiveEconomicZone = UUID.fromString("b10d2637-4b44-44d5-8742-fe8576859926");
161
	public static final UUID uuidNorthAtlanticOcean = UUID.fromString("628354d1-1ded-4f3d-887e-4f90d43e0f14");
162
	public static final UUID uuidNorway = UUID.fromString("d76b5b8b-2e1e-4241-b4f1-eb3acdfc12fd");
163
	public static final UUID uuidPanama = UUID.fromString("796ed240-94bd-4558-bb99-7b1facdbc435");
164
	public static final UUID uuidPanamanianExclusiveEconomicZone = UUID.fromString("49e40b33-30d0-4905-adea-b3ce05a40450");
118 165
	public static final UUID uuidPolishExclusiveEconomicZone = UUID.fromString("dc7f8339-528b-49ec-a8d9-c2be0441e933");
166
	public static final UUID uuidPortugal = UUID.fromString("4a04d8fd-3f2f-43ec-a5c4-684c8028e6c6");
167
	public static final UUID uuidPortugueseExclusiveEconomicZone_Azores = UUID.fromString("33672f3d-dc4e-43ca-8b46-1e7d292c2fae");
168
	public static final UUID uuidPortugueseExclusiveEconomicZone_Madeira = UUID.fromString("8308b767-09be-459a-9281-67b15fb59380");
169
	public static final UUID uuidRedSea = UUID.fromString("6470eda4-738a-411d-9af7-0fd791dc9195");
170
	public static final UUID uuidRussianExclusiveEconomicZone = UUID.fromString("cb7b047e-562d-4a1e-be08-872f0679dd1f");
171
	public static final UUID uuidSeaOfMarmara = UUID.fromString("4b9dce18-0e4a-46e1-b8a0-634284f3fa18");
172
	public static final UUID uuidSenegaleseExclusiveEconomicZone = UUID.fromString("05a4a971-ed53-4133-8999-8c96ddd20e22");
173
	public static final UUID uuidSingapore = UUID.fromString("f68a178f-093f-427b-9431-ed2564516e90");
174
	public static final UUID uuidSlovenianExclusiveEconomicZone = UUID.fromString("b5b06645-da20-4fc3-b964-09e4bbb63337");
175
	public static final UUID uuidSouthAfrica = UUID.fromString("0004d255-7dbe-47e2-9acc-6086a5ac6719");
176
	public static final UUID uuidSouthAfricanExclusiveEconomicZone = UUID.fromString("cba99c12-040b-4e17-9b20-2350ec4201c2");
177
	public static final UUID uuidSouthChinaSea = UUID.fromString("b91b1cae-0c9d-4d73-b3c7-98312664f4b4");
178
	public static final UUID uuidSpain = UUID.fromString("36b5a55c-6fd8-4fab-bd01-d776fb1f357e");
179
	public static final UUID uuidSpanishExclusiveEconomicZone_CanaryIslands = UUID.fromString("30404044-c1e5-4757-92fd-0b1851c7d801");
180
	public static final UUID uuidSriLankanExclusiveEconomicZone = UUID.fromString("be08163d-9e4c-44ad-b1f6-0592497724e1");
181
	public static final UUID uuidStraitOfGibraltar = UUID.fromString("0cdd58d4-cf46-4ea2-b841-bcfcb1ee2195");
182
	public static final UUID uuidSweden = UUID.fromString("dade7b65-d408-4017-a16c-f5ea7aeb3783");
183
	public static final UUID uuidTunisia = UUID.fromString("e7caa4b3-cf79-4ea0-8468-2438c2a201c6");
184
	public static final UUID uuidTurkey = UUID.fromString("0fbbf26a-7743-44d3-a7e4-2783016a37ed");
185
	public static final UUID uuidTyrrhenianSea = UUID.fromString("26c39604-b7fd-425a-93a5-958774261d04");
186
	public static final UUID uuidUnitedKingdom = UUID.fromString("a066c48c-6821-4acb-a454-3e1564e17cfe");
187
	public static final UUID uuidUnitedStates = UUID.fromString("44d0c16c-b9d0-4db2-8776-34d230222caa");
188
    public static final UUID uuidUnitedStatesExclusiveEconomicZone_Alaska = UUID.fromString("2d7d93fe-68ac-43d1-9d3a-92ccb8000ae6");
189
	public static final UUID uuidVenezuela = UUID.fromString("c19956af-02e6-4868-97ef-135db405cc75");
119 190

  
120 191
	//feature uuids
121 192
	public static final UUID uuidRemark = UUID.fromString("648eab77-8469-4139-bbf4-3fb26ec15864");
......
289 360

  
290 361
	public static UUID uuidFromGuName(String guName){
291 362
		if (StringUtils.isBlank(guName)){return null;
292
		}else if (guName.equalsIgnoreCase("European Marine Waters")){ return uuidEuropeanMarineWaters;
293
		}else if (guName.equalsIgnoreCase("Mediterranean Sea")){ return uuidMediterraneanSea;
294
		}else if (guName.equalsIgnoreCase("White Sea")){ return uuidWhiteSea;
295
		}else if (guName.equalsIgnoreCase("North Sea")){ return uuidNorthSea;
363
		}else if (guName.equalsIgnoreCase("Adriatic Sea")){ return uuidAdriaticSea;
364
		}else if (guName.equalsIgnoreCase("Aegean Sea")){ return uuidAegeanSea;
365
		}else if (guName.equalsIgnoreCase("Archipelago Sea")){ return uuidArchipelagoSea;
366
		}else if (guName.equalsIgnoreCase("Balear Sea")){ return uuidBalearSea;
367
		}else if (guName.equalsIgnoreCase("Baltic Proper")){ return uuidBalticProper;
296 368
		}else if (guName.equalsIgnoreCase("Baltic Sea")){ return uuidBalticSea;
297
		}else if (guName.equalsIgnoreCase("Black Sea")){ return uuidBlackSea;
298 369
		}else if (guName.equalsIgnoreCase("Barents Sea")){ return uuidBarentsSea;
299
		}else if (guName.equalsIgnoreCase("Caspian Sea")){ return uuidCaspianSea;
300
		}else if (guName.equalsIgnoreCase("Portuguese Exclusive Economic Zone")){ return uuidPortugueseExclusiveEconomicZone;
301 370
		}else if (guName.equalsIgnoreCase("Belgian Exclusive Economic Zone")){ return uuidBelgianExclusiveEconomicZone;
302
		}else if (guName.equalsIgnoreCase("French Exclusive Economic Zone")){ return uuidFrenchExclusiveEconomicZone;
303
		}else if (guName.equalsIgnoreCase("English Channel")){ return uuidEnglishChannel;
304
		}else if (guName.equalsIgnoreCase("Adriatic Sea")){ return uuidAdriaticSea;
371
		}else if (guName.equalsIgnoreCase("Belt Sea")
372
		        || guName.equalsIgnoreCase("Baelt Sea")){ return uuidBeltSea;
305 373
		}else if (guName.equalsIgnoreCase("Biscay Bay")){ return uuidBiscayBay;
374
		}else if (guName.equalsIgnoreCase("Black Sea")){ return uuidBlackSea;
375
		}else if (guName.equalsIgnoreCase("Bothnian Sea")){ return uuidBothnianSea;
376
		}else if (guName.equalsIgnoreCase("Bulgarian Exclusive Economic Zone")){ return uuidBulgarianExclusiveEconomicZone;
377
		}else if (guName.equalsIgnoreCase("Caspian Sea")){ return uuidCaspianSea;
378
		}else if (guName.equalsIgnoreCase("Croatian Exclusive Economic Zone")){ return uuidCroatianExclusiveEconomicZone;
379
		}else if (guName.equalsIgnoreCase("Danish Exclusive Economic Zone")){ return uuidDanishExclusiveEconomicZone;
306 380
		}else if (guName.equalsIgnoreCase("Dutch Exclusive Economic Zone")){ return uuidDutchExclusiveEconomicZone;
307
		}else if (guName.equalsIgnoreCase("United Kingdom Exclusive Economic Zone")){ return uuidUnitedKingdomExclusiveEconomicZone;
308
		}else if (guName.equalsIgnoreCase("Spanish Exclusive Economic Zone")){ return uuidSpanishExclusiveEconomicZone;
309 381
		}else if (guName.equalsIgnoreCase("Egyptian Exclusive Economic Zone")){ return uuidEgyptianExclusiveEconomicZone;
310
		}else if (guName.equalsIgnoreCase("Grecian Exclusive Economic Zone")){ return uuidGrecianExclusiveEconomicZone;
311
		}else if (guName.equalsIgnoreCase("Tirreno Sea")){ return uuidTirrenoSea;
382
		}else if (guName.equalsIgnoreCase("English Channel")){ return uuidEnglishChannel;
383
		}else if (guName.equalsIgnoreCase("Estonian Exclusive Economic Zone")){ return uuidEstonianExclusiveEconomicZone;
384
		}else if (guName.equalsIgnoreCase("European Marine Waters")){ return uuidEuropeanMarineWaters;
385
		}else if (guName.equalsIgnoreCase("French Exclusive Economic Zone")){ return uuidFrenchExclusiveEconomicZone;
386
		}else if (guName.equalsIgnoreCase("German Exclusive Economic Zone")){ return uuidGermanExclusiveEconomicZone;
312 387
		}else if (guName.equalsIgnoreCase("Icelandic Exclusive Economic Zone")){ return uuidIcelandicExclusiveEconomicZone;
313 388
		}else if (guName.equalsIgnoreCase("Irish Exclusive economic Zone")){ return uuidIrishExclusiveeconomicZone;
314
		}else if (guName.equalsIgnoreCase("Irish Sea")){ return uuidIrishSea;
389
		}else if (guName.equalsIgnoreCase("Irish Sea")||
390
		        guName.equalsIgnoreCase("Irish Sea and St. George's Channel")){ return uuidIrishSea;
315 391
		}else if (guName.equalsIgnoreCase("Italian Exclusive Economic Zone")){ return uuidItalianExclusiveEconomicZone;
316
		}else if (guName.equalsIgnoreCase("Norwegian Sea")){ return uuidNorwegianSea;
392
		}else if (guName.equalsIgnoreCase("Lebanese Exclusive Economic Zone")){ return uuidLebaneseExclusiveEconomicZone;
393
		}else if (guName.equalsIgnoreCase("Madeiran Exclusive Economic Zone")){ return uuidMadeiranExclusiveEconomicZone;
394
		}else if (guName.equalsIgnoreCase("Marmara Sea")){ return uuidMarmaraSea;
395
		}else if (guName.equalsIgnoreCase("Mediterranean Sea")){ return uuidMediterraneanSea;
317 396
		}else if (guName.equalsIgnoreCase("Moroccan Exclusive Economic Zone")){ return uuidMoroccanExclusiveEconomicZone;
397
		}else if (guName.equalsIgnoreCase("North Baltic proper")){ return uuidNorthBalticproper;
398
		}else if (guName.equalsIgnoreCase("North Sea")){ return uuidNorthSea;
318 399
		}else if (guName.equalsIgnoreCase("Norwegian Exclusive Economic Zone")){ return uuidNorwegianExclusiveEconomicZone;
319
		}else if (guName.equalsIgnoreCase("Skagerrak")){ return uuidSkagerrak;
320
		}else if (guName.equalsIgnoreCase("Tunisian Exclusive Economic Zone")){ return uuidTunisianExclusiveEconomicZone;
321
		}else if (guName.equalsIgnoreCase("Wadden Sea")){ return uuidWaddenSea;
322
		}else if (guName.equalsIgnoreCase("Belt Sea")){ return uuidBeltSea;
323
		}else if (guName.equalsIgnoreCase("Marmara Sea")){ return uuidMarmaraSea;
400
		}else if (guName.equalsIgnoreCase("Norwegian Sea")){ return uuidNorwegianSea;
401
		}else if (guName.equalsIgnoreCase("Portuguese Exclusive Economic Zone")){ return uuidPortugueseExclusiveEconomicZone;
324 402
		}else if (guName.equalsIgnoreCase("Sea of Azov")){ return uuidSeaofAzov;
325
		}else if (guName.equalsIgnoreCase("Aegean Sea")){ return uuidAegeanSea;
326
		}else if (guName.equalsIgnoreCase("Bulgarian Exclusive Economic Zone")){ return uuidBulgarianExclusiveEconomicZone;
403
		}else if (guName.equalsIgnoreCase("Skagerrak")){ return uuidSkagerrak;
327 404
		}else if (guName.equalsIgnoreCase("South Baltic proper")){ return uuidSouthBalticproper;
328
		}else if (guName.equalsIgnoreCase("Baltic Proper")){ return uuidBalticProper;
329
		}else if (guName.equalsIgnoreCase("North Baltic proper")){ return uuidNorthBalticproper;
330
		}else if (guName.equalsIgnoreCase("Archipelago Sea")){ return uuidArchipelagoSea;
331
		}else if (guName.equalsIgnoreCase("Bothnian Sea")){ return uuidBothnianSea;
332
		}else if (guName.equalsIgnoreCase("German Exclusive Economic Zone")){ return uuidGermanExclusiveEconomicZone;
333
		}else if (guName.equalsIgnoreCase("Swedish Exclusive Economic Zone")){ return uuidSwedishExclusiveEconomicZone;
334
		}else if (guName.equalsIgnoreCase("Ukrainian Exclusive Economic Zone")){ return uuidUkrainianExclusiveEconomicZone;
335
		}else if (guName.equalsIgnoreCase("Madeiran Exclusive Economic Zone")){ return uuidMadeiranExclusiveEconomicZone;
336
		}else if (guName.equalsIgnoreCase("Lebanese Exclusive Economic Zone")){ return uuidLebaneseExclusiveEconomicZone;
405
		}else if (guName.equalsIgnoreCase("Spanish Exclusive Economic Zone")){ return uuidSpanishExclusiveEconomicZone;
337 406
		}else if (guName.equalsIgnoreCase("Spanish Exclusive Economic Zone [Mediterranean part]")){ return uuidSpanishExclusiveEconomicZoneMediterraneanpart;
338
		}else if (guName.equalsIgnoreCase("Estonian Exclusive Economic Zone")){ return uuidEstonianExclusiveEconomicZone;
339
		}else if (guName.equalsIgnoreCase("Croatian Exclusive Economic Zone")){ return uuidCroatianExclusiveEconomicZone;
340
		}else if (guName.equalsIgnoreCase("Balear Sea")){ return uuidBalearSea;
407
		}else if (guName.equalsIgnoreCase("Swedish Exclusive Economic Zone")){ return uuidSwedishExclusiveEconomicZone;
408
		}else if (guName.equalsIgnoreCase("Tirreno Sea")){ return uuidTirrenoSea;
409
		}else if (guName.equalsIgnoreCase("Tunisian Exclusive Economic Zone")){ return uuidTunisianExclusiveEconomicZone;
341 410
		}else if (guName.equalsIgnoreCase("Turkish Exclusive Economic Zone")){ return uuidTurkishExclusiveEconomicZone;
342
		}else if (guName.equalsIgnoreCase("Danish Exclusive Economic Zone")){ return uuidDanishExclusiveEconomicZone;
411
		}else if (guName.equalsIgnoreCase("Ukrainian Exclusive Economic Zone")||
412
		        guName.equalsIgnoreCase("Overlapping claim Ukrainian Exclusive Economic Zone")){ return uuidUkrainianExclusiveEconomicZone;
413
		}else if (guName.equalsIgnoreCase("United Kingdom Exclusive Economic Zone")){ return uuidUnitedKingdomExclusiveEconomicZone;
414
		}else if (guName.equalsIgnoreCase("Wadden Sea")){ return uuidWaddenSea;
415
		}else if (guName.equalsIgnoreCase("White Sea")){ return uuidWhiteSea;
343 416

  
417
		}else if (guName.equalsIgnoreCase("Azores Exclusive Economic Zone")){ return uuidAzoresExclusiveEconomicZone;
344 418
		}else if (guName.equalsIgnoreCase("Bay of Biscay")){ return uuidBayOfBiscay;
345 419
		}else if (guName.equalsIgnoreCase("Greek Exclusive Economic Zone")){ return uuidGreekExclusiveEconomicZone;
420
		}else if (guName.equalsIgnoreCase("Polish Exclusive Economic Zone")){ return uuidPolishExclusiveEconomicZone;
346 421
		}else if (guName.equalsIgnoreCase("Tyrrhenian Sea")){ return uuidTyrrhenianSea;
347
		}else if (guName.equalsIgnoreCase("Baelt Sea")){ return uuidBaeltSea;
422

  
423
		}else if (guName.equalsIgnoreCase("Alboran Sea")){ return uuidAlboranSea;
424
		}else if (guName.equalsIgnoreCase("Algeria")){ return uuidAlgeria;
425
		}else if (guName.equalsIgnoreCase("Angola")){ return uuidAngola;
426
		}else if (guName.equalsIgnoreCase("Australian Exclusive Economic Zone")){ return uuidAustralianExclusiveEconomicZone;
427
		}else if (guName.equalsIgnoreCase("Bahamas")){ return uuidBahamas;
428
		}else if (guName.equalsIgnoreCase("Balearic Sea")){ return uuidBalearicSea;
429
		}else if (guName.equalsIgnoreCase("Belgium")){ return uuidBelgium;
430
		}else if (guName.equalsIgnoreCase("Belize")){ return uuidBelize;
431
		}else if (guName.equalsIgnoreCase("Brazil")){ return uuidBrazil;
432
		}else if (guName.equalsIgnoreCase("Bulgaria")){ return uuidBulgaria;
433
		}else if (guName.equalsIgnoreCase("Canada")){ return uuidCanada;
434
		}else if (guName.equalsIgnoreCase("Caribbean Sea")){ return uuidCaribbeanSea;
435
		}else if (guName.equalsIgnoreCase("Cape Verde")){ return uuidCapeVerde;
436
		}else if (guName.equalsIgnoreCase("Cape Verdean Exclusive Economic Zone")){ return uuidCapeVerdeanExclusiveEconomicZone;
437
		}else if (guName.equalsIgnoreCase("Chile")){ return uuidChile;
438
		}else if (guName.equalsIgnoreCase("Colombia")){ return uuidColombia;
439
		}else if (guName.equalsIgnoreCase("Costa Rica")){ return uuidCostaRica;
440
		}else if (guName.equalsIgnoreCase("Croatia")){ return uuidCroatia;
441
		}else if (guName.equalsIgnoreCase("Cuba")){ return uuidCuba;
442
		}else if (guName.equalsIgnoreCase("Denmark")){ return uuidDenmark;
443
		}else if (guName.equalsIgnoreCase("Egypt")){ return uuidEgypt;
444
		}else if (guName.equalsIgnoreCase("Estonia")){ return uuidEstonia;
445
		}else if (guName.equalsIgnoreCase("Faeroe Exclusive Economic Zone")){ return uuidFaeroeExclusiveEconomicZone;
446
		}else if (guName.equalsIgnoreCase("France")){ return uuidFrance;
447
		}else if (guName.equalsIgnoreCase("Ghana")){ return uuidGhana;
448
		}else if (guName.equalsIgnoreCase("Greece")){ return uuidGreece;
449
		}else if (guName.equalsIgnoreCase("Gulf of Bothnia")){ return uuidGulfOfBothnia;
450
		}else if (guName.equalsIgnoreCase("Gulf of Finland")){ return uuidGulfOfFinland;
451
		}else if (guName.equalsIgnoreCase("Gulf of Guinea")){ return uuidGulfOfGuinea;
452
		}else if (guName.equalsIgnoreCase("Gulf of Mexico")){ return uuidGulfOfMexico;
453
		}else if (guName.equalsIgnoreCase("Gulf of Riga")){ return uuidGulfOfRiga;
454
		}else if (guName.equalsIgnoreCase("Iceland")){ return uuidIceland;
455
		}else if (guName.equalsIgnoreCase("Ionian Sea")){ return uuidIonianSea;
456
		}else if (guName.equalsIgnoreCase("Ireland")){ return uuidIreland;
457
		}else if (guName.equalsIgnoreCase("Israeli Exclusive Economic Zone")){return uuidIsraeliExclusiveEconomicZone;
458
		}else if (guName.equalsIgnoreCase("Italy")){ return uuidItaly;
459
		}else if (guName.equalsIgnoreCase("Jamaica")){ return uuidJamaica;
460
		}else if (guName.equalsIgnoreCase("Kattegat")){ return uuidKattegat;
461
		}else if (guName.equalsIgnoreCase("Levantine Sea")){ return uuidLevantineSea;
462
		}else if (guName.equalsIgnoreCase("Ligurian Sea")){ return uuidLigurianSea;
463
		}else if (guName.equalsIgnoreCase("Maltese Exclusive Economic Zone")){ return uuidMalteseExclusiveEconomicZone;
464
		}else if (guName.equalsIgnoreCase("Mauritanian Exclusive Economic Zone")){ return uuidMauritanianExclusiveEconomicZone;
465
		}else if (guName.equalsIgnoreCase("Mediterranean Sea - Eastern Basin")){ return uuidMediterraneanSea_EasternBasin;
466
		}else if (guName.equalsIgnoreCase("Mediterranean Sea - Western Basin")){ return uuidMediterraneanSea_WesternBasin;
467
		}else if (guName.equalsIgnoreCase("Mexico")){ return uuidMexico;
468
		}else if (guName.equalsIgnoreCase("Morocco")){ return uuidMorocco;
469
		}else if (guName.equalsIgnoreCase("Netherlands")){ return uuidNetherlands;
470
		}else if (guName.equalsIgnoreCase("New Zealand")){ return uuidNewZealand;
471
		}else if (guName.equalsIgnoreCase("New Zealand Exclusive Economic Zone")){ return uuidNewZealandExclusiveEconomicZone;
472
		}else if (guName.equalsIgnoreCase("North Atlantic Ocean")){ return uuidNorthAtlanticOcean;
473
		}else if (guName.equalsIgnoreCase("Norway")){ return uuidNorway;
474
		}else if (guName.equalsIgnoreCase("Panama")){ return uuidPanama;
475
		}else if (guName.equalsIgnoreCase("Panamanian Exclusive Economic Zone")){ return uuidPanamanianExclusiveEconomicZone;
476
		}else if (guName.equalsIgnoreCase("Portugal")){ return uuidPortugal;
477
		}else if (guName.equalsIgnoreCase("Portuguese Exclusive Economic Zone (Azores)")){ return uuidPortugueseExclusiveEconomicZone_Azores;
478
		}else if (guName.equalsIgnoreCase("Portuguese Exclusive Economic Zone (Madeira)")){ return uuidPortugueseExclusiveEconomicZone_Madeira;
479
		}else if (guName.equalsIgnoreCase("Red Sea")){ return uuidRedSea;
480
		}else if (guName.equalsIgnoreCase("Russian Exclusive economic Zone")){ return uuidRussianExclusiveEconomicZone;
348 481
		}else if (guName.equalsIgnoreCase("Sea of Marmara")){ return uuidSeaOfMarmara;
349
		}else if (guName.equalsIgnoreCase("Azores Exclusive Economic Zone")){ return uuidAzoresExclusiveEconomicZone;
350
		}else if (guName.equalsIgnoreCase("Israeli Exclusive Economic Zone [Mediterranean part]")){ return uuidIsraeliExclusiveEconomicZoneMediterranean;
351
		}else if (guName.equalsIgnoreCase("Polish Exclusive Economic Zone")){ return uuidPolishExclusiveEconomicZone;
482
		}else if (guName.equalsIgnoreCase("Senegalese Exclusive Economic Zone")){ return uuidSenegaleseExclusiveEconomicZone;
483
		}else if (guName.equalsIgnoreCase("Singapore")){ return uuidSingapore;
484
		}else if (guName.equalsIgnoreCase("Slovenian Exclusive Economic Zone")){ return uuidSlovenianExclusiveEconomicZone;
485
		}else if (guName.equalsIgnoreCase("South Africa")){ return uuidSouthAfrica;
486
		}else if (guName.equalsIgnoreCase("South African Exclusive Economic Zone")){ return uuidSouthAfricanExclusiveEconomicZone;
487
		}else if (guName.equalsIgnoreCase("South China Sea")){ return uuidSouthChinaSea;
488
		}else if (guName.equalsIgnoreCase("Spain")){ return uuidSpain;
489
		}else if (guName.equalsIgnoreCase("Spanish Exclusive Economic Zone (Canary Islands)")){ return uuidSpanishExclusiveEconomicZone_CanaryIslands;
490
		}else if (guName.equalsIgnoreCase("Sri Lankan Exclusive Economic Zone")){ return uuidSriLankanExclusiveEconomicZone;
491
		}else if (guName.equalsIgnoreCase("Strait of Gibraltar")){ return uuidStraitOfGibraltar;
492
		}else if (guName.equalsIgnoreCase("Sweden")){ return uuidSweden;
493
		}else if (guName.equalsIgnoreCase("Tunisia")){ return uuidTunisia;
494
		}else if (guName.equalsIgnoreCase("Turkey")){ return uuidTurkey;
495
		}else if (guName.equalsIgnoreCase("United Kingdom")){ return uuidUnitedKingdom;
496
        }else if (guName.equalsIgnoreCase("United States")){ return uuidUnitedStates;
497
		}else if (guName.equalsIgnoreCase("United States Exclusive Economic Zone (Alaska)")){ return uuidUnitedStatesExclusiveEconomicZone_Alaska;
498
		}else if (guName.equalsIgnoreCase("Venezuela")){ return uuidVenezuela;
352 499

  
353 500
		}else{
354 501
			throw new IllegalArgumentException("Unknown area " + guName);
355 502
		}
356 503
	}
357 504

  
358
	public static UUID uuidFromGuId(Integer guId){
359
		if (guId == null){return null;
360
		}else if (guId == 7788){ return uuidEuropeanMarineWaters;
361
		}else if (guId == 7789){ return uuidMediterraneanSea;
362
		}else if (guId == 7791){ return uuidWhiteSea;
363
		}else if (guId == 7792){ return uuidNorthSea;
364
		}else if (guId == 7793){ return uuidBalticSea;
365
		}else if (guId == 7794){ return uuidBlackSea;
366
		}else if (guId == 7795){ return uuidBarentsSea;
367
		}else if (guId == 7796){ return uuidCaspianSea;
368
		}else if (guId == 7799){ return uuidPortugueseExclusiveEconomicZone;
369
		}else if (guId == 7802){ return uuidBelgianExclusiveEconomicZone;
370
		}else if (guId == 7805){ return uuidFrenchExclusiveEconomicZone;
371
		}else if (guId == 7818){ return uuidEnglishChannel;
372
		}else if (guId == 7821){ return uuidAdriaticSea;
373
		}else if (guId == 7831){ return uuidBiscayBay;
374
		}else if (guId == 7839){ return uuidDutchExclusiveEconomicZone;
375
		}else if (guId == 7862){ return uuidUnitedKingdomExclusiveEconomicZone;
376
		}else if (guId == 7869){ return uuidSpanishExclusiveEconomicZone;
377
		}else if (guId == 7902){ return uuidEgyptianExclusiveEconomicZone;
378
		}else if (guId == 7939){ return uuidGrecianExclusiveEconomicZone;
379
		}else if (guId == 7946){ return uuidTirrenoSea;
380
		}else if (guId == 7964){ return uuidIcelandicExclusiveEconomicZone;
381
		}else if (guId == 7974){ return uuidIrishExclusiveeconomicZone;
382
		}else if (guId == 7975){ return uuidIrishSea;
383
		}else if (guId == 7978){ return uuidItalianExclusiveEconomicZone;
384
		}else if (guId == 7980){ return uuidNorwegianSea;
385
		}else if (guId == 8027){ return uuidMoroccanExclusiveEconomicZone;
386
		}else if (guId == 8050){ return uuidNorwegianExclusiveEconomicZone;
387
		}else if (guId == 8072){ return uuidSkagerrak;
388
		}else if (guId == 8143){ return uuidTunisianExclusiveEconomicZone;
389
		}else if (guId == 8155){ return uuidWaddenSea;
390
		}else if (guId == 8203){ return uuidBeltSea;
391
		}else if (guId == 8205){ return uuidMarmaraSea;
392
		}else if (guId == 8837){ return uuidSeaofAzov;
393
		}else if (guId == 9146){ return uuidAegeanSea;
394
		}else if (guId == 9178){ return uuidBulgarianExclusiveEconomicZone;
395
		}else if (guId == 9903){ return uuidSouthBalticproper;
396
		}else if (guId == 9904){ return uuidBalticProper;
397
		}else if (guId == 9905){ return uuidNorthBalticproper;
398
		}else if (guId == 9908){ return uuidArchipelagoSea;
399
		}else if (guId == 9909){ return uuidBothnianSea;
400
		}else if (guId == 10515){ return uuidGermanExclusiveEconomicZone;
401
		}else if (guId == 10528){ return uuidSwedishExclusiveEconomicZone;
402
		}else if (guId == 10529){ return uuidUkrainianExclusiveEconomicZone;
403
		}else if (guId == 10564){ return uuidMadeiranExclusiveEconomicZone;
404
		}else if (guId == 10574){ return uuidLebaneseExclusiveEconomicZone;
405
		}else if (guId == 10659){ return uuidSpanishExclusiveEconomicZoneMediterraneanpart;
406
		}else if (guId == 10708){ return uuidEstonianExclusiveEconomicZone;
407
		}else if (guId == 10778){ return uuidCroatianExclusiveEconomicZone;
408
		}else if (guId == 10779){ return uuidBalearSea;
409
		}else if (guId == 10782){ return uuidTurkishExclusiveEconomicZone;
410
		}else if (guId == 11039){ return uuidDanishExclusiveEconomicZone;
411

  
412
		}else{
413
			throw new IllegalArgumentException("Unknown area id " + guId);
414
		}
415
	}
416

  
417 505
	public static Feature noteType2Feature(String type){
418 506
		if (StringUtils.isBlank(type)){return null;
419 507
		}else if (type.equals("Remark")){return Feature.UNKNOWN();
cdm-pesi/src/main/java/eu/etaxonomy/cdm/io/pesi/out/PesiTransformer.java
708 708
	public static int AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE = 163;
709 709
	public static int AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE = 164;
710 710
	public static int AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE = 165;
711
	public static int AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE = 166;
711
	public static int AREA_GREEK_EXCLUSIVE_ECONOMIC_ZONE = 166;
712 712
	public static int AREA_TIRRENO_SEA = 167;
713 713
	public static int AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE = 168;
714 714
	public static int AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE = 169;
......
753 753
	public static int AREA_SPAIN_COUNTRY = 206;
754 754
	public static int AREA_GREECE_COUNTRY = 207;
755 755
	public static int AREA_PORTUGAL_COUNTRY = 208;
756
	//continues without variables
756 757

  
757 758
	// OccurrenceStatus
758 759
	public static int STATUS_PRESENT = 1;
......
1246 1247
					(namedArea.getUuid().equals(ErmsTransformer.uuidBlackSea))) { return AREA_BLACK_SEA; } // abbreviated label missing
1247 1248
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBarentsSea)) { return AREA_BARENTS_SEA; }
1248 1249
			else if ((namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel()).equals("CAS") ||
1249
					(namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return AREA_CASPIAN_SEA; } // abbreviated label missingelse if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1250
					(namedArea.getUuid().equals(ErmsTransformer.uuidCaspianSea))) { return AREA_CASPIAN_SEA; } // abbreviated label missing
1251
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone)) { return AREA_PORTUGUESE_EXCLUSIVE_ECONOMIC_ZONE; }
1250 1252
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgianExclusiveEconomicZone)) { return AREA_BELGIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1251 1253
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrenchExclusiveEconomicZone)) { return AREA_FRENCH_EXCLUSIVE_ECONOMIC_ZONE; }
1252 1254
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEnglishChannel)) { return AREA_ENGLISH_CHANNEL; }
......
1256 1258
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdomExclusiveEconomicZone)) { return AREA_UNITED_KINGDOM_EXCLUSIVE_ECONOMIC_ZONE; }
1257 1259
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone)) { return AREA_SPANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1258 1260
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgyptianExclusiveEconomicZone)) { return AREA_EGYPTIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1259
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGrecianExclusiveEconomicZone)) { return AREA_GRECIAN_EXCLUSIVE_ECONOMIC_ZONE; }
1260 1261
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTirrenoSea)) { return AREA_TIRRENO_SEA; }
1261 1262
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIcelandicExclusiveEconomicZone)) { return AREA_ICELANDIC_EXCLUSIVE_ECONOMIC_ZONE; }
1262 1263
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIrishExclusiveeconomicZone)) { return AREA_IRISH_EXCLUSIVE_ECONOMIC_ZONE; }
......
1289 1290
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearSea)) { return AREA_BALEAR_SEA; }
1290 1291
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkishExclusiveEconomicZone)) { return AREA_TURKISH_EXCLUSIVE_ECONOMIC_ZONE; }
1291 1292
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDanishExclusiveEconomicZone)) { return AREA_DANISH_EXCLUSIVE_ECONOMIC_ZONE; }
1293

  
1294
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAlboranSea)) { return 219; }
1295
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAlgeria)) { return 220; }
1296
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAngola)) { return 221; }
1297
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidAustralianExclusiveEconomicZone)) { return 222; }
1298
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBahamas)) { return 223; }
1299
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBalearicSea)) { return 224; }
1300
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelgium)) { return 225; }
1301
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBelize)) { return 226; }
1302
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBrazil)) { return 227; }
1303
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidBulgaria)) { return 228; }
1304
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCanada)) { return 229; }
1305
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCapeVerde)) { return 230; }
1306
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCapeVerdeanExclusiveEconomicZone)) { return 231; }
1307
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCaribbeanSea)) { return 210; }
1308
            else if (namedArea.getUuid().equals(ErmsTransformer.uuidChile)) { return 232; }
1309
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidColombia)) { return 233; }
1310
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCostaRica)) { return 234; }
1311
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCroatia)) { return 235; }
1312
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidCuba)) { return 236; }
1313
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidDenmark)) { return 292; }
1314
            else if (namedArea.getUuid().equals(ErmsTransformer.uuidEgypt)) { return 237; }
1315
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidEstonia)) { return 238; }
1316
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidFaeroeExclusiveEconomicZone)) { return 239; }
1317
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidFrance)) { return 240; }
1318
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGhana)) { return 241; }
1319
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGreece)) { return 242; }
1320
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGreekExclusiveEconomicZone)) { return AREA_GREEK_EXCLUSIVE_ECONOMIC_ZONE; }
1321
            else if (namedArea.getUuid().equals(ErmsTransformer.uuidGulfOfBothnia)) { return 243; }
1322
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGulfOfFinland)) { return 244; }
1323
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGulfOfGuinea)) { return 245; }
1324
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGulfOfMexico)) { return 246; }
1325
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidGulfOfRiga)) { return 247; }
1326
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIceland)) { return 248; }
1327
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIonianSea)) { return 249; }
1328
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidIreland)) { return 250; }
1329
            else if (namedArea.getUuid().equals(ErmsTransformer.uuidItaly)) { return 251; }
1330
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidJamaica)) { return 252; }
1331
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidKattegat)) { return 253; }
1332
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidLevantineSea)) { return 254; }
1333
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidLigurianSea)) { return 255; }
1334
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMalteseExclusiveEconomicZone)) { return 256; }
1335
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMauritanianExclusiveEconomicZone)) { return 257; }
1336
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea_EasternBasin)) { return 258; }
1337
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMediterraneanSea_WesternBasin)) { return 259; }
1338
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMexico)) { return 260; }
1339
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidMorocco)) { return 261; }
1340
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNetherlands)) { return 262; }
1341
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNewZealand)) { return 263; }
1342
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNewZealandExclusiveEconomicZone)) { return 264; }
1343
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorthAtlanticOcean)) { return 265; }
1344
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidNorway)) { return 266; }
1345
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPanama)) { return 267; }
1346
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPanamanianExclusiveEconomicZone)) { return 268; }
1347
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPolishExclusiveEconomicZone)) { return 216; }
1348
            else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugal)) { return 269; }
1349
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone_Azores)) { return 270; }
1350
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidPortugueseExclusiveEconomicZone_Madeira)) { return 271; }
1351
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidRedSea)) { return 272; }
1352
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidRussianExclusiveEconomicZone)) { return 217; }
1353
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSeaOfMarmara)) { return 273; }
1354
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSenegaleseExclusiveEconomicZone)) { return 274; }
1355
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSingapore)) { return 275; }
1356
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSlovenianExclusiveEconomicZone)) { return 276; }
1357
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthAfrica)) { return 277; }
1358
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthAfricanExclusiveEconomicZone)) { return 278; }
1359
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSouthChinaSea)) { return 279; }
1360
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpain)) { return 280; }
1361
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSpanishExclusiveEconomicZone_CanaryIslands)) { return 281; }
1362
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSriLankanExclusiveEconomicZone)) { return 282; }
1363
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidStraitOfGibraltar)) { return 283; }
1364
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidSweden)) { return 284; }
1365
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTunisia)) { return 285; }
1366
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTurkey)) { return 286; }
1367
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidTyrrhenianSea)) { return 287; }
1368
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedKingdom)) { return 288; }
1369
	        else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedStates)) { return 291; }
1370
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidUnitedStatesExclusiveEconomicZone_Alaska)) { return 289; }
1371
			else if (namedArea.getUuid().equals(ErmsTransformer.uuidVenezuela)) { return 290; }
1372

  
1292 1373
			else {
1293 1374
				logger.warn("Unknown NamedArea Area: " + area.getTitleCache());
1294 1375
			}

Also available in: Unified diff