text: insert into city values
  (4122327,"Mound City","US",-90.129257,35.190369),
  (4935951,"Essex County","US",-70.832832,42.666759),
  (4405434,"Republic","US",-93.480186,37.120049),
  (5078878,"Shelton","US",-98.730911,40.779179),
  (5551665,"Arizona City","US",-111.670959,32.75589),
  (4368320,"Saint Mary's County","US",-76.616348,38.300129),
  (7208522,"Pin Oak Village","US",-95.803001,29.7665),
  (4578104,"Fairtraid","US",-78.979477,33.873779),
  (4341377,"Sheltons","US",-91.907349,32.8293),
  (4422833,"Country Club Subdivision","US",-88.806442,33.423458),
  (4712711,"Mount Enterprise","US",-94.681038,31.91795),
  (5424865,"Hermosa","US",-107.835342,37.415279),
  (5363907,"La Fetra","US",-117.881447,34.138901),
  (5064432,"Boone County","US",-98.083672,41.700008),
  (7201401,"Carlyle West","US",-73.830559,42.935558),
  (5139023,"South Westerlo","US",-74.027077,42.447861),
  (4461697,"Contentnea Junction","US",-77.93248,35.678211),
  (4475980,"Lincoln Heights","US",-77.904709,35.69405),
  (4527720,"Waterloo","US",-82.784897,39.83979),
  (5268838,"Richfield","US",-88.193977,43.256119),
  (4599503,"Vaughans Crossroads","US",-80.102287,34.208771),
  (4421547,"Choctaw County","US",-89.237572,33.340401),
  (5312572,"Saint David","US",-110.214241,31.904249),
  (4723416,"Rockwell","US",-95.549683,33.591221),
  (4919277,"Cook","US",-87.469757,41.377258),
  (4985016,"Barry County","US",-85.316673,42.60004),
  (3911925,"La Paz","BO",-68.150002,-16.5),
  (5273134,"Sidney","US",-90.638748,44.552738),
  (4494053,"Sunny View","US",-82.187889,35.374279),
  (4988619,"Cheboygan County","US",-84.500587,45.450008),
  (4913764,"Tomahawk Bluff","US",-89.08342,41.380589),
  (4290651,"Dykes","US",-84.435768,37.068138),
  (7247870,"Cozy Acres","US",-81.63694,40.658329),
  (5723848,"Drake Crossing","US",-122.655922,44.925961),
  (5564102,"Gas Point","US",-122.534462,40.415428),
  (4926474,"Sloan","US",-87.476128,40.301979),
  (5340687,"Creston","US",-120.523773,35.51886),
  (4364519,"Oliver Beach","US",-76.342743,39.37289),
  (7839805,"Melbourne","AU",144.944214,-37.813061),
  (2158177,"Melbourne","AU",144.963318,-37.813999),
  (6619279,"City of Sydney","AU",151.208435,-33.867779),
  (2148876,"South Yarra","AU",144.983337,-37.833328),
  (2146268,"Toowoomba","AU",151.966675,-27.549999),
  (7839478,"Cambridge","AU",115.798866,-31.935419),
  (2150767,"Ryde","AU",151.100006,-33.816669),
  (2155384,"Newtown","AU",143.649994,-37.700001),
  (2149975,"Seaford","AU",145.133331,-38.099998),
  (2177089,"Ballarat North","AU",143.772842,-37.518841),
  (7839740,"Ku-ring-gai","AU",151.148773,-33.727009),
  (2074113,"Collie","AU",116.150002,-33.366669),
  (2142501,"Yarra Junction","AU",145.616669,-37.783329),
  (2158868,"Manly","AU",153.183334,-27.466669),
  (7839796,"Kingston","AU",145.095306,-38.004501),
  (2154787,"Nowra","AU",150.600006,-34.883331),
  (7839760,"Oberon","AU",149.817947,-33.84531),
  (2206089,"Sandy Bay","AU",147.35318,-42.912998),
  (7839461,"Tatiara","AU",140.507477,-36.222321),
  (2178174,"Albury","AU",146.916672,-36.083328),
  (2146899,"The Patch","AU",145.383331,-37.900002),
  (7839602,"Manjimup","AU",116.265663,-34.597889),
  (2162419,"Jannali","AU",151.066666,-34.01667),
  (2151134,"Rosebank","AU",153.399994,-28.66667),
  (2170318,"Corinda","AU",152.983337,-27.533331),
  (2144332,"Wauchope","AU",152.733337,-31.450001),
  (7839593,"Mackay","AU",149.042648,-21.08189),
  (7932620,"Elwood","AU",144.983047,-37.881699),
  (7839648,"Barossa","AU",138.961685,-34.61351),
  (2142330,"Yenda","AU",146.183334,-34.25),
  (2070185,"Hallett","AU",138.883331,-33.400002),
  (2176031,"Berwick","AU",145.350006,-38.033329),
  (2151522,"Riverstone","AU",150.866669,-33.683331),
  (7839477,"Busselton","AU",115.370796,-33.684769),
  (2143285,"Wodonga","AU",146.883331,-36.116669),
  (2077347,"Balaklava","AU",138.416672,-34.150002),
  (2154913,"Northmead","AU",150.983337,-33.783329),
  (2169866,"Croydon North","AU",145.300003,-37.783329),
  (2147381,"Taree","AU",152.466675,-31.9),
  (2161415,"Kilmore","AU",144.949997,-37.299999),
  (2158922,"Mandalong","AU",151.433334,-33.133331),
  (2142777,"Wyee","AU",151.483337,-33.183331),
  (2160413,"Leeton","AU",146.399994,-34.566669),
  (2143074,"Woodleigh","AU",145.633331,-38.400002),
  (2079019,"Cervantes","AU",115.063889,-30.500561),
  (2059539,"Utakarra","AU",114.650002,-28.783331),
  (6573030,"Namhyang-dong","KR",127.021393,37.283611),
  (1842936,"Kinho","KR",126.714172,37.623611),
  (6800892,"Sup’yŏng-dong","KR",127.143501,37.594601),
  (6800397,"P’ungnap-tong","KR",127.1185,37.5368),
  (1844533,"Hamyang","KR",127.727661,35.519379),
  (1894616,"Okinawa","JP",127.801392,26.335831),
  (1862818,"Higashi-horidōri","JP",139.050003,37.916672),
  (2111220,"Sakura","JP",140.233337,35.716671),
  (1856717,"Miyazaki-shi","JP",131.423889,31.91111),
  (1860797,"Kaigandōri","JP",133.916672,34.666672),
  (1852524,"Shijōdōri","JP",135.763031,35.00378),
  (2112923,"Fukushima-shi","JP",140.467773,37.75),
  (1856697,"Miyoshi","JP",137.066666,35.083328),
  (1856524,"Motoichiba","JP",138.649994,35.150002),
  (1849876,"Toyama-shi","JP",137.211395,36.695278),
  (1854629,"Ogori","JP",131.399994,34.099998),
  (1856900,"Mitsugarasuchō","JP",135.833328,34.666672),
  (1862415,"Hiroshima-shi","JP",132.459366,34.396271),
  (1860483,"Kami-nagarekawachō","JP",132.449997,34.400002),
  (1863130,"Harisakichō","JP",137.149994,34.916672),
  (1855891,"Nakamura","JP",132.933334,32.98333),
  (1863641,"Gifu-shi","JP",136.760391,35.422909),
  (1862197,"Honjōchō","JP",136.75,35.416672),
  (1853574,"Otsu-shi","JP",135.868332,35.00444),
  (2128295,"Sapporo-shi","JP",141.346939,43.064171),
  (2130658,"Aomori-shi","JP",140.740005,40.82444),
  (1857550,"Matsue-shi","JP",133.050568,35.472221),
  (1856789,"Miyake","JP",135.550003,34.583328),
  (1856177,"Nagasaki-shi","JP",129.873611,32.74472),
  (1862554,"Hiradogoyamachi","JP",129.866669,32.75),
  (1851100,"Takamatsu-shi","JP",134.043335,34.340279),
  (2128815,"Obihiro","JP",143.204437,42.917221),
  (1855863,"Nakano","JP",138.366669,36.75),
  (1863219,"Hanawadamachi","JP",139.883331,36.549999),
  (1855265,"Nishikichō","JP",138.566666,35.650002),
  (1852607,"Shibata","JP",139.333328,37.950001),
  (1853045,"Sambashidōri","JP",133.550003,33.549999),
  (1857594,"Masuda","JP",131.850006,34.666672),
  (1855944,"Nakaichi","JP",131.483337,34.166672),
  (1865103,"Arita","JP",129.899994,33.183331),
  (1863822,"Furukawabashi","JP",135.600006,34.73333),
  (1850314,"Tōbō","JP",129.933334,33.48333),
  (1857140,"Minami-senjumachi","JP",139.816666,35.73333),
  (1853188,"Sakaidechō","JP",133.850006,34.316669),
  (1863683,"Ganiko","JP",127.75351,26.25601),
  (1849519,"Tsuyama","JP",134,35.049999),
  (1850152,"Tokuyama","JP",131.816666,34.049999),
  (1926020,"Uwajima","JP",132.560013,33.223751),
  (1858296,"Kure","JP",132.566666,34.23333),
  (1856243,"Nagahama","JP",136.266663,35.383331),
  (1926108,"Komatsu","JP",133.116669,33.883331),
  (2114009,"Nishikawa","JP",140.176392,38.926109),
  (2128574,"Otaru","JP",141.002213,43.189442),
  (1849831,"Toyooka","JP",134.833328,35.533329),
  (1859492,"Kikuchi","JP",130.816666,32.98333),
  (1896348,"Hikari","JP",131.949997,33.955002),
  (1859908,"Kashiwazaki","JP",138.550003,37.366669),
  (2129163,"Mombetsu","JP",143.352493,44.352501),
  (1850523,"Tateyama","JP",139.866669,34.98333),
  (1848706,"Yamae","JP",130.566666,33.466671),
  (1849977,"Toriimatsu","JP",136.966675,35.23333),
  (2111127,"Shibayama","JP",140.433334,35.683331),
  (1852788,"Sekigahara","JP",136.466675,35.366669),
  (1858333,"Kuradani","JP",135.333328,35.450001),
  (1857922,"Kyōguchi","JP",135.333328,35.450001),
  (1864180,"Enzan","JP",138.733337,35.700001),
  (1849713,"Tsukaguchi","JP",135.416672,34.75),
  (2110774,"Togane","JP",140.366669,35.549999),
  (1863173,"Hanyu","JP",139.533325,36.166672),
  (1850708,"Tanabe","JP",135.366669,33.73333),
  (1863276,"Hamanose","JP",135.149994,33.883331),
  (1854444,"Ojiya","JP",138.800003,37.299999),
  (1861207,"Iwakura","JP",136.866669,35.283329),
  (1857089,"Minatomachi","JP",130.449997,33.033329),
  (1857343,"Mifune","JP",130.800003,32.716671),
  (1853662,"Otake","JP",132.216675,34.200001),
  (1859716,"Kawai","JP",135.850006,34.23333),
  (2128333,"Samani","JP",142.919174,42.121941),
  (2129447,"Koshimizu","JP",144.459717,43.853329),
  (2112370,"Kanegasaki","JP",141.116669,39.200001),
  (1855987,"Nakagawa","JP",137.033325,35.066669),
  (2110506,"Yokote","JP",140.566666,39.299999),
  (2128983,"Nayoro","JP",142.457779,44.350559),
  (1856434,"Murakami","JP",139.483337,38.23333),
  (1847996,"Zaōmachi","JP",138.850006,37.450001),
  (1860635,"Kameoka","JP",135.583328,35),
  (1850762,"Tamagawa","JP",139.666672,38.033329),
  (1858492,"Kudoyama","JP",135.566666,34.283329),
  (7302983,"芦屋","JP",135.30719,34.733921),
  (1861202,"Iwami","JP",134.533325,34.783329),
  (1853338,"Sabae","JP",136.184982,35.946468),
  (1851079,"Takamori","JP",131.116669,32.816669),
  (1861853,"Iijima","JP",137.883331,35.299999),
  (1862998,"Hayakawa","JP",138.350006,35.450001),
  (1855585,"Narusawa","JP",138.733337,35.75),
  (1854691,"Ogano","JP",139,36.01667),
  (2112455,"Kakuda","JP",140.783325,37.966671),
  (1849237,"Uozu","JP",137.399994,36.799999),
  (1861838,"Iiyama","JP",138.366669,36.849998),
  (1863917,"Fukuyama","JP",133.366669,34.48333),
  (1850892,"Takayama","JP",137.25,36.133331),
  (1849845,"Toyokawa","JP",137.399994,34.816669),
  (1853237,"Saiki","JP",131.899994,32.950001),
  (2113698,"Kahoku","JP",141.321671,38.51667),
  (1865485,"Akashichō","JP",139.783325,35.666672),
  (1848040,"Yūrakuchō","JP",139.766663,35.666672),
  (6415253,"Kawasaki","JP",136.064438,35.65694),
  (2112062,"Kurosawajiri","JP",141.116669,39.283329),
  (1855623,"Nanukaichi","JP",133.466675,34.599998),
  (2130705,"Akabira","JP",142.053055,43.551392),
  (1853412,"Renjakuchō","JP",139.066666,36.383331),
  (1860039,"Kariwa","JP",138.61879,37.429749),
  (1863475,"Habu","JP",130.699997,33.816669),
  (1851713,"Shobara","JP",133.016663,34.849998),
  (1856938,"Mitake","JP",137.133331,35.416672),
  (1858067,"Kusatsu","JP",135.966675,35.01667),
  (1864009,"Fukuchiyama","JP",135.116669,35.299999),
  (1850589,"Tarumizu","JP",130.699997,31.48333),
  (2128710,"Oku-ikutahara","JP",143.516663,43.849998),
  (2130700,"Akaigawa","JP",140.817215,43.083328),
  (1850217,"Tokamachi","JP",138.766663,37.133331),
  (1855363,"Nirasaki","JP",138.449997,35.700001),
  (2127586,"Urakawa","JP",142.783615,42.15556),
  (2128498,"Pippu","JP",142.473892,43.869438),
  (2128215,"Shari","JP",144.659439,43.90556),
  (1852984,"Sanjo","JP",138.949997,37.616669),
  (1854807,"Obita","JP",129.883331,32.816669),
  (2127652,"Toyokoro","JP",143.533325,42.816669),
  (2129387,"Kuromatsunai","JP",140.306107,42.66806),
  (1849347,"Uken","JP",129.233337,28.299999),
  (2130387,"Engaru","JP",143.522217,44.054169),
  (1848764,"Yakage","JP",133.583328,34.616669),
  (1863837,"Furugen","JP",127.751106,26.368589),
  (1856488,"Mugi","JP",134.416672,33.666672),
  (2130389,"Embetsu","JP",141.788895,44.707218),
  (2128139,"Shimokawa","JP",142.636383,44.28944),
  (1849073,"Utazu","JP",133.816666,34.299999),
  (1863866,"Funato","JP",135.316666,34.25),
  (1865312,"Anamizu","JP",136.899994,37.23333),
  (1848528,"Yanohama","JP",136.199997,34.066669),
  (1864894,"Awara","JP",136.192368,36.223091),
  (1854026,"Ono","JP",134.933334,34.849998),
  (2111559,"Obanazawa","JP",140.401947,38.603329),
  (2111325,"Otawara","JP",140.033325,36.866669),
  (1848705,"Yamaga","JP",130.683334,33.01667),
  (1926006,"Iyo","JP",132.701385,33.751389),
  (1926055,"Ozu","JP",132.550003,33.5),
  (2130106,"Higashikawa","JP",141.783325,44.23333),
  (1862752,"Higashi-ōsaka","JP",135.583328,34.666672),
  (2127545,"Utashinai","JP",142.050003,43.51667),
  (2128159,"Shimizu","JP",142.88472,43.006111),
  (2127731,"Tomamae","JP",141.654434,44.305279),
  (1848935,"Wake","JP",134.133331,34.799999),
  (1894619,"Urazoe","JP",127.70639,26.25444),
  (2129696,"Kamoenai","JP",140.434433,43.138329),
  (1861305,"Itano","JP",133.783325,34.01667),
  (1276533,"Belgaum","IN",74.5,15.86667),
  (1269920,"Hubli","IN",75.166672,15.35),
  (1278647,"Union Territory of Andaman and Nicobar Islands","IN",92.675171,11.70065),
  (1259385,"Port Blair","IN",92.75,11.66667),
  (1254710,"Tezpur","IN",92.800003,26.633329),
  (7533612,"Kowloon City","HK",114.191208,22.328659),
  (1619638,"Ban Fai Kaeo","TH",100.800003,18.76667),
  (6455273,"Amiens","FR",2.3,49.900002),
  (6441375,"Strasbourg","FR",7.75,48.583328),
  (6451976,"Nanterre","FR",2.20714,48.891842),
  (2989247,"Département de l'Orne","FR",0.08333,48.666672),
  (6452018,"Créteil","FR",2.46667,48.783329),
  (6455341,"Saint-Denis","FR",2.36667,48.933331),
  (6440000,"Clermont-Ferrand","FR",3.08333,45.783329),
  (3024635,"Clermont-Ferrand","FR",3.08628,45.779659),
  (2973384,"Arrondissement de Tarbes","FR",0.16667,43.25),
  (6454430,"Clermont","FR",2.4,49.383331),
  (6440996,"Perpignan","FR",2.89541,42.697639),
  (3029094,"Département du Calvados","FR",-0.5,49.166672),
  (6456407,"Le Mans","FR",0.2,48),
  (3003603,"Le Mans","FR",0.2,48),
  (6454251,"Reims","FR",4.0292,49.265099),
  (6452436,"Argentan","FR",-0.01667,48.75),
  (2983360,"Arrondissement de Roanne","FR",4,46),
  (6613992,"Roanne","FR",4.06667,46.033329),
  (6453924,"Landerneau","FR",-4.25,48.450001),
  (3034005,"Arrondissement de Beauvais","FR",2,49.416672),
  (2968819,"Ville-dAvray","FR",2.19311,48.823582),
  (6443660,"Fontainebleau","FR",2.7,48.400002),
  (3027453,"Chamalieres","FR",3.0631,45.775589),
  (6453805,"Saint-Brieuc","FR",-2.78333,48.51667),
  (2990371,"Département de la Nièvre","FR",3.5,47.083328),
  (3006414,"La Seyne-sur-Mer","FR",5.88472,43.098179),
  (6454207,"Coutances","FR",-1.43333,49.049999),
  (3022826,"Coutances","FR",-1.43333,49.049999),
  (2993358,"Mondeville","FR",-0.32238,49.174969),
  (6453923,"Yèvres","FR",1.1906,48.2103),
  (6454554,"Saverne","FR",7.36127,48.74176),
  (6454301,"Lunéville","FR",6.5024,48.589199),
  (2985020,"Arrondissement du Puy","FR",3.83333,45.083328),
  (6449052,"Coubon","FR",3.91754,44.997372),
  (3023379,"Coubon","FR",3.91783,44.997311),
  (3026612,"Arrondissement de Charleville-Mézières","FR",4.5,49.833328),
  (3031676,"Arrondissement de Bonneville","FR",6.66667,46),
  (6435667,"Sotteville","FR",-1.75,49.533329),
  (2983423,"Riva-Bella","FR",-0.26054,49.287708),
  (2979071,"Arrondissement de Saint-Julien-en-Genevois","FR",6.08333,46.083328),
  (6433846,"Labenne","FR",-1.41667,43.599998),
  (3029799,"Bruges","FR",-0.61219,44.87981),
  (6432490,"Tresses","FR",-0.46667,44.849998),
  (3010626,"Lacanau","FR",-1.0762,44.977791),
  (3020034,"Arrondissement d'Épinal","FR",6.5,48.166672),
  (3016474,"Gavray","FR",-1.3506,48.911079),
  (3034873,"Baron-sur-Odon","FR",-0.47795,49.13221),
  (2990139,"Arrondissement de Nontron","FR",0.83333,45.5),
  (3032668,"Biguglia","FR",9.43324,42.625889),
  (2982692,"Rots","FR",-0.47319,49.212349),
  (3038333,"Arrondissement d'Ajaccio","FR",8.91667,42),
  (3022569,"Crepy-en-Valois","FR",2.88807,49.233589),
  (6432503,"Virelade","FR",-0.3808,44.6661),
  (1506418,"Gonba","RU",83.574699,53.417198),
  (1506676,"Gari","RU",62.34967,59.43074),
  (1506938,"Erzin","RU",95.1623,50.261002),
  (1507172,"Dubinino","RU",89.09111,55.619171),
  (1507638,"Chunoyar","RU",97.321671,57.446671),
  (1507745,"Choya","RU",86.5467,52.010799),
  (1507801,"Chistogorskiy","RU",87.3843,53.983501),
  (1507926,"Chesma","RU",60.653332,53.811111),
  (1508636,"Burla","RU",78.330101,53.336201),
  (1510131,"Beya","RU",90.913887,53.053329),
  (1510370,"Belyy Yar","RU",85.042503,58.444721),
  (1510817,"Barzas","RU",86.316673,55.716671),
  (1120863,"Zarghun Shahr","AF",68.445732,32.84734),
  (1120879,"Zarah Sharan","AF",68.791672,33.146671),
  (1121418,"Yahya Khel","AF",68.646217,32.93742),
  (1122068,"Tormay","AF",68.401672,33.687222),
  (1130131,"Qalat","AF",66.908333,32.105751),
  (1138636,"Kalakan","AF",69.150009,34.78371),
  (1143782,"Dwah Manday","AF",69.584999,33.28167),
  (1144040,"Darqad","AF",69.452942,37.38414),
  (1146979,"Barg-e Matal","AF",71.343391,35.672829),
  (1147511,"Bagrami","AF",69.274269,34.493759),
  (1148114,"Alaqahdari Atghar","AF",67.357399,31.73506),
  (1148709,"Anar Darah","AF",61.653969,32.758701),
  (1148939,"Ali Khel","AF",69.719078,33.942532),
  (1429499,"Shayrwani-ye Bala","AF",69.599342,35.014679),
  (1434016,"Alaqahdari Sarobi","AF",69.086601,32.793308),
  (1435007,"Zerok-Alakadari","AF",69.312782,33.158058),
  (1437517,"Khayr Kot","AF",68.449722,32.85355),
  (1455430,"Dahan-e Jarf","AF",68.464172,34.927219),
  (1456960,"Maidan Shahr","AF",68.86618,34.395611),
  (1464922,"Pul-e Hisar","AF",69.471336,35.617939),
  (1468514,"Pas Pul","AF",70.61586,37.474072),
  (3576361,"Bolands","AG",-61.87466,17.065651),
  (363320,"Konispol","AL",20.181391,39.65889),
  (782632,"Kurbnesh","AL",20.083611,41.77972),
  (783214,"Fushe-Arrez","AL",20.01667,42.062222),
  (3184197,"Selenice","AL",19.63583,40.53056),
  (3184388,"Puke","AL",19.899719,42.044441),
  (3184575,"Orikum","AL",19.47139,40.325279),
  (3184702,"Milot","AL",19.715561,41.683891),
  (3188434,"Uzice","RS",19.84878,43.858608),
  (3026227,"Chateauneuf-les-Martigues","FR",5.16667,43.383331),
  (6448871,"Castandet","FR",-0.35,43.799999),
  (3172394,"Napoli","IT",14.25,40.833328),
  (6536522,"Sesto San Giovanni","IT",9.24175,45.539371),
  (3167961,"San Michele di Pagana","IT",9.23564,44.352982),
  (3182748,"Province of Ascoli Piceno","IT",13.55306,42.88443),
  (6542154,"Taranto","IT",17.240101,40.417019),
  (3172656,"Montoggio","IT",9.04816,44.517448),
  (3167431,"Sant’Anna","IT",10.48333,43.833328),
  (3168673,"Salerno","IT",14.76599,40.677971),
  (6536153,"Seriate","IT",9.72286,45.68338),
  (6540063,"Vittoria","IT",14.53318,36.953739),
  (6539606,"Asti","IT",8.20684,44.897949),
  (6541469,"Trento","IT",11.12074,46.070431),
  (6540107,"Viterbo","IT",12.10856,42.417831),
  (3173845,"Martignacco","IT",13.13778,46.09639),
  (6540390,"Castelfranco Veneto","IT",11.926,45.676102),
  (3170622,"Pisticci","IT",16.556789,40.390621),
  (6538566,"Sesto Fiorentino","IT",11.19522,43.834549),
  (3174658,"Provincia di Livorno","IT",10.58333,43.23333),
  (6541852,"Rovigo","IT",11.79301,45.079979),
  (3165197,"Trezzo sullAdda","IT",9.51995,45.602982),
  (3172980,"Montecchio Emilia","IT",10.44709,44.701359),
  (2525755,"Alcamo","IT",12.95654,37.998348),
  (6536781,"Senigallia","IT",13.21667,43.709259),
  (6538612,"Assisi","IT",12.61646,43.069141),
  (2524393,"Licata","IT",13.94607,37.10714),
  (6541465,"Vicenza","IT",11.5409,45.557289),
  (6542122,"Pisa","IT",10.4137,43.710838),
  (3174096,"Manduria","IT",17.633511,40.401821),
  (2523045,"Soverato Marina","IT",16.54991,38.684978),
  (6458615,"Provincia di Crotone","IT",17.081341,39.120071),
  (6541463,"Crotone","IT",17.117809,39.085098),
  (2524881,"Crotone","IT",17.117809,39.085098),
  (6539766,"Ferentino","IT",13.2564,41.69532),
  (3177102,"Ferentino","IT",13.2564,41.69532),
  (6542118,"Chieti","IT",14.16773,42.3503),
  (3178796,"Chieti","IT",14.13801,42.360939),
  (6541116,"Spoleto","IT",12.73737,42.744839),
  (3166236,"Spoleto","IT",12.73737,42.744839),
  (3175444,"Provincia di Isernia","IT",14.25,41.666672),
  (6536505,"Cologno Monzese","IT",9.27635,45.535671),
  (6539672,"Sarzana","IT",9.95859,44.11145),
  (3167104,"Sarzana","IT",9.95859,44.11145),
  (3181995,"Bitonto","IT",16.689381,41.110828),
  (6538456,"Mirandola","IT",11.0662,44.886768),
  (3180749,"Caorle","IT",12.8758,45.596561),
  (6539859,"Gioia Tauro","IT",15.899,38.423969),
  (6538674,"Genzano di Roma","IT",12.69178,41.701321),
  (6540287,"Fiumicino","IT",12.24747,41.76281),
  (2524237,"Mascali","IT",15.19589,37.75576),
  (6539444,"Domodossola","IT",8.28962,46.11348),
  (6540110,"Matera","IT",16.60158,40.668522),
  (6538946,"Putignano","IT",17.12129,40.85183),
  (6538943,"Gravina in Puglia","IT",16.422779,40.819721),
  (6540781,"Acri","IT",16.383789,39.492901),
  (3182966,"San Michele","IT",11.26178,46.45472),
  (6540671,"Alba","IT",8.02564,44.69154),
  (3179542,"Castelnuovo","IT",13.53333,43.400002),
  (2524085,"Monreale","IT",13.28854,38.080051),
  (6541098,"Montevarchi","IT",11.56893,43.527649),
  (6541032,"Imola","IT",11.71582,44.352268),
  (6536054,"Casale Monferrato","IT",8.45714,45.133362),
  (6539037,"Corigliano Calabro","IT",16.5177,39.595001),
  (2524929,"Corigliano Calabro","IT",16.5177,39.595001),
  (3175385,"Ivrea","IT",7.87617,45.466869),
  (6539211,"Lentini","IT",14.99959,37.28545),
  (6536709,"Sala Baganza","IT",10.23178,44.720261),
  (6541462,"Rieti","IT",12.85918,42.40723),
  (3169412,"Rieti","IT",12.85918,42.40723),
  (3182628,"Avilla","IT",13.7,42.650002),
  (6537243,"Avio","IT",10.93718,45.733791),
  (3182625,"Avio","IT",10.93718,45.733791),
  (2523890,"Pantelleria","IT",11.95,36.833328),
  (6538451,"Castelvetro di Modena","IT",10.9464,44.50576),
  (2523557,"Salemi","IT",12.80564,37.823139),
  (6535904,"Lana - Lana","IT",11.15587,46.612419),
  (3175177,"Lana","IT",11.15587,46.612419),
  (6540386,"Thiene","IT",11.47959,45.708801),
  (2522718,"Vita","IT",12.82504,37.870541),
  (6538323,"Scorzè","IT",12.10991,45.569),
  (3182918,"Arceto","IT",10.71667,44.616669),
  (6541168,"Torre Annunziata","IT",14.46464,40.74971),
  (3172086,"Olbia Marittima","IT",9.50528,40.922401),
  (6536871,"Deruta","IT",12.41506,42.980438),
  (3165612,"Todi","IT",12.40456,42.779942),
  (3178131,"Corato","IT",16.41387,41.145531),
  (6536698,"Cormons","IT",13.46534,45.956921),
  (6540134,"Savigliano","IT",7.65593,44.644039),
  (3180563,"Carbonera","IT",12.28833,45.680561),
  (6541812,"Marano di Valpolicella","IT",10.91518,45.55579),
  (6536506,"Cormano","IT",9.17094,45.53957),
  (3165119,"Tufo","IT",13.76667,41.26667),
  (3180916,"Camposanto","IT",11.1429,44.786968),
  (3172379,"Nardo","IT",18.02972,40.175121),
  (6541923,"Atri","IT",13.9848,42.577839),
  (6536651,"Susegana","IT",12.25351,45.856209),
  (3182633,"Avigliano","IT",15.72004,40.73291),
  (6536661,"Santa Maria di Sala","IT",12.03531,45.507999),
  (6536948,"Formello","IT",12.40027,42.08252),
  (3176739,"Formello","IT",12.39979,42.080132),
  (3172240,"Noci","IT",17.131701,40.79073),
  (3166426,"Soliera","IT",10.9263,44.737968),
  (3163836,"Zula","IT",11.33333,44.349998),
  (6538018,"Poggio a Caiano","IT",11.05072,43.813648),
  (3170487,"Poggio a Caiano","IT",11.05072,43.813648),
  (3178263,"Colorno","IT",10.37678,44.92627),
  (6536328,"Ronchi dei Legionari","IT",13.50424,45.82832),
  (6537163,"Breno","IT",10.30476,45.95779),
  (6537088,"Somma Lombardo","IT",8.70873,45.682968),
  (3167062,"Sasso Marconi","IT",11.24951,44.39946),
  (6537231,"Castel Goffredo","IT",10.47538,45.29858),
  (3179675,"Castel Goffredo","IT",10.47538,45.29858),
  (3181094,"Camerino","IT",13.06917,43.139851),
  (6539656,"Castellabate","IT",14.95645,40.2817),
  (3167551,"Santa Maria di Castellabate","IT",14.95,40.283329),
  (6541644,"Seravezza","IT",10.2287,43.995041),
  (3166168,"Stellata","IT",11.41667,44.883331),
  (6539726,"Loreto","IT",13.60978,43.43536),
  (3174567,"Loreto","IT",13.60978,43.43536),
  (2523113,"Siderno","IT",16.302,38.277882),
  (6537787,"Butera","IT",14.18367,37.19104),
  (6539861,"Monasterace","IT",16.55201,38.453678),
  (2523998,"Noto","IT",15.06929,36.890141),
  (6537585,"Carpignano Salentino","IT",18.338329,40.196918),
  (3166662,"Serrano","IT",18.35,40.183331),
  (6539927,"Montagnana","IT",11.4635,45.22868),
  (3176328,"Ganna","IT",8.81667,45.900002),
  (6539612,"Carro","IT",9.60888,44.272148),
  (3182057,"Bibione","IT",13.05389,45.63583),
  (6538424,"Langhirano","IT",10.26559,44.612659),
  (6543726,"Ronago","IT",8.98364,45.832279),
  (6537804,"Adrano","IT",14.83478,37.661751),
  (2525616,"Bagnara Calabra","IT",15.8078,38.288471),
  (6536808,"Fivizzano","IT",10.12599,44.23835),
  (3182479,"Baio Dora","IT",7.83333,45.5),
  (3170589,"Pizzolo","IT",9.61667,44.349998),
  (6536523,"Trezzano sul Naviglio","IT",9.06644,45.423069),
  (6541877,"San Benedetto del Tronto","IT",13.88569,42.934849),
  (3168550,"San Benedetto del Tronto","IT",13.88157,42.945621),
  (3178709,"Cigliano","IT",8.02102,45.308361),
  (6536662,"Santo Stino di Livenza","IT",12.68232,45.729912),
  (6536846,"San Giovanni Valdarno","IT",11.53183,43.56345),
  (6539110,"Castellammare del Golfo","IT",12.88584,38.018848),
  (6539156,"Novara di Sicilia","IT",15.13188,38.015961),
  (3168521,"San Biagio di Callalta","IT",12.37722,45.683609),
  (6536329,"Savogna d'Isonzo","IT",13.57474,45.906422),
  (3169980,"Pra","IT",8.79001,44.427528),
  (3170752,"Pieve di Cento","IT",11.30761,44.712269),
  (2712995,"Gamla Staden","SE",13,55.599998),
  (2687700,"Nykoping","SE",17.007879,58.752998),
  (602150,"Umea","SE",20.25972,63.828419),
  (2662881,"Vimmerby","SE",15.85515,57.665878),
  (2724227,"Åvik","SE",17.1,61.73333),
  (8012855,"Cedofeita","PT",-8.62244,41.158352),
  (8012597,"Pontinha","PT",-9.20377,38.777),
  (2742031,"Distrito de Braga","PT",-8.41667,41.583328),
  (8010417,"Aveiro","PT",-8.61628,40.623981),
  (2261956,"Valejas","PT",-9.26549,38.735001),
  (8010459,"Vizela","PT",-8.2931,41.37529),
  (8012966,"Tramagal","PT",-8.25987,39.443241),
  (2262540,"Tramagal","PT",-8.25,39.450001),
  (8011143,"Fafe","PT",-8.17333,41.44698),
  (8012715,"Rio Tinto","PT",-8.55954,41.176891),
  (8010550,"Marinha Grande","PT",-8.95005,39.77681),
  (8011327,"Ribeirão","PT",-8.56012,41.361649),
  (8010587,"Penafiel","PT",-8.28972,41.159599),
  (2740519,"Cortegaca","PT",-8.6213,40.94883),
  (8014836,"Borda do Campo","PT",-8.75771,40.050621),
  (8010546,"Caldas da Rainha","PT",-9.10242,39.409809),
  (2739055,"Gatões","PT",-8.66221,41.212662),
  (2263919,"Riba Fria","PT",-8.9936,39.416939),
  (8012434,"Ventosa","PT",-9.09361,39.123291),
  (8010449,"Cabeceiras de Basto","PT",-7.97198,41.52079),
  (8011197,"Mascotelos","PT",-8.30995,41.425571),
  (8014395,"Armação de Pêra","PT",-8.36463,37.115799),
  (408687,"Líndos","GR",28.085711,36.091019),
  (255683,"Patra","GR",21.73444,38.244438),
  (8133812,"Dimos Kalymnos","GR",26.991211,36.987148),
  (8133988,"Dimos Pylos-Nestoras","GR",21.779409,36.916351),
  (253343,"Spiliá","GR",20.48333,38.166672),
  (8133759,"Dimos Rethymno","GR",24.487341,35.315041),
  (733901,"Vergina","GR",22.31361,40.48111),
  (8133695,"Dimos Chersonisos","GR",25.34346,35.28577),
  (8133857,"Dimos Eordaia","GR",21.71814,40.522541),
  (7297375,"The Gorge","GB",-2.47239,52.635288),
  (2652708,"Coalbrookdale","GB",-2.49174,52.63821),
  (2647601,"Borough of Halton","GB",-2.75,53.333328),
  (2634311,"Weston Point","GB",-2.75649,53.32642),
  (2650236,"Edgbaston","GB",-1.92115,52.462299),
  (7291997,"Newbury","GB",-1.32067,51.390831),
  (7290590,"Lincoln District","GB",-0.55664,53.220119),
  (2635586,"Town Moor","GB",-1.61667,54.98333),
  (2656196,"Basford","GB",-1.18333,52.966671),
  (2646253,"Ince-in-Makerfield","GB",-2.61667,53.533329),
  (2647516,"Hanwell","GB",-0.33517,51.518089),
  (2644100,"Llanelli","GB",-4.16191,51.68195),
  (2657480,"Allesley","GB",-1.57157,52.426048),
  (3333187,"Richmond upon Thames","GB",-0.33333,51.416672),
  (2655984,"Belfast","GB",-5.93333,54.583328),
  (3333229,"City of Edinburgh","GB",-3.19333,55.94973),
  (3333136,"Borough of Bury","GB",-2.33333,53.583328),
  (2641557,"Newton Abbot","GB",-3.61186,50.52858),
  (3333161,"Borough of Kirklees","GB",-1.75,53.583328),
  (3333137,"Borough of Calderdale","GB",-2,53.700001),
  (2635028,"Vale of Glamorgan","GB",-3.41667,51.416672),
  (2633462,"Wycombe","GB",-0.9,51.583328),
  (2652586,"Coleraine","GB",-6.66667,55.133331),
  (2634869,"Wallingford","GB",-1.1248,51.599819),
  (2636066,"Thame","GB",-0.97624,51.748402),
  (2654092,"Caernarfon","GB",-4.27016,53.141258),
  (2645093,"Knutsford","GB",-2.37482,53.302891),
  (7295999,"Carmarthen","GB",-4.33155,51.856049),
  (2653755,"Carmarthen","GB",-4.30535,51.855518),
  (7292911,"Huntingdon","GB",-0.18646,52.34251),
  (2657060,"Armagh","GB",-6.66667,54.349998),
  (7291791,"Northwood","GB",-1.31093,50.739151),
  (2641217,"Northwood","GB",-1.31192,50.74102),
  (7292855,"Crowthorne","GB",-0.77353,51.375),
  (7292770,"Finchampstead","GB",-0.866,51.371929),
  (2649445,"Finchampstead","GB",-0.85728,51.361488),
  (7298372,"Truro","GB",-5.05831,50.263691),
  (2635412,"Truro","GB",-5.05436,50.265259),
  (2656913,"Ash Vale","GB",-0.72115,51.26997),
  (2655049,"Bowness-on-Windermere","GB",-2.91859,54.363312),
  (3333239,"Bridgend county borough","GB",-3.58333,51.549999),
  (7292974,"Leighton-Linslade","GB",-0.66606,51.917469),
  (7290663,"Barrow-in-Furness District","GB",-3.22326,54.128849),
  (3333152,"Borough of Hartlepool","GB",-1.25,54.666672),
  (3333236,"South Lanarkshire","GB",-3.83333,55.583328),
  (2647570,"Hamilton","GB",-4.03333,55.76667),
  (7290586,"Hinckley and Bosworth District","GB",-1.38402,52.60778),
  (2656039,"Bedlington","GB",-1.59319,55.130611),
  (2636518,"Sunninghill","GB",-0.65557,51.401348),
  (2651386,"Denbigh","GB",-3.41667,53.183331),
  (7294638,"Penzance","GB",-5.54554,50.105862),
  (2640377,"Penzance","GB",-5.53715,50.11861),
  (7290557,"Gosport District","GB",-1.16165,50.806198),
  (3333232,"North Ayrshire","GB",-4.89647,55.696548),
  (2654604,"Brodick","GB",-5.14717,55.57539),
  (7295818,"Meltham","GB",-1.86003,53.589859),
  (2640968,"Omagh District","GB",-7.25,54.583328),
  (2640967,"Omagh","GB",-7.3,54.599998),
  (7292970,"Glyncorrwg","GB",-3.64345,51.673939),
  (2657807,"Abergwynfi","GB",-3.6026,51.653549),
  (7292972,"Pelenna","GB",-3.72255,51.656151),
  (2640118,"Pontrhydyfen","GB",-3.74469,51.63435),
  (2642330,"Monkseaton","GB",-1.4659,55.042339),
  (7296375,"Ystalyfera","GB",-3.80508,51.758041),
  (2633337,"Ystalyfera","GB",-3.78082,51.767159),
  (2650941,"Drumcree","GB",-6.46667,54.433331),
  (7296308,"Milford Haven","GB",-5.03444,51.720711),
  (2642534,"Milford Haven","GB",-5.0341,51.71278),
  (3333212,"City and Borough of Wakefield","GB",-1.49895,53.680851),
  (2638035,"Shepton Mallet","GB",-2.54722,51.18972),
  (7300410,"Thorne","GB",-0.92887,53.621189),
  (2635997,"Thorne","GB",-0.96308,53.611221),
  (2636175,"Tavernspite","GB",-4.64111,51.78194),
  (7290622,"West Oxfordshire District","GB",-1.50136,51.839882),
  (2643697,"Long Eaton","GB",-1.27136,52.898548),
  (2649207,"Forfar","GB",-2.89026,56.643131),
  (7297451,"Hungerford","GB",-1.52201,51.41671),
  (2646411,"Hungerford","GB",-1.51556,51.415131),
  (7294533,"Thornbury","GB",-2.55531,52.237991),
  (7299856,"Blaengwrach","GB",-3.62173,51.728111),
  (3345326,"Blaengwrach","GB",-3.63915,51.736851),
  (7295589,"Olney","GB",-0.71375,52.16486),
  (2640972,"Olney","GB",-0.70201,52.15345),
  (7301705,"Harden","GB",-1.87311,53.842739),
  (2639944,"Sir Powys","GB",-3.41667,52.333328),
  (2654818,"Brecon","GB",-3.38601,51.947651),
  (2654817,"Brecon","GB",-3.38887,51.946121),
  (2641910,"Nairn","GB",-3.87973,57.58094),
  (6620335,"Frankby","GB",-3.13703,53.372581),
  (7290624,"Sedgemoor District","GB",-2.9619,51.186409),
  (2639563,"Redcar","GB",-1.05999,54.61657),
  (2643314,"Lyme Regis","GB",-2.93477,50.72654),
  (2647393,"Hartpury","GB",-2.29314,51.924191),
  (2646472,"Hoylake","GB",-3.18066,53.390461),
  (7292301,"Crymych","GB",-4.63719,51.96452),
  (2651796,"Crymych","GB",-4.64722,51.97361),
  (7294618,"Llysfaen","GB",-3.66256,53.28157),
  (2643867,"Llysfaen","GB",-3.66667,53.283329),
  (2650797,"Dumfries and Galloway","GB",-3.83333,55.083328),
  (2657293,"Annan","GB",-3.25647,54.988392),
  (2641331,"Northiam","GB",0.60026,50.994389),
  (7294631,"Marhamchurch","GB",-4.51644,50.79673),
  (2643040,"Marhamchurch","GB",-4.52241,50.80513),
  (6945806,"Shepway District","GB",1.15391,51.081741),
  (2649258,"Folkestone","GB",1.18333,51.083328),
  (2652418,"Cookstown District","GB",-6.66667,54.666672),
  (2652417,"Cookstown","GB",-6.74595,54.643051),
  (2652725,"Clunderwen","GB",-4.73167,51.840561),
  (2634354,"West Lothian","GB",-3.5,55.916672),
  (2656169,"Bathgate","GB",-3.64398,55.902039),
  (2648559,"Glastonbury","GB",-2.71797,51.147289),
  (2646810,"Hodbarrow","GB",-3.25222,54.195381),
  (6949212,"Ham","GB",-0.30933,51.436192),
  (2650725,"Dunglass","GB",-2.36667,55.933331),
  (2646455,"Hugglescote","GB",-1.37179,52.709759),
  (6619866,"East Croydon Railway Station","GB",-0.0925,51.375),
  (2654464,"Bruichladdich","GB",-6.36134,55.766151),
  (7300017,"Lawhitton Rural","GB",-4.32263,50.621391),
  (7301014,"Llanfyllin","GB",-3.31067,52.774261),
  (2644053,"Llanfyllin","GB",-3.27187,52.765701),
  (7298240,"Epworth","GB",-0.83465,53.538929),
  (2642486,"Milnathort","GB",-3.4193,56.226879),
  (2649298,"County of Flintshire","GB",-3.16667,53.25),
  (7301170,"Mostyn","GB",-3.24684,53.31588),
  (2644159,"Llandarcy","GB",-3.85657,51.642262),
  (2640551,"Payhembury","GB",-3.29518,50.80674),
  (7297046,"Llangamarch","GB",-3.58225,52.08548),
  (7295209,"Bala","GB",-3.60141,52.91077),
  (2655692,"Biggar","GB",-3.51667,55.616669),
  (7293134,"North Lodge","GB",-1.55754,54.873711),
  (2646228,"Inchture","GB",-3.16956,56.445511),
  (7293619,"Beddgelert","GB",-4.06923,53.028229),
  (2657340,"Ampney Crucis","GB",-1.905,51.713989),
  (7298755,"Maesycwmmer","GB",-3.21639,51.63755),
  (2638043,"Shepherds Bush","GB",-0.23767,51.51569),
  (2644290,"Little Massingham","GB",0.65888,52.78561),
  (7292365,"Bodedern","GB",-4.49044,53.293251),
  (2652649,"Coedely","GB",-3.4163,51.56189),
  (2616814,"Mølholm","DK",9.54402,55.698959),
  (2620423,"Herning Kommune","DK",9,56.166672),
  (6141256,"Saskatoon","CA",-106.634521,52.116791),
  (6183858,"Wolfville","CA",-64.365463,45.08345),
  (6146143,"Sherbrooke","CA",-71.899078,45.400082),
  (5897321,"Bedford","CA",-63.66732,44.725521),
  (6160752,"Sydney","CA",-60.181751,46.150139),
  (6545041,"Lachine","CA",-73.668991,45.43177),
  (6138517,"Saint John","CA",-66.067657,45.272709),
  (7798683,"New Westminster","CA",-122.91111,49.20694),
  (5886182,"Antigonish","CA",-61.998581,45.616852),
  (6094325,"Orillia","CA",-79.420677,44.608681),
  (6073349,"Midhurst","CA",-79.732941,44.450111),
  (5907166,"Bradford","CA",-79.566322,44.11681),
  (5884051,"Alliston","CA",-79.866348,44.150108),
  (5978353,"Hull","CA",-75.741051,45.4445),
  (5925975,"Collingwood","CA",-80.216377,44.483398),
  (5905308,"Bolton","CA",-79.737907,43.87952),
  (5955895,"Fort McMurray","CA",-111.381027,56.726761),
  (7871301,"Kingsview Village","CA",-79.554657,43.700432),
  (6065566,"Maple","CA",-79.516312,43.850109),
  (6141190,"Sarnia","CA",-82.404068,42.978661),
  (5941602,"Don Mills","CA",-79.332901,43.73341),
  (6185449,"Yennadon","CA",-122.585899,49.232971),
  (6089426,"North Bay","CA",-79.466331,46.316799),
  (5951036,"Fairview","CA",-118.386063,56.06675),
  (6944113,"Mont-Joli","CA",-68.192139,48.583881),
  (6111253,"Portage","CA",-64.06543,46.66684),
  (6095246,"Otway","CA",-114.9188,52.366829),
  (5977783,"Houston","CA",-126.670082,54.399761),
  (6111867,"Port Hawkesbury","CA",-61.34853,45.616852),
  (6126245,"Rockcliffe Park","CA",-75.68264,45.4501),
  (6180550,"Whitehorse","CA",-135.053757,60.71611),
  (6035615,"Lacombe","CA",-113.735298,52.466808),
  (5975503,"Hinton","CA",-117.58567,53.400089),
  (6180285,"Whitecourt","CA",-115.685478,54.15015),
  (5946222,"East Wiltshire","CA",-63.213989,46.254318),
  (6091191,"Norwich","CA",-80.599693,42.983398),
  (5942547,"Drayton Valley","CA",-114.985443,53.21682),
  (6166580,"Tillsonburg","CA",-80.726173,42.859859),
  (6064180,"Magog","CA",-72.149094,45.266781),
  (5964214,"Granby","CA",-72.73243,45.383381),
  (5909294,"Brockville","CA",-75.68264,44.583408),
  (6168768,"Trenton","CA",-77.577553,44.099171),
  (6158027,"Strathroy","CA",-81.622322,42.955101),
  (6122081,"Richmond","CA",-75.832657,45.183399),
  (5965812,"Greater Napanee","CA",-76.94944,44.250118),
  (6050619,"Laval-des-Rapides","CA",-73.699181,45.550079),
  (6139184,"Saint-Vincent-de-Paul","CA",-73.649178,45.616779),
  (6101546,"Perth","CA",-76.24939,44.900108),
  (5937612,"Delson","CA",-73.549171,45.366779),
  (6107761,"Point Edward","CA",-82.399834,43.00008),
  (5890542,"Baie-DUrfe","CA",-73.915863,45.413971),
  (6103581,"Petrolia","CA",-82.149811,42.866779),
  (6170584,"Turtleford","CA",-108.951439,53.38348),
  (6087579,"New Glasgow","CA",-62.648628,45.583439),
  (6095416,"Outlook","CA",-107.051277,51.50008),
  (5916786,"Cardinal","CA",-75.382629,44.783409),
  (6067959,"Mattawa","CA",-78.69957,46.316811),
  (5882142,"Acton Vale","CA",-72.565819,45.65007),
  (5962442,"Goderich","CA",-81.716476,43.75008),
  (6139216,"Saint-Zotique","CA",-74.249237,45.250092),
  (6078636,"Morinville","CA",-113.652031,53.80014),
  (6073749,"Millbrook","CA",-78.449539,44.15012),
  (6137696,"Sainte-Adele","CA",-74.132507,45.950081),
  (6115144,"Queenston","CA",-79.049568,43.166821),
  (6118091,"Redcliff","CA",-110.78495,50.083359),
  (6138815,"Saint-Nazaire","CA",-71.549088,48.583389),
  (5924109,"Cloridorme","CA",-64.91539,49.166801),
  (4006702,"Ensenada","MX",-116.616669,31.866671),
  (4008303,"El Pueblito","MX",-100.449997,20.533331),
  (3514780,"Estado de Veracruz-Llave","MX",-96.666672,19.33333),
  (3992619,"Piedras Negras","MX",-100.51667,28.700001),
  (3522509,"Estado de Oaxaca","MX",-96.5,17),
  (3531732,"Campeche","MX",-90.533333,19.85),
  (4003626,"La Albarrada","MX",-103.716667,19.23333),
  (3998655,"Leon","MX",-101.666672,21.116671),
  (3995523,"Monclova","MX",-101.416672,26.9),
  (3996472,"Mascota","MX",-104.783333,20.51667),
  (4019231,"Estado de Aguascalientes","MX",-102.5,22),
  (3816237,"Ocosingo","MX",-92.038887,16.90556),
  (4000915,"La Partida","MX",-103.283333,25.58333),
  (3530757,"Cholula","MX",-98.30352,19.06406),
  (3988214,"Salamanca","MX",-101.199997,20.566669),
  (3526621,"Jalapa","MX",-95.466667,16.5),
  (3981254,"Torreon","MX",-103.433327,25.549999),
  (6942826,"La Paz","MX",-110.300003,24.133329),
  (4012176,"Culiacan","MX",-107.389717,24.79944),
  (4008420,"El Potosí","MX",-100.316673,24.85),
  (3992212,"Poncitlan","MX",-102.916672,20.366671),
  (3514031,"Zimapan","MX",-99.349998,20.75),
  (3526957,"Huehuetoca","MX",-99.20417,19.84889),
  (3984717,"Santa Ana","MX",-111.116669,30.549999),
  (3514876,"Valladolid","MX",-88.199364,20.68812),
  (3515062,"Tulancingo","MX",-98.366669,20.08333),
  (3515904,"Tepeaca","MX",-97.900002,18.966669),
  (3827341,"Tres Marias","MX",-99.243057,19.052219),
  (4013724,"Ciudad Camargo","MX",-105.166672,27.66667),
  (3527021,"Hualahuises","MX",-99.673332,24.88472),
  (3977811,"Minas de Barroteran","MX",-101.283333,27.633329),
  (3527164,"Halacho","MX",-90.083328,20.48333),
  (4006532,"Esqueda","MX",-109.583328,30.716669),
  (2930817,"Elp","DE",7,51.200001),
  (2911297,"Freie und Hansestadt Hamburg","DE",10,53.583328),
  (2956829,"Altstadt","DE",10,53.549999),
  (2812833,"Weihenstephan","DE",11.73333,48.400002),
  (2939256,"Dambach","DE",10.97363,49.46349),
  (2815239,"Walburger","DE",8.11667,51.583328),
  (2852456,"Landkreis Potsdam-Mittelmark","DE",12.675,52.21944),
  (6547684,"Stahnsdorf","DE",13.1918,52.358501),
  (2829657,"Stahnsdorf","DE",13.21667,52.383331),
  (3249071,"Kreisfreie Stadt Lübeck","DE",10.74361,53.89333),
  (2875601,"Luebeck","DE",10.68729,53.868931),
  (3221033,"Landkreis Hannover","DE",9.74,52.448891),
  (6547528,"Wadgassen","DE",6.78333,49.266701),
  (2837291,"Schneverdingen","DE",9.8,53.116669),
  (2944388,"Bremen","DE",8.80777,53.075161),
  (3220966,"Landkreis Darmstadt-Dieburg","DE",8.75667,49.856392),
  (6553169,"Roßdorf","DE",8.7441,49.862301),
  (2844756,"Rossdorf","DE",8.76167,49.859718),
  (2930220,"Engelshof","DE",7.75,49.450001),
  (2955486,"Arnoldsweiler","DE",6.48992,50.838089),
  (3220811,"Landkreis Landshut","DE",12.18056,48.57056),
  (6556508,"Kumhausen","DE",12.1667,48.5),
  (2882563,"Kumhausen","DE",12.16667,48.5),
  (2814775,"Waldstetten","DE",9.82135,48.766151),
  (2941383,"Bürgerfeld","DE",8.2,53.166672),
  (2895992,"Ingolstadt","DE",11.43333,48.76667),
  (2879690,"Leerort","DE",7.43333,53.216671),
  (2813383,"Wegeleben","DE",11.16667,51.883331),
  (2853304,"Plätz","DE",11.88669,52.738468),
  (2813308,"Wehingen","DE",8.79151,48.145329),
  (3220890,"Kreisfreie Stadt Aschaffenburg","DE",9.14778,49.966942),
  (3221017,"Landkreis Peine","DE",10.26111,52.317219),
  (6557392,"Peine, Stadt","DE",10.23065,52.323299),
  (2885552,"Köppern","DE",8.64967,50.274311),
  (2933789,"Echterdingen","DE",9.16775,48.688438),
  (2905496,"Herzberg am Harz","DE",10.33333,51.650002),
  (2866322,"Netze","DE",9.0941,51.223598),
  (2949078,"Bierstraß","DE",6.1,50.866669),
  (2807465,"Wismar","DE",11.46667,53.900002),
  (6555249,"Maxdorf","DE",8.29167,49.488098),
  (2872686,"Maxdorf","DE",8.29167,49.48806),
  (3220995,"Kreisfreie Stadt Kassel","DE",9.46722,51.32111),
  (2906464,"Hengersberg","DE",13.05,48.783329),
  (2857792,"Offenhausen","DE",10.02258,48.40163),
  (2860051,"Oberknöringen","DE",10.4,48.433331),
  (2839420,"Schierenbrink","DE",8.85,52.166672),
  (2929670,"Erfurt","DE",11.03333,50.98333),
  (2938323,"Delmenhorst","DE",8.61667,53.049999),
  (6556329,"Unterföhring","DE",11.6584,48.1884),
  (2819568,"Unterfohring","DE",11.64293,48.192532),
  (2944012,"Brock","DE",7.78333,51.833328),
  (2934955,"Driesch","DE",7.2,50.799999),
  (2808148,"Windischeschenbach","DE",12.15889,49.799721),
  (2806654,"Wolfsburg","DE",10.8,52.433331),
  (2890155,"Kitzscher","DE",12.56667,51.166672),
  (2948652,"Birkenau","DE",8.70694,49.5625),
  (3220830,"Landkreis Eichstätt","DE",11.37528,48.909168),
  (6556171,"Lenting","DE",11.4667,48.799999),
  (2878751,"Lenting","DE",11.46667,48.799999),
  (2824732,"Sulzgries","DE",9.29804,48.75602),
  (6556320,"Oberschleißheim","DE",11.5677,48.248798),
  (2859147,"Oberschleissheim","DE",11.56667,48.25),
  (3205790,"Brömmenkamp","DE",6.73333,51.566669),
  (6555704,"Ispringen","DE",8.66667,48.916698),
  (2895636,"Ispringen","DE",8.66667,48.916672),
  (2950881,"Berchtesgaden","DE",13,47.633331),
  (2920203,"Glane","DE",8.05,52.150002),
  (2917833,"Greding","DE",11.36139,49.048328),
  (3274966,"Lauda-Konigshofen","DE",9.70417,49.565281),
  (2847686,"Rheden","DE",9.78333,52.066669),
  (2853657,"Kreis Pinneberg","DE",9.75722,53.73444),
  (6551708,"Tangstedt","DE",9.85,53.666698),
  (2824246,"Tangstedt","DE",9.85,53.666672),
  (3220752,"Landkreis Ludwigsburg","DE",9.13333,48.916672),
  (6555489,"Schwieberdingen","DE",9.07451,48.876129),
  (2834226,"Schwieberdingen","DE",9.07439,48.876438),
  (2917698,"Grenzach-Wyhlen","DE",7.68333,47.549999),
  (2812084,"Weisenheim am Sand","DE",8.24778,49.518059),
  (6556312,"Grasbrunn","DE",11.75,48.083302),
  (2918037,"Grasbrunn","DE",11.74361,48.079048),
  (3247458,"Landkreis Neuwied","DE",7.47806,50.53944),
  (6553853,"Rengsdorf","DE",7.5,50.5),
  (2848215,"Rengsdorf","DE",7.5,50.5),
  (2862620,"Nienburg","DE",9.21667,52.633331),
  (2930341,"Engbrück","DE",6.51667,51.183331),
  (2941501,"Burg bei Magdeburg","DE",11.85493,52.271519),
  (2895044,"Jena","DE",11.58333,50.933331),
  (6556231,"Olching","DE",11.32783,48.207829),
  (2907851,"Heidenheim an der Brenz","DE",10.15162,48.677979),
  (6555416,"Denkendorf","DE",9.31847,48.695271),
  (2938253,"Denkendorf","DE",9.31675,48.695549),
  (2948164,"Bitterfeld","DE",12.31667,51.616669),
  (2812502,"Weil im Schonbuch","DE",9.06355,48.6227),
  (2958802,"Alterhofen","DE",12.62012,48.846588),
  (2949803,"Besigheim","DE",9.13333,48.98333),
  (2942187,"Buchwald","DE",14.01667,51.51667),
  (2938540,"Deggendorf","DE",12.96667,48.833328),
  (2918752,"Gotha","DE",10.70193,50.948231),
  (2959927,"Aalen","DE",10.0933,48.837769),
  (2873632,"Marienberg","DE",13.16667,50.650002),
  (2838939,"Schlaitdorf","DE",9.22268,48.604309),
  (2941119,"Burgstall","DE",10.87672,49.550049),
  (2925101,"Freiheit","DE",8.98333,54.76667),
  (2922363,"Gasteig","DE",12.13333,47.783329),
  (7669417,"St. Mang","DE",10.32629,47.71265),
  (2891972,"Keferloh","DE",11.72748,48.095051),
  (6556206,"Kranzberg","DE",11.6167,48.400002),
  (2884739,"Kranzberg","DE",11.61246,48.406132),
  (2892356,"Katrepel","DE",8.91667,53.133331),
  (2873759,"Marburg an der Lahn","DE",8.76667,50.816669),
  (2824801,"Sulzbach-Rosenberg","DE",11.75167,49.498329),
  (2891339,"Ketschendorf","DE",10.96667,50.25),
  (2933618,"Eckersbach","DE",12.5,50.73333),
  (2835421,"Schwaig","DE",11.20111,49.46944),
  (2840293,"Scharnhausen","DE",9.26293,48.70739),
  (2850539,"Ramstein","DE",7.53333,49.450001),
  (2861315,"Oberbehme","DE",8.66667,52.183331),
  (2927939,"Falkenkrug","DE",8.89652,51.933208),
  (2944368,"Bremerhaven","DE",8.58333,53.549999),
  (2821416,"Trebur","DE",8.41611,49.93111),
  (2952406,"Barsinghausen","DE",9.45,52.299999),
  (6555290,"Nieder-Olm","DE",8.21333,49.9142),
  (2863014,"Nieder-Olm","DE",8.20533,49.911659),
  (2837150,"Schöller","DE",7.01667,51.23333),
  (2945358,"Brandenburg an der Havel","DE",12.55,52.416672),
  (2844588,"Rostock","DE",12.14049,54.088699),
  (2814374,"Walthersdorf","DE",12.96667,50.549999),
  (2859846,"Oberlüghausen","DE",7.20154,50.901649),
  (2954804,"Au","DE",12.13333,47.849998),
  (2893237,"Kandern","DE",7.66667,47.716671),
  (2872155,"Meissen","DE",13.4737,51.161579),
  (2813040,"Weiden","DE",12.15667,49.677502),
  (2836089,"Schriesheim","DE",8.67278,49.477779),
  (6554391,"Landscheid","DE",6.76667,49.983299),
  (2881500,"Landscheid","DE",6.76667,49.98333),
  (2948290,"Bischofsheim","DE",8.36722,49.993889),
  (2911144,"Hammerbühl","DE",11.28333,49.700001),
  (2949612,"Beuerlbach","DE",10.09137,49.156391),
  (2847889,"Reußen","DE",12.1,51.083328),
  (2871813,"Mering","DE",10.98461,48.265598),
  (6556951,"Kleinostheim","DE",9.06195,50.002701),
  (2930695,"Elster","DE",12.83333,51.833328),
  (2875014,"Luschendorf","DE",10.73333,54),
  (2849913,"Raunheim","DE",8.45,50.01667),
  (2902942,"Hochstraß","DE",6.65,51.450001),
  (3214112,"Landkreis Waldshut","DE",8.255,47.705559),
  (6555919,"Rickenbach","DE",7.98333,47.616699),
  (2847442,"Rickenbach","DE",7.97873,47.61895),
  (2929350,"Ernst","DE",7.23333,50.150002),
  (2847669,"Rheinau","DE",8.2,48.866669),
  (2928381,"Eutin","DE",10.61667,54.133331),
  (2890957,"Kießling","DE",11.66667,50.416672),
  (2852144,"Preussisch Oldendorf","DE",8.5,52.299999),
  (3220970,"Hochtaunuskreis","DE",8.51694,50.285278),
  (6553182,"Wehrheim","DE",8.5683,50.294498),
  (2915372,"Grosskrotzenburg","DE",8.98333,50.083328),
  (2871705,"Merz","DE",14.35,52.200001),
  (6553143,"Wenden","DE",7.845,50.987999),
  (2847604,"Rhein-Sieg-Kreis","DE",7.26361,50.75861),
  (2812182,"Weingartsgasse","DE",7.28565,50.78838),
  (2803463,"Landkreis Aichach-Friedberg","DE",11.05472,48.417221),
  (2927054,"Feucht","DE",11.21389,49.376671),
  (3247434,"Kreis Neuss","DE",6.65389,51.165279),
  (6556232,"Puchheim","DE",11.35097,48.168999),
  (2858326,"Ochsenhausen","DE",9.95,48.066669),
  (2809191,"Wiesentheid","DE",10.35,49.799999),
  (2934728,"Duderstadt","DE",10.25951,51.513119),
  (2855499,"Papenmoorland","DE",7.95,53.533329),
  (2934495,"Durchhausen","DE",8.68333,48.033329),
  (2930522,"Landkreis Emmendingen","DE",7.88556,48.149719),
  (6555768,"Malterdingen","DE",7.8,48.166698),
  (2928823,"Esseite","DE",7.03333,52.200001),
  (2912266,"Hahnenblecher","DE",7.11667,51.049999),
  (2821878,"Tonning","DE",8.95,54.316669),
  (2933945,"Ebersberg","DE",11.97063,48.077099),
  (6555464,"Kuchen","DE",9.80011,48.63586),
  (2883151,"Kuchen","DE",9.79989,48.63583),
  (2856408,"Osterode","DE",10.81667,51.566669),
  (2891640,"Kempenich","DE",7.13333,50.416672),
  (2841707,"Sandwisch","DE",7.98333,52.400002),
  (6555415,"Deizisau","DE",9.38923,48.713509),
  (2938391,"Deizisau","DE",9.3861,48.7122),
  (2875909,"Lorch","DE",9.6914,48.798328),
  (6555524,"Leingarten","DE",9.1089,49.147449),
  (3220835,"Landkreis Miesbach","DE",11.81611,47.771671),
  (6556281,"Valley","DE",11.7833,47.900002),
  (2817904,"Valley","DE",11.77915,47.893101),
  (2861814,"Northeim","DE",10,51.700001),
  (6556895,"Schwarzenbruck","DE",11.25175,49.360199),
  (2834955,"Schwarzenbruck","DE",11.24333,49.35778),
  (2890278,"Kirrweiler","DE",8.16556,49.301941),
  (2827574,"Stelle","DE",10.11138,53.384159),
  (2953336,"Bad Sooden-Allendorf","DE",9.98333,51.283329),
  (2808277,"Windberg","DE",6.33333,51.299999),
  (2829456,"Landkreis Starnberg","DE",11.29583,48.014999),
  (6556387,"Gauting","DE",11.3834,48.066399),
  (2953775,"Babelsberg","DE",13.1,52.400002),
  (2903240,"Hochfeld","DE",6.96667,51.666672),
  (6555723,"Loßburg","DE",8.45,48.400002),
  (2875815,"Lossburg","DE",8.45,48.400002),
  (2908828,"Häuser","DE",10.26667,47.549999),
  (2916611,"Grossenkneten","DE",8.26667,52.950001),
  (6556307,"Aschheim","DE",11.72255,48.171902),
  (2829318,"Staufen im Breisgau","DE",7.73333,47.883331),
  (6553312,"Hümmel","DE",6.78333,50.466702),
  (2864869,"Neuhofen","DE",8.42472,49.42778),
  (2867198,"Nagel","DE",11.91667,49.98333),
  (2949694,"Bettingerbrück","DE",6.85,49.433331),
  (2812626,"Weilburg","DE",8.25,50.48333),
  (2946001,"Börstel","DE",8.75,52.216671),
  (2951843,"Bayerisch Gmain","DE",12.9,47.716671),
  (2848104,"Reppinghausen","DE",7.53333,51.083328),
  (2933792,"Echte","DE",10.06667,51.783329),
  (2859002,"Obersölden","DE",13.48333,48.583328),
  (2908552,"Hebel","DE",9.38333,51.066669),
  (2903624,"Hirschhorn","DE",7.68333,49.51667),
  (2850615,"Rampoldsdorf","DE",12.25,48.466671),
  (2856816,"Ostbevern","DE",7.85,52.049999),
  (2841460,"Sankt Wilhelmshütte","DE",8.36667,51.450001),
  (2930350,"Enerke","DE",7.38333,51.366669),
  (3208415,"Borg","DE",7.26667,52.366669),
  (2925545,"Franken Vorstadt","DE",13.1,54.299999),
  (2841693,"Sangerhausen","DE",11.3,51.466671),
  (2887240,"Knautnaundorf","DE",12.27113,51.25375),
  (2876952,"Linz am Rhein","DE",7.28333,50.566669),
  (2867310,"Mutterstadt","DE",8.35611,49.441391),
  (2906159,"Herchenrath","DE",7.36667,50.883331),
  (6555568,"Gerstetten","DE",10.0195,48.624599),
  (2920896,"Gerstetten","DE",10.03333,48.633331),
  (6555629,"Hügelsheim","DE",8.11667,48.799999),
  (6554594,"Reiff","DE",6.2,50.099998),
  (2827238,"Stetten","DE",9.68106,48.259602);