{"id":30118,"date":"2015-11-30T16:16:22","date_gmt":"2015-11-30T16:16:22","guid":{"rendered":"https:\/\/www.anciens-aerodromes.com\/?p=30118"},"modified":"2017-12-14T11:11:36","modified_gmt":"2017-12-14T11:11:36","slug":"30118","status":"publish","type":"post","link":"https:\/\/www.anciens-aerodromes.com\/?p=30118","title":{"rendered":"# Table des data pour le projet MSI"},"content":{"rendered":"<p><strong>Premi\u00e8re livraison de donn\u00e9es brutes ATLAS 01 &#8211; SOMME<\/strong><\/p>\n<h3><strong>1 &#8211; Table des QR CODES (4)<\/strong>\u00a0 (7 champs) :<br \/>\n<strong>Structure :<\/strong> Atlas;Num\u00e9ro;Nom;LienSite;Localisation;LienLocal;Audio<\/h3>\n<p><a href=\"https:\/\/www.anciens-aerodromes.com\/upload\/bigdata\/CLASSEURSOMMECONVERTIOKEXPORT.csv\"><em><strong>Liens vers le .CSV<\/strong><\/em><\/a><\/p>\n<h3><strong>2 &#8211; Tables des Contenus_Fiches<\/strong> (14 champs) :<br \/>\n<strong>Structure :<\/strong><br \/>\nIdentifiant;Pays;D\u00e9partement;Nom;Autre appellation Commune(s);Coordonn\u00e9es;OACI;Situation;Utilisation; Sources;Cartographie;Occupations successives du Terrain;Fiche mise \u00e0 jour<\/h3>\n<p>Lien vers le .csv\u00a0<a href=\"https:\/\/www.anciens-aerodromes.com\/upload\/bigdata\/CONVERSIONCONTENUS FICHESTERRAINS.csv\">CONVERSIONCONTENUS FICHESTERRAINS.csv<\/a><\/p>\n<p>Vous acc\u00e9derez \u00e0 cette s\u00e9lection de donn\u00e9es pertinentes pour votre application. Sous forme de .csv, comme ci-dessus, ou sous forme de tables SQL sur nos serveurs. Avant d&rsquo;enregistrer celles-ci, il conviendra de valider la structure des donn\u00e9es, leur r\u00e9partitions en tables et d&rsquo;en v\u00e9rifier les diff\u00e9rents nommages, compatibles avec l&rsquo;application cibl\u00e9e.<\/p>\n<h3>3 &#8211; Connexion \u00e0 la table SQL<\/h3>\n<p style=\"margin: 0in; font-family: Calibri; font-size: 11.0pt;\"><strong>AdresseTable<\/strong> sv126335.nfrance.com<\/p>\n<p style=\"margin: 0in; font-family: Calibri; font-size: 11.0pt;\"><strong>TableName<\/strong> = v1009b<\/p>\n<p style=\"margin: 0in; font-family: Calibri; font-size: 11.0pt;\"><strong>ID<\/strong> = MasterMsi<\/p>\n<p style=\"margin: 0in; font-family: Calibri; font-size: 11.0pt;\"><strong>PW<\/strong> = mBxS37TuTstNKHpE<\/p>\n<p>&nbsp;<\/p>\n\n<table id=\"tablepress-1740\" class=\"tablepress tablepress-id-1740\">\n<thead>\n<tr class=\"row-1\">\n\t<td class=\"column-1\"><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td><td class=\"column-4\"><\/td><td class=\"column-5\"><\/td>\n<\/tr>\n<\/thead>\n<tbody class=\"row-striping\">\n<tr class=\"row-2\">\n\t<td class=\"column-1\"><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td><td class=\"column-4\"><\/td><td class=\"column-5\"><\/td>\n<\/tr>\n<tr class=\"row-3\">\n\t<td class=\"column-1\"><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td><td class=\"column-4\"><\/td><td class=\"column-5\"><\/td>\n<\/tr>\n<tr class=\"row-4\">\n\t<td class=\"column-1\"><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td><td class=\"column-4\"><\/td><td class=\"column-5\"><\/td>\n<\/tr>\n<tr class=\"row-5\">\n\t<td class=\"column-1\"><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td><td class=\"column-4\"><\/td><td class=\"column-5\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- #tablepress-1740 from cache -->\n","protected":false},"excerpt":{"rendered":"<p>Premi\u00e8re livraison de donn\u00e9es brutes ATLAS 01 &#8211; SOMME 1 &#8211; Table des QR CODES (4)\u00a0 (7 champs) : Structure : Atlas;Num\u00e9ro;Nom;LienSite;Localisation;LienLocal;Audio Liens vers le .CSV 2 &#8211; Tables des Contenus_Fiches (14 champs) : Structure : Identifiant;Pays;D\u00e9partement;Nom;Autre appellation Commune(s);Coordonn\u00e9es;OACI;Situation;Utilisation; Sources;Cartographie;Occupations&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"https:\/\/www.anciens-aerodromes.com\/?p=30118\">Lire la suite &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[308],"tags":[],"class_list":["post-30118","post","type-post","status-publish","format-standard","hentry","category-6-0-academic"],"_links":{"self":[{"href":"https:\/\/www.anciens-aerodromes.com\/index.php?rest_route=\/wp\/v2\/posts\/30118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.anciens-aerodromes.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.anciens-aerodromes.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.anciens-aerodromes.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.anciens-aerodromes.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=30118"}],"version-history":[{"count":0,"href":"https:\/\/www.anciens-aerodromes.com\/index.php?rest_route=\/wp\/v2\/posts\/30118\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.anciens-aerodromes.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=30118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.anciens-aerodromes.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=30118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.anciens-aerodromes.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=30118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}