3e:null 3f:["$","title",null,{"children":"Experimenting with weatherdata | Tom van Tilburg | Observable"}] 45:T537,{ const brush = vl.selectInterval().encodings('x'); const click = vl.selectMulti().encodings('color'); const scale = { domain: ['sun', 'fog', 'drizzle', 'rain', 'snow'], range: ['#e7ba52', '#a7a7a7', '#aec7e8', '#1f77b4', '#9467bd'] }; const plot1 = vl.markPoint({filled: true}) .encode( vl.color().value('lightgray') .if(brush, vl.color().fieldN('weather').scale(scale).title('Weather')), vl.size().fieldQ('RH').scale({domain: [-1, 20], range: [10, 500]}).title('Precipitation'), vl.order().fieldQ('RH').sort('descending'), vl.x().timeMD('timestamp').axis({title: 'Date', format: '%b'}), //vl.x().fieldT('timestamp'), vl.y().fieldQ('T').scale({domain: [-5, 40]}).axis({title: 'Maximum Daily Temperature (°C)'}) ) .width(width) .height(300) .select(brush) .transform(vl.filter(click)); const plot2 = vl.markBar() .encode( vl.color().value('lightgray') .if(click, vl.color().fieldN('weather').scale(scale).title('Weather')), vl.x().count(), vl.y().fieldN('weather').scale({domain: scale.domain}).title('Weather') ) .width(width) .select(click) .transform(vl.filter(brush)); return vl.vconcat(plot1, plot2) .data(data_2019) .autosize({type: 'fit-x', contains: 'padding'}) .render(); }46:Ta7c,md` ~~~~ YYYYMMDD = date (YYYY=year,MM=month,DD=day) HH = time (HH uur/hour, UT. 12 UT=13 MET, 14 MEZT. Hourly division 05 runs from 04.00 UT to 5.00 UT DD = Mean wind direction (in degrees) during the 10-minute period preceding the time of observation (360=north, 90=east, 180=south, 270=west, 0=calm 990=variable) FH = Hourly mean wind speed (in 0.1 m/s) FF = Mean wind speed (in 0.1 m/s) during the 10-minute period preceding the time of observation FX = Maximum wind gust (in 0.1 m/s) during the hourly division T = Temperature (in 0.1 degrees Celsius) at 1.50 m at the time of observation T10N = Minimum temperature (in 0.1 degrees Celsius) at 0.1 m in the preceding 6-hour period TD = Dew point temperature (in 0.1 degrees Celsius) at 1.50 m at the time of observation SQ = Sunshine duration (in 0.1 hour) during the hourly division, calculated from global radiation (-1 for <0.05 hour) Q = Global radiation (in J/cm2) during the hourly division DR = Precipitation duration (in 0.1 hour) during the hourly division RH = Hourly precipitation amount (in 0.1 mm) (-1 for <0.05 mm) P = Air pressure (in 0.1 hPa) reduced to mean sea level, at the time of observation VV = Horizontal visibility at the time of observation (0=less than 100m, 1=100-200m, 2=200-300m,..., 49=4900-5000m, 50=5-6km, 56=6-7km, 57=7-8km, ..., 79=29-30km, 80=30-35km, 81=35-40km,..., 89=more than 70km) N = Cloud cover (in octants), at the time of observation (9=sky invisible) U = Relative atmospheric humidity (in percents) at 1.50 m at the time of observation WW = Present weather code (00-99), description for the hourly division. IX = Indicator present weather code (1=manned and recorded (using code from visual observations), 2,3=manned and omitted (no significant weather phenomenon to report, not available), 4=automatically recorded (using code from visual observations), 5,6=automatically omitted (no significant weather phenomenon to report, not available), 7=automatically set (using code from automated observations) M = Fog 0=no occurrence, 1=occurred during the preceding hour and/or at the time of observation R = Rainfall 0=no occurrence, 1=occurred during the preceding hour and/or at the time of observation S = Snow 0=no occurrence, 1=occurred during the preceding hour and/or at the time of observation O = Thunder 0=no occurrence, 1=occurred during the preceding hour and/or at the time of observation Y = Ice formation 0=no occurrence, 1=occurred during the preceding hour and/or at the time of observation ~~~~ `47:[{"id":"7fe8043c35efc353d6a2d91cd55b359147a183895739bd8135d4c664689e76896fbcfe30eaee78ba05cb9df4514a4ac997dcaebe430b3f0421badeebbcf629fe","href":"https://static.observableusercontent.com/files/7fe8043c35efc353d6a2d91cd55b359147a183895739bd8135d4c664689e76896fbcfe30eaee78ba05cb9df4514a4ac997dcaebe430b3f0421badeebbcf629fe","name":"stationdata@1.tsv","type":"text/tab-separated-values","lastModified":1578166049159.289,"size":7481114}] 43:{"id":"bc1606f83a74720c","slug":null,"title":"Experimenting with weatherdata","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2020-01-03T20:16:54.618Z","update_time":"$D2023-07-20T19:19:24.515Z","view_time":null,"first_public_time":"$D2023-07-20T19:19:04.735Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"b647bc22a67ec061","login":"tomvantilburg","name":"Tom van Tilburg","avatar_url":"https://avatars-next.observableusercontent.com/4313679a18b29c09b91353f3603285bcd54596364413fe36d682d5984c147b15","tier":"starter_2024","bio":"","following":false},"version":425,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"6a7a260a29251abf","login":"tomvantilburg","name":"Tom van Tilburg","avatar_url":"https://avatars-next.observableusercontent.com/4313679a18b29c09b91353f3603285bcd54596364413fe36d682d5984c147b15","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"6a7a260a29251abf","login":"tomvantilburg","name":"Tom van Tilburg","avatar_url":"https://avatars-next.observableusercontent.com/4313679a18b29c09b91353f3603285bcd54596364413fe36d682d5984c147b15","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Experimenting with weatherdata","cells":[{"id":0,"value":"md`# Experimenting with weatherdata`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"printTable(data.slice(0, 5))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":237,"value":"data_2019 = data.filter(d=>d.timestamp > '2019-01-01')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":102,"value":"$45","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":246,"value":"yeardata = [\n {data:stationdata.filter(d=>d.timestamp >= '2011-01-01' && d.timestamp < '2011-02-01').map(d=>d.Q)},\n {data:stationdata.filter(d=>d.timestamp >= '2012-01-01' && d.timestamp < '2012-02-01').map(d=>d.Q)},\n {data:stationdata.filter(d=>d.timestamp >= '2013-01-01' && d.timestamp < '2013-02-01').map(d=>d.Q)},\n {data:stationdata.filter(d=>d.timestamp >= '2014-01-01' && d.timestamp < '2014-02-01').map(d=>d.Q)},\n {data:stationdata.filter(d=>d.timestamp >= '2015-01-01' && d.timestamp < '2015-02-01').map(d=>d.Q)},\n {data:stationdata.filter(d=>d.timestamp >= '2016-01-01' && d.timestamp < '2016-02-01').map(d=>d.Q)},\n {data:stationdata.filter(d=>d.timestamp >= '2017-01-01' && d.timestamp < '2017-02-01').map(d=>d.Q)},\n {data:stationdata.filter(d=>d.timestamp >= '2018-01-01' && d.timestamp < '2018-02-01').map(d=>d.Q)},\n {data:stationdata.filter(d=>d.timestamp >= '2019-01-01' && d.timestamp < '2019-02-01').map(d=>d.Q)}\n ]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"vl.data(yeardata)\n .transform(\n vl.window(vl.row_number().as('series')), // add index for each series\n vl.flatten('data'), // flatten each series array to individual data points\n vl.groupby('series').window(vl.row_number().as('index')) // add index for each point\n )\n .mark({type: 'line', fill: 'white', stroke: 'black', strokeWidth: 1})\n .encode(\n vl.x().fieldQ('index').axis(null),\n vl.y().fieldQ('data').scale({range: [step, -overlap * step]}).axis(null),\n vl.row().fieldN('series').header({title: null, labelPadding: 0, labelFontSize: 0})\n )\n .width(width) // facet cell width\n .height(step) // facet cell height\n .bounds('flush') // use facet cell height for layout, not the full mark bounds \n .spacing(0) // zero spacing between facet cells\n .padding(0) // no chart padding\n .config({view: {stroke: null}}) // no cell borders\n .render()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"step = 8 // base height for each data series","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":244,"value":"overlap = 6 // overlap scale factor for data series","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":" vl.markPoint()\n .data(sunhours.all())\n .encode(\n vl.x().timeMD('key').axis({title: 'Date', format: '%b'}),\n vl.y().fieldQ('value')\n )\n .render()\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"data = FileAttachment(\"stationdata@1.tsv\").text().then(d=> d3.tsvParse(d, d3.autoType))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":186,"value":"stationdata = crossfilter(data.map(r=>{return {\n timestamp: new Date(r.timestamp),\n STN: r.STN,\n DD: r.DD,\n FH: r.FH/10,\n FF: r.FF/10,\n FX: r.FX/10,\n T: r.T/10,\n T10: r.T10/10,\n TD: r.TD/10,\n SQ: r.SQ/10,\n Q: r.Q,\n DR: r.DR/10,\n RH: r.RH/10,\n P: r.P/10,\n VV: r.VV,\n N: r.N,\n U: r.U,\n WW: r.WW,\n IX: r.IX,\n M: r.M,\n R: r.R,\n S: r.S,\n O: r.O,\n Y: r.Y,\n weather: r.SQ>0.1?'sun':r.S==1?'snow':r.M==1?'fog':r.R==1?'rain':'sun'\n}}));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"date_dim = stationdata.dimension(d=>d.timestamp);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":337,"value":"sunhours = date_dim.group(d3.timeDay).reduceSum(d=>d.SQ);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"temp = date_dim.group(d3.timeDay).reduceSum(d=>d.T).all();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":414,"value":"new Date('2011-01-02T00:00') - 1970","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"joined = sunhours.all().map(d=>{return {time:d.key,sun: d.value,temp: temp[d.key-1970]}})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":348,"value":"sunhours.all()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":257,"value":"crossfilter = require('https://bundle.run/crossfilter2@1.4.5')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":355,"value":"universe = require('https://npmcdn.com/universe@latest/universe.min.js')\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"import {vl} from '@vega/vega-lite-api'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"import {printTable} from '@uwdata/data-utilities'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W47","stdlib":"1"}} 44:"$43:body"