Cornouailles|Cornovaglia|Cornualha|Cornualles|Cornwall and Isles of Scilly

non-metropolitan county with no county council
non-metropolitan county with no county council
non-metropolitan county with no county council
non-metropolitan county with no county council
non-metropolitan county with no county council
non-metropolitan county with no county council

London Borough of Hammersmith and Fulham

Kensington and Chelsea, Royal London Borough of
Hammersmith and Fulham, London Borough of
Newcastle upon Tyne, City and Borough of
Kingston upon Thames, Royal London Borough of
Windsor and Maidenhead, Royal Borough of
Bath and North East Somerset, District of

Dungannon and South Tyrone Borough Council

borough londonien de Hammersmith et Fulham
district londonien de Barking et Dagenham

distretto di contea di Vale of Glamorgan
distretto di contea di Neath Port Talbot
distretto di contea di Rhondda Cynon Taf

drop table if exists dorset_roads;create table dorset_roads as select r.* from roads r, dorset d where st_intersects(d.geometry,r.geometry); select * from dorset_roads

Territory of the French Southern and Antarctic Lands
United Kingdom of Great Britain and Northern Ireland
Democratic Socialist Republic of Sri Lanka

Southern Nations, Nationalities and Peoples
Aisén del General Carlos Ibáñez del Campo
South Georgia and the South Sandwich Islands

