World map not showing state level

[Tanmay14]

Hi,

I need some help with map report. I have created a Map report to show the incidents by caller’s location. I defined a 3-level map source record. Level 1 is caller location country; Level 2 is caller location state and Level 3 is caller location city. All the locations have latitude and longitude.

For all incidents created in the US, I can drill down in an expected manner of country > state/region > city.

Somehow this is not working for incidents raised in UK. Upon clicking on country UK, I am directly taken to London city level

Country level (England) :

When I click on this number, I am directly taken to city level (London) instead of region level:

I have 3 location mappings for UK under 'Mapping groups' table:

I noticed that there is no record for UK in Report Maps (sys_report_map) table. For USA we have 51 record, one for each state I believe. Example of one record for the state of Alabama:

Is the reason for UK not drilling down to state/region level this missing Report Maps record for Level 3 for the London Region? if yes, how do I get this JSON definition for all the regions of UK or any other country?

Also, I see below warning on the map report, not sure what us causing this:

Thanks

[Haustin Kimbrou]

Interested in this as well. Specifically adding a sys_report_map record and obtaining that JSON. I noticed at the top of the JSON it references:
"version":"1.1.2","type":"FeatureCollection","copyright":"Copyright (c) 2015 Highsoft AS, Based on data from Natural Earth","copyrightShort":"Natural Earth","copyrightUrl":"http://www.naturalearthdata.com"

Going to this site increased my detective skill level, but did nothing for helping find the JSON there.

[ab-hsbc]

Correct - the UK counties are not mapped at the same level as states in the USA or Canada, Netherlands.

There's a website called Highmaps which has the JSON containing the UK along with the county boundaries. Whilst this is better than what's there as standard in SN, it's got gonna help you much. Basically, you need a JSON file for every county and then a new data row for every county to contain it. That way it'll work just like the USA/Canada map does.

On the plus side, there's breakdowns for France, Germany, Norway if that's your fancy. No UK counties though...

https://code.highcharts.com/mapdata/countries/gb/gb-all.geo.json

https://code.highcharts.com/mapdata/countries/gb/gb-all.geo.json

[ab-hsbc]

PS

The error..............no idea why it does this but even if all of your ACTIVE users are filtered and they all inhabit a location which contains GPS data, the report shows you a list of locations that are not inhabited and are missing GPS data.