{"id":3495,"date":"2018-03-09T19:46:46","date_gmt":"2018-03-09T18:46:46","guid":{"rendered":"http:\/\/www.blue-bears.com\/blog\/?p=3495"},"modified":"2018-03-09T21:46:47","modified_gmt":"2018-03-09T20:46:47","slug":"dune-adresse-vers-des-coordonnees-api-google-map-mysql-php-xml","status":"publish","type":"post","link":"http:\/\/www.blue-bears.com\/blog\/?p=3495","title":{"rendered":"D&rsquo;une adresse vers des Coordonn\u00e9es : API Google Map MYSQL\/PHP\/XML Geocoding"},"content":{"rendered":"<h3>Google Map :<\/h3>\n<p>Tuto import de donn\u00e9es de MYSQL dans une Map avec PHP et Javascript;<\/p>\n<p><a href=\"https:\/\/developers.google.com\/maps\/documentation\/javascript\/mysql-to-maps?hl=fr\">https:\/\/developers.google.com\/maps\/documentation\/javascript\/mysql-to-maps?hl=fr<\/a><\/p>\n<p>Les coordonn\u00e9es semblent requises =&gt; utiliser l&rsquo;API de geocoding pour r\u00e9cup\u00e9rer celles-ci.<\/p>\n<p><!--more--><\/p>\n<p>D\u00e9marrage :<a href=\"https:\/\/developers.google.com\/maps\/documentation\/geocoding\/start?hl=FR\">https:\/\/developers.google.com\/maps\/documentation\/geocoding\/start?hl=FR<\/a><\/p>\n<p>Guide utilisateur : <a href=\"https:\/\/developers.google.com\/maps\/documentation\/geocoding\/intro?hl=FR\">https:\/\/developers.google.com\/maps\/documentation\/geocoding\/intro?hl=FR<\/a><\/p>\n<ul>\n<li>Sous compte Gmail VDFT \/\/ <span class=\"p6n-snippet-overflow-hidden p6n-snippet-key-selector-container p6n-snippet-container p6n-snippet-focused\" tabindex=\"0\">AIzaSyCgb5fsAJCV7ztg9vmCy-J3Y9cxvEILwkI<\/span><\/li>\n<li>Modifier les param\u00e8tres de la cl\u00e9 : <a href=\"https:\/\/console.developers.google.com\/projectselector\/apis\/credentials?hl=FR&amp;supportedpurview=project\">https:\/\/console.developers.google.com\/projectselector\/apis\/credentials?hl=FR&amp;supportedpurview=project<\/a><\/li>\n<\/ul>\n<p>Exemple XML avec l&rsquo;adresse :<\/p>\n<p><a href=\"https:\/\/maps.googleapis.com\/maps\/api\/geocode\/xml?address=10+rue+de+la+cle+des+champs,60560,FR&amp;key=AIzaSyCgb5fsAJCV7ztg9vmCy-J3Y9cxvEILwkI\">https:\/\/maps.googleapis.com\/maps\/api\/geocode\/xml?address=10+rue+de+la+cle+des+champs,60560,FR&amp;key=AIzaSyCgb5fsAJCV7ztg9vmCy-J3Y9cxvEILwkI<\/a><\/p>\n<p>marche aussi au format JSON avec<\/p>\n<p><a href=\"https:\/\/maps.googleapis.com\/maps\/api\/geocode\/json?address=10+rue+de+la+cle+des+champs,60560,FR&amp;key=AIzaSyCgb5fsAJCV7ztg9vmCy-J3Y9cxvEILwkI\">https:\/\/maps.googleapis.com\/maps\/api\/geocode\/json?address=10+rue+de+la+cle+des+champs,60560,FR&amp;key=AIzaSyCgb5fsAJCV7ztg9vmCy-J3Y9cxvEILwkI<\/a><\/p>\n<ul>\n<li>Le syst\u00e8me est assez tol\u00e9rant au niveau de l&rsquo;adresse. En cas d\u2019ambigu\u00eft\u00e9 il renvoie les possibilit\u00e9s les plus coh\u00e9rentes (9 max ?) .<\/li>\n<li>Un bon formatage : Num\u00e9ro+rue,code postale,nom de ville,pays (code ISO 2 lettres)<\/li>\n<li>Les espaces sont remplac\u00e9s par des plus (+);<\/li>\n<li>Des virgules s\u00e9parent les champs<\/li>\n<\/ul>\n<h3>Openstreet Map :<\/h3>\n<p><a href=\"https:\/\/wiki.openstreetmap.org\/wiki\/Nominatim\">https:\/\/wiki.openstreetmap.org\/wiki\/Nominatim<\/a><\/p>\n<p>ne trouve pas \u00ab\u00a0cl\u00e9 des champs\u00a0\u00bb mais \u00ab\u00a0clef des champs\u00a0\u00bb<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Map : Tuto import de donn\u00e9es de MYSQL dans une Map avec PHP et Javascript; https:\/\/developers.google.com\/maps\/documentation\/javascript\/mysql-to-maps?hl=fr Les coordonn\u00e9es semblent requises =&gt; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-3495","post","type-post","status-publish","format-standard","hentry","category-informatique"],"_links":{"self":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3495"}],"version-history":[{"count":5,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3495\/revisions"}],"predecessor-version":[{"id":3500,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3495\/revisions\/3500"}],"wp:attachment":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3495"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}