EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

Mapbox region namings spelling from config files


Robert Prochowicz

Manager, Sales Engineering • MicroStrategy


In order to properly display data on Mapbox map you need to match the region names you are using with the names that Mapbox is using. You can retrieve the names from Mapbox config files.

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
In order to properly display data on Mapbox map you need to match the region names you are using with the names that Mapbox is using. It is important since you might use different spelling than Mapbox and as a result your regions will not be shown on the map.
The format of those file is a nested JSON, which can be difficult to use. For example you cannot import them into Strategy dossier (each region will be imported as a separate attribute).
Attached Python file will transform nested JSON into flat, easy to use CSV file.
Attached zip file contains already flatten files from a0 to a3.
Example from a2.json


code_ID,name,name_ascii,bounds,parent_0,parent_1,parent_2
USA247075,Haywood,--,[-89.503_ 35.397_ -89.07_ 35.823],US,USA147,--
ROA2032768,Budeşti,Budesti,[24.178_ 46.775_ 24.292_ 46.893],RO,ROA106,--
THA27209,อู่ทอง,U Thong,[99.792_ 14.217_ 99.98_ 14.632],TH,THA172,--
ROA2155154,Uda-Clocociov,--,[24.662_ 43.851_ 24.791_ 43.944],RO,ROA134,--
PRA27210155140,Morovis,--,[-66.411_ 18.324_ -66.405_ 18.328],PR,PRA172101,--
MNA21803,Давст,Davst,[91.667_ 50.298_ 93.028_ 50.885],MN,MNA118,--
BHA2515,الغينة,Algainah,[50.578_ 25.945_ 50.606_ 26.009],BH,BHA15,--
VEA20306,Guanta,--,[-64.627_ 10.178_ -64.487_ 10.257],VE,VEA103,--
THA24204,ปากชม,Pak Chom,[101.78_ 17.635_ 102.116_ 18.217],TH,THA142,--

 


Comment

0 comments

Details

Example

Published:

October 26, 2018

Last Updated:

March 21, 2024