22:null 23:["$","title",null,{"children":"More comtrade commodity flow sketches | Ingrid Burrington | Observable"}] 28:[{"id":"816872a180dc588d52c385a8b0c206390140e0839a3e6cba08fb4da28d21ca827fd8340a11a2e5f488e5c5c81fc968f7571f79a8249afdc0f5aecd08f9a78fe0","href":"https://static.observableusercontent.com/files/816872a180dc588d52c385a8b0c206390140e0839a3e6cba08fb4da28d21ca827fd8340a11a2e5f488e5c5c81fc968f7571f79a8249afdc0f5aecd08f9a78fe0","name":"world10m_wound.json","type":"application/json","lastModified":1658195643247.35,"size":22446484},{"id":"746f2979dd8faf54403880568612e820b0c1903d17fa991b3f7612fed4789b9a458b4de5977e96b8ce134d452b4a17b9a98113be3a9626ac4fabadbee7ff4cfd","href":"https://static.observableusercontent.com/files/746f2979dd8faf54403880568612e820b0c1903d17fa991b3f7612fed4789b9a458b4de5977e96b8ce134d452b4a17b9a98113be3a9626ac4fabadbee7ff4cfd","name":"ne_10m_admin_0.geojson.json","type":"application/json","lastModified":1658136093520.843,"size":22446745},{"id":"136911b0ef640df5f8ef15aa98aa356d7d8adf376b7192ef73e1da82d567c7bc0412cc5b8c2e8c1dc689d8dccd2040266cdba33a72b27f2bde21651b2abb2340","href":"https://static.observableusercontent.com/files/136911b0ef640df5f8ef15aa98aa356d7d8adf376b7192ef73e1da82d567c7bc0412cc5b8c2e8c1dc689d8dccd2040266cdba33a72b27f2bde21651b2abb2340","name":"all_cobalt.csv","type":"text/csv","lastModified":1658195767481.177,"size":444613},{"id":"8a8eaa08af334fc71309f54ce760696c6d6db596c1357130203ffc1159ed58f8d15e238e68f16070b41579c023db669a8830fb30a7b50b6cfe27e6dfa49fbc8a","href":"https://static.observableusercontent.com/files/8a8eaa08af334fc71309f54ce760696c6d6db596c1357130203ffc1159ed58f8d15e238e68f16070b41579c023db669a8830fb30a7b50b6cfe27e6dfa49fbc8a","name":"bulk_cobalt.csv","type":"text/csv","lastModified":1658197883419.437,"size":826037}] 26:{"id":"2f3b54b23e921b26","slug":"comtrade-commodity-flow-sketches/2","title":"More comtrade commodity flow sketches","thumbnail":"1dff314950d7e9c748561f961caa9acd1ae7ba9b71f3f073459fe35389d7a180","access_level":"public","create_time":"$D2022-07-18T08:56:48.876Z","update_time":"$D2022-08-29T19:30:31.057Z","view_time":null,"first_public_time":"$D2022-07-19T04:47:29.633Z","has_unpublished_edits":null,"fork":{"id":"93f2cb19e13bcafa","slug":"comtrade-commodity-flow-sketches","title":"Comtrade commodity flow sketches","owner":{"id":"6ae7f99f369fe7ae","login":"lifewinning","name":"Ingrid Burrington"}},"stars":2,"starred":false,"owner":{"type":"team","id":"6ae7f99f369fe7ae","login":"lifewinning","name":"Ingrid Burrington","avatar_url":"https://avatars-next.observableusercontent.com/361e8fec3b6688927a430032a2ebcc4a35bfb53a951f775e8a60fdac19e4f742","tier":"starter_2024","bio":"Feral"},"version":1125,"publish_version":1125,"role":null,"authored":false,"authors":[{"type":"individual","id":"87193242b5b8718c","login":"lifewinning","name":"Ingrid Burrington","avatar_url":"https://avatars-next.observableusercontent.com/361e8fec3b6688927a430032a2ebcc4a35bfb53a951f775e8a60fdac19e4f742","tier":null,"bio":"Feral"}],"members":[{"type":"individual","id":"87193242b5b8718c","login":"lifewinning","name":"Ingrid Burrington","avatar_url":"https://avatars-next.observableusercontent.com/361e8fec3b6688927a430032a2ebcc4a35bfb53a951f775e8a60fdac19e4f742","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"titling":"auto","title":"More comtrade commodity flow sketches","cells":[{"id":0,"value":"md`# More comtrade commodity flow sketches\n\nIn progress--still figuring a lot of stuff out, not fully interactive just yet. Data is of cobalt ore trade 2000-2020 from UN Comtrade.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":770,"value":"viewof selectYear = Inputs.select(cobalt_export.map((c) => c.key).sort(), {\n label: \"select year\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":965,"value":"viewof selectProj = Inputs.select(projections, {\n label: \"select projection\",\n format: (x) => x.name,\n value: projections.find((t) => t.name === \"Robinson\")\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"map = html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1048,"value":"selected_with_percent.map((s) => Math.max(1.5, s.percentage * 10))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1008,"value":"(Note that this visualization does not account for [\"not otherwise specified\"](https://unstats.un.org/wiki/display/comtrade/Areas+not+elsewhere+specified) partner records in Comtrade; Chatham House's [resource trade visualizer](https://resourcetrade.earth/) just sort of sends those entries to Antarctica? Which I suppose is an option here.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1001,"value":"# Data stuff","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":689,"value":"bulk_cobalt = FileAttachment(\"bulk_cobalt.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":684,"value":"// using reporting by partner country bc it seems slightly more thorough; inevitably inconsistencies are part of this lol\ncobalt_export = d3\n .nest()\n .key(function (d) {\n return d.Year;\n })\n .entries(\n bulk_cobalt\n .filter((c) => c.Flow == \"1\")\n .filter((c) => c.Partner != \"0\")\n .filter((c) => c.NetWeight != \"\")\n .filter((c) => c.CommodityCode != \"2605\")\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":805,"value":"viridis = [\n \"#440154\",\n \"#481467\",\n \"#482576\",\n \"#453781\",\n \"#404688\",\n \"#39558c\",\n \"#33638d\",\n \"#2d718e\",\n \"#287d8e\",\n \"#238a8d\",\n \"#1f968b\",\n \"#20a386\",\n \"#29af7f\",\n \"#3dbc74\",\n \"#56c667\",\n \"#75d054\",\n \"#95d840\",\n \"#bade28\",\n \"#dde318\",\n \"#fde725\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":823,"value":"//assign colors to specific countries--imperfect method, come back to this\ncountry_colors = Array.from(\n new Set(\n cobalt_export\n .filter((c) => c.key == selectYear)[0]\n .values.map((m) => [m.PISO, m.RISO])\n .flat()\n )\n).map((m) => {\n let obj = {};\n (obj.iso = m),\n (obj.color = viridis[Math.floor(Math.random() * viridis.length)]);\n return obj;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"# Maps Implementation Stuff","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":4,"value":"projection = selectProj.value().fitSize([width, height], world)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"path = d3.geoPath(projection)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"height = 600","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":679,"value":"world10m_wound = FileAttachment(\"world10m_wound.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"outline = ({type: \"Sphere\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"graticule = d3.geoGraticule10()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":720,"value":"//get center points of all countries\ncenter = world.features\n .map((w) =>\n turf.centroid(w.geometry, {\n properties: { ISO: w.properties.ADM0_A3 }\n })\n )\n .filter((w) => w.properties.ISO != \"USA\")\n .concat(usa)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1123,"value":"tw = center.filter((f) => f.properties.ISO == \"TWN\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1096,"value":"//this is fussy but the \"center\" of the USA when factoring in Alaska and Hawaii ends up not in the center of the contiguous US and it looks kind of clunky is all\nusa = [\n Object({\n type: \"Feature\",\n properties: { ISO: \"USA\" },\n geometry: { type: \"Point\", coordinates: [-98.583333, 39.833333] }\n })\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1082,"value":"center.find((c) => c.properties.ISO == \"USA\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1015,"value":"selected = cobalt_export.filter((c) => c.key == selectYear)[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1018,"value":"total = selected.values.reduce(function (acc, obj) {\n return acc + parseInt(obj.NetWeight);\n}, 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1039,"value":"selected_with_percent = selected.values.map((s) => {\n s.percentage = s.NetWeight / total;\n return s;\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":777,"value":"// make lines between trading partners\nexport_paths = selected_with_percent\n .map((m) => {\n let start = center.filter((c) => c.properties.ISO == m.PISO);\n let end = center.filter((c) => c.properties.ISO == m.RISO);\n if ((start.length > 0) & (end.length > 0)) {\n return turf.lineString(\n [start[0].geometry.coordinates, end[0].geometry.coordinates],\n {\n start: m.Partner_Name,\n end: m.Reporter_Name,\n value: m.TradeQuantity,\n startcolor: country_colors.find((c) => c.iso == m.PISO).color,\n endcolor: country_colors.find((c) => c.iso == m.RISO).color,\n percentage: m.percentage\n }\n );\n }\n })\n .filter((f) => f != undefined)\n .sort((a, b) => (a.properties.percentage > b.properties.percentage ? 1 : -1))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":633,"value":"world = FileAttachment(\"ne_10m_admin_0.geojson.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":325,"value":"nation_center = world.features.map((n) =>\n turf.centroid(n, { properties: { name: n.properties.SOV_A3 } })\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"d3 = require(\"d3-collection@latest\", \"d3@5.9\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":299,"value":"turf = require(\"@turf/turf\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":956,"value":"projections.map((p) => p.name)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":944,"value":"import { projections } from \"@d3/projection-comparison\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W28","stdlib":"1"}} 27:"$26:body"