Southern Nations, Nationalities, and People's Region
Al Istiwa'iyah ash Sharqiyah| Sharq al Istiwa'iyah| Équatoria oriental
Agence de la Frontisre du Nord-Est(French-obsolete)|North East Frontier Agency
Al Foudjaïrah, Fudjayra|Al Fujayrah, Fujaira, Fujairah, Fujeira
Ach Chârdjah|Chardja|Ash Shariqah|Ash Sharjah|Sharjah and Dependencies|Sharjah and Kalba
Ras al Khaima|Râs al Khaïmah|Ra's al Khayma|Ra's al Khaymah
Góbi do Sul|Ömnögov'|Ömönö Gobi|South Gobi|Umnu|Ömnögow'|Südgobi
Gorno-Altayskaya A.Obl.|Respublika Altay|Oirot|Republic of Altai
Cossacks of the Black Sea|Kuban|Kubanskaya|Yekaterinodar|Krasnodarskiy Kray
Kuzey Osetya|Respublika Severnaya Osetiya|Severnaya Osetiya-Alaniya|North Ossetian A.S.S.R.|Republic of North Osetia-Alania
Dagestanskaya A.S.S.R.|Daghestan|Republic of Dagestan|Respublika Dagestan|Dagistan
Badakhshoni Kuni|Autonomes Gebiet der Berg-Badachschanen|Gorno-Badahshanskaya avtonomnaya oblast'|Go
Darfur al Janubiyah| Janub Darfur| Darfur méridional| Southern Darfur
Al Istiwa'iyah al Gharbiyah|Gharb al Istiwa'iyah| Équatoria occidental
Southern Red Sea|Debubawi Keyh Bahri|Debub-Keih-Bahri|al-Bahru al-Ahmaru al-Janubi
Lower Austria|Baixa-Áustria|Baja Austria|Niederdonau|Österreich unter der Enns
South Moravian Region, Jihomoravský kraj
Upper Austria|Alta-Áustria|Alta Austria|Österreich ober der Enns|Oberösterreich
Bolzano|Trentino - Alto Adige|Trentino-Alto Adigio|Trentino-South Tirol|Venezia Tridentina
Azarbayjan-e Bakhtari|Azarbaijan-e Gharbi|West Azarbayejan|Azerba‹djan e Gharbi
Karelian A.S.S.R.|Karelo-Finnish A.S.S.R.|Karel'skaya A.S.S.R.|Olonets|Olonetskaya G.|Kareliya|Republic of Karelia
Gorna Cumaya|Cuma-i Bala|Gorna Djumaya|Gorna Dzhumaya
Brabante del Norte|Brabante do Norte|Brabante settentrionale|Brabant-septentrional|Nord-Brabant|Nort
Province of the Don Cossacks|Provinz des Donischen Heeres|Voyska Donskovo|Rostovskaya Oblast
Azarbayjan-e Khavari|Azarbaijan-e Sharghi|Azarbaijan-Sharqi|East Azarbayejan|Azerba‹djan e Sharqi
Buryatiya|Buryat-Mongol A.S.S.R.|Republic of Buryatia|Buryatskaya A.S.S.R.
Respublika Tyva|Republic of Tuva|Tyva|Tuvinskaya A.S.S.R.|Republic of Tyva
Den jødiske autonome oblasten|Evrey|Jewish A.Obl.|Yahudi|Yevreyskaya A.Obl.|Evreyskaya AOb
Al Hasaka|Al-Haska|Al Hassake|El Haseke|Haseke|Hassakeh|Hazakieh|Hassetché|Al Jezira|Jezireh
Loang Prabang|Louangphabang|Louang Prabang|Luang Phabang|Luangphrabang|Luang Prabang
Al Wustá, Al Awsat |An Nil al Azraq| Central
Upper Nile|Sobat|a`Ali an Nil|Nil supérieur
colonial territories|madre de dios|territorio nacional de colonias
Región Metropolitana|Région Metropolitaine de Santiago|Región Metropolitana|RM
Aisén|Aysén|Aysén del General Carlos Ibáñez del Campo
Magalhães|Magellan et Antarctique Chilienne|Región de Magallanes y de la Antártica Chilena
Feuerland|Terra del Fuoco|Terre de Feu|Terra do Fogo|Tierra del Fuego|Antártida e Islas del Atlántico Sur
New Guinea|Yos Sudarso or Frederick Hendrik|Waigeo|Supiori Biak|Yapen|Misool|Salawati|Batanta
Baluchestan va Sistan|Seistan and Baluchistan|Sistan e Baloutchistan
Djebel Druze|Jabal Druze|Jebel Druse|Jebel ed Druz|Al Sueida|Es Sueida|Es Suweida|Soueida|Suwaidaa
Shamal Sina|Nord Sinaï|North Sinai|Sina ash-Shamaliyah|Sinai ash Shamaliya
Dair-Ezzor|Dayr az Zaur|Deir Al Zour|Deir ez Zor|Der Azzor|Dier Elzour
an Nil, Nahr an Nil| Nil| Nile| Nile River|Nilen|Nilo
Ba?r al A?mar|Mar Rojo|Mar Rosso|Mar Vermelho|Mer Rouge|Röda havet|Rødehavet|Rotes Meer
Dakhlet Nouâdhibou|Baie du Lévrier|Lévrier Bay
North Darfur|Darfur ash Shamaliyah|Shamal Darfur|Darfur septentrional
Northern Red Sea|al-Bahru al-Ahmaru ash-Shimali|Semenawi Keyh Bahri|Semien-Keih-Bahri
Southern Kordofan|South Kordufan|Janub Kurdufan|Janub Kurdufun|Kurdufan al Janubiyah|Kordofan méridional
North Bahr-al-Gazal| North Bahr el Ghazal| Shamal Bahr al Ghazal
Al Qunatirah|Al Qunaytirah|Al Quneitera|El Quneitra|El Kenitra|Kunaitra|Kuneitra|Qunaytira
Bruselas|Brussel Hoofstadt|Brusselse Hoofdstedelijke Gewest|Brüssel|Bruxelas|Région de Bruxelles-Capitale
BUENOS AIRES D.F.|Capital Federal|Distretto Federale|Distrito Federal|Federal Capital
West Papua|Irian Jaya Barat|New Guinea|Yos Sudarso or Frederick Hendrik|Waigeo|Supiori Biak|Yapen|Misool|Salawati|Batanta
Janub Sina|Sina al-Janubiyah|Sina' al-Janubiyah|Sinai al Janubia|South Sinai|Sud Sinai
La Meca|La Mecca|La Mecque|Makka|Makkah al-Mukarramah|Mecca|Meca|Mecka|Mekka
Oumm al Qaïwaïn|Umm al Qi`iwayn|Qaiwan|Umm al Qaiwain|Umm al Qayqayn|Umm al Qaywayn|Umm el Quwain|Um al Qaiuan
State of Rhode Island and Providence Plantations|RI|R.I.
Banader va Jazayer-e Khalij-e Fars|Bushire|Persian Gulf|Ports and Islands of the Persian Gulf
Banader va Jazayer-e Bahr-e Oman|Ports and Islands of the Sea of Oman|Saheli
Kafr-El-Sheikh|Kafr ash Shaikh|Kafr ash-Shayk|Kafr el Sheik|Kafr el Sheikh
Al Bayda'|al-Ghabal al-Ahdar|Beida|Djebel Akhdar|Jebel el Akhdar
Negeri Sembilan Darul Khusus|Negri Sembilan
Nakhon Thammarat|Nagara Sridharmaraj|Nakhon Sri Thammarat|Nakhornsrithamrat|Nakornsrithamaraj
Bangkok|Krung Thep|Krung Thep Maha Nakhon|Phra Nakhon-Thonburi
Sogn og Fjordane fyl|Nordre Bergenhus|Sogn og Firða-Fylki
Íles Laquedives|Laccadive|Minicoy and Amindivi Islands|Laccadives|Lackadiverna|Lakkadiven|Lakkadi
Andaman & Nicobar Islands|Andaman et Nicobar|Iihas de Andama e Nicobar|Inseln Andamanen und Nikobare
Kalmykiya|Khalmg Tangch|Republic of Kalmykia|Kalmytskaya A.S.S.R.|Respublika Kalmykiya
Nova Bretanha Ocidental|Nuova Britannia Occidentale
Nova Bretanha Oriental|Nuova Britannia Orientale
Sidi Bu Zayd|Qamudah|Sidi Boû Sa`îd|Sidi Buzid|Sidi Bu Sa`id|Sidi Bu Zayd|Sidi Bu Said
DAdra et Nagar Haveli|Dadra e Nagar Haveli
Appenzell Ausser-Rhoden|Appenzell Outer Rhodes|Appenzell dadens|Appenzell Rhodes Extérieures|Appenzello Esterno
Appenzell Inner-Rhoden|Appenzell Inner Rhodes|Appenzell dador|Appenzell Rhodes Intérieures|Appenzello Interno
Kordofan septentrional| Kurdufan ash Shamaliyah| Shamal Kurdufan| North Kordofan
Islamabad|Federal Capital Territory|Federal Capital Territory Islamabad|Territoire de la Capitale fédérale
Bashkir|Bashkiriya|Bashkirskaya A.S.S.R.|Republic of Bashkortostan|Respublika Bashkortostan
Kazan|Kazanskaya G.|Tatar A.S.S.R.|Tatarskaya A.S.S.R.|Republic of Tatarstan|Respublika Tatars
Khakassiya|Republic of Khakasia|Khakasskaya A.Obl.|Respublika Khakasiya|Republic of Khakasia
Mordov|Mordvian Autonomous Republic|Mordvinia|Republic of Mordovia|Mordovian A.S.S.R.
Mari|Mari-El|Republic of Mari El|Mariyskaya A.S.S.R.|Respublika Mariy El
Komi A.S.S.R.|Republic of Komi|Respublika Komi
Adygea|Adygeya|Adygheya|Republic of Adygeya|Adygeyskaya A.Obl.|Respublika Adygeya
Central Gobi|Dunda Gobi|Dundgobi|Dundgov'|Middle Gobi|Dundgow'|Mittelgobi|G¢bi Central
Bovir Ahmadi and Kohkiluyeh|Boyer-Ahmad and Koh-Giluye|Boyer Ahmad e Kohkiluyeh|Boyer Ahmadi-ye Sardir va Kohkiluyeh|Kohgil
Trentino - Alto Adige|Trentino-Alto Adigio|Trentino-South Tirol|Venezia Tridentina