REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('PT', 'Portugal', 'portugal', '351', 'Portugal', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002235, 'PT', 'Aveiro District', 1, 'aveiro-district');

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 
(1088910, 1002235, 'PT', 'Aguada de Cima', 1, 'aguada-de-cima', 40.52291000, -8.42700000),
(1089695, 1002235, 'PT', 'Águeda', 1, 'agueda', 40.57720000, -8.44442000),
(1088913, 1002235, 'PT', 'Albergaria-a-Velha', 1, 'albergaria-a-velha', 40.68706000, -8.50399000),
(1088967, 1002235, 'PT', 'Anadia', 1, 'anadia', 40.43841000, -8.43352000),
(1088976, 1002235, 'PT', 'Aradas', 1, 'aradas', 40.62084000, -8.64195000),
(1088980, 1002235, 'PT', 'Arcos', 1, 'arcos', 40.44779000, -8.44171000),
(1088986, 1002235, 'PT', 'Argoncilhe', 1, 'argoncilhe', 41.02541000, -8.53885000),
(1088989, 1002235, 'PT', 'Arouca', 1, 'arouca', 40.92658000, -8.27251000),
(1088993, 1002235, 'PT', 'Arrifana', 1, 'arrifana', 40.91565000, -8.49657000),
(1089001, 1002235, 'PT', 'Avanca', 1, 'avanca', 40.80771000, -8.57220000),
(1089003, 1002235, 'PT', 'Aveiro', 1, 'aveiro', 40.64427000, -8.64554000),
(1089025, 1002235, 'PT', 'Beduido', 1, 'beduido', 40.76427000, -8.56110000),
(1089048, 1002235, 'PT', 'Branca', 1, 'branca', 40.76653000, -8.48262000),
(1089106, 1002235, 'PT', 'Castelo de Paiva', 1, 'castelo-de-paiva', 41.03353000, -8.29822000),
(1089129, 1002235, 'PT', 'Cortegaça', 1, 'cortegaca', 40.94883000, -8.62130000),
(1089137, 1002235, 'PT', 'Cucujães', 1, 'cucujaes', 40.87413000, -8.50687000),
(1089141, 1002235, 'PT', 'Eixo', 1, 'eixo', 40.62758000, -8.56922000),
(1089147, 1002235, 'PT', 'Esgueira', 1, 'esgueira', 40.64899000, -8.62943000),
(1089148, 1002235, 'PT', 'Esmoriz', 1, 'esmoriz', 40.95773000, -8.62753000),
(1089149, 1002235, 'PT', 'Espargo', 1, 'espargo', 40.92462000, -8.57495000),
(1089150, 1002235, 'PT', 'Espinho', 1, 'espinho', 41.00763000, -8.64125000),
(1089153, 1002235, 'PT', 'Estarreja', 1, 'estarreja', 40.75463000, -8.57917000),
(1089170, 1002235, 'PT', 'Feira', 1, 'feira', 40.92535000, -8.54277000),
(1089185, 1002235, 'PT', 'Fiães', 1, 'fiaes', 40.99446000, -8.52537000),
(1089203, 1002235, 'PT', 'Gafanha da Encarnação', 1, 'gafanha-da-encarnacao', 40.61806000, -8.73303000),
(1089204, 1002235, 'PT', 'Gafanha da Nazaré', 1, 'gafanha-da-nazare', 40.63621000, -8.71338000),
(1089698, 1002235, 'PT', 'Ílhavo', 1, 'ilhavo', 40.60188000, -8.67021000),
(1089234, 1002235, 'PT', 'Lamas', 1, 'lamas', 40.98597000, -8.56923000),
(1089246, 1002235, 'PT', 'Lobão', 1, 'lobao', 40.98664000, -8.48566000),
(1089254, 1002235, 'PT', 'Lourosa', 1, 'lourosa', 40.98420000, -8.55142000),
(1089257, 1002235, 'PT', 'Luso', 1, 'luso', 40.38429000, -8.37845000),
(1089263, 1002235, 'PT', 'Macieira de Cambra', 1, 'macieira-de-cambra', 40.85939000, -8.37338000),
(1089287, 1002235, 'PT', 'Mealhada', 1, 'mealhada', 40.36273000, -8.44781000),
(1089298, 1002235, 'PT', 'Milheirós de Poiares', 1, 'milheiros-de-poiares', 40.92163000, -8.46788000),
(1089334, 1002235, 'PT', 'Mosteirô', 1, 'mosteiro', 40.89843000, -8.53196000),
(1089338, 1002235, 'PT', 'Murtosa', 1, 'murtosa', 40.74301000, -8.64023000),
(1089349, 1002235, 'PT', 'Nogueira da Regedoura', 1, 'nogueira-da-regedoura', 41.00530000, -8.59195000),
(1089355, 1002235, 'PT', 'Oiã', 1, 'oia', 40.54264000, -8.53856000),
(1089363, 1002235, 'PT', 'Oliveira de Azemeis', 1, 'oliveira-de-azemeis', 40.84101000, -8.47555000),
(1089364, 1002235, 'PT', 'Oliveira de Azeméis', 1, 'oliveira-de-azemeis', 40.85078000, -8.46945000),
(1089366, 1002235, 'PT', 'Oliveira do Bairro', 1, 'oliveira-do-bairro', 40.50977000, -8.56374000),
(1089370, 1002235, 'PT', 'Oliveirinha', 1, 'oliveirinha', 40.60715000, -8.59198000),
(1089374, 1002235, 'PT', 'Ovar', 1, 'ovar', 40.85862000, -8.62513000),
(1089387, 1002235, 'PT', 'Paços de Brandão', 1, 'pacos-de-brandao', 40.97541000, -8.58350000),
(1089379, 1002235, 'PT', 'Pampilhosa do Botão', 1, 'pampilhosa-do-botao', 40.33580000, -8.42738000),
(1089381, 1002235, 'PT', 'Pardilhó', 1, 'pardilho', 40.79925000, -8.62598000),
(1089473, 1002235, 'PT', 'Rio Meão', 1, 'rio-meao', 40.95775000, -8.57818000),
(1089484, 1002235, 'PT', 'Salreu', 1, 'salreu', 40.73971000, -8.55720000),
(1089492, 1002235, 'PT', 'Sanfins', 1, 'sanfins', 40.92979000, -8.52563000),
(1089493, 1002235, 'PT', 'Sangalhos', 1, 'sangalhos', 40.48678000, -8.46968000),
(1089507, 1002235, 'PT', 'Santa Maria da Feira', 1, 'santa-maria-da-feira', 40.96043000, -8.51545000),
(1089564, 1002235, 'PT', 'São João', 1, 'sao-joao', 40.86802000, -8.60672000),
(1089565, 1002235, 'PT', 'São João da Madeira', 1, 'sao-joao-da-madeira', 40.90070000, -8.49020000),
(1089570, 1002235, 'PT', 'São João de Ver', 1, 'sao-joao-de-ver', 40.95527000, -8.55117000),
(1089587, 1002235, 'PT', 'São Roque', 1, 'sao-roque', 40.87216000, -8.47149000),
(1089541, 1002235, 'PT', 'Sever do Vouga', 1, 'sever-do-vouga', 40.73156000, -8.35493000),
(1089542, 1002235, 'PT', 'Silvalde', 1, 'silvalde', 40.99205000, -8.62567000),
(1089554, 1002235, 'PT', 'Souto', 1, 'souto', 40.98496000, -8.62185000),
(1089619, 1002235, 'PT', 'Vagos', 1, 'vagos', 40.49943000, -8.67830000),
(1089625, 1002235, 'PT', 'Vale de Cambra', 1, 'vale-de-cambra', 40.84500000, -8.36022000),
(1089688, 1002235, 'PT', 'Válega', 1, 'valega', 40.83629000, -8.58061000),
(1089630, 1002235, 'PT', 'Valongo', 1, 'valongo', 40.61667000, -8.45000000),
(1089645, 1002235, 'PT', 'Vila Chã', 1, 'vila-cha', 40.86667000, -8.46667000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002233, 'PT', 'Azores', 1, 'azores');

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 
(1089692, 1002233, 'PT', 'Água de Pau', 1, 'agua-de-pau', 37.72142000, -25.51170000),
(1088968, 1002233, 'PT', 'Angra do Heroísmo', 1, 'angra-do-heroismo', 38.65483000, -27.21734000),
(1088969, 1002233, 'PT', 'Angústias', 1, 'angustias', 38.52547000, -28.63132000),
(1088994, 1002233, 'PT', 'Arrifes', 1, 'arrifes', 37.76667000, -25.70000000),
(1089037, 1002233, 'PT', 'Biscoitos', 1, 'biscoitos', 38.78333000, -27.25000000),
(1089057, 1002233, 'PT', 'Cabouco', 1, 'cabouco', 37.76667000, -25.56667000),
(1089062, 1002233, 'PT', 'Cais do Pico', 1, 'cais-do-pico', 38.52531000, -28.32074000),
(1089069, 1002233, 'PT', 'Calheta', 1, 'calheta', 38.60186000, -28.01792000),
(1089070, 1002233, 'PT', 'Calheta de São Jorge', 1, 'calheta-de-sao-jorge', 38.59767000, -27.91459000),
(1089105, 1002233, 'PT', 'Castelo Branco', 1, 'castelo-branco', 38.52198000, -28.71365000),
(1089131, 1002233, 'PT', 'Corvo', 1, 'corvo', 39.69771000, -31.10550000),
(1089163, 1002233, 'PT', 'Fajã de Baixo', 1, 'faja-de-baixo', 37.75000000, -25.65000000),
(1089172, 1002233, 'PT', 'Fenais da Ajuda', 1, 'fenais-da-ajuda', 37.85128000, -25.32406000),
(1089173, 1002233, 'PT', 'Fenais da Luz', 1, 'fenais-da-luz', 37.82490000, -25.64229000),
(1089181, 1002233, 'PT', 'Feteira', 1, 'feteira', 38.65429000, -27.14995000),
(1089187, 1002233, 'PT', 'Fonte Bastardo', 1, 'fonte-bastardo', 38.69201000, -27.07942000),
(1089199, 1002233, 'PT', 'Furnas', 1, 'furnas', 37.77567000, -25.31035000),
(1089223, 1002233, 'PT', 'Horta', 1, 'horta', 38.53737000, -28.62615000),
(1089228, 1002233, 'PT', 'Lagoa', 1, 'lagoa', 37.74486000, -25.57184000),
(1089231, 1002233, 'PT', 'Lajes', 1, 'lajes', 38.76352000, -27.10336000),
(1089232, 1002233, 'PT', 'Lajes das Flores', 1, 'lajes-das-flores', 39.41619000, -31.21725000),
(1089233, 1002233, 'PT', 'Lajes do Pico', 1, 'lajes-do-pico', 38.42797000, -28.17402000),
(1089267, 1002233, 'PT', 'Madalena', 1, 'madalena', 38.53642000, -28.52660000),
(1089269, 1002233, 'PT', 'Maia', 1, 'maia', 37.83247000, -25.38976000),
(1089333, 1002233, 'PT', 'Mosteiros', 1, 'mosteiros', 37.89017000, -25.81999000),
(1089350, 1002233, 'PT', 'Nordeste', 1, 'nordeste', 37.82721000, -25.22863000),
(1089412, 1002233, 'PT', 'Ponta Delgada', 1, 'ponta-delgada', 37.74230000, -25.67093000),
(1089413, 1002233, 'PT', 'Ponta Garça', 1, 'ponta-garca', 37.71667000, -25.36667000),
(1089427, 1002233, 'PT', 'Porto Judeu', 1, 'porto-judeu', 38.64814000, -27.11944000),
(1089428, 1002233, 'PT', 'Porto Martins', 1, 'porto-martins', 38.68146000, -27.05835000),
(1089434, 1002233, 'PT', 'Povoação', 1, 'povoacao', 37.76471000, -25.24487000),
(1089437, 1002233, 'PT', 'Praia da Vitória', 1, 'praia-da-vitoria', 38.73333000, -27.06667000),
(1089451, 1002233, 'PT', 'Rabo de Peixe', 1, 'rabo-de-peixe', 37.81022000, -25.58263000),
(1089460, 1002233, 'PT', 'Relva', 1, 'relva', 37.75271000, -25.71848000),
(1089466, 1002233, 'PT', 'Ribeira Grande', 1, 'ribeira-grande', 38.51667000, -28.70000000),
(1089467, 1002233, 'PT', 'Ribeira Seca', 1, 'ribeira-seca', 37.81667000, -25.53333000),
(1089469, 1002233, 'PT', 'Ribeirinha', 1, 'ribeirinha', 38.66203000, -27.18093000),
(1089479, 1002233, 'PT', 'Rosto de Cão', 1, 'rosto-de-cao', 37.75000000, -25.65000000),
(1089494, 1002233, 'PT', 'Santa Bárbara', 1, 'santa-barbara', 38.69608000, -27.33907000),
(1089502, 1002233, 'PT', 'Santa Cruz da Graciosa', 1, 'santa-cruz-da-graciosa', 39.04946000, -28.00432000),
(1089501, 1002233, 'PT', 'Santa Cruz das Flores', 1, 'santa-cruz-das-flores', 39.46984000, -31.18514000),
(1089558, 1002233, 'PT', 'São Bartolomeu', 1, 'sao-bartolomeu', 38.67491000, -27.29349000),
(1089577, 1002233, 'PT', 'São Mateus', 1, 'sao-mateus', 38.65630000, -27.26935000),
(1089586, 1002233, 'PT', 'São Roque', 1, 'sao-roque', 37.75418000, -25.64127000),
(1089588, 1002233, 'PT', 'São Roque do Pico', 1, 'sao-roque-do-pico', 38.51631000, -28.30752000),
(1089589, 1002233, 'PT', 'São Sebastião', 1, 'sao-sebastiao', 38.66584000, -27.08976000),
(1089592, 1002233, 'PT', 'São Vicente', 1, 'sao-vicente', 37.81829000, -25.66583000),
(1089529, 1002233, 'PT', 'Senhora do Rosário', 1, 'senhora-do-rosario', 37.83333000, -25.15000000),
(1089633, 1002233, 'PT', 'Velas', 1, 'velas', 38.67995000, -28.15155000),
(1089673, 1002233, 'PT', 'Vila do Porto', 1, 'vila-do-porto', 36.97454000, -25.09967000),
(1089650, 1002233, 'PT', 'Vila Franca do Campo', 1, 'vila-franca-do-campo', 37.71667000, -25.43333000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002230, 'PT', 'Beja District', 1, 'beja-district');

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 
(1088925, 1002230, 'PT', 'Aldeia Nova de São Bento', 1, 'aldeia-nova-de-sao-bento', 37.92603000, -7.40804000),
(1088944, 1002230, 'PT', 'Aljustrel', 1, 'aljustrel', 37.87759000, -8.16516000),
(1088949, 1002230, 'PT', 'Almodôvar', 1, 'almodovar', 37.49590000, -8.09372000),
(1088950, 1002230, 'PT', 'Almograve', 1, 'almograve', 37.65665000, -8.79214000),
(1088957, 1002230, 'PT', 'Alvito', 1, 'alvito', 38.24653000, -8.05038000),
(1089020, 1002230, 'PT', 'Barrancos', 1, 'barrancos', 38.13446000, -6.97604000),
(1089027, 1002230, 'PT', 'Beja', 1, 'beja', 38.01506000, -7.86323000),
(1089036, 1002230, 'PT', 'Beringel', 1, 'beringel', 38.05656000, -7.98427000),
(1089039, 1002230, 'PT', 'Boavista dos Pinheiros', 1, 'boavista-dos-pinheiros', 37.58058000, -8.66441000),
(1089056, 1002230, 'PT', 'Cabeça Gorda', 1, 'cabeca-gorda', 37.92401000, -7.79290000),
(1089111, 1002230, 'PT', 'Castro Verde', 1, 'castro-verde', 37.69828000, -8.08581000),
(1089136, 1002230, 'PT', 'Cuba', 1, 'cuba', 38.21972000, -7.92114000),
(1089176, 1002230, 'PT', 'Ferreira do Alentejo', 1, 'ferreira-do-alentejo', 38.05000000, -8.03333000),
(1089340, 1002230, 'PT', 'Mértola', 1, 'mertola', 37.65918000, -7.66434000),
(1089299, 1002230, 'PT', 'Minas de São Domingos', 1, 'minas-de-sao-domingos', 37.67322000, -7.49765000),
(1089335, 1002230, 'PT', 'Moura', 1, 'moura', 38.14010000, -7.44856000),
(1089346, 1002230, 'PT', 'Neves', 1, 'neves', 38.02270000, -7.81344000),
(1089352, 1002230, 'PT', 'Odemira', 1, 'odemira', 37.59798000, -8.63972000),
(1089372, 1002230, 'PT', 'Ourique', 1, 'ourique', 37.69156000, -8.31031000),
(1089397, 1002230, 'PT', 'Penedo Gordo', 1, 'penedo-gordo', 37.98477000, -7.91651000),
(1089485, 1002230, 'PT', 'Salvada', 1, 'salvada', 37.93771000, -7.77448000),
(1089572, 1002230, 'PT', 'São Luis', 1, 'sao-luis', 37.71556000, -8.66472000),
(1089590, 1002230, 'PT', 'São Teotónio', 1, 'sao-teotonio', 37.51282000, -8.70708000),
(1089533, 1002230, 'PT', 'Serpa', 1, 'serpa', 37.95201000, -7.47534000),
(1089642, 1002230, 'PT', 'Vidigueira', 1, 'vidigueira', 38.18448000, -7.74469000),
(1089658, 1002230, 'PT', 'Vila Nova de Milfontes', 1, 'vila-nova-de-milfontes', 37.72377000, -8.78278000),
(1089690, 1002230, 'PT', 'Zambujeira do Mar', 1, 'zambujeira-do-mar', 37.52799000, -8.78483000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002244, 'PT', 'Braga District', 1, 'braga-district');

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 
(1088909, 1002244, 'PT', 'Adaúfe', 1, 'adaufe', 41.58732000, -8.39817000),
(1088962, 1002244, 'PT', 'Amares', 1, 'amares', 41.64718000, -8.35558000),
(1088974, 1002244, 'PT', 'Apúlia', 1, 'apulia', 41.48512000, -8.76413000),
(1088975, 1002244, 'PT', 'Apúlia e Fão', 1, 'apulia-e-fao', 41.51194000, -8.77288000),
(1088979, 1002244, 'PT', 'Arcos', 1, 'arcos', 41.52185000, -8.42151000),
(1088997, 1002244, 'PT', 'Arões', 1, 'aroes', 41.45553000, -8.21419000),
(1089004, 1002244, 'PT', 'Aveleda', 1, 'aveleda', 41.52113000, -8.46682000),
(1089018, 1002244, 'PT', 'Barcelos', 1, 'barcelos', 41.53174000, -8.61843000),
(1089019, 1002244, 'PT', 'Barqueiros', 1, 'barqueiros', 41.49111000, -8.73192000),
(1089046, 1002244, 'PT', 'Braga', 1, 'braga', 41.55032000, -8.42005000),
(1089049, 1002244, 'PT', 'Brito', 1, 'brito', 41.45821000, -8.36103000),
(1089055, 1002244, 'PT', 'Cabeceiras de Basto', 1, 'cabeceiras-de-basto', 41.52079000, -7.97198000),
(1089064, 1002244, 'PT', 'Caldas das Taipas', 1, 'caldas-das-taipas', 41.48465000, -8.34850000),
(1089065, 1002244, 'PT', 'Caldas de Vizela', 1, 'caldas-de-vizela', 41.38212000, -8.30890000),
(1089066, 1002244, 'PT', 'Caldelas', 1, 'caldelas', 41.67101000, -8.38148000),
(1089067, 1002244, 'PT', 'Calendário', 1, 'calendario', 41.40361000, -8.52967000),
(1089081, 1002244, 'PT', 'Candoso', 1, 'candoso', 41.42768000, -8.32166000),
(1089114, 1002244, 'PT', 'Celorico de Basto', 1, 'celorico-de-basto', 41.40278000, -8.03346000),
(1089120, 1002244, 'PT', 'Chavão', 1, 'chavao', 41.45235000, -8.60194000),
(1089135, 1002244, 'PT', 'Cristelo', 1, 'cristelo', 41.47964000, -8.69785000),
(1089151, 1002244, 'PT', 'Esporões', 1, 'esporoes', 41.51006000, -8.41729000),
(1089152, 1002244, 'PT', 'Esposende', 1, 'esposende', 41.53610000, -8.78201000),
(1089160, 1002244, 'PT', 'Fafe', 1, 'fafe', 41.46837000, -8.15863000),
(1089166, 1002244, 'PT', 'Faria', 1, 'faria', 41.48298000, -8.67152000),
(1089179, 1002244, 'PT', 'Ferreiros', 1, 'ferreiros', 41.35000000, -8.55000000),
(1089191, 1002244, 'PT', 'Fradelos', 1, 'fradelos', 41.36846000, -8.59887000),
(1089196, 1002244, 'PT', 'Frossos', 1, 'frossos', 41.56590000, -8.45134000),
(1089205, 1002244, 'PT', 'Galegos', 1, 'galegos', 41.56268000, -8.57204000),
(1089207, 1002244, 'PT', 'Gandra', 1, 'gandra', 41.52185000, -8.76185000),
(1089212, 1002244, 'PT', 'Gondizalves', 1, 'gondizalves', 41.54158000, -8.45570000),
(1089216, 1002244, 'PT', 'Gueral', 1, 'gueral', 41.45859000, -8.62946000),
(1089219, 1002244, 'PT', 'Guimarães', 1, 'guimaraes', 41.44384000, -8.28918000),
(1089220, 1002244, 'PT', 'Guisande', 1, 'guisande', 41.48264000, -8.44564000),
(1089225, 1002244, 'PT', 'Joane', 1, 'joane', 41.43906000, -8.40846000),
(1089227, 1002244, 'PT', 'Lago', 1, 'lago', 41.62148000, -8.41258000),
(1089248, 1002244, 'PT', 'Lordelo', 1, 'lordelo', 41.37411000, -8.38016000),
(1089264, 1002244, 'PT', 'Macieira de Rates', 1, 'macieira-de-rates', 41.44092000, -8.63426000),
(1089279, 1002244, 'PT', 'Marinhas', 1, 'marinhas', 41.55906000, -8.78297000),
(1089280, 1002244, 'PT', 'Mariz', 1, 'mariz', 41.52823000, -8.67081000),
(1089293, 1002244, 'PT', 'Merelim', 1, 'merelim', 41.58568000, -8.46555000),
(1089330, 1002244, 'PT', 'Moreira de Conegos', 1, 'moreira-de-conegos', 41.38680000, -8.33940000),
(1089343, 1002244, 'PT', 'Negreiros', 1, 'negreiros', 41.43552000, -8.61398000),
(1089362, 1002244, 'PT', 'Oliveira', 1, 'oliveira', 41.47819000, -8.46965000),
(1089402, 1002244, 'PT', 'Perelhal', 1, 'perelhal', 41.53075000, -8.68982000),
(1089415, 1002244, 'PT', 'Ponte', 1, 'ponte', 41.47057000, -8.32990000),
(1089442, 1002244, 'PT', 'Póvoa de Lanhoso', 1, 'povoa-de-lanhoso', 41.57599000, -8.27008000),
(1089435, 1002244, 'PT', 'Prado', 1, 'prado', 41.60246000, -8.46297000),
(1089453, 1002244, 'PT', 'Real', 1, 'real', 41.55841000, -8.44330000),
(1089458, 1002244, 'PT', 'Refojos de Basto', 1, 'refojos-de-basto', 41.51318000, -7.99517000),
(1089461, 1002244, 'PT', 'Rendufe', 1, 'rendufe', 41.62898000, -8.40858000),
(1089464, 1002244, 'PT', 'Riba de Ave', 1, 'riba-de-ave', 41.39648000, -8.38685000),
(1089470, 1002244, 'PT', 'Ribeirão', 1, 'ribeirao', 41.36081000, -8.56774000),
(1089477, 1002244, 'PT', 'Ronfe', 1, 'ronfe', 41.44146000, -8.38412000),
(1089490, 1002244, 'PT', 'Sande', 1, 'sande', 41.70190000, -8.39246000),
(1089524, 1002244, 'PT', 'Selho', 1, 'selho', 41.41938000, -8.34599000),
(1089525, 1002244, 'PT', 'Semelhe', 1, 'semelhe', 41.55437000, -8.46281000),
(1089536, 1002244, 'PT', 'Serzedelo', 1, 'serzedelo', 41.40128000, -8.36888000),
(1089537, 1002244, 'PT', 'Serzedo', 1, 'serzedo', 41.40502000, -8.22926000),
(1089598, 1002244, 'PT', 'Tebosa', 1, 'tebosa', 41.48253000, -8.48399000),
(1089601, 1002244, 'PT', 'Terras de Bouro', 1, 'terras-de-bouro', 41.73914000, -8.19109000),
(1089618, 1002244, 'PT', 'Urgeses', 1, 'urgeses', 41.42720000, -8.29796000),
(1089689, 1002244, 'PT', 'Várzea', 1, 'varzea', 41.51512000, -8.58400000),
(1089644, 1002244, 'PT', 'Vieira do Minho', 1, 'vieira-do-minho', 41.63557000, -8.13244000),
(1089647, 1002244, 'PT', 'Vila Cova', 1, 'vila-cova', 41.55107000, -8.71645000),
(1089651, 1002244, 'PT', 'Vila Frescainha', 1, 'vila-frescainha', 41.53846000, -8.63971000),
(1089656, 1002244, 'PT', 'Vila Nova de Famalicão', 1, 'vila-nova-de-famalicao', 41.40797000, -8.51978000),
(1089665, 1002244, 'PT', 'Vila Seca', 1, 'vila-seca', 41.50031000, -8.68525000),
(1089668, 1002244, 'PT', 'Vila Verde', 1, 'vila-verde', 41.64869000, -8.43628000),
(1089679, 1002244, 'PT', 'Vilaça', 1, 'vilaca', 41.51787000, -8.48357000),
(1089676, 1002244, 'PT', 'Vilar de Figos', 1, 'vilar-de-figos', 41.47555000, -8.65382000),
(1089686, 1002244, 'PT', 'Vizela', 1, 'vizela', 41.37529000, -8.29310000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002229, 'PT', 'Bragança District', 1, 'braganca-district');

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 
(1088934, 1002229, 'PT', 'Alfândega da Fé', 1, 'alfandega-da-fe', 41.34315000, -6.96112000),
(1089030, 1002229, 'PT', 'Belver', 1, 'belver', 41.24696000, -7.27594000),
(1089047, 1002229, 'PT', 'Bragança Municipality', 1, 'braganca-municipality', 41.75608000, -6.75535000),
(1089094, 1002229, 'PT', 'Carrazeda de Anciães', 1, 'carrazeda-de-anciaes', 41.24247000, -7.30721000),
(1089095, 1002229, 'PT', 'Carrazeda de Ansiães', 1, 'carrazeda-de-ansiaes', 41.23424000, -7.31129000),
(1089194, 1002229, 'PT', 'Freixo de Espada à Cinta', 1, 'freixo-de-espada-a-cinta', 41.09033000, -6.80648000),
(1089260, 1002229, 'PT', 'Macedo de Cavaleiros', 1, 'macedo-de-cavaleiros', 41.55132000, -6.93355000),
(1089305, 1002229, 'PT', 'Miranda do Douro', 1, 'miranda-do-douro', 41.49692000, -6.27308000),
(1089306, 1002229, 'PT', 'Mirandela', 1, 'mirandela', 41.50098000, -7.19185000),
(1089307, 1002229, 'PT', 'Mogadouro', 1, 'mogadouro', 41.34034000, -6.71187000),
(1089487, 1002229, 'PT', 'Samil', 1, 'samil', 41.77632000, -6.75698000),
(1089526, 1002229, 'PT', 'Sendim', 1, 'sendim', 41.38739000, -6.42625000),
(1089606, 1002229, 'PT', 'Torre de Moncorvo', 1, 'torre-de-moncorvo', 41.17454000, -7.05364000),
(1089648, 1002229, 'PT', 'Vila Flor', 1, 'vila-flor', 41.31429000, -7.15071000),
(1089682, 1002229, 'PT', 'Vimioso', 1, 'vimioso', 41.57287000, -6.52087000),
(1089683, 1002229, 'PT', 'Vinhais', 1, 'vinhais', 41.83509000, -7.00501000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002241, 'PT', 'Castelo Branco District', 1, 'castelo-branco-district');

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 
(1088926, 1002241, 'PT', 'Aldeia de Joanes', 1, 'aldeia-de-joanes', 40.13905000, -7.51694000),
(1089029, 1002241, 'PT', 'Belmonte', 1, 'belmonte', 40.36181000, -7.35157000),
(1089104, 1002241, 'PT', 'Castelo Branco', 1, 'castelo-branco', 39.82219000, -7.49087000),
(1089133, 1002241, 'PT', 'Covilhã', 1, 'covilha', 40.28106000, -7.50504000),
(1089198, 1002241, 'PT', 'Fundão', 1, 'fundao', 40.12412000, -7.49542000),
(1089224, 1002241, 'PT', 'Idanha-A-Nova', 1, 'idanha-a-nova', 39.92957000, -7.23690000),
(1089356, 1002241, 'PT', 'Oleiros', 1, 'oleiros', 39.94948000, -7.88592000),
(1089396, 1002241, 'PT', 'Penamacor', 1, 'penamacor', 40.15495000, -7.17149000),
(1089440, 1002241, 'PT', 'Proença-a-Nova', 1, 'proenca-a-nova', 39.75700000, -7.92595000),
(1089535, 1002241, 'PT', 'Sertã', 1, 'serta', 39.80205000, -8.09589000),
(1089599, 1002241, 'PT', 'Teixoso', 1, 'teixoso', 40.31448000, -7.45759000),
(1089670, 1002241, 'PT', 'Vila de Rei', 1, 'vila-de-rei', 39.70685000, -8.12836000),
(1089666, 1002241, 'PT', 'Vila Velha de Ródão', 1, 'vila-velha-de-rodao', 39.68709000, -7.65987000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002246, 'PT', 'Coimbra District', 1, 'coimbra-district');

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 
(1088929, 1002246, 'PT', 'Alfarelos', 1, 'alfarelos', 40.15057000, -8.65326000),
(1088938, 1002246, 'PT', 'Alhadas', 1, 'alhadas', 40.18607000, -8.79057000),
(1088972, 1002246, 'PT', 'Ançã', 1, 'anca', 40.27161000, -8.52090000),
(1088977, 1002246, 'PT', 'Arazede', 1, 'arazede', 40.28627000, -8.64999000),
(1088984, 1002246, 'PT', 'Arganil', 1, 'arganil', 40.21826000, -8.05403000),
(1088998, 1002246, 'PT', 'Assafarge', 1, 'assafarge', 40.15895000, -8.43167000),
(1089050, 1002246, 'PT', 'Buarcos', 1, 'buarcos', 40.16604000, -8.87680000),
(1089088, 1002246, 'PT', 'Cantanhede', 1, 'cantanhede', 40.36354000, -8.60549000),
(1089091, 1002246, 'PT', 'Carapinheira', 1, 'carapinheira', 40.20620000, -8.64810000),
(1089122, 1002246, 'PT', 'Coimbra', 1, 'coimbra', 40.20564000, -8.41955000),
(1089126, 1002246, 'PT', 'Condeixa-a-Nova', 1, 'condeixa-a-nova', 40.10639000, -8.49632000),
(1089182, 1002246, 'PT', 'Figueira da Foz', 1, 'figueira-da-foz', 40.15085000, -8.86179000),
(1089222, 1002246, 'PT', 'Góis', 1, 'gois', 40.12535000, -8.08340000),
(1089238, 1002246, 'PT', 'Lavos', 1, 'lavos', 40.09363000, -8.82826000),
(1089249, 1002246, 'PT', 'Lorvão', 1, 'lorvao', 40.25938000, -8.31683000),
(1089256, 1002246, 'PT', 'Lousã', 1, 'lousa', 40.11673000, -8.24921000),
(1089303, 1002246, 'PT', 'Mira', 1, 'mira', 40.44559000, -8.73849000),
(1089304, 1002246, 'PT', 'Miranda do Corvo', 1, 'miranda-do-corvo', 40.09318000, -8.33261000),
(1089325, 1002246, 'PT', 'Montemor-o-Velho', 1, 'montemor-o-velho', 40.19385000, -8.66696000),
(1089368, 1002246, 'PT', 'Oliveira do Hospital', 1, 'oliveira-do-hospital', 40.35522000, -7.86481000),
(1089369, 1002246, 'PT', 'Oliveira do Mondego', 1, 'oliveira-do-mondego', 40.32305000, -8.22367000),
(1089378, 1002246, 'PT', 'Pampilhosa da Serra', 1, 'pampilhosa-da-serra', 40.04620000, -7.95182000),
(1089393, 1002246, 'PT', 'Penacova', 1, 'penacova', 40.26884000, -8.28237000),
(1089399, 1002246, 'PT', 'Penela', 1, 'penela', 40.03333000, -8.38333000),
(1089410, 1002246, 'PT', 'Poiares', 1, 'poiares', 40.21026000, -8.25746000),
(1089497, 1002246, 'PT', 'Santa Clara', 1, 'santa-clara', 40.19985000, -8.44018000),
(1089516, 1002246, 'PT', 'Santo António dos Olivais', 1, 'santo-antonio-dos-olivais', 40.21805000, -8.40523000),
(1089582, 1002246, 'PT', 'São Pedro de Alva', 1, 'sao-pedro-de-alva', 40.30044000, -8.16623000),
(1089552, 1002246, 'PT', 'Soure', 1, 'soure', 40.05989000, -8.62605000),
(1089616, 1002246, 'PT', 'Tábua', 1, 'tabua', 40.36207000, -8.02936000),
(1089596, 1002246, 'PT', 'Tavarede', 1, 'tavarede', 40.16692000, -8.84568000),
(1089603, 1002246, 'PT', 'Tocha', 1, 'tocha', 40.31308000, -8.75339000),
(1089611, 1002246, 'PT', 'Travanca', 1, 'travanca', 40.32357000, -8.18687000),
(1089660, 1002246, 'PT', 'Vila Nova de Poiares', 1, 'vila-nova-de-poiares', 40.22129000, -8.24105000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002236, 'PT', 'Évora District', 1, 'evora-district');

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 
(1088912, 1002236, 'PT', 'Alandroal', 1, 'alandroal', 38.62924000, -7.36599000),
(1088990, 1002236, 'PT', 'Arraiolos', 1, 'arraiolos', 38.76774000, -7.95831000),
(1089043, 1002236, 'PT', 'Borba', 1, 'borba', 38.80553000, -7.45465000),
(1089157, 1002236, 'PT', 'Estremoz', 1, 'estremoz', 38.84996000, -7.60117000),
(1089697, 1002236, 'PT', 'Évora', 1, 'evora', 38.56667000, -7.90000000),
(1089324, 1002236, 'PT', 'Montemor-o-Novo', 1, 'montemor-o-novo', 38.67103000, -8.29956000),
(1089328, 1002236, 'PT', 'Mora', 1, 'mora', 38.92174000, -8.09972000),
(1089336, 1002236, 'PT', 'Mourão', 1, 'mourao', 38.29778000, -7.22230000),
(1089423, 1002236, 'PT', 'Portel', 1, 'portel', 38.29385000, -7.72762000),
(1089457, 1002236, 'PT', 'Redondo', 1, 'redondo', 38.58010000, -7.59659000),
(1089459, 1002236, 'PT', 'Reguengos de Monsaraz', 1, 'reguengos-de-monsaraz', 38.42529000, -7.53494000),
(1089635, 1002236, 'PT', 'Vendas Novas', 1, 'vendas-novas', 38.63975000, -8.54702000),
(1089639, 1002236, 'PT', 'Viana do Alentejo', 1, 'viana-do-alentejo', 38.33645000, -8.00011000),
(1089669, 1002236, 'PT', 'Vila Viçosa', 1, 'vila-vicosa', 38.78790000, -7.41852000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002239, 'PT', 'Faro District', 1, 'faro-district');

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 
(1088914, 1002239, 'PT', 'Albufeira', 1, 'albufeira', 37.08819000, -8.25030000),
(1088919, 1002239, 'PT', 'Alcantarilha', 1, 'alcantarilha', 37.13044000, -8.34623000),
(1088923, 1002239, 'PT', 'Alcoutim', 1, 'alcoutim', 37.42400000, -7.65456000),
(1088935, 1002239, 'PT', 'Algoz', 1, 'algoz', 37.16301000, -8.30359000),
(1088942, 1002239, 'PT', 'Aljezur', 1, 'aljezur', 37.31745000, -8.80147000),
(1088946, 1002239, 'PT', 'Almancil', 1, 'almancil', 37.08686000, -8.03074000),
(1088954, 1002239, 'PT', 'Altura', 1, 'altura', 37.17560000, -7.50064000),
(1088958, 1002239, 'PT', 'Alvor', 1, 'alvor', 37.12994000, -8.59174000),
(1088988, 1002239, 'PT', 'Armação de Pêra', 1, 'armacao-de-pera', 37.10256000, -8.35695000),
(1089035, 1002239, 'PT', 'Bensafrim', 1, 'bensafrim', 37.15583000, -8.73520000),
(1089041, 1002239, 'PT', 'Boliqueime', 1, 'boliqueime', 37.13718000, -8.15820000),
(1089052, 1002239, 'PT', 'Cabanas de Tavira', 1, 'cabanas-de-tavira', 37.13521000, -7.60048000),
(1089100, 1002239, 'PT', 'Carvoeiro', 1, 'carvoeiro', 37.09736000, -8.46846000),
(1089110, 1002239, 'PT', 'Castro Marim', 1, 'castro-marim', 37.25865000, -7.50732000),
(1089125, 1002239, 'PT', 'Conceição', 1, 'conceicao', 37.14789000, -7.60426000),
(1089158, 1002239, 'PT', 'Estói', 1, 'estoi', 37.09503000, -7.89445000),
(1089159, 1002239, 'PT', 'Estômbar', 1, 'estombar', 37.14629000, -8.48505000),
(1089167, 1002239, 'PT', 'Faro', 1, 'faro', 37.01869000, -7.92716000),
(1089174, 1002239, 'PT', 'Ferragudo', 1, 'ferragudo', 37.12474000, -8.51915000),
(1089178, 1002239, 'PT', 'Ferreiras', 1, 'ferreiras', 37.12926000, -8.23759000),
(1089200, 1002239, 'PT', 'Fuzeta', 1, 'fuzeta', 37.05429000, -7.74699000),
(1089217, 1002239, 'PT', 'Guia', 1, 'guia', 37.12959000, -8.29963000),
(1089229, 1002239, 'PT', 'Lagoa', 1, 'lagoa', 37.10505000, -8.45974000),
(1089230, 1002239, 'PT', 'Lagos', 1, 'lagos', 37.10202000, -8.67422000),
(1089237, 1002239, 'PT', 'Laranjeiro', 1, 'laranjeiro', 37.06799000, -7.80780000),
(1089250, 1002239, 'PT', 'Loulé', 1, 'loule', 37.14399000, -8.02345000),
(1089259, 1002239, 'PT', 'Luz', 1, 'luz', 37.09216000, -7.70433000),
(1089273, 1002239, 'PT', 'Manta Rota', 1, 'manta-rota', 37.16849000, -7.51804000),
(1089281, 1002239, 'PT', 'Marmelete', 1, 'marmelete', 37.31014000, -8.66813000),
(1089295, 1002239, 'PT', 'Mexilhoeira Grande', 1, 'mexilhoeira-grande', 37.15858000, -8.61487000),
(1089311, 1002239, 'PT', 'Moncarapacho', 1, 'moncarapacho', 37.08360000, -7.78763000),
(1089312, 1002239, 'PT', 'Monchique', 1, 'monchique', 37.31664000, -8.58340000),
(1089321, 1002239, 'PT', 'Monte Gordo', 1, 'monte-gordo', 37.18192000, -7.45225000),
(1089358, 1002239, 'PT', 'Olhão', 1, 'olhao', 37.04509000, -7.81032000),
(1089357, 1002239, 'PT', 'Olhos de Água', 1, 'olhos-de-agua', 37.09024000, -8.19168000),
(1089375, 1002239, 'PT', 'Paderne', 1, 'paderne', 37.17935000, -8.20150000),
(1089380, 1002239, 'PT', 'Parchal', 1, 'parchal', 37.13827000, -8.51703000),
(1089441, 1002239, 'PT', 'Pêra', 1, 'pera', 37.12296000, -8.34115000),
(1089421, 1002239, 'PT', 'Porches', 1, 'porches', 37.12665000, -8.40162000),
(1089424, 1002239, 'PT', 'Portimão', 1, 'portimao', 37.17544000, -8.58420000),
(1089446, 1002239, 'PT', 'Quarteira', 1, 'quarteira', 37.06946000, -8.10064000),
(1089482, 1002239, 'PT', 'Sagres', 1, 'sagres', 37.00864000, -8.94311000),
(1089495, 1002239, 'PT', 'Santa Bárbara de Nexe', 1, 'santa-barbara-de-nexe', 37.10619000, -7.96648000),
(1089505, 1002239, 'PT', 'Santa Luzia', 1, 'santa-luzia', 37.10224000, -7.66202000),
(1089559, 1002239, 'PT', 'São Bartolomeu de Messines', 1, 'sao-bartolomeu-de-messines', 37.25648000, -8.28672000),
(1089560, 1002239, 'PT', 'São Brás de Alportel', 1, 'sao-bras-de-alportel', 37.19564000, -7.87546000),
(1089574, 1002239, 'PT', 'São Marcos da Serra', 1, 'sao-marcos-da-serra', 37.36100000, -8.37764000),
(1089528, 1002239, 'PT', 'Senhora da Luz', 1, 'senhora-da-luz', 37.08771000, -8.72649000),
(1089544, 1002239, 'PT', 'Silves', 1, 'silves', 37.20343000, -8.33472000),
(1089597, 1002239, 'PT', 'Tavira', 1, 'tavira', 37.12734000, -7.64861000),
(1089614, 1002239, 'PT', 'Tunes', 1, 'tunes', 37.16592000, -8.25919000),
(1089671, 1002239, 'PT', 'Vila do Bispo', 1, 'vila-do-bispo', 37.08317000, -8.91144000),
(1089653, 1002239, 'PT', 'Vila Nova De Cacela', 1, 'vila-nova-de-cacela', 37.17391000, -7.53169000),
(1089664, 1002239, 'PT', 'Vila Real de Santo António', 1, 'vila-real-de-santo-antonio', 37.19232000, -7.42538000),
(1089674, 1002239, 'PT', 'Vilamoura', 1, 'vilamoura', 37.08728000, -8.11701000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004859, 'PT', 'Guarda District', 1, 'guarda-district');

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 
(1143237, 1004859, 'PT', 'Abrigada', 1, 'abrigada', 39.14472222, -9.01861111),
(1143297, 1004859, 'PT', 'Açores', 1, 'acores', 40.64500000, -7.30527778),
(1143238, 1004859, 'PT', 'Adão', 1, 'adao', 40.45916667, -7.16500000),
(1143239, 1004859, 'PT', 'Agualva', 1, 'agualva', 38.77004444, -9.29881111),
(1143760, 1004859, 'PT', 'Águas Belas', 1, 'aguas-belas', 40.37472222, -7.16694444),
(1143240, 1004859, 'PT', 'Aguiar da Beira', 1, 'aguiar-da-beira', 40.81726000, -7.54431000),
(1143241, 1004859, 'PT', 'Ajuda', 1, 'ajuda', 38.70750000, -9.19833333),
(1143242, 1004859, 'PT', 'Albardo', 1, 'albardo', 40.51145000, -7.13028000),
(1143243, 1004859, 'PT', 'Alcabideche', 1, 'alcabideche', 38.73361111, -9.40916667),
(1143244, 1004859, 'PT', 'Alcains', 1, 'alcains', 39.91540278, -7.46107778),
(1143246, 1004859, 'PT', 'Alcântara', 1, 'alcantara', 38.70638889, -9.17416667),
(1143245, 1004859, 'PT', 'Alcoentre', 1, 'alcoentre', 39.20861111, -8.95944444),
(1143252, 1004859, 'PT', 'Aldeia da Ponte', 1, 'aldeia-da-ponte', 40.41348889, -6.86908333),
(1143253, 1004859, 'PT', 'Aldeia da Ribeira', 1, 'aldeia-da-ribeira', 40.45666667, -6.89777778),
(1143254, 1004859, 'PT', 'Aldeia de Santo António', 1, 'aldeia-de-santo-antonio', 40.34305556, -7.13638889),
(1143255, 1004859, 'PT', 'Aldeia do Bispo', 1, 'aldeia-do-bispo', 40.32333333, -6.84805556),
(1143247, 1004859, 'PT', 'Aldeia Galega da Merceana', 1, 'aldeia-galega-da-merceana', 39.08222222, -9.11194444),
(1143248, 1004859, 'PT', 'Aldeia Gavinha', 1, 'aldeia-gavinha', 39.08444444, -9.09638889),
(1143249, 1004859, 'PT', 'Aldeia Nova, Miranda do Douro', 1, 'aldeia-nova-miranda-do-douro', 40.72584000, -7.42384000),
(1143250, 1004859, 'PT', 'Aldeia Velha', 1, 'aldeia-velha', 40.34333333, -6.86750000),
(1143251, 1004859, 'PT', 'Aldeia Viçosa', 1, 'aldeia-vicosa', 40.57888889, -7.31777778),
(1143256, 1004859, 'PT', 'Aldeias', 1, 'aldeias', 40.46861111, -7.59805556),
(1143257, 1004859, 'PT', 'Alenquer', 1, 'alenquer', 39.05000000, -9.01666667),
(1143258, 1004859, 'PT', 'Alfaiates', 1, 'alfaiates', 40.39111111, -6.91333333),
(1143259, 1004859, 'PT', 'Alfornelos', 1, 'alfornelos', 38.76333333, -9.20638889),
(1143260, 1004859, 'PT', 'Alfragide', 1, 'alfragide', 38.73203000, -9.21920000),
(1143265, 1004859, 'PT', 'Algés', 1, 'alges', 38.69949722, -9.22927222),
(1143261, 1004859, 'PT', 'Algodres', 1, 'algodres', 40.95250000, -7.05472222),
(1143262, 1004859, 'PT', 'Alguber', 1, 'alguber', 39.27583333, -9.01888889),
(1143263, 1004859, 'PT', 'Algueirão', 1, 'algueirao', 38.79764000, -9.34370000),
(1143264, 1004859, 'PT', 'Algueirão–Mem Martins', 1, 'algueirao-mem-martins', 38.79411389, -9.34510833),
(1143266, 1004859, 'PT', 'Alhandra', 1, 'alhandra', 38.92732000, -9.00864000),
(1143267, 1004859, 'PT', 'Almargem', 1, 'almargem', 38.84472222, -9.27305556),
(1143268, 1004859, 'PT', 'Almargem do Bispo', 1, 'almargem-do-bispo', 38.84750000, -9.27138889),
(1143269, 1004859, 'PT', 'Almeida', 1, 'almeida', 40.73070000, -6.90594000),
(1143270, 1004859, 'PT', 'Almendra', 1, 'almendra', 40.99284444, -7.05756944),
(1143271, 1004859, 'PT', 'Almofala', 1, 'almofala', 40.86027778, -6.84861111),
(1143272, 1004859, 'PT', 'Alto do Pina', 1, 'alto-do-pina', 38.74027778, -9.12805556),
(1143273, 1004859, 'PT', 'Alvalade', 1, 'alvalade', 38.74694444, -9.13611111),
(1143274, 1004859, 'PT', 'Alvendre', 1, 'alvendre', 40.58500000, -7.25833333),
(1143275, 1004859, 'PT', 'Alverca da Beira', 1, 'alverca-da-beira', 40.70055556, -7.21750000),
(1143276, 1004859, 'PT', 'Alverca do Ribatejo', 1, 'alverca-do-ribatejo', 38.89866111, -9.03947778),
(1143277, 1004859, 'PT', 'Alvoco da Serra', 1, 'alvoco-da-serra', 40.29555556, -7.67027778),
(1143278, 1004859, 'PT', 'Amadora', 1, 'amadora', 38.75000000, -9.23333333),
(1143279, 1004859, 'PT', 'Ameixoeira', 1, 'ameixoeira', 38.78777778, -9.15250000),
(1143280, 1004859, 'PT', 'Amoreira', 1, 'amoreira', 40.58805556, -7.01555556),
(1143281, 1004859, 'PT', 'Anjos', 1, 'anjos', 38.72388889, -9.13638889),
(1143282, 1004859, 'PT', 'Apelação', 1, 'apelacao', 38.81500000, -9.13249000),
(1143283, 1004859, 'PT', 'Arcozelo', 1, 'arcozelo', 40.54055556, -7.62722222),
(1143284, 1004859, 'PT', 'Arranhó', 1, 'arranho', 38.95371667, -9.13497778),
(1143285, 1004859, 'PT', 'Arrifana', 1, 'arrifana', 40.56972222, -7.21027778),
(1143286, 1004859, 'PT', 'Arruda Dos Vinhos', 1, 'arruda-dos-vinhos', 38.97172000, -9.08807000),
(1143287, 1004859, 'PT', 'Atalaia', 1, 'atalaia', 40.66000000, -7.03305556),
(1143288, 1004859, 'PT', 'Aveiras de Baixo', 1, 'aveiras-de-baixo', 39.11138889, -8.86916667),
(1143289, 1004859, 'PT', 'Aveiras de Cima', 1, 'aveiras-de-cima', 39.13769444, -8.89995556),
(1143291, 1004859, 'PT', 'Avelãs da Ribeira', 1, 'avelas-da-ribeira', 40.67773000, -7.21492000),
(1143290, 1004859, 'PT', 'Aveloso', 1, 'aveloso', 40.93111111, -7.31666667),
(1143292, 1004859, 'PT', 'Azambuja', 1, 'azambuja', 39.06666667, -8.86666667),
(1143293, 1004859, 'PT', 'Azambuja (town)', 1, 'azambuja-town', 39.07027778, -8.86833333),
(1143294, 1004859, 'PT', 'Azenhas do Mar', 1, 'azenhas-do-mar', 38.84055556, -9.46000000),
(1143295, 1004859, 'PT', 'Azevo', 1, 'azevo', 40.85166667, -7.13138889),
(1143296, 1004859, 'PT', 'Azueira', 1, 'azueira', 39.00653000, -9.27475000),
(1143298, 1004859, 'PT', 'Baraçal', 1, 'baracal', 40.39357000, -7.08522000),
(1143299, 1004859, 'PT', 'Barcarena', 1, 'barcarena', 38.73250000, -9.28000000),
(1143300, 1004859, 'PT', 'Barreira', 1, 'barreira', 40.91111111, -7.18638889),
(1143301, 1004859, 'PT', 'Beato', 1, 'beato', 38.73472222, -9.10583333),
(1143302, 1004859, 'PT', 'Belas', 1, 'belas', 38.76666667, -9.26666667),
(1143303, 1004859, 'PT', 'Bendada', 1, 'bendada', 40.37083333, -7.25472222),
(1143304, 1004859, 'PT', 'Benespera', 1, 'benespera', 40.44027778, -7.27638889),
(1143305, 1004859, 'PT', 'Benfica', 1, 'benfica', 38.75111111, -9.20222222),
(1143306, 1004859, 'PT', 'Bismula', 1, 'bismula', 40.44694444, -6.96444444),
(1143307, 1004859, 'PT', 'Bobadela', 1, 'bobadela', 38.80663000, -9.09731000),
(1143308, 1004859, 'PT', 'Bouça Cova', 1, 'bouca-cova', 40.70464000, -7.23830000),
(1143309, 1004859, 'PT', 'Brandoa', 1, 'brandoa', 38.76611111, -9.21444444),
(1143310, 1004859, 'PT', 'Bucelas', 1, 'bucelas', 38.90000000, -9.11666667),
(1143311, 1004859, 'PT', 'Buraca', 1, 'buraca', 38.74222222, -9.20944444),
(1143312, 1004859, 'PT', 'Cabanas de Torres', 1, 'cabanas-de-torres', 39.15631000, -9.06328000),
(1143313, 1004859, 'PT', 'Cabeça', 1, 'cabeca', 40.31916667, -7.73527778),
(1143314, 1004859, 'PT', 'Cacem', 1, 'cacem', 38.77042000, -9.30809000),
(1143315, 1004859, 'PT', 'Cachoeiras', 1, 'cachoeiras', 38.98583333, -9.01638889),
(1143316, 1004859, 'PT', 'Cadafais', 1, 'cadafais', 39.00444444, -9.00416667),
(1143317, 1004859, 'PT', 'Cadafaz', 1, 'cadafaz', 40.58472222, -7.36194444),
(1143318, 1004859, 'PT', 'Cadaval', 1, 'cadaval', 39.24621000, -9.06738000),
(1143319, 1004859, 'PT', 'Calhandriz', 1, 'calhandriz', 38.92500000, -9.06777778),
(1143320, 1004859, 'PT', 'Camarate', 1, 'camarate', 38.80358000, -9.12809000),
(1143321, 1004859, 'PT', 'Campelos', 1, 'campelos', 39.20000000, -9.23333333),
(1143322, 1004859, 'PT', 'Campo Grande', 1, 'campo-grande', 38.75694444, -9.15361111),
(1143323, 1004859, 'PT', 'Campolide', 1, 'campolide', 38.72638889, -9.16333333),
(1143324, 1004859, 'PT', 'Caneças', 1, 'canecas', 38.81666667, -9.23333333),
(1143325, 1004859, 'PT', 'Carapito', 1, 'carapito', 40.76759000, -7.45447000),
(1143326, 1004859, 'PT', 'Carcavelos', 1, 'carcavelos', 38.69220000, -9.33327000),
(1143327, 1004859, 'PT', 'Cardosas', 1, 'cardosas', 38.97722222, -9.04083333),
(1143328, 1004859, 'PT', 'Carmões', 1, 'carmoes', 39.05777778, -9.13416667),
(1143329, 1004859, 'PT', 'Carnaxide', 1, 'carnaxide', 38.72666667, -9.24166667),
(1143330, 1004859, 'PT', 'Carnicães', 1, 'carnicaes', 40.73333333, -7.31833333),
(1143331, 1004859, 'PT', 'Carnide', 1, 'carnide', 38.76083333, -9.18361111),
(1143332, 1004859, 'PT', 'Carnota', 1, 'carnota', 39.03361111, -9.07166667),
(1143333, 1004859, 'PT', 'Carragozela', 1, 'carragozela', 40.40572000, -7.76077000),
(1143334, 1004859, 'PT', 'Carrapichana', 1, 'carrapichana', 40.56194444, -7.48694444),
(1143335, 1004859, 'PT', 'Carregado', 1, 'carregado', 39.02334000, -8.96450000),
(1143336, 1004859, 'PT', 'Carvalhal', 1, 'carvalhal', 40.88361111, -7.28361111),
(1143337, 1004859, 'PT', 'Carvoeira', 1, 'carvoeira', 39.08055556, -9.16222222),
(1143339, 1004859, 'PT', 'Casal de Cambra', 1, 'casal-de-cambra', 38.80236000, -9.23188000),
(1143340, 1004859, 'PT', 'Casal de Cinza', 1, 'casal-de-cinza', 40.54416667, -7.16416667),
(1143338, 1004859, 'PT', 'Casal Vasco', 1, 'casal-vasco', 40.63792000, -7.55538000),
(1143341, 1004859, 'PT', 'Casas do Soeiro', 1, 'casas-do-soeiro', 40.61888889, -7.40638889),
(1143342, 1004859, 'PT', 'Cascais', 1, 'cascais', 38.69681000, -9.42147000),
(1143343, 1004859, 'PT', 'Castanheira', 1, 'castanheira', 40.57472222, -7.07944444),
(1143344, 1004859, 'PT', 'Castanheira do Ribatejo', 1, 'castanheira-do-ribatejo', 38.98333333, -8.96666667),
(1143345, 1004859, 'PT', 'Casteição', 1, 'casteicao', 40.88083333, -7.32583333),
(1143346, 1004859, 'PT', 'Casteleiro', 1, 'casteleiro', 40.30222222, -7.23166667),
(1143347, 1004859, 'PT', 'Castelo (Lisbon)', 1, 'castelo-lisbon', 38.71361111, -9.13333333),
(1143348, 1004859, 'PT', 'Castelo Bom', 1, 'castelo-bom', 40.62027778, -6.90055556),
(1143349, 1004859, 'PT', 'Castelo Melhor', 1, 'castelo-melhor', 41.02750000, -7.06500000),
(1143350, 1004859, 'PT', 'Castelo Rodrigo', 1, 'castelo-rodrigo', 40.87555556, -6.96388889),
(1143351, 1004859, 'PT', 'Cativelos', 1, 'cativelos', 40.53083333, -7.68194444),
(1143352, 1004859, 'PT', 'Cavadoude', 1, 'cavadoude', 40.58472222, -7.28666667),
(1143353, 1004859, 'PT', 'Caxias', 1, 'caxias', 38.70000000, -9.28333333),
(1143354, 1004859, 'PT', 'Cedovim', 1, 'cedovim', 41.03333333, -7.31666667),
(1143355, 1004859, 'PT', 'Celorico da Beira', 1, 'celorico-da-beira', 40.63333333, -7.40000000),
(1143356, 1004859, 'PT', 'Cercal', 1, 'cercal', 39.23388889, -8.99833333),
(1143357, 1004859, 'PT', 'Cerdeira', 1, 'cerdeira', 40.51416667, -7.04666667),
(1143358, 1004859, 'PT', 'Cerejo', 1, 'cerejo', 40.72944444, -7.22361111),
(1143359, 1004859, 'PT', 'Charneca', 1, 'charneca', 38.78527778, -9.14500000),
(1143361, 1004859, 'PT', 'Chãs', 1, 'chas', 40.98972222, -7.17027778),
(1143360, 1004859, 'PT', 'Cheleiros', 1, 'cheleiros', 38.88972222, -9.32888889),
(1143362, 1004859, 'PT', 'Codesseiro', 1, 'codesseiro', 40.65111111, -7.20500000),
(1143363, 1004859, 'PT', 'Cogula', 1, 'cogula', 40.81277778, -7.26138889),
(1143364, 1004859, 'PT', 'Colares', 1, 'colares', 38.80206000, -9.46305000),
(1143365, 1004859, 'PT', 'Coração de Jesus', 1, 'coracao-de-jesus', 38.72416667, -9.14500000),
(1143366, 1004859, 'PT', 'Coriscada', 1, 'coriscada', 40.86197000, -7.20372000),
(1143367, 1004859, 'PT', 'Cortiçada', 1, 'corticada', 40.76500000, -7.54222222),
(1143368, 1004859, 'PT', 'Cortiçô', 1, 'cortico', 40.66305556, -7.49472222),
(1143369, 1004859, 'PT', 'Cortiçô da Serra', 1, 'cortico-da-serra', 40.60124000, -7.43426000),
(1143370, 1004859, 'PT', 'Coruche', 1, 'coruche', 40.79361111, -7.54083333),
(1143371, 1004859, 'PT', 'Corujeira', 1, 'corujeira', 40.50609000, -7.32803000),
(1143374, 1004859, 'PT', 'Cótimos', 1, 'cotimos', 40.82750000, -7.23972222),
(1143372, 1004859, 'PT', 'Cruz Quebrada - Dafundo', 1, 'cruz-quebrada-dafundo', 38.70611111, -9.25055556),
(1143373, 1004859, 'PT', 'Custoias', 1, 'custoias', 41.10527778, -7.32083333),
(1143375, 1004859, 'PT', 'Damaia', 1, 'damaia', 38.74527778, -9.21833333),
(1143376, 1004859, 'PT', 'Dois Portos', 1, 'dois-portos', 39.03840000, -9.18556000),
(1143377, 1004859, 'PT', 'Dornelas', 1, 'dornelas', 40.73105000, -7.55894000),
(1143378, 1004859, 'PT', 'Eirado', 1, 'eirado', 40.77333333, -7.49000000),
(1143379, 1004859, 'PT', 'Encarnação', 1, 'encarnacao', 39.03333333, -9.36805556),
(1143380, 1004859, 'PT', 'Enxara do Bispo', 1, 'enxara-do-bispo', 38.99194444, -9.24083333),
(1143381, 1004859, 'PT', 'Ericeira', 1, 'ericeira', 38.96277778, -9.41527778),
(1143382, 1004859, 'PT', 'Ervas Tenras', 1, 'ervas-tenras', 40.74055556, -7.18611111),
(1143383, 1004859, 'PT', 'Ervedosa', 1, 'ervedosa', 40.84694444, -7.17611111),
(1143384, 1004859, 'PT', 'Escalhão', 1, 'escalhao', 40.94944444, -6.92611111),
(1143385, 1004859, 'PT', 'Estoril', 1, 'estoril', 38.70571000, -9.39773000),
(1143386, 1004859, 'PT', 'Faia', 1, 'faia', 40.56055556, -7.31027778),
(1143387, 1004859, 'PT', 'Falagueira', 1, 'falagueira', 38.75903000, -9.21988000),
(1143388, 1004859, 'PT', 'Famalicão', 1, 'famalicao', 40.44361111, -7.37722222),
(1143389, 1004859, 'PT', 'Famões', 1, 'famoes', 38.78333333, -9.21666667),
(1143390, 1004859, 'PT', 'Fanhões', 1, 'fanhoes', 38.88111111, -9.15250000),
(1143391, 1004859, 'PT', 'Fernão Joanes', 1, 'fernao-joanes', 40.48694444, -7.35527778),
(1143397, 1004859, 'PT', 'Fiães', 1, 'fiaes', 40.73305556, -7.37305556),
(1143392, 1004859, 'PT', 'Figueira de Castelo Rodrigo', 1, 'figueira-de-castelo-rodrigo', 40.90000000, -6.96666667),
(1143393, 1004859, 'PT', 'Figueira do Guincho', 1, 'figueira-do-guincho', 38.75000000, -9.46666667),
(1143395, 1004859, 'PT', 'Figueiró da Granja', 1, 'figueiro-da-granja', 40.62805556, -7.49916667),
(1143396, 1004859, 'PT', 'Figueiró da Serra', 1, 'figueiro-da-serra', 40.54055556, -7.48888889),
(1143394, 1004859, 'PT', 'Figueiros', 1, 'figueiros', 39.27946000, -9.05083000),
(1143414, 1004859, 'PT', 'Fóios', 1, 'foios', 40.28666667, -6.89250000),
(1143398, 1004859, 'PT', 'Folgosinho', 1, 'folgosinho', 40.50944444, -7.51388889),
(1143399, 1004859, 'PT', 'Folhadosa', 1, 'folhadosa', 40.37944444, -7.78472222),
(1143400, 1004859, 'PT', 'Fontanelas', 1, 'fontanelas', 38.85000000, -9.43333333),
(1143401, 1004859, 'PT', 'Fonte Longa', 1, 'fonte-longa', 41.01305556, -7.23361111),
(1143402, 1004859, 'PT', 'Forninhos', 1, 'forninhos', 40.70472222, -7.55416667),
(1143403, 1004859, 'PT', 'Forno Telheiro', 1, 'forno-telheiro', 40.67333333, -7.39777778),
(1143404, 1004859, 'PT', 'Fornos de Algodres', 1, 'fornos-de-algodres', 40.61666667, -7.53333333),
(1143405, 1004859, 'PT', 'Forte da Casa', 1, 'forte-da-casa', 38.87391000, -9.05216000),
(1143406, 1004859, 'PT', 'Freches', 1, 'freches', 40.73166667, -7.34638889),
(1143407, 1004859, 'PT', 'Freineda', 1, 'freineda', 40.58305556, -6.89111111),
(1143408, 1004859, 'PT', 'Freiria', 1, 'freiria', 39.02739000, -9.31995000),
(1143409, 1004859, 'PT', 'Freixeda do Torrão', 1, 'freixeda-do-torrao', 40.89027778, -7.03222222),
(1143410, 1004859, 'PT', 'Freixedas', 1, 'freixedas', 40.69194444, -7.16305556),
(1143411, 1004859, 'PT', 'Freixo', 1, 'freixo', 40.61861111, -7.01027778),
(1143412, 1004859, 'PT', 'Freixo de Numão', 1, 'freixo-de-numao', 41.06666667, -7.21666667),
(1143413, 1004859, 'PT', 'Frielas', 1, 'frielas', 38.82583333, -9.14444444),
(1143415, 1004859, 'PT', 'Gagos', 1, 'gagos', 40.58388889, -7.11472222),
(1143416, 1004859, 'PT', 'Girabolhos', 1, 'girabolhos', 40.50944444, -7.73666667),
(1143417, 1004859, 'PT', 'Gonçalo', 1, 'goncalo', 40.41666667, -7.35000000),
(1143418, 1004859, 'PT', 'Gonçalo Bocas', 1, 'goncalo-bocas', 40.57666667, -7.17750000),
(1143419, 1004859, 'PT', 'Gouveia', 1, 'gouveia', 40.50000000, -7.60000000),
(1143423, 1004859, 'PT', 'Graça', 1, 'graca', 38.71722222, -9.13083333),
(1143420, 1004859, 'PT', 'Gradil', 1, 'gradil', 38.98222222, -9.28083333),
(1143421, 1004859, 'PT', 'Gradiz', 1, 'gradiz', 40.85944444, -7.52861111),
(1143422, 1004859, 'PT', 'Granja', 1, 'granja', 40.75201000, -7.20428000),
(1143424, 1004859, 'PT', 'Guarda', 1, 'guarda', 40.53638889, -7.26833333),
(1143425, 1004859, 'PT', 'Guilheiro', 1, 'guilheiro', 40.89805556, -7.40972222),
(1143426, 1004859, 'PT', 'Horta', 1, 'horta', 41.06777778, -7.31055556),
(1143427, 1004859, 'PT', 'Igreja Nova', 1, 'igreja-nova', 38.91694444, -9.31944444),
(1143428, 1004859, 'PT', 'Infias', 1, 'infias', 40.63000000, -7.53944444),
(1143429, 1004859, 'PT', 'Jarmelo São Miguel', 1, 'jarmelo-sao-miguel', 40.60040000, -7.14915000),
(1143430, 1004859, 'PT', 'Jarmelo São Pedro', 1, 'jarmelo-sao-pedro', 40.59447000, -7.13016000),
(1143431, 1004859, 'PT', 'João Antão', 1, 'joao-antao', 40.46443000, -7.23940000),
(1143433, 1004859, 'PT', 'Junça', 1, 'junca', 40.68138889, -6.88555556),
(1143432, 1004859, 'PT', 'Juncais', 1, 'juncais', 40.60944444, -7.50750000),
(1143434, 1004859, 'PT', 'Lagarinhos', 1, 'lagarinhos', 40.48583333, -7.66944444),
(1143435, 1004859, 'PT', 'Lajeosa', 1, 'lajeosa', 40.34353000, -6.81621000),
(1143436, 1004859, 'PT', 'Lajeosa do Mondego', 1, 'lajeosa-do-mondego', 40.62750000, -7.33750000),
(1143437, 1004859, 'PT', 'Lajes', 1, 'lajes', 40.48361111, -7.71638889),
(1143438, 1004859, 'PT', 'Lamas', 1, 'lamas', 39.21114000, -9.06151000),
(1143439, 1004859, 'PT', 'Lamegal', 1, 'lamegal', 40.66500000, -7.07972222),
(1143440, 1004859, 'PT', 'Lameiras', 1, 'lameiras', 40.71138889, -7.10444444),
(1143441, 1004859, 'PT', 'Lapa', 1, 'lapa', 38.71189000, -9.16007000),
(1143442, 1004859, 'PT', 'Lapa Dos Dinheiros', 1, 'lapa-dos-dinheiros', 40.37888889, -7.70944444),
(1143443, 1004859, 'PT', 'Leomil', 1, 'leomil', 40.63527778, -6.96416667),
(1143444, 1004859, 'PT', 'Linda-a-Velha', 1, 'linda-a-velha', 38.71446000, -9.24220000),
(1143445, 1004859, 'PT', 'Linhares (Celorico da Beira)', 1, 'linhares-celorico-da-beira', 40.54083333, -7.46111111),
(1143446, 1004859, 'PT', 'Lisbon', 1, 'lisbon', 38.71666667, -9.16666667),
(1143447, 1004859, 'PT', 'Longroiva', 1, 'longroiva', 40.98103000, -7.20334000),
(1143448, 1004859, 'PT', 'Loriga', 1, 'loriga', 40.31666667, -7.68333333),
(1143449, 1004859, 'PT', 'Loures', 1, 'loures', 38.83333333, -9.16666667),
(1143450, 1004859, 'PT', 'Lourinhã', 1, 'lourinha', 39.25000000, -9.31666667),
(1143451, 1004859, 'PT', 'Lousa', 1, 'lousa', 38.89171000, -9.20972000),
(1143452, 1004859, 'PT', 'Lumiar', 1, 'lumiar', 38.76527778, -9.15861111),
(1143474, 1004859, 'PT', 'Maçainhas', 1, 'macainhas', 40.53666667, -7.30250000),
(1143475, 1004859, 'PT', 'Maçal do Chão', 1, 'macal-do-chao', 40.69171000, -7.29178000),
(1143453, 1004859, 'PT', 'Maceira', 1, 'maceira', 40.68555556, -7.47166667),
(1143476, 1004859, 'PT', 'Maçussa', 1, 'macussa', 39.19472222, -8.86722222),
(1143454, 1004859, 'PT', 'Madalena', 1, 'madalena', 38.71000000, -9.13472222),
(1143455, 1004859, 'PT', 'Mafra', 1, 'mafra', 38.93333333, -9.33333333),
(1143456, 1004859, 'PT', 'Malcata', 1, 'malcata', 40.29990000, -7.06147000),
(1143457, 1004859, 'PT', 'Malhada Sorda', 1, 'malhada-sorda', 40.53638889, -6.91444444),
(1143458, 1004859, 'PT', 'Malpartida', 1, 'malpartida', 40.76000000, -6.86666667),
(1143459, 1004859, 'PT', 'Malveira', 1, 'malveira', 38.93059000, -9.26165000),
(1143460, 1004859, 'PT', 'Mangualde da Serra', 1, 'mangualde-da-serra', 40.46638889, -7.62166667),
(1143461, 1004859, 'PT', 'Manigoto', 1, 'manigoto', 40.70833333, -7.07583333),
(1143462, 1004859, 'PT', 'Manique do Intendente', 1, 'manique-do-intendente', 39.22111111, -8.89361111),
(1143463, 1004859, 'PT', 'Manteigas', 1, 'manteigas', 40.40000000, -7.53333333),
(1143464, 1004859, 'PT', 'Manteigas (São Pedro)', 1, 'manteigas-sao-pedro', 40.36611111, -7.54611111),
(1143465, 1004859, 'PT', 'Marialva', 1, 'marialva', 40.91000000, -7.23166667),
(1143466, 1004859, 'PT', 'Marmeleiro', 1, 'marmeleiro', 40.46861111, -7.11416667),
(1143467, 1004859, 'PT', 'Marteleira', 1, 'marteleira', 39.21305556, -9.28333333),
(1143503, 1004859, 'PT', 'Mártires', 1, 'martires', 38.70861111, -9.14166667),
(1143468, 1004859, 'PT', 'Marvila', 1, 'marvila', 38.74527778, -9.10416667),
(1143469, 1004859, 'PT', 'Massamá', 1, 'massama', 38.75564000, -9.28427000),
(1143470, 1004859, 'PT', 'Mata de Lobos', 1, 'mata-de-lobos', 40.91691000, -6.88804000),
(1143471, 1004859, 'PT', 'Matacães', 1, 'matacaes', 39.09277778, -9.21222222),
(1143472, 1004859, 'PT', 'Matança', 1, 'matanca', 40.67888889, -7.52888889),
(1143473, 1004859, 'PT', 'Maxial', 1, 'maxial', 39.14301000, -9.16898000),
(1143477, 1004859, 'PT', 'Meca', 1, 'meca', 39.08972222, -9.02555556),
(1143504, 1004859, 'PT', 'Mêda', 1, 'meda', 40.96666667, -7.26666667),
(1143478, 1004859, 'PT', 'Meios', 1, 'meios', 40.49361111, -7.35916667),
(1143479, 1004859, 'PT', 'Melo', 1, 'melo', 40.51944444, -7.53361111),
(1143480, 1004859, 'PT', 'Mem Martins', 1, 'mem-martins', 38.79443000, -9.34284000),
(1143481, 1004859, 'PT', 'Mercês', 1, 'merces', 38.71611111, -9.14888889),
(1143482, 1004859, 'PT', 'Mesquitela', 1, 'mesquitela', 40.58805556, -7.48944444),
(1143483, 1004859, 'PT', 'Milharado', 1, 'milharado', 38.94722222, -9.19916667),
(1143484, 1004859, 'PT', 'Mina', 1, 'mina', 38.76166667, -9.23611111),
(1143485, 1004859, 'PT', 'Minhocal', 1, 'minhocal', 40.68944444, -7.34666667),
(1143486, 1004859, 'PT', 'Mira-Sintra', 1, 'mira-sintra', 38.78417000, -9.30148000),
(1143487, 1004859, 'PT', 'Miragaia', 1, 'miragaia', 39.23583333, -9.26500000),
(1143488, 1004859, 'PT', 'Miuzela', 1, 'miuzela', 40.51055556, -7.00500000),
(1143489, 1004859, 'PT', 'Mizarela', 1, 'mizarela', 40.55746000, -7.34107000),
(1143490, 1004859, 'PT', 'Moimenta da Serra', 1, 'moimenta-da-serra', 40.47359000, -7.63839000),
(1143491, 1004859, 'PT', 'Moimentinha', 1, 'moimentinha', 40.74555556, -7.22777778),
(1143492, 1004859, 'PT', 'Moita', 1, 'moita', 40.30000000, -7.19750000),
(1143493, 1004859, 'PT', 'Moita dos Ferreiros', 1, 'moita-dos-ferreiros', 39.24825000, -9.22355000),
(1143494, 1004859, 'PT', 'Moledo', 1, 'moledo', 39.28388889, -9.25722222),
(1143495, 1004859, 'PT', 'Monte Abraão', 1, 'monte-abraao', 38.75840000, -9.26527000),
(1143496, 1004859, 'PT', 'Monte Estoril', 1, 'monte-estoril', 38.70636000, -9.40595000),
(1143497, 1004859, 'PT', 'Monte Redondo', 1, 'monte-redondo', 39.11500000, -9.20444444),
(1143498, 1004859, 'PT', 'Montelavar', 1, 'montelavar', 38.86968000, -9.31581000),
(1143499, 1004859, 'PT', 'Moreira de Rei', 1, 'moreira-de-rei', 40.83915000, -7.32316000),
(1143505, 1004859, 'PT', 'Mós', 1, 'mos', 41.11306000, -7.19717000),
(1143500, 1004859, 'PT', 'Moscavide', 1, 'moscavide', 38.77929000, -9.10222000),
(1143501, 1004859, 'PT', 'Murça', 1, 'murca', 41.10055556, -7.23138889),
(1143502, 1004859, 'PT', 'Muxagata', 1, 'muxagata', 41.03611111, -7.15000000),
(1143506, 1004859, 'PT', 'Nabais', 1, 'nabais', 40.52000000, -7.55555556),
(1143507, 1004859, 'PT', 'Nave', 1, 'nave', 40.39821000, -6.96030000),
(1143508, 1004859, 'PT', 'Nave de Haver', 1, 'nave-de-haver', 40.52166667, -6.83416667),
(1143509, 1004859, 'PT', 'Nespereira', 1, 'nespereira', 40.51722222, -7.60972222),
(1143510, 1004859, 'PT', 'Nossa Senhora de Fátima', 1, 'nossa-senhora-de-fatima', 38.73916667, -9.15083333),
(1143511, 1004859, 'PT', 'Numão', 1, 'numao', 41.09750000, -7.29111111),
(1143512, 1004859, 'PT', 'Odivelas', 1, 'odivelas', 38.80000000, -9.18333333),
(1143513, 1004859, 'PT', 'Odivelas Municipality', 1, 'odivelas-municipality', 38.79705000, -9.19108000),
(1143514, 1004859, 'PT', 'Oeiras', 1, 'oeiras', 38.69704444, -9.30165278),
(1143515, 1004859, 'PT', 'Oeiras e São Julião da Barra', 1, 'oeiras-e-sao-juliao-da-barra', 38.69722222, -9.30833333),
(1143516, 1004859, 'PT', 'Olhalvo', 1, 'olhalvo', 39.09861111, -9.06388889),
(1143517, 1004859, 'PT', 'Olival de Basto', 1, 'olival-de-basto', 38.79083333, -9.16722222),
(1143518, 1004859, 'PT', 'Olival do Basto', 1, 'olival-do-basto', 38.79083333, -9.16611111),
(1143519, 1004859, 'PT', 'Ota', 1, 'ota', 39.11000000, -8.98972222),
(1143520, 1004859, 'PT', 'Outeiro da Cabeça', 1, 'outeiro-da-cabeca', 39.19222222, -9.18222222),
(1143521, 1004859, 'PT', 'Outeiro de Gatos', 1, 'outeiro-de-gatos', 40.95222222, -7.30222222),
(1143529, 1004859, 'PT', 'Paço de Arcos', 1, 'paco-de-arcos', 38.69500000, -9.29361111),
(1143530, 1004859, 'PT', 'Paços da Serra', 1, 'pacos-da-serra', 40.45972222, -7.65055556),
(1143522, 1004859, 'PT', 'Painho', 1, 'painho', 39.30222222, -9.04944444),
(1143523, 1004859, 'PT', 'Pala', 1, 'pala', 40.76305556, -7.15111111),
(1143524, 1004859, 'PT', 'Palhais', 1, 'palhais', 40.81666667, -7.43000000),
(1143525, 1004859, 'PT', 'Panoias de Cima', 1, 'panoias-de-cima', 40.49777778, -7.23277778),
(1143526, 1004859, 'PT', 'Parada', 1, 'parada', 40.53972222, -7.03777778),
(1143527, 1004859, 'PT', 'Paranhos', 1, 'paranhos', 40.48635000, -7.79454000),
(1143528, 1004859, 'PT', 'Parede', 1, 'parede', 38.69328000, -9.35695000),
(1143531, 1004859, 'PT', 'Pega', 1, 'pega', 40.42861111, -7.14444444),
(1143532, 1004859, 'PT', 'Pena', 1, 'pena', 38.72138889, -9.14000000),
(1143533, 1004859, 'PT', 'Pena Lobo', 1, 'pena-lobo', 40.39277778, -7.20388889),
(1143534, 1004859, 'PT', 'Pena Verde', 1, 'pena-verde', 40.72833333, -7.50527778),
(1143536, 1004859, 'PT', 'Penha de Águia', 1, 'penha-de-aguia', 40.86636000, -7.06814000),
(1143535, 1004859, 'PT', 'Penha de França', 1, 'penha-de-franca', 38.73000000, -9.13166667),
(1143558, 1004859, 'PT', 'Pêra do Moço', 1, 'pera-do-moco', 40.61305556, -7.20972222),
(1143537, 1004859, 'PT', 'Peral', 1, 'peral', 39.26166667, -9.07444444),
(1143538, 1004859, 'PT', 'Pereiro', 1, 'pereiro', 40.73500000, -7.01305556),
(1143539, 1004859, 'PT', 'Pereiro de Palhacana', 1, 'pereiro-de-palhacana', 39.04277778, -9.10888889),
(1143559, 1004859, 'PT', 'Pêro Moniz', 1, 'pero-moniz', 39.22138889, -9.12361111),
(1143540, 1004859, 'PT', 'Pero Pinheiro', 1, 'pero-pinheiro', 38.83990000, -9.32066000),
(1143541, 1004859, 'PT', 'Peva', 1, 'peva', 40.66472222, -6.99083333),
(1143542, 1004859, 'PT', 'Pinhanços', 1, 'pinhancos', 40.46638889, -7.68305556),
(1143543, 1004859, 'PT', 'Pinheiro', 1, 'pinheiro', 40.80083333, -7.59833333),
(1143544, 1004859, 'PT', 'Pinhel', 1, 'pinhel', 40.78333333, -7.06666667),
(1143560, 1004859, 'PT', 'Pínzio', 1, 'pinzio', 40.60250000, -7.06527778),
(1143553, 1004859, 'PT', 'Poço do Canto', 1, 'poco-do-canto', 40.99944444, -7.26833333),
(1143545, 1004859, 'PT', 'Pomares', 1, 'pomares', 40.64305556, -7.13805556),
(1143546, 1004859, 'PT', 'Ponte do Rol', 1, 'ponte-do-rol', 39.09277778, -9.31916667),
(1143547, 1004859, 'PT', 'Pontinha', 1, 'pontinha', 38.77700000, -9.20377000),
(1143548, 1004859, 'PT', 'Portela', 1, 'portela', 38.78277778, -9.11111111),
(1143550, 1004859, 'PT', 'Porto da Carne', 1, 'porto-da-carne', 40.60527778, -7.29222222),
(1143549, 1004859, 'PT', 'Porto Salvo', 1, 'porto-salvo', 38.71722222, -9.29916667),
(1143551, 1004859, 'PT', 'Pousada', 1, 'pousada', 40.54722222, -7.12611111),
(1143552, 1004859, 'PT', 'Pousafoles do Bispo', 1, 'pousafoles-do-bispo', 40.41222222, -7.17916667),
(1143561, 1004859, 'PT', 'Póvoa de Santa Iria', 1, 'povoa-de-santa-iria', 38.86111111, -9.06444444),
(1143562, 1004859, 'PT', 'Póvoa de Santo Adrião', 1, 'povoa-de-santo-adriao', 38.80016000, -9.16395000),
(1143563, 1004859, 'PT', 'Póvoa do Concelho', 1, 'povoa-do-concelho', 40.75972222, -7.26638889),
(1143554, 1004859, 'PT', 'Prados', 1, 'prados', 40.56138889, -7.37666667),
(1143555, 1004859, 'PT', 'Prazeres', 1, 'prazeres', 38.70888889, -9.16888889),
(1143556, 1004859, 'PT', 'Prior Velho', 1, 'prior-velho', 38.79194444, -9.12083333),
(1143557, 1004859, 'PT', 'Prova', 1, 'prova', 40.91250000, -7.34194444),
(1143564, 1004859, 'PT', 'Quadrazais', 1, 'quadrazais', 40.32472222, -6.99833333),
(1143565, 1004859, 'PT', 'Queijas', 1, 'queijas', 38.72236000, -9.26593000),
(1143566, 1004859, 'PT', 'Queiriz', 1, 'queiriz', 40.73596000, -7.44999000),
(1143567, 1004859, 'PT', 'Queluz', 1, 'queluz', 38.75657000, -9.25451000),
(1143569, 1004859, 'PT', 'Quintã de Pêro Martins', 1, 'quinta-de-pero-martins', 40.88194444, -7.08305556),
(1143568, 1004859, 'PT', 'Quintas de São Bartolomeu', 1, 'quintas-de-sao-bartolomeu', 40.37138889, -7.09861111),
(1143570, 1004859, 'PT', 'Rabaçal', 1, 'rabacal', 40.86250000, -7.24941000),
(1143571, 1004859, 'PT', 'Ramada', 1, 'ramada', 38.80361111, -9.19111111),
(1143572, 1004859, 'PT', 'Ramalhal', 1, 'ramalhal', 39.14472222, -9.23222222),
(1143573, 1004859, 'PT', 'Ramela', 1, 'ramela', 40.47777778, -7.25888889),
(1143574, 1004859, 'PT', 'Ranhados', 1, 'ranhados', 40.99527778, -7.32944444),
(1143575, 1004859, 'PT', 'Rapa', 1, 'rapa', 40.58416667, -7.34555556),
(1143576, 1004859, 'PT', 'Rapoula do Côa', 1, 'rapoula-do-coa', 40.42111111, -7.04750000),
(1143577, 1004859, 'PT', 'Ratoeira', 1, 'ratoeira', 40.64027778, -7.35361111),
(1143578, 1004859, 'PT', 'Reboleira', 1, 'reboleira', 38.75083333, -9.23027778),
(1143579, 1004859, 'PT', 'Reboleiro', 1, 'reboleiro', 40.83250000, -7.41888889),
(1143580, 1004859, 'PT', 'Rebolosa', 1, 'rebolosa', 40.42361111, -6.91111111),
(1143581, 1004859, 'PT', 'Reguengo Grande', 1, 'reguengo-grande', 39.28722222, -9.21472222),
(1143582, 1004859, 'PT', 'Reigada', 1, 'reigada', 40.80444444, -6.94805556),
(1143583, 1004859, 'PT', 'Rendo', 1, 'rendo', 40.37972222, -7.04444444),
(1143584, 1004859, 'PT', 'Ribafria', 1, 'ribafria', 39.06194444, -9.09472222),
(1143585, 1004859, 'PT', 'Ribamar', 1, 'ribamar', 39.20250000, -9.33250000),
(1143586, 1004859, 'PT', 'Ribamondego', 1, 'ribamondego', 40.56805556, -7.58138889),
(1143587, 1004859, 'PT', 'Ribeira Dos Carinhos', 1, 'ribeira-dos-carinhos', 40.62138889, -7.14222222),
(1143589, 1004859, 'PT', 'Rio de Mel', 1, 'rio-de-mel', 40.80777778, -7.39361111),
(1143590, 1004859, 'PT', 'Rio de Mouro', 1, 'rio-de-mouro', 38.76889000, -9.33273000),
(1143588, 1004859, 'PT', 'Rio Torto', 1, 'rio-torto', 40.50916667, -7.65694444),
(1143591, 1004859, 'PT', 'Rochoso', 1, 'rochoso', 40.51638889, -7.09333333),
(1143592, 1004859, 'PT', 'Runa', 1, 'runa', 39.06527778, -9.20888889),
(1143593, 1004859, 'PT', 'Ruvina', 1, 'ruvina', 40.41500000, -7.01055556),
(1143594, 1004859, 'PT', 'Sabugal', 1, 'sabugal', 40.35000000, -7.08333333),
(1143595, 1004859, 'PT', 'Sabugueiro', 1, 'sabugueiro', 40.40194444, -7.63972222),
(1143596, 1004859, 'PT', 'Sacavém', 1, 'sacavem', 38.79442000, -9.10533000),
(1143597, 1004859, 'PT', 'Sacramento', 1, 'sacramento', 38.71222222, -9.14000000),
(1143598, 1004859, 'PT', 'Safurdão', 1, 'safurdao', 40.63694444, -7.06888889),
(1143599, 1004859, 'PT', 'Salgueirais', 1, 'salgueirais', 40.57445000, -7.42247000),
(1143600, 1004859, 'PT', 'Sameice', 1, 'sameice', 40.43444444, -7.77611111),
(1143601, 1004859, 'PT', 'Sameiro', 1, 'sameiro', 40.40916667, -7.49000000),
(1143602, 1004859, 'PT', 'Sandomil', 1, 'sandomil', 40.35805556, -7.78277778),
(1143603, 1004859, 'PT', 'Santa Bárbara', 1, 'santa-barbara', 39.21000000, -9.31388889),
(1143604, 1004859, 'PT', 'Santa Catarina', 1, 'santa-catarina', 38.71138889, -9.14805556),
(1143605, 1004859, 'PT', 'Santa Comba', 1, 'santa-comba', 40.45055556, -7.71472222),
(1143606, 1004859, 'PT', 'Santa Engrácia', 1, 'santa-engracia', 38.71916667, -9.11972222),
(1143607, 1004859, 'PT', 'Santa Eufémia', 1, 'santa-eufemia', 40.79833333, -7.18083333),
(1143608, 1004859, 'PT', 'Santa Eulália', 1, 'santa-eulalia', 40.41439000, -7.78717000),
(1143609, 1004859, 'PT', 'Santa Iria da Azóia', 1, 'santa-iria-da-azoia', 38.84629000, -9.08748000),
(1143610, 1004859, 'PT', 'Santa Iria de Azoia', 1, 'santa-iria-de-azoia', 38.84638889, -9.08805556),
(1143611, 1004859, 'PT', 'Santa Isabel', 1, 'santa-isabel', 38.71861111, -9.15833333),
(1143612, 1004859, 'PT', 'Santa Justa', 1, 'santa-justa', 38.71555556, -9.13638889),
(1143613, 1004859, 'PT', 'Santa Maria', 1, 'santa-maria', 40.42388889, -7.52138889),
(1143614, 1004859, 'PT', 'Santa Maria de Belém', 1, 'santa-maria-de-belem', 38.69911000, -9.20867000),
(1143615, 1004859, 'PT', 'Santa Maria do Castelo e São Miguel', 1, 'santa-maria-do-castelo-e-sao-miguel', 39.10864000, -9.23907000),
(1143616, 1004859, 'PT', 'Santa Maria dos Olivais', 1, 'santa-maria-dos-olivais', 38.76989000, -9.12073000),
(1143617, 1004859, 'PT', 'Santa Maria e São Miguel', 1, 'santa-maria-e-sao-miguel', 38.80083333, -9.37944444),
(1143618, 1004859, 'PT', 'Santa Marinha', 1, 'santa-marinha', 40.45027778, -7.66333333),
(1143619, 1004859, 'PT', 'Santana da Azinha', 1, 'santana-da-azinha', 40.47361111, -7.20916667),
(1143620, 1004859, 'PT', 'Santiago', 1, 'santiago', 40.42388889, -7.72916667),
(1143621, 1004859, 'PT', 'Santiago dos Velhos', 1, 'santiago-dos-velhos', 38.94166667, -9.10361111),
(1143622, 1004859, 'PT', 'Santo Antão do Tojal', 1, 'santo-antao-do-tojal', 38.85361111, -9.14305556),
(1143623, 1004859, 'PT', 'Santo António dos Cavaleiros', 1, 'santo-antonio-dos-cavaleiros', 38.81166667, -9.16111111),
(1143624, 1004859, 'PT', 'Santo Condestável', 1, 'santo-condestavel', 38.71527778, -9.16694444),
(1143625, 1004859, 'PT', 'Santo Estêvão', 1, 'santo-estevao', 39.04222222, -9.01583333),
(1143626, 1004859, 'PT', 'Santo Estêvão das Galés', 1, 'santo-estevao-das-gales', 38.89008000, -9.25066000),
(1143627, 1004859, 'PT', 'Santo Isidoro', 1, 'santo-isidoro', 38.99361111, -9.39861111),
(1143628, 1004859, 'PT', 'Santo Quintino', 1, 'santo-quintino', 39.00611111, -9.14972222),
(1143629, 1004859, 'PT', 'Santos-o-Velho', 1, 'santos-o-velho', 38.70694444, -9.15638889),
(1143653, 1004859, 'PT', 'São Bartolomeu', 1, 'sao-bartolomeu', 39.27511000, -9.27885000),
(1143654, 1004859, 'PT', 'São Bartolomeu dos Galegos', 1, 'sao-bartolomeu-dos-galegos', 39.27583333, -9.27944444),
(1143655, 1004859, 'PT', 'São Brás', 1, 'sao-bras', 38.76750000, -9.23305556),
(1143656, 1004859, 'PT', 'São Cristóvão e São Lourenço', 1, 'sao-cristovao-e-sao-lourenco', 38.71277778, -9.13555556),
(1143657, 1004859, 'PT', 'São Domingos de Benfica', 1, 'sao-domingos-de-benfica', 38.74361111, -9.17000000),
(1143658, 1004859, 'PT', 'São Domingos de Rana', 1, 'sao-domingos-de-rana', 38.70123000, -9.32760000),
(1143659, 1004859, 'PT', 'São Francisco Xavier', 1, 'sao-francisco-xavier', 38.70722222, -9.21722222),
(1143662, 1004859, 'PT', 'São João', 1, 'sao-joao', 38.72888889, -9.12277778),
(1143664, 1004859, 'PT', 'São João da Talha', 1, 'sao-joao-da-talha', 38.82583333, -9.09222222),
(1143665, 1004859, 'PT', 'São João das Lampas', 1, 'sao-joao-das-lampas', 38.87000000, -9.42111111),
(1143666, 1004859, 'PT', 'São João de Brito', 1, 'sao-joao-de-brito', 38.75500000, -9.13777778),
(1143667, 1004859, 'PT', 'São João de Deus', 1, 'sao-joao-de-deus', 38.74027778, -9.13777778),
(1143663, 1004859, 'PT', 'São João Dos Montes', 1, 'sao-joao-dos-montes', 38.95166000, -9.05449000),
(1143660, 1004859, 'PT', 'São Jorge de Arroios', 1, 'sao-jorge-de-arroios', 38.72888889, -9.13888889),
(1143661, 1004859, 'PT', 'São José', 1, 'sao-jose', 38.71805556, -9.14250000),
(1143668, 1004859, 'PT', 'São Julião', 1, 'sao-juliao', 40.48757000, -7.59498000),
(1143669, 1004859, 'PT', 'São Julião do Tojal', 1, 'sao-juliao-do-tojal', 38.85805556, -9.13555556),
(1143670, 1004859, 'PT', 'São Mamede', 1, 'sao-mamede', 38.72023000, -9.15298000),
(1143671, 1004859, 'PT', 'São Marcos', 1, 'sao-marcos', 38.75624000, -9.29731000),
(1143672, 1004859, 'PT', 'São Martinho', 1, 'sao-martinho', 40.44305556, -7.67194444),
(1143673, 1004859, 'PT', 'São Miguel', 1, 'sao-miguel', 38.71111111, -9.12944444),
(1143674, 1004859, 'PT', 'São Miguel da Guarda', 1, 'sao-miguel-da-guarda', 40.55555556, -7.24611111),
(1143675, 1004859, 'PT', 'São Miguel de Alcainça', 1, 'sao-miguel-de-alcainca', 38.92111111, -9.29583333),
(1143676, 1004859, 'PT', 'São Nicolau', 1, 'sao-nicolau', 38.70750000, -9.13666667),
(1143677, 1004859, 'PT', 'São Paio', 1, 'sao-paio', 40.51527778, -7.58222222),
(1143678, 1004859, 'PT', 'São Paulo', 1, 'sao-paulo', 38.70760000, -9.14707000),
(1143679, 1004859, 'PT', 'São Pedro', 1, 'sao-pedro', 40.63222222, -7.38138889),
(1143680, 1004859, 'PT', 'São Pedro da Cadeira', 1, 'sao-pedro-da-cadeira', 39.06972222, -9.37166667),
(1143681, 1004859, 'PT', 'São Pedro de Penaferrim', 1, 'sao-pedro-de-penaferrim', 38.76947000, -9.38963000),
(1143682, 1004859, 'PT', 'São Pedro de Rio Seco', 1, 'sao-pedro-de-rio-seco', 40.66194444, -6.83916667),
(1143683, 1004859, 'PT', 'São Romão', 1, 'sao-romao', 40.40194444, -7.71694444),
(1143684, 1004859, 'PT', 'São Sebastião da Pedreira', 1, 'sao-sebastiao-da-pedreira', 38.73083333, -9.14916667),
(1143685, 1004859, 'PT', 'São Vicente', 1, 'sao-vicente', 40.53979000, -7.23536000),
(1143686, 1004859, 'PT', 'São Vicente de Fora', 1, 'sao-vicente-de-fora', 38.71583333, -9.12416667),
(1143630, 1004859, 'PT', 'Sapataria', 1, 'sapataria', 38.97188000, -9.20195000),
(1143631, 1004859, 'PT', 'Sazes da Beira', 1, 'sazes-da-beira', 40.34888889, -7.73527778),
(1143687, 1004859, 'PT', 'Sé', 1, 'se', 40.53861111, -7.26916667),
(1143632, 1004859, 'PT', 'Sebadelhe', 1, 'sebadelhe', 41.05222222, -7.26972222),
(1143633, 1004859, 'PT', 'Sebadelhe da Serra', 1, 'sebadelhe-da-serra', 40.87111111, -7.39833333),
(1143634, 1004859, 'PT', 'Seia', 1, 'seia', 40.42027778, -7.70333333),
(1143635, 1004859, 'PT', 'Seixas', 1, 'seixas', 41.11196000, -7.25251000),
(1143636, 1004859, 'PT', 'Seixo do Côa', 1, 'seixo-do-coa', 40.46305556, -7.02666667),
(1143637, 1004859, 'PT', 'Sequeira', 1, 'sequeira', 40.55361111, -7.22583333),
(1143638, 1004859, 'PT', 'Sequeiros', 1, 'sequeiros', 40.83714000, -7.49803000),
(1143639, 1004859, 'PT', 'Silveira', 1, 'silveira', 39.11111111, -9.36416667),
(1143640, 1004859, 'PT', 'Sintra', 1, 'sintra', 38.79736111, -9.39041667),
(1143641, 1004859, 'PT', 'Sintra (town)', 1, 'sintra-town', 38.81439000, -9.38370000),
(1143643, 1004859, 'PT', 'Sobral da Abelheira', 1, 'sobral-da-abelheira', 38.99833333, -9.32916667),
(1143644, 1004859, 'PT', 'Sobral da Serra', 1, 'sobral-da-serra', 40.61916667, -7.27972222),
(1143645, 1004859, 'PT', 'Sobral de Monte Agraço', 1, 'sobral-de-monte-agraco', 39.01666667, -9.15000000),
(1143642, 1004859, 'PT', 'Sobral Pichorro', 1, 'sobral-pichorro', 40.69073000, -7.45598000),
(1143646, 1004859, 'PT', 'Sobralinho', 1, 'sobralinho', 38.91750000, -9.02611111),
(1143647, 1004859, 'PT', 'Socorro', 1, 'socorro', 38.71666667, -9.13444444),
(1143648, 1004859, 'PT', 'Sortelha', 1, 'sortelha', 40.33138889, -7.21138889),
(1143649, 1004859, 'PT', 'Souro Pires', 1, 'souro-pires', 40.74500000, -7.12472222),
(1143650, 1004859, 'PT', 'Souto', 1, 'souto', 40.35666667, -6.95833333),
(1143652, 1004859, 'PT', 'Souto de Aguiar da Beira', 1, 'souto-de-aguiar-da-beira', 40.81075000, -7.49244000),
(1143651, 1004859, 'PT', 'Souto Maior', 1, 'souto-maior', 40.79686000, -7.31410000),
(1143688, 1004859, 'PT', 'Tamanhos', 1, 'tamanhos', 40.76166667, -7.31555556),
(1143689, 1004859, 'PT', 'Teixeira', 1, 'teixeira', 40.25333333, -7.74166667),
(1143690, 1004859, 'PT', 'Terrenho', 1, 'terrenho', 40.86611111, -7.35416667),
(1143691, 1004859, 'PT', 'Terrugem', 1, 'terrugem', 38.85111111, -9.37472222),
(1143692, 1004859, 'PT', 'Torre do Terrenho', 1, 'torre-do-terrenho', 40.88888889, -7.35944444),
(1143693, 1004859, 'PT', 'Torres', 1, 'torres', 40.74833333, -7.31916667),
(1143694, 1004859, 'PT', 'Torres Vedras', 1, 'torres-vedras', 39.08333333, -9.26666667),
(1143695, 1004859, 'PT', 'Torrozelo', 1, 'torrozelo', 40.38611111, -7.76027778),
(1143697, 1004859, 'PT', 'Touça', 1, 'touca', 41.04722222, -7.23388889),
(1143696, 1004859, 'PT', 'Tourais', 1, 'tourais', 40.47138889, -7.75083333),
(1143698, 1004859, 'PT', 'Trancoso', 1, 'trancoso', 40.78330000, -7.35000000),
(1143699, 1004859, 'PT', 'Travancinha', 1, 'travancinha', 40.42234000, -7.82175000),
(1143700, 1004859, 'PT', 'Triana', 1, 'triana', 39.06988000, -8.98660000),
(1143701, 1004859, 'PT', 'Trinta', 1, 'trinta', 40.50444444, -7.35527778),
(1143702, 1004859, 'PT', 'Turcifal', 1, 'turcifal', 39.03578000, -9.26017000),
(1143703, 1004859, 'PT', 'Unhos', 1, 'unhos', 38.82583333, -9.12138889),
(1143704, 1004859, 'PT', 'Valbom', 1, 'valbom', 40.78055556, -7.12888889),
(1143705, 1004859, 'PT', 'Valdujo', 1, 'valdujo', 40.84500000, -7.26694444),
(1143707, 1004859, 'PT', 'Vale da Mula', 1, 'vale-da-mula', 40.70361111, -6.82361111),
(1143708, 1004859, 'PT', 'Vale de Amoreira', 1, 'vale-de-amoreira', 40.41416667, -7.44138889),
(1143709, 1004859, 'PT', 'Vale de Azares', 1, 'vale-de-azares', 40.60492000, -7.36421000),
(1143710, 1004859, 'PT', 'Vale de Espinho', 1, 'vale-de-espinho', 40.29694444, -6.95055556),
(1143711, 1004859, 'PT', 'Vale de Estrela', 1, 'vale-de-estrela', 40.49944444, -7.30777778),
(1143712, 1004859, 'PT', 'Vale do Paraíso', 1, 'vale-do-paraiso', 39.11555556, -8.88583333),
(1143713, 1004859, 'PT', 'Vale do Seixo', 1, 'vale-do-seixo', 40.79291000, -7.27266000),
(1143706, 1004859, 'PT', 'Vale Flor', 1, 'vale-flor', 40.91277778, -7.28222222),
(1143714, 1004859, 'PT', 'Valezim', 1, 'valezim', 40.35889000, -7.70831000),
(1143715, 1004859, 'PT', 'Valhelhas', 1, 'valhelhas', 40.40722222, -7.40305556),
(1143716, 1004859, 'PT', 'Valverde', 1, 'valverde', 40.78416667, -7.52194444),
(1143759, 1004859, 'PT', 'Várzea de Meruge', 1, 'varzea-de-meruge', 40.39527778, -7.78361111),
(1143717, 1004859, 'PT', 'Vascoveiro', 1, 'vascoveiro', 40.73416667, -7.06972222),
(1143718, 1004859, 'PT', 'Vela', 1, 'vela', 40.43585000, -7.30369000),
(1143719, 1004859, 'PT', 'Velosa', 1, 'velosa', 40.65250000, -7.29000000),
(1143721, 1004859, 'PT', 'Venda do Pinheiro', 1, 'venda-do-pinheiro', 38.92527778, -9.23222222),
(1143720, 1004859, 'PT', 'Venda Nova', 1, 'venda-nova', 38.75422000, -9.21452000),
(1143722, 1004859, 'PT', 'Venteira', 1, 'venteira', 38.75944444, -9.24111111),
(1143723, 1004859, 'PT', 'Ventosa', 1, 'ventosa', 39.12694444, -9.08416667),
(1143724, 1004859, 'PT', 'Vermelha', 1, 'vermelha', 39.27277778, -9.10555556),
(1143725, 1004859, 'PT', 'Vermiosa', 1, 'vermiosa', 40.82722222, -6.87750000),
(1143726, 1004859, 'PT', 'Vialonga', 1, 'vialonga', 38.87094000, -9.06823000),
(1143727, 1004859, 'PT', 'Vide', 1, 'vide', 40.29444444, -7.78416667),
(1143728, 1004859, 'PT', 'Vide Entre Vinhas', 1, 'vide-entre-vinhas', 40.59722222, -7.40416667),
(1143729, 1004859, 'PT', 'Videmonte', 1, 'videmonte', 40.51388889, -7.39000000),
(1143730, 1004859, 'PT', 'Vila Boa', 1, 'vila-boa', 40.38305556, -7.00388889),
(1143731, 1004859, 'PT', 'Vila Boa do Mondego', 1, 'vila-boa-do-mondego', 40.62694444, -7.43777778),
(1143732, 1004859, 'PT', 'Vila Cortês da Serra', 1, 'vila-cortes-da-serra', 40.55083333, -7.52944444),
(1143733, 1004859, 'PT', 'Vila Cortês do Mondego', 1, 'vila-cortes-do-mondego', 40.60593000, -7.31236000),
(1143734, 1004859, 'PT', 'Vila Cova à Coelheira', 1, 'vila-cova-a-coelheira', 40.38333333, -7.73416667),
(1143750, 1004859, 'PT', 'Vila do Touro', 1, 'vila-do-touro', 40.41638889, -7.10555556),
(1143735, 1004859, 'PT', 'Vila Fernando', 1, 'vila-fernando', 40.49472222, -7.15444444),
(1143736, 1004859, 'PT', 'Vila Franca da Serra', 1, 'vila-franca-da-serra', 40.58722222, -7.53944444),
(1143737, 1004859, 'PT', 'Vila Franca das Naves', 1, 'vila-franca-das-naves', 40.72392000, -7.26206000),
(1143738, 1004859, 'PT', 'Vila Franca de Xira', 1, 'vila-franca-de-xira', 38.95000000, -8.98333333),
(1143739, 1004859, 'PT', 'Vila Franca do Deão', 1, 'vila-franca-do-deao', 40.65277778, -7.24222222),
(1143740, 1004859, 'PT', 'Vila Franca do Rosário', 1, 'vila-franca-do-rosario', 38.97472222, -9.25611111),
(1143741, 1004859, 'PT', 'Vila Garcia', 1, 'vila-garcia', 40.79414000, -7.23318000),
(1143742, 1004859, 'PT', 'Vila Nova da Rainha', 1, 'vila-nova-da-rainha', 39.03722222, -8.93361111),
(1143743, 1004859, 'PT', 'Vila Nova de Foz Côa', 1, 'vila-nova-de-foz-coa', 41.08333333, -7.13333333),
(1143744, 1004859, 'PT', 'Vila Nova de São Pedro', 1, 'vila-nova-de-sao-pedro', 39.21980000, -8.84037000),
(1143745, 1004859, 'PT', 'Vila Nova de Tazem', 1, 'vila-nova-de-tazem', 40.50250000, -7.70305556),
(1143746, 1004859, 'PT', 'Vila Ruiva', 1, 'vila-ruiva', 40.56944444, -7.51416667),
(1143747, 1004859, 'PT', 'Vila Soeiro do Chão', 1, 'vila-soeiro-do-chao', 40.61036000, -7.48202000),
(1143748, 1004859, 'PT', 'Vila Verde', 1, 'vila-verde', 39.15489000, -9.11512000),
(1143749, 1004859, 'PT', 'Vila Verde dos Francos', 1, 'vila-verde-dos-francos', 39.15444444, -9.11333333),
(1143751, 1004859, 'PT', 'Vilar', 1, 'vilar', 39.18671000, -9.10687000),
(1143755, 1004859, 'PT', 'Vilar de Amargo', 1, 'vilar-de-amargo', 40.94636000, -7.00157000),
(1143752, 1004859, 'PT', 'Vilar Formoso', 1, 'vilar-formoso', 40.61382000, -6.83493000),
(1143753, 1004859, 'PT', 'Vilar Maior', 1, 'vilar-maior', 40.48473000, -6.91999000),
(1143754, 1004859, 'PT', 'Vilar Torpim', 1, 'vilar-torpim', 40.82555556, -6.95194444),
(1143756, 1004859, 'PT', 'Vilares', 1, 'vilares', 40.72062000, -7.28348000),
(1143757, 1004859, 'PT', 'Vimeiro', 1, 'vimeiro', 39.17777778, -9.31777778),
(1143758, 1004859, 'PT', 'Vinhó', 1, 'vinho', 40.49583333, -7.62694444);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002240, 'PT', 'Leiria District', 1, 'leiria-district');

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 
(1088905, 1002240, 'PT', 'A dos Francos', 1, 'a-dos-francos', 39.32272000, -9.04743000),
(1088920, 1002240, 'PT', 'Alcobaça', 1, 'alcobaca', 39.55223000, -8.97749000),
(1088930, 1002240, 'PT', 'Alfeizerão', 1, 'alfeizerao', 39.49971000, -9.10341000),
(1088943, 1002240, 'PT', 'Aljubarrota', 1, 'aljubarrota', 39.56715000, -8.92925000),
(1088955, 1002240, 'PT', 'Alvaiázere', 1, 'alvaiazere', 39.81951000, -8.38858000),
(1088959, 1002240, 'PT', 'Alvorninha', 1, 'alvorninha', 39.38224000, -9.03674000),
(1088964, 1002240, 'PT', 'Amor', 1, 'amor', 39.80404000, -8.85984000),
(1088970, 1002240, 'PT', 'Ansião', 1, 'ansiao', 39.93424000, -8.42045000),
(1089000, 1002240, 'PT', 'Atouguia da Baleia', 1, 'atouguia-da-baleia', 39.33814000, -9.32630000),
(1089023, 1002240, 'PT', 'Batalha', 1, 'batalha', 39.66025000, -8.82475000),
(1089033, 1002240, 'PT', 'Benedita', 1, 'benedita', 39.42470000, -8.96996000),
(1089042, 1002240, 'PT', 'Bombarral', 1, 'bombarral', 39.26723000, -9.15795000),
(1089063, 1002240, 'PT', 'Caldas da Rainha', 1, 'caldas-da-rainha', 39.40326000, -9.13839000),
(1089090, 1002240, 'PT', 'Caranguejeira', 1, 'caranguejeira', 39.74619000, -8.70740000),
(1089102, 1002240, 'PT', 'Castanheira de Pêra', 1, 'castanheira-de-pera', 40.00717000, -8.21048000),
(1089113, 1002240, 'PT', 'Cela', 1, 'cela', 39.54075000, -9.03449000),
(1089164, 1002240, 'PT', 'Famalicão', 1, 'famalicao', 39.53642000, -9.08308000),
(1089180, 1002240, 'PT', 'Ferrel', 1, 'ferrel', 39.36398000, -9.31541000),
(1089184, 1002240, 'PT', 'Figueiró Dos Vinhos', 1, 'figueiro-dos-vinhos', 39.90617000, -8.27753000),
(1089188, 1002240, 'PT', 'Foz do Arelho', 1, 'foz-do-arelho', 39.43672000, -9.21374000),
(1089241, 1002240, 'PT', 'Leiria', 1, 'leiria', 39.74362000, -8.80705000),
(1089253, 1002240, 'PT', 'Louriçal', 1, 'lourical', 40.00390000, -8.73736000),
(1089261, 1002240, 'PT', 'Maceira', 1, 'maceira', 39.68853000, -8.89423000),
(1089277, 1002240, 'PT', 'Marinha Grande', 1, 'marinha-grande', 39.77681000, -8.95005000),
(1089302, 1002240, 'PT', 'Mira', 1, 'mira', 39.54315000, -8.71505000),
(1089322, 1002240, 'PT', 'Monte Real', 1, 'monte-real', 39.85210000, -8.86349000),
(1089323, 1002240, 'PT', 'Monte Redondo', 1, 'monte-redondo', 39.89930000, -8.83171000),
(1089341, 1002240, 'PT', 'Nadadouro', 1, 'nadadouro', 39.41927000, -9.19091000),
(1089342, 1002240, 'PT', 'Nazaré', 1, 'nazare', 39.59965000, -9.07162000),
(1089699, 1002240, 'PT', 'Óbidos', 1, 'obidos', 39.35854000, -9.17603000),
(1089385, 1002240, 'PT', 'Pataias', 1, 'pataias', 39.66978000, -8.99580000),
(1089391, 1002240, 'PT', 'Pedrógão Grande', 1, 'pedrogao-grande', 39.92682000, -8.20093000),
(1089400, 1002240, 'PT', 'Peniche', 1, 'peniche', 39.35580000, -9.38112000),
(1089411, 1002240, 'PT', 'Pombal', 1, 'pombal', 39.90735000, -8.66949000),
(1089433, 1002240, 'PT', 'Porto de Mós', 1, 'porto-de-mos', 39.60191000, -8.81839000),
(1089483, 1002240, 'PT', 'Salir de Matos', 1, 'salir-de-matos', 39.43186000, -9.09479000),
(1089496, 1002240, 'PT', 'Santa Catarina da Serra', 1, 'santa-catarina-da-serra', 39.67960000, -8.68679000),
(1089576, 1002240, 'PT', 'São Martinho do Porto', 1, 'sao-martinho-do-porto', 39.51444000, -9.13111000),
(1089534, 1002240, 'PT', 'Serra de El-Rei', 1, 'serra-de-el-rei', 39.33291000, -9.26843000),
(1089555, 1002240, 'PT', 'Souto da Carpalhosa', 1, 'souto-da-carpalhosa', 39.84867000, -8.83506000),
(1089615, 1002240, 'PT', 'Turquel', 1, 'turquel', 39.46411000, -8.97743000),
(1089622, 1002240, 'PT', 'Valado de Frades', 1, 'valado-de-frades', 39.58432000, -9.02290000),
(1089637, 1002240, 'PT', 'Vestiaria', 1, 'vestiaria', 39.55271000, -8.99790000),
(1089641, 1002240, 'PT', 'Vidais', 1, 'vidais', 39.36886000, -9.04916000),
(1089643, 1002240, 'PT', 'Vieira de Leiria', 1, 'vieira-de-leiria', 39.86945000, -8.93238000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002228, 'PT', 'Lisbon District', 1, 'lisbon-district');

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 
(1088904, 1002228, 'PT', 'A dos Cunhados', 1, 'a-dos-cunhados', 39.15237000, -9.29720000),
(1088908, 1002228, 'PT', 'Abrigada', 1, 'abrigada', 39.14416000, -9.01853000),
(1088915, 1002228, 'PT', 'Alcabideche', 1, 'alcabideche', 38.73366000, -9.40928000),
(1088922, 1002228, 'PT', 'Alcoentre', 1, 'alcoentre', 39.20857000, -8.95953000),
(1088928, 1002228, 'PT', 'Alenquer', 1, 'alenquer', 39.05315000, -9.00928000),
(1088933, 1002228, 'PT', 'Alfragide', 1, 'alfragide', 38.73203000, -9.21920000),
(1088937, 1002228, 'PT', 'Algés', 1, 'alges', 38.70245000, -9.22936000),
(1088936, 1002228, 'PT', 'Algueirão', 1, 'algueirao', 38.79764000, -9.34370000),
(1088939, 1002228, 'PT', 'Alhandra', 1, 'alhandra', 38.92732000, -9.00864000),
(1088947, 1002228, 'PT', 'Almargem', 1, 'almargem', 38.84485000, -9.27315000),
(1088956, 1002228, 'PT', 'Alvalade', 1, 'alvalade', 38.75328000, -9.14397000),
(1088960, 1002228, 'PT', 'Amadora', 1, 'amadora', 38.75382000, -9.23083000),
(1088973, 1002228, 'PT', 'Apelação', 1, 'apelacao', 38.81387000, -9.13225000),
(1088991, 1002228, 'PT', 'Arranhó', 1, 'arranho', 38.95378000, -9.13465000),
(1088996, 1002228, 'PT', 'Arruda dos Vinhos', 1, 'arruda-dos-vinhos', 38.97172000, -9.08807000),
(1089002, 1002228, 'PT', 'Aveiras de Cima', 1, 'aveiras-de-cima', 39.13796000, -8.89932000),
(1089009, 1002228, 'PT', 'Azambuja', 1, 'azambuja', 39.07029000, -8.86822000),
(1089017, 1002228, 'PT', 'Barcarena', 1, 'barcarena', 38.73245000, -9.28000000),
(1089024, 1002228, 'PT', 'Beato António', 1, 'beato-antonio', 38.73327000, -9.10335000),
(1089028, 1002228, 'PT', 'Belas', 1, 'belas', 38.77670000, -9.26353000),
(1089034, 1002228, 'PT', 'Benfica', 1, 'benfica', 38.75087000, -9.20282000),
(1089040, 1002228, 'PT', 'Bobadela', 1, 'bobadela', 38.80774000, -9.09925000),
(1089051, 1002228, 'PT', 'Bucelas', 1, 'bucelas', 38.90193000, -9.11885000),
(1089053, 1002228, 'PT', 'Cabanas de Torres', 1, 'cabanas-de-torres', 39.15581000, -9.06588000),
(1089059, 1002228, 'PT', 'Cacém', 1, 'cacem', 38.76698000, -9.29793000),
(1089060, 1002228, 'PT', 'Cadafais', 1, 'cadafais', 39.00461000, -9.00419000),
(1089061, 1002228, 'PT', 'Cadaval', 1, 'cadaval', 39.24621000, -9.06738000),
(1089072, 1002228, 'PT', 'Camarate', 1, 'camarate', 38.80358000, -9.12809000),
(1089075, 1002228, 'PT', 'Campelos', 1, 'campelos', 39.19678000, -9.23519000),
(1089083, 1002228, 'PT', 'Caneças', 1, 'canecas', 38.81321000, -9.22679000),
(1089092, 1002228, 'PT', 'Carcavelos', 1, 'carcavelos', 38.69105000, -9.32215000),
(1089093, 1002228, 'PT', 'Carnaxide', 1, 'carnaxide', 38.72706000, -9.24671000),
(1089096, 1002228, 'PT', 'Carregado', 1, 'carregado', 39.02362000, -8.97692000),
(1089101, 1002228, 'PT', 'Cascais', 1, 'cascais', 38.69681000, -9.42147000),
(1089103, 1002228, 'PT', 'Castanheira do Ribatejo', 1, 'castanheira-do-ribatejo', 38.99298000, -8.97346000),
(1089112, 1002228, 'PT', 'Caxias', 1, 'caxias', 38.70314000, -9.27666000),
(1089117, 1002228, 'PT', 'Charneca', 1, 'charneca', 38.78351000, -9.14348000),
(1089123, 1002228, 'PT', 'Colares', 1, 'colares', 38.79921000, -9.44691000),
(1089144, 1002228, 'PT', 'Ericeira', 1, 'ericeira', 38.96275000, -9.41563000),
(1089155, 1002228, 'PT', 'Estoril', 1, 'estoril', 38.70571000, -9.39773000),
(1089165, 1002228, 'PT', 'Famões', 1, 'famoes', 38.78804000, -9.21033000),
(1089186, 1002228, 'PT', 'Fontanelas', 1, 'fontanelas', 38.84806000, -9.43942000),
(1089244, 1002228, 'PT', 'Linda-a-Velha', 1, 'linda-a-velha', 38.71446000, -9.24220000),
(1089245, 1002228, 'PT', 'Lisbon', 1, 'lisbon', 38.72635000, -9.14843000),
(1089251, 1002228, 'PT', 'Loures', 1, 'loures', 38.83091000, -9.16845000),
(1089252, 1002228, 'PT', 'Lourinhã', 1, 'lourinha', 39.24745000, -9.31194000),
(1089268, 1002228, 'PT', 'Mafra', 1, 'mafra', 38.94107000, -9.32636000),
(1089271, 1002228, 'PT', 'Malveira', 1, 'malveira', 38.93213000, -9.25779000),
(1089283, 1002228, 'PT', 'Massamá', 1, 'massama', 38.75279000, -9.28110000),
(1089288, 1002228, 'PT', 'Meca', 1, 'meca', 39.08178000, -9.03459000),
(1089292, 1002228, 'PT', 'Mem Martins', 1, 'mem-martins', 38.79443000, -9.34284000),
(1089296, 1002228, 'PT', 'Milharado', 1, 'milharado', 38.94732000, -9.19914000),
(1089310, 1002228, 'PT', 'Moita dos Ferreiros', 1, 'moita-dos-ferreiros', 39.24825000, -9.22355000),
(1089320, 1002228, 'PT', 'Monte Estoril', 1, 'monte-estoril', 38.70636000, -9.40595000),
(1089332, 1002228, 'PT', 'Moscavide e Portela', 1, 'moscavide-e-portela', 38.77929000, -9.10222000),
(1089353, 1002228, 'PT', 'Odivelas', 1, 'odivelas', 38.79269000, -9.18380000),
(1089354, 1002228, 'PT', 'Oeiras', 1, 'oeiras', 38.71371000, -9.26832000),
(1089359, 1002228, 'PT', 'Olivais', 1, 'olivais', 38.76994000, -9.10674000),
(1089361, 1002228, 'PT', 'Olival do Basto', 1, 'olival-do-basto', 38.79079000, -9.16621000),
(1089371, 1002228, 'PT', 'Ota', 1, 'ota', 39.11199000, -8.99105000),
(1089386, 1002228, 'PT', 'Paço de Arcos', 1, 'paco-de-arcos', 38.69569000, -9.29143000),
(1089382, 1002228, 'PT', 'Parede', 1, 'parede', 38.69282000, -9.35412000),
(1089403, 1002228, 'PT', 'Pero Pinheiro', 1, 'pero-pinheiro', 38.85783000, -9.32352000),
(1089419, 1002228, 'PT', 'Pontinha', 1, 'pontinha', 38.76771000, -9.19935000),
(1089430, 1002228, 'PT', 'Porto Salvo', 1, 'porto-salvo', 38.72293000, -9.30473000),
(1089443, 1002228, 'PT', 'Póvoa de Santa Iria', 1, 'povoa-de-santa-iria', 38.86101000, -9.06453000),
(1089444, 1002228, 'PT', 'Póvoa de Santo Adrião', 1, 'povoa-de-santo-adriao', 38.80000000, -9.16667000),
(1089439, 1002228, 'PT', 'Prior Velho', 1, 'prior-velho', 38.79174000, -9.12119000),
(1089447, 1002228, 'PT', 'Queijas', 1, 'queijas', 38.71925000, -9.26255000),
(1089448, 1002228, 'PT', 'Queluz', 1, 'queluz', 38.75657000, -9.25451000),
(1089452, 1002228, 'PT', 'Ramada', 1, 'ramada', 38.80368000, -9.18770000),
(1089476, 1002228, 'PT', 'Rio de Mouro', 1, 'rio-de-mouro', 38.76613000, -9.32804000),
(1089481, 1002228, 'PT', 'Sacavém', 1, 'sacavem', 38.79202000, -9.10801000),
(1089504, 1002228, 'PT', 'Santa Iria da Azóia', 1, 'santa-iria-da-azoia', 38.84110000, -9.09908000),
(1089514, 1002228, 'PT', 'Santo Antão do Tojal', 1, 'santo-antao-do-tojal', 38.85151000, -9.13975000),
(1089517, 1002228, 'PT', 'Santo Isidoro', 1, 'santo-isidoro', 38.99593000, -9.39940000),
(1089520, 1002228, 'PT', 'Santos-o-Velho', 1, 'santos-o-velho', 38.70690000, -9.15611000),
(1089557, 1002228, 'PT', 'São Bartolomeu', 1, 'sao-bartolomeu', 39.27511000, -9.27885000),
(1089561, 1002228, 'PT', 'São Domingos de Rana', 1, 'sao-domingos-de-rana', 38.70194000, -9.34083000),
(1089567, 1002228, 'PT', 'São João da Talha', 1, 'sao-joao-da-talha', 38.82378000, -9.09719000),
(1089568, 1002228, 'PT', 'São João das Lampas', 1, 'sao-joao-das-lampas', 38.87376000, -9.39842000),
(1089571, 1002228, 'PT', 'São João dos Montes', 1, 'sao-joao-dos-montes', 38.93944000, -9.01892000),
(1089580, 1002228, 'PT', 'São Pedro da Cadeira', 1, 'sao-pedro-da-cadeira', 39.06983000, -9.37174000),
(1089543, 1002228, 'PT', 'Silveira', 1, 'silveira', 39.11120000, -9.36430000),
(1089546, 1002228, 'PT', 'Sintra', 1, 'sintra', 38.81439000, -9.38370000),
(1089548, 1002228, 'PT', 'Sobral de Monte Agraço', 1, 'sobral-de-monte-agraco', 39.01958000, -9.15081000),
(1089549, 1002228, 'PT', 'Sobralinho', 1, 'sobralinho', 38.91703000, -9.02656000),
(1089602, 1002228, 'PT', 'Terrugem', 1, 'terrugem', 38.70647000, -9.28693000),
(1089608, 1002228, 'PT', 'Torres Vedras', 1, 'torres-vedras', 39.09109000, -9.25860000),
(1089617, 1002228, 'PT', 'Unhos', 1, 'unhos', 38.81958000, -9.12007000),
(1089634, 1002228, 'PT', 'Venda do Pinheiro', 1, 'venda-do-pinheiro', 38.92365000, -9.23178000),
(1089636, 1002228, 'PT', 'Ventosa', 1, 'ventosa', 39.12696000, -9.08423000),
(1089638, 1002228, 'PT', 'Vialonga', 1, 'vialonga', 38.87206000, -9.07805000),
(1089649, 1002228, 'PT', 'Vila Franca de Xira', 1, 'vila-franca-de-xira', 38.92137000, -9.03220000),
(1089667, 1002228, 'PT', 'Vila Verde', 1, 'vila-verde', 39.15489000, -9.11512000),
(1089681, 1002228, 'PT', 'Vimeiro', 1, 'vimeiro', 39.17768000, -9.31702000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002231, 'PT', 'Madeira', 1, 'madeira');

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 
(1089693, 1002231, 'PT', 'Água de Pena', 1, 'agua-de-pena', 32.70143000, -16.77874000),
(1088978, 1002231, 'PT', 'Arco da Calheta', 1, 'arco-da-calheta', 32.71502000, -17.14974000),
(1089038, 1002231, 'PT', 'Boaventura', 1, 'boaventura', 32.81846000, -16.97268000),
(1089068, 1002231, 'PT', 'Calheta', 1, 'calheta', 32.71667000, -17.18333000),
(1089071, 1002231, 'PT', 'Camacha', 1, 'camacha', 32.67919000, -16.84462000),
(1089139, 1002231, 'PT', 'Câmara de Lobos', 1, 'camara-de-lobos', 32.65043000, -16.97718000),
(1089074, 1002231, 'PT', 'Campanário', 1, 'campanario', 32.66578000, -17.03576000),
(1089084, 1002231, 'PT', 'Canhas', 1, 'canhas', 32.69465000, -17.09867000),
(1089086, 1002231, 'PT', 'Caniçal', 1, 'canical', 32.73834000, -16.73836000),
(1089087, 1002231, 'PT', 'Caniço', 1, 'canico', 32.65078000, -16.83749000),
(1089138, 1002231, 'PT', 'Curral das Freiras', 1, 'curral-das-freiras', 32.72029000, -16.96993000),
(1089156, 1002231, 'PT', 'Estreito da Calheta', 1, 'estreito-da-calheta', 32.73704000, -17.18674000),
(1089161, 1002231, 'PT', 'Faial', 1, 'faial', 32.78333000, -16.85000000),
(1089162, 1002231, 'PT', 'Fajã da Ovelha', 1, 'faja-da-ovelha', 32.77457000, -17.23412000),
(1089197, 1002231, 'PT', 'Funchal', 1, 'funchal', 32.66568000, -16.92547000),
(1089262, 1002231, 'PT', 'Machico', 1, 'machico', 32.71620000, -16.76758000),
(1089351, 1002231, 'PT', 'Nossa Senhora do Monte', 1, 'nossa-senhora-do-monte', 32.66667000, -16.90000000),
(1089414, 1002231, 'PT', 'Ponta do Sol', 1, 'ponta-do-sol', 32.67980000, -17.10000000),
(1089432, 1002231, 'PT', 'Porto da Cruz', 1, 'porto-da-cruz', 32.76667000, -16.83333000),
(1089429, 1002231, 'PT', 'Porto Moniz', 1, 'porto-moniz', 32.86681000, -17.16667000),
(1089431, 1002231, 'PT', 'Porto Santo', 1, 'porto-santo', 33.07145000, -16.34304000),
(1089465, 1002231, 'PT', 'Ribeira Brava', 1, 'ribeira-brava', 32.67483000, -17.06288000),
(1089499, 1002231, 'PT', 'Santa Cruz', 1, 'santa-cruz', 32.68806000, -16.79388000),
(1089509, 1002231, 'PT', 'Santana', 1, 'santana', 32.80000000, -16.88333000),
(1089563, 1002231, 'PT', 'São Jorge', 1, 'sao-jorge', 32.81667000, -16.90000000),
(1089575, 1002231, 'PT', 'São Martinho', 1, 'sao-martinho', 32.64480000, -16.93843000),
(1089585, 1002231, 'PT', 'São Roque', 1, 'sao-roque', 32.66667000, -16.91667000),
(1089591, 1002231, 'PT', 'São Vicente', 1, 'sao-vicente', 32.79673000, -17.04323000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002232, 'PT', 'Portalegre District', 1, 'portalegre-district');

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 
(1088953, 1002232, 'PT', 'Alter do Chão', 1, 'alter-do-chao', 39.23098000, -7.74430000),
(1088995, 1002232, 'PT', 'Arronches', 1, 'arronches', 39.12242000, -7.28619000),
(1088999, 1002232, 'PT', 'Atalaia', 1, 'atalaia', 39.45551000, -7.87295000),
(1089008, 1002232, 'PT', 'Avis', 1, 'avis', 39.06448000, -7.89560000),
(1089078, 1002232, 'PT', 'Campo Maior', 1, 'campo-maior', 39.02935000, -7.06479000),
(1089107, 1002232, 'PT', 'Castelo de Vide', 1, 'castelo-de-vide', 39.41624000, -7.45680000),
(1089134, 1002232, 'PT', 'Crato', 1, 'crato', 39.28657000, -7.64408000),
(1089142, 1002232, 'PT', 'Elvas', 1, 'elvas', 38.88150000, -7.16282000),
(1089195, 1002232, 'PT', 'Fronteira', 1, 'fronteira', 39.07179000, -7.61052000),
(1089208, 1002232, 'PT', 'Gavião', 1, 'gaviao', 39.44462000, -7.89532000),
(1089282, 1002232, 'PT', 'Marvão', 1, 'marvao', 39.39377000, -7.37663000),
(1089314, 1002232, 'PT', 'Monforte', 1, 'monforte', 39.04960000, -7.44428000),
(1089319, 1002232, 'PT', 'Montargil', 1, 'montargil', 39.07771000, -8.17044000),
(1089347, 1002232, 'PT', 'Nisa', 1, 'nisa', 39.51828000, -7.67496000),
(1089418, 1002232, 'PT', 'Ponte de Sor', 1, 'ponte-de-sor', 39.21441000, -8.05420000),
(1089422, 1002232, 'PT', 'Portalegre', 1, 'portalegre', 39.29740000, -7.41538000),
(1089513, 1002232, 'PT', 'Santo André', 1, 'santo-andre', 39.05532000, -8.24414000),
(1089553, 1002232, 'PT', 'Sousel', 1, 'sousel', 38.96685000, -7.71788000),
(1089624, 1002232, 'PT', 'Vale da Amoreira', 1, 'vale-da-amoreira', 39.06969000, -7.69849000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002243, 'PT', 'Porto District', 1, 'porto-district');

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 
(1089691, 1002243, 'PT', 'Água Longa', 1, 'agua-longa', 41.24972000, -8.49285000),
(1089694, 1002243, 'PT', 'Águas Santas', 1, 'aguas-santas', 41.21017000, -8.57599000),
(1088911, 1002243, 'PT', 'Aguçadoura', 1, 'agucadoura', 41.43116000, -8.77844000),
(1088931, 1002243, 'PT', 'Alfena', 1, 'alfena', 41.23671000, -8.52454000),
(1088951, 1002243, 'PT', 'Alpendurada', 1, 'alpendurada', 41.08944000, -8.24643000),
(1088961, 1002243, 'PT', 'Amarante', 1, 'amarante', 41.27271000, -8.08245000),
(1088966, 1002243, 'PT', 'Amorim', 1, 'amorim', 41.40503000, -8.75046000),
(1088971, 1002243, 'PT', 'Anta', 1, 'anta', 41.26634000, -8.62844000),
(1088982, 1002243, 'PT', 'Arcozelo', 1, 'arcozelo', 41.06187000, -8.63192000),
(1088985, 1002243, 'PT', 'Argivai', 1, 'argivai', 41.37744000, -8.72987000),
(1089696, 1002243, 'PT', 'Árvore', 1, 'arvore', 41.33922000, -8.71806000),
(1089005, 1002243, 'PT', 'Aver-o-Mar', 1, 'aver-o-mar', 41.40607000, -8.77958000),
(1089006, 1002243, 'PT', 'Aves', 1, 'aves', 41.37034000, -8.41010000),
(1089007, 1002243, 'PT', 'Avintes', 1, 'avintes', 41.10711000, -8.55131000),
(1089011, 1002243, 'PT', 'Azenha', 1, 'azenha', 41.07651000, -8.62468000),
(1089013, 1002243, 'PT', 'Baguim do Monte', 1, 'baguim-do-monte', 41.19203000, -8.54118000),
(1089014, 1002243, 'PT', 'Baião', 1, 'baiao', 41.16384000, -8.03581000),
(1089015, 1002243, 'PT', 'Balazar', 1, 'balazar', 41.40435000, -8.62386000),
(1089016, 1002243, 'PT', 'Baltar', 1, 'baltar', 41.19272000, -8.38768000),
(1089022, 1002243, 'PT', 'Barrosas', 1, 'barrosas', 41.35534000, -8.29943000),
(1089026, 1002243, 'PT', 'Beiriz de Baixo', 1, 'beiriz-de-baixo', 41.39727000, -8.72385000),
(1089045, 1002243, 'PT', 'Bougado', 1, 'bougado', 41.33979000, -8.55180000),
(1089077, 1002243, 'PT', 'Campo', 1, 'campo', 41.18516000, -8.46493000),
(1089082, 1002243, 'PT', 'Canelas', 1, 'canelas', 41.08333000, -8.60000000),
(1089085, 1002243, 'PT', 'Canidelo', 1, 'canidelo', 41.12314000, -8.64654000),
(1089099, 1002243, 'PT', 'Carvalhosa', 1, 'carvalhosa', 41.30057000, -8.36080000),
(1089108, 1002243, 'PT', 'Castelões de Cepeda', 1, 'casteloes-de-cepeda', 41.20265000, -8.33516000),
(1089145, 1002243, 'PT', 'Ermesinde', 1, 'ermesinde', 41.21653000, -8.55318000),
(1089154, 1002243, 'PT', 'Estela', 1, 'estela', 41.44944000, -8.75166000),
(1089202, 1002243, 'PT', 'Fânzeres', 1, 'fanzeres', 41.16754000, -8.52981000),
(1089171, 1002243, 'PT', 'Felgueiras', 1, 'felgueiras', 41.34774000, -8.20808000),
(1089175, 1002243, 'PT', 'Ferreira', 1, 'ferreira', 41.26718000, -8.34434000),
(1089183, 1002243, 'PT', 'Figueiró', 1, 'figueiro', 41.29922000, -8.16779000),
(1089189, 1002243, 'PT', 'Foz do Douro', 1, 'foz-do-douro', 41.15119000, -8.67125000),
(1089190, 1002243, 'PT', 'Foz do Sousa', 1, 'foz-do-sousa', 41.09668000, -8.50184000),
(1089192, 1002243, 'PT', 'Frazão', 1, 'frazao', 41.25866000, -8.40014000),
(1089193, 1002243, 'PT', 'Freamunde', 1, 'freamunde', 41.28835000, -8.33533000),
(1089206, 1002243, 'PT', 'Gandra', 1, 'gandra', 41.20116000, -8.43376000),
(1089209, 1002243, 'PT', 'Gemunde', 1, 'gemunde', 41.26766000, -8.64515000),
(1089213, 1002243, 'PT', 'Gondomar', 1, 'gondomar', 41.12015000, -8.49595000),
(1089214, 1002243, 'PT', 'Grijó', 1, 'grijo', 41.02836000, -8.58017000),
(1089218, 1002243, 'PT', 'Guifões', 1, 'guifoes', 41.19748000, -8.66899000),
(1089221, 1002243, 'PT', 'Gulpilhares', 1, 'gulpilhares', 41.08292000, -8.62679000),
(1089226, 1002243, 'PT', 'Jovim', 1, 'jovim', 41.11102000, -8.51903000),
(1089239, 1002243, 'PT', 'Lavra', 1, 'lavra', 41.25935000, -8.71849000),
(1089242, 1002243, 'PT', 'Leça da Palmeira', 1, 'leca-da-palmeira', 41.19100000, -8.70027000),
(1089243, 1002243, 'PT', 'Leça do Bailio', 1, 'leca-do-bailio', 41.21201000, -8.63422000),
(1089247, 1002243, 'PT', 'Lordelo', 1, 'lordelo', 41.23451000, -8.40297000),
(1089255, 1002243, 'PT', 'Lousada', 1, 'lousada', 41.28355000, -8.27437000),
(1089258, 1002243, 'PT', 'Lustosa', 1, 'lustosa', 41.34081000, -8.31715000),
(1089266, 1002243, 'PT', 'Madalena', 1, 'madalena', 41.21616000, -8.33451000),
(1089270, 1002243, 'PT', 'Maia', 1, 'maia', 41.24254000, -8.60257000),
(1089274, 1002243, 'PT', 'Marco de Canaveses', 1, 'marco-de-canaveses', 41.15545000, -8.16954000),
(1089275, 1002243, 'PT', 'Marco de Canavezes', 1, 'marco-de-canavezes', 41.18389000, -8.14864000),
(1089276, 1002243, 'PT', 'Margaride', 1, 'margaride', 41.36478000, -8.19999000),
(1089284, 1002243, 'PT', 'Matosinhos', 1, 'matosinhos', 41.18207000, -8.68908000),
(1089289, 1002243, 'PT', 'Meinedo', 1, 'meinedo', 41.24827000, -8.25807000),
(1089291, 1002243, 'PT', 'Melres', 1, 'melres', 41.06989000, -8.40091000),
(1089297, 1002243, 'PT', 'Milheirós', 1, 'milheiros', 41.21478000, -8.58837000),
(1089301, 1002243, 'PT', 'Mindelo', 1, 'mindelo', 41.31527000, -8.72124000),
(1089329, 1002243, 'PT', 'Moreira', 1, 'moreira', 41.05600000, -8.38939000),
(1089344, 1002243, 'PT', 'Negrelos', 1, 'negrelos', 41.34946000, -8.40145000),
(1089348, 1002243, 'PT', 'Nogueira', 1, 'nogueira', 41.24246000, -8.58685000),
(1089360, 1002243, 'PT', 'Olival', 1, 'olival', 41.05024000, -8.54416000),
(1089367, 1002243, 'PT', 'Oliveira do Douro', 1, 'oliveira-do-douro', 41.12466000, -8.58463000),
(1089388, 1002243, 'PT', 'Paços de Ferreira', 1, 'pacos-de-ferreira', 41.28964000, -8.37584000),
(1089383, 1002243, 'PT', 'Paredes', 1, 'paredes', 41.20501000, -8.37506000),
(1089389, 1002243, 'PT', 'Pedroso', 1, 'pedroso', 41.41103000, -8.74897000),
(1089390, 1002243, 'PT', 'Pedrouços', 1, 'pedroucos', 41.18880000, -8.58624000),
(1089394, 1002243, 'PT', 'Penafiel', 1, 'penafiel', 41.20931000, -8.26996000),
(1089401, 1002243, 'PT', 'Perafita', 1, 'perafita', 41.18252000, -8.25450000),
(1089404, 1002243, 'PT', 'Perozinho', 1, 'perozinho', 41.06513000, -8.58531000),
(1089425, 1002243, 'PT', 'Porto', 1, 'porto', 41.14961000, -8.61099000),
(1089445, 1002243, 'PT', 'Póvoa de Varzim', 1, 'povoa-de-varzim', 41.38344000, -8.76364000),
(1089455, 1002243, 'PT', 'Rebordões', 1, 'rebordoes', 41.35509000, -8.42355000),
(1089454, 1002243, 'PT', 'Rebordosa', 1, 'rebordosa', 41.22405000, -8.40669000),
(1089456, 1002243, 'PT', 'Recarei', 1, 'recarei', 41.15356000, -8.41178000),
(1089472, 1002243, 'PT', 'Rio Mau', 1, 'rio-mau', 41.40422000, -8.67994000),
(1089474, 1002243, 'PT', 'Rio Tinto', 1, 'rio-tinto', 41.17872000, -8.55953000),
(1089491, 1002243, 'PT', 'Sandim', 1, 'sandim', 41.03508000, -8.50700000),
(1089503, 1002243, 'PT', 'Santa Cruz do Bispo', 1, 'santa-cruz-do-bispo', 41.21462000, -8.67406000),
(1089518, 1002243, 'PT', 'Santo Izidoro', 1, 'santo-izidoro', 41.21083000, -8.14224000),
(1089519, 1002243, 'PT', 'Santo Tirso', 1, 'santo-tirso', 41.33014000, -8.43827000),
(1089562, 1002243, 'PT', 'São Félix da Marinha', 1, 'sao-felix-da-marinha', 41.03555000, -8.62259000),
(1089573, 1002243, 'PT', 'São Mamede de Infesta', 1, 'sao-mamede-de-infesta', 41.19183000, -8.61105000),
(1089579, 1002243, 'PT', 'São Miguel do Couto', 1, 'sao-miguel-do-couto', 41.33167000, -8.46185000),
(1089581, 1002243, 'PT', 'São Pedro da Cova', 1, 'sao-pedro-da-cova', 41.14331000, -8.50033000),
(1089584, 1002243, 'PT', 'São Romão do Coronado', 1, 'sao-romao-do-coronado', 41.28544000, -8.56320000),
(1089527, 1002243, 'PT', 'Senhora da Hora', 1, 'senhora-da-hora', 41.18641000, -8.65172000),
(1089530, 1002243, 'PT', 'Sermonde', 1, 'sermonde', 41.04712000, -8.58449000),
(1089532, 1002243, 'PT', 'Seroa', 1, 'seroa', 41.26511000, -8.42892000),
(1089538, 1002243, 'PT', 'Serzedo', 1, 'serzedo', 41.05105000, -8.61605000),
(1089547, 1002243, 'PT', 'Sobrado', 1, 'sobrado', 41.21041000, -8.45488000),
(1089600, 1002243, 'PT', 'Telões', 1, 'teloes', 41.31054000, -8.11101000),
(1089613, 1002243, 'PT', 'Trofa', 1, 'trofa', 41.30646000, -8.57640000),
(1089620, 1002243, 'PT', 'Vairão', 1, 'vairao', 41.33290000, -8.66657000),
(1089621, 1002243, 'PT', 'Valadares', 1, 'valadares', 41.14737000, -7.98120000),
(1089623, 1002243, 'PT', 'Valbom', 1, 'valbom', 41.12921000, -8.56199000),
(1089631, 1002243, 'PT', 'Valongo', 1, 'valongo', 41.20797000, -8.50086000),
(1089672, 1002243, 'PT', 'Vila do Conde', 1, 'vila-do-conde', 41.35326000, -8.74516000),
(1089652, 1002243, 'PT', 'Vila Meã', 1, 'vila-mea', 41.25116000, -8.18397000),
(1089655, 1002243, 'PT', 'Vila Nova da Telha', 1, 'vila-nova-da-telha', 41.07170000, -8.64146000),
(1089657, 1002243, 'PT', 'Vila Nova de Gaia', 1, 'vila-nova-de-gaia', 41.12401000, -8.61241000),
(1089675, 1002243, 'PT', 'Vilar de Andorinho', 1, 'vilar-de-andorinho', 41.10574000, -8.58622000),
(1089677, 1002243, 'PT', 'Vilar do Paraíso', 1, 'vilar-do-paraiso', 41.08974000, -8.62110000),
(1089678, 1002243, 'PT', 'Vilarinho', 1, 'vilarinho', 41.35955000, -8.33123000),
(1089685, 1002243, 'PT', 'Vizela', 1, 'vizela', 41.38242000, -8.24887000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002238, 'PT', 'Santarém District', 1, 'santarem-district');

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 
(1088906, 1002238, 'PT', 'Abrantes', 1, 'abrantes', 39.46667000, -8.20000000),
(1088916, 1002238, 'PT', 'Alcanede', 1, 'alcanede', 39.41501000, -8.82189000),
(1088917, 1002238, 'PT', 'Alcanena', 1, 'alcanena', 39.45900000, -8.66892000),
(1088918, 1002238, 'PT', 'Alcanhões', 1, 'alcanhoes', 39.29603000, -8.65847000),
(1088932, 1002238, 'PT', 'Alferrarede', 1, 'alferrarede', 39.48333000, -8.16667000),
(1088948, 1002238, 'PT', 'Almeirim', 1, 'almeirim', 39.20837000, -8.62635000),
(1088952, 1002238, 'PT', 'Alpiarça', 1, 'alpiarca', 39.25712000, -8.58187000),
(1088963, 1002238, 'PT', 'Amiães de Baixo', 1, 'amiaes-de-baixo', 39.44296000, -8.73358000),
(1089012, 1002238, 'PT', 'Azinhaga', 1, 'azinhaga', 39.34877000, -8.53005000),
(1089031, 1002238, 'PT', 'Bemfica', 1, 'bemfica', 39.14325000, -8.68717000),
(1089032, 1002238, 'PT', 'Benavente', 1, 'benavente', 38.90800000, -8.76898000),
(1089098, 1002238, 'PT', 'Cartaxo', 1, 'cartaxo', 39.15377000, -8.81373000),
(1089116, 1002238, 'PT', 'Chamusca', 1, 'chamusca', 39.29900000, -8.39933000),
(1089127, 1002238, 'PT', 'Constância', 1, 'constancia', 39.45718000, -8.30368000),
(1089130, 1002238, 'PT', 'Coruche', 1, 'coruche', 38.95950000, -8.52745000),
(1089143, 1002238, 'PT', 'Entroncamento', 1, 'entroncamento', 39.46667000, -8.46667000),
(1089201, 1002238, 'PT', 'Fátima', 1, 'fatima', 39.62071000, -8.65237000),
(1089169, 1002238, 'PT', 'Fazendas de Almeirim', 1, 'fazendas-de-almeirim', 39.17553000, -8.56927000),
(1089177, 1002238, 'PT', 'Ferreira do Zêzere', 1, 'ferreira-do-zezere', 39.72303000, -8.31661000),
(1089211, 1002238, 'PT', 'Golegã', 1, 'golega', 39.38683000, -8.50591000),
(1089285, 1002238, 'PT', 'Mação', 1, 'macao', 39.59331000, -7.99772000),
(1089265, 1002238, 'PT', 'Madalena', 1, 'madalena', 39.57133000, -8.44635000),
(1089278, 1002238, 'PT', 'Marinhais', 1, 'marinhais', 39.04730000, -8.70236000),
(1089300, 1002238, 'PT', 'Minde', 1, 'minde', 39.51631000, -8.68799000),
(1089315, 1002238, 'PT', 'Monsanto', 1, 'monsanto', 39.46203000, -8.71180000),
(1089317, 1002238, 'PT', 'Montalvinho', 1, 'montalvinho', 39.48333000, -8.30000000),
(1089318, 1002238, 'PT', 'Montalvo', 1, 'montalvo', 39.48333000, -8.30000000),
(1089373, 1002238, 'PT', 'Ourém', 1, 'ourem', 39.66179000, -8.57895000),
(1089376, 1002238, 'PT', 'Paialvo', 1, 'paialvo', 39.56399000, -8.46835000),
(1089392, 1002238, 'PT', 'Pego', 1, 'pego', 39.46146000, -8.14955000),
(1089408, 1002238, 'PT', 'Pinheiro Grande', 1, 'pinheiro-grande', 39.39212000, -8.43410000),
(1089409, 1002238, 'PT', 'Poceirão', 1, 'poceirao', 38.83095000, -8.79365000),
(1089420, 1002238, 'PT', 'Pontével', 1, 'pontevel', 39.14945000, -8.83880000),
(1089438, 1002238, 'PT', 'Praia do Ribatejo', 1, 'praia-do-ribatejo', 39.46667000, -8.35000000),
(1089463, 1002238, 'PT', 'Riachos', 1, 'riachos', 39.44472000, -8.51420000),
(1089471, 1002238, 'PT', 'Rio Maior', 1, 'rio-maior', 39.34288000, -8.93806000),
(1089486, 1002238, 'PT', 'Salvaterra de Magos', 1, 'salvaterra-de-magos', 39.04482000, -8.68903000),
(1089488, 1002238, 'PT', 'Samora Correia', 1, 'samora-correia', 38.93709000, -8.87178000),
(1089506, 1002238, 'PT', 'Santa Margarida da Coutada', 1, 'santa-margarida-da-coutada', 39.45000000, -8.31667000),
(1089510, 1002238, 'PT', 'Santarém', 1, 'santarem', 39.23333000, -8.68333000),
(1089578, 1002238, 'PT', 'São Miguel de Rio Torto', 1, 'sao-miguel-de-rio-torto', 39.43333000, -8.21667000),
(1089593, 1002238, 'PT', 'São Vicente do Paul', 1, 'sao-vicente-do-paul', 39.34946000, -8.62221000),
(1089521, 1002238, 'PT', 'Sardoal', 1, 'sardoal', 39.55643000, -8.14323000),
(1089604, 1002238, 'PT', 'Tomar', 1, 'tomar', 39.60199000, -8.40924000),
(1089607, 1002238, 'PT', 'Torres Novas', 1, 'torres-novas', 39.49160000, -8.54796000),
(1089610, 1002238, 'PT', 'Tramagal', 1, 'tramagal', 39.45000000, -8.25000000),
(1089626, 1002238, 'PT', 'Vale de Figueira', 1, 'vale-de-figueira', 39.30569000, -8.62876000),
(1089627, 1002238, 'PT', 'Vale de Santarém', 1, 'vale-de-santarem', 39.19052000, -8.72735000),
(1089646, 1002238, 'PT', 'Vila Chã de Ourique', 1, 'vila-cha-de-ourique', 39.17219000, -8.76658000),
(1089654, 1002238, 'PT', 'Vila Nova da Barquinha', 1, 'vila-nova-da-barquinha', 39.46081000, -8.43588000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002242, 'PT', 'Setúbal District', 1, 'setubal-district');

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 
(1088924, 1002242, 'PT', 'Alcácer do Sal', 1, 'alcacer-do-sal', 38.37326000, -8.51444000),
(1088921, 1002242, 'PT', 'Alcochete', 1, 'alcochete', 38.73827000, -8.97936000),
(1088927, 1002242, 'PT', 'Aldeia de Paio Pires', 1, 'aldeia-de-paio-pires', 38.61667000, -9.08333000),
(1088940, 1002242, 'PT', 'Alhos Vedros', 1, 'alhos-vedros', 38.65486000, -9.02368000),
(1088945, 1002242, 'PT', 'Almada', 1, 'almada', 38.67902000, -9.15690000),
(1088965, 1002242, 'PT', 'Amora', 1, 'amora', 38.62961000, -9.11557000),
(1088992, 1002242, 'PT', 'Arrentela', 1, 'arrentela', 38.62500000, -9.10151000),
(1089010, 1002242, 'PT', 'Azeitão', 1, 'azeitao', 38.51919000, -9.01390000),
(1089021, 1002242, 'PT', 'Barreiro', 1, 'barreiro', 38.66314000, -9.07240000),
(1089058, 1002242, 'PT', 'Cacilhas', 1, 'cacilhas', 38.68638000, -9.14938000),
(1089089, 1002242, 'PT', 'Caparica', 1, 'caparica', 38.66179000, -9.20032000),
(1089115, 1002242, 'PT', 'Cercal', 1, 'cercal', 37.80129000, -8.67400000),
(1089118, 1002242, 'PT', 'Charneca de Caparica', 1, 'charneca-de-caparica', 38.62032000, -9.19426000),
(1089124, 1002242, 'PT', 'Comporta', 1, 'comporta', 38.38059000, -8.78608000),
(1089128, 1002242, 'PT', 'Corroios', 1, 'corroios', 38.64004000, -9.15080000),
(1089132, 1002242, 'PT', 'Costa de Caparica', 1, 'costa-de-caparica', 38.64458000, -9.23556000),
(1089215, 1002242, 'PT', 'Grândola', 1, 'grandola', 38.18999000, -8.61197000),
(1089236, 1002242, 'PT', 'Laranjeira', 1, 'laranjeira', 38.65599000, -9.15376000),
(1089240, 1002242, 'PT', 'Lavradio', 1, 'lavradio', 38.66808000, -9.05204000),
(1089309, 1002242, 'PT', 'Moita', 1, 'moita', 38.65854000, -9.01040000),
(1089326, 1002242, 'PT', 'Montijo', 1, 'montijo', 38.72990000, -8.69364000),
(1089377, 1002242, 'PT', 'Palmela', 1, 'palmela', 38.56902000, -8.90126000),
(1089406, 1002242, 'PT', 'Piedade', 1, 'piedade', 38.67005000, -9.15852000),
(1089407, 1002242, 'PT', 'Pinhal Novo', 1, 'pinhal-novo', 38.63106000, -8.91376000),
(1089426, 1002242, 'PT', 'Porto Covo', 1, 'porto-covo', 37.85256000, -8.79018000),
(1089436, 1002242, 'PT', 'Pragal', 1, 'pragal', 38.67459000, -9.16981000),
(1089450, 1002242, 'PT', 'Quinta do Anjo', 1, 'quinta-do-anjo', 38.56753000, -8.94228000),
(1089449, 1002242, 'PT', 'Quinta Do Conde', 1, 'quinta-do-conde', 38.56528000, -9.04316000),
(1089478, 1002242, 'PT', 'Rosairinho', 1, 'rosairinho', 38.67734000, -9.00836000),
(1089489, 1002242, 'PT', 'Samouco', 1, 'samouco', 38.72035000, -9.00471000),
(1089511, 1002242, 'PT', 'Santiago do Cacém', 1, 'santiago-do-cacem', 38.02502000, -8.67577000),
(1089512, 1002242, 'PT', 'Santo André', 1, 'santo-andre', 38.06078000, -8.78220000),
(1089515, 1002242, 'PT', 'Santo António da Charneca', 1, 'santo-antonio-da-charneca', 38.62561000, -9.03043000),
(1089522, 1002242, 'PT', 'Sarilhos Pequenos', 1, 'sarilhos-pequenos', 38.68176000, -8.98231000),
(1089523, 1002242, 'PT', 'Seixal', 1, 'seixal', 38.61173000, -9.10371000),
(1089539, 1002242, 'PT', 'Sesimbra', 1, 'sesimbra', 38.49486000, -9.12011000),
(1089540, 1002242, 'PT', 'Setúbal', 1, 'setubal', 38.52440000, -8.88820000),
(1089545, 1002242, 'PT', 'Sines', 1, 'sines', 37.95622000, -8.86979000),
(1089550, 1002242, 'PT', 'Sobreda', 1, 'sobreda', 38.64961000, -9.18977000),
(1089609, 1002242, 'PT', 'Trafaria', 1, 'trafaria', 38.67222000, -9.23268000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002245, 'PT', 'Viana do Castelo District', 1, 'viana-do-castelo-district');

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 
(1088981, 1002245, 'PT', 'Arcos de Valdevez', 1, 'arcos-de-valdevez', 41.84668000, -8.41905000),
(1088983, 1002245, 'PT', 'Areosa', 1, 'areosa', 41.71779000, -8.85707000),
(1089073, 1002245, 'PT', 'Caminha', 1, 'caminha', 41.84647000, -8.80133000),
(1089140, 1002245, 'PT', 'Darque', 1, 'darque', 41.68333000, -8.76667000),
(1089286, 1002245, 'PT', 'Meadela', 1, 'meadela', 41.70654000, -8.79628000),
(1089290, 1002245, 'PT', 'Melgaço', 1, 'melgaco', 42.08067000, -8.24844000),
(1089327, 1002245, 'PT', 'Monção', 1, 'moncao', 42.07892000, -8.48076000),
(1089337, 1002245, 'PT', 'Mozelos', 1, 'mozelos', 41.86774000, -8.39776000),
(1089384, 1002245, 'PT', 'Paredes de Coura', 1, 'paredes-de-coura', 41.90995000, -8.57034000),
(1089416, 1002245, 'PT', 'Ponte da Barca', 1, 'ponte-da-barca', 41.80669000, -8.31014000),
(1089417, 1002245, 'PT', 'Ponte de Lima', 1, 'ponte-de-lima', 41.74682000, -8.57637000),
(1089629, 1002245, 'PT', 'Valença', 1, 'valenca', 42.02821000, -8.63388000),
(1089628, 1002245, 'PT', 'Valenza', 1, 'valenza', 42.02418000, -8.63474000),
(1089640, 1002245, 'PT', 'Viana do Castelo', 1, 'viana-do-castelo', 41.69371000, -8.83456000),
(1089662, 1002245, 'PT', 'Vila Praia de Âncora', 1, 'vila-praia-de-ancora', 41.81098000, -8.85255000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002234, 'PT', 'Vila Real District', 1, 'vila-real-district');

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 
(1088941, 1002234, 'PT', 'Alijó', 1, 'alijo', 41.28447000, -7.48545000),
(1089044, 1002234, 'PT', 'Boticas', 1, 'boticas', 41.68939000, -7.66914000),
(1089119, 1002234, 'PT', 'Chaves', 1, 'chaves', 41.73961000, -7.45030000),
(1089168, 1002234, 'PT', 'Favaios', 1, 'favaios', 41.26876000, -7.50465000),
(1089210, 1002234, 'PT', 'Godim', 1, 'godim', 41.17104000, -7.80303000),
(1089294, 1002234, 'PT', 'Mesão Frio', 1, 'mesao-frio', 41.16190000, -7.87284000),
(1089313, 1002234, 'PT', 'Mondim de Basto', 1, 'mondim-de-basto', 41.41347000, -7.95479000),
(1089316, 1002234, 'PT', 'Montalegre', 1, 'montalegre', 41.83180000, -7.78999000),
(1089339, 1002234, 'PT', 'Murça', 1, 'murca', 41.41825000, -7.45121000),
(1089405, 1002234, 'PT', 'Peso da Régua', 1, 'peso-da-regua', 41.19157000, -7.83668000),
(1089468, 1002234, 'PT', 'Ribeira de Pena', 1, 'ribeira-de-pena', 41.51021000, -7.79673000),
(1089480, 1002234, 'PT', 'Sabrosa', 1, 'sabrosa', 41.26702000, -7.57601000),
(1089500, 1002234, 'PT', 'Santa Cruz', 1, 'santa-cruz', 41.76007000, -7.46834000),
(1089508, 1002234, 'PT', 'Santa Marta de Penaguião', 1, 'santa-marta-de-penaguiao', 41.20991000, -7.78386000),
(1089551, 1002234, 'PT', 'Sobreira', 1, 'sobreira', 41.52371000, -7.80234000),
(1089632, 1002234, 'PT', 'Valpaços', 1, 'valpacos', 41.62082000, -7.33607000),
(1089661, 1002234, 'PT', 'Vila Pouca de Aguiar', 1, 'vila-pouca-de-aguiar', 41.52079000, -7.63671000),
(1089663, 1002234, 'PT', 'Vila Real', 1, 'vila-real', 41.30021000, -7.73985000),
(1089680, 1002234, 'PT', 'Vilela', 1, 'vilela', 41.22511000, -7.60338000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002237, 'PT', 'Viseu District', 1, 'viseu-district');

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 
(1088907, 1002237, 'PT', 'Abraveses', 1, 'abraveses', 40.68137000, -7.92102000),
(1088987, 1002237, 'PT', 'Armamar', 1, 'armamar', 41.09718000, -7.68553000),
(1089054, 1002237, 'PT', 'Cabanas de Viriato', 1, 'cabanas-de-viriato', 40.47662000, -7.97445000),
(1089076, 1002237, 'PT', 'Campo', 1, 'campo', 40.71086000, -7.91445000),
(1089079, 1002237, 'PT', 'Campo de Besteiros', 1, 'campo-de-besteiros', 40.55655000, -8.13432000),
(1089080, 1002237, 'PT', 'Canas de Senhorim', 1, 'canas-de-senhorim', 40.50012000, -7.89874000),
(1089097, 1002237, 'PT', 'Carregal do Sal', 1, 'carregal-do-sal', 40.45007000, -7.99819000),
(1089109, 1002237, 'PT', 'Castro Daire', 1, 'castro-daire', 40.92279000, -7.93878000),
(1089121, 1002237, 'PT', 'Cinfães', 1, 'cinfaes', 41.03986000, -8.11218000),
(1089146, 1002237, 'PT', 'Ervedosa do Douro', 1, 'ervedosa-do-douro', 41.16626000, -7.47305000),
(1089235, 1002237, 'PT', 'Lamego', 1, 'lamego', 41.10229000, -7.81025000),
(1089272, 1002237, 'PT', 'Mangualde', 1, 'mangualde', 40.60425000, -7.76115000),
(1089308, 1002237, 'PT', 'Moimenta da Beira', 1, 'moimenta-da-beira', 40.97134000, -7.62959000),
(1089331, 1002237, 'PT', 'Mortágua', 1, 'mortagua', 40.39434000, -8.25811000),
(1089345, 1002237, 'PT', 'Nelas', 1, 'nelas', 40.53216000, -7.85152000),
(1089365, 1002237, 'PT', 'Oliveira de Frades', 1, 'oliveira-de-frades', 40.73357000, -8.17481000),
(1089395, 1002237, 'PT', 'Penalva do Castelo', 1, 'penalva-do-castelo', 40.66791000, -7.66015000),
(1089398, 1002237, 'PT', 'Penedono', 1, 'penedono', 40.98875000, -7.39386000),
(1089462, 1002237, 'PT', 'Resende', 1, 'resende', 41.07688000, -7.95123000),
(1089475, 1002237, 'PT', 'Rio de Loba', 1, 'rio-de-loba', 40.66596000, -7.87781000),
(1089498, 1002237, 'PT', 'Santa Comba Dão', 1, 'santa-comba-dao', 40.40442000, -8.11380000),
(1089566, 1002237, 'PT', 'São João da Pesqueira', 1, 'sao-joao-da-pesqueira', 41.14805000, -7.40489000),
(1089569, 1002237, 'PT', 'São João de Areias', 1, 'sao-joao-de-areias', 40.38722000, -8.06783000),
(1089583, 1002237, 'PT', 'São Pedro do Sul', 1, 'sao-pedro-do-sul', 40.80073000, -8.09023000),
(1089556, 1002237, 'PT', 'Sátão', 1, 'satao', 40.76246000, -7.67600000),
(1089531, 1002237, 'PT', 'Sernancelhe', 1, 'sernancelhe', 40.92097000, -7.51226000),
(1089594, 1002237, 'PT', 'Tabuaço', 1, 'tabuaco', 41.09555000, -7.56735000),
(1089595, 1002237, 'PT', 'Tarouca', 1, 'tarouca', 41.02651000, -7.74998000),
(1089605, 1002237, 'PT', 'Tondela', 1, 'tondela', 40.54052000, -8.10040000),
(1089612, 1002237, 'PT', 'Treixedo', 1, 'treixedo', 40.43246000, -8.09428000),
(1089659, 1002237, 'PT', 'Vila Nova de Paiva', 1, 'vila-nova-de-paiva', 40.86590000, -7.76127000),
(1089684, 1002237, 'PT', 'Viseu', 1, 'viseu', 40.67450000, -7.91721000),
(1089687, 1002237, 'PT', 'Vouzela', 1, 'vouzela', 40.68944000, -8.11360000);

