25:["$","title",null,{"children":"Weather Exploring | Alexey Smagin | Observable"}] 49:T47f,tempStatuses = weatherDT .derive({ day_month: aq.escape((obs) => new Date(obs.date).toLocaleString('default').slice(0, 5)) }) .join(refPeriodTemps) .derive({ year: aq.escape((obs) => new Date(obs.date).getFullYear()), temp_diff: aq.escape((obs) => obs.t_avg - obs.refPeriodMean), status: aq.escape((obs) => { if (obs.t_avg > obs.refPeriodMean + deviation) return 'hot' else if (obs.t_avg < obs.refPeriodMean - deviation) return 'cold' else return 'normal' }), period: aq.escape((obs) => { if (obs.date >= new Date(refPeriod['start']) & obs.date < new Date(refPeriod['end'])) return 'reference' else if (obs.date >= new Date(refPeriod['now'])) return 'now' else return 'junk' }) }) .derive({ yearGroup: aq.escape((obs) => { for (let i = 0; i < yearStarts.length; i++) { if ((obs.year >= yearStarts[i]) && (obs.year < yearStarts[i] + yearsGroupLen)) return yearStarts[i] } }) }) .select(['date', 'city', 'status', 'year', 'yearGroup', 't_min', 't_max', 't_avg', 'temp_diff', 'period'])4a:T509,hwCsEvents = { var temp_statuses_objects = tempStatuses.objects() for (let i = 0; i < temp_statuses_objects.length; i++) { if (temp_statuses_objects[i]['status'] == "normal") temp_statuses_objects[i]['status_days'] = 0 else if (temp_statuses_objects[i]['status'] == "hot") if ((i == 0) || (temp_statuses_objects[i]['city'] != temp_statuses_objects[i-1]['city'])) temp_statuses_objects[i]['status_days'] = 1 else temp_statuses_objects[i]['status_days'] = temp_statuses_objects[i-1]['status_days'] + 1 else if (temp_statuses_objects[i]['status'] == "cold") if ((i == 0) || (temp_statuses_objects[i]['city'] != temp_statuses_objects[i-1]['city'])) temp_statuses_objects[i]['status_days'] = -1 else temp_statuses_objects[i]['status_days'] = temp_statuses_objects[i-1]['status_days'] - 1 } for (let i = temp_statuses_objects.length-1; i >= 0 ; i--) { if (temp_statuses_objects[i]['status_days'] >= heatwave_days_limit) temp_statuses_objects[i]['hw/sc'] = 'heatwave' else if (temp_statuses_objects[i]['status_days'] <= -1 * heatwave_days_limit) temp_statuses_objects[i]['hw/sc'] = 'coldspell' else temp_statuses_objects[i]['hw/sc'] = 'normal' } return temp_statuses_objects }4b:T69e,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(hotDays.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(hotDays, { x: "yearGroup", y: "days", fx: (d) => fx(d.city), fy: (d) => fy(d.city), fill: "#E74C3C", opacity: 0.6, channels: { days: { value: "days", label: "hot days" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.tickY(coldDays, { x: "yearGroup", y: "days", fx: (d) => fx(d.city), fy: (d) => fy(d.city), fill: "#3498DB", fillOpacity: 0.3, stroke: "#3498DB", curve: "step", strokeWidth: 2 }), Plot.axisY({ tickSpacing: 20, nice: true, label: "дней" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())4c:T6ae,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(hotDays.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(hwEventsCount, { x: "yearGroup", y: "count", fx: (d) => fx(d.city), fy: (d) => fy(d.city), fill: "#E74C3C", opacity: 0.6, channels: { count: { value: "count", label: "hw events" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.tickY(csEventsCount, { x: "yearGroup", y: "count", fx: (d) => fx(d.city), fy: (d) => fy(d.city), fill: "#3498DB", fillOpacity: 0.3, stroke: "#3498DB", curve: "step", strokeWidth: 2 }), Plot.axisY({ tickSpacing: 20, nice: true, label: "дней" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())4d:T576,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(selected_temp_statuses.objects().map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { grid: true, height: 600, width: 1000, marginTop: -10, color: { legend: true, range: ["#3498DB", "#E74C3C", "#fff"] }, x: { tickFormat: (d) => (d.toLocaleString("ru", {month: 'short'})), tickSize: 0, grid: false }, y: { tickFormat: (d) => {if ([...Array(5)].map((x,i)=>1960 + i*15).includes(d)) return `${d}` else return ""}, tickSize: 0, grid: false, insetBottom: -1, insetTop: 10 }, fx: {tickFormat: null}, fy: {tickFormat: null}, marks: [ Plot.barX(selected_temp_statuses, { x: (d) => new Date("0/" + d.date.toLocaleString("en", { "month": "numeric", "day": "numeric" })), y: (d) => { return d.year }, fx: (d) => fx(d.city), fy: (d) => fy(d.city), fill: "hw/sc", interval: "day", inset: 0 // no gaps }), Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 0, dy: 0}) ] } })())4e:T1077,seasonsData = { var tempStatusesObjects = tempStatuses.objects() const daysToCheck = 15 var citiesFirstLast = {}; var dateStart, dateEnd for (let i = 0; i < tempStatusesObjects.length; i++) { if (!(tempStatusesObjects[i]['city'] in citiesFirstLast)) { citiesFirstLast[tempStatusesObjects[i]['city']] = {} citiesFirstLast[tempStatusesObjects[i]['city']]['first'] = i if (i != 0) { citiesFirstLast[tempStatusesObjects[i-1]['city']]['last'] = i - 1 } } if (i == tempStatusesObjects.length - 1) { citiesFirstLast[tempStatusesObjects[i]['city']]['last'] = i } dateStart = new Date(tempStatusesObjects[i]['year'] + "-" + dateRangeStart) dateEnd = new Date(tempStatusesObjects[i]['year'] + "-" + dateRangeEnd) if ((tempStatusesObjects[i]['date'] > dateStart) && (tempStatusesObjects[i]['date'] < dateEnd)) { tempStatusesObjects[i]['opacity'] = "true" } else tempStatusesObjects[i]['opacity'] = "false" tempStatusesObjects[i]['calendarSeason'] = getSeason(tempStatusesObjects[i]['date']) tempStatusesObjects[i]['month'] = tempStatusesObjects[i]['date'].getMonth() if (tempStatusesObjects[i]['t_avg'] < 0) tempStatusesObjects[i]['avgTempGroup'] = '< 0' else if (tempStatusesObjects[i]['t_avg'] > 15) tempStatusesObjects[i]['avgTempGroup'] = '> 15' else tempStatusesObjects[i]['avgTempGroup'] = '0-15' if (tempStatusesObjects[i]['t_avg'] < -10) tempStatusesObjects[i]['avgTempGroup2'] = '< -10' else if (tempStatusesObjects[i]['t_avg'] < 0) tempStatusesObjects[i]['avgTempGroup2'] = '-10-0' else if (tempStatusesObjects[i]['t_avg'] > 25) tempStatusesObjects[i]['avgTempGroup2'] = '> 25' else if (tempStatusesObjects[i]['t_avg'] > 15) tempStatusesObjects[i]['avgTempGroup2'] = '> 15' else tempStatusesObjects[i]['avgTempGroup2'] = '0-15' if (tempStatusesObjects[i]['t_min'] < -10) tempStatusesObjects[i]['minTempGroup'] = '< -10' else if (tempStatusesObjects[i]['t_min'] < 0) tempStatusesObjects[i]['minTempGroup'] = '-10-0' else if (tempStatusesObjects[i]['t_min'] > 25) tempStatusesObjects[i]['minTempGroup'] = '> 25' else if (tempStatusesObjects[i]['t_min'] > 15) tempStatusesObjects[i]['minTempGroup'] = '> 15' else tempStatusesObjects[i]['minTempGroup'] = '0-15' if (tempStatusesObjects[i]['t_max'] < -10) tempStatusesObjects[i]['maxTempGroup'] = '< -10' else if (tempStatusesObjects[i]['t_max'] < 0) tempStatusesObjects[i]['maxTempGroup'] = '-10-0' if (tempStatusesObjects[i]['t_max'] < 0) tempStatusesObjects[i]['maxTempGroup'] = '< 0' else if (tempStatusesObjects[i]['t_max'] > 25) tempStatusesObjects[i]['maxTempGroup'] = '> 25' else if (tempStatusesObjects[i]['t_max'] > 15) tempStatusesObjects[i]['maxTempGroup'] = '> 15' else tempStatusesObjects[i]['maxTempGroup'] = '0-15' } var startIndex = 0 var endIndex = 0 for (let i = 0; i < tempStatusesObjects.length; i++) { startIndex = i - daysToCheck endIndex = i + daysToCheck if (i - daysToCheck < citiesFirstLast[tempStatusesObjects[i]['city']]['first']) startIndex = citiesFirstLast[tempStatusesObjects[i]['city']]['first'] if (i + daysToCheck > citiesFirstLast[tempStatusesObjects[i]['city']]['last']) endIndex = citiesFirstLast[tempStatusesObjects[i]['city']]['last'] tempStatusesObjects[i]['season'] = mostFrequent(tempStatusesObjects.slice(startIndex, endIndex).map((d) => d.avgTempGroup)) } for (let i = 0; i < tempStatusesObjects.length; i++) { startIndex = i - daysToCheck endIndex = i + daysToCheck if (i - daysToCheck < citiesFirstLast[tempStatusesObjects[i]['city']]['first']) startIndex = citiesFirstLast[tempStatusesObjects[i]['city']]['first'] if (i + daysToCheck > citiesFirstLast[tempStatusesObjects[i]['city']]['last']) endIndex = citiesFirstLast[tempStatusesObjects[i]['city']]['last'] tempStatusesObjects[i]['season2'] = mostFrequent(tempStatusesObjects.slice(startIndex, endIndex).map((d) => d.season)) } return tempStatusesObjects }4f:T97d,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(selectedSeasonsData.objects().map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { grid: true, marginTop: -10, height: 600, width: 900, color: pallete, x: { tickFormat: (d) => (d.toLocaleString("ru", {month: 'short'})), tickSize: 0, grid: true, ticks: cityInputSeasons == "Все" ? 3 : 12 }, y: { tickFormat: (d) => {if ([...Array(5)].map((x,i)=>1960 + i*15).includes(d)) return `${d}` else return ""}, tickSize: 0, grid: false, insetBottom: -1, insetTop: 10 }, fx: {tickFormat: null}, fy: {tickFormat: null}, marks: [ Plot.barX(selectedSeasonsData, { x: (d) => new Date("0/" + d.date.toLocaleString("en", { "month": "numeric", "day": "numeric" })), y: (d) => { return d.year }, fx: (d) => fx(d.city), fy: (d) => fy(d.city), fill: (d) => { if (seasonRadio.value == "seasons") return d.season2 else if (seasonRadio.value == "temp") return d.avgTempGroup2 else if (seasonRadio.value == "minTemp") return d.minTempGroup else if (seasonRadio.value == "maxTemp") return d.maxTempGroup else if (seasonRadio.value == "val") return d.t_avg else if (seasonRadio.value == "val_min") return d.t_min else if (seasonRadio.value == "val_max") return d.t_max }, opacity: (d) => { if (d.opacity == "true") return 1 else return 0.3 }, interval: "day", inset: 0, // no gaps channels: { t_avg: { value: "t_avg", label: "avg. temp" }, date: "date", cur_season: "cur_season" }, tip: { format: { x: false, y: false, fx: false, fy: false, opacity: false } } }), Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 0, dy: 0}) ] } })())50:T439,Plot.plot({ width: 928, height: 300, x: { axis: "top", ticks: 0, label: null }, y: { tickFormat: d => `${d}`, label: null }, fx: { label: null }, color: { range: ["#004e82", "#22575C", "#fcf2ec", "#F0CA4D", "#DE5B49"], legend: "ramp", width: 340, label: "Температура", domain: ["< -10", "-10-0", "0-15", "> 15", "> 25"], }, marks: [ Plot.barX(seasonPercents, { x: "count", y: "yearGroup", fx: seasonsSplit == "Да" ? "calendarSeason": null, fill: (d) => { if (seasonRadio2.value == "seasons") return d.season2 else if (seasonRadio2.value == "temp") return d.avgTempGroup2 else if (seasonRadio2.value == "minTemp") return d.minTempGroup else if (seasonRadio2.value == "maxTemp") return d.maxTempGroup }, offset: "normalize", order: [ "< -10", "-10-0", "0-15", "> 15", "> 25" ], tip: true }), Plot.ruleX([0]) ] })51:T595,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(extremePrecipDays.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(extremePrecipDays, { x: "yearGroup", y: "count", fx: (d) => fx(d.city), fy: (d) => fy(d.city), opacity: 0.6, channels: { count: { value: "count", label: "hot days" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.axisY({ tickSpacing: 20, nice: true, label: "дней" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())52:T587,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(precipDays.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(precipDays, { x: "yearGroup", y: "count", fx: (d) => fx(d.city), fy: (d) => fy(d.city), opacity: 0.6, channels: { count: { value: "count", label: "hot days" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.axisY({ tickSpacing: 20, nice: true, label: "дней" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())53:T603,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(precipDaysType.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(precipDaysType, { x: "yearGroup", y: "count", fill: "precip_type_by_sum_name", offset: "normalize", order: ["cнег", "дождь"], fx: (d) => fx(d.city), fy: (d) => fy(d.city), opacity: 0.6, channels: { count: { value: "count", label: "share" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.axisY({ tickSpacing: 20, nice: true, label: "дней" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())54:T5a9, precip_sum_by_seasons = weatherDT .derive({ yearGroup: aq.escape((obs) => { for (let i = 0; i < yearStarts.length; i++) { if ((obs.year >= yearStarts[i]) && (obs.year < yearStarts[i] + yearsGroupLen)) return yearStarts[i] } }), period: aq.escape((obs) => { if ((obs.year >= 1950) & (obs.year < 1980)) return 'reference' else if (obs.year >= 2014) return 'now' else return 'junk' }) }) .select('city', 'date', 'yearGroup', 'year', 'season', 'new_precip_sum_rain', 'new_precip_sum_snow', 'precip_sum', 'period') .rename({ 'new_precip_sum_snow': 'snow', 'new_precip_sum_rain': 'rain', 'precip_sum': 'precip_sum_total' }) .fold(['rain', 'snow']) .rename({ 'key': 'precip_type', 'value': 'precip_sum' }) .groupby(['city', 'precip_type', 'yearGroup', 'year', 'season', 'period']) .rollup({ precip_sum: d => op.sum(d.precip_sum), precip_sum_total: d => op.sum(d.precip_sum_total), }) .groupby(['city', 'precip_type', 'season', 'period']) .rollup({ avg_precip_sum: d => op.mean(d.precip_sum), avg_precip_sum_total: d => op.mean(d.precip_sum_total), }) .filter( aq.escape((obs) => obs.period != 'junk') ) .select('city', 'season', 'precip_type', 'period', 'avg_precip_sum') .groupby('city', 'season', 'precip_type') .pivot('period', 'avg_precip_sum') // .view() .objects()55:T5e2,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(precip_sum_by_seasons.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 550, width: 1200, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(precip_sum_by_seasons, { x: "yearGroup", y: "avg_precip_sum", fx: "city", fy: "season", opacity: 0.6, channels: { avg_precip_sum: { value: "avg_precip_sum", label: "avg_precip_sum sum" }, yearGroup: "yearGroup", city: "city", season: "season" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.axisY({ tickSpacing: 20, nice: true, label: "мм" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов // Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())56:T585,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(snowyDays.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(snowyDays, { x: "yearGroup", y: "count", fx: (d) => fx(d.city), fy: (d) => fy(d.city), opacity: 0.6, channels: { count: { value: "count", label: "hot days" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.axisY({ tickSpacing: 20, nice: true, label: "дней" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())57:T59b,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(precip_sum.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(precip_sum, { x: "yearGroup", y: "avg_precip_sum", fx: (d) => fx(d.city), fy: (d) => fy(d.city), opacity: 0.6, channels: { count: { value: "avg_precip_sum", label: "avg_precip_sum" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.axisY({ tickSpacing: 20, nice: true, label: "мм" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())58:T59d,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(precip_sum2.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(precip_sum2, { x: "yearGroup", y: "avg_precip_sum", fx: (d) => fx(d.city), fy: (d) => fy(d.city), opacity: 0.6, channels: { count: { value: "avg_precip_sum", label: "avg_precip_sum" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.axisY({ tickSpacing: 20, nice: true, label: "мм" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())59:Tc37,snowyDates = { var citiesFirstLast = {}; var dateStart, dateEnd var snowyObjects = snowDT.objects() var snowyDaysCount = 0 var noSnowDaysCount = 0 var snowyDaysLimit = 30 var noSnowDaysLimit = 3 var curYear = null var curFirstSnow = null var curFirstStableSnow = null var snowIsStable = false var snowyDates = {} for (let i = 0; i < snowyObjects.length; i++) { if (snowyObjects[i]['year'] == 1950) curYear = 1950 // если наступил июнь, подвожу итоги года if (snowyObjects[i]['month'] >= 6) { if (!(snowyObjects[i]['city'] in snowyDates)) snowyDates[snowyObjects[i]['city']] = {} if (!(snowyObjects[i]['year']-1 in snowyDates[snowyObjects[i]['city']])) { if (snowyObjects[i]['year'] != 1950) { snowyDates[snowyObjects[i]['city']][snowyObjects[i]['year']-1] = {} snowyDates[snowyObjects[i]['city']][snowyObjects[i]['year']-1]['firstSnow'] = curFirstSnow snowyDates[snowyObjects[i]['city']][snowyObjects[i]['year']-1]['firstStableSnow'] = curFirstStableSnow curFirstSnow = null curFirstStableSnow = null snowIsStable = false snowyDaysCount = 0 noSnowDaysCount = 0 curYear += 1 } } } // если уже вторая половина года или начался следующий год, могу считать первый снег if ((snowyObjects[i]['month'] >= 6) | (curYear < snowyObjects[i]['year'])) { if ((snowyObjects[i]['is_snow_cm'] == 1)) { if (curFirstSnow === null) { curFirstSnow = snowyObjects[i]['date'] } if (curFirstStableSnow === null) { curFirstStableSnow = snowyObjects[i]['date'] } noSnowDaysCount = 0 snowyDaysCount += 1 if (snowyDaysCount == snowyDaysLimit) { snowIsStable = true } } else { noSnowDaysCount += 1 if ((noSnowDaysCount > noSnowDaysLimit) & (!snowIsStable)) { curFirstStableSnow = null } } } } var snowyDatesRefactored = [] var curEl const oneDay = 24 * 60 * 60 * 1000; // hours*minutes*seconds*milliseconds var firstDate, secondDate, diffDays for (const city in snowyDates) { for (const year in snowyDates[city]) { curEl = {} curEl['city'] = city curEl['year'] = year curEl['firstSnow'] = snowyDates[city][year]['firstSnow'] curEl['firstStableSnow'] = snowyDates[city][year]['firstStableSnow'] firstDate = new Date(curEl['firstSnow']); secondDate = new Date(year, 6, 1); curEl['firstSnowDays'] = Math.round(Math.abs((firstDate - secondDate) / oneDay)); firstDate = new Date(curEl['firstStableSnow']); secondDate = new Date(year, 6, 1); curEl['firstStableSnowDays'] = Math.round(Math.abs((firstDate - secondDate) / oneDay)); snowyDatesRefactored.push(curEl) } } return snowyDatesRefactored }5a:T5a2,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(snowyDatesDecades.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.lineY(snowyDatesDecades, { x: "yearGroup", y: "count", fx: (d) => fx(d.city), fy: (d) => fy(d.city), opacity: 0.6, channels: { count: { value: "count", label: "days from year start" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.axisY({ tickSpacing: 20, nice: true, label: "дней" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())5b:T586,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(snowSize.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(snowSize, { x: "yearGroup", y: "avg_max", fx: (d) => fx(d.city), fy: (d) => fy(d.city), opacity: 0.6, channels: { max_avg: { value: "avg_max", label: "snow size" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.axisY({ tickSpacing: 20, nice: true, label: "мм" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())5c:T586,Plot.plot((() => { const n = 4; // number of facet columns const keys = Array.from(d3.union(snowDays.map((d) => d.city))); const index = new Map(keys.map((key, i) => [key, i])); const fx = (key) => index.get(key) % n; const fy = (key) => Math.floor(index.get(key) / n); return { height: 450, width: 900, axis: null, y: {insetTop: 20}, fx: {padding: 0.02}, marks: [ Plot.barY(snowDays, { x: "yearGroup", y: "count", fx: (d) => fx(d.city), fy: (d) => fy(d.city), opacity: 0.6, channels: { max_avg: { value: "count", label: "snow size" }, yearGroup: "yearGroup" }, tip: { format: { x: false, y: false, fx: false, fy: false, yearGroup: (d) => (`${d}`) } } }), Plot.axisY({ tickSpacing: 20, nice: true, label: "дней" }), Plot.axisX({ tickSize: 0, tickSpacing: 120, label: null, tickFormat: (d) => {if (getUniformlyDistributedElements(yearStarts, 5).includes(d)) return `${d}` else return ""} }), // подписи городов Plot.text(keys, {fx, fy, frameAnchor: "top-left", dx: 6, dy: 6}) ] }; })())5d:Tc61,trashSeasonsData = { // const daysToCheck = 15 // var tempStatusesObjects = temp_statuses.objects() // var threshold = false // var season = "winter" // var tempArr = [] // var seasonStart = 0 // var seasonEnd = 0 // var daysLeft = daysToCheck // for (let i = 0; i < tempStatusesObjects.length; i++) { // if (tempStatusesObjects[i]['t_avg'] < 0) // tempStatusesObjects[i]['season_group'] = '< 0' // else if (tempStatusesObjects[i]['t_avg'] > 25) // tempStatusesObjects[i]['season_group'] = '> 25' // else if (tempStatusesObjects[i]['t_avg'] > 15) // tempStatusesObjects[i]['season_group'] = '> 15' // else // tempStatusesObjects[i]['season_group'] = '0-15' // if (tempStatusesObjects[i]['t_avg'] < 0) // tempStatusesObjects[i]['season_group2'] = '< 0' // else if (tempStatusesObjects[i]['t_avg'] > 15) // tempStatusesObjects[i]['season_group2'] = '> 15' // else // tempStatusesObjects[i]['season_group2'] = '0-15' // // tempStatusesObjects[i]['i'] = i // tempStatusesObjects[i]['cur_season'] = season // if ((i == 0) || new Date(tempStatusesObjects[i]['date']).toISOString().split('T') // == new Date('1960-01-01').toISOString().split('T')[0]) { // tempStatusesObjects[i]['season'] = "winter" // season = "winter" // } // else { // if (threshold == false) { // if (seasonLimits[seasonLimits[season]["next"]]['sign'] == ">" ? // tempStatusesObjects[i]['t_avg'] >= seasonLimits[seasonLimits[season]["next"]]["limit"] : // tempStatusesObjects[i]['t_avg'] < seasonLimits[seasonLimits[season]["next"]]["limit"]) { // threshold = true // tempArr = [tempStatusesObjects[i]['t_avg']] // seasonEnd = i // daysLeft = daysToCheck // } // } else { // tempArr.push(tempStatusesObjects[i]['t_avg']) // if (tempArr.length > 100) // return tempArr // if (seasonLimits[seasonLimits[season]["next"]]['sign'] == ">" ? // mean(tempArr) <= seasonLimits[seasonLimits[season]["next"]]["limit"] : // tempStatusesObjects[i]['t_avg'] > seasonLimits[seasonLimits[season]["next"]]["limit"]) { // threshold = false // } // else { // // return [seasonLimits[season]['sign'], mean(tempArr), seasonLimits[seasonLimits[season]["next"]]["limit"]] // daysLeft-- // if (daysLeft == 0) { // for (let j = seasonStart; j < seasonEnd; j++) { // tempStatusesObjects[j]['season'] = season // } // season = seasonLimits[season]['next'] // seasonStart = seasonEnd // threshold = false // } // } // } // } // } // for (let j = seasonStart; j < seasonEnd; j++) { // tempStatusesObjects[j]['season'] = season // } // return tempStatusesObjects }5e:[{"id":"3cd351dee6ad0300d45288f634ae05f36348afbaab300fc0987b2e0eb5cd5068d7d8c6fd81c489470cbbf207945e608b5f154260c0ca8069b7d3ba5950e360c2","href":"https://static.observableusercontent.com/files/3cd351dee6ad0300d45288f634ae05f36348afbaab300fc0987b2e0eb5cd5068d7d8c6fd81c489470cbbf207945e608b5f154260c0ca8069b7d3ba5950e360c2","name":"snow_refactored@2.csv","type":"text/csv","lastModified":1701834473228.481,"size":20064857},{"id":"a12ecdf3336fdb5da02b922e220bade7f7a39b93dc1b7d78471ca64c860a87e4c057c6093d78c25fcb11e6919f7b9d2fb0d95a49928338c7bab887cc0db9d916","href":"https://static.observableusercontent.com/files/a12ecdf3336fdb5da02b922e220bade7f7a39b93dc1b7d78471ca64c860a87e4c057c6093d78c25fcb11e6919f7b9d2fb0d95a49928338c7bab887cc0db9d916","name":"snow_refactored_new.csv","type":"text/csv","lastModified":1706216472536.275,"size":20966224},{"id":"0e119603713cbb76ce0bceb8b6a8c1bf4d3ea2f92a3f9a2ad66dfa0a12eb6cfdbcab14b8e325a88a0ee26c1cc4a17cb4bbf7778464db7f0f42a3d657e6bfc94d","href":"https://static.observableusercontent.com/files/0e119603713cbb76ce0bceb8b6a8c1bf4d3ea2f92a3f9a2ad66dfa0a12eb6cfdbcab14b8e325a88a0ee26c1cc4a17cb4bbf7778464db7f0f42a3d657e6bfc94d","name":"all_temps_compile_new@6.csv","type":"text/csv","lastModified":1705069758873.767,"size":48383035},{"id":"96dab109a2284a69c2a68a76837b54accec634478c6e39792056dc5550085139395b2ce59db2521a451a454e556dcfe1f52c7f2a8f8c1ca80dfd54ce69043d02","href":"https://static.observableusercontent.com/files/96dab109a2284a69c2a68a76837b54accec634478c6e39792056dc5550085139395b2ce59db2521a451a454e556dcfe1f52c7f2a8f8c1ca80dfd54ce69043d02","name":"all_temps_compile_new@7.csv","type":"text/csv","lastModified":1705076603999.308,"size":43129971}] 29:{"id":"182b4639f9c6e596","slug":null,"title":"Weather Exploring","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2023-10-24T08:32:47.223Z","update_time":"$D2024-02-08T16:39:18.683Z","view_time":null,"first_public_time":"$D2023-10-24T08:32:47.223Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"8ae0112d461293cc","login":"pineappleblack","name":"Alexey Smagin","avatar_url":"https://avatars-next.observableusercontent.com/24873ad67ec8c994cf10ab1ac2cd2fab0f5176b53d80b862adcc8ba3ceb91fda","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":3537,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"c8b4bf673749a7d5","login":"pineappleblack","name":"Alexey Smagin","avatar_url":"https://avatars-next.observableusercontent.com/24873ad67ec8c994cf10ab1ac2cd2fab0f5176b53d80b862adcc8ba3ceb91fda","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"c8b4bf673749a7d5","login":"pineappleblack","name":"Alexey Smagin","avatar_url":"https://avatars-next.observableusercontent.com/24873ad67ec8c994cf10ab1ac2cd2fab0f5176b53d80b862adcc8ba3ceb91fda","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Weather Exploring","cells":[{"id":0,"value":"# Weather Exploring","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":55,"value":"## Basic","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":104,"value":"weatherDT = aq.fromCSV(await FileAttachment(\"all_temps_compile_new@7.csv\").text())\n .filter(\n aq.escape((obs) => obs.date >= new Date(\"1950-01-01\"))\n )\n .derive({\n season: aq.escape((obs) => getSeason(obs.date))\n }) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3462,"value":"weatherDT.view(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"## Extreme hot and extreme cold days","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":237,"value":"refPeriod = ({start: \"1950-01-01\", end: \"1980-01-01\", now: \"2014-01-01\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":187,"value":"refPeriodTemps = weatherDT\n .filter(\n aq.escape((obs) => obs.date >= new Date(refPeriod['start']) & obs.date < new Date(refPeriod['end']))\n )\n .derive({\n day_month: aq.escape((obs) => new Date(obs.date).toLocaleString('default').slice(0, 5))\n }) \n .groupby('city', 'day_month')\n .rollup({\n refPeriodMean: d => op.mean(d.t_avg)\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1719,"value":"yearStarts = [...Array(Math.floor(((2023 - 1950)/yearsGroupLen)) + 1)].map((x,i)=>1950 + i*yearsGroupLen)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":597,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2679,"value":"tempStatuses.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3492,"value":"tempStatuses\n .groupby('period', 'city')\n .rollup({\n t_avg: d => op.mean(d.t_avg),\n })\n .filter(\n aq.escape((obs) => obs.period != 'junk')\n )\n .groupby('city')\n .pivot('period', 't_avg')\n .derive({\n temp_diff: aq.escape((obs) => obs.now - obs.reference)\n })\n .orderby(aq.desc('temp_diff'))\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"hotDays = tempStatuses\n .filter(\n aq.escape((obs) => obs.status == 'hot')\n )\n .groupby('yearGroup', 'year', 'city')\n .count()\n .groupby('yearGroup', 'city')\n .rollup({\n count: d => op.mean(d.count),\n })\n .objects().map((d) => ({\n yearGroup: d.yearGroup,\n days: d.count,\n city: d.city\n }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":668,"value":"coldDays = tempStatuses\n .filter(\n aq.escape((obs) => obs.status == 'cold')\n )\n .groupby('yearGroup', 'year', 'city')\n .count()\n .groupby('yearGroup', 'city')\n .rollup({\n count: d => op.mean(d.count),\n })\n .objects().map((d) => ({\n days: d.count,\n yearGroup: d.yearGroup,\n city: d.city\n }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":866,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":952,"value":"hwEventsCount = aq.from(hwCsEvents)\n .filter(\n aq.escape((obs) => obs.status_days == heatwave_days_limit)\n )\n .groupby('yearGroup', 'city')\n .count().objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":883,"value":"csEventsCount = aq.from(hwCsEvents)\n .filter(\n aq.escape((obs) => obs.status_days == -1*heatwave_days_limit)\n )\n .groupby('yearGroup', 'city')\n .count().objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":547,"value":"

Количество жарких и холодных дней

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":550,"value":"_Жарким днём считается день, средняя температура которого на N градусов выше, чем в тот же день за референсный период. Холодным — когда средняя температура на N градусов ниже_ ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":647,"value":"viewof deviation = Inputs.select([5, 10], {label: \"Отклонение от среднего\", step: 1, value: 5})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":652,"value":"viewof yearsGroupLen = Inputs.range([1, 10], {label: \"Сколько лет группировать\", step: 1, value: 10})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":455,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2457,"value":"aq.from(coldDays)\n .derive({\n coldDays: d => d.days\n })\n .select(aq.not('days'))\n .join(aq.from(hotDays))\n .derive({\n hotDays: d => d.days\n })\n .select(aq.not('days'))\n .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2740,"value":"

Количество экстремальных дней при разном разбросе

Количество волн жары и волн холода

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":928,"value":"viewof heatwave_days_limit = Inputs.range([0, 30], {label: \"Миним. длина волны (дней)\", step: 1, value: 5})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1968,"value":"Inputs.bind(Inputs.range([1, 30], {label: \"Отклонение от среднего\", step: 1, value: 5}), viewof deviation)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1963,"value":"Inputs.bind(Inputs.range([1, 10], {label: \"Сколько лет группировать\", step: 1, value: 5}), viewof yearsGroupLen)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1953,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":991,"value":"cities = aq.from(hwCsEvents)\n .groupby('city')\n .count()\n .select('city')\n .objects()\n .map(ob => ob.city)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":763,"value":"selected_temp_statuses = {\n var data = aq.from(hwCsEvents)\n if (cityInput == \"Все\")\n return data\n else\n return data.filter(\n aq.escape((obs) => obs.city == cityInput)\n )\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":987,"value":"viewof cityInput = Inputs.select([\"Все\"].concat(cities), {label: \"Город\", value: \"Москва\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":733,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1189,"value":"tempPlus = tempStatuses\n .filter(\n aq.escape((obs) => obs.t_avg > 0)\n )\n .groupby('year', 'city')\n .count().objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1175,"value":"tempMinus = tempStatuses\n .filter(\n aq.escape((obs) => obs.t_avg < 0)\n )\n .groupby('year', 'city')\n .count().objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1219,"value":"seasonLimits = ({\n \"winter\": {\n \"limit\": 0,\n \"sign\": \"<\",\n \"next\": \"spring\"\n },\n \"spring\": {\n \"limit\": 0,\n \"sign\": \">\",\n \"next\": \"summer\"\n },\n \"summer\": {\n \"limit\": 15,\n \"sign\": \">\",\n \"next\": \"autumn\"\n },\n \"autumn\": {\n \"limit\": 15,\n \"sign\": \"<\",\n \"next\": \"winter\"\n }\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1245,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2232,"value":"dateRange = ({\n start: '1-1',\n end: '12-1'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1432,"value":"selectedSeasonsData = {\n var data = aq.from(seasonsData)\n if (cityInputSeasons == \"Все\")\n return data\n else\n return data.filter(\n aq.escape((obs) => obs.city == cityInputSeasons)\n )\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1608,"value":"seasonRadioNames = [\n {name: \"Средние температуры\", value: \"temp\"},\n {name: \"Мин. температуры\", value: \"minTemp\"},\n {name: \"Макс. температуры\", value: \"maxTemp\"},\n {name: \"Значения средних\", value: \"val\"},\n {name: \"Значения мин\", value: \"val_min\"},\n {name: \"Значения макс\", value: \"val_max\"},\n {name: \"Сезоны\", value: \"seasons\"},\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2374,"value":"pallete = { \n if (!seasonRadio.value.includes(\"val\"))\n return {\n legend: true, \n range: [\"#22575C\", \"#fcf2ec\", \"#F0CA4D\", \"#DE5B49\"],\n domain: [\"< 0\", \"0-15\", \"> 15\", \"> 25\"]\n }\n else \n return {\n legend: true, \n type: \"linear\",\n domain: [-15, 0, 15, 25],\n range: [\"#22575C\", \"#fcf2ec\", \"#F0CA4D\", \"#DE5B49\"]\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1605,"value":"viewof seasonRadio = Inputs.radio(seasonRadioNames, {label: \"Показывать\", format: x => x.name, value: seasonRadioNames[0]})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1586,"value":"viewof cityInputSeasons = Inputs.select([\"Все\"].concat(cities), {label: \"Город\", value: \"Москва\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2267,"value":"viewof dateRangeStart = Inputs.text({'label': 'Начало фокуса', 'value': '1-1'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2272,"value":"viewof dateRangeEnd = Inputs.text({'label': 'Конец фокуса', 'value': '12-1'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1509,"value":"$4f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3473,"value":"aq.from(seasonsData).view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2213,"value":"fillValue = {\n if (seasonRadio2.value == \"seasons\")\n return \"season2\"\n else if (seasonRadio2.value == \"temp\")\n return \"avgTempGroup2\"\n else if (seasonRadio2.value == \"minTemp\")\n return \"minTempGroup\"\n else if (seasonRadio2.value == \"maxTemp\")\n return \"maxTempGroup\"\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1683,"value":"seasonPercents = aq.from(seasonsData)\n .groupby('yearGroup', 'city', 'calendarSeason', fillValue)\n .count()\n .filter(\n aq.escape((obs) => obs.city == cityInputPercents)\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2429,"value":"aq.from(seasonsData)\n .groupby('yearGroup', 'city', 'calendarSeason', 'avgTempGroup2')\n .count()\n .groupby('yearGroup', 'city', 'calendarSeason')\n .pivot('avgTempGroup2', 'count')\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2396,"value":"seasonRadioNames2 = [\n {name: \"Средние температуры\", value: \"temp\"},\n {name: \"Мин. температуры\", value: \"minTemp\"},\n {name: \"Макс. температуры\", value: \"maxTemp\"}\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2144,"value":"viewof cityInputPercents = Inputs.select(cities, {label: \"Город\", value: \"Москва\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2138,"value":"Inputs.bind(Inputs.select([5, 10], {label: \"Сколько лет группировать\", step: 1, value: 5}), viewof yearsGroupLen)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2401,"value":"viewof seasonRadio2 = Inputs.radio(seasonRadioNames2, {label: \"Показывать\", format: x => x.name, value: seasonRadioNames2[0]})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2318,"value":"viewof seasonsSplit = Inputs.radio([\"Да\", \"Нет\"], {label: \"Разбить по сезонам\", value: \"нет\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1847,"value":"$50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2299,"value":"seasonPercentsMonth = aq.from(seasonsData)\n .groupby('yearGroup', 'city', 'calendarSeason', fillValue)\n .count()\n .filter(\n aq.escape((obs) => obs.city == cityInputPercents)\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2301,"value":"seasonPercentsMonth.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3471,"value":"seasonPercentsMonth.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2512,"value":"## Precipitation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":3045,"value":"weatherDT.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2516,"value":"refPeriodPrecip = weatherDT\n .filter(\n aq.escape((obs) => obs.date >= new Date(refPeriod['start']) & obs.date < new Date(refPeriod['end']))\n )\n .groupby('city')\n .rollup({\n refPeriodPrecip: d => op.quantile(d.precip_sum, 0.95),\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3037,"value":"refPeriodPrecip.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2578,"value":"extremePrecipDays = weatherDT\n .derive({\n year: aq.escape((obs) => new Date(obs.date).getFullYear()),\n })\n .derive({\n yearGroup: aq.escape((obs) => {\n for (let i = 0; i < yearStarts.length; i++) {\n if ((obs.year >= yearStarts[i]) && (obs.year < yearStarts[i] + yearsGroupLen)) \n return yearStarts[i]\n }\n })\n })\n .join(refPeriodPrecip)\n .filter(\n aq.escape((obs) => obs.precip_sum > obs.refPeriodPrecip)\n )\n .groupby('year', 'city', 'yearGroup')\n .count()\n .groupby('yearGroup', 'city')\n .rollup({\n count: d => op.mean(d.count),\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2574,"value":"aq.from(extremePrecipDays)\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2598,"value":"

Количество дней с экстремальными осадками

Количество осадочных дней

Распределение числа дней по типу осадков

Сумма снега и сумма дождя по сезонам

Количество снежных дней

Средняя годовая сумма осадков за десятилетие

Средняя годовая сумма осадков за десятилетие в дождливые дни

Среднее число дней с начала года, когда выпал устойчивый снег

Средняя высота сугробов за десятилетие

Число дней со снегом