REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('RE', 'Reunion', 'La Réunion', 'reunion', '262', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(9690283, 'RE', 'Réunion', 1, 'reunion');

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 
(3935126, 9690283, 'RE', 'Vincendo', 1, 'vincendo', -21.37104, 55.67013),
(3935129, 9690283, 'RE', 'Le Piton Saint-Leu', 1, 'le-piton-saint-leu', -21.21968, 55.31095),
(3935132, 9690283, 'RE', 'Le Verger Hémery', 1, 'le-verger-hemery', -21.36434, 55.5449),
(3935135, 9690283, 'RE', 'L\'Union', 1, 'l-union', -20.99968, 55.67236),
(3935141, 9690283, 'RE', 'Trois Mares les Hauts', 1, 'trois-mares-les-hauts', -21.2441, 55.51281),
(3935146, 9690283, 'RE', 'Les Trois-Bassins', 1, 'les-trois-bassins', -21.1, 55.3),
(3935147, 9690283, 'RE', 'Trinité', 1, 'trinite', -21.33333, 55.76667),
(3935153, 9690283, 'RE', 'Le Tremblet', 1, 'le-tremblet', -21.30403, 55.8012),
(3935157, 9690283, 'RE', 'Terre Sainte', 1, 'terre-sainte', -21.34832, 55.48521),
(3935161, 9690283, 'RE', 'Terre Rouge', 1, 'terre-rouge', -21.3447, 55.50399),
(3935175, 9690283, 'RE', 'Takamaka', 1, 'takamaka', -21.31786, 55.80094),
(3935181, 9690283, 'RE', 'Surprise', 1, 'surprise', -21.1513, 55.3021),
(3935182, 9690283, 'RE', 'Stella', 1, 'stella', -21.20201, 55.29595),
(3935183, 9690283, 'RE', 'Bois Noirs', 1, 'bois-noirs', -21.37903, 55.63932),
(3935198, 9690283, 'RE', 'Savannah', 1, 'savannah', -20.98661, 55.29831),
(3935205, 9690283, 'RE', 'Saline-les Hauts', 1, 'saline-les-hauts', -21.09263, 55.30553),
(3935210, 9690283, 'RE', 'Salazie', 1, 'salazie', -21.0271, 55.5395),
(3935213, 9690283, 'RE', 'Arrondissement de Saint-Pierre', 1, 'arrondissement-de-saint-pierre', -21.25, 55.58333),
(3935214, 9690283, 'RE', 'Saint-Pierre', 1, 'saint-pierre', -21.3393, 55.47811),
(3935215, 9690283, 'RE', 'Saint-Philippe', 1, 'saint-philippe', -21.36086, 55.7679),
(3935220, 9690283, 'RE', 'Arrondissement de Saint-Paul', 1, 'arrondissement-de-saint-paul', -21.08333, 55.33333),
(3935221, 9690283, 'RE', 'Saint-Paul', 1, 'saint-paul', -21.00961, 55.27134),
(3935223, 9690283, 'RE', 'Saint-Louis', 1, 'saint-louis', -21.28585, 55.41124),
(3935225, 9690283, 'RE', 'Saint-Leu', 1, 'saint-leu', -21.17059, 55.28824),
(3935227, 9690283, 'RE', 'Saint-Joseph', 1, 'saint-joseph', -21.3777, 55.61691),
(3935230, 9690283, 'RE', 'Saint-Gilles les Hauts', 1, 'saint-gilles-les-hauts', -21.0502, 55.27),
(3935231, 9690283, 'RE', 'Saint-Gilles les Bains', 1, 'saint-gilles-les-bains', -21.05203, 55.22571),
(3935239, 9690283, 'RE', 'Saint-François', 1, 'saint-francois', -21.06975, 55.73293),
(3935244, 9690283, 'RE', 'Sainte-Thérèse', 1, 'sainte-therese', -20.95205, 55.34302),
(3935248, 9690283, 'RE', 'Sainte-Suzanne', 1, 'sainte-suzanne', -20.90616, 55.60788),
(3935251, 9690283, 'RE', 'Sainte-Rose', 1, 'sainte-rose', -21.12858, 55.79616),
(3935255, 9690283, 'RE', 'Sainte-Marie', 1, 'sainte-marie', -20.89686, 55.55056),
(3935257, 9690283, 'RE', 'Sainte-Clotilde', 1, 'sainte-clotilde', -20.90429, 55.47826),
(3935258, 9690283, 'RE', 'Sainte-Anne-les Hauts', 1, 'sainte-anne-les-hauts', -21.08333, 55.71667),
(3935260, 9690283, 'RE', 'Sainte-Anne', 1, 'sainte-anne', -21.08522, 55.74944),
(3935263, 9690283, 'RE', 'Arrondissement de Saint-Denis', 1, 'arrondissement-de-saint-denis', -20.91667, 55.5),
(3935264, 9690283, 'RE', 'Saint-Denis', 1, 'saint-denis', -20.88231, 55.4504),
(3935265, 9690283, 'RE', 'Saint-Bernard', 1, 'saint-bernard', -20.91045, 55.40091),
(3935266, 9690283, 'RE', 'Arrondissement de Saint-Benoît', 1, 'arrondissement-de-saint-benoit', -21.08333, 55.66667),
(3935267, 9690283, 'RE', 'Saint-Benoît', 1, 'saint-benoit', -21.03795, 55.71546),
(3935268, 9690283, 'RE', 'Saint-André', 1, 'saint-andre', -20.96333, 55.65031),
(3935292, 9690283, 'RE', 'Roche Maigre', 1, 'roche-maigre', -21.2718, 55.41567),
(3935296, 9690283, 'RE', 'Rivière Saint-Pierre', 1, 'riviere-saint-pierre', -21.08333, 55.73333),
(3935298, 9690283, 'RE', 'Rivière du Rempart', 1, 'riviere-du-rempart', -21.36667, 55.61667),
(3935299, 9690283, 'RE', 'Rivière du Mât les Hauts', 1, 'riviere-du-mat-les-hauts', -20.97564, 55.64749),
(3935300, 9690283, 'RE', 'Rivière du Mât les Bas', 1, 'riviere-du-mat-les-bas', -20.9698, 55.68924),
(3935311, 9690283, 'RE', 'La Rivière de l\'Est', 1, 'la-riviere-de-l-est', -21.11995, 55.7592),
(3935315, 9690283, 'RE', 'La Révolution', 1, 'la-revolution', -20.91636, 55.55757),
(3935318, 9690283, 'RE', 'Réunion', 1, 'reunion', -21.06667, 55.26667),
(3935319, 9690283, 'RE', 'La Réunion', 1, 'la-reunion', -20.90074, 55.5365),
(3935323, 9690283, 'RE', 'La Renaissance', 1, 'la-renaissance', -20.92724, 55.60433),
(3935329, 9690283, 'RE', 'Ravine Sèche', 1, 'ravine-seche', -21.24337, 55.35475),
(3935330, 9690283, 'RE', 'Ravine Martin', 1, 'ravine-martin', -21.16667, 55.45),
(3935333, 9690283, 'RE', 'La Ravine Glissante', 1, 'la-ravine-glissante', -21.13811, 55.80663),
(3935335, 9690283, 'RE', 'Ravine du Pont-les Bas', 1, 'ravine-du-pont-les-bas', -21.35, 55.56667),
(3935336, 9690283, 'RE', 'La Ravine du Pont', 1, 'la-ravine-du-pont', -21.33911, 55.56205),
(3935339, 9690283, 'RE', 'Ravine des Chèvres les Hauts', 1, 'ravine-des-chevres-les-hauts', -20.90975, 55.56937),
(3935341, 9690283, 'RE', 'Ravine des Chèvres les Bas', 1, 'ravine-des-chevres-les-bas', -20.89543, 55.57073),
(3935342, 9690283, 'RE', 'La Ravine des Cafres les Hauts', 1, 'la-ravine-des-cafres-les-hauts', -21.33734, 55.51871),
(3935343, 9690283, 'RE', 'Ravine des Cafres-les Bas', 1, 'ravine-des-cafres-les-bas', -21.34986, 55.50832),
(3935345, 9690283, 'RE', 'La Ravine des Cabris', 1, 'la-ravine-des-cabris', -21.28612, 55.4701),
(3935346, 9690283, 'RE', 'Ravine des Cabris', 1, 'ravine-des-cabris', -21.26499, 55.50818),
(3935348, 9690283, 'RE', 'Ravine Ango', 1, 'ravine-ango', -21.34979, 55.79105),
(3935350, 9690283, 'RE', 'Ravine Creuse', 1, 'ravine-creuse', -20.96587, 55.66569),
(3935353, 9690283, 'RE', 'La Ravine Blanche', 1, 'la-ravine-blanche', -21.33707, 55.46053),
(3935355, 9690283, 'RE', 'Ravine à Marquet', 1, 'ravine-a-marquet', -20.95, 55.33333),
(3935357, 9690283, 'RE', 'La Ravine à Malheur', 1, 'la-ravine-a-malheur', -20.92302, 55.36634),
(3935362, 9690283, 'RE', 'Quartier Français', 1, 'quartier-francais', -20.92903, 55.63524),
(3935372, 9690283, 'RE', 'Le Pont d\'Yves', 1, 'le-pont-d-yves', -21.23397, 55.50511),
(3935380, 9690283, 'RE', 'Le Plate', 1, 'le-plate', -21.20448, 55.33371),
(3935382, 9690283, 'RE', 'Plaine des Grègues', 1, 'plaine-des-gregues', -21.3322, 55.60939),
(3935386, 9690283, 'RE', 'Piton Sainte-Rose', 1, 'piton-sainte-rose', -21.15717, 55.82344),
(3935397, 9690283, 'RE', 'La Cour du Piton', 1, 'la-cour-du-piton', -20.96796, 55.30101),
(3935400, 9690283, 'RE', 'Pierrefonds', 1, 'pierrefonds', -21.30135, 55.42973),
(3935401, 9690283, 'RE', 'Pichète', 1, 'pichete', -20.96064, 55.34561),
(3935405, 9690283, 'RE', 'Le Petit Serré', 1, 'le-petit-serre', -21.21454, 55.45469),
(3935407, 9690283, 'RE', 'Petit Saint-Pierre', 1, 'petit-saint-pierre', -21.08801, 55.74853),
(3935408, 9690283, 'RE', 'Le Petit Sable', 1, 'le-petit-sable', -21.03489, 55.536),
(3935412, 9690283, 'RE', 'La Petite Ravine', 1, 'la-petite-ravine', -21.12464, 55.30186),
(3935416, 9690283, 'RE', 'Petite-Île', 1, 'petite-ile', -21.35327, 55.56427),
(3935462, 9690283, 'RE', 'Morange', 1, 'morange', -21.09507, 55.7347),
(3935463, 9690283, 'RE', 'Mont Vert les Hauts', 1, 'mont-vert-les-hauts', -21.31694, 55.55265),
(3935464, 9690283, 'RE', 'Mont Vert les Bas', 1, 'mont-vert-les-bas', -21.33247, 55.53033),
(3935472, 9690283, 'RE', 'Mon Caprice', 1, 'mon-caprice', -21.30372, 55.49779),
(3935474, 9690283, 'RE', 'Moka', 1, 'moka', -20.93247, 55.5134),
(3935475, 9690283, 'RE', 'M. Lamotte', 1, 'm-lamotte', -20.98333, 55.66667),
(3935485, 9690283, 'RE', 'Menciol', 1, 'menciol', -20.96185, 55.62707),
(3935491, 9690283, 'RE', 'Matouta', 1, 'matouta', -21.35873, 55.69974),
(3935511, 9690283, 'RE', 'Marepine', 1, 'marepine', -20.8885, 55.51844),
(3935515, 9690283, 'RE', 'Mare Longue', 1, 'mare-longue', -21.36505, 55.75187),
(3935520, 9690283, 'RE', 'Mare à Vieille Place', 1, 'mare-a-vieille-place', -21.02733, 55.50843),
(3935521, 9690283, 'RE', 'Mare à Citrons', 1, 'mare-a-citrons', -21.03533, 55.52995),
(3935529, 9690283, 'RE', 'Ma Pensée', 1, 'ma-pensee', -20.99303, 55.6926),
(3935533, 9690283, 'RE', 'Manapany les Hauts', 1, 'manapany-les-hauts', -21.33685, 55.57705),
(3935534, 9690283, 'RE', 'Manapany les Bains', 1, 'manapany-les-bains', -21.37476, 55.59355),
(3935537, 9690283, 'RE', 'Manapany', 1, 'manapany', -21.37599, 55.60078),
(3935542, 9690283, 'RE', 'Les Makes', 1, 'les-makes', -21.20783, 55.40548),
(3935543, 9690283, 'RE', 'Maison Rouge', 1, 'maison-rouge', -21.26601, 55.41189),
(3935544, 9690283, 'RE', 'Maison Payet', 1, 'maison-payet', -20.96667, 55.63333),
(3935545, 9690283, 'RE', 'Maison Moullan', 1, 'maison-moullan', -21.03333, 55.5),
(3935546, 9690283, 'RE', 'Maison Leroux', 1, 'maison-leroux', -21.20176, 55.81892),
(3935547, 9690283, 'RE', 'Maison Lelièvre', 1, 'maison-lelievre', -21.08333, 55.31667),
(3935548, 9690283, 'RE', 'Maison James Biget', 1, 'maison-james-biget', -21.21564, 55.52107),
(3935549, 9690283, 'RE', 'Maison Isautier', 1, 'maison-isautier', -21.31448, 55.53208),
(3935550, 9690283, 'RE', 'Maison Henou', 1, 'maison-henou', -21.1495, 55.59782),
(3935551, 9690283, 'RE', 'Maison de l\'Enfance', 1, 'maison-de-l-enfance', -21.20701, 55.5722),
(3935557, 9690283, 'RE', 'Mahavel', 1, 'mahavel', -21.27578, 55.46912),
(3935558, 9690283, 'RE', 'Mafatte', 1, 'mafatte', -21.06141, 55.41747),
(3935564, 9690283, 'RE', 'L\'Oasis', 1, 'l-oasis', -21.04648, 55.66875),
(3935565, 9690283, 'RE', 'Îlet aux Palmistes', 1, 'ilet-aux-palmistes', -21.33523, 55.80164),
(3935566, 9690283, 'RE', 'L\'Îlet', 1, 'l-ilet', -21.32352, 55.60159),
(3935568, 9690283, 'RE', 'La Ligne des Bambous', 1, 'la-ligne-des-bambous', -21.29947, 55.49049),
(3935574, 9690283, 'RE', 'L\'Ermitage les Bains', 1, 'l-ermitage-les-bains', -21.08176, 55.2278),
(3935575, 9690283, 'RE', 'L\'Ermitage', 1, 'l-ermitage', -21.35795, 55.57711),
(3935577, 9690283, 'RE', 'Le Tévelave', 1, 'le-tevelave', -21.20944, 55.35566),
(3935581, 9690283, 'RE', 'L\'Étang', 1, 'l-etang', -20.9294, 55.65564),
(3935582, 9690283, 'RE', 'Le Tampon', 1, 'le-tampon', -21.2766, 55.51766),
(3935583, 9690283, 'RE', 'Les Vacoas', 1, 'les-vacoas', -21.31667, 55.8),
(3935585, 9690283, 'RE', 'Trois Mares', 1, 'trois-mares', -21.25841, 55.50072),
(3935586, 9690283, 'RE', 'Les Trois Frères', 1, 'les-trois-freres', -20.90802, 55.59779),
(3935589, 9690283, 'RE', 'Les Six-Cents', 1, 'les-six-cents', -21.26667, 55.51667),
(3935590, 9690283, 'RE', 'Les Sables Blancs', 1, 'les-sables-blancs', -21.35277, 55.78646),
(3935591, 9690283, 'RE', 'Les Quatre Cents', 1, 'les-quatre-cents', -21.27068, 55.4955),
(3935593, 9690283, 'RE', 'Les Orangers', 1, 'les-orangers', -21.11223, 55.75121),
(3935595, 9690283, 'RE', 'Les Lianes', 1, 'les-lianes', -21.34508, 55.60203),
(3935596, 9690283, 'RE', 'Les Jacques', 1, 'les-jacques', -21.37646, 55.63083),
(3935599, 9690283, 'RE', 'Les Deux Bras', 1, 'les-deux-bras', -21.00104, 55.39133),
(3935600, 9690283, 'RE', 'Les Colimaçons', 1, 'les-colimacons', -21.13923, 55.29288),
(3935601, 9690283, 'RE', 'Les Cocos', 1, 'les-cocos', -21.28396, 55.43664),
(3935602, 9690283, 'RE', 'Les Chicots', 1, 'les-chicots', -21.11445, 55.74925),
(3935604, 9690283, 'RE', 'Les Canots', 1, 'les-canots', -21.24967, 55.36382),
(3935606, 9690283, 'RE', 'L\'Escalier', 1, 'l-escalier', -21.00222, 55.57364),
(3935608, 9690283, 'RE', 'Les Avirons', 1, 'les-avirons', -21.24063, 55.33685),
(3935609, 9690283, 'RE', 'Les Aigrettes', 1, 'les-aigrettes', -21.14287, 55.45608),
(3935610, 9690283, 'RE', 'Le Ruisseau les Hauts', 1, 'le-ruisseau-les-hauts', -21.25863, 55.43896),
(3935611, 9690283, 'RE', 'Le Rond', 1, 'le-rond', -21.31627, 55.60681),
(3935612, 9690283, 'RE', 'Les Ramiers', 1, 'les-ramiers', -21.02517, 55.53252),
(3935613, 9690283, 'RE', 'Le Quatorzième', 1, 'le-quatorzieme', -21.2516, 55.52114),
(3935614, 9690283, 'RE', 'Le Grand Pourpier', 1, 'le-grand-pourpier', -20.97302, 55.30958),
(3935615, 9690283, 'RE', 'Le Portail', 1, 'le-portail', -21.2132, 55.30071),
(3935616, 9690283, 'RE', 'Le Port', 1, 'le-port', -20.93752, 55.29415),
(3935619, 9690283, 'RE', 'Le Petit Tampon', 1, 'le-petit-tampon', -21.27865, 55.54298),
(3935622, 9690283, 'RE', 'Le Petit Brûlé', 1, 'le-petit-brule', -21.12682, 55.77771),
(3935625, 9690283, 'RE', 'L\'Éperon', 1, 'l-eperon', -21.24715, 55.41291),
(3935628, 9690283, 'RE', 'Le Pavillon', 1, 'le-pavillon', -21.1903, 55.45026),
(3935630, 9690283, 'RE', 'Patelin', 1, 'patelin', -20.97153, 55.67639),
(3935631, 9690283, 'RE', 'Le Ouaki', 1, 'le-ouaki', -21.27497, 55.4491),
(3935632, 9690283, 'RE', 'Le Onzième', 1, 'le-onzieme', -21.26415, 55.52363),
(3935636, 9690283, 'RE', 'Le Maniron', 1, 'le-maniron', -21.24788, 55.38863),
(3935637, 9690283, 'RE', 'Le Lambert', 1, 'le-lambert', -21.25716, 55.37513),
(3935638, 9690283, 'RE', 'Le Guillaume', 1, 'le-guillaume', -21.03786, 55.29893),
(3935643, 9690283, 'RE', 'Fond Maurice', 1, 'fond-maurice', -21.24891, 55.35041),
(3935644, 9690283, 'RE', 'Le Dix-Septième', 1, 'le-dix-septieme', -21.24501, 55.52479),
(3935645, 9690283, 'RE', 'Le Dix-Neuvième', 1, 'le-dix-neuvieme', -21.23604, 55.543),
(3935646, 9690283, 'RE', 'Lotissement Dioré', 1, 'lotissement-diore', -20.98364, 55.61913),
(3935647, 9690283, 'RE', 'Délices', 1, 'delices', -20.9352, 55.6316),
(3935648, 9690283, 'RE', 'Le Cratère', 1, 'le-cratere', -21.05037, 55.68301),
(3935650, 9690283, 'RE', 'Le Colosse', 1, 'le-colosse', -20.93587, 55.67238),
(3935654, 9690283, 'RE', 'Le Chaudron', 1, 'le-chaudron', -20.89195, 55.49528),
(3935655, 9690283, 'RE', 'Casabois', 1, 'casabois', -21.03787, 55.46437),
(3935656, 9690283, 'RE', 'Le Cap-les Hauts', 1, 'le-cap-les-hauts', -21.15, 55.33333),
(3935657, 9690283, 'RE', 'Le Cap Lelièvre', 1, 'le-cap-lelievre', -21.18087, 55.3033),
(3935658, 9690283, 'RE', 'Le Cap', 1, 'le-cap', -21.1657, 55.48081),
(3935660, 9690283, 'RE', 'Le Butor', 1, 'le-butor', -21.38276, 55.61509),
(3935663, 9690283, 'RE', 'Le Brûlé', 1, 'le-brule', -20.92199, 55.4361),
(3935664, 9690283, 'RE', 'Le Bras Creux', 1, 'le-bras-creux', -21.25799, 55.53891),
(3935667, 9690283, 'RE', 'Bois de Nèfles', 1, 'bois-de-nefles', -20.99704, 55.32702),
(3935669, 9690283, 'RE', 'Bésave', 1, 'besave', -21.36189, 55.60685),
(3935670, 9690283, 'RE', 'Le Bélier', 1, 'le-belier', -21.04392, 55.46191),
(3935671, 9690283, 'RE', 'Le Barrage', 1, 'le-barrage', -21.10011, 55.27419),
(3935672, 9690283, 'RE', 'La Vigne', 1, 'la-vigne', -20.92044, 55.61609),
(3935673, 9690283, 'RE', 'La Vallée', 1, 'la-vallee', -21.30326, 55.4585),
(3935680, 9690283, 'RE', 'La Saline les Bains', 1, 'la-saline-les-bains', -21.09372, 55.23913),
(3935681, 9690283, 'RE', 'La Saline', 1, 'la-saline', -21.08426, 55.26893),
(3935683, 9690283, 'RE', 'La Rivière des Roches', 1, 'la-riviere-des-roches', -21.00115, 55.69628),
(3935684, 9690283, 'RE', 'Rivière des Pluies', 1, 'riviere-des-pluies', -20.91339, 55.50976),
(3935685, 9690283, 'RE', 'La Rivière', 1, 'la-riviere', -21.26609, 55.44039),
(3935687, 9690283, 'RE', 'La Ressource Barau', 1, 'la-ressource-barau', -20.91866, 55.57033),
(3935690, 9690283, 'RE', 'La Providence', 1, 'la-providence', -20.89453, 55.45735),
(3935691, 9690283, 'RE', 'La Possession', 1, 'la-possession', -20.92909, 55.3348),
(3935692, 9690283, 'RE', 'La Pointe', 1, 'la-pointe', -21.29573, 55.51767),
(3935694, 9690283, 'RE', 'La Plaine-des-Palmistes', 1, 'la-plaine-des-palmistes', -21.13425, 55.62819),
(3935695, 9690283, 'RE', 'La Plaine des Cafres', 1, 'la-plaine-des-cafres', -21.22526, 55.55588),
(3935696, 9690283, 'RE', 'La Plaine', 1, 'la-plaine', -20.98134, 55.32806),
(3935697, 9690283, 'RE', 'Petite Île', 1, 'petite-ile', -20.88024, 55.44164),
(3935700, 9690283, 'RE', 'La Passerelle', 1, 'la-passerelle', -21.34046, 55.64563),
(3935701, 9690283, 'RE', 'La Paix', 1, 'la-paix', -21.02432, 55.67028),
(3935702, 9690283, 'RE', 'La Nouvelle', 1, 'la-nouvelle', -21.07651, 55.42291),
(3935707, 9690283, 'RE', 'Langevin', 1, 'langevin', -21.38165, 55.65099),
(3935708, 9690283, 'RE', 'La Montagne', 1, 'la-montagne', -20.88877, 55.42267),
(3935709, 9690283, 'RE', 'La Marine', 1, 'la-marine', -21.12726, 55.78537),
(3935712, 9690283, 'RE', 'La Mare', 1, 'la-mare', -20.95341, 55.35392),
(3935717, 9690283, 'RE', 'La Grande Montée', 1, 'la-grande-montee', -20.92421, 55.51945),
(3935719, 9690283, 'RE', 'La Grande Chaloupe', 1, 'la-grande-chaloupe', -20.89765, 55.37523),
(3935720, 9690283, 'RE', 'Le Goyave', 1, 'le-goyave', -21.3709, 55.61731),
(3935723, 9690283, 'RE', 'La Fontaine-les Hauts', 1, 'la-fontaine-les-hauts', -21.13333, 55.33333),
(3935724, 9690283, 'RE', 'La Fontaine', 1, 'la-fontaine', -21.15708, 55.30425),
(3935732, 9690283, 'RE', 'La Crête', 1, 'la-crete', -21.335, 55.65495),
(3935734, 9690283, 'RE', 'La Chatoire', 1, 'la-chatoire', -21.27617, 55.50134),
(3935735, 9690283, 'RE', 'La Chaloupe Saint-Leu', 1, 'la-chaloupe-saint-leu', -21.14279, 55.31525),
(3935736, 9690283, 'RE', 'La Caroline', 1, 'la-caroline', -21.00143, 55.6516),
(3935738, 9690283, 'RE', 'La Bretagne', 1, 'la-bretagne', -20.92011, 55.49486),
(3935742, 9690283, 'RE', 'Jean Petit les Bas', 1, 'jean-petit-les-bas', -21.37045, 55.62308),
(3935743, 9690283, 'RE', 'Jean Petit', 1, 'jean-petit', -21.3386, 55.62903),
(3935751, 9690283, 'RE', 'Jacques Payet', 1, 'jacques-payet', -21.34034, 55.68398),
(3935756, 9690283, 'RE', 'Îlet Tommic', 1, 'ilet-tommic', -21.15, 55.46667),
(3935757, 9690283, 'RE', 'Îlet Techer', 1, 'ilet-techer', -21.1983, 55.51823),
(3935758, 9690283, 'RE', 'Îlet Solitude', 1, 'ilet-solitude', -20.96594, 55.36426),
(3935759, 9690283, 'RE', 'Îlet Furcy', 1, 'ilet-furcy', -21.24263, 55.455),
(3935761, 9690283, 'RE', 'Îlet Nourry', 1, 'ilet-nourry', -20.99169, 55.39407),
(3935762, 9690283, 'RE', 'Îlet Morin', 1, 'ilet-morin', -21.00842, 55.56428),
(3935763, 9690283, 'RE', 'Îlet Marron', 1, 'ilet-marron', -21.20183, 55.51405),
(3935764, 9690283, 'RE', 'Îlet Flamand', 1, 'ilet-flamand', -20.98333, 55.46667),
(3935765, 9690283, 'RE', 'Peter Both', 1, 'peter-both', -21.17216, 55.461),
(3935766, 9690283, 'RE', 'Îlet des Lataniers', 1, 'ilet-des-lataniers', -21.03671, 55.39988),
(3935767, 9690283, 'RE', 'Roche Plate', 1, 'roche-plate', -21.2481, 55.61549),
(3935769, 9690283, 'RE', 'Îlet Denise', 1, 'ilet-denise', -20.97869, 55.36329),
(3935770, 9690283, 'RE', 'Îlet Bois-Rouge', 1, 'ilet-bois-rouge', -21.02499, 55.40521),
(3935771, 9690283, 'RE', 'Îlet à Vidot', 1, 'ilet-a-vidot', -21.31806, 55.62595),
(3935772, 9690283, 'RE', 'Îlet à Malheur', 1, 'ilet-a-malheur', -21.02666, 55.42833),
(3935773, 9690283, 'RE', 'Îlet à Guillaume', 1, 'ilet-a-guillaume', -20.94941, 55.41147),
(3935774, 9690283, 'RE', 'Îlet à Déjeuner', 1, 'ilet-a-dejeuner', -20.9959, 55.40796),
(3935775, 9690283, 'RE', 'Îlet à Cordes', 1, 'ilet-a-cordes', -21.15409, 55.43722),
(3935786, 9690283, 'RE', 'Hell Bourg', 1, 'hell-bourg', -21.06493, 55.51954),
(3935791, 9690283, 'RE', 'Harmonie', 1, 'harmonie', -21.01377, 55.70108),
(3935806, 9690283, 'RE', 'Grands Bois', 1, 'grands-bois', -21.35928, 55.52557),
(3935814, 9690283, 'RE', 'Grand Îlet', 1, 'grand-ilet', -21.02876, 55.47301),
(3935815, 9690283, 'RE', 'Grand Galet', 1, 'grand-galet', -21.30981, 55.6405),
(3935816, 9690283, 'RE', 'Grand Fond', 1, 'grand-fond', -21.19547, 55.30181),
(3935826, 9690283, 'RE', 'Grande Ravine', 1, 'grande-ravine', -21.11327, 55.30029),
(3935828, 9690283, 'RE', 'Grand-Place', 1, 'grand-place', -21.04165, 55.41226),
(3935838, 9690283, 'RE', 'Grande Anse', 1, 'grande-anse', -21.36932, 55.55442),
(3935839, 9690283, 'RE', 'Grand Coude', 1, 'grand-coude', -21.29306, 55.62576),
(3935850, 9690283, 'RE', 'Grand Bassin', 1, 'grand-bassin', -21.18242, 55.53401),
(3935856, 9690283, 'RE', 'Le Gol les Hauts', 1, 'le-gol-les-hauts', -21.25151, 55.43521),
(3935859, 9690283, 'RE', 'Le Camp du Gol', 1, 'le-camp-du-gol', -21.27281, 55.40413),
(3935861, 9690283, 'RE', 'Girofle', 1, 'girofle', -21.37099, 55.68751),
(3935875, 9690283, 'RE', 'Franche Terre', 1, 'franche-terre', -20.90333, 55.58054),
(3935886, 9690283, 'RE', 'Fleurs Jaunes les Hauts', 1, 'fleurs-jaunes-les-hauts', -21.01679, 55.53159),
(3935890, 9690283, 'RE', 'Fleurimont', 1, 'fleurimont', -21.03516, 55.26837),
(3935891, 9690283, 'RE', 'Flacourt', 1, 'flacourt', -20.91642, 55.55306),
(3935892, 9690283, 'RE', 'Les Filaos', 1, 'les-filaos', -21.07583, 55.22493),
(3935894, 9690283, 'RE', 'Fiague', 1, 'fiague', -21.25, 55.43333),
(3935900, 9690283, 'RE', 'L\'Étang-Salé les Bains', 1, 'l-etang-sale-les-bains', -21.27052, 55.33633),
(3935902, 9690283, 'RE', 'L\'Étang-Salé', 1, 'l-etang-sale', -21.25, 55.38333),
(3935904, 9690283, 'RE', 'Étang-les Hauts', 1, 'etang-les-hauts', -21.13333, 55.33333),
(3935910, 9690283, 'RE', 'L\'Étang Saint-Leu', 1, 'l-etang-saint-leu', -21.17132, 55.30528),
(3935912, 9690283, 'RE', 'Espérance', 1, 'esperance', -20.95113, 55.60798),
(3935913, 9690283, 'RE', 'L\'Espérance les Hauts', 1, 'l-esperance-les-hauts', -20.9478, 55.5168),
(3935915, 9690283, 'RE', 'Entre-Deux', 1, 'entre-deux', -21.23333, 55.46667),
(3935927, 9690283, 'RE', 'Dos d\'Âne', 1, 'dos-d-ane', -20.98408, 55.38121),
(3935930, 9690283, 'RE', 'Domenjod', 1, 'domenjod', -20.91277, 55.50608),
(3935932, 9690283, 'RE', 'Dimitile', 1, 'dimitile', -21.29085, 55.61332),
(3935935, 9690283, 'RE', 'Le Désert', 1, 'le-desert', -20.96594, 55.63306),
(3935936, 9690283, 'RE', 'Desbassyns', 1, 'desbassyns', -20.91733, 55.50934),
(3935956, 9690283, 'RE', 'La Convenance', 1, 'la-convenance', -20.89478, 55.56522),
(3935960, 9690283, 'RE', 'La Confiance', 1, 'la-confiance', -21.06738, 55.70277),
(3935961, 9690283, 'RE', 'Condé', 1, 'conde', -21.29317, 55.50836),
(3935962, 9690283, 'RE', 'Commune Carron', 1, 'commune-carron', -20.93384, 55.61885),
(3935963, 9690283, 'RE', 'Commune Bègue', 1, 'commune-begue', -20.95314, 55.62829),
(3935964, 9690283, 'RE', 'Commune Ango', 1, 'commune-ango', -20.94349, 55.61907),
(3935975, 9690283, 'RE', 'Cilaos', 1, 'cilaos', -21.13641, 55.47187),
(3935977, 9690283, 'RE', 'Chiendent', 1, 'chiendent', -20.937, 55.5437),
(3935983, 9690283, 'RE', 'Chemin César', 1, 'chemin-cesar', -21.35, 55.58333),
(3935992, 9690283, 'RE', 'Le Champ Borne', 1, 'le-champ-borne', -20.9435, 55.67625),
(3936007, 9690283, 'RE', 'Casabona', 1, 'casabona', -21.3347, 55.46714),
(3936011, 9690283, 'RE', 'Carosse', 1, 'carosse', -21.35555, 55.59688),
(3936015, 9690283, 'RE', 'Cap Noir', 1, 'cap-noir', -20.99381, 55.39168),
(3936016, 9690283, 'RE', 'Cap Blanc', 1, 'cap-blanc', -21.28698, 55.65003),
(3936020, 9690283, 'RE', 'Camp Jacquot', 1, 'camp-jacquot', -20.99157, 55.6777),
(3936024, 9690283, 'RE', 'Camp de Pierrot', 1, 'camp-de-pierrot', -21.05418, 55.46895),
(3936025, 9690283, 'RE', 'Cambuston', 1, 'cambuston', -20.93338, 55.64764),
(3936029, 9690283, 'RE', 'La Cafrine', 1, 'la-cafrine', -21.35101, 55.51126),
(3936048, 9690283, 'RE', 'Bras-Panon', 1, 'bras-panon', -20.99667, 55.67823),
(3936049, 9690283, 'RE', 'Bras Madeleine', 1, 'bras-madeleine', -21.05665, 55.69763),
(3936051, 9690283, 'RE', 'Bras des Chevrettes', 1, 'bras-des-chevrettes', -20.96698, 55.62459),
(3936052, 9690283, 'RE', 'Bras des Calumets', 1, 'bras-des-calumets', -21.16062, 55.61747),
(3936053, 9690283, 'RE', 'Bras de Ponteau', 1, 'bras-de-ponteau', -21.21667, 55.48333),
(3936054, 9690283, 'RE', 'Bras Canot', 1, 'bras-canot', -21.05006, 55.7019),
(3936060, 9690283, 'RE', 'Bourbier-Beaulieu', 1, 'bourbier-beaulieu', -21.03248, 55.70018),
(3936065, 9690283, 'RE', 'Boucan Canot', 1, 'boucan-canot', -21.0283, 55.22725),
(3936076, 9690283, 'RE', 'Bois Rouge', 1, 'bois-rouge', -20.91452, 55.63774),
(3936078, 9690283, 'RE', 'Bois d\'Olives', 1, 'bois-d-olives', -21.29827, 55.45307),
(3936082, 9690283, 'RE', 'Bois Court', 1, 'bois-court', -21.19665, 55.536),
(3936089, 9690283, 'RE', 'Bois Blanc', 1, 'bois-blanc', -21.19842, 55.81952),
(3936095, 9690283, 'RE', 'Bethléem', 1, 'bethleem', -21.03912, 55.67443),
(3936099, 9690283, 'RE', 'Bernica-les Bas', 1, 'bernica-les-bas', -21.04444, 55.28111),
(3936104, 9690283, 'RE', 'Bérive les Bas', 1, 'berive-les-bas', -21.31719, 55.52836),
(3936105, 9690283, 'RE', 'Bérive', 1, 'berive', -21.30726, 55.53702),
(3936116, 9690283, 'RE', 'Bellevue', 1, 'bellevue', -21.25136, 55.40297),
(3936120, 9690283, 'RE', 'Bellemène', 1, 'bellemene', -21.01904, 55.2949),
(3936126, 9690283, 'RE', 'Bel-Air', 1, 'bel-air', -21.28769, 55.51219),
(3936130, 9690283, 'RE', 'Bécabot', 1, 'becabot', -21.01552, 55.50557),
(3936132, 9690283, 'RE', 'Bebour', 1, 'bebour', -21.1, 55.6),
(3936134, 9690283, 'RE', 'Beauvallon', 1, 'beauvallon', -21.00978, 55.69559),
(3936135, 9690283, 'RE', 'Beaumont', 1, 'beaumont', -20.93857, 55.53086),
(3936136, 9690283, 'RE', 'Beaulieu', 1, 'beaulieu', -21.03475, 55.70782),
(3936137, 9690283, 'RE', 'Beaufonds', 1, 'beaufonds', -21.04657, 55.72134),
(3936138, 9690283, 'RE', 'Beaufond', 1, 'beaufond', -20.92717, 55.55983),
(3936142, 9690283, 'RE', 'Bassin Martin', 1, 'bassin-martin', -21.30713, 55.51822),
(3936147, 9690283, 'RE', 'Basse Vallée', 1, 'basse-vallee', -21.37116, 55.71168),
(3936152, 9690283, 'RE', 'Le Baril', 1, 'le-baril', -21.36794, 55.72779),
(3936160, 9690283, 'RE', 'Bain', 1, 'bain', -21.05, 55.51667),
(3936161, 9690283, 'RE', 'Bagatelle', 1, 'bagatelle', -20.92802, 55.58178),
(3936165, 9690283, 'RE', 'Avenir', 1, 'avenir', -20.93192, 55.3359),
(3936169, 9690283, 'RE', 'Aurère', 1, 'aurere', -21.02055, 55.42361),
(3936170, 9690283, 'RE', 'Îlet Aurélien Dijoux', 1, 'ilet-aurelien-dijoux', -21.20739, 55.51352),
(3936178, 9690283, 'RE', 'Anse les Hauts', 1, 'anse-les-hauts', -21.33718, 55.54939),
(3936179, 9690283, 'RE', 'Anse les Bas', 1, 'anse-les-bas', -21.36391, 55.54129),
(3936181, 9690283, 'RE', 'Anse', 1, 'anse', -21.33814, 55.54821),
(3936187, 9690283, 'RE', 'Aloès', 1, 'aloes', -21.25, 55.45),
(3936191, 9690283, 'RE', 'A. Dubuisson', 1, 'a-dubuisson', -21.17383, 55.30853),
(3936193, 9690283, 'RE', 'Abondance', 1, 'abondance', -21.03465, 55.67338),
(10932385, 9690283, 'RE', 'Piton Saint-Leu', 1, 'piton-saint-leu', -21.21962, 55.31513),
(14101563, 9690283, 'RE', 'Bourg-Murat', 1, 'bourg-murat', -21.20366, 55.57292);