REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('DK', 'Denmark', 'denmark', '45', 'Danmark', 'DKK');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001530, 'DK', 'Capital Region of Denmark', 1, 'capital-region-of-denmark');

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 
(1030990, 1001530, 'DK', 'Åkirkeby', 1, 'akirkeby', 55.07080000, 14.91978000),
(1030577, 1001530, 'DK', 'Albertslund', 1, 'albertslund', 55.65691000, 12.36381000),
(1030578, 1001530, 'DK', 'Albertslund Kommune', 1, 'albertslund-kommune', 55.68022000, 12.34797000),
(1030579, 1001530, 'DK', 'Allerød Kommune', 1, 'allerod-kommune', 55.85856000, 12.32558000),
(1030589, 1001530, 'DK', 'Ballerup', 1, 'ballerup', 55.73165000, 12.36328000),
(1030590, 1001530, 'DK', 'Ballerup Kommune', 1, 'ballerup-kommune', 55.73248000, 12.35793000),
(1030595, 1001530, 'DK', 'Birkerød', 1, 'birkerod', 55.84759000, 12.42791000),
(1030598, 1001530, 'DK', 'Blovstrød', 1, 'blovstrod', 55.87038000, 12.38640000),
(1030601, 1001530, 'DK', 'Bornholm Kommune', 1, 'bornholm-kommune', 55.12386000, 14.91115000),
(1030610, 1001530, 'DK', 'Brøndby Kommune', 1, 'brondby-kommune', 55.64290000, 12.41101000),
(1030616, 1001530, 'DK', 'Charlottenlund', 1, 'charlottenlund', 55.75238000, 12.57450000),
(1030618, 1001530, 'DK', 'Christianshavn', 1, 'christianshavn', 55.67383000, 12.59541000),
(1030619, 1001530, 'DK', 'Christiansø', 1, 'christianso', 55.31982000, 15.18783000),
(1030620, 1001530, 'DK', 'Copenhagen', 1, 'copenhagen', 55.67594000, 12.56553000),
(1030622, 1001530, 'DK', 'Dragør', 1, 'dragor', 55.59280000, 12.67221000),
(1030623, 1001530, 'DK', 'Dragør Kommune', 1, 'dragor-kommune', 55.58233000, 12.62756000),
(1030627, 1001530, 'DK', 'Egedal Kommune', 1, 'egedal-kommune', 55.75556000, 12.22778000),
(1030633, 1001530, 'DK', 'Espergærde', 1, 'espergaerde', 55.99464000, 12.54733000),
(1030638, 1001530, 'DK', 'Farum', 1, 'farum', 55.80858000, 12.36066000),
(1030645, 1001530, 'DK', 'Fløng', 1, 'flong', 55.66212000, 12.18698000),
(1030648, 1001530, 'DK', 'Fredensborg', 1, 'fredensborg', 55.97558000, 12.40314000),
(1030649, 1001530, 'DK', 'Fredensborg Kommune', 1, 'fredensborg-kommune', 55.95000000, 12.45000000),
(1030652, 1001530, 'DK', 'Frederiksberg', 1, 'frederiksberg', 55.67938000, 12.53463000),
(1030654, 1001530, 'DK', 'Frederiksberg Kommune', 1, 'frederiksberg-kommune', 55.67856000, 12.52216000),
(1030657, 1001530, 'DK', 'Frederikssund', 1, 'frederikssund', 55.83956000, 12.06896000),
(1030658, 1001530, 'DK', 'Frederikssund Kommune', 1, 'frederikssund-kommune', 55.80957000, 12.04038000),
(1030659, 1001530, 'DK', 'Frederiksværk', 1, 'frederiksvaerk', 55.97073000, 12.02250000),
(1030662, 1001530, 'DK', 'Furesø Kommune', 1, 'fureso-kommune', 55.78333000, 12.34167000),
(1030664, 1001530, 'DK', 'Ganløse', 1, 'ganlose', 55.79124000, 12.26421000),
(1030665, 1001530, 'DK', 'Gentofte Kommune', 1, 'gentofte-kommune', 55.75000000, 12.55000000),
(1030666, 1001530, 'DK', 'Gilleleje', 1, 'gilleleje', 56.12196000, 12.31056000),
(1030670, 1001530, 'DK', 'Gladsaxe Municipality', 1, 'gladsaxe-municipality', 55.76667000, 12.43333000),
(1030672, 1001530, 'DK', 'Glostrup', 1, 'glostrup', 55.66660000, 12.40377000),
(1030673, 1001530, 'DK', 'Glostrup Kommune', 1, 'glostrup-kommune', 55.68188000, 12.41018000),
(1030681, 1001530, 'DK', 'Græsted', 1, 'graested', 56.06558000, 12.28512000),
(1030678, 1001530, 'DK', 'Gribskov Kommune', 1, 'gribskov-kommune', 56.05833000, 12.24167000),
(1030691, 1001530, 'DK', 'Halsnæs Kommune', 1, 'halsnaes-kommune', 55.96765000, 11.94214000),
(1030700, 1001530, 'DK', 'Hellebæk', 1, 'hellebaek', 56.06823000, 12.55782000),
(1030701, 1001530, 'DK', 'Helsinge', 1, 'helsinge', 56.02283000, 12.19752000),
(1030702, 1001530, 'DK', 'Helsingør', 1, 'helsingor', 56.03606000, 12.61360000),
(1030703, 1001530, 'DK', 'Helsingør Kommune', 1, 'helsingor-kommune', 56.05000000, 12.50000000),
(1030704, 1001530, 'DK', 'Herlev Kommune', 1, 'herlev-kommune', 55.73317000, 12.43106000),
(1030707, 1001530, 'DK', 'Hillerød', 1, 'hillerod', 55.92791000, 12.30081000),
(1030708, 1001530, 'DK', 'Hillerød Kommune', 1, 'hillerod-kommune', 55.92319000, 12.23794000),
(1030722, 1001530, 'DK', 'Hornbæk', 1, 'hornbaek', 56.09027000, 12.45693000),
(1030736, 1001530, 'DK', 'Høje-Taastrup Kommune', 1, 'hoje-taastrup-kommune', 55.65643000, 12.24854000),
(1030739, 1001530, 'DK', 'Hørsholm', 1, 'horsholm', 55.88098000, 12.50111000),
(1030740, 1001530, 'DK', 'Hørsholm Kommune', 1, 'horsholm-kommune', 55.88759000, 12.48566000),
(1030727, 1001530, 'DK', 'Humlebæk', 1, 'humlebaek', 55.96180000, 12.53410000),
(1030728, 1001530, 'DK', 'Hundested', 1, 'hundested', 55.96397000, 11.85044000),
(1030731, 1001530, 'DK', 'Hvidovre', 1, 'hvidovre', 55.65719000, 12.47364000),
(1030732, 1001530, 'DK', 'Hvidovre Kommune', 1, 'hvidovre-kommune', 55.63166000, 12.46615000),
(1030745, 1001530, 'DK', 'Ishøj', 1, 'ishoj', 55.61543000, 12.35182000),
(1030746, 1001530, 'DK', 'Ishøj Kommune', 1, 'ishoj-kommune', 55.62299000, 12.30567000),
(1030752, 1001530, 'DK', 'Jægerspris', 1, 'jaegerspris', 55.85248000, 11.98565000),
(1030762, 1001530, 'DK', 'Kokkedal', 1, 'kokkedal', 55.91179000, 12.49952000),
(1030766, 1001530, 'DK', 'Kongens Lyngby', 1, 'kongens-lyngby', 55.77044000, 12.50378000),
(1030770, 1001530, 'DK', 'København', 1, 'kobenhavn', 55.67110000, 12.56529000),
(1030780, 1001530, 'DK', 'Lillerød', 1, 'lillerod', 55.87496000, 12.34579000),
(1030782, 1001530, 'DK', 'Liseleje', 1, 'liseleje', 56.01295000, 11.96544000),
(1030785, 1001530, 'DK', 'Lyngby-Tårbæk Kommune', 1, 'lyngby-tarbaek-kommune', 55.78456000, 12.50508000),
(1030786, 1001530, 'DK', 'Lynge', 1, 'lynge', 55.83941000, 12.27725000),
(1030803, 1001530, 'DK', 'Måløv', 1, 'malov', 55.75528000, 12.32327000),
(1030808, 1001530, 'DK', 'Nexø', 1, 'nexo', 55.06067000, 15.13058000),
(1030810, 1001530, 'DK', 'Nivå', 1, 'niva', 55.93405000, 12.50485000),
(1030823, 1001530, 'DK', 'Nødebo', 1, 'nodebo', 55.97877000, 12.34685000),
(1031000, 1001530, 'DK', 'Ølstykke', 1, 'olstykke', 55.79567000, 12.15509000),
(1030857, 1001530, 'DK', 'Rødovre', 1, 'rodovre', 55.68062000, 12.45373000),
(1030858, 1001530, 'DK', 'Rødovre Kommune', 1, 'rodovre-kommune', 55.68852000, 12.44834000),
(1030861, 1001530, 'DK', 'Rønne', 1, 'ronne', 55.10091000, 14.70664000),
(1030849, 1001530, 'DK', 'Rudersdal Kommune', 1, 'rudersdal-kommune', 55.82500000, 12.49167000),
(1030880, 1001530, 'DK', 'Skævinge', 1, 'skaevinge', 55.90785000, 12.15036000),
(1030874, 1001530, 'DK', 'Skibby', 1, 'skibby', 55.75122000, 11.96083000),
(1030884, 1001530, 'DK', 'Slangerup', 1, 'slangerup', 55.85000000, 12.18333000),
(1030885, 1001530, 'DK', 'Smørumnedre', 1, 'smorumnedre', 55.74232000, 12.30276000),
(1030896, 1001530, 'DK', 'Stavnsholt', 1, 'stavnsholt', 55.81479000, 12.40545000),
(1030900, 1001530, 'DK', 'Stenløse', 1, 'stenlose', 55.76828000, 12.19723000),
(1030930, 1001530, 'DK', 'Taastrup', 1, 'taastrup', 55.65006000, 12.30160000),
(1030946, 1001530, 'DK', 'Tårnby', 1, 'tarnby', 55.63030000, 12.60035000),
(1030947, 1001530, 'DK', 'Tårnby Kommune', 1, 'tarnby-kommune', 55.60391000, 12.59599000),
(1030944, 1001530, 'DK', 'Trørød', 1, 'trorod', 55.83946000, 12.54432000),
(1030957, 1001530, 'DK', 'Vallensbæk', 1, 'vallensbaek', 55.62199000, 12.38511000),
(1030958, 1001530, 'DK', 'Vallensbæk Kommune', 1, 'vallensbaek-kommune', 55.63128000, 12.37369000),
(1030960, 1001530, 'DK', 'Vanløse', 1, 'vanlose', 55.68361000, 12.48713000),
(1030988, 1001530, 'DK', 'Værløse', 1, 'vaerlose', 55.78251000, 12.36856000),
(1030967, 1001530, 'DK', 'Veksø', 1, 'vekso', 55.75473000, 12.23837000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001531, 'DK', 'Central Denmark Region', 1, 'central-denmark-region');

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 
(1030580, 1001531, 'DK', 'Allingåbro', 1, 'allingabro', 56.46432000, 10.31957000),
(1030993, 1001531, 'DK', 'Århus', 1, 'arhus', 56.15674000, 10.21076000),
(1030994, 1001531, 'DK', 'Århus Kommune', 1, 'arhus-kommune', 56.16317000, 10.16897000),
(1030585, 1001531, 'DK', 'Assentoft', 1, 'assentoft', 56.44210000, 10.15170000),
(1030587, 1001531, 'DK', 'Auning', 1, 'auning', 56.43079000, 10.37818000),
(1030588, 1001531, 'DK', 'Avlum', 1, 'avlum', 56.26539000, 8.79256000),
(1030591, 1001531, 'DK', 'Beder', 1, 'beder', 56.06025000, 10.21179000),
(1030596, 1001531, 'DK', 'Bjerringbro', 1, 'bjerringbro', 56.37797000, 9.66065000),
(1030600, 1001531, 'DK', 'Bording Kirkeby', 1, 'bording-kirkeby', 56.16871000, 9.24384000),
(1030604, 1001531, 'DK', 'Brande', 1, 'brande', 55.94316000, 9.12798000),
(1030609, 1001531, 'DK', 'Brædstrup', 1, 'braedstrup', 55.97153000, 9.61129000),
(1030626, 1001531, 'DK', 'Ebeltoft', 1, 'ebeltoft', 56.19442000, 10.68210000),
(1030639, 1001531, 'DK', 'Favrskov Kommune', 1, 'favrskov-kommune', 56.31667000, 9.94000000),
(1030647, 1001531, 'DK', 'Framlev', 1, 'framlev', 56.15664000, 10.01318000),
(1030663, 1001531, 'DK', 'Galten', 1, 'galten', 56.15902000, 9.91691000),
(1030669, 1001531, 'DK', 'Gjellerup', 1, 'gjellerup', 56.14616000, 9.05467000),
(1030675, 1001531, 'DK', 'Grenaa', 1, 'grenaa', 56.41578000, 10.87825000),
(1030688, 1001531, 'DK', 'Hadsten', 1, 'hadsten', 56.32819000, 10.04931000),
(1030692, 1001531, 'DK', 'Hammel', 1, 'hammel', 56.25762000, 9.86316000),
(1030693, 1001531, 'DK', 'Hammerum', 1, 'hammerum', 56.13361000, 9.06121000),
(1030695, 1001531, 'DK', 'Harboøre', 1, 'harboore', 56.61752000, 8.18069000),
(1030698, 1001531, 'DK', 'Hedensted', 1, 'hedensted', 55.77043000, 9.70110000),
(1030699, 1001531, 'DK', 'Hedensted Kommune', 1, 'hedensted-kommune', 55.79680000, 9.74400000),
(1030705, 1001531, 'DK', 'Herning', 1, 'herning', 56.13615000, 8.97662000),
(1030706, 1001531, 'DK', 'Herning Kommune', 1, 'herning-kommune', 56.14997000, 8.89712000),
(1030709, 1001531, 'DK', 'Hinnerup', 1, 'hinnerup', 56.26608000, 10.06299000),
(1030712, 1001531, 'DK', 'Hjortshøj', 1, 'hjortshoj', 56.24811000, 10.26533000),
(1030719, 1001531, 'DK', 'Holstebro', 1, 'holstebro', 56.36009000, 8.61607000),
(1030720, 1001531, 'DK', 'Holstebro Kommune', 1, 'holstebro-kommune', 56.35916000, 8.59631000),
(1030723, 1001531, 'DK', 'Hornslet', 1, 'hornslet', 56.31550000, 10.32041000),
(1030724, 1001531, 'DK', 'Hornsyld', 1, 'hornsyld', 55.75621000, 9.85643000),
(1030725, 1001531, 'DK', 'Horsens', 1, 'horsens', 55.86066000, 9.85034000),
(1030726, 1001531, 'DK', 'Horsens Kommune', 1, 'horsens-kommune', 55.92740000, 9.77377000),
(1030738, 1001531, 'DK', 'Hørning', 1, 'horning', 56.08701000, 10.03716000),
(1030730, 1001531, 'DK', 'Hvide Sande', 1, 'hvide-sande', 55.99866000, 8.12605000),
(1030743, 1001531, 'DK', 'Ikast', 1, 'ikast', 56.13883000, 9.15768000),
(1030744, 1001531, 'DK', 'Ikast-Brande Kommune', 1, 'ikast-brande-kommune', 55.98333000, 9.21667000),
(1030749, 1001531, 'DK', 'Juelsminde', 1, 'juelsminde', 55.70876000, 10.01668000),
(1030755, 1001531, 'DK', 'Karup', 1, 'karup', 56.30673000, 9.16835000),
(1030758, 1001531, 'DK', 'Kibæk', 1, 'kibaek', 56.03170000, 8.85697000),
(1030760, 1001531, 'DK', 'Kjellerup', 1, 'kjellerup', 56.28581000, 9.43528000),
(1030765, 1001531, 'DK', 'Kolt', 1, 'kolt', 56.10845000, 10.06986000),
(1030775, 1001531, 'DK', 'Langå', 1, 'langa', 56.39026000, 9.89486000),
(1030778, 1001531, 'DK', 'Lemvig', 1, 'lemvig', 56.54856000, 8.31019000),
(1030779, 1001531, 'DK', 'Lemvig Kommune', 1, 'lemvig-kommune', 56.49136000, 8.29927000),
(1030781, 1001531, 'DK', 'Lind', 1, 'lind', 56.10600000, 8.97915000),
(1030790, 1001531, 'DK', 'Løgten', 1, 'logten', 56.27459000, 10.31181000),
(1030787, 1001531, 'DK', 'Lystrup', 1, 'lystrup', 56.23750000, 10.23778000),
(1030794, 1001531, 'DK', 'Malling', 1, 'malling', 56.03632000, 10.19632000),
(1030804, 1001531, 'DK', 'Mårslet', 1, 'marslet', 56.06690000, 10.16112000),
(1030813, 1001531, 'DK', 'Norddjurs Kommune', 1, 'norddjurs-kommune', 56.44124000, 10.76660000),
(1030827, 1001531, 'DK', 'Odder', 1, 'odder', 55.97313000, 10.15300000),
(1030828, 1001531, 'DK', 'Odder Kommune', 1, 'odder-kommune', 55.92967000, 10.15304000),
(1030838, 1001531, 'DK', 'Randers', 1, 'randers', 56.46070000, 10.03639000),
(1030839, 1001531, 'DK', 'Randers Kommune', 1, 'randers-kommune', 56.51561000, 10.06901000),
(1030843, 1001531, 'DK', 'Ringkøbing', 1, 'ringkobing', 56.09006000, 8.24402000),
(1030844, 1001531, 'DK', 'Ringkøbing-Skjern Kommune', 1, 'ringkobing-skjern-kommune', 56.01000000, 8.39667000),
(1030860, 1001531, 'DK', 'Rønde', 1, 'ronde', 56.30145000, 10.47505000),
(1030851, 1001531, 'DK', 'Ry', 1, 'ry', 56.09038000, 9.76505000),
(1030852, 1001531, 'DK', 'Ryomgård', 1, 'ryomgard', 56.38430000, 10.50295000),
(1030863, 1001531, 'DK', 'Sabro', 1, 'sabro', 56.21333000, 10.03441000),
(1030865, 1001531, 'DK', 'Samsø Kommune', 1, 'samso-kommune', 55.85245000, 10.60045000),
(1030867, 1001531, 'DK', 'Silkeborg', 1, 'silkeborg', 56.16970000, 9.54508000),
(1030868, 1001531, 'DK', 'Silkeborg Kommune', 1, 'silkeborg-kommune', 56.17495000, 9.54666000),
(1030872, 1001531, 'DK', 'Skanderborg', 1, 'skanderborg', 56.03434000, 9.93177000),
(1030873, 1001531, 'DK', 'Skanderborg Kommune', 1, 'skanderborg-kommune', 56.07956000, 9.89868000),
(1030875, 1001531, 'DK', 'Skive', 1, 'skive', 56.56699000, 9.02707000),
(1030876, 1001531, 'DK', 'Skive Kommune', 1, 'skive-kommune', 56.64478000, 8.97660000),
(1030877, 1001531, 'DK', 'Skjern', 1, 'skjern', 55.95000000, 8.50000000),
(1030878, 1001531, 'DK', 'Skovby', 1, 'skovby', 56.15672000, 9.94523000),
(1030886, 1001531, 'DK', 'Snejbjerg', 1, 'snejbjerg', 56.13291000, 8.90353000),
(1030888, 1001531, 'DK', 'Solbjerg', 1, 'solbjerg', 56.04271000, 10.08631000),
(1030925, 1001531, 'DK', 'Søften', 1, 'soften', 56.23801000, 10.08510000),
(1030894, 1001531, 'DK', 'Spentrup', 1, 'spentrup', 56.53703000, 10.03792000),
(1030897, 1001531, 'DK', 'Stavtrup', 1, 'stavtrup', 56.13124000, 10.11987000),
(1030903, 1001531, 'DK', 'Stilling', 1, 'stilling', 56.06224000, 9.98822000),
(1030904, 1001531, 'DK', 'Stoholm', 1, 'stoholm', 56.48454000, 9.14617000),
(1030909, 1001531, 'DK', 'Struer', 1, 'struer', 56.49205000, 8.59397000),
(1030910, 1001531, 'DK', 'Struer Kommune', 1, 'struer-kommune', 56.46667000, 8.58333000),
(1030915, 1001531, 'DK', 'Sunds', 1, 'sunds', 56.20743000, 9.01386000),
(1030917, 1001531, 'DK', 'Svejbæk', 1, 'svejbaek', 56.13255000, 9.63289000),
(1030923, 1001531, 'DK', 'Syddjurs Kommune', 1, 'syddjurs-kommune', 56.31250000, 10.52083000),
(1030931, 1001531, 'DK', 'Tarm', 1, 'tarm', 55.90861000, 8.53041000),
(1030936, 1001531, 'DK', 'Thyborøn', 1, 'thyboron', 56.69846000, 8.21238000),
(1030952, 1001531, 'DK', 'Tørring', 1, 'torring', 55.85000000, 9.48333000),
(1030942, 1001531, 'DK', 'Tranbjerg', 1, 'tranbjerg', 56.09519000, 10.13605000),
(1030943, 1001531, 'DK', 'Trige', 1, 'trige', 56.25291000, 10.14840000),
(1030953, 1001531, 'DK', 'Ulfborg', 1, 'ulfborg', 56.26725000, 8.32167000),
(1030955, 1001531, 'DK', 'Ulstrup', 1, 'ulstrup', 56.38994000, 9.79354000),
(1030972, 1001531, 'DK', 'Viborg', 1, 'viborg', 56.45319000, 9.40201000),
(1030973, 1001531, 'DK', 'Viborg Kommune', 1, 'viborg-kommune', 56.45000000, 9.36667000),
(1030975, 1001531, 'DK', 'Videbæk', 1, 'videbaek', 56.08760000, 8.62852000),
(1030976, 1001531, 'DK', 'Vildbjerg', 1, 'vildbjerg', 56.20000000, 8.76667000),
(1030978, 1001531, 'DK', 'Vinderup', 1, 'vinderup', 56.48176000, 8.77991000),
(1030981, 1001531, 'DK', 'Virklund', 1, 'virklund', 56.13218000, 9.55582000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001532, 'DK', 'North Denmark Region', 1, 'north-denmark-region');

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 
(1030575, 1001532, 'DK', 'Aalborg', 1, 'aalborg', 57.04800000, 9.91870000),
(1030576, 1001532, 'DK', 'Aars', 1, 'aars', 56.80399000, 9.51441000),
(1030989, 1001532, 'DK', 'Åbybro', 1, 'abybro', 57.16249000, 9.72996000),
(1030991, 1001532, 'DK', 'Ålborg Kommune', 1, 'alborg-kommune', 57.00000000, 9.95000000),
(1030992, 1001532, 'DK', 'Ålestrup', 1, 'alestrup', 56.69470000, 9.49336000),
(1030581, 1001532, 'DK', 'Arden', 1, 'arden', 56.76899000, 9.86184000),
(1030608, 1001532, 'DK', 'Brovst', 1, 'brovst', 57.09750000, 9.52264000),
(1030611, 1001532, 'DK', 'Brønderslev', 1, 'bronderslev', 57.27021000, 9.94102000),
(1030612, 1001532, 'DK', 'Brønderslev Kommune', 1, 'bronderslev-kommune', 57.23506000, 10.10061000),
(1030624, 1001532, 'DK', 'Dronninglund', 1, 'dronninglund', 57.16035000, 10.29287000),
(1030637, 1001532, 'DK', 'Farsø', 1, 'farso', 56.77276000, 9.33925000),
(1030644, 1001532, 'DK', 'Fjerritslev', 1, 'fjerritslev', 57.08822000, 9.26622000),
(1030655, 1001532, 'DK', 'Frederikshavn', 1, 'frederikshavn', 57.44073000, 10.53661000),
(1030656, 1001532, 'DK', 'Frederikshavn Kommune', 1, 'frederikshavn-kommune', 57.43347000, 10.42507000),
(1030660, 1001532, 'DK', 'Frejlev', 1, 'frejlev', 57.00623000, 9.81711000),
(1030667, 1001532, 'DK', 'Gistrup', 1, 'gistrup', 56.99430000, 9.99085000),
(1030689, 1001532, 'DK', 'Hadsund', 1, 'hadsund', 56.71482000, 10.11682000),
(1030690, 1001532, 'DK', 'Hals', 1, 'hals', 56.99609000, 10.30807000),
(1030694, 1001532, 'DK', 'Hanstholm', 1, 'hanstholm', 57.11667000, 8.61667000),
(1030710, 1001532, 'DK', 'Hirtshals', 1, 'hirtshals', 57.58812000, 9.95922000),
(1030711, 1001532, 'DK', 'Hjallerup', 1, 'hjallerup', 57.16466000, 10.14571000),
(1030713, 1001532, 'DK', 'Hjørring', 1, 'hjorring', 57.46417000, 9.98229000),
(1030714, 1001532, 'DK', 'Hjørring Kommune', 1, 'hjorring-kommune', 57.45682000, 10.05859000),
(1030715, 1001532, 'DK', 'Hobro', 1, 'hobro', 56.64306000, 9.79029000),
(1030729, 1001532, 'DK', 'Hurup', 1, 'hurup', 56.74944000, 8.41953000),
(1030747, 1001532, 'DK', 'Jammerbugt Kommune', 1, 'jammerbugt-kommune', 57.14583000, 9.56250000),
(1030769, 1001532, 'DK', 'Kås', 1, 'kas', 57.19774000, 9.67173000),
(1030761, 1001532, 'DK', 'Klarup', 1, 'klarup', 57.01194000, 10.05617000),
(1030788, 1001532, 'DK', 'Læso Kommune', 1, 'laeso-kommune', 57.26774000, 11.02265000),
(1030789, 1001532, 'DK', 'Løgstør', 1, 'logstor', 56.96245000, 9.25830000),
(1030793, 1001532, 'DK', 'Løkken', 1, 'lokken', 57.37047000, 9.71466000),
(1030795, 1001532, 'DK', 'Mariager', 1, 'mariager', 56.64985000, 9.97515000),
(1030796, 1001532, 'DK', 'Mariagerfjord Kommune', 1, 'mariagerfjord-kommune', 56.69722000, 9.84722000),
(1030801, 1001532, 'DK', 'Morsø Kommune', 1, 'morso-kommune', 56.79622000, 8.73272000),
(1030809, 1001532, 'DK', 'Nibe', 1, 'nibe', 56.98150000, 9.63917000),
(1030826, 1001532, 'DK', 'Nørresundby', 1, 'norresundby', 57.05877000, 9.92284000),
(1030818, 1001532, 'DK', 'Nykøbing Mors', 1, 'nykobing-mors', 56.79334000, 8.85282000),
(1030836, 1001532, 'DK', 'Pandrup', 1, 'pandrup', 57.22147000, 9.67569000),
(1030840, 1001532, 'DK', 'Rebild Kommune', 1, 'rebild-kommune', 56.80556000, 9.77778000),
(1030924, 1001532, 'DK', 'Sæby', 1, 'saeby', 57.33188000, 10.52251000),
(1030869, 1001532, 'DK', 'Sindal', 1, 'sindal', 57.47117000, 10.20312000),
(1030871, 1001532, 'DK', 'Skagen', 1, 'skagen', 57.72093000, 10.58394000),
(1030881, 1001532, 'DK', 'Skørping', 1, 'skorping', 56.83626000, 9.89255000),
(1030906, 1001532, 'DK', 'Storvorde', 1, 'storvorde', 57.00392000, 10.10125000),
(1030913, 1001532, 'DK', 'Støvring', 1, 'stovring', 56.88536000, 9.83839000),
(1030907, 1001532, 'DK', 'Strandby', 1, 'strandby', 57.49150000, 10.49609000),
(1030920, 1001532, 'DK', 'Svenstrup', 1, 'svenstrup', 56.97230000, 9.84806000),
(1030948, 1001532, 'DK', 'Tårs', 1, 'tars', 57.38333000, 10.11667000),
(1030933, 1001532, 'DK', 'Thisted', 1, 'thisted', 56.95523000, 8.69491000),
(1030934, 1001532, 'DK', 'Thisted Kommune', 1, 'thisted-kommune', 57.00397000, 8.61834000),
(1030956, 1001532, 'DK', 'Vadum', 1, 'vadum', 57.11790000, 9.85700000),
(1030968, 1001532, 'DK', 'Vestbjerg', 1, 'vestbjerg', 57.13166000, 9.95942000),
(1030969, 1001532, 'DK', 'Vester Hassing', 1, 'vester-hassing', 57.06767000, 10.12558000),
(1030971, 1001532, 'DK', 'Vesthimmerland Kommune', 1, 'vesthimmerland-kommune', 56.80000000, 9.37083000),
(1030983, 1001532, 'DK', 'Vodskov', 1, 'vodskov', 57.10854000, 10.02215000),
(1030987, 1001532, 'DK', 'Vrå', 1, 'vra', 57.35370000, 9.94176000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001529, 'DK', 'Region of Southern Denmark', 1, 'region-of-southern-denmark');

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 
(1030573, 1001529, 'DK', 'Aabenraa', 1, 'aabenraa', 55.04434000, 9.41741000),
(1030574, 1001529, 'DK', 'Aabenraa Kommune', 1, 'aabenraa-kommune', 54.98980000, 9.31282000),
(1030995, 1001529, 'DK', 'Årslev', 1, 'arslev', 55.30353000, 10.46428000),
(1030996, 1001529, 'DK', 'Årup', 1, 'arup', 55.37315000, 10.04131000),
(1030583, 1001529, 'DK', 'Assens', 1, 'assens', 55.27023000, 9.90081000),
(1030584, 1001529, 'DK', 'Assens Kommune', 1, 'assens-kommune', 55.29958000, 10.07952000),
(1030586, 1001529, 'DK', 'Augustenborg', 1, 'augustenborg', 54.95201000, 9.87216000),
(1030997, 1001529, 'DK', 'Ærø Kommune', 1, 'aero-kommune', 54.85833000, 10.43333000),
(1030998, 1001529, 'DK', 'Ærøskøbing', 1, 'aeroskobing', 54.88803000, 10.41117000),
(1030592, 1001529, 'DK', 'Bellinge', 1, 'bellinge', 55.33535000, 10.32045000),
(1030593, 1001529, 'DK', 'Billund', 1, 'billund', 55.73349000, 9.10785000),
(1030594, 1001529, 'DK', 'Billund Kommune', 1, 'billund-kommune', 55.73079000, 8.96844000),
(1030599, 1001529, 'DK', 'Bogense', 1, 'bogense', 55.56691000, 10.08863000),
(1030615, 1001529, 'DK', 'Børkop', 1, 'borkop', 55.64195000, 9.64958000),
(1030603, 1001529, 'DK', 'Bramming', 1, 'bramming', 55.46946000, 8.70007000),
(1030605, 1001529, 'DK', 'Brejning', 1, 'brejning', 55.66594000, 9.67217000),
(1030606, 1001529, 'DK', 'Brenderup', 1, 'brenderup', 55.48407000, 9.97908000),
(1030607, 1001529, 'DK', 'Broager', 1, 'broager', 54.88940000, 9.67465000),
(1030613, 1001529, 'DK', 'Brørup', 1, 'brorup', 55.48194000, 9.01756000),
(1030614, 1001529, 'DK', 'Bullerup', 1, 'bullerup', 55.42686000, 10.47137000),
(1030617, 1001529, 'DK', 'Christiansfeld', 1, 'christiansfeld', 55.35817000, 9.48701000),
(1030625, 1001529, 'DK', 'Dybbøl', 1, 'dybbol', 54.91079000, 9.73601000),
(1030628, 1001529, 'DK', 'Egtved', 1, 'egtved', 55.61613000, 9.30763000),
(1030629, 1001529, 'DK', 'Ejby', 1, 'ejby', 55.43010000, 9.92973000),
(1030631, 1001529, 'DK', 'Esbjerg', 1, 'esbjerg', 55.47028000, 8.45187000),
(1030632, 1001529, 'DK', 'Esbjerg Kommune', 1, 'esbjerg-kommune', 55.46893000, 8.46222000),
(1030634, 1001529, 'DK', 'Faaborg', 1, 'faaborg', 55.09510000, 10.24226000),
(1030635, 1001529, 'DK', 'Faaborg-Midtfyn Kommune', 1, 'faaborg-midtfyn-kommune', 55.22667000, 10.40667000),
(1030636, 1001529, 'DK', 'Fanø Kommune', 1, 'fano-kommune', 55.41667000, 8.41667000),
(1030650, 1001529, 'DK', 'Fredericia', 1, 'fredericia', 55.56568000, 9.75257000),
(1030651, 1001529, 'DK', 'Fredericia Kommune', 1, 'fredericia-kommune', 55.57271000, 9.69489000),
(1030668, 1001529, 'DK', 'Give', 1, 'give', 55.84523000, 9.23769000),
(1030671, 1001529, 'DK', 'Glamsbjerg', 1, 'glamsbjerg', 55.27237000, 10.10483000),
(1030674, 1001529, 'DK', 'Gram', 1, 'gram', 55.28948000, 9.04913000),
(1030680, 1001529, 'DK', 'Gråsten', 1, 'grasten', 54.91918000, 9.59523000),
(1030679, 1001529, 'DK', 'Grindsted', 1, 'grindsted', 55.75726000, 8.92750000),
(1030682, 1001529, 'DK', 'Guderup', 1, 'guderup', 54.98978000, 9.87174000),
(1030686, 1001529, 'DK', 'Haderslev', 1, 'haderslev', 55.24943000, 9.48771000),
(1030687, 1001529, 'DK', 'Haderslev Kommune', 1, 'haderslev-kommune', 55.24441000, 9.32261000),
(1030733, 1001529, 'DK', 'Hårby', 1, 'harby', 55.22357000, 10.12268000),
(1030721, 1001529, 'DK', 'Holsted', 1, 'holsted', 55.51086000, 8.91872000),
(1030735, 1001529, 'DK', 'Højby', 1, 'hojby', 55.33177000, 10.43725000),
(1030741, 1001529, 'DK', 'Høruphav', 1, 'horuphav', 54.91017000, 9.89872000),
(1030748, 1001529, 'DK', 'Jelling', 1, 'jelling', 55.75588000, 9.42580000),
(1030756, 1001529, 'DK', 'Kerteminde', 1, 'kerteminde', 55.44903000, 10.65769000),
(1030757, 1001529, 'DK', 'Kerteminde Kommune', 1, 'kerteminde-kommune', 55.45498000, 10.62220000),
(1030763, 1001529, 'DK', 'Kolding', 1, 'kolding', 55.49040000, 9.47216000),
(1030764, 1001529, 'DK', 'Kolding Kommune', 1, 'kolding-kommune', 55.45006000, 9.45807000),
(1030768, 1001529, 'DK', 'Kruså', 1, 'krusa', 54.85097000, 9.40129000),
(1030773, 1001529, 'DK', 'Langeland Kommune', 1, 'langeland-kommune', 54.90000000, 10.77222000),
(1030774, 1001529, 'DK', 'Langeskov', 1, 'langeskov', 55.35655000, 10.58447000),
(1030791, 1001529, 'DK', 'Løgumkloster', 1, 'logumkloster', 55.05941000, 8.95508000),
(1030792, 1001529, 'DK', 'Løjt Kirkeby', 1, 'lojt-kirkeby', 55.08959000, 9.46084000),
(1030784, 1001529, 'DK', 'Lunderskov', 1, 'lunderskov', 55.48375000, 9.29917000),
(1030798, 1001529, 'DK', 'Marstal', 1, 'marstal', 54.85621000, 10.51726000),
(1030799, 1001529, 'DK', 'Middelfart', 1, 'middelfart', 55.50591000, 9.73054000),
(1030800, 1001529, 'DK', 'Middelfart Kommune', 1, 'middelfart-kommune', 55.45782000, 9.88100000),
(1030802, 1001529, 'DK', 'Munkebo', 1, 'munkebo', 55.45553000, 10.55433000),
(1030806, 1001529, 'DK', 'Neder Holluf', 1, 'neder-holluf', 55.36451000, 10.44824000),
(1030811, 1001529, 'DK', 'Nordborg', 1, 'nordborg', 55.05732000, 9.74080000),
(1030812, 1001529, 'DK', 'Nordby', 1, 'nordby', 55.44603000, 8.39786000),
(1030814, 1001529, 'DK', 'Nordfyns Kommune', 1, 'nordfyns-kommune', 55.52222000, 10.22222000),
(1030825, 1001529, 'DK', 'Nørre Åby', 1, 'norre-aby', 55.46107000, 9.87940000),
(1030815, 1001529, 'DK', 'Nyborg', 1, 'nyborg', 55.31274000, 10.78964000),
(1030816, 1001529, 'DK', 'Nyborg Kommune', 1, 'nyborg-kommune', 55.29473000, 10.70310000),
(1030829, 1001529, 'DK', 'Odense', 1, 'odense', 55.39594000, 10.38831000),
(1030830, 1001529, 'DK', 'Odense Kommune', 1, 'odense-kommune', 55.39570000, 10.37761000),
(1030832, 1001529, 'DK', 'Oksbøl', 1, 'oksbol', 55.62680000, 8.28757000),
(1030834, 1001529, 'DK', 'Otterup', 1, 'otterup', 55.51527000, 10.39756000),
(1030999, 1001529, 'DK', 'Ølgod', 1, 'olgod', 55.80682000, 8.62859000),
(1030835, 1001529, 'DK', 'Padborg', 1, 'padborg', 54.82657000, 9.36247000),
(1030841, 1001529, 'DK', 'Ribe', 1, 'ribe', 55.33051000, 8.76966000),
(1030842, 1001529, 'DK', 'Ringe', 1, 'ringe', 55.23828000, 10.47860000),
(1030855, 1001529, 'DK', 'Rødding', 1, 'rodding', 55.36569000, 9.06316000),
(1030856, 1001529, 'DK', 'Rødekro', 1, 'rodekro', 55.07076000, 9.33531000),
(1030850, 1001529, 'DK', 'Rudkøbing', 1, 'rudkobing', 54.93639000, 10.71019000),
(1030866, 1001529, 'DK', 'Seden', 1, 'seden', 55.42648000, 10.44265000),
(1030870, 1001529, 'DK', 'Skaerbaek', 1, 'skaerbaek', 55.15735000, 8.76901000),
(1030887, 1001529, 'DK', 'Snoghøj', 1, 'snoghoj', 55.52253000, 9.72125000),
(1030926, 1001529, 'DK', 'Sønder Bjert', 1, 'sonder-bjert', 55.45272000, 9.56741000),
(1030927, 1001529, 'DK', 'Sønderborg', 1, 'sonderborg', 54.90896000, 9.78917000),
(1030928, 1001529, 'DK', 'Sønderborg Kommune', 1, 'sonderborg-kommune', 54.91667000, 9.80000000),
(1030929, 1001529, 'DK', 'Søndersø', 1, 'sonderso', 55.48526000, 10.25540000),
(1030895, 1001529, 'DK', 'Starup', 1, 'starup', 55.24097000, 9.53503000),
(1030902, 1001529, 'DK', 'Stige', 1, 'stige', 55.43941000, 10.40940000),
(1030908, 1001529, 'DK', 'Strib', 1, 'strib', 55.54021000, 9.76748000),
(1030918, 1001529, 'DK', 'Svendborg', 1, 'svendborg', 55.05982000, 10.60677000),
(1030919, 1001529, 'DK', 'Svendborg Kommune', 1, 'svendborg-kommune', 55.08410000, 10.61391000),
(1030932, 1001529, 'DK', 'Taulov', 1, 'taulov', 55.54582000, 9.61553000),
(1030935, 1001529, 'DK', 'Thurø By', 1, 'thuro-by', 55.04740000, 10.66385000),
(1030937, 1001529, 'DK', 'Tinglev', 1, 'tinglev', 54.93788000, 9.25547000),
(1030938, 1001529, 'DK', 'Tjæreborg', 1, 'tjaereborg', 55.46457000, 8.57968000),
(1030939, 1001529, 'DK', 'Toftlund', 1, 'toftlund', 55.18858000, 9.06925000),
(1030940, 1001529, 'DK', 'Tommerup', 1, 'tommerup', 55.31952000, 10.20659000),
(1030941, 1001529, 'DK', 'Tommerup Stationsby', 1, 'tommerup-stationsby', 55.34535000, 10.17594000),
(1030950, 1001529, 'DK', 'Tønder', 1, 'tonder', 54.93306000, 8.86674000),
(1030951, 1001529, 'DK', 'Tønder Kommune', 1, 'tonder-kommune', 55.07304000, 8.87214000),
(1030954, 1001529, 'DK', 'Ullerslev', 1, 'ullerslev', 55.36172000, 10.65190000),
(1030959, 1001529, 'DK', 'Vamdrup', 1, 'vamdrup', 55.42764000, 9.28435000),
(1030961, 1001529, 'DK', 'Varde', 1, 'varde', 55.62112000, 8.48069000),
(1030962, 1001529, 'DK', 'Varde Kommune', 1, 'varde-kommune', 55.61667000, 8.50000000),
(1030963, 1001529, 'DK', 'Vejen', 1, 'vejen', 55.48117000, 9.13795000),
(1030964, 1001529, 'DK', 'Vejen Kommune', 1, 'vejen-kommune', 55.46312000, 9.05004000),
(1030965, 1001529, 'DK', 'Vejle', 1, 'vejle', 55.70927000, 9.53570000),
(1030966, 1001529, 'DK', 'Vejle Kommune', 1, 'vejle-kommune', 55.74874000, 9.40421000),
(1030970, 1001529, 'DK', 'Vester-Skerninge', 1, 'vester-skerninge', 55.07322000, 10.45536000),
(1030977, 1001529, 'DK', 'Vindeby', 1, 'vindeby', 55.04489000, 10.61309000),
(1030982, 1001529, 'DK', 'Vissenbjerg', 1, 'vissenbjerg', 55.38482000, 10.13784000),
(1030984, 1001529, 'DK', 'Vojens', 1, 'vojens', 55.24639000, 9.30603000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001528, 'DK', 'Region Zealand', 1, 'region-zealand');

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 
(1030582, 1001528, 'DK', 'Asnæs', 1, 'asnaes', 55.81229000, 11.50129000),
(1030597, 1001528, 'DK', 'Bjæverskov', 1, 'bjaeverskov', 55.45756000, 12.03651000),
(1030602, 1001528, 'DK', 'Borup', 1, 'borup', 55.49472000, 11.97584000),
(1030621, 1001528, 'DK', 'Dianalund', 1, 'dianalund', 55.53133000, 11.49250000),
(1030630, 1001528, 'DK', 'Ejby', 1, 'ejby', 55.48580000, 12.08171000),
(1030640, 1001528, 'DK', 'Faxe', 1, 'faxe', 55.25561000, 12.11926000),
(1030641, 1001528, 'DK', 'Faxe Kommune', 1, 'faxe-kommune', 55.29444000, 12.06111000),
(1030642, 1001528, 'DK', 'Faxe Ladeplads', 1, 'faxe-ladeplads', 55.21981000, 12.17013000),
(1030643, 1001528, 'DK', 'Fensmark', 1, 'fensmark', 55.27919000, 11.80382000),
(1030646, 1001528, 'DK', 'Forlev', 1, 'forlev', 55.37445000, 11.25966000),
(1030653, 1001528, 'DK', 'Frederiksberg', 1, 'frederiksberg', 55.41618000, 11.56934000),
(1030661, 1001528, 'DK', 'Fuglebjerg', 1, 'fuglebjerg', 55.30604000, 11.54766000),
(1030685, 1001528, 'DK', 'Gørlev', 1, 'gorlev', 55.53926000, 11.22708000),
(1030676, 1001528, 'DK', 'Greve', 1, 'greve', 55.58333000, 12.30000000),
(1030677, 1001528, 'DK', 'Greve Kommune', 1, 'greve-kommune', 55.58770000, 12.25060000),
(1030683, 1001528, 'DK', 'Guldborgsund Kommune', 1, 'guldborgsund-kommune', 54.76944000, 11.83611000),
(1030684, 1001528, 'DK', 'Gundsømagle', 1, 'gundsomagle', 55.73565000, 12.15158000),
(1030734, 1001528, 'DK', 'Hårlev', 1, 'harlev', 55.34936000, 12.23382000),
(1030696, 1001528, 'DK', 'Haslev', 1, 'haslev', 55.32346000, 11.96389000),
(1030697, 1001528, 'DK', 'Havdrup', 1, 'havdrup', 55.54481000, 12.12392000),
(1030716, 1001528, 'DK', 'Holbæk', 1, 'holbaek', 55.71750000, 11.71279000),
(1030717, 1001528, 'DK', 'Holbæk Kommune', 1, 'holbaek-kommune', 55.65919000, 11.62049000),
(1030718, 1001528, 'DK', 'Holeby', 1, 'holeby', 54.71148000, 11.46416000),
(1030737, 1001528, 'DK', 'Høng', 1, 'hong', 55.50736000, 11.28873000),
(1030742, 1001528, 'DK', 'Hørve', 1, 'horve', 55.75292000, 11.45298000),
(1030750, 1001528, 'DK', 'Jyderup', 1, 'jyderup', 55.66399000, 11.42029000),
(1030751, 1001528, 'DK', 'Jyllinge', 1, 'jyllinge', 55.75295000, 12.10315000),
(1030753, 1001528, 'DK', 'Kalundborg', 1, 'kalundborg', 55.67954000, 11.08864000),
(1030754, 1001528, 'DK', 'Kalundborg Kommune', 1, 'kalundborg-kommune', 55.63545000, 11.19993000),
(1030759, 1001528, 'DK', 'Kirke Hvalsø', 1, 'kirke-hvalso', 55.59170000, 11.86253000),
(1030767, 1001528, 'DK', 'Korsør', 1, 'korsor', 55.32993000, 11.13857000),
(1030771, 1001528, 'DK', 'Køge', 1, 'koge', 55.45802000, 12.18214000),
(1030772, 1001528, 'DK', 'Køge Kommune', 1, 'koge-kommune', 55.45668000, 12.07332000),
(1030776, 1001528, 'DK', 'Lejre', 1, 'lejre', 55.60461000, 11.97477000),
(1030777, 1001528, 'DK', 'Lejre Kommune', 1, 'lejre-kommune', 55.63375000, 11.92234000),
(1030783, 1001528, 'DK', 'Lolland Kommune', 1, 'lolland-kommune', 54.80238000, 11.29524000),
(1030797, 1001528, 'DK', 'Maribo', 1, 'maribo', 54.77662000, 11.50017000),
(1030805, 1001528, 'DK', 'Nakskov', 1, 'nakskov', 54.83038000, 11.13567000),
(1030821, 1001528, 'DK', 'Næstved', 1, 'naestved', 55.22992000, 11.76092000),
(1030822, 1001528, 'DK', 'Næstved Kommune', 1, 'naestved-kommune', 55.25855000, 11.74615000),
(1030807, 1001528, 'DK', 'Neder Vindinge', 1, 'neder-vindinge', 55.03211000, 11.88356000),
(1030824, 1001528, 'DK', 'Nørre Alslev', 1, 'norre-alslev', 54.89784000, 11.88414000),
(1030817, 1001528, 'DK', 'Nykøbing Falster', 1, 'nykobing-falster', 54.76906000, 11.87425000),
(1030819, 1001528, 'DK', 'Nykøbing Sjælland', 1, 'nykobing-sjaelland', 55.92491000, 11.67109000),
(1030820, 1001528, 'DK', 'Nyråd', 1, 'nyrad', 55.00511000, 11.96060000),
(1030831, 1001528, 'DK', 'Odsherred Kommune', 1, 'odsherred-kommune', 55.88333000, 11.59444000),
(1030833, 1001528, 'DK', 'Osted', 1, 'osted', 55.56228000, 11.95786000),
(1031001, 1001528, 'DK', 'Ørslev', 1, 'orslev', 55.04356000, 11.96792000),
(1030837, 1001528, 'DK', 'Præstø', 1, 'praesto', 55.12374000, 12.04477000),
(1030845, 1001528, 'DK', 'Ringsted', 1, 'ringsted', 55.44260000, 11.79011000),
(1030846, 1001528, 'DK', 'Ringsted Kommune', 1, 'ringsted-kommune', 55.44721000, 11.81720000),
(1030847, 1001528, 'DK', 'Roskilde', 1, 'roskilde', 55.64152000, 12.08035000),
(1030848, 1001528, 'DK', 'Roskilde Kommune', 1, 'roskilde-kommune', 55.65000000, 12.10000000),
(1030853, 1001528, 'DK', 'Rødby', 1, 'rodby', 54.69495000, 11.38885000),
(1030854, 1001528, 'DK', 'Rødbyhavn', 1, 'rodbyhavn', 54.65944000, 11.35504000),
(1030859, 1001528, 'DK', 'Rødvig', 1, 'rodvig', 55.25540000, 12.37936000),
(1030862, 1001528, 'DK', 'Rønnede', 1, 'ronnede', 55.25710000, 12.02125000),
(1030864, 1001528, 'DK', 'Sakskøbing', 1, 'sakskobing', 54.79970000, 11.62599000),
(1030879, 1001528, 'DK', 'Skælskør', 1, 'skaelskor', 55.25058000, 11.29352000),
(1030882, 1001528, 'DK', 'Slagelse', 1, 'slagelse', 55.40276000, 11.35459000),
(1030883, 1001528, 'DK', 'Slagelse Kommune', 1, 'slagelse-kommune', 55.34546000, 11.33390000),
(1030889, 1001528, 'DK', 'Solrød', 1, 'solrod', 55.53628000, 12.18270000),
(1030890, 1001528, 'DK', 'Solrød Kommune', 1, 'solrod-kommune', 55.53553000, 12.17337000),
(1030891, 1001528, 'DK', 'Solrød Strand', 1, 'solrod-strand', 55.53285000, 12.22227000),
(1030892, 1001528, 'DK', 'Sorø', 1, 'soro', 55.43184000, 11.55547000),
(1030893, 1001528, 'DK', 'Sorø Kommune', 1, 'soro-kommune', 55.48268000, 11.55693000),
(1030898, 1001528, 'DK', 'Stege', 1, 'stege', 54.98704000, 12.28461000),
(1030899, 1001528, 'DK', 'Stenlille', 1, 'stenlille', 55.53888000, 11.59120000),
(1030901, 1001528, 'DK', 'Stevns Kommune', 1, 'stevns-kommune', 55.33373000, 12.30692000),
(1030905, 1001528, 'DK', 'Store Heddinge', 1, 'store-heddinge', 55.30965000, 12.38885000),
(1030911, 1001528, 'DK', 'Strøby Egede', 1, 'stroby-egede', 55.41382000, 12.24502000),
(1030912, 1001528, 'DK', 'Stubbekøbing', 1, 'stubbekobing', 54.88875000, 12.04102000),
(1030914, 1001528, 'DK', 'Sundby', 1, 'sundby', 54.76711000, 11.84979000),
(1030916, 1001528, 'DK', 'Svebølle', 1, 'svebolle', 55.65183000, 11.28658000),
(1030921, 1001528, 'DK', 'Svinninge', 1, 'svinninge', 55.72111000, 11.46547000),
(1030922, 1001528, 'DK', 'Svogerslev', 1, 'svogerslev', 55.63423000, 12.01465000),
(1030949, 1001528, 'DK', 'Tølløse', 1, 'tollose', 55.61250000, 11.77034000),
(1030945, 1001528, 'DK', 'Tune', 1, 'tune', 55.59287000, 12.16968000),
(1030974, 1001528, 'DK', 'Viby', 1, 'viby', 55.54872000, 12.02391000),
(1030979, 1001528, 'DK', 'Vindinge', 1, 'vindinge', 55.62298000, 12.13870000),
(1030980, 1001528, 'DK', 'Vipperød', 1, 'vipperod', 55.66768000, 11.73967000),
(1030985, 1001528, 'DK', 'Vordingborg', 1, 'vordingborg', 55.00801000, 11.91057000),
(1030986, 1001528, 'DK', 'Vordingborg Kommune', 1, 'vordingborg-kommune', 55.01383000, 12.10008000);

