Forum Discussion
Custom Shape Map - Insert City Polygon in State County Map
Hello,
I am trying to display City of Detroit along with Counties in Michigan map. I have downloaded and imported the City of Detroit shape file and Michigan Counties shape file to Mapshaper. I have merged 2 layers using "merge-layers" command in Mapshaper console. I was able to see the City of Detroit boundary under Wayne County of Michigan map in the output of merged file.
I have exported the output in TopoJSON format as a local file. I have converted the output coordinate system to WGS 1984. But, when I loaded this custom map to Shape Map visual in Power BI, I am not able to find the City of Detroit's boundary in Power BI. It is displaying the whole Wayne County with out Detroit polygon.
I have checked Map keys. It is fine. When I filtered City of Detroit in my fields, the Shape Map is approximately zooming in to Detroit's geographic location in default grey color.
I need to display boundary for City of Detroit to appear so that one can select Detroit or rest of Wayne County in Power BI Shape map.
Am I missing some steps to be done in Mapshaper? Can you please help me with this?
I am sharing the source file download links below,
http://gis-michigan.opendata.arcgis.com/datasets/cities-v17a/data?where=NAME%20%3D%20%27Detroit%27
http://gis-michigan.opendata.arcgis.com/datasets/counties-v17a/data
Power BI Desktop Version: 2.84.861.0 64-bit (August 2020)
Windowns Version: Windows 10 Enterprise
Thank you,
Abhinav
THe issue has been resolved. I have uploaded 2 source files to Mapshaper. One is of Detroit City map and the Other is of Michigan County Map. I have used "erase" command in Mapshaper to erase interecting boundary between Wayne County and Detroit city. Later, I have merged 2 layers using "merge-layers" command. Finally I have used Simplify in mapshaper to repair any interscetions resulted due to above 2 operations.
Thank you,
Abhinav
6 Replies
- nallaaFrequent Visitor
THe issue has been resolved. I have uploaded 2 source files to Mapshaper. One is of Detroit City map and the Other is of Michigan County Map. I have used "erase" command in Mapshaper to erase interecting boundary between Wayne County and Detroit city. Later, I have merged 2 layers using "merge-layers" command. Finally I have used Simplify in mapshaper to repair any interscetions resulted due to above 2 operations.
Thank you,
Abhinav
- AllisonKennedyCommunity ChampionThanks for the update! Glad it's working and I'll be coming to you if I ever have any question on mapshaper. 😛
- AllisonKennedyCommunity ChampionI would guess you might need to update the Wayne county shape too so that it excludes the city of Detroit, otherwise Power BI can't have two shapes in the same place.
- nallaaFrequent Visitor
AllisonKennedy Do you know how to update the Wayne county polygon excluding the Detroit city in Mapshaper?
Access to source files,
https://drive.google.com/drive/folders/1uPsaACCQbn2C-uRfs-8alZUCk4D040Iv?usp=sharing
Thank you
Abhinav
- amitchandakSuper User
nallaa , you need to have correct json for that.
these are few sources having information on that. Not sure they can help you
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map
https://dataveld.com/2016/09/12/topojson-map-files-for-power-bi-shape-map/
https://medium.com/weareservian/power-bi-custom-maps-part-ii-shape-map-939873da3f66
https://radacad.com/shape-map-better-than-the-filled-map
https://doc.arcgis.com/en/maps-for-powerbi/get-started/prepare-your-data.htm - v-lionel-msftCommunity Support
Hi nallaa ,
Does your'map key' contain Detroit?
Power BI can't seem to achieve this.Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.