 INSERT INTO geo_lake VALUES ('Lake Nasser','SUD','ash Shamaliyah');
 INSERT INTO geo_lake VALUES ('Lake Volta','GH','Ghana');
 INSERT INTO geo_lake VALUES ('Lake Bosumtwi','GH','Ghana');
 INSERT INTO geo_lake VALUES ('Lake Kainji','WAN','Nigeria');
 INSERT INTO geo_lake VALUES ('Chad Lake','RN','Niger');
 INSERT INTO geo_lake VALUES ('Chad Lake','WAN','Nigeria');
 INSERT INTO geo_lake VALUES ('Chad Lake','CAM','Nord extreme');
 INSERT INTO geo_lake VALUES ('Chad Lake','TCH','Chad');
 INSERT INTO geo_lake VALUES ('Barrage de Mbakaou','CAM','Adamaoua');
 INSERT INTO geo_lake VALUES ('Lake Nyos','CAM','Nordoueste');
 INSERT INTO geo_lake VALUES ('Lac Assal','DJI','Djibouti');
 INSERT INTO geo_lake VALUES ('Lake Abbe','DJI','Djibouti');
 INSERT INTO geo_lake VALUES ('Lake Abbe','ETH','Ethiopia');
 INSERT INTO geo_lake VALUES ('Lake Abaya','ETH','Ethiopia');
 INSERT INTO geo_lake VALUES ('Chew Bahir','ETH','Ethiopia');
 INSERT INTO geo_lake VALUES ('Chew Bahir','EAK','Eastern');
 INSERT INTO geo_lake VALUES ('Lake Turkana','ETH','Ethiopia');
 INSERT INTO geo_lake VALUES ('Lake Turkana','EAK','Eastern');
 INSERT INTO geo_lake VALUES ('Lake Turkana','EAK','Rift Valley');
 INSERT INTO geo_lake VALUES ('Lake Tana','ETH','Ethiopia');
 INSERT INTO geo_lake VALUES ('Lake Sese Seko/Albertsee','ZRE','Haut Zaire');
 INSERT INTO geo_lake VALUES ('Lake Sese Seko/Albertsee','EAU','Uganda');
 INSERT INTO geo_lake VALUES ('Rutanzige/Eduardsee','ZRE','Kivu');
 INSERT INTO geo_lake VALUES ('Rutanzige/Eduardsee','EAU','Uganda');
 INSERT INTO geo_lake VALUES ('Lake Kioga','EAU','Uganda');
 INSERT INTO geo_lake VALUES ('Lake Victoria','EAT','Kagera');
 INSERT INTO geo_lake VALUES ('Lake Victoria','EAT','Mwanza');
 INSERT INTO geo_lake VALUES ('Lake Victoria','EAT','Mara');
 INSERT INTO geo_lake VALUES ('Lake Victoria','EAK','Nyanza');
 INSERT INTO geo_lake VALUES ('Lake Victoria','EAK','Western');
 INSERT INTO geo_lake VALUES ('Lake Victoria','EAU','Uganda');
 INSERT INTO geo_lake VALUES ('Lake Kivu','ZRE','Kivu');
 INSERT INTO geo_lake VALUES ('Lake Kivu','RWA','Rwanda');
 INSERT INTO geo_lake VALUES ('Lake Tanganjika','ZRE','Kivu');
 INSERT INTO geo_lake VALUES ('Lake Tanganjika','ZRE','Shaba/Katanga');
 INSERT INTO geo_lake VALUES ('Lake Tanganjika','Z','Northern');
 INSERT INTO geo_lake VALUES ('Lake Tanganjika','BI','Burundi');
 INSERT INTO geo_lake VALUES ('Lake Tanganjika','EAT','Mbeya');
 INSERT INTO geo_lake VALUES ('Lake Tanganjika','EAT','Tabora');
 INSERT INTO geo_lake VALUES ('Lake Tanganjika','EAT','Kigoma');
 INSERT INTO geo_lake VALUES ('Lake Mweru','ZRE','Shaba/Katanga');
 INSERT INTO geo_lake VALUES ('Lake Mweru','Z','Luapula');
 INSERT INTO geo_lake VALUES ('Lake Bangweulu','Z','Luapula');
 INSERT INTO geo_lake VALUES ('Lake Bangweulu','Z','Northern');
 INSERT INTO geo_lake VALUES ('Lake Rukwa','EAT','Mbeya');
 INSERT INTO geo_lake VALUES ('Lake Rukwa','EAT','Tabora');
 INSERT INTO geo_lake VALUES ('Lake Eyasi','EAT','Arusha');
 INSERT INTO geo_lake VALUES ('Lake Natron','EAT','Arusha');
 INSERT INTO geo_lake VALUES ('Lake Malawi','EAT','Ruvuma');
 INSERT INTO geo_lake VALUES ('Lake Malawi','EAT','Iringa');
 INSERT INTO geo_lake VALUES ('Lake Malawi','MW','Malawi');
 INSERT INTO geo_lake VALUES ('Lake Malawi','MOC','Niassa');
 INSERT INTO geo_lake VALUES ('Lake Chilwa','MW','Malawi');
 INSERT INTO geo_lake VALUES ('Lake Chilwa','MOC','Niassa');
 INSERT INTO geo_lake VALUES ('Lake Mai Ndombe','ZRE','Bandundu');
 INSERT INTO geo_lake VALUES ('Lake Cabora-Bassa','MOC','Tete');
 INSERT INTO geo_lake VALUES ('Lake Kariba','Z','Southern');
 INSERT INTO geo_lake VALUES ('Lake Kariba','ZW','Zimbabwe');
 INSERT INTO geo_lake VALUES ('Lake Ngami','RB','Botswana');
 INSERT INTO geo_lake VALUES ('Etoscha Salt Pan','NAM','Namibia');
 INSERT INTO geo_lake VALUES ('Makarikari Salt Pan','RB','Botswana');
 INSERT INTO geo_lake VALUES ('Great Bear Lake','CDN','Northwest Territories');
 INSERT INTO geo_lake VALUES ('Great Slave Lake','CDN','Northwest Territories');
 INSERT INTO geo_lake VALUES ('Atlin Lake','CDN','British Columbia');
 INSERT INTO geo_lake VALUES ('Atlin Lake','CDN','Yukon Territory');
 INSERT INTO geo_lake VALUES ('Lake Winnipeg','CDN','Manitoba');
 INSERT INTO geo_lake VALUES ('Lake Nipigon','CDN','Ontario');
 INSERT INTO geo_lake VALUES ('Lake Manicouagan','CDN','Quebec');
 INSERT INTO geo_lake VALUES ('Lake Ontario','CDN','Ontario');
 INSERT INTO geo_lake VALUES ('Lake Ontario','USA','New York');
 INSERT INTO geo_lake VALUES ('Lake Erie','CDN','Ontario');
 INSERT INTO geo_lake VALUES ('Lake Erie','USA','Michigan');
 INSERT INTO geo_lake VALUES ('Lake Erie','USA','New York');
 INSERT INTO geo_lake VALUES ('Lake Erie','USA','Ohio');
 INSERT INTO geo_lake VALUES ('Lake Erie','USA','Pennsylvania');
 INSERT INTO geo_lake VALUES ('Lake Huron','CDN','Ontario');
 INSERT INTO geo_lake VALUES ('Lake Huron','USA','Michigan');
 INSERT INTO geo_lake VALUES ('Lake Manitou','CDN','Ontario');
 INSERT INTO geo_lake VALUES ('Lake Michigan','USA','Illinois');
 INSERT INTO geo_lake VALUES ('Lake Michigan','USA','Indiana');
 INSERT INTO geo_lake VALUES ('Lake Michigan','USA','Michigan');
 INSERT INTO geo_lake VALUES ('Lake Michigan','USA','Wisconsin');
 INSERT INTO geo_lake VALUES ('Lake Superior','CDN','Ontario');
 INSERT INTO geo_lake VALUES ('Lake Superior','USA','Michigan');
 INSERT INTO geo_lake VALUES ('Lake Superior','USA','Minnesota');
 INSERT INTO geo_lake VALUES ('Lake Superior','USA','Wisconsin');
 INSERT INTO geo_lake VALUES ('Lake Champlain','CDN','Quebec');
 INSERT INTO geo_lake VALUES ('Lake Champlain','USA','New York');
 INSERT INTO geo_lake VALUES ('Lake Champlain','USA','Vermont');
 INSERT INTO geo_lake VALUES ('Lake Winnipesaukee','USA','New Hampshire');
 INSERT INTO geo_lake VALUES ('Lake Okeechobee','USA','Florida');
 INSERT INTO geo_lake VALUES ('Kentucky Lake','USA','Kentucky');
 INSERT INTO geo_lake VALUES ('Kentucky Lake','USA','Tennessee');
 INSERT INTO geo_lake VALUES ('Chickamauga Lake','USA','Tennessee');
 INSERT INTO geo_lake VALUES ('Franklin. D. Roosevelt Lake','USA','Washington');
 INSERT INTO geo_lake VALUES ('Crater Lake','USA','Oregon');
 INSERT INTO geo_lake VALUES ('Great Salt Lake','USA','Utah');
 INSERT INTO geo_lake VALUES ('Lake Tahoe','USA','California');
 INSERT INTO geo_lake VALUES ('Lake Tahoe','USA','Nevada');
 INSERT INTO geo_lake VALUES ('Pyramid Lake','USA','Nevada');
 INSERT INTO geo_lake VALUES ('Lake Powell','USA','Arizona');
 INSERT INTO geo_lake VALUES ('Lake Powell','USA','Utah');
 INSERT INTO geo_lake VALUES ('Lake Mead','USA','Arizona');
 INSERT INTO geo_lake VALUES ('Lake Mead','USA','Nevada');
 INSERT INTO geo_lake VALUES ('Fort Peck Lake','USA','Montana');
 INSERT INTO geo_lake VALUES ('Lake Sakakawea','USA','Montana');
 INSERT INTO geo_lake VALUES ('Lake Sakakawea','USA','North Dakota');
 INSERT INTO geo_lake VALUES ('Lake Oahe','USA','North Dakota');
 INSERT INTO geo_lake VALUES ('Lake Oahe','USA','South Dakota');
 INSERT INTO geo_lake VALUES ('Lago de Chapala','MEX','Jalisco');
 INSERT INTO geo_lake VALUES ('Lake Nicaragua','CR','Alajuela');
 INSERT INTO geo_lake VALUES ('Lake Nicaragua','CR','Guanacaste');
 INSERT INTO geo_lake VALUES ('Lake Nicaragua','NIC','Nicaragua');
 INSERT INTO geo_lake VALUES ('Lake Managua','NIC','Nicaragua');
 INSERT INTO geo_lake VALUES ('Lake Irazu','CR','Cartago');
 INSERT INTO geo_lake VALUES ('Lake Maracaibo','YV','Merida');
 INSERT INTO geo_lake VALUES ('Lake Maracaibo','YV','Trujillo');
 INSERT INTO geo_lake VALUES ('Lake Maracaibo','YV','Zulia');
 INSERT INTO geo_lake VALUES ('Lago de Sobradinho','BR','Bahia');
 INSERT INTO geo_lake VALUES ('Lake Titicaca','BOL','Bolivia');
 INSERT INTO geo_lake VALUES ('Lake Titicaca','PE','Puno');
 INSERT INTO geo_lake VALUES ('Poopo','BOL','Bolivia');
 INSERT INTO geo_lake VALUES ('Salar de Uyuni','BOL','Bolivia');
 INSERT INTO geo_lake VALUES ('Licancabur Crater Lake','BOL','Bolivia');
 INSERT INTO geo_lake VALUES ('Licancabur Crater Lake','RCH','Chile');
 INSERT INTO geo_lake VALUES ('Laguna Mar Chiquita','RA','Cordoba');
 INSERT INTO geo_lake VALUES ('Laguna Mar Chiquita','RA','Santa Fe');
 INSERT INTO geo_lake VALUES ('Laguna Mar Chiquita','RA','Santiago de Estero');
 INSERT INTO geo_lake VALUES ('Lake Eyre','AUS','South Australia');
 INSERT INTO geo_lake VALUES ('Lake Burley Griffin','AUS','Australia Capital Territory');
 INSERT INTO geo_lake VALUES ('Lake Hume','AUS','New South Wales');
 INSERT INTO geo_lake VALUES ('Lake Hume','AUS','Victoria');
 INSERT INTO geo_island VALUES ('Svalbard','SVAX','Svalbard');
 INSERT INTO geo_island VALUES ('Greenland','GROX','Greenland');
 INSERT INTO geo_island VALUES ('Iceland','IS','Iceland');
 INSERT INTO geo_island VALUES ('Aust-Vagoey','N','Nordland');
 INSERT INTO geo_island VALUES ('Streymoy','FARX','Faroe Islands');
 INSERT INTO geo_island VALUES ('Ireland','IRL','Ireland');
 INSERT INTO geo_island VALUES ('Ireland','GB','Northern Ireland');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Avon');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Bedfordshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Berkshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Buckinghamshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Cambridgeshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Cheshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Cleveland');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Cornwall');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Cumbria');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Derbyshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Devon');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Dorset');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Durham');
 INSERT INTO geo_island VALUES ('Great Britain','GB','East Sussex');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Essex');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Gloucestershire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Greater London');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Greater Manchester');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Hampshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Hereford and Worcester');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Hertfordshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Humberside');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Kent');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Lancashire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Leicestershire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Lincolnshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Merseyside');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Norfolk');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Northamptonshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Northumberland');
 INSERT INTO geo_island VALUES ('Great Britain','GB','North Yorkshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Nottinghamshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Oxfordshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Shropshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Somerset');
 INSERT INTO geo_island VALUES ('Great Britain','GB','South Yorkshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Staffordshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Suffolk');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Surrey');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Tyne and Wear');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Warwickshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','West Midlands');
 INSERT INTO geo_island VALUES ('Great Britain','GB','West Sussex');
 INSERT INTO geo_island VALUES ('Great Britain','GB','West Yorkshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Wiltshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Borders');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Central');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Dumfries and Galloway');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Fife');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Grampian');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Highland');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Lothian');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Strathclyde');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Tayside');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Aberconwy and Colwyn');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Blaenau Gwent');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Bridgend');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Caerphilly');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Cardiff');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Carmarthenshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Ceredigion');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Denbighshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Flintshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Gwynedd');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Merthyr Tydfil');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Monmouthshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Neath and Port Talbot');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Newport');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Pembrokeshire');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Powys');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Rhondda Cynon Taff');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Swansea');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Torfaen');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Vale of Glamorgan');
 INSERT INTO geo_island VALUES ('Great Britain','GB','Wrexham');
 INSERT INTO geo_island VALUES ('Shetland Mainland','GB','Shetland');
 INSERT INTO geo_island VALUES ('Orkney Mainland','GB','Orkneys');
 INSERT INTO geo_island VALUES ('South Ronaldsay','GB','Orkneys');
 INSERT INTO geo_island VALUES ('Hoy','GB','Orkneys');
 INSERT INTO geo_island VALUES ('Westray','GB','Orkneys');
 INSERT INTO geo_island VALUES ('Barra','GB','Outer Hebrides');
 INSERT INTO geo_island VALUES ('South Uist','GB','Outer Hebrides');
 INSERT INTO geo_island VALUES ('Benbecula','GB','Outer Hebrides');
 INSERT INTO geo_island VALUES ('North Uist','GB','Outer Hebrides');
 INSERT INTO geo_island VALUES ('Lewis and Harris','GB','Outer Hebrides');
 INSERT INTO geo_island VALUES ('Skye','GB','Highland');
 INSERT INTO geo_island VALUES ('Rhum','GB','Highland');
 INSERT INTO geo_island VALUES ('Mull','GB','Highland');
 INSERT INTO geo_island VALUES ('Islay','GB','Strathclyde');
 INSERT INTO geo_island VALUES ('Jura','GB','Strathclyde');
 INSERT INTO geo_island VALUES ('Arran','GB','Strathclyde');
 INSERT INTO geo_island VALUES ('Isle of Man','GBM','Man');
 INSERT INTO geo_island VALUES ('Anglesey','GB','Anglesey');
 INSERT INTO geo_island VALUES ('Isle of Wight','GB','Isle of Wight');
 INSERT INTO geo_island VALUES ('Lundy','GB','Devon');
 INSERT INTO geo_island VALUES ('Bishop Rock','GB','Cornwall');
 INSERT INTO geo_island VALUES ('Guernsey','GBG','Guernsey');
 INSERT INTO geo_island VALUES ('Jersey','GBJ','Jersey');
 INSERT INTO geo_island VALUES ('Gotland','S','Gotland');
 INSERT INTO geo_island VALUES ('Oeland','S','Kalmar');
 INSERT INTO geo_island VALUES ('Aland','SF','Aland');
 INSERT INTO geo_island VALUES ('Dagoe','EW','Estonia');
 INSERT INTO geo_island VALUES ('Oesel','EW','Estonia');
 INSERT INTO geo_island VALUES ('Seeland','DK','Denmark');
 INSERT INTO geo_island VALUES ('Fuenen','DK','Denmark');
 INSERT INTO geo_island VALUES ('Langeland','DK','Denmark');
 INSERT INTO geo_island VALUES ('Falster','DK','Denmark');
 INSERT INTO geo_island VALUES ('Lolland','DK','Denmark');
 INSERT INTO geo_island VALUES ('Bornholm','DK','Denmark');
 INSERT INTO geo_island VALUES ('Helgoland','D','Schleswig Holstein');
 INSERT INTO geo_island VALUES ('Fehmarn','D','Schleswig Holstein');
 INSERT INTO geo_island VALUES ('Rugen','D','Mecklenburg Vorpommern');
 INSERT INTO geo_island VALUES ('Usedom','D','Mecklenburg Vorpommern');
 INSERT INTO geo_island VALUES ('Usedom','PL','Szczecinskie');
 INSERT INTO geo_island VALUES ('Sylt','D','Schleswig Holstein');
 INSERT INTO geo_island VALUES ('Fohr','D','Schleswig Holstein');
 INSERT INTO geo_island VALUES ('Amrum','D','Schleswig Holstein');
 INSERT INTO geo_island VALUES ('Pellworm','D','Schleswig Holstein');
 INSERT INTO geo_island VALUES ('Wangerooge','D','Niedersachsen');
 INSERT INTO geo_island VALUES ('Spiekeroog','D','Niedersachsen');
 INSERT INTO geo_island VALUES ('Langeoog','D','Niedersachsen');
 INSERT INTO geo_island VALUES ('Baltrum','D','Niedersachsen');
 INSERT INTO geo_island VALUES ('Norderney','D','Niedersachsen');
 INSERT INTO geo_island VALUES ('Juist','D','Niedersachsen');
 INSERT INTO geo_island VALUES ('Borkum','D','Niedersachsen');
 INSERT INTO geo_island VALUES ('Schiermonnikoog','NL','Friesland');
 INSERT INTO geo_island VALUES ('Ameland','NL','Friesland');
 INSERT INTO geo_island VALUES ('Terschelling','NL','Friesland');
 INSERT INTO geo_island VALUES ('Vlieland','NL','Friesland');
 INSERT INTO geo_island VALUES ('Texel','NL','Noord Holland');
 INSERT INTO geo_island VALUES ('Korfu','GR','Ionioi Nisoi');
 INSERT INTO geo_island VALUES ('Lefkas','GR','Ionioi Nisoi');
 INSERT INTO geo_island VALUES ('Kefallinia','GR','Ionioi Nisoi');
 INSERT INTO geo_island VALUES ('Zakinthos','GR','Ionioi Nisoi');
 INSERT INTO geo_island VALUES ('Kreta','GR','Kriti');
 INSERT INTO geo_island VALUES ('Chios','GR','Voreion Aiyaion');
 INSERT INTO geo_island VALUES ('Samos','GR','Voreion Aiyaion');
 INSERT INTO geo_island VALUES ('Ikaria','GR','Voreion Aiyaion');
 INSERT INTO geo_island VALUES ('Lesbos','GR','Voreion Aiyaion');
 INSERT INTO geo_island VALUES ('Kos','GR','Notion Aiyaion');
 INSERT INTO geo_island VALUES ('Rhodos','GR','Notion Aiyaion');
 INSERT INTO geo_island VALUES ('Cyprus','CY','Cyprus');
 INSERT INTO geo_island VALUES ('Alicudi','I','Calabria');
 INSERT INTO geo_island VALUES ('Filicudi','I','Calabria');
 INSERT INTO geo_island VALUES ('Salina','I','Calabria');
 INSERT INTO geo_island VALUES ('Lipari','I','Calabria');
 INSERT INTO geo_island VALUES ('Vulcano','I','Calabria');
 INSERT INTO geo_island VALUES ('Panarea','I','Calabria');
 INSERT INTO geo_island VALUES ('Stromboli','I','Calabria');
 INSERT INTO geo_island VALUES ('Lampedusa','I','Sicilia');
 INSERT INTO geo_island VALUES ('Linosa','I','Sicilia');
 INSERT INTO geo_island VALUES ('Sicilia','I','Sicilia');
 INSERT INTO geo_island VALUES ('Malta','M','Malta');
 INSERT INTO geo_island VALUES ('Gozo','M','Malta');
 INSERT INTO geo_island VALUES ('Sardegna','I','Sardegna');
 INSERT INTO geo_island VALUES ('Corse','F','Corse');
 INSERT INTO geo_island VALUES ('Menorca','E','Balearic Islands');
 INSERT INTO geo_island VALUES ('Mallorca','E','Balearic Islands');
 INSERT INTO geo_island VALUES ('Ibiza','E','Balearic Islands');
 INSERT INTO geo_island VALUES ('Formentera','E','Balearic Islands');
 INSERT INTO geo_island VALUES ('Lanzarote','E','Canary Islands');
 INSERT INTO geo_island VALUES ('Fuerteventura','E','Canary Islands');
 INSERT INTO geo_island VALUES ('Gran Canaria','E','Canary Islands');
 INSERT INTO geo_island VALUES ('Teneriffa','E','Canary Islands');
 INSERT INTO geo_island VALUES ('Gomera','E','Canary Islands');
 INSERT INTO geo_island VALUES ('Hierro','E','Canary Islands');
 INSERT INTO geo_island VALUES ('La Palma','E','Canary Islands');
 INSERT INTO geo_island VALUES ('Madeira','P','Madeira');
 INSERT INTO geo_island VALUES ('Porto Santo','P','Madeira');
 INSERT INTO geo_island VALUES ('Sao Miguel','P','Azores');
 INSERT INTO geo_island VALUES ('Santa Maria','P','Azores');
 INSERT INTO geo_island VALUES ('Terceira','P','Azores');
 INSERT INTO geo_island VALUES ('Sao Jorge','P','Azores');
 INSERT INTO geo_island VALUES ('Pico','P','Azores');
 INSERT INTO geo_island VALUES ('Faial','P','Azores');
 INSERT INTO geo_island VALUES ('Graciosa','P','Azores');
 INSERT INTO geo_island VALUES ('Flores','P','Azores');
 INSERT INTO geo_island VALUES ('Corvo','P','Azores');
 INSERT INTO geo_island VALUES ('Santiago','CV','Cape Verde');
 INSERT INTO geo_island VALUES ('Fogo','CV','Cape Verde');
 INSERT INTO geo_island VALUES ('Sao Tome','STP','Sao Tome and Principe');
 INSERT INTO geo_island VALUES ('Principe','STP','Sao Tome and Principe');
 INSERT INTO geo_island VALUES ('Bioko','GQ','Equatorial Guinea');
 INSERT INTO geo_island VALUES ('Saint Helena','HELX','Saint Helena');
 INSERT INTO geo_island VALUES ('Ascension','HELX','Saint Helena');
 INSERT INTO geo_island VALUES ('Tristan Da Cunha','HELX','Saint Helena');
 INSERT INTO geo_island VALUES ('West Falkland','FALK','Falkland Islands');
 INSERT INTO geo_island VALUES ('East Falkland','FALK','Falkland Islands');
 INSERT INTO geo_island VALUES ('Bahrain','BRN','Bahrain');
 INSERT INTO geo_island VALUES ('Khark','IR','Fars');
 INSERT INTO geo_island VALUES ('Gheschm','IR','Hormozgan');
 INSERT INTO geo_island VALUES ('Lavan','IR','Fars');
 INSERT INTO geo_island VALUES ('Christmas Island','XMAS','Christmas Island');
 INSERT INTO geo_island VALUES ('Pulau Panjang','COCO','Cocos Islands');
 INSERT INTO geo_island VALUES ('Male','MV','Maldives');
 INSERT INTO geo_island VALUES ('Kavaratti','IND','Lakshadweep Is.');
 INSERT INTO geo_island VALUES ('Sri Lanka','CL','Sri Lanka');
 INSERT INTO geo_island VALUES ('South Andaman Island','IND','Andaman and Nicobar Is.');
 INSERT INTO geo_island VALUES ('Sokotra','YE','Yemen');
 INSERT INTO geo_island VALUES ('Sansibar','EAT','Mjini Magharibi');
 INSERT INTO geo_island VALUES ('Pemba','EAT','Mjini Magharibi');
 INSERT INTO geo_island VALUES ('Mahe','SY','Seychelles');
 INSERT INTO geo_island VALUES ('Grand Comoro','COM','Comoros');
 INSERT INTO geo_island VALUES ('Anjouan','COM','Comoros');
 INSERT INTO geo_island VALUES ('Mohilla','COM','Comoros');
 INSERT INTO geo_island VALUES ('Mayotte','MAYO','Mayotte');
 INSERT INTO geo_island VALUES ('Reunion','REUN','Reunion');
 INSERT INTO geo_island VALUES ('Mauritius','MS','Mauritius');
 INSERT INTO geo_island VALUES ('Madagaskar','RM','Antsiranana');
 INSERT INTO geo_island VALUES ('Madagaskar','RM','Antananarivo');
 INSERT INTO geo_island VALUES ('Madagaskar','RM','Fianarantsoa');
 INSERT INTO geo_island VALUES ('Madagaskar','RM','Mahajanga');
 INSERT INTO geo_island VALUES ('Madagaskar','RM','Toamasina');
 INSERT INTO geo_island VALUES ('Madagaskar','RM','Toliara');
 INSERT INTO geo_island VALUES ('Kotelny Island','R','Rep. of Sakha');
 INSERT INTO geo_island VALUES ('Paramuschir','R','Kamchatskaya oblast');
 INSERT INTO geo_island VALUES ('Olkhon','R','Rep. of Buryatiya');
 INSERT INTO geo_island VALUES ('Sachalin','R','Sakhalinskaya oblast');
 INSERT INTO geo_island VALUES ('Hokkaido','J','Hokkaido');
 INSERT INTO geo_island VALUES ('Kyushu','J','Fukuoka');
 INSERT INTO geo_island VALUES ('Kyushu','J','Saga');
 INSERT INTO geo_island VALUES ('Kyushu','J','Nagasaki');
 INSERT INTO geo_island VALUES ('Kyushu','J','Kumamoto');
 INSERT INTO geo_island VALUES ('Kyushu','J','Oita');
 INSERT INTO geo_island VALUES ('Kyushu','J','Miyazaki');
 INSERT INTO geo_island VALUES ('Kyushu','J','Kagoshima');
 INSERT INTO geo_island VALUES ('Shikoku','J','Tokushima');
 INSERT INTO geo_island VALUES ('Shikoku','J','Kagawa');
 INSERT INTO geo_island VALUES ('Shikoku','J','Ehime');
 INSERT INTO geo_island VALUES ('Shikoku','J','Kochi');
 INSERT INTO geo_island VALUES ('Honshu','J','Aomori');
 INSERT INTO geo_island VALUES ('Honshu','J','Iwate');
 INSERT INTO geo_island VALUES ('Honshu','J','Miyagi');
 INSERT INTO geo_island VALUES ('Honshu','J','Akita');
 INSERT INTO geo_island VALUES ('Honshu','J','Yamagata');
 INSERT INTO geo_island VALUES ('Honshu','J','Fukushima');
 INSERT INTO geo_island VALUES ('Honshu','J','Ibaraki');
 INSERT INTO geo_island VALUES ('Honshu','J','Tochigi');
 INSERT INTO geo_island VALUES ('Honshu','J','Gumma');
 INSERT INTO geo_island VALUES ('Honshu','J','Saitama');
 INSERT INTO geo_island VALUES ('Honshu','J','Chiba');
 INSERT INTO geo_island VALUES ('Honshu','J','Tokyo');
 INSERT INTO geo_island VALUES ('Honshu','J','Kanagawa');
 INSERT INTO geo_island VALUES ('Honshu','J','Niigata');
 INSERT INTO geo_island VALUES ('Honshu','J','Toyama');
 INSERT INTO geo_island VALUES ('Honshu','J','Ishikawa');
 INSERT INTO geo_island VALUES ('Honshu','J','Fukui');
 INSERT INTO geo_island VALUES ('Honshu','J','Yamanashi');
 INSERT INTO geo_island VALUES ('Honshu','J','Nagano');
 INSERT INTO geo_island VALUES ('Honshu','J','Gifu');
 INSERT INTO geo_island VALUES ('Honshu','J','Shizuoka');
 INSERT INTO geo_island VALUES ('Honshu','J','Aichi');
 INSERT INTO geo_island VALUES ('Honshu','J','Mie');
 INSERT INTO geo_island VALUES ('Honshu','J','Shiga');
 INSERT INTO geo_island VALUES ('Honshu','J','Kyoto');
 INSERT INTO geo_island VALUES ('Honshu','J','Osaka');
 INSERT INTO geo_island VALUES ('Honshu','J','Hyogo');
 INSERT INTO geo_island VALUES ('Honshu','J','Nara');
 INSERT INTO geo_island VALUES ('Honshu','J','Wakayama');
 INSERT INTO geo_island VALUES ('Honshu','J','Tottori');
 INSERT INTO geo_island VALUES ('Honshu','J','Shimane');
 INSERT INTO geo_island VALUES ('Honshu','J','Okayama');
 INSERT INTO geo_island VALUES ('Honshu','J','Hiroshima');
 INSERT INTO geo_island VALUES ('Honshu','J','Yamaguchi');
 INSERT INTO geo_island VALUES ('Okinawa','J','Okinawa');
 INSERT INTO geo_island VALUES ('Jeju','ROK','South Korea');
 INSERT INTO geo_island VALUES ('Taiwan','RC','Taiwan');
 INSERT INTO geo_island VALUES ('Hainan','TJ','Hainan');
 INSERT INTO geo_island VALUES ('Luzon','RP','Philippines');
 INSERT INTO geo_island VALUES ('Mindoro','RP','Philippines');
 INSERT INTO geo_island VALUES ('Negros','RP','Philippines');
 INSERT INTO geo_island VALUES ('Panay','RP','Philippines');
 INSERT INTO geo_island VALUES ('Bohol','RP','Philippines');
 INSERT INTO geo_island VALUES ('Leyte','RP','Philippines');
 INSERT INTO geo_island VALUES ('Samar','RP','Philippines');
 INSERT INTO geo_island VALUES ('Cebu','RP','Philippines');
 INSERT INTO geo_island VALUES ('Mindanao','RP','Philippines');
 INSERT INTO geo_island VALUES ('Palawan','RP','Philippines');
 INSERT INTO geo_island VALUES ('Singapore','SGP','Singapore');
 INSERT INTO geo_island VALUES ('Sumatra','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Samosir','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Batam','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Bangka','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Krakatau','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Java','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Borneo','BRU','Brunei');
 INSERT INTO geo_island VALUES ('Borneo','MAL','Sabah');
 INSERT INTO geo_island VALUES ('Borneo','MAL','Sarawak');
 INSERT INTO geo_island VALUES ('Borneo','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Bali','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Lombok','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Sumbawa','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Sulawesi','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Timor','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Timor','TL','Timor-Leste');
 INSERT INTO geo_island VALUES ('Ambon','RI','Indonesia');
 INSERT INTO geo_island VALUES ('Ceram','RI','Indonesia');
 INSERT INTO geo_island VALUES ('New Guinea','RI','Indonesia');
 INSERT INTO geo_island VALUES ('New Guinea','PNG','Papua New Guinea');
 INSERT INTO geo_island VALUES ('Bougainville','PNG','Papua New Guinea');
 INSERT INTO geo_island VALUES ('Guadalcanal','SLB','Solomon Islands');
 INSERT INTO geo_island VALUES ('Grande Terre','NCA','New Caledonia');
 INSERT INTO geo_island VALUES ('Cangaroo Island','AUS','South Australia');
 INSERT INTO geo_island VALUES ('Melville Island','AUS','Northern Territory');
 INSERT INTO geo_island VALUES ('Tasmania','AUS','Tasmania');
 INSERT INTO geo_island VALUES ('Victoria Island','CDN','Northwest Territories');
 INSERT INTO geo_island VALUES ('Banks Island','CDN','Northwest Territories');
 INSERT INTO geo_island VALUES ('Prince of Wales Island','CDN','Northwest Territories');
 INSERT INTO geo_island VALUES ('Baffin Island','CDN','Northwest Territories');
 INSERT INTO geo_island VALUES ('Southampton Island','CDN','Northwest Territories');
 INSERT INTO geo_island VALUES ('Ellesmere Island','CDN','Northwest Territories');
 INSERT INTO geo_island VALUES ('Saint Pierre','SPMI','Saint Pierre and Miquelon');
 INSERT INTO geo_island VALUES ('Miquelon-Langlade','SPMI','Saint Pierre and Miquelon');
 INSERT INTO geo_island VALUES ('Newfoundland','CDN','Newfoundland');
 INSERT INTO geo_island VALUES ('Prince Edward Island','CDN','Prince Edward Island');
 INSERT INTO geo_island VALUES ('Rene Levasseur Island','CDN','Ontario');
 INSERT INTO geo_island VALUES ('Manitoulin','CDN','Ontario');
 INSERT INTO geo_island VALUES ('Martha s Vineyard','USA','Massachusetts');
 INSERT INTO geo_island VALUES ('Nantucket','USA','Massachusetts');
 INSERT INTO geo_island VALUES ('Long Island','USA','New York');
 INSERT INTO geo_island VALUES ('Grand Bermuda','BERM','Bermuda');
 INSERT INTO geo_island VALUES ('New Providence','BS','Bahamas');
 INSERT INTO geo_island VALUES ('Grand Turk','TUCA','Turks and Caicos Islands');
 INSERT INTO geo_island VALUES ('Providenciales','TUCA','Turks and Caicos Islands');
 INSERT INTO geo_island VALUES ('North Caicos','TUCA','Turks and Caicos Islands');
 INSERT INTO geo_island VALUES ('Cuba','C','Ciego de Avila');
 INSERT INTO geo_island VALUES ('Cuba','C','Cienfuegos');
 INSERT INTO geo_island VALUES ('Cuba','C','Ciudad de la Habana');
 INSERT INTO geo_island VALUES ('Cuba','C','Granma');
 INSERT INTO geo_island VALUES ('Cuba','C','Guantanamo');
 INSERT INTO geo_island VALUES ('Cuba','C','Holguin');
 INSERT INTO geo_island VALUES ('Cuba','C','La Habana');
 INSERT INTO geo_island VALUES ('Cuba','C','Las Tunas');
 INSERT INTO geo_island VALUES ('Cuba','C','Matanzas');
 INSERT INTO geo_island VALUES ('Cuba','C','Pinar del Rio');
 INSERT INTO geo_island VALUES ('Cuba','C','Sancti Spiritus');
 INSERT INTO geo_island VALUES ('Cuba','C','Santiago de Cuba');
 INSERT INTO geo_island VALUES ('Cuba','C','Villa Clara');
 INSERT INTO geo_island VALUES ('Jamaica','JA','Jamaica');
 INSERT INTO geo_island VALUES ('Hispaniola','DOM','Dominican Republic');
 INSERT INTO geo_island VALUES ('Hispaniola','RH','Haiti');
 INSERT INTO geo_island VALUES ('Puerto Rico','PR','Puerto Rico');
 INSERT INTO geo_island VALUES ('Tortola','BVIR','British Virgin Islands');
 INSERT INTO geo_island VALUES ('Saint Thomas','VIRG','Virgin Islands');
 INSERT INTO geo_island VALUES ('Anguilla','AXA','Anguilla');
 INSERT INTO geo_island VALUES ('St. Martin','NA','Netherlands Antilles');
 INSERT INTO geo_island VALUES ('St. Martin','SMAR','Saint Martin');
 INSERT INTO geo_island VALUES ('Saint Kitts','KN','Saint Kitts and Nevis');
 INSERT INTO geo_island VALUES ('Nevis','KN','Saint Kitts and Nevis');
 INSERT INTO geo_island VALUES ('Barbuda','AG','Antigua and Barbuda');
 INSERT INTO geo_island VALUES ('Antigua','AG','Antigua and Barbuda');
 INSERT INTO geo_island VALUES ('Montserrat','MNTS','Montserrat');
 INSERT INTO geo_island VALUES ('Basse-Terre','GUAD','Guadeloupe');
 INSERT INTO geo_island VALUES ('Grande-Terre','GUAD','Guadeloupe');
 INSERT INTO geo_island VALUES ('Dominica','WD','Dominica');
 INSERT INTO geo_island VALUES ('Martinique','MART','Martinique');
 INSERT INTO geo_island VALUES ('Saint Lucia','WL','Saint Lucia');
 INSERT INTO geo_island VALUES ('Saint Vincent','WV','Saint Vincent and the Grenadines');
 INSERT INTO geo_island VALUES ('Barbados','BDS','Barbados');
 INSERT INTO geo_island VALUES ('Grenada','WG','Grenada');
 INSERT INTO geo_island VALUES ('Trinidad','TT','Trinidad and Tobago');
 INSERT INTO geo_island VALUES ('Tobago','TT','Trinidad and Tobago');
 INSERT INTO geo_island VALUES ('Curacao','NA','Netherlands Antilles');
 INSERT INTO geo_island VALUES ('Bonaire','NA','Netherlands Antilles');
 INSERT INTO geo_island VALUES ('Aruba','ARU','Aruba');
 INSERT INTO geo_island VALUES ('Grand Cayman','CAYM','Cayman Islands');
 INSERT INTO geo_island VALUES ('Little Cayman','CAYM','Cayman Islands');
 INSERT INTO geo_island VALUES ('Cayman Brac','CAYM','Cayman Islands');
 INSERT INTO geo_island VALUES ('Isla da Ometepe','NIC','Nicaragua');
 INSERT INTO geo_island VALUES ('Vancouver Island','CDN','British Columbia');
 INSERT INTO geo_island VALUES ('Santa Cruz Island','USA','California');
 INSERT INTO geo_island VALUES ('Santa Catalina Island','USA','California');
 INSERT INTO geo_island VALUES ('Santa Rosa Island','USA','California');
 INSERT INTO geo_island VALUES ('San Clemente Island','USA','California');
 INSERT INTO geo_island VALUES ('San Miguel Island','USA','California');
 INSERT INTO geo_island VALUES ('Isabela','EC','Ecuador');
 INSERT INTO geo_island VALUES ('Niihau','USA','Hawaii');
 INSERT INTO geo_island VALUES ('Kauai','USA','Hawaii');
 INSERT INTO geo_island VALUES ('Oahu','USA','Hawaii');
 INSERT INTO geo_island VALUES ('Molokai','USA','Hawaii');
 INSERT INTO geo_island VALUES ('Lanai','USA','Hawaii');
 INSERT INTO geo_island VALUES ('Maui','USA','Hawaii');
 INSERT INTO geo_island VALUES ('Hawaii','USA','Hawaii');
 INSERT INTO geo_island VALUES ('Niue','NIUE','Niue');
 INSERT INTO geo_island VALUES ('Saipan','NMIS','Northern Mariana Islands');
 INSERT INTO geo_island VALUES ('Tinian','NMIS','Northern Mariana Islands');
 INSERT INTO geo_island VALUES ('Rota','NMIS','Northern Mariana Islands');
 INSERT INTO geo_island VALUES ('Pitcairn','PITC','Pitcairn Islands');
 INSERT INTO geo_island VALUES ('Uvea','WAFU','Wallis and Futuna');
 INSERT INTO geo_island VALUES ('Futuna','WAFU','Wallis and Futuna');
 INSERT INTO geo_island VALUES ('Tarawa','KIR','Kiribati');
 INSERT INTO geo_island VALUES ('Tongatapu','TO','Tonga');
 INSERT INTO geo_island VALUES ('Viti Levu','FJI','Fiji');
 INSERT INTO geo_island VALUES ('Vanua Levu','FJI','Fiji');
 INSERT INTO geo_island VALUES ('Norfolk Island','NORF','Norfolk Island');
 INSERT INTO geo_island VALUES ('Nauru','NAU','Nauru');
 INSERT INTO geo_island VALUES ('Koror','PAL','Palau');
 INSERT INTO geo_island VALUES ('Babelthuap','PAL','Palau');
 INSERT INTO geo_island VALUES ('Fongafale','TUV','Tuvalu');
 INSERT INTO geo_island VALUES ('Efate','VU','Vanuatu');
 INSERT INTO geo_island VALUES ('Upolu','WS','Samoa');
 INSERT INTO geo_island VALUES ('Savaii','WS','Samoa');
 INSERT INTO geo_island VALUES ('Tutuila','AMSA','American Samoa');
 INSERT INTO geo_island VALUES ('Rarotonga','COOK','Cook Islands');
 INSERT INTO geo_island VALUES ('Tahiti','FPOL','French Polynesia');
 INSERT INTO geo_island VALUES ('Guam','GUAM','Guam');
 INSERT INTO geo_island VALUES ('Majuro','MH','Marshall Islands');
 INSERT INTO geo_island VALUES ('Ponape','FSM','Micronesia');
 INSERT INTO geo_island VALUES ('Osterinsel','RCH','Chile');
 INSERT INTO geo_island VALUES ('Te Ika-a-Maui (North Island)','NZ','New Zealand');
 INSERT INTO geo_island VALUES ('Te Waka-a-Maui (South Island)','NZ','New Zealand');
 INSERT INTO geo_mountain VALUES ('Oeraefajoekull','IS','Iceland');
 INSERT INTO geo_mountain VALUES ('Snoefell','IS','Iceland');
 INSERT INTO geo_mountain VALUES ('Haltiatunturi','SF','Lappia');
 INSERT INTO geo_mountain VALUES ('Kebnekaise','S','Norrbotten');
 INSERT INTO geo_mountain VALUES ('Sarektjokko','S','Norrbotten');
 INSERT INTO geo_mountain VALUES ('Portefjaellen','S','Norrbotten');
 INSERT INTO geo_mountain VALUES ('Tarrekaise','S','Norrbotten');
 INSERT INTO geo_mountain VALUES ('Sulitjelma','N','Nordland');
 INSERT INTO geo_mountain VALUES ('Sulitjelma','S','Norrbotten');
 INSERT INTO geo_mountain VALUES ('Galdhoeppig','N','Oppland');
 INSERT INTO geo_mountain VALUES ('Jostedalsbre','N','Sogn og Fjordane');
 INSERT INTO geo_mountain VALUES ('Glittertind','N','Oppland');
 INSERT INTO geo_mountain VALUES ('Joekul','N','Hordaland');
 INSERT INTO geo_mountain VALUES ('Snoehetta','N','Oppland');
 INSERT INTO geo_mountain VALUES ('Ben Nevis','GB','Highland');
 INSERT INTO geo_mountain VALUES ('Feldberg','D','Baden Wurttemberg');
 INSERT INTO geo_mountain VALUES ('Brocken','D','Sachsen Anhalt');
 INSERT INTO geo_mountain VALUES ('Grosser Arber','D','Bayern');
 INSERT INTO geo_mountain VALUES ('Zugspitze','D','Bayern');
 INSERT INTO geo_mountain VALUES ('Zugspitze','A','Tyrol');
 INSERT INTO geo_mountain VALUES ('Mont Blanc','F','Rhone Alpes');
 INSERT INTO geo_mountain VALUES ('Mont Blanc','I','Valle dAosta');
 INSERT INTO geo_mountain VALUES ('Barre des Ecrins','F','Rhone Alpes');
 INSERT INTO geo_mountain VALUES ('GrandCombin','CH','VS');
 INSERT INTO geo_mountain VALUES ('Matterhorn','I','Valle dAosta');
 INSERT INTO geo_mountain VALUES ('Matterhorn','CH','VS');
 INSERT INTO geo_mountain VALUES ('Monte Rosa','I','Valle dAosta');
 INSERT INTO geo_mountain VALUES ('Monte Rosa','I','Lombardia');
 INSERT INTO geo_mountain VALUES ('Monte Rosa','CH','VS');
 INSERT INTO geo_mountain VALUES ('Finsteraarhorn','CH','BE');
 INSERT INTO geo_mountain VALUES ('Finsteraarhorn','CH','VS');
 INSERT INTO geo_mountain VALUES ('GranParadiso','I','Piemonte');
 INSERT INTO geo_mountain VALUES ('GranParadiso','I','Valle dAosta');
 INSERT INTO geo_mountain VALUES ('Piz Bernina','I','Lombardia');
 INSERT INTO geo_mountain VALUES ('Piz Bernina','CH','GR');
 INSERT INTO geo_mountain VALUES ('Crap_Sogn_Gion','CH','GR');
 INSERT INTO geo_mountain VALUES ('Marmolata','I','Trentino Alto Adige');
 INSERT INTO geo_mountain VALUES ('Marmolata','I','Veneto');
 INSERT INTO geo_mountain VALUES ('Grossglockner','A','Carinthia');
 INSERT INTO geo_mountain VALUES ('Hochgolling','A','Styria');
 INSERT INTO geo_mountain VALUES ('Hochgolling','A','Salzburg');
 INSERT INTO geo_mountain VALUES ('Grand Ballon','F','Alsace');
 INSERT INTO geo_mountain VALUES ('Grand Ballon','F','Lorraine');
 INSERT INTO geo_mountain VALUES ('Puy De Dome','F','Auvergne');
 INSERT INTO geo_mountain VALUES ('Puy de Sancy','F','Auvergne');
 INSERT INTO geo_mountain VALUES ('Vignemale','F','Midi Pyrenees');
 INSERT INTO geo_mountain VALUES ('Vignemale','E','Aragon');
 INSERT INTO geo_mountain VALUES ('Pico de Aneto','E','Aragon');
 INSERT INTO geo_mountain VALUES ('Torre de Cerredo','E','Asturias');
 INSERT INTO geo_mountain VALUES ('Torre de Cerredo','E','Castile and Leon');
 INSERT INTO geo_mountain VALUES ('Pico de Almanzor','E','Castile and Leon');
 INSERT INTO geo_mountain VALUES ('Moncayo','E','Aragon');
 INSERT INTO geo_mountain VALUES ('Moncayo','E','Castile and Leon');
 INSERT INTO geo_mountain VALUES ('Mulhacen','E','Andalusia');
 INSERT INTO geo_mountain VALUES ('Torre de Estrela','P','Guarda');
 INSERT INTO geo_mountain VALUES ('Monte Cinto','F','Corse');
 INSERT INTO geo_mountain VALUES ('Gran Sasso','I','Abruzzo');
 INSERT INTO geo_mountain VALUES ('Monte Falterona','I','Emilia Romagna');
 INSERT INTO geo_mountain VALUES ('Monte Falterona','I','Toscana');
 INSERT INTO geo_mountain VALUES ('Vesuv','I','Campania');
 INSERT INTO geo_mountain VALUES ('Etna','I','Sicilia');
 INSERT INTO geo_mountain VALUES ('Schneekoppe','CZ','Vychodocesky');
 INSERT INTO geo_mountain VALUES ('Schneekoppe','PL','Walbrzyskie');
 INSERT INTO geo_mountain VALUES ('GerlachovskyStit','SK','Slovakia');
 INSERT INTO geo_mountain VALUES ('Moldoveanu','RO','Arges');
 INSERT INTO geo_mountain VALUES ('Moldoveanu','RO','Brasov');
 INSERT INTO geo_mountain VALUES ('Moldoveanu','RO','Sibiu');
 INSERT INTO geo_mountain VALUES ('Musala','BG','Bulgaria');
 INSERT INTO geo_mountain VALUES ('Jezerce','AL','Albania');
 INSERT INTO geo_mountain VALUES ('Korab','AL','Albania');
 INSERT INTO geo_mountain VALUES ('Korab','MK','Macedonia');
 INSERT INTO geo_mountain VALUES ('Olymp','GR','Kedriki Makedhonia');
 INSERT INTO geo_mountain VALUES ('Olymp','GR','Thessalia');
 INSERT INTO geo_mountain VALUES ('Psiloritis','GR','Kriti');
 INSERT INTO geo_mountain VALUES ('Olympos','CY','Cyprus');
 INSERT INTO geo_mountain VALUES ('Pico de Teide','E','Canary Islands');
 INSERT INTO geo_mountain VALUES ('Pico de los Nieves','E','Canary Islands');
 INSERT INTO geo_mountain VALUES ('Roque de los Muchachos','E','Canary Islands');
 INSERT INTO geo_mountain VALUES ('Pico Ruivo','P','Madeira');
 INSERT INTO geo_mountain VALUES ('Pico','P','Azores');
 INSERT INTO geo_mountain VALUES ('Fogo','CV','Cape Verde');
 INSERT INTO geo_mountain VALUES ('Tubkhal','MA','Morocco');
 INSERT INTO geo_mountain VALUES ('Djebel Aures','MA','Morocco');
 INSERT INTO geo_mountain VALUES ('Tahat','DZ','Algeria');
 INSERT INTO geo_mountain VALUES ('Tamgak','RN','Niger');
 INSERT INTO geo_mountain VALUES ('Mont Greboun','RN','Niger');
 INSERT INTO geo_mountain VALUES ('Emi Kussi','TCH','Chad');
 INSERT INTO geo_mountain VALUES ('Jabal Marra','SUD','Darfur');
 INSERT INTO geo_mountain VALUES ('Jabal Katrina','ET','Sina al Janubiyah');
 INSERT INTO geo_mountain VALUES ('Fako','CAM','Sudoueste');
 INSERT INTO geo_mountain VALUES ('Pico Basile','GQ','Equatorial Guinea');
 INSERT INTO geo_mountain VALUES ('Pico de Sao Tome','STP','Sao Tome and Principe');
 INSERT INTO geo_mountain VALUES ('Queen Marys Peak','HELX','Saint Helena');
 INSERT INTO geo_mountain VALUES ('Ras Daschan Terara','ETH','Ethiopia');
 INSERT INTO geo_mountain VALUES ('Ruwenzori','ZRE','Kivu');
 INSERT INTO geo_mountain VALUES ('Ruwenzori','EAU','Uganda');
 INSERT INTO geo_mountain VALUES ('Elgon','EAK','Western');
 INSERT INTO geo_mountain VALUES ('Elgon','EAU','Uganda');
 INSERT INTO geo_mountain VALUES ('Kenia','EAK','Eastern');
 INSERT INTO geo_mountain VALUES ('Kilimanjaro','EAT','Kilimanjaro');
 INSERT INTO geo_mountain VALUES ('Mawenzi','EAT','Kilimanjaro');
 INSERT INTO geo_mountain VALUES ('Meru','EAT','Arusha');
 INSERT INTO geo_mountain VALUES ('Karisimbi','ZRE','Kivu');
 INSERT INTO geo_mountain VALUES ('Karisimbi','RWA','Rwanda');
 INSERT INTO geo_mountain VALUES ('Thabana Ntlenyana','LS','Lesotho');
 INSERT INTO geo_mountain VALUES ('Cathkin Peak','RSA','Kwazulu Natal');
 INSERT INTO geo_mountain VALUES ('Tsaratanana','RM','Antsiranana');
 INSERT INTO geo_mountain VALUES ('Tsiafajavona','RM','Antananarivo');
 INSERT INTO geo_mountain VALUES ('Andringitra','RM','Fianarantsoa');
 INSERT INTO geo_mountain VALUES ('Piton des Neiges','REUN','Reunion');
 INSERT INTO geo_mountain VALUES ('Piton de la Fournaise','REUN','Reunion');
 INSERT INTO geo_mountain VALUES ('Narodnaja','R','Rep. of Komi');
 INSERT INTO geo_mountain VALUES ('Demirkazik','TR','Nigde');
 INSERT INTO geo_mountain VALUES ('Ararat','TR','Agri');
 INSERT INTO geo_mountain VALUES ('Jabal Lubnan','RL','Lebanon');
 INSERT INTO geo_mountain VALUES ('Elbrus','R','Kabardino Balkar Rep.');
 INSERT INTO geo_mountain VALUES ('Kasbek','R','Rep. of North Ossetiya');
 INSERT INTO geo_mountain VALUES ('Kasbek','GE','Georgia');
 INSERT INTO geo_mountain VALUES ('Damavand','IR','Mazandaran');
 INSERT INTO geo_mountain VALUES ('Sabalan','IR','Azarbayian e Sharqi');
 INSERT INTO geo_mountain VALUES ('Zard Kuh','IR','Chahar Mahal e Bakhtiari');
 INSERT INTO geo_mountain VALUES ('Jabal Shuayb','YE','Yemen');
 INSERT INTO geo_mountain VALUES ('Dodabetta','IND','Tamil Nadu');
 INSERT INTO geo_mountain VALUES ('Pidurutalagala','CL','Sri Lanka');
 INSERT INTO geo_mountain VALUES ('Zhima','R','Rep. of Buryatiya');
 INSERT INTO geo_mountain VALUES ('Bjelucha','R','Rep. of Altay');
 INSERT INTO geo_mountain VALUES ('Bjelucha','KAZ','Shyghys Qazaqstan');
 INSERT INTO geo_mountain VALUES ('Pik Chan-Tengri','KGZ','Kyrgyzstan');
 INSERT INTO geo_mountain VALUES ('Pik Pobeda','TJ','Xinjiang Uygur');
 INSERT INTO geo_mountain VALUES ('Pik Pobeda','KGZ','Kyrgyzstan');
 INSERT INTO geo_mountain VALUES ('Pik Kommunizma','TAD','Badakhshoni Kuni');
 INSERT INTO geo_mountain VALUES ('Pik Lenina','TAD','Badakhshoni Kuni');
 INSERT INTO geo_mountain VALUES ('Pik Lenina','KGZ','Kyrgyzstan');
 INSERT INTO geo_mountain VALUES ('Pik Revoluzija','TAD','Badakhshoni Kuni');
 INSERT INTO geo_mountain VALUES ('Pik Moskva','TAD','Badakhshoni Kuni');
 INSERT INTO geo_mountain VALUES ('Pik Karl-Marx','TAD','Badakhshoni Kuni');
 INSERT INTO geo_mountain VALUES ('Tirich Mir','AFG','Afghanistan');
 INSERT INTO geo_mountain VALUES ('K2','TJ','Xinjiang Uygur');
 INSERT INTO geo_mountain VALUES ('K2','PK','Pakistan');
 INSERT INTO geo_mountain VALUES ('Gasherbrum II','TJ','Xinjiang Uygur');
 INSERT INTO geo_mountain VALUES ('Gasherbrum II','PK','Pakistan');
 INSERT INTO geo_mountain VALUES ('Gasherbrum I','TJ','Xinjiang Uygur');
 INSERT INTO geo_mountain VALUES ('Gasherbrum I','PK','Pakistan');
 INSERT INTO geo_mountain VALUES ('Broad Peak','TJ','Xinjiang Uygur');
 INSERT INTO geo_mountain VALUES ('Broad Peak','PK','Pakistan');
 INSERT INTO geo_mountain VALUES ('Nanga Parbat','PK','Pakistan');
 INSERT INTO geo_mountain VALUES ('Nanda Devi','IND','Uttar Pradesh');
 INSERT INTO geo_mountain VALUES ('Dhaulagiri','NEP','Nepal');
 INSERT INTO geo_mountain VALUES ('Annapurna','NEP','Nepal');
 INSERT INTO geo_mountain VALUES ('Manaslu','NEP','Nepal');
 INSERT INTO geo_mountain VALUES ('Shishapangma','TJ','Tibet');
 INSERT INTO geo_mountain VALUES ('Kailash','TJ','Tibet');
 INSERT INTO geo_mountain VALUES ('Cho Oyu','TJ','Tibet');
 INSERT INTO geo_mountain VALUES ('Cho Oyu','NEP','Nepal');
 INSERT INTO geo_mountain VALUES ('Mount Everest','TJ','Tibet');
 INSERT INTO geo_mountain VALUES ('Mount Everest','NEP','Nepal');
 INSERT INTO geo_mountain VALUES ('Lhotse','TJ','Tibet');
 INSERT INTO geo_mountain VALUES ('Lhotse','NEP','Nepal');
 INSERT INTO geo_mountain VALUES ('Makalu','TJ','Tibet');
 INSERT INTO geo_mountain VALUES ('Makalu','NEP','Nepal');
 INSERT INTO geo_mountain VALUES ('Kangchendzonga','IND','Sikkim');
 INSERT INTO geo_mountain VALUES ('Kangchendzonga','NEP','Nepal');
 INSERT INTO geo_mountain VALUES ('Kljutschewskaja Sopka','R','Kamchatskaya oblast');
 INSERT INTO geo_mountain VALUES ('Changbai Shan','TJ','Jilin');
 INSERT INTO geo_mountain VALUES ('Changbai Shan','NOK','North Korea');
 INSERT INTO geo_mountain VALUES ('Asahi-Dake','J','Hokkaido');
 INSERT INTO geo_mountain VALUES ('Fujisan','J','Yamanashi');
 INSERT INTO geo_mountain VALUES ('Fujisan','J','Shizuoka');
 INSERT INTO geo_mountain VALUES ('Hotaka-Dake','J','Nagano');
 INSERT INTO geo_mountain VALUES ('Hotaka-Dake','J','Gifu');
 INSERT INTO geo_mountain VALUES ('Yu Shan','RC','Taiwan');
 INSERT INTO geo_mountain VALUES ('Pulog','RP','Philippines');
 INSERT INTO geo_mountain VALUES ('Pinatubo','RP','Philippines');
 INSERT INTO geo_mountain VALUES ('Mount Apo','RP','Philippines');
 INSERT INTO geo_mountain VALUES ('Kanlaon','RP','Philippines');
 INSERT INTO geo_mountain VALUES ('Mantalingajan','RP','Philippines');
 INSERT INTO geo_mountain VALUES ('Kinabalu','MAL','Sabah');
 INSERT INTO geo_mountain VALUES ('Tahan','MAL','Kelantan');
 INSERT INTO geo_mountain VALUES ('Tahan','MAL','Pahang');
 INSERT INTO geo_mountain VALUES ('Leuser','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Kerinci','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Krakatau','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Merapi','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Semeru','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Gunung Agung','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Rinjani','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Tambora','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Rantekombola','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Tatamailau','TL','Timor-Leste');
 INSERT INTO geo_mountain VALUES ('Gunung Binaiya','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Puncak Jaya','RI','Indonesia');
 INSERT INTO geo_mountain VALUES ('Mt. Wilhelm','PNG','Papua New Guinea');
 INSERT INTO geo_mountain VALUES ('Mt. Giluwe','PNG','Papua New Guinea');
 INSERT INTO geo_mountain VALUES ('Mt. Balbi','PNG','Papua New Guinea');
 INSERT INTO geo_mountain VALUES ('Mt.Victoria','FJI','Fiji');
 INSERT INTO geo_mountain VALUES ('Silisili','WS','Samoa');
 INSERT INTO geo_mountain VALUES ('Mont Orohena','FPOL','French Polynesia');
 INSERT INTO geo_mountain VALUES ('Popomanaseu','SLB','Solomon Islands');
 INSERT INTO geo_mountain VALUES ('Mauna Kea','USA','Hawaii');
 INSERT INTO geo_mountain VALUES ('Mauna Loa','USA','Hawaii');
 INSERT INTO geo_mountain VALUES ('Haleakala','USA','Hawaii');
 INSERT INTO geo_mountain VALUES ('Mt. Kosciuszko','AUS','New South Wales');
 INSERT INTO geo_mountain VALUES ('Mt. Bogong','AUS','Victoria');
 INSERT INTO geo_mountain VALUES ('Uluru','AUS','Northern Territory');
 INSERT INTO geo_mountain VALUES ('Mt. Cook','NZ','New Zealand');
 INSERT INTO geo_mountain VALUES ('Ruapehu','NZ','New Zealand');
 INSERT INTO geo_mountain VALUES ('Mt Redoubt','USA','Alaska');
 INSERT INTO geo_mountain VALUES ('Mt McKinley','USA','Alaska');
 INSERT INTO geo_mountain VALUES ('Mt Blackburn','USA','Alaska');
 INSERT INTO geo_mountain VALUES ('Mt Bona','CDN','Saskatchewan');
 INSERT INTO geo_mountain VALUES ('Mt Bona','USA','Alaska');
 INSERT INTO geo_mountain VALUES ('Mt St.Elias','CDN','Yukon Territory');
 INSERT INTO geo_mountain VALUES ('Mt St.Elias','USA','Alaska');
 INSERT INTO geo_mountain VALUES ('Mt Logan','CDN','Yukon Territory');
 INSERT INTO geo_mountain VALUES ('Mt Fairweather','CDN','British Columbia');
 INSERT INTO geo_mountain VALUES ('Mt Fairweather','USA','Alaska');
 INSERT INTO geo_mountain VALUES ('Mt Waddington','CDN','British Columbia');
 INSERT INTO geo_mountain VALUES ('Mt Robson','CDN','British Columbia');
 INSERT INTO geo_mountain VALUES ('Mt Columbia','CDN','Alberta');
 INSERT INTO geo_mountain VALUES ('Mt Columbia','CDN','British Columbia');
 INSERT INTO geo_mountain VALUES ('Barbeau Peak','CDN','Northwest Territories');
 INSERT INTO geo_mountain VALUES ('Mt. Odin','CDN','Northwest Territories');
 INSERT INTO geo_mountain VALUES ('Mt. Babel','CDN','Quebec');
 INSERT INTO geo_mountain VALUES ('Granite Peak','USA','Montana');
 INSERT INTO geo_mountain VALUES ('Borah Peak','USA','Idaho');
 INSERT INTO geo_mountain VALUES ('Harney Peak','USA','South Dakota');
 INSERT INTO geo_mountain VALUES ('Gannett Peak','USA','Wyoming');
 INSERT INTO geo_mountain VALUES ('Kings Peak','USA','Utah');
 INSERT INTO geo_mountain VALUES ('Mt Elbert','USA','Colorado');
 INSERT INTO geo_mountain VALUES ('Pikes Peak','USA','Colorado');
 INSERT INTO geo_mountain VALUES ('Wheeler Peak','USA','New Mexico');
 INSERT INTO geo_mountain VALUES ('Humphreys Peak','USA','Arizona');
 INSERT INTO geo_mountain VALUES ('Guadalupe Peak','USA','Texas');
 INSERT INTO geo_mountain VALUES ('Mt Rainier','USA','Washington');
 INSERT INTO geo_mountain VALUES ('Mt Adams','USA','Washington');
 INSERT INTO geo_mountain VALUES ('Mt Hood','USA','Oregon');
 INSERT INTO geo_mountain VALUES ('Mt Whitney','USA','California');
 INSERT INTO geo_mountain VALUES ('Boundary Peak','USA','California');
 INSERT INTO geo_mountain VALUES ('Boundary Peak','USA','Nevada');
 INSERT INTO geo_mountain VALUES ('Mt Washington','USA','New Hampshire');
 INSERT INTO geo_mountain VALUES ('Mt Marcy','USA','New York');
 INSERT INTO geo_mountain VALUES ('Mt Mitchell','USA','North Carolina');
 INSERT INTO geo_mountain VALUES ('Clingmans Dome','USA','Tennessee');
 INSERT INTO geo_mountain VALUES ('Citlaltepetl (Pico de Orizaba)','MEX','Puebla');
 INSERT INTO geo_mountain VALUES ('Citlaltepetl (Pico de Orizaba)','MEX','Veracruz');
 INSERT INTO geo_mountain VALUES ('Popocatepetl','MEX','Mexico, Estado de');
 INSERT INTO geo_mountain VALUES ('Popocatepetl','MEX','Morelos');
 INSERT INTO geo_mountain VALUES ('Popocatepetl','MEX','Puebla');
 INSERT INTO geo_mountain VALUES ('Iztaccihuatl','MEX','Puebla');
 INSERT INTO geo_mountain VALUES ('Nevado de Toluca','MEX','Mexico, Estado de');
 INSERT INTO geo_mountain VALUES ('Nevado de Colima','MEX','Jalisco');
 INSERT INTO geo_mountain VALUES ('Tajumulco','GCA','Guatemala');
 INSERT INTO geo_mountain VALUES ('Concepcion','NIC','Nicaragua');
 INSERT INTO geo_mountain VALUES ('Irazu','CR','Cartago');
 INSERT INTO geo_mountain VALUES ('Cerro Chirripo','CR','Cartago');
 INSERT INTO geo_mountain VALUES ('Cerro Chirripo','CR','Limon');
 INSERT INTO geo_mountain VALUES ('Pico Turquino','C','Granma');
 INSERT INTO geo_mountain VALUES ('Pico Turquino','C','Santiago de Cuba');
 INSERT INTO geo_mountain VALUES ('Blue Mountain Peak','JA','Jamaica');
 INSERT INTO geo_mountain VALUES ('Pico Duarte','DOM','Dominican Republic');
 INSERT INTO geo_mountain VALUES ('Cerro de Punta','PR','Puerto Rico');
 INSERT INTO geo_mountain VALUES ('La Soufriere','GUAD','Guadeloupe');
 INSERT INTO geo_mountain VALUES ('Soufriere Hills','MNTS','Montserrat');
 INSERT INTO geo_mountain VALUES ('Soufriere','WV','Saint Vincent and the Grenadines');
 INSERT INTO geo_mountain VALUES ('Morne Diablotins','WD','Dominica');
 INSERT INTO geo_mountain VALUES ('Pelee','MART','Martinique');
 INSERT INTO geo_mountain VALUES ('Pico Cristobal Colon','CO','Magdalena');
 INSERT INTO geo_mountain VALUES ('Pico Bolivar','YV','Merida');
 INSERT INTO geo_mountain VALUES ('Nevado del Ruiz','CO','Choco');
 INSERT INTO geo_mountain VALUES ('Nevado del Ruiz','CO','Risaralda');
 INSERT INTO geo_mountain VALUES ('Nevado del Huila','CO','Huila');
 INSERT INTO geo_mountain VALUES ('Cayambe','EC','Ecuador');
 INSERT INTO geo_mountain VALUES ('Cotopaxi','EC','Ecuador');
 INSERT INTO geo_mountain VALUES ('Chimborazo','EC','Ecuador');
 INSERT INTO geo_mountain VALUES ('Huascaran','PE','Ancash');
 INSERT INTO geo_mountain VALUES ('Alpamayo','PE','Ancash');
 INSERT INTO geo_mountain VALUES ('Pico Rocarre','PE','Ancash');
 INSERT INTO geo_mountain VALUES ('Ausangate','PE','Cuzco');
 INSERT INTO geo_mountain VALUES ('Coropuna','PE','Arequipa');
 INSERT INTO geo_mountain VALUES ('Ampato','PE','Arequipa');
 INSERT INTO geo_mountain VALUES ('Illampu','BOL','Bolivia');
 INSERT INTO geo_mountain VALUES ('Illimani','BOL','Bolivia');
 INSERT INTO geo_mountain VALUES ('Sajama','BOL','Bolivia');
 INSERT INTO geo_mountain VALUES ('Licancabur','BOL','Bolivia');
 INSERT INTO geo_mountain VALUES ('Licancabur','RCH','Chile');
 INSERT INTO geo_mountain VALUES ('Llullaillaco','RA','Tucuman');
 INSERT INTO geo_mountain VALUES ('Llullaillaco','RCH','Chile');
 INSERT INTO geo_mountain VALUES ('Ojos del Salado','RA','Tucuman');
 INSERT INTO geo_mountain VALUES ('Ojos del Salado','RCH','Chile');
 INSERT INTO geo_mountain VALUES ('Monte Pissis','RA','La Rioja');
 INSERT INTO geo_mountain VALUES ('Monte Pissis','RA','Tucuman');
 INSERT INTO geo_mountain VALUES ('Aconcagua','RA','Mendoza');
 INSERT INTO geo_mountain VALUES ('Tupungato','RA','Mendoza');
 INSERT INTO geo_mountain VALUES ('Pico de Agulhas Negras','BR','Minas Gerais');
 INSERT INTO geo_mountain VALUES ('Pico de Agulhas Negras','BR','Rio de Janeiro');
 INSERT INTO geo_desert VALUES ('Kalahari','ANG','Moxico');
 INSERT INTO geo_desert VALUES ('Kalahari','ANG','Cuando Cubango');
 INSERT INTO geo_desert VALUES ('Kalahari','NAM','Namibia');
 INSERT INTO geo_desert VALUES ('Kalahari','Z','Southern');
 INSERT INTO geo_desert VALUES ('Kalahari','Z','Western');
 INSERT INTO geo_desert VALUES ('Kalahari','RB','Botswana');
 INSERT INTO geo_desert VALUES ('Kalahari','RSA','North West');
 INSERT INTO geo_desert VALUES ('Namib','NAM','Namibia');
 INSERT INTO geo_desert VALUES ('Ferlo','SN','Louga');
 INSERT INTO geo_desert VALUES ('Ferlo','SN','Saint Louis');
 INSERT INTO geo_desert VALUES ('Ferlo','SN','Tambacounda');
 INSERT INTO geo_desert VALUES ('Trarza','RIM','Mauritania');
 INSERT INTO geo_desert VALUES ('Erg Ouarane','RIM','Mauritania');
 INSERT INTO geo_desert VALUES ('Erg Maqteir','RIM','Mauritania');
 INSERT INTO geo_desert VALUES ('Saguia el-Hamra','WSA','Western Sahara');
 INSERT INTO geo_desert VALUES ('Erg Igidi','DZ','Algeria');
 INSERT INTO geo_desert VALUES ('Erg Igidi','RMM','Mali');
 INSERT INTO geo_desert VALUES ('Erg Igidi','RIM','Mauritania');
 INSERT INTO geo_desert VALUES ('Hamada du Draa','DZ','Algeria');
 INSERT INTO geo_desert VALUES ('Hamada du Draa','MA','Morocco');
 INSERT INTO geo_desert VALUES ('Erg Chech','DZ','Algeria');
 INSERT INTO geo_desert VALUES ('Erg Chech','RMM','Mali');
 INSERT INTO geo_desert VALUES ('Tanezrouft','DZ','Algeria');
 INSERT INTO geo_desert VALUES ('Tanezrouft','RMM','Mali');
 INSERT INTO geo_desert VALUES ('Azaouad','DZ','Algeria');
 INSERT INTO geo_desert VALUES ('Azaouad','RMM','Mali');
 INSERT INTO geo_desert VALUES ('Azaouad','RN','Niger');
 INSERT INTO geo_desert VALUES ('Grand Erg Ouest','DZ','Algeria');
 INSERT INTO geo_desert VALUES ('Grand Erg Est','DZ','Algeria');
 INSERT INTO geo_desert VALUES ('Grand Erg Est','TN','Tunisia');
 INSERT INTO geo_desert VALUES ('Erg Isaouane','DZ','Algeria');
 INSERT INTO geo_desert VALUES ('Hamada al-Hamra','LAR','Libya');
 INSERT INTO geo_desert VALUES ('Fesan','LAR','Libya');
 INSERT INTO geo_desert VALUES ('Erg Rebiana','LAR','Libya');
 INSERT INTO geo_desert VALUES ('Talak','RN','Niger');
 INSERT INTO geo_desert VALUES ('Tenere','RN','Niger');
 INSERT INTO geo_desert VALUES ('Tenere','TCH','Chad');
 INSERT INTO geo_desert VALUES ('Djourab','TCH','Chad');
 INSERT INTO geo_desert VALUES ('Erdi Ennedi','TCH','Chad');
 INSERT INTO geo_desert VALUES ('Libyan Desert','ET','Matruh');
 INSERT INTO geo_desert VALUES ('Libyan Desert','ET','El Wadi el Jadid');
 INSERT INTO geo_desert VALUES ('Libyan Desert','ET','Beni Suef');
 INSERT INTO geo_desert VALUES ('Libyan Desert','ET','El Giza');
 INSERT INTO geo_desert VALUES ('Libyan Desert','ET','El Minya');
 INSERT INTO geo_desert VALUES ('Libyan Desert','LAR','Libya');
 INSERT INTO geo_desert VALUES ('Libyan Desert','SUD','Darfur');
 INSERT INTO geo_desert VALUES ('Libyan Desert','SUD','ash Shamaliyah');
 INSERT INTO geo_desert VALUES ('Darfur','SUD','Darfur');
 INSERT INTO geo_desert VALUES ('Arabian Desert','ET','El Bahr el Ahmar');
 INSERT INTO geo_desert VALUES ('Nubian Desert','SUD','ash Sharqiyah');
 INSERT INTO geo_desert VALUES ('Negev','IL','South');
 INSERT INTO geo_desert VALUES ('Syrian Desert','IRQ','Al Anbar');
 INSERT INTO geo_desert VALUES ('Syrian Desert','JOR','Jordan');
 INSERT INTO geo_desert VALUES ('Syrian Desert','SA','Saudi Arabia');
 INSERT INTO geo_desert VALUES ('Syrian Desert','SYR','Syria');
 INSERT INTO geo_desert VALUES ('Nefud','SA','Saudi Arabia');
 INSERT INTO geo_desert VALUES ('Rub Al Chali','SA','Saudi Arabia');
 INSERT INTO geo_desert VALUES ('Rub Al Chali','OM','Oman');
 INSERT INTO geo_desert VALUES ('Rub Al Chali','UAE','Abu Dhabi');
 INSERT INTO geo_desert VALUES ('Rub Al Chali','UAE','Dubayy');
 INSERT INTO geo_desert VALUES ('Rub Al Chali','UAE','Al Fujayrah');
 INSERT INTO geo_desert VALUES ('Rub Al Chali','UAE','Ras al Khaymah');
 INSERT INTO geo_desert VALUES ('Rub Al Chali','UAE','Ash Shariqah');
 INSERT INTO geo_desert VALUES ('Rub Al Chali','UAE','Umm al Qaywayn');
 INSERT INTO geo_desert VALUES ('Rub Al Chali','YE','Yemen');
 INSERT INTO geo_desert VALUES ('Dascht-e-Kavir','IR','Esfahan');
 INSERT INTO geo_desert VALUES ('Dascht-e-Kavir','IR','Khorasan');
 INSERT INTO geo_desert VALUES ('Dascht-e-Kavir','IR','Semnan');
 INSERT INTO geo_desert VALUES ('Dascht-e-Kavir','IR','Tehran');
 INSERT INTO geo_desert VALUES ('Dascht-e-Kavir','IR','Yazd');
 INSERT INTO geo_desert VALUES ('Dascht-e-Lut','IR','Esfahan');
 INSERT INTO geo_desert VALUES ('Dascht-e-Lut','IR','Kerman');
 INSERT INTO geo_desert VALUES ('Dascht-e-Lut','IR','Khorasan');
 INSERT INTO geo_desert VALUES ('Dascht-e-Lut','IR','Sistan e Baluchestan');
 INSERT INTO geo_desert VALUES ('Dascht-e-Lut','IR','Yazd');
 INSERT INTO geo_desert VALUES ('Dascht-e-Margoh','AFG','Afghanistan');
 INSERT INTO geo_desert VALUES ('Rigestan','AFG','Afghanistan');
 INSERT INTO geo_desert VALUES ('Rigestan','PK','Pakistan');
 INSERT INTO geo_desert VALUES ('Thar','PK','Pakistan');
 INSERT INTO geo_desert VALUES ('Thar','IND','Gujarat');
 INSERT INTO geo_desert VALUES ('Thar','IND','Haryana');
 INSERT INTO geo_desert VALUES ('Thar','IND','Punjab');
 INSERT INTO geo_desert VALUES ('Thar','IND','Rajasthan');
 INSERT INTO geo_desert VALUES ('Ryn','R','Rep. of Kalmykiya');
 INSERT INTO geo_desert VALUES ('Ryn','R','Astrakhanskaya oblast');
 INSERT INTO geo_desert VALUES ('Ryn','KAZ','Atyrau');
 INSERT INTO geo_desert VALUES ('Ryn','KAZ','Batys Qazaqstan');
 INSERT INTO geo_desert VALUES ('Ust Urt','UZB','Qaraqalpoghiston');
 INSERT INTO geo_desert VALUES ('Ust Urt','KAZ','Aqtobe');
 INSERT INTO geo_desert VALUES ('Ust Urt','KAZ','Mangghystau');
 INSERT INTO geo_desert VALUES ('Karakum','TM','Ahal');
 INSERT INTO geo_desert VALUES ('Karakum','TM','Balkan');
 INSERT INTO geo_desert VALUES ('Karakum','TM','Dashhowuz');
 INSERT INTO geo_desert VALUES ('Karakum','TM','Leban');
 INSERT INTO geo_desert VALUES ('Karakum','TM','Mary');
 INSERT INTO geo_desert VALUES ('Karakum','UZB','Samarqand');
 INSERT INTO geo_desert VALUES ('Karakum','UZB','Qaraqalpoghiston');
 INSERT INTO geo_desert VALUES ('Kysylkum','UZB','Jizzakh');
 INSERT INTO geo_desert VALUES ('Kysylkum','UZB','Samarqand');
 INSERT INTO geo_desert VALUES ('Kysylkum','UZB','Qaraqalpoghiston');
 INSERT INTO geo_desert VALUES ('Kysylkum','KAZ','Qyzylorda');
 INSERT INTO geo_desert VALUES ('Mujunkum','KAZ','Qyzylorda');
 INSERT INTO geo_desert VALUES ('Mujunkum','KAZ','Zhambyl');
 INSERT INTO geo_desert VALUES ('TaklaMakan','TJ','Xinjiang Uygur');
 INSERT INTO geo_desert VALUES ('Gurbantunggut','TJ','Xinjiang Uygur');
 INSERT INTO geo_desert VALUES ('Kum Tagh','TJ','Xinjiang Uygur');
 INSERT INTO geo_desert VALUES ('Qaidam','TJ','Qinghai');
 INSERT INTO geo_desert VALUES ('Gobi','TJ','Gansu');
 INSERT INTO geo_desert VALUES ('Gobi','TJ','Nei Monggol');
 INSERT INTO geo_desert VALUES ('Gobi','TJ','Ningxia Huizu');
 INSERT INTO geo_desert VALUES ('Gobi','MNG','Mongolia');
 INSERT INTO geo_desert VALUES ('Ordos','TJ','Shaanxi');
 INSERT INTO geo_desert VALUES ('Ordos','TJ','Nei Monggol');
 INSERT INTO geo_desert VALUES ('Ordos','TJ','Ningxia Huizu');
 INSERT INTO geo_desert VALUES ('Great Sandy Desert','AUS','Western Australia');
 INSERT INTO geo_desert VALUES ('Gibson Desert','AUS','Western Australia');
 INSERT INTO geo_desert VALUES ('Great Victoria Desert','AUS','South Australia');
 INSERT INTO geo_desert VALUES ('Great Victoria Desert','AUS','Western Australia');
 INSERT INTO geo_desert VALUES ('Nullarbor Plain','AUS','South Australia');
 INSERT INTO geo_desert VALUES ('Nullarbor Plain','AUS','Western Australia');
 INSERT INTO geo_desert VALUES ('Simpson Desert','AUS','Northern Territory');
 INSERT INTO geo_desert VALUES ('Simpson Desert','AUS','Queensland');
 INSERT INTO geo_desert VALUES ('Simpson Desert','AUS','South Australia');
 INSERT INTO geo_desert VALUES ('Red Centre','AUS','Northern Territory');
 INSERT INTO geo_desert VALUES ('Red Centre','AUS','South Australia');
 INSERT INTO geo_desert VALUES ('Red Centre','AUS','Western Australia');
 INSERT INTO geo_desert VALUES ('Tanami','AUS','Northern Territory');
 INSERT INTO geo_desert VALUES ('Sturt Desert','AUS','New South Wales');
 INSERT INTO geo_desert VALUES ('Sturt Desert','AUS','Northern Territory');
 INSERT INTO geo_desert VALUES ('Sturt Desert','AUS','Queensland');
 INSERT INTO geo_desert VALUES ('Owyhee','USA','Idaho');
 INSERT INTO geo_desert VALUES ('Owyhee','USA','Nevada');
 INSERT INTO geo_desert VALUES ('Owyhee','USA','Oregon');
 INSERT INTO geo_desert VALUES ('Great Salt Lake Desert','USA','Utah');
 INSERT INTO geo_desert VALUES ('Colorado Plateau','USA','Arizona');
 INSERT INTO geo_desert VALUES ('Colorado Plateau','USA','Colorado');
 INSERT INTO geo_desert VALUES ('Colorado Plateau','USA','New Mexico');
 INSERT INTO geo_desert VALUES ('Colorado Plateau','USA','Utah');
 INSERT INTO geo_desert VALUES ('Great Basin','USA','California');
 INSERT INTO geo_desert VALUES ('Great Basin','USA','Nevada');
 INSERT INTO geo_desert VALUES ('Great Basin','USA','Utah');
 INSERT INTO geo_desert VALUES ('Mojave','USA','Arizona');
 INSERT INTO geo_desert VALUES ('Mojave','USA','California');
 INSERT INTO geo_desert VALUES ('Mojave','USA','Nevada');
 INSERT INTO geo_desert VALUES ('Mojave','USA','Utah');
 INSERT INTO geo_desert VALUES ('Sonora','MEX','Chihuahua');
 INSERT INTO geo_desert VALUES ('Sonora','MEX','Sonora');
 INSERT INTO geo_desert VALUES ('Sonora','USA','Arizona');
 INSERT INTO geo_desert VALUES ('Sonora','USA','California');
 INSERT INTO geo_desert VALUES ('Chihuahua','USA','Arizona');
 INSERT INTO geo_desert VALUES ('Chihuahua','USA','New Mexico');
 INSERT INTO geo_desert VALUES ('Chihuahua','USA','Texas');
 INSERT INTO geo_desert VALUES ('Baja California Desert','MEX','Baja California');
 INSERT INTO geo_desert VALUES ('Atacama','RCH','Chile');
 
