1d:{"title":"Formulate a Climate Rationale for Projects","cells":[{"id":6769,"value":"# Formulate a Climate Rationale for Projects","pinned":false,"hidden":false,"mode":"md"},{"id":0,"value":"heroImage = {\n const imgSource = {\n en: FileAttachment(\"formulate-a-climate-rationale.webp\").url(),\n fr: FileAttachment(\"formulate-a-climate-rationale-fr.webp\").url(),\n };\n const imgUrl = _lang(imgSource);\n return htl.html`

${notebookTitle}

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":61,"value":"// pretty view of language toggle\nviewof prettyLanguageView = {\n return Inputs.bind(\n Inputs.radio(languages, {\n label: _lang(nbText.legends.language),\n format: (d) => d.label,\n disabled: false\n }),\n viewof language\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":532,"value":"tocBanner = tocOneliner({\n skip: [notebookTitle, \"Appendix\"],\n heading: `${Lang.toSentenceCase(_lang(nbText.legends.toc))}`\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"overviewHeader = md`# ${_lang(nbText.sections.intro.title)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"overviewBody = md`${_lang(nbText.sections.intro.introText)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":135,"value":"fstHeader = md`# ${_lang(nbText.sections.keyFacts.title)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":237,"value":"fstIntro = md`${_lang(nbText.sections.keyFacts.introText)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2291,"value":"// format admin selections\n// bind to appendix inputs, add template to format\nfstCountrySelect = Inputs.form(\n [\n Inputs.bind(\n Inputs.select(asData_admin0, { label: adminRegions.labels.admin0, format: x => x.label }),\n viewof as_i_admin0\n ),\n // Inputs.bind(\n // Inputs.select(asData_admin1, { label: adminRegions.labels.admin1, format: x => x.label }),\n // viewof as_i_admin1\n // ),\n ],\n {\n template: inputTemplate()\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":328,"value":"$1f","pinned":false,"hidden":false,"mode":"ojs"},{"id":331,"value":"$20","pinned":false,"hidden":false,"mode":"ojs"},{"id":335,"value":"$21","pinned":false,"hidden":false,"mode":"ojs"},{"id":338,"value":"$22","pinned":false,"hidden":false,"mode":"ojs"},{"id":382,"value":"fstInsightHeader = {\n const selection = fst_selections.admin0;\n const text = _lang(nbText.sections.quickInsightsGeneral.fHeader)({\n selection: selection.admin0_name\n });\n return md`### ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2880,"value":"fstInsight1 = {\n const country = fst_selections.admin0.admin0_name;\n const iso3 = fst_selections.admin0.iso3;\n const countryTranslated = Lang.toSentenceCase(_lang(country_translations[iso3].article1));\n const dataPopulation = fst_data_pop_wide[0];\n const totalPop = dataPopulation.population_rural_pop + dataPopulation.population_urban_pop;\n const ruralPop = dataPopulation.population_rural_pop;\n const ruralPerc = dataPopulation.percentage_rural_pop / 100;\n\n const formatPop = formatNumCompactSigFigs();\n const formatPerc = d3.format(\".1%\")\n\n const i = {\n country: countryTranslated,\n popTotal: formatPop(totalPop),\n popRural: formatPop(ruralPop),\n percRural: formatPerc(ruralPerc)\n }\n\n const insight = _lang(nbText.sections.keyFacts.insights.pop)({\n country: i.country,\n popTotal: i.popTotal,\n popRural: i.popRural,\n percRural: i.percRural\n })\n \n return insight\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2879,"value":"$23","pinned":false,"hidden":false,"mode":"ojs"},{"id":2885,"value":"fstInsight3 = {\n const country = fst_selections.admin0.admin0_name;\n const iso3 = fst_selections.admin0.iso3;\n const countryTranslated1 = _lang(country_translations[iso3].article1);\n const countryTranslated3 = _lang(country_translations[iso3].article3);\n \n const data = fst_data_agricultureGdp;\n const rank = data.rank;\n\n const i = {\n rank: numberToOrdinal(rank, {lang: language.key, gender: \"m\"}),\n country1: countryTranslated1,\n country3: countryTranslated3,\n }\n\n if (!data.gdp || data.percentage === null) {\n return _lang(nbText.sections.keyFacts.insights.gdp.missing)({\n country: i.country1\n })\n } else {\n return _lang(nbText.sections.keyFacts.insights.gdp.main)({\n country: i.country3,\n rank: i.rank\n });\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3131,"value":"fstInsight4 = {\n const country = fst_selections.admin0.admin0_name;\n const iso3 = fst_selections.admin0.iso3;\n const countryTranslated = _lang(country_translations[iso3].article2);\n const data = fst_plotData.land;\n const maxLand = d3.max(data, d => d.ha);\n const mostLandUse = data.filter((d) => d.ha == maxLand)[0];\n\n // return mostLandUse\n\n const formatHa = formatNumCompactSigFigs();\n const formatPerc = d3.format(\".1%\")\n\n // const groupTranslated = mostLandUse.group;\n const groupTranslated = _lang(td.land_group.values?.[mostLandUse.group]);\n \n const i = {\n country: countryTranslated,\n type: groupTranslated,\n ha: formatHa(mostLandUse.ha),\n perc: formatPerc(mostLandUse.percentage / 100)\n }\n\n const insight = _lang(nbText.sections.keyFacts.insights.land)({\n country: i.country,\n type: i.type,\n ha: i.ha,\n perc: i.perc\n })\n \n return insight\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":357,"value":"fstInsight5Intro = {\n const country = fst_selections.admin0.admin0_name;\n const iso3 = fst_selections.admin0.iso3;\n const countryTranslated = _lang(country_translations[iso3].article2);\n\n const insight = _lang(nbText.sections.keyFacts.insights.landTable.intro)({\n country: countryTranslated\n });\n\n return insight\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":360,"value":"$24","pinned":false,"hidden":false,"mode":"ojs"},{"id":148,"value":"wsBanner = md`# ${_lang(nbText.sections.recentChangesClimateIndicators.title)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":157,"value":"wsIntro = md`${_lang(nbText.sections.recentChangesClimateIndicators.introText)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2412,"value":"wsGeoSelects = // format admin selections\n// bind to appendix inputs, add template to format\nInputs.form(\n [\n Inputs.bind(\n Inputs.select(asData_admin0, { label: adminRegions.labels.admin0, format: x => x.label }),\n viewof as_i_admin0\n ),\n Inputs.bind(\n Inputs.select(asData_admin1, { label: adminRegions.labels.admin1, format: x => x.label }),\n viewof as_i_admin1\n ),\n ],\n {\n template: inputTemplate()\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":574,"value":"wsSeasonVarSelects = Inputs.form([viewof ws_iSelectSeason, viewof ws_iSelectVariable], {\n template: inputTemplate()\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":573,"value":"wsCheckboxes = Inputs.form([viewof ws_iToggleAnomaly, viewof ws_iToggleLine], {\n template: inputTemplate()\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":397,"value":"$25","pinned":false,"hidden":false,"mode":"ojs"},{"id":3343,"value":"buildInlineDownloadButton(ws_plotData, _lang(download_translation))","pinned":false,"hidden":false,"mode":"ojs"},{"id":469,"value":"wsInsightBanner = {\n const selection = getAdmin0WithAdmin1Parens();\n const text = _lang(nbText.sections.quickInsightsGeneral.fHeader)({\n selection: selection\n });\n const seasonStr = _lang(nbText.legends.fSeasonString)({season: ws_selections.season.season_string});\n return md`### ${text}\n_${seasonStr}_ ${styling}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":468,"value":"wsInsight1 = {\n const selection = getAdmin0WithAdmin1Parens({articleField: \"article1\"});\n \n const _admin0 = ws_selections.admin0.admin0_name;\n const _admin1 = as_i_admin1.admin1_name;\n const _season = ws_iSelectSeason.season;\n\n const insightData = ws_insightData_tempTrends.find(\n d => d.admin0_name == _admin0 && d.admin1_name == _admin1 && d.season == _season\n )\n\n const iWarming = insightData?.value_diff_tot\n const iDecade = insightData?.value_diff_year * 10\n\n const format = d3.format('.2f')\n\n const i = {\n country: Lang.toSentenceCase(selection),\n temp: format(iWarming),\n tempDecade: format(iDecade)\n }\n\n const insight = _lang(nbText.sections.recentChangesClimateIndicators.insights.warming.fWarming)({\n country: i.country,\n temp: i.temp,\n tempDecade: i.tempDecade\n })\n\n return insight\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":467,"value":"$26","pinned":false,"hidden":false,"mode":"ojs"},{"id":466,"value":"$27","pinned":false,"hidden":false,"mode":"ojs"},{"id":2918,"value":"$28","pinned":false,"hidden":false,"mode":"ojs"},{"id":178,"value":"plcBanner = md`# ${_lang(nbText.sections.futureClimateProjections.title)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":182,"value":"plcIntro = md`${_lang(nbText.sections.futureClimateProjections.introText)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2440,"value":"plcGeoSelects = // format admin selections\n// bind to appendix inputs, add template to format\nInputs.form(\n [\n Inputs.bind(\n Inputs.select(asData_admin0, { label: adminRegions.labels.admin0, format: x => x.label }),\n viewof as_i_admin0\n ),\n Inputs.bind(\n Inputs.select(asData_admin1, { label: adminRegions.labels.admin1, format: x => x.label }),\n viewof as_i_admin1\n ),\n ],\n {\n template: inputTemplate()\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":588,"value":"plcSeasonVarSelects = Inputs.form([viewof plc_iSelectSeason, viewof plc_iSelectVariable], {\n template: inputTemplate()\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":587,"value":"plcCheckboxes = Inputs.form([viewof plc_iToggleScenario, viewof plc_iToggleAnomaly, viewof plc_iToggleMinMax], { //viewof plc_iToggleTrend\n template: inputTemplate()\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5866,"value":"$29","pinned":false,"hidden":false,"mode":"ojs"},{"id":3347,"value":"buildInlineDownloadButton(tf_data, _lang(download_translation))","pinned":false,"hidden":false,"mode":"ojs"},{"id":499,"value":"plcInsightBanner = {\n const selection = getAdmin0WithAdmin1Parens();\n const text = _lang(nbText.sections.quickInsightsGeneral.fHeader)({\n selection: selection\n });\n const season = plc_iSelectSeason\n const seasonStr = _lang(nbText.legends.fSeasonString)({season: plc_iSelectSeason.season_string})\n return md`### ${text}\n_${seasonStr}_`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2926,"value":"plcInsight1 = {\n const selectedRegion = getAdmin0WithAdmin1Parens({articleField: \"article1\"});\n const data = plc_insights.filter(d => d.hazard == 'TAVG');\n const findScenario = (scenario, df = data, scenarioField = \"scenario\") => {\n return df.find((x) => x[scenarioField] == scenario);\n };\n\n const trajectoryHigh = findScenario(\"ssp370\")?.mean_anomaly.toFixed(2);\n const trajectoryModerate = findScenario(\"ssp245\")?.mean_anomaly.toFixed(2);\n const trajectoryLow = findScenario(\"ssp126\")?.mean_anomaly.toFixed(2);\n\n const i = {\n selectedRegion: Lang.toSentenceCase(selectedRegion),\n trajectoryHigh: trajectoryHigh,\n trajectoryModerate: trajectoryModerate,\n trajectoryLow: trajectoryLow,\n }\n\n const insight = _lang(nbText.sections.futureClimateProjections.insights.fWarming)({\n selectedRegion: i.selectedRegion,\n trajectoryHigh: i.trajectoryHigh,\n trajectoryModerate: i.trajectoryModerate,\n trajectoryLow: i.trajectoryLow,\n })\n\n return insight\n \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":497,"value":"plcInsight2 = {\n const selectedRegion = getAdmin0WithAdmin1Parens({articleField: \"article1\"});\n const data = plc_insights.filter((d) => d.hazard == \"TAVG\");\n const findScenario = (scenario, df = data, scenarioField = \"scenario\") => {\n return df.find((x) => x[scenarioField] == scenario);\n };\n\n const trajectory = findScenario(\"ssp370\");\n\n const i = {\n selectedRegion: selectedRegion,\n min: trajectory?.min_anomaly,\n max: trajectory?.max_anomaly\n };\n\n const insight = _lang(nbText.sections.futureClimateProjections.insights.fUncertainty)({\n selectedRegion: i.selectedRegion,\n max: i.max,\n min: i.min\n })\n return insight\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3171,"value":"plcInsight3 = {\n // combined precipitation insights\n const projection = plc_insight_makePrecipicationProjections();\n const reduction = plc_insight_makePrecipicationRainfall();\n\n return md`${projection} ${reduction}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2227,"value":"plcInsight4 = {\n const data = plc_insight_heatStress;\n const crop2 = data.ntx.find(d => d.scenario == 'ssp245')\n const crop5 = data.ntx.find(d => d.scenario == 'ssp585')\n const livestock2 = data.thi.find(d => d.scenario == 'ssp245')\n const livestock5 = data.thi.find(d => d.scenario == 'ssp585')\n\n const formatPerc = (d) => d3.format(\".1f\")(d) + '%'\n \n const i = {\n crop2: formatPerc(crop2?.perc_area_total),\n crop5: formatPerc(crop5?.perc_area_total),\n livestock2: formatPerc(livestock2?.perc_area_total),\n livestock5: formatPerc(livestock5?.perc_area_total),\n }\n\n const insight = _lang(nbText.sections.futureClimateProjections.insights.fHeatStress)({\n crop2: i.crop2,\n crop5: i.crop5,\n livestock2: i.livestock2,\n livestock5: i.livestock5,\n })\n\n return insight\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":192,"value":"ehmBanner = md`# ${_lang(nbText.sections.cropLivestockHazardExposure.title)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":193,"value":"ehmIntro = md`${_lang(nbText.sections.cropLivestockHazardExposure.introText)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2448,"value":"ehmGeoSelects = // format admin selections\n// bind to appendix inputs, add template to format\nInputs.form(\n [\n Inputs.bind(\n Inputs.select(asData_admin0, { label: adminRegions.labels.admin0, format: x => x.label }),\n viewof as_i_admin0\n ),\n Inputs.bind(\n Inputs.select(asData_admin1, { label: adminRegions.labels.admin1, format: x => x.label }),\n viewof as_i_admin1\n ),\n ],\n {\n template: inputTemplate()\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":601,"value":"ehmHazScenarioSelects = Inputs.form([viewof ehm_iHazard, viewof ehm_iScenario], {\n template: inputTemplate()\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":440,"value":"viewof ehm_iSortY = {\n const lookup = (d) => _lang(nbText.sections.cropLivestockHazardExposure.inputs.radioSortYCrops.data?.[d]);\n const data = [\n { key: \"alpha\", label: lookup(\"alpha\"), sort: { y: \"y\", reverse: false } },\n { key: \"vop\", label: lookup(\"total\"), sort: { y: \"fill\", reverse: true } }\n ];\n return Inputs.radio(data, {\n label: _lang(nbText.sections.cropLivestockHazardExposure.inputs.radioSortYCrops.label),\n format: (x) => x.label,\n value: data.find((x) => x.key === \"vop\")\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":456,"value":"$2a","pinned":false,"hidden":false,"mode":"ojs"},{"id":3351,"value":"buildInlineDownloadButton(ehm_prepData, _lang(download_translation))","pinned":false,"hidden":false,"mode":"ojs"},{"id":455,"value":"ehmInsightBanner = {\n const selection = getAdmin0WithAdmin1Parens();\n const text = _lang(nbText.sections.quickInsightsGeneral.fHeader)({\n selection: selection\n });\n return md`### ${text}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":454,"value":"$2b","pinned":false,"hidden":false,"mode":"ojs"},{"id":453,"value":"$2c","pinned":false,"hidden":false,"mode":"ojs"},{"id":202,"value":"ccBanner = md`# ${_lang(nbText.sections.climateChangeImpacts.title)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":205,"value":"ccIntro = md`${_lang(nbText.sections.climateChangeImpacts.introText)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2247,"value":"// pick a sector\nviewof cc_iSector = Inputs.select(cc_sectors, {\n label: _lang(nbText.sections.climateChangeImpacts.inputs.selectSector.label),\n format: (x) => x.label,\n value: cc_sectors.find(x => x.key == 'crop_suit')\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2459,"value":"ccGeoSelects = // format admin selections\n// bind to appendix inputs, add template to format\n// SPECIAL: the admin1 is determined by the sector selection\n{\n const admin0 = Inputs.bind(\n Inputs.select(asData_admin0, {\n label: adminRegions.labels.admin0,\n format: (x) => x.label\n }),\n viewof as_i_admin0\n );\n const admin1Standard = Inputs.bind(\n Inputs.select(asData_admin1, {\n label: adminRegions.labels.admin1,\n format: (x) => x.label\n }),\n viewof as_i_admin1\n );\n const admin1Basins = Inputs.bind(\n Inputs.select(cc_qAdmin1Basins, {\n label: \"Basin\",\n format: (x) => x.label\n }),\n viewof cc_i_admin1Basins\n );\n\n let admin1 = cc_iSector.key == \"water\" \n ? admin1Basins\n : admin1Standard\n \n return Inputs.form([admin0, admin1], {\n template: inputTemplate()\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3317,"value":"viewof scenario_form = {\n let temp_names = { rfd: \"Rainfed\", irr: \"Irrigated\" };\n let elements = [\n Inputs.bind(\n Inputs.select(cc_qScenarioTimeframe, {\n label: _lang(\n nbText.sections.climateChangeImpacts.inputs.selectScenario.label\n ),\n format: (x) => x.label\n }),\n viewof cc_iScenario\n )\n ];\n if (cc_iSector.key === \"crop_yield\") {\n elements.push(\n Inputs.select([\"irr\", \"rfd\"], {\n label: _lang(\n nbText.sections.climateChangeImpacts.insights.cyChanges.table.cols\n .yield_type\n ),\n format: (v) =>\n _lang(\n nbText.sections.climateChangeImpacts.inputs.selectSector.data\n .crop_yield.indicator[v]\n )\n })\n );\n }\n return Inputs.form(elements, { template: inputTemplate() });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3316,"value":"Climate_summaryTable = {\n let scaleValues = cc_iSector.key === \"water\" ? false : true;\n return generate_table(cc_plotData, cc_iSector.key, scaleValues);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3355,"value":"buildInlineDownloadButton(cc_plotData, _lang(download_translation))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2287,"value":"ccInsightBanner = {\n const showParens = cc_iSector.key == \"water\" ? false : true // only admin0 for water (by basins)\n const selection = getAdmin0WithAdmin1Parens({showParens});\n const text = _lang(nbText.sections.quickInsightsGeneral.fHeader)({\n selection: selection\n });\n return md`### ${text}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2986,"value":"ccInsightBody = {\n // show insights based on selected sector\n const sector = cc_iSector.key\n // water resources (based on basins)\n if (sector == \"water\") return cc_showCCInsights_water()\n // non-water (based on regions)\n else if (sector == \"crop_suit\") return cc_showCCInsights_cropSuit()\n else if (sector == \"crop_yield\") return cc_showCCInsights_cropYield()\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":217,"value":"summaryBanner = md`# ${_lang(nbText.sections.summary.title)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3164,"value":"summarySelects = // format admin selections\n// bind to appendix inputs, add template to format\nInputs.form(\n [\n Inputs.bind(\n Inputs.select(asData_admin0, { label: adminRegions.labels.admin0, format: x => x.label }),\n viewof as_i_admin0\n ),\n Inputs.bind(\n Inputs.select(asData_admin1, { label: adminRegions.labels.admin1, format: x => x.label }),\n viewof as_i_admin1\n ),\n ],\n {\n template: inputTemplate()\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":220,"value":"$2d","pinned":false,"hidden":false,"mode":"ojs"},{"id":228,"value":"msBanner = md`# ${_lang(nbTextMethods.title)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3114,"value":"ms_s_banner = getMethodTitle(nbTextMethods.sources)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3113,"value":"ms_s_pop = getMethodSection(nbTextMethods.sources.sections.population)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3112,"value":"ms_s_pov = getMethodSection(nbTextMethods.sources.sections.poverty)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3111,"value":"ms_s_gdp = getMethodSection(nbTextMethods.sources.sections.gdp)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3110,"value":"ms_s_land = getMethodSection(nbTextMethods.sources.sections.landUse)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3109,"value":"ms_s_historicalHazards = getMethodSection(nbTextMethods.sources.sections.historicalFutureClimateHazards)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3108,"value":"ms_s_exposure = getMethodSection(nbTextMethods.sources.sections.exposureToRisk)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3107,"value":"ms_s_water = getMethodSection(nbTextMethods.sources.sections.waterResources)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3106,"value":"ms_s_cropYieldRed = getMethodSection(nbTextMethods.sources.sections.cropYieldProjections)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3105,"value":"ms_s_cropSuit = getMethodSection(nbTextMethods.sources.sections.cropSuitabilityProjections)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3104,"value":"ms_s_meatMilkProj = getMethodSection(nbTextMethods.sources.sections.meatAndMilkProjections)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3103,"value":"ms_s_boundaries = getMethodSection(nbTextMethods.sources.sections.boundaries)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3102,"value":"ms_m_banner = getMethodTitle(nbTextMethods.methods)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3101,"value":"ms_m_facts = getMethodSection(nbTextMethods.methods.sections.quickDemoEconFacts)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3100,"value":"ms_m_hazards = getMethodSection(nbTextMethods.methods.sections.annualSeasonalHazards)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3099,"value":"ms_m_cropLivestockVop = getMethodSection(nbTextMethods.methods.sections.cropLivestockExposure)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3098,"value":"ms_m_climate = getMethodSection(nbTextMethods.methods.sections.climateChange)","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"---\n# Appendix\nThis large section includes all the cells that power the notebook.","pinned":false,"hidden":false,"mode":"md"},{"id":240,"value":"---\n## Data Setup","pinned":false,"hidden":false,"mode":"md"},{"id":246,"value":"db = await initDb(dbSetup)","pinned":false,"hidden":false,"mode":"ojs"},{"id":6837,"value":"db2 = {\n document.body.style.cursor = \"wait\"\n let cli = await DuckDBClient.of()\n await cli.query(`CREATE VIEW test_hist AS SELECT * FROM read_parquet(\"${resolveWindowsCacheIssue(\"s3://digital-atlas/testData_atlas/tmp_climate-rational/haz_3months_adm_mean_historic_anomaly-historic_ensemble_seasons.parquet\")}\")`)\n document.body.style.cursor = \"\"\n return cli\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":6966,"value":"import {resolveWindowsCacheIssue} from \"72281be2f13a0a72\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":3396,"value":"import {initDb} from \"@adaptationatlas/ab-climate-rationale-data-sources\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":3399,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs"},{"id":247,"value":"// lookup array of objects, find result\nfunction findObjectByField(array, {field=\"key\", value}={}) {\n return array.find(obj => obj[field] === value);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":252,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":2300,"value":"### Global admin selections","pinned":false,"hidden":false,"mode":"md"},{"id":3060,"value":"// specific locations to exclude\nasData_excludeLocations = [\n { admin0_name: \"Equatorial Guinea\", admin1_name: \"Annobón\" }\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":2298,"value":"asData_raw = FileAttachment(\"asData_raw.json\").json()\n// asData_raw = {\n// const table = dataTable.chirtsSimple.name;\n// const query = await db.query(`\n// with base as (\n// select admin0_name\n// , iso3\n// , admin1_name\n// , count(*)\n// from tbl_chirts_simple\n// group by 1, 2, 3\n// )\n \n// select admin0_name\n// , iso3\n// , admin1_name\n// from base\n// order by 1, 2, 3\n// `)\n// // filter out any specific locations\n// const specificLocations = asData_excludeLocations;\n// const tidy = query.filter(d => !specificLocations.some(x => x.admin0_name == d.admin0_name && x.admin1_name == d.admin1_name))\n\n// return tidy\n// }","pinned":false,"hidden":false,"mode":"ojs"},{"id":2297,"value":"asData_admin0 = {\n const raw = asData_raw.filter(d => d.admin1_name == null)\n // adding labels\n const formatted = raw.map(d => ({\n admin0_name: d.admin0_name,\n iso3: d.iso3,\n label: _lang(country_translations[d.iso3]?.general)\n }))\n return formatted.filter((d) => Object.values(countryToIso3).includes(d.iso3))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3667,"value":"countryToIso3 = new Object({\n \"Angola\": \"AGO\",\n \"Benin\": \"BEN\",\n \"Botswana\": \"BWA\",\n \"Burkina Faso\": \"BFA\",\n \"Burundi\": \"BDI\",\n \"Cameroon\": \"CMR\",\n \"Central African Republic\": \"CAF\",\n \"Chad\": \"TCD\",\n \"Congo - Brazzaville\": \"COG\",\n \"Congo - Kinshasa\": \"COD\",\n \"Côte d’Ivoire\": \"CIV\",\n \"Côte d'Ivoire\": \"CIV\",\n \"Djibouti\": \"DJI\",\n \"Equatorial Guinea\": \"GNQ\",\n \"Eritrea\": \"ERI\",\n \"Eswatini\": \"SWZ\",\n \"Ethiopia\": \"ETH\",\n \"Gabon\": \"GAB\",\n \"Gambia\": \"GMB\",\n \"Ghana\": \"GHA\",\n \"Guinea\": \"GIN\",\n \"Guinea-Bissau\": \"GNB\",\n \"Kenya\": \"KEN\",\n \"Lesotho\": \"LSO\",\n \"Liberia\": \"LBR\",\n \"Madagascar\": \"MDG\",\n \"Malawi\": \"MWI\",\n \"Mali\": \"MLI\",\n \"Mauritania\": \"MRT\",\n \"Mozambique\": \"MOZ\",\n \"Namibia\": \"NAM\",\n \"Niger\": \"NER\",\n \"Nigeria\": \"NGA\",\n \"Rwanda\": \"RWA\",\n \"Senegal\": \"SEN\",\n \"Sierra Leone\": \"SLE\",\n \"Somalia\": \"SOM\",\n \"South Africa\": \"ZAF\",\n \"South Sudan\": \"SSD\",\n \"Sudan\": \"SDN\",\n \"Tanzania\": \"TZA\",\n \"Togo\": \"TGO\",\n \"Uganda\": \"UGA\",\n \"Zambia\": \"ZMB\",\n \"Zimbabwe\": \"ZWE\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2296,"value":"asData_admin1 = {\n const raw = asData_raw.filter(d => d.admin0_name == as_i_admin0.admin0_name)\n // adding labels\n const formatted = raw.map(d => ({\n admin0_name: d.admin0_name,\n admin1_name: d.admin1_name,\n label: d.admin1_name == null ? refAdmin.all.admin1 : d.admin1_name,\n }))\n return formatted\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2295,"value":"// info for the admin selectors\nadminRegions = {\n return {\n labels: {\n admin0: Lang.toSentenceCase(\n _lang(nbText.legends.adminSelections.country)\n ),\n admin1: Lang.toSentenceCase(\n _lang(nbText.legends.adminSelections.region)\n )\n },\n allLabels: {\n admin1: _lang(nbText.legends.adminSelections.allRegions),\n }\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2293,"value":"viewof as_i_admin0 = {\n return Inputs.select(asData_admin0, { label: _lang(nbText.legends.adminSelections.country), format: x => x.label });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2292,"value":"viewof as_i_admin1 = {\n return Inputs.select(asData_admin1, { label: _lang(nbText.legends.adminSelections.region), format: x => x.label });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":261,"value":"### General","pinned":false,"hidden":false,"mode":"md"},{"id":262,"value":"// alphabetic sort, nulls first\nsortByField = (a,b, {field}={}) => {\n // If a.name is null and b.name is not null, a should come first\n if (a[field] === null && b[field] !== null) return -1;\n // If b.name is null and a.name is not null, b should come first\n if (b[field] === null && a[field] !== null) return 1;\n // If both are null, they are equal\n if (a[field] === null && b[field] === null) return 0;\n // If neither is null, compare alphabetically\n if (a[field] < b[field]) return -1;\n if (a[field] > b[field]) return 1;\n return 0;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":265,"value":"// create where clause that handles null cases\nsqlWhereNull = ({value, field}={}) => {\n return value === null \n ? `and ${field} is null`\n : `and ${field} = '${value}'`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":266,"value":"refAdmin = {\n const lookup = (field) => _lang(nbText.legends.adminSelections?.[field])\n return {\n all: {\n admin0: lookup(\"allCountries\"),\n admin1: lookup(\"allRegions\"),\n basin: lookup(\"allBasins\")\n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":451,"value":"// get country or region name, passing object\ngetAdminSelection = (selections) => {\n if (selections.admin1.admin1_name) {\n return selections.admin1.admin1_name\n } else {\n return selections.admin0.admin0_name\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2833,"value":"getAdmin0WithAdmin1Parens = ({articleField=\"general\", showParens=true}={}) => {\n // getting admin0, with admin1 in parens\n // can specify admin0article lookup\n const a0 = as_i_admin0\n const a1 = as_i_admin1\n\n const a0WithArticle = _lang(country_translations?.[a0.iso3]?.[articleField])\n \n if (a1.admin1_name == null) return a0WithArticle\n if (!showParens) return a0WithArticle\n return `${a0WithArticle} (${a1.label})`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":572,"value":"inputTemplate = ({ gap = \"2em\" } = {}) => {\n // template for input display\n return (inputs) => html`

${inputs}

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2482,"value":"function hideTableCheckboxes(tbl) {\n // hide the checkboxes from an Observable Table Input\n // Ex. tbl = Inputs.table(penguins)\n\n tbl.append(\n htl.html`\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3332,"value":"import {buildInlineDownloadButton} from \"1bda5f9b60c64223\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":3405,"value":"ptot_na = FileAttachment(\"ptot_na.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":6897,"value":"daaata = db.query(`\n select iso3\n , year\n , \"group\"\n , sub_group\n , ha\n from ${dataTable.factsSummaryTable_land.name}\n where 1=1\n -- and sub_group is not null\n and year = (select max(year) from ${dataTable.factsSummaryTable_land.name})\n`)","pinned":true,"hidden":false,"mode":"ojs"},{"id":6903,"value":"new Set(daaata.map((d) => d.year))","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W4a","stdlib":"1"}