Forum Discussion

achin1979's avatar
achin1979
Frequent Visitor
4 years ago
Solved

ISO Country Code : Country undefined

I've created a shape map, but it does not recognize Singapore and Taiwan. - Tried ISO Alpha 2 & 3 too. Not successful.
Need Help
  • TomMartens's avatar
    TomMartens
    4 years ago

    Hey achin1979 ,

     

    if I open the global_dot_json inside a text editor, I can't find Singapore if I'm searching for the text "Singapore"

    There is just a fraction for what is necessary to visualize Singapore, Alpha code 2 "SG"

    In contrast this is inside the JSON for Germany

    {
                    "arcs": [
                        [
                            223,
                            224,
                            -221,
                            -44,
                            -163,
                            225,
                            226,
                            -57,
                            227,
                            228,
                            229
                        ]
                    ],
                    "type": "Polygon",
                    "properties": {
                        "name": "Germany",
                        "Alpha-2": "DE"
                    },
                    "id": "DEU"
                },

    And this is SG:

    {
                    "type": null,
                    "properties": {
                        "Alpha-2": "SG",
                        "Alpha-3": "SGP"
                    }
                },

     

    The json file is missing essential information, this is the reason why SG will not be visualized.

     

    Regards,

    Tom

     

  • achin1979's avatar
    achin1979
    4 years ago

    TomMartens Thanks for pointing it out. I've reloaded new json file with arc for those missing countries. It's working now. Thanks a lot! 😉

TomMartens's avatar
TomMartens
Super User
4 years ago

Hey achin1979 ,

 

please take the time and create a pbix file that contains sample data. Upload the file to to onedrive or dropbox and share the link.

Please describe what is your expected result and also mention what map visual you are using.

 

Regards,

Tom

achin1979's avatar
achin1979
Frequent Visitor
4 years ago

A shape map cannot show country locations like Taiwan, Hong Kong, and Singapore.

 

Suspect Hong Kong has returned to China, hence no longer displayed as a country on its own?

Singapore is missing from the Shape map, and Taiwan is not detectable. 

 

 

But all works well with Filled Map which is not something I need. 

TomMartens ,  PBIX file (right click to download) 

  • TomMartens's avatar
    TomMartens
    Super User
    4 years ago

    Hey achin1979 ,

     

    thank you for sharing the file.

    Did you inspect the json file, using a simple text search for Singapore?

    I realized that Singapore is not contained in the countries-110m.json file that you will find here: GitHub - topojson/world-atlas: Pre-built TopoJSON from Natural Earth.

    Maybe this is the same reason with your file.

     

    Hopefully, this provides some new ideas on how to tackle your challenge.

     

    Regards,

    Tom 

    • achin1979's avatar
      achin1979
      Frequent Visitor
      4 years ago

      Thanks, TomMartens 

      I did. Singapore, Hong Kong & Taiwan are all there.  I'm new to json. 

      Is that mean it's not possible to have them & better to change to another type of map?

      global.json 

      • TomMartens's avatar
        TomMartens
        Super User
        4 years ago

        Hey achin1979 ,

         

        if I open the global_dot_json inside a text editor, I can't find Singapore if I'm searching for the text "Singapore"

        There is just a fraction for what is necessary to visualize Singapore, Alpha code 2 "SG"

        In contrast this is inside the JSON for Germany

        {
                    "arcs": [
                        [
                            223,
                            224,
                            -221,
                            -44,
                            -163,
                            225,
                            226,
                            -57,
                            227,
                            228,
                            229
                        ]
                    ],
                    "type": "Polygon",
                    "properties": {
                        "name": "Germany",
                        "Alpha-2": "DE"
                    },
                    "id": "DEU"
                },

        And this is SG:

        {
                    "type": null,
                    "properties": {
                        "Alpha-2": "SG",
                        "Alpha-3": "SGP"
                    }
                },

         

        The json file is missing essential information, this is the reason why SG will not be visualized.

         

        Regards,

        Tom