2f:Td15,// define choices for the data value viewof selectGeoDataType = { const options = [ { key: "ag_workforce_data_2", // lookup id for data option dataColumn: "corrected_ag_pop", // data column label: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_2.label), // label labelTip: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_2.labelTip), // label for tooltip labelLegend: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_2.labelLegend), // label for legend formatFunc: formatNumCompactShort({locale: language.locale}), // formatting function for raw data value colorRange: colorScales.range.yellowGreen, // color range colorUnknown: colorScales.unknown, // unknown fill color }, { key: "ag_workforce_data_1", dataColumn: "agw_total_mid", label: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_1.label), labelTip: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_1.labelTip), labelLegend: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_1.labelLegend), formatFunc: d => `${formatNumCompactShort({locale: language.locale})(d)}%`, colorRange: colorScales.range.redYellowGreen, colorUnknown: colorScales.unknown, }, { key: "ag_workforce_data", dataColumn: "agw_total", label: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data.label), labelTip: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data.labelTip), labelLegend: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data.labelLegend), formatFunc: d => `${formatNumCompactShort({locale: language.locale})(d)}%`, colorRange: colorScales.range.redYellowGreen, colorUnknown: colorScales.unknown, }, { key: "ag_workforce_data_15", dataColumn: "agw_total_mid_abs", label: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_15.label), labelTip: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_15.labelTip), labelLegend: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_15.labelLegend), formatFunc: formatNumCompactShort({locale: language.locale}), colorRange: colorScales.range.yellowGreen, colorUnknown: colorScales.unknown, }, { key: "ag_workforce_data_10", dataColumn: "agw_total_abs", label: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_10.label), labelTip: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_10.labelTip), labelLegend: _lang(nbText.sections.futureWorkforce.map.mapLayer.values.ag_workforce_data_10.labelLegend), formatFunc: formatNumCompactShort({locale: language.locale}), colorRange: colorScales.range.yellowGreen, colorUnknown: colorScales.unknown, }, ]; return Inputs.radio(options.sort((a,b) => b.key.localeCompare(a.key)), { width: 300, label: _lang(nbText.sections.futureWorkforce.map.mapLayer.title), format: (x) => x.label, value: options.find((t) => t.key === "ag_workforce_data_2") }); }30:Tdd5,plotChoroplethGeoImpact = { const data = mapDataGeoImpact; const selector = selectGeoDataType; const allValues = data.features.flatMap((d) => d.properties.data && d.properties.data[selector.dataColumn] !== undefined ? [Math.abs(d.properties.data[selector.dataColumn])] : [] ); const caption = Lang.reduceReplaceTemplateItems( _lang(nbText.sections.futureWorkforce.map.caption), [{ name: "selector", value: selector.label }] ); // return plot return Plot.plot({ width: mapWidth, height: 600, caption, projection: { type: "azimuthal-equal-area", domain: data }, color: { legend: true, label: selector.labelLegend, range: selector.colorRange, unknown: selector.colorUnknown, tickFormat: (d) => { // Check if dataColumn is one of the specified types if ( selector.dataColumn === "corrected_ag_pop" || selector.dataColumn === "agw_total_mid_abs" || selector.dataColumn === "agw_total_abs" ) { // Use the provided formatFunc and append a "%" symbol for these types return selector.formatFunc(d); } else { // For other types, just use the formatFunc without appending a "%" symbol return `${selector.formatFunc(d)}`; } }, domain: selector.dataColumn === "corrected_ag_pop" || selector.dataColumn === "agw_total_mid_abs" || selector.dataColumn === "agw_total_abs" ? [0, Math.max(...allValues)] : [-Math.max(...allValues), Math.max(...allValues)] }, marks: [ // geo data Plot.geo(data.features, { fill: (d) => { const dataColumn = selector.dataColumn; const fillValue = d.properties.data ? d.properties.data[dataColumn] : null; // handle missing data return fillValue; }, stroke: "#fff", strokeWidth: 0.5 }), // admin2 highlight // if Admin selection includes admin2, highlight section Plot.geo( adminSelections.selectAdmin2.value ? data.features.filter( (d) => d.properties.admin2_name == adminSelections.selectAdmin2.value ) : [], { fill: null, stroke: "#333", strokeWidth: 1.5 } ), // geo pointer Plot.geo( data, Plot.pointer( Plot.centroid({ stroke: "#333", strokeWidth: 1.5 }) ) ), // tooltip Plot.tip( data.features, Plot.pointer( Plot.centroid({ channels: { name: { // region label, based on selection label: Lang.toTitleCase(getLowerLevelAdminLabel()), // plot-level so inputs don't reload value: (d) => _lang(td.admin0_name.values?.[d.properties.admin_name]) ?? d.properties.admin_name }, data: { label: selector.labelTip, value: (d) => { const dataColumn = selector.dataColumn; const data = d.properties.data ? d.properties.data[dataColumn] : undefined; return data; } } }, format: { name: true, data: (d) => `${selector.formatFunc(d)}` } }) ) ) ] }); }31:Td85,// text insights for geo impact textDynamicInsights_geoImpact = { const adminSelection = getAdmin0WithAdminSubParens({articleField: "article2"}); const i = dynamicInsights_geoImpact.insight; const currentAgPop = i.totalAgPop_noformat; // totalVop is the projected change in agricultural population by 2050 const projectedChange2050 = i.totalAgPop_2_50_noformat; const projectedChange2030 = i.totalAgPop_2_30_noformat; // string for percent change const percChangeType = (d) => d >= 0 ? _lang(nbText.sections.futureWorkforce.quickInsights.direction.inc) : _lang(nbText.sections.futureWorkforce.quickInsights.direction.dec); // Calculate the new total agricultural population for 2050 const newTotalAgPop2050 = currentAgPop + projectedChange2050; // Calculate the percentage change let percentChange50 = ((projectedChange2050 - currentAgPop) / currentAgPop) * 100; let changeType50 = percChangeType(percentChange50); percentChange50 = Math.abs(percentChange50).toFixed(1); // Keeping two decimals for readability let percentChange30 = ((projectedChange2030 - currentAgPop) / currentAgPop) * 100; let changeType30 = percChangeType(percentChange30); percentChange30 = Math.abs(percentChange30).toFixed(1); // Keeping two decimals for readability let percentChange_5 = ((i.totalAgPop_5_50_noformat - currentAgPop) / currentAgPop) * 100; let changeType_5 = percChangeType(percentChange_5); percentChange_5 = Math.abs(percentChange_5).toFixed(1); // Keeping two decimals for readability let percentChange30_5 = ((i.totalAgPop_5_30_noformat - currentAgPop) / currentAgPop) * 100; let changeType30_5 = percChangeType(percentChange30_5); percentChange30_5 = Math.abs(percentChange30_5).toFixed(1); // Keeping two decimals for readability const selectedCountry = getAdminSelection0().value; // Function to get the selected country const countriesWithoutData = [ "Burundi", "Rwanda", "Lesotho", "Gabon", "Eswatini", "Equatorial Guinea" ]; const insightBase = Lang.reduceReplaceTemplateItems( _lang(nbText.sections.futureWorkforce.quickInsights.basePop), [ { name: "geo", value: adminSelection }, { name: "total", value: i.totalAgPop } ] ); const insightPopChange = Lang.reduceReplaceTemplateItems( _lang(nbText.sections.futureWorkforce.quickInsights.popChange), [ { name: "change2030", value: i.totalAgPop_2_30 }, { name: "change2050", value: i.totalAgPop_2_50 }, { name: "direction2030", value: changeType30 }, { name: "direction2050", value: changeType50 }, { name: "perc2030", value: percentChange30 }, { name: "perc2050", value: percentChange50 } ] ); const insightPopScenario = Lang.reduceReplaceTemplateItems( _lang(nbText.sections.futureWorkforce.quickInsights.popScenario), [ { name: "pop2030", value: i.totalAgPop_5_30 }, { name: "pop2050", value: i.totalAgPop_5_50 }, { name: "direction", value: changeType30_5 }, { name: "perc2030", value: percentChange30_5 }, { name: "perc2050", value: percentChange_5 } ] ) // Check if the selected country is in the list of countries without data if (countriesWithoutData.includes(selectedCountry)) { return md`${_lang(nbText.sections.quickInsightsGeneral.noDataBlurb)}`; } else { return md`${styling}${insightBase} ${insightPopChange} ${insightPopScenario}`; } }32:T13c0,{ const _anyData = T.tidy( data_hazardVoP, T.groupBy( [ "admin0_name", "admin1_name", "admin2_name", "scenario", "timeframe", "threshold", "crop" ], [ T.summarize({ vop_any: T.sum("vop") }) ] ) ); const _dataWithAnyColumn = T.tidy( data_hazardVoP, T.leftJoin(_anyData, { by: [ "admin0_name", "admin1_name", "admin2_name", "scenario", "timeframe", "crop", "threshold" ] }) ); const data = _dataWithAnyColumn; const dataAny = data.filter((d) => d.hazard == "any"); // combined const dataBars = [ ...data.filter((d) => d.hazard !== "any" && d.vop !== 0) // remove the combined hazard ]; const _formatNumber = formatNumCompactShort({locale: language.locale}); const xDomain = cropNames .filter(d => { const availableCrops = _.uniq(dataBars.map(d => d.crop)); return availableCrops.includes(d.crop); }) .map(d => { const upperBound = parseInt(d.cropName, 10); // Assuming cropName is the upper bound const lowerBound = Math.max(0, upperBound - 5); return `${lowerBound}-${upperBound}%`; }); const maxValue = d3.max(dataBars, (d) => d.vop) * 1.5; // adding 10% buffer return Plot.plot({ // caption: `To ensure that the details across all bins are visible without being dominated by the initial range, the 0-5% bin has been intentionally excluded from this visualization.`, caption: _lang(nbText.sections.heatStress.barChart.caption), width, height: 600, marginLeft: 40, marginRight: 40, marginBottom: 40, color: { domain: hazardPlotLookup.color.domain, range: hazardPlotLookup.color.range, legend: true }, x: { domain: xDomain, label: _lang(nbText.sections.heatStress.barChart.xLabel), labelStyle: { fontSize: '36px' }, // Hypothetical API }, y: { nice: true, grid: true, label: _lang(nbText.sections.heatStress.barChart.yLabel), tickFormat: d => _formatNumber(d), }, marks: [ // main x-axis Plot.axisX({ tickSize: 0, // lineWidth: 3, }), // pointer white-out Plot.axisX( Plot.pointerX({ label: null, fill: "white", textStroke: "white", textStrokeWidth: 1, tickSize: 0 }) ), // bold pointer Plot.axisX( Plot.pointerX({ fontWeight: "bold", label: null, tickSize: 0 }) ), // hazard component bars Plot.barY( dataBars, Plot.stackY( { order: hazardPlotLookup.color.domain }, { y: (d) => d.vop, x: d => { const upperBound = parseInt(hazardPlotLookup.crops[d.crop], 10); // Assuming this gives the upper bound as before const lowerBound = Math.max(0, upperBound - 5); return `${lowerBound}-${upperBound}%`; }, fill: (d) => hazardPlotLookup.names[d.hazard], stroke: "#fff", strokeWidth: 0.25 } ) ), // tooltip Plot.tip( dataBars, Plot.pointerX( Plot.stackY( { order: hazardPlotLookup.color.domain }, { y: (d) => d.vop, x: d => { const upperBound = parseInt(hazardPlotLookup.crops[d.crop], 10); // Assuming this gives the upper bound as before const lowerBound = Math.max(0, upperBound - 5); return `${lowerBound}-${upperBound}%`; }, fill: (d) => hazardPlotLookup.names[d.hazard], channels: { hazard: { label: _lang(nbText.sections.heatStress.barChart.tooltip.period), value: (d) => hazardPlotLookup.names[d.hazard] }, vop: { label: _lang(nbText.sections.heatStress.barChart.tooltip.exposed), value: (d) => { const vop = d.vop; return `(${vop})`; }, value: (d) => _formatNumber(d.vop) } }, format: { x: false, y: false, fill: false, vop: true, hazard: true, perc: true } } ) ) ), // total VoP, sidebar highlight Plot.textY( dataAny, Plot.pointer({ y: maxValue, x: d => { const upperBound = parseInt(hazardPlotLookup.crops[d.crop], 10); // Assuming this gives the upper bound as before const lowerBound = Math.max(0, upperBound - 5); return `${lowerBound}-${upperBound}%`; }, text: (d) => { const value = d.vop_total; return `${value}`; }, textAnchor: "start", dx: 6 }) ) ] }); }33:T1b02,{ const crop = insight_totalExposedVop.filter( (d) => d.totalExposedVop !== 0 && d.cropType == "crop" )?.[0]?.["totalExposedVop"]; const totalExposedVopBaseline = insight_totalExposedVop.find( (d) => d.cropType === "crop" && d.hazard === "baseline" )?.totalExposedVop || "no data"; const totalExposedVopProjection = insight_totalExposedVop.find( (d) => d.cropType === "crop" && d.hazard === "projection" )?.totalExposedVop || "no data"; const totalExposedVopOver30 = insight_totalExposedVop.find((d) => d.hazard === "projection") ?.totalExposedVopOver30 || 0; const totalExposedVopOver50 = insight_totalExposedVop.find((d) => d.hazard === "projection") ?.totalExposedVopOver50 || 0; const totalExposedVopOver30_b = insight_totalExposedVop.find((d) => d.hazard === "baseline") ?.totalExposedVopOver30 || 0; const totalExposedVopOver50_b = insight_totalExposedVop.find((d) => d.hazard === "baseline") ?.totalExposedVopOver50 || 0; const formatVop = (vop) => vop === "no data" ? vop : formatNumCompactShort({ locale: language.locale })(vop); function findTopCropByHazard(hazardType) { const filteredCrops = T.tidy( data_selectedHazardCropType, T.select(["cropType", "crop", "vop", "hazard"]), T.filter((d) => d.cropType == "crop" && d.hazard == hazardType), T.sliceMax(1, "vop") ); return filteredCrops[0]; // Assuming there's at least one entry after filtering } // Calculate topCrop_b and topCrop_p using the adjusted function const topCrop_b = findTopCropByHazard("baseline"); const topCrop_p = findTopCropByHazard("projection"); const lowerBound_b = hazardPlotLookup.crops[topCrop_b?.["crop"]] - 5; const upperBound_b = hazardPlotLookup.crops[topCrop_b?.["crop"]]; const lowerBound_p = hazardPlotLookup.crops[topCrop_p?.["crop"]] - 5; const upperBound_p = hazardPlotLookup.crops[topCrop_p?.["crop"]]; const missingValue = "--- no data for that bin ---"; function showResult(value, format) { if (value === null || value === undefined) return missingValue; return format(value); } function findMedianCropWithVop(data) { const sortedData = [...data] .filter((d) => !isNaN(d.vop)) .sort((a, b) => a.vop - b.vop); const medianIndex = Math.floor(sortedData.length / 2); if (sortedData.length === 0) return { crop: undefined, vop: undefined }; return sortedData.length % 2 !== 0 ? sortedData[medianIndex] : sortedData[medianIndex]; } const baselineData = data_selectedHazardCropType.filter( (d) => d.hazard === "baseline" && d.cropType == "crop" ); const projectionData = data_selectedHazardCropType.filter( (d) => d.hazard === "projection" ); const medianCropInfoBaseline = findMedianCropWithVop(baselineData); const medianCropInfoProjection = findMedianCropWithVop(projectionData); const getBinBounds = (cropValue) => { // Assuming cropValue directly relates to the bin, adjust as necessary for your logic const lowerBound = cropValue - (cropValue % 5); // Adjust based on how bins are defined const upperBound = lowerBound + 5; return { lowerBound, upperBound }; }; const medianCropBaselineBounds = getBinBounds(medianCropInfoBaseline.crop); const medianCropProjectionBounds = getBinBounds( medianCropInfoProjection.crop ); // Example function to convert percentages to months function percentToMonths(percent) { return (percent * 12) / 100; } // Calculate months for baseline and projection median bins const baselineMonthsLower = percentToMonths( medianCropBaselineBounds.lowerBound ); const baselineMonthsUpper = percentToMonths( medianCropBaselineBounds.upperBound ); const projectionMonthsLower = percentToMonths( medianCropProjectionBounds.lowerBound ); const projectionMonthsUpper = percentToMonths( medianCropProjectionBounds.upperBound ); let percentChange = ((totalExposedVopOver50 - totalExposedVopOver50_b) / totalExposedVopOver50_b) * 100; percentChange = Math.abs(percentChange).toFixed(1); let changeType = percentChange >= 0 ? "an increase" : "a decrease"; let percentChange2 = ((totalExposedVopOver30 - totalExposedVopOver30_b) / totalExposedVopOver30_b) * 100; percentChange2 = Math.abs(percentChange2).toFixed(1); let changeType2 = percentChange >= 0 ? "an increase" : "a decrease"; const scenarioLabel = selectScenarioAndTimeframe.scenario === "SSP2" ? "SSP2 4.5" : "SSP5 8.5"; // const over30Insight = `For the baseline period, **${formatVop( // totalExposedVopOver50_b // )}** people experienced unsafe working conditions for at least **half of the days** in the year. Under the scenario **${scenarioLabel}** and year **${ // selectScenarioAndTimeframe.timeframe // }**, it's expected to rise to **${formatVop( // totalExposedVopOver50 // )}** people.`; const insightOver30 = Lang.reduceReplaceTemplateItems( _lang(nbText.sections.heatStress.quickInsights.overview), [ { name: "baseRisk", value: formatVop(totalExposedVopOver30_b) }, { name: "scenario", value: scenarioLabel }, { name: "year", value: selectScenarioAndTimeframe.timeframe }, { name: "projectionRisk", value: formatVop(totalExposedVopOver30) } ] ); const insightOver50 = Lang.reduceReplaceTemplateItems( _lang(nbText.sections.heatStress.quickInsights.half), [ { name: "baseline", value: formatVop(totalExposedVopOver50_b) }, { name: "scenario", value: scenarioLabel }, { name: "year", value: selectScenarioAndTimeframe.timeframe }, { name: "projection", value: formatVop(totalExposedVopOver50) } ] ); // const over50Insight = `For over **100 days** in a year, the people at risk for the baseline were **${formatVop( // totalExposedVopOver30_b // )}**; under the scenario **${scenarioLabel}** and year **${ // selectScenarioAndTimeframe.timeframe // }**, it ascends to **${formatVop(totalExposedVopOver30)}**.`; const medianExplanation = `When we say we're 'looking at the median', we mean focusing on the group in the exact middle when arranging everyone from the least to the most exposed to heat stress over the year. It's like finding the middle point in a line of people sorted by how long they're exposed to high heat.`; const selectedCountry = getAdminSelection0().value; // Function to get the selected country const countriesWithoutData = [ "Burundi", "Rwanda", "Lesotho", "Gabon", "Eswatini", "Equatorial Guinea" ]; // Check if the selected country is in the list of countries without data if (countriesWithoutData.includes(selectedCountry)) { return md`${_lang(nbText.sections.quickInsightsGeneral.noDataBlurb)}`; } else { return md`${insightOver30} ${insightOver50}`; } }34:T10d7,plotHourSeasonLoss = { const _anyData = T.tidy( data_hourlyStress, T.groupBy( [ "admin0_name", "admin1_name", "admin2_name", "scenario", "timeframe", "threshold", "hour_day" ], [ T.summarize({ vop_any: T.mean("delta") }) ] ) ); const _dataWithAnyColumn = T.tidy( data_hourlyStress, T.leftJoin(_anyData, { by: [ "admin0_name", "admin1_name", "admin2_name", "scenario", "timeframe", "hour_day", "threshold" ] }) ); const data = _dataWithAnyColumn.filter(d => d.hazard == radios.value); const dataAny = data.filter((d) => d.hazard == "any"); // combined const dataBars = [ ...data.filter((d) => d.hazard !== "any" && d.delta !== 0) // remove the combined hazard ]; const _formatPercent = (num) => { return `${num.toFixed(1)}%`; }; const xDomain = hourlyNames.map(d => d.hourlyName); const maxValue = d3.max(dataBars, (d) => d.delta) * 1.75; // adding 10% buffer return Plot.plot({ // caption: `The data on the plot above is stacked for visualization purposes, but percentages are based on different parts of the year, depending on the season.`, width: 800, height: 500, marginLeft: 40, marginRight: 5, marginBottom: 35, color: { domain: hourlyPlotLookup.color.domain, range: hourlyPlotLookup.color.range, legend: false }, x: { domain: xDomain, label: _lang(nbText.sections.workingHours.barChart.xLabel) }, y: { domain: [0, maxValue], grid: true, label: _lang(nbText.sections.workingHours.barChart.yLabel), // tickSize: 0, // Set tick size to 0 to hide the ticks // tickFormat: () => "", // Return an empty string to hide tick labels }, marks: [ // main y-axis Plot.axisX({ tickSize: 0, }), // pointer white-out Plot.axisX( Plot.pointerX({ label: null, fill: "white", textStroke: "white", textStrokeWidth: 2, tickSize: 0 }) ), // bold pointer Plot.axisX( Plot.pointerX({ label: null, fontWeight: "bold", tickSize: 0 }) ), // hazard component bars Plot.barY( dataBars, Plot.stackY( { order: hourlyPlotLookup.color.domain }, { y: (d) => d.delta, x: (d) => hourlyPlotLookup.hours[d.hour_day], fill: (d) => hourlyPlotLookup.names[d.hazard], stroke: "#fff", strokeWidth: 0.1, width: 1 // Adjust this value to control the thickness of the bars } ) ), // tooltip Plot.tip( dataBars, Plot.pointerX( Plot.stackY( { order: hourlyPlotLookup.color.domain }, { y: (d) => d.delta, x: (d) => hourlyPlotLookup.hours[d.hour_day], fill: (d) => hourlyPlotLookup.names[d.hazard], channels: { hazard: { label: _lang(nbText.sections.workingHours.barChart.tooltip.period), value: (d) => hourlyPlotLookup.names[d.hazard] }, delta: { label: _lang(nbText.sections.workingHours.barChart.tooltip.perc), value: (d) => { const delta_num = d.delta; return `(${delta_num})`; }, value: (d) => _formatPercent(d.delta) } }, format: { x: false, y: false, fill: false, delta: true, hazard: true, perc: true } } ) ) ), // total VoP, sidebar highlight Plot.textY( dataAny, Plot.pointerX({ y: maxValue, x: (d) => hourlyPlotLookup.hours[d.hour_day], text: (d) => { const value = d.delta_total; return `${value}`; }, textAnchor: "start", dx: 5 }) ) ] }); }35:T13d6,insightsHourSeasonLoss = { const i = dynamicInsights_geoImpact.insight; const currentAgPop = i.totalAgPop_noformat; // totalVop is the projected change in agricultural population by 2050 const projectedChange2050 = i.totalAgPop_5_50_noformat; const projectedChange2030 = i.totalVopMid_noformat; const pop_2050 = currentAgPop + projectedChange2050; const crop = insight_totalExposedHourly.filter( (d) => d.totalExposedHourly !== 0 && d.hour_dayType == "hour_day" )?.[0]?.["totalExposedHourly"]; const pop_sum2 = insight_totalExposedHourly.filter( (d) => d.corrected_pop_sum !== 0 && d.hour_dayType == "hour_day" )?.[0]?.["corrected_pop_sum"]; const totalPercentHarvesting = insight_totalExposedHourly.find( (d) => d.hour_dayType === "hour_day" && d.hazard === "harvesting" )?.totalExposedHourly || "no data"; const totalPercentPlanting = insight_totalExposedHourly.find( (d) => d.hour_dayType === "hour_day" && d.hazard === "planting" )?.totalExposedHourly || "no data"; const formatVop = (vop) => vop === "no data" ? vop : formatNumCompactShort({ locale: language.locale })(vop); const topHour_day = insight_topHourly.filter( (d) => d.delta !== 0 && d.hour_dayType == "hour_day" )?.[0]; const missingValue = "--- no data for that bin ---"; function showResult(value, format) { if (value === null || value === undefined) return missingValue; return format(value); } // Find a row for each hazard type to get period and total_days const harvestingInsight = insight_totalExposedHourly.find( (d) => d.hazard === "harvesting" ); const plantingInsight = insight_totalExposedHourly.find( (d) => d.hazard === "planting" ); const periodHarvesting = insight_totalExposedHourly.find( (d) => d.hour_dayType === "hour_day" && d.hazard === "harvesting" )?.period || "no data"; const totalDaysHarvesting = harvestingInsight ? harvestingInsight.days_period : "no data"; const periodPlanting = plantingInsight ? plantingInsight.period : "no data"; const totalDaysPlanting = plantingInsight ? plantingInsight.days_period : "no data"; const pop_sum = harvestingInsight ? harvestingInsight.corrected_pop_sum : "no data"; const delta_mean = harvestingInsight ? harvestingInsight.delta_pop_mean : "no data"; const totalPercentHarvestingNumeric = totalPercentHarvesting !== "no data" ? parseFloat(totalPercentHarvesting) : 0; const totalDaysHarvestingNumeric = totalDaysHarvesting !== "no data" ? parseFloat(totalDaysHarvesting) : 0; const totalPercentPlantingNumeric = totalPercentPlanting !== "no data" ? parseFloat(totalPercentPlanting) : 0; const totalDaysPlantingNumeric = totalDaysPlanting !== "no data" ? parseFloat(totalDaysPlanting) : 0; const pop_sumNumeric = pop_2050 !== "no data" ? parseFloat(pop_2050) : 0; const totalHoursLostHarvest = (totalPercentHarvestingNumeric / 100) * totalDaysHarvestingNumeric * pop_sumNumeric; const totalHoursLostPlanting = (totalPercentPlantingNumeric / 100) * totalDaysPlantingNumeric * pop_sumNumeric; const totalWorkingDaysLostHarvest = totalHoursLostHarvest / 8; // assuming 8h working day const totalWorkingDaysLostPlanting = totalHoursLostPlanting / 8; // assuming 8h working day const totalWorkingDaysLostHarvestFormatted = formatVop( totalWorkingDaysLostHarvest.toFixed(1) ); // formatting const totalWorkingDaysLostPlantingFormatted = formatVop( totalWorkingDaysLostPlanting.toFixed(1) ); // formatting const insightIntro = _lang(nbText.sections.workingHours.quickInsights.intro); const insightBody = Lang.reduceReplaceTemplateItems( _lang(nbText.sections.workingHours.quickInsights.body), [ { name: "scenario", value: selectScenarioAndTimeframe2.scenario }, { name: "year", value: selectScenarioAndTimeframe2.timeframe }, { name: "totalHours", value: formatVop(totalHoursLostHarvest) }, { name: "daysHarvest", value: formatVop(totalDaysHarvesting) }, { name: "wholeWorkingDays", value: totalWorkingDaysLostHarvestFormatted } ] ); const insightLostDays = Lang.reduceReplaceTemplateItems( _lang(nbText.sections.workingHours.quickInsights.lostDays), [ { name: "period", value: formatVop(totalDaysPlanting) }, { name: "geo", value: getAdmin0WithAdminSubParens({articleField: "article1"}) }, { name: "lostDays", value: totalWorkingDaysLostPlantingFormatted } ] ); const selectedCountry = getAdminSelection0().value; // Function to get the selected country const countriesWithoutData = [ "Burundi", "Rwanda", "Lesotho", "Gabon", "Eswatini", "Equatorial Guinea" ]; // Check if the selected country is in the list of countries without data if (countriesWithoutData.includes(selectedCountry)) { return md`${_lang(nbText.sections.quickInsightsGeneral.noDataBlurb)}`; } else { return md` ${insightIntro} ${insightBody} ${insightLostDays} `; } }36:T7ba7,nbText = { return { legends: { language: { en: "language", fr: "langue" }, toc: { en: "in this notebook", fr: "dans ce notebook" }, adminSelections: { country: { en: "country", fr: "pays" }, region: { en: "region", fr: "région" }, subregion: { en: "subregion", fr: "sous-région" } }, scenario: { en: "scenario", fr: "scénario" }, threshold: { en: "threshold", fr: "seuil" }, season: { en: "season", fr: "saison" }, seasonTypes: { planting: { en: "planting", fr: "plantation" }, harvesting: { en: "harvesting", fr: "récolte" } } }, sections: { quickInsightsGeneral: { header: { en: "Quick Insights for :::selection:::", fr: "Aperçu Rapide pour :::selection:::" }, noDataBlurb: { en: "Currently, there is no available data for this country. Please, select another country.", fr: "Actuellement, aucune donnée n’est disponible pour ce pays. Veuillez sélectionner un autre pays." } }, overview: { title: { en: "Overview", fr: "Vue d’Ensemble" }, intro: { en: "African food systems depend on manual labour for production, distribution, and processing. Economic development is leading to changes in the structure and size of the labour force. This change, in the number and size of the agricultural workforce, is happening in parallel to climate change. The intersection of these two drivers together pose a range of risks to the African continent's food systems. This notebook aims to communicate the size of the agricultural workforce at risk to extreme heat today, and in the future. It presents a new insight into this risk leveraging a range of new datasets and highlights how the workday for different labourers will be disrupted by climate change in the future. You can follow the narrative for the continent as a whole, or select individual countries for geography-specific statistics.", fr: "Les systèmes alimentaires africains dépendent du travail manuel pour la production, la distribution et la transformation. Le développement économique entraîne des changements dans la structure et la taille de la population active. Ce changement, dans le nombre et la taille de la main-d’œuvre agricole, se produit parallèlement au changement climatique. L’intersection de ces deux facteurs présente une série de risques pour les systèmes alimentaires du continent africain. Ce carnet vise à communiquer la taille de la main d’œuvre agricole exposée aujourd’hui et à l’avenir à la chaleur extrême. Il présente un nouvel aperçu de ce risque en exploitant une série de nouveaux ensembles de données et souligne comment la journée de travail des différents travailleurs sera perturbée par le changement climatique à l'avenir. Vous pouvez suivre le récit du continent dans son ensemble ou sélectionner des pays individuels pour obtenir des statistiques spécifiques à la géographie." } }, futureWorkforce: { title: { en: "The Future of the Agricultural Workforce", fr: "L’avenir de la Main-d’Œuvre Agricole" }, intro: { en: "The agricultural workforce covers the entire employed portion of the employable population involved in the agriculture sector. In the African continent, the vast majority of these are farmers. However, the number of farmers and the size of the workforce is not static, and depends on structural factors which drive rural population growth, push or pull the rural population towards urban areas over time. Here, you can explore how the size of the agricultural workforce today and how it will change as a result of these factors in the future.", fr: "La main d’œuvre agricole couvre l’ensemble de la part occupée de la population employable impliquée dans le secteur agricole. Sur le continent africain, la grande majorité d’entre eux sont des agriculteurs. Cependant, le nombre d’agriculteurs et la taille de la main d’œuvre ne sont pas statiques et dépendent de facteurs structurels qui stimulent la croissance de la population rurale, poussent ou attirent la population rurale vers les zones urbaines au fil du temps. Ici, vous pouvez découvrir comment la taille de la main-d’œuvre agricole aujourd’hui et comment elle évoluera en raison de ces facteurs à l’avenir." }, map: { caption: { en: `Grey regions signal lack of :::selector::: data`, fr: `Les régions grises signalent un manque de données sur la :::selector:::` }, mapLayer: { title: { en: "Map Layer", fr: "Couche de Carte" }, values: { ag_workforce_data_2: { label: { en: "Ag population baseline (circa 2005)", fr: "Référence de la population agricole (vers 2005)" }, labelTip: { en: "Ag population", fr: "Population agricole" }, labelLegend: { en: "Ag population", fr: "Population agricole" } }, ag_workforce_data_1: { label: { en: "Percentage change by 2030", fr: "Pourcentage de changement d’ici 2030" }, labelTip: { en: "Population change by 2030", fr: "Changement en population d’ici 2030" }, labelLegend: { en: "Population change by 2030 (%)", fr: "Changement en population d’ici 2030 (%)" } }, ag_workforce_data: { label: { en: "Percentage change by 2050", fr: "Pourcentage de changement d’ici 2050" }, labelTip: { en: "Population change by 2050", fr: "Changement en population d’ici 2050" }, labelLegend: { en: "Population change by 2050 (%)", fr: "Changement en population d’ici 2050 (%)" } }, ag_workforce_data_15: { label: { en: "Ag population in 2030", fr: "Population agricole en 2030" }, labelTip: { en: "Ag population in 2030", fr: "Population agricole en 2030" }, labelLegend: { en: "Ag population in 2030", fr: "Population agricole en 2030" } }, ag_workforce_data_10: { label: { en: "Ag population in 2050", fr: "Population agricole en 2050" }, labelTip: { en: "Ag population in 2050", fr: "Population agricole en 2050" }, labelLegend: { en: "Ag population in 2050", fr: "Population agricole en 2050" } } } } }, quickInsights: { direction: { inc: { en: "an increase", fr: "une augmentation" }, dec: { en: "a decrease", fr: "une diminution" } }, basePop: { en: `**:::geo:::**’s total agricultural population is **:::total:::** for the baseline year, circa 2005.`, fr: `La population agricole totale **:::geo:::** est de **:::total:::** pour l’année de référence, vers 2005.` }, popChange: { en: `The total agricultural population is expected to change to **:::change2030:::** by 2030, and to **:::change2050:::** by 2050, under SSP245. These represent **:::direction2030:::** of **:::perc2030:::%** and **:::direction2050:::** of **:::perc2050:::%**, respectively.`, fr: `La population agricole totale devrait passer à **:::change2030:::** d’ici 2030 et à **:::change2050:::** d’ici 2050, dans le cadre du SSP245. Cela représente **:::direction2030:::** de **:::perc2030:::%** et **:::direction2050:::** de **:::perc2050:::%**, respectivement.` }, popScenario: { en: `Under SSP585, the total agricultural population will be **:::pop2030:::** by 2030 and **:::pop2050:::** by 2050. These represent **:::direction:::** of **:::perc2030:::%** and **:::perc2050:::%**, respectively.`, fr: `Dans le cadre du SSP585, la population agricole totale sera de **:::pop2030:::** d'ici 2030 et de **:::pop2050:::** d'ici 2050. Cela représente **:::direction:::** de **:::perc2030:::%** et **:::perc2050:::%**, respectivement.` } } }, heatStress: { title: { en: "Heat Stress in Numbers", fr: "Le Stress Thermique en Chiffres" }, intro: { en: "An important question is how the increases in agricultural workforce on the African continent will be affected by climate change. A key indicator of climate change impacts on human well being is heat stress. The level of heat stress experienced by a person depends not only on temperature but also on humidity, which are together often represented in terms of Wet Bulb Globe Temperature, where thresholds exceeding 28°C are considered harmful, and those exceeding 32°C extremely harmful. Use the dropdowns below to explore how many days in the year the agricultural workforce will be exposed to harmful heat stress for specific geographies, temperature thresholds and climate change scenarios.", fr: "Une question importante est de savoir comment les augmentations de la main-d'œuvre agricole sur le continent africain seront affectées par le changement climatique. Un indicateur clé des impacts du changement climatique sur le bien-être humain est le stress thermique. Le niveau de stress thermique ressenti par une personne dépend non seulement de la température mais aussi de l'humidité, qui sont souvent représentés conjointement en termes de température du globe humide, où des seuils dépassant 28°C sont considérés comme nuisibles, et ceux dépassant 32°C extrêmement nuisibles. Utilisez les menus déroulants ci-dessous pour explorer combien de jours dans l'année la main-d'œuvre agricole sera exposée à un stress thermique nuisible pour des géographies spécifiques, des seuils de température et des scénarios de changement climatique." }, barChart: { caption: { en: "To ensure that the details across all bins are visible without being dominated by the initial range, the 0-5% bin has been intentionally excluded from this visualization.", fr: "Pour garantir que les détails dans tous les groupes sont visibles sans être dominés par la plage initiale, le groupe 0-5 % a été intentionnellement exclu de cette visualisation." }, group: { baseline: { en: "Baseline", fr: "Référence" }, projection: { en: "Projection", fr: "Projection" } }, xLabel: { en: "Percent of Year Exceeding Safe Working Conditions", fr: "Pourcentage de l'année dépassant les conditions de travail sécuritaires" }, yLabel: { en: "People Exposed", fr: "Personnes Exposées" }, tooltip: { exposed: { en: "Ag pop exposed", fr: "Population agricole exposée" }, period: { en: "Period", fr: "Période" } } }, figureBody: { en: "The figure presents the count of agricultural workers subject to unsafe Wet Bulb Globe Temperature (WBGT) levels across the year, based on both baseline data and projections. For instance, if a projection displays 16 million people within the 45%-50% bin, it means that these individuals are exposed to unsafe working conditions for a portion of their day, 45% to 50% of the days in the year.", fr: "La figure présente le nombre de travailleurs agricoles soumis à des niveaux dangereux de température du globe humide (WBGT) tout au long de l’année, sur la base à la fois de données de base et de projections. Par exemple, si une projection affiche 16 millions de personnes dans la tranche 45 à 50 %, cela signifie que ces personnes sont exposées à des conditions de travail dangereuses pendant une partie de leur journée, soit 45 à 50 % des jours de l’année." }, quickInsights: { overview: { en: `For over **100 days** in a year, the people at risk for the baseline were **:::baseRisk:::**; under the scenario **:::scenario:::** and year **:::year:::**, it ascends to **:::projectionRisk:::**.`, fr: `Pendant plus de **100 jours** par an, les personnes à risque étaient de **:::baseRisk:::**; dans le scénario **:::scenario:::** et l'année **:::year:::**, il monte à **:::projectionRisk::: de personnes**.` }, half: { en: `For the baseline period, **:::baseline:::** people experienced unsafe working conditions for at least **half of the days** in the year. Under the scenario **:::scenario:::** and year **:::year:::**, it's expected to rise to **:::projection:::** people.`, fr: `Pour la période de référence, **:::baseline:::** personnes ont connu des conditions de travail dangereuses pendant au moins la **moitié des jours** de l'année. Dans le scénario **:::scenario:::** et l'année **:::year:::**, on s'attend à ce qu'il s'élève à **:::projection:::** personnes.` } } }, workingHours: { title: { en: "Loss of Safe Working Hours", fr: "Perte d'Heures de Travail Sécurisées" }, intro: { en: "Importantly, it is not just the days of climate disruptions to the agricultural workforce that matter. The hours during the day and the time in the growing season, whether planting, or harvesting, all influence how these disruptions will take place and impact on the sector. Use the figure below to explore how these safe working hours will be disrupted for different populations under different climate scenarios, temperature thresholds, and different geographies on the African continent.", fr: "Il est important de noter que ce ne sont pas seulement les jours de perturbations climatiques qui affectent la main-d'œuvre agricole qui comptent. Les heures pendant la journée et le moment dans la saison de croissance, que ce soit lors de la plantation ou de la récolte, influencent toutes la manière dont ces perturbations se produiront et auront un impact sur le secteur. Utilisez la figure ci-dessous pour explorer comment ces heures de travail sécurisées seront perturbées pour différentes populations sous différents scénarios climatiques, seuils de température et différentes géographies sur le continent africain." }, barChart: { xLabel: { en: "Hour of Day", fr: "Heure de la Journée" }, yLabel: { en: "Percent Loss of Season due to Extreme Heat", fr: "Pourcentage de Perte de Saison due à une Chaleur Extrême" }, tooltip: { perc: { en: "Percent loss", fr: "Pourcentage de perte" }, period: { en: "Period", fr: "Période" } } }, quickInsights: { intro: { en: `The figure illustrates the percentage of the harvesting and planting seasons during which the Wet Bulb Globe Temperature (WBGT) surpasses safe working limits, as per the selected threshold, relative to the baseline. This highlights the projected changes for the future. For example, a **15%** figure for the harvesting season at 11am indicates that, under the specified scenario and year, there will be **15% fewer days** out of the total season where the population can work safely at that time.`, fr: `La figure illustre le pourcentage des saisons de récolte et de plantation au cours desquelles la température du globe humide (WBGT) dépasse les limites de travail sécuritaire, selon le seuil sélectionné, par rapport à la référence. Cela met en évidence les changements projetés pour l’avenir. Par exemple, un chiffre de **15%** pour la saison de récolte à 11 heures du matin indique que, selon le scénario et l'année spécifiés, il y aura **15% de jours en moins** sur la saison totale où la population pourra travailler en toute sécurité à ce moment-là.` }, body: { en: `Under scenario **:::scenario:::** and year **:::year:::**, a policy of avoiding unsafe working hours would translate into **:::totalHours:::** working hours lost during the harvesting season, spanning **:::daysHarvest:::** days; if we consider a common working day to have 8 hours, this translates into **:::wholeWorkingDays:::** total working days lost in harvesting in a year.`, fr: `Dans le scénario **:::scenario:::** et l’année **:::year:::**, une politique visant à éviter les heures de travail dangereuses se traduirait par **:::totalHours:::** heures de travail perdues pendant la saison des récoltes, s’étalant sur **:::daysHarvest:::** jours; si l’on considère qu’une journée de travail commune compte 8 heures, cela se traduit par **:::wholeWorkingDays:::** jours de travail perdus au total pour la récolte au cours d’une année.` }, lostDays: { en: `For the planting period, spanning **:::period:::** days, **:::geo:::** would lose **:::lostDays:::** whole working days.`, fr: `Pour la période de plantation, qui s'étend sur **:::period:::** jours, **:::geo:::** perdrait **:::lostDays:::** jours de travail entiers.` } } }, summary: { title: { en: "Summary", fr: "Résumé" }, intro: { en: "Climate change will drive disruptions to the African agricultural labour force. This has important implications for economic development, human health, gender equity, as well as food security. The size of the expected disruptions depend not only on climate stressors, such as increasing heat stress, but also on the expected change in the size of the agricultural workforce. There are a number of locations where these two factors will collide, driving increased risks, loss of safe working hours, agricultural productivity, and ultimately the right to work in a safe climate for millions. A number of solutions have been proposed to deal with this stress, including shifting working hours shifting in working hours, increased shade on farms, increased mechanisation, improved worker safety protocols, improved hydration and other heat stress coping mechanisms. Ultimately however, solutions on the scale of adaptation required have yet to be developed, and based on the size of this risk need to be addressed urgently to maintain human health and environmental rights, agricultural productivity, and food security, now and in the future.", fr: "Le changement climatique entraînera des perturbations dans la main-d’œuvre agricole africaine. Cela a des implications importantes pour le développement économique, la santé humaine, l’équité entre les sexes ainsi que la sécurité alimentaire. L’ampleur des perturbations attendues dépend non seulement des facteurs de stress climatiques, tels que l’augmentation du stress thermique, mais également de l’évolution attendue de la taille de la main d’œuvre agricole. Il existe un certain nombre d’endroits où ces deux facteurs entreront en collision, entraînant une augmentation des risques, une perte d’heures de travail sûres, une perte de productivité agricole et, en fin de compte, le droit de travailler dans un climat sûr pour des millions de personnes. Un certain nombre de solutions ont été proposées pour faire face à ce stress, notamment le décalage des horaires de travail, l'augmentation de l'ombre dans les fermes, l'augmentation de la mécanisation, l'amélioration des protocoles de sécurité des travailleurs, l'amélioration de l'hydratation et d'autres mécanismes d'adaptation au stress thermique. Toutefois, en fin de compte, les solutions à l’échelle d’adaptation requise doivent encore être développées et, compte tenu de l’ampleur de ce risque, il convient d’y remédier de toute urgence afin de préserver la santé humaine et les droits environnementaux, la productivité agricole et la sécurité alimentaire, aujourd’hui et à l’avenir." } }, methods: { title: { en: "Methods", fr: "Méthodologie" }, agWorkforce: { title: { en: "Agricultural workforce", fr: "Main d'œuvre agricole" }, body: { en: `We generated gridded predictions for the agricultural workforce by first harmonising subnational data from census statistics from a range of government sources, with national data from the [International Labour Organisation (ILO)](https://rshiny.ilo.org/dataexplorer36/?lang=en&segment=indicator&id=EAP_2WAP_SEX_AGE_RT_A) on the proportion of the population employed in agriculture. Then, using a geospatial version of the predictive framework introduced by [Mehrabi, Z (2023) Nat Sust](https://doi.org/10.1038/s41893-023-01110-y), we fit functions relating workforce size to [population statistics from Jones and O’Neill (2016)](https://www.cgd.ucar.edu/sections/iam/modeling/spatial-population), [gridded gdp from Wang and Sun (2022)](https://www.nature.com/articles/s41597-022-01300-x), and [agricultural land area by Ramankutty et al. (2008)](https://agupubs.onlinelibrary.wiley.com/doi/10.1029/2007GB002952). We employed stacked machine learning models (boosted regression trees, random forests) for the fitting process. Using these models and current and future gridded data we generated baseline-period (circa 2005) and future (2030, 2050) estimates of the agricultural workforce at 0.083 degrees resolution for the African continent.`, fr: `Nous avons généré des prévisions en grille pour la main-d'œuvre agricole en harmonisant d'abord les données subnationales issues des statistiques de recensement provenant de diverses sources gouvernementales, avec les données nationales de [l'Organisation internationale du travail](https://rshiny.ilo.org/dataexplorer36/?lang=en&segment=indicator&id=EAP_2WAP_SEX_AGE_RT_A) (OIT) sur la proportion de la population employée dans l'agriculture. Ensuite, en utilisant une version géospatiale du cadre prédictif introduit par [Mehrabi, Z (2023) Nat Sust](https://doi.org/10.1038/s41893-023-01110-y), nous ajustons les fonctions reliant la taille de la main-d'œuvre aux [statistiques démographiques de Jones et O'Neill (2016)](https://www.cgd.ucar.edu/sections/iam/modeling/spatial-population), [le PIB maillé de Wang et Sun (2022)](https://www.nature.com/articles/s41597-022-01300-x), et la [superficie des terres agricoles par Ramankutty et al. (2008)](https://agupubs.onlinelibrary.wiley.com/doi/10.1029/2007GB002952). Nous avons utilisé des modèles d'apprentissage automatique empilés (arbres de régression améliorés, random forests) pour le processus d'ajustement. À l’aide de ces modèles et des données en grille actuelles et futures, nous avons généré des estimations pour la période de référence (vers 2005) et future (2030, 2050) de la main-d’œuvre agricole avec une résolution de 0,083 degrés pour le continent africain.` } }, heatStress: { title: { en: "Heat stress", fr: "Stress thermique" }, body: { en: `We use high-resolution, daily gridded data from the Climate Hazards Center Coupled Model Intercomparison Project Phase 6 (CHC-CMIP6) dataset [Williams et al. (2024)](https://www.nature.com/articles/s41597-024-03074-w). The CHC-CMIP6 dataset provides future estimates for 2030 and 2050, whose delta fields are based on the CMIP6 multi-model ensemble forecasts for the SSP 245 and SSP 585 scenarios. As inputs to compute WBGT values, we take from the dataset three main variables: the daily maximum and minimum temperatures (Tmax and Tmin), as well as the maximum daily relative humidity (RHx) that occurs at the time of Tmax, for both, the observation period (circa 2005, average taken across 10 years), and the future projections under SSP 2.45 and 5.85 (years 2030 and 2050, average taken across 10 years).`, fr: `Nous utilisons des données en grille quotidiennes à haute résolution provenant de l'ensemble de données de la phase 6 du projet de comparaison de modèles couplés du Climate Hazards Center (CHC-CMIP6) [Williams et al. (2024)](https://www.nature.com/articles/s41597-024-03074-w). L'ensemble de données CHC-CMIP6 fournit des estimations futures pour 2030 et 2050, dont les champs delta sont basés sur les prévisions d'ensemble multimodèles CMIP6 pour les scénarios SSP 245 et SSP 585. Comme entrées pour calculer les valeurs WBGT, nous prenons à partir de l'ensemble de données trois variables principales : les températures quotidiennes maximales et minimales (Tmax et Tmin), ainsi que l'humidité relative quotidienne maximale (RHx) qui se produit au moment de Tmax, pour les deux, la période d’observation (vers 2005, moyenne sur 10 ans) et les projections futures dans le cadre des PAS 2,45 et 5,85 (années 2030 et 2050, moyenne sur 10 ans).` } }, hourlyExposure: { title: { en: "Hourly exposure", fr: "Exposition horaire" }, body: { en: `We examine agricultural workers' hourly exposure to heat stress during the harvesting and planting seasons, crucial periods in the agricultural calendar, where agricultural labourers are exposed to prolonged labour-intense outdoor activity, making them more susceptible to the impacts of heat stress. We use the crop calendars from [GGCMI Phase 3](https://zenodo.org/records/5062513), which provide the planting and harvesting dates for eighteen distinct crops and show exposure histograms during these periods. The histograms quantify the percentage of days within the harvesting or planting periods that surpass WBGT safety standards for each hour of the day. Here we compute and rely on hourly WBGT exceedances in present and future, for different SSPs and years. The calculations for the hourly temperature rely on Linvill’s (1990) method for predicting hourly temperatures from daily minimum and maximum measurements. To compute such temperature profiles, we rely on daylength values, mainly taken from [Spencer (1971)](https://www.mail-archive.com/sundial@uni-koeln.de/msg01050.html). This approach was used to create hourly temperature profiles; then, hourly heat index values relying on relative humidity values and following the [NOAA guidelines](https://www.wpc.ncep.noaa.gov/html/heatindex_equation.shtml); and, finally, hourly WBGT, which was evaluated at three different thresholds – 28, 30 and 32 degrees Celsius.`, fr: `Nous examinons l'exposition horaire des travailleurs agricoles au stress thermique pendant les saisons de récolte et de plantation, périodes cruciales du calendrier agricole, où les travailleurs agricoles sont exposés à une activité extérieure prolongée et intense, les rendant plus sensibles aux impacts du stress thermique. Nous utilisons les calendriers de cultures de la [phase 3 du GGCMI](https://zenodo.org/records/5062513), qui fournissent les dates de plantation et de récolte de dix-huit cultures distinctes et affichent des histogrammes d'exposition pendant ces périodes. Les histogrammes quantifient le pourcentage de jours au cours des périodes de récolte ou de plantation qui dépassent les normes de sécurité du WBGT pour chaque heure de la journée. Ici, nous calculons et nous appuyons sur les dépassements horaires du WBGT dans le présent et le futur, pour différents SSP et années. Les calculs de température horaire s’appuient sur la méthode de Linvill (1990) pour prédire les températures horaires à partir de mesures quotidiennes minimales et maximales. Pour calculer de tels profils de température, nous nous appuyons sur les valeurs de longueur du jour, principalement tirées de [Spencer (1971)](https://www.mail-archive.com/sundial@uni-koeln.de/msg01050.html). Cette approche a été utilisée pour créer des profils de température horaires ; puis, les valeurs horaires de l'indice de chaleur basées sur les valeurs d'humidité relative et suivant les [directives de la NOAA](https://www.wpc.ncep.noaa.gov/html/heatindex_equation.shtml); et enfin le WBGT horaire, qui a été évalué à trois seuils différents – 28, 30 et 32 degrés Celsius.` } }, additionalMethods: { title: { en: "Additional methods", fr: "Méthodologie supplémentaire" }, body: { en: `Full methodological details are contained in two forthcoming background papers: - Ormaza-Zulueta, N and Mehrabi, Z. *Mapping global agricultural workforce* - Ormaza-Zulueta, N and Mehrabi, Z. *Reductions in the agricultural workday in future due to climate change*`, fr: `Les détails méthodologiques complets sont contenus dans deux documents de référence à venir: - Ormaza-Zulueta, N et Mehrabi, Z. *Cartographie de la main-d'œuvre agricole mondiale* - Ormaza-Zulueta, N et Mehrabi, Z. *Réductions de la journée de travail agricole à l'avenir en raison du changement climatique*` }, linkNote: { en: "Links will be updated when published.", fr: "Les liens seront mis à jour une fois publiés." } }, citation: { title: { en: "Citation", fr: "Citation" }, body: { en: "If the above links to background papers are not live, please use the following citation for this analysis: Ormaza-Zulueta, N and Mehrabi, Z. 2024. Widespread Workforce Disruptions. Africa Agriculture Adaptation Atlas. CGIAR.", fr: "Si les liens ci-dessus vers les documents de référence ne sont pas actifs, veuillez utiliser la citation suivante pour cette analyse: Ormaza-Zulueta, N et Mehrabi, Z. 2024. Disruptions généralisées de la main-d'œuvre. Atlas de l’adaptation de l’agriculture en Afrique. GCRAI." } } } } }; }37:T621,styling = { return !toggleCustomStyling ? "no custom styling" : htl.html`` }38:T4cf,function tocOneliner({ selector = "h1", // selectors to include (can comma-separate, like "h1,h2,h3") heading = "In this notebook", // heading for ToC delim = ' | ', // delimiter between links skip = [], // text content for headers to exclude } = {}) { // return a one-liner table of contents // allow for skips // modified from https://observablehq.com/@mbostock/toc return Generators.observe(notify => { let headings = []; function observed() { let h = Array.from(document.querySelectorAll(selector)); h = h.filter((d) => !skip.includes(d.textContent)) if (h.length !== headings.length || h.some((h, i) => headings[i] !== h)) { notify(html`${heading}
${Array.from(headings = h, (h, i) => { const end = i === headings.length - 1 return Object.assign( html`${DOM.text(h.textContent)}${end ? '' : delim}`, {onclick: e => (e.preventDefault(), h.scrollIntoView())} ); })}`); } } const observer = new MutationObserver(observed); observer.observe(document.body, {childList: true, subtree: true}); observed(); return () => observer.disconnect(); }); }39:T639,// grab tabular data for choropleth dataGeoImpact = { // get data for choropleth map based on choice let dataSource; if (selectGeoDataType.key == "ag_workforce_data_2") { dataSource = dataPopulation; } else if (selectGeoDataType.key == "ag_workforce_data") { dataSource = dataTotalAgW; } else if (selectGeoDataType.key == "ag_workforce_data_15") { dataSource = dataTotalAgWMid_abs; } else if (selectGeoDataType.key == "ag_workforce_data_10") { dataSource = dataTotalAgW_abs; } else { dataSource = dataTotalAgWMid; } // select different data based on admin selections if (adminSelections.selectAdmin1.value) { // admin1 or 2 is selected, show all admin2's for selected admin1 return T.tidy( dataSource, T.filter((d) => { return d.admin0_name == adminSelections.selectAdmin0.value && d.admin1_name == adminSelections.selectAdmin1.value && d.admin2_name // always non-null }) ); } else if (adminSelections.selectAdmin0.value) { // admin0 is selected, with no admin1 // get all admin1 data for selected admin0 return T.tidy( dataSource, T.filter((d) => { return d.admin0_name == adminSelections.selectAdmin0.value && d.admin1_name // always non-null && !d.admin2_name // always null }) ) } else { // end case: admin0 is not selected // get all admin0 data return T.tidy( dataSource, T.filter((d) => { return !d.admin1_name // always null && !d.admin2_name // always null }) ) } }3a:T5d8,// bind geojson to tabular data mapDataGeoImpact = { // no selections if (!adminSelections.selectAdmin0.value) { return bindTabularToGeo({ data: dataGeoImpact, dataBindColumn: "admin0_name", geoData: boundaries.admin0, geoDataBindColumn: "admin0_name" }); } // admin0 selected only else if (!adminSelections.selectAdmin1.value) { const data = T.tidy( dataGeoImpact, T.mutate({ a1_a0: (d) => [d.admin1_name, d.admin0_name].join("_") }) ); const geoData = { ...boundaries.admin1, features: boundaries.admin1.features.filter( (d) => d.properties.admin0_name == adminSelections.selectAdmin0.value ) }; return bindTabularToGeo({ data: data, dataBindColumn: "a1_a0", geoData: geoData, geoDataBindColumn: "a1_a0" }); } // admin1 is selected // show all admin2 regions within admin1 else { const data = T.tidy( dataGeoImpact, T.mutate({ a2_a1_a0: (d) => [d.admin2_name, d.admin1_name, d.admin0_name].join("_") }) ); const geoData = { ...boundaries.admin2, features: boundaries.admin2.features.filter( (d) => d.properties.admin1_name == adminSelections.selectAdmin1.value && d.properties.admin0_name == adminSelections.selectAdmin0.value ) }; return bindTabularToGeo({ data: data, dataBindColumn: "a2_a1_a0", geoData: geoData, geoDataBindColumn: "a2_a1_a0" }); } }3b:T973,// dynamic insights for an Admin Selection dynamicInsights_geoImpact = { // define data const totalVop = filterByAdminNames(dynInsightGeo_vopTotals); const population = filterByAdminNames(dynInsightGeo_population); const perc30 = filterByAdminNames(dynInsightGeo_percentTotals_mid); const perc50 = filterByAdminNames(dynInsightGeo_percentTotals); // format functions const _formatTopNVop = formatUSD; const _formatNumber = formatNumCompactLong({locale: language.locale}); function getTopValue({ d, i } = {}) { return { data: d?.[i]?.agw_total, value: formatWithDefault({ value: d?.[i]?.agw_total, format: _formatNumber }), label: formatWithDefault({ value: d?.[i]?.crop }) }; } // make insights ------------------------------------ return { data: { totalVop, population }, insight: { totalVop: formatWithDefault({ value: totalVop?.[0]?.agw_total, format: _formatNumber }), totalPop: formatWithDefault({ value: population?.[0]?.total_pop, format: _formatNumber }), totalRuralPop: formatWithDefault({ value: population?.[0]?.rural_pop, format: _formatNumber }), totalAgPop: formatWithDefault({ value: population?.[0]?.ag_pop, format: _formatNumber }), totalAgPop_noformat: formatWithDefault({ value: population?.[0]?.ag_pop }), totalAgPop_2_30: formatWithDefault({ value: population?.[0]?.ag_pop_2_30, format: _formatNumber }), totalAgPop_2_30_noformat: formatWithDefault({ value: population?.[0]?.ag_pop_2_30 }), totalAgPop_2_50: formatWithDefault({ value: population?.[0]?.ag_pop_2_50, format: _formatNumber }), totalAgPop_2_50_noformat: formatWithDefault({ value: population?.[0]?.ag_pop_2_50 }), totalAgPop_5_30: formatWithDefault({ value: population?.[0]?.ag_pop_5_30, format: _formatNumber }), totalAgPop_5_30_noformat: formatWithDefault({ value: population?.[0]?.ag_pop_5_30 }), totalAgPop_5_50: formatWithDefault({ value: population?.[0]?.ag_pop_5_50, format: _formatNumber }), totalAgPop_5_50_noformat: formatWithDefault({ value: population?.[0]?.ag_pop_5_50 }), } }; }3c:T450,dynInsightGeo_population = db.query(` with tbl as ( -- ag workforce population data select admin0_name , admin1_name , admin2_name , total , rural , corrected_ag_pop , corrected_index_ag_pop_SSP2_2050 , corrected_index_ag_pop_SSP2_2030 , corrected_index_ag_pop_SSP5_2050 , corrected_index_ag_pop_SSP5_2030 from ag_workforce_data order by admin0_name , admin1_name , admin2_name ) -- QUERY ------------------------------------------ ( -- total for all regions select null as admin0_name , null as admin1_name , null as admin2_name , * from ( select sum(total) as total_pop , sum(rural) as rural_pop , sum(corrected_ag_pop) as ag_pop , sum(corrected_index_ag_pop_SSP2_2030) as ag_pop_2_30 , sum(corrected_index_ag_pop_SSP2_2050) as ag_pop_2_50 , sum(corrected_index_ag_pop_SSP5_2050) as ag_pop_5_50 , sum(corrected_index_ag_pop_SSP5_2030) as ag_pop_5_30 from tbl where admin1_name is null ) union select * from tbl order by 1, 2, 3 ) `)3d:T475,// make the bar chart for top crops // approach is passing in data for selected hazard and crop type function makeTopCropBarChart(data) { // if no data is available for selected hazard, show a message if (data.length == 0) { return md`*No VoP exposure*`; } const topN = 10; return Plot.plot({ width, marginLeft: 100, caption: monetaryVoPNote, x: { tickFormat: formatUSD, label: "VoP at risk ($)", grid: true }, y: { label: null, tickSize: 0, }, color: { domain: hazardPlotLookup.color.domain, range: hazardPlotLookup.color.range }, marks: [ Plot.barX(data, { x: "vop", y: (d) => hazardPlotLookup.crops[d.crop], fill: (d) => hazardPlotLookup.names[d.hazard], sort: { y: "x", reverse: true, limit: 10 }, channels: { vop: { label: "VoP at risk", value: "vop" } }, tip: { format: { x: false, y: false, fill: false, vop: (d) => formatUSD(d) } } }) ] }); }3e:T480,// make the bar chart for top crops // approach is passing in data for selected hazard and crop type function makeHourlyBarChart(data) { // if no data is available for selected hazard, show a message if (data.length == 0) { return md`*No VoP exposure*`; } const topN = 10; return Plot.plot({ width, marginLeft: 100, caption: monetaryVoPNote, x: { tickFormat: formatUSD, label: "VoP at risk ($)", grid: true }, y: { label: null, tickSize: 0, }, color: { domain: hourlyPlotLookup.color.domain, range: hourlyPlotLookup.color.range }, marks: [ Plot.barX(data, { x: "delta", y: (d) => hourlyPlotLookup.hours[d.hour_day], fill: (d) => hourlyPlotLookup.names[d.hazard], sort: { y: "x", reverse: true, limit: 10 }, channels: { delta: { label: "VoP at risk", value: "delta" } }, tip: { format: { x: false, y: false, fill: false, delta: (d) => formatUSD(d) } } }) ] }); }3f:T4f1,-- admin0, combine for Sub-Saharan Africa with data_tbl as ( with tbl as ( -- total for all admin0 regions with base as ( -- chosen scenario and timeframe, VoP select admin0_name , admin1_name , admin2_name , scenario , timeframe , hour_day , threshold , hazard , corrected_pop as corrected_pop_sum , delta_pop as delta_pop_mean , total_days as days_period , avg_count as delta from hourly_data where timeframe = ${selectScenarioAndTimeframe2.timeframe} and scenario = ${selectScenarioAndTimeframe2.scenario} and threshold = ${selectThreshold2.threshold} ) select * from base where admin1_name is null ) -- total VoP for each crop select threshold , scenario , timeframe , hour_day , hazard , SUM(corrected_pop_sum) as corrected_pop_sum , MEAN(delta_pop_mean) as delta_pop_mean , MEAN(delta) as delta , MEAN(days_period) as days_period from tbl group by scenario , timeframe , threshold , hazard , hour_day ) select null as admin0_name -- add admin values as nulls , null as admin1_name , null as admin2_name , * from data_tbl40:T4bc,function buildHierarchy(csv) { // Helper function that transforms the given CSV into a hierarchical format. const root = { name: "root", children: [] }; for (let i = 0; i < csv.length; i++) { const sequence = csv[i][0]; const size = +csv[i][1]; if (isNaN(size)) { // e.g. if this is a header row continue; } const parts = sequence.split("_"); let currentNode = root; for (let j = 0; j < parts.length; j++) { const children = currentNode["children"]; const nodeName = parts[j]; let childNode = null; let foundChild = false; // Search for existing child with the same name for (let k = 0; k < children.length; k++) { if (children[k]["name"] === nodeName) { childNode = children[k]; foundChild = true; break; } } // If not found, create a new child node if (!foundChild) { childNode = { name: nodeName, children: [] }; children.push(childNode); } currentNode = childNode; // If it's the last part of the sequence, create a leaf node if (j === parts.length - 1) { childNode.value = size; } } } return root; }41:[{"id":"309844174fa054314ddef3aa486401df8b1bda509204ac625deb0f82bb65387d47f65a2ace488771b242f9833261f7805e4bc45d54e0bde0916de68b7d8d0ab2","href":"https://static.observableusercontent.com/files/309844174fa054314ddef3aa486401df8b1bda509204ac625deb0f82bb65387d47f65a2ace488771b242f9833261f7805e4bc45d54e0bde0916de68b7d8d0ab2","name":"exposure_adm_sum.parquet","type":"application/octet-stream","lastModified":1710193640992.127,"size":2529226},{"id":"f6a29c3305754bec66c9fe14022df77bd55a58c200df10fb7b09fb3fe7b7f6d1f67dcf02864366c5248e47e3727735348d171aafb6231f02db4846d7e5fc9881","href":"https://static.observableusercontent.com/files/f6a29c3305754bec66c9fe14022df77bd55a58c200df10fb7b09fb3fe7b7f6d1f67dcf02864366c5248e47e3727735348d171aafb6231f02db4846d7e5fc9881","name":"atlas-region_admin2_harmonizedV2.json","type":"application/json","lastModified":1710193640992.127,"size":34556619},{"id":"8475a37da02bfd3428ddae5cea26c1cae5cba39eded93f7cfa90b79a64d84c3c4874af53d5ef68197f7d4e4d84a2c9edfa9721c2fec40715bcae85a87d4269fa","href":"https://static.observableusercontent.com/files/8475a37da02bfd3428ddae5cea26c1cae5cba39eded93f7cfa90b79a64d84c3c4874af53d5ef68197f7d4e4d84a2c9edfa9721c2fec40715bcae85a87d4269fa","name":"atlas-region_admin1_harmonizedV2@1.json","type":"application/json","lastModified":1710193640992.127,"size":10721042},{"id":"e800174d38f86d26e95f2883fccb71d87c42bc1bbe9edec24288ec2a66f6702052df931e560cd7f52c42d50eb7f35345d24d1e04a34eebb9e8b5bbe2551287ef","href":"https://static.observableusercontent.com/files/e800174d38f86d26e95f2883fccb71d87c42bc1bbe9edec24288ec2a66f6702052df931e560cd7f52c42d50eb7f35345d24d1e04a34eebb9e8b5bbe2551287ef","name":"population_long.parquet","type":"application/octet-stream","lastModified":1710193640992.127,"size":145112},{"id":"049db310b3cf39c1a18b534bcc7e6770bfc81b5b9ec2a08103f253dfab2e5dede26719dc65a751e8d1c326756a0bf383585d1108ccacb221f3a22af62b76d5b5","href":"https://static.observableusercontent.com/files/049db310b3cf39c1a18b534bcc7e6770bfc81b5b9ec2a08103f253dfab2e5dede26719dc65a751e8d1c326756a0bf383585d1108ccacb221f3a22af62b76d5b5","name":"atlas-region_admin0_harmonized.json","type":"application/json","lastModified":1710193640992.127,"size":121354},{"id":"125a6d6c3cb7e86671ef9723c943b93c1d77f2a28785939fdab906644ee99de0d07789d3cc1df2a60c6fec5b7847c3adddb7f750a9cf39f24e41351b32b32b49","href":"https://static.observableusercontent.com/files/125a6d6c3cb7e86671ef9723c943b93c1d77f2a28785939fdab906644ee99de0d07789d3cc1df2a60c6fec5b7847c3adddb7f750a9cf39f24e41351b32b32b49","name":"cover_image@1.png","type":"image/png","lastModified":1711443985549.152,"size":2290010},{"id":"d44ca9f9a75fa6d6efa6f2690f2d06bf94bec5ba1ec38ea76ff512359b72b9cf3e3176ac54dd712f9994af86f27ede7d1c1fb33e09172aeade74e451a6ad7287","href":"https://static.observableusercontent.com/files/d44ca9f9a75fa6d6efa6f2690f2d06bf94bec5ba1ec38ea76ff512359b72b9cf3e3176ac54dd712f9994af86f27ede7d1c1fb33e09172aeade74e451a6ad7287","name":"baseline_df_data@15.parquet","type":"application/octet-stream","lastModified":1712220166484.401,"size":2355925},{"id":"ac9f67676404557e97ee0e55657b9b058348803d01501622e1cd7d7dc6dc6ab9b064d684e726966835a1c6a638c6c5f57bfac8d4006106f0d7633919c771f83c","href":"https://static.observableusercontent.com/files/ac9f67676404557e97ee0e55657b9b058348803d01501622e1cd7d7dc6dc6ab9b064d684e726966835a1c6a638c6c5f57bfac8d4006106f0d7633919c771f83c","name":"baseline_df_data@16.parquet","type":"application/octet-stream","lastModified":1712220232709.457,"size":2681261},{"id":"0b358317a9897bdcafd956db6e7b324132f8ad11f87cd3af12a9851446fd50451e54ad3fda07a8073f547d86970c12143975b4cff69c296ec8ec7cb9a8951ec3","href":"https://static.observableusercontent.com/files/0b358317a9897bdcafd956db6e7b324132f8ad11f87cd3af12a9851446fd50451e54ad3fda07a8073f547d86970c12143975b4cff69c296ec8ec7cb9a8951ec3","name":"baseline_df_data@14.parquet","type":"application/octet-stream","lastModified":1711986106303.128,"size":2811992},{"id":"307e26dbb4b3e5f52b187aebaa7485f0be35c4695a5431c06fae6d929c902231c0059382b56a737f5a30e0ecc0c4e4ff31c9decf617b4cbb006ae97e7898530a","href":"https://static.observableusercontent.com/files/307e26dbb4b3e5f52b187aebaa7485f0be35c4695a5431c06fae6d929c902231c0059382b56a737f5a30e0ecc0c4e4ff31c9decf617b4cbb006ae97e7898530a","name":"heat_stress_data@6.parquet","type":"application/octet-stream","lastModified":1711990874617.962,"size":2375505},{"id":"178576ca3d4844fd9f09cb888c7e476cbe3da181deaaba22c64ba5e0838708cb076315e18d07946f2af4513aa9c1e5a1259c6dd400a6733242a11d821ae55742","href":"https://static.observableusercontent.com/files/178576ca3d4844fd9f09cb888c7e476cbe3da181deaaba22c64ba5e0838708cb076315e18d07946f2af4513aa9c1e5a1259c6dd400a6733242a11d821ae55742","name":"hourly_data@19.parquet","type":"application/octet-stream","lastModified":1711993851059.269,"size":4046588},{"id":"307e26dbb4b3e5f52b187aebaa7485f0be35c4695a5431c06fae6d929c902231c0059382b56a737f5a30e0ecc0c4e4ff31c9decf617b4cbb006ae97e7898530a","href":"https://static.observableusercontent.com/files/307e26dbb4b3e5f52b187aebaa7485f0be35c4695a5431c06fae6d929c902231c0059382b56a737f5a30e0ecc0c4e4ff31c9decf617b4cbb006ae97e7898530a","name":"heat_stress_data@7.parquet","type":"application/octet-stream","lastModified":1712329067616.435,"size":2375505},{"id":"987f9f5e8b99cc82cc97c1bc8255ea2601e10c695e953c1d01290c6ae46daf4833875dd355254a5de9d6e10d71efab976ef5c603c68e79ffaa958537713e6ca5","href":"https://static.observableusercontent.com/files/987f9f5e8b99cc82cc97c1bc8255ea2601e10c695e953c1d01290c6ae46daf4833875dd355254a5de9d6e10d71efab976ef5c603c68e79ffaa958537713e6ca5","name":"hourly_data@20.parquet","type":"application/octet-stream","lastModified":1712330268804.754,"size":3971272},{"id":"aef2390c57642be5ef2a7220cd24375546172881c5c1f9f36864a4f8fc1689b406375d2281b75f29b621c41300f49199c5e4ce76d13164725ca98399bb0ed4f3","href":"https://static.observableusercontent.com/files/aef2390c57642be5ef2a7220cd24375546172881c5c1f9f36864a4f8fc1689b406375d2281b75f29b621c41300f49199c5e4ce76d13164725ca98399bb0ed4f3","name":"Periscopic-Alliance-Bioversity_Adaptation-Atlas_Notebook-Title_Spotlight-7.png","type":"image/png","lastModified":1712089542974.443,"size":1597937},{"id":"78232c66c645f23514100166bccffb14a73ea5cb792169d3da2d83c446273793a6d3d26c21297633adc2d8a5eef18274c2b0f1cf29142b348b29dad8e259f206","href":"https://static.observableusercontent.com/files/78232c66c645f23514100166bccffb14a73ea5cb792169d3da2d83c446273793a6d3d26c21297633adc2d8a5eef18274c2b0f1cf29142b348b29dad8e259f206","name":"abAtlas-td-translation-data-v1.json","type":"application/json","lastModified":1724434299306.73,"size":38447},{"id":"ac0b4ab756ff89a0bc584cde279ccc95562f551827c6aa0d5b19945649715d4e3c713729dfcd90538163a75c1f44972e00dde43ea2fd812934dc134ebb200cf6","href":"https://static.observableusercontent.com/files/ac0b4ab756ff89a0bc584cde279ccc95562f551827c6aa0d5b19945649715d4e3c713729dfcd90538163a75c1f44972e00dde43ea2fd812934dc134ebb200cf6","name":"Understand-heat-stress-fr.webp","type":"image/webp","lastModified":1724434299306.73,"size":135694},{"id":"17312579a47f8734049e2707f2f03d04851a535f62a6896757ac809c559ebc4a7fdba49753a3499f4dbada6d091d10e2979d3c8330c466a95a61534d4ab977a6","href":"https://static.observableusercontent.com/files/17312579a47f8734049e2707f2f03d04851a535f62a6896757ac809c559ebc4a7fdba49753a3499f4dbada6d091d10e2979d3c8330c466a95a61534d4ab977a6","name":"Understand-heat-stress.webp","type":"image/webp","lastModified":1724434299306.73,"size":133938}] 2d:{"title":"Understand Heat Stress on Producers","cells":[{"id":3682,"value":"{\n const imgSource = {\n en: FileAttachment(\"Understand-heat-stress.webp\").url(),\n fr: FileAttachment(\"Understand-heat-stress-fr.webp\").url()\n };\n const imgUrl = _lang(imgSource);\n return htl.html`

