none
Map Charts - 5 French 'Départements' not showing RRS feed

  • Question

  • Hi,
    I'm using a map chart in MS Excel for data regarding Sub-Regions called 'Departements' in France. It works like a charm for 91 of the 96, which are correctly filled on the map. However I don't understand what the problem is with the remaining 5: they have the correct geographic data type, there is no disambiguation issue. I have tried with a new document, but the issue remains the same.

    The 5 faulty admin divisions are "Loire-Atlantique","Calvados","Côtes-d'armor", "Meurthe-et-Moselle","Corse-du-Sud". Examples of functional ones at the same admin level include "Vendée","Loiret","Pas-de-Calais","Val-d'Oise","Morbihan","Haute-Corse".


    Sample Data to build map:

    Lot               26 
    Haute-Garonne               20 
    Gironde               17 
    Loire-Atlantique               14 
    Dordogne               10 
    Nord                 9 
    Ille-et-Vilaine                 9 
    Yvelines                 9 
    Corrèze                 9 
    Puy-de-Dôme                 8 
    Rhône                 8 
    Paris                 8 
    Maine-et-Loire                 8 
    Hauts-de-Seine                 8 
    Finistère                 7 
    Vendée                 7 
    Seine-Maritime                 7 
    Morbihan                 7 
    Seine-et-Marne                 7 
    Essonne                 7 
    Bouches-du-Rhône                 7 
    Charente-Maritime                 6 
    Haute-Vienne                 6 
    Pas-de-Calais                 6 
    Hérault                 6 
    Tarn-et-Garonne                 5 
    Aveyron                 5 
    Isère                 5 
    Indre-et-Loire                 5 
    Calvados                 5 
    Côtes-d'Armor                 5 
    Loire                 5 
    Val-de-Marne                 5 
    Tarn                 5 
    Loiret                 5 
    Vienne                 5 
    Lot-et-Garonne                 4 
    Sarthe                 4 
    Oise                 4 
    Val-d'Oise                 4 
    Eure                 4 
    Var                 4 
    Deux-Sèvres                 4 
    Charente                 4 
    Pyrénées-Atlantiques                 4 
    Manche                 4 
    Cantal                 3 
    Haute-Savoie                 3 
    Mayenne                 3 
    Ain                 3 
    Alpes-Maritimes                 3 
    Allier                 3 
    Eure-et-Loir                 3 
    Seine-Saint-Denis                 3 
    Gard                 3 
    Landes                 3 
    Loir-et-Cher                 3 
    Bas-Rhin                 2 
    Saône-et-Loire                 2 
    Indre                 2 
    Somme                 2 
    Cher                 2 
    Aude                 2 
    Moselle                 2 
    Haute-Loire                 2 
    Pyrénées-Orientales                 2 
    Marne                 2 
    Gers                 2 
    Meurthe-et-Moselle                 2 
    Vaucluse                 2 
    Orne                 2 
    Savoie                 2 
    Côte-d'Or                 2 
    Aisne                 2 
    Drôme                 2 
    Doubs                 1 
    Haut-Rhin                 1 
    Yonne                 1 
    Ardèche                 1 
    Creuse                 1 
    Hautes-Pyrénées                 1 
    Aube                 1 
    Vosges                 1 
    Nièvre                 1 
    Jura                 1 
    Ariège                 1 
    Ardennes                 1 
    Lozère                 1 
    Haute-Saône                 1 
    Haute-Marne                 1 
    Alpes-de-Haute-Provence                 1 
    Hautes-Alpes                 1 
    Meuse                 1 
    Haute-Corse                 6 
    Territoire de Belfort                 1 
    Corse-du-Sud                 1 

    Image

    Wednesday, May 6, 2020 10:44 AM

All replies

  • Hi Alex,

    Thank you for reporting this issue.  I have escalated it to the Microsoft Maps team for review.

    UPDATE: I took the data in your post, pasted it in Excel and set the left column to "Geography". I then created a Map Graph with that as the contents and took the snip that I have added to your post above.

    Note: I am also confirming the availability of this data in our dataset as follows:

    Step 1: Go to https://www.bing.com/api/maps/sdk/mapcontrol/isdk/sdsloadmultipleboundaries

    Step 2: Edit the code so it looks for Admin Districts in France

    var map = new Microsoft.Maps.Map(document.getElementById('myMap'), {
        /* No need to set credentials if already passed in URL */
        center: new Microsoft.Maps.Location(47.333000, 1.667000),
        zoom: 6
    });
    //Create an array of locations to get the boundaries of
    var zipCodes = [ "Loire-Atlantique","Calvados","Côtes-d'armor", "Meurthe-et-Moselle","Corse-du-Sud"];
    var geoDataRequestOptions = {
        entityType: 'AdminDivision1',
        getAllPolygons: true
    };
    Microsoft.Maps.loadModule('Microsoft.Maps.SpatialDataService', function () {
        //Use the GeoData API manager to get the boundary
        Microsoft.Maps.SpatialDataService.GeoDataAPIManager.getBoundary(zipCodes, geoDataRequestOptions, map, function (data) {
            if (data.results && data.results.length > 0) {
                map.entities.push(data.results[0].Polygons);
            }
        }, null, function errCallback(callbackState, networkStatus, statusMessage) {
            console.log(callbackState);
            console.log(networkStatus);
            console.log(statusMessage);
        });
    });
    Step 3: I see 4 areas instead of 5 and I think the one that is missing is "Côtes-d'armor"

    So I am not reproducing what you are seeing with my steps but you should be able to edit this part of the code to see the different regions:

    //Create an array of locations to get the boundaries of
    var zipCodes = [ "Loire-Atlantique","Calvados","Côtes-d'armor", "Meurthe-et-Moselle","Corse-du-Sud"];
    var geoDataRequestOptions = {
        entityType: 'AdminDivision2',
        getAllPolygons: true
    };

    Also, if you are just looking to see if there is a polygon at a specific spot in the world, You can use another page of the same interactive site here https://www.bing.com/api/maps/sdk/mapcontrol/isdk/sdsloadsingleboundary and just change the Lat long like Microsoft.Maps.Location(47.333000, 1.667000)

    Sincerely,

    IoTGirl



    Wednesday, May 6, 2020 4:29 PM
    Owner
  • Hello @AlexMelka 

    Did you manage to find a solution? I'm experiencing pretty much the same issue, although for me the only problematic department is "Loire-Atlantique"

    Any information is deeply appreciated :)

    Thanks a lot!

    David




    Thursday, July 23, 2020 9:46 AM
  • Hello,

    I'm trying to chart some data in Excel concerning the French geographical divisions known as "Departéments". I have been careful to assign the correct data type "Geography' to the label column, but for some reason the map chart js simply not displayed for 2 departments: "Loire-Atlantique" and "Côtes d'Armor". Can anyone provide some help with this issue? It's rather urgent :)

    Thanks a lot!

    Thursday, July 23, 2020 9:58 AM