Geochart uk counties

  • 1
  • Problem
  • Updated 3 months ago
  • In Progress
I'm unable to get the UK Counties to display in the map visualization.

I have:

Map Group: Europe
Map Type: United Kingdom

A simple model with Data, Country and County fields selected on the series tab and using iso 3166 codes in the model

E.g. for Kent I have:

Country: GB
County: GB-KEN
Data: 25

Yet nothing is showing on the map. I have also tried KEN and Kent for the County code but still no joy.

Does anybody have any ideas?
Photo of Mark

Mark

  • 560 Points 500 badge 2x thumb

Posted 4 months ago

  • 1
Photo of Luzie Baumgart

Luzie Baumgart, Official Rep

  • 2,630 Points 2k badge 2x thumb
Hi Mark, I can see Kent on Highcharts' map, so it should be possible. Did you check out their reference for more information? Please see below:
https://www.highcharts.com/maps/demo/all-maps#countries/gb/gb-all
Photo of Mark

Mark

  • 560 Points 500 badge 2x thumb
Hi Luzie,

I can't a list though I've made some headway by looking at the GeoJSON for the map and using the id values e.g. 2354 for North Down and KE for Kent  - matching the names up is going to be somewhat laborious.

Thanks for your help
Photo of Luzie Baumgart

Luzie Baumgart, Official Rep

  • 2,630 Points 2k badge 2x thumb
You're welcome :-) I found more information in our documentation: "Skuid requires 2 digit ISO codes for the Country and State fields."
https://docs.skuid.com/latest/en/skuid/components/ink/visualizations/geochart/#skuid-on-salesforce-u...

If you can use KE for Kent, looks like 2 digit ISO codes are required for County, too. I will inform our docs-team to double check the guideline. Thank you for bringing this to our attention!
Photo of Mark

Mark

  • 560 Points 500 badge 2x thumb
Hi Luzie,

2 digit ISO codes don't actually work - for instance Orkney is Country: GB, County: 3270 whereas Kent is Country: GB, County: KE (the ISO 3166-2 code for Kent is GB-KEN)

When I've created a definitive list from the JSON I grabbed from Highcharts I'll post it
Photo of Mark

Mark

  • 560 Points 500 badge 2x thumb
Hi Luzie,

Here's the list I've managed to extract from the Highcharts GeoJSON - not checked them all mind.

