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! 😉

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

       

      • achin1979's avatar
        achin1979
        Frequent Visitor
        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! 😉