25:["$","title",null,{"children":"Abwassermonitoring SM | Rodolphe Dewarrat | Observable"}] 49:T1cd4,abwasserSM = { let heightPer = 130; let widthAll = width; const padding = 20; let grid = {}; let scale = 1; const margin = { left: 20, top: 40, bottom: 20, right: 10 }; if (width < 470) { grid.x = 1; grid.y = 14; scale = 1; } else if (width < 780) { grid.x = 2; grid.y = 7; scale = 1.1; } else { grid.x = 3; grid.y = 5; scale = 1.3; } let heightAll = grid.y * heightPer + margin.top + margin.bottom + (grid.y - 1) * padding; const svg = d3 .create("svg") .attr("viewBox", [0, 0, width, heightAll]) .attr("id", "STATchart1"); let widthPer = width / grid.x - (grid.x - 1) * padding - margin.right; let xScale = d3.scaleTime().domain(dateZH_extent).range([0, widthPer]); let max = d3.max(data_mes_roh, (d) => d.SARS_CoV_2_RNA_copies_d_100000); let yScale = d3 .scaleLinear() .domain([0, max]) .range([heightPer - 5, 0]); let yAxis = (g) => g.attr("transform", `translate(${widthPer},0)`).call( d3 .axisLeft(yScale) .tickSize(widthPer) .ticks(2) .tickSizeOuter(0) .tickFormat((d) => (d / 100000000000).toLocaleString("de-CH")) ); let xAxisF = (g) => g .attr("transform", `translate(0,${heightPer - 5})`) .call( d3 .axisBottom(xScale) .tickSize("5") .ticks(d3.timeYear) .tickSizeOuter(2) .tickFormat(ch_DE.format("%Y")) ); let line = d3 .line() .defined((d) => d.value >= 0) //.defined(d => !isNaN(d.value)) .x((d) => xScale(d.date)) .y((d) => yScale(d.value)); let counter = 0; let roh = data_mes_roh; for (let y = 0; y < grid.y; y++) { for (let x = 0; x < grid.x; x++) { if (counter < 13) { let this_data_mes = roh.filter( (el) => el.sample_origin == data_ara[counter].ARA_code ); console.log( this_data_mes .filter((d) => d.date < parseTime("2021-12-30")) .map((d) => [d.SARS_CoV_2_RNA_copies_d_100000, d.date]) ); let this_data_mes_avg_old = movingAverage( this_data_mes .filter((d) => d.date < parseTime("2021-12-30")) .map((d) => [d.SARS_CoV_2_RNA_copies_d_100000, d.date]), (function () { if (data_ara[counter].ARA_name !== "Winterthur") { return 3; } else { return 5; } })() ); let this_data_mes_avg_new = movingAverage( this_data_mes .filter((d) => d.date >= parseTime("2021-12-30")) .map((d) => [d.SARS_CoV_2_RNA_copies_d_100000, d.date]), (function () { if (data_ara[counter].ARA_name !== "Winterthur") { return 3; } else { return 5; } })() ); console.log(counter); console.log(this_data_mes_avg_new); var thisChart = svg .append("g") .attr("id", "grid_" + counter) .attr( "transform", "translate(" + (margin.left + x * widthPer + (x - 1) * padding) + "," + (margin.top + y * heightPer + (y - 1) * padding) + ")" ); let xaxisGr = thisChart.append("g"); let yaxisGr = thisChart.append("g"); let mouseGr = thisChart.append("g"); let chartGr = thisChart.append("g").attr("pointer-events", "none"); //let xAxisGr = axisGr.append("g").attr("id", "monthAxis").call(xAxis); let yAxisGr = yaxisGr .append("g") .attr("id", "monthAxis" + counter) .call(yAxis); let xAxisGr = xaxisGr.append("g").attr("id", "dayAxis").call(xAxisF); //let xAxis = axisGr.append("g").attr("id", "xAxis" + counter); // .call(d3.axisBottom(xScale).tickSize("5").tickSizeOuter(0)); yaxisGr .selectAll("text") .attr("y", "-0.5em") .attr("x", -widthPer) .style("text-anchor", "start") .attr("pointer-events", "none"); yaxisGr .selectAll(".tick") .selectAll("line") .style("stroke", "lightgrey"); yaxisGr.selectAll("path").style("stroke", "none"); chartGr .append("g") //.attr("transform", "translate(" + balkenWidth / 2 + "," + 0 + ")") .append("path") .datum(this_data_mes_avg_old) .attr("fill", "none") .attr("stroke-width", 2) .attr("stroke", color1) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .attr("d", line); chartGr .append("g") //.attr("transform", "translate(" + balkenWidth / 2 + "," + 0 + ")") .append("path") .datum(this_data_mes_avg_new) .attr("fill", "none") .attr("stroke-width", 2) .attr("stroke", color2) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .attr("d", line); chartGr .append("text") .attr("x", widthPer) .attr("y", 0) .attr("dy", "1em") .style("text-anchor", "end") .text(data_ara[counter].ARA_name) .attr("pointer-events", "none"); } else if (counter == 13) { var legende = svg .append("g") .attr("id", "grid_" + counter) .attr( "transform", "translate(" + (margin.left + x * widthPer + (x - 1) * padding) + "," + (margin.top + y * heightPer + (y - 1) * padding) + ")" ); let element2 = legende .append("g") .attr("transform", "translate(" + margin.left + ",40)"); let element21 = legende .append("g") .attr("transform", "translate(" + margin.left + ",60)"); let element3 = legende .append("g") .attr("transform", "translate(" + margin.left + ",90)"); let element4 = legende .append("g") .attr("transform", "translate(" + margin.left + ",115)"); let text2 = element2 .append("text") .attr("x", 0) .attr("y", 13) .text("SARS-CoV-2 RNA im Abwasser, "); let text21 = element21 .append("text") .attr("x", 0) .attr("y", 13) .text("gleitendes Mittel (7 Tage):"); let text3 = element3 .append("text") .attr("x", 20) .attr("y", 13) .text("alte Messmethode"); let text4 = element4 .append("text") .attr("x", 20) .attr("y", 13) .text("neue Messmethode"); element3 .append("line") .attr("x1", 0) .attr("x2", 15) .attr("y1", 8) .attr("y2", 8) .style("stroke", color1) .style("stroke-width", 3); element4 .append("line") .attr("x1", 0) .attr("x2", 15) .attr("y1", 8) .attr("y2", 8) .style("stroke", color2) .style("stroke-width", 3); } counter += 1; } } svg.selectAll("text").attr("font-size", "calc(0vw + 16px)"); return svg.node(); }4a:T2627,dayChartDeath = { let yScale = yScaleF( scaleTyp, d3.extent(data_mes_roh, (d) => d.SARS_CoV_2_RNA_copies_d_100000) ); let yAxis = (g) => g.attr("transform", `translate(${widthNow - margin.right},0)`).call( d3 .axisLeft(yScale) .tickSize(widthNow - margin.left - margin.right) .tickFormat((d) => (d / 100000000000).toLocaleString("de-CH")) //.ticks(3) ); let yScaleC = yScaleF( scaleTyp, d3.extent(data_cases, (d) => +d.n_conf) ); let yAxisC = (g) => g.attr("transform", `translate(${widthNow - margin.left},0)`).call( d3 .axisRight(yScaleC) .tickSize(0) .tickFormat((d) => d.toLocaleString("de-CH")) //.ticks(3) ); let line = d3 .line() .defined((d) => d.value >= 0) //.defined(d => !isNaN(d.value)) .x((d) => xScale(d.date)) .y((d) => yScale(d.value)); let lineC = d3 .line() .defined((d) => d.value >= 0) //.defined(d => !isNaN(d.value)) .x((d) => xScale(d.date)) .y((d) => yScaleC(d.value)); const svg = d3 .create("svg") .attr("viewBox", [0, 0, widthNow, height]) .attr("id", "STATchart1"); const axisGr = svg.append("g"); const mouseGr = svg.append("g"); const chartGr = svg.append("g").attr("pointer-events", "none"); if (widthNow < 1020) { axisGr.select("#dayAxis").remove(); let xAxisMonth = axisGr.append("g").attr("id", "monthAxis").call(xAxisM); } else { axisGr.select("#monthAxis").remove(); let xAxisMonth = axisGr.append("g").attr("id", "dayAxis").call(xAxis); } const xAxisYear = axisGr.append("g").attr("id", "dayAxis").call(xAxisJ); axisGr.append("g").call(yAxis); axisGr.append("g").call(yAxisC); let balkenWidth = (widthNow - margin.left - margin.right) / Math.round((dateZH_extent[1] - dateZH_extent[0]) / (1000 * 60 * 60 * 24)); axisGr.selectAll(".tick").selectAll("line").style("stroke", "lightgrey"); axisGr.selectAll("path").style("stroke", "none"); const mouseRect = mouseGr .selectAll("rect.STATmouse") .data(data_mes) .enter() .append("rect") .attr("id", (d) => "m" + formatTime(d.date)) .attr("class", "STATmouse") .attr("cursor", "pointer") .attr("fill", "white") .attr("stroke-width", 0.5) .attr("stroke", "white") .attr("opacity", 0) .attr("x", (d, i) => xScale(d.date)) .attr("y", 0) .attr("width", balkenWidth) .attr("height", height); let symbole = chartGr.selectAll("path.messung").data(data_mes); symbole .enter() .append("path") .attr("id", (d) => "a" + formatTime(d.date)) .attr("class", "messung") .attr("fill", function (d) { if (d.date >= parseTime("2021-12-30")) { return color2; } else { return color1; } }) .attr("stroke-width", 0) .attr("stroke", "grey") .attr("opacity", 0.8) .attr( "transform", (d) => "translate(" + xScale(d.date) + "," + yScale(d.SARS_CoV_2_RNA_copies_d_100000) + ")" ) .attr( "d", d3 .symbol() .type((d) => symbolScale(d.quantification_flag)) .size(35) ); //Ersetzen mit Kreisen: chartGr .append("g") .attr("transform", "translate(" + balkenWidth / 2 + "," + 0 + ")") .append("path") .datum(data_cases_avg) .attr("fill", "none") .attr("stroke-width", 1.5) .attr("stroke", "grey") .attr("stroke-dasharray", "2,5") .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .attr("d", lineC); chartGr .append("g") .attr("transform", "translate(" + balkenWidth / 2 + "," + 0 + ")") .append("path") .datum(data_mes_avg_old) .attr("fill", "none") .attr("stroke-width", 2) .attr("stroke", color1) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .attr("d", line); chartGr .append("g") .attr("transform", "translate(" + balkenWidth / 2 + "," + 0 + ")") .append("path") .datum(data_mes_avg_new) .attr("fill", "none") .attr("stroke-width", 2) .attr("stroke", color2) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .attr("d", line); let tag, tageswert, mittelwert, week; axisGr .append("text") .attr("x", 10) .attr("y", 15) .text("SARS-CoV-2 RNA in Mia") .style("fill", "dark gray") //.attr("transform", "rotate(-90)") .style("text-anchor", "start"); axisGr .append("text") .attr("x", widthNow - 15) .attr("y", 10) .text("Fälle im Kanton Zürich") .style("fill", "dark gray") //.attr("transform", "rotate(-90)") .style("text-anchor", "end"); mouseGr.selectAll("rect").on("mouseover", function (d) { let da = d3.select(this).data()[0]; tageswert = da; tag = d3 .timeParse("%Q")(+da.date) .toLocaleString("de-CH", { day: "numeric", month: "long" }); mittelwert = bisect(data_mes_avg, d3.timeParse("%Q")(+da.date)); week = d3.timeFormat("%U")(d3.timeParse("%Q")(+da.date)); chartGr.selectAll("rect").attr("opacity", 0.7); chartGr.select("#a" + formatTime(+da.date)).attr("opacity", 1); chartGr.select("#thisMouse").remove(); let thisMouse = chartGr.append("g").attr("id", "thisMouse"); let translateX = d3.min([ widthNow - margin.right - margin.left - 20, d3.max([xScale(da.date) - 40, 0]) ]); let translateY = d3.min([height - 60, yScale(mittelwert.value)]) - 60; let thisGr = thisMouse .append("g") .attr("transform", "translate(" + translateX + "," + translateY + ")"); thisGr .append("rect") .attr("x", 0) .attr("y", 0) .attr("width", 80) .attr("height", 45) .style("fill", "white") .style("opacity", 0.6); thisGr .append("text") .attr("dx", 40) .attr("dy", "1em") .style("text-anchor", "middle") .text(tag); let text1 = ""; if (mittelwert.value >= 0) { text1 = Math.round(mittelwert.value / 100000000000); } let text2 = ""; if (tageswert.SARS_CoV_2_RNA_copies_d_100000 >= 0) { text2 = "(" + tageswert.quantification_flag + ")"; } else { text2 = ""; } thisGr .append("text") .attr("dx", 40) .attr("dy", "2.2em") .style("text-anchor", "middle") .style("fill", function () { if (tageswert.date < parseTime("2021-12-30")) { return color1; } else { return color2; } }) .text(text1 + " Mrd. " + text2); }); let element2 = svg .append("g") .attr("transform", "translate(" + margin.left + ",395)"); let element21 = svg .append("g") .attr("transform", "translate(" + margin.left + ",415)"); let element3 = svg .append("g") .attr("transform", "translate(" + margin.left + ",440)"); let element4 = svg .append("g") .attr("transform", "translate(" + margin.left + ",465)"); let element1 = svg .append("g") .attr("transform", "translate(" + margin.left + ",490)"); let text2 = element2 .append("text") .attr("x", 0) .attr("y", 13) .text("SARS-CoV-2 RNA im Abwasser,"); let text2q = element21 .append("text") .attr("x", widthNow / 2) .attr("y", 13) .text("Quantifizierungsgrenze:"); let text21 = element21 .append("text") .attr("x", 0) .attr("y", 13) .text("gleitendes Mittel (7 Tage):"); let text3 = element3 .append("text") .attr("x", 20) .attr("y", 13) .text("alte Messmethode"); let text3q = element3 .append("text") .attr("x", widthNow / 2 + 20) .attr("y", 13) .text("Q: über Quantifizierungsgrenze (>LOQ)"); let s3q = element3 .append("path") .attr("transform", "translate(" + (widthNow / 2 + 4) + "," + 8 + ")") .attr("d", d3.symbol(d3.symbolCircle), 30); let text4 = element4 .append("text") .attr("x", 20) .attr("y", 13) .text("neue Messmethode"); let text4q = element4 .append("text") .attr("x", widthNow / 2 + 20) .attr("y", 13) .text("D: über Nachweisgrenze (>LOD)"); let s4q = element4 .append("path") .attr("transform", "translate(" + (widthNow / 2 + 4) + "," + 8 + ")") .attr("d", d3.symbol(d3.symbolTriangle), 30); let text5q = element1 .append("text") .attr("x", widthNow / 2 + 20) .attr("y", 13) .text("N: unter Nachweisgrenze ( { event.currentTarget.value = { tag: tag, mittel: mittelwert.value, neu: tageswert.n_deceased, woche: week }; event.currentTarget.dispatchEvent(new CustomEvent("input")); } }); }4b:T40f,As part of the cantonal SARS-CoV-2 wastewater monitoring, the Health Department of the Canton of Zurich (Cantonal Laboratory Zurich) analyses and publishes measurements of samples from twelve wastewater treatment plants (WTPs) distributed throughout the Canton of Zurich.
The measurements are based on the EAWAG (Swiss Federal Institute of Aquatic Science and Technology) project "SARS-CoV-2 in wastewater". Further information: https://www.eawag.ch/en/department/sww/projects/sars-cov2-in-wastewater/

### Contact If you have questions regarding the content of the data, please contact the Division for Data Analysis of the Office of Health Care of the Canton of Zurich, - by creating a GitHub issue or - by writing an e-mail to gdstab@gd.zh.ch

If you have questions regarding the provision of the data, please contact the Specialist Unit for Open Government Data of the Canton of Zurich, - by writing a Twitter direct message or - by writing an e-mail to info@open.zh.ch

Many thanks for your feedback!4c:[] 29:{"id":"8cc2219983b0c14d","slug":null,"title":"Abwassermonitoring SM","thumbnail":"ea329495bdcb546286ac726917873616749239be50511e411a851f4d35f9068e","access_level":"public","create_time":"$D2023-02-09T10:03:20.209Z","update_time":"$D2023-02-09T10:03:53.872Z","view_time":null,"first_public_time":"$D2023-02-09T10:03:20.209Z","has_unpublished_edits":null,"fork":{"id":"fbe20206b714e23f","slug":"abwassermonitoring-sm","title":"Abwassermonitoring SM","owner":{"id":"4b23743d6fe05d13","login":"statistikzh","name":"Office for Statistics and Data of the Canton of Zurich"}},"stars":0,"starred":false,"owner":{"type":"team","id":"d1f3df0af1f88806","login":"rd255","name":"Rodolphe Dewarrat","avatar_url":"https://avatars-next.observableusercontent.com/268290dfbb8cb0fd88a2bf32e64d6c82106d1c68bebfd16fc68b335ce4d6341a","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1887,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"6f9e2a93d6be04e0","login":"rd255","name":"Rodolphe Dewarrat","avatar_url":"https://avatars-next.observableusercontent.com/268290dfbb8cb0fd88a2bf32e64d6c82106d1c68bebfd16fc68b335ce4d6341a","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"6f9e2a93d6be04e0","login":"rd255","name":"Rodolphe Dewarrat","avatar_url":"https://avatars-next.observableusercontent.com/268290dfbb8cb0fd88a2bf32e64d6c82106d1c68bebfd16fc68b335ce4d6341a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Abwassermonitoring SM","cells":[{"id":0,"value":"# Abwassermonitoring SM","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1200,"value":"logo","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1349,"value":"## SARS-CoV-2 RNA im Abwasser pro 100'000 Einwohner:innen in Mrd","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1447,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1250,"value":"viewof ara = {\n const node = Inputs.select(\n new Map(d3.map(data_ara, (d) => [d.ARA_name, d.ARA_code])),\n {\n label: \"Messstelle:\",\n value: data_ara[0].ARA_code\n }\n );\n return node;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1287,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1238,"value":"dataDownload(\n \"https://raw.githubusercontent.com/openZH/covid_19_wastewater_monitoring_ZH/master/COVID19_Abwassermonitoring.csv\",\n \"https://github.com/openZH/covid_19_wastewater_monitoring_ZH\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1235,"value":"$4b","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1644,"value":"color1 = \"#B01657\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1645,"value":"color2 = \"#0070B4\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1545,"value":"d3.symbol()\n .type(symbolScale(\"Q\"))\n .size(20)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"md`## Parameters`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1298,"value":"viewof scaleTyp = DOM.select([\"linear\", \"log\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"margin = ({ top: 20, right: 50, bottom: 170, left: 50 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1326,"value":"padding = 10","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1284,"value":"widthNow = d3.min([768, width])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1292,"value":"height = 520","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1304,"value":"ch_DE = d3.timeFormatDefaultLocale({\n decimal: \".\",\n thousands: \"'\",\n grouping: [3],\n currency: [\"CHF\", \" \"],\n dateTime: \"%a %b %e %X %Y\",\n date: \"%d.%m.%Y\",\n time: \"%H:%M:%S\",\n periods: [\"AM\", \"PM\"],\n days: [\n \"Sonntag\",\n \"Montag\",\n \"Dienstag\",\n \"Mittwoch\",\n \"Donnerstag\",\n \"Freitag\",\n \"Samstag\"\n ],\n shortDays: [\"So\", \"Mo\", \"Di\", \"Mi\", \"Do\", \"Fr\", \"Sa\"],\n months: [\n \"Januar\",\n \"Februar\",\n \"März\",\n \"April\",\n \"Mai\",\n \"Juni\",\n \"Juli\",\n \"August\",\n \"September\",\n \"Oktober\",\n \"November\",\n \"Dezember\"\n ],\n shortMonths: [\n \"Jan\",\n \"Feb\",\n \"Mar\",\n \"Apr\",\n \"Mai\",\n \"Jun\",\n \"Jul\",\n \"Aug\",\n \"Sep\",\n \"Okt\",\n \"Nov\",\n \"Dez\"\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":112,"value":"md`## Functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1269,"value":"parseTime = d3.timeParse(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1314,"value":"formatTime = d3.timeFormat(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1277,"value":"xScale = d3\n .scaleTime()\n .domain(dateZH_extent)\n .range([margin.left, widthNow - margin.right])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1301,"value":"xAxisM = (g) =>\n g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(\n d3\n .axisBottom(xScale)\n .tickSize(\"5\")\n .ticks(d3.timeMonth)\n .tickSizeOuter(0)\n .tickFormat(ch_DE.format(\"%b\"))\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1432,"value":"xAxisJ = (g) =>\n g\n .attr(\"transform\", `translate(0,${height - margin.bottom + 20})`)\n .call(\n d3\n .axisBottom(xScale)\n .tickSize(\"5\")\n .ticks(d3.timeYear)\n .tickSizeOuter(0)\n .tickFormat(ch_DE.format(\"%Y\"))\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1307,"value":"xAxis = (g) =>\n g.attr(\"transform\", `translate(0,${height - margin.bottom})`).call(\n d3\n .axisBottom(xScale)\n .tickFormat((d) =>\n d.toLocaleString(\"de-CH\", {\n day: \"numeric\",\n month: \"short\"\n })\n )\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1278,"value":"dateZH_extent = d3.extent(data_mes_roh, (d) => d.date)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1295,"value":"valueZH_extent = d3.extent(data_mes, d => +d.SARS_CoV_2_RNA_copies_d_100000)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1288,"value":"yScaleF = function(type, extent) {\n if (type == 'linear') {\n return d3\n .scaleLinear()\n .domain([0, extent[1]])\n .range([height - margin.bottom, margin.top]);\n } else if (type == 'log') {\n return d3\n .scaleLog()\n .domain([1, valueZH_extent[1]])\n .range([height - margin.bottom, margin.top]);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1290,"value":"bisect = {\n const bisectDate = d3.bisector(d => d.date).left;\n return (data, date) => {\n const i = bisectDate(data, date, 1);\n const a = data[i - 1],\n b = data[i];\n return date - a.date > b.date - date ? b : a;\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1319,"value":"function movingAverage(values, N) {\n let i = 0;\n let sum = 0;\n const means = []; \n for (let n = Math.min(N - 1, values.length); i < n; ++i) {\n let mean = {};\n mean.value = NaN;\n mean.date = values[i][1];\n means[i] = mean;\n sum += values[i][0];\n }\n for (let n = values.length; i < n; ++i) {\n sum += values[i][0];\n let mean = {};\n mean.value = sum / N;\n mean.date = values[i][1];\n means[i] = mean;\n sum -= values[i - N + 1][0];\n }\n return means;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1332,"value":"quant_color = d3\n .scaleOrdinal()\n .domain([\"Q\", \"D\", \"N\"])\n .range([\"tomato\", \"grey\", \"none\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1815,"value":"mess_color = d3\n .scaleOrdinal()\n .domain([\"Q\", \"D\", \"N\"])\n .range([\"tomato\", \"grey\", \"none\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1516,"value":"symbolScale = d3\n .scaleOrdinal()\n .domain([\"Q\", \"D\", \"N\"])\n .range([d3.symbolCircle, d3.symbolTriangle, d3.symbolCross])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1243,"value":"data_ara = d3.csv(\"https://raw.githubusercontent.com/openZH/covid_19_wastewater_monitoring_ZH/master/ara_einzugsgebiet.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1608,"value":"data_mes_avg = movingAverage(\n data_mes.map((d) => [d.SARS_CoV_2_RNA_copies_d_100000, d.date]),\n anzahlMessungen()\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1316,"value":"data_mes_avg_old = movingAverage(\n data_mes\n .filter((d) => d.date < parseTime(\"2021-12-30\"))\n .map((d) => [d.SARS_CoV_2_RNA_copies_d_100000, d.date]),\n anzahlMessungen()\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1616,"value":"anzahlMessungen = function () {\n if (ara !== \"Winterthur\") {\n return 3;\n } else {\n return 5;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1604,"value":"data_mes_avg_new = movingAverage(\n data_mes\n .filter((d) => d.date >= parseTime(\"2021-12-30\"))\n .map((d) => [d.SARS_CoV_2_RNA_copies_d_100000, d.date]),\n anzahlMessungen()\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1372,"value":"data_cases_avg = datenZHTagAvg.filter(d => d.date >= parseTime(\"2021-05-29\"));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1387,"value":"data_cases = datenZH.filter(\n (d) => d.date >= dateZH_extent[0] && d.date <= dateZH_extent[1]\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1385,"value":"import {datenZH} from \"@statistikzh/tagliche-covid-19-fallzahlen-im-kanton-zurich-stripdown\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1365,"value":"import {datenZHTagAvg} from \"@statistikzh/tagliche-covid-19-fallzahlen-im-kanton-zurich-stripdown\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1244,"value":"data_mes_roh = d3\n .csv(\n \"https://raw.githubusercontent.com/openZH/covid_19_wastewater_monitoring_ZH/master/COVID19_Abwassermonitoring.csv\"\n )\n .then(function (data) {\n data.forEach(function (d) {\n d.date = parseTime(d.date);\n d.SARS_CoV_2_RNA_copies_d_100000 = +d.SARS_CoV_2_RNA_copies_d_100000;\n d.flow_m3_d = +d.flow_m3_d;\n });\n\n return data;\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1354,"value":"data_mes = data_mes_roh.filter((el) => el.sample_origin == ara)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1219,"value":"md`## Styling`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1321,"value":"html`