2f:T659,Plot.plot({ width: 1200, height: 1200, color: { scheme: "viridis" }, projection: { type: "azimuthal-equidistant", rotate: [0, -90], // Note: 0.625° corresponds to max. length (here, 0.5), plus enough room for the labels domain: d3.geoCircle().center([0, 90]).radius(1)() }, //width: 1200, marks:[ // discs Plot.geo([1.0,0.9,0.8,0.7,0.6,0.5, 0.4, 0.3, 0.2, 0.1], { geometry: (r) => d3.geoCircle().center([0, 90]).radius(r)(), stroke: "black", fill: "none", strokeOpacity: 0.3, fillOpacity: 0.03, strokeWidth: 0.5 }), // white axes Plot.link(longitude.domain(), { x1: longitude, y1: 90 - 2, x2: 0, y2: 90, stroke: "lightgrey", strokeOpacity: 0.5, strokeWidth: 1 }), Plot.line(temp, { x: d=> longitude(d.month), y: d=> 90 - scale(d.temp), fill: "none", stroke: "year", opacity: 0.5 //curve: "cardinal-closed", }), Plot.dot(temp, { x: d=> longitude(d.month), y: d=> 90 - scale(d.temp), fill: "year", r: 2, stroke: "white", strokeWidth: 0.5, title: d=>d.year + ' ' + d.month }), Plot.line([1,2,3,4,5,6,7,8,9,10,11,12],{ x: d=>Math.sin( (d/12.0 ) * 2 * Math.PI ), y: d=>Math.cos( (d/12.0 ) * 2 * Math.PI ), stroke: 'black',curve: "catmull-rom" }) /* Plot.line(temp, {x: 'date', y: 'daytemp',stroke: 'grey'}), Plot.line(temp, {x: 'date', y: 'maxdaytemp',stroke: 'darkred'}), Plot.line(temp, {x: 'date', y: 'mindaytemp',stroke: 'steelblue'}), */ ]})30:T65d,

Vandaag in De Bilt

${weatherToday.daily.temperature_2m_max[0]}°

${weatherToday.daily.temperature_2m_min[0]}°

Gemiddelde in maand ${getCurrentMonth()}

${getWeatherBlock("1901 - 1920", ...getAverageTemperaturesByMonthAndYearRange(getCurrentMonth(), 1901, 1920))} ${getWeatherBlock("1920 - 1940", ...getAverageTemperaturesByMonthAndYearRange(getCurrentMonth(), 1920, 1940))} ${getWeatherBlock("1940 - 1960", ...getAverageTemperaturesByMonthAndYearRange(getCurrentMonth(), 1940, 1960))} ${getWeatherBlock("1960 - 1980", ...getAverageTemperaturesByMonthAndYearRange(getCurrentMonth(), 1960, 1980))} ${getWeatherBlock("1980 - 2000", ...getAverageTemperaturesByMonthAndYearRange(getCurrentMonth(), 1980, 2000))} ${getWeatherBlock("2000 - 2020", ...getAverageTemperaturesByMonthAndYearRange(getCurrentMonth(), 2000, 2020))} ${getWeatherBlock("2021 - 2022", ...getAverageTemperaturesByMonthAndYearRange(getCurrentMonth(), 2021, 2022))}

31:[{"id":"eeb9b2ff8f8bef506be980d270637de4efc4649fdbd7f936bbd856988b35b944ecba3f6cfdc2e2e29d7fb066fe21a5fadbe1090870df9f19c9ff531c056e7fc9","href":"https://static.observableusercontent.com/files/eeb9b2ff8f8bef506be980d270637de4efc4649fdbd7f936bbd856988b35b944ecba3f6cfdc2e2e29d7fb066fe21a5fadbe1090870df9f19c9ff531c056e7fc9","name":"etmgeg_260.parquet","type":"application/octet-stream","lastModified":1690359948656.428,"size":2793752}] 2d:{"title":"Temperatuur in de Bilt","cells":[{"id":0,"value":"# Temperatuur in de Bilt","pinned":false,"hidden":false,"mode":"md"},{"id":124,"value":"scale = d3.scaleLinear().domain([\n d3.min(temp,d=>d.temp),\n d3.max(temp,d=>d.temp)\n]).range([0,0.9])","pinned":true,"hidden":false,"mode":"ojs"},{"id":177,"value":"longitude = d3.scalePoint([1,2,3,4,5,6,7,8,9,10,11,12], [180, -180]).padding(0.5).align(1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":17,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs"},{"id":154,"value":"Plot.line(temp,{x: 'date',y: 'temp', stroke: 'year'}).plot()","pinned":true,"hidden":false,"mode":"ojs"},{"id":70,"value":"Plot.plot({\n color:{\n legend: true\n },\n marks: [\n Plot.dot(temp, {x: 'temp', y: 'precip', opacity: 0.01})\n]})","pinned":true,"hidden":false,"mode":"ojs"},{"id":7,"value":"temp = data.query(`\nSELECT \n date_trunc('month',strptime(YYYYMMDD, '%Y%m%d')) as date,\n date_part('month',strptime(YYYYMMDD, '%Y%m%d')) as month,\n date_part('year',strptime(YYYYMMDD, '%Y%m%d')) as year,\n\n avg(TG)/10.0 + 1 AS temp,\n avg(TN)/10.0 AS mintemp,\n avg(TX)/10.0 AS maxtemp,\n avg(RH)/10.0 AS precip,\n/*\n avg(TG) OVER (\n ORDER BY strptime(YYYYMMDD, '%Y%m%d') ASC\n RANGE BETWEEN INTERVAL (1) YEARS PRECEDING\n AND INTERVAL (1) YEARS FOLLOWING) / 10.0 AS daytemp,\n min(TN) OVER (\n ORDER BY strptime(YYYYMMDD, '%Y%m%d') ASC\n RANGE BETWEEN INTERVAL (1) YEARS PRECEDING\n AND INTERVAL (1) YEARS FOLLOWING) / 10.0 AS mindaytemp,\n max(TX) OVER (\n ORDER BY strptime(YYYYMMDD, '%Y%m%d') ASC\n RANGE BETWEEN INTERVAL (1) YEARS PRECEDING\n AND INTERVAL (1) YEARS FOLLOWING) / 10.0 AS maxdaytemp\n */\nFROM debilt \n--WHERE YYYYMMDD BETWEEN 20180101 AND 20190101\nGROUP BY date, month,year\nORDER BY year, month\n`)","pinned":true,"hidden":false,"mode":"ojs"},{"id":5,"value":"data = DuckDBClient.of({debilt: FileAttachment(\"etmgeg_260.parquet\")})","pinned":true,"hidden":false,"mode":"ojs"},{"id":39,"value":"import {linearRegression} from \"9fc6187b5f9d2293\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":265,"value":"async function fetchWeatherToday(startDate, endDate) {\n const url = `https://api.open-meteo.com/v1/forecast?latitude=52.11&longitude=5.1806&daily=temperature_2m_max,temperature_2m_min&timezone=auto&start_date=${startDate}&end_date=${endDate}`;\n\n try {\n const response = await fetch(url);\n if (!response.ok) {\n throw new Error('Network response was not ok');\n }\n\n const data = await response.json();\n return data;\n } catch (error) {\n console.error('Error fetching data:', error);\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":272,"value":"function getCurrentDateFormatted() {\n const today = new Date();\n const year = today.getFullYear().toString();\n const month = (today.getMonth() + 1).toString().padStart(2, '0');\n const day = today.getDate().toString().padStart(2, '0');\n\n return `${year}-${month}-${day}`;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":331,"value":"function getCurrentMonth() {\n const currentDate = new Date();\n const currentMonth = currentDate.getMonth() + 1; \n \n return currentMonth;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":267,"value":"weatherToday = await fetchWeatherToday(getCurrentDateFormatted(), getCurrentDateFormatted());","pinned":true,"hidden":false,"mode":"ojs"},{"id":302,"value":"function getAverageTemperaturesByMonthAndYearRange(targetMonth, minYear, maxYear) {\n const filteredData = temp.filter(entry => {\n const entryMonth = entry.month;\n const entryYear = entry.year;\n return entryMonth === targetMonth && entryYear >= minYear && entryYear <= maxYear;\n });\n\n if (filteredData.length === 0) {\n return {\n avgMinTemp: null,\n avgMaxTemp: null\n };\n }\n\n const totalMinTemp = filteredData.reduce((sum, entry) => sum + entry.mintemp, 0);\n const totalMaxTemp = filteredData.reduce((sum, entry) => sum + entry.maxtemp, 0);\n\n const avgMinTemp = totalMinTemp / filteredData.length;\n const avgMaxTemp = totalMaxTemp / filteredData.length;\n\n return [avgMinTemp.toFixed(1), avgMaxTemp.toFixed(1)];\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":292,"value":"function getWeatherBlock(heading, min, max) {\n const block = html`\n

\n ${heading}\n

${max}°

${min}°

\n `\n return block;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":278,"value":"$30","pinned":false,"hidden":false,"mode":"html"}],"files":"$W31","stdlib":"1","titling":"auto"}