31:T557,🇳🇱: *Nederlanders van Eemshaven tot Epen* Reading Jeffrey Baker's notebook [Californians from Oregon to Mexico](/@jwb/californians-from-oregon-to-mexico) and Benjamin Schmidt's [New Yorkers from Canada to the Amboys](/@bmschmidt/new-yorkers-from-canada-to-the-amboys), I got curious about the same chart for the whole country of the Netherlands, all the way from Eemshaven up north to Epen down south. The Netherlands is not big but it packs a bit over 17.5 million people, quite a lot in a small area. Each dot represents a single ‘wijk’, a statistical division meaning something like 'tract' or 'district'. They’re determined by the municipalities themselves, so they’re pretty arbitrary. Each ‘wijk’ is shown at the latitude of its centroid. Hover your mouse over a dot to show the name of the wijk and its number of inhabitants. A wijk is defined by CBS as: > a part of a municipality, consisting of one or more 'buurten' (neighborhoods). Often a wijk corresponds to a town or part of a larger town. ^ Special Caribbean municipalities Bonaire, Saba & Sint Eustatius excluded and a few ['wijken'](#leftOvers) I was not able to match too ## Source * [CBS Wijk- en buurtkaart](https://www.cbs.nl/nl-nl/dossier/nederland-regionaal/geografische-data/wijk-en-buurtkaart-2022)32:T58d,Plot.plot({ height: 5000, width: 1000, y: { label: "↑ degrees latitude north" }, x: { domain: [0.01, 0.99], ticks: 0 }, color: { type: "categorical", scheme: "tableau10" }, marks: [ Plot.rectY(bigCitiesBounds, { y1: "minLat", y2: "maxLat", fill: "#ccc", fillOpacity: 0.2, title: "city" }), Plot.dot( wijkenClean, Plot.dodgeX({ y: "lat", r: "bevolking", title: (d) => `Provincie ${d.provincie} ${d.gemeente} ${d.wijk} ${d.bevolking} inhabitants`, fill: colorBy, strokeWidth: 2, anchor: "middle" }) ), Plot.text( wijkenClean, Plot.dodgeX({ filter: (d) => d.bevolking > 20_000, y: "lat", r: "bevolking", text: (d) => (d.bevolking / 1e3).toFixed() + "k", fill: "black", anchor: "middle", dy: 0.2 }) ), Plot.ruleY([bounds.maxLat]), Plot.ruleY([bounds.minLat]), Plot.text(cities, { y: "lat", x: 0.975, text: "text", frameAnchor: "right", fontSize: 15 }), Plot.text(paragraphs, { y: "lat", x: 0.8, lineWidth: 17.5, text: "text", frameAnchor: "left" }), Plot.text(quantiles, { y: "lat", x: 0.05, fontSize: 15, text: "text", fill: "grey", frameAnchor: "left" }) ] })33:T613,paragraphs = [ { text: "Schiermonnikoog is an island and both the least populous and least densely populated municipality", lat: 53.48 }, { text: "With 200 000 inhabitants Groningen is the largest city north of Amsterdam", lat: 53.24 }, { text: "Drenthe is 'the empty province', it's the Netherlands least densely populated province at 188 inh/km²", lat: 52.83 }, { text: "Almere was built in the 70's to house the growing population of Amsterdam", lat: 52.38 }, { text: "Amsterdam is the capital and most populous city with a poulation of 907 000", lat: 52.34 }, { text: "Limburg is a long and narrow 'appendix' of a province. Here it's at its narrowest, only around 5 km from the German to Belgian border! No wonder there's not a lot of people living here.", lat: 51.07 }, { text: "Zuid-Holland contains the 2nd and 3rd largest cities and is the most densely populated province with 1374 inh/km², over 7 times the density of Drenthe!", lat: 52 }, { text: "Slightly over half of Limburgs population lives in the southernmost region of the province", lat: 50.91 }, { text: "With 383 000 inhabitants Zeeland is the least populous province", lat: 51.5 }, { lat: 52.04, text: "The Hague is the most densely populated city with 6 707 inh/km²" }, { lat: 52.3, text: "Almost half the nations population lives in the 'Randstad' conurbation which comprises the 4 largest cities; Amsterdam, Rotterdam, the Hague, and Utrecht" } ]34:T18e9,gemeentesPerProvincieObj = ({ Drenthe: [ "Aa en Hunze", "Assen", "Borger-Odoorn", "Coevorden", "Emmen", "Hoogeveen", "Meppel", "Midden-Drenthe", "Noordenveld", "Tynaarlo", "Westerveld", "De Wolden" ], Flevoland: [ "Almere", "Dronten", "Lelystad", "Noordoostpolder", "Urk", "Zeewolde" ], Friesland: [ "Achtkarspelen", "Ameland", "Dantumadiel", "De Fryske Marren", "Harlingen", "Heerenveen", "Leeuwarden", "Noardeast-Fryslân", "Ooststellingwerf", "Opsterland", "Schiermonnikoog", "Smallingerland", "Súdwest-Fryslân", "Terschelling", "Tytsjerksteradiel", "Vlieland", "Waadhoeke", "Weststellingwerf" ], Gelderland: [ "Aalten", "Apeldoorn", "Arnhem", "Barneveld", "Berg en Dal", "Berkelland", "Beuningen", "Bronckhorst", "Brummen", "Buren", "Culemborg", "Doesburg", "Doetinchem", "Druten", "Duiven", "Ede", "Elburg", "Epe", "Ermelo", "Harderwijk", "Hattem", "Heerde", "Heumen", "Lingewaard", "Lochem", "Maasdriel", "Montferland", "Neder-Betuwe", "Nijkerk", "Nijmegen", "Nunspeet", "Oldebroek", "Oost Gelre", "Oude IJsselstreek", "Overbetuwe", "Putten", "Renkum", "Rheden", "Rozendaal", "Scherpenzeel", "Tiel", "Voorst", "Wageningen", "West Betuwe", "West Maas en Waal", "Westervoort", "Wijchen", "Winterswijk", "Zaltbommel", "Zevenaar", "Zutphen" ], Groningen: [ "Eemsdelta", "Groningen", "Het Hogeland", "Midden-Groningen", "Oldambt", "Pekela", "Stadskanaal", "Veendam", "Westerkwartier", "Westerwolde" ], Limburg: [ "Beek", "Beekdaelen", "Beesel", "Bergen (L.)", "Brunssum", "Echt-Susteren", "Eijsden-Margraten", "Gennep", "Gulpen-Wittem", "Heerlen", "Horst aan de Maas", "Kerkrade", "Landgraaf", "Leudal", "Maasgouw", "Maastricht", "Meerssen", "Mook en Middelaar", "Nederweert", "Peel en Maas", "Roerdalen", "Roermond", "Simpelveld", "Sittard-Geleen", "Stein", "Vaals", "Valkenburg aan de Geul", "Venlo", "Venray", "Voerendaal", "Weert" ], "Noord-Brabant": [ "Alphen-Chaam", "Altena", "Asten", "Baarle-Nassau", "Bergeijk", "Bergen op Zoom", "Bernheze", "Best", "Bladel", "Boekel", "Boxtel", "Breda", "Cranendonck", "Deurne", "Dongen", "Drimmelen", "Eersel", "Eindhoven", "Etten-Leur", "Geertruidenberg", "Geldrop-Mierlo", "Gemert-Bakel", "Gilze en Rijen", "Goirle", "Halderberge", "Heeze-Leende", "Helmond", "'s-Hertogenbosch", "Heusden", "Hilvarenbeek", "Laarbeek", "Land van Cuijk", "Loon op Zand", "Maashorst", "Meierijstad", "Moerdijk", "Nuenen, Gerwen en Nederwetten", "Oirschot", "Oisterwijk", "Oosterhout", "Oss", "Reusel-De Mierden", "Roosendaal", "Rucphen", "Sint-Michielsgestel", "Someren", "Son en Breugel", "Steenbergen", "Tilburg", "Valkenswaard", "Veldhoven", "Vught", "Waalre", "Waalwijk", "Woensdrecht", "Zundert" ], "Noord-Holland": [ "Aalsmeer", "Alkmaar", "Amstelveen", "Amsterdam", "Bergen (NH.)", "Beverwijk", "Blaricum", "Bloemendaal", "Castricum", "Den Helder", "Diemen", "Dijk en Waard", "Drechterland", "Edam-Volendam", "Enkhuizen", "Gooise Meren", "Haarlem", "Haarlemmermeer", "Heemskerk", "Heemstede", "Heiloo", "Hilversum", "Hollands Kroon", "Hoorn", "Huizen", "Koggenland", "Landsmeer", "Laren", "Medemblik", "Oostzaan", "Opmeer", "Ouder-Amstel", "Purmerend", "Schagen", "Stede Broec", "Texel", "Uitgeest", "Uithoorn", "Velsen", "Waterland", "Wijdemeren", "Wormerland", "Zaanstad", "Zandvoort", "Weesp" ], Overijssel: [ "Almelo", "Borne", "Dalfsen", "Deventer", "Dinkelland", "Enschede", "Haaksbergen", "Hardenberg", "Hellendoorn", "Hengelo", "Hof van Twente", "Kampen", "Losser", "Oldenzaal", "Olst-Wijhe", "Ommen", "Raalte", "Rijssen-Holten", "Staphorst", "Steenwijkerland", "Tubbergen", "Twenterand", "Wierden", "Zwartewaterland", "Zwolle" ], Utrecht: [ "Amersfoort", "Baarn", "De Bilt", "Bunnik", "Bunschoten", "Eemnes", "Houten", "IJsselstein", "Leusden", "Lopik", "Montfoort", "Nieuwegein", "Oudewater", "Renswoude", "Rhenen", "De Ronde Venen", "Soest", "Stichtse Vecht", "Utrecht", "Utrechtse Heuvelrug", "Veenendaal", "Vijfheerenlanden", "Wijk bij Duurstede", "Woerden", "Woudenberg", "Zeist" ], Zeeland: [ "Borsele", "Goes", "Hulst", "Kapelle", "Middelburg", "Noord-Beveland", "Reimerswaal", "Schouwen-Duiveland", "Sluis", "Terneuzen", "Tholen", "Veere", "Vlissingen" ], "Zuid-Holland": [ "Alblasserdam", "Albrandswaard", "Alphen aan den Rijn", "Barendrecht", "Bodegraven-Reeuwijk", "Brielle", "Capelle aan den IJssel", "Delft", "'s-Gravenhage", "Dordrecht", "Goeree-Overflakkee", "Gorinchem", "Gouda", "Hardinxveld-Giessendam", "Hellevoetsluis", "Hendrik-Ido-Ambacht", "Hillegom", "Hoeksche Waard", "Kaag en Braassem", "Katwijk", "Krimpen aan den IJssel", "Krimpenerwaard", "Lansingerland", "Leiden", "Leiderdorp", "Leidschendam-Voorburg", "Lisse", "Maassluis", "Midden-Delfland", "Molenlanden", "Nieuwkoop", "Nissewaard", "Noordwijk", "Oegstgeest", "Papendrecht", "Pijnacker-Nootdorp", "Ridderkerk", "Rijswijk", "Rotterdam", "Schiedam", "Sliedrecht", "Teylingen", "Vlaardingen", "Voorschoten", "Waddinxveen", "Wassenaar", "Westland", "Westvoorne", "Zoetermeer", "Zoeterwoude", "Zuidplas", "Zwijndrecht" ] })35:[{"id":"b292894de913bb6f76a026f03d9ef025f522f54bba39c322a5237320247fc52d5cd1955912a0888165c85475f9f62f80784eda39afbc9e4213fcbe6d2e840312","href":"https://static.observableusercontent.com/files/b292894de913bb6f76a026f03d9ef025f522f54bba39c322a5237320247fc52d5cd1955912a0888165c85475f9f62f80784eda39afbc9e4213fcbe6d2e840312","name":"wijken.json","type":"application/json","lastModified":1660257991906.348,"size":3256556},{"id":"b952dadd83b3c9fd46db24195bd081c4b88744eb6b3a6d5ffae27420a70c53a43a59080449aaeab8c17af7a5042bc16ffa39d871a627b13790bcb2b4635c6091","href":"https://static.observableusercontent.com/files/b952dadd83b3c9fd46db24195bd081c4b88744eb6b3a6d5ffae27420a70c53a43a59080449aaeab8c17af7a5042bc16ffa39d871a627b13790bcb2b4635c6091","name":"kerncijfers_wijken_en_buurten_2021@13.csv","type":"text/csv","lastModified":1660324799643.454,"size":722203}] 2f:{"title":"Dutch People from Eemshaven to Epen","cells":[{"id":0,"value":"# Dutch People from Eemshaven to Epen\n\n","pinned":false,"hidden":false,"mode":"md"},{"id":978,"value":"freelanceBanner","pinned":false,"hidden":false,"mode":"ojs"},{"id":976,"value":"$31","pinned":false,"hidden":false,"mode":"md"},{"id":613,"value":"viewof colorBy = Inputs.radio([\"provincie\", \"gemeente\"], {\n label: \"Color by\",\n value: \"provincie\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":86,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":967,"value":"## See Also\n\nThe same but from West to East","pinned":false,"hidden":false,"mode":"md"},{"id":946,"value":"preview({\n path: \"@julesblm/dutch-people-from-sluis-to-schanze-bad-nieuweschans\",\n thumbnail: \"dc374d20002435e13a34ae86fc12e880c8f33ceaf1085c00fa9f324ab838150c\",\n title: \"Dutch People from Sluis to Schanze (Bad Nieuweschans)\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":118,"value":"## Data","pinned":false,"hidden":false,"mode":"md"},{"id":942,"value":"function preview(\n { path, title, author, thumbnail },\n { target = \"_blank\" } = {}\n) {\n return htl.html`\n (event.currentTarget.firstElementChild.style.borderColor =\n \"#1b1e23\")} onmouseout=${(event) =>\n (event.currentTarget.firstElementChild.style.borderColor = \"#e8e8e8\")}>\n

${title}

\n`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":801,"value":"// this is a pretty rough, not-super-correct calculation\nquantiles = {\n const formatPercentage = d3.format(\".0%\");\n const wijkenNorthToSouth = wijkenClean.sort((a, b) =>\n d3.descending(a.lat, b.lat)\n );\n const cumulative = d3.cumsum(wijkenNorthToSouth, (d) => d.bevolking);\n\n const quantiles = [0.1, 0.25, 0.5, 0.75, 0.9];\n const indices = quantiles.map((n) => d3.quantileIndex(cumulative, n));\n\n return indices.map((wijkIndex, i) => ({\n lat: wijkenNorthToSouth[wijkIndex - 1].lat,\n text: `${formatPercentage(1 - quantiles[i])} live south of here (aprox.)`,\n wijkIndex: wijkIndex - 1\n }));\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":364,"value":"cities = [\n { text: \"Groningen\", lat: 53.216667 },\n { text: \"Utrecht\", lat: 52.1 },\n { text: \"Amsterdam\", lat: 52.36 },\n { text: \"The Hague\", lat: 52.065 },\n { text: \"Rotterdam\", lat: 51.916667 },\n { text: \"Eindhoven\", lat: 51.455 },\n { text: \"Tilburg\", lat: 51.55 },\n { text: \"Breda\", lat: 51.588889 },\n { text: \"Nijmegen\", lat: 51.8475 },\n { text: \"Maastricht\", lat: 50.85 },\n { text: \"Den Bosch\", lat: 51.683333 },\n { text: \"Amersfoort\", lat: 52.15 },\n { text: \"Zwolle\", lat: 52.516667 },\n { text: \"Enschede\", lat: 52.216667 },\n { text: \"Arnhem\", lat: 51.983333 },\n { text: \"Almere\", lat: 52.4 }\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":478,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":516,"value":"gemeentesPerProvincie = new Map(Object.entries(gemeentesPerProvincieObj))","pinned":false,"hidden":false,"mode":"ojs"},{"id":480,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":100,"value":"population = FileAttachment(\"kerncijfers_wijken_en_buurten_2021@13.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":44,"value":"centers = wijken.features.map((d) => {\n const match = population.find((e) => {\n const isDuplicateName = duplicateWijkNames.has(e[\"wijk-buurt\"]);\n const isNameMatch =\n e[\"wijk-buurt\"].toLowerCase() === d.properties.wijk.toLowerCase();\n\n // if the wijknames is not unique check the gemeente too\n // the population and map data are from different years and in between some gemeentes have merged\n return isDuplicateName\n ? isNameMatch && e.gemeente === d.properties.gemeente\n : isNameMatch;\n });\n\n const center = turf.center(d);\n\n let provincie;\n for (const provincieG of gemeentesPerProvincie) {\n if (provincieG[1].includes(d.properties.gemeente)) {\n provincie = provincieG[0];\n }\n }\n\n const centerCoords = center.geometry.coordinates;\n\n return {\n ...d.properties,\n provincie,\n bevolking: match?.bevolking ? Number(match.bevolking) : undefined,\n lon: centerCoords[0],\n lat: centerCoords[1]\n };\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":258,"value":"bounds = getBounds(centers)","pinned":false,"hidden":false,"mode":"ojs"},{"id":384,"value":"bigCities = [\"Amsterdam\", \"Rotterdam\", \"'s-Gravenhage\", \"Utrecht\", \"Eindhoven\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":386,"value":"bigCitiesBounds = bigCities.map((city) => {\n const cityData = centers.filter((d) => d.gemeente === city);\n return { ...getBounds(cityData), city };\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":381,"value":"getBounds = (features) => {\n const maxLon = d3.max(features, (d) => d.lon);\n const maxLat = d3.max(features, (d) => d.lat);\n\n const minLon = d3.min(features, (d) => d.lon);\n const minLat = d3.min(features, (d) => d.lat);\n\n return { maxLon, maxLat, minLon, minLat };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":207,"value":"// Don't know how to match these :(\nleftOvers = centers.filter(\n (d) => typeof d.bevolking === \"undefined\" && d.wijk !== \"Groot water\"\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":280,"value":"wijkenClean = centers.filter((d) => Boolean(d.bevolking))","pinned":true,"hidden":false,"mode":"ojs"},{"id":227,"value":"duplicateWijkNames = new Set(\n wijken.features\n .map((d) => d.properties.wijk)\n .filter((e, i, a) => a.indexOf(e) !== i)\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"wijken = FileAttachment(\"wijken.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":55,"value":"// turf = import(\"https://cdn.skypack.dev/@turf/turf\")\nturf = require(\"@turf/turf\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":980,"value":"import { freelanceBanner } from \"@julesblm/freelance-banner\"","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W35","stdlib":"1","titling":"auto"}