Forum Discussion
Maps Data for Scotland
NFPChris it also appears to respond to Forfarshire. West Dunbartonshire is proving impossible, however. I've tried everything I can think of, in English, Scots and Gaelic.
Thank you for the replies. Thanks SergeiBaklan for bringing in reinforcements! I have now added the question to Answers. I couldn't find an appropriate blog to contact an author though.
Thanks for trying Noel Slevin , Forfarshire seems to replace Angus which would make sense.
Thanks Smitty Smith , unfortunately I don't seem to be able to access Data Types. I'm using Office 365 Pro Plus and have just done an update but I still don't have these options. It sounds like it's the same problem if it's plotting all but East Ayrshire though, seems bizarre that it'd be a different Local Authority that'd cause the problem. From your original post regarding the counties and greater confidence I do know from checking that the 31/32 that I do now have plotted are correct and the missing piece of the jigsaw is exactly where West Dunbartonshire lies.
I didn't find here Smitty Smith post about geography data type, perhaps it was deleted. I tried West Dunbartonshire with geography data type as well, that didn't help.
- Smitty Smith
Microsoft
Chris/Sergei,
[quote]I didn't find here @Smitty Smith post about geography data type, perhaps it was deleted. [quote]
Sorry about that. I posted a solution from the Excel team with data types, but it turns out there were some issues that need to be addressed, so I deleted it.
They went back to the drawing board, and were able to come up with good results with normal text by adding a Country/UK column to aid with disambiguation, then mapping Scottish Councils with "County" for the Council column, and "Province" header for Scotland. There's a hangup with West Dumbartonshire, but that's been sent to the Bing team to investigate. It should be fixed and in production in a few weeks.
And here's a link to the new workbook: ScotlandCouncils.xlsx
Thanks for the interesting scenario! It's definitely going to help with geography data type definitions.
Smitty
- Whoop! Thanks again guys.
I'll leave Data Types for another day :D
- Smitty Smith
Chris/Sergei,
{quote}I didn't find here @Smitty Smith post about geography data type, perhaps it was deleted. {quote}
Sorry about that. I posted a solution from the Excel team with data types, but it turns out there were some issues that need to be addressed, so I deleted it.
They went back to the drawing board, and were able to come up with good results with normal text by adding a Country/UK column to aid with disambiguation, then mapping Scottish Councils with "County" for the Council column, and "Province" header for Scotland. There's a hangup with West Dumbartonshire, but that's been sent to the Bing team to investigate. It should be fixed and in production in a few weeks.
And here's a link to the new workbook: ScotlandCouncils.xlsx
Thanks for the interesting scenario! It's definitely going to help with geography data type definitions.
Smitty
Hi Smitty,
Thank you for this update. Yes, Map Charts is quite sensitive to column names, but not only. Sometimes it's enough to rename the place like County of Stirling instead of Stirling (what Chris did). Sometimes order of records matters.
On the other hand it could ignore such dancing with names, e.g. I removed UK column and renamed Scotland to State - result is exactly the same (second sheet attached)
However, whatever we do West Dunbartonshire remains the black hole.
