Alaska and Hawaii are missing

[chazmo03]

The following DMA's are missing from the data set:

• Anchorage, AK
• Juneau, AK
• Fairbanks, AK
• Honolulu, HI

[aaburgos4]

I would also like to see these added!

[Nemsae]

@aaburgos4 @chazmo03 Hey guys! I know it's been a while since this issue has been open and yall have probably moved on to different projects.

But I'm currently trying to build a DMA map also with Alaska and Hawaii. Were there any workarounds or tips/tricks that you used to accomodate these DMAs?

[ryanrishi]

Hey @Nemsae, I was able to modify this dataset using QGIS to add these. Rough steps are:

• download QGIS or some other GIS program
• import nielsentopo.json into that program
• download and import the US Census county shapefiles
• figure out which counties that make up the Anchorage/Juneau/Fairbanks/Honolulu DMAs using this map
• copy the underlying counties to the nielsentopo layer
• merge them together
• export the nielsentopo layer

As a side note, most DMAs in this dataset are made up of individual counties, so you can also use that dataset to clean up the edges of DMAs. Here's an example:

[aaburgos4]

Hey @Nemsae,

I did this long ago, but I found a DMA shapefile somewhere on the interwebs (I forgot where) that included both Hawaii and Alaska and was able to convert that over to TopoJSON with http://mapshaper.org/. I have a JS file that you can use or I can submit a pull request if you want. I used this for loading into HighchartsJS and using as an interactive chart, but you can save it as a JSON file and use it how you wish.

I can give you both a detailed version and a simplified version. The difference being that the detailed version has way more polygon coordinates and adds a significant amount of weight to the file (1.1MB vs 270KB). I used the simplified version which rendered way faster and it looks good enough for my use case.

[Nemsae]

@aaburgos4 I would deeply appreciate it if I could use that JS file that you have for both the detailed and simplified version!

On a side note: Do you know if this data (which I presume is made by Nielsen) for a use case just like this would require paying Nielsen for commercial use? I'd like to think we don't but I've contacted Nielsen and am still waiting on a response.

[simzou]

@Nemsae I've merged in @aaburgos4's json files via https://github.com/simzou/nielsen-dma/pull/12.

I'm pretty sure you would have to pay Nielsen for this data. The original sources I got this from way back when seem to have been DMCA'd and taken down.

[Nemsae]

@simzou Awesome. Thanks for the info, the project, and for keeping it updated.

[logan-priyank]

Alaska and Hawaii are missing

[tumparoy]

was trying to implement simplified version of json file.... but its not working... not able to see any map.... what i need to do to implement the file

[Nemsae]

@tumparoy The issue is most likely your d3 code, not the json.

[giorgi-ghviniashvili]

Hi guys. Thanks for adding Alaska and Hawaii, but is it possible to project them exactly same as GeoAlbersUSA?

https://bl.ocks.org/Fil/7723167596af40d9159be34ffbf8d36b