Anglesey,AY
Orkney,3270
Highland,HI
Argyll and Bute,AB
Portsmouth,PS
Eilean Siar/Western Isles,WI
Moyle,MY
Isles of Scilly,7398
Edinburgh,EB
Leicester,LC
Leicestershire,2393
Derbyshire,DB
Derby,DE
Antrim,AN
Ballymena,BL
Nottingham,NG
Devon,DO
Perthshire and Kinross,2458
East Renfrewshire,ER
East Ayrshire,EA
Glasgow,GG
East Dunbartonshire,ED
Inverclyde,IC
North Ayshire,2446
North Lanarkshire,NN
Renfrewshire,RF
South Ayrshire,SA
South Lanarkshire,SL
West Dunbartonshire,WD
Aberdeen,AR
Aberdeenshire,AS
Falkirk,FK
Stirling,ZG
Clackmannanshire,CC
Dundee,DU
Fife,FI
Midlothian,ML
West Lothian,WH
Scottish Borders,BO
Durham,DH
Darlington,DA
Hartlepool,HP
Middlesbrough,MB
Redcar and Cleveland,RC
Stockton-on-Tees,ZT
Hampshire,HA
Southampton,ZH
Monmouthshire,2318
Gloucestershire,GC
Milton Keynes,MK
Buckinghamshire,BU
Bath and North East Somerset,BN
Bristol,BS
North Somerset,NS
South Gloucestershire,SJ
Bournemouth,2389
Dorset,DS
Poole,2391
Hertfordshire,HT
Cambridgeshire,CM
Kingston upon Hull,KH
North East Lincolnshire,NE
Barking and Dagenham,BA
Bexley,XB
Kent,KE
Bromley,BZ
Brent,BE
Camden,CN
Ealing,EG
Enfield,EF
Greenwich,GR
Hammersmith and Fulham,HF
Hounslow,HU
Islington,IT
Kensington and Chelsea,KC
Croydon,CY
Merton,ME
Redbridge,RB
Richmond upon Thames,RU
Sutton,SU
Tower Hamlets,TH
Waltham Forest,WF
Wandsworth,WW
Westminster,WE
Lincolnshire,LI
Belfast,BF
Derry,LD
Newry and Mourne,NM
Armagh,AM
Banbridge,BB
Craigavon,CR
Dungannon,DN
Cookstown,2347
Lisburn,LB
Magherafelt,MF
Omagh,OM
Larne,LR
Carrickfergus,CF
Newtownabbey,NW
North Down,2354
Down,DW
Coleraine,CL
Ballymoney,BY
Castlereagh,CS
Pembrokeshire,PE
Ceredigion,2301
Gwynedd,GD
Shropshire,SP
Powys,PO
Merthyr Tydfil,MT
Bridgend,BJ
Caerphilly,CP
"Rhondda, Cynon, Taff",RT
Cardiff,CA
Vale of Glamorgan,VG
Neath Port Talbot,NP
Swansea,SW
Bolton,7122
Blackburn with Darwen,BW
Lancashire,LA
East Riding of Yorkshire,EY
York,YK
Denbighshire,DI
Flintshire,FL
Wrexham,WX
Blaenau Gwent,BG
Newport,NO
Torfaen,TF
Limavady,LM
Strabane,SB
Fermanagh,FE
North Yorkshire,NY
Plymouth,2420
Torbay,TB
Essex,EX
Norfolk,NF
Brighton and Hove,BH
Havering,HV
Thurrock,TR
Southend-on-Sea,SS
West Sussex,WS
Warwickshire,WR
Hillingdon,HD
Kingston upon Thames,KT
Surrey,SR
East Sussex,ES
Oxfordshire,OX
Swindon,SN
Northamptonshire,NA
Rutland,RL
Hackney,HK
Haringey,HY
Harrow,HR
Lambeth,LT
Lewisham,LW
Newham,NH
Southwark,SQ
Herefordshire,HE
Staffordshire,ST
Worcestershire,WC
Telford and Wrekin,TK
City of London,6338
Northumberland,NB
Newcastle upon Tyne,2367
North Tyneside,7113
South Tyneside,7114
Sunderland,7115
Gateshead,7116
Knowsley,2364
Sefton,7118
Liverpool,7119
Warrington,WT
Merseyside,MS
Blackpool,7117
Kirklees,3265
Calderdale,7130
Bradford,7131
Leeds,7132
Wakefield,7133
Salford,3266
Wigan,7121
Bury,7123
Rochdale,7124
Oldham,7125
Tameside,7126
Stockport,7127
Manchester,7128
Trafford,7129
Cheshire East,2366
Nottinghamshire,NT
Rotherham,3267
Sheffield,7134
Barnsley,7135
North Lincolnshire,NL
Doncaster,7136
Birmingham,2377
Sandwell,7137
Dudley,7138
Wolverhampton,7139
Walsall,7140
Solihull,7141
Coventry,7142
Central Bedfordshire,2381
Bedford,BD
Reading,2388
West Berkshire,7143
Wokingham,7144
Bracknell Forest,7145
Royal Borough of Windsor and Maidenhead,7146
Slough,7147
Barnet,7149
Stoke-on-Trent,SO
Cheshire West and Chester,7150
Halton,7151
Peterborough,PB
Isle of Wight,IW
Moray,MO
Angus,AG
East Lothian,EL
Somerset,SM
Carmarthenshire,CI
Halton,HL
Cornwall,CO
Conwy,CW
Ards,ND
Dumfries and Galloway,DG
Cumbria,CU
Suffolk,SF
Medway,MW
Luton,LU
Wiltshire,WL
Shetland Islands,3271

Photo of Luzie Baumgart

Luzie Baumgart, Official Rep

  • 2,630 Points 2k badge 2x thumb
Thanks for sharing, Mark! I will inform our documentation team about it :-)