1d:{"title":"Evaluate Climate Risks","cells":[{"id":2683,"value":"{\n const imgUrl = _lang(nbText.frontMatter.heroImage.url);\n return htl.html`

${notebookTitle}

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2682,"value":"// pretty view of language toggle\nviewof prettyLanguageView = {\n return Inputs.bind(\n Inputs.radio(languages, {\n label: _lang(nbText.supportNbText.labels.language),\n format: (d) => d.label\n }),\n viewof language\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2192,"value":"tocOneliner({\n heading: `${_lang(nbText.supportNbText.labels.tocTitle)}`,\n skip: [notebookTitle, \"Appendix\"], \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2463,"value":"{\n const title = _lang(nbText.overview.header)\n return md`# ${title}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1372,"value":"{\n const text = _lang(nbText.overview.blocks.opener)\n return md`${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1267,"value":"{\n const text = _lang(nbText.africaMap.blocks.h1)\n return md`# ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2677,"value":"{\n const template = _lang(nbText.africaMap.blocks.opener)\n const items = [\n {name: 'vop_blurb', value: _lang(nbText.vopNoteMd.blurb)}\n ]\n const format = Lang.reduceReplaceTemplateItems(template, items)\n return md`${format}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2021,"value":"$1f","pinned":false,"hidden":false,"mode":"ojs"},{"id":1767,"value":"$20","pinned":false,"hidden":false,"mode":"ojs"},{"id":3801,"value":"viewof disaggFilter = Inputs.radio(\n [\"All\", \"Men\", \"Women\"],\n {label: \"Disaggregate By Gender\", value: \"All\"}\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1260,"value":"/////////////////////////////\n// FINAL VIEW\n/////////////////////////////\n\ndualMapView = html`\n

\n\n

\n ${plotChoroplethGeoImpact}\n

\n\n

\n ${plotChoroplethGeoImpact1}\n

\n\n

\n${populationSummaryCard}\n

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":4513,"value":"$21","pinned":false,"hidden":false,"mode":"ojs"},{"id":2823,"value":"buildInlineDownloadButton(mapDataGeoImpact.features.map(d => d.properties), _lang(download_translation), `${selectGeoDataType.key}.csv`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1341,"value":"headerQuickInsightsGeoImpact =\n{\n const template = _lang(nbText.africaMap.insights.title)\n const items = [\n {name: \"insight_string\", value: _lang(nbText.supportNbText.labels.quickInsights)},\n {name: \"admin_selection\", value: getAdminSelection().label},\n ]\n const format = Lang.reduceReplaceTemplateItems(template, items)\n return md`### ${format}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1874,"value":"$22","pinned":false,"hidden":false,"mode":"ojs"},{"id":1367,"value":"{\n const text = _lang(nbText.climateRisks.intro.h1)\n return md`# ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1366,"value":"{\n const adminSelection = getAdminSelectionLabelWithParen({\n admin0Label: Lang.toSentenceCase(\n _lang(\n td.admin0_name.values?.[getAdminSelectionAdmin0().value ?? \"SSA\"][\"article2\"]\n )\n ),\n adminSublabel: getAdminSelection().label\n });\n const format = Lang.reduceReplaceTemplateItems(\n _lang(nbText.climateRisks.intro.opener),\n [{ name: \"admin_selection\", value: adminSelection }]\n );\n return md`${format}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2669,"value":"{\n const text = _lang(nbText.climateRisks.compoundHazards.h2)\n return md`## ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2668,"value":"{\n const text = Lang.reduceReplaceTemplateItems(\n _lang(nbText.climateRisks.compoundHazards.opener),\n [\n {name: \"vop_note\", value: _lang(nbText.vopNoteMd.blurb)},\n {name: \"admin_selection\", value: getAdminSelection().label}\n ]\n )\n return md`${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"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 Inputs.bind(\n Inputs.select(dataAdmin3, { label: adminRegions.labels.admin3, format: x => x.label }),\n viewof selectAdmin3\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 historicLabel = `${_lang(nbText.climateRisks.compoundHazards.inputs.dropdownScenario.historic)}: 1995-2014`\n\n const data = [\n {label: historicLabel, scenario: 'historic', timeframe: 'historic'},\n {label: 'SSP245: 2021-2040', scenario: 'ssp245', timeframe: '2021_2040'},\n {label: 'SSP245: 2041-2060', scenario: 'ssp245', timeframe: '2041_2060'},\n {label: 'SSP585: 2021-2040', scenario: 'ssp585', timeframe: '2021_2040'},\n {label: 'SSP585: 2041-2060', scenario: 'ssp585', timeframe: '2041_2060'},\n ]\n \n return Inputs.select(data, {\n label: _lang(nbText.climateRisks.compoundHazards.inputs.dropdownScenario.label),\n format: x => x.label,\n value: data.find(d => d.timeframe === 'historic')\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4418,"value":"// viewof ChartType = Inputs.radio(\n// [\"bar\", \"line\"],\n// {\n// label: \"Chart Type\",\n// format: (d) => d === \"bar\" ? \"Stacked Bar Chart\" : \"Line Chart\",\n// value: \"bar\"\n// }\n// );\nviewof ChartType = Inputs.radio(\n [\"bar\", \"line\"],\n {\n label: \"Chart Type\",\n format: (d) => d === \"bar\" ? \"Stacked Bar Chart\" : \"Line Chart\",\n value: \"bar\"\n }\n);\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":2262,"value":"$23","pinned":false,"hidden":false,"mode":"ojs"},{"id":4542,"value":"$24","pinned":false,"hidden":false,"mode":"ojs"},{"id":3006,"value":"$25","pinned":false,"hidden":false,"mode":"ojs"},{"id":2800,"value":"buildInlineDownloadButton(data_hazardVoP, _lang(download_translation), \"CropClimateHazards.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":2665,"value":"{\n const text = _lang(nbText.climateRisks.hazardImpact.h1)\n return md`## ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2664,"value":"{\n const text = _lang(nbText.climateRisks.hazardImpact.intro)\n return md`${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2259,"value":"// picking hazard\nviewof selectHazard = {\n const data = new Map(\n Object.keys(hazardPlotLookup.names)\n .filter(d => d !== 'no hazard') // remove no hazard option\n .map(d => [hazardPlotLookup.names[d], d])\n );\n return Inputs.select(data, {\n value: 'dry',\n label: _lang(nbText.climateRisks.hazardImpact.inputs.dropdownHazard.label)\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2662,"value":"{\n const template = _lang(nbText.climateRisks.hazardImpact.plots.crops.header)\n const items = [{name: \"hazard_string\", value: hazardPlotLookup.names[selectHazard].toLowerCase()}]\n const format = Lang.reduceReplaceTemplateItems(template, items)\n return md`### ${format}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2257,"value":"chart_35 = {\n const data = data_hazardVoP.filter((d) => {\n return (\n d.hazard == selectHazard &&\n d.vop !== 0 &&\n riskDataTypes.crop.crop.includes(d.crop)\n ); // lookup crop type\n });\n const marginLeft = _lang({en: 110, fr: 120});\n return makeTopCropBarChart(data, {marginLeft});\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4587,"value":"$26","pinned":false,"hidden":false,"mode":"ojs"},{"id":2808,"value":"buildInlineDownloadButton(\n data_hazardVoP.filter((d) => {\n return (\n d.hazard == selectHazard &&\n d.vop !== 0 &&\n riskDataTypes.crop.crop.includes(d.crop)\n );\n }), _lang(download_translation), `CropRisk_${selectHazard}.csv`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2660,"value":"{\n const template = _lang(nbText.climateRisks.hazardImpact.plots.livestock.header)\n const items = [{name: \"hazard_string\", value: hazardPlotLookup.names[selectHazard].toLowerCase()}]\n const format = Lang.reduceReplaceTemplateItems(template, items)\n return md`### ${format}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2255,"value":"chart_38 = {\n const data = data_hazardVoP.filter((d) => {\n return (\n d.hazard == selectHazard &&\n d.vop !== 0 &&\n riskDataTypes.crop.livestock.includes(d.crop)\n ); // lookup crop type\n });\n const marginLeft = _lang({en: 110, fr: 150});\n return makeTopCropBarChart(data, {marginLeft});\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4596,"value":"$27","pinned":false,"hidden":false,"mode":"ojs"},{"id":2818,"value":"buildInlineDownloadButton(\n data_hazardVoP.filter((d) => {\n return (\n d.hazard == selectHazard &&\n d.vop !== 0 &&\n riskDataTypes.crop.livestock.includes(d.crop)\n );\n }), _lang(download_translation), `LivestockRisk_${selectHazard}.csv`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2658,"value":"{\n const format = Lang.reduceReplaceTemplateItems(\n _lang(nbText.climateRisks.hazardImpact.insights.title),\n [\n { name: \"insight_string\", value: _lang(nbText.supportNbText.labels.quickInsights) },\n { name: \"admin_selection\", value: getAdminSelection().label },\n { name: \"scenario\", value: selectScenarioAndTimeframe.label }\n ]\n );\n return md`### ${format}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2251,"value":"$28","pinned":false,"hidden":false,"mode":"ojs"},{"id":2250,"value":"$29","pinned":false,"hidden":false,"mode":"ojs"},{"id":1363,"value":"{\n const text = _lang(nbText.adaptiveCapacities.h1)\n return md`# ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2654,"value":"{\n const adminSelection = getAdminSelectionLabelWithParen({\n admin0Label: _lang(\n td.admin0_name.values?.[getAdminSelectionAdmin0().value ?? \"SSA\"][\"article3\"]\n ),\n adminSublabel: getAdminSelection().label\n });\n const format = Lang.reduceReplaceTemplateItems(\n _lang(nbText.adaptiveCapacities.intro),\n [{name: \"admin_selection\", value: adminSelection}]\n )\n return md`${format}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1996,"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 Inputs.bind(\n Inputs.select(dataAdmin3, { label: adminRegions.labels.admin3, format: x => x.label }),\n viewof selectAdmin3\n )\n ],\n {\n template: adminFormTemplate\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1821,"value":"// define choices for the data value\nviewof selectAcDataTypeNew = {\n const options = dataLayerOptionsAdaptiveCapacities;\n \n return Inputs.radio(options, {\n width: 300,\n label: _lang(nbText.adaptiveCapacities.inputs.mapLayer.label),\n format: (x) => x.label,\n value: options.find((t) => t.key === \"pov\"),\n sort: true\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4083,"value":"viewof genderFilter = Inputs.select([\"All\", \"Men\", \"Women\"], {label: \"Gender Disaggregation (for Poverty and Education)\", value: \"All\"});","pinned":false,"hidden":false,"mode":"ojs"},{"id":4429,"value":"viewof plotChoroplethAdaptiveCapacity1ChartType = {return(\n Inputs.radio(\n [\"map\", \"bar\"],\n {\n label: \"Chart Type\",\n format: (d) => d === \"map\" ? \"Map\" : \"Bar Chart\",\n value: \"map\"\n }\n )\n)}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1817,"value":"$2a","pinned":false,"hidden":false,"mode":"ojs"},{"id":4532,"value":"$2b","pinned":false,"hidden":false,"mode":"ojs"},{"id":2787,"value":"buildInlineDownloadButton(dataAdaptiveCapacity, _lang(download_translation), \"AdaptiveCapacityMap\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":2651,"value":"{\n const format = Lang.reduceReplaceTemplateItems(\n _lang(nbText.adaptiveCapacities.insights.title),\n [\n { name: \"insight_string\", value: _lang(nbText.supportNbText.labels.quickInsights) },\n { name: \"admin_selection\", value: getAdminSelection().label },\n ]\n );\n return md`## ${format}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2748,"value":"$2c","pinned":false,"hidden":false,"mode":"ojs"},{"id":2649,"value":"{\n const text = _lang(nbText.adaptiveCapacities.delvingDeeper.h2)\n return md`## ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2322,"value":"{\n const text = _lang(nbText.adaptiveCapacities.delvingDeeper.intro)\n return md`${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2247,"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 Inputs.bind(\n Inputs.select(dataAdmin3, { label: adminRegions.labels.admin3, format: x => x.label }),\n viewof selectAdmin3\n )\n ],\n {\n template: adminFormTemplate\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2246,"value":"$2d","pinned":false,"hidden":false,"mode":"ojs"},{"id":2382,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs"},{"id":4605,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":2776,"value":"buildInlineDownloadButton(icicle_raw, _lang(download_translation), \"AdaptiveCapacityIcicle\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":1358,"value":"{\n const text = _lang(nbText.summary.h1)\n return md`# ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1356,"value":"dynamicSummaryCell = {\n let dynamicSummary = \"\";\n // add filter to do nothing in case where no admin0 is selected\n if (adminSelections.selectAdmin0.value !== null) {\n dynamicSummary = Lang.reduceReplaceTemplateItems(\n _lang(nbText.summary.dynamicSummarylist),\n [{ name: \"markdownList\", value: dynamicSummaryMarkdown }]\n );\n }\n const admin0 = _lang(\n td.admin0_name.values?.[getAdminSelectionAdmin0().value ?? 'SSA'][\"article3\"]\n );\n const intro = Lang.reduceReplaceTemplateItems(\n _lang(nbText.summary.blocks.dynamicSummary.intro),\n [{ name: \"admin0\", value: admin0 }]\n );\n\n return md`${intro} ${dynamicSummary}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1634,"value":"{\n const text = _lang(nbText.summary.blocks.closer)\n return md`${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2642,"value":"{\n const text = _lang(nbText.methods.h1)\n return md`# ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2641,"value":"{\n const text = _lang(nbText.methods.section1)\n return md`## ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2640,"value":"{\n const text = _lang(nbText.methods.section1.subsections);\n return md`${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2639,"value":"{\n const text = _lang(nbText.methods.section2)\n return md`## ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2638,"value":"{\n const text = _lang(nbText.methods.section2.subsections)\n return md`${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":49,"value":"***\n# Appendix\nThis large section includes all the cells that power the notebook.","pinned":false,"hidden":false,"mode":"md"},{"id":2244,"value":"toc()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1258,"value":"---\n## Work by Topic\n*Cells that power different sections*","pinned":false,"hidden":false,"mode":"md"},{"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":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 = \"Evaluate Climate Risks\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1745,"value":"// info for the admin selectors - UPDATED\nadminRegions = {\n return {\n labels: {\n admin0: Lang.toSentenceCase(\n _lang(nbText.supportNbText.words.country.singular)\n ),\n admin1: Lang.toSentenceCase(\n _lang(nbText.supportNbText.words.region.singular)\n ),\n admin2: Lang.toSentenceCase(\n _lang(nbText.supportNbText.words.subregion.singular)\n ),\n admin3: Lang.toSentenceCase(\n _lang(nbText.supportNbText.words.woreda.singular)\n ),\n },\n allLabels: {\n admin1: _lang(nbText.supportNbText.labels.allRegions),\n admin2: _lang(nbText.supportNbText.labels.allSubregions),\n admin3: _lang(nbText.supportNbText.labels.allWoredas)\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.selectAdmin3.value) return adminRegions.labels.admin3\n if (selections.selectAdmin2.value) return adminRegions.labels.admin3\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":2180,"value":"// width of the maps\nmapWidth = 625","pinned":false,"hidden":false,"mode":"ojs"},{"id":2634,"value":"**Language and notebook text**","pinned":false,"hidden":false,"mode":"md"},{"id":2633,"value":"import { Lang } from \"7d46679f7d0d917e\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2632,"value":"Lang ","pinned":false,"hidden":false,"mode":"ojs"},{"id":2631,"value":"languages = [\n { key: \"en\", label: \"English\", locale: 'en-US' },\n { key: \"am\", label: \"አማርኛ\", locale: 'am-ET' },\n {key: \"or\", label: \"Afaan Oromoo\", locale: 'or-ET'},\n {key: \"ti\", label: \"ትግርኛ\", locale: 'ti-ET'},\n {key: \"so\", label: \"Soomaali\", locale: 'so-ET'},\n {key: \"af\", label: \"Qafar af\", locale: 'af-ET'}\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":2630,"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":2629,"value":"// helper shorthand for Lang text-getting\n_lang = Lang.lg(language.key)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2628,"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":2626,"value":"// data translation values\ntd = {\n let data = await FileAttachment(\"abAtlas-td-translation-data-v3 (4)-2 (3)@1.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":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":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":2779,"value":"downloadButtonCSS = htl.html`\nDownload Button CSS\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2175,"value":"**Table of Contents**","pinned":false,"hidden":false,"mode":"md"},{"id":2174,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":1812,"value":"**Color Scales**","pinned":false,"hidden":false,"mode":"md"},{"id":4621,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":4676,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":2627,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":3046,"value":"// get admin3 options based on admin2 selection - ETHIOPIA ONLY\ndataAdmin3 = {\n if (!selectAdmin2.value || !selectAdmin0.value || selectAdmin0.value !== \"Ethiopia\") {\n return [{ label: \"All Woredas\", value: null }];\n }\n \n // Only get woredas for Ethiopia\n const data = admin3_cleaned.features\n .filter(d => \n d.properties.admin0_name === \"Ethiopia\" &&\n d.properties.admin1_name === selectAdmin1.value &&\n d.properties.admin2_name === selectAdmin2.value\n )\n .map(d => d.properties.admin3_name);\n \n const allLabel = {\n label: adminRegions.allLabels.admin3,\n value: null\n }\n \n const uniqueWoredas = [...new Set(data)].sort();\n \n return [allLabel, ...uniqueWoredas.map(d => {\n return {\n label: d,\n value: d,\n }\n })];\n}","pinned":false,"hidden":false,"mode":"ojs"},{"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 },\n unknown: \"#ccc\"\n }\n}","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 = 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 ? globalSelection.label : _lang(td.admin0_name.values?.[d]?.general),\n value: 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 const data = await geo_db.query(`SELECT DISTINCT admin1_name FROM admin1_geom WHERE admin0_name = '${selectAdmin0.value}'`)\n // add blank value\n const allLabel = {\n label: adminRegions.allLabels.admin1,\n value: null\n }\n return [allLabel, ...data.map(d => {\n return {\n label: d.admin1_name,\n value: d.admin1_name,\n }\n })].map(d => {\n return {label: d.label, value: d.value}\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1251,"value":"$35","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 const data = await geo_db.query(`SELECT DISTINCT admin2_name FROM admin2_geom WHERE admin0_name = '${selectAdmin0.value}' AND admin1_name = '${cleanAdminInput_SQL(selectAdmin1.value)}'`)\n // add blank value\n const allLabel = {\n label: adminRegions.allLabels.admin2,\n value: null\n }\n return [allLabel, ...data.map(d => {\n return {\n label: d.admin2_name,\n value: d.admin2_name,\n }\n })].map(d => {\n return {label: d.label, value: d.value}\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1265,"value":"viewof selectAdmin0 = Inputs.select(dataAdmin0, {\n label: adminRegions.labels.admin0,\n format: x => x.label,\n value: dataAdmin0.find(x => x.label === \"Ethiopia\") // Set default to Ethiopia\n})","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":3090,"value":"viewof selectAdmin3 = Inputs.select(dataAdmin3, {label: adminRegions.labels.admin3, format: x => x.label})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1253,"value":"adminSelections = ({\n selectAdmin0: selectAdmin0,\n selectAdmin1: selectAdmin1,\n selectAdmin2: selectAdmin2,\n selectAdmin3: selectAdmin3\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":2620,"value":"getAdminSelectionLabelWithParen = ({\n selections = adminSelections,\n admin0Label,\n adminSublabel\n} = {}) => {\n // return admin0 selection and admin1/admin2 selection if chosen (in parentheses)\n if (selections.selectAdmin1.value === null) {\n return admin0Label;\n } else {\n return `${admin0Label} (${adminSublabel})`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3188,"value":"// A helper to get all existing admin3_name units for a given admin2_name\nadmin3NamesByAdmin2 = {\n // Add dependency to make it reactive\n void boundaries;\n \n const map = new Map();\n if (boundaries.admin3 && boundaries.admin3.features) {\n for (const f of boundaries.admin3.features) {\n const a2_name = f.properties.admin2_name;\n const a3_name = f.properties.admin3_name;\n \n if (a2_name && a3_name) {\n if (!map.has(a2_name)) {\n map.set(a2_name, new Set());\n }\n map.get(a2_name).add(a3_name);\n }\n }\n }\n return map;\n}","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 }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1336,"value":"$36","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.label\n\n return a0\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,\n selections.selectAdmin1,\n selections.selectAdmin2\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":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":2743,"value":"dataPopulation = async (admin_query) => {\n return await db.query(`\nselect * \nfrom population\n${admin_query}\n`)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1292,"value":"// // total VoP data\ndataTotalVoP = async (admin_query) => {\nreturn await db.query(`\nselect admin0_name\n , admin1_name\n , admin2_name\n , SUM(value) as vop_total\n from vop\n ${admin_query}\n group by admin0_name, admin1_name, admin2_name\n order by admin0_name, admin1_name, admin2_name\n`)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3792,"value":"mockWoredaData = {\n return await FileAttachment(\"mock_woreda_data@7.csv\").csv({ typed: true });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4077,"value":"mockAdaptiveCapacityData = {\n return await FileAttachment(\"mock_adaptive_capacity_data@1.csv\").csv({ typed: true });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3233,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":3519,"value":"// Add mock VOP data to admin3 features\nfunction addMockVopDataToAdmin3(admin3Data) {\n if (!admin3Data || !admin3Data.features) return admin3Data;\n \n // Create a copy to avoid modifying the original\n const enhancedData = JSON.parse(JSON.stringify(admin3Data));\n \n enhancedData.features.forEach(feature => {\n if (feature.properties.data) {\n // Generate mock VOP data based on rural population\n const ruralPop = feature.properties.data.rural_pop || 0;\n const totalPop = feature.properties.data.total_pop || ruralPop;\n \n // VOP is roughly proportional to population with some variation\n // Using a reasonable per-capita VOP estimate for Ethiopia\n const vopPerCapita = 150 + (Math.random() * 100); // $150-250 per capita\n const vopTotal = totalPop * vopPerCapita;\n \n // Add mock VOP data to the embedded data\n feature.properties.data.vop_total = vopTotal;\n }\n });\n \n return enhancedData;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3581,"value":"// Alternative: Simple scale calculation\nfunction calculateOptimalScale(bounds, width, height) {\n const [[minLon, minLat], [maxLon, maxLat]] = bounds;\n const lonRange = maxLon - minLon;\n \n // Simple heuristic: for Ethiopia regions, these scales usually work well\n if (lonRange < 0.5) return 50000; // Very small area\n if (lonRange < 1.0) return 30000; // Small area \n if (lonRange < 2.0) return 20000; // Medium area\n return 15000; // Larger area\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3522,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":3834,"value":"{\n const vulSample = await db.query(\"SELECT * FROM vul_ac2 LIMIT 5\");\n const popSample = await db.query(\"SELECT * FROM population LIMIT 5\");\n return { vulSample, popSample };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1250,"value":"$39","pinned":false,"hidden":false,"mode":"ojs"},{"id":4734,"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":2739,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs"},{"id":1452,"value":"// total harvested area\ndynInsightGeo_haTotals = {\n let admin_query = insight_adminQuery\n \n return await db.query(`\nwith tblHA as (\n -- total VoP and harvested area\n SELECT admin0_name, admin1_name, admin2_name, SUM(value) AS ha_total\n FROM ha\n ${admin_query}\n AND exposure = 'ha'\n GROUP 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 , ha_total\n from (\n select sum(ha_total) as ha_total\n from tblHA\n )\n \n union\n \n select * \n from tblHA\n \n order by 1, 2, 3\n)\n`)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1451,"value":"dynInsightGeo_vopTotals = {\n let admin_query = insight_adminQuery\n\n \n return db.query(`\n-- total value of production\nwith tbl as (\n -- total VoP and harvested area\n SELECT admin0_name, admin1_name, admin2_name, SUM(value) AS vop_total\n FROM vop\n ${admin_query}\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 , vop_total\n from (\n select sum(vop_total) as vop_total\n from tbl\n )\n \n union\n \n select * \n from tbl\n \n order by 1, 2, 3\n)\n`)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1450,"value":"dynInsightGeo_population = {\n let admin_query = insight_adminQuery\nreturn await db.query(`\nwith tbl as (\n -- population data\n select admin0_name\n , admin1_name\n , admin2_name\n , total_pop\n , rural_pop\n from population\n ${admin_query}\n order by admin0_name\n , admin1_name\n , admin2_name\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 , *\n from (\n select sum(total_pop) as total_pop\n , sum(rural_pop) as rural_pop\n from tbl\n )\n \n union\n \n select *\n from tbl\n \n order by 1, 2, 3\n)\n`)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2735,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs"},{"id":2734,"value":"$3e","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":"$3f","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 is a large value that dwarfs other crop values. We exclude this from the chart.","pinned":false,"hidden":false,"mode":"md"},{"id":2239,"value":"Below is a table of the explanations of every hazard component. The `any` hazard is the combination of all of the below hazards.\n\n| hazard | description |\n| --- | --- |\n| dry | risk of dry hazard occurring alone |\n| heat | risk of heat hazard occurring alone |\n| wet | risk of wet hazard occurring alone |\n| dry+heat | risk of dry and heat hazard occurring together |\n| dry+wet | risk of dry and wet hazard occurring together |\n| heat+wet | risk of heat and wet hazard occurring together |\n| dry+heat+wet | risk of dry and heat and wet hazard occurring together |\n| No hazard | no hazard applied\n\n*If there are zeros for individual hazards then it means it always occurs in combination with another hazard and does not occur alone.*","pinned":false,"hidden":false,"mode":"md"},{"id":2414,"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', 'admin3_name', 'crop']}),\n T.filter((d) => d.crop !== 'generic') // remove generic \n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2413,"value":"dataHazardVoPTotalSelected = T.tidy(\n dataHazardSelected,\n T.filter((d) => d.hazard !== 'any'),\n T.groupBy(\n [\n \"admin0_name\",\n \"admin1_name\",\n \"admin2_name\",\n \"admin3_name\",\n \"severity\",\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":2412,"value":"#### Lookups","pinned":false,"hidden":false,"mode":"md"},{"id":2236,"value":"// unique crops in the hazard data\nhazardCrops = {\n const query = await db.query(`select crop\n , count(*) as count\n from haz_risk_vop_int_combined\n group by 1\n order by 1`);\n\n return query\n }","pinned":false,"hidden":false,"mode":"ojs"},{"id":2233,"value":"$40","pinned":false,"hidden":false,"mode":"ojs"},{"id":2234,"value":"$41","pinned":false,"hidden":false,"mode":"ojs"},{"id":1691,"value":"#### Selecting VoP 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.selectAdmin3?.value) return dataHazardAdmin3\n else 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":2733,"value":"$42","pinned":false,"hidden":false,"mode":"ojs"},{"id":2732,"value":"dataHazardAdmin0 = db.query(`\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , crop\n , severity\n , hazard\n , value as vop\n from haz_risk_vop_int_combined\n where severity = 'severe' -- hard-coded\n -- and hazard in ('heat', 'wet', 'dry') -- single hazards alone\n and timeframe = '${selectScenarioAndTimeframe.timeframe}'\n and scenario = '${selectScenarioAndTimeframe.scenario}'\n and admin1_name is null\n and admin0_name = '${adminSelections.selectAdmin0.value}'`)\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":2731,"value":"dataHazardAdmin1 = db.query(`-- admin1 level hazard data\n -- chosen scenario and timeframe VoP\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , crop\n , severity\n , hazard\n , value as vop\n from haz_risk_vop_int_combined\n where severity = 'severe' -- hard-coded\n -- and hazard in ('heat', 'wet', 'dry') -- single hazards alone\n and timeframe = '${selectScenarioAndTimeframe.timeframe}'\n and scenario = '${selectScenarioAndTimeframe.scenario}'\n and admin0_name = '${adminSelections.selectAdmin0.value}'\n and admin1_name = '${cleanAdminInput_SQL(adminSelections.selectAdmin1.value)}'\n and admin2_name is null\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2730,"value":"dataHazardAdmin2 = db.query(`-- admin2 level hazard data\n -- chosen scenario and timeframe VoP\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , crop\n , severity\n , hazard\n , value as vop\n from haz_risk_vop_int_combined\n where severity = 'severe' -- hard-coded\n -- and hazard in ('heat', 'wet', 'dry') -- single hazards alone\n and timeframe = '${selectScenarioAndTimeframe.timeframe}'\n and scenario = '${selectScenarioAndTimeframe.scenario}'\n and admin0_name = '${adminSelections.selectAdmin0.value}'\n and admin1_name = '${cleanAdminInput_SQL(adminSelections.selectAdmin1.value)}'\n and admin2_name = '${cleanAdminInput_SQL(adminSelections.selectAdmin2.value)}'\n and admin3_name IS NULL -- Only subregion-level data, not woreda-level\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":4388,"value":"dataHazardAdmin3 = db.query(`-- admin3 level (woreda) hazard data\n -- chosen scenario and timeframe VoP\n select admin0_name\n , admin1_name\n , admin2_name\n , admin3_name\n , scenario\n , timeframe\n , crop\n , severity\n , hazard\n , value as vop\n from haz_risk_vop_int_combined\n where severity = 'severe' -- hard-coded\n and timeframe = '${selectScenarioAndTimeframe.timeframe}'\n and scenario = '${selectScenarioAndTimeframe.scenario}'\n and admin0_name = '${adminSelections.selectAdmin0.value}'\n and admin1_name = '${cleanAdminInput_SQL(adminSelections.selectAdmin1.value)}'\n and admin2_name = '${cleanAdminInput_SQL(adminSelections.selectAdmin2.value)}'\n and admin3_name = '${cleanAdminInput_SQL(adminSelections.selectAdmin3.value)}'\n`)\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":2923,"value":"db.query(`SELECT DISTINCT admin0_name from haz_risk_vop_int_combined\n where severity = 'severe' and hazard = 'dry+heat+wet' and value > 0 and admin1_name is null`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2231,"value":"---\n### Dynamic Insights - Hazards and exposures","pinned":false,"hidden":false,"mode":"md"},{"id":2230,"value":"// get selected hazard for insights, define crop type\ndata_selectedHazardCropType = T.tidy(\n data_hazardVoP,\n T.filter(d => d.hazard == selectHazard),\n T.mutate({\n cropType: d => {\n if (riskDataTypes.crop.crop.includes(d.crop)) return 'crop'\n if (riskDataTypes.crop.livestock.includes(d.crop)) return 'livestock'\n return 'other'\n }\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.groupBy(['cropType'], [\n T.summarize({\n totalExposedVop: T.sum('vop')\n })\n ])\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2228,"value":"// top crop and livestock for selection\ninsight_topCrops = {\n const topCrop = T.tidy(\n data_selectedHazardCropType,\n T.select([\"cropType\", \"crop\", \"vop\"]),\n T.filter((d) => d.cropType == \"crop\"),\n T.sliceMax(1, \"vop\")\n );\n const topLivestock = T.tidy(\n data_selectedHazardCropType,\n T.select([\"cropType\", \"crop\", \"vop\"]),\n T.filter((d) => d.cropType == \"livestock\"),\n T.sliceMax(1, \"vop\")\n );\n return [\n ...topCrop,\n ...topLivestock\n ]\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) => !['any', 'no hazard'].includes(d.hazard)), // remove combined and no hazard\n T.arrange(T.desc('totalVop'))\n \n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1381,"value":"---\n### Choropleth map - Adaptive Capacities\n*Population affected by admin region*\n- Fetch the data separately for the different admin levels and generate map data for each\n- Serve different data based on admin selection","pinned":false,"hidden":false,"mode":"md"},{"id":2606,"value":"$43","pinned":false,"hidden":false,"mode":"ojs"},{"id":1809,"value":"$44","pinned":false,"hidden":false,"mode":"ojs"},{"id":4157,"value":"$45","pinned":false,"hidden":false,"mode":"ojs"},{"id":4144,"value":"{\n console.log(\"DEBUG: adminSelections:\", {\n admin0: adminSelections.selectAdmin0.value,\n admin1: adminSelections.selectAdmin1.value,\n admin2: adminSelections.selectAdmin2.value,\n admin3: adminSelections.selectAdmin3.value\n });\n console.log(\"DEBUG: dataAdaptiveCapacity sample:\", dataAdaptiveCapacity.slice(0, 2));\n console.log(\"DEBUG: mapDataAdaptiveCapacityAdmin0 features:\", mapDataAdaptiveCapacityAdmin0.features.length);\n console.log(\"DEBUG: mapDataAdaptiveCapacityAdmin2 features:\", mapDataAdaptiveCapacityAdmin2.features.length);\n console.log(\"DEBUG: mapDataAdaptiveCapacityAdmin3 features:\", mapDataAdaptiveCapacityAdmin3.features.length);\n console.log(\"DEBUG: mapFeaturesAdaptiveCapacity sample:\", mapFeaturesAdaptiveCapacity.slice(0, 2).map(f => f.properties));\n return { dataAdaptiveCapacity, mapDataAdmin0: mapDataAdaptiveCapacityAdmin0, mapDataAdmin2: mapDataAdaptiveCapacityAdmin2, mapDataAdmin3: mapDataAdaptiveCapacityAdmin3, mapFeatures: mapFeaturesAdaptiveCapacity };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1808,"value":"mapDataAdaptiveCapacityAdmin2 = {\n const data = T.tidy(\n dataAdaptiveCapacity,\n T.mutate({ a2_a1_a0: (d) => [d.admin2_name || '', d.admin1_name || '', d.admin0_name].join(\"_\") })\n );\n const geoData = boundaries.admin2;\n \n console.log(\"DEBUG: mapDataAdaptiveCapacityAdmin2 - Data rows:\", data.length);\n console.log(\"DEBUG: mapDataAdaptiveCapacityAdmin2 - Geo features:\", geoData?.features?.length || 0);\n \n const result = bindTabularToGeo({\n data: data,\n dataBindColumn: \"a2_a1_a0\",\n geoData: geoData,\n geoDataBindColumn: \"a2_a1_a0\"\n });\n \n console.log(\"DEBUG: mapDataAdaptiveCapacityAdmin2 - Bound features:\", result.features.length);\n console.log(\"DEBUG: mapDataAdaptiveCapacityAdmin2 - Sample bound feature:\", result.features[0]?.properties);\n \n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1807,"value":"mapDataAdaptiveCapacityAdmin0 = {\n const data = T.tidy(\n dataAdaptiveCapacity,\n T.mutate({ admin0_name: (d) => d.admin0_name })\n );\n const geoData = boundaries.admin0;\n\n return bindTabularToGeo({\n data: data,\n dataBindColumn: \"admin0_name\",\n geoData: geoData,\n geoDataBindColumn: \"admin0_name\"\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3086,"value":"$46","pinned":false,"hidden":false,"mode":"ojs"},{"id":4123,"value":"{\n console.log(\"DEBUG: adminSelections:\", {\n admin0: adminSelections.selectAdmin0.value,\n admin1: adminSelections.selectAdmin1.value,\n admin2: adminSelections.selectAdmin2.value,\n admin3: adminSelections.selectAdmin3.value\n });\n console.log(\"DEBUG: dataAdaptiveCapacity sample:\", dataAdaptiveCapacity.slice(0, 2));\n console.log(\"DEBUG: boundaries.admin3_with_vop features:\", boundaries.admin3_with_vop?.features?.length || 0);\n console.log(\"DEBUG: mapDataAdaptiveCapacityAdmin3 features:\", mapDataAdaptiveCapacityAdmin3.features.length);\n console.log(\"DEBUG: mapFeaturesAdaptiveCapacity features:\", mapFeaturesAdaptiveCapacity.length);\n console.log(\"admin 3\",boundaries?.admin3)\n return { dataAdaptiveCapacity, mapDataAdmin3: mapDataAdaptiveCapacityAdmin3, mapFeatures: mapFeaturesAdaptiveCapacity };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2727,"value":"$47","pinned":false,"hidden":false,"mode":"ojs"},{"id":4171,"value":"$48","pinned":false,"hidden":false,"mode":"ojs"},{"id":1498,"value":"---\n### Dynamic Insights - Adapative Capacities\n*insights and helpers*","pinned":false,"hidden":false,"mode":"md"},{"id":2172,"value":"$49","pinned":false,"hidden":false,"mode":"ojs"},{"id":1496,"value":"#### Helpers","pinned":false,"hidden":false,"mode":"md"},{"id":2171,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs"},{"id":2725,"value":"// define the mad lib for adaptive capacity admin1 and admin 0 levels\nfunction adaptiveCapacityInsightMadLib2(data, adminName) {\n // Handle NaN values\n const education_years = (data?.ac_edu_perc != null && !isNaN(data.ac_edu_perc)) \n ? data.ac_edu_perc.toFixed(2) \n : \"NaN\";\n const female_empowerment = (data?.ac_fem_perc != null && !isNaN(data.ac_fem_perc)) \n ? (data.ac_fem_perc * 100).toFixed(0) \n : \"NaN\";\n const poverty_rate = (data?.ac_pov_perc != null && !isNaN(data.ac_pov_perc)) \n ? formatPercentWhole(data.ac_pov_perc) \n : \"NaN\";\n\n \n return `In **${adminName}**, the average educational attainment is **${education_years}** years, the female empowerment index is **${female_empowerment}**, and **${poverty_rate}** live in poverty.`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2724,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs"},{"id":2226,"value":"---\n### Adaptive Capacity Icicle - Adaptive Capacities\nNote: data uses `SSA` for combined admin region (see `icicle_csv`)","pinned":false,"hidden":false,"mode":"md"},{"id":2723,"value":"icicle_raw = {\n const country = adminSelections.selectAdmin0.value || \"SSA\";\n const admin1 = adminSelections.selectAdmin1.value || null;\n const admin2 = adminSelections.selectAdmin2.value || null;\n const admin3 = adminSelections.selectAdmin3?.value || null;\n \n let adminQuery = `WHERE admin0_name = '${country}' AND admin1_name`\n adminQuery += !admin1 ? ` IS NULL` : ` = '${cleanAdminInput_SQL(admin1)}'`\n adminQuery += ` AND admin2_name`\n adminQuery += !admin2 ? ` IS NULL` : ` = '${cleanAdminInput_SQL(admin2)}'`\n adminQuery += ` AND admin3_name`\n adminQuery += !admin3 ? ` IS NULL` : ` = '${cleanAdminInput_SQL(admin3)}'`\n // let adminQuery = `WHERE admin0_name = 'Angola' AND admin1_name IS NULL`\n // return adminQuery\n return db.query(`SELECT path, value FROM icicle_data ${adminQuery}`)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2722,"value":"icicle_data = buildHierarchy(icicle_raw)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2221,"value":"icicle_alias = {\n const base = nbText.adaptiveCapacities.delvingDeeper.plot.nameMap\n const nameMap = {\n population: _lang(base.population),\n poverty0: _lang(base.poverty0),\n poverty1: _lang(base.poverty1),\n poverty2: _lang(base.poverty2),\n education0: _lang(base.education0),\n education1: _lang(base.education1),\n education2: _lang(base.education2),\n gender0: _lang(base.gender0),\n gender1: _lang(base.gender1),\n gender2: _lang(base.gender2)\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([\n \"#a4a4a4\",\n \"#ec5a47\",\n \"#fc8a34\",\n \"#f4bb21\",\n \"#f4bb21\",\n \"#fc8a34\",\n \"#ec5a47\",\n \"#f4bb21\",\n \"#fc8a34\",\n \"#ec5a47\"\n ])","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":"$4c","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":2206,"value":"This notebook reuses much of the `buildHierarchy` function from the original [Sequences sunburst](https://gist.github.com/kerryrodden/7090426) gist, which was published with the following [license](https://gist.github.com/kerryrodden/7090426#file-license):\n\n> Copyright 2013 Google Inc. All Rights Reserved.\n> \n> Licensed under the Apache License, Version 2.0 (the \"License\");\n> you may not use this file except in compliance with the License.\n> You may obtain a copy of the License at\n> \n> http://www.apache.org/licenses/LICENSE-2.0\n> \n> Unless required by applicable law or agreed to in writing, software\n> distributed under the License is distributed on an \"AS IS\" BASIS,\n> WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n> See the License for the specific language governing permissions and\n> limitations under the License.","pinned":false,"hidden":false,"mode":"md"},{"id":33,"value":"---\n## Data\n*Data sources*\n- Data is from local files downloaded from S3, uploaded as a file attachments\n- Data is then wrapped as a duckDB database table (separate tables for each parquet file)\n- We are using some simplified data sources, suffixed with `reduced.parquet` in the S3 bucket","pinned":false,"hidden":false,"mode":"md"},{"id":1282,"value":"### Tabular data\n- **haz_risk_vop_int**: risk data showing effect hazards have on crops. Interactions are independent.\n - `risk_prototype/data/hazard_risk_vop_ac/annual/haz_risk_vop_int_ac_reduced.parquet` \n- **population**: population data by admin levels\n - `population/population_long.parquet`\n- **vop_ha**: Value of Production (VoP) and hectare data (Ha) exposures by admin level. No hazards applied.\n - `risk_prototype/data/exposure/exposure_adm_sum.parquet`\n- **vul_ac**: adaptive capacity data (update)\n - `vulnerability/vulnerability_RawIndex_adminALL.parquet`","pinned":false,"hidden":false,"mode":"md"},{"id":8,"value":"$4d","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":2719,"value":"boundaries = {\n let admin1Data, admin2Data;\n \n // Only fetch admin1 and admin2 data if a country is selected\n if (adminSelections.selectAdmin0.value) {\n admin1Data = await get_admin1();\n admin2Data = await get_admin2();\n } else {\n admin1Data = { type: \"FeatureCollection\", features: [] };\n admin2Data = { type: \"FeatureCollection\", features: [] };\n }\n \n return {\n admin0: admin0,\n admin1: admin1Data,\n admin2: admin2Data,\n admin3: admin3_with_vop,// Use the enhanced version\n admin32: admin3_cleaned\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3500,"value":"// Refresh boundaries when country changes\nrefreshBoundaries = {\n void adminSelections.selectAdmin0.value;\n return boundaries; // This will trigger boundaries to recalculate\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2718,"value":"geo_db = {\n let db = await DuckDBClient.of({\n // admin0_geom: FileAttachment(\"atlas-region_admin0_simplified.parquet\"),\n admin1_geom: FileAttachment(\"atlas-region_admin1_simplified@1.parquet\")\n });\n await db.query(`\n CREATE VIEW admin2_geom AS\n SELECT *\n FROM read_parquet(\"${resolveWindowsCacheIssue(\n \"https://digital-atlas.s3.amazonaws.com/boundaries/atlas-region_admin2_simplified.parquet\"\n )}\")`);\n return db;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2841,"value":"partitioned_boundries = \"https://digital-atlas.s3.amazonaws.com/boundaries/subnational-boundaries_simplified\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2851,"value":"iso3_list = new Object({\n \"Nigeria\": \"NGA\",\n \"Sudan\": \"SDN\",\n \"Cameroon\": \"CMR\",\n \"Ethiopia\": \"ETH\",\n \"Mauritania\": \"MRT\",\n \"Côte d’Ivoire\": \"CIV\",\n \"Ghana\": \"GHA\",\n \"Madagascar\": \"MDG\",\n \"Djibouti\": \"DJI\",\n \"Benin\": \"BEN\",\n \"Equatorial Guinea\": \"GNQ\",\n \"Eritrea\": \"ERI\",\n \"Tanzania\": \"TZA\",\n \"Somalia\": \"SOM\",\n \"Guinea-Bissau\": \"GNB\",\n \"Mali\": \"MLI\",\n \"Central African Republic\": \"CAF\",\n \"Gambia\": \"GMB\",\n \"Chad\": \"TCD\",\n \"Kenya\": \"KEN\",\n \"Congo - Kinshasa\": \"COD\",\n \"Angola\": \"AGO\",\n \"Lesotho\": \"LSO\",\n \"Guinea\": \"GIN\",\n \"Liberia\": \"LBR\",\n \"Burkina Faso\": \"BFA\",\n \"Congo - Brazzaville\": \"COG\",\n \"Burundi\": \"BDI\",\n \"Zimbabwe\": \"ZWE\",\n \"Mozambique\": \"MOZ\",\n \"Botswana\": \"BWA\",\n \"Malawi\": \"MWI\",\n \"Uganda\": \"UGA\",\n \"Zambia\": \"ZMB\",\n \"South Sudan\": \"SSD\",\n \"Togo\": \"TGO\",\n \"Senegal\": \"SEN\",\n \"Niger\": \"NER\",\n \"Sierra Leone\": \"SLE\",\n \"South Africa\": \"ZAF\",\n \"Rwanda\": \"RWA\",\n \"Namibia\": \"NAM\",\n \"Gabon\": \"GAB\",\n \"Eswatini\": \"SWZ\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2855,"value":"admin_iso = iso3_list[selectAdmin0.value]","pinned":false,"hidden":false,"mode":"ojs"},{"id":2717,"value":"admin0 = {\n let admin0 = await FileAttachment(\"atlas-region_admin0_harmonized@1.json\").json()\n return topojson.feature(admin0, admin0.objects[\"atlas-region_admin0_harmonized\"])\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3067,"value":"admin3 = {\n const admin3 = FileAttachment(\"eth_admbnda_adm3_csa_bofedb_2021_simplified.json\").json();\n return admin3; // already GeoJSON\n}\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":3079,"value":"admin3_cleaned = {\n const renamed = admin3.features.map(f => ({\n ...f,\n properties: {\n admin3_name: f.properties.ADM31_EN,\n admin3_pcode: f.properties.ADM3_PCODE,\n admin2_name: f.properties.ADM2_EN,\n admin2_pcode: f.properties.ADM2_PCODE,\n admin1_name: f.properties.ADM1_EN,\n admin1_pcode: f.properties.ADM1_PCODE,\n admin0_name: f.properties.ADM0_EN,\n admin0_pcode: f.properties.ADM0_PCODE,\n ...f.properties // keep everything else\n }\n }));\n\n return { type: \"FeatureCollection\", features: renamed };\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":2716,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs"},{"id":2715,"value":"$4f","pinned":false,"hidden":false,"mode":"ojs"},{"id":2109,"value":"### Dynamic summary links\nCSV of links to include for different admin0 selections\n- `Local Drive Google Sheet`","pinned":false,"hidden":false,"mode":"md"},{"id":2108,"value":"// dynamic bulleted list data\ndynamicSummaryData = {\n const raw = await FileAttachment(\"dynamic-summary-links@1.csv\").csv()\n\n return raw.filter((d) => d.admin0_name.length > 0)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2107,"value":"dynamicSummarySelectedLinks = {\n // filter and check link number\n const data = dynamicSummaryData\n const admin0Selection = adminSelections.selectAdmin0.value ?? \"DEFAULT\"\n \n const numLinks = data.filter(d => d.admin0_name == admin0Selection).length\n return numLinks == 0\n ? data.filter(d => d.admin0_name == 'DEFAULT')\n : data.filter(d => d.admin0_name == admin0Selection)\n\n \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2106,"value":"dynamicSummaryMarkdown = {\n const linkArr = dynamicSummarySelectedLinks.map(d => `- [${d.link_text}](${d.link_url})${d.description.length > 0 ? `: ${d.description}`: \"\"}`)\n return linkArr.join(\"\\n\")\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":448,"value":"***\n## Helpers\n*Functions and other good stuff*","pinned":false,"hidden":false,"mode":"md"},{"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":"$50","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/admin3 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 const matchAdmin0 = d.admin0_name == adminSelections.selectAdmin0.value;\n const matchAdmin1 = d.admin1_name == adminSelections.selectAdmin1.value;\n const matchAdmin2 = d.admin2_name == adminSelections.selectAdmin2.value;\n // If admin3 is selected, also filter by admin3 (though most queries don't have admin3_name)\n const matchAdmin3 = adminSelections.selectAdmin3?.value \n ? (d.admin3_name == adminSelections.selectAdmin3.value || !d.hasOwnProperty('admin3_name'))\n : true;\n return matchAdmin0 && matchAdmin1 && matchAdmin2 && matchAdmin3;\n })\n )\n return result\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1325,"value":"function 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, null, or NaN\n if (value === null || value === undefined || (typeof value === 'number' && isNaN(value))) {\n return defaultValue\n } else {\n return format(value)\n }\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":2543,"value":"// format non-number with no floating point \n// for index values\nformatPercentNoSymbol = (d) => {\n if (d === undefined || d === null) return d\n else return d3.format('.0f')(d)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2562,"value":"function formatUSD({ locale = \"en-US\" } = {}) {\n const formatter = formatNumCompactShort({ locale });\n\n return (number) => {\n const formattedNum = formatter(number)\n return \"$\" + formattedNum;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2561,"value":"intDollarYear = 2005 // year of international year data","pinned":false,"hidden":false,"mode":"ojs"},{"id":2560,"value":"intDollarUnit = `${intDollarYear} Int$` // full unit for international dollars","pinned":false,"hidden":false,"mode":"ojs"},{"id":449,"value":"// format US currency\nfunction formatIntDollar({ locale = \"en-US\" } = {}) {\n return (number, unit = intDollarUnit.replace(\"$\", \"\")) => {\n let formattedNumber = formatUSD({ locale })(number);\n let intDollar = unit + formattedNumber;\n return intDollar;\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1322,"value":"// format number, long notation\nformatNumCompactLong = function ({ locale = \"en-US\" } = {}) {\n return function (number) {\n return new Intl.NumberFormat(locale, {\n notation: \"compact\",\n compactDisplay: \"long\",\n unitDisplay: \"long\"\n }).format(number);\n };\n}","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 if (!data.length || !geoData.features || !geoData.features.length) {\n return {\n type: \"FeatureCollection\",\n features: []\n };\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":98,"value":"***\n## Testing Queries\n*Test queries of the tabular data*","pinned":false,"hidden":false,"mode":"md"},{"id":2371,"value":"{\n const debugString = md`**Query hidden: Debug: non-zero hazard data counts**\n\n_(update boolean within this cell to run)_ \n - this checks the number of results for every combination of hazard data \n - ~3% of choices have no data across all crops`\n \n const hideQuery = true;\n\n return hideQuery\n ? debugString\n : db.query(`\nwith tbl as (\n select admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n , count(*) as total_count\n , count(case when value <> 0 then 1 end) as non_zero_count\n from haz_risk_vop_int_combined\n -- where admin0_name = 'Angola'\n where severity = 'moderate' -- hard-coded\n and hazard != 'any'\n group by admin0_name\n , admin1_name\n , admin2_name\n , scenario\n , timeframe\n order by non_zero_count\n)\n\nselect * \n from tbl\n -- where non_zero_count = 0\n`);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":264,"value":"***\n## Imports\n*External imports*","pinned":false,"hidden":false,"mode":"md"},{"id":265,"value":"import {toc} from \"@nebrius/indented-toc\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1240,"value":"import {T} from \"@pbeshai/tidyjs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2713,"value":"import {cleanAdminInput_SQL, resolveWindowsCacheIssue} from \"cbd32f92c155bf5b\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2711,"value":"GEOS = {\n const initgeosJs = (await import(\"https://cdn.skypack.dev/geos-wasm@2.0.0\"))\n .default;\n const geos = await initgeosJs();\n\n function geosGeomFromWKB(wkb) {\n const wkbPtr = geos.Module._malloc(wkb.length); //Allocate memory for the geom\n geos.Module.HEAPU8.set(wkb, wkbPtr);\n const geomPtr = geos.GEOSGeomFromWKB_buf(wkbPtr, wkb.length);\n geos.Module._free(wkbPtr);\n return geomPtr;\n }\n \n const geosGeomToGeojson = (\n await import(\"https://cdn.skypack.dev/geos-wasm/helpers\")\n ).geosGeomToGeojson;\n\n return { geosGeomToGeojson, geosGeomFromWKB, geos };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2710,"value":"turfRewind = require(\"@turf/turf\").then((t) => t.rewind)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2772,"value":"import {buildInlineDownloadButton} from \"1bda5f9b60c64223\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2783,"value":"download_translation = new Object({en: \"Download Data\", fr: \"Télécharger les Données\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2370,"value":"---\n\n## Other","pinned":false,"hidden":false,"mode":"md"},{"id":2369,"value":"function makeDevNotes({\n // adding dev notes as a html summary (collapsible)\n title = \"Plot dev notes\",\n emojis = \"👆🛠\",\n text = md`Update this text using the \\`text\\` field.`\n} = {}) {\n return htl.html`

${title} ${emojis}

${text}

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2368,"value":"$51","pinned":false,"hidden":false,"mode":"ojs"},{"id":2906,"value":"convertToCSV = (data) => {\n if (!data?.length) return '';\n \n const headers = Object.keys(data[0]);\n const escapeValue = val => {\n if (val == null) return '';\n const str = String(val);\n return str.includes(',') || str.includes('\"') || str.includes('\\n') \n ? `\"${str.replace(/\"/g, '\"\"')}\"` : str;\n };\n \n return [\n headers.map(escapeValue).join(','),\n ...data.map(row => headers.map(key => escapeValue(row[key])).join(','))\n ].join('\\n');\n};","pinned":false,"hidden":false,"mode":"ojs"},{"id":2908,"value":"icicle_raw","pinned":false,"hidden":false,"mode":"ojs"},{"id":4294,"value":"usdToEtbExchangeRate=\n{\n try {\n const response = await fetch(\"https://open.er-api.com/v6/latest/USD\");\n const data = await response.json();\n if (data.result === \"success\" && data.rates && data.rates.ETB) {\n return data.rates.ETB;\n }\n // Fallback to 140 if API fails\n return 140;\n } catch (error) {\n console.warn(\"Failed to fetch exchange rate, using fallback value:\", error);\n // Fallback to 140 if API fails\n return 140;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4354,"value":"$52","pinned":false,"hidden":false,"mode":"ojs"},{"id":4357,"value":"$53","pinned":false,"hidden":false,"mode":"ojs"},{"id":4204,"value":"{\n const result = await db.query(`\n SELECT admin0_name, admin1_name, admin2_name, crop, scenario, timeframe, severity, hazard, value, total_value\n FROM haz_risk_vop_int_combined\n WHERE admin0_name = 'Ethiopia' AND admin2_name IS NOT NULL\n LIMIT 10\n `);\n console.log(\"haz_risk_vop_int_combined sample:\", result);\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4206,"value":"{\n const result = await db.query(`\n SELECT admin0_name, admin1_name, admin2_name, SUM(value) as vop_total\n FROM vop\n WHERE admin0_name = 'Ethiopia' AND admin2_name IS NOT NULL\n GROUP BY admin0_name, admin1_name, admin2_name\n LIMIT 10\n `);\n console.log(\"vop sample:\", result);\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4208,"value":"{\n const result = mockWoredaData\n .filter(d => d.admin0_name === \"Ethiopia\" && d.admin3_name)\n .slice(0, 10)\n .map(d => ({\n admin0_name: d.admin0_name,\n admin1_name: d.admin1_name,\n admin2_name: d.admin2_name,\n admin3_name: d.admin3_name,\n vop_total: d.vop_total,\n rural_pop: d.rural_pop\n }));\n console.log(\"mockWoredaData sample:\", result);\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4220,"value":"{\n const result = await db.query(`\n SELECT admin0_name, admin1_name, admin2_name, crop, scenario, timeframe, severity, hazard, value, total_value\n FROM haz_risk_vop_int_combined\n WHERE admin0_name = 'Ethiopia' AND admin2_name IS NOT NULL\n LIMIT 10\n `);\n // Convert result to an array of objects\n const rows = [];\n for (const row of result) {\n rows.push({\n admin0_name: row.admin0_name,\n admin1_name: row.admin1_name,\n admin2_name: row.admin2_name,\n crop: row.crop,\n scenario: row.scenario,\n timeframe: row.timeframe,\n severity: row.severity,\n hazard: row.hazard,\n value: row.value,\n total_value: row.total_value\n });\n }\n console.log(\"haz_risk_vop_int sample:\", rows);\n return rows;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4224,"value":"{\n const rows = dataHazardSelected.slice(0, 10).map(row => ({\n admin0_name: row.admin0_name,\n admin1_name: row.admin1_name,\n admin2_name: row.admin2_name,\n crop: row.crop,\n scenario: row.scenario,\n timeframe: row.timeframe,\n severity: row.severity,\n hazard: row.hazard,\n vop: row.vop\n }));\n console.log(\"dataHazardSelected sample:\", rows);\n return rows;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4524,"value":"plotChoroplethGeoImpactSvg = {\n const container = plotChoroplethGeoImpact;\n if (!container) return null;\n \n // Try to get SVG from the exposed reference\n if (container._exportSvg) {\n return container._exportSvg;\n }\n \n // Fallback: find SVG in the container (pick the one with most children to avoid grabbing the legend)\n const figure = container.querySelector?.('figure');\n if (figure) {\n const svgs = Array.from(figure.querySelectorAll('svg'));\n if (svgs.length > 0) {\n return svgs.reduce((best, s) => s.children.length > best.children.length ? s : best);\n }\n }\n\n return null;\n}\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":4553,"value":"ChartSvg = \n{\n // Extract SVG from the _23 chart container\n if (hazardVopChart && hazardVopChart._exportSvg) {\n return hazardVopChart._exportSvg;\n }\n // Fallback: find SVG with most children to avoid grabbing the color legend\n if (hazardVopChart) {\n const figure = hazardVopChart.querySelector('figure');\n if (figure) {\n const svgs = Array.from(figure.querySelectorAll('svg'));\n if (svgs.length > 0) {\n return svgs.reduce((best, s) => s.children.length > best.children.length ? s : best);\n }\n }\n }\n return null;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4585,"value":"function _getSvgFromChart(chart) {\n if (!chart) return null;\n if (chart.tagName === \"svg\") return chart;\n const figure = chart.tagName === \"figure\" ? chart : chart.querySelector?.(\"figure\");\n if (figure) {\n const svg = figure.querySelector?.(\"svg\");\n if (svg) return svg;\n }\n return chart.querySelector?.(\"svg\") || null;\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":4602,"value":"function _getIcicleSvg() {\n return document.querySelector(\".icicle-chart-svg\") || null;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4695,"value":"$54","pinned":true,"hidden":false,"mode":"ojs"},{"id":4692,"value":"$55","pinned":true,"hidden":false,"mode":"ojs"},{"id":4702,"value":"population_workbook = FileAttachment(\"Population_Clean_V2@3.xlsx\").xlsx()","pinned":false,"hidden":false,"mode":"ojs"},{"id":4703,"value":"population_workbook.sheetNames","pinned":false,"hidden":false,"mode":"ojs"},{"id":4704,"value":"population_data = population_workbook.sheet(0, {\n headers: true\n // range: \"A1:J10\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":4720,"value":"normalizeName = (s) =>\n (s || \"\")\n .toString()\n .trim()\n .toLowerCase()\n .replace(/[-_/()]/g, \" \")\n .replace(/\\s+/g, \" \")","pinned":false,"hidden":false,"mode":"ojs"},{"id":4718,"value":"$56","pinned":false,"hidden":false,"mode":"ojs"},{"id":4728,"value":"$57","pinned":false,"hidden":false,"mode":"ojs"},{"id":4758,"value":"///////////////////////////////////////////////////////////\n// SUM POPULATION\n///////////////////////////////////////////////////////////\n\npopulationTotals = {\n const data = filteredPopulation;\n\n return data.reduce(\n (acc, d) => {\n // TOTAL POPULATION\n acc.male += +d.male || 0;\n acc.female += +d.female || 0;\n acc.total_pop += +d.total_pop || 0;\n\n // URBAN\n acc.urban_male += +d.urban_male || 0;\n acc.urban_female += +d.urban_female || 0;\n acc.urban_total += +d.urban_total || 0;\n\n // RURAL\n acc.rural_male += +d.rural_male || 0;\n acc.rural_female += +d.rural_female || 0;\n acc.rural_total += +d.rural_total || 0;\n\n return acc;\n },\n {\n male: 0,\n female: 0,\n total_pop: 0,\n\n urban_male: 0,\n urban_female: 0,\n urban_total: 0,\n\n rural_male: 0,\n rural_female: 0,\n rural_total: 0\n }\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4761,"value":"$58","pinned":false,"hidden":false,"mode":"ojs"},{"id":4745,"value":"$59","pinned":false,"hidden":false,"mode":"ojs"},{"id":4749,"value":"$5a","pinned":false,"hidden":false,"mode":"ojs"},{"id":4724,"value":"$5b","pinned":false,"hidden":false,"mode":"ojs"},{"id":4824,"value":"workbook = FileAttachment(\"Enset Crop data.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":4825,"value":"workbook.sheetNames","pinned":true,"hidden":false,"mode":"ojs"},{"id":4826,"value":"enset_data = workbook.sheet(0, {\n headers: true,\n // range: \"A1:J10\"\n })","pinned":true,"hidden":false,"mode":"ojs"},{"id":4827,"value":"enset_data","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W5c","stdlib":"1"}