ISO Country Code : Country undefined

[achin1979]

I've created a shape map, but it does not recognize Singapore and Taiwan.

- Tried ISO Alpha 2 & 3 too. Not successful.

[TomMartens · Accepted solution]

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

[TomMartens]

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]

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]

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]

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 · Accepted solution]

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 · Accepted solution]

@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]

Hey @achin1979 ,

if it's a public JSON file you might consider adding the source as it will happen others as well. If you created the arcs yourself, consider providing a short description of how you did it, e.g. using qGIS

Regards,

Tom