2b:null 2c:["$","title",null,{"children":"Phänologischer Frühling | RND | Observable"}] 31:T7ad,frühling_chart = Plot.plot({ width, height: 450, grid: true, marginBottom: 20, x: { interval: "day", domain: [new Date(2023,1,1),new Date(2023,3,2)], ticks: 3, tickSize: 0, axis: "top", tickFormat: d => d.toLocaleString("de", {day: "numeric", month: "short"}) }, y: { domain: d3.sort(forsythie_mittel_station, d => d.num).map(d => d.name.split('-')[0]), axis: null, grid: true }, marks: [ Plot.text([0], { textAnchor: "end", x: d => date, y: d => name, text: d => "2023", fill: "#e84f1c", dx: 3, dy: -12 }), Plot.text([0], { textAnchor: "start", x: d => date_mittel, y: d => name, text: d => "2000er", fill: "#4f80ff", dx: -3, dy: -12 }), Plot.text(forsythie_mittel_station, { textAnchor: "start", x: d => d.date, y: d => d.name.split('-')[0], text: (d) => `${d.name.split('-')[0]}`, dx: -3, dy: 12 }), Plot.text(forsythie_mittel_station, { textAnchor: "start", x: d => d.date, y: d => d.name.split('-')[0], fill: "#99AFC2", text: (d) => `${d.land}`, dx: -3, dy: 25 }), Plot.ruleY(forsythie_mittel_station, { y: d => d.name.split('-')[0], x1: d => d.date_mittel, x2: d => d.date, stroke: "#99AFC2", strokeWidth: 2 }), Plot.dot(forsythie_mittel_station, { x: d => d.date, y: d => d.name.split('-')[0], fill: "#e84f1c", stroke: "#e84f1c", title: d => `${d.date.toLocaleString("de", {day: "numeric", month: "long"})}` }), Plot.dot(forsythie_mittel_station, { x: d => d.date_mittel, y: d => d.name.split('-')[0], fill: "#4f80ff", stroke: "#4f80ff", title: d => `${d.date_mittel.toLocaleString("de", {day: "numeric", month: "long"})}` }) ] })32:T85b,function Swatches(color, { columns = null, format, unknown: formatUnknown, swatchSize = 15, swatchWidth = swatchSize, swatchHeight = swatchSize, marginLeft = 0 } = {}) { const id = `-swatches-${Math.random().toString(16).slice(2)}`; const unknown = formatUnknown == null ? undefined : color.unknown(); const unknowns = unknown == null || unknown === d3.scaleImplicit ? [] : [unknown]; const domain = color.domain().concat(unknowns); if (format === undefined) format = x => x === unknown ? formatUnknown : x; function entity(character) { return `&#${character.charCodeAt(0).toString()};`; } if (columns !== null) return htl.html`

${domain.map(value => { const label = `${format(value)}`; return htl.html`

${label}

`; })}

`; return htl.html`

${domain.map(value => htl.html`${format(value)}`)}

`; }33:T704,myStyles = html` `34:[{"id":"9a431288474137a5137913ac5a61d3575c77dba072b8c1f7b24c0052283b516c80a5d2c551a10997e8574e9b332686d79cfd3dc411662e13146324bab4f35d6f","href":"https://static.observableusercontent.com/files/9a431288474137a5137913ac5a61d3575c77dba072b8c1f7b24c0052283b516c80a5d2c551a10997e8574e9b332686d79cfd3dc411662e13146324bab4f35d6f","name":"dwd_plz@3.csv","type":"text/csv","lastModified":1679910278165.008,"size":852786},{"id":"28a3cd8f58a1800bcbcb1d82805e9d9823c283b8535684e77db4ab2014f396fb69eeff2295116e43f6894a4ab3f2ec25544b240aec23e1c44b1bcd0a1a2c4a69","href":"https://static.observableusercontent.com/files/28a3cd8f58a1800bcbcb1d82805e9d9823c283b8535684e77db4ab2014f396fb69eeff2295116e43f6894a4ab3f2ec25544b240aec23e1c44b1bcd0a1a2c4a69","name":"deutschland.geojson","type":"application/geo+json","lastModified":1679568250050.645,"size":2929181},{"id":"960af33e4cf5fc5df7a6dbef6a3a7e726651afd53705e147aee8fdbb47a0e737e1ce6d065df24c6ac82bcb0d52844008525779152c7107557e2fcac3e3dfc132","href":"https://static.observableusercontent.com/files/960af33e4cf5fc5df7a6dbef6a3a7e726651afd53705e147aee8fdbb47a0e737e1ce6d065df24c6ac82bcb0d52844008525779152c7107557e2fcac3e3dfc132","name":"forsythie_mittel@9.csv","type":"text/csv","lastModified":1679910294209.441,"size":26148}] 2f:{"id":"9fdd8241e56e031f","slug":"phanologischer-fruhling","title":"Phänologischer Frühling","thumbnail":"bba808c97cfc008eeaaae7abc297ab88378c2209b62f3cecd5a2a5e0a2a55769","access_level":"public","create_time":"$D2023-03-23T10:42:39.648Z","update_time":"$D2025-03-17T16:33:28.231Z","view_time":null,"first_public_time":"$D2023-03-27T09:49:13.741Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"b8db01b7dd27a055","login":"rnd","name":"RND","avatar_url":"https://avatars-next.observableusercontent.com/8cd6e8f8a280701f2c59b563c390950d7287c4e64c058ec466b6042ca5b6e9e1","tier":"starter_2024"},"version":1152,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"5f9b41b7f852d3da","login":"rnd","name":"RND","avatar_url":"https://avatars-next.observableusercontent.com/8cd6e8f8a280701f2c59b563c390950d7287c4e64c058ec466b6042ca5b6e9e1","tier":null}],"members":[{"type":"individual","id":"5f9b41b7f852d3da","login":"rnd","name":"RND","avatar_url":"https://avatars-next.observableusercontent.com/8cd6e8f8a280701f2c59b563c390950d7287c4e64c058ec466b6042ca5b6e9e1","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"title":"Phänologischer Frühling","cells":[{"id":0,"value":"# Phänologischer Frühling","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":507,"value":"title = html`\n

Wo die Forsythien blühen

\n Beobachtete Blüten bis Kalenderwoche ${week_input} vom ${first_day.toLocaleString(\"de\", {day: \"numeric\", month: \"numeric\", year: \"numeric\"})} bis ${last_day.toLocaleString(\"de\", {day: \"numeric\", month: \"numeric\", year: \"numeric\"})}

\n

\n `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"viewof week_input = Inputs.range([6, 12], {label: \"Kalenderwoche:\", step: 1, value: 14})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":418,"value":"legend = Swatches(d3.scaleOrdinal(domain_filtered, range_filtered))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"frühling_map = Plot.plot({\n width, \n \n color: { \n domain: domain,\n range: range,\n legend: false\n }, \n \n projection: { \n type: \"mercator\", \n domain: deutschland },\n \n marks: [\n\n Plot.geo(deutschland, { \n fill: \"#597A96\",\n fillOpacity: 1,\n stroke: \"#fff\",\n strokeWidth: 0,\n strokeOpacity: 0.75\n }),\n\n Plot.density(forsythie_mittel, {\n x: \"lon\",\n y: \"lat\",\n z: \"week\",\n thresholds: 6,\n stroke: \"week\",\n fill: \"week\",\n fillOpacity: 0.7,\n opacity: 0.08\n }),\n \n Plot.dot(forsythie_mittel.filter(d => d.week <= week_input), {\n x: \"lon\",\n y: \"lat\",\n r: 5,\n fill: \"week\",\n title: (d) => `${d.name}`,\n fillOpacity: 0.8\n })\n \n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":525,"value":"credits_map = md`

Quelle: DWD

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":557,"value":"viewof plz_input = Inputs.text({label: \"PLZ oder Ort:\", value: \"30459 Hannover\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1135,"value":"plz_input","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1019,"value":"answer = md`An der nächstgelegenen Beobachtungsstelle in ${name} (${land}) hat 2023 der Erstfrühling (Forsythienblüte) ${textcolor(\n (diff * -1).toLocaleString(\"de\", {\n minimumFractionDigits: \"0\",\n maximumFractionDigits: \"0\"\n }) + \" Tage\",\n {\n background: \"#e84f1c\",\n fontSize: \"16px\",\n fontFamily: \"Source Serif Pro\",\n fontWeight: 400,\n padding: \"0px 5px 0px 5px\"\n }\n)} früher begonnen als im Durchschnitt der Jahre 2000 bis 2010.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":607,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1060,"value":"credits_chart = md`

Quelle: DWD, eigene Berechnung

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":923,"value":"name = forsythie_mittel_station[0].name.split('-')[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1028,"value":"land = forsythie_mittel_station[0].land","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":932,"value":"date = forsythie_mittel_station[0].date","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":938,"value":"date_mittel = forsythie_mittel_station[0].date_mittel","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1038,"value":"diff = forsythie_mittel_station[0].diff","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":706,"value":"select ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS num, * from (\n SELECT id, date, name, kreis, land, date_mittel, diff\n FROM forsythie_mittel\n WHERE id = 8261\n OR id = 10176\n OR id = 15937\n OR id = 13400\n OR id = 12335\n OR id = 9087\n OR id = 19478\n OR id = 8844\n \n OR id = ${id_plz}\n ORDER BY (id = ${id_plz}) DESC, date ASC\n ) ","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"forsythie_mittel_station","database":"var:forsythie_mittel"},{"id":560,"value":"id_plz_name_long = dwd_plz.filter(d => d.plz_name_long.toLowerCase() === plz_input.toLowerCase()).map(d => {return d.id})[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":562,"value":"id_plz_code = dwd_plz.filter(d => d.plz_code === plz_input.replace(/\\s+/g, '').replace(/[^0-9]/g, '')).map(d => {return d.id})[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":564,"value":"id_plz_name = dwd_plz.filter(d => d.plz_name.toLowerCase() === plz_input.toLowerCase()).map(d => {return d.id})[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":566,"value":"id_plz_name_short = dwd_plz.filter(d => d.name_short.toLowerCase() === plz_input.toLowerCase()).map(d => {return d.id})[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":568,"value":"id_plz = id_plz_code ?? id_plz_name_long ?? id_plz_name ?? id_plz_name_short","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":552,"value":"dwd_plz = FileAttachment(\"dwd_plz@3.csv\").csv().then(\n function(data) {\n data.forEach(function(d) {\n d.id = +d.id;\n });\n return data;\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":231,"value":"forsythie_mittel = FileAttachment(\"forsythie_mittel@9.csv\").csv().then(\n function(data) {\n data.forEach(function(d) {\n d.tag = +d.tag;\n d.week = +d.week;\n d.month = +d.month;\n d.year = +d.year;\n d.mittel = +d.mittel;\n d.diff = +d.diff;\n d.date = new Date(d.date);\n d.date_mittel = new Date(d.date_mittel);\n });\n return data;\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"deutschland = FileAttachment(\"deutschland.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"number_weeks = week_input - 6","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":390,"value":"domain = [7,8,9,10,11,12]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"domain_filtered = domain.slice(0, number_weeks)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":386,"value":"range = [\"#780000\", \"#b82100\", \"#e84f1c\", \"#ff7842\", \"#DCE4EA\", \"#7ca2ff\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":392,"value":"range_filtered = range.slice(0, number_weeks)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":438,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":351,"value":"last_day = roundUTCDay(getLastDateOfWeek(week_input, 2023))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":363,"value":"first_day = roundUTCDay(getFirstDateOfWeek(week_input, 2023))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"function getLastDateOfWeek(w, y) {\n var d = (2 + (w - 1) * 7);\n\n return new Date(y, 0, d);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":370,"value":"function getFirstDateOfWeek(w, y) {\n var d = (2 + (w - 1) * 7) - 7 ;\n\n return new Date(y, 0, d);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"function roundUTCDay(d) {\n return new Date(Date.UTC(d.getUTCFullYear(), d.getUTCMonth(), d.getUTCDate() + (d.getUTCHours() < 12 ? 0 : 1)));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1034,"value":"import {textcolor} from \"@observablehq/text-color-annotations-in-markdown\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1083,"value":"import {rewind} from \"@fil/rewind\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":458,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 30:"$2f:body"