${notebookTitle}

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3815,"value":"makeQuartoFlag(\"https://adaptationatlas.github.io/atlas_notebooksV1/notebooks/heatstressProducers/notebook.html\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":3681,"value":"// pretty view of language toggle\nviewof prettyLanguageView = {\n return Inputs.bind(\n Inputs.radio(languages, {\n label: _lang(nbText.legends.language),\n format: (d) => d.label\n }),\n viewof language\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2192,"value":"// table of contents (selected h1's)\ntocOneliner({\n selector: \"h1\",\n skip: [notebookTitle, \"Appendix\"],\n heading: `${Lang.toSentenceCase(_lang(nbText.legends.toc))}`\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2563,"value":"# ${_lang(nbText.sections.overview.title)}\n\n${_lang(nbText.sections.overview.intro)}","pinned":false,"hidden":false,"mode":"md"},{"id":2607,"value":"# ${_lang(nbText.sections.futureWorkforce.title)}\n\n${_lang(nbText.sections.futureWorkforce.intro)}","pinned":false,"hidden":false,"mode":"md"},{"id":2021,"value":"// format admin selections\n// bind to appendix inputs, add template to format\ngeoImpactAdminSelectors = Inputs.form(\n [\n Inputs.bind(\n Inputs.select(dataAdmin0, { label: adminRegions.labels.admin0, format: x => x.label }),\n viewof selectAdmin0\n ),\n Inputs.bind(\n Inputs.select(dataAdmin1, { label: adminRegions.labels.admin1, format: x => x.label }),\n viewof selectAdmin1\n ),\n Inputs.bind(\n Inputs.select(dataAdmin2, { label: adminRegions.labels.admin2, format: x => x.label }),\n viewof selectAdmin2\n )\n ],\n {\n template: adminFormTemplate\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3677,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":1260,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":3804,"value":"buildInlineDownloadButton(dataGeoImpact, _lang(download_translation), `agWorkforce_${selectAdmin0.label.replace(/\\s/g, \"\")}`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1341,"value":"headerQuickInsightsGeoImpact = {\n const adminArticle = _lang(getAdminSelection()?.data?.article1);\n const adminSelection = adminArticle ?? getAdminSelection().label;\n const text = Lang.reduceReplaceTemplateItems(\n _lang(nbText.sections.quickInsightsGeneral.header),\n [{ name: \"selection\", value: adminSelection }]\n );\n\n return md`### ${text}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1874,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":1367,"value":"# ${_lang(nbText.sections.heatStress.title)}","pinned":false,"hidden":false,"mode":"md"},{"id":1366,"value":"$${_lang(nbText.sections.heatStress.intro)}","pinned":false,"hidden":false,"mode":"md"},{"id":2018,"value":"// format admin selections\n// bind to appendix inputs, add template to format\nInputs.form(\n [\n Inputs.bind(\n Inputs.select(dataAdmin0, { label: adminRegions.labels.admin0, format: x => x.label }),\n viewof selectAdmin0\n ),\n Inputs.bind(\n Inputs.select(dataAdmin1, { label: adminRegions.labels.admin1, format: x => x.label }),\n viewof selectAdmin1\n ),\n Inputs.bind(\n Inputs.select(dataAdmin2, { label: adminRegions.labels.admin2, format: x => x.label }),\n viewof selectAdmin2\n )\n ],\n {\n template: adminFormTemplate\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1701,"value":"viewof selectScenarioAndTimeframe = {\n // scenario and timeframe\n\n const data = [\n {label: 'SSP245: 2030', scenario: 'SSP2', timeframe: '2030'},\n {label: 'SSP245: 2050', scenario: 'SSP2', timeframe: '2050'},\n {label: 'SSP585: 2030', scenario: 'SSP5', timeframe: '2030'},\n {label: 'SSP585: 2050', scenario: 'SSP5', timeframe: '2050'},\n ]\n \n return Inputs.select(data, {\n label: _lang(nbText.legends.scenario),\n format: x => x.label,\n value: data.find(d => d.label === 'SSP245: 2050')\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2684,"value":"viewof selectThreshold = {\n // scenario and timeframe\n\n const data = [\n {label: '28°C', threshold: '28'},\n {label: '30°C', threshold: '30'},\n ]\n \n return Inputs.select(data, {\n label: _lang(nbText.legends.threshold),\n format: x => x.label,\n value: data.find(d => d.label === '28')\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3669,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":3800,"value":"{\n const _anyData = T.tidy(\n data_hazardVoP,\n T.groupBy(\n [\n \"admin0_name\",\n \"admin1_name\",\n \"admin2_name\",\n \"scenario\",\n \"timeframe\",\n \"threshold\",\n \"crop\"\n ],\n [\n T.summarize({\n vop_any: T.sum(\"vop\")\n })\n ]\n )\n );\n\n const _dataWithAnyColumn = T.tidy(\n data_hazardVoP,\n T.leftJoin(_anyData, {\n by: [\n \"admin0_name\",\n \"admin1_name\",\n \"admin2_name\",\n \"scenario\",\n \"timeframe\",\n \"crop\",\n \"threshold\"\n ]\n })\n );\n\n const data = _dataWithAnyColumn;\n return buildInlineDownloadButton(data, _lang(download_translation), `daysUnsafeHeatStress_${selectAdmin0.label.replace(/\\s/g, \"\")}`)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3574,"value":"$${_lang(nbText.sections.heatStress.figureBody)}","pinned":false,"hidden":false,"mode":"md"},{"id":2743,"value":"headerQuickInsightsBars = {\n const adminArticle = _lang(getAdminSelection()?.data?.article1);\n const adminSelection = adminArticle ?? getAdminSelection().label;\n const text = Lang.reduceReplaceTemplateItems(\n _lang(nbText.sections.quickInsightsGeneral.header),\n [{ name: \"selection\", value: adminSelection }]\n );\n\n return md`### ${text}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2755,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":2260,"value":"# ${_lang(nbText.sections.workingHours.title)}\n\n${_lang(nbText.sections.workingHours.intro)}","pinned":false,"hidden":false,"mode":"md"},{"id":2882,"value":"viewBindAdminSelectors = // format admin selections\n// bind to appendix inputs, add template to format\nInputs.form(\n [\n Inputs.bind(\n Inputs.select(dataAdmin0, { label: adminRegions.labels.admin0, format: x => x.label }),\n viewof selectAdmin0\n ),\n Inputs.bind(\n Inputs.select(dataAdmin1, { label: adminRegions.labels.admin1, format: x => x.label }),\n viewof selectAdmin1\n ),\n Inputs.bind(\n Inputs.select(dataAdmin2, { label: adminRegions.labels.admin2, format: x => x.label }),\n viewof selectAdmin2\n )\n ],\n {\n template: adminFormTemplate\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2885,"value":"viewof selectScenarioAndTimeframe2 = {\n // scenario and timeframe\n\n const data = [\n // {label: 'SSP245: 2030', scenario: 'SSP2', timeframe: '2030'},\n {label: 'SSP245: 2050', scenario: 'SSP245', timeframe: '2050'},\n // {label: 'SSP585: 2030', scenario: 'SSP5', timeframe: '2030'},\n {label: 'SSP585: 2050', scenario: 'SSP585', timeframe: '2050'},\n ]\n \n return Inputs.select(data, {\n label: _lang(nbText.legends.scenario),\n format: x => x.label,\n value: data.find(d => d.label === 'SSP245: 2050')\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2889,"value":"viewof selectThreshold2 = {\n // threshold\n\n const data = [\n {label: '28°C', threshold: '28'},\n {label: '30°C', threshold: '30'},\n {label: '32°C', threshold: '32'},\n ]\n \n return Inputs.select(data, {\n label: _lang(nbText.legends.threshold),\n format: x => x.label,\n value: data.find(d => d.label === '30')\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3570,"value":"viewof radios = {\n const data = [\n {\n label: Lang.toTitleCase(_lang(nbText.legends.seasonTypes.planting)),\n value: \"planting\"\n },\n {\n label: Lang.toTitleCase(_lang(nbText.legends.seasonTypes.harvesting)),\n value: \"harvesting\"\n }\n ];\n return Inputs.radio(data, {\n label: _lang(nbText.legends.season),\n format: (x) => x.label,\n value: data.find((x) => x.value == \"planting\")\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3569,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":3787,"value":"{\n let data = T.tidy(\n data_hourlyStress,\n T.groupBy(\n [\n \"admin0_name\",\n \"admin1_name\",\n \"admin2_name\",\n \"scenario\",\n \"timeframe\",\n \"threshold\",\n \"hour_day\"\n ],\n [\n T.summarize({\n vop_any: T.mean(\"delta\")\n })\n ]\n )\n );\n return buildInlineDownloadButton(data, _lang(download_translation), `hourlyHumanHeatStress_${selectAdmin0.label.replace(/\\s/g, \"\")}`)\n }","pinned":false,"hidden":false,"mode":"ojs"},{"id":3065,"value":"headerQuickInsightsHourly = {\n const adminArticle = _lang(getAdminSelection()?.data?.article1);\n const adminSelection = adminArticle ?? getAdminSelection().label;\n const text = Lang.reduceReplaceTemplateItems(\n _lang(nbText.sections.quickInsightsGeneral.header),\n [{ name: \"selection\", value: adminSelection }]\n );\n\n return md`### ${text}\n${styling}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3117,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":2615,"value":"# ${_lang(nbText.sections.summary.title)}\n\n${_lang(nbText.sections.summary.intro)}","pinned":false,"hidden":false,"mode":"md"},{"id":3657,"value":"# ${_lang(nbText.sections.methods.title)}\n\n## ${_lang(nbText.sections.methods.agWorkforce.title)}\n${_lang(nbText.sections.methods.agWorkforce.body)}\n\n## ${_lang(nbText.sections.methods.heatStress.title)}\n${_lang(nbText.sections.methods.heatStress.body)}\n\n## ${_lang(nbText.sections.methods.hourlyExposure.title)}\n${_lang(nbText.sections.methods.hourlyExposure.body)}\n\n# ${_lang(nbText.sections.methods.additionalMethods.title)}\n${_lang(nbText.sections.methods.additionalMethods.body)}\n\n${_lang(nbText.sections.methods.additionalMethods.linkNote)}\n\n## ${_lang(nbText.sections.methods.citation.title)}\n${_lang(nbText.sections.methods.citation.body)}","pinned":false,"hidden":false,"mode":"md"},{"id":2306,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":2244,"value":"toc()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1750,"value":"---\n### Support notebook\n[Support Notebook](https://observablehq.com/@periscopic/ab-atlas-spotlight-support): used for imports across spotlights.","pinned":false,"hidden":false,"mode":"md"},{"id":3655,"value":"---\n### Translation\n_Notebook language handling and main text_","pinned":false,"hidden":false,"mode":"md"},{"id":3654,"value":"import { Lang } from \"7d46679f7d0d917e\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":3653,"value":"languages = [\n { key: \"en\", label: \"English\", locale: 'en-US' },\n { key: \"fr\", label: \"Français\", locale: 'fr-FR' }\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":3652,"value":"// get the default language key from parameter, or use default\ndefaultLangKey = {\n const name = \"lang\";\n const list = languages.map((d) => d.key);\n const defaultKey = \"en\";\n\n const queryParam = await Lang.getParamFromList({ name, list });\n\n return queryParam ?? defaultKey;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3651,"value":"// helper shorthand for Lang text-getting\n_lang = Lang.lg(language.key)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3650,"value":"// main toggle of language key\nviewof language = Inputs.radio(languages, {\n label: \"Main language toggle\",\n format: (d) => d.key,\n value: languages.find((x) => x.key === defaultLangKey),\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":3649,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"id":3648,"value":"// data translation values\ntd = {\n let data = await FileAttachment(\"abAtlas-td-translation-data-v1.json\").json()\n\n // update SSA default\n data.admin0_name.values.SSA.en = \"Sub-Saharan Africa\"\n // cote d'ivoire, comma version duplicate\n data.admin0_name.values[\"Côte d’Ivoire\"] = data.admin0_name.values[\"Côte d'Ivoire\"]\n \n return data\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1747,"value":"---\n### Notebook Variables\n_Main variables across notebook_","pinned":false,"hidden":false,"mode":"md"},{"id":1746,"value":"// main title of the notebook\nnotebookTitle = \"Understand Heat Stress on Producers\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1745,"value":"// info for the admin selectors\nadminRegions = {\n return {\n labels: {\n admin0: _lang(nbText.legends.adminSelections.country),\n admin1: _lang(nbText.legends.adminSelections.region),\n admin2: _lang(nbText.legends.adminSelections.subregion)\n }\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2110,"value":"function getLowerLevelAdminLabel(selections=adminSelections) {\n // based on admin selection, get the lower level label \n if (selections.selectAdmin2.value) return adminRegions.labels.admin2\n if (selections.selectAdmin1.value) return adminRegions.labels.admin2\n if (selections.selectAdmin0.value) return adminRegions.labels.admin1\n else return adminRegions.labels.admin0\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2551,"value":"monetaryVoPNote = `Monetary VoP values are represented in 2005 international dollars.` // note about VoP source","pinned":false,"hidden":false,"mode":"ojs"},{"id":2180,"value":"// width of the maps\nmapWidth = 625","pinned":false,"hidden":false,"mode":"ojs"},{"id":1644,"value":"---\n### Notebook Styling\n*styling helpers*\nStylesheet is a named cell, which is necessary to include for embeds.","pinned":false,"hidden":false,"mode":"md"},{"id":1813,"value":"**CSS styling**","pinned":false,"hidden":false,"mode":"md"},{"id":1643,"value":"viewof toggleCustomStyling = Inputs.toggle({label: \"Use custom styling\", value: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1642,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":2175,"value":"**Table of Contents**","pinned":false,"hidden":false,"mode":"md"},{"id":2174,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":1812,"value":"**Color Scales**","pinned":false,"hidden":false,"mode":"md"},{"id":1811,"value":"// color scale info\ncolorScales = {\n return {\n range: {\n green: ['#E4F5D0', '#015023'],\n blue: ['#E8F2FF', '#003E6B'],\n brown: ['#FFFDE5', '#A87B00'],\n yellowGreen: ['#F7D732', '#216729'],\n orangeRed: ['#F4BB21', '#EC5A47'],\n blueWhiteRed: ['#003E6B', '#FFFFFF', '#EC5A47'],\n redYellowGreen: [\"#EC5A47\", \"#F4BB21\", '#216729']\n },\n unknown: \"#ccc\"\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3780,"value":"import {buildInlineDownloadButton, downloadButtonCSS, download_translation} from \"1bda5f9b60c64223\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":3783,"value":"downloadButtonCSS","pinned":false,"hidden":false,"mode":"ojs"},{"id":1257,"value":"---\n### Admin Selection\n*Global admin selector using dropdowns*\n\nThis is the global selector for the selected region\n- The completed data is contained within `adminSelections` to be used in queries\n- Dropdowns are defined below then bound for each section\n - Defined as separate cells since they dynamically respond to different values\n - In narrative, they are simply views of the data \n - Dropdowns are dynamic based on higher-level choices\n - Options are defined from the geographic data\n - `null` value means unselected region\n- Dropdowns are added to each section, using `Inputs.bind` to create synchronized inputs (see `viewof` for input definitions). A form input is used to consolidate and apply a template to format.","pinned":false,"hidden":false,"mode":"md"},{"id":1256,"value":"// get admin0 options from geo\ndataAdmin0 = {\n const data = boundaries.admin0.features.map((d) => d.properties);\n // add a blank value\n return [null, ...data.map((d) => d.admin_name)].map((d) => {\n return {\n label:\n d == null\n ? globalSelection.label\n : _lang(td.admin0_name.values?.[d].general),\n value: d,\n data: d == null ? globalSelection.data : td.admin0_name.values?.[d],\n };\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1255,"value":"// get admin1 options based on admin0 selection\n// (the admin1 regions within selected admin0)\ndataAdmin1 = {\n // admin 1, filter by 0 \n const data = boundaries.admin1.features.map(d => d.properties)\n .filter(d => d.admin0_name == selectAdmin0.value)\n // add blank value\n return [null, ...data.map(d => d.admin1_name)].map(d => {\n return {label: d, value: d}\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1254,"value":"// get admin2 options based on admin1 selection\n// (the admin2 regions within selected admin1)\ndataAdmin2 = {\n const data = boundaries.admin2.features.map(d => d.properties)\n .filter(d => d.admin0_name == selectAdmin0.value && d.admin1_name == selectAdmin1.value)\n // add blank value\n return [null, ...data.map(d => d.admin2_name)].map(d => {\n return {label: d, value: d}\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1265,"value":"viewof selectAdmin0 = Inputs.select(dataAdmin0, {label: adminRegions.labels.admin0, format: x => x.label})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1264,"value":"viewof selectAdmin1 = Inputs.select(dataAdmin1, {label: adminRegions.labels.admin1, format: x => x.label})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1263,"value":"viewof selectAdmin2 = Inputs.select(dataAdmin2, {label: adminRegions.labels.admin2, format: x => x.label})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1253,"value":"// selected admin regions from dropdowns\nadminSelections = ({\n selectAdmin0: selectAdmin0,\n selectAdmin1: selectAdmin1,\n selectAdmin2: selectAdmin2,\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1955,"value":"// template to format admin selection form\nadminFormTemplate = (inputs) => htl.html`

