2b:null 2c:["$","title",null,{"children":"Sitzverlegungen | Office for Statistics and Data of the Canton of Zurich | Observable"}] 31:Td01,sitzverlegungenSaldo = vl .data(sitzverlegungen.filter((d) => d.sitzverlegung == "Saldo")) .transform([ { calculate: "datum.kumsum < 0 ? 'negativer Saldo' : 'positiver Saldo'", as: "category" } ]) .facet({ field: "stichtag_quarter", type: "ordinal", columns: nCol, title: null }) .spec({ encoding: { x: { timeUnit: "year", field: "jahr", type: "ordinal" }, y: { aggregate: "sum", field: "kumsum", axis: { format: "+f", title: null, grid: true, gridColor: { condition: { test: "datum.value === 0", value: "#000" }, value: "#fff" } }, scale: { domain: extentKumSumNetflow } } }, layer: [ { mark: { type: "bar" }, encoding: { color: { field: "category", type: "ordinal", scale: { range: ["#ff8500", "#5a189a"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }, title: null, legend: "top" } } }, { mark: { type: "text", // align: { expr: "datum.ytd < 0 ? 'middle' : 'middle'" }, dy: { expr: "datum.kumsum < 0 ? 12.5 : -12.5" } }, encoding: { text: { format: "+.0f", field: "kumsum", type: "quantitative" }, color: { condition: { test: "datum.kumsum < 0", value: "#000" }, value: "#000" } } } ] }) .columns(nCol) .title({ text: "Saldo der Sitzverlegungen (kumuliert) pro Quartal", subtitle: "Kanton Zürich" }) .autosize({ type: "fit", resize: true }) .config({ locale: { number: locale }, view: { fill: "#e5e5e5", stroke: "transparent", width: plotWidth(4), height: 350 }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", axis: { labelFontSize: 12, labelFont: ZHFonts.regular, labelColor: "black", titleFontSize: 12, titleColor: "black", titleFont: ZHFonts.regular }, axisX: { labelAngle: 0, labelPadding: 7, title: null, orient: "bottom", ticks: false, labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(plotWidth(4) / 80) } }, axisY: { axis: "right", grid: true, ticks: true, tickCount: { signal: Math.ceil(350 / 80) } }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, header: { labelOrient: "top", labelPadding: 5, lineHeight: 3, labelFontSize: 13, labelFont: ZHFonts.black, labelColor: "black" }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14 } }) .render()32:Td9c,viewof anzahlSitzverlegungenKumuliert = vl .data(sitzverlegungen.filter((d) => d.sitzverlegung != "Saldo")) .transform([ { calculate: "datum.sitzverlegung === 'Zuzug' ? 'Zuzüge' : 'Wegzüge'", as: "category" }, { calculate: "datum.sitzverlegung == 'Wegzug' ? -datum.kumsum : datum.kumsum", as: "value" } ]) .facet({ field: "stichtag_quarter", type: "ordinal", columns: nCol, title: null }) .spec({ encoding: { x: { timeUnit: "year", field: "jahr", type: "ordinal" }, y: { aggregate: "sum", field: "value", axis: { format: "+f", title: null, grid: true, gridColor: { condition: { test: "datum.value === 0", value: "#000" }, value: "#fff" } }, scale: { domain: [-extentKumsum * 1.2, extentKumsum * 1.2] } } }, layer: [ { mark: { type: "bar" }, encoding: { color: { field: "category", type: "ordinal", scale: { range: ["#ff8500", "#5a189a"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }, title: null, legend: "top" } } }, { mark: { type: "text", // align: { expr: "datum.ytd < 0 ? 'middle' : 'middle'" }, dy: { expr: "datum.value < 0 ? -12.5 : 12.5" } }, encoding: { text: { field: "value", type: "quantitative", format: "+.0f" }, color: { condition: { test: "datum.value < 0", value: "#fff" }, value: "#fff" } } } ] }) .columns(nCol) .title({ text: "Kumulierte Anzahl Zu- und Wegzüge pro Quartal", subtitle: "Kanton Zürich" }) .autosize({ type: "fit", resize: true }) .config({ locale: { number: locale }, view: { fill: "#e5e5e5", stroke: "transparent", width: plotWidth(4), height: 350 }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", axis: { labelFontSize: 12, labelFont: ZHFonts.regular, labelColor: "black", titleFontSize: 12, titleColor: "black", titleFont: ZHFonts.regular }, axisX: { labelAngle: 0, labelPadding: 7, title: null, orient: "bottom", ticks: false, labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(plotWidth(4) / 80) } }, axisY: { axis: "right", grid: true, ticks: true, tickCount: { signal: Math.ceil(350 / 80) } }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, header: { labelOrient: "top", labelPadding: 5, lineHeight: 3, labelFontSize: 13, labelFont: ZHFonts.black, labelColor: "black" }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14 } }) .render()33:Td6c,viewof anzahlSitzverlegungen = vl .data(sitzverlegungen.filter((d) => d.sitzverlegung != "Saldo")) .transform([ { calculate: "datum.sitzverlegung === 'Zuzug' ? 'Zuzüge' : 'Wegzüge'", as: "category" }, { calculate: "datum.sitzverlegung == 'Wegzug' ? -datum.n : datum.n", as: "value" } ]) .facet({ field: "stichtag_quarter", type: "ordinal", columns: nCol, title: null }) .spec({ encoding: { x: { timeUnit: "year", field: "jahr", type: "ordinal" }, y: { aggregate: "sum", field: "value", axis: { format: "+f", title: null, grid: true, gridColor: { condition: { test: "datum.value === 0", value: "#000" }, value: "#fff" } }, scale: { domain: [-extentN * 1.2, extentN * 1.2] } } }, layer: [ { mark: { type: "bar" }, encoding: { color: { field: "category", type: "ordinal", scale: { range: ["#ff8500", "#5a189a"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }, title: null, legend: "top" } } }, { mark: { type: "text", // align: { expr: "datum.ytd < 0 ? 'middle' : 'middle'" }, dy: { expr: "datum.value < 0 ? -12.5 : 12.5" } }, encoding: { text: { field: "value", type: "quantitative", format: "+.0f" }, color: { condition: { test: "datum.value < 0", value: "#fff" }, value: "#fff" } } } ] }) .columns(nCol) .title({ text: "Anzahl Zu- und Wegzüge pro Quartal", subtitle: "Kanton Zürich" }) .autosize({ type: "fit", resize: true }) .config({ locale: { number: locale }, view: { fill: "#e5e5e5", stroke: "transparent", width: plotWidth(4), height: 350 }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", axis: { labelFontSize: 12, labelFont: ZHFonts.regular, labelColor: "black", titleFontSize: 12, titleColor: "black", titleFont: ZHFonts.regular }, axisX: { labelAngle: 0, labelPadding: 7, title: null, orient: "bottom", ticks: false, labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(plotWidth(4) / 80) } }, axisY: { axis: "right", grid: true, ticks: true, tickCount: { signal: Math.ceil(350 / 80) } }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, header: { labelOrient: "top", labelPadding: 5, lineHeight: 3, labelFontSize: 13, labelFont: ZHFonts.black, labelColor: "black" }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14 } }) .render()34:Td0e,viewof sitzverlegungenVorjahresvergleich = vl .data(sitzverlegungen.filter((d) => d.sitzverlegung == "Saldo")) .transform([ { calculate: "datum.ytd < 0 ? 'Abnahme' : 'Zunahme'", as: "category" } ]) .facet({ field: "stichtag_quarter", type: "ordinal", columns: nCol, title: null }) .spec({ encoding: { x: { timeUnit: "year", field: "jahr", type: "ordinal" }, y: { aggregate: "sum", field: "ytd", axis: { title: null, format: "+%", grid: true, gridColor: { condition: { test: "datum.value === 0", value: "#000" }, value: "#fff" } }, scale: { domain: extentYTD_Netflow } } }, layer: [ { mark: { type: "bar" }, encoding: { color: { field: "category", type: "ordinal", scale: { range: ["#ff8500", "#5a189a"] // blues: ["#8ecae6", "#219ebc", "#023047", "#ffb703", "#fb8500"] }, title: null, legend: "top" } } }, { mark: { type: "text", // align: { expr: "datum.ytd < 0 ? 'middle' : 'middle'" }, dy: { expr: "datum.ytd < 0 ? 12.5 : -12.5" } }, encoding: { text: { field: "ytd", type: "quantitative", format: "+.0%" }, color: { condition: { test: "datum.ytd < 0", value: "#000" }, value: "#000" } } } ] }) .columns(nCol) .title({ text: "Veränderung zum Vorjahresquartal, in Prozent", subtitle: "Kanton Zürich, Basis: Anzahl Zu- & Wegzüge" }) .autosize({ type: "fit", resize: true }) .config({ locale: { number: locale }, view: { fill: "#e5e5e5", stroke: "transparent", width: plotWidth(4), height: 350 }, scale: { bandPaddingInner: 0.2, bandPaddingOuter: 0.2 }, background: "#ffffff", axis: { labelFontSize: 12, labelFont: ZHFonts.regular, labelColor: "black", titleFontSize: 12, titleColor: "black", titleFont: ZHFonts.regular }, axisX: { labelAngle: 0, labelPadding: 7, title: null, orient: "bottom", ticks: false, labelFont: ZHFonts.black, labelFontSize: 12, tickCount: { signal: Math.ceil(plotWidth(4) / 80) } }, axisY: { axis: "right", grid: true, ticks: true, tickCount: { signal: Math.ceil(350 / 80) } }, title: { font: ZHFonts.black, fontSize: 16, offset: 15, anchor: "start", lineHeight: 5, padding: 40, subtitleFont: ZHFonts.regular, subtitleFontSize: 14 }, header: { labelOrient: "top", labelPadding: 5, lineHeight: 3, labelFontSize: 13, labelFont: ZHFonts.black, labelColor: "black" }, legend: { orient: "top", labelFontSize: 14, labelFont: ZHFonts.regular, labelColor: "black", labelLimit: 300, columns: nCol, rowPadding: 5, title: null }, text: { font: ZHFonts.regular, fontSize: 14 } }) .render()35:[] 2f:{"id":"b54fe00574e65427","slug":null,"title":"Sitzverlegungen","thumbnail":"dd0b34205920bf527d965422bb1e8673076058374ae548693b6881ebdbc74a06","access_level":"public","create_time":"$D2022-04-08T11:50:55.505Z","update_time":"$D2024-09-05T05:39:30.465Z","view_time":null,"first_public_time":"$D2022-10-26T05:55:51.620Z","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":1874,"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"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Sitzverlegungen","cells":[{"id":0,"value":"# Sitzverlegungen\n\nOpen Data beziehen: [Sitzverlegungen pro Quartal und Branche ab 2018](https://www.zh.ch/de/politik-staat/statistik-daten/datenkatalog.html#/datasets/1421@handelsregisteramt-kanton-zuerich/distributions/2781)\n\nThemenseite auf zh.ch: [Zahlen & Fakten zu Eintragungen im Handelsregister](https://www.zh.ch/de/wirtschaft-arbeit/handelsregister/zahlen-fakten.html#main_linklist)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":122,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1514,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"*Lesebeispiel: Während des gesamten Jahres 2021 hat die Zahl der aus dem Kanton abwandernden Unternehmen im Vergleich zu den zuziehenden Unternehmen zugenommen.*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1613,"value":"viewof sitzverlegungenSelection = Inputs.radio(\n [\"Anzahl\", \"Kumulierte Anzahl\", \"Veränderung\"],\n {\n label: \"Datensicht wechseln\",\n value: \"Anzahl\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1616,"value":"sitzverlegungenTotal = (function () {\n if (sitzverlegungenSelection == \"Anzahl\") {\n return htl.html`\n${viewof sitzverlegungenSelection}\n
\n${viewof anzahlSitzverlegungen}`;\n } else if (sitzverlegungenSelection == \"Kumulierte Anzahl\") {\n return htl.html`\n${viewof sitzverlegungenSelection}\n
\n${viewof anzahlSitzverlegungenKumuliert}`;\n } else if (sitzverlegungenSelection == \"Veränderung\") {\n return htl.html`\n${viewof sitzverlegungenSelection}\n
\n${viewof sitzverlegungenVorjahresvergleich}`;\n }\n})()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1766,"value":"---\n### Code für Plots","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1542,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1558,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1530,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"*Lesebeispiel: Per 31. Dez. 2021 lagen die Netto-Sitzverlegungen um 13.6% unter der Vorjahresperiode. Das heisst, die Wegzüge überwiegen die Zuzüge im Vergleich zu Dez. 2020.*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":135,"value":"---\n### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1677,"value":"data = \n d3.csv(\n \"https://www.web.statistik.zh.ch/ogd/data/KANTON_ZUERICH_HRA_Sitzverlegungen.csv\",\n { typed: true }\n)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"sitzverlegungen = tidy(\n data,\n filter((d) => d.branchen == \"Total\" && d.jahr >= mostRecentYear - 2),\n mutate({\n ytd: (d) => +d.vj_rel_n,\n n: (d) => +d.n,\n kumsum: (d) => +d.kumsum,\n jahr: (d) => d.jahr.toString(),\n stichtag_quarter: (d) => d.quartal\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":992,"value":"mostRecentYear = d3.max(data, (d) => d.jahr)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1318,"value":"extentKumSumNetflow = (function (d) {\n const minNetflow = d3.min(\n sitzverlegungen.filter((d) => d.sitzverlegung == \"Saldo\"),\n (d) => d.kumsum\n );\n const maxNetflow = d3.max(\n sitzverlegungen.filter((d) => d.sitzverlegung == \"Saldo\"),\n (d) => d.kumsum\n );\n\n if (minNetflow < 0 && 0 - minNetflow > maxNetflow - 0) {\n return [minNetflow * 1.1, (0 - minNetflow) * 1.1];\n } else if (minNetflow < 0 && 0 - minNetflow < maxNetflow - 0) {\n return [(0 - minNetflow) * 1.1, minNetflow * 1.1];\n } else if (minNetflow > 0 && 0 - minNetflow < maxNetflow - 0) {\n return [(0 - minNetflow) * 1.1, minNetflow * 1.1];\n }\n})()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1460,"value":"extentYTD_Netflow = (function (d) {\n const minNetflow = d3.min(\n sitzverlegungen.filter((d) => d.sitzverlegung == \"Saldo\"),\n (d) => d.ytd\n );\n const maxNetflow = d3.max(\n sitzverlegungen.filter((d) => d.sitzverlegung == \"Saldo\"),\n (d) => d.ytd\n );\n\n if (minNetflow < 0 && 0 - minNetflow > maxNetflow - 0) {\n return [minNetflow * 1.2, (0 - minNetflow) * 1.2];\n } else if (minNetflow < 0 && 0 - minNetflow < maxNetflow - 0) {\n return [(0 - maxNetflow) * 1.2, maxNetflow * 1.2];\n } else if (minNetflow > 0 && 0 - minNetflow < maxNetflow - 0) {\n return [(0 - maxNetflow) * 1.2, maxNetflow * 1.2];\n }\n})()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1491,"value":"extentN = d3.max(sitzverlegungen, (d) => d.n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1498,"value":"extentKumsum = d3.max(\n sitzverlegungen.filter((d) => d.sitzverlegung != \"Saldo\"),\n (d) => d.kumsum\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":131,"value":"---\n### Code for Formatting","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":997,"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":1000,"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":990,"value":"nCol = {\n if (width >= 1100) {\n return 4;\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":1770,"value":"### Dependencies","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1865,"value":"import { fonts as ZHFonts } from \"@statistikzh/common-styles\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"import { tidy, mutate, select, filter } from \"@pbeshai/tidyjs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1398,"value":"import { vl } from \"@vega/vega-lite-api\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 30:"$2f:body"