REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('LC', 'Saint Lucia', 'saint-lucia', '+1-758', 'Saint Lucia', 'XCD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003757, 'LC', 'Anse la Raye Quarter', 1, 'anse-la-raye-quarter');

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 
(1065965, 1003757, 'LC', 'Anse La Raye', 1, 'anse-la-raye', 13.94619000, -61.03879000),
(1065969, 1003757, 'LC', 'Au Tabor', 1, 'au-tabor', 13.94540000, -61.04112000),
(1065970, 1003757, 'LC', 'Au Tabor Hill', 1, 'au-tabor-hill', 13.94457000, -61.03559000),
(1066019, 1003757, 'LC', 'Bois D\'Inde', 1, 'bois-d-inde', 13.94148000, -61.00966000),
(1066037, 1003757, 'LC', 'Caico/Millet', 1, 'caico-millet', 13.91948000, -60.99264000),
(1066040, 1003757, 'LC', 'Canaries', 1, 'canaries', 13.90224000, -61.06459000),
(1066064, 1003757, 'LC', 'Champen Estate', 1, 'champen-estate', 13.93575000, -61.02991000),
(1066112, 1003757, 'LC', 'Derriere Lagoon', 1, 'derriere-lagoon', 13.94168000, -61.01891000),
(1066128, 1003757, 'LC', 'Durandeau', 1, 'durandeau', 13.92277000, -60.99512000),
(1066132, 1003757, 'LC', 'Enbar Pwin', 1, 'enbar-pwin', 13.91175000, -60.99266000),
(1066198, 1003757, 'LC', 'Jacmel', 1, 'jacmel', 13.94796000, -61.01297000),
(1066200, 1003757, 'LC', 'Jean Baptiste', 1, 'jean-baptiste', 13.94704000, -61.01578000),
(1066231, 1003757, 'LC', 'La Trielle', 1, 'la-trielle', 13.94014000, -60.99729000),
(1066260, 1003757, 'LC', 'Massacre', 1, 'massacre', 13.94872000, -61.03544000),
(1066266, 1003757, 'LC', 'Millet', 1, 'millet', 13.90985000, -60.98884000),
(1066294, 1003757, 'LC', 'Morne Ciseaux', 1, 'morne-ciseaux', 13.93597000, -61.00330000),
(1066296, 1003757, 'LC', 'Morne D\'Or', 1, 'morne-d-or', 13.94931000, -61.00601000),
(1066365, 1003757, 'LC', 'Roseau Valley', 1, 'roseau-valley', 13.95317000, -61.02676000),
(1066381, 1003757, 'LC', 'St Lawrence', 1, 'st-lawrence', 13.93852000, -61.02503000),
(1066382, 1003757, 'LC', 'St Lawrence Estate', 1, 'st-lawrence-estate', 13.94236000, -61.04248000),
(1066392, 1003757, 'LC', 'Tete Chemin', 1, 'tete-chemin', 13.89092000, -60.99785000),
(1066416, 1003757, 'LC', 'Vanard', 1, 'vanard', 13.93558000, -60.99363000),
(1066417, 1003757, 'LC', 'Venus', 1, 'venus', 13.91558000, -61.01676000),
(1066427, 1003757, 'LC', 'Village', 1, 'village', 13.93939000, -61.04150000),
(1066429, 1003757, 'LC', 'Village/Petite Bourgh', 1, 'village-petite-bourgh', 13.93801000, -61.04184000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003761, 'LC', 'Canaries', 1, 'canaries');

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 
(1065962, 1003761, 'LC', 'Anse Cochon', 1, 'anse-cochon', 13.92261000, -61.05250000),
(1065963, 1003761, 'LC', 'Anse Galet', 1, 'anse-galet', 13.93221000, -61.04290000),
(1065966, 1003761, 'LC', 'Anse La Verdue', 1, 'anse-la-verdue', 13.90964000, -61.04755000),
(1066006, 1003761, 'LC', 'Belvedere', 1, 'belvedere', 13.89122000, -61.05550000),
(1066063, 1003761, 'LC', 'Chalon', 1, 'chalon', 13.92018000, -61.04412000),
(1066359, 1003761, 'LC', 'Riverside Road', 1, 'riverside-road', 13.89408000, -61.04989000),
(1066397, 1003761, 'LC', 'Theodrine', 1, 'theodrine', 13.92878000, -61.04972000),
(1066428, 1003761, 'LC', 'Village', 1, 'village', 13.90526000, -61.06108000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003758, 'LC', 'Castries Quarter', 1, 'castries-quarter');

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 
(1065956, 1003758, 'LC', 'Active Hill', 1, 'active-hill', 14.01940000, -60.97767000),
(1065957, 1003758, 'LC', 'Agard Lands/Morne Dudon', 1, 'agard-lands-morne-dudon', 14.00768000, -60.96462000),
(1065958, 1003758, 'LC', 'Almondale', 1, 'almondale', 14.01848000, -60.96162000),
(1065972, 1003758, 'LC', 'Aurendel Hill', 1, 'aurendel-hill', 14.00069000, -60.98670000),
(1065973, 1003758, 'LC', 'Babonneau Proper', 1, 'babonneau-proper', 14.00535000, -60.94640000),
(1065974, 1003758, 'LC', 'Bagatelle', 1, 'bagatelle', 13.99797000, -60.98156000),
(1065975, 1003758, 'LC', 'Balata', 1, 'balata', 14.01471000, -60.95167000),
(1065979, 1003758, 'LC', 'Banannes Bay', 1, 'banannes-bay', 14.01087000, -61.00135000),
(1065983, 1003758, 'LC', 'Barnard Hill', 1, 'barnard-hill', 14.01423000, -60.98924000),
(1065985, 1003758, 'LC', 'Barre Denis', 1, 'barre-denis', 13.96809000, -60.99073000),
(1065986, 1003758, 'LC', 'Barre Duchaussee', 1, 'barre-duchaussee', 13.96190000, -60.99678000),
(1065987, 1003758, 'LC', 'Barre St.Joseph', 1, 'barre-st-joseph', 13.97247000, -61.01829000),
(1065996, 1003758, 'LC', 'Belair', 1, 'belair', 13.95283000, -60.99747000),
(1065998, 1003758, 'LC', 'Bella Rosa', 1, 'bella-rosa', 14.00777000, -60.99628000),
(1066008, 1003758, 'LC', 'Bexon', 1, 'bexon', 13.96077000, -60.97497000),
(1066009, 1003758, 'LC', 'Bisee', 1, 'bisee', 14.02429000, -60.97445000),
(1066010, 1003758, 'LC', 'Bishop\'S Gap', 1, 'bishop-s-gap', 14.00019000, -60.98498000),
(1066011, 1003758, 'LC', 'Bissee', 1, 'bissee', 14.02255000, -60.97489000),
(1066013, 1003758, 'LC', 'Black Mallet', 1, 'black-mallet', 14.00457000, -60.98811000),
(1066015, 1003758, 'LC', 'Bocage', 1, 'bocage', 14.00199000, -60.96954000),
(1066018, 1003758, 'LC', 'Bois Catchet', 1, 'bois-catchet', 14.00399000, -60.99437000),
(1066025, 1003758, 'LC', 'Bois Patat', 1, 'bois-patat', 14.00892000, -60.98214000),
(1066033, 1003758, 'LC', 'Cabiche/Babonneau', 1, 'cabiche-babonneau', 14.00583000, -60.95432000),
(1066035, 1003758, 'LC', 'Cacoa/Babonneau', 1, 'cacoa-babonneau', 13.98875000, -60.95113000),
(1066038, 1003758, 'LC', 'Calvary', 1, 'calvary', 14.01391000, -60.98664000),
(1066052, 1003758, 'LC', 'Capital Hill', 1, 'capital-hill', 13.99307000, -60.99097000),
(1066053, 1003758, 'LC', 'Carellie', 1, 'carellie', 14.01889000, -60.96851000),
(1066056, 1003758, 'LC', 'Castries', 1, 'castries', 13.99570000, -61.00614000),
(1066060, 1003758, 'LC', 'Cedars', 1, 'cedars', 14.00601000, -60.98232000),
(1066065, 1003758, 'LC', 'Chase Gardens', 1, 'chase-gardens', 14.01481000, -60.97395000),
(1066066, 1003758, 'LC', 'Chassin/Babonneau', 1, 'chassin-babonneau', 13.99100000, -60.92187000),
(1066070, 1003758, 'LC', 'Choppin Ridge/Sarot', 1, 'choppin-ridge-sarot', 13.95597000, -60.98624000),
(1066072, 1003758, 'LC', 'Ciceron', 1, 'ciceron', 13.99296000, -61.00878000),
(1066073, 1003758, 'LC', 'City', 1, 'city', 14.00946000, -60.99027000),
(1066074, 1003758, 'LC', 'City Gate/La Clery', 1, 'city-gate-la-clery', 14.02124000, -60.98149000),
(1066078, 1003758, 'LC', 'Conway/Waterfront', 1, 'conway-waterfront', 14.01389000, -60.99055000),
(1066080, 1003758, 'LC', 'Coolie Town', 1, 'coolie-town', 13.95684000, -61.01437000),
(1066085, 1003758, 'LC', 'Coubaril', 1, 'coubaril', 14.00223000, -61.00919000),
(1066087, 1003758, 'LC', 'Crownlands/Marc', 1, 'crownlands-marc', 13.95174000, -60.97150000),
(1066088, 1003758, 'LC', 'Cul De Sac', 1, 'cul-de-sac', 13.98084000, -61.00645000),
(1066091, 1003758, 'LC', 'Darling Road', 1, 'darling-road', 14.01355000, -60.98779000),
(1066095, 1003758, 'LC', 'Deglos', 1, 'deglos', 13.97727000, -60.97329000),
(1066106, 1003758, 'LC', 'Derierre Fort/Old Victoria Road', 1, 'derierre-fort-old-victoria-road', 13.99474000, -60.98513000),
(1066124, 1003758, 'LC', 'Dubrassay', 1, 'dubrassay', 13.98382000, -60.97154000),
(1066131, 1003758, 'LC', 'En Pois Doux/Babonneau', 1, 'en-pois-doux-babonneau', 13.98853000, -60.94099000),
(1066133, 1003758, 'LC', 'Entrepot', 1, 'entrepot', 13.99978000, -60.97953000),
(1066139, 1003758, 'LC', 'Faux A Chaud', 1, 'faux-a-chaud', 14.00878000, -60.99558000),
(1066140, 1003758, 'LC', 'Ferrand', 1, 'ferrand', 13.98684000, -60.98494000),
(1066141, 1003758, 'LC', 'Floissac/Marc', 1, 'floissac-marc', 13.96283000, -60.95880000),
(1066142, 1003758, 'LC', 'Fond Assau/Babonneau', 1, 'fond-assau-babonneau', 13.99491000, -60.93626000),
(1066146, 1003758, 'LC', 'Fond Canie', 1, 'fond-canie', 13.99195000, -60.95954000),
(1066154, 1003758, 'LC', 'Forestiere', 1, 'forestiere', 13.97775000, -60.95766000),
(1066160, 1003758, 'LC', 'George Charles Boulevard', 1, 'george-charles-boulevard', 14.00499000, -60.98673000),
(1066162, 1003758, 'LC', 'Girard', 1, 'girard', 14.00004000, -60.95960000),
(1066164, 1003758, 'LC', 'Goergeville', 1, 'goergeville', 14.01311000, -60.98446000),
(1066166, 1003758, 'LC', 'Goodlands', 1, 'goodlands', 13.99121000, -60.99840000),
(1066182, 1003758, 'LC', 'Grass Street', 1, 'grass-street', 14.00706000, -60.98763000),
(1066183, 1003758, 'LC', 'Green Gold', 1, 'green-gold', 13.99603000, -60.95284000),
(1066187, 1003758, 'LC', 'Guesneau', 1, 'guesneau', 13.99084000, -60.96486000),
(1066190, 1003758, 'LC', 'Hill 20/Babonneau', 1, 'hill-20-babonneau', 13.99941000, -60.94988000),
(1066191, 1003758, 'LC', 'Hillcrest Gardens', 1, 'hillcrest-gardens', 14.01115000, -60.97083000),
(1066194, 1003758, 'LC', 'Hospital Road', 1, 'hospital-road', 14.00914000, -60.99906000),
(1066195, 1003758, 'LC', 'Independence City', 1, 'independence-city', 14.00199000, -60.97879000),
(1066201, 1003758, 'LC', 'John Compton Highway', 1, 'john-compton-highway', 14.01909000, -60.99110000),
(1066204, 1003758, 'LC', 'L\'Anse Road', 1, 'l-anse-road', 14.01875000, -60.98799000),
(1066207, 1003758, 'LC', 'La Carierre', 1, 'la-carierre', 14.01806000, -60.98723000),
(1066209, 1003758, 'LC', 'La Clery', 1, 'la-clery', 14.01846000, -60.98422000),
(1066212, 1003758, 'LC', 'La Croix Maingot', 1, 'la-croix-maingot', 13.96569000, -61.00582000),
(1066218, 1003758, 'LC', 'La Pansee', 1, 'la-pansee', 14.01368000, -60.98187000),
(1066229, 1003758, 'LC', 'La Toc', 1, 'la-toc', 14.00824000, -61.00404000),
(1066232, 1003758, 'LC', 'Labayee', 1, 'labayee', 13.94044000, -60.97316000),
(1066235, 1003758, 'LC', 'Lastic Hill', 1, 'lastic-hill', 14.00755000, -60.98321000),
(1066238, 1003758, 'LC', 'Leslie Land', 1, 'leslie-land', 14.00752000, -60.98674000),
(1066250, 1003758, 'LC', 'Marc', 1, 'marc', 13.95688000, -60.95724000),
(1066251, 1003758, 'LC', 'Marchand', 1, 'marchand', 14.00415000, -60.98532000),
(1066252, 1003758, 'LC', 'Marigot', 1, 'marigot', 13.96212000, -61.02205000),
(1066262, 1003758, 'LC', 'Maynard Hill', 1, 'maynard-hill', 14.00314000, -60.98966000),
(1066263, 1003758, 'LC', 'Miami/Bexon', 1, 'miami-bexon', 13.92295000, -60.96945000),
(1066288, 1003758, 'LC', 'Monkey Town Ciceron', 1, 'monkey-town-ciceron', 13.98885000, -61.00615000),
(1066291, 1003758, 'LC', 'Morne Assau/Babonneau', 1, 'morne-assau-babonneau', 13.99079000, -60.93241000),
(1066297, 1003758, 'LC', 'Morne Dudon', 1, 'morne-dudon', 14.01194000, -60.96378000),
(1066304, 1003758, 'LC', 'Morne Road', 1, 'morne-road', 14.00544000, -60.99693000),
(1066305, 1003758, 'LC', 'Morne Rouge/Marc', 1, 'morne-rouge-marc', 13.95838000, -60.96972000),
(1066311, 1003758, 'LC', 'Mount Pleasant', 1, 'mount-pleasant', 14.01494000, -60.98576000),
(1066316, 1003758, 'LC', 'New Village', 1, 'new-village', 14.01104000, -60.98456000),
(1066318, 1003758, 'LC', 'Odsan', 1, 'odsan', 13.97479000, -60.98319000),
(1066325, 1003758, 'LC', 'Parker\'S Hill', 1, 'parker-s-hill', 14.00378000, -60.99049000),
(1066327, 1003758, 'LC', 'Patterson\'S Gap', 1, 'patterson-s-gap', 14.00655000, -60.98473000),
(1066328, 1003758, 'LC', 'Pavee', 1, 'pavee', 14.00282000, -60.99191000),
(1066329, 1003758, 'LC', 'Peart\'S Gap', 1, 'peart-s-gap', 14.01035000, -60.98598000),
(1066330, 1003758, 'LC', 'Perou', 1, 'perou', 13.95960000, -61.00726000),
(1066338, 1003758, 'LC', 'Pointe Seraphine', 1, 'pointe-seraphine', 14.01575000, -60.99305000),
(1066342, 1003758, 'LC', 'Quarte Chemins', 1, 'quarte-chemins', 13.99136000, -60.97630000),
(1066346, 1003758, 'LC', 'Ravine Chabot', 1, 'ravine-chabot', 14.00051000, -60.97617000),
(1066348, 1003758, 'LC', 'Ravine Poisson', 1, 'ravine-poisson', 13.93156000, -60.96849000),
(1066349, 1003758, 'LC', 'Ravine Touterelle', 1, 'ravine-touterelle', 14.00325000, -60.98806000),
(1066353, 1003758, 'LC', 'Resinard/Babonneau', 1, 'resinard-babonneau', 14.00289000, -60.94200000),
(1066361, 1003758, 'LC', 'Rock Hall', 1, 'rock-hall', 14.00009000, -60.98928000),
(1066364, 1003758, 'LC', 'Rose Hill', 1, 'rose-hill', 14.00816000, -60.98560000),
(1066369, 1003758, 'LC', 'San Soucis', 1, 'san-soucis', 14.01695000, -60.98985000),
(1066370, 1003758, 'LC', 'Sand De Feu', 1, 'sand-de-feu', 13.92781000, -60.98026000),
(1066372, 1003758, 'LC', 'Sarot', 1, 'sarot', 13.94212000, -60.98489000),
(1066387, 1003758, 'LC', 'Summersdale', 1, 'summersdale', 14.02582000, -60.97644000),
(1066388, 1003758, 'LC', 'Sunbilt', 1, 'sunbilt', 14.00561000, -60.97922000),
(1066389, 1003758, 'LC', 'Sunny Acres', 1, 'sunny-acres', 14.02810000, -60.97361000),
(1066390, 1003758, 'LC', 'Talvern', 1, 'talvern', 13.99578000, -60.94410000),
(1066391, 1003758, 'LC', 'Tapion', 1, 'tapion', 14.01383000, -61.00489000),
(1066396, 1003758, 'LC', 'The Morne', 1, 'the-morne', 13.99778000, -60.99620000),
(1066399, 1003758, 'LC', 'Ti Colon', 1, 'ti-colon', 13.97071000, -61.00229000),
(1066402, 1003758, 'LC', 'Ti Rocher', 1, 'ti-rocher', 13.99490000, -60.97110000),
(1066407, 1003758, 'LC', 'Trois Piton', 1, 'trois-piton', 13.98890000, -60.97259000),
(1066408, 1003758, 'LC', 'Trou Cochan/Marc', 1, 'trou-cochan-marc', 13.94220000, -60.96199000),
(1066409, 1003758, 'LC', 'Trou Florent/Marc', 1, 'trou-florent-marc', 13.94525000, -60.95382000),
(1066410, 1003758, 'LC', 'Trou Rouge', 1, 'trou-rouge', 14.00602000, -60.98950000),
(1066419, 1003758, 'LC', 'Vide Bouteille', 1, 'vide-bouteille', 14.02439000, -60.98066000),
(1066423, 1003758, 'LC', 'Vigie', 1, 'vigie', 14.02053000, -60.99611000),
(1066432, 1003758, 'LC', 'Waterworks', 1, 'waterworks', 14.00498000, -60.97635000),
(1066434, 1003758, 'LC', 'Wilton\'S Yard/Grave Yard', 1, 'wilton-s-yard-grave-yard', 14.00968000, -60.98639000),
(1066435, 1003758, 'LC', 'Yorke Hill', 1, 'yorke-hill', 14.01694000, -60.97919000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003760, 'LC', 'Choiseul Quarter', 1, 'choiseul-quarter');

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 
(1066000, 1003760, 'LC', 'Belle Vue', 1, 'belle-vue', 13.80510000, -61.03615000),
(1066023, 1003760, 'LC', 'Bois Dinde', 1, 'bois-dinde', 13.80463000, -61.04952000),
(1066036, 1003760, 'LC', 'Caffiere', 1, 'caffiere', 13.78409000, -61.03554000),
(1066061, 1003760, 'LC', 'Cedars/Chu Tigre', 1, 'cedars-chu-tigre', 13.76995000, -61.04716000),
(1066069, 1003760, 'LC', 'Choiseul', 1, 'choiseul', 13.77273000, -61.04931000),
(1066071, 1003760, 'LC', 'Christian Hill', 1, 'christian-hill', 13.77354000, -61.04694000),
(1066090, 1003760, 'LC', 'Dacretin', 1, 'dacretin', 13.79617000, -61.03574000),
(1066094, 1003760, 'LC', 'Debreuil', 1, 'debreuil', 13.79033000, -61.02585000),
(1066097, 1003760, 'LC', 'Delcer', 1, 'delcer', 13.80121000, -61.05892000),
(1066113, 1003760, 'LC', 'Derriere Morne', 1, 'derriere-morne', 13.80916000, -61.05101000),
(1066125, 1003760, 'LC', 'Dugard', 1, 'dugard', 13.80386000, -61.02831000),
(1066127, 1003760, 'LC', 'Dupre', 1, 'dupre', 13.79435000, -61.02947000),
(1066136, 1003760, 'LC', 'Esperance', 1, 'esperance', 13.80775000, -61.05331000),
(1066155, 1003760, 'LC', 'Franciou', 1, 'franciou', 13.80400000, -61.05448000),
(1066197, 1003760, 'LC', 'Industry', 1, 'industry', 13.79127000, -61.05992000),
(1066213, 1003760, 'LC', 'La Fargue', 1, 'la-fargue', 13.77197000, -61.04124000),
(1066223, 1003760, 'LC', 'La Pointe', 1, 'la-pointe', 13.79443000, -61.06497000),
(1066234, 1003760, 'LC', 'Lamaze', 1, 'lamaze', 13.80649000, -61.01906000),
(1066236, 1003760, 'LC', 'Le Riche', 1, 'le-riche', 13.78365000, -61.04815000),
(1066246, 1003760, 'LC', 'Mailly Motete', 1, 'mailly-motete', 13.81788000, -61.02772000),
(1066259, 1003760, 'LC', 'Martin', 1, 'martin', 13.78941000, -61.04542000),
(1066286, 1003760, 'LC', 'Mongouge', 1, 'mongouge', 13.80301000, -61.04524000),
(1066289, 1003760, 'LC', 'Monzie', 1, 'monzie', 13.80669000, -61.02297000),
(1066299, 1003760, 'LC', 'Morne Jacques', 1, 'morne-jacques', 13.81162000, -61.03165000),
(1066306, 1003760, 'LC', 'Morne Sion', 1, 'morne-sion', 13.79246000, -61.05467000),
(1066309, 1003760, 'LC', 'Motete', 1, 'motete', 13.81325000, -61.02320000),
(1066314, 1003760, 'LC', 'New Field/Fiette', 1, 'new-field-fiette', 13.78815000, -61.05216000),
(1066340, 1003760, 'LC', 'Ponyon', 1, 'ponyon', 13.79639000, -61.04360000),
(1066345, 1003760, 'LC', 'Raveneau', 1, 'raveneau', 13.81018000, -61.04642000),
(1066354, 1003760, 'LC', 'Reunion', 1, 'reunion', 13.77861000, -61.04531000),
(1066358, 1003760, 'LC', 'River Doree', 1, 'river-doree', 13.76769000, -61.03646000),
(1066360, 1003760, 'LC', 'Roblot', 1, 'roblot', 13.80323000, -61.02297000),
(1066374, 1003760, 'LC', 'Sauzay', 1, 'sauzay', 13.77743000, -61.03368000),
(1066376, 1003760, 'LC', 'Savannesgeorge/Constitution', 1, 'savannesgeorge-constitution', 13.77855000, -61.05139000),
(1066418, 1003760, 'LC', 'Victoria', 1, 'victoria', 13.81116000, -61.03963000),
(1066424, 1003760, 'LC', 'Village', 1, 'village', 13.77464000, -61.05020000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003767, 'LC', 'Dauphin Quarter', 1, 'dauphin-quarter');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003756, 'LC', 'Dennery Quarter', 1, 'dennery-quarter');

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 
(1065960, 1003756, 'LC', 'Anse Canot', 1, 'anse-canot', 13.90871000, -60.90440000),
(1065967, 1003756, 'LC', 'Athens', 1, 'athens', 13.90574000, -60.89184000),
(1065968, 1003756, 'LC', 'Au Leon', 1, 'au-leon', 13.95245000, -60.90456000),
(1065982, 1003756, 'LC', 'Bara Bara', 1, 'bara-bara', 13.95911000, -60.93414000),
(1065988, 1003756, 'LC', 'Bazile', 1, 'bazile', 13.91082000, -60.92430000),
(1066005, 1003756, 'LC', 'Belmont', 1, 'belmont', 13.95044000, -60.93276000),
(1066024, 1003756, 'LC', 'Bois Joli', 1, 'bois-joli', 13.92020000, -60.91409000),
(1066029, 1003756, 'LC', 'Bordelais', 1, 'bordelais', 13.89552000, -60.90092000),
(1066030, 1003756, 'LC', 'Bosquet D\'Or', 1, 'bosquet-d-or', 13.92886000, -60.91127000),
(1066096, 1003756, 'LC', 'Delaide', 1, 'delaide', 13.92993000, -60.90584000),
(1066099, 1003756, 'LC', 'Dennery', 1, 'dennery', 13.91409000, -60.89132000),
(1066100, 1003756, 'LC', 'Dennery By Pass', 1, 'dennery-by-pass', 13.91164000, -60.89454000),
(1066101, 1003756, 'LC', 'Dennery By Pass/Green Mountain', 1, 'dennery-by-pass-green-mountain', 13.91094000, -60.89810000),
(1066102, 1003756, 'LC', 'Dennery By Pass/Rocky Lane', 1, 'dennery-by-pass-rocky-lane', 13.91443000, -60.90017000),
(1066103, 1003756, 'LC', 'Dennery By Pass/White Rock Gardens', 1, 'dennery-by-pass-white-rock-gardens', 13.91424000, -60.89333000),
(1066104, 1003756, 'LC', 'Dennery Village', 1, 'dennery-village', 13.91099000, -60.89122000),
(1066108, 1003756, 'LC', 'Derniere Riviere', 1, 'derniere-riviere', 13.95679000, -60.92578000),
(1066109, 1003756, 'LC', 'Derniere Riviere/Fond Maricient', 1, 'derniere-riviere-fond-maricient', 13.95130000, -60.92218000),
(1066110, 1003756, 'LC', 'Derniere Riviere/Mardi Gras/Morne Caca Cochon', 1, 'derniere-riviere-mardi-gras-morne-caca-cochon', 13.96288000, -60.92029000),
(1066111, 1003756, 'LC', 'Derniere Riviere/Morne Panache', 1, 'derniere-riviere-morne-panache', 13.95252000, -60.92919000),
(1066117, 1003756, 'LC', 'Despinoze', 1, 'despinoze', 13.94971000, -60.91182000),
(1066123, 1003756, 'LC', 'Dubonnaire', 1, 'dubonnaire', 13.92808000, -60.92336000),
(1066156, 1003756, 'LC', 'Gadette', 1, 'gadette', 13.95937000, -60.91029000),
(1066170, 1003756, 'LC', 'Grande Ravine', 1, 'grande-ravine', 13.94263000, -60.93404000),
(1066171, 1003756, 'LC', 'Grande Riviere', 1, 'grande-riviere', 13.93306000, -60.93239000),
(1066173, 1003756, 'LC', 'Grande Riviere/Des Branch', 1, 'grande-riviere-des-branch', 13.93383000, -60.93499000),
(1066174, 1003756, 'LC', 'Grande Riviere/En Leur Morne/Discompere', 1, 'grande-riviere-en-leur-morne-discompere', 13.93223000, -60.93461000),
(1066175, 1003756, 'LC', 'Grande Riviere/Funier', 1, 'grande-riviere-funier', 13.93240000, -60.93305000),
(1066177, 1003756, 'LC', 'Grande Riviere/Morne Caca Cochon', 1, 'grande-riviere-morne-caca-cochon', 13.92960000, -60.93794000),
(1066208, 1003756, 'LC', 'La Caye', 1, 'la-caye', 13.93290000, -60.90434000),
(1066220, 1003756, 'LC', 'La Pelle', 1, 'la-pelle', 13.94096000, -60.90569000),
(1066224, 1003756, 'LC', 'La Pointe', 1, 'la-pointe', 13.91525000, -60.88830000),
(1066226, 1003756, 'LC', 'La Ressource', 1, 'la-ressource', 13.94293000, -60.91585000),
(1066242, 1003756, 'LC', 'Lumiere', 1, 'lumiere', 13.93928000, -60.88889000),
(1066303, 1003756, 'LC', 'Morne Panache', 1, 'morne-panache', 13.92167000, -60.93654000),
(1066355, 1003756, 'LC', 'Riche Fond', 1, 'riche-fond', 13.93644000, -60.92026000),
(1066356, 1003756, 'LC', 'Riche Fond/La Belle Vie', 1, 'riche-fond-la-belle-vie', 13.93782000, -60.92908000),
(1066357, 1003756, 'LC', 'Riche Fond/New Village', 1, 'riche-fond-new-village', 13.93648000, -60.92394000),
(1066384, 1003756, 'LC', 'St. Joseph Estate', 1, 'st-joseph-estate', 13.90066000, -60.91444000),
(1066395, 1003756, 'LC', 'Thamazo', 1, 'thamazo', 13.93245000, -60.94786000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003766, 'LC', 'Gros Islet Quarter', 1, 'gros-islet-quarter');

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 
(1065993, 1003766, 'LC', 'Beausejour', 1, 'beausejour', 14.07647000, -60.93780000),
(1065994, 1003766, 'LC', 'Beausejour/Fostin\'S Development', 1, 'beausejour-fostin-s-development', 14.07445000, -60.92929000),
(1065995, 1003766, 'LC', 'Beausejour/Ndc', 1, 'beausejour-ndc', 14.07733000, -60.92683000),
(1065997, 1003766, 'LC', 'Bella Rosa', 1, 'bella-rosa', 14.07711000, -60.94568000),
(1066001, 1003766, 'LC', 'Belle Vue', 1, 'belle-vue', 14.08470000, -60.94342000),
(1066003, 1003766, 'LC', 'Belle Vue Estate', 1, 'belle-vue-estate', 14.08840000, -60.94613000),
(1066016, 1003766, 'LC', 'Boguis', 1, 'boguis', 14.01548000, -60.92089000),
(1066017, 1003766, 'LC', 'Boguis/Desa Blond', 1, 'boguis-desa-blond', 14.01057000, -60.92565000),
(1066021, 1003766, 'LC', 'Bois D\'Orange', 1, 'bois-d-orange', 14.05803000, -60.95992000),
(1066022, 1003766, 'LC', 'Bois D\'Ornange/Trouya', 1, 'bois-d-ornange-trouya', 14.06198000, -60.96914000),
(1066027, 1003766, 'LC', 'Bonneterre', 1, 'bonneterre', 14.06994000, -60.94146000),
(1066028, 1003766, 'LC', 'Bonneterre Gardens', 1, 'bonneterre-gardens', 14.06737000, -60.93393000),
(1066043, 1003766, 'LC', 'Cap Estate', 1, 'cap-estate', 14.09410000, -60.93592000),
(1066044, 1003766, 'LC', 'Cap Estate/Becune Point', 1, 'cap-estate-becune-point', 14.09270000, -60.95161000),
(1066045, 1003766, 'LC', 'Cap Estate/Caribbean Park', 1, 'cap-estate-caribbean-park', 14.10019000, -60.92446000),
(1066046, 1003766, 'LC', 'Cap Estate/Golf Park', 1, 'cap-estate-golf-park', 14.09998000, -60.93705000),
(1066047, 1003766, 'LC', 'Cap Estate/Lower Saline Point', 1, 'cap-estate-lower-saline-point', 14.10515000, -60.94310000),
(1066048, 1003766, 'LC', 'Cap Estate/Mon Du Cap', 1, 'cap-estate-mon-du-cap', 14.10554000, -60.93758000),
(1066049, 1003766, 'LC', 'Cap Estate/Ranch Site', 1, 'cap-estate-ranch-site', 14.10437000, -60.93360000),
(1066050, 1003766, 'LC', 'Cap Estate/Saddlec Back', 1, 'cap-estate-saddlec-back', 14.10023000, -60.94246000),
(1066051, 1003766, 'LC', 'Cap Estate/Upper Saline Point', 1, 'cap-estate-upper-saline-point', 14.10740000, -60.94487000),
(1066055, 1003766, 'LC', 'Cas En Bas', 1, 'cas-en-bas', 14.08328000, -60.93209000),
(1066058, 1003766, 'LC', 'Caye Manje\'', 1, 'caye-manje', 14.06629000, -60.93560000),
(1066082, 1003766, 'LC', 'Corinth', 1, 'corinth', 14.04710000, -60.96046000),
(1066083, 1003766, 'LC', 'Corinth Estate', 1, 'corinth-estate', 14.04336000, -60.95388000),
(1066084, 1003766, 'LC', 'Corinth/La Bel Lair', 1, 'corinth-la-bel-lair', 14.04469000, -60.94484000),
(1066092, 1003766, 'LC', 'Dauphin', 1, 'dauphin', 14.05647000, -60.90188000),
(1066114, 1003766, 'LC', 'Des Barras', 1, 'des-barras', 13.99949000, -60.90166000),
(1066115, 1003766, 'LC', 'Des Barras/Cacolie', 1, 'des-barras-cacolie', 14.01687000, -60.90097000),
(1066118, 1003766, 'LC', 'Desrameaux', 1, 'desrameaux', 14.03681000, -60.92697000),
(1066157, 1003766, 'LC', 'Garrand', 1, 'garrand', 14.00424000, -60.93270000),
(1066169, 1003766, 'LC', 'Grand Riviere', 1, 'grand-riviere', 14.03546000, -60.95152000),
(1066172, 1003766, 'LC', 'Grande Riviere/Assou Canal', 1, 'grande-riviere-assou-canal', 14.03975000, -60.95121000),
(1066176, 1003766, 'LC', 'Grande Riviere/Ingle Woods', 1, 'grande-riviere-ingle-woods', 14.03091000, -60.95592000),
(1066178, 1003766, 'LC', 'Grande Riviere/Morne Serpent', 1, 'grande-riviere-morne-serpent', 14.03509000, -60.96060000),
(1066179, 1003766, 'LC', 'Grande Riviere/Norbert', 1, 'grande-riviere-norbert', 14.04317000, -60.94933000),
(1066180, 1003766, 'LC', 'Grande Riviere/Piat', 1, 'grande-riviere-piat', 14.03926000, -60.94361000),
(1066181, 1003766, 'LC', 'Grande Riviere/White Rock', 1, 'grande-riviere-white-rock', 14.03618000, -60.95556000),
(1066184, 1003766, 'LC', 'Gros Islet', 1, 'gros-islet', 14.06667000, -60.95000000),
(1066185, 1003766, 'LC', 'Gros Islet Town', 1, 'gros-islet-town', 14.08080000, -60.95312000),
(1066186, 1003766, 'LC', 'Gros Islet/Edge Water', 1, 'gros-islet-edge-water', 14.07912000, -60.94973000),
(1066206, 1003766, 'LC', 'L\'Hermitage', 1, 'l-hermitage', 14.06521000, -60.93967000),
(1066211, 1003766, 'LC', 'La Croix Chabourgh', 1, 'la-croix-chabourgh', 14.01147000, -60.94025000),
(1066214, 1003766, 'LC', 'La Guerre', 1, 'la-guerre', 14.02191000, -60.92491000),
(1066215, 1003766, 'LC', 'La Guerre/Chicken Back Street', 1, 'la-guerre-chicken-back-street', 14.02387000, -60.93108000),
(1066253, 1003766, 'LC', 'Marisule', 1, 'marisule', 14.04621000, -60.97063000),
(1066254, 1003766, 'LC', 'Marisule/Bon Air', 1, 'marisule-bon-air', 14.05062000, -60.97124000),
(1066255, 1003766, 'LC', 'Marisule/East Winds', 1, 'marisule-east-winds', 14.05407000, -60.96849000),
(1066256, 1003766, 'LC', 'Marisule/La Brellotte', 1, 'marisule-la-brellotte', 14.05710000, -60.97183000),
(1066257, 1003766, 'LC', 'Marisule/Top Of The World', 1, 'marisule-top-of-the-world', 14.04385000, -60.96885000),
(1066258, 1003766, 'LC', 'Marquis Estate', 1, 'marquis-estate', 14.02960000, -60.90732000),
(1066261, 1003766, 'LC', 'Massade', 1, 'massade', 14.08292000, -60.94946000),
(1066269, 1003766, 'LC', 'Monchy', 1, 'monchy', 14.05502000, -60.92623000),
(1066270, 1003766, 'LC', 'Monchy/Careffe', 1, 'monchy-careffe', 14.05930000, -60.95069000),
(1066271, 1003766, 'LC', 'Monchy/Cletus Village', 1, 'monchy-cletus-village', 14.05137000, -60.92380000),
(1066272, 1003766, 'LC', 'Monchy/La Borne', 1, 'monchy-la-borne', 14.04628000, -60.91961000),
(1066273, 1003766, 'LC', 'Monchy/La Borne/Sans Souci', 1, 'monchy-la-borne-sans-souci', 14.04504000, -60.89961000),
(1066274, 1003766, 'LC', 'Monchy/La Retraite', 1, 'monchy-la-retraite', 14.06421000, -60.94564000),
(1066275, 1003766, 'LC', 'Monchy/Lafeuillee', 1, 'monchy-lafeuillee', 14.05950000, -60.94086000),
(1066276, 1003766, 'LC', 'Monchy/Lawi Fwen', 1, 'monchy-lawi-fwen', 14.05802000, -60.92906000),
(1066277, 1003766, 'LC', 'Monchy/Malgretoute', 1, 'monchy-malgretoute', 14.04108000, -60.91912000),
(1066278, 1003766, 'LC', 'Monchy/Moulin A Vent', 1, 'monchy-moulin-a-vent', 14.06283000, -60.95025000),
(1066279, 1003766, 'LC', 'Monchy/Ravine Macock', 1, 'monchy-ravine-macock', 14.04789000, -60.92511000),
(1066280, 1003766, 'LC', 'Monchy/Riviere Mitan', 1, 'monchy-riviere-mitan', 14.04987000, -60.94029000),
(1066281, 1003766, 'LC', 'Monchy/Ti Dauphin', 1, 'monchy-ti-dauphin', 14.04081000, -60.93225000),
(1066282, 1003766, 'LC', 'Monchy/Vieux Sucreic', 1, 'monchy-vieux-sucreic', 14.04996000, -60.94992000),
(1066283, 1003766, 'LC', 'Monchy/Vieux Sucreic/Bois D\'Inde', 1, 'monchy-vieux-sucreic-bois-d-inde', 14.05613000, -60.95151000),
(1066284, 1003766, 'LC', 'Monchy/Vieux Sucreic/Careffe', 1, 'monchy-vieux-sucreic-careffe', 14.05652000, -60.94948000),
(1066285, 1003766, 'LC', 'Mongiraud', 1, 'mongiraud', 14.06287000, -60.95722000),
(1066287, 1003766, 'LC', 'Monier', 1, 'monier', 14.02951000, -60.94098000),
(1066295, 1003766, 'LC', 'Morne Citon', 1, 'morne-citon', 14.03004000, -60.92813000),
(1066320, 1003766, 'LC', 'Paix Bouche', 1, 'paix-bouche', 14.01755000, -60.93852000),
(1066333, 1003766, 'LC', 'Pigeon Island', 1, 'pigeon-island', 14.08965000, -60.95724000),
(1066336, 1003766, 'LC', 'Plateau', 1, 'plateau', 14.02612000, -60.93474000),
(1066350, 1003766, 'LC', 'Reduit', 1, 'reduit', 14.06829000, -60.96145000),
(1066351, 1003766, 'LC', 'Reduit Orchard', 1, 'reduit-orchard', 14.06594000, -60.95340000),
(1066352, 1003766, 'LC', 'Reduit Park', 1, 'reduit-park', 14.06622000, -60.95560000),
(1066362, 1003766, 'LC', 'Rodney Bay', 1, 'rodney-bay', 14.07292000, -60.95443000),
(1066363, 1003766, 'LC', 'Rodney Heights', 1, 'rodney-heights', 14.06731000, -60.94906000),
(1066412, 1003766, 'LC', 'Union', 1, 'union', 14.02907000, -60.96480000),
(1066413, 1003766, 'LC', 'Union Terrace', 1, 'union-terrace', 14.02654000, -60.95710000),
(1066415, 1003766, 'LC', 'Union/Ti Morne', 1, 'union-ti-morne', 14.02283000, -60.95272000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003759, 'LC', 'Laborie Quarter', 1, 'laborie-quarter');

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 
(1065959, 1003759, 'LC', 'Annus', 1, 'annus', 13.77449000, -61.00511000),
(1065976, 1003759, 'LC', 'Balca', 1, 'balca', 13.77117000, -61.02389000),
(1065977, 1003759, 'LC', 'Balca/En Leur Ba', 1, 'balca-en-leur-ba', 13.77638000, -61.01931000),
(1065978, 1003759, 'LC', 'Balembouche', 1, 'balembouche', 13.75992000, -61.02840000),
(1065980, 1003759, 'LC', 'Banse', 1, 'banse', 13.79211000, -60.99282000),
(1065981, 1003759, 'LC', 'Banse La Grace', 1, 'banse-la-grace', 13.78150000, -60.99840000),
(1066026, 1003759, 'LC', 'Bongalo', 1, 'bongalo', 13.76666000, -61.02991000),
(1066089, 1003759, 'LC', 'Daban', 1, 'daban', 13.80490000, -61.00435000),
(1066143, 1003759, 'LC', 'Fond Berange', 1, 'fond-berange', 13.78238000, -61.00346000),
(1066158, 1003759, 'LC', 'Gayabois', 1, 'gayabois', 13.78643000, -61.01835000),
(1066159, 1003759, 'LC', 'Gentil', 1, 'gentil', 13.76816000, -60.98877000),
(1066161, 1003759, 'LC', 'Getrine', 1, 'getrine', 13.78192000, -61.00741000),
(1066163, 1003759, 'LC', 'Giraud', 1, 'giraud', 13.79254000, -61.00843000),
(1066188, 1003759, 'LC', 'H\'Erelle', 1, 'h-erelle', 13.75599000, -60.98698000),
(1066203, 1003759, 'LC', 'Kennedy Highway/Laborie Bypass', 1, 'kennedy-highway-laborie-bypass', 13.75380000, -60.99594000),
(1066216, 1003759, 'LC', 'La Haut', 1, 'la-haut', 13.79207000, -61.00014000),
(1066221, 1003759, 'LC', 'La Perle', 1, 'la-perle', 13.76483000, -61.02088000),
(1066233, 1003759, 'LC', 'Laborie', 1, 'laborie', 13.75000000, -60.98333000),
(1066241, 1003759, 'LC', 'Londonderry', 1, 'londonderry', 13.77623000, -61.01362000),
(1066243, 1003759, 'LC', 'Macdomel', 1, 'macdomel', 13.77497000, -60.98508000),
(1066298, 1003759, 'LC', 'Morne Gomier', 1, 'morne-gomier', 13.76552000, -60.99524000),
(1066302, 1003759, 'LC', 'Morne Le Blanc', 1, 'morne-le-blanc', 13.75868000, -60.99913000),
(1066319, 1003759, 'LC', 'Olibo', 1, 'olibo', 13.77628000, -60.99931000),
(1066324, 1003759, 'LC', 'Parc Estate', 1, 'parc-estate', 13.79639000, -61.01613000),
(1066331, 1003759, 'LC', 'Piaye', 1, 'piaye', 13.75628000, -61.02279000),
(1066368, 1003759, 'LC', 'Saltibus', 1, 'saltibus', 13.81211000, -61.00982000),
(1066371, 1003759, 'LC', 'Saphire', 1, 'saphire', 13.75670000, -61.01209000),
(1066393, 1003759, 'LC', 'Tete Morne', 1, 'tete-morne', 13.76160000, -61.03397000),
(1066426, 1003759, 'LC', 'Village', 1, 'village', 13.74927000, -60.99375000),
(1066431, 1003759, 'LC', 'Warwick/Daban', 1, 'warwick-daban', 13.81084000, -61.00047000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003762, 'LC', 'Micoud Quarter', 1, 'micoud-quarter');

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 
(1065964, 1003762, 'LC', 'Anse Ger', 1, 'anse-ger', 13.79567000, -60.91567000),
(1065991, 1003762, 'LC', 'Beauchamp', 1, 'beauchamp', 13.81778000, -60.91528000),
(1066014, 1003762, 'LC', 'Blanchard', 1, 'blanchard', 13.80616000, -60.94630000),
(1066041, 1003762, 'LC', 'Canelles', 1, 'canelles', 13.78515000, -60.91789000),
(1066059, 1003762, 'LC', 'Cazuca', 1, 'cazuca', 13.80002000, -60.90481000),
(1066068, 1003762, 'LC', 'Chique/Blanchard', 1, 'chique-blanchard', 13.80120000, -60.94970000),
(1066079, 1003762, 'LC', 'Coolie Town', 1, 'coolie-town', 13.85429000, -60.91380000),
(1066098, 1003762, 'LC', 'Delomel', 1, 'delomel', 13.80338000, -60.92927000),
(1066116, 1003762, 'LC', 'Des Blanchard', 1, 'des-blanchard', 13.81155000, -60.93423000),
(1066119, 1003762, 'LC', 'Desruisseaux', 1, 'desruisseaux', 13.79640000, -60.93540000),
(1066126, 1003762, 'LC', 'Dugard', 1, 'dugard', 13.81090000, -60.91415000),
(1066134, 1003762, 'LC', 'Escap', 1, 'escap', 13.83031000, -60.89673000),
(1066148, 1003762, 'LC', 'Fond D\'Lor/Dugard', 1, 'fond-d-lor-dugard', 13.81069000, -60.92119000),
(1066150, 1003762, 'LC', 'Fond Estate', 1, 'fond-estate', 13.84243000, -60.91862000),
(1066153, 1003762, 'LC', 'Fond/Desruisseaux', 1, 'fond-desruisseaux', 13.79421000, -60.94128000),
(1066165, 1003762, 'LC', 'Gomier', 1, 'gomier', 13.81485000, -60.95252000),
(1066167, 1003762, 'LC', 'Gouette', 1, 'gouette', 13.80650000, -60.93964000),
(1066192, 1003762, 'LC', 'Honeymoon Beach', 1, 'honeymoon-beach', 13.77746000, -60.90493000),
(1066205, 1003762, 'LC', 'L\'Eau Mineau', 1, 'l-eau-mineau', 13.80672000, -60.92103000),
(1066210, 1003762, 'LC', 'La Courville', 1, 'la-courville', 13.81056000, -60.92766000),
(1066222, 1003762, 'LC', 'La Pointe', 1, 'la-pointe', 13.84593000, -60.89332000),
(1066228, 1003762, 'LC', 'La Tille', 1, 'la-tille', 13.82744000, -60.91716000),
(1066239, 1003762, 'LC', 'Lezy', 1, 'lezy', 13.80372000, -60.93906000),
(1066240, 1003762, 'LC', 'Lombard', 1, 'lombard', 13.85772000, -60.91510000),
(1066245, 1003762, 'LC', 'Mahaut', 1, 'mahaut', 13.84391000, -60.95397000),
(1066247, 1003762, 'LC', 'Malgretoute', 1, 'malgretoute', 13.84199000, -60.90411000),
(1066249, 1003762, 'LC', 'Mamiku', 1, 'mamiku', 13.86744000, -60.90184000),
(1066264, 1003762, 'LC', 'Micoud', 1, 'micoud', 13.81667000, -60.90000000),
(1066268, 1003762, 'LC', 'Mon Repos', 1, 'mon-repos', 13.85865000, -60.89591000),
(1066290, 1003762, 'LC', 'Moreau', 1, 'moreau', 13.82676000, -60.94238000),
(1066308, 1003762, 'LC', 'Morne Vient', 1, 'morne-vient', 13.80646000, -60.95241000),
(1066312, 1003762, 'LC', 'Myette Gardens', 1, 'myette-gardens', 13.81862000, -60.90440000),
(1066315, 1003762, 'LC', 'New Village', 1, 'new-village', 13.82446000, -60.89864000),
(1066321, 1003762, 'LC', 'Paix Bouche', 1, 'paix-bouche', 13.81556000, -60.94073000),
(1066323, 1003762, 'LC', 'Palmiste Estate', 1, 'palmiste-estate', 13.85377000, -60.96007000),
(1066326, 1003762, 'LC', 'Patience', 1, 'patience', 13.85000000, -60.90874000),
(1066334, 1003762, 'LC', 'Planard', 1, 'planard', 13.80521000, -60.91540000),
(1066341, 1003762, 'LC', 'Praslin', 1, 'praslin', 13.87545000, -60.89717000),
(1066344, 1003762, 'LC', 'Rameau', 1, 'rameau', 13.83055000, -60.92375000),
(1066367, 1003762, 'LC', 'Saint Marie Road', 1, 'saint-marie-road', 13.85444000, -60.91803000),
(1066373, 1003762, 'LC', 'Saut', 1, 'saut', 13.81272000, -60.94375000),
(1066375, 1003762, 'LC', 'Savannes', 1, 'savannes', 13.77098000, -60.92017000),
(1066379, 1003762, 'LC', 'St Helen Estate', 1, 'st-helen-estate', 13.78735000, -60.90726000),
(1066401, 1003762, 'LC', 'Ti Riviere', 1, 'ti-riviere', 13.83006000, -60.93774000),
(1066403, 1003762, 'LC', 'Ti Rocher', 1, 'ti-rocher', 13.81734000, -60.92858000),
(1066411, 1003762, 'LC', 'Troumassee', 1, 'troumassee', 13.80892000, -60.90341000),
(1066425, 1003762, 'LC', 'Village', 1, 'village', 13.81904000, -60.89692000),
(1066430, 1003762, 'LC', 'Volet', 1, 'volet', 13.82626000, -60.90789000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003765, 'LC', 'Praslin Quarter', 1, 'praslin-quarter');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003764, 'LC', 'Soufrière Quarter', 1, 'soufriere-quarter');

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 
(1065961, 1003764, 'LC', 'Anse Chastanet', 1, 'anse-chastanet', 13.86426000, -61.07016000),
(1065984, 1003764, 'LC', 'Barons Drive/Coin De L\'Anse', 1, 'barons-drive-coin-de-l-anse', 13.85138000, -61.05939000),
(1065990, 1003764, 'LC', 'Beasejour/Myers Bridge', 1, 'beasejour-myers-bridge', 13.82147000, -61.03396000),
(1065999, 1003764, 'LC', 'Belle Plaine', 1, 'belle-plaine', 13.82700000, -61.03127000),
(1066004, 1003764, 'LC', 'Bellefond', 1, 'bellefond', 13.82753000, -61.04269000),
(1066007, 1003764, 'LC', 'Belvedere', 1, 'belvedere', 13.83440000, -61.01771000),
(1066020, 1003764, 'LC', 'Bois D\'Inde', 1, 'bois-d-inde', 13.83650000, -61.03491000),
(1066031, 1003764, 'LC', 'Bouton', 1, 'bouton', 13.87936000, -61.06449000),
(1066039, 1003764, 'LC', 'Calvary/Calvaire', 1, 'calvary-calvaire', 13.85035000, -61.05620000),
(1066062, 1003764, 'LC', 'Cenac', 1, 'cenac', 13.87207000, -61.04243000),
(1066067, 1003764, 'LC', 'Chateau Belair', 1, 'chateau-belair', 13.81830000, -61.05350000),
(1066076, 1003764, 'LC', 'Colombette', 1, 'colombette', 13.86861000, -61.04990000),
(1066077, 1003764, 'LC', 'Compar', 1, 'compar', 13.83586000, -61.05934000),
(1066086, 1003764, 'LC', 'Cresslands', 1, 'cresslands', 13.85999000, -61.04032000),
(1066120, 1003764, 'LC', 'Deville', 1, 'deville', 13.81372000, -61.05049000),
(1066121, 1003764, 'LC', 'Diamond/Diamond Estate', 1, 'diamond-diamond-estate', 13.85168000, -61.04352000),
(1066137, 1003764, 'LC', 'Esperance', 1, 'esperance', 13.84562000, -61.03713000),
(1066138, 1003764, 'LC', 'Etangs', 1, 'etangs', 13.81902000, -61.04056000),
(1066144, 1003764, 'LC', 'Fond Bernier', 1, 'fond-bernier', 13.85845000, -61.05949000),
(1066145, 1003764, 'LC', 'Fond Cacoa', 1, 'fond-cacoa', 13.85442000, -61.05077000),
(1066149, 1003764, 'LC', 'Fond Doux', 1, 'fond-doux', 13.82096000, -61.04952000),
(1066151, 1003764, 'LC', 'Fond Gens Libre', 1, 'fond-gens-libre', 13.80791000, -61.06259000),
(1066199, 1003764, 'LC', 'Jalousie', 1, 'jalousie', 13.82811000, -61.05891000),
(1066217, 1003764, 'LC', 'La Haut', 1, 'la-haut', 13.86276000, -61.05584000),
(1066219, 1003764, 'LC', 'La Pearle', 1, 'la-pearle', 13.85740000, -61.04760000),
(1066237, 1003764, 'LC', 'Lenny Hill', 1, 'lenny-hill', 13.85059000, -61.05906000),
(1066248, 1003764, 'LC', 'Malgretoute', 1, 'malgretoute', 13.84233000, -61.05998000),
(1066265, 1003764, 'LC', 'Migny', 1, 'migny', 13.84166000, -61.01808000),
(1066267, 1003764, 'LC', 'Mocha', 1, 'mocha', 13.83117000, -61.02503000),
(1066292, 1003764, 'LC', 'Morne Bonin', 1, 'morne-bonin', 13.83174000, -61.03285000),
(1066300, 1003764, 'LC', 'Morne La Croix', 1, 'morne-la-croix', 13.81762000, -61.06146000),
(1066301, 1003764, 'LC', 'Morne Lastic/Desruisseaux', 1, 'morne-lastic-desruisseaux', 13.86628000, -61.05894000),
(1066313, 1003764, 'LC', 'New Development', 1, 'new-development', 13.86176000, -61.04791000),
(1066322, 1003764, 'LC', 'Palmiste', 1, 'palmiste', 13.85843000, -61.05575000),
(1066335, 1003764, 'LC', 'Plat Pays', 1, 'plat-pays', 13.84085000, -61.05571000),
(1066343, 1003764, 'LC', 'Rabot', 1, 'rabot', 13.83380000, -61.04540000),
(1066347, 1003764, 'LC', 'Ravine Claire', 1, 'ravine-claire', 13.85262000, -61.02892000),
(1066366, 1003764, 'LC', 'Ruby Estate', 1, 'ruby-estate', 13.85812000, -61.04983000),
(1066378, 1003764, 'LC', 'Soufrière', 1, 'soufriere', 13.85616000, -61.05660000),
(1066377, 1003764, 'LC', 'Soufriere Estate', 1, 'soufriere-estate', 13.85174000, -61.05420000),
(1066383, 1003764, 'LC', 'St Phillip', 1, 'st-phillip', 13.84432000, -61.02766000),
(1066385, 1003764, 'LC', 'Stonefield', 1, 'stonefield', 13.84513000, -61.05990000),
(1066386, 1003764, 'LC', 'Sulphur Springs', 1, 'sulphur-springs', 13.84002000, -61.04512000),
(1066398, 1003764, 'LC', 'Ti Boug', 1, 'ti-boug', 13.83744000, -61.02460000),
(1066400, 1003764, 'LC', 'Ti Delcer', 1, 'ti-delcer', 13.83386000, -61.06410000),
(1066404, 1003764, 'LC', 'Toraille', 1, 'toraille', 13.85704000, -61.03296000),
(1066405, 1003764, 'LC', 'Town', 1, 'town', 13.85491000, -61.05764000),
(1066414, 1003764, 'LC', 'Union Vale', 1, 'union-vale', 13.81103000, -61.05686000),
(1066436, 1003764, 'LC', 'Zenon', 1, 'zenon', 13.85953000, -61.03394000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1003763, 'LC', 'Vieux Fort Quarter', 1, 'vieux-fort-quarter');

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 
(1065971, 1003763, 'LC', 'Augier', 1, 'augier', 13.76669000, -60.98063000),
(1065989, 1003763, 'LC', 'Beane Field', 1, 'beane-field', 13.73976000, -60.94741000),
(1065992, 1003763, 'LC', 'Beausejour', 1, 'beausejour', 13.75229000, -60.95519000),
(1066002, 1003763, 'LC', 'Belle Vue', 1, 'belle-vue', 13.79218000, -60.95379000),
(1066012, 1003763, 'LC', 'Black Bay', 1, 'black-bay', 13.74330000, -60.98272000),
(1066032, 1003763, 'LC', 'Bruceville/Shanty Town', 1, 'bruceville-shanty-town', 13.72558000, -60.94907000),
(1066034, 1003763, 'LC', 'Cacoa', 1, 'cacoa', 13.77889000, -60.93862000),
(1066042, 1003763, 'LC', 'Cantonement', 1, 'cantonement', 13.75665000, -60.97662000),
(1066054, 1003763, 'LC', 'Carierre', 1, 'carierre', 13.78514000, -60.96721000),
(1066057, 1003763, 'LC', 'Catin', 1, 'catin', 13.77694000, -60.97973000),
(1066075, 1003763, 'LC', 'Cocoa Dan', 1, 'cocoa-dan', 13.73087000, -60.97195000),
(1066081, 1003763, 'LC', 'Coolie Town', 1, 'coolie-town', 13.76911000, -60.96680000),
(1066093, 1003763, 'LC', 'De Mailly', 1, 'de-mailly', 13.79649000, -60.94938000),
(1066105, 1003763, 'LC', 'Derierre Bois', 1, 'derierre-bois', 13.76807000, -60.97725000),
(1066107, 1003763, 'LC', 'Derierre Morne', 1, 'derierre-morne', 13.74126000, -60.96057000),
(1066122, 1003763, 'LC', 'Docamel/La Resource', 1, 'docamel-la-resource', 13.74202000, -60.95604000),
(1066129, 1003763, 'LC', 'Eau Piquant/St Urbain', 1, 'eau-piquant-st-urbain', 13.76025000, -60.94012000),
(1066130, 1003763, 'LC', 'En Bamboo', 1, 'en-bamboo', 13.78155000, -60.94763000),
(1066135, 1003763, 'LC', 'Esperance', 1, 'esperance', 13.78854000, -60.96108000),
(1066147, 1003763, 'LC', 'Fond Capeche', 1, 'fond-capeche', 13.77449000, -60.94835000),
(1066152, 1003763, 'LC', 'Fond Sabot', 1, 'fond-sabot', 13.77659000, -60.95546000),
(1066168, 1003763, 'LC', 'Grace', 1, 'grace', 13.77678000, -60.96637000),
(1066189, 1003763, 'LC', 'Hewanorra Orchard', 1, 'hewanorra-orchard', 13.74486000, -60.97284000),
(1066193, 1003763, 'LC', 'Hope Estate', 1, 'hope-estate', 13.76477000, -60.95831000),
(1066196, 1003763, 'LC', 'Industrial Estate', 1, 'industrial-estate', 13.74096000, -60.97393000),
(1066202, 1003763, 'LC', 'Joyeux', 1, 'joyeux', 13.78313000, -60.96068000),
(1066225, 1003763, 'LC', 'La Resource', 1, 'la-resource', 13.74799000, -60.96237000),
(1066227, 1003763, 'LC', 'La Retraite', 1, 'la-retraite', 13.75944000, -60.96632000),
(1066230, 1003763, 'LC', 'La Tourney/Cedar Heights', 1, 'la-tourney-cedar-heights', 13.74114000, -60.96517000),
(1066244, 1003763, 'LC', 'Maganier', 1, 'maganier', 13.79450000, -60.98513000),
(1066293, 1003763, 'LC', 'Morne Cayenne', 1, 'morne-cayenne', 13.78349000, -60.95506000),
(1066307, 1003763, 'LC', 'Morne Vert', 1, 'morne-vert', 13.77899000, -60.97617000),
(1066310, 1003763, 'LC', 'Moule A Chique', 1, 'moule-a-chique', 13.71458000, -60.94835000),
(1066317, 1003763, 'LC', 'Obrier', 1, 'obrier', 13.76831000, -60.97313000),
(1066332, 1003763, 'LC', 'Pierrot', 1, 'pierrot', 13.76857000, -60.94381000),
(1066337, 1003763, 'LC', 'Plut', 1, 'plut', 13.77417000, -60.96076000),
(1066339, 1003763, 'LC', 'Pomme', 1, 'pomme', 13.75792000, -60.98147000),
(1066380, 1003763, 'LC', 'St Jude\'S Highway', 1, 'st-jude-s-highway', 13.75867000, -60.97360000),
(1066394, 1003763, 'LC', 'Tete Morne/Morne Andrew', 1, 'tete-morne-morne-andrew', 13.77114000, -60.95194000),
(1066406, 1003763, 'LC', 'Town', 1, 'town', 13.72835000, -60.95408000),
(1066420, 1003763, 'LC', 'Vieux Fort', 1, 'vieux-fort', 13.71667000, -60.95000000),
(1066421, 1003763, 'LC', 'Vieux Fort/Laborie Highway', 1, 'vieux-fort-laborie-highway', 13.73197000, -60.95477000),
(1066422, 1003763, 'LC', 'Vige\'', 1, 'vige', 13.78692000, -60.93550000),
(1066433, 1003763, 'LC', 'Westall Group/The Mangue', 1, 'westall-group-the-mangue', 13.72707000, -60.95312000);

