Not all counties (gemeentes) are shown the Netherlands map

[TottaErick]

I'm trying to make a filled map of the Netherlands.

The Netherlands consists of 380 'gemeentes' (singular: 'gemeente', translation: county), and most of the times, if I try to find them in Power BI, it can find them and fill them. But there are some problematic values it can't find, so there are holes on my map. The following holes are found:

• Berg en Dal (no idea why this doesn't show)
• Bergen (there are two gemeentes with this name, one in province Limburg and one in province Noord-Holland, usually they are indicated like Bergen (L.) and Bergen (NH.) but that won't work in Power BI)
• Best (no idea why this doesn't show)
• Meierijstad (this gemeente fused on January 1st, 2017 from 3 former gemeentes)
• Midden-Groningen (this gemeente fused on January 1st, 2018 from 3 former gemeentes)
• Waadhoeke (this gemeente fused on January 1st, 2018 from 3 former gemeentes)
• Westerwolde (this gemeente fused on January 1st, 2018 from 2 former gemeentes)

How do I fill the holes on my map?

[v-danhe-msft · Accepted solution]

Hi @TottaErick,

From my research, the places you have listed are not all regions, some of them are villages(Berg en Dal, Best) and some of them are towns or municipalities.(Waadhoeke, Midden-Groningen, Meierijstad). For such locations, you need to give specific latitude and longitude, then the map will work like the picture below.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/8qqauxprpof7s1e/Not%20all%20counties%20%28gemeentes%29%20are%20shown%20the...

Regards,

Daniel He

[TottaErick]

Hi @v-danhe-msft,

Thanks for your reply. This works indeed, if I change the data category from Province/State to County.

You almost got it right, except it seems I didn't make clear enough what a gemeente is. A gemeente has almost always the same name as its capital town (as is the case in Berg en Dal, Best, Bergen (NH) and Bergen (L); in some extreme cases (Groningen and Utrecht), the names of a town, its gemeente and its province can be the same, but these are shown correctly)), while it is actually a region containing multiple towns. The structure of the Netherlands is quite similar to that of the US, but on a smaller scale (please somebody correct me if I'm wrong):

- A state in the US equals a provincie in the Netherlands;

- A county in the US equals a gemeente in the Netherlands;

- A municipality in the US doens't have an equivalent in the Netherlands (this subdivision would be unnecessary/artificial for such a small country) but might be considered as a gemeente as well;

- A city/town/village in the US is the same (stad/plaats/dorp) in the Netherlands.

This is why it seems strange to me that these problematic cases aren't covered on the map if I don't use coordinates, even though the >370 others are shown correctly. Anyway, I'll use the lat/long for all gemeentes, as that seems to work. 

[v-danhe-msft]

Hi @TottaErick

It's pleasant that your problem has been solved, could you please mark my reply as Answered?

Regards,

Daniel He

[Esbee]

Hi!
I want to use lattitude and longitude by making a map of The Netherlands (for plotting adresses on a map more accurately). Therefore I'm looking for a CSV/excel sheet with for all dutch adresses including postal codes the X and y coordinates (open data).
Does anybody know wich source I can use?

Regards, Stéphanie