REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('MT', 'Malta', 'Malta', 'malta', '356', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(11299700, 'MT', 'Attard', 1, 'attard'),
(11299701, 'MT', 'Balzan', 1, 'balzan'),
(11299702, 'MT', 'Il-Birgu', 1, 'il-birgu'),
(11299703, 'MT', 'Birkirkara', 1, 'birkirkara'),
(11299704, 'MT', 'Birżebbuġa', 1, 'birzebbuga'),
(11299705, 'MT', 'Bormla', 1, 'bormla'),
(11299706, 'MT', 'Dingli', 1, 'dingli'),
(11299707, 'MT', 'Il-Fgura', 1, 'il-fgura'),
(11299708, 'MT', 'Floriana', 1, 'floriana'),
(11299709, 'MT', 'Il-Fontana', 1, 'il-fontana'),
(11299710, 'MT', 'Għajnsielem', 1, 'ghajnsielem'),
(11299711, 'MT', 'L-Għarb', 1, 'l-gharb'),
(11299712, 'MT', 'Ħal Għargħur', 1, 'hal-gharghur'),
(11299713, 'MT', 'L-Għasri', 1, 'l-ghasri'),
(11299714, 'MT', 'Ħal Għaxaq', 1, 'hal-ghaxaq'),
(11299715, 'MT', 'Il-Gudja', 1, 'il-gudja'),
(11299716, 'MT', 'Il-Gżira', 1, 'il-gzira'),
(11299717, 'MT', 'Il-Ħamrun', 1, 'il-hamrun'),
(11299718, 'MT', 'L-Iklin', 1, 'l-iklin'),
(11299719, 'MT', 'L-Imdina', 1, 'l-imdina'),
(11299720, 'MT', 'L-Imġarr', 1, 'l-imgarr'),
(11299721, 'MT', 'L-Imqabba', 1, 'l-imqabba'),
(11299722, 'MT', 'L-Imsida', 1, 'l-imsida'),
(11299723, 'MT', 'Mtarfa', 1, 'mtarfa'),
(11299724, 'MT', 'Senglea', 1, 'senglea'),
(11299725, 'MT', 'Il-Kalkara', 1, 'il-kalkara'),
(11299726, 'MT', 'Ta’ Kerċem', 1, 'ta-kercem'),
(11299727, 'MT', 'Kirkop', 1, 'kirkop'),
(11299728, 'MT', 'Lija', 1, 'lija'),
(11299729, 'MT', 'Luqa', 1, 'luqa'),
(11299730, 'MT', 'Il-Marsa', 1, 'il-marsa'),
(11299731, 'MT', 'Marsaskala', 1, 'marsaskala'),
(11299732, 'MT', 'Marsaxlokk', 1, 'marsaxlokk'),
(11299733, 'MT', 'Il-Mellieħa', 1, 'il-mellieha'),
(11299734, 'MT', 'Il-Mosta', 1, 'il-mosta'),
(11299735, 'MT', 'Il-Munxar', 1, 'il-munxar'),
(11299736, 'MT', 'In-Nadur', 1, 'in-nadur'),
(11299737, 'MT', 'In-Naxxar', 1, 'in-naxxar'),
(11299738, 'MT', 'Paola', 1, 'paola'),
(11299739, 'MT', 'Pembroke', 1, 'pembroke'),
(11299740, 'MT', 'Tal-Pietà', 1, 'tal-pieta'),
(11299741, 'MT', 'Il-Qala', 1, 'il-qala'),
(11299742, 'MT', 'Qormi', 1, 'qormi'),
(11299743, 'MT', 'Il-Qrendi', 1, 'il-qrendi'),
(11299744, 'MT', 'Ir-Rabat', 1, 'ir-rabat'),
(11299745, 'MT', 'Victoria', 1, 'victoria'),
(11299746, 'MT', 'Safi', 1, 'safi'),
(11299747, 'MT', 'Saint John', 1, 'saint-john'),
(11299748, 'MT', 'Saint Julian', 1, 'saint-julian'),
(11299749, 'MT', 'Saint Lawrence', 1, 'saint-lawrence'),
(11299750, 'MT', 'Saint Lucia', 1, 'saint-lucia'),
(11299751, 'MT', 'Saint Paul’s Bay', 1, 'saint-paul-s-bay'),
(11299752, 'MT', 'Saint Venera', 1, 'saint-venera'),
(11299753, 'MT', 'Sannat', 1, 'sannat'),
(11299754, 'MT', 'Is-Siġġiewi', 1, 'is-siggiewi'),
(11299755, 'MT', 'Tas-Sliema', 1, 'tas-sliema'),
(11299756, 'MT', 'Is-Swieqi', 1, 'is-swieqi'),
(11299757, 'MT', 'Tarxien', 1, 'tarxien'),
(11299758, 'MT', 'Ta’ Xbiex', 1, 'ta-xbiex'),
(11299759, 'MT', 'Ix-Xagħra', 1, 'ix-xaghra'),
(11299760, 'MT', 'Ix-Xewkija', 1, 'ix-xewkija'),
(11299761, 'MT', 'Ix-Xgħajra', 1, 'ix-xghajra'),
(11299762, 'MT', 'Ħaż-Żabbar', 1, 'haz-zabbar'),
(11299763, 'MT', 'Ħaż-Żebbuġ', 1, 'haz-zebbug'),
(11299764, 'MT', 'Iż-Żebbuġ', 1, 'iz-zebbug'),
(11299765, 'MT', 'Iż-Żejtun', 1, 'iz-zejtun'),
(11299766, 'MT', 'Iż-Żurrieq', 1, 'iz-zurrieq'),
(11334638, 'MT', 'Valletta', 1, 'valletta');

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 
(5562247, 11299732, 'MT', 'Marsaxlokk', 1, 'marsaxlokk', 35.84194, 14.54306),
(5562250, 11299766, 'MT', 'Żurrieq', 1, 'zurrieq', 35.83111, 14.47417),
(5562254, 11299731, 'MT', 'Żonqor', 1, 'zonqor', 35.87083, 14.565),
(5562258, 11299765, 'MT', 'Żejtun', 1, 'zejtun', 35.85583, 14.53306),
(5562260, 11299764, 'MT', 'Żebbuġ', 1, 'zebbug', 36.07222, 14.23583),
(5562261, 11299763, 'MT', 'Haz-Zebbug', 1, 'haz-zebbug', 35.87194, 14.44111),
(5562262, 11299720, 'MT', 'Iż-Żebbiegħ', 1, 'iz-zebbiegh', 35.92028, 14.37944),
(5562266, 11299762, 'MT', 'Żabbar', 1, 'zabbar', 35.87611, 14.535),
(5562268, 11299732, 'MT', 'Xrobb il-Għaġin', 1, 'xrobb-il-ghagin', 35.84056, 14.56972),
(5562273, 11299761, 'MT', 'Xgħajra', 1, 'xghajra', 35.88556, 14.5475),
(5562274, 11299760, 'MT', 'Xewkija', 1, 'xewkija', 36.03278, 14.25806),
(5562280, 11299759, 'MT', 'Xagħra', 1, 'xaghra', 36.05, 14.26444),
(5562284, 11299734, 'MT', 'Wied l-Arkata', 1, 'wied-l-arkata', 35.92472, 14.41444),
(5562287, 11299725, 'MT', 'Wied Għammieq', 1, 'wied-ghammieq', 35.89694, 14.52944),
(5562288, 11299766, 'MT', 'Wied Fulija', 1, 'wied-fulija', 35.81833, 14.4775),
(5562290, 11299751, 'MT', 'Wardija Crossroads', 1, 'wardija-crossroads', 35.93806, 14.41111),
(5562305, 11334638, 'MT', 'Valletta', 1, 'valletta', 35.89968, 14.5148),
(5562320, 11299758, 'MT', 'Ta’ Xbiex', 1, 'ta-xbiex', 35.89917, 14.49444),
(5562332, 11299720, 'MT', 'Tas-Santi', 1, 'tas-santi', 35.90611, 14.35639),
(5562334, 11299754, 'MT', 'Tas-Salvatur', 1, 'tas-salvatur', 35.85083, 14.45194),
(5562342, 11299743, 'MT', 'Ta’ San Niklaw', 1, 'ta-san-niklaw', 35.83556, 14.44167),
(5562343, 11299742, 'MT', 'Ta’ San Ġwakkin', 1, 'ta-san-gwakkin', 35.88667, 14.46583),
(5562349, 11299757, 'MT', 'Tarxien', 1, 'tarxien', 35.86583, 14.515),
(5562362, 11299700, 'MT', 'Ta’ Qali', 1, 'ta-qali', 35.89417, 14.42722),
(5562369, 11299706, 'MT', 'Tal-Veċċa', 1, 'tal-vecca', 35.85611, 14.37694),
(5562373, 11299706, 'MT', 'Tal-Pitkal', 1, 'tal-pitkal', 35.86, 14.37056),
(5562374, 11299704, 'MT', 'Tal-Papa', 1, 'tal-papa', 35.81778, 14.52278),
(5562378, 11299731, 'MT', 'Tal-Munxar', 1, 'tal-munxar', 35.84944, 14.56222),
(5562380, 11299734, 'MT', 'Tal-Milord', 1, 'tal-milord', 35.92694, 14.39833),
(5562381, 11299744, 'MT', 'Tal-Merħla', 1, 'tal-merhla', 35.87889, 14.34389),
(5562384, 11299756, 'MT', 'Tal-Mejda', 1, 'tal-mejda', 35.91611, 14.46889),
(5562388, 11299746, 'MT', 'Tal-Liebru', 1, 'tal-liebru', 35.83472, 14.49444),
(5562391, 11299743, 'MT', 'Tal-Kittienija', 1, 'tal-kittienija', 35.83694, 14.46833),
(5562398, 11299756, 'MT', 'Tal-Ibraġ', 1, 'tal-ibrag', 35.91556, 14.46444),
(5562404, 11299763, 'MT', 'Tal-Ħlas', 1, 'tal-hlas', 35.87306, 14.45167),
(5562406, 11299742, 'MT', 'Tal-Ħandaq', 1, 'tal-handaq', 35.87083, 14.46806),
(5562420, 11299757, 'MT', 'Tal-Borġ', 1, 'tal-borg', 35.87111, 14.51472),
(5562421, 11299733, 'MT', 'Tal-Blata', 1, 'tal-blata', 35.96389, 14.39111),
(5562424, 11299765, 'MT', 'Tal-Barrani', 1, 'tal-barrani', 35.85639, 14.52028),
(5562429, 11299754, 'MT', 'Tal-Bajjada', 1, 'tal-bajjada', 35.83722, 14.42556),
(5562433, 11299720, 'MT', 'Ta’ l-Abatija', 1, 'ta-l-abatija', 35.9075, 14.35028),
(5562443, 11299754, 'MT', 'Ta’ Ħaxxluq', 1, 'ta-haxxluq', 35.84667, 14.445),
(5562447, 11299760, 'MT', 'Ta’ Ħamet', 1, 'ta-hamet', 36.04, 14.26472),
(5562463, 11299721, 'MT', 'Tad-Dawl', 1, 'tad-dawl', 35.85083, 14.47222),
(5562471, 11299745, 'MT', 'Taċ-Ċawla', 1, 'tac-cawla', 36.0375, 14.24056),
(5562474, 11299762, 'MT', 'Ta’ Ċantar', 1, 'ta-cantar', 35.86972, 14.53667),
(5562483, 11299734, 'MT', 'Ta’ Brared', 1, 'ta-brared', 35.92889, 14.40222),
(5562486, 11299729, 'MT', 'Ta’ Bir Miftuħ', 1, 'ta-bir-miftuh', 35.85278, 14.49056),
(5562501, 11299755, 'MT', 'Sliema', 1, 'sliema', 35.9125, 14.50194),
(5562504, 11299754, 'MT', 'Siġġiewi', 1, 'siggiewi', 35.85556, 14.43639),
(5562514, 11299725, 'MT', 'Santu Rokku', 1, 'santu-rokku', 35.89083, 14.54056),
(5562515, 11299711, 'MT', 'Santu Pietru', 1, 'santu-pietru', 36.06083, 14.20111),
(5562518, 11299752, 'MT', 'Santa Venera', 1, 'santa-venera', 35.89083, 14.47417),
(5562528, 11299750, 'MT', 'Saint Lucia', 1, 'saint-lucia', 36.04306, 14.21722),
(5562529, 11299750, 'MT', 'Santa Luċija', 1, 'santa-lucija', 35.86278, 14.5075),
(5562541, 11299751, 'MT', 'San Pawl il-Baħar', 1, 'san-pawl-il-bahar', 35.95064, 14.41561),
(5562545, 11299753, 'MT', 'Sannat', 1, 'sannat', 36.02444, 14.24278),
(5562551, 11299762, 'MT', 'San Leonardo', 1, 'san-leonardo', 35.87833, 14.55583),
(5562552, 11299749, 'MT', 'San Lawrenz', 1, 'san-lawrenz', 36.05556, 14.20361),
(5562553, 11299711, 'MT', 'San Katald', 1, 'san-katald', 36.06556, 14.20583),
(5562557, 11299748, 'MT', 'San Ġiljan', 1, 'san-giljan', 35.91839, 14.48977),
(5562598, 11299746, 'MT', 'Safi', 1, 'safi', 35.83306, 14.48472),
(5562617, 11299738, 'MT', 'Paola', 1, 'paola', 35.87306, 14.49889),
(5562619, 11299745, 'MT', 'Victoria', 1, 'victoria', 36.04444, 14.23972),
(5562620, 11299744, 'MT', 'Rabat', 1, 'rabat', 35.88152, 14.39872),
(5562622, 11299743, 'MT', 'Qrendi', 1, 'qrendi', 35.83472, 14.45833),
(5562629, 11299742, 'MT', 'Qormi', 1, 'qormi', 35.87601, 14.472),
(5562634, 11299764, 'MT', 'Qbajjar', 1, 'qbajjar', 36.07778, 14.25028),
(5562655, 11299741, 'MT', 'Qala', 1, 'qala', 36.03611, 14.30944),
(5562664, 11299740, 'MT', 'Pietà', 1, 'pieta', 35.89472, 14.495),
(5562679, 11299744, 'MT', 'Nigred', 1, 'nigred', 35.88278, 14.38583),
(5562683, 11299737, 'MT', 'Naxxar', 1, 'naxxar', 35.91361, 14.44361),
(5562687, 11299736, 'MT', 'Nadur', 1, 'nadur', 36.03778, 14.29417),
(5562693, 11299735, 'MT', 'Munxar', 1, 'munxar', 36.03, 14.23333),
(5562694, 11299723, 'MT', 'Imtarfa', 1, 'imtarfa', 35.89333, 14.39889),
(5562696, 11299722, 'MT', 'Msieraħ', 1, 'msierah', 35.9, 14.48333),
(5562698, 11299722, 'MT', 'Imsida', 1, 'imsida', 35.8925, 14.48278),
(5562701, 11299721, 'MT', 'Mqabba', 1, 'mqabba', 35.84763, 14.46824),
(5562704, 11299734, 'MT', 'Mosta', 1, 'mosta', 35.90917, 14.42556),
(5562707, 11299733, 'MT', 'Miżieb', 1, 'mizieb', 35.95, 14.35806),
(5562712, 11299706, 'MT', 'Misraħ Suffara', 1, 'misrah-suffara', 35.86861, 14.37361),
(5562713, 11299765, 'MT', 'Misraħ Strejnu', 1, 'misrah-strejnu', 35.85056, 14.54528),
(5562717, 11299746, 'MT', 'Misraħ Ħlantun', 1, 'misrah-hlantun', 35.82806, 14.49083),
(5562734, 11299720, 'MT', 'Mġarr', 1, 'mgarr', 36.02528, 14.295),
(5562735, 11299720, 'MT', 'Imġarr', 1, 'imgarr', 35.92056, 14.36639),
(5562744, 11299733, 'MT', 'Mellieħa', 1, 'mellieha', 35.95639, 14.36222),
(5562746, 11299719, 'MT', 'Imdina', 1, 'imdina', 35.88694, 14.4025),
(5562750, 11299731, 'MT', 'Marsaskala', 1, 'marsaskala', 35.8622, 14.56701),
(5562753, 11299764, 'MT', 'Marsalforn', 1, 'marsalforn', 36.07111, 14.25861),
(5562755, 11299730, 'MT', 'Marsa', 1, 'marsa', 35.87917, 14.49528),
(5562766, 11299733, 'MT', 'Manikata', 1, 'manikata', 35.94, 14.35333),
(5562774, 11299737, 'MT', 'Magħtab', 1, 'maghtab', 35.93639, 14.44778),
(5562781, 11299756, 'MT', 'Il-Madliena', 1, 'il-madliena', 35.9275, 14.46611),
(5562788, 11299729, 'MT', 'Luqa', 1, 'luqa', 35.85889, 14.48861),
(5562792, 11299724, 'MT', 'Senglea', 1, 'senglea', 35.8875, 14.51694),
(5562793, 11299720, 'MT', 'L-Iskorvit', 1, 'l-iskorvit', 35.91306, 14.35556),
(5562798, 11299751, 'MT', 'L-Imbordin', 1, 'l-imbordin', 35.94333, 14.37167),
(5562800, 11299718, 'MT', 'L-Iklin', 1, 'l-iklin', 35.90414, 14.45415),
(5562801, 11299728, 'MT', 'Lija', 1, 'lija', 35.90056, 14.44639),
(5562809, 11299744, 'MT', 'L-Andrijiet', 1, 'l-andrijiet', 35.88611, 14.36583),
(5562815, 11299727, 'MT', 'Kirkop', 1, 'kirkop', 35.84222, 14.48528),
(5562816, 11299726, 'MT', 'Kerċem', 1, 'kercem', 36.04194, 14.22667),
(5562830, 11299725, 'MT', 'Kalkara', 1, 'kalkara', 35.88917, 14.53278),
(5562831, 11299704, 'MT', 'Kalafrana', 1, 'kalafrana', 35.81806, 14.53444),
(5562837, 11299715, 'MT', 'Ix-Xlejli', 1, 'ix-xlejli', 35.85111, 14.50722),
(5562840, 11299756, 'MT', 'Ix-Xgħajriet', 1, 'ix-xghajriet', 35.92139, 14.46278),
(5562842, 11299744, 'MT', 'Ix-Xagħra ta’ l-Isqof', 1, 'ix-xaghra-ta-l-isqof', 35.86528, 14.40639),
(5562850, 11299756, 'MT', 'Swieqi', 1, 'swieqi', 35.9225, 14.48),
(5562860, 11299733, 'MT', 'Is-Sellum', 1, 'is-sellum', 35.96639, 14.35889),
(5562877, 11299733, 'MT', 'In-Naħħalija', 1, 'in-nahhalija', 35.93528, 14.34278),
(5562881, 11299711, 'MT', 'Il-Wilġa', 1, 'il-wilga', 36.0575, 14.20944),
(5562892, 11299734, 'MT', 'Il-Qattara', 1, 'il-qattara', 35.9025, 14.40889),
(5562897, 11299704, 'MT', 'Il-Qajjenza', 1, 'il-qajjenza', 35.83389, 14.535),
(5562904, 11299720, 'MT', 'Il-Palma', 1, 'il-palma', 35.93556, 14.36722),
(5562906, 11299766, 'MT', 'Il-Miżieb', 1, 'il-mizieb', 35.81722, 14.49528),
(5562933, 11299762, 'MT', 'Il-Ħofra', 1, 'il-hofra', 35.88194, 14.54472),
(5562941, 11299754, 'MT', 'Il-Ħamrija', 1, 'il-hamrija', 35.85889, 14.42333),
(5562943, 11299742, 'MT', 'Il-Ħammieri', 1, 'il-hammieri', 35.88222, 14.46083),
(5562946, 11299716, 'MT', 'Gżira', 1, 'gzira', 35.90583, 14.48806),
(5562947, 11299758, 'MT', 'Il-Gżira', 1, 'il-gzira', 35.9, 14.5),
(5562955, 11299708, 'MT', 'Floriana', 1, 'floriana', 35.89583, 14.50833),
(5562959, 11299754, 'MT', 'Il-Fawwara', 1, 'il-fawwara', 35.84028, 14.40194),
(5562961, 11299704, 'MT', 'Il-Brolli', 1, 'il-brolli', 35.83056, 14.52139),
(5562966, 11299702, 'MT', 'Vittoriosa', 1, 'vittoriosa', 35.89222, 14.51833),
(5562968, 11299762, 'MT', 'Il-Bidni', 1, 'il-bidni', 35.86889, 14.55444),
(5562971, 11299733, 'MT', 'Id-Daħar', 1, 'id-dahar', 35.97639, 14.33278),
(5562980, 11299744, 'MT', 'Ħofret ir-Rizz', 1, 'hofret-ir-rizz', 35.87333, 14.37667),
(5562989, 11299762, 'MT', 'Ħas-Sajd', 1, 'has-sajd', 35.87083, 14.54333),
(5562998, 11299717, 'MT', 'Ħamrun', 1, 'hamrun', 35.88472, 14.48444),
(5563004, 11299763, 'MT', 'Ħalq Dieri', 1, 'halq-dieri', 35.86861, 14.42361),
(5563009, 11299732, 'MT', 'Ħal Ġinwi', 1, 'hal-ginwi', 35.84667, 14.5425),
(5563020, 11299715, 'MT', 'Gudja', 1, 'gudja', 35.84917, 14.50306),
(5563031, 11299744, 'MT', 'Ġnien il-Kbir', 1, 'gnien-il-kbir', 35.87083, 14.39639),
(5563044, 11299744, 'MT', 'Għemieri', 1, 'ghemieri', 35.89222, 14.36583),
(5563046, 11299714, 'MT', 'Għaxaq', 1, 'ghaxaq', 35.84889, 14.51667),
(5563052, 11299713, 'MT', 'Għasri', 1, 'ghasri', 36.05778, 14.22639),
(5563055, 11299763, 'MT', 'Għar Ram', 1, 'ghar-ram', 35.87222, 14.45833),
(5563056, 11299754, 'MT', 'Għar Mundu', 1, 'ghar-mundu', 35.84944, 14.40611),
(5563062, 11299712, 'MT', 'Hal Gharghur', 1, 'hal-gharghur', 35.92409, 14.45118),
(5563063, 11299711, 'MT', 'Għarb', 1, 'gharb', 36.06, 14.20889),
(5563066, 11299713, 'MT', 'Għammar', 1, 'ghammar', 36.06611, 14.21833),
(5563074, 11299733, 'MT', 'Il-Qortin ta’ Għajn Żejtuna', 1, 'il-qortin-ta-ghajn-zejtuna', 35.96389, 14.37139),
(5563075, 11299733, 'MT', 'Għajn Żejtuna', 1, 'ghajn-zejtuna', 35.96639, 14.36722),
(5563079, 11299720, 'MT', 'Għajn Tuffieħa', 1, 'ghajn-tuffieha', 35.92583, 14.35333),
(5563081, 11299710, 'MT', 'Għajnsielem', 1, 'ghajnsielem', 36.02639, 14.285),
(5563085, 11299744, 'MT', 'Għajn Qajjied', 1, 'ghajn-qajjied', 35.88611, 14.38667),
(5563088, 11299744, 'MT', 'Għajn Klieb', 1, 'ghajn-klieb', 35.88556, 14.38472),
(5563089, 11299745, 'MT', 'Għajn il-Kbira', 1, 'ghajn-il-kbira', 36.03861, 14.23972),
(5563090, 11299754, 'MT', 'Għajn il-Kbira', 1, 'ghajn-il-kbira', 35.85444, 14.40806),
(5563115, 11299707, 'MT', 'Fgura', 1, 'fgura', 35.87028, 14.51333),
(5563129, 11299720, 'MT', 'Dwejra', 1, 'dwejra', 35.90528, 14.38361),
(5563140, 11299706, 'MT', 'Dingli', 1, 'dingli', 35.86139, 14.38222),
(5563150, 11299732, 'MT', 'Delimara', 1, 'delimara', 35.82472, 14.55972),
(5563172, 11299751, 'MT', 'Bur Marrad', 1, 'bur-marrad', 35.93583, 14.41389),
(5563173, 11299714, 'MT', 'Bur Magħtab', 1, 'bur-maghtab', 35.84278, 14.51361),
(5563178, 11299751, 'MT', 'Buġibba', 1, 'bugibba', 35.95139, 14.41056),
(5563180, 11299766, 'MT', 'Bubaqra', 1, 'bubaqra', 35.82472, 14.47806),
(5563181, 11299705, 'MT', 'Cospicua', 1, 'cospicua', 35.88556, 14.5275),
(5563182, 11299704, 'MT', 'Borġ in-Nadur', 1, 'borg-in-nadur', 35.83389, 14.53028),
(5563186, 11299733, 'MT', 'Biskra', 1, 'biskra', 35.96639, 14.34694),
(5563189, 11299704, 'MT', 'Birżebbuġa', 1, 'birzebbuga', 35.82583, 14.52694),
(5563191, 11299703, 'MT', 'Birkirkara', 1, 'birkirkara', 35.89722, 14.46111),
(5563193, 11299711, 'MT', 'Birbuba', 1, 'birbuba', 36.06417, 14.19861),
(5563197, 11299720, 'MT', 'Binġemma', 1, 'bingemma', 35.91, 14.37361),
(5563205, 11299734, 'MT', 'Beżbeżija', 1, 'bezbezija', 35.91222, 14.40861),
(5563217, 11299701, 'MT', 'Balzan', 1, 'balzan', 35.90028, 14.455),
(5563230, 11299737, 'MT', 'Baħar iċ-Ċagħaq', 1, 'bahar-ic-caghaq', 35.93861, 14.45417),
(5563232, 11299700, 'MT', 'Attard', 1, 'attard', 35.88972, 14.4425),
(5564671, 11299744, 'MT', 'Il-Baħrija', 1, 'il-bahrija', 35.89444, 14.34861),
(5564765, 11299725, 'MT', 'Bighi', 1, 'bighi', 35.89235, 14.52459),
(5565295, 11299733, 'MT', 'L-Aħrax tal-Għajn', 1, 'l-ahrax-tal-ghajn', 35.98111, 14.33222),
(5567539, 11299747, 'MT', 'San Ġwann', 1, 'san-gwann', 35.90556, 14.47611),
(5567540, 11299704, 'MT', 'Ħal Far', 1, 'hal-far', 35.81667, 14.50667),
(9692380, 11299735, 'MT', 'Xlendi', 1, 'xlendi', 36.02883, 14.21803),
(10302254, 11299748, 'MT', 'Paceville', 1, 'paceville', 35.92378, 14.48949),
(10522265, 11299710, 'MT', 'Comino', 1, 'comino', 36.01465, 14.33571),
(11337342, 11299709, 'MT', 'Fontana', 1, 'fontana', 36.0375, 14.23611),
(11337353, 11299739, 'MT', 'Pembroke', 1, 'pembroke', 35.93056, 14.47639),
(12653600, 11299713, 'MT', 'Fanal', 1, 'fanal', 36.06374, 14.22139),
(12653601, 11299709, 'MT', 'Manresa', 1, 'manresa', 36.03806, 14.23913),
(12794199, 11299744, 'MT', 'Santa Katarina', 1, 'santa-katarina', 35.87133, 14.38595),
(13171154, 11299733, 'MT', 'Marfa', 1, 'marfa', 35.98584, 14.34625),
(13401834, 11299725, 'MT', 'Smart City', 1, 'smart-city', 35.8903, 14.54032),
(14152670, 11299751, 'MT', 'Xemxija', 1, 'xemxija', 35.94959, 14.38033),
(14856601, 11299749, 'MT', 'Dwejra', 1, 'dwejra', 36.05207, 14.1909),
(14856604, 11299749, 'MT', 'Debba', 1, 'debba', 36.05058, 14.20057),
(14856605, 11299749, 'MT', 'Gebla', 1, 'gebla', 36.0533, 14.20215),
(14856607, 11299749, 'MT', 'Wileg', 1, 'wileg', 36.05639, 14.2023),
(14856608, 11299749, 'MT', 'Ghonoq', 1, 'ghonoq', 36.05767, 14.20089),
(14856610, 11299749, 'MT', 'Rosa', 1, 'rosa', 36.05937, 14.19829),
(14856611, 11299749, 'MT', 'Pawluzzu', 1, 'pawluzzu', 36.05509, 14.20658);