COMMIT;


 INSERT INTO mergesWith VALUES ('Kattegat','Skagerrak');
 INSERT INTO mergesWith VALUES ('North Sea','Skagerrak');
 INSERT INTO mergesWith VALUES ('North Sea','The Channel');
 INSERT INTO mergesWith VALUES ('North Sea','Norwegian Sea');
 INSERT INTO mergesWith VALUES ('Black Sea','Sea of Azov');
 INSERT INTO mergesWith VALUES ('Black Sea','Mediterranean Sea');
 INSERT INTO mergesWith VALUES ('Baltic Sea','North Sea');
 INSERT INTO mergesWith VALUES ('Atlantic Ocean','North Sea');
 INSERT INTO mergesWith VALUES ('Atlantic Ocean','The Channel');
 INSERT INTO mergesWith VALUES ('Atlantic Ocean','Mediterranean Sea');
 INSERT INTO mergesWith VALUES ('Atlantic Ocean','Gulf of Mexico');
 INSERT INTO mergesWith VALUES ('Atlantic Ocean','Norwegian Sea');
 INSERT INTO mergesWith VALUES ('Atlantic Ocean','Pacific Ocean');
 INSERT INTO mergesWith VALUES ('Atlantic Ocean','Irish Sea');
 INSERT INTO mergesWith VALUES ('Atlantic Ocean','Caribbean Sea');
 INSERT INTO mergesWith VALUES ('Atlantic Ocean','Indian Ocean');
 INSERT INTO mergesWith VALUES ('Barents Sea','Norwegian Sea');
 INSERT INTO mergesWith VALUES ('Barents Sea','Sibirian Sea');
 INSERT INTO mergesWith VALUES ('Arctic Ocean','Atlantic Ocean');
 INSERT INTO mergesWith VALUES ('Arctic Ocean','Norwegian Sea');
 INSERT INTO mergesWith VALUES ('Arctic Ocean','Barents Sea');
 INSERT INTO mergesWith VALUES ('Arctic Ocean','Sibirian Sea');
 INSERT INTO mergesWith VALUES ('Arctic Ocean','Bering Sea');
 INSERT INTO mergesWith VALUES ('Bering Sea','Pacific Ocean');
 INSERT INTO mergesWith VALUES ('Pacific Ocean','Sea of Okhotsk');
 INSERT INTO mergesWith VALUES ('Pacific Ocean','Sea of Japan');
 INSERT INTO mergesWith VALUES ('Pacific Ocean','South China Sea');
 INSERT INTO mergesWith VALUES ('Pacific Ocean','Sunda Sea');
 INSERT INTO mergesWith VALUES ('Pacific Ocean','Sulawesi Sea');
 INSERT INTO mergesWith VALUES ('Sea of Japan','Sea of Okhotsk');
 INSERT INTO mergesWith VALUES ('Sea of Japan','Yellow Sea');
 INSERT INTO mergesWith VALUES ('East China Sea','Pacific Ocean');
 INSERT INTO mergesWith VALUES ('East China Sea','Sea of Japan');
 INSERT INTO mergesWith VALUES ('East China Sea','Yellow Sea');
 INSERT INTO mergesWith VALUES ('East China Sea','South China Sea');
 INSERT INTO mergesWith VALUES ('South China Sea','Sunda Sea');
 INSERT INTO mergesWith VALUES ('South China Sea','Sulawesi Sea');
 INSERT INTO mergesWith VALUES ('Caribbean Sea','Gulf of Mexico');
 INSERT INTO mergesWith VALUES ('Indian Ocean','Pacific Ocean');
 INSERT INTO mergesWith VALUES ('Indian Ocean','Sunda Sea');
 INSERT INTO mergesWith VALUES ('Arabian Sea','Indian Ocean');
 INSERT INTO mergesWith VALUES ('Arabian Sea','Gulf of Oman');
 INSERT INTO mergesWith VALUES ('Arabian Sea','Gulf of Aden');
 INSERT INTO mergesWith VALUES ('Gulf of Oman','Persian Gulf');
 INSERT INTO mergesWith VALUES ('Gulf of Oman','Indian Ocean');
 INSERT INTO mergesWith VALUES ('Gulf of Aden','Indian Ocean');
 INSERT INTO mergesWith VALUES ('Gulf of Aden','Red Sea');
 INSERT INTO mergesWith VALUES ('Gulf of Bengal','Pacific Ocean');
 INSERT INTO mergesWith VALUES ('Gulf of Bengal','Sunda Sea');
 INSERT INTO mergesWith VALUES ('Andaman Sea','Indian Ocean');
 INSERT INTO mergesWith VALUES ('Andaman Sea','Gulf of Bengal');
 INSERT INTO mergesWith VALUES ('Andaman Sea','Malakka Strait');
 INSERT INTO mergesWith VALUES ('Malakka Strait','South China Sea');
 INSERT INTO mergesWith VALUES ('Sulawesi Sea','Sunda Sea');
 
