2d:null 2e:["$","title",null,{"children":"where are the heritages of our engineers | Johannes Mainusch | Observable"}] 33:Te7f,{ // 1. Bibliothek und Daten laden const d3geo = await import("d3-geo-projection@4"); // 2. Daten für die Tabelle vorbereiten const stats = data.data .filter(d => +d[settings.selectedCategory] > 0) .sort((a, b) => d3.descending(+a[settings.selectedCategory], +b[settings.selectedCategory])); // 3. Layout erstellen return html`

Herkunft der Personen ${settings.selectedCategory}

${stats.map(d => { // ISO-Code in Kleinbuchstaben für die Flaggen-API const iso = d["ISO-Code"] ? d["ISO-Code"].toLowerCase() : null; const flagUrl = iso ? `https://flagcdn.com/w40/${iso}.png` : `https://placehold.co/20x15?text=?`; return html` `} )}

Land	${settings.selectedCategory}
${d["Heritage/Countries of P&E"]}	${d[settings.selectedCategory]}

${Plot.plot({ projection: { type: d3geo.geoBromley, domain: { type: "MultiPoint", coordinates: [[-180, -90], [180, 90]] }, // 3. Dein Zoom-Regler steuert jetzt wieder den Inset inset: settings.zoom }, width: 900, height: 500, color: { type: "log", // Teilt die Daten in Farbstufen ein n: 20, scheme: "Blues", // Von Hellblau nach Dunkelblau label: "Anzahl Personen", domain: [1, d3.max(data.data, d => +d["how many of 253"])], legend: true, // Fügt eine Legende hinzu unknown: "#e0e0e0", tickFormat: "~s" }, marks: [ Plot.sphere({fill: "#e8e9fa"}), // Hintergrund Ozean Plot.graticule({stroke: "#ddd"}), // Gitterlinien Plot.geo(countries, { fill: d => { const entry = data.data.find(e => String(e["Numeric-ID"]).padStart(3, '0') === String(d.id).padStart(3, '0')); return entry && +entry["how many of 253"] > 0 ? +entry[settings.selectedCategory] : null; }, stroke: "white", strokeWidth: 0.4, title: d => { const entry = data.data.find(e => String(e["Numeric-ID"]).padStart(3, '0') === String(d.id).padStart(3, '0')); return entry ? `${entry["Heritage/Countries of P&E"]}: ${entry[settings.selectedCategory]}` : d.properties.name; } }) ] })}

`; }34:T486,data = { const GURL = 'https://docs.google.com/spreadsheets/d/' const GKEY = '16vaDnVTbPttLPF3ZiP0KymtQYOh-Uc3joqhHv9wqvk8' const GMAGIC = '/gviz/tq?tqx=out:csv' const GSN_sheet = '&sheet=CountriesOfD' const GdataUrl = GURL + GKEY + GMAGIC + GSN_sheet const getDataFromGoogle = (url) => { const ret = new Promise(function (resolve, reject) { ppp.parse(url, { download: true, header: true, transform: (value, header) => { // Wir prüfen, ob der Wert ein String ist und ein Komma enthält, // das eine Zahl sein könnte (z.B. "12,5") if (typeof value === "string" && value.includes(",")) { const replaced = value.replace(",", "."); // Versuche, es in eine Zahl umzuwandeln const parsed = parseFloat(replaced); // Wenn es eine gültige Zahl ist, gib sie zurück, sonst den Originalwert return isNaN(parsed) ? value : parsed; } return value; }, skipEmptyLines: true, complete: resolve, error: reject, }) }) return ret } return getDataFromGoogle (GdataUrl) }35:[] 31:{"id":"61c4ac349ba44665","slug":"where-are-the-heritages-of-our-engineers","title":"where are the heritages of our engineers","thumbnail":"b4bf1f0bb37117158611f3c4ec8ce45ab46a1f1c023933f7d7d7895feb465e1f","access_level":"public","create_time":"$D2026-02-04T20:56:12.011Z","update_time":"$D2026-02-07T12:59:40.421Z","view_time":null,"first_public_time":"$D2026-02-07T13:06:36.077Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"ae5e0aa7324794cc","login":"ahojsenn","name":"Johannes Mainusch","avatar_url":"https://avatars-next.observableusercontent.com/e0207661263f514787582149fc224d289f2498ae5ad80bd02aaa3145c65b94d2","tier":"starter_2024"},"version":256,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"277b45a6eb5af5e8","login":"ahojsenn","name":"Johannes Mainusch","avatar_url":"https://avatars-next.observableusercontent.com/e0207661263f514787582149fc224d289f2498ae5ad80bd02aaa3145c65b94d2","tier":null}],"members":[{"type":"individual","id":"277b45a6eb5af5e8","login":"ahojsenn","name":"Johannes Mainusch","avatar_url":"https://avatars-next.observableusercontent.com/e0207661263f514787582149fc224d289f2498ae5ad80bd02aaa3145c65b94d2","tier":null,"role":"editor"},{"type":"team","id":"ae5e0aa7324794cc","login":"ahojsenn","name":"Johannes Mainusch","avatar_url":"https://avatars-next.observableusercontent.com/e0207661263f514787582149fc224d289f2498ae5ad80bd02aaa3145c65b94d2","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"where are the heritages of our engineers","cells":[{"id":0,"value":"# where are the heritages of our engineers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":106,"value":"viewof settings = Inputs.form({\n // Eindeutige Namen für jeden Regler\n //lon: Inputs.range([0, 180], {step: 1, label: \"Längengrad (λ)\", value: 10}),\n //lat: Inputs.range([0, 90], {step: 1, label: \"Breitengrad (φ)\", value: 0}),\n //rot: Inputs.range([-150, 150], {step: 1, label: \"Rotation (γ)\", value: 0}), // Das ist dein dritter Wert\n zoom: Inputs.range([-300, 50], {step: 5, label: \"Zoom-Stärke\", value: 0}),\n selectedCategory: Inputs.select(categories, {\n label: \"Select int/all:\",\n value: categories[0]\n })\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"categories = data.meta.fields.slice(1,6)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"require(\"d3@7\")\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"topojson = require(\"topojson-client@3\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"world = fetch(\"https://cdn.jsdelivr.net/npm/world-atlas@2/countries-110m.json\").then(res => res.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"countries = topojson.feature(world, world.objects.countries)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"ppp = require('papaparse@5.3.2/papaparse.min.js')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":140,"value":"// In einer eigenen Zelle\nmutable hoveredCountry = null;","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 32:"$31:body"