INSERT INTO ville VALUES(01030,01480,01,'Beauregard',46.011079,4.825067);
INSERT INTO ville VALUES(01200,01450,01,'Labalme',46.134638,5.445570);
INSERT INTO ville VALUES(01202,01150,01,'Lagnieu',45.868047,5.351671);
INSERT INTO ville VALUES(01203,01290,01,'Laiz',46.248375,4.884713);
INSERT INTO ville VALUES(01204,01130,01,'Lalleyriat',46.188127,5.700599);
INSERT INTO ville VALUES(01205,01200,01,'Lancrans',46.108030,5.805865);
INSERT INTO ville VALUES(01206,01430,01,'Lantenay',46.087974,5.545260);
INSERT INTO ville VALUES(01207,01330,01,'Lapeyrouse',45.990500,5.016713);
INSERT INTO ville VALUES(01208,01350,01,'Lavours',45.852517,5.752835);
INSERT INTO ville VALUES(01209,01200,01,'Léaz',46.108030,5.805865);
INSERT INTO ville VALUES(01210,01410,01,'Lélex',46.287341,5.926876);
INSERT INTO ville VALUES(01211,01240,01,'Lent',46.093439,5.089657);
INSERT INTO ville VALUES(01212,01560,01,'Lescheroux',46.436993,5.129014);
INSERT INTO ville VALUES(01213,01150,01,'Leyment',45.868047,5.351671);
INSERT INTO ville VALUES(01214,01450,01,'Leyssard',46.134638,5.445570);
INSERT INTO ville VALUES(01215,01420,01,'Lhôpital',45.989058,5.777951);
INSERT INTO ville VALUES(01216,01680,01,'Lhuis',45.772091,5.547192);
INSERT INTO ville VALUES(01218,01260,01,'Lochieu',45.994992,5.691790);
INSERT INTO ville VALUES(01219,01680,01,'Lompnas',45.772091,5.547192);
INSERT INTO ville VALUES(01221,01260,01,'Lompnieu',45.994992,5.691790);
INSERT INTO ville VALUES(01224,01360,01,'Loyettes',45.829453,5.165046);
INSERT INTO ville VALUES(01225,01090,01,'Lurcy',46.091566,4.800463);
INSERT INTO ville VALUES(01285,01600,01,'Parcieux',45.948897,4.801143);
INSERT INTO ville VALUES(01286,01300,01,'Parves',45.723066,5.663965);
INSERT INTO ville VALUES(02057,02110,02,'Beaurevoir',49.997775,3.307917);
INSERT INTO ville VALUES(02374,02420,02,'Lehaucourt',49.919412,3.279444);
INSERT INTO ville VALUES(02400,02880,02,'Laffaux',49.448436,3.425370);
INSERT INTO ville VALUES(02401,02140,02,'Laigny',49.857661,3.854371);
INSERT INTO ville VALUES(02402,02590,02,'Lanchy',49.826730,3.076547);
INSERT INTO ville VALUES(02403,02120,02,'Landifay-et-Bertaignemont',49.818447,3.605238);
INSERT INTO ville VALUES(02404,02140,02,'Landouzy-la-Cour',49.846999,3.982265);
INSERT INTO ville VALUES(02405,02140,02,'Landouzy-la-Ville',49.861451,4.046852);
INSERT INTO ville VALUES(02406,02380,02,'Landricourt',49.507965,3.366221);
INSERT INTO ville VALUES(02407,02000,02,'Laniscourt',49.547264,3.594231);
INSERT INTO ville VALUES(02408,02000,02,'Laon',49.564746,3.624245);
INSERT INTO ville VALUES(02409,02150,02,'Lappion',49.609057,3.966059);
INSERT INTO ville VALUES(02410,02600,02,'Largny-sur-Automne',49.260104,3.042684);
INSERT INTO ville VALUES(02411,02210,02,'Latilly',49.154537,3.310436);
INSERT INTO ville VALUES(02412,02210,02,'Launoy',49.264357,3.399701);
INSERT INTO ville VALUES(02413,02860,02,'Laval-en-Laonnois',49.501226,3.594206);
INSERT INTO ville VALUES(02414,02450,02,'Lavaqueresse',49.948415,3.710980);
INSERT INTO ville VALUES(02415,02600,02,'Laversine',49.259907,3.126420);
INSERT INTO ville VALUES(02416,02140,02,'Lemé',49.836848,3.763694);
INSERT INTO ville VALUES(02417,02420,02,'Lempire',49.991583,3.171540);
INSERT INTO ville VALUES(02418,02260,02,'Lerzy',49.944151,3.881048);
INSERT INTO ville VALUES(02419,02170,02,'Leschelles',49.958430,3.770085);
INSERT INTO ville VALUES(02420,02100,02,'Lesdins',49.865446,3.295765);
INSERT INTO ville VALUES(02421,02220,02,'Lesges',49.307483,3.509749);
INSERT INTO ville VALUES(02422,02120,02,'Lesquielles-Saint-Germain',49.931985,3.619555);
INSERT INTO ville VALUES(02423,02380,02,'Leuilly-sous-Coucy',49.478878,3.357800);
INSERT INTO ville VALUES(02424,02880,02,'Leury',49.430212,3.337508);
INSERT INTO ville VALUES(02425,02500,02,'Leuze',49.851291,4.161552);
INSERT INTO ville VALUES(02426,02420,02,'Levergies',49.928296,3.310619);
INSERT INTO ville VALUES(02427,02220,02,'Lhuys',49.281489,3.556100);
INSERT INTO ville VALUES(02428,02810,02,'Licy-Clignon',49.100101,3.274301);
INSERT INTO ville VALUES(02429,02860,02,'Lierval',49.484601,3.615678);
INSERT INTO ville VALUES(02430,02350,02,'Liesse-Notre-Dame',49.609714,3.803632);
INSERT INTO ville VALUES(02431,02700,02,'Liez',49.691742,3.289916);
INSERT INTO ville VALUES(02432,02220,02,'Limé',49.322187,3.547329);
INSERT INTO ville VALUES(02433,02340,02,'Lislet',49.685733,4.022003);
INSERT INTO ville VALUES(02434,02320,02,'Lizy',49.514653,3.481182);
INSERT INTO ville VALUES(02435,02500,02,'Logny-lès-Aubenton',49.885004,4.095893);
INSERT INTO ville VALUES(02438,02600,02,'Longpont',49.273208,3.219766);
INSERT INTO ville VALUES(02439,02160,02,'Longueval-Barbonval',49.358756,3.653537);
INSERT INTO ville VALUES(02440,02190,02,'Lor',49.456011,3.961780);
INSERT INTO ville VALUES(02441,02600,02,'Louâtre',49.256821,3.247178);
INSERT INTO ville VALUES(02442,02130,02,'Loupeigne',49.250521,3.535589);
INSERT INTO ville VALUES(02443,02400,02,'Lucy-le-Bocage',49.054323,3.392283);
INSERT INTO ville VALUES(02444,02140,02,'Lugny',49.781344,3.808870);
INSERT INTO ville VALUES(02445,02500,02,'Luzoir',49.925552,3.961966);
INSERT INTO ville VALUES(02446,02440,02,'Ly-Fontaine',49.734972,3.307477);
INSERT INTO ville VALUES(02581,02220,02,'Paars',49.328255,3.600154);
INSERT INTO ville VALUES(02582,02160,02,'Paissy',49.424841,3.700456);
INSERT INTO ville VALUES(02583,02860,02,'Pancy-Courtecon',49.473500,3.654199);
INSERT INTO ville VALUES(02584,02260,02,'Papleux',50.021300,3.884238);
INSERT INTO ville VALUES(02585,02210,02,'Parcy-et-Tigny',49.270758,3.320430);
INSERT INTO ville VALUES(02586,02360,02,'Parfondeval',49.739057,4.159728);
INSERT INTO ville VALUES(02587,02840,02,'Parfondru',49.527619,3.711202);
INSERT INTO ville VALUES(02588,02160,02,'Pargnan',49.391813,3.733859);
INSERT INTO ville VALUES(02589,02000,02,'Pargny-Filain',49.547264,3.594231);
INSERT INTO ville VALUES(02590,02330,02,'Pargny-la-Dhuys',48.953777,3.553368);
INSERT INTO ville VALUES(02591,02270,02,'Pargny-les-Bois',49.726125,3.623697);
INSERT INTO ville VALUES(02592,02240,02,'Parpeville',49.784234,3.547135);
INSERT INTO ville VALUES(02593,02200,02,'Pasly',49.402238,3.296597);
INSERT INTO ville VALUES(02594,02470,02,'Passy-en-Valois',49.167971,3.193777);
INSERT INTO ville VALUES(02595,02850,02,'Passy-sur-Marne',49.060280,3.572852);
INSERT INTO ville VALUES(02596,02310,02,'Pavant',48.950840,3.285365);
INSERT INTO ville VALUES(03134,03500,03,'Laféline',46.349488,3.167496);
INSERT INTO ville VALUES(03135,03450,03,'Lalizolle',46.157005,3.001115);
INSERT INTO ville VALUES(03136,03380,03,'Lamaids',46.302596,2.431191);
INSERT INTO ville VALUES(03137,03150,03,'Langy',46.267286,3.469829);
INSERT INTO ville VALUES(03138,03120,03,'Lapalisse',46.249591,3.638865);
INSERT INTO ville VALUES(03139,03250,03,'Laprugne',45.986328,3.741845);
INSERT INTO ville VALUES(03140,03310,03,'Lavault-Sainte-Anne',46.309764,2.599846);
INSERT INTO ville VALUES(03141,03250,03,'Lavoine',45.978431,3.697489);
INSERT INTO ville VALUES(03142,03130,03,'Lenax',46.298287,3.816385);
INSERT INTO ville VALUES(03143,03360,03,'Lételon',46.656568,2.586962);
INSERT INTO ville VALUES(03144,03130,03,'Liernolles',46.394341,3.752209);
INSERT INTO ville VALUES(03145,03410,03,'Lignerolles',46.280919,2.567825);
INSERT INTO ville VALUES(03146,03320,03,'Limoise',46.677255,3.052456);
INSERT INTO ville VALUES(03147,03130,03,'Loddes',46.288124,3.765487);
INSERT INTO ville VALUES(03148,03500,03,'Loriges',46.269130,3.347003);
INSERT INTO ville VALUES(03149,03500,03,'Louchy-Montfand',46.306779,3.244692);
INSERT INTO ville VALUES(03150,03350,03,'Louroux-Bourbonnais',46.534045,2.840050);
INSERT INTO ville VALUES(03151,03600,03,'Louroux-de-Beaune',46.292841,2.854587);
INSERT INTO ville VALUES(03152,03330,03,'Louroux-de-Bouble',46.225629,2.978845);
INSERT INTO ville VALUES(03153,03190,03,'Louroux-Hodement',46.461700,2.714350);
INSERT INTO ville VALUES(03154,03130,03,'Luneau',46.363370,3.951179);
INSERT INTO ville VALUES(03155,03320,03,'Lurcy-Lévis',46.704403,2.921731);
INSERT INTO ville VALUES(03156,03230,03,'Lusigny',46.588092,3.491950);
INSERT INTO ville VALUES(03203,03230,03,'Paray-le-Frésil',46.655024,3.611505);
INSERT INTO ville VALUES(03204,03500,03,'Paray-sous-Briailles',46.290751,3.364734);
INSERT INTO ville VALUES(04099,04170,04,'Lambruisse',44.047854,6.442995);
INSERT INTO ville VALUES(04100,04540,04,'Larche',44.237674,1.831587);
INSERT INTO ville VALUES(04101,04230,04,'Lardiers',44.057237,5.712435);
INSERT INTO ville VALUES(04102,04340,04,'Lauzet-Ubaye',44.383954,6.409380);
INSERT INTO ville VALUES(04104,04300,04,'Limans',43.985167,5.731002);
INSERT INTO ville VALUES(04106,04700,04,'Lurs',43.968849,5.890050);
INSERT INTO ville VALUES(04144,04120,04,'Palud-sur-Verdon',43.828020,6.480860);
INSERT INTO ville VALUES(05069,05300,05,'Lagrand',44.340768,5.755946);
INSERT INTO ville VALUES(05070,05300,05,'Laragne-Montéglin',44.314194,5.823569);
INSERT INTO ville VALUES(05071,05110,05,'Lardier-et-Valença',44.435159,5.981098);
INSERT INTO ville VALUES(05072,05500,05,'Laye',44.640974,6.086025);
INSERT INTO ville VALUES(05073,05300,05,'Lazer',44.348246,5.837250);
INSERT INTO ville VALUES(05074,05130,05,'Lettret',44.468273,6.061955);
INSERT INTO ville VALUES(06074,06450,06,'Lantosque',43.974382,7.311444);
INSERT INTO ville VALUES(06075,06670,06,'Levens',43.859914,7.227583);
INSERT INTO ville VALUES(06076,06260,06,'Lieuche',43.995992,7.015854);
INSERT INTO ville VALUES(06077,06440,06,'Lucéram',43.882691,7.359132);
INSERT INTO ville VALUES(07112,07600,07,'Labastide-sur-Bésorgues',44.724912,4.302020);
INSERT INTO ville VALUES(07113,07150,07,'Labastide-de-Virac',44.350917,4.402184);
INSERT INTO ville VALUES(07114,07570,07,'Labatie-d''Andaure',45.024964,4.494979);
INSERT INTO ville VALUES(07115,07120,07,'Labeaume',44.448737,4.307151);
INSERT INTO ville VALUES(07116,07200,07,'Labégude',44.648247,4.368286);
INSERT INTO ville VALUES(07117,07230,07,'Lablachère',44.463941,4.214878);
INSERT INTO ville VALUES(07118,07110,07,'Laboule',44.587908,4.165273);
INSERT INTO ville VALUES(07119,07470,07,'Lac-d''Issarlès',44.817702,4.070295);
INSERT INTO ville VALUES(07120,07530,07,'Lachamp-Raphaël',44.809830,4.290680);
INSERT INTO ville VALUES(07121,07470,07,'Lachapelle-Graillouse',44.812533,4.019886);
INSERT INTO ville VALUES(07122,07200,07,'Lachapelle-sous-Aubenas',44.564568,4.363965);
INSERT INTO ville VALUES(07123,07310,07,'Lachapelle-sous-Chanéac',44.947889,4.330771);
INSERT INTO ville VALUES(07124,07520,07,'Lafarre',45.079545,4.509105);
INSERT INTO ville VALUES(07126,07150,07,'Lagorce',44.446958,4.417165);
INSERT INTO ville VALUES(07127,07380,07,'Lalevade-d''Ardèche',44.648022,4.324477);
INSERT INTO ville VALUES(07128,07520,07,'Lalouvesc',45.119221,4.535885);
INSERT INTO ville VALUES(07129,07270,07,'Lamastre',44.985832,4.579671);
INSERT INTO ville VALUES(07130,07660,07,'Lanarce',44.729550,4.002192);
INSERT INTO ville VALUES(07131,07200,07,'Lanas',44.606614,4.378947);
INSERT INTO ville VALUES(07132,07110,07,'Largentière',44.540693,4.292018);
INSERT INTO ville VALUES(07133,07220,07,'Larnas',44.447406,4.598722);
INSERT INTO ville VALUES(07134,07110,07,'Laurac-en-Vivarais',44.509006,4.290521);
INSERT INTO ville VALUES(07135,07590,07,'Laval-d''Aurelle',44.565026,3.959774);
INSERT INTO ville VALUES(07136,48250,07,'Laveyrune',44.631654,3.894813);
INSERT INTO ville VALUES(07137,07660,07,'Lavillatte',44.744258,3.952234);
INSERT INTO ville VALUES(07138,07170,07,'Lavilledieu',44.575299,4.453314);
INSERT INTO ville VALUES(07139,07530,07,'Laviolle',44.762874,4.337374);
INSERT INTO ville VALUES(07140,07300,07,'Lemps',45.108296,4.764205);
INSERT INTO ville VALUES(07141,07200,07,'Lentillères',44.613175,4.313329);
INSERT INTO ville VALUES(07142,07660,07,'Lespéron',44.730386,3.897789);
INSERT INTO ville VALUES(07143,07340,07,'Limony',45.352188,4.757614);
INSERT INTO ville VALUES(07144,07110,07,'Loubaresse',44.552080,4.190264);
INSERT INTO ville VALUES(07145,07170,07,'Lussas',44.611474,4.473191);
INSERT INTO ville VALUES(07146,07000,07,'Lyas',44.758385,4.598527);
INSERT INTO ville VALUES(07170,07410,07,'Pailharès',45.078484,4.565668);
INSERT INTO ville VALUES(07171,07230,07,'Payzac',44.451886,4.148786);
INSERT INTO ville VALUES(08242,08800,08,'Laifour',49.912873,4.692303);
INSERT INTO ville VALUES(08243,08460,08,'Lalobbe',49.668776,4.376162);
INSERT INTO ville VALUES(08244,08130,08,'Lametz',49.500634,4.590372);
INSERT INTO ville VALUES(08245,08250,08,'Lançon',49.312063,4.881366);
INSERT INTO ville VALUES(08246,08240,08,'Landres-et-Saint-Georges',49.352176,5.011201);
INSERT INTO ville VALUES(08247,08600,08,'Landrichamps',50.110974,4.826586);
INSERT INTO ville VALUES(08248,08430,08,'Launois-sur-Vence',49.653417,4.536364);
INSERT INTO ville VALUES(08249,08150,08,'Laval-Morency',49.831169,4.491009);
INSERT INTO ville VALUES(08250,08310,08,'Leffincourt',49.387004,4.546742);
INSERT INTO ville VALUES(08251,08150,08,'Lépron-les-Vallées',49.760850,4.453517);
INSERT INTO ville VALUES(08252,08210,08,'Létanne',49.544868,5.080142);
INSERT INTO ville VALUES(08254,08290,08,'Liart',49.769448,4.339863);
INSERT INTO ville VALUES(08255,08110,08,'Linay',49.615300,5.222775);
INSERT INTO ville VALUES(08256,08400,08,'Liry',49.366933,4.681583);
INSERT INTO ville VALUES(08257,08150,08,'Logny-Bogny',49.777407,4.398668);
INSERT INTO ville VALUES(08259,08400,08,'Longwé',49.366933,4.681583);
INSERT INTO ville VALUES(08260,08150,08,'Lonny',49.816325,4.588729);
INSERT INTO ville VALUES(08261,08390,08,'Louvergny',49.551986,4.738953);
INSERT INTO ville VALUES(08262,08300,08,'Lucquy',49.539006,4.476552);
INSERT INTO ville VALUES(08263,08440,08,'Lumes',49.736145,4.782448);
INSERT INTO ville VALUES(08338,08310,08,'Pauvres',49.410823,4.491346);
INSERT INTO ville VALUES(09147,09700,09,'Labatut',43.261364,1.517213);
INSERT INTO ville VALUES(09148,09160,09,'Lacave',43.040337,0.996544);
INSERT INTO ville VALUES(09149,09200,09,'Lacourt',42.944722,1.174269);
INSERT INTO ville VALUES(09150,09500,09,'Lagarde',43.049000,1.935782);
INSERT INTO ville VALUES(09151,09130,09,'Lanoux',43.118857,1.422830);
INSERT INTO ville VALUES(09152,09400,09,'Lapège',42.828852,1.581614);
INSERT INTO ville VALUES(09153,09500,09,'Lapenne',43.145518,1.750684);
INSERT INTO ville VALUES(09154,09240,09,'Larbont',42.991678,1.397678);
INSERT INTO ville VALUES(09155,09310,09,'Larcat',42.778587,1.660059);
INSERT INTO ville VALUES(09156,09310,09,'Larnat',42.799358,1.631754);
INSERT INTO ville VALUES(09157,09600,09,'Laroque-d''Olmes',42.970817,1.874072);
INSERT INTO ville VALUES(09158,09230,09,'Lasserre',43.069526,1.170508);
INSERT INTO ville VALUES(09159,09310,09,'Lassur',42.769553,1.735954);
INSERT INTO ville VALUES(09160,09300,09,'Lavelanet',42.934906,1.849883);
INSERT INTO ville VALUES(09161,09600,09,'Léran',42.989043,1.909126);
INSERT INTO ville VALUES(09162,09220,09,'Lercoul',42.770822,1.547447);
INSERT INTO ville VALUES(09163,09100,09,'Lescousse',43.153461,1.512815);
INSERT INTO ville VALUES(09164,09420,09,'Lescure',43.001035,1.240787);
INSERT INTO ville VALUES(09165,09300,09,'Lesparrou',42.930355,1.905675);
INSERT INTO ville VALUES(09166,09300,09,'Leychert',42.944493,1.728273);
INSERT INTO ville VALUES(09167,09210,09,'Lézat-sur-Lèze',43.275786,1.345909);
INSERT INTO ville VALUES(09168,09300,09,'Lieurac',42.982065,1.789433);
INSERT INTO ville VALUES(09169,09600,09,'Limbrassac',43.016775,1.842439);
INSERT INTO ville VALUES(09170,09700,09,'Lissac',43.269363,1.512135);
INSERT INTO ville VALUES(09171,09250,09,'Lordat',42.775865,1.751360);
INSERT INTO ville VALUES(09172,09350,09,'Loubaut',43.188938,1.284071);
INSERT INTO ville VALUES(09173,09120,09,'Loubens',43.045398,1.546509);
INSERT INTO ville VALUES(09174,09000,09,'Loubières',42.951647,1.568610);
INSERT INTO ville VALUES(09175,09100,09,'Ludiès',43.116256,1.604889);
INSERT INTO ville VALUES(09176,09250,09,'Luzenac',42.763425,1.763661);
INSERT INTO ville VALUES(09224,09130,09,'Pailhès',43.102043,1.443609);
INSERT INTO ville VALUES(09225,09100,09,'Pamiers',43.116003,1.610795);
INSERT INTO ville VALUES(09289,09190,09,'Lorp-Sentaraille',43.009790,1.118665);
INSERT INTO ville VALUES(10185,10210,10,'Lagesse',48.021373,4.132904);
INSERT INTO ville VALUES(10186,10120,10,'Laines-aux-Bois',48.232916,3.988320);
INSERT INTO ville VALUES(10187,10110,10,'Landreville',48.073979,4.473277);
INSERT INTO ville VALUES(10188,10210,10,'Lantages',48.072843,4.212727);
INSERT INTO ville VALUES(10189,10500,10,'Lassicourt',48.442636,4.488467);
INSERT INTO ville VALUES(10190,10270,10,'Laubressel',48.297934,4.213649);
INSERT INTO ville VALUES(10191,10150,10,'Lavau',48.324710,4.087613);
INSERT INTO ville VALUES(10192,10330,10,'Lentilles',48.483770,4.610526);
INSERT INTO ville VALUES(10193,10500,10,'Lesmont',48.427666,4.413681);
INSERT INTO ville VALUES(10194,10200,10,'Lévigny',48.243064,4.701906);
INSERT INTO ville VALUES(10195,10700,10,'Lhuître',48.570966,4.248118);
INSERT INTO ville VALUES(10196,10130,10,'Lignières',47.951244,3.966203);
INSERT INTO ville VALUES(10197,10200,10,'Lignol-le-Château',48.223386,4.808760);
INSERT INTO ville VALUES(10198,10320,10,'Lirey',48.156970,4.050418);
INSERT INTO ville VALUES(10199,10110,10,'Loches-sur-Ource',48.064199,4.503094);
INSERT INTO ville VALUES(10200,10140,10,'Loge-aux-Chèvres',48.245834,4.471510);
INSERT INTO ville VALUES(10201,10210,10,'Loge-Pomblin',48.029528,4.126684);
INSERT INTO ville VALUES(10202,10210,10,'Loges-Margueron',48.029528,4.126684);
INSERT INTO ville VALUES(10203,10310,10,'Longchamp-sur-Aujon',48.149138,4.831711);
INSERT INTO ville VALUES(10204,10320,10,'Longeville-sur-Mogne',48.148854,4.059922);
INSERT INTO ville VALUES(10205,10140,10,'Longpré-le-Sec',48.187139,4.523417);
INSERT INTO ville VALUES(10206,10240,10,'Longsols',48.430838,4.288491);
INSERT INTO ville VALUES(10207,10170,10,'Longueville-sur-Aube',48.493701,3.926860);
INSERT INTO ville VALUES(10208,10400,10,'Louptière-Thénard',48.474365,3.513942);
INSERT INTO ville VALUES(10209,10270,10,'Lusigny-sur-Barse',48.254814,4.268510);
INSERT INTO ville VALUES(10210,10150,10,'Luyères',48.381341,4.194814);
INSERT INTO ville VALUES(10276,10160,10,'Paisy-Cosdon',48.244756,3.708638);
INSERT INTO ville VALUES(10277,10190,10,'Palis',48.286828,3.708603);
INSERT INTO ville VALUES(10278,10210,10,'Pargues',48.031568,4.198154);
INSERT INTO ville VALUES(10279,10330,10,'Pars-lès-Chavanges',48.507361,4.497671);
INSERT INTO ville VALUES(10280,10100,10,'Pars-lès-Romilly',48.484816,3.731140);
INSERT INTO ville VALUES(10281,10350,10,'Pavillon-Sainte-Julie',48.369916,3.898565);
INSERT INTO ville VALUES(10282,10600,10,'Payns',48.379484,3.983237);
INSERT INTO ville VALUES(11178,11320,11,'Labastide-d''Anjou',43.346158,1.851140);
INSERT INTO ville VALUES(11179,11220,11,'Labastide-en-Val',43.076207,2.473197);
INSERT INTO ville VALUES(11180,11380,11,'Labastide-Esparbairenque',43.380797,2.394303);
INSERT INTO ville VALUES(11181,11400,11,'Labécède-Lauragais',43.391521,2.006172);
INSERT INTO ville VALUES(11182,11310,11,'Lacombe',43.397210,2.232583);
INSERT INTO ville VALUES(11183,11250,11,'Ladern-sur-Lauquet',43.104564,2.351543);
INSERT INTO ville VALUES(11184,11420,11,'Lafage',43.174196,1.863707);
INSERT INTO ville VALUES(11185,11220,11,'Lagrasse',43.090470,2.619735);
INSERT INTO ville VALUES(11186,11330,11,'Lairière',43.015345,2.484900);
INSERT INTO ville VALUES(11187,11330,11,'Lanet',42.964415,2.496524);
INSERT INTO ville VALUES(11188,11480,11,'Palme',42.967706,2.988822);
INSERT INTO ville VALUES(11189,11390,11,'Laprade',43.442733,2.258959);
INSERT INTO ville VALUES(11191,11330,11,'Laroque-de-Fa',42.956434,2.565000);
INSERT INTO ville VALUES(11192,11400,11,'Lasbordes',43.294510,2.044612);
INSERT INTO ville VALUES(11193,11270,11,'Lasserre-de-Prouille',43.179024,2.083292);
INSERT INTO ville VALUES(11194,11600,11,'Lastours',43.331759,2.380394);
INSERT INTO ville VALUES(11195,11400,11,'Laurabuc',43.247809,1.979917);
INSERT INTO ville VALUES(11196,11270,11,'Laurac',43.229280,1.974934);
INSERT INTO ville VALUES(11197,11300,11,'Lauraguel',43.098654,2.174782);
INSERT INTO ville VALUES(11198,11800,11,'Laure-Minervois',43.272657,2.519698);
INSERT INTO ville VALUES(11199,11290,11,'Lavalette',43.185213,2.267798);
INSERT INTO ville VALUES(11200,11160,11,'Lespinassière',43.402914,2.537167);
INSERT INTO ville VALUES(11201,11250,11,'Leuc',43.146264,2.323126);
INSERT INTO ville VALUES(11202,11370,11,'Leucate',42.907432,3.025044);
INSERT INTO ville VALUES(11203,11200,11,'Lézignan-Corbières',43.201652,2.759970);
INSERT INTO ville VALUES(11204,11240,11,'Lignairolles',43.097154,1.994509);
INSERT INTO ville VALUES(11205,11600,11,'Limousis',43.334086,2.402125);
INSERT INTO ville VALUES(11206,11300,11,'Limoux',43.054354,2.221460);
INSERT INTO ville VALUES(11207,11300,11,'Loupia',43.062374,2.112334);
INSERT INTO ville VALUES(11208,11410,11,'Louvière-Lauragais',43.291295,1.807346);
INSERT INTO ville VALUES(11209,11190,11,'Luc-sur-Aude',42.929798,2.326372);
INSERT INTO ville VALUES(11210,11200,11,'Luc-sur-Orbieu',43.176508,2.786313);
INSERT INTO ville VALUES(11270,11350,11,'Padern',42.868437,2.655123);
INSERT INTO ville VALUES(11271,11330,11,'Palairac',42.956943,2.661760);
INSERT INTO ville VALUES(11272,11570,11,'Palaja',43.174388,2.382697);
INSERT INTO ville VALUES(11273,11200,11,'Paraza',43.250087,2.831385);
INSERT INTO ville VALUES(11274,11300,11,'Pauligne',43.072873,2.159259);
INSERT INTO ville VALUES(11275,11410,11,'Payra-sur-l''Hers',43.266297,1.855023);
INSERT INTO ville VALUES(11276,11350,11,'Paziols',42.858537,2.718278);
INSERT INTO ville VALUES(12117,12210,12,'Lacalm',44.772315,2.882597);
INSERT INTO ville VALUES(12118,12600,12,'Lacroix-Barrez',44.779596,2.637555);
INSERT INTO ville VALUES(12119,12210,12,'Laguiole',44.684339,2.847240);
INSERT INTO ville VALUES(12120,12310,12,'Laissac',44.381272,2.823608);
INSERT INTO ville VALUES(12121,12350,12,'Lanuéjouls',44.425279,2.161857);
INSERT INTO ville VALUES(12122,12230,12,'Lapanouse-de-Cernon',43.996127,3.097612);
INSERT INTO ville VALUES(12123,12150,12,'Lapanouse',44.334949,3.030505);
INSERT INTO ville VALUES(12124,12500,12,'Lassouts',44.485646,2.863675);
INSERT INTO ville VALUES(12125,12380,12,'Laval-Roquecezière',43.797719,2.619164);
INSERT INTO ville VALUES(12126,12150,12,'Lavernhe',44.307944,3.001208);
INSERT INTO ville VALUES(12127,12170,12,'Lédergues',44.089677,2.440626);
INSERT INTO ville VALUES(12128,12440,12,'Lescure-Jaoul',44.231775,2.145195);
INSERT INTO ville VALUES(12129,12430,12,'Lestrade-et-Thouels',44.059527,2.659938);
INSERT INTO ville VALUES(12130,12300,12,'Livinhac-le-Haut',44.591140,2.230436);
INSERT INTO ville VALUES(12131,12740,12,'Loubière',44.402151,2.626996);
INSERT INTO ville VALUES(12133,12450,12,'Luc-la-Primaube',44.313693,2.535241);
INSERT INTO ville VALUES(12134,12220,12,'Lugan',44.482272,2.258422);
INSERT INTO ville VALUES(12135,12270,12,'Lunac',44.235684,2.112266);
INSERT INTO ville VALUES(12177,12310,12,'Palmas',44.394623,2.840999);
INSERT INTO ville VALUES(12178,12520,12,'Paulhe',44.152078,3.102669);
INSERT INTO ville VALUES(13012,13100,13,'Beaurecueil',43.540352,5.532196);
INSERT INTO ville VALUES(13049,13113,13,'Lamanon',43.707187,5.090184);
INSERT INTO ville VALUES(13050,13410,13,'Lambesc',43.663590,5.249272);
INSERT INTO ville VALUES(13051,13680,13,'Lançon-Provence',43.572702,5.172402);
INSERT INTO ville VALUES(13068,13520,13,'Paradou',43.723825,4.817418);
INSERT INTO ville VALUES(14349,14320,14,'Laize-la-Ville',49.102326,-0.371428);
INSERT INTO ville VALUES(14350,14240,14,'Lande-sur-Drôme',49.105576,-0.782250);
INSERT INTO ville VALUES(14352,14380,14,'Landelles-et-Coupigny',48.868025,-1.045021);
INSERT INTO ville VALUES(14353,14310,14,'Landes-sur-Ajon',49.084224,-0.643204);
INSERT INTO ville VALUES(14354,14830,14,'Langrune-sur-Mer',49.313726,-0.380474);
INSERT INTO ville VALUES(14355,14480,14,'Lantheuil',49.279315,-0.535772);
INSERT INTO ville VALUES(14356,14740,14,'Lasson',49.214106,-0.532928);
INSERT INTO ville VALUES(14357,14770,14,'Lassy',48.931151,-0.621721);
INSERT INTO ville VALUES(14358,14340,14,'Léaupartie',49.174875,0.071583);
INSERT INTO ville VALUES(14359,14140,14,'Lécaude',49.020178,0.165083);
INSERT INTO ville VALUES(14360,14700,14,'Leffard',48.885700,-0.229580);
INSERT INTO ville VALUES(14361,14770,14,'Lénault',48.931151,-0.621721);
INSERT INTO ville VALUES(14362,14140,14,'Lessard-et-le-Chêne',49.020178,0.165083);
INSERT INTO ville VALUES(14364,14250,14,'Lingèvres',49.183226,-0.634865);
INSERT INTO ville VALUES(14365,14780,14,'Lion-sur-Mer',49.301008,-0.332795);
INSERT INTO ville VALUES(14366,14100,14,'Lisieux',49.137518,0.273982);
INSERT INTO ville VALUES(14367,14330,14,'Lison',49.244282,-0.958772);
INSERT INTO ville VALUES(14368,14140,14,'Lisores',49.020178,0.165083);
INSERT INTO ville VALUES(14369,14490,14,'Litteau',49.196267,-0.831004);
INSERT INTO ville VALUES(14371,14140,14,'Livarot',49.020178,0.165083);
INSERT INTO ville VALUES(14372,14240,14,'Livry',49.105576,-0.782249);
INSERT INTO ville VALUES(14373,14210,14,'Locheur',49.109912,-0.514295);
INSERT INTO ville VALUES(14374,14240,14,'Loges',49.105576,-0.782250);
INSERT INTO ville VALUES(14375,14700,14,'Loges-Saulces',48.885701,-0.229581);
INSERT INTO ville VALUES(14376,14250,14,'Longraye',49.183226,-0.634865);
INSERT INTO ville VALUES(14377,14400,14,'Longues-sur-Mer',49.280691,-0.711805);
INSERT INTO ville VALUES(14378,14230,14,'Longueville',49.312259,-1.037030);
INSERT INTO ville VALUES(14379,14310,14,'Longvillers',49.084224,-0.643204);
INSERT INTO ville VALUES(14380,14250,14,'Loucelles',49.183226,-0.634865);
INSERT INTO ville VALUES(14381,14170,14,'Louvagny',48.987601,-0.045780);
INSERT INTO ville VALUES(14382,14710,14,'Louvières',49.310692,-0.907776);
INSERT INTO ville VALUES(14383,14111,14,'Louvigny',49.152137,-0.395106);
INSERT INTO ville VALUES(14384,14530,14,'Luc-sur-Mer',49.307680,-0.356235);
INSERT INTO ville VALUES(14491,14310,14,'Parfouru-sur-Odon',49.084224,-0.643204);
INSERT INTO ville VALUES(15084,15120,15,'Labesserette',44.723906,2.476751);
INSERT INTO ville VALUES(15085,15130,15,'Labrousse',44.879389,2.466716);
INSERT INTO ville VALUES(15086,15230,15,'Lacapelle-Barrès',44.955947,2.817315);
INSERT INTO ville VALUES(15087,15120,15,'Lacapelle-del-Fraisse',44.723906,2.476751);
INSERT INTO ville VALUES(15088,15150,15,'Lacapelle-Viescamp',44.974042,2.189097);
INSERT INTO ville VALUES(15089,15120,15,'Ladinhac',44.723906,2.476751);
INSERT INTO ville VALUES(15090,15130,15,'Lafeuillade-en-Vézie',44.879389,2.466716);
INSERT INTO ville VALUES(15091,15160,15,'Landeyrat',45.251947,2.936853);
INSERT INTO ville VALUES(15092,15270,15,'Lanobre',45.418010,2.601000);
INSERT INTO ville VALUES(15093,15120,15,'Lapeyrugue',44.723906,2.476751);
INSERT INTO ville VALUES(15094,15150,15,'Laroquebrou',44.974042,2.189097);
INSERT INTO ville VALUES(15095,15250,15,'Laroquevieille',44.984278,2.410010);
INSERT INTO ville VALUES(15096,15590,15,'Lascelle',45.044213,2.622848);
INSERT INTO ville VALUES(15097,15500,15,'Lastic',45.196992,3.183538);
INSERT INTO ville VALUES(15098,15500,15,'Laurie',45.196992,3.183538);
INSERT INTO ville VALUES(15099,15260,15,'Lavastrie',44.933867,2.977033);
INSERT INTO ville VALUES(15100,15300,15,'Laveissenet',45.134840,2.830598);
INSERT INTO ville VALUES(15101,15300,15,'Laveissière',45.134840,2.830598);
INSERT INTO ville VALUES(15102,15300,15,'Lavigerie',45.134840,2.830598);
INSERT INTO ville VALUES(15103,15120,15,'Leucamp',44.723906,2.476751);
INSERT INTO ville VALUES(15104,15600,15,'Leynhac',44.722581,2.228472);
INSERT INTO ville VALUES(15105,43450,15,'Leyvaux',45.320039,3.166580);
INSERT INTO ville VALUES(15106,15110,15,'Lieutadès',44.787165,2.991684);
INSERT INTO ville VALUES(15107,15320,15,'Lorcières',44.948872,3.232569);
INSERT INTO ville VALUES(15108,15390,15,'Loubaresse',999,999);
INSERT INTO ville VALUES(15110,15190,15,'Lugarde',45.290234,2.805569);
INSERT INTO ville VALUES(15146,15800,15,'Pailherols',44.979212,2.651709);
INSERT INTO ville VALUES(15147,15290,15,'Parlan',44.860365,2.194719);
INSERT INTO ville VALUES(15148,15430,15,'Paulhac',45.004074,2.884165);
INSERT INTO ville VALUES(15149,15230,15,'Paulhenc',44.955947,2.817315);
INSERT INTO ville VALUES(16176,16300,16,'Lachaise',45.486986,-0.166442);
INSERT INTO ville VALUES(16177,16120,16,'Ladiville',45.587337,-0.088724);
INSERT INTO ville VALUES(16178,16300,16,'Lagarde-sur-le-Né',45.486986,-0.166442);
INSERT INTO ville VALUES(16179,16300,16,'Lamérac',45.486986,-0.166442);
INSERT INTO ville VALUES(16180,16390,16,'Laprade',45.286311,0.193569);
INSERT INTO ville VALUES(16181,16500,16,'Lessac',46.013669,0.709940);
INSERT INTO ville VALUES(16182,16420,16,'Lesterps',45.982223,0.842383);
INSERT INTO ville VALUES(16183,16310,16,'Lésignac-Durand',45.766815,0.578999);
INSERT INTO ville VALUES(16184,16460,16,'Lichères',45.914941,0.272537);
INSERT INTO ville VALUES(16185,16140,16,'Ligné',45.902904,-0.002240);
INSERT INTO ville VALUES(16186,16130,16,'Lignières-Sonneville',45.611666,-0.289187);
INSERT INTO ville VALUES(16187,16730,16,'Linars',45.666157,0.071295);
INSERT INTO ville VALUES(16188,16310,16,'Lindois',45.766816,0.578999);
INSERT INTO ville VALUES(16189,16700,16,'Londigny',46.020481,0.252105);
INSERT INTO ville VALUES(16190,16240,16,'Longré',46.028517,0.062732);
INSERT INTO ville VALUES(16191,16230,16,'Lonnes',45.884738,0.213027);
INSERT INTO ville VALUES(16193,16100,16,'Louzac-Saint-André',45.697607,-0.329789);
INSERT INTO ville VALUES(16194,16140,16,'Lupsault',45.902904,-0.002240);
INSERT INTO ville VALUES(16195,16450,16,'Lussac',45.908533,0.437716);
INSERT INTO ville VALUES(16196,16230,16,'Luxé',45.884738,0.213027);
INSERT INTO ville VALUES(16253,16240,16,'Paizay-Naudouin-Embourie',46.028517,0.062732);
INSERT INTO ville VALUES(16254,16390,16,'Palluaud',45.286311,0.193569);
INSERT INTO ville VALUES(16255,16450,16,'Parzac',45.908533,0.437716);
INSERT INTO ville VALUES(16256,16480,16,'Passirac',45.330231,-0.068098);
INSERT INTO ville VALUES(17200,17140,17,'Lagord',46.185111,-1.152220);
INSERT INTO ville VALUES(17201,17170,17,'Laigne',46.253685,-0.800507);
INSERT INTO ville VALUES(17202,17380,17,'Landes',45.979808,-0.681092);
INSERT INTO ville VALUES(17203,17290,17,'Landrais',46.083316,-0.925522);
INSERT INTO ville VALUES(17204,17500,17,'Léoville',45.431326,-0.405631);
INSERT INTO ville VALUES(17205,17870,17,'Loire-les-Marais',45.991433,-0.952686);
INSERT INTO ville VALUES(17206,17470,17,'Loiré-sur-Nie',46.016396,-0.333079);
INSERT INTO ville VALUES(17207,17111,17,'Loix',46.220421,-1.447653);
INSERT INTO ville VALUES(17208,17230,17,'Longèves',46.292788,-1.017765);
INSERT INTO ville VALUES(17209,17520,17,'Lonzac',45.507014,-0.338733);
INSERT INTO ville VALUES(17210,17240,17,'Lorignac',45.471881,-0.616954);
INSERT INTO ville VALUES(17211,17330,17,'Loulay',46.081146,-0.535228);
INSERT INTO ville VALUES(17212,17160,17,'Louzignac',45.866849,-0.295807);
INSERT INTO ville VALUES(17213,17330,17,'Lozay',46.081146,-0.535228);
INSERT INTO ville VALUES(17214,17600,17,'Luchat',45.699195,-0.909095);
INSERT INTO ville VALUES(17215,17500,17,'Lussac',45.431326,-0.405631);
INSERT INTO ville VALUES(17216,17430,17,'Lussant',45.969074,-0.834358);
INSERT INTO ville VALUES(17271,17470,17,'Paillé',46.016396,-0.333079);
INSERT INTO ville VALUES(18121,18130,18,'Lantan',46.927194,2.603876);
INSERT INTO ville VALUES(18122,18340,18,'Lapan',46.953677,2.432339);
INSERT INTO ville VALUES(18123,18800,18,'Laverdines',47.104042,2.736368);
INSERT INTO ville VALUES(18124,18120,18,'Lazenay',47.123510,2.065418);
INSERT INTO ville VALUES(18125,18240,18,'Léré',47.459881,2.825958);
INSERT INTO ville VALUES(18126,18340,18,'Levet',46.953677,2.432339);
INSERT INTO ville VALUES(18127,18160,18,'Lignières',46.782615,2.182548);
INSERT INTO ville VALUES(18128,18120,18,'Limeux',47.123510,2.065418);
INSERT INTO ville VALUES(18129,18340,18,'Lissay-Lochy',46.953677,2.432339);
INSERT INTO ville VALUES(18130,18170,18,'Loye-sur-Arnon',46.674509,2.286545);
INSERT INTO ville VALUES(18131,18350,18,'Lugny-Bourbonnais',46.956203,2.786955);
INSERT INTO ville VALUES(18132,18140,18,'Lugny-Champagne',47.166662,2.891299);
INSERT INTO ville VALUES(18133,18400,18,'Lunery',46.966712,2.244092);
INSERT INTO ville VALUES(18134,18120,18,'Lury-sur-Arnon',47.123510,2.065418);
INSERT INTO ville VALUES(18176,18220,18,'Parassy',47.189609,2.625099);
INSERT INTO ville VALUES(18177,18130,18,'Parnay',46.927194,2.603876);
INSERT INTO ville VALUES(19095,19170,19,'Lacelle',45.602135,1.920392);
INSERT INTO ville VALUES(19096,19150,19,'Ladignac-sur-Rondelles',45.229353,1.800890);
INSERT INTO ville VALUES(19097,19320,19,'Lafage-sur-Sombre',45.230817,2.020372);
INSERT INTO ville VALUES(19098,19150,19,'Lagarde-Enval',45.229353,1.800890);
INSERT INTO ville VALUES(19099,19500,19,'Lagleygeolle',45.049051,1.662162);
INSERT INTO ville VALUES(19100,19700,19,'Lagraulière',45.359660,1.653309);
INSERT INTO ville VALUES(19101,19150,19,'Laguenne',45.229353,1.800890);
INSERT INTO ville VALUES(19102,19160,19,'Lamazière-Basse',45.380254,2.265254);
INSERT INTO ville VALUES(19103,19340,19,'Lamazière-Haute',45.669498,2.412964);
INSERT INTO ville VALUES(19104,19510,19,'Lamongerie',45.527926,1.561414);
INSERT INTO ville VALUES(19105,19190,19,'Lanteuil',45.130661,1.707198);
INSERT INTO ville VALUES(19106,19550,19,'Lapleau',45.289275,2.160494);
INSERT INTO ville VALUES(19107,19600,19,'Larche',45.092283,1.462094);
INSERT INTO ville VALUES(19108,19340,19,'Laroche-près-Feyt',45.669498,2.412964);
INSERT INTO ville VALUES(19109,19130,19,'Lascaux',45.289592,1.403400);
INSERT INTO ville VALUES(19110,19160,19,'Latronche',45.380254,2.265254);
INSERT INTO ville VALUES(19111,19550,19,'Laval-sur-Luzège',45.289275,2.160494);
INSERT INTO ville VALUES(19112,19170,19,'Lestards',45.602135,1.920392);
INSERT INTO ville VALUES(19113,19160,19,'Liginiac',45.380254,2.265254);
INSERT INTO ville VALUES(19114,19200,19,'Lignareix',45.545009,2.351379);
INSERT INTO ville VALUES(19115,19500,19,'Ligneyrac',45.049051,1.662162);
INSERT INTO ville VALUES(19116,19120,19,'Liourdres',45.006855,1.805197);
INSERT INTO ville VALUES(19117,19600,19,'Lissac-sur-Couze',45.092283,1.462094);
INSERT INTO ville VALUES(19118,19470,19,'Lonzac',45.470459,1.753359);
INSERT INTO ville VALUES(19119,19500,19,'Lostanges',45.049051,1.662162);
INSERT INTO ville VALUES(19120,19310,19,'Louignac',45.225345,1.324604);
INSERT INTO ville VALUES(19121,19210,19,'Lubersac',45.467050,1.377730);
INSERT INTO ville VALUES(19156,19190,19,'Palazinges',45.130661,1.707198);
INSERT INTO ville VALUES(19157,19160,19,'Palisse',45.380254,2.265254);
INSERT INTO ville VALUES(19158,19150,19,'Pandrignes',45.229353,1.800890);
INSERT INTO ville VALUES(21330,21110,21,'Labergement-Foigney',47.214815,5.205446);
INSERT INTO ville VALUES(21331,21130,21,'Labergement-lès-Auxonne',47.177688,5.367533);
INSERT INTO ville VALUES(21332,21820,21,'Labergement-lès-Seurre',46.986597,5.087871);
INSERT INTO ville VALUES(21333,21250,21,'Labruyère',47.037362,5.130158);
INSERT INTO ville VALUES(21334,21230,21,'Lacanche',47.122728,4.477110);
INSERT INTO ville VALUES(21335,21210,21,'Lacour-d''Arcenay',47.294517,4.259402);
INSERT INTO ville VALUES(21336,21330,21,'Laignes',47.839562,4.382026);
INSERT INTO ville VALUES(21337,21760,21,'Lamarche-sur-Saône',47.274872,5.371193);
INSERT INTO ville VALUES(21338,21440,21,'Lamargelle',47.487247,4.816917);
INSERT INTO ville VALUES(21339,21370,21,'Lantenay',47.340974,4.903448);
INSERT INTO ville VALUES(21340,21250,21,'Lanthes',47.037362,5.130158);
INSERT INTO ville VALUES(21341,21140,21,'Lantilly',47.489230,4.334713);
INSERT INTO ville VALUES(21342,21170,21,'Laperrière-sur-Saône',47.102507,5.260303);
INSERT INTO ville VALUES(21343,21330,21,'Larrey',47.839562,4.382026);
INSERT INTO ville VALUES(21344,21250,21,'Lechâtelet',47.037362,5.130158);
INSERT INTO ville VALUES(21345,21440,21,'Léry',47.487247,4.816917);
INSERT INTO ville VALUES(21346,21290,21,'Leuglay',47.771780,4.866462);
INSERT INTO ville VALUES(21347,21200,21,'Levernois',47.015740,4.878329);
INSERT INTO ville VALUES(21348,21610,21,'Licey-sur-Vingeanne',47.554351,5.370695);
INSERT INTO ville VALUES(21349,21430,21,'Liernais',47.175454,4.264314);
INSERT INTO ville VALUES(21350,21520,21,'Lignerolles',47.930500,4.802649);
INSERT INTO ville VALUES(21351,21110,21,'Longchamp',47.214815,5.205446);
INSERT INTO ville VALUES(21352,21110,21,'Longeault',47.214815,5.205446);
INSERT INTO ville VALUES(21353,21110,21,'Longecourt-en-Plaine',47.214815,5.205446);
INSERT INTO ville VALUES(21354,21230,21,'Longecourt-lès-Culêtre',47.122728,4.477110);
INSERT INTO ville VALUES(21355,21600,21,'Longvic',47.261621,5.064665);
INSERT INTO ville VALUES(21356,21170,21,'Losne',47.102507,5.260303);
INSERT INTO ville VALUES(21357,21520,21,'Louesme',47.930500,4.802649);
INSERT INTO ville VALUES(21358,21150,21,'Lucenay-le-Duc',47.545258,4.529532);
INSERT INTO ville VALUES(21359,21290,21,'Lucey',47.771780,4.866462);
INSERT INTO ville VALUES(21360,21360,21,'Lusigny-sur-Ouche',47.148021,4.667996);
INSERT INTO ville VALUES(21361,21120,21,'Lux',47.522959,5.057858);
INSERT INTO ville VALUES(21474,21250,21,'Pagny-la-Ville',47.037362,5.130158);
INSERT INTO ville VALUES(21475,21250,21,'Pagny-le-Château',47.037362,5.130158);
INSERT INTO ville VALUES(21476,21360,21,'Painblanc',47.148021,4.667996);
INSERT INTO ville VALUES(21477,21540,21,'Panges',47.339286,4.702104);
INSERT INTO ville VALUES(21478,21370,21,'Pasques',47.340974,4.903448);
INSERT INTO ville VALUES(21606,21550,21,'Ladoix-Serrigny',47.067317,4.915470);
INSERT INTO ville VALUES(22093,22400,22,'Lamballe',48.491865,-2.491456);
INSERT INTO ville VALUES(22094,22770,22,'Lancieux',48.602672,-2.147749);
INSERT INTO ville VALUES(22095,22140,22,'Landebaëron',48.656929,-3.304704);
INSERT INTO ville VALUES(22096,22130,22,'Landébia',48.496851,-2.217571);
INSERT INTO ville VALUES(22097,22980,22,'Landec',48.427117,-2.201302);
INSERT INTO ville VALUES(22098,22400,22,'Landéhen',48.491865,-2.491456);
INSERT INTO ville VALUES(22099,22800,22,'Lanfains',48.416540,-2.938512);
INSERT INTO ville VALUES(22100,22150,22,'Langast',48.333422,-2.769428);
INSERT INTO ville VALUES(22101,22450,22,'Langoat',48.746014,-3.292939);
INSERT INTO ville VALUES(22102,22330,22,'Langourla',48.284524,-2.415223);
INSERT INTO ville VALUES(22103,22490,22,'Langrolay-sur-Rance',48.536119,-2.041584);
INSERT INTO ville VALUES(22104,22980,22,'Languédias',48.427117,-2.201301);
INSERT INTO ville VALUES(22105,22130,22,'Languenan',48.496851,-2.217571);
INSERT INTO ville VALUES(22106,22360,22,'Langueux',48.502061,-2.708349);
INSERT INTO ville VALUES(22107,22570,22,'Laniscat',48.220681,-3.155548);
INSERT INTO ville VALUES(22108,22290,22,'Lanleff',48.645211,-3.021259);
INSERT INTO ville VALUES(22109,22580,22,'Lanloup',48.685477,-2.934354);
INSERT INTO ville VALUES(22110,22300,22,'Lanmérin',48.715631,-3.457604);
INSERT INTO ville VALUES(22111,22610,22,'Lanmodez',48.845244,-3.116068);
INSERT INTO ville VALUES(22112,22290,22,'Lannebert',48.645211,-3.021259);
INSERT INTO ville VALUES(22113,22300,22,'Lannion',48.715631,-3.457604);
INSERT INTO ville VALUES(22114,22250,22,'Lanrelas',48.296573,-2.314951);
INSERT INTO ville VALUES(22115,22480,22,'Lanrivain',48.335944,-3.181696);
INSERT INTO ville VALUES(22116,22170,22,'Lanrodec',48.514464,-2.972253);
INSERT INTO ville VALUES(22117,22410,22,'Lantic',48.629006,-2.875358);
INSERT INTO ville VALUES(22118,22100,22,'Lanvallay',48.440195,-2.037198);
INSERT INTO ville VALUES(22119,22420,22,'Lanvellec',48.614637,-3.469979);
INSERT INTO ville VALUES(22121,22290,22,'Lanvollon',48.645211,-3.021259);
INSERT INTO ville VALUES(22122,22230,22,'Laurenan',48.193717,-2.391432);
INSERT INTO ville VALUES(22123,22100,22,'Léhon',48.440195,-2.037198);
INSERT INTO ville VALUES(22124,22570,22,'Lescouët-Gouarec',48.220681,-3.155548);
INSERT INTO ville VALUES(22126,22800,22,'Leslay',48.416541,-2.938512);
INSERT INTO ville VALUES(22127,22740,22,'Lézardrieux',48.786053,-3.133395);
INSERT INTO ville VALUES(22128,22340,22,'Locarn',48.264843,-3.452249);
INSERT INTO ville VALUES(22129,22810,22,'Loc-Envel',48.519772,-3.413379);
INSERT INTO ville VALUES(22131,22780,22,'Loguivy-Plougras',48.528876,-3.513109);
INSERT INTO ville VALUES(22132,22160,22,'Lohuec',48.400252,-3.429289);
INSERT INTO ville VALUES(22133,22230,22,'Loscouët-sur-Meu',48.193717,-2.391432);
INSERT INTO ville VALUES(22134,22700,22,'Louannec',48.795945,-3.435613);
INSERT INTO ville VALUES(22135,22540,22,'Louargat',48.563069,-3.299442);
INSERT INTO ville VALUES(22136,22600,22,'Loudéac',48.175920,-2.769769);
INSERT INTO ville VALUES(22161,22200,22,'Pabu',48.582844,-3.155806);
INSERT INTO ville VALUES(22162,22500,22,'Paimpol',48.764124,-3.050780);
INSERT INTO ville VALUES(22163,22340,22,'Paule',48.264843,-3.452249);
INSERT INTO ville VALUES(23102,23270,23,'Ladapeyre',46.299347,2.064703);
INSERT INTO ville VALUES(23103,23800,23,'Lafat',46.296002,1.692034);
INSERT INTO ville VALUES(23104,23600,23,'Lavaufranche',46.341493,2.233583);
INSERT INTO ville VALUES(23105,23150,23,'Lavaveix-les-Mines',46.089942,2.024427);
INSERT INTO ville VALUES(23106,23170,23,'Lépaud',46.224110,2.389463);
INSERT INTO ville VALUES(23107,23150,23,'Lépinas',46.089942,2.024427);
INSERT INTO ville VALUES(23108,23600,23,'Leyrat',46.341493,2.233583);
INSERT INTO ville VALUES(23109,23220,23,'Linard',46.329873,1.869243);
INSERT INTO ville VALUES(23110,23700,23,'Lioux-les-Monges',46.009574,2.472777);
INSERT INTO ville VALUES(23111,23240,23,'Lizières',46.169702,1.631906);
INSERT INTO ville VALUES(23112,23360,23,'Lourdoueix-Saint-Pierre',46.403585,1.818581);
INSERT INTO ville VALUES(23113,23190,23,'Lupersat',45.994777,2.332253);
INSERT INTO ville VALUES(23114,23170,23,'Lussat',46.224110,2.389463);
INSERT INTO ville VALUES(23149,23140,23,'Parsac',46.196593,2.092359);
INSERT INTO ville VALUES(24030,24120,24,'Beauregard-de-Terrasson',45.124361,1.287831);
INSERT INTO ville VALUES(24031,24140,24,'Beauregard-et-Bassac',44.980663,0.544469);
INSERT INTO ville VALUES(24219,24440,24,'Labouquerie',44.738865,0.787549);
INSERT INTO ville VALUES(24220,24380,24,'Lacropte',45.034561,0.746533);
INSERT INTO ville VALUES(24223,24150,24,'Lalinde',44.848997,0.732470);
INSERT INTO ville VALUES(24224,24520,24,'Lamonzie-Montastruc',44.856112,0.594655);
INSERT INTO ville VALUES(24225,24680,24,'Lamonzie-Saint-Martin',44.833540,0.363103);
INSERT INTO ville VALUES(24226,24230,24,'Lamothe-Montravel',44.872753,0.075063);
INSERT INTO ville VALUES(24227,24270,24,'Lanouaille',45.404053,1.179235);
INSERT INTO ville VALUES(24228,24150,24,'Lanquais',44.848997,0.732470);
INSERT INTO ville VALUES(24229,24570,24,'Lardin-Saint-Lazare',45.136259,1.243619);
INSERT INTO ville VALUES(24230,24170,24,'Larzac',44.758039,1.053147);
INSERT INTO ville VALUES(24231,24540,24,'Lavalade',44.678991,0.905736);
INSERT INTO ville VALUES(24232,24550,24,'Lavaur',44.648121,1.081871);
INSERT INTO ville VALUES(24233,24130,24,'Laveyssière',44.906205,0.351797);
INSERT INTO ville VALUES(24234,24400,24,'Lèches',45.036477,0.342807);
INSERT INTO ville VALUES(24235,24340,24,'Léguillac-de-Cercles',45.447575,0.474270);
INSERT INTO ville VALUES(24236,24110,24,'Léguillac-de-l''Auche',45.122453,0.539010);
INSERT INTO ville VALUES(24237,24100,24,'Lembras',44.856803,0.500061);
INSERT INTO ville VALUES(24238,24800,24,'Lempzours',45.432940,0.930584);
INSERT INTO ville VALUES(24239,24460,24,'Ligueux',45.283729,0.780697);
INSERT INTO ville VALUES(24240,24510,24,'Limeuil',44.915755,0.783856);
INSERT INTO ville VALUES(24241,24210,24,'Limeyrat',45.159752,1.071456);
INSERT INTO ville VALUES(24242,24520,24,'Liorac-sur-Louyre',44.856112,0.594655);
INSERT INTO ville VALUES(24243,24350,24,'Lisle',45.260085,0.539730);
INSERT INTO ville VALUES(24244,24540,24,'Lolme',44.678991,0.905736);
INSERT INTO ville VALUES(24245,24550,24,'Loubejac',44.648121,1.081871);
INSERT INTO ville VALUES(24246,24130,24,'Lunas',44.906205,0.351797);
INSERT INTO ville VALUES(24247,24320,24,'Lusignac',45.372930,0.385361);
INSERT INTO ville VALUES(24248,24300,24,'Lussas-et-Nontronneau',45.524312,0.641893);
INSERT INTO ville VALUES(24316,24410,24,'Parcoul',45.178798,0.156391);
INSERT INTO ville VALUES(24317,24590,24,'Paulin',44.987355,1.325056);
INSERT INTO ville VALUES(24318,24510,24,'Paunat',44.915755,0.783856);
INSERT INTO ville VALUES(24319,24310,24,'Paussac-et-Saint-Vivien',45.353563,0.610192);
INSERT INTO ville VALUES(24320,24270,24,'Payzac',45.404053,1.179235);
INSERT INTO ville VALUES(24321,24120,24,'Pazayac',45.124361,1.287831);
INSERT INTO ville VALUES(25319,25270,25,'Labergement-du-Navois',46.942849,6.089242);
INSERT INTO ville VALUES(25320,25160,25,'Labergement-Sainte-Marie',46.801851,6.272947);
INSERT INTO ville VALUES(25322,25550,25,'Laire',47.513511,6.725067);
INSERT INTO ville VALUES(25323,25820,25,'Laissey',47.300651,6.233597);
INSERT INTO ville VALUES(25324,25360,25,'Lanans',47.251244,6.310037);
INSERT INTO ville VALUES(25325,25530,25,'Landresse',47.215922,6.418751);
INSERT INTO ville VALUES(25326,25170,25,'Lantenne-Vertière',47.273181,5.824517);
INSERT INTO ville VALUES(25327,25250,25,'Lanthenans',47.451442,6.567711);
INSERT INTO ville VALUES(25328,25720,25,'Larnod',47.186016,5.978189);
INSERT INTO ville VALUES(25329,25210,25,'Laval-le-Prieuré',47.169095,6.713702);
INSERT INTO ville VALUES(25330,25440,25,'Lavans-Quingey',47.069919,5.889238);
INSERT INTO ville VALUES(25331,25580,25,'Lavans-Vuillafans',47.118422,6.294145);
INSERT INTO ville VALUES(25332,25170,25,'Lavernay',47.273181,5.824517);
INSERT INTO ville VALUES(25333,25510,25,'Laviron',47.220945,6.522856);
INSERT INTO ville VALUES(25334,25270,25,'Levier',46.942849,6.089242);
INSERT INTO ville VALUES(25335,25190,25,'Liebvillers',47.328314,6.852289);
INSERT INTO ville VALUES(25336,25440,25,'Liesle',47.069919,5.889238);
INSERT INTO ville VALUES(25338,25330,25,'Lizine',47.032513,6.099013);
INSERT INTO ville VALUES(25339,25930,25,'Lods',47.050035,6.259239);
INSERT INTO ville VALUES(25340,25440,25,'Lombard',47.069919,5.889238);
INSERT INTO ville VALUES(25341,25110,25,'Lomont-sur-Crête',47.349048,6.363165);
INSERT INTO ville VALUES(25342,25690,25,'Longechaux',47.116067,6.438186);
INSERT INTO ville VALUES(25343,25690,25,'Longemaison',47.116067,6.438186);
INSERT INTO ville VALUES(25344,25380,25,'Longevelle-lès-Russey',47.254594,6.672595);
INSERT INTO ville VALUES(25345,25260,25,'Longevelle-sur-Doubs',47.456940,6.681499);
INSERT INTO ville VALUES(25346,25330,25,'Longeville',47.032513,6.099013);
INSERT INTO ville VALUES(25347,25650,25,'Longeville',47.015561,6.444089);
INSERT INTO ville VALUES(25348,25370,25,'Longevilles-Mont-d''Or',46.758247,6.359095);
INSERT INTO ville VALUES(25349,25390,25,'Loray',47.134719,6.539074);
INSERT INTO ville VALUES(25350,25260,25,'Lougres',47.456940,6.681499);
INSERT INTO ville VALUES(25351,25210,25,'Luhier',47.169095,6.713702);
INSERT INTO ville VALUES(25354,25110,25,'Luxiol',47.349048,6.363165);
INSERT INTO ville VALUES(25443,25440,25,'Palantine',47.069919,5.889238);
INSERT INTO ville VALUES(25444,25870,25,'Palise',47.336354,6.041742);
INSERT INTO ville VALUES(25445,25440,25,'Paroy',47.069919,5.889238);
INSERT INTO ville VALUES(25446,25360,25,'Passavant',47.251244,6.310037);
INSERT INTO ville VALUES(25447,25690,25,'Passonfontaine',47.116067,6.438186);
INSERT INTO ville VALUES(26039,26300,26,'Beauregard-Baret',44.980123,5.044155);
INSERT INTO ville VALUES(26153,26560,26,'Laborel',44.227953,5.562488);
INSERT INTO ville VALUES(26154,26560,26,'Lachau',44.227953,5.562488);
INSERT INTO ville VALUES(26155,26210,26,'Lapeyrouse-Mornay',45.298120,4.988626);
INSERT INTO ville VALUES(26156,26600,26,'Larnage',45.067198,4.899292);
INSERT INTO ville VALUES(26157,26740,26,'Laupie',44.609973,4.832272);
INSERT INTO ville VALUES(26159,26150,26,'Laval-d''Aix',44.783860,5.355851);
INSERT INTO ville VALUES(26160,26240,26,'Laveyron',45.187867,4.887980);
INSERT INTO ville VALUES(26161,26510,26,'Lemps',44.390882,5.412232);
INSERT INTO ville VALUES(26162,26210,26,'Lens-Lestang',45.298120,4.988626);
INSERT INTO ville VALUES(26163,26190,26,'Léoncel',44.963539,5.275277);
INSERT INTO ville VALUES(26164,26310,26,'Lesches-en-Diois',44.572416,5.497560);
INSERT INTO ville VALUES(26165,26250,26,'Livron-sur-Drôme',44.790339,4.825621);
INSERT INTO ville VALUES(26166,26270,26,'Loriol-sur-Drôme',44.714316,4.818964);
INSERT INTO ville VALUES(26167,26310,26,'Luc-en-Diois',44.572416,5.497560);
INSERT INTO ville VALUES(26168,26620,26,'Lus-la-Croix-Haute',44.684299,5.735407);
INSERT INTO ville VALUES(26225,26750,26,'Parnans',45.114811,5.128822);
INSERT INTO ville VALUES(27361,27210,27,'Lande-Saint-Léger',49.361086,0.385342);
INSERT INTO ville VALUES(27362,27410,27,'Landepéreuse',49.008243,0.701237);
INSERT INTO ville VALUES(27363,27350,27,'Landin',49.373904,0.704302);
INSERT INTO ville VALUES(27364,27470,27,'Launay',49.098184,0.701098);
INSERT INTO ville VALUES(27365,27690,27,'Léry',49.288497,1.193265);
INSERT INTO ville VALUES(27366,27910,27,'Letteguives',49.417897,1.376724);
INSERT INTO ville VALUES(27367,27560,27,'Lieurey',49.239134,0.523311);
INSERT INTO ville VALUES(27368,27220,27,'Lignerolles',48.903079,1.274068);
INSERT INTO ville VALUES(27369,27480,27,'Lilly',49.412361,1.526940);
INSERT INTO ville VALUES(27370,27440,27,'Lisors',49.331809,1.411105);
INSERT INTO ville VALUES(27371,27800,27,'Livet-sur-Authou',49.186313,0.702864);
INSERT INTO ville VALUES(27372,27150,27,'Longchamps',49.331218,1.605670);
INSERT INTO ville VALUES(27373,27480,27,'Lorleau',49.412361,1.526940);
INSERT INTO ville VALUES(27374,27190,27,'Louversey',48.985735,0.907018);
INSERT INTO ville VALUES(27375,27400,27,'Louviers',49.184259,1.153242);
INSERT INTO ville VALUES(27376,27650,27,'Louye',48.783776,1.313605);
INSERT INTO ville VALUES(27377,27480,27,'Lyons-la-Forêt',49.412361,1.526940);
INSERT INTO ville VALUES(27448,27120,27,'Pacy-sur-Eure',49.022328,1.359478);
INSERT INTO ville VALUES(27449,27510,27,'Panilleuse',49.176104,1.511442);
INSERT INTO ville VALUES(27451,27180,27,'Parville',49.005790,1.062989);
INSERT INTO ville VALUES(28202,28340,28,'Lamblore',48.639263,0.892427);
INSERT INTO ville VALUES(28203,28190,28,'Landelles',48.462755,1.234544);
INSERT INTO ville VALUES(28204,28220,28,'Langey',48.014366,1.277997);
INSERT INTO ville VALUES(28205,28200,28,'Lanneray',48.073910,1.363398);
INSERT INTO ville VALUES(28206,28270,28,'Laons',48.691866,1.092138);
INSERT INTO ville VALUES(28207,28700,28,'Léthuin',48.441022,1.791769);
INSERT INTO ville VALUES(28208,28700,28,'Levainville',48.441022,1.791769);
INSERT INTO ville VALUES(28209,28300,28,'Lèves',48.496193,1.467478);
INSERT INTO ville VALUES(28210,28310,28,'Levesville-la-Chenard',48.255128,1.877590);
INSERT INTO ville VALUES(28211,28200,28,'Logron',48.073910,1.363398);
INSERT INTO ville VALUES(28212,28140,28,'Loigny-la-Bataille',48.126409,1.686985);
INSERT INTO ville VALUES(28213,28210,28,'Lormaye',48.645619,1.515631);
INSERT INTO ville VALUES(28214,28240,28,'Loupe',48.453004,1.065535);
INSERT INTO ville VALUES(28215,28150,28,'Louville-la-Chenard',48.273161,1.659300);
INSERT INTO ville VALUES(28216,28500,28,'Louvilliers-en-Drouais',48.719113,1.380449);
INSERT INTO ville VALUES(28217,28250,28,'Louvilliers-lès-Perche',48.575872,1.068142);
INSERT INTO ville VALUES(28218,28110,28,'Lucé',48.433708,1.452787);
INSERT INTO ville VALUES(28219,28420,28,'Luigny',999,999);
INSERT INTO ville VALUES(28220,28600,28,'Luisant',48.423778,1.466793);
INSERT INTO ville VALUES(28221,28140,28,'Lumeau',48.126409,1.686985);
INSERT INTO ville VALUES(28222,28360,28,'Luplanté',48.325263,1.518840);
INSERT INTO ville VALUES(28223,28500,28,'Luray',48.719113,1.380449);
INSERT INTO ville VALUES(28224,28200,28,'Lutz-en-Dunois',48.073910,1.363398);
INSERT INTO ville VALUES(29097,29400,29,'Lampaul-Guimiliau',48.501591,-4.110881);
INSERT INTO ville VALUES(29098,29810,29,'Lampaul-Plouarzel',48.430717,-4.718438);
INSERT INTO ville VALUES(29099,29830,29,'Lampaul-Ploudalmézeau',48.525658,-4.645820);
INSERT INTO ville VALUES(29100,29260,29,'Lanarvily',48.554370,-4.336731);
INSERT INTO ville VALUES(29101,29870,29,'Landéda',48.541905,-4.545391);
INSERT INTO ville VALUES(29102,29530,29,'Landeleau',48.277794,-3.801304);
INSERT INTO ville VALUES(29103,29800,29,'Landerneau',48.446753,-4.223838);
INSERT INTO ville VALUES(29104,29560,29,'Landévennec',48.249835,-4.303664);
INSERT INTO ville VALUES(29105,29400,29,'Landivisiau',48.501591,-4.110881);
INSERT INTO ville VALUES(29106,29510,29,'Landrévarzec',48.096436,-3.988475);
INSERT INTO ville VALUES(29107,29510,29,'Landudal',48.096436,-3.988475);
INSERT INTO ville VALUES(29108,29710,29,'Landudec',47.984509,-4.307422);
INSERT INTO ville VALUES(29109,29840,29,'Landunvez',48.514462,-4.739414);
INSERT INTO ville VALUES(29110,29510,29,'Langolen',48.096436,-3.988475);
INSERT INTO ville VALUES(29111,29430,29,'Lanhouarneau',48.621926,-4.224269);
INSERT INTO ville VALUES(29112,29840,29,'Lanildut',48.514462,-4.739414);
INSERT INTO ville VALUES(29113,29620,29,'Lanmeur',48.650412,-3.697055);
INSERT INTO ville VALUES(29114,29640,29,'Lannéanou',48.469769,-3.675781);
INSERT INTO ville VALUES(29115,29190,29,'Lannédern',48.254370,-3.957874);
INSERT INTO ville VALUES(29116,29400,29,'Lanneuffret',48.501591,-4.110881);
INSERT INTO ville VALUES(29117,29870,29,'Lannilis',48.541905,-4.545391);
INSERT INTO ville VALUES(29119,29290,29,'Lanrivoaré',48.459214,-4.582718);
INSERT INTO ville VALUES(29120,29160,29,'Lanvéoc',48.239127,-4.468621);
INSERT INTO ville VALUES(29122,29520,29,'Laz',48.158774,-3.817922);
INSERT INTO ville VALUES(29123,29190,29,'Lennon',48.254370,-3.957874);
INSERT INTO ville VALUES(29124,29260,29,'Lesneven',48.554370,-4.336731);
INSERT INTO ville VALUES(29125,29390,29,'Leuhan',48.042449,-3.737852);
INSERT INTO ville VALUES(29126,29260,29,'Loc-Brévalaire',48.554370,-4.336731);
INSERT INTO ville VALUES(29127,29410,29,'Loc-Eguiner-Saint-Thégonnec',48.499457,-3.808486);
INSERT INTO ville VALUES(29128,29400,29,'Loc-Eguiner',48.501591,-4.110881);
INSERT INTO ville VALUES(29129,29690,29,'Locmaria-Berrien',48.357798,-3.818129);
INSERT INTO ville VALUES(29130,29280,29,'Locmaria-Plouzané',48.374666,-4.620064);
INSERT INTO ville VALUES(29131,29400,29,'Locmélar',48.501591,-4.110881);
INSERT INTO ville VALUES(29132,29670,29,'Locquénolé',48.608387,-3.905213);
INSERT INTO ville VALUES(29133,29241,29,'Locquirec',48.681613,-3.669876);
INSERT INTO ville VALUES(29134,29180,29,'Locronan',48.080131,-4.167338);
INSERT INTO ville VALUES(29135,29750,29,'Loctudy',47.824623,-4.185185);
INSERT INTO ville VALUES(29136,29310,29,'Locunolé',47.946960,-3.532336);
INSERT INTO ville VALUES(29137,29460,29,'Logonna-Daoulas',48.369933,-4.192826);
INSERT INTO ville VALUES(29139,29590,29,'Lopérec',48.281949,-4.140148);
INSERT INTO ville VALUES(29140,29470,29,'Loperhet',48.370919,-4.371623);
INSERT INTO ville VALUES(29141,29530,29,'Loqueffret',48.277794,-3.801304);
INSERT INTO ville VALUES(29142,29190,29,'Lothey',48.254370,-3.957874);
INSERT INTO ville VALUES('2A139',NULL,'2A','Lecci',41.679691,9.317593);
INSERT INTO ville VALUES('2A141',NULL,'2A','Letia',42.192494,8.847332);
INSERT INTO ville VALUES('2A142',NULL,'2A','Levie',41.701491,9.122495);
INSERT INTO ville VALUES('2A144',NULL,'2A','Lopigna',42.099025,8.847232);
INSERT INTO ville VALUES('2A146',NULL,'2A','Loreto-di-Tallano',41.719214,9.037042);
INSERT INTO ville VALUES('2A200',NULL,'2A','Palneca',41.969781,9.172356);
INSERT INTO ville VALUES('2A203',NULL,'2A','Partinello',42.312049,8.681269);
INSERT INTO ville VALUES('2A204',NULL,'2A','Pastricciola',42.140361,8.984100);
INSERT INTO ville VALUES('2B136',NULL,'2B','Lama',42.575383,9.171649);
INSERT INTO ville VALUES('2B137',NULL,'2B','Lano',42.381640,9.245962);
INSERT INTO ville VALUES('2B138',NULL,'2B','Lavatoggio',42.574186,8.877604);
INSERT INTO ville VALUES('2B140',NULL,'2B','Lento',42.521883,9.282112);
INSERT INTO ville VALUES('2B143',NULL,'2B','Linguizzetta',42.264713,9.472009);
INSERT INTO ville VALUES('2B145',NULL,'2B','Loreto-di-Casinca',42.476241,9.429164);
INSERT INTO ville VALUES('2B147',NULL,'2B','Lozzi',42.346949,9.009377);
INSERT INTO ville VALUES('2B148',NULL,'2B','Lucciana',42.546129,9.418413);
INSERT INTO ville VALUES('2B149',NULL,'2B','Lugo-di-Nazza',42.074213,9.301791);
INSERT INTO ville VALUES('2B150',NULL,'2B','Lumio',42.579462,8.831390);
INSERT INTO ville VALUES('2B152',NULL,'2B','Luri',42.892254,9.440227);
INSERT INTO ville VALUES('2B199',NULL,'2B','Palasca',42.590187,9.041823);
INSERT INTO ville VALUES('2B201',NULL,'2B','Pancheraccia',42.217773,9.371695);
INSERT INTO ville VALUES('2B202',NULL,'2B','Parata',42.370561,9.408124);
INSERT INTO ville VALUES('2B205',NULL,'2B','Patrimonio',42.706207,9.370455);
INSERT INTO ville VALUES(30137,30110,30,'Lamelouze',44.217172,4.012085);
INSERT INTO ville VALUES(30138,30980,30,'Langlade',43.801845,4.246400);
INSERT INTO ville VALUES(30139,30750,30,'Lanuéjols',44.096683,3.426972);
INSERT INTO ville VALUES(30140,30460,30,'Lasalle',44.053906,3.829451);
INSERT INTO ville VALUES(30141,30290,30,'Laudun-l''Ardoise',44.075328,4.661418);
INSERT INTO ville VALUES(30142,30110,30,'Laval-Pradel',44.217172,4.012085);
INSERT INTO ville VALUES(30143,30760,30,'Laval-Saint-Roman',44.288188,4.522883);
INSERT INTO ville VALUES(30144,30250,30,'Lecques',43.808849,4.086755);
INSERT INTO ville VALUES(30145,30210,30,'Lédenon',43.970374,4.540030);
INSERT INTO ville VALUES(30146,30350,30,'Lédignan',43.968806,4.105190);
INSERT INTO ville VALUES(30147,30350,30,'Lézan',43.968806,4.105190);
INSERT INTO ville VALUES(30148,30260,30,'Liouc',43.881141,4.034347);
INSERT INTO ville VALUES(30149,30126,30,'Lirac',44.036294,4.687075);
INSERT INTO ville VALUES(30150,30610,30,'Logrian-Florian',43.946314,3.995305);
INSERT INTO ville VALUES(30151,30580,30,'Lussan',44.136661,4.322635);
INSERT INTO ville VALUES(30193,30730,30,'Parignargues',43.882013,4.193179);
INSERT INTO ville VALUES(31246,31800,31,'Labarthe-Inard',43.129483,0.739666);
INSERT INTO ville VALUES(31247,31800,31,'Labarthe-Rivière',43.129483,0.739666);
INSERT INTO ville VALUES(31248,31860,31,'Labarthe-sur-Lèze',43.464581,1.395074);
INSERT INTO ville VALUES(31249,31450,31,'Labastide-Beauvoir',43.457040,1.592532);
INSERT INTO ville VALUES(31250,31370,31,'Labastide-Clermont',43.408338,1.105762);
INSERT INTO ville VALUES(31251,31230,31,'Labastide-Paumès',43.343616,0.842227);
INSERT INTO ville VALUES(31252,31620,31,'Labastide-Saint-Sernin',43.806164,1.390991);
INSERT INTO ville VALUES(31253,31600,31,'Labastidette',43.454242,1.287336);
INSERT INTO ville VALUES(31254,31670,31,'Labège',43.539444,1.520987);
INSERT INTO ville VALUES(31255,31510,31,'Labroquère',43.015670,0.628269);
INSERT INTO ville VALUES(31256,31190,31,'Labruyère-Dorsa',43.348930,1.454137);
INSERT INTO ville VALUES(31258,31390,31,'Lacaugne',43.307247,1.216381);
INSERT INTO ville VALUES(31259,31120,31,'Lacroix-Falgarde',43.509335,1.392017);
INSERT INTO ville VALUES(31260,31360,31,'Laffite-Toupière',43.152071,0.901698);
INSERT INTO ville VALUES(31261,31390,31,'Lafitte-Vigordane',43.307247,1.216381);
INSERT INTO ville VALUES(31262,31290,31,'Lagarde',43.406380,1.727640);
INSERT INTO ville VALUES(31263,31870,31,'Lagardelle-sur-Lèze',43.395794,1.365442);
INSERT INTO ville VALUES(31264,31190,31,'Lagrâce-Dieu',43.348930,1.454137);
INSERT INTO ville VALUES(31265,31480,31,'Lagraulet-Saint-Nicolas',43.744424,1.047518);
INSERT INTO ville VALUES(31266,31370,31,'Lahage',43.408338,1.105762);
INSERT INTO ville VALUES(31267,31310,31,'Lahitère',43.184475,1.241901);
INSERT INTO ville VALUES(31268,31800,31,'Lalouret-Laffiteau',43.129483,0.739666);
INSERT INTO ville VALUES(31269,31600,31,'Lamasquère',43.454242,1.287336);
INSERT INTO ville VALUES(31270,31800,31,'Landorthe',43.129483,0.739666);
INSERT INTO ville VALUES(31271,31570,31,'Lanta',43.562494,1.657388);
INSERT INTO ville VALUES(31272,31310,31,'Lapeyrère',43.184475,1.241901);
INSERT INTO ville VALUES(31273,31180,31,'Lapeyrouse-Fossat',43.688134,1.515726);
INSERT INTO ville VALUES(31274,31800,31,'Larcan',43.129483,0.739666);
INSERT INTO ville VALUES(31275,31480,31,'Laréole',43.744424,1.047518);
INSERT INTO ville VALUES(31276,31580,31,'Larroque',43.168189,0.545810);
INSERT INTO ville VALUES(31277,31530,31,'Lasserre',43.668122,1.151369);
INSERT INTO ville VALUES(31278,31800,31,'Latoue',43.129483,0.739666);
INSERT INTO ville VALUES(31279,31310,31,'Latour',43.184475,1.241901);
INSERT INTO ville VALUES(31280,31310,31,'Latrape',43.184475,1.241901);
INSERT INTO ville VALUES(31281,31330,31,'Launac',43.758627,1.234949);
INSERT INTO ville VALUES(31282,31140,31,'Launaguet',43.690586,1.453343);
INSERT INTO ville VALUES(31283,31370,31,'Lautignac',43.408338,1.105762);
INSERT INTO ville VALUES(31284,31650,31,'Lauzerville',43.554087,1.546355);
INSERT INTO ville VALUES(31285,31590,31,'Lavalette',43.647632,1.648597);
INSERT INTO ville VALUES(31286,31220,31,'Lavelanet-de-Comminges',43.204108,1.058034);
INSERT INTO ville VALUES(31287,31410,31,'Lavernose-Lacasse',43.359647,1.272951);
INSERT INTO ville VALUES(31288,31340,31,'Layrac-sur-Tarn',43.841512,1.511544);
INSERT INTO ville VALUES(31289,31580,31,'Lécussan',43.168189,0.545810);
INSERT INTO ville VALUES(31290,31440,31,'Lège',42.894858,0.717828);
INSERT INTO ville VALUES(31291,31490,31,'Léguevin',43.595773,1.235214);
INSERT INTO ville VALUES(31292,31220,31,'Lescuns',43.204108,1.058034);
INSERT INTO ville VALUES(31293,31150,31,'Lespinasse',43.709315,1.397339);
INSERT INTO ville VALUES(31294,31160,31,'Lespiteau',43.000016,0.824626);
INSERT INTO ville VALUES(31295,31350,31,'Lespugue',43.267351,0.677755);
INSERT INTO ville VALUES(31296,31360,31,'Lestelle-de-Saint-Martory',43.152071,0.901698);
INSERT INTO ville VALUES(31297,31530,31,'Lévignac',43.668122,1.151369);
INSERT INTO ville VALUES(31298,31440,31,'Lez',42.894858,0.717828);
INSERT INTO ville VALUES(31299,31600,31,'Lherm',43.454242,1.287336);
INSERT INTO ville VALUES(31301,31230,31,'Lilhac',43.343616,0.842227);
INSERT INTO ville VALUES(31302,31800,31,'Lodes',43.129483,0.739666);
INSERT INTO ville VALUES(31303,31410,31,'Longages',43.359647,1.272951);
INSERT INTO ville VALUES(31304,31460,31,'Loubens-Lauragais',43.526815,1.782461);
INSERT INTO ville VALUES(31305,31580,31,'Loudet',43.168189,0.545810);
INSERT INTO ville VALUES(31306,31510,31,'Lourde',43.015670,0.628269);
INSERT INTO ville VALUES(31307,31350,31,'Lunax',43.267351,0.677755);
INSERT INTO ville VALUES(31308,31510,31,'Luscan',43.015670,0.628269);
INSERT INTO ville VALUES(31309,31430,31,'Lussan-Adeilhac',43.310591,1.046206);
INSERT INTO ville VALUES(31310,31290,31,'Lux',43.406380,1.727640);
INSERT INTO ville VALUES(31406,31220,31,'Palaminy',43.204108,1.058034);
INSERT INTO ville VALUES(31407,31380,31,'Paulhac',43.735440,1.588465);
INSERT INTO ville VALUES(31408,31510,31,'Payssous',43.015670,0.628269);
INSERT INTO ville VALUES(31592,31330,31,'Larra',43.758627,1.234949);
INSERT INTO ville VALUES(32167,32170,32,'Laas',43.414652,0.335871);
INSERT INTO ville VALUES(32168,32250,32,'Labarrère',43.965040,0.196127);
INSERT INTO ville VALUES(32169,32260,32,'Labarthe',43.500086,0.623202);
INSERT INTO ville VALUES(32170,32400,32,'Labarthète',43.655586,-0.127080);
INSERT INTO ville VALUES(32171,32130,32,'Labastide-Savès',43.515398,0.936869);
INSERT INTO ville VALUES(32172,32300,32,'Labéjan',43.472658,0.421869);
INSERT INTO ville VALUES(32173,32120,32,'Labrihe',43.768211,0.838832);
INSERT INTO ville VALUES(32174,32230,32,'Ladevèze-Rivière',43.541524,0.168544);
INSERT INTO ville VALUES(32175,32230,32,'Ladevèze-Ville',43.541524,0.168544);
INSERT INTO ville VALUES(32176,32700,32,'Lagarde',43.977041,0.588864);
INSERT INTO ville VALUES(32177,32300,32,'Lagarde-Hachan',43.472658,0.421869);
INSERT INTO ville VALUES(32178,32310,32,'Lagardère',43.856044,0.391729);
INSERT INTO ville VALUES(32180,32330,32,'Lagraulet-du-Gers',43.880971,0.243426);
INSERT INTO ville VALUES(32181,32170,32,'Laguian-Mazous',43.414652,0.335871);
INSERT INTO ville VALUES(32182,32130,32,'Lahas',43.515398,0.936869);
INSERT INTO ville VALUES(32183,32810,32,'Lahitte',43.698938,0.607689);
INSERT INTO ville VALUES(32184,32500,32,'Lalanne',43.842576,0.625456);
INSERT INTO ville VALUES(32185,32140,32,'Lalanne-Arqué',43.394892,0.589239);
INSERT INTO ville VALUES(32186,32260,32,'Lamaguère',43.500086,0.623202);
INSERT INTO ville VALUES(32187,32300,32,'Lamazère',43.472658,0.421869);
INSERT INTO ville VALUES(32188,32500,32,'Lamothe-Goas',43.842576,0.625456);
INSERT INTO ville VALUES(32189,32240,32,'Lannemaignan',43.859398,-0.135898);
INSERT INTO ville VALUES(32190,32190,32,'Lannepax',43.730028,0.247608);
INSERT INTO ville VALUES(32191,32110,32,'Lanne-Soubiran',43.772389,-0.055600);
INSERT INTO ville VALUES(32192,32400,32,'Lannux',43.655586,-0.127080);
INSERT INTO ville VALUES(32193,32150,32,'Larée',43.927636,-0.050856);
INSERT INTO ville VALUES(32194,32100,32,'Larressingle',43.959878,0.379639);
INSERT INTO ville VALUES(32195,32480,32,'Larroque-Engalin',44.009604,0.515281);
INSERT INTO ville VALUES(32196,32410,32,'Larroque-Saint-Sernin',43.808510,0.434325);
INSERT INTO ville VALUES(32197,32100,32,'Larroque-sur-l''Osse',43.959878,0.379639);
INSERT INTO ville VALUES(32198,32450,32,'Lartigue',43.552194,0.738108);
INSERT INTO ville VALUES(32199,32160,32,'Lasserade',43.599677,0.071199);
INSERT INTO ville VALUES(32200,32550,32,'Lasséran',43.598059,0.589974);
INSERT INTO ville VALUES(32201,32550,32,'Lasseube-Propre',43.598059,0.589974);
INSERT INTO ville VALUES(32202,32110,32,'Laujuzan',43.772389,-0.055600);
INSERT INTO ville VALUES(32203,32330,32,'Lauraët',43.880971,0.243426);
INSERT INTO ville VALUES(32204,32360,32,'Lavardens',43.747718,0.478950);
INSERT INTO ville VALUES(32205,32230,32,'Laveraët',43.541524,0.168544);
INSERT INTO ville VALUES(32206,32220,32,'Laymont',43.443859,0.902633);
INSERT INTO ville VALUES(32207,32810,32,'Leboulin',43.698938,0.607689);
INSERT INTO ville VALUES(32208,32700,32,'Lectoure',43.977041,0.588864);
INSERT INTO ville VALUES(32209,32400,32,'Lelin-Lapujolle',43.655586,-0.127080);
INSERT INTO ville VALUES(32210,32600,32,'Lias',43.600365,1.084194);
INSERT INTO ville VALUES(32211,32240,32,'Lias-d''Armagnac',43.859398,-0.135898);
INSERT INTO ville VALUES(32212,32480,32,'Ligardes',44.009604,0.515281);
INSERT INTO ville VALUES(32213,32220,32,'Lombez',43.443859,0.902633);
INSERT INTO ville VALUES(32214,32110,32,'Loubédat',43.772389,-0.055600);
INSERT INTO ville VALUES(32215,32300,32,'Loubersan',43.472658,0.421869);
INSERT INTO ville VALUES(32216,32140,32,'Lourties-Monbrun',43.394892,0.589239);
INSERT INTO ville VALUES(32217,32230,32,'Louslitges',43.541524,0.168544);
INSERT INTO ville VALUES(32218,32290,32,'Loussous-Débat',43.707755,0.115891);
INSERT INTO ville VALUES(32219,32290,32,'Lupiac',43.707755,0.115891);
INSERT INTO ville VALUES(32220,32110,32,'Luppé-Violles',43.772389,-0.055600);
INSERT INTO ville VALUES(32221,32270,32,'Lussan',43.668659,0.765223);
INSERT INTO ville VALUES(32303,32230,32,'Pallanne',43.541524,0.168544);
INSERT INTO ville VALUES(32304,32140,32,'Panassac',43.394892,0.589239);
INSERT INTO ville VALUES(32305,32110,32,'Panjas',43.772389,-0.055600);
INSERT INTO ville VALUES(32306,32500,32,'Pauilhac',43.842576,0.625456);
INSERT INTO ville VALUES(32307,32550,32,'Pavie',43.598059,0.589974);
INSERT INTO ville VALUES(33211,33460,33,'Labarde',45.050874,-0.660191);
INSERT INTO ville VALUES(33212,33690,33,'Labescau',44.414031,-0.054441);
INSERT INTO ville VALUES(33214,33680,33,'Lacanau',44.939075,-1.057218);
INSERT INTO ville VALUES(33215,33760,33,'Ladaux',45.067530,-0.586585);
INSERT INTO ville VALUES(33216,33124,33,'Lados',44.491740,-0.108048);
INSERT INTO ville VALUES(33218,33230,33,'Lagorce',45.056057,-0.118323);
INSERT INTO ville VALUES(33219,33240,33,'Lande-de-Fronsac',44.998209,-0.389451);
INSERT INTO ville VALUES(33220,33460,33,'Lamarque',45.050874,-0.660191);
INSERT INTO ville VALUES(33221,33190,33,'Lamothe-Landerron',44.576479,-0.011378);
INSERT INTO ville VALUES(33222,33500,33,'Lalande-de-Pomerol',44.918025,-0.231505);
INSERT INTO ville VALUES(33223,33790,33,'Landerrouat',44.742561,0.076562);
INSERT INTO ville VALUES(33224,33540,33,'Landerrouet-sur-Ségur',44.701534,-0.096397);
INSERT INTO ville VALUES(33225,33720,33,'Landiras',44.599994,-0.433030);
INSERT INTO ville VALUES(33226,33550,33,'Langoiran',44.717044,-0.368152);
INSERT INTO ville VALUES(33227,33210,33,'Langon',44.536640,-0.259754);
INSERT INTO ville VALUES(33228,33710,33,'Lansac',45.060853,-0.568205);
INSERT INTO ville VALUES(33229,33138,33,'Lanton',44.772451,-0.982218);
INSERT INTO ville VALUES(33230,33620,33,'Lapouyade',45.107123,-0.361745);
INSERT INTO ville VALUES(33231,33410,33,'Laroque',44.638501,-0.276075);
INSERT INTO ville VALUES(33232,33840,33,'Lartigue',44.288860,-0.214869);
INSERT INTO ville VALUES(33233,33620,33,'Laruscade',45.107123,-0.361745);
INSERT INTO ville VALUES(33234,33360,33,'Latresne',44.782156,-0.465561);
INSERT INTO ville VALUES(33235,33690,33,'Lavazan',44.414031,-0.054441);
INSERT INTO ville VALUES(33236,33950,33,'Lège-Cap-Ferret',44.756834,-1.153610);
INSERT INTO ville VALUES(33237,33210,33,'Léogeats',44.536640,-0.259754);
INSERT INTO ville VALUES(33238,33850,33,'Léognan',44.723408,-0.617286);
INSERT INTO ville VALUES(33239,33840,33,'Lerm-et-Musset',44.288860,-0.214869);
INSERT INTO ville VALUES(33240,33340,33,'Lesparre-Médoc',45.306641,-0.912964);
INSERT INTO ville VALUES(33241,33550,33,'Lestiac-sur-Garonne',44.717044,-0.368152);
INSERT INTO ville VALUES(33242,33220,33,'Lèves-et-Thoumeyragues',44.817427,0.210935);
INSERT INTO ville VALUES(33243,33500,33,'Libourne',44.918025,-0.231505);
INSERT INTO ville VALUES(33244,33430,33,'Lignan-de-Bazas',44.408293,-0.203976);
INSERT INTO ville VALUES(33245,33360,33,'Lignan-de-Bordeaux',44.782156,-0.465561);
INSERT INTO ville VALUES(33246,33220,33,'Ligueux',44.817427,0.210935);
INSERT INTO ville VALUES(33247,33790,33,'Listrac-de-Durèze',44.742561,0.076562);
INSERT INTO ville VALUES(33248,33480,33,'Listrac-Médoc',45.005957,-0.854479);
INSERT INTO ville VALUES(33249,33310,33,'Lormont',44.875126,-0.517829);
INSERT INTO ville VALUES(33250,33190,33,'Loubens',44.576479,-0.011378);
INSERT INTO ville VALUES(33251,33125,33,'Louchats',44.519957,-0.632643);
INSERT INTO ville VALUES(33252,33370,33,'Loupes',44.847936,-0.432935);
INSERT INTO ville VALUES(33253,33410,33,'Loupiac',44.638501,-0.276075);
INSERT INTO ville VALUES(33254,33190,33,'Loupiac-de-la-Réole',44.576479,-0.011378);
INSERT INTO ville VALUES(33255,33840,33,'Lucmau',44.288860,-0.214869);
INSERT INTO ville VALUES(33256,33290,33,'Ludon-Médoc',44.946895,-0.632419);
INSERT INTO ville VALUES(33257,33420,33,'Lugaignac',44.826990,-0.203915);
INSERT INTO ville VALUES(33258,33760,33,'Lugasson',45.067530,-0.586585);
INSERT INTO ville VALUES(33259,33240,33,'Lugon-et-l''Île-du-Carnay',44.998209,-0.389451);
INSERT INTO ville VALUES(33260,33830,33,'Lugos',44.495878,-0.855813);
INSERT INTO ville VALUES(33261,33570,33,'Lussac',44.952309,-0.083434);
INSERT INTO ville VALUES(33311,33550,33,'Paillet',44.717044,-0.368152);
INSERT INTO ville VALUES(33312,33290,33,'Parempuyre',44.946895,-0.632419);
INSERT INTO ville VALUES(33314,33250,33,'Pauillac',45.189287,-0.801717);
INSERT INTO ville VALUES(34124,34800,34,'Lacoste',43.615135,3.373854);
INSERT INTO ville VALUES(34125,34150,34,'Lagamas',43.703059,3.565363);
INSERT INTO ville VALUES(34126,34240,34,'Lamalou-les-Bains',43.602419,3.065884);
INSERT INTO ville VALUES(34127,34130,34,'Lansargues',43.618144,4.021615);
INSERT INTO ville VALUES(34128,34190,34,'Laroque',43.897972,3.709731);
INSERT INTO ville VALUES(34129,34970,34,'Lattes',43.566921,3.898821);
INSERT INTO ville VALUES(34130,34480,34,'Laurens',43.495833,3.187718);
INSERT INTO ville VALUES(34131,34270,34,'Lauret',43.797492,3.864161);
INSERT INTO ville VALUES(34132,34700,34,'Lauroux',43.758024,3.362597);
INSERT INTO ville VALUES(34133,34700,34,'Lavalette',43.758024,3.362597);
INSERT INTO ville VALUES(34134,34880,34,'Lavérune',43.584522,3.800046);
INSERT INTO ville VALUES(34135,34710,34,'Lespignan',43.273690,3.169004);
INSERT INTO ville VALUES(34136,34120,34,'Lézignan-la-Cèbe',43.463605,3.428991);
INSERT INTO ville VALUES(34137,34800,34,'Liausson',43.615135,3.373854);
INSERT INTO ville VALUES(34138,34800,34,'Lieuran-Cabrières',43.615135,3.373854);
INSERT INTO ville VALUES(34139,34290,34,'Lieuran-lès-Béziers',43.413111,3.302380);
INSERT INTO ville VALUES(34140,34490,34,'Lignan-sur-Orb',43.463047,3.132023);
INSERT INTO ville VALUES(34141,34210,34,'Livinière',43.356310,2.707729);
INSERT INTO ville VALUES(34142,34700,34,'Lodève',43.758024,3.362597);
INSERT INTO ville VALUES(34143,34140,34,'Loupian',43.442101,3.596685);
INSERT INTO ville VALUES(34144,34650,34,'Lunas',43.723627,3.197792);
INSERT INTO ville VALUES(34145,34400,34,'Lunel',43.682696,4.108200);
INSERT INTO ville VALUES(34146,34400,34,'Lunel-Viel',43.682696,4.108200);
INSERT INTO ville VALUES(34191,34490,34,'Pailhès',43.463047,3.132023);
INSERT INTO ville VALUES(34192,34250,34,'Palavas-les-Flots',43.532355,3.934621);
INSERT INTO ville VALUES(34193,34360,34,'Pardailhan',43.436420,2.892919);
INSERT INTO ville VALUES(34194,34230,34,'Paulhan',43.565570,3.541067);
INSERT INTO ville VALUES(35138,35133,35,'Laignelet',48.358357,-1.195703);
INSERT INTO ville VALUES(35139,35890,35,'Laillé',47.955613,-1.718206);
INSERT INTO ville VALUES(35140,35320,35,'Lalleu',47.889205,-1.589362);
INSERT INTO ville VALUES(35141,35450,35,'Landavran',48.204684,-1.320050);
INSERT INTO ville VALUES(35142,35133,35,'Landéan',48.358357,-1.195703);
INSERT INTO ville VALUES(35143,35360,35,'Landujan',48.222503,-2.051893);
INSERT INTO ville VALUES(35144,35850,35,'Langan',48.220161,-1.870864);
INSERT INTO ville VALUES(35145,35660,35,'Langon',47.720123,-1.927394);
INSERT INTO ville VALUES(35146,35630,35,'Langouet',48.279604,-1.820102);
INSERT INTO ville VALUES(35147,35720,35,'Lanhélin',48.436784,-1.882721);
INSERT INTO ville VALUES(35148,35270,35,'Lanrigan',48.425772,-1.744390);
INSERT INTO ville VALUES(35149,35580,35,'Lassy',47.966260,-1.858921);
INSERT INTO ville VALUES(35150,35133,35,'Lécousse',48.358357,-1.195703);
INSERT INTO ville VALUES(35151,35550,35,'Lieuron',47.809712,-1.995738);
INSERT INTO ville VALUES(35152,35340,35,'Liffré',48.202898,-1.489524);
INSERT INTO ville VALUES(35153,35111,35,'Lillemer',48.584106,-1.838636);
INSERT INTO ville VALUES(35154,35450,35,'Livré-sur-Changeon',48.204684,-1.320050);
INSERT INTO ville VALUES(35155,35550,35,'Lohéac',47.809712,-1.995738);
INSERT INTO ville VALUES(35156,35190,35,'Longaulnay',48.323373,-1.892825);
INSERT INTO ville VALUES(35157,35133,35,'Loroux',48.358358,-1.195703);
INSERT INTO ville VALUES(35158,35360,35,'Lou-du-Lac',48.222503,-2.051893);
INSERT INTO ville VALUES(35159,35270,35,'Lourmais',48.425772,-1.744390);
INSERT INTO ville VALUES(35160,35330,35,'Loutehel',47.905011,-2.004131);
INSERT INTO ville VALUES(35161,35680,35,'Louvigné-de-Bais',48.012756,-1.296158);
INSERT INTO ville VALUES(35162,35420,35,'Louvigné-du-Désert',48.479516,-1.197401);
INSERT INTO ville VALUES(35163,35133,35,'Luitré',48.358357,-1.195703);
INSERT INTO ville VALUES(35210,35740,35,'Pacé',48.444537,-0.003803);
INSERT INTO ville VALUES(35211,35380,35,'Paimpont',48.014998,-2.126012);
INSERT INTO ville VALUES(35212,35320,35,'Pancé',47.889205,-1.589362);
INSERT INTO ville VALUES(35214,35210,35,'Parcé',48.246446,-1.189636);
INSERT INTO ville VALUES(35215,35133,35,'Parigné',48.358357,-1.195703);
INSERT INTO ville VALUES(35216,35850,35,'Parthenay-de-Bretagne',48.220161,-1.870864);
INSERT INTO ville VALUES(36091,36400,36,'Lacs',46.616154,2.041818);
INSERT INTO ville VALUES(36092,36600,36,'Langé',47.157163,1.511734);
INSERT INTO ville VALUES(36093,36110,36,'Levroux',46.987947,1.627539);
INSERT INTO ville VALUES(36094,36370,36,'Lignac',46.517803,1.184619);
INSERT INTO ville VALUES(36095,36160,36,'Lignerolles',46.486695,2.085418);
INSERT INTO ville VALUES(36096,36220,36,'Lingé',46.719657,1.024293);
INSERT INTO ville VALUES(36097,36150,36,'Liniez',47.068340,1.806825);
INSERT INTO ville VALUES(36098,36100,36,'Lizeray',46.908478,1.950651);
INSERT INTO ville VALUES(36099,36140,36,'Lourdoueix-Saint-Michel',46.456011,1.834183);
INSERT INTO ville VALUES(36100,36400,36,'Lourouer-Saint-Laurent',46.616154,2.041818);
INSERT INTO ville VALUES(36101,36350,36,'Luant',46.718274,1.549537);
INSERT INTO ville VALUES(36102,36150,36,'Luçay-le-Libre',47.068340,1.806825);
INSERT INTO ville VALUES(36103,36360,36,'Luçay-le-Mâle',47.138822,1.406711);
INSERT INTO ville VALUES(36104,36220,36,'Lurais',46.719657,1.024293);
INSERT INTO ville VALUES(36105,36220,36,'Lureuil',46.719657,1.024293);
INSERT INTO ville VALUES(36106,36800,36,'Luzeret',46.645690,1.385990);
INSERT INTO ville VALUES(36107,36600,36,'Lye',47.157163,1.511734);
INSERT INTO ville VALUES(36108,36230,36,'Lys-Saint-Georges',46.597412,1.822642);
INSERT INTO ville VALUES(36149,36500,36,'Palluau-sur-Indre',46.860347,1.431805);
INSERT INTO ville VALUES(36150,36170,36,'Parnac',46.457554,1.423275);
INSERT INTO ville VALUES(36151,36210,36,'Parpeçay',47.186886,1.694888);
INSERT INTO ville VALUES(36152,36260,36,'Paudy',47.051121,1.972506);
INSERT INTO ville VALUES(36153,36290,36,'Paulnay',46.844871,1.167156);
INSERT INTO ville VALUES(37123,37130,37,'Langeais',47.339463,0.385503);
INSERT INTO ville VALUES(37124,37270,37,'Larçay',47.342564,0.855846);
INSERT INTO ville VALUES(37125,37120,37,'Lémeré',47.025083,0.382517);
INSERT INTO ville VALUES(37126,37500,37,'Lerné',47.150659,0.223268);
INSERT INTO ville VALUES(37127,37460,37,'Liège',47.154248,1.200884);
INSERT INTO ville VALUES(37128,37130,37,'Lignières-de-Touraine',47.339463,0.385503);
INSERT INTO ville VALUES(37129,37500,37,'Ligré',47.150659,0.223268);
INSERT INTO ville VALUES(37130,37240,37,'Ligueil',47.087803,0.816953);
INSERT INTO ville VALUES(37131,37530,37,'Limeray',47.447872,1.024360);
INSERT INTO ville VALUES(37132,37600,37,'Loches',47.059406,1.025512);
INSERT INTO ville VALUES(37133,37460,37,'Loché-sur-Indrois',47.154248,1.200883);
INSERT INTO ville VALUES(37134,37320,37,'Louans',47.244419,0.784298);
INSERT INTO ville VALUES(37135,37370,37,'Louestault',47.629094,0.553201);
INSERT INTO ville VALUES(37136,37240,37,'Louroux',47.087804,0.816954);
INSERT INTO ville VALUES(37137,37330,37,'Lublé',47.530781,0.316896);
INSERT INTO ville VALUES(37138,37400,37,'Lussault-sur-Loire',47.396485,0.978150);
INSERT INTO ville VALUES(37139,37230,37,'Luynes',47.417300,0.557869);
INSERT INTO ville VALUES(37140,37120,37,'Luzé',47.025083,0.382517);
INSERT INTO ville VALUES(37141,37150,37,'Luzillé',47.300471,1.046396);
INSERT INTO ville VALUES(37178,37220,37,'Panzoult',47.127832,0.428365);
INSERT INTO ville VALUES(37179,37210,37,'Parçay-Meslay',47.439725,0.821605);
INSERT INTO ville VALUES(37180,37220,37,'Parçay-sur-Vienne',47.127832,0.428365);
INSERT INTO ville VALUES(37181,37350,37,'Paulmy',46.936791,0.838473);
INSERT INTO ville VALUES(38034,38270,38,'Beaurepaire',45.359931,5.030076);
INSERT INTO ville VALUES(38203,38220,38,'Laffrey',45.074662,5.854286);
INSERT INTO ville VALUES(38204,38930,38,'Lalley',44.790948,5.588714);
INSERT INTO ville VALUES(38205,38250,38,'Lans-en-Vercors',45.080408,5.559536);
INSERT INTO ville VALUES(38206,38190,38,'Laval',45.228524,5.937814);
INSERT INTO ville VALUES(38207,38350,38,'Lavaldens',44.948126,5.812927);
INSERT INTO ville VALUES(38208,38710,38,'Lavars',44.789935,5.772820);
INSERT INTO ville VALUES(38209,38270,38,'Lentiol',45.359931,5.030076);
INSERT INTO ville VALUES(38210,38460,38,'Leyrieu',45.717337,5.268161);
INSERT INTO ville VALUES(38211,38440,38,'Lieudieu',45.493836,5.132846);
INSERT INTO ville VALUES(38212,38220,38,'Livet-et-Gavet',45.074662,5.854286);
INSERT INTO ville VALUES(38213,38690,38,'Longechenal',45.449934,5.404510);
INSERT INTO ville VALUES(38214,38660,38,'Lumbin',45.358739,5.911148);
INSERT INTO ville VALUES(38215,38200,38,'Luzinay',45.534087,4.907182);
INSERT INTO ville VALUES(38290,38270,38,'Pact',45.352803,4.989718);
INSERT INTO ville VALUES(38291,38260,38,'Pajay',45.388881,5.238874);
INSERT INTO ville VALUES(38292,38137,38,'Paladru',45.268150,5.107480);
INSERT INTO ville VALUES(38293,38730,38,'Panissage',45.483048,5.484851);
INSERT INTO ville VALUES(38294,38460,38,'Panossas',45.717337,5.268161);
INSERT INTO ville VALUES(38295,38390,38,'Parmilieu',45.817855,5.375723);
INSERT INTO ville VALUES(38296,38490,38,'Passage',45.558145,5.565752);
INSERT INTO ville VALUES(38297,38510,38,'Passins',45.700880,5.463581);
INSERT INTO ville VALUES(39271,39150,39,'Lac-des-Rouges-Truites',46.599906,5.939709);
INSERT INTO ville VALUES(39272,39210,39,'Ladoye-sur-Seille',46.753103,5.636583);
INSERT INTO ville VALUES(39273,39320,39,'Lains',46.411695,5.447948);
INSERT INTO ville VALUES(39274,00000,39,'Lajoux',45.878896,1.258220);
INSERT INTO ville VALUES(39275,39310,39,'Lamoura',46.362131,5.948105);
INSERT INTO ville VALUES(39277,39300,39,'Larderet',46.755376,5.892536);
INSERT INTO ville VALUES(39278,39130,39,'Largillay-Marsonnay',46.581397,5.787495);
INSERT INTO ville VALUES(39279,39140,39,'Larnaud',46.753255,5.441349);
INSERT INTO ville VALUES(39280,39360,39,'Larrivoire',46.330973,5.744602);
INSERT INTO ville VALUES(39281,39300,39,'Latet',46.755376,5.892536);
INSERT INTO ville VALUES(39282,39250,39,'Latette',46.776998,6.084165);
INSERT INTO ville VALUES(39283,01590,39,'Lavancia-Epercy',46.337674,5.670993);
INSERT INTO ville VALUES(39284,39700,39,'Lavangeot',47.135529,5.677991);
INSERT INTO ville VALUES(39285,39700,39,'Lavans-lès-Dole',47.135529,5.677991);
INSERT INTO ville VALUES(39286,39170,39,'Lavans-lès-Saint-Claude',46.422183,5.788956);
INSERT INTO ville VALUES(39287,39240,39,'Lavans-sur-Valouse',46.364404,5.566043);
INSERT INTO ville VALUES(39288,39210,39,'Lavigny',46.753103,5.636583);
INSERT INTO ville VALUES(39289,39260,39,'Lect',46.427877,5.733476);
INSERT INTO ville VALUES(39290,39240,39,'Légna',46.364404,5.566043);
INSERT INTO ville VALUES(39291,39110,39,'Lemuy',46.925033,5.910589);
INSERT INTO ville VALUES(39292,39300,39,'Lent',46.755375,5.892536);
INSERT INTO ville VALUES(39293,39170,39,'Leschères',46.422183,5.788956);
INSERT INTO ville VALUES(39294,39400,39,'Lézat',46.514463,6.010310);
INSERT INTO ville VALUES(39295,39320,39,'Loisia',46.411695,5.447948);
INSERT INTO ville VALUES(39296,39230,39,'Lombard',46.832810,5.532683);
INSERT INTO ville VALUES(39297,39400,39,'Longchaumois',46.514463,6.010310);
INSERT INTO ville VALUES(39298,39250,39,'Longcochon',46.776998,6.084165);
INSERT INTO ville VALUES(39299,39120,39,'Longwy-sur-le-Doubs',46.949838,5.405247);
INSERT INTO ville VALUES(39300,39000,39,'Lons-le-Saunier',46.675797,5.557303);
INSERT INTO ville VALUES(39301,39300,39,'Loulle',46.755375,5.892536);
INSERT INTO ville VALUES(39302,39350,39,'Louvatange',47.224094,5.684762);
INSERT INTO ville VALUES(39303,39320,39,'Louvenne',46.411695,5.447948);
INSERT INTO ville VALUES(39304,39210,39,'Louverot',46.753103,5.636584);
INSERT INTO ville VALUES(39305,39380,39,'Loye',47.018034,5.642221);
INSERT INTO ville VALUES(39402,39350,39,'Pagney',47.224094,5.684762);
INSERT INTO ville VALUES(39403,39330,39,'Pagnoz',46.977762,5.804511);
INSERT INTO ville VALUES(39404,39570,39,'Pannessières',46.650538,5.594555);
INSERT INTO ville VALUES(39405,39100,39,'Parcey',47.080921,5.464680);
INSERT INTO ville VALUES(39406,39300,39,'Pasquier',46.755376,5.892536);
INSERT INTO ville VALUES(39407,39230,39,'Passenans',46.832810,5.532683);
INSERT INTO ville VALUES(39408,39130,39,'Patornay',46.581397,5.787495);
INSERT INTO ville VALUES(40130,40700,40,'Labastide-Chalosse',43.627148,-0.590359);
INSERT INTO ville VALUES(40131,40240,40,'Labastide-d''Armagnac',44.033976,-0.130797);
INSERT INTO ville VALUES(40132,40300,40,'Labatut',43.573268,-1.086333);
INSERT INTO ville VALUES(40133,40530,40,'Labenne',43.598244,-1.437671);
INSERT INTO ville VALUES(40134,40210,40,'Labouheyre',44.168813,-0.948952);
INSERT INTO ville VALUES(40135,40420,40,'Labrit',44.099239,-0.578181);
INSERT INTO ville VALUES(40136,40320,40,'Lacajunte',43.642886,-0.413445);
INSERT INTO ville VALUES(40137,40120,40,'Lacquy',44.102859,-0.315057);
INSERT INTO ville VALUES(40138,40700,40,'Lacrabe',43.627148,-0.590359);
INSERT INTO ville VALUES(40139,40090,40,'Laglorieuse',43.921915,-0.529941);
INSERT INTO ville VALUES(40140,40240,40,'Lagrange',44.033976,-0.130797);
INSERT INTO ville VALUES(40141,40250,40,'Lahosse',43.744594,-0.719099);
INSERT INTO ville VALUES(40142,40465,40,'Laluque',43.811449,-0.957952);
INSERT INTO ville VALUES(40143,40250,40,'Lamothe',43.744594,-0.719099);
INSERT INTO ville VALUES(40144,40250,40,'Larbey',43.744594,-0.719099);
INSERT INTO ville VALUES(40145,40270,40,'Larrivière-Saint-Savin',999,999);
INSERT INTO ville VALUES(40146,40800,40,'Latrille',43.663540,-0.277945);
INSERT INTO ville VALUES(40147,40250,40,'Laurède',43.744594,-0.719099);
INSERT INTO ville VALUES(40148,40320,40,'Lauret',43.642886,-0.413445);
INSERT INTO ville VALUES(40149,40120,40,'Lencouacq',44.102859,-0.315057);
INSERT INTO ville VALUES(40150,40550,40,'Léon',43.848834,-1.270252);
INSERT INTO ville VALUES(40151,40400,40,'Lesgor',43.846073,-0.797953);
INSERT INTO ville VALUES(40152,40260,40,'Lesperon',43.922416,-1.145076);
INSERT INTO ville VALUES(40153,40250,40,'Leuy',43.744594,-0.719100);
INSERT INTO ville VALUES(40154,40170,40,'Lévignacq',44.059940,-1.214715);
INSERT INTO ville VALUES(40155,40260,40,'Linxe',43.922416,-1.145076);
INSERT INTO ville VALUES(40156,40410,40,'Liposthey',44.353825,-0.787133);
INSERT INTO ville VALUES(40157,40170,40,'Lit-et-Mixe',44.059940,-1.214715);
INSERT INTO ville VALUES(40158,40240,40,'Losse',44.033976,-0.130797);
INSERT INTO ville VALUES(40159,40380,40,'Louer',43.721646,-0.838138);
INSERT INTO ville VALUES(40160,40250,40,'Lourquen',43.744594,-0.719099);
INSERT INTO ville VALUES(40161,40240,40,'Lubbon',44.033976,-0.130797);
INSERT INTO ville VALUES(40162,40090,40,'Lucbardez-et-Bargues',43.921915,-0.529941);
INSERT INTO ville VALUES(40163,40210,40,'Lüe',44.168813,-0.948952);
INSERT INTO ville VALUES(40165,40630,40,'Luglon',44.159144,-0.733183);
INSERT INTO ville VALUES(40166,40270,40,'Lussagnet',43.778762,-0.347982);
INSERT INTO ville VALUES(40167,40430,40,'Luxey',44.285494,-0.535066);
INSERT INTO ville VALUES(40217,40160,40,'Parentis-en-Born',44.354710,-1.091463);
INSERT INTO ville VALUES(40218,40310,40,'Parleboscq',44.013570,0.027704);
INSERT INTO ville VALUES(40219,40320,40,'Payros-Cazautets',43.642886,-0.413445);
INSERT INTO ville VALUES(41106,41600,41,'Lamotte-Beuvron',47.578200,2.017855);
INSERT INTO ville VALUES(41107,41310,41,'Lancé',47.671152,0.974063);
INSERT INTO ville VALUES(41108,41190,41,'Lancôme',47.620718,1.124256);
INSERT INTO ville VALUES(41109,41190,41,'Landes-le-Gaulois',47.620718,1.124256);
INSERT INTO ville VALUES(41110,41320,41,'Langon',47.277299,1.845708);
INSERT INTO ville VALUES(41112,41230,41,'Lassay-sur-Croisne',47.422831,1.620518);
INSERT INTO ville VALUES(41113,41800,41,'Lavardin',47.755350,0.781042);
INSERT INTO ville VALUES(41114,41500,41,'Lestiou',47.708745,1.455390);
INSERT INTO ville VALUES(41115,41160,41,'Lignières',47.911858,1.184732);
INSERT INTO ville VALUES(41116,41100,41,'Lisle',47.797373,1.081089);
INSERT INTO ville VALUES(41118,41200,41,'Loreux',47.390317,1.746398);
INSERT INTO ville VALUES(41119,41370,41,'Lorges',47.809903,1.446633);
INSERT INTO ville VALUES(41120,41360,41,'Lunay',47.846698,0.865006);
INSERT INTO ville VALUES(42117,42560,42,'Lavieu',45.504189,4.050340);
INSERT INTO ville VALUES(42118,42470,42,'Lay',45.947486,4.217182);
INSERT INTO ville VALUES(42119,42130,42,'Leigneux',45.747538,4.007442);
INSERT INTO ville VALUES(42120,42155,42,'Lentigny',46.000164,3.965181);
INSERT INTO ville VALUES(42121,42600,42,'Lérigneux',45.623423,4.045477);
INSERT INTO ville VALUES(42122,42600,42,'Lézigneux',45.623423,4.045477);
INSERT INTO ville VALUES(42123,42420,42,'Lorette',45.508842,4.582010);
INSERT INTO ville VALUES(42124,42520,42,'Lupé',45.366421,4.672730);
INSERT INTO ville VALUES(42125,42260,42,'Luré',45.863388,3.990315);
INSERT INTO ville VALUES(42126,42380,42,'Luriecq',45.407416,4.078947);
INSERT INTO ville VALUES(42163,42310,42,'Pacaudière',46.183345,3.888974);
INSERT INTO ville VALUES(42164,42890,42,'Palogneux',45.743629,3.920181);
INSERT INTO ville VALUES(42165,42360,42,'Panissières',45.793859,4.328294);
INSERT INTO ville VALUES(42166,42120,42,'Parigny',46.023585,4.112906);
INSERT INTO ville VALUES(42167,42410,42,'Pavezin',45.443563,4.686447);
INSERT INTO ville VALUES(43109,43490,43,'Lafarre',44.856129,3.927193);
INSERT INTO ville VALUES(43110,43100,43,'Lamothe',45.260307,3.369881);
INSERT INTO ville VALUES(43111,43340,43,'Landos',44.829410,3.788409);
INSERT INTO ville VALUES(43112,43300,43,'Langeac',45.069360,3.480785);
INSERT INTO ville VALUES(43113,43260,43,'Lantriac',45.034433,4.059410);
INSERT INTO ville VALUES(43114,43200,43,'Lapte',45.143506,4.156760);
INSERT INTO ville VALUES(43115,43150,43,'Laussonne',44.919858,4.046061);
INSERT INTO ville VALUES(43116,43440,43,'Laval-sur-Doulon',45.348125,3.520791);
INSERT INTO ville VALUES(43117,43100,43,'Lavaudieu',45.260307,3.369881);
INSERT INTO ville VALUES(43118,43380,43,'Lavoûte-Chilhac',45.168164,3.384594);
INSERT INTO ville VALUES(43119,43800,43,'Lavoûte-sur-Loire',45.147756,3.944245);
INSERT INTO ville VALUES(43120,43410,43,'Lempdes-sur-Allagnon',45.362529,3.254827);
INSERT INTO ville VALUES(43121,43410,43,'Léotoing',45.362529,3.254827);
INSERT INTO ville VALUES(43122,43350,43,'Lissac',45.161750,3.807621);
INSERT INTO ville VALUES(43123,43360,43,'Lorlanges',45.345468,3.299177);
INSERT INTO ville VALUES(43124,43320,43,'Loudes',45.085033,3.741468);
INSERT INTO ville VALUES(43125,43100,43,'Lubilhac',45.260307,3.369881);
INSERT INTO ville VALUES(43147,43100,43,'Paulhac',45.260307,3.369881);
INSERT INTO ville VALUES(43148,43230,43,'Paulhaguet',45.211442,3.551726);
INSERT INTO ville VALUES(44079,44430,44,'Landreau',47.227148,-1.287821);
INSERT INTO ville VALUES(44080,44260,44,'Lavau-sur-Loire',47.347290,-1.927095);
INSERT INTO ville VALUES(44081,44650,44,'Legé',46.926975,-1.619892);
INSERT INTO ville VALUES(44082,44850,44,'Ligné',47.384904,-1.387747);
INSERT INTO ville VALUES(44083,44310,44,'Limouzinière',47.049420,-1.628864);
INSERT INTO ville VALUES(44084,44430,44,'Loroux-Bottereau',47.237737,-1.348339);
INSERT INTO ville VALUES(44085,44110,44,'Louisfert',47.711729,-1.375535);
INSERT INTO ville VALUES(44086,44590,44,'Lusanger',47.685032,-1.588701);
INSERT INTO ville VALUES(44116,44560,44,'Paimbuf',999,999);
INSERT INTO ville VALUES(44117,44330,44,'Pallet',47.164528,-1.271625);
INSERT INTO ville VALUES(44118,44440,44,'Pannecé',47.498752,-1.330884);
INSERT INTO ville VALUES(44119,44270,44,'Paulx',46.987742,-1.798383);
INSERT INTO ville VALUES(45057,45330,45,'Labrosse',48.283885,2.347655);
INSERT INTO ville VALUES(45177,45300,45,'Laas',48.183207,2.261814);
INSERT INTO ville VALUES(45178,45270,45,'Ladon',47.987189,2.480091);
INSERT INTO ville VALUES(45179,45740,45,'Lailly-en-Val',47.746335,1.718332);
INSERT INTO ville VALUES(45180,45290,45,'Langesse',47.840082,2.685932);
INSERT INTO ville VALUES(45181,45480,45,'Léouville',48.216238,2.058632);
INSERT INTO ville VALUES(45182,45240,45,'Ligny-le-Ribault',47.724194,1.961426);
INSERT INTO ville VALUES(45183,45410,45,'Lion-en-Beauce',48.089864,1.868066);
INSERT INTO ville VALUES(45184,45600,45,'Lion-en-Sullias',47.730692,2.382978);
INSERT INTO ville VALUES(45185,45700,45,'Lombreuil',47.961064,2.707903);
INSERT INTO ville VALUES(45186,45490,45,'Lorcy',48.079493,2.604150);
INSERT INTO ville VALUES(45187,45260,45,'Lorris',47.884686,2.491228);
INSERT INTO ville VALUES(45188,45470,45,'Loury',47.983883,2.073196);
INSERT INTO ville VALUES(45189,45210,45,'Louzouer',48.076159,2.868051);
INSERT INTO ville VALUES(45246,45300,45,'Pannecières',48.183207,2.261814);
INSERT INTO ville VALUES(45247,45700,45,'Pannes',47.961064,2.707903);
INSERT INTO ville VALUES(45248,45310,45,'Patay',48.011700,1.659147);
INSERT INTO ville VALUES(45249,45200,45,'Paucourt',48.012447,2.779351);
INSERT INTO ville VALUES(46020,46260,46,'Beauregard',44.389270,1.757502);
INSERT INTO ville VALUES(46135,46210,46,'Labastide-du-Haut-Mont',44.778506,2.075303);
INSERT INTO ville VALUES(46136,46150,46,'Labastide-du-Vert',44.559158,1.337186);
INSERT INTO ville VALUES(46137,46090,46,'Labastide-Marnhac',44.467313,1.483690);
INSERT INTO ville VALUES(46138,46240,46,'Labastide-Murat',44.662564,1.597307);
INSERT INTO ville VALUES(46139,46120,46,'Labathude',44.747649,1.910180);
INSERT INTO ville VALUES(46140,46230,46,'Laburgade',44.322050,1.590628);
INSERT INTO ville VALUES(46141,46190,46,'Lacam-d''Ourcet',44.900006,2.022021);
INSERT INTO ville VALUES(46142,46700,46,'Lacapelle-Cabanac',44.493073,1.078753);
INSERT INTO ville VALUES(46143,46120,46,'Lacapelle-Marival',44.747649,1.910180);
INSERT INTO ville VALUES(46144,46200,46,'Lacave',44.894166,1.508179);
INSERT INTO ville VALUES(46145,46200,46,'Lachapelle-Auzac',44.894166,1.508179);
INSERT INTO ville VALUES(46146,46400,46,'Ladirat',44.849816,1.909271);
INSERT INTO ville VALUES(46147,46220,46,'Lagardelle',44.508600,1.184205);
INSERT INTO ville VALUES(46148,46230,46,'Lalbenque',44.322050,1.590628);
INSERT INTO ville VALUES(46149,46090,46,'Lamagdelaine',44.467313,1.483690);
INSERT INTO ville VALUES(46150,46190,46,'Lamativie',44.900006,2.022021);
INSERT INTO ville VALUES(46151,46240,46,'Lamothe-Cassel',44.662564,1.597307);
INSERT INTO ville VALUES(46152,46350,46,'Lamothe-Fénelon',44.810729,1.482806);
INSERT INTO ville VALUES(46153,46200,46,'Lanzac',44.894166,1.508179);
INSERT INTO ville VALUES(46154,46260,46,'Laramière',44.389270,1.757502);
INSERT INTO ville VALUES(46155,46160,46,'Larnagol',44.512740,1.858130);
INSERT INTO ville VALUES(46156,46090,46,'Laroque-des-Arcs',44.467313,1.483690);
INSERT INTO ville VALUES(46157,46160,46,'Larroque-Toirac',44.512740,1.858130);
INSERT INTO ville VALUES(46158,46800,46,'Lascabanes',44.358074,1.209955);
INSERT INTO ville VALUES(46159,46400,46,'Latouille-Lentillac',44.849816,1.909271);
INSERT INTO ville VALUES(46160,46210,46,'Latronquière',44.778506,2.075303);
INSERT INTO ville VALUES(46161,46210,46,'Lauresses',44.778506,2.075303);
INSERT INTO ville VALUES(46162,46360,46,'Lauzès',44.579811,1.594356);
INSERT INTO ville VALUES(46163,46130,46,'Laval-de-Cère',44.905950,1.855086);
INSERT INTO ville VALUES(46164,46340,46,'Lavercantière',44.666660,1.297395);
INSERT INTO ville VALUES(46165,46500,46,'Lavergne',44.779009,1.690876);
INSERT INTO ville VALUES(46166,46800,46,'Lebreil',44.358074,1.209955);
INSERT INTO ville VALUES(46167,46330,46,'Lentillac-du-Causse',44.500492,1.663297);
INSERT INTO ville VALUES(46168,46100,46,'Lentillac-Saint-Blaise',44.631140,1.997784);
INSERT INTO ville VALUES(46169,46300,46,'Léobard',44.751744,1.423344);
INSERT INTO ville VALUES(46170,46120,46,'Leyme',44.747649,1.910180);
INSERT INTO ville VALUES(46171,46150,46,'Lherm',44.559158,1.337186);
INSERT INTO ville VALUES(46172,46170,46,'Lhospitalet',44.291156,1.383261);
INSERT INTO ville VALUES(46173,46260,46,'Limogne-en-Quercy',44.389270,1.757502);
INSERT INTO ville VALUES(46174,46270,46,'Linac',44.644691,2.124450);
INSERT INTO ville VALUES(46175,46100,46,'Lissac-et-Mouret',44.631140,1.997784);
INSERT INTO ville VALUES(46176,46320,46,'Livernon',44.633562,1.815676);
INSERT INTO ville VALUES(46177,46130,46,'Loubressac',44.905950,1.855086);
INSERT INTO ville VALUES(46178,46350,46,'Loupiac',44.810729,1.482806);
INSERT INTO ville VALUES(46179,46260,46,'Lugagnac',44.389270,1.757502);
INSERT INTO ville VALUES(46180,46100,46,'Lunan',44.631140,1.997784);
INSERT INTO ville VALUES(46181,46240,46,'Lunegarde',44.662564,1.597307);
INSERT INTO ville VALUES(46182,46140,46,'Luzech',44.455576,1.264599);
INSERT INTO ville VALUES(46213,46500,46,'Padirac',44.779009,1.690876);
INSERT INTO ville VALUES(46214,46140,46,'Parnac',44.455576,1.264599);
INSERT INTO ville VALUES(46215,46350,46,'Payrac',44.810729,1.482806);
INSERT INTO ville VALUES(46216,46300,46,'Payrignac',44.751744,1.423344);
INSERT INTO ville VALUES(47121,47250,47,'Labastide-Castel-Amouroux',44.404842,0.088411);
INSERT INTO ville VALUES(47122,47350,47,'Labretonie',44.545348,0.299082);
INSERT INTO ville VALUES(47123,47150,47,'Lacapelle-Biron',44.536452,0.808637);
INSERT INTO ville VALUES(47124,47150,47,'Lacaussade',44.536452,0.808637);
INSERT INTO ville VALUES(47125,47360,47,'Lacépède',44.309955,0.545326);
INSERT INTO ville VALUES(47126,47350,47,'Lachapelle',44.545348,0.299082);
INSERT INTO ville VALUES(47127,47320,47,'Lafitte-sur-Lot',44.353114,0.398037);
INSERT INTO ville VALUES(47128,47240,47,'Lafox',44.197417,0.689994);
INSERT INTO ville VALUES(47129,47190,47,'Lagarrigue',44.304534,0.370264);
INSERT INTO ville VALUES(47130,47400,47,'Lagruère',44.414472,0.323107);
INSERT INTO ville VALUES(47131,47200,47,'Lagupie',44.555545,0.113306);
INSERT INTO ville VALUES(47132,47330,47,'Lalandusse',44.651387,0.581944);
INSERT INTO ville VALUES(47133,47310,47,'Lamontjoie',44.144325,0.551900);
INSERT INTO ville VALUES(47134,47170,47,'Lannes',44.056756,0.192607);
INSERT INTO ville VALUES(47135,47260,47,'Laparade',44.426546,0.460342);
INSERT INTO ville VALUES(47136,47800,47,'Laperche',44.595906,0.393924);
INSERT INTO ville VALUES(47137,47310,47,'Laplume',44.144325,0.551900);
INSERT INTO ville VALUES(47138,47340,47,'Laroque-Timbaut',44.300268,0.725097);
INSERT INTO ville VALUES(47139,47600,47,'Lasserre',44.100441,0.387405);
INSERT INTO ville VALUES(47140,47360,47,'Laugnac',44.309955,0.545326);
INSERT INTO ville VALUES(47141,47150,47,'Laussou',44.536452,0.808637);
INSERT INTO ville VALUES(47142,47410,47,'Lauzun',44.620292,0.481449);
INSERT INTO ville VALUES(47143,47230,47,'Lavardac',44.201540,0.281904);
INSERT INTO ville VALUES(47144,47800,47,'Lavergne',44.595906,0.393924);
INSERT INTO ville VALUES(47145,47390,47,'Layrac',44.123490,0.659466);
INSERT INTO ville VALUES(47146,47300,47,'Lédat',44.402368,0.725397);
INSERT INTO ville VALUES(47147,47120,47,'Lévignac-de-Guyenne',44.670186,0.229820);
INSERT INTO ville VALUES(47148,47700,47,'Leyritz-Moncassin',44.290064,0.087990);
INSERT INTO ville VALUES(47150,47200,47,'Longueville',44.507358,0.176785);
INSERT INTO ville VALUES(47151,47120,47,'Loubès-Bernac',44.670186,0.229820);
INSERT INTO ville VALUES(47152,47290,47,'Lougratte',44.541716,0.595251);
INSERT INTO ville VALUES(47154,47360,47,'Lusignan-Petit',44.309955,0.545326);
INSERT INTO ville VALUES(47198,47440,47,'Pailloles',44.457901,0.626795);
INSERT INTO ville VALUES(47199,47120,47,'Pardaillan',44.670186,0.229820);
INSERT INTO ville VALUES(47200,47210,47,'Parranquet',44.619235,0.749866);
INSERT INTO ville VALUES(47201,47520,47,'Passage',44.187881,0.583326);
INSERT INTO ville VALUES(47202,47150,47,'Paulhiac',44.536452,0.808637);
INSERT INTO ville VALUES(48078,48100,48,'Lachamp',44.596096,3.241920);
INSERT INTO ville VALUES(48079,48120,48,'Lajo',44.803504,3.444532);
INSERT INTO ville VALUES(48080,48300,48,'Langogne',44.698741,3.786906);
INSERT INTO ville VALUES(48081,48000,48,'Lanuéjols',44.519964,3.516801);
INSERT INTO ville VALUES(48082,48170,48,'Laubert',44.639211,3.672717);
INSERT INTO ville VALUES(48083,48700,48,'Laubies',44.677046,3.451655);
INSERT INTO ville VALUES(48084,48600,48,'Laval-Atger',44.789853,3.630063);
INSERT INTO ville VALUES(48085,48500,48,'Laval-du-Tarn',44.372012,3.257664);
INSERT INTO ville VALUES(48086,48250,48,'Luc',44.600542,3.846218);
INSERT INTO ville VALUES(48107,48100,48,'Palhers',44.596096,3.241920);
INSERT INTO ville VALUES(48108,48600,48,'Panouse',44.789854,3.630063);
INSERT INTO ville VALUES(48110,48140,48,'Paulhac-en-Margeride',44.899207,3.341734);
INSERT INTO ville VALUES(49171,49150,49,'Lande-Chasles',47.555800,-0.114181);
INSERT INTO ville VALUES(49172,49270,49,'Landemont',47.293647,-1.221568);
INSERT INTO ville VALUES(49173,49490,49,'Lasse',47.527445,0.102653);
INSERT INTO ville VALUES(49174,49430,49,'Lézigné',47.665209,-0.280514);
INSERT INTO ville VALUES(49175,49490,49,'Linières-Bouton',47.527445,0.102653);
INSERT INTO ville VALUES(49176,49220,49,'Lion-d''Angers',47.648308,-0.767379);
INSERT INTO ville VALUES(49177,49530,49,'Liré',47.319954,-1.157828);
INSERT INTO ville VALUES(49178,49440,49,'Loiré',47.575600,-1.040447);
INSERT INTO ville VALUES(49179,49710,49,'Longeron',47.027903,-1.043066);
INSERT INTO ville VALUES(49180,49160,49,'Longué-Jumelles',47.382015,-0.099134);
INSERT INTO ville VALUES(49181,49700,49,'Louerre',47.217306,-0.284457);
INSERT INTO ville VALUES(49182,49700,49,'Louresse-Rochemenier',47.217306,-0.284457);
INSERT INTO ville VALUES(49183,49370,49,'Louroux-Béconnais',47.522195,-0.885883);
INSERT INTO ville VALUES(49184,49500,49,'Louvaines',47.670905,-0.821209);
INSERT INTO ville VALUES(49185,49140,49,'Lué-en-Baugeois',47.553682,-0.344894);
INSERT INTO ville VALUES(49186,49320,49,'Luigné',47.340398,-0.409719);
INSERT INTO ville VALUES(49234,49390,49,'Parçay-les-Pins',47.411732,0.075211);
INSERT INTO ville VALUES(49235,49730,49,'Parnay',47.232298,0.034654);
INSERT INTO ville VALUES(49236,49560,49,'Passavant-sur-Layon',47.106748,-0.410935);
INSERT INTO ville VALUES(50261,50160,50,'Lamberville',49.023326,-0.951903);
INSERT INTO ville VALUES(50262,50800,50,'Lande-d''Airou',48.826520,-1.233302);
INSERT INTO ville VALUES(50263,50600,50,'Lapenty',48.581538,-1.091636);
INSERT INTO ville VALUES(50265,50430,50,'Laulne',49.233455,-1.544737);
INSERT INTO ville VALUES(50266,50510,50,'Lengronne',48.891114,-1.427828);
INSERT INTO ville VALUES(50267,50430,50,'Lessay',49.233455,-1.544737);
INSERT INTO ville VALUES(50268,50310,50,'Lestre',49.482524,-1.345946);
INSERT INTO ville VALUES(50269,50480,50,'Liesville-sur-Douve',49.406985,-1.297332);
INSERT INTO ville VALUES(50270,50700,50,'Lieusaint',49.514278,-1.504665);
INSERT INTO ville VALUES(50271,50670,50,'Lingeard',48.762321,-1.065115);
INSERT INTO ville VALUES(50272,50660,50,'Lingreville',48.980876,-1.470303);
INSERT INTO ville VALUES(50273,50250,50,'Lithaire',49.308942,-1.504300);
INSERT INTO ville VALUES(50274,50600,50,'Loges-Marchis',48.581538,-1.091636);
INSERT INTO ville VALUES(50275,50370,50,'Loges-sur-Brécey',48.719740,-1.179256);
INSERT INTO ville VALUES(50276,50530,50,'Lolif',48.734413,-1.458393);
INSERT INTO ville VALUES(50277,50290,50,'Longueville',48.901719,-1.485704);
INSERT INTO ville VALUES(50278,50510,50,'Loreur',48.891115,-1.427828);
INSERT INTO ville VALUES(50279,50570,50,'Lorey',49.121314,-1.264370);
INSERT INTO ville VALUES(50280,50570,50,'Lozon',49.121314,-1.264370);
INSERT INTO ville VALUES(50281,50320,50,'Lucerne-d''Outremer',48.802907,-1.402451);
INSERT INTO ville VALUES(50282,50870,50,'Luot',48.746336,-1.306161);
INSERT INTO ville VALUES(50283,50680,50,'Luzerne',49.182379,-0.993340);
INSERT INTO ville VALUES(50391,50600,50,'Parigny',48.581538,-1.091636);
INSERT INTO ville VALUES(51313,51120,51,'Lachy',48.713014,3.692962);
INSERT INTO ville VALUES(51314,51170,51,'Lagery',49.225964,3.783875);
INSERT INTO ville VALUES(51315,51290,51,'Landricourt',48.595534,4.643076);
INSERT INTO ville VALUES(51316,51290,51,'Larzicourt',48.595534,4.643076);
INSERT INTO ville VALUES(51317,51600,51,'Laval-sur-Tourbe',49.156997,4.541154);
INSERT INTO ville VALUES(51318,51110,51,'Lavannes',49.343201,4.171584);
INSERT INTO ville VALUES(51319,51230,51,'Lenharrée',48.725984,3.963054);
INSERT INTO ville VALUES(51320,51700,51,'Leuvrigny',49.065053,3.714331);
INSERT INTO ville VALUES(51321,51170,51,'Lhéry',49.225964,3.783875);
INSERT INTO ville VALUES(51322,51290,51,'Lignon',48.595534,4.643076);
INSERT INTO ville VALUES(51323,51230,51,'Linthelles',48.725984,3.963054);
INSERT INTO ville VALUES(51324,51230,51,'Linthes',48.725984,3.963054);
INSERT INTO ville VALUES(51325,51300,51,'Lisse-en-Champagne',48.747963,4.598340);
INSERT INTO ville VALUES(51326,51400,51,'Livry-Louvercy',49.123093,4.342905);
INSERT INTO ville VALUES(51327,51130,51,'Loisy-en-Brie',48.882502,4.042613);
INSERT INTO ville VALUES(51328,51300,51,'Loisy-sur-Marne',48.747963,4.598340);
INSERT INTO ville VALUES(51329,51220,51,'Loivre',49.340558,3.959397);
INSERT INTO ville VALUES(51331,51150,51,'Louvois',49.035691,4.181758);
INSERT INTO ville VALUES(51333,51500,51,'Ludes',49.170645,4.045029);
INSERT INTO ville VALUES(51334,51300,51,'Luxémont-et-Villotte',48.747963,4.598340);
INSERT INTO ville VALUES(51422,51390,51,'Pargny-lès-Reims',49.225637,3.890273);
INSERT INTO ville VALUES(51423,51340,51,'Pargny-sur-Saulx',48.768456,4.857485);
INSERT INTO ville VALUES(51424,51800,51,'Passavant-en-Argonne',49.115967,4.825398);
INSERT INTO ville VALUES(51425,51700,51,'Passy-Grigny',49.065053,3.714331);
INSERT INTO ville VALUES(52254,52330,52,'Lachapelle-en-Blaisy',48.211663,4.948164);
INSERT INTO ville VALUES(52256,52700,52,'Lafauche',48.260444,5.379841);
INSERT INTO ville VALUES(52257,52500,52,'Laferté-sur-Amance',47.774522,5.572866);
INSERT INTO ville VALUES(52258,52120,52,'Laferté-sur-Aube',48.066713,4.881558);
INSERT INTO ville VALUES(52260,52310,52,'Lamancine',48.210380,5.122067);
INSERT INTO ville VALUES(52262,52330,52,'Lamothe-en-Blaisy',48.211663,4.948164);
INSERT INTO ville VALUES(52264,52400,52,'Laneuvelle',47.956308,5.732606);
INSERT INTO ville VALUES(52267,52100,52,'Laneuville-au-Pont',48.642038,4.891652);
INSERT INTO ville VALUES(52269,52200,52,'Langres',47.849437,5.271676);
INSERT INTO ville VALUES(52271,52800,52,'Lanques-sur-Rognon',48.036753,5.278372);
INSERT INTO ville VALUES(52272,52120,52,'Lanty-sur-Aube',48.066713,4.881558);
INSERT INTO ville VALUES(52273,52400,52,'Larivière-Arnoncourt',47.956308,5.732606);
INSERT INTO ville VALUES(52274,52120,52,'Latrecey-Ormoy-sur-Aube',48.066713,4.881558);
INSERT INTO ville VALUES(52275,52140,52,'Lavernoy',47.982385,5.513666);
INSERT INTO ville VALUES(52276,52000,52,'Laville-aux-Bois',48.105767,5.136554);
INSERT INTO ville VALUES(52277,52140,52,'Lavilleneuve',47.982385,5.513666);
INSERT INTO ville VALUES(52280,52360,52,'Lecey',47.913031,5.462507);
INSERT INTO ville VALUES(52282,52210,52,'Leffonds',47.913087,5.028075);
INSERT INTO ville VALUES(52284,52110,52,'Leschères-sur-le-Blaiseron',48.369017,4.915773);
INSERT INTO ville VALUES(52285,52190,52,'Leuchey',47.676897,5.286938);
INSERT INTO ville VALUES(52286,52700,52,'Leurville',48.260444,5.379841);
INSERT INTO ville VALUES(52287,52150,52,'Levécourt',48.198285,5.605021);
INSERT INTO ville VALUES(52288,52230,52,'Lezéville',48.434295,5.327410);
INSERT INTO ville VALUES(52289,52700,52,'Liffol-le-Petit',48.260444,5.379841);
INSERT INTO ville VALUES(52290,52500,52,'Loges',47.774522,5.572867);
INSERT INTO ville VALUES(52291,52240,52,'Longchamp',48.097382,5.556403);
INSERT INTO ville VALUES(52292,52250,52,'Longeau-Percey',47.764242,5.252880);
INSERT INTO ville VALUES(52293,52220,52,'Longeville-sur-la-Laines',48.460959,4.765177);
INSERT INTO ville VALUES(52294,52130,52,'Louvemont',48.507565,4.950089);
INSERT INTO ville VALUES(52295,52800,52,'Louvières',48.036753,5.278372);
INSERT INTO ville VALUES(52296,52220,52,'Louze',48.460959,4.765177);
INSERT INTO ville VALUES(52297,52000,52,'Luzy-sur-Marne',48.105767,5.136554);
INSERT INTO ville VALUES(52374,52600,52,'Pailly',47.799361,5.457544);
INSERT INTO ville VALUES(52375,52600,52,'Palaiseul',47.799360,5.457543);
INSERT INTO ville VALUES(52376,52230,52,'Pancey',48.434295,5.327410);
INSERT INTO ville VALUES(52377,52400,52,'Parnoy-en-Bassigny',47.956308,5.732606);
INSERT INTO ville VALUES(52378,52300,52,'Paroy-sur-Saulx',48.428780,5.152999);
INSERT INTO ville VALUES(52379,52270,52,'Pautaines-Augeville',48.312355,5.254757);
INSERT INTO ville VALUES(53124,53200,53,'Laigné',47.819039,-0.711330);
INSERT INTO ville VALUES(53125,53190,53,'Landivy',48.470494,-0.946799);
INSERT INTO ville VALUES(53126,53220,53,'Larchamp',48.379565,-1.000948);
INSERT INTO ville VALUES(53127,53110,53,'Lassay-les-Châteaux',48.460033,-0.493187);
INSERT INTO ville VALUES(53128,53540,53,'Laubrières',47.956177,-1.088730);
INSERT INTO ville VALUES(53129,53410,53,'Launay-Villiers',48.130036,-0.960700);
INSERT INTO ville VALUES(53130,53000,53,'Laval',48.058151,-0.769183);
INSERT INTO ville VALUES(53131,53120,53,'Lesbois',48.409708,-0.830025);
INSERT INTO ville VALUES(53132,53120,53,'Levaré',48.409708,-0.830025);
INSERT INTO ville VALUES(53133,53140,53,'Lignières-Orgères',48.484944,-0.229355);
INSERT INTO ville VALUES(53134,53150,53,'Livet',48.154991,-0.528048);
INSERT INTO ville VALUES(53135,53400,53,'Livré',47.839761,-0.936518);
INSERT INTO ville VALUES(53136,53200,53,'Loigné-sur-Mayenne',47.819039,-0.711330);
INSERT INTO ville VALUES(53137,53320,53,'Loiron',48.031694,-0.955220);
INSERT INTO ville VALUES(53138,53200,53,'Longuefuye',47.819039,-0.711330);
INSERT INTO ville VALUES(53139,53700,53,'Loupfougères',48.323699,-0.265924);
INSERT INTO ville VALUES(53140,53950,53,'Louverné',48.125539,-0.681468);
INSERT INTO ville VALUES(53141,53210,53,'Louvigné',48.079691,-0.601401);
INSERT INTO ville VALUES(53173,53140,53,'Pallu',48.484944,-0.229355);
INSERT INTO ville VALUES(53174,53100,53,'Parigné-sur-Braye',48.304019,-0.694748);
INSERT INTO ville VALUES(53175,53260,53,'Parné-sur-Roc',47.996468,-0.685829);
INSERT INTO ville VALUES(53176,53300,53,'Pas',48.404161,-0.630204);
INSERT INTO ville VALUES(54286,54800,54,'Labry',49.159956,5.861988);
INSERT INTO ville VALUES(54287,54120,54,'Lachapelle',48.464919,6.766590);
INSERT INTO ville VALUES(54288,54200,54,'Lagney',48.706843,5.860997);
INSERT INTO ville VALUES(54289,54770,54,'Laître-sous-Amance',48.756524,6.288474);
INSERT INTO ville VALUES(54290,54720,54,'Laix',49.472545,5.755318);
INSERT INTO ville VALUES(54291,54115,54,'Laluf',999,999);
INSERT INTO ville VALUES(54292,54300,54,'Lamath',48.581263,6.546751);
INSERT INTO ville VALUES(54293,54360,54,'Landécourt',48.527388,6.392779);
INSERT INTO ville VALUES(54294,54380,54,'Landremont',48.820489,6.046179);
INSERT INTO ville VALUES(54295,54970,54,'Landres',49.318078,5.807268);
INSERT INTO ville VALUES(54296,54280,54,'Laneuvelotte',48.745349,6.351545);
INSERT INTO ville VALUES(54297,54370,54,'Laneuveville-aux-Bois',48.682854,6.577998);
INSERT INTO ville VALUES(54298,54570,54,'Laneuveville-derrière-Foug',48.692346,5.775870);
INSERT INTO ville VALUES(54299,54740,54,'Laneuveville-devant-Bayon',48.477098,6.210257);
INSERT INTO ville VALUES(54300,54410,54,'Laneuveville-devant-Nancy',48.650297,6.247119);
INSERT INTO ville VALUES(54301,54760,54,'Lanfroicourt',48.810912,6.264074);
INSERT INTO ville VALUES(54302,54150,54,'Lantéfontaine',49.268321,5.897266);
INSERT INTO ville VALUES(54303,54950,54,'Laronxe',48.543674,6.618767);
INSERT INTO ville VALUES(54304,54520,54,'Laxou',48.683939,6.118337);
INSERT INTO ville VALUES(54305,54690,54,'Lay-Saint-Christophe',48.748634,6.203715);
INSERT INTO ville VALUES(54306,54570,54,'Lay-Saint-Remy',48.692346,5.775870);
INSERT INTO ville VALUES(54307,54740,54,'Lebeuville',48.477098,6.210257);
INSERT INTO ville VALUES(54308,54450,54,'Leintrey',48.581595,6.788569);
INSERT INTO ville VALUES(54309,54740,54,'Lemainville',48.477098,6.210257);
INSERT INTO ville VALUES(54310,54740,54,'Leménil-Mitry',48.477098,6.210257);
INSERT INTO ville VALUES(54311,54110,54,'Lenoncourt',48.645221,6.355821);
INSERT INTO ville VALUES(54312,54700,54,'Lesménils',48.912390,6.058956);
INSERT INTO ville VALUES(54313,54610,54,'Létricourt',48.875765,6.237517);
INSERT INTO ville VALUES(54314,54720,54,'Lexy',49.472545,5.755318);
INSERT INTO ville VALUES(54315,54760,54,'Leyr',48.810912,6.264074);
INSERT INTO ville VALUES(54316,54470,54,'Limey-Remenauville',48.920752,5.868973);
INSERT INTO ville VALUES(54317,54470,54,'Lironville',48.920752,5.868973);
INSERT INTO ville VALUES(54318,54460,54,'Liverdun',48.748056,6.049560);
INSERT INTO ville VALUES(54320,54700,54,'Loisy',48.912390,6.058956);
INSERT INTO ville VALUES(54321,54810,54,'Longlaville',49.533795,5.800093);
INSERT INTO ville VALUES(54322,54260,54,'Longuyon',49.455749,5.550887);
INSERT INTO ville VALUES(54323,54400,54,'Longwy',49.526116,5.720472);
INSERT INTO ville VALUES(54324,54290,54,'Lorey',48.468479,6.341616);
INSERT INTO ville VALUES(54325,54290,54,'Loromontzey',48.468479,6.341616);
INSERT INTO ville VALUES(54326,54150,54,'Lubey',49.268321,5.897266);
INSERT INTO ville VALUES(54327,54200,54,'Lucey',48.706843,5.860997);
INSERT INTO ville VALUES(54328,54710,54,'Ludres',48.626432,6.183708);
INSERT INTO ville VALUES(54329,54300,54,'Lunéville',48.581263,6.546751);
INSERT INTO ville VALUES(54330,54210,54,'Lupcourt',48.587397,6.261602);
INSERT INTO ville VALUES(54414,54200,54,'Pagney-derrière-Barine',48.706843,5.860997);
INSERT INTO ville VALUES(54415,54530,54,'Pagny-sur-Moselle',48.996525,5.978861);
INSERT INTO ville VALUES(54416,54470,54,'Pannes',48.920752,5.868973);
INSERT INTO ville VALUES(54417,54330,54,'Parey-Saint-Césaire',48.485309,6.070106);
INSERT INTO ville VALUES(54418,54370,54,'Parroy',48.682854,6.577998);
INSERT INTO ville VALUES(54419,54480,54,'Parux',48.559137,6.992813);
INSERT INTO ville VALUES(55265,55160,55,'Labeuville',49.088873,5.661263);
INSERT INTO ville VALUES(55266,55120,55,'Lachalade',49.105683,5.129263);
INSERT INTO ville VALUES(55267,55210,55,'Lachaussée',48.988871,5.728008);
INSERT INTO ville VALUES(55268,55300,55,'Lacroix-sur-Meuse',48.919766,5.590165);
INSERT INTO ville VALUES(55269,55260,55,'Lahaymeix',48.879101,5.338911);
INSERT INTO ville VALUES(55270,55300,55,'Lahayville',48.919766,5.590165);
INSERT INTO ville VALUES(55271,55800,55,'Laheycourt',48.843616,5.006278);
INSERT INTO ville VALUES(55272,55800,55,'Laimont',48.843616,5.006278);
INSERT INTO ville VALUES(55274,55300,55,'Lamorville',48.919766,5.590165);
INSERT INTO ville VALUES(55275,55700,55,'Lamouilly',49.507908,5.181652);
INSERT INTO ville VALUES(55276,55100,55,'Landrecourt-Lempire',49.182264,5.330002);
INSERT INTO ville VALUES(55278,55190,55,'Laneuville-au-Rupt',48.656055,5.592139);
INSERT INTO ville VALUES(55279,55700,55,'Laneuville-sur-Meuse',49.507908,5.181652);
INSERT INTO ville VALUES(55280,55400,55,'Lanhères',49.204169,5.597000);
INSERT INTO ville VALUES(55281,55160,55,'Latour-en-Woëvre',49.088873,5.661263);
INSERT INTO ville VALUES(55282,55260,55,'Lavallée',48.879101,5.338911);
INSERT INTO ville VALUES(55284,55170,55,'Lavincourt',48.639479,5.090043);
INSERT INTO ville VALUES(55285,55120,55,'Lavoye',49.105683,5.129263);
INSERT INTO ville VALUES(55286,55220,55,'Lemmes',49.029573,5.320511);
INSERT INTO ville VALUES(55288,55200,55,'Lérouville',48.776314,5.611372);
INSERT INTO ville VALUES(55289,55260,55,'Levoncourt',48.879101,5.338911);
INSERT INTO ville VALUES(55290,55260,55,'Lignières-sur-Aire',48.879101,5.338911);
INSERT INTO ville VALUES(55291,55500,55,'Ligny-en-Barrois',48.693841,5.327716);
INSERT INTO ville VALUES(55292,55110,55,'Liny-devant-Dun',49.345155,5.190193);
INSERT INTO ville VALUES(55293,55110,55,'Lion-devant-Dun',49.345155,5.190193);
INSERT INTO ville VALUES(55295,55250,55,'Lisle-en-Barrois',48.974927,5.118387);
INSERT INTO ville VALUES(55296,55000,55,'Lisle-en-Rigault',48.788605,5.171247);
INSERT INTO ville VALUES(55297,55150,55,'Lissey',49.331346,5.425494);
INSERT INTO ville VALUES(55298,55000,55,'Loisey-Culey',48.788605,5.171247);
INSERT INTO ville VALUES(55299,55230,55,'Loison',49.335865,5.627108);
INSERT INTO ville VALUES(55300,55500,55,'Longeaux',48.693841,5.327716);
INSERT INTO ville VALUES(55301,55260,55,'Longchamps-sur-Aire',48.879101,5.338911);
INSERT INTO ville VALUES(55302,55000,55,'Longeville-en-Barrois',48.788605,5.171247);
INSERT INTO ville VALUES(55303,55300,55,'Loupmont',48.919766,5.590165);
INSERT INTO ville VALUES(55304,55800,55,'Louppy-le-Château',48.843616,5.006278);
INSERT INTO ville VALUES(55306,55600,55,'Louppy-sur-Loison',49.509708,5.374731);
INSERT INTO ville VALUES(55307,NULL,55,'Louvemont-Côte-du-Poivre',49.234837,5.400377);
INSERT INTO ville VALUES(55310,55700,55,'Luzy-Saint-Martin',49.507908,5.181652);
INSERT INTO ville VALUES(55397,55140,55,'Pagny-la-Blanche-Côte',48.559746,5.688784);
INSERT INTO ville VALUES(55398,55190,55,'Pagny-sur-Meuse',48.656055,5.592139);
INSERT INTO ville VALUES(55399,55160,55,'Pareid',49.088873,5.661263);
INSERT INTO ville VALUES(55400,55400,55,'Parfondrupt',49.204169,5.597000);
INSERT INTO ville VALUES(55401,55300,55,'Paroches',48.919767,5.590165);
INSERT INTO ville VALUES(56096,56690,56,'Landaul',47.761524,-3.127570);
INSERT INTO ville VALUES(56097,56690,56,'Landévant',47.761524,-3.127570);
INSERT INTO ville VALUES(56098,56600,56,'Lanester',47.766037,-3.326824);
INSERT INTO ville VALUES(56099,56160,56,'Langoëlan',48.068850,-3.218206);
INSERT INTO ville VALUES(56100,56630,56,'Langonnet',48.129103,-3.482463);
INSERT INTO ville VALUES(56101,56440,56,'Languidic',47.829457,-3.148330);
INSERT INTO ville VALUES(56102,56120,56,'Lanouée',47.969502,-2.605356);
INSERT INTO ville VALUES(56103,56120,56,'Lantillac',47.969502,-2.605356);
INSERT INTO ville VALUES(56104,56240,56,'Lanvaudan',47.941708,-3.304347);
INSERT INTO ville VALUES(56105,56320,56,'Lanvénégen',48.025219,-3.485728);
INSERT INTO ville VALUES(56106,56870,56,'Larmor-Baden',47.604793,-2.903242);
INSERT INTO ville VALUES(56107,56260,56,'Larmor-Plage',47.716352,-3.387714);
INSERT INTO ville VALUES(56108,56230,56,'Larré',47.692524,-2.473603);
INSERT INTO ville VALUES(56109,56190,56,'Lauzach',47.566425,-2.482436);
INSERT INTO ville VALUES(56110,56160,56,'Lignol',48.068850,-3.218206);
INSERT INTO ville VALUES(56111,56220,56,'Limerzel',47.672711,-2.282756);
INSERT INTO ville VALUES(56112,56460,56,'Lizio',47.826477,-2.469010);
INSERT INTO ville VALUES(56113,56160,56,'Locmalo',48.068850,-3.218206);
INSERT INTO ville VALUES(56114,56360,56,'Locmaria',47.332820,-3.160272);
INSERT INTO ville VALUES(56115,56390,56,'Locmaria-Grand-Champ',47.774750,-2.843839);
INSERT INTO ville VALUES(56116,56740,56,'Locmariaquer',47.580368,-2.959192);
INSERT INTO ville VALUES(56117,56500,56,'Locminé',47.925069,-2.818360);
INSERT INTO ville VALUES(56118,56570,56,'Locmiquélic',47.730692,-3.328577);
INSERT INTO ville VALUES(56119,56550,56,'Locoal-Mendon',47.692987,-3.125841);
INSERT INTO ville VALUES(56120,56390,56,'Locqueltas',47.774750,-2.843839);
INSERT INTO ville VALUES(56121,56100,56,'Lorient',47.745551,-3.378910);
INSERT INTO ville VALUES(56122,56800,56,'Loyat',47.948382,-2.373829);
INSERT INTO ville VALUES(56152,56360,56,'Palais',47.348317,-3.159129);
INSERT INTO ville VALUES(57373,57730,57,'Lachambre',49.084335,6.735894);
INSERT INTO ville VALUES(57374,57560,57,'Lafrimbolle',48.595868,7.106739);
INSERT INTO ville VALUES(57375,57810,57,'Lagarde',48.729629,6.776884);
INSERT INTO ville VALUES(57376,57410,57,'Lambach',49.036994,7.288612);
INSERT INTO ville VALUES(57377,57830,57,'Landange',48.686548,6.928325);
INSERT INTO ville VALUES(57379,57340,57,'Landroff',48.929347,6.640125);
INSERT INTO ville VALUES(57380,57790,57,'Laneuveville-lès-Lorquin',48.650158,7.003630);
INSERT INTO ville VALUES(57381,57590,57,'Laneuveville-en-Saulnois',48.886169,6.406055);
INSERT INTO ville VALUES(57382,57400,57,'Langatte',48.732237,7.024743);
INSERT INTO ville VALUES(57383,57810,57,'Languimberg',48.729629,6.776884);
INSERT INTO ville VALUES(57384,57660,57,'Laning',49.011750,6.777981);
INSERT INTO ville VALUES(57385,57530,57,'Laquenexy',49.115751,6.369602);
INSERT INTO ville VALUES(57386,57114,57,'Laudrefang',49.082217,6.638224);
INSERT INTO ville VALUES(57387,57480,57,'Laumesfeld',49.415959,6.422053);
INSERT INTO ville VALUES(57388,57480,57,'Launstroff',49.415959,6.422053);
INSERT INTO ville VALUES(57389,57660,57,'Lelling',49.011750,6.777981);
INSERT INTO ville VALUES(57390,57620,57,'Lemberg',48.988989,7.414300);
INSERT INTO ville VALUES(57391,57590,57,'Lemoncourt',48.886169,6.406055);
INSERT INTO ville VALUES(57392,57580,57,'Lemud',48.989493,6.412532);
INSERT INTO ville VALUES(57393,57720,57,'Lengelsheim',49.125356,7.352381);
INSERT INTO ville VALUES(57394,57670,57,'Léning',48.907538,6.860882);
INSERT INTO ville VALUES(57395,57580,57,'Lesse',48.989493,6.412532);
INSERT INTO ville VALUES(57396,57160,57,'Lessy',49.113532,6.082001);
INSERT INTO ville VALUES(57397,57810,57,'Ley',48.729629,6.776884);
INSERT INTO ville VALUES(57398,57660,57,'Leyviller',49.011750,6.777981);
INSERT INTO ville VALUES(57399,57630,57,'Lezey',48.772195,6.591984);
INSERT INTO ville VALUES(57401,57340,57,'Lidrezing',48.929347,6.640125);
INSERT INTO ville VALUES(57402,57230,57,'Liederschiedt',49.034431,7.506696);
INSERT INTO ville VALUES(57403,57420,57,'Liéhon',48.986026,6.211914);
INSERT INTO ville VALUES(57404,57260,57,'Lindre-Basse',48.819243,6.740493);
INSERT INTO ville VALUES(57405,57260,57,'Lindre-Haute',48.819243,6.740493);
INSERT INTO ville VALUES(57406,57590,57,'Liocourt',48.886169,6.406055);
INSERT INTO ville VALUES(57407,57119,57,'Lixheim',48.774918,7.142222);
INSERT INTO ville VALUES(57408,57520,57,'Lixing-lès-Rouhling',49.156552,7.010905);
INSERT INTO ville VALUES(57409,57660,57,'Lixing-lès-Saint-Avold',49.011750,6.777981);
INSERT INTO ville VALUES(57410,57670,57,'Lhor',48.907538,6.860882);
INSERT INTO ville VALUES(57411,57650,57,'Lommerange',49.356314,5.988252);
INSERT INTO ville VALUES(57412,57050,57,'Longeville-lès-Metz',49.134019,6.130242);
INSERT INTO ville VALUES(57413,57740,57,'Longeville-lès-Saint-Avold',49.119071,6.650947);
INSERT INTO ville VALUES(57414,57790,57,'Lorquin',48.650158,7.003630);
INSERT INTO ville VALUES(57415,57050,57,'Lorry-lès-Metz',49.134019,6.130242);
INSERT INTO ville VALUES(57416,57420,57,'Lorry-Mardigny',48.986026,6.211914);
INSERT INTO ville VALUES(57417,57670,57,'Lostroff',48.907538,6.860882);
INSERT INTO ville VALUES(57418,57670,57,'Loudrefing',48.907538,6.860882);
INSERT INTO ville VALUES(57419,57510,57,'Loupershouse',49.043667,6.918884);
INSERT INTO ville VALUES(57421,57720,57,'Loutzviller',49.125356,7.352381);
INSERT INTO ville VALUES(57422,57420,57,'Louvigny',48.986026,6.211914);
INSERT INTO ville VALUES(57423,57170,57,'Lubécourt',48.822566,6.525379);
INSERT INTO ville VALUES(57424,57590,57,'Lucy',48.886169,6.406055);
INSERT INTO ville VALUES(57425,57580,57,'Luppy',48.989493,6.412532);
INSERT INTO ville VALUES(57426,57144,57,'Luttange',49.269825,6.310031);
INSERT INTO ville VALUES(57427,57820,57,'Lutzelbourg',48.722751,7.229101);
INSERT INTO ville VALUES(57532,57420,57,'Pagny-lès-Goin',48.986026,6.211914);
INSERT INTO ville VALUES(57533,57530,57,'Pange',49.115751,6.369602);
INSERT INTO ville VALUES(58137,58300,58,'Lamenay-sur-Loire',46.807060,3.463898);
INSERT INTO ville VALUES(58138,58240,58,'Langeron',46.794562,3.192004);
INSERT INTO ville VALUES(58139,58250,58,'Lanty',46.806689,3.767930);
INSERT INTO ville VALUES(58140,58370,58,'Larochemillay',46.919371,3.958619);
INSERT INTO ville VALUES(58141,58230,58,'Lavault-de-Frétoy',47.218543,4.057098);
INSERT INTO ville VALUES(58142,58290,58,'Limanton',46.969947,3.777941);
INSERT INTO ville VALUES(58143,58270,58,'Limon',47.001454,3.471722);
INSERT INTO ville VALUES(58144,58240,58,'Livry',46.794562,3.192004);
INSERT INTO ville VALUES(58145,58140,58,'Lormes',47.299343,3.876013);
INSERT INTO ville VALUES(58146,58380,58,'Lucenay-lès-Aix',46.693840,3.494709);
INSERT INTO ville VALUES(58147,58700,58,'Lurcy-le-Bourg',47.187121,3.311620);
INSERT INTO ville VALUES(58148,58240,58,'Luthenay-Uxeloup',46.794562,3.192004);
INSERT INTO ville VALUES(58149,58170,58,'Luzy',46.815107,3.931812);
INSERT INTO ville VALUES(58150,58190,58,'Lys',47.362557,3.677292);
INSERT INTO ville VALUES(58206,58210,58,'Parigny-la-Rose',47.345318,3.398678);
INSERT INTO ville VALUES(58207,58320,58,'Parigny-les-Vaux',47.089166,3.104655);
INSERT INTO ville VALUES(58208,58800,58,'Pazy',47.232960,3.701913);
INSERT INTO ville VALUES(59061,59550,59,'Beaurepaire-sur-Sambre',50.106840,3.725275);
INSERT INTO ville VALUES(59327,59167,59,'Lallaing',50.386893,3.172302);
INSERT INTO ville VALUES(59328,59130,59,'Lambersart',50.653767,3.024821);
INSERT INTO ville VALUES(59329,59552,59,'Lambres-lez-Douai',50.352564,3.054480);
INSERT INTO ville VALUES(59330,59310,59,'Landas',50.477698,3.231079);
INSERT INTO ville VALUES(59331,59550,59,'Landrecies',50.106840,3.725275);
INSERT INTO ville VALUES(59332,59390,59,'Lannoy',50.659532,3.224982);
INSERT INTO ville VALUES(59333,59219,59,'Larouillies',50.049376,3.912962);
INSERT INTO ville VALUES(59334,59553,59,'Lauwin-Planque',50.380851,3.020110);
INSERT INTO ville VALUES(59335,59226,59,'Lecelles',50.481459,3.383765);
INSERT INTO ville VALUES(59336,59259,59,'Lécluse',50.275707,3.033295);
INSERT INTO ville VALUES(59337,59143,59,'Lederzeele',50.828884,2.254772);
INSERT INTO ville VALUES(59338,59470,59,'Ledringhem',50.868745,2.425767);
INSERT INTO ville VALUES(59339,59115,59,'Leers',50.679377,3.239910);
INSERT INTO ville VALUES(59340,59495,59,'Leffrinckoucke',51.045849,2.452196);
INSERT INTO ville VALUES(59341,59258,59,'Lesdain',50.079678,3.247008);
INSERT INTO ville VALUES(59342,59740,59,'Lez-Fontaine',50.153012,4.074085);
INSERT INTO ville VALUES(59343,59810,59,'Lesquin',50.589506,3.113241);
INSERT INTO ville VALUES(59344,59620,59,'Leval',50.190910,3.859274);
INSERT INTO ville VALUES(59345,59287,59,'Lewarde',50.343240,3.159652);
INSERT INTO ville VALUES(59346,59260,59,'Lezennes',50.610033,3.117338);
INSERT INTO ville VALUES(59347,59740,59,'Liessies',50.153012,4.074085);
INSERT INTO ville VALUES(59348,59111,59,'Lieu-Saint-Amand',50.277230,3.319543);
INSERT INTO ville VALUES(59349,59191,59,'Ligny-en-Cambrésis',50.095329,3.365101);
INSERT INTO ville VALUES(59350,59000,59,'Lille',50.619816,3.054048);
INSERT INTO ville VALUES(59351,59330,59,'Limont-Fontaine',50.229565,3.927263);
INSERT INTO ville VALUES(59352,59126,59,'Linselles',50.736727,3.072249);
INSERT INTO ville VALUES(59353,59530,59,'Locquignol',50.223692,3.694086);
INSERT INTO ville VALUES(59354,59182,59,'Loffre',50.363676,3.183271);
INSERT INTO ville VALUES(59356,59840,59,'Lompret',50.665610,2.968151);
INSERT INTO ville VALUES(59357,59570,59,'Longueville',50.305088,3.818744);
INSERT INTO ville VALUES(59358,59630,59,'Looberghe',50.915815,2.239697);
INSERT INTO ville VALUES(59359,59279,59,'Loon-Plage',50.999910,2.220037);
INSERT INTO ville VALUES(59360,59120,59,'Loos',50.607760,3.021665);
INSERT INTO ville VALUES(59361,59156,59,'Lourches',50.310338,3.358243);
INSERT INTO ville VALUES(59363,59530,59,'Louvignies-Quesnoy',50.223692,3.694086);
INSERT INTO ville VALUES(59364,59830,59,'Louvil',50.561070,3.230859);
INSERT INTO ville VALUES(59365,59720,59,'Louvroil',50.259683,3.951242);
INSERT INTO ville VALUES(59366,59173,59,'Lynde',50.717970,2.405039);
INSERT INTO ville VALUES(59367,59390,59,'Lys-lez-Lannoy',50.659532,3.224982);
INSERT INTO ville VALUES(59455,59295,59,'Paillencourt',50.248889,3.272912);
INSERT INTO ville VALUES(60056,60700,60,'Beaurepaire',49.315466,2.601329);
INSERT INTO ville VALUES(60329,60310,60,'Laberlière',49.622225,2.847600);
INSERT INTO ville VALUES(60330,60570,60,'Laboissière-en-Thelle',49.273742,2.164712);
INSERT INTO ville VALUES(60331,60590,60,'Labosse',49.337312,1.826863);
INSERT INTO ville VALUES(60332,60140,60,'Labruyère',49.332075,2.486718);
INSERT INTO ville VALUES(60333,60650,60,'Lachapelle-aux-Pots',49.456531,1.905030);
INSERT INTO ville VALUES(60334,60730,60,'Lachapelle-Saint-Pierre',49.287660,2.239448);
INSERT INTO ville VALUES(60335,60380,60,'Lachapelle-sous-Gerberoy',49.557692,1.814632);
INSERT INTO ville VALUES(60336,60480,60,'Lachaussée-du-Bois-d''Écu',49.559492,2.173208);
INSERT INTO ville VALUES(60337,60190,60,'Lachelle',49.439504,2.644994);
INSERT INTO ville VALUES(60338,60610,60,'Lacroix-Saint-Ouen',49.357209,2.796036);
INSERT INTO ville VALUES(60339,60510,60,'Lafraye',49.438396,2.253058);
INSERT INTO ville VALUES(60340,60310,60,'Lagny',49.622225,2.847600);
INSERT INTO ville VALUES(60341,60330,60,'Lagny-le-Sec',49.092874,2.747075);
INSERT INTO ville VALUES(60342,60290,60,'Laigneville',49.325063,2.429547);
INSERT INTO ville VALUES(60343,60590,60,'Lalande-en-Son',49.337312,1.826863);
INSERT INTO ville VALUES(60344,60850,60,'Lalandelle',49.416166,1.807015);
INSERT INTO ville VALUES(60345,60600,60,'Lamécourt',49.395193,2.440419);
INSERT INTO ville VALUES(60346,60260,60,'Lamorlaye',49.160431,2.425791);
INSERT INTO ville VALUES(60347,60220,60,'Lannoy-Cuillère',49.673266,1.777672);
INSERT INTO ville VALUES(60348,60400,60,'Larbroye',49.554236,3.026367);
INSERT INTO ville VALUES(60350,60310,60,'Lassigny',49.622225,2.847600);
INSERT INTO ville VALUES(60351,60490,60,'Lataule',49.559204,2.740293);
INSERT INTO ville VALUES(60352,60240,60,'Lattainville',49.255112,1.875205);
INSERT INTO ville VALUES(60353,60120,60,'Lavacquerie',49.625737,2.275930);
INSERT INTO ville VALUES(60354,60210,60,'Laverrière',49.659072,1.937454);
INSERT INTO ville VALUES(60355,60510,60,'Laversines',49.438396,2.253058);
INSERT INTO ville VALUES(60356,60240,60,'Lavilletertre',49.255112,1.875205);
INSERT INTO ville VALUES(60357,60420,60,'Léglantiers',49.560449,2.544154);
INSERT INTO ville VALUES(60358,60800,60,'Lévignen',49.230394,2.837291);
INSERT INTO ville VALUES(60359,60650,60,'Lhéraule',49.456531,1.905030);
INSERT INTO ville VALUES(60360,60140,60,'Liancourt',49.332075,2.486718);
INSERT INTO ville VALUES(60361,60240,60,'Liancourt-Saint-Pierre',49.255112,1.875205);
INSERT INTO ville VALUES(60362,60640,60,'Libermont',49.667135,3.020607);
INSERT INTO ville VALUES(60363,60240,60,'Lierville',49.255112,1.875205);
INSERT INTO ville VALUES(60364,60130,60,'Lieuvillers',49.499190,2.415401);
INSERT INTO ville VALUES(60365,60360,60,'Lihus',49.609400,2.077146);
INSERT INTO ville VALUES(60366,60510,60,'Litz',49.438396,2.253058);
INSERT INTO ville VALUES(60367,60240,60,'Loconville',49.255112,1.875205);
INSERT INTO ville VALUES(60368,60150,60,'Longueil-Annel',49.489430,2.854216);
INSERT INTO ville VALUES(60369,60126,60,'Longueil-Sainte-Marie',49.345245,2.715148);
INSERT INTO ville VALUES(60370,60110,60,'Lormaison',49.233048,2.138824);
INSERT INTO ville VALUES(60371,60380,60,'Loueuse',49.557692,1.814632);
INSERT INTO ville VALUES(60372,60360,60,'Luchy',49.609400,2.077146);
INSERT INTO ville VALUES(60486,60120,60,'Paillart',49.625737,2.275930);
INSERT INTO ville VALUES(60487,60240,60,'Parnes',49.255112,1.875205);
INSERT INTO ville VALUES(60488,60400,60,'Passel',49.554236,3.026367);
INSERT INTO ville VALUES(61213,61320,61,'Lalacelle',48.547075,-0.145517);
INSERT INTO ville VALUES(61215,61170,61,'Laleu',48.546763,0.340938);
INSERT INTO ville VALUES(61216,61320,61,'Lande-de-Goult',48.547076,-0.145517);
INSERT INTO ville VALUES(61217,61210,61,'Lande-de-Lougé',48.762285,-0.269401);
INSERT INTO ville VALUES(61218,61100,61,'Lande-Patry',48.765239,-0.533147);
INSERT INTO ville VALUES(61219,61100,61,'Lande-Saint-Siméon',48.765239,-0.533147);
INSERT INTO ville VALUES(61220,61290,61,'Lande-sur-Eure',48.543604,0.817213);
INSERT INTO ville VALUES(61221,61100,61,'Landigou',48.765239,-0.533147);
INSERT INTO ville VALUES(61222,61100,61,'Landisacq',48.765239,-0.533147);
INSERT INTO ville VALUES(61223,61800,61,'Larchamp',48.754961,-0.738378);
INSERT INTO ville VALUES(61224,61250,61,'Larré',48.458235,0.099933);
INSERT INTO ville VALUES(61225,61240,61,'Lignères',48.710181,0.261580);
INSERT INTO ville VALUES(61226,61190,61,'Lignerolles',48.628031,0.684332);
INSERT INTO ville VALUES(61227,61220,61,'Lignou',48.688413,-0.389138);
INSERT INTO ville VALUES(61228,61420,61,'Livaie',48.473768,-0.031554);
INSERT INTO ville VALUES(61229,61400,61,'Loisail',48.487183,0.591752);
INSERT INTO ville VALUES(61230,61290,61,'Longny-au-Perche',48.543603,0.817213);
INSERT INTO ville VALUES(61231,61320,61,'Longuenoë',48.547075,-0.145517);
INSERT INTO ville VALUES(61232,61700,61,'Lonlay-l''Abbaye',48.606858,-0.607088);
INSERT INTO ville VALUES(61233,61600,61,'Lonlay-le-Tesson',48.599039,-0.365334);
INSERT INTO ville VALUES(61234,61250,61,'Lonrai',48.458235,0.099933);
INSERT INTO ville VALUES(61235,61330,61,'Loré',48.508098,-0.605715);
INSERT INTO ville VALUES(61236,61150,61,'Loucé',48.695144,-0.165350);
INSERT INTO ville VALUES(61237,61150,61,'Lougé-sur-Maire',48.695144,-0.165350);
INSERT INTO ville VALUES(61238,61160,61,'Louvières-en-Auge',48.847155,0.013800);
INSERT INTO ville VALUES(61239,61330,61,'Lucé',48.508098,-0.605715);
INSERT INTO ville VALUES(61321,61250,61,'Pacé',48.458235,0.099933);
INSERT INTO ville VALUES(61322,61400,61,'Parfondeval',48.487183,0.591752);
INSERT INTO ville VALUES(61323,61290,61,'Pas-Saint-l''Homer',48.543604,0.817213);
INSERT INTO ville VALUES(61324,61350,61,'Passais',48.515417,-0.764022);
INSERT INTO ville VALUES(62479,62122,62,'Labeuvrière',50.520073,2.550515);
INSERT INTO ville VALUES(62480,62113,62,'Labourse',50.497152,2.695078);
INSERT INTO ville VALUES(62481,62140,62,'Labroye',50.377804,1.992683);
INSERT INTO ville VALUES(62483,62830,62,'Lacres',50.633709,1.772560);
INSERT INTO ville VALUES(62484,62159,62,'Lagnicourt-Marcel',50.147252,2.912913);
INSERT INTO ville VALUES(62485,62960,62,'Laires',50.552214,2.276835);
INSERT INTO ville VALUES(62486,62120,62,'Lambres',50.641507,2.374227);
INSERT INTO ville VALUES(62487,62250,62,'Landrethun-le-Nord',50.823379,1.716794);
INSERT INTO ville VALUES(62488,62610,62,'Landrethun-lès-Ardres',50.852021,1.974574);
INSERT INTO ville VALUES(62489,62122,62,'Lapugnoy',50.520073,2.550515);
INSERT INTO ville VALUES(62490,62810,62,'Lattre-Saint-Quentin',50.261960,2.468221);
INSERT INTO ville VALUES(62491,62840,62,'Laventie',50.609232,2.809216);
INSERT INTO ville VALUES(62492,62990,62,'Lebiez',50.457079,1.928724);
INSERT INTO ville VALUES(62493,62124,62,'Lebucquière',50.097363,3.005650);
INSERT INTO ville VALUES(62494,62124,62,'Léchelle',50.097363,3.005650);
INSERT INTO ville VALUES(62495,62380,62,'Ledinghem',50.682993,2.071328);
INSERT INTO ville VALUES(62496,62630,62,'Lefaux',50.548598,1.689540);
INSERT INTO ville VALUES(62497,62790,62,'Leforest',50.441988,3.061496);
INSERT INTO ville VALUES(62498,62300,62,'Lens',50.436276,2.817670);
INSERT INTO ville VALUES(62499,62170,62,'Lépine',50.468064,1.764853);
INSERT INTO ville VALUES(62500,62190,62,'Lespesses',50.561930,2.440462);
INSERT INTO ville VALUES(62501,62990,62,'Lespinoy',50.457079,1.928724);
INSERT INTO ville VALUES(62502,62136,62,'Lestrem',50.593658,2.707732);
INSERT INTO ville VALUES(62503,62250,62,'Leubringhen',50.823379,1.716794);
INSERT INTO ville VALUES(62504,62500,62,'Leulinghem',50.757335,2.242761);
INSERT INTO ville VALUES(62505,62250,62,'Leulinghen-Bernes',50.823379,1.716794);
INSERT INTO ville VALUES(62506,62850,62,'Licques',50.767328,1.939382);
INSERT INTO ville VALUES(62507,62810,62,'Liencourt',50.261960,2.468221);
INSERT INTO ville VALUES(62508,62190,62,'Lières',50.561930,2.440462);
INSERT INTO ville VALUES(62509,62145,62,'Liettres',50.594966,2.296442);
INSERT INTO ville VALUES(62510,62800,62,'Liévin',50.422972,2.769747);
INSERT INTO ville VALUES(62511,62810,62,'Lignereuil',50.261960,2.468221);
INSERT INTO ville VALUES(62512,62960,62,'Ligny-lès-Aire',50.552214,2.276835);
INSERT INTO ville VALUES(62513,62270,62,'Ligny-sur-Canche',50.282803,2.300771);
INSERT INTO ville VALUES(62514,62127,62,'Ligny-Saint-Flochel',50.358238,2.463968);
INSERT INTO ville VALUES(62515,62450,62,'Ligny-Thilloy',50.084051,2.841571);
INSERT INTO ville VALUES(62516,62190,62,'Lillers',50.561930,2.440462);
INSERT INTO ville VALUES(62517,62120,62,'Linghem',50.641507,2.374227);
INSERT INTO ville VALUES(62518,62270,62,'Linzeux',50.282803,2.300771);
INSERT INTO ville VALUES(62519,62134,62,'Lisbourg',50.474614,2.253158);
INSERT INTO ville VALUES(62520,62400,62,'Locon',50.539226,2.656844);
INSERT INTO ville VALUES(62521,62140,62,'Loge',50.377804,1.992684);
INSERT INTO ville VALUES(62522,62990,62,'Loison-sur-Créquoise',50.457079,1.928724);
INSERT INTO ville VALUES(62523,62218,62,'Loison-sous-Lens',50.445472,2.862567);
INSERT INTO ville VALUES(62524,62240,62,'Longfossé',50.677686,1.860885);
INSERT INTO ville VALUES(62525,62219,62,'Longuenesse',50.732713,2.228636);
INSERT INTO ville VALUES(62526,62142,62,'Longueville',50.736209,1.817285);
INSERT INTO ville VALUES(62527,62630,62,'Longvilliers',50.548598,1.689540);
INSERT INTO ville VALUES(62528,62750,62,'Loos-en-Gohelle',50.457600,2.786284);
INSERT INTO ville VALUES(62529,62840,62,'Lorgies',50.609232,2.809216);
INSERT INTO ville VALUES(62530,62240,62,'Lottinghen',50.677686,1.860885);
INSERT INTO ville VALUES(62531,62610,62,'Louches',50.852021,1.974574);
INSERT INTO ville VALUES(62532,62540,62,'Lozinghem',50.507574,2.505006);
INSERT INTO ville VALUES(62533,62310,62,'Lugy',50.501326,2.106961);
INSERT INTO ville VALUES(62534,62380,62,'Lumbres',50.682993,2.071328);
INSERT INTO ville VALUES(62646,62860,62,'Palluel',50.212580,3.072621);
INSERT INTO ville VALUES(62647,62770,62,'Parcq',50.378828,2.099121);
INSERT INTO ville VALUES(62648,62650,62,'Parenty',50.565107,1.897089);
INSERT INTO ville VALUES(62649,62760,62,'Pas-en-Artois',50.141579,2.480796);
INSERT INTO ville VALUES(62907,62820,62,'Libercourt',50.483688,3.003323);
INSERT INTO ville VALUES(63034,63116,63,'Beauregard-l''Évêque',45.816619,3.297056);
INSERT INTO ville VALUES(63035,63460,63,'Beauregard-Vendon',45.994845,3.104686);
INSERT INTO ville VALUES(63183,63690,63,'Labessette',45.549585,2.596557);
INSERT INTO ville VALUES(63184,63290,63,'Lachaux',45.958578,3.521326);
INSERT INTO ville VALUES(63185,63570,63,'Lamontgie',45.453021,3.344092);
INSERT INTO ville VALUES(63186,63380,63,'Landogne',45.875929,2.632111);
INSERT INTO ville VALUES(63187,63700,63,'Lapeyrouse',46.184674,2.824712);
INSERT INTO ville VALUES(63188,63270,63,'Laps',45.642960,3.303268);
INSERT INTO ville VALUES(63189,63820,63,'Laqueuille',45.674053,2.686892);
INSERT INTO ville VALUES(63190,63690,63,'Larodde',45.549585,2.596557);
INSERT INTO ville VALUES(63191,63760,63,'Lastic',45.673869,2.581572);
INSERT INTO ville VALUES(63193,63370,63,'Lempdes',45.771736,3.191957);
INSERT INTO ville VALUES(63194,63190,63,'Lempty',45.823861,3.395436);
INSERT INTO ville VALUES(63195,63190,63,'Lezoux',45.823861,3.395436);
INSERT INTO ville VALUES(63196,63290,63,'Limons',45.958578,3.521326);
INSERT INTO ville VALUES(63197,63440,63,'Lisseuil',46.068421,3.015292);
INSERT INTO ville VALUES(63198,63410,63,'Loubeyrat',45.941945,2.959715);
INSERT INTO ville VALUES(63199,63320,63,'Ludesse',45.549588,3.081386);
INSERT INTO ville VALUES(63200,63360,63,'Lussat',45.842686,3.191073);
INSERT INTO ville VALUES(63201,63350,63,'Luzillat',45.908003,3.360867);
INSERT INTO ville VALUES(63267,63550,63,'Palladuc',45.919644,3.609052);
INSERT INTO ville VALUES(63268,63500,63,'Pardines',45.554291,3.220327);
INSERT INTO ville VALUES(63269,63270,63,'Parent',45.642960,3.303268);
INSERT INTO ville VALUES(63270,63500,63,'Parentignat',45.554291,3.220327);
INSERT INTO ville VALUES(63271,63290,63,'Paslières',45.958578,3.521326);
INSERT INTO ville VALUES(64286,64300,64,'Laà-Mondrans',43.485620,-0.756286);
INSERT INTO ville VALUES(64287,64390,64,'Laàs',43.396524,-0.921267);
INSERT INTO ville VALUES(64288,64170,64,'Labastide-Cézéracq',43.402234,-0.552818);
INSERT INTO ville VALUES(64290,64170,64,'Labastide-Monréjeau',43.402234,-0.552818);
INSERT INTO ville VALUES(64291,64270,64,'Labastide-Villefranche',43.478733,-0.964281);
INSERT INTO ville VALUES(64292,64530,64,'Labatmale',43.228162,-0.091211);
INSERT INTO ville VALUES(64293,64460,64,'Labatut',43.360964,-0.069723);
INSERT INTO ville VALUES(64294,64120,64,'Labets-Biscay',43.283838,-1.055662);
INSERT INTO ville VALUES(64295,64300,64,'Labeyrie',43.485620,-0.756286);
INSERT INTO ville VALUES(64296,64300,64,'Lacadée',43.485620,-0.756286);
INSERT INTO ville VALUES(64297,64220,64,'Lacarre',43.120474,-1.183279);
INSERT INTO ville VALUES(64298,64470,64,'Lacarry-Arhan-Charritte-de-Haut',43.101792,-0.915488);
INSERT INTO ville VALUES(64299,64360,64,'Lacommande',43.301599,-0.594510);
INSERT INTO ville VALUES(64300,64170,64,'Lacq',43.402234,-0.552818);
INSERT INTO ville VALUES(64301,64150,64,'Lagor',43.371156,-0.649110);
INSERT INTO ville VALUES(64302,64800,64,'Lagos',43.135457,-0.239691);
INSERT INTO ville VALUES(64303,64470,64,'Laguinge-Restoue',43.101792,-0.915488);
INSERT INTO ville VALUES(64304,64990,64,'Lahonce',43.460984,-1.401011);
INSERT INTO ville VALUES(64305,64270,64,'Lahontan',43.478733,-0.964281);
INSERT INTO ville VALUES(64306,64150,64,'Lahourcade',43.371156,-0.649110);
INSERT INTO ville VALUES(64307,64350,64,'Lalongue',43.467148,-0.130820);
INSERT INTO ville VALUES(64308,64450,64,'Lalonquette',43.462611,-0.342817);
INSERT INTO ville VALUES(64309,64460,64,'Lamayou',43.360964,-0.069723);
INSERT INTO ville VALUES(64310,64570,64,'Lanne-en-Barétous',43.069407,-0.724329);
INSERT INTO ville VALUES(64311,64350,64,'Lannecaube',43.467148,-0.130820);
INSERT INTO ville VALUES(64312,64300,64,'Lanneplaà',43.485620,-0.756286);
INSERT INTO ville VALUES(64313,64640,64,'Lantabat',43.298787,-1.185425);
INSERT INTO ville VALUES(64314,64120,64,'Larceveau-Arros-Cibits',43.283838,-1.055662);
INSERT INTO ville VALUES(64315,64110,64,'Laroin',43.270225,-0.393828);
INSERT INTO ville VALUES(64316,64560,64,'Larrau',43.018474,-0.919032);
INSERT INTO ville VALUES(64317,64480,64,'Larressore',43.394000,-1.447529);
INSERT INTO ville VALUES(64318,64410,64,'Larreule',43.525862,-0.446267);
INSERT INTO ville VALUES(64319,64120,64,'Larribar-Sorhapuru',43.283838,-1.055662);
INSERT INTO ville VALUES(64320,64440,64,'Laruns',42.916655,-0.382700);
INSERT INTO ville VALUES(64321,64450,64,'Lasclaveries',43.462611,-0.342817);
INSERT INTO ville VALUES(64322,64220,64,'Lasse',43.120474,-1.183279);
INSERT INTO ville VALUES(64323,64350,64,'Lasserre',43.467148,-0.130820);
INSERT INTO ville VALUES(64324,64290,64,'Lasseube',43.230078,-0.445720);
INSERT INTO ville VALUES(64325,64290,64,'Lasseubetat',43.230078,-0.445720);
INSERT INTO ville VALUES(64326,64190,64,'Lay-Lamidou',43.321641,-0.794932);
INSERT INTO ville VALUES(64327,64220,64,'Lecumberry',43.120474,-1.183279);
INSERT INTO ville VALUES(64328,64400,64,'Ledeuix',43.182520,-0.638350);
INSERT INTO ville VALUES(64329,64320,64,'Lée',43.293831,-0.302218);
INSERT INTO ville VALUES(64330,64490,64,'Lées-Athas',42.937867,-0.606770);
INSERT INTO ville VALUES(64331,64350,64,'Lembeye',43.467148,-0.130820);
INSERT INTO ville VALUES(64332,64450,64,'Lème',43.462611,-0.342817);
INSERT INTO ville VALUES(64334,64270,64,'Léren',43.478733,-0.964281);
INSERT INTO ville VALUES(64335,64230,64,'Lescar',43.379072,-0.443292);
INSERT INTO ville VALUES(64336,64490,64,'Lescun',42.937867,-0.606770);
INSERT INTO ville VALUES(64337,64350,64,'Lespielle',43.467148,-0.130820);
INSERT INTO ville VALUES(64338,64160,64,'Lespourcy',43.396692,-0.224099);
INSERT INTO ville VALUES(64339,64800,64,'Lestelle-Bétharram',43.135457,-0.239691);
INSERT INTO ville VALUES(64340,64470,64,'Lichans-Sunhar',43.101792,-0.915488);
INSERT INTO ville VALUES(64341,64130,64,'Lichos',43.205936,-0.895348);
INSERT INTO ville VALUES(64342,64560,64,'Licq-Athérey',43.018474,-0.919032);
INSERT INTO ville VALUES(64343,64420,64,'Limendous',43.264352,-0.171719);
INSERT INTO ville VALUES(64344,64530,64,'Livron',43.226298,-0.140250);
INSERT INTO ville VALUES(64345,64120,64,'Lohitzun-Oyhercq',43.283838,-1.055662);
INSERT INTO ville VALUES(64346,64160,64,'Lombia',43.396692,-0.224099);
INSERT INTO ville VALUES(64347,64410,64,'Lonçon',43.525862,-0.446267);
INSERT INTO ville VALUES(64348,64140,64,'Lons',43.323450,-0.405709);
INSERT INTO ville VALUES(64349,64300,64,'Loubieng',43.485620,-0.756286);
INSERT INTO ville VALUES(64350,64250,64,'Louhossoa',43.329743,-1.420505);
INSERT INTO ville VALUES(64351,64570,64,'Lourdios-Ichère',43.069407,-0.724329);
INSERT INTO ville VALUES(64352,64420,64,'Lourenties',43.264352,-0.171719);
INSERT INTO ville VALUES(64353,64260,64,'Louvie-Juzon',43.090716,-0.395499);
INSERT INTO ville VALUES(64354,64440,64,'Louvie-Soubiron',42.916655,-0.382700);
INSERT INTO ville VALUES(64355,64410,64,'Louvigny',43.525862,-0.446267);
INSERT INTO ville VALUES(64356,64350,64,'Luc-Armau',43.467148,-0.130820);
INSERT INTO ville VALUES(64357,64350,64,'Lucarré',43.467148,-0.130820);
INSERT INTO ville VALUES(64358,64420,64,'Lucgarier',43.264352,-0.171719);
INSERT INTO ville VALUES(64359,64360,64,'Lucq-de-Béarn',43.301599,-0.594510);
INSERT INTO ville VALUES(64360,64660,64,'Lurbe-Saint-Christau',43.109904,-0.624921);
INSERT INTO ville VALUES(64361,64160,64,'Lussagnet-Lusson',43.396692,-0.224099);
INSERT INTO ville VALUES(64362,64120,64,'Luxe-Sumberraute',43.283838,-1.055662);
INSERT INTO ville VALUES(64363,64260,64,'Lys',43.090716,-0.395499);
INSERT INTO ville VALUES(64441,64120,64,'Pagolle',43.283838,-1.055662);
INSERT INTO ville VALUES(64442,64360,64,'Parbayse',43.301599,-0.594510);
INSERT INTO ville VALUES(64443,64150,64,'Pardies',43.371156,-0.649110);
INSERT INTO ville VALUES(64444,64800,64,'Pardies-Piétat',43.135457,-0.239691);
INSERT INTO ville VALUES(64445,64000,64,'Pau',43.321532,-0.343272);
INSERT INTO ville VALUES(65238,65200,65,'Labassère',43.010753,0.159105);
INSERT INTO ville VALUES(65239,65130,65,'Labastide',43.068275,0.288932);
INSERT INTO ville VALUES(65240,65700,65,'Labatut-Rivière',43.511351,0.016679);
INSERT INTO ville VALUES(65241,65130,65,'Laborde',43.068275,0.288932);
INSERT INTO ville VALUES(65242,65140,65,'Lacassagne',43.390919,0.174155);
INSERT INTO ville VALUES(65243,65700,65,'Lafitole',43.511351,0.016679);
INSERT INTO ville VALUES(65244,65320,65,'Lagarde',43.289315,-0.030178);
INSERT INTO ville VALUES(65245,65300,65,'Lagrange',43.142029,0.394777);
INSERT INTO ville VALUES(65248,65700,65,'Lahitte-Toupière',43.511351,0.016679);
INSERT INTO ville VALUES(65249,65230,65,'Lalanne',43.284433,0.525362);
INSERT INTO ville VALUES(65250,65220,65,'Lalanne-Trie',43.302647,0.343384);
INSERT INTO ville VALUES(65251,65310,65,'Laloubère',43.194853,0.065696);
INSERT INTO ville VALUES(65252,65380,65,'Lamarque-Pontacq',43.166771,-0.033456);
INSERT INTO ville VALUES(65253,65220,65,'Lamarque-Rustaing',43.302647,0.343384);
INSERT INTO ville VALUES(65254,65140,65,'Laméac',43.390919,0.174155);
INSERT INTO ville VALUES(65255,65240,65,'Lançon',42.835687,0.344620);
INSERT INTO ville VALUES(65256,65190,65,'Lanespède',43.197105,0.245960);
INSERT INTO ville VALUES(65257,65380,65,'Lanne',43.166771,-0.033456);
INSERT INTO ville VALUES(65258,65300,65,'Lannemezan',43.142029,0.394777);
INSERT INTO ville VALUES(65259,65350,65,'Lansac',43.274445,0.203502);
INSERT INTO ville VALUES(65260,65220,65,'Lapeyre',43.302647,0.343384);
INSERT INTO ville VALUES(65261,65670,65,'Laran',43.206065,0.510596);
INSERT INTO ville VALUES(65262,65700,65,'Larreule',43.511351,0.016679);
INSERT INTO ville VALUES(65263,65230,65,'Larroque',43.284433,0.525362);
INSERT INTO ville VALUES(65264,65700,65,'Lascazères',43.511351,0.016679);
INSERT INTO ville VALUES(65265,65350,65,'Laslades',43.274445,0.203502);
INSERT INTO ville VALUES(65266,65670,65,'Lassales',43.206065,0.510596);
INSERT INTO ville VALUES(65267,65400,65,'Lau-Balagnas',42.935056,-0.106924);
INSERT INTO ville VALUES(65268,65380,65,'Layrisse',43.166771,-0.033456);
INSERT INTO ville VALUES(65269,65140,65,'Lescurry',43.390919,0.174155);
INSERT INTO ville VALUES(65270,65190,65,'Lespouey',43.197105,0.245960);
INSERT INTO ville VALUES(65271,65100,65,'Lézignan',43.062213,-0.039721);
INSERT INTO ville VALUES(65272,65190,65,'Lhez',43.197105,0.245960);
INSERT INTO ville VALUES(65273,65140,65,'Liac',43.390919,0.174155);
INSERT INTO ville VALUES(65274,65330,65,'Libaros',43.207747,0.381966);
INSERT INTO ville VALUES(65275,65200,65,'Lies',43.010753,0.159105);
INSERT INTO ville VALUES(65276,65350,65,'Lizos',43.274445,0.203502);
INSERT INTO ville VALUES(65277,65150,65,'Lombrès',43.140417,0.387499);
INSERT INTO ville VALUES(65278,65130,65,'Lomné',43.068275,0.288932);
INSERT INTO ville VALUES(65279,65250,65,'Lortet',43.035906,0.377288);
INSERT INTO ville VALUES(65280,65100,65,'Loubajac',43.062213,-0.039721);
INSERT INTO ville VALUES(65281,65200,65,'Loucrup',43.010753,0.159105);
INSERT INTO ville VALUES(65282,65510,65,'Loudenvielle',42.750754,0.438704);
INSERT INTO ville VALUES(65283,65510,65,'Loudervielle',42.809629,0.420445);
INSERT INTO ville VALUES(65284,65290,65,'Louey',43.192096,0.020754);
INSERT INTO ville VALUES(65285,65350,65,'Louit',43.274445,0.203502);
INSERT INTO ville VALUES(65286,65100,65,'Lourdes',43.062213,-0.039721);
INSERT INTO ville VALUES(65287,65370,65,'Loures-Barousse',42.947725,0.542923);
INSERT INTO ville VALUES(65288,65220,65,'Lubret-Saint-Luc',43.302647,0.343384);
INSERT INTO ville VALUES(65289,65220,65,'Luby-Betmont',43.302647,0.343384);
INSERT INTO ville VALUES(65290,65190,65,'Luc',43.197105,0.245960);
INSERT INTO ville VALUES(65291,65100,65,'Lugagnan',43.062213,-0.039721);
INSERT INTO ville VALUES(65292,65320,65,'Luquet',43.289315,-0.030178);
INSERT INTO ville VALUES(65293,65220,65,'Lustar',43.302647,0.343384);
INSERT INTO ville VALUES(65294,65300,65,'Lutilhous',43.142029,0.394777);
INSERT INTO ville VALUES(65295,65120,65,'Luz-Saint-Sauveur',42.811194,0.011956);
INSERT INTO ville VALUES(65354,65240,65,'Pailhac',42.835687,0.344620);
INSERT INTO ville VALUES(65355,65100,65,'Paréac',43.062213,-0.039721);
INSERT INTO ville VALUES(66091,66230,66,'Lamanère',42.413904,2.459093);
INSERT INTO ville VALUES(66092,66720,66,'Lansac',42.776719,2.659189);
INSERT INTO ville VALUES(66093,66740,66,'Laroque-des-Albères',42.523396,2.897519);
INSERT INTO ville VALUES(66094,66200,66,'Latour-Bas-Elne',42.618271,2.967135);
INSERT INTO ville VALUES(66095,66760,66,'Latour-de-Carol',42.522358,1.869090);
INSERT INTO ville VALUES(66096,66720,66,'Latour-de-France',42.776719,2.659189);
INSERT INTO ville VALUES(66097,66220,66,'Lesquerde',42.786306,2.456702);
INSERT INTO ville VALUES(66098,66210,66,'Llagonne',42.553559,2.080448);
INSERT INTO ville VALUES(66099,66300,66,'Llauro',42.599211,2.751686);
INSERT INTO ville VALUES(66100,66800,66,'Llo',42.434049,2.066531);
INSERT INTO ville VALUES(66101,66300,66,'Llupia',42.599211,2.751686);
INSERT INTO ville VALUES(66132,66340,66,'Palau-de-Cerdagne',42.392103,2.022333);
INSERT INTO ville VALUES(66133,66690,66,'Palau-del-Vidre',42.524908,2.982023);
INSERT INTO ville VALUES(66134,66300,66,'Passa',42.599211,2.751686);
INSERT INTO ville VALUES(67255,67220,67,'Lalaye',48.337211,7.276637);
INSERT INTO ville VALUES(67256,67450,67,'Lampertheim',48.648099,7.703420);
INSERT INTO ville VALUES(67257,67250,67,'Lampertsloch',48.945012,7.889971);
INSERT INTO ville VALUES(67258,67700,67,'Landersheim',48.731092,7.382293);
INSERT INTO ville VALUES(67259,67360,67,'Langensoultzbach',48.936240,7.760958);
INSERT INTO ville VALUES(67260,67580,67,'Laubach',48.878924,7.675752);
INSERT INTO ville VALUES(67261,67630,67,'Lauterbourg',48.964588,8.155524);
INSERT INTO ville VALUES(67263,67510,67,'Lembach',49.016759,7.747820);
INSERT INTO ville VALUES(67264,67480,67,'Leutenheim',48.820114,8.030985);
INSERT INTO ville VALUES(67265,67340,67,'Lichtenberg',48.904964,7.475105);
INSERT INTO ville VALUES(67266,67150,67,'Limersheim',48.412602,7.666320);
INSERT INTO ville VALUES(67267,67380,67,'Lingolsheim',48.554230,7.684155);
INSERT INTO ville VALUES(67268,67640,67,'Lipsheim',48.490878,7.670666);
INSERT INTO ville VALUES(67269,67490,67,'Littenheim',48.749632,7.465853);
INSERT INTO ville VALUES(67270,67270,67,'Lixhausen',48.743561,7.567904);
INSERT INTO ville VALUES(67271,67250,67,'Lobsann',48.945012,7.889971);
INSERT INTO ville VALUES(67272,67440,67,'Lochwiller',48.685032,7.379882);
INSERT INTO ville VALUES(67273,67290,67,'Lohr',48.895034,7.341228);
INSERT INTO ville VALUES(67274,67430,67,'Lorentzen',48.955477,7.196713);
INSERT INTO ville VALUES(67275,67490,67,'Lupstein',48.749632,7.465853);
INSERT INTO ville VALUES(67276,67130,67,'Lutzelhouse',48.478263,7.206273);
INSERT INTO ville VALUES(68173,68910,68,'Labaroche',48.111335,7.191820);
INSERT INTO ville VALUES(68174,68440,68,'Landser',47.693729,7.396106);
INSERT INTO ville VALUES(68175,68650,68,'Lapoutroie',48.162199,7.133747);
INSERT INTO ville VALUES(68176,68580,68,'Largitzen',47.542591,7.170218);
INSERT INTO ville VALUES(68177,68610,68,'Lautenbach',47.941734,7.117295);
INSERT INTO ville VALUES(68178,68610,68,'Lautenbachzell',47.941734,7.117295);
INSERT INTO ville VALUES(68179,68290,68,'Lauw',47.796343,6.951847);
INSERT INTO ville VALUES(68180,68800,68,'Leimbach',47.800968,7.095096);
INSERT INTO ville VALUES(68181,68480,68,'Levoncourt',47.484044,7.293072);
INSERT INTO ville VALUES(68182,68220,68,'Leymen',47.538208,7.466373);
INSERT INTO ville VALUES(68183,68220,68,'Liebenswiller',47.538208,7.466373);
INSERT INTO ville VALUES(68184,68480,68,'Liebsdorf',47.484044,7.293072);
INSERT INTO ville VALUES(68185,68660,68,'Lièpvre',48.273938,7.263641);
INSERT INTO ville VALUES(68186,68480,68,'Ligsdorf',47.484044,7.293072);
INSERT INTO ville VALUES(68187,68480,68,'Linsdorf',47.484044,7.293072);
INSERT INTO ville VALUES(68188,68610,68,'Linthal',47.941734,7.117295);
INSERT INTO ville VALUES(68189,68280,68,'Logelheim',48.046850,7.424239);
INSERT INTO ville VALUES(68190,68480,68,'Lucelle',47.484044,7.293072);
INSERT INTO ville VALUES(68191,68720,68,'Luemschwiller',47.679906,7.253341);
INSERT INTO ville VALUES(68193,68140,68,'Luttenbach-près-Munster',48.045136,7.099287);
INSERT INTO ville VALUES(68194,68480,68,'Lutter',47.484044,7.293072);
INSERT INTO ville VALUES(68195,68460,68,'Lutterbach',47.759570,7.267731);
INSERT INTO ville VALUES(69105,69640,69,'Lacenas',45.992207,4.611642);
INSERT INTO ville VALUES(69106,69480,69,'Lachassagne',45.927507,4.709121);
INSERT INTO ville VALUES(69107,69870,69,'Lamure-sur-Azergues',46.080945,4.476235);
INSERT INTO ville VALUES(69108,69220,69,'Lancié',46.123122,4.721989);
INSERT INTO ville VALUES(69109,69430,69,'Lantignié',46.150240,4.572041);
INSERT INTO ville VALUES(69110,69590,69,'Larajasse',45.620114,4.483763);
INSERT INTO ville VALUES(69111,69620,69,'Légny',45.940440,4.560524);
INSERT INTO ville VALUES(69112,69210,69,'Lentilly',45.817864,4.611497);
INSERT INTO ville VALUES(69113,69620,69,'Létra',45.940440,4.560524);
INSERT INTO ville VALUES(69114,69400,69,'Liergues',45.991968,4.691927);
INSERT INTO ville VALUES(69115,69400,69,'Limas',45.991968,4.691927);
INSERT INTO ville VALUES(69116,69760,69,'Limonest',45.826688,4.768225);
INSERT INTO ville VALUES(69117,69380,69,'Lissieu',45.874952,4.697609);
INSERT INTO ville VALUES(69118,69700,69,'Loire-sur-Rhône',45.586865,4.735025);
INSERT INTO ville VALUES(69119,69420,69,'Longes',45.504416,4.747552);
INSERT INTO ville VALUES(69120,69770,69,'Longessaigne',45.793292,4.424882);
INSERT INTO ville VALUES(69121,69380,69,'Lozanne',45.874952,4.697609);
INSERT INTO ville VALUES(69122,69480,69,'Lucenay',45.927507,4.709121);
INSERT INTO ville VALUES(69123,NULL,69,'Lyon',45.767299,4.834328);
INSERT INTO ville VALUES(70293,70500,70,'Lambrey',47.864687,5.861087);
INSERT INTO ville VALUES(70294,70200,70,'Lantenot',47.686372,6.509665);
INSERT INTO ville VALUES(70295,70270,70,'Lanterne-et-les-Armonts',47.772931,6.605206);
INSERT INTO ville VALUES(70296,70230,70,'Larians-et-Munans',47.490933,6.255403);
INSERT INTO ville VALUES(70297,70600,70,'Larret',47.606357,5.542356);
INSERT INTO ville VALUES(70298,70120,70,'Lavigney',47.683307,5.804050);
INSERT INTO ville VALUES(70299,70120,70,'Lavoncourt',47.683307,5.804050);
INSERT INTO ville VALUES(70301,70190,70,'Lieffrans',47.432904,6.067789);
INSERT INTO ville VALUES(70302,70140,70,'Lieucourt',47.314462,5.584754);
INSERT INTO ville VALUES(70303,70240,70,'Liévans',47.684378,6.304929);
INSERT INTO ville VALUES(70304,70200,70,'Linexert',47.686372,6.509665);
INSERT INTO ville VALUES(70305,70100,70,'Luilley',999,999);
INSERT INTO ville VALUES(70306,70200,70,'Lomont',47.686372,6.509665);
INSERT INTO ville VALUES(70307,70110,70,'Longevelle',47.562765,6.453550);
INSERT INTO ville VALUES(70308,70310,70,'Longine',47.868589,6.590047);
INSERT INTO ville VALUES(70309,70230,70,'Loulans-Verchamp',47.490933,6.255403);
INSERT INTO ville VALUES(70310,70200,70,'Lure',47.686372,6.509665);
INSERT INTO ville VALUES(70311,70300,70,'Luxeuil-les-Bains',47.796169,6.355228);
INSERT INTO ville VALUES(70312,70400,70,'Luze',47.616291,6.676661);
INSERT INTO ville VALUES(70313,70200,70,'Lyoffans',47.686372,6.509665);
INSERT INTO ville VALUES(70403,70200,70,'Palante',47.686372,6.509665);
INSERT INTO ville VALUES(70404,70210,70,'Passavant-la-Rochère',47.931289,6.107445);
INSERT INTO ville VALUES(71027,71580,71,'Beaurepaire-en-Bresse',46.623079,5.351206);
INSERT INTO ville VALUES(71248,71700,71,'Lacrost',46.551966,4.860565);
INSERT INTO ville VALUES(71249,71240,71,'Laives',46.646095,4.832156);
INSERT INTO ville VALUES(71250,71870,71,'Laizé',46.362802,4.801238);
INSERT INTO ville VALUES(71251,71190,71,'Laizy',46.844199,4.196976);
INSERT INTO ville VALUES(71252,71240,71,'Lalheue',46.646095,4.832156);
INSERT INTO ville VALUES(71253,71380,71,'Lans',46.775467,4.922023);
INSERT INTO ville VALUES(71254,71270,71,'Lays-sur-le-Doubs',46.901345,5.277193);
INSERT INTO ville VALUES(71255,71140,71,'Lesme',46.652075,3.759214);
INSERT INTO ville VALUES(71256,71440,71,'Lessard-en-Bresse',46.690655,5.106830);
INSERT INTO ville VALUES(71257,71530,71,'Lessard-le-National',46.847986,4.874461);
INSERT INTO ville VALUES(71258,71570,71,'Leynes',46.228838,4.738765);
INSERT INTO ville VALUES(71259,71110,71,'Ligny-en-Brionnais',46.299775,4.064795);
INSERT INTO ville VALUES(71261,71290,71,'Loisy',46.578219,5.011299);
INSERT INTO ville VALUES(71262,71270,71,'Longepierre',46.901345,5.277193);
INSERT INTO ville VALUES(71263,71500,71,'Louhans',46.641353,5.210175);
INSERT INTO ville VALUES(71264,71250,71,'Lournand',46.468942,4.636975);
INSERT INTO ville VALUES(71265,71530,71,'Loyère',46.847986,4.874462);
INSERT INTO ville VALUES(71266,71540,71,'Lucenay-l''Évêque',47.080571,4.244971);
INSERT INTO ville VALUES(71267,71260,71,'Lugny',46.454953,4.815661);
INSERT INTO ville VALUES(71268,71120,71,'Lugny-lès-Charolles',46.431762,4.292051);
INSERT INTO ville VALUES(71269,71100,71,'Lux',46.758815,4.823424);
INSERT INTO ville VALUES(71340,71430,71,'Palinges',46.527427,4.185129);
INSERT INTO ville VALUES(71341,71350,71,'Palleau',46.909922,5.008089);
INSERT INTO ville VALUES(71342,71600,71,'Paray-le-Monial',46.431590,4.094267);
INSERT INTO ville VALUES(71343,71150,71,'Paris-l''Hôpital',46.883856,4.760431);
INSERT INTO ville VALUES(71344,71220,71,'Passy',46.483406,4.438124);
INSERT INTO ville VALUES(72155,72220,72,'Laigné-en-Belin',47.851303,0.287733);
INSERT INTO ville VALUES(72156,72320,72,'Lamnay',48.081543,0.760076);
INSERT INTO ville VALUES(72157,72240,72,'Lavardin',48.112974,-0.042732);
INSERT INTO ville VALUES(72158,72390,72,'Lavaré',48.057860,0.622278);
INSERT INTO ville VALUES(72159,72310,72,'Lavenay',47.825535,0.696815);
INSERT INTO ville VALUES(72160,72500,72,'Lavernat',47.695860,0.402530);
INSERT INTO ville VALUES(72161,72340,72,'Lhomme',47.754044,0.575969);
INSERT INTO ville VALUES(72162,72610,72,'Lignières-la-Carelle',48.374920,0.133559);
INSERT INTO ville VALUES(72163,72270,72,'Ligron',47.794975,-0.060915);
INSERT INTO ville VALUES(72164,72610,72,'Livet-en-Saosnois',48.374920,0.133559);
INSERT INTO ville VALUES(72165,72450,72,'Lombron',48.075093,0.407194);
INSERT INTO ville VALUES(72166,72540,72,'Longnes',48.004637,-0.117481);
INSERT INTO ville VALUES(72167,72300,72,'Louailles',47.820875,-0.288912);
INSERT INTO ville VALUES(72168,72540,72,'Loué',48.004637,-0.117481);
INSERT INTO ville VALUES(72169,72210,72,'Louplande',47.922080,0.029150);
INSERT INTO ville VALUES(72170,72600,72,'Louvigny',48.376647,0.306461);
INSERT INTO ville VALUES(72171,72670,72,'Louzes',999,999);
INSERT INTO ville VALUES(72172,72390,72,'Luart',48.057860,0.622278);
INSERT INTO ville VALUES(72173,72500,72,'Luceau',47.695860,0.402530);
INSERT INTO ville VALUES(72174,72290,72,'Lucé-sous-Ballon',48.168336,0.239168);
INSERT INTO ville VALUES(72175,72800,72,'Luché-Pringé',47.661195,0.162075);
INSERT INTO ville VALUES(72176,72800,72,'Lude',47.661195,0.162075);
INSERT INTO ville VALUES(72227,72600,72,'Panon',48.376647,0.306461);
INSERT INTO ville VALUES(72228,72300,72,'Parcé-sur-Sarthe',47.820875,-0.288912);
INSERT INTO ville VALUES(72229,72140,72,'Parennes',48.172787,-0.129040);
INSERT INTO ville VALUES(72230,72330,72,'Parigné-le-Pôlin',47.826147,0.099666);
INSERT INTO ville VALUES(72231,72250,72,'Parigné-l''Évêque',47.937977,0.365940);
INSERT INTO ville VALUES(73141,73800,73,'Laissaud',45.496753,6.042978);
INSERT INTO ville VALUES(73142,73210,73,'Landry',45.559167,6.713619);
INSERT INTO ville VALUES(73143,73480,73,'Lanslebourg-Mont-Cenis',45.305053,7.014644);
INSERT INTO ville VALUES(73144,73480,73,'Lanslevillard',45.305053,7.014644);
INSERT INTO ville VALUES(73145,73610,73,'Lépin-le-Lac',45.527385,5.781803);
INSERT INTO ville VALUES(73146,73340,73,'Lescheraines',45.662232,6.099471);
INSERT INTO ville VALUES(73147,73170,73,'Loisieux',45.697050,5.765353);
INSERT INTO ville VALUES(73149,73170,73,'Lucey',45.697050,5.765353);
INSERT INTO ville VALUES(73187,73260,73,'Léchère',45.525510,6.466882);
INSERT INTO ville VALUES(73196,73200,73,'Pallud',45.667208,6.359315);
INSERT INTO ville VALUES(74146,74500,74,'Larringes',46.360689,6.657096);
INSERT INTO ville VALUES(74147,74210,74,'Lathuile',45.755551,6.285313);
INSERT INTO ville VALUES(74148,74320,74,'Leschaux',45.817545,6.129325);
INSERT INTO ville VALUES(74150,74140,74,'Loisin',46.291744,6.326284);
INSERT INTO ville VALUES(74151,74150,74,'Lornay',45.885128,5.948050);
INSERT INTO ville VALUES(74152,74330,74,'Lovagny',45.954343,6.040498);
INSERT INTO ville VALUES(74153,74380,74,'Lucinges',46.177969,6.298696);
INSERT INTO ville VALUES(74154,74500,74,'Lugrin',46.360689,6.657096);
INSERT INTO ville VALUES(74155,74470,74,'Lullin',46.241443,6.544756);
INSERT INTO ville VALUES(74156,74890,74,'Lully',46.268579,6.386535);
INSERT INTO ville VALUES(74157,74200,74,'Lyaud',46.346460,6.517591);
INSERT INTO ville VALUES(74208,74190,74,'Passy',45.957780,6.750613);
INSERT INTO ville VALUES(75056,NULL,75,'Paris',48.856558,2.350966);
INSERT INTO ville VALUES(76064,76280,76,'Beaurepaire',49.631195,0.239438);
INSERT INTO ville VALUES(76379,76730,76,'Lamberville',49.795897,0.970621);
INSERT INTO ville VALUES(76380,76730,76,'Lammerville',49.795897,0.970621);
INSERT INTO ville VALUES(76381,76390,76,'Landes-Vieilles-et-Neuves',49.752951,1.667963);
INSERT INTO ville VALUES(76382,76210,76,'Lanquetot',49.591121,0.498097);
INSERT INTO ville VALUES(76383,76730,76,'Lestanville',49.795897,0.970621);
INSERT INTO ville VALUES(76384,76170,76,'Lillebonne',49.515782,0.524943);
INSERT INTO ville VALUES(76385,76570,76,'Limésy',49.595321,0.951702);
INSERT INTO ville VALUES(76386,76540,76,'Limpiville',49.748001,0.509794);
INSERT INTO ville VALUES(76387,76760,76,'Lindebeuf',49.669178,0.913794);
INSERT INTO ville VALUES(76388,76210,76,'Lintot',49.591121,0.498097);
INSERT INTO ville VALUES(76389,76590,76,'Lintot-les-Bois',49.796816,1.116805);
INSERT INTO ville VALUES(76390,76790,76,'Loges',49.700162,0.260652);
INSERT INTO ville VALUES(76391,76500,76,'Londe',49.299033,0.944961);
INSERT INTO ville VALUES(76392,76660,76,'Londinières',49.843687,1.395530);
INSERT INTO ville VALUES(76393,76440,76,'Longmesnil',49.622311,1.547090);
INSERT INTO ville VALUES(76394,76260,76,'Longroy',49.998037,1.440697);
INSERT INTO ville VALUES(76395,76860,76,'Longueil',49.880888,0.953932);
INSERT INTO ville VALUES(76396,76750,76,'Longuerue',49.566186,1.338343);
INSERT INTO ville VALUES(76397,76590,76,'Longueville-sur-Scie',49.796816,1.116805);
INSERT INTO ville VALUES(76398,76490,76,'Louvetot',49.536796,0.704650);
INSERT INTO ville VALUES(76399,76270,76,'Lucy',49.761554,1.458274);
INSERT INTO ville VALUES(76400,76810,76,'Luneray',49.817456,0.909116);
INSERT INTO ville VALUES(76493,76450,76,'Paluel',49.768896,0.649589);
INSERT INTO ville VALUES(76494,76210,76,'Parc-d''Anxtot',49.591121,0.498097);
INSERT INTO ville VALUES(76495,76570,76,'Pavilly',49.595321,0.951702);
INSERT INTO ville VALUES(77243,77400,77,'Lagny-sur-Marne',48.880538,2.709916);
INSERT INTO ville VALUES(77244,77760,77,'Larchant',48.292774,2.533288);
INSERT INTO ville VALUES(77245,77148,77,'Laval-en-Brie',48.450065,2.990689);
INSERT INTO ville VALUES(77246,77171,77,'Léchelle',48.540965,3.401046);
INSERT INTO ville VALUES(77247,77320,77,'Lescherolles',48.773003,3.313709);
INSERT INTO ville VALUES(77248,77450,77,'Lesches',48.922444,2.789570);
INSERT INTO ville VALUES(77249,77150,77,'Lésigny',48.741781,2.629259);
INSERT INTO ville VALUES(77250,77320,77,'Leudon-en-Brie',48.773003,3.313709);
INSERT INTO ville VALUES(77251,77127,77,'Lieusaint',48.625549,2.548734);
INSERT INTO ville VALUES(77252,77550,77,'Limoges-Fourches',48.618642,2.641793);
INSERT INTO ville VALUES(77253,77550,77,'Lissy',48.618642,2.641793);
INSERT INTO ville VALUES(77254,77220,77,'Liverdy-en-Brie',48.746149,2.756537);
INSERT INTO ville VALUES(77255,77000,77,'Livry-sur-Seine',48.523895,2.681360);
INSERT INTO ville VALUES(77256,77650,77,'Lizines',48.514802,3.237978);
INSERT INTO ville VALUES(77257,77440,77,'Lizy-sur-Ourcq',49.017425,3.064400);
INSERT INTO ville VALUES(77258,77185,77,'Lognes',48.832478,2.636707);
INSERT INTO ville VALUES(77259,77230,77,'Longperrier',49.039509,2.678941);
INSERT INTO ville VALUES(77260,77650,77,'Longueville',48.514802,3.237978);
INSERT INTO ville VALUES(77261,77710,77,'Lorrez-le-Bocage-Préaux',48.236613,2.875411);
INSERT INTO ville VALUES(77262,77560,77,'Louan-Villegruis-Fontaine',48.649010,3.402475);
INSERT INTO ville VALUES(77263,77520,77,'Luisetaines',48.481713,3.114344);
INSERT INTO ville VALUES(77264,77540,77,'Lumigny-Nesles-Ormeaux',48.692093,2.976592);
INSERT INTO ville VALUES(77265,77138,77,'Luzancy',48.975524,3.179237);
INSERT INTO ville VALUES(77353,77710,77,'Paley',48.236613,2.875411);
INSERT INTO ville VALUES(77354,77830,77,'Pamfou',48.463299,2.898664);
INSERT INTO ville VALUES(77355,77520,77,'Paroy',48.481713,3.114344);
INSERT INTO ville VALUES(77356,77480,77,'Passy-sur-Seine',48.409761,3.299419);
INSERT INTO ville VALUES(78329,78440,78,'Lainville-en-Vexin',49.021241,1.797817);
INSERT INTO ville VALUES(78334,78320,78,'Lévis-Saint-Nom',48.736209,1.946806);
INSERT INTO ville VALUES(78335,78520,78,'Limay',49.014189,1.689468);
INSERT INTO ville VALUES(78337,78270,78,'Limetz-Villez',49.030050,1.565786);
INSERT INTO ville VALUES(78343,78350,78,'Loges-en-Josas',48.765700,2.158244);
INSERT INTO ville VALUES(78344,78270,78,'Lommoye',49.030050,1.565786);
INSERT INTO ville VALUES(78346,78980,78,'Longnes',48.941921,1.560671);
INSERT INTO ville VALUES(78349,78730,78,'Longvilliers',48.565429,1.965266);
INSERT INTO ville VALUES(78350,78430,78,'Louveciennes',48.859519,2.113211);
INSERT INTO ville VALUES(78478,78660,78,'Paray-Douaville',48.504986,1.864772);
INSERT INTO ville VALUES(79145,79200,79,'Lageon',46.680141,-0.239034);
INSERT INTO ville VALUES(79147,79240,79,'Largeasse',46.627019,-0.560936);
INSERT INTO ville VALUES(79148,79120,79,'Lezay',46.278670,0.023633);
INSERT INTO ville VALUES(79149,79390,79,'Lhoumois',46.695333,-0.056068);
INSERT INTO ville VALUES(79150,79190,79,'Limalonges',46.162753,0.085099);
INSERT INTO ville VALUES(79152,79190,79,'Lorigné',46.162753,0.085099);
INSERT INTO ville VALUES(79153,79110,79,'Loubigné',46.079483,-0.059172);
INSERT INTO ville VALUES(79154,79110,79,'Loubillé',46.079483,-0.059172);
INSERT INTO ville VALUES(79156,79600,79,'Louin',46.830793,-0.139975);
INSERT INTO ville VALUES(79157,79100,79,'Louzy',46.979790,-0.177353);
INSERT INTO ville VALUES(79158,79170,79,'Luché-sur-Brioux',46.126625,-0.276985);
INSERT INTO ville VALUES(79159,79330,79,'Luché-Thouarsais',46.895832,-0.281376);
INSERT INTO ville VALUES(79160,79170,79,'Lusseray',46.126625,-0.276985);
INSERT INTO ville VALUES(79161,79100,79,'Luzay',46.979790,-0.177353);
INSERT INTO ville VALUES(79198,79170,79,'Paizay-le-Chapt',46.126625,-0.276985);
INSERT INTO ville VALUES(79199,79500,79,'Paizay-le-Tort',46.208643,-0.110272);
INSERT INTO ville VALUES(79200,79220,79,'Pamplie',46.481112,-0.403875);
INSERT INTO ville VALUES(79201,79800,79,'Pamproux',46.376447,-0.090656);
INSERT INTO ville VALUES(79202,79200,79,'Parthenay',46.680141,-0.239034);
INSERT INTO ville VALUES(79203,79100,79,'Pas-de-Jeu',46.979790,-0.177353);
INSERT INTO ville VALUES(80453,80500,80,'Laboissière-en-Santerre',49.654953,2.574227);
INSERT INTO ville VALUES(80455,80290,80,'Lachapelle',49.766353,1.950933);
INSERT INTO ville VALUES(80456,80430,80,'Lafresguimont-Saint-Martin',49.836817,1.789511);
INSERT INTO ville VALUES(80458,80800,80,'Lahoussoye',49.927916,2.463321);
INSERT INTO ville VALUES(80459,80270,80,'Laleu',49.945266,1.920233);
INSERT INTO ville VALUES(80460,80590,80,'Lamaronde',49.777985,1.840884);
INSERT INTO ville VALUES(80461,80450,80,'Lamotte-Brebière',49.903185,2.373048);
INSERT INTO ville VALUES(80462,80150,80,'Lamotte-Buleux',50.242092,1.924698);
INSERT INTO ville VALUES(80463,80720,80,'Lamotte-Warfusée',49.850879,2.582889);
INSERT INTO ville VALUES(80464,80230,80,'Lanchères',50.156151,1.623363);
INSERT INTO ville VALUES(80465,80190,80,'Languevoisin-Quiquery',49.767706,2.916802);
INSERT INTO ville VALUES(80466,80620,80,'Lanches-Saint-Hilaire',50.095070,2.108304);
INSERT INTO ville VALUES(80467,80700,80,'Laucourt',49.700069,2.780427);
INSERT INTO ville VALUES(80468,80300,80,'Laviéville',50.028749,2.649805);
INSERT INTO ville VALUES(80469,80250,80,'Lawarde-Mauger-l''Hortoy',49.725740,2.380355);
INSERT INTO ville VALUES(80470,80560,80,'Léalvillers',50.064879,2.510628);
INSERT INTO ville VALUES(80472,80360,80,'Lesbufs',999,999);
INSERT INTO ville VALUES(80473,80700,80,'Liancourt-Fosse',49.700069,2.780427);
INSERT INTO ville VALUES(80474,80320,80,'Licourt',49.821220,2.824425);
INSERT INTO ville VALUES(80475,80240,80,'Liéramont',49.958372,3.038996);
INSERT INTO ville VALUES(80476,80580,80,'Liercourt',50.055855,1.882751);
INSERT INTO ville VALUES(80477,80150,80,'Ligescourt',50.242092,1.924698);
INSERT INTO ville VALUES(80478,80500,80,'Lignières',49.654953,2.574227);
INSERT INTO ville VALUES(80479,80590,80,'Lignières-Châtelain',49.777985,1.840884);
INSERT INTO ville VALUES(80480,80140,80,'Lignières-en-Vimeu',49.950324,1.770985);
INSERT INTO ville VALUES(80481,80320,80,'Lihons',49.821220,2.824425);
INSERT INTO ville VALUES(80482,80490,80,'Limeux',50.003220,1.858308);
INSERT INTO ville VALUES(80484,80430,80,'Liomer',49.836817,1.789511);
INSERT INTO ville VALUES(80485,80160,80,'Luilly',999,999);
INSERT INTO ville VALUES(80486,80510,80,'Long',50.038189,1.961970);
INSERT INTO ville VALUES(80487,80240,80,'Longavesnes',49.958372,3.038996);
INSERT INTO ville VALUES(80488,80510,80,'Longpré-les-Corps-Saints',50.038189,1.961970);
INSERT INTO ville VALUES(80489,80330,80,'Longueau',49.858927,2.347770);
INSERT INTO ville VALUES(80490,80360,80,'Longueval',50.012646,2.914976);
INSERT INTO ville VALUES(80491,80600,80,'Longuevillette',50.143859,2.347183);
INSERT INTO ville VALUES(80493,80560,80,'Louvencourt',50.064879,2.510628);
INSERT INTO ville VALUES(80494,80250,80,'Louvrechy',49.725740,2.380355);
INSERT INTO ville VALUES(80495,80600,80,'Lucheux',50.143859,2.347183);
INSERT INTO ville VALUES(80616,80190,80,'Pargny',49.767706,2.916802);
INSERT INTO ville VALUES(80617,80700,80,'Parvillers-le-Quesnoy',49.700069,2.780427);
INSERT INTO ville VALUES(81111,81170,81,'Labarthe-Bleys',44.076455,1.926813);
INSERT INTO ville VALUES(81112,81150,81,'Labastide-de-Lévis',43.937138,2.035361);
INSERT INTO ville VALUES(81113,81120,81,'Labastide-Dénat',43.815286,2.229427);
INSERT INTO ville VALUES(81114,81400,81,'Labastide-Gabausse',44.048049,2.145402);
INSERT INTO ville VALUES(81115,81270,81,'Labastide-Rouairoux',43.478100,2.637814);
INSERT INTO ville VALUES(81116,81500,81,'Labastide-Saint-Georges',43.695444,1.816290);
INSERT INTO ville VALUES(81117,81300,81,'Labessière-Candeil',43.765588,2.001667);
INSERT INTO ville VALUES(81118,81100,81,'Laboulbène',43.617287,2.279287);
INSERT INTO ville VALUES(81119,81120,81,'Laboutarie',43.815286,2.229427);
INSERT INTO ville VALUES(81120,81290,81,'Labruguière',43.507920,2.227795);
INSERT INTO ville VALUES(81121,81240,81,'Lacabarède',43.499230,2.526409);
INSERT INTO ville VALUES(81122,81340,81,'Lacapelle-Pinet',44.017364,2.419035);
INSERT INTO ville VALUES(81123,81170,81,'Lacapelle-Ségalar',44.076455,1.926813);
INSERT INTO ville VALUES(81124,81230,81,'Lacaune',43.699111,2.694385);
INSERT INTO ville VALUES(81125,81330,81,'Lacaze',43.754782,2.466836);
INSERT INTO ville VALUES(81126,81500,81,'Lacougotte-Cadoul',43.695444,1.816290);
INSERT INTO ville VALUES(81127,81470,81,'Lacroisille',43.562846,1.880629);
INSERT INTO ville VALUES(81128,81210,81,'Lacrouzette',43.678014,2.309239);
INSERT INTO ville VALUES(81129,81110,81,'Lagardiolle',43.465106,2.151741);
INSERT INTO ville VALUES(81130,81090,81,'Lagarrigue',43.571211,2.298746);
INSERT INTO ville VALUES(81131,81150,81,'Lagrave',43.937138,2.035361);
INSERT INTO ville VALUES(81132,81220,81,'Lalbarède',43.655325,1.974221);
INSERT INTO ville VALUES(81133,81120,81,'Lamillarié',43.815286,2.229427);
INSERT INTO ville VALUES(81134,81260,81,'Lamontélarié',43.596669,2.536995);
INSERT INTO ville VALUES(81135,81640,81,'Laparrouquial',44.081697,2.085352);
INSERT INTO ville VALUES(81136,81140,81,'Larroque',44.026581,1.794551);
INSERT INTO ville VALUES(81137,81260,81,'Lasfaillades',43.596669,2.536995);
INSERT INTO ville VALUES(81138,81300,81,'Lasgraisses',43.765588,2.001667);
INSERT INTO ville VALUES(81139,81440,81,'Lautrec',43.715560,2.128993);
INSERT INTO ville VALUES(81140,81500,81,'Lavaur',43.695444,1.816290);
INSERT INTO ville VALUES(81141,81340,81,'Lédas-et-Penthiès',44.017364,2.419035);
INSERT INTO ville VALUES(81142,81700,81,'Lempaut',43.556502,2.022023);
INSERT INTO ville VALUES(81143,81110,81,'Lescout',43.465106,2.151741);
INSERT INTO ville VALUES(81144,81380,81,'Lescure-d''Albigeois',43.963113,2.184686);
INSERT INTO ville VALUES(81145,81310,81,'Lisle-sur-Tarn',43.850767,1.831628);
INSERT INTO ville VALUES(81146,81170,81,'Livers-Cazelles',44.076455,1.926813);
INSERT INTO ville VALUES(81147,81120,81,'Lombers',43.815286,2.229427);
INSERT INTO ville VALUES(81148,81170,81,'Loubers',44.076455,1.926813);
INSERT INTO ville VALUES(81149,81800,81,'Loupiac',43.832997,1.700195);
INSERT INTO ville VALUES(81150,81500,81,'Lugan',43.695444,1.816290);
INSERT INTO ville VALUES(81199,81340,81,'Padiès',44.017364,2.419035);
INSERT INTO ville VALUES(81200,81700,81,'Palleville',43.556502,2.022023);
INSERT INTO ville VALUES(81201,81190,81,'Pampelonne',44.129265,2.181581);
INSERT INTO ville VALUES(81202,81310,81,'Parisot',43.850767,1.831628);
INSERT INTO ville VALUES(81203,81250,81,'Paulinet',43.870540,2.464224);
INSERT INTO ville VALUES(81204,81660,81,'Payrin-Augmontel',43.531219,2.385918);
INSERT INTO ville VALUES(82077,82220,82,'Labarthe',44.190324,1.358169);
INSERT INTO ville VALUES(82078,82240,82,'Labastide-de-Penne',44.225927,1.623559);
INSERT INTO ville VALUES(82079,82370,82,'Labastide-Saint-Pierre',43.926427,1.404893);
INSERT INTO ville VALUES(82080,82100,82,'Labastide-du-Temple',44.020293,1.126011);
INSERT INTO ville VALUES(82081,82100,82,'Labourgade',44.020293,1.126011);
INSERT INTO ville VALUES(82082,82160,82,'Lacapelle-Livron',44.259135,1.809845);
INSERT INTO ville VALUES(82083,82120,82,'Lachapelle',43.968491,0.869358);
INSERT INTO ville VALUES(82084,82190,82,'Lacour',44.241128,1.000493);
INSERT INTO ville VALUES(82085,82290,82,'Lacourt-Saint-Pierre',44.039226,1.243160);
INSERT INTO ville VALUES(82086,82100,82,'Lafitte',44.020293,1.126011);
INSERT INTO ville VALUES(82087,82130,82,'Lafrançaise',44.117488,1.303306);
INSERT INTO ville VALUES(82088,82250,82,'Laguépie',44.164348,1.958813);
INSERT INTO ville VALUES(82089,82360,82,'Lamagistère',44.130965,0.822560);
INSERT INTO ville VALUES(82090,82130,82,'Lamothe-Capdeville',44.117488,1.303306);
INSERT INTO ville VALUES(82091,82500,82,'Lamothe-Cumont',43.872765,0.999391);
INSERT INTO ville VALUES(82092,82240,82,'Lapenche',44.225927,1.623559);
INSERT INTO ville VALUES(82093,82500,82,'Larrazet',43.872765,0.999391);
INSERT INTO ville VALUES(82094,82110,82,'Lauzerte',44.236876,1.179353);
INSERT INTO ville VALUES(82095,82240,82,'Lavaurette',44.225927,1.623559);
INSERT INTO ville VALUES(82097,82120,82,'Lavit',43.968491,0.869358);
INSERT INTO ville VALUES(82098,82230,82,'Léojac',43.968977,1.531545);
INSERT INTO ville VALUES(82099,82200,82,'Lizac',44.138721,1.077801);
INSERT INTO ville VALUES(82100,82160,82,'Loze',44.259135,1.809845);
INSERT INTO ville VALUES(82137,82160,82,'Parisot',44.259135,1.809845);
INSERT INTO ville VALUES(83070,83980,83,'Lavandou',43.166735,6.402859);
INSERT INTO ville VALUES(83071,83250,83,'Londe-les-Maures',43.164215,6.242397);
INSERT INTO ville VALUES(83072,83510,83,'Lorgues',43.481061,6.345674);
INSERT INTO ville VALUES(83073,83340,83,'Luc',43.382331,6.297179);
INSERT INTO ville VALUES(84058,84480,84,'Lacoste',43.832790,5.326270);
INSERT INTO ville VALUES(84059,84190,84,'Lafare',44.147050,5.018176);
INSERT INTO ville VALUES(84060,84400,84,'Lagarde-d''Apt',43.915254,5.425769);
INSERT INTO ville VALUES(84061,84290,84,'Lagarde-Paréol',44.239043,4.908033);
INSERT INTO ville VALUES(84062,84800,84,'Lagnes',43.915738,5.086100);
INSERT INTO ville VALUES(84063,84840,84,'Lamotte-du-Rhône',44.294356,4.681731);
INSERT INTO ville VALUES(84064,84840,84,'Lapalud',44.294356,4.681731);
INSERT INTO ville VALUES(84065,84360,84,'Lauris',43.763633,5.235728);
INSERT INTO ville VALUES(84066,84220,84,'Lioux',43.930702,5.245619);
INSERT INTO ville VALUES(84067,84870,84,'Loriol-du-Comtat',44.075826,5.004490);
INSERT INTO ville VALUES(84068,84160,84,'Lourmarin',43.759861,5.398888);
INSERT INTO ville VALUES(85017,85500,85,'Beaurepaire',46.873793,-1.042068);
INSERT INTO ville VALUES(85117,85400,85,'Lairoux',46.463782,-1.183200);
INSERT INTO ville VALUES(85118,85150,85,'Landeronde',46.601187,-1.661645);
INSERT INTO ville VALUES(85119,85130,85,'Landes-Genusson',46.960906,-1.053673);
INSERT INTO ville VALUES(85120,85220,85,'Landevieille',46.715211,-1.778966);
INSERT INTO ville VALUES(85121,85370,85,'Langon',46.453586,-0.991951);
INSERT INTO ville VALUES(85123,85420,85,'Liez',46.361773,-0.724944);
INSERT INTO ville VALUES(85125,85120,85,'Loge-Fougereuse',46.627982,-0.709650);
INSERT INTO ville VALUES(85126,85200,85,'Longèves',46.468057,-0.810608);
INSERT INTO ville VALUES(85127,85560,85,'Longeville-sur-Mer',46.428145,-1.473039);
INSERT INTO ville VALUES(85128,85400,85,'Luçon',46.463782,-1.183200);
INSERT INTO ville VALUES(85129,85170,85,'Lucs-sur-Boulogne',46.805267,-1.457592);
INSERT INTO ville VALUES(85169,85670,85,'Palluau',46.830918,-1.669033);
INSERT INTO ville VALUES(86120,86390,86,'Lathus-Saint-Rémy',46.330710,0.947351);
INSERT INTO ville VALUES(86121,86190,86,'Latillé',46.678590,0.096918);
INSERT INTO ville VALUES(86122,86300,86,'Lauthiers',46.545960,0.691586);
INSERT INTO ville VALUES(86123,86470,86,'Lavausseau',46.538960,0.087515);
INSERT INTO ville VALUES(86124,86800,86,'Lavoux',46.563499,0.521457);
INSERT INTO ville VALUES(86125,86450,86,'Leigné-les-Bois',46.743560,0.725211);
INSERT INTO ville VALUES(86126,86300,86,'Leignes-sur-Fontaine',46.545960,0.691586);
INSERT INTO ville VALUES(86127,86230,86,'Leigné-sur-Usseau',46.907013,0.418690);
INSERT INTO ville VALUES(86128,86140,86,'Lencloître',46.840051,0.334867);
INSERT INTO ville VALUES(86129,86270,86,'Lésigny',46.810390,0.760818);
INSERT INTO ville VALUES(86130,86220,86,'Leugny',46.917448,0.634497);
INSERT INTO ville VALUES(86131,86410,86,'Lhommaizé',46.397351,0.569834);
INSERT INTO ville VALUES(86132,86290,86,'Liglet',46.443399,1.058368);
INSERT INTO ville VALUES(86133,86240,86,'Ligugé',46.503968,0.299525);
INSERT INTO ville VALUES(86134,86400,86,'Linazay',46.153337,0.271577);
INSERT INTO ville VALUES(86135,86800,86,'Liniers',46.563499,0.521457);
INSERT INTO ville VALUES(86136,86400,86,'Lizant',46.153337,0.271577);
INSERT INTO ville VALUES(86137,86200,86,'Loudun',46.996675,0.128142);
INSERT INTO ville VALUES(86138,86430,86,'Luchapt',46.218779,0.788637);
INSERT INTO ville VALUES(86139,86600,86,'Lusignan',46.460460,0.088554);
INSERT INTO ville VALUES(86140,86320,86,'Lussac-les-Châteaux',46.381704,0.731229);
INSERT INTO ville VALUES(86187,86300,86,'Paizay-le-Sec',46.545960,0.691586);
INSERT INTO ville VALUES(86188,86700,86,'Payré',46.337840,0.187888);
INSERT INTO ville VALUES(86189,86350,86,'Payroux',46.264221,0.506532);
INSERT INTO ville VALUES(87082,87500,87,'Ladignac-le-Long',45.533784,1.226704);
INSERT INTO ville VALUES(87083,87370,87,'Laurière',46.054517,1.457336);
INSERT INTO ville VALUES(87084,87230,87,'Lavignac',45.649065,1.006082);
INSERT INTO ville VALUES(87085,87000,87,'Limoges',45.821349,1.251002);
INSERT INTO ville VALUES(87086,87130,87,'Linards',45.680442,1.597838);
INSERT INTO ville VALUES(87087,87360,87,'Lussac-les-Églises',46.319310,1.123358);
INSERT INTO ville VALUES(87112,87230,87,'Pageas',45.649065,1.006082);
INSERT INTO ville VALUES(87113,87410,87,'Palais-sur-Vienne',45.870222,1.328790);
INSERT INTO ville VALUES(87114,87350,87,'Panazol',45.844480,1.322730);
INSERT INTO ville VALUES(88258,88320,88,'Lamarche',48.049343,5.784172);
INSERT INTO ville VALUES(88259,88300,88,'Landaville',48.286861,6.312136);
INSERT INTO ville VALUES(88260,88130,88,'Langley',48.370997,6.269956);
INSERT INTO ville VALUES(88261,88600,88,'Laval-sur-Vologne',48.216819,6.692666);
INSERT INTO ville VALUES(88262,88600,88,'Laveline-devant-Bruyères',48.216819,6.692666);
INSERT INTO ville VALUES(88263,88640,88,'Laveline-du-Houx',48.134381,6.778137);
INSERT INTO ville VALUES(88264,88270,88,'Légéville-et-Bonfays',48.174126,6.201874);
INSERT INTO ville VALUES(88265,88300,88,'Lemmecourt',48.286861,6.312136);
INSERT INTO ville VALUES(88266,88600,88,'Lépanges-sur-Vologne',48.216819,6.692666);
INSERT INTO ville VALUES(88267,88260,88,'Lerrain',48.104983,6.070880);
INSERT INTO ville VALUES(88268,88490,88,'Lesseux',48.307938,7.115157);
INSERT INTO ville VALUES(88269,88400,88,'Liézey',48.069443,6.892440);
INSERT INTO ville VALUES(88270,88350,88,'Liffol-le-Grand',48.347404,5.519794);
INSERT INTO ville VALUES(88271,88800,88,'Lignéville',48.167346,5.950960);
INSERT INTO ville VALUES(88272,88410,88,'Lironcourt',48.011988,5.969398);
INSERT INTO ville VALUES(88273,88000,88,'Longchamp',48.187419,6.486636);
INSERT INTO ville VALUES(88274,88170,88,'Longchamp-sous-Châtenois',48.339334,5.871533);
INSERT INTO ville VALUES(88275,88490,88,'Lubine',48.307938,7.115157);
INSERT INTO ville VALUES(88276,88490,88,'Lusse',48.307938,7.115157);
INSERT INTO ville VALUES(88277,88110,88,'Luvigny',48.442327,6.970880);
INSERT INTO ville VALUES(88340,88700,88,'Padoux',48.368023,6.651255);
INSERT INTO ville VALUES(88341,88100,88,'Pair-et-Grandrupt',48.274967,6.938938);
INSERT INTO ville VALUES(88342,88330,88,'Pallegney',48.340914,6.432253);
INSERT INTO ville VALUES(88343,88800,88,'Parey-sous-Montfort',48.252181,5.944641);
INSERT INTO ville VALUES(88344,88350,88,'Pargny-sous-Mureau',48.347404,5.519794);
INSERT INTO ville VALUES(89213,89110,89,'Laduz',47.841903,3.311655);
INSERT INTO ville VALUES(89214,89190,89,'Lailly',48.257791,3.520279);
INSERT INTO ville VALUES(89215,89560,89,'Lain',47.601582,3.454916);
INSERT INTO ville VALUES(89216,89520,89,'Lainsecq',47.583966,3.249353);
INSERT INTO ville VALUES(89217,89130,89,'Lalande',47.736312,3.261772);
INSERT INTO ville VALUES(89218,89400,89,'Laroche-Saint-Cydroine',47.990284,3.517792);
INSERT INTO ville VALUES(89219,89570,89,'Lasson',48.071912,3.774281);
INSERT INTO ville VALUES(89220,89170,89,'Lavau',47.636609,3.039512);
INSERT INTO ville VALUES(89221,89130,89,'Leugny',47.736312,3.261772);
INSERT INTO ville VALUES(89222,89520,89,'Levis',47.583966,3.249353);
INSERT INTO ville VALUES(89223,89160,89,'Lézinnes',47.772193,4.159050);
INSERT INTO ville VALUES(89224,89800,89,'Lichères-près-Aigremont',47.794003,3.799399);
INSERT INTO ville VALUES(89225,89660,89,'Lichères-sur-Yonne',47.547153,3.649594);
INSERT INTO ville VALUES(89226,89800,89,'Lignorelles',47.794003,3.799399);
INSERT INTO ville VALUES(89227,89144,89,'Ligny-le-Châtel',47.917338,3.779022);
INSERT INTO ville VALUES(89228,89240,89,'Lindry',47.757425,3.417553);
INSERT INTO ville VALUES(89229,89140,89,'Lixy',48.301440,3.195519);
INSERT INTO ville VALUES(89230,89300,89,'Looze',47.991158,3.380297);
INSERT INTO ville VALUES(89232,89200,89,'Lucy-le-Bois',47.508636,3.879933);
INSERT INTO ville VALUES(89233,89270,89,'Lucy-sur-Cure',47.622846,3.757186);
INSERT INTO ville VALUES(89234,89480,89,'Lucy-sur-Yonne',47.527125,3.444707);
INSERT INTO ville VALUES(89284,89160,89,'Pacy-sur-Armançon',47.772193,4.159050);
INSERT INTO ville VALUES(89285,89140,89,'Pailly',48.301440,3.195519);
INSERT INTO ville VALUES(89286,89240,89,'Parly',47.757425,3.417553);
INSERT INTO ville VALUES(89287,89100,89,'Paron',48.205718,3.296209);
INSERT INTO ville VALUES(89288,89210,89,'Paroy-en-Othe',48.051585,3.631909);
INSERT INTO ville VALUES(89289,89300,89,'Paroy-sur-Tholon',47.991158,3.380297);
INSERT INTO ville VALUES(89290,89310,89,'Pasilly',47.695057,4.002136);
INSERT INTO ville VALUES(89291,89510,89,'Passy',48.127626,3.316418);
INSERT INTO ville VALUES(90057,90300,90,'Lachapelle-sous-Chaux',47.684255,6.840234);
INSERT INTO ville VALUES(90058,90360,90,'Lachapelle-sous-Rougemont',47.719335,7.010030);
INSERT INTO ville VALUES(90059,90150,90,'Lacollonge',47.662757,6.986119);
INSERT INTO ville VALUES(90060,90150,90,'Lagrange',47.662757,6.986119);
INSERT INTO ville VALUES(90061,90170,90,'Lamadeleine-Val-des-Anges',47.733126,6.921544);
INSERT INTO ville VALUES(90062,90150,90,'Larivière',47.662757,6.986119);
INSERT INTO ville VALUES(90063,90100,90,'Lebetain',47.517361,7.032744);
INSERT INTO ville VALUES(90064,90100,90,'Lepuix-Neuf',47.517361,7.032744);
INSERT INTO ville VALUES(90065,90200,90,'Lepuix',47.755303,6.830971);
INSERT INTO ville VALUES(90066,90110,90,'Leval',47.730594,6.970793);
INSERT INTO ville VALUES(91330,91510,91,'Lardy',48.510677,2.264166);
INSERT INTO ville VALUES(91332,91630,91,'Leudeville',48.561666,2.285654);
INSERT INTO ville VALUES(91333,91310,91,'Leuville-sur-Orge',48.631789,2.261396);
INSERT INTO ville VALUES(91338,91470,91,'Limours',48.632352,2.066744);
INSERT INTO ville VALUES(91339,91310,91,'Linas',48.631789,2.261396);
INSERT INTO ville VALUES(91340,91090,91,'Lisses',48.593529,2.426306);
INSERT INTO ville VALUES(91345,91160,91,'Longjumeau',48.687999,2.284875);
INSERT INTO ville VALUES(91347,91310,91,'Longpont-sur-Orge',48.631789,2.261396);
INSERT INTO ville VALUES(91477,91120,91,'Palaiseau',48.715433,2.229364);
INSERT INTO ville VALUES(91479,91550,91,'Paray-Vieille-Poste',48.723971,2.357624);
INSERT INTO ville VALUES(92044,92300,92,'Levallois-Perret',48.894618,2.287447);
INSERT INTO ville VALUES(93045,93260,93,'Lilas',48.881986,2.420829);
INSERT INTO ville VALUES(93046,93190,93,'Livry-Gargan',48.918383,2.535185);
INSERT INTO ville VALUES(93055,93500,93,'Pantin',48.900579,2.408659);
INSERT INTO ville VALUES(93057,93320,93,'Pavillons-sous-Bois',48.906959,2.505568);
INSERT INTO ville VALUES(94044,94450,94,'Limeil-Brévannes',48.746139,2.492423);
INSERT INTO ville VALUES(95328,95690,95,'Labbeville',49.140244,2.155260);
INSERT INTO ville VALUES(95331,95270,95,'Lassy',49.115438,2.404169);
INSERT INTO ville VALUES(95341,95300,95,'Livilliers',49.073981,2.112089);
INSERT INTO ville VALUES(95348,95450,95,'Longuesse',49.077208,1.907827);
INSERT INTO ville VALUES(95351,95380,95,'Louvres',49.056073,2.521183);
INSERT INTO ville VALUES(95352,95270,95,'Luzarches',49.115438,2.404169);
INSERT INTO ville VALUES(95480,95620,95,'Parmain',49.124956,2.199155);
INSERT INTO ville VALUES(97115,97129,971,'Lamentin',44.072591,0.277589);
INSERT INTO ville VALUES(97213,97232,972,'Lamentin',44.072591,0.277589);
INSERT INTO ville VALUES(97214,97214,972,'Lorrain',48.640676,9.224794);
INSERT INTO ville VALUES(97362,NULL,973,'Papaichton',999,999);
