 INSERT INTO located VALUES ('Puerto Plata','Dominican Republic','DOM',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('San Juan','Puerto Rico','PR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Ponce','Puerto Rico','PR',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Carolina','Puerto Rico','PR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Charlotte Amalie','Virgin Islands','VIRG',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Road Town','British Virgin Islands','BVI',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('The Valley','Anguilla','AXA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Marigot','Saint Martin','SMAR',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Philipsburg','Sint Maarten','SX',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Gustavia','Saint Barthelemy','SBAR',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Basseterre','Saint Kitts and Nevis','KN',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('St. John''s','Antigua and Barbuda','AG',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Plymouth','Montserrat','MNTS',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Brades','Montserrat','MNTS',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Basse-Terre','Guadeloupe','GP',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Roseau','Dominica','WD',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Fort-de-France','Martinique','MQ',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Castries','Saint Lucia','WL',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Bridgetown','Barbados','BDS',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Kingstown','Saint Vincent and the Grenadines','WV',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Saint George''s','Grenada','WG',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Port-of-Spain','Trinidad and Tobago','TT',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Kralendijk','Bonaire','NLB',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Willemstad','Curacao','CUR',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Oranjestad','Aruba','ARU',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Puerto Ayacucho','Amazonas','YV','Orinoco',NULL,NULL);
 INSERT INTO located VALUES ('Barcelona','Anzoátegui','YV',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Puerto La Cruz','Anzoátegui','YV',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('San Fernando','Apure','YV','Apure',NULL,NULL);
 INSERT INTO located VALUES ('Ciudad Bolívar','Bolívar','YV','Orinoco',NULL,NULL);
 INSERT INTO located VALUES ('Ciudad Guayana','Bolívar','YV','Orinoco',NULL,NULL);
 INSERT INTO located VALUES ('Puerto Cabello','Carabobo','YV',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Tucupita','Delta Amacuro','YV','Orinoco',NULL,NULL);
 INSERT INTO located VALUES ('Santa Ana de Coro','Falcón','YV',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Cumaná','Sucre','YV',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Maracaibo','Zulia','YV',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Maracaibo','Zulia','YV',NULL,NULL,'Lago de Maracaibo');
 INSERT INTO located VALUES ('Cabimas','Zulia','YV',NULL,NULL,'Lago de Maracaibo');
 INSERT INTO located VALUES ('La Guaira','Vargas','YV',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Catia La Mar','Vargas','YV',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Georgetown','Guyana','GUY',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Paramaribo','Suriname','SME','Suriname',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Cayenne','French Guiana','GF',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Leticia','Amazonas','CO','Amazonas',NULL,NULL);
 INSERT INTO located VALUES ('Arauca','Arauca','CO','Arauca',NULL,NULL);
 INSERT INTO located VALUES ('Cartagena','Bolívar','CO',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Magangué','Bolívar','CO','Rio Magdalena',NULL,NULL);
 INSERT INTO located VALUES ('Popayán','Cauca','CO','Rio Cauca',NULL,NULL);
 INSERT INTO located VALUES ('Soacha','Cundinamarca','CO','Rio Bogota',NULL,NULL);
 INSERT INTO located VALUES ('Riohacha','La Guajira','CO',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('San Jose del Guaviare','Guaviare','CO','Rio Guaviare',NULL,NULL);
 INSERT INTO located VALUES ('Neiva','Huila','CO','Rio Magdalena',NULL,NULL);
 INSERT INTO located VALUES ('Santa Marta','Magdalena','CO',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Ciénaga','Magdalena','CO',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('San Andres','San Andrés, Providencia y Santa Catalina','CO',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Bogotá','Bogotá Distrito Especial','CO','Rio Bogota',NULL,NULL);
 INSERT INTO located VALUES ('Barrancabermeja','Santander','CO','Rio Magdalena',NULL,NULL);
 INSERT INTO located VALUES ('Cali','Valle de Cauca','CO','Rio Cauca',NULL,NULL);
 INSERT INTO located VALUES ('Buenaventura','Valle de Cauca','CO',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Tuluá','Valle de Cauca','CO','Rio Cauca',NULL,NULL);
 INSERT INTO located VALUES ('Cartago','Valle de Cauca','CO','Rio Cauca',NULL,NULL);
 INSERT INTO located VALUES ('Puerto Carreno','Vichada','CO','Orinoco',NULL,NULL);
 INSERT INTO located VALUES ('Puerto Carreno','Vichada','CO','Rio Meta',NULL,NULL);
 INSERT INTO located VALUES ('Guayaquil','Ecuador','EC','Rio Guayas',NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Chimbote','Ancash','PE',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Callao','Callao','PE',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Huánuco','Huánuco','PE','Huallaga',NULL,NULL);
 INSERT INTO located VALUES ('Huancayo','Junín','PE','Mantaro',NULL,NULL);
 INSERT INTO located VALUES ('Trujillo','La Libertad','PE',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Chiclayo','Lambayeque','PE',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Lima','Lima City','PE',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Iquitos','Loreto','PE','Amazonas',NULL,NULL);
 INSERT INTO located VALUES ('Puerto Maldonado','Madre de Dios','PE','Rio Madre de Dios',NULL,NULL);
 INSERT INTO located VALUES ('Talara','Piura','PE',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Tumbes','Tumbes','PE',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Pucallpa','Ucayali','PE','Ucayali',NULL,NULL);
 INSERT INTO located VALUES ('Cobija','Pando','BOL','Acre',NULL,NULL);
 INSERT INTO located VALUES ('Iquique','Tarapacá','RCH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Antofagasta','Antofagasta','RCH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('La Serena','Coquimbo','RCH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Valparaíso','Valparaíso','RCH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Concepción','Bío-Bío','RCH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Puerto Montt','Lagos','RCH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Punta Arenas','Magallanes','RCH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Valdivia','Ríos','RCH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Arica','Arica y Parinacota','RCH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('La Plata','Buenos Aires','RA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Mar del Plata','Buenos Aires','RA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('San Isidro','Buenos Aires','RA','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Bahía Blanca','Buenos Aires','RA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Resistencia','Chaco','RA','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Comodoro Rivadavia','Chubut','RA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Rawson','Chubut','RA','Río Chubut',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Corrientes','Corrientes','RA','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Paraná','Entre Ríos','RA','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Concordia','Entre Ríos','RA','Uruguay',NULL,NULL);
 INSERT INTO located VALUES ('Formosa','Formosa','RA','Paraguay',NULL,NULL);
 INSERT INTO located VALUES ('Posadas','Misiones','RA','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Neuquén','Neuquén','RA','Río Neuquen',NULL,NULL);
 INSERT INTO located VALUES ('Neuquén','Neuquén','RA','Río Limay',NULL,NULL);
 INSERT INTO located VALUES ('Viedma','Río Negro','RA','Río Neuquen',NULL,NULL);
 INSERT INTO located VALUES ('Bariloche','Río Negro','RA',NULL,NULL,NULL);
 INSERT INTO located VALUES ('Río Gallegos','Santa Cruz','RA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Santa Fe','Santa Fe','RA','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Rosario','Santa Fe','RA','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Santiago del Estero','Santiago de Estero','RA','Río Sali',NULL,NULL);
 INSERT INTO located VALUES ('Ushuaia','Tierra del Fuego','RA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('San Miguel de Tucumán','Tucumán','RA','Río Sali',NULL,NULL);
 INSERT INTO located VALUES ('Buenos Aires','Distrito Federal','RA','Parana',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Asunción','Paraguay','PY','Paraguay',NULL,NULL);
 INSERT INTO located VALUES ('Ciudad del Este','Paraguay','PY','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Montevideo','Uruguay','ROU',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Salto','Uruguay','ROU','Uruguay',NULL,NULL);
 INSERT INTO located VALUES ('Rio Branco','Acre','BR','Acre',NULL,NULL);
 INSERT INTO located VALUES ('Maceió','Alagoas','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Macapá','Amapá','BR','Amazonas',NULL,NULL);
 INSERT INTO located VALUES ('Manaus','Amazonas','BR','Amazonas',NULL,NULL);
 INSERT INTO located VALUES ('Manaus','Amazonas','BR','Rio Negro',NULL,NULL);
 INSERT INTO located VALUES ('Salvador','Bahia','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Ilhéus','Bahia','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Juazeiro','Bahia','BR','Rio Sao Francisco',NULL,NULL);
 INSERT INTO located VALUES ('Camaçari','Bahia','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Lauro de Freitas','Bahia','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Porto Seguro','Bahia','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Fortaleza','Ceará','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Vitória','Espírito Santo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Vila Velha','Espírito Santo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Serra','Espírito Santo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('São Luís','Maranhão','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Imperatriz','Maranhão','BR','Tocantins',NULL,NULL);
 INSERT INTO located VALUES ('Cuiabá','Mato Grosso','BR','Rio Cuiabá',NULL,NULL);
 INSERT INTO located VALUES ('Belém','Pará','BR','Tocantins',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Santarém','Pará','BR','Amazonas',NULL,NULL);
 INSERT INTO located VALUES ('Santarém','Pará','BR','Tapajós',NULL,NULL);
 INSERT INTO located VALUES ('Marabá','Pará','BR','Tocantins',NULL,NULL);
 INSERT INTO located VALUES ('João Pessoa','Paraíba','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Curitiba','Paraná','BR','Iguacu',NULL,NULL);
 INSERT INTO located VALUES ('Foz do Iguaçu','Paraná','BR','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Foz do Iguaçu','Paraná','BR','Iguacu',NULL,NULL);
 INSERT INTO located VALUES ('Paranaguá','Paraná','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Recife','Pernambuco','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Petrolina','Pernambuco','BR','Rio Sao Francisco',NULL,NULL);
 INSERT INTO located VALUES ('Teresina','Piauí','BR','Rio Parnaiba',NULL,NULL);
 INSERT INTO located VALUES ('Parnaíba','Piauí','BR','Rio Parnaiba',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Rio de Janeiro','Rio de Janeiro','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('São Gonçalo','Rio de Janeiro','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Duque de Caxias','Rio de Janeiro','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Niterói','Rio de Janeiro','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Campos dos Goytacazes','Rio de Janeiro','BR','Rio Paraiba do Sul',NULL,NULL);
 INSERT INTO located VALUES ('Volta Redonda','Rio de Janeiro','BR','Rio Paraiba do Sul',NULL,NULL);
 INSERT INTO located VALUES ('Magé','Rio de Janeiro','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Itaboraí','Rio de Janeiro','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Macaé','Rio de Janeiro','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Cabo Frio','Rio de Janeiro','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Barra Mansa','Rio de Janeiro','BR','Rio Paraiba do Sul',NULL,NULL);
 INSERT INTO located VALUES ('Angra dos Reis','Rio de Janeiro','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Natal','Rio Grande do Norte','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Parnamirim','Rio Grande do Norte','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Porto Alegre','Rio Grande do Sul','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Rio Grande','Rio Grande do Sul','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Uruguaiana','Rio Grande do Sul','BR','Uruguay',NULL,NULL);
 INSERT INTO located VALUES ('Porto Velho','Rondônia','BR','Rio Madeira',NULL,NULL);
 INSERT INTO located VALUES ('Florianópolis','Santa Catarina','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('São José','Santa Catarina','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Itajaí','Santa Catarina','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('São Paulo','São Paulo','BR','Tiete',NULL,NULL);
 INSERT INTO located VALUES ('Osasco','São Paulo','BR','Tiete',NULL,NULL);
 INSERT INTO located VALUES ('Guarulhos','São Paulo','BR','Tiete',NULL,NULL);
 INSERT INTO located VALUES ('Itaquaquecetuba','São Paulo','BR','Tiete',NULL,NULL);
 INSERT INTO located VALUES ('São José dos Campos','São Paulo','BR','Rio Paraiba do Sul',NULL,NULL);
 INSERT INTO located VALUES ('Santos','São Paulo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Mogi das Cruzes','São Paulo','BR','Tiete',NULL,NULL);
 INSERT INTO located VALUES ('São Vicente','São Paulo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Guarujá','São Paulo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Taubaté','São Paulo','BR','Rio Paraiba do Sul',NULL,NULL);
 INSERT INTO located VALUES ('Suzano','São Paulo','BR','Tiete',NULL,NULL);
 INSERT INTO located VALUES ('Barueri','São Paulo','BR','Tiete',NULL,NULL);
 INSERT INTO located VALUES ('Jacareí','São Paulo','BR','Rio Paraiba do Sul',NULL,NULL);
 INSERT INTO located VALUES ('Pindamonhangaba','São Paulo','BR','Rio Paraiba do Sul',NULL,NULL);
 INSERT INTO located VALUES ('Praia Grande','São Paulo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Aracaju','Sergipe','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Palmas','Tocantins','BR','Tocantins',NULL,NULL);
 INSERT INTO located VALUES ('Stanley','Falkland Islands','FALK',NULL,NULL,'Atlantic Ocean');
 INSERT INTO locatedOn VALUES ('Kerkyra','Ionion Nison','GR','Korfu');
 INSERT INTO locatedOn VALUES ('Iraklio','Kritis','GR','Crete');
 INSERT INTO locatedOn VALUES ('Chania','Kritis','GR','Crete');
 INSERT INTO locatedOn VALUES ('Ermoupoli','Notioy Aigaioy','GR','Syros');
 INSERT INTO locatedOn VALUES ('Rhodes','Notioy Aigaioy','GR','Rhodos');
 INSERT INTO locatedOn VALUES ('Chalkida','Stereas Elladas','GR','Euboea');
 INSERT INTO locatedOn VALUES ('Mytilini','Boreioy Aigaioy','GR','Lesbos');
 INSERT INTO locatedOn VALUES ('Nicosia','Cyprus','CY','Cyprus');
 INSERT INTO locatedOn VALUES ('Larnaka','Cyprus','CY','Cyprus');
 INSERT INTO locatedOn VALUES ('Lemesos','Cyprus','CY','Cyprus');
 INSERT INTO locatedOn VALUES ('Episkopi Cantonment','Akrotiri and Dhekelia','AD','Cyprus');
 INSERT INTO locatedOn VALUES ('Ajaccio','Corse','F','Corse');
 INSERT INTO locatedOn VALUES ('Palma de Mallorca','Illes Balears','E','Mallorca');
 INSERT INTO locatedOn VALUES ('Santa Cruz de Tenerife','Canarias','E','Teneriffa');
 INSERT INTO locatedOn VALUES ('San Cristóbal de La Laguna','Canarias','E','Teneriffa');
 INSERT INTO locatedOn VALUES ('Las Palmas de Gran Canaria','Canarias','E','Gran Canaria');
 INSERT INTO locatedOn VALUES ('Telde','Canarias','E','Gran Canaria');
 INSERT INTO locatedOn VALUES ('Palermo','Sicilia','I','Sicilia');
 INSERT INTO locatedOn VALUES ('Messina','Sicilia','I','Sicilia');
 INSERT INTO locatedOn VALUES ('Catánia','Sicilia','I','Sicilia');
 INSERT INTO locatedOn VALUES ('Siracusa','Sicilia','I','Sicilia');
 INSERT INTO locatedOn VALUES ('Cágliari','Sardegna','I','Sardegna');
 INSERT INTO locatedOn VALUES ('Sássari','Sardegna','I','Sardegna');
 INSERT INTO locatedOn VALUES ('Južno-Sachalinsk','Sakhalin','R','Sachalin');
 INSERT INTO locatedOn VALUES ('Odense','Syddanmark','DK','Fünen');
 INSERT INTO locatedOn VALUES ('Hillerød','Hovedstaden','DK','Seeland');
 INSERT INTO locatedOn VALUES ('Copenhagen','Hovedstaden','DK','Seeland');
 INSERT INTO locatedOn VALUES ('Helsingør','Hovedstaden','DK','Seeland');
 INSERT INTO locatedOn VALUES ('Ronne','Hovedstaden','DK','Bornholm');
 INSERT INTO locatedOn VALUES ('Sorø','Sjælland','DK','Seeland');
 INSERT INTO locatedOn VALUES ('Reykjavik','Iceland','IS','Iceland');
 INSERT INTO locatedOn VALUES ('Keflavik','Iceland','IS','Iceland');
 INSERT INTO locatedOn VALUES ('Akureyri','Iceland','IS','Iceland');
 INSERT INTO locatedOn VALUES ('Tórshavn','Faroe Islands','FO','Streymoy');
 INSERT INTO locatedOn VALUES ('Dublin','Leinster','IRL','Ireland');
 INSERT INTO locatedOn VALUES ('Cork','Munster','IRL','Ireland');
 INSERT INTO locatedOn VALUES ('Limerick','Munster','IRL','Ireland');
 INSERT INTO locatedOn VALUES ('Galway','Connacht','IRL','Ireland');
 INSERT INTO locatedOn VALUES ('Letterkenny','Ulster','IRL','Ireland');
 INSERT INTO locatedOn VALUES ('Valletta','Malta','M','Malta');
 INSERT INTO locatedOn VALUES ('Victoria','Malta','M','Gozo');
 INSERT INTO locatedOn VALUES ('Douglas','Isle of Man','GBM','Isle of Man');
 INSERT INTO locatedOn VALUES ('Ponta Delgada','Azores','P','Sao Miguel');
 INSERT INTO locatedOn VALUES ('Funchal','Madeira','P','Madeira');
 INSERT INTO locatedOn VALUES ('Longyearbyen','Svalbard','SVA','Svalbard');
 INSERT INTO locatedOn VALUES ('Newcastle upon Tyne','North East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Sunderland','North East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Gateshead','North East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Middlesbrough','North East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Manchester','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Sale','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Wigan','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Stockport','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bolton','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Salford','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Oldham','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Rochdale','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Warrington','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Blackpool','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Blackburn','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Liverpool','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Birkenhead','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('St Helens','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Preston','North West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Leeds','Yorkshire and the Humber','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Wakefield','Yorkshire and the Humber','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bradford','Yorkshire and the Humber','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Huddersfield','Yorkshire and the Humber','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Sheffield','Yorkshire and the Humber','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Doncaster','Yorkshire and the Humber','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Rotherham','Yorkshire and the Humber','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('York','Yorkshire and the Humber','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Kingston upon Hull','Yorkshire and the Humber','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Nottingham','East Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Northampton','East Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Leicester','East Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Derby','East Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Lincoln','East Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Birmingham','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Coventry','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Wolverhampton','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Solihull','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Stoke-on-Trent','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Worcester','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Sutton Coldfield','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Telford','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Cambridge','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Peterborough','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Ipswich','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Chelmsford','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Watford','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Southend-on-Sea','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Basildon','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Colchester','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Norwich','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Luton','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Hemel Hempstead','East of England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('London','London','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Southampton','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Portsmouth','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Basingstoke','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Milton Keynes','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('High Wycombe','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Brighton and Hove','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Maidstone','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Oxford','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Reading','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Slough','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Eastbourne','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Gillingham','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Crawley','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Worthing','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Woking','South East England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bristol','South West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bath','South West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Plymouth','South West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Exeter','South West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bournemouth','South West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Poole','South West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Cheltenham','South West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Gloucester','South West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Swindon','South West England','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Edinburgh','Scotland','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Glasgow','Scotland','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Aberdeen','Scotland','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Dundee','Scotland','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Kirkwall','Scotland','GB','Orkney Mainland');
 INSERT INTO locatedOn VALUES ('Lerwick','Scotland','GB','Shetland Mainland');
 INSERT INTO locatedOn VALUES ('Cardiff','Wales','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Swansea','Wales','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Newport','Wales','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Belfast','Northern Ireland','GB','Ireland');
 INSERT INTO locatedOn VALUES ('Saint Peter Port','Guernsey','GBG','Guernsey');
 INSERT INTO locatedOn VALUES ('Saint Helier','Jersey','GBJ','Jersey');
 INSERT INTO locatedOn VALUES ('Al Manāmah','Bahrain','BRN','Bahrain');
 INSERT INTO locatedOn VALUES ('Male','Maldives','MV','Male');
 INSERT INTO locatedOn VALUES ('Mumbai','Maharashtra','IND','Salsette');
 INSERT INTO locatedOn VALUES ('Thane','Maharashtra','IND','Salsette');
 INSERT INTO locatedOn VALUES ('Port Blair','Andaman and Nicobar Islands','IND','South Andaman Island');
 INSERT INTO locatedOn VALUES ('Kavaratti','Lakshadweep','IND','Kavaratti');
 INSERT INTO locatedOn VALUES ('Sri Jayawardhanapura','Sri Lanka','CL','Sri Lanka');
 INSERT INTO locatedOn VALUES ('Colombo','Sri Lanka','CL','Sri Lanka');
 INSERT INTO locatedOn VALUES ('Xiamen','Fujian','CN','Xiamen');
 INSERT INTO locatedOn VALUES ('Haikou','Hainan','CN','Hainan');
 INSERT INTO locatedOn VALUES ('Sanya','Hainan','CN','Hainan');
 INSERT INTO locatedOn VALUES ('Zhoushan','Zhejiang','CN','Zhoushan');
 INSERT INTO locatedOn VALUES ('Taipei','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('New Taipei','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Taoyuan','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Jhongli','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Keelung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Hsinchu','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Taichung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Changhua','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Hualien','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Chiayi','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Tainan','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Pingtung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Kaohsiung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Taitung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Taipa-Coloane','Macau','MAC','Taipa');
 INSERT INTO locatedOn VALUES ('Taipa-Coloane','Macau','MAC','Coloane');
 INSERT INTO locatedOn VALUES ('Jeju','South Korea','ROK','Jeju');
 INSERT INTO locatedOn VALUES ('Sapporo','Hokkaido','J','Hokkaido');
 INSERT INTO locatedOn VALUES ('Asahikawa','Hokkaido','J','Hokkaido');
 INSERT INTO locatedOn VALUES ('Hakodate','Hokkaido','J','Hokkaido');
 INSERT INTO locatedOn VALUES ('Kushiro','Hokkaido','J','Hokkaido');
 INSERT INTO locatedOn VALUES ('Aomori','Aomori','J','Honshu');
 INSERT INTO locatedOn VALUES ('Morioka','Iwate','J','Honshu');
 INSERT INTO locatedOn VALUES ('Sendai','Miyagi','J','Honshu');
 INSERT INTO locatedOn VALUES ('Akita','Akita','J','Honshu');
 INSERT INTO locatedOn VALUES ('Yamagata','Yamagata','J','Honshu');
 INSERT INTO locatedOn VALUES ('Fukushima','Fukushima','J','Honshu');
 INSERT INTO locatedOn VALUES ('Mito','Ibaraki','J','Honshu');
 INSERT INTO locatedOn VALUES ('Utsunomiya','Tochigi','J','Honshu');
 INSERT INTO locatedOn VALUES ('Maebashi','Gumma','J','Honshu');
 INSERT INTO locatedOn VALUES ('Saitama','Saitama','J','Honshu');
 INSERT INTO locatedOn VALUES ('Kawaguchi','Saitama','J','Honshu');
 INSERT INTO locatedOn VALUES ('Chiba','Chiba','J','Honshu');
 INSERT INTO locatedOn VALUES ('Funabashi','Chiba','J','Honshu');
 INSERT INTO locatedOn VALUES ('Matsudo','Chiba','J','Honshu');
 INSERT INTO locatedOn VALUES ('Ichikawa','Chiba','J','Honshu');
 INSERT INTO locatedOn VALUES ('Kashiwa','Chiba','J','Honshu');
 INSERT INTO locatedOn VALUES ('Tokyo','Tokyo','J','Honshu');
 INSERT INTO locatedOn VALUES ('Hachioji','Tokyo','J','Honshu');
 INSERT INTO locatedOn VALUES ('Machida','Tokyo','J','Honshu');
 INSERT INTO locatedOn VALUES ('Yokohama','Kanagawa','J','Honshu');
 INSERT INTO locatedOn VALUES ('Kawasaki','Kanagawa','J','Honshu');
 INSERT INTO locatedOn VALUES ('Sagamihara','Kanagawa','J','Honshu');
 INSERT INTO locatedOn VALUES ('Yokosuka','Kanagawa','J','Honshu');
 INSERT INTO locatedOn VALUES ('Fujisawa','Kanagawa','J','Honshu');
 INSERT INTO locatedOn VALUES ('Niigata','Niigata','J','Honshu');
 INSERT INTO locatedOn VALUES ('Toyama','Toyama','J','Honshu');
 INSERT INTO locatedOn VALUES ('Kanazawa','Ishikawa','J','Honshu');
 INSERT INTO locatedOn VALUES ('Fukui','Fukui','J','Honshu');
 INSERT INTO locatedOn VALUES ('Kofu','Yamanashi','J','Honshu');
 INSERT INTO locatedOn VALUES ('Nagano','Nagano','J','Honshu');
 INSERT INTO locatedOn VALUES ('Gifu','Gifu','J','Honshu');
 INSERT INTO locatedOn VALUES ('Shizuoka','Shizuoka','J','Honshu');
 INSERT INTO locatedOn VALUES ('Hamamatsu','Shizuoka','J','Honshu');
 INSERT INTO locatedOn VALUES ('Nagoya','Aichi','J','Honshu');
 INSERT INTO locatedOn VALUES ('Toyota','Aichi','J','Honshu');
 INSERT INTO locatedOn VALUES ('Tsu','Mie','J','Honshu');
 INSERT INTO locatedOn VALUES ('Otsu','Shiga','J','Honshu');
 INSERT INTO locatedOn VALUES ('Kyoto','Kyoto','J','Honshu');
 INSERT INTO locatedOn VALUES ('Osaka','Osaka','J','Honshu');
 INSERT INTO locatedOn VALUES ('Sakai','Osaka','J','Honshu');
 INSERT INTO locatedOn VALUES ('Higashiosaka','Osaka','J','Honshu');
 INSERT INTO locatedOn VALUES ('Hirakata','Osaka','J','Honshu');
 INSERT INTO locatedOn VALUES ('Kobe','Hyogo','J','Honshu');
 INSERT INTO locatedOn VALUES ('Himeji','Hyogo','J','Honshu');
 INSERT INTO locatedOn VALUES ('Nishinomiya','Hyogo','J','Honshu');
 INSERT INTO locatedOn VALUES ('Amagasaki','Hyogo','J','Honshu');
 INSERT INTO locatedOn VALUES ('Nara','Nara','J','Honshu');
 INSERT INTO locatedOn VALUES ('Wakayama','Wakayama','J','Honshu');
 INSERT INTO locatedOn VALUES ('Tottori','Tottori','J','Honshu');
 INSERT INTO locatedOn VALUES ('Matsue','Shimane','J','Honshu');
 INSERT INTO locatedOn VALUES ('Okayama','Okayama','J','Honshu');
 INSERT INTO locatedOn VALUES ('Kurashiki','Okayama','J','Honshu');
 INSERT INTO locatedOn VALUES ('Hiroshima','Hiroshima','J','Honshu');
 INSERT INTO locatedOn VALUES ('Fukuyama','Hiroshima','J','Honshu');
 INSERT INTO locatedOn VALUES ('Yamaguchi','Yamaguchi','J','Honshu');
 INSERT INTO locatedOn VALUES ('Tokushima','Tokushima','J','Shikoku');
 INSERT INTO locatedOn VALUES ('Takamatsu','Kagawa','J','Shikoku');
 INSERT INTO locatedOn VALUES ('Matsuyama','Ehime','J','Shikoku');
 INSERT INTO locatedOn VALUES ('Kochi','Kochi','J','Shikoku');
 INSERT INTO locatedOn VALUES ('Fukuoka','Fukuoka','J','Kyushu');
 INSERT INTO locatedOn VALUES ('Kitakyushu','Fukuoka','J','Kyushu');
 INSERT INTO locatedOn VALUES ('Saga','Saga','J','Kyushu');
 INSERT INTO locatedOn VALUES ('Nagasaki','Nagasaki','J','Kyushu');
 INSERT INTO locatedOn VALUES ('Kumamoto','Kumamoto','J','Kyushu');
 INSERT INTO locatedOn VALUES ('Oita','Oita','J','Kyushu');
 INSERT INTO locatedOn VALUES ('Miyazaki','Miyazaki','J','Kyushu');
 INSERT INTO locatedOn VALUES ('Kagoshima','Kagoshima','J','Kyushu');
 INSERT INTO locatedOn VALUES ('Naha','Okinawa','J','Okinawa');
 INSERT INTO locatedOn VALUES ('San Fernando','Ilocos','RP','Luzon');
 INSERT INTO locatedOn VALUES ('San Carlos','Ilocos','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Tuguegarao','Cagayan Valley','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Tarlac','Central Luzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Cabanatuan','Central Luzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Mabalacat','Central Luzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Angeles','Central Luzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('San Fernando','Central Luzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Malolos','Central Luzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('San Jose Del Monte','Central Luzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Rodriguez','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('San Mateo','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Antipolo','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Cainta','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Taytay','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Binangonan','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Bacoor','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Imus','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('General Trias','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Dasmarinas','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('San Pedro','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Biñan','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Santa Rosa','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Cabuyao','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Calamba','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('San Pablo','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Lipa','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Batangas','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Lucena','Calabarzon','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Legazpi','Bicol','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Iloilo','Western Visayas','RP','Panay');
 INSERT INTO locatedOn VALUES ('Roxas','Western Visayas','RP','Panay');
 INSERT INTO locatedOn VALUES ('Bacolod','Western Visayas','RP','Negros');
 INSERT INTO locatedOn VALUES ('Cebu','Central Visayas','RP','Cebu');
 INSERT INTO locatedOn VALUES ('Lapu-Lapu','Central Visayas','RP','Cebu');
 INSERT INTO locatedOn VALUES ('Mandaue','Central Visayas','RP','Cebu');
 INSERT INTO locatedOn VALUES ('Toledo','Central Visayas','RP','Cebu');
 INSERT INTO locatedOn VALUES ('Tagbilaran','Central Visayas','RP','Bohol');
 INSERT INTO locatedOn VALUES ('Tacloban','Eastern Visayas','RP','Leyte');
 INSERT INTO locatedOn VALUES ('Pagadian','Zamboanga Peninsula','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Zamboanga','Zamboanga Peninsula','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Cagayan De Oro','Northern Mindanao','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Iligan','Northern Mindanao','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Valencia','Northern Mindanao','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Davao','Davao','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Tagum','Davao','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Koronadal','Soccsksargen','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('General Santos','Soccsksargen','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Valenzuela','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Marikina','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Malabon','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Kalookan','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Quezon City','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Manila','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Mandaluyong','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Pasig','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Makati','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Pasay','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Taguig','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Parañaque','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Las Piñas','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Muntinlupa','Metro Manila','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Baguio','Cordillera','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Cotabato','Muslim Mindanao','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Marawi','Muslim Mindanao','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Jolo','Muslim Mindanao','RP','Jolo');
 INSERT INTO locatedOn VALUES ('Butuan','Caraga','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Calapan','Mimaropa','RP','Mindoro');
 INSERT INTO locatedOn VALUES ('Puerto Princesa','Mimaropa','RP','Palawan');
 INSERT INTO locatedOn VALUES ('Phuket','Thailand','THA','Phuket');
 INSERT INTO locatedOn VALUES ('Georgetown','Pulau Pinang','MAL','Penang');
 INSERT INTO locatedOn VALUES ('Kota Kinabalu','Sabah','MAL','Borneo');
 INSERT INTO locatedOn VALUES ('Tawau','Sabah','MAL','Borneo');
 INSERT INTO locatedOn VALUES ('Sandakan','Sabah','MAL','Borneo');
 INSERT INTO locatedOn VALUES ('Kuching Utara','Sarawak','MAL','Borneo');
 INSERT INTO locatedOn VALUES ('Sibu','Sarawak','MAL','Borneo');
 INSERT INTO locatedOn VALUES ('Labuan','Labuan','MAL','Labuan');
 INSERT INTO locatedOn VALUES ('Bandar Seri Begawan','Brunei','BRU','Borneo');
 INSERT INTO locatedOn VALUES ('Singapore','Singapore','SGP','Ujong');
 INSERT INTO locatedOn VALUES ('Banda Aceh','Aceh','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Medan','Sumatera Utara','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Pematang Siantar','Sumatera Utara','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Binjai','Sumatera Utara','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Padang','Sumatera Barat','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Pekanbaru','Riau','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Dumai','Riau','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Jambi','Jambi','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Palembang','Sumatera Selatan','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Lubuk Linggau','Sumatera Selatan','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Bengkulu','Bengkulu','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Bandar Lampung','Lampung','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Pangkal Pinang','Kepulauan Bangka Belitung','RI','Bangka');
 INSERT INTO locatedOn VALUES ('Tanjung Pinang','Kepulauan Riau','RI','Bintan');
 INSERT INTO locatedOn VALUES ('Batam','Kepulauan Riau','RI','Batam');
 INSERT INTO locatedOn VALUES ('Jakarta','DKI Jakarta','RI','Java');
 INSERT INTO locatedOn VALUES ('Bandung','Jawa Barat','RI','Java');
 INSERT INTO locatedOn VALUES ('Bogor','Jawa Barat','RI','Java');
 INSERT INTO locatedOn VALUES ('Cirebon','Jawa Barat','RI','Java');
 INSERT INTO locatedOn VALUES ('Sukabumi','Jawa Barat','RI','Java');
 INSERT INTO locatedOn VALUES ('Bekasi','Jawa Barat','RI','Java');
 INSERT INTO locatedOn VALUES ('Depok','Jawa Barat','RI','Java');
 INSERT INTO locatedOn VALUES ('Tasikmalaya','Jawa Barat','RI','Java');
 INSERT INTO locatedOn VALUES ('Cimahi','Jawa Barat','RI','Java');
 INSERT INTO locatedOn VALUES ('Semarang','Jawa Tengah','RI','Java');
 INSERT INTO locatedOn VALUES ('Surakarta','Jawa Tengah','RI','Java');
 INSERT INTO locatedOn VALUES ('Pekalongan','Jawa Tengah','RI','Java');
 INSERT INTO locatedOn VALUES ('Tegal','Jawa Tengah','RI','Java');
 INSERT INTO locatedOn VALUES ('Yogyakarta','DI Yogyakarta','RI','Java');
 INSERT INTO locatedOn VALUES ('Surabaya','Jawa Timur','RI','Java');
 INSERT INTO locatedOn VALUES ('Malang','Jawa Timur','RI','Java');
 INSERT INTO locatedOn VALUES ('Probolinggo','Jawa Timur','RI','Java');
 INSERT INTO locatedOn VALUES ('Kediri','Jawa Timur','RI','Java');
 INSERT INTO locatedOn VALUES ('Serang','Banten','RI','Java');
 INSERT INTO locatedOn VALUES ('Tangerang','Banten','RI','Java');
 INSERT INTO locatedOn VALUES ('Tangerang Selatan','Banten','RI','Java');
 INSERT INTO locatedOn VALUES ('Cilegon','Banten','RI','Java');
 INSERT INTO locatedOn VALUES ('Denpasar','Bali','RI','Bali');
 INSERT INTO locatedOn VALUES ('Mataram','Nusa Tenggara Barat','RI','Lombok');
 INSERT INTO locatedOn VALUES ('Kupang','Nusa Tenggara Timur','RI','Timor');
 INSERT INTO locatedOn VALUES ('Pontianak','Kalimantan Barat','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Palangkaraya','Kalimantan Tengah','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Bandjarmasin','Kalimantan Selatan','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Samarinda','Kalimantan Timur','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Balikpapan','Kalimantan Timur','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Tanjung Selor','Kalimantan Utara','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Tarakan','Kalimantan Utara','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Manado','Sulawesi Utara','RI','Sulawesi');
 INSERT INTO locatedOn VALUES ('Palu','Sulawesi Tengah','RI','Sulawesi');
 INSERT INTO locatedOn VALUES ('Makassar','Sulawesi Selatan','RI','Sulawesi');
 INSERT INTO locatedOn VALUES ('Kendari','Sulawesi Tenggara','RI','Sulawesi');
 INSERT INTO locatedOn VALUES ('Gorontalo','Gorontalo','RI','Sulawesi');
 INSERT INTO locatedOn VALUES ('Mamuju','Sulawesi Barat','RI','Sulawesi');
 INSERT INTO locatedOn VALUES ('Ambon','Maluku','RI','Ambon');
 INSERT INTO locatedOn VALUES ('Ternate','Maluku Utara','RI','Ternate');
 INSERT INTO locatedOn VALUES ('Manokwari','Papua Barat','RI','New Guinea');
 INSERT INTO locatedOn VALUES ('Jayapura','Papua','RI','New Guinea');
 INSERT INTO locatedOn VALUES ('Merauke','Papua','RI','New Guinea');
 INSERT INTO locatedOn VALUES ('Dili','Timor-Leste','TL','Timor');
 INSERT INTO locatedOn VALUES ('Lae','North','PNG','New Guinea');
 INSERT INTO locatedOn VALUES ('Port Moresby','South','PNG','New Guinea');
 INSERT INTO locatedOn VALUES ('Buka','Bougainville','PNG','Buka');
 INSERT INTO locatedOn VALUES ('Honiara','Solomon Islands','SOL','Guadalcanal');
 INSERT INTO locatedOn VALUES ('Port Vila','Vanuatu','VU','Efate');
 INSERT INTO locatedOn VALUES ('Noumea','New Caledonia','NCL','Grande Terre');
 INSERT INTO locatedOn VALUES ('Hobart','Tasmania','AUS','Tasmania');
 INSERT INTO locatedOn VALUES ('Flying Fish Cove','Christmas Island','CX','Christmas Island');
 INSERT INTO locatedOn VALUES ('West Island','Cocos Islands','CC','Pulau Panjang');
 INSERT INTO locatedOn VALUES ('Kingston','Norfolk Island','NF','Norfolk Island');
 INSERT INTO locatedOn VALUES ('Wellington','New Zealand','NZ','Te Ika-a-Maui (North Island)');
 INSERT INTO locatedOn VALUES ('Auckland','New Zealand','NZ','Te Ika-a-Maui (North Island)');
 INSERT INTO locatedOn VALUES ('Hamilton','New Zealand','NZ','Te Ika-a-Maui (North Island)');
 INSERT INTO locatedOn VALUES ('Christchurch','New Zealand','NZ','Te Waka-a-Maui (South Island)');
 INSERT INTO locatedOn VALUES ('Dunedin','New Zealand','NZ','Te Waka-a-Maui (South Island)');
 INSERT INTO locatedOn VALUES ('Koror','Palau','PAL','Koror');
 INSERT INTO locatedOn VALUES ('Ngerulmud','Palau','PAL','Babeldaob');
 INSERT INTO locatedOn VALUES ('Saipan','Northern Mariana Islands','MP','Saipan');
 INSERT INTO locatedOn VALUES ('Hagåtña','Guam','GU','Guam');
 INSERT INTO locatedOn VALUES ('Palikir','Micronesia','FSM','Pohnpei');
 INSERT INTO locatedOn VALUES ('Majuro','Marshall Islands','MH','Majuro');
 INSERT INTO locatedOn VALUES ('Yaren','Nauru','NAU','Nauru');
 INSERT INTO locatedOn VALUES ('Tarawa','Kiribati','KIR','Tarawa');
 INSERT INTO locatedOn VALUES ('Funafuti','Tuvalu','TUV','Fongafale');
 INSERT INTO locatedOn VALUES ('Fakaofo','Tokelau','TOK','Fakaofo');
 INSERT INTO locatedOn VALUES ('Apia','Samoa','WS','Upolu');
 INSERT INTO locatedOn VALUES ('Pago Pago','American Samoa','AS','Tutuila');
 INSERT INTO locatedOn VALUES ('Mata-Utu','Wallis and Futuna','WF','Uvea');
 INSERT INTO locatedOn VALUES ('Suva','Fiji','FJI','Viti Levu');
 INSERT INTO locatedOn VALUES ('Nukualofa','Tonga','TO','Tongatapu');
 INSERT INTO locatedOn VALUES ('Alofi','Niue','NU','Niue');
 INSERT INTO locatedOn VALUES ('Avarua','Cook Islands','CK','Rarotonga');
 INSERT INTO locatedOn VALUES ('Papeete','French Polynesia','PF','Tahiti');
 INSERT INTO locatedOn VALUES ('Rikitea','French Polynesia','PF','Mangareva');
 INSERT INTO locatedOn VALUES ('Adamstown','Pitcairn','PN','Pitcairn');
 INSERT INTO locatedOn VALUES ('Banjul','Gambia','WAG','St. Mary''s Island');
 INSERT INTO locatedOn VALUES ('Malabo','Insular','GQ','Bioko');
 INSERT INTO locatedOn VALUES ('Mkokotoni','Kaskazini Unguja','EAT','Sansibar');
 INSERT INTO locatedOn VALUES ('Koani','Kusini Unguja','EAT','Sansibar');
 INSERT INTO locatedOn VALUES ('Zanzibar','Mjini Magharibi Unguja','EAT','Sansibar');
 INSERT INTO locatedOn VALUES ('Wete','Kaskazini Pemba','EAT','Pemba');
 INSERT INTO locatedOn VALUES ('Chake Chake','Kusini Pemba','EAT','Pemba');
 INSERT INTO locatedOn VALUES ('Praia','Cape Verde','CV','Santiago');
 INSERT INTO locatedOn VALUES ('São Tomé','Sao Tome and Principe','STP','Sao Tome');
 INSERT INTO locatedOn VALUES ('Victoria','Seychelles','SY','Mahe');
 INSERT INTO locatedOn VALUES ('Moroni','Comoros','COM','Grand Comoro');
 INSERT INTO locatedOn VALUES ('Mamoutzou','Mayotte','MYT','Mayotte');
 INSERT INTO locatedOn VALUES ('Antsiranana','Madagascar','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Antananarivo','Madagascar','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Antsirabe','Madagascar','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Fianarantsoa','Madagascar','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Majunga','Madagascar','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Tamatave','Madagascar','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Toliara','Madagascar','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Port Louis','Mauritius','MS','Mauritius');
 INSERT INTO locatedOn VALUES ('Saint-Denis','Reunion','RE','Reunion');
 INSERT INTO locatedOn VALUES ('Saint-Paul','Reunion','RE','Reunion');
 INSERT INTO locatedOn VALUES ('Jamestown','Saint Helena','HELX','Saint Helena');
 INSERT INTO locatedOn VALUES ('Nuuk','Greenland','GL','Greenland');
 INSERT INTO locatedOn VALUES ('Saint-Pierre','Saint Pierre and Miquelon','SPM','Saint Pierre');
 INSERT INTO locatedOn VALUES ('Hamilton','Bermuda','BM','Grand Bermuda');
 INSERT INTO locatedOn VALUES ('Victoria','British Columbia','CDN','Vancouver Island');
 INSERT INTO locatedOn VALUES ('Saanich','British Columbia','CDN','Vancouver Island');
 INSERT INTO locatedOn VALUES ('St. John''s','Newfoundland and Labrador','CDN','Newfoundland');
 INSERT INTO locatedOn VALUES ('Gander','Newfoundland and Labrador','CDN','Newfoundland');
 INSERT INTO locatedOn VALUES ('Laval','Quebec','CDN','Île Jésus');
 INSERT INTO locatedOn VALUES ('Montréal','Quebec','CDN','Île de Montréal');
 INSERT INTO locatedOn VALUES ('Iqaluit','Nunavut','CDN','Baffin Island');
 INSERT INTO locatedOn VALUES ('Honolulu','Hawaii','USA','Oahu');
 INSERT INTO locatedOn VALUES ('Hilo','Hawaii','USA','Hawaii');
 INSERT INTO locatedOn VALUES ('New York','New York','USA','Long Island');
 INSERT INTO locatedOn VALUES ('New York','New York','USA','Manhattan');
 INSERT INTO locatedOn VALUES ('New York','New York','USA','Staten Island');
 INSERT INTO locatedOn VALUES ('Nassau','Bahamas','BS','New Providence');
 INSERT INTO locatedOn VALUES ('Grand Turk','Turks and Caicos Islands','TUCA','Grand Turk');
 INSERT INTO locatedOn VALUES ('George Town','Cayman Islands','CYM','Grand Cayman');
 INSERT INTO locatedOn VALUES ('Camagüey','Camagüey','C','Cuba');
 INSERT INTO locatedOn VALUES ('Ciego de Ávila','Ciego de Ávila','C','Cuba');
 INSERT INTO locatedOn VALUES ('Cienfuegos','Cienfuegos','C','Cuba');
 INSERT INTO locatedOn VALUES ('La Habana','La Habana','C','Cuba');
 INSERT INTO locatedOn VALUES ('Bayamo','Granma','C','Cuba');
 INSERT INTO locatedOn VALUES ('Manzanillo','Granma','C','Cuba');
 INSERT INTO locatedOn VALUES ('Guantánamo','Guantánamo','C','Cuba');
 INSERT INTO locatedOn VALUES ('Holguín','Holguín','C','Cuba');
 INSERT INTO locatedOn VALUES ('Victoria de las Tunas','Las Tunas','C','Cuba');
 INSERT INTO locatedOn VALUES ('Matanzas','Matanzas','C','Cuba');
 INSERT INTO locatedOn VALUES ('Pinar del Río','Pinar del Río','C','Cuba');
 INSERT INTO locatedOn VALUES ('Sancti Spíritus','Sancti Spíritus','C','Cuba');
 INSERT INTO locatedOn VALUES ('Santiago de Cuba','Santiago de Cuba','C','Cuba');
 INSERT INTO locatedOn VALUES ('Santa Clara','Villa Clara','C','Cuba');
 INSERT INTO locatedOn VALUES ('Nueva Gerona','Isla de la Juventud','C','Isla de la Juventud');
 INSERT INTO locatedOn VALUES ('Artemisa','Artemisa','C','Cuba');
 INSERT INTO locatedOn VALUES ('San José de las Lajas','Mayabeque','C','Cuba');
 INSERT INTO locatedOn VALUES ('Kingston','Jamaica','JA','Jamaica');
 INSERT INTO locatedOn VALUES ('Port-au-Prince','Haiti','RH','Hispaniola');
 INSERT INTO locatedOn VALUES ('Carrefour','Haiti','RH','Hispaniola');
 INSERT INTO locatedOn VALUES ('Delmas','Haiti','RH','Hispaniola');
 INSERT INTO locatedOn VALUES ('Pétion-Ville','Haiti','RH','Hispaniola');
 INSERT INTO locatedOn VALUES ('Cité Soleil','Haiti','RH','Hispaniola');
 INSERT INTO locatedOn VALUES ('Gonaïves','Haiti','RH','Hispaniola');
 INSERT INTO locatedOn VALUES ('Cap-Haïtien','Haiti','RH','Hispaniola');
 INSERT INTO locatedOn VALUES ('Santo Domingo','Dominican Republic','DOM','Hispaniola');
 INSERT INTO locatedOn VALUES ('Santiago','Dominican Republic','DOM','Hispaniola');
 INSERT INTO locatedOn VALUES ('Puerto Plata','Dominican Republic','DOM','Hispaniola');
 INSERT INTO locatedOn VALUES ('San Juan','Puerto Rico','PR','Puerto Rico');
 INSERT INTO locatedOn VALUES ('Ponce','Puerto Rico','PR','Puerto Rico');
 INSERT INTO locatedOn VALUES ('Bayamón','Puerto Rico','PR','Puerto Rico');
 INSERT INTO locatedOn VALUES ('Carolina','Puerto Rico','PR','Puerto Rico');
 INSERT INTO locatedOn VALUES ('Charlotte Amalie','Virgin Islands','VIRG','Saint Thomas');
 INSERT INTO locatedOn VALUES ('Road Town','British Virgin Islands','BVI','Tortola');
 INSERT INTO locatedOn VALUES ('The Valley','Anguilla','AXA','Anguilla');
 INSERT INTO locatedOn VALUES ('Marigot','Saint Martin','SMAR','St. Martin');
 INSERT INTO locatedOn VALUES ('Philipsburg','Sint Maarten','SX','St. Martin');
 INSERT INTO locatedOn VALUES ('Gustavia','Saint Barthelemy','SBAR','St. Barthelemy');
 INSERT INTO locatedOn VALUES ('Basseterre','Saint Kitts and Nevis','KN','Saint Kitts');
 INSERT INTO locatedOn VALUES ('St. John''s','Antigua and Barbuda','AG','Antigua');
 INSERT INTO locatedOn VALUES ('Plymouth','Montserrat','MNTS','Montserrat');
 INSERT INTO locatedOn VALUES ('Brades','Montserrat','MNTS','Montserrat');
 INSERT INTO locatedOn VALUES ('Basse-Terre','Guadeloupe','GP','Basse-Terre');
 INSERT INTO locatedOn VALUES ('Roseau','Dominica','WD','Dominica');
 INSERT INTO locatedOn VALUES ('Fort-de-France','Martinique','MQ','Martinique');
 INSERT INTO locatedOn VALUES ('Castries','Saint Lucia','WL','Saint Lucia');
 INSERT INTO locatedOn VALUES ('Bridgetown','Barbados','BDS','Barbados');
 INSERT INTO locatedOn VALUES ('Kingstown','Saint Vincent and the Grenadines','WV','Saint Vincent');
 INSERT INTO locatedOn VALUES ('Saint George''s','Grenada','WG','Grenada');
 INSERT INTO locatedOn VALUES ('Port-of-Spain','Trinidad and Tobago','TT','Trinidad');
 INSERT INTO locatedOn VALUES ('Kralendijk','Bonaire','NLB','Bonaire');
 INSERT INTO locatedOn VALUES ('Willemstad','Curacao','CUR','Curacao');
 INSERT INTO locatedOn VALUES ('Oranjestad','Aruba','ARU','Aruba');
 INSERT INTO locatedOn VALUES ('La Asuncion','Nueva Esparta','YV','Isla Margarita');
 INSERT INTO locatedOn VALUES ('Porlamar','Nueva Esparta','YV','Isla Margarita');
 INSERT INTO locatedOn VALUES ('San Andres','San Andrés, Providencia y Santa Catalina','CO','San Andres');
 INSERT INTO locatedOn VALUES ('Ushuaia','Tierra del Fuego','RA','Tierra del Fuego');
 INSERT INTO locatedOn VALUES ('Vitória','Espírito Santo','BR','Ilha de Vitória');
 INSERT INTO locatedOn VALUES ('São Luís','Maranhão','BR','Ilha de São Luís');
 INSERT INTO locatedOn VALUES ('Florianópolis','Santa Catarina','BR','Ilha de Santa Catarina');
 INSERT INTO locatedOn VALUES ('Santos','São Paulo','BR','Ilha de São Vicente');
 INSERT INTO locatedOn VALUES ('São Vicente','São Paulo','BR','Ilha de São Vicente');
 INSERT INTO locatedOn VALUES ('Guarujá','São Paulo','BR','Ilha de Sãnto Amaro');
 INSERT INTO locatedOn VALUES ('Stanley','Falkland Islands','FALK','East Falkland');
 
 


 INSERT INTO islandIn VALUES ('Svalbard','Norwegian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Svalbard','Greenland Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Svalbard','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Svalbard','Barents Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Greenland','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Greenland','Greenland Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Greenland','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Greenland','Labrador Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Greenland','Baffin Bay',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hans Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Iceland','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Iceland','Norwegian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Iceland','Greenland Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Austvågøy','Norwegian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Streymoy','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Streymoy','Norwegian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ireland','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ireland','Irish Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Great Britain','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Great Britain','The Channel',NULL,NULL);
 INSERT INTO islandIn VALUES ('Great Britain','Irish Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Great Britain','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Shetland Mainland','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Shetland Mainland','Norwegian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Orkney Mainland','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('South Ronaldsay','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hoy','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Westray','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Barra','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('South Uist','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Benbecula','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('North Uist','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lewis and Harris','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Skye','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Rhum','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mull','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tiree','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Islay','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Jura','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Arran','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Isle of Man','Irish Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Anglesey','Irish Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Isle of Wight','The Channel',NULL,NULL);
 INSERT INTO islandIn VALUES ('Guernsey','The Channel',NULL,NULL);
 INSERT INTO islandIn VALUES ('Jersey','The Channel',NULL,NULL);
 INSERT INTO islandIn VALUES ('Gotland','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Öland','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Åland','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hiumaa','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ösel','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Seeland','Kattegat',NULL,NULL);
 INSERT INTO islandIn VALUES ('Seeland','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fünen','Kattegat',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fünen','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Langeland','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Falster','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lolland','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bornholm','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fehmarn','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Rügen','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Usedom','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Helgoland','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sylt','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Föhr','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Amrum','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Pellworm','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Wangerooge','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Spiekeroog','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Langeoog','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Baltrum','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Norderney','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Juist','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Borkum','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Schiermonnikoog','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ameland','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Terschelling','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Vlieland','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Texel','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Krk','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Cres','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Brač','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Korčula','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Korfu','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lefkas','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kefallinia','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Zakynthos','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Euboea','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Samothraki','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lesbos','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Chios','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Samos','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ikaria','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kos','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Rhodos','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Syros','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mykonos','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Crete','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Cyprus','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Corse','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Elba','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sardegna','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Alicudi','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Filicudi','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Salina','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lipari','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Vulcano','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Panarea','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Stromboli','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sicilia','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lampedusa','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Linosa','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Malta','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Gozo','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Djerba','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Menorca','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mallorca','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ibiza','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Formentera','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lanzarote','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fuerteventura','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Gran Canaria','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Teneriffa','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Gomera','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hierro','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('La Palma','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Madeira','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Porto Santo','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sao Miguel','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Santa Maria','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Terceira','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sao Jorge','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Pico','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Faial','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Graciosa','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Flores (Azores)','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Corvo','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Santiago','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fogo','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('St. Mary''s Island','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sao Tome','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Principe','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bioko','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Helena','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ascension','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tristan Da Cunha','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('West Falkland','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('East Falkland','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bahrain','Persian Gulf',NULL,NULL);
 INSERT INTO islandIn VALUES ('Khark','Persian Gulf',NULL,NULL);
 INSERT INTO islandIn VALUES ('Qeshm','Gulf of Oman',NULL,NULL);
 INSERT INTO islandIn VALUES ('Qeshm','Persian Gulf',NULL,NULL);
 INSERT INTO islandIn VALUES ('Christmas Island','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Pulau Panjang','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Male','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Salsette','Arabian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kavaratti','Arabian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sri Lanka','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sri Lanka','Gulf of Bengal',NULL,NULL);
 INSERT INTO islandIn VALUES ('South Andaman Island','Gulf of Bengal',NULL,NULL);
 INSERT INTO islandIn VALUES ('South Andaman Island','Andaman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sokotra','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sokotra','Arabian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sokotra','Gulf of Aden',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sansibar','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Pemba','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mafia','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mahe','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grand Comoro','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Anjouan','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mohéli','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mayotte','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Reunion','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mauritius','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Madagaskar','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Novaya Zemlya Severny Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Novaya Zemlya Severny Island','Barents Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Novaya Zemlya Severny Island','Kara Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Novaya Zemlya Yuzhny Island','Barents Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Novaya Zemlya Yuzhny Island','Kara Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kotelny Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kotelny Island','Laptev Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kotelny Island','East Sibirian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Wrangel Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Wrangel Island','East Sibirian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Wrangel Island','Chukchi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Atlasov','Sea of Okhotsk',NULL,NULL);
 INSERT INTO islandIn VALUES ('Paramushir','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Paramushir','Sea of Okhotsk',NULL,NULL);
 INSERT INTO islandIn VALUES ('Onekotan','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Onekotan','Sea of Okhotsk',NULL,NULL);
 INSERT INTO islandIn VALUES ('Iturup','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Iturup','Sea of Okhotsk',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kunashir','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kunashir','Sea of Okhotsk',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sachalin','Sea of Okhotsk',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sachalin','Sea of Japan',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hokkaido','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hokkaido','Sea of Okhotsk',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hokkaido','Sea of Japan',NULL,NULL);
 INSERT INTO islandIn VALUES ('Honshu','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Honshu','Sea of Japan',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kyushu','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kyushu','Sea of Japan',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kyushu','East China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Shikoku','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Awajishima','Seto Inland Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Okinawa','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Okinawa','East China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Nishinoshima','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Jeju','East China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Taiwan','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Taiwan','East China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Taiwan','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Great Kinmen','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Xiamen','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Taipa','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Coloane','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hainan','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Zhoushan','East China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Chongming','East China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Luzon','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Luzon','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mindoro','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mindoro','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sibuyan','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Panay','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Negros','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Cebu','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bohol','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Leyte','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Leyte','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Samar','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Samar','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mindanao','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mindanao','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mindanao','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Palawan','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Palawan','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Jolo','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Jolo','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ujong','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ujong','Malakka Strait',NULL,NULL);
 INSERT INTO islandIn VALUES ('Penang','Malakka Strait',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ko Samui','Andaman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Phuket','Andaman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumatra','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumatra','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumatra','Andaman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumatra','Malakka Strait',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumatra','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Batam','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bintan','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bangka','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bangka','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Krakatau','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Krakatau','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Java','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Java','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Labuan','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Borneo','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Borneo','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Borneo','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Borneo','Sulu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Madura','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bali','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bali','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lombok','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lombok','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumbawa','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumbawa','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sangeang','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Flores','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Flores','Banda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Flores','Savu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumba','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumba','Savu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Timor','Banda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Timor','Savu Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Timor','Timor Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sulawesi','Java Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sulawesi','Banda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sulawesi','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Buru','Banda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ambon','Banda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ceram','Banda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Halmahera','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Halmahera','Banda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ternate','Banda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Guinea','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Guinea','Banda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Guinea','Arafura Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Guinea','Coral Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Guinea','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Goodenough Island','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Britain','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Britain','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Duke of York Island','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Duke of York Island','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Ireland','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Ireland','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Buka','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Buka','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bougainville','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bougainville','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Guadalcanal','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kolombangara','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Choiseul','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Choiseul','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Santa Isabel','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Santa Isabel','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Malaita','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Malaita','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Makira','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Makira','Coral Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Makira','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Rennell Island','Coral Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Rennell Island','Solomon Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grande Terre','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grande Terre','Coral Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grande Terre','Tasman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Cangaroo Island','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Melville Island','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lord Howe Island','Tasman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ball''s Pyramid','Tasman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tasmania','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tasmania','Tasman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Victoria Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Banks Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Prince of Wales Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Baffin Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Baffin Island','Hudson Bay',NULL,NULL);
 INSERT INTO islandIn VALUES ('Baffin Island','Labrador Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Southampton Island','Hudson Bay',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ellesmere Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ellesmere Island','Baffin Bay',NULL,NULL);
 INSERT INTO islandIn VALUES ('Devon Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Devon Island','Baffin Bay',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Pierre','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Miquelon-Langlade','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Newfoundland','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Prince Edward Island','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Marthas Vineyard','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Nantucket','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Long Island','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Manhattan','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Staten Island','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Unalaska','Bering Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Unalaska','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Unimak','Bering Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Unimak','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Vancouver Island','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Santa Cruz Island','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Santa Catalina Island','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Santa Rosa Island','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('San Clemente Island','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('San Miguel Island','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grand Bermuda','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Providence','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grand Turk','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Providenciales','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('North Caicos','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Cuba','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Cuba','Gulf of Mexico',NULL,NULL);
 INSERT INTO islandIn VALUES ('Cuba','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Isla de la Juventud','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Jamaica','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hispaniola','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hispaniola','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Puerto Rico','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Puerto Rico','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tortola','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tortola','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Thomas','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Thomas','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Croix','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Anguilla','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Anguilla','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('St. Martin','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('St. Martin','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('St. Barthelemy','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('St. Barthelemy','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Kitts','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Kitts','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Nevis','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Nevis','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Barbuda','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Barbuda','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Antigua','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Antigua','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Montserrat','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Montserrat','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Basse-Terre','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Basse-Terre','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grande-Terre','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grande-Terre','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Dominica','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Dominica','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Martinique','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Martinique','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Lucia','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Lucia','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Vincent','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saint Vincent','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Barbados','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grenada','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grenada','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Trinidad','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Trinidad','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tobago','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tobago','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Isla Margarita','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bonaire','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Curacao','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Aruba','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grand Cayman','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Little Cayman','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Cayman Brac','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('San Andres','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Isabela','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Marajó','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ilha de São Luís','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ilha de Vitória','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ilha de São Vicente','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ilha de Sãnto Amaro','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ilha de Santa Catarina','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Chiloé','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tierra del Fuego','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tierra del Fuego','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Niihau','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kauai','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Oahu','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Molokai','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lanai','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Maui','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Hawaii','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Niue','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Saipan','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tinian','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Guam','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Rota','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Uvea','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Futuna','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tarawa','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kiritimati','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Banaba','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tongatapu','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kao','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Viti Levu','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Vanua Levu','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Norfolk Island','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Norfolk Island','Tasman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Nauru','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Koror','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Babeldaob','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fongafale','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fakaofo','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Espiritu Santo','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Espiritu Santo','Coral Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Efate','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Efate','Coral Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tanna','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tanna','Coral Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Upolu','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Savaii','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tutuila','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Rarotonga','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tahiti','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Raiātea','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Mangareva','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Makatea','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Rangiroa','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Majuro','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kwajalein','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bikini','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Yap','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Pohnpei','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kapingamarangi','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Weno','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kosrae','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Pitcairn','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Henderson Island','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Easter Island','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Te Ika-a-Maui (North Island)','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Te Ika-a-Maui (North Island)','Tasman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Te Waka-a-Maui (South Island)','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Te Waka-a-Maui (South Island)','Tasman Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ukerewe',NULL,'Lake Victoria',NULL);
 INSERT INTO islandIn VALUES ('Olkhon',NULL,'Ozero Baikal',NULL);
 INSERT INTO islandIn VALUES ('Krenizyn',NULL,'Koltsevoye Lake',NULL);
 INSERT INTO islandIn VALUES ('Taal Volcano Island',NULL,'Lake Taal',NULL);
 INSERT INTO islandIn VALUES ('Taal Vulcan Point',NULL,'Taal Crater Lake',NULL);
 INSERT INTO islandIn VALUES ('Samosir',NULL,'Lake Toba',NULL);
 INSERT INTO islandIn VALUES ('Rene Levasseur Island',NULL,'Lake Manicouagan',NULL);
 INSERT INTO islandIn VALUES ('Teresa Island',NULL,'Atlin Lake',NULL);
 INSERT INTO islandIn VALUES ('Manitoulin',NULL,'Lake Huron',NULL);
 INSERT INTO islandIn VALUES ('Treasure Island',NULL,'Lake Mindemoya',NULL);
 INSERT INTO islandIn VALUES ('Isla da Ometepe',NULL,'Lake Nicaragua',NULL);
 INSERT INTO islandIn VALUES ('Amantaní',NULL,'Lake Titicaca',NULL);
 INSERT INTO islandIn VALUES ('Zitny Ostrov',NULL,NULL, 'Donau');
 INSERT INTO islandIn VALUES ('Zitny Ostrov',NULL,NULL, 'Waag');
 INSERT INTO islandIn VALUES ('Maly Zitny Ostrov',NULL,NULL, 'Donau');
 INSERT INTO islandIn VALUES ('Margit Sziget',NULL,NULL, 'Donau');
 INSERT INTO islandIn VALUES ('Veliko Ratno Ostrvo',NULL,NULL, 'Donau');
 INSERT INTO islandIn VALUES ('Veliko Ratno Ostrvo',NULL,NULL, 'Save');
 INSERT INTO islandIn VALUES ('Impalila',NULL,NULL, 'Zambezi');
 INSERT INTO islandIn VALUES ('Chongming',NULL,NULL, 'Yangtze');
 INSERT INTO islandIn VALUES ('Île de Montréal',NULL,NULL, 'Saint Lawrence River');
 INSERT INTO islandIn VALUES ('Île Jésus',NULL,NULL, 'Saint Lawrence River');
 INSERT INTO islandIn VALUES ('Manhattan',NULL,NULL, 'Hudson River');
 INSERT INTO islandIn VALUES ('Marajó',NULL,NULL, 'Tocantins');
 INSERT INTO islandIn VALUES ('Marajó',NULL,NULL, 'Araguaia');
 INSERT INTO islandIn VALUES ('Ilha do Bananal',NULL,NULL, 'Araguaia');
 
 


 INSERT INTO mountainOnIsland VALUES ('Gunnbjørn Fjeld','Greenland');
 INSERT INTO mountainOnIsland VALUES ('Newtontoppen','Svalbard');
 INSERT INTO mountainOnIsland VALUES ('Hvannadalshnukur','Iceland');
 INSERT INTO mountainOnIsland VALUES ('Snaefell','Iceland');
 INSERT INTO mountainOnIsland VALUES ('Hekla','Iceland');
 INSERT INTO mountainOnIsland VALUES ('Katla','Iceland');
 INSERT INTO mountainOnIsland VALUES ('Higravstinden','Austvågøy');
 INSERT INTO mountainOnIsland VALUES ('Ben Nevis','Great Britain');
 INSERT INTO mountainOnIsland VALUES ('Snowdon','Great Britain');
 INSERT INTO mountainOnIsland VALUES ('Sgùrr Alasdair','Skye');
 INSERT INTO mountainOnIsland VALUES ('Carrauntoohil','Ireland');
 INSERT INTO mountainOnIsland VALUES ('Slieve Donard','Ireland');
 INSERT INTO mountainOnIsland VALUES ('Puig Major','Mallorca');
 INSERT INTO mountainOnIsland VALUES ('Monte Cinto','Corse');
 INSERT INTO mountainOnIsland VALUES ('Punta La Marmora','Sardegna');
 INSERT INTO mountainOnIsland VALUES ('Monte Capanne','Elba');
 INSERT INTO mountainOnIsland VALUES ('Etna','Sicilia');
 INSERT INTO mountainOnIsland VALUES ('Pizzo Carbonara','Sicilia');
 INSERT INTO mountainOnIsland VALUES ('Aenos','Kefallinia');
 INSERT INTO mountainOnIsland VALUES ('Elati','Lefkas');
 INSERT INTO mountainOnIsland VALUES ('Dirfi','Euboea');
 INSERT INTO mountainOnIsland VALUES ('Fengari','Samothraki');
 INSERT INTO mountainOnIsland VALUES ('Kerkis','Samos');
 INSERT INTO mountainOnIsland VALUES ('Pilineo','Chios');
 INSERT INTO mountainOnIsland VALUES ('Pramnos','Ikaria');
 INSERT INTO mountainOnIsland VALUES ('Attavyros','Rhodos');
 INSERT INTO mountainOnIsland VALUES ('Psiloritis','Crete');
 INSERT INTO mountainOnIsland VALUES ('Olympos','Cyprus');
 INSERT INTO mountainOnIsland VALUES ('Pico de Teide','Teneriffa');
 INSERT INTO mountainOnIsland VALUES ('Pico de las Nieves','Gran Canaria');
 INSERT INTO mountainOnIsland VALUES ('Pico de Malpaso','Hierro');
 INSERT INTO mountainOnIsland VALUES ('Garajonay','Gomera');
 INSERT INTO mountainOnIsland VALUES ('Roque de los Muchachos','La Palma');
 INSERT INTO mountainOnIsland VALUES ('Pico Ruivo','Madeira');
 INSERT INTO mountainOnIsland VALUES ('Pico','Pico');
 INSERT INTO mountainOnIsland VALUES ('Pico da Vara','Sao Miguel');
 INSERT INTO mountainOnIsland VALUES ('Pico da Esperança','Sao Jorge');
 INSERT INTO mountainOnIsland VALUES ('Cabeço Gordo','Faial');
 INSERT INTO mountainOnIsland VALUES ('Serra de Santa Bárbara','Terceira');
 INSERT INTO mountainOnIsland VALUES ('Fogo','Fogo');
 INSERT INTO mountainOnIsland VALUES ('Pico da Antónia','Santiago');
 INSERT INTO mountainOnIsland VALUES ('Pico Basile','Bioko');
 INSERT INTO mountainOnIsland VALUES ('Pico de Sao Tome','Sao Tome');
 INSERT INTO mountainOnIsland VALUES ('Queen Marys Peak','Tristan Da Cunha');
 INSERT INTO mountainOnIsland VALUES ('Jabal Hajhir','Sokotra');
 INSERT INTO mountainOnIsland VALUES ('Tsaratanana','Madagaskar');
 INSERT INTO mountainOnIsland VALUES ('Tsiafajavona','Madagaskar');
 INSERT INTO mountainOnIsland VALUES ('Andringitra','Madagaskar');
 INSERT INTO mountainOnIsland VALUES ('Piton des Neiges','Reunion');
 INSERT INTO mountainOnIsland VALUES ('Piton de la Fournaise','Reunion');
 INSERT INTO mountainOnIsland VALUES ('Piton de la Petite Rivière Noire','Mauritius');
 INSERT INTO mountainOnIsland VALUES ('Karthala','Grand Comoro');
 INSERT INTO mountainOnIsland VALUES ('Ntringui','Anjouan');
 INSERT INTO mountainOnIsland VALUES ('Pik Sedova','Novaya Zemlya Severny Island');
 INSERT INTO mountainOnIsland VALUES ('Gora Pervousmotrennaya','Novaya Zemlya Yuzhny Island');
 INSERT INTO mountainOnIsland VALUES ('Pidurutalagala','Sri Lanka');
 INSERT INTO mountainOnIsland VALUES ('Alaid','Atlasov');
 INSERT INTO mountainOnIsland VALUES ('Chikurachki','Paramushir');
 INSERT INTO mountainOnIsland VALUES ('Krenizyn','Krenizyn');
 INSERT INTO mountainOnIsland VALUES ('Stokap','Iturup');
 INSERT INTO mountainOnIsland VALUES ('Tyatya','Kunashir');
 INSERT INTO mountainOnIsland VALUES ('Lopatin','Sachalin');
 INSERT INTO mountainOnIsland VALUES ('Zhima','Olkhon');
 INSERT INTO mountainOnIsland VALUES ('Asahi-Dake','Hokkaido');
 INSERT INTO mountainOnIsland VALUES ('Iwate','Honshu');
 INSERT INTO mountainOnIsland VALUES ('Hotaka-Dake','Honshu');
 INSERT INTO mountainOnIsland VALUES ('Kita-Dake','Honshu');
 INSERT INTO mountainOnIsland VALUES ('Haku-San','Honshu');
 INSERT INTO mountainOnIsland VALUES ('Fuji-San','Honshu');
 INSERT INTO mountainOnIsland VALUES ('Daisen','Honshu');
 INSERT INTO mountainOnIsland VALUES ('Ishizuchi-San','Shikoku');
 INSERT INTO mountainOnIsland VALUES ('Sobo-San','Kyushu');
 INSERT INTO mountainOnIsland VALUES ('Halla-San','Jeju');
 INSERT INTO mountainOnIsland VALUES ('Jirisan','Jeju');
 INSERT INTO mountainOnIsland VALUES ('Wuzhi Shan','Hainan');
 INSERT INTO mountainOnIsland VALUES ('Yu Shan','Taiwan');
 INSERT INTO mountainOnIsland VALUES ('Sicapo','Luzon');
 INSERT INTO mountainOnIsland VALUES ('Pulag','Luzon');
 INSERT INTO mountainOnIsland VALUES ('Tapulao','Luzon');
 INSERT INTO mountainOnIsland VALUES ('Pinatubo','Luzon');
 INSERT INTO mountainOnIsland VALUES ('Taal','Taal Volcano Island');
 INSERT INTO mountainOnIsland VALUES ('Banahao','Luzon');
 INSERT INTO mountainOnIsland VALUES ('Mayon','Luzon');
 INSERT INTO mountainOnIsland VALUES ('Mt. Halcon','Mindoro');
 INSERT INTO mountainOnIsland VALUES ('Mt. Guiting-Guiting','Sibuyan');
 INSERT INTO mountainOnIsland VALUES ('Madias','Panay');
 INSERT INTO mountainOnIsland VALUES ('Kanlaon','Negros');
 INSERT INTO mountainOnIsland VALUES ('Osmeña Peak','Cebu');
 INSERT INTO mountainOnIsland VALUES ('Majuyag','Leyte');
 INSERT INTO mountainOnIsland VALUES ('Mantalingajan','Palawan');
 INSERT INTO mountainOnIsland VALUES ('Mt. Apo','Mindanao');
 INSERT INTO mountainOnIsland VALUES ('Dulang-dulang','Mindanao');
 INSERT INTO mountainOnIsland VALUES ('Tagubud','Mindanao');
 INSERT INTO mountainOnIsland VALUES ('Malindang','Mindanao');
 INSERT INTO mountainOnIsland VALUES ('Kinabalu','Borneo');
 INSERT INTO mountainOnIsland VALUES ('Murud','Borneo');
 INSERT INTO mountainOnIsland VALUES ('Siho','Borneo');
 INSERT INTO mountainOnIsland VALUES ('Mantam','Borneo');
 INSERT INTO mountainOnIsland VALUES ('Bukit Batubrok','Borneo');
 INSERT INTO mountainOnIsland VALUES ('Bukit Raya','Borneo');
 INSERT INTO mountainOnIsland VALUES ('Besar','Borneo');
 INSERT INTO mountainOnIsland VALUES ('Seulawah Agam','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Geureudong','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Leuser','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Sinabung','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Samosir Hill','Samosir');
 INSERT INTO mountainOnIsland VALUES ('Toba Caldera','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Talakmau','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Marapi','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Kerinci','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Masurai','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Dempo','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Rajabasa','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Krakatau','Krakatau');
 INSERT INTO mountainOnIsland VALUES ('Karang','Java');
 INSERT INTO mountainOnIsland VALUES ('Gede','Java');
 INSERT INTO mountainOnIsland VALUES ('Ciremai','Java');
 INSERT INTO mountainOnIsland VALUES ('Slamet','Java');
 INSERT INTO mountainOnIsland VALUES ('Merapi','Java');
 INSERT INTO mountainOnIsland VALUES ('Semeru','Java');
 INSERT INTO mountainOnIsland VALUES ('Raung','Java');
 INSERT INTO mountainOnIsland VALUES ('Agung','Bali');
 INSERT INTO mountainOnIsland VALUES ('Rinjani','Lombok');
 INSERT INTO mountainOnIsland VALUES ('Tambora','Sumbawa');
 INSERT INTO mountainOnIsland VALUES ('Sangeang','Sangeang');
 INSERT INTO mountainOnIsland VALUES ('Poco Mandasawu','Flores');
 INSERT INTO mountainOnIsland VALUES ('Kelimutu','Flores');
 INSERT INTO mountainOnIsland VALUES ('Wanggameti','Sumba');
 INSERT INTO mountainOnIsland VALUES ('Mutis','Timor');
 INSERT INTO mountainOnIsland VALUES ('Tatamailau','Timor');
 INSERT INTO mountainOnIsland VALUES ('Rantemario','Sulawesi');
 INSERT INTO mountainOnIsland VALUES ('Moncong Lompobatang','Sulawesi');
 INSERT INTO mountainOnIsland VALUES ('Buyu Balease','Sulawesi');
 INSERT INTO mountainOnIsland VALUES ('Fuyul Sojol','Sulawesi');
 INSERT INTO mountainOnIsland VALUES ('Klabat','Sulawesi');
 INSERT INTO mountainOnIsland VALUES ('Buyu Lumut','Sulawesi');
 INSERT INTO mountainOnIsland VALUES ('Mekongga','Sulawesi');
 INSERT INTO mountainOnIsland VALUES ('Gamalama','Ternate');
 INSERT INTO mountainOnIsland VALUES ('Gamkonora','Halmahera');
 INSERT INTO mountainOnIsland VALUES ('Kapalatmada','Buru');
 INSERT INTO mountainOnIsland VALUES ('Binaiya','Ceram');
 INSERT INTO mountainOnIsland VALUES ('Salahutu','Ambon');
 INSERT INTO mountainOnIsland VALUES ('Mt. Arfak','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Puncak Jaya','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Puncak Trikora','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Puncak Mandala','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Mt. Wilhelm','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Mt. Giluwe','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Mt. Victoria','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Mt. Suckling','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Mt. Boising','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Mt. Vineuo','Goodenough Island');
 INSERT INTO mountainOnIsland VALUES ('Mt. Ulawun','New Britain');
 INSERT INTO mountainOnIsland VALUES ('Mt. Taron','New Ireland');
 INSERT INTO mountainOnIsland VALUES ('Mt. Balbi','Bougainville');
 INSERT INTO mountainOnIsland VALUES ('Mt. Tomanivi','Viti Levu');
 INSERT INTO mountainOnIsland VALUES ('Mt. Nasorolevu','Vanua Levu');
 INSERT INTO mountainOnIsland VALUES ('Tabwemasana','Espiritu Santo');
 INSERT INTO mountainOnIsland VALUES ('Mt. Tukosmera','Tanna');
 INSERT INTO mountainOnIsland VALUES ('Mt. Yasur','Tanna');
 INSERT INTO mountainOnIsland VALUES ('Silisili','Savaii');
 INSERT INTO mountainOnIsland VALUES ('Mt. Fito','Upolu');
 INSERT INTO mountainOnIsland VALUES ('Mont Orohena','Tahiti');
 INSERT INTO mountainOnIsland VALUES ('Mt. Tefatua','Raiātea');
 INSERT INTO mountainOnIsland VALUES ('Popomanaseu','Guadalcanal');
 INSERT INTO mountainOnIsland VALUES ('Mt. Veve','Kolombangara');
 INSERT INTO mountainOnIsland VALUES ('Mt. Panié','Grande Terre');
 INSERT INTO mountainOnIsland VALUES ('Mauna Kea','Hawaii');
 INSERT INTO mountainOnIsland VALUES ('Mauna Loa','Hawaii');
 INSERT INTO mountainOnIsland VALUES ('Haleakala','Maui');
 INSERT INTO mountainOnIsland VALUES ('Mauna Kamakou','Molokai');
 INSERT INTO mountainOnIsland VALUES ('Kaʻala','Oahu');
 INSERT INTO mountainOnIsland VALUES ('Kawaikini','Kauai');
 INSERT INTO mountainOnIsland VALUES ('Lānaihale','Lanai');
 INSERT INTO mountainOnIsland VALUES ('Mt. Ossa','Tasmania');
 INSERT INTO mountainOnIsland VALUES ('Mt. Cook','Te Waka-a-Maui (South Island)');
 INSERT INTO mountainOnIsland VALUES ('Mt. Aspiring','Te Waka-a-Maui (South Island)');
 INSERT INTO mountainOnIsland VALUES ('Mt. Tapuaenuku','Te Waka-a-Maui (South Island)');
 INSERT INTO mountainOnIsland VALUES ('Ruapehu','Te Ika-a-Maui (North Island)');
 INSERT INTO mountainOnIsland VALUES ('Mt. Taranaki','Te Ika-a-Maui (North Island)');
 INSERT INTO mountainOnIsland VALUES ('Barbeau Peak','Ellesmere Island');
 INSERT INTO mountainOnIsland VALUES ('Treuter Mt.','Devon Island');
 INSERT INTO mountainOnIsland VALUES ('Mt. Odin','Baffin Island');
 INSERT INTO mountainOnIsland VALUES ('Makushin','Unalaska');
 INSERT INTO mountainOnIsland VALUES ('Shishaldin','Unimak');
 INSERT INTO mountainOnIsland VALUES ('Birch Mountain','Teresa Island');
 INSERT INTO mountainOnIsland VALUES ('Golden Hinde','Vancouver Island');
 INSERT INTO mountainOnIsland VALUES ('Mt. Babel','Rene Levasseur Island');
 INSERT INTO mountainOnIsland VALUES ('Concepcion','Isla da Ometepe');
 INSERT INTO mountainOnIsland VALUES ('Pico Turquino','Cuba');
 INSERT INTO mountainOnIsland VALUES ('Blue Mountain Peak','Jamaica');
 INSERT INTO mountainOnIsland VALUES ('Pic la Selle','Hispaniola');
 INSERT INTO mountainOnIsland VALUES ('Pico Duarte','Hispaniola');
 INSERT INTO mountainOnIsland VALUES ('Cerro de Punta','Puerto Rico');
 INSERT INTO mountainOnIsland VALUES ('Liamuiga','Saint Kitts');
 INSERT INTO mountainOnIsland VALUES ('Nevis Peak','Nevis');
 INSERT INTO mountainOnIsland VALUES ('Soufriere Hills','Montserrat');
 INSERT INTO mountainOnIsland VALUES ('La Soufriere','Basse-Terre');
 INSERT INTO mountainOnIsland VALUES ('Soufriere','Saint Vincent');
 INSERT INTO mountainOnIsland VALUES ('Morne Diablotins','Dominica');
 INSERT INTO mountainOnIsland VALUES ('Pelee','Martinique');
 INSERT INTO mountainOnIsland VALUES ('Wolf','Isabela');
 INSERT INTO mountainOnIsland VALUES ('Monte Darwin','Tierra del Fuego');
 
 


 INSERT INTO riverOnIsland VALUES ('Thames','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Severn','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Avon','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Test','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Great Ouse','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Trent','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Ouse','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Aire','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Clyde','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Leven','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Ness','Great Britain');
 INSERT INTO riverOnIsland VALUES ('Bann','Ireland');
 INSERT INTO riverOnIsland VALUES ('Shannon','Ireland');
 INSERT INTO riverOnIsland VALUES ('Imera Meridionale','Sicilia');
 INSERT INTO riverOnIsland VALUES ('Tirso','Sardegna');
 INSERT INTO riverOnIsland VALUES ('Ishikari','Hokkaido');
 INSERT INTO riverOnIsland VALUES ('Shinano','Honshu');
 INSERT INTO riverOnIsland VALUES ('Tone','Honshu');
 INSERT INTO riverOnIsland VALUES ('Kitakami','Honshu');
 INSERT INTO riverOnIsland VALUES ('Yodo','Honshu');
 INSERT INTO riverOnIsland VALUES ('Kushiro','Hokkaido');
 INSERT INTO riverOnIsland VALUES ('Tamsui','Taiwan');
 INSERT INTO riverOnIsland VALUES ('Gaoping','Taiwan');
 INSERT INTO riverOnIsland VALUES ('Mahaweli','Sri Lanka');
 INSERT INTO riverOnIsland VALUES ('Asahan','Sumatra');
 INSERT INTO riverOnIsland VALUES ('Batang Hari','Sumatra');
 INSERT INTO riverOnIsland VALUES ('Solo','Java');
 INSERT INTO riverOnIsland VALUES ('Rajang','Borneo');
 INSERT INTO riverOnIsland VALUES ('Kapuas','Borneo');
 INSERT INTO riverOnIsland VALUES ('Mahakam','Borneo');
 INSERT INTO riverOnIsland VALUES ('Barito','Borneo');
 INSERT INTO riverOnIsland VALUES ('Pansipit River','Luzon');
 INSERT INTO riverOnIsland VALUES ('Pasig River','Luzon');
 INSERT INTO riverOnIsland VALUES ('Agus River','Mindanao');
 INSERT INTO riverOnIsland VALUES ('Mamberano','New Guinea');
 INSERT INTO riverOnIsland VALUES ('Digul','New Guinea');
 INSERT INTO riverOnIsland VALUES ('Sepik','New Guinea');
 INSERT INTO riverOnIsland VALUES ('Fly River','New Guinea');
 INSERT INTO riverOnIsland VALUES ('Ruggles River','Ellesmere Island');
 INSERT INTO riverOnIsland VALUES ('Koukdjuak River','Baffin Island');
 INSERT INTO riverOnIsland VALUES ('Manitou River','Manitoulin');
 INSERT INTO riverOnIsland VALUES ('Mindemoya River','Manitoulin');
 INSERT INTO riverOnIsland VALUES ('Río Azopardo','Tierra del Fuego');
 INSERT INTO riverOnIsland VALUES ('Waikato River','Te Ika-a-Maui (North Island)');
 INSERT INTO riverOnIsland VALUES ('Whangaehu River','Te Ika-a-Maui (North Island)');
 INSERT INTO riverOnIsland VALUES ('Clutha River','Te Waka-a-Maui (South Island)');
 
 


 INSERT INTO lakeOnIsland VALUES ('Arresø','Seeland');
 INSERT INTO lakeOnIsland VALUES ('Lough Neagh','Ireland');
 INSERT INTO lakeOnIsland VALUES ('Loch Ness','Great Britain');
 INSERT INTO lakeOnIsland VALUES ('Loch Lomond','Great Britain');
 INSERT INTO lakeOnIsland VALUES ('Koltsevoye Lake','Onekotan');
 INSERT INTO lakeOnIsland VALUES ('Lake Biwa','Honshu');
 INSERT INTO lakeOnIsland VALUES ('Lake Kussharo','Hokkaido');
 INSERT INTO lakeOnIsland VALUES ('Lake Tazawa','Honshu');
 INSERT INTO lakeOnIsland VALUES ('Lake Pinatubo','Luzon');
 INSERT INTO lakeOnIsland VALUES ('Lake Taal','Luzon');
 INSERT INTO lakeOnIsland VALUES ('Taal Crater Lake','Taal Volcano Island');
 INSERT INTO lakeOnIsland VALUES ('Laguna de Bay','Luzon');
 INSERT INTO lakeOnIsland VALUES ('Lake Lanao','Mindanao');
 INSERT INTO lakeOnIsland VALUES ('Lake Toba','Sumatra');
 INSERT INTO lakeOnIsland VALUES ('Danau Kumbang','Sumatra');
 INSERT INTO lakeOnIsland VALUES ('Segara Anak','Lombok');
 INSERT INTO lakeOnIsland VALUES ('Lake Hazen','Ellesmere Island');
 INSERT INTO lakeOnIsland VALUES ('Nettilling Lake','Baffin Island');
 INSERT INTO lakeOnIsland VALUES ('Lake Manitou','Manitoulin');
 INSERT INTO lakeOnIsland VALUES ('Lake Mindemoya','Manitoulin');
 INSERT INTO lakeOnIsland VALUES ('Fagnano Lake','Tierra del Fuego');
 INSERT INTO lakeOnIsland VALUES ('Lake Taupo','Te Ika-a-Maui (North Island)');
 INSERT INTO lakeOnIsland VALUES ('Te Wai ā-moe','Te Ika-a-Maui (North Island)');
 INSERT INTO lakeOnIsland VALUES ('Lake Wanaka','Te Waka-a-Maui (South Island)');
 INSERT INTO lakeOnIsland VALUES ('Lake Tengano','Rennell Island');
 
 


 INSERT INTO airport VALUES ('HEA','Herat','AFG','Herat','Afghanistan',NULL,34.210017,62.2283,977,5);
 INSERT INTO airport VALUES ('KBL','Kabul Intl','AFG','Kabul','Afghanistan',NULL,34.565853,69.212328,1792,5);
 INSERT INTO airport VALUES ('TIA','Tirana Rinas','AL','Tirana','Albania',NULL,41.414742,19.720561,38,1);
 INSERT INTO airport VALUES ('TEE','Cheikh Larbi Tebessi','DZ','Tébessa','Algeria',NULL,35.431611,8.120717,811,1);
 INSERT INTO airport VALUES ('BLJ','Batna Airport','DZ','Batna','Algeria',NULL,35.752106,6.308589,822,1);
 INSERT INTO airport VALUES ('BJA','Soummam','DZ','Bejaïa','Algeria',NULL,36.711997,5.069922,6,1);
 INSERT INTO airport VALUES ('TMR','Tamanrasset','DZ','Tamanrasset','Algeria',NULL,22.811461,5.451075,1377,1);
 INSERT INTO airport VALUES ('BSK','Biskra','DZ','Biskra','Algeria',NULL,34.793289,5.738231,88,1);
 INSERT INTO airport VALUES ('CZL','Mohamed Boudiaf Intl','DZ','Constantine','Algeria',NULL,36.276028,6.620386,691,1);
 INSERT INTO airport VALUES ('QSF','Ain Arnat Airport','DZ','Sétif','Algeria',NULL,36.1781,5.32449,1024,1);
 INSERT INTO airport VALUES ('ORN','Es Senia','DZ','Oran','Algeria',NULL,35.623858,-0.621183,90,1);
 INSERT INTO airport VALUES ('GHA','Noumerat','DZ','Ghardaïa','Algeria',NULL,32.384106,3.794114,461,1);
 INSERT INTO airport VALUES ('AAE','Annaba','DZ','Annaba','Algeria',NULL,36.822225,7.809167,5,1);
 INSERT INTO airport VALUES ('ALG','Houari Boumediene','DZ','Algiers','Algeria',NULL,36.691014,3.215408,25,1);
 INSERT INTO airport VALUES ('TLM','Zenata','DZ','Tlemcen','Algeria',NULL,35.016667,-1.45,248,1);
 INSERT INTO airport VALUES ('PPG','Pago Pago Intl','AS','Pago Pago','American Samoa','Tutuila',-14.2794,-170.7006,10,-11);
 INSERT INTO airport VALUES ('VPE','Ondjiva Pereira Airport','ANG','Ngiva','Cunene',NULL,-17.043464,15.683822,1087,1);
 INSERT INTO airport VALUES ('SDD','Lubango','ANG','Lubango','Huíla',NULL,-14.924733,13.575022,1762,1);
 INSERT INTO airport VALUES ('CAB','Cabinda','ANG','Cabinda','Cabinda',NULL,-5.596992,12.188353,20,1);
 INSERT INTO airport VALUES ('SPP','Menongue','ANG','Menongue','Cuando Cubango',NULL,-14.657583,17.719833,1363,1);
 INSERT INTO airport VALUES ('LAD','Luanda 4 De Fevereiro','ANG','Luanda','Luanda',NULL,-8.858375,13.231178,74,1);
 INSERT INTO airport VALUES ('NOV','Huambo','ANG','Huambo','Huambo',NULL,-12.808878,15.760547,1703,1);
 INSERT INTO airport VALUES ('AXA','Wallblake','AXA','The Valley','Anguilla','Anguilla',18.204834,-63.055084,39,-4);
 INSERT INTO airport VALUES ('ANU','V C Bird Intl','AG','St. John''s','Antigua and Barbuda','Antigua',17.136749,-61.792667,19,-4);
 INSERT INTO airport VALUES ('IRJ','La Rioja','RA','La Rioja','La Rioja',NULL,-29.381636,-66.795839,438,-3);
 INSERT INTO airport VALUES ('JUJ','Jujuy','RA','San Salvador de Jujuy','Jujuy',NULL,-24.392778,-65.097778,920,-3);
 INSERT INTO airport VALUES ('BHI','Comandante Espora','RA','Bahía Blanca','Buenos Aires',NULL,-38.724967,-62.169317,75,-3);
 INSERT INTO airport VALUES ('TUC','Teniente Benjamin Matienzo','RA','San Miguel de Tucumán','Tucumán',NULL,-26.840861,-65.104944,456,-3);
 INSERT INTO airport VALUES ('LUQ','San Luis','RA','San Luis','San Luis',NULL,-33.273192,-66.356422,710,-3);
 INSERT INTO airport VALUES ('SDE','Santiago del Estero','RA','Santiago del Estero','Santiago de Estero',NULL,-27.765617,-64.310122,200,-3);
 INSERT INTO airport VALUES ('SFN','Sauce Viejo','RA','Santa Fe','Santa Fe',NULL,-31.711666,-60.811668,17,-3);
 INSERT INTO airport VALUES ('CNQ','Corrientes','RA','Corrientes','Corrientes',NULL,-27.445503,-58.761864,62,-3);
 INSERT INTO airport VALUES ('NQN','Presidente Peron','RA','Neuquén','Neuquén',NULL,-38.949,-68.155711,273,-3);
 INSERT INTO airport VALUES ('SLA','Salta','RA','Salta','Salta',NULL,-24.855978,-65.486169,1246,-3);
 INSERT INTO airport VALUES ('AEP','Aeroparque Jorge Newbery','RA','Buenos Aires','Distrito Federal',NULL,-34.559175,-58.415606,5,-3);
 INSERT INTO airport VALUES ('EZE','Ministro Pistarini','RA','Buenos Aires','Distrito Federal',NULL,-34.822222,-58.535833,20,-3);
 INSERT INTO airport VALUES ('USH','Ushuaia Malvinas Argentinas','RA','Ushuaia','Tierra del Fuego',NULL,-54.843278,-68.29575,22,-3);
 INSERT INTO airport VALUES ('FMA','Formosa','RA','Formosa','Formosa',NULL,-26.212722,-58.228111,59,-3);
 INSERT INTO airport VALUES ('PSS','Posadas','RA','Posadas','Misiones',NULL,-27.385839,-55.970728,131,-3);
 INSERT INTO airport VALUES ('ROS','Rosario','RA','Rosario','Santa Fe',NULL,-32.903611,-60.785,26,-3);
 INSERT INTO airport VALUES ('RES','Resistencia','RA','Resistencia','Chaco',NULL,-27.449986,-59.056125,53,-3);
 INSERT INTO airport VALUES ('RGL','Rio Gallegos','RA','Río Gallegos','Santa Cruz',NULL,-51.608875,-69.312636,19,-3);
 INSERT INTO airport VALUES ('CRD','Comodoro Rivadavia','RA','Comodoro Rivadavia','Chubut',NULL,-45.785347,-67.465508,58,-3);
 INSERT INTO airport VALUES ('MDQ','Mar Del Plata','RA','Mar del Plata','Buenos Aires',NULL,-37.934167,-57.573333,22,-3);
 INSERT INTO airport VALUES ('MDZ','El Plumerillo','RA','Mendoza','Mendoza',NULL,-32.831717,-68.792856,704,-3);
 INSERT INTO airport VALUES ('COR','Ambrosio L V Taravella','RA','Córdoba','Córdoba',NULL,-31.323619,-64.207953,489,-3);
 INSERT INTO airport VALUES ('EVN','Zvartnots','ARM','Yerevan','Armenia',NULL,40.147275,44.395881,865,4);
 INSERT INTO airport VALUES ('AUA','Reina Beatrix Intl','ARU','Oranjestad','Aruba','Aruba',12.501389,-70.015221,18,-4);
 INSERT INTO airport VALUES ('MEL','Melbourne Intl','AUS','Melbourne','Victoria',NULL,-37.673333,144.843333,132,10);
 INSERT INTO airport VALUES ('SYD','Sydney Intl','AUS','Sydney','New South Wales',NULL,-33.946111,151.177222,6,10);
 INSERT INTO airport VALUES ('CNS','Cairns Intl','AUS','Cairns','Queensland',NULL,-16.885833,145.755278,3,10);
 INSERT INTO airport VALUES ('TSV','Townsville','AUS','Townsville','Queensland',NULL,-19.2525,146.765278,5,10);
 INSERT INTO airport VALUES ('BNE','Brisbane Intl','AUS','Brisbane','Queensland',NULL,-27.384167,153.1175,4,10);
 INSERT INTO airport VALUES ('CBR','Canberra','AUS','Canberra','Australia Capital Territory',NULL,-35.306944,149.195,575,10);
 INSERT INTO airport VALUES ('ADL','Adelaide Intl','AUS','Adelaide','South Australia',NULL,-34.945,138.530556,6,9.5);
 INSERT INTO airport VALUES ('NTL','Newcastle Airport','AUS','Newcastle','New South Wales',NULL,-32.78,151.83,9,10);
 INSERT INTO airport VALUES ('DRW','Darwin Intl','AUS','Darwin','Northern Territory',NULL,-12.4083333,130.87266,31,9.5);
 INSERT INTO airport VALUES ('PER','Perth Intl','AUS','Perth','Western Australia',NULL,-31.940278,115.966944,20,8);
 INSERT INTO airport VALUES ('HBA','Hobart','AUS','Hobart','Tasmania','Tasmania',-42.836111,147.510278,4,10);
 INSERT INTO airport VALUES ('SZG','Salzburg','A','Salzburg','Salzburg',NULL,47.793304,13.004333,430,1);
 INSERT INTO airport VALUES ('LNZ','Linz','A','Linz','Oberösterreich',NULL,48.233219,14.187511,298,1);
 INSERT INTO airport VALUES ('INN','Innsbruck','A','Innsbruck','Tirol',NULL,47.260219,11.343964,581,1);
 INSERT INTO airport VALUES ('VIE','Schwechat','A','Wien','Wien',NULL,48.110278,16.569722,183,1);
 INSERT INTO airport VALUES ('GRZ','Graz','A','Graz','Steiermark',NULL,46.991067,15.439628,340,1);
 INSERT INTO airport VALUES ('KLU','Woerthersee International Airport','A','Klagenfurt','Kärnten',NULL,46.642514,14.337739,138,1);
 INSERT INTO airport VALUES ('GYD','Heydar Aliyev','AZ','Baku','Azerbaijan',NULL,40.4675,50.046667,3,4);
 INSERT INTO airport VALUES ('NAS','Lynden Pindling Intl','BS','Nassau','Bahamas','New Providence',25.038958,-77.466231,5,-5);
 INSERT INTO airport VALUES ('BAH','Bahrain Intl','BRN','Al Manāmah','Bahrain','Bahrain',26.270834,50.63361,2,3);
 INSERT INTO airport VALUES ('DAC','Zia Intl','BD','Dhaka','Dhaka',NULL,23.843333,90.397781,9,6);
 INSERT INTO airport VALUES ('CGP','Shah Amanat Intl','BD','Chittagong','Chittagong',NULL,22.249611,91.813286,4,6);
 INSERT INTO airport VALUES ('BGI','Grantley Adams Intl','BDS','Bridgetown','Barbados','Barbados',13.074603,-59.492456,52,-4);
 INSERT INTO airport VALUES ('MSQ','Minsk National','BY','Minsk','Minsk City',NULL,53.882469,28.030731,204,3);
 INSERT INTO airport VALUES ('ANR','Deurne','B','Antwerpen','Antwerpen',NULL,51.189444,4.460278,12,1);
 INSERT INTO airport VALUES ('CRL','Brussels South','B','Charleroi','Hainaut',NULL,50.459197,4.453817,187,1);
 INSERT INTO airport VALUES ('LGG','Aéroport de Liège','B','Liège','Liège',NULL,50.6375,5.4433,201,1);
 INSERT INTO airport VALUES ('BRU','Brussels Natl','B','Bruxelles','Bruxelles',NULL,50.901389,4.484444,56,1);
 INSERT INTO airport VALUES ('BZE','Philip S W Goldson Intl','BZ','Belize City','Belize',NULL,17.539144,-88.308203,5,-6);
 INSERT INTO airport VALUES ('COO','Cadjehoun','BEN','Cotonou','Benin',NULL,6.357228,2.384353,6,1);
 INSERT INTO airport VALUES ('BDA','Bermuda Intl','BM','Hamilton','Bermuda','Grand Bermuda',32.364042,-64.678703,4,-4);
 INSERT INTO airport VALUES ('PBH','Paro','BHT','Thimphu','Bhutan',NULL,27.403192,89.424606,2235,6);
 INSERT INTO airport VALUES ('CIJ','Heroes Del Acre','BOL','Cobija','Pando',NULL,-11.040436,-68.782972,272,-4);
 INSERT INTO airport VALUES ('LPB','El Alto Intl','BOL','La Paz','La Paz',NULL,-16.513339,-68.192256,4063,-4);
 INSERT INTO airport VALUES ('VVI','Viru Viru Intl','BOL','Santa Cruz de la Sierra','Santa Cruz',NULL,-17.644756,-63.135364,373,-4);
 INSERT INTO airport VALUES ('SRE','Juana Azurduy De Padilla','BOL','Sucre','Chuquisaca',NULL,-19.007083,-65.288747,2905,-4);
 INSERT INTO airport VALUES ('TDD','Tte Av Jorge Henrich Arauz','BOL','Trinidad','Beni',NULL,-14.818739,-64.918019,155,-4);
 INSERT INTO airport VALUES ('TJA','Capitan Oriel Lea Plaza','BOL','Tarija','Tarija',NULL,-21.555736,-64.701325,1855,-4);
 INSERT INTO airport VALUES ('CBB','Jorge Wilsterman','BOL','Cochabamba','Cochabamba',NULL,-17.421058,-66.177114,2549,-4);
 INSERT INTO airport VALUES ('SJJ','Sarajevo','BIH','Sarajevo','Federacija Bosne i Hercegovine',NULL,43.824583,18.331467,521,1);
 INSERT INTO airport VALUES ('GBE','Sir Seretse Khama Intl','RB','Gaborone','Botswana',NULL,-24.555225,25.918208,1006,2);
 INSERT INTO airport VALUES ('REC','Guararapes Gilberto Freyre Intl','BR','Recife','Pernambuco',NULL,-8.126794,-34.923039,10,-3);
 INSERT INTO airport VALUES ('BSB','Presidente Juscelino Kubitschek','BR','Brasília','Distrito Federal',NULL,-15.8711,-47.918625,1061,-3);
 INSERT INTO airport VALUES ('BVB','Boa Vista','BR','Boa Vista','Roraima',NULL,2.846311,-60.690069,84,-4);
 INSERT INTO airport VALUES ('RBR','Rio Branco','BR','Rio Branco','Acre',NULL,-9.87,-67.89,193,-5);
 INSERT INTO airport VALUES ('UDI','Ten Cel Av Cesar Bombonato','BR','Uberlândia','Minas Gerais',NULL,-18.882844,-48.225594,943,-3);
 INSERT INTO airport VALUES ('MCZ','Zumbi Dos Palmares','BR','Maceió','Alagoas',NULL,-9.510808,-35.791678,118,-3);
 INSERT INTO airport VALUES ('MCP','Macapa','BR','Macapá','Amapá',NULL,.050664,-51.072178,17,-3);
 INSERT INTO airport VALUES ('MAO','Eduardo Gomes Intl','BR','Manaus','Amazonas',NULL,-3.038611,-60.049721,80,-4);
 INSERT INTO airport VALUES ('VIX','Goiabeiras','BR','Vitória','Espírito Santo',NULL,-20.258056,-40.286389,3,-3);
 INSERT INTO airport VALUES ('CWB','Afonso Pena','BR','Curitiba','Paraná',NULL,-25.528475,-49.175775,911,-3);
 INSERT INTO airport VALUES ('STM','Santarem','BR','Santarém','Pará',NULL,-2.422431,-54.792789,60,-3);
 INSERT INTO airport VALUES ('LDB','Londrina','BR','Londrina','Paraná',NULL,-23.333625,-51.130072,569,-3);
 INSERT INTO airport VALUES ('CGB','Marechal Rondon','BR','Cuiabá','Mato Grosso',NULL,-15.652931,-56.116719,188,-4);
 INSERT INTO airport VALUES ('CGR','Campo Grande','BR','Campo Grande','Mato Grosso do Sul',NULL,-20.468667,-54.6725,559,-4);
 INSERT INTO airport VALUES ('CGH','Congonhas','BR','São Paulo','São Paulo',NULL,-23.626692,-46.655375,802,-3);
 INSERT INTO airport VALUES ('SDU','Santos Dumont','BR','Rio de Janeiro','Rio de Janeiro',NULL,-22.910461,-43.163133,3,-3);
 INSERT INTO airport VALUES ('SSA','Deputado Luis Eduardo Magalhaes','BR','Salvador','Bahia',NULL,-12.910994,-38.331044,20,-3);
 INSERT INTO airport VALUES ('CNF','Tancredo Neves Intl','BR','Belo Horizonte','Minas Gerais',NULL,-19.63375,-43.968856,828,-3);
 INSERT INTO airport VALUES ('SLZ','Marechal Cunha Machado Intl','BR','São Luís','Maranhão',NULL,-2.585361,-44.234139,54,-3);
 INSERT INTO airport VALUES ('CPQ','Amarais Airport','BR','Campinas','São Paulo',NULL,-22.8592,-47.1082,612,-3);
 INSERT INTO airport VALUES ('VCP','Viracopos','BR','Campinas','São Paulo',NULL,-23.0075,-47.134444,662,-3);
 INSERT INTO airport VALUES ('AJU','Santa Maria','BR','Aracaju','Sergipe',NULL,-10.984,-37.070333,7,-3);
 INSERT INTO airport VALUES ('UBA','Uberaba','BR','Uberaba','Minas Gerais',NULL,-19.765,-47.964778,809,-3);
 INSERT INTO airport VALUES ('BEL','Val De Cans Intl','BR','Belém','Pará',NULL,-1.37925,-48.476292,16,-3);
 INSERT INTO airport VALUES ('THE','Senador Petronio Portella','BR','Teresina','Piauí',NULL,-5.059942,-42.823478,67,-3);
 INSERT INTO airport VALUES ('NAT','Augusto Severo','BR','Natal','Rio Grande do Norte',NULL,-5.911417,-35.247717,52,-3);
 INSERT INTO airport VALUES ('PET','Pelotas','BR','Pelotas','Rio Grande do Sul',NULL,-31.718353,-52.327689,18,-3);
 INSERT INTO airport VALUES ('RAO','Leite Lopes','BR','Ribeirão Preto','São Paulo',NULL,-21.134167,-47.774189,549,-3);
 INSERT INTO airport VALUES ('RVD','General Leite de Castro Airport','BR','Rio Verde','Goiás',NULL,-17.790278,-50.918333,684,-3);
 INSERT INTO airport VALUES ('GVR','Governador Valadares Airport','BR','Governador Valadares','Minas Gerais',NULL,-18.8952,-41.9822,171,-3);
 INSERT INTO airport VALUES ('IPN','Usiminas','BR','Ipatinga','Minas Gerais',NULL,-19.470722,-42.487583,239,-3);
 INSERT INTO airport VALUES ('CXJ','Campo Dos Bugres','BR','Caxias do Sul','Rio Grande do Sul',NULL,-29.197064,-51.187536,754,-3);
 INSERT INTO airport VALUES ('GIG','Galeao Antonio Carlos Jobim','BR','Rio de Janeiro','Rio de Janeiro',NULL,-22.808903,-43.243647,9,-3);
 INSERT INTO airport VALUES ('FOR','Pinto Martins Intl','BR','Fortaleza','Ceará',NULL,-3.776283,-38.532556,25,-3);
 INSERT INTO airport VALUES ('PLU','Pampulha Carlos Drummond De Andrade','BR','Belo Horizonte','Minas Gerais',NULL,-19.851181,-43.950628,789,-3);
 INSERT INTO airport VALUES ('PVH','Governador Jorge Teixeira De Oliveira','BR','Porto Velho','Rondônia',NULL,-8.709294,-63.902281,90,-4);
 INSERT INTO airport VALUES ('GYN','Santa Genoveva','BR','Goiânia','Goiás',NULL,-16.632033,-49.220686,747,-3);
 INSERT INTO airport VALUES ('POA','Salgado Filho','BR','Porto Alegre','Rio Grande do Sul',NULL,-29.994428,-51.171428,3,-3);
 INSERT INTO airport VALUES ('GRU','Guarulhos Gov Andre Franco Montouro','BR','São Paulo','São Paulo',NULL,-23.432075,-46.469511,750,-3);
 INSERT INTO airport VALUES ('IMP','Prefeito Renato Moreira','BR','Imperatriz','Maranhão',NULL,-5.531292,-47.46005,131,-3);
 INSERT INTO airport VALUES ('IOS','Ilheus','BR','Ilhéus','Bahia',NULL,-14.815964,-39.033197,5,-3);
 INSERT INTO airport VALUES ('EIS','Terrance B Lettsome Intl','BVI','Road Town','British Virgin Islands','Tortola',18.444834,-64.542975,5,-4);
 INSERT INTO airport VALUES ('BWN','Brunei Intl','BRU','Bandar Seri Begawan','Brunei','Borneo',4.9442,114.928353,22,8);
 INSERT INTO airport VALUES ('BOJ','Burgas','BG','Burgas','Bulgaria',NULL,42.569583,27.515236,41,2);
 INSERT INTO airport VALUES ('VAR','Varna','BG','Varna','Bulgaria',NULL,43.232072,27.825106,70,2);
 INSERT INTO airport VALUES ('PDV','Plovdiv','BG','Plovdiv','Bulgaria',NULL,42.067806,24.850833,182,2);
 INSERT INTO airport VALUES ('SOF','Sofia','BG','Sofia','Bulgaria',NULL,42.695194,23.406167,531,2);
 INSERT INTO airport VALUES ('BOY','Bobo Dioulasso','BF','Bobo Dioulasso','Burkina Faso',NULL,11.160056,-4.330969,461,0);
 INSERT INTO airport VALUES ('OUA','Ouagadougou','BF','Ouagadougou','Burkina Faso',NULL, 12.353194,-1.512417,316,0);
 INSERT INTO airport VALUES ('MDL','Mandalay Intl','MYA','Mandalay','Mandalay',NULL,21.702156,95.977928,91,6.5);
 INSERT INTO airport VALUES ('RGN','Yangon Intl','MYA','Yangon','Yangon',NULL,16.907305,96.133222,33,6.5);
 INSERT INTO airport VALUES ('BJM','Bujumbura Intl','BI','Bujumbura','Burundi',NULL,-3.324019,29.318519,787,2);
 INSERT INTO airport VALUES ('PNH','Phnom Penh Intl','K','Phnom Penh','Cambodia',NULL,11.546556,104.844139,12,7);
 INSERT INTO airport VALUES ('DLA','Douala','CAM','Douala','Littoral',NULL,4.006081,9.719481,10,1);
 INSERT INTO airport VALUES ('NSI','Yaounde Nsimalen','CAM','Yaoundé','Centre',NULL,3.722556,11.553269,695,1);
 INSERT INTO airport VALUES ('YQX','Gander Intl','CDN','Gander','Newfoundland and Labrador','Newfoundland',48.936944,-54.568056,151,-4);
 INSERT INTO airport VALUES ('YXY','Whitehorse Intl','CDN','Whitehorse','Yukon',NULL,60.709553,-135.067269,706,-8);
 INSERT INTO airport VALUES ('YFB','Iqaluit','CDN','Iqaluit','Nunavut','Baffin Island',63.75639,-68.555832,34,-5);
 INSERT INTO airport VALUES ('YYT','St Johns Intl','CDN','St. John''s','Newfoundland and Labrador','Newfoundland',47.61861,-52.751945,141,-3.5);
 INSERT INTO airport VALUES ('YYZ','Lester B Pearson Intl','CDN','Toronto','Ontario',NULL,43.677223,-79.630556,173,-5);
 INSERT INTO airport VALUES ('YYC','Calgary Intl','CDN','Calgary','Alberta',NULL,51.113888,-114.020278,1084,-7);
 INSERT INTO airport VALUES ('YYJ','Victoria Intl','CDN','Victoria','British Columbia','Vancouver Island',48.646944,-123.425833,19,-8);
 INSERT INTO airport VALUES ('YXU','London','CDN','London','Ontario',NULL,43.033056,-81.151111,278,-5);
 INSERT INTO airport VALUES ('YXE','Saskatoon J G Diefenbaker Intl','CDN','Saskatoon','Saskatchewan',NULL,52.170834,-106.699722,504,-6);
 INSERT INTO airport VALUES ('YZF','Yellowknife','CDN','Yellowknife','Northwest Territories',NULL,62.462778,-114.440278,206,-7);
 INSERT INTO airport VALUES ('YQB','Quebec Jean Lesage Intl','CDN','Quebec','Quebec',NULL,46.791111,-71.393333,74,-5);
 INSERT INTO airport VALUES ('YQT','Thunder Bay','CDN','Thunder Bay','Ontario',NULL,48.371944,-89.323889,199,-5);
 INSERT INTO airport VALUES ('YQR','Regina Intl','CDN','Regina','Saskatchewan',NULL,50.431944,-104.665833,577,-6);
 INSERT INTO airport VALUES ('YOW','Ottawa Macdonald Cartier Intl','CDN','Ottawa','Ontario',NULL,45.3225,-75.669167,114,-5);
 INSERT INTO airport VALUES ('YUL','Pierre Elliott Trudeau Intl','CDN','Montréal','Quebec',NULL,45.470556,-73.740833,36,-5);
 INSERT INTO airport VALUES ('YTZ','City Centre','CDN','Toronto','Ontario',NULL,43.627499,-79.396167,77,-5);
 INSERT INTO airport VALUES ('YWG','Winnipeg Intl','CDN','Winnipeg','Manitoba',NULL,49.910036,-97.239886,239,-6);
 INSERT INTO airport VALUES ('YVR','Vancouver Intl','CDN','Vancouver','British Columbia',NULL,49.193889,-123.184444,4,-8);
 INSERT INTO airport VALUES ('YHM','Hamilton','CDN','Hamilton','Ontario',NULL,43.173611,-79.935,238,-5);
 INSERT INTO airport VALUES ('YHZ','Halifax Intl','CDN','Halifax','Nova Scotia',NULL,44.880833,-63.50861,145,-4);
 INSERT INTO airport VALUES ('YEG','Edmonton Intl','CDN','Edmonton','Alberta',NULL,53.309723,-113.579722,723,-7);
 INSERT INTO airport VALUES ('RAI','Praia International Airport','CV','Praia','Cape Verde','Santiago',14.9245,-23.4935,70,-1);
 INSERT INTO airport VALUES ('LYB','Edward Bodden Airfield','CYM',NULL,NULL,'Little Cayman',19.6591666667,-80.09083333,1,-5);
 INSERT INTO airport VALUES ('GCM','Owen Roberts Intl','CYM','George Town','Cayman Islands','Grand Cayman',19.292778,-81.35775,2,-5);
 INSERT INTO airport VALUES ('CYB','Gerrard Smith Intl','CYM',NULL,NULL,'Cayman Brac',19.686981,-79.882789,2,-5);
 INSERT INTO airport VALUES ('BGF','Bangui M Poko','RCA','Bangui','Central African Republic',NULL,4.398475,18.518786,368,1);
 INSERT INTO airport VALUES ('NDJ','Ndjamena Hassan Djamous','TCH','N''Djamena','Chad',NULL,12.133689,15.034019,295,1);
 INSERT INTO airport VALUES ('ANF','Cerro Moreno Intl','RCH','Antofagasta','Antofagasta',NULL,-23.444478,-70.4451,139,-4);
 INSERT INTO airport VALUES ('ZAL','Pichoy','RCH','Valdivia','Ríos',NULL,-39.649956,-73.086111,18,-4);
 INSERT INTO airport VALUES ('LSC','La Florida','RCH','La Serena','Coquimbo',NULL,-29.916233,-71.199522,147,-4);
 INSERT INTO airport VALUES ('CPO','Copiapo','RCH','Copiapó','Atacama',NULL,-27,-70,305,-4);
 INSERT INTO airport VALUES ('CCP','Carriel Sur Intl','RCH','Concepción','Bío-Bío',NULL,-36.77265,-73.063106,8,-4);
 INSERT INTO airport VALUES ('ZCO','Maquehue','RCH','Temuco','Araucanía',NULL,-38.766819,-72.637097,93,-4);
 INSERT INTO airport VALUES ('SCL','Arturo Merino Benitez Intl','RCH','Santiago','Santiago',NULL,-33.392975,-70.785803,474,-4);
 INSERT INTO airport VALUES ('IQQ','Diego Aracena Intl','RCH','Iquique','Tarapacá',NULL,-20.535222,-70.181275,47,-4);
 INSERT INTO airport VALUES ('ARI','Chacalluta','RCH','Arica','Arica y Parinacota',NULL,-18.348531,-70.338742,51,-4);
 INSERT INTO airport VALUES ('PMC','El Tepual Intl','RCH','Puerto Montt','Lagos',NULL,-41.438886,-73.093953,90,-4);
 INSERT INTO airport VALUES ('PUQ','Carlos Ibanez Del Campo Intl','RCH','Punta Arenas','Magallanes',NULL,-53.002642,-70.854586,42,-4);
 INSERT INTO airport VALUES ('HGH','Xiaoshan','CN','Hangzhou','Zhejiang',NULL,30.229503,120.434453,7,8);
 INSERT INTO airport VALUES ('XMN','Gaoqi','CN','Xiamen','Fujian',NULL,24.544036,118.127739,18,8);
 INSERT INTO airport VALUES ('HLD','Dongshan','CN','Hailar','Nei Mongol',NULL,49.204997,119.825,661,8);
 INSERT INTO airport VALUES ('XFN','Xiangfan Airport','CN','Xiangyang','Hubei',NULL,32.1506,112.291,NULL,8);
 INSERT INTO airport VALUES ('HAK','Meilan','CN','Haikou','Hainan','Hainan',19.934856,110.458961,23,8);
 INSERT INTO airport VALUES ('HET','Baita Airport','CN','Hohhot','Nei Mongol',NULL,40.851422,111.824103,1084,8);
 INSERT INTO airport VALUES ('PEK','Capital Intl','CN','Beijing','Beijing',NULL,40.080111,116.584556,35,8);
 INSERT INTO airport VALUES ('PVG','Pudong','CN','Shanghai','Shanghai',NULL,31.143378,121.805214,4,8);
 INSERT INTO airport VALUES ('NGB','Ningbo Lishe','CN','Ningbo','Zhejiang',NULL,29.82,121.46,4,8);
 INSERT INTO airport VALUES ('WXN','Wanzhou Wuqiao Airport','CN','Wanzhou','Sichuan',NULL,30.8361,108.406,567,8);
 INSERT INTO airport VALUES ('WUH','Tianhe','CN','Wuhan','Hubei',NULL,30.783758,114.2081,34,8);
 INSERT INTO airport VALUES ('WUX','Wuxi Airport','CN','Wuxi','Jiangsu',NULL,31.4944,120.429,5,8);
 INSERT INTO airport VALUES ('FOC','Fuzhou Changle','CN','Fuzhou','Fujian',NULL,25.93,119.65,14,8);
 INSERT INTO airport VALUES ('WNZ','Wenzhou Longwan Airport','CN','Wenzhou','Zhejiang',NULL,27.9122,120.852,NULL,8);
 INSERT INTO airport VALUES ('INC','Yinchuan','CN','Yinchuan','Ningxia',NULL,38.481944,106.009167,1098,8);
 INSERT INTO airport VALUES ('ZUH','Zhuhai Airport','CN','Zhuhai','Guangdong',NULL,22.0064,113.376,7,8);
 INSERT INTO airport VALUES ('HRB','Taiping','CN','Harbin','Heilongjiang',NULL,45.623403,126.250328,139,8);
 INSERT INTO airport VALUES ('CGQ','Changchun','CN','Changchun','Jilin',NULL,43.5412,125.1201,69,8);
 INSERT INTO airport VALUES ('CGO','Xinzheng','CN','Zhengzhou','Henan',NULL,34.519672,113.840889,151,8);
 INSERT INTO airport VALUES ('LHW','Lanzhou Airport','CN','Lanzhou','Gansu',NULL,36.117,103.617,1948,8);
 INSERT INTO airport VALUES ('SJW','Shijiazhuang Daguocun International Airport','CN','Shijiazhuang','Hebei',NULL,38.280686,114.6973,71,8);
 INSERT INTO airport VALUES ('CKG','Jiangbei','CN','Chongqing','Chongqing',NULL,29.719217,106.641678,416,8);
 INSERT INTO airport VALUES ('CSX','Huanghua','CN','Changsha','Hunan',NULL,28.189158,113.219633,66,8);
 INSERT INTO airport VALUES ('TGO','Tongliao Airport','CN','Tongliao','Nei Mongol',NULL,43.5567,122.2,730,8);
 INSERT INTO airport VALUES ('KHN','Changbei Intl','CN','Nanchang','Jiangxi',NULL,28.865,115.9,44,8);
 INSERT INTO airport VALUES ('KMG','Wujiaba','CN','Kunming','Yunnan',NULL,24.992364,102.743536,1895,8);
 INSERT INTO airport VALUES ('TSN','Binhai','CN','Tianjin','Tianjin',NULL,39.124353,117.346183,3,8);
 INSERT INTO airport VALUES ('BAV','Baotou Airport','CN','Baotou','Nei Mongol',NULL,40.56,109.997,1013,8);
 INSERT INTO airport VALUES ('NDG','Qiqihar Sanjiazi Airport','CN','Qiqihar','Heilongjiang',NULL,47.239628,123.918131,145,8);
 INSERT INTO airport VALUES ('NNG','Wuxu','CN','Nanning','Guangxi',NULL,22.608267,108.172442,128,8);
 INSERT INTO airport VALUES ('NKG','Lukou','CN','Nanjing','Jiangsu',NULL,31.742042,118.862025,15,8);
 INSERT INTO airport VALUES ('URC','Diwopu','CN','Wulumuqi','Xinjiang',NULL,43.907106,87.474244,648,8);
 INSERT INTO airport VALUES ('NTG','Nantong Airport','CN','Nantong','Jiangsu',NULL,32.0708,120.976,NULL,8);
 INSERT INTO airport VALUES ('MIG','Mianyang Airport','CN','Mianyang','Sichuan',NULL,31.4281,104.741,NULL,8);
 INSERT INTO airport VALUES ('TYN','Wusu','CN','Taiyuan','Shanxi',NULL,37.746897,112.628428,785,8);
 INSERT INTO airport VALUES ('CAN','Baiyun Intl','CN','Guangzhou','Guangdong',NULL,23.392436,113.298786,15,8);
 INSERT INTO airport VALUES ('LZO','Luzhou Airport','CN','Luzhou','Sichuan',NULL,28.8522,105.393,NULL,8);
 INSERT INTO airport VALUES ('LYI','Shubuling Airport','CN','Linyi','Shandong',NULL,35.0461,118.412,NULL,8);
 INSERT INTO airport VALUES ('LXA','Lhasa-Gonggar','CN','Lhasa','Xizang',NULL,29.297778,90.911944,4005,8);
 INSERT INTO airport VALUES ('WEH','Weihai Airport','CN','Weihai','Shandong',NULL,37.1871,122.229,44,8);
 INSERT INTO airport VALUES ('MDG','Mudanjiang','CN','Mudanjiang','Heilongjiang',NULL,44.523889,129.568889,269,8);
 INSERT INTO airport VALUES ('DLC','Zhoushuizi','CN','Dalian','Liaoning',NULL,38.965667,121.5386,33,8);
 INSERT INTO airport VALUES ('TNA','Jinan','CN','Jinan','Shandong',NULL,36.857214,117.215992,23,8);
 INSERT INTO airport VALUES ('SYX','Phoenix International','CN','Sanya','Hainan','Hainan',18.302897,109.412272,28,8);
 INSERT INTO airport VALUES ('KWE','Longdongbao','CN','Guiyang','Guizhou',NULL,26.538522,106.800703,1139,8);
 INSERT INTO airport VALUES ('SZX','Baoan Intl','CN','Shenzhen','Guangdong',NULL,22.639258,113.810664,4,8);
 INSERT INTO airport VALUES ('CTU','Shuangliu','CN','Chengdu','Sichuan',NULL,30.578528,103.947086,495,8);
 INSERT INTO airport VALUES ('YNT','Laishan','CN','Yantai','Shandong',NULL,37.401667,121.371667,18,8);
 INSERT INTO airport VALUES ('YNZ','Yancheng Airport','CN','Yancheng','Jiangsu',NULL,33.3856,120.125,NULL,8);
 INSERT INTO airport VALUES ('YIH','Yichang Airport','CN','Yichang','Hubei',NULL,30.671,111.441,205,8);
 INSERT INTO airport VALUES ('YBP','Yibin','CN','Yibin','Sichuan',NULL,28.800278,104.544444,305,8);
 INSERT INTO airport VALUES ('XUZ','Xuzhou Guanyin Airport','CN','Xuzhou','Jiangsu',NULL,34.16,117.11,43,8);
 INSERT INTO airport VALUES ('XNN','Xining Caojiabao Airport','CN','Xining','Qinghai',NULL,36.5275,102.043,2170,8);
 INSERT INTO airport VALUES ('XIY','Xianyang','CN','Xian','Shaanxi',NULL,34.447119,108.751592,479,8);
 INSERT INTO airport VALUES ('HFE','Luogang','CN','Hefei','Anhui',NULL,31.780019,117.298436,33,8);
 INSERT INTO airport VALUES ('NNY','Nanyang Airport','CN','Nanyang','Henan',NULL,32.9808,112.615,NULL,8);
 INSERT INTO airport VALUES ('CGD','Changde Airport','CN','Changde','Hunan',NULL,28.9189,111.64,NULL,8);
 INSERT INTO airport VALUES ('KHG','Kashi','CN','Kashgar','Xinjiang',NULL,39.542922,76.019956,1381,8);
 INSERT INTO airport VALUES ('KOW','Ganzhou Airport','CN','Ganzhou','Jiangxi',NULL,25.8258,114.912,NULL,8);
 INSERT INTO airport VALUES ('AKU','Aksu Airport','CN','Aksu','Xinjiang',NULL,41.2625,80.2917,1163,8);
 INSERT INTO airport VALUES ('LYA','Luoyang Airport','CN','Luoyang','Henan',NULL,34.41,112.28,64,8);
 INSERT INTO airport VALUES ('LYG','Lianyungang Airport','CN','Lianyungang','Jiangsu',NULL,34.55,119.25,NULL,8);
 INSERT INTO airport VALUES ('LZH','Bailian Airport','CN','Liuzhou','Guangxi',NULL,24.2075,109.391,90,8);
 INSERT INTO airport VALUES ('WEF','Weifang Airport','CN','Weifang','Shandong',NULL,36.6467,119.119,NULL,8);
 INSERT INTO airport VALUES ('CIH','Changzhi Airport','CN','Changzhi','Shanxi',NULL,36.2475,113.126,NULL,8);
 INSERT INTO airport VALUES ('CIF','Chifeng Airport','CN','Chifeng','Nei Mongol',NULL,42.235,118.908,NULL,8);
 INSERT INTO airport VALUES ('DOY','Dongying Airport','CN','Dongying','Shandong',NULL,37.2716,118.2819,26,8);
 INSERT INTO airport VALUES ('NAO','Nanchong Airport','CN','Nanchong','Sichuan',NULL,30.754,106.062,NULL,8);
 INSERT INTO airport VALUES ('JIU','Jiujiang Lushan Airport','CN','Jiujiang','Jiangxi',NULL,29.733,115.983,NULL,8);
 INSERT INTO airport VALUES ('ZHA','Zhanjiang Airport','CN','Zhanjiang','Guangdong',NULL,21.2144,110.358,38,8);
 INSERT INTO airport VALUES ('HSN','Zhoushan Airport','CN','Zhoushan','Zhejiang','Zhoushan',29.9342,122.362,9,8);
 INSERT INTO airport VALUES ('JNZ','Jinzhou Airport','CN','Jinzhou','Liaoning',NULL,41.1014,121.062,NULL,8);
 INSERT INTO airport VALUES ('YIN','Yining Airport','CN','Yining','Xinjiang',NULL,43.9558,81.3303,666,8);
 INSERT INTO airport VALUES ('KWL','Liangjiang','CN','Guilin','Guangxi',NULL,25.218106,110.039197,174,8);
 INSERT INTO airport VALUES ('CZX','Changzhou','CN','Changzhou','Jiangsu',NULL,31.941667,119.711667,12,8);
 INSERT INTO airport VALUES ('SWA','Jieyang Chaoshan International Airport','CN','Shantou','Guangdong',NULL,23.55,116.5,NULL,8);
 INSERT INTO airport VALUES ('DAT','Datong Airport','CN','Datong','Shanxi',NULL,40.0603,113.482,1049,8);
 INSERT INTO airport VALUES ('TAO','Liuting','CN','Qingdao','Shandong',NULL,36.266108,120.374436,10,8);
 INSERT INTO airport VALUES ('DDG','Dandong','CN','Dandong','Liaoning',NULL,40.0255,124.2866,9,8);
 INSERT INTO airport VALUES ('SHE','Shenyang Taoxian International Airport','CN','Shenyang','Liaoning',NULL,41.3824,123.2901,60,8);
 INSERT INTO airport VALUES ('SHA','Hongqiao Intl','CN','Shanghai','Shanghai',NULL,31.197875,121.336319,3,8);
 INSERT INTO airport VALUES ('XCH','Christmas Island','CX','Flying Fish Cove','Christmas Island','Christmas Island',-10.450556,105.690278,279,7);
 INSERT INTO airport VALUES ('CCK','Cocos Keeling Island Airport','CC','West Island','Cocos Islands','Pulau Panjang',-12.1883,96.8339,3,6.5);
 INSERT INTO airport VALUES ('BOG','Eldorado Intl','CO','Bogotá','Bogotá Distrito Especial',NULL,4.701594,-74.146947,2549,-5);
 INSERT INTO airport VALUES ('IBE','Perales','CO','Ibagué','Tolima',NULL,4.421608,-75.1333,914,-5);
 INSERT INTO airport VALUES ('FLA','Gustavo Artunduaga Paredes','CO','Florencia','Caquetá',NULL,1.589189,-75.564372,245,-5);
 INSERT INTO airport VALUES ('AXM','El Eden','CO','Armenia','Quindío',NULL,4.452775,-75.766447,1216,-5);
 INSERT INTO airport VALUES ('MZL','La Nubia','CO','Manizales','Caldas',NULL,5.029597,-75.464708,2095,-5);
 INSERT INTO airport VALUES ('EJA','Yariguies','CO','Barrancabermeja','Santander',NULL,7.024331,-73.8068,126,-5);
 INSERT INTO airport VALUES ('CLO','Alfonso Bonilla Aragon Intl','CO','Cali','Valle de Cauca',NULL,3.543222,-76.381583,964,-5);
 INSERT INTO airport VALUES ('CTG','Rafael Nunez','CO','Cartagena','Bolívar',NULL,10.442381,-75.512961,1,-5);
 INSERT INTO airport VALUES ('SMR','Simon Bolivar','CO','Santa Marta','Magdalena',NULL,11.11965,-74.230647,7,-5);
 INSERT INTO airport VALUES ('BAQ','Ernesto Cortissoz','CO','Barranquilla','Atlántico',NULL,10.889589,-74.780819,30,-5);
 INSERT INTO airport VALUES ('PEI','Matecana','CO','Pereira','Risaralda',NULL,4.812675,-75.739519,1346,-5);
 INSERT INTO airport VALUES ('CUC','Camilo Daza','CO','Cúcuta','Norte de Santander',NULL,7.927567,-72.511547,334,-5);
 INSERT INTO airport VALUES ('BGA','Palonegro','CO','Bucaramanga','Santander',NULL,7.1265,-73.184778,1188,-5);
 INSERT INTO airport VALUES ('ADZ','Gustavo Rojas Pinilla','CO','San Andres','San Andrés, Providencia y Santa Catalina','San Andres',12.583594,-81.711192,6,-5);
 INSERT INTO airport VALUES ('EOH','Olaya Herrera','CO','Medellín','Antioquia',NULL,6.219958,-75.590519,1506,-5);
 INSERT INTO airport VALUES ('HAH','Prince Said Ibrahim','COM','Moroni','Comoros','Grand Comoro',-11.533661,43.27185,28,3);
 INSERT INTO airport VALUES ('PNR','Pointe Noire','RCB','Pointe-Noire','Pointe-Noire',NULL,-4.816028,11.886597,17,1);
 INSERT INTO airport VALUES ('BZV','Maya Maya','RCB','Brazzaville','Brazzaville',NULL,-4.2517,15.253031,320,1);
 INSERT INTO airport VALUES ('CUR','Hato','CUR','Willemstad','Curacao','Curacao',12.188853,-68.959803,9,-4);
 INSERT INTO airport VALUES ('FIH','Ndjili Intl','CGO','Kinshasa','Kinshasa',NULL,-4.38575,15.444569,313,1);
 INSERT INTO airport VALUES ('MJM','Mbuji Mayi','CGO','Mbuji-Mayi','Kasai-Oriental',NULL,-6.121236,23.569008,677,2);
 INSERT INTO airport VALUES ('FBM','Lubumbashi Intl','CGO','Lubumbashi','Haut-Katanga',NULL,-11.591333,27.530889,1309,2);
 INSERT INTO airport VALUES ('RAR','Rarotonga Intl','CK','Avarua','Cook Islands','Rarotonga',-21.202739,-159.805556,6,-10);
 INSERT INTO airport VALUES ('SYQ','Tobias Bolanos International Airport','CR','San José','San José',NULL,9.957053,-84.139797,1002,-6);
 INSERT INTO airport VALUES ('LIR','Daniel Oduber Quiros Intl','CR','Liberia','Guanacaste',NULL,10.593289,-85.544408,82,-6);
 INSERT INTO airport VALUES ('SJO','Juan Santamaria Intl','CR','San José','San José',NULL,9.993861,-84.208806,921,-6);
 INSERT INTO airport VALUES ('ABJ','Abidjan Felix Houphouet Boigny Intl','CI','Abidjan','Abidjan',NULL,5.261386,-3.926294,6,0);
 INSERT INTO airport VALUES ('SPU','Split','HR','Split','Croatia',NULL,43.538944,16.297964,24,1);
 INSERT INTO airport VALUES ('ZAG','Zagreb','HR','Zagreb','Croatia',NULL,45.742931,16.068778,108,1);
 INSERT INTO airport VALUES ('RJK','Rijeka','HR','Rijeka','Croatia',NULL,45.216889,14.570267,85,1);
 INSERT INTO airport VALUES ('ZAD','Zadar','HR','Zadar','Croatia',NULL,44.108269,15.346697,88,1);
 INSERT INTO airport VALUES ('SCU','Antonio Maceo Intl','C','Santiago de Cuba','Santiago de Cuba','Cuba',19.969769,-75.835414,76,-5);
 INSERT INTO airport VALUES ('CMW','Ignacio Agramonte Intl','C','Camagüey','Camagüey','Cuba',21.420428,-77.847433,126,-5);
 INSERT INTO airport VALUES ('HOG','Frank Pais Intl','C','Holguín','Holguín','Cuba',20.785589,-76.315108,110,-5);
 INSERT INTO airport VALUES ('GER','Rafael Cabrera','C','Nueva Gerona','Isla de la Juventud','Cuba',21.834689,-82.783819,24,-5);
 INSERT INTO airport VALUES ('HAV','Jose Marti Intl','C','La Habana','La Habana','Cuba',22.989153,-82.409086,64,-5);
 INSERT INTO airport VALUES ('LCA','Larnaca','CY','Larnaka','Cyprus','Cyprus',34.875117,33.62485,2,2);
 INSERT INTO airport VALUES ('ECN','Ercan International Airport','CY','Nicosia','Cyprus','Cyprus',35.1547,33.4961,123,2);
 INSERT INTO airport VALUES ('KLV','Karlovy Vary','CZ','Karlovy Vary','Karlovarský',NULL,50.202978,12.914983,606,1);
 INSERT INTO airport VALUES ('PED','Pardubice','CZ','Pardubice','Pardubický',NULL,50.013419,15.738647,226,1);
 INSERT INTO airport VALUES ('PRG','Vaclav Havel Airport','CZ','Praha','Praha',NULL,50.100833,14.26,380,1);
 INSERT INTO airport VALUES ('OSR','Mosnov','CZ','Ostrava','Moravskoslezský',NULL,49.696292,18.111053,257,1);
 INSERT INTO airport VALUES ('BRQ','Brno-Tuřany','CZ','Brno','Jihomoravský',NULL,49.1514,16.6944,235,1);
 INSERT INTO airport VALUES ('CPH','Kastrup','DK','Copenhagen','Hovedstaden','Seeland',55.617917,12.655972,5,1);
 INSERT INTO airport VALUES ('AAL','Aalborg','DK','Ålborg','Nordjylland',NULL,57.092789,9.849164,3,1);
 INSERT INTO airport VALUES ('AAR','Aarhus','DK','Århus','Midtjylland',NULL,56.300017,10.619008,25,1);
 INSERT INTO airport VALUES ('RNN','Bornholm Ronne','DK','Ronne','Hovedstaden','Bornholm',55.063267,14.759558,16,1);
 INSERT INTO airport VALUES ('EBJ','Esbjerg','DK','Esbjerg','Syddanmark',NULL,55.525942,8.553403,30,1);
 INSERT INTO airport VALUES ('JIB','Ambouli International Airport','DJI','Djibouti','Djibouti',NULL,11.5472,43.1594,15,3);
 INSERT INTO airport VALUES ('DOM','Melville Hall','WD','Roseau','Dominica','Dominica',15.547028,-61.3,22,-4);
 INSERT INTO airport VALUES ('SDQ','Las Americas Intl','DOM','Santo Domingo','Dominican Republic','Hispaniola',18.429664,-69.668925,18,-4);
 INSERT INTO airport VALUES ('STI','Cibao Intl','DOM','Santiago','Dominican Republic','Hispaniola',19.406092,-70.604689,172,-4);
 INSERT INTO airport VALUES ('DIL','Presidente Nicolau Lobato Intl','TL','Dili','Timor-Leste','Timor',-8.546553,125.524719,8,8);
 INSERT INTO airport VALUES ('GPS','Seymour','EC',NULL,NULL,'Isabela',-0.453758,-90.265914,63,-6);
 INSERT INTO airport VALUES ('GYE','Jose Joaquin De Olmedo Intl','EC','Guayaquil','Ecuador',NULL,-2.157419,-79.883558,6,-5);
 INSERT INTO airport VALUES ('UIO','Mariscal Sucre Intl','EC','Quito','Ecuador',NULL,-0.141144,-78.488214,2813,-5);
 INSERT INTO airport VALUES ('CUE','Mariscal Lamar','EC','Cuenca','Ecuador',NULL,-2.889467,-78.984397,2532,-5);
 INSERT INTO airport VALUES ('HRG','Hurghada Intl','ET','Hurghada','Egypt',NULL,27.178317,33.799436,16,2);
 INSERT INTO airport VALUES ('ASW','Aswan Intl','ET','Aswan','Egypt',NULL,23.964356,32.819975,202,2);
 INSERT INTO airport VALUES ('ATZ','Asyut International Airport','ET','Asyut','Egypt',NULL,27.046508,31.011983,235,2);
 INSERT INTO airport VALUES ('HBE','Borg El Arab Intl','ET','Al Iskandariyah','Egypt',NULL,30.917669,29.696408,54,2);
 INSERT INTO airport VALUES ('CAI','Cairo Intl','ET','Al Qahirah','Egypt',NULL,30.121944,31.405556,116,2);
 INSERT INTO airport VALUES ('LXR','Luxor Intl','ET','Al Uqsur','Egypt',NULL,25.671028,32.706583,90,2);
 INSERT INTO airport VALUES ('ALY','Alexandria Intl','ET','Al Iskandariyah','Egypt',NULL,31.183903,29.948889,-2,2);
 INSERT INTO airport VALUES ('SAL','El Salvador Intl','ES','San Salvador','El Salvador',NULL,13.440947,-89.055728,31,-6);
 INSERT INTO airport VALUES ('SSG','Malabo','GQ','Malabo','Insular','Bioko',3.755267,8.708717,23,1);
 INSERT INTO airport VALUES ('BSG','Bata','GQ','Bata','Continental',NULL,1.9056,9.8056,11,1);
 INSERT INTO airport VALUES ('ASM','Asmara Intl','ER','Asmara','Eritrea',NULL,15.291853,38.910667,2336,3);
 INSERT INTO airport VALUES ('MSW','Massaua','ER','Massaua','Eritrea',NULL,15.68,39.28,59,3);
 INSERT INTO airport VALUES ('TLL','Tallinn-Ulemiste International','EST','Tallinn','Estonia',NULL,59.413317,24.832844,40,2);
 INSERT INTO airport VALUES ('GDQ','Gondar','ETH','Gondar','Amhara',NULL,12.5199,37.434047,1994,3);
 INSERT INTO airport VALUES ('DIR','Dire Dawa Intl','ETH','Dire Dawa','Dire Dawa',NULL,9.6247,41.854203,1167,3);
 INSERT INTO airport VALUES ('ADD','Bole Intl','ETH','Addis Ababa','Addis Ababa',NULL,8.977889,38.799319,2334,3);
 INSERT INTO airport VALUES ('GMB','Gambella','ETH','Gambella','Gambella',NULL,8.128764,34.563131,540,3);
 INSERT INTO airport VALUES ('PSY','Port Stanley','FALK','Stanley','Falkland Islands','East Falkland',-51.6857,-57.7776,23,-3);
 INSERT INTO airport VALUES ('FAE','Vagar','FO','Tórshavn','Faroe Islands','Streymoy',62.063628,-7.277219,85,0);
 INSERT INTO airport VALUES ('SUV','Nausori Intl','FJI','Suva','Fiji','Viti Levu',-18.043267,178.559228,5,12);
 INSERT INTO airport VALUES ('MHQ','Mariehamn','SF','Mariehamn','Åland',NULL,60.122203,19.898156,5,2);
 INSERT INTO airport VALUES ('OUL','Oulu','SF','Oulu','Pohjois-Pohjanmaa',NULL,64.930061,25.354564,14,2);
 INSERT INTO airport VALUES ('HEL','Helsinki Vantaa','SF','Helsinki','Uusimaa',NULL,60.317222,24.963333,55,2);
 INSERT INTO airport VALUES ('POR','Pori','SF','Pori','Satakunta',NULL,61.461686,21.799983,13,2);
 INSERT INTO airport VALUES ('JOE','Joensuu','SF','Joensuu','Pohjols-Karjala',NULL,62.662906,29.60755,121,2);
 INSERT INTO airport VALUES ('RVN','Rovaniemi','SF','Rovaniemi','Lappia',NULL,66.564822,25.830411,196,2);
 INSERT INTO airport VALUES ('JYV','Jyväskylä','SF','Jyväskylä','Keski-Suomi',NULL,62.399453,25.678253,140,2);
 INSERT INTO airport VALUES ('KUO','Kuopio','SF','Kuopio','Pohjois-Savo',NULL,63.00715,27.797756,98,2);
 INSERT INTO airport VALUES ('LPP','Lappeenranta','SF','Lappeenranta','Etelä-Karjala',NULL,61.044553,28.144397,106,2);
 INSERT INTO airport VALUES ('TMP','Tampere Pirkkala','SF','Tampere','Pirkanmaa',NULL,61.414147,23.604392,119,2);
 INSERT INTO airport VALUES ('TKU','Turku','SF','Turku','Varsinais-Suomi',NULL,60.514142,22.262808,49,2);
 INSERT INTO airport VALUES ('VAA','Vaasa','SF','Vaasa','Pohjanmaa',NULL,63.05065,21.762175,6,2);
 INSERT INTO airport VALUES ('MLH','Basel Mulhouse','F','Mulhouse','Grand Est',NULL,47.589583,7.529914,270,1);
 INSERT INTO airport VALUES ('MRS','Provence','F','Marseille','Provence-Alpes-Côte d''Azur',NULL,43.435555,5.213611,23,1);
 INSERT INTO airport VALUES ('MPL','Mediterranee','F','Montpellier','Occitanie',NULL,43.576194,3.963014,5,1);
 INSERT INTO airport VALUES ('CFR','Carpiquet','F','Caen','Normandie',NULL,49.173333,-0.45,78,1);
 INSERT INTO airport VALUES ('ANE','Angers-Loire Airport','F','Angers','Pays de la Loire',NULL,47.5603,-0.312222,59,1);
 INSERT INTO airport VALUES ('ETZ','Metz Nancy Lorraine','F','Metz','Grand Est',NULL,48.982142,6.251319,265,1);
 INSERT INTO airport VALUES ('ORY','Orly','F','Paris','Île-de-France',NULL,48.725278,2.359444,89,1);
 INSERT INTO airport VALUES ('FNI','Garons','F','Nîmes','Occitanie',NULL,43.757444,4.416347,94,1);
 INSERT INTO airport VALUES ('PGF','Rivesaltes','F','Perpignan','Occitanie',NULL,42.740442,2.870667,44,1);
 INSERT INTO airport VALUES ('RNS','St Jacques','F','Rennes','Bretagne',NULL,48.069508,-1.734794,38,1);
 INSERT INTO airport VALUES ('LYS','Saint Exupery','F','Lyon','Auvergne-Rhône-Alpes',NULL,45.726387,5.090833,250,1);
 INSERT INTO airport VALUES ('BOD','Merignac','F','Bordeaux','Nouvelle-Aquitaine',NULL,44.828335,-0.715556,49,1);
 INSERT INTO airport VALUES ('SXB','Entzheim','F','Strasbourg','Grand Est',NULL,48.538319,7.628233,154,1);
 INSERT INTO airport VALUES ('CFE','Auvergne','F','Clermont-Ferrand','Auvergne-Rhône-Alpes',NULL,45.786661,3.169169,332,1);
 INSERT INTO airport VALUES ('LIG','Bellegarde','F','Limoges','Nouvelle-Aquitaine',NULL,45.862778,1.179444,396,1);
 INSERT INTO airport VALUES ('LIL','Lesquin','F','Lille','Hauts-de-France',NULL,50.561942,3.089444,48,1);
 INSERT INTO airport VALUES ('CDG','Charles De Gaulle','F','Paris','Île-de-France',NULL,49.012779,2.55,120,1);
 INSERT INTO airport VALUES ('AJA','Campo Dell Oro','F','Ajaccio','Corse','Corse',41.923637,8.802917,5,1);
 INSERT INTO airport VALUES ('TUF','Val De Loire','F','Tours','Centre-Val de Loire',NULL,47.432222,.727606,109,1);
 INSERT INTO airport VALUES ('TLS','Blagnac','F','Toulouse','Occitanie',NULL,43.629075,1.363819,152,1);
 INSERT INTO airport VALUES ('BES','Guipavas','F','Brest','Bretagne',NULL,48.447911,-4.418539,99,1);
 INSERT INTO airport VALUES ('NCE','Cote d''Azur','F','Nice','Provence-Alpes-Côte d''Azur',NULL,43.658411,7.215872,4,1);
 INSERT INTO airport VALUES ('NTE','Nantes Atlantique','F','Nantes','Pays de la Loire',NULL,47.153189,-1.610725,27,1);
 INSERT INTO airport VALUES ('SBH','Saint Barthelemy','SBAR','Gustavia','Saint Barthelemy','St. Barthelemy',17.9023,-62.8324,15,-4);
 INSERT INTO airport VALUES ('CAY','Rochambeau','GF','Cayenne','French Guiana',NULL,4.819808,-52.360447,8,-3);
 INSERT INTO airport VALUES ('PPT','Faa''a International','PF','Papeete','French Polynesia','Tahiti',-17.556667,-149.611389,2,-10);
 INSERT INTO airport VALUES ('LBV','Leon M Ba','G','Libreville','Gabon',NULL,.4586,9.412283,12,1);
 INSERT INTO airport VALUES ('BJL','Banjul Intl','WAG','Banjul','Gambia',NULL,13.337961,-16.652206,29,0);
 INSERT INTO airport VALUES ('TBS','Tbilisi','GE','Tbilisi','Georgia',NULL,41.669167,44.954722,495,4);
 INSERT INTO airport VALUES ('BUS','Batumi','GE','Batumi','Georgia',NULL,41.610278,41.599694,32,4);
 INSERT INTO airport VALUES ('KUT','Kopitnari','GE','Kutaisi','Georgia',NULL,42.176653,42.482583,68,4);
 INSERT INTO airport VALUES ('HAJ','Hannover','D','Hannover','Niedersachsen',NULL,52.461056,9.685078,56,1);
 INSERT INTO airport VALUES ('HAM','Hamburg','D','Hamburg','Hamburg',NULL,53.630389,9.988228,16,1);
 INSERT INTO airport VALUES ('PAD','Paderborn Lippstadt','D','Paderborn','Nordrhein-Westfalen',NULL,51.614089,8.616317,213,1);
 INSERT INTO airport VALUES ('GWT','Westerland Sylt','D',NULL,NULL,'Sylt',54.91325,8.340472,16,1);
 INSERT INTO airport VALUES ('SCN','Saarbrücken','D','Saarbrücken','Saarland',NULL,49.214553,7.109508,323,1);
 INSERT INTO airport VALUES ('TXL','Tegel','D','Berlin','Berlin',NULL,52.559686,13.287711,37,1);
 INSERT INTO airport VALUES ('BRE','Neuenland','D','Bremen','Bremen',NULL,53.0475,8.786667,4,1);
 INSERT INTO airport VALUES ('SXF','Schönefeld','D','Berlin','Berlin',NULL,52.380001,13.5225,48,1);
 INSERT INTO airport VALUES ('STR','Stuttgart','D','Stuttgart','Baden-Württemberg',NULL,48.689878,9.221964,389,1);
 INSERT INTO airport VALUES ('LBC','Lübeck','D','Lübeck','Schleswig-Holstein',NULL,53.805367,10.719222,16,1);
 INSERT INTO airport VALUES ('LEJ','Leipzig Halle','D','Leipzig','Sachsen',NULL,51.432447,12.241633,142,1);
 INSERT INTO airport VALUES ('CGN','Köln Bonn','D','Köln','Nordrhein-Westfalen',NULL,50.865917,7.142744,92,1);
 INSERT INTO airport VALUES ('HHN','Frankfurt Hahn','D','Frankfurt','Hessen',NULL,49.948672,7.263892,503,1);
 INSERT INTO airport VALUES ('FRA','Frankfurt Main','D','Frankfurt','Hessen',NULL,50.026421,8.543125,111,1);
 INSERT INTO airport VALUES ('FMO','Münster Osnabrück','D','Münster','Nordrhein-Westfalen',NULL,52.134642,7.684831,49,1);
 INSERT INTO airport VALUES ('FKB','Baden Airpark','D','Karlsruhe','Baden-Württemberg',NULL,48.7793,8.08048,124,1);
 INSERT INTO airport VALUES ('DUS','Düsseldorf','D','Düsseldorf','Nordrhein-Westfalen',NULL,51.289453,6.766775,45,1);
 INSERT INTO airport VALUES ('NUE','Nürnberg','D','Nürnberg','Bayern',NULL,49.4987,11.066897,319,1);
 INSERT INTO airport VALUES ('DRS','Dresden','D','Dresden','Sachsen',NULL,51.132767,13.767161,230,1);
 INSERT INTO airport VALUES ('DTM','Dortmund','D','Dortmund','Nordrhein-Westfalen',NULL,51.518314,7.612242,130,1);
 INSERT INTO airport VALUES ('MUC','Franz Josef Strauss','D','München','Bayern',NULL,48.353783,11.786086,453,1);
 INSERT INTO airport VALUES ('ACC','Kotoka Intl','GH','Accra','Greater Accra',NULL,5.605186,-0.166786,63,0);
 INSERT INTO airport VALUES ('GIB','Gibraltar','GBZ','Gibraltar','Gibraltar',NULL,36.151219,-5.349664,5,1);
 INSERT INTO airport VALUES ('HER','Nikos Kazantzakis','GR','Iraklio','Kritis','Crete',35.339719,25.180297,35,2);
 INSERT INTO airport VALUES ('IOA','Ioannina','GR','Ioannina','Ipeiroy',NULL,39.696388,20.8225,475,2);
 INSERT INTO airport VALUES ('JMK','Mikonos','GR',NULL,NULL,'Mykonos',37.435128,25.348103,123,2);
 INSERT INTO airport VALUES ('JKH','Chios','GR',NULL,NULL,'Chios',38.343175,26.140572,5,2);
 INSERT INTO airport VALUES ('RHO','Rhodes Diagoras','GR','Rhodes','Notioy Aigaioy','Rhodos',36.405419,28.086192,5,2);
 INSERT INTO airport VALUES ('ATH','Eleftherios Venizelos Intl','GR','Athina','Attikis',NULL,37.936358,23.944467,94,2);
 INSERT INTO airport VALUES ('EFL','Kefallinia','GR',NULL,NULL,'Kefallinia',38.120069,20.500481,18,2);
 INSERT INTO airport VALUES ('KVA','Megas Alexandros Intl','GR','Kavala','Anatolikis Makedonias kai Thrakis',NULL,40.913306,24.619223,5,2);
 INSERT INTO airport VALUES ('CFU','Ioannis Kapodistrias Intl','GR','Kerkyra','Ionion Nison','Korfu',39.601944,19.911667,2,2);
 INSERT INTO airport VALUES ('SKG','Makedonia','GR','Thessaloniki','Kentrikis Makedonias',NULL,40.519725,22.97095,7,2);
 INSERT INTO airport VALUES ('CHQ','Souda','GR','Chania','Kritis','Crete',35.531747,24.149678,149,2);
 INSERT INTO airport VALUES ('SMI','Samos','GR',NULL,NULL,'Samos',37.689999,26.911667,6,2);
 INSERT INTO airport VALUES ('KGS','Kos','GR',NULL,NULL,'Kos',36.793335,27.091667,126,2);
 INSERT INTO airport VALUES ('MJT','Mitilini','GR','Mytilini','Boreioy Aigaioy','Lesbos',39.056667,26.598333,18,2);
 INSERT INTO airport VALUES ('GPA','Araxos','GR','Patra','Dytikis Elladas',NULL,38.151111,21.425556,14,2);
 INSERT INTO airport VALUES ('ZTH','Dionysios Solomos','GR',NULL,NULL,'Zakynthos',37.750853,20.88425,5,2);
 INSERT INTO airport VALUES ('JIK','Ikaria','GR',NULL,NULL,'Ikaria',37.682717,26.347061,24,2);
 INSERT INTO airport VALUES ('JSY','Syros','GR','Ermoupoli','Notioy Aigaioy','Syros',37.422792,24.950936,72,2);
 INSERT INTO airport VALUES ('GOH','Nuuk','GL','Nuuk','Greenland','Greenland',64.190922,-51.678064,86,-3);
 INSERT INTO airport VALUES ('GND','Point Salines Intl','WG','Saint George''s','Grenada','Grenada',12.004247,-61.786192,13,-4);
 INSERT INTO airport VALUES ('PTP','Le Raizet','GP','Basse-Terre','Guadeloupe','Basse-Terre',16.265306,-61.531806,11,-4);
 INSERT INTO airport VALUES ('GUM','Guam Intl','GU','Hagåtña','Guam','Guam',13.48345,144.795983,91,10);
 INSERT INTO airport VALUES ('GUA','La Aurora','GCA','Ciudad de Guatemala','Guatemala',NULL,14.583272,-90.527475,1510,-6);
 INSERT INTO airport VALUES ('GCI','Guernsey','GBG','Saint Peter Port','Guernsey','Guernsey',49.434956,-2.601969,102,0);
 INSERT INTO airport VALUES ('CKY','Conakry','RG','Conakry','Guinea',NULL,9.576889,-13.611961,22,0);
 INSERT INTO airport VALUES ('OXB','Osvaldo Vieira Intl','GUB','Bissau','Guinea-Bissau',NULL,11.8947,-15.6536,39,0);
 INSERT INTO airport VALUES ('GEO','Cheddi Jagan Intl','GUY','Georgetown','Guyana',NULL,6.498553,-58.254119,29,-4);
 INSERT INTO airport VALUES ('PAP','Toussaint Louverture Intl','RH','Port-au-Prince','Haiti','Hispaniola',18.58005,-72.292542,37,-5);
 INSERT INTO airport VALUES ('TGU','Toncontin Intl','HN','Tegucigalpa','Francisco Morazán',NULL,14.060883,-87.217197,1004,-6);
 INSERT INTO airport VALUES ('HKG','Hong Kong Intl','HK','Hong Kong','Hong Kong',NULL,22.308919,113.914603,9,8);
 INSERT INTO airport VALUES ('BUD','Ferihegy','H','Budapest','Budapest',NULL,47.436933,19.255592,151,1);
 INSERT INTO airport VALUES ('KEF','Keflavik International Airport','IS','Keflavik','Iceland','Iceland',63.985,-22.605556,52,0);
 INSERT INTO airport VALUES ('SXR','Srinagar','IND','Srinagar','Jammu and Kashmir',NULL,33.987139,74.77425,1655,5.5);
 INSERT INTO airport VALUES ('STV','Surat','IND','Surat','Gujarat',NULL,21.114061,72.741792,5,5.5);
 INSERT INTO airport VALUES ('DED','Dehradun','IND','Dehra Dun','Uttarakhand',NULL,30.189689,78.180256,558,5.5);
 INSERT INTO airport VALUES ('DEL','Indira Gandhi Intl','IND','Delhi','Delhi',NULL,28.5665,77.103088,237,5.5);
 INSERT INTO airport VALUES ('LKO','Lucknow','IND','Lucknow','Uttar Pradesh',NULL,26.760594,80.889339,125,5.5);
 INSERT INTO airport VALUES ('CJB','Coimbatore','IND','Coimbatore','Tamil Nadu',NULL,11.030031,77.043383,404,5.5);
 INSERT INTO airport VALUES ('COK','Cochin','IND','Kochi','Kerala',NULL,10.155556,76.391389,2,5.5);
 INSERT INTO airport VALUES ('BHO','Bhopal','IND','Bhopal','Madhya Pradesh',NULL,23.287467,77.337375,524,5.5);
 INSERT INTO airport VALUES ('BLR','Bangalore','IND','Bangalore','Karnataka',NULL,12.949986,77.668206,888,5.5);
 INSERT INTO airport VALUES ('TRZ','Trichy','IND','Tiruchirappalli','Tamil Nadu',NULL,10.765364,78.709722,88,5.5);
 INSERT INTO airport VALUES ('TRV','Thiruvananthapuram Intl','IND','Trivandrum','Kerala',NULL,8.482122,76.920114,5,5.5);
 INSERT INTO airport VALUES ('AJL','Aizawl','IND','Aijal','Mizoram',NULL,23.746603,92.802767,305,5.5);
 INSERT INTO airport VALUES ('CCJ','Calicut','IND','Kozhikode','Kerala',NULL,11.136839,75.9553,104,5.5);
 INSERT INTO airport VALUES ('CCU','Netaji Subhash Chandra Bose Intl','IND','Kolkata','West Bengal',NULL,22.654739,88.446722,5,5.5);
 INSERT INTO airport VALUES ('BBI','Bhubaneshwar','IND','Bhubaneswar','Odisha',NULL,20.244364,85.817781,42,5.5);
 INSERT INTO airport VALUES ('VGA','Vijayawada','IND','Vijayawada','Andhra Pradesh',NULL,16.530433,80.796847,25,5.5);
 INSERT INTO airport VALUES ('VNS','Varanasi','IND','Varanasi','Uttar Pradesh',NULL,25.452358,82.859342,81,5.5);
 INSERT INTO airport VALUES ('DIU','Diu Airport','IND','Daman','Daman and Diu',NULL,20.7131,70.9211,9,5.5);
 INSERT INTO airport VALUES ('VTZ','Visakhapatnam','IND','Visakhapatnam','Andhra Pradesh',NULL,17.721167,83.224483,5,5.5);
 INSERT INTO airport VALUES ('NAG','Dr Ambedkar Intl','IND','Nagpur','Maharashtra',NULL,21.092192,79.047183,315,5.5);
 INSERT INTO airport VALUES ('GOP','Gorakhpur Airport','IND','Gorakhpur','Uttar Pradesh',NULL,26.739708,83.449708,79,5.5);
 INSERT INTO airport VALUES ('GAU','Lokpriya Gopinath Bordoloi International Airport','IND','Gauhati','Assam',NULL,26.106092,91.585939,49,5.5);
 INSERT INTO airport VALUES ('PNQ','Pune','IND','Pune','Maharashtra',NULL,18.582111,73.919697,592,5.5);
 INSERT INTO airport VALUES ('GOI','Goa','IND','Panaji','Goa',NULL,15.380833,73.831422,56,5.5);
 INSERT INTO airport VALUES ('IMF','Imphal','IND','Imphal','Manipur',NULL,24.75995,93.896697,774,5.5);
 INSERT INTO airport VALUES ('IDR','Devi Ahilyabai Holkar','IND','Indore','Madhya Pradesh',NULL,22.721786,75.801086,564,5.5);
 INSERT INTO airport VALUES ('RAJ','Rajkot','IND','Rajkot','Gujarat',NULL,22.309183,70.779525,134,5.5);
 INSERT INTO airport VALUES ('HYD','Hyderabad','IND','Hyderabad','Telangana',NULL,17.453117,78.467586,531,5.5);
 INSERT INTO airport VALUES ('RPR','Raipur','IND','Raipur','Chhattisgarh',NULL,21.180406,81.738753,317,5.5);
 INSERT INTO airport VALUES ('JLR','Jabalpur','IND','Jabalpur','Madhya Pradesh',NULL,23.177817,80.052047,495,5.5);
 INSERT INTO airport VALUES ('RJA','Rajahmundry','IND','Rajahmundry','Andhra Pradesh',NULL,17.110361,81.818208,46,5.5);
 INSERT INTO airport VALUES ('JGA','Jamnagar','IND','Jamnagar','Gujarat',NULL,22.465522,70.012556,21,5.5);
 INSERT INTO airport VALUES ('JDH','Jodhpur','IND','Jodhpur','Rajasthan',NULL,26.251092,73.048869,219,5.5);
 INSERT INTO airport VALUES ('JAI','Jaipur','IND','Jaipur','Rajasthan',NULL,26.824192,75.812161,385,5.5);
 INSERT INTO airport VALUES ('IXZ','Port Blair','IND','Port Blair','Andaman and Nicobar Islands','South Andaman Island',11.641161,92.729744,4,5.5);
 INSERT INTO airport VALUES ('IXR','Birsa Munda','IND','Ranchi','Jharkhand',NULL,23.31425,85.321675,655,5.5);
 INSERT INTO airport VALUES ('IXU','Aurangabad','IND','Aurangabad','Maharashtra',NULL,19.862728,75.398114,583,5.5);
 INSERT INTO airport VALUES ('IXC','Chandigarh','IND','Chandigarh','Chandigarh',NULL,30.673469,76.788542,309,5.5);
 INSERT INTO airport VALUES ('IXA','Agartala','IND','Agartala','Tripura',NULL,23.886978,91.24045,14,5.5);
 INSERT INTO airport VALUES ('IXM','Madurai','IND','Madurai','Tamil Nadu',NULL,9.834508,78.093378,140,5.5);
 INSERT INTO airport VALUES ('IXJ','Jammu','IND','Jammu','Jammu and Kashmir',NULL,32.689142,74.837389,314,5.5);
 INSERT INTO airport VALUES ('ATQ','Amritsar','IND','Amritsar','Punjab',NULL,31.709594,74.797264,230,5.5);
 INSERT INTO airport VALUES ('MAA','Chennai Intl','IND','Chennai','Tamil Nadu',NULL,12.994414,80.180517,16,5.5);
 INSERT INTO airport VALUES ('BOM','Chhatrapati Shivaji Intl','IND','Mumbai','Maharashtra',NULL,19.088686,72.867919,11,5.5);
 INSERT INTO airport VALUES ('AMD','Ahmedabad','IND','Ahmadabad','Gujarat',NULL,23.077242,72.63465,58,5.5);
 INSERT INTO airport VALUES ('IXD','Allahabad','IND','Allahabad','Uttar Pradesh',NULL,25.440064,81.733872,98,5.5);
 INSERT INTO airport VALUES ('BDJ','Syamsudin Noor','RI','Bandjarmasin','Kalimantan Selatan','Borneo',-3.442356,114.762553,20,8);
 INSERT INTO airport VALUES ('KDI','Wolter Monginsidi','RI','Kendari','Sulawesi Tenggara','Sulawesi',-4.081608,122.418231,164,8);
 INSERT INTO airport VALUES ('TKG','Radin Inten II (Branti) Airport','RI','Bandar Lampung','Lampung','Sumatra',-5.242339,105.178939,86,7);
 INSERT INTO airport VALUES ('BTH','Hang Nadim','RI','Batam','Kepulauan Riau','Batam',1.121028,104.118753,38,7);
 INSERT INTO airport VALUES ('KOE','El Tari','RI','Kupang','Nusa Tenggara Timur','Timor',-10.171583,123.671136,102,8);
 INSERT INTO airport VALUES ('TTE','Sultan Babullah','RI','Ternate','Maluku Utara','Ternate',.831414,127.381486,15,9);
 INSERT INTO airport VALUES ('BKS','Fatmawati Soekarno','RI','Bengkulu','Bengkulu','Sumatra',-3.8637,102.339036,15,7);
 INSERT INTO airport VALUES ('AMQ','Pattimura','RI','Ambon','Maluku','Ambon',-3.710264,128.089136,10,9);
 INSERT INTO airport VALUES ('BPN','Sepinggan','RI','Balikpapan','Kalimantan Timur','Borneo',-1.268272,116.894478,4,8);
 INSERT INTO airport VALUES ('MLG','Abdul Rachman Saleh','RI','Malang','Jawa Timur','Java',-7.926556,112.714514,526,7);
 INSERT INTO airport VALUES ('MDC','Sam Ratulangi','RI','Manado','Sulawesi Utara','Sulawesi',1.549447,124.925878,80,8);
 INSERT INTO airport VALUES ('DJJ','Sentani','RI','Jayapura','Papua','New Guinea',-2.576953,140.516372,88,9);
 INSERT INTO airport VALUES ('LOP','Lombok International Airport','RI','Mataram','Nusa Tenggara Barat','Lombok',-8.7573222,116.276675,16,8);
 INSERT INTO airport VALUES ('SRG','Achmad Yani','RI','Semarang','Jawa Tengah','Java',-6.971447,110.374122,4,7);
 INSERT INTO airport VALUES ('DJB','Sultan Thaha','RI','Jambi','Jambi','Sumatra',-1.638017,103.644378,25,7);
 INSERT INTO airport VALUES ('CGK','Soekarno Hatta Intl','RI','Jakarta','DKI Jakarta','Java',-6.125567,106.655897,10,7);
 INSERT INTO airport VALUES ('BDO','Husein Sastranegara','RI','Bandung','Jawa Barat','Java',-6.900625,107.576294,743,7);
 INSERT INTO airport VALUES ('UPG','Hasanuddin','RI','Makassar','Sulawesi Selatan','Sulawesi',-5.061631,119.554042,14,8);
 INSERT INTO airport VALUES ('DPS','Bali Ngurah Rai','RI','Denpasar','Bali','Bali',-8.748169,115.167172,4,8);
 INSERT INTO airport VALUES ('PLW','Mutiara','RI','Palu','Sulawesi Tengah','Sulawesi',-0.918542,119.909642,87,8);
 INSERT INTO airport VALUES ('PGK','Depati Amir','RI','Pangkal Pinang','Kepulauan Bangka Belitung','Bangka',-2.1622,106.139064,33,7);
 INSERT INTO airport VALUES ('PKY','Tjilik Riwut','RI','Palangkaraya','Kalimantan Tengah','Borneo',-2.225128,113.942661,25,7);
 INSERT INTO airport VALUES ('PLM','Sultan Mahmud Badaruddin Ii','RI','Palembang','Sumatera Selatan','Sumatra',-2.89825,104.699903,15,7);
 INSERT INTO airport VALUES ('GTO','Jalaluddin','RI','Gorontalo','Gorontalo','Sulawesi',.637119,122.849858,32,8);
 INSERT INTO airport VALUES ('PNK','Supadio','RI','Pontianak','Kalimantan Barat','Borneo',-0.150711,109.403892,3,7);
 INSERT INTO airport VALUES ('PKU','Sultan Syarif Kasim Ii','RI','Pekanbaru','Riau','Sumatra',.460786,101.444539,31,7);
 INSERT INTO airport VALUES ('PDG','Tabing','RI','Padang','Sumatera Barat','Sumatra',-0.874989,100.351881,3,7);
 INSERT INTO airport VALUES ('JOG','Adi Sutjipto','RI','Yogyakarta','DI Yogyakarta','Java',-7.788181,110.431758,107,7);
 INSERT INTO airport VALUES ('BTJ','Sultan Iskandarmuda','RI','Banda Aceh','Aceh','Sumatra',5.523522,95.420372,20,7);
 INSERT INTO airport VALUES ('MES','Polonia','RI','Medan','Sumatera Utara','Sumatra',3.558056,98.671722,35,7);
 INSERT INTO airport VALUES ('SUB','Juanda','RI','Surabaya','Jawa Timur','Java',-7.379831,112.786858,3,7);
 INSERT INTO airport VALUES ('AWZ','Ahwaz','IR','Ahvaz','Khuzestan',NULL,31.337431,48.76195,20,3.5);
 INSERT INTO airport VALUES ('ABD','Abadan','IR','Abadan','Khuzestan',NULL,30.371111,48.228333,6,3.5);
 INSERT INTO airport VALUES ('SYZ','Shiraz Shahid Dastghaib Intl','IR','Shiraz','Fars',NULL,29.539242,52.589786,1500,3.5);
 INSERT INTO airport VALUES ('IFN','Esfahan Shahid Beheshti Intl','IR','Esfahan','Esfahan',NULL,32.750836,51.861267,1542,3.5);
 INSERT INTO airport VALUES ('IKA','Imam Khomeini','IR','Tehran','Tehran',NULL,35,51,1008,3.5);
 INSERT INTO airport VALUES ('BUZ','Bushehr','IR','Bushehr','Bushehr',NULL,28.944811,50.834637,21,3.5);
 INSERT INTO airport VALUES ('MHD','Mashhad','IR','Mashhad','Khorasan-e-Razavi',NULL,36,59,995,3.5);
 INSERT INTO airport VALUES ('TBZ','Tabriz Intl','IR','Tabriz','East Azarbayejan',NULL,38.133889,46.235,1359,3.5);
 INSERT INTO airport VALUES ('BND','Bandar Abbas Intl','IR','Bandar Abbas','Hormozgan',NULL,27.218317,56.37785,7,3.5);
 INSERT INTO airport VALUES ('NJF','Al Najaf International Airport','IRQ','An Najaf','al-Najaf',NULL,31.991667,44.404167,152,3);
 INSERT INTO airport VALUES ('BSR','Basrah Intl','IRQ','Al Basrah','Basrah',NULL,30.549069,47.662142,3,3);
 INSERT INTO airport VALUES ('EBL','Erbil Intl','IRQ','Arbil','Arbil',NULL,36.237611,43.963158,409,3);
 INSERT INTO airport VALUES ('BGW','Baghdad International Airport','IRQ','Baghdad','Baghdad',NULL,33.262539,44.234578,35,3);
 INSERT INTO airport VALUES ('ISU','Sulaymaniyah International Airport','IRQ','As Sulaymaniyah','As Sulaymaniyah',NULL,35.5608,45.3147,760,3);
 INSERT INTO airport VALUES ('SNN','Shannon','IRL','Limerick','Munster','Ireland',52.701978,-8.924817,14,0);
 INSERT INTO airport VALUES ('ORK','Cork','IRL','Cork','Munster','Ireland',51.841269,-8.491111,153,0);
 INSERT INTO airport VALUES ('DUB','Dublin','IRL','Dublin','Leinster','Ireland',53.421333,-6.270075,74,0);
 INSERT INTO airport VALUES ('IOM','Isle Of Man','GBM','Douglas','Isle of Man','Isle of Man',54.083333,-4.623889,16,0);
 INSERT INTO airport VALUES ('TLV','Ben Gurion','IL','Tel Aviv-Yafo','Tel Aviv',NULL,32.011389,34.886667,41,2);
 INSERT INTO airport VALUES ('MXP','Malpensa','I','Milano','Lombardia',NULL,45.630606,8.728111,234,1);
 INSERT INTO airport VALUES ('FLR','Firenze','I','Firenze','Toscana',NULL,43.809953,11.2051,43,1);
 INSERT INTO airport VALUES ('PMF','Parma','I','Parma','Emilia-Romagna',NULL,44.824483,10.296367,49,1);
 INSERT INTO airport VALUES ('PMO','Palermo','I','Palermo','Sicilia','Sicilia',38.175958,13.091019,20,1);
 INSERT INTO airport VALUES ('PEG','Perugia','I','Perúgia','Umbria',NULL,43.095906,12.513222,211,1);
 INSERT INTO airport VALUES ('GOA','Genova Sestri','I','Génova','Liguria',NULL,44.413333,8.8375,4,1);
 INSERT INTO airport VALUES ('PSA','Pisa','I','Pisa','Toscana',NULL,43.683917,10.39275,2,1);
 INSERT INTO airport VALUES ('PSR','Pescara','I','Pescara','Abruzzo',NULL,42.431656,14.181067,15,1);
 INSERT INTO airport VALUES ('AOI','Falconara','I','Ancona','Marche',NULL,43.616389,13.362222,3,1);
 INSERT INTO airport VALUES ('BRI','Bari','I','Bari','Puglia',NULL,41.138856,16.760594,54,1);
 INSERT INTO airport VALUES ('CAG','Elmas','I','Cágliari','Sardegna','Sardegna',39.251469,9.054283,4,1);
 INSERT INTO airport VALUES ('BZO','Bolzano','I','Bolzano','Trentino-Alto Adige',NULL,46.460194,11.326383,241,1);
 INSERT INTO airport VALUES ('REG','Reggio Calabria','I','Réggio di Calabria','Calabria',NULL,38.071206,15.651556,29,1);
 INSERT INTO airport VALUES ('RMI','Rimini','I','Rímini','Emilia-Romagna',NULL,44.020292,12.611747,13,1);
 INSERT INTO airport VALUES ('NAP','Capodichino','I','Nápoli','Campania',NULL,40.886033,14.290781,90,1);
 INSERT INTO airport VALUES ('VRN','Villafranca','I','Verona','Veneto',NULL,45.395706,10.888533,73,1);
 INSERT INTO airport VALUES ('FCO','Fiumicino','I','Roma','Lazio',NULL,41.804475,12.250797,5,1);
 INSERT INTO airport VALUES ('VCE','Venezia Tessera','I','Venézia','Veneto',NULL,45.505278,12.351944,2,1);
 INSERT INTO airport VALUES ('BGY','Bergamo Orio Al Serio','I','Bérgamo','Lombardia',NULL,45.673889,9.704166,238,1);
 INSERT INTO airport VALUES ('TRN','Torino','I','Torino','Piemonte',NULL,45.200761,7.649631,302,1);
 INSERT INTO airport VALUES ('TRS','Ronchi Dei Legionari','I','Trieste','Friuli-Venezia Giulia',NULL,45.8275,13.472222,11,1);
 INSERT INTO airport VALUES ('BLQ','Bologna','I','Bologna','Emilia-Romagna',NULL,44.535444,11.288667,38,1);
 INSERT INTO airport VALUES ('CTA','Catania Fontanarossa','I','Catánia','Sicilia','Sicilia',37.466781,15.0664,12,1);
 INSERT INTO airport VALUES ('LMP','Lampedusa','I',NULL,NULL,'Lampedusa',35.497914,12.618083,21,1);
 INSERT INTO airport VALUES ('CIA','Ciampino','I','Roma','Lazio',NULL,41.799361,12.594936,130,1);
 INSERT INTO airport VALUES ('LIN','Linate','I','Milano','Lombardia',NULL,45.445103,9.276739,108,1);
 INSERT INTO airport VALUES ('KIN','Norman Manley Intl','JA','Kingston','Jamaica','Jamaica',17.935667,-76.7875,3,-5);
 INSERT INTO airport VALUES ('OKJ','Okayama','J','Okayama','Okayama','Honshu',34.756944,133.855278,246,9);
 INSERT INTO airport VALUES ('OKA','Naha','J','Naha','Okinawa','Okinawa',26.195814,127.645869,4,9);
 INSERT INTO airport VALUES ('OIT','Oita','J','Oita','Oita','Kyushu',33.479444,131.737222,6,9);
 INSERT INTO airport VALUES ('GAJ','Yamagata','J','Yamagata','Yamagata','Honshu',38.411894,140.371331,108,9);
 INSERT INTO airport VALUES ('FUK','Fukuoka','J','Fukuoka','Fukuoka','Kyushu',33.585942,130.450686,10,9);
 INSERT INTO airport VALUES ('FKS','Fukushima Airport','J','Fukushima','Fukushima','Honshu',37.2274,140.431,372,9);
 INSERT INTO airport VALUES ('HIJ','Hiroshima','J','Hiroshima','Hiroshima','Honshu',34.436111,132.919444,332,9);
 INSERT INTO airport VALUES ('HND','Tokyo Intl','J','Tokyo','Tokyo','Honshu',35.552258,139.779694,11,9);
 INSERT INTO airport VALUES ('HKD','Hakodate','J','Hakodate','Hokkaido','Hokkaido',41.77,140.821944,46,9);
 INSERT INTO airport VALUES ('HSG','Saga Airport','J','Saga','Saga','Kyushu',33.1497,130.302,2,9);
 INSERT INTO airport VALUES ('ITM','Osaka Intl','J','Osaka','Osaka','Honshu',34.785528,135.438222,15,9);
 INSERT INTO airport VALUES ('AXT','Akita','J','Akita','Akita','Honshu',39.615556,140.218611,95,9);
 INSERT INTO airport VALUES ('TOY','Toyama','J','Toyama','Toyama','Honshu',36.648333,137.1875,29,9);
 INSERT INTO airport VALUES ('AOJ','Aomori','J','Aomori','Aomori','Honshu',40.734722,140.690833,202,9);
 INSERT INTO airport VALUES ('CTS','New Chitose','J','Sapporo','Hokkaido','Hokkaido',42.7752,141.692283,25,9);
 INSERT INTO airport VALUES ('TAK','Takamatsu','J','Takamatsu','Kagawa','Shikoku',34.214167,134.015556,185,9);
 INSERT INTO airport VALUES ('SDJ','Sendai','J','Sendai','Miyagi','Honshu',38.139722,140.916944,5,9);
 INSERT INTO airport VALUES ('KIX','Kansai','J','Osaka','Osaka','Honshu',34.4347222,135.244167,15,9);
 INSERT INTO airport VALUES ('KIJ','Niigata','J','Niigata','Niigata','Honshu',37.5711,139.0646,2,9);
 INSERT INTO airport VALUES ('KOJ','Kagoshima','J','Kagoshima','Kagoshima','Kyushu',31.803397,130.719408,276,9);
 INSERT INTO airport VALUES ('TTJ','Tottori','J','Tottori','Tottori','Honshu',35.530069,134.166553,20,9);
 INSERT INTO airport VALUES ('KMI','Miyazaki','J','Miyazaki','Miyazaki','Kyushu',31.877222,131.448611,6,9);
 INSERT INTO airport VALUES ('KMQ','Komatsu','J','Kanazawa','Ishikawa','Honshu',36.394611,136.406544,11,9);
 INSERT INTO airport VALUES ('KMJ','Kumamoto','J','Kumamoto','Kumamoto','Kyushu',32.837319,130.85505,196,9);
 INSERT INTO airport VALUES ('TKS','Tokushima','J','Tokushima','Tokushima','Shikoku',34.132808,134.606639,8,9);
 INSERT INTO airport VALUES ('KCZ','Kochi','J','Kochi','Kochi','Shikoku',33.546111,133.669444,13,9);
 INSERT INTO airport VALUES ('KKJ','New Kitakyushu','J','Kitakyushu','Fukuoka','Kyushu',33.845942,131.034689,6,9);
 INSERT INTO airport VALUES ('NGO','Chubu Centrair Intl','J','Nagoya','Aichi','Honshu',34.858414,136.805408,5,9);
 INSERT INTO airport VALUES ('NGS','Nagasaki','J','Nagasaki','Nagasaki','Kyushu',32.916944,129.913611,5,9);
 INSERT INTO airport VALUES ('UKB','Kobe','J','Kobe','Hyogo','Honshu',34.632778,135.223889,7,9);
 INSERT INTO airport VALUES ('NRT','Narita Intl','J','Tokyo','Tokyo','Honshu',35.764722,140.386389,43,9);
 INSERT INTO airport VALUES ('UBJ','Yamaguchi Ube','J','Yamaguchi','Yamaguchi','Honshu',33.93,131.278611,7,9);
 INSERT INTO airport VALUES ('MYJ','Matsuyama','J','Matsuyama','Ehime','Shikoku',33.827222,132.699722,8,9);
 INSERT INTO airport VALUES ('FSZ','Mt. Fuji Shizuoka Airport','J','Shizuoka','Shizuoka','Honshu',34.796111,138.189444,132,9);
 INSERT INTO airport VALUES ('JER','Jersey','GBJ','Saint Helier','Jersey','Jersey',49.207947,-2.195508,84,0);
 INSERT INTO airport VALUES ('AMM','Queen Alia Intl','JOR','Amman','Jordan',NULL,31.722556,35.993214,730,2);
 INSERT INTO airport VALUES ('PLX','Semipalatinsk','KZ','Semei','East-Kazakhstan',NULL,50.3513,80.2344,232,6);
 INSERT INTO airport VALUES ('URA','Uralsk','KZ','Oral','West Kazakhstan',NULL,51.150833,51.543056,38,5);
 INSERT INTO airport VALUES ('GUW','Atyrau','KZ','Atyrau','Atyrau',NULL,47.121944,51.821389,-22,5);
 INSERT INTO airport VALUES ('SCO','Aktau','KZ','Aktau','Mangistau',NULL,43.513557,51.052817,6,5);
 INSERT INTO airport VALUES ('DZN','Zhezkazgan Airport','KZ','Zhezkazgan','Karaganda',NULL,47.708333,67.733333,381,6);
 INSERT INTO airport VALUES ('KSN','Kostanay West Airport','KZ','Kustanay','Kostanai',NULL,53.206944,63.550278,181,6);
 INSERT INTO airport VALUES ('UKK','Ust Kamenogorsk Airport','KZ','Öskemen','East-Kazakhstan',NULL,50.0366,82.4942,286,6);
 INSERT INTO airport VALUES ('CIT','Shymkent','KZ','Shymkent','South-Kazakhstan',NULL,42.364167,69.478889,422,6);
 INSERT INTO airport VALUES ('AKX','Aktyubinsk','KZ','Aqtobe','Aktobe',NULL,50.245833,57.206667,225,5);
 INSERT INTO airport VALUES ('ALA','Almaty','KZ','Almaty','Almaty City',NULL,43.352072,77.040508,681,6);
 INSERT INTO airport VALUES ('TSE','Astana Intl','KZ','Astana','Astana',NULL,51.022222,71.466944,355,6);
 INSERT INTO airport VALUES ('KGF','Sary-Arka','KZ','Karaganda','Karaganda',NULL,49.670833,73.334444,538,6);
 INSERT INTO airport VALUES ('PWQ','Pavlodar','KZ','Pavlodar','Pavlodar',NULL,52.195,77.073889,125,6);
 INSERT INTO airport VALUES ('KZO','Kzylorda','KZ','Kyzylorda','Kyzylorda',NULL,44.709,65.591,131,6);
 INSERT INTO airport VALUES ('MYD','Malindi Airport','EAK','Malindi','Kenya',NULL,-3.22931,40.1017,24,3);
 INSERT INTO airport VALUES ('MBA','Mombasa Moi Intl','EAK','Mombasa','Kenya',NULL,-4.034833,39.59425,61,3);
 INSERT INTO airport VALUES ('NBO','Jomo Kenyatta International','EAK','Nairobi','Kenya',NULL,-1.319167,36.9275,1624,3);
 INSERT INTO airport VALUES ('WIL','Nairobi Wilson','EAK','Nairobi','Kenya',NULL,-1.321719,36.814833,1691,3);
 INSERT INTO airport VALUES ('KIS','Kisumu','EAK','Kisumu','Kenya',NULL,-0.086139,34.728892,1157,3);
 INSERT INTO airport VALUES ('EDL','Eldoret Intl','EAK','Eldoret','Kenya',NULL,.404458,35.238928,2116,3);
 INSERT INTO airport VALUES ('TRW','Bonriki Intl','KIR','Tarawa','Kiribati','Tarawa',1.3817,-173.1442,3,14);
 INSERT INTO airport VALUES ('KWI','Kuwait Intl','KWT','Al Kuwayt','Kuwait',NULL,29.226567,47.968928,63,3);
 INSERT INTO airport VALUES ('FRU','Manas','KG','Bishkek','Kyrgyzstan',NULL,43.061306,74.477556,627,5);
 INSERT INTO airport VALUES ('OSS','Osh','KG','Osh','Kyrgyzstan',NULL,40.608989,72.793269,892,5);
 INSERT INTO airport VALUES ('VTE','Wattay Intl','LAO','Vientiane','Laos',NULL,17.988322,102.563256,172,7);
 INSERT INTO airport VALUES ('RIX','Riga Intl','LV','Rīga','Latvia',NULL,56.923611,23.971111,10,2);
 INSERT INTO airport VALUES ('BEY','Rafic Hariri Intl','RL','Bayrūt','Lebanon',NULL,33.820931,35.488389,27,2);
 INSERT INTO airport VALUES ('MSU','Moshoeshoe I Intl','LS','Maseru','Lesotho',NULL,-29.462256,27.552503,1630,2);
 INSERT INTO airport VALUES ('ROB','Monrovia Roberts Intl','LB','Monrovia','Liberia',NULL,6.233789,-10.362311,9,0);
 INSERT INTO airport VALUES ('BEN','Benina','LAR','Benghazi','Libya',NULL,32.096786,20.269472,132,1);
 INSERT INTO airport VALUES ('MRA','Misratah Airport','LAR','Misratah','Libya',NULL,32.325,15.061,18,1);
 INSERT INTO airport VALUES ('TIP','Tripoli Intl','LAR','Tripoli','Libya',NULL,32.663544,13.159011,80,1);
 INSERT INTO airport VALUES ('KUN','Kaunas Intl','LT','Kaunas','Lithuania',NULL,54.963919,24.084778,78,2);
 INSERT INTO airport VALUES ('VNO','Vilnius Intl','LT','Vilnius','Lithuania',NULL,54.634133,25.285767,197,2);
 INSERT INTO airport VALUES ('LUX','Luxembourg','L','Luxembourg','Luxembourg',NULL,49.626575,6.211517,376,1);
 INSERT INTO airport VALUES ('MFM','Macao Intl','MAC','Macao','Macau',NULL,22.149556,113.591558,6,8);
 INSERT INTO airport VALUES ('SKP','Skopje','MK','Skopje','North Macedonia',NULL,41.961622,21.621381,238,1);
 INSERT INTO airport VALUES ('DIE','Arrachart','RM','Antsiranana','Madagascar','Madagaskar',-12.3494,49.291747,114,3);
 INSERT INTO airport VALUES ('TLE','Toliara','RM','Toliara','Madagascar','Madagaskar',-23.383369,43.728453,9,3);
 INSERT INTO airport VALUES ('TNR','Ivato','RM','Antananarivo','Madagascar','Madagaskar',-18.79695,47.478806,1280,3);
 INSERT INTO airport VALUES ('TMM','Toamasina','RM','Tamatave','Madagascar','Madagaskar',-18.109517,49.392536,7,3);
 INSERT INTO airport VALUES ('BLZ','Chileka Intl','MW','Blantyre','Malawi',NULL,-15.679053,34.974014,779,2);
 INSERT INTO airport VALUES ('LLW','Kamuzu Intl','MW','Lilongwe','Malawi',NULL,-13.789378,33.781,1230,2);
 INSERT INTO airport VALUES ('PEN','Penang Intl','MAL','Georgetown','Pulau Pinang',NULL,5.297139,100.276864,3,8);
 INSERT INTO airport VALUES ('TGG','Sultan Mahmud','MAL','Kuala Terengganu','Terengganu',NULL,5.382639,103.10336,6,8);
 INSERT INTO airport VALUES ('SDK','Sandakan','MAL','Sandakan','Sabah','Borneo',5.900897,118.059486,14,8);
 INSERT INTO airport VALUES ('BKI','Kota Kinabalu Intl','MAL','Kota Kinabalu','Sabah','Borneo',5.937208,116.051181,3,8);
 INSERT INTO airport VALUES ('JHB','Sultan Ismail','MAL','Johor Bahru','Johor',NULL,1.641308,103.669619,41,8);
 INSERT INTO airport VALUES ('KCH','Kuching Intl','MAL','Kuching Utara','Sarawak','Borneo',1.484697,110.346933,27,8);
 INSERT INTO airport VALUES ('IPH','Sultan Azlan Shah','MAL','Ipoh','Perak',NULL,4.567972,101.092194,40,8);
 INSERT INTO airport VALUES ('KBR','Sultan Ismail Petra','MAL','Kota Bahru','Kelantan',NULL,6.16685,102.293014,5,8);
 INSERT INTO airport VALUES ('SZB','Sultan Abdul Aziz Shah Intl','MAL','Kuala Lumpur','Kuala Lumpur',NULL,3.130583,101.549333,27,8);
 INSERT INTO airport VALUES ('KUA','Kuantan','MAL','Kuantan','Pahang',NULL,3.775389,103.209056,18,8);
 INSERT INTO airport VALUES ('KUL','Kuala Lumpur Intl','MAL','Kuala Lumpur','Kuala Lumpur',NULL,2.745578,101.709917,21,8);
 INSERT INTO airport VALUES ('LBU','Labuan','MAL','Labuan','Labuan','Labuan',5.300683,115.250181,31,8);
 INSERT INTO airport VALUES ('MLE','Male Intl','MV','Male','Maldives','Male',4.191833,73.529128,2,5);
 INSERT INTO airport VALUES ('BKO','Senou','RMM','Bamako','Bamako',NULL,12.533544,-7.949944,380,0);
 INSERT INTO airport VALUES ('MLA','Luqa','M','Valletta','Malta','Malta',35.857497,14.4775,91,1);
 INSERT INTO airport VALUES ('MAJ','Marshall Islands Intl','MH','Majuro','Marshall Islands','Majuro',7.064758,171.272022,2,12);
 INSERT INTO airport VALUES ('FDF','Le Lamentin','MQ','Fort-de-France','Martinique','Martinique',14.591033,-61.003175,5,-4);
 INSERT INTO airport VALUES ('NKC','Nouakchott','RIM','Nouakchott','Nouakchott',NULL,18.097856,-15.947956,2,0);
 INSERT INTO airport VALUES ('NDB','Nouadhibou','RIM','Nouadhibou','Dakhlet Nouadhibou',NULL,20.933067,-17.029956,5,0);
 INSERT INTO airport VALUES ('MRU','Sir Seewoosagur Ramgoolam Intl','MS','Port Louis','Mauritius','Mauritius',-20.430235,57.6836,57,5);
 INSERT INTO airport VALUES ('DZA','Dzaoudzi Pamandzi','MYT','Mamoutzou','Mayotte','Mayotte',-12.804722,45.281113,7,3);
 INSERT INTO airport VALUES ('MAM','General Servando Canales Intl','MEX','Matamoros','Tamaulipas',NULL,25.769894,-97.525311,8,-6);
 INSERT INTO airport VALUES ('CPE','Ingeniero Alberto Acuna Ongay Intl','MEX','Campeche','Campeche',NULL,19.816794,-90.500314,10,-6);
 INSERT INTO airport VALUES ('CLQ','Colima','MEX','Colima','Colima',NULL,19.277011,-103.577397,752,-6);
 INSERT INTO airport VALUES ('UPN','Licenciado Y Gen Ignacio Lopez Rayon','MEX','Uruapan','Michoacán',NULL,19.396692,-102.039056,1603,-6);
 INSERT INTO airport VALUES ('TGZ','Angel Albino Corzo','MEX','Tuxtla Gutiérrez','Chiapas',NULL,16.561822,-93.026081,455,-6);
 INSERT INTO airport VALUES ('TIJ','General Abelardo L Rodriguez Intl','MEX','Tijuana','Baja California',NULL,32.541064,-116.970158,149,-8);
 INSERT INTO airport VALUES ('VER','General Heriberto Jara Intl','MEX','Veracruz','Veracruz',NULL,19.145931,-96.187267,27,-6);
 INSERT INTO airport VALUES ('NLD','Quetzalcoatl Intl','MEX','Nuevo Laredo','Tamaulipas',NULL,27.443918,-99.57046,148,-6);
 INSERT INTO airport VALUES ('MID','Licenciado Manuel Crescencio Rejon Int','MEX','Mérida','Yucatán',NULL,20.936981,-89.657672,12,-6);
 INSERT INTO airport VALUES ('MTY','General Mariano Escobedo Intl','MEX','Monterrey','Nuevo Léon',NULL,25.778489,-100.106878,390,-6);
 INSERT INTO airport VALUES ('MTT','Minatitlan','MEX','Minatitlán','Veracruz',NULL,18.103419,-94.580681,11,-6);
 INSERT INTO airport VALUES ('VSA','C P A Carlos Rovirosa Intl','MEX','Villahermosa','Tabasco',NULL,17.997,-92.817361,14,-6);
 INSERT INTO airport VALUES ('MXL','General Rodolfo Sanchez Taboada Intl','MEX','Mexicali','Baja California',NULL,32.630634,-115.241637,23,-8);
 INSERT INTO airport VALUES ('PBC','Hermanos Serdan Intl','MEX','Puebla','Puebla',NULL,19.158144,-98.371447,2244,-6);
 INSERT INTO airport VALUES ('ZCL','General Leobardo C Ruiz Intl','MEX','Zacatecas','Zacatecas',NULL,22.897112,-102.68689,2177,-6);
 INSERT INTO airport VALUES ('JAL','Lencero Airport','MEX','Xalapa-Enríquez','Veracruz',NULL,19.475083,-96.797506,953,-6);
 INSERT INTO airport VALUES ('QRO','Queretaro Intercontinental','MEX','Querétaro','Querétaro',NULL,20.617289,-100.185658,1920,-6);
 INSERT INTO airport VALUES ('TLC','Licenciado Adolfo Lopez Mateos Intl','MEX','Toluca','México, Estado de',NULL,19.337072,-99.566008,2581,-6);
 INSERT INTO airport VALUES ('TPQ','Tepic','MEX','Tepic','Nayarit',NULL,21.419453,-104.842581,921,-6);
 INSERT INTO airport VALUES ('CVM','General Pedro Jose Mendez Intl','MEX','Ciudad Victoria','Tamaulipas',NULL,23.703336,-98.956486,232,-6);
 INSERT INTO airport VALUES ('SLP','Ponciano Arriaga Intl','MEX','San Luis Potosí','San Luis Potosí',NULL,22.254303,-100.930806,1840,-6);
 INSERT INTO airport VALUES ('MLM','General Francisco J Mujica Intl','MEX','Morelia','Michoacán',NULL,19.849944,-101.0255,1839,-6);
 INSERT INTO airport VALUES ('DGO','Durango Intl','MEX','Durango','Durango',NULL,24.124194,-104.528014,1861,-6);
 INSERT INTO airport VALUES ('GDL','Don Miguel Hidalgo Y Costilla Intl','MEX','Guadalajara','Jalisco',NULL,20.5218,-103.311167,1529,-6);
 INSERT INTO airport VALUES ('OAX','Xoxocotlan Intl','MEX','Oaxaca','Oaxaca',NULL,16.999906,-96.726639,1521,-6);
 INSERT INTO airport VALUES ('HMO','General Ignacio P Garcia Intl','MEX','Hermosillo','Sonora',NULL,29.095858,-111.047858,191,-7);
 INSERT INTO airport VALUES ('REX','General Lucio Blanco Intl','MEX','Reynosa','Tamaulipas',NULL,26.008908,-98.228513,42,-6);
 INSERT INTO airport VALUES ('MEX','Licenciado Benito Juarez Intl','MEX','Ciudad de México','Distrito Federal',NULL,19.436303,-99.072097,2230,-6);
 INSERT INTO airport VALUES ('MZT','General Rafael Buelna Intl','MEX','Mazatlán','Sinaloa',NULL,23.161356,-106.266072,12,-7);
 INSERT INTO airport VALUES ('CUU','General R Fierro Villalobos Intl','MEX','Chihuahua','Chihuahua',NULL,28.702875,-105.964567,1360,-6);
 INSERT INTO airport VALUES ('CUN','Cancun Intl','MEX','Cancún','Quintana Roo',NULL,21.036528,-86.877083,6,-5);
 INSERT INTO airport VALUES ('CTM','Chetumal Intl','MEX','Chetumal','Quintana Roo',NULL,18.504667,-88.326847,12,-5);
 INSERT INTO airport VALUES ('CUL','Culiacan Intl','MEX','Culiacán','Sinaloa',NULL,24.764547,-107.474717,33,-7);
 INSERT INTO airport VALUES ('TAP','Tapachula Intl','MEX','Tapachula','Chiapas',NULL,14.794339,-92.370025,30,-6);
 INSERT INTO airport VALUES ('TAM','General Francisco Javier Mina Intl','MEX','Tampico','Tamaulipas',NULL,22.29645,-97.865931,24,-6);
 INSERT INTO airport VALUES ('LAP','General Manuel Marquez De Leon Intl','MEX','La Paz','Baja California Sur',NULL,24.072694,-110.362475,21,-7);
 INSERT INTO airport VALUES ('CEN','Ciudad Obregon Intl','MEX','Ciudad Obregón','Sonora',NULL,27.392639,-109.833111,63,-7);
 INSERT INTO airport VALUES ('LMM','Valle Del Fuerte Intl','MEX','Los Mochis','Sinaloa',NULL,25.685194,-109.080806,5,-7);
 INSERT INTO airport VALUES ('SLW','Plan De Guadalupe Intl','MEX','Saltillo','Coahuila',NULL,25.549497,-100.928669,1457,-6);
 INSERT INTO airport VALUES ('AGU','Jesus Teran Intl','MEX','Aguascalientes','Aguascalientes',NULL,21.705558,-102.317858,1863,-6);
 INSERT INTO airport VALUES ('TRC','Torreon Intl','MEX','Torreón','Coahuila',NULL,25.568278,-103.410583,1124,-6);
 INSERT INTO airport VALUES ('ACA','General Juan N Alvarez Intl','MEX','Acapulco','Guerrero',NULL,16.757061,-99.753953,5,-6);
 INSERT INTO airport VALUES ('PNI','Pohnpei Intl','FSM','Palikir','Micronesia','Pohnpei',6.9851,158.208989,3,11);
 INSERT INTO airport VALUES ('KIV','Chisinau Intl','MD','Chişinău','Moldova',NULL,46.927744,28.930978,122,2);
 INSERT INTO airport VALUES ('ULN','Chinggis Khaan Intl','MNG','Ulaanbaatar','Mongolia',NULL,47.843056,106.766639,1330,8);
 INSERT INTO airport VALUES ('TGD','Podgorica','MNE','Podgorica','Montenegro',NULL,42.359392,19.251894,43,1);
 INSERT INTO airport VALUES ('MNI','John A. Osborne','MNTS','Brades','Montserrat','Montserrat',16.7914,-62.1933,168,-4);
 INSERT INTO airport VALUES ('OUD','Angads','MA','Oujda','Oriental',NULL,34.78715,-1.923986,468,0);
 INSERT INTO airport VALUES ('AGA','Inezgane','MA','Agadir','Souss Massa Daraa',NULL,30.381353,-9.546311,27,0);
 INSERT INTO airport VALUES ('TNG','Ibn Batouta','MA','Tanger','Tanger Tetouan',NULL,35.726917,-5.916889,19,0);
 INSERT INTO airport VALUES ('RAK','Menara','MA','Marrakech','Marrakech Tensift Al Haouz',NULL,31.606886,-8.0363,471,0);
 INSERT INTO airport VALUES ('CMN','Mohammed V Intl','MA','Casablanca','Grand Casablanca',NULL,33.367467,-7.589967,200,0);
 INSERT INTO airport VALUES ('AHU','Cherif El Idrissi','MA','Al Hoceima','Taza Al Hoceima Taounate',NULL,35.177103,-3.839525,29,0);
 INSERT INTO airport VALUES ('RBA','Sale','MA','Rabat','Rabat Sale Zemmour Zaer',NULL,34.051467,-6.751519,84,0);
 INSERT INTO airport VALUES ('FEZ','Saiss','MA','Fès','Fes Boulemane',NULL,33.927261,-4.977958,579,0);
 INSERT INTO airport VALUES ('VPY','Chimoio Airport','MOC','Chimoio','Manica',NULL,-19.151267,33.428958,697,2);
 INSERT INTO airport VALUES ('APL','Nampula','MOC','Nampula','Nampula',NULL,-15.105611,39.2818,440,2);
 INSERT INTO airport VALUES ('TET','Tete Chingodzi','MOC','Tete','Tete',NULL,-16.104817,33.640181,160,2);
 INSERT INTO airport VALUES ('BEW','Beira','MOC','Beira','Sofala',NULL,-19.796419,34.907556,10,2);
 INSERT INTO airport VALUES ('UEL','Quelimane','MOC','Quelimane','Zambézia',NULL,-17.8555,36.869106,11,2);
 INSERT INTO airport VALUES ('INH','Inhambane','MOC','Inhambane','Inhambane',NULL,-23.876431,35.408544,9,2);
 INSERT INTO airport VALUES ('POL','Pemba','MOC','Pemba','Cabo Delgado',NULL,-12.986753,40.522492,101,2);
 INSERT INTO airport VALUES ('MPM','Maputo','MOC','Maputo','Cidade de Maputo',NULL,-25.920836,32.572606,44,2);
 INSERT INTO airport VALUES ('VXC','Lichinga','MOC','Lichinga','Niassa',NULL,-13.273986,35.266262,1373,2);
 INSERT INTO airport VALUES ('WDH','Windhoek Hosea Kutako International Airport','NAM','Windhoek','Namibia',NULL,-22.486667,17.4625,1720,1);
 INSERT INTO airport VALUES ('KTM','Tribhuvan Intl','NEP','Kathmandu','Nepal',NULL,27.696583,85.3591,1338,5.75);
 INSERT INTO airport VALUES ('RTM','Rotterdam','NL','Rotterdam','Zuid-Holland',NULL,51.956944,4.437222,-5,1);
 INSERT INTO airport VALUES ('EIN','Eindhoven','NL','Eindhoven','Noord-Brabant',NULL,51.450139,5.374528,23,1);
 INSERT INTO airport VALUES ('MST','Maastricht','NL','Maastricht','Limburg',NULL,50.911658,5.770144,114,1);
 INSERT INTO airport VALUES ('AMS','Schiphol','NL','Amsterdam','Noord-Holland',NULL,52.308613,4.763889,-3,1);
 INSERT INTO airport VALUES ('INU','Nauru Intl','NAU','Yaren','Nauru','Nauru',-0.5475,166.9192,7,12);
 INSERT INTO airport VALUES ('NOU','La Tontouta','NCL','Noumea','New Caledonia','Grande Terre',-22.014553,166.212972,16,11);
 INSERT INTO airport VALUES ('HLZ','Hamilton','NZ','Hamilton','New Zealand','Te Ika-a-Maui (North Island)',-37.866661,175.332056,52,12);
 INSERT INTO airport VALUES ('WLG','Wellington Intl','NZ','Wellington','New Zealand','Te Ika-a-Maui (North Island)',-41.327221,174.805278,13,12);
 INSERT INTO airport VALUES ('CHC','Christchurch Intl','NZ','Christchurch','New Zealand','Te Waka-a-Maui (South Island)',-43.489358,172.532225,38,12);
 INSERT INTO airport VALUES ('AKL','Auckland Intl','NZ','Auckland','New Zealand','Te Ika-a-Maui (North Island)',-37.008056,174.791667,7,12);
 INSERT INTO airport VALUES ('DUD','Dunedin','NZ','Dunedin','New Zealand','Te Waka-a-Maui (South Island)',-45.928055,170.198333,1,12);
 INSERT INTO airport VALUES ('MGA','Managua Intl','NIC','Managua','Nicaragua',NULL,12.141494,-86.168178,59,-6);
 INSERT INTO airport VALUES ('NIM','Diori Hamani','RN','Niamey','Niamey',NULL,13.481547,2.183614,223,1);
 INSERT INTO airport VALUES ('MIU','Maiduguri','NGR','Maiduguri','Borno',NULL,11.855347,13.08095,335,1);
 INSERT INTO airport VALUES ('PHC','Port Harcourt Intl','NGR','Port Harcourt','Rivers',NULL,5.015494,6.949594,27,1);
 INSERT INTO airport VALUES ('JOS','Yakubu Gowon','NGR','Jos','Plateau',NULL,9.639828,8.86905,1290,1);
 INSERT INTO airport VALUES ('SKO','Sadiq Abubakar Iii Intl','NGR','Sokoto','Sokoto',NULL,12.916322,5.207189,308,1);
 INSERT INTO airport VALUES ('LOS','Murtala Muhammed','NGR','Lagos','Lagos',NULL,6.577369,3.321156,41,1);
 INSERT INTO airport VALUES ('BNI','Benin','NGR','Benin','Edo',NULL,6.316981,5.599503,79,1);
 INSERT INTO airport VALUES ('KAD','Kaduna','NGR','Kaduna','Kaduna',NULL,10.696025,7.320114,632,1);
 INSERT INTO airport VALUES ('KAN','Mallam Aminu Intl','NGR','Kano','Kano',NULL,12.047589,8.524622,476,1);
 INSERT INTO airport VALUES ('CBQ','Calabar','NGR','Calabar','Cross River',NULL,4.976019,8.347197,64,1);
 INSERT INTO airport VALUES ('ABV','Nnamdi Azikiwe Intl','NGR','Abuja','Abuja',NULL,9.006792,7.263172,342,1);
 INSERT INTO airport VALUES ('ENU','Enugu','NGR','Enugu','Enugu',NULL,6.474272,7.561961,142,1);
 INSERT INTO airport VALUES ('YOL','Yola','NGR','Yola','Adamawa',NULL,9.257553,12.430422,183,1);
 INSERT INTO airport VALUES ('ILR','Ilorin','NGR','Ilorin','Kwara',NULL,8.440211,4.493919,343,1);
 INSERT INTO airport VALUES ('IUE','Niue Intl','NU','Alofi','Niue','Niue',-19.0533,-169.9256,64,-11);
 INSERT INTO airport VALUES ('NLK','Norfolk Island Intl','NF','Kingston','Norfolk Island','Norfolk Island',-29.041625,167.938742,113,11.5);
 INSERT INTO airport VALUES ('SPN','Francisco C Ada Saipan Intl','MP','Saipan','Northern Mariana Islands','Saipan',15.119003,145.729356,66,10);
 INSERT INTO airport VALUES ('FNJ','Pyongyang Sunan Int','KP','Pyongyang','North Korea',NULL,39.2239,126.67,36,9);
 INSERT INTO airport VALUES ('SKE','Geiteryggen','N','Skien','Telemark',NULL,59.185,9.566944,141,1);
 INSERT INTO airport VALUES ('VDS','Vadsoe','N','Vadsø','Finnmark',NULL,70.065,29.844,39,1);
 INSERT INTO airport VALUES ('NVK','Framnes','N','Narvik','Nordland',NULL,68.435833,17.388056,30,1);
 INSERT INTO airport VALUES ('OSL','Gardermoen','N','Oslo','Oslo',NULL,60.193917,11.100361,208,1);
 INSERT INTO airport VALUES ('RYG','Moss','N','Moss','Østfold',NULL,59.378933,10.785389,53,1);
 INSERT INTO airport VALUES ('LYR','Longyear','SVA','Longyearbyen','Svalbard','Svalbard',78.246111,15.465556,27,1);
 INSERT INTO airport VALUES ('MOL','Aro','N','Molde','Møre og Romsdal',NULL,62.744722,7.2625,3,1);
 INSERT INTO airport VALUES ('KRS','Kjevik','N','Kristiansand','Vest-Agder',NULL,58.204214,8.085369,17,1);
 INSERT INTO airport VALUES ('SVG','Sola','N','Stavanger','Rogaland',NULL,58.876778,5.637856,9,1);
 INSERT INTO airport VALUES ('TRD','Vaernes','N','Trondheim','Sør-Trøndelag',NULL,63.457556,10.92425,17,1);
 INSERT INTO airport VALUES ('BGO','Flesland','N','Bergen','Hordaland',NULL,60.293386,5.218142,52,1);
 INSERT INTO airport VALUES ('HFT','Hammerfest Airport','N','Hammerfest','Finnmark',NULL,70.679722,23.668889,244,1);
 INSERT INTO airport VALUES ('MCT','Seeb Intl','OM','Muscat','Oman',NULL,23.593278,58.284444,15,4);
 INSERT INTO airport VALUES ('ISB','Chaklala','PK','Islamabad','FCT Islamabad',NULL,33.616653,73.099233,509,5);
 INSERT INTO airport VALUES ('KHI','Jinnah Intl','PK','Karachi','Sindh',NULL,24.906547,67.160797,30,5);
 INSERT INTO airport VALUES ('LHE','Allama Iqbal Intl','PK','Lahore','Punjab',NULL,31.521564,74.403594,217,5);
 INSERT INTO airport VALUES ('LYP','Faisalabad Intl','PK','Faisalabad','Punjab',NULL,31.365014,72.994842,180,5);
 INSERT INTO airport VALUES ('SKZ','Sukkur','PK','Sukkur','Sindh',NULL,27.721989,68.791683,60,5);
 INSERT INTO airport VALUES ('SKT','Sialkot Airport','PK','Sialkot','Punjab',NULL,32.5356,74.3639,247,5);
 INSERT INTO airport VALUES ('RYK','Sheikh Zayed','PK','Rahimyar Khan','Punjab',NULL,28.3839,70.279572,83,5);
 INSERT INTO airport VALUES ('UET','Quetta','PK','Quetta','Balochistan',NULL,30.251369,66.937764,1606,5);
 INSERT INTO airport VALUES ('PEW','Peshawar Intl','PK','Peshawar','Khyber Pakhtunkhwa',NULL,33.993911,71.514581,353,5);
 INSERT INTO airport VALUES ('MUX','Multan Intl','PK','Multan','Punjab',NULL,30.203222,71.419111,123,5);
 INSERT INTO airport VALUES ('ROR','Babelthuap','PAL','Ngerulmud','Palau','Babeldaob',7.367303,134.544278,54,9);
 INSERT INTO airport VALUES ('BOC','Bocas del Toro Intl','PA','Bocas del Toro','Bocas del Toro',NULL,9.340853,-82.250842,3,-5);
 INSERT INTO airport VALUES ('PTY','Tocumen Intl','PA','Panamá City','Panamá',NULL,9.071364,-79.383453,41,-5);
 INSERT INTO airport VALUES ('POM','Port Moresby Jacksons Intl','PNG','Port Moresby','South','New Guinea',-9.443383,147.22005,45,10);
 INSERT INTO airport VALUES ('LAE','Lae Nadzab','PNG','Lae','North','New Guinea',-6.5698,146.7262,73,10);
 INSERT INTO airport VALUES ('AGT','Ciudad del Este','PY','Ciudad del Este','Paraguay',NULL,-25.4555,-54.843592,258,-4);
 INSERT INTO airport VALUES ('ASU','Silvio Pettirossi Intl','PY','Asunción','Paraguay',NULL,-25.23985,-57.519133,89,-4);
 INSERT INTO airport VALUES ('CIX','Capt Jose A Quinones Gonzales Intl','PE','Chiclayo','Lambayeque',NULL,-6.787475,-79.828097,30,-5);
 INSERT INTO airport VALUES ('TRU','Capitan Carlos Martinez De Pinillos','PE','Trujillo','La Libertad',NULL,-8.081411,-79.108761,32,-5);
 INSERT INTO airport VALUES ('HUU','Alferez Fap David Figueroa Fernandini Airport','PE','Huánuco','Huánuco',NULL,-9.878811,-76.204797,1851,-5);
 INSERT INTO airport VALUES ('AYP','Coronel Fap Alfredo Mendivil Duarte','PE','Ayacucho','Ayacucho',NULL,-13.154819,-74.204417,2719,-5);
 INSERT INTO airport VALUES ('TBP','Pedro Canga','PE','Tumbes','Tumbes',NULL,-3.552528,-80.381356,35,-5);
 INSERT INTO airport VALUES ('CJA','Mayor General FAP Armando Revoredo Iglesias Airport','PE','Cajamarca','Cajamarca',NULL,-7.139183,-78.4894,2677,-5);
 INSERT INTO airport VALUES ('PIU','Capitan Fap Guillermo Concha Iberico','PE','Piura','Piura',NULL,-5.20575,-80.616444,37,-5);
 INSERT INTO airport VALUES ('PCL','Cap Fap David Abenzur Rengifo Intl','PE','Pucallpa','Ucayali',NULL,-8.377939,-74.574297,156,-5);
 INSERT INTO airport VALUES ('PEM','Padre Aldamiz','PE','Puerto Maldonado','Madre de Dios',NULL,-12.613611,-69.228611,201,-5);
 INSERT INTO airport VALUES ('IQT','Coronel Francisco Secada Vignetta Intl','PE','Iquitos','Loreto',NULL,-3.784739,-73.308806,93,-5);
 INSERT INTO airport VALUES ('AQP','Rodriguez Ballon','PE','Arequipa','Arequipa',NULL,-16.341072,-71.583083,2563,-5);
 INSERT INTO airport VALUES ('JUL','Juliaca','PE','Juliaca','Puno',NULL,-15.467103,-70.158169,3827,-5);
 INSERT INTO airport VALUES ('TPP','Cadete Guillermo Del Castillo Paredes','PE','Tarapoto','San Martín',NULL,-6.508742,-76.373247,265,-5);
 INSERT INTO airport VALUES ('CUZ','Teniente Alejandro Velasco Astete Intl','PE','Cusco','Cusco',NULL,-13.535722,-71.938781,3311,-5);
 INSERT INTO airport VALUES ('TCQ','Coronel Carlos Ciriani Santa Rosa Intl','PE','Tacna','Tacna',NULL,-18.053333,-70.275833,469,-5);
 INSERT INTO airport VALUES ('LIM','Jorge Chavez Intl','PE','Lima','Lima City',NULL,-12.021889,-77.114319,34,-5);
 INSERT INTO airport VALUES ('CEB','Mactan Cebu Intl','RP','Cebu','Central Visayas','Cebu',10.307542,123.979439,9,8);
 INSERT INTO airport VALUES ('LGP','Legazpi','RP','Legazpi','Bicol','Luzon',13.157064,123.746247,20,8);
 INSERT INTO airport VALUES ('TAC','Daniel Z Romualdez','RP','Tacloban','Eastern Visayas','Leyte',11.227628,125.027758,3,8);
 INSERT INTO airport VALUES ('MNL','Ninoy Aquino Intl','RP','Manila','Metro Manila','Luzon',14.508647,121.019581,23,8);
 INSERT INTO airport VALUES ('BXU','Butuan','RP','Butuan','Caraga','Mindanao',8.951322,125.477972,43,8);
 INSERT INTO airport VALUES ('ZAM','Zamboanga Intl','RP','Zamboanga','Zamboanga Peninsula','Mindanao',6.922419,122.059633,10,8);
 INSERT INTO airport VALUES ('ILO','Iloilo','RP','Iloilo','Western Visayas','Panay',10.713044,122.545297,8,8);
 INSERT INTO airport VALUES ('PPS','Puerto Princesa','RP','Calapan','Mimaropa','Palawan',9.742119,118.758731,22,8);
 INSERT INTO airport VALUES ('PAG','Pagadian','RP','Pagadian','Zamboanga Peninsula','Mindanao',7.827197,123.458294,2,8);
 INSERT INTO airport VALUES ('GES','General Santos International Airport','RP','General Santos','Soccsksargen','Mindanao',6.106439,125.2353,9,8);
 INSERT INTO airport VALUES ('DVO','Francisco Bangoy International','RP','Davao','Davao','Mindanao',7.125522,125.645778,18,8);
 INSERT INTO airport VALUES ('BCD','Bacolod','RP','Bacolod','Western Visayas','Negros',10.642511,122.929617,8,8);
 INSERT INTO airport VALUES ('CBO','Cotabato','RP','Cotabato','Muslim Mindanao','Mindanao',7.165242,124.209619,58,8);
 INSERT INTO airport VALUES ('KRK','Balice','PL','Kraków','Małopolskie',NULL,50.077731,19.784836,241,1);
 INSERT INTO airport VALUES ('KTW','Pyrzowice','PL','Katowice','Śląskie',NULL,50.474253,19.080019,303,1);
 INSERT INTO airport VALUES ('BZG','Bydgoszcz Ignacy Jan Paderewski Airport','PL','Bydgoszcz','Kujawsko-Pomorskie',NULL,53.0968,17.9777,72,1);
 INSERT INTO airport VALUES ('SZZ','Goleniow','PL','Szczecin','Zachodniopomorskie',NULL,53.584731,14.902206,47,1);
 INSERT INTO airport VALUES ('GDN','Lech Walesa','PL','Gdańsk','Pomorskie',NULL,54.377569,18.466222,149,1);
 INSERT INTO airport VALUES ('RZE','Jasionka','PL','Rzeszów','Podkarpackie',NULL,50.109958,22.019,206,1);
 INSERT INTO airport VALUES ('POZ','Lawica','PL','Poznań','Wielkopolskie',NULL,52.421031,16.826325,94,1);
 INSERT INTO airport VALUES ('WRO','Strachowice','PL','Wrocław','Dolnośląskie',NULL,51.102683,16.885836,123,1);
 INSERT INTO airport VALUES ('LCJ','Lodz Wladyslaw Reymont Airport','PL','Łódź','Łódzkie',NULL,51.721881,19.398133,184,1);
 INSERT INTO airport VALUES ('WAW','Okecie','PL','Warszawa','Mazowieckie',NULL,52.16575,20.967122,110,1);
 INSERT INTO airport VALUES ('FAO','Faro','P','Faro','Algarve',NULL,37.014425,-7.965911,7,0);
 INSERT INTO airport VALUES ('FLW','Flores','P',NULL,NULL,'Flores (Azores)',39.455272,-31.131361,34,-1);
 INSERT INTO airport VALUES ('LIS','Portela','P','Lisboa','Lisboa',NULL,38.781311,-9.135919,114,0);
 INSERT INTO airport VALUES ('PXO','Porto Santo','P',NULL,NULL,'Porto Santo',33.073386,-16.349975,104,0);
 INSERT INTO airport VALUES ('GRW','Graciosa','P',NULL,NULL,'Graciosa',39.092169,-28.029847,26,-1);
 INSERT INTO airport VALUES ('SJZ','Sao Jorge','P',NULL,NULL,'Sao Jorge',38.6655,-28.175817,95,-1);
 INSERT INTO airport VALUES ('CVU','Corvo Airport','P',NULL,NULL,'Corvo',39.6715,-31.1136,19,-1);
 INSERT INTO airport VALUES ('SMA','Santa Maria','P',NULL,NULL,'Santa Maria',36.97139,-25.170639,94,-1);
 INSERT INTO airport VALUES ('FNC','Madeira','P','Funchal','Madeira','Madeira',32.697889,-16.774453,59,0);
 INSERT INTO airport VALUES ('PIX','Pico','P',NULL,NULL,'Pico',38.554333,-28.441333,33,-1);
 INSERT INTO airport VALUES ('TER','Lajes','P',NULL,NULL,'Terceira',38.761842,-27.090797,55,-1);
 INSERT INTO airport VALUES ('OPO','Porto','P','Oporto','Porto',NULL,41.248055,-8.681389,70,0);
 INSERT INTO airport VALUES ('PDL','Ponta Delgada','P','Ponta Delgada','Azores','Sao Miguel',37.741184,-25.69787,79,-1);
 INSERT INTO airport VALUES ('SJU','Luis Munoz Marin Intl','PR','San Juan','Puerto Rico','Puerto Rico',18.439417,-66.001833,3,-4);
 INSERT INTO airport VALUES ('DOH','Doha Intl','Q','Doha','Qatar',NULL,25.261125,51.565056,11,4);
 INSERT INTO airport VALUES ('RUN','St Denis Gillot','RE','Saint-Denis','Reunion','Reunion',-20.8871,55.510308,20,5);
 INSERT INTO airport VALUES ('IAS','Iasi','RO','Iaşi','Iaşi',NULL,47.178492,27.620631,121,2);
 INSERT INTO airport VALUES ('SBZ','Sibiu','RO','Sibiu','Sibiu',NULL,45.785597,24.091342,456,2);
 INSERT INTO airport VALUES ('BAY','Tautii Magheraus','RO','Baia Mare','Maramureş',NULL,47.658389,23.470022,184,2);
 INSERT INTO airport VALUES ('SCV','Stefan Cel Mare','RO','Suceava','Suceava',NULL,47.6875,26.354056,419,2);
 INSERT INTO airport VALUES ('CLJ','Cluj Napoca','RO','Cluj-Napoca','Cluj',NULL,46.785167,23.686167,316,2);
 INSERT INTO airport VALUES ('TSR','Traian Vuia','RO','Timişoara','Timiş',NULL,45.809861,21.337861,106,2);
 INSERT INTO airport VALUES ('BCM','Bacau','RO','Bacău','Bacău',NULL,46.521946,26.910278,185,2);
 INSERT INTO airport VALUES ('OMR','Oradea','RO','Oradea','Bihor',NULL,47.025278,21.9025,142,2);
 INSERT INTO airport VALUES ('OTP','Henri Coanda','RO','Bucureşti','Bucureşti',NULL,44.572161,26.102178,96,2);
 INSERT INTO airport VALUES ('SUJ','Satu Mare','RO','Satu Mare','Satu-Mare',NULL,47.703275,22.8857,123,2);
 INSERT INTO airport VALUES ('ARW','Arad','RO','Arad','Arad',NULL,46.17655,21.262022,107,2);
 INSERT INTO airport VALUES ('KGD','Khrabrovo','R','Kaliningrad','Kaliningradskaya',NULL,54.89005,20.592633,13,2);
 INSERT INTO airport VALUES ('MMK','Murmansk','R','Murmansk','Murmanskaya',NULL,68.781672,32.750822,81,3);
 INSERT INTO airport VALUES ('PES','Petrozavodsk Airport','R','Petrozavodsk','Karelia',NULL,61.8852,34.1547,46,3);
 INSERT INTO airport VALUES ('ARH','Talagi','R','Arkhangelsk','Arkhangelskaya',NULL,64.360281,40.430167,6,4);
 INSERT INTO airport VALUES ('SCW','Syktyvkar','R','Syktyvkar','Komi',NULL,61.64705,50.84505,104,3);
 INSERT INTO airport VALUES ('VKT','Vorkuta Airport','R','Vorkuta','Komi',NULL,67.4886,63.9931,184,3);
 INSERT INTO airport VALUES ('KVX','Pobedilovo Airport','R','Kirov','Kirovskaya',NULL,58.5033,49.3483,146,4);
 INSERT INTO airport VALUES ('LED','Pulkovo','R','Sankt Peterburg','Sankt-Peterburg',NULL,59.800292,30.262503,24,3);
 INSERT INTO airport VALUES ('EGO','Belgorod International Airport','R','Belgorod','Belgorodskaya',NULL,50.6438,36.5901,224,3);
 INSERT INTO airport VALUES ('DME','Domododevo','R','Moskva','Moscow',NULL,55.408611,37.906111,179,3);
 INSERT INTO airport VALUES ('SVO','Sheremetyevo','R','Moskva','Moscow',NULL,55.972642,37.414589,190,3);
 INSERT INTO airport VALUES ('VKO','Vnukovo','R','Moskva','Moscow',NULL,55.591531,37.261486,209,3);
 INSERT INTO airport VALUES ('GOJ','Strigono','R','Nizhnii Novgorod','Nizhnii Novgorodskaya',NULL,56.23,43.785,78,3);
 INSERT INTO airport VALUES ('CEE','Cherepovets Airport','R','Cherepovets','Vologodskaya',NULL,59.2736,38.0158,115,3);
 INSERT INTO airport VALUES ('KZN','Kazan','R','Kazan','Tatarstan',NULL,55.606186,49.278728,125,3);
 INSERT INTO airport VALUES ('CSY','Cheboksary Airport','R','Cheboksary','Chuvashia',NULL,56.0903,47.3473,170,3);
 INSERT INTO airport VALUES ('TBW','Tambow','R','Tambov','Tambovskaya',NULL,52.81,41.48,38,4);
 INSERT INTO airport VALUES ('VOZ','Chertovitskoye','R','Voronezh','Voronezhskaya',NULL,51.814211,39.229589,157,3);
 INSERT INTO airport VALUES ('VOG','Gumrak','R','Volgograd','Volgogradskaya',NULL,48.782528,44.345544,147,3);
 INSERT INTO airport VALUES ('ROV','Rostov Na Donu','R','Rostov-na-Donu','Rostovskaya',NULL,47.258208,39.818089,85,3);
 INSERT INTO airport VALUES ('STW','Shpakovskoye','R','Stavropol','Stavropolskiy',NULL,45.109165,42.112778,453,4);
 INSERT INTO airport VALUES ('AER','Sochi','R','Sochi','Krasnodarskiy',NULL,43.449928,39.956589,27,3);
 INSERT INTO airport VALUES ('KRR','Pashkovskiy','R','Krasnodar','Krasnodarskiy',NULL,45.034689,39.170539,36,3);
 INSERT INTO airport VALUES ('ESL','Elista Airport','R','Elista','Kalmykiya',NULL,46.3739,44.3309,153,3);
 INSERT INTO airport VALUES ('NAL','Nalchik Airport','R','Nalčik','Kabardino-Balkarskaya',NULL,43.5129,43.6366,445,3);
 INSERT INTO airport VALUES ('GRV','Grozny Airport','R','Grozny','Chechenskaya',NULL,43.2981,45.7841,167,3);
 INSERT INTO airport VALUES ('MCX','Uytash','R','Makhachkala','Dagestan',NULL,42.816822,47.652294,4,3);
 INSERT INTO airport VALUES ('KUF','Kurumoch','R','Samara','Samarskaya',NULL,53.5,50.15,145,4);
 INSERT INTO airport VALUES ('ULY','Ulyanovsk East Airport','R','Ulyanovsk','Ulyanovskaya',NULL,54.401,48.8027,77,4);
 INSERT INTO airport VALUES ('ASF','Astrakhan','R','Astrakhan','Astrakhanskaya',NULL,46.283333,48.006278,-20,4);
 INSERT INTO airport VALUES ('IJK','Izhevsk Airport','R','Izhevsk','Udmurtskaya',NULL,56.8281,53.4575,162,4);
 INSERT INTO airport VALUES ('PEE','Bolshoye Savino','R','Perm','Permskij',NULL,57.914517,56.021214,123,5);
 INSERT INTO airport VALUES ('UFA','Ufa','R','Ufa','Bashkortostan',NULL,54.557511,55.874417,137,6);
 INSERT INTO airport VALUES ('REN','Orenburg','R','Orenburg','Orenburgskaya',NULL,51.795786,55.456744,118,5);
 INSERT INTO airport VALUES ('MQF','Magnitogorsk','R','Magnitogorsk','Chelyabinskaya',NULL,53.393131,58.755661,436,6);
 INSERT INTO airport VALUES ('OSW','Orsk Airport','R','Orsk','Orenburgskaya',NULL,51.0725,58.5956,277,5);
 INSERT INTO airport VALUES ('SVX','Koltsovo','R','Yekaterinburg','Sverdlovskaya',NULL,56.743108,60.802728,233,5);
 INSERT INTO airport VALUES ('CEK','Balandino','R','Chelyabinsk','Chelyabinskaya',NULL,55.305836,61.503333,234,5);
 INSERT INTO airport VALUES ('TJM','Roschino','R','Tyumen','Tyumenskaya',NULL,57.189567,65.3243,115,5);
 INSERT INTO airport VALUES ('SLY','Salekhard Airport','R','Salekhard','Tyumenskaya',NULL,66.590753,66.611042,66,6);
 INSERT INTO airport VALUES ('NUX','Novyi Urengoy','R','Novyj Urengoj','Tyumenskaya',NULL,66.041811,76.313938,6,6);
 INSERT INTO airport VALUES ('HMA','Khanty Mansiysk Airport','R','Khanty Mansijsk','Tyumenskaya',NULL,61.028479,69.086067,23,5);
 INSERT INTO airport VALUES ('SGC','Surgut','R','Surgut','Tyumenskaya',NULL,61.343694,73.401842,61,6);
 INSERT INTO airport VALUES ('NOJ','Noyabrsk','R','Nojabrsk','Tyumenskaya',NULL,63.110079,75.162243,6,6);
 INSERT INTO airport VALUES ('NJC','Nizhnevartovsk','R','Nizhnevartovsk','Tyumenskaya',NULL,60.949272,76.483617,54,5);
 INSERT INTO airport VALUES ('OMS','Omsk','R','Omsk','Omskaya',NULL,54.967042,73.310514,95,6);
 INSERT INTO airport VALUES ('OVB','Tolmachevo','R','Novosibirsk','Novosibirskaya',NULL,55.012622,82.650656,111,7);
 INSERT INTO airport VALUES ('BAX','Barnaul','R','Barnaul','Altayskiy',NULL,53.363775,83.538533,255,7);
 INSERT INTO airport VALUES ('TOF','Tomsk Bogashevo Airport','R','Tomsk','Tomskaya',NULL,56.380278,85.208333,182,7);
 INSERT INTO airport VALUES ('KEJ','Kemerovo','R','Kemerovo','Kemerovskaya',NULL,55.270094,86.107208,263,7);
 INSERT INTO airport VALUES ('NOZ','Spichenkovo Airport','R','Novokuznetsk','Kemerovskaya',NULL,53.8114,86.8772,312,7);
 INSERT INTO airport VALUES ('NSK','Alykel','R','Norilsk','Krasnoyarsk',NULL,69.311053,87.332183,181,7);
 INSERT INTO airport VALUES ('ABA','Abakan','R','Abakan','Khakasiya',NULL,53.74,91.385,253,7);
 INSERT INTO airport VALUES ('KJA','Emelyanovo','R','Krasnoyarsk','Krasnoyarsk',NULL,56.18,92.475,287,7);
 INSERT INTO airport VALUES ('BTK','Bratsk','R','Bratsk','Irkutskaya',NULL,56.370556,101.698331,491,8);
 INSERT INTO airport VALUES ('IKT','Irkutsk','R','Irkutsk','Irkutskaya',NULL,52.268028,104.388975,511,8);
 INSERT INTO airport VALUES ('UUD','Mukhino','R','Ulan-Ude','Buryatiya',NULL,51.807764,107.437644,515,8);
 INSERT INTO airport VALUES ('HTA','Kadala','R','Chita','Zabaykalskiy',NULL,52.026317,113.305556,693,9);
 INSERT INTO airport VALUES ('BQS','Ignatyevo','R','Blagoveščensk','Amurskaya',NULL,50.425394,127.412478,195,9);
 INSERT INTO airport VALUES ('YKS','Yakutsk','R','Yakutsk','Sakha',NULL,62.09325,129.770672,99,9);
 INSERT INTO airport VALUES ('VVO','Knevichi','R','Vladivostok','Primorskiy',NULL,43.398953,132.148017,14,10);
 INSERT INTO airport VALUES ('KHV','Khabarovsk Novy','R','Khabarovsk','Khabarovskiy',NULL,48.528044,135.188361,74,10);
 INSERT INTO airport VALUES ('UUS','Khomutovo','R','Južno-Sachalinsk','Sakhalin','Sachalin',46.888672,142.717531,18,11);
 INSERT INTO airport VALUES ('ITU','Iturup','R',NULL,NULL,'Iturup',45.25,147.95,118,11);
 INSERT INTO airport VALUES ('GDX','Sokol','R','Magadan','Magadanskaya',NULL,59.910989,150.720439,175,11);
 INSERT INTO airport VALUES ('PKC','Yelizovo','R','Petropavlovsk-Kamčatskij','Kamchatka',NULL,53.167889,158.453669,40,12);
 INSERT INTO airport VALUES ('KGL','Kigali Intl','RWA','Kigali','Rwanda',NULL,-1.968628,30.13945,1481,2);
 INSERT INTO airport VALUES ('SKB','Robert L Bradshaw','KN','Basseterre','Saint Kitts and Nevis','Saint Kitts',17.311194,-62.718667,52,-4);
 INSERT INTO airport VALUES ('UVF','Hewanorra Intl','WL','Castries','Saint Lucia','Saint Lucia',13.733194,-60.952597,4,-4);
 INSERT INTO airport VALUES ('SLU','George F L Charles','WL','Castries','Saint Lucia','Saint Lucia',14.020228,-60.992936,7,-4);
 INSERT INTO airport VALUES ('SFP','Saint-Pierre','SPM','Saint-Pierre','Saint Pierre and Miquelon','Saint Pierre',46.7631,-56.1742,8,-2);
 INSERT INTO airport VALUES ('SVD','E T Joshua','WV','Kingstown','Saint Vincent and the Grenadines','Saint Vincent',13.144306,-61.210861,20,-4);
 INSERT INTO airport VALUES ('APW','Faleolo Intl','WS','Apia','Samoa','Upolu',-13.829969,-172.008336,18,13);
 INSERT INTO airport VALUES ('TMS','Sao Tome Intl','STP','São Tomé','Sao Tome and Principe','Sao Tome',.378175,6.712153,10,0);
 INSERT INTO airport VALUES ('TIF','Taif','SA','At Taif','Makkah Al-Mokarramah',NULL,21.483418,40.544334,1478,3);
 INSERT INTO airport VALUES ('DMM','King Fahd Intl','SA','Ad-Dammam','Ash Sharqiyah',NULL,26.471161,49.79789,22,3);
 INSERT INTO airport VALUES ('HAS','Hail','SA','Hail','Hail',NULL,27.437917,41.686292,1016,3);
 INSERT INTO airport VALUES ('JED','King Abdulaziz Intl','SA','Jeddah','Makkah Al-Mokarramah',NULL,21.679564,39.156536,15,3);
 INSERT INTO airport VALUES ('RUH','King Khaled Intl','SA','Riyadh','Ar-Riyadh',NULL,24.95764,46.698776,625,3);
 INSERT INTO airport VALUES ('MED','Prince Mohammad Bin Abdulaziz','SA','Al Madinah','Al-Madinah Al-Monawarah',NULL,24.553422,39.705061,656,3);
 INSERT INTO airport VALUES ('ZIG','Ziguinchor','SN','Ziguinchor','Ziguinchor',NULL,12.555617,-16.281783,23,0);
 INSERT INTO airport VALUES ('DKR','Leopold Sedar Senghor Intl','SN','Dakar','Dakar',NULL,14.739708,-17.490225,26,0);
 INSERT INTO airport VALUES ('PRN','Pristina','KOS','Prishtine','Kosovo',NULL,42.572778,21.035833,545,1);
 INSERT INTO airport VALUES ('BEG','Beograd','SRB','Beograd','Serbia',NULL,44.818444,20.309139,102,1);
 INSERT INTO airport VALUES ('INI','Nis','SRB','Niš','Serbia',NULL,43.337289,21.853722,198,1);
 INSERT INTO airport VALUES ('SEZ','Seychelles Intl','SY','Victoria','Seychelles','Mahe',-4.674342,55.521839,3,4);
 INSERT INTO airport VALUES ('FNA','Freetown Lungi','SLE','Freetown','Sierra Leone',NULL,8.616444,-13.195489,26,0);
 INSERT INTO airport VALUES ('SIN','Changi Intl','SGP','Singapore','Singapore','Ujong',1.350189,103.994433,7,8);
 INSERT INTO airport VALUES ('SXM','Princess Juliana Intl','SX','Philipsburg','Sint Maarten','St. Martin',18.040953,-63.1089,4,-4);
 INSERT INTO airport VALUES ('BTS','M R Stefanik','SK','Bratislava','Bratislavský',NULL,48.170167,17.212667,133,1);
 INSERT INTO airport VALUES ('KSC','Kosice','SK','Košice','Košický',NULL,48.663055,21.241112,230,1);
 INSERT INTO airport VALUES ('LJU','Ljubljana','SLO','Ljubljana','Slovenia',NULL,46.223686,14.457611,388,1);
 INSERT INTO airport VALUES ('HIR','Honiara International','SOL','Honiara','Solomon Islands','Guadalcanal',-9.428,160.054789,9,11);
 INSERT INTO airport VALUES ('MGQ','Aden Adde International Airport','SO','Mogadishu','Somalia',NULL,2.01444,45.3047,9,3);
 INSERT INTO airport VALUES ('HLA','Lanseria','RSA','Johannesburg','Gauteng',NULL,-25.938514,27.926133,1377,2);
 INSERT INTO airport VALUES ('PZB','Pietermaritzburg','RSA','Msunduzi','KwaZulu-Natal',NULL,-29.648975,30.398667,739,2);
 INSERT INTO airport VALUES ('DUR','Durban Intl','RSA','eThekwini','KwaZulu-Natal',NULL,-29.970089,30.950519,10,2);
 INSERT INTO airport VALUES ('ELS','East London','RSA','Buffalo City','Eastern Cape',NULL,-33.035569,27.825939,133,2);
 INSERT INTO airport VALUES ('BFN','Bloemfontein Intl','RSA','Mangaung','Free State',NULL,-29.092722,26.302444,1359,2);
 INSERT INTO airport VALUES ('KIM','Kimberley','RSA','Kimberley','Northern Cape',NULL,-28.802834,24.765167,1204,2);
 INSERT INTO airport VALUES ('PLZ','Port Elizabeth Intl','RSA','Nelson Mandela Bay','Eastern Cape',NULL,-33.984919,25.617275,69,2);
 INSERT INTO airport VALUES ('PTG','Pietersburg','RSA','Polokwane','Limpopo',NULL,-23.926089,29.484422,1327,2);
 INSERT INTO airport VALUES ('CPT','Cape Town Intl','RSA','Cape Town','Western Cape',NULL,-33.964806,18.601667,46,2);
 INSERT INTO airport VALUES ('JNB','Johannesburg Intl','RSA','Johannesburg','Gauteng',NULL,-26.139166,28.246,1695,2);
 INSERT INTO airport VALUES ('RSU','Yeosu','ROK','Yeosu','South Korea',NULL,34.842328,127.61685,16,9);
 INSERT INTO airport VALUES ('ICN','Incheon Intl','ROK','Seoul','South Korea',NULL,37.469075,126.450517,7,9);
 INSERT INTO airport VALUES ('PUS','Gimhae Intl','ROK','Busan','South Korea',NULL,35.179528,128.938222,2,9);
 INSERT INTO airport VALUES ('GMP','Gimpo','ROK','Seoul','South Korea',NULL,37.558311,126.790586,18,9);
 INSERT INTO airport VALUES ('USN','Ulsan','ROK','Ulsan','South Korea',NULL,35.593494,129.351722,14,9);
 INSERT INTO airport VALUES ('KWJ','Gwangju','ROK','Gwangju','South Korea',NULL,35.126389,126.808889,12,9);
 INSERT INTO airport VALUES ('TAE','Daegu Ab','ROK','Daegu','South Korea',NULL,35.894108,128.658856,35,9);
 INSERT INTO airport VALUES ('CJU','Jeju Intl','ROK','Jeju','South Korea','Jeju',33.511306,126.493028,36,9);
 INSERT INTO airport VALUES ('JUB','Juba','SSD','Juba','South Sudan',NULL,4.872006,31.601117,461,2);
 INSERT INTO airport VALUES ('VDE','Hierro','E',NULL,NULL,'Hierro',27.814847,-17.887056,31,0);
 INSERT INTO airport VALUES ('SDR','Santander','E','Santander','Cantabria',NULL,43.427064,-3.820006,5,1);
 INSERT INTO airport VALUES ('SPC','La Palma','E',NULL,NULL,'La Palma',28.626478,-17.755611,33,0);
 INSERT INTO airport VALUES ('LPA','Gran Canaria','E','Las Palmas de Gran Canaria','Canarias','Gran Canaria',27.931886,-15.386586,24,0);
 INSERT INTO airport VALUES ('SLM','Salamanca','E','Salamanca','Castilla y León',NULL,40.952117,-5.501986,791,1);
 INSERT INTO airport VALUES ('TFN','Tenerife Norte','E','Santa Cruz de Tenerife','Canarias','Teneriffa',28.482653,-16.341536,632,0);
 INSERT INTO airport VALUES ('AGP','Malaga','E','Málaga','Andalucía',NULL,36.6749,-4.499106,16,1);
 INSERT INTO airport VALUES ('BIO','Bilbao','E','Bilbao','Euskadi',NULL,43.301097,-2.910608,42,1);
 INSERT INTO airport VALUES ('TFS','Tenerife Sur','E','Santa Cruz de Tenerife','Canarias','Teneriffa',28.044475,-16.572489,64,0);
 INSERT INTO airport VALUES ('BJZ','Talavera La Real','E','Badajoz','Extremadura',NULL,38.89125,-6.821333,186,1);
 INSERT INTO airport VALUES ('ALC','Alicante','E','Alicante','Valenciana',NULL,38.282169,-0.558156,43,1);
 INSERT INTO airport VALUES ('BCN','Barcelona','E','Barcelona','Catalunya',NULL,41.297078,2.078464,4,1);
 INSERT INTO airport VALUES ('ACE','Lanzarote','E','Las Palmas de Gran Canaria','Canarias','Gran Canaria',28.945464,-13.605225,14,0);
 INSERT INTO airport VALUES ('VGO','Vigo','E','Vigo','Galicia',NULL,42.2318,-8.626775,261,1);
 INSERT INTO airport VALUES ('MLN','Melilla','MEL','Melilla','Melilla',NULL,35.279817,-2.956256,48,0);
 INSERT INTO airport VALUES ('MJV','Murcia San Javier','E','Murcia','Murcia',NULL,37.774972,-0.812389,3,1);
 INSERT INTO airport VALUES ('GMZ','La Gomera Airport','E',NULL,NULL,'Gomera',28.0296,-17.2146,219,0);
 INSERT INTO airport VALUES ('FUE','Fuerteventura','E',NULL,NULL,'Fuerteventura',28.452717,-13.863761,25,0);
 INSERT INTO airport VALUES ('XRY','Jerez','E','Jerez de la Frontera','Andalucía',NULL,36.744622,-6.060111,28,1);
 INSERT INTO airport VALUES ('PMI','Son Sant Joan','E','Palma de Mallorca','Illes Balears','Mallorca',39.55361,2.727778,7,1);
 INSERT INTO airport VALUES ('PNA','Pamplona','E','Pamplona','Navarra',NULL,42.770039,-1.646331,459,1);
 INSERT INTO airport VALUES ('GRX','Granada','E','Granada','Andalucía',NULL,37.188731,-3.777356,567,1);
 INSERT INTO airport VALUES ('IBZ','Ibiza','E',NULL,NULL,'Ibiza',38.872858,1.373117,6,1);
 INSERT INTO airport VALUES ('ZAZ','Zaragoza Ab','E','Zaragoza','Aragón',NULL,41.666242,-1.041553,263,1);
 INSERT INTO airport VALUES ('REU','Reus','E','Reus','Catalunya',NULL,41.147392,1.167172,71,1);
 INSERT INTO airport VALUES ('EAS','San Sebastian','E','Donostia','Euskadi',NULL,43.356519,-1.790611,5,1);
 INSERT INTO airport VALUES ('MAD','Barajas','E','Madrid','Madrid',NULL,40.493556,-3.566764,610,1);
 INSERT INTO airport VALUES ('MAH','Menorca','E',NULL,NULL,'Menorca',39.862597,4.218647,91,1);
 INSERT INTO airport VALUES ('VLC','Valencia','E','Valencia','Valenciana',NULL,39.489314,-0.481625,69,1);
 INSERT INTO airport VALUES ('VLL','Valladolid','E','Valladolid','Castilla y León',NULL,41.706111,-4.851944,846,1);
 INSERT INTO airport VALUES ('SVQ','Sevilla','E','Sevilla','Andalucía',NULL,37.418,-5.893106,34,1);
 INSERT INTO airport VALUES ('LCG','A Coruna','E','A Coruña','Galicia',NULL,43.302061,-8.377256,99,1);
 INSERT INTO airport VALUES ('LEI','Almeria','E','Almería','Andalucía',NULL,36.843936,-2.370097,21,1);
 INSERT INTO airport VALUES ('SCQ','Santiago','E','Santiago de Compostela','Galicia',NULL,42.896333,-8.415144,370,1);
 INSERT INTO airport VALUES ('CMB','Bandaranaike Intl Colombo','CL','Colombo','Sri Lanka','Sri Lanka',7.180756,79.884117,9,5.5);
 INSERT INTO airport VALUES ('KRT','Khartoum','SUD','Khartoum','Al-Kharṭūm',NULL,15.589497,32.553161,386,2);
 INSERT INTO airport VALUES ('PBM','Johan A Pengel Intl','SME','Paramaribo','Suriname',NULL,5.452831,-55.187783,18,-3);
 INSERT INTO airport VALUES ('MTS','Matsapha','SD','Mbabane','Eswatini',NULL,-26.529022,31.307519,633,2);
 INSERT INTO airport VALUES ('VXO','Kronoberg','S','Växjö','Kronoberg',NULL,56.929144,14.727994,186,1);
 INSERT INTO airport VALUES ('VBY','Visby','S','Visby','Gotland',NULL,57.662797,18.346211,50,1);
 INSERT INTO airport VALUES ('NRK','Kungsangen','S','Norrköping','Östergötland',NULL,58.586253,16.250622,10,1);
 INSERT INTO airport VALUES ('LLA','Kallax','S','Lulea','Norrbotten',NULL,65.543758,22.121989,20,1);
 INSERT INTO airport VALUES ('LPI','Saab','S','Linköping','Östergötland',NULL,58.40615,15.680508,52,1);
 INSERT INTO airport VALUES ('AGH','Angelholm-Helsingborg Airport','S','Helsingborg','Skåne',NULL,56.2961,12.8471,21,1);
 INSERT INTO airport VALUES ('KID','Kristianstad','S','Kristianstad','Skåne',NULL,55.921686,14.085536,23,1);
 INSERT INTO airport VALUES ('BMA','Bromma','S','Stockholm','Stockholm',NULL,59.354372,17.94165,14,1);
 INSERT INTO airport VALUES ('KLR','Kalmar','S','Kalmar','Kalmar',NULL,56.685531,16.287578,5,1);
 INSERT INTO airport VALUES ('UME','Umea','S','Umeå','Västerbotten',NULL,63.791828,20.282758,7,1);
 INSERT INTO airport VALUES ('NYO','Skavsta','S','Stockholm','Stockholm',NULL,58.788636,16.912189,43,1);
 INSERT INTO airport VALUES ('VST','Västerås','S','Västerås','Västmanland',NULL,59.589444,16.633611,6,1);
 INSERT INTO airport VALUES ('HAD','Halmstad','S','Halmstad','Halland',NULL,56.691128,12.820211,31,1);
 INSERT INTO airport VALUES ('JKG','Jönköping','S','Jönköping','Jönköping',NULL,57.757594,14.068731,226,1);
 INSERT INTO airport VALUES ('OSD','Östersund Airport','S','Ostersund','Jämtland',NULL,63.1944,14.5003,376,1);
 INSERT INTO airport VALUES ('ORB','Örebro','S','Örebro','Örebro',NULL,59.223733,15.037956,57,1);
 INSERT INTO airport VALUES ('GOT','Landvetter','S','Göteborg','Västra Götaland',NULL,57.662836,12.279819,154,1);
 INSERT INTO airport VALUES ('GSE','Save','S','Göteborg','Västra Götaland',NULL,57.774722,11.870372,18,1);
 INSERT INTO airport VALUES ('ARN','Arlanda','S','Stockholm','Stockholm',NULL,59.651944,17.918611,42,1);
 INSERT INTO airport VALUES ('MMX','Sturup','S','Malmö','Skåne',NULL,55.530193,13.371639,72,1);
 INSERT INTO airport VALUES ('KSD','Karlstad Airport','S','Karlstad','Värmland',NULL,59.4447,13.3374,107,1);
 INSERT INTO airport VALUES ('BRN','Bern Belp','CH','Bern','Bern',NULL,46.9141,7.497153,510,1);
 INSERT INTO airport VALUES ('LUG','Lugano','CH','Lugano','Ticino',NULL,46.004275,8.910578,279,1);
 INSERT INTO airport VALUES ('BSL','EuroAirport Basel-Mulhouse-Freiburg','CH','Basel','Basel-Stadt',NULL,47.59,7.529167,270,1);
 INSERT INTO airport VALUES ('ZRH','Zurich Kloten','CH','Zürich','Zürich',NULL,47.464722,8.549167,432,1);
 INSERT INTO airport VALUES ('GVA','Geneva Cointrin','CH','Genève','Genève',NULL,46.238064,6.10895,430,1);
 INSERT INTO airport VALUES ('ACH','St Gallen Altenrhein','CH','Sankt Gallen','Sankt Gallen',NULL,47.485033,9.560775,398,1);
 INSERT INTO airport VALUES ('DAM','Damaskus Intl','SYR','Dimashq','Dimashq',NULL,33.4115,36.5156,616,2);
 INSERT INTO airport VALUES ('ALP','Aleppo Intl','SYR','Halab','Halab',NULL,36.1806,37.2242,383,2);
 INSERT INTO airport VALUES ('KHH','Kaohsiung Intl','RC','Kaohsiung','Taiwan','Taiwan',22.577094,120.350006,9,8);
 INSERT INTO airport VALUES ('TSA','Sungshan','RC','Taipei','Taiwan','Taiwan',25.069722,121.5525,5,8);
 INSERT INTO airport VALUES ('TPE','Taoyuan Intl','RC','Taipei','Taiwan','Taiwan',25.077731,121.232822,32,8);
 INSERT INTO airport VALUES ('DYU','Dushanbe','TJ','Dushanbe','Dushanbe',NULL,38.543333,68.825,785,5);
 INSERT INTO airport VALUES ('TJU','Kulob Airport','TJ','Kulyab','Khatlon',NULL,37.981667,69.799444,699,5);
 INSERT INTO airport VALUES ('LBD','Khudzhand Airport','TJ','Khujand','Sughd',NULL,40.2154,69.6947,442,5);
 INSERT INTO airport VALUES ('ZNZ','Zanzibar','EAT','Zanzibar','Mjini Magharibi Unguja','Sansibar',-6.222025,39.224886,16,3);
 INSERT INTO airport VALUES ('JRO','Kilimanjaro Intl','EAT','Moshi','Kilimanjaro',NULL,-3.429406,37.074461,894,3);
 INSERT INTO airport VALUES ('MYW','Mtwara','EAT','Mtwara','Mtwara',NULL,-10.339058,40.181781,113,3);
 INSERT INTO airport VALUES ('DAR','Mwalimu Julius K Nyerere Intl','EAT','Dar es Salaam','Dar es Salaam',NULL,-6.878111,39.202625,55,3);
 INSERT INTO airport VALUES ('MWZ','Mwanza','EAT','Mwanza','Mwanza',NULL,-2.444486,32.932667,1147,3);
 INSERT INTO airport VALUES ('ARK','Arusha','EAT','Arusha','Arusha',NULL,-3.367794,36.633333,1387,3);
 INSERT INTO airport VALUES ('DMK','Don Muang Intl','THA','Bangkok','Thailand',NULL,13.912583,100.60675,3,7);
 INSERT INTO airport VALUES ('NST','Nakhon Si Thammarat','THA','Nakhon Si Thammarat','Thailand',NULL,8.539617,99.944725,4,7);
 INSERT INTO airport VALUES ('USM','Samui','THA',NULL,NULL,'Ko Samui',9.547794,100.062272,20,7);
 INSERT INTO airport VALUES ('KKC','Khon Kaen','THA','Khon Kaen','Thailand',NULL,16.466628,102.783661,204,7);
 INSERT INTO airport VALUES ('BKK','Suvarnabhumi Intl','THA','Bangkok','Thailand',NULL,13.681108,100.747283,2,7);
 INSERT INTO airport VALUES ('CNX','Chiang Mai Intl','THA','Chiang Mai','Thailand',NULL,18.766847,98.962644,316,7);
 INSERT INTO airport VALUES ('HDY','Hat Yai Intl','THA','Songkhla','Thailand',NULL,6.933206,100.392975,27,7);
 INSERT INTO airport VALUES ('HKT','Phuket Intl','THA','Phuket','Thailand','Phuket',8.1132,98.316872,25,7);
 INSERT INTO airport VALUES ('LFW','Gnassingbe Eyadema Intl','RT','Lomé','Togo',NULL,6.165611,1.254511,22,1);
 INSERT INTO airport VALUES ('TBU','Fua Amotu Intl','TO','Nukualofa','Tonga','Tongatapu',-21.241214,-175.149644,38,13);
 INSERT INTO airport VALUES ('POS','Piarco','TT','Port-of-Spain','Trinidad and Tobago','Trinidad',10.595369,-61.337242,18,-4);
 INSERT INTO airport VALUES ('SFA','Thyna','TN','Sfax','Tunisia',NULL,34.717953,10.690972,26,1);
 INSERT INTO airport VALUES ('TUN','Carthage','TN','Tunis','Tunisia',NULL,36.851033,10.227217,7,1);
 INSERT INTO airport VALUES ('AYT','Antalya','TR','Antalya','Antalya',NULL,36.898731,30.800461,54,3);
 INSERT INTO airport VALUES ('EZS','Elazig','TR','Elazig','Elazığ',NULL,38.606925,39.291417,892,3);
 INSERT INTO airport VALUES ('KSY','Kars Airport','TR','Kars','Kars',NULL,40.562222,43.115002,1795,3);
 INSERT INTO airport VALUES ('SZF','Samsun-Carsamba Airport','TR','Samsun','Samsun',NULL,41.2545,36.5671,5,3);
 INSERT INTO airport VALUES ('KYA','Konya','TR','Konya','Konya',NULL,37.979,32.561861,1031,3);
 INSERT INTO airport VALUES ('ADF','Adiyaman Airport','TR','Adiyaman','Adıyaman',NULL,37.7314,38.4689,676,3);
 INSERT INTO airport VALUES ('BAL','Batman','TR','Batman','Batman',NULL,37.928969,41.116583,555,3);
 INSERT INTO airport VALUES ('ADA','Adana','TR','Adana','Adana',NULL,36.982166,35.280388,20,3);
 INSERT INTO airport VALUES ('ADB','Adnan Menderes','TR','İzmir','İzmir',NULL,38.292392,27.156953,126,3);
 INSERT INTO airport VALUES ('VAN','Van','TR','Van','Van',NULL,38.468219,43.3323,1671,3);
 INSERT INTO airport VALUES ('VAS','Sivas','TR','Sivas','Sivas',NULL,39.813828,36.903497,1596,3);
 INSERT INTO airport VALUES ('NAV','Kapadokya','TR','Nevsehir','Nevşehir',NULL,38.771867,34.53455,945,3);
 INSERT INTO airport VALUES ('ESB','Esenboga','TR','Ankara','Ankara',NULL,40.128082,32.995083,953,3);
 INSERT INTO airport VALUES ('ERZ','Erzurum','TR','Erzurum','Erzurum',NULL,39.956501,41.170166,1757,3);
 INSERT INTO airport VALUES ('ERC','Erzincan','TR','Erzincan','Erzincan',NULL,39.710203,39.527003,1153,3);
 INSERT INTO airport VALUES ('KCM','Kahramanmaras Airport','TR','Kahramanmaraş','Kahramanmaraş',NULL,37.539,36.9534,525,3);
 INSERT INTO airport VALUES ('MLX','Erhac','TR','Malatya','Malatya',NULL,38.435347,38.091006,862,3);
 INSERT INTO airport VALUES ('DIY','Diyarbakir','TR','Diyarbakir','Diyarbakır',NULL,37.893897,40.201019,686,3);
 INSERT INTO airport VALUES ('ASR','Erkilet','TR','Kayseri','Kayseri',NULL,38.770386,35.495428,1056,3);
 INSERT INTO airport VALUES ('TZX','Trabzon','TR','Trabzon','Trabzon',NULL,40.995108,39.789728,32,3);
 INSERT INTO airport VALUES ('IST','Atatürk','TR','İstanbul','İstanbul',NULL,40.976922,28.814606,50,3);
 INSERT INTO airport VALUES ('SAW','Sabiha Gokcen','TR','İstanbul','İstanbul',NULL,40.898553,29.309219,95,3);
 INSERT INTO airport VALUES ('GZT','Oguzeli','TR','Gaziantep','Gaziantep',NULL,36.947183,37.478683,706,3);
 INSERT INTO airport VALUES ('HTY','Hatay Airport','TR','Hatay','Hatay',NULL,36.362778,36.282222,8,3);
 INSERT INTO airport VALUES ('AJI','Agri Airport','TR','Agri','Ağrı',NULL,39.6546,43.0271,1665,3);
 INSERT INTO airport VALUES ('AOE','Anadolu Airport','TR','Eskisehir','Eskişehir',NULL,39.809858,30.519378,789,3);
 INSERT INTO airport VALUES ('MQM','Mardin Airport','TR','Mardin','Mardin',NULL,37.2233,40.6317,527,3);
 INSERT INTO airport VALUES ('DNZ','Cardak','TR','Denizli','Denizli',NULL,37.785567,29.701297,852,3);
 INSERT INTO airport VALUES ('MSR','Mus Airport','TR','Mus','Muş',NULL,38.747769,41.661236,1267,2);
 INSERT INTO airport VALUES ('ASB','Ashgabat','TM','Ashgabat','Ashgabat',NULL,37.986814,58.360967,211,5);
 INSERT INTO airport VALUES ('PLS','Providenciales','TUCA','Grand Turk','Turks and Caicos Islands','Grand Turk',21.773625,-72.265886,5,-5);
 INSERT INTO airport VALUES ('FUN','Funafuti International','TUV','Funafuti','Tuvalu','Fongafale',-8.525,179.196389,3,12);
 INSERT INTO airport VALUES ('EBB','Entebbe Intl','EAU','Kampala','Central',NULL,.042386,32.443503,1153,3);
 INSERT INTO airport VALUES ('DOK','Donetsk Intl','UA','Donetsk','Donetska',NULL,48.073611,37.739722,241,2);
 INSERT INTO airport VALUES ('KBP','Boryspil Intl','UA','Kyïv','Kyïv',NULL,50.345,30.894722,130,2);
 INSERT INTO airport VALUES ('HRK','Osnova International Airport','UA','Charkiv','Charkivska',NULL,49.924786,36.289986,155,2);
 INSERT INTO airport VALUES ('IEV','Zhuliany Intl','UA','Kyïv','Kyïv',NULL,50.401694,30.449697,179,2);
 INSERT INTO airport VALUES ('SIP','Simferopol Intl','UA','Simferopol','Krym',NULL,45.052222,33.975139,195,2);
 INSERT INTO airport VALUES ('UDJ','Uzhhorod International Airport','UA','Uzhhorod','Zakarpatska',NULL,48.634278,22.263356,117,2);
 INSERT INTO airport VALUES ('DNK','Dnipropetrovsk Intl','UA','Dnipro','Dnipropetrovska',NULL,48.357222,35.100556,147,2);
 INSERT INTO airport VALUES ('IFO','Ivano Frankivsk International Airport','UA','Ivano-Frankivsk','Ivano-Frankivska',NULL,48.884167,24.686111,280,2);
 INSERT INTO airport VALUES ('ODS','Odesa Intl','UA','Odesa','Odeska',NULL,46.426767,30.676464,52,2);
 INSERT INTO airport VALUES ('LWO','Lviv Intl','UA','Lviv','Lvivska',NULL,49.8125,23.956111,327,2);
 INSERT INTO airport VALUES ('AUH','Abu Dhabi Intl','UAE','Abu Dhabi','United Arab Emirates',NULL,24.432972,54.651138,27,4);
 INSERT INTO airport VALUES ('AAN','Al Ain International Airport','UAE','Al Ain','United Arab Emirates',NULL,24.261667,55.609167,265,4);
 INSERT INTO airport VALUES ('DXB','Dubai Intl','UAE','Dubai','United Arab Emirates',NULL,25.252778,55.364444,19,4);
 INSERT INTO airport VALUES ('SHJ','Sharjah Intl','UAE','Al Sharjah','United Arab Emirates',NULL,25.328575,55.51715,34,4);
 INSERT INTO airport VALUES ('STN','Stansted','GB','London','London','Great Britain',51.885,.235,106,0);
 INSERT INTO airport VALUES ('LBA','Leeds Bradford','GB','Leeds','Yorkshire and the Humber','Great Britain',53.865897,-1.660569,208,0);
 INSERT INTO airport VALUES ('LCY','City','GB','London','London','Great Britain',51.505278,.055278,6,0);
 INSERT INTO airport VALUES ('LGW','Gatwick','GB','London','London','Great Britain',51.148056,-0.190278,62,0);
 INSERT INTO airport VALUES ('LHR','Heathrow','GB','London','London','Great Britain',51.4775,-0.461389,25,0);
 INSERT INTO airport VALUES ('LPL','Liverpool','GB','Liverpool','North West England','Great Britain',53.333611,-2.849722,24,0);
 INSERT INTO airport VALUES ('BHX','Birmingham','GB','Birmingham','West Midlands','Great Britain',52.453856,-1.748028,100,0);
 INSERT INTO airport VALUES ('TRE','Tiree','GB',NULL,NULL,'Tiree',56.499167,-6.869167,12,0);
 INSERT INTO airport VALUES ('BLK','Blackpool','GB','Blackpool','North West England','Great Britain',53.771667,-3.028611,10,0);
 INSERT INTO airport VALUES ('BEB','Benbecula','GB',NULL,NULL,'Benbecula',57.481111,-7.362778,6,0);
 INSERT INTO airport VALUES ('ABZ','Dyce','GB','Aberdeen','Scotland','Great Britain',57.201944,-2.197778,66,0);
 INSERT INTO airport VALUES ('BFS','Aldergrove','GB','Belfast','Northern Ireland','Ireland',54.6575,-6.215833,82,0);
 INSERT INTO airport VALUES ('BHD','City','GB','Belfast','Northern Ireland','Ireland',54.618056,-5.8725,5,0);
 INSERT INTO airport VALUES ('EXT','Exeter','GB','Exeter','South West England','Great Britain',50.734444,-3.413889,31,0);
 INSERT INTO airport VALUES ('NCL','Newcastle','GB','Newcastle upon Tyne','North East England','Great Britain',55.0375,-1.691667,81,0);
 INSERT INTO airport VALUES ('EMA','Nottingham East Midlands','GB','Nottingham','East Midlands','Great Britain',52.831111,-1.328056,93,0);
 INSERT INTO airport VALUES ('NWI','Norwich','GB','Norwich','East of England','Great Britain',52.675833,1.282778,36,0);
 INSERT INTO airport VALUES ('BOH','Bournemouth','GB','Bournemouth','South West England','Great Britain',50.78,-1.8425,12,0);
 INSERT INTO airport VALUES ('DND','Dundee','GB','Dundee','Scotland','Great Britain',56.452499,-3.025833,5,0);
 INSERT INTO airport VALUES ('DSA','Robin Hood Doncaster Sheffield Airport','GB','Sheffield','Yorkshire and the Humber','Great Britain',53.474722,-1.004444,17,0);
 INSERT INTO airport VALUES ('MME','Durham Tees Valley Airport','GB','Middlesbrough','North East England','Great Britain',54.509189,-1.429406,37,0);
 INSERT INTO airport VALUES ('MAN','Manchester','GB','Manchester','North West England','Great Britain',53.353744,-2.27495,78,0);
 INSERT INTO airport VALUES ('EDI','Edinburgh','GB','Edinburgh','Scotland','Great Britain',55.95,-3.3725,41,0);
 INSERT INTO airport VALUES ('SOU','Southampton','GB','Southampton','South East England','Great Britain',50.950261,-1.356803,13,0);
 INSERT INTO airport VALUES ('LTN','Luton','GB','Luton','East of England','Great Britain',51.874722,-0.368333,160,0);
 INSERT INTO airport VALUES ('BRR','Barra Airport','GB',NULL,NULL,'Barra',57.0228,-7.44306,2,0);
 INSERT INTO airport VALUES ('BRS','Bristol','GB','Bristol','South West England','Great Britain',51.382669,-2.719089,190,0);
 INSERT INTO airport VALUES ('HUY','Humberside','GB','Kingston upon Hull','Yorkshire and the Humber','Great Britain',53.574444,-0.350833,37,0);
 INSERT INTO airport VALUES ('ILY','Islay','GB',NULL,NULL,'Islay',55.681944,-6.256667,17,0);
 INSERT INTO airport VALUES ('GLO','Gloucestershire','GB','Gloucester','South West England','Great Britain',51.894167,-2.167222,31,0);
 INSERT INTO airport VALUES ('GLA','Glasgow','GB','Glasgow','Scotland','Great Britain',55.871944,-4.433056,8,0);
 INSERT INTO airport VALUES ('SEN','Southend','GB','Southend-on-Sea','East of England','Great Britain',51.571389,.695556,15,0);
 INSERT INTO airport VALUES ('CWL','Cardiff','GB','Cardiff','Wales','Great Britain',51.396667,-3.343333,67,0);
 INSERT INTO airport VALUES ('KOI','Kirkwall','GB','Kirkwall','Scotland','Orkney Mainland',58.957778,-2.905,15,0);
 INSERT INTO airport VALUES ('LRD','Laredo Intl','USA','Laredo','Texas',NULL,27.54375,-99.461556,155,-6);
 INSERT INTO airport VALUES ('CMH','Port Columbus Intl','USA','Columbus','Ohio',NULL,39.997972,-82.891889,248,-5);
 INSERT INTO airport VALUES ('DSM','Des Moines Intl','USA','Des Moines','Iowa',NULL,41.533972,-93.663083,292,-6);
 INSERT INTO airport VALUES ('DTW','Detroit Metro Wayne Co','USA','Detroit','Michigan',NULL,42.212444,-83.353389,197,-5);
 INSERT INTO airport VALUES ('MSY','Louis Armstrong New Orleans Intl','USA','New Orleans','Louisiana',NULL,29.993389,-90.258028,1,-6);
 INSERT INTO airport VALUES ('MSP','Minneapolis St Paul Intl','USA','Minneapolis','Minnesota',NULL,44.881956,-93.221767,256,-6);
 INSERT INTO airport VALUES ('MSN','Dane Co Rgnl Truax Fld','USA','Madison','Wisconsin',NULL,43.139858,-89.337514,270,-6);
 INSERT INTO airport VALUES ('FAR','Hector International Airport','USA','Fargo','North Dakota',NULL,46.92065,-96.8157639,275,-6);
 INSERT INTO airport VALUES ('FAT','Fresno Yosemite Intl','USA','Fresno','California',NULL,36.776194,-119.71814,102,-8);
 INSERT INTO airport VALUES ('ELP','El Paso Intl','USA','El Paso','Texas',NULL,31.80725,-106.377583,1207,-7);
 INSERT INTO airport VALUES ('EVV','Evansville Regional','USA','Evansville','Indiana',NULL,38.036997,-87.532364,127,-6);
 INSERT INTO airport VALUES ('EWR','Newark Liberty Intl','USA','Newark','New Jersey',NULL,40.6925,-74.168667,5,-5);
 INSERT INTO airport VALUES ('EUG','Mahlon Sweet Fld','USA','Eugene','Oregon',NULL,44.124583,-123.211972,114,-8);
 INSERT INTO airport VALUES ('ERI','Erie Intl Tom Ridge Fld','USA','Erie','Pennsylvania',NULL,42.082022,-80.176217,223,-5);
 INSERT INTO airport VALUES ('MKE','General Mitchell Intl','USA','Milwaukee','Wisconsin',NULL,42.947222,-87.896583,220,-6);
 INSERT INTO airport VALUES ('MKL','Mc Kellar Sipes Rgnl','USA','Jackson','Mississippi',NULL,35.599889,-88.915611,132,-6);
 INSERT INTO airport VALUES ('DFW','Dallas Fort Worth Intl','USA','Dallas','Texas',NULL,32.896828,-97.037997,185,-6);
 INSERT INTO airport VALUES ('MIA','Miami Intl','USA','Miami','Florida',NULL,25.79325,-80.290556,2,-5);
 INSERT INTO airport VALUES ('MDT','Harrisburg Intl','USA','Harrisburg','Pennsylvania',NULL,40.193494,-76.763403,95,-5);
 INSERT INTO airport VALUES ('MEM','Memphis Intl','USA','Memphis','Tennessee',NULL,35.042417,-89.976667,104,-6);
 INSERT INTO airport VALUES ('MDW','Chicago Midway Intl','USA','Chicago','Illinois',NULL,41.785972,-87.752417,189,-6);
 INSERT INTO airport VALUES ('MCI','Kansas City Intl','USA','Kansas City','Missouri',NULL,39.297606,-94.713905,313,-6);
 INSERT INTO airport VALUES ('MCO','Orlando Intl','USA','Orlando','Florida',NULL,28.429394,-81.308994,29,-5);
 INSERT INTO airport VALUES ('MOB','Mobile Rgnl','USA','Mobile','Alabama',NULL,30.691231,-88.242814,67,-6);
 INSERT INTO airport VALUES ('MOD','Modesto City Co Harry Sham','USA','Modesto','California',NULL,37.625817,-120.954422,30,-8);
 INSERT INTO airport VALUES ('SDF','Louisville International Airport','USA','Louisville','Kentucky',NULL,38.1740858,-85.7364989,153,-5);
 INSERT INTO airport VALUES ('CLE','Cleveland Hopkins Intl','USA','Cleveland','Ohio',NULL,41.411689,-81.849794,241,-5);
 INSERT INTO airport VALUES ('SEA','Seattle Tacoma Intl','USA','Seattle','Washington',NULL,47.449,-122.309306,132,-8);
 INSERT INTO airport VALUES ('SFO','San Francisco Intl','USA','San Francisco','California',NULL,37.618972,-122.374889,4,-8);
 INSERT INTO airport VALUES ('CHS','Charleston Afb Intl','USA','Charleston','West Virginia',NULL,32.898647,-80.040528,14,-5);
 INSERT INTO airport VALUES ('SGF','Springfield Branson Natl','USA','Springfield','Missouri',NULL,37.245667,-93.388639,387,-6);
 INSERT INTO airport VALUES ('SPS','Sheppard Afb Wichita Falls Muni','USA','Wichita Falls','Texas',NULL,33.988797,-98.491894,311,-6);
 INSERT INTO airport VALUES ('LNK','Lincoln','USA','Lincoln','Nebraska',NULL,40.850971,-96.75925,372,-6);
 INSERT INTO airport VALUES ('COS','City Of Colorado Springs Muni','USA','Colorado Springs','Colorado',NULL,38.805805,-104.700778,1886,-7);
 INSERT INTO airport VALUES ('CLT','Charlotte Douglas Intl','USA','Charlotte','North Carolina',NULL,35.214,-80.943139,228,-5);
 INSERT INTO airport VALUES ('ALB','Albany Intl','USA','Albany','New York',NULL,42.748267,-73.801692,87,-5);
 INSERT INTO airport VALUES ('BNA','Nashville Intl','USA','Nashville-Davidson','Tennessee',NULL,36.124472,-86.678194,183,-6);
 INSERT INTO airport VALUES ('TPA','Tampa Intl','USA','Tampa','Florida',NULL,27.975472,-82.53325,8,-5);
 INSERT INTO airport VALUES ('BOI','Boise Air Terminal','USA','Boise City','Idaho',NULL,43.564361,-116.222861,875,-7);
 INSERT INTO airport VALUES ('BOS','General Edward Lawrence Logan Intl','USA','Boston','Massachusetts',NULL,42.364347,-71.005181,6,-5);
 INSERT INTO airport VALUES ('MVY','Martha''s Vineyard','USA',NULL,NULL,'Marthas Vineyard',41.391667,-70.615278,20,-5);
 INSERT INTO airport VALUES ('ACK','Nantucket Mem','USA',NULL,NULL,'Nantucket',41.253053,-70.060181,15,-5);
 INSERT INTO airport VALUES ('AMA','Rick Husband Amarillo Intl','USA','Amarillo','Texas',NULL,35.219369,-101.705931,1100,-6);
 INSERT INTO airport VALUES ('TOL','Toledo','USA','Toledo','Ohio',NULL,41.586806,-83.807833,209,-5);
 INSERT INTO airport VALUES ('SYR','Syracuse Hancock Intl','USA','Syracuse','New York',NULL,43.111187,-76.106311,128,-5);
 INSERT INTO airport VALUES ('CVG','Cincinnati Northern Kentucky Intl','USA','Cincinnati','Ohio',NULL,39.048836,-84.667822,273,-5);
 INSERT INTO airport VALUES ('STL','Lambert St Louis Intl','USA','St. Louis','Missouri',NULL,38.748697,-90.370028,188,-6);
 INSERT INTO airport VALUES ('CYS','Cheyenne Rgnl Jerry Olson Fld','USA','Cheyenne','Wyoming',NULL,41.155722,-104.811839,1877,-7);
 INSERT INTO airport VALUES ('DAL','Dallas Love Fld','USA','Dallas','Texas',NULL,32.847111,-96.851778,148,-6);
 INSERT INTO airport VALUES ('DAY','James M Cox Dayton Intl','USA','Dayton','Ohio',NULL,39.902375,-84.219375,308,-5);
 INSERT INTO airport VALUES ('LAS','Mc Carran Intl','USA','Las Vegas','Nevada',NULL,36.080056,-115.15225,653,-8);
 INSERT INTO airport VALUES ('LAN','Capital City','USA','Lansing','Michigan',NULL,42.7787,-84.587357,263,-5);
 INSERT INTO airport VALUES ('CRP','Corpus Christi Intl','USA','Corpus Christi','Texas',NULL,27.770361,-97.501222,13,-6);
 INSERT INTO airport VALUES ('SLC','Salt Lake City Intl','USA','Salt Lake City','Utah',NULL,40.788389,-111.977772,1289,-7);
 INSERT INTO airport VALUES ('CRW','Yeager','USA','Charleston','West Virginia',NULL,38.373147,-81.593189,299,-5);
 INSERT INTO airport VALUES ('CSG','Columbus Metropolitan Airport','USA','Columbus','Georgia',NULL,32.5163333,-84.9388611,121,-5);
 INSERT INTO airport VALUES ('SMF','Sacramento Intl','USA','Sacramento','California',NULL,38.695417,-121.590778,8,-8);
 INSERT INTO airport VALUES ('LUK','Cincinnati Muni Lunken Fld','USA','Cincinnati','Ohio',NULL,39.103333,-84.418611,147,-5);
 INSERT INTO airport VALUES ('SNA','John Wayne Arpt Orange Co','USA','Santa Ana','California',NULL,33.675667,-117.868222,17,-8);
 INSERT INTO airport VALUES ('LAX','Los Angeles Intl','USA','Los Angeles','California',NULL,33.942536,-118.408075,38,-8);
 INSERT INTO airport VALUES ('LBB','Lubbock Preston Smith Intl','USA','Lubbock','Texas',NULL,33.663639,-101.822778,1001,-6);
 INSERT INTO airport VALUES ('DEN','Denver Intl','USA','Denver','Colorado',NULL,39.861656,-104.673178,1656,-7);
 INSERT INTO airport VALUES ('DCA','Ronald Reagan Washington Natl','USA','Washington','District of Columbia',NULL,38.852083,-77.037722,5,-5);
 INSERT INTO airport VALUES ('LGB','Long Beach','USA','Long Beach','California',NULL,33.817722,-118.151611,18,-8);
 INSERT INTO airport VALUES ('LGA','La Guardia','USA','New York','New York','Long Island',40.777245,-73.872608,7,-5);
 INSERT INTO airport VALUES ('CHA','Lovell Fld','USA','Chattanooga','Tennessee',NULL,35.035278,-85.203808,208,-5);
 INSERT INTO airport VALUES ('SHV','Shreveport Rgnl','USA','Shreveport','Louisiana',NULL,32.446629,-93.8256,79,-6);
 INSERT INTO airport VALUES ('LIT','Adams Fld','USA','Little Rock','Arkansas',NULL,34.729444,-92.224306,80,-6);
 INSERT INTO airport VALUES ('SJC','Norman Y Mineta San Jose Intl','USA','San Jose','California',NULL,37.3626,-121.929022,19,-8);
 INSERT INTO airport VALUES ('BHM','Birmingham Intl','USA','Birmingham','Alabama',NULL,33.562942,-86.75355,196,-6);
 INSERT INTO airport VALUES ('BIS','Bismarck Municipal Airport','USA','Bismarck','North Dakota',NULL,46.775842,-100.757931,506,-6);
 INSERT INTO airport VALUES ('BIL','Billings Logan International Airport','USA','Billings','Montana',NULL,45.80921,-108.537654,1113,-7);
 INSERT INTO airport VALUES ('TUL','Tulsa Intl','USA','Tulsa','Oklahoma',NULL,36.198389,-95.888111,206,-6);
 INSERT INTO airport VALUES ('TUS','Tucson Intl','USA','Tucson','Arizona',NULL,32.116083,-110.941028,806,-7);
 INSERT INTO airport VALUES ('RNO','Reno Tahoe Intl','USA','Reno','Nevada',NULL,39.499108,-119.768108,1346,-8);
 INSERT INTO airport VALUES ('BUF','Buffalo Niagara Intl','USA','Buffalo','New York',NULL,42.940525,-78.732167,221,-5);
 INSERT INTO airport VALUES ('ATL','Hartsfield Jackson Atlanta Intl','USA','Atlanta','Georgia',NULL,33.636719,-84.428067,313,-5);
 INSERT INTO airport VALUES ('BTR','Baton Rouge Metro Ryan Fld','USA','Baton Rouge','Louisiana',NULL,30.533167,-91.149639,21,-6);
 INSERT INTO airport VALUES ('AUS','Austin Bergstrom Intl','USA','Austin','Texas',NULL,30.194528,-97.669889,165,-6);
 INSERT INTO airport VALUES ('TYS','Mc Ghee Tyson','USA','Knoxville','Tennessee',NULL,35.810972,-83.994028,299,-5);
 INSERT INTO airport VALUES ('BWI','Baltimore Washington Intl','USA','Baltimore','Maryland',NULL,39.175361,-76.668333,45,-5);
 INSERT INTO airport VALUES ('CAK','Akron Canton Regional Airport','USA','Akron','Ohio',NULL,40.9160833,-81.4421944,374,-5);
 INSERT INTO airport VALUES ('ABE','Lehigh Valley Intl','USA','Allentown','Pennsylvania',NULL,40.652083,-75.440806,120,-5);
 INSERT INTO airport VALUES ('ABI','Abilene Rgnl','USA','Abilene','Texas',NULL,32.411319,-99.681897,546,-6);
 INSERT INTO airport VALUES ('TLH','Tallahassee Rgnl','USA','Tallahassee','Florida',NULL,30.396528,-84.350333,25,-5);
 INSERT INTO airport VALUES ('ACT','Waco Rgnl','USA','Waco','Texas',NULL,31.611289,-97.230519,157,-6);
 INSERT INTO airport VALUES ('ABQ','Albuquerque International Sunport','USA','Albuquerque','New Mexico',NULL,35.0402222,-106.6091944,1633,-7);
 INSERT INTO airport VALUES ('SAN','San Diego Intl','USA','San Diego','California',NULL,32.733556,-117.189667,5,-8);
 INSERT INTO airport VALUES ('SAT','San Antonio Intl','USA','San Antonio','Texas',NULL,29.533694,-98.469778,247,-6);
 INSERT INTO airport VALUES ('SAV','Savannah Hilton Head Intl','USA','Savannah','Georgia',NULL,32.127583,-81.202139,16,-5);
 INSERT INTO airport VALUES ('PWM','Portland Intl Jetport','USA','Portland','Maine',NULL,43.646161,-70.309281,23,-5);
 INSERT INTO airport VALUES ('PVD','Theodore Francis Green State','USA','Providence','Rhode Island',NULL,41.732581,-71.420383,17,-5);
 INSERT INTO airport VALUES ('IND','Indianapolis Intl','USA','Indianapolis','Indiana',NULL,39.717331,-86.294383,243,-5);
 INSERT INTO airport VALUES ('IAD','Washington Dulles Intl','USA','Washington','District of Columbia',NULL,38.944533,-77.455811,95,-5);
 INSERT INTO airport VALUES ('IAH','George Bush Intcntl Houston','USA','Houston','Texas',NULL,29.984433,-95.341442,30,-6);
 INSERT INTO airport VALUES ('ICT','Wichita Mid Continent','USA','Wichita','Kansas',NULL,37.649944,-97.433056,406,-6);
 INSERT INTO airport VALUES ('HOU','William P Hobby','USA','Houston','Texas',NULL,29.645419,-95.278889,14,-6);
 INSERT INTO airport VALUES ('ROC','Greater Rochester Intl','USA','Rochester','New York',NULL,43.118866,-77.672389,170,-5);
 INSERT INTO airport VALUES ('FLL','Fort Lauderdale Hollywood Intl','USA','Fort Lauderdale','Florida',NULL,26.072583,-80.15275,3,-5);
 INSERT INTO airport VALUES ('OMA','Eppley Afld','USA','Omaha','Nebraska',NULL,41.303167,-95.894069,300,-6);
 INSERT INTO airport VALUES ('PDX','Portland Intl','USA','Portland','Oregon',NULL,45.588722,-122.5975,9,-8);
 INSERT INTO airport VALUES ('ORF','Norfolk Intl','USA','Norfolk','Virginia',NULL,36.894611,-76.201222,8,-5);
 INSERT INTO airport VALUES ('ORD','Chicago Ohare Intl','USA','Chicago','Illinois',NULL,41.978603,-87.904842,204,-6);
 INSERT INTO airport VALUES ('FNT','Bishop International','USA','Flint','Michigan',NULL,42.965424,-83.743629,238,-5);
 INSERT INTO airport VALUES ('PHX','Phoenix Sky Harbor Intl','USA','Phoenix','Arizona',NULL,33.434278,-112.011583,346,-7);
 INSERT INTO airport VALUES ('PIT','Pittsburgh Intl','USA','Pittsburgh','Pennsylvania',NULL,40.491467,-80.232872,367,-5);
 INSERT INTO airport VALUES ('PIR','Pierre Regional Airport','USA','Pierre','South Dakota',NULL,44.3827,-100.286,531,-6);
 INSERT INTO airport VALUES ('PHL','Philadelphia Intl','USA','Philadelphia','Pennsylvania',NULL,39.871944,-75.241139,11,-5);
 INSERT INTO airport VALUES ('HLN','Helena Rgnl','USA','Helena','Montana',NULL,46.606806,-111.98275,1182,-7);
 INSERT INTO airport VALUES ('GEG','Spokane Intl','USA','Spokane','Washington',NULL,47.619861,-117.533833,724,-8);
 INSERT INTO airport VALUES ('OKC','Will Rogers World','USA','Oklahoma City','Oklahoma',NULL,35.393089,-97.600733,395,-6);
 INSERT INTO airport VALUES ('RIC','Richmond Intl','USA','Richmond','Virginia',NULL,37.505167,-77.319667,51,-5);
 INSERT INTO airport VALUES ('JFK','John F Kennedy Intl','USA','New York','New York','Long Island',40.639751,-73.778925,4,-5);
 INSERT INTO airport VALUES ('JAX','Jacksonville Intl','USA','Jacksonville','Florida',NULL,30.494056,-81.687861,9,-5);
 INSERT INTO airport VALUES ('JAN','Jackson Evers Intl','USA','Jackson','Mississippi',NULL,32.311167,-90.075889,105,-6);
 INSERT INTO airport VALUES ('SAF','Santa Fe Muni','USA','Santa Fe','New Mexico',NULL,35.617108,-106.089422,1935,-7);
 INSERT INTO airport VALUES ('OAJ','Albert J Ellis','USA','Jacksonville','Florida',NULL,34.829164,-77.612139,29,-5);
 INSERT INTO airport VALUES ('OAK','Metropolitan Oakland Intl','USA','Oakland','California',NULL,37.721278,-122.220722,3,-8);
 INSERT INTO airport VALUES ('JNU','Juneau Intl','USA','Juneau','Alaska',NULL,58.354972,-134.576278,6,-9);
 INSERT INTO airport VALUES ('ANC','Ted Stevens Anchorage Intl','USA','Anchorage','Alaska',NULL,61.174361,-149.996361,46,-9);
 INSERT INTO airport VALUES ('HNL','Honolulu Intl','USA','Honolulu','Hawaii','Oahu',21.318681,-157.922428,4,-10);
 INSERT INTO airport VALUES ('ITO','Hilo Intl','USA','Hilo','Hawaii','Hawaii',19.721375,-155.048469,12,-10);
 INSERT INTO airport VALUES ('LNY','Lanai','USA',NULL,NULL,'Lanai',20.785611,-156.951419,399,-10);
 INSERT INTO airport VALUES ('MKK','Molokai','USA',NULL,NULL,'Molokai',21.152886,-157.096256,138,-10);
 INSERT INTO airport VALUES ('OGG','Kahului','USA',NULL,NULL,'Maui',20.89865,-156.430458,16,-10);
 INSERT INTO airport VALUES ('MVD','Carrasco Intl','ROU','Montevideo','Uruguay',NULL,-34.838417,-56.030806,32,-3);
 INSERT INTO airport VALUES ('BHK','Bukhara','UZ','Buxoro','Buxoro',NULL,39.775,64.483333,229,5);
 INSERT INTO airport VALUES ('UGC','Urgench Airport','UZ','Urganch','Xorazm',NULL,41.5843,60.6417,98,5);
 INSERT INTO airport VALUES ('TMJ','Termez Airport','UZ','Termiz','Surkhandarya',NULL,37.286667,67.31,313,5);
 INSERT INTO airport VALUES ('TAS','Yuzhny','UZ','Toshkent','Toshkent City',NULL,41.257861,69.281186,432,5);
 INSERT INTO airport VALUES ('NCU','Nukus Airport','UZ','Nukus','Qoraqalpogʻiston',NULL,42.4884,59.6233,75,5);
 INSERT INTO airport VALUES ('FEG','Fergana Airport','UZ','Fargona','Fargʻona',NULL,40.3588,71.745,604,5);
 INSERT INTO airport VALUES ('SKD','Samarkand','UZ','Samarqand','Samarqand',NULL,39.700547,66.983829,678,5);
 INSERT INTO airport VALUES ('VLI','Port Vila Bauerfield','VU','Port Vila','Vanuatu','Efate',-17.699325,168.319794,21,11);
 INSERT INTO airport VALUES ('PZO','General Manuel Carlos Piar','YV','Ciudad Guayana','Bolívar',NULL,8.288528,-62.760361,144,-4);
 INSERT INTO airport VALUES ('BLA','General Jose Antonio Anzoategui Intl','YV','Barcelona','Anzoátegui',NULL,10.107139,-64.689161,8,-4);
 INSERT INTO airport VALUES ('PYH','Casique Aramare','YV','Puerto Ayacucho','Amazonas',NULL,5.619992,-67.606103,75,-4);
 INSERT INTO airport VALUES ('BNS','Barinas','YV','Barinas','Barinas',NULL,8.619575,-70.220825,203,-4);
 INSERT INTO airport VALUES ('BRM','Barquisimeto Intl','YV','Barquisimeto','Lara',NULL,10.042747,-69.358619,623,-4);
 INSERT INTO airport VALUES ('MAR','La Chinita Intl','YV','Maracaibo','Zulia',NULL,10.558208,-71.727856,72,-4);
 INSERT INTO airport VALUES ('VLN','Arturo Michelena Intl','YV','Valencia','Carabobo',NULL,10.149733,-67.9284,432,-4);
 INSERT INTO airport VALUES ('MUN','Maturin','YV','Maturín','Monagas',NULL,9.749067,-63.1534,68,-4);
 INSERT INTO airport VALUES ('CCS','Simon Bolivar Intl','YV','Caracas','Distrito Federal',NULL,10.603117,-66.990583,72,-4);
 INSERT INTO airport VALUES ('PMV','Caribe Santiago Mariño','YV','Porlamar','Nueva Esparta','Isla Margarita',10.89,-63.65,14,-4);
 INSERT INTO airport VALUES ('VKG','Rach Gia','VN','Rach Gia','Mekong River Delta',NULL,9.949676,105.133659,2,7);
 INSERT INTO airport VALUES ('VII','Vinh Airport','VN','Vinh','North and South Central Coast',NULL,18.737569,105.670764,7,7);
 INSERT INTO airport VALUES ('SGN','Tansonnhat Intl','VN','Thanh Pho Ho Chi Minh','Southeast',NULL,10.818797,106.651856,10,7);
 INSERT INTO airport VALUES ('HAN','Noibai Intl','VN','Hanoi','Red River Delta',NULL,21.221192,105.807178,12,7);
 INSERT INTO airport VALUES ('HPH','Cat Bi International Airport','VN','Haiphong','Red River Delta',NULL,20.819386,106.724989,2,7);
 INSERT INTO airport VALUES ('VCA','Tra Noc Airport','VN','Can Tho','Mekong River Delta',NULL,10.085119,105.711922,3,7);
 INSERT INTO airport VALUES ('NHA','Nha Trang','VN','Nha Trang','North and South Central Coast',NULL,12.227467,109.192322,6,7);
 INSERT INTO airport VALUES ('STT','Cyril E King','VIRG','Charlotte Amalie','Virgin Islands','Saint Thomas',18.337306,-64.973361,7,-4);
 INSERT INTO airport VALUES ('WLS','Wallis','WF','Mata-Utu','Wallis and Futuna','Uvea',-13.238281,-176.199228,24,12);
 INSERT INTO airport VALUES ('EUN','Hassan I Airport','WSA','El Aaiun','Western Sahara',NULL,27.1517,-13.2192,63,0);
 INSERT INTO airport VALUES ('SAH','Sanaa Intl','YE','Sanaa','Yemen',NULL,15.476258,44.219739,2200,3);
 INSERT INTO airport VALUES ('HOD','Hodeidah Intl','YE','al Hudaydah','Yemen',NULL,14.753,42.976336,13,3);
 INSERT INTO airport VALUES ('TAI','Taiz Intl','YE','Taizz','Yemen',NULL,13.685964,44.139056,1475,3);
 INSERT INTO airport VALUES ('ADE','Aden Intl','YE','Aden','Yemen',NULL,12.829542,45.028792,2,3);
 INSERT INTO airport VALUES ('LVI','Livingstone','Z','Livingstone','Southern',NULL,-17.821756,25.822692,1007,2);
 INSERT INTO airport VALUES ('NLA','Ndola','Z','Ndola','Copperbelt',NULL,-12.998139,28.664944,1270,2);
 INSERT INTO airport VALUES ('LUN','Lusaka Intl','Z','Lusaka','Lusaka',NULL,-15.330817,28.452628,1152,2);
 INSERT INTO airport VALUES ('BUQ','J M Nkomo Intl','ZW','Bulawayo','Zimbabwe',NULL,-20.017431,28.617869,1329,2);
 INSERT INTO airport VALUES ('HRE','Harare Intl','ZW','Harare','Zimbabwe',NULL,-17.931806,31.092847,1490,2);
 
 


