31:T80a,map = { // Initialize the map const m = eurostatmap .map("choropleth") .width(width) .height(height) .title("Custom geometries example") .subtitle("Unemployment rate, municipality level, 2023") .geometries([ { id: "regions", class: "regions", statisticalRegions: true, features: municipalGeometries.features // onEach: (elements) => { // // Add any D3 custom styling or behavior here // } }, { id: "borders", features: borderGeometries.features, class: "borders" } ]) .classificationMethod("threshold") .thresholds([1, 3, 4, 5, 6, 7, 8, 9]) .colorFunction(d3.interpolateYlGnBu) .zoomExtent([1, 10]) .projectionFunction(projection) .legend({ title: "Unemployment %", x: 5, y: 180, boxOpacity: 0.8, decimals: 0 }) .footnote( 'Source: datos.gob.es' ) .insetBoxPosition([5, 490]) .insets([ { projectionFunction: canariesProjection, title: "Canarias", geometries: [ { id: "canaries", class: "canaries", statisticalRegions: true, features: canariesFeatures } ], width: canariesWidth, height: canariesHeight, x: 0, y: 0, zoomExtent: [1, 10] }, { projectionFunction: melillaProjection, title: "Melilla", geometries: [ { id: "melilla", class: "melilla", statisticalRegions: true, features: melillaFeatures } ], width: melillaWidth, height: melillaHeight, x: 350, y: 0, zoomExtent: [1, 10] } ]); // .labels({ values: true }) // Set statistical data for the map m.statData().setData(statisticalData); // Build the map m.build(); return m; }32:T56b,mergedData = unemploymentCsv.map((row) => { // Step 1: Clean whitespace from all keys (in case of leading spaces) const cleanedRow = {}; for (const key in row) { cleanedRow[key.trim()] = row[key]; } // Step 2: Swap code/name fields if necessary const codeRaw = cleanedRow["Codigo Municipio"]; const nameRaw = cleanedRow["Municipio"]; const isCodeBroken = !/^\d+$/.test(codeRaw?.trim()); const isNameActuallyCode = /^\d+$/.test(nameRaw?.trim()); if (isCodeBroken && isNameActuallyCode) { // Swap the fields const temp = cleanedRow["Codigo Municipio"]; cleanedRow["Codigo Municipio"] = cleanedRow["Municipio"]; cleanedRow["Municipio"] = temp; } // Step 3: Fix clearly broken "total Paro Registrado" (should be numeric) if (!/^\d+$/.test(cleanedRow["total Paro Registrado"])) { // Try to recover from a known column like "Paro hombre edad < 25" const fallbackTotal = [ "Paro hombre edad < 25", "Paro mujer edad < 25" ].reduce((sum, k) => { const val = parseInt(cleanedRow[k]); return sum + (isNaN(val) ? 0 : val); }, 0); cleanedRow["total Paro Registrado"] = fallbackTotal || null; } // Step 4: Attempt merge const code = String(cleanedRow["Codigo Municipio"] || "").replace(/^0+/, ""); const match = populationLookup[code]; return match ? { ...cleanedRow, ...match } : cleanedRow; })33:[{"id":"ac1064a437bc8319c26ca53e65636245a6c9bd0dd0e1f4fa7e8b90824aee8e73911fee3988c6084e5e554e6f60d72673cc8f07d619dfa5a6b61f75b071a2a1e9","href":"https://static.observableusercontent.com/files/ac1064a437bc8319c26ca53e65636245a6c9bd0dd0e1f4fa7e8b90824aee8e73911fee3988c6084e5e554e6f60d72673cc8f07d619dfa5a6b61f75b071a2a1e9","name":"spain_borders.json","type":"application/json","lastModified":1750152859966.525,"size":100853},{"id":"d75d10ed5beee02fe239638ba0ed43fc7ef2834eb02cf0d7582e648c5932f3c601fcb70f29a4a04c34e171cd0f34379aed85ed62d7a1878692cdbbe67cc7644d","href":"https://static.observableusercontent.com/files/d75d10ed5beee02fe239638ba0ed43fc7ef2834eb02cf0d7582e648c5932f3c601fcb70f29a4a04c34e171cd0f34379aed85ed62d7a1878692cdbbe67cc7644d","name":"spain-municipalities.topojson.json","type":"application/json","lastModified":1750152861729.95,"size":1818537},{"id":"215919319cce7ea3dbd60bf6b0eea6725fd256bdfe1d91dd7939016e2e93ea955589e4e32cc958140247c0de8e86bf162e1826dd9ab3fbcf1eec430241729322","href":"https://static.observableusercontent.com/files/215919319cce7ea3dbd60bf6b0eea6725fd256bdfe1d91dd7939016e2e93ea955589e4e32cc958140247c0de8e86bf162e1826dd9ab3fbcf1eec430241729322","name":"Paro_por_municipios_2023_csv.csv","type":"text/csv","lastModified":1750152860501.516,"size":844468},{"id":"bd9b175ee945713331bc15a00fbbb65261cbe443712f40f8e0dc30367ab3b1707fcd81e7fb8c2fd8860cae464a80b1496eaad0eda850c98f0df10b08cb60291a","href":"https://static.observableusercontent.com/files/bd9b175ee945713331bc15a00fbbb65261cbe443712f40f8e0dc30367ab3b1707fcd81e7fb8c2fd8860cae464a80b1496eaad0eda850c98f0df10b08cb60291a","name":"poblacion.csv","type":"text/csv","lastModified":1750152983861.999,"size":202945}] 2f:{"title":"Eurostat-map: custom geometries","cells":[{"id":0,"value":"# Eurostat-map: custom geometries","pinned":false,"hidden":false,"mode":"md"},{"id":262,"value":"You can add whatever regions you like to eurostat-map with: \n\n```javascript \n.geometries([\n {\n id: \"regions\",\n class: \"regions\",\n statisticalRegions: true, // tells eurostat-map to link your stat data to them (via feature.properties.id)\n features: yourRegions.features \n // onEach: (elements) => {\n // // Add any D3 custom styling or behavior here\n // }\n },\n {\n id: \"borders\",\n features: yourBorders.features, \n class: \"borders\"\n }\n ])\n```","pinned":false,"hidden":false,"mode":"md"},{"id":90,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":94,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":87,"value":"height = 600","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":77,"value":"## Geometries","pinned":false,"hidden":false,"mode":"md"},{"id":109,"value":"### Canarias","pinned":false,"hidden":false,"mode":"md"},{"id":114,"value":" // define canarias\ncanariesWidth = 200;\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":116,"value":"canariesHeight = 90","pinned":false,"hidden":false,"mode":"ojs"},{"id":102,"value":"canariesFeatures = municipalGeometries.features.filter(\n (d) => d.id.startsWith(\"380\") || d.id.startsWith(\"350\")\n)\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":107,"value":"canariesProjection = d3\n .geoAzimuthalEqualArea()\n .rotate([15.8, -28.5]) // Center around the Canary Islands\n .scale(2300) // Adjust scale as needed\n .translate([\n canariesWidth / 2, // Center with horizontal padding\n canariesHeight / 2 // Center with vertical padding\n ]);","pinned":false,"hidden":false,"mode":"ojs"},{"id":122,"value":"### Melilla","pinned":false,"hidden":false,"mode":"md"},{"id":127,"value":"melillaWidth = 100;\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":129,"value":"melillaHeight = 90","pinned":false,"hidden":false,"mode":"ojs"},{"id":125,"value":"melillaFeatures = municipalGeometries.features.filter((d) =>\n d.id.startsWith(\"52001\")\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":134,"value":"melillaProjection = d3\n .geoAzimuthalEqualArea()\n .rotate([2.95, -35.3]) // Center around Melilla\n .scale(50000) // Adjust scale as needed\n .translate([\n melillaWidth / 2, // Center with horizontal padding\n melillaHeight / 2 // Center with vertical padding\n ])","pinned":false,"hidden":false,"mode":"ojs"},{"id":138,"value":"### Mainland","pinned":false,"hidden":false,"mode":"md"},{"id":141,"value":"projection = d3.geoAzimuthalEqualArea().rotate([1.5, -40.55]).scale(3000)","pinned":false,"hidden":false,"mode":"ojs"},{"id":51,"value":"municipalTopojson = FileAttachment(\"spain-municipalities.topojson.json\").json()","pinned":true,"hidden":false,"mode":"ojs"},{"id":57,"value":"bordersTopojson = FileAttachment(\"spain_borders.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":44,"value":"municipalGeometries = {\n const geoms = topojson.feature(\n municipalTopojson,\n municipalTopojson.objects[Object.keys(municipalTopojson.objects)[0]]\n );\n\n // Add id to properties\n geoms.features.forEach((feature) => {\n feature.properties.id = feature.id;\n });\n\n const bannedIds = [\"20015\", \"53065\"];\n geoms.features = geoms.features.filter(\n (geom) => !bannedIds.includes(geom.id)\n );\n\n return geoms;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"borderGeometries = topojson.feature(\n bordersTopojson,\n bordersTopojson.objects[Object.keys(bordersTopojson.objects)[0]]\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":81,"value":"## Statistical data","pinned":false,"hidden":false,"mode":"md"},{"id":40,"value":"// Transform merged data to code:value object\nstatisticalData = mergedData.reduce((acc, row) => {\n // Handle unemployment value, setting \"<5\" to \"5\" and parsing as an integer\n let unemployment =\n row[\"total Paro Registrado\"] === \"<5\"\n ? 5\n : parseThousandsDelimiter(row[\"total Paro Registrado\"]);\n\n // Parse population\n const population = parsePopulation(row.total);\n\n // Calculate percentage unemployed and add to accumulator\n const unemploymentRate = Math.round((unemployment / population) * 100);\n acc[row[\"Codigo Municipio\"]] = isNaN(unemploymentRate)\n ? \":\"\n : unemploymentRate;\n\n return acc;\n}, {})\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":32,"value":"function parseThousandsDelimiter(value) {\n if (typeof value === \"string\" || typeof value === \"number\") {\n return parseInt(String(value).replace(/\\./g, \"\"), 10);\n }\n return NaN; // or return null if you prefer\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"function parsePopulation(value) {\n if (!value) return NaN;\n return parseInt(String(value).replace(/\\./g, \"\"), 10);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":236,"value":"lookupCode = 26011","pinned":true,"hidden":false,"mode":"ojs"},{"id":220,"value":"statisticalData[lookupCode]","pinned":true,"hidden":false,"mode":"ojs"},{"id":180,"value":"populationLookup[lookupCode]","pinned":true,"hidden":false,"mode":"ojs"},{"id":186,"value":"unemploymentLookup[lookupCode]","pinned":true,"hidden":false,"mode":"ojs"},{"id":256,"value":"unemploymentCsv.find((d) =>\n Object.values(d).some((val) => String(val).includes(lookupCode))\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":228,"value":"mergedData.find((d) => d[\"Codigo Municipio\"] == lookupCode)","pinned":true,"hidden":false,"mode":"ojs"},{"id":18,"value":"$32","pinned":true,"hidden":false,"mode":"ojs"},{"id":182,"value":"unemploymentLookup = unemploymentCsv.reduce((lookup, row) => {\n let code = row[\"Codigo Municipio\"];\n\n // If 'Codigo Municipio' is actually a name, and ' Municipio' contains a numeric code, use that instead\n if (!/^\\d+$/.test(code) && /^\\d+$/.test(row[\" Municipio\"])) {\n code = row[\" Municipio\"];\n }\n\n // Normalize code: trim, split, and strip leading zeros\n code = code.toString().trim().split(\" \")[0].replace(/^0+/, \"\");\n\n lookup[code] = row;\n return lookup;\n}, {})","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"populationLookup = populationCsv.reduce((lookup, row) => {\n const code = row.id.split(\" \")[0].replace(/^0+/, \"\"); // Remove leading zeros from the code\n lookup[code] = row;\n return lookup;\n}, {})","pinned":false,"hidden":false,"mode":"ojs"},{"id":7,"value":"unemploymentCsv = FileAttachment(\"Paro_por_municipios_2023_csv.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"populationCsv = FileAttachment(\"poblacion.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":75,"value":"## Dependencies","pinned":false,"hidden":false,"mode":"md"},{"id":260,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":83,"value":"eurostatmap = require(\"eurostat-map\")","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}