REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('CO', 'Colombia', 'colombia', '57', 'Colombia', 'COP');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002895, 'CO', 'Amazonas Department', 1, 'amazonas-department');

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 
(1020807, 1002895, 'CO', 'El Encanto', 1, 'el-encanto', -1.56261000, -73.25684000),
(1020977, 1002895, 'CO', 'La Chorrera', 1, 'la-chorrera', -1.48894000, -72.72935000),
(1020998, 1002895, 'CO', 'La Pedrera', 1, 'la-pedrera', -1.65596000, -70.22186000),
(1021014, 1002895, 'CO', 'La Victoria', 1, 'la-victoria', -0.18311000, -71.03760000),
(1021027, 1002895, 'CO', 'Leticia', 1, 'leticia', -4.21528000, -69.94056000),
(1021086, 1002895, 'CO', 'Miriti - Paraná', 1, 'miriti-parana', -0.81858000, -70.78925000),
(1021231, 1002895, 'CO', 'Puerto Alegría', 1, 'puerto-alegria', -0.96886000, -73.74962000),
(1021232, 1002895, 'CO', 'Puerto Arica', 1, 'puerto-arica', -1.90677000, -71.14653000),
(1021249, 1002895, 'CO', 'Puerto Nariño', 1, 'puerto-narino', -3.78889000, -70.35584000),
(1021256, 1002895, 'CO', 'Puerto Santander', 1, 'puerto-santander', -1.09870000, -71.93911000),
(1021512, 1002895, 'CO', 'Tarapacá', 1, 'tarapaca', -2.88544000, -69.77692000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002890, 'CO', 'Antioquia Department', 1, 'antioquia-department');

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 
(1020485, 1002890, 'CO', 'Abejorral', 1, 'abejorral', 5.78928000, -75.42725000),
(1020487, 1002890, 'CO', 'Abriaquí', 1, 'abriaqui', 6.63148000, -76.06444000),
(1020504, 1002890, 'CO', 'Alejandría', 1, 'alejandria', 6.36667000, -75.08333000),
(1020512, 1002890, 'CO', 'Amagá', 1, 'amaga', 6.04001000, -75.70315000),
(1020513, 1002890, 'CO', 'Amalfi', 1, 'amalfi', 6.91016000, -75.07764000),
(1020520, 1002890, 'CO', 'Andes', 1, 'andes', 5.66974000, -75.89905000),
(1020521, 1002890, 'CO', 'Angelópolis', 1, 'angelopolis', 6.12228000, -75.71432000),
(1020522, 1002890, 'CO', 'Angostura', 1, 'angostura', 6.87120000, -75.35947000),
(1020527, 1002890, 'CO', 'Anza', 1, 'anza', 6.33333000, -75.91667000),
(1020529, 1002890, 'CO', 'Apartadó', 1, 'apartado', 7.88299000, -76.62587000),
(1020541, 1002890, 'CO', 'Arboletes', 1, 'arboletes', 8.85051000, -76.42694000),
(1020544, 1002890, 'CO', 'Argelia', 1, 'argelia', 5.73127000, -75.14257000),
(1020551, 1002890, 'CO', 'Armenia', 1, 'armenia', 6.17554000, -75.81230000),
(1020566, 1002890, 'CO', 'Barbosa', 1, 'barbosa', 6.43809000, -75.33136000),
(1020579, 1002890, 'CO', 'Bello', 1, 'bello', 6.36160000, -75.58728000),
(1020580, 1002890, 'CO', 'Belmira', 1, 'belmira', 6.60508000, -75.66619000),
(1020588, 1002890, 'CO', 'Betania', 1, 'betania', 5.73571000, -75.98964000),
(1020589, 1002890, 'CO', 'Betulia', 1, 'betulia', 6.11284000, -75.98378000),
(1020602, 1002890, 'CO', 'Briceño', 1, 'briceno', 7.05001000, -75.50903000),
(1020613, 1002890, 'CO', 'Buriticá', 1, 'buritica', 6.80549000, -75.92093000),
(1020763, 1002890, 'CO', 'Cáceres', 1, 'caceres', 7.68252000, -75.22481000),
(1020621, 1002890, 'CO', 'Caicedo', 1, 'caicedo', 6.42805000, -75.99715000),
(1020631, 1002890, 'CO', 'Caldas', 1, 'caldas', 6.09106000, -75.63569000),
(1020638, 1002890, 'CO', 'Campamento', 1, 'campamento', 7.03910000, -75.28938000),
(1020667, 1002890, 'CO', 'Cañasgordas', 1, 'canasgordas', 6.80951000, -76.03954000),
(1020649, 1002890, 'CO', 'Caracolí', 1, 'caracoli', 6.40920000, -74.75715000),
(1020650, 1002890, 'CO', 'Caramanta', 1, 'caramanta', 5.54144000, -75.66961000),
(1020652, 1002890, 'CO', 'Carepa', 1, 'carepa', 7.75849000, -76.65255000),
(1020656, 1002890, 'CO', 'Carmen de Viboral', 1, 'carmen-de-viboral', 6.08236000, -75.33509000),
(1020658, 1002890, 'CO', 'Carolina', 1, 'carolina', 6.74807000, -75.32131000),
(1020666, 1002890, 'CO', 'Caucasia', 1, 'caucasia', 7.98654000, -75.19349000),
(1020683, 1002890, 'CO', 'Chigorodó', 1, 'chigorodo', 7.66638000, -76.68106000),
(1020710, 1002890, 'CO', 'Cisneros', 1, 'cisneros', 6.54507000, -75.09415000),
(1020711, 1002890, 'CO', 'Ciudad Bolívar', 1, 'ciudad-bolivar', 5.85389000, -76.02528000),
(1020716, 1002890, 'CO', 'Cocorná', 1, 'cocorna', 6.00579000, -75.16984000),
(1020724, 1002890, 'CO', 'Concepción', 1, 'concepcion', 6.39408000, -75.25830000),
(1020727, 1002890, 'CO', 'Concordia', 1, 'concordia', 6.04639000, -75.90705000),
(1020735, 1002890, 'CO', 'Copacabana', 1, 'copacabana', 6.36230000, -75.49922000),
(1020747, 1002890, 'CO', 'Cruces de Anorí', 1, 'cruces-de-anori', 7.18333000, -75.06667000),
(1020773, 1002890, 'CO', 'Dabeiba', 1, 'dabeiba', 7.03367000, -76.34161000),
(1020780, 1002890, 'CO', 'Don Matías', 1, 'don-matias', 6.50559000, -75.36645000),
(1020781, 1002890, 'CO', 'Donmatías', 1, 'donmatias', 6.48569000, -75.39496000),
(1020785, 1002890, 'CO', 'Ebéjico', 1, 'ebejico', 6.32598000, -75.76835000),
(1020786, 1002890, 'CO', 'El Bagre', 1, 'el-bagre', 7.60347000, -74.80951000),
(1020798, 1002890, 'CO', 'El Carmen de Viboral', 1, 'el-carmen-de-viboral', 5.97810000, -75.26322000),
(1020828, 1002890, 'CO', 'El Santuario', 1, 'el-santuario', 6.13568000, -75.25705000),
(1020838, 1002890, 'CO', 'Entrerrios', 1, 'entrerrios', 6.58333000, -75.58333000),
(1020839, 1002890, 'CO', 'Entrerríos', 1, 'entrerrios', 6.56540000, -75.51690000),
(1020840, 1002890, 'CO', 'Envigado', 1, 'envigado', 6.17591000, -75.59174000),
(1020859, 1002890, 'CO', 'Fredonia', 1, 'fredonia', 5.89239000, -75.68546000),
(1020861, 1002890, 'CO', 'Frontino', 1, 'frontino', 6.77133000, -76.13324000),
(1020885, 1002890, 'CO', 'Giraldo', 1, 'giraldo', 6.66667000, -75.95346000),
(1020888, 1002890, 'CO', 'Girardota', 1, 'girardota', 6.36789000, -75.46231000),
(1020931, 1002890, 'CO', 'Gómez Plata', 1, 'gomez-plata', 6.68178000, -75.21907000),
(1020893, 1002890, 'CO', 'Granada', 1, 'granada', 6.14353000, -75.18532000),
(1020901, 1002890, 'CO', 'Guadalupe', 1, 'guadalupe', 6.81449000, -75.24063000),
(1020913, 1002890, 'CO', 'Guarne', 1, 'guarne', 6.28345000, -75.44363000),
(1020915, 1002890, 'CO', 'Guatapé', 1, 'guatape', 6.25548000, -75.16432000),
(1020939, 1002890, 'CO', 'Heliconia', 1, 'heliconia', 6.20831000, -75.73565000),
(1020942, 1002890, 'CO', 'Hispania', 1, 'hispania', 5.79925000, -75.90718000),
(1020953, 1002890, 'CO', 'Itagui', 1, 'itagui', 6.17874000, -75.63117000),
(1020954, 1002890, 'CO', 'Itagüí', 1, 'itagui', 6.18461000, -75.59913000),
(1020955, 1002890, 'CO', 'Ituango', 1, 'ituango', 7.17117000, -75.76404000),
(1020959, 1002890, 'CO', 'Jardín', 1, 'jardin', 5.59038000, -75.81846000),
(1020961, 1002890, 'CO', 'Jericó', 1, 'jerico', 5.79211000, -75.78601000),
(1020974, 1002890, 'CO', 'La Ceja', 1, 'la-ceja', 6.00000000, -75.43311000),
(1020983, 1002890, 'CO', 'La Estrella', 1, 'la-estrella', 6.14239000, -75.65257000),
(1021000, 1002890, 'CO', 'La Pintada', 1, 'la-pintada', 5.74867000, -75.60626000),
(1021009, 1002890, 'CO', 'La Unión', 1, 'la-union', 5.94642000, -75.35917000),
(1021028, 1002890, 'CO', 'Liborina', 1, 'liborina', 6.67790000, -75.81218000),
(1021044, 1002890, 'CO', 'Maceo', 1, 'maceo', 6.55196000, -74.78741000),
(1021066, 1002890, 'CO', 'Marinilla', 1, 'marinilla', 6.19609000, -75.30313000),
(1021074, 1002890, 'CO', 'Medellín', 1, 'medellin', 6.25184000, -75.56359000),
(1021097, 1002890, 'CO', 'Montebello', 1, 'montebello', 5.93703000, -75.52741000),
(1021117, 1002890, 'CO', 'Municipio de San Pedro de los Milagros', 1, 'municipio-de-san-pedro-de-los-milagros', 6.46538000, -75.56452000),
(1021120, 1002890, 'CO', 'Murindó', 1, 'murindo', 6.84698000, -76.71544000),
(1021121, 1002890, 'CO', 'Mutatá', 1, 'mutata', 7.24407000, -76.43564000),
(1021126, 1002890, 'CO', 'Nariño', 1, 'narino', 5.60893000, -75.17656000),
(1021129, 1002890, 'CO', 'Nechí', 1, 'nechi', 8.09419000, -74.77573000),
(1021130, 1002890, 'CO', 'Necoclí', 1, 'necocli', 8.42627000, -76.78926000),
(1021149, 1002890, 'CO', 'Olaya', 1, 'olaya', 6.62773000, -75.81270000),
(1021197, 1002890, 'CO', 'Peñol', 1, 'penol', 6.23434000, -75.22573000),
(1021194, 1002890, 'CO', 'Peque', 1, 'peque', 7.02123000, -75.90926000),
(1021227, 1002890, 'CO', 'Pueblorrico', 1, 'pueblorrico', 5.80000000, -75.85000000),
(1021234, 1002890, 'CO', 'Puerto Berrío', 1, 'puerto-berrio', 6.50749000, -74.52271000),
(1021248, 1002890, 'CO', 'Puerto Nare', 1, 'puerto-nare', 6.19167000, -74.58670000),
(1021258, 1002890, 'CO', 'Puerto Triunfo', 1, 'puerto-triunfo', 5.87259000, -74.64050000),
(1021281, 1002890, 'CO', 'Remedios', 1, 'remedios', 7.02835000, -74.69379000),
(1021286, 1002890, 'CO', 'Retiro', 1, 'retiro', 6.05906000, -75.51488000),
(1021293, 1002890, 'CO', 'Rionegro', 1, 'rionegro', 6.16667000, -75.41667000),
(1021311, 1002890, 'CO', 'Sabanalarga', 1, 'sabanalarga', 6.84893000, -75.81711000),
(1021314, 1002890, 'CO', 'Sabaneta', 1, 'sabaneta', 6.15153000, -75.61657000),
(1021323, 1002890, 'CO', 'Salgar', 1, 'salgar', 5.96711000, -75.98747000),
(1021330, 1002890, 'CO', 'San Andrés', 1, 'san-andres', 6.90333000, -75.68250000),
(1021334, 1002890, 'CO', 'San Andrés de Cuerquía', 1, 'san-andres-de-cuerquia', 6.91667000, -75.66667000),
(1021345, 1002890, 'CO', 'San Carlos', 1, 'san-carlos', 7.79177000, -74.77316000),
(1021357, 1002890, 'CO', 'San Francisco', 1, 'san-francisco', 6.11667000, -75.98333000),
(1021362, 1002890, 'CO', 'San Jerónimo', 1, 'san-jeronimo', 6.44139000, -75.70783000),
(1021366, 1002890, 'CO', 'San José de la Montaña', 1, 'san-jose-de-la-montana', 6.82205000, -75.69757000),
(1021376, 1002890, 'CO', 'San Juan de Urabá', 1, 'san-juan-de-uraba', 8.75924000, -76.52969000),
(1021396, 1002890, 'CO', 'San Pedro', 1, 'san-pedro', 6.46135000, -75.55778000),
(1021399, 1002890, 'CO', 'San Pedro de Uraba', 1, 'san-pedro-de-uraba', 8.42291000, -76.31747000),
(1021400, 1002890, 'CO', 'San Pedro de Urabá', 1, 'san-pedro-de-uraba', 8.27515000, -76.37641000),
(1021402, 1002890, 'CO', 'San Rafael', 1, 'san-rafael', 6.31234000, -75.02426000),
(1021403, 1002890, 'CO', 'San Roque', 1, 'san-roque', 6.48511000, -75.01960000),
(1021406, 1002890, 'CO', 'San Vicente', 1, 'san-vicente', 6.28535000, -75.33385000),
(1021407, 1002890, 'CO', 'San Vicente Ferrer', 1, 'san-vicente-ferrer', 6.32237000, -75.33020000),
(1021414, 1002890, 'CO', 'Santa Bárbara', 1, 'santa-barbara', 5.88937000, -75.58255000),
(1021417, 1002890, 'CO', 'Santa Fe de Antioquia', 1, 'santa-fe-de-antioquia', 6.55687000, -75.82806000),
(1021425, 1002890, 'CO', 'Santa Rosa de Osos', 1, 'santa-rosa-de-osos', 6.64738000, -75.46031000),
(1021432, 1002890, 'CO', 'Santafé de Antioquia', 1, 'santafe-de-antioquia', 6.55000000, -75.90000000),
(1021439, 1002890, 'CO', 'Santo Domingo', 1, 'santo-domingo', 6.47282000, -75.16547000),
(1021441, 1002890, 'CO', 'Santuario', 1, 'santuario', 6.13833000, -75.26417000),
(1021449, 1002890, 'CO', 'Segovia', 1, 'segovia', 7.28132000, -74.64273000),
(1021474, 1002890, 'CO', 'Sonson', 1, 'sonson', 5.75000000, -75.00000000),
(1021475, 1002890, 'CO', 'Sonsón', 1, 'sonson', 5.71062000, -75.31069000),
(1021476, 1002890, 'CO', 'Sopetrán', 1, 'sopetran', 6.52271000, -75.74608000),
(1021562, 1002890, 'CO', 'Támesis', 1, 'tamesis', 5.66462000, -75.71339000),
(1021513, 1002890, 'CO', 'Tarazá', 1, 'taraza', 7.58358000, -75.40068000),
(1021514, 1002890, 'CO', 'Tarso', 1, 'tarso', 5.86467000, -75.82192000),
(1021532, 1002890, 'CO', 'Titiribí', 1, 'titiribi', 6.06276000, -75.79370000),
(1021537, 1002890, 'CO', 'Toledo', 1, 'toledo', 7.01306000, -75.69528000),
(1021557, 1002890, 'CO', 'Turbo', 1, 'turbo', 8.09263000, -76.72822000),
(1021572, 1002890, 'CO', 'Uramita', 1, 'uramita', 6.89944000, -76.17417000),
(1021574, 1002890, 'CO', 'Urrao', 1, 'urrao', 6.31696000, -76.13420000),
(1021577, 1002890, 'CO', 'Valdivia', 1, 'valdivia', 7.29382000, -75.39190000),
(1021584, 1002890, 'CO', 'Valparaíso', 1, 'valparaiso', 5.61500000, -75.62422000),
(1021585, 1002890, 'CO', 'Vegachí', 1, 'vegachi', 6.76141000, -74.79473000),
(1021588, 1002890, 'CO', 'Venecia', 1, 'venecia', 5.95417000, -75.79904000),
(1021595, 1002890, 'CO', 'Vigía del Fuerte', 1, 'vigia-del-fuerte', 6.58933000, -76.89599000),
(1021621, 1002890, 'CO', 'Yalí', 1, 'yali', 6.70257000, -74.79018000),
(1021622, 1002890, 'CO', 'Yarumal', 1, 'yarumal', 6.98532000, -75.45402000),
(1021624, 1002890, 'CO', 'Yolombó', 1, 'yolombo', 6.66569000, -74.99120000),
(1021625, 1002890, 'CO', 'Yondó', 1, 'yondo', 6.90738000, -74.17686000),
(1021632, 1002890, 'CO', 'Zaragoza', 1, 'zaragoza', 7.48971000, -74.86919000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002881, 'CO', 'Arauca Department', 1, 'arauca-department');

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 
(1020536, 1002881, 'CO', 'Arauca', 1, 'arauca', 7.08471000, -70.75908000),
(1020537, 1002881, 'CO', 'Arauquita', 1, 'arauquita', 7.02917000, -71.42806000),
(1020746, 1002881, 'CO', 'Cravo Norte', 1, 'cravo-norte', 6.30173000, -70.20415000),
(1020856, 1002881, 'CO', 'Fortul', 1, 'fortul', 6.74611000, -71.85667000),
(1021253, 1002881, 'CO', 'Puerto Rondón', 1, 'puerto-rondon', 6.28048000, -71.10000000),
(1021444, 1002881, 'CO', 'Saravena', 1, 'saravena', 6.96319000, -71.88230000),
(1021508, 1002881, 'CO', 'Tame', 1, 'tame', 6.46065000, -71.73618000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002900, 'CO', 'Archipelago of Saint Andréws, Providence and Saint Catalina', 1, 'archipelago-of-saint-andrews-providence-and-saint-catalina');

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 
(1021111, 1002900, 'CO', 'Mountain', 1, 'mountain', 13.36667000, -81.36667000),
(1021224, 1002900, 'CO', 'Providencia', 1, 'providencia', 13.38479000, -81.37468000),
(1021331, 1002900, 'CO', 'San Andrés', 1, 'san-andres', 12.58317000, -81.70636000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002880, 'CO', 'Atlántico Department', 1, 'atlantico-department');

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 
(1020564, 1002880, 'CO', 'Baranoa', 1, 'baranoa', 10.79497000, -74.92073000),
(1020574, 1002880, 'CO', 'Barranquilla', 1, 'barranquilla', 10.96854000, -74.78132000),
(1020640, 1002880, 'CO', 'Campo de la Cruz', 1, 'campo-de-la-cruz', 10.37844000, -74.90258000),
(1020643, 1002880, 'CO', 'Candelaria', 1, 'candelaria', 10.47387000, -74.88581000),
(1020876, 1002880, 'CO', 'Galapa', 1, 'galapa', 10.89790000, -74.88700000),
(1020966, 1002880, 'CO', 'Juan de Acosta', 1, 'juan-de-acosta', 10.82930000, -75.03346000),
(1021038, 1002880, 'CO', 'Luruaco', 1, 'luruaco', 10.61712000, -75.15146000),
(1021053, 1002880, 'CO', 'Malambo', 1, 'malambo', 10.85953000, -74.77386000),
(1021055, 1002880, 'CO', 'Manatí', 1, 'manati', 10.46402000, -74.98220000),
(1021171, 1002880, 'CO', 'Palmar de Varela', 1, 'palmar-de-varela', 10.74055000, -74.75443000),
(1021208, 1002880, 'CO', 'Piojó', 1, 'piojo', 10.74846000, -75.10776000),
(1021217, 1002880, 'CO', 'Polonuevo', 1, 'polonuevo', 10.77697000, -74.85344000),
(1021218, 1002880, 'CO', 'Ponedera', 1, 'ponedera', 10.64297000, -74.75393000),
(1021238, 1002880, 'CO', 'Puerto Colombia', 1, 'puerto-colombia', 11.00854000, -74.90887000),
(1021283, 1002880, 'CO', 'Repelón', 1, 'repelon', 10.50937000, -75.12830000),
(1021309, 1002880, 'CO', 'Sabanagrande', 1, 'sabanagrande', 10.80077000, -74.77051000),
(1021312, 1002880, 'CO', 'Sabanalarga', 1, 'sabanalarga', 10.61636000, -74.95717000),
(1021420, 1002880, 'CO', 'Santa Lucía', 1, 'santa-lucia', 10.32420000, -74.96017000),
(1021440, 1002880, 'CO', 'Santo Tomás', 1, 'santo-tomas', 10.75773000, -74.75451000),
(1021472, 1002880, 'CO', 'Soledad', 1, 'soledad', 10.89986000, -74.78787000),
(1021485, 1002880, 'CO', 'Suan', 1, 'suan', 10.30214000, -74.91934000),
(1021550, 1002880, 'CO', 'Tubará', 1, 'tubara', 10.87562000, -74.97873000),
(1021576, 1002880, 'CO', 'Usiacurí', 1, 'usiacuri', 10.74313000, -74.97604000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002893, 'CO', 'Bolívar Department', 1, 'bolivar-department');

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 
(1020490, 1002893, 'CO', 'Achí', 1, 'achi', 8.56950000, -74.55715000),
(1020510, 1002893, 'CO', 'Altos del Rosario', 1, 'altos-del-rosario', 8.79162000, -74.16556000),
(1020543, 1002893, 'CO', 'Arenal', 1, 'arenal', 8.45928000, -73.94331000),
(1020549, 1002893, 'CO', 'Arjona', 1, 'arjona', 10.17594000, -75.35884000),
(1020554, 1002893, 'CO', 'Arroyohondo', 1, 'arroyohondo', 10.25220000, -75.01980000),
(1020573, 1002893, 'CO', 'Barranco de Loba', 1, 'barranco-de-loba', 8.94597000, -74.10647000),
(1020628, 1002893, 'CO', 'Calamar', 1, 'calamar', 10.23377000, -74.94240000),
(1020645, 1002893, 'CO', 'Cantagallo', 1, 'cantagallo', 7.37926000, -73.91550000),
(1020659, 1002893, 'CO', 'Cartagena', 1, 'cartagena', 10.39972000, -75.51444000),
(1020707, 1002893, 'CO', 'Cicuco', 1, 'cicuco', 9.27756000, -74.64312000),
(1020715, 1002893, 'CO', 'Clemencia', 1, 'clemencia', 10.56645000, -75.32499000),
(1020770, 1002893, 'CO', 'Córdoba', 1, 'cordoba', 9.55149000, -74.89800000),
(1020796, 1002893, 'CO', 'El Carmen de Bolívar', 1, 'el-carmen-de-bolivar', 9.71740000, -75.12023000),
(1020810, 1002893, 'CO', 'El Guamo', 1, 'el-guamo', 10.01753000, -74.93483000),
(1020818, 1002893, 'CO', 'El Peñón', 1, 'el-penon', 8.98691000, -73.94697000),
(1020935, 1002893, 'CO', 'Hatillo de Loba', 1, 'hatillo-de-loba', 8.95635000, -74.07819000),
(1021048, 1002893, 'CO', 'Magangué', 1, 'magangue', 9.24202000, -74.75467000),
(1021050, 1002893, 'CO', 'Mahates', 1, 'mahates', 10.23293000, -75.18985000),
(1021065, 1002893, 'CO', 'Margarita', 1, 'margarita', 9.06325000, -74.28134000),
(1021072, 1002893, 'CO', 'María la Baja', 1, 'maria-la-baja', 9.98320000, -75.30155000),
(1021093, 1002893, 'CO', 'Mompós', 1, 'mompos', 9.13990000, -74.54513000),
(1021098, 1002893, 'CO', 'Montecristo', 1, 'montecristo', 8.29710000, -74.47330000),
(1021104, 1002893, 'CO', 'Morales', 1, 'morales', 8.27520000, -73.86884000),
(1021114, 1002893, 'CO', 'Municipio de Cartagena de Indias', 1, 'municipio-de-cartagena-de-indias', 10.50743000, -75.45430000),
(1021116, 1002893, 'CO', 'Municipio de María la Baja', 1, 'municipio-de-maria-la-baja', 9.99228000, -75.34364000),
(1021138, 1002893, 'CO', 'Norosí', 1, 'norosi', 8.52692000, -74.03736000),
(1021207, 1002893, 'CO', 'Pinillos', 1, 'pinillos', 8.91925000, -74.46771000),
(1021280, 1002893, 'CO', 'Regidor', 1, 'regidor', 8.72229000, -73.84891000),
(1021306, 1002893, 'CO', 'Río Viejo', 1, 'rio-viejo', 8.58740000, -73.83901000),
(1021350, 1002893, 'CO', 'San Cristóbal', 1, 'san-cristobal', 9.87809000, -75.25248000),
(1021353, 1002893, 'CO', 'San Estanislao', 1, 'san-estanislao', 10.39833000, -75.15111000),
(1021355, 1002893, 'CO', 'San Fernando', 1, 'san-fernando', 9.27972000, -74.53389000),
(1021360, 1002893, 'CO', 'San Jacinto', 1, 'san-jacinto', 9.83906000, -75.11043000),
(1021361, 1002893, 'CO', 'San Jacinto del Cauca', 1, 'san-jacinto-del-cauca', 8.23729000, -74.66782000),
(1021372, 1002893, 'CO', 'San Juan Nepomuceno', 1, 'san-juan-nepomuceno', 9.94976000, -75.07426000),
(1021386, 1002893, 'CO', 'San Martín de Loba', 1, 'san-martin-de-loba', 8.88214000, -74.00353000),
(1021393, 1002893, 'CO', 'San Pablo', 1, 'san-pablo', 10.05154000, -75.26775000),
(1021416, 1002893, 'CO', 'Santa Catalina', 1, 'santa-catalina', 10.60448000, -75.29555000),
(1021423, 1002893, 'CO', 'Santa Rosa', 1, 'santa-rosa', 10.47312000, -75.36160000),
(1021427, 1002893, 'CO', 'Santa Rosa del Sur', 1, 'santa-rosa-del-sur', 7.96444000, -74.05444000),
(1021460, 1002893, 'CO', 'Simití', 1, 'simiti', 7.81632000, -73.97922000),
(1021477, 1002893, 'CO', 'Soplaviento', 1, 'soplaviento', 10.33176000, -75.11853000),
(1021505, 1002893, 'CO', 'Talaigua Nuevo', 1, 'talaigua-nuevo', 9.30347000, -74.56477000),
(1021506, 1002893, 'CO', 'Talaigua Viejo', 1, 'talaigua-viejo', 9.31206000, -74.58544000),
(1021531, 1002893, 'CO', 'Tiquisio', 1, 'tiquisio', 8.55666000, -74.26355000),
(1021555, 1002893, 'CO', 'Turbaco', 1, 'turbaco', 10.35707000, -75.38044000),
(1021556, 1002893, 'CO', 'Turbaná', 1, 'turbana', 10.27169000, -75.44222000),
(1021609, 1002893, 'CO', 'Villanueva', 1, 'villanueva', 10.44759000, -75.26574000),
(1021629, 1002893, 'CO', 'Zambrano', 1, 'zambrano', 9.74823000, -74.88487000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002903, 'CO', 'Boyacá Department', 1, 'boyaca-department');

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 
(1020507, 1002903, 'CO', 'Almeida', 1, 'almeida', 4.97083000, -73.37972000),
(1020532, 1002903, 'CO', 'Aquitania', 1, 'aquitania', 5.40341000, -72.90192000),
(1020542, 1002903, 'CO', 'Arcabuco', 1, 'arcabuco', 5.75463000, -73.43669000),
(1020583, 1002903, 'CO', 'Belén', 1, 'belen', 5.98892000, -72.91254000),
(1020587, 1002903, 'CO', 'Berbeo', 1, 'berbeo', 5.22760000, -73.12527000),
(1020591, 1002903, 'CO', 'Betéitiva', 1, 'beteitiva', 5.91102000, -72.80926000),
(1020593, 1002903, 'CO', 'Boavita', 1, 'boavita', 6.33031000, -72.58505000),
(1020600, 1002903, 'CO', 'Boyacá', 1, 'boyaca', 5.45371000, -73.36250000),
(1020601, 1002903, 'CO', 'Briceño', 1, 'briceno', 5.68822000, -73.91784000),
(1020609, 1002903, 'CO', 'Buenavista', 1, 'buenavista', 5.50000000, -73.96667000),
(1020614, 1002903, 'CO', 'Busbanzá', 1, 'busbanza', 5.83047000, -72.88419000),
(1020632, 1002903, 'CO', 'Caldas', 1, 'caldas', 5.57830000, -73.88066000),
(1020641, 1002903, 'CO', 'Campohermoso', 1, 'campohermoso', 4.97733000, -73.16714000),
(1020670, 1002903, 'CO', 'Cerinza', 1, 'cerinza', 5.93649000, -72.99127000),
(1020687, 1002903, 'CO', 'Chinavita', 1, 'chinavita', 5.17915000, -73.37147000),
(1020693, 1002903, 'CO', 'Chiquinquirá', 1, 'chiquinquira', 5.61363000, -73.83848000),
(1020706, 1002903, 'CO', 'Chíquiza', 1, 'chiquiza', 5.60412000, -73.48518000),
(1020695, 1002903, 'CO', 'Chiscas', 1, 'chiscas', 6.55642000, -72.50378000),
(1020696, 1002903, 'CO', 'Chita', 1, 'chita', 6.07788000, -72.46774000),
(1020698, 1002903, 'CO', 'Chitaraque', 1, 'chitaraque', 5.96167000, -73.45761000),
(1020699, 1002903, 'CO', 'Chivatá', 1, 'chivata', 5.55823000, -73.28198000),
(1020701, 1002903, 'CO', 'Chivor', 1, 'chivor', 4.88556000, -73.36889000),
(1020714, 1002903, 'CO', 'Ciénega', 1, 'cienega', 5.40867000, -73.29572000),
(1020768, 1002903, 'CO', 'Cómbita', 1, 'combita', 5.68760000, -73.32942000),
(1020723, 1002903, 'CO', 'Combita', 1, 'combita', 5.63333000, -73.31667000),
(1020736, 1002903, 'CO', 'Coper', 1, 'coper', 5.47681000, -74.04416000),
(1020740, 1002903, 'CO', 'Corrales', 1, 'corrales', 5.82497000, -72.84539000),
(1020743, 1002903, 'CO', 'Covarachía', 1, 'covarachia', 6.50563000, -72.73310000),
(1020750, 1002903, 'CO', 'Cubará', 1, 'cubara', 7.00578000, -72.10568000),
(1020751, 1002903, 'CO', 'Cucaita', 1, 'cucaita', 5.54373000, -73.45433000),
(1020762, 1002903, 'CO', 'Cuítiva', 1, 'cuitiva', 5.58007000, -72.96687000),
(1020783, 1002903, 'CO', 'Duitama', 1, 'duitama', 5.82450000, -73.03408000),
(1020802, 1002903, 'CO', 'El Cocuy', 1, 'el-cocuy', 6.32839000, -72.43577000),
(1020808, 1002903, 'CO', 'El Espino', 1, 'el-espino', 6.50812000, -72.48036000),
(1020846, 1002903, 'CO', 'Firavitoba', 1, 'firavitoba', 5.66885000, -72.99289000),
(1020850, 1002903, 'CO', 'Floresta', 1, 'floresta', 5.85903000, -72.92511000),
(1020873, 1002903, 'CO', 'Gachantivá', 1, 'gachantiva', 5.74417000, -73.54253000),
(1020882, 1002903, 'CO', 'Gameza', 1, 'gameza', 5.80313000, -72.73721000),
(1020928, 1002903, 'CO', 'Gámeza', 1, 'gameza', 5.80263000, -72.80586000),
(1020883, 1002903, 'CO', 'Garagoa', 1, 'garagoa', 5.08236000, -73.36334000),
(1020896, 1002903, 'CO', 'Guacamayas', 1, 'guacamayas', 6.44599000, -72.51676000),
(1020918, 1002903, 'CO', 'Guateque', 1, 'guateque', 5.00619000, -73.47274000),
(1020924, 1002903, 'CO', 'Guayatá', 1, 'guayata', 4.96417000, -73.48750000),
(1020933, 1002903, 'CO', 'Güicán', 1, 'guican', 6.46554000, -72.41539000),
(1020956, 1002903, 'CO', 'Iza', 1, 'iza', 5.61203000, -72.97930000),
(1020960, 1002903, 'CO', 'Jenesano', 1, 'jenesano', 5.38541000, -73.36364000),
(1020962, 1002903, 'CO', 'Jericó', 1, 'jerico', 6.14577000, -72.58598000),
(1020973, 1002903, 'CO', 'La Capilla', 1, 'la-capilla', 5.08076000, -73.48076000),
(1021010, 1002903, 'CO', 'La Uvita', 1, 'la-uvita', 6.24262000, -72.56448000),
(1021015, 1002903, 'CO', 'La Victoria', 1, 'la-victoria', 5.52278000, -74.23280000),
(1021018, 1002903, 'CO', 'Labranzagrande', 1, 'labranzagrande', 5.56223000, -72.57499000),
(1021042, 1002903, 'CO', 'Macanal', 1, 'macanal', 4.95050000, -73.32029000),
(1021067, 1002903, 'CO', 'Maripí', 1, 'maripi', 5.55194000, -74.00861000),
(1021084, 1002903, 'CO', 'Miraflores', 1, 'miraflores', 5.12216000, -73.21212000),
(1021094, 1002903, 'CO', 'Mongua', 1, 'mongua', 5.75084000, -72.80339000),
(1021095, 1002903, 'CO', 'Monguí', 1, 'mongui', 5.69752000, -72.83359000),
(1021096, 1002903, 'CO', 'Moniquirá', 1, 'moniquira', 5.84315000, -73.57775000),
(1021110, 1002903, 'CO', 'Motavita', 1, 'motavita', 5.57655000, -73.36696000),
(1021123, 1002903, 'CO', 'Muzo', 1, 'muzo', 5.53528000, -74.10778000),
(1021135, 1002903, 'CO', 'Nobsa', 1, 'nobsa', 5.76978000, -72.94099000),
(1021140, 1002903, 'CO', 'Nuevo Colón', 1, 'nuevo-colon', 5.35368000, -73.45660000),
(1021148, 1002903, 'CO', 'Oicatá', 1, 'oicata', 5.59548000, -73.30820000),
(1021156, 1002903, 'CO', 'Otanche', 1, 'otanche', 5.77534000, -74.20315000),
(1021158, 1002903, 'CO', 'Pachavita', 1, 'pachavita', 5.13969000, -73.39739000),
(1021268, 1002903, 'CO', 'Páez', 1, 'paez', 5.10112000, -73.05123000),
(1021166, 1002903, 'CO', 'Paipa', 1, 'paipa', 5.78013000, -73.11708000),
(1021168, 1002903, 'CO', 'Pajarito', 1, 'pajarito', 5.34751000, -72.72075000),
(1021180, 1002903, 'CO', 'Panqueba', 1, 'panqueba', 6.44533000, -72.46268000),
(1021186, 1002903, 'CO', 'Pauna', 1, 'pauna', 5.65861000, -73.98250000),
(1021187, 1002903, 'CO', 'Paya', 1, 'paya', 5.62492000, -72.42345000),
(1021190, 1002903, 'CO', 'Paz de Río', 1, 'paz-de-rio', 6.00219000, -72.78857000),
(1021196, 1002903, 'CO', 'Pesca', 1, 'pesca', 5.50213000, -73.08794000),
(1021209, 1002903, 'CO', 'Pisba', 1, 'pisba', 5.72396000, -72.48646000),
(1021236, 1002903, 'CO', 'Puerto Boyacá', 1, 'puerto-boyaca', 5.97214000, -74.46349000),
(1021276, 1002903, 'CO', 'Quípama', 1, 'quipama', 5.51940000, -74.17765000),
(1021278, 1002903, 'CO', 'Ramiriquí', 1, 'ramiriqui', 5.40020000, -73.33544000),
(1021303, 1002903, 'CO', 'Ráquira', 1, 'raquira', 5.53793000, -73.63201000),
(1021300, 1002903, 'CO', 'Rondón', 1, 'rondon', 5.38173000, -73.19683000),
(1021315, 1002903, 'CO', 'Saboyá', 1, 'saboya', 5.69636000, -73.76932000),
(1021502, 1002903, 'CO', 'Sáchica', 1, 'sachica', 5.58453000, -73.54184000),
(1021324, 1002903, 'CO', 'Samacá', 1, 'samaca', 5.49273000, -73.48537000),
(1021352, 1002903, 'CO', 'San Eduardo', 1, 'san-eduardo', 5.22396000, -73.07696000),
(1021368, 1002903, 'CO', 'San José de Pare', 1, 'san-jose-de-pare', 6.01746000, -73.54703000),
(1021380, 1002903, 'CO', 'San Luis de Gaceno', 1, 'san-luis-de-gaceno', 4.82052000, -73.16851000),
(1021387, 1002903, 'CO', 'San Mateo', 1, 'san-mateo', 6.37704000, -72.57797000),
(1021390, 1002903, 'CO', 'San Miguel de Sema', 1, 'san-miguel-de-sema', 5.51847000, -73.72238000),
(1021394, 1002903, 'CO', 'San Pablo de Borbur', 1, 'san-pablo-de-borbur', 5.66638000, -74.13723000),
(1021422, 1002903, 'CO', 'Santa María', 1, 'santa-maria', 4.82282000, -73.25373000),
(1021426, 1002903, 'CO', 'Santa Rosa de Viterbo', 1, 'santa-rosa-de-viterbo', 5.87401000, -72.98217000),
(1021430, 1002903, 'CO', 'Santa Sofía', 1, 'santa-sofia', 5.70213000, -73.62976000),
(1021433, 1002903, 'CO', 'Santana', 1, 'santana', 6.04464000, -73.51107000),
(1021447, 1002903, 'CO', 'Sativanorte', 1, 'sativanorte', 6.13156000, -72.70895000),
(1021448, 1002903, 'CO', 'Sativasur', 1, 'sativasur', 6.08959000, -72.72432000),
(1021452, 1002903, 'CO', 'Siachoque', 1, 'siachoque', 5.51238000, -73.24436000),
(1021465, 1002903, 'CO', 'Soatá', 1, 'soata', 6.29966000, -72.72422000),
(1021466, 1002903, 'CO', 'Socha', 1, 'socha', 5.92926000, -72.70072000),
(1021467, 1002903, 'CO', 'Socha Viejo', 1, 'socha-viejo', 5.98170000, -72.71503000),
(1021469, 1002903, 'CO', 'Socotá', 1, 'socota', 6.04028000, -72.63509000),
(1021470, 1002903, 'CO', 'Sogamoso', 1, 'sogamoso', 5.71434000, -72.93391000),
(1021473, 1002903, 'CO', 'Somondoco', 1, 'somondoco', 4.98495000, -73.43238000),
(1021479, 1002903, 'CO', 'Sora', 1, 'sora', 5.56514000, -73.45017000),
(1021480, 1002903, 'CO', 'Soracá', 1, 'soraca', 5.50055000, -73.33299000),
(1021481, 1002903, 'CO', 'Sotaquirá', 1, 'sotaquira', 5.76483000, -73.24758000),
(1021495, 1002903, 'CO', 'Susacón', 1, 'susacon', 6.22978000, -72.69010000),
(1021496, 1002903, 'CO', 'Sutamarchán', 1, 'sutamarchan', 5.61538000, -73.61701000),
(1021498, 1002903, 'CO', 'Sutatenza', 1, 'sutatenza', 5.02311000, -73.45230000),
(1021515, 1002903, 'CO', 'Tasco', 1, 'tasco', 5.91044000, -72.78001000),
(1021521, 1002903, 'CO', 'Tenza', 1, 'tenza', 5.07664000, -73.42077000),
(1021523, 1002903, 'CO', 'Tibaná', 1, 'tibana', 5.31728000, -73.39655000),
(1021524, 1002903, 'CO', 'Tibasosa', 1, 'tibasosa', 5.74722000, -73.01091000),
(1021529, 1002903, 'CO', 'Tinjacá', 1, 'tinjaca', 5.57916000, -73.64486000),
(1021530, 1002903, 'CO', 'Tipacoque', 1, 'tipacoque', 6.42031000, -72.69184000),
(1021533, 1002903, 'CO', 'Toca', 1, 'toca', 5.56393000, -73.18398000),
(1021536, 1002903, 'CO', 'Togüí', 1, 'togui', 5.93462000, -73.51297000),
(1021563, 1002903, 'CO', 'Tópaga', 1, 'topaga', 5.75979000, -72.82583000),
(1021545, 1002903, 'CO', 'Tota', 1, 'tota', 5.55833000, -72.98757000),
(1021553, 1002903, 'CO', 'Tunja', 1, 'tunja', 5.53528000, -73.36778000),
(1021554, 1002903, 'CO', 'Tununguá', 1, 'tunungua', 5.72967000, -73.94137000),
(1021558, 1002903, 'CO', 'Turmequé', 1, 'turmeque', 5.32360000, -73.49067000),
(1021559, 1002903, 'CO', 'Tuta', 1, 'tuta', 5.68966000, -73.22779000),
(1021560, 1002903, 'CO', 'Tutazá', 1, 'tutaza', 6.03228000, -72.85639000),
(1021568, 1002903, 'CO', 'Umbita', 1, 'umbita', 5.18411000, -73.48341000),
(1021639, 1002903, 'CO', 'Úmbita', 1, 'umbita', 5.22041000, -73.45695000),
(1021589, 1002903, 'CO', 'Ventaquemada', 1, 'ventaquemada', 5.35987000, -73.55032000),
(1021598, 1002903, 'CO', 'Villa de Leyva', 1, 'villa-de-leyva', 5.67061000, -73.51554000),
(1021615, 1002903, 'CO', 'Viracachá', 1, 'viracacha', 5.43637000, -73.29606000),
(1021634, 1002903, 'CO', 'Zetaquira', 1, 'zetaquira', 5.25824000, -73.18275000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002887, 'CO', 'Caldas Department', 1, 'caldas-department');

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 
(1020494, 1002887, 'CO', 'Aguadas', 1, 'aguadas', 5.61161000, -75.45624000),
(1020525, 1002887, 'CO', 'Anserma', 1, 'anserma', 5.20427000, -75.79167000),
(1020534, 1002887, 'CO', 'Aranzazu', 1, 'aranzazu', 5.25519000, -75.50984000),
(1020576, 1002887, 'CO', 'Belalcázar', 1, 'belalcazar', 4.99528000, -75.81278000),
(1020688, 1002887, 'CO', 'Chinchiná', 1, 'chinchina', 4.97522000, -75.70416000),
(1020844, 1002887, 'CO', 'Filadelfia', 1, 'filadelfia', 5.29606000, -75.56120000),
(1020981, 1002887, 'CO', 'La Dorada', 1, 'la-dorada', 5.53333000, -74.70000000),
(1020992, 1002887, 'CO', 'La Merced', 1, 'la-merced', 5.38060000, -75.58842000),
(1021059, 1002887, 'CO', 'Manizales', 1, 'manizales', 5.06889000, -75.51738000),
(1021061, 1002887, 'CO', 'Manzanares', 1, 'manzanares', 5.23305000, -75.15168000),
(1021068, 1002887, 'CO', 'Marmato', 1, 'marmato', 5.47554000, -75.59710000),
(1021069, 1002887, 'CO', 'Marquetalia', 1, 'marquetalia', 5.29069000, -75.08028000),
(1021071, 1002887, 'CO', 'Marulanda', 1, 'marulanda', 5.28393000, -75.26016000),
(1021131, 1002887, 'CO', 'Neira', 1, 'neira', 5.17534000, -75.52405000),
(1021137, 1002887, 'CO', 'Norcasia', 1, 'norcasia', 5.57535000, -74.88831000),
(1021267, 1002887, 'CO', 'Pácora', 1, 'pacora', 5.50631000, -75.49054000),
(1021169, 1002887, 'CO', 'Palestina', 1, 'palestina', 5.04571000, -75.69552000),
(1021193, 1002887, 'CO', 'Pensilvania', 1, 'pensilvania', 5.38840000, -75.20420000),
(1021294, 1002887, 'CO', 'Riosucio', 1, 'riosucio', 5.42164000, -75.70318000),
(1021296, 1002887, 'CO', 'Risaralda', 1, 'risaralda', 5.11237000, -75.75861000),
(1021319, 1002887, 'CO', 'Salamina', 1, 'salamina', 5.37014000, -75.41548000),
(1021326, 1002887, 'CO', 'Samaná', 1, 'samana', 5.54061000, -74.99346000),
(1021364, 1002887, 'CO', 'San José', 1, 'san-jose', 5.08221000, -75.79107000),
(1021492, 1002887, 'CO', 'Supía', 1, 'supia', 5.45303000, -75.65072000),
(1021594, 1002887, 'CO', 'Victoria', 1, 'victoria', 5.45666000, -74.84061000),
(1021605, 1002887, 'CO', 'Villamaría', 1, 'villamaria', 4.95078000, -75.43680000),
(1021617, 1002887, 'CO', 'Viterbo', 1, 'viterbo', 5.06242000, -75.87159000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002891, 'CO', 'Caquetá Department', 1, 'caqueta-department');

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 
(1020499, 1002891, 'CO', 'Albania', 1, 'albania', 1.26325000, -75.95366000),
(1020584, 1002891, 'CO', 'Belén de Los Andaquies', 1, 'belen-de-los-andaquies', 1.41667000, -75.91667000),
(1020586, 1002891, 'CO', 'Belén de los Andaquíes', 1, 'belen-de-los-andaquies', 1.41828000, -75.87753000),
(1020660, 1002891, 'CO', 'Cartagena del Chairá', 1, 'cartagena-del-chaira', 1.33488000, -74.84289000),
(1020759, 1002891, 'CO', 'Curillo', 1, 'curillo', 1.03327000, -75.91907000),
(1020805, 1002891, 'CO', 'El Doncello', 1, 'el-doncello', 1.67817000, -75.28466000),
(1020814, 1002891, 'CO', 'El Paujil', 1, 'el-paujil', 1.57085000, -75.31403000),
(1020815, 1002891, 'CO', 'El Paujíl', 1, 'el-paujil', 1.57006000, -75.32863000),
(1020849, 1002891, 'CO', 'Florencia', 1, 'florencia', 1.71619000, -75.59624000),
(1020994, 1002891, 'CO', 'La Montañita', 1, 'la-montanita', 1.46389000, -75.30363000),
(1021082, 1002891, 'CO', 'Milán', 1, 'milan', 1.29034000, -75.50757000),
(1021105, 1002891, 'CO', 'Morelia', 1, 'morelia', 1.48747000, -75.72581000),
(1021251, 1002891, 'CO', 'Puerto Rico', 1, 'puerto-rico', 1.90999000, -75.15931000),
(1021369, 1002891, 'CO', 'San José del Fragua', 1, 'san-jose-del-fragua', 1.30780000, -76.16554000),
(1021471, 1002891, 'CO', 'Solano', 1, 'solano', 0.22842000, -73.27597000),
(1021583, 1002891, 'CO', 'Valparaíso', 1, 'valparaiso', 1.19403000, -75.70746000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002892, 'CO', 'Casanare Department', 1, 'casanare-department');

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 
(1020495, 1002892, 'CO', 'Aguazul', 1, 'aguazul', 5.17282000, -72.54706000),
(1020677, 1002892, 'CO', 'Chameza', 1, 'chameza', 5.19237000, -72.88952000),
(1020704, 1002892, 'CO', 'Chámeza', 1, 'chameza', 5.21421000, -72.86948000),
(1020937, 1002892, 'CO', 'Hato Corozal', 1, 'hato-corozal', 6.16278000, -70.99694000),
(1021062, 1002892, 'CO', 'Maní', 1, 'mani', 4.81638000, -72.27946000),
(1021101, 1002892, 'CO', 'Monterrey', 1, 'monterrey', 4.82015000, -72.87901000),
(1021113, 1002892, 'CO', 'Municipio Hato Corozal', 1, 'municipio-hato-corozal', 6.15676000, -71.76372000),
(1021141, 1002892, 'CO', 'Nunchía', 1, 'nunchia', 5.63589000, -72.19543000),
(1021153, 1002892, 'CO', 'Orocué', 1, 'orocue', 4.79035000, -71.33917000),
(1021220, 1002892, 'CO', 'Pore', 1, 'pore', 5.72792000, -71.99266000),
(1021279, 1002892, 'CO', 'Recetor', 1, 'recetor', 5.22947000, -72.76099000),
(1021310, 1002892, 'CO', 'Sabanalarga', 1, 'sabanalarga', 4.85430000, -73.04003000),
(1021501, 1002892, 'CO', 'Sácama', 1, 'sacama', 6.09908000, -72.24880000),
(1021381, 1002892, 'CO', 'San Luis de Palenque', 1, 'san-luis-de-palenque', 5.42139000, -71.73167000),
(1021561, 1002892, 'CO', 'Támara', 1, 'tamara', 5.82998000, -72.16286000),
(1021516, 1002892, 'CO', 'Tauramena', 1, 'tauramena', 5.01789000, -72.74675000),
(1021548, 1002892, 'CO', 'Trinidad', 1, 'trinidad', 5.34778000, -71.20194000),
(1021607, 1002892, 'CO', 'Villanueva', 1, 'villanueva', 5.28333000, -71.96667000),
(1021626, 1002892, 'CO', 'Yopal', 1, 'yopal', 5.33775000, -72.39586000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002884, 'CO', 'Cauca Department', 1, 'cauca-department');

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 
(1020506, 1002884, 'CO', 'Almaguer', 1, 'almaguer', 1.91472000, -76.85482000),
(1020545, 1002884, 'CO', 'Argelia', 1, 'argelia', 2.31728000, -77.25700000),
(1020562, 1002884, 'CO', 'Balboa', 1, 'balboa', 2.08436000, -77.20781000),
(1020577, 1002884, 'CO', 'Belalcázar', 1, 'belalcazar', 2.64644000, -75.97269000),
(1020599, 1002884, 'CO', 'Bolívar', 1, 'bolivar', 1.84670000, -76.98292000),
(1020610, 1002884, 'CO', 'Buenos Aires', 1, 'buenos-aires', 3.04825000, -76.63066000),
(1020625, 1002884, 'CO', 'Cajibío', 1, 'cajibio', 2.62271000, -76.57039000),
(1020633, 1002884, 'CO', 'Caldono', 1, 'caldono', 2.79739000, -76.48316000),
(1020637, 1002884, 'CO', 'Caloto', 1, 'caloto', 3.03586000, -76.40788000),
(1020737, 1002884, 'CO', 'Corinto', 1, 'corinto', 3.13598000, -76.20646000),
(1020788, 1002884, 'CO', 'El Bordo', 1, 'el-bordo', 2.11696000, -76.98214000),
(1020831, 1002884, 'CO', 'El Tambo', 1, 'el-tambo', 2.45199000, -76.81029000),
(1020848, 1002884, 'CO', 'Florencia', 1, 'florencia', 1.68318000, -77.07331000),
(1020909, 1002884, 'CO', 'Guapi', 1, 'guapi', 2.55210000, -77.87865000),
(1020911, 1002884, 'CO', 'Guapí', 1, 'guapi', 2.57082000, -77.88542000),
(1020948, 1002884, 'CO', 'Inzá', 1, 'inza', 2.55452000, -76.06722000),
(1020957, 1002884, 'CO', 'Jambaló', 1, 'jambalo', 2.85065000, -76.32506000),
(1021003, 1002884, 'CO', 'La Sierra', 1, 'la-sierra', 2.19665000, -76.78590000),
(1021011, 1002884, 'CO', 'La Vega', 1, 'la-vega', 2.06201000, -76.76808000),
(1021041, 1002884, 'CO', 'López', 1, 'lopez', 2.43333000, -76.80000000),
(1021080, 1002884, 'CO', 'Mercaderes', 1, 'mercaderes', 1.80175000, -77.17032000),
(1021085, 1002884, 'CO', 'Miranda', 1, 'miranda', 3.23773000, -76.22093000),
(1021103, 1002884, 'CO', 'Morales', 1, 'morales', 2.75446000, -76.62791000),
(1021115, 1002884, 'CO', 'Municipio de López de Micay', 1, 'municipio-de-lopez-de-micay', 3.00000000, -77.25000000),
(1021161, 1002884, 'CO', 'Padilla', 1, 'padilla', 3.22038000, -76.31385000),
(1021163, 1002884, 'CO', 'Paez', 1, 'paez', 2.75000000, -76.00000000),
(1021167, 1002884, 'CO', 'Paispamba', 1, 'paispamba', 2.25462000, -76.61086000),
(1021185, 1002884, 'CO', 'Patía', 1, 'patia', 2.14018000, -77.01744000),
(1021202, 1002884, 'CO', 'Piendamo', 1, 'piendamo', 2.63918000, -76.53055000),
(1021203, 1002884, 'CO', 'Piendamó', 1, 'piendamo', 2.70214000, -76.59736000),
(1021219, 1002884, 'CO', 'Popayán', 1, 'popayan', 2.43823000, -76.61316000),
(1021257, 1002884, 'CO', 'Puerto Tejada', 1, 'puerto-tejada', 3.23393000, -76.41935000),
(1021263, 1002884, 'CO', 'Puracé', 1, 'purace', 2.33851000, -76.38759000),
(1021301, 1002884, 'CO', 'Rosas', 1, 'rosas', 2.26093000, -76.73986000),
(1021404, 1002884, 'CO', 'San Sebastián', 1, 'san-sebastian', 1.91667000, -76.66667000),
(1021434, 1002884, 'CO', 'Santander de Quilichao', 1, 'santander-de-quilichao', 3.00945000, -76.48494000),
(1021457, 1002884, 'CO', 'Silvia', 1, 'silvia', 2.61557000, -76.38261000),
(1021482, 1002884, 'CO', 'Sotara', 1, 'sotara', 2.25000000, -76.58333000),
(1021499, 1002884, 'CO', 'Suárez', 1, 'suarez', 2.95395000, -76.69644000),
(1021489, 1002884, 'CO', 'Sucre', 1, 'sucre', 2.06182000, -76.91438000),
(1021528, 1002884, 'CO', 'Timbiquí', 1, 'timbiqui', 2.77170000, -77.66536000),
(1021542, 1002884, 'CO', 'Toribio', 1, 'toribio', 3.00000000, -76.16667000),
(1021543, 1002884, 'CO', 'Toribío', 1, 'toribio', 2.95481000, -76.26839000),
(1021546, 1002884, 'CO', 'Totoró', 1, 'totoro', 2.50518000, -76.39254000),
(1021597, 1002884, 'CO', 'Villa Rica', 1, 'villa-rica', 2.51420000, -76.84939000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002899, 'CO', 'Cesar Department', 1, 'cesar-department');

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 
(1020492, 1002899, 'CO', 'Aguachica', 1, 'aguachica', 8.30844000, -73.61660000),
(1020496, 1002899, 'CO', 'Agustín Codazzi', 1, 'agustin-codazzi', 10.03672000, -73.23558000),
(1020547, 1002899, 'CO', 'Ariguaní', 1, 'ariguani', 10.25000000, -74.00000000),
(1020555, 1002899, 'CO', 'Astrea', 1, 'astrea', 9.49828000, -73.97591000),
(1020575, 1002899, 'CO', 'Becerril', 1, 'becerril', 9.70413000, -73.27930000),
(1020685, 1002899, 'CO', 'Chimichagua', 1, 'chimichagua', 9.25778000, -73.81228000),
(1020694, 1002899, 'CO', 'Chiriguaná', 1, 'chiriguana', 9.36238000, -73.60313000),
(1020761, 1002899, 'CO', 'Curumaní', 1, 'curumani', 9.19992000, -73.54274000),
(1020804, 1002899, 'CO', 'El Copey', 1, 'el-copey', 10.15031000, -73.96140000),
(1020813, 1002899, 'CO', 'El Paso', 1, 'el-paso', 9.65724000, -73.74685000),
(1020880, 1002899, 'CO', 'Gamarra', 1, 'gamarra', 8.32969000, -73.71773000),
(1020890, 1002899, 'CO', 'González', 1, 'gonzalez', 8.36735000, -73.40032000),
(1020985, 1002899, 'CO', 'La Gloria', 1, 'la-gloria', 8.61160000, -73.63045000),
(1020987, 1002899, 'CO', 'La Jagua de Ibirico', 1, 'la-jagua-de-ibirico', 9.56228000, -73.33405000),
(1020997, 1002899, 'CO', 'La Paz', 1, 'la-paz', 10.10487000, -73.22056000),
(1021057, 1002899, 'CO', 'Manaure', 1, 'manaure', 10.40138000, -72.93102000),
(1021058, 1002899, 'CO', 'Manaure Balcón del Cesar', 1, 'manaure-balcon-del-cesar', 10.39278000, -73.03250000),
(1021164, 1002899, 'CO', 'Pailitas', 1, 'pailitas', 8.95652000, -73.62548000),
(1021192, 1002899, 'CO', 'Pelaya', 1, 'pelaya', 8.68819000, -73.66451000),
(1021307, 1002899, 'CO', 'Río de Oro', 1, 'rio-de-oro', 8.17879000, -73.51218000),
(1021328, 1002899, 'CO', 'San Alberto', 1, 'san-alberto', 7.76107000, -73.39220000),
(1021351, 1002899, 'CO', 'San Diego', 1, 'san-diego', 10.33623000, -73.18203000),
(1021384, 1002899, 'CO', 'San Martín', 1, 'san-martin', 8.00151000, -73.51126000),
(1021507, 1002899, 'CO', 'Tamalameque', 1, 'tamalameque', 8.86422000, -73.78106000),
(1021582, 1002899, 'CO', 'Valledupar', 1, 'valledupar', 10.46314000, -73.25322000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002876, 'CO', 'Chocó Department', 1, 'choco-department');

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 
(1020489, 1002876, 'CO', 'Acandí', 1, 'acandi', 8.51158000, -77.27719000),
(1020509, 1002876, 'CO', 'Alto Baudo', 1, 'alto-baudo', 5.60464000, -77.06975000),
(1020557, 1002876, 'CO', 'Atrato', 1, 'atrato', 5.57362000, -76.64063000),
(1020559, 1002876, 'CO', 'Bagadó', 1, 'bagado', 5.41164000, -76.41520000),
(1020560, 1002876, 'CO', 'Bahía Solano', 1, 'bahia-solano', 6.22520000, -77.39147000),
(1020561, 1002876, 'CO', 'Bajo Baudó', 1, 'bajo-baudo', 4.90181000, -77.22771000),
(1020578, 1002876, 'CO', 'Bellavista', 1, 'bellavista', 6.55645000, -76.88389000),
(1020596, 1002876, 'CO', 'Bojaya', 1, 'bojaya', 6.50000000, -77.10000000),
(1020657, 1002876, 'CO', 'Carmen del Darien', 1, 'carmen-del-darien', 7.03639000, -76.95222000),
(1020767, 1002876, 'CO', 'Cértegui', 1, 'certegui', 5.37073000, -76.60440000),
(1020728, 1002876, 'CO', 'Condoto', 1, 'condoto', 5.09351000, -76.64973000),
(1020791, 1002876, 'CO', 'El Cantón de San Pablo', 1, 'el-canton-de-san-pablo', 5.33889000, -76.73139000),
(1020792, 1002876, 'CO', 'El Cantón del San Pablo', 1, 'el-canton-del-san-pablo', 5.35989000, -76.77280000),
(1020794, 1002876, 'CO', 'El Carmen', 1, 'el-carmen', 5.88778000, -75.16417000),
(1020795, 1002876, 'CO', 'El Carmen de Atrato', 1, 'el-carmen-de-atrato', 5.83333000, -76.25000000),
(1020811, 1002876, 'CO', 'El Litoral del San Juan', 1, 'el-litoral-del-san-juan', 4.25070000, -76.96926000),
(1020952, 1002876, 'CO', 'Istmina', 1, 'istmina', 5.16054000, -76.68397000),
(1020969, 1002876, 'CO', 'Juradó', 1, 'jurado', 7.10421000, -77.76200000),
(1021030, 1002876, 'CO', 'Lloró', 1, 'lloro', 5.49605000, -76.54945000),
(1021076, 1002876, 'CO', 'Medio Atrato', 1, 'medio-atrato', 5.99500000, -76.78250000),
(1021077, 1002876, 'CO', 'Medio Baudó', 1, 'medio-baudo', 5.05000000, -77.05000000),
(1021078, 1002876, 'CO', 'Medio San Juan', 1, 'medio-san-juan', 5.09278000, -76.69528000),
(1021143, 1002876, 'CO', 'Nóvita', 1, 'novita', 4.95511000, -76.60526000),
(1021142, 1002876, 'CO', 'Nuquí', 1, 'nuqui', 5.71250000, -77.27083000),
(1021198, 1002876, 'CO', 'Pie de Pató', 1, 'pie-de-pato', 5.51604000, -76.97449000),
(1021211, 1002876, 'CO', 'Pizarro', 1, 'pizarro', 4.95334000, -77.36598000),
(1021272, 1002876, 'CO', 'Quibdó', 1, 'quibdo', 5.76075000, -76.83701000),
(1021304, 1002876, 'CO', 'Río Iro', 1, 'rio-iro', 5.18333000, -76.48330000),
(1021305, 1002876, 'CO', 'Río Quito', 1, 'rio-quito', 5.51667000, -76.75000000),
(1021295, 1002876, 'CO', 'Riosucio', 1, 'riosucio', 7.41667000, -77.16667000),
(1021371, 1002876, 'CO', 'San José del Palmar', 1, 'san-jose-del-palmar', 4.89616000, -76.23422000),
(1021418, 1002876, 'CO', 'Santa Genoveva de Docordó', 1, 'santa-genoveva-de-docordo', 4.25875000, -77.36516000),
(1021462, 1002876, 'CO', 'Sipí', 1, 'sipi', 4.65374000, -76.64442000),
(1021504, 1002876, 'CO', 'Tadó', 1, 'tado', 5.26598000, -76.56487000),
(1021570, 1002876, 'CO', 'Unguía', 1, 'unguia', 8.04364000, -77.09137000),
(1021571, 1002876, 'CO', 'Unión Panamericana', 1, 'union-panamericana', 5.28139000, -76.63000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002898, 'CO', 'Córdoba Department', 1, 'cordoba-department');

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 
(1020558, 1002898, 'CO', 'Ayapel', 1, 'ayapel', 8.31372000, -75.13982000),
(1020608, 1002898, 'CO', 'Buenavista', 1, 'buenavista', 9.04963000, -76.00280000),
(1020642, 1002898, 'CO', 'Canalete', 1, 'canalete', 8.67611000, -76.20417000),
(1020669, 1002898, 'CO', 'Cereté', 1, 'cerete', 8.88479000, -75.79052000),
(1020686, 1002898, 'CO', 'Chimá', 1, 'chima', 9.14893000, -75.62841000),
(1020690, 1002898, 'CO', 'Chinú', 1, 'chinu', 9.03869000, -75.34273000),
(1020713, 1002898, 'CO', 'Ciénaga de Oro', 1, 'cienaga-de-oro', 8.83581000, -75.60425000),
(1020742, 1002898, 'CO', 'Cotorra', 1, 'cotorra', 9.03886000, -75.78969000),
(1020970, 1002898, 'CO', 'La Apartada', 1, 'la-apartada', 8.04787000, -75.30097000),
(1021031, 1002898, 'CO', 'Lorica', 1, 'lorica', 9.23648000, -75.81350000),
(1021033, 1002898, 'CO', 'Los Córdobas', 1, 'los-cordobas', 8.89403000, -76.35455000),
(1021092, 1002898, 'CO', 'Momil', 1, 'momil', 9.23767000, -75.67489000),
(1021112, 1002898, 'CO', 'Moñitos', 1, 'monitos', 9.22615000, -76.13594000),
(1021099, 1002898, 'CO', 'Montelíbano', 1, 'montelibano', 7.97917000, -75.42020000),
(1021102, 1002898, 'CO', 'Montería', 1, 'monteria', 8.74798000, -75.88143000),
(1021213, 1002898, 'CO', 'Planeta Rica', 1, 'planeta-rica', 8.41150000, -75.58508000),
(1021225, 1002898, 'CO', 'Pueblo Nuevo', 1, 'pueblo-nuevo', 8.24110000, -74.95815000),
(1021241, 1002898, 'CO', 'Puerto Escondido', 1, 'puerto-escondido', 8.99453000, -76.19351000),
(1021245, 1002898, 'CO', 'Puerto Libertador', 1, 'puerto-libertador', 7.68181000, -75.78312000),
(1021265, 1002898, 'CO', 'Purísima', 1, 'purisima', 9.24955000, -75.71181000),
(1021266, 1002898, 'CO', 'Purísima de la Concepción', 1, 'purisima-de-la-concepcion', 9.23657000, -75.72191000),
(1021316, 1002898, 'CO', 'Sahagún', 1, 'sahagun', 8.94617000, -75.44275000),
(1021333, 1002898, 'CO', 'San Andrés Sotavento', 1, 'san-andres-sotavento', 9.12183000, -75.51627000),
(1021335, 1002898, 'CO', 'San Antero', 1, 'san-antero', 9.37410000, -75.75891000),
(1021343, 1002898, 'CO', 'San Bernardo del Viento', 1, 'san-bernardo-del-viento', 9.35330000, -75.95244000),
(1021346, 1002898, 'CO', 'San Carlos', 1, 'san-carlos', 8.79577000, -75.69947000),
(1021401, 1002898, 'CO', 'San Pelayo', 1, 'san-pelayo', 8.95833000, -75.83627000),
(1021527, 1002898, 'CO', 'Tierralta', 1, 'tierralta', 7.87863000, -76.21307000),
(1021578, 1002898, 'CO', 'Valencia', 1, 'valencia', 8.23350000, -76.21428000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002875, 'CO', 'Cundinamarca Department', 1, 'cundinamarca-department');

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 
(1020491, 1002875, 'CO', 'Agua de Dios', 1, 'agua-de-dios', 4.37648000, -74.66995000),
(1020501, 1002875, 'CO', 'Albán', 1, 'alban', 4.89432000, -74.44388000),
(1020516, 1002875, 'CO', 'Anapoima', 1, 'anapoima', 4.55099000, -74.53517000),
(1020523, 1002875, 'CO', 'Anolaima', 1, 'anolaima', 4.83362000, -74.49950000),
(1020530, 1002875, 'CO', 'Apulo', 1, 'apulo', 4.51952000, -74.59293000),
(1020538, 1002875, 'CO', 'Arbeláez', 1, 'arbelaez', 4.21251000, -74.41464000),
(1143872, 1002875, 'CO', 'Barrio San Luis', 1, 'barrio-san-luis', 4.66779000, -74.02150000),
(1020581, 1002875, 'CO', 'Beltrán', 1, 'beltran', 4.71947000, -74.75660000),
(1020592, 1002875, 'CO', 'Bituima', 1, 'bituima', 4.87252000, -74.53925000),
(1143873, 1002875, 'CO', 'Bogota', 1, 'bogota', 4.61263889, -74.07050000),
(1020595, 1002875, 'CO', 'Bojacá', 1, 'bojaca', 4.73176000, -74.34129000),
(1020615, 1002875, 'CO', 'Cabrera', 1, 'cabrera', 3.98598000, -74.48283000),
(1020619, 1002875, 'CO', 'Cachipay', 1, 'cachipay', 5.26667000, -74.56667000),
(1020626, 1002875, 'CO', 'Cajicá', 1, 'cajica', 4.91857000, -74.02799000),
(1020646, 1002875, 'CO', 'Caparrapí', 1, 'caparrapi', 5.34644000, -74.49147000),
(1020766, 1002875, 'CO', 'Cáqueza', 1, 'caqueza', 4.40569000, -73.94683000),
(1020648, 1002875, 'CO', 'Caqueza', 1, 'caqueza', 4.38708000, -73.95722000),
(1020655, 1002875, 'CO', 'Carmen de Carupa', 1, 'carmen-de-carupa', 5.34862000, -73.90168000),
(1020675, 1002875, 'CO', 'Chaguaní', 1, 'chaguani', 4.94829000, -74.59392000),
(1020705, 1002875, 'CO', 'Chía', 1, 'chia', 4.84452000, -74.05848000),
(1020691, 1002875, 'CO', 'Chipaque', 1, 'chipaque', 4.44250000, -74.04417000),
(1020702, 1002875, 'CO', 'Choachí', 1, 'choachi', 4.52897000, -73.92273000),
(1020703, 1002875, 'CO', 'Chocontá', 1, 'choconta', 5.14468000, -73.68578000),
(1020718, 1002875, 'CO', 'Cogua', 1, 'cogua', 5.06051000, -73.97925000),
(1020741, 1002875, 'CO', 'Cota', 1, 'cota', 4.80938000, -74.09800000),
(1020752, 1002875, 'CO', 'Cucunubá', 1, 'cucunuba', 5.24958000, -73.76610000),
(1020803, 1002875, 'CO', 'El Colegio', 1, 'el-colegio', 4.56047000, -74.42614000),
(1021159, 1002875, 'CO', 'El Maríachi', 1, 'el-mariachi', 5.13278000, -74.15977000),
(1020817, 1002875, 'CO', 'El Peñón', 1, 'el-penon', 5.25264000, -74.29069000),
(1020826, 1002875, 'CO', 'El Rosal', 1, 'el-rosal', 4.85314000, -74.25996000),
(1020842, 1002875, 'CO', 'Facatativá', 1, 'facatativa', 4.81367000, -74.35453000),
(1020854, 1002875, 'CO', 'Fomeque', 1, 'fomeque', 4.52806000, -73.78879000),
(1020868, 1002875, 'CO', 'Fómeque', 1, 'fomeque', 4.48797000, -73.89749000),
(1020857, 1002875, 'CO', 'Fosca', 1, 'fosca', 4.33916000, -73.93852000),
(1020866, 1002875, 'CO', 'Funza', 1, 'funza', 4.71638000, -74.21195000),
(1020869, 1002875, 'CO', 'Fúquene', 1, 'fuquene', 5.41988000, -73.76997000),
(1020867, 1002875, 'CO', 'Fusagasugá', 1, 'fusagasuga', 4.33646000, -74.36378000),
(1020870, 1002875, 'CO', 'Gachala', 1, 'gachala', 4.66667000, -73.50000000),
(1020871, 1002875, 'CO', 'Gachalá', 1, 'gachala', 4.69244000, -73.52042000),
(1020872, 1002875, 'CO', 'Gachancipá', 1, 'gachancipa', 4.99111000, -73.87154000),
(1020874, 1002875, 'CO', 'Gachetá', 1, 'gacheta', 4.87104000, -73.61730000),
(1020879, 1002875, 'CO', 'Gama', 1, 'gama', 4.76288000, -73.61091000),
(1020886, 1002875, 'CO', 'Girardot', 1, 'girardot', 4.31802000, -74.83504000),
(1020892, 1002875, 'CO', 'Granada', 1, 'granada', 5.06667000, -74.56667000),
(1020898, 1002875, 'CO', 'Guachetá', 1, 'guacheta', 5.38425000, -73.68617000),
(1020903, 1002875, 'CO', 'Guaduas', 1, 'guaduas', 5.07430000, -74.59854000),
(1020914, 1002875, 'CO', 'Guasca', 1, 'guasca', 4.86601000, -73.87748000),
(1020916, 1002875, 'CO', 'Guataquí', 1, 'guataqui', 4.51573000, -74.78935000),
(1020917, 1002875, 'CO', 'Guatavita', 1, 'guatavita', 4.93658000, -73.83314000),
(1020921, 1002875, 'CO', 'Guayabal de Siquima', 1, 'guayabal-de-siquima', 4.87881000, -74.48306000),
(1020922, 1002875, 'CO', 'Guayabal de Síquima', 1, 'guayabal-de-siquima', 4.87739000, -74.46744000),
(1020923, 1002875, 'CO', 'Guayabetal', 1, 'guayabetal', 4.21472000, -73.81719000),
(1020925, 1002875, 'CO', 'Gutiérrez', 1, 'gutierrez', 4.18486000, -74.01168000),
(1020963, 1002875, 'CO', 'Jerusalén', 1, 'jerusalen', 4.56309000, -74.69519000),
(1020968, 1002875, 'CO', 'Junín', 1, 'junin', 4.70725000, -73.69549000),
(1020972, 1002875, 'CO', 'La Calera', 1, 'la-calera', 4.68678000, -73.93590000),
(1020993, 1002875, 'CO', 'La Mesa', 1, 'la-mesa', 4.65374000, -74.47316000),
(1143874, 1002875, 'CO', 'La Mesa', 1, 'la-mesa', 5.26666667, -73.91666667),
(1020995, 1002875, 'CO', 'La Palma', 1, 'la-palma', 5.31732000, -74.43003000),
(1020999, 1002875, 'CO', 'La Peña', 1, 'la-pena', 5.19847000, -74.39368000),
(1021012, 1002875, 'CO', 'La Vega', 1, 'la-vega', 4.97382000, -74.34476000),
(1021026, 1002875, 'CO', 'Lenguazaque', 1, 'lenguazaque', 5.30711000, -73.71152000),
(1021045, 1002875, 'CO', 'Macheta', 1, 'macheta', 5.08333000, -73.61667000),
(1021046, 1002875, 'CO', 'Machetá', 1, 'macheta', 5.08154000, -73.60761000),
(1021047, 1002875, 'CO', 'Madrid', 1, 'madrid', 4.75564000, -74.27708000),
(1021060, 1002875, 'CO', 'Manta', 1, 'manta', 4.95720000, -73.58583000),
(1021075, 1002875, 'CO', 'Medina', 1, 'medina', 4.51005000, -73.34982000),
(1021109, 1002875, 'CO', 'Mosquera', 1, 'mosquera', 4.68935000, -74.23599000),
(1021127, 1002875, 'CO', 'Nariño', 1, 'narino', 4.39913000, -74.82239000),
(1021132, 1002875, 'CO', 'Nemocón', 1, 'nemocon', 5.06767000, -73.87769000),
(1021133, 1002875, 'CO', 'Nilo', 1, 'nilo', 4.30604000, -74.62083000),
(1021134, 1002875, 'CO', 'Nimaima', 1, 'nimaima', 5.12614000, -74.38495000),
(1021136, 1002875, 'CO', 'Nocaima', 1, 'nocaima', 5.06696000, -74.38439000),
(1021165, 1002875, 'CO', 'Paime', 1, 'paime', 5.37054000, -74.15219000),
(1021179, 1002875, 'CO', 'Pandi', 1, 'pandi', 4.18032000, -74.47099000),
(1021182, 1002875, 'CO', 'Paratebueno', 1, 'paratebueno', 4.37575000, -73.21547000),
(1021183, 1002875, 'CO', 'Pasca', 1, 'pasca', 4.30722000, -74.30056000),
(1021235, 1002875, 'CO', 'Puerto Bogotá', 1, 'puerto-bogota', 5.19994000, -74.72733000),
(1021254, 1002875, 'CO', 'Puerto Salgar', 1, 'puerto-salgar', 5.61892000, -74.58483000),
(1021261, 1002875, 'CO', 'Pulí', 1, 'puli', 4.68116000, -74.71406000),
(1021270, 1002875, 'CO', 'Quebradanegra', 1, 'quebradanegra', 5.08262000, -74.52117000),
(1021271, 1002875, 'CO', 'Quetame', 1, 'quetame', 4.33234000, -73.86141000),
(1021275, 1002875, 'CO', 'Quipile', 1, 'quipile', 4.74517000, -74.53378000),
(1021287, 1002875, 'CO', 'Ricaurte', 1, 'ricaurte', 4.28075000, -74.76469000),
(1021338, 1002875, 'CO', 'San Antonio del Tequendama', 1, 'san-antonio-del-tequendama', 4.61667000, -74.35000000),
(1021342, 1002875, 'CO', 'San Bernardo', 1, 'san-bernardo', 4.12956000, -74.35903000),
(1021348, 1002875, 'CO', 'San Cayetano', 1, 'san-cayetano', 5.31693000, -74.07141000),
(1021358, 1002875, 'CO', 'San Francisco', 1, 'san-francisco', 4.96335000, -74.26613000),
(1021375, 1002875, 'CO', 'San Juan de Río Seco', 1, 'san-juan-de-rio-seco', 4.83077000, -74.68248000),
(1021446, 1002875, 'CO', 'Sasaima', 1, 'sasaima', 4.96705000, -74.43512000),
(1021450, 1002875, 'CO', 'Sesquilé', 1, 'sesquile', 5.04463000, -73.79724000),
(1021453, 1002875, 'CO', 'Sibaté', 1, 'sibate', 4.49154000, -74.25957000),
(1021456, 1002875, 'CO', 'Silvania', 1, 'silvania', 4.40367000, -74.38670000),
(1021459, 1002875, 'CO', 'Simijaca', 1, 'simijaca', 5.50415000, -73.86944000),
(1021464, 1002875, 'CO', 'Soacha', 1, 'soacha', 4.57937000, -74.21682000),
(1021478, 1002875, 'CO', 'Sopó', 1, 'sopo', 4.90750000, -73.93840000),
(1021486, 1002875, 'CO', 'Subachoque', 1, 'subachoque', 4.92614000, -74.17299000),
(1021490, 1002875, 'CO', 'Suesca', 1, 'suesca', 5.10289000, -73.79845000),
(1021491, 1002875, 'CO', 'Supatá', 1, 'supata', 5.06097000, -74.23721000),
(1021494, 1002875, 'CO', 'Susa', 1, 'susa', 5.42700000, -73.84786000),
(1021497, 1002875, 'CO', 'Sutatausa', 1, 'sutatausa', 5.24779000, -73.85238000),
(1021503, 1002875, 'CO', 'Tabio', 1, 'tabio', 4.91726000, -74.09364000),
(1021517, 1002875, 'CO', 'Tausa', 1, 'tausa', 5.19903000, -73.89128000),
(1021518, 1002875, 'CO', 'Tena', 1, 'tena', 4.66001000, -74.39258000),
(1021520, 1002875, 'CO', 'Tenjo', 1, 'tenjo', 4.87270000, -74.14435000),
(1143875, 1002875, 'CO', 'Tibacuy', 1, 'tibacuy', 4.35111111, -72.45638889),
(1021522, 1002875, 'CO', 'Tibacuy', 1, 'tibacuy', 4.30606000, -74.51639000),
(1021525, 1002875, 'CO', 'Tibirita', 1, 'tibirita', 5.05227000, -73.50459000),
(1021534, 1002875, 'CO', 'Tocaima', 1, 'tocaima', 4.46073000, -74.65722000),
(1021535, 1002875, 'CO', 'Tocancipá', 1, 'tocancipa', 4.96531000, -73.91301000),
(1021541, 1002875, 'CO', 'Topaipí', 1, 'topaipi', 5.33457000, -74.30292000),
(1021565, 1002875, 'CO', 'Ubalá', 1, 'ubala', 4.74778000, -72.53694000),
(1021566, 1002875, 'CO', 'Ubaque', 1, 'ubaque', 4.48667000, -73.93748000),
(1021569, 1002875, 'CO', 'Une', 1, 'une', 4.30691000, -74.07104000),
(1143876, 1002875, 'CO', 'Útica', 1, 'utica', 5.18861111, -74.48111111),
(1021640, 1002875, 'CO', 'Útica', 1, 'utica', 5.16977000, -74.50134000),
(1021587, 1002875, 'CO', 'Venecia', 1, 'venecia', 4.08808000, -74.47746000),
(1021590, 1002875, 'CO', 'Vergara', 1, 'vergara', 5.13600000, -74.31539000),
(1021593, 1002875, 'CO', 'Vianí', 1, 'viani', 4.89579000, -74.55398000),
(1021599, 1002875, 'CO', 'Villa de San Diego de Ubate', 1, 'villa-de-san-diego-de-ubate', 5.31544000, -73.82045000),
(1021600, 1002875, 'CO', 'Villa de San Diego de Ubaté', 1, 'villa-de-san-diego-de-ubate', 5.30933000, -73.81575000),
(1021603, 1002875, 'CO', 'Villagómez', 1, 'villagomez', 5.27372000, -74.19614000),
(1021610, 1002875, 'CO', 'Villapinzón', 1, 'villapinzon', 5.21617000, -73.59490000),
(1021613, 1002875, 'CO', 'Villeta', 1, 'villeta', 5.00008000, -74.50498000),
(1021614, 1002875, 'CO', 'Viotá', 1, 'viota', 4.43713000, -74.52157000),
(1021619, 1002875, 'CO', 'Yacopí', 1, 'yacopi', 5.45948000, -74.33823000),
(1021635, 1002875, 'CO', 'Zipacón', 1, 'zipacon', 4.75881000, -74.38017000),
(1021636, 1002875, 'CO', 'Zipaquirá', 1, 'zipaquira', 5.02208000, -74.00481000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002882, 'CO', 'Guainía Department', 1, 'guainia-department');

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 
(1020572, 1002882, 'CO', 'Barranco Minas', 1, 'barranco-minas', 3.09899000, -69.58297000),
(1020618, 1002882, 'CO', 'Cacahual', 1, 'cacahual', 3.32533000, -67.62397000),
(1020949, 1002882, 'CO', 'Inírida', 1, 'inirida', 3.86528000, -67.92389000),
(1020986, 1002882, 'CO', 'La Guadalupe', 1, 'la-guadalupe', 1.39579000, -67.00150000),
(1021063, 1002882, 'CO', 'Mapiripana', 1, 'mapiripana', 2.81003000, -70.28568000),
(1021106, 1002882, 'CO', 'Morichal', 1, 'morichal', 2.42980000, -69.83284000),
(1021178, 1002882, 'CO', 'Pana Pana', 1, 'pana-pana', 1.96249000, -69.12600000),
(1021239, 1002882, 'CO', 'Puerto Colombia', 1, 'puerto-colombia', 2.43903000, -68.16419000),
(1021354, 1002882, 'CO', 'San Felipe', 1, 'san-felipe', 2.14321000, -67.34122000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002888, 'CO', 'Guaviare Department', 1, 'guaviare-department');

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 
(1020627, 1002888, 'CO', 'Calamar', 1, 'calamar', 1.95960000, -72.65315000),
(1020823, 1002888, 'CO', 'El Retorno', 1, 'el-retorno', 2.33022000, -72.62765000),
(1021083, 1002888, 'CO', 'Miraflores', 1, 'miraflores', 1.33667000, -71.95111000),
(1021370, 1002888, 'CO', 'San José del Guaviare', 1, 'san-jose-del-guaviare', 2.57286000, -72.64591000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004871, 'CO', 'Huila Department', 1, 'huila-department');

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 
(1143877, 1004871, 'CO', 'Acevedo', 1, 'acevedo', 1.83611111, -75.85500000),
(1143878, 1004871, 'CO', 'Aipe', 1, 'aipe', 3.22194444, -75.23750000),
(1143879, 1004871, 'CO', 'Algeciras', 1, 'algeciras', 2.52194444, -75.31444444),
(1143880, 1004871, 'CO', 'Altamira', 1, 'altamira', 2.06333333, -75.78777778),
(1143881, 1004871, 'CO', 'Baraya', 1, 'baraya', 3.15305556, -75.05250000),
(1143882, 1004871, 'CO', 'Campoalegre', 1, 'campoalegre', 2.68666667, -75.32555556),
(1143883, 1004871, 'CO', 'Colombia', 1, 'colombia', 3.37500000, -74.80194444),
(1143884, 1004871, 'CO', 'El Agrado', 1, 'el-agrado', 2.25833056, -75.77250000),
(1143885, 1004871, 'CO', 'Elias', 1, 'elias', 2.01361111, -75.93972222),
(1143886, 1004871, 'CO', 'Garzón', 1, 'garzon', 2.19611111, -75.62916667),
(1143887, 1004871, 'CO', 'Gigante', 1, 'gigante', 2.38666944, -75.54610000),
(1143888, 1004871, 'CO', 'Guadalupe', 1, 'guadalupe', 2.02500000, -75.75638889),
(1143889, 1004871, 'CO', 'Hobo', 1, 'hobo', 2.58250000, -75.45111111),
(1143890, 1004871, 'CO', 'Iquira', 1, 'iquira', 2.64833333, -75.63638889),
(1143891, 1004871, 'CO', 'Isnos', 1, 'isnos', 1.92888889, -76.21583333),
(1143892, 1004871, 'CO', 'La Plata', 1, 'la-plata', 2.39000000, -75.89194444),
(1143893, 1004871, 'CO', 'Nataga', 1, 'nataga', 2.54388889, -75.80861111),
(1143894, 1004871, 'CO', 'Neiva', 1, 'neiva', 2.92750000, -75.28750000),
(1143895, 1004871, 'CO', 'Oporapa', 1, 'oporapa', 2.02305556, -75.99527778),
(1143896, 1004871, 'CO', 'Paicol', 1, 'paicol', 2.44972222, -75.77388889),
(1143897, 1004871, 'CO', 'Palermo', 1, 'palermo', 2.88833333, -75.43388889),
(1143898, 1004871, 'CO', 'Palestina', 1, 'palestina', 1.72250000, -76.13055556),
(1143899, 1004871, 'CO', 'Pital', 1, 'pital', 2.26638889, -75.80444444),
(1143900, 1004871, 'CO', 'Pitalito', 1, 'pitalito', 1.85388889, -76.05138889),
(1143901, 1004871, 'CO', 'Rivera', 1, 'rivera', 2.77722222, -75.25638889),
(1143902, 1004871, 'CO', 'Saladoblanco', 1, 'saladoblanco', 1.99333333, -76.04527778),
(1143903, 1004871, 'CO', 'San Agustín', 1, 'san-agustin', 1.87916667, -76.26833333),
(1143904, 1004871, 'CO', 'Santa María', 1, 'santa-maria', 2.93777778, -75.58694444),
(1143905, 1004871, 'CO', 'Suaza', 1, 'suaza', 1.97500000, -75.79555556),
(1143906, 1004871, 'CO', 'Tarqui', 1, 'tarqui', 2.11055556, -75.82305556),
(1143907, 1004871, 'CO', 'Tello', 1, 'tello', 3.06666667, -75.13861111),
(1143908, 1004871, 'CO', 'Teruel', 1, 'teruel', 2.74055556, -75.56833333),
(1143909, 1004871, 'CO', 'Tesalia', 1, 'tesalia', 2.48472222, -75.73000000),
(1143910, 1004871, 'CO', 'Timana', 1, 'timana', 1.97136000, -75.93123000),
(1143911, 1004871, 'CO', 'Villavieja', 1, 'villavieja', 3.21888889, -75.21833333),
(1143912, 1004871, 'CO', 'Yaguará', 1, 'yaguara', 2.66361111, -75.51750000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002889, 'CO', 'La Guajira Department', 1, 'la-guajira-department');

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 
(1020498, 1002889, 'CO', 'Albania', 1, 'albania', 11.16099000, -72.59238000),
(1020571, 1002889, 'CO', 'Barrancas', 1, 'barrancas', 10.97180000, -72.69115000),
(1020776, 1002889, 'CO', 'Dibulla', 1, 'dibulla', 11.27251000, -73.30911000),
(1020777, 1002889, 'CO', 'Distracción', 1, 'distraccion', 10.89784000, -72.88666000),
(1020812, 1002889, 'CO', 'El Molino', 1, 'el-molino', 10.65296000, -72.92461000),
(1020855, 1002889, 'CO', 'Fonseca', 1, 'fonseca', 10.82966000, -72.79778000),
(1020938, 1002889, 'CO', 'Hatonuevo', 1, 'hatonuevo', 11.06940000, -72.76690000),
(1020988, 1002889, 'CO', 'La Jagua del Pilar', 1, 'la-jagua-del-pilar', 10.51061000, -73.07178000),
(1021051, 1002889, 'CO', 'Maicao', 1, 'maicao', 11.37837000, -72.23950000),
(1021056, 1002889, 'CO', 'Manaure', 1, 'manaure', 11.77505000, -72.44447000),
(1021291, 1002889, 'CO', 'Riohacha', 1, 'riohacha', 11.54444000, -72.90722000),
(1021377, 1002889, 'CO', 'San Juan del Cesar', 1, 'san-juan-del-cesar', 10.77107000, -73.00314000),
(1021573, 1002889, 'CO', 'Uribia', 1, 'uribia', 12.02638000, -71.74887000),
(1021575, 1002889, 'CO', 'Urumita', 1, 'urumita', 10.55894000, -73.01232000),
(1021608, 1002889, 'CO', 'Villanueva', 1, 'villanueva', 10.58333000, -72.96077000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002886, 'CO', 'Magdalena Department', 1, 'magdalena-department');

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 
(1020505, 1002886, 'CO', 'Algarrobo', 1, 'algarrobo', 10.18553000, -74.06158000),
(1020533, 1002886, 'CO', 'Aracataca', 1, 'aracataca', 10.59181000, -74.18983000),
(1020548, 1002886, 'CO', 'Ariguaní', 1, 'ariguani', 9.89383000, -74.13583000),
(1020606, 1002886, 'CO', 'Buenavista', 1, 'buenavista', 9.21433000, -74.31363000),
(1020673, 1002886, 'CO', 'Cerro de San Antonio', 1, 'cerro-de-san-antonio', 10.32585000, -74.86933000),
(1020672, 1002886, 'CO', 'Cerro San Antonio', 1, 'cerro-san-antonio', 10.29063000, -74.82173000),
(1020681, 1002886, 'CO', 'Chibolo', 1, 'chibolo', 10.08250000, -74.50696000),
(1020700, 1002886, 'CO', 'Chivolo', 1, 'chivolo', 10.02502000, -74.62279000),
(1020712, 1002886, 'CO', 'Ciénaga', 1, 'cienaga', 10.83333000, -74.08333000),
(1020726, 1002886, 'CO', 'Concordia', 1, 'concordia', 9.83545000, -74.45548000),
(1020787, 1002886, 'CO', 'El Banco', 1, 'el-banco', 9.00114000, -73.97581000),
(1020820, 1002886, 'CO', 'El Piñon', 1, 'el-pinon', 10.33333000, -74.66667000),
(1020821, 1002886, 'CO', 'El Piñón', 1, 'el-pinon', 10.40283000, -74.82415000),
(1020824, 1002886, 'CO', 'El Retén', 1, 'el-reten', 10.61135000, -74.26824000),
(1020864, 1002886, 'CO', 'Fundación', 1, 'fundacion', 10.52066000, -74.18504000),
(1020907, 1002886, 'CO', 'Guamal', 1, 'guamal', 9.14334000, -74.22384000),
(1021139, 1002886, 'CO', 'Nueva Granada', 1, 'nueva-granada', 9.80168000, -74.39304000),
(1021191, 1002886, 'CO', 'Pedraza', 1, 'pedraza', 10.18739000, -74.91504000),
(1021205, 1002886, 'CO', 'Pijiño del Carmen', 1, 'pijino-del-carmen', 9.32908000, -74.45302000),
(1021210, 1002886, 'CO', 'Pivijay', 1, 'pivijay', 10.46167000, -74.61621000),
(1021214, 1002886, 'CO', 'Plato', 1, 'plato', 9.77267000, -74.74548000),
(1021228, 1002886, 'CO', 'Puebloviejo', 1, 'puebloviejo', 10.84239000, -74.38538000),
(1021282, 1002886, 'CO', 'Remolino', 1, 'remolino', 10.65048000, -74.58442000),
(1021313, 1002886, 'CO', 'Sabanas de San Angel', 1, 'sabanas-de-san-angel', 10.11072000, -74.26007000),
(1021318, 1002886, 'CO', 'Salamina', 1, 'salamina', 10.49027000, -74.79463000),
(1021336, 1002886, 'CO', 'San Antonio', 1, 'san-antonio', 9.93303000, -74.69346000),
(1021409, 1002886, 'CO', 'San Zenón', 1, 'san-zenon', 9.32686000, -74.32914000),
(1021411, 1002886, 'CO', 'Santa Ana', 1, 'santa-ana', 9.51484000, -74.34330000),
(1021415, 1002886, 'CO', 'Santa Bárbara de Pinto', 1, 'santa-barbara-de-pinto', 9.52107000, -74.64912000),
(1021421, 1002886, 'CO', 'Santa Marta', 1, 'santa-marta', 11.24348000, -74.20835000),
(1021463, 1002886, 'CO', 'Sitionuevo', 1, 'sitionuevo', 10.77737000, -74.72049000),
(1021519, 1002886, 'CO', 'Tenerife', 1, 'tenerife', 9.93201000, -74.73465000),
(1021631, 1002886, 'CO', 'Zapayán', 1, 'zapayan', 10.11846000, -74.69143000),
(1021637, 1002886, 'CO', 'Zona Bananera', 1, 'zona-bananera', 10.76417000, -74.15722000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002878, 'CO', 'Meta', 1, 'meta');

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 
(1020488, 1002878, 'CO', 'Acacías', 1, 'acacias', 3.98695000, -73.75797000),
(1020569, 1002878, 'CO', 'Barranca de Upía', 1, 'barranca-de-upia', 4.56963000, -72.96676000),
(1020617, 1002878, 'CO', 'Cabuyaro', 1, 'cabuyaro', 4.28170000, -72.79399000),
(1020665, 1002878, 'CO', 'Castilla la Nueva', 1, 'castilla-la-nueva', 3.82722000, -73.68831000),
(1020749, 1002878, 'CO', 'Cubarral', 1, 'cubarral', 3.79536000, -73.84063000),
(1020754, 1002878, 'CO', 'Cumaral', 1, 'cumaral', 4.23814000, -73.34101000),
(1020790, 1002878, 'CO', 'El Calvario', 1, 'el-calvario', 4.35426000, -73.74431000),
(1020799, 1002878, 'CO', 'El Castillo', 1, 'el-castillo', 3.56363000, -73.79488000),
(1020863, 1002878, 'CO', 'Fuente de Oro', 1, 'fuente-de-oro', 3.46263000, -73.62162000),
(1020894, 1002878, 'CO', 'Granada', 1, 'granada', 3.54625000, -73.70687000),
(1020906, 1002878, 'CO', 'Guamal', 1, 'guamal', 3.88043000, -73.76566000),
(1020990, 1002878, 'CO', 'La Macarena', 1, 'la-macarena', 2.00702000, -74.07320000),
(1021025, 1002878, 'CO', 'Lejanías', 1, 'lejanias', 3.52762000, -74.02335000),
(1021064, 1002878, 'CO', 'Mapiripán', 1, 'mapiripan', 2.89115000, -72.13328000),
(1021081, 1002878, 'CO', 'Mesetas', 1, 'mesetas', 3.38463000, -74.04424000),
(1021240, 1002878, 'CO', 'Puerto Concordia', 1, 'puerto-concordia', 2.62206000, -72.75724000),
(1021242, 1002878, 'CO', 'Puerto Gaitán', 1, 'puerto-gaitan', 4.31328000, -72.08157000),
(1021246, 1002878, 'CO', 'Puerto Lleras', 1, 'puerto-lleras', 3.21794000, -73.23215000),
(1021247, 1002878, 'CO', 'Puerto López', 1, 'puerto-lopez', 4.04426000, -72.65731000),
(1021252, 1002878, 'CO', 'Puerto Rico', 1, 'puerto-rico', 2.78273000, -73.13956000),
(1021260, 1002878, 'CO', 'Puerto Yuca', 1, 'puerto-yuca', 2.93833000, -73.20833000),
(1021284, 1002878, 'CO', 'Restrepo', 1, 'restrepo', 4.25833000, -73.56142000),
(1021347, 1002878, 'CO', 'San Carlos de Guaroa', 1, 'san-carlos-de-guaroa', 3.71161000, -73.24344000),
(1021373, 1002878, 'CO', 'San Juan de Arama', 1, 'san-juan-de-arama', 3.29034000, -73.82065000),
(1021385, 1002878, 'CO', 'San Martín', 1, 'san-martin', 3.50819000, -73.03975000),
(1021612, 1002878, 'CO', 'Villavicencio', 1, 'villavicencio', 4.07424000, -73.49150000),
(1021616, 1002878, 'CO', 'Vistahermosa', 1, 'vistahermosa', 3.12428000, -73.75156000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002897, 'CO', 'Nariño Department', 1, 'narino-department');

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 
(1020500, 1002897, 'CO', 'Albán', 1, 'alban', 1.47050000, -77.06846000),
(1020503, 1002897, 'CO', 'Aldana', 1, 'aldana', 0.88283000, -77.70103000),
(1020517, 1002897, 'CO', 'Ancuya', 1, 'ancuya', 1.26330000, -77.51376000),
(1020518, 1002897, 'CO', 'Ancuyá', 1, 'ancuya', 1.26538000, -77.53258000),
(1020539, 1002897, 'CO', 'Arboleda', 1, 'arboleda', 1.49830000, -77.13613000),
(1020565, 1002897, 'CO', 'Barbacoas', 1, 'barbacoas', 1.67154000, -78.13978000),
(1020582, 1002897, 'CO', 'Belén', 1, 'belen', 1.59477000, -77.05408000),
(1020611, 1002897, 'CO', 'Buesaco', 1, 'buesaco', 1.38364000, -77.15622000),
(1020653, 1002897, 'CO', 'Carlosama', 1, 'carlosama', 0.86292000, -77.72734000),
(1020662, 1002897, 'CO', 'Cartago', 1, 'cartago', 1.55151000, -77.11948000),
(1020674, 1002897, 'CO', 'Chachagüí', 1, 'chachagui', 1.35943000, -77.28367000),
(1020722, 1002897, 'CO', 'Colón', 1, 'colon', 1.62850000, -77.02927000),
(1020730, 1002897, 'CO', 'Consaca', 1, 'consaca', 1.20841000, -77.46323000),
(1020731, 1002897, 'CO', 'Consacá', 1, 'consaca', 1.20805000, -77.46548000),
(1020732, 1002897, 'CO', 'Contadero', 1, 'contadero', 0.93072000, -77.53333000),
(1020769, 1002897, 'CO', 'Córdoba', 1, 'cordoba', 0.85362000, -77.51817000),
(1020748, 1002897, 'CO', 'Cuaspud', 1, 'cuaspud', 0.87570000, -77.73640000),
(1020756, 1002897, 'CO', 'Cumbal', 1, 'cumbal', 0.90875000, -77.79145000),
(1020757, 1002897, 'CO', 'Cumbitara', 1, 'cumbitara', 1.64786000, -77.57819000),
(1020801, 1002897, 'CO', 'El Charco', 1, 'el-charco', 2.47926000, -78.10972000),
(1020816, 1002897, 'CO', 'El Peñol', 1, 'el-penol', 1.45365000, -77.44017000),
(1020827, 1002897, 'CO', 'El Rosario', 1, 'el-rosario', 1.84593000, -77.40620000),
(1020829, 1002897, 'CO', 'El Tablón', 1, 'el-tablon', 1.42717000, -77.09693000),
(1020830, 1002897, 'CO', 'El Tablón de Gómez', 1, 'el-tablon-de-gomez', 1.41201000, -76.98526000),
(1020832, 1002897, 'CO', 'El Tambo', 1, 'el-tambo', 1.43049000, -77.38326000),
(1020858, 1002897, 'CO', 'Francisco Pizarro', 1, 'francisco-pizarro', 2.14713000, -78.58883000),
(1020865, 1002897, 'CO', 'Funes', 1, 'funes', 1.00075000, -77.44918000),
(1020929, 1002897, 'CO', 'Génova', 1, 'genova', 1.64367000, -77.01924000),
(1020899, 1002897, 'CO', 'Guachucal', 1, 'guachucal', 0.96093000, -77.73161000),
(1020904, 1002897, 'CO', 'Guaitarilla', 1, 'guaitarilla', 1.13103000, -77.54815000),
(1020905, 1002897, 'CO', 'Gualmatán', 1, 'gualmatan', 0.91992000, -77.56738000),
(1020946, 1002897, 'CO', 'Iles', 1, 'iles', 0.97040000, -77.52146000),
(1020947, 1002897, 'CO', 'Imués', 1, 'imues', 1.05516000, -77.49669000),
(1020950, 1002897, 'CO', 'Ipiales', 1, 'ipiales', 0.82501000, -77.63966000),
(1020951, 1002897, 'CO', 'Iscuandé', 1, 'iscuande', 2.45065000, -77.97998000),
(1020978, 1002897, 'CO', 'La Cruz', 1, 'la-cruz', 1.60221000, -76.97130000),
(1020984, 1002897, 'CO', 'La Florida', 1, 'la-florida', 1.35693000, -77.41271000),
(1020989, 1002897, 'CO', 'La Llanada', 1, 'la-llanada', 1.47310000, -77.58024000),
(1021005, 1002897, 'CO', 'La Tola', 1, 'la-tola', 2.39949000, -78.18923000),
(1021008, 1002897, 'CO', 'La Unión', 1, 'la-union', 1.60450000, -77.13152000),
(1021024, 1002897, 'CO', 'Leiva', 1, 'leiva', 1.93497000, -77.30634000),
(1021029, 1002897, 'CO', 'Linares', 1, 'linares', 1.35078000, -77.52339000),
(1021032, 1002897, 'CO', 'Los Andes', 1, 'los-andes', 1.62831000, -77.67959000),
(1021049, 1002897, 'CO', 'Magüi', 1, 'magui', 1.90504000, -78.04916000),
(1021054, 1002897, 'CO', 'Mallama', 1, 'mallama', 1.15887000, -77.84688000),
(1021108, 1002897, 'CO', 'Mosquera', 1, 'mosquera', 2.49139000, -78.44307000),
(1021125, 1002897, 'CO', 'Nariño', 1, 'narino', 1.28995000, -77.35721000),
(1021150, 1002897, 'CO', 'Olaya Herrera', 1, 'olaya-herrera', 1.24803000, -77.49085000),
(1021155, 1002897, 'CO', 'Ospina', 1, 'ospina', 1.02962000, -77.55252000),
(1021184, 1002897, 'CO', 'Pasto', 1, 'pasto', 1.21467000, -77.27865000),
(1021189, 1002897, 'CO', 'Payán', 1, 'payan', 1.76645000, -78.18326000),
(1021200, 1002897, 'CO', 'Piedrancha', 1, 'piedrancha', 1.14109000, -77.86479000),
(1021216, 1002897, 'CO', 'Policarpa', 1, 'policarpa', 1.62843000, -77.45956000),
(1021221, 1002897, 'CO', 'Potosí', 1, 'potosi', 0.80739000, -77.57216000),
(1021230, 1002897, 'CO', 'Puerres', 1, 'puerres', 1.19374000, -77.26661000),
(1021262, 1002897, 'CO', 'Pupiales', 1, 'pupiales', 0.87136000, -77.64027000),
(1021288, 1002897, 'CO', 'Ricaurte', 1, 'ricaurte', 1.21474000, -77.99801000),
(1021297, 1002897, 'CO', 'Roberto Payán', 1, 'roberto-payan', 1.91757000, -78.38191000),
(1021317, 1002897, 'CO', 'Salahonda', 1, 'salahonda', 2.04060000, -78.65877000),
(1021325, 1002897, 'CO', 'Samaniego', 1, 'samaniego', 1.33849000, -77.59570000),
(1021329, 1002897, 'CO', 'San Andres de Tumaco', 1, 'san-andres-de-tumaco', 1.63766000, -78.61218000),
(1021341, 1002897, 'CO', 'San Bernardo', 1, 'san-bernardo', 1.51525000, -77.04679000),
(1021365, 1002897, 'CO', 'San José', 1, 'san-jose', 1.69659000, -78.24482000),
(1021378, 1002897, 'CO', 'San Lorenzo', 1, 'san-lorenzo', 1.55731000, -77.24599000),
(1021392, 1002897, 'CO', 'San Pablo', 1, 'san-pablo', 1.67250000, -77.01389000),
(1021398, 1002897, 'CO', 'San Pedro de Cartago', 1, 'san-pedro-de-cartago', 1.55533000, -77.12984000),
(1021410, 1002897, 'CO', 'Sandoná', 1, 'sandona', 1.28626000, -77.46921000),
(1021413, 1002897, 'CO', 'Santa Bárbara', 1, 'santa-barbara', 2.30185000, -77.91487000),
(1021431, 1002897, 'CO', 'Santacruz', 1, 'santacruz', 1.52090000, -77.26206000),
(1021443, 1002897, 'CO', 'Sapuyes', 1, 'sapuyes', 1.03728000, -77.62094000),
(1021483, 1002897, 'CO', 'Sotomayor', 1, 'sotomayor', 1.49474000, -77.52136000),
(1021509, 1002897, 'CO', 'Taminango', 1, 'taminango', 1.57032000, -77.28043000),
(1021510, 1002897, 'CO', 'Tangua', 1, 'tangua', 1.09189000, -77.38645000),
(1021552, 1002897, 'CO', 'Tumaco', 1, 'tumaco', 1.79112000, -78.79275000),
(1021564, 1002897, 'CO', 'Túquerres', 1, 'tuquerres', 1.08647000, -77.61858000),
(1021620, 1002897, 'CO', 'Yacuanquer', 1, 'yacuanquer', 1.11577000, -77.40169000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002877, 'CO', 'Norte de Santander Department', 1, 'norte-de-santander-department');

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 
(1020486, 1002877, 'CO', 'Abrego', 1, 'abrego', 8.00000000, -73.20000000),
(1021638, 1002877, 'CO', 'Ábrego', 1, 'abrego', 8.08065000, -73.22054000),
(1020540, 1002877, 'CO', 'Arboledas', 1, 'arboledas', 7.63494000, -72.86050000),
(1020594, 1002877, 'CO', 'Bochalema', 1, 'bochalema', 7.60217000, -72.68839000),
(1020604, 1002877, 'CO', 'Bucarasica', 1, 'bucarasica', 8.04096000, -72.86538000),
(1020764, 1002877, 'CO', 'Cáchira', 1, 'cachira', 7.74104000, -73.04830000),
(1020620, 1002877, 'CO', 'Cachirá', 1, 'cachira', 7.75000000, -73.16667000),
(1020765, 1002877, 'CO', 'Cácota', 1, 'cacota', 7.26787000, -72.64197000),
(1020689, 1002877, 'CO', 'Chinácota', 1, 'chinacota', 7.60731000, -72.60108000),
(1020697, 1002877, 'CO', 'Chitagá', 1, 'chitaga', 7.13781000, -72.66456000),
(1020734, 1002877, 'CO', 'Convención', 1, 'convencion', 8.82242000, -73.22850000),
(1020772, 1002877, 'CO', 'Cúcuta', 1, 'cucuta', 7.89391000, -72.50782000),
(1020753, 1002877, 'CO', 'Cucutilla', 1, 'cucutilla', 7.53941000, -72.77238000),
(1020784, 1002877, 'CO', 'Durania', 1, 'durania', 7.71307000, -72.65759000),
(1020793, 1002877, 'CO', 'El Carmen', 1, 'el-carmen', 8.51064000, -73.44776000),
(1020833, 1002877, 'CO', 'El Tarra', 1, 'el-tarra', 8.57562000, -73.09489000),
(1020834, 1002877, 'CO', 'El Zulia', 1, 'el-zulia', 7.93248000, -72.60125000),
(1020891, 1002877, 'CO', 'Gramalote', 1, 'gramalote', 7.88752000, -72.79749000),
(1020934, 1002877, 'CO', 'Hacarí', 1, 'hacari', 8.32333000, -73.14889000),
(1020940, 1002877, 'CO', 'Herrán', 1, 'herran', 7.50611000, -72.48332000),
(1020982, 1002877, 'CO', 'La Esperanza', 1, 'la-esperanza', 8.21043000, -72.46399000),
(1021001, 1002877, 'CO', 'La Playa', 1, 'la-playa', 8.25833000, -73.19222000),
(1021017, 1002877, 'CO', 'Labateca', 1, 'labateca', 7.24558000, -72.55286000),
(1021035, 1002877, 'CO', 'Los Patios', 1, 'los-patios', 7.83793000, -72.50370000),
(1021037, 1002877, 'CO', 'Lourdes', 1, 'lourdes', 7.96774000, -72.84519000),
(1021122, 1002877, 'CO', 'Mutiscua', 1, 'mutiscua', 7.29810000, -72.79879000),
(1021146, 1002877, 'CO', 'Ocaña', 1, 'ocana', 8.23773000, -73.35604000),
(1021176, 1002877, 'CO', 'Pamplona', 1, 'pamplona', 7.37565000, -72.64795000),
(1021177, 1002877, 'CO', 'Pamplonita', 1, 'pamplonita', 7.45814000, -72.65965000),
(1021255, 1002877, 'CO', 'Puerto Santander', 1, 'puerto-santander', 8.36361000, -72.40630000),
(1021277, 1002877, 'CO', 'Ragonvalia', 1, 'ragonvalia', 7.57749000, -72.47574000),
(1021320, 1002877, 'CO', 'Salazar', 1, 'salazar', 7.78249000, -72.85741000),
(1021344, 1002877, 'CO', 'San Calixto', 1, 'san-calixto', 8.40210000, -73.20737000),
(1021349, 1002877, 'CO', 'San Cayetano', 1, 'san-cayetano', 7.84771000, -72.61014000),
(1021436, 1002877, 'CO', 'Santiago', 1, 'santiago', 7.86930000, -72.73753000),
(1021445, 1002877, 'CO', 'Sardinata', 1, 'sardinata', 8.08289000, -72.80071000),
(1021455, 1002877, 'CO', 'Silos', 1, 'silos', 7.20524000, -72.75639000),
(1021526, 1002877, 'CO', 'Tibú', 1, 'tibu', 8.63895000, -72.73583000),
(1021538, 1002877, 'CO', 'Toledo', 1, 'toledo', 7.30984000, -72.48295000),
(1021601, 1002877, 'CO', 'Villa del Rosario', 1, 'villa-del-rosario', 7.75816000, -72.48182000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002896, 'CO', 'Putumayo Department', 1, 'putumayo-department');

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 
(1020721, 1002896, 'CO', 'Colón', 1, 'colon', 1.19034000, -76.97369000),
(1020980, 1002896, 'CO', 'La Dorada', 1, 'la-dorada', 0.34314000, -76.91124000),
(1021023, 1002896, 'CO', 'Leguízamo', 1, 'leguizamo', 0.05683000, -75.05832000),
(1021089, 1002896, 'CO', 'Mocoa', 1, 'mocoa', 1.15284000, -76.65208000),
(1021152, 1002896, 'CO', 'Orito', 1, 'orito', 0.66749000, -76.87297000),
(1021233, 1002896, 'CO', 'Puerto Asís', 1, 'puerto-asis', 0.50514000, -76.49571000),
(1021243, 1002896, 'CO', 'Puerto Guzmán', 1, 'puerto-guzman', 0.97028000, -76.58583000),
(1021244, 1002896, 'CO', 'Puerto Leguízamo', 1, 'puerto-leguizamo', -0.19337000, -74.78189000),
(1021356, 1002896, 'CO', 'San Francisco', 1, 'san-francisco', 1.17644000, -76.87838000),
(1021389, 1002896, 'CO', 'San Miguel', 1, 'san-miguel', 0.34300000, -76.91000000),
(1021435, 1002896, 'CO', 'Santiago', 1, 'santiago', 1.14844000, -77.00450000),
(1021454, 1002896, 'CO', 'Sibundoy', 1, 'sibundoy', 1.20296000, -76.92275000),
(1021581, 1002896, 'CO', 'Valle del Guamuez', 1, 'valle-del-guamuez', 0.45250000, -76.91917000),
(1021602, 1002896, 'CO', 'Villagarzón', 1, 'villagarzon', 0.89663000, -76.72794000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002874, 'CO', 'Quindío Department', 1, 'quindio-department');

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 
(1020550, 1002874, 'CO', 'Armenia', 1, 'armenia', 4.53307000, -75.70438000),
(1020607, 1002874, 'CO', 'Buenavista', 1, 'buenavista', 4.35969000, -75.73888000),
(1020629, 1002874, 'CO', 'Calarca', 1, 'calarca', 4.50000000, -75.63333000),
(1020630, 1002874, 'CO', 'Calarcá', 1, 'calarca', 4.52949000, -75.64091000),
(1020709, 1002874, 'CO', 'Circasia', 1, 'circasia', 4.59940000, -75.68536000),
(1020771, 1002874, 'CO', 'Córdoba', 1, 'cordoba', 4.38055000, -75.66685000),
(1020845, 1002874, 'CO', 'Filandia', 1, 'filandia', 4.67525000, -75.67142000),
(1020930, 1002874, 'CO', 'Génova', 1, 'genova', 4.22743000, -75.75480000),
(1021004, 1002874, 'CO', 'La Tebaida', 1, 'la-tebaida', 4.43353000, -75.81476000),
(1021100, 1002874, 'CO', 'Montenegro', 1, 'montenegro', 4.52676000, -75.82265000),
(1021204, 1002874, 'CO', 'Pijao', 1, 'pijao', 4.33350000, -75.70463000),
(1021273, 1002874, 'CO', 'Quimbaya', 1, 'quimbaya', 4.59342000, -75.83758000),
(1021322, 1002874, 'CO', 'Salento', 1, 'salento', 4.63643000, -75.56740000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002879, 'CO', 'Risaralda Department', 1, 'risaralda-department');

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 
(1020524, 1002879, 'CO', 'Anserma', 1, 'anserma', 5.33278000, -75.79111000),
(1020531, 1002879, 'CO', 'Apía', 1, 'apia', 5.10658000, -75.94244000),
(1020563, 1002879, 'CO', 'Balboa', 1, 'balboa', 4.92284000, -75.94030000),
(1020585, 1002879, 'CO', 'Belén de Umbría', 1, 'belen-de-umbria', 5.20087000, -75.86865000),
(1020782, 1002879, 'CO', 'Dosquebradas', 1, 'dosquebradas', 4.83916000, -75.66727000),
(1020926, 1002879, 'CO', 'Guática', 1, 'guatica', 5.31569000, -75.79826000),
(1020975, 1002879, 'CO', 'La Celia', 1, 'la-celia', 5.00332000, -76.00355000),
(1020991, 1002879, 'CO', 'La Merced', 1, 'la-merced', 5.40194000, -75.88472000),
(1021016, 1002879, 'CO', 'La Virginia', 1, 'la-virginia', 4.89972000, -75.88250000),
(1021070, 1002879, 'CO', 'Marsella', 1, 'marsella', 4.95238000, -75.75265000),
(1021087, 1002879, 'CO', 'Mistrató', 1, 'mistrato', 5.29622000, -75.88390000),
(1021195, 1002879, 'CO', 'Pereira', 1, 'pereira', 4.76896000, -75.72222000),
(1021226, 1002879, 'CO', 'Pueblo Rico', 1, 'pueblo-rico', 5.29453000, -76.06702000),
(1021274, 1002879, 'CO', 'Quinchía', 1, 'quinchia', 5.33957000, -75.73018000),
(1021424, 1002879, 'CO', 'Santa Rosa de Cabal', 1, 'santa-rosa-de-cabal', 4.86806000, -75.62139000),
(1021442, 1002879, 'CO', 'Santuario', 1, 'santuario', 5.05321000, -75.99060000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002901, 'CO', 'Santander Department', 1, 'santander-department');

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 
(1020493, 1002901, 'CO', 'Aguada', 1, 'aguada', 6.16019000, -73.52747000),
(1020497, 1002901, 'CO', 'Albania', 1, 'albania', 5.75894000, -73.91376000),
(1020535, 1002901, 'CO', 'Aratoca', 1, 'aratoca', 6.69432000, -73.01868000),
(1020567, 1002901, 'CO', 'Barbosa', 1, 'barbosa', 5.93168000, -73.61507000),
(1020568, 1002901, 'CO', 'Barichara', 1, 'barichara', 6.63572000, -73.22282000),
(1020570, 1002901, 'CO', 'Barrancabermeja', 1, 'barrancabermeja', 7.06528000, -73.85472000),
(1020590, 1002901, 'CO', 'Betulia', 1, 'betulia', 6.90069000, -73.28347000),
(1020597, 1002901, 'CO', 'Bolívar', 1, 'bolivar', 5.98930000, -73.77058000),
(1020603, 1002901, 'CO', 'Bucaramanga', 1, 'bucaramanga', 7.12539000, -73.11980000),
(1020616, 1002901, 'CO', 'Cabrera', 1, 'cabrera', 6.56443000, -73.26768000),
(1020635, 1002901, 'CO', 'California', 1, 'california', 7.34340000, -72.95815000),
(1020647, 1002901, 'CO', 'Capitanejo', 1, 'capitanejo', 6.52881000, -72.69595000),
(1020651, 1002901, 'CO', 'Carcasí', 1, 'carcasi', 6.62711000, -72.62625000),
(1020668, 1002901, 'CO', 'Cepitá', 1, 'cepita', 6.75427000, -72.97440000),
(1020671, 1002901, 'CO', 'Cerrito', 1, 'cerrito', 6.84315000, -72.69404000),
(1020679, 1002901, 'CO', 'Charalá', 1, 'charala', 6.17513000, -73.17587000),
(1020680, 1002901, 'CO', 'Charta', 1, 'charta', 7.28025000, -72.96782000),
(1020684, 1002901, 'CO', 'Chima', 1, 'chima', 6.36289000, -73.42534000),
(1020692, 1002901, 'CO', 'Chipatá', 1, 'chipata', 6.06196000, -73.63718000),
(1020708, 1002901, 'CO', 'Cimitarra', 1, 'cimitarra', 6.31419000, -73.94968000),
(1020725, 1002901, 'CO', 'Concepción', 1, 'concepcion', 6.76619000, -72.69400000),
(1020729, 1002901, 'CO', 'Confines', 1, 'confines', 6.34875000, -73.20990000),
(1020733, 1002901, 'CO', 'Contratación', 1, 'contratacion', 6.29005000, -73.47354000),
(1020738, 1002901, 'CO', 'Coromoro', 1, 'coromoro', 6.29461000, -73.04022000),
(1020760, 1002901, 'CO', 'Curití', 1, 'curiti', 6.60519000, -73.06809000),
(1020797, 1002901, 'CO', 'El Carmen de Chucurí', 1, 'el-carmen-de-chucuri', 6.69736000, -73.51117000),
(1020809, 1002901, 'CO', 'El Guacamayo', 1, 'el-guacamayo', 6.24856000, -73.52957000),
(1020819, 1002901, 'CO', 'El Peñón', 1, 'el-penon', 6.09900000, -73.92835000),
(1020822, 1002901, 'CO', 'El Playón', 1, 'el-playon', 7.47131000, -73.20310000),
(1020836, 1002901, 'CO', 'Encino', 1, 'encino', 6.13735000, -73.09847000),
(1020837, 1002901, 'CO', 'Enciso', 1, 'enciso', 6.64651000, -72.70709000),
(1020853, 1002901, 'CO', 'Florián', 1, 'florian', 5.80487000, -73.97029000),
(1020852, 1002901, 'CO', 'Floridablanca', 1, 'floridablanca', 7.06315000, -73.08586000),
(1020878, 1002901, 'CO', 'Galán', 1, 'galan', 6.66271000, -73.34233000),
(1020881, 1002901, 'CO', 'Gambita', 1, 'gambita', 5.90273000, -73.36788000),
(1020927, 1002901, 'CO', 'Gámbita', 1, 'gambita', 5.94597000, -73.34435000),
(1020889, 1002901, 'CO', 'Girón', 1, 'giron', 7.06820000, -73.16981000),
(1020895, 1002901, 'CO', 'Guaca', 1, 'guaca', 6.87621000, -72.85594000),
(1020902, 1002901, 'CO', 'Guadalupe', 1, 'guadalupe', 6.24640000, -73.41833000),
(1020910, 1002901, 'CO', 'Guapotá', 1, 'guapota', 6.30697000, -73.32848000),
(1020919, 1002901, 'CO', 'Guavatá', 1, 'guavata', 5.95502000, -73.70018000),
(1020932, 1002901, 'CO', 'Güepsa', 1, 'guepsa', 6.02505000, -73.57313000),
(1020936, 1002901, 'CO', 'Hato', 1, 'hato', 6.56113000, -73.35895000),
(1020964, 1002901, 'CO', 'Jesús María', 1, 'jesus-maria', 5.87715000, -73.78097000),
(1020965, 1002901, 'CO', 'Jordán', 1, 'jordan', 6.69857000, -73.10966000),
(1020971, 1002901, 'CO', 'La Belleza', 1, 'la-belleza', 5.86371000, -73.96167000),
(1020996, 1002901, 'CO', 'La Paz', 1, 'la-paz', 6.17848000, -73.58948000),
(1021019, 1002901, 'CO', 'Landázuri', 1, 'landazuri', 6.21826000, -73.81121000),
(1021021, 1002901, 'CO', 'Lebrija', 1, 'lebrija', 7.11317000, -73.21780000),
(1021022, 1002901, 'CO', 'Lebríja', 1, 'lebrija', 7.19714000, -73.31566000),
(1021036, 1002901, 'CO', 'Los Santos', 1, 'los-santos', 6.79734000, -73.12490000),
(1021043, 1002901, 'CO', 'Macaravita', 1, 'macaravita', 6.50567000, -72.59299000),
(1021124, 1002901, 'CO', 'Málaga', 1, 'malaga', 6.69903000, -72.73233000),
(1021073, 1002901, 'CO', 'Matanza', 1, 'matanza', 7.35605000, -73.05303000),
(1021090, 1002901, 'CO', 'Mogotes', 1, 'mogotes', 6.47559000, -72.97046000),
(1021091, 1002901, 'CO', 'Molagavita', 1, 'molagavita', 6.67315000, -72.80875000),
(1021145, 1002901, 'CO', 'Ocamonte', 1, 'ocamonte', 6.34001000, -73.12205000),
(1021147, 1002901, 'CO', 'Oiba', 1, 'oiba', 6.26387000, -73.29876000),
(1021151, 1002901, 'CO', 'Onzaga', 1, 'onzaga', 6.34434000, -72.81726000),
(1021170, 1002901, 'CO', 'Palmar', 1, 'palmar', 6.49740000, -73.30740000),
(1021172, 1002901, 'CO', 'Palmas del Socorro', 1, 'palmas-del-socorro', 6.40756000, -73.28824000),
(1021269, 1002901, 'CO', 'Páramo', 1, 'paramo', 6.43750000, -73.18027000),
(1021199, 1002901, 'CO', 'Piedecuesta', 1, 'piedecuesta', 6.97443000, -73.02284000),
(1021206, 1002901, 'CO', 'Pinchote', 1, 'pinchote', 6.53226000, -73.17309000),
(1021229, 1002901, 'CO', 'Puente Nacional', 1, 'puente-nacional', 5.87739000, -73.67810000),
(1021250, 1002901, 'CO', 'Puerto Parra', 1, 'puerto-parra', 6.65149000, -74.05734000),
(1021259, 1002901, 'CO', 'Puerto Wilches', 1, 'puerto-wilches', 7.34828000, -73.89601000),
(1021292, 1002901, 'CO', 'Rionegro', 1, 'rionegro', 7.50000000, -73.33333000),
(1021308, 1002901, 'CO', 'Sabana de Torres', 1, 'sabana-de-torres', 7.39150000, -73.49574000),
(1021332, 1002901, 'CO', 'San Andrés', 1, 'san-andres', 6.81148000, -72.84929000),
(1021339, 1002901, 'CO', 'San Benito', 1, 'san-benito', 6.10206000, -73.53753000),
(1021359, 1002901, 'CO', 'San Gil', 1, 'san-gil', 6.55952000, -73.13637000),
(1021363, 1002901, 'CO', 'San Joaquín', 1, 'san-joaquin', 6.46554000, -72.84852000),
(1021367, 1002901, 'CO', 'San José de Miranda', 1, 'san-jose-de-miranda', 6.63051000, -72.73155000),
(1021388, 1002901, 'CO', 'San Miguel', 1, 'san-miguel', 6.57583000, -72.64591000),
(1021408, 1002901, 'CO', 'San Vicente de Chucurí', 1, 'san-vicente-de-chucuri', 6.88100000, -73.40977000),
(1021412, 1002901, 'CO', 'Santa Bárbara', 1, 'santa-barbara', 6.99022000, -72.90700000),
(1021458, 1002901, 'CO', 'Simacota', 1, 'simacota', 6.44290000, -73.33688000),
(1021468, 1002901, 'CO', 'Socorro', 1, 'socorro', 6.45647000, -73.25502000),
(1021484, 1002901, 'CO', 'Suaita', 1, 'suaita', 6.08221000, -73.37008000),
(1021488, 1002901, 'CO', 'Sucre', 1, 'sucre', 5.96995000, -73.96629000),
(1021493, 1002901, 'CO', 'Suratá', 1, 'surata', 7.36633000, -72.98361000),
(1021540, 1002901, 'CO', 'Tona', 1, 'tona', 7.15727000, -72.96559000),
(1021579, 1002901, 'CO', 'Valle de San José', 1, 'valle-de-san-jose', 6.41984000, -73.12946000),
(1021618, 1002901, 'CO', 'Vélez', 1, 'velez', 6.23274000, -73.72582000),
(1021592, 1002901, 'CO', 'Vetas', 1, 'vetas', 7.30911000, -72.87122000),
(1021606, 1002901, 'CO', 'Villanueva', 1, 'villanueva', 6.67169000, -73.17421000),
(1021630, 1002901, 'CO', 'Zapatoca', 1, 'zapatoca', 6.81532000, -73.26768000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002902, 'CO', 'Sucre Department', 1, 'sucre-department');

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 
(1020623, 1002902, 'CO', 'Caimito', 1, 'caimito', 8.78834000, -75.13583000),
(1020676, 1002902, 'CO', 'Chalán', 1, 'chalan', 9.54765000, -75.31128000),
(1020719, 1002902, 'CO', 'Coloso', 1, 'coloso', 9.51176000, -75.36233000),
(1020720, 1002902, 'CO', 'Colosó', 1, 'coloso', 9.49477000, -75.35271000),
(1020739, 1002902, 'CO', 'Corozal', 1, 'corozal', 9.31847000, -75.29330000),
(1020744, 1002902, 'CO', 'Coveñas', 1, 'covenas', 9.40254000, -75.68029000),
(1020825, 1002902, 'CO', 'El Roble', 1, 'el-roble', 9.10193000, -75.19508000),
(1020877, 1002902, 'CO', 'Galeras', 1, 'galeras', 9.16095000, -75.04811000),
(1020912, 1002902, 'CO', 'Guaranda', 1, 'guaranda', 8.46746000, -74.53617000),
(1021007, 1002902, 'CO', 'La Unión', 1, 'la-union', 8.84965000, -75.27942000),
(1021034, 1002902, 'CO', 'Los Palmitos', 1, 'los-palmitos', 9.37899000, -75.26769000),
(1021052, 1002902, 'CO', 'Majagual', 1, 'majagual', 8.53500000, -74.71499000),
(1021107, 1002902, 'CO', 'Morroa', 1, 'morroa', 9.33348000, -75.30542000),
(1021157, 1002902, 'CO', 'Ovejas', 1, 'ovejas', 9.54083000, -75.18333000),
(1021174, 1002902, 'CO', 'Palmito', 1, 'palmito', 9.33667000, -75.56333000),
(1021327, 1002902, 'CO', 'Sampués', 1, 'sampues', 9.18361000, -75.38167000),
(1021340, 1002902, 'CO', 'San Benito Abad', 1, 'san-benito-abad', 8.78833000, -74.95666000),
(1021374, 1002902, 'CO', 'San Juan de Betulia', 1, 'san-juan-de-betulia', 9.27345000, -75.24103000),
(1021382, 1002902, 'CO', 'San Luis de Sincé', 1, 'san-luis-de-since', 9.24391000, -75.14675000),
(1021383, 1002902, 'CO', 'San Marcos', 1, 'san-marcos', 8.58333000, -75.16667000),
(1021391, 1002902, 'CO', 'San Onofre', 1, 'san-onofre', 9.73586000, -75.52626000),
(1021395, 1002902, 'CO', 'San Pedro', 1, 'san-pedro', 9.39560000, -75.06476000),
(1021438, 1002902, 'CO', 'Santiago de Tolú', 1, 'santiago-de-tolu', 9.52392000, -75.58139000),
(1021461, 1002902, 'CO', 'Sincelejo', 1, 'sincelejo', 9.30472000, -75.39778000),
(1021487, 1002902, 'CO', 'Sucre', 1, 'sucre', 8.81136000, -74.72084000),
(1021539, 1002902, 'CO', 'Tolú Viejo', 1, 'tolu-viejo', 9.45082000, -75.43864000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002883, 'CO', 'Tolima Department', 1, 'tolima-department');

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 
(1020508, 1002883, 'CO', 'Alpujarra', 1, 'alpujarra', 3.39222000, -74.93271000),
(1020511, 1002883, 'CO', 'Alvarado', 1, 'alvarado', 4.58826000, -74.97810000),
(1020514, 1002883, 'CO', 'Ambalema', 1, 'ambalema', 4.78405000, -74.76268000),
(1020515, 1002883, 'CO', 'Anaime', 1, 'anaime', 4.39639000, -75.44500000),
(1020528, 1002883, 'CO', 'Anzoátegui', 1, 'anzoategui', 4.62232000, -75.18046000),
(1020552, 1002883, 'CO', 'Armero', 1, 'armero', 4.98873000, -74.88130000),
(1020553, 1002883, 'CO', 'Armero-Guyabal', 1, 'armero-guyabal', 4.96701000, -74.90294000),
(1020556, 1002883, 'CO', 'Ataco', 1, 'ataco', 3.59147000, -75.38178000),
(1020624, 1002883, 'CO', 'Cajamarca', 1, 'cajamarca', 4.41667000, -75.50000000),
(1020639, 1002883, 'CO', 'Campo Alegre', 1, 'campo-alegre', 3.18917000, -75.70361000),
(1020654, 1002883, 'CO', 'Carmen de Apicalá', 1, 'carmen-de-apicala', 4.14725000, -74.72014000),
(1020664, 1002883, 'CO', 'Casabianca', 1, 'casabianca', 5.07959000, -75.12059000),
(1020678, 1002883, 'CO', 'Chaparral', 1, 'chaparral', 3.75000000, -75.58333000),
(1020682, 1002883, 'CO', 'Chicoral', 1, 'chicoral', 4.21536000, -74.98189000),
(1020717, 1002883, 'CO', 'Coello', 1, 'coello', 4.37330000, -74.88655000),
(1020745, 1002883, 'CO', 'Coyaima', 1, 'coyaima', 3.72781000, -75.17397000),
(1020758, 1002883, 'CO', 'Cunday', 1, 'cunday', 4.00284000, -74.69295000),
(1020778, 1002883, 'CO', 'Doima', 1, 'doima', 4.42692000, -74.97548000),
(1020779, 1002883, 'CO', 'Dolores', 1, 'dolores', 3.60534000, -74.80585000),
(1020841, 1002883, 'CO', 'Espinal', 1, 'espinal', 4.14924000, -74.88429000),
(1020843, 1002883, 'CO', 'Falan', 1, 'falan', 5.12383000, -74.95181000),
(1020847, 1002883, 'CO', 'Flandes', 1, 'flandes', 4.25000000, -74.83333000),
(1020860, 1002883, 'CO', 'Fresno', 1, 'fresno', 5.15264000, -75.03624000),
(1020862, 1002883, 'CO', 'Frías', 1, 'frias', 5.02973000, -75.00860000),
(1020875, 1002883, 'CO', 'Gaitania', 1, 'gaitania', 3.15000000, -75.81667000),
(1020908, 1002883, 'CO', 'Guamo', 1, 'guamo', 4.07457000, -74.97689000),
(1020920, 1002883, 'CO', 'Guayabal', 1, 'guayabal', 5.03103000, -74.88683000),
(1020941, 1002883, 'CO', 'Herveo', 1, 'herveo', 5.08004000, -75.17556000),
(1020943, 1002883, 'CO', 'Honda', 1, 'honda', 5.20856000, -74.73584000),
(1020944, 1002883, 'CO', 'Ibagué', 1, 'ibague', 4.43889000, -75.23222000),
(1020945, 1002883, 'CO', 'Icononzo', 1, 'icononzo', 4.17698000, -74.53254000),
(1020967, 1002883, 'CO', 'Junín', 1, 'junin', 4.78333000, -75.01667000),
(1020976, 1002883, 'CO', 'La Chamba', 1, 'la-chamba', 4.02649000, -74.86844000),
(1021020, 1002883, 'CO', 'Laureles', 1, 'laureles', 4.25917000, -75.32250000),
(1021039, 1002883, 'CO', 'Lérida', 1, 'lerida', 4.86242000, -74.90977000),
(1021040, 1002883, 'CO', 'Líbano', 1, 'libano', 4.83560000, -75.10834000),
(1021079, 1002883, 'CO', 'Melgar', 1, 'melgar', 4.20475000, -74.64075000),
(1021118, 1002883, 'CO', 'Municipio de San Sebastián de Mariquita', 1, 'municipio-de-san-sebastian-de-mariquita', 5.24269000, -74.90772000),
(1021119, 1002883, 'CO', 'Murillo', 1, 'murillo', 4.87393000, -75.17151000),
(1021128, 1002883, 'CO', 'Natagaima', 1, 'natagaima', 3.55212000, -75.11345000),
(1021154, 1002883, 'CO', 'Ortega', 1, 'ortega', 3.94514000, -75.27245000),
(1021162, 1002883, 'CO', 'Padua', 1, 'padua', 5.13429000, -75.14001000),
(1021175, 1002883, 'CO', 'Palocabildo', 1, 'palocabildo', 5.11705000, -75.01732000),
(1021188, 1002883, 'CO', 'Payandé', 1, 'payande', 4.29750000, -75.09667000),
(1021201, 1002883, 'CO', 'Piedras', 1, 'piedras', 4.50000000, -74.91667000),
(1021212, 1002883, 'CO', 'Planadas', 1, 'planadas', 3.10326000, -75.81680000),
(1021215, 1002883, 'CO', 'Playarrica', 1, 'playarrica', 4.05694000, -75.41028000),
(1021223, 1002883, 'CO', 'Prado', 1, 'prado', 3.73219000, -74.86494000),
(1021264, 1002883, 'CO', 'Purificación', 1, 'purificacion', 3.85871000, -74.93129000),
(1021289, 1002883, 'CO', 'Rioblanco', 1, 'rioblanco', 3.50000000, -75.83333000),
(1021299, 1002883, 'CO', 'Roncesvalles', 1, 'roncesvalles', 4.01080000, -75.60493000),
(1021302, 1002883, 'CO', 'Rovira', 1, 'rovira', 4.21222000, -75.34210000),
(1021321, 1002883, 'CO', 'Saldaña', 1, 'saldana', 3.92923000, -75.01517000),
(1021337, 1002883, 'CO', 'San Antonio', 1, 'san-antonio', 3.95664000, -75.50000000),
(1021379, 1002883, 'CO', 'San Luis', 1, 'san-luis', 4.16667000, -75.08333000),
(1021405, 1002883, 'CO', 'San Sebastián de Mariquita', 1, 'san-sebastian-de-mariquita', 5.19889000, -74.89295000),
(1021419, 1002883, 'CO', 'Santa Isabel', 1, 'santa-isabel', 4.72626000, -75.22391000),
(1021437, 1002883, 'CO', 'Santiago Pérez', 1, 'santiago-perez', 3.39806000, -75.60500000),
(1021500, 1002883, 'CO', 'Suárez', 1, 'suarez', 4.04897000, -74.81821000),
(1021547, 1002883, 'CO', 'Tres Esquinas', 1, 'tres-esquinas', 3.86512000, -74.70906000),
(1021580, 1002883, 'CO', 'Valle de San Juan', 1, 'valle-de-san-juan', 4.19869000, -75.11733000),
(1021586, 1002883, 'CO', 'Venadillo', 1, 'venadillo', 4.69177000, -74.93669000),
(1021604, 1002883, 'CO', 'Villahermosa', 1, 'villahermosa', 4.96503000, -75.15650000),
(1021611, 1002883, 'CO', 'Villarrica', 1, 'villarrica', 3.83099000, -74.65258000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002904, 'CO', 'Valle del Cauca Department', 1, 'valle-del-cauca-department');

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 
(1020502, 1002904, 'CO', 'Alcalá', 1, 'alcala', 4.67458000, -75.77188000),
(1020519, 1002904, 'CO', 'Andalucía', 1, 'andalucia', 4.14035000, -76.14739000),
(1020526, 1002904, 'CO', 'Ansermanuevo', 1, 'ansermanuevo', 4.79722000, -75.99500000),
(1020546, 1002904, 'CO', 'Argelia', 1, 'argelia', 4.72904000, -76.11637000),
(1020598, 1002904, 'CO', 'Bolívar', 1, 'bolivar', 4.37710000, -76.34870000),
(1020605, 1002904, 'CO', 'Buenaventura', 1, 'buenaventura', 3.88010000, -77.03116000),
(1020612, 1002904, 'CO', 'Bugalagrande', 1, 'bugalagrande', 4.21207000, -76.15564000),
(1020622, 1002904, 'CO', 'Caicedonia', 1, 'caicedonia', 4.33240000, -75.82665000),
(1020634, 1002904, 'CO', 'Cali', 1, 'cali', 3.41033000, -76.58097000),
(1020636, 1002904, 'CO', 'Calima', 1, 'calima', 3.92511000, -76.62654000),
(1020644, 1002904, 'CO', 'Candelaria', 1, 'candelaria', 3.38367000, -76.42466000),
(1020661, 1002904, 'CO', 'Cartago', 1, 'cartago', 4.74639000, -75.91167000),
(1020774, 1002904, 'CO', 'Dagua', 1, 'dagua', 3.65685000, -76.68859000),
(1020775, 1002904, 'CO', 'Darien', 1, 'darien', 3.93135000, -76.48481000),
(1020835, 1002904, 'CO', 'El Águila', 1, 'el-aguila', 4.91946000, -76.05680000),
(1020789, 1002904, 'CO', 'El Cairo', 1, 'el-cairo', 4.74889000, -76.24443000),
(1020800, 1002904, 'CO', 'El Cerrito', 1, 'el-cerrito', 3.64273000, -76.20960000),
(1020806, 1002904, 'CO', 'El Dovio', 1, 'el-dovio', 4.50790000, -76.23619000),
(1020851, 1002904, 'CO', 'Florida', 1, 'florida', 3.30940000, -76.18989000),
(1020884, 1002904, 'CO', 'Ginebra', 1, 'ginebra', 3.74296000, -76.19412000),
(1020897, 1002904, 'CO', 'Guacarí', 1, 'guacari', 3.76383000, -76.33292000),
(1020900, 1002904, 'CO', 'Guadalajara de Buga', 1, 'guadalajara-de-buga', 3.90089000, -76.29783000),
(1020958, 1002904, 'CO', 'Jamundí', 1, 'jamundi', 3.26074000, -76.53499000),
(1020979, 1002904, 'CO', 'La Cumbre', 1, 'la-cumbre', 3.72250000, -76.02083000),
(1021006, 1002904, 'CO', 'La Unión', 1, 'la-union', 4.53282000, -76.10318000),
(1021013, 1002904, 'CO', 'La Victoria', 1, 'la-victoria', 4.52483000, -76.03921000),
(1021144, 1002904, 'CO', 'Obando', 1, 'obando', 4.59590000, -75.94879000),
(1021173, 1002904, 'CO', 'Palmira', 1, 'palmira', 3.53969000, -76.22607000),
(1021222, 1002904, 'CO', 'Pradera', 1, 'pradera', 3.42793000, -76.17159000),
(1021285, 1002904, 'CO', 'Restrepo', 1, 'restrepo', 3.82203000, -76.52242000),
(1021290, 1002904, 'CO', 'Riofrío', 1, 'riofrio', 4.15710000, -76.28852000),
(1021298, 1002904, 'CO', 'Roldanillo', 1, 'roldanillo', 4.41256000, -76.15457000),
(1021397, 1002904, 'CO', 'San Pedro', 1, 'san-pedro', 3.99936000, -76.26123000),
(1021451, 1002904, 'CO', 'Sevilla', 1, 'sevilla', 4.19345000, -75.88829000),
(1021544, 1002904, 'CO', 'Toro', 1, 'toro', 4.61167000, -76.08139000),
(1021549, 1002904, 'CO', 'Trujillo', 1, 'trujillo', 4.23696000, -76.34730000),
(1021551, 1002904, 'CO', 'Tuluá', 1, 'tulua', 4.08466000, -76.19536000),
(1021567, 1002904, 'CO', 'Ulloa', 1, 'ulloa', 4.70745000, -75.77781000),
(1021591, 1002904, 'CO', 'Versalles', 1, 'versalles', 4.66335000, -76.24649000),
(1021596, 1002904, 'CO', 'Vijes', 1, 'vijes', 3.73283000, -76.49363000),
(1021627, 1002904, 'CO', 'Yotoco', 1, 'yotoco', 3.86048000, -76.38364000),
(1021628, 1002904, 'CO', 'Yumbo', 1, 'yumbo', 3.58234000, -76.49146000),
(1021633, 1002904, 'CO', 'Zarzal', 1, 'zarzal', 4.39462000, -76.07150000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002885, 'CO', 'Vaupés Department', 1, 'vaupes-department');

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 
(1020663, 1002885, 'CO', 'Caruru', 1, 'caruru', 1.02081000, -71.33788000),
(1021088, 1002885, 'CO', 'Mitú', 1, 'mitu', 1.25778000, -70.23472000),
(1021160, 1002885, 'CO', 'Pacoa', 1, 'pacoa', 0.15636000, -70.89274000),
(1021181, 1002885, 'CO', 'Papunaua', 1, 'papunaua', 1.68335000, -70.70968000),
(1021511, 1002885, 'CO', 'Taraira', 1, 'taraira', -0.74835000, -69.89662000),
(1021623, 1002885, 'CO', 'Yavaraté', 1, 'yavarate', 0.82828000, -69.62959000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002894, 'CO', 'Vichada Department', 1, 'vichada-department');

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 
(1020755, 1002894, 'CO', 'Cumaribo', 1, 'cumaribo', 4.44552000, -69.79897000),
(1021002, 1002894, 'CO', 'La Primavera', 1, 'la-primavera', 5.49056000, -70.40917000),
(1021237, 1002894, 'CO', 'Puerto Carreño', 1, 'puerto-carreno', 6.18903000, -67.48588000),
(1021428, 1002894, 'CO', 'Santa Rosalia', 1, 'santa-rosalia', 5.13356000, -70.86233000),
(1021429, 1002894, 'CO', 'Santa Rosalía', 1, 'santa-rosalia', 5.02169000, -70.65985000);

