2b:null 2c:["$","title",null,{"children":"LF4 - Antriebsart bei Landwirtschaftsfahrzeugen - Fahrzeugbestand | Office for Statistics and Data of the Canton of Zurich | Observable"}] 31:T10c4,viewof LF4_plot = vl .markBar({ // yOffset: 0, // height: 25, stroke: "white", strokeWidth: 1 }) .data( LF4_checkboxes.length > 0 ? data.filter( (d) => d.Variable != "Benzin, Diesel" && d.Variable != "Gas" && d.Variable != "Andere" && d.Variable != "Elektrofahrzeuge (ohne Hybrid)" && d.Einheit == LF4_radiosUnit ) : data.filter( (d) => d.Variable != "Elektrofahrzeuge (ohne Hybrid)" && d.Einheit == LF4_radiosUnit ) ) .transform( vl .calculate( "indexof([ 'Gas', 'Hybrid', 'Elektrisch', 'Andere'], datum.Variable)" ) .as("stackSortOrder") ) .encode( vl .y() .fieldQ("Wert") .title("↑ " + LF4_radiosUnit) .axis({ format: LF4_radiosUnit == units[1] ? "%" : null }) .scale({ domain: LF4_radiosUnit == units[1] && LF4_checkboxes.length == 1 ? [0, 0.1] : null }) .stack( LF4_radiosUnit == units[1] && LF4_checkboxes.length == 0 ? "normalize" : "zero" ), vl .x() .field("Jahr") .axis({ grid: false, domain: true, labelPadding: 8, zindex: 1 }) .title(null), vl .color({ title: "Antriebsart" }) .field("Variable") .scale(colorAntriebsart), vl.order("stackSortOrder"), vl.tooltip([ { field: "Jahr", title: "Jahr" }, { field: "Variable", title: "Antriebsart" }, { field: "Wert_txt", title: LF4_radiosUnit } ]), vl.facet({ field: "Gebiet", type: "nominal", columns: 1, spacing: 50, title: null }) ) .resolve({ scale: { y: "independent" }, axis: { x: "independent" } }) .width(plotWidth(1)) // specifying responsive width .height(350) // .title({ // text: // [...new Set(data.map((d) => d.Indikator_Name))] + // ", " + // gebiet[1] + // " und " + // gebiet[0], // subtitle: "In " + LF4_radiosUnit // }) .autosize({ resize: true, type: "fit" }) .config({ view: { stroke: null }, locale: { number: localeNumber, time: localeTime }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2, stroke: 2 }, background: "#ffffff", axis: { labelFont: "HelveticaNowRegular,Helvetica,sans-serif", labelFontSize: 14, labelColor: "black", titleFont: "HelveticaNowRegular,Helvetica,sans-serif", titleFontSize: 14, titleFontColor: "black" }, axisX: { tickCount: Math.ceil(width / 120), grid: false, domainColor: "lightgrey", tickColor: "lightgrey", labelAngle: 0, zindex: 1 }, axisY: { labelPadding: 10, titleAlign: "left", titleAngle: 0, titleX: 0, titleY: -20, tickCount: Math.ceil(height / 120), ticks: true, tickSize: 10, tickColor: "lightgrey", domain: false, domainColor: "lightgrey", gridColor: "lightgrey", labelLimit: 300 }, title: { font: "HelveticaNowBlack,Arial Black,Helvetica,sans-serif", fontSize: 20, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: "HelveticaNowRegular,Helvetica,sans-serif", subtitleFontSize: 18 }, header: { labelOrient: "top", labelPadding: 10, lineHeight: 3, labelFontSize: 16, labelFont: "HelveticaNowBlack,Arial Black,Helvetica,sans-serif", labelColor: "black", labelAnchor: "start", titleFont: "HelveticaNowBlack,Arial Black,Helvetica,sans-serif", titleAnchor: "start", titleColor: "black", titleFontSize: 16 }, legend: { orient: "top", symbolSize: 250, titleFont: "HelveticaNowBlack,Arial Black,Helvetica,sans-serif", titleFontSize: 14, labelFont: "HelveticaNowRegular,Helvetica,sans-serif", labelFontSize: 14, labelColor: "black", labelLimit: 300, columns: nCol, // responsive legend width padding: 10 }, text: { font: "HelveticaNowRegular,Helvetica,sans-serif", fontSize: 14, color: "black" } }) .render()32:[] 2f:{"id":"cfbfafcdff30f72b","slug":null,"title":"LF4 - Antriebsart bei Landwirtschaftsfahrzeugen - Fahrzeugbestand","thumbnail":"0eb30a29d623e3b0c04109458b19e50eb5ef2aeae83e598aa283a1714ed82317","access_level":"public","create_time":"$D2023-05-04T11:31:22.213Z","update_time":"$D2023-07-11T13:32:39.998Z","view_time":null,"first_public_time":"$D2023-07-06T12:35:01.517Z","has_unpublished_edits":null,"fork":{"id":"9e05532a76cb1384","slug":null,"title":"LF2 - Abgedeckte Güllelager","owner":{"id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich"}},"stars":0,"starred":false,"owner":{"type":"team","id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich","avatar_url":"https://avatars-next.observableusercontent.com/61364635cd5db7a914727e7625ac41daa90fedeba239e3d2ce93b57a9ad3bce9","tier":"pro"},"version":1997,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"32d8f5276b0e4535","login":"cgrb","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a7d9a10b8456291ccefbc9c7c7b9ecdc5d5f31095c0a77bdea09bd75590057bc","tier":null}],"members":[{"type":"individual","id":"32d8f5276b0e4535","login":"cgrb","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a7d9a10b8456291ccefbc9c7c7b9ecdc5d5f31095c0a77bdea09bd75590057bc","tier":null,"role":"editor"},{"type":"team","id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich","avatar_url":"https://avatars-next.observableusercontent.com/61364635cd5db7a914727e7625ac41daa90fedeba239e3d2ce93b57a9ad3bce9","tier":"pro","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"5e3d875f95e398da","slug":"decarb-monitoring-awel","title":"AWEL - Decarb-Monitoring","owner":{"id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich"}},"type":"notebook","body":{"title":"LF4 - Antriebsart bei Landwirtschaftsfahrzeugen - Fahrzeugbestand","cells":[{"id":0,"value":"# LF4 - Antriebsart bei Landwirtschaftsfahrzeugen - Fahrzeugbestand","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1811,"value":"viewof LF4_checkboxes = Inputs.checkbox(\n [\"Nur alternative Antriebsarten anzeigen\"],\n {\n label: null,\n value: [null]\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1798,"value":"viewof LF4_radiosUnit = Inputs.radio(units, {\n // label: \"Einheit wählen\",\n value: \"Prozent (%)\",\n sort: \"descending\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1935,"value":"LF4_title = htl.html`\n

${\n [...new Set(data.map((d) => d.Indikator_Name))] +\n \", \" +\n gebiet[1] +\n \" und \" +\n gebiet[0]\n}

${viewof LF4_radiosUnit}

${viewof LF4_checkboxes}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1497,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1427,"value":"LF4_caption = html`

Quelle: ${[\n ...new Set(data.map((d) => d.Datenquelle))\n]}. Daten zur Grafik herunterladen

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":757,"value":"---\n## Parameters","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1950,"value":"margin = ({\n top: 30,\n right: 10,\n bottom: 30,\n left: 50\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":196,"value":"barHeight = 35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":192,"value":"chartHeight = 150 + barHeight + years.length * (barHeight * years.length + 10) // Anzahl Jahr * Balkenhöhe + Margin","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1952,"value":"svgHeight = 450","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":194,"value":"plotWidth = function (nPlots) {\n if (nPlots == 1) {\n // Entspricht Mobile\n if (width < 415) {\n return width * 0.88;\n } else if (width >= 415 && width < 768) {\n return width * 0.855;\n // Entspricht Tablets\n } else if (width >= 768 && width <= 1248) {\n return width * 0.877;\n // Entspricht Laptops & Desktops\n } else {\n return 1128 * 0.9275;\n }\n } else {\n // Entspricht Mobile\n if (width < 768) {\n return (width * 1.4) / nPlots;\n // Entspricht Tablets\n } else if (width >= 768 && width <= 1248) {\n return (width * 1.6) / nPlots;\n // Entspricht Laptops & Desktops\n } else {\n return (1128 * 0.92) / nPlots;\n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1948,"value":"height = svgHeight - margin.top - margin.bottom","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":713,"value":"colorAntriebsart = LF4_checkboxes.length > 0\n ? {\n domain: [\"Hybrid\", \"Elektrisch\"],\n range: [\"#7F3DA7\", \"#8A8C00\"]\n // range: [\"#dc7700\", \"#D93C1A\", \"#9572d5\", \"#009ee0\", \"#1a7f1f\", \"#cccccc\"]\n }\n : {\n domain: [\"Benzin, Diesel\", \"Gas\", \"Hybrid\", \"Elektrisch\", \"Andere\"],\n range: [\"#666666\", \"#7F3DA7\", \"#00797B\", \"#8A8C00\", \"#cccccc\"]\n // range: [\n // \"#96170f\",\n // \"#dc7700\",\n // \"#D93C1A\",\n // \"#9572d5\",\n // \"#009ee0\",\n // \"#1a7f1f\",\n // \"#cccccc\"\n // ]\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"// Sets the locale for Vega-Lite axis, but not for text in tooltip (CMS does not recognise)\nlocaleNumber = await d3.json(\n \"https://cdn.jsdelivr.net/npm/d3-format@3/locale/de-CH.json\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"localeTime = await d3.json(\n \"https://raw.githubusercontent.com/d3/d3-time-format/main/locale/de-CH.json\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1792,"value":"nCol = {\n if (width >= 1100) {\n return antriebsarten.length;\n } else if (width < 1100 && width >= 750) {\n return 3;\n } else {\n return 1;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1913,"value":"filteredData = LF4_checkboxes.length == 0\n ? data.filter(\n (d) =>\n d.Variable !== \"Elektrofahrzeuge (ohne Hybrid)\" &&\n d.Einheit == LF4_radiosUnit\n )\n : data.filter(\n (d) =>\n d.Variable !== \"Benzin, Diesel\" &&\n d.Variable !== \"Elektrofahrzeuge (ohne Hybrid)\" &&\n d.Einheit == LF4_radiosUnit\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1873,"value":"y_domain = LF4_radiosUnit != \"Prozent (%)\"\n ? [0, d3.max(filteredData, (d) => d.Wert) * 1.2]\n : [0, 1]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":764,"value":"---\n\n## Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1989,"value":"dataPath = \"https://raw.githubusercontent.com/statistikZH/decarb_monitoring/main/output/LF4_data.csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1375,"value":"data = d3\n .csv(dataPath)\n // FileAttachment(\"LF4_data@2.csv\")\n // .csv()\n .then(function (data) {\n data.forEach(function (d) {\n d.xTime = d3.timeParse(\"%Y\")(d.Jahr); // xTime is time used for x scale so different year's data can share the x scale\n d.Wert = +d.Wert; // Values to numeric\n d.Wert_txt =\n d.Einheit == \"Prozent (%)\"\n ? d.Wert.toLocaleString(undefined, {\n style: \"percent\",\n minimumFractionDigits: 1,\n maximumFractionDigits: 2\n })\n : d.Wert.toLocaleString(\"de-CH\");\n });\n return data;\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":526,"value":"years = [...new Set(d3.map(data, (d) => d.Jahr))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1386,"value":"gebiet = [...new Set(d3.map(data, (d) => d.Gebiet))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1379,"value":"units = [...new Set(d3.map(data, (d) => d.Einheit))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1803,"value":"antriebsarten = [...new Set(d3.map(data, (d) => d.Variable))]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1691,"value":"labelTxt = d3.group(\n data.filter((d) => d.Einheit == LF4_radiosUnit),\n (d) => d.Gebiet, // data.filter((d) => d.Einheit == A2_radiosUnit), // d3.group(\n (d, i) => {\n return i % 3 == 2; // i starts with 0 and i%5 == 2 is every fifth element starting with the 2nd in the array\n }\n)\n// data.filter((d, i) => {\n// return i % 4 == 2; // i starts with 0 and i%5 == 2 is every fifth element starting with the 2nd in the array\n// })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1360,"value":"Inputs.table(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"---\n## Functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":163,"value":"function wrangleData(data) {\n const groupedByYear = Array.from(\n d3.rollup(\n data,\n (v) => {\n if (v.length === 1) {\n return v[0];\n } else {\n return Object.assign({}, v[0], {\n value: d3.sum(v, (d) => d.value),\n location: \"CH\"\n });\n }\n },\n (d) => d.year,\n (d) => d.date\n ),\n ([key, values]) => ({\n key,\n values: Array.from(values.values())\n })\n );\n groupedByYear.forEach((d) =>\n d.values.forEach((e, i) => {\n if (i === 0) {\n e.total = e.value;\n } else {\n e.total = e.value + d.values[i - 1].total;\n }\n })\n );\n return groupedByYear;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"// displayData = wrangleData(konkurse)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"---\n## Imports & dependencies","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":42,"value":"import { vl } from \"@vega/vega-lite-api-v5\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":289,"value":"d3 = require(\"d3@6\", \"d3-array@^3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"