ArctosDB / arctos

Arctos is a museum collections management system
https://arctos.database.museum
59 stars 13 forks source link

adding higher geography metadata #796

Closed ccicero closed 8 years ago

ccicero commented 8 years ago

When adding higher geography metadata (e.g., geographic search terms), it runs through checks for the entire geog record and potentially returns an error (e.g., duplicate island name). Need to be able to add metadata by bypassing those checks.

See email thread of 11 Dec 2015.

ccicero commented 8 years ago

Goal: turn Geog Search Term into a synonymy server for geography

dustymc commented 8 years ago

Goal: turn Geog Search Term into a synonymy server for geography

Specifics please - what are you wanting, where, for what purpose, etc?

Current data, in case it's somehow useful:

(edit: github hates TAB)

begin for r in (select higher_geog,geog_auth_rec_id from geog_auth_rec where geog_auth_rec_id in (select geog_auth_rec_id from geog_search_term) order by higher_geog) loop dbms_output.put_line(r.higher_geog); for t in (select SEARCH_TERM from geog_search_term where geog_auth_rec_id=r.geog_auth_rec_id) loop dbms_output.put_line(' ' || t.SEARCH_TERM); end loop; end loop; end; /

Africa, Algeria, al-Jaza'ir Wilayat Algiers Province Wilāyat al-Jazāʼir ولاية الجزائر Africa, Botswana Lefatshe la Botswana Republic of Botswana Africa, Cameroon, Adamawa Region Région de l'Adamaoua Africa, Democratic Republic of the Congo, Equateur Équateur Africa, Democratic Republic of the Congo, Katanga Shaba Province Shaba Region Africa, Egypt Arab Republic of Egypt Maṣr Miṣr جمهورية مصر العربية مَصر مِصر‎ Africa, Egypt, Alexandria Governorate Muḥāfaẓat al Iskandariyya محافظة الإسكندرية Africa, Egypt, Aswan Governorate Muḥāfaẓat Aswān ‏محافظة أسوان Africa, Egypt, Beni Suef Governorate محافظة بنى سويف Africa, Equatorial Guinea Guinea Ecuatorial Guiné Equatorial Guinée équatoriale Republic of Equatorial Guinea República da Guiné Equatorial República de Guinea Ecuatorial République de Guinée équatoriale Africa, Guinea Republic of Guinea République de Guinée Africa, Guinea, Nzerekore, Lola Lola Prefecture, Nzérékoré Region Africa, Kenya, North Eastern Province Woqooyi Bari Africa, Libya ليبيا‎ Africa, Madagascar, Atsimo-Andrefana, Madagascar Région Atsimo Andrefana Africa, Namibia, Sinclairs Island Roast Beef Island Africa, Niger, Tillaberi Tillabéri Tillabéry Africa, Nigeria Federal Republic of Nigeria Africa, Seychelles, Seychelles Islands, Make Island Mahé Africa, South Africa, Northern Cape Noord-Kaap Africa, Tanzania, Pwani Region koa wa Pwani Asia, China Zhōngguó 中国 中國 Asia, China, Anhui Province Ānhuī 安徽省 皖 Asia, China, Annam An Nam An Nam đô hộ phủ Protectorate General to Pacify the South Ānnán Ānnán Dūhùfǔ 安南 安南都護府 Asia, China, Beijing Municipality Peking 北京市 Asia, China, Fujian Province Foukien Fukien 福建 福建省 Asia, China, Fujian Province, Xiamen Island Amoy 厦门市 Asia, China, Gansu Province Gānsù 甘肃 甘肅 Asia, China, Guangdong Province Guǎngdōng 广东 廣東 Asia, China, Guangxi Zhuang Autonomous Region Guǎngxī 广西 广西壮族自治区 Asia, China, Guizhou Province Guìzhōu 貴州 贵州 Asia, China, Hainan Province, Hainan Island Hǎinán Dǎo 海南岛 Asia, China, Hebei Province Hopeh Héběi 河北 Asia, China, Heilongjiang Province Hēilóngjiāng Shěng 黑龍江省 黑龙江省 Asia, China, Henan Province Hénán 河南 豫 Asia, China, Hong Kong Hongkong Xiānggǎng 香港 香港特別行政區 香港特别行政区 香港特區 Asia, China, Hong Kong, Hong Kong Island 香港島 Asia, China, Hubei Province Hupeh Húběi 湖北 Asia, China, Hunan Húnán Xiāng 湖南 湘 Asia, China, Inner Mongolia Autonomous Region Nei Mongol Autonomous Region Nèi Měnggǔ Övör Mongol ᠦᠪᠦᠷ ᠮᠤᠩᠭᠤᠯ 内蒙古 内蒙古自治区 Asia, China, Jiangsu Province Kiangsu 江苏省 Asia, China, Jiangxi Province Jiāngxī 江西 Asia, China, Jilin Province Jílín Kirin 吉林 Asia, China, Liaoning Province Liáo 辽宁省 Asia, China, Ningxia Hui Autonomous Region Níngxià 宁夏 宁夏回族自治区 Asia, China, Qinghai Province Kokonor Qīnghǎi Tsinghai 青海 Asia, China, Qinghai, Yushu ཡུལ་ཤུལ་གྲོང་ཁྱེར། 玉树市 Asia, China, Shaanxi Province Shensi Shǎnxī 陕西 陝西 Asia, China, Shandong Province Shāndōng 山东 山東 Asia, China, Shanghai Municipality 上海市 沪 Asia, China, Shanxi Province Shānxī 山西 山西省 晉 Asia, China, Sichuan Province Szechuan Szechwan Sìchuān 四川 蜀 Asia, China, Tibet Autonomous Region Tibet Xizang Xīzàng Zìzhìqū Zàng བོད་རང་སྐྱོང་ལྗོངས། 西藏自治区 Asia, China, Xinjiang Xinjiang Uyghur Autonomous Region Xīnjiāng شىنجاڭ‎ 新疆 Asia, China, Yunaan, Baoshan Bǎoshān Yongchang 保山 Asia, China, Yunaan, Jianchuan Jiànchuān Xiàn 剑川县 Asia, China, Yunnan 云南省 Asia, China, Zhejiang Province Chekiang Zhè 浙江省 Asia, India Bhārat Ganarājya Republic of India Asia, India, Andhra Pradesh ఆంధ్ర ప్రదేశ్ Asia, India, Assam Ôxôm অসম Asia, India, Bihar بہار‎ बिहार Asia, India, Chhattisgarh Chattīsgaṛh छत्तीसगढ़ Asia, India, Delhi National Capital Territory of Delhi دہلی दिल्ली ਦਿੱਲੀ Asia, India, Gujarat गुजरात ગુજરાત Asia, India, Himachal Pradesh हिमाचल प्रदेश Asia, India, Jammu and Kashmir جموں اور کشمیر जम्मू और कश्मीर Asia, India, Karnataka ಕರ್ನಾಟಕ Asia, India, Kerala Keralam Asia, India, Kerala, Kollam Kollam District Quilon District കൊല്ലം ജില്ല Asia, India, Madhya Pradesh मध्य प्रदेश Asia, India, Maharashtra महाराष्ट्र Asia, India, Manipur মনিপুর্ Asia, India, Odisha oṛiśā ଓଡ଼ିଶା Asia, India, Puducherry Pondicherry Union Territory Pondichéry Pāṇṭiccēri புதுச்சேரி Asia, India, Punjab ਪੰਜਾਬ Asia, India, Rajasthan राजस्थान, ਰਾਜਸਥਾਨ Asia, India, Sikkim Shikim Su Khyim सिक्किम སུ་ཁྱིམ་ Asia, India, Tamil Nadu தமிழ்நாடு Asia, India, Uttar Pradesh اتر پردیش उत्तर प्रदेश Asia, India, Uttar Pradesh, Varanasi وارانسی ضلع वाराणसी ज़िला Asia, India, Uttarakhand Devbhumi Uttaranchal उत्तराखण्ड उत्तराखण्डराज्यम् देवभूमि Asia, India, Uttarakhand, Pithoragarh पिथौरागढ़ जिला Asia, India, West Bengal পশ্চিমবঙ্গ Asia, India, West Bengal, Birbhum বীরভূম জেলা Asia, Indonesia, Bangka–Belitung, Indonesian Archipelago Kepulauan Bangka Belitung Asia, Indonesia, East Nusa Tenggara, Indonesian Archipelago, Sabu Island Hawoe Hawu Sawoe Sawu Asia, Indonesia, Maluku, Indonesian Archipelago, Amboina Island Ambon Island Asia, Indonesia, North Sumatra, Indonesian Archipelago, Sumatra Sumatera Utara Asia, Indonesia, South Sulawesi, Indonesian Archipelago, Selayar Island Kepulauan Selayar Asia, Indonesia, South Sulawesi, Indonesian Archipelago, Tanah Jampea Jampea Island Pulau Jampea Tanah Djampea Tanahjampea Asia, Iran Islamic Republic of Iran Jomhuri-ye Eslāmi-ye Irān Persia جمهوری اسلامی ایران Asia, Iran, Es Fahan Province Esfahan Espahan Isfahan Isphahan Ostāne Esfahan استان اصفهان Asia, Iran, Khuzestan Province Khuzistan Ostān-e Khūzestān استان خوزستان Asia, Iran, Kordestan Province Kordestan Province Kurdestan Province Kurdistan Province استان کردستان Asia, Japan Nihon-koku Nippon-koku 日本国 Asia, Japan, Aichi Prefecture, Honshu Aichi-ken 愛知県 Asia, Japan, Aomori Prefecture, Honshu 青森県 Asia, Japan, Chiba Prefecture, Honshu 千葉県 Asia, Japan, Chugoku, Honshu Chūgoku San'in-San'yō 中国地方 Asia, Japan, Fukuoka Prefecture, Kyushu Fukuoka-ken 福岡県 Asia, Japan, Fukushima Prefecture, Honshu Fukushima-ken 福島県 Asia, Japan, Hokkaido Prefecture, Hokkaido Ezo Hokkaido Prefecture Yeso Yesso Yezo 北海道 Asia, Japan, Honshu 本州 Asia, Japan, Izu Islands, Tori Shima Izu-no-Tori-shima 鳥島 Asia, Japan, Kinki, Honshu Kansai region Kansai-chihō Kinki region Kinki-chihō 近畿地方 関西地方 Asia, Japan, Kyushu Chinzei Kyūkoku Saikaidō Tsukushi-no-shima 九国 九州 筑紫島 西海道 鎮西 Asia, Japan, Mie Prefecture, Honshu Mie-ken 三重県

