1d:{"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":"$1f","pinned":false,"hidden":false,"mode":"ojs"},{"id":1260,"value":"$20","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":"$21","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":"$22","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":"$23","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":"$24","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":"$25","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":"$26","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":"$27","pinned":false,"hidden":false,"mode":"ojs"},{"id":2175,"value":"**Table of Contents**","pinned":false,"hidden":false,"mode":"md"},{"id":2174,"value":"$28","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":"$29","pinned":false,"hidden":false,"mode":"ojs"},{"id":1250,"value":"$2a","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":"$2b","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":"$2c","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":"$2d","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":"$2e","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":"$2f","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":"$30","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":"$W31","stdlib":"1"}