Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
saj
Helper III
Helper III

ArcGIS map preview - UK census boundaries

When setting a location type of Boundary>>One Country>>UK>>CensusAreas to a map and setting the location as the LSOA code a map is drawn with a set of boundaries but the boundaries do not reflect the area and is drawn in London rather than West Yorkshire.

 

I can't find any documentation online to establish what Census Areas are supported.

 

Has anyone come across any details?

ESRI - is this a feature that is work in progress?

 

Thanks

12 REPLIES 12
coniro
New Member

Has this problem been solved? Any updates?

DebbieE
Community Champion
Community Champion

We are also having this problem with the visual using LSOA codes. Is there anyother place we can go to get this logged?

I believe this is similar to an issue we have observed in May last year, ticket raised with MS. This was the response

We had a look in how you were using the LSOAs or MSOAs columns to visualize Census data to represent UK boundaries in the ArcGIS map. We identified that the columns used for mapping the data on the visual are alphanumeric and not ideal for ArcGIS map visual. We discussed possibilities of changing the column to represent the Census areas and ended up using the correct column for this scenario which was Output Areas (OAs) which is a geography very granular and helpful in this scenario.

 

If similar - please Vote this one up:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37651120-extend-the-arcgis-map-vi...

GK
Regular Visitor

Having the same problem - different part of London! - any idea if / when this will get fixed?

v-yuezhe-msft
Employee
Employee

@saj,

Could you please share sample data of your table and post screenshot of your scenario so that we can test it further?


Regards,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi any update on this?

@saj,

I am not able to re-create the ArcGis map using your sample data, please check the screenshot in my scenario. Would you mind sharing me your PBIX file?

1.PNG

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, the link to the PBIX file is https://datahub.bradford.gov.uk/ebase/dp/LSOA.pbix

 

Thanks

gooranga1
Power Participant
Power Participant

Hi @saj

 

I couldn't get the ArcGIS map working and git the same problems you reported but if you follow the post from @mjfulke you could use the Shape visualisation instead.

 

http://community.powerbi.com/t5/Desktop/Create-Your-Own-Custom-Map-for-Power-BI/m-p/165854/highlight...

 

I tried it with your data and I could get a map okay but frustatlingly I couldn't get the areas to colour correctly so it's all green in powerbi even after executing -svg-style fill="white".

I am sure there are people that would know what commands to  execute in mapshaper to remove the fill and allow colour saturation to work correctly in power bi.

 

bradford.PNG

 

Ah no I did get it working both using the shape file export on kml export for bradford.

 

bradford1.PNG

Thanks @gooranga we are using shape visualisations successfully but they are not very good at identifying where the polygon sits within the context of the district (area).

 

Even individuals who know the district struggle to work out where an area (in this case an LSOA) relates to the city/towns/villages etc.

 

Hopefully ESRI will resolve this issue as we are looking forward to being able to have polygons overlaid on a map (in addition to reference layers).

 

Thanks again.

gooranga1
Power Participant
Power Participant

ah I see yes it does lack a base map using shape visualisation. Hopefully this will get fixed.

The source data is available at https://datahub.bradford.gov.uk/ebase/dp/LSOA.csv

 

The source data has been extracted from the ONS and can be seen via this link.

http://geoportal.statistics.gov.uk/datasets/da831f80764346889837c72508f046fa_2?uiTab=table&filterByE...

 

The following screen shot shows BI. I've created the ArcGIS map where location = LSOAcode.

Location Type>>Boundary>>One Country>>UK>>CensusArea

 

The codes are geocoded but incorrectly. The shape is wrong and the polygons are near Uxbridge, not Bradford, West Yorkshire.

 

 

Capture.JPG

 

Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.