Asia, Japan, Nagasaki Prefecture 長崎県 Asia, Japan, Ryukyu Islands Nansei Islands Nansei-shotō Ruuchuu Ryukyu Arc Ryūkyū-ko Ryūkyū-shotō ルーチュー 南西諸島 琉球 琉球弧 琉球諸島 Asia, Japan, Sagami Province, Honshu 相模国 Asia, Japan, Shimotsuke Province, Honshu Shimotsuke-no kuni 下野国 Asia, Japan, Tokyo Metropolis Prefecture 東京 Asia, Japan, Tokyo Metropolis Prefecture, Izu Islands, Hachijo-Jima Hachijō-jima 八丈島 Asia, Japan, Tokyo Metropolis Prefecture, Ogasawara Subprefecture, Volcano Islands, Iwo Jima Iwo To 硫黄島 Asia, Japan, Yamagata Prefecture, Honshu 山形県 Asia, Japan, Yamashiro Province, Honshu Yamashiro no Kuni 山城国 Asia, Laos, Vientiane Province ວຽງຈັນ Asia, Mongolia Monggol Ulus Mongol Uls Монгол Улс ᠮᠤᠩᠭᠤᠯ ᠤᠯᠤᠰ Asia, Paracel Islands, Lincoln Island Dōng Dǎo Đảo Linh-Côn Asia, Philippines, Aurora Province, Philippine Islands, Luzon District of El Príncipe Asia, Philippines, Northern Mindanao, Lanao del Norte, Philippine Islands, Mindanao Amihanang Lanao Hilagang Lanao Asia, Philippines, Northern Mindanao, Philippine Islands, Mindanao Hilagang Kamindanawan Asia, Russia, Kamchatka Oblast Kamchatskaya oblast Камча́тская о́бласть Asia, Taiwan ROC Republic of China Táiwān Zhōnghuá Mínguó 中華民國 台灣 臺灣 Asia, Taiwan, Chiayi County, Taiwan Chiayi Chiayi Xiàn 嘉義縣; Asia, Taiwan, Green Island 綠島 绿岛 Asia, Taiwan, Hsinchu City, Taiwan Hsin1-chu2 Shih4 Sinjhú Shìh Xinzhu Xīnzhú Shì Zhu City 新竹市 竹市 風城 Asia, Taiwan, Hualien County, Taiwan Huālián Xiàn 花蓮縣 Asia, Taiwan, Taoyuan County, Taiwan Táoyuán Xiàn 桃園縣 Asia, Taiwan, Yilan County, Taiwan Ilan County Yílán Xiàn 宜蘭縣 Asia, Taiwan, Yunlin County, Taiwan Yúnlín Xiàn 雲林縣 Asia, Thailand, Chiangmai Province Chiang Mai Province เชียงใหม่ Asia, Thailand, Chiangmai Province, Hang Dong หางดง Asia, Thailand, Chiangmai Province, Samoeng สะเมิง Asia, Thailand, Khon Kaen Province ขอนแก่น Asia, Thailand, Mae Hong Son Province Mae Hong Sorn Mae Rong Son Maehongson Maehongsorn แม่ฮ่องสอน Asia, Thailand, Mukdahan Province มุกดาหาร Asia, Thailand, Songkhla Province สงขลา Asia, Vietnam Cộng hòa Xã hội chủ nghĩa Việt Nam SRV Socialist Republic of Vietnam 越南 Asia, Vietnam, Binh Dinh Bình Định Tỉnh Bình Định Asia, Vietnam, Cao Bang Cao Bằng Province Asia, Vietnam, Hanoi Hà Nội Long Biên Long Đỗ Tống Bình Đại La 大羅 宋平 河內 龍肚 Asia, Vietnam, Lam Dong Lâm Đồng Province Asia, Vietnam, Lao Cai Lào Cai Province Asia, Vietnam, Ninh Binh Ninh Bình Province Asia, Vietnam, Quang Nam Tỉnh Quảng Nam Asia, Vietnam, Son La Province Sơn La Province Tỉnh Sơn La Asia, Vietnam, Thanh Hoa Thanh Hóa Province Asia, Vietnam, Thua Thien-Hue Thừa Thiên–Huế Asia, Vietnam, Vinh Phuc Vĩnh Phúc Province Asia, West Bank Cisjordan HaGadah HaMa'aravit aḍ-Ḍiffah הגדה המערבית الضفة الغربية Atlantic Ocean, Gulf of Mexico Golfo de México Australia, Australia Commonwealth of Australia Central America, Costa Rica, Cartago Provincia de Cartago Central America, Costa Rica, Cartago, Jimenez Cantón de Jiménez Central America, Guatemala, El Quiche El Quiché Central America, Guatemala, Peten Petén Central America, Guatemala, Sacatepequez Sacatepéquez Central America, Guatemala, Solola Sololá Central America, Guatemala, Suchitepequez Suchitepéquez Central America, Guatemala, Totonicapan Totonicapán Europe, Austria, Carinthia Carinzia Koroška Kärnten Europe, Austria, Oberosterreich Oberösterreich Upper Austria Europe, Austria, Oberosterreich, Gmunden Bezirk Gmunden Europe, Austria, Styria Steiermark Europe, Austria, Styria, Bruck-Murzzuschlag District Bruck-Mürzzuschlag District Europe, Austria, Tyrol Tirol Tirolo Europe, Belgium, Flanders Flandern Flandre Flemish Region Vlaanderen Europe, Belgium, Flanders, Antwerp Antwerpen Europe, Belgium, Wallonia Région wallonne Wallonie Wallonische Region Wallonië Walloon Region Europe, Belgium, Wallonia, Hainaut Hainault Hainaut Henegouwen Hennegau Hinnot Hénau Europe, Bosnia and Herzegovina, Central Bosnia Canton Srednjobosanski kanton Županija Središnja Bosna Europe, Croatia, Dalmatia Dalmacija Dalmazia Dalmàssia Europe, Czech Republic, Central Bohemian Region Středočeský kraj Europe, Czech Republic, Karlovy Vary Region Carlsbad Region Karlovarský kraj Europe, Czech Republic, Karlovy Vary Region, Sokolov District Okres Sokolov Europe, Czech Republic, Plzen Region Plzeň Europe, Czech Republic, Usti nad Labem Region Region Aussig Ústecký Region Ústecký kraj Ústí nad Labem Region Europe, Czech Republic, Usti nad Labem Region, Teplice District Okres Teplice Europe, Denmark, Faroe Islands Faeroes Færøerne Føroyar Europe, Finland, Lappi Lapin maakunta Lapland Lappland Lapplands landskap Europe, Finland, Lappi, Enontekio Eanodat Enontekis Enontekiö Europe, France, Brittany Breizh Bretagne Rannvro Breizh Région Bretagne Europe, France, Franche-Comte Franche-Comté Europe, France, Ile-de-France Île-de-France Europe, France, Poitou-Charentes, Deux-Sevres Deux-Sèvres Europe, France, Rhone-Alpes Rhône-Alpes Europe, France, Rhone-Alpes, Isere Isère Europe, Germany Bundesrepublik Deutschland Deutschland Federal Republic of Germany Europe, Germany, Baden-Wurttemberg Baden-Württemberg Europe, Germany, Bavaria Bavorsko Freischdood Bayan Freistaat Bayern Freistood Baijaan Freistood Boajan The Free State of Bavaria Europe, Germany, Bavaria, Lower Bavaria Niederbayern Europe, Germany, Bavaria, Lower Franconia Unterfranken Europe, Germany, Bavaria, Upper Bavaria Oberbayern Europe, Germany, Bavaria, Upper Franconia Oberfranken Europe, Germany, Erfurt District Bezirk Erfurt Europe, Germany, Halle District Bezirk Halle Europe, Germany, Hamburg Free and Hanseatic City of Hamburg Freie und Hansestadt Hamburg Europe, Germany, Hesse Hessen Hessia Europe, Germany, Hesse, Giessen Gießen Europe, Germany, Lower Saxony Lound Läichsaksen Neddersassen Nedersaksen Niedersachsen Europe, Germany, Magdeburg District Bezirk Magdeburg Europe, Germany, Mecklenburg-Vorpommern MV MeckPomm Mecklenburg-Western Pomerania Europe, Germany, Mecklenburg-Vorpommern, Rostock Landkreis Rostock Europe, Germany, Nordrhein-Westfalen Nordrhein-Westfalen North Rhine-Westphalia Europe, Germany, Rheinland-Pfalz Rhineland-Palatinate Rhénanie-Palatinat Europe, Germany, Rheinland-Pfalz, Rhein-Lahn-Kreis Rhein-Lahn Europe, Germany, Saxony Free State of Saxony Freistaat Sachsen Sasko Swobodny stat Sakska Europe, Germany, Saxony, Leipzig District Landkreis Leipzig Europe, Germany, Saxony, Mittelsachsen Central Saxony Europe, Germany, Saxony, Saxon Switzerland-East Ore Mountains Saské Švýcarsko a východní Krušné hory Sächsische Schweiz-Osterzgebirge Europe, Germany, Saxony, Weiseritzkreis Weißeritzkreis Europe, Germany, Saxony-Anhalt Sachsen-Anhalt Europe, Germany, Schleswig-Holstein, Holstein Holsatia Holsteen Holsten Europe, Germany, Thuringia Free State of Thuringia Freistaat Thüringen Europe, Germany, Thuringia, Kyffhauserkreis Kyffhäuserkreis Europe, Germany, Wurttemberg Württemberg Europe, Greece, Aegean South, Cyclades Νομός Κυκλάδων Europe, Greece, Greece Central Continental Greece Region Periféreia Stereás Elládas Περιφέρεια Στερεάς Ελλάδας Europe, Greece, Peloponnese Περιφέρεια Πελοποννήσου Europe, Greece, Western Greece Περιφέρεια Δυτικής Ελλάδας Europe, Iceland, Capital Region Greater Reykjavík Höfuðborgarsvæðið Europe, Iceland, Eastern Region Austfirðir Austurland Europe, Iceland, Eastern Region, Sudur-Mulasysla Suður-Múlasýsla Europe, Iceland, Northeastern Region Norðurland eystra Europe, Iceland, Northeastern Region, Nordurthing Norðurþing Europe, Iceland, Southern Region Suðurland Europe, Iceland, Southern Region, Blaskogabyggd Bláskógabyggð Europe, Iceland, Vestmannaeyjar Westman Islands Europe, Iceland, Westfjords Region Vestfirðir West Fjords Europe, Ireland, County Meath, British Isles Contae na Mí an Mhí Europe, Ireland, Leinster, British Isles Laighin Europe, Ireland, Leinster, County Westmeath, British Isles Contae na hIarmhí Europe, Ireland, Leinster, County Wicklow, British Isles Contae Chill Mhantáin Europe, Ireland, Munster, County Cork, British Isles Contae Chorcaí Europe, Ireland, Munster, County Kerry, British Isles Contae Chiarraí Europe, Italy Italia Italian Republic Repubblica italiana Europe, Italy, Agrigento, Sicily Provincia di Agrigento Pruvincia di Girgenti Europe, Italy, Campania Region, Salerno Province of Salerno Provincia di Salerno Europe, Italy, Piedmont Region Piemont Piemonte Piémont Europe, Italy, Piedmont Region, Verbano-Cusio-Ossola Provincia del Verbano Cusio Ossola Europe, Italy, Trentino-Alto Adige Region Südtirol Trentino-Alto Adige Europe, Italy, Tuscany, Florence Province of Florence Provincia di Firenze Europe, Italy, Tuscany, Sardinia Toscana Europe, Italy, Tuscany, Siena Province of Siena Europe, Italy, Umbria Region, Perugia Province Province of Perugia Provincia di Perugia Europe, Monaco Principauté de Monaco Europe, North Sea, Germany, Schleswig-Holstein, Helgoland Helgoland deät Lun Europe, North Sea, Sweden, Gulf of Bothnia Bottniska viken Pohjanlahti Europe, Norway, Buskerud Buskerud fylke Europe, Norway, Finnmark Finnmárkku fylka Ruija Europe, Norway, Hordaland Hǫrðaland Europe, Norway, Nordland Nordland fylke Nordlándda Europe, Norway, Ostfold Østfold fylke Europe, Norway, Rogaland, Eigersund Eigersund kommune Europe, Norway, Rogaland, Sokndal Sokndal kommune Europe, Norway, Sor-Trondelag Sør-Trøndelag fylke Europe, Norway, Svalbard, Spitzbergen Vest Spitsbergen Vestspitsbergen West Spitsbergen Europe, Poland, Lower Silesia Dolny Śląsk Dolny Ślůnsk Dolní Slezsko Niederschlesien Niederschläsing Silesia Inferior Europe, Poland, Lower Silesia, Boleslawiec Bolesławiec County Powiat bolesławiecki Europe, Poland, Lower Silesia, Klodzko Kłodzko County powiat kłodzki Europe, Poland, Silesia Schläsing Silesia Slezsko Śląsk Ślůnsk Europe, Romania, Arges County Argeș County Europe, Romania, Bistrita-Nasaud County Bistrița-Năsăud County Europe, Romania, Braila County Brăila County Europe, Romania, Caras-Severin County Caraș-Severin County Europe, Romania, Constanta County Constanța County Europe, Romania, Dambovita County Dâmbovița County Europe, Romania, Ialomita County Ialomița County Europe, Romania, Mehedinti County Mehedinți County Europe, Romania, Salaj County Land of Silvania Sălaj County Europe, Romania, Timis County Timiș County Europe, Russia, Kalmykia Hal'mg Tanghch Respublika Kalmykiya Респу́блика Калмы́кия Хальмг Таңһч Europe, Slovakia, Banska Bystrica Region Banskobystrický kraj Banská Bystrica Region Besztercebányai kerület Europe, Sweden Kingdom of Sweden Konungariket Sverige Europe, Sweden, Gavleborg County Gävleborg County Gävleborgs län Europe, Sweden, Gotland County Gotlands län Europe, Sweden, Gotland County, Bohuslan Bohuslän Europe, Sweden, Gotland County, Gotland Island Gothland Gottland Gutland Europe, Sweden, Jamtland County Jämtland Jämtlands län Europe, Sweden, Kalmar County Kalmar län Europe, Sweden, Kalmar County, Oland Öland Europe, Sweden, Kristianstad County Kristianstads län Europe, Sweden, Norrbotten County Norrbottens län Europe, Sweden, Ostergotland County Östergötland County Östergötlands län Europe, Sweden, Skane County Scania County Skåne County Skåne Ian Skåne län Europe, Sweden, Stockholm County Stockholms län Europe, Sweden, Uppsala County Uppsala län Europe, Sweden, Varmland County Värmland County Värmlands län Europe, Sweden, Vasterbotten County Västerbottens län Europe, Sweden, Vasternorrland County Västernorrland County Västernorrlands län Europe, Switzerland, Aargau Argovia Europe, Switzerland, Graubunden Canton Cantone dei Grigioni Chantun Grischun Graubünden Europe, Switzerland, Graubunden Canton, Surselva District Bezirk Surselva District Surselva Europe, Switzerland, Lucerne Canton Kanton Luzern Europe, Switzerland, Saint Gallen Canton of St. Gallen Kanton St. Gallen Sanggale St. Gallen Europe, Switzerland, Thurgau Thurgovia Europe, United Kingdom, Scotland, Aberdeenshire, British Isles, Britain Aiberdeenshire Siorrachd Obar Dheathain Europe, United Kingdom, Scotland, Dumfries and Galloway Region, British Isles Dumfries an Gallowa Dùn Phrìs is Gall-Ghaidhealaibh Europe, United Kingdom, Scotland, Hebrides Innse Gall Suðreyjar Europe, United Kingdom, Scotland, Midlothian, British Isles Edinburghshire Meadhan Lodainn Midlowden Europe, United Kingdom, Scotland, North Ayrshire, British Isles, Britain Siorrachd Àir a Tuath Europe, United Kingdom, Scotland, South Lanarkshire, British Isles Siorrachd Lannraig a Deas Sooth Lanrikshire Europe, United Kingdom, Wales, Conwy, British Isles, Britain Bwrdeistref Sirol Conwy Conwy County Borough North America, Canada, British Columbia, Mount Waddington RDMW Regional District of Mount Waddington North America, Canada, British Columbia, North Okanagan RDNO Regional District of North Okanagan North America, Canada, Manitoba, Portage la Prairie Rural Municipality of Portage la Prairie North America, Canada, Newfoundland and Labrador Terre-Neuve-et-Labrador North America, Canada, Quebec, Memphremagog Memphrémagog Regional County Municipality North America, Canada, Quebec, Wright Gracefield North America, Greenland, Aquiles Serdan Aquiles Serdán Municipality North America, Gulf of California, Mexico Golfo de California Mar Bermejo Mar de Cortés Sea of Cortez Sea of Cortés Vermilion Sea North America, Gulf of California, Mexico, Baja California Sur Estado Libre y Soberano de Baja California Sur North America, Gulf of California, Mexico, Baja California Sur, Gulf of California Islands, Consag Rock Roca Consag North America, Gulf of California, Mexico, Baja California Sur, Gulf of California Islands, Isla Carmen Isla del Carmen North America, Gulf of California, Mexico, Baja California Sur, Gulf of California Islands, Isla Cerralvo Cerralvo Island Jacques Cousteau Island North America, Gulf of California, Mexico, Baja California Sur, Gulf of California Islands, Isla Espiritu Santo Isla Espíritu Santo North America, Mexico, Aguascalientes Estado Libre y Soberano de Aguascalientes North America, Mexico, Campeche Estado Libre y Soberano de Campeche North America, Mexico, Chihuahua, Aquiles Serdan Aquiles Serdán North America, Mexico, Durango, Inde Municipality Indé North America, Mexico, Durango, Mapimi Municipality Mapimí North America, Mexico, Mexico Estado Libre y Soberano de México Estado de México Free and Sovereign State of Mexico North America, Mexico, Nuevo Leon Nuevo León North America, Mexico, Nuevo Leon, Cadereyta Jimenez Cadereyta Jiménez North America, Mexico, Oaxaca, Ixtlan District Ixtlán District North America, Mexico, Queretaro Estado Libre y Soberano de Querétaro Free and Sovereign State of Querétaro North America, Mexico, Quintana Roo Estado Libre y Soberano de Quintana Roo Free and Sovereign State of Quintana Roo North America, Mexico, Sinaloa, Mazatlan Mazatlán North America, Mexico, Tamaulipas Estado Libre y Soberano de Tamaulipas North America, Mexico, Veracruz, Poza Rica Poza Rica de Hidalgo North America, Mexico, Yucatan Estado Libre y Soberano de Yucatán Free and Sovereign State of Yucatán Yucatán North America, United States, Alaska, City and Borough of Yakutat Yaakwdáat North America, United States, Alaska, Municipality of Skagway Skagway Borough North America, United States, Montana, National Bison Range NBR North America, United States, Oklahoma Gahnawiyoˀgeh Uukuhuúwa òɡàlàhoma ᎣᎦᎳᎰᎹ North Pacific Ocean, Sea of Japan Yaponskoye more Японское море にほんかい 日本海 朝鮮東海 東海 동해 조선동해 Pacific Ocean, Federated States of Micronesia, Caroline Islands, Ponape Island Pohnpei Pacific Ocean, Papua New Guinea, Chimbu Province, New Guinea Simbu Pacific Ocean, United States, Hawaii, Honolulu County, Hawaiian Islands, Moku O Loe Island Coconut Island Moku o Loʻe Pacific Ocean, United States, Hawaii, Kauai County, Hawaiian Islands Kauaʻi County Pacific Ocean, United States, Midway Island, Hawaiian Islands Midway Atoll Pihemanu Kauihelani South America, Argentina Argentine Republic República Argentina South America, Argentina, Buenos Aires Capital Federal Provincia de Buenos Aires South America, Brazil, Rio de Janeiro Estado do Rio de Janeiro South America, Brazil, Rondonia Rondônia South America, Colombia Republic of Colombia República de Colombia South America, Colombia, Amazonas Departamento del Amazonas Department of Amazonas South America, Colombia, Archipelago of San Andres, Providencia and Santa Catalina Archipelago of San Andrés, Providencia and Santa Catalina Archipiélago de San Andrés, Providencia y Santa Catalina San Andrés y Providencia South America, Colombia, Atlantico Atlántico South America, Colombia, Bogota Capital District South America, Colombia, Bolivar Bolívar South America, Colombia, Boyaca Boyacá South America, Colombia, Caqueta Caquetá Department South America, Colombia, Cesar Departamento del Cesar South America, Colombia, Choco Chocó South America, Colombia, Cordoba Córdoba South America, Colombia, Cundinamarca Departamento de Cundinamarca South America, Colombia, Narino Nariño South America, Colombia, Norte de Santander North Santander South America, Colombia, Quindio Quindío South America, Colombia, Vaupes Vaupés South America, Guyana, Upper Takutu-Upper Essequibo Region 9 South America, Peru, Arequipa, La Union La Unión La Unión Province South America, Peru, Huanuco Huánuco South America, Peru, Junin Junín Region South America, Peru, La Libertad Departamento de La Libertad South America, Peru, Pasco, Oxapampa Provincia de Oxapampa South America, Venezuela, Aragua Estado Aragua South America, Venezuela, Cojedes Estado Cojedes South America, Venezuela, Merida Estado Bolivariano de Mérida Mérida South America, Venezuela, Miranda Estado Miranda South America, Venezuela, Vargas Estado Vargas South Pacific Ocean, Chile, Valparaiso, Easter Island Isla de Pascua Rapa Nui West Indies, Antigua and Barbuda, Lesser Antilles, Antigua Wadadli Waladli West Indies, Dominican Republic, Provincia Bahoruco, Greater Antilles, Hispaniola Baoruco West Indies, Haiti, Grand Anse Department, Greater Antilles, Hispaniola Grand'Anse Grandans West Indies, Haiti, Greater Antilles, Hispaniola Ayiti Haïti Republic of Haiti West Indies, Haiti, Sud Department, Greater Antilles, Hispaniola Sid South Department West Indies, Lesser Antilles Caribbees West Indies, Netherlands, Netherlands Antilles, Lesser Antilles Antia Hulandes Dutch Antilles Nederlandse Antillen

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.15

dustymc commented 8 years ago

Form updated, closing this - I still have no idea what a synonymy server is, file a new Issue please. @mkoo