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:

     

     

     

deldersveld's avatar
deldersveld
Resident Rockstar
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
Advocate I
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:

 

 

 

  • deldersveld's avatar
    deldersveld
    Resident Rockstar
    10 years ago

    ChristianDiscer: Great. I don't have an ArcGIS license, and I used QGIS. If/when I blog this, can I use your screenshots for ArcGIS users alongside my own?

    • mjfulke's avatar
      mjfulke
      Microsoft Employee
      9 years ago

      I  was able to take Shape Files straight to http://MapShaper.org, import them, and in the Console window, run -proj wgs84 and convert the map to something Power BI would accept.  

      • sweidlich's avatar
        sweidlich
        Advocate II
        8 years ago

        This response needs to be ranked higher. Our security settings at work prevent us from installing qgis, and arcgis is too expensive. But running "-proj wgs84" in the console dialog worked like a freaking charm.

    • ChristianDiscer's avatar
      ChristianDiscer
      Advocate I
      10 years ago

      Yes, by all means use the images in anyway possible.  Thanks again for your help!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi there. Will you please be able to help me with the similar problems? Thank you in advance. My email [email protected]

  • nallaa's avatar
    nallaa
    Frequent Visitor
    6 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
      6 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