cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jayeckles
Advocate II
Advocate II

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

19 REPLIES 19

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

Great resource.  I am looking for a TopoJson for all US Zip Codes so that I can quickly develop a map.  Any reference would greatly appreciated.

any chance you can add Greece and Cyprus on the list?

 

Could you include the country Uruguay in https://github.com/deldersveld/topojson? Thank you

Podrías incluir en https://github.com/deldersveld/topojson a Uruguay? Gracias

@deldersveld Appreciate your efforts.

Unfortunately though, India map is not usable (atleast, within India) since the disputed regions have been excluded, wherein it is illegal in India to depict the country's boundaries excluding disputed areas like POK, Siachen.

Is it possible for you to include the disputed areas in the north and release a version.

I will *convert* from an original source, but I will not *create* an original source. This is due to the liability for ongoing maintenance and potential for continually correcting regional errors like those you have pointed out. If you can find an original public source as a Shapefile, GeoJson, or other format that contains the regions as you'd like them, I would be more than happy to attempt to convert it to TopoJson.

Updated to include individual state files with county boundaries: https://github.com/deldersveld/topojson/blob/master/README.md

Do you have a process set up to do this that I could replicate?  For example, we're currently looking for maps for Tennessee only with boundaries for TN State House and TN State Senate (as opposed to US House and US Senate) districts.

@jayeckles: for the county files, I could script it out more easily because each individual state file started from the same national file. It looks like the census site doesn't have that for state legislative districts and instead has it per-state. I pulled Tennessee's down and converted them, but I probably wouldn't try to do this programmatically for the hosted collection for each state (could do as-needed or on-request though for other states).

 

The latest version was 2015, so hopefully districts have not been re-drawn since.

Senate: https://github.com/deldersveld/topojson/blob/master/us-states/TN-47-tennessee-state-senate-districts...

House: https://github.com/deldersveld/topojson/blob/master/us-states/TN-47-tennessee-state-house-districts-...

This is great! Any ideas how you can get the county map to support the Albers USA projection, like the USA: states map?

Unfortunately the projection options are part of the Shape Map source code. Albers requires latitude and longitude parameters to be specified to render without too much distortion, so that's likely why it's not an option for the custom topojson import. Obviously the county map lines up properly since it's a US map, but that's just by chance.

Interesting, so you're saying we can't expect a topojson file to support Albers until the Shape Map visual code is updated? When this support is added, do you think the files you're sharing on GitHub will work? I'm a little surprised it doesn't work by default because we can do an Albers projection for one of the default maps.

@npnigro: Attempting to read between the lines, do you simply want Alaska to to appear in the location where the "Albers" map places it...?

Yes, I'm trying to make a Power BI visual like this:

 

http://bl.ocks.org/mbostock/4090848

@deldersveld any thoughts on how to make these a custom map look like http://bl.ocks.org/mbostock/4090848 or do you think it's not possible yet?

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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors