2d:null 2e:["$","title",null,{"children":"Kiesstatistik | Office for Statistics and Data of the Canton of Zurich | Observable"}] 33:T8a4,plot1 = vl .data(abbauEinbau) .encode( vl.x().fieldT("jahr_str").timeUnit("year"), vl.y().fieldQ("wert").title("Volumen, in Mio. m\u00B3 fest") ) .layer( vl.markPoint({ size: 50, filled: true }).encode( vl .color() .fieldN("Indikator") .title(null) .legend(null) .scale({ domain: ["Aushubeinbau", "Kiesabbau"], range: ["#00797B", "#7F3DA7"] }), vl.shape().fieldN("Indikator").title(null).legend(null), vl.tooltip([ { field: "Jahr", title: "Jahr" }, { field: "Indikator", title: "Indikator" }, { field: "Wert", title: "Volumen" } ]) ), vl.markLine({ size: 3 }).encode(vl.color().fieldN("Indikator").title(null)), vl.markText({ align: "left", dx: 10 }).encode( vl.text(vl.fieldN("Indikator")), vl.x({ aggregate: "max", field: "jahr_str" }), // x-Position at the 'max' value for field "jahr_str" vl.y({ aggregate: { argmax: "jahr_str" }, field: "wert" }) // argmax for getting the last value in a line for label placement ) ) .width(plotWidth(1)) // specifying responsive width .height(300) .autosize({ type: "fit", resize: true }) .config({ view: { stroke: null }, background: "#ffffff", padding: { top: 5, bottom: 5, left: 5, right: 5 }, axis: { labelFont: "Arial Black", labelColor: "black", titleFont: "Arial Black", titleFontColor: "black", titleFontSize: 14 }, axisX: { labelFont: "Arial Black", labelFontSize: 12, tickCount: { signal: Math.ceil(chartWidth / 80) }, // grid: true, ticks: true, title: null }, axisY: { titleAlign: "left", titleAngle: 0, titleX: -20, titleY: -10, labelFont: "Arial", labelFontSize: 12, titleFont: "Arial Black", titleFontSize: 12, tickCount: { signal: Math.ceil(chartHeight / 40) }, grid: false }, legend: { labelFontSize: 12, labelFont: "Arial", labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5 }, text: { font: "Arial", fontSize: 13, color: "black" } }) .render()34:Taa4,plot2 = vl .markBar({ cornerRadiusTopRight: 3, cornerRadiusBottomRight: 3, yOffset: 10, height: 60, stroke: "white" }) .data(regionen) .transform( vl .calculate( "indexof(['Zürcher Unterland', 'Zürcher Oberland', 'Weinland', 'Winterthur und Umgebung', 'Glattal', 'Knonaueramt'], datum.indikator)" ) .as("stackSortOrder") ) .encode( vl.x().fieldQ("pct").stack("normalize"), vl .y() .fieldO("indikator") .scale({ padding: 0 }) .axis({ bandPosition: 0, grid: false, domain: false, ticks: false, labelAlign: "left", labelBaseline: "middle", labelPadding: 0, labelOffset: -30 }) .sort(["Kiesabbau", "Aushubeinbau"]), vl .color() .fieldO("region") .scale({ domain: [ "Zürcher Unterland", "Zürcher Oberland", "Weinland", "Winterthur und Umgebung", "Glattal", "Knonaueramt" ], range: [ "#7F3DA7", "#00797B", "#a77f3d", "#0070B4", // "#0076BD", "#B01657", "#666666" ], reverse: false }), vl.order("stackSortOrder"), vl.tooltip([ { field: "region", title: "Region" }, { field: "indikator", title: "Indikator" }, { field: "wert_txt", title: "Anteil" } ]) ) .width(plotWidth(1)) // specifying responsive width .height(275) .autosize({ resize: true, type: "fit" }) .config({ view: { stroke: null }, // scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2, stroke: 2 }, background: "#ffffff", axis: { labelFont: "Arial Black", labelColor: "black", titleFont: "Arial Black", titleFontSize: 13, titleFontColor: "black" }, axisX: { labelFont: "Arial Black", labelFontSize: 12, format: "%", tickCount: 7, title: null }, axisY: { labelPadding: 10, title: null, ticks: false, labelLimit: 300, labelFontSize: 13 }, title: { font: "Arial Black", fontSize: 16, offset: 15, anchor: "start", lineHeight: 1.5, subtitleFont: "Helvetica", subtitleFontSize: 14 }, legend: { orient: "top", symbolSize: 250, labelFontSize: 12, labelFont: "Arial", labelColor: "black", labelLimit: 300, columns: nCol_Legend, // responsive legend width rowPadding: 5, title: null }, title: { fontSize: 16, color: "black", offset: 15, anchor: "center" }, text: { font: "Arial", fontSize: 16, color: "black" } }) .render()35:Tad4,plot3 = vl .data(kiesreserven.filter((d) => d.jahr >= fourYearsAgo)) .layer( vl .markBar({ cornerRadiusTopRight: 3, cornerRadiusBottomRight: 3, yOffset: 10, height: 60, stroke: "white", fill: "#7F3DA7" }) .encode( vl.y().fieldO("jahr").scale({ padding: 0 }).axis({ bandPosition: 0, grid: false, domain: false, ticks: false, labelAlign: "left", labelBaseline: "middle", labelPadding: 0, labelOffset: -30 }), vl.x().fieldQ("wert").axis({ title: "Kiesreserven, in Mio. m³ fest" }) ), vl .markText({ align: "right", fill: "white", fontWeight: "bold", dx: -5 }) .data(kiesreserven.filter((d) => d.jahr >= fourYearsAgo)) .encode( vl.y().fieldO("jahr"), vl .x() .fieldQ("wert") .scale({ domain: [0, 110] }), vl.color(), vl.text().fieldN("Wert") ) // vl // .markText({ // align: "right", // fill: "white", // dx: -5 // }) // .data( // restvolumen.filter( // (d) => d.indikator == "Festgesetzt" && d.jahr >= fourYearsAgo // ) // ) // .transform(vl.calculate("split(datum.Wert, ' ')").as("Split_Wert")) .encode( vl.y().fieldO("jahr"), vl .x() .fieldQ("wert") .scale({ domain: [0, 110] }), vl.color(), vl.text().fieldN("Wert") ) ) .width(plotWidth(1)) // specifying responsive width .height(550) .autosize({ resize: true, type: "fit" }) .config({ view: { stroke: null }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2, stroke: 2 }, background: "#ffffff", axis: { labelFont: "Arial Black", labelColor: "black", titleFont: "Arial Black", titleFontSize: 13, titleFontColor: "black" }, axisX: { labelFontSize: 12, tickCount: 7, ticks: true, grid: true }, axisY: { title: null, ticks: false, labelLimit: 300, labelFontSize: 13 }, title: { font: "Arial Black", fontSize: 16, offset: 15, anchor: "start", lineHeight: 1.5, subtitleFont: "Arial", subtitleFontSize: 14 }, legend: { orient: "top", symbolSize: 250, labelFontSize: 12, labelFont: "Arial", labelColor: "black", labelLimit: 300, columns: 2, rowPadding: 5, title: null }, text: { font: "Arial", fontSize: 12, baseline: "line-top" } }) .render()36:T793,plot4 = vl .markBar() .data(bahnanteil) .encode( // vl.column().fieldN("indikator").title(null), vl .facet() .fieldN("indikator") .align("all") .columns(nCol) .title(null) .sort(["Aushubeinbau", "Kiesabbau", "Summe"]), vl.x().fieldN("jahr").timeUnit("year").axis({ zindex: 1 }), vl.y().fieldQ("wert").axis({ format: "%", title: null }), vl .color() .fieldN("indikator") .legend(null) .scale({ range: ["#00797B", "#7F3DA7", "#a77f3d"] }), vl.fillOpacity({ value: 0.8, condition: [{ selection: "hover", value: 1 }] }), vl.tooltip().fieldN("Wert") ) .select({ hover: { type: "single", empty: "all", on: "mouseover" } }) .width(plotWidth(3)) // specifying responsive width for each individual plot .height(250) .autosize({ type: "fit", resize: true }) .config({ view: { stroke: null }, facet: { spacing: 20, tickCount: { signal: Math.ceil(plotWidth / 80) } }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", // padding: 20, axis: { labelColor: "black", labelFontSize: 12, titleFont: "Arial Black", titleFontSize: 13, titleFontColor: "black" }, axisX: { labelFont: "Arial Black", labelAngle: 0, title: null, ticks: true, domain: true, tickCount: { signal: Math.ceil(plotWidth / 80) }, grid: false }, axisY: { axis: "left", grid: true, ticks: true }, legend: { orient: "top", labelFontSize: 12, labelFont: "Arial", labelColor: "black", // maxExtent: 250, title: null }, title: { fontSize: 16, color: "black", offset: 15, anchor: "center" }, header: { labelOrient: "top", labelPadding: 6, labelFontSize: 13, labelFont: "Arial Black", labelColor: "black" } }) .render()37:Tc4d,plot6 = vl .data( aushubproben_pct.filter( (d) => d.category != "Ausgeführt" && d.jahr >= fourYearsAgo ) ) .transform( vl .calculate( "indexof(['Mit Überschreitung', 'Ohne Überschreitung'], datum.category)" ) .as("stackSortOrder") ) .layer( vl .markBar({ cornerRadiusTopRight: 3, cornerRadiusBottomRight: 3, yOffset: 10, height: 60, stroke: "white" }) .encode( vl.y().fieldO("jahr").scale({ padding: 0 }).axis({ bandPosition: 0, grid: false, domain: false, ticks: false, labelFont: "Arial Black", labelColor: "black", labelAlign: "left", labelBaseline: "middle", labelPadding: 0, labelOffset: -30 }), vl.x().fieldQ("value"), vl .color() .fieldO("category") .sort(["Ohne Überschreitung", "Mit Überschreitung"]) .scale({ domain: ["Mit Überschreitung", "Ohne Überschreitung"], range: ["#7F3DA7", "#949494"], reverse: false }), vl.order("stackSortOrder") ), vl .markText({ align: "right", fill: "white", dx: -5 }) .data( aushubproben_pct.filter( (d) => d.category == "Mit Überschreitung" && d.jahr >= fourYearsAgo ) ) .encode( vl.y().fieldO("jahr"), vl.x().fieldQ("value"), vl.color(), vl.text().fieldN("Wert") ), vl .markText({ align: "right", fill: "white", dx: -5 }) .data( aushubproben_pct.filter( (d) => d.category == "Ohne Überschreitung" && d.jahr >= fourYearsAgo ) ) .encode( vl.y().fieldO("jahr"), vl.x().fieldQ("Wert"), vl.color(), vl.text().fieldQ("Wert") ) ) .width(plotWidth(1)) // specifying responsive width .height(550) .autosize({ resize: true, type: "fit" }) .config({ view: { stroke: null }, // scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2, stroke: 2 }, background: "#ffffff", axis: { labelFont: "Arial Black", labelColor: "black", titleFont: "Arial Black", titleFontSize: 13, titleFontColor: "black" }, axisX: { labelFontSize: 12, format: "%", tickCount: 7, ticks: true, grid: true, title: null }, axisY: { title: null, ticks: false, labelLimit: 300, labelFontSize: 13 }, title: { font: "Arial Black", fontSize: 16, offset: 15, anchor: "start", lineHeight: 1.5, subtitleFont: "Arial", subtitleFontSize: 14 }, legend: { orient: "top", symbolSize: 250, labelFontSize: 12, labelFont: "Arial", labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: "Arial", fontSize: 12, baseline: "line-top" } }) .render()38:T47c,cssStyles = html` `39:T8da,plot2_horizontal = vl .markBar() .data(regionen) .transform( vl .calculate( "indexof(['Zürcher Unterland', 'Zürcher Oberland', 'Weinland', 'Winterthur und Umgebung', 'Glattal', 'Knonaueramt'], datum.indikator)" ) .as("stackSortOrder") ) .encode( vl.y().fieldQ("pct").stack("normalize").axis({ format: "%", title: null }), vl.x().fieldO("indikator").axis({ title: null }), vl .color() .fieldO("region") .scale({ domain: [ "Knonaueramt", "Glattal", "Winterthur und Umgebung", "Weinland", "Zürcher Oberland", "Zürcher Unterland" ], range: [ "#666666", "#B01657", "#0076BD", "#a77f3d", "#00797B", "#7F3DA7" ], reverse: false }), vl.order("stackSortOrder"), vl.tooltip([ { field: "region", title: "Region" }, { field: "indikator", title: "Indikator" }, { field: "pct", title: "Anteil" } ]) ) .width(chartWidth) // specifying responsive width .height(chartHeight) .autosize({ type: "fit-x", resize: false, contains: "padding" }) .config({ view: { stroke: null }, background: "#ffffff", padding: { top: 5, bottom: 5, left: 5, right: 5 }, axis: { labelFontSize: 12, labelFont: "Helvetica", labelColor: "black", titleFontSize: 14, titleColor: "black", titleFont: "Helvetica", titleFontWeight: "normal" }, axisX: { tickCount: { signal: Math.ceil(chartWidth / 80) }, grid: true, ticks: true, labelFont: "Arial Black", labelFontSize: 12, labelAngle: 0, labelPadding: 10, grid: true, title: null }, axisY: { tickCount: { signal: Math.ceil(chartHeight / 80) }, grid: false }, legend: { orient: "top", symbolSize: 250, labelFontSize: 12, labelFont: "Arial", labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, title: { fontSize: 16, color: "black", offset: 15, anchor: "center" }, text: { font: "Helvetica", fontSize: 16, color: "black" } }) .render()3a:[{"id":"826a16eb055229aa66695e5cf4ab0b145aef6b4f84bfc1d8882ba883a2851615b5d1e7715426b1f36c1757ca890c2cfe46a0e64bdb30597215835a3331d7cce1","href":"https://static.observableusercontent.com/files/826a16eb055229aa66695e5cf4ab0b145aef6b4f84bfc1d8882ba883a2851615b5d1e7715426b1f36c1757ca890c2cfe46a0e64bdb30597215835a3331d7cce1","name":"KTZH_00000736_00001881 (1).csv","type":"text/csv","lastModified":1685022629859.518,"size":9793}] 31:{"id":"0ab84a8838652b32","slug":"kiesstatistik","title":"Kiesstatistik","thumbnail":"de351ae9bd1bbd54a0f9e109126886bc25dfafb5a8528e8436ec3195c7d505e6","access_level":"public","create_time":"$D2021-10-26T06:39:57.053Z","update_time":"$D2023-05-25T14:05:02.038Z","view_time":null,"first_public_time":"$D2022-10-26T05:55:18.760Z","has_unpublished_edits":null,"fork":false,"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":1715,"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":null,"type":"notebook","body":{"title":"Kiesstatistik","cells":[{"id":4,"value":"htl.html`

Kiesstatistik

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"txt1 = htl.html`

Kiesabbau und Aushubeinbau, ${d3.min(\n abbauEinbau,\n (d) => d.jahr_str\n)}-${d3.max(abbauEinbau, (d) => d.jahr_str)}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1516,"value":"q1 = htl.html`

Volumen und Gewicht: In vorliegender Statistik werden Festkubikmeter als Volumenmass verwendet. Für einen\nFestkubikmeter wird mit 2 Tonnen gerechnet.

\n\n

Quelle: AWEL, Kiesstatistik

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":298,"value":"txt2 = htl.html`

Kiesabbau und Aushubeinbau nach Regionen, ${lastYear}

Das Zürcher Unterland ist die wichtigste Abbauregion im Kanton Zürich. Rund 80% des Kiesabbaus und des Aushubeinbaus finden hier statt.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1345,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1041,"value":"q2 = htl.html`

Hinweis: Dargestellt sind Regionen mit einem Volumen > 0 m³.

\n\n

Quelle: AWEL, Kiesstatistik

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":368,"value":"txt3 = htl.html`

Kiesreserven

Die Kiesreserven ergeben sich aus den im Richtplan gesicherten Reserven zuzüglich der Reserven aus den Gebieten in Nutzung.\nDie Kiesreserven reichen bei einem Kiesbedarf von jährlich 3 Mio. m³ für über 20 Jahre.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1050,"value":"q3 = htl.html`

Quelle: AWEL, Kiesstatistik

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":381,"value":"txt4 = htl.html`

Bahnanteil

Die Vorgabe aus dem kantonalen Richtplan, wonach mindestens 35% der abgebauten und abzulagernden Menge in der Summe mit der Bahn transportiert werden muss, wird nicht erfüllt.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":384,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":911,"value":"q4 = htl.html`

Bei der Zeitreihe \"Summe\" handelt es sich um einen mit der Transportmenge gewichteten Mittelwert.

Quelle: AWEL, Kiesstatistik

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":235,"value":"txt5 = htl.html`

Offene Flächen

Zur Schonung des Landschaftsbildes und der Fruchtfolgeflächen soll die offene Gesamtfläche aller im kantonalen Richtplan festgelegten Materialgewinnungsgebiete stabil gehalten werden (Richtwert 400 ha).

\n\n

${lastYear} betrug die offene Fläche ${\n restflaeche.filter((d) => d.jahr == lastYear)[0][\"Wert\"]\n}.\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":669,"value":"txt6 = htl.html`

Aushubproben

Im Schnitt ist pro Auffüllgebiet eine Probe auf 4'000 m³ Aushub lose zu nehmen und analysieren zu lassen. Die Überschreitungen der Grenzwerte lassen sich hauptsächlich auf organische Parameter (Kohlenwasserstoffe, PAK) zurückführen.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1057,"value":"q6 = htl.html`

Quelle: AWEL, Kiesstatistik

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"htl.html`

Anhang

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"htl.html`

Daten

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"// Fetch data directly from ftp server\ndataImport = d3.csv(\n \"https://www.web.statistik.zh.ch/ogd/daten/ressourcen/KTZH_00000736_00001881.csv\",\n { typed: true }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"data = tidy(\n dataImport,\n mutate({\n wert: (d) => +d.wert,\n Jahr: (d) => +d.jahr\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"abbauEinbau = tidy(\n data,\n filter(\n (d) =>\n d.region === \"Kanton Zürich\" && d.thema == \"Kiesabbau\" && d.jahr >= 1990\n ),\n mutate({\n Wert: (d) => (d.wert / 1e6).toFixed(1) + \" Mio.\" + d.einheit,\n wert: (d) => d.wert / 1e6\n }),\n rename({ indikator: \"Indikator\", jahr: \"jahr_str\" })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"regioData = data\n .filter((d) => d.wert > 0 && d.thema == \"Regionen\")\n .sort(desc((d) => d.wert))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"regionen = tidy(\n regioData,\n groupBy(\"indikator\", [summarize({ total: sum(\"wert\") })]),\n leftJoin(regioData, { by: \"indikator\" }),\n mutate({\n pct: (d) => d.wert / d.total,\n wert_txt: (d) => (d.pct * 100).toFixed(1) + \" %\"\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"restflaeche = tidy(\n data,\n filter((d) => d.thema == \"Betriebsfläche\"),\n mutate({ Wert: (d) => d.wert + \" ha\" })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":386,"value":"bahnanteil = tidy(\n data,\n filter((d) => d.thema == \"Bahnanteil\" && d.jahr >= 2010),\n mutate({ Wert: (d) => d.wert + \"%\", wert: (d) => d.wert / 100 })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1674,"value":"kiesreserven = tidy(\n data,\n filter((d) => d.thema == \"Kiesreserven\"),\n pivotWider({\n namesFrom: \"indikator\",\n valuesFrom: \"wert\"\n }),\n pivotLonger({\n cols: [\"Kiesreserven\"],\n namesTo: \"indikator\",\n valuesTo: \"wert\"\n }),\n mutate({ Wert: (d) => d.wert.toFixed(0) })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":256,"value":"aushubproben = tidy(\n data,\n filter((d) => d.thema == \"Aushubproben\"),\n pivotWider({\n namesFrom: \"indikator\",\n valuesFrom: \"wert\"\n }),\n // compute deltas by year\n groupBy(\"jahr\", [\n mutate({\n withoutExceeding: (d) =>\n TMath.subtract(d.Ausgeführt, d[\"Mit Grenzwertüberschreitung\"])\n })\n ]),\n rename({ withoutExceeding: \"Ohne Grenzwertüberschreitung\" }),\n pivotLonger({\n cols: [\n \"Ausgeführt\",\n \"Mit Grenzwertüberschreitung\",\n \"Ohne Grenzwertüberschreitung\"\n ],\n namesTo: \"indikator\",\n valuesTo: \"wert\"\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":261,"value":"aushubproben_pct = tidy(\n aushubproben,\n // 1. transform data structure to wide format\n pivotWider({\n namesFrom: \"indikator\",\n valuesFrom: \"wert\"\n }),\n // 2. group by each year\n groupBy(\"jahr\"),\n\n // 2. compute the percent of total. use rate() to safely\n // handle division by zero and nully values.\n mutate({\n percent: rate(\"Mit Grenzwertüberschreitung\", \"Ausgeführt\"),\n diff: (d) => 1 - d.percent\n }),\n rename({\n \"Mit Grenzwertüberschreitung\": \"Negative Proben\",\n percent: \"Mit Überschreitung\",\n diff: \"Ohne Überschreitung\"\n }),\n pivotLonger({\n cols: [\"Mit Überschreitung\", \"Ohne Überschreitung\"],\n namesTo: \"category\",\n valuesTo: \"value\"\n }),\n mutate({ Wert: (d) => (d.value * 100).toFixed(1) + \"%\" })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"Inputs.table(aushubproben_pct)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"htl.html`

Parameters

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":68,"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":1280,"value":"chartWidth = d3.min([width, 1168])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1286,"value":"chartHeight = 300","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1196,"value":"nCol = {\n if (width >= 1100) {\n return 3;\n } else if (width < 1100 && width >= 750) {\n return 2;\n } else {\n return 1;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1450,"value":"nCol_Legend = {\n if (width >= 1100) {\n return 6;\n } else if (width < 1100 && width >= 750) {\n return 3;\n } else {\n return 2;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"formatTime = d3.timeFormat(\"%Y\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"regions = [...new Set(regionen.map((d) => d.region))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"dimRestvolumen = [\n ...new Set(\n kiesreserven\n // .filter((d) => d.indikator != \"Festgesetzt\")\n .map((d) => d.indikator)\n )\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"lastYear = d3.max(data, (d) => d.jahr) // formatTime(d3.timeYear.offset(new Date(), -1))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":267,"value":"twoYearsAgo = formatTime(d3.timeYear.offset(new Date(lastYear), -2))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"fourYearsAgo = formatTime(d3.timeYear.offset(new Date(lastYear), -4))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"avg3Years = tidy(\n aushubproben_pct.filter(\n (d) => d.jahr >= fourYearsAgo && d.jahr <= twoYearsAgo\n ),\n summarize({\n executed: mean(\"Ausgeführt\"),\n negative: mean(\"Negative Proben\")\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":292,"value":"htl.html`

Style

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":295,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"htl.html`

Imports

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"import { vl } from \"@vega/vega-lite-api\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"import {\n tidy,\n select,\n summarize,\n groupBy,\n leftJoin,\n sum,\n rate,\n pivotWider,\n pivotLonger,\n mutate,\n mutateWithSummary,\n summarizeAll,\n arrange,\n TMath,\n rename,\n total,\n totalAt,\n map,\n cumsum,\n mean,\n roll,\n desc,\n asc,\n filter,\n distinct,\n when\n} from \"@pbeshai/tidyjs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"bannerImage = function (url, title, pageTitle = title) {\n const { id, href } = DOM.uid(\"banner\");\n return html`\n

${title}

\n $\"${title}\"$ \n \n `;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":301,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3a","stdlib":"1","titling":"auto"}} 32:"$31:body"