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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jayeckles
Advocate III
Advocate III

collection of topojson maps?

Anyone have a link to a collection of useful topojson maps (the format that can be used in the Shape Map Visual)?  I've found tools that will let you create these, and I've even found a US map that contains counties but no useful ID.  

 

Surely someone has a collection of common maps already in topojson format.  I'm looking right now for US zip codes, US counties (perhaps ID'd by FIPS), and US congressional districts.  

 

Thanks!

1 ACCEPTED SOLUTION

I've started a repository to collect topojson files converted from open data sources and can add additional files over time: https://github.com/deldersveld/topojson

 

Zip codes are only offered by the US census at the highest of resolutions. I used a simplification method to reduce the polygon detail, but performance was still so bad at the national level that it won't work well in Power BI with that many shapes. Zips might be okay at the state level though. Counties at the national level are not as bad. You can match using GEOID, which is FIPS state+county code.

View solution in original post

23 REPLIES 23

I finally had a chance to look more into this, and I have posted a TopoJSON file with Alaska and Hawaii shifted like it is with "Albers USA". Even as a custom map though, you can still select other projections like Mercator, and the Alaska/Hawaii shift is preserved.

 

https://github.com/deldersveld/topojson/blob/master/united-states/us-albers-counties.json

 

US-Albers.PNG

 

 

 

 

@deldersveld How do I get a copy of this TopoJson US Map with zip codes ?  

I loaded up your 20m US Counties map into the Power BI drilldown chloropleth map, added the GEOID from the file into my database to correspond with the correct county I wanted, did the same as well for the states, and gave each County/State combination in my access database a unique ID. However, when I try to filter out a specific county in a specific state, the map will populate all of the counties in the US with the same county name even though if is not in the correct state. Do you know a way to only have it display only the county that is in the state that I set a filter for?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors