REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('AE', 'United Arab Emirates', 'دولة الإمارات العربية المتحدة', 'united-arab-emirates', '971', 'AED');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(3290595, 'AE', 'Imārat Umm al Qaywayn', 1, 'imarat-umm-al-qaywayn'),
(3291075, 'AE', 'Raʼs al Khaymah', 1, 'imarat-ra-s-al-khaymah'),
(3292224, 'AE', 'Dubai', 1, 'dubai'),
(3292673, 'AE', 'Sharjah', 1, 'sharjah'),
(3292879, 'AE', 'Fujairah', 1, 'fujairah'),
(3292933, 'AE', 'Ajman', 1, 'ajman'),
(3292969, 'AE', 'Abu Dhabi', 1, 'abu-dhabi');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(3286280, 3292224, 'AE', 'Suhaylah', 1, 'suhaylah', 24.80388, 56.19449),
(3290400, 3292969, 'AE', 'Z̧uwayhir', 1, 'zuwayhir', 23.28333, 53.2),
(3290409, 3292879, 'AE', 'Zubārah', 1, 'zubarah', 25.40487, 56.35971),
(3290419, 3292879, 'AE', 'Zikt', 1, 'zikt', 25.51179, 56.32328),
(3290442, 3292879, 'AE', 'Z̧anḩah', 1, 'zanhah', 25.5659, 56.20217),
(3290454, 3292969, 'AE', 'Z̧afīr', 1, 'zafir', 23.12731, 53.75439),
(3290462, 3291075, 'AE', 'Yinas', 1, 'yinas', 25.73158, 56.13405),
(3290503, 3292224, 'AE', 'Warīsān', 1, 'warisan', 25.16744, 55.40708),
(3290509, 3292879, 'AE', 'Wamm', 1, 'wamm', 25.60031, 56.22838),
(3290512, 3291075, 'AE', 'Waḩlah', 1, 'wahlah', 24.90897, 56.30316),
(3290517, 3292969, 'AE', 'Wafd', 1, 'wafd', 23.10262, 53.71159),
(3290518, 3291075, 'AE', 'Wad Wid', 1, 'wad-wid', 25.62515, 56.01396),
(3290519, 3292673, 'AE', 'Wādī Shī', 1, 'wadi-shi', 25.35, 56.31667),
(3290521, 3292969, 'AE', 'Wadhīl', 1, 'wadhil', 23.0474, 54.13332),
(3290523, 3292879, 'AE', 'Wa‘bayn', 1, 'wa-bayn', 25.57046, 56.13536),
(3290546, 3292224, 'AE', '‘Urqūb Juwayza', 1, 'urqub-juwayza', 24.93333, 55.46667),
(3290554, 3292673, 'AE', '‘Uqayr', 1, 'uqayr', 25.28302, 56.36435),
(3290589, 3292969, 'AE', 'Umm al Qurayn', 1, 'umm-al-qurayn', 23.1, 53.71667),
(3290594, 3290595, 'AE', 'Umm Al Quwain City', 1, 'umm-al-quwain-city', 25.56473, 55.55517),
(3290624, 3292224, 'AE', '‘Ūd al Bayḑā’', 1, 'ud-al-bayda', 25.01625, 55.45533),
(3290658, 3292969, 'AE', 'Tharwānīyah', 1, 'tharwaniyah', 23.11088, 54.01572),
(3290664, 3292879, 'AE', 'Ţayyibah', 1, 'tayyibah', 25.41228, 56.17075),
(3290679, 3292879, 'AE', 'Ţarīqat Ja‘d', 1, 'tariqat-ja-d', 25.52852, 56.15144),
(3290680, 3292879, 'AE', 'Ţarīf Kalbā', 1, 'tarif-kalba', 25.0695, 56.33115),
(3290681, 3292969, 'AE', 'Ţarīf', 1, 'tarif', 24.05399, 53.76347),
(3290687, 3292969, 'AE', 'Ţaraq', 1, 'taraq', 23.11656, 53.60697),
(3290710, 3292673, 'AE', 'Şūr', 1, 'sur', 25.09407, 56.34827),
(3290714, 3292879, 'AE', 'Sumbrair', 1, 'sumbrair', 25.60083, 56.2844),
(3290727, 3291075, 'AE', 'Suḩaybah', 1, 'suhaybah', 24.93877, 56.15754),
(3290729, 3292933, 'AE', 'Şufayrī', 1, 'sufayri', 24.81168, 56.12647),
(3290747, 3292879, 'AE', 'Sinnah', 1, 'sinnah', 25.50868, 56.16772),
(3290759, 3291075, 'AE', 'Sījī', 1, 'siji', 25.24764, 56.07719),
(3290793, 3292673, 'AE', 'Shīs', 1, 'shis', 25.29138, 56.24549),
(3290795, 3291075, 'AE', 'Shimāl', 1, 'shimal', 25.8178, 56.01088),
(3290812, 3291075, 'AE', 'Shawkah', 1, 'shawkah', 25.1, 56.03333),
(3290814, 3292879, 'AE', 'Shawīyah', 1, 'shawiyah', 25.26792, 56.08149),
(3290820, 3292879, 'AE', 'Sharm', 1, 'sharm', 25.47078, 56.35319),
(3290822, 3291075, 'AE', 'Sharīyah', 1, 'shariyah', 25.1, 56.03333),
(3290823, 3292933, 'AE', 'Sharīyah', 1, 'shariyah', 24.81512, 56.0986),
(3290860, 3291075, 'AE', 'Shahawāt', 1, 'shahawat', 25.96667, 56.08333),
(3290863, 3292969, 'AE', 'Shāh', 1, 'shah', 23.13561, 53.91653),
(3290866, 3291075, 'AE', 'Shāh', 1, 'shah', 25.89861, 56.12833),
(3290869, 3291075, 'AE', 'Shabakah', 1, 'shabakah', 25.03333, 56),
(3290878, 3291075, 'AE', 'Sayḩ aş Şaqlah', 1, 'sayh-as-saqlah', 24.88398, 56.16847),
(3290880, 3291075, 'AE', 'Sayḩ', 1, 'sayh', 25.93333, 56.06667),
(3290909, 3292879, 'AE', 'Saqamqam', 1, 'saqamqam', 25.17467, 56.33039),
(3290920, 3291075, 'AE', 'Samarat', 1, 'samarat', 25.68907, 56.13699),
(3290944, 3291075, 'AE', 'Şāliḩīyah', 1, 'salihiyah', 25.72161, 55.99081),
(3290956, 3292879, 'AE', 'Sā’if', 1, 'sa-if', 25.1842, 56.24205),
(3290975, 3292879, 'AE', 'Şafad', 1, 'safad', 25.22314, 56.29944),
(3290988, 3292969, 'AE', 'Sabkhah', 1, 'sabkhah', 23.3, 53.85),
(3291035, 3292879, 'AE', 'Rūl Ḑadnā', 1, 'rul-dadna', 25.55481, 56.34546),
(3291040, 3292879, 'AE', 'Rughaylāt', 1, 'rughaylat', 25.10552, 56.3563),
(3291047, 3292879, 'AE', 'Riyāmah', 1, 'riyamah', 25.54564, 56.05836),
(3291052, 3291075, 'AE', 'Rimá', 1, 'rima', 25.16784, 56.11795),
(3291074, 3291075, 'AE', 'Ras Al Khaimah City', 1, 'ras-al-khaimah-city', 25.78953, 55.9432),
(3291085, 3292879, 'AE', 'Ramlah', 1, 'ramlah', 25.35979, 56.04452),
(3291107, 3291075, 'AE', 'Rafaq', 1, 'rafaq', 24.87471, 56.24559),
(3291110, 3292673, 'AE', 'Rafā‘', 1, 'rafa', 25.34701, 56.35014),
(3291116, 3292969, 'AE', 'Quţūf', 1, 'qutuf', 23.10971, 53.72738),
(3291125, 3292969, 'AE', 'Qurmidah', 1, 'qurmidah', 23.11957, 53.82855),
(3291129, 3291075, 'AE', 'Qurm', 1, 'qurm', 25.91139, 56.06417),
(3291136, 3291075, 'AE', 'Qūr', 1, 'qur', 24.91214, 56.09566),
(3291146, 3292969, 'AE', 'Qu‘aysah', 1, 'qu-aysah', 22.9941, 54.22183),
(3291147, 3291075, 'AE', 'Quar Al Qahlish', 1, 'quar-al-qahlish', 25.985, 56.08639),
(3291152, 3292224, 'AE', 'Qimah', 1, 'qimah', 24.78668, 56.14143),
(3291155, 3292673, 'AE', 'Qidfa‘', 1, 'qidfa', 25.30426, 56.37034),
(3291159, 3292969, 'AE', 'Qaţţārah', 1, 'qattarah', 24.25993, 55.75566),
(3291199, 3291075, 'AE', 'Qabas', 1, 'qabas', 26.03435, 56.12302),
(3291209, 3292969, 'AE', 'Nuqayrah', 1, 'nuqayrah', 23.30021, 54.09107),
(3291215, 3292673, 'AE', 'Nuhayy', 1, 'nuhayy', 25.27074, 56.36242),
(3291242, 3292969, 'AE', 'Naqrah', 1, 'naqrah', 24.37645, 55.56032),
(3291265, 3292673, 'AE', 'Naḩwah', 1, 'nahwah', 25.26822, 56.28013),
(3291270, 3292969, 'AE', 'Nafīr', 1, 'nafir', 23.10393, 53.78919),
(3291279, 3292969, 'AE', 'Muzayri‘', 1, 'muzayri', 23.14355, 53.7881),
(3291299, 3292879, 'AE', 'Mu‘tariḑah', 1, 'mu-taridah', 25.50841, 56.11046),
(3291334, 3292879, 'AE', 'Murrah', 1, 'murrah', 25.19903, 56.22165),
(3291339, 3292673, 'AE', 'Murbaḩ', 1, 'murbah', 25.27623, 56.36256),
(3291340, 3292879, 'AE', 'Murbaḑ', 1, 'murbad', 25.3254, 56.13311),
(3291342, 3291075, 'AE', 'Muraytah', 1, 'muraytah', 25.40032, 56.05844),
(3291358, 3292969, 'AE', 'Mundafinah', 1, 'mundafinah', 24.11667, 55.8),
(3291363, 3291075, 'AE', 'Munay‘ī', 1, 'munay-i', 24.95135, 56.14997),
(3291374, 3292879, 'AE', 'Mukhtaraqah', 1, 'mukhtaraqah', 25.54092, 56.13066),
(3291376, 3292969, 'AE', 'Mūjib', 1, 'mujib', 23.11667, 53.68333),
(3291418, 3292673, 'AE', 'Nedaifi', 1, 'nedaifi', 25.36167, 56.34472),
(3291432, 3291075, 'AE', 'Minhā', 1, 'minha', 25.15745, 56.08011),
(3291434, 3291075, 'AE', 'Minazif', 1, 'minazif', 24.94256, 56.21074),
(3291443, 3292969, 'AE', 'Milqaţah', 1, 'milqatah', 23.06667, 53.53333),
(3291471, 3292969, 'AE', 'Mawşil', 1, 'mawsil', 23.01353, 54.15447),
(3291477, 3292969, 'AE', 'Mas‘ūdī', 1, 'mas-udi', 24.26627, 55.74123),
(3291489, 3292933, 'AE', 'Maşfūţ', 1, 'masfut', 24.81089, 56.10657),
(3291499, 3291075, 'AE', 'Māsah', 1, 'masah', 25.30319, 56.1649),
(3291501, 3291075, 'AE', 'Masāfī', 1, 'masafi', 25.30129, 56.16531),
(3291513, 3291075, 'AE', 'Marḩāmid', 1, 'marhamid', 25.09708, 56.03056),
(3291517, 3292969, 'AE', 'Marawwaḩ', 1, 'marawwah', 24.29457, 53.33069),
(3291526, 3291075, 'AE', 'Manqashah', 1, 'manqashah', 26.035, 56.14861),
(3291559, 3292969, 'AE', 'Maḩḑar Bin ‘Uşayyān', 1, 'mahdar-bin-usayyan', 22.93333, 54.31667),
(3291569, 3291075, 'AE', 'Maghribīyah', 1, 'maghribiyah', 25.2, 56.05),
(3291580, 3292969, 'AE', 'Zayed City', 1, 'zayed-city', 23.65416, 53.70522),
(3291588, 3292879, 'AE', 'Maydaq', 1, 'maydaq', 25.33912, 56.10494),
(3291598, 3292673, 'AE', 'Lūlayyah', 1, 'lulayyah', 25.39258, 56.35464),
(3291611, 3292969, 'AE', 'Liffah', 1, 'liffah', 24.29325, 53.22538),
(3291620, 3292673, 'AE', 'Layyah', 1, 'layyah', 25.35397, 55.37189),
(3291644, 3291075, 'AE', 'Kūb', 1, 'kub', 25.47018, 56.11886),
(3291672, 3292879, 'AE', 'Khulaybīyah', 1, 'khulaybiyah', 25.38124, 56.17358),
(3291693, 3291075, 'AE', 'Khawr Khuwayr', 1, 'khawr-khuwayr', 25.96577, 56.05471),
(3291694, 3292673, 'AE', 'Khawr Kalbā', 1, 'khawr-kalba', 25.03835, 56.36258),
(3291696, 3292673, 'AE', 'Khawr Fakkān', 1, 'khawr-fakkan', 25.33132, 56.34199),
(3291708, 3291075, 'AE', 'Khatt', 1, 'khatt', 25.61729, 56.01113),
(3291715, 3291075, 'AE', 'Kharrān', 1, 'kharran', 25.71617, 55.96776),
(3291730, 3292969, 'AE', 'Khannūr', 1, 'khannur', 23.10092, 53.60594),
(3291755, 3291075, 'AE', 'Khabākhib', 1, 'khabakhib', 25.452, 56.09376),
(3291756, 3292969, 'AE', 'Kayyah', 1, 'kayyah', 23.15696, 53.68541),
(3291763, 3292673, 'AE', 'Kalbā', 1, 'kalba', 25.07462, 56.35545),
(3291774, 3292969, 'AE', 'Jurayrah', 1, 'jurayrah', 22.94082, 54.31016),
(3291794, 3291075, 'AE', 'Al Jazīrah al Ḩamrā’', 1, 'al-jazirah-al-hamra', 25.7091, 55.80772),
(3291796, 3292969, 'AE', 'Jazīrah', 1, 'jazirah', 24.15, 53.7),
(3291799, 3292969, 'AE', 'Jayf', 1, 'jayf', 23.15786, 53.77762),
(3291835, 3292969, 'AE', 'Istayhah', 1, 'istayhah', 23.3161, 54.06718),
(3291840, 3291075, 'AE', 'Adhan', 1, 'adhan', 25.46012, 56.01256),
(3291844, 3292969, 'AE', 'Ḩuwaytayn', 1, 'huwaytayn', 23.11904, 53.92836),
(3291847, 3291075, 'AE', 'Huwaylāt', 1, 'huwaylat', 24.87664, 56.17372),
(3291848, 3292969, 'AE', 'Ḩuwaylah', 1, 'huwaylah', 23.15201, 53.82462),
(3291865, 3292224, 'AE', 'Hunaywah', 1, 'hunaywah', 25.19474, 55.59449),
(3291871, 3292969, 'AE', 'Ḩumar', 1, 'humar', 23.08216, 53.58421),
(3291891, 3292673, 'AE', 'Ḩiyāwah', 1, 'hiyawah', 25.36043, 56.34773),
(3291902, 3292969, 'AE', 'Hillī', 1, 'hilli', 24.28473, 55.7633),
(3291925, 3292879, 'AE', 'Ḩayl', 1, 'hayl', 25.09223, 56.24418),
(3291926, 3292224, 'AE', 'Ḩayl', 1, 'hayl', 24.7892, 56.11462),
(3291928, 3292673, 'AE', 'Ḩayāt', 1, 'hayat', 25.05814, 56.34575),
(3291939, 3291075, 'AE', 'Ḩatīyah', 1, 'hatiyah', 25.40374, 56.1446),
(3291951, 3292673, 'AE', 'Ḩarrah', 1, 'harrah', 24.99039, 56.21669),
(3291987, 3292969, 'AE', 'Ḩamīm', 1, 'hamim', 22.95805, 54.29721),
(3291996, 3292969, 'AE', 'Ḩamarūr', 1, 'hamarur', 23.09525, 53.60715),
(3292030, 3292969, 'AE', 'Ḩafīf', 1, 'hafif', 23.1461, 53.84528),
(3292036, 3292879, 'AE', 'Ḩafarah', 1, 'hafarah', 25.04106, 56.31485),
(3292051, 3292969, 'AE', 'Ḩabshān', 1, 'habshan', 23.94242, 53.63612),
(3292053, 3291075, 'AE', 'Ḩabḩab', 1, 'habhab', 25.61564, 56.00441),
(3292055, 3291075, 'AE', 'Gragrah', 1, 'gragrah', 25.46583, 55.97803),
(3292064, 3292969, 'AE', 'Ghurbah', 1, 'ghurbah', 24.28738, 53.27171),
(3292071, 3292879, 'AE', 'Ghurah', 1, 'ghurah', 25.21966, 56.2076),
(3292073, 3291075, 'AE', 'Ghamarah', 1, 'ghamarah', 25.29419, 56.17009),
(3292082, 3291075, 'AE', 'Al Ghābah', 1, 'al-ghabah', 26.04889, 56.15333),
(3292092, 3291075, 'AE', 'Ghayl', 1, 'ghayl', 25.40174, 56.06806),
(3292093, 3292673, 'AE', 'Ghayl', 1, 'ghayl', 25.00677, 56.3329),
(3292119, 3291075, 'AE', 'Ghalīlah', 1, 'ghalilah', 25.9975, 56.07444),
(3292123, 3291075, 'AE', 'Ghāghah', 1, 'ghaghah', 25.76667, 56.06667),
(3292150, 3291075, 'AE', 'Ghadf', 1, 'ghadf', 25.28358, 56.1741),
(3292168, 3291075, 'AE', 'Fayyāḑ', 1, 'fayyad', 24.95775, 56.20598),
(3292173, 3291075, 'AE', 'Fa’y', 1, 'fa-y', 25.1707, 56.10159),
(3292180, 3291075, 'AE', 'Fashrah', 1, 'fashrah', 24.8841, 56.20528),
(3292182, 3292969, 'AE', 'Farīq Ţarīf', 1, 'fariq-tarif', 24.05, 53.78333),
(3292184, 3292969, 'AE', 'Farīq', 1, 'fariq', 24.20058, 53.53465),
(3292187, 3292879, 'AE', 'Furfār', 1, 'furfar', 25.14844, 56.22242),
(3292192, 3292879, 'AE', 'Far‘ah', 1, 'far-ah', 25.13678, 56.23731),
(3292195, 3291075, 'AE', 'Fāqī', 1, 'faqi', 25.40254, 56.14511),
(3292202, 3290595, 'AE', 'Falaj al Mu‘allā', 1, 'falaj-al-mu-alla', 25.35401, 55.85332),
(3292223, 3292224, 'AE', 'Dubai', 1, 'dubai', 25.07725, 55.30927),
(3292231, 3292879, 'AE', 'Dibba Al-Fujairah', 1, 'dibba-al-fujairah', 25.59246, 56.26176),
(3292234, 3291075, 'AE', 'Diqdāqah', 1, 'diqdaqah', 25.6656, 55.96905),
(3292239, 3292879, 'AE', 'Dibba Al-Hisn', 1, 'dibba-al-hisn', 25.61955, 56.27291),
(3292257, 3290595, 'AE', 'Dhad al Arab', 1, 'dhad-al-arab', 25.61667, 55.85),
(3292263, 3291075, 'AE', 'Daynah', 1, 'daynah', 25.04711, 56.00895),
(3292266, 3291075, 'AE', 'Ḑāyah', 1, 'dayah', 25.88784, 56.05824),
(3292272, 3292969, 'AE', 'Da‘sah', 1, 'da-sah', 24.27839, 52.62369),
(3292282, 3291075, 'AE', 'Dārah', 1, 'darah', 25.10083, 56.05722),
(3292293, 3292879, 'AE', 'Ḑāhir', 1, 'dahir', 25.53342, 56.15499),
(3292294, 3292969, 'AE', 'Dāhin', 1, 'dahin', 23.07734, 54.08422),
(3292301, 3291075, 'AE', 'Daftah', 1, 'daftah', 25.27226, 56.18353),
(3292309, 3292879, 'AE', 'Ḑadnā', 1, 'dadna', 25.52422, 56.35868),
(3292313, 3291075, 'AE', 'Ḑab‘ah', 1, 'dab-ah', 25.48246, 56.13867),
(3292363, 3292969, 'AE', 'Bū Līfīyāt', 1, 'bu-lifiyat', 24.23333, 53.81667),
(3292368, 3292879, 'AE', 'Bulaydah', 1, 'bulaydah', 25.22388, 56.20221),
(3292476, 3292969, 'AE', 'Bin Aḩmad', 1, 'bin-ahmad', 24.48162, 55.69089),
(3292508, 3291075, 'AE', 'Bidīyah', 1, 'bidiyah', 25.675, 55.97194),
(3292516, 3291075, 'AE', 'Bidá', 1, 'bida', 25.76453, 55.97712),
(3292562, 3291075, 'AE', 'Baqal', 1, 'baqal', 25.68913, 56.08768),
(3292596, 3292879, 'AE', 'Badīyah', 1, 'badiyah', 25.43227, 56.34574),
(3292617, 3292969, 'AE', '‘Ayn al Fayḑah', 1, 'ayn-al-faydah', 24.08333, 55.68333),
(3292621, 3291075, 'AE', '‘Ayīm', 1, 'ayim', 25.43998, 56.06869),
(3292630, 3290595, 'AE', '‘Uwaynāt', 1, 'uwaynat', 25.36585, 55.85619),
(3292635, 3292969, 'AE', '‘Awāfī', 1, 'awafi', 24.3, 52.56667),
(3292641, 3292969, 'AE', '‘Aţţāb', 1, 'attab', 23.1518, 53.8811),
(3292643, 3291075, 'AE', 'Athabāt', 1, 'athabat', 25.16356, 56.09619),
(3292646, 3292969, 'AE', 'As Sulaymāt', 1, 'as-sulaymat', 24.22194, 55.60306),
(3292647, 3292969, 'AE', 'As Slabeikh', 1, 'as-slabeikh', 24.18333, 55.21667),
(3292659, 3292969, 'AE', 'As Sād', 1, 'as-sad', 24.15, 55.76667),
(3292671, 3292969, 'AE', 'Ash Shibhānah', 1, 'ash-shibhanah', 24.13333, 51.65),
(3292672, 3292673, 'AE', 'Sharjah', 1, 'sharjah', 25.33737, 55.41206),
(3292674, 3291075, 'AE', 'Ash Sha‘m', 1, 'ash-sha-m', 26.0279, 56.08352),
(3292677, 3292879, 'AE', '‘Ashashah', 1, 'ashashah', 25.45934, 56.16401),
(3292680, 3291075, 'AE', '‘Asamah', 1, 'asamah', 25.39831, 56.15073),
(3292688, 3292969, 'AE', 'Ar Ruways', 1, 'ar-ruways', 24.11028, 52.73056),
(3292689, 3292879, 'AE', 'Ar Rūl', 1, 'ar-rul', 25.60106, 56.3228),
(3292690, 3292673, 'AE', 'Ar Rufayşah', 1, 'ar-rufaysah', 25.34518, 56.3225),
(3292692, 3291075, 'AE', 'Ar Rams', 1, 'ar-rams', 25.87658, 56.01862),
(3292709, 3292969, 'AE', '‘Arādah', 1, 'aradah', 22.99231, 53.42892),
(3292717, 3292879, 'AE', '‘Aqqah', 1, 'aqqah', 25.49867, 56.3583),
(3292730, 3291075, 'AE', 'Sha‘bīyat Naşlah', 1, 'sha-biyat-naslah', 24.86586, 56.26085),
(3292731, 3292969, 'AE', 'An Nashshāsh', 1, 'an-nashshash', 23.0811, 54.03635),
(3292744, 3292969, 'AE', 'Al Wathbah', 1, 'al-wathbah', 24.25958, 54.70781),
(3292748, 3292879, 'AE', 'Al ‘Uyaynah', 1, 'al-uyaynah', 25.45283, 56.16879),
(3292752, 3291075, 'AE', 'Al Usaylī', 1, 'al-usayli', 25.62676, 56.00814),
(3292761, 3292879, 'AE', 'Al Qurayyah', 1, 'al-qurayyah', 25.23779, 56.36128),
(3292765, 3291075, 'AE', 'Al Qīr', 1, 'al-qir', 26.03244, 56.10445),
(3292766, 3292969, 'AE', 'Al Qīmī', 1, 'al-qimi', 24.24914, 55.74582),
(3292770, 3292969, 'AE', 'Al Qaia', 1, 'al-qaia', 24.51926, 55.75606),
(3292774, 3292969, 'AE', 'Al Muwayqi‘ī', 1, 'al-muwayqi-i', 24.23333, 55.7),
(3292777, 3292969, 'AE', 'Al Mu‘taraḑ', 1, 'al-mu-tarad', 24.219, 55.73989),
(3292783, 3292969, 'AE', 'Al Mughayrā’', 1, 'al-mughayra', 24.07843, 53.53842),
(3292788, 3291075, 'AE', 'Al Matāf', 1, 'al-mataf', 25.83333, 55.98333),
(3292789, 3292969, 'AE', 'Al Mashrūb', 1, 'al-mashrub', 23.07646, 54.01347),
(3292791, 3292969, 'AE', 'Al Māriyah al Gharbīyah', 1, 'al-mariyah-al-gharbiyah', 23.10265, 53.58185),
(3292793, 3292969, 'AE', 'Al Māriyah', 1, 'al-mariyah', 23.13848, 53.7426),
(3292795, 3292969, 'AE', 'Al Marfa’', 1, 'al-marfa', 24.09911, 53.49077),
(3292799, 3292933, 'AE', 'Al Manāmah', 1, 'al-manamah', 25.3299, 56.02188),
(3292802, 3291075, 'AE', 'Al Mahamm', 1, 'al-mahamm', 25.675, 55.99028),
(3292808, 3292879, 'AE', 'Akkamyah', 1, 'akkamyah', 25.60151, 56.3047),
(3292816, 3292969, 'AE', 'Al Khīs', 1, 'al-khis', 23.00848, 54.19626),
(3292818, 3292969, 'AE', 'Al Khaznah', 1, 'al-khaznah', 24.16797, 55.11157),
(3292822, 3292969, 'AE', 'Al Khatim', 1, 'al-khatim', 24.2, 54.83333),
(3292825, 3291075, 'AE', 'Al Khārī', 1, 'al-khari', 25.09745, 56.02625),
(3292826, 3292673, 'AE', 'Al Khān', 1, 'al-khan', 25.33141, 55.35901),
(3292833, 3292673, 'AE', 'Al Jazīrah', 1, 'al-jazirah', 25.35, 55.36667),
(3292836, 3292969, 'AE', 'Al Jaḩr', 1, 'al-jahr', 24.25, 55.58333),
(3292840, 3292969, 'AE', 'Al ‘Idd', 1, 'al-idd', 23.07989, 53.55245),
(3292850, 3292673, 'AE', 'Al Ḩayrah', 1, 'al-hayrah', 25.38148, 55.41955),
(3292851, 3291075, 'AE', 'Al Hayr', 1, 'al-hayr', 25.97861, 56.08528),
(3292854, 3291075, 'AE', 'Ḩayl', 1, 'hayl', 25.70498, 55.98701),
(3292856, 3292673, 'AE', 'Al Ḩamrīyah', 1, 'al-hamriyah', 25.47819, 55.53377),
(3292860, 3292879, 'AE', 'Al Ḩalāh', 1, 'al-halah', 25.47738, 56.18244),
(3292862, 3292224, 'AE', 'Ḩattā', 1, 'hatta', 24.80073, 56.12726),
(3292865, 3292969, 'AE', 'Al Ḩādhī', 1, 'al-hadhi', 23.10642, 53.99527),
(3292869, 3291075, 'AE', 'Al Jaddah', 1, 'al-jaddah', 25.99611, 56.08417),
(3292871, 3292879, 'AE', 'Al Ghurfah', 1, 'al-ghurfah', 25.12496, 56.35381),
(3292877, 3291075, 'AE', 'Al Fulayyah', 1, 'al-fulayyah', 25.73481, 55.98284),
(3292878, 3292879, 'AE', 'Al Fujairah City', 1, 'al-fujairah-city', 25.11641, 56.34141),
(3292880, 3292969, 'AE', 'Al Fīyay', 1, 'al-fiyay', 24.29801, 53.2114),
(3292883, 3291075, 'AE', 'Al Fay‘', 1, 'al-fay', 26.02139, 56.09139),
(3292885, 3291075, 'AE', 'Al Fara‘', 1, 'al-fara', 25.4143, 56.09123),
(3292888, 3291075, 'AE', 'Al Faḩlayn', 1, 'al-fahlayn', 25.68412, 55.96749),
(3292898, 3292879, 'AE', 'Biţnah', 1, 'bitnah', 25.18951, 56.23516),
(3292911, 3291075, 'AE', 'Al ‘Ayn al Ghumūr', 1, 'al-ayn-al-ghumur', 24.95951, 56.31585),
(3292913, 3292969, 'AE', 'Al Ain City', 1, 'al-ain-city', 24.19167, 55.76056),
(3292914, 3292673, 'AE', 'Al ‘Awdah', 1, 'al-awdah', 25.38068, 56.30921),
(3292915, 3292969, 'AE', 'Al Aţīr', 1, 'al-atir', 23.16261, 53.73617),
(3292932, 3292933, 'AE', 'Ajman City', 1, 'ajman-city', 25.40177, 55.47878),
(3292953, 3292673, 'AE', 'Adh Dhayd', 1, 'adh-dhayd', 25.28812, 55.88157),
(3292954, 3291075, 'AE', 'Adh Dharbānīyah', 1, 'adh-dharbaniyah', 25.78333, 55.93333),
(3292968, 3292969, 'AE', 'Abu Dhabi', 1, 'abu-dhabi', 24.45118, 54.39696),
(3293003, 3292879, 'AE', '‘Abādilah', 1, 'abadilah', 25.45353, 56.18991),
(3388439, 3291075, 'AE', 'Ḩārat ‘Awālī', 1, 'harat-awali', 26.01727, 56.13276),
(3388440, 3291075, 'AE', 'Al Ḩulaylah', 1, 'al-hulaylah', 25.88556, 56.05222),
(3388441, 3291075, 'AE', 'Al Khashfah', 1, 'al-khashfah', 26.02833, 56.13944),
(3388442, 3291075, 'AE', 'Wayb Ḩawf', 1, 'wayb-hawf', 26.02889, 56.12111),
(3388443, 3291075, 'AE', 'Al Ghabām', 1, 'al-ghabam', 26.03278, 56.15222),
(3388444, 3291075, 'AE', 'Qaf’ah', 1, 'qaf-ah', 26.03806, 56.10861),
(3388445, 3291075, 'AE', 'Sharyāt', 1, 'sharyat', 26.04306, 56.10806),
(3389286, 3292969, 'AE', 'Al Mafraq', 1, 'al-mafraq', 24.32965, 54.60764),
(3389287, 3292969, 'AE', 'Al Muqaţţarah', 1, 'al-muqattarah', 24.26762, 54.56193),
(3389288, 3292969, 'AE', 'Madīnat an Nahḑah', 1, 'madinat-an-nahdah', 24.23213, 54.74469),
(3389388, 3292969, 'AE', 'Ash Shahāmah', 1, 'ash-shahamah', 24.54977, 54.68091),
(3389992, 3291075, 'AE', 'Mawrid', 1, 'mawrid', 25.42871, 56.11457),
(3390001, 3291075, 'AE', 'Qārat ad Dum', 1, 'qarat-ad-dum', 25.86028, 56.025),
(3390005, 3291075, 'AE', 'Yinainir', 1, 'yinainir', 25.90806, 56.17),
(3390010, 3291075, 'AE', 'Ra’s', 1, 'ra-s', 25.79333, 56.14833),
(3390011, 3291075, 'AE', 'Magam', 1, 'magam', 25.78361, 56.15056),
(3390013, 3292879, 'AE', 'Şidaqah', 1, 'sidaqah', 25.63587, 56.16775),
(3390235, 3292969, 'AE', 'Yāfūr', 1, 'yafur', 24.26954, 54.61149),
(3390258, 3291075, 'AE', 'Al Ghashbān', 1, 'al-ghashban', 26.0425, 56.11861),
(3390259, 3291075, 'AE', 'Ghubbat Khawrah', 1, 'ghubbat-khawrah', 26.04278, 56.135),
(3394141, 3292224, 'AE', 'Qarayţaysah', 1, 'qaraytaysah', 24.87077, 55.54905),
(3394142, 3292224, 'AE', 'Margham', 1, 'margham', 24.89868, 55.62402),
(3394224, 3292673, 'AE', 'Ash Shu‘ayb', 1, 'ash-shu-ayb', 24.74706, 55.81631),
(3394228, 3292224, 'AE', 'Al Faq‘', 1, 'al-faq', 24.71016, 55.6218),
(3394346, 3292969, 'AE', 'Al Khabb', 1, 'al-khabb', 24.58969, 55.74627),
(3394524, 3292969, 'AE', '‘Aqbīyah', 1, 'aqbiyah', 24.16111, 55.65694),
(3394632, 3292969, 'AE', 'Mazyad', 1, 'mazyad', 24.03694, 55.8425),
(3398760, 3292969, 'AE', 'Majrá al Ghāf', 1, 'majra-al-ghaf', 24.06582, 51.76114),
(3408681, 3292673, 'AE', 'Ḩaşat al Bidīyah', 1, 'hasat-al-bidiyah', 25.32728, 55.97992),
(3412433, 3292969, 'AE', 'Za‘bah', 1, 'za-bah', 23.71833, 55.50694),
(3412434, 3292969, 'AE', 'Ţawī Khadaraq', 1, 'tawi-khadaraq', 23.72556, 55.52889),
(3412497, 3291075, 'AE', 'Al Masāfirah', 1, 'al-masafirah', 25.68333, 55.95),
(3412513, 3291075, 'AE', 'Ḩām Ḩām', 1, 'ham-ham', 25.68611, 55.96389),
(3412514, 3290595, 'AE', 'Ar Rā‘fah', 1, 'ar-ra-fah', 25.61633, 55.7026),
(3412516, 3291075, 'AE', 'Al Ḩamrānīyah', 1, 'al-hamraniyah', 25.61139, 55.90028),
(3412868, 3292969, 'AE', 'Bū Rays', 1, 'bu-rays', 23.6031, 53.72849),
(3412871, 3292969, 'AE', 'Badiyah', 1, 'badiyah', 23.61619, 53.84309),
(3412875, 3292969, 'AE', 'Sikkat al Khayl', 1, 'sikkat-al-khayl', 23.65053, 53.62049),
(3412981, 3292224, 'AE', 'Al Lusaylī', 1, 'al-lusayli', 24.93138, 55.47531),
(3413256, 3292969, 'AE', 'Suwayḩān', 1, 'suwayhan', 24.46235, 55.33715),
(3416468, 3292969, 'AE', 'Bū Ḩaşā', 1, 'bu-hasa', 23.55386, 53.31388),
(9691106, 3292224, 'AE', 'Al Barsha First', 1, 'al-barsha-first', 25.11311, 55.1978),
(9691113, 3292224, 'AE', 'The Palm Jumeirah', 1, 'the-palm-jumeirah', 25.11607, 55.13506),
(9692640, 3292969, 'AE', 'Al Raha Corniche', 1, 'al-raha-corniche', 24.44246, 54.44653),
(9951086, 3292969, 'AE', 'Jebel Dhanna', 1, 'jebel-dhanna', 24.1651, 52.642),
(9951109, 3292879, 'AE', 'Al Aqah', 1, 'al-aqah', 25.4967, 56.3564),
(10289825, 3292224, 'AE', 'Bur Dubai', 1, 'bur-dubai', 25.26038, 55.29891),
(10632355, 3292879, 'AE', 'Theeb', 1, 'theeb', 25.24501, 56.34206),
(10632358, 3292879, 'AE', 'Al Gissemari', 1, 'al-gissemari', 25.14342, 56.2484),
(11019328, 3292673, 'AE', 'Girath', 1, 'girath', 25.26089, 56.35435),
(11019353, 3292879, 'AE', 'Al Fuqait', 1, 'al-fuqait', 25.59966, 56.34249),
(11019359, 3292879, 'AE', 'Tawian', 1, 'tawian', 25.55675, 56.07647),
(11019360, 3292879, 'AE', 'Jareef', 1, 'jareef', 25.51417, 56.07194),
(11019361, 3292879, 'AE', 'Sram', 1, 'sram', 25.49818, 56.05716),
(11019375, 3292879, 'AE', 'Yalah', 1, 'yalah', 25.41517, 56.15496),
(11019378, 3292879, 'AE', 'Thoban', 1, 'thoban', 25.30332, 56.02792),
(11019380, 3292879, 'AE', 'Al Hinya', 1, 'al-hinya', 25.35093, 56.02535),
(11030638, 3292969, 'AE', 'Al Mariah United Group', 1, 'al-mariah-united-group', 24.49424, 54.36767),
(11051665, 3290595, 'AE', 'Al Ḩazaywah', 1, 'al-hazaywah', 25.52584, 55.66266),
(11051668, 3290595, 'AE', 'Al ‘Adhīb', 1, 'al-adhib', 25.49843, 55.66801),
(11052059, 3290595, 'AE', 'Ar Ramlah', 1, 'ar-ramlah', 25.50641, 55.58095),
(11052062, 3290595, 'AE', 'As Salamah', 1, 'as-salamah', 25.49242, 55.5908),
(11052063, 3290595, 'AE', 'Al Abraq', 1, 'al-abraq', 25.50401, 55.55663),
(11052070, 3290595, 'AE', 'As Surrah', 1, 'as-surrah', 25.44573, 55.63109),
(11052071, 3290595, 'AE', 'Muhadhdhib', 1, 'muhadhdhib', 25.43355, 55.66856),
(11052072, 3290595, 'AE', 'Kābir', 1, 'kabir', 25.4322, 55.70513),
(11052073, 3290595, 'AE', 'Al Labsah', 1, 'al-labsah', 25.42762, 55.73),
(11052075, 3290595, 'AE', 'Ar Rāshidīyah', 1, 'ar-rashidiyah', 25.39017, 55.84118),
(11057551, 3292969, 'AE', 'Khalifah A City', 1, 'khalifah-a-city', 24.42588, 54.605),
(11308747, 3292879, 'AE', 'Ras Dibba', 1, 'ras-dibba', 25.60549, 56.305),
(11308860, 3290595, 'AE', 'Biyātah', 1, 'biyatah', 25.41463, 55.79832),
(12973323, 3292969, 'AE', 'Palm Jebel Ali', 1, 'palm-jebel-ali', 25.00582, 54.98829),
(14048854, 3292969, 'AE', 'Ghayathi', 1, 'ghayathi', 23.8425, 52.81),
(14048855, 3292969, 'AE', 'Ghantoot', 1, 'ghantoot', 24.85386, 54.84641),
(14048857, 3292224, 'AE', 'Bab Al Shams', 1, 'bab-al-shams', 24.81689, 55.23188),
(14524601, 3292224, 'AE', 'Jebel Ali', 1, 'jebel-ali', 25.00255, 55.10811),
(15042052, 3292969, 'AE', 'Bani Yas City', 1, 'bani-yas-city', 24.30978, 54.62944),
(15042053, 3292969, 'AE', 'Musaffah', 1, 'musaffah', 24.35893, 54.48267),
(15047416, 3292969, 'AE', 'Al Shamkhah City', 1, 'al-shamkhah-city', 24.39268, 54.70779),
(15047417, 3292879, 'AE', 'Reef Al Fujairah City', 1, 'reef-al-fujairah-city', 25.14479, 56.24764);