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":3051,"value":"makeQuartoFlag(\"https://adaptationatlas.github.io/atlas_notebooksV1/notebooks/whatsAtRisk/notebook.html\")","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":"// format admin selections\n// bind to appendix inputs, add template to format\ngeoImpactAdminSelectors = {\n const labelCountry = _lang(nbText.supportNbText.words.country.singular)\n const labelRegion = _lang(nbText.supportNbText.words.region.singular)\n const labelSubregion = _lang(nbText.supportNbText.words.subregion.singular)\n \n return Inputs.form(\n [\n Inputs.bind(\n Inputs.select(dataAdmin0, {\n label: labelCountry,\n format: (x) => x.label\n }),\n viewof selectAdmin0\n ),\n Inputs.bind(\n Inputs.select(dataAdmin1, {\n label: labelRegion,\n format: (x) => x.label\n }),\n viewof selectAdmin1\n ),\n Inputs.bind(\n Inputs.select(dataAdmin2, {\n label: labelSubregion,\n format: (x) => x.label\n }),\n viewof selectAdmin2\n )\n ],\n {\n template: adminFormTemplate\n }\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1767,"value":"$1f","pinned":false,"hidden":false,"mode":"ojs"},{"id":1260,"value":"$20","pinned":false,"hidden":false,"mode":"ojs"},{"id":2823,"value":"buildInlineDownloadButton(mapDataGeoImpact.features.map(d => d.properties), _lang(download_translation), `${selectGeoDataType.key}`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1341,"value":"headerQuickInsightsGeoImpact = {\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":"$21","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 ],\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":2262,"value":"$22","pinned":false,"hidden":false,"mode":"ojs"},{"id":2800,"value":"buildInlineDownloadButton(\n data_hazardVoP,\n _lang(download_translation),\n `CropClimateExposure_${selectScenarioAndTimeframe.label.replace(/\\s/g, \"\")}`\n)","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":"{\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":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}`)","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":"{\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":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}`)","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":"$23","pinned":false,"hidden":false,"mode":"ojs"},{"id":2250,"value":"{\n const intro = _lang(nbText.climateRisks.hazardImpact.insights.blurbBiggestHazard)\n return md`${intro}\n- **${hazardPlotLookup.names[insight_rankedHazardVopTotals?.[0]?.['hazard']]}**: **${formatIntDollar({locale: language.locale})(insight_rankedHazardVopTotals?.[0]?.['totalVop'])}**\n- **${hazardPlotLookup.names[insight_rankedHazardVopTotals?.[1]?.['hazard']]}**: **${formatIntDollar({locale: language.locale})(insight_rankedHazardVopTotals?.[1]?.['totalVop'])}**`\n}","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 ],\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":1817,"value":"$24","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":"$25","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 ],\n {\n template: adminFormTemplate\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2246,"value":"$26","pinned":false,"hidden":false,"mode":"ojs"},{"id":2949,"value":"$27","pinned":false,"hidden":false,"mode":"ojs"},{"id":2977,"value":"$28","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\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 },\n allLabels: {\n admin1: _lang(nbText.supportNbText.labels.allRegions),\n admin2: _lang(nbText.supportNbText.labels.allSubregions),\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":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: \"fr\", label: \"Français\", locale: 'fr-FR' }\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":2627,"value":"$29","pinned":false,"hidden":false,"mode":"ojs"},{"id":2626,"value":"// data translation values\ntd = {\n let data = await FileAttachment(\"abAtlas-td-translation-data-v3.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":"$2a","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":"$2b","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 },\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":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, {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":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":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":"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":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":1251,"value":"// grab tabular data for choropleth\ndataGeoImpact = {\n let admin_query\n if (adminSelections.selectAdmin1.value) {\n admin_query = `WHERE admin0_name = '${adminSelections.selectAdmin0.value}' AND admin1_name = '${cleanAdminInput_SQL(adminSelections.selectAdmin1.value)}' AND admin2_name IS NOT NULL`\n } else if (adminSelections.selectAdmin0.value) {\n admin_query = `WHERE admin0_name = '${adminSelections.selectAdmin0.value}' AND admin1_name IS NOT NULL AND admin2_name IS NULL`\n } else {\n admin_query = `WHERE admin1_name IS NULL`\n }\n // get data for choropleth map based on choice\n const dataSource = selectGeoDataType.key == \"population\"\n ? await dataPopulation(admin_query)\n : await dataTotalVoP(admin_query)\n return dataSource \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1250,"value":"$2c","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":"$2d","pinned":false,"hidden":false,"mode":"ojs"},{"id":1332,"value":"---\n#### Data cells for insights","pinned":false,"hidden":false,"mode":"md"},{"id":2739,"value":"insight_adminQuery = {\n let admin_query\nif (adminSelections.selectAdmin1.value) {\n admin_query = `WHERE admin0_name = '${adminSelections.selectAdmin0.value}' AND admin1_name = '${cleanAdminInput_SQL(adminSelections.selectAdmin1.value)}' AND admin2_name IS NOT NULL`\n} else if (adminSelections.selectAdmin0.value) {\n admin_query = `WHERE admin0_name = '${adminSelections.selectAdmin0.value}' AND admin1_name IS NOT NULL AND admin2_name IS NULL`\n} else {\n admin_query = `WHERE admin1_name IS NULL`\n}\n return admin_query\n}","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":"$2e","pinned":false,"hidden":false,"mode":"ojs"},{"id":2734,"value":"$2f","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":"$30","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', '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 \"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\n group by 1\n order by 1`);\n\n return query\n }","pinned":false,"hidden":false,"mode":"ojs"},{"id":2233,"value":"// formatting crop names\ncropNames = {\n const raw = T.tidy(\n hazardCrops,\n T.distinct(\"crop\"),\n T.select(\"crop\"),\n T.mutate({\n type: (d) => (/_/.test(d.crop) ? \"livestock\" : \"crop\")\n }),\n T.arrange([\"type\", \"cropName\"])\n );\n let data = raw;\n\n // translation\n\n const translateCrop = (crop) => td.crop.values?.[crop];\n data = data.map((d) => {\n const arr = Lang.toSentenceCase(_lang(translateCrop(d.crop))).split(\"_\");\n const mainHalf = arr.slice(0, 1);\n const backHalf = arr\n .slice(1)\n .filter((d) => d !== \"de\")\n .join(\" \");\n const paren = backHalf.length > 0 ? `(${backHalf})` : \"\";\n const formatted = [...mainHalf, paren].join(\" \").trimEnd();\n return {\n ...d,\n cropName: formatted\n };\n });\n\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2234,"value":"$31","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.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":"$32","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\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\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\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`)","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":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":1809,"value":"// filter adaptive capacity data, get relevant features\nmapFeaturesAdaptiveCapacity = {\n // if null selection for all admins, return admin0 level\n if (!adminSelections.selectAdmin0.value) return mapDataAdaptiveCapacityAdmin0.features\n // return admin2 level\n else {\n return mapDataAdaptiveCapacityAdmin2.features.filter((d) => {\n return (\n d.properties.admin0_name ===\n (adminSelections.selectAdmin0.value || d.properties.admin0_name) &&\n d.properties.admin1_name ===\n (adminSelections.selectAdmin1.value || d.properties.admin1_name)\n );\n });\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1808,"value":"mapDataAdaptiveCapacityAdmin2 = {\n const data = T.tidy(\n dataAdaptiveCapacity,\n // add data join for geo data\n T.mutate({\n a2_a1_a0: (d) => [d.admin2_name, d.admin1_name, d.admin0_name].join(\"_\")\n })\n );\n const geoData = boundaries.admin2;\n\n return bindTabularToGeo({\n data: data,\n dataBindColumn: \"a2_a1_a0\",\n geoData: geoData,\n geoDataBindColumn: \"a2_a1_a0\"\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1807,"value":"mapDataAdaptiveCapacityAdmin0 = {\n const data = dataAdaptiveCapacity\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":2727,"value":"$34","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":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":1496,"value":"#### Helpers","pinned":false,"hidden":false,"mode":"md"},{"id":2171,"value":"$36","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 const education_years = data?.ac_edu_perc.toFixed(2)\n const female_empowerment = (data?.ac_fem_perc * 100).toFixed(0) //formatPercentWhole(data?.ac_fem_perc)\n const poverty_rate = formatPercentWhole(data?.ac_pov_perc)\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":"$37","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 \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 // 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":2981,"value":"icicle_keys = new Object({\n \"poverty\": {\n \"poverty0\": [\n \"Low Poverty\"\n ],\n \"poverty1\": [\n \"Moderate Poverty\"\n ],\n \"poverty1\": [\n \"High Poverty\"\n ]\n },\n \"education\": {\n \"education0\": [\n \"0-1 Years of Education\"\n ],\n \"education1\": [\n \"1-5 Years of Education\"\n ],\n \"education3\": [\n \"5+ Years of Education\"\n ]\n }, \n \"gender\": {\n \"gender0\": [\"Low Female Empowerment\"],\n \"gender1\": [\"Moderate Female Empowerment\"],\n \"gender2\": [\"High Female Empowerment\"]\n }\n})","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":"$38","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":"$39","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 return {\n admin0: admin0,\n admin1: await get_admin1(),\n admin2: await get_admin2()\n }\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.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.json\").json()\n return topojson.feature(admin0, admin0.objects[\"atlas-region_admin0_harmonized\"])\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2716,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs"},{"id":2715,"value":"$3b","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.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":"// lookup for risk data type groupings\n// used by inputs and for grouping up data\nriskDataTypes = ({\n crop: {\n crop: [\n \"arabica coffee\",\n \"banana\",\n \"barley\",\n \"bean\",\n \"cassava\",\n \"chickpea\",\n \"cocoa\",\n \"coconut\",\n \"cotton\",\n \"cowpea\",\n \"generic\",\n \"groundnut\",\n \"lentil\",\n \"maize\",\n \"oilpalm\",\n \"pearl millet\",\n \"pigeonpea\",\n \"plantain\",\n \"potato\",\n \"rice\",\n \"robusta coffee\",\n \"sesameseed\",\n \"small millet\",\n \"sorghum\",\n \"soybean\",\n \"sugarcane\",\n \"sunflower\",\n \"sweet potato\",\n \"tea\",\n \"tobacco\",\n \"wheat\",\n \"yams\"\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":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":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\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":"$3c","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":3017,"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: \"\"\n }\n )\n \n return htl.html`\n

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

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