Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Custom Shape Maps Unexpected Error

I can find lots of threads where people have this problem, but I can't find one with an actual solution. All I see is people insisting that it works, but it definitely does not work.   When I try t...
Need Help
  • deldersveld's avatar
    deldersveld
    9 years ago

    Ok, I think I might know the potential cause of your issue. When you pulled the file off of GitHub, my guess is that you did not save the actual json file. Instead, you probably right-clicked in the ReadMe and did a Save As on the link to the blob. Is that correct?

     

    GitHub shows a preview of TopoJson, GeoJson, etc. blobs on their own page. Unless you download the entire repo, you need to click through the link and save the Raw json instead of the blob preview.

     

Sean's avatar
Sean
Community Champion
9 years ago

deldersveld I have a question about your us-albers.counties.json file?

 

I can't figure out how to plot the correct county in the correct state?

 

Here is some sample data

These are the 3 most popular county names

(btw these are not all their occurences - I kind of narrowed them down to just the SE/4 of the country)

 

County ColumnFull State NamePopulationCounty NameCounty, StateCounty Word
Jefferson CountyAlabama659,479JeffersonJefferson County, AlabamaCounty
Washington CountyAlabama16,877WashingtonWashington County, AlabamaCounty
Jefferson CountyArkansas73,191JeffersonJefferson County, ArkansasCounty
Lincoln CountyArkansas14,031LincolnLincoln County, ArkansasCounty
Washington CountyArkansas216,410WashingtonWashington County, ArkansasCounty
Jefferson CountyFlorida14,194JeffersonJefferson County, FloridaCounty
Washington CountyFlorida24,624WashingtonWashington County, FloridaCounty
Jefferson CountyGeorgia16,320JeffersonJefferson County, GeorgiaCounty
Lincoln CountyGeorgia7,751LincolnLincoln County, GeorgiaCounty
Washington CountyGeorgia20,676WashingtonWashington County, GeorgiaCounty
Jefferson CountyIndiana32,458JeffersonJefferson County, IndianaCounty
Washington CountyIndiana27,780WashingtonWashington County, IndianaCounty
Jefferson CountyKansas18,813JeffersonJefferson County, KansasCounty
Lincoln CountyKansas3,147LincolnLincoln County, KansasCounty
Washington CountyKansas5,629WashingtonWashington County, KansasCounty
Jefferson CountyKentucky756,832JeffersonJefferson County, KentuckyCounty
Lincoln CountyKentucky24,370LincolnLincoln County, KentuckyCounty
Washington CountyKentucky11,875WashingtonWashington County, KentuckyCounty
Jefferson CountyMississippi7,629JeffersonJefferson County, MississippiCounty
Lincoln CountyMississippi34,810LincolnLincoln County, MississippiCounty
Washington CountyMississippi49,688WashingtonWashington County, MississippiCounty
Jefferson CountyMissouri221,396JeffersonJefferson County, MissouriCounty
Lincoln CountyMissouri53,860LincolnLincoln County, MissouriCounty
Washington CountyMissouri25,172WashingtonWashington County, MissouriCounty
Lincoln CountyNorth Carolina79,740LincolnLincoln County, North CarolinaCounty
Washington CountyNorth Carolina12,722WashingtonWashington County, North CarolinaCounty
Jefferson CountyOklahoma6,432JeffersonJefferson County, OklahomaCounty
Lincoln CountyOklahoma34,351LincolnLincoln County, OklahomaCounty
Washington CountyOklahoma51,577WashingtonWashington County, OklahomaCounty
Jefferson CountyTennessee52,123JeffersonJefferson County, TennesseeCounty
Lincoln CountyTennessee33,633LincolnLincoln County, TennesseeCounty
Washington CountyTennessee125,546WashingtonWashington County, TennesseeCounty
Jefferson CountyTexas252,358JeffersonJefferson County, TexasCounty
Washington CountyTexas34,147WashingtonWashington County, TexasCounty
Washington CountyVirginia54,907WashingtonWashington County, VirginiaCounty
Jefferson CountyWest Virginia55,073JeffersonJefferson County, West VirginiaCounty
Lincoln CountyWest Virginia21,559LincolnLincoln County, West VirginiaCounty

 

In both PBI's regular and filled maps and in the ArcGIS visual you basically use the County, State field and you get this result...

(Note that if you don't use this field you'll get incorrect results!)

 

Now when we go to the topojson file - it would not plot anything using the County, State field

If i use only the County it plot like this - it plots Counties with the same name but in states which are not even included

 

 

Any advice will be much appreciated!

Thanks in advance!

 

dMac314's avatar
dMac314
Frequent Visitor
8 years ago

Sean Did you ever find a solution to this? I am having the same issue.