REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('PA', 'Panama', 'panama', '507', 'Panamá', 'PAB');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001393, 'PA', 'Bocas del Toro Province', 1, 'bocas-del-toro-province');

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 
(1079962, 1001393, 'PA', 'Almirante', 1, 'almirante', 9.30091000, -82.40180000),
(1079982, 1001393, 'PA', 'Barranco', 1, 'barranco', 9.51984000, -82.70424000),
(1079983, 1001393, 'PA', 'Barranco Adentro', 1, 'barranco-adentro', 9.52757000, -82.73344000),
(1079986, 1001393, 'PA', 'Bastimentos', 1, 'bastimentos', 9.34707000, -82.20880000),
(1080000, 1001393, 'PA', 'Bocas del Toro', 1, 'bocas-del-toro', 9.34031000, -82.24204000),
(1080036, 1001393, 'PA', 'Cauchero', 1, 'cauchero', 9.15226000, -82.26450000),
(1080054, 1001393, 'PA', 'Changuinola', 1, 'changuinola', 9.43000000, -82.52000000),
(1080063, 1001393, 'PA', 'Chiriquí Grande', 1, 'chiriqui-grande', 8.94557000, -82.11769000),
(1080084, 1001393, 'PA', 'Distrito Chiriquí Grande', 1, 'distrito-chiriqui-grande', 8.94748000, -82.12418000),
(1080092, 1001393, 'PA', 'Distrito de Bocas del Toro', 1, 'distrito-de-bocas-del-toro', 9.36235000, -82.26288000),
(1080101, 1001393, 'PA', 'Distrito de Changuinola', 1, 'distrito-de-changuinola', 9.25000000, -82.63333000),
(1080170, 1001393, 'PA', 'El Empalme', 1, 'el-empalme', 9.41667000, -82.51667000),
(1080202, 1001393, 'PA', 'El Silencio', 1, 'el-silencio', 9.37222000, -82.52877000),
(1080217, 1001393, 'PA', 'Guabito', 1, 'guabito', 9.48968000, -82.61279000),
(1080235, 1001393, 'PA', 'Isla Bastimentos', 1, 'isla-bastimentos', 9.30000000, -82.13333000),
(1080265, 1001393, 'PA', 'La Mesa', 1, 'la-mesa', 9.49587000, -82.67534000),
(1080355, 1001393, 'PA', 'Miramar', 1, 'miramar', 8.99482000, -82.24147000),
(1080437, 1001393, 'PA', 'Punta Laurel', 1, 'punta-laurel', 9.14100000, -82.12717000),
(1080438, 1001393, 'PA', 'Punta Peña', 1, 'punta-pena', 8.91659000, -82.18488000),
(1080439, 1001393, 'PA', 'Punta Róbalo', 1, 'punta-robalo', 9.03631000, -82.24952000),
(1080537, 1001393, 'PA', 'Valle del Risco', 1, 'valle-del-risco', 9.23064000, -82.42748000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001397, 'PA', 'Chiriquí Province', 1, 'chiriqui-province');

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 
(1079959, 1001397, 'PA', 'Alanje', 1, 'alanje', 8.39791000, -82.55947000),
(1079961, 1001397, 'PA', 'Algarrobos Arriba', 1, 'algarrobos-arriba', 8.51550000, -82.42263000),
(1079963, 1001397, 'PA', 'Alto Boquete', 1, 'alto-boquete', 8.73458000, -82.43213000),
(1079974, 1001397, 'PA', 'Aserrío de Gariché', 1, 'aserrio-de-gariche', 8.48257000, -82.79086000),
(1080012, 1001397, 'PA', 'Bágala', 1, 'bagala', 8.46399000, -82.52617000),
(1079979, 1001397, 'PA', 'Bajo Boquete', 1, 'bajo-boquete', 8.77058000, -82.43306000),
(1079985, 1001397, 'PA', 'Barrio Guadalupe', 1, 'barrio-guadalupe', 8.86482000, -82.56523000),
(1079992, 1001397, 'PA', 'Bijagual', 1, 'bijagual', 8.51486000, -82.33361000),
(1079995, 1001397, 'PA', 'Boca Chica', 1, 'boca-chica', 8.21911000, -82.21592000),
(1079999, 1001397, 'PA', 'Boca del Monte', 1, 'boca-del-monte', 8.35296000, -82.11379000),
(1080002, 1001397, 'PA', 'Boquerón', 1, 'boqueron', 8.50510000, -82.57025000),
(1080003, 1001397, 'PA', 'Boquete', 1, 'boquete', 8.78024000, -82.44136000),
(1080005, 1001397, 'PA', 'Breñón', 1, 'brenon', 8.62491000, -82.81277000),
(1080010, 1001397, 'PA', 'Bugaba', 1, 'bugaba', 8.48255000, -82.61991000),
(1080011, 1001397, 'PA', 'Bugabita Arriba', 1, 'bugabita-arriba', 8.52143000, -82.63638000),
(1080021, 1001397, 'PA', 'Caimito', 1, 'caimito', 8.54162000, -82.41900000),
(1080023, 1001397, 'PA', 'Caldera', 1, 'caldera', 8.64907000, -82.38058000),
(1080038, 1001397, 'PA', 'Cañas Gordas', 1, 'canas-gordas', 8.74309000, -82.91275000),
(1080043, 1001397, 'PA', 'Celmira', 1, 'celmira', 8.54026000, -82.80022000),
(1080051, 1001397, 'PA', 'Cerro Punta', 1, 'cerro-punta', 8.84968000, -82.57261000),
(1080052, 1001397, 'PA', 'Cerro Viejo', 1, 'cerro-viejo', 8.25349000, -81.57658000),
(1080062, 1001397, 'PA', 'Chiriquí', 1, 'chiriqui', 8.39291000, -82.31993000),
(1080070, 1001397, 'PA', 'Cochea Abajo', 1, 'cochea-abajo', 8.50512000, -82.35878000),
(1080075, 1001397, 'PA', 'Cordillera', 1, 'cordillera', 8.70683000, -82.60327000),
(1080082, 1001397, 'PA', 'David', 1, 'david', 8.42729000, -82.43085000),
(1080087, 1001397, 'PA', 'Distrito de Alanje', 1, 'distrito-de-alanje', 8.39842000, -82.64065000),
(1080091, 1001397, 'PA', 'Distrito de Barú', 1, 'distrito-de-baru', 8.29482000, -82.92726000),
(1080093, 1001397, 'PA', 'Distrito de Boquerón', 1, 'distrito-de-boqueron', 8.61667000, -82.56667000),
(1080094, 1001397, 'PA', 'Distrito de Boquete', 1, 'distrito-de-boquete', 8.74896000, -82.36842000),
(1080095, 1001397, 'PA', 'Distrito de Bugaba', 1, 'distrito-de-bugaba', 8.68786000, -82.67937000),
(1080107, 1001397, 'PA', 'Distrito de David', 1, 'distrito-de-david', 8.40000000, -82.40000000),
(1080108, 1001397, 'PA', 'Distrito de Dolega', 1, 'distrito-de-dolega', 8.61667000, -82.45000000),
(1080110, 1001397, 'PA', 'Distrito de Gualaca', 1, 'distrito-de-gualaca', 8.57398000, -82.22207000),
(1080132, 1001397, 'PA', 'Distrito de Remedios', 1, 'distrito-de-remedios', 8.20253000, -81.81163000),
(1080133, 1001397, 'PA', 'Distrito de Renacimiento', 1, 'distrito-de-renacimiento', 8.71667000, -82.76667000),
(1080137, 1001397, 'PA', 'Distrito de San Félix', 1, 'distrito-de-san-felix', 8.27768000, -81.87377000),
(1080138, 1001397, 'PA', 'Distrito de San Lorenzo', 1, 'distrito-de-san-lorenzo', 8.29366000, -82.08922000),
(1080145, 1001397, 'PA', 'Distrito de Tolé', 1, 'distrito-de-tole', 8.19015000, -81.66007000),
(1080147, 1001397, 'PA', 'Divalá', 1, 'divala', 8.41066000, -82.71332000),
(1080148, 1001397, 'PA', 'Dolega District', 1, 'dolega-district', 8.56667000, -82.41407000),
(1080185, 1001397, 'PA', 'El Nancito', 1, 'el-nancito', 8.23811000, -81.73218000),
(1080186, 1001397, 'PA', 'El Palmar', 1, 'el-palmar', 8.30098000, -82.85344000),
(1080193, 1001397, 'PA', 'El Porvenir', 1, 'el-porvenir', 8.22919000, -81.83278000),
(1080203, 1001397, 'PA', 'El Tejar', 1, 'el-tejar', 8.42973000, -82.57294000),
(1080210, 1001397, 'PA', 'Finca Blanco', 1, 'finca-blanco', 8.37979000, -82.87385000),
(1080229, 1001397, 'PA', 'Gómez', 1, 'gomez', 8.56085000, -82.74142000),
(1080216, 1001397, 'PA', 'Guabal', 1, 'guabal', 8.57466000, -82.53730000),
(1080218, 1001397, 'PA', 'Guaca Arriba', 1, 'guaca-arriba', 8.53733000, -82.49281000),
(1080220, 1001397, 'PA', 'Gualaca', 1, 'gualaca', 8.53006000, -82.29959000),
(1080223, 1001397, 'PA', 'Guarumal', 1, 'guarumal', 8.34523000, -82.53205000),
(1080225, 1001397, 'PA', 'Guayabal', 1, 'guayabal', 8.62193000, -82.57935000),
(1080233, 1001397, 'PA', 'Horconcitos', 1, 'horconcitos', 8.31142000, -82.15102000),
(1080247, 1001397, 'PA', 'La Concepción', 1, 'la-concepcion', 8.51212000, -82.61858000),
(1080252, 1001397, 'PA', 'La Esperanza', 1, 'la-esperanza', 8.40344000, -82.79197000),
(1080254, 1001397, 'PA', 'La Estrella', 1, 'la-estrella', 8.51572000, -82.67212000),
(1080283, 1001397, 'PA', 'Lajas Adentro', 1, 'lajas-adentro', 8.24981000, -81.87779000),
(1080284, 1001397, 'PA', 'Lajas de Tolé', 1, 'lajas-de-tole', 8.16994000, -81.69654000),
(1080295, 1001397, 'PA', 'Las Lajas', 1, 'las-lajas', 8.24184000, -81.86931000),
(1080296, 1001397, 'PA', 'Las Lomas', 1, 'las-lomas', 8.42927000, -82.38743000),
(1080311, 1001397, 'PA', 'Limones', 1, 'limones', 8.10007000, -82.86679000),
(1080326, 1001397, 'PA', 'Los Algarrobos', 1, 'los-algarrobos', 8.49601000, -82.42417000),
(1080328, 1001397, 'PA', 'Los Anastacios', 1, 'los-anastacios', 8.53027000, -82.42295000),
(1080344, 1001397, 'PA', 'Los Ángeles', 1, 'los-angeles', 8.52271000, -82.19997000),
(1080338, 1001397, 'PA', 'Los Naranjos', 1, 'los-naranjos', 8.79210000, -82.44665000),
(1080347, 1001397, 'PA', 'Manaca Civil', 1, 'manaca-civil', 8.32458000, -82.81570000),
(1080348, 1001397, 'PA', 'Manaca Norte', 1, 'manaca-norte', 8.33419000, -82.81003000),
(1080351, 1001397, 'PA', 'Mata del Nance', 1, 'mata-del-nance', 8.45056000, -82.40057000),
(1080360, 1001397, 'PA', 'Monte Lirio', 1, 'monte-lirio', 8.78935000, -82.82865000),
(1080378, 1001397, 'PA', 'Nuevo San Carlitos', 1, 'nuevo-san-carlitos', 8.45698000, -82.43712000),
(1080387, 1001397, 'PA', 'Paja de Sombrero', 1, 'paja-de-sombrero', 8.68335000, -82.31911000),
(1080392, 1001397, 'PA', 'Palmira', 1, 'palmira', 8.73401000, -82.45887000),
(1080393, 1001397, 'PA', 'Palmira Centro', 1, 'palmira-centro', 8.73956000, -82.45228000),
(1080395, 1001397, 'PA', 'Paraíso', 1, 'paraiso', 8.65842000, -82.58625000),
(1080402, 1001397, 'PA', 'Paso Canoas Arriba', 1, 'paso-canoas-arriba', 8.56516000, -82.82214000),
(1080405, 1001397, 'PA', 'Pedregal', 1, 'pedregal', 8.36586000, -82.43524000),
(1080418, 1001397, 'PA', 'Plaza de Caisán', 1, 'plaza-de-caisan', 8.73672000, -82.81968000),
(1080424, 1001397, 'PA', 'Potrerillos Abajo', 1, 'potrerillos-abajo', 8.63978000, -82.48560000),
(1080425, 1001397, 'PA', 'Potrerillos Arriba', 1, 'potrerillos-arriba', 8.68547000, -82.49090000),
(1080428, 1001397, 'PA', 'Progreso', 1, 'progreso', 8.44669000, -82.83859000),
(1080430, 1001397, 'PA', 'Pueblo Viejo', 1, 'pueblo-viejo', 8.25081000, -81.66259000),
(1080431, 1001397, 'PA', 'Puerto Armuelles', 1, 'puerto-armuelles', 8.27775000, -82.86206000),
(1080440, 1001397, 'PA', 'Punta de Burica', 1, 'punta-de-burica', 8.03333000, -82.86667000),
(1080447, 1001397, 'PA', 'Quebrada de Piedra', 1, 'quebrada-de-piedra', 8.09418000, -81.67915000),
(1080449, 1001397, 'PA', 'Querévalo', 1, 'querevalo', 8.37174000, -82.52670000),
(1080450, 1001397, 'PA', 'Quinteño', 1, 'quinteno', 8.47102000, -82.39352000),
(1080451, 1001397, 'PA', 'Remedios', 1, 'remedios', 8.22436000, -81.82747000),
(1080452, 1001397, 'PA', 'Rincón', 1, 'rincon', 8.46374000, -82.27951000),
(1080465, 1001397, 'PA', 'Río Sereno', 1, 'rio-sereno', 8.81741000, -82.85731000),
(1080455, 1001397, 'PA', 'Rovira Arriba', 1, 'rovira-arriba', 8.63822000, -82.49965000),
(1080471, 1001397, 'PA', 'San Andrés', 1, 'san-andres', 8.60260000, -82.72588000),
(1080474, 1001397, 'PA', 'San Carlos', 1, 'san-carlos', 8.51663000, -82.50906000),
(1080478, 1001397, 'PA', 'San Félix', 1, 'san-felix', 8.29063000, -81.86702000),
(1080480, 1001397, 'PA', 'San Isidro', 1, 'san-isidro', 8.53032000, -82.82720000),
(1080487, 1001397, 'PA', 'San Lorenzo', 1, 'san-lorenzo', 8.30561000, -82.10114000),
(1080491, 1001397, 'PA', 'San Pablo Nuevo Abajo', 1, 'san-pablo-nuevo-abajo', 8.42558000, -82.50173000),
(1080492, 1001397, 'PA', 'San Pablo Viejo Abajo', 1, 'san-pablo-viejo-abajo', 8.45339000, -82.50179000),
(1080497, 1001397, 'PA', 'Santa Clara', 1, 'santa-clara', 8.83376000, -82.77945000),
(1080499, 1001397, 'PA', 'Santa Cruz', 1, 'santa-cruz', 8.23219000, -81.91323000),
(1080503, 1001397, 'PA', 'Santa Marta', 1, 'santa-marta', 8.51406000, -82.69870000),
(1080507, 1001397, 'PA', 'Santa Rosa', 1, 'santa-rosa', 8.59958000, -82.68489000),
(1080510, 1001397, 'PA', 'Santo Domingo', 1, 'santo-domingo', 8.50803000, -82.71295000),
(1080511, 1001397, 'PA', 'Santo Tomás', 1, 'santo-tomas', 8.38959000, -82.65058000),
(1080513, 1001397, 'PA', 'Sioguí Abajo', 1, 'siogui-abajo', 8.48678000, -82.66539000),
(1080514, 1001397, 'PA', 'Sioguí Arriba', 1, 'siogui-arriba', 8.53865000, -82.68619000),
(1080517, 1001397, 'PA', 'Sortova', 1, 'sortova', 8.54642000, -82.65170000),
(1080520, 1001397, 'PA', 'Tijeras', 1, 'tijeras', 8.47514000, -82.56058000),
(1080521, 1001397, 'PA', 'Tinajas', 1, 'tinajas', 8.55281000, -82.45963000),
(1080525, 1001397, 'PA', 'Tolé', 1, 'tole', 8.23989000, -81.67168000),
(1080539, 1001397, 'PA', 'Veladero', 1, 'veladero', 8.23136000, -81.65417000),
(1080550, 1001397, 'PA', 'Volcán', 1, 'volcan', 8.77291000, -82.63823000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001387, 'PA', 'Coclé Province', 1, 'cocle-province');

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 
(1079956, 1001387, 'PA', 'Aguadulce', 1, 'aguadulce', 8.24183000, -80.54609000),
(1079957, 1001387, 'PA', 'Aguas Blancas', 1, 'aguas-blancas', 8.50351000, -80.31169000),
(1079965, 1001387, 'PA', 'Alto de La Estancia', 1, 'alto-de-la-estancia', 8.58792000, -80.18443000),
(1079969, 1001387, 'PA', 'Antón', 1, 'anton', 8.39733000, -80.26063000),
(1079984, 1001387, 'PA', 'Barranco Colorado', 1, 'barranco-colorado', 8.38937000, -80.63546000),
(1080013, 1001387, 'PA', 'Caballero', 1, 'caballero', 8.54343000, -80.19769000),
(1080017, 1001387, 'PA', 'Cabuya', 1, 'cabuya', 8.54703000, -80.16756000),
(1080019, 1001387, 'PA', 'Caimito', 1, 'caimito', 8.62271000, -80.23919000),
(1080039, 1001387, 'PA', 'Cañaveral', 1, 'canaveral', 8.51700000, -80.42916000),
(1080032, 1001387, 'PA', 'Capellanía', 1, 'capellania', 8.29858000, -80.55480000),
(1080058, 1001387, 'PA', 'Chigoré', 1, 'chigore', 8.53035000, -80.35117000),
(1080059, 1001387, 'PA', 'Chiguirí Arriba', 1, 'chiguiri-arriba', 8.67187000, -80.18975000),
(1080067, 1001387, 'PA', 'Churuquita Chiquita', 1, 'churuquita-chiquita', 8.57555000, -80.27161000),
(1080068, 1001387, 'PA', 'Churuquita Grande', 1, 'churuquita-grande', 8.59449000, -80.27182000),
(1080071, 1001387, 'PA', 'Coclé', 1, 'cocle', 8.45601000, -80.42899000),
(1080086, 1001387, 'PA', 'Distrito de Aguadulce', 1, 'distrito-de-aguadulce', 8.21270000, -80.61441000),
(1080088, 1001387, 'PA', 'Distrito de Antón', 1, 'distrito-de-anton', 8.45394000, -80.18361000),
(1080114, 1001387, 'PA', 'Distrito de La Pintada', 1, 'distrito-de-la-pintada', 8.71801000, -80.53946000),
(1080122, 1001387, 'PA', 'Distrito de Natá', 1, 'distrito-de-nata', 8.34416000, -80.60934000),
(1080124, 1001387, 'PA', 'Distrito de Olá', 1, 'distrito-de-ola', 8.48053000, -80.65324000),
(1080085, 1001387, 'PA', 'Distrito Penonomé', 1, 'distrito-penonome', 8.63000000, -80.28333000),
(1080157, 1001387, 'PA', 'El Caño', 1, 'el-cano', 8.40195000, -80.51791000),
(1080159, 1001387, 'PA', 'El Chirú', 1, 'el-chiru', 8.39876000, -80.18721000),
(1080163, 1001387, 'PA', 'El Coco', 1, 'el-coco', 8.39716000, -80.35000000),
(1080165, 1001387, 'PA', 'El Copé', 1, 'el-cope', 8.62036000, -80.58433000),
(1080167, 1001387, 'PA', 'El Cortezo', 1, 'el-cortezo', 8.34556000, -80.58721000),
(1080168, 1001387, 'PA', 'El Cristo', 1, 'el-cristo', 8.25071000, -80.62093000),
(1080194, 1001387, 'PA', 'El Potrero', 1, 'el-potrero', 8.52146000, -80.51681000),
(1080198, 1001387, 'PA', 'El Retiro', 1, 'el-retiro', 8.48014000, -80.15426000),
(1080201, 1001387, 'PA', 'El Roble', 1, 'el-roble', 8.16850000, -80.65897000),
(1080207, 1001387, 'PA', 'Entradero', 1, 'entradero', 8.56880000, -80.20743000),
(1080209, 1001387, 'PA', 'Farallón', 1, 'farallon', 8.35658000, -80.13723000),
(1080228, 1001387, 'PA', 'Guzman', 1, 'guzman', 8.51969000, -80.58405000),
(1080237, 1001387, 'PA', 'Juan Díaz', 1, 'juan-diaz', 8.46240000, -80.28280000),
(1080261, 1001387, 'PA', 'La Loma', 1, 'la-loma', 8.16667000, -80.63742000),
(1080275, 1001387, 'PA', 'La Pintada', 1, 'la-pintada', 8.59299000, -80.44349000),
(1080293, 1001387, 'PA', 'Las Huacas del Quije', 1, 'las-huacas-del-quije', 8.46702000, -80.75089000),
(1080299, 1001387, 'PA', 'Las Marias', 1, 'las-marias', 8.88809000, -80.21893000),
(1080301, 1001387, 'PA', 'Las Minas', 1, 'las-minas', 8.64118000, -80.39432000),
(1080305, 1001387, 'PA', 'Las Sabanas', 1, 'las-sabanas', 8.58141000, -80.67978000),
(1080317, 1001387, 'PA', 'Llano Grande', 1, 'llano-grande', 8.63817000, -80.43848000),
(1080320, 1001387, 'PA', 'Llano Marín', 1, 'llano-marin', 8.47696000, -80.32499000),
(1080340, 1001387, 'PA', 'Los Pollos', 1, 'los-pollos', 8.39898000, -80.15731000),
(1080366, 1001387, 'PA', 'Natá', 1, 'nata', 8.33209000, -80.51969000),
(1080370, 1001387, 'PA', 'Nuestro Amo', 1, 'nuestro-amo', 8.44485000, -80.58934000),
(1080383, 1001387, 'PA', 'Olá', 1, 'ola', 8.41807000, -80.65123000),
(1080406, 1001387, 'PA', 'Penonomé', 1, 'penonome', 8.51889000, -80.35727000),
(1080411, 1001387, 'PA', 'Piedras Gordas', 1, 'piedras-gordas', 8.63777000, -80.51024000),
(1080420, 1001387, 'PA', 'Pocrí', 1, 'pocri', 8.25814000, -80.55000000),
(1080460, 1001387, 'PA', 'Río Grande', 1, 'rio-grande', 8.42679000, -80.48457000),
(1080462, 1001387, 'PA', 'Río Hato', 1, 'rio-hato', 8.37940000, -80.16621000),
(1080486, 1001387, 'PA', 'San Juan de Dios', 1, 'san-juan-de-dios', 8.55119000, -80.22623000),
(1080522, 1001387, 'PA', 'Toabré', 1, 'toabre', 8.65131000, -80.32017000),
(1080528, 1001387, 'PA', 'Toza', 1, 'toza', 8.34542000, -80.64012000),
(1080548, 1001387, 'PA', 'Vista Hermosa', 1, 'vista-hermosa', 8.52687000, -80.37486000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001386, 'PA', 'Colón Province', 1, 'colon-province');

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 
(1080007, 1001386, 'PA', 'Buena Vista', 1, 'buena-vista', 9.27356000, -79.69551000),
(1080035, 1001386, 'PA', 'Cativá', 1, 'cativa', 9.36218000, -79.83232000),
(1080072, 1001386, 'PA', 'Coclé del Norte', 1, 'cocle-del-norte', 9.07540000, -80.57177000),
(1080073, 1001386, 'PA', 'Colón', 1, 'colon', 9.35451000, -79.90011000),
(1080078, 1001386, 'PA', 'Cristóbal', 1, 'cristobal', 9.35222000, -79.90444000),
(1080099, 1001386, 'PA', 'Distrito de Chagres', 1, 'distrito-de-chagres', 9.12300000, -80.11841000),
(1080106, 1001386, 'PA', 'Distrito de Colón', 1, 'distrito-de-colon', 9.24313000, -79.79463000),
(1080109, 1001386, 'PA', 'Distrito de Donoso', 1, 'distrito-de-donoso', 9.01999000, -80.42967000),
(1080131, 1001386, 'PA', 'Distrito de Portobelo', 1, 'distrito-de-portobelo', 9.49748000, -79.60730000),
(1080140, 1001386, 'PA', 'Distrito de Santa Isabel', 1, 'distrito-de-santa-isabel', 9.48333000, -79.31667000),
(1080174, 1001386, 'PA', 'El Giral', 1, 'el-giral', 9.24509000, -79.69266000),
(1080175, 1001386, 'PA', 'El Guabo', 1, 'el-guabo', 9.07842000, -80.08316000),
(1080206, 1001386, 'PA', 'El Valle de la Unión', 1, 'el-valle-de-la-union', 9.23630000, -79.65986000),
(1080208, 1001386, 'PA', 'Escobal', 1, 'escobal', 9.14373000, -79.96439000),
(1080214, 1001386, 'PA', 'Gatún', 1, 'gatun', 9.28922000, -79.77204000),
(1080213, 1001386, 'PA', 'Gatuncillo', 1, 'gatuncillo', 9.24346000, -79.64856000),
(1080298, 1001386, 'PA', 'Las Margaritas', 1, 'las-margaritas', 9.32603000, -79.89028000),
(1080350, 1001386, 'PA', 'María Chiquita', 1, 'maria-chiquita', 9.43991000, -79.75455000),
(1080354, 1001386, 'PA', 'Miramar', 1, 'miramar', 9.57544000, -79.33573000),
(1080368, 1001386, 'PA', 'Nombre de Dios', 1, 'nombre-de-dios', 9.57937000, -79.47109000),
(1080376, 1001386, 'PA', 'Nuevo Chagres', 1, 'nuevo-chagres', 9.23979000, -80.08267000),
(1080379, 1001386, 'PA', 'Nuevo San Juan', 1, 'nuevo-san-juan', 9.22205000, -79.66602000),
(1080380, 1001386, 'PA', 'Nuevo Vigía', 1, 'nuevo-vigia', 9.24263000, -79.60756000),
(1080388, 1001386, 'PA', 'Palenque', 1, 'palenque', 9.56970000, -79.36341000),
(1080389, 1001386, 'PA', 'Palmas Bellas', 1, 'palmas-bellas', 9.22838000, -80.08503000),
(1080391, 1001386, 'PA', 'Palmira', 1, 'palmira', 9.54359000, -79.21946000),
(1080415, 1001386, 'PA', 'Playa Chiquita', 1, 'playa-chiquita', 9.56620000, -79.29185000),
(1080423, 1001386, 'PA', 'Portobelo', 1, 'portobelo', 9.55303000, -79.65693000),
(1080433, 1001386, 'PA', 'Puerto Escondido', 1, 'puerto-escondido', 9.19333000, -80.08833000),
(1080435, 1001386, 'PA', 'Puerto Pilón', 1, 'puerto-pilon', 9.36316000, -79.79333000),
(1080443, 1001386, 'PA', 'Quebrada Bonita Adentro', 1, 'quebrada-bonita-adentro', 9.29662000, -79.70606000),
(1080457, 1001386, 'PA', 'Río Alejandro', 1, 'rio-alejandro', 9.37149000, -79.78809000),
(1080459, 1001386, 'PA', 'Río Duque', 1, 'rio-duque', 9.25688000, -79.67937000),
(1080464, 1001386, 'PA', 'Río Rita', 1, 'rio-rita', 9.30296000, -79.79234000),
(1080469, 1001386, 'PA', 'Sabanitas', 1, 'sabanitas', 9.34269000, -79.80961000),
(1080502, 1001386, 'PA', 'Santa Isabel', 1, 'santa-isabel', 9.53922000, -79.19570000),
(1080506, 1001386, 'PA', 'Santa Rita Arriba', 1, 'santa-rita-arriba', 9.33032000, -79.79363000),
(1080541, 1001386, 'PA', 'Viento Frío', 1, 'viento-frio', 9.58263000, -79.40690000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001385, 'PA', 'Darién Province', 1, 'darien-province');

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 
(1079997, 1001385, 'PA', 'Boca de Cupé', 1, 'boca-de-cupe', 8.03003000, -77.58978000),
(1080030, 1001385, 'PA', 'Camogantí', 1, 'camoganti', 8.04171000, -77.88682000),
(1080079, 1001385, 'PA', 'Cucunatí', 1, 'cucunati', 8.57508000, -78.25671000),
(1080102, 1001385, 'PA', 'Distrito de Chepigana', 1, 'distrito-de-chepigana', 7.84374000, -77.83830000),
(1080129, 1001385, 'PA', 'Distrito de Pinogana', 1, 'distrito-de-pinogana', 7.89343000, -77.52562000),
(1080212, 1001385, 'PA', 'Garachiné', 1, 'garachine', 8.06684000, -78.36436000),
(1080236, 1001385, 'PA', 'Jaqué', 1, 'jaque', 7.51826000, -78.16343000),
(1080270, 1001385, 'PA', 'La Palma', 1, 'la-palma', 8.40608000, -78.13964000),
(1080353, 1001385, 'PA', 'Metetí', 1, 'meteti', 8.49909000, -77.97897000),
(1080362, 1001385, 'PA', 'Mortí', 1, 'morti', 8.84246000, -77.97539000),
(1080442, 1001385, 'PA', 'Púcuro', 1, 'pucuro', 7.97876000, -77.48758000),
(1080500, 1001385, 'PA', 'Santa Fé', 1, 'santa-fe', 8.65525000, -78.16140000),
(1080552, 1001385, 'PA', 'Yaviza', 1, 'yaviza', 8.15835000, -77.69276000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001396, 'PA', 'Emberá-Wounaan Comarca', 1, 'embera-wounaan-comarca');

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 
(1079987, 1001396, 'PA', 'Bayamón', 1, 'bayamon', 7.96817000, -78.21648000),
(1080081, 1001396, 'PA', 'Cémaco', 1, 'cemaco', 8.08285000, -77.54210000),
(1080076, 1001396, 'PA', 'Corozal', 1, 'corozal', 8.20108000, -77.59637000),
(1080470, 1001396, 'PA', 'Sambú', 1, 'sambu', 7.82013000, -78.11005000),
(1080531, 1001396, 'PA', 'Unión Chocó', 1, 'union-choco', 8.08404000, -77.53507000),
(1080551, 1001396, 'PA', 'Yape', 1, 'yape', 8.09839000, -77.59817000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001388, 'PA', 'Guna Yala', 1, 'guna-yala');

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 
(1079954, 1001388, 'PA', 'Achutupo', 1, 'achutupo', 9.19827000, -77.98729000),
(1079958, 1001388, 'PA', 'Ailigandí', 1, 'ailigandi', 9.22810000, -78.02778000),
(1080034, 1001388, 'PA', 'Cartí Sugdup', 1, 'carti-sugdup', 9.46460000, -78.95931000),
(1080192, 1001388, 'PA', 'El Porvenir', 1, 'el-porvenir', 9.55276000, -78.95230000),
(1080363, 1001388, 'PA', 'Mulatupo', 1, 'mulatupo', 8.94672000, -77.75080000),
(1080365, 1001388, 'PA', 'Narganá', 1, 'nargana', 9.44394000, -78.58666000),
(1080417, 1001388, 'PA', 'Playón Chico', 1, 'playon-chico', 9.31128000, -78.23270000),
(1080434, 1001388, 'PA', 'Puerto Obaldía', 1, 'puerto-obaldia', 8.66632000, -77.41922000),
(1080479, 1001388, 'PA', 'San Ignacio de Tupile', 1, 'san-ignacio-de-tupile', 9.28905000, -78.15206000),
(1080530, 1001388, 'PA', 'Tubualá', 1, 'tubuala', 9.51667000, -79.03333000),
(1080534, 1001388, 'PA', 'Ustupo', 1, 'ustupo', 9.13112000, -77.92620000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001389, 'PA', 'Herrera Province', 1, 'herrera-province');

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 
(1079998, 1001389, 'PA', 'Boca de Parita', 1, 'boca-de-parita', 8.00796000, -80.45320000),
(1080015, 1001389, 'PA', 'Cabuya', 1, 'cabuya', 8.03138000, -80.63227000),
(1080049, 1001389, 'PA', 'Cerro Largo', 1, 'cerro-largo', 7.83377000, -80.83168000),
(1080064, 1001389, 'PA', 'Chitré', 1, 'chitre', 7.96082000, -80.42944000),
(1080065, 1001389, 'PA', 'Chumical', 1, 'chumical', 7.84482000, -80.72627000),
(1080066, 1001389, 'PA', 'Chupampa', 1, 'chupampa', 8.07620000, -80.77656000),
(1080105, 1001389, 'PA', 'Distrito de Chitré', 1, 'distrito-de-chitre', 7.98333000, -80.43333000),
(1080115, 1001389, 'PA', 'Distrito de Las Minas', 1, 'distrito-de-las-minas', 7.76525000, -80.82249000),
(1080118, 1001389, 'PA', 'Distrito de Los Pozos', 1, 'distrito-de-los-pozos', 7.70944000, -80.64311000),
(1080123, 1001389, 'PA', 'Distrito de Ocú', 1, 'distrito-de-ocu', 7.90641000, -80.79752000),
(1080126, 1001389, 'PA', 'Distrito de Parita', 1, 'distrito-de-parita', 8.06240000, -80.56373000),
(1080128, 1001389, 'PA', 'Distrito de Pesé', 1, 'distrito-de-pese', 7.88194000, -80.63261000),
(1080141, 1001389, 'PA', 'Distrito de Santa María', 1, 'distrito-de-santa-maria', 8.11667000, -80.68333000),
(1080153, 1001389, 'PA', 'El Calabacito', 1, 'el-calabacito', 7.71843000, -80.59757000),
(1080154, 1001389, 'PA', 'El Capurí', 1, 'el-capuri', 7.72571000, -80.64349000),
(1080158, 1001389, 'PA', 'El Cedro', 1, 'el-cedro', 7.68565000, -80.65927000),
(1080188, 1001389, 'PA', 'El Pedregoso', 1, 'el-pedregoso', 7.93642000, -80.63807000),
(1080199, 1001389, 'PA', 'El Rincón', 1, 'el-rincon', 8.11923000, -80.61707000),
(1080204, 1001389, 'PA', 'El Toro', 1, 'el-toro', 7.75110000, -80.86943000),
(1080241, 1001389, 'PA', 'La Arena', 1, 'la-arena', 7.96766000, -80.46523000),
(1080279, 1001389, 'PA', 'La Trinidad', 1, 'la-trinidad', 7.91457000, -80.70332000),
(1080289, 1001389, 'PA', 'Las Guabas', 1, 'las-guabas', 7.90949000, -80.80706000),
(1080300, 1001389, 'PA', 'Las Minas', 1, 'las-minas', 7.79581000, -80.74570000),
(1080309, 1001389, 'PA', 'Leones Arriba', 1, 'leones-arriba', 7.76590000, -80.84515000),
(1080312, 1001389, 'PA', 'Limón de Tijeras', 1, 'limon-de-tijeras', 7.81756000, -80.91335000),
(1080314, 1001389, 'PA', 'Llano Bonito', 1, 'llano-bonito', 7.97637000, -80.41646000),
(1080321, 1001389, 'PA', 'Llano de La Cruz', 1, 'llano-de-la-cruz', 7.95178000, -80.64239000),
(1080315, 1001389, 'PA', 'Llano Grande', 1, 'llano-grande', 7.97406000, -80.71103000),
(1080330, 1001389, 'PA', 'Los Canelos', 1, 'los-canelos', 8.11722000, -80.70769000),
(1080331, 1001389, 'PA', 'Los Castillos', 1, 'los-castillos', 7.98565000, -80.61886000),
(1080333, 1001389, 'PA', 'Los Cerritos', 1, 'los-cerritos', 7.79746000, -80.61071000),
(1080334, 1001389, 'PA', 'Los Cerros de Paja', 1, 'los-cerros-de-paja', 7.71821000, -80.67273000),
(1080341, 1001389, 'PA', 'Los Pozos', 1, 'los-pozos', 7.78300000, -80.64524000),
(1080358, 1001389, 'PA', 'Monagrillo', 1, 'monagrillo', 7.98179000, -80.43764000),
(1080382, 1001389, 'PA', 'Ocú', 1, 'ocu', 7.94052000, -80.77936000),
(1080401, 1001389, 'PA', 'París', 1, 'paris', 8.05053000, -80.55409000),
(1080398, 1001389, 'PA', 'Parita', 1, 'parita', 7.99393000, -80.52097000),
(1080410, 1001389, 'PA', 'Peñas Chatas', 1, 'penas-chatas', 8.01502000, -80.80366000),
(1080408, 1001389, 'PA', 'Pesé', 1, 'pese', 7.90863000, -80.61433000),
(1080413, 1001389, 'PA', 'Pitaloza Arriba', 1, 'pitaloza-arriba', 7.64216000, -80.66788000),
(1080422, 1001389, 'PA', 'Portobelillo', 1, 'portobelillo', 8.01738000, -80.59538000),
(1080427, 1001389, 'PA', 'Potuga', 1, 'potuga', 8.06317000, -80.62271000),
(1080448, 1001389, 'PA', 'Quebrada del Rosario', 1, 'quebrada-del-rosario', 7.71238000, -80.74222000),
(1080453, 1001389, 'PA', 'Rincón Hondo', 1, 'rincon-hondo', 7.84436000, -80.60397000),
(1080467, 1001389, 'PA', 'Sabana Grande', 1, 'sabana-grande', 7.88002000, -80.63818000),
(1080485, 1001389, 'PA', 'San Juan Bautista', 1, 'san-juan-bautista', 7.96099000, -80.41283000),
(1080504, 1001389, 'PA', 'Santa María', 1, 'santa-maria', 8.11143000, -80.66582000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001390, 'PA', 'Los Santos Province', 1, 'los-santos-province');

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 
(1079955, 1001390, 'PA', 'Agua Buena', 1, 'agua-buena', 7.83465000, -80.39405000),
(1079976, 1001390, 'PA', 'Ave María', 1, 'ave-maria', 7.32481000, -80.45361000),
(1079978, 1001390, 'PA', 'Bahía Honda', 1, 'bahia-honda', 7.70517000, -80.45342000),
(1079980, 1001390, 'PA', 'Bajo Corral', 1, 'bajo-corral', 7.60463000, -80.26016000),
(1079988, 1001390, 'PA', 'Bayano', 1, 'bayano', 7.63014000, -80.38201000),
(1079990, 1001390, 'PA', 'Bella Vista', 1, 'bella-vista', 7.75000000, -80.23333000),
(1080029, 1001390, 'PA', 'Cambutal', 1, 'cambutal', 7.26534000, -80.49105000),
(1080037, 1001390, 'PA', 'Cañas', 1, 'canas', 7.44713000, -80.26480000),
(1080042, 1001390, 'PA', 'Cedro Arriba', 1, 'cedro-arriba', 7.78097000, -80.53057000),
(1080111, 1001390, 'PA', 'Distrito de Guararé', 1, 'distrito-de-guarare', 7.77021000, -80.37515000),
(1080117, 1001390, 'PA', 'Distrito de Las Tablas', 1, 'distrito-de-las-tablas', 7.64843000, -80.29933000),
(1080119, 1001390, 'PA', 'Distrito de Los Santos', 1, 'distrito-de-los-santos', 7.88333000, -80.45000000),
(1080120, 1001390, 'PA', 'Distrito de Macaracas', 1, 'distrito-de-macaracas', 7.65817000, -80.53526000),
(1080127, 1001390, 'PA', 'Distrito de Pedasí', 1, 'distrito-de-pedasi', 7.48528000, -80.12747000),
(1080130, 1001390, 'PA', 'Distrito de Pocrí', 1, 'distrito-de-pocri', 7.63721000, -80.16470000),
(1080146, 1001390, 'PA', 'Distrito de Tonosí', 1, 'distrito-de-tonosi', 7.43597000, -80.45828000),
(1080151, 1001390, 'PA', 'El Cacao', 1, 'el-cacao', 7.44570000, -80.40938000),
(1080156, 1001390, 'PA', 'El Cañafístulo', 1, 'el-canafistulo', 7.61768000, -80.23322000),
(1080155, 1001390, 'PA', 'El Carate', 1, 'el-carate', 7.73124000, -80.29691000),
(1080161, 1001390, 'PA', 'El Cocal', 1, 'el-cocal', 7.73697000, -80.27980000),
(1080166, 1001390, 'PA', 'El Cortezo', 1, 'el-cortezo', 7.42661000, -80.63311000),
(1080169, 1001390, 'PA', 'El Ejido', 1, 'el-ejido', 7.91634000, -80.38686000),
(1080176, 1001390, 'PA', 'El Guásimo', 1, 'el-guasimo', 7.80640000, -80.52991000),
(1080177, 1001390, 'PA', 'El Hato', 1, 'el-hato', 7.79316000, -80.38267000),
(1080180, 1001390, 'PA', 'El Macano', 1, 'el-macano', 7.68489000, -80.40309000),
(1080181, 1001390, 'PA', 'El Manantial', 1, 'el-manantial', 7.78245000, -80.24713000),
(1080184, 1001390, 'PA', 'El Muñoz', 1, 'el-munoz', 7.67582000, -80.32130000),
(1080189, 1001390, 'PA', 'El Pedregoso', 1, 'el-pedregoso', 7.69173000, -80.32793000),
(1080211, 1001390, 'PA', 'Flores', 1, 'flores', 7.48157000, -80.40695000),
(1080221, 1001390, 'PA', 'Guararé', 1, 'guarare', 7.81531000, -80.28345000),
(1080222, 1001390, 'PA', 'Guararé Arriba', 1, 'guarare-arriba', 7.80023000, -80.35983000),
(1080246, 1001390, 'PA', 'La Colorada', 1, 'la-colorada', 7.82362000, -80.55552000),
(1080248, 1001390, 'PA', 'La Enea', 1, 'la-enea', 7.83333000, -80.27417000),
(1080253, 1001390, 'PA', 'La Espigadilla', 1, 'la-espigadilla', 7.88389000, -80.39039000),
(1080260, 1001390, 'PA', 'La Laja', 1, 'la-laja', 7.73102000, -80.25298000),
(1080266, 1001390, 'PA', 'La Mesa', 1, 'la-mesa', 7.65670000, -80.61794000),
(1080267, 1001390, 'PA', 'La Miel', 1, 'la-miel', 7.56022000, -80.32736000),
(1080271, 1001390, 'PA', 'La Palma', 1, 'la-palma', 7.71667000, -80.38333000),
(1080272, 1001390, 'PA', 'La Pasera', 1, 'la-pasera', 7.79757000, -80.30342000),
(1080278, 1001390, 'PA', 'La Tiza', 1, 'la-tiza', 7.75110000, -80.29216000),
(1080280, 1001390, 'PA', 'La Tronosa', 1, 'la-tronosa', 7.43609000, -80.58698000),
(1080282, 1001390, 'PA', 'Lajamina', 1, 'lajamina', 7.58587000, -80.13212000),
(1080287, 1001390, 'PA', 'Las Cruces', 1, 'las-cruces', 7.82285000, -80.43003000),
(1080290, 1001390, 'PA', 'Las Guabas', 1, 'las-guabas', 7.81469000, -80.50155000),
(1080303, 1001390, 'PA', 'Las Palmas', 1, 'las-palmas', 7.68314000, -80.49728000),
(1080304, 1001390, 'PA', 'Las Palmitas', 1, 'las-palmitas', 7.76523000, -80.29350000),
(1080306, 1001390, 'PA', 'Las Tablas', 1, 'las-tablas', 7.76472000, -80.27483000),
(1080307, 1001390, 'PA', 'Las Trancas', 1, 'las-trancas', 7.73400000, -80.37384000),
(1080313, 1001390, 'PA', 'Llano Abajo', 1, 'llano-abajo', 7.78598000, -80.41060000),
(1080322, 1001390, 'PA', 'Llano de Piedra', 1, 'llano-de-piedra', 7.65972000, -80.56347000),
(1080319, 1001390, 'PA', 'Llano Largo', 1, 'llano-largo', 7.90607000, -80.42561000),
(1080343, 1001390, 'PA', 'Los Ángeles', 1, 'los-angeles', 7.88422000, -80.35772000),
(1080329, 1001390, 'PA', 'Los Asientos', 1, 'los-asientos', 7.51656000, -80.13521000),
(1080339, 1001390, 'PA', 'Los Olivos', 1, 'los-olivos', 7.91589000, -80.48884000),
(1080342, 1001390, 'PA', 'Los Santos', 1, 'los-santos', 7.93333000, -80.41667000),
(1080346, 1001390, 'PA', 'Macaracas', 1, 'macaracas', 7.73168000, -80.55364000),
(1080357, 1001390, 'PA', 'Mogollón', 1, 'mogollon', 7.64261000, -80.45950000),
(1080369, 1001390, 'PA', 'Nuario', 1, 'nuario', 7.53047000, -80.32692000),
(1080385, 1001390, 'PA', 'Oria Arriba', 1, 'oria-arriba', 7.50505000, -80.20567000),
(1080390, 1001390, 'PA', 'Palmira', 1, 'palmira', 7.66347000, -80.35728000),
(1080396, 1001390, 'PA', 'Paraíso', 1, 'paraiso', 7.68510000, -80.16082000),
(1080399, 1001390, 'PA', 'Paritilla', 1, 'paritilla', 7.62848000, -80.17240000),
(1080403, 1001390, 'PA', 'Pedasí', 1, 'pedasi', 7.53034000, -80.02699000),
(1080409, 1001390, 'PA', 'Peña Blanca', 1, 'pena-blanca', 7.71931000, -80.28366000),
(1080407, 1001390, 'PA', 'Perales', 1, 'perales', 7.77461000, -80.32494000),
(1080419, 1001390, 'PA', 'Pocrí', 1, 'pocri', 7.65816000, -80.12119000),
(1080463, 1001390, 'PA', 'Río Hondo', 1, 'rio-hondo', 7.71192000, -80.35904000),
(1080468, 1001390, 'PA', 'Sabana Grande', 1, 'sabana-grande', 7.83543000, -80.36490000),
(1080481, 1001390, 'PA', 'San José', 1, 'san-jose', 7.67395000, -80.24438000),
(1080496, 1001390, 'PA', 'Santa Ana Arriba', 1, 'santa-ana-arriba', 7.93300000, -80.36369000),
(1080509, 1001390, 'PA', 'Santo Domingo', 1, 'santo-domingo', 7.74614000, -80.24173000),
(1080512, 1001390, 'PA', 'Sesteadero', 1, 'sesteadero', 7.73885000, -80.24854000),
(1080526, 1001390, 'PA', 'Tonosí', 1, 'tonosi', 7.40684000, -80.44217000),
(1080529, 1001390, 'PA', 'Tres Quebradas', 1, 'tres-quebradas', 7.84018000, -80.40740000),
(1080536, 1001390, 'PA', 'Valle Rico', 1, 'valle-rico', 7.62011000, -80.35076000),
(1080538, 1001390, 'PA', 'Vallerriquito', 1, 'vallerriquito', 7.62163000, -80.31975000),
(1080544, 1001390, 'PA', 'Villa Lourdes', 1, 'villa-lourdes', 7.81141000, -80.47029000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001391, 'PA', 'Ngöbe-Buglé Comarca', 1, 'ngobe-bugle-comarca');

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 
(1079977, 1001391, 'PA', 'Bahía Azul', 1, 'bahia-azul', 9.14176000, -81.89425000),
(1079991, 1001391, 'PA', 'Besiko', 1, 'besiko', 8.54863000, -82.08980000),
(1079993, 1001391, 'PA', 'Bisira', 1, 'bisira', 8.89553000, -81.85352000),
(1079996, 1001391, 'PA', 'Boca de Balsa', 1, 'boca-de-balsa', 8.52995000, -82.03132000),
(1080009, 1001391, 'PA', 'Buenos Aires', 1, 'buenos-aires', 8.41384000, -81.48440000),
(1080028, 1001391, 'PA', 'Camarón Arriba', 1, 'camaron-arriba', 8.38324000, -81.99345000),
(1080046, 1001391, 'PA', 'Cerro Banco', 1, 'cerro-banco', 8.45797000, -82.03081000),
(1080048, 1001391, 'PA', 'Cerro Caña', 1, 'cerro-cana', 8.35174000, -81.61050000),
(1080050, 1001391, 'PA', 'Cerro Plata', 1, 'cerro-plata', 8.47733000, -81.54585000),
(1080057, 1001391, 'PA', 'Chichica', 1, 'chichica', 8.35885000, -81.66582000),
(1080226, 1001391, 'PA', 'Guayabito', 1, 'guayabito', 8.53949000, -81.48225000),
(1080230, 1001391, 'PA', 'Hato Chami', 1, 'hato-chami', 8.44281000, -81.77196000),
(1080231, 1001391, 'PA', 'Hato Corotú', 1, 'hato-corotu', 8.33516000, -81.97030000),
(1080239, 1001391, 'PA', 'Kankintú', 1, 'kankintu', 8.89503000, -81.85750000),
(1080240, 1001391, 'PA', 'Kusapín', 1, 'kusapin', 9.17119000, -81.89621000),
(1080285, 1001391, 'PA', 'Lajero Arriba', 1, 'lajero-arriba', 8.29060000, -81.77047000),
(1080323, 1001391, 'PA', 'Llano Ñopo', 1, 'llano-nopo', 8.41996000, -81.61865000),
(1080325, 1001391, 'PA', 'Loma Yuca', 1, 'loma-yuca', 8.71817000, -81.40492000),
(1080356, 1001391, 'PA', 'Mirono', 1, 'mirono', 8.40469000, -81.83064000),
(1080364, 1001391, 'PA', 'Müna', 1, 'muna', 8.35035000, -81.67219000),
(1080367, 1001391, 'PA', 'Nole Düima', 1, 'nole-duima', 8.32682000, -81.81531000),
(1080381, 1001391, 'PA', 'Nurun', 1, 'nurun', 8.47815000, -81.47015000),
(1080384, 1001391, 'PA', 'Oma', 1, 'oma', 8.35019000, -81.80177000),
(1080397, 1001391, 'PA', 'Paredón Arriba', 1, 'paredon-arriba', 8.45977000, -81.19592000),
(1080414, 1001391, 'PA', 'Plan de Chorcha', 1, 'plan-de-chorcha', 8.46168000, -82.15924000),
(1080429, 1001391, 'PA', 'Pueblo Nuevo', 1, 'pueblo-nuevo', 8.88070000, -82.22411000),
(1080444, 1001391, 'PA', 'Quebrada Canoa', 1, 'quebrada-canoa', 8.43333000, -81.78333000),
(1080445, 1001391, 'PA', 'Quebrada Tula', 1, 'quebrada-tula', 8.84037000, -81.99645000),
(1080515, 1001391, 'PA', 'Sitio Prado', 1, 'sitio-prado', 8.37233000, -81.58141000),
(1080523, 1001391, 'PA', 'Tobobe', 1, 'tobobe', 9.12111000, -81.82471000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001394, 'PA', 'Panamá Oeste Province', 1, 'panama-oeste-province');

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 
(1079966, 1001394, 'PA', 'Alto del Espino', 1, 'alto-del-espino', 8.84213000, -79.84551000),
(1079967, 1001394, 'PA', 'Altos de San Francisco', 1, 'altos-de-san-francisco', 8.86167000, -79.79000000),
(1079971, 1001394, 'PA', 'Arenosa', 1, 'arenosa', 9.03978000, -79.95128000),
(1079972, 1001394, 'PA', 'Arosemena', 1, 'arosemena', 8.97091000, -79.96641000),
(1079973, 1001394, 'PA', 'Arraiján', 1, 'arraijan', 8.95187000, -79.66011000),
(1079989, 1001394, 'PA', 'Bejuco', 1, 'bejuco', 8.60037000, -79.88988000),
(1080008, 1001394, 'PA', 'Buenos Aires', 1, 'buenos-aires', 8.63146000, -79.94775000),
(1080016, 1001394, 'PA', 'Cabuya', 1, 'cabuya', 8.57472000, -79.92714000),
(1080020, 1001394, 'PA', 'Caimito', 1, 'caimito', 8.81143000, -79.94738000),
(1080033, 1001394, 'PA', 'Capira', 1, 'capira', 8.75636000, -79.87996000),
(1080044, 1001394, 'PA', 'Cermeño', 1, 'cermeno', 8.74082000, -79.85299000),
(1080047, 1001394, 'PA', 'Cerro Cama', 1, 'cerro-cama', 9.02802000, -79.90744000),
(1080053, 1001394, 'PA', 'Chame', 1, 'chame', 8.57753000, -79.88595000),
(1080069, 1001394, 'PA', 'Cirí de Los Sotos', 1, 'ciri-de-los-sotos', 8.97206000, -80.09209000),
(1080083, 1001394, 'PA', 'Distrito Arraiján', 1, 'distrito-arraijan', 8.95000000, -79.70000000),
(1080097, 1001394, 'PA', 'Distrito de Capira', 1, 'distrito-de-capira', 8.76228000, -79.88275000),
(1080100, 1001394, 'PA', 'Distrito de Chame', 1, 'distrito-de-chame', 8.60000000, -79.91667000),
(1080112, 1001394, 'PA', 'Distrito de La Chorrera', 1, 'distrito-de-la-chorrera', 8.95000000, -79.85000000),
(1080135, 1001394, 'PA', 'Distrito de San Carlos', 1, 'distrito-de-san-carlos', 8.53196000, -80.06906000),
(1080152, 1001394, 'PA', 'El Cacao', 1, 'el-cacao', 8.76134000, -80.01294000),
(1080164, 1001394, 'PA', 'El Coco', 1, 'el-coco', 8.87009000, -79.80415000),
(1080171, 1001394, 'PA', 'El Espavé', 1, 'el-espave', 8.66161000, -79.87584000),
(1080172, 1001394, 'PA', 'El Espino', 1, 'el-espino', 8.83795000, -79.84925000),
(1080178, 1001394, 'PA', 'El Higo', 1, 'el-higo', 8.44731000, -80.03603000),
(1080179, 1001394, 'PA', 'El Líbano', 1, 'el-libano', 8.61685000, -79.83483000),
(1080219, 1001394, 'PA', 'Guadalupe', 1, 'guadalupe', 8.85452000, -79.81408000),
(1080227, 1001394, 'PA', 'Guayabito', 1, 'guayabito', 8.54828000, -80.01350000),
(1080232, 1001394, 'PA', 'Hato Montaña', 1, 'hato-montana', 8.91938000, -79.73915000),
(1080243, 1001394, 'PA', 'La Chorrera', 1, 'la-chorrera', 8.88028000, -79.78333000),
(1080250, 1001394, 'PA', 'La Ermita', 1, 'la-ermita', 8.45622000, -80.06835000),
(1080257, 1001394, 'PA', 'La Herradura', 1, 'la-herradura', 8.84848000, -79.80404000),
(1080258, 1001394, 'PA', 'La Laguna', 1, 'la-laguna', 9.04404000, -79.84215000),
(1080268, 1001394, 'PA', 'La Mitra', 1, 'la-mitra', 8.84091000, -79.78648000),
(1080273, 1001394, 'PA', 'La Pesa', 1, 'la-pesa', 8.85073000, -79.82374000),
(1080286, 1001394, 'PA', 'Las Colinas', 1, 'las-colinas', 8.55000000, -80.08333000),
(1080294, 1001394, 'PA', 'Las Lajas', 1, 'las-lajas', 8.54963000, -79.93521000),
(1080308, 1001394, 'PA', 'Las Uvas', 1, 'las-uvas', 8.45937000, -80.00075000),
(1080318, 1001394, 'PA', 'Llano Largo', 1, 'llano-largo', 8.83463000, -79.80765000),
(1080336, 1001394, 'PA', 'Los Llanitos', 1, 'los-llanitos', 8.59787000, -80.09503000),
(1080352, 1001394, 'PA', 'Mendoza', 1, 'mendoza', 9.01471000, -79.85073000),
(1080371, 1001394, 'PA', 'Nueva Arenosa', 1, 'nueva-arenosa', 8.86944000, -79.99472000),
(1080373, 1001394, 'PA', 'Nueva Gorgona', 1, 'nueva-gorgona', 8.55000000, -79.87547000),
(1080374, 1001394, 'PA', 'Nuevo Arraiján', 1, 'nuevo-arraijan', 8.92453000, -79.72004000),
(1080377, 1001394, 'PA', 'Nuevo Emperador', 1, 'nuevo-emperador', 9.00273000, -79.73141000),
(1080416, 1001394, 'PA', 'Playa Leona', 1, 'playa-leona', 8.78389000, -79.77547000),
(1080426, 1001394, 'PA', 'Potrero Grande', 1, 'potrero-grande', 8.88051000, -79.82795000),
(1080432, 1001394, 'PA', 'Puerto Caimito', 1, 'puerto-caimito', 8.87022000, -79.71423000),
(1080458, 1001394, 'PA', 'Río Congo', 1, 'rio-congo', 8.96666000, -79.76105000),
(1080475, 1001394, 'PA', 'San Carlos', 1, 'san-carlos', 8.47323000, -79.96104000),
(1080483, 1001394, 'PA', 'San José', 1, 'san-jose', 8.93333000, -79.73333000),
(1080495, 1001394, 'PA', 'San Vicente de Bique', 1, 'san-vicente-de-bique', 8.91143000, -79.67360000),
(1080498, 1001394, 'PA', 'Santa Clara', 1, 'santa-clara', 9.02875000, -79.75443000),
(1080505, 1001394, 'PA', 'Santa Rita', 1, 'santa-rita', 8.85681000, -79.87954000),
(1080518, 1001394, 'PA', 'Sorá', 1, 'sora', 8.63191000, -80.00888000),
(1080540, 1001394, 'PA', 'Veracruz', 1, 'veracruz', 8.88988000, -79.62603000),
(1080543, 1001394, 'PA', 'Villa Carmen', 1, 'villa-carmen', 8.79832000, -79.86929000),
(1080545, 1001394, 'PA', 'Villa Rosario', 1, 'villa-rosario', 8.77379000, -79.87547000),
(1080547, 1001394, 'PA', 'Vista Alegre', 1, 'vista-alegre', 8.92772000, -79.70280000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001395, 'PA', 'Panamá Province', 1, 'panama-province');

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 
(1079960, 1001395, 'PA', 'Alcalde Díaz', 1, 'alcalde-diaz', 9.12016000, -79.55641000),
(1079968, 1001395, 'PA', 'Ancón', 1, 'ancon', 8.96015000, -79.55140000),
(1080006, 1001395, 'PA', 'Brujas', 1, 'brujas', 8.58536000, -78.53008000),
(1080014, 1001395, 'PA', 'Cabra Número Uno', 1, 'cabra-numero-uno', 9.10863000, -79.33694000),
(1080018, 1001395, 'PA', 'Caimitillo', 1, 'caimitillo', 9.15559000, -79.53974000),
(1080027, 1001395, 'PA', 'Calzada Larga', 1, 'calzada-larga', 9.17272000, -79.56212000),
(1080041, 1001395, 'PA', 'Cañita', 1, 'canita', 9.22236000, -78.89509000),
(1080045, 1001395, 'PA', 'Cerro Azul', 1, 'cerro-azul', 9.15735000, -79.42097000),
(1080055, 1001395, 'PA', 'Chepillo', 1, 'chepillo', 8.95396000, -79.12856000),
(1080056, 1001395, 'PA', 'Chepo', 1, 'chepo', 9.17019000, -79.10083000),
(1080060, 1001395, 'PA', 'Chilibre', 1, 'chilibre', 9.15093000, -79.62098000),
(1080061, 1001395, 'PA', 'Chimán', 1, 'chiman', 8.69125000, -78.63570000),
(1080074, 1001395, 'PA', 'Contadora', 1, 'contadora', 8.62483000, -79.03748000),
(1080080, 1001395, 'PA', 'Curundú', 1, 'curundu', 8.97092000, -79.54612000),
(1080090, 1001395, 'PA', 'Distrito de Balboa', 1, 'distrito-de-balboa', 8.46667000, -79.00000000),
(1080103, 1001395, 'PA', 'Distrito de Chepo', 1, 'distrito-de-chepo', 9.17391000, -78.70374000),
(1080104, 1001395, 'PA', 'Distrito de Chimán', 1, 'distrito-de-chiman', 8.76043000, -78.56470000),
(1080125, 1001395, 'PA', 'Distrito de Panamá', 1, 'distrito-de-panama', 9.30612000, -79.45246000),
(1080144, 1001395, 'PA', 'Distrito de Taboga', 1, 'distrito-de-taboga', 8.78333000, -79.55833000),
(1080160, 1001395, 'PA', 'El Chorrillo', 1, 'el-chorrillo', 8.94964000, -79.54715000),
(1080196, 1001395, 'PA', 'El Progreso', 1, 'el-progreso', 9.26667000, -79.11667000),
(1080215, 1001395, 'PA', 'Gonzalillo', 1, 'gonzalillo', 9.09183000, -79.51928000),
(1080234, 1001395, 'PA', 'Howard', 1, 'howard', 8.93942000, -79.59097000),
(1080238, 1001395, 'PA', 'Juan Díaz', 1, 'juan-diaz', 9.05000000, -79.45000000),
(1080242, 1001395, 'PA', 'La Cabima', 1, 'la-cabima', 9.11865000, -79.53660000),
(1080245, 1001395, 'PA', 'La Colorada', 1, 'la-colorada', 9.10224000, -79.41600000),
(1080249, 1001395, 'PA', 'La Ensenada', 1, 'la-ensenada', 8.36618000, -78.84606000),
(1080251, 1001395, 'PA', 'La Esmeralda', 1, 'la-esmeralda', 8.26817000, -78.92460000),
(1080256, 1001395, 'PA', 'La Guinea', 1, 'la-guinea', 8.34250000, -78.93430000),
(1080264, 1001395, 'PA', 'La Mesa', 1, 'la-mesa', 9.17308000, -79.27401000),
(1080288, 1001395, 'PA', 'Las Cumbres', 1, 'las-cumbres', 9.08916000, -79.52809000),
(1080297, 1001395, 'PA', 'Las Margaritas', 1, 'las-margaritas', 9.18426000, -79.08730000),
(1080345, 1001395, 'PA', 'Lídice', 1, 'lidice', 8.74869000, -79.90974000),
(1080337, 1001395, 'PA', 'Los Lotes', 1, 'los-lotes', 9.12425000, -79.28929000),
(1080372, 1001395, 'PA', 'Nueva Esperanza', 1, 'nueva-esperanza', 9.10210000, -79.33414000),
(1080375, 1001395, 'PA', 'Nuevo Belén', 1, 'nuevo-belen', 9.07939000, -79.39556000),
(1080386, 1001395, 'PA', 'Pacora', 1, 'pacora', 9.07937000, -79.28997000),
(1080394, 1001395, 'PA', 'Panamá', 1, 'panama', 8.99360000, -79.51973000),
(1080400, 1001395, 'PA', 'Parque Lefevre', 1, 'parque-lefevre', 9.01667000, -79.48333000),
(1080441, 1001395, 'PA', 'Pásiga', 1, 'pasiga', 8.93647000, -78.90917000),
(1080404, 1001395, 'PA', 'Pedregal', 1, 'pedregal', 9.06667000, -79.43333000),
(1080456, 1001395, 'PA', 'Río Abajo', 1, 'rio-abajo', 9.01667000, -79.50000000),
(1080472, 1001395, 'PA', 'San Antonio', 1, 'san-antonio', 9.17290000, -79.54743000),
(1080476, 1001395, 'PA', 'San Felipe', 1, 'san-felipe', 8.95118000, -79.53726000),
(1080489, 1001395, 'PA', 'San Miguel', 1, 'san-miguel', 8.45685000, -78.93695000),
(1080490, 1001395, 'PA', 'San Miguelito', 1, 'san-miguelito', 9.05032000, -79.47068000),
(1080494, 1001395, 'PA', 'San Vicente', 1, 'san-vicente', 9.11445000, -79.59755000),
(1080524, 1001395, 'PA', 'Tocumen', 1, 'tocumen', 9.08939000, -79.38310000),
(1080527, 1001395, 'PA', 'Tortí', 1, 'torti', 8.92132000, -78.40546000),
(1080533, 1001395, 'PA', 'Unión de Azuero', 1, 'union-de-azuero', 9.15256000, -79.17005000),
(1080532, 1001395, 'PA', 'Unión Santeña', 1, 'union-santena', 8.83525000, -78.65104000),
(1080546, 1001395, 'PA', 'Villa Unida', 1, 'villa-unida', 9.18908000, -79.62452000),
(1080549, 1001395, 'PA', 'Vista Hermosa', 1, 'vista-hermosa', 9.11178000, -79.36113000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001392, 'PA', 'Veraguas Province', 1, 'veraguas-province');

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 
(1079964, 1001392, 'PA', 'Alto de Jesús', 1, 'alto-de-jesus', 8.26152000, -81.48412000),
(1079970, 1001392, 'PA', 'Arenas', 1, 'arenas', 7.36865000, -80.86268000),
(1079975, 1001392, 'PA', 'Atalaya', 1, 'atalaya', 8.04213000, -80.92528000),
(1079981, 1001392, 'PA', 'Barnizal', 1, 'barnizal', 8.40460000, -80.77765000),
(1079994, 1001392, 'PA', 'Bisvalles', 1, 'bisvalles', 8.18298000, -81.22092000),
(1080001, 1001392, 'PA', 'Boquerón', 1, 'boqueron', 8.24414000, -80.85897000),
(1080004, 1001392, 'PA', 'Boró', 1, 'boro', 8.16933000, -81.30071000),
(1080022, 1001392, 'PA', 'Calabacito', 1, 'calabacito', 8.24817000, -81.08187000),
(1080024, 1001392, 'PA', 'Calidonia', 1, 'calidonia', 7.95756000, -81.38633000),
(1080025, 1001392, 'PA', 'Calobre', 1, 'calobre', 8.31886000, -80.84067000),
(1080026, 1001392, 'PA', 'Calovébora', 1, 'calovebora', 8.78703000, -81.21056000),
(1080040, 1001392, 'PA', 'Cañazas', 1, 'canazas', 8.32004000, -81.21152000),
(1080031, 1001392, 'PA', 'Canto del Llano', 1, 'canto-del-llano', 8.12472000, -80.96374000),
(1080077, 1001392, 'PA', 'Corozal', 1, 'corozal', 8.07712000, -81.43990000),
(1080089, 1001392, 'PA', 'Distrito de Atalaya', 1, 'distrito-de-atalaya', 8.02899000, -80.91739000),
(1080096, 1001392, 'PA', 'Distrito de Calobre', 1, 'distrito-de-calobre', 8.39684000, -80.85124000),
(1080098, 1001392, 'PA', 'Distrito de Cañazas', 1, 'distrito-de-canazas', 8.35596000, -81.28633000),
(1080113, 1001392, 'PA', 'Distrito de La Mesa', 1, 'distrito-de-la-mesa', 8.10976000, -81.17767000),
(1080116, 1001392, 'PA', 'Distrito de Las Palmas', 1, 'distrito-de-las-palmas', 8.14532000, -81.42849000),
(1080121, 1001392, 'PA', 'Distrito de Montijo', 1, 'distrito-de-montijo', 7.95316000, -81.05301000),
(1080134, 1001392, 'PA', 'Distrito de Río de Jesús', 1, 'distrito-de-rio-de-jesus', 7.91438000, -81.16133000),
(1080136, 1001392, 'PA', 'Distrito de San Francisco', 1, 'distrito-de-san-francisco', 8.26965000, -81.00108000),
(1080139, 1001392, 'PA', 'Distrito de Santa Fé', 1, 'distrito-de-santa-fe', 8.72063000, -80.95858000),
(1080142, 1001392, 'PA', 'Distrito de Santiago', 1, 'distrito-de-santiago', 8.12425000, -80.87827000),
(1080143, 1001392, 'PA', 'Distrito de Soná', 1, 'distrito-de-sona', 7.84378000, -81.36612000),
(1080149, 1001392, 'PA', 'El Alto', 1, 'el-alto', 8.51191000, -81.03646000),
(1080150, 1001392, 'PA', 'El Barrito', 1, 'el-barrito', 7.96059000, -80.94801000),
(1080162, 1001392, 'PA', 'El Coclá', 1, 'el-cocla', 8.32143000, -80.92069000),
(1080173, 1001392, 'PA', 'El Espino de Santa Rosa', 1, 'el-espino-de-santa-rosa', 8.09286000, -80.82380000),
(1080182, 1001392, 'PA', 'El Marañón', 1, 'el-maranon', 8.03582000, -81.21489000),
(1080183, 1001392, 'PA', 'El María', 1, 'el-maria', 8.02905000, -81.44384000),
(1080197, 1001392, 'PA', 'El Pájaro', 1, 'el-pajaro', 7.95342000, -81.12154000),
(1080187, 1001392, 'PA', 'El Pantano', 1, 'el-pantano', 8.53755000, -81.06941000),
(1080190, 1001392, 'PA', 'El Peñón', 1, 'el-penon', 8.35000000, -80.97620000),
(1080191, 1001392, 'PA', 'El Picador', 1, 'el-picador', 8.37803000, -81.25621000),
(1080195, 1001392, 'PA', 'El Potrero', 1, 'el-potrero', 8.37692000, -80.79434000),
(1080200, 1001392, 'PA', 'El Rincón', 1, 'el-rincon', 8.18422000, -81.43333000),
(1080205, 1001392, 'PA', 'El Uvito', 1, 'el-uvito', 8.11648000, -80.98461000),
(1080224, 1001392, 'PA', 'Guarumal', 1, 'guarumal', 7.79404000, -81.25904000),
(1080244, 1001392, 'PA', 'La Colorada', 1, 'la-colorada', 8.01319000, -80.98590000),
(1080255, 1001392, 'PA', 'La Garceana', 1, 'la-garceana', 7.93708000, -81.01643000),
(1080259, 1001392, 'PA', 'La Laguna', 1, 'la-laguna', 8.33882000, -80.72949000),
(1080262, 1001392, 'PA', 'La Loma', 1, 'la-loma', 7.43708000, -80.89118000),
(1080263, 1001392, 'PA', 'La Mesa', 1, 'la-mesa', 8.14707000, -81.18114000),
(1080269, 1001392, 'PA', 'La Montañuela', 1, 'la-montanuela', 8.02487000, -80.86325000),
(1080274, 1001392, 'PA', 'La Peña', 1, 'la-pena', 8.12784000, -81.02693000),
(1080276, 1001392, 'PA', 'La Raya de Calobre', 1, 'la-raya-de-calobre', 8.21630000, -80.82729000),
(1080277, 1001392, 'PA', 'La Raya de Santa María', 1, 'la-raya-de-santa-maria', 8.16429000, -80.82143000),
(1080281, 1001392, 'PA', 'La Yeguada', 1, 'la-yeguada', 8.43060000, -80.85752000),
(1080291, 1001392, 'PA', 'Las Guías Abajo', 1, 'las-guias-abajo', 8.19451000, -80.75494000),
(1080292, 1001392, 'PA', 'Las Huacas', 1, 'las-huacas', 7.90167000, -81.14056000),
(1080302, 1001392, 'PA', 'Las Palmas', 1, 'las-palmas', 8.13564000, -81.45674000),
(1080310, 1001392, 'PA', 'Leones Arriba', 1, 'leones-arriba', 7.75415000, -81.11556000),
(1080316, 1001392, 'PA', 'Llano Grande', 1, 'llano-grande', 8.07473000, -81.13626000),
(1080324, 1001392, 'PA', 'Lolá', 1, 'lola', 8.09326000, -81.47163000),
(1080327, 1001392, 'PA', 'Los Algarrobos', 1, 'los-algarrobos', 8.10898000, -81.01355000),
(1080332, 1001392, 'PA', 'Los Castillos', 1, 'los-castillos', 8.02326000, -81.11941000),
(1080335, 1001392, 'PA', 'Los Higos', 1, 'los-higos', 8.20553000, -80.86022000),
(1080349, 1001392, 'PA', 'Mariato District', 1, 'mariato-district', 7.67810000, -81.00409000),
(1080359, 1001392, 'PA', 'Monjarás', 1, 'monjaras', 8.36942000, -80.86667000),
(1080361, 1001392, 'PA', 'Montijo', 1, 'montijo', 7.98858000, -81.05643000),
(1080412, 1001392, 'PA', 'Piedras Gordas', 1, 'piedras-gordas', 8.52419000, -80.91152000),
(1080421, 1001392, 'PA', 'Ponuga', 1, 'ponuga', 7.88245000, -80.97880000),
(1080436, 1001392, 'PA', 'Puerto Vidal', 1, 'puerto-vidal', 8.04834000, -81.60499000),
(1080446, 1001392, 'PA', 'Quebrada de Oro', 1, 'quebrada-de-oro', 8.03548000, -81.38692000),
(1080466, 1001392, 'PA', 'Río de Jesús', 1, 'rio-de-jesus', 7.97882000, -81.16162000),
(1080461, 1001392, 'PA', 'Río Grande', 1, 'rio-grande', 7.71907000, -81.33423000),
(1080454, 1001392, 'PA', 'Rodeo Viejo', 1, 'rodeo-viejo', 8.11205000, -81.31684000),
(1080473, 1001392, 'PA', 'San Bartolo', 1, 'san-bartolo', 8.21063000, -81.27572000),
(1080477, 1001392, 'PA', 'San Francisco', 1, 'san-francisco', 8.06667000, -81.36667000),
(1080482, 1001392, 'PA', 'San José', 1, 'san-jose', 8.46704000, -80.80514000),
(1080484, 1001392, 'PA', 'San Juan', 1, 'san-juan', 8.30311000, -81.01575000),
(1080488, 1001392, 'PA', 'San Marcelo', 1, 'san-marcelo', 8.27252000, -81.15988000),
(1080493, 1001392, 'PA', 'San Pedro del Espino', 1, 'san-pedro-del-espino', 8.14011000, -81.08663000),
(1080501, 1001392, 'PA', 'Santa Fé', 1, 'santa-fe', 8.51063000, -81.07802000),
(1080508, 1001392, 'PA', 'Santiago de Veraguas', 1, 'santiago-de-veraguas', 8.10000000, -80.98333000),
(1080516, 1001392, 'PA', 'Soná', 1, 'sona', 8.01223000, -81.32163000),
(1080519, 1001392, 'PA', 'Tebario', 1, 'tebario', 7.71369000, -80.97825000),
(1080535, 1001392, 'PA', 'Utirá', 1, 'utira', 7.97208000, -81.21777000),
(1080542, 1001392, 'PA', 'Viguí', 1, 'vigui', 8.33921000, -81.49823000),
(1080553, 1001392, 'PA', 'Zapotillo', 1, 'zapotillo', 8.00532000, -81.50653000);

