laradb

script pour établir une bdd Ãà partir d'un tsv avec différent format - retour accueil

git clone git://bebou.netlib.re/laradb
Log | Files | Refs |

cities.tsv (2261B)

      1 ville	json	lat-lon
      2 	lat:"null", lon:"null"	
      3 Aix-en-Provence	lat:"43.5298424", lon:"5.4474738"	
      4 Aix-en-Provence, Bron-Parilly, Paris	lat:"43.5298424", lon:"5.4474738"	
      5 Aix-en-Provence, Lille	lat:"43.5298424", lon:"5.4474738"	
      6 Alkmaar	lat:"52.600853799999996", lon:"4.817099446443963"	
      7 Amstelveen	lat:"52.3028209", lon:"4.8596844"	
      8 Amsterdam	lat:"52.3730796", lon:"4.8924534"	
      9 Angers, Poitiers, Tours	lat:"47.4739884", lon:"-0.5515588"	
     10 Arnhem	lat:"51.984257", lon:"5.9108573"	
     11 Assen	lat:"52.9952273", lon:"6.560498"	
     12 Besançon	lat:"47.2380222", lon:"6.0243622"	
     13 Bordeaux	lat:"44.841225", lon:"-0.5800364"	
     14 Breda	lat:"51.5887845", lon:"4.7760237"	
     15 Bruxelles	lat:"50.8465573", lon:"4.351697"	
     16 Champigny-sur-Marne	lat:"48.8137759", lon:"2.5107384"	
     17 City	lat:"-37.8141705", lon:"144.9655616"	
     18 Den Bosch	lat:"68.5727778", lon:"18.0863889"	
     19 Eindhoven	lat:"51.4392648", lon:"5.478633"	
     20 Essone	lat:"48.604471", lon:"2.4750088"	
     21 Genève	lat:"46.2017559", lon:"6.1466014"	
     22 Grenoble	lat:"45.1875602", lon:"5.7357819"	
     23 Grenoble?, Lyon?	lat:"45.1875602", lon:"5.7357819"	
     24 Groningen	lat:"53.2190652", lon:"6.5680077"	
     25 Hilversum	lat:"52.2241375", lon:"5.1719396"	
     26 La Garenne-Colombes	lat:"43.9154619", lon:"6.8911826"	
     27 Lausanne, Paris	lat:"46.5218269", lon:"6.6327025"	
     28 Leiden	lat:"52.1594747", lon:"4.4908843"	
     29 Lelystad	lat:"52.536680950000004", lon:"5.361043525412799"	
     30 Lyon	lat:"45.7578137", lon:"4.8320114"	
     31 Maastricht	lat:"50.8512438", lon:"5.6909768"	
     32 Marseille	lat:"43.2961743", lon:"5.3699525"	
     33 Marseille?, Nantes?	lat:"43.2961743", lon:"5.3699525"	
     34 Middelburg	lat:"51.4996784", lon:"3.6137371"	
     35 Montréal	lat:"45.5031824", lon:"-73.5698065"	
     36 Montreuil	lat:"50.4638918", lon:"1.7631125"	
     37 Nijmegen	lat:"51.842574850000005", lon:"5.838960628748229"	
     38 Paris	lat:"48.8588897", lon:"2.3200410217200766"	
     39 Paris?	lat:"48.8588897", lon:"2.3200410217200766"	
     40 Québec	lat:"46.8137431", lon:"-71.2084061"	
     41 Rennes	lat:"48.1113387", lon:"-1.6800198"	
     42 Rotterdam	lat:"51.9244424", lon:"4.47775"	
     43 Saint-Denis	lat:"48.935773", lon:"2.3580232"	
     44 Tilburg	lat:"51.58561845", lon:"5.0660616131367675"	
     45 Toulouse	lat:"43.6044622", lon:"1.4442469"	
     46 Tunis	lat:"36.8002068", lon:"10.1857757"	
     47 Utrecht	lat:"52.080985600000005", lon:"5.12768396945229"	
     48 Vlissingen	lat:"51.4480929", lon:"3.5697992"