View source for Talk:Municipalities of the Netherlands

{{Article history
|action1=FLC
|action1date=10:03, 24 June 2013
|action1link=Wikipedia:Featured list candidates/List of municipalities of the Netherlands/archive1
|action1result=promoted
|action1oldid=561337461
|currentstatus=FL
|maindate=2 September 2013}}
{{WikiProject banner shell|class=Fl|listas=Municipalities Of The Netherlands, List Of|
{{WikiProject Cities}}
{{WikiProject Lists|class=FL |importance=Low}}
{{WikiProject Netherlands|muni=yes |muni-importance=Top}}
}}
{{merged-from|Table of municipalities of the Netherlands|31 March 2013}}

==For the record==
For the record:

In Oct 2002 [[User:Jheijmans]] (see [http://en2.wikipedia.org/w/wiki.phtml?title=Special:Contributions&limit=1000&hideminor=0&target=131.155.230.165]) used a bot to create most municipality articles (namely all that did not exist yet), with info from http://www.sdu.nl/staatscourant/scdata/gemeentenindex.htm , including lists of settlements.

I added the lists of settlements for the skipped municipalities. [[User:Patrick|Patrick]] 14:57, 18 Dec 2003 (UTC)

See also [[nl:Overleg:Lijst van Nederlandse gemeenten#Alle gemeenten een artikel]]

Would, please, some Dutchman or Dutchwoman add sth about the powers, duties and functions of Dutch municipalities? It'd be interesting to know what their responsibilities are.

==deelgemeenten==
Would someone be able to provide an accurate translation? I don't speak Dutch and don't want to rely on Google Translate ("towns")! [[Special:Contributions/67.204.9.60|67.204.9.60]] ([[User talk:67.204.9.60|talk]]) 03:39, 28 November 2012 (UTC)


==A Dutch village with the border going across it in a curious shape==

Can anyone tell me the name of the village (or city) where the border goes across the village in a curious shape, going across even a house? Once I found a webpage about it, I remember seeing the map itself, but I can't find it now. I wanted to insert its article into [[Wikipedia:Unusual articles]]. Thank you. -- [[User:Adam78|Adam78]] 23:47, 23 July 2005 (UTC)

:[[Baarle-Nassau]].--[[User:Patrick|Patrick]] 23:54, 23 July 2005 (UTC)

Thanks! :-)  [[User:Adam78|Adam78]] 11:56, 24 July 2005 (UTC)

==Standardization of the lists of municipalities==

There is a discussion about an eventual standardization of all the lists of municipalities. Please join [[:Category talk:Lists of municipalities|here]] and express your opinions.--[[User:Husond|Húsönd]] 19:55, 21 August 2006 (UTC)

==Gemeente (municipality) (municipality)==
Gemeente (municipality) (municipality) redirects here, but are they not also used in Flanders, Belgium too? [[User:Mjroots|Mjroots]] ([[User talk:Mjroots|talk]]) 22:19, 15 February 2010 (UTC)
:You are correct, it's wrong now. It could either be a disambiguation page, or more likely redirect to [[municipality]]. I did he latter, because it makes more sense. Dutch speakers refer to municipalities as gemeenten (or gemeentes) when not in Dutch speaking countries too.
:If that's a problem, fix it or come complain on my talkpage. -[[Special:Contributions/83.134.160.178|83.134.160.178]] ([[User talk:83.134.160.178|talk]]) 12:27, 25 May 2011 (UTC)

== Merger proposal ==
{{Discussion top|1=The result of this discussion was to merge. <span style="border:1px solid maroon; padding:0 2px">[[User:CRwikiCA|<span style="font-family:'Courier';color:maroon">CRwikiCA</span>]]&nbsp;[[User talk:CRwikiCA|<i style="color:navy">talk</i>]]</span> 16:23, 31 March 2013 (UTC)}}
I propose that [[Table of municipalities of the Netherlands]] be merged into [[List of municipalities of the Netherlands]]. I think that the content in the Table article has a large overlap with the List article and that this data should be merged into one list article. The article can then take the shape/structure similar to some [[Wikipedia:FL#Places|featured lists]]. <span style="border:1px solid maroon; padding:0 2px">[[User:CRwikiCA|<span style="font-family:'Courier';color:maroon">CRwikiCA</span>]]&nbsp;[[User talk:CRwikiCA|<i style="color:navy">talk</i>]]</span> 13:16, 28 March 2013 (UTC)

:That does not make sense, the table is sortable. - [[User:Patrick|Patrick]] ([[User talk:Patrick|talk]]) 14:49, 28 March 2013 (UTC)

:Even if you mean keeping the table, just moving it, then I am not in favor of that, because the rendering of the table is already a bit slow due to the processing time. - [[User:Patrick|Patrick]] ([[User talk:Patrick|talk]]) 06:19, 29 March 2013 (UTC)

::Yes, the table is sortable, and some other information like population density and area could be added. If the two are merged all this information is in one place. [[Wikipedia:Merging#Reasons_for_merger]] point #2 (Overlap) recommends to do this, because in this case the two topics overlap completely. There are multiple lists on Wikipedia that have a similar number of entries, so it would not be unwarranted to include this in one list.<br>Part of the reason the rendering time is slow is because all the entries are automatically read out of a template every time, this can be avoided in two ways. First having to using the [[WP:SUBST|subst]] property of the template when updating it. This means every time that population numbers are updated in that list, the list in this would need to be regenerated. And after that rendering will be faster. Second just have numeric entries, I do have a code to convert the excel sheets with the population, area and density numbers automatically to a table containing all this information. Both this methods would reduce the rendering time significantly and would address your second concern. In case that concern would have been addressed, which of those two methods would have your preference? <span style="border:1px solid maroon; padding:0 2px">[[User:CRwikiCA|<span style="font-family:'Courier';color:maroon">CRwikiCA</span>]]&nbsp;[[User talk:CRwikiCA|<i style="color:navy">talk</i>]]</span> 14:29, 29 March 2013 (UTC)

:::One big sortable table (I would not call this a list, to avoid confusion) would be fine for the reader, if the rendering is not too slow. Substitution may have to be done in pieces, otherwise the system may time out. Other ways of creating the wikitext can be considered too, but preferably the tools needed are publicly accessible.--[[User:Patrick|Patrick]] ([[User talk:Patrick|talk]]) 21:11, 29 March 2013 (UTC)

::::I think we pretty much agree then. Although calling it a table might be more appropriate, it seems like the general usage on Wikipedia is to call these kinds of pages lists as stated in [[WP:LISTNAME]]. Therefore I would suggest to follow this guideline and keep calling it a list. <span style="border:1px solid maroon; padding:0 2px">[[User:CRwikiCA|<span style="font-family:'Courier';color:maroon">CRwikiCA</span>]]&nbsp;[[User talk:CRwikiCA|<i style="color:navy">talk</i>]]</span> 00:17, 30 March 2013 (UTC)
*'''Support''' - this is a no brainer. Just go ahead and do it. [[User:Gidonb|gidonb]] ([[User talk:Gidonb|talk]]) 14:13, 30 March 2013 (UTC)
:Okay, if there are no objections I will merge the two tomorrow. <span style="border:1px solid maroon; padding:0 2px">[[User:CRwikiCA|<span style="font-family:'Courier';color:maroon">CRwikiCA</span>]]&nbsp;[[User talk:CRwikiCA|<i style="color:navy">talk</i>]]</span> 21:21, 30 March 2013 (UTC)
{{Discussion bottom}}

== Technical notes ==

The CBS publishes updated population, population density and area numbers throughout the year. Even though the table (list) can be manually updated from these numbers it might be more convenient to use a (semi-)automated system for this. I had automated this, take note of the following if you want to do this as well.
The CBS data can be downloaded as excel-files (and some other file formats if you want that). In particular there are 3 files (or their updated version) you would want. 
<ol type="I">
<li> The municipal information (name + code): [http://www.cbs.nl/nl-NL/menu/methoden/classificaties/overzicht/gemeentelijke-indeling/ get Gemeenten alfabetisch].</li>
<li> The population data: [http://statline.cbs.nl/StatWeb/publication/?DM=SLNL&PA=37230NED&D1=17-18&D2=101-619,621,624-632&D3=l&LA=EN&HDR=T&STB=G1,G2&VW=T Here], go to change selection to select the most recent period and the right regions, then use download to get the data.</li>
<li> The population density and area numbers: [http://statline.cbs.nl/StatWeb/publication/default.aspx?DM=SLNL&PA=70904ned&D1=15%2c157&D2=1-50000&D3=l&LA=EN&HDR=T&STB=G1%2cG2&VW=D Here], go to change selection to select the most recent period and the right regions, then use download to get the data.</li>
</ol>
Update the references once you are done. To generate the table take the following points into account:
# Use a program of your choosing to read in the data and parse the table.
# Use information (I) to get a list of all municipalities (ordered alphabetically) and their CBS code. Locally store this information in a variable (or multiple variables).
# Now use data (II) to match the population data, search for the right town name to do this, because the index might not be exactly the same.
# Now use data (III) to obtain the population density and area numbers. Note that this is an enormous list which also includes municipal subdivisions and that names could occur multiple times (e.g. both as town name its municipality). Find all the matching entries for each municipality and use the one with the largest area, which is the municipality and take the population density from that same entry.
# You have all the data, although ''if'' files (II) or (III) are from a previous year it might not be correct because of municipal changes (2 or more are merged together). Manually check the municipalities that were new or increased in size for the current year (either in this step or after parsing the table).
# Now parse the table (see example code below), note that the numbers should ideally be given in both km<sup>2</sup> and sq mi and rounded to the same precision. Note 1 km<sup>2</sup> = 0.386102 sq mi
# Copy paste the table in your sandbox and check whether all the wikilinks are correct. Note that {{tl|Province Dutch municipality}} might not yet include newly formed municipalities and might need to be updated.
# Update the references you used

Example code implemented in Matlab:

{{hidden
|Example code, implemented in Matlab
|<syntaxhighlight lang="matlab" line>
close all
clear all

% Define the file names
file_muni = '2014gemeentenalfabetisch.xlsx';
file_pop = '201401_bevolking.xlsx';
file_key_nums = '201212_kerncijfers_wijken.xlsx';

% Calculation needs
sqmi_per_sqkm = 0.386102;

% Get the municipal information (names + CBS codes)
[~,~,data_muni]=xlsread(file_muni);
N_muni = size(data_muni,1)-1;
list_info_cell = cell(N_muni,5);
for ii = 1:N_muni
    list_info_cell{ii,1} = data_muni{ii+1,1};
    list_info_cell{ii,2} = data_muni{ii+1,2};
end
clear data_muni
% Note: Bergen occurs in two provinces

% Get the population information
[~,text_pop,data_pop]=xlsread(file_pop);
for ii = 1:N_muni
    % Find the municipality in this table
    curr_muni = list_info_cell{ii,1};
    muni_find = strfind(text_pop,curr_muni);
    jj_index = find(cellfun(@(x) ~isempty(x)&&(x==1), muni_find));
    N_found = numel(jj_index);
    % Now put the population
    if N_found == 1
        list_info_cell{ii,3} = data_pop{jj_index,3};
    elseif N_found == 0
        fprintf(['No population number found for ',curr_muni,'\n']);
    else
        % There are several options; 1 is that there are other towns
        % starting with the same names, but not the same, others are that
        % there is an empty entry
        name_options = {text_pop{jj_index,1}};
        kk_exact = cellfun(@(x) strcmp(x,curr_muni),name_options);
        one_exact = (sum(kk_exact) == 1);
        if one_exact
            kk_index = jj_index(kk_exact);
            list_info_cell{ii,3} = data_pop{kk_index,3};
        else
            switch curr_muni
                case 'Hengelo'
                    muni_find = strfind(text_pop,'Hengelo (O.)');
                    fprintf('Using Hengelo (O.) instead of Hengelo for population.\n');
                    jj_index = find(cellfun(@(x) ~isempty(x)&&(x==1), muni_find));
                    list_info_cell{ii,3} = data_pop{jj_index,3};
                case 'Utrecht'
                    muni_find = strfind(text_pop,'Utrecht (gemeente)');
                    fprintf('Using Utrecht (gemeente) instead of Utrecht for population.\n');
                    jj_index = find(cellfun(@(x) ~isempty(x)&&(x==1), muni_find));
                    list_info_cell{ii,3} = data_pop{jj_index,3};
                otherwise
                    fprintf(['Multiple population numbers found for ',curr_muni,'\n']);
            end
        end
    end
end
clear text_pop data_pop

% Get the density and area information
[~,text_key_nums,data_key_nums]=xlsread(file_key_nums);
for ii = 1:N_muni
    % Find the municipality in this table
    curr_muni = list_info_cell{ii,1};
    muni_find = strfind(text_key_nums,curr_muni);
    jj_index = find(cellfun(@(x) ~isempty(x)&&isscalar(x)&&(x==1), muni_find));
    N_found = numel(jj_index);
    % Now put the population
    if N_found == 1
        list_info_cell{ii,4} = data_key_nums{jj_index,3}; % Population density
        list_info_cell{ii,5} = data_key_nums{jj_index,4}/100; % Total area in km^2
        list_info_cell{ii,6} = data_key_nums{jj_index,5}/100; % Land area in km^2
    elseif N_found == 0
        fprintf(['No density and area number found for ',curr_muni,'\n']);
        list_info_cell{ii,4} = 0; % Population density; dummy value
        list_info_cell{ii,5} = 0; % Total area in km^2; dummy value
        list_info_cell{ii,6} = 0; % Land area in km^2
    else
        % There are several options; 1 is that there are other towns
        % starting with the same names, but not the same, others are that
        % there is an empty entry
        name_options = {text_key_nums{jj_index,1}};
        kk_exact = cellfun(@(x) strcmp(x,curr_muni),name_options);
        one_exact = (sum(kk_exact) == 1);
        if one_exact
            kk_index = jj_index(kk_exact);
            list_info_cell{ii,4} = data_key_nums{kk_index,3}; % Population density
            list_info_cell{ii,5} = data_key_nums{kk_index,4}/100; % Total area in km^2
            list_info_cell{ii,6} = data_key_nums{kk_index,5}/100; % Land area in km^2
        else % Otherwise cheat and use the maximum area region for it
            ll_index = jj_index(kk_exact);
            tot_area_nums = {data_key_nums{ll_index,4}};
            try 
                ll_area = cell2mat(tot_area_nums);
            catch 
                for iii = 1:numel(tot_area_nums)
                    if ~isnumeric(tot_area_nums{iii})
                        tot_area_nums{iii} = 0;
                    end
                end            
                ll_area = cell2mat(tot_area_nums);
            end
            [~,ll_max] = max(ll_area(:));
            kk_index = ll_index(ll_max);
            list_info_cell{ii,4} = data_key_nums{kk_index,3}; % Population density
            list_info_cell{ii,5} = data_key_nums{kk_index,4}/100; % Total area in km^2
            list_info_cell{ii,6} = data_key_nums{kk_index,5}/100; % Land area in km^2
%         else
%             fprintf(['Multiple density and area numbers found for ',curr_muni,'\n']);
        end
    end
end

% Build the text file for the list article
% Header
table_text = '{|class="wikitable plainrowheaders sortable" style="text-align: center;"\n';
table_text = [table_text,'! scope="col" |Municipality\n'];
table_text = [table_text,'! scope="col" |CBS code<ref name="CBS_code"></ref>\n'];
table_text = [table_text,'! scope="col" |Province\n'];
table_text = [table_text,'! scope="col" |Population<ref name="CBS_pop"></ref>\n'];
table_text = [table_text,'! scope="col" |Population density<ref name="CBS_key_figs"></ref>\n'];
table_text = [table_text,'! scope="col" |Area<ref name="CBS_key_figs"></ref>\n'];
table_text = [table_text,'! scope="col" class=unsortable|Map\n'];
% Municipal information
for ii = 1:N_muni
    dens_km2 = list_info_cell{ii,4};
    total_area_km2 = list_info_cell{ii,5};
    table_text = [table_text,'|-\n'];
    table_text = [table_text,'! scope="row" style="background-color:transparent"|[[',list_info_cell{ii,1},']]\n'];
    table_text = [table_text,'|',list_info_cell{ii,2},'\n'];
    table_text = [table_text,'|[[{{subst:Province Dutch municipality|',list_info_cell{ii,1},'}}|]]\n'];
    table_text = [table_text,'{{nts|',num2str(list_info_cell{ii,3}),'}}\n'];
    table_text = [table_text,'|{{ntsh|',num2str(dens_km2),'}}{{subst:formatnum:',num2str(dens_km2),...
        '}}&nbsp;/km<sup>2</sup> ({{subst:formatnum:',num2str(round(dens_km2/sqmi_per_sqkm)),...
        '}}&nbsp;/sq&nbsp;mi)\n'];
    table_text = [table_text,'|{{ntsh|',num2str(total_area_km2),'}}{{subst:formatnum:',num2str(total_area_km2),...
        '}}&nbsp;km<sup>2</sup> ({{subst:formatnum:',num2str(round(100*total_area_km2*sqmi_per_sqkm)/100),...
        '}}&nbsp;sq&nbsp;mi)\n'];
    table_text = [table_text,'|[[File:Map - NL - Municipality code ',list_info_cell{ii,2},...
        ' (2009).svg|150px|alt=Location of ',list_info_cell{ii,1},']]\n'];
end
% Table close
table_text = [table_text,'|}\n'];

% Replace some text for redirects etc..
% Drenthe
table_text = strrep(table_text,'[[Emmen]]','[[Emmen, Netherlands|Emmen]]');
% Friesland
table_text = strrep(table_text,'[[Harlingen]]','[[Harlingen, Friesland|Harlingen]]');
table_text = strrep(table_text,'[[Kollumerland en Nieuwkruisland]]','[[Kollumerland c.a.|Kollumerland en Nieuwkruisland]]');
% Gelderland
table_text = strrep(table_text,'[[Ede]]','[[Ede, Netherlands|Ede]]');
table_text = strrep(table_text,'[[Scherpenzeel]]','[[Scherpenzeel, Gelderland|Scherpenzeel]]');
% Groningen
table_text = strrep(table_text,'[[Haren]]','[[Haren, Groningen|Haren]]');
table_text = strrep(table_text,'[[Leek]]','[[Leek, Groningen|Leek]]');
table_text = strrep(table_text,'[[Oldambt]]','[[Oldambt (municipality)|Oldambt]]');
% Limburg
table_text = strrep(table_text,'Bergen (L.)','Bergen, Limburg');
table_text = strrep(table_text,'[[Bergen, Limburg]]','[[Bergen, Limburg|Bergen (LI)]]');
table_text = strrep(table_text,'[[Stein]]','[[Stein, Limburg|Stein]]');
% North Brabant
table_text = strrep(table_text,'[[Asten]]','[[Asten, Netherlands|Asten]]');
table_text = strrep(table_text,'[[Best]]','[[Best, Netherlands|Best]]');
table_text = strrep(table_text,'[[Deurne]]','[[Deurne, North Brabant|Deurne]]');
table_text = strrep(table_text,'[[Grave]]','[[Grave, North Brabant|Grave]]');
table_text = strrep(table_text,'[[Haaren]]','[[Haaren, North Brabant|Haaren]]');
% North Holland
table_text = strrep(table_text,'Bergen (NH.)','Bergen, North Holland');
table_text = strrep(table_text,'[[Bergen, North Holland]]','[[Bergen, North Holland|Bergen (NH)]]');
% Overijssel
table_text = strrep(table_text,'[[Borne]]','[[Borne, Overijssel|Borne]]');
table_text = strrep(table_text,'[[Kampen]]','[[Kampen (Overijssel)|Kampen]]');
% South Holland
table_text = strrep(table_text,'''s-Gravenhage','The Hague');
table_text = strrep(table_text,'[[Westland]]','[[Westland (municipality), Netherlands|Westland]]');
table_text = strrep(table_text,'[[Zwijndrecht]]','[[Zwijndrecht, Netherlands|Zwijndrecht]]');
% Utrecht
table_text = strrep(table_text,'[[Soest]]','[[Soest, Netherlands|Soest]]');
% Zeeland
table_text = strrep(table_text,'[[Reimerswaal]]','[[Reimerswaal (municipality)|Reimerswaal]]');

% Replace sortkey for some names
table_text = strrep(table_text,'[[het Bildt]]','{{sortname|het|Bildt}}');
table_text = strrep(table_text,'[[De Bilt]]','{{sortname|De|Bilt}}');
table_text = strrep(table_text,'[[Ten Boer]]','{{sortname|Ten|Boer}}');
table_text = strrep(table_text,'[[The Hague]]','{{sortname|The|Hague}}');
table_text = strrep(table_text,'[[Den Helder]]','{{sortname|Den|Helder}}');
table_text = strrep(table_text,'[[''s-Hertogenbosch]]','{{sort|Hertogenbosch|[[''s-Hertogenbosch]]}}');
table_text = strrep(table_text,'[[De Marne]]','{{sortname|De|Marne}}');
table_text = strrep(table_text,'[[De Ronde Venen]]','{{sortname|De|Ronde Venen}}');
table_text = strrep(table_text,'[[De Wolden]]','{{sortname|De|Wolden}}');

% Replace changed maps
table_text = strrep(table_text,'Map - NL - Municipality code 0074 (2009).svg','Map - NL - Municipality code 0074 (2014).png');
table_text = strrep(table_text,'Map - NL - Municipality code 0080 (2009).svg','Map - NL - Municipality code 0080 (2014).png');
table_text = strrep(table_text,'Map - NL - Municipality code 0484 (2009).svg','Map - NL - Municipality code 0484 (2014).png');
table_text = strrep(table_text,'Map - NL - Municipality code 1892 (2009).svg','Map - NL - Gemeente Zuidplas.svg');
table_text = strrep(table_text,'Map - NL - Municipality code 1894 (2009).svg','LocatiePeelEnMaas.png');
table_text = strrep(table_text,'Map - NL - Municipality code 1900 (2009).svg','Map - NL - Municipality code 1900 (2014).png');
table_text = strrep(table_text,'Map - NL - Municipality code 1901 (2009).svg','Map - NL - Municipality code 1901 (2011).svg');
table_text = strrep(table_text,'Map - NL - Municipality code 1903 (2009).svg','LocatieEijsdenMargraten.png');
table_text = strrep(table_text,'Map - NL - Municipality code 1908 (2009).svg','LocatieMenaldumadeel.png');
table_text = strrep(table_text,'Map - NL - Municipality code 1911 (2009).svg','LocatieHollandsKroon.png');
table_text = strrep(table_text,'Map - NL - Municipality code 1921 (2009).svg','Map - NL - Municipality code 1921 (2014).png');
table_text = strrep(table_text,'Map - NL - Municipality code 1924 (2009).svg','LocatieGoereeOverflakkee.png');
table_text = strrep(table_text,'Map - NL - Municipality code 1927 (2009).svg','Map - NL - Municipality code 1927 (2012).svg');

% Write to text file
table_text_out = strrep(table_text,'\n','\r\n');
fid_log = fopen('WP_List_muni_text.txt','w+');
fprintf(fid_log,table_text_out);
fclose(fid_log);


%% Build text files for the data template files: population, total area, land area 
text_data_pop = '';
text_data_tot_area = '';
text_data_land_area = '';
% Now fill in the blanks
for ii = 1:N_muni
    % Check whether it exists
    if list_info_cell{ii,1} > 0
        text_data_pop = [text_data_pop,'|\t',list_info_cell{ii,2},'\t=\t',...
            num2str(list_info_cell{ii,3}),'\t<!--\t',list_info_cell{ii,1},'\t-->\n'];
    else
        text_data_pop = [text_data_pop,'|\t',list_info_cell{ii,2},'\t=\t',...
            'data missing','\t<!--\t',list_info_cell{ii,1},'\t-->\n'];
    end
    if num2str(list_info_cell{ii,5}) > 0 
        text_data_tot_area = [text_data_tot_area,'|\t',list_info_cell{ii,2},'\t=\t',...
            num2str(list_info_cell{ii,5},'%9.2f'),'\t<!--\t',list_info_cell{ii,1},'\t-->\n'];
    else
        text_data_tot_area = [text_data_tot_area,'|\t',list_info_cell{ii,2},'\t=\t',...
            'data missing','\t<!--\t',list_info_cell{ii,1},'\t-->\n'];
    end
    if num2str(list_info_cell{ii,6}) > 0
        text_data_land_area = [text_data_land_area,'|\t',list_info_cell{ii,2},'\t=\t',...
            num2str(list_info_cell{ii,6},'%9.2f'),'\t<!--\t',list_info_cell{ii,1},'\t-->\n'];
    else
        text_data_land_area = [text_data_land_area,'|\t',list_info_cell{ii,2},'\t=\t',...
            'data missing','\t<!--\t',list_info_cell{ii,1},'\t-->\n'];
    end
end
% Now save these to text files
fid_log = fopen('WP_muni_data_pop.txt','w+');
fprintf(fid_log,strrep(text_data_pop,'\n','\r\n'));
fclose(fid_log);
fid_log = fopen('WP_muni_data_tot_area.txt','w+');
fprintf(fid_log,strrep(text_data_tot_area,'\n','\r\n'));
fclose(fid_log);
fid_log = fopen('WP_muni_data_land_area.txt','w+');
fprintf(fid_log,strrep(text_data_land_area,'\n','\r\n'));
fclose(fid_log);
</syntaxhighlight>
|headerstyle=background:#ccccff
|style=text-align:center;
}}
<span style="border:1px solid maroon; padding:0 2px">[[User:CRwikiCA|<span style="font-family:'Courier';color:maroon">CRwikiCA</span>]]&nbsp;[[User talk:CRwikiCA|<i style="color:navy">talk</i>]]</span> 13:31, 2 April 2013 (UTC), Last update: <span style="border:1px solid maroon; padding:0 2px">[[User:CRwikiCA|<span style="font-family:'Courier';color:maroon">CRwikiCA</span>]]&nbsp;[[User talk:CRwikiCA|<i style="color:navy">talk</i>]]</span> 18:29, 12 March 2014 (UTC)

== Municipality subdivisions ==

Can anybody verify if the only cities with municipality subdivisions are Amsterdam (deelgemeente) and Rotterdam (stadsdeel) or, as stated in the Italian version of the page, Amsterdam and Rotterdam (deelgemeente) and The Hague, Almere, Breda, Eindhoven, Enschede, Groningen, Nijmegen and Utrecht (stadsdeel)? Thanks [[User:Hypergio|Hypergio]] ([[User talk:Hypergio|talk]]) 13:39, 4 December 2013 (UTC)
:To clarify the situation: Only Rotterdam and Amsterdam have legally defined sub-municipal governments with their own elected representatives (formally ''deelgemeente'', although they are called ''stadsdeel'' in Amsterdam as well). Technically all Dutch municipalities are divided administratively into boroughs and neighborhoods, which might be called ''stadsdeel'' in some places. These subdivisions do not, however, have the legal status of ''deelgemeente'', even when there are elections for their potential respective sub-municipal councils. <span style="border:1px solid maroon; padding:0 2px">[[User:CRwikiCA|<span style="font-family:'Courier';color:maroon">CRwikiCA</span>]]&nbsp;[[User talk:CRwikiCA|<i style="color:navy">talk</i>]]</span> 16:03, 4 December 2013 (UTC)
::Personal experience (I live in The Hague).: I normally do not receive any communication or formal letter from the ''geemente'' but from the ''stadsdeel'' of Haagse Hout. The division of The Hague in ''stadsdeel'' is formally defined and this is the office I usually refer to: [http://www.denhaag.nl/home/bewoners/to/Stadsdeelkantoor-Haagse-Hout.htm|Stadsdeel Haagse Hout]. This is not a subdivision made by the [[Statistics Netherlands|Centraal Bureau voor de Statistiek - CBS]] for statistic purposes only. There are other additional subdivions called ''neighbourhood'' which are for statistic purposes only. In The Hague, they are smaller than the ''stadsdeelen''. Haagse Hout, for example, is divided in 4 neighbourhoods: ''Benoordenhout'', ''Haagse Hout'', ''Bezuidenhout'' and ''Mariahoeve en Marlot''. I am trying to find, without success, the law, the rule or any other reference which is giving to the ''stadsdeelen'' of Amsterdam and Rotterdam only the ''legal status'' to exist.[[User:Hypergio|Hypergio]] ([[User talk:Hypergio|talk]]) 21:12, 5 December 2013 (UTC)
:::Yes, the other municipalities with ''stadsdelen'' do not just have a statistical function, but they do not have the legal status of deelgemeente. See for example the following Rijksoverheid links [http://www.rijksoverheid.nl/nieuws/2012/11/27/plan-afschaffing-deelgemeenten-in-amsterdam-en-rotterdam-doorgezet.html this one] and [http://www.rijksoverheid.nl/onderwerpen/gemeenten/raadsleden/commissies this one], were Amsterdam and Rotterdam are listed separate. <span style="border:1px solid maroon; padding:0 2px">[[User:CRwikiCA|<span style="font-family:'Courier';color:maroon">CRwikiCA</span>]]&nbsp;[[User talk:CRwikiCA|<i style="color:navy">talk</i>]]</span> 14:35, 6 December 2013 (UTC)
::::Thanks, I will make the same changes on the corresponding article in Wikipedia Italian.  <small><span class="autosigned">—&nbsp;Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[User:Hypergio|Hypergio]] ([[User talk:Hypergio|talk]] • [[Special:Contributions/Hypergio|contribs]]) 21:05, 6 December 2013 (UTC)</span></small><!-- Template:Unsigned --> <!--Autosigned by SineBot-->
:::::No problem. I have to admit the situation is a bit odd. When they cancel the deelgemeenten – although we'll see when it happens – the situation might become a bit clearer. <span style="border:1px solid maroon; padding:0 2px">[[User:CRwikiCA|<span style="font-family:'Courier';color:maroon">CRwikiCA</span>]]&nbsp;[[User talk:CRwikiCA|<i style="color:navy">talk</i>]]</span> 00:32, 7 December 2013 (UTC)


== Requested move 10 December 2020 ==
<div class="boilerplate" style="background-color: #efe; margin: 0; padding: 0 10px 0 10px; border: 1px dotted #aaa;"><!-- Template:RM top -->
:''The following is a closed discussion of a [[Wikipedia:Requested moves|requested move]]. <span style="color:red">'''Please do not modify it.'''</span> Subsequent comments should be made in a new section on the talk page. Editors desiring to contest the closing decision should consider a [[Wikipedia:move review|move review]] after discussing it on the closer's talk page. No further edits should be made to this discussion. ''

The result of the move request was: '''Moved''' <small>([[Wikipedia:Requested moves/Closing instructions#Non-admin closure|non-admin closure]])</small>  ''[[User:BegbertBiggs|BegbertBiggs]]&nbsp;([[User talk:BegbertBiggs|talk]])'' 00:04, 18 December 2020 (UTC)
----



[[:List of municipalities of the Netherlands]] → {{no redirect|Municipalities of the Netherlands}} – per [[Wikipedia:Article titles#Deciding on an article title]]. Shorter and clearer. [[User:Ookrainer|Ookrainer]] ([[User talk:Ookrainer|talk]]) 18:39, 10 December 2020 (UTC)

* '''Support''', per nomination. The article is about the municipalities in general and not merely a list of municipalities. The new name also matches with "[[Provinces of the Netherlands]]". &#8213; [[User:Ætoms|<span style="font-family:Times New Roman; color:Black">Æ'''toms'''</span>]] <sup>[[User talk:Ætoms|<span style="font-family:Times New Roman; color:Black">[''talk'']</span>]]</sup> 12:12, 11 December 2020 (UTC)
{{abot}}

== Middelburg ==

Hi. The article on Middelburg, Zeeland was recently moved from [[Middelburg]] to [[Middelburg, Netherlands]], and now [[Template:Flaglist]] doesn't work with the new name, as can be seen in the list of municipalities. I'm bad with templates and don't know how to fix this. Can someone look into it? [[User:Lennart97|Lennart97]] ([[User talk:Lennart97|talk]]) 09:08, 23 February 2021 (UTC)
* {{Done}}. --[[User:Delasse|Delasse]] ([[User talk:Delasse|talk]]) 11:36, 26 February 2021 (UTC)

== A Commons file used on this page or its Wikidata item has been nominated for deletion ==
The following Wikimedia Commons file used on this page or its Wikidata item has been nominated for deletion:
* [[commons:File:Krimpen aan den Ijssel vlag.svg|Krimpen aan den Ijssel vlag.svg]]<!-- COMMONSBOT: discussion | 2022-04-16T14:53:53.668867 | Krimpen aan den Ijssel vlag.svg -->
Participate in the deletion discussion at the [[commons:Commons:Deletion requests/File:Krimpen aan den Ijssel vlag.svg|nomination page]]. —[[User:Community Tech bot|Community Tech bot]] ([[User talk:Community Tech bot|talk]]) 14:54, 16 April 2022 (UTC)