2b:null 2c:["$","title",null,{"children":"PKS: Straftaten nach Gesetzen | Office for Statistics and Data of the Canton of Zurich | Observable"}] 31:T12a0,sng_plot = { // select a point for which to provide details-on-demand const hover = vl .selectPoint("hover") .encodings("x") // limit selection to x-axis value .on("mousemove") // select on mouseover events .toggle(false) // disable toggle on shift-hover .nearest(true); // select data point nearest the cursor // predicate to test if a point is hover-selected // return false if the selection is empty const isHovered = hover.empty(false); // define our base area chart const area = vl .markArea({ stroke: "white" }) .encode( vl .color() // .legend(null) .fieldN("Gesetz_Abk") .scale({ domain: ["StGB", "BetmG", "AIG"], range: ["#0070B4", "#D40053", "#00544C"], reverse: false }) ); // shared base for new layers, filtered to hover selection const base = area.transform(vl.filter(isHovered)); // mark properties for text label layers const label = { align: "left", baseline: "middle", dx: 5, dy: -5 }; const white = { stroke: "white", strokeWidth: 3 }; return ( vl .data(dataByLaw) .transform( vl .calculate("indexof(['AIG', 'BetmG', 'StGB'], datum.Gesetz_Abk)") .as("stackSortOrder") ) .encode( vl.x().fieldT("date").timeUnit("year"), vl.y().fieldQ("total").title("Anzahl Straftaten"), vl.order("stackSortOrder") ) .layer( area, // add a rule mark to serve as a guide line vl .markRule({ color: "#ffffff", strokeWidth: 2 }) .transform(vl.filter(isHovered)) .encode( vl.x().fieldT("date").timeUnit("year"), vl.y({ aggregate: "sum", field: "total", type: "quantitative", stack: "zero" }), vl.order("stackSortOrder") ), // add circle marks for selected time points, hide unselected points area .markCircle({ stroke: "white", strokeWidth: 1.5, size: 60 }) .params(hover) // use as anchor points for selection .encode( vl.y({ aggregate: "sum", field: "total", type: "quantitative", stack: "zero" }), vl.opacity().if(isHovered, vl.value(1)).value(0), vl.order("stackSortOrder") ), // add white stroked text to provide a legible background for labels base.markText(label, white).encode( vl.y({ aggregate: "sum", field: "total", type: "quantitative", stack: "zero" }), vl.text().field("text"), vl.order("stackSortOrder") ), // add text labels for stock prices base.markText(label).encode( vl.y({ aggregate: "sum", field: "total", type: "quantitative", stack: "zero" }), vl.text().field("text"), vl.order("stackSortOrder") ) ) .width(chartWidth(1)) // specifying responsive width .height(450) .autosize({ resize: true, type: "fit" }) // .title({ // text: "Straftaten nach Gesetzen" // // subtitle: "Total Straftaten, Kanton Zürich" // }) .config({ locale: { number: locale }, view: { stroke: null }, background: "#ffffff", padding: { top: 5, bottom: 5, left: 0, right: 25 }, axis: { labelFontSize: 13, labelColor: "black" }, axisX: { labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(chartWidth / 80) }, grid: true, ticks: true, title: null }, axisY: { titleAlign: "left", titleAngle: 270, titleX: -50, labelFont: ZHFonts.regular, labelFontSize: 12, titleFont: ZHFonts.regular, titleFontSize: 12, tickCount: { signal: Math.ceil(chartHeight / 40) }, grid: false }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", // lineHeight: 1.5, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: 1, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14, color: "black" } }) .render() ); }32:T813,sng_plot1_2 = vl .markBar({ cornerRadiusTopRight: 3, cornerRadiusBottomRight: 3, height: 50, yOffset: 10, stroke: "white" }) .data(dataByOffences) .transform(vl.calculate(stackOrder).as("stackSortOrder")) .encode( vl.x().fieldQ("total").title("Anzahl Straftaten"), //.stack("normalize"), vl.y().fieldO("Ausgangsjahr").scale({ padding: 0 }).axis({ bandPosition: 0, grid: false, domain: false, ticks: false, labelAlign: "left", labelBaseline: "middle", labelPadding: 0, labelOffset: -25 }), vl.color().fieldO("Haupttitel").scale(color), vl.order("stackSortOrder"), vl.tooltip([ { field: "Ausgangsjahr", title: "Jahr" }, { field: "Haupttitel", title: "Haupttitel" }, { field: "total_txt", title: "Straftaten" } ]) ) .width(chartWidth(1)) // specifying responsive width .height(550) .autosize({ resize: true, type: "fit-x" }) // .title(plotTitle) .config({ locale: { number: locale }, view: { stroke: null }, background: "#ffffff", padding: { top: 5, bottom: 5, left: 0, right: 25 }, axis: { labelFontSize: 13, labelColor: "black" }, axisX: { labelFont: ZHFonts.regular, labelFontSize: 12, titleFont: ZHFonts.black, titleFontSize: 12, tickCount: 7, title: null }, axisY: { labelPadding: 10, title: null, ticks: false, labelLimit: 300, labelFont: ZHFonts.black }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 1.5, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, legend: { orient: "top", gridAlign: "none", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: labelLimit, rowPadding: 5, columns: nCol_Legend, // responsive legend width title: null }, text: { font: ZHFonts.regular, fontSize: 20, color: "black" } }) .render()33:[] 2f:{"id":"7870732bd9817815","slug":null,"title":"PKS: Straftaten nach Gesetzen","thumbnail":"b6a5e8c67f09f640b3eea6b0238e3d71cdd1671544821e9ce4d4be5d7db30656","access_level":"public","create_time":"$D2022-02-23T00:10:14.063Z","update_time":"$D2024-09-05T06:02:32.190Z","view_time":null,"first_public_time":"$D2022-10-26T05:57:41.331Z","has_unpublished_edits":null,"fork":true,"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":1474,"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":2,"collection":null,"type":"notebook","body":{"title":"PKS: Straftaten nach Gesetzen","cells":[{"id":0,"value":"# PKS: Straftaten nach Gesetzen\n\nData source: [OGD-Ressource 'Anzahl Straftaten nach Tatbestand ganzer Kanton' (CSV)](https://www.web.statistik.zh.ch/ogd/daten/ressourcen/KTZH_00001202_00002278.csv)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1421,"value":"Module name prefix: sng_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1442,"value":"sng_title = htl.html`\n

Straftaten nach Gesetz

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1041,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":137,"value":"---\n## Straftaten nach Gesetz und Haupttitel","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1186,"value":"viewof sng_inputLaws = Inputs.radio(laws, {\n label: \"Gesetz wählen\",\n value: \"StGB\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1446,"value":"sng_plot1_2_titel = htl.html`\n

${viewof sng_inputLaws}

Straftaten des ${sng_inputLaws}

Anzahl Straftaten nach Haupttiteln, Kanton Zürich

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":592,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"----\n## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":12,"value":"### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1208,"value":"dataImport = d3.csv(\n \"https://www.web.statistik.zh.ch/ogd/daten/ressourcen/KTZH_00001202_00002278.csv\",\n { typed: true }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"dataByLaw = tidy(\n dataImport,\n filter((d) => d.Ausgangsjahr >= lastYear - 9),\n groupBy(\n [\"Ausgangsjahr\", \"Gesetz_Abk\"],\n summarize({ total: sum(\"Straftaten_total\") })\n ),\n mutate({\n Jahr: (d) => `${d.Ausgangsjahr}`,\n date: (d) => parseTime(d.Ausgangsjahr),\n total_txt: (d) => d.total.toLocaleString(\"de-CH\"),\n text: (d) => d.Gesetz_Abk + \": \" + d.total.toLocaleString(\"de-CH\")\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"dataByOffences = tidy(\n dataImport,\n filter((d) => d.Ausgangsjahr > lastYear - 5 && d.Gesetz_Abk == sng_inputLaws),\n groupBy(\n [\"Ausgangsjahr\", \"Haupttitel\"],\n summarize({ total: sum(\"Straftaten_total\") })\n ),\n mutate({\n Haupttitel: (d) => d.Haupttitel.split(\"Total \").pop(),\n date: (d) => parseTime(d.Ausgangsjahr),\n total_txt: (d) => d.total.toLocaleString(\"de-CH\")\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":368,"value":"offences = [...new Set(dataByOffences.map((d) => d.Haupttitel))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":952,"value":"laws = [...new Set(dataByLaw.map((d) => d.Gesetz_Abk))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":971,"value":"lastYear = d3.max(dataImport, (d) => d.Ausgangsjahr)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":931,"value":"parseTime = d3.timeParse(\"%Y\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1415,"value":"Inputs.table(dataImport)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"### Code for Formatting","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1228,"value":"// Sets the locale for Vega-Lite axis, but not for text in tooltip (CMS does not recognise)\nlocale = 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":281,"value":"// set up domain and range for color scale by law\ncolor = (function () {\n if (sng_inputLaws == \"StGB\") {\n return {\n domain: [\n \"gegen sexuelle Integrität\",\n \"gegen Leib und Leben\",\n \"gegen die Freiheit\",\n \"gegen das Vermögen\",\n \"übrige Titel StGB\"\n ],\n range: [\"#00407c\", \"#0070b4\", \"#009ee0\", \"#7ab6e2\", \"#cccccc\"]\n };\n } else if (sng_inputLaws == \"AIG\") {\n return {\n domain: [\n \"Täuschung der Behörden\",\n \"Förderung der rechtswidrigen Ein- / Ausreise / Aufenthalt\",\n \"illegale Erwerbstätigkeit oder Beschäftigung\",\n \"rechtswidrige Ein- / Ausreise / Aufenthalt\",\n \"weitere Widerhandlungen gegen AIG\"\n ],\n range: [\"#00544c\", \"#00797b\", \"#0fa693\", \"#6bc9cb\", \"#cccccc\"]\n };\n } else if (sng_inputLaws == \"BetmG\") {\n return {\n domain: [\"Übertretungen\", \"leichte Fälle\", \"schwere Fälle\"],\n range: [\"#7a0049\", \"#b01657\", \"#d40053\"]\n };\n }\n})()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1001,"value":"stackOrder = (function () {\n if (sng_inputLaws == \"StGB\") {\n return \"indexof(['gegen sexuelle Integrität', 'gegen Leib und Leben', 'gegen die Freiheit', 'gegen das Vermögen', 'übrige Titel StGB'], datum.Haupttitel)\";\n } else if (sng_inputLaws == \"AIG\") {\n return \"indexof(['Täuschung der Behörden', 'Förderung der rechtswidrigen Ein- / Ausreise / Aufenthalt', 'illegale Erwerbstätigkeit oder Beschäftigung', 'rechtswidrige Ein- / Ausreise / Aufenthalt', 'weitere Widerhandlungen gegen AIG'], datum.Haupttitel)\";\n } else if (sng_inputLaws == \"BetmG\") {\n return \"indexof(['Übertretungen', 'leichte Fälle', 'schwere Fälle'], datum.Haupttitel)\";\n }\n})()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1017,"value":"// plotTitle = (function () {\n// if (inputLaws == \"StGB\") {\n// return {\n// text: \"Straftaten des StGB\",\n// subtitle: \"Anzahl Straftaten nach Haupttiteln, Kanton Zürich\"\n// };\n// } else if (inputLaws == \"AIG\") {\n// return {\n// text: \"Straftaten des AIG\",\n// subtitle: \"Anzahl Straftaten nach Haupttiteln, Kanton Zürich\"\n// };\n// } else if (inputLaws == \"BetmG\") {\n// return {\n// text: \"Straftaten des BetmG\",\n// subtitle: \"Anzahl Straftaten nach Haupttiteln, Kanton Zürich\"\n// };\n// }\n// })()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1356,"value":"plotTitle = (function () {\n if (sng_inputLaws == \"StGB\") {\n return htl.html`

Straftaten des StGB

`;\n } else if (sng_inputLaws == \"AIG\") {\n return htl.html`

Straftaten des AIG

`;\n } else if (sng_inputLaws == \"BetmG\") {\n return htl.html`

Straftaten des BetmG

`;\n }\n})()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"tip = (d) => `${d.Ausgangsjahr}: ${d.Gesetz_Abk}\\n${d.total} Straftaten`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":617,"value":"chartWidth = 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":697,"value":"chartHeight = 300","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":596,"value":"nCol_Legend = {\n if (width >= 1100 && sng_inputLaws == \"AIG\") {\n return 3;\n } else if (width >= 1100 && sng_inputLaws != \"AIG\") {\n return 5;\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":1347,"value":"labelLimit = {\n if (width >= 1100) {\n return 500;\n } else if (width < 1100 && width >= 750) {\n return 325;\n } else {\n return 300;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1194,"value":"### CSS Styles","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1198,"value":"sng_cssStyles = html`\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"### Dependencies","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1468,"value":"import { fonts as ZHFonts } from \"@statistikzh/common-styles\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"import {\n tidy,\n groupBy,\n summarize,\n sum,\n mutate,\n filter,\n mutateWithSummary,\n lead,\n TMath\n} from \"@pbeshai/tidyjs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":609,"value":"import { vl } from \"@vega/vega-lite-api-v5\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 30:"$2f:body"