25:["$","title",null,{"children":"Trase explainer: Indo palm oil - Importer country ZDC coverage (metric selection fix) (CN) | Trase | Observable"}] 49:T820,chart = { const id = DOM.uid("chart").id; const svg = d3 .create("svg") .attr("class", id) .attr("viewBox", [0, 0, width, height]) .call((svg) => svg.append("defs").html(fonts(`.${id}`))); const g = svg.append("g").attr("text-anchor", "middle"); let text = g.selectAll("text"); const tooltip = new Tooltip(); svg.append(() => tooltip.node); const t = svg.transition().duration(800); const root = pack( d3 .hierarchy({ children: data.sort((a, b) => b[selected_value] - a[selected_value]) }) .sum((d) => d[selected_value]) ); const thresholds = [0.005, 0.025, 0.05, 0.1, 0.8].map((d) => Math.floor(d * d3.max(data, (d) => d[selected_value])) ); const colour = d3.scaleThreshold().domain(thresholds).range(colourScheme); let circles = g .selectAll("circle") .data(root.leaves(), (d) => d.data.key) .join("circle") .attr("cx", (d) => d.x) .attr("cy", (d) => d.y) .attr("r", (d) => d.r) .attr("fill", (d) => colourSchemeZdc(d)); text = g .selectAll("text") .data(root.leaves(), (d) => d.data.key) .join("text") .attr("transform", (d) => `translate(${d.x}, ${d.y})`) .style("fill", (d) => { const bgColor = colourSchemeZdc(d); return pickTextColorBasedOnBackground(bgColor); }) .selectAll("tspan") .data((d) => formatBubbleText(d)) .join("tspan") .attr("x", 0) .attr("y", (d, i, nodes) => i === nodes.length - 1 ? `${i - nodes.length / 2 + 1.1}em` : `${i - nodes.length / 2 + 0.8}em` ) .attr("fill-opacity", (d, i, nodes) => i === nodes.length - 1 ? 0.7 : null ) .style("font", (d, i, nodes) => i === nodes.length - 1 ? "14px var(--trase-mono)" : "bold 18px var(--trase-sans-serif)" ) .style("letter-spacing", (d, i, nodes) => i === nodes.length - 1 ? "0.03em" : null ) .text((d) => d) .style("pointer-events", "none"); svg.append("g").call(annotate); circles.call(hover, svg, selected_value); return svg.node(); }4a:[{"id":"f99ac5cae2cc6dfb1ec87391a391a947b27bae52d3db72736cb2933c159528c5977f04e8114ad9358f2e74a2a7aac8bf3d3a2c6a256c46d9c2c89c612d28e939","href":"https://static.observableusercontent.com/files/f99ac5cae2cc6dfb1ec87391a391a947b27bae52d3db72736cb2933c159528c5977f04e8114ad9358f2e74a2a7aac8bf3d3a2c6a256c46d9c2c89c612d28e939","name":"id_palm_zdc_shr_vols_imp_ctry_1_2_2@2.csv","type":"text/csv","lastModified":1730124777961.244,"size":17668}] 29:{"id":"9feffbf8cc07f669","slug":null,"title":"Trase explainer: Indo palm oil - Importer country ZDC coverage (metric selection fix) (CN)","thumbnail":"a3f2441c9002b565f92335a436e2d2a48f81376398ea39c47f472f65652e6422","access_level":"unlisted","create_time":"$D2024-10-28T14:12:57.961Z","update_time":"$D2024-10-28T15:36:37.728Z","view_time":null,"first_public_time":"$D2024-10-28T14:12:57.961Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"7ad1222ddb4e496a","login":"trase","name":"Trase","avatar_url":"https://avatars-next.observableusercontent.com/b224aa7961f5a048a8038ec6325c50964fe0466aeb33b4e09887e1f552e8a676","tier":"pro","bio":"Trase is a supply chain transparency initiative that seeks to transform our understanding of how companies and governments involved in the trade of agricultural commodities are linked to impacts and opportunities for more sustainable production","followed_by_you":false,"follows_you":false},"version":1642,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"2afbe130e224f76e","login":"bernardol","name":"Bernardo Loureiro","avatar_url":"https://avatars-next.observableusercontent.com/3ddb97df58abc437d5bbc6349f9def4591d2d148c1ccc8047e6c56067eb89987","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"2afbe130e224f76e","login":"bernardol","name":"Bernardo Loureiro","avatar_url":"https://avatars-next.observableusercontent.com/3ddb97df58abc437d5bbc6349f9def4591d2d148c1ccc8047e6c56067eb89987","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Trase explainer: Indo palm oil - Importer country ZDC coverage (metric selection fix) (CN)","cells":[{"id":0,"value":"md`# Trase explainer: Indo palm oil - Importer country ZDC coverage (metric selection fix) (CN)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1055,"value":"titleCard1 = titleCard({\n title: \"印尼、中国和印度是印尼棕榈油的主要进口市场\",\n subtitle:\n \"由于这三个市场对印尼棕榈油的需求量大，而且毁林风险强度相对较高，因此在2021-2022年，这三个市场购买的棕榈油占印尼棕榈油毁林风险的75%。资料来源： Trase\",\n extra: [viewof selected_value, viewof bubbleYearSelect],\n footnote:\n \"Unknown country is associated with approximately 2.4 million tonnes of CPO-eq palm oil missing from the trade data in 2021 and 8.2 million tonnes in 2022\",\n width: 1\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1167,"value":"chartLegend = legend({\n colour: d3.scaleThreshold([...thresholds], colourSchemeRev),\n title: \"Share of production covered by ZDC exporters\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":528,"value":"md`---\n## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1082,"value":"viewof bubbleYearSelect = Inputs.select([2021, 2022], {\n step: 1,\n value: 2022,\n label: \"Select year:\",\n format: (d) => d\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1622,"value":"viewof selected_value = Inputs.radio(metrics, {\n value: \"volume\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1624,"value":"metrics = new Map([\n [\"Volume (tonnes)\", \"volume\"],\n [\"Deforestation exposure (ha)\", \"deforestation\"]\n])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":936,"value":"keys = Object.keys(data[0]).filter((d) => d != \"key\" && d != \"zdc_share\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1431,"value":"legendItems = [\n {\n type: \"dot\",\n stroke: \"#bdbdbd\",\n fill: \"#bdbdbd\",\n text: \"No data\"\n }\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"height = width * 0.65","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1592,"value":"width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"margin = ({ top: 5, bottom: 5, right: 5, left: 5 })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":993,"value":"// colourScheme = traseOranges[6]\ncolourScheme = traseOranges[7]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1522,"value":"colourSchemeRev = colourScheme.reverse()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1202,"value":"colourSchemeZdc = (d) => {\n if ((d.data.key === \"DOMESTIC\") | (d.data.key === \"UNKNOWN COUNTRY\"))\n return \"#bdbdbd\";\n return d3.scaleThreshold().domain(thresholds).range(colourSchemeRev)(\n d.data[colourKey]\n );\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1325,"value":"id_palm_zdc_shr_vols_imp_ctry1 = FileAttachment(\"id_palm_zdc_shr_vols_imp_ctry_1_2_2@2.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1194,"value":"colourKey = \"zdc_share\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1329,"value":"defriskKey = \"deforestation\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1154,"value":"root = d3\n .hierarchy(\n d3.rollup(\n data,\n (v) => ({ value: d3.sum(v, (d) => d.value), data: v }),\n ...keys.map((k) => (d) => d[k])\n )\n )\n .sum(([, d]) => d.value)\n .sort((a, b) => b.value - a.value)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":854,"value":"pack = d3\n .pack()\n .size([\n width - (margin.left + margin.right),\n height - (margin.top + margin.bottom)\n ])\n .padding(3)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1169,"value":"thresholds = [0.2, 0.4, 0.6, 0.8, 0.9, 0.95].map((d) =>\n Math.floor(d * d3.max(data, (d) => d.zdc_share))\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":336,"value":"full = FileAttachment(\"id_palm_zdc_shr_vols_imp_ctry_1_2_2@2.csv\").csv({\n typed: true\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1019,"value":"data = full\n .filter((d) => d.year === bubbleYearSelect)\n .map((d) => ({\n key: d.key,\n volume: d.volume,\n deforestation: d.def_exposure,\n zdc_share: d.zdc_share\n }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":580,"value":"format = d3.format(\".03s\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"formatBubbleText = (d) => {\n let key = d.data.key;\n const length = getLabelLength(key, \"font: 10px var(--trase-sans-serif)\");\n const perimeter = d.r * 2 - 20;\n const prop = (length - perimeter) / length;\n if (perimeter < 50) return \"\";\n if (length > perimeter)\n key =\n key.substring(0, Math.floor(key.length * (1 - prop)) - 3).trim() + \"...\";\n return [...key.split(\" \"), format(d.value)];\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":500,"value":"annotate = g => {}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":481,"value":"function hover(bubbles, svg, selected_value) {\n const tooltip = new Tooltip();\n const tooltipKey = selected_value.replace(/_/g, \" \");\n bubbles\n .style(\"cursor\", \"pointer\")\n .on(\"touchstart\", (event) => event.preventDefault())\n .on(\"pointerenter\", (event, d) => {\n tooltip.position(\n ...tooltipOffset(tooltip, d3.pointer(event, svg.node()), width, height)\n );\n tooltip.show(d.data.key, tooltipKeyValueMultiple(d));\n })\n .on(\"pointermove\", function (event) {\n let [x, y] = tooltipOffset(\n tooltip,\n d3.pointer(event, svg.node()),\n width,\n height\n );\n tooltip.position(x, y);\n this.releasePointerCapture(event.pointerId);\n })\n .on(\"pointerout\", () => tooltip.hide());\n svg.append(() => tooltip.node);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1255,"value":"tooltipKeyValueMultiple = (d) => svg`\n VOLUME:\n ${format(\n d.data.volume\n )} t\nDEFORESTATION EXPOSURE:\n ${d3.format(\n \".03s\"\n )(d.data.deforestation)} ha\n SHARE COVERED BY ZDC:\n ${\n d.data[colourKey] >= 0 ? d3.format(\".1%\")(d.data[colourKey] / 100) : \"N/A\"\n }\n \n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":774,"value":"formatTooltipValue = d3.format(\".03s\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":773,"value":"import {\n traseColours,\n traseCategory1,\n fonts,\n traseOranges,\n trasePurples,\n traseGreens,\n traseOrPu\n} from \"@trase/visual-id\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":772,"value":"import { getLabelLength, legend, swatches } from \"@trase/legends@376\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":539,"value":"import { Tooltip, tooltipKeyValue, tooltipOffset } from \"@trase/tooltip@440\";","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":997,"value":"import { pickTextColorBasedOnBackground } from \"@trase/pick-text-color-based-on-bg\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1023,"value":"import { slider, select, checkbox, radio } from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1058,"value":"import { titleCard } from \"@trase/title-card\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"d3 = require(\"d3@6\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":966,"value":"htl = require(\"htl@0.2\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4a","stdlib":"1"}} 24:null