COMMIT;


 INSERT INTO located VALUES ('Shkoder','Albania','AL',NULL,'Lake Skutari',NULL);
 INSERT INTO located VALUES ('Durres','Albania','AL',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Vlore','Albania','AL',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Kavalla','Anatoliki Makedhonia kai Thraki','GR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Athens','Attiki','GR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Piraeus','Attiki','GR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Patrai','Dhytiki Ellas','GR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Korfu','Ionioi Nisoi','GR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Thessaloniki','Kedriki Makedhonia','GR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Iraklion','Kriti','GR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Ermoupoli','Notion Aiyaion','GR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Volos','Thessalia','GR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Mytilini','Voreion Aiyaion','GR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Belgrade','Serbia','SRB','Donau',NULL,NULL);
 INSERT INTO located VALUES ('Belgrade','Serbia','SRB','Save',NULL,NULL);
 INSERT INTO located VALUES ('Strasbourg','Alsace','F','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Bordeaux','Aquitaine','F','Garonne',NULL,NULL);
 INSERT INTO located VALUES ('Brest','Bretagne','F',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Orleans','Centre','F','Loire',NULL,NULL);
 INSERT INTO located VALUES ('Tours','Centre','F','Loire',NULL,NULL);
 INSERT INTO located VALUES ('Chalons en Champagne','Champagne Ardenne','F','Marne',NULL,NULL);
 INSERT INTO located VALUES ('Ajaccio','Corse','F',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Besancon','Franche Comte','F','Doubs',NULL,NULL);
 INSERT INTO located VALUES ('Rouen','Haute Normandie','F','Seine',NULL,NULL);
 INSERT INTO located VALUES ('Le Havre','Haute Normandie','F','Seine',NULL,'The Channel');
 INSERT INTO located VALUES ('Paris','Ile de France','F','Seine',NULL,NULL);
 INSERT INTO located VALUES ('Boulogne Billancourt','Ile de France','F','Seine',NULL,NULL);
 INSERT INTO located VALUES ('Perpignan','Languedoc Roussillon','F',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Metz','Lorraine','F','Mosel',NULL,NULL);
 INSERT INTO located VALUES ('Nancy','Lorraine','F','Mosel',NULL,NULL);
 INSERT INTO located VALUES ('Toulouse','Midi Pyrenees','F','Garonne',NULL,NULL);
 INSERT INTO located VALUES ('Nantes','Pays de la Loire','F','Loire',NULL,NULL);
 INSERT INTO located VALUES ('Marseille','Provence Cote dAzur','F',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Nice','Provence Cote dAzur','F',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Toulon','Provence Cote dAzur','F',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Lyon','Rhone Alpes','F','Saone',NULL,NULL);
 INSERT INTO located VALUES ('Lyon','Rhone Alpes','F','Saone',NULL,NULL);
 INSERT INTO located VALUES ('Grenoble','Rhone Alpes','F','Isere',NULL,NULL);
 INSERT INTO located VALUES ('Villeurbanne','Rhone Alpes','F','Rhone',NULL,NULL);
 INSERT INTO located VALUES ('Sevilla','Andalusia','E','Guadalquivir',NULL,NULL);
 INSERT INTO located VALUES ('Almeria','Andalusia','E',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Cadiz','Andalusia','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Cordoba','Andalusia','E','Guadalquivir',NULL,NULL);
 INSERT INTO located VALUES ('Huelva','Andalusia','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Malaga','Andalusia','E',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Algeciras','Andalusia','E',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Zaragoza','Aragon','E','Ebro',NULL,NULL);
 INSERT INTO located VALUES ('Gijon','Asturias','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Palma de Mallorca','Balearic Islands','E',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Bilbao','Basque Country','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Baracaldo','Basque Country','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Donostia','Basque Country','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Santa Cruz de Tenerife','Canary Islands','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Las Palmas de Gran Canaria','Canary Islands','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('La Laguna','Canary Islands','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Santander','Cantabria','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Valladolid','Castile and Leon','E','Douro',NULL,NULL);
 INSERT INTO located VALUES ('Barcelona','Catalonia','E',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Badalona','Catalonia','E',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Badajoz','Estremadura','E','Guadiana',NULL,NULL);
 INSERT INTO located VALUES ('La Coruna','Galicia','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Vigo','Galicia','E',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Cartagena','Murcia','E',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Logrono','Rioja','E','Ebro',NULL,NULL);
 INSERT INTO located VALUES ('Valencia','Valencia','E',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Alicante','Valencia','E',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Castellon de la Plana','Valencia','E',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Bregenz','Vorarlberg','A',NULL,'Bodensee',NULL);
 INSERT INTO located VALUES ('Vienna','Vienna','A','Donau',NULL,NULL);
 INSERT INTO located VALUES ('Linz','Upper Austria','A','Donau',NULL,NULL);
 INSERT INTO located VALUES ('Innsbruck','Tyrol','A','Inn',NULL,NULL);
 INSERT INTO located VALUES ('Graz','Styria','A','Mur',NULL,NULL);
 INSERT INTO located VALUES ('Salzburg','Salzburg','A','Salzach',NULL,NULL);
 INSERT INTO located VALUES ('Ostrava','Severomoravsky','CZ','Oder',NULL,NULL);
 INSERT INTO located VALUES ('Olomouc','Severomoravsky','CZ','March',NULL,NULL);
 INSERT INTO located VALUES ('Stuttgart','Baden Wurttemberg','D','Neckar',NULL,NULL);
 INSERT INTO located VALUES ('Mannheim','Baden Wurttemberg','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Mannheim','Baden Wurttemberg','D','Neckar',NULL,NULL);
 INSERT INTO located VALUES ('Karlsruhe','Baden Wurttemberg','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Heidelberg','Baden Wurttemberg','D','Neckar',NULL,NULL);
 INSERT INTO located VALUES ('Heilbronn','Baden Wurttemberg','D','Neckar',NULL,NULL);
 INSERT INTO located VALUES ('Ulm','Baden Wurttemberg','D','Donau',NULL,NULL);
 INSERT INTO located VALUES ('Ulm','Baden Wurttemberg','D','Iller',NULL,NULL);
 INSERT INTO located VALUES ('Munich','Bayern','D','Isar',NULL,NULL);
 INSERT INTO located VALUES ('Augsburg','Bayern','D','Lech',NULL,NULL);
 INSERT INTO located VALUES ('Wurzburg','Bayern','D','Main',NULL,NULL);
 INSERT INTO located VALUES ('Regensburg','Bayern','D','Donau',NULL,NULL);
 INSERT INTO located VALUES ('Ingolstadt','Bayern','D','Donau',NULL,NULL);
 INSERT INTO located VALUES ('Bremen','Bremen','D','Weser',NULL,NULL);
 INSERT INTO located VALUES ('Bremerhaven','Bremen','D','Weser',NULL,'North Sea');
 INSERT INTO located VALUES ('Hamburg','Hamburg','D','Elbe',NULL,NULL);
 INSERT INTO located VALUES ('Wiesbaden','Hessen','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Wiesbaden','Hessen','D','Main',NULL,NULL);
 INSERT INTO located VALUES ('Frankfurt am Main','Hessen','D','Main',NULL,NULL);
 INSERT INTO located VALUES ('Kassel','Hessen','D','Fulda',NULL,NULL);
 INSERT INTO located VALUES ('Offenbach am Main','Hessen','D','Main',NULL,NULL);
 INSERT INTO located VALUES ('Rostock','Mecklenburg Vorpommern','D',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Hannover','Niedersachsen','D','Leine',NULL,NULL);
 INSERT INTO located VALUES ('Gottingen','Niedersachsen','D','Leine',NULL,NULL);
 INSERT INTO located VALUES ('Wolfsburg','Niedersachsen','D','Aller',NULL,NULL);
 INSERT INTO located VALUES ('Dusseldorf','Nordrhein Westfalen','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Koln','Nordrhein Westfalen','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Duisburg','Nordrhein Westfalen','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Bonn','Nordrhein Westfalen','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Krefeld','Nordrhein Westfalen','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Leverkusen','Nordrhein Westfalen','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Neuss','Nordrhein Westfalen','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Mainz','Rheinland Pfalz','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Ludwigshafen','Rheinland Pfalz','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Koblenz','Rheinland Pfalz','D','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Koblenz','Rheinland Pfalz','D','Mosel',NULL,NULL);
 INSERT INTO located VALUES ('Saarbrucken','Saarland','D','Saar',NULL,NULL);
 INSERT INTO located VALUES ('Dresden','Sachsen','D','Elbe',NULL,NULL);
 INSERT INTO located VALUES ('Magdeburg','Sachsen Anhalt','D','Elbe',NULL,NULL);
 INSERT INTO located VALUES ('Kiel','Schleswig Holstein','D',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Lubeck','Schleswig Holstein','D',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Szolnok','Szolnok','H','Theiss',NULL,NULL);
 INSERT INTO located VALUES ('Budapest','Budapest (munic.)','H','Donau',NULL,NULL);
 INSERT INTO located VALUES ('Gyor','Gyor (munic.)','H','Raab',NULL,NULL);
 INSERT INTO located VALUES ('Szeged','Szeged (munic.)','H','Theiss',NULL,NULL);
 INSERT INTO located VALUES ('Turin','Piemonte','I','Po',NULL,NULL);
 INSERT INTO located VALUES ('Bolzano','Trentino Alto Adige','I','Etsch',NULL,NULL);
 INSERT INTO located VALUES ('Trento','Trentino Alto Adige','I','Etsch',NULL,NULL);
 INSERT INTO located VALUES ('Verona','Veneto','I','Etsch',NULL,NULL);
 INSERT INTO located VALUES ('Venice','Veneto','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Trieste','Friuli Venezia Giulia','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('La Spezia','Liguria','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Genua','Liguria','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Piacenza','Emilia Romagna','I','Po',NULL,NULL);
 INSERT INTO located VALUES ('Rimini','Emilia Romagna','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Livorno','Toscana','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Pisa','Toscana','I','Arno',NULL,NULL);
 INSERT INTO located VALUES ('Firenze','Toscana','I','Arno',NULL,NULL);
 INSERT INTO located VALUES ('Ancona','Marche','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Rome','Lazio','I','Tiber',NULL,NULL);
 INSERT INTO located VALUES ('Pescara','Abruzzo','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Salerno','Campania','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Napoli','Campania','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Torre del Greco','Campania','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Bari','Puglia','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Taranto','Puglia','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Reggio di Calabria','Calabria','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Palermo','Sicilia','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Messina','Sicilia','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Catania','Sicilia','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Siracusa','Sicilia','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Cagliari','Sardegna','I',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Bratislava','Slovakia','SK','Donau',NULL,NULL);
 INSERT INTO located VALUES ('Bratislava','Slovakia','SK','March',NULL,NULL);
 INSERT INTO located VALUES ('Ljubljana','Slovenia','SLO','Save',NULL,NULL);
 INSERT INTO located VALUES ('Aarau','AG','CH','Aare',NULL,NULL);
 INSERT INTO located VALUES ('Basel','BS','CH','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Bern','BE','CH','Aare',NULL,NULL);
 INSERT INTO located VALUES ('Geneva','GE','CH','Rhone','Lac Leman',NULL);
 INSERT INTO located VALUES ('Chur','GR','CH','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Luzern','LU','CH','Reuss','Vierwaldstattersee',NULL);
 INSERT INTO located VALUES ('Schaffhausen','SH','CH','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Solothurn','SO','CH','Aare',NULL,NULL);
 INSERT INTO located VALUES ('Bellinzona','TI','CH','Ticino',NULL,NULL);
 INSERT INTO located VALUES ('Altdorf','UR','CH','Reuss',NULL,NULL);
 INSERT INTO located VALUES ('Sion','VS','CH','Rhone',NULL,NULL);
 INSERT INTO located VALUES ('Lausanne','VD','CH',NULL,'Lac Leman',NULL);
 INSERT INTO located VALUES ('Zurich','ZH','CH','Limmat','Zurichsee',NULL);
 INSERT INTO located VALUES ('Riga','Latvia','LV','Western Dwina',NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Warsaw','Warszwaskie','PL','Weichsel',NULL,NULL);
 INSERT INTO located VALUES ('Bydgoszcz','Bydgoskie','PL','Weichsel',NULL,NULL);
 INSERT INTO located VALUES ('Gdansk','Gdanskie','PL','Weichsel',NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Gdynia','Gdanskie','PL',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Krakow','Krakowskie','PL','Weichsel',NULL,NULL);
 INSERT INTO located VALUES ('Opole','Opolskie','PL','Oder',NULL,NULL);
 INSERT INTO located VALUES ('Szczecin','Szczecinskie','PL','Oder',NULL,NULL);
 INSERT INTO located VALUES ('Wroclaw','Wroclawskie','PL','Oder',NULL,NULL);
 INSERT INTO located VALUES ('Cherkasy','Cherkaska','UA','Dnepr',NULL,NULL);
 INSERT INTO located VALUES ('Chernivtsi','Chernivetska','UA','Pruth',NULL,NULL);
 INSERT INTO located VALUES ('Dnipropetrovsk','Dnipropetrovska','UA','Dnepr',NULL,NULL);
 INSERT INTO located VALUES ('Dniprodzerzhynsk','Dnipropetrovska','UA','Dnepr',NULL,NULL);
 INSERT INTO located VALUES ('Kherson','Khersonska','UA','Dnepr',NULL,NULL);
 INSERT INTO located VALUES ('Kiev','Kyyivska','UA','Dnepr',NULL,NULL);
 INSERT INTO located VALUES ('Kremenchuk','Poltavska','UA','Dnepr',NULL,NULL);
 INSERT INTO located VALUES ('Zaporizhzhya','Zaporizka','UA','Dnepr',NULL,NULL);
 INSERT INTO located VALUES ('Arkhangelsk','Arkhangelskaya oblast','R','Northern Dwina',NULL,'Barents Sea');
 INSERT INTO located VALUES ('Severodvinsk','Arkhangelskaya oblast','R',NULL,NULL,'Barents Sea');
 INSERT INTO located VALUES ('Murmansk','Murmanskaya oblast','R',NULL,NULL,'Barents Sea');
 INSERT INTO located VALUES ('Kaliningrad','Kaliningradskaya oblast','R',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Sankt Peterburg','Sankt Peterburg','R',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Kaluga','Kaluzhskaya oblast','R','Oka',NULL,NULL);
 INSERT INTO located VALUES ('Kostroma','Kostromskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Kolomna','Moskovskaya oblast','R','Oka',NULL,NULL);
 INSERT INTO located VALUES ('Serpukhov','Moskovskaya oblast','R','Oka',NULL,NULL);
 INSERT INTO located VALUES ('Ryazan','Ryazanskaya oblast','R','Oka',NULL,NULL);
 INSERT INTO located VALUES ('Smolensk','Smolenskaya oblast','R','Dnepr',NULL,NULL);
 INSERT INTO located VALUES ('Tver','Tverskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Yaroslavl','Yaroslavskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Rybinsk','Yaroslavskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Nizhniy Novgorod','Nizhegorodskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Nizhniy Novgorod','Nizhegorodskaya oblast','R','Oka',NULL,NULL);
 INSERT INTO located VALUES ('Dzerzhinsk','Nizhegorodskaya oblast','R','Oka',NULL,NULL);
 INSERT INTO located VALUES ('Kazan','Rep. of Tatarstan','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Astrakhan','Astrakhanskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Volgograd','Volgogradskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Samara','Samarskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Tolyatti','Samarskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Saratov','Saratovskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Balakovo','Saratovskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Engels','Saratovskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Simbirsk','Ulyanovskaya oblast','R','Volga',NULL,NULL);
 INSERT INTO located VALUES ('Orenburg','Orenburgskaya oblast','R','Ural',NULL,NULL);
 INSERT INTO located VALUES ('Orsk','Orenburgskaya oblast','R','Ural',NULL,NULL);
 INSERT INTO located VALUES ('Kurgan','Kurganskaya oblast','R','Tobol',NULL,NULL);
 INSERT INTO located VALUES ('Magnitogorsk','Chelyabinskaya oblast','R','Ural',NULL,NULL);
 INSERT INTO located VALUES ('Biysk','Altayskiy kray','R','Katun',NULL,NULL);
 INSERT INTO located VALUES ('Omsk','Omskaya oblast','R','Irtysch',NULL,NULL);
 INSERT INTO located VALUES ('Kyzyl','Rep. of Tyva','R','Jenissej',NULL,NULL);
 INSERT INTO located VALUES ('Abakan','Rep. of Khakassiya','R','Jenissej',NULL,NULL);
 INSERT INTO located VALUES ('Krasnoyarsk','Krasnoyarskiy kray','R','Jenissej',NULL,NULL);
 INSERT INTO located VALUES ('Irkutsk','Irkutskaya oblast','R','Angara',NULL,NULL);
 INSERT INTO located VALUES ('Angarsk','Irkutskaya oblast','R','Angara',NULL,NULL);
 INSERT INTO located VALUES ('Bratsk','Irkutskaya oblast','R','Angara',NULL,NULL);
 INSERT INTO located VALUES ('Ust Ilimsk','Irkutskaya oblast','R','Angara',NULL,NULL);
 INSERT INTO located VALUES ('Usolye Sibirskoye','Irkutskaya oblast','R','Angara',NULL,NULL);
 INSERT INTO located VALUES ('Chita','Chitinskaya oblast','R','Schilka',NULL,NULL);
 INSERT INTO located VALUES ('Yakutsk','Rep. of Sakha','R','Lena',NULL,NULL);
 INSERT INTO located VALUES ('Vladivostok','Primorsky kray','R',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Nakhodka','Primorsky kray','R',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Khabarovsk','Khabarovskiy kray','R','Amur',NULL,NULL);
 INSERT INTO located VALUES ('Komsomolsk na Amure','Khabarovskiy kray','R','Amur',NULL,NULL);
 INSERT INTO located VALUES ('Blagoveshchensk','Amurskaya oblast','R','Amur',NULL,NULL);
 INSERT INTO located VALUES ('Petropavlovsk Kamchatsky','Kamchatskaya oblast','R',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Magadan','Magadanskaya oblast','R',NULL,NULL,'Sea of Okhotsk');
 INSERT INTO located VALUES ('Okhotsk','Magadanskaya oblast','R',NULL,NULL,'Sea of Okhotsk');
 INSERT INTO located VALUES ('Liege','Liege','B','Maas',NULL,NULL);
 INSERT INTO located VALUES ('Namur','Namur','B','Maas',NULL,NULL);
 INSERT INTO located VALUES ('Arnhem','Gelderland','NL','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Nijmegen','Gelderland','NL','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Rotterdam','Zuid Holland','NL','Rhein',NULL,NULL);
 INSERT INTO located VALUES ('Maastricht','Limburg','NL','Maas',NULL,NULL);
 INSERT INTO located VALUES ('Zagreb','Croatia','HR','Save',NULL,NULL);
 INSERT INTO located VALUES ('Braila','Braila','RO','Donau',NULL,NULL);
 INSERT INTO located VALUES ('Sfintu Gheorghe','Covasna','RO','Olt',NULL,NULL);
 INSERT INTO located VALUES ('Galati','Galati','RO','Donau',NULL,NULL);
 INSERT INTO located VALUES ('Miercurea Ciuc','Harghita','RO','Olt',NULL,NULL);
 INSERT INTO located VALUES ('Slatina','Olt','RO','Olt',NULL,NULL);
 INSERT INTO located VALUES ('Diyarbakir','Diyarbakir','TR','Tigris',NULL,NULL);
 INSERT INTO located VALUES ('Erzincan','Erzincan','TR','Karasu',NULL,NULL);
 INSERT INTO located VALUES ('Erzurum','Erzurum','TR','Karasu',NULL,NULL);
 INSERT INTO located VALUES ('Mus','Mus','TR','Murat',NULL,NULL);
 INSERT INTO located VALUES ('Copenhagen','Denmark','DK',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Aarhus','Denmark','DK',NULL,NULL,'Kattegat');
 INSERT INTO located VALUES ('Esbjerg','Denmark','DK',NULL,NULL,'North Sea');
 INSERT INTO located VALUES ('Tallinn','Estonia','EW',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Torshavn','Faroe Islands','FARX',NULL,NULL,'Norwegian Sea');
 INSERT INTO located VALUES ('Lahti','Haeme','SF',NULL,'Paeijaenne',NULL);
 INSERT INTO located VALUES ('Kuopio','Kuopio','SF',NULL,'Kallavesi',NULL);
 INSERT INTO located VALUES ('Lappeenrenta','Kymi','SF',NULL,'Saimaa',NULL);
 INSERT INTO located VALUES ('Kotka','Kymi','SF','Kymijoki',NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Rovaniemi','Lappia','SF','Ounasjoki',NULL,NULL);
 INSERT INTO located VALUES ('Rovaniemi','Lappia','SF','Kemijoki',NULL,NULL);
 INSERT INTO located VALUES ('Mikkeli','Mikkeli','SF',NULL,'Saimaa',NULL);
 INSERT INTO located VALUES ('Jyvaeskylae','Suomi','SF',NULL,'Paeijaenne',NULL);
 INSERT INTO located VALUES ('Oulu','Oulu','SF','Oulujoki',NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Pori','Turku-Pori','SF','Kokemaeenjoki',NULL,NULL);
 INSERT INTO located VALUES ('Turku','Turku-Pori','SF',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Helsinki','Uusimaa','SF',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Espoo','Uusimaa','SF',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Vaasa','Vaasa','SF',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Oslo','Oslo','N',NULL,NULL,'Skagerrak');
 INSERT INTO located VALUES ('Moss','Oestfold','N',NULL,NULL,'Skagerrak');
 INSERT INTO located VALUES ('Hamar','Hedmark','N',NULL,'Mjoesa-See',NULL);
 INSERT INTO located VALUES ('Lillehammer','Oppland','N',NULL,'Mjoesa-See',NULL);
 INSERT INTO located VALUES ('Arendal','Aust Agder','N',NULL,NULL,'Skagerrak');
 INSERT INTO located VALUES ('Kristiansand','Vest Agder','N',NULL,NULL,'Skagerrak');
 INSERT INTO located VALUES ('Stavanger','Rogaland','N',NULL,NULL,'North Sea');
 INSERT INTO located VALUES ('Bergen','Hordaland','N',NULL,NULL,'North Sea');
 INSERT INTO located VALUES ('Molde','Moere og Romsdal','N',NULL,NULL,'Norwegian Sea');
 INSERT INTO located VALUES ('Trondheim','Soer Trondelag','N',NULL,NULL,'Norwegian Sea');
 INSERT INTO located VALUES ('Steinkjer','Nord Trondelag','N',NULL,NULL,'Norwegian Sea');
 INSERT INTO located VALUES ('Svolvaer','Nordland','N',NULL,NULL,'Norwegian Sea');
 INSERT INTO located VALUES ('Narvik','Nordland','N',NULL,NULL,'Norwegian Sea');
 INSERT INTO located VALUES ('Bodoe','Nordland','N',NULL,NULL,'Norwegian Sea');
 INSERT INTO located VALUES ('Tromsoe','Troms','N',NULL,NULL,'Norwegian Sea');
 INSERT INTO located VALUES ('Hammerfest','Finnmark','N',NULL,NULL,'Barents Sea');
 INSERT INTO located VALUES ('Vadsoe','Finnmark','N',NULL,NULL,'Barents Sea');
 INSERT INTO located VALUES ('Vanersborg','Alvsborg','S','Goetaaelv','Vaenern',NULL);
 INSERT INTO located VALUES ('Karlskrona','Blekinge','S',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Gavle','Gavleborg','S',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Goteborg','Goteborg och Bohus','S','Goetaaelv',NULL,'Kattegat');
 INSERT INTO located VALUES ('Visby','Gotland','S',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Halmstad','Halland','S',NULL,NULL,'Kattegat');
 INSERT INTO located VALUES ('Jonkoping','Jonkoping','S',NULL,'Vaettern',NULL);
 INSERT INTO located VALUES ('Kalmar','Kalmar','S',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Malmo','Malmohus','S',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Helsingborg','Malmohus','S',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Lulea','Norrbotten','S',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Mariestad','Skaraborg','S',NULL,'Vaenern',NULL);
 INSERT INTO located VALUES ('Stockholm','Stockholm','S',NULL,'Maelaren','Baltic Sea');
 INSERT INTO located VALUES ('Karlstad','Varmland','S','Klaraelv','Vaenern',NULL);
 INSERT INTO located VALUES ('Umea','Vasterbotten','S','Umeaelv',NULL,NULL);
 INSERT INTO located VALUES ('Harnosand','Vasternorrland','S',NULL,NULL,'Baltic Sea');
 INSERT INTO located VALUES ('Vasteras','Vastmanland','S',NULL,'Maelaren',NULL);
 INSERT INTO located VALUES ('Monaco','Monaco','MC',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Saint Peter Port','Guernsey','GBG',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Reykjavik','Iceland','IS',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Keflavik','Iceland','IS',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Hafnarfjoerdur','Iceland','IS',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Akureyri','Iceland','IS',NULL,NULL,'Norwegian Sea');
 INSERT INTO located VALUES ('Dublin','Ireland','IRL',NULL,NULL,'Irish Sea');
 INSERT INTO located VALUES ('Saint Helier','Jersey','GBJ',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Valletta','Malta','M',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Douglas','Man','GBM',NULL,NULL,'Irish Sea');
 INSERT INTO located VALUES ('Faro','Algarve','P',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Lisbon','Lisbon','P','Tajo',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Porto','Porto','P','Douro',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Vila Nova de Gaia','Porto','P','Douro',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Santarem','Santarem','P','Tajo',NULL,NULL);
 INSERT INTO located VALUES ('Setubal','Setubal','P',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Viana do Castelo','Viana do Castelo','P',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Ponta Delgada','Azores','P',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Funchal','Madeira','P',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Longyearbyen','Svalbard','SVAX',NULL,NULL,'Norwegian Sea');
 INSERT INTO located VALUES ('Reading','Berkshire','GB','Thames',NULL,NULL);
 INSERT INTO located VALUES ('Plymouth','Devon','GB',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Bournemouth','Dorset','GB',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Poole','Dorset','GB',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Brighton','East Sussex','GB',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Southend on Sea','Essex','GB','Thames',NULL,'North Sea');
 INSERT INTO located VALUES ('London','Greater London','GB','Thames',NULL,NULL);
 INSERT INTO located VALUES ('Southampton','Hampshire','GB',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Portsmouth','Hampshire','GB',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Havant','Hampshire','GB',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Fareham','Hampshire','GB',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Dover','Kent','GB',NULL,NULL,'The Channel');
 INSERT INTO located VALUES ('Oxford','Oxfordshire','GB','Thames',NULL,NULL);
 INSERT INTO located VALUES ('Inverness','Highland','GB',NULL,NULL,'North Sea');
 INSERT INTO located VALUES ('Dundee','Tayside','GB',NULL,NULL,'North Sea');
 INSERT INTO located VALUES ('Colwyn Bay','Aberconwy and Colwyn','GB',NULL,NULL,'Irish Sea');
 INSERT INTO located VALUES ('Cardiff','Cardiff','GB',NULL,NULL,'Irish Sea');
 INSERT INTO located VALUES ('Belfast','Northern Ireland','GB',NULL,NULL,'Irish Sea');
 INSERT INTO located VALUES ('Kirkwall','Orkneys','GB',NULL,NULL,'North Sea');
 INSERT INTO located VALUES ('Stornoway','Outer Hebrides','GB',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Lerwick','Shetland','GB',NULL,NULL,'North Sea');
 INSERT INTO located VALUES ('Wuhu','Anhui','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Maanshan','Anhui','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Anqing','Anhui','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Tongling','Anhui','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Lanzhou','Gansu','TJ','Hwangho',NULL,NULL);
 INSERT INTO located VALUES ('Haikou','Hainan','TJ',NULL,NULL,'South China Sea');
 INSERT INTO located VALUES ('Sanya','Hainan','TJ',NULL,NULL,'South China Sea');
 INSERT INTO located VALUES ('Zhengzhou','Henan','TJ','Hwangho',NULL,NULL);
 INSERT INTO located VALUES ('Luoyang','Henan','TJ','Hwangho',NULL,NULL);
 INSERT INTO located VALUES ('Kaifeng','Henan','TJ','Hwangho',NULL,NULL);
 INSERT INTO located VALUES ('Wuhan','Hubei','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Huangshi','Hubei','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Yichang','Hubei','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Shashi','Hubei','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Xianning','Hubei','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Shishou','Hubei','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Yueyang','Hunan','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Nanjing','Jiangsu','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Changzhou','Jiangsu','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Zhenjiang','Jiangsu','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Nantong','Jiangsu','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Yangzhou','Jiangsu','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Jiujiang','Jiangxi','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Dalian','Liaoning','TJ',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Yingkou','Liaoning','TJ',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Jinan','Shandong','TJ','Hwangho',NULL,NULL);
 INSERT INTO located VALUES ('Qingdao','Shandong','TJ',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Yantai','Shandong','TJ',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Weihai','Shandong','TJ',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Chongqing','Sichuan','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Luzhou','Sichuan','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Yibin','Sichuan','TJ','Jangtse',NULL,NULL);
 INSERT INTO located VALUES ('Baotou','Nei Monggol','TJ','Hwangho',NULL,NULL);
 INSERT INTO located VALUES ('Yinchuan','Ningxia Huizu','TJ','Hwangho',NULL,NULL);
 INSERT INTO located VALUES ('Khorramshahr','Khuzestan','IR','Karun',NULL,NULL);
 INSERT INTO located VALUES ('Khorramshahr','Khuzestan','IR','Karun',NULL,NULL);
 INSERT INTO located VALUES ('Hyderabad','Pakistan','PK','Indus',NULL,NULL);
 INSERT INTO located VALUES ('Karachi','Pakistan','PK',NULL,NULL,'Arabian Sea');
 INSERT INTO located VALUES ('Sukkur','Pakistan','PK','Indus',NULL,NULL);
 INSERT INTO located VALUES ('Khorugh','Badakhshoni Kuni','TAD','Pjandsh',NULL,NULL);
 INSERT INTO located VALUES ('Namangan','Namangan','UZB','Syrdarja',NULL,NULL);
 INSERT INTO located VALUES ('Tbilisi','Georgia','GE','Kura',NULL,NULL);
 INSERT INTO located VALUES ('Baku','Azerbaijan','AZ',NULL,'Caspian Sea',NULL);
 INSERT INTO located VALUES ('Manama','Bahrain','BRN',NULL,NULL,'Persian Gulf');
 INSERT INTO located VALUES ('Dhaka','Bangladesh','BD','Ganges',NULL,NULL);
 INSERT INTO located VALUES ('Pathein','Ayeyarwady','MYA','Irawaddy',NULL,NULL);
 INSERT INTO located VALUES ('Magway','Magway','MYA','Irawaddy',NULL,NULL);
 INSERT INTO located VALUES ('Mandalay','Mandalay','MYA','Irawaddy',NULL,NULL);
 INSERT INTO located VALUES ('Sagaing','Sagaing','MYA','Irawaddy',NULL,NULL);
 INSERT INTO located VALUES ('Myitkyina','Kachin','MYA','Irawaddy',NULL,NULL);
 INSERT INTO located VALUES ('Moulmein','Mon','MYA','Saluen',NULL,'Andaman Sea');
 INSERT INTO located VALUES ('Gauhati','Assam','IND','Brahmaputra',NULL,NULL);
 INSERT INTO located VALUES ('Patna','Bihar','IND','Ganges',NULL,NULL);
 INSERT INTO located VALUES ('Panaji','Goa','IND',NULL,NULL,'Arabian Sea');
 INSERT INTO located VALUES ('Jamnagar','Gujarat','IND',NULL,NULL,'Arabian Sea');
 INSERT INTO located VALUES ('Trivandrum','Kerala','IND',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Cochin','Kerala','IND',NULL,NULL,'Arabian Sea');
 INSERT INTO located VALUES ('Mumbai','Maharashtra','IND',NULL,NULL,'Arabian Sea');
 INSERT INTO located VALUES ('Madras','Tamil Nadu','IND',NULL,NULL,'Gulf of Bengal');
 INSERT INTO located VALUES ('Kanpur','Uttar Pradesh','IND','Ganges',NULL,NULL);
 INSERT INTO located VALUES ('Varanasi','Uttar Pradesh','IND','Ganges',NULL,NULL);
 INSERT INTO located VALUES ('Allahabad','Uttar Pradesh','IND','Ganges',NULL,NULL);
 INSERT INTO located VALUES ('Port Blair','Andaman and Nicobar Is.','IND',NULL,NULL,'Gulf of Bengal');
 INSERT INTO located VALUES ('Port Blair','Andaman and Nicobar Is.','IND',NULL,NULL,'Andaman Sea');
 INSERT INTO located VALUES ('Kavaratti','Lakshadweep Is.','IND',NULL,NULL,'Arabian Sea');
 INSERT INTO located VALUES ('Melaka','Melaka','MAL',NULL,NULL,'Malakka Strait');
 INSERT INTO located VALUES ('Penang','Pulau Pinang','MAL',NULL,NULL,'Malakka Strait');
 INSERT INTO located VALUES ('Vientiane','Laos','LAO','Mekong',NULL,NULL);
 INSERT INTO located VALUES ('Phnom Penh','Cambodia','K','Mekong',NULL,NULL);
 INSERT INTO located VALUES ('Can Tho','Vietnam','VN','Mekong',NULL,NULL);
 INSERT INTO located VALUES ('Long Xuyen','Vietnam','VN','Mekong',NULL,NULL);
 INSERT INTO located VALUES ('Atyrau','Atyrau','KAZ','Ural','Caspian Sea',NULL);
 INSERT INTO located VALUES ('Oral','Batys Qazaqstan','KAZ','Ural',NULL,NULL);
 INSERT INTO located VALUES ('Aqtau','Mangghystau','KAZ',NULL,'Caspian Sea',NULL);
 INSERT INTO located VALUES ('Pavlodar','Pavlodar','KAZ','Irtysch',NULL,NULL);
 INSERT INTO located VALUES ('Qostanay','Qostanay','KAZ','Tobol',NULL,NULL);
 INSERT INTO located VALUES ('Qyzylorda','Qyzylorda','KAZ','Syrdarja',NULL,NULL);
 INSERT INTO located VALUES ('Semey','Semey','KAZ','Irtysch',NULL,NULL);
 INSERT INTO located VALUES ('Petropavl','Soltustik Qazaqstan','KAZ','Ischim',NULL,NULL);
 INSERT INTO located VALUES ('Hamhung Hungnam','North Korea','NOK',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Chongjin','North Korea','NOK',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Sinuiju','North Korea','NOK',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Wonsan','North Korea','NOK',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Haeju','North Korea','NOK',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Anju','North Korea','NOK',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Songjin','North Korea','NOK',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Kusong','North Korea','NOK',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Sinpo','North Korea','NOK',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Kaesong','North Korea','NOK',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Flying Fish Cove','Christmas Island','XMAS',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('West Island','Cocos Islands','COCO',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Gaza','Gaza Strip','GAZA',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Haifa','Haifa','IL',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Tel Aviv','Tel Aviv','IL',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Marsa Matruh','Matruh','ET',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('El Tur','Sina al Janubiyah','ET',NULL,NULL,'Red Sea');
 INSERT INTO located VALUES ('El Arish','Sina ash Shamaliyah','ET',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Aswan','Aswan','ET','Nile',NULL,NULL);
 INSERT INTO located VALUES ('Asyut','Asyut','ET','Nile',NULL,NULL);
 INSERT INTO located VALUES ('Beni Suef','Beni Suef','ET','Nile',NULL,NULL);
 INSERT INTO located VALUES ('El Giza','El Giza','ET','Nile',NULL,NULL);
 INSERT INTO located VALUES ('El Minya','El Minya','ET','Nile',NULL,NULL);
 INSERT INTO located VALUES ('Qena','Qena','ET','Nile',NULL,NULL);
 INSERT INTO located VALUES ('El Uqsur','Qena','ET','Nile',NULL,NULL);
 INSERT INTO located VALUES ('Sohag','Sohag','ET','Nile',NULL,NULL);
 INSERT INTO located VALUES ('Bur Said','Bur Said (munic.)','ET',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Alexandria','El Iskandariya','ET',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Cairo','El Qahira','ET','Nile',NULL,NULL);
 INSERT INTO located VALUES ('Helwan','El Qahira','ET','Nile',NULL,NULL);
 INSERT INTO located VALUES ('El Suweiz','El Suweiz','ET',NULL,NULL,'Red Sea');
 INSERT INTO located VALUES ('Jakarta','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Semarang','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Surabaya','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Banda Aceh','Indonesia','RI',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Banda Aceh','Indonesia','RI',NULL,NULL,'Andaman Sea');
 INSERT INTO located VALUES ('Bengkulu','Indonesia','RI',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Bandar Lampung','Indonesia','RI',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Padang','Indonesia','RI',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Medan','Indonesia','RI',NULL,NULL,'Malakka Strait');
 INSERT INTO located VALUES ('Pontianak','Indonesia','RI',NULL,NULL,'South China Sea');
 INSERT INTO located VALUES ('Banjarmasin','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Samarinda','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Ujung Pandang','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Ambon','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Balikpapan','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Manado','Indonesia','RI',NULL,NULL,'Sulawesi Sea');
 INSERT INTO located VALUES ('Pekalongan','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Tegal','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Pematang Siantar','Indonesia','RI','Asahan',NULL,NULL);
 INSERT INTO located VALUES ('Probolinggo','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Pangkal Pinang','Indonesia','RI',NULL,NULL,'South China Sea');
 INSERT INTO located VALUES ('Tanjung Balai','Indonesia','RI',NULL,NULL,'Malakka Strait');
 INSERT INTO located VALUES ('Batam','Indonesia','RI',NULL,NULL,'South China Sea');
 INSERT INTO located VALUES ('Pare Pare','Indonesia','RI',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Dili','Timor-Leste','TL',NULL,NULL,'Sunda Sea');
 INSERT INTO located VALUES ('Port Moresby','Papua New Guinea','PNG',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Ar Ramadi','Al Anbar','IRQ','Euphrat',NULL,NULL);
 INSERT INTO located VALUES ('Al Hillah','Babil','IRQ','Euphrat',NULL,NULL);
 INSERT INTO located VALUES ('Baghdad','Baghdad','IRQ','Tigris',NULL,NULL);
 INSERT INTO located VALUES ('Al Basrah','Al Basrah','IRQ','Schatt al Arab',NULL,NULL);
 INSERT INTO located VALUES ('An Nasiriyah','Dhi Qar','IRQ','Euphrat',NULL,NULL);
 INSERT INTO located VALUES ('Al Amarah','Maysan','IRQ','Tigris',NULL,NULL);
 INSERT INTO located VALUES ('As Samawah','Al Muthanna','IRQ','Euphrat',NULL,NULL);
 INSERT INTO located VALUES ('An Najaf','An Najaf','IRQ','Euphrat',NULL,NULL);
 INSERT INTO located VALUES ('Mosul','Ninawa','IRQ','Tigris',NULL,NULL);
 INSERT INTO located VALUES ('Diwaniyah','Al Qadisiyah','IRQ','Euphrat',NULL,NULL);
 INSERT INTO located VALUES ('Samarra','Salah ad Din','IRQ','Tigris',NULL,NULL);
 INSERT INTO located VALUES ('Al Kut','Wasit','IRQ','Tigris',NULL,NULL);
 INSERT INTO located VALUES ('Kuwait','Kuwait','KWT',NULL,NULL,'Persian Gulf');
 INSERT INTO located VALUES ('Beirut','Lebanon','RL',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Hakodate','Hokkaido','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Hakodate','Hokkaido','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Aomori','Aomori','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Sendai','Miyagi','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Akita','Akita','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Chiba','Chiba','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Tokyo','Tokyo','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Yokohama','Kanagawa','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Kawasaki','Kanagawa','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Niigata','Niigata','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Toyama','Toyama','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Kanazawa','Ishikawa','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Shizuoka','Shizuoka','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Nagoya','Aichi','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Tsu','Mie','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Osaka','Osaka','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Kobe','Hyogo','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Wakayama','Wakayama','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Tottori','Tottori','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Matsue','Shimane','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Okayama','Okayama','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Hiroshima','Hiroshima','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Tokushima','Tokushima','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Takamatsu','Kagawa','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Matsuyama','Ehime','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Kochi','Kochi','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Fukuoka','Fukuoka','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Kita Kyushu','Fukuoka','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Nagasaki','Nagasaki','J',NULL,NULL,'East China Sea');
 INSERT INTO located VALUES ('Oita','Oita','J',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Miyazaki','Miyazaki','J',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Kagoshima','Kagoshima','J',NULL,NULL,'East China Sea');
 INSERT INTO located VALUES ('Naha','Okinawa','J',NULL,NULL,'East China Sea');
 INSERT INTO located VALUES ('Naha','Okinawa','J',NULL,NULL,'East China Sea');
 INSERT INTO located VALUES ('Pusan','South Korea','ROK',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Inchon','South Korea','ROK',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Ulsan','South Korea','ROK',NULL,NULL,'Sea of Japan');
 INSERT INTO located VALUES ('Mokpo','South Korea','ROK',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Kunsan','South Korea','ROK',NULL,NULL,'Yellow Sea');
 INSERT INTO located VALUES ('Yosu','South Korea','ROK',NULL,NULL,'East China Sea');
 INSERT INTO located VALUES ('Male','Maldives','MV',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Muscat','Oman','OM',NULL,NULL,'Gulf of Oman');
 INSERT INTO located VALUES ('Abu Dhabi','Abu Dhabi','UAE',NULL,NULL,'Persian Gulf');
 INSERT INTO located VALUES ('Dubai','Dubayy','UAE',NULL,NULL,'Persian Gulf');
 INSERT INTO located VALUES ('Sharjah','Ash Shariqah','UAE',NULL,NULL,'Persian Gulf');
 INSERT INTO located VALUES ('Aden','Yemen','YE',NULL,NULL,'Gulf of Aden');
 INSERT INTO located VALUES ('Manila','Philippines','RP',NULL,NULL,'South China Sea');
 INSERT INTO located VALUES ('Davao','Philippines','RP',NULL,NULL,'Sulawesi Sea');
 INSERT INTO located VALUES ('Cebu','Philippines','RP',NULL,NULL,'Sulawesi Sea');
 INSERT INTO located VALUES ('Zamboanga','Philippines','RP',NULL,NULL,'Sulawesi Sea');
 INSERT INTO located VALUES ('Cagayan de Oro','Philippines','RP',NULL,NULL,'Sulawesi Sea');
 INSERT INTO located VALUES ('Singapore','Singapore','SGP',NULL,NULL,'South China Sea');
 INSERT INTO located VALUES ('Colombo','Sri Lanka','CL',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Hualien','Taiwan','RC',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Taitung','Taiwan','RC',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Chilung','Taiwan','RC',NULL,NULL,'East China Sea');
 INSERT INTO located VALUES ('Hsinchu','Taiwan','RC',NULL,NULL,'East China Sea');
 INSERT INTO located VALUES ('Kaohsiung','Taiwan','RC',NULL,NULL,'South China Sea');
 INSERT INTO located VALUES ('Tainan','Taiwan','RC',NULL,NULL,'South China Sea');
 INSERT INTO located VALUES ('The Valley','Anguilla','AXA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Saint Johns','Antigua and Barbuda','AG',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Oranjestad','Aruba','ARU',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Nassau','Bahamas','BS',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Bridgetown','Barbados','BDS',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Campeche','Campeche','MEX',NULL,NULL,'Gulf of Mexico');
 INSERT INTO located VALUES ('Ciudad Juarez','Chihuahua','MEX','Rio Grande',NULL,NULL);
 INSERT INTO located VALUES ('Guadalajara','Jalisco','MEX','Rio Lerma',NULL,NULL);
 INSERT INTO located VALUES ('Tampico','Tamaulipas','MEX',NULL,NULL,'Gulf of Mexico');
 INSERT INTO located VALUES ('Reynosa','Tamaulipas','MEX','Rio Grande',NULL,NULL);
 INSERT INTO located VALUES ('Nuevo Laredo','Tamaulipas','MEX','Rio Grande',NULL,NULL);
 INSERT INTO located VALUES ('Ciudad Madero','Tamaulipas','MEX',NULL,NULL,'Gulf of Mexico');
 INSERT INTO located VALUES ('Coatzacoalcos','Veracruz','MEX',NULL,NULL,'Gulf of Mexico');
 INSERT INTO located VALUES ('Veracruz Llave','Veracruz','MEX',NULL,NULL,'Gulf of Mexico');
 INSERT INTO located VALUES ('Hamilton','Bermuda','BERM',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Road Town','British Virgin Islands','BVIR',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Edmonton','Alberta','CDN','Saskatchewan River',NULL,NULL);
 INSERT INTO located VALUES ('Vancouver','British Columbia','CDN',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Victoria','British Columbia','CDN',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Saint Johns','Newfoundland','CDN',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Yellowknife','Northwest Territories','CDN',NULL,'Great Slave Lake',NULL);
 INSERT INTO located VALUES ('Halifax','Nova Scotia','CDN',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Hamilton','Ontario','CDN',NULL,'Lake Ontario',NULL);
 INSERT INTO located VALUES ('Toronto','Ontario','CDN',NULL,'Lake Ontario',NULL);
 INSERT INTO located VALUES ('Windsor','Ontario','CDN','Detroit River',NULL,NULL);
 INSERT INTO located VALUES ('Oshawa','Ontario','CDN',NULL,'Lake Ontario',NULL);
 INSERT INTO located VALUES ('Saint Catharines','Ontario','CDN',NULL,'Lake Ontario',NULL);
 INSERT INTO located VALUES ('Thunder Bay','Ontario','CDN',NULL,'Lake Superior',NULL);
 INSERT INTO located VALUES ('Charlottetown','Prince Edward Island','CDN',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Montreal','Quebec','CDN','Saint Lawrence River',NULL,NULL);
 INSERT INTO located VALUES ('Quebec','Quebec','CDN','Saint Lawrence River',NULL,NULL);
 INSERT INTO located VALUES ('Saskatoon','Saskatchewan','CDN','Saskatchewan River',NULL,NULL);
 INSERT INTO located VALUES ('Whitehorse','Yukon Territory','CDN','Yukon River',NULL,NULL);
 INSERT INTO located VALUES ('Huntsville','Alabama','USA','Tennessee',NULL,NULL);
 INSERT INTO located VALUES ('Little Rock','Arkansas','USA','Arkansas',NULL,NULL);
 INSERT INTO located VALUES ('Los Angeles','California','USA',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('San Diego','California','USA',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('San Francisco','California','USA',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Bridgeport','Connecticut','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Hartford','Connecticut','USA','Connecticut River',NULL,NULL);
 INSERT INTO located VALUES ('New Haven','Connecticut','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Stamford','Connecticut','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Jacksonville','Florida','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Miami','Florida','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Tampa','Florida','USA',NULL,NULL,'Gulf of Mexico');
 INSERT INTO located VALUES ('St. Petersburg','Florida','USA',NULL,NULL,'Gulf of Mexico');
 INSERT INTO located VALUES ('Savannah','Georgia','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Honolulu','Hawaii','USA',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Chicago','Illinois','USA',NULL,'Lake Michigan',NULL);
 INSERT INTO located VALUES ('Evansville','Indiana','USA','Ohio River',NULL,NULL);
 INSERT INTO located VALUES ('Gary','Indiana','USA',NULL,'Lake Michigan',NULL);
 INSERT INTO located VALUES ('Wichita','Kansas','USA','Arkansas',NULL,NULL);
 INSERT INTO located VALUES ('Kansas City','Kansas','USA','Missouri',NULL,NULL);
 INSERT INTO located VALUES ('Louisville','Kentucky','USA','Ohio River',NULL,NULL);
 INSERT INTO located VALUES ('New Orleans','Louisiana','USA','Mississippi',NULL,NULL);
 INSERT INTO located VALUES ('Baton Rouge','Louisiana','USA','Mississippi',NULL,NULL);
 INSERT INTO located VALUES ('Boston','Massachusetts','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Springfield','Massachusetts','USA','Connecticut River',NULL,NULL);
 INSERT INTO located VALUES ('Detroit','Michigan','USA','Detroit River',NULL,NULL);
 INSERT INTO located VALUES ('Minneapolis','Minnesota','USA','Mississippi',NULL,NULL);
 INSERT INTO located VALUES ('St. Paul','Minnesota','USA','Mississippi',NULL,NULL);
 INSERT INTO located VALUES ('Kansas City','Missouri','USA','Missouri',NULL,NULL);
 INSERT INTO located VALUES ('St. Louis','Missouri','USA','Mississippi',NULL,NULL);
 INSERT INTO located VALUES ('St. Louis','Missouri','USA','Missouri',NULL,NULL);
 INSERT INTO located VALUES ('Independence','Missouri','USA','Missouri',NULL,NULL);
 INSERT INTO located VALUES ('Jefferson City','Missouri','USA','Missouri',NULL,NULL);
 INSERT INTO located VALUES ('Omaha','Nebraska','USA','Missouri',NULL,NULL);
 INSERT INTO located VALUES ('Reno','Nevada','USA','Truckee River',NULL,NULL);
 INSERT INTO located VALUES ('Concord','New Hampshire','USA','Merrimack River',NULL,NULL);
 INSERT INTO located VALUES ('Jersey City','New Jersey','USA','Hudson River',NULL,NULL);
 INSERT INTO located VALUES ('Albuquerque','New Mexico','USA','Rio Grande',NULL,NULL);
 INSERT INTO located VALUES ('New York','New York','USA','Hudson River',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Buffalo','New York','USA',NULL,'Lake Erie',NULL);
 INSERT INTO located VALUES ('Rochester','New York','USA',NULL,'Lake Ontario',NULL);
 INSERT INTO located VALUES ('Yonkers','New York','USA','Hudson River',NULL,NULL);
 INSERT INTO located VALUES ('Albany','New York','USA','Hudson River',NULL,NULL);
 INSERT INTO located VALUES ('Bismarck','North Dakota','USA','Missouri','Lake Oahe',NULL);
 INSERT INTO located VALUES ('Cleveland','Ohio','USA',NULL,'Lake Erie',NULL);
 INSERT INTO located VALUES ('Cincinnati','Ohio','USA','Ohio River',NULL,NULL);
 INSERT INTO located VALUES ('Toledo','Ohio','USA',NULL,'Lake Erie',NULL);
 INSERT INTO located VALUES ('Tulsa','Oklahoma','USA','Arkansas',NULL,NULL);
 INSERT INTO located VALUES ('Portland','Oregon','USA','Columbia River',NULL,NULL);
 INSERT INTO located VALUES ('Pittsburgh','Pennsylvania','USA','Ohio River',NULL,NULL);
 INSERT INTO located VALUES ('Erie','Pennsylvania','USA',NULL,'Lake Erie',NULL);
 INSERT INTO located VALUES ('Providence','Rhode Island','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Pierre','South Dakota','USA','Missouri','Lake Oahe',NULL);
 INSERT INTO located VALUES ('Memphis','Tennessee','USA','Mississippi',NULL,NULL);
 INSERT INTO located VALUES ('Knoxville','Tennessee','USA','Tennessee',NULL,NULL);
 INSERT INTO located VALUES ('Chattanooga','Tennessee','USA','Tennessee',NULL,NULL);
 INSERT INTO located VALUES ('El Paso','Texas','USA','Rio Grande',NULL,NULL);
 INSERT INTO located VALUES ('Corpus Christi','Texas','USA',NULL,NULL,'Gulf of Mexico');
 INSERT INTO located VALUES ('Salt Lake City','Utah','USA',NULL,'Great Salt Lake',NULL);
 INSERT INTO located VALUES ('Norfolk','Virginia','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Chesapeake','Virginia','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Newport News','Virginia','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Portsmouth','Virginia','USA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Milwaukee','Wisconsin','USA',NULL,'Lake Michigan',NULL);
 INSERT INTO located VALUES ('George Town','Cayman Islands','CAYM',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Puntarenas','Puntarenas','CR',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Limon','Limon','CR',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Managua','Nicaragua','NIC',NULL,'Lake Managua',NULL);
 INSERT INTO located VALUES ('Granada','Nicaragua','NIC',NULL,'Lake Nicaragua',NULL);
 INSERT INTO located VALUES ('Panama City','Panama','PA',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Havana','Ciudad de la Habana','C',NULL,NULL,'Gulf of Mexico');
 INSERT INTO located VALUES ('Roseau','Dominica','WD',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Santo Domingo','Dominican Republic','DOM',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Port-au-Prince','Haiti','RH',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('La Ceiba','Atlantida','HCA',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Tela','Atlantida','HCA',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Trujillo','Colon','HCA',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Puerto Cortes','Cortes','HCA',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Puerto Lempira','Gracias a Dios','HCA',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Nuuk','Greenland','GROX',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Saint Georges','Grenada','WG',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Basse-Terre','Guadeloupe','GUAD',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Kingston','Jamaica','JA',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Fort-de-France','Martinique','MART',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Plymouth','Montserrat','MNTS',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Willemstad','Netherlands Antilles','NA',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Marigot','Saint Martin','SMAR',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Leticia','Amazonas','CO','Amazonas',NULL,NULL);
 INSERT INTO located VALUES ('Barranquilla','Atlantico','CO','Rio Magdalena',NULL,NULL);
 INSERT INTO located VALUES ('Puerto Inirida','Guainia','CO','Orinoco',NULL,NULL);
 INSERT INTO located VALUES ('Neiva','Huila','CO','Rio Magdalena',NULL,NULL);
 INSERT INTO located VALUES ('Barrancabermeja','Santander del Sur','CO','Rio Magdalena',NULL,NULL);
 INSERT INTO located VALUES ('Puerto Carreno','Vichada','CO','Orinoco',NULL,NULL);
 INSERT INTO located VALUES ('San Juan','Puerto Rico','PR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Basseterre','Saint Kitts and Nevis','KN',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Castries','Saint Lucia','WL',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Saint-Pierre','Saint Pierre and Miquelon','SPMI',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Kingstown','Saint Vincent and the Grenadines','WV',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Port-of-Spain','Trinidad and Tobago','TT',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Grand Turk','Turks and Caicos Islands','TUCA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Charlotte Amalie','Virgin Islands','VIRG',NULL,NULL,'Caribbean Sea');
 INSERT INTO located VALUES ('Pago Pago','American Samoa','AMSA',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Newcastle','New South Wales','AUS',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Sydney','New South Wales','AUS',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Wollongong','New South Wales','AUS',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Sunshine Coast','New South Wales','AUS',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Darwin','Northern Territory','AUS',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Brisbane','Queensland','AUS',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Gold Coast','Queensland','AUS',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Townsville','Queensland','AUS',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Adelaide','South Australia','AUS',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Hobart','Tasmania','AUS',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Melbourne','Victoria','AUS',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Geelong','Victoria','AUS',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Perth','Western Australia','AUS',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Albany','Western Australia','AUS',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Canberra','Australia Capital Territory','AUS','Murrumbidgee River','Lake Burley Griffin',NULL);
 INSERT INTO located VALUES ('Avarua','Cook Islands','COOK',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Suva','Fiji','FJI',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Papeete','French Polynesia','FPOL',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Agana','Guam','GUAM',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Dededo','Guam','GUAM',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Tarawa','Kiribati','KIR',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Majuro','Marshall Islands','MH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Kolonia','Micronesia','FSM',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Palikir','Micronesia','FSM',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Yaren','Nauru','NAU',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Noumea','New Caledonia','NCA',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Wellington','New Zealand','NZ',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Auckland','New Zealand','NZ',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Christchurch','New Zealand','NZ',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Alofi','Niue','NIUE',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Kingston','Norfolk Island','NORF',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Saipan','Northern Mariana Islands','NMIS',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Koror','Palau','PAL',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Melekeok','Palau','PAL',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Adamstown','Pitcairn Islands','PITC',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Honiara','Solomon Islands','SLB',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Nukualofa','Tonga','TO',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Funafuti','Tuvalu','TUV',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Port-Vila','Vanuatu','VU',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Mata-Utu','Wallis and Futuna','WAFU',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Apia','Samoa','WS',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 ('Bahia 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',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Corrientes','Corrientes','RA','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Parana','Entre Rios','RA','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Concordia','Entre Rios','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 ('Rio 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 ('Buenos Aires','Distrito Federal','RA','Parana',NULL,NULL);
 INSERT INTO located VALUES ('Maceio','Alagoas','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Macapa','Amapa','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 ('Ilheus','Bahia','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Juazeiro','Bahia','BR','Rio Sao Francisco',NULL,NULL);
 INSERT INTO located VALUES ('Fortaleza','Ceara','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Vila Velha','Espirito Santo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Vitoria','Espirito Santo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Sao Luis','Maranhao','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Belem','Para','BR','Tocantins',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Joao Pessoa','Paraiba','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Paranagua','Parana','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Recife','Pernambuco','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Rio de Janeiro','Rio de Janeiro','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Niteroi','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 ('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','Rondonia','BR','Rio Madeira',NULL,NULL);
 INSERT INTO located VALUES ('Florianopolis','Santa Catarina','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Itajai','Santa Catarina','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Sao Paulo','Sao Paulo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Santos','Sao Paulo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Sao Vicente','Sao Paulo','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Aracaju','Sergipe','BR',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Valparaiso','Chile','RCH',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Asuncion','Paraguay','PY','Paraguay',NULL,NULL);
 INSERT INTO located VALUES ('Montevideo','Uruguay','ROU',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Cuzco','Cuzco','PE','Amazonas',NULL,NULL);
 INSERT INTO located VALUES ('Iquitos','Loreto','PE','Amazonas',NULL,NULL);
 INSERT INTO located VALUES ('Pucallpa','Ucayali','PE','Amazonas',NULL,NULL);
 INSERT INTO located VALUES ('Georgetown','Guyana','GUY',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Paramaribo','Suriname','SME',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Ciudad Bolivar','Bolivar','YV','Orinoco',NULL,NULL);
 INSERT INTO located VALUES ('Ciudad Guayana','Bolivar','YV','Orinoco',NULL,NULL);
 INSERT INTO located VALUES ('Maracaibo','Zulia','YV',NULL,'Lake Maracaibo','Caribbean Sea');
 INSERT INTO located VALUES ('Guayaquil','Ecuador','EC',NULL,NULL,'Pacific Ocean');
 INSERT INTO located VALUES ('Stanley','Falkland Islands','FALK',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Algier','Algeria','DZ',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Annaba','Algeria','DZ',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Skikda','Algeria','DZ',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Oran','Algeria','DZ',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Bejaia','Algeria','DZ',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Mostaganem','Algeria','DZ',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Tripoli','Libya','LAR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Bengasi','Libya','LAR',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Bamako','Mali','RMM','Niger',NULL,NULL);
 INSERT INTO located VALUES ('Rabat','Morocco','MA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Agadir','Morocco','MA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Kenitra','Morocco','MA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Safi','Morocco','MA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Tanger','Morocco','MA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Casablanca','Morocco','MA',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Tetouan','Morocco','MA',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Niamey','Niger','RN','Niger',NULL,NULL);
 INSERT INTO located VALUES ('Tunis','Tunisia','TN',NULL,NULL,'Mediterranean Sea');
 INSERT INTO located VALUES ('Luanda','Luanda','ANG',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Brazzaville','Congo','RCB','Zaire',NULL,NULL);
 INSERT INTO located VALUES ('Kikwit','Bandundu','ZRE','Cuilo',NULL,NULL);
 INSERT INTO located VALUES ('Bandundu','Bandundu','ZRE','Kwa',NULL,NULL);
 INSERT INTO located VALUES ('Bandundu','Bandundu','ZRE','Kasai',NULL,NULL);
 INSERT INTO located VALUES ('Matadi','Bas Zaire','ZRE','Zaire',NULL,NULL);
 INSERT INTO located VALUES ('Boma','Bas Zaire','ZRE','Zaire',NULL,NULL);
 INSERT INTO located VALUES ('Mbandaka','Equateur','ZRE','Zaire',NULL,NULL);
 INSERT INTO located VALUES ('Kananga','Kasai Occidental','ZRE','Lulua',NULL,NULL);
 INSERT INTO located VALUES ('Tshikapa','Kasai Occidental','ZRE','Kasai',NULL,NULL);
 INSERT INTO located VALUES ('Bukavu','Kivu','ZRE',NULL,'Lake Kivu',NULL);
 INSERT INTO located VALUES ('Uvira','Kivu','ZRE',NULL,'Lake Tanganjika',NULL);
 INSERT INTO located VALUES ('Goma','Kivu','ZRE',NULL,'Lake Kivu',NULL);
 INSERT INTO located VALUES ('Kalemie','Shaba/Katanga','ZRE','Lukuga','Lake Tanganjika',NULL);
 INSERT INTO located VALUES ('Kinshasa','Kinshasa','ZRE','Zaire',NULL,NULL);
 INSERT INTO located VALUES ('Lagos','Nigeria','WAN',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Onitsha','Nigeria','WAN','Niger',NULL,NULL);
 INSERT INTO located VALUES ('Lome','Togo','RT',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Abidjan','Cote dIvoire','CI',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Accra','Ghana','GH',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Bujumbura','Burundi','BI',NULL,'Lake Tanganjika',NULL);
 INSERT INTO located VALUES ('Dar es Salaam','Daressalam','EAT',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Garoua','Nord','CAM','Benue',NULL,NULL);
 INSERT INTO located VALUES ('Bangui','Central African Republic','RCA','Ubangi',NULL,NULL);
 INSERT INTO located VALUES ('NDjamena','Chad','TCH','Schari',NULL,NULL);
 INSERT INTO located VALUES ('Malabo','Equatorial Guinea','GQ',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Libreville','Gabon','G',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Praia','Cape Verde','CV',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Malakal','Aali an Nil','SUD','White Nile',NULL,NULL);
 INSERT INTO located VALUES ('Juba','al Istiwaiyah','SUD','Bahr el-Djebel/Albert-Nil',NULL,NULL);
 INSERT INTO located VALUES ('Khartoum','al Khartum','SUD','Nile',NULL,NULL);
 INSERT INTO located VALUES ('Khartoum','al Khartum','SUD','Blue Nile',NULL,NULL);
 INSERT INTO located VALUES ('Omdurman','al Khartum','SUD','Nile',NULL,NULL);
 INSERT INTO located VALUES ('Omdurman','al Khartum','SUD','Blue Nile',NULL,NULL);
 INSERT INTO located VALUES ('Khartoum North','al Khartum','SUD','Nile',NULL,NULL);
 INSERT INTO located VALUES ('ad Damir','ash Shamaliyah','SUD','Nile',NULL,NULL);
 INSERT INTO located VALUES ('Port Sudan','ash Sharqiyah','SUD',NULL,NULL,'Red Sea');
 INSERT INTO located VALUES ('Wad Madani','Nil al Asraq','SUD','Blue Nile',NULL,NULL);
 INSERT INTO located VALUES ('Moroni','Comoros','COM',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Conakry','Guinea','RG',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Monrovia','Liberia','LB',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Djibouti','Djibouti','DJI',NULL,NULL,'Gulf of Aden');
 INSERT INTO located VALUES ('Mogadishu','Somalia','SP',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Mombasa','Coast','EAK',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Banjul','Gambia','WAG','Gambia',NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Dakar','Dakar','SN',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Saint Louis','Saint Louis','SN','Senegal',NULL,NULL);
 INSERT INTO located VALUES ('Bissau','Guinea-Bissau','GNB',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Freetown','Sierra Leone','WAL',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Kampala','Uganda','EAU',NULL,'Lake Victoria',NULL);
 INSERT INTO located VALUES ('Xai Xai','Gaza','MOC','Limpopo',NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Maputo','Maputo (munic.)','MOC',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Port Louis','Mauritius','MS',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Mamoutzou','Mayotte','MAYO',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Saint-Denis','Reunion','REUN',NULL,NULL,'Indian Ocean');
 INSERT INTO located VALUES ('Jamestown','Saint Helena','HELX',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Sao Tome','Sao Tome and Principe','STP',NULL,NULL,'Atlantic Ocean');
 INSERT INTO located VALUES ('Victoria','Seychelles','SY',NULL,NULL,'Indian Ocean');
 INSERT INTO locatedOn VALUES ('Iraklion','Kriti','GR','Kreta');
 INSERT INTO locatedOn VALUES ('Mytilini','Voreion Aiyaion','GR','Lesbos');
 INSERT INTO locatedOn VALUES ('Ajaccio','Corse','F','Corse');
 INSERT INTO locatedOn VALUES ('Palma de Mallorca','Balearic Islands','E','Mallorca');
 INSERT INTO locatedOn VALUES ('Santa Cruz de Tenerife','Canary Islands','E','Teneriffa');
 INSERT INTO locatedOn VALUES ('Las Palmas de Gran Canaria','Canary Islands','E','Gran Canaria');
 INSERT INTO locatedOn VALUES ('La Laguna','Canary Islands','E','Teneriffa');
 INSERT INTO locatedOn VALUES ('Palermo','Sicilia','I','Sicilia');
 INSERT INTO locatedOn VALUES ('Messina','Sicilia','I','Sicilia');
 INSERT INTO locatedOn VALUES ('Catania','Sicilia','I','Sicilia');
 INSERT INTO locatedOn VALUES ('Siracusa','Sicilia','I','Sicilia');
 INSERT INTO locatedOn VALUES ('Cagliari','Sardegna','I','Sardegna');
 INSERT INTO locatedOn VALUES ('Sassari','Sardegna','I','Sardegna');
 INSERT INTO locatedOn VALUES ('Yuzhno Sakhalinsk','Sakhalinskaya oblast','R','Sachalin');
 INSERT INTO locatedOn VALUES ('Copenhagen','Denmark','DK','Seeland');
 INSERT INTO locatedOn VALUES ('Odense','Denmark','DK','Fuenen');
 INSERT INTO locatedOn VALUES ('Torshavn','Faroe Islands','FARX','Streymoy');
 INSERT INTO locatedOn VALUES ('Saint Peter Port','Guernsey','GBG','Guernsey');
 INSERT INTO locatedOn VALUES ('Reykjavik','Iceland','IS','Iceland');
 INSERT INTO locatedOn VALUES ('Keflavik','Iceland','IS','Iceland');
 INSERT INTO locatedOn VALUES ('Hafnarfjoerdur','Iceland','IS','Iceland');
 INSERT INTO locatedOn VALUES ('Akureyri','Iceland','IS','Iceland');
 INSERT INTO locatedOn VALUES ('Dublin','Ireland','IRL','Ireland');
 INSERT INTO locatedOn VALUES ('Saint Helier','Jersey','GBJ','Jersey');
 INSERT INTO locatedOn VALUES ('Valletta','Malta','M','Malta');
 INSERT INTO locatedOn VALUES ('Victoria','Malta','M','Gozo');
 INSERT INTO locatedOn VALUES ('Douglas','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','SVAX','Svalbard');
 INSERT INTO locatedOn VALUES ('Bristol','Avon','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bedford','Bedfordshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Luton','Bedfordshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Reading','Berkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Wokingham','Berkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Newbury','Berkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Windsor','Berkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Slough','Berkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bracknell','Berkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Aylesbury','Buckinghamshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Milton Keynes','Buckinghamshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Wycombe','Buckinghamshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Cambridge','Cambridgeshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Peterborough','Cambridgeshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Huntingdon','Cambridgeshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Chester','Cheshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Warrington','Cheshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Macclesfield','Cheshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Crewe','Cheshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Middlesbrough','Cleveland','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Stockton on Tees','Cleveland','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Truro','Cornwall','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Carlisle','Cumbria','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Derby','Derbyshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Sutton in Ashfield','Derbyshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Chesterfield','Derbyshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Matlock','Derbyshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Plymouth','Devon','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Exeter','Devon','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bournemouth','Dorset','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Poole','Dorset','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Dorchester','Dorset','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Darlington','Durham','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Durham','Durham','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Brighton','East Sussex','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Lewes','East Sussex','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Chelmsford','Essex','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Southend on Sea','Essex','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Basildon','Essex','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Colchester','Essex','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Braintree','Essex','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Epping Forest','Essex','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Cheltenham','Gloucestershire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Stroud','Gloucestershire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Gloucester','Gloucestershire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('London','Greater London','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Manchester','Greater Manchester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Wigan','Greater Manchester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Stockport','Greater Manchester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bolton','Greater Manchester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Salford','Greater Manchester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Tameside','Greater Manchester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Oldham','Greater Manchester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Trafford','Greater Manchester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Rochdale','Greater Manchester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bury','Greater Manchester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Winchester','Hampshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Southampton','Hampshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Portsmouth','Hampshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Basingstoke','Hampshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Havant','Hampshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Eastleigh','Hampshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Fareham','Hampshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Worcester','Hereford and Worcester','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Saint Albans','Hertfordshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Hertford','Hertfordshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Kingston upon Hull','Humberside','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Beverley','Humberside','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Hull','Humberside','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Maidstone','Kent','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Rochester upon Medway','Kent','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Canterbury','Kent','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Swale','Kent','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Sevenoaks','Kent','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Dover','Kent','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Tonbridge','Kent','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Tunbridge Wells','Kent','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Preston','Lancashire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Blackpool','Lancashire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Blackburn','Lancashire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Lancaster','Lancashire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Leichester','Leicestershire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Lincoln','Lincolnshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Liverpool','Merseyside','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Wiral','Merseyside','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Sefton','Merseyside','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Saint Helens','Merseyside','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Knowsley','Merseyside','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Norwich','Norfolk','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Kings Lynn','Norfolk','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Northampton','Northamptonshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Harrogate','North Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Scarborough','North Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('York','North Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Northallerton','North Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Nottingham','Nottinghamshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Newark on Trent','Nottinghamshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Mansfield','Nottinghamshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Oxford','Oxfordshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Shrewsbury','Shropshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Taunton','Somerset','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Barnsley','South Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Sheffield','South Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Doncaster','South Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Rotherham','South Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Stafford','Staffordshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Stoke on Trent','Staffordshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Newcastle under Lyme','Staffordshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Ipswich','Suffolk','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Guildford','Surrey','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Reigate','Surrey','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Elmbridge','Surrey','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Kingston','Surrey','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Sunderland','Tyne and Wear','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Newcastle upon Tyne','Tyne and Wear','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Gateshead','Tyne and Wear','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Warwick','Warwickshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Nuneaton','Warwickshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Stratford on Avon','Warwickshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Birmingham','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Dudley','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Coventry','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Walsall','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 ('West Bromwich','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Sandwell','West Midlands','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Chichester','West Sussex','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Horsham','West Sussex','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Wakefield','West Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Leeds','West Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bradford','West Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Kirklees','West Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Huddersfield','West Yorkshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Salisbury','Wiltshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Trowbridge','Wiltshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Newtown St. Boswells','Borders','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Stirling','Central','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Dumfries','Dumfries and Galloway','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Glenrothes','Fife','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Aberdeen','Grampian','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Inverness','Highland','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Edinburgh','Lothian','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Glasgow','Strathclyde','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Renfrew','Strathclyde','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Dundee','Tayside','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Colwyn Bay','Aberconwy and Colwyn','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Llangefni','Anglesey','GB','Anglesey');
 INSERT INTO locatedOn VALUES ('Ebbw Vale','Blaenau Gwent','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Bridgend','Bridgend','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Ystrad Fawr','Caerphilly','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Cardiff','Cardiff','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Carmarthen','Carmarthenshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Aberystwyth','Ceredigion','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Ruthin','Denbighshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Mold','Flintshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Caernarfon','Gwynedd','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Merthyr Tydfil','Merthyr Tydfil','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Cwmbran','Monmouthshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Port Talbot','Neath and Port Talbot','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Newport','Newport','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Haverfordwest','Pembrokeshire','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Llandrindod Wells','Powys','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Rhondda','Rhondda Cynon Taff','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Swansea','Swansea','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Pontypool','Torfaen','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Rhymney Valley','Vale of Glamorgan','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Barry','Vale of Glamorgan','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Wrexham','Wrexham','GB','Great Britain');
 INSERT INTO locatedOn VALUES ('Belfast','Northern Ireland','GB','Ireland');
 INSERT INTO locatedOn VALUES ('Kirkwall','Orkneys','GB','Orkney Mainland');
 INSERT INTO locatedOn VALUES ('Stornoway','Outer Hebrides','GB','Lewis and Harris');
 INSERT INTO locatedOn VALUES ('Lerwick','Shetland','GB','Shetland Mainland');
 INSERT INTO locatedOn VALUES ('Haikou','Hainan','TJ','Hainan');
 INSERT INTO locatedOn VALUES ('Sanya','Hainan','TJ','Hainan');
 INSERT INTO locatedOn VALUES ('Manama','Bahrain','BRN','Bahrain');
 INSERT INTO locatedOn VALUES ('Port Blair','Andaman and Nicobar Is.','IND','South Andaman Island');
 INSERT INTO locatedOn VALUES ('Kavaratti','Lakshadweep Is.','IND','Kavaratti');
 INSERT INTO locatedOn VALUES ('Bandar Seri Begawan','Brunei','BRU','Borneo');
 INSERT INTO locatedOn VALUES ('Kota Kinabalu','Sabah','MAL','Borneo');
 INSERT INTO locatedOn VALUES ('Tawai','Sabah','MAL','Borneo');
 INSERT INTO locatedOn VALUES ('Sandakan','Sabah','MAL','Borneo');
 INSERT INTO locatedOn VALUES ('Kuching','Sarawak','MAL','Borneo');
 INSERT INTO locatedOn VALUES ('Sibu','Sarawak','MAL','Borneo');
 INSERT INTO locatedOn VALUES ('Flying Fish Cove','Christmas Island','XMAS','Christmas Island');
 INSERT INTO locatedOn VALUES ('West Island','Cocos Islands','COCO','Pulau Panjang');
 INSERT INTO locatedOn VALUES ('Nicosia','Cyprus','CY','Cyprus');
 INSERT INTO locatedOn VALUES ('Jakarta','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Bandung','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Semarang','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Surabaya','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Yogyakarta','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Banda Aceh','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Bengkulu','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Jambi','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Bandar Lampung','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Padang','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Palembang','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Medan','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Pontianak','Indonesia','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Banjarmasin','Indonesia','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Palangkaraya','Indonesia','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Samarinda','Indonesia','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Ujung Pandang','Indonesia','RI','Sulawesi');
 INSERT INTO locatedOn VALUES ('Ambon','Indonesia','RI','Ambon');
 INSERT INTO locatedOn VALUES ('Malang','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Surakarta','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Pekan Baru','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Balikpapan','Indonesia','RI','Borneo');
 INSERT INTO locatedOn VALUES ('Manado','Indonesia','RI','Sulawesi');
 INSERT INTO locatedOn VALUES ('Bogor','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Cirebon','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Kediri','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Pekalongan','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Tegal','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Pematang Siantar','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Binjai','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Probolinggo','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Madiun','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Pasuruan','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Magelang','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Sukabumi','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Gorontalo','Indonesia','RI','Sulawesi');
 INSERT INTO locatedOn VALUES ('Blitar','Indonesia','RI','Java');
 INSERT INTO locatedOn VALUES ('Tebing Tinggi','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Pangkal Pinang','Indonesia','RI','Bangka');
 INSERT INTO locatedOn VALUES ('Tanjung Balai','Indonesia','RI','Sumatra');
 INSERT INTO locatedOn VALUES ('Batam','Indonesia','RI','Batam');
 INSERT INTO locatedOn VALUES ('Pare Pare','Indonesia','RI','Sulawesi');
 INSERT INTO locatedOn VALUES ('Dili','Timor-Leste','TL','Timor');
 INSERT INTO locatedOn VALUES ('Port Moresby','Papua New Guinea','PNG','New Guinea');
 INSERT INTO locatedOn VALUES ('Sapporo','Hokkaido','J','Hokkaido');
 INSERT INTO locatedOn VALUES ('Hakodate','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 ('Utsonomiya','Tochigi','J','Honshu');
 INSERT INTO locatedOn VALUES ('Maebashi','Gumma','J','Honshu');
 INSERT INTO locatedOn VALUES ('Urawa','Saitama','J','Honshu');
 INSERT INTO locatedOn VALUES ('Chiba','Chiba','J','Honshu');
 INSERT INTO locatedOn VALUES ('Tokyo','Tokyo','J','Honshu');
 INSERT INTO locatedOn VALUES ('Yokohama','Kanagawa','J','Honshu');
 INSERT INTO locatedOn VALUES ('Kawasaki','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 ('Nagoya','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 ('Kobe','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 ('Hiroshima','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 ('Kita Kyushu','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 ('Male','Maldives','MV','Male');
 INSERT INTO locatedOn VALUES ('Manila','Philippines','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Quezon','Philippines','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Kalookan','Philippines','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Davao','Philippines','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Cebu','Philippines','RP','Cebu');
 INSERT INTO locatedOn VALUES ('Zamboanga','Philippines','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Makati','Philippines','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Pasig','Philippines','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Cagayan de Oro','Philippines','RP','Mindanao');
 INSERT INTO locatedOn VALUES ('Pasay','Philippines','RP','Luzon');
 INSERT INTO locatedOn VALUES ('Singapore','Singapore','SGP','Singapore');
 INSERT INTO locatedOn VALUES ('Colombo','Sri Lanka','CL','Sri Lanka');
 INSERT INTO locatedOn VALUES ('Changhua','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Hualien','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Fengshan','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Pingtung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Fengyuan','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Panchiao','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Chungho','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Sanchuung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Hsinchuang','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Yungho','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Hsintien','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Taitung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Taoyuan','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Chungli','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Chiai','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Chilung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Hsinchu','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Kaohsiung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Taichung','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Tainan','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('Taipei','Taiwan','RC','Taiwan');
 INSERT INTO locatedOn VALUES ('The Valley','Anguilla','AXA','Anguilla');
 INSERT INTO locatedOn VALUES ('Saint Johns','Antigua and Barbuda','AG','Antigua');
 INSERT INTO locatedOn VALUES ('Oranjestad','Aruba','ARU','Aruba');
 INSERT INTO locatedOn VALUES ('Nassau','Bahamas','BS','New Providence');
 INSERT INTO locatedOn VALUES ('Bridgetown','Barbados','BDS','Barbados');
 INSERT INTO locatedOn VALUES ('Hamilton','Bermuda','BERM','Grand Bermuda');
 INSERT INTO locatedOn VALUES ('Road Town','British Virgin Islands','BVIR','Tortola');
 INSERT INTO locatedOn VALUES ('Victoria','British Columbia','CDN','Vancouver Island');
 INSERT INTO locatedOn VALUES ('Saint Johns','Newfoundland','CDN','Newfoundland');
 INSERT INTO locatedOn VALUES ('George Town','Cayman Islands','CAYM','Grand Cayman');
 INSERT INTO locatedOn VALUES ('Camaguey','Camaguey','C','Cuba');
 INSERT INTO locatedOn VALUES ('Ciego de Avila','Ciego de Avila','C','Cuba');
 INSERT INTO locatedOn VALUES ('Cienfuegos','Cienfuegos','C','Cuba');
 INSERT INTO locatedOn VALUES ('Havana','Ciudad de la Habana','C','Cuba');
 INSERT INTO locatedOn VALUES ('Bayamo','Granma','C','Cuba');
 INSERT INTO locatedOn VALUES ('Manzanillo','Granma','C','Cuba');
 INSERT INTO locatedOn VALUES ('Guantanamo','Guantanamo','C','Cuba');
 INSERT INTO locatedOn VALUES ('Holguin','Holguin','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 Rio','Pinar del Rio','C','Cuba');
 INSERT INTO locatedOn VALUES ('Sancti Spiritus','Sancti Spiritus','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','Cuba');
 INSERT INTO locatedOn VALUES ('Roseau','Dominica','WD','Dominica');
 INSERT INTO locatedOn VALUES ('Santo Domingo','Dominican Republic','DOM','Hispaniola');
 INSERT INTO locatedOn VALUES ('Port-au-Prince','Haiti','RH','Hispaniola');
 INSERT INTO locatedOn VALUES ('Nuuk','Greenland','GROX','Greenland');
 INSERT INTO locatedOn VALUES ('Saint Georges','Grenada','WG','Grenada');
 INSERT INTO locatedOn VALUES ('Basse-Terre','Guadeloupe','GUAD','Basse-Terre');
 INSERT INTO locatedOn VALUES ('Kingston','Jamaica','JA','Jamaica');
 INSERT INTO locatedOn VALUES ('Fort-de-France','Martinique','MART','Martinique');
 INSERT INTO locatedOn VALUES ('Plymouth','Montserrat','MNTS','Montserrat');
 INSERT INTO locatedOn VALUES ('Willemstad','Netherlands Antilles','NA','Curacao');
 INSERT INTO locatedOn VALUES ('Marigot','Saint Martin','SMAR','St. Martin');
 INSERT INTO locatedOn VALUES ('San Juan','Puerto Rico','PR','Puerto Rico');
 INSERT INTO locatedOn VALUES ('Basseterre','Saint Kitts and Nevis','KN','Saint Kitts');
 INSERT INTO locatedOn VALUES ('Castries','Saint Lucia','WL','Saint Lucia');
 INSERT INTO locatedOn VALUES ('Saint-Pierre','Saint Pierre and Miquelon','SPMI','Saint Pierre');
 INSERT INTO locatedOn VALUES ('Kingstown','Saint Vincent and the Grenadines','WV','Saint Vincent');
 INSERT INTO locatedOn VALUES ('Port-of-Spain','Trinidad and Tobago','TT','Trinidad');
 INSERT INTO locatedOn VALUES ('Grand Turk','Turks and Caicos Islands','TUCA','Grand Turk');
 INSERT INTO locatedOn VALUES ('Charlotte Amalie','Virgin Islands','VIRG','Saint Thomas');
 INSERT INTO locatedOn VALUES ('Pago Pago','American Samoa','AMSA','Tutuila');
 INSERT INTO locatedOn VALUES ('Hobart','Tasmania','AUS','Tasmania');
 INSERT INTO locatedOn VALUES ('Avarua','Cook Islands','COOK','Rarotonga');
 INSERT INTO locatedOn VALUES ('Suva','Fiji','FJI','Viti Levu');
 INSERT INTO locatedOn VALUES ('Papeete','French Polynesia','FPOL','Tahiti');
 INSERT INTO locatedOn VALUES ('Agana','Guam','GUAM','Guam');
 INSERT INTO locatedOn VALUES ('Dededo','Guam','GUAM','Guam');
 INSERT INTO locatedOn VALUES ('Tarawa','Kiribati','KIR','Tarawa');
 INSERT INTO locatedOn VALUES ('Majuro','Marshall Islands','MH','Majuro');
 INSERT INTO locatedOn VALUES ('Kolonia','Micronesia','FSM','Ponape');
 INSERT INTO locatedOn VALUES ('Palikir','Micronesia','FSM','Ponape');
 INSERT INTO locatedOn VALUES ('Yaren','Nauru','NAU','Nauru');
 INSERT INTO locatedOn VALUES ('Noumea','New Caledonia','NCA','Grande Terre');
 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 ('Christchurch','New Zealand','NZ','Te Waka-a-Maui (South Island)');
 INSERT INTO locatedOn VALUES ('Alofi','Niue','NIUE','Niue');
 INSERT INTO locatedOn VALUES ('Kingston','Norfolk Island','NORF','Norfolk Island');
 INSERT INTO locatedOn VALUES ('Saipan','Northern Mariana Islands','NMIS','Saipan');
 INSERT INTO locatedOn VALUES ('Koror','Palau','PAL','Koror');
 INSERT INTO locatedOn VALUES ('Melekeok','Palau','PAL','Babelthuap');
 INSERT INTO locatedOn VALUES ('Adamstown','Pitcairn Islands','PITC','Pitcairn');
 INSERT INTO locatedOn VALUES ('Honiara','Solomon Islands','SLB','Guadalcanal');
 INSERT INTO locatedOn VALUES ('Nukualofa','Tonga','TO','Tongatapu');
 INSERT INTO locatedOn VALUES ('Funafuti','Tuvalu','TUV','Fongafale');
 INSERT INTO locatedOn VALUES ('Port-Vila','Vanuatu','VU','Efate');
 INSERT INTO locatedOn VALUES ('Mata-Utu','Wallis and Futuna','WAFU','Uvea');
 INSERT INTO locatedOn VALUES ('Apia','Samoa','WS','Upolu');
 INSERT INTO locatedOn VALUES ('Stanley','Falkland Islands','FALK','East Falkland');
 INSERT INTO locatedOn VALUES ('Malabo','Equatorial Guinea','GQ','Bioko');
 INSERT INTO locatedOn VALUES ('Praia','Cape Verde','CV','Santiago');
 INSERT INTO locatedOn VALUES ('Moroni','Comoros','COM','Grand Comoro');
 INSERT INTO locatedOn VALUES ('Antsiranana','Antsiranana','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Antananarivo','Antananarivo','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Antsirabe','Antananarivo','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Fianarantsoa','Fianarantsoa','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Majunga','Mahajanga','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Tamatave','Toamasina','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Toliara','Toliara','RM','Madagaskar');
 INSERT INTO locatedOn VALUES ('Port Louis','Mauritius','MS','Mauritius');
 INSERT INTO locatedOn VALUES ('Mamoutzou','Mayotte','MAYO','Mayotte');
 INSERT INTO locatedOn VALUES ('Saint-Denis','Reunion','REUN','Reunion');
 INSERT INTO locatedOn VALUES ('Jamestown','Saint Helena','HELX','Saint Helena');
 INSERT INTO locatedOn VALUES ('Sao Tome','Sao Tome and Principe','STP','Sao Tome');
 INSERT INTO locatedOn VALUES ('Victoria','Seychelles','SY','Mahe');
 
COMMIT;


 INSERT INTO islandIn VALUES ('Svalbard','Norwegian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Svalbard','Barents Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Svalbard','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Greenland','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Greenland','Norwegian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Greenland','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 ('Aust-Vagoey','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','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Great Britain','The Channel',NULL,NULL);
 INSERT INTO islandIn VALUES ('Great Britain','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Great Britain','Irish 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 ('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 ('Lundy','Atlantic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bishop Rock','Atlantic Ocean',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 ('Oeland','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Aland','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Dagoe','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Oesel','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 ('Fuenen','Kattegat',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fuenen','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 ('Helgoland','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fehmarn','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Rugen','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Usedom','Baltic Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sylt','North Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fohr','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 ('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 ('Zakinthos','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kreta','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 ('Lesbos','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 ('Cyprus','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 ('Lampedusa','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Linosa','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sicilia','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 ('Sardegna','Mediterranean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Corse','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','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 ('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 ('Khark','Arabian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Gheschm','Persian Gulf',NULL,NULL);
 INSERT INTO islandIn VALUES ('Gheschm','Arabian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lavan','Persian Gulf',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lavan','Arabian Sea',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 ('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','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 ('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 ('Mohilla','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 ('Kotelny Island','Sibirian Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Kotelny Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Paramuschir','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Paramuschir','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 ('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 ('Honshu','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Honshu','Sea of Japan',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 ('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 ('Hainan','South 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 ('Negros','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Panay','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bohol','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Leyte','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Leyte','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Samar','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Samar','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Cebu','Sulawesi 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 ('Palawan','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Palawan','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Singapore','South China 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','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Batam','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bangka','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bangka','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Krakatau','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Krakatau','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Java','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Java','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Borneo','South China Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Borneo','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Borneo','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bali','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bali','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lombok','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Lombok','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumbawa','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sumbawa','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sulawesi','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Sulawesi','Sulawesi Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Timor','Indian Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Timor','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ambon','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ceram','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Guinea','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('New Guinea','Sunda Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bougainville','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Guadalcanal','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Grande Terre','Pacific Ocean',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 ('Tasmania','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Tasmania','Indian Ocean',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 ('Southampton Island','Arctic Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ellesmere Island','Arctic Ocean',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 ('Martha s 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 ('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 ('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 ('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 ('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 ('Curacao','Caribbean Sea',NULL,NULL);
 INSERT INTO islandIn VALUES ('Bonaire','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 ('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 ('Isabela','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 ('Rota','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Pitcairn','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 ('Tongatapu','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 ('Nauru','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Koror','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Babelthuap','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Fongafale','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Efate','Pacific Ocean',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 ('Guam','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Majuro','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Ponape','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Osterinsel','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Te Ika-a-Maui (North Island)','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Te Waka-a-Maui (South Island)','Pacific Ocean',NULL,NULL);
 INSERT INTO islandIn VALUES ('Olkhon',NULL,'Ozero Baikal',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 ('Manitoulin',NULL,'Lake Huron',NULL);
 INSERT INTO islandIn VALUES ('Isla da Ometepe',NULL,'Lake Nicaragua',NULL);
 
COMMIT;


 INSERT INTO mountainOnIsland VALUES ('Oeraefajoekull','Iceland');
 INSERT INTO mountainOnIsland VALUES ('Snoefell','Iceland');
 INSERT INTO mountainOnIsland VALUES ('Ben Nevis','Great Britain');
 INSERT INTO mountainOnIsland VALUES ('Monte Cinto','Corse');
 INSERT INTO mountainOnIsland VALUES ('Etna','Sicilia');
 INSERT INTO mountainOnIsland VALUES ('Psiloritis','Kreta');
 INSERT INTO mountainOnIsland VALUES ('Olympos','Cyprus');
 INSERT INTO mountainOnIsland VALUES ('Pico de Teide','Teneriffa');
 INSERT INTO mountainOnIsland VALUES ('Pico de los Nieves','Gran Canaria');
 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 ('Fogo','Fogo');
 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 ('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 ('Zhima','Olkhon');
 INSERT INTO mountainOnIsland VALUES ('Asahi-Dake','Hokkaido');
 INSERT INTO mountainOnIsland VALUES ('Yu Shan','Taiwan');
 INSERT INTO mountainOnIsland VALUES ('Pulog','Luzon');
 INSERT INTO mountainOnIsland VALUES ('Pinatubo','Luzon');
 INSERT INTO mountainOnIsland VALUES ('Mount Apo','Mindanao');
 INSERT INTO mountainOnIsland VALUES ('Kanlaon','Negros');
 INSERT INTO mountainOnIsland VALUES ('Mantalingajan','Palawan');
 INSERT INTO mountainOnIsland VALUES ('Kinabalu','Borneo');
 INSERT INTO mountainOnIsland VALUES ('Leuser','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Kerinci','Sumatra');
 INSERT INTO mountainOnIsland VALUES ('Krakatau','Krakatau');
 INSERT INTO mountainOnIsland VALUES ('Merapi','Java');
 INSERT INTO mountainOnIsland VALUES ('Semeru','Java');
 INSERT INTO mountainOnIsland VALUES ('Gunung Agung','Bali');
 INSERT INTO mountainOnIsland VALUES ('Rinjani','Lombok');
 INSERT INTO mountainOnIsland VALUES ('Tambora','Sumbawa');
 INSERT INTO mountainOnIsland VALUES ('Rantekombola','Sulawesi');
 INSERT INTO mountainOnIsland VALUES ('Tatamailau','Timor');
 INSERT INTO mountainOnIsland VALUES ('Gunung Binaiya','Ceram');
 INSERT INTO mountainOnIsland VALUES ('Puncak Jaya','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Mt. Wilhelm','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Mt. Giluwe','New Guinea');
 INSERT INTO mountainOnIsland VALUES ('Mt. Balbi','Bougainville');
 INSERT INTO mountainOnIsland VALUES ('Mt.Victoria','Viti Levu');
 INSERT INTO mountainOnIsland VALUES ('Silisili','Savaii');
 INSERT INTO mountainOnIsland VALUES ('Mont Orohena','Tahiti');
 INSERT INTO mountainOnIsland VALUES ('Popomanaseu','Guadalcanal');
 INSERT INTO mountainOnIsland VALUES ('Mauna Kea','Hawaii');
 INSERT INTO mountainOnIsland VALUES ('Mauna Loa','Hawaii');
 INSERT INTO mountainOnIsland VALUES ('Haleakala','Maui');
 INSERT INTO mountainOnIsland VALUES ('Mt. Cook','Te Waka-a-Maui (South Island)');
 INSERT INTO mountainOnIsland VALUES ('Ruapehu','Te Ika-a-Maui (North Island)');
 INSERT INTO mountainOnIsland VALUES ('Barbeau Peak','Ellesmere Island');
 INSERT INTO mountainOnIsland VALUES ('Mt. Odin','Baffin 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 ('Pico Duarte','Hispaniola');
 INSERT INTO mountainOnIsland VALUES ('Cerro de Punta','Puerto Rico');
 INSERT INTO mountainOnIsland VALUES ('La Soufriere','Basse-Terre');
 INSERT INTO mountainOnIsland VALUES ('Soufriere Hills','Montserrat');
 INSERT INTO mountainOnIsland VALUES ('Soufriere','Saint Vincent');
 INSERT INTO mountainOnIsland VALUES ('Morne Diablotins','Dominica');
 INSERT INTO mountainOnIsland VALUES ('Pelee','Martinique');
 
COMMIT;