Regions and Provinces in Maps

[Oslo_Qlik]

Hi all.
We are working with Qlik Sense Maps and we need to put un a map Italian regions, provinces and ZIP codes.

We also need to control how data are used from Qlik Sense.

We have found that there are .qvd files with cities and countries; is there something similar for other geo-info? Where are they stored? Can they be manipulated to fix or integrate them?

Thank you very much in advance

[Lisa_P]

If you are using the SaaS edition of Qlik you can do Geo-operations to request this information using the load script and then you could store to .qvd files and use in other apps.

Good tutorials can be found in help.qlik.com here:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Global_Common/GeoOperationsFunctio... 

And an excerpt below ...

GeoOperations functions return fields. By default, all fields are returned and included. You can precede GeoOperations functions with a SELECT statement to select and optionally rename specific fields in which you are interested. For example, this script uses SELECT to load only two of the postal code fields from the location service:

Load * Extension GeoOperations.ScriptEval('

SELECT Name as PostalCode, LocationArea FROM

Load() DATASOURCE PostalCodes LOCATIONSERVICE type="PostalCode", country="se"');

[Oslo_Qlik]

Hi Lisa
Thank you very much for your answer!
Unfortunately we have Qlik Sense Enterprise Edition, with no GeoAnalytics Extension (maybe, in future!) so I can not follow your approach.
At the moment, I need a more simple thing.
If I want to create a map with Italian regions (the same goes for the provinces) I can use Region Field with values as LOMBARDIA, PIEMONTE and they are correctly drawn on the map.
I would like to know how Qlik Sense does the association between Region Name and Region Polygon.
I would like to edit/modify the association - as Qlik does for cities or countries in __country/cityGeoBase and __country/cityAliasesBase - to solve the problem of regions with compound names which could be written in different ways (EMILIA ROMAGNA, EMILIA-ROMAGNA, ...).
Thank you very much in advance!

[Lisa_P]

One way to solve this is to capture the other ways of spelling the different Region names and use the mapping table lookup to fix this. You will need to create a mapping table with two colums, BadName, GoodName then lookup the region name when you load in the data and replace with the GoodName that gets a result i the map.

There is as example in help doing a similar thing for US/USA etc. https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/data-cleansing... 

Hope this helps.

[Oslo_Qlik]

Hi Lisa_P
Thank you for your answer which it could solve one of my problems, but I would like to know anything more about how Qlik Sense EE manage geo data.
I have found that for City and Country it uses some .qvd files (__city/countryBase/Alias), but what about Regions, Provinces? From which source does it take information? Where does it sotre them?
Another thing, for Italy I experimented that it recognises ISTAT code for City. Where can I found the list? At what time are they refreshed. I see that in my version a town which was modified in 2028 is not recognized...
Is there some detailed documentation about how do maps work in Qlik Sense?
Thank you

[joostvanegmond7]

Hi! 

It is easy load all the association of polygons and names via the Load operation in Qlik CLoud or GeoAnalytcis. I performed a load operation following below instructions for Adminsitrative Region 3 in Italy:

https://community.qlik.com/t5/Qlik-Sense-Documents/How-to-improve-the-lookup-accuracy/ta-p/1553461

You'll find the results in attached file. Is this what you want? 

[Oslo_Qlik]

Thanks, but it is not exactly what I want.
First of all I'm using Qlik Sense EE with no Geo Analytics, then my actual problem is to be aware of what Qlik Sene shows in maps.
As I told before, I can show on a map Italian City/Town by ISTAT Code, but I don't know which code are shown and which are not, what ie tre reason why Code1 is shown and Code2 is not.
I am asking for to know how and where Qlik manage this information.
I know there are qvd about cities and countries and I can check if a city is listed or not (and I see that little town I need to show are not listed, hence the idea of ​​using ISTAT Codes which offer greater coverage), but I can not know when these lists are refreshed.
I need to be more aware about my geo data.

[joostvanegmond7 · Accepted solution]

Hi Oslo, I understand what you need. The data Qlik Sense uses for mapping cities, countries and ISTAT codes etc is probably coming from Telematica. Yet, I don't know more about which data exactly and when it is published.

[Oslo_Qlik]

Another question about maps...
What kind of sources does Qlik use in building maps and for which purpose?
I mean... I know that Qlik reads data fron its internal qvd (city/countryAliases.qvd, city/countryGeo.qvd), Joostvanegmond7 tells me that Telematica is used, too and then on maps themselves I see openStreetMaps "logo"...
How does Qlik handle this information?
In which case use qvd, in which other sources...
I don't understand and it is a problem in choosing the best way to show my information.
If I need to visualize City and Town, I need to display all cities, not just those with more than 15.000 inhabitants. Empirically I have seen that using the ISTAT code gives me a higher coverage than using the names of the cities/countries, but what is the update date of these codes?