REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('NL', 'Netherlands The', 'netherlands-the', '31', 'Nederland', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002624, 'NL', 'Bonaire', 1, 'bonaire');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002613, 'NL', 'Drenthe', 1, 'drenthe');

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 
(1077306, 1002613, 'NL', 'Aalden', 1, 'aalden', 52.79000000, 6.71806000),
(1077344, 1002613, 'NL', 'Angelslo', 1, 'angelslo', 52.78090000, 6.92645000),
(1077349, 1002613, 'NL', 'Annen', 1, 'annen', 53.05750000, 6.71944000),
(1077357, 1002613, 'NL', 'Assen', 1, 'assen', 52.99667000, 6.56250000),
(1077376, 1002613, 'NL', 'Ballast', 1, 'ballast', 52.67218000, 6.73299000),
(1077380, 1002613, 'NL', 'Barger-Oosterveld', 1, 'barger-oosterveld', 52.77000000, 6.95833000),
(1077381, 1002613, 'NL', 'Bargeres', 1, 'bargeres', 52.76152000, 6.88145000),
(1077395, 1002613, 'NL', 'Beilen', 1, 'beilen', 52.86333000, 6.51389000),
(1077456, 1002613, 'NL', 'Borger', 1, 'borger', 52.92333000, 6.79306000),
(1077519, 1002613, 'NL', 'Coevorden', 1, 'coevorden', 52.66103000, 6.74046000),
(1077528, 1002613, 'NL', 'Dalen', 1, 'dalen', 52.69917000, 6.75556000),
(1077552, 1002613, 'NL', 'De Loo', 1, 'de-loo', 52.67167000, 6.73967000),
(1077563, 1002613, 'NL', 'De Wijk', 1, 'de-wijk', 52.67333000, 6.29028000),
(1077581, 1002613, 'NL', 'Diever', 1, 'diever', 52.85417000, 6.31806000),
(1077620, 1002613, 'NL', 'Dwingeloo', 1, 'dwingeloo', 52.83417000, 6.36944000),
(1077628, 1002613, 'NL', 'Eelde', 1, 'eelde', 53.13583000, 6.56250000),
(1077634, 1002613, 'NL', 'Eext', 1, 'eext', 53.01750000, 6.73472000),
(1077653, 1002613, 'NL', 'Emmen', 1, 'emmen', 52.77917000, 6.90694000),
(1077654, 1002613, 'NL', 'Emmer-Compascuum', 1, 'emmer-compascuum', 52.81167000, 7.04722000),
(1077655, 1002613, 'NL', 'Emmer-Erfscheidenveen', 1, 'emmer-erfscheidenveen', 52.80667000, 6.98889000),
(1077656, 1002613, 'NL', 'Emmerhout', 1, 'emmerhout', 52.78755000, 6.93881000),
(1077657, 1002613, 'NL', 'Emmermeer', 1, 'emmermeer', 52.80071000, 6.89315000),
(1077658, 1002613, 'NL', 'Emmerschans', 1, 'emmerschans', 52.80083000, 6.93889000),
(1077671, 1002613, 'NL', 'Exloo', 1, 'exloo', 52.88250000, 6.86389000),
(1077684, 1002613, 'NL', 'Gasselte', 1, 'gasselte', 52.97167000, 6.79444000),
(1077685, 1002613, 'NL', 'Gasselternijveen', 1, 'gasselternijveen', 52.98833000, 6.85278000),
(1077696, 1002613, 'NL', 'Gemeente Aa en Hunze', 1, 'gemeente-aa-en-hunze', 53.00445000, 6.74908000),
(1077714, 1002613, 'NL', 'Gemeente Assen', 1, 'gemeente-assen', 52.99635000, 6.55255000),
(1077735, 1002613, 'NL', 'Gemeente Borger-Odoorn', 1, 'gemeente-borger-odoorn', 52.90501000, 6.88042000),
(1077750, 1002613, 'NL', 'Gemeente Coevorden', 1, 'gemeente-coevorden', 52.74344000, 6.72487000),
(1077758, 1002613, 'NL', 'Gemeente De Wolden', 1, 'gemeente-de-wolden', 52.70102000, 6.37277000),
(1077783, 1002613, 'NL', 'Gemeente Emmen', 1, 'gemeente-emmen', 52.75243000, 6.95938000),
(1077831, 1002613, 'NL', 'Gemeente Hoogeveen', 1, 'gemeente-hoogeveen', 52.71820000, 6.51803000),
(1077871, 1002613, 'NL', 'Gemeente Meppel', 1, 'gemeente-meppel', 52.70885000, 6.19727000),
(1077874, 1002613, 'NL', 'Gemeente Midden-Drenthe', 1, 'gemeente-midden-drenthe', 52.86716000, 6.53840000),
(1077887, 1002613, 'NL', 'Gemeente Noordenveld', 1, 'gemeente-noordenveld', 53.11494000, 6.44622000),
(1077958, 1002613, 'NL', 'Gemeente Tynaarlo', 1, 'gemeente-tynaarlo', 53.10417000, 6.60271000),
(1077991, 1002613, 'NL', 'Gemeente Westerveld', 1, 'gemeente-westerveld', 52.82700000, 6.29060000),
(1078031, 1002613, 'NL', 'Gieten', 1, 'gieten', 53.00500000, 6.76389000),
(1078104, 1002613, 'NL', 'Havelte', 1, 'havelte', 52.76941000, 6.24015000),
(1078181, 1002613, 'NL', 'Hoogeveen', 1, 'hoogeveen', 52.72250000, 6.47639000),
(1078235, 1002613, 'NL', 'Klazienaveen', 1, 'klazienaveen', 52.72417000, 6.99028000),
(1078241, 1002613, 'NL', 'Koekange', 1, 'koekange', 52.69917000, 6.31667000),
(1078255, 1002613, 'NL', 'Krakeel', 1, 'krakeel', 52.72339000, 6.51146000),
(1078354, 1002613, 'NL', 'Marsdijk', 1, 'marsdijk', 53.01766000, 6.58527000),
(1078381, 1002613, 'NL', 'Meppel', 1, 'meppel', 52.69583000, 6.19444000),
(1078431, 1002613, 'NL', 'Nieuw-Buinen', 1, 'nieuw-buinen', 52.96250000, 6.95000000),
(1078432, 1002613, 'NL', 'Nieuw-Dordrecht', 1, 'nieuw-dordrecht', 52.74833000, 6.96806000),
(1078436, 1002613, 'NL', 'Nieuw-Roden', 1, 'nieuw-roden', 53.13167000, 6.39722000),
(1078463, 1002613, 'NL', 'Noordbarge', 1, 'noordbarge', 52.77237000, 6.88713000),
(1078473, 1002613, 'NL', 'Norg', 1, 'norg', 53.06667000, 6.45833000),
(1078484, 1002613, 'NL', 'Odoorn', 1, 'odoorn', 52.84917000, 6.85139000),
(1078516, 1002613, 'NL', 'Oosterhesselen', 1, 'oosterhesselen', 52.75417000, 6.72222000),
(1078581, 1002613, 'NL', 'Paterswolde', 1, 'paterswolde', 53.14500000, 6.56528000),
(1078583, 1002613, 'NL', 'Peelo', 1, 'peelo', 53.01719000, 6.56208000),
(1078585, 1002613, 'NL', 'Peize', 1, 'peize', 53.14667000, 6.49722000),
(1078633, 1002613, 'NL', 'Roden', 1, 'roden', 53.13750000, 6.42083000),
(1078636, 1002613, 'NL', 'Rolde', 1, 'rolde', 52.98417000, 6.64861000),
(1078648, 1002613, 'NL', 'Ruinen', 1, 'ruinen', 52.76250000, 6.35417000),
(1078649, 1002613, 'NL', 'Ruinerwold', 1, 'ruinerwold', 52.72333000, 6.24861000),
(1078679, 1002613, 'NL', 'Schoonebeek', 1, 'schoonebeek', 52.66250000, 6.88472000),
(1078681, 1002613, 'NL', 'Schoonoord', 1, 'schoonoord', 52.84583000, 6.75556000),
(1078709, 1002613, 'NL', 'Sleen', 1, 'sleen', 52.77167000, 6.80278000),
(1078796, 1002613, 'NL', 'Tweede Exloërmond', 1, 'tweede-exloermond', 52.90917000, 6.93333000),
(1078802, 1002613, 'NL', 'Tynaarlo', 1, 'tynaarlo', 53.07750000, 6.61667000),
(1078809, 1002613, 'NL', 'Uffelte', 1, 'uffelte', 52.79000000, 6.28056000),
(1078832, 1002613, 'NL', 'Valthe', 1, 'valthe', 52.84583000, 6.89444000),
(1078833, 1002613, 'NL', 'Valthermond', 1, 'valthermond', 52.88167000, 6.96250000),
(1078838, 1002613, 'NL', 'Veenoord', 1, 'veenoord', 52.71087000, 6.84869000),
(1078857, 1002613, 'NL', 'Vledder', 1, 'vledder', 52.85583000, 6.20833000),
(1078885, 1002613, 'NL', 'Vries', 1, 'vries', 53.07417000, 6.57778000),
(1078917, 1002613, 'NL', 'Weiteveen', 1, 'weiteveen', 52.67250000, 6.98750000),
(1078935, 1002613, 'NL', 'Westerbork', 1, 'westerbork', 52.85000000, 6.60833000),
(1078943, 1002613, 'NL', 'Westlaren', 1, 'westlaren', 53.08480000, 6.66469000),
(1078976, 1002613, 'NL', 'Wolfsbos', 1, 'wolfsbos', 52.71734000, 6.49881000),
(1079028, 1002613, 'NL', 'Zuidlaren', 1, 'zuidlaren', 53.09417000, 6.68194000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002619, 'NL', 'Flevoland', 1, 'flevoland');

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 
(1077327, 1002619, 'NL', 'Almere Stad', 1, 'almere-stad', 52.37025000, 5.21413000),
(1077427, 1002619, 'NL', 'Biddinghuizen', 1, 'biddinghuizen', 52.45500000, 5.69306000),
(1077612, 1002619, 'NL', 'Dronten', 1, 'dronten', 52.52500000, 5.71806000),
(1077652, 1002619, 'NL', 'Emmeloord', 1, 'emmeloord', 52.71083000, 5.74861000),
(1077661, 1002619, 'NL', 'Ens', 1, 'ens', 52.63667000, 5.82778000),
(1077704, 1002619, 'NL', 'Gemeente Almere', 1, 'gemeente-almere', 52.36861000, 5.23750000),
(1077773, 1002619, 'NL', 'Gemeente Dronten', 1, 'gemeente-dronten', 52.50000000, 5.71667000),
(1077855, 1002619, 'NL', 'Gemeente Lelystad', 1, 'gemeente-lelystad', 52.47542000, 5.43811000),
(1077888, 1002619, 'NL', 'Gemeente Noordoostpolder', 1, 'gemeente-noordoostpolder', 52.71703000, 5.77248000),
(1077963, 1002619, 'NL', 'Gemeente Urk', 1, 'gemeente-urk', 52.66585000, 5.62371000),
(1078008, 1002619, 'NL', 'Gemeente Zeewolde', 1, 'gemeente-zeewolde', 52.34420000, 5.45904000),
(1078288, 1002619, 'NL', 'Lelystad', 1, 'lelystad', 52.50833000, 5.47500000),
(1078819, 1002619, 'NL', 'Urk', 1, 'urk', 52.66250000, 5.60139000),
(1079002, 1002619, 'NL', 'Zeewolde', 1, 'zeewolde', 52.33000000, 5.54167000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002622, 'NL', 'Friesland', 1, 'friesland');

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 
(1077321, 1002622, 'NL', 'Akkrum', 1, 'akkrum', 53.05024000, 5.83087000),
(1077323, 1002622, 'NL', 'Aldeboarn', 1, 'aldeboarn', 53.05000000, 5.90000000),
(1077324, 1002622, 'NL', 'Aldlân-Oost', 1, 'aldlan-oost', 53.18860000, 5.82825000),
(1077351, 1002622, 'NL', 'Appelscha', 1, 'appelscha', 52.95526000, 6.35053000),
(1077359, 1002622, 'NL', 'Augustinusga', 1, 'augustinusga', 53.21785000, 6.16170000),
(1077373, 1002622, 'NL', 'Bakhuizen', 1, 'bakhuizen', 52.86975000, 5.45926000),
(1077374, 1002622, 'NL', 'Bakkeveen', 1, 'bakkeveen', 53.08072000, 6.25671000),
(1077375, 1002622, 'NL', 'Balk', 1, 'balk', 52.89756000, 5.57964000),
(1077394, 1002622, 'NL', 'Beetsterzwaag', 1, 'beetsterzwaag', 53.05914000, 6.07711000),
(1077420, 1002622, 'NL', 'Berltsum', 1, 'berltsum', 53.24370000, 5.65101000),
(1077431, 1002622, 'NL', 'Bilgaard', 1, 'bilgaard', 53.21551000, 5.79574000),
(1077452, 1002622, 'NL', 'Bolsward', 1, 'bolsward', 53.06555000, 5.53176000),
(1077453, 1002622, 'NL', 'Boornbergum', 1, 'boornbergum', 53.08284000, 6.04578000),
(1077487, 1002622, 'NL', 'Broeksterwâld', 1, 'broeksterwald', 53.27466000, 5.99648000),
(1077501, 1002622, 'NL', 'Buitenpost', 1, 'buitenpost', 53.25166000, 6.14483000),
(1077505, 1002622, 'NL', 'Burdaard', 1, 'burdaard', 53.29421000, 5.87897000),
(1077507, 1002622, 'NL', 'Burgum', 1, 'burgum', 53.19243000, 5.99009000),
(1077510, 1002622, 'NL', 'Camminghaburen', 1, 'camminghaburen', 53.20973000, 5.84318000),
(1077530, 1002622, 'NL', 'Damwâld', 1, 'damwald', 53.29046000, 5.99785000),
(1077535, 1002622, 'NL', 'De Domp', 1, 'de-domp', 53.03113000, 5.67716000),
(1077537, 1002622, 'NL', 'De Drait', 1, 'de-drait', 53.09743000, 6.06791000),
(1077538, 1002622, 'NL', 'De Fryske Marren', 1, 'de-fryske-marren', 52.96906000, 5.77246000),
(1077541, 1002622, 'NL', 'De Greiden', 1, 'de-greiden', 52.94960000, 5.91366000),
(1077548, 1002622, 'NL', 'De Knipe', 1, 'de-knipe', 52.96829000, 5.97116000),
(1077561, 1002622, 'NL', 'De Westereen', 1, 'de-westereen', 53.25731000, 6.03630000),
(1077588, 1002622, 'NL', 'Dokkum', 1, 'dokkum', 53.32224000, 5.99697000),
(1077593, 1002622, 'NL', 'Donkerbroek', 1, 'donkerbroek', 53.01734000, 6.23927000),
(1077602, 1002622, 'NL', 'Drachten', 1, 'drachten', 53.11254000, 6.09890000),
(1077603, 1002622, 'NL', 'Drachtstercompagnie', 1, 'drachtstercompagnie', 53.13462000, 6.14153000),
(1077610, 1002622, 'NL', 'Drogeham', 1, 'drogeham', 53.20213000, 6.11183000),
(1077611, 1002622, 'NL', 'Dronryp', 1, 'dronryp', 53.20000000, 5.65000000),
(1077621, 1002622, 'NL', 'Eastermar', 1, 'eastermar', 53.17466000, 6.05999000),
(1077622, 1002622, 'NL', 'Echtenerbrug', 1, 'echtenerbrug', 52.87141000, 5.82147000),
(1077673, 1002622, 'NL', 'Feanwâlden', 1, 'feanwalden', 53.23558000, 5.98832000),
(1077675, 1002622, 'NL', 'Ferwert', 1, 'ferwert', 53.33784000, 5.82533000),
(1077678, 1002622, 'NL', 'Franeker', 1, 'franeker', 53.18546000, 5.54123000),
(1077683, 1002622, 'NL', 'Garyp', 1, 'garyp', 53.16667000, 5.96667000),
(1077699, 1002622, 'NL', 'Gemeente Achtkarspelen', 1, 'gemeente-achtkarspelen', 53.21167000, 6.13776000),
(1077707, 1002622, 'NL', 'Gemeente Ameland', 1, 'gemeente-ameland', 53.45024000, 5.78277000),
(1077755, 1002622, 'NL', 'Gemeente Dantumadiel', 1, 'gemeente-dantumadiel', 53.29113000, 5.99545000),
(1077809, 1002622, 'NL', 'Gemeente Harlingen', 1, 'gemeente-harlingen', 53.17525000, 5.41806000),
(1077814, 1002622, 'NL', 'Gemeente Heerenveen', 1, 'gemeente-heerenveen', 52.94220000, 6.04410000),
(1077851, 1002622, 'NL', 'Gemeente Leeuwarden', 1, 'gemeente-leeuwarden', 53.18602000, 5.81111000),
(1077900, 1002622, 'NL', 'Gemeente Ooststellingwerf', 1, 'gemeente-ooststellingwerf', 52.98264000, 6.27515000),
(1077903, 1002622, 'NL', 'Gemeente Opsterland', 1, 'gemeente-opsterland', 53.04849000, 6.12128000),
(1077932, 1002622, 'NL', 'Gemeente Schiermonnikoog', 1, 'gemeente-schiermonnikoog', 53.48707000, 6.22917000),
(1077939, 1002622, 'NL', 'Gemeente Smallingerland', 1, 'gemeente-smallingerland', 53.11667000, 6.03333000),
(1077950, 1002622, 'NL', 'Gemeente Terschelling', 1, 'gemeente-terschelling', 53.40000000, 5.35000000),
(1077959, 1002622, 'NL', 'Gemeente Tytsjerksteradiel', 1, 'gemeente-tytsjerksteradiel', 53.19966000, 5.95802000),
(1077976, 1002622, 'NL', 'Gemeente Vlieland', 1, 'gemeente-vlieland', 53.25320000, 4.95071000),
(1077994, 1002622, 'NL', 'Gemeente Weststellingwerf', 1, 'gemeente-weststellingwerf', 52.87647000, 6.01998000),
(1078042, 1002622, 'NL', 'Gorredijk', 1, 'gorredijk', 53.00659000, 6.06402000),
(1078047, 1002622, 'NL', 'Goutum', 1, 'goutum', 53.17734000, 5.80370000),
(1078068, 1002622, 'NL', 'Grou', 1, 'grou', 53.09456000, 5.83745000),
(1078073, 1002622, 'NL', 'Gytsjerk', 1, 'gytsjerk', 53.24293000, 5.89502000),
(1078086, 1002622, 'NL', 'Hallum', 1, 'hallum', 53.30657000, 5.78379000),
(1078095, 1002622, 'NL', 'Harkema', 1, 'harkema', 53.18333000, 6.13333000),
(1078097, 1002622, 'NL', 'Harlingen', 1, 'harlingen', 53.17477000, 5.42244000),
(1078103, 1002622, 'NL', 'Haulerwijk', 1, 'haulerwijk', 53.06468000, 6.33453000),
(1078106, 1002622, 'NL', 'Heechterp', 1, 'heechterp', 53.20963000, 5.82250000),
(1078107, 1002622, 'NL', 'Heeg', 1, 'heeg', 52.96860000, 5.61075000),
(1078114, 1002622, 'NL', 'Heerenveen', 1, 'heerenveen', 52.95929000, 5.91854000),
(1078162, 1002622, 'NL', 'Hoek', 1, 'hoek', 53.20455000, 5.80192000),
(1078170, 1002622, 'NL', 'Hollum', 1, 'hollum', 53.43940000, 5.63805000),
(1078172, 1002622, 'NL', 'Holwerd', 1, 'holwerd', 53.36815000, 5.90073000),
(1078193, 1002622, 'NL', 'Huizum', 1, 'huizum', 53.19170000, 5.81119000),
(1078198, 1002622, 'NL', 'Hurdegaryp', 1, 'hurdegaryp', 53.21333000, 5.94137000),
(1078200, 1002622, 'NL', 'IJlst', 1, 'ijlst', 53.01009000, 5.62312000),
(1078206, 1002622, 'NL', 'Jirnsum', 1, 'jirnsum', 53.07753000, 5.79254000),
(1078207, 1002622, 'NL', 'Joure', 1, 'joure', 52.96570000, 5.80301000),
(1078208, 1002622, 'NL', 'Jubbega', 1, 'jubbega', 53.00396000, 6.12183000),
(1078243, 1002622, 'NL', 'Kollum', 1, 'kollum', 53.27695000, 6.15293000),
(1078244, 1002622, 'NL', 'Kollumerzwaag', 1, 'kollumerzwaag', 53.26224000, 6.07544000),
(1078247, 1002622, 'NL', 'Kootstertille', 1, 'kootstertille', 53.21261000, 6.09209000),
(1078254, 1002622, 'NL', 'Koudum', 1, 'koudum', 52.91551000, 5.44834000),
(1078272, 1002622, 'NL', 'Langweer', 1, 'langweer', 52.95836000, 5.72173000),
(1078283, 1002622, 'NL', 'Leeuwarden', 1, 'leeuwarden', 53.20139000, 5.80859000),
(1078289, 1002622, 'NL', 'Lemmer', 1, 'lemmer', 52.84618000, 5.70912000),
(1078343, 1002622, 'NL', 'Makkum', 1, 'makkum', 53.05458000, 5.40231000),
(1078347, 1002622, 'NL', 'Mantgum', 1, 'mantgum', 53.12865000, 5.71924000),
(1078353, 1002622, 'NL', 'Marrum', 1, 'marrum', 53.32277000, 5.80198000),
(1078355, 1002622, 'NL', 'Marsum', 1, 'marsum', 53.21050000, 5.72637000),
(1078380, 1002622, 'NL', 'Menaam', 1, 'menaam', 53.21797000, 5.66124000),
(1078403, 1002622, 'NL', 'Minnertsga', 1, 'minnertsga', 53.25104000, 5.59513000),
(1078427, 1002622, 'NL', 'Nes', 1, 'nes', 53.44502000, 5.77400000),
(1078442, 1002622, 'NL', 'Nieuwehorne', 1, 'nieuwehorne', 52.95113000, 6.06342000),
(1078460, 1002622, 'NL', 'Noardburgum', 1, 'noardburgum', 53.22135000, 6.00523000),
(1078472, 1002622, 'NL', 'Noordwolde', 1, 'noordwolde', 52.88964000, 6.14153000),
(1078486, 1002622, 'NL', 'Oentsjerk', 1, 'oentsjerk', 53.25000000, 5.90000000),
(1078493, 1002622, 'NL', 'Oldeberkoop', 1, 'oldeberkoop', 52.93788000, 6.13089000),
(1078507, 1002622, 'NL', 'Oost-Vlieland', 1, 'oost-vlieland', 53.29703000, 5.07431000),
(1078524, 1002622, 'NL', 'Oosterwolde', 1, 'oosterwolde', 52.99164000, 6.29096000),
(1078533, 1002622, 'NL', 'Opeinde', 1, 'opeinde', 53.13410000, 6.05656000),
(1078539, 1002622, 'NL', 'Oppenhuizen', 1, 'oppenhuizen', 53.01194000, 5.69495000),
(1078542, 1002622, 'NL', 'Oranjewoud', 1, 'oranjewoud', 52.94579000, 5.95038000),
(1078560, 1002622, 'NL', 'Oudega', 1, 'oudega', 53.12504000, 5.99888000),
(1078561, 1002622, 'NL', 'Oudehaske', 1, 'oudehaske', 52.95709000, 5.87095000),
(1078562, 1002622, 'NL', 'Oudemirdum', 1, 'oudemirdum', 52.85019000, 5.53544000),
(1078566, 1002622, 'NL', 'Oudeschoot', 1, 'oudeschoot', 52.93343000, 5.95579000),
(1078643, 1002622, 'NL', 'Rottevalle', 1, 'rottevalle', 53.14523000, 6.10411000),
(1078661, 1002622, 'NL', 'Scharnegoutum', 1, 'scharnegoutum', 53.06051000, 5.67822000),
(1078670, 1002622, 'NL', 'Schiermonnikoog', 1, 'schiermonnikoog', 53.48025000, 6.15209000),
(1078689, 1002622, 'NL', 'Sexbierum', 1, 'sexbierum', 53.21823000, 5.48402000),
(1078694, 1002622, 'NL', 'Sint Annaparochie', 1, 'sint-annaparochie', 53.27620000, 5.65727000),
(1078696, 1002622, 'NL', 'Sint Jacobiparochie', 1, 'sint-jacobiparochie', 53.27291000, 5.60354000),
(1078700, 1002622, 'NL', 'Sint Nicolaasga', 1, 'sint-nicolaasga', 52.92293000, 5.74242000),
(1078707, 1002622, 'NL', 'Sintjohannesga', 1, 'sintjohannesga', 52.93157000, 5.85588000),
(1078717, 1002622, 'NL', 'Sneek', 1, 'sneek', 53.03297000, 5.65890000),
(1078741, 1002622, 'NL', 'Stadsfenne', 1, 'stadsfenne', 53.03987000, 5.67844000),
(1078759, 1002622, 'NL', 'Stiens', 1, 'stiens', 53.26234000, 5.75769000),
(1078766, 1002622, 'NL', 'Sûdwest Fryslân', 1, 'sudwest-fryslan', 53.01056000, 5.52580000),
(1078765, 1002622, 'NL', 'Surhuisterveen', 1, 'surhuisterveen', 53.18477000, 6.17031000),
(1078773, 1002622, 'NL', 'Ternaard', 1, 'ternaard', 53.38203000, 5.96523000),
(1078785, 1002622, 'NL', 'Tijnje', 1, 'tijnje', 53.03058000, 5.99193000),
(1078787, 1002622, 'NL', 'Tinga', 1, 'tinga', 53.02064000, 5.64575000),
(1078799, 1002622, 'NL', 'Twijzel', 1, 'twijzel', 53.23152000, 6.08952000),
(1078800, 1002622, 'NL', 'Twijzelerheide', 1, 'twijzelerheide', 53.24015000, 6.04591000),
(1078803, 1002622, 'NL', 'Tytsjerk', 1, 'tytsjerk', 53.21343000, 5.90961000),
(1078804, 1002622, 'NL', 'Tzummarum', 1, 'tzummarum', 53.23733000, 5.54612000),
(1078818, 1002622, 'NL', 'Ureterp', 1, 'ureterp', 53.09244000, 6.16718000),
(1078890, 1002622, 'NL', 'Waadhoeke', 1, 'waadhoeke', 53.18947000, 5.50793000),
(1078905, 1002622, 'NL', 'Warga', 1, 'warga', 53.15145000, 5.84404000),
(1078930, 1002622, 'NL', 'West-Terschelling', 1, 'west-terschelling', 53.35911000, 5.21482000),
(1078932, 1002622, 'NL', 'Westeinde', 1, 'westeinde', 53.20853000, 5.76812000),
(1078957, 1002622, 'NL', 'Wijnjewoude', 1, 'wijnjewoude', 53.05814000, 6.20470000),
(1078966, 1002622, 'NL', 'Wirdum', 1, 'wirdum', 53.14893000, 5.80387000),
(1078970, 1002622, 'NL', 'Witmarsum', 1, 'witmarsum', 53.10452000, 5.46902000),
(1078978, 1002622, 'NL', 'Wolvega', 1, 'wolvega', 52.87545000, 5.99691000),
(1078979, 1002622, 'NL', 'Wommels', 1, 'wommels', 53.10883000, 5.58749000),
(1078982, 1002622, 'NL', 'Workum', 1, 'workum', 52.97969000, 5.44710000),
(1078987, 1002622, 'NL', 'Woudsend', 1, 'woudsend', 52.94357000, 5.62843000),
(1079026, 1002622, 'NL', 'Zuiderburen', 1, 'zuiderburen', 53.17340000, 5.84271000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002611, 'NL', 'Gelderland', 1, 'gelderland');

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 
(1077300, 1002611, 'NL', '\'s-Heerenberg', 1, 's-heerenberg', 51.87670000, 6.25877000),
(1077309, 1002611, 'NL', 'Aalst', 1, 'aalst', 51.78250000, 5.12778000),
(1077310, 1002611, 'NL', 'Aalten', 1, 'aalten', 51.92500000, 6.58056000),
(1077319, 1002611, 'NL', 'Afferden', 1, 'afferden', 51.88000000, 5.63472000),
(1077331, 1002611, 'NL', 'Alverna', 1, 'alverna', 51.80417000, 5.75972000),
(1077337, 1002611, 'NL', 'Ammerzoden', 1, 'ammerzoden', 51.74917000, 5.22083000),
(1077343, 1002611, 'NL', 'Andelst', 1, 'andelst', 51.90833000, 5.72917000),
(1077345, 1002611, 'NL', 'Angeren', 1, 'angeren', 51.91583000, 5.95833000),
(1077346, 1002611, 'NL', 'Angerlo', 1, 'angerlo', 51.99583000, 6.13472000),
(1077348, 1002611, 'NL', 'Anklaar', 1, 'anklaar', 52.23111000, 5.98497000),
(1077350, 1002611, 'NL', 'Apeldoorn', 1, 'apeldoorn', 52.21000000, 5.96944000),
(1077356, 1002611, 'NL', 'Arnhem', 1, 'arnhem', 51.98000000, 5.91111000),
(1077369, 1002611, 'NL', 'Babberich', 1, 'babberich', 51.90750000, 6.11111000),
(1077372, 1002611, 'NL', 'Bakenberg', 1, 'bakenberg', 52.00511000, 5.87710000),
(1077382, 1002611, 'NL', 'Barneveld', 1, 'barneveld', 52.14000000, 5.58472000),
(1077388, 1002611, 'NL', 'Beek gem Montferland', 1, 'beek-gem-montferland', 51.90667000, 6.18750000),
(1077389, 1002611, 'NL', 'Beekbergen', 1, 'beekbergen', 52.16000000, 5.96389000),
(1077392, 1002611, 'NL', 'Beesd', 1, 'beesd', 51.88750000, 5.19167000),
(1077399, 1002611, 'NL', 'Beltrum', 1, 'beltrum', 52.06667000, 6.56389000),
(1077400, 1002611, 'NL', 'Bemmel', 1, 'bemmel', 51.89167000, 5.89861000),
(1077402, 1002611, 'NL', 'Bennekom', 1, 'bennekom', 51.99833000, 5.67639000),
(1077405, 1002611, 'NL', 'Berg en Bos', 1, 'berg-en-bos', 52.22009000, 5.93340000),
(1077406, 1002611, 'NL', 'Berg en Dal', 1, 'berg-en-dal', 51.82167000, 5.91667000),
(1077409, 1002611, 'NL', 'Bergharen', 1, 'bergharen', 51.85083000, 5.66944000),
(1077415, 1002611, 'NL', 'Berkelland', 1, 'berkelland', 52.10606000, 6.56748000),
(1077424, 1002611, 'NL', 'Beuningen', 1, 'beuningen', 51.86083000, 5.76667000),
(1077425, 1002611, 'NL', 'Beusichem', 1, 'beusichem', 51.95000000, 5.29167000),
(1077433, 1002611, 'NL', 'Binnenstad', 1, 'binnenstad', 52.21304000, 5.95957000),
(1077454, 1002611, 'NL', 'Borculo', 1, 'borculo', 52.11583000, 6.52222000),
(1077470, 1002611, 'NL', 'Brakel', 1, 'brakel', 51.81750000, 5.09028000),
(1077471, 1002611, 'NL', 'Brakkenstein', 1, 'brakkenstein', 51.81324000, 5.86539000),
(1077474, 1002611, 'NL', 'Bredevoort', 1, 'bredevoort', 51.94167000, 6.62083000),
(1077475, 1002611, 'NL', 'Bredeweg', 1, 'bredeweg', 51.76019000, 5.94189000),
(1077481, 1002611, 'NL', 'Brinkhorst', 1, 'brinkhorst', 52.21302000, 5.95167000),
(1077489, 1002611, 'NL', 'Bruchem', 1, 'bruchem', 51.78667000, 5.23611000),
(1077492, 1002611, 'NL', 'Brummelhof', 1, 'brummelhof', 52.20503000, 5.96789000),
(1077493, 1002611, 'NL', 'Brummen', 1, 'brummen', 52.09000000, 6.15556000),
(1077506, 1002611, 'NL', 'Burgemeesterswijk', 1, 'burgemeesterswijk', 51.98943000, 5.89597000),
(1077522, 1002611, 'NL', 'Componistenkwartier', 1, 'componistenkwartier', 52.18977000, 5.96609000),
(1077523, 1002611, 'NL', 'Corlaer', 1, 'corlaer', 52.21639000, 5.46535000),
(1077527, 1002611, 'NL', 'Culemborg', 1, 'culemborg', 51.95500000, 5.22778000),
(1077534, 1002611, 'NL', 'De Bouwhof', 1, 'de-bouwhof', 52.18546000, 5.94704000),
(1077543, 1002611, 'NL', 'De Haven', 1, 'de-haven', 52.21045000, 5.97407000),
(1077545, 1002611, 'NL', 'De Heeze', 1, 'de-heeze', 52.20061000, 5.95365000),
(1077554, 1002611, 'NL', 'De Mheen', 1, 'de-mheen', 52.21954000, 5.99141000),
(1077564, 1002611, 'NL', 'Deest', 1, 'deest', 51.89000000, 5.66667000),
(1077565, 1002611, 'NL', 'Deil', 1, 'deil', 51.88417000, 5.24306000),
(1077579, 1002611, 'NL', 'Dieren', 1, 'dieren', 52.05250000, 6.10000000),
(1077586, 1002611, 'NL', 'Doesburg', 1, 'doesburg', 52.01250000, 6.13889000),
(1077587, 1002611, 'NL', 'Doetinchem', 1, 'doetinchem', 51.96500000, 6.28889000),
(1077596, 1002611, 'NL', 'Doornenburg', 1, 'doornenburg', 51.89000000, 6.00000000),
(1077597, 1002611, 'NL', 'Doornspijk', 1, 'doornspijk', 52.41833000, 5.81806000),
(1077598, 1002611, 'NL', 'Doornsteeg', 1, 'doornsteeg', 52.23000000, 5.45417000),
(1077599, 1002611, 'NL', 'Doorwerth', 1, 'doorwerth', 51.97917000, 5.79722000),
(1077606, 1002611, 'NL', 'Driehuizen', 1, 'driehuizen', 52.20879000, 5.94442000),
(1077607, 1002611, 'NL', 'Driel', 1, 'driel', 51.95917000, 5.81389000),
(1077613, 1002611, 'NL', 'Drumpt', 1, 'drumpt', 51.89700000, 5.41043000),
(1077614, 1002611, 'NL', 'Druten', 1, 'druten', 51.88833000, 5.60556000),
(1077617, 1002611, 'NL', 'Duiven', 1, 'duiven', 51.94667000, 6.01389000),
(1077625, 1002611, 'NL', 'Ede', 1, 'ede', 52.03333000, 5.65833000),
(1077626, 1002611, 'NL', 'Ederveen', 1, 'ederveen', 52.06333000, 5.57778000),
(1077627, 1002611, 'NL', 'Eefde', 1, 'eefde', 52.16667000, 6.22500000),
(1077630, 1002611, 'NL', 'Eerbeek', 1, 'eerbeek', 52.10500000, 6.05833000),
(1077639, 1002611, 'NL', 'Eibergen', 1, 'eibergen', 52.10000000, 6.64861000),
(1077645, 1002611, 'NL', 'Elburg', 1, 'elburg', 52.44750000, 5.84306000),
(1077646, 1002611, 'NL', 'Elden', 1, 'elden', 51.95833000, 5.88194000),
(1077647, 1002611, 'NL', 'Ellecom', 1, 'ellecom', 52.03250000, 6.08750000),
(1077650, 1002611, 'NL', 'Elspeet', 1, 'elspeet', 52.29167000, 5.78889000),
(1077651, 1002611, 'NL', 'Elst', 1, 'elst', 51.91917000, 5.84167000),
(1077659, 1002611, 'NL', 'Emst', 1, 'emst', 52.31583000, 5.97361000),
(1077664, 1002611, 'NL', 'Epe', 1, 'epe', 52.34750000, 5.98333000),
(1077665, 1002611, 'NL', 'Epse', 1, 'epse', 52.22500000, 6.20000000),
(1077666, 1002611, 'NL', 'Ermelo', 1, 'ermelo', 52.29833000, 5.62222000),
(1077670, 1002611, 'NL', 'Etten', 1, 'etten', 51.91667000, 6.33611000),
(1077681, 1002611, 'NL', 'Gameren', 1, 'gameren', 51.80083000, 5.20417000),
(1077682, 1002611, 'NL', 'Garderen', 1, 'garderen', 52.23083000, 5.71389000),
(1077689, 1002611, 'NL', 'Geitenkamp', 1, 'geitenkamp', 52.00379000, 5.93862000),
(1077690, 1002611, 'NL', 'Geldermalsen', 1, 'geldermalsen', 51.88083000, 5.28889000),
(1077691, 1002611, 'NL', 'Geldermalsen-West', 1, 'geldermalsen-west', 51.87968000, 5.28015000),
(1077698, 1002611, 'NL', 'Gemeente Aalten', 1, 'gemeente-aalten', 51.92420000, 6.56574000),
(1077711, 1002611, 'NL', 'Gemeente Apeldoorn', 1, 'gemeente-apeldoorn', 52.18722000, 5.91969000),
(1077713, 1002611, 'NL', 'Gemeente Arnhem', 1, 'gemeente-arnhem', 52.00113000, 5.89641000),
(1077719, 1002611, 'NL', 'Gemeente Barneveld', 1, 'gemeente-barneveld', 52.16880000, 5.63985000),
(1077723, 1002611, 'NL', 'Gemeente Berg en Dal', 1, 'gemeente-berg-en-dal', 51.78412000, 5.92968000),
(1077729, 1002611, 'NL', 'Gemeente Beuningen', 1, 'gemeente-beuningen', 51.85950000, 5.74362000),
(1077742, 1002611, 'NL', 'Gemeente Bronckhorst', 1, 'gemeente-bronckhorst', 52.04401000, 6.30378000),
(1077743, 1002611, 'NL', 'Gemeente Brummen', 1, 'gemeente-brummen', 52.11063000, 6.11791000),
(1077747, 1002611, 'NL', 'Gemeente Buren', 1, 'gemeente-buren', 51.90901000, 5.33403000),
(1077753, 1002611, 'NL', 'Gemeente Culemborg', 1, 'gemeente-culemborg', 51.94465000, 5.20946000),
(1077767, 1002611, 'NL', 'Gemeente Doesburg', 1, 'gemeente-doesburg', 52.01935000, 6.14855000),
(1077768, 1002611, 'NL', 'Gemeente Doetinchem', 1, 'gemeente-doetinchem', 51.96216000, 6.27955000),
(1077774, 1002611, 'NL', 'Gemeente Druten', 1, 'gemeente-druten', 51.87184000, 5.61322000),
(1077775, 1002611, 'NL', 'Gemeente Duiven', 1, 'gemeente-duiven', 51.94740000, 6.01720000),
(1077778, 1002611, 'NL', 'Gemeente Ede', 1, 'gemeente-ede', 52.08118000, 5.74490000),
(1077782, 1002611, 'NL', 'Gemeente Elburg', 1, 'gemeente-elburg', 52.41487000, 5.84868000),
(1077786, 1002611, 'NL', 'Gemeente Epe', 1, 'gemeente-epe', 52.33394000, 5.96175000),
(1077787, 1002611, 'NL', 'Gemeente Ermelo', 1, 'gemeente-ermelo', 52.28826000, 5.65538000),
(1077807, 1002611, 'NL', 'Gemeente Harderwijk', 1, 'gemeente-harderwijk', 52.34540000, 5.63948000),
(1077810, 1002611, 'NL', 'Gemeente Hattem', 1, 'gemeente-hattem', 52.47566000, 6.05195000),
(1077813, 1002611, 'NL', 'Gemeente Heerde', 1, 'gemeente-heerde', 52.38833000, 6.03889000),
(1077824, 1002611, 'NL', 'Gemeente Heumen', 1, 'gemeente-heumen', 51.77438000, 5.81312000),
(1077858, 1002611, 'NL', 'Gemeente Lingewaard', 1, 'gemeente-lingewaard', 51.89558000, 5.94577000),
(1077860, 1002611, 'NL', 'Gemeente Lochem', 1, 'gemeente-lochem', 52.18478000, 6.33700000),
(1077865, 1002611, 'NL', 'Gemeente Maasdriel', 1, 'gemeente-maasdriel', 51.77337000, 5.29711000),
(1077877, 1002611, 'NL', 'Gemeente Montferland', 1, 'gemeente-montferland', 51.91925000, 6.21333000),
(1077880, 1002611, 'NL', 'Gemeente Neder-Betuwe', 1, 'gemeente-neder-betuwe', 51.91442000, 5.57147000),
(1077884, 1002611, 'NL', 'Gemeente Nijkerk', 1, 'gemeente-nijkerk', 52.21700000, 5.48300000),
(1077885, 1002611, 'NL', 'Gemeente Nijmegen', 1, 'gemeente-nijmegen', 51.84168000, 5.83813000),
(1077891, 1002611, 'NL', 'Gemeente Nunspeet', 1, 'gemeente-nunspeet', 52.33524000, 5.78771000),
(1077895, 1002611, 'NL', 'Gemeente Oldebroek', 1, 'gemeente-oldebroek', 52.44502000, 5.90086000),
(1077907, 1002611, 'NL', 'Gemeente Overbetuwe', 1, 'gemeente-overbetuwe', 51.91843000, 5.78686000),
(1077913, 1002611, 'NL', 'Gemeente Putten', 1, 'gemeente-putten', 52.24438000, 5.57827000),
(1077916, 1002611, 'NL', 'Gemeente Renkum', 1, 'gemeente-renkum', 51.99036000, 5.78723000),
(1077919, 1002611, 'NL', 'Gemeente Rheden', 1, 'gemeente-rheden', 52.03386000, 6.04547000),
(1077927, 1002611, 'NL', 'Gemeente Rozendaal', 1, 'gemeente-rozendaal', 52.03913000, 5.97268000),
(1077930, 1002611, 'NL', 'Gemeente Scherpenzeel', 1, 'gemeente-scherpenzeel', 52.08773000, 5.48698000),
(1077954, 1002611, 'NL', 'Gemeente Tiel', 1, 'gemeente-tiel', 51.88463000, 5.40429000),
(1077980, 1002611, 'NL', 'Gemeente Voorst', 1, 'gemeente-voorst', 52.22965000, 6.09992000),
(1077985, 1002611, 'NL', 'Gemeente Wageningen', 1, 'gemeente-wageningen', 51.96876000, 5.66675000),
(1077990, 1002611, 'NL', 'Gemeente West Maas en Waal', 1, 'gemeente-west-maas-en-waal', 51.84494000, 5.51074000),
(1077992, 1002611, 'NL', 'Gemeente Westervoort', 1, 'gemeente-westervoort', 51.95949000, 5.97435000),
(1077997, 1002611, 'NL', 'Gemeente Wijchen', 1, 'gemeente-wijchen', 51.81884000, 5.69862000),
(1078000, 1002611, 'NL', 'Gemeente Winterswijk', 1, 'gemeente-winterswijk', 51.97226000, 6.72544000),
(1078006, 1002611, 'NL', 'Gemeente Zaltbommel', 1, 'gemeente-zaltbommel', 51.78680000, 5.15254000),
(1078010, 1002611, 'NL', 'Gemeente Zevenaar', 1, 'gemeente-zevenaar', 51.95376000, 6.07727000),
(1078015, 1002611, 'NL', 'Gemeente Zutphen', 1, 'gemeente-zutphen', 52.13145000, 6.23132000),
(1078022, 1002611, 'NL', 'Gendringen', 1, 'gendringen', 51.87333000, 6.37639000),
(1078023, 1002611, 'NL', 'Gendt', 1, 'gendt', 51.87750000, 5.97083000),
(1078027, 1002611, 'NL', 'Giesbeek', 1, 'giesbeek', 51.99333000, 6.06667000),
(1078043, 1002611, 'NL', 'Gorssel', 1, 'gorssel', 52.20167000, 6.20139000),
(1078061, 1002611, 'NL', 'Groesbeek', 1, 'groesbeek', 51.77667000, 5.93611000),
(1078062, 1002611, 'NL', 'Groessen', 1, 'groessen', 51.93167000, 6.02639000),
(1078069, 1002611, 'NL', 'Gulden Bodem', 1, 'gulden-bodem', 51.99428000, 5.89080000),
(1078074, 1002611, 'NL', 'Haaften', 1, 'haaften', 51.81583000, 5.21111000),
(1078076, 1002611, 'NL', 'Haalderen', 1, 'haalderen', 51.88750000, 5.92917000),
(1078092, 1002611, 'NL', 'Harderwijk', 1, 'harderwijk', 52.34167000, 5.62083000),
(1078098, 1002611, 'NL', 'Harskamp', 1, 'harskamp', 52.13000000, 5.75278000),
(1078100, 1002611, 'NL', 'Hatert', 1, 'hatert', 51.80635000, 5.83057000),
(1078101, 1002611, 'NL', 'Hattem', 1, 'hattem', 52.47500000, 6.06389000),
(1078102, 1002611, 'NL', 'Hattemerbroek', 1, 'hattemerbroek', 52.47417000, 6.02222000),
(1078105, 1002611, 'NL', 'Hedel', 1, 'hedel', 51.74802000, 5.26134000),
(1078109, 1002611, 'NL', 'Heelsum', 1, 'heelsum', 51.98417000, 5.75833000),
(1078113, 1002611, 'NL', 'Heerde', 1, 'heerde', 52.38723000, 6.04016000),
(1078115, 1002611, 'NL', 'Heerewaarden', 1, 'heerewaarden', 51.81769000, 5.39300000),
(1078120, 1002611, 'NL', 'Hees', 1, 'hees', 51.84136000, 5.82846000),
(1078141, 1002611, 'NL', 'Hengelo', 1, 'hengelo', 52.05083000, 6.30972000),
(1078143, 1002611, 'NL', 'Hengstdal', 1, 'hengstdal', 51.83333000, 5.88333000),
(1078148, 1002611, 'NL', 'Herwijnen', 1, 'herwijnen', 51.82667000, 5.12917000),
(1078149, 1002611, 'NL', 'Het Loo', 1, 'het-loo', 52.23390000, 5.95275000),
(1078151, 1002611, 'NL', 'Heteren', 1, 'heteren', 51.95667000, 5.75556000),
(1078153, 1002611, 'NL', 'Heumen', 1, 'heumen', 51.76500000, 5.84444000),
(1078183, 1002611, 'NL', 'Hoogkamp', 1, 'hoogkamp', 51.99630000, 5.88026000),
(1078188, 1002611, 'NL', 'Horssen', 1, 'horssen', 51.85583000, 5.60972000),
(1078196, 1002611, 'NL', 'Hummelo', 1, 'hummelo', 52.00417000, 6.23333000),
(1078197, 1002611, 'NL', 'Hunnerberg', 1, 'hunnerberg', 51.84209000, 5.87876000),
(1078204, 1002611, 'NL', 'Ingen', 1, 'ingen', 51.95917000, 5.48472000),
(1078221, 1002611, 'NL', 'Keijenborg', 1, 'keijenborg', 52.02917000, 6.29444000),
(1078225, 1002611, 'NL', 'Kerkdriel', 1, 'kerkdriel', 51.77167000, 5.33472000),
(1078229, 1002611, 'NL', 'Kerschoten', 1, 'kerschoten', 52.23333000, 5.96667000),
(1078231, 1002611, 'NL', 'Kesteren', 1, 'kesteren', 51.93500000, 5.56944000),
(1078248, 1002611, 'NL', 'Kootwijkerbroek', 1, 'kootwijkerbroek', 52.15083000, 5.66944000),
(1078273, 1002611, 'NL', 'Laren', 1, 'laren', 52.19417000, 6.36528000),
(1078282, 1002611, 'NL', 'Leesten', 1, 'leesten', 52.12790000, 6.23217000),
(1078290, 1002611, 'NL', 'Lent', 1, 'lent', 51.86167000, 5.86667000),
(1078295, 1002611, 'NL', 'Leuth', 1, 'leuth', 51.83917000, 5.99167000),
(1078297, 1002611, 'NL', 'Lichtenvoorde', 1, 'lichtenvoorde', 51.98667000, 6.56667000),
(1078299, 1002611, 'NL', 'Lienden', 1, 'lienden', 51.94833000, 5.51806000),
(1078309, 1002611, 'NL', 'Lindenholt', 1, 'lindenholt', 51.83270000, 5.79340000),
(1078315, 1002611, 'NL', 'Lobith', 1, 'lobith', 51.86250000, 6.11806000),
(1078316, 1002611, 'NL', 'Lochem', 1, 'lochem', 52.15917000, 6.41111000),
(1078317, 1002611, 'NL', 'Loenen', 1, 'loenen', 52.11750000, 6.01944000),
(1078327, 1002611, 'NL', 'Lunteren', 1, 'lunteren', 52.08500000, 5.62222000),
(1078345, 1002611, 'NL', 'Malburgen West', 1, 'malburgen-west', 51.96811000, 5.89743000),
(1078357, 1002611, 'NL', 'Matendonk', 1, 'matendonk', 52.19766000, 6.01115000),
(1078358, 1002611, 'NL', 'Matendreef', 1, 'matendreef', 52.19993000, 5.98592000),
(1078359, 1002611, 'NL', 'Matengaarde', 1, 'matengaarde', 52.19793000, 5.99570000),
(1078360, 1002611, 'NL', 'Matenhoeve', 1, 'matenhoeve', 52.19056000, 6.01338000),
(1078361, 1002611, 'NL', 'Matenhorst', 1, 'matenhorst', 52.20482000, 5.99304000),
(1078362, 1002611, 'NL', 'Matenveld', 1, 'matenveld', 52.18767000, 5.99879000),
(1078363, 1002611, 'NL', 'Maurik', 1, 'maurik', 51.96083000, 5.42222000),
(1078386, 1002611, 'NL', 'Meteren', 1, 'meteren', 51.86500000, 5.28333000),
(1078420, 1002611, 'NL', 'Nederhemert', 1, 'nederhemert', 51.76518000, 5.16817000),
(1078421, 1002611, 'NL', 'Nederhemert-Noord', 1, 'nederhemert-noord', 51.76322000, 5.17305000),
(1078423, 1002611, 'NL', 'Nederwoud', 1, 'nederwoud', 52.10083000, 5.57083000),
(1078424, 1002611, 'NL', 'Neede', 1, 'neede', 52.13417000, 6.61389000),
(1078452, 1002611, 'NL', 'Nijkerk', 1, 'nijkerk', 52.22000000, 5.48611000),
(1078453, 1002611, 'NL', 'Nijkerkerveen', 1, 'nijkerkerveen', 52.19500000, 5.46667000),
(1078454, 1002611, 'NL', 'Nijmegen', 1, 'nijmegen', 51.84250000, 5.85278000),
(1078476, 1002611, 'NL', 'Nunspeet', 1, 'nunspeet', 52.37917000, 5.78611000),
(1078481, 1002611, 'NL', 'Ochten', 1, 'ochten', 51.91000000, 5.56944000),
(1078494, 1002611, 'NL', 'Oldebroek', 1, 'oldebroek', 52.44500000, 5.90139000),
(1078505, 1002611, 'NL', 'Ooij', 1, 'ooij', 51.85465000, 5.93915000),
(1078506, 1002611, 'NL', 'Oost Gelre', 1, 'oost-gelre', 52.00425000, 6.54958000),
(1078513, 1002611, 'NL', 'Oostendorp', 1, 'oostendorp', 52.44722000, 5.85443000),
(1078514, 1002611, 'NL', 'Oosterbeek', 1, 'oosterbeek', 51.98583000, 5.84583000),
(1078520, 1002611, 'NL', 'Oosterhout', 1, 'oosterhout', 51.88000000, 5.82639000),
(1078531, 1002611, 'NL', 'Ooy', 1, 'ooy', 51.91917000, 6.05833000),
(1078532, 1002611, 'NL', 'Ooyerhoek', 1, 'ooyerhoek', 52.12838000, 6.22307000),
(1078534, 1002611, 'NL', 'Ophemert', 1, 'ophemert', 51.84500000, 5.38750000),
(1078535, 1002611, 'NL', 'Opheusden', 1, 'opheusden', 51.93167000, 5.63194000),
(1078537, 1002611, 'NL', 'Opijnen', 1, 'opijnen', 51.82917000, 5.29861000),
(1078543, 1002611, 'NL', 'Orden', 1, 'orden', 52.20113000, 5.93417000),
(1078549, 1002611, 'NL', 'Otterlo', 1, 'otterlo', 52.10000000, 5.77222000),
(1078557, 1002611, 'NL', 'Oude IJsselstreek', 1, 'oude-ijsselstreek', 51.89963000, 6.38078000),
(1078569, 1002611, 'NL', 'Overasselt', 1, 'overasselt', 51.76000000, 5.78889000),
(1078576, 1002611, 'NL', 'Pannerden', 1, 'pannerden', 51.89083000, 6.03889000),
(1078598, 1002611, 'NL', 'Puiflijk', 1, 'puiflijk', 51.87833000, 5.59028000),
(1078602, 1002611, 'NL', 'Putten', 1, 'putten', 52.25917000, 5.60694000),
(1078614, 1002611, 'NL', 'Renkum', 1, 'renkum', 51.97667000, 5.73333000),
(1078618, 1002611, 'NL', 'Rheden', 1, 'rheden', 52.00500000, 6.02917000),
(1078631, 1002611, 'NL', 'Rivierenkwartier', 1, 'rivierenkwartier', 52.18914000, 5.97665000),
(1078639, 1002611, 'NL', 'Rossum', 1, 'rossum', 51.80083000, 5.33333000),
(1078645, 1002611, 'NL', 'Rozendaal', 1, 'rozendaal', 52.00583000, 5.96250000),
(1078650, 1002611, 'NL', 'Ruurlo', 1, 'ruurlo', 52.08833000, 6.45000000),
(1078666, 1002611, 'NL', 'Scherpenzeel', 1, 'scherpenzeel', 52.08000000, 5.48889000),
(1078692, 1002611, 'NL', 'Silvolde', 1, 'silvolde', 51.90917000, 6.38750000),
(1078716, 1002611, 'NL', 'Sluisoord', 1, 'sluisoord', 52.22291000, 5.98145000),
(1078724, 1002611, 'NL', 'Spainkbos', 1, 'spainkbos', 52.22228000, 5.94738000),
(1078735, 1002611, 'NL', 'Sprengenbos', 1, 'sprengenbos', 52.21902000, 5.94163000),
(1078736, 1002611, 'NL', 'Sprengenweg-Noord', 1, 'sprengenweg-noord', 52.21839000, 5.95068000),
(1078737, 1002611, 'NL', 'Sprenkelaar', 1, 'sprenkelaar', 52.22512000, 5.99922000),
(1078739, 1002611, 'NL', 'Staatsliedenkwartier', 1, 'staatsliedenkwartier', 52.19951000, 5.97691000),
(1078749, 1002611, 'NL', 'Steenderen', 1, 'steenderen', 52.06417000, 6.18750000),
(1078753, 1002611, 'NL', 'Stegeslag', 1, 'stegeslag', 51.94151000, 6.06194000),
(1078757, 1002611, 'NL', 'Sterrenberg', 1, 'sterrenberg', 51.99350000, 5.88387000),
(1078770, 1002611, 'NL', 'Terborg', 1, 'terborg', 51.92000000, 6.35417000),
(1078775, 1002611, 'NL', 'Terschuur', 1, 'terschuur', 52.16500000, 5.51667000),
(1078777, 1002611, 'NL', 'Terwolde', 1, 'terwolde', 52.28333000, 6.10000000),
(1078783, 1002611, 'NL', 'Tiel', 1, 'tiel', 51.88667000, 5.42917000),
(1078789, 1002611, 'NL', 'Tolkamer', 1, 'tolkamer', 51.85500000, 6.10278000),
(1078791, 1002611, 'NL', 'Tricht', 1, 'tricht', 51.89083000, 5.26806000),
(1078798, 1002611, 'NL', 'Twello', 1, 'twello', 52.23667000, 6.10278000),
(1078806, 1002611, 'NL', 'Uddel', 1, 'uddel', 52.25917000, 5.78056000),
(1078810, 1002611, 'NL', 'Ugchelen', 1, 'ugchelen', 52.18464000, 5.93177000),
(1078825, 1002611, 'NL', 'Vaassen', 1, 'vaassen', 52.28583000, 5.96667000),
(1078826, 1002611, 'NL', 'Valburg', 1, 'valburg', 51.91167000, 5.79028000),
(1078827, 1002611, 'NL', 'Valendries', 1, 'valendries', 51.80658000, 5.73445000),
(1078834, 1002611, 'NL', 'Varsseveld', 1, 'varsseveld', 51.94333000, 6.45833000),
(1078842, 1002611, 'NL', 'Velp', 1, 'velp', 51.99500000, 5.97361000),
(1078867, 1002611, 'NL', 'Vogelkwartier', 1, 'vogelkwartier', 52.19777000, 5.96721000),
(1078877, 1002611, 'NL', 'Voorst', 1, 'voorst', 52.17000000, 6.14167000),
(1078878, 1002611, 'NL', 'Voorthuizen', 1, 'voorthuizen', 52.18667000, 5.60556000),
(1078879, 1002611, 'NL', 'Vorden', 1, 'vorden', 52.10500000, 6.30972000),
(1078881, 1002611, 'NL', 'Vredenburg', 1, 'vredenburg', 51.95355000, 5.90284000),
(1078889, 1002611, 'NL', 'Vuren', 1, 'vuren', 51.82500000, 5.04583000),
(1078894, 1002611, 'NL', 'Waardenburg', 1, 'waardenburg', 51.83250000, 5.25694000),
(1078900, 1002611, 'NL', 'Wageningen', 1, 'wageningen', 51.97000000, 5.66667000),
(1078903, 1002611, 'NL', 'Wapenveld', 1, 'wapenveld', 52.42917000, 6.07361000),
(1078907, 1002611, 'NL', 'Warnsveld', 1, 'warnsveld', 52.13750000, 6.23056000),
(1078918, 1002611, 'NL', 'Wekerom', 1, 'wekerom', 52.11250000, 5.71389000),
(1078920, 1002611, 'NL', 'Welgelegen', 1, 'welgelegen', 52.21397000, 5.97643000),
(1078928, 1002611, 'NL', 'West Betuwe', 1, 'west-betuwe', 51.86158000, 5.20935000),
(1078933, 1002611, 'NL', 'Westeneng', 1, 'westeneng', 52.12750000, 5.71528000),
(1078934, 1002611, 'NL', 'Westenenk', 1, 'westenenk', 52.19624000, 5.95656000),
(1078939, 1002611, 'NL', 'Westervoort', 1, 'westervoort', 51.95583000, 5.97222000),
(1078950, 1002611, 'NL', 'Wijchen', 1, 'wijchen', 51.80917000, 5.72500000),
(1078962, 1002611, 'NL', 'Winkewijert', 1, 'winkewijert', 52.19082000, 5.95794000),
(1078965, 1002611, 'NL', 'Winterswijk', 1, 'winterswijk', 51.97250000, 6.71944000),
(1078967, 1002611, 'NL', 'Wisch', 1, 'wisch', 51.92648000, 6.41705000),
(1078975, 1002611, 'NL', 'Wolfheze', 1, 'wolfheze', 52.00333000, 5.79028000),
(1078985, 1002611, 'NL', 'Woudhuis', 1, 'woudhuis', 52.21323000, 6.01124000),
(1078996, 1002611, 'NL', 'Zaltbommel', 1, 'zaltbommel', 51.81000000, 5.24444000),
(1078999, 1002611, 'NL', 'Zeddam', 1, 'zeddam', 51.90333000, 6.25972000),
(1079006, 1002611, 'NL', 'Zelhem', 1, 'zelhem', 52.00667000, 6.34861000),
(1079008, 1002611, 'NL', 'Zetten', 1, 'zetten', 51.92833000, 5.71389000),
(1079009, 1002611, 'NL', 'Zevenaar', 1, 'zevenaar', 51.93000000, 6.07083000),
(1079012, 1002611, 'NL', 'Zevenhuizen', 1, 'zevenhuizen', 52.21816000, 5.97841000),
(1079015, 1002611, 'NL', 'Zoelen', 1, 'zoelen', 51.91250000, 5.40278000),
(1079019, 1002611, 'NL', 'Zonnemaat', 1, 'zonnemaat', 51.93115000, 6.06235000),
(1079030, 1002611, 'NL', 'Zuilichem', 1, 'zuilichem', 51.80917000, 5.13611000),
(1079032, 1002611, 'NL', 'Zutphen', 1, 'zutphen', 52.13833000, 6.20139000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002617, 'NL', 'Groningen', 1, 'groningen');

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 
(1077318, 1002617, 'NL', 'Aduard', 1, 'aduard', 53.25667000, 6.45972000),
(1077352, 1002617, 'NL', 'Appingedam', 1, 'appingedam', 53.32167000, 6.85833000),
(1077370, 1002617, 'NL', 'Baflo', 1, 'baflo', 53.36250000, 6.51389000),
(1077384, 1002617, 'NL', 'Bedum', 1, 'bedum', 53.30083000, 6.60278000),
(1077398, 1002617, 'NL', 'Bellingwolde', 1, 'bellingwolde', 53.11583000, 7.16528000),
(1077441, 1002617, 'NL', 'Blijham', 1, 'blijham', 53.10917000, 7.07639000),
(1077517, 1002617, 'NL', 'Coendersborg', 1, 'coendersborg', 53.19410000, 6.58944000),
(1077562, 1002617, 'NL', 'De Wijert', 1, 'de-wijert', 53.19450000, 6.57117000),
(1077569, 1002617, 'NL', 'Delfzijl', 1, 'delfzijl', 53.33000000, 6.91806000),
(1077629, 1002617, 'NL', 'Eenrum', 1, 'eenrum', 53.36250000, 6.45833000),
(1077635, 1002617, 'NL', 'Eexta', 1, 'eexta', 53.16386000, 6.98344000),
(1077672, 1002617, 'NL', 'Farmsum', 1, 'farmsum', 53.32167000, 6.92639000),
(1077694, 1002617, 'NL', 'Gemeente  Oldambt', 1, 'gemeente-oldambt', 53.16859000, 7.04224000),
(1077712, 1002617, 'NL', 'Gemeente Appingedam', 1, 'gemeente-appingedam', 53.31926000, 6.84864000),
(1077760, 1002617, 'NL', 'Gemeente Delfzijl', 1, 'gemeente-delfzijl', 53.30019000, 6.93129000),
(1077800, 1002617, 'NL', 'Gemeente Groningen', 1, 'gemeente-groningen', 53.22369000, 6.56479000),
(1077863, 1002617, 'NL', 'Gemeente Loppersum', 1, 'gemeente-loppersum', 53.33849000, 6.72149000),
(1077910, 1002617, 'NL', 'Gemeente Pekela', 1, 'gemeente-pekela', 53.05969000, 6.96510000),
(1077943, 1002617, 'NL', 'Gemeente Stadskanaal', 1, 'gemeente-stadskanaal', 53.00005000, 6.98906000),
(1077968, 1002617, 'NL', 'Gemeente Veendam', 1, 'gemeente-veendam', 53.08951000, 6.87923000),
(1078035, 1002617, 'NL', 'Glimmen', 1, 'glimmen', 53.13917000, 6.62917000),
(1078056, 1002617, 'NL', 'Grijpskerk', 1, 'grijpskerk', 53.26250000, 6.30833000),
(1078063, 1002617, 'NL', 'Groningen', 1, 'groningen', 53.21917000, 6.56667000),
(1078067, 1002617, 'NL', 'Grootegast', 1, 'grootegast', 53.21250000, 6.27361000),
(1078093, 1002617, 'NL', 'Haren', 1, 'haren', 53.17209000, 6.60931000),
(1078096, 1002617, 'NL', 'Harkstede', 1, 'harkstede', 53.21333000, 6.69861000),
(1078129, 1002617, 'NL', 'Heiligerlee', 1, 'heiligerlee', 53.15667000, 7.00972000),
(1078136, 1002617, 'NL', 'Helpman', 1, 'helpman', 53.19794000, 6.57978000),
(1078182, 1002617, 'NL', 'Hoogezand', 1, 'hoogezand', 53.16167000, 6.76111000),
(1078250, 1002617, 'NL', 'Korrewegwijk', 1, 'korrewegwijk', 53.23235000, 6.56804000),
(1078276, 1002617, 'NL', 'Leek', 1, 'leek', 53.16250000, 6.37639000),
(1078278, 1002617, 'NL', 'Leens', 1, 'leens', 53.36000000, 6.37917000),
(1078322, 1002617, 'NL', 'Loppersum', 1, 'loppersum', 53.33167000, 6.74722000),
(1078356, 1002617, 'NL', 'Marum', 1, 'marum', 53.14417000, 6.26250000),
(1078366, 1002617, 'NL', 'Meeden', 1, 'meeden', 53.14000000, 6.92639000),
(1078392, 1002617, 'NL', 'Middelstum', 1, 'middelstum', 53.34667000, 6.64167000),
(1078393, 1002617, 'NL', 'Midden-Groningen', 1, 'midden-groningen', 53.15113000, 6.83313000),
(1078396, 1002617, 'NL', 'Midwolda', 1, 'midwolda', 53.19500000, 7.01389000),
(1078428, 1002617, 'NL', 'Niekerk', 1, 'niekerk', 53.22500000, 6.35278000),
(1078439, 1002617, 'NL', 'Nieuwe Pekela', 1, 'nieuwe-pekela', 53.07917000, 6.96528000),
(1078447, 1002617, 'NL', 'Nieuwolda', 1, 'nieuwolda', 53.24417000, 6.97500000),
(1078464, 1002617, 'NL', 'Noordbroek', 1, 'noordbroek', 53.19500000, 6.87361000),
(1078469, 1002617, 'NL', 'Noordhorn', 1, 'noordhorn', 53.26167000, 6.39583000),
(1078480, 1002617, 'NL', 'Obergum', 1, 'obergum', 53.33333000, 6.51667000),
(1078495, 1002617, 'NL', 'Oldehove', 1, 'oldehove', 53.30333000, 6.39583000),
(1078499, 1002617, 'NL', 'Ommelanderwijk', 1, 'ommelanderwijk', 53.08917000, 6.90556000),
(1078503, 1002617, 'NL', 'Onstwedde', 1, 'onstwedde', 53.03500000, 7.04028000),
(1078518, 1002617, 'NL', 'Oosterhoogebrug', 1, 'oosterhoogebrug', 53.22892000, 6.60141000),
(1078523, 1002617, 'NL', 'Oosterpark', 1, 'oosterpark', 53.22370000, 6.58530000),
(1078558, 1002617, 'NL', 'Oude Pekela', 1, 'oude-pekela', 53.10417000, 7.00972000),
(1078612, 1002617, 'NL', 'Reitdiep', 1, 'reitdiep', 53.24252000, 6.51957000),
(1078652, 1002617, 'NL', 'Sappemeer', 1, 'sappemeer', 53.16417000, 6.79028000),
(1078662, 1002617, 'NL', 'Scheemda', 1, 'scheemda', 53.17333000, 6.97222000),
(1078673, 1002617, 'NL', 'Schildwolde', 1, 'schildwolde', 53.23327000, 6.81566000),
(1078685, 1002617, 'NL', 'Sellingen', 1, 'sellingen', 52.94583000, 7.15139000),
(1078686, 1002617, 'NL', 'Selwerd', 1, 'selwerd', 53.23520000, 6.55450000),
(1078691, 1002617, 'NL', 'Siddeburen', 1, 'siddeburen', 53.25000000, 6.86806000),
(1078712, 1002617, 'NL', 'Slochteren', 1, 'slochteren', 53.22078000, 6.80547000),
(1078732, 1002617, 'NL', 'Spijk', 1, 'spijk', 53.39000000, 6.83750000),
(1078742, 1002617, 'NL', 'Stadskanaal', 1, 'stadskanaal', 52.98947000, 6.95040000),
(1078768, 1002617, 'NL', 'Ten Boer', 1, 'ten-boer', 53.27583000, 6.69444000),
(1078769, 1002617, 'NL', 'Ter Apel', 1, 'ter-apel', 52.87667000, 7.05972000),
(1078793, 1002617, 'NL', 'Tuikwerd', 1, 'tuikwerd', 53.31667000, 6.90000000),
(1078813, 1002617, 'NL', 'Uithuizen', 1, 'uithuizen', 53.40750000, 6.67083000),
(1078814, 1002617, 'NL', 'Uithuizermeeden', 1, 'uithuizermeeden', 53.41417000, 6.72361000),
(1078816, 1002617, 'NL', 'Ulrum', 1, 'ulrum', 53.35917000, 6.33333000),
(1078821, 1002617, 'NL', 'Usquert', 1, 'usquert', 53.40250000, 6.61111000),
(1078836, 1002617, 'NL', 'Veendam', 1, 'veendam', 53.10667000, 6.87917000),
(1078856, 1002617, 'NL', 'Vlagtwedde', 1, 'vlagtwedde', 53.02750000, 7.10833000),
(1078899, 1002617, 'NL', 'Wagenborgen', 1, 'wagenborgen', 53.25583000, 6.93333000),
(1078904, 1002617, 'NL', 'Warffum', 1, 'warffum', 53.39250000, 6.55833000),
(1078938, 1002617, 'NL', 'Westerlee', 1, 'westerlee', 53.14583000, 6.98750000),
(1078940, 1002617, 'NL', 'Westerwolde', 1, 'westerwolde', 53.02800000, 7.15671000),
(1078958, 1002617, 'NL', 'Wildervank', 1, 'wildervank', 53.08083000, 6.86250000),
(1078963, 1002617, 'NL', 'Winschoten', 1, 'winschoten', 53.14417000, 7.03472000),
(1078964, 1002617, 'NL', 'Winsum', 1, 'winsum', 53.33000000, 6.52083000),
(1079021, 1002617, 'NL', 'Zoutkamp', 1, 'zoutkamp', 53.33917000, 6.30417000),
(1079025, 1002617, 'NL', 'Zuidbroek', 1, 'zuidbroek', 53.16333000, 6.86111000),
(1079027, 1002617, 'NL', 'Zuidhorn', 1, 'zuidhorn', 53.24667000, 6.40278000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002615, 'NL', 'Limburg', 1, 'limburg');

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 
(1077316, 1002615, 'NL', 'Abdissenbosch', 1, 'abdissenbosch', 50.91667000, 6.03333000),
(1077332, 1002615, 'NL', 'Amby', 1, 'amby', 50.86215000, 5.73226000),
(1077333, 1002615, 'NL', 'America', 1, 'america', 51.43667000, 5.97917000),
(1077339, 1002615, 'NL', 'Amstenrade', 1, 'amstenrade', 50.93917000, 5.92361000),
(1077353, 1002615, 'NL', 'Arcen', 1, 'arcen', 51.47667000, 6.18056000),
(1077367, 1002615, 'NL', 'Baarlo', 1, 'baarlo', 51.33083000, 6.09444000),
(1077378, 1002615, 'NL', 'Banholt', 1, 'banholt', 50.79000000, 5.80833000),
(1077385, 1002615, 'NL', 'Beegden', 1, 'beegden', 51.18917000, 5.91944000),
(1077387, 1002615, 'NL', 'Beek', 1, 'beek', 50.94083000, 5.79722000),
(1077391, 1002615, 'NL', 'Beersdal', 1, 'beersdal', 50.90597000, 5.96440000),
(1077393, 1002615, 'NL', 'Beesel', 1, 'beesel', 51.26833000, 6.03889000),
(1077397, 1002615, 'NL', 'Belfort', 1, 'belfort', 50.84698000, 5.65991000),
(1077404, 1002615, 'NL', 'Berg', 1, 'berg', 50.86167000, 5.78333000),
(1077413, 1002615, 'NL', 'Beringe', 1, 'beringe', 51.33667000, 5.94861000),
(1077429, 1002615, 'NL', 'Biesland', 1, 'biesland', 50.84110000, 5.67573000),
(1077438, 1002615, 'NL', 'Bleijerheide', 1, 'bleijerheide', 50.85538000, 6.06789000),
(1077442, 1002615, 'NL', 'Blitterswijck', 1, 'blitterswijck', 51.53083000, 6.10833000),
(1077447, 1002615, 'NL', 'Bocholtz', 1, 'bocholtz', 50.81833000, 6.00556000),
(1077457, 1002615, 'NL', 'Borgharen', 1, 'borgharen', 50.87750000, 5.68750000),
(1077458, 1002615, 'NL', 'Born', 1, 'born', 51.03167000, 5.80972000),
(1077468, 1002615, 'NL', 'Brabander', 1, 'brabander', 51.53583000, 5.96806000),
(1077469, 1002615, 'NL', 'Brachterbeek', 1, 'brachterbeek', 51.14694000, 5.90446000),
(1077484, 1002615, 'NL', 'Broekhem', 1, 'broekhem', 50.87119000, 5.82069000),
(1077486, 1002615, 'NL', 'Broeksittard', 1, 'broeksittard', 51.00290000, 5.89511000),
(1077491, 1002615, 'NL', 'Brukske', 1, 'brukske', 51.52101000, 5.99270000),
(1077495, 1002615, 'NL', 'Brunssum', 1, 'brunssum', 50.94667000, 5.97083000),
(1077496, 1002615, 'NL', 'Buchten', 1, 'buchten', 51.04333000, 5.80972000),
(1077500, 1002615, 'NL', 'Budschop', 1, 'budschop', 51.28511000, 5.75898000),
(1077502, 1002615, 'NL', 'Bunde', 1, 'bunde', 50.89667000, 5.73194000),
(1077516, 1002615, 'NL', 'Chevremont', 1, 'chevremont', 50.87554000, 6.05981000),
(1077544, 1002615, 'NL', 'De Heeg', 1, 'de-heeg', 50.82454000, 5.72309000),
(1077585, 1002615, 'NL', 'Doenrade', 1, 'doenrade', 50.96750000, 5.90694000),
(1077636, 1002615, 'NL', 'Egchel', 1, 'egchel', 51.31417000, 5.97222000),
(1077640, 1002615, 'NL', 'Eijsden', 1, 'eijsden', 50.78000000, 5.71770000),
(1077641, 1002615, 'NL', 'Eijsden-Margraten', 1, 'eijsden-margraten', 50.80090000, 5.77408000),
(1077643, 1002615, 'NL', 'Einighausen', 1, 'einighausen', 51.00167000, 5.82778000),
(1077649, 1002615, 'NL', 'Elsloo', 1, 'elsloo', 50.94917000, 5.77083000),
(1077693, 1002615, 'NL', 'Geleen', 1, 'geleen', 50.97417000, 5.82917000),
(1077720, 1002615, 'NL', 'Gemeente Beek', 1, 'gemeente-beek', 50.93237000, 5.80587000),
(1077722, 1002615, 'NL', 'Gemeente Beesel', 1, 'gemeente-beesel', 51.27016000, 6.06771000),
(1077724, 1002615, 'NL', 'Gemeente Bergen', 1, 'gemeente-bergen', 51.57717000, 6.09014000),
(1077744, 1002615, 'NL', 'Gemeente Brunssum', 1, 'gemeente-brunssum', 50.94451000, 5.97618000),
(1077776, 1002615, 'NL', 'Gemeente Echt-Susteren', 1, 'gemeente-echt-susteren', 51.10000000, 5.86667000),
(1077792, 1002615, 'NL', 'Gemeente Gennep', 1, 'gemeente-gennep', 51.70063000, 5.98447000),
(1077816, 1002615, 'NL', 'Gemeente Heerlen', 1, 'gemeente-heerlen', 50.88777000, 5.97407000),
(1077833, 1002615, 'NL', 'Gemeente Horst aan de Maas', 1, 'gemeente-horst-aan-de-maas', 51.45931000, 6.10254000),
(1077842, 1002615, 'NL', 'Gemeente Kerkrade', 1, 'gemeente-kerkrade', 50.87337000, 6.04876000),
(1077856, 1002615, 'NL', 'Gemeente Leudal', 1, 'gemeente-leudal', 51.24371000, 5.89815000),
(1077866, 1002615, 'NL', 'Gemeente Maasgouw', 1, 'gemeente-maasgouw', 51.15426000, 5.87712000),
(1077868, 1002615, 'NL', 'Gemeente Maastricht', 1, 'gemeente-maastricht', 50.85000000, 5.70000000),
(1077870, 1002615, 'NL', 'Gemeente Meerssen', 1, 'gemeente-meerssen', 50.89518000, 5.75711000),
(1077879, 1002615, 'NL', 'Gemeente Mook en Middelaar', 1, 'gemeente-mook-en-middelaar', 51.74777000, 5.90200000),
(1077881, 1002615, 'NL', 'Gemeente Nederweert', 1, 'gemeente-nederweert', 51.28813000, 5.77157000),
(1077909, 1002615, 'NL', 'Gemeente Peel en Maas', 1, 'gemeente-peel-en-maas', 51.32353000, 5.97261000),
(1077924, 1002615, 'NL', 'Gemeente Roerdalen', 1, 'gemeente-roerdalen', 51.13492000, 6.03542000),
(1077925, 1002615, 'NL', 'Gemeente Roermond', 1, 'gemeente-roermond', 51.19999000, 6.00900000),
(1077933, 1002615, 'NL', 'Gemeente Simpelveld', 1, 'gemeente-simpelveld', 50.82901000, 5.98410000),
(1077936, 1002615, 'NL', 'Gemeente Sittard-Geleen', 1, 'gemeente-sittard-geleen', 51.01074000, 5.82288000),
(1077948, 1002615, 'NL', 'Gemeente Stein', 1, 'gemeente-stein', 50.97358000, 5.76126000),
(1077966, 1002615, 'NL', 'Gemeente Vaals', 1, 'gemeente-vaals', 50.77848000, 5.97674000),
(1077973, 1002615, 'NL', 'Gemeente Venlo', 1, 'gemeente-venlo', 51.39277000, 6.16041000),
(1077974, 1002615, 'NL', 'Gemeente Venray', 1, 'gemeente-venray', 51.51412000, 5.95927000),
(1077978, 1002615, 'NL', 'Gemeente Voerendaal', 1, 'gemeente-voerendaal', 50.87117000, 5.91495000),
(1077988, 1002615, 'NL', 'Gemeente Weert', 1, 'gemeente-weert', 51.23418000, 5.69067000),
(1078024, 1002615, 'NL', 'Gennep', 1, 'gennep', 51.69833000, 5.97361000),
(1078049, 1002615, 'NL', 'Gracht', 1, 'gracht', 50.85175000, 6.02793000),
(1078051, 1002615, 'NL', 'Grashoek', 1, 'grashoek', 51.36083000, 5.94306000),
(1078054, 1002615, 'NL', 'Grevenbicht', 1, 'grevenbicht', 51.03833000, 5.77500000),
(1078064, 1002615, 'NL', 'Gronsveld', 1, 'gronsveld', 50.81083000, 5.73056000),
(1078070, 1002615, 'NL', 'Gulpen', 1, 'gulpen', 50.81583000, 5.88889000),
(1078071, 1002615, 'NL', 'Gulpen-Wittem', 1, 'gulpen-wittem', 50.81374000, 5.89296000),
(1078072, 1002615, 'NL', 'Guttecoven', 1, 'guttecoven', 51.01500000, 5.81806000),
(1078078, 1002615, 'NL', 'Haanrade', 1, 'haanrade', 50.87981000, 6.07411000),
(1078084, 1002615, 'NL', 'Haelen', 1, 'haelen', 51.23583000, 5.95694000),
(1078108, 1002615, 'NL', 'Heel', 1, 'heel', 51.17917000, 5.89444000),
(1078112, 1002615, 'NL', 'Heer', 1, 'heer', 50.83836000, 5.72989000),
(1078119, 1002615, 'NL', 'Heerlen', 1, 'heerlen', 50.88365000, 5.98154000),
(1078125, 1002615, 'NL', 'Hegelsom', 1, 'hegelsom', 51.43917000, 6.03889000),
(1078126, 1002615, 'NL', 'Heide', 1, 'heide', 51.06833000, 5.87222000),
(1078127, 1002615, 'NL', 'Heijen', 1, 'heijen', 51.67500000, 5.98056000),
(1078132, 1002615, 'NL', 'Heksenberg', 1, 'heksenberg', 50.92068000, 5.97373000),
(1078133, 1002615, 'NL', 'Helden', 1, 'helden', 51.31917000, 6.00000000),
(1078145, 1002615, 'NL', 'Herkenbosch', 1, 'herkenbosch', 51.15333000, 6.06389000),
(1078147, 1002615, 'NL', 'Herten', 1, 'herten', 51.18083000, 5.96250000),
(1078152, 1002615, 'NL', 'Heugem', 1, 'heugem', 50.82791000, 5.70774000),
(1078156, 1002615, 'NL', 'Heythuysen', 1, 'heythuysen', 51.25000000, 5.89861000),
(1078164, 1002615, 'NL', 'Hoensbroek', 1, 'hoensbroek', 50.92387000, 5.92528000),
(1078171, 1002615, 'NL', 'Holtum', 1, 'holtum', 51.04750000, 5.82222000),
(1078173, 1002615, 'NL', 'Holz', 1, 'holz', 50.86415000, 6.07424000),
(1078187, 1002615, 'NL', 'Hopel', 1, 'hopel', 50.89245000, 6.05046000),
(1078190, 1002615, 'NL', 'Houthem', 1, 'houthem', 50.87250000, 5.79306000),
(1078194, 1002615, 'NL', 'Hulsberg', 1, 'hulsberg', 50.88917000, 5.85556000),
(1078199, 1002615, 'NL', 'Husken', 1, 'husken', 50.89567000, 5.95648000),
(1078209, 1002615, 'NL', 'Kaalheide', 1, 'kaalheide', 50.86505000, 6.03643000),
(1078211, 1002615, 'NL', 'Kakert', 1, 'kakert', 50.90414000, 6.00463000),
(1078220, 1002615, 'NL', 'Keent', 1, 'keent', 51.24218000, 5.70079000),
(1078222, 1002615, 'NL', 'Kelpen-Oler', 1, 'kelpen-oler', 51.21817000, 5.82602000),
(1078224, 1002615, 'NL', 'Kerensheide', 1, 'kerensheide', 50.97210000, 5.77666000),
(1078228, 1002615, 'NL', 'Kerkrade', 1, 'kerkrade', 50.86583000, 6.06250000),
(1078230, 1002615, 'NL', 'Kessel', 1, 'kessel', 51.29167000, 6.05417000),
(1078238, 1002615, 'NL', 'Klimmen', 1, 'klimmen', 50.87583000, 5.88056000),
(1078245, 1002615, 'NL', 'Koningsbosch', 1, 'koningsbosch', 51.05167000, 5.95833000),
(1078246, 1002615, 'NL', 'Koningslust', 1, 'koningslust', 51.35750000, 5.99306000),
(1078259, 1002615, 'NL', 'Kruisberg', 1, 'kruisberg', 50.94234000, 5.96519000),
(1078262, 1002615, 'NL', 'Kunrade', 1, 'kunrade', 50.87769000, 5.93107000),
(1078267, 1002615, 'NL', 'Landgraaf', 1, 'landgraaf', 50.91333000, 6.05722000),
(1078275, 1002615, 'NL', 'Lauradorp', 1, 'lauradorp', 50.91229000, 6.04591000),
(1078284, 1002615, 'NL', 'Leeuwen', 1, 'leeuwen', 51.21032000, 5.99862000),
(1078292, 1002615, 'NL', 'Leuken', 1, 'leuken', 51.25288000, 5.73460000),
(1078293, 1002615, 'NL', 'Leunen', 1, 'leunen', 51.51000000, 5.97917000),
(1078296, 1002615, 'NL', 'Lichtenberg', 1, 'lichtenberg', 50.90220000, 6.02523000),
(1078305, 1002615, 'NL', 'Limbricht', 1, 'limbricht', 51.01167000, 5.83750000),
(1078306, 1002615, 'NL', 'Limmel', 1, 'limmel', 50.86718000, 5.70719000),
(1078308, 1002615, 'NL', 'Lindenheuvel', 1, 'lindenheuvel', 50.98509000, 5.81667000),
(1078310, 1002615, 'NL', 'Linne', 1, 'linne', 51.15500000, 5.93889000),
(1078324, 1002615, 'NL', 'Lottum', 1, 'lottum', 51.46167000, 6.16111000),
(1078334, 1002615, 'NL', 'Maasbracht', 1, 'maasbracht', 51.13929000, 5.88627000),
(1078335, 1002615, 'NL', 'Maasbree', 1, 'maasbree', 51.35750000, 6.04861000),
(1078340, 1002615, 'NL', 'Maastricht', 1, 'maastricht', 50.84833000, 5.68889000),
(1078344, 1002615, 'NL', 'Malberg', 1, 'malberg', 50.86244000, 5.65419000),
(1078348, 1002615, 'NL', 'Margraten', 1, 'margraten', 50.82083000, 5.82083000),
(1078350, 1002615, 'NL', 'Mariarade', 1, 'mariarade', 50.92906000, 5.92738000),
(1078364, 1002615, 'NL', 'Mechelen', 1, 'mechelen', 50.79583000, 5.92639000),
(1078368, 1002615, 'NL', 'Meerlo', 1, 'meerlo', 51.51333000, 6.08472000),
(1078369, 1002615, 'NL', 'Meerssen', 1, 'meerssen', 50.88750000, 5.75000000),
(1078371, 1002615, 'NL', 'Meezenbroek', 1, 'meezenbroek', 50.89680000, 5.99051000),
(1078374, 1002615, 'NL', 'Meijel', 1, 'meijel', 51.34417000, 5.88472000),
(1078376, 1002615, 'NL', 'Melderslo', 1, 'melderslo', 51.46167000, 6.08611000),
(1078377, 1002615, 'NL', 'Melick', 1, 'melick', 51.15917000, 6.01667000),
(1078383, 1002615, 'NL', 'Merkelbeek', 1, 'merkelbeek', 50.95389000, 5.94069000),
(1078384, 1002615, 'NL', 'Merselo', 1, 'merselo', 51.53000000, 5.92778000),
(1078385, 1002615, 'NL', 'Merum', 1, 'merum', 51.17333000, 5.95972000),
(1078402, 1002615, 'NL', 'Milsbeek', 1, 'milsbeek', 51.72500000, 5.94861000),
(1078405, 1002615, 'NL', 'Moesel', 1, 'moesel', 51.23828000, 5.71778000),
(1078410, 1002615, 'NL', 'Montfort', 1, 'montfort', 51.12583000, 5.94861000),
(1078411, 1002615, 'NL', 'Mook', 1, 'mook', 51.75250000, 5.88194000),
(1078414, 1002615, 'NL', 'Munstergeleen', 1, 'munstergeleen', 50.97500000, 5.86389000),
(1078422, 1002615, 'NL', 'Nederweert', 1, 'nederweert', 51.28583000, 5.74861000),
(1078425, 1002615, 'NL', 'Neerbeek', 1, 'neerbeek', 50.95000000, 5.81528000),
(1078435, 1002615, 'NL', 'Nieuw-Lotbroek', 1, 'nieuw-lotbroek', 50.91283000, 5.92798000),
(1078438, 1002615, 'NL', 'Nieuwdorp', 1, 'nieuwdorp', 50.96216000, 5.77297000),
(1078477, 1002615, 'NL', 'Nuth', 1, 'nuth', 50.91750000, 5.88611000),
(1078478, 1002615, 'NL', 'Obbicht', 1, 'obbicht', 51.02833000, 5.78056000),
(1078488, 1002615, 'NL', 'Offenbeek', 1, 'offenbeek', 51.28225000, 6.09500000),
(1078489, 1002615, 'NL', 'Oirlo', 1, 'oirlo', 51.51167000, 6.03750000),
(1078490, 1002615, 'NL', 'Oirsbeek', 1, 'oirsbeek', 50.95083000, 5.90833000),
(1078528, 1002615, 'NL', 'Oostrum', 1, 'oostrum', 51.52917000, 6.01667000),
(1078536, 1002615, 'NL', 'Ophoven', 1, 'ophoven', 50.99036000, 5.85868000),
(1078545, 1002615, 'NL', 'Ospel', 1, 'ospel', 51.29750000, 5.78472000),
(1078550, 1002615, 'NL', 'Ottersum', 1, 'ottersum', 51.70333000, 5.98333000),
(1078553, 1002615, 'NL', 'Oud-Caberg', 1, 'oud-caberg', 50.86539000, 5.66444000),
(1078571, 1002615, 'NL', 'Overhoven', 1, 'overhoven', 51.00869000, 5.86628000),
(1078577, 1002615, 'NL', 'Panningen', 1, 'panningen', 51.32667000, 5.97917000),
(1078580, 1002615, 'NL', 'Passart', 1, 'passart', 50.92389000, 5.94674000),
(1078584, 1002615, 'NL', 'Peij', 1, 'peij', 51.09417000, 5.89583000),
(1078594, 1002615, 'NL', 'Posterholt', 1, 'posterholt', 51.12333000, 6.03472000),
(1078595, 1002615, 'NL', 'Pottenberg', 1, 'pottenberg', 50.85135000, 5.65668000),
(1078600, 1002615, 'NL', 'Puth', 1, 'puth', 50.95417000, 5.87361000),
(1078617, 1002615, 'NL', 'Reuver', 1, 'reuver', 51.28417000, 6.07778000),
(1078635, 1002615, 'NL', 'Roermond', 1, 'roermond', 51.19417000, 5.98750000),
(1078638, 1002615, 'NL', 'Roosteren', 1, 'roosteren', 51.08333000, 5.81806000),
(1078641, 1002615, 'NL', 'Rothem', 1, 'rothem', 50.87667000, 5.73889000),
(1078660, 1002615, 'NL', 'Scharn', 1, 'scharn', 50.85000000, 5.73333000),
(1078672, 1002615, 'NL', 'Schilberg', 1, 'schilberg', 51.09917000, 5.88611000),
(1078674, 1002615, 'NL', 'Schimmert', 1, 'schimmert', 50.90667000, 5.82361000),
(1078675, 1002615, 'NL', 'Schinnen', 1, 'schinnen', 50.94333000, 5.88889000),
(1078676, 1002615, 'NL', 'Schinveld', 1, 'schinveld', 50.96917000, 5.97917000),
(1078688, 1002615, 'NL', 'Sevenum', 1, 'sevenum', 51.41250000, 6.03750000),
(1078690, 1002615, 'NL', 'Sibbe', 1, 'sibbe', 50.84417000, 5.82639000),
(1078693, 1002615, 'NL', 'Simpelveld', 1, 'simpelveld', 50.83417000, 5.98194000),
(1078698, 1002615, 'NL', 'Sint Joost', 1, 'sint-joost', 51.11750000, 5.89861000),
(1078701, 1002615, 'NL', 'Sint Odiliënberg', 1, 'sint-odilienberg', 51.14333000, 6.00000000),
(1078708, 1002615, 'NL', 'Sittard', 1, 'sittard', 50.99833000, 5.86944000),
(1078727, 1002615, 'NL', 'Spaubeek', 1, 'spaubeek', 50.94000000, 5.84306000),
(1078730, 1002615, 'NL', 'Spekholzerheide', 1, 'spekholzerheide', 50.85559000, 6.02471000),
(1078740, 1002615, 'NL', 'Stadbroek', 1, 'stadbroek', 51.00187000, 5.87656000),
(1078754, 1002615, 'NL', 'Stein', 1, 'stein', 50.96917000, 5.76667000),
(1078762, 1002615, 'NL', 'Stramproy', 1, 'stramproy', 51.19417000, 5.71944000),
(1078767, 1002615, 'NL', 'Tegelen', 1, 'tegelen', 51.34417000, 6.13611000),
(1078776, 1002615, 'NL', 'Terwinselen', 1, 'terwinselen', 50.86659000, 6.02471000),
(1078782, 1002615, 'NL', 'Thorn', 1, 'thorn', 51.16167000, 5.84167000),
(1078784, 1002615, 'NL', 'Tienray', 1, 'tienray', 51.49500000, 6.09306000),
(1078805, 1002615, 'NL', 'Ubachsberg', 1, 'ubachsberg', 50.85333000, 5.94861000),
(1078815, 1002615, 'NL', 'Ulestraten', 1, 'ulestraten', 50.90583000, 5.78194000),
(1078820, 1002615, 'NL', 'Urmond', 1, 'urmond', 50.99083000, 5.77222000),
(1078823, 1002615, 'NL', 'Vaals', 1, 'vaals', 50.77083000, 6.01806000),
(1078829, 1002615, 'NL', 'Valkenburg', 1, 'valkenburg', 50.86523000, 5.83205000),
(1078830, 1002615, 'NL', 'Valkenburg aan de Geul', 1, 'valkenburg-aan-de-geul', 50.85711000, 5.83489000),
(1078844, 1002615, 'NL', 'Veltum', 1, 'veltum', 51.51954000, 5.96032000),
(1078847, 1002615, 'NL', 'Venlo', 1, 'venlo', 51.37000000, 6.16806000),
(1078848, 1002615, 'NL', 'Venray', 1, 'venray', 51.52500000, 5.97500000),
(1078852, 1002615, 'NL', 'Vijlen', 1, 'vijlen', 50.78833000, 5.96528000),
(1078863, 1002615, 'NL', 'Vlodrop', 1, 'vlodrop', 51.13333000, 6.07639000),
(1078865, 1002615, 'NL', 'Voerendaal', 1, 'voerendaal', 50.88327000, 5.92978000),
(1078884, 1002615, 'NL', 'Vrieheide', 1, 'vrieheide', 50.92192000, 5.96701000),
(1078902, 1002615, 'NL', 'Wanssum', 1, 'wanssum', 51.53583000, 6.07639000),
(1078912, 1002615, 'NL', 'Waubach', 1, 'waubach', 50.91833000, 6.05000000),
(1078914, 1002615, 'NL', 'Weert', 1, 'weert', 51.25167000, 5.70694000),
(1078921, 1002615, 'NL', 'Well', 1, 'well', 51.55000000, 6.08889000),
(1078922, 1002615, 'NL', 'Wellerlooi', 1, 'wellerlooi', 51.53417000, 6.13611000),
(1078927, 1002615, 'NL', 'Wessem', 1, 'wessem', 51.15954000, 5.88146000),
(1078955, 1002615, 'NL', 'Wijlre', 1, 'wijlre', 50.83333000, 5.89583000),
(1078956, 1002615, 'NL', 'Wijnandsrade', 1, 'wijnandsrade', 50.90583000, 5.88333000),
(1078974, 1002615, 'NL', 'Wolder', 1, 'wolder', 50.83752000, 5.65938000),
(1078991, 1002615, 'NL', 'Ysselsteyn', 1, 'ysselsteyn', 51.49000000, 5.89722000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002623, 'NL', 'North Brabant', 1, 'north-brabant');

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 
(1077297, 1002623, 'NL', '\'s Gravenmoer', 1, 's-gravenmoer', 51.65594000, 4.94076000),
(1077301, 1002623, 'NL', '\'s-Hertogenbosch', 1, 's-hertogenbosch', 51.69917000, 5.30417000),
(1077302, 1002623, 'NL', '\'t Hofke', 1, 't-hofke', 51.44943000, 5.51926000),
(1077305, 1002623, 'NL', 'Aalburg', 1, 'aalburg', 51.75482000, 5.13156000),
(1077308, 1002623, 'NL', 'Aalst', 1, 'aalst', 51.39667000, 5.47778000),
(1077312, 1002623, 'NL', 'Aarle-Rixtel', 1, 'aarle-rixtel', 51.50976000, 5.63839000),
(1077315, 1002623, 'NL', 'Abcoven', 1, 'abcoven', 51.52750000, 5.08333000),
(1077320, 1002623, 'NL', 'Akert', 1, 'akert', 51.41407000, 5.55960000),
(1077328, 1002623, 'NL', 'Almkerk', 1, 'almkerk', 51.77083000, 4.95972000),
(1077329, 1002623, 'NL', 'Alphen', 1, 'alphen', 51.48167000, 4.95833000),
(1077342, 1002623, 'NL', 'Andel', 1, 'andel', 51.78333000, 5.05833000),
(1077358, 1002623, 'NL', 'Asten', 1, 'asten', 51.40417000, 5.74861000),
(1077365, 1002623, 'NL', 'Baardwijk', 1, 'baardwijk', 51.69246000, 5.09628000),
(1077366, 1002623, 'NL', 'Baarle-Nassau', 1, 'baarle-nassau', 51.44750000, 4.92917000),
(1077371, 1002623, 'NL', 'Bakel', 1, 'bakel', 51.50333000, 5.74028000),
(1077383, 1002623, 'NL', 'Bavel', 1, 'bavel', 51.56583000, 4.83056000),
(1077386, 1002623, 'NL', 'Beek', 1, 'beek', 51.52890000, 5.63382000),
(1077390, 1002623, 'NL', 'Beers', 1, 'beers', 51.72583000, 5.82778000),
(1077396, 1002623, 'NL', 'Belcrum', 1, 'belcrum', 51.59911000, 4.76994000),
(1077407, 1002623, 'NL', 'Bergeijk', 1, 'bergeijk', 51.30182000, 5.33946000),
(1077408, 1002623, 'NL', 'Bergen op Zoom', 1, 'bergen-op-zoom', 51.49500000, 4.29167000),
(1077410, 1002623, 'NL', 'Berghem', 1, 'berghem', 51.76991000, 5.56827000),
(1077419, 1002623, 'NL', 'Berlicum', 1, 'berlicum', 51.67750000, 5.40000000),
(1077421, 1002623, 'NL', 'Besoijen', 1, 'besoijen', 51.68333000, 5.05000000),
(1077422, 1002623, 'NL', 'Best', 1, 'best', 51.50750000, 5.39028000),
(1077423, 1002623, 'NL', 'Besterd', 1, 'besterd', 51.56380000, 5.08658000),
(1077428, 1002623, 'NL', 'Biesdonk', 1, 'biesdonk', 51.60613000, 4.78515000),
(1077434, 1002623, 'NL', 'Bitswijk', 1, 'bitswijk', 51.66870000, 5.60921000),
(1077435, 1002623, 'NL', 'Blaarthem', 1, 'blaarthem', 51.42501000, 5.45784000),
(1077436, 1002623, 'NL', 'Bladel', 1, 'bladel', 51.36833000, 5.22083000),
(1077450, 1002623, 'NL', 'Boekel', 1, 'boekel', 51.60333000, 5.67500000),
(1077464, 1002623, 'NL', 'Bosschenhoofd', 1, 'bosschenhoofd', 51.56083000, 4.54028000),
(1077466, 1002623, 'NL', 'Boxmeer', 1, 'boxmeer', 51.64667000, 5.94722000),
(1077467, 1002623, 'NL', 'Boxtel', 1, 'boxtel', 51.59083000, 5.32917000),
(1077472, 1002623, 'NL', 'Brand', 1, 'brand', 51.45839000, 5.62427000),
(1077473, 1002623, 'NL', 'Breda', 1, 'breda', 51.58656000, 4.77596000),
(1077478, 1002623, 'NL', 'Breugel', 1, 'breugel', 51.51750000, 5.51111000),
(1077485, 1002623, 'NL', 'Broekhoven', 1, 'broekhoven', 51.54801000, 5.09175000),
(1077497, 1002623, 'NL', 'Budel', 1, 'budel', 51.27167000, 5.57500000),
(1077498, 1002623, 'NL', 'Budel-Dorplein', 1, 'budel-dorplein', 51.23667000, 5.58750000),
(1077499, 1002623, 'NL', 'Budel-Schoot', 1, 'budel-schoot', 51.24750000, 5.56528000),
(1077515, 1002623, 'NL', 'Chaam', 1, 'chaam', 51.50583000, 4.86111000),
(1077518, 1002623, 'NL', 'Coevering', 1, 'coevering', 51.41742000, 5.57463000),
(1077525, 1002623, 'NL', 'Cranendonck', 1, 'cranendonck', 51.30417000, 5.58889000),
(1077526, 1002623, 'NL', 'Cuijk', 1, 'cuijk', 51.73083000, 5.87917000),
(1077533, 1002623, 'NL', 'De Blaak', 1, 'de-blaak', 51.54626000, 5.04465000),
(1077536, 1002623, 'NL', 'De Doornakkers', 1, 'de-doornakkers', 51.43844000, 5.50887000),
(1077550, 1002623, 'NL', 'De Kruiskamp', 1, 'de-kruiskamp', 51.69978000, 5.26032000),
(1077557, 1002623, 'NL', 'De Reit', 1, 'de-reit', 51.56038000, 5.04932000),
(1077559, 1002623, 'NL', 'De Rompert', 1, 'de-rompert', 51.71667000, 5.31667000),
(1077571, 1002623, 'NL', 'Den Dungen', 1, 'den-dungen', 51.66500000, 5.37222000),
(1077575, 1002623, 'NL', 'Deuteren', 1, 'deuteren', 51.68667000, 5.26667000),
(1077580, 1002623, 'NL', 'Diessen', 1, 'diessen', 51.47583000, 5.17500000),
(1077582, 1002623, 'NL', 'Dinteloord', 1, 'dinteloord', 51.63500000, 4.36944000),
(1077590, 1002623, 'NL', 'Dommelen', 1, 'dommelen', 51.34624000, 5.43394000),
(1077591, 1002623, 'NL', 'Dongen', 1, 'dongen', 51.62667000, 4.93889000),
(1077592, 1002623, 'NL', 'Donk', 1, 'donk', 51.53843000, 5.62914000),
(1077594, 1002623, 'NL', 'Doonheide', 1, 'doonheide', 51.56667000, 5.69444000),
(1077601, 1002623, 'NL', 'Dorst', 1, 'dorst', 51.59000000, 4.85694000),
(1077619, 1002623, 'NL', 'Duizel', 1, 'duizel', 51.36833000, 5.29722000),
(1077623, 1002623, 'NL', 'Eckart', 1, 'eckart', 51.47320000, 5.49449000),
(1077631, 1002623, 'NL', 'Eerde', 1, 'eerde', 51.60417000, 5.49861000),
(1077632, 1002623, 'NL', 'Eerschot', 1, 'eerschot', 51.56833000, 5.47361000),
(1077633, 1002623, 'NL', 'Eersel', 1, 'eersel', 51.35750000, 5.31806000),
(1077642, 1002623, 'NL', 'Eindhoven', 1, 'eindhoven', 51.44083000, 5.47778000),
(1077644, 1002623, 'NL', 'Ekenrooi', 1, 'ekenrooi', 51.39656000, 5.48624000),
(1077648, 1002623, 'NL', 'Elshout', 1, 'elshout', 51.70083000, 5.14167000),
(1077663, 1002623, 'NL', 'Enschot', 1, 'enschot', 51.57846000, 5.13885000),
(1077667, 1002623, 'NL', 'Erp', 1, 'erp', 51.60000000, 5.60694000),
(1077668, 1002623, 'NL', 'Esch', 1, 'esch', 51.61083000, 5.29028000),
(1077676, 1002623, 'NL', 'Fijnaart', 1, 'fijnaart', 51.63750000, 4.46944000),
(1077680, 1002623, 'NL', 'Gageldonk', 1, 'gageldonk', 51.60167000, 4.73889000),
(1077686, 1002623, 'NL', 'Geenhoven', 1, 'geenhoven', 51.35935000, 5.46021000),
(1077687, 1002623, 'NL', 'Geertruidenberg', 1, 'geertruidenberg', 51.70167000, 4.85694000),
(1077688, 1002623, 'NL', 'Geffen', 1, 'geffen', 51.74000000, 5.46389000),
(1077692, 1002623, 'NL', 'Geldrop', 1, 'geldrop', 51.42167000, 5.55972000),
(1077695, 1002623, 'NL', 'Gemeente \'s-Hertogenbosch', 1, 'gemeente-s-hertogenbosch', 51.68267000, 5.30056000),
(1077706, 1002623, 'NL', 'Gemeente Alphen-Chaam', 1, 'gemeente-alphen-chaam', 51.50341000, 4.88013000),
(1077715, 1002623, 'NL', 'Gemeente Asten', 1, 'gemeente-asten', 51.39231000, 5.77910000),
(1077716, 1002623, 'NL', 'Gemeente Baarle-Nassau', 1, 'gemeente-baarle-nassau', 51.43544000, 4.91180000),
(1077726, 1002623, 'NL', 'Gemeente Bergen op Zoom', 1, 'gemeente-bergen-op-zoom', 51.50451000, 4.29108000),
(1077727, 1002623, 'NL', 'Gemeente Bernheze', 1, 'gemeente-bernheze', 51.68556000, 5.52378000),
(1077728, 1002623, 'NL', 'Gemeente Best', 1, 'gemeente-best', 51.50000000, 5.38333000),
(1077731, 1002623, 'NL', 'Gemeente Bladel', 1, 'gemeente-bladel', 51.35000000, 5.21667000),
(1077734, 1002623, 'NL', 'Gemeente Boekel', 1, 'gemeente-boekel', 51.60489000, 5.69357000),
(1077738, 1002623, 'NL', 'Gemeente Boxmeer', 1, 'gemeente-boxmeer', 51.63333000, 5.95000000),
(1077739, 1002623, 'NL', 'Gemeente Boxtel', 1, 'gemeente-boxtel', 51.58472000, 5.32654000),
(1077740, 1002623, 'NL', 'Gemeente Breda', 1, 'gemeente-breda', 51.57790000, 4.76039000),
(1077751, 1002623, 'NL', 'Gemeente Cranendonck', 1, 'gemeente-cranendonck', 51.27746000, 5.58373000),
(1077752, 1002623, 'NL', 'Gemeente Cuijk', 1, 'gemeente-cuijk', 51.71739000, 5.85773000),
(1077763, 1002623, 'NL', 'Gemeente Deurne', 1, 'gemeente-deurne', 51.43701000, 5.82245000),
(1077769, 1002623, 'NL', 'Gemeente Dongen', 1, 'gemeente-dongen', 51.63754000, 4.95361000),
(1077772, 1002623, 'NL', 'Gemeente Drimmelen', 1, 'gemeente-drimmelen', 51.66667000, 4.78333000),
(1077780, 1002623, 'NL', 'Gemeente Eersel', 1, 'gemeente-eersel', 51.39579000, 5.31956000),
(1077781, 1002623, 'NL', 'Gemeente Eindhoven', 1, 'gemeente-eindhoven', 51.45037000, 5.45279000),
(1077788, 1002623, 'NL', 'Gemeente Etten-Leur', 1, 'gemeente-etten-leur', 51.57711000, 4.64253000),
(1077789, 1002623, 'NL', 'Gemeente Geertruidenberg', 1, 'gemeente-geertruidenberg', 51.69634000, 4.87836000),
(1077790, 1002623, 'NL', 'Gemeente Geldrop-Mierlo', 1, 'gemeente-geldrop-mierlo', 51.43372000, 5.59926000),
(1077791, 1002623, 'NL', 'Gemeente Gemert-Bakel', 1, 'gemeente-gemert-bakel', 51.52554000, 5.72802000),
(1077793, 1002623, 'NL', 'Gemeente Gilze en Rijen', 1, 'gemeente-gilze-en-rijen', 51.55656000, 4.91253000),
(1077796, 1002623, 'NL', 'Gemeente Goirle', 1, 'gemeente-goirle', 51.50875000, 5.03381000),
(1077799, 1002623, 'NL', 'Gemeente Grave', 1, 'gemeente-grave', 51.73970000, 5.74366000),
(1077802, 1002623, 'NL', 'Gemeente Haaren', 1, 'gemeente-haaren', 51.61831000, 5.22779000),
(1077805, 1002623, 'NL', 'Gemeente Halderberge', 1, 'gemeente-halderberge', 51.58925000, 4.50597000),
(1077817, 1002623, 'NL', 'Gemeente Heeze-Leende', 1, 'gemeente-heeze-leende', 51.36404000, 5.55870000),
(1077821, 1002623, 'NL', 'Gemeente Helmond', 1, 'gemeente-helmond', 51.47968000, 5.65559000),
(1077825, 1002623, 'NL', 'Gemeente Heusden', 1, 'gemeente-heusden', 51.69975000, 5.16598000),
(1077827, 1002623, 'NL', 'Gemeente Hilvarenbeek', 1, 'gemeente-hilvarenbeek', 51.47772000, 5.14778000),
(1077845, 1002623, 'NL', 'Gemeente Laarbeek', 1, 'gemeente-laarbeek', 51.52643000, 5.61283000),
(1077846, 1002623, 'NL', 'Gemeente Landerd', 1, 'gemeente-landerd', 51.71151000, 5.66580000),
(1077861, 1002623, 'NL', 'Gemeente Loon op Zand', 1, 'gemeente-loon-op-zand', 51.63782000, 5.04860000),
(1077875, 1002623, 'NL', 'Gemeente Mill en Sint Hubert', 1, 'gemeente-mill-en-sint-hubert', 51.68712000, 5.77077000),
(1077876, 1002623, 'NL', 'Gemeente Moerdijk', 1, 'gemeente-moerdijk', 51.63933000, 4.56379000),
(1077890, 1002623, 'NL', 'Gemeente Nuenen, Gerwen en Nederwetten', 1, 'gemeente-nuenen-gerwen-en-nederwetten', 51.46667000, 5.53333000),
(1077893, 1002623, 'NL', 'Gemeente Oirschot', 1, 'gemeente-oirschot', 51.49062000, 5.28959000),
(1077894, 1002623, 'NL', 'Gemeente Oisterwijk', 1, 'gemeente-oisterwijk', 51.55289000, 5.20188000),
(1077899, 1002623, 'NL', 'Gemeente Oosterhout', 1, 'gemeente-oosterhout', 51.63435000, 4.86399000),
(1077904, 1002623, 'NL', 'Gemeente Oss', 1, 'gemeente-oss', 51.78103000, 5.58111000),
(1077918, 1002623, 'NL', 'Gemeente Reusel-De Mierden', 1, 'gemeente-reusel-de-mierden', 51.38047000, 5.15790000),
(1077928, 1002623, 'NL', 'Gemeente Rucphen', 1, 'gemeente-rucphen', 51.52357000, 4.56586000),
(1077934, 1002623, 'NL', 'Gemeente Sint Anthonis', 1, 'gemeente-sint-anthonis', 51.61826000, 5.84354000),
(1077935, 1002623, 'NL', 'Gemeente Sint-Michielsgestel', 1, 'gemeente-sint-michielsgestel', 51.66076000, 5.37851000),
(1077941, 1002623, 'NL', 'Gemeente Someren', 1, 'gemeente-someren', 51.38233000, 5.71049000),
(1077942, 1002623, 'NL', 'Gemeente Son en Breugel', 1, 'gemeente-son-en-breugel', 51.50970000, 5.49934000),
(1077946, 1002623, 'NL', 'Gemeente Steenbergen', 1, 'gemeente-steenbergen', 51.60081000, 4.32077000),
(1077955, 1002623, 'NL', 'Gemeente Tilburg', 1, 'gemeente-tilburg', 51.57787000, 5.06555000),
(1077960, 1002623, 'NL', 'Gemeente Uden', 1, 'gemeente-uden', 51.65682000, 5.61258000),
(1077967, 1002623, 'NL', 'Gemeente Valkenswaard', 1, 'gemeente-valkenswaard', 51.32575000, 5.45323000),
(1077971, 1002623, 'NL', 'Gemeente Veldhoven', 1, 'gemeente-veldhoven', 51.41253000, 5.38052000),
(1077981, 1002623, 'NL', 'Gemeente Vught', 1, 'gemeente-vught', 51.65822000, 5.26746000),
(1077982, 1002623, 'NL', 'Gemeente Waalre', 1, 'gemeente-waalre', 51.38757000, 5.46380000),
(1077983, 1002623, 'NL', 'Gemeente Waalwijk', 1, 'gemeente-waalwijk', 51.68970000, 5.01721000),
(1078001, 1002623, 'NL', 'Gemeente Woensdrecht', 1, 'gemeente-woensdrecht', 51.40948000, 4.33512000),
(1078014, 1002623, 'NL', 'Gemeente Zundert', 1, 'gemeente-zundert', 51.47352000, 4.64180000),
(1078019, 1002623, 'NL', 'Gemert', 1, 'gemert', 51.55583000, 5.69028000),
(1078020, 1002623, 'NL', 'Gemonde', 1, 'gemonde', 51.61833000, 5.35694000),
(1078021, 1002623, 'NL', 'Genderen', 1, 'genderen', 51.73583000, 5.08750000),
(1078025, 1002623, 'NL', 'Genoenhuis', 1, 'genoenhuis', 51.40917000, 5.53889000),
(1078026, 1002623, 'NL', 'Gerwen', 1, 'gerwen', 51.49000000, 5.56250000),
(1078028, 1002623, 'NL', 'Giessen', 1, 'giessen', 51.79000000, 5.03056000),
(1078033, 1002623, 'NL', 'Gilze', 1, 'gilze', 51.54417000, 4.94028000),
(1078034, 1002623, 'NL', 'Ginneken', 1, 'ginneken', 51.56593000, 4.79310000),
(1078038, 1002623, 'NL', 'Goirle', 1, 'goirle', 51.52083000, 5.06667000),
(1078052, 1002623, 'NL', 'Grasrijk', 1, 'grasrijk', 51.43916000, 5.41544000),
(1078053, 1002623, 'NL', 'Grave', 1, 'grave', 51.75902000, 5.73882000),
(1078059, 1002623, 'NL', 'Groenewoud', 1, 'groenewoud', 51.53860000, 5.09028000),
(1078079, 1002623, 'NL', 'Haaren', 1, 'haaren', 51.60250000, 5.22222000),
(1078082, 1002623, 'NL', 'Haarsteeg', 1, 'haarsteeg', 51.71167000, 5.19861000),
(1078087, 1002623, 'NL', 'Halsteren', 1, 'halsteren', 51.52834000, 4.26785000),
(1078088, 1002623, 'NL', 'Handel', 1, 'handel', 51.58000000, 5.70972000),
(1078089, 1002623, 'NL', 'Hapert', 1, 'hapert', 51.36833000, 5.25694000),
(1078090, 1002623, 'NL', 'Haps', 1, 'haps', 51.68917000, 5.86111000),
(1078118, 1002623, 'NL', 'Heerle', 1, 'heerle', 51.51917000, 4.35972000),
(1078121, 1002623, 'NL', 'Heesch', 1, 'heesch', 51.73362000, 5.52672000),
(1078122, 1002623, 'NL', 'Heesterakker', 1, 'heesterakker', 51.48610000, 5.49681000),
(1078123, 1002623, 'NL', 'Heeswijk-Dinther', 1, 'heeswijk-dinther', 51.65083000, 5.47500000),
(1078124, 1002623, 'NL', 'Heeze', 1, 'heeze', 51.38280000, 5.57145000),
(1078135, 1002623, 'NL', 'Helmond', 1, 'helmond', 51.48167000, 5.66111000),
(1078137, 1002623, 'NL', 'Helvoirt', 1, 'helvoirt', 51.63167000, 5.23056000),
(1078146, 1002623, 'NL', 'Herpen', 1, 'herpen', 51.77167000, 5.64167000),
(1078154, 1002623, 'NL', 'Heusden', 1, 'heusden', 51.38417000, 5.76389000),
(1078155, 1002623, 'NL', 'Heusdenhout', 1, 'heusdenhout', 51.58811000, 4.81930000),
(1078158, 1002623, 'NL', 'Hilvarenbeek', 1, 'hilvarenbeek', 51.48583000, 5.13750000),
(1078165, 1002623, 'NL', 'Hoeven', 1, 'hoeven', 51.57917000, 4.58333000),
(1078168, 1002623, 'NL', 'Hoge Vucht', 1, 'hoge-vucht', 51.60794000, 4.79150000),
(1078177, 1002623, 'NL', 'Hooge Mierde', 1, 'hooge-mierde', 51.38750000, 5.12917000),
(1078178, 1002623, 'NL', 'Hooge Zwaluwe', 1, 'hooge-zwaluwe', 51.68750000, 4.74444000),
(1078179, 1002623, 'NL', 'Hoogeloon', 1, 'hoogeloon', 51.39750000, 5.26806000),
(1078180, 1002623, 'NL', 'Hoogerheide', 1, 'hoogerheide', 51.42417000, 4.32500000),
(1078191, 1002623, 'NL', 'Huijbergen', 1, 'huijbergen', 51.43250000, 4.37639000),
(1078205, 1002623, 'NL', 'Jagershoef', 1, 'jagershoef', 51.47330000, 5.46720000),
(1078212, 1002623, 'NL', 'Kalsdonk', 1, 'kalsdonk', 51.53973000, 4.47111000),
(1078237, 1002623, 'NL', 'Klein-Zundert', 1, 'klein-zundert', 51.48083000, 4.65417000),
(1078240, 1002623, 'NL', 'Klundert', 1, 'klundert', 51.66500000, 4.53472000),
(1078252, 1002623, 'NL', 'Korvel', 1, 'korvel', 51.54954000, 5.07079000),
(1078258, 1002623, 'NL', 'Krooswijk', 1, 'krooswijk', 51.64665000, 4.59203000),
(1078260, 1002623, 'NL', 'Kruisland', 1, 'kruisland', 51.56917000, 4.40972000),
(1078264, 1002623, 'NL', 'Lage Mierde', 1, 'lage-mierde', 51.40583000, 5.14722000),
(1078265, 1002623, 'NL', 'Lakerlopen', 1, 'lakerlopen', 51.43791000, 5.50106000),
(1078270, 1002623, 'NL', 'Langenboom', 1, 'langenboom', 51.70417000, 5.73056000),
(1078277, 1002623, 'NL', 'Leende', 1, 'leende', 51.35083000, 5.55417000),
(1078281, 1002623, 'NL', 'Leest', 1, 'leest', 51.60983000, 5.54312000),
(1078291, 1002623, 'NL', 'Lepelstraat', 1, 'lepelstraat', 51.54833000, 4.27639000),
(1078298, 1002623, 'NL', 'Liempde', 1, 'liempde', 51.56917000, 5.37222000),
(1078300, 1002623, 'NL', 'Lierop', 1, 'lierop', 51.41917000, 5.67917000),
(1078301, 1002623, 'NL', 'Lieshout', 1, 'lieshout', 51.52036000, 5.59479000),
(1078302, 1002623, 'NL', 'Liessel', 1, 'liessel', 51.41333000, 5.82083000),
(1078304, 1002623, 'NL', 'Lievendaal', 1, 'lievendaal', 51.44219000, 5.43405000),
(1078314, 1002623, 'NL', 'Lith', 1, 'lith', 51.80583000, 5.43889000),
(1078319, 1002623, 'NL', 'Loon op Zand', 1, 'loon-op-zand', 51.62750000, 5.07500000),
(1078320, 1002623, 'NL', 'Loosbroek', 1, 'loosbroek', 51.67833000, 5.50694000),
(1078325, 1002623, 'NL', 'Loven', 1, 'loven', 51.56480000, 5.09748000),
(1078329, 1002623, 'NL', 'Luyksgestel', 1, 'luyksgestel', 51.28917000, 5.32361000),
(1078330, 1002623, 'NL', 'Maarheeze', 1, 'maarheeze', 51.31167000, 5.61667000),
(1078337, 1002623, 'NL', 'Maaskantje', 1, 'maaskantje', 51.65833000, 5.37083000),
(1078341, 1002623, 'NL', 'Made', 1, 'made', 51.67667000, 4.79306000),
(1078349, 1002623, 'NL', 'Mariahout', 1, 'mariahout', 51.54083000, 5.57222000),
(1078367, 1002623, 'NL', 'Meerhoven', 1, 'meerhoven', 51.44267000, 5.41102000),
(1078370, 1002623, 'NL', 'Meerveldhoven', 1, 'meerveldhoven', 51.41705000, 5.41618000),
(1078372, 1002623, 'NL', 'Megen', 1, 'megen', 51.82167000, 5.56250000),
(1078373, 1002623, 'NL', 'Meierijstad', 1, 'meierijstad', 51.59968000, 5.50278000),
(1078379, 1002623, 'NL', 'Melle', 1, 'melle', 51.66244000, 5.63367000),
(1078387, 1002623, 'NL', 'Middelbeers', 1, 'middelbeers', 51.46667000, 5.25000000),
(1078390, 1002623, 'NL', 'Middelrode', 1, 'middelrode', 51.66417000, 5.41944000),
(1078398, 1002623, 'NL', 'Mierlo', 1, 'mierlo', 51.44000000, 5.61944000),
(1078401, 1002623, 'NL', 'Milheeze', 1, 'milheeze', 51.50167000, 5.77917000),
(1078404, 1002623, 'NL', 'Moerdijk', 1, 'moerdijk', 51.70167000, 4.62639000),
(1078406, 1002623, 'NL', 'Molenhoek', 1, 'molenhoek', 51.71113000, 5.36809000),
(1078415, 1002623, 'NL', 'Muschberg en Geestenberg', 1, 'muschberg-en-geestenberg', 51.44384000, 5.52329000),
(1078418, 1002623, 'NL', 'Naastenbest', 1, 'naastenbest', 51.50484000, 5.38579000),
(1078426, 1002623, 'NL', 'Neerkant', 1, 'neerkant', 51.36833000, 5.86667000),
(1078437, 1002623, 'NL', 'Nieuw-Vossemeer', 1, 'nieuw-vossemeer', 51.59000000, 4.21806000),
(1078446, 1002623, 'NL', 'Nieuwkuijk', 1, 'nieuwkuijk', 51.69000000, 5.18194000),
(1078455, 1002623, 'NL', 'Nijnsel', 1, 'nijnsel', 51.55083000, 5.48333000),
(1078457, 1002623, 'NL', 'Nispen', 1, 'nispen', 51.48331000, 4.46131000),
(1078459, 1002623, 'NL', 'Nistelrode', 1, 'nistelrode', 51.70417000, 5.56250000),
(1078467, 1002623, 'NL', 'Noordgeest', 1, 'noordgeest', 51.50917000, 4.27917000),
(1078468, 1002623, 'NL', 'Noordhoek', 1, 'noordhoek', 51.64250000, 4.53194000),
(1078474, 1002623, 'NL', 'Nuenen', 1, 'nuenen', 51.47000000, 5.55278000),
(1078483, 1002623, 'NL', 'Odiliapeel', 1, 'odiliapeel', 51.64333000, 5.70556000),
(1078487, 1002623, 'NL', 'Oerle', 1, 'oerle', 51.42255000, 5.37163000),
(1078491, 1002623, 'NL', 'Oirschot', 1, 'oirschot', 51.50500000, 5.31389000),
(1078492, 1002623, 'NL', 'Oisterwijk', 1, 'oisterwijk', 51.57917000, 5.18889000),
(1078510, 1002623, 'NL', 'Oosteind', 1, 'oosteind', 51.64418000, 4.89784000),
(1078512, 1002623, 'NL', 'Oostelbeers', 1, 'oostelbeers', 51.47171000, 5.26897000),
(1078519, 1002623, 'NL', 'Oosterhout', 1, 'oosterhout', 51.64500000, 4.85972000),
(1078544, 1002623, 'NL', 'Orthen', 1, 'orthen', 51.70613000, 5.30468000),
(1078546, 1002623, 'NL', 'Oss', 1, 'oss', 51.76500000, 5.51806000),
(1078547, 1002623, 'NL', 'Ossendrecht', 1, 'ossendrecht', 51.39417000, 4.32639000),
(1078551, 1002623, 'NL', 'Oud Gastel', 1, 'oud-gastel', 51.58667000, 4.45972000),
(1078572, 1002623, 'NL', 'Overloon', 1, 'overloon', 51.57167000, 5.94722000),
(1078596, 1002623, 'NL', 'Princenhage', 1, 'princenhage', 51.57632000, 4.73906000),
(1078597, 1002623, 'NL', 'Prinsenbeek', 1, 'prinsenbeek', 51.59833000, 4.71250000),
(1078601, 1002623, 'NL', 'Putte', 1, 'putte', 51.36000000, 4.39583000),
(1078603, 1002623, 'NL', 'Quirijnstok', 1, 'quirijnstok', 51.58430000, 5.09810000),
(1078605, 1002623, 'NL', 'Raam', 1, 'raam', 51.65967000, 5.63637000),
(1078606, 1002623, 'NL', 'Raamsdonk', 1, 'raamsdonk', 51.68750000, 4.90833000),
(1078607, 1002623, 'NL', 'Raamsdonksveer', 1, 'raamsdonksveer', 51.69667000, 4.87361000),
(1078609, 1002623, 'NL', 'Ravenstein', 1, 'ravenstein', 51.79667000, 5.65000000),
(1078610, 1002623, 'NL', 'Reek', 1, 'reek', 51.74583000, 5.68194000),
(1078616, 1002623, 'NL', 'Reusel', 1, 'reusel', 51.36250000, 5.16528000),
(1078622, 1002623, 'NL', 'Riethoven', 1, 'riethoven', 51.35417000, 5.38750000),
(1078623, 1002623, 'NL', 'Rijen', 1, 'rijen', 51.59083000, 4.91944000),
(1078627, 1002623, 'NL', 'Rijsbergen', 1, 'rijsbergen', 51.51750000, 4.69722000),
(1078629, 1002623, 'NL', 'Rijswijk', 1, 'rijswijk', 51.79750000, 5.02500000),
(1078637, 1002623, 'NL', 'Roosendaal', 1, 'roosendaal', 51.53083000, 4.46528000),
(1078646, 1002623, 'NL', 'Rucphen', 1, 'rucphen', 51.53167000, 4.55833000),
(1078651, 1002623, 'NL', 'Salderes', 1, 'salderes', 51.51505000, 5.38991000),
(1078657, 1002623, 'NL', 'Schaijk', 1, 'schaijk', 51.74583000, 5.63194000),
(1078671, 1002623, 'NL', 'Schijndel', 1, 'schijndel', 51.62250000, 5.43194000),
(1078684, 1002623, 'NL', 'Schutsboom', 1, 'schutsboom', 51.46152000, 5.62260000),
(1078695, 1002623, 'NL', 'Sint Anthonis', 1, 'sint-anthonis', 51.62667000, 5.88194000),
(1078704, 1002623, 'NL', 'Sint Willebrord', 1, 'sint-willebrord', 51.54833000, 4.58889000),
(1078705, 1002623, 'NL', 'Sint-Michielsgestel', 1, 'sint-michielsgestel', 51.64167000, 5.35278000),
(1078706, 1002623, 'NL', 'Sint-Oedenrode', 1, 'sint-oedenrode', 51.56750000, 5.45972000),
(1078718, 1002623, 'NL', 'Soerendonk', 1, 'soerendonk', 51.30083000, 5.57500000),
(1078721, 1002623, 'NL', 'Someren', 1, 'someren', 51.38500000, 5.71111000),
(1078722, 1002623, 'NL', 'Someren-Eind', 1, 'someren-eind', 51.35750000, 5.73333000),
(1078723, 1002623, 'NL', 'Son', 1, 'son', 51.51136000, 5.49282000),
(1078729, 1002623, 'NL', 'Speelheide', 1, 'speelheide', 51.50607000, 5.40519000),
(1078738, 1002623, 'NL', 'Sprundel', 1, 'sprundel', 51.53750000, 4.59722000),
(1078743, 1002623, 'NL', 'Stampersgat', 1, 'stampersgat', 51.61333000, 4.44444000),
(1078744, 1002623, 'NL', 'Standdaarbuiten', 1, 'standdaarbuiten', 51.61333000, 4.51389000),
(1078748, 1002623, 'NL', 'Steenbergen', 1, 'steenbergen', 51.58417000, 4.31944000),
(1078750, 1002623, 'NL', 'Steensel', 1, 'steensel', 51.37667000, 5.35278000),
(1078756, 1002623, 'NL', 'Stepekolk', 1, 'stepekolk', 51.45500000, 5.61251000),
(1078772, 1002623, 'NL', 'Terheijden', 1, 'terheijden', 51.64333000, 4.75417000),
(1078778, 1002623, 'NL', 'Teteringen', 1, 'teteringen', 51.60917000, 4.82083000),
(1078780, 1002623, 'NL', 'Theereheide', 1, 'theereheide', 51.63843000, 5.33729000),
(1078786, 1002623, 'NL', 'Tilburg', 1, 'tilburg', 51.55551000, 5.09130000),
(1078788, 1002623, 'NL', 'Tivoli', 1, 'tivoli', 51.42069000, 5.50818000),
(1078790, 1002623, 'NL', 'Tongelre', 1, 'tongelre', 51.44889000, 5.51978000),
(1078807, 1002623, 'NL', 'Uden', 1, 'uden', 51.66083000, 5.61944000),
(1078808, 1002623, 'NL', 'Udenhout', 1, 'udenhout', 51.60917000, 5.14306000),
(1078817, 1002623, 'NL', 'Ulvenhout', 1, 'ulvenhout', 51.54907000, 4.79931000),
(1078824, 1002623, 'NL', 'Vaartbroek', 1, 'vaartbroek', 51.47954000, 5.49806000),
(1078831, 1002623, 'NL', 'Valkenswaard', 1, 'valkenswaard', 51.35083000, 5.45972000),
(1078835, 1002623, 'NL', 'Veen', 1, 'veen', 51.77750000, 5.10833000),
(1078839, 1002623, 'NL', 'Veghel', 1, 'veghel', 51.61667000, 5.54861000),
(1078840, 1002623, 'NL', 'Veldhoven', 1, 'veldhoven', 51.41833000, 5.40278000),
(1078845, 1002623, 'NL', 'Ven', 1, 'ven', 51.64000000, 5.55000000),
(1078846, 1002623, 'NL', 'Venhorst', 1, 'venhorst', 51.60833000, 5.73750000),
(1078853, 1002623, 'NL', 'Villapark', 1, 'villapark', 51.44144000, 5.49385000),
(1078859, 1002623, 'NL', 'Vliedberg', 1, 'vliedberg', 51.68961000, 5.19031000),
(1078860, 1002623, 'NL', 'Vlierden', 1, 'vlierden', 51.44500000, 5.75833000),
(1078864, 1002623, 'NL', 'Vlokhoven', 1, 'vlokhoven', 51.46667000, 5.48333000),
(1078869, 1002623, 'NL', 'Voldijn', 1, 'voldijn', 51.40052000, 5.47196000),
(1078871, 1002623, 'NL', 'Volkel', 1, 'volkel', 51.64250000, 5.65417000),
(1078880, 1002623, 'NL', 'Vorstenbosch', 1, 'vorstenbosch', 51.65250000, 5.55000000),
(1078888, 1002623, 'NL', 'Vught', 1, 'vught', 51.65333000, 5.28750000),
(1078891, 1002623, 'NL', 'Waalre', 1, 'waalre', 51.38667000, 5.44444000),
(1078892, 1002623, 'NL', 'Waalwijk', 1, 'waalwijk', 51.68250000, 5.07083000),
(1078898, 1002623, 'NL', 'Wagenberg', 1, 'wagenberg', 51.66500000, 4.74861000),
(1078901, 1002623, 'NL', 'Wanroij', 1, 'wanroij', 51.65750000, 5.81806000),
(1078908, 1002623, 'NL', 'Waspik', 1, 'waspik', 51.68667000, 4.94444000),
(1078911, 1002623, 'NL', 'Waterdonken', 1, 'waterdonken', 51.60959000, 4.80452000),
(1078919, 1002623, 'NL', 'Welberg', 1, 'welberg', 51.57667000, 4.33056000),
(1078924, 1002623, 'NL', 'Werkendam', 1, 'werkendam', 51.81000000, 4.89444000),
(1078926, 1002623, 'NL', 'Wernhout', 1, 'wernhout', 51.45500000, 4.64167000),
(1078937, 1002623, 'NL', 'Westerhoven', 1, 'westerhoven', 51.33250000, 5.39583000),
(1078949, 1002623, 'NL', 'Wijbosch', 1, 'wijbosch', 51.61667000, 5.46806000),
(1078959, 1002623, 'NL', 'Wilhelminadorp', 1, 'wilhelminadorp', 51.49742000, 5.39223000),
(1078968, 1002623, 'NL', 'Wisselaar', 1, 'wisselaar', 51.61285000, 4.78444000),
(1078971, 1002623, 'NL', 'Woensdrecht', 1, 'woensdrecht', 51.42897000, 4.30355000),
(1078972, 1002623, 'NL', 'Woenselse Heide', 1, 'woenselse-heide', 51.48333000, 5.46667000),
(1078986, 1002623, 'NL', 'Woudrichem', 1, 'woudrichem', 51.81500000, 5.00139000),
(1078988, 1002623, 'NL', 'Wouw', 1, 'wouw', 51.52167000, 4.39028000),
(1078997, 1002623, 'NL', 'Zandberg', 1, 'zandberg', 51.57333000, 4.78472000),
(1079000, 1002623, 'NL', 'Zeeland', 1, 'zeeland', 51.69750000, 5.67639000),
(1079001, 1002623, 'NL', 'Zeelst', 1, 'zeelst', 51.42421000, 5.41566000),
(1079003, 1002623, 'NL', 'Zegge', 1, 'zegge', 51.55667000, 4.51806000),
(1079004, 1002623, 'NL', 'Zeilberg', 1, 'zeilberg', 51.45469000, 5.81878000),
(1079007, 1002623, 'NL', 'Zesgehuchten', 1, 'zesgehuchten', 51.41667000, 5.55000000),
(1079010, 1002623, 'NL', 'Zevenbergschen Hoek', 1, 'zevenbergschen-hoek', 51.67250000, 4.67917000),
(1079014, 1002623, 'NL', 'Zijtaart', 1, 'zijtaart', 51.59250000, 5.54167000),
(1079018, 1002623, 'NL', 'Zonderwijk', 1, 'zonderwijk', 51.41141000, 5.39361000),
(1079031, 1002623, 'NL', 'Zundert', 1, 'zundert', 51.47167000, 4.65556000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002612, 'NL', 'North Holland', 1, 'north-holland');

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 
(1077303, 1002612, 'NL', '\'t Zand', 1, 't-zand', 52.83667000, 4.75556000),
(1077307, 1002612, 'NL', 'Aalsmeer', 1, 'aalsmeer', 52.25917000, 4.75972000),
(1077313, 1002612, 'NL', 'Abbekerk', 1, 'abbekerk', 52.73167000, 5.01806000),
(1077325, 1002612, 'NL', 'Alkmaar', 1, 'alkmaar', 52.63167000, 4.74861000),
(1077338, 1002612, 'NL', 'Amstelveen', 1, 'amstelveen', 52.30083000, 4.86389000),
(1077340, 1002612, 'NL', 'Amsterdam', 1, 'amsterdam', 52.37403000, 4.88969000),
(1077341, 1002612, 'NL', 'Amsterdam-Zuidoost', 1, 'amsterdam-zuidoost', 52.30750000, 4.97222000),
(1077347, 1002612, 'NL', 'Ankeveense Rade', 1, 'ankeveense-rade', 52.25891000, 5.10160000),
(1077361, 1002612, 'NL', 'Avenhorn', 1, 'avenhorn', 52.61750000, 4.95139000),
(1077377, 1002612, 'NL', 'Bangert', 1, 'bangert', 52.73582000, 5.18010000),
(1077401, 1002612, 'NL', 'Bennebroek', 1, 'bennebroek', 52.32083000, 4.59861000),
(1077417, 1002612, 'NL', 'Berkhout', 1, 'berkhout', 52.64083000, 5.00139000),
(1077426, 1002612, 'NL', 'Beverwijk', 1, 'beverwijk', 52.48333000, 4.65694000),
(1077430, 1002612, 'NL', 'Bijvanck', 1, 'bijvanck', 52.28585000, 5.26534000),
(1077437, 1002612, 'NL', 'Blaricum', 1, 'blaricum', 52.27250000, 5.24167000),
(1077443, 1002612, 'NL', 'Bloemendaal', 1, 'bloemendaal', 52.40250000, 4.62222000),
(1077476, 1002612, 'NL', 'Breezand', 1, 'breezand', 52.89000000, 4.80417000),
(1077482, 1002612, 'NL', 'Broek in Waterland', 1, 'broek-in-waterland', 52.43417000, 4.99583000),
(1077483, 1002612, 'NL', 'Broek op Langedijk', 1, 'broek-op-langedijk', 52.67417000, 4.80556000),
(1077508, 1002612, 'NL', 'Bussum', 1, 'bussum', 52.27333000, 5.16111000),
(1077509, 1002612, 'NL', 'Callantsoog', 1, 'callantsoog', 52.84000000, 4.69583000),
(1077514, 1002612, 'NL', 'Castricum', 1, 'castricum', 52.54833000, 4.66944000),
(1077521, 1002612, 'NL', 'Commandeurs', 1, 'commandeurs', 52.50902000, 4.65843000),
(1077539, 1002612, 'NL', 'De Glip', 1, 'de-glip', 52.33083000, 4.61111000),
(1077540, 1002612, 'NL', 'De Goorn', 1, 'de-goorn', 52.62583000, 4.94722000),
(1077549, 1002612, 'NL', 'De Koog', 1, 'de-koog', 53.09750000, 4.76111000),
(1077553, 1002612, 'NL', 'De Maer', 1, 'de-maer', 52.51901000, 4.68171000),
(1077555, 1002612, 'NL', 'De Noord', 1, 'de-noord', 52.70750000, 4.85139000),
(1077558, 1002612, 'NL', 'De Rijp', 1, 'de-rijp', 52.55667000, 4.84583000),
(1077570, 1002612, 'NL', 'Den Burg', 1, 'den-burg', 53.05417000, 4.79722000),
(1077573, 1002612, 'NL', 'Den Helder', 1, 'den-helder', 52.95988000, 4.75933000),
(1077574, 1002612, 'NL', 'Den Oever', 1, 'den-oever', 52.93353000, 5.03079000),
(1077577, 1002612, 'NL', 'Diemen', 1, 'diemen', 52.33964000, 4.96256000),
(1077583, 1002612, 'NL', 'Dirkshorn', 1, 'dirkshorn', 52.75000000, 4.77500000),
(1077609, 1002612, 'NL', 'Driemond', 1, 'driemond', 52.30583000, 5.01667000),
(1077618, 1002612, 'NL', 'Duivendrecht', 1, 'duivendrecht', 52.32941000, 4.93964000),
(1077624, 1002612, 'NL', 'Edam', 1, 'edam', 52.51215000, 5.04805000),
(1077637, 1002612, 'NL', 'Egmond aan Zee', 1, 'egmond-aan-zee', 52.62040000, 4.62705000),
(1077638, 1002612, 'NL', 'Egmond-Binnen', 1, 'egmond-binnen', 52.59583000, 4.65556000),
(1077660, 1002612, 'NL', 'Enkhuizen', 1, 'enkhuizen', 52.70333000, 5.29167000),
(1077697, 1002612, 'NL', 'Gemeente Aalsmeer', 1, 'gemeente-aalsmeer', 52.26406000, 4.76532000),
(1077702, 1002612, 'NL', 'Gemeente Alkmaar', 1, 'gemeente-alkmaar', 52.62890000, 4.74403000),
(1077709, 1002612, 'NL', 'Gemeente Amstelveen', 1, 'gemeente-amstelveen', 52.29840000, 4.85767000),
(1077710, 1002612, 'NL', 'Gemeente Amsterdam', 1, 'gemeente-amsterdam', 52.37302000, 4.89856000),
(1077721, 1002612, 'NL', 'Gemeente Beemster', 1, 'gemeente-beemster', 52.55402000, 4.91810000),
(1077725, 1002612, 'NL', 'Gemeente Bergen', 1, 'gemeente-bergen', 52.65783000, 4.67610000),
(1077730, 1002612, 'NL', 'Gemeente Beverwijk', 1, 'gemeente-beverwijk', 52.48273000, 4.65468000),
(1077732, 1002612, 'NL', 'Gemeente Blaricum', 1, 'gemeente-blaricum', 52.28548000, 5.26830000),
(1077733, 1002612, 'NL', 'Gemeente Bloemendaal', 1, 'gemeente-bloemendaal', 52.36230000, 4.58968000),
(1077749, 1002612, 'NL', 'Gemeente Castricum', 1, 'gemeente-castricum', 52.55577000, 4.68945000),
(1077762, 1002612, 'NL', 'Gemeente Den Helder', 1, 'gemeente-den-helder', 52.92366000, 4.75793000),
(1077765, 1002612, 'NL', 'Gemeente Diemen', 1, 'gemeente-diemen', 52.34163000, 4.96805000),
(1077771, 1002612, 'NL', 'Gemeente Drechterland', 1, 'gemeente-drechterland', 52.66454000, 5.16569000),
(1077777, 1002612, 'NL', 'Gemeente Edam-Volendam', 1, 'gemeente-edam-volendam', 52.50556000, 5.05920000),
(1077784, 1002612, 'NL', 'Gemeente Enkhuizen', 1, 'gemeente-enkhuizen', 52.71653000, 5.27615000),
(1077803, 1002612, 'NL', 'Gemeente Haarlem', 1, 'gemeente-haarlem', 52.38074000, 4.64400000),
(1077804, 1002612, 'NL', 'Gemeente Haarlemmermeer', 1, 'gemeente-haarlemmermeer', 52.30623000, 4.68418000),
(1077811, 1002612, 'NL', 'Gemeente Heemskerk', 1, 'gemeente-heemskerk', 52.50945000, 4.65386000),
(1077812, 1002612, 'NL', 'Gemeente Heemstede', 1, 'gemeente-heemstede', 52.34719000, 4.61838000),
(1077815, 1002612, 'NL', 'Gemeente Heerhugowaard', 1, 'gemeente-heerhugowaard', 52.68210000, 4.84363000),
(1077818, 1002612, 'NL', 'Gemeente Heiloo', 1, 'gemeente-heiloo', 52.60122000, 4.70945000),
(1077828, 1002612, 'NL', 'Gemeente Hilversum', 1, 'gemeente-hilversum', 52.22252000, 5.16789000),
(1077830, 1002612, 'NL', 'Gemeente Hollands Kroon', 1, 'gemeente-hollands-kroon', 52.84882000, 4.90711000),
(1077832, 1002612, 'NL', 'Gemeente Hoorn', 1, 'gemeente-hoorn', 52.64312000, 5.05779000),
(1077835, 1002612, 'NL', 'Gemeente Huizen', 1, 'gemeente-huizen', 52.29664000, 5.24132000),
(1077843, 1002612, 'NL', 'Gemeente Koggenland', 1, 'gemeente-koggenland', 52.64163000, 4.94909000),
(1077847, 1002612, 'NL', 'Gemeente Landsmeer', 1, 'gemeente-landsmeer', 52.43100000, 4.91570000),
(1077848, 1002612, 'NL', 'Gemeente Langedijk', 1, 'gemeente-langedijk', 52.69151000, 4.78659000),
(1077850, 1002612, 'NL', 'Gemeente Laren', 1, 'gemeente-laren', 52.24518000, 5.21701000),
(1077869, 1002612, 'NL', 'Gemeente Medemblik', 1, 'gemeente-medemblik', 52.72496000, 5.12204000),
(1077901, 1002612, 'NL', 'Gemeente Oostzaan', 1, 'gemeente-oostzaan', 52.43780000, 4.87604000),
(1077902, 1002612, 'NL', 'Gemeente Opmeer', 1, 'gemeente-opmeer', 52.71468000, 4.95334000),
(1077905, 1002612, 'NL', 'Gemeente Ouder-Amstel', 1, 'gemeente-ouder-amstel', 52.30659000, 4.91432000),
(1077912, 1002612, 'NL', 'Gemeente Purmerend', 1, 'gemeente-purmerend', 52.50515000, 4.95243000),
(1077929, 1002612, 'NL', 'Gemeente Schagen', 1, 'gemeente-schagen', 52.78823000, 4.79965000),
(1077945, 1002612, 'NL', 'Gemeente Stede Broec', 1, 'gemeente-stede-broec', 52.69617000, 5.22389000),
(1077951, 1002612, 'NL', 'Gemeente Texel', 1, 'gemeente-texel', 53.07883000, 4.81166000),
(1077961, 1002612, 'NL', 'Gemeente Uitgeest', 1, 'gemeente-uitgeest', 52.52855000, 4.71176000),
(1077962, 1002612, 'NL', 'Gemeente Uithoorn', 1, 'gemeente-uithoorn', 52.23999000, 4.83072000),
(1077972, 1002612, 'NL', 'Gemeente Velsen', 1, 'gemeente-velsen', 52.45182000, 4.63211000),
(1077987, 1002612, 'NL', 'Gemeente Waterland', 1, 'gemeente-waterland', 52.43760000, 5.01371000),
(1077989, 1002612, 'NL', 'Gemeente Weesp', 1, 'gemeente-weesp', 52.30575000, 5.04152000),
(1077998, 1002612, 'NL', 'Gemeente Wijdemeren', 1, 'gemeente-wijdemeren', 52.22756000, 5.08445000),
(1078003, 1002612, 'NL', 'Gemeente Wormerland', 1, 'gemeente-wormerland', 52.49700000, 4.83364000),
(1078005, 1002612, 'NL', 'Gemeente Zaanstad', 1, 'gemeente-zaanstad', 52.45308000, 4.81253000),
(1078007, 1002612, 'NL', 'Gemeente Zandvoort', 1, 'gemeente-zandvoort', 52.35769000, 4.54388000),
(1078039, 1002612, 'NL', 'Gooise Meren', 1, 'gooise-meren', 52.29735000, 5.13371000),
(1078081, 1002612, 'NL', 'Haarlem', 1, 'haarlem', 52.38084000, 4.63683000),
(1078085, 1002612, 'NL', 'Halfweg', 1, 'halfweg', 52.38250000, 4.75417000),
(1078094, 1002612, 'NL', 'Harenkarspel', 1, 'harenkarspel', 52.73416000, 4.77682000),
(1078110, 1002612, 'NL', 'Heemskerk', 1, 'heemskerk', 52.51108000, 4.67165000),
(1078111, 1002612, 'NL', 'Heemstede', 1, 'heemstede', 52.34992000, 4.62301000),
(1078116, 1002612, 'NL', 'Heerhugowaard', 1, 'heerhugowaard', 52.67144000, 4.84862000),
(1078130, 1002612, 'NL', 'Heiloo', 1, 'heiloo', 52.60252000, 4.68815000),
(1078138, 1002612, 'NL', 'Hem', 1, 'hem', 52.66083000, 5.18333000),
(1078144, 1002612, 'NL', 'Hensbroek', 1, 'hensbroek', 52.65833000, 4.88472000),
(1078159, 1002612, 'NL', 'Hilversum', 1, 'hilversum', 52.22333000, 5.17639000),
(1078160, 1002612, 'NL', 'Hilversumse Meent', 1, 'hilversumse-meent', 52.27115000, 5.13729000),
(1078161, 1002612, 'NL', 'Hippolytushoef', 1, 'hippolytushoef', 52.90750000, 4.96250000),
(1078166, 1002612, 'NL', 'Hofgeest', 1, 'hofgeest', 52.44333000, 4.65833000),
(1078175, 1002612, 'NL', 'Hoofddorp', 1, 'hoofddorp', 52.30250000, 4.68889000),
(1078185, 1002612, 'NL', 'Hoogwoud', 1, 'hoogwoud', 52.71583000, 4.93889000),
(1078186, 1002612, 'NL', 'Hoorn', 1, 'hoorn', 52.64250000, 5.05972000),
(1078192, 1002612, 'NL', 'Huizen', 1, 'huizen', 52.29917000, 5.24167000),
(1078203, 1002612, 'NL', 'Ilpendam', 1, 'ilpendam', 52.46333000, 4.95000000),
(1078210, 1002612, 'NL', 'Kadoelen', 1, 'kadoelen', 52.41750000, 4.90561000),
(1078227, 1002612, 'NL', 'Kerkelanden', 1, 'kerkelanden', 52.21755000, 5.13575000),
(1078251, 1002612, 'NL', 'Kortenhoef', 1, 'kortenhoef', 52.23917000, 5.10694000),
(1078261, 1002612, 'NL', 'Kudelstaart', 1, 'kudelstaart', 52.23417000, 4.75139000),
(1078268, 1002612, 'NL', 'Landsmeer', 1, 'landsmeer', 52.43083000, 4.91528000),
(1078269, 1002612, 'NL', 'Langeheit', 1, 'langeheit', 52.49200000, 4.75849000),
(1078274, 1002612, 'NL', 'Laren', 1, 'laren', 52.25667000, 5.22778000),
(1078307, 1002612, 'NL', 'Limmen', 1, 'limmen', 52.56917000, 4.69444000),
(1078313, 1002612, 'NL', 'Lisserbroek', 1, 'lisserbroek', 52.25667000, 4.57222000),
(1078328, 1002612, 'NL', 'Lutjebroek', 1, 'lutjebroek', 52.69750000, 5.20417000),
(1078352, 1002612, 'NL', 'Marken', 1, 'marken', 52.45833000, 5.10278000),
(1078365, 1002612, 'NL', 'Medemblik', 1, 'medemblik', 52.77167000, 5.10556000),
(1078394, 1002612, 'NL', 'Middenbeemster', 1, 'middenbeemster', 52.54917000, 4.91250000),
(1078395, 1002612, 'NL', 'Middenmeer', 1, 'middenmeer', 52.80667000, 4.99861000),
(1078397, 1002612, 'NL', 'Midwoud', 1, 'midwoud', 52.71667000, 5.07500000),
(1078407, 1002612, 'NL', 'Monnickendam', 1, 'monnickendam', 52.45833000, 5.03750000),
(1078412, 1002612, 'NL', 'Muiden', 1, 'muiden', 52.33000000, 5.06944000),
(1078413, 1002612, 'NL', 'Muiderberg', 1, 'muiderberg', 52.32583000, 5.12083000),
(1078417, 1002612, 'NL', 'Naarden', 1, 'naarden', 52.29583000, 5.16250000),
(1078434, 1002612, 'NL', 'Nieuw-Loosdrecht', 1, 'nieuw-loosdrecht', 52.19917000, 5.13889000),
(1078440, 1002612, 'NL', 'Nieuwe-Niedorp', 1, 'nieuwe-niedorp', 52.74000000, 4.89861000),
(1078462, 1002612, 'NL', 'Noord-Scharwoude', 1, 'noord-scharwoude', 52.69833000, 4.81111000),
(1078479, 1002612, 'NL', 'Obdam', 1, 'obdam', 52.67583000, 4.90694000),
(1078502, 1002612, 'NL', 'Onderdijk', 1, 'onderdijk', 52.74333000, 5.13750000),
(1078511, 1002612, 'NL', 'Oosteinde', 1, 'oosteinde', 52.27917000, 4.79583000),
(1078515, 1002612, 'NL', 'Oosterblokker', 1, 'oosterblokker', 52.66917000, 5.11806000),
(1078525, 1002612, 'NL', 'Oosterzij', 1, 'oosterzij', 52.58500000, 4.70556000),
(1078526, 1002612, 'NL', 'Oosthuizen', 1, 'oosthuizen', 52.57250000, 4.99583000),
(1078538, 1002612, 'NL', 'Opmeer', 1, 'opmeer', 52.70667000, 4.94444000),
(1078540, 1002612, 'NL', 'Opperdoes', 1, 'opperdoes', 52.75915000, 5.07534000),
(1078554, 1002612, 'NL', 'Oud-Loosdrecht', 1, 'oud-loosdrecht', 52.20667000, 5.08056000),
(1078563, 1002612, 'NL', 'Ouderkerk aan de Amstel', 1, 'ouderkerk-aan-de-amstel', 52.29504000, 4.90746000),
(1078565, 1002612, 'NL', 'Oudeschild', 1, 'oudeschild', 53.03917000, 4.84722000),
(1078568, 1002612, 'NL', 'Oudkarspel', 1, 'oudkarspel', 52.71583000, 4.80556000),
(1078574, 1002612, 'NL', 'Overveen', 1, 'overveen', 52.39167000, 4.61389000),
(1078588, 1002612, 'NL', 'Petten', 1, 'petten', 52.76667000, 4.66111000),
(1078599, 1002612, 'NL', 'Purmerend', 1, 'purmerend', 52.50500000, 4.95972000),
(1078655, 1002612, 'NL', 'Schagen', 1, 'schagen', 52.78750000, 4.79861000),
(1078656, 1002612, 'NL', 'Schagerbrug', 1, 'schagerbrug', 52.80250000, 4.75833000),
(1078664, 1002612, 'NL', 'Schermerhorn', 1, 'schermerhorn', 52.60083000, 4.89167000),
(1078702, 1002612, 'NL', 'Sint Pancras', 1, 'sint-pancras', 52.66000000, 4.78333000),
(1078713, 1002612, 'NL', 'Slootdorp', 1, 'slootdorp', 52.84250000, 4.97222000),
(1078731, 1002612, 'NL', 'Spierdijk', 1, 'spierdijk', 52.65083000, 4.94306000),
(1078761, 1002612, 'NL', 'Stompetoren', 1, 'stompetoren', 52.61333000, 4.82083000),
(1078801, 1002612, 'NL', 'Twisk', 1, 'twisk', 52.74083000, 5.05278000),
(1078811, 1002612, 'NL', 'Uitgeest', 1, 'uitgeest', 52.52917000, 4.70972000),
(1078812, 1002612, 'NL', 'Uithoorn', 1, 'uithoorn', 52.23750000, 4.82639000),
(1078843, 1002612, 'NL', 'Velsen-Zuid', 1, 'velsen-zuid', 52.46000000, 4.65000000),
(1078851, 1002612, 'NL', 'Vijfhuizen', 1, 'vijfhuizen', 52.35083000, 4.67778000),
(1078866, 1002612, 'NL', 'Vogelenzang', 1, 'vogelenzang', 52.31917000, 4.57778000),
(1078870, 1002612, 'NL', 'Volendam', 1, 'volendam', 52.49500000, 5.07083000),
(1078896, 1002612, 'NL', 'Waarland', 1, 'waarland', 52.72667000, 4.83194000),
(1078910, 1002612, 'NL', 'Waterakkers', 1, 'waterakkers', 52.50440000, 4.65608000),
(1078915, 1002612, 'NL', 'Weesp', 1, 'weesp', 52.30750000, 5.04167000),
(1078945, 1002612, 'NL', 'Westwoud', 1, 'westwoud', 52.68500000, 5.13472000),
(1078947, 1002612, 'NL', 'Wieringerwaard', 1, 'wieringerwaard', 52.83583000, 4.86528000),
(1078948, 1002612, 'NL', 'Wieringerwerf', 1, 'wieringerwerf', 52.85083000, 5.02639000),
(1078951, 1002612, 'NL', 'Wijdenes', 1, 'wijdenes', 52.63500000, 5.15694000),
(1078953, 1002612, 'NL', 'Wijk aan Zee', 1, 'wijk-aan-zee', 52.49360000, 4.59409000),
(1078961, 1002612, 'NL', 'Winkel', 1, 'winkel', 52.75417000, 4.90278000),
(1078993, 1002612, 'NL', 'Zaandam', 1, 'zaandam', 52.43854000, 4.82643000),
(1078994, 1002612, 'NL', 'Zaandijk', 1, 'zaandijk', 52.47494000, 4.80686000),
(1078995, 1002612, 'NL', 'Zaanstad', 1, 'zaanstad', 52.45313000, 4.81356000),
(1078998, 1002612, 'NL', 'Zandvoort', 1, 'zandvoort', 52.37125000, 4.53306000),
(1079024, 1002612, 'NL', 'Zuid-Scharwoude', 1, 'zuid-scharwoude', 52.68667000, 4.80833000),
(1079033, 1002612, 'NL', 'Zwaagdijk-Oost', 1, 'zwaagdijk-oost', 52.70750000, 5.14028000),
(1079034, 1002612, 'NL', 'Zwaanshoek', 1, 'zwaanshoek', 52.31250000, 4.61667000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002618, 'NL', 'Overijssel', 1, 'overijssel');

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 
(1077326, 1002618, 'NL', 'Almelo', 1, 'almelo', 52.35667000, 6.66250000),
(1077363, 1002618, 'NL', 'Baalder', 1, 'baalder', 52.58579000, 6.65299000),
(1077418, 1002618, 'NL', 'Berkum', 1, 'berkum', 52.52395000, 6.13655000),
(1077446, 1002618, 'NL', 'Blokzijl', 1, 'blokzijl', 52.72667000, 5.96111000),
(1077455, 1002618, 'NL', 'Borgele', 1, 'borgele', 52.27630000, 6.14926000),
(1077459, 1002618, 'NL', 'Borne', 1, 'borne', 52.30136000, 6.74820000),
(1077462, 1002618, 'NL', 'Boskamp', 1, 'boskamp', 52.33083000, 6.12778000),
(1077494, 1002618, 'NL', 'Brunnepe', 1, 'brunnepe', 52.56185000, 5.90343000),
(1077529, 1002618, 'NL', 'Dalfsen', 1, 'dalfsen', 52.51167000, 6.25694000),
(1077546, 1002618, 'NL', 'De Hoven', 1, 'de-hoven', 52.24901000, 6.14367000),
(1077566, 1002618, 'NL', 'Delden', 1, 'delden', 52.26000000, 6.71111000),
(1077572, 1002618, 'NL', 'Den Ham', 1, 'den-ham', 52.46583000, 6.49583000),
(1077576, 1002618, 'NL', 'Deventer', 1, 'deventer', 52.25500000, 6.16389000),
(1077578, 1002618, 'NL', 'Diepenheim', 1, 'diepenheim', 52.20000000, 6.55556000),
(1077662, 1002618, 'NL', 'Enschede', 1, 'enschede', 52.21833000, 6.89583000),
(1077677, 1002618, 'NL', 'Flevowijk', 1, 'flevowijk', 52.54583000, 5.91338000),
(1077679, 1002618, 'NL', 'Frankhuis', 1, 'frankhuis', 52.52500000, 6.06806000),
(1077703, 1002618, 'NL', 'Gemeente Almelo', 1, 'gemeente-almelo', 52.34463000, 6.65942000),
(1077736, 1002618, 'NL', 'Gemeente Borne', 1, 'gemeente-borne', 52.31120000, 6.74404000),
(1077754, 1002618, 'NL', 'Gemeente Dalfsen', 1, 'gemeente-dalfsen', 52.52461000, 6.27214000),
(1077764, 1002618, 'NL', 'Gemeente Deventer', 1, 'gemeente-deventer', 52.26927000, 6.23795000),
(1077766, 1002618, 'NL', 'Gemeente Dinkelland', 1, 'gemeente-dinkelland', 52.37108000, 6.89294000),
(1077785, 1002618, 'NL', 'Gemeente Enschede', 1, 'gemeente-enschede', 52.21909000, 6.88041000),
(1077801, 1002618, 'NL', 'Gemeente Haaksbergen', 1, 'gemeente-haaksbergen', 52.15514000, 6.75404000),
(1077806, 1002618, 'NL', 'Gemeente Hardenberg', 1, 'gemeente-hardenberg', 52.59312000, 6.53476000),
(1077819, 1002618, 'NL', 'Gemeente Hellendoorn', 1, 'gemeente-hellendoorn', 52.39022000, 6.46434000),
(1077823, 1002618, 'NL', 'Gemeente Hengelo', 1, 'gemeente-hengelo', 52.25910000, 6.77876000),
(1077829, 1002618, 'NL', 'Gemeente Hof van Twente', 1, 'gemeente-hof-van-twente', 52.24341000, 6.59749000),
(1077839, 1002618, 'NL', 'Gemeente Kampen', 1, 'gemeente-kampen', 52.56181000, 5.91535000),
(1077864, 1002618, 'NL', 'Gemeente Losser', 1, 'gemeente-losser', 52.29819000, 7.00106000),
(1077896, 1002618, 'NL', 'Gemeente Oldenzaal', 1, 'gemeente-oldenzaal', 52.30750000, 6.90750000),
(1077897, 1002618, 'NL', 'Gemeente Olst-Wijhe', 1, 'gemeente-olst-wijhe', 52.35734000, 6.13481000),
(1077898, 1002618, 'NL', 'Gemeente Ommen', 1, 'gemeente-ommen', 52.51659000, 6.45631000),
(1077914, 1002618, 'NL', 'Gemeente Raalte', 1, 'gemeente-raalte', 52.40299000, 6.28773000),
(1077922, 1002618, 'NL', 'Gemeente Rijssen-Holten', 1, 'gemeente-rijssen-holten', 52.29000000, 6.42515000),
(1077944, 1002618, 'NL', 'Gemeente Staphorst', 1, 'gemeente-staphorst', 52.63241000, 6.20737000),
(1077947, 1002618, 'NL', 'Gemeente Steenwijkerland', 1, 'gemeente-steenwijkerland', 52.75587000, 6.04028000),
(1077956, 1002618, 'NL', 'Gemeente Tubbergen', 1, 'gemeente-tubbergen', 52.40451000, 6.78241000),
(1077957, 1002618, 'NL', 'Gemeente Twenterand', 1, 'gemeente-twenterand', 52.44974000, 6.56122000),
(1077996, 1002618, 'NL', 'Gemeente Wierden', 1, 'gemeente-wierden', 52.34247000, 6.55795000),
(1078016, 1002618, 'NL', 'Gemeente Zwartewaterland', 1, 'gemeente-zwartewaterland', 52.60240000, 6.07402000),
(1078018, 1002618, 'NL', 'Gemeente Zwolle', 1, 'gemeente-zwolle', 52.51264000, 6.09359000),
(1078032, 1002618, 'NL', 'Giethoorn', 1, 'giethoorn', 52.74000000, 6.07917000),
(1078040, 1002618, 'NL', 'Goor', 1, 'goor', 52.23333000, 6.58611000),
(1078050, 1002618, 'NL', 'Grafhorst', 1, 'grafhorst', 52.58250000, 5.93333000),
(1078075, 1002618, 'NL', 'Haaksbergen', 1, 'haaksbergen', 52.15667000, 6.73889000),
(1078080, 1002618, 'NL', 'Haarle', 1, 'haarle', 52.35917000, 6.38056000),
(1078091, 1002618, 'NL', 'Hardenberg', 1, 'hardenberg', 52.57583000, 6.61944000),
(1078099, 1002618, 'NL', 'Hasselt', 1, 'hasselt', 52.59267000, 6.09527000),
(1078131, 1002618, 'NL', 'Heino', 1, 'heino', 52.43661000, 6.23282000),
(1078140, 1002618, 'NL', 'Hengelo', 1, 'hengelo', 52.26583000, 6.79306000),
(1078142, 1002618, 'NL', 'Hengevelde', 1, 'hengevelde', 52.19917000, 6.63611000),
(1078150, 1002618, 'NL', 'Het Oostrik', 1, 'het-oostrik', 52.25000000, 6.21667000),
(1078213, 1002618, 'NL', 'Kampen', 1, 'kampen', 52.55500000, 5.91111000),
(1078236, 1002618, 'NL', 'Klein Driene', 1, 'klein-driene', 52.26935000, 6.81613000),
(1078323, 1002618, 'NL', 'Losser', 1, 'losser', 52.26083000, 7.00417000),
(1078342, 1002618, 'NL', 'Magele', 1, 'magele', 52.46917000, 6.52083000),
(1078351, 1002618, 'NL', 'Markelo', 1, 'markelo', 52.23500000, 6.49861000),
(1078375, 1002618, 'NL', 'Mekkelholt', 1, 'mekkelholt', 52.23645000, 6.89058000),
(1078448, 1002618, 'NL', 'Nieuwoord', 1, 'nieuwoord', 52.46667000, 6.55000000),
(1078456, 1002618, 'NL', 'Nijrees', 1, 'nijrees', 52.33500000, 6.66389000),
(1078496, 1002618, 'NL', 'Oldemarkt', 1, 'oldemarkt', 52.82083000, 5.97500000),
(1078497, 1002618, 'NL', 'Oldenzaal', 1, 'oldenzaal', 52.31333000, 6.92917000),
(1078498, 1002618, 'NL', 'Olst', 1, 'olst', 52.33750000, 6.10972000),
(1078500, 1002618, 'NL', 'Ommen', 1, 'ommen', 52.52083000, 6.42083000),
(1078517, 1002618, 'NL', 'Oosterholt', 1, 'oosterholt', 52.55917000, 5.95556000),
(1078522, 1002618, 'NL', 'Oostermeenthe', 1, 'oostermeenthe', 52.79319000, 6.13138000),
(1078530, 1002618, 'NL', 'Ootmarsum', 1, 'ootmarsum', 52.40833000, 6.90139000),
(1078582, 1002618, 'NL', 'Pathmos', 1, 'pathmos', 52.21397000, 6.87555000),
(1078589, 1002618, 'NL', 'Pierik', 1, 'pierik', 52.50141000, 6.11170000),
(1078604, 1002618, 'NL', 'Raalte', 1, 'raalte', 52.38583000, 6.27500000),
(1078640, 1002618, 'NL', 'Rossum', 1, 'rossum', 52.35167000, 6.92222000),
(1078658, 1002618, 'NL', 'Schalkhaar', 1, 'schalkhaar', 52.26833000, 6.19444000),
(1078697, 1002618, 'NL', 'Sint Jansklooster', 1, 'sint-jansklooster', 52.67750000, 6.00556000),
(1078745, 1002618, 'NL', 'Staphorst', 1, 'staphorst', 52.64500000, 6.21111000),
(1078751, 1002618, 'NL', 'Steenwijk', 1, 'steenwijk', 52.78750000, 6.12083000),
(1078752, 1002618, 'NL', 'Steenwijkerwold', 1, 'steenwijkerwold', 52.80417000, 6.06389000),
(1078792, 1002618, 'NL', 'Tubbergen', 1, 'tubbergen', 52.40750000, 6.78472000),
(1078795, 1002618, 'NL', 'Tuk', 1, 'tuk', 52.79667000, 6.09444000),
(1078797, 1002618, 'NL', 'Twekkelerveld', 1, 'twekkelerveld', 52.23064000, 6.86004000),
(1078872, 1002618, 'NL', 'Vollenhove', 1, 'vollenhove', 52.68083000, 5.95417000),
(1078886, 1002618, 'NL', 'Vriezenveen', 1, 'vriezenveen', 52.40833000, 6.62222000),
(1078887, 1002618, 'NL', 'Vroomshoop', 1, 'vroomshoop', 52.46083000, 6.56528000),
(1078936, 1002618, 'NL', 'Westerhaar-Vriezenveensewijk', 1, 'westerhaar-vriezenveensewijk', 52.45583000, 6.62361000),
(1078946, 1002618, 'NL', 'Wierden', 1, 'wierden', 52.35917000, 6.59306000),
(1078952, 1002618, 'NL', 'Wijhe', 1, 'wijhe', 52.38667000, 6.13472000),
(1078980, 1002618, 'NL', 'Woolde', 1, 'woolde', 52.27210000, 6.75891000),
(1078981, 1002618, 'NL', 'Wooldrik', 1, 'wooldrik', 52.21667000, 6.91667000),
(1079023, 1002618, 'NL', 'Zuid-Berghuizen', 1, 'zuid-berghuizen', 52.30083000, 6.93333000),
(1079036, 1002618, 'NL', 'Zwolle', 1, 'zwolle', 52.51250000, 6.09444000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002621, 'NL', 'Saba', 1, 'saba');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002616, 'NL', 'Sint Eustatius', 1, 'sint-eustatius');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002614, 'NL', 'South Holland', 1, 'south-holland');

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 
(1077298, 1002614, 'NL', '\'s-Gravenland', 1, 's-gravenland', 51.92336000, 4.55315000),
(1077299, 1002614, 'NL', '\'s-Gravenzande', 1, 's-gravenzande', 52.00167000, 4.16528000),
(1077317, 1002614, 'NL', 'Adegeest', 1, 'adegeest', 52.13621000, 4.45249000),
(1077322, 1002614, 'NL', 'Alblasserdam', 1, 'alblasserdam', 51.86583000, 4.66111000),
(1077330, 1002614, 'NL', 'Alphen aan den Rijn', 1, 'alphen-aan-den-rijn', 52.12917000, 4.65546000),
(1077336, 1002614, 'NL', 'Ammerstol', 1, 'ammerstol', 51.92750000, 4.80833000),
(1077354, 1002614, 'NL', 'Arkel', 1, 'arkel', 51.86417000, 4.99444000),
(1077379, 1002614, 'NL', 'Barendrecht', 1, 'barendrecht', 51.85667000, 4.53472000),
(1077403, 1002614, 'NL', 'Benthuizen', 1, 'benthuizen', 52.07750000, 4.54444000),
(1077411, 1002614, 'NL', 'Bergschenhoek', 1, 'bergschenhoek', 51.99000000, 4.49861000),
(1077412, 1002614, 'NL', 'Bergstoep', 1, 'bergstoep', 51.92250000, 4.78472000),
(1077414, 1002614, 'NL', 'Berkel en Rodenrijs', 1, 'berkel-en-rodenrijs', 51.99313000, 4.47865000),
(1077416, 1002614, 'NL', 'Berkenwoude', 1, 'berkenwoude', 51.94500000, 4.70694000),
(1077432, 1002614, 'NL', 'Binnenhof', 1, 'binnenhof', 52.16418000, 4.53644000),
(1077439, 1002614, 'NL', 'Bleiswijk', 1, 'bleiswijk', 52.01083000, 4.53194000),
(1077440, 1002614, 'NL', 'Bleskensgraaf', 1, 'bleskensgraaf', 51.87250000, 4.78333000),
(1077444, 1002614, 'NL', 'Bloemendaal', 1, 'bloemendaal', 52.02878000, 4.69440000),
(1077445, 1002614, 'NL', 'Bloemhof', 1, 'bloemhof', 51.89723000, 4.49943000),
(1077448, 1002614, 'NL', 'Bodegraven', 1, 'bodegraven', 52.08250000, 4.75000000),
(1077449, 1002614, 'NL', 'Bodegraven-Reeuwijk', 1, 'bodegraven-reeuwijk', 52.06541000, 4.76634000),
(1077451, 1002614, 'NL', 'Bolnes', 1, 'bolnes', 51.89500000, 4.57917000),
(1077463, 1002614, 'NL', 'Boskoop', 1, 'boskoop', 52.07500000, 4.65556000),
(1077465, 1002614, 'NL', 'Boven-Hardinxveld', 1, 'boven-hardinxveld', 51.82333000, 4.88194000),
(1077480, 1002614, 'NL', 'Brielle', 1, 'brielle', 51.90167000, 4.16250000),
(1077511, 1002614, 'NL', 'Capelle aan den IJssel', 1, 'capelle-aan-den-ijssel', 51.92917000, 4.57778000),
(1077512, 1002614, 'NL', 'Capelle-West', 1, 'capelle-west', 51.91667000, 4.56667000),
(1077513, 1002614, 'NL', 'Carnisse', 1, 'carnisse', 51.88932000, 4.47758000),
(1077547, 1002614, 'NL', 'De Kieviet', 1, 'de-kieviet', 52.12333000, 4.35839000),
(1077551, 1002614, 'NL', 'De Lier', 1, 'de-lier', 51.97500000, 4.24861000),
(1077556, 1002614, 'NL', 'De Peulen', 1, 'de-peulen', 51.82362000, 4.82165000),
(1077567, 1002614, 'NL', 'Delfshaven', 1, 'delfshaven', 51.90488000, 4.45315000),
(1077568, 1002614, 'NL', 'Delft', 1, 'delft', 52.00667000, 4.35556000),
(1077584, 1002614, 'NL', 'Dirksland', 1, 'dirksland', 51.74917000, 4.10000000),
(1077600, 1002614, 'NL', 'Dordrecht', 1, 'dordrecht', 51.81000000, 4.67361000),
(1077605, 1002614, 'NL', 'Driebruggen', 1, 'driebruggen', 52.04417000, 4.80000000),
(1077608, 1002614, 'NL', 'Driemanspolder', 1, 'driemanspolder', 52.05176000, 4.48504000),
(1077615, 1002614, 'NL', 'Duindorp', 1, 'duindorp', 52.09078000, 4.26038000),
(1077616, 1002614, 'NL', 'Duinzigt', 1, 'duinzigt', 52.10485000, 4.32494000),
(1077669, 1002614, 'NL', 'Essesteijn', 1, 'essesteijn', 52.08534000, 4.37263000),
(1077674, 1002614, 'NL', 'Feijenoord', 1, 'feijenoord', 51.91169000, 4.50645000),
(1077700, 1002614, 'NL', 'Gemeente Alblasserdam', 1, 'gemeente-alblasserdam', 51.85985000, 4.66321000),
(1077701, 1002614, 'NL', 'Gemeente Albrandswaard', 1, 'gemeente-albrandswaard', 51.85792000, 4.40833000),
(1077705, 1002614, 'NL', 'Gemeente Alphen aan den Rijn', 1, 'gemeente-alphen-aan-den-rijn', 52.12974000, 4.68892000),
(1077718, 1002614, 'NL', 'Gemeente Barendrecht', 1, 'gemeente-barendrecht', 51.84974000, 4.52540000),
(1077741, 1002614, 'NL', 'Gemeente Brielle', 1, 'gemeente-brielle', 51.88819000, 4.18481000),
(1077748, 1002614, 'NL', 'Gemeente Capelle aan den IJssel', 1, 'gemeente-capelle-aan-den-ijssel', 51.93567000, 4.57819000),
(1077759, 1002614, 'NL', 'Gemeente Delft', 1, 'gemeente-delft', 51.99968000, 4.36405000),
(1077761, 1002614, 'NL', 'Gemeente Den Haag', 1, 'gemeente-den-haag', 52.06866000, 4.28635000),
(1077770, 1002614, 'NL', 'Gemeente Dordrecht', 1, 'gemeente-dordrecht', 51.79901000, 4.74159000),
(1077794, 1002614, 'NL', 'Gemeente Goeree-Overflakkee', 1, 'gemeente-goeree-overflakkee', 51.75351000, 4.11264000),
(1077797, 1002614, 'NL', 'Gemeente Gorinchem', 1, 'gemeente-gorinchem', 51.83873000, 4.97713000),
(1077798, 1002614, 'NL', 'Gemeente Gouda', 1, 'gemeente-gouda', 52.01917000, 4.70790000),
(1077808, 1002614, 'NL', 'Gemeente Hardinxveld-Giessendam', 1, 'gemeente-hardinxveld-giessendam', 51.82594000, 4.86428000),
(1077820, 1002614, 'NL', 'Gemeente Hellevoetsluis', 1, 'gemeente-hellevoetsluis', 51.83333000, 4.13333000),
(1077822, 1002614, 'NL', 'Gemeente Hendrik-Ido-Ambacht', 1, 'gemeente-hendrik-ido-ambacht', 51.84273000, 4.63975000),
(1077826, 1002614, 'NL', 'Gemeente Hillegom', 1, 'gemeente-hillegom', 52.29616000, 4.57822000),
(1077838, 1002614, 'NL', 'Gemeente Kaag en Braassem', 1, 'gemeente-kaag-en-braassem', 52.19393000, 4.65516000),
(1077841, 1002614, 'NL', 'Gemeente Katwijk', 1, 'gemeente-katwijk', 52.19029000, 4.42129000),
(1077844, 1002614, 'NL', 'Gemeente Krimpen aan den IJssel', 1, 'gemeente-krimpen-aan-den-ijssel', 51.91458000, 4.58819000),
(1077849, 1002614, 'NL', 'Gemeente Lansingerland', 1, 'gemeente-lansingerland', 52.00389000, 4.51088000),
(1077852, 1002614, 'NL', 'Gemeente Leiden', 1, 'gemeente-leiden', 52.15274000, 4.48360000),
(1077853, 1002614, 'NL', 'Gemeente Leiderdorp', 1, 'gemeente-leiderdorp', 52.15707000, 4.54318000),
(1077854, 1002614, 'NL', 'Gemeente Leidschendam-Voorburg', 1, 'gemeente-leidschendam-voorburg', 52.07833000, 4.40139000),
(1077859, 1002614, 'NL', 'Gemeente Lisse', 1, 'gemeente-lisse', 52.25601000, 4.54526000),
(1077867, 1002614, 'NL', 'Gemeente Maassluis', 1, 'gemeente-maassluis', 51.92332000, 4.24722000),
(1077873, 1002614, 'NL', 'Gemeente Midden-Delfland', 1, 'gemeente-midden-delfland', 51.96528000, 4.30525000),
(1077883, 1002614, 'NL', 'Gemeente Nieuwkoop', 1, 'gemeente-nieuwkoop', 52.17198000, 4.78006000),
(1077889, 1002614, 'NL', 'Gemeente Noordwijk', 1, 'gemeente-noordwijk', 52.26953000, 4.46354000),
(1077892, 1002614, 'NL', 'Gemeente Oegstgeest', 1, 'gemeente-oegstgeest', 52.18256000, 4.46676000),
(1077908, 1002614, 'NL', 'Gemeente Papendrecht', 1, 'gemeente-papendrecht', 51.83175000, 4.69125000),
(1077911, 1002614, 'NL', 'Gemeente Pijnacker-Nootdorp', 1, 'gemeente-pijnacker-nootdorp', 52.02615000, 4.41944000),
(1077921, 1002614, 'NL', 'Gemeente Ridderkerk', 1, 'gemeente-ridderkerk', 51.86969000, 4.59785000),
(1077923, 1002614, 'NL', 'Gemeente Rijswijk', 1, 'gemeente-rijswijk', 52.03490000, 4.32785000),
(1077926, 1002614, 'NL', 'Gemeente Rotterdam', 1, 'gemeente-rotterdam', 51.88246000, 4.28784000),
(1077931, 1002614, 'NL', 'Gemeente Schiedam', 1, 'gemeente-schiedam', 51.92650000, 4.38675000),
(1077937, 1002614, 'NL', 'Gemeente Sliedrecht', 1, 'gemeente-sliedrecht', 51.82999000, 4.77191000),
(1077952, 1002614, 'NL', 'Gemeente Teylingen', 1, 'gemeente-teylingen', 52.21556000, 4.50648000),
(1077975, 1002614, 'NL', 'Gemeente Vlaardingen', 1, 'gemeente-vlaardingen', 51.91754000, 4.32570000),
(1077979, 1002614, 'NL', 'Gemeente Voorschoten', 1, 'gemeente-voorschoten', 52.12533000, 4.44014000),
(1077984, 1002614, 'NL', 'Gemeente Waddinxveen', 1, 'gemeente-waddinxveen', 52.04247000, 4.64486000),
(1077986, 1002614, 'NL', 'Gemeente Wassenaar', 1, 'gemeente-wassenaar', 52.13791000, 4.37546000),
(1077993, 1002614, 'NL', 'Gemeente Westland', 1, 'gemeente-westland', 51.99671000, 4.22729000),
(1077995, 1002614, 'NL', 'Gemeente Westvoorne', 1, 'gemeente-westvoorne', 51.89308000, 4.08922000),
(1078011, 1002614, 'NL', 'Gemeente Zoetermeer', 1, 'gemeente-zoetermeer', 52.05954000, 4.48832000),
(1078012, 1002614, 'NL', 'Gemeente Zoeterwoude', 1, 'gemeente-zoeterwoude', 52.11410000, 4.51142000),
(1078013, 1002614, 'NL', 'Gemeente Zuidplas', 1, 'gemeente-zuidplas', 52.01574000, 4.61048000),
(1078017, 1002614, 'NL', 'Gemeente Zwijndrecht', 1, 'gemeente-zwijndrecht', 51.82399000, 4.61258000),
(1078029, 1002614, 'NL', 'Giessenburg', 1, 'giessenburg', 51.85083000, 4.89028000),
(1078030, 1002614, 'NL', 'Giessendam', 1, 'giessendam', 51.83257000, 4.83583000),
(1078036, 1002614, 'NL', 'Goedereede', 1, 'goedereede', 51.81750000, 3.98056000),
(1078041, 1002614, 'NL', 'Gorinchem', 1, 'gorinchem', 51.83652000, 4.97243000),
(1078044, 1002614, 'NL', 'Gouda', 1, 'gouda', 52.01667000, 4.70833000),
(1078045, 1002614, 'NL', 'Gouderak', 1, 'gouderak', 51.98417000, 4.67778000),
(1078046, 1002614, 'NL', 'Goudswaard', 1, 'goudswaard', 51.79417000, 4.27639000),
(1078048, 1002614, 'NL', 'Gouwsluis', 1, 'gouwsluis', 52.11943000, 4.66899000),
(1078060, 1002614, 'NL', 'Groenswaard', 1, 'groenswaard', 52.05154000, 4.64541000),
(1078065, 1002614, 'NL', 'Groot IJsselmonde', 1, 'groot-ijsselmonde', 51.88264000, 4.54937000),
(1078066, 1002614, 'NL', 'Groot-Ammers', 1, 'groot-ammers', 51.92333000, 4.82361000),
(1078083, 1002614, 'NL', 'Haastrecht', 1, 'haastrecht', 52.00074000, 4.77639000),
(1078117, 1002614, 'NL', 'Heerjansdam', 1, 'heerjansdam', 51.83583000, 4.56389000),
(1078128, 1002614, 'NL', 'Heijplaat', 1, 'heijplaat', 51.89333000, 4.42083000),
(1078134, 1002614, 'NL', 'Hellevoetsluis', 1, 'hellevoetsluis', 51.83333000, 4.13333000),
(1078139, 1002614, 'NL', 'Hendrik-Ido-Ambacht', 1, 'hendrik-ido-ambacht', 51.84417000, 4.63889000),
(1078157, 1002614, 'NL', 'Hillegom', 1, 'hillegom', 52.29083000, 4.58333000),
(1078163, 1002614, 'NL', 'Hoek van Holland', 1, 'hoek-van-holland', 51.97750000, 4.13333000),
(1078167, 1002614, 'NL', 'Hoge Mors', 1, 'hoge-mors', 52.15616000, 4.46025000),
(1078174, 1002614, 'NL', 'Honselersdijk', 1, 'honselersdijk', 52.00665000, 4.22441000),
(1078176, 1002614, 'NL', 'Hoogblokland', 1, 'hoogblokland', 51.87500000, 4.97639000),
(1078184, 1002614, 'NL', 'Hoogmade', 1, 'hoogmade', 52.16917000, 4.58194000),
(1078216, 1002614, 'NL', 'Katendrecht', 1, 'katendrecht', 51.90074000, 4.48254000),
(1078218, 1002614, 'NL', 'Katwijk aan den Rijn', 1, 'katwijk-aan-den-rijn', 52.19417000, 4.42222000),
(1078217, 1002614, 'NL', 'Katwijk aan Zee', 1, 'katwijk-aan-zee', 52.20333000, 4.39861000),
(1078226, 1002614, 'NL', 'Kerkehout', 1, 'kerkehout', 52.11018000, 4.37957000),
(1078232, 1002614, 'NL', 'Kijkduin', 1, 'kijkduin', 52.06765000, 4.22188000),
(1078233, 1002614, 'NL', 'Klaaswaal', 1, 'klaaswaal', 51.77000000, 4.44583000),
(1078249, 1002614, 'NL', 'Kop van Zuid', 1, 'kop-van-zuid', 51.90553000, 4.48706000),
(1078256, 1002614, 'NL', 'Krimpen aan den IJssel', 1, 'krimpen-aan-den-ijssel', 51.91667000, 4.60278000),
(1078257, 1002614, 'NL', 'Krimpenerwaard', 1, 'krimpenerwaard', 51.98171000, 4.77828000),
(1078263, 1002614, 'NL', 'Kwintsheul', 1, 'kwintsheul', 52.01333000, 4.25556000),
(1078285, 1002614, 'NL', 'Leiden', 1, 'leiden', 52.15833000, 4.49306000),
(1078286, 1002614, 'NL', 'Leiderdorp', 1, 'leiderdorp', 52.15833000, 4.52917000),
(1078287, 1002614, 'NL', 'Leimuiden', 1, 'leimuiden', 52.22417000, 4.66944000),
(1078303, 1002614, 'NL', 'Liesveld', 1, 'liesveld', 51.93250000, 4.83194000),
(1078312, 1002614, 'NL', 'Lisse', 1, 'lisse', 52.26000000, 4.55694000),
(1078318, 1002614, 'NL', 'Lombardijen', 1, 'lombardijen', 51.87380000, 4.52192000),
(1078336, 1002614, 'NL', 'Maasdijk', 1, 'maasdijk', 51.95917000, 4.21389000),
(1078338, 1002614, 'NL', 'Maasland', 1, 'maasland', 51.93417000, 4.27222000),
(1078339, 1002614, 'NL', 'Maassluis', 1, 'maassluis', 51.92333000, 4.25000000),
(1078382, 1002614, 'NL', 'Merenwijk', 1, 'merenwijk', 52.17655000, 4.50885000),
(1078389, 1002614, 'NL', 'Middelharnis', 1, 'middelharnis', 51.75750000, 4.16528000),
(1078391, 1002614, 'NL', 'Middelsluis', 1, 'middelsluis', 51.74250000, 4.44167000),
(1078400, 1002614, 'NL', 'Mijnsheerenland', 1, 'mijnsheerenland', 51.79667000, 4.48750000),
(1078408, 1002614, 'NL', 'Monster', 1, 'monster', 52.02583000, 4.17500000),
(1078416, 1002614, 'NL', 'Naaldwijk', 1, 'naaldwijk', 51.99417000, 4.20972000),
(1078419, 1002614, 'NL', 'Neder-Hardinxveld', 1, 'neder-hardinxveld', 51.82879000, 4.85489000),
(1078430, 1002614, 'NL', 'Nieuw-Beijerland', 1, 'nieuw-beijerland', 51.81250000, 4.34306000),
(1078433, 1002614, 'NL', 'Nieuw-Lekkerland', 1, 'nieuw-lekkerland', 51.88915000, 4.68653000),
(1078443, 1002614, 'NL', 'Nieuwenhoorn', 1, 'nieuwenhoorn', 51.85417000, 4.14306000),
(1078445, 1002614, 'NL', 'Nieuwkoop', 1, 'nieuwkoop', 52.15083000, 4.77639000),
(1078449, 1002614, 'NL', 'Nieuwpoort', 1, 'nieuwpoort', 51.93583000, 4.86806000),
(1078450, 1002614, 'NL', 'Nieuwveen', 1, 'nieuwveen', 52.19667000, 4.75694000),
(1078458, 1002614, 'NL', 'Nissewaard', 1, 'nissewaard', 51.83716000, 4.27540000),
(1078461, 1002614, 'NL', 'Noord-Hofland', 1, 'noord-hofland', 52.14059000, 4.45864000),
(1078465, 1002614, 'NL', 'Noordeinde', 1, 'noordeinde', 52.01667000, 4.48333000),
(1078466, 1002614, 'NL', 'Noordeloos', 1, 'noordeloos', 51.90333000, 4.94167000),
(1078470, 1002614, 'NL', 'Noordwijk-Binnen', 1, 'noordwijk-binnen', 52.23400000, 4.44474000),
(1078471, 1002614, 'NL', 'Noordwijkerhout', 1, 'noordwijkerhout', 52.26167000, 4.49306000),
(1078475, 1002614, 'NL', 'Numansdorp', 1, 'numansdorp', 51.73167000, 4.43750000),
(1078485, 1002614, 'NL', 'Oegstgeest', 1, 'oegstgeest', 52.18000000, 4.46944000),
(1078501, 1002614, 'NL', 'Ommoord', 1, 'ommoord', 51.95951000, 4.54533000),
(1078509, 1002614, 'NL', 'Oostdorp', 1, 'oostdorp', 52.14994000, 4.39319000),
(1078529, 1002614, 'NL', 'Oostvoorne', 1, 'oostvoorne', 51.91250000, 4.09861000),
(1078541, 1002614, 'NL', 'Oranjewijk', 1, 'oranjewijk', 52.04922000, 4.65374000),
(1078552, 1002614, 'NL', 'Oud-Beijerland', 1, 'oud-beijerland', 51.82417000, 4.41250000),
(1078556, 1002614, 'NL', 'Ouddorp', 1, 'ouddorp', 51.81167000, 3.93472000),
(1078559, 1002614, 'NL', 'Oude Wetering', 1, 'oude-wetering', 52.21417000, 4.64444000),
(1078564, 1002614, 'NL', 'Ouderkerk aan den IJssel', 1, 'ouderkerk-aan-den-ijssel', 51.93417000, 4.63611000),
(1078573, 1002614, 'NL', 'Overschie', 1, 'overschie', 51.93863000, 4.42766000),
(1078575, 1002614, 'NL', 'Palenstein', 1, 'palenstein', 52.05579000, 4.50869000),
(1078578, 1002614, 'NL', 'Papendrecht', 1, 'papendrecht', 51.83167000, 4.68750000),
(1078579, 1002614, 'NL', 'Papenveer', 1, 'papenveer', 52.18500000, 4.72500000),
(1078586, 1002614, 'NL', 'Pendrecht', 1, 'pendrecht', 51.87152000, 4.46901000),
(1078587, 1002614, 'NL', 'Pernis', 1, 'pernis', 51.88833000, 4.38889000),
(1078590, 1002614, 'NL', 'Piershil', 1, 'piershil', 51.79333000, 4.31389000),
(1078591, 1002614, 'NL', 'Pijnacker', 1, 'pijnacker', 52.01954000, 4.42946000),
(1078592, 1002614, 'NL', 'Poeldijk', 1, 'poeldijk', 52.02417000, 4.21944000),
(1078611, 1002614, 'NL', 'Reeuwijk', 1, 'reeuwijk', 52.04667000, 4.72500000),
(1078620, 1002614, 'NL', 'Rhoon', 1, 'rhoon', 51.85750000, 4.42222000),
(1078621, 1002614, 'NL', 'Ridderkerk', 1, 'ridderkerk', 51.87250000, 4.60278000),
(1078624, 1002614, 'NL', 'Rijnsaterwoude', 1, 'rijnsaterwoude', 52.19583000, 4.67083000),
(1078625, 1002614, 'NL', 'Rijnsburg', 1, 'rijnsburg', 52.19000000, 4.44167000),
(1078626, 1002614, 'NL', 'Rijpwetering', 1, 'rijpwetering', 52.19250000, 4.58333000),
(1078628, 1002614, 'NL', 'Rijsoord', 1, 'rijsoord', 51.85083000, 4.59583000),
(1078630, 1002614, 'NL', 'Rijswijk', 1, 'rijswijk', 52.03634000, 4.32501000),
(1078632, 1002614, 'NL', 'Rockanje', 1, 'rockanje', 51.87167000, 4.07083000),
(1078634, 1002614, 'NL', 'Roelofarendsveen', 1, 'roelofarendsveen', 52.20333000, 4.63333000),
(1078642, 1002614, 'NL', 'Rotterdam', 1, 'rotterdam', 51.92250000, 4.47917000),
(1078644, 1002614, 'NL', 'Rozenburg', 1, 'rozenburg', 51.90417000, 4.24861000),
(1078647, 1002614, 'NL', 'Rugge', 1, 'rugge', 51.89921000, 4.15231000),
(1078654, 1002614, 'NL', 'Sassenheim', 1, 'sassenheim', 52.22500000, 4.52222000),
(1078663, 1002614, 'NL', 'Schelluinen', 1, 'schelluinen', 51.84333000, 4.92639000),
(1078667, 1002614, 'NL', 'Scheveningen', 1, 'scheveningen', 52.10461000, 4.27557000),
(1078668, 1002614, 'NL', 'Schiebroek', 1, 'schiebroek', 51.95838000, 4.47124000),
(1078669, 1002614, 'NL', 'Schiedam', 1, 'schiedam', 51.91917000, 4.38889000),
(1078677, 1002614, 'NL', 'Schipluiden', 1, 'schipluiden', 51.97583000, 4.31389000),
(1078680, 1002614, 'NL', 'Schoonhoven', 1, 'schoonhoven', 51.94750000, 4.84861000),
(1078710, 1002614, 'NL', 'Sliedrecht', 1, 'sliedrecht', 51.82083000, 4.77639000),
(1078711, 1002614, 'NL', 'Slikkerveer', 1, 'slikkerveer', 51.88531000, 4.60494000),
(1078726, 1002614, 'NL', 'Spangen', 1, 'spangen', 51.91688000, 4.43539000),
(1078733, 1002614, 'NL', 'Spijkenisse', 1, 'spijkenisse', 51.84500000, 4.32917000),
(1078734, 1002614, 'NL', 'Spoorwijk', 1, 'spoorwijk', 52.05347000, 4.31339000),
(1078746, 1002614, 'NL', 'Statenkwartier', 1, 'statenkwartier', 52.09311000, 4.27577000),
(1078755, 1002614, 'NL', 'Stein', 1, 'stein', 52.00333000, 4.78194000),
(1078760, 1002614, 'NL', 'Stolwijk', 1, 'stolwijk', 51.97250000, 4.77361000),
(1078763, 1002614, 'NL', 'Strijen', 1, 'strijen', 51.74521000, 4.55083000),
(1078764, 1002614, 'NL', 'Strijp', 1, 'strijp', 52.03083000, 4.30139000),
(1078771, 1002614, 'NL', 'Terbregge', 1, 'terbregge', 51.95328000, 4.51537000),
(1078779, 1002614, 'NL', 'The Hague', 1, 'the-hague', 52.07667000, 4.29861000),
(1078794, 1002614, 'NL', 'Tuindorp', 1, 'tuindorp', 51.93032000, 4.37840000),
(1078828, 1002614, 'NL', 'Valkenburg', 1, 'valkenburg', 52.18000000, 4.43194000),
(1078850, 1002614, 'NL', 'Vierpolders', 1, 'vierpolders', 51.87917000, 4.17917000),
(1078855, 1002614, 'NL', 'Vlaardingen', 1, 'vlaardingen', 51.91250000, 4.34167000),
(1078861, 1002614, 'NL', 'Vlietwijk', 1, 'vlietwijk', 52.12436000, 4.45736000),
(1078868, 1002614, 'NL', 'Vogelwijk', 1, 'vogelwijk', 52.07631000, 4.24790000),
(1078873, 1002614, 'NL', 'Vondelwijk', 1, 'vondelwijk', 52.05497000, 4.65314000),
(1078874, 1002614, 'NL', 'Voorburg', 1, 'voorburg', 52.07417000, 4.35972000),
(1078875, 1002614, 'NL', 'Voorhout', 1, 'voorhout', 52.22167000, 4.48472000),
(1078876, 1002614, 'NL', 'Voorschoten', 1, 'voorschoten', 52.12750000, 4.44861000),
(1078883, 1002614, 'NL', 'Vreewijk', 1, 'vreewijk', 51.88428000, 4.51967000),
(1078895, 1002614, 'NL', 'Waarder', 1, 'waarder', 52.06083000, 4.82083000),
(1078897, 1002614, 'NL', 'Waddinxveen', 1, 'waddinxveen', 52.04500000, 4.65139000),
(1078906, 1002614, 'NL', 'Warmond', 1, 'warmond', 52.19667000, 4.50278000),
(1078909, 1002614, 'NL', 'Wassenaar', 1, 'wassenaar', 52.14583000, 4.40278000),
(1078913, 1002614, 'NL', 'Weerestein', 1, 'weerestein', 52.30381000, 4.58861000),
(1078916, 1002614, 'NL', 'Weijpoort', 1, 'weijpoort', 52.08167000, 4.80278000),
(1078944, 1002614, 'NL', 'Westmaas', 1, 'westmaas', 51.78667000, 4.47500000),
(1078983, 1002614, 'NL', 'Woubrugge', 1, 'woubrugge', 52.17000000, 4.63611000),
(1078990, 1002614, 'NL', 'Ypenburg', 1, 'ypenburg', 52.04098000, 4.36981000),
(1079011, 1002614, 'NL', 'Zevenhoven', 1, 'zevenhoven', 52.18167000, 4.77917000),
(1079016, 1002614, 'NL', 'Zoetermeer', 1, 'zoetermeer', 52.05750000, 4.49306000),
(1079017, 1002614, 'NL', 'Zoeterwoude-Dorp', 1, 'zoeterwoude-dorp', 52.12000000, 4.49583000),
(1079022, 1002614, 'NL', 'Zuid-Beijerland', 1, 'zuid-beijerland', 51.75083000, 4.36806000),
(1079029, 1002614, 'NL', 'Zuidwijk', 1, 'zuidwijk', 51.87532000, 4.48514000),
(1079035, 1002614, 'NL', 'Zwijndrecht', 1, 'zwijndrecht', 51.81750000, 4.63333000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002610, 'NL', 'Utrecht', 1, 'utrecht');

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 
(1077314, 1002610, 'NL', 'Abcoude', 1, 'abcoude', 52.27250000, 4.96944000),
(1077334, 1002610, 'NL', 'Amerongen', 1, 'amerongen', 52.00250000, 5.45972000),
(1077335, 1002610, 'NL', 'Amersfoort', 1, 'amersfoort', 52.15500000, 5.38750000),
(1077360, 1002610, 'NL', 'Austerlitz', 1, 'austerlitz', 52.08000000, 5.31528000),
(1077364, 1002610, 'NL', 'Baambrugge', 1, 'baambrugge', 52.24583000, 4.98889000),
(1077368, 1002610, 'NL', 'Baarn', 1, 'baarn', 52.21167000, 5.28750000),
(1077461, 1002610, 'NL', 'Bosch en Duin', 1, 'bosch-en-duin', 52.11667000, 5.24167000),
(1077479, 1002610, 'NL', 'Breukelen', 1, 'breukelen', 52.17417000, 5.00139000),
(1077503, 1002610, 'NL', 'Bunnik', 1, 'bunnik', 52.06667000, 5.19861000),
(1077504, 1002610, 'NL', 'Bunschoten', 1, 'bunschoten', 52.24304000, 5.37884000),
(1077524, 1002610, 'NL', 'Cothen', 1, 'cothen', 51.99667000, 5.30833000),
(1077532, 1002610, 'NL', 'De Bilt', 1, 'de-bilt', 52.11000000, 5.18056000),
(1077542, 1002610, 'NL', 'De Hagen', 1, 'de-hagen', 51.99381000, 5.10263000),
(1077560, 1002610, 'NL', 'De Uithof', 1, 'de-uithof', 52.08526000, 5.17456000),
(1077595, 1002610, 'NL', 'Doorn', 1, 'doorn', 52.03343000, 5.34571000),
(1077604, 1002610, 'NL', 'Driebergen-Rijsenburg', 1, 'driebergen-rijsenburg', 52.05333000, 5.28056000),
(1077708, 1002610, 'NL', 'Gemeente Amersfoort', 1, 'gemeente-amersfoort', 52.17375000, 5.38954000),
(1077717, 1002610, 'NL', 'Gemeente Baarn', 1, 'gemeente-baarn', 52.20602000, 5.27144000),
(1077745, 1002610, 'NL', 'Gemeente Bunnik', 1, 'gemeente-bunnik', 52.04228000, 5.21664000),
(1077746, 1002610, 'NL', 'Gemeente Bunschoten', 1, 'gemeente-bunschoten', 52.24249000, 5.35837000),
(1077756, 1002610, 'NL', 'Gemeente De Bilt', 1, 'gemeente-de-bilt', 52.14137000, 5.16828000),
(1077757, 1002610, 'NL', 'Gemeente De Ronde Venen', 1, 'gemeente-de-ronde-venen', 52.21515000, 4.90123000),
(1077779, 1002610, 'NL', 'Gemeente Eemnes', 1, 'gemeente-eemnes', 52.25253000, 5.28391000),
(1077834, 1002610, 'NL', 'Gemeente Houten', 1, 'gemeente-houten', 52.02683000, 5.16941000),
(1077837, 1002610, 'NL', 'Gemeente IJsselstein', 1, 'gemeente-ijsselstein', 52.02912000, 5.02868000),
(1077857, 1002610, 'NL', 'Gemeente Leusden', 1, 'gemeente-leusden', 52.12418000, 5.41245000),
(1077862, 1002610, 'NL', 'Gemeente Lopik', 1, 'gemeente-lopik', 51.98991000, 4.94851000),
(1077878, 1002610, 'NL', 'Gemeente Montfoort', 1, 'gemeente-montfoort', 52.04767000, 4.94844000),
(1077882, 1002610, 'NL', 'Gemeente Nieuwegein', 1, 'gemeente-nieuwegein', 52.02843000, 5.09539000),
(1077906, 1002610, 'NL', 'Gemeente Oudewater', 1, 'gemeente-oudewater', 52.02840000, 4.86243000),
(1077917, 1002610, 'NL', 'Gemeente Renswoude', 1, 'gemeente-renswoude', 52.07294000, 5.53352000),
(1077920, 1002610, 'NL', 'Gemeente Rhenen', 1, 'gemeente-rhenen', 51.96151000, 5.57058000),
(1077940, 1002610, 'NL', 'Gemeente Soest', 1, 'gemeente-soest', 52.15636000, 5.29854000),
(1077964, 1002610, 'NL', 'Gemeente Utrecht', 1, 'gemeente-utrecht', 52.09675000, 5.03708000),
(1077965, 1002610, 'NL', 'Gemeente Utrechtse Heuvelrug', 1, 'gemeente-utrechtse-heuvelrug', 52.03486000, 5.35738000),
(1077969, 1002610, 'NL', 'Gemeente Veenendaal', 1, 'gemeente-veenendaal', 52.02459000, 5.55562000),
(1077999, 1002610, 'NL', 'Gemeente Wijk bij Duurstede', 1, 'gemeente-wijk-bij-duurstede', 51.97452000, 5.33661000),
(1078002, 1002610, 'NL', 'Gemeente Woerden', 1, 'gemeente-woerden', 52.10675000, 4.90066000),
(1078004, 1002610, 'NL', 'Gemeente Woudenberg', 1, 'gemeente-woudenberg', 52.08055000, 5.39810000),
(1078009, 1002610, 'NL', 'Gemeente Zeist', 1, 'gemeente-zeist', 52.08847000, 5.23275000),
(1078058, 1002610, 'NL', 'Groenekan', 1, 'groenekan', 52.12333000, 5.15278000),
(1078169, 1002610, 'NL', 'Hollandsche Rading', 1, 'hollandsche-rading', 52.17500000, 5.17778000),
(1078189, 1002610, 'NL', 'Houten', 1, 'houten', 52.02833000, 5.16806000),
(1078201, 1002610, 'NL', 'IJsselstein', 1, 'ijsselstein', 52.02000000, 5.04306000),
(1078219, 1002610, 'NL', 'Kedichem', 1, 'kedichem', 51.86000000, 5.05000000),
(1078223, 1002610, 'NL', 'Kerckebosch', 1, 'kerckebosch', 52.07844000, 5.26584000),
(1078271, 1002610, 'NL', 'Langenoord', 1, 'langenoord', 52.18768000, 5.38034000),
(1078279, 1002610, 'NL', 'Leerdam', 1, 'leerdam', 51.89333000, 5.09167000),
(1078280, 1002610, 'NL', 'Leersum', 1, 'leersum', 52.01167000, 5.42778000),
(1078294, 1002610, 'NL', 'Leusden', 1, 'leusden', 52.13250000, 5.43194000),
(1078311, 1002610, 'NL', 'Linschoten', 1, 'linschoten', 52.06250000, 4.91528000),
(1078321, 1002610, 'NL', 'Lopik', 1, 'lopik', 51.97250000, 4.94861000),
(1078326, 1002610, 'NL', 'Lunetten', 1, 'lunetten', 52.06178000, 5.13474000),
(1078331, 1002610, 'NL', 'Maarn', 1, 'maarn', 52.06417000, 5.37083000),
(1078332, 1002610, 'NL', 'Maarssen', 1, 'maarssen', 52.13917000, 5.04167000),
(1078333, 1002610, 'NL', 'Maartensdijk', 1, 'maartensdijk', 52.15500000, 5.17500000),
(1078399, 1002610, 'NL', 'Mijdrecht', 1, 'mijdrecht', 52.20667000, 4.86250000),
(1078409, 1002610, 'NL', 'Montfoort', 1, 'montfoort', 52.04583000, 4.95278000),
(1078441, 1002610, 'NL', 'Nieuwegein', 1, 'nieuwegein', 52.02917000, 5.08056000),
(1078451, 1002610, 'NL', 'Nijenheim', 1, 'nijenheim', 52.08689000, 5.21852000),
(1078482, 1002610, 'NL', 'Odijk', 1, 'odijk', 52.05250000, 5.23611000),
(1078504, 1002610, 'NL', 'Oog in Al', 1, 'oog-in-al', 52.08636000, 5.08470000),
(1078567, 1002610, 'NL', 'Oudewater', 1, 'oudewater', 52.02500000, 4.86806000),
(1078570, 1002610, 'NL', 'Overberg', 1, 'overberg', 52.04000000, 5.49444000),
(1078608, 1002610, 'NL', 'Randenbroek', 1, 'randenbroek', 52.14863000, 5.40120000),
(1078615, 1002610, 'NL', 'Renswoude', 1, 'renswoude', 52.07333000, 5.54028000),
(1078619, 1002610, 'NL', 'Rhenen', 1, 'rhenen', 51.95917000, 5.56806000),
(1078682, 1002610, 'NL', 'Schoonrewoerd', 1, 'schoonrewoerd', 51.92083000, 5.11667000),
(1078719, 1002610, 'NL', 'Soest', 1, 'soest', 52.17333000, 5.29167000),
(1078720, 1002610, 'NL', 'Soestdijk', 1, 'soestdijk', 52.19083000, 5.28472000),
(1078725, 1002610, 'NL', 'Spakenburg', 1, 'spakenburg', 52.25000000, 5.36667000),
(1078728, 1002610, 'NL', 'Spechtenkamp', 1, 'spechtenkamp', 52.13926000, 5.01758000),
(1078758, 1002610, 'NL', 'Stichtse Vecht', 1, 'stichtse-vecht', 52.17679000, 5.01259000),
(1078822, 1002610, 'NL', 'Utrecht', 1, 'utrecht', 52.09083000, 5.12222000),
(1078837, 1002610, 'NL', 'Veenendaal', 1, 'veenendaal', 52.02863000, 5.55891000),
(1078841, 1002610, 'NL', 'Veldhuizen', 1, 'veldhuizen', 52.07537000, 5.01234000),
(1078849, 1002610, 'NL', 'Vianen', 1, 'vianen', 51.99250000, 5.09167000),
(1078854, 1002610, 'NL', 'Vinkeveen', 1, 'vinkeveen', 52.21507000, 4.93372000),
(1078858, 1002610, 'NL', 'Vleuten', 1, 'vleuten', 52.10583000, 5.01528000),
(1078882, 1002610, 'NL', 'Vreeswijk', 1, 'vreeswijk', 52.01088000, 5.09285000),
(1078925, 1002610, 'NL', 'Werkhoven', 1, 'werkhoven', 52.02500000, 5.24444000),
(1078954, 1002610, 'NL', 'Wijk bij Duurstede', 1, 'wijk-bij-duurstede', 51.97417000, 5.34167000),
(1078960, 1002610, 'NL', 'Wilnis', 1, 'wilnis', 52.19667000, 4.89722000),
(1078973, 1002610, 'NL', 'Woerden', 1, 'woerden', 52.08500000, 4.88333000),
(1078984, 1002610, 'NL', 'Woudenberg', 1, 'woudenberg', 52.08083000, 5.41667000),
(1079005, 1002610, 'NL', 'Zeist', 1, 'zeist', 52.09000000, 5.23333000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002620, 'NL', 'Zeeland', 1, 'zeeland');

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 
(1077304, 1002620, 'NL', 'Aagtekerke', 1, 'aagtekerke', 51.54667000, 3.50972000),
(1077311, 1002620, 'NL', 'Aardenburg', 1, 'aardenburg', 51.27333000, 3.44722000),
(1077355, 1002620, 'NL', 'Arnemuiden', 1, 'arnemuiden', 51.50167000, 3.67500000),
(1077362, 1002620, 'NL', 'Axel', 1, 'axel', 51.26667000, 3.90833000),
(1077460, 1002620, 'NL', 'Borssele', 1, 'borssele', 51.42333000, 3.73472000),
(1077477, 1002620, 'NL', 'Breskens', 1, 'breskens', 51.39583000, 3.55556000),
(1077488, 1002620, 'NL', 'Brouwershaven', 1, 'brouwershaven', 51.72667000, 3.91250000),
(1077490, 1002620, 'NL', 'Bruinisse', 1, 'bruinisse', 51.66167000, 4.09444000),
(1077520, 1002620, 'NL', 'Colijnsplaat', 1, 'colijnsplaat', 51.59917000, 3.84861000),
(1077531, 1002620, 'NL', 'Dauwendaele', 1, 'dauwendaele', 51.49299000, 3.62624000),
(1077589, 1002620, 'NL', 'Domburg', 1, 'domburg', 51.56333000, 3.49583000),
(1077737, 1002620, 'NL', 'Gemeente Borsele', 1, 'gemeente-borsele', 51.44191000, 3.81127000),
(1077795, 1002620, 'NL', 'Gemeente Goes', 1, 'gemeente-goes', 51.51500000, 3.83949000),
(1077836, 1002620, 'NL', 'Gemeente Hulst', 1, 'gemeente-hulst', 51.31897000, 4.08690000),
(1077840, 1002620, 'NL', 'Gemeente Kapelle', 1, 'gemeente-kapelle', 51.48223000, 3.96524000),
(1077872, 1002620, 'NL', 'Gemeente Middelburg', 1, 'gemeente-middelburg', 51.49719000, 3.65459000),
(1077886, 1002620, 'NL', 'Gemeente Noord-Beveland', 1, 'gemeente-noord-beveland', 51.57226000, 3.78353000),
(1077915, 1002620, 'NL', 'Gemeente Reimerswaal', 1, 'gemeente-reimerswaal', 51.42040000, 4.13169000),
(1077938, 1002620, 'NL', 'Gemeente Sluis', 1, 'gemeente-sluis', 51.33490000, 3.51974000),
(1077949, 1002620, 'NL', 'Gemeente Terneuzen', 1, 'gemeente-terneuzen', 51.28550000, 3.82817000),
(1077953, 1002620, 'NL', 'Gemeente Tholen', 1, 'gemeente-tholen', 51.58336000, 4.13373000),
(1077970, 1002620, 'NL', 'Gemeente Veere', 1, 'gemeente-veere', 51.53902000, 3.55688000),
(1077977, 1002620, 'NL', 'Gemeente Vlissingen', 1, 'gemeente-vlissingen', 51.45914000, 3.62325000),
(1078037, 1002620, 'NL', 'Goes', 1, 'goes', 51.50417000, 3.88889000),
(1078055, 1002620, 'NL', 'Griffioen', 1, 'griffioen', 51.50548000, 3.59598000),
(1078057, 1002620, 'NL', 'Grijpskerke', 1, 'grijpskerke', 51.53417000, 3.56111000),
(1078077, 1002620, 'NL', 'Haamstede', 1, 'haamstede', 51.69682000, 3.74299000),
(1078195, 1002620, 'NL', 'Hulst', 1, 'hulst', 51.28000000, 4.05278000),
(1078202, 1002620, 'NL', 'IJzendijke', 1, 'ijzendijke', 51.32167000, 3.61667000),
(1078214, 1002620, 'NL', 'Kamperland', 1, 'kamperland', 51.57167000, 3.70417000),
(1078215, 1002620, 'NL', 'Kapelle', 1, 'kapelle', 51.48627000, 3.95804000),
(1078234, 1002620, 'NL', 'Klarenbeek', 1, 'klarenbeek', 51.50964000, 3.61132000),
(1078239, 1002620, 'NL', 'Kloetinge', 1, 'kloetinge', 51.49833000, 3.91528000),
(1078242, 1002620, 'NL', 'Koewacht', 1, 'koewacht', 51.22833000, 3.97361000),
(1078253, 1002620, 'NL', 'Koudekerke', 1, 'koudekerke', 51.48167000, 3.55417000),
(1078266, 1002620, 'NL', 'Lammerenburg', 1, 'lammerenburg', 51.46667000, 3.55833000),
(1078346, 1002620, 'NL', 'Malta', 1, 'malta', 51.65000000, 3.93333000),
(1078378, 1002620, 'NL', 'Meliskerke', 1, 'meliskerke', 51.51417000, 3.50972000),
(1078388, 1002620, 'NL', 'Middelburg', 1, 'middelburg', 51.50000000, 3.61389000),
(1078429, 1002620, 'NL', 'Nieuw- en Sint Joosland', 1, 'nieuw-en-sint-joosland', 51.48333000, 3.65694000),
(1078444, 1002620, 'NL', 'Nieuwerkerk', 1, 'nieuwerkerk', 51.65083000, 4.00139000),
(1078508, 1002620, 'NL', 'Oostburg', 1, 'oostburg', 51.32583000, 3.48750000),
(1078521, 1002620, 'NL', 'Oosterland', 1, 'oosterland', 51.65000000, 4.03611000),
(1078527, 1002620, 'NL', 'Oostkapelle', 1, 'oostkapelle', 51.56667000, 3.55139000),
(1078548, 1002620, 'NL', 'Othene', 1, 'othene', 51.33083000, 3.85972000),
(1078555, 1002620, 'NL', 'Oud-Vossemeer', 1, 'oud-vossemeer', 51.57083000, 4.19861000),
(1078593, 1002620, 'NL', 'Poortvliet', 1, 'poortvliet', 51.54417000, 4.14306000),
(1078613, 1002620, 'NL', 'Renesse', 1, 'renesse', 51.73250000, 3.77500000),
(1078653, 1002620, 'NL', 'Sas van Gent', 1, 'sas-van-gent', 51.22750000, 3.79861000),
(1078659, 1002620, 'NL', 'Scharendijke', 1, 'scharendijke', 51.73583000, 3.84306000),
(1078665, 1002620, 'NL', 'Scherpenisse', 1, 'scherpenisse', 51.54667000, 4.10556000),
(1078678, 1002620, 'NL', 'Schoondijke', 1, 'schoondijke', 51.35417000, 3.55556000),
(1078683, 1002620, 'NL', 'Schouwen-Duiveland', 1, 'schouwen-duiveland', 51.69294000, 3.88676000),
(1078687, 1002620, 'NL', 'Serooskerke', 1, 'serooskerke', 51.54833000, 3.59444000),
(1078699, 1002620, 'NL', 'Sint Laurens', 1, 'sint-laurens', 51.52750000, 3.60278000),
(1078703, 1002620, 'NL', 'Sint Philipsland', 1, 'sint-philipsland', 51.61667000, 4.16528000),
(1078714, 1002620, 'NL', 'Sluis', 1, 'sluis', 51.30833000, 3.38611000),
(1078715, 1002620, 'NL', 'Sluiskil', 1, 'sluiskil', 51.27833000, 3.83611000),
(1078747, 1002620, 'NL', 'Stavenisse', 1, 'stavenisse', 51.58750000, 4.01250000),
(1078774, 1002620, 'NL', 'Terneuzen', 1, 'terneuzen', 51.33583000, 3.82778000),
(1078781, 1002620, 'NL', 'Tholen', 1, 'tholen', 51.53167000, 4.22083000),
(1078862, 1002620, 'NL', 'Vlissingen', 1, 'vlissingen', 51.44250000, 3.57361000),
(1078893, 1002620, 'NL', 'Waarde', 1, 'waarde', 51.41750000, 4.06806000),
(1078923, 1002620, 'NL', 'Wemeldinge', 1, 'wemeldinge', 51.51833000, 3.99722000),
(1078929, 1002620, 'NL', 'West-Souburg', 1, 'west-souburg', 51.46417000, 3.59167000),
(1078931, 1002620, 'NL', 'Westdorpe', 1, 'westdorpe', 51.23250000, 3.82639000),
(1078941, 1002620, 'NL', 'Westerzicht', 1, 'westerzicht', 51.46252000, 3.58687000),
(1078942, 1002620, 'NL', 'Westkapelle', 1, 'westkapelle', 51.52917000, 3.44028000),
(1078969, 1002620, 'NL', 'Wissenkerke', 1, 'wissenkerke', 51.58500000, 3.74722000),
(1078977, 1002620, 'NL', 'Wolphaartsdijk', 1, 'wolphaartsdijk', 51.53167000, 3.81944000),
(1078989, 1002620, 'NL', 'Yerseke', 1, 'yerseke', 51.49250000, 4.05000000),
(1078992, 1002620, 'NL', 'Zaamslag', 1, 'zaamslag', 51.31250000, 3.91250000),
(1079013, 1002620, 'NL', 'Zierikzee', 1, 'zierikzee', 51.65000000, 3.91944000),
(1079020, 1002620, 'NL', 'Zoutelande', 1, 'zoutelande', 51.50167000, 3.48472000);

