-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: 2018_2019
-- ------------------------------------------------------
-- Server version	5.7.44-google-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `puertos`
--

DROP TABLE IF EXISTS `puertos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `puertos` (
  `pais` varchar(255) NOT NULL DEFAULT '',
  `ciudad` varchar(100) NOT NULL DEFAULT '',
  `puerto` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `puertos`
--

LOCK TABLES `puertos` WRITE;
/*!40000 ALTER TABLE `puertos` DISABLE KEYS */;
INSERT INTO `puertos` VALUES ('AU','AU','ADELAIDE'),('US','US','BOSTON'),('MEXICO','VERACRUZ','VERACRUZ'),('MEXICO','ALTAMIRA','ALTAMIRA'),('DK','','AALBORG'),('DK','','AARHUS'),('DK','','AARHUS'),('GB','','ABERDEEN'),('CI','','ABIDJAN'),('CI','','ABIDJAN'),('AE','','ABU DHABI'),('AE','','ABU DHABI'),('GH','','ACCRA'),('SA','','AD DAMMAM'),('ET','','ADDIS ABABA'),('AU','AU','ADELAIDE'),('AU','AU','ADELAIDE'),('YE','','ADEN'),('JP','','AINOURA'),('AE','','AJMAN'),('US','US','ALBANY'),('US','US','ALBUQUERQUE'),('ES','','ALCALA DE GUAD.'),('EG','','ALEXANDRIE'),('ES','ES','ALGECIRAS'),('DZ','','ALGER'),('ES','ES','ALICANTE'),('TR','','ALIGA'),('KZ','','ALMATY (ALMA ATA)'),('MX','','ALTAMIRA'),('NL','NL','AMSTERDAM'),('US','US','ANCHORAGE'),('IT','','ANCONA'),('MA','','ANFA-CASABLANCA'),('AI','','ANGUILLA'),('AG','','ANTIGUA'),('CL','','ANTOFAGASTA'),('BE','BE','ANTWERPEN'),('NG','','APAPA'),('JO','','AQABA'),('CA','CA','ARGENTIA'),('CL','','ARICA'),('RU','','ARKHANGELSK'),('AW','','ARUBA'),('PY','','ASUNCION'),('NZ','','AUCKLAND'),('NZ','','AUCKLAND'),('IT','','AUGUSTA'),('VE','','BACHAQUERO/MARACAIBO L'),('BH','','BAHRAIN'),('BH','','BAHRAIN'),('PA','','BALBOA'),('US','US','BALTIMORE'),('US','US','BALTIMORE'),('US','US','BALTIMORE-WASH.'),('IN','','BANGALORE'),('TH','','BANGKOK'),('TH','','BANGKOK'),('TH','','BANGKOK - BMT TERMINAL'),('GM','','BANJUL'),('ES','','BARCELONA'),('ES','','BARCELONA-EL PRAT'),('IT','','BARI'),('CO','','BARRANQUILLA'),('CH','CH','BASEL'),('GP','','BASSE TERRE'),('FR','FR','BASSENS'),('US','US','BATON ROUGE'),('CN','','BEIJING/PEKIN'),('LB','','BEIRUT'),('LB','','BEIRUT'),('DZ','','BEJAIA'),('BR','BR','BELEM'),('GB','','BELFAST'),('BZ','','BELIZE CITY'),('AU','','BELL BAY'),('LY','','BENGHAZI'),('DE','DE','BERLIN'),('BM','','BERMUDA'),('CH','','BERN'),('ES','ES','BILBAO'),('ES','','BILBAO-SONDIKA'),('US','','BIRMINGHAM'),('GW','','BISSAU'),('NZ','','BLUFF PORT'),('GB','','BLYTH'),('DO','','BOCA CHICA'),('CO','','BOGOTA'),('US','US','BOISE'),('IT','','BOLOGNA'),('IN','','BOMBAY'),('AN','','BONAIRE'),('FR','FR','BORDEAUX'),('FR','','BORDEAUX'),('FR','FR','BORDEAUX'),('US','US','BOSTON'),('US','US','BOSTON'),('GB','','BOSTON GB'),('FR','FR','BOULOGE-SUR-MER'),('BR','','BRASILIA'),('DE','DE','BREMEN'),('DE','DE','BREMERHAVEN'),('DE','DE','BREMERHAVEN'),('FR','FR','BREST'),('BB','','BRIDGETOWN'),('BB','','BRIDGETOWN'),('AU','AU','BRISBANE'),('AU','AU','BRISBANE'),('GB','','BRISTOL'),('BE','','BRUSSELS'),('CO','','BUENAVENTURA'),('AR','','BUENOS AIRES'),('US','US','BUFFALO'),('BG','','BURGAS'),('US','US','BURLINGTON'),('AU','','BURNIE'),('KR','','BUSAN'),('PY','','CAACUPE'),('ES','ES','CADIZ'),('FR','FR','CAEN'),('IT','','CAGLIARI'),('GB','','CAIRNRYAN'),('EG','','CAIRO'),('FR','FR','CALAIS'),('IN','','CALCUTTA'),('CA','CA','CALGARY'),('PE','','CALLAO'),('FR','','CANNES'),('ZA','','CAPE TOWN'),('ZA','','CAPE TOWN'),('VE','','CARACAS'),('GB','','CARDIFF'),('ES','','CARTAGENA'),('CO','','CARTAGENE'),('MA','','CASABLANCA'),('IT','','CASTELLAMARE'),('LC','','CASTRIES (ST L.)'),('IT','','CATANIA'),('GF','','CAYENNE'),('GF','','CAYENNE'),('PH','','CEBU'),('ES','','CEUTA'),('US','US','CHARLESTON'),('US','US','CHARLESTON'),('US','US','CHARLOTTE'),('GB','','CHATAM'),('FR','FR','CHERBOURG'),('US','US','CHESTER'),('US','US','CHICAGO'),('US','US','CHICAGO'),('BD','','CHITTAGONG'),('NZ','','CHRISTCHURCH'),('NZ','','CHRISTCHURCH'),('US','US','CINCINATTI'),('US','US','CLEVELAND'),('US','US','CLEVELAND'),('GB','','COATBRIDGE'),('LK','','COLOMBO'),('LK','','COLOMBO KATMALANA'),('LK','','COLOMBO KATUNAYAKE'),('PA','','COLON'),('US','US','COLUMBUS'),('GN','','CONAKRY'),('GN','','CONAKRY'),('RO','','CONSTANTA'),('DK','','COPENHAGEN'),('DK','','COPENHAGEN'),('BJ','','COTONOU'),('BJ','','COTONOU'),('PA','','CRISTOBAL'),('AN','','CURACAO'),('DE','DE','CUXHAVEN'),('IN','','DABOLIM GOA'),('SN','','DAKAR'),('SN','','DAKAR'),('CN','CN','DALIAN'),('US','US','DALLAS'),('US','US','DALLAS/FT. WORTH'),('SY','','DAMASCUS'),('EG','','DAMIETTA'),('TZ','','DAR ES SALAAM'),('US','US','DAYTON'),('GF','','DEGRAD DES CANNES'),('IN','','DELHI'),('ID','','DENPASAR'),('US','US','DENVER'),('US','US','DETROIT'),('US','US','DETROIT'),('US','US','DETROIT'),('AU','','DEVONPORT'),('DJ','','DJIBOUTI'),('QA','','DOHA'),('QA','','DOHA'),('CM','','DOULA'),('GB','','DOVER'),('AE','','DUBAI'),('AE','','DUBAI'),('AE','','DUBAI'),('US','','DULLES (WASHINGTON)'),('US','','DULLES (WASHINGTON)'),('US','US','DULLES (WASHINGTON)'),('FR','FR','DUNKERQUE'),('ZA','','DURBAN'),('CA','CA','EDMONTON'),('VE','','EL GUAMACHE'),('US','US','ELIZABETH'),('GB','','ELLESMERE PORT'),('MX','MX','ENSENADA'),('DK','','ESBJERG'),('GB','GB','FELIXSTOWE'),('GB','GB','FELIXSTOWE'),('US','US','FERNANDINA BEACH'),('IT','','FIRENZE'),('NO','','FLORO'),('GB','','FOLKSTONE'),('MQ','','FORT DE FRANCE'),('MQ','','FORT DE FRANCE'),('US','','FORT LAUERDAALE'),('BR','BR','FORTALEZA'),('FR','FR','FOS-SUR-MER'),('CN','','FOZHOU'),('DE','DE','FRANKFURT'),('DE','','FRANKFURT'),('DK','','FREDERICIA'),('CA','CA','FREDERICTON'),('CA','CA','FREDERICTON'),('DK','','FREDERISKHAVN'),('BS','','FREEPORT'),('SL','','FREETOWN'),('AU','AU','FREMANTLE'),('AE','','FUJAIRAH'),('JP','JP','FUKUOKA'),('PT','','FUNCHAL'),('CN','','FUZHOU'),('BW','','GABARONE'),('US','US','GALVESTON'),('SE','','GAVLE'),('PL','','GDANSK'),('PL','','GDYNIA'),('CH','','GENEVA'),('IT','','GENOA'),('IT','IT','GENOA'),('GY','','GEORGETOWN'),('KY','','GEORGETOWN'),('BE','','GHENT'),('GI','','GIBRALTAR'),('IT','','GIOIA TAURO'),('GB','','GLASGOW'),('GB','','GLASGOW'),('US','US','GLOUCESTER CITY'),('IN','','GOA IN DABOLIM'),('GB','','GOOLE'),('SE','','GOTHENBURG'),('KY','','GRAND CAYMAN'),('US','US','GRAND RAPIDS'),('GB','','GRANGEMOUTH'),('GB','','GREENOCK'),('GD','','GRENADA'),('GD','','GRENADA'),('MX','','GUADELAJARA'),('GU','','GUAM'),('TD','','GUAM'),('CN','','GUANGZHOU'),('CN','','GUANGZHOU'),('VE','','GUANTA'),('BR','BR','GUARULHOS'),('GT','','GUATEMALA CITY'),('GT','','GUATEMALA CITY'),('EC','','GUAYAQUIL'),('US','US','GULFPORT'),('EC','','GUYAQUIL'),('VN','','HAIPHONG'),('JP','','HAKATA'),('CA','CA','HALIFAX'),('CA','CA','HALIFAX'),('DE','DE','HAMBURG'),('DE','DE','HAMBURG'),('BM','','HAMILTON'),('FI','','HAMINA'),('VN','','HANOI'),('ZW','','HARARE'),('GB','','HARLOW'),('US','US','HARTFORD'),('GB','','HARWICH'),('SE','SE','HELSINGBORG'),('FI','','HELSINKI'),('FI','','HELSINKI'),('GB','','HERSHAM'),('GB','','HEYSHAM'),('DK','','HIRTSHALS'),('VN','','HO CHI MINH'),('VN','','HO CHI MINH CITY'),('AU','','HOBART'),('YE','','HODEIDAH'),('GB','','HOLYHEAD'),('HK','','HONG KONG'),('HK','','HONG KONG'),('SB','','HONIARA'),('US','US','HONOLULU'),('US','US','HONOLULU/OAHU'),('US','US','HOUSTON'),('US','US','HOUSTON HOBBY'),('US','US','HOUSTON INTERCONT'),('GB','','HULL'),('UA','','ILYICHEVSK'),('GB','','IMMINGHAM'),('KR','','INCHEON HLPT'),('KR','','INCHEUN'),('US','','INDIANAPOLIS'),('GB','','IPSWICH'),('CL','','IQUIQUE'),('VE','','ISLA MARGARITA'),('TR','','ISTANBUL'),('TR','','ISTANBUL'),('BR','BR','ITAJAI'),('TR','','IZMIR'),('US','US','JACKSONVILLE'),('US','','JACKSONVILLE'),('ID','','JAKARTA'),('IN','','JAWAHARLAL NEWRU'),('AE','','JEBEL ALI'),('SA','','JEDDAH'),('ZA','','JOHANNESBURG'),('RU','','KALININGRAD'),('JP','JP','KANAZAWA'),('JP','','KANSAI INTL'),('US','US','KANSAS CITY'),('TW','','KAOHSIUNG'),('TW','','KAOHSIUNG'),('PK','','KARACHI'),('DK','','KASTRUP'),('DK','','KASTRUP'),('NP','','KATHMANADU'),('TW','','KEELUNG'),('AE','','KHOR AL FAKKAN'),('DE','DE','KIEL'),('JM','','KINGSTON'),('JM','','KINGSTON MANLEY'),('VC','','KINGSTOWN'),('MD','','KISHINEV'),('LT','','KLAIPEDA'),('JP','','KOBE'),('JP','','KOBE'),('SI','','KOPER'),('SK','','KOSICE-LETISKO'),('MY','','KOTA KINABALU'),('FI','','KOTKA'),('MY','','KUALA LUMPUR'),('KW','','KUWAIT'),('KR','','KWANGYANG'),('HN','','LA CEIBA'),('VE','','LA GUAIRA'),('CU','','LA HABANA'),('FR','FR','LA PALLICE'),('FR','FR','LA ROCHELLE'),('IT','IT','LA SPEZIA'),('IT','IT','LA SPEZIA'),('MY','','LABUAN'),('TH','','LAEM CHABANG'),('NG','','LAGOS'),('US','US','LAKE CHARLES'),('MY','','LANGKAWI'),('CY','','LARNACA'),('CY','','LARNACA'),('GB','','LARNE'),('ES','','LAS PALMAS'),('US','','LAS VEGAS'),('SY','','LATAKIA'),('FJ','','LAUTOKA'),('FR','','LE CAIRE'),('FR','FR','LE HAVRE'),('FR','FR','LE HAVRE'),('FR','FR','LE-VERDON'),('GB','','LEITH'),('PT','','LEIXOES'),('CN','','LIANYUNGANG'),('GA','','LIBREVILLE'),('BE','','LIEGE'),('FR','','LILLE / LESQUIN'),('PE','','LIMA'),('CY','','LIMASSOL'),('CL','','LIRQUEN'),('PT','','LISBOA'),('PT','','LISBOA'),('GB','GB','LIVERPOOL'),('GB','','LIVERPOOL'),('IT','IT','LIVORNO'),('IT','IT','LIVORNO'),('TG','','LOME'),('GB','','LONDON'),('GB','','LONDON'),('GB','','LONDON GATWICK'),('GB','','LONDON HEATHROW'),('US','US','LONG BEACH'),('US','US','LONG BEACH'),('US','US','LOS ANGELES'),('US','US','LOS ANGELES'),('US','US','LOUISVILLE'),('DE','','LUBECK'),('LU','','LUXEMBOURG'),('FR','FR','LYON SATOLAS'),('SE','','LYSEKIL'),('NZ','','LYTTELTON'),('MO','','MACAU'),('MO','','MACAU'),('ES','','MADRID-BARAJAS'),('SC','','MAHE IS. INTL'),('MV','','MALE'),('MV','','MALE'),('SE','','MALMO'),('MT','','MALTA (VALETTA)'),('MT','','MALTA (VALETTA)'),('NI','','MANAGUA'),('US','US','MANATEE'),('BR','BR','MANAUS'),('GB','','MANCHESTER'),('GB','','MANCHESTER'),('RO','','MANGALIA'),('PH','','MANILA'),('PH','','MANILA'),('EC','','MANTA'),('MX','MX','MANZANILLO'),('PA','','MANZANILLO'),('MZ','','MAPUTO'),('IT','','MARGHERA'),('ES','','MARIN'),('IT','','MARINA DI CARRARA'),('MT','','MARSAXLOKK'),('FR','FR','MARSEILLE'),('FR','FR','MARSEILLE'),('IT','','MASSA'),('ER','','MASSAWA'),('ZR','','MATADI'),('MU','','MAURITIUS'),('MU','','MAURITIUS'),('SC','','MAWE'),('CO','','MEDELLIN'),('AU','AU','MELBOURNE'),('AU','AU','MELBOURNE'),('ES','','MELILLA'),('US','US','MEMPHIS'),('AR','','MENDOZA'),('TR','','MERSIN'),('MX','','MEXICO'),('US','US','MIAMI'),('US','US','MIAMI'),('GB','','MIDDLESBOROUGH'),('IT','','MILANO'),('IT','','MILANO-MALPENZA'),('US','US','MILWAUKEE'),('OM','','MINA QABOOS'),('US','US','MINNEAPOLIS'),('CU','','MOA'),('JP','','MOJI'),('KE','','MOMBASA'),('CA','CA','MONCTON'),('IT','','MONFALCONE'),('LR','','MONROVIA'),('JM','','MONTEGO BAY'),('UY','','MONTEVIDEO'),('UY','','MONTEVIDEO'),('FR','FR','MONTOIR-BRETAGNE'),('CA','CA','MONTREAL'),('CA','CA','MONTREAL DORVAL'),('CA','','MONTREAL MIRABEL'),('RU','','MOSCOW'),('GB','','MOSSEND'),('FR','','MULHOUSE (BALE)'),('FR','','MULHOUSE (BALE)'),('IN','','MUMBAI'),('OM','','MUSCAT'),('OM','','MUSCAT'),('KR',' ABBAS','N'),('GB','','N. KILLINGHOLME'),('JP','','NAGOYA'),('JP','','NAGOYA'),('JP','JP','NAHA'),('KE','','NAIROBI'),('CN','','NANJING'),('NZ','','NAPIER'),('IT','','NAPOLI'),('IT','','NAPOLI'),('US','','NASHVILLE'),('US','US','NASHVILLE'),('BS','','NASSAU'),('BS','','NASSAU (BAHAMAS)'),('GB','','NEATH'),('NZ','','NELSON'),('US','US','NEW ORLEANS'),('CA','CA','NEW WESTMINSTER'),('US','US','NEW YORK - LA GUARDIA APT'),('US','US','NEW YORK JFK'),('US','US','NEWARK'),('US','US','NEWARK NJ'),('GB','','NEWCASTLE UPON TYNE'),('GB','','NEWPORT'),('CY','','NICOSIA'),('CN','','NINGBO'),('CN','CN','NINGBO'),('US','US','NORFOLK'),('SE','','NORRK?PING'),('MR','','NOUAKCHOTT'),('NC','','NOUMEA'),('NC','','NOUMEA'),('RU','','NOVOROSSIYSK'),('DK','','ODENSE'),('UA','','ODESSA'),('JP','','OKINAWA'),('JP','','OKINAWA'),('NG','','ONNE'),('BE','','OOSTENDE'),('DZ','','ORAN'),('AW','','ORANJESTAD'),('US','US','ORLANDO'),('JP','','OSAKA'),('JP','','OSAKA INTL'),('NO','','OSLO'),('NO','','OSLO'),('JP','','OTSU'),('CA','CA','OTTAWA'),('IT','','PALERMO'),('ES','','PALMA DE MALLORCA'),('PA','','PANAMA CITY'),('PA','','PANAMA CITY'),('PF','','PAPEETE'),('PF','','PAPEETE'),('SR','','PARAMARIBO'),('BR','','PARANAGUA'),('FR','','PARIS ORLY'),('FR','','PARIS ROISSY'),('MY','','PENANG'),('US','US','PENSACOLA'),('AU','','PERTH'),('AU','','PERTH'),('US','US','PHILADELPHIA'),('KH','','PHNOM PENH'),('VN','','PHNOM-PENH'),('US','','PHOENIX'),('GR','','PIRAEUS'),('US','US','PITTSBURGH'),('GP','','POINTE A PITRE'),('GP','','POINTE A PITRE'),('RE','','POINTE DES GALETS'),('PN','','POINTE NEGRE'),('CG','','POINTE NOIRE'),('PR','','PONCE'),('GB','','POOLE'),('AU','','PORT ADELAIDE'),('NZ','','PORT CHALMERS'),('ZA','','PORT ELIZABETH'),('NG','','PORT HARTCOUR'),('MY','','PORT KELANG'),('MU','','PORT LOUIS'),('TT','','PORT OF SPAIN'),('TT','','PORT OF SPAIN'),('AE','','PORT RASHID'),('EG','','PORT SAID'),('SD','','PORT SUDAN'),('OM','','PORT SULTAN QABOOS'),('FR','','PORT VENDRES'),('VU','','PORT VILA'),('HT','','PORT-AU-PRINCE'),('US','US','PORTLAND'),('PT','','PORTO'),('PT','','PORTO'),('BR','BR','PORTO ALEGRE'),('VE','','PORTO CABELLO'),('GB','','PORTSMOUTH'),('GB','','PORTSMOUTH GB'),('GE','','POTI'),('CZ','','PRAGUE'),('CZ','','PRAHA'),('CV','','PRAIA'),('MX','MX','PROGRESO'),('US','US','PROVIDENCE'),('TC','','PROVIDENCIALES'),('HN','','PUERTO CORTES'),('CR','','PUERTO LIMON'),('MX','','PUERTO MORELOS'),('DO','','PUERTO PLATA'),('GT','','PUERTO QUETZAL'),('HR','','PULA'),('CL','','PUNTA ARENAS'),('GB','','PURFLEET'),('KR','','PUSAN'),('KR','','PUSAN'),('KR','','PUSAN'),('CN','CN','QINGDAO'),('CN','','QUANZHOU'),('CA','','QUEBEC'),('TN','','RADES/TUNIS'),('US','US','RALEIGH/DURHAM INTL'),('GB','','RAMSGATE'),('IT','','RAVENNA'),('BR','BR','RECIFE'),('CA','','REGINA'),('US','US','RENO'),('IS','','REYKJAVIK'),('IS','','REYKJAVIK'),('GR','','RHODES'),('US','US','RICHMOND VA'),('US','US','RICHMOND VA'),('LV','','RIGA'),('LV','','RIGA'),('HR','','RIJEKA SUSAK'),('BR','BR','RIO DE JANEIRO'),('BR','BR','RIO DE JANEIRO'),('BR','BR','RIO GRANDE'),('DO','','RIO HAINA'),('SA','','RIYADH'),('IT','IT','ROMA'),('IT','','ROMA-CIAMPINO'),('IT','','ROMA-FIUMICINO'),('DM','','ROSEAU'),('DE','','ROSTOCK'),('GB','','ROSYTH'),('NL','NL','ROTTERDAM'),('FR','FR','ROUEN'),('IT','','ROVIGO'),('BR','','S. FRANCISCO DO S'),('US','US','SACRAMENTO'),('US','US','SACRAMENTO'),('MP','','SAIPAN'),('OM','','SALALAH'),('IT','','SALERNO'),('US','US','SALT LAKE CITY'),('BR','','SALVADOR'),('CO','','SAN ANDREAS ISLAND'),('CL','','SAN ANTONIO'),('US','US','SAN DIEGO'),('US','US','SAN DIEGO'),('US','US','SAN FRANCISCO'),('US','US','SAN FRANCISCO'),('US','','SAN JOSE'),('CR','','SAN JOSE'),('CR','','SAN JOSE'),('CR','','SAN JOSE'),('PR','','SAN JUAN'),('PR','','SAN JUAN'),('US','US','SAN PEDRO'),('HN','','SAN PEDRO DE SULA'),('SV','','SAN SALVADOR'),('CL','','SAN VICENTE'),('CN','','SANSHAN'),('CO','','SANTA MARTA'),('CL','','SANTIAGO'),('DO','','SANTO DOMINGO'),('DO','','SANTO DOMINGO'),('GT','','SANTO TOMAS DE CASTILLA'),('BR','','SANTOS'),('BR','BR','SAO PAULO'),('ST','','SAO TOME'),('CV','','SAO VICENTE'),('JP','','SAPPORO'),('JP','','SAPPORO'),('US','US','SAVANNAH'),('IT','','SAVONA'),('US','US','SEATTLE'),('US','US','SEATTLE'),('JP','','SENDAI'),('KR','','SEOUL'),('BR','BR','SEPETIBA'),('FR','FR','SETE'),('PT','','SETUBAL'),('ES','','SEVILLA'),('TN','','SFAX'),('CN','','SHANGHAI'),('CN','','SHANGHAI'),('CN','','SHANTOU'),('AE','','SHARJAH'),('AE','','SHARJAH'),('GB','','SHEERNESS'),('CN','','SHENYANG'),('JP','','SHIMIZU'),('US','US','SHREVEPORT'),('MY','','SIBU'),('KH','','SIHANOUKVILLE'),('SG','','SINGAPORE'),('SG','','SINGAPORE'),('FR','','SINT MAARTEN'),('SE','','SODERTALJE'),('GB','GB','SOUTHAMPTON'),('HR','','SPLIT'),('US','US','ST ALBAN'),('GP','','ST BARTHELEMY'),('FR','FR','ST DENIS'),('GR','','ST GEORGE'),('CA','CA','ST JOHN'),('CA','CA','ST JOHNS'),('KN','','ST KITTS'),('US','US','ST LOUIS'),('US','US','ST LOUIS'),('US','US','ST LOUIS'),('FR','','ST MALO'),('FR','FR','ST NAZAIRE'),('RU','','ST PETERSBURG'),('RU','','ST PETERSBURG'),('PM','','ST PIERRE'),('FR','','ST PIERRE ET MIQUELON'),('VG','','ST THOMAS'),('VI','','ST THOMAS'),('VC','','ST VINCENT'),('VC','','ST VINCENT'),('ES','ES','ST-CRUZ-TENERIFE'),('VI','','ST. CROIX ISLAND HAMILTON'),('RE','','ST. DENIS'),('LC','','ST. LUCIA'),('AN','','ST. MAARTEN'),('NO','','STAVANGER'),('SE','','STOCKHOLM'),('SE','','STOCKHOLM'),('BR','','SUAPE'),('PH','','SUBIC BAY'),('SE','','SUNDSVALL'),('FJ','','SUVA'),('AU','AU','SYDNEY'),('AU','AU','SYDNEY'),('PL','','SZCZECIN'),('US','US','TACOMA'),('TW','','TAIPEI'),('EE','','TALLINN'),('US','US','TAMPA'),('US','US','TAMPA'),('MX','MX','TAMPICO'),('MA','','TANGER'),('MY','','TANJUNG PELEPAS'),('IT','','TARANTO'),('NZ','','TAURANGA'),('GB','','TEESPORT'),('HN','','TEGUCIGALPA'),('IL','','TEL AVIV'),('GH','','TEMA'),('ES','','TENERIFE'),('GB','','THAMES PORT'),('GR','','THESSALONIKI'),('FO','','THORSHAVN'),('CN','','TIANJIN'),('CN','CN','TIANJIN'),('CN','','TIANJINXINGANG'),('GB','','TILBURY'),('JP','','TOKYO'),('JP','','TOKYO NARITA'),('JP','','TOKYO NARITA'),('US','US','TOLEDO'),('JP','','TOMAKOMAI'),('IT','','TORINO'),('CA','CA','TORONTO'),('CA','CA','TORONTO'),('VG','','TORTOLA'),('VG','','TORTOLA'),('FR','FR','TOULON'),('IT','','TRAPANI'),('DE','','TRAVEMUNDE'),('SE','','TRELLEBORG'),('IT','','TRIESTE'),('IT','','TRIESTE'),('LY','','TRIPOLI'),('NO','','TRONDHEIM'),('GB','','TROON'),('TN','','TUNIS'),('TN','','TUNIS'),('FI','','TURKU'),('MN','','ULAANBAATAR'),('NO','','ULSTEINVIK'),('AE','','UMM AL QAIWAIN'),('IT','','VADO LIGURE'),('ES','ES','VALENCIA'),('CL','','VALPARAISO'),('CA','CA','VANCOUVER'),('CA','CA','VANCOUVER'),('BG','','VARNA'),('IT','','VENEZIA'),('IT','','VENEZIA'),('MX','MX','VERACRUZ'),('IT','','VIAREGGIO'),('LC','','VIEUX FORT'),('ES','ES','VIGO'),('LT','','VILNIUS'),('BR','BR','VITORIA'),('NL','','VLISSINGEN'),('SE','SE','WALLHAMN'),('NA','','WALVIS BAY'),('PL','','WARSZAWA'),('US','US','WASHINGTON'),('NZ','','WELLINGTON'),('NZ','','WELLINGTON'),('CN','CN','WENZHOU'),('CA','CA','WHITBY'),('AT','','WIEN'),('US','US','WILMINGTON'),('US','US','WILMINGTON CA'),('CA','CA','WINNIPEG'),('CA','','WINNIPEG'),('CN','CN','XIAMEN'),('CN','','XINFENG'),('CN','','XINGANG'),('MM','','YANGON'),('CN','CN','YANTAI'),('CN','','YANTIAN'),('JP','','YOKOHAMA'),('HR','','ZAGREB'),('BE','BE','ZEEBRUGGE'),('CN','','ZHENGZHOU'),('CN','CN','ZHUHAI'),('CH','CH','ZURICH'),('CH','','ZURICH'),('DK','','AALBORG'),('DK','','AARHUS'),('DK','','AARHUS'),('GB','','ABERDEEN'),('CI','','ABIDJAN'),('CI','','ABIDJAN'),('AE','','ABU DHABI'),('AE','','ABU DHABI'),('GH','','ACCRA'),('SA','','AD DAMMAM'),('ET','','ADDIS ABABA'),('AU','AU','ADELAIDE'),('AU','AU','ADELAIDE'),('YE','','ADEN'),('JP','','AINOURA'),('AE','','AJMAN'),('US','US','ALBANY'),('US','US','ALBUQUERQUE'),('ES','','ALCALA DE GUAD.'),('EG','','ALEXANDRIE'),('ES','ES','ALGECIRAS'),('DZ','','ALGER'),('ES','ES','ALICANTE'),('TR','','ALIGA'),('KZ','','ALMATY (ALMA ATA)'),('MX','','ALTAMIRA'),('NL','NL','AMSTERDAM'),('US','US','ANCHORAGE'),('IT','','ANCONA'),('MA','','ANFA-CASABLANCA'),('AI','','ANGUILLA'),('AG','','ANTIGUA'),('CL','','ANTOFAGASTA'),('BE','BE','ANTWERPEN'),('NG','','APAPA'),('JO','','AQABA'),('CA','CA','ARGENTIA'),('CL','','ARICA'),('RU','','ARKHANGELSK'),('AW','','ARUBA'),('PY','','ASUNCION'),('NZ','','AUCKLAND'),('NZ','','AUCKLAND'),('IT','','AUGUSTA'),('VE','','BACHAQUERO/MARACAIBO L'),('BH','','BAHRAIN'),('BH','','BAHRAIN'),('PA','','BALBOA'),('US','US','BALTIMORE'),('US','US','BALTIMORE'),('US','US','BALTIMORE-WASH.'),('IN','','BANGALORE'),('TH','','BANGKOK'),('TH','','BANGKOK'),('TH','','BANGKOK - BMT TERMINAL'),('GM','','BANJUL'),('ES','','BARCELONA'),('ES','','BARCELONA-EL PRAT'),('IT','','BARI'),('CO','','BARRANQUILLA'),('CH','CH','BASEL'),('GP','','BASSE TERRE'),('FR','FR','BASSENS'),('US','US','BATON ROUGE'),('CN','','BEIJING/PEKIN'),('LB','','BEIRUT'),('LB','','BEIRUT'),('DZ','','BEJAIA'),('BR','BR','BELEM'),('GB','','BELFAST'),('BZ','','BELIZE CITY'),('AU','','BELL BAY'),('LY','','BENGHAZI'),('DE','DE','BERLIN'),('BM','','BERMUDA'),('CH','','BERN'),('ES','ES','BILBAO'),('ES','','BILBAO-SONDIKA'),('US','','BIRMINGHAM'),('GW','','BISSAU'),('NZ','','BLUFF PORT'),('GB','','BLYTH'),('DO','','BOCA CHICA'),('CO','','BOGOTA'),('US','US','BOISE'),('IT','','BOLOGNA'),('IN','','BOMBAY'),('AN','','BONAIRE'),('FR','FR','BORDEAUX'),('FR','','BORDEAUX'),('FR','FR','BORDEAUX'),('US','US','BOSTON'),('US','US','BOSTON'),('GB','','BOSTON GB'),('FR','FR','BOULOGE-SUR-MER'),('BR','','BRASILIA'),('DE','DE','BREMEN'),('DE','DE','BREMERHAVEN'),('DE','DE','BREMERHAVEN'),('FR','FR','BREST'),('BB','','BRIDGETOWN'),('BB','','BRIDGETOWN'),('AU','AU','BRISBANE'),('AU','AU','BRISBANE'),('GB','','BRISTOL'),('BE','','BRUSSELS'),('CO','','BUENAVENTURA'),('AR','','BUENOS AIRES'),('US','US','BUFFALO'),('BG','','BURGAS'),('US','US','BURLINGTON'),('AU','','BURNIE'),('KR','','BUSAN'),('PY','','CAACUPE'),('ES','ES','CADIZ'),('FR','FR','CAEN'),('IT','','CAGLIARI'),('GB','','CAIRNRYAN'),('EG','','CAIRO'),('FR','FR','CALAIS'),('IN','','CALCUTTA'),('CA','CA','CALGARY'),('PE','','CALLAO'),('FR','','CANNES'),('ZA','','CAPE TOWN'),('ZA','','CAPE TOWN'),('VE','','CARACAS'),('GB','','CARDIFF'),('ES','','CARTAGENA'),('CO','','CARTAGENE'),('MA','','CASABLANCA'),('IT','','CASTELLAMARE'),('LC','','CASTRIES (ST L.)'),('IT','','CATANIA'),('GF','','CAYENNE'),('GF','','CAYENNE'),('PH','','CEBU'),('ES','','CEUTA'),('US','US','CHARLESTON'),('US','US','CHARLESTON'),('US','US','CHARLOTTE'),('GB','','CHATAM'),('FR','FR','CHERBOURG'),('US','US','CHESTER'),('US','US','CHICAGO'),('US','US','CHICAGO'),('BD','','CHITTAGONG'),('NZ','','CHRISTCHURCH'),('NZ','','CHRISTCHURCH'),('US','US','CINCINATTI'),('US','US','CLEVELAND'),('US','US','CLEVELAND'),('GB','','COATBRIDGE'),('LK','','COLOMBO'),('LK','','COLOMBO KATMALANA'),('LK','','COLOMBO KATUNAYAKE'),('PA','','COLON'),('US','US','COLUMBUS'),('GN','','CONAKRY'),('GN','','CONAKRY'),('RO','','CONSTANTA'),('DK','','COPENHAGEN'),('DK','','COPENHAGEN'),('BJ','','COTONOU'),('BJ','','COTONOU'),('PA','','CRISTOBAL'),('AN','','CURACAO'),('DE','DE','CUXHAVEN'),('IN','','DABOLIM GOA'),('SN','','DAKAR'),('SN','','DAKAR'),('CN','CN','DALIAN'),('US','US','DALLAS'),('US','US','DALLAS/FT. WORTH'),('SY','','DAMASCUS'),('EG','','DAMIETTA'),('TZ','','DAR ES SALAAM'),('US','US','DAYTON'),('GF','','DEGRAD DES CANNES'),('IN','','DELHI'),('ID','','DENPASAR'),('US','US','DENVER'),('US','US','DETROIT'),('US','US','DETROIT'),('US','US','DETROIT'),('AU','','DEVONPORT'),('DJ','','DJIBOUTI'),('QA','','DOHA'),('QA','','DOHA'),('CM','','DOULA'),('GB','','DOVER'),('AE','','DUBAI'),('AE','','DUBAI'),('AE','','DUBAI'),('US','','DULLES (WASHINGTON)'),('US','','DULLES (WASHINGTON)'),('US','US','DULLES (WASHINGTON)'),('FR','FR','DUNKERQUE'),('ZA','','DURBAN'),('CA','CA','EDMONTON'),('VE','','EL GUAMACHE'),('US','US','ELIZABETH'),('GB','','ELLESMERE PORT'),('MX','MX','ENSENADA'),('DK','','ESBJERG'),('GB','GB','FELIXSTOWE'),('GB','GB','FELIXSTOWE'),('US','US','FERNANDINA BEACH'),('IT','','FIRENZE'),('NO','','FLORO'),('GB','','FOLKSTONE'),('MQ','','FORT DE FRANCE'),('MQ','','FORT DE FRANCE'),('US','','FORT LAUERDAALE'),('BR','BR','FORTALEZA'),('FR','FR','FOS-SUR-MER'),('CN','','FOZHOU'),('DE','DE','FRANKFURT'),('DE','','FRANKFURT'),('DK','','FREDERICIA'),('CA','CA','FREDERICTON'),('CA','CA','FREDERICTON'),('DK','','FREDERISKHAVN'),('BS','','FREEPORT'),('SL','','FREETOWN'),('AU','AU','FREMANTLE'),('AE','','FUJAIRAH'),('JP','JP','FUKUOKA'),('PT','','FUNCHAL'),('CN','','FUZHOU'),('BW','','GABARONE'),('US','US','GALVESTON'),('SE','','GAVLE'),('PL','','GDANSK'),('PL','','GDYNIA'),('CH','','GENEVA'),('IT','','GENOA'),('IT','IT','GENOA'),('GY','','GEORGETOWN'),('KY','','GEORGETOWN'),('BE','','GHENT'),('GI','','GIBRALTAR'),('IT','','GIOIA TAURO'),('GB','','GLASGOW'),('GB','','GLASGOW'),('US','US','GLOUCESTER CITY'),('IN','','GOA IN DABOLIM'),('GB','','GOOLE'),('SE','','GOTHENBURG'),('KY','','GRAND CAYMAN'),('US','US','GRAND RAPIDS'),('GB','','GRANGEMOUTH'),('GB','','GREENOCK'),('GD','','GRENADA'),('GD','','GRENADA'),('MX','','GUADELAJARA'),('GU','','GUAM'),('TD','','GUAM'),('CN','','GUANGZHOU'),('CN','','GUANGZHOU'),('VE','','GUANTA'),('BR','BR','GUARULHOS'),('GT','','GUATEMALA CITY'),('GT','','GUATEMALA CITY'),('EC','','GUAYAQUIL'),('US','US','GULFPORT'),('EC','','GUYAQUIL'),('VN','','HAIPHONG'),('JP','','HAKATA'),('CA','CA','HALIFAX'),('CA','CA','HALIFAX'),('DE','DE','HAMBURG'),('DE','DE','HAMBURG'),('BM','','HAMILTON'),('FI','','HAMINA'),('VN','','HANOI'),('ZW','','HARARE'),('GB','','HARLOW'),('US','US','HARTFORD'),('GB','','HARWICH'),('SE','SE','HELSINGBORG'),('FI','','HELSINKI'),('FI','','HELSINKI'),('GB','','HERSHAM'),('GB','','HEYSHAM'),('DK','','HIRTSHALS'),('VN','','HO CHI MINH'),('VN','','HO CHI MINH CITY'),('AU','','HOBART'),('YE','','HODEIDAH'),('GB','','HOLYHEAD'),('HK','','HONG KONG'),('HK','','HONG KONG'),('SB','','HONIARA'),('US','US','HONOLULU'),('US','US','HONOLULU/OAHU'),('US','US','HOUSTON'),('US','US','HOUSTON HOBBY'),('US','US','HOUSTON INTERCONT'),('GB','','HULL'),('UA','','ILYICHEVSK'),('GB','','IMMINGHAM'),('KR','','INCHEON HLPT'),('KR','','INCHEUN'),('US','','INDIANAPOLIS'),('GB','','IPSWICH'),('CL','','IQUIQUE'),('VE','','ISLA MARGARITA'),('TR','','ISTANBUL'),('TR','','ISTANBUL'),('BR','BR','ITAJAI'),('TR','','IZMIR'),('US','US','JACKSONVILLE'),('US','','JACKSONVILLE'),('ID','','JAKARTA'),('IN','','JAWAHARLAL NEWRU'),('AE','','JEBEL ALI'),('SA','','JEDDAH'),('ZA','','JOHANNESBURG'),('RU','','KALININGRAD'),('JP','JP','KANAZAWA'),('JP','','KANSAI INTL'),('US','US','KANSAS CITY'),('TW','','KAOHSIUNG'),('TW','','KAOHSIUNG'),('PK','','KARACHI'),('DK','','KASTRUP'),('DK','','KASTRUP'),('NP','','KATHMANADU'),('TW','','KEELUNG'),('AE','','KHOR AL FAKKAN'),('DE','DE','KIEL'),('JM','','KINGSTON'),('JM','','KINGSTON MANLEY'),('VC','','KINGSTOWN'),('MD','','KISHINEV'),('LT','','KLAIPEDA'),('JP','','KOBE'),('JP','','KOBE'),('SI','','KOPER'),('SK','','KOSICE-LETISKO'),('MY','','KOTA KINABALU'),('FI','','KOTKA'),('MY','','KUALA LUMPUR'),('KW','','KUWAIT'),('KR','','KWANGYANG'),('HN','','LA CEIBA'),('VE','','LA GUAIRA'),('CU','','LA HABANA'),('FR','FR','LA PALLICE'),('FR','FR','LA ROCHELLE'),('IT','IT','LA SPEZIA'),('IT','IT','LA SPEZIA'),('MY','','LABUAN'),('TH','','LAEM CHABANG'),('NG','','LAGOS'),('US','US','LAKE CHARLES'),('MY','','LANGKAWI'),('CY','','LARNACA'),('CY','','LARNACA'),('GB','','LARNE'),('ES','','LAS PALMAS'),('US','','LAS VEGAS'),('SY','','LATAKIA'),('FJ','','LAUTOKA'),('FR','','LE CAIRE'),('FR','FR','LE HAVRE'),('FR','FR','LE HAVRE'),('FR','FR','LE-VERDON'),('GB','','LEITH'),('PT','','LEIXOES'),('CN','','LIANYUNGANG'),('GA','','LIBREVILLE'),('BE','','LIEGE'),('FR','','LILLE / LESQUIN'),('PE','','LIMA'),('CY','','LIMASSOL'),('CL','','LIRQUEN'),('PT','','LISBOA'),('PT','','LISBOA'),('GB','GB','LIVERPOOL'),('GB','','LIVERPOOL'),('IT','IT','LIVORNO'),('IT','IT','LIVORNO'),('TG','','LOME'),('GB','','LONDON'),('GB','','LONDON'),('GB','','LONDON GATWICK'),('GB','','LONDON HEATHROW'),('US','US','LONG BEACH'),('US','US','LONG BEACH'),('US','US','LOS ANGELES'),('US','US','LOS ANGELES'),('US','US','LOUISVILLE'),('DE','','LUBECK'),('LU','','LUXEMBOURG'),('FR','FR','LYON SATOLAS'),('SE','','LYSEKIL'),('NZ','','LYTTELTON'),('MO','','MACAU'),('MO','','MACAU'),('ES','','MADRID-BARAJAS'),('SC','','MAHE IS. INTL'),('MV','','MALE'),('MV','','MALE'),('SE','','MALMO'),('MT','','MALTA (VALETTA)'),('MT','','MALTA (VALETTA)'),('NI','','MANAGUA'),('US','US','MANATEE'),('BR','BR','MANAUS'),('GB','','MANCHESTER'),('GB','','MANCHESTER'),('RO','','MANGALIA'),('PH','','MANILA'),('PH','','MANILA'),('EC','','MANTA'),('MX','MX','MANZANILLO'),('PA','','MANZANILLO'),('MZ','','MAPUTO'),('IT','','MARGHERA'),('ES','','MARIN'),('IT','','MARINA DI CARRARA'),('MT','','MARSAXLOKK'),('FR','FR','MARSEILLE'),('FR','FR','MARSEILLE'),('IT','','MASSA'),('ER','','MASSAWA'),('ZR','','MATADI'),('MU','','MAURITIUS'),('MU','','MAURITIUS'),('SC','','MAWE'),('CO','','MEDELLIN'),('AU','AU','MELBOURNE'),('AU','AU','MELBOURNE'),('ES','','MELILLA'),('US','US','MEMPHIS'),('AR','','MENDOZA'),('TR','','MERSIN'),('MX','','MEXICO'),('US','US','MIAMI'),('US','US','MIAMI'),('GB','','MIDDLESBOROUGH'),('IT','','MILANO'),('IT','','MILANO-MALPENZA'),('US','US','MILWAUKEE'),('OM','','MINA QABOOS'),('US','US','MINNEAPOLIS'),('CU','','MOA'),('JP','','MOJI'),('KE','','MOMBASA'),('CA','CA','MONCTON'),('IT','','MONFALCONE'),('LR','','MONROVIA'),('JM','','MONTEGO BAY'),('UY','','MONTEVIDEO'),('UY','','MONTEVIDEO'),('FR','FR','MONTOIR-BRETAGNE'),('CA','CA','MONTREAL'),('CA','CA','MONTREAL DORVAL'),('CA','','MONTREAL MIRABEL'),('RU','','MOSCOW'),('GB','','MOSSEND'),('FR','','MULHOUSE (BALE)'),('FR','','MULHOUSE (BALE)'),('IN','','MUMBAI'),('OM','','MUSCAT'),('OM','','MUSCAT'),('KR',' ABBAS','N'),('GB','','N. KILLINGHOLME'),('JP','','NAGOYA'),('JP','','NAGOYA'),('JP','JP','NAHA'),('KE','','NAIROBI'),('CN','','NANJING'),('NZ','','NAPIER'),('IT','','NAPOLI'),('IT','','NAPOLI'),('US','','NASHVILLE'),('US','US','NASHVILLE'),('BS','','NASSAU'),('BS','','NASSAU (BAHAMAS)'),('GB','','NEATH'),('NZ','','NELSON'),('US','US','NEW ORLEANS'),('CA','CA','NEW WESTMINSTER'),('US','US','NEW YORK - LA GUARDIA APT'),('US','US','NEW YORK JFK'),('US','US','NEWARK'),('US','US','NEWARK NJ'),('GB','','NEWCASTLE UPON TYNE'),('GB','','NEWPORT'),('CY','','NICOSIA'),('CN','','NINGBO'),('CN','CN','NINGBO'),('US','US','NORFOLK'),('SE','','NORRK?PING'),('MR','','NOUAKCHOTT'),('NC','','NOUMEA'),('NC','','NOUMEA'),('RU','','NOVOROSSIYSK'),('DK','','ODENSE'),('UA','','ODESSA'),('JP','','OKINAWA'),('JP','','OKINAWA'),('NG','','ONNE'),('BE','','OOSTENDE'),('DZ','','ORAN'),('AW','','ORANJESTAD'),('US','US','ORLANDO'),('JP','','OSAKA'),('JP','','OSAKA INTL'),('NO','','OSLO'),('NO','','OSLO'),('JP','','OTSU'),('CA','CA','OTTAWA'),('IT','','PALERMO'),('ES','','PALMA DE MALLORCA'),('PA','','PANAMA CITY'),('PA','','PANAMA CITY'),('PF','','PAPEETE'),('PF','','PAPEETE'),('SR','','PARAMARIBO'),('BR','','PARANAGUA'),('FR','','PARIS ORLY'),('FR','','PARIS ROISSY'),('MY','','PENANG'),('US','US','PENSACOLA'),('AU','','PERTH'),('AU','','PERTH'),('US','US','PHILADELPHIA'),('KH','','PHNOM PENH'),('VN','','PHNOM-PENH'),('US','','PHOENIX'),('GR','','PIRAEUS'),('US','US','PITTSBURGH'),('GP','','POINTE A PITRE'),('GP','','POINTE A PITRE'),('RE','','POINTE DES GALETS'),('PN','','POINTE NEGRE'),('CG','','POINTE NOIRE'),('PR','','PONCE'),('GB','','POOLE'),('AU','','PORT ADELAIDE'),('NZ','','PORT CHALMERS'),('ZA','','PORT ELIZABETH'),('NG','','PORT HARTCOUR'),('MY','','PORT KELANG'),('MU','','PORT LOUIS'),('TT','','PORT OF SPAIN'),('TT','','PORT OF SPAIN'),('AE','','PORT RASHID'),('EG','','PORT SAID'),('SD','','PORT SUDAN'),('OM','','PORT SULTAN QABOOS'),('FR','','PORT VENDRES'),('VU','','PORT VILA'),('HT','','PORT-AU-PRINCE'),('US','US','PORTLAND'),('PT','','PORTO'),('PT','','PORTO'),('BR','BR','PORTO ALEGRE'),('VE','','PORTO CABELLO'),('GB','','PORTSMOUTH'),('GB','','PORTSMOUTH GB'),('GE','','POTI'),('CZ','','PRAGUE'),('CZ','','PRAHA'),('CV','','PRAIA'),('MX','MX','PROGRESO'),('US','US','PROVIDENCE'),('TC','','PROVIDENCIALES'),('HN','','PUERTO CORTES'),('CR','','PUERTO LIMON'),('MX','','PUERTO MORELOS'),('DO','','PUERTO PLATA'),('GT','','PUERTO QUETZAL'),('HR','','PULA'),('CL','','PUNTA ARENAS'),('GB','','PURFLEET'),('KR','','PUSAN'),('KR','','PUSAN'),('KR','','PUSAN'),('CN','CN','QINGDAO'),('CN','','QUANZHOU'),('CA','','QUEBEC'),('TN','','RADES/TUNIS'),('US','US','RALEIGH/DURHAM INTL'),('GB','','RAMSGATE'),('IT','','RAVENNA'),('BR','BR','RECIFE'),('CA','','REGINA'),('US','US','RENO'),('IS','','REYKJAVIK'),('IS','','REYKJAVIK'),('GR','','RHODES'),('US','US','RICHMOND VA'),('US','US','RICHMOND VA'),('LV','','RIGA'),('LV','','RIGA'),('HR','','RIJEKA SUSAK'),('BR','BR','RIO DE JANEIRO'),('BR','BR','RIO DE JANEIRO'),('BR','BR','RIO GRANDE'),('DO','','RIO HAINA'),('SA','','RIYADH'),('IT','IT','ROMA'),('IT','','ROMA-CIAMPINO'),('IT','','ROMA-FIUMICINO'),('DM','','ROSEAU'),('DE','','ROSTOCK'),('GB','','ROSYTH'),('NL','NL','ROTTERDAM'),('FR','FR','ROUEN'),('IT','','ROVIGO'),('BR','','S. FRANCISCO DO S'),('US','US','SACRAMENTO'),('US','US','SACRAMENTO'),('MP','','SAIPAN'),('OM','','SALALAH'),('IT','','SALERNO'),('US','US','SALT LAKE CITY'),('BR','','SALVADOR'),('CO','','SAN ANDREAS ISLAND'),('CL','','SAN ANTONIO'),('US','US','SAN DIEGO'),('US','US','SAN DIEGO'),('US','US','SAN FRANCISCO'),('US','US','SAN FRANCISCO'),('US','','SAN JOSE'),('CR','','SAN JOSE'),('CR','','SAN JOSE'),('CR','','SAN JOSE'),('PR','','SAN JUAN'),('PR','','SAN JUAN'),('US','US','SAN PEDRO'),('HN','','SAN PEDRO DE SULA'),('SV','','SAN SALVADOR'),('CL','','SAN VICENTE'),('CN','','SANSHAN'),('CO','','SANTA MARTA'),('CL','','SANTIAGO'),('DO','','SANTO DOMINGO'),('DO','','SANTO DOMINGO'),('GT','','SANTO TOMAS DE CASTILLA'),('BR','','SANTOS'),('BR','BR','SAO PAULO'),('ST','','SAO TOME'),('CV','','SAO VICENTE'),('JP','','SAPPORO'),('JP','','SAPPORO'),('US','US','SAVANNAH'),('IT','','SAVONA'),('US','US','SEATTLE'),('US','US','SEATTLE'),('JP','','SENDAI'),('KR','','SEOUL'),('BR','BR','SEPETIBA'),('FR','FR','SETE'),('PT','','SETUBAL'),('ES','','SEVILLA'),('TN','','SFAX'),('CN','','SHANGHAI'),('CN','','SHANGHAI'),('CN','','SHANTOU'),('AE','','SHARJAH'),('AE','','SHARJAH'),('GB','','SHEERNESS'),('CN','','SHENYANG'),('JP','','SHIMIZU'),('US','US','SHREVEPORT'),('MY','','SIBU'),('KH','','SIHANOUKVILLE'),('SG','','SINGAPORE'),('SG','','SINGAPORE'),('FR','','SINT MAARTEN'),('SE','','SODERTALJE'),('GB','GB','SOUTHAMPTON'),('HR','','SPLIT'),('US','US','ST ALBAN'),('GP','','ST BARTHELEMY'),('FR','FR','ST DENIS'),('GR','','ST GEORGE'),('CA','CA','ST JOHN'),('CA','CA','ST JOHNS'),('KN','','ST KITTS'),('US','US','ST LOUIS'),('US','US','ST LOUIS'),('US','US','ST LOUIS'),('FR','','ST MALO'),('FR','FR','ST NAZAIRE'),('RU','','ST PETERSBURG'),('RU','','ST PETERSBURG'),('PM','','ST PIERRE'),('FR','','ST PIERRE ET MIQUELON'),('VG','','ST THOMAS'),('VI','','ST THOMAS'),('VC','','ST VINCENT'),('VC','','ST VINCENT'),('ES','ES','ST-CRUZ-TENERIFE'),('VI','','ST. CROIX ISLAND HAMILTON'),('RE','','ST. DENIS'),('LC','','ST. LUCIA'),('AN','','ST. MAARTEN'),('NO','','STAVANGER'),('SE','','STOCKHOLM'),('SE','','STOCKHOLM'),('BR','','SUAPE'),('PH','','SUBIC BAY'),('SE','','SUNDSVALL'),('FJ','','SUVA'),('AU','AU','SYDNEY'),('AU','AU','SYDNEY'),('PL','','SZCZECIN'),('US','US','TACOMA'),('TW','','TAIPEI'),('EE','','TALLINN'),('US','US','TAMPA'),('US','US','TAMPA'),('MX','MX','TAMPICO'),('MA','','TANGER'),('MY','','TANJUNG PELEPAS'),('IT','','TARANTO'),('NZ','','TAURANGA'),('GB','','TEESPORT'),('HN','','TEGUCIGALPA'),('IL','','TEL AVIV'),('GH','','TEMA'),('ES','','TENERIFE'),('GB','','THAMES PORT'),('GR','','THESSALONIKI'),('FO','','THORSHAVN'),('CN','','TIANJIN'),('CN','CN','TIANJIN'),('CN','','TIANJINXINGANG'),('GB','','TILBURY'),('JP','','TOKYO'),('JP','','TOKYO NARITA'),('JP','','TOKYO NARITA'),('US','US','TOLEDO'),('JP','','TOMAKOMAI'),('IT','','TORINO'),('CA','CA','TORONTO'),('CA','CA','TORONTO'),('VG','','TORTOLA'),('VG','','TORTOLA'),('FR','FR','TOULON'),('IT','','TRAPANI'),('DE','','TRAVEMUNDE'),('SE','','TRELLEBORG'),('IT','','TRIESTE'),('IT','','TRIESTE'),('LY','','TRIPOLI'),('NO','','TRONDHEIM'),('GB','','TROON'),('TN','','TUNIS'),('TN','','TUNIS'),('FI','','TURKU'),('MN','','ULAANBAATAR'),('NO','','ULSTEINVIK'),('AE','','UMM AL QAIWAIN'),('IT','','VADO LIGURE'),('ES','ES','VALENCIA'),('CL','','VALPARAISO'),('CA','CA','VANCOUVER'),('CA','CA','VANCOUVER'),('BG','','VARNA'),('IT','','VENEZIA'),('IT','','VENEZIA'),('MX','MX','VERACRUZ'),('IT','','VIAREGGIO'),('LC','','VIEUX FORT'),('ES','ES','VIGO'),('LT','','VILNIUS'),('BR','BR','VITORIA'),('NL','','VLISSINGEN'),('SE','SE','WALLHAMN'),('NA','','WALVIS BAY'),('PL','','WARSZAWA'),('US','US','WASHINGTON'),('NZ','','WELLINGTON'),('NZ','','WELLINGTON'),('CN','CN','WENZHOU'),('CA','CA','WHITBY'),('AT','','WIEN'),('US','US','WILMINGTON'),('US','US','WILMINGTON CA'),('CA','CA','WINNIPEG'),('CA','','WINNIPEG'),('CN','CN','XIAMEN'),('CN','','XINFENG'),('CN','','XINGANG'),('MM','','YANGON'),('CN','CN','YANTAI'),('CN','','YANTIAN'),('JP','','YOKOHAMA'),('HR','','ZAGREB'),('BE','BE','ZEEBRUGGE'),('CN','','ZHENGZHOU'),('CN','CN','ZHUHAI'),('CH','CH','ZURICH'),('CH','','ZURICH'),('EVERGLADES','EVERGLADES','EVERGLADES'),('-','-','PORT EVERGLADES'),('','','Caucedo'),('LEGHORN','LEGHORN','LEGHORN'),('-','-','PESCHIERRA BORROMEO'),('NAPOLES','NAPOLES','NAPOLES'),('Sines','Sines','Sines');
/*!40000 ALTER TABLE `puertos` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-07-25 21:13:51
