25:["$","title",null,{"children":"TransparenZRH | Thorben Westerhuys | Observable"}] 4b:[] 47:{"id":"07eac45bedf3f810","slug":"transparenzrh","title":"TransparenZRH","thumbnail":"fbe7ffa7457f827d252846159111c859c9fef1687dd991f278b3deb074e5de1d","access_level":"public","create_time":"$D2021-03-30T16:01:12.428Z","update_time":"$D2021-04-01T09:47:02.443Z","view_time":null,"first_public_time":"$D2021-03-30T18:05:28.727Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"ca172bc3072e03f1","login":"n0rdlicht","name":"Thorben Westerhuys","avatar_url":"https://avatars-next.observableusercontent.com/7e174f5156ab429bffcb01159d4f4b6dd131b4c29665d4dcc034b71c908d28a4","tier":"starter_2024","bio":"draws. codes. travels. makes. eth architecture graduate. Working on making geo data more accessible @cividi","followed_by_you":false,"follows_you":false},"version":736,"publish_version":736,"role":null,"authored":false,"authors":[{"type":"individual","id":"3917b22397dee990","login":"n0rdlicht","name":"Thorben Westerhuys","avatar_url":"https://avatars-next.observableusercontent.com/7e174f5156ab429bffcb01159d4f4b6dd131b4c29665d4dcc034b71c908d28a4","tier":null,"bio":"draws. codes. travels. makes. eth architecture graduate. Working on making geo data more accessible @cividi","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"3917b22397dee990","login":"n0rdlicht","name":"Thorben Westerhuys","avatar_url":"https://avatars-next.observableusercontent.com/7e174f5156ab429bffcb01159d4f4b6dd131b4c29665d4dcc034b71c908d28a4","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"TransparenZRH","cells":[{"id":0,"value":"md`# TransparenZRH`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":461,"value":"md`Daten geladen: ${tformatter(new Date())}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"md`## Luftqualität\n### Sensor ${air_sensor}\nLetztes Update Sensordaten: ${tformatter(air[0].date)}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"gauges = [\"NO2\",\"O3\",\"PM10\",\"CO\",\"PM2.5\",\"SO2\",\"NO\",\"NOx\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":518,"value":"html`\n${gauges\n .map((d, i) => {\n return `\n \n \n \n `;\n })\n .join('')}\n\n

${d}	${lookup(air, d, 'value')}	${lookup(air, d, 'unit')}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":667,"value":"md`Ozon Trendline: ${spark([...air_sums.get(\"O3\").values()].reverse())}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"md`## Velos\n### Sensor #${bike_sensor} / Lux-Guyer-Weg\nLetztes Update Sensordaten: ${tformatter(velo[0].date)}\n` ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"md`| Zeitraum | # gemessene Velos | |\n| - | - | - |\n| Heute | Wert noch nicht verfügbar | |\n| Gestern / Vorgestern (${tformatter_short(velo[0].date)}) | ${countSum(\n velo.filter(d => d.date > yesterday && d.date < midnight),\n 'value'\n)} | ${velo[0].unit} |\n| Tagesdurchschnitt letzte 7 Tage | ${groupedDayAverage(\n velo.filter(d => d.date > lastweek)\n)} | ${velo[0].unit} |\n| Seit Anfang Jahr | ${countSum(\n velo.filter(d => d.date > newyear),\n 'value'\n)}| ${velo[0].unit} |\n| Tagesdurchschnitt Trend | ${spark(\n [\n ...d3\n .rollup(velo, v => d3.mean(v, d => d.value), d => dateWithoutTime(d.date))\n .values()\n ].reverse()\n)} |\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":456,"value":"md`[Weitere Informationen zur Velozählung]().`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"md`## Fussgänger\n### Sensor #${people_sensor} / Lettenviadukt\nLetztes Update Sensordaten: ${tformatter(fuss[0].date)}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"md`| Zeitraum | # gemessene Personen | |\n| - | - | - |\n| Heute | Wert noch nicht verfügbar | |\n| Gestern / Vorgestern (${tformatter_short(fuss[0].date)}) | ${countSum(\n fuss.filter(d => d.date > yesterday && d.date < midnight),\n 'value'\n)} | ${fuss[0].unit} |\n| Tagesdurchschnitt letzte 7 Tage | ${groupedDayAverage(\n fuss.filter(d => d.date > lastweek)\n)} | ${fuss[0].unit} |\n| Seit Anfang Jahr | ${countSum(\n fuss.filter(d => d.date > newyear),\n 'value'\n)}| ${fuss[0].unit} |\n| Tagessumme Trend | ${spark(\n [\n ...d3\n .rollup(fuss, v => d3.sum(v, d => d.value), d => dateWithoutTime(d.date))\n .values()\n ].reverse()\n)} |\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"md`## Data Loading`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":299,"value":"air_sensor = \"Zch_Stampfenbachstrasse\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":294,"value":"air_raw = d3\n .json(\n `https://data.stadt-zuerich.ch/api/3/action/datastore_search?resource_id=4466ec4a-b215-4134-8973-2f360e53c33d&sort=Datum%20desc&limit=32000&filters={%22Standort%22:%22${air_sensor}%22}`\n )\n .then(function(r) {\n r.result.records.forEach(function(d) {\n d.date = dateParser(d.Datum);\n d.value = +d.Wert;\n d.unit = d.Einheit;\n });\n return r.result.records;\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":630,"value":"air_grouped = d3.group(air_raw, d => dateWithoutTime(d.date))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":654,"value":"air_sums = d3.rollup(\n air_raw,\n v => d3.mean(v, d => d.value),\n d => d.Parameter,\n d => dateWithoutTime(d.date)\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":639,"value":"air = air_grouped.get([...air_grouped.keys()][0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":304,"value":"bike_sensor = \"2997\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":308,"value":"velo = d3.json(`https://data.stadt-zuerich.ch/api/3/action/datastore_search?resource_id=ebe5e78c-a99f-4607-bedc-051f33d75318&sort=DATUM%20desc&filters={%22FK_STANDORT%22:%22${bike_sensor}%22}&limit=32000`).then( function(r) {\n r.result.records.forEach(function(d) {\n d.date = dateParser2(d.DATUM);\n d.value = +d['VELO_IN'] + +d['VELO_OUT'];\n d.unit = 'Velos';\n });\n return r.result.records\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":310,"value":"people_sensor = \"3013\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"fuss = d3.json(`https://data.stadt-zuerich.ch/api/3/action/datastore_search?resource_id=ebe5e78c-a99f-4607-bedc-051f33d75318&sort=DATUM%20desc&filters={%22FK_STANDORT%22:%22${people_sensor}%22}&limit=32000`).then( function(r) {\n r.result.records.forEach(function(d) {\n d.date = dateParser2(d.DATUM);\n d.value = +d['FUSS_IN'] + +d['FUSS_OUT'];\n d.unit = 'Personen';\n });\n return r.result.records\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"md`## Utils`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":593,"value":"function spark(values, width = 200, height = 50) {\n const x = d3\n .scaleLinear()\n .domain([0, values.length - 1])\n .range([0.5, width - 0.5]);\n const y = d3\n .scaleLinear()\n .domain(d3.extent(values))\n .range([height - 0.5, 0.5]);\n const context = DOM.context2d(width, height);\n const line = d3\n .line()\n .x((d, i) => x(i))\n .y(y)\n .context(context);\n context.beginPath(), line(values), context.stroke();\n return context.canvas;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"dateParser = d3.timeParse(\"%Y-%m-%dT%H:%M%Z\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"dateParser2 = d3.timeParse(\"%Y-%m-%dT%H:%M\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":148,"value":"dateParser2(\"2021-01-01T02:30\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"f = d3.formatLocale(\".\",\"'\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"locale = d3.formatLocale({\n decimal: \".\",\n thousands: \"'\",\n grouping: [3],\n currency: [\"\", \"\\u00a0CHF\"],\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":249,"value":"fformat = locale.format(\",.4r\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"fformat(1564)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"lookup = function(array,parameter,key) {\n return array.filter(d => d.Parameter === parameter)[0][key]\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"countSum = function(array,valueKey){\n return fformat(array.map(d => d[valueKey]).reduce((accumulator, currentValue) => accumulator + currentValue))\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":387,"value":"[ ...d3.rollup(velo, v => d3.sum(v, d => d.value), d => dateWithoutTime(d.date)).values() ]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":417,"value":"d3.rollup(fuss, v => d3.sum(v, d => d.value), d => dateWithoutTime(d.date))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":420,"value":"groupedDayAverage = function(array){\n let sums = [ ...d3.rollup(array, v => d3.sum(v, d => d.value), d => dateWithoutTime(d.date)).values() ]\n return fformat(sums.reduce((total, val) => total + val) / sums.length)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"yesterday = new Date(new Date(velo[0].date - 864e5).setHours(0, 0, 0, 0))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":430,"value":"lastweek = new Date(new Date(Date.now() - (864e5 * 7) ).setHours(0,0,0,0))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":183,"value":"midnight = new Date(new Date(Date.now() - 864e5).setHours(23,59,0,0))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"newyear = new Date(new Date().getFullYear(), 0, 1);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":392,"value":"dateWithoutTime = function(d){\n return new Date(d.getFullYear(),d.getMonth(), d.getDate())\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":466,"value":"tformatter = d3.timeFormat('%d.%m. %H:%M')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":726,"value":"tformatter_short = d3.timeFormat('%d.%m.')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"d3 = require(\"d3\", \"d3-array\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4b","stdlib":"1"}} 24:null