-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: intralog_impo
-- ------------------------------------------------------
-- 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 `iataexpint`
--

DROP TABLE IF EXISTS `iataexpint`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `iataexpint` (
  `destination` varchar(255) NOT NULL DEFAULT '',
  `iata` varchar(255) NOT NULL DEFAULT '',
  `id` varchar(250) NOT NULL DEFAULT '',
  `country` varchar(100) NOT NULL DEFAULT '',
  `schedule` varchar(10) NOT NULL DEFAULT '',
  `keybooking` double NOT NULL DEFAULT '1',
  `keyhbl` tinyint(4) NOT NULL DEFAULT '1',
  `region` varchar(100) NOT NULL DEFAULT '',
  `code_wwa_country` varchar(30) NOT NULL,
  `code_wwa_state` varchar(30) NOT NULL,
  `uncode` varchar(5) DEFAULT NULL,
  `idiata` int(11) NOT NULL AUTO_INCREMENT,
  UNIQUE KEY `idiata_UNIQUE` (`idiata`),
  KEY `i_destination` (`destination`)
) ENGINE=InnoDB AUTO_INCREMENT=1134 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `iataexpint`
--

LOCK TABLES `iataexpint` WRITE;
/*!40000 ALTER TABLE `iataexpint` DISABLE KEYS */;
INSERT INTO `iataexpint` VALUES ('AALBORG','AAL','1986','DENMARK','NO',0,1,'EUROPE','','',NULL,1),('AARHUS','AAR','2','DENMARK','NO',1,1,'EUROPE','','',NULL,2),('AGRIGENTO','GOA','3','ITALY','NO',0,1,'EUROPE','','',NULL,3),('ALBACETE','BCN','4','SPAIN','NO',0,1,'EUROPE','','',NULL,4),('ALESUND','AES','5','NORWAY','NO',1,1,'EUROPE','','',NULL,5),('ALESSANDRIA','GOA','6','ITALY','NO',0,1,'EUROPE','','',NULL,6),('ALGECIRAS','BCN','7','SPAIN','NO',0,1,'EUROPE','','',NULL,7),('ALICANTE','ALC','8','SPAIN','NO',1,1,'EUROPE','','',NULL,8),('ALMERIA','LEI','9','SPAIN','NO',1,1,'EUROPE','','',NULL,9),('AMSTERDAM','AMS','10','THE NETHERLANDS','NO',1,1,'EUROPE','','',NULL,10),('ANCONA','AOI','11','ITALY','NO',1,1,'EUROPE','','',NULL,11),('ANTALYA','AYT','12','TURKEY','NO',1,1,'M-EAST & AFRICA','','',NULL,12),('ANTWERP','ANR','13','BELGIUM','YES',1,4,'EUROPE','BE','ANR',NULL,13),('AOSTA','GOA','14','ITALY','NO',0,1,'EUROPE','','',NULL,14),('AREZZO','GOA','15','ITALY','NO',0,1,'EUROPE','','',NULL,15),('ARRECIFE','ACE','16','LANZAROTE/SPAIN','NO',1,1,'EUROPE','','',NULL,16),('ASCOLI PICENO','GOA','17','ITALY','NO',0,1,'EUROPE','','',NULL,17),('ASTI','GOA','18','ITALY','NO',0,1,'EUROPE','','',NULL,18),('ATHENS','ATH','19','GREECE','NO',1,1,'EUROPE','','',NULL,19),('AUGSBURG','AGB','20','GERMANY','NO',1,1,'EUROPE','','',NULL,20),('AVELLINO','QVN','21','ITALY','NO',1,1,'EUROPE','','',NULL,21),('AVILA','BCN','22','SPAIN','NO',0,1,'EUROPE','','',NULL,22),('BADAJOZ','BJZ','23','SPAIN','NO',1,1,'EUROPE','','',NULL,23),('BARCELONA','BCN','24','SPAIN','YES',1,1,'EUROPE','ES','BCN',NULL,24),('BARI','BRI','25','ITALY','NO',1,1,'EUROPE','','',NULL,25),('BASEL','BSL','26','SWITZERLAND','NO',1,1,'EUROPE','','',NULL,26),('BELLUNO','BLX','27','ITALY','NO',1,1,'EUROPE','','',NULL,27),('BENEVENTO','GOA','28','ITALY','NO',0,1,'EUROPE','','',NULL,28),('BERGAMO','BGY','29','ITALY','NO',1,1,'EUROPE','','',NULL,29),('BERGEN','BGO','30','NORWAY','NO',1,1,'EUROPE','','',NULL,30),('BERLIN','BER','31','GERMANY','NO',1,1,'EUROPE','','',NULL,31),('BERN','BRN','32','SWITZERLAND','NO',1,1,'EUROPE','','',NULL,32),('BIELEFELD','BFE','33','GERMANY','NO',1,1,'EUROPE','','',NULL,33),('BIELLA','GOA','34','ITALY','NO',0,1,'EUROPE','','',NULL,34),('BILBAO','BIO','35','SPAIN','NO',1,1,'EUROPE','','',NULL,35),('BIRMINGHAM','BHX','36','ENGLAND/UK','NO',0,1,'EUROPE','','',NULL,36),('BOLOGNA','BLQ','37','ITALY','NO',1,1,'EUROPE','','',NULL,37),('BOLZANO','ZBN','38','ITALY','NO',1,1,'EUROPE','','',NULL,38),('BONN','BNJ','39','GERMANY','NO',1,1,'EUROPE','','',NULL,39),('BORDEAUX','BOD','40','FRANCE','NO',1,1,'EUROPE','','',NULL,40),('BOTTROP','BTR','41','GERMANY','NO',0,1,'EUROPE','','',NULL,41),('BRATISLAVA','BTS','42','SLOVAKIA','NO',1,1,'EUROPE','','',NULL,42),('BREMEN','BRE','44','GERMANY','YES',1,2,'EUROPE','','',NULL,43),('BREMERHAVEN','BRV','45','GERMANY','NO',1,1,'EUROPE','DE','BRV','',44),('BRESCIA','QBS','46','ITALY','NO',1,1,'EUROPE','','',NULL,45),('BRINDISI','BDS','47','ITALY','NO',1,1,'EUROPE','','',NULL,46),('BRISTOL','BRS','48','ENGLAND/UK','NO',0,1,'EUROPE','','',NULL,47),('BRUSSELS','BRU','49','BELGIUM','NO',1,1,'EUROPE','','',NULL,48),('BUCHAREST','BUH','50','ROMANIA','NO',1,1,'EUROPE','','',NULL,49),('BUDAPEST','BUD','51','HUNGARY','NO',1,1,'EUROPE','','',NULL,50),('BURGOS','BCN','52','SPAIN','NO',0,1,'EUROPE','','',NULL,51),('CACERES','QUQ','53','SPAIN','NO',1,1,'EUROPE','','',NULL,52),('CADIZ','CDZ','54','SPAIN','NO',1,1,'EUROPE','','',NULL,53),('CAGLIARI','CAG','55','ITALY','NO',1,1,'EUROPE','','',NULL,54),('CALTANISSETTA','GOA','56','ITALY','NO',0,1,'EUROPE','','',NULL,55),('CAMPOBASSO','GOA','57','ITALY','NO',0,1,'EUROPE','','',NULL,56),('CASERTA','GOA','58','ITALY','NO',0,1,'EUROPE','','',NULL,57),('CASTELLON','BCN','59','SPAIN','NO',0,1,'EUROPE','','',NULL,58),('CATANIA','CTA','60','ITALY','NO',1,1,'EUROPE','','',NULL,59),('CATANZARO','QCZ','61','ITALY','NO',1,1,'EUROPE','','',NULL,60),('CESENA','GOA','62','ITALY','NO',0,1,'EUROPE','','',NULL,61),('CHIETI','GOA','64','ITALY','NO',0,1,'EUROPE','','',NULL,62),('CIUDAD REAL','BCN','65','SPAIN','NO',0,1,'EUROPE','','',NULL,63),('CIVITA VECCHIA','GOA','66','ITALY','NO',0,1,'EUROPE','','',NULL,64),('COLOGNE','CGN','67','GERMANY','NO',1,1,'EUROPE','','',NULL,65),('COMO','COM','68','ITALY','NO',0,1,'EUROPE','','',NULL,66),('COPENHAGUE','CPH','70','DENMARK','NO',1,1,'EUROPE','','',NULL,67),('CORDOBA','ODB','71','SPAIN','NO',1,1,'EUROPE','','',NULL,68),('CORFU','CFU','72','GREECE','NO',1,1,'EUROPE','','',NULL,69),('COSENZA','GOA','73','ITALY','NO',0,1,'EUROPE','','',NULL,70),('CREMONA','GOA','74','ITALY','NO',0,1,'EUROPE','','',NULL,71),('CUENCA','BCN','75','SPAIN','NO',0,1,'EUROPE','','',NULL,72),('CUNEO','GOA','76','ITALY','NO',0,1,'EUROPE','','',NULL,73),('DIJON','DIJ','77','FRANCE','NO',1,1,'EUROPE','','',NULL,74),('DORTMUND','DTM','78','GERMANY','NO',1,1,'EUROPE','','',NULL,75),('DRAMMEN','DRA','79','NORWAY','NO',1,1,'EUROPE','','',NULL,76),('DRESDEN','DRS','80','GERMANY','NO',1,1,'EUROPE','','',NULL,77),('DUBLIN','DUB','81','IRELAND REP','NO',1,1,'EUROPE','','',NULL,78),('DUESSELDORF','DUS','82','GERMANY','NO',1,1,'EUROPE','','',NULL,79),('ENNA','GOA','83','ITALY','NO',0,1,'EUROPE','','',NULL,80),('ESBJERG','EBJ','84','DENMARK','NO',1,1,'EUROPE','','',NULL,81),('ESPOO','ESP','85','FINLAND','NO',1,1,'EUROPE','','',NULL,82),('ESSEN','ESS','86','GERMANY','NO',1,1,'EUROPE','','',NULL,83),('FELIXSTOWE','FXT','87','ENGLAND/UK','NO',0,2,'EUROPE','','',NULL,84),('FERRARA','GOA','88','ITALY','NO',0,1,'EUROPE','','',NULL,85),('FIRENZE','FLR','89','ITALY','NO',1,1,'EUROPE','','',NULL,86),('FOGGIA','FOG','90','ITALY','NO',1,1,'EUROPE','','',NULL,87),('FORLI','FRL','91','ITALY','NO',1,1,'EUROPE','','',NULL,88),('FRANKFURT','FRA','92','GERMANY','NO',1,1,'EUROPE','','',NULL,89),('FREIBURG','QFB','93','GERMANY','NO',1,1,'EUROPE','','',NULL,90),('FROSINONE','QFR','94','ITALY','NO',1,1,'EUROPE','','',NULL,91),('GÄVLE','GVX','95','SWEDEN','NO',0,1,'EUROPE','','',NULL,92),('GDYNIA','GDY','96','POLAND','NO',1,1,'EUROPE','','',NULL,93),('GEBZE','GBZ','97','TURKEY','NO',0,1,'M-EAST & AFRICA','','',NULL,94),('GELSENKIRCHEN','HAM','98','GERMANY','NO',0,1,'EUROPE','','',NULL,95),('VILLENEUVE(GENEVE)','GVA','99','SWITZERLAND','NO',0,1,'EUROPE','','',NULL,96),('GENOVA, ITALY','GOA','100','ITALY','NO',0,6,'EUROPE','','',NULL,97),('GIESSEN','HAM','101','GERMANY','NO',0,1,'EUROPE','','',NULL,98),('GLASGOW','GLA','102','SCOTLAND','NO',1,1,'EUROPE','','',NULL,99),('GORIZIA','GOA','103','ITALY','NO',0,1,'EUROPE','','',NULL,100),('GOTHENBURG','GOT','104','SWEDEN','NO',1,1,'EUROPE','','',NULL,101),('GRANADA','GRX','105','SPAIN','NO',1,1,'EUROPE','','',NULL,102),('GRAZ','GRZ','106','AUSTRIA','NO',1,1,'EUROPE','','',NULL,103),('GROSSETO','GRS','107','ITALY','NO',1,1,'EUROPE','','',NULL,104),('GUADALAJARA, SPAIN','BCN','108','SPAIN','NO',0,1,'EUROPE','','',NULL,105),('HAMBURG','HAM','109','GERMANY','YES',5,17,'EUROPE','','',NULL,106),('HANNOVER','HAJ','110','GERMANY','NO',1,1,'EUROPE','','',NULL,107),('HELSINGBORG','JHE','111','SWEDEN','NO',1,1,'EUROPE','','',NULL,108),('HELSINKI','HEL','112','FINLAND','NO',1,1,'EUROPE','','',NULL,109),('HUELVA','BCN','113','SPAIN','NO',0,1,'EUROPE','','',NULL,110),('HUESCA','BCN','114','SPAIN','NO',0,1,'EUROPE','','',NULL,111),('IBIZA','IBZ','115','SPAIN','NO',0,1,'EUROPE','','',NULL,112),('IMPERIA','GOA','116','ITALY','NO',0,1,'EUROPE','','',NULL,113),('INNSBRUCK','INN','117','AUSTRIA','NO',1,1,'EUROPE','','',NULL,114),('IRUN','BCN','118','SPAIN','NO',0,1,'EUROPE','','',NULL,115),('ISERNIA','GOA','119','ITALY','NO',0,1,'EUROPE','','',NULL,116),('ISTANBUL','IST','120','TURKEY','NO',1,1,'M-EAST & AFRICA','','',NULL,117),('IZMIR','IZM','121','TURKEY','NO',1,1,'M-EAST & AFRICA','','',NULL,118),('JAEN','ENM','122','SPAIN','NO',1,1,'EUROPE','','',NULL,119),('JÖNKÖPING','JKG','123','SWEDEN','NO',0,1,'EUROPE','','',NULL,120),('KARLSRUHE','QKA','124','GERMANY','NO',1,1,'EUROPE','','',NULL,121),('KASSEL','KSF','125','GERMANY','NO',1,1,'EUROPE','','',NULL,122),('KAUNAS','KUN','126','LITHUANIA','NO',1,1,'EUROPE','','',NULL,123),('KIEL','KEL','127','GERMANY','NO',1,1,'EUROPE','','',NULL,124),('KLAIPEDA','KLJ','128','LITHUANIA','NO',1,1,'EUROPE','','',NULL,125),('KÖLN','CGN','129','GERMANY','NO',0,1,'EUROPE','','',NULL,126),('KOPER','KPR','130','SLOVENIA','NO',1,1,'EUROPE','','',NULL,127),('KORFU','CFU','131','GREECE','NO',1,1,'EUROPE','','',NULL,128),('KOTKA','KOT','132','FINLAND','NO',1,1,'EUROPE','','',NULL,129),('KRAKOW','KRK','133','POLAND','NO',1,1,'EUROPE','','',NULL,130),('KRISTIANSAND','KRS','134','NORWAY','NO',1,1,'EUROPE','','',NULL,131),('KRISTIANSUND','KSU','135','NORWAY','NO',1,1,'EUROPE','','',NULL,132),('LA CORUÑA','LCG','136','SPAIN','NO',0,1,'EUROPE','','',NULL,133),('LAHTI','LHT','137','FINLAND','NO',1,1,'EUROPE','','',NULL,134),('LANDSHOT(LANDSCHUT)','QLG','138','GERMANY','NO',1,1,'EUROPE','','',NULL,135),('LANZAROTE','BCN','139','SPAIN','NO',0,1,'EUROPE','','',NULL,136),('L AQUILA','GOA','140','ITALY','NO',0,1,'EUROPE','','',NULL,137),('LARNACA','LCA','141','CYPRUS','NO',1,1,'EUROPE','','',NULL,138),('LA SPEZIA','SPZ','142','ITALY','YES',0,1,'EUROPE','','',NULL,139),('LATINA','QLT','143','ITALY','NO',1,1,'EUROPE','','',NULL,140),('LAUSANNE','QLS','144','SWITZERLAND','NO',1,1,'EUROPE','','',NULL,141),('LA VALLETTA','LVV','145','MALTA','NO',1,1,'M-EAST & AFRICA','','',NULL,142),('LECCE','LCC','146','ITALY','NO',1,1,'EUROPE','','',NULL,143),('LECCO','GOA','147','ITALY','NO',0,1,'EUROPE','','',NULL,144),('LEEDS','LBA','148','ENGLAND/UK','NO',0,1,'EUROPE','','',NULL,145),('LE HAVRE','LEH','149','FRANCE','NO',2,4,'EUROPE','','',NULL,146),('LEIPZIG','LEJ','150','GERMANY','NO',1,1,'EUROPE','','',NULL,147),('LEIXOES(OPORTO)','OPO','151','PORTUGAL','NO',1,1,'EUROPE','','',NULL,148),('LEON, SPAIN','BCN','152','SPAIN','NO',0,1,'EUROPE','','',NULL,149),('LILLE','LIL','153','FRANCE','NO',1,1,'EUROPE','','',NULL,150),('LILLEHAMMER','LIH','154','NORWAY','NO',1,1,'EUROPE','','',NULL,151),('LIMASSOL','QLI','155','CYPRUS','NO',1,1,'EUROPE','','',NULL,152),('LINKÖPING','LPI','156','SWEDEN','NO',0,1,'EUROPE','','',NULL,153),('LINZ','LNZ','157','AUSTRIA','NO',1,1,'EUROPE','','',NULL,154),('LISBOA','LIS','158','PORTUGAL','NO',1,1,'EUROPE','','',NULL,155),('LIVERPOOL','LPL','159','ENGLAND/UK','NO',0,1,'EUROPE','','',NULL,156),('LIVORNO(LEGHORN)','LIV','160','ITALY','NO',1,1,'EUROPE','','',NULL,157),('LJUBLJANA','LJU','161','SLOVENIA','NO',1,1,'EUROPE','','',NULL,158),('','','162','','',0,0,'','','',NULL,159),('LONDON','LON','163','ENGLAND/UK','NO',0,1,'EUROPE','','',NULL,160),('LUCCA','LCV','164','ITALY','NO',1,1,'EUROPE','','',NULL,161),('LUDWIGSBURG','HAM','165','GERMANY','NO',0,1,'EUROPE','','',NULL,162),('LUGO','BCN','166','SPAIN','NO',0,1,'EUROPE','','',NULL,163),('LYON','LYS','167','FRANCE','NO',1,1,'EUROPE','','',NULL,164),('MACERATA','GOA','168','ITALY','NO',0,1,'EUROPE','','',NULL,165),('MADRID','MAD','169','SPAIN','NO',1,2,'EUROPE','','',NULL,166),('MAGDEBURG','HAM','170','GERMANY','NO',0,1,'EUROPE','','',NULL,167),('MALAGA','AGP','171','SPAIN','NO',1,1,'EUROPE','','',NULL,168),('MALMÖ','MMA','172','SWEDEN','NO',0,1,'EUROPE','','',NULL,169),('MALTA','MLA','173','MALTA','NO',1,1,'EUROPE','','',NULL,170),('MANCHESTER','MAN','174','ENGLAND/UK','NO',0,1,'EUROPE','','',NULL,171),('MANNHEIM','MHG','175','GERMANY','NO',1,1,'EUROPE','','',NULL,172),('MANTOVA','GOA','176','ITALY','NO',0,1,'EUROPE','','',NULL,173),('MARSEILLE','MRS','177','FRANCE','NO',0,1,'EUROPE','','',NULL,174),('MASSA CARRARA','GOA','178','ITALY','NO',0,1,'EUROPE','','',NULL,175),('MATERA','GOA','179','ITALY','NO',0,1,'EUROPE','','',NULL,176),('MERSIN(ICEL)','MSN','180','TURKEY','NO',1,1,'M-EAST & AFRICA','','',NULL,177),('MESSINA','QME','181','ITALY','NO',1,1,'EUROPE','','',NULL,178),('MILAN','MIL','182','ITALY','YES',1,9,'EUROPE','','',NULL,179),('MODENA','GOA','183','ITALY','NO',0,1,'EUROPE','','',NULL,180),('MONACO','MCM','184','MONACO','NO',1,1,'EUROPE','','',NULL,181),('MOSCOW','MOW','185','RUSSIA','NO',1,1,'EUROPE','','',NULL,182),('MUNICH','MUC','186','GERMANY','NO',1,1,'EUROPE','','',NULL,183),('MURCIA','MJV','187','SPAIN','NO',1,1,'EUROPE','','',NULL,184),('NAPOLI','NAP','188','ITALY','NO',1,1,'EUROPE','','',NULL,185),('NEUSS','HAM','189','GERMANY','NO',0,1,'EUROPE','','',NULL,186),('NICOSIA','NIC','190','CYPRUS','NO',1,1,'EUROPE','','',NULL,187),('NOVARA','GOA','191','ITALY','NO',0,1,'EUROPE','','',NULL,188),('NUERNBERG','NUE','192','GERMANY','NO',1,1,'EUROPE','','',NULL,189),('ODENSE','ODE','193','DENMARK','NO',1,1,'EUROPE','','',NULL,190),('OFFENBACH','HAM','194','GERMANY','NO',0,1,'EUROPE','','',NULL,191),('OLDENBURG','HAM','195','GERMANY','NO',0,1,'EUROPE','','',NULL,192),('OPORTO','OPO','196','PORTUGAL','NO',1,1,'EUROPE','','',NULL,193),('ORENSE','BCN','197','SPAIN','NO',0,1,'EUROPE','','',NULL,194),('OSLO','OSL','198','NORWAY','NO',1,3,'EUROPE','','',NULL,195),('OULU','OUL','199','FINLAND','NO',1,1,'EUROPE','','',NULL,196),('OVIEDO','OVD','200','SPAIN','NO',1,1,'EUROPE','','',NULL,197),('PADOVA','QPA','201','ITALY','NO',1,1,'EUROPE','','',NULL,198),('PALENCIA','BCN','202','SPAIN','NO',0,1,'EUROPE','','',NULL,199),('PALERMO','PMO','203','ITALY','NO',1,1,'EUROPE','','',NULL,200),('PALMA DE MALLORCA','PMI','204','SPAIN','NO',1,1,'EUROPE','','',NULL,201),('PAMPLONA','PNA','205','SPAIN','NO',1,1,'EUROPE','','',NULL,202),('PARIS','PAR','206','FRANCE','NO',1,1,'EUROPE','','',NULL,203),('PARMA','PMF','207','ITALY','NO',1,1,'EUROPE','','',NULL,204),('PAVIA','GOA','208','ITALY','NO',0,1,'EUROPE','','',NULL,205),('PERUGIA','PEG','209','ITALY','NO',1,1,'EUROPE','','',NULL,206),('PESARO','GOA','210','ITALY','NO',0,1,'EUROPE','','',NULL,207),('PESCARA','PSR','211','ITALY','NO',1,1,'EUROPE','','',NULL,208),('PIACENZA','GOA','212','ITALY','NO',0,1,'EUROPE','','',NULL,209),('PIRAEUS(PEIRAIAS)','PIR','213','GREECE','NO',1,1,'EUROPE','','',NULL,210),('PISA','PSA','214','ITALY','NO',1,1,'EUROPE','','',NULL,211),('PISTOIA','GOA','215','ITALY','NO',0,1,'EUROPE','','',NULL,212),('PONTEVEDRA','BCN','216','SPAIN','NO',0,1,'EUROPE','','',NULL,213),('PORDENONE','GOA','217','ITALY','NO',0,1,'EUROPE','','',NULL,214),('PORI','POR','218','FINLAND','NO',1,1,'EUROPE','','',NULL,215),('PORTA WESTFALICA','HAM','219','GERMANY','NO',0,1,'EUROPE','','',NULL,216),('POTENZA','GOA','220','ITALY','NO',0,1,'EUROPE','','',NULL,217),('PRAGUE','PRG','221','CZECH REP','NO',1,2,'EUROPE','','',NULL,218),('PRATO','QPR','222','ITALY','NO',1,1,'EUROPE','','',NULL,219),('RANDERS','RND','223','DENMARK','NO',1,1,'EUROPE','','',NULL,220),('RAUMA','RAM','224','FINLAND','NO',1,1,'EUROPE','','',NULL,221),('RAVENNA','RAN','225','ITALY','NO',1,1,'EUROPE','','',NULL,222),('REGENSBURG','HAM','226','GERMANY','NO',0,1,'EUROPE','','',NULL,223),('REGGIO CALABRIA','REG','227','ITALY','NO',1,1,'EUROPE','','',NULL,224),('REGGIO EMILIA','GOA','228','ITALY','NO',0,1,'EUROPE','','',NULL,225),('REYKJAVIK','REK','229','ICELAND','NO',1,1,'EUROPE','','',NULL,226),('RHEINE','HAM','230','GERMANY','NO',0,1,'EUROPE','','',NULL,227),('RHODOS','RHO','231','GREECE','NO',1,1,'EUROPE','','',NULL,228),('RIESA','HAM','232','GERMANY','NO',0,1,'EUROPE','','',NULL,229),('RIETI','GOA','233','ITALY','NO',0,1,'EUROPE','','',NULL,230),('RIGA','RIX','234','LATVIA','NO',1,1,'EUROPE','','',NULL,231),('ROME','ROM','235','ITALY','NO',1,1,'EUROPE','','',NULL,232),('ROSTOCK','RLG','236','GERMANY','NO',1,1,'EUROPE','','',NULL,233),('ROTTERDAM','RTM','237','NETHERLANDS','YES',1,3,'EUROPE','','',NULL,234),('ROVIGO','GOA','238','ITALY','NO',0,1,'EUROPE','','',NULL,235),('SAARBRUECKEN','SCN','239','GERMANY','NO',1,1,'EUROPE','','',NULL,236),('SALAMANCA','SLM','240','SPAIN','NO',1,1,'EUROPE','','',NULL,237),('SALERNO','QSR','241','ITALY','NO',1,1,'EUROPE','','',NULL,238),('SALZBURG','SZG','242','AUSTRIA','NO',1,1,'EUROPE','','',NULL,239),('SAN SEBASTIAN','EAS','243','SPAIN','NO',1,1,'EUROPE','','',NULL,240),('SANTANDER','SDR','244','SPAIN','NO',1,1,'EUROPE','','',NULL,241),('SASSARI(ALHEGRO)','QSS','245','ITALY','NO',1,1,'EUROPE','','',NULL,242),('SAVONA','GOA','246','ITALY','NO',0,1,'EUROPE','','',NULL,243),('SCHWEINFURT','HAM','247','GERMANY','NO',0,1,'EUROPE','','',NULL,244),('SEGOVIA','BCN','248','SPAIN','NO',0,1,'EUROPE','','',NULL,245),('SEVILLA','SVQ','249','SPAIN','NO',1,1,'EUROPE','','',NULL,246),('SIENA','SAY','250','ITALY','NO',1,1,'EUROPE','','',NULL,247),('SIRACUSA','GOA','251','ITALY','NO',0,1,'EUROPE','','',NULL,248),('SOFIA','SOF','252','BULGARIA','NO',1,1,'EUROPE','','',NULL,249),('SONDRIO','GOA','253','ITALY','NO',0,1,'EUROPE','','',NULL,250),('SORIA','BCN','254','SPAIN','NO',0,1,'EUROPE','','',NULL,251),('STAVANGER','SVG','255','NORWAY','NO',1,1,'EUROPE','','',NULL,252),('STOCKHOLM','STO','256','SWEDEN','NO',1,1,'EUROPE','','',NULL,253),('ST PETERSBURG','LED','257','RUSSIA','NO',1,1,'EUROPE','','',NULL,254),('STRASBOURG','SXB','258','FRANCE','NO',1,1,'EUROPE','','',NULL,255),('STUTTGART','STR','259','GERMANY','NO',1,1,'EUROPE','','',NULL,256),('TALLINN','TLL','260','ESTONIA','NO',1,1,'EUROPE','','',NULL,257),('TAMPERE','TMP','261','FINLAND','NO',1,1,'EUROPE','','',NULL,258),('TARANTO','TAR','262','ITALY','NO',1,1,'EUROPE','','',NULL,259),('TAUBERBISCHOFSHEIM','TBH','263','GERMANY','NO',0,1,'EUROPE','','',NULL,260),('TERAMO','GOA','264','ITALY','NO',0,1,'EUROPE','','',NULL,261),('TERNI','GOA','265','ITALY','NO',0,1,'EUROPE','','',NULL,262),('TERUEL','BCN','266','SPAIN','NO',0,1,'EUROPE','','',NULL,263),('THESSALONIKI','SKG','267','GREECE','NO',1,1,'EUROPE','','',NULL,264),('TILBURG','TBR','268','NETHERLANDS','NO',1,1,'EUROPE','','',NULL,265),('TILBURY','TBY','269','ENGLAND/UK','NO',0,1,'EUROPE','','',NULL,266),('TOLEDO','BCN','270','SPAIN','NO',0,1,'EUROPE','','',NULL,267),('TORINO','TRN','271','ITALY','NO',1,1,'EUROPE','','',NULL,268),('TOULOUSE','TLS','272','FRANCE','NO',1,1,'EUROPE','','',NULL,269),('TRENTO','GOA','273','ITALY','NO',0,1,'EUROPE','','',NULL,270),('TREVISO','QTV','274','ITALY','NO',1,1,'EUROPE','','',NULL,271),('TRIER','HAM','275','GERMANY','NO',0,1,'EUROPE','','',NULL,272),('TRIESTE','TRS','276','ITALY','NO',1,1,'EUROPE','','',NULL,273),('TRONDHEIM','TRD','277','NORWAY','NO',1,1,'EUROPE','','',NULL,274),('TURKU','TKU','278','FINLAND','NO',1,1,'EUROPE','','',NULL,275),('UDINE','UDN','279','ITALY','NO',1,1,'EUROPE','','',NULL,276),('ULM','QUL','280','GERMANY','NO',1,1,'EUROPE','','',NULL,277),('UPPSALA','UPP','281','SWEDEN','NO',1,1,'EUROPE','','',NULL,278),('VALENCIA','VLC','282','SPAIN','NO',1,1,'EUROPE','','',NULL,279),('VALLADOLID','VLL','283','SPAIN','NO',1,1,'EUROPE','','',NULL,280),('VANTAA','HEL','284','FINLAND','NO',0,1,'EUROPE','','',NULL,281),('VARESE','GOA','285','ITALY','NO',0,1,'EUROPE','','',NULL,282),('VÄSTERAS','VST','286','SWEDEN','NO',1,1,'EUROPE','','',NULL,283),('VENICE','VCE','287','ITALY','NO',1,1,'EUROPE','','',NULL,284),('VENLO','VEN','288','NETHERLANDS','NO',1,1,'EUROPE','','',NULL,285),('VERCELLI','GOA','289','ITALY','NO',0,1,'EUROPE','','',NULL,286),('VERONA','VRN','290','ITALY','NO',1,1,'EUROPE','','',NULL,287),('VICENZA','VIC','291','ITALY','NO',0,1,'EUROPE','','',NULL,288),('VIENNA','VIE','292','AUSTRIA','NO',1,1,'EUROPE','','',NULL,289),('VIGO','VGO','293','SPAIN','NO',1,1,'EUROPE','','',NULL,290),('DUNHUANG','DNH','2007','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,291),('VILLINGEN','HAM','295','GERMANY','NO',0,1,'EUROPE','','',NULL,292),('VILNIUS','VNO','296','LITHUANIA','NO',1,2,'EUROPE','','',NULL,293),('VITERBO','GOA','297','ITALY','NO',0,1,'EUROPE','','',NULL,294),('VITORIA, SPAIN','VIT','298','SPAIN','NO',1,1,'EUROPE','','',NULL,295),('VLADIVOSTOK','VVO','299','RUSSIA','NO',1,1,'EUROPE','','',NULL,296),('WARSAW','WAW','300','POLAND','NO',1,1,'EUROPE','','',NULL,297),('WUPPERTAL','UWP','301','GERMANY','NO',1,1,'EUROPE','','',NULL,298),('ZAGREB','ZAG','302','CROATIA','NO',1,1,'EUROPE','','',NULL,299),('ZAMORA, SPAIN','BCN','303','SPAIN','NO',0,1,'EUROPE','','',NULL,300),('ZARAGOZA','ZAZ','304','SPAIN','NO',1,2,'EUROPE','','',NULL,301),('ZURICH','ZRH','305','SWITZERLAND','NO',1,4,'EUROPE','','',NULL,302),('ACAJUTLA','ACJ','306','EL SALVADOR','NO',1,3,'C&S-AMERICA','','',NULL,303),('ANTOFAGASTA','ANF','307','CHILE','NO',1,1,'C&S-AMERICA','','',NULL,304),('ARICA','ARI','308','CHILE','NO',1,2,'C&S-AMERICA','','',NULL,305),('ARMENIA','AXM','309','COLOMBIA','NO',1,1,'C&S-AMERICA','','',NULL,306),('ASHTON','UNI','310','UNION ISLAND','NO',1,1,'C&S-AMERICA','','',NULL,307),('ASUNCION','ASU','311','PARAGUAY','NO',1,1,'C&S-AMERICA','','',NULL,308),('BALBOA','BLB','312','PANAMA','NO',1,1,'C&S-AMERICA','','',NULL,309),('BARRANQUILLA','BAQ','313','COLOMBIA','NO',1,1,'C&S-AMERICA','','',NULL,310),('BASSETERRE, ST KITTS','SKB','314','ST KITTS & NEVIS/GUADALUPE','NO',0,1,'C&S-AMERICA','','',NULL,311),('BELIZE CITY','BZE','315','BELIZE','NO',1,1,'C&S-AMERICA','','',NULL,312),('BEQUIA','BQU','316','ST VINCENT&GRENADINES','NO',1,1,'C&S-AMERICA','','',NULL,313),('BOGOTA(SANTA FE DE-)','BOG','317','COLOMBIA','NO',1,1,'C&S-AMERICA','','',NULL,314),('BRIDGETOWN','BGI','318','BARBADOS','NO',1,1,'C&S-AMERICA','','',NULL,315),('BUENAVENTURA','BUN','319','COLOMBIA','NO',1,1,'C&S-AMERICA','','',NULL,316),('BUENOS AIRES','BUE','320','ARGENTINA','YES',1,1,'C&S-AMERICA','AR','BUE',NULL,317),('CALI','CLO','321','COLOMBIA','NO',1,1,'C&S-AMERICA','','',NULL,318),('CALLAO','CLL','322','PERU','YES',2,4,'C&S-AMERICA','','',NULL,319),('CARTAGENA','CTG','323','COLOMBIA','YES',1,1,'C&S-AMERICA','','','COCTG',320),('CASTRIES, ST LUCIA','SLU','324','ST LUCIA','NO',0,1,'C&S-AMERICA','','',NULL,321),('COCHABAMBA','CBB','325','BOLIVIA','NO',1,1,'C&S-AMERICA','','',NULL,322),('COCKBURN HARBOUR','CCB','326','TURKS & CAICOS','NO',1,1,'C&S-AMERICA','','',NULL,323),('CODRINGTON','CDR','327','BARBADOS','NO',1,1,'C&S-AMERICA','','',NULL,324),('COLON','ONX','328','PANAMA','YES',12,16,'C&S-AMERICA','','',NULL,325),('CORINTO','CRX','329','NICARAGUA','NO',1,1,'C&S-AMERICA','','',NULL,326),('CRISTOBAL','CBA','330','PANAMA','NO',1,2,'C&S-AMERICA','','',NULL,327),('CURITIBA','CWB','331','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,328),('FORTALEZA','FOR','332','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,329),('FORT-DE-FRANCE','FDF','333','MARTINIQUE','NO',1,1,'C&S-AMERICA','','',NULL,330),('GEORGETOWN','GEO','334','GUYANA','NO',1,1,'C&S-AMERICA','','',NULL,331),('GRAND TURK','GDT','335','TURKS & CAICOS','NO',1,1,'C&S-AMERICA','','',NULL,332),('GUATEMALA CITY','GUA','336','GUATEMALA','NO',1,1,'C&S-AMERICA','','',NULL,333),('GUAYAQUIL','GYE','337','ECUADOR','YES',1,1,'C&S-AMERICA','','',NULL,334),('HILLSBOROUGH','CRU','338','CARRIACOU/GRENADA','NO',1,1,'C&S-AMERICA','','',NULL,335),('IQUIQUE','IQQ','339','CHILE','NO',1,1,'C&S-AMERICA','','',NULL,336),('ISLA MARGARITA','IMT','340','VENEZUELA','NO',1,1,'C&S-AMERICA','','',NULL,337),('ITAJAI','ITJ','341','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,338),('KINGSTON','KIN','342','JAMAICA','NO',1,2,'C&S-AMERICA','','',NULL,339),('KINGSTOWN, ST VINCENT','SVD','343','ST VINCENT&GRENADINES','NO',0,1,'C&S-AMERICA','','',NULL,340),('KRALENDIJK','BON','344','BONAIRE','NO',1,1,'C&S-AMERICA','','',NULL,341),('LA GUAIRA','LAG','345','VENEZUELA','YES',1,16,'C&S-AMERICA','','',NULL,342),('LA HABANA','HAV','346','CUBA','NO',1,2,'C&S-AMERICA','','',NULL,343),('LA PAZ, BOLIVIA','LPB','347','BOLIVIA','NO',1,1,'C&S-AMERICA','','',NULL,344),('MANAGUA','MGA','348','NICARAGUA','NO',1,1,'C&S-AMERICA','','',NULL,345),('MANAUS','MAO','349','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,346),('MANIZALES','MZL','350','COLOMBIA','NO',1,1,'C&S-AMERICA','','',NULL,347),('MANZANILLO, PANAMA','MZO','351','PANAMA','NO',0,1,'C&S-AMERICA','','','MXZLO',348),('MAYREAU','MYR','352','GRENADA','NO',1,1,'C&S-AMERICA','','',NULL,349),('MEDELLIN','EOH','353','COLOMBIA','NO',1,1,'C&S-AMERICA','','',NULL,350),('MONTEVIDEO','MVD','354','URUGUAY','NO',1,1,'C&S-AMERICA','','',NULL,351),('MUSTIQUE','MQS','355','ST VINCENT&GRENADINES','NO',1,1,'C&S-AMERICA','','',NULL,352),('NATAL','NAT','356','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,353),('NOVO HAMBURGO','NHB','357','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,354),('ORANJESTAD','AUA','358','ARUBA','NO',1,1,'C&S-AMERICA','','',NULL,355),('ORURO','ORU','359','BOLIVIA','NO',1,1,'C&S-AMERICA','','',NULL,356),('PALM','PAM','360','GRENADA','NO',1,1,'C&S-AMERICA','','',NULL,357),('PANAMA CITY','PTY','361','PANAMA','NO',1,8,'C&S-AMERICA','','',NULL,358),('PARAMARIBO','ORG','362','SURINAME','NO',1,1,'C&S-AMERICA','','',NULL,359),('PARANAGUA','PNG','363','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,360),('PEREIRA','PEI','364','COLOMBIA','NO',1,1,'C&S-AMERICA','','',NULL,361),('PETIT ST VINCENT','VCT','365','GRENADA','NO',1,1,'C&S-AMERICA','','',NULL,362),('PHILIPSBURG','SXM','366','ST. MAARTEN','NO',1,1,'C&S-AMERICA','','',NULL,363),('PORTO ALEGRE','POA','367','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,364),('SANTIAGO ','SCL','2303','CHILE','NO',0,0,'CHILE','','',NULL,365),('PROVIDENCIALES','PLS','369','TURKS & CAICOS','NO',1,1,'C&S-AMERICA','','',NULL,366),('PUERTO CABELLO','PBL','370','VENEZUELA','NO',1,1,'C&S-AMERICA','','',NULL,367),('PUERTO CORTES','PTC','371','HONDURAS','NO',1,1,'C&S-AMERICA','','',NULL,368),('PUERTO LIMON','LIO','372','COSTA RICA','NO',1,1,'C&S-AMERICA','','',NULL,369),('PUERTO QUETZAL','QTL','373','GUATEMALA','NO',1,1,'C&S-AMERICA','','',NULL,370),('PUNTA ARENAS','PUQ','374','CHILE','NO',1,1,'C&S-AMERICA','','',NULL,371),('RECIFE','REC','375','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,372),('RIO DE JANEIRO','RIO','376','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,373),('RIO GRANDE DO SUL','RIG','377','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,374),('RIO HAINA','HAI','378','DOMINICAN REP','NO',1,1,'C&S-AMERICA','','',NULL,375),('ROSSEAU','DCF','379','DOMINICA','NO',1,1,'C&S-AMERICA','','',NULL,376),('SALVADOR','SSA','380','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,377),('SAN ANTONIO','SAN','381','CHILE','NO',1,1,'C&S-AMERICA','','',NULL,378),('SAN JOSE','SJO','382','COSTA RICA','YES',1,14,'C&S-AMERICA','','',NULL,379),('SAN JUAN','SJU','383','PUERTO RICO','NO',1,2,'C&S-AMERICA','','',NULL,380),('SAN PEDRO SULA','SAP','384','HONDURAS','NO',1,1,'C&S-AMERICA','','',NULL,381),('SAN SALVADOR','SAL','385','EL SALVADOR','NO',1,1,'C&S-AMERICA','','',NULL,382),('SANTA CRUZ, BOLIVIA','SRZ','386','BOLIVIA','NO',1,1,'C&S-AMERICA','','',NULL,383),('SANTA MARTA','SMR','387','COLOMBIA','NO',1,1,'C&S-AMERICA','','',NULL,384),('SANTIAGO DE CHILE','SCL','388','CHILE','NO',1,2,'C&S-AMERICA','','',NULL,385),('SANTO DOMINGO','SDQ','389','DOMINICAN REP','NO',1,2,'C&S-AMERICA','','',NULL,386),('SANTOS','SSZ','390','BRAZIL','YES',1,11,'C&S-AMERICA','BR','SSZ',NULL,387),('SANTO TOMAS DE CASTILLA','STC','391','GUATEMALA','NO',1,1,'C&S-AMERICA','','',NULL,388),('ST CROIX','STX','392','VIRGIN ISLANDS','NO',1,1,'C&S-AMERICA','','',NULL,389),('ST GEORGES','GND','393','GRENADA','NO',1,1,'C&S-AMERICA','','',NULL,390),('ST JOHN','SJF','394','VIRGIN ISLANDS','NO',1,1,'C&S-AMERICA','','',NULL,391),('ST JOHNS','ANU','395','ANTIGUA & BARBUDA','NO',1,1,'C&S-AMERICA','','',NULL,392),('ST THOMAS','STT','396','VIRGIN ISLANDS','NO',1,1,'C&S-AMERICA','','',NULL,393),('SUAPE','SUA','397','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,394),('TALCAHUANO','THA','398','CHILE','NO',1,1,'C&S-AMERICA','','',NULL,395),('TEGUCIGALPA','TGU','399','HONDURAS','NO',1,1,'C&S-AMERICA','','',NULL,396),('VALPARAISO','VAP','400','CHILE','YES',4,2,'C&S-AMERICA','','',NULL,397),('VITORIA, BRAZIL','VIX','401','BRAZIL','NO',1,1,'C&S-AMERICA','','',NULL,398),('WILLEMSTAD','CUR','402','CURACAO','NO',1,1,'C&S-AMERICA','','',NULL,399),('ABIDJAN','ABJ','403','IVORY COAST','NO',1,1,'M-EAST & AFRICA','','',NULL,400),('ABU DHABI','AUH','404','U.A.E.','NO',1,1,'M-EAST & AFRICA','','',NULL,401),('ACCRA','ACC','405','GHANA','NO',1,1,'M-EAST & AFRICA','','',NULL,402),('ADEN','ADE','406','YEMEN','NO',1,1,'M-EAST & AFRICA','','',NULL,403),('AJMAN','QAJ','407','U.A.E.','NO',1,1,'M-EAST & AFRICA','','',NULL,404),('AL AIN','AAN','408','U.A.E.','NO',1,1,'M-EAST & AFRICA','','',NULL,405),('ALEXANDRIA','ALY','409','EGYPT','NO',1,1,'M-EAST & AFRICA','','',NULL,406),('ALGIERS','ALG','410','ALGERIA','NO',1,1,'M-EAST & AFRICA','','',NULL,407),('AMMAN','ADJ','411','JORDAN','NO',1,1,'M-EAST & AFRICA','','',NULL,408),('ANKARA','ANK','412','EGYPT','NO',1,1,'M-EAST & AFRICA','','',NULL,409),('ANTANARIVO','TNR','413','MADAGASCAR','NO',1,1,'M-EAST & AFRICA','','',NULL,410),('AQABA','AQJ','414','JORDAN','NO',1,1,'M-EAST & AFRICA','','',NULL,411),('ASHDOD','ASH','415','ISRAEL','NO',1,1,'M-EAST & AFRICA','','',NULL,412),('BAHRAIN','BAH','416','BAHRAIN','NO',1,1,'M-EAST & AFRICA','','',NULL,413),('BANDAR ABBAS','BND','417','IRAN','NO',1,1,'M-EAST & AFRICA','','',NULL,414),('BANJUL','BJL','418','GAMBIA','NO',1,1,'M-EAST & AFRICA','','',NULL,415),('BEIRUT','BEY','419','LEBANON','NO',1,1,'M-EAST & AFRICA','','',NULL,416),('BENGHAZI','BEN','420','LYBIA','NO',1,1,'M-EAST & AFRICA','','',NULL,417),('BLANTYRE','BLZ','421','MALAWI','NO',1,1,'M-EAST & AFRICA','','',NULL,418),('BULAWAYO','BUQ','422','ZIMBABWE','NO',1,1,'M-EAST & AFRICA','','',NULL,419),('CAIRO','CAI','423','EGYPT','NO',1,1,'M-EAST & AFRICA','','',NULL,420),('CAPETOWN','CPT','424','SOUTH AFRICA','NO',1,2,'M-EAST & AFRICA','','',NULL,421),('CASABLANCA','CAS','425','MAROCCO','NO',1,1,'M-EAST & AFRICA','','',NULL,422),('CONAKRY','CKY','426','GUINEA','NO',1,1,'M-EAST & AFRICA','','',NULL,423),('COTONOU','COO','427','BENIN','NO',1,1,'M-EAST & AFRICA','','',NULL,424),('DAKAR','DKR','428','SENEGAL','NO',1,1,'M-EAST & AFRICA','','',NULL,425),('DAMIETTA','DTT','429','EGYPT','NO',1,1,'M-EAST & AFRICA','','',NULL,426),('DAMMAM','DMM','430','SAUDI ARABIA','NO',1,1,'M-EAST & AFRICA','','',NULL,427),('DAR ES SALAAM','DAR','431','TANZANIA','NO',1,1,'M-EAST & AFRICA','','',NULL,428),('DJIBOUTI','JIB','432','DJIBOUTI','NO',1,1,'M-EAST & AFRICA','','',NULL,429),('DOHA','DOH','433','QATAR','NO',1,1,'M-EAST & AFRICA','','',NULL,430),('DOUALA','DLA','434','CAMEROUN','NO',1,1,'M-EAST & AFRICA','','',NULL,431),('DUBAI','DXB','435','U.A.E.','NO',1,1,'M-EAST & AFRICA','','',NULL,432),('DURBAN','DUR','436','SOUTH AFRICA','NO',1,1,'M-EAST & AFRICA','','',NULL,433),('EAST LONDON','ELS','437','SOUTH AFRICA','NO',1,1,'M-EAST & AFRICA','','',NULL,434),('FREETOWN','FNA','438','SIERRA LEONE','NO',1,1,'M-EAST & AFRICA','','',NULL,435),('FUJAIRAH','FJR','439','U.A.E.','NO',1,1,'M-EAST & AFRICA','','',NULL,436),('GABORONE','GBE','440','BOTSWANA','NO',1,1,'M-EAST & AFRICA','','',NULL,437),('HAIFA','HFA','441','ISRAEL','NO',1,1,'M-EAST & AFRICA','','',NULL,438),('HARARE','HRE','442','ZIMBABWE','NO',1,1,'M-EAST & AFRICA','','',NULL,439),('HODEIDAH','HOD','443','YEMEN','NO',1,1,'M-EAST & AFRICA','','',NULL,440),('JEBEL ALI','JBL','444','U.A.E.','NO',1,1,'M-EAST & AFRICA','','',NULL,441),('JEDDAH','JED','445','SAUDI ARABIA','NO',1,1,'M-EAST & AFRICA','','',NULL,442),('JOHANNESBURG','JNB','446','SOUTH AFRICA','NO',1,1,'M-EAST & AFRICA','','',NULL,443),('KHOR FAKKAN','KOR','447','U.A.E.','NO',1,1,'M-EAST & AFRICA','','',NULL,444),('KUWAIT','KWI','448','KUWAIT','NO',1,1,'M-EAST & AFRICA','','',NULL,445),('LAGOS','LOS','449','NIGERIA','NO',1,1,'M-EAST & AFRICA','','',NULL,446),('LA POINTE','RUN','450','REUNION','NO',1,1,'M-EAST & AFRICA','','',NULL,447),('LAS PALMAS','LPA','451','GRAN CANARIA/SPAIN','NO',1,1,'EUROPE','','',NULL,448),('LATTAKIA','LTK','452','SYRIA','NO',1,1,'M-EAST & AFRICA','','',NULL,449),('LIBREVILLE','LBV','453','GABON','NO',1,1,'M-EAST & AFRICA','','',NULL,450),('LOME','LFW','454','TOGO','NO',1,1,'M-EAST & AFRICA','','',NULL,451),('LUANDA','LAD','455','ANGOLA','NO',1,1,'M-EAST & AFRICA','','',NULL,452),('LUSAKA','LUN','456','ZAMBIA','NO',1,1,'M-EAST & AFRICA','','',NULL,453),('MAHE','SEZ','457','SEYCHELLES','NO',1,1,'M-EAST & AFRICA','','',NULL,454),('MANZINI','MTS','458','SWAZILAND','NO',1,1,'M-EAST & AFRICA','','',NULL,455),('MAPUTO','MPM','459','MOSAMBIQUE','NO',1,1,'M-EAST & AFRICA','','',NULL,456),('MATADI','MAT','460','CONGO- DEM.REP.','NO',1,1,'M-EAST & AFRICA','','',NULL,457),('MOMBASSA','MBA','461','KENYA','NO',1,1,'M-EAST & AFRICA','','',NULL,458),('MONROVIA','MLW','462','LIBERIA','NO',1,1,'M-EAST & AFRICA','','',NULL,459),('MUSCAT','MCT','463','OMAN','NO',1,1,'M-EAST & AFRICA','','',NULL,460),('NAIROBI','NBO','464','KENYA','NO',1,1,'M-EAST & AFRICA','','',NULL,461),('NOUAKCHOTT','NKC','465','MAURETANIA','NO',1,1,'M-EAST & AFRICA','','',NULL,462),('POINTE NOIRE','PNR','466','CONGO- DEM.REP.','NO',1,1,'M-EAST & AFRICA','','',NULL,463),('PORT ELIZABETH','PLZ','467','SOUTH AFRICA','NO',1,1,'M-EAST & AFRICA','','',NULL,464),('PORT HARCOURT','PHC','468','NIGERIA','NO',1,1,'M-EAST & AFRICA','','',NULL,465),('PORT LOUIS','PTL','469','MAURITIUS','YES',0,1,'M-EAST & AFRICA','','',NULL,466),('PORT SAID','PSD','470','EGYPT','NO',1,1,'M-EAST & AFRICA','','',NULL,467),('PORT SUDAN','PZU','471','SUDAN','NO',1,1,'M-EAST & AFRICA','','',NULL,468),('PORT SULTAN QABOOS','QAB','472','OMAN','NO',1,1,'M-EAST & AFRICA','','',NULL,469),('PRAIA','RAI','473','CAPE VERDE','NO',1,1,'M-EAST & AFRICA','','',NULL,470),('PUERTO DE ROSARIO','FUE','474','FUERTEVENTURA/SPAIN','NO',1,1,'EUROPE','','',NULL,471),('RAS AL KAIMAH','RKH','475','U.A.E.','NO',1,1,'M-EAST & AFRICA','','',NULL,472),('RIYADH','RUH','476','SAUDI ARABIA','NO',1,1,'M-EAST & AFRICA','','',NULL,473),('SALALAH','SLL','477','OMAN','NO',1,1,'M-EAST & AFRICA','','',NULL,474),('SANTA CRUZ DE PALMA','SPC','478','LA PALMA/SPAIN','NO',1,1,'EUROPE','','',NULL,475),('SANTA CRUZ DE TENERIFE','TFS','479','TENERIFE/SPAIN','NO',1,1,'EUROPE','','',NULL,476),('SFAX','SFA','480','TUNESIA','NO',1,1,'M-EAST & AFRICA','','',NULL,477),('SHARJAH','SHJ','481','U.A.E.','NO',1,1,'M-EAST & AFRICA','','',NULL,478),('SHUAIBA','SHQ','482','KUWAIT','NO',1,1,'M-EAST & AFRICA','','',NULL,479),('SIXTH OF OCTOBER','OCT','483','EGYPT','NO',1,1,'M-EAST & AFRICA','','',NULL,480),('SUEZ(EL SUWEIS)','SUE','484','EGYPT','NO',1,1,'M-EAST & AFRICA','','',NULL,481),('TAKORADI','TKD','485','GHANA','NO',1,1,'M-EAST & AFRICA','','',NULL,482),('TEL AVIV','TLV','486','ISRAEL','NO',1,1,'M-EAST & AFRICA','','',NULL,483),('TEMA','TEM','487','GHANA','NO',1,1,'M-EAST & AFRICA','','',NULL,484),('TENTH OF RAMADAN','RMM','488','EGYPT','NO',1,1,'M-EAST & AFRICA','','',NULL,485),('TOAMASINA','TOA','489','MADAGASCAR','NO',1,1,'M-EAST & AFRICA','','',NULL,486),('TRIPOLI','KYE','490','LEBANON','NO',1,1,'M-EAST & AFRICA','','',NULL,487),('TUNIS','TUN','491','TUNESIA','NO',1,1,'M-EAST & AFRICA','','',NULL,488),('WALVIS BAY','WVB','492','NAMIBIA','NO',1,1,'M-EAST & AFRICA','','',NULL,489),('WINDHOEK','ERS','493','NAMIBIA','NO',1,1,'M-EAST & AFRICA','','',NULL,490),('ADELAIDE','ADL','494','AUSTRALIA','NO',1,2,'F-EAST & OCEANIA','','',NULL,491),('AKITA','AXT','495','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,492),('ALOTAU(GURNEY)','GUR','496','PAPUA NEW GUINEA','NO',1,1,'F-EAST & OCEANIA','','',NULL,493),('ANYANG','AYN','497','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,494),('APIA','APW','498','SAMOA(WEST-)','NO',1,1,'F-EAST & OCEANIA','','',NULL,495),('AUCKLAND','AKL','499','NEW ZEALAND','NO',1,6,'F-EAST & OCEANIA','','',NULL,496),('BALIKPAPAN','BPN','500','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,497),('BANGALORE','BLR','501','INDIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,498),('BANGKOK','BKK','502','THAILAND','NO',1,5,'F-EAST & OCEANIA','','',NULL,499),('BAOTOU','BAV','503','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,500),('BATAM','BTH','504','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,501),('BEIDIHE','BDE','505','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,502),('BEIHAI','BHY','506','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,503),('BEIJING','BJS','507','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,504),('BELAWAN','BLW','508','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,505),('BINTULU','BTU','509','MALAYSIA(SARAWAK)','NO',1,1,'F-EAST & OCEANIA','','',NULL,506),('MUMBAI (NHAVA SHEVA)','BOM','511','INDIA','NO',0,1,'F-EAST & OCEANIA','','',NULL,507),('BRISBANE','BNE','512','AUSTRALIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,508),('PUSAN','PUS','513','KOREA','YES',1,11,'F-EAST & OCEANIA','KR','PUS',NULL,509),('CALCUTTA(KOLKATA)','CCU','514','INDIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,510),('CANGZHOU','CGZ','515','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,511),('CEBU','CEB','516','PHILIPPINES','NO',1,1,'F-EAST & OCEANIA','','',NULL,512),('CHANGCHUN','CGQ','517','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,513),('CHANGZHOU','CZX','519','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,514),('CHENGDU','CTU','520','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,515),('CHENNAI(MADRAS)','MAA','521','INDIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,516),('CHIBA','CHA','522','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,517),('CHIFENG','CIF','523','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,518),('CHITTAGONG','CGP','524','BANGLADESH','NO',1,1,'F-EAST & OCEANIA','','',NULL,519),('CHONGQING','CKG','525','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,520),('COCHIN','COK','526','INDIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,521),('COLOMBO','RML','527','SRI LANKA','NO',1,1,'F-EAST & OCEANIA','','',NULL,522),('DALIAN','DLC','528','CHINA','NO',1,2,'F-EAST & OCEANIA','','',NULL,523),('DARWIN','DRW','529','AUSTRALIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,524),('DATONG','DAT','530','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,525),('DAVAO','DVO','531','PHILIPPINES','NO',0,1,'F-EAST & OCEANIA','','',NULL,526),('DENPASAR','DPS','532','BALI','NO',1,1,'F-EAST & OCEANIA','','',NULL,527),('DHAKA','DAC','533','BANGLADESH','NO',1,1,'F-EAST & OCEANIA','','',NULL,528),('PUERTO CALDERA','CAL','2200','COSTA RICA','NO',0,0,'C&S-AMERICA','','',NULL,529),('DONGGUAN, FUMEN','DGM','535','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,530),('DUMAI','DUM','536','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,531),('DUNEDIN','DUD','537','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,532),('ESPIRITO SANTO','SON','538','VANUATU','NO',1,1,'F-EAST & OCEANIA','','',NULL,533),('FANGSHANG','FGS','539','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,534),('FENGTAI','FGT','540','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,535),('FREMANTLE','JFM','541','AUSTRALIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,536),('FUKUYAMA','QFY','542','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,537),('FOSHAN','FUO','543','CHINA','NO',0,1,'F-EAST & OCEANIA','','',NULL,538),('FUZHOU','FOC','544','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,539),('TAIPEI','TPE','2199','TAIWAN','NO',0,0,'F-EAST & OCEANIA','','',NULL,540),('GISBORNE','GIS','546','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,541),('GUAM','GUM','547','GUAM','NO',1,1,'F-EAST & OCEANIA','','',NULL,542),('GUANGZHOU','CAN','548','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,543),('HAIKOU','HAK','549','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,544),('DASHIQIAO','DSQ','2005','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,545),('SAN MARTIN OBISPO','SMA','2300','ESTADO DE MEXICO','NO',0,0,'MEXICO','','',NULL,546),('DANYANG','DYN','2003','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,547),('HAKATA','HTT','554','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,548),('HAMILTON','HLZ','555','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,549),('HANGZHOU','HGH','556','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,550),('HANOI','HAN','557','VIETNAM','NO',1,1,'F-EAST & OCEANIA','','',NULL,551),('HARBIN','HRB','558','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,552),('HIROSHIMA','HIJ','559','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,553),('HOBART','HBA','560','AUSTRALIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,554),('HOCHIMINH CITY','SGN','561','VIETNAM','NO',1,2,'F-EAST & OCEANIA','','',NULL,555),('HONIARA','HIR','562','SOLOMON ISLANDS','NO',1,1,'F-EAST & OCEANIA','','',NULL,556),('HONG KONG','HKG','563','CHINA','YES',1,6,'F-EAST & OCEANIA','HK','HKG','HKHKG',557),('HUAIROU','HUR','564','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,558),('HUANGPU, JISI','HGP','565','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,559),('HUANGYAN','HYN','566','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,560),('HUSHI','HSH','567','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,561),('HYDERABAD','HDD','568','PAKISTAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,562),('IMABARI','IBR','569','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,563),('INCHEON','JCN','570','KOREA(SOUTH-)','NO',0,2,'F-EAST & OCEANIA','','',NULL,564),('ISHIKARI','IKR','571','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,565),('JAKARTA','JKT','572','INDONESIA','NO',1,2,'F-EAST & OCEANIA','','',NULL,566),('JIANGMEN','JMN','573','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,567),('JIAXING','JXN','575','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,568),('JILIN','JIL','576','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,569),('JIUJIANG','JIU','578','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,570),('KANAZAWA','QKW','579','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,571),('KAOHSIUNG','KHH','580','TAIWAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,572),('KARACHI','KHI','581','PAKISTAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,573),('KAVIENG','KVG','582','PAPUA NEW GUINEA','NO',1,1,'F-EAST & OCEANIA','','',NULL,574),('KEELUNG','KLL','583','TAIWAN','YES',1,9,'F-EAST & OCEANIA','','',NULL,575),('KIMBE(HOSKINS)','HKN','584','PAPUA NEW GUINEA','NO',1,1,'F-EAST & OCEANIA','','',NULL,576),('KOBE','UKB','585','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,577),('KOMPONGTHOM','KZK','586','CAMBODIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,578),('KOTA KINABALU','BKI','587','MALAYSIA(EAST-)','NO',1,1,'F-EAST & OCEANIA','','',NULL,579),('KUALA BELAIT','KUB','588','BRUNEI','NO',0,1,'F-EAST & OCEANIA','','',NULL,580),('KUCHING','KCH','589','MALAYSIA(EAST-)','NO',1,1,'F-EAST & OCEANIA','','',NULL,581),('KUMAMOTO','KMJ','590','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,582),('KUNSHAN','UNH','591','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,583),('LABUAN','LBU','592','MALAYSIA(SABAH)','NO',1,1,'F-EAST & OCEANIA','','',NULL,584),('LAE','LAE','593','PAPUA NEW GUINEA','NO',1,1,'F-EAST & OCEANIA','','',NULL,585),('LAEM CHA BANG','LCH','594','THAILAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,586),('LANGFANG','LGF','595','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,587),('LANSHI','LNI','596','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,588),('LAUTOKA','LKK','597','FIJI ISLANDS','NO',1,1,'F-EAST & OCEANIA','','',NULL,589),('LEVIN','LVN','598','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,590),('LIAN HUA SHAN','LHH','599','CHINA','NO',1,2,'F-EAST & OCEANIA','','',NULL,591),('LIANYUNGANG(XINPU)','LYG','600','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,592),('DAGANG','DGN','2001','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,593),('LYTTELTON','LTE','602','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,594),('MACAO','QMP','603','MACAO','NO',1,1,'F-EAST & OCEANIA','','',NULL,595),('MADANG','MAG','604','PAPUA NEW GUINEA','NO',1,1,'F-EAST & OCEANIA','','',NULL,596),('NANHAI, JIUJIANG','JIU','2064','CHINA','NO',0,1,'F-EAST & OCEANIA','','',NULL,597),('MAIZURU','IZU','606','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,598),('MAKASSAR','MKK','607','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,599),('MALE','MLE','608','MALDIVES','NO',1,1,'F-EAST & OCEANIA','','',NULL,600),('MANILA','MNL','609','PHILIPPINES','NO',1,4,'F-EAST & OCEANIA','','',NULL,601),('MATSUYAMA','MYJ','610','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,602),('MELBOURNE','MEL','611','AUSTRALIA','NO',1,6,'F-EAST & OCEANIA','','',NULL,603),('MIRI','MYY','612','MALAYSIA(SARAWAK)','NO',1,1,'F-EAST & OCEANIA','','',NULL,604),('MIYUN','YUN','613','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,605),('MIZUSHIMA','MHM','614','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,606),('MOJI(MOJIKO)','OJI','615','JAPAN','NO',1,3,'F-EAST & OCEANIA','','',NULL,607),('MUARA','UAR','616','MALAYSIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,608),('MURORAN','MRN','617','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,609),('NAGANOSEKI','QNG','618','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,610),('NAGASAKI','NGS','619','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,611),('NAGOYA','NGO','620','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,612),('NAHA, OKINAWA','OKA','621','JAPAN','NO',0,1,'F-EAST & OCEANIA','','',NULL,613),('NAMP O','NMO','622','KOREA(NORTH-)','NO',1,1,'F-EAST & OCEANIA','','',NULL,614),('NANJING(NANKING)','NKG','623','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,615),('NANNING','NNG','624','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,616),('NANTONG','NTG','625','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,617),('LUXEMBOURG','LUX','2198','LUXEMBOURG','NO',0,0,'EUROPE','','',NULL,618),('NAOETSU','ETS','627','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,619),('NAPIER(HASTINGS)','NPE','628','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,620),('NELSON','NSN','629','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,621),('NEW DELHI','DEL','630','INDIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,622),('NEW PLYMOUTH','NPL','631','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,623),('NHAVA SHEVA','NVH','632','INDIA','NO',0,2,'F-EAST & OCEANIA','IN','NSA',NULL,624),('NIIGATA','KIJ','633','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,625),('NINGBO','NGB','634','CHINA','NO',1,1,'F-EAST & OCEANIA','CN','NGB',NULL,626),('NOUMEA','NOU','635','NEW CALEDONIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,627),('NUKU ALOFA','TBU','636','TONGA','NO',1,1,'F-EAST & OCEANIA','','',NULL,628),('OITA','OIT','637','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,629),('OSAKA','OSA','638','JAPAN','NO',1,2,'F-EAST & OCEANIA','','',NULL,630),('PADANG','PDG','639','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,631),('PAGO PAGO','PPG','640','SAMOA(AM.-)','NO',1,1,'F-EAST & OCEANIA','','',NULL,632),('PALEMBANG','PLM','641','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,633),('PAPEETE','PPT','642','TAHITI,FRENCH POLYNESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,634),('PASIR GUDANG','PSG','643','MALAYSIA(WEST-)','NO',1,1,'F-EAST & OCEANIA','','',NULL,635),('PENANG','PEN','644','MALAYSIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,636),('PERAWANG','PRW','645','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,637),('PHNOM PENH','PNH','646','CAMBODIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,638),('PONTIANAK','PNK','647','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,639),('PORT KELANG','PTK','648','MALAYSIA(WEST-)','NO',1,6,'F-EAST & OCEANIA','','',NULL,640),('PORT MORESBY','POM','649','PAPUA NEW GUINEA','NO',1,1,'F-EAST & OCEANIA','','',NULL,641),('PORT VILA','VLI','650','VANUATU','NO',1,1,'F-EAST & OCEANIA','','',NULL,642),('QINGDAO','TAO','651','CHINA','NO',1,1,'F-EAST & OCEANIA','CN','TAO',NULL,643),('QINHUANGDAO','SHP','652','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,644),('QUZHOU','QUZ','654','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,645),('RABAUL','RAB','655','PAPUA NEW GUINEA','NO',1,1,'F-EAST & OCEANIA','','',NULL,646),('RAJIN','JNR','656','KOREA(NORTH-)','NO',1,1,'F-EAST & OCEANIA','','',NULL,647),('RAROTONGA(AVARUA)','RAR','657','COOK ISLANDS','NO',1,1,'F-EAST & OCEANIA','','',NULL,648),('RONGQI','NGQ','658','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,649),('ROTORUA','ROT','659','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,650),('SAIPAN','SPN','660','SAIPAN,MARIANA ISLANDS','NO',1,1,'F-EAST & OCEANIA','','',NULL,651),('SAKAIMINATO','SKA','661','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,652),('SAKATA','SAA','662','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,653),('SANDAKAN','SDK','663','MALAYSIA(SABAH)','NO',1,1,'F-EAST & OCEANIA','','',NULL,654),('SEMARANG','SRG','664','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,655),('SEOUL','SEL','665','KOREA(SOUTH-)','NO',1,5,'F-EAST & OCEANIA','','',NULL,656),('SHANGHAI','SHA','666','CHINA','YES',1,8,'F-EAST & OCEANIA','CN','SHA','',657),('SHANHAIGUAN','SHF','667','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,658),('SHANTOU','SWA','668','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,659),('SEMERANG(SAIPAN)','SPN','1989','SAIPAN,MARIANA ISLANDS','NO',1,1,'F-EAST & OCEANIA','','',NULL,660),('SHEKOU(MAWAM)','HKO','671','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,661),('SHENYANG','SHE','672','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,662),('SHENZHEN','SZX','673','CHINA','YES',1,1,'F-EAST & OCEANIA','','',NULL,663),('SHIBA','SBA','674','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,664),('SHIMIZU','HZU','675','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,665),('SHIMONOSEKI','SMN','676','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,666),('SHIJIAZHUANG','SJW','677','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,667),('SHUNYI','UNY','678','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,668),('SIBU','SBW','679','MALAYSIA(SARAWAK)','NO',1,1,'F-EAST & OCEANIA','','',NULL,669),('SIHANOUKVILLE','SHV','680','CAMBODIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,670),('SINGAPORE','SIN','681','SINGAPORE','NO',1,3,'F-EAST & OCEANIA','','',NULL,671),('SURABAYA','SUB','682','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,672),('SUVA','SUV','683','FIJI ISLANDS','NO',1,1,'F-EAST & OCEANIA','','',NULL,673),('SUZHOU','SZV','684','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,674),('SYDNEY','SYD','685','AUSTRALIA','NO',1,3,'F-EAST & OCEANIA','','',NULL,675),('TAICHUNG','TXG','687','TAIWAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,676),('TAIPING','AIN','688','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,677),('TAIYUAN','TYN','689','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,678),('TAKAMATSU','TAK','690','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,679),('TANGSHAN','GSH','691','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,680),('TARAWA','TRW','692','KIRIBATI','NO',1,1,'F-EAST & OCEANIA','','',NULL,681),('TAURANGA','TRG','693','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,682),('TAWAU','TWU','694','MALAYSIA(SABAH)','NO',1,1,'F-EAST & OCEANIA','','',NULL,683),('TIANJIN','TSN','695','CHINA','NO',1,2,'F-EAST & OCEANIA','','',NULL,684),('TOKUSHIMA','TKS','696','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,685),('TOKUYAMA','TKA','697','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,686),('TOKYO','TYO','698','JAPAN','NO',1,2,'F-EAST & OCEANIA','','',NULL,687),('TOMAKOMAI','TMA','699','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,688),('CHANGSHA','CSX','1998','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,689),('TONGXIAN','GXI','701','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,690),('TOYAMA','TOY','702','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,691),('TOYAMA SHINKO','TOY','703','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,692),('TOYOHASHI','TYH','704','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,693),('TSURUGA','TSG','705','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,694),('TUTICORIN','TCR','706','INDIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,695),('UJUNG PANDANG','UPG','707','INDONESIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,696),('ULAN BATOR','ULN','708','MONGOLIA','NO',1,1,'F-EAST & OCEANIA','','',NULL,697),('VUNG TAU','VTG','709','VIETNAM','NO',1,1,'F-EAST & OCEANIA','','',NULL,698),('WAKAYAMA','WKY','710','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,699),('WEWAK','WWK','711','PAPUA NEW GUINEA','NO',1,1,'F-EAST & OCEANIA','','',NULL,700),('WEIHAI','WEH','712','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,701),('WELLINGTON','WLG','713','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,702),('WENZHOU','WNZ','715','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,703),('WHANGAREI','WRE','716','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,704),('WUHAN','WUH','717','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,705),('WUXI','WUX','718','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,706),('WUZHOU','WUZ','719','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,707),('XIAMEN','XMN','720','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,708),('XIAOSHAN','XSH','722','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,709),('XINFENG','XFG','723','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,710),('XINGANG (TIANJINXINGANG)','TSN','724','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,711),('XINHUI','XIH','725','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,712),('XUZHOU','XUZ','726','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,713),('YANGON(RANGOON)','RGN','727','MYANMAR','NO',1,1,'F-EAST & OCEANIA','','',NULL,714),('YANGZHOU','YGZ','728','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,715),('BEIJING CAPITAL AIRPORT','PEK','1995','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,716),('YANTAI','YNT','730','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,717),('YANTIAN','YTN','731','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,718),('YATSUSHIRO','YSS','732','JAPAN','NO',1,2,'F-EAST & OCEANIA','','',NULL,719),('YINGKOU','YNG','733','CHINA','NO',1,2,'F-EAST & OCEANIA','','',NULL,720),('YIWU','YIW','734','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,721),('BENXI','BXY','1994','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,722),('YOKKAICHI','YKK','736','JAPAN','NO',1,1,'F-EAST & OCEANIA','','',NULL,723),('YOKOHAMA','YOK','737','JAPAN','NO',1,1,'F-EAST & OCEANIA','JP','NGI',NULL,724),('BAODI','BAD','1992','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,725),('ZHANGJIAGANG','ZGJ','740','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,726),('ZHANGJIAKOU','ZGK','741','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,727),('ZHANJIANG','ZHA','742','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,728),('ZHENJIANG','ZHE','745','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,729),('ZHONGGSHAN','ZHO','746','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,730),('ZHUHAI','ZUH','747','CHINA','NO',1,2,'F-EAST & OCEANIA','','',NULL,731),('LIMA','LIM','1990','PERU','NO',1,1,'C&S-AMERICA','','',NULL,732),('DILI','DII','2006','PHILIPPINES','NO',1,1,'F-EAST & OCEANIA','','',NULL,733),('VERACRUZ, MEXICO','VER','1878','MEXICO','YES',0,127,'MEXICO','MX','VER','MXVER',734),('MANZANILLO, MEXICO','ZLO','1879','MEXICO','YES',0,1,'MEXICO','MX','ZLO','MXZLO',735),('ALTAMIRA, MEXICO','ALM','1880','MEXICO','YES',0,1,'MEXICO','MX','ATM','MXATM',736),('FUXIN','FXN','2009','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,737),('FUSHUN','FSH','2008','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,738),('GDANSK','GDN','1988','POLAND','NO',1,1,'EUROPE','','',NULL,739),('DAQING','DAQ','2004','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,740),('DANDONG','DDG','2002','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,741),('CHENGDE(BEIJING)','PEK','2000','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,742),('CHANGSHU','CHU','1999','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,743),('CHANGPING','CHP','1996','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,744),('BAODING','BNG','1993','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,745),('ANSHAN','AOG','1991','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,746),('ACAPULCO','ACA','1881','MEXICO','NO',1,1,'MEXICO','','',NULL,747),('CIUDAD ACUNA','ACN','1882','MEXICO','NO',1,1,'MEXICO','','',NULL,748),('AGUASCALIENTES','AGU','1883','MEXICO','NO',1,1,'MEXICO','','',NULL,749),('ABREOJOS','AJS','1884','MEXICO','NO',1,2,'MEXICO','','',NULL,750),('APATZINGAN','AZG','1885','MEXICO','NO',1,1,'MEXICO','','',NULL,751),('BAHIA ANGELES','BHL','1886','MEXICO','NO',1,1,'MEXICO','','',NULL,752),('LEON, GTO','BJX','1887','MEXICO','NO',1,1,'MEXICO','','',NULL,753),('CEDROS ISLAND','CDI','1888','MEXICO','NO',1,1,'MEXICO','','',NULL,754),('CIUDAD OBREGON','CEN','1889','MEXICO','NO',1,1,'MEXICO','','',NULL,755),('CIUDAD JUAREZ','CJS','1890','MEXICO','NO',1,1,'MEXICO','','',NULL,756),('COLIMA','CLQ','1891','MEXICO','NO',1,1,'MEXICO','','',NULL,757),('CIUDAD DEL CARMEN','CME','1892','MEXICO','NO',1,1,'MEXICO','','',NULL,758),('CANANEA','CNA','1893','MEXICO','NO',1,1,'MEXICO','','',NULL,759),('CAMPECHE','CPE','1894','MEXICO','NO',1,1,'MEXICO','','',NULL,760),('CHETUMAL','CTM','1895','MEXICO','NO',1,1,'MEXICO','','',NULL,761),('CATAVINA','CTV','1896','MEXICO','NO',1,1,'MEXICO','','',NULL,762),('CIUDAD CONSTITUCION','CUA','1897','MEXICO','NO',1,1,'MEXICO','','',NULL,763),('CULIACAN','CUL','1898','MEXICO','NO',1,1,'MEXICO','','',NULL,764),('CANCUN','CUN','1899','MEXICO','NO',1,1,'MEXICO','','',NULL,765),('CHIHUAHUA','CUU','1900','MEXICO','NO',1,1,'MEXICO','','',NULL,766),('CIUDAD VICTORIA','CVM','1901','MEXICO','NO',1,1,'MEXICO','','',NULL,767),('CHICHEN ITZA','CZA','1902','MEXICO','NO',1,1,'MEXICO','','',NULL,768),('COZUMEL','CZM','1903','MEXICO','NO',1,1,'MEXICO','','',NULL,769),('DURANGO','DGO','1904','MEXICO','NO',1,1,'MEXICO','','',NULL,770),('ENSENADA','ESE','1905','MEXICO','NO',1,1,'MEXICO','','',NULL,771),('GUADALAJARA, MEXICO','GDL','1906','MEXICO','NO',1,1,'MEXICO','','',NULL,772),('GUERRERO NEGRO','GUB','1907','MEXICO','NO',1,1,'MEXICO','','',NULL,773),('GUAYMAS','GYM','1908','MEXICO','NO',1,1,'MEXICO','','',NULL,774),('HERMOSILLO','HMO','1909','MEXICO','NO',1,1,'MEXICO','','',NULL,775),('SANTA CRUZ/HUATULCO','HUX','1910','MEXICO','NO',1,1,'MEXICO','','',NULL,776),('ISLA MUJERES','ISJ','1911','MEXICO','NO',1,1,'MEXICO','','',NULL,777),('IXTEPEC','IZT','1912','MEXICO','NO',1,1,'MEXICO','','',NULL,778),('JALAPA','JAL','1913','MEXICO','NO',1,1,'MEXICO','','',NULL,779),('LA PAZ, MEXICO','LAP','1914','MEXICO','NO',1,1,'MEXICO','','',NULL,780),('LEON, BAJIO','LEN','1915','MEXICO','NO',1,1,'MEXICO','','',NULL,781),('LOS MOCHIS','LMM','1916','MEXICO','NO',1,1,'MEXICO','','',NULL,782),('LAGOS DE MORENO','LOM','1917','MEXICO','NO',1,1,'MEXICO','','',NULL,783),('MONCLOVA','LOV','1918','MEXICO','NO',1,1,'MEXICO','','',NULL,784),('FUYANG','FUG','2010','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,785),('LORETO','LTO','1919','MEXICO','NO',1,1,'MEXICO','','',NULL,786),('LAZARO CARDENAS, MEXICO','LZC','1920','MEXICO','NO',1,1,'MEXICO','','','MXLZC',787),('MATAMOROS','MAM','1921','MEXICO','NO',1,1,'MEXICO','','',NULL,788),('MEXICO CITY','MEX','1922','MEXICO','NO',1,2,'MEXICO','','',NULL,789),('MERIDA','MID','1923','MEXICO','NO',1,1,'MEXICO','','',NULL,790),('MORELIA','MLM','1924','MEXICO','NO',1,1,'MEXICO','','',NULL,791),('CIUDAD MANTE','MMC','1925','MEXICO','NO',1,1,'MEXICO','','',NULL,792),('MINATITLAN','MTT','1926','MEXICO','NO',1,1,'MEXICO','','',NULL,793),('MONTERREY','MTY','1927','MEXICO','NO',1,1,'MEXICO','','',NULL,794),('MULEGE','MUG','1928','MEXICO','NO',1,1,'MEXICO','','',NULL,795),('MEXICALI','MXL','1929','MEXICO','NO',1,1,'MEXICO','','',NULL,796),('MAZATLAN','MZT','1930','MEXICO','NO',1,1,'MEXICO','','',NULL,797),('CASAS GRANDES','NCG','1931','MEXICO','NO',1,1,'MEXICO','','',NULL,798),('NUEVO LAREDO','NLD','1932','MEXICO','NO',1,1,'MEXICO','','',NULL,799),('NOGALES','NOG','1933','MEXICO','NO',1,1,'MEXICO','','',NULL,800),('OAXACA','OAX','1934','MEXICO','NO',1,1,'MEXICO','','',NULL,801),('POZA RICA','PAZ','1935','MEXICO','NO',1,1,'MEXICO','','',NULL,802),('PUEBLA','PBC','1937','MEXICO','NO',1,1,'MEXICO','','',NULL,803),('PLAYA DEL CARMEN','PCM','1938','MEXICO','NO',1,1,'MEXICO','','',NULL,804),('PUNTA COLORADA','PCO','1939','MEXICO','NO',1,1,'MEXICO','','',NULL,805),('PUNTA CHIVATO','PCV','1940','MEXICO','NO',1,1,'MEXICO','','',NULL,806),('PIEDRAS NEGRAS','PDS','1941','MEXICO','NO',1,1,'MEXICO','','',NULL,807),('PUERTO JUAREZ','PJZ','1942','MEXICO','NO',1,1,'MEXICO','','',NULL,808),('PALMIA','PLL','1943','MEXICO','NO',1,1,'MEXICO','','',NULL,809),('PUNOTECA','PNO','1944','MEXICO','NO',1,1,'MEXICO','','',NULL,810),('PUERTO PENASCO','PPE','1945','MEXICO','NO',1,1,'MEXICO','','',NULL,811),('PALENQUE','PQM','1946','MEXICO','NO',1,1,'MEXICO','','',NULL,812),('POCHUTLA','PUH','1947','MEXICO','NO',1,1,'MEXICO','','',NULL,813),('PUERTO VALLARTA','PVR','1948','MEXICO','NO',1,1,'MEXICO','','',NULL,814),('PUERTO ESCONDIDO','PXM','1949','MEXICO','NO',1,1,'MEXICO','','',NULL,815),('QUERETARO','QRO','1950','MEXICO','NO',1,1,'MEXICO','','',NULL,816),('COATZACOALCOS','QTZ','1951','MEXICO','NO',1,1,'MEXICO','','',NULL,817),('RANCHO BUENA VISTA','RBV','1952','MEXICO','NO',1,1,'MEXICO','','',NULL,818),('REYNOSA','REX','1953','MEXICO','NO',1,1,'MEXICO','','',NULL,819),('SALINA CRUZ','SCX','1954','MEXICO','NO',1,1,'MEXICO','','',NULL,820),('SAN FRANCISQUITO','SFQ','1956','MEXICO','NO',1,1,'MEXICO','','',NULL,821),('SAN IGNACIO','SGM','1957','MEXICO','NO',1,1,'MEXICO','','',NULL,822),('SAN JOSE DEL CABO','SDJ','1958','MEXICO','NO',1,1,'MEXICO','','',NULL,823),('SAN LUIS POTOSI','SLP','1959','MEXICO','NO',1,1,'MEXICO','','',NULL,824),('SALTILLO','SLW','1960','MEXICO','NO',1,1,'MEXICO','','',NULL,825),('SAN QUINTIN','SNQ','1961','MEXICO','NO',1,1,'MEXICO','','',NULL,826),('SANTA ROSALIA','SRL','1962','MEXICO','NO',1,1,'MEXICO','','',NULL,827),('TAMPICO','TAM','1963','MEXICO','NO',1,1,'MEXICO','','',NULL,828),('TAPACHULA','TAP','1964','MEXICO','NO',1,1,'MEXICO','','',NULL,829),('TEHUACAN','TCN','1965','MEXICO','NO',1,1,'MEXICO','','',NULL,830),('TUXTLA GUTIERREZ','TGZ','1966','MEXICO','NO',1,1,'MEXICO','','',NULL,831),('TIJUANA','TIJ','1967','MEXICO','NO',1,1,'MEXICO','','',NULL,832),('TOLUCA','TLC','1968','MEXICO','NO',1,1,'MEXICO','','',NULL,833),('TEPIC','TPQ','1969','MEXICO','NO',1,1,'MEXICO','','',NULL,834),('TORREON','TRC','1970','MEXICO','NO',1,1,'MEXICO','','',NULL,835),('TAMUIN','TSL','1971','MEXICO','NO',1,1,'MEXICO','','',NULL,836),('TULUM','TUY','1972','MEXICO','NO',1,1,'MEXICO','','',NULL,837),('TIZIMIN','TZM','1973','MEXICO','NO',1,1,'MEXICO','','',NULL,838),('SAN LUIS RIO COLORADO','UAC','1974','MEXICO','NO',1,1,'MEXICO','','',NULL,839),('URUAPAN','URN','1975','MEXICO','NO',1,1,'MEXICO','','',NULL,840),('VALLES','VAE','1976','MEXICO','NO',1,1,'MEXICO','','',NULL,841),('VILLA CONSTITUCION','VIB','1977','MEXICO','NO',1,1,'MEXICO','','',NULL,842),('VALLEJO','VLO','1978','MEXICO','NO',1,1,'MEXICO','','',NULL,843),('VILLAHERMOSA','VSA','1979','MEXICO','NO',1,1,'MEXICO','','',NULL,844),('TUXPAN','WIX','1980','MEXICO','NO',1,1,'MEXICO','','',NULL,845),('ALAMOS','XAL','1981','MEXICO','NO',1,1,'MEXICO','','',NULL,846),('ZACATECAS','ZCL','1982','MEXICO','NO',1,1,'MEXICO','','',NULL,847),('IXTAPA/ZIHUATANEJO','ZIH','1983','MEXICO','NO',1,1,'MEXICO','','',NULL,848),('ZAMORA','ZMM','1984','MEXICO','NO',1,1,'MEXICO','','',NULL,849),('GAOMING','GAM','2011','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,850),('GAIXIAN','GXN','2012','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,851),('DAXING','DXG','2013','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,852),('HAI CHENG','HCH','2014','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,853),('HAIYANG','HYG','2015','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,854),('HANZHONG','HZG','2018','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,855),('HANDAN','AND','2017','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,856),('HASTINGS','HSI','2019','NEW ZEALAND','NO',1,1,'F-EAST & OCEANIA','','',NULL,857),('HEFEI','HFE','2020','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,858),('HENGYANG','HNY','2021','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,859),('HUAINAN','HUA','2024','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,860),('HUAIYIN','UIY','2025','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,861),('HUHEHAOTE','HHH','2026','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,862),('HULUDAO','HUD','2027','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,863),('HUIZHOU, AOTOU','HUZ','2028','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,864),('HUZHOU','HZH','2029','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,865),('JIADING','JXD','2030','CHINA','NO',1,1,'F- EAST & OCEANIA','','',NULL,866),('JIANGYIN','JGY','2031','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,867),('JIAMUSI','JMU','2032','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,868),('JIAOXIN','JOX','2033','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,869),('JINAN','TNA','2034','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,870),('JINGHAI','JGI','2035','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,871),('JINHUA','JHA','2036','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,872),('JINZHOU','JNZ','2037','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,873),('JIXI','JXI','2038','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,874),('JURONG','JRG','2039','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,875),('KAIFENG','KIF','2040','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,876),('KAIPING','APG','2041','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,877),('KAIYUAN','KYU','2042','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,878),('KUNMING','KMG','2043','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,879),('LAIYANG','LAY','2044','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,880),('LANZHOU','ZGC','2045','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,881),('LEQING','LQG','2046','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,882),('LIAOYANG','LIY','2047','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,883),('LINAN','LNA','2048','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,884),('LISHUI','LHU','2049','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,885),('LINYUAN','LYU','2050','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,886),('LIUZHOU','LZH','2051','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,887),('LONGKOU','LOG','2052','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,888),('LUOYANG','LYA','2053','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,889),('LUSHUN','SHN','2054','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,890),('MACAU','MFM','2055','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,891),('NANCHANG','KHN','2062','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,892),('NANHUI','NHU','2063','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,893),('NANHAI, SHANSHAN','SXJ','2065','CHINA','NO',0,1,'F-EAST & OCEANIA','','',NULL,894),('NANHAI, NANGANG PING2','NGP','2066','CHINA','NO',0,1,'F-EAST & OCEANIA','','',NULL,895),('MUPING','MUI','2067','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,896),('MUDANJIANG','MDG','2068','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,897),('MAANSHAN','MHN','2069','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,898),('NANSHA','NNH','2070','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,899),('NANYANG','NNY','2071','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,900),('NINGHE','NHG','2072','CHINA','NO',1,1,'F-EAST & OCEANIA','','',NULL,901),('PALMERSTON','PMR','2075','NEW ZEALAND','NO',0,0,'F-EAST & OCEANIA','','',NULL,902),('PANJIN','PNN','2076','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,903),('PANYU, NANSHAN','PYU','2077','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,904),('PANYU, NANWEI','PYU','2078','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,905),('PANYU, DONGFA','PYU','2079','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,906),('PANYU, LIANHUASHAN','LHH','2080','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,907),('PENGLAI','PGL','2081','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,908),('PING GU','PGU','2082','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,909),('PUDONG AIRPORT','PVG','2083','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,910),('QINGXIAN','QGX','2084','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,911),('QINGPU','QNP','2085','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,912),('QIQIHAR','NDG','2086','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,913),('QIXIA','QXA','2087','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,914),('RONGCHENG','RGG','2088','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,915),('RUSHAN','RSH','2089','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,916),('SIPING','SPG','2090','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,917),('SIHUI, MAFANG','IUI','2091','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,918),('SHUNDE, RONGQING','SHD','2092','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,919),('SHUNDE, LELIU','SHD','2093','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,920),('SHUNDE, BEIJIAO','SHD','2094','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,921),('SHUIKOU','UKO','2095','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,922),('SHUIDONG, MAOMING','UDG','2096','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,923),('SHUANGCHENG','SHG','2097','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,924),('SHAOXIN','SHX','2098','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,925),('SHANGYU','SGU','2099','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,926),('TAICANG','TCC','2100','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,927),('TAIZHOU','TZH','2101','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,928),('TAISHANG, GONGYI','GGI','2102','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,929),('TIANJIN DOOR','TSN','2103','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,930),('TIELING','TIL','2104','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,931),('TONGCHUAN','TGC','2105','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,932),('ULAANBAATAR','ULN','2106','MONGOLIA','NO',0,0,'F-EAST & OCEANIA','','',NULL,933),('WANGAQIAO','WGQ','2107','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,934),('WEIFANG','WEF','2108','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,935),('WENDENG','WEN','2109','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,936),('WUHU','WHU','2110','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,937),('WULUMUQI','WUL','2111','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,938),('WUQING','WUQ','2112','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,939),('WUSONG','WSN','2113','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,940),('XI AN','XIY','2114','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,941),('XINZHUANG','XZG','2115','CHINA','NO',0,1,'F-EAST & OCEANIA','','',NULL,942),('YANCHENG','YNZ','2116','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,943),('YANGCUN','YGC','2117','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,944),('YANQING','YQI','2118','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,945),('YIXING','YXG','2119','CHINA','NO',0,2,'F-EAST & OCEANIA','','',NULL,946),('YUN FU, LIUDU','YFL','2120','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,947),('ZHAOQING, SANRONG','ZHQ','2121','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,948),('ZHAOQING, GAOYAO','ZHQ','2122','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,949),('ZHENGZHOU','CGO','2123','CHINA','NO',0,1,'F-EAST & OCEANIA','','',NULL,950),('XIAOLAN, ZHONGGSHAN','ZHO','2124','CHINA','NO',0,0,'F-EAST & OCEANIA','','','CNZHO',951),('ZHUHAI, JIUZHOU','ZUH','2125','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,952),('ZHUHAI, XIANGZHOU','ZUH','2126','CHINA','NO',0,1,'F-EAST & OCEANIA','','',NULL,953),('ZHUHAI, WANZI','ZUH','2127','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,954),('ZHUHAI, DOUMEN','ZUH','2128','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,955),('CUERNAVACA','CVJ','2129','MEXICO','NO',0,0,'MEXICO','','',NULL,956),('COMITAN','CJT','2130','MEXICO','NO',0,0,'MEXICO','','',NULL,957),('HUATULCO/SANTA CRUZ','HUX','2131','MEXICO','NO',0,0,'MEXICO','','',NULL,958),('SAN CRISTOBAL DE LAS CASAS','SZT','2132','MEXICO','NO',0,0,'MEXICO','','',NULL,959),('ZIHUATANEJO/IXTAPA','ZIH','2133','MEXICO','NO',0,2,'MEXICO','','',NULL,960),('ALL DESTINATIONS','TFO','2136','GENERAL','NO',0,0,'GENERAL','','',NULL,961),('CAUCEDO','CAU','2137','DOMINICAN REPUBLIC','NO',0,2,'C&S-AMERICA','','',NULL,962),('CHARLESTOWN','CHT','2138','NEVIS','NO',0,0,'C&S-AMERICA','','',NULL,963),('CHARLOTTE AMALIA','CRA','2139','ST THOMAS','NO',0,0,'C&S-AMERICA','','',NULL,964),('CHRISTIANSTED','CHD','2140','ST CROIX','NO',0,0,'C&S-AMERICA','','',NULL,965),('CRUZ BAY','CZB','2141','ST JOHN USVI','NO',0,0,'C&S-AMERICA','','',NULL,966),('EL GUAMACHE','ELG','2142','VENEZUELA','NO',0,0,'C&S-AMERICA','','',NULL,967),('NASSAU','NAS','2143','BAHAMAS','NO',0,0,'C&S-AMERICA','','',NULL,968),('PLYMOUTH','PMT','2144','MONTSERRAT','NO',0,0,'C&S-AMERICA','','',NULL,969),('POINTE BLANCHE','PTB','2145','ST MAARTEN','NO',0,0,'C&S-AMERICA','','',NULL,970),('PORT-AU-PRINCE','PAP','2146','HAITI','NO',0,0,'C&S-AMERICA','','',NULL,971),('ROADTOWN','RDT','2147','TORTOLA','NO',0,0,'C&S-AMERICA','','',NULL,972),('SABA','SAB','2148','SABA ISLAND','NO',0,0,'C&S-AMERICA','','',NULL,973),('SAINT EUSTATIUS','STE','2149','SAINT EUSTATIUS','NO',0,0,'C&S-AMERICA','','',NULL,974),('THE VALLEY','VAL','2150','ANGUILLA','NO',0,0,'C&S-AMERICA','','',NULL,975),('PORT OF SPAIN','POS','2302','TRINIDAD Y TOBAGO','YES',0,0,'CARIBEAN','','',NULL,976),('ALL ORIGINS','TFO','2152','GENERAL','NO',0,0,'GENERAL','','',NULL,977),('LONGBEACH','LGB','2153','USA','NO',0,0,'N-AMERICA','','',NULL,978),('MIAMI','MIA','2154','USA','NO',0,1,'N-AMERICA','','',NULL,979),('LOS ANGELES','LAX','2155','USA','NO',0,0,'N-AMERICA','','',NULL,980),('HOUSTON','HOU','2156','USA','NO',0,0,'N-AMERICA','','',NULL,981),('EUROPE','TFO','2157','GENERAL','NO',0,0,'EUROPE','','',NULL,982),('F-EAST & OCEANIA','TFO','2158','GENERAL','NO',0,0,'F-EAST & OCEANIA','','',NULL,983),('USA','TFO','2159','USA','NO',0,0,'N-AMERICA','','',NULL,984),('M-EAST & AFRICA','TFO','2160','GENERAL','NO',0,0,'M-EAST & AFRICA','','',NULL,985),('C&S-AMERICA','TFO','2161','GENERAL','NO',0,0,'C&S-AMERICA','','',NULL,986),('VARNA','VAR','2162','BULGARIA','NO',0,0,'EUROPE','','',NULL,987),('VADO LIGURE','VAD','2163','ITALY','NO',0,0,'EUROPE','','',NULL,988),('SHUNDE','SHD','2164','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,989),('TAMPA, FL','TPA','2165','USA','NO',0,0,'N-AMERICA','','',NULL,990),('LA GUANTA','LGU','2166','VENEZUELA','NO',0,0,'C&S-AMERICA','','',NULL,991),('THAMESPORT','THA','2168','INGLATERRA','NO',1,1,'EUROPE','','',NULL,992),('XIANGFAN','XFN','2169','CHINA','NO',0,0,'F-EAST&OCEANIA','','',NULL,993),('HENGSHUI','HSU','2170','CHINA','NO',0,0,'F-EAST&OCEANIA','','',NULL,994),('XINJI','XJI','2171','CHINA','NO',0,0,'F-EAST&OCEANIA','','',NULL,995),('DONGGUAN, STATIAN INTL','DGM','2172','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,996),('DONGGUAN, TAIPINE','DGM','2173','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,997),('DONGGUAN, MACHONG','DGM','2174','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,998),('DONGGUAN, SHATIAN RONGXUAN','DGM','2175','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,999),('DONGGUAN, JIANYUZHOU','DGM','2176','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1000),('HUANGPU, SIGANGAO','HGP','2177','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1001),('HUANGPU, GUANGBAOTONG','HGP','2178','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1002),('HUANGPU, DONGJIANG','HGP','2179','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1003),('HUANGPU, SUIGANG','HGP','2180','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1004),('HUANGPU, WUCHONG','HGP','2181','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1005),('HUANGPU, TONGYANJIU','HGP','2182','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1006),('HUANGPU','HGP','2183','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1007),('DONGGUAN','DGM','2184','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1008),('GUANGZHOU, ZHOUTOUZUI','CAN','2185','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1009),('GUANGZHOU, XINTONG','CAN','2186','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1010),('GUANGZHOU, FANGCUN','CAN','2187','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1011),('GUANGZHOU, HUADU','CAN','2188','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1012),('GUANGZHOU, XINGFENG','CAN','2189','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1013),('FUOSHAN, LANSHI','FUO','2190','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1014),('FUOSHAN, NEW PORT','FUO','2191','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1015),('JIANGMEN, GAOSHA','JMN','2192','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1016),('JIANGMEN, WAIHAI','JMN','2193','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1017),('KAIPING, SANBU','APG','2194','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1018),('KAIPING, SHUIKOU','APG','2195','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1019),('SOUTHAMPTON','SOU','2196','INGLAND','NO',0,1,'EUROPE','','',NULL,1020),('VIRACOPOS','VCP','2201','BRAZIL','NO',0,0,'C&S-AMERICA','','',NULL,1021),('GUARULHOS','GRU','2202','BRAZIL','NO',0,0,'C&S-AMERICA','','',NULL,1022),('CHRISTCHURCH','CHC','2203','NEW ZEALAND','NO',0,0,'F-EAST & OCEANIA','','',NULL,1023),('DONGGUAN, FTT','DGM','2204','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1024),('GUANGZHOU, DONGZHOUW','CAN','2205','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1025),('GUANGZHOU, BAJIANGGANG','CAN','2206','CHINA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1026),('FORT LAUDERDALE','FLL','2207','USA','NO',0,0,'N-AMERICA','','',NULL,1027),('PORT EVERGLADES','PEF','2208','MEXICO','NO',0,0,'','','',NULL,1028),('SENDAI','SDJ','2209','JAPAN','NO',0,0,'F-EAST & OCEANIA','','',NULL,1029),('SATSUMA','STS','2210','JAPAN','NO',0,0,'F-EAST & OCEANIA','','',NULL,1030),('ONAHAMA','ONH','2211','JAPAN','NO',0,0,'F-EAST & OCEANIA','','',NULL,1031),('MIIKE','MII','2212','JAPAN','NO',0,0,'F-EAST & OCEANIA','','',NULL,1032),('KOCHI','KCZ','2213','JAPAN','NO',0,0,'F-EAST & AUSTRALIA','','',NULL,1033),('HESHAN','HSN','2214','CHINA','NO',0,0,'F-EAST & AUSTRALIA','','',NULL,1034),('WAKAMAYA','WKM','2215','JAPAN','NO',0,0,'F-EAST & OCEANIA','','',NULL,1035),('FREEPORT','FPO','2216','USA','NO',0,0,'N-AMERICA','','',NULL,1036),('FUNCHAL','FNC','2217','PORTUGAL','NO',0,0,'EUROPE','','',NULL,1037),('PONTA DELGADA','PDL','2218','PORTUGAL','NO',0,0,'EUROPE','','',NULL,1038),('SAN MIGUEL','SMG','2219','PORTUGAL','NO',0,0,'EUROPE','','',NULL,1039),('SANTA MARIA','SMA','2220','PORTUGAL','NO',0,0,'EUROPE','','',NULL,1040),('TERCEIRA','TCA','2221','PORTUGAL','NO',0,0,'EUROPE','','',NULL,1041),('BELGRADE','BEG','2222','YUGOSLAVIA','NO',0,0,'EUROPE','','',NULL,1042),('KIEV','IEV','2223','UKRAINIA','NO',0,0,'EUROPE','','',NULL,1043),('MULHOUSE','MLH','2224','FRANCE','NO',0,0,'EUROPE','','',NULL,1044),('RIJEKA','RJK','2225','CROATIA','NO',0,0,'EUROPE','','',NULL,1045),('COCO SOLO','COC','2226','PANAMA','NO',0,0,'C&S-AMERICA','','',NULL,1046),('EL DJAZAIR','ELD','2227','ALGERIA','NO',0,0,'M-EAST & AFRICA','','',NULL,1047),('LONGONI','LGN','2228','MAYOTTE(MAHORE)','NO',0,0,'M-EAST & AFRICA','','',NULL,1048),('NEW YORK','NYK','2229','USA','NO',0,0,'N-AMERICA','','',NULL,1049),('MARACAIBO','MAR','2230','VENEZUELA','NO',0,0,'C&S-AMERICA','','',NULL,1050),('ST BARTHELEMY','SBH','2231','GUADALUPE, FRENCH WEST INDIES','NO',0,0,'C&S-AMERICA','','',NULL,1051),('BALTIMORE','BWI','2232','USA','NO',0,0,'N-AMERICA','','',NULL,1052),('CONCEPCION','CCP','2233','CHILE','NO',0,0,'C&S-AMERICA','','',NULL,1053),('CANADA','TFO','2234','CANADA','NO',0,0,'N-AMERICA','','',NULL,1054),('DIRECT','TFO','2235','GENERAL','NO',0,0,'GENERAL','','',NULL,1055),('MADEIRA','FNC','2236','PORTUGAL','NO',0,0,'EUROPE','','',NULL,1056),('GENEVE(VILLENEUVE)','GVA','2237','SWITZERLAND','NO',0,0,'EUROPE','','',NULL,1057),('LA CHAUX DE FONDS','LCX','2238','SWITZERLAND','NO',0,0,'EUROPE','','',NULL,1058),('PROGRESO','PRG','2239','MEXICO','NO',0,0,'MEXICO','','','',1059),('GIOIA TAURO','GIT','2240','ITALY','NO',0,0,'EUROPE','','',NULL,1060),('VARIOUS','TFO','2241','GENERAL','NO',0,0,'GENERAL','','',NULL,1061),('HUANGZHOU','HGH','2242','CHINA','NO',0,0,'ASIA','','',NULL,1062),('EVERGLADES','EV9','2243','USA','NO',0,1,'N-AMERICA','','',NULL,1063),('ATLANTA','ATL','2244','USA','NO',0,0,'N-AMERICA','','',NULL,1064),('KANSAS CITY','MCI','2245','USA','NO',0,0,'N-AMERICA','','',NULL,1065),('ZARATE','ZRE','2246','ARGENTINA','NO',0,0,'C&S-AMERICA','','',NULL,1066),('TORONTO','YYZ','2247','CANADA','NO',0,0,'N-AMERICA','','',NULL,1067),('MONTREAL','YMX','2248','CANADA','NO',0,0,'N-AMERICA','','',NULL,1068),('BIRR','BIR','2249','SWITZERLAND','NO',0,0,'EUROPE','','',NULL,1069),('BOSTON','BOS','2250','USA','NO',0,0,'N-AMERICA','','',NULL,1070),('SINES','SNS','2251','PORTUGAL','NO',0,0,'EUROPE','','',NULL,1071),('SEATTLE','SEA','2252','USA','NO',0,0,'N-AMERICA','','',NULL,1072),('CHICAGO','ORD','2253','USA','NO',0,0,'N-AMERICA','','',NULL,1073),('HAVANA','HAV','2254','CUBA','NO',0,0,'C&S-AMERICA','','',NULL,1074),('MONTEGO (BAY)','MBJ','2255','JAMAICA','NO',0,1,'C&S. AMERICA','','',NULL,1075),('CANTON','CAK','2256','CHINA','NO',0,1,'F-EAST & OCEANIA','','',NULL,1076),('GUADALOUPE','GPE','2257','FRENCH WEST INDIES','NO',0,1,'C&S-AMERICA','','',NULL,1077),('AZORES','AZS','2258','PORTUGAL','NO',0,1,'EUROPE','','',NULL,1078),('PORTO','OPO','2259','PORTUGAL','NO',0,1,'EUROPE','','',NULL,1079),('PALMA DE GRAN C.','PGC','2260','SPAIN','NO',0,1,'EUROPE','','',NULL,1080),('MAURITIUS','MRU','2261','MAURITIUS','NO',0,1,'M-EAST & AFRICA','','',NULL,1081),('SIX OF OCTOBER','SOT','2262','EGYPT','NO',0,1,'M-EAST & AFRICA','','',NULL,1082),('CAPITAL AIRPORT','PEK','2263','CHINA','NO',0,1,'F-EAST & OCEANIA','','',NULL,1083),('SANTO PEKOA INT\'L','SON','2264','VANUATU','NO',0,1,'F-EAST & OCEANIA','','',NULL,1084),('PUERTO PROGRESO','PPG','2266','MEXICO','NO',0,1,'MEXICO','','','MXPGO',1085),('HONOLULU','HNL','2267','USA','NO',0,1,'N-AMERICA','','',NULL,1086),('LOS ANGELES, CA','ANG','2268','ESTADOS UNIDOS','NO',0,1,'ESTADOS UNIDOS','','',NULL,1087),('GENOVA','312','2269','-','NO',0,0,'-','','',NULL,1088),('OAKLAND','OAK','2271','ESTADOS UNIDOS','NO',0,1,'CALIFORNIA','','',NULL,1089),('KUALA LUMPUR','KUL','2272','MALAYSIA','NO',0,0,'F-EAST & OCEANIA','','',NULL,1090),('BILLUND','BLL','2273','DENMARK','NO',0,1,'EUROPE','','',NULL,1091),('CHIWAN','CHI','2274','CHINA','NO',0,1,'F-EAST & OCEANIA','','',NULL,1092),('SAIGON','SGN','2275','VIETNAM','NO',0,100,'F-EAST & OCEANIA','','',NULL,1093),('PUERTO MORELOS','PTM','2276','MEXICO','NO',0,1,'QUITANA ROO','','','MXPMS',1094),('NO ESPECIFICADO','NNN','2277','NO ESPECIFICADO','NO',0,1,'NO ESPECIFICADO','','',NULL,1095),('SAVANNAH,GA','SAV','2278','ESTADOS UNIDOS','NO',0,1,'GEORGIA','','',NULL,1096),('CHARLESTON','CHA','2279','CALIFORNIA','NO',0,1,'USA','','',NULL,1097),('BELFAST','BFS','2280','IRELAND REP.','NO',0,1,'EUROPE','','',NULL,1098),('CORK','ORK','2281','IRELAND REP.','NO',0,1,'EUROPE','','',NULL,1099),('HORTA/FAIAL-AZORES','HOR','2282','PORTUGAL','NO',0,1,'EUROPE','','',NULL,1100),('LIMERICK','LMK','2283','IRELAND REP.','NO',0,1,'EUROPE','','',NULL,1101),('SANTA CRUZ  DE FLORES/AZORES','PRT','2284','PORTUGAL','NO',0,1,'EUROPE','','',NULL,1102),('SARAJEVO','SJJ','2285','BOSNIA & HERZEGOVIA','NO',0,1,'EUROPE','','',NULL,1103),('SHANNON','SNN','2286','IRELAND REP.','NO',0,1,'EUROPE','','',NULL,1104),('SKOPJE','SPJ','2287','MACEDONIA','NO',0,1,'EUROPE','','',NULL,1105),('HALIFAX','HLX','2288','CANADA','NO',0,1,'N-AMERICA','','',NULL,1106),('QUEBEC','YQB','2289','CANADA','NO',0,1,'N-AMERICA','','',NULL,1107),('ROSARIO','ROS','2290','ARGENTINA','NO',0,1,'C&S-AMERICA','','',NULL,1108),('SAINT JOHN','YSJ','2291','CANADA','NO',0,1,'N-AMERICA','','',NULL,1109),('VANCOUVER','YVR','2292','CANADA','NO',0,1,'N-AMERICA','','',NULL,1110),('KOSAKOV','KKV','2293','RUSSIA','NO',0,1,'EUROPE','','',NULL,1111),('NORFOLK, VA','NOR','2294','ESTADOS UNIDOS','NO',0,0,'AMERICA','','',NULL,1112),('SIN REGISTRO','222','2295','2','NO',0,2,'2','','',NULL,1113),('ANTWERPEN','ANR','','','',1,1,'','BE','ANR',NULL,1114),('BUSAN (EX PUSAN)','KRPUS','','KOREA','YES',1,1,'ASIA','KR','PUS',NULL,1115),('MEXICO ','MEX','2304','MEXICO','NO',0,0,'MEXICO','','',NULL,1116),('NHAVA SHEVA (JAWAHARLAL NEHRU)','INNSA','','asia','yes',1,1,'asia','IN','NSA','',1117),('GENOA','ITGOA','','IT','yes',1,1,'europa','IT','GOA','ITGOA',1118),('HAIPHONG','HPH','2299','VIETNAM','YES',0,0,'FAR EAST','','',NULL,1119),('LAEM CHABANG','LCB','2301','THAILANDIA','NO',0,1,'ASIA','','',NULL,1120),('SAN FELIPE','SFH','1955','MEXICO','YES',0,1,'MEXICO','MX','SFH','',1121),('VISAKHAPATNAM','VTZ','6','INDIA','NO',0,1,'ASIA','','','INVTZ',1122),('XIAOLAN, GUANGDONG','XAO','2124','CHINA','NO',0,0,'F-EAST & OCEANIA','','','CNXAO',1123),('LIRQUEN','LQN','2176','CHILE','NO',0,0,'AMERICA','','CLLQN',NULL,1124),('DA CHAN BAY','DCB','506','CHINA','NO',1,1,'F-EAST & OCEANIA','','','CNDCB',1125),('FOS SUR MER','FOS','1986','FRANCE','NO',0,1,'EUROPE','','',NULL,1126),('GENOVA','312','2305','ITALIA','NO',0,0,'-','','',NULL,1127),('GENOA','312','2306','ITALY','NO',0,0,'-','','',NULL,1128),('SURAT','STV','2307','INDIA','NO',0,0,'ASIA','','','INSTV',1129),('HALDIA','HAL','2308','INDIA','NO',0,0,'ASIA','','','INHAL',1130),('MUNDRA','MUN','2309','INDIA','NO',0,0,'ASIA','','','INMUM',1131),('PT EVERGLADES','PEF','','USA','',1,1,'N-AMERICA','','',NULL,1132),('WILHELMSHAVEN','WIL','2310','GERMANY','NO',1,1,'EUROPE','','',NULL,1133);
/*!40000 ALTER TABLE `iataexpint` 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 20:23:09
