INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEGRD','Greifswald','BH','Mibau Baustoffhandel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEGRD','Greifswald','LAD','Greifswald Ladebow / HLG')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEGRD','Greifswald','TL','Tanklager')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DELBM','Lubmin','LUB','Hafen Lubmin')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEMUK','Mukran','FHS','Fährhafen Sassnitz-Mukran')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEMUK','Mukran','EUB','Mukran EUROBALTIC')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','CAT','Rostock / Caterpillar Rostock')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','CHH','Rostock / Chemiehafen Rostock-Peez')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','MAB','Rostock / Rostock MAB')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','MGB','Rostock / Neptun Werft')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','MGS','Rostock / Maritimes Gewerbegebiet Süd')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','ÖLH','Rostock / Großtanklager Ölhafen Rostock')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','RFH','Rostock / Rostocker Fracht- und Fischereihafen GmbH')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','STH','Rostock / Stadthafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','ÜSH','Überseehafen Rostock')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','WMD','Rostock / Warnemünde Cruise Center')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DERSK','Rostock','WWW','Nordic Yards Warnemünde GmbH')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DESAS','Sassnitz','SHS','Sassnitz / Stadthafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DESTL','Stralsund','STH','Stralsund / Seehafen Stralsund')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEUCK','Ueckermünde','IH','Ueckermünde / Industriehafen Ueckermünde')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEVIW','Vierow','VIE','Vierow / Hafen Vierow GmbH')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWAR','Warnmeünde','WMD','Warnemünde / Kreufahrt-Terminal')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWAR','Warnmeünde','MGB','Maritimes Gewerbegebiet / Neptun Werft')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWAR','Warnmeünde','MGS','Maritimes Gewerbegebiet Süd')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWAR','Warnmeünde','WWW','Nordic Yards Warnemünde GmbH')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','AH','Alter Hafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','AU','Allgemeiner Umschlag')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','GT','Getreideterminal')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','HT','Holzterminal')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','KH','Kalihafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','MGT','Massengutterminal')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','MTW','NORDIC YARDS Wismar GmbH')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','NLP','Notliegeplätze')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','Ree','Reede')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','TT','Torfterminal')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','ÜSH','Überseehafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','PAX','Wismar Passagierkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWIS','Wismar','WH','Westhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('MV','DEWOL','Wolgast','STH','Wolgast / Wolgaster Hafengesellschaft')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHUS','Husum','NTHF','Nord Tonnenhof')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHUS','Husum','NLKN','Nord LKN')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHUS','Husum','NHGN','Nord HaGe')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHUS','Husum','HDRO','Süd HDR Dockvorhafen Ost')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHUS','Husum','HDRW','Süd HDR Dockvorhafen West')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHUS','Husum','SENV','Süd Senvion')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHUS','Husum','SATR','Süd ATR Landhandel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHUS','Husum','SLKN','Süd LKN')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHUS','Husum','HOSI','Holmer Siel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DETOE','Tönning','LHTO','Landeshafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DETOE','Tönning','ESPW','Liegeplätze Eidersperrwerk')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DETOE','Tönning','WSA','Liegeplätze Eiderkaje (WSA Tönning)')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','VHOM','Vorhafen Ostmole')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','HAZU','Hafenzufahrt')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','HB1','HB I')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','HB2N','HB II Nord')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','HB2W','HB II/III West')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','HB2S','HB II Süd')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','HB3N','HB III Nord')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','HB3O','HB III Ost')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','HB3S','HB III Süd Bulk/Passagiere')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','SILO','HB III Süd Stöven')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','HB3W','HB III/IV West')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBUM','Büsum','HB4N','HB IV Nord')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEGLU','Glückstadt','AHAS','Außenhafen Südmole (Glückstadt Ports)')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEGLU','Glückstadt','AHAN','Außenhafen Nordmole')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEWED','Wedel/Holstein','WKWK','Kraftwerkskai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHGL','Helgoland','HNOH','Nordosthafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHGL','Helgoland','HLA3','Landungsbrücke/Anlegerampe 3')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','EHOB','Elbehafen Ostbecken, BrbPorts')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','EHO','Elbehafen Ost, BrbPorts')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','EHC','Elbehafen Center, BrbPorts')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','EHW','Elbehafen West, BrbPorts')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OH4','Ölhafen, Brücke 4, WSA Brb')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OH5','Ölhafen, Brücke 5,  Raffinerie Heide')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OH6','Ölhafen, Brücke 6,  Raffinerie Heide')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OH7','Ölhafen, Brücke 7,  Raffinerie Heide')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OH8','Ölhafen,Brücke 8,  BrbPorts')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OM1','Ostermoor, Brücke 1, YARA')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OM2','Ostermoor, Brücke 2, YARA')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OM3','Ostermoor, Liegeplatz 3, YARA')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OM4','Ostermoor, Brücke 4,  YARA')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OM5','Ostermoor, Brücke 5,  BAYER')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','OM6','Ostermoor, Brücke 6, TOTAL')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','SKAI','NOK Binnenhafen Südkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','SASL','NOK Binnenhafen , SASOL')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','KUBI','NOK Binnenhafen , KüBI-Bunkeranlage')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','BAY','NOK Binnenhafen, Brücke 0102 (BAYER AG)')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','HOLC','NOK Binnenhafen , Zement Export Terminal (Fa. HOLCIM)')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBRB','Brunsbüttel','SUSI','NOK Binnenhafen (Schutz u. Sicherheitshafen)')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEREN','Rendsburg','WN','Werft Nobiskrug')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEREN','Rendsburg','KH','NOK, Kreishafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEREN','Rendsburg','ORP','Osterrönfeld NOK, Rendsburg Port')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEEEK','Eckernförde','KH','Kommunalhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEEEK','Eckernförde','IM','Innenhafen (Marine)')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKEL','Kiel','OUH','Ostuferhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKEL','Kiel','OSK','Ostseekai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKEL','Kiel','NWK','Norwegenkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKEL','Kiel','SWK','Schwedenkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKEL','Kiel','HDW','Werft HDW, ADMK')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKEL','Kiel','SH','Scheerhafen, Stallzus')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKEL','Kiel','GKK','Gemeinschaftskraftwerk GKK')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKEL','Kiel','CAT','Caterpillar Motoren')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKEL','Kiel','LP9B','Burmann KG, Schwentine')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKEL','Kiel','KSH','Kieler Schrotthandel, KSH')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DE136','Kiel Canal','LP32','NOK, Nordhafen Ölsaatenverarbeitungs GmbH, Liegepl. 32, 32a')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DE136','Kiel Canal','LP33','NOK, FA. Voith, Liegepl. 33')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DE136','Kiel Canal','B136','NOK, Bominflot Tanklager GmbH')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DE136','Kiel Canal','T136','NOK, Total Deutschland GmbH')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DETRV','Travemünde','SKAN','Scandinavienkai Lübeck-Travemünde')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DETRV','Travemünde','HILL','Bunkerstation Hillenberg Lübeck-Travemünde')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DETRV','Travemünde','TRAV','Travemünde Seebrücken Lübeck Travemünde')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','SCH1','Schlutup 1')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','OPK','Ostpreussenkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','VH','Nordlandkai-Neu')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','NG','Nordgetreide')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','SCH2','Schlutup 2')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','RK','Roddenloppel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','HV','Havemann')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','LGH','Lagerhaus Lübeck')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','LMG','LMG Maschinen- und Anlagenbau')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','CTL','Containerterminal Lehmann')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','BGT','Burgtorkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','BRÜ','Brüggen KG')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','HEN','Henningskai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','SLK','Seelandkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','LK','Lehmannkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','KK','Konstinkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELBC','Lübeck','HANS','Hansahafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEFLF','Flensburg','HK','Harniskai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEFLF','Flensburg','KWK','Kraftwerkskai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEFLF','Flensburg','SBK','Schiffbrückenkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEKAP','Kappeln','KAP','Kommunalhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHHF','Heiligenhafen','HHF','Kommunalhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEPUT','Puttgarden','SCFH','Fährhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DENHO','Neustadt/Holstein','KH','Kommunalhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEBSK','Burgstaaken/Fehmarn','BSK','Burgstaaken/Fehmarn')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEDAG','Dagebüll','DAG','Dagebüll')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHRM','Hörnum (Sylt)','HRM','Hörnum (Sylt)')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELIS','List (Sylt)','KH','Kommunalhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DELIS','List (Sylt)','FHRS','Fährhafen/Fähranleger  (Röm – Sylt Linie)')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEHTU','Holtenau','HTU','Holtenau')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEIAM','Amrum','IAM','Amrum')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEPEL','Pellworm','PEL','Pellworm')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DESLS','Schleswig','SLS','Schleswig')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEWEW','Wewelsfleth','WEW','Wewelsfleth')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('SH','DEWYK','Wyk auf Föhr','WYK','Wyk auf Föhr')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBMR','Baltrum','BMR','Baltrum')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBEN','Bensersiel','BEN','Bensersiel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBMK','Borkum','BMK','Borkum')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBKE','Brake','NDSK','Niedersachsenkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBKE','Brake','WILM','Wilmar Edible Oils Pier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBKE','Brake','NORP','Nordpier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBKE','Brake','SUEP','Südpier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBKE','Brake','BINN','Binnenhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBKE','Brake','KANA','Kanalhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBKE','Brake','STAK','Stadtkaje')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBUT','Butjadingen-Fedderwardersiel','BUT','Fedderwadersiel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','FAER','Fährhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','SEEB','Seebäderbrücke')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','ALTH','Alter Hafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','HAKA','Hafenkaje')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','HELG','Helgoländer Kai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','SLPR','Schleusenpriel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','STHF','Steubenhöft')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','LUEB','Lübbertkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','STHI','Steubenhöft Innenkante')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','ALTL','Alter Lentzkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','NEUL','Neuer Lentzkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','IMPE','Imperatorufer')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','CUXC','CuxCargo-Kai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','HUMB','Humberkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','EURO','Europakai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','OFFS','Offshorebasis')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','ALTF','Alter Fischereihafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','HERK','Heringskai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','NDSK','Niedersachsenkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DECUX','Cuxhaven','HANS','Hansakai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWAC','Dornum-Accumersiel / Westeraccumersiel','WAC','Dornum-Accumersiel / Westeraccumersiel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEELS','Elsfleth','STAP','Stadtpier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEELS','Elsfleth','OMNI','Omni Pac Pier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEELS','Elsfleth','WERF','Elsflether Werft')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','DEMS','Dalbenliegeplatz Emspier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','EMSP','Emspier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','EMSK','Emskai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','AUSW','Außenhafen-West')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','AUSO','Außenhafen-Ost')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','SUED','Südkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','JARS','Jarssumer Hafen Süd')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','JARN','Jarssumer Hafen Nord')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','NBID','Neuer Binnenhafen Dalben')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','NORD','Nordkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','BISB','Binnenschiffsbecken')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','EVA1','EVAG Terminal I')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','OLHS','Ölhafen Süd')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','OLHN','Ölhafen Nord')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','ISUD','Industriehafen Süd')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','BORS','Borssumer Hafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','INOR','Industriehafen Nord')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','STIK','Stichkanal')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','NSWK','Nordseewerke')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','EWUD','Emder Werft und Dock')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','EVA2','EVAG Terminal II')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','CASS','Cassens Werft')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','EFAW','Emder Fahrwasser')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','UTB','UTB')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEEME','Emden','STEG','Stege Westseite-Neuer Binnehafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEGRE','Greetsiel','GRE','Greetsiel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEHSX','Harlesiel','HSX','Harlesiel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEHOO','Hooksiel Außenhafen','NORD','Nordseite')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEHOO','Hooksiel Außenhafen','SUED','Südanleger')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEJUI','Juist','JUI','Juist')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DELGO','Langeoog','LGO','Langeoog')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DELEE','Leer','INDU','Industriehafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DELEE','Leer','HAND','Handelshafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DELEW','Lemwerder/Ochtum','OCHT','Ochtum Pier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DELEW','Lemwerder/Ochtum','AUR','Abeking und Rassmussen Werft')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEMOZ','Motzen','ROVA','Rova Pier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEMOZ','Motzen','FASS','Fassmer Werft')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENES','Nessmersiel','NES','Nessmersiel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENHS','Neuharlingersiel','NHS','Neuharlingersiel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENOE','Norddeich','NOE','Norddeich')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENHA','Nordenham','RMIN','Rhenus Midgard Pier Nordenham')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENHA','Nordenham','NSKW','Norddeutsche Seekabelwerke Pier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENHA','Nordenham','STUE','Stührenberg Pier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENHA','Nordenham','WESM','Wesermetall Pier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENHA','Nordenham','RMIB','Rhenus Midgard Pier Blexen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENHA','Nordenham','GRAU','Graue Pier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENHA','Nordenham','STEW','Steelwind Pier Blexen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENHA','Nordenham','KROT','Kronos Titan Pier Blexen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DENRD','Norderney','NRD','Norderney')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEOLO','Oldenburg','OSTH','Osthafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEOLO','Oldenburg','NORK','Nordkaje')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEOLO','Oldenburg','DALB','Kaje Dalbenstraße')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','DOBR','Deverhafen  Ostseite / Brügmann')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','DKBR','Deverhafen Kopf / Brügmann')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','DWSB','Deverhafen Westseite / S & B')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','SSSB','Sielkanal Südseite / S & B')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','SNBE','Sielkanal Nordseite / Bera')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','SNSV','Sielkanal Nordseite / Schiffsverwertung')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','SNAU','Sielkanal Nordseite / Augustin')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','SNBR','Sielkanal Nordseite / Brill')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','SNSB','Sielkanal Nordseite / S & B')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','ISSB','Industriehafen Süd Ostseite / S & B')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','ISBU','Industriehafen Süd  Ostseite / Bunte')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','ISHG','Industriehafen Süd Westseite / Hagemeier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','ISND','Industriehafen Süd Westseite / ND Coating')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','INSB','Industriehafen Nord  Ostseite / S & B')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','INRO','Industriehafen Nord  Ostseite / ROVA Mix')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','INBU','Industriehafen Nord  Ostseite /  Bunte')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEPAP','Papenburg','INNY','Industriehafen Nord Westseite / Nyblad')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DESPI','Spiekeroog','SPI','Spiekeroog')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBUZ','Stade-Bützfleth','NORD','Nordhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBUZ','Stade-Bützfleth','NWK','Nordwest-Kai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEBUZ','Stade-Bützfleth','SUED','Südhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEAGE','Wangerooge','AGE','Wangerooge')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','UVG1','UVG 1')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','UVG2','UVG 2')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','UVG3','UVG 3')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','WRG1','WRG 1')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','WR1A','WRG 1A')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','WRG2','WRG 2')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','WRG3','WRG 3')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','JWPP','JWP Projektpier')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','JWPC','JWP')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','NDSA','Niedersachsenbrücke außen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','NDSI','Niedersachsenbrücke innen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','NWO1','NWO 1')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','NWO2','NWO 2')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','NWO3','NWO 3')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','NWO4','NWO 4')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','FUPH','Flut- und Pontonhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','AVH','Alter Vorhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','BSK','Braunschweigkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','LGK','Lüneburgkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','HK','Hannoverkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','OLK','Oldenburgkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','DOC8','Dock 8')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','DALB','Dalbenplatz')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','3EIN','ehem. III. Einfahrt')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWVN','Wilhelmshaven/Land','JADI','Jade-Dienst Kai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWHV','Wilhelmshaven/Stadt','AUSR','Ausrüstungshafen Nord')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWHV','Wilhelmshaven/Stadt','NOK','Nordostkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWHV','Wilhelmshaven/Stadt','NWK','Nordwestkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWHV','Wilhelmshaven/Stadt','SWK','Südwestkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWHV','Wilhelmshaven/Stadt','BONT','Bontekai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWHV','Wilhelmshaven/Stadt','WIES','Wiesbadenbrücke')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWHV','Wilhelmshaven/Stadt','STBK','Strombaukaje')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWHV','Wilhelmshaven/Stadt','ALBA','Jade-Stahl-Kaje')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('NI','DEWHV','Wilhelmshaven/Stadt','GVKA','Güterverkehrsanlage')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','AIRB','Finkenwerder - Airbus')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','FKWP','Finkenwerder - Finkenwerder Pfähle')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','CELL','Köhlfleet – Rhenus Midgard')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','MITT','Köhlfleet – Mittal')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','TRI','Köhlfleet – Trimet')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','AUE','Köhlfleet - Aue 1')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','KOEH','Köhlfleet – Köhlfleethafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','CTB','Burchardkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','EUR','Eurogate')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','B+V','Blohm+Voss')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','CTT','Tollerort - CTT 1-5')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','CTA','Altenwerder - CTA 1-4')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','HAPO','Hansaport')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','HJM','Harburg - Hrb1 HJM')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','ISR','Harburg - Hrb1 ISR')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','RIN','Harburg - Hrb1 Rinck')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','MID','Harburg - Hrb2 Midgard')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','N+T','Harburg - Hrb3 N+T')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','HOLB','Harburg - Hrb4 Holborn')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','NYN','Harburg - Hrb4 Nynas')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','HOH','Harburg - Shell Hohe Schaarhafen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','VATT','Harburg - Vattenfall Moorburg')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','CAR','Harburg - Cargill')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','KRA','Harburg - Krages')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','VOP','Rethe - Vopak 1-5')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','KALI','Rethe - Kalikai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','OILT','Rethe - Oiltanking')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','KSHE','Rethe - Kattwyk Shell')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','BLG','Rethe - Kattwyk Harms (BLG)')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','H+R','Rethe - H&R Ölwerke Schindler')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','KRUS','Rethe - P.Kruse')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','GTH','südl. Reiherstieg - GTH')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','HALT','südl. Reiherstieg - Haltermann')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','WALL','südl. Reiherstieg - Wallmann')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','HAB','südl. Reiherstieg - Habema')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','HAG','südl. Reiherstieg - Hagel')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','NOW','Norderwerft')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','OSW','Hansahafen - Oswaldkai 1-8')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','HHPF','Hansahafen - Hansahafenpfähle')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','SWT','Südwest-Terminal')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','BHT','Oderhafen - BHT Schuppen 80/81')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','MÖN','Oderhafen - Schuppen 76/77')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','S84','Rosshafen - Schuppen 84')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','EMR','Rosshafen - EMR')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','MAN','Rosshafen - MAN')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','GREV','Kuhwerder Hafen - Grevenhofkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','AGR','Kuhwerder Hafen - Agrar Terminal')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','CTAL','Altona - CruiseTerminal Altona')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','ALTM','Altona - Altona Mittelkai')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','CTGR','Norderelbe -  Cruise Terminal Grasbrook')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','NEPF','Norderelbe - Norderelbpfähle')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','SAS','Norderelbe - Schümann')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','RSHE','Norderelbe - Shell Reiherstieg')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','CTS','Kaiser-Wilhelm-Hafen - CruiseTerminal Steinwerder')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HH','DEHAM','Hamburg','KWH','Kaiser-Wilhelm-Hafen Warteplätze')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HB','DEBRE','Bremen','BRE','Bremen')
INSERT INTO PortArea (Country, Locode, Port, Code, Name) VALUES ('HB','DEBRV','Bremerhaven','BRV','Bremerhaven')