Geochart uk counties

MarkMark ✭✭
edited February 4, 2019 in Questions
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?

Comments

  • Luzie BaumgartLuzie Baumgart 🛠️ 
    edited January 18, 2019
    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


  • MarkMark ✭✭
    edited January 18, 2019
    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
  • Luzie BaumgartLuzie Baumgart 🛠️ 
    edited January 18, 2019
    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!
  • MarkMark ✭✭
    edited January 18, 2019
    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
  • MarkMark ✭✭
    edited January 21, 2019
    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

  • Luzie BaumgartLuzie Baumgart 🛠️ 
    edited February 4, 2019
    Thanks for sharing, Mark! I will inform our documentation team about it :-)
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!