// splitgraph doesn't yet contain latest data
data = splitgraph`SELECT COALESCE(
CASE
WHEN biome = ANY('{"CHACO HUMEDO", "CHACO SECO"}') THEN 'CHACO'
WHEN biome = 'AMAZONIA' THEN 'AMAZON'
WHEN biome = 'MATA ATLANTICA' THEN 'ATLANTIC FOREST'
WHEN biome = ANY('{"DELTA E ISLAS DEL PARANA", "ESPINAL", "MONTE DE LLANURAS Y MESETAS", "YUNGAS"}') THEN 'OTHER'
WHEN biome = 'CAATINGA' THEN 'CERRADO'
ELSE biome END, country_of_production
) AS key1,
CASE
WHEN deforestation_commitments IS NULL THEN 'Not assessed'
WHEN deforestation_commitments && '{"NONE", "None", "No"}' THEN 'No ZDC'
ELSE 'ZDC' END AS key2,
SUM(${indicator}) AS value
FROM "trase/supply-chains"."supply-chains"
WHERE true
AND commodity = '${commodity.toUpperCase()}'
${commodity === "Palm oil" ? `AND country_of_production = 'INDONESIA'` : ``}
${
commodity === "Cocoa"
? `AND country_of_production = ANY('{"GHANA", "COTE D''IVOIRE"}')`
: ``
}
AND economic_bloc = 'EUROPEAN UNION'
AND country_of_production != 'GHANA'
AND year = ${year}
GROUP BY key1, key2`.then((res) =>
res
.map((d) => ({ ...d, key1: titleCase(d.key1), key2: d.key2 }))
.filter((d) =>
commodity === "Soy" && year === 2018 ? d.value > 200 : true
)
)
margin = ({top: 30, right: 20, bottom: 20, left: 140})
colour = d3.scaleOrdinal()
.domain(["Not assessed", "ZDC", "No ZDC"])
.range(["#e3ebe8", "#8ba194", "#ff6a5f"])
annotate = g => g.attr("transform", `translate(${margin.left}, 0)`).append(() => legend)
import { titleCase } from "@trase/visual-id@1375"
import { chart, legend } with { data, colour, margin, annotate } from "@trase/stacked-horizontal-bar-chart@921"
import { select, slider } from "@jashkenas/inputs"
// import { splitgraph } from "@trase/splitgraph"
// client = DatabaseClient("trase-master")
d3 = require("d3-scale@1")
import { splitgraph } from "@trase/splitgraph"
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
