Forum Discussion

ChristianDiscer's avatar
ChristianDiscer
Advocate I
10 years ago
Solved

Problem using custom shape map

Converted shapefile (projection "transverse_mercator") to a Topo JSON file using the website http://mapshaper.org/ but the resulting JSON file has display problems.  Here's a screenshot: (1) The left...
  • deldersveld's avatar
    deldersveld
    10 years ago

    I believe that when I converted your file, I lined it up with WGS 84 / EPSG 4326 -- geographic.

  • ChristianDiscer's avatar
    ChristianDiscer
    10 years ago

    deldersveld Thank you so much, that works great!!  Here's are screen captures of the process.

     

    Step #1: select the shapefile using ArcGIS Project tool & set parameters

     

     Step #2: Parameters selected

     

     Step #3: Use mapshaper.org to convert shapefile to json format

     

     Step #4: Save as TopoJSON

     

     Step #5: Use TopoJSON file in Power BI:smileyvery-happy:

     

     

     

nallaa's avatar
nallaa
Frequent Visitor
5 years ago

Hello deldersveld ,

 

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 as suggested in this thread. 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)

Windows 10 Enterprise

 

Thank you,

Abhinav

nallaa's avatar
nallaa
Frequent Visitor
5 years ago

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