${inputs}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1339,"value":"---\n### Admin Selection - Display\n*Showing admin selections*","pinned":false,"hidden":false,"mode":"md"},{"id":1338,"value":"// options for the global admin selection\n// used when no admin selection is made\nglobalSelection = {\n return {\n label: _lang(td.admin0_name.values.SSA.general),\n value: null,\n data: td.admin0_name.values.SSA\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1336,"value":"function getAdminSelection(selections=adminSelections) {\n // get the most granular admin selection made\n const a0 = selections.selectAdmin0\n const a1 = selections.selectAdmin1\n const a2 = selections.selectAdmin2\n const global = globalSelection\n\n return a2.value\n ? a2\n : a1.value\n ? a1\n : a0.value\n ? a0\n : global\n} ","pinned":false,"hidden":false,"mode":"ojs"},{"id":3603,"value":"function getAdminSelection0(selections=adminSelections) {\n // get the most granular admin selection made\n const a0 = selections.selectAdmin0\n\n return a0\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1629,"value":"function getAdminSelectionAdmin0(selections=adminSelections) {\n // get the selected admin0 or global value\n const a0 = selections.selectAdmin0\n const global = globalSelection\n\n return a0.value\n ? a0\n : global\n} ","pinned":false,"hidden":false,"mode":"ojs"},{"id":1335,"value":"function getAdminSelectionMarkdownPath(selections=adminSelections) {\n // function to show selected admin region\n // return path showing nested admin selection\n \n const delim = ' → '\n const path = [\n selections.selectAdmin0.label,\n selections.selectAdmin1.label,\n selections.selectAdmin2.label\n ].filter(d => d)\n \n const formatted = path\n .filter((d) => d)\n .map((d, i) => {\n return (i == path.length - 1)\n ? `**${d}**`\n : `*${d}*`\n })\n \n return formatted.length == 0\n ? `**${globalSelection.label}**` // no selection, all of Africa\n : `${formatted.join(delim)}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3637,"value":"getAdmin0WithAdminSubParens = ({\n articleField = \"general\",\n showParens = true\n} = {}) => {\n // getting admin0, with admin1 in parens\n // can specify admin0article lookup\n const a0 = adminSelections.selectAdmin0;\n const a1 = adminSelections.selectAdmin1;\n const a2 = adminSelections.selectAdmin2;\n\n const a0WithArticle =\n a0.value == null\n ? _lang(td.admin0_name.values?.['SSA']?.[articleField])\n : _lang(td.admin0_name.values?.[a0.value]?.[articleField]);\n if (a1.value == null) return a0WithArticle;\n if (!showParens) return a0WithArticle;\n const subLabel = a2.value == null ? a1.label : a2.label;\n return `${a0WithArticle} (${subLabel})`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1252,"value":"---\n### Choropleth map - Geographic Impact\n*Showing context for admin selection*\n\nThere is some hoop-jumping to get the right data based on the Admin Selection. The tabular data is then bound to the applicable geojson, and visualized with Plot.","pinned":false,"hidden":false,"mode":"md"},{"id":1293,"value":"// population data\ndataPopulation = db.query(`\nselect * \nfrom ag_workforce_data\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1292,"value":"// total VoP data\ndataTotalAgW = db.query(`\nselect admin0_name\n , admin1_name\n , admin2_name\n , MEAN(percentage_change_SSP2_2050_ag) as agw_total\n from ag_workforce_data\n group by 1, 2, 3\n order by 1, 2, 3\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3337,"value":"// total VoP data\ndataTotalAgW_abs = db.query(`\nselect admin0_name\n , admin1_name\n , admin2_name\n , SUM(corrected_index_ag_pop_SSP2_2050) as agw_total_abs\n from ag_workforce_data\n group by 1, 2, 3\n order by 1, 2, 3\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2624,"value":"// total Ag_SSP2_2030 data\ndataTotalAgWMid = db.query(`\nselect admin0_name\n , admin1_name\n , admin2_name\n , MEAN(percentage_change_SSP2_2030_ag) as agw_total_mid\n from ag_workforce_data\n group by 1, 2, 3\n order by 1, 2, 3\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3332,"value":"// total VoP data\ndataTotalAgWMid_abs = db.query(`\nselect admin0_name\n , admin1_name\n , admin2_name\n , SUM(corrected_index_ag_pop_SSP2_2030) as agw_total_mid_abs\n from ag_workforce_data\n group by 1, 2, 3\n order by 1, 2, 3\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1251,"value":"$39","pinned":false,"hidden":false,"mode":"ojs"},{"id":1250,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs"},{"id":1334,"value":"---\n### Dynamic Insights - Geographic Impact\n*quick insights for given admin selection*\n\n- Sql cells add a row that is the combined value for all admin regions, where all admin names are `null`.","pinned":false,"hidden":false,"mode":"md"},{"id":1453,"value":"Here are the combined data and insights for creating the dynamic narrative. Data tables are below.","pinned":false,"hidden":false,"mode":"md"},{"id":1333,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs"},{"id":1332,"value":"---\n#### Data cells for insights","pinned":false,"hidden":false,"mode":"md"},{"id":1452,"value":"// total harvested area\ndynInsightGeo_percentTotals_mid = db.query(`\nwith tbl as (\n -- total percentages\n SELECT admin0_name, admin1_name, admin2_name, MEAN(percentage_change_SSP2_2030_ag) AS percent_change_30\n FROM ag_workforce_data\n GROUP BY 1, 2, 3\n ORDER BY 1, 2, 3\n)\n\n-- QUERY ------------------------------------------\n(\n -- total for all regions\n select null as admin0_name\n , null as admin1_name\n , null as admin2_name\n , percent_change_30\n from (\n select mean(percent_change_30) as percent_change_30\n from tbl\n where admin1_name is null\n )\n \n union\n \n select * \n from tbl\n \n order by 1, 2, 3\n)\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3425,"value":"// total harvested area\ndynInsightGeo_percentTotals = db.query(`\nwith tbl as (\n -- total percentages\n SELECT admin0_name, admin1_name, admin2_name, MEAN(percentage_change_SSP2_2050_ag) AS percent_change_50\n FROM ag_workforce_data\n GROUP BY 1, 2, 3\n ORDER BY 1, 2, 3\n)\n\n-- QUERY ------------------------------------------\n(\n -- total for all regions\n select null as admin0_name\n , null as admin1_name\n , null as admin2_name\n , percent_change_50\n from (\n select mean(percent_change_50) as percent_change_50\n from tbl\n where admin1_name is null\n )\n \n union\n \n select * \n from tbl\n \n order by 1, 2, 3\n)\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1451,"value":"dynInsightGeo_vopTotals = db.query(`\n-- total ag workforce\nwith tbl as (\n -- total VoP and harvested area\n SELECT admin0_name, admin1_name, admin2_name, sum(corrected_index_ag_pop_SSP2_2050) AS agw_total\n FROM ag_workforce_data\n GROUP BY 1, 2, 3\n ORDER BY 1, 2, 3\n)\n\n-- QUERY ------------------------------------------\n(\n -- total for all regions\n select null as admin0_name\n , null as admin1_name\n , null as admin2_name\n , agw_total\n from (\n select mean(agw_total) as agw_total\n from tbl\n where admin1_name is null\n )\n \n union\n \n select * \n from tbl\n \n order by 1, 2, 3\n)\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1450,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs"},{"id":1694,"value":"---\n### Bar Charts - Hazards and Exposures\n*getting data based on admin selection and hazard options*","pinned":false,"hidden":false,"mode":"md"},{"id":2243,"value":"#### Plot Function\nMaking the top VoP bar charts","pinned":false,"hidden":false,"mode":"md"},{"id":2242,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs"},{"id":2241,"value":"#### Hazard Data","pinned":false,"hidden":false,"mode":"md"},{"id":2240,"value":"➡️ The hazard data includes a `generic` crop, which we don't have total value of production data for in the other table. We exclude this from the chart.","pinned":false,"hidden":false,"mode":"md"},{"id":2238,"value":"// data for selected hazard scenario, with total vop\ndata_hazardVoP = T.tidy(\n dataHazardSelected,\n T.leftJoin(dataHazardVoPTotalSelected, {by: ['admin0_name', 'admin1_name', 'admin2_name', 'crop']})\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2237,"value":"dataHazardVoPTotalSelected = T.tidy(\n dataHazardSelected,\n T.groupBy(\n [\n \"admin0_name\",\n \"admin1_name\",\n \"admin2_name\",\n \"threshold\",\n \"scenario\",\n \"timeframe\",\n \"crop\"\n ],\n [\n T.summarize({\n vop_total: T.sum(\"vop\")\n })\n ]\n )\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2236,"value":"// unique crops in the hazard data\nhazardCrops = {\n const query = await db.query(`select crop\n , count(*) as count\n from heat_stress_data\n group by 1\n order by 1`);\n\n return query\n }","pinned":false,"hidden":false,"mode":"ojs"},{"id":2544,"value":"// formatting crop names\ncropNames = T.tidy(\n hazardCrops,\n T.distinct(\"crop\"),\n T.select('crop'),\n T.mutate({\n // Convert crop to number for sorting\n cropNum: d => parseInt(d.crop, 10),\n // Determine the type based on the original string format (adjust as needed)\n type: d => /_/.test(d.crop) ? 'livestock' : 'crop',\n // Format the crop name\n cropName: d => {\n let cropName = d.crop.charAt(0).toUpperCase() + d.crop.slice(1)\n if (/_/.test(d.crop)) cropName = cropName.replace('_', \" (\") + ')'\n return cropName\n }\n }),\n // Use the numeric version of crop for sorting, then remove it from the final result as it's no longer needed\n T.arrange(['type', 'cropNum']),\n T.select(['type', 'crop', 'cropName']) // Assuming you want to keep these fields in the final output\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2234,"value":"// lookups for hazard plot\nhazardPlotLookup = {\n return {\n names: {\n baseline: _lang(nbText.sections.heatStress.barChart.group.baseline),\n projection: _lang(nbText.sections.heatStress.barChart.group.projection)\n },\n color: {\n domain: [\n _lang(nbText.sections.heatStress.barChart.group.baseline),\n _lang(nbText.sections.heatStress.barChart.group.projection)\n ],\n range: [\"#B1B1B1\", \"#EC5A47\"]\n },\n crops: cropNames.reduce((acc, obj) => {\n acc[obj.crop] = obj.cropName;\n return acc;\n }, {})\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1691,"value":"#### Selecting Heat Stress data by scenario\n- The data is queried as separate components for each admin region to reduce query size and allow for dynamic null handling. A table is chosen based on the selected admin region.","pinned":false,"hidden":false,"mode":"md"},{"id":1690,"value":"// pick the admin dataset based on admin selection\ndataHazardSelected = {\n if (adminSelections.selectAdmin2.value) return dataHazardAdmin2\n else if (adminSelections.selectAdmin1.value) return dataHazardAdmin1\n else if (adminSelections.selectAdmin0.value) return dataHazardAdmin0\n else return dataHazardAdminAll\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2082,"value":"-- admin0, combine for Sub-Saharan Africa\nwith data_tbl as (\n with tbl as (\n -- total for all admin0 regions\n with base as (\n -- chosen scenario and timeframe, VoP\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , crop\n , threshold\n , hazard\n , value as vop\n from heat_stress_data\n where timeframe = ${selectScenarioAndTimeframe.timeframe}\n and scenario = ${selectScenarioAndTimeframe.scenario}\n and threshold = ${selectThreshold.threshold}\n )\n \n select *\n from base\n where admin1_name is null\n )\n\n -- total VoP for each crop\n select threshold\n , scenario\n , timeframe\n , hazard\n , crop\n , SUM(vop) as vop\n from tbl\n group by threshold\n , scenario\n , timeframe\n , hazard\n , crop\n)\n\nselect null as admin0_name -- add admin values as nulls\n , null as admin1_name\n , null as admin2_name\n , *\n from data_tbl","pinned":false,"hidden":false,"mode":"sql","output":"dataHazardAdminAll","database":"var:db"},{"id":2006,"value":"-- admin0 level hazard data\nwith base as (\n -- chosen scenario and timeframe VoP\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , crop\n , threshold\n , hazard\n , value as vop\n from heat_stress_data\n where timeframe = ${selectScenarioAndTimeframe.timeframe}\n and scenario = ${selectScenarioAndTimeframe.scenario}\n and threshold = ${selectThreshold.threshold}\n)\n\nselect *\n from base\n where admin1_name is null\n and admin0_name = ${adminSelections.selectAdmin0.value}","pinned":false,"hidden":false,"mode":"sql","output":"dataHazardAdmin0","database":"var:db"},{"id":2005,"value":"-- admin1 level hazard data\nwith base as (\n -- chosen scenario and timeframe VoP\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , crop\n , threshold\n , hazard\n , value as vop\n from heat_stress_data\n where timeframe = ${selectScenarioAndTimeframe.timeframe}\n and scenario = ${selectScenarioAndTimeframe.scenario}\n and threshold = ${selectThreshold.threshold}\n)\n\nselect *\n from base\n where admin0_name = ${adminSelections.selectAdmin0.value}\n and admin1_name = ${adminSelections.selectAdmin1.value}\n and admin2_name is null","pinned":false,"hidden":false,"mode":"sql","output":"dataHazardAdmin1","database":"var:db"},{"id":2004,"value":"-- admin2 level hazard data\nwith base as (\n -- chosen scenario and timeframe VoP\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , crop\n , threshold\n , hazard\n , value as vop\n from heat_stress_data\n where timeframe = ${selectScenarioAndTimeframe.timeframe}\n and scenario = ${selectScenarioAndTimeframe.scenario}\n and threshold = ${selectThreshold.threshold}\n)\n\nselect *\n from base\n where admin0_name = ${adminSelections.selectAdmin0.value}\n and admin1_name = ${adminSelections.selectAdmin1.value}\n and admin2_name = ${adminSelections.selectAdmin2.value}","pinned":false,"hidden":false,"mode":"sql","output":"dataHazardAdmin2","database":"var:db"},{"id":1693,"value":"---\n#### Helpers","pinned":false,"hidden":false,"mode":"md"},{"id":1692,"value":"helpersHazard = {\n return {\n colorDomain: ['crop', 'livestock'],\n colorRange: ['seagreen', 'sienna']\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2231,"value":"---\n### Dynamic Insights - Heat Stress in Numbers","pinned":false,"hidden":false,"mode":"md"},{"id":2230,"value":"data_selectedHazardCropType = T.tidy(\n data_hazardVoP,\n T.filter(d => \n d.scenario === selectScenarioAndTimeframe.scenario && \n d.timeframe === selectScenarioAndTimeframe.timeframe &&\n d.threshold == selectThreshold.threshold\n ),\n T.mutate({\n cropType: d => {\n if (riskDataTypes.crop.crop.includes(d.crop)) return 'crop';\n return 'other';\n },\n cropValue: d => parseFloat(d.crop) // Ensure cropValue is numeric\n }),\n T.arrange(['cropType', T.desc('vop')])\n);","pinned":false,"hidden":false,"mode":"ojs"},{"id":2229,"value":"// combined crop and livestock exposed for selection\ninsight_totalExposedVop = T.tidy(\n data_selectedHazardCropType,\n T.filter(d => d.cropType === \"crop\"),\n T.groupBy(['cropType', 'hazard'], [\n T.summarize({\n totalExposedVop: T.sum('vop'),\n totalExposedVopOver30: T.sum(d => d.cropValue >= 30 ? d.vop : 0), // Sum for crops over 30%\n totalExposedVopOver50: T.sum(d => d.cropValue >= 55 ? d.vop : 0) // Sum for crops over 50%\n })\n ])\n);","pinned":false,"hidden":false,"mode":"ojs"},{"id":2228,"value":"insight_topExp = {\n const cropsByVop = T.tidy(\n data_selectedHazardCropType,\n T.select([\"cropType\", \"crop\", \"vop\", \"hazard\"]),\n T.filter(d => d.cropType == \"crop\")\n );\n \n // Find the top crop by vop\n const topCrop = T.tidy(\n cropsByVop,\n T.sliceMax(1, \"vop\")\n )[0];\n \n // Return the combination, including topCrop only if it's not '30' or '50'\n return [topCrop].filter(d => d !== undefined);\n};","pinned":false,"hidden":false,"mode":"ojs"},{"id":2227,"value":"// total vop exposed by each hazard\ninsight_rankedHazardVopTotals = T.tidy(\n data_hazardVoP,\n T.groupBy(['hazard'], [\n T.summarize({\n totalVop: T.sum('vop')\n })\n ]),\n T.filter((d) => d.hazard !== 'any'), // remove combined hazard\n T.arrange(T.desc('totalVop'))\n \n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2897,"value":"---\n## BarChart - Loss of Safe Working Hours","pinned":false,"hidden":false,"mode":"md"},{"id":2999,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs"},{"id":2903,"value":"// data for selected hazard scenario, with total vop\ndata_hourlyStress = T.tidy(\n dataHourlySelected,\n T.leftJoin(dataHazardHourlyTotalSelected, {by: ['admin0_name', 'admin1_name', 'admin2_name', 'hour_day']})\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2970,"value":"dataHazardHourlyTotalSelected = T.tidy(\n dataHourlySelected,\n T.groupBy(\n [\n \"admin0_name\",\n \"admin1_name\",\n \"admin2_name\",\n \"threshold\",\n \"scenario\",\n \"timeframe\",\n \"hour_day\",\n ],\n [\n T.summarize({\n delta_total: T.mean(\"delta\")\n })\n ]\n )\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2905,"value":"// pick the admin dataset based on admin selection\ndataHourlySelected = {\n if (adminSelections.selectAdmin2.value) return dataHourlyAdmin2\n else if (adminSelections.selectAdmin1.value) return dataHourlyAdmin1\n else if (adminSelections.selectAdmin0.value) return dataHourlyAdmin0\n else return dataHourlyAdminAll\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2907,"value":"-- admin0 level hazard data\nwith base as (\n -- chosen scenario and timeframe VoP\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , hour_day\n , threshold\n , hazard\n , period\n , corrected_pop as corrected_pop_sum\n , delta_pop as delta_pop_mean\n , total_days as days_period\n , avg_count as delta\n from hourly_data\n where timeframe = ${selectScenarioAndTimeframe2.timeframe}\n and scenario = ${selectScenarioAndTimeframe2.scenario}\n and threshold = ${selectThreshold2.threshold}\n)\n\nselect *\n from base\n where admin1_name is null\n and admin0_name = ${adminSelections.selectAdmin0.value}","pinned":false,"hidden":false,"mode":"sql","output":"dataHourlyAdmin0","database":"var:db"},{"id":2952,"value":"-- admin1 level hazard data\nwith base as (\n -- chosen scenario and timeframe VoP\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , hour_day\n , threshold\n , hazard\n , period\n , corrected_pop as corrected_pop_sum\n , delta_pop as delta_pop_mean\n , total_days as days_period\n , avg_count as delta\n from hourly_data\n where timeframe = ${selectScenarioAndTimeframe2.timeframe}\n and scenario = ${selectScenarioAndTimeframe2.scenario}\n and threshold = ${selectThreshold2.threshold}\n)\n\nselect *\n from base\n where admin0_name = ${adminSelections.selectAdmin0.value}\n and admin1_name = ${adminSelections.selectAdmin1.value}\n and admin2_name is null","pinned":false,"hidden":false,"mode":"sql","output":"dataHourlyAdmin1","database":"var:db"},{"id":2941,"value":"-- admin2 level hazard data\nwith base as (\n -- chosen scenario and timeframe VoP\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , hour_day\n , threshold\n , hazard\n , period\n , corrected_pop as corrected_pop_sum\n , delta_pop as delta_pop_mean\n , total_days as days_period\n , avg_count as delta\n from hourly_data\n where timeframe = ${selectScenarioAndTimeframe2.timeframe}\n and scenario = ${selectScenarioAndTimeframe2.scenario}\n and threshold = ${selectThreshold2.threshold}\n)\n\nselect *\n from base\n where admin0_name = ${adminSelections.selectAdmin0.value}\n and admin1_name = ${adminSelections.selectAdmin1.value}\n and admin2_name = ${adminSelections.selectAdmin2.value}","pinned":false,"hidden":false,"mode":"sql","output":"dataHourlyAdmin2","database":"var:db"},{"id":2958,"value":"$3f","pinned":false,"hidden":false,"mode":"sql","output":"dataHourlyAdminAll","database":"var:db"},{"id":2932,"value":"// lookups for hazard plot\nhourlyPlotLookup = {\n return {\n names: {\n planting: Lang.toTitleCase(_lang(nbText.legends.seasonTypes.planting)),\n harvesting: Lang.toTitleCase(_lang(nbText.legends.seasonTypes.harvesting))\n },\n color: {\n domain: [\n Lang.toTitleCase(_lang(nbText.legends.seasonTypes.planting)),\n Lang.toTitleCase(_lang(nbText.legends.seasonTypes.harvesting)),\n ],\n range: [\n // red for both\n \"#4FB5B7\", \n \"#FCC42C\",\n ],\n // range: [\n // \"#808000\", // Olive Green\n // \"#B5651D\", // Light Brown\n // ],\n },\n hours: hourlyNames.reduce((acc, obj) => {\n acc[obj.hour_day] = obj.hourlyName;\n return acc;\n }, {})\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2936,"value":"// unique crops in the hazard data\nhazardHours = {\n const query = await db.query(`select hour_day\n , count(*) as count\n from hourly_data\n group by 1\n order by 1`);\n\n return query\n }","pinned":false,"hidden":false,"mode":"ojs"},{"id":2934,"value":"// formatting crop names\nhourlyNames = T.tidy(\n hazardHours,\n T.distinct(\"hour_day\"),\n T.select('hour_day'),\n T.mutate({\n // Convert to number for sorting\n hourlyNum: d => parseInt(d.hour_day, 10),\n // Determine the type based on the original string format (adjust as needed)\n type: d => /_/.test(d.hour_day) ? 'livestock' : 'hour_day',\n // Format the name\n hourlyName: d => {\n let hourlyName = d.hour_day\n if (/_/.test(d.hour_day)) hourlyName = hourlyName.replace('_', \" (\") + ')'\n return hourlyName\n }\n }),\n // Use the numeric version of hour for sorting, then remove it from the final result as it's no longer needed\n T.arrange(['type', 'hourlyNum']),\n T.select(['type', 'hour_day', 'hourlyName']) \n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3123,"value":"### Dynamic Insights - Loss of Safe Working Hours","pinned":false,"hidden":false,"mode":"md"},{"id":3127,"value":"data_selectedHourly = T.tidy(\n data_hourlyStress,\n T.filter(d => \n d.scenario === selectScenarioAndTimeframe2.scenario && \n d.timeframe === selectScenarioAndTimeframe2.timeframe \n ),\n T.mutate({\n hour_dayType: d => {\n if (hourlyDataTypes.hour_day.hour_day.includes(d.hour_day)) return 'hour_day';\n return 'other';\n },\n hour_dayValue: d => parseFloat(d.hour_day) // Ensure hour_dayValue is numeric\n }),\n T.select([\"hour_dayType\", \"hazard\", \"hour_day\", \"delta\", \"period\", \"days_period\", 'corrected_pop_sum', 'delta_pop_sum']),\n T.arrange(['hour_dayType', T.desc('delta')])\n);","pinned":false,"hidden":false,"mode":"ojs"},{"id":3125,"value":"// hourly exposition data\ninsight_totalExposedHourly = T.tidy(\n data_selectedHourly,\n T.filter(d => d.hour_dayType === \"hour_day\"),\n T.groupBy(['hour_dayType', 'hazard'], [\n T.summarize({\n totalExposedHourly: T.sum('delta'),\n period: T.first('period'),\n days_period: T.first('days_period'),\n corrected_pop_sum: T.sum('corrected_pop_sum'),\n delta_pop_sum: T.mean('delta_pop_sum')\n })\n ])\n);","pinned":false,"hidden":false,"mode":"ojs"},{"id":3151,"value":"insight_topHourly = {\n const hoursByDelta = T.tidy(\n data_selectedHourly,\n T.select([\"hour_dayType\", \"hour_day\", \"delta\"]),\n T.filter(d => d.hour_dayType == \"hour_day\")\n );\n \n // Find the top hour by delta\n const topHour_day = T.tidy(\n hoursByDelta,\n T.sliceMax(1, \"delta\")\n )[0];\n \n // Return the combination, including topCrop only if it's not '30' or '50'\n return [topHour_day].filter(d => d !== undefined);\n};","pinned":false,"hidden":false,"mode":"ojs"},{"id":1496,"value":"#### Helpers","pinned":false,"hidden":false,"mode":"md"},{"id":2221,"value":"icicle_alias = {\n const nameMap = {\n population: \"Total Population\",\n poverty0: \"Low Poverty\",\n poverty1: \"Moderate Poverty\",\n poverty2: \"High Poverty\",\n education0: \"0-1 Years of Education\",\n education1: \"1-5 Years of Education\",\n education2: \"5+ Years of Education\",\n gender0: \"Low Female Empowerment\",\n gender1: \"Moderate Female Empowerment\",\n gender2: \"High Female Empowerment\"\n };\n return nameMap;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2220,"value":"partition = (data) =>\n d3\n .partition()\n .padding(1)\n .size(narrow ? [height, width] : [width, height])(\n d3\n .hierarchy(data)\n .sum((d) => d.value)\n .sort((a, b) => b.value - a.value)\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":2219,"value":"icicle_color = d3\n .scaleOrdinal()\n .domain([\n \"population\",\n \"poverty2\",\n \"poverty1\",\n \"poverty0\",\n \"education2\",\n \"education1\",\n \"education0\",\n \"gender2\",\n \"gender1\",\n \"gender0\"\n ])\n .range([\"#efefef\", \"#ec5a47\", \"#fc8a34\", \"#f4bb21\", \"#f4bb21\", \"#fc8a34\", \"#ec5a47\", \"#f4bb21\", \"#fc8a34\", \"#ec5a47\"])","pinned":false,"hidden":false,"mode":"ojs"},{"id":2218,"value":"targetHeight = 350","pinned":false,"hidden":false,"mode":"ojs"},{"id":2217,"value":"narrowHeight = 600","pinned":false,"hidden":false,"mode":"ojs"},{"id":2216,"value":"height = narrow ? narrowHeight : targetHeight","pinned":false,"hidden":false,"mode":"ojs"},{"id":2215,"value":"narrow = width <= 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":2214,"value":"segmentX = d => (narrow ? d.y0 : d.x0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2213,"value":"segmentY = d => (narrow ? d.x0 : d.y0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2212,"value":"segmentWidth = d => (narrow ? d.y1 - d.y0 : d.x1 - d.x0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2211,"value":"segmentHeight = d => (narrow ? d.x1 - d.x0 : d.y1 - d.y0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2210,"value":"$40","pinned":false,"hidden":false,"mode":"ojs"},{"id":2209,"value":"breadcrumbWidth = 200","pinned":false,"hidden":false,"mode":"ojs"},{"id":2208,"value":"breadcrumbHeight = 35","pinned":false,"hidden":false,"mode":"ojs"},{"id":2207,"value":"// Generate a string that describes the points of a breadcrumb SVG polygon.\nfunction breadcrumbPoints(d, i) {\n const tipWidth = 10;\n const points = [];\n points.push(\"0,0\");\n points.push(`${breadcrumbWidth},0`);\n points.push(`${breadcrumbWidth + tipWidth},${breadcrumbHeight / 2}`);\n points.push(`${breadcrumbWidth},${breadcrumbHeight}`);\n points.push(`0,${breadcrumbHeight}`);\n if (i > 0) {\n // Leftmost breadcrumb; don't include 6th vertex.\n points.push(`${tipWidth},${breadcrumbHeight / 2}`);\n }\n return points.join(\" \");\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1282,"value":"### Tabular data\n- **ag_workforce_data**: ag workforce data showing current and projected ag populations under different scenarios and for different years. File: baseline_df_data.parquet.\n- **heat_stress_data**: number of ag workders facing different sums of days on a year where WBGT values exceed 30 degrees. File: heat_stress_data.parquet.\n- **hourly_data**: percent of hours across seasons (harvesting, planting) that exceed safe WBGT thresholds. File: hourly_data.parquet.\n- **population**: population data by admin levels\n - `population/population_long.parquet`","pinned":false,"hidden":false,"mode":"md"},{"id":8,"value":"db = {\n return DuckDBClient.of({\n population: FileAttachment(\"population_long.parquet\"),\n vop_ha: FileAttachment(\"exposure_adm_sum.parquet\"),\n ag_workforce_data: FileAttachment(\"baseline_df_data@16.parquet\"),\n heat_stress_data: FileAttachment(\"heat_stress_data@7.parquet\"),\n hourly_data: FileAttachment(\"hourly_data@20.parquet\"),\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":548,"value":"### Geographic data\nGeo files were converted to TopoJSON and reduced in complexity before uploading to the notebook, see [Simplify large spatial files](https://observablehq.com/d/258c68ee969e8ed5?collection=@periscopic/ab-atlas) notebook for method.\n- **admin0**: broadest level, country boundaries\n - `boundaries/atlas-region_admin0_harmonized.geojson`\n- **admin1**: one level down from `admin0`, regions within each `admin0` region\n - `boundaries/atlas-region_admin1_harmonized.geojson`\n- **admin2**: lowest level, subregions of every `admin1` region\n - `boundaries/atlas-region_admin2_harmonized.geojson`","pinned":false,"hidden":false,"mode":"md"},{"id":557,"value":"boundaries = {\n const input0 = await FileAttachment(\"atlas-region_admin0_harmonized.json\").json()\n const input1 = await FileAttachment(\"atlas-region_admin1_harmonizedV2@1.json\").json()\n const input2 = await FileAttachment(\"atlas-region_admin2_harmonizedV2.json\").json()\n\n const geo = {\n admin0: topojson.feature(input0, input0.objects[\"atlas-region_admin0_harmonized\"]),\n admin1: topojson.feature(input1, input1.objects[\"atlas-region_admin1_harmonizedV2\"]),\n admin2: topojson.feature(input2, input2.objects[\"atlas-region_admin2_harmonizedV2\"]),\n }\n return geo\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1476,"value":"---\n### Risk data grouping\n*Lookups for risk data binning, such as hazards and crop types*","pinned":false,"hidden":false,"mode":"md"},{"id":1475,"value":"// lookup for risk data type groupings\n// used by inputs and for grouping up data\nriskDataTypes = ({\n crop: {\n crop: [\n \"10\",\n \"15\",\n \"20\",\n \"25\",\n \"30\",\n \"35\",\n \"40\",\n \"45\",\n \"50\",\n \"55\",\n \"60\",\n \"65\",\n \"70\",\n \"75\",\n \"80\",\n \"85\",\n \"90\",\n \"95\"\n ],\n livestock: [\n \"cattle_highland\",\n \"cattle_tropical\",\n \"goats_highland\",\n \"goats_tropical\",\n \"pigs_highland\",\n \"pigs_tropical\",\n \"poultry_highland\",\n \"poultry_tropical\",\n \"sheep_highland\",\n \"sheep_tropical\"\n ]\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":3129,"value":"// lookup for hourly data type groupings\n// used by inputs and for grouping up data\nhourlyDataTypes = ({\n hour_day: {\n hour_day: [\n 0,\n 1,\n 2,\n 3,\n 4,\n 5,\n 6,\n 7,\n 8,\n 9,\n 10,\n 11,\n 12,\n 13,\n 14,\n 15,\n 16,\n 17,\n 18,\n 19,\n 20,\n 21,\n 22,\n 23\n ]\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1327,"value":"---\n### Dynamic insights\n*functions for formatting results*","pinned":false,"hidden":false,"mode":"md"},{"id":1326,"value":"function filterByAdminNames(data) {\n // filter down data by combined selected admin0/admin1/admin2 Admin Selections\n // pass data from query, use tidyjs to filter by admin selection\n const result = T.tidy(\n data,\n T.filter((d) => {\n return d.admin0_name == adminSelections.selectAdmin0.value\n && d.admin1_name == adminSelections.selectAdmin1.value\n && d.admin2_name == adminSelections.selectAdmin2.value\n })\n )\n return result\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1325,"value":"// wrapper for format functions, show chosen default\nfunction formatWithDefault({\n value=1000, \n format=d=>d, \n defaultValue=\"---\", \n debug=false\n}={}) {\n // apply a formatting function to a value\n // return default value if undefined or null\n if (!(value === null || value === undefined)) {\n return format(value)\n } else {\n return defaultValue\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1324,"value":"---\n### Data functions: format and transform\n*apply formatting to/transform a value*\n\n- Reference: [Intl.NumberFormat()](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Intl/NumberFormat/NumberFormat)","pinned":false,"hidden":false,"mode":"md"},{"id":1799,"value":"**Transforms**","pinned":false,"hidden":false,"mode":"md"},{"id":1798,"value":"// transform non-number to percent value\ntransformPercent = (d) => {\n if (d === undefined || d === null) return d\n else return d * 100\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1797,"value":"**Formatting**","pinned":false,"hidden":false,"mode":"md"},{"id":1796,"value":"// format non-number as percent\nformatPercentTenth = (d) => {\n if (d === undefined || d === null) return d\n else return d3.format('.1%')(d)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2167,"value":"// format non-number as percent\nformatPercentWhole = (d) => {\n if (d === undefined || d === null) return d\n else return d3.format('.0%')(d)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":449,"value":"// format US currency\nformatUSD = new Intl.NumberFormat(\"en-US\", {\n notation: \"compact\",\n compactDisplay: \"short\",\n style: \"currency\",\n currency: \"usd\"\n}).format","pinned":false,"hidden":false,"mode":"ojs"},{"id":1322,"value":"// format number, long notation\nformatNumCompactLong = ({ locale = \"en-US\" } = {}) =>\n new Intl.NumberFormat(locale, {\n notation: \"compact\",\n compactDisplay: \"long\",\n unitDisplay: \"long\"\n }).format","pinned":false,"hidden":false,"mode":"ojs"},{"id":1794,"value":"// format number, short notation\nformatNumCompactShort = ({ locale = \"en-US\" } = {}) =>\n new Intl.NumberFormat(locale, {\n notation: \"compact\",\n compactDisplay: \"short\"\n }).format","pinned":false,"hidden":false,"mode":"ojs"},{"id":1321,"value":"---\n### Querying data\n*functions for querying data*","pinned":false,"hidden":false,"mode":"md"},{"id":693,"value":"function getUniqueValues(col, tbl, db) {\n // return unique values of from db tbl as a list\n return db.query(`select distinct ${col} from ${tbl}`).then(x => x.map(d => d[col]))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1242,"value":"function bindTabularToGeo({\n data = [],\n dataBindColumn = 'dataBindColumn',\n geoData = [],\n geoDataBindColumn = 'geoDataBindColumn'\n}) {\n // bind data to geojson\n const index = new Map(data.map(d => [d[dataBindColumn], d])) // map data by dataBindColumn\n const geojson = JSON.parse(JSON.stringify(geoData)); // do a copy, rather than mutate\n // join up data to geojson\n for (const f of geojson.features) {\n f.properties.data = index.get(f.properties[geoDataBindColumn]);\n }\n return geojson;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":264,"value":"***\n## Imports\n*External imports*","pinned":false,"hidden":false,"mode":"md"},{"id":2500,"value":"import {toc} from \"@nebrius/indented-toc\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2498,"value":"import {T} from \"@pbeshai/tidyjs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":3742,"value":"makeQuartoFlag = (url) => {\n const baseText = _lang(\n {\n en: \"New version available! This notebook has been rebuilt in Quarto for a better experience:\",\n fr: \"Nouvelle version disponible ! Ce carnet a été reconstruit avec Quarto pour une meilleure expérience:\"\n }\n )\n const openText = _lang(\n {\n en: \"Open Updated Notebook\",\n fr: \"Ouvrir le carnet mis à jour\"\n }\n )\n \n return htl.html`\n

\n ${baseText} ${openText} →\n

\n `\n}","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W41","stdlib":"1","titling":"auto"}