1d:{"title":"Explore the Datasets","cells":[{"id":5795,"value":"heroImage = {\n const imgSource = {\n en: FileAttachment(\"explore-the-datasets_hero.webp\").url(),\n am: FileAttachment(\"explore-the-datasets_hero.webp\").url(),\n or: FileAttachment(\"explore-the-datasets_hero.webp\").url(),\n ti: FileAttachment(\"explore-the-datasets_hero.webp\").url(),\n so: FileAttachment(\"explore-the-datasets_hero.webp\").url(),\n af: FileAttachment(\"explore-the-datasets_hero.webp\").url(),\n };\n const imgUrl = _lang(imgSource);\n return htl.html`

${notebookTitle}

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4594,"value":"viewof prettyLanguageView = {\n return Inputs.bind(\n Inputs.radio(languages, {\n label: _lang({en: \"Language\", fr: \"Langue\"}),\n format: (d) => d.label\n }),\n viewof language\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4571,"value":"tocOneliner({\n heading: `${_lang(nbText.toc.title)}`,\n skip: [notebookTitle, \"Appendix\"]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":3829,"value":"# ${_lang(nbText.overview.title)}\n\n_${_lang(nbText.overview.subTitle)}_\n\n${_lang(nbText.overview.text)}\n","pinned":false,"hidden":false,"mode":"md"},{"id":5774,"value":"# ${_lang(nbText.selectCategory.title_main)}","pinned":false,"hidden":false,"mode":"md"},{"id":3613,"value":"### ${_lang(nbText.selectCategory.title)}\n${_lang(nbText.selectCategory.text)}","pinned":false,"hidden":false,"mode":"md"},{"id":263,"value":"viewof atlas_cat = Inputs.radio([\"Hazard\", \"Exposure\", \"Vulnerability\"], {\n label: _lang(nbText.selectCategory.selector.title),\n value: \"Hazard\",\n format: (l) => _lang(nbText.selectCategory.selector.options[l].title)\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1239,"value":"{\n return md`${_lang(nbText.selectCategory.selector.options[atlas_cat].description)}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4113,"value":"### ${_lang(nbText.selectVars.title)}\n${_lang(nbText.selectVars.text)}","pinned":false,"hidden":false,"mode":"md"},{"id":1585,"value":"definitions = create_definitions(atlas_cat)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1248,"value":"$1f","pinned":false,"hidden":false,"mode":"ojs"},{"id":3625,"value":"### ${_lang(nbText.selectGeog.title)}\n${_lang(nbText.selectGeog.text)}","pinned":false,"hidden":false,"mode":"md"},{"id":269,"value":"viewof admin_aggregationLevel ={\n // Include admin3_name (Woreda) only for Ethiopia\n const admin_choices = country === \"Ethiopia\" \n ? [\"admin0_name\", \"admin1_name\", \"admin2_name\", \"admin3_name\"]\n : [\"admin0_name\", \"admin1_name\", \"admin2_name\"];\n\n let radio = Inputs.radio(admin_choices, {\n label: _lang(nbText.selectGeog.selectors.aggregationLvl.title),\n value: \"admin0_name\",\n format: (l) => _lang(nbText.selectGeog.selectors.aggregationLvl.options[l])\n });\n let selectors = radio.querySelectorAll(\"input[name=input]\");\n let labels = radio.querySelectorAll(\"label\");\n if (selectors && selectors[2] && country === \"SSA\") {\n selectors[2].title = _lang(\n nbText.selectGeog.selectors.aggregationLvl.warning\n );\n }\n if (labels && labels[2] && country === \"SSA\") {\n labels[3].title = _lang(nbText.selectGeog.selectors.aggregationLvl.warning);\n labels[3].style.color = \"#b8310f\";\n }\n return radio;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":266,"value":"$20","pinned":false,"hidden":false,"mode":"ojs"},{"id":3631,"value":"# ${_lang(nbText.ViewExplore.title)}\n${_lang(nbText.ViewExplore.text)}","pinned":false,"hidden":false,"mode":"md"},{"id":295,"value":"viewof previewType = Inputs.radio([\"Map\", \"Table\", \"Plot\"], {\n //, \"Interactive Map\",\n // Icons to these would be pretty\n value: \"Map\",\n label: _lang(nbText.ViewExplore.selectors.preview.title),\n format: (l) => _lang(nbText.ViewExplore.selectors.preview.options[l])\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1233,"value":"$21","pinned":false,"hidden":false,"mode":"ojs"},{"id":332,"value":"{\n if (previewType === \"Map\") {\n return html`

${map()}

`;\n // } else if (previewType === \"Interactive Map\") {\n // return html`

${MapInfo.MapLegend}

${MapContainer}

`;\n } else if (previewType === \"Table\") {\n return html`

${createTable()}

`;\n } else if (previewType === \"Plot\") {\n // return html`

${container2}

`;\n return html`

${await createPlot()}

`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":6568,"value":"$22","pinned":false,"hidden":false,"mode":"ojs"},{"id":4000,"value":"# ${_lang(nbText.download.title)}","pinned":false,"hidden":false,"mode":"md"},{"id":1389,"value":"viewof download_format = {\n // let downlaod_options;\n let download_options = [\"Parquet\", \"CSV\", \"JSON\"]; //, \"GEOPARQUET\", \"GEOJSON\"];\n\n // if (download_dataChoice.includes(\"Admin Boundaries\")) {\n // downlaod_options = [\"GEOPACKAGE\", \"GEOPARQUET\", \"GEOJSON\"];\n // } else {\n // downlaod_options = [\"PARQUET\", \"CSV\"];\n // }\n\n return Inputs.radio(download_options, {\n label: _lang(nbText.download.selector.title),\n value: \"Parquet\"\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1860,"value":"html`

${download_button_initiate()}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3997,"value":"### ${_lang(nbText.download.boundaries.title)}","pinned":false,"hidden":false,"mode":"md"},{"id":4011,"value":"download_spatial_button()","pinned":false,"hidden":false,"mode":"ojs"},{"id":3096,"value":"# ${_lang(nbText.STAC.title)}\n\n${_lang(nbText.STAC.text)}","pinned":false,"hidden":false,"mode":"md"},{"id":4168,"value":"viewof codeLanguage = Inputs.radio([\"R\", \"Python\", \"NoCode\"], {\n label: \"Language\",\n value: \"NoCode\",\n format: l => _lang(nbText.general[l]) || l\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":4166,"value":"$23","pinned":false,"hidden":false,"mode":"ojs"},{"id":5831,"value":"# ${_lang(nbText.methods_sources.title)}","pinned":false,"hidden":false,"mode":"md"},{"id":5839,"value":"## ${_lang(nbText.methods_sources.datasets.title)}","pinned":false,"hidden":false,"mode":"md"},{"id":5851,"value":"### ${_lang(nbText.methods_sources.datasets.boundaries.title)}\n${_lang(nbText.methods_sources.datasets.boundaries.text)}","pinned":false,"hidden":false,"mode":"md"},{"id":5884,"value":"### ${_lang(nbText.methods_sources.datasets.Hazards.title)}\n${_lang(nbText.methods_sources.datasets.Hazards.text)}\n","pinned":false,"hidden":false,"mode":"md"},{"id":5863,"value":"### ${_lang(nbText.methods_sources.datasets.exposureDS.title)}","pinned":false,"hidden":false,"mode":"md"},{"id":5867,"value":"#### ${_lang(nbText.methods_sources.datasets.exposureDS.vopHA.title)}\n${_lang(nbText.methods_sources.datasets.exposureDS.vopHA.text)}","pinned":false,"hidden":false,"mode":"md"},{"id":5856,"value":"#### ${_lang(nbText.methods_sources.datasets.exposureDS.population.title)}\n${_lang(nbText.methods_sources.datasets.exposureDS.population.text)}","pinned":false,"hidden":false,"mode":"md"},{"id":5872,"value":"### ${_lang(nbText.methods_sources.datasets.acDS.title)}","pinned":false,"hidden":false,"mode":"md"},{"id":5874,"value":"#### ${_lang(nbText.methods_sources.datasets.acDS.FemaleWellbeing.title)}\n ${_lang(nbText.methods_sources.datasets.acDS.FemaleWellbeing.text)}","pinned":false,"hidden":false,"mode":"md"},{"id":5889,"value":"#### ${_lang(nbText.methods_sources.datasets.acDS.poverty.title)}\n${_lang(nbText.methods_sources.datasets.acDS.poverty.text)}","pinned":false,"hidden":false,"mode":"md"},{"id":9,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":14,"value":"## Imports","pinned":false,"hidden":false,"mode":"md"},{"id":43,"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":3639,"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":471,"value":"$24","pinned":false,"hidden":false,"mode":"ojs"},{"id":3725,"value":"$25","pinned":false,"hidden":false,"mode":"ojs"},{"id":3729,"value":"CheckORAdd_VulnTable = async (db) => {\n let tables = await db.describeTables().then((r) => r.map((d) => d.name));\n if (!tables.includes(\"Vulnerability\")) {\n await db.query(`\n CREATE VIEW Vulnerability AS\n SELECT *\n FROM read_parquet('${s3Paths[\"Vulnerability\"]}')\n `);\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":353,"value":"import { ScrollingMultiSelect_collapsible } from \"@brayden-youngberg/scrolling-multi-select\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1454,"value":"turfRewind = require(\"@turf/turf\").then((t) => t.rewind)","pinned":false,"hidden":false,"mode":"ojs"},{"id":3797,"value":"import { resolveWindowsCacheIssue } from \"72281be2f13a0a72\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":381,"value":"## Notebook Variables","pinned":false,"hidden":false,"mode":"md"},{"id":4569,"value":"notebookTitle = \"Explore the Datasets\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1533,"value":"timePeriod_dict = new Object({\n \"historic\": \"Baseline\",\n \"2021_2040\": \"2040\",\n \"2041_2060\": \"2060\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":473,"value":"$26","pinned":false,"hidden":false,"mode":"ojs"},{"id":387,"value":"merged_scale = [\"#EC5A47\", \"#ffb347\", \"#F7D732\", \"#a3ab2e\"].reverse()","pinned":false,"hidden":false,"mode":"ojs"},{"id":384,"value":"$27","pinned":false,"hidden":false,"mode":"ojs"},{"id":3314,"value":"vulnerability_dict = new Object({\n gender: {\n domestic_violence: \"Lack of Domestic Violence\",\n gender_equity: \"Gender Equity\", // leaving out the 1995-2015 equity index, as the rest of the AC vars are from ~2015, which is this\n decision_making: \"Decision Making Power\",\n education: \"Womens Education\",\n family_planning: \"Access to Family Planning\",\n reproductive_health: \"Reproductive Health\"\n },\n poverty: {\n GSAP_poor215: \"% under $2.15 poverty line\",\n GSAP_poor365: \"% under $3.65 poverty line\",\n GSAP_poor685: \"% under $6.85 poverty line\"\n },\n education: {\n educationYrs: \"Education(Yrs)\"\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1107,"value":"plotQuery_admin = {\n if (country === \"SSA\") {\n return `WHERE admin1_name IS NULL`;\n } else if (country !== \"SSA\" && admin1_sel === \"Full Country\") {\n return `WHERE admin0_name = '${country}' AND admin1_name IS NULL`;\n } else if (admin1_sel !== \"Full Country\" && admin2_sel === \"Full Region\") {\n return `WHERE admin0_name = '${country}' AND admin1_name = ${admin1_sel}`;\n } else if (admin2_sel !== \"Full Region\") {\n return `Where admin admin0_name = '${country}' AND admin1_name = ${admin1_sel} AND admin2_name = ${admin2_sel}`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1305,"value":"$28","pinned":false,"hidden":false,"mode":"ojs"},{"id":5290,"value":"plotQuery2_admin = {\n if (country === \"SSA\") {\n return `WHERE admin1_name IS NULL`;\n } else if (country !== \"SSA\" && admin1_sel === \"Full Country\") {\n return `WHERE admin0_name = '${country}' AND admin1_name IS NOT NULL AND admin2_name IS NULL`;\n } else if (admin1_sel !== \"Full Country\" && admin2_sel === \"Full Region\") {\n return `WHERE admin0_name = '${country}' AND admin1_name = '${admin1_sel}' AND admin2_name IS NOT NULL`;\n } else if (admin2_sel !== \"Full Region\") {\n return `WHERE admin0_name = '${country}' AND admin1_name = '${admin1_sel}' AND admin2_name = '${admin2_sel}'`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1311,"value":"$29","pinned":false,"hidden":false,"mode":"ojs"},{"id":465,"value":"$2a","pinned":false,"hidden":false,"mode":"ojs"},{"id":6098,"value":"map_data_mock = {\n if (admin_aggregationLevel !== \"admin3_name\") return null;\n \n let result = null;\n if (atlas_cat === \"Hazard\") {\n result = mockWoredaHazardData;\n } else if (atlas_cat === \"Exposure\") {\n result = mockWoredaExposureData;\n } else if (atlas_cat === \"Vulnerability\") {\n result = mockWoredaVulnerabilityData;\n }\n \n // Focused debug: Only check Ethiopia > Tigray > North Western\n if (Array.isArray(result) && result.length > 0) {\n const ethTigrayNW = result.filter(d => \n d.admin0_name === \"Ethiopia\" && \n d.admin1_name === \"Tigray\" && \n d.admin2_name === \"North Western\"\n );\n \n if (ethTigrayNW.length > 0) {\n console.log(\"🟢 [map_data_mock] Ethiopia/Tigray/North Western:\", {\n totalRows: ethTigrayNW.length,\n sampleRow: {\n admin3_name: ethTigrayNW[0].admin3_name,\n value: ethTigrayNW[0].value,\n allKeys: Object.keys(ethTigrayNW[0])\n }\n });\n }\n }\n \n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":6101,"value":"mockWoredaData = \n{\n try {\n const data = await FileAttachment(\"mock_woreda_population_data.csv\").csv();\n return data.filter(d => {\n if (country && d.admin0_name !== country) return false;\n if (admin1_sel && admin1_sel !== \"Full Country\" && d.admin1_name !== admin1_sel) return false;\n if (admin2_sel && admin2_sel !== \"Full Region\" && d.admin2_name !== admin2_sel) return false;\n if (admin3_sel && admin3_sel !== \"All Woredas\" && d.admin3_name !== admin3_sel) return false;\n return true;\n });\n } catch (error) {\n console.error(\"Error loading mock woreda population data:\", error);\n return [];\n }\n}\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":6104,"value":"$2b","pinned":false,"hidden":false,"mode":"ojs"},{"id":6107,"value":"$2c","pinned":false,"hidden":false,"mode":"ojs"},{"id":6110,"value":"mockWoredaVulnerabilityData = \n{\n if (admin_aggregationLevel !== \"admin3_name\") return [];\n \n try {\n const data = await FileAttachment(\"mock_woreda_vulnerability_data.csv\").csv();\n \n return data.filter(d => {\n if (country && d.admin0_name !== country) return false;\n if (admin1_sel && admin1_sel !== \"Full Country\" && d.admin1_name !== admin1_sel) return false;\n if (admin2_sel && admin2_sel !== \"Full Region\" && d.admin2_name !== admin2_sel) return false;\n if (admin3_sel && admin3_sel !== \"All Woredas\" && d.admin3_name !== admin3_sel) return false;\n if (ac_cat && d.group !== ac_cat) return false;\n if (ac_subcat && d.variable !== ac_subcat) return false;\n return true;\n });\n } catch (error) {\n console.error(\"Error loading mock woreda vulnerability data:\", error);\n return [];\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3875,"value":"$2d","pinned":false,"hidden":false,"mode":"ojs"},{"id":6310,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs"},{"id":467,"value":"\n// admin_index = {return(\n// NbData[\"map_data\"] && NbData[\"map_data\"].length > 0\n// ? d3.index(\n// NbData[\"map_data\"],\n// (d) => d.admin0_name,\n// (d) => d.admin1_name,\n// (d) => d.admin2_name,\n// (d) => d.admin3_name || null\n// )\n// : new Map()\n// )}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1126,"value":"crop_groups = new Object({\n cattle: [\"cattle_tropical\", \"cattle_highland\"],\n poultry: [\"poultry_tropical\", \"poultry_highland\"],\n pigs: [\"pigs_tropical\", \"pigs_highland\"],\n \"Small Ruminants\": [\n \"sheep_tropical\",\n \"sheep_highland\",\n \"goats_tropical\",\n \"goats_highland\"\n ],\n rootsTuber: [\"potato\", \"sweet potato\", \"yams\", \"cassava\"],\n cereals: [\n \"wheat\",\n \"rice\",\n \"maize\",\n \"barley\",\n \"pearl millet\",\n \"small millet\",\n \"sorghum\"\n ],\n legumes: [\n \"bean\",\n \"chickpea\",\n \"cowpea\",\n \"pigeonpea\",\n \"lentil\",\n \"groundnut\",\n \"soybean\"\n ],\n fruitVeg: [\"plantain\", \"coconut\", \"banana\"],\n nonEdible: [\n \"cocoa\",\n \"rapeseed\",\n \"sesameseed\",\n \"oilpalm\",\n \"cotton\",\n \"tea\",\n \"tobacco\",\n \"arabica coffee\",\n \"sunflower\",\n \"sugarcane\",\n \"sugarbeet\",\n \"robusta coffee\"\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1167,"value":"## Format helpers","pinned":false,"hidden":false,"mode":"md"},{"id":1169,"value":"formatDollar = new Intl.NumberFormat(\"en-US\", {\n notation: \"compact\",\n compactDisplay: \"short\",\n style: \"currency\",\n currency: \"usd\"\n}).format","pinned":false,"hidden":false,"mode":"ojs"},{"id":4296,"value":"formatBigNums = new Intl.NumberFormat(\"en-US\", {\n notation: \"compact\",\n compactDisplay: \"short\"\n}).format","pinned":false,"hidden":false,"mode":"ojs"},{"id":1404,"value":"function format_val(val, unit) {\n switch (unit) {\n case \"dollar\":\n return formatDollar(val);\n case \"total\":\n return formatBigNums(val);\n case \"total_ha\":\n return `${formatBigNums(val)} /ha`;\n case \"index\":\n return val.toFixed(2);\n case \"percent\":\n return `${(val * 100).toFixed(2)}%`;\n case \"percent_NoDecimal\":\n return `${(val * 100).toFixed(0)}%`;\n default:\n if (typeof unit === 'number') {\n return (val * unit).toFixed(1);\n }\n return val; // Default case if unit doesn't match any condition\n }\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":1407,"value":"var_unit = {\n if (atlas_cat === \"Hazard\") {\n const clean_haz = hazard_sel.split(\"_\")[0];\n return unit_dict[atlas_cat][clean_haz];\n }\n\n if (atlas_cat === \"Exposure\") {\n if (exposure_var === \"vop\") {\n return unit_dict[atlas_cat][exposure_var];\n } else if (exposure_cat === \"Population\") {\n return unit_dict[atlas_cat][\"populationTotal\"];\n } else {\n const clean_var = exposure_var;\n const full_var = exposure_cat.toLowerCase() + clean_var;\n return unit_dict[atlas_cat][full_var]; //.toLowerCase()\n }\n }\n\n if (atlas_cat === \"Vulnerability\") {\n return unit_dict[atlas_cat][ac_cat];\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1410,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":1722,"value":"## Download Helpers","pinned":false,"hidden":false,"mode":"md"},{"id":1396,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":1522,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":1526,"value":"async function downloadSpatial( // The issue with this one is that it needs to be long format somehow...\n file_name,\n file_ext,\n download_format,\n full_name\n) {\n if (download_format === \"PARQUET\") {\n \n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4009,"value":"download_spatial_button = () => {\n let adm_level = admin_aggregationLevel.match(/\\d+/)[0];\n let downloadBlob = new Blob([JSON.stringify(adminLevel_spatial)], {\n type: \"application/geo+json\"\n });\n let size = (downloadBlob.size / 1000000).toFixed(0);\n let url = URL.createObjectURL(downloadBlob);\n\n let button_template = _lang(nbText.download.boundaries.button)\n let btn_txt = Lang.reduceReplaceTemplateItems(button_template, [{name:\"adminLvl\", value:adm_level }])\n \n\n let downloadButton = html`${btn_txt}`;\n return downloadButton;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1852,"value":"download_metadata_button = () => {\n let downloadBlob = new Blob([\",\"], {\n type: \"text/csv\"\n });\n let size = (downloadBlob.size / 1000000).toFixed(0);\n let url = URL.createObjectURL(downloadBlob);\n\n let downloadButton = html`Download Metadata`;\n return downloadButton;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"## Geography","pinned":false,"hidden":false,"mode":"md"},{"id":1415,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":88,"value":"admin0_load = { \n // Admin 2 is a geojson so that initial page load can be faster(not wait for DB setup)\n let geojson = await FileAttachment(\n \"atlas-region_admin0_simplified.geojson\"\n ).json();\n let a0_names = geojson.features.map((d) => d.properties.admin0_name);\n mutable admin0_names = [\"SSA\"].concat(a0_names);\n return geojson;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1006,"value":"admin0_filtered = {\n if (country !== \"SSA\") {\n let filtered = admin0_load.features.filter((d) => {\n return d.properties.admin0_name === country;\n });\n // Create a new GeoJSON object with the filtered features\n return {\n type: admin0_load.type,\n features: filtered\n };\n } else {\n return admin0_load;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":97,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":6116,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":1089,"value":"append_a2Names = {\n if (!country || country === \"SSA\" || !admin1_sel || admin1_sel === \"Full Country\") {\n mutable admin2_names = [\"Full Region\"];\n return [\"Full Region\"];\n }\n \n let response = await geo_db.query(`\n SELECT admin2_name\n FROM admin2_geom\n where admin0_name = '${country}' and admin1_name = '${admin1_sel}'`);\n let a2_names = response.map((d) => d.admin2_name);\n mutable admin2_names = [\"Full Region\"].concat(a2_names);\n return a2_names;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":6119,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"id":24,"value":"### Geography Selectors","pinned":false,"hidden":false,"mode":"md"},{"id":6462,"value":"mutable admin0_names = [\"Ethiopia\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":130,"value":"mutable admin1_names = [\"Full Country\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":132,"value":"mutable admin2_names = [\"Full Region\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":6087,"value":"mutable admin3_names = [\"All Woredas\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"viewof country = {\n const country = Inputs.select(admin0_names, {\n label: \"Select Country\"\n });\n return country;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":62,"value":"viewof admin1_sel = Inputs.select(admin1_names, { label: \"admin1\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":65,"value":"viewof admin2_sel = Inputs.select(admin2_names, { label: \"admin2\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":6092,"value":"viewof admin3_sel = Inputs.select(admin3_names, { label: \"Woreda\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":365,"value":"## Selector Forms","pinned":false,"hidden":false,"mode":"md"},{"id":367,"value":"### Hazard","pinned":false,"hidden":false,"mode":"md"},{"id":372,"value":"viewof hazard_sel = Inputs.select(\n // Inputs.select(\n // new Map(\n // DataSelector_form.hazardGroup_form.hazard_sel.map((value) => [\n // hazard_dict[value].name,\n // value\n // ])\n // ),\n // { label: \"Hazard\" }\n // ),\n new Map(Object.entries(hazard_dict).map(([key, value]) => [value.name, key])),\n { label: \"Hazard\" } //, format: ([name]) => `${name}`\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":374,"value":"viewof time_sel = Inputs.select(\n new Map([\n [\"Baseline\", \"historic\"],\n [\"2040\", \"2021_2040\"],\n [\"2060\", \"2041_2060\"]\n ]),\n { label: \"Time Period\", value: \"historic\" } //, format: ([name]) => `${name}`\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":376,"value":"viewof ssp_sel = {\n const choices = time_sel === \"historic\" ? [\"Historic\"] : [\"SSP245\", \"SSP585\"];\n return Inputs.select(choices, { label: \"Scenario\" });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":391,"value":"### Adaptive Capacity","pinned":false,"hidden":false,"mode":"md"},{"id":393,"value":"viewof ac_cat = Inputs.select([\"Education\", \"Poverty\", \"Gender\"], {\n // value: \"Poverty\",\n label: \"Adaptive Capacity\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":396,"value":"viewof ac_subcat = {\n let subcats;\n if (ac_cat === \"Gender\") {\n subcats = new Map(\n Object.entries(vulnerability_dict[\"gender\"]).map(([key, value]) => [\n value,\n key\n ])\n );\n } else if (ac_cat === \"Poverty\") {\n subcats = new Map(\n Object.entries(vulnerability_dict[\"poverty\"]).map(([key, value]) => [\n value,\n key\n ])\n );\n } else {\n subcats = [];\n }\n return Inputs.select(subcats, {\n label: `${ac_cat} Category`\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":403,"value":"## Exposure","pinned":false,"hidden":false,"mode":"md"},{"id":407,"value":"viewof exposure_cat = Inputs.select([\"Crop\", \"Livestock\", \"Population\"], {\n value: \"Crop\",\n label: \"Exposure Category\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":412,"value":"commodities = new Object({\n Crop: [\n \"wheat\",\n \"rice\",\n \"maize\",\n \"barley\",\n \"pearl millet\",\n \"small millet\",\n \"sorghum\",\n \"potato\",\n \"sweet potato\",\n \"yams\",\n \"cassava\",\n \"bean\",\n \"chickpea\",\n \"cowpea\",\n \"pigeonpea\",\n \"lentil\",\n \"soybean\",\n \"groundnut\",\n \"coconut\",\n \"oilpalm\",\n \"sunflower\",\n \"rapeseed\",\n \"sesameseed\",\n \"sugarcane\",\n \"sugarbeet\",\n \"cotton\",\n \"arabica coffee\",\n \"robusta coffee\",\n \"cocoa\",\n \"tea\",\n \"tobacco\",\n \"banana\",\n \"plantain\",\n \"teff\",\n \"teff_001\",\n \"teff_002\",\n \"enset\"\n ],\n Livestock: [\n \"cattle_tropical\",\n \"poultry_tropical\",\n \"pigs_tropical\",\n \"sheep_tropical\",\n \"goats_tropical\",\n \"cattle_highland\",\n \"poultry_highland\",\n \"pigs_highland\",\n \"sheep_highland\",\n \"goats_highland\",\n \"Donkey (highland)\",\n \"donkey\",\n \"camel\",\n \"camel_001\",\n \"camel_002\"\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":410,"value":"viewof exposure_subCat ={\n let title;\n let selections;\n if (exposure_cat === \"Population\") {\n title = \"Population Group\";\n selections = new Map([\n [\"Total Population\", \"total_pop\"],\n [\"Rural Population\", \"rural_pop\"],\n [\"Urban Population\", \"urban_pop\"]\n ]);\n } else {\n title = \"Commodity\";\n selections = commodities[exposure_cat];\n }\n\n return Inputs.select(selections, {\n label: title\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":405,"value":"exposure_var_choices = {\n let choices;\n if (exposure_cat === \"Population\") {\n choices = [\n \"total_pop\",\n \"rural_pop\",\n \"urban_pop\"\n // { name: \"Total Population\", variable: \"total_pop\" },\n // { name: \"Rural Population\", variable: \"rural_pop\" },\n // { name: \"Urban Population\", variable: \"urban_pop\" }\n ]; //add density to raster\n } else if (exposure_cat === \"Crop\") {\n choices = [\n 'vop',\n 'ha'\n // { name: \"Value of Production\", variable: \"vop\" },\n // { name: \"Harvested Area\", variable: \"ha\" }\n ];\n } else {\n choices = [\n 'vop',\n 'number'\n // { name: \"Value of Production\", variable: \"vop\" },\n // { name: \"Number of Animals\", variable: \"number\" }\n ];\n }\n return choices;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":418,"value":"viewof exposure_var = {\n return Inputs.select(exposure_var_choices, {\n label: \"Variable\",\n format: (t) => _lang(nbText.ViewExplore.selectors.visualiseVars.exposure.exposureVariable.options[t])\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":429,"value":"## Map Setup","pinned":false,"hidden":false,"mode":"md"},{"id":1710,"value":"### D3 map ","pinned":false,"hidden":false,"mode":"md"},{"id":1402,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":1564,"value":"## Definition boxes","pinned":false,"hidden":false,"mode":"md"},{"id":4694,"value":"create_definitions = (category) => {\n let def_text = _lang(definitionText[category].text)\n return html`

${_lang(definitionText[category].title)}

\n${md`${def_text}`}\n

`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1447,"value":"## Plot Functions","pinned":false,"hidden":false,"mode":"md"},{"id":1845,"value":"function createPlot() {\n if (atlas_cat === \"Exposure\") {\n if (exposure_cat.includes(\"Livestock\") || exposure_cat.includes(\"Crop\")) {\n return exposure_treeplot();\n } else if (exposure_cat === \"Population\") {\n return population_stackbars();\n }\n } else if (atlas_cat === \"Hazard\") {\n return hazard_stackBar(hazard_sel);\n } else if (atlas_cat === \"Vulnerability\") {\n return parallelCoordinatesScatterPlot();\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1849,"value":"createTable = () => {\n let table = Inputs.table(data_to_visualise, {\n rows: 25,\n maxWidth: \"1000px\"\n });\n const style = document.createElement(\"style\");\n style.innerHTML = `\n .exploreTable th {\n background-color: lightgrey !important;\n }\n .exploreTable tr:nth-child(odd) {\n background: #f2f2f2!important;\n }\n .exploreTable td {\n padding-left: 15px !important;\n }\n `;\n table.classList.add(\"exploreTable\");\n table.appendChild(style);\n\n const checkboxes = table.querySelectorAll('table input[type=\"checkbox\"]');\n\n // Remove all checkboxes\n checkboxes.forEach(function (checkbox) {\n checkbox.parentNode.removeChild(checkbox);\n });\n \n return table;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1451,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":2480,"value":"$39","pinned":false,"hidden":false,"mode":"ojs"},{"id":2462,"value":"function classifyAndCount(data) {\n const result = {};\n\n // Helper function to classify a number based on thresholds\n function classifyNumber(number, thresholds) {\n for (let i = 0; i < thresholds.length; i++) {\n if (number < thresholds[i]) {\n return i;\n }\n }\n return thresholds.length;\n }\n\n data.forEach((row) => {\n const { admin0_name, scenario, timeframe, hazard, value } = row;\n const thresholds = hazard_dict[hazard].thresholds;\n if (!thresholds) {\n console.error(`No thresholds found for hazard: ${hazard}`);\n return;\n }\n const classification = classifyNumber(value, thresholds);\n\n if (!result[hazard]) {\n result[hazard] = {};\n }\n if (!result[hazard][scenario]) {\n result[hazard][scenario] = {};\n }\n if (!result[hazard][scenario][timeframe]) {\n result[hazard][scenario][timeframe] = Array(thresholds.length + 1).fill(\n 0\n );\n }\n\n result[hazard][scenario][timeframe][classification]++;\n });\n\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3018,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs"},{"id":2158,"value":"function format_slopeData(data) {\n const order = [\"historic\", \"2021_2040\", \"2041_2060\"];\n\n const admin_grouped = Array.from(\n d3.group(data, (d) => d[\"hazard\"]),\n ([admin_name, values]) => {\n values.sort(\n (a, b) => order.indexOf(a.timeframe) - order.indexOf(b.timeframe)\n );\n return {\n admin_name,\n values: values.map(({ timeframe, scenario, value, percentChange }) => ({\n timeframe,\n scenario,\n value,\n percentChange\n }))\n };\n }\n );\n return admin_grouped;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2139,"value":"calculatePercentChange = (data) => {\n const baseline = {};\n \n // Find historic baseline values\n for (const row of data) {\n if (row.scenario === \"historic\" && row.timeframe === \"historic\") {\n baseline[row.hazard] = row.admin_mean;\n }\n }\n\n const results = [];\n for (const row of data) {\n const hazard = row.hazard;\n const scenario = row.scenario;\n const timeframe = row.timeframe;\n const value = row.admin_mean;\n const baselineValue = baseline[hazard];\n\n // Check if baseline value exists\n if (baselineValue !== undefined && scenario !== \"historic\") {\n const change = value - baselineValue;\n const percentChange = (change / baselineValue) * 100;\n results.push({ hazard, scenario, timeframe, value, percentChange });\n } else {\n results.push({ hazard, scenario, timeframe, value, percentChange: null });\n }\n }\n\n return results;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2280,"value":"function scaleHazardValue(value, minValue, maxValue) {\n const thresholds = hazard_dict[\"HSH_max\"][\"thresholds\"];\n\n // Calculate the range between the minimum and maximum values\n const range = maxValue - minValue;\n\n // Determine the scale based on thresholds\n if (value <= thresholds[0]) {\n return 1;\n } else if (value <= thresholds[1]) {\n return Math.ceil(\n 1 + ((value - thresholds[0]) / (thresholds[1] - thresholds[0])) * 2\n );\n } else if (value <= thresholds[2]) {\n return Math.ceil(\n 4 + ((value - thresholds[1]) / (thresholds[2] - thresholds[1])) * 3\n );\n } else if (value <= thresholds[3]) {\n return Math.ceil(\n 7 + ((value - thresholds[2]) / (thresholds[3] - thresholds[2])) * 3\n );\n } else {\n return 10;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3186,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs"},{"id":5263,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs"},{"id":5636,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs"},{"id":120,"value":"## Styling","pinned":false,"hidden":false,"mode":"md"},{"id":123,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs"},{"id":1474,"value":"TooltipCSS = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":4565,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs"},{"id":4687,"value":"## Language and Translation tools","pinned":false,"hidden":false,"mode":"md"},{"id":4577,"value":"import {Lang} from \"7d46679f7d0d917e\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":4579,"value":"_lang = Lang.lg(language.key)","pinned":false,"hidden":false,"mode":"ojs"},{"id":4581,"value":"languages = [\n { key: \"en\", label: \"English\", locale: 'en-US' },\n { key: \"am\", label: \"አማርኛ\", locale: 'am-ET' },\n {key: \"or\", label: \"Afaan Oromoo\", locale: 'or-ET'},\n {key: \"ti\", label: \"ትግርኛ\", locale: 'ti-ET'},\n {key: \"so\", label: \"Soomaali\", locale: 'so-ET'},\n {key: \"af\", label: \"Qafar af\", locale: 'af-ET'}\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":4583,"value":"defaultLangKey = {\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":4585,"value":"viewof 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":6539,"value":"$40","pinned":false,"hidden":false,"mode":"ojs"},{"id":6542,"value":"$41","pinned":false,"hidden":false,"mode":"ojs"},{"id":6545,"value":"$42","pinned":false,"hidden":false,"mode":"ojs"},{"id":6548,"value":"$43","pinned":false,"hidden":false,"mode":"ojs"},{"id":4690,"value":"$44","pinned":false,"hidden":false,"mode":"ojs"},{"id":6257,"value":"$45","pinned":false,"hidden":false,"mode":"ojs"},{"id":6294,"value":"mockCropsLivestock={return(\n{\n crops: [\"teff\", \"teff_001\", \"teff_002\", \"enset\"],\n livestock: [\"Donkey (highland)\", \"donkey\", \"camel\", \"camel_001\", \"camel_002\"]\n\n}\n)}","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W46","stdlib":"1"}