Skip to main content

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?

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



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


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!


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


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


Thanks for sharing, Mark! I will inform our documentation team about it 🙂


Reply