{"id":9393,"date":"2026-03-10T16:59:34","date_gmt":"2026-03-10T16:59:34","guid":{"rendered":"https:\/\/planifeducation.gouv.tg\/dpsse\/?page_id=9393"},"modified":"2026-03-12T13:43:28","modified_gmt":"2026-03-12T13:43:28","slug":"localisation-des-iepp-et-dre","status":"publish","type":"page","link":"https:\/\/planifeducation.gouv.tg\/dpsse\/localisation-des-iepp-et-dre\/","title":{"rendered":"Localisation des IEPP et DRE"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"9393\" class=\"elementor elementor-9393\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-15c8a0a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"15c8a0a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2d36c66\" data-id=\"2d36c66\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-40e707d elementor-widget__width-initial elementor-widget elementor-widget-html\" data-id=\"40e707d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<link rel=\"stylesheet\" href=\"https:\/\/unpkg.com\/leaflet@1.9.4\/dist\/leaflet.css\" \/>\r\n<script src=\"https:\/\/cdn.sheetjs.com\/xlsx-latest\/package\/dist\/xlsx.full.min.js\"><\/script>\r\n\r\n<style>\r\n  #map { height: 600px; width: 100%; border-radius: 8px; z-index: 1; }\r\n  .loading-overlay { position: absolute; background: rgba(255,255,255,0.8); z-index: 1000; padding: 20px; border-radius: 5px; top: 50%; left: 50%; transform: translate(-50%, -50%); display: none; }\r\n  \/* Style pour le panneau de contr\u00f4le Leaflet *\/\r\n  .leaflet-control-layers-list { padding: 5px; font-family: sans-serif; }\r\n<\/style>\r\n\r\n<div style=\"position: relative;\">\r\n    <div id=\"loading\" class=\"loading-overlay\">Chargement de la carte...<\/div>\r\n    <div id=\"map\"><\/div>\r\n<\/div>\r\n\r\n<script src=\"https:\/\/unpkg.com\/leaflet@1.9.4\/dist\/leaflet.js\"><\/script>\r\n\r\n<script>\r\n  const FILE_URL = 'https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vTsetvAGqILc9nOvNABcKbt95pTgIdvUK-ko43A6ylpK9li9sjNntauGDBaw8WMPQ\/pub?gid=672350568&single=true&output=csv';\r\n\r\n  const couleursRegion = {\r\n    \"DRE GRAND LOME\": \"red\",\r\n    \"DRE MARITIME\": \"blue\",\r\n    \"DRE PLATEAUX EST\": \"brown\",\r\n    \"DRE PLATEAUX OUEST\": \"yellow\",\r\n    \"DRE CENTRALE\": \"orange\",\r\n    \"DRE KARA\": \"purple\",\r\n    \"DRE SAVANES\": \"green\"\r\n  };\r\n\r\n  var map = L.map('map').setView([8.6195, 0.8248], 7);\r\n  L.tileLayer('https:\/\/{s}.tile.openstreetmap.org\/{z}\/{x}\/{y}.png', {\r\n    attribution: '\u00a9 OpenStreetMap'\r\n  }).addTo(map);\r\n\r\n  \/\/ Objet pour stocker les groupes de marqueurs par r\u00e9gion\r\n  const layerGroups = {};\r\n\r\n  async function loadCsvData() {\r\n    const loadingEl = document.getElementById('loading');\r\n    loadingEl.style.display = 'block';\r\n\r\n    try {\r\n      const response = await fetch(FILE_URL);\r\n      const text = await response.text();\r\n      const workbook = XLSX.read(text, { type: 'string' });\r\n      const jsonData = XLSX.utils.sheet_to_json(workbook.Sheets[workbook.SheetNames[0]], { defval: \"\" });\r\n      \r\n      let lastRegion = \"INCONNUE\";\r\n\r\n      jsonData.forEach(row => {\r\n        let lat = parseFloat(String(row.LATITUDE).replace(',', '.').trim());\r\n        let lng = parseFloat(String(row.LONGITUDE).replace(',', '.').trim());\r\n        \r\n        if (row.REGIONS && row.REGIONS.trim() !== \"\") {\r\n          lastRegion = row.REGIONS.trim().toUpperCase();\r\n        }\r\n        \r\n        let region = lastRegion;\r\n        let nom = row[\"Chef lieu\"] || \"IEPP Sans Nom\";\r\n        let nb_ecoles = row[\"nb_ecoles\"] || \"Pas d'\u00e9tablissement\";\r\n\r\n        console.log(nb_ecoles);\r\n        if (!isNaN(lat) && !isNaN(lng)) {\r\n          \/\/ Si le groupe de calque pour cette r\u00e9gion n'existe pas encore, on le cr\u00e9e\r\n          if (!layerGroups[region]) {\r\n            layerGroups[region] = L.layerGroup().addTo(map);\r\n          }\r\n\r\n          L.circleMarker([lat, lng], {\r\n            color: couleursRegion[region] || \"black\",\r\n            fillColor: couleursRegion[region] || \"black\",\r\n            fillOpacity: 0.7,\r\n            radius: 7\r\n          })\r\n          .bindPopup(`<b>${nom}<\/b><br>R\u00e9gion: ${region}<\/b><br>Nombre d'\u00e9tablissements: ${nb_ecoles}`)\r\n          .addTo(layerGroups[region]);\r\n        }\r\n      });\r\n\r\n      \/\/ Ajout du s\u00e9lecteur de couches (Menu pour filtrer par r\u00e9gion)\r\n      L.control.layers(null, layerGroups, { collapsed: false }).addTo(map);\r\n\r\n      loadingEl.style.display = 'none';\r\n    } catch (error) {\r\n      console.error(\"Erreur :\", error);\r\n      loadingEl.innerHTML = \"Erreur de chargement.\";\r\n    }\r\n  }\r\n\r\n  loadCsvData();\r\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Chargement de la carte&#8230;<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":"","footnotes":""},"class_list":["post-9393","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/planifeducation.gouv.tg\/dpsse\/wp-json\/wp\/v2\/pages\/9393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/planifeducation.gouv.tg\/dpsse\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/planifeducation.gouv.tg\/dpsse\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/planifeducation.gouv.tg\/dpsse\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/planifeducation.gouv.tg\/dpsse\/wp-json\/wp\/v2\/comments?post=9393"}],"version-history":[{"count":16,"href":"https:\/\/planifeducation.gouv.tg\/dpsse\/wp-json\/wp\/v2\/pages\/9393\/revisions"}],"predecessor-version":[{"id":9410,"href":"https:\/\/planifeducation.gouv.tg\/dpsse\/wp-json\/wp\/v2\/pages\/9393\/revisions\/9410"}],"wp:attachment":[{"href":"https:\/\/planifeducation.gouv.tg\/dpsse\/wp-json\/wp\/v2\/media?parent=9393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}