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