There is no way in geographical data to distinguish between province and municipality

Occasional Contributor

According to Microsoft, it is possible to add geographic data by country, region, province or municipality, but this doesn't work very well in Italy. For example, if I write "Torino" (Turin), it is clearly both the capital of the region, of the province and of the municipality. However while I can get the region data simply by using the term "Piemonte" (Piedmont), there is no way to distinguish between the "Provincia di Torino" (province) and the "Comune di Torino" (municipality). By writing "Torino", only the data of the municipality are provided and if a geographical map is created, only the territory of the municipality will be colored. There is no way to specify that we are interested in the "Provincia di Torino" rather than in the municipality. Writing explicitly "Provincia di Torino" doesn't work.

11 Replies

@Dario_de_Judicibus 

This rich data fields that you can access entirely depend upon what is stored in the online database.  For Italy it appears that the .[Admin Division 2] field is not used.  The province, .[Admin Division 1] field is populated, as is .[Country/region].  The UK uses both, but it is the constituent country that populates Admin Division 1.  In Greece, Athens has one administrative level stored but Sparta has two.  Interestingly New York has no admin data other than United States, so perhaps you should not feel hard done by.

@Peter Bartholomew there is something wrong. We have three administrative regions inside the Italian country: region, province and municipality. You said that AR2 is not used but it should be the municipality and it is definitively used. Instead AR1 is the province and it is not used. So, they did something wrong. Probably used municipality in AR1 instead of province.

@Dario_de_Judicibus 

I am not sure it is wrong or simply following some unstated logic.  The example of New York interested me because it was not reported as being in New York state (state capital Albany).  Maybe it is a case of only using an entity name at one administrative level.

@Dario_de_Judicibus 

It's better to discuss with the sample file. Tool is very sensitive to column names, do you use rich data types or texts, table or range, exact names of the values.

@Sergei Baklan Well, I use location names in my language, of course, but you are right: the tool is very sensible to texts in some unpredictable way. For example, if I write:

 

Dario_de_Judicibus_0-1669114385388.png

and I select them as geographical data, I get
Dario_de_Judicibus_1-1669114454046.png

It looks like "Inghilterra" (i.e. England) is not recognized. Same for "Spagna" (i.e. Spain). What's fun is that if I write

Dario_de_Judicibus_2-1669114603786.png

and set them as geographical data, I get

Dario_de_Judicibus_3-1669114674292.png

in Italian language! So, quite hard to understand the logics of that piece of software!

 

 

 

 

 

 

@Dario_de_Judicibus 

At least partly logic is on AI site, human being sometimes have another one.

In addition to column names try plain texts instead of data types in values. Based on my experience in many cases texts work better.

You cannot create a map chart by plain text. You have to tell Excel that those labels refer to geographic areas.

@Dario_de_Judicibus 

I found some other entities, but there appears to be no relationship that says Turin is part of its metropolitan area.

image.png

@Dario_de_Judicibus 

Map Charts cares more about column names, not about data types

image.png

@Sergei Baklan Well, it looks like I can get better results if I use headers. I wasn't aware of this aspect.

 

Dario_de_Judicibus_0-1669199874447.png

It is not yet all automatic, that is, some manual selection is still necessary, but it works better. 

Thank you, Sergei.

@Dario_de_Judicibus 

Yes, column names is the most critical part in using this tool. However, I'd compare results wit and without data types.