REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('GP', 'Guadeloupe', 'Guadeloupe', 'guadeloupe', '590', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(9690363, 'GP', 'Guadeloupe', 1, 'guadeloupe');

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 
(6578260, 9690363, 'GP', 'Zévallos', 1, 'zevallos', 16.30542, -61.30299),
(6578268, 9690363, 'GP', 'Vital', 1, 'vital', 15.91496, -61.21913),
(6578269, 9690363, 'GP', 'Vipart', 1, 'vipart', 16.33333, -61.4),
(6578272, 9690363, 'GP', 'Vince', 1, 'vince', 16.23333, -61.6),
(6578275, 9690363, 'GP', 'Village', 1, 'village', 16.13012, -61.76864),
(6578278, 9690363, 'GP', 'Vieux-Habitants', 1, 'vieux-habitants', 16.05866, -61.76667),
(6578287, 9690363, 'GP', 'Vieux Fort', 1, 'vieux-fort', 15.99094, -61.2995),
(6578288, 9690363, 'GP', 'Vieux-Fort', 1, 'vieux-fort', 15.94959, -61.69928),
(6578289, 9690363, 'GP', 'Vieux Bourg', 1, 'vieux-bourg', 16.34187, -61.51113),
(6578292, 9690363, 'GP', 'Vidon', 1, 'vidon', 15.90174, -61.25013),
(6578296, 9690363, 'GP', 'Vezoux', 1, 'vezoux', 16.29478, -61.27647),
(6578298, 9690363, 'GP', 'Versailles', 1, 'versailles', 16.22155, -61.60162),
(6578299, 9690363, 'GP', 'Vernou', 1, 'vernou', 16.18167, -61.65626),
(6578300, 9690363, 'GP', 'Vermont', 1, 'vermont', 16.39948, -61.46408),
(6578301, 9690363, 'GP', 'La Rose Verger', 1, 'la-rose-verger', 15.94095, -61.26185),
(6578303, 9690363, 'GP', 'Verdier', 1, 'verdier', 16.2, -61.6),
(6578308, 9690363, 'GP', 'Vanniers', 1, 'vanniers', 15.92114, -61.27999),
(6578310, 9690363, 'GP', 'Vallée d\'Or', 1, 'vallee-d-or', 16.26667, -61.25),
(6578311, 9690363, 'GP', 'Valeau', 1, 'valeau', 16.03624, -61.71883),
(6578324, 9690363, 'GP', 'Trois-Rivières', 1, 'trois-rivieres', 15.97595, -61.64492),
(6578325, 9690363, 'GP', 'Trois Îlets', 1, 'trois-ilets', 15.93094, -61.33151),
(6578347, 9690363, 'GP', 'Terre-de-Haut', 1, 'terre-de-haut', 15.86656, -61.5826),
(6578350, 9690363, 'GP', 'Terre-de-Bas', 1, 'terre-de-bas', 15.8544, -61.63411),
(6578351, 9690363, 'GP', 'Petites Anses', 1, 'petites-anses', 15.84993, -61.64457),
(6578360, 9690363, 'GP', 'Surgy', 1, 'surgy', 16.26278, -61.34041),
(6578368, 9690363, 'GP', 'Subercazeaux', 1, 'subercazeaux', 16.29527, -61.65934),
(6578381, 9690363, 'GP', 'Sofaïa', 1, 'sofaia', 16.29989, -61.72261),
(6578386, 9690363, 'GP', 'Siblet', 1, 'siblet', 15.93287, -61.31273),
(6578387, 9690363, 'GP', 'Sèze', 1, 'seze', 16.24912, -61.28794),
(6578388, 9690363, 'GP', 'Sevray', 1, 'sevray', 16.05, -61.75),
(6578392, 9690363, 'GP', 'Seforge', 1, 'seforge', 16.26667, -61.36667),
(6578398, 9690363, 'GP', 'Savane', 1, 'savane', 15.9796, -61.63221),
(6578400, 9690363, 'GP', 'Satgé', 1, 'satge', 16.01667, -61.61667),
(6578415, 9690363, 'GP', 'Saint-Sauveur', 1, 'saint-sauveur', 16.01113, -61.58921),
(6578417, 9690363, 'GP', 'Saint-Prix', 1, 'saint-prix', 16.41667, -61.43333),
(6578418, 9690363, 'GP', 'Saint-Pierre', 1, 'saint-pierre', 16.45028, -61.52955),
(6578423, 9690363, 'GP', 'Saint-Marc', 1, 'saint-marc', 15.90899, -61.27361),
(6578428, 9690363, 'GP', 'Saint-Louis', 1, 'saint-louis', 15.95476, -61.31759),
(6578436, 9690363, 'GP', 'Saint-Jacques', 1, 'saint-jacques', 16.48382, -61.46708),
(6578438, 9690363, 'GP', 'Saint-Gilles', 1, 'saint-gilles', 15.98333, -61.63333),
(6578441, 9690363, 'GP', 'Saint-François', 1, 'saint-francois', 16.25236, -61.27332),
(6578442, 9690363, 'GP', 'Saint-Félix', 1, 'saint-felix', 16.20676, -61.45701),
(6578447, 9690363, 'GP', 'Sainte-Rose', 1, 'sainte-rose', 16.33264, -61.6969),
(6578448, 9690363, 'GP', 'Sainte-Marthe', 1, 'sainte-marthe', 16.26504, -61.27246),
(6578449, 9690363, 'GP', 'Sainte-Marie des Bois', 1, 'sainte-marie-des-bois', 16.06667, -61.58333),
(6578454, 9690363, 'GP', 'Sainte-Marie', 1, 'sainte-marie', 16.26216, -61.27267),
(6578459, 9690363, 'GP', 'Sainte-Marguerite', 1, 'sainte-marguerite', 16.38579, -61.41658),
(6578460, 9690363, 'GP', 'Sainte-Madeleine', 1, 'sainte-madeleine', 16.28333, -61.3),
(6578461, 9690363, 'GP', 'Sainte-Croix', 1, 'sainte-croix', 15.93166, -61.25395),
(6578462, 9690363, 'GP', 'Sainte-Claire', 1, 'sainte-claire', 16.12617, -61.5731),
(6578466, 9690363, 'GP', 'Sainte-Anne', 1, 'sainte-anne', 16.22564, -61.38098),
(6578467, 9690363, 'GP', 'Saint-Claude', 1, 'saint-claude', 16.02515, -61.69975),
(6578471, 9690363, 'GP', 'Saint-Charles', 1, 'saint-charles', 15.94156, -61.30765),
(6578473, 9690363, 'GP', 'Saint-Bernard', 1, 'saint-bernard', 16.25596, -61.24941),
(6578479, 9690363, 'GP', 'Salette', 1, 'salette', 16.32439, -61.46058),
(6578488, 9690363, 'GP', 'Ruillier', 1, 'ruillier', 16.26667, -61.65),
(6578489, 9690363, 'GP', 'Routhiers', 1, 'routhiers', 16.04041, -61.59726),
(6578493, 9690363, 'GP', 'Roussel', 1, 'roussel', 16.22106, -61.64882),
(6578524, 9690363, 'GP', 'Rifflet', 1, 'rifflet', 16.33738, -61.78329),
(6578526, 9690363, 'GP', 'Richeval', 1, 'richeval', 16.34571, -61.45437),
(6578527, 9690363, 'GP', 'Richeplaine', 1, 'richeplaine', 16.27614, -61.33689),
(6578529, 9690363, 'GP', 'Richemont', 1, 'richemont', 16.4, -61.46667),
(6578530, 9690363, 'GP', 'Ribourgeon', 1, 'ribourgeon', 15.97627, -61.2671),
(6578532, 9690363, 'GP', 'Retz', 1, 'retz', 15.91667, -61.33333),
(6578533, 9690363, 'GP', 'Renéville', 1, 'reneville', 16.28832, -61.31161),
(6578535, 9690363, 'GP', 'Renard', 1, 'renard', 16.3, -61.31667),
(6578537, 9690363, 'GP', 'Reizet-Sainte-Marie', 1, 'reizet-sainte-marie', 16.28726, -61.65339),
(6578539, 9690363, 'GP', 'Ravine Chaude', 1, 'ravine-chaude', 16.22686, -61.66827),
(6578548, 9690363, 'GP', 'Radelin', 1, 'radelin', 16.31667, -61.78333),
(6578551, 9690363, 'GP', 'Rabi', 1, 'rabi', 15.90717, -61.26099),
(6578554, 9690363, 'GP', 'Quatre Chemins', 1, 'quatre-chemins', 16.28084, -61.49609),
(6578564, 9690363, 'GP', 'Prise d\'Eau', 1, 'prise-d-eau', 16.2085, -61.6522),
(6578566, 9690363, 'GP', 'Pressec', 1, 'pressec', 16.46601, -61.46643),
(6578569, 9690363, 'GP', 'Poyen', 1, 'poyen', 16.35, -61.45),
(6578571, 9690363, 'GP', 'Pouzzole', 1, 'pouzzole', 16.42571, -61.52005),
(6578573, 9690363, 'GP', 'Poucet', 1, 'poucet', 16.2177, -61.50313),
(6578575, 9690363, 'GP', 'Port-Louis', 1, 'port-louis', 16.41749, -61.53045),
(6578576, 9690363, 'GP', 'Port Louis', 1, 'port-louis', 15.91317, -61.28775),
(6578577, 9690363, 'GP', 'Portland', 1, 'portland', 16.32339, -61.3233),
(6578579, 9690363, 'GP', 'Quatrième Portel', 1, 'quatrieme-portel', 15.91188, -61.30279),
(6578584, 9690363, 'GP', 'Port Blanc', 1, 'port-blanc', 16.23335, -61.45615),
(6578587, 9690363, 'GP', 'Pombiray', 1, 'pombiray', 16.28375, -61.30401),
(6578592, 9690363, 'GP', 'Poirier', 1, 'poirier', 16.24484, -61.36987),
(6578594, 9690363, 'GP', 'Pointe-Noire', 1, 'pointe-noire', 16.23218, -61.78917),
(6578596, 9690363, 'GP', 'Pointe à Raie', 1, 'pointe-a-raie', 16.35, -61.48333),
(6578598, 9690363, 'GP', 'Arrondissement de Pointe-à-Pitre', 1, 'arrondissement-de-pointe-a-pitre', 16.33333, -61.41667),
(6578599, 9690363, 'GP', 'Pointe-à-Pitre', 1, 'pointe-a-pitre', 16.24125, -61.53614),
(6578604, 9690363, 'GP', 'Plessis-Nogent', 1, 'plessis-nogent', 16.35435, -61.73537),
(6578611, 9690363, 'GP', 'Planel', 1, 'planel', 16.0514, -61.69357),
(6578612, 9690363, 'GP', 'Plaisance', 1, 'plaisance', 16.24028, -61.40244),
(6578618, 9690363, 'GP', 'Pirogue', 1, 'pirogue', 15.90098, -61.28584),
(6578624, 9690363, 'GP', 'Pigeon', 1, 'pigeon', 16.15023, -61.77425),
(6578629, 9690363, 'GP', 'Pichon', 1, 'pichon', 16.42523, -61.46874),
(6578631, 9690363, 'GP', 'Philipsbourg', 1, 'philipsbourg', 16.43817, -61.47124),
(6578639, 9690363, 'GP', 'Petit Portland', 1, 'petit-portland', 16.45785, -61.44154),
(6578656, 9690363, 'GP', 'Petites Mamelles', 1, 'petites-mamelles', 16.05, -61.61667),
(6578660, 9690363, 'GP', 'Petites-Anses', 1, 'petites-anses', 15.85, -61.63333),
(6578672, 9690363, 'GP', 'Petite Anse', 1, 'petite-anse', 16.1, -61.76667),
(6578681, 9690363, 'GP', 'Petit-Canal', 1, 'petit-canal', 16.37913, -61.48716),
(6578682, 9690363, 'GP', 'Petit-Bourg', 1, 'petit-bourg', 16.19163, -61.5914),
(6578697, 9690363, 'GP', 'Pélisson', 1, 'pelisson', 15.93301, -61.26833),
(6578701, 9690363, 'GP', 'Pavillon', 1, 'pavillon', 16.26083, -61.41505),
(6578709, 9690363, 'GP', 'Pasquereau', 1, 'pasquereau', 16.27365, -61.61575),
(6578712, 9690363, 'GP', 'Parnasse', 1, 'parnasse', 16.02379, -61.685),
(6578725, 9690363, 'GP', 'Pagesy', 1, 'pagesy', 16.11667, -61.76667),
(6578748, 9690363, 'GP', 'Neuf-Château', 1, 'neuf-chateau', 16.08184, -61.60125),
(6578751, 9690363, 'GP', 'Nérée', 1, 'neree', 16.26465, -61.50046),
(6578757, 9690363, 'GP', 'Néau', 1, 'neau', 16.2, -61.61667),
(6578761, 9690363, 'GP', 'Habitation Murat', 1, 'habitation-murat', 15.88022, -61.3022),
(6578767, 9690363, 'GP', 'Moustique', 1, 'moustique', 16.30444, -61.67203),
(6578771, 9690363, 'GP', 'Morphy', 1, 'morphy', 16.24551, -61.79725),
(6578772, 9690363, 'GP', 'Morne Rouge', 1, 'morne-rouge', 16.30597, -61.65561),
(6578776, 9690363, 'GP', 'Morne Bourg', 1, 'morne-bourg', 16.188, -61.59575),
(6578781, 9690363, 'GP', 'Morne-à-l\'Eau', 1, 'morne-a-l-eau', 16.33339, -61.4588),
(6578785, 9690363, 'GP', 'Moringlane', 1, 'moringlane', 15.92499, -61.30363),
(6578790, 9690363, 'GP', 'Montval', 1, 'montval', 16.05905, -61.72411),
(6578791, 9690363, 'GP', 'Monplaisir', 1, 'monplaisir', 16.32071, -61.69057),
(6578792, 9690363, 'GP', 'Montebello', 1, 'montebello', 16.17656, -61.60199),
(6578793, 9690363, 'GP', 'Montalègre', 1, 'montalegre', 16.43413, -61.50351),
(6578800, 9690363, 'GP', 'Monroc', 1, 'monroc', 16.44318, -61.4981),
(6578801, 9690363, 'GP', 'Mon Repos', 1, 'mon-repos', 15.91623, -61.2936),
(6578810, 9690363, 'GP', 'Métivier', 1, 'metivier', 16.08333, -61.75),
(6578812, 9690363, 'GP', 'Merlet', 1, 'merlet', 15.97488, -61.30054),
(6578814, 9690363, 'GP', 'Ménard', 1, 'menard', 16.00253, -61.28647),
(6578818, 9690363, 'GP', 'Mazeau', 1, 'mazeau', 16.2948, -61.78839),
(6578825, 9690363, 'GP', 'Matouba', 1, 'matouba', 16.04256, -61.69481),
(6578826, 9690363, 'GP', 'Mathurin Noël', 1, 'mathurin-noel', 16.1, -61.76667),
(6578829, 9690363, 'GP', 'Massol', 1, 'massol', 16.08333, -61.75),
(6578830, 9690363, 'GP', 'Massioux', 1, 'massioux', 16.46269, -61.46319),
(6578837, 9690363, 'GP', 'Marquisat', 1, 'marquisat', 16.04068, -61.56936),
(6578853, 9690363, 'GP', 'Marigot', 1, 'marigot', 16.08282, -61.76707),
(6578854, 9690363, 'GP', 'Marie-Thérèse', 1, 'marie-therese', 16.4567, -61.45056),
(6578855, 9690363, 'GP', 'Marie-Louise', 1, 'marie-louise', 15.98156, -61.27893),
(6578860, 9690363, 'GP', 'Mare Gaillard', 1, 'mare-gaillard', 16.2153, -61.4393),
(6578862, 9690363, 'GP', 'Maréchal', 1, 'marechal', 15.91819, -61.32931),
(6578863, 9690363, 'GP', 'Marchand', 1, 'marchand', 16.31994, -61.42081),
(6578870, 9690363, 'GP', 'Matignon', 1, 'matignon', 16.29388, -61.4284),
(6578872, 9690363, 'GP', 'Malgrétout', 1, 'malgretout', 16.45175, -61.45654),
(6578873, 9690363, 'GP', 'Bel Arbre du Malgré Tout', 1, 'bel-arbre-du-malgre-tout', 16.26586, -61.26445),
(6578874, 9690363, 'GP', 'Maletie', 1, 'maletie', 15.99781, -61.26689),
(6578878, 9690363, 'GP', 'Maisoncelle', 1, 'maisoncelle', 16.37576, -61.47048),
(6578881, 9690363, 'GP', 'Mahaut', 1, 'mahaut', 16.19272, -61.7806),
(6578886, 9690363, 'GP', 'Mahaudière', 1, 'mahaudiere', 16.46744, -61.50521),
(6578891, 9690363, 'GP', 'Madeleine', 1, 'madeleine', 16.03534, -61.73872),
(6578906, 9690363, 'GP', 'Louisiane', 1, 'louisiane', 16.26256, -61.39512),
(6578914, 9690363, 'GP', 'Longval', 1, 'longval', 16.26667, -61.5),
(6578916, 9690363, 'GP', 'Longmont', 1, 'longmont', 16.01667, -61.6),
(6578918, 9690363, 'GP', 'Littoral', 1, 'littoral', 15.95884, -61.31837),
(6578919, 9690363, 'GP', 'L\'Îlet', 1, 'l-ilet', 16.28333, -61.51667),
(6578920, 9690363, 'GP', 'L\'Habituée', 1, 'l-habituee', 16.02229, -61.60296),
(6578926, 9690363, 'GP', 'L\'Étang Noir', 1, 'l-etang-noir', 15.9378, -61.24599),
(6578928, 9690363, 'GP', 'Lesueur', 1, 'lesueur', 16.08333, -61.75),
(6578935, 9690363, 'GP', 'Les Sables', 1, 'les-sables', 16.29955, -61.08126),
(6578938, 9690363, 'GP', 'Les Plaines', 1, 'les-plaines', 16.22512, -61.76421),
(6578943, 9690363, 'GP', 'Le Souffleur', 1, 'le-souffleur', 16.31447, -61.04098),
(6578944, 9690363, 'GP', 'Les Mangles', 1, 'les-mangles', 16.39253, -61.45754),
(6578951, 9690363, 'GP', 'Les Galets', 1, 'les-galets', 16.2976, -61.09336),
(6578953, 9690363, 'GP', 'Les Basses', 1, 'les-basses', 15.87175, -61.28426),
(6578959, 9690363, 'GP', 'Les Abymes', 1, 'les-abymes', 16.273, -61.50507),
(6578960, 9690363, 'GP', 'L\'Ermitage', 1, 'l-ermitage', 16.4347, -61.45732),
(6578967, 9690363, 'GP', 'Le Moule', 1, 'le-moule', 16.33164, -61.34656),
(6578968, 9690363, 'GP', 'Lemercier', 1, 'lemercier', 16.3292, -61.35469),
(6578972, 9690363, 'GP', 'Le Haut du Morne des Pères', 1, 'le-haut-du-morne-des-peres', 15.90189, -61.22654),
(6578978, 9690363, 'GP', 'Le Gosier', 1, 'le-gosier', 16.20618, -61.49306),
(6578989, 9690363, 'GP', 'Lauréal', 1, 'laureal', 16.31987, -61.34468),
(6578997, 9690363, 'GP', 'Lasserre', 1, 'lasserre', 16.31908, -61.43024),
(6578998, 9690363, 'GP', 'La Source', 1, 'la-source', 16.13333, -61.76667),
(6579001, 9690363, 'GP', 'La Rosière', 1, 'la-rosiere', 16.24048, -61.6544),
(6579002, 9690363, 'GP', 'La Rosette', 1, 'la-rosette', 16.33644, -61.37548),
(6579006, 9690363, 'GP', 'La Retraite', 1, 'la-retraite', 16.22964, -61.61828),
(6579010, 9690363, 'GP', 'La Ramée', 1, 'la-ramee', 16.33293, -61.71),
(6579013, 9690363, 'GP', 'La Plaine', 1, 'la-plaine', 15.99527, -61.62494),
(6579017, 9690363, 'GP', 'L\'Anglais', 1, 'l-anglais', 16.33844, -61.38661),
(6579019, 9690363, 'GP', 'Lamothe', 1, 'lamothe', 16.25084, -61.42613),
(6579020, 9690363, 'GP', 'Lami', 1, 'lami', 15.8925, -61.31179),
(6579023, 9690363, 'GP', 'Lamentin', 1, 'lamentin', 16.27047, -61.63166),
(6579025, 9690363, 'GP', 'La Martinière', 1, 'la-martiniere', 16.31667, -61.36667),
(6579028, 9690363, 'GP', 'La Lise', 1, 'la-lise', 16.15878, -61.77464),
(6579030, 9690363, 'GP', 'Lalanne', 1, 'lalanne', 16.41063, -61.51827),
(6579033, 9690363, 'GP', 'La Jaille', 1, 'la-jaille', 16.25954, -61.5749),
(6579034, 9690363, 'GP', 'La Grivelière', 1, 'la-griveliere', 16.07157, -61.72883),
(6579035, 9690363, 'GP', 'La Grange', 1, 'la-grange', 16.13333, -61.56667),
(6579045, 9690363, 'GP', 'Goguette', 1, 'goguette', 16.44944, -61.51592),
(6579052, 9690363, 'GP', 'Lacroix', 1, 'lacroix', 16.4, -61.43333),
(6579054, 9690363, 'GP', 'La Coulisse', 1, 'la-coulisse', 16.06932, -61.73273),
(6579058, 9690363, 'GP', 'La Chapelle', 1, 'la-chapelle', 15.88481, -61.2606),
(6579062, 9690363, 'GP', 'Labuthie', 1, 'labuthie', 16.32563, -61.51337),
(6579063, 9690363, 'GP', 'La Boucan', 1, 'la-boucan', 16.28254, -61.66983),
(6579066, 9690363, 'GP', 'La Berthaudière', 1, 'la-berthaudiere', 16.47832, -61.47711),
(6579068, 9690363, 'GP', 'Labarthe', 1, 'labarthe', 16.28946, -61.28571),
(6579069, 9690363, 'GP', 'La Barrière', 1, 'la-barriere', 16.21667, -61.46667),
(6579091, 9690363, 'GP', 'Jacquelot', 1, 'jacquelot', 15.93938, -61.21782),
(6579093, 9690363, 'GP', 'Jabrun', 1, 'jabrun', 16.30703, -61.44494),
(6579099, 9690363, 'GP', 'Îlet Pérou', 1, 'ilet-perou', 16.05727, -61.57067),
(6579102, 9690363, 'GP', 'Hurault', 1, 'hurault', 16.05, -61.56667),
(6579105, 9690363, 'GP', 'Houëlbourg', 1, 'houelbourg', 16.23711, -61.57485),
(6579117, 9690363, 'GP', 'Hauteurs Lézarde', 1, 'hauteurs-lezarde', 16.19762, -61.63003),
(6579118, 9690363, 'GP', 'Haut de la Montagne', 1, 'haut-de-la-montagne', 16.43898, -61.47461),
(6579124, 9690363, 'GP', 'Hameau', 1, 'hameau', 16.4, -61.41667),
(6579134, 9690363, 'GP', 'Guyot', 1, 'guyot', 16.28743, -61.26869),
(6579135, 9690363, 'GP', 'Guillocheau', 1, 'guillocheau', 16.31667, -61.33333),
(6579158, 9690363, 'GP', 'Gros Morne', 1, 'gros-morne', 16.21667, -61.78333),
(6579169, 9690363, 'GP', 'Gros Cap', 1, 'gros-cap', 16.40597, -61.41812),
(6579178, 9690363, 'GP', 'Gresset', 1, 'gresset', 16.06667, -61.56667),
(6579179, 9690363, 'GP', 'Grenade', 1, 'grenade', 16.1, -61.75),
(6579180, 9690363, 'GP', 'Grelin', 1, 'grelin', 15.95956, -61.27465),
(6579183, 9690363, 'GP', 'Grands Fonds', 1, 'grands-fonds', 16.26309, -61.42396),
(6579187, 9690363, 'GP', 'Grand Pierre', 1, 'grand-pierre', 15.9682, -61.28936),
(6579203, 9690363, 'GP', 'Grand Étang', 1, 'grand-etang', 15.93333, -61.21667),
(6579208, 9690363, 'GP', 'Grande Savane', 1, 'grande-savane', 16.18487, -61.61762),
(6579214, 9690363, 'GP', 'Grande Rivière', 1, 'grande-riviere', 16.08333, -61.71667),
(6579219, 9690363, 'GP', 'Grande Plaine', 1, 'grande-plaine', 16.20725, -61.77633),
(6579232, 9690363, 'GP', 'Beauséjour', 1, 'beausejour', 16.30413, -61.07375),
(6579233, 9690363, 'GP', 'Grande Anse sur Morne', 1, 'grande-anse-sur-morne', 15.96511, -61.66605),
(6579234, 9690363, 'GP', 'Grand-Anse', 1, 'grand-anse', 15.91389, -61.32781),
(6579235, 9690363, 'GP', 'Grande Anse', 1, 'grande-anse', 15.85765, -61.62354),
(6579244, 9690363, 'GP', 'Grand\'Croix', 1, 'grand-croix', 16.05024, -61.74885),
(6579246, 9690363, 'GP', 'Grand Case', 1, 'grand-case', 15.93348, -61.21754),
(6579248, 9690363, 'GP', 'Grand\'Case', 1, 'grand-case', 16.21667, -61.78333),
(6579250, 9690363, 'GP', 'Grand-Bourg', 1, 'grand-bourg', 15.88402, -61.3148),
(6579251, 9690363, 'GP', 'Grand Bois', 1, 'grand-bois', 16.24396, -61.46195),
(6579253, 9690363, 'GP', 'Grand Bassin', 1, 'grand-bassin', 15.9603, -61.24076),
(6579259, 9690363, 'GP', 'Goyave', 1, 'goyave', 16.13524, -61.57457),
(6579267, 9690363, 'GP', 'Gourbeyre', 1, 'gourbeyre', 15.99454, -61.69203),
(6579277, 9690363, 'GP', 'Girard', 1, 'girard', 15.91181, -61.21308),
(6579280, 9690363, 'GP', 'Gest', 1, 'gest', 16.07794, -61.74988),
(6579281, 9690363, 'GP', 'Gensolin', 1, 'gensolin', 16.31313, -61.47697),
(6579283, 9690363, 'GP', 'Gay', 1, 'gay', 15.92563, -61.31464),
(6579287, 9690363, 'GP', 'Garnier', 1, 'garnier', 16.31375, -61.49738),
(6579288, 9690363, 'GP', 'Garel', 1, 'garel', 15.94594, -61.25223),
(6579290, 9690363, 'GP', 'Gardel', 1, 'gardel', 16.30623, -61.32658),
(6579293, 9690363, 'GP', 'Gallard', 1, 'gallard', 16.00968, -61.69397),
(6579301, 9690363, 'GP', 'Galebas', 1, 'galebas', 16.3022, -61.67472),
(6579321, 9690363, 'GP', 'Fouché', 1, 'fouche', 16.24318, -61.40281),
(6579328, 9690363, 'GP', 'Fontaine', 1, 'fontaine', 16.31667, -61.4),
(6579329, 9690363, 'GP', 'Fonds d\'Or', 1, 'fonds-d-or', 16.3, -61.35),
(6579330, 9690363, 'GP', 'Fonds Cacao', 1, 'fonds-cacao', 16.03619, -61.59125),
(6579348, 9690363, 'GP', 'Fexland', 1, 'fexland', 16.35, -61.46667),
(6579354, 9690363, 'GP', 'Ferry', 1, 'ferry', 16.27811, -61.80201),
(6579360, 9690363, 'GP', 'Favreau', 1, 'favreau', 16.25, -61.3),
(6579361, 9690363, 'GP', 'Faup', 1, 'faup', 15.91505, -61.30895),
(6579371, 9690363, 'GP', 'Émilien', 1, 'emilien', 16.31667, -61.43333),
(6579382, 9690363, 'GP', 'Duzer', 1, 'duzer', 16.34332, -61.73626),
(6579383, 9690363, 'GP', 'Durocher', 1, 'durocher', 15.91537, -61.27338),
(6579384, 9690363, 'GP', 'Durivage', 1, 'durivage', 16.22408, -61.3994),
(6579389, 9690363, 'GP', 'Dupuy', 1, 'dupuy', 16.25853, -61.61358),
(6579390, 9690363, 'GP', 'Dupré', 1, 'dupre', 16.22612, -61.3909),
(6579393, 9690363, 'GP', 'Ducos', 1, 'ducos', 15.89247, -61.29314),
(6579395, 9690363, 'GP', 'Dubois', 1, 'dubois', 16.2, -61.6),
(6579399, 9690363, 'GP', 'Dubédou', 1, 'dubedou', 16.29685, -61.28711),
(6579401, 9690363, 'GP', 'Douville', 1, 'douville', 16.25986, -61.37729),
(6579406, 9690363, 'GP', 'Dorilas', 1, 'dorilas', 16.08333, -61.76667),
(6579409, 9690363, 'GP', 'Dolé', 1, 'dole', 15.98948, -61.66999),
(6579411, 9690363, 'GP', 'Diavet', 1, 'diavet', 16.31635, -61.68954),
(6579417, 9690363, 'GP', 'Destrellan', 1, 'destrellan', 16.25575, -61.58112),
(6579418, 9690363, 'GP', 'Desruisseaux', 1, 'desruisseaux', 15.9467, -61.22003),
(6579419, 9690363, 'GP', 'Desplan', 1, 'desplan', 16.21667, -61.76667),
(6579420, 9690363, 'GP', 'Desmarais', 1, 'desmarais', 15.95601, -61.30797),
(6579423, 9690363, 'GP', 'La Désirade', 1, 'la-desirade', 16.31175, -61.05269),
(6579426, 9690363, 'GP', 'Deshauteurs', 1, 'deshauteurs', 16.25098, -61.43132),
(6579429, 9690363, 'GP', 'Deshaies', 1, 'deshaies', 16.30672, -61.79435),
(6579431, 9690363, 'GP', 'Descostiers', 1, 'descostiers', 16.28333, -61.65),
(6579434, 9690363, 'GP', 'Desbonnes', 1, 'desbonnes', 16.3305, -61.75192),
(6579436, 9690363, 'GP', 'D\'Équainville', 1, 'd-equainville', 16.25, -61.38333),
(6579437, 9690363, 'GP', 'De Poyen', 1, 'de-poyen', 16.18333, -61.61667),
(6579456, 9690363, 'GP', 'Courcelles', 1, 'courcelles', 16.25602, -61.33035),
(6579457, 9690363, 'GP', 'Courbaril', 1, 'courbaril', 15.95716, -61.30415),
(6579501, 9690363, 'GP', 'Coignet', 1, 'coignet', 16.36667, -61.41667),
(6579503, 9690363, 'GP', 'Cocoyer', 1, 'cocoyer', 16.23719, -61.48254),
(6579509, 9690363, 'GP', 'Clugny', 1, 'clugny', 16.31351, -61.40662),
(6579525, 9690363, 'GP', 'Chazeau', 1, 'chazeau', 16.29556, -61.45928),
(6579533, 9690363, 'GP', 'Château Gaillard', 1, 'chateau-gaillard', 16.30952, -61.39734),
(6579534, 9690363, 'GP', 'Châteaubrun', 1, 'chateaubrun', 16.25236, -61.35359),
(6579536, 9690363, 'GP', 'Chassaing', 1, 'chassaing', 16.25707, -61.23445),
(6579537, 9690363, 'GP', 'Chartreux', 1, 'chartreux', 16.23563, -61.66383),
(6579538, 9690363, 'GP', 'Charneau', 1, 'charneau', 16, -61.66667),
(6579543, 9690363, 'GP', 'Champfleury', 1, 'champfleury', 15.98358, -61.68035),
(6579547, 9690363, 'GP', 'Chalet', 1, 'chalet', 15.96206, -61.31804),
(6579553, 9690363, 'GP', 'Castel', 1, 'castel', 16.25893, -61.66706),
(6579572, 9690363, 'GP', 'Carbet', 1, 'carbet', 16.01667, -61.58333),
(6579573, 9690363, 'GP', 'Caraque', 1, 'caraque', 16.25203, -61.48937),
(6579576, 9690363, 'GP', 'Carangaise', 1, 'carangaise', 16.08011, -61.57072),
(6579585, 9690363, 'GP', 'Capesterre-Belle-Eau', 1, 'capesterre-belle-eau', 16.04495, -61.56425),
(6579591, 9690363, 'GP', 'Capesterre-de-Marie-Galante', 1, 'capesterre-de-marie-galante', 15.88333, -61.21667),
(6579599, 9690363, 'GP', 'Camp Jacob', 1, 'camp-jacob', 16.02887, -61.69174),
(6579600, 9690363, 'GP', 'Campêche', 1, 'campeche', 16.44312, -61.43813),
(6579601, 9690363, 'GP', 'Cambrefort', 1, 'cambrefort', 16.07127, -61.57718),
(6579602, 9690363, 'GP', 'Ménard Cambrai', 1, 'menard-cambrai', 15.99992, -61.27446),
(6579603, 9690363, 'GP', 'Calvaire', 1, 'calvaire', 16.26271, -61.38685),
(6579607, 9690363, 'GP', 'Caféière', 1, 'cafeiere', 16.32409, -61.7732),
(6579608, 9690363, 'GP', 'Cadet de Reine', 1, 'cadet-de-reine', 16.1, -61.75),
(6579610, 9690363, 'GP', 'Cadet', 1, 'cadet', 16.26724, -61.68386),
(6579617, 9690363, 'GP', 'Budan', 1, 'budan', 16.24329, -61.60875),
(6579618, 9690363, 'GP', 'Brument', 1, 'brument', 16.41566, -61.50568),
(6579619, 9690363, 'GP', 'Brouel', 1, 'brouel', 16.08333, -61.76667),
(6579621, 9690363, 'GP', 'Brion', 1, 'brion', 16.32375, -61.45807),
(6579625, 9690363, 'GP', 'Bréfort', 1, 'brefort', 16.26699, -61.64032),
(6579628, 9690363, 'GP', 'Boyer', 1, 'boyer', 15.98333, -61.65),
(6579634, 9690363, 'GP', 'Bouliqui', 1, 'bouliqui', 16.25905, -61.45539),
(6579637, 9690363, 'GP', 'Bouillé', 1, 'bouille', 16.18333, -61.6),
(6579642, 9690363, 'GP', 'Bouillante', 1, 'bouillante', 16.13043, -61.76895),
(6579647, 9690363, 'GP', 'Bosrédon', 1, 'bosredon', 16.31292, -61.48407),
(6579649, 9690363, 'GP', 'Boricaud', 1, 'boricaud', 16.28381, -61.44661),
(6579650, 9690363, 'GP', 'Borel', 1, 'borel', 16.26641, -61.63056),
(6579651, 9690363, 'GP', 'Borée', 1, 'boree', 15.95134, -61.227),
(6579652, 9690363, 'GP', 'Bord de Mer', 1, 'bord-de-mer', 15.96849, -61.6429),
(6579655, 9690363, 'GP', 'Bontemps Rameau', 1, 'bontemps-rameau', 15.9239, -61.21112),
(6579657, 9690363, 'GP', 'Bonneval', 1, 'bonneval', 15.8929, -61.31916),
(6579659, 9690363, 'GP', 'Bonnet', 1, 'bonnet', 15.92353, -61.28765),
(6579660, 9690363, 'GP', 'Bonne Mère', 1, 'bonne-mere', 16.26741, -61.67614),
(6579661, 9690363, 'GP', 'Bonfils', 1, 'bonfils', 16.06667, -61.56667),
(6579662, 9690363, 'GP', 'Bon', 1, 'bon', 15.95, -61.31667),
(6579665, 9690363, 'GP', 'Boivin', 1, 'boivin', 16.26667, -61.36667),
(6579667, 9690363, 'GP', 'Boisvin', 1, 'boisvin', 16.29805, -61.35005),
(6579671, 9690363, 'GP', 'Boismorin', 1, 'boismorin', 16.4, -61.48333),
(6579675, 9690363, 'GP', 'Habitation Bois Debout', 1, 'habitation-bois-debout', 16.0245, -61.58693),
(6579678, 9690363, 'GP', 'Blondin', 1, 'blondin', 16.03333, -61.75),
(6579682, 9690363, 'GP', 'Blanchet', 1, 'blanchet', 16.32502, -61.41453),
(6579686, 9690363, 'GP', 'Bisdary', 1, 'bisdary', 15.98874, -61.70924),
(6579687, 9690363, 'GP', 'Bis', 1, 'bis', 16.27613, -61.68817),
(6579689, 9690363, 'GP', 'Bichemin', 1, 'bichemin', 16.07721, -61.74406),
(6579690, 9690363, 'GP', 'Bézard', 1, 'bezard', 15.93472, -61.23739),
(6579691, 9690363, 'GP', 'Bétin', 1, 'betin', 16.44763, -61.5142),
(6579692, 9690363, 'GP', 'Besnard', 1, 'besnard', 16.38355, -61.43892),
(6579698, 9690363, 'GP', 'Bérard', 1, 'berard', 16.25875, -61.35625),
(6579701, 9690363, 'GP', 'Bellevue', 1, 'bellevue', 16.44154, -61.44664),
(6579704, 9690363, 'GP', 'Belle-Plaine', 1, 'belle-plaine', 16.2896, -61.52179),
(6579705, 9690363, 'GP', 'Belle Place', 1, 'belle-place', 16.26676, -61.43647),
(6579707, 9690363, 'GP', 'Belle Espérance', 1, 'belle-esperance', 16.31225, -61.50796),
(6579708, 9690363, 'GP', 'Belle Allée', 1, 'belle-allee', 16.25481, -61.30304),
(6579712, 9690363, 'GP', 'Bel-Air', 1, 'bel-air', 16.06981, -61.75741),
(6579714, 9690363, 'GP', 'Beausoleil', 1, 'beausoleil', 16.25956, -61.79223),
(6579717, 9690363, 'GP', 'Beaurenom', 1, 'beaurenom', 15.87893, -61.30686),
(6579718, 9690363, 'GP', 'Beauregard', 1, 'beauregard', 15.88874, -61.25613),
(6579720, 9690363, 'GP', 'Beauport', 1, 'beauport', 16.41727, -61.51493),
(6579721, 9690363, 'GP', 'Beauplan', 1, 'beauplan', 16.41046, -61.46895),
(6579724, 9690363, 'GP', 'Beaugendre', 1, 'beaugendre', 16.08908, -61.75499),
(6579726, 9690363, 'GP', 'Bazin', 1, 'bazin', 16.36969, -61.45142),
(6579729, 9690363, 'GP', 'Bas-Vent', 1, 'bas-vent', 16.3423, -61.77072),
(6579731, 9690363, 'GP', 'Arrondissement de la Basse-Terre', 1, 'arrondissement-de-la-basse-terre', 16.16667, -61.66667),
(6579732, 9690363, 'GP', 'Basse-Terre', 1, 'basse-terre', 15.99714, -61.73214),
(6579736, 9690363, 'GP', 'Bas du Fort', 1, 'bas-du-fort', 16.21635, -61.52109),
(6579739, 9690363, 'GP', 'Barre de l\'Île', 1, 'barre-de-l-ile', 15.94972, -61.27514),
(6579747, 9690363, 'GP', 'Barbier', 1, 'barbier', 16.16667, -61.6),
(6579752, 9690363, 'GP', 'Bananier', 1, 'bananier', 16.00116, -61.60134),
(6579757, 9690363, 'GP', 'Ballet', 1, 'ballet', 15.90464, -61.32644),
(6579759, 9690363, 'GP', 'Baimbridge', 1, 'baimbridge', 16.24307, -61.51885),
(6579761, 9690363, 'GP', 'Baillif', 1, 'baillif', 16.02037, -61.74611),
(6579765, 9690363, 'GP', 'Baille-Argent', 1, 'baille-argent', 16.26009, -61.8033),
(6579766, 9690363, 'GP', 'Baie Mahault', 1, 'baie-mahault', 16.32974, -61.02032),
(6579767, 9690363, 'GP', 'Baie-Mahault', 1, 'baie-mahault', 16.26738, -61.58543),
(6579769, 9690363, 'GP', 'Bagatelle', 1, 'bagatelle', 15.9551, -61.30318),
(6579773, 9690363, 'GP', 'Ausset', 1, 'ausset', 16.06667, -61.76667),
(6579789, 9690363, 'GP', 'Anse-Bertrand', 1, 'anse-bertrand', 16.47239, -61.50739),
(6579804, 9690363, 'GP', 'Agapy', 1, 'agapy', 15.98727, -61.26518),
(6579806, 9690363, 'GP', 'Acomat', 1, 'acomat', 16.21337, -61.7658);