2d:null 2e:["$","title",null,{"children":"Org Tree Explorer | Grad Div Research | Observable"}] 33:T1203,chart = { const root = d3.hierarchy(new_data, (d) => d.children); root.x0 = dy / 2; root.y0 = 0; root.descendants().forEach((d, i) => { d.id = i; d._children = d.children; if (d.depth && d.data.name !== "Other Academic") d.children = null; // if (d.depth && d.data.name !== selected_unit) d.children = null; }); // handle the search select inputs // find the data node to be shown // var dn = root // .descendants() // .map(function(d) { // return { name: d.data.name, node: d.data.node }; // }) // .filter(function(d) { // return d.name === selected_unit; // }); // var node_path = root.path(dn[0].node); // console.log(node_path); const svg = d3 .create("svg") .attr("viewBox", [-margin.left, -margin.top, width, dx]) .style("font-size", "0.45em") .style("user-select", "none"); const gLink = svg .append("g") .attr("fill", "none") .attr("stroke", "#ccc") .attr("stroke-opacity", 0.4) .attr("stroke-width", 1.5); const gNode = svg .append("g") .attr("cursor", "pointer") .attr("pointer-events", "all"); function update(source) { const duration = d3.event && d3.event.altKey ? 2500 : 500; // capture the source input // source = // selected_unit === "" // ? root // : gNode.selectAll("g").filter(d => d.data.name === selected_unit); const nodes = root.descendants().reverse(); const links = root.links(); // Normalize for fixed-depth. nodes.forEach(function (d) { d.y = (d.depth * width) / 2; }); // Compute the new tree layout. tree(root); let left = root; let right = root; root.eachBefore((node) => { if (node.x < left.x) left = node; if (node.x > right.x) right = node; }); const height = right.x - left.x + margin.top + margin.bottom; const transition = svg .transition() .duration(duration) .attr("viewBox", [-margin.left, left.x - margin.top, width, height]) .tween( "resize", window.ResizeObserver ? null : () => () => svg.dispatch("toggle") ); // Update the nodes… const node = gNode.selectAll("g").data(nodes, (d) => d.id); // Enter any new nodes at the parent's previous position. const nodeEnter = node .enter() .append("g") .attr("transform", (d) => `translate(${source.y0},${source.x0})`) .attr("fill-opacity", 0) .attr("stroke-opacity", 0) .on("click", (d) => { d.children = d.children ? null : d._children; update(d); }); nodeEnter .append("circle") .attr("r", 6) .attr("fill", (d) => (d._children ? "lightsteelblue" : "#fff")) .attr("stroke", "steelblue") .attr("stroke-width", "1px"); nodeEnter .append("text") .attr("dy", "0.31em") .attr("x", (d) => (d._children ? -10 : 10)) .attr("text-anchor", (d) => (d._children ? "end" : "start")) .text((d) => d.data.name) .clone(true) .lower() .attr("stroke-linejoin", "round") .attr("stroke-width", 3) .attr("stroke", "white"); // Transition nodes to their new position. const nodeUpdate = node .merge(nodeEnter) .transition(transition) .attr("transform", (d) => `translate(${d.y},${d.x})`) .attr("fill-opacity", 1) .attr("stroke-opacity", 1); // Transition exiting nodes to the parent's new position. const nodeExit = node .exit() .transition(transition) .remove() .attr("transform", (d) => `translate(${source.y},${source.x})`) .attr("fill-opacity", 0) .attr("stroke-opacity", 0); // Update the links… const link = gLink.selectAll("path").data(links, (d) => d.target.id); // Enter any new links at the parent's previous position. const linkEnter = link .enter() .append("path") .attr("d", (d) => { const o = { x: source.x0, y: source.y0 }; return diagonal({ source: o, target: o }); }); // Transition links to their new position. link.merge(linkEnter).transition(transition).attr("d", diagonal); // Transition exiting nodes to the parent's new position. link .exit() .transition(transition) .remove() .attr("d", (d) => { const o = { x: source.x, y: source.y }; return diagonal({ source: o, target: o }); }); // Stash the old positions for transition. root.eachBefore((d) => { d.x0 = d.x; d.y0 = d.y; }); } update(root); return svg.node(); }34:[{"id":"e921ca4b2f19e3bd8f672babbbbbf84b3d77e2439e1956081bca244807e8e6eed74e3ecdbcae690080b3ab1c537392669d91a796e513f9a228ced82c373a206d","href":"https://static.observableusercontent.com/files/e921ca4b2f19e3bd8f672babbbbbf84b3d77e2439e1956081bca244807e8e6eed74e3ecdbcae690080b3ab1c537392669d91a796e513f9a228ced82c373a206d","name":"Org Tree Explorer to L5.csv","type":"text/csv","lastModified":1654572356675.401,"size":24892}] 31:{"id":"585dc979d0cbdde7","slug":"org-tree-explorer","title":"Org Tree Explorer","thumbnail":"b09c2ed40ab9cb1bca92abdda2474b4f31bfa8f231a63db6c698b8b7d4f2b773","access_level":"public","create_time":"$D2020-08-19T20:45:14.031Z","update_time":"$D2022-06-07T06:32:45.104Z","view_time":null,"first_public_time":"$D2022-06-07T06:33:10.536Z","has_unpublished_edits":null,"fork":{"id":"e257f81c745be447","slug":"collapsible-tree","title":"Collapsible tree","owner":{"id":"863951e3ebe4c0ae","login":"d3","name":"D3"}},"stars":2,"starred":false,"owner":{"type":"team","id":"57cec13df17cda62","login":"gradresearch","name":"Grad Div Research","avatar_url":"https://avatars-next.observableusercontent.com/648da64820b7b40a7ad33bdc825f4481fe5086724d98bbb941369de6bfad3e1e","tier":"enterprise_2024"},"version":589,"publish_version":589,"role":null,"authored":false,"authors":[{"type":"individual","id":"211f24df88ae4cd6","login":"saraquigley","name":"Sara Quigley","avatar_url":"https://avatars-next.observableusercontent.com/3bf6bb250428d139d5d072eaa766e992a5fb59c5f12a436ff6ece80fdaa5f395","tier":null}],"members":[{"type":"individual","id":"211f24df88ae4cd6","login":"saraquigley","name":"Sara Quigley","avatar_url":"https://avatars-next.observableusercontent.com/3bf6bb250428d139d5d072eaa766e992a5fb59c5f12a436ff6ece80fdaa5f395","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":4,"collection":null,"type":"notebook","body":{"title":"Org Tree Explorer","cells":[{"id":0,"value":"md`# Org Tree Explorer`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":507,"value":"hint = html `Click a node to expand or collapse the tree.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":510,"value":"note = html`This UC Berkeley tree represents the financial accounting org tree (maintained by the UC Berkeley Controller's Office) as of June 6, 2022.
This data represents org tree nodes L1, L2, L3, L4, L5 and are based on Fall HR Census data. Org changes are usually implemented during the September/October timeframe; the data behind this dashboard will be updated again once the changes are reflected in the data. If there are no people associated with a particular org node, the node won't appear in the graphic.
In some cases, due to the evolution of the ogranizational structure over time, certain nodes may have the same name at both the L3 and the L4 or L5 level. One example of this is the Academic Senate, which appears to have no children; on the contrary its child is also the Academic Senate and this duplicate node is not shown in the graphic.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":508,"value":"other_data = html`Another source for similar data is the UC Organization Tree Reports, maintained by the UC Berkeley Controller's Office. The Controller's tree represents the latest tree that is generated weekly from the production database, and may differ from the org tree shown here because the data here represents the HR Census snapshot and because the Controller's org tree goes beyond org node L4.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":358,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":367,"value":"childColumn = data.columns[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":370,"value":"parentColumn = data.columns[1]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":373,"value":"stratify = d3\n .stratify()\n .id(d => d[childColumn])\n .parentId(d => d[parentColumn])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":376,"value":"new_data = stratify(data).each(function(d) {\n d.name = d.id;\n d.size = 10;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":361,"value":"data = d3.csvParse(\n await FileAttachment(\"Org Tree Explorer to L5.csv\").text(),\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":587,"value":"// TODO : incorporate search functionality\n// viewof selected_unit = autoSelect({\n// options: new_data.descendants().map(d => d.id),\n// placeholder: \"Search for a unit . . .\"\n// })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":382,"value":"md`data transformations:\n- add \"UC Berkeley,\"\n- Change \"University of Cal Berkeley\" to \"UC Berkeley\"\n- remove other false parents, e.g. \"Academic Senate, \"\n- remove weird central ledger stuff, e.g. :\nCtrl Ops General Accounting,Central Accounting Ledger\nCtrl Ops Human Resources,Central Accounting Ledger\nCtrl Ops Payroll,Central Accounting Ledger\nCentral Accounting Ledger,Central Ledger\nCentral Ledger,University of Cal Berkeley\nCtl Ops UCOP (J),UCOP Control Ops Loc J\nUCOP Control Ops Loc J,UCOP: Loc J\n- remove node names that have a , within them, e.g. \"Environ Sci, Policy & Mgmt\"\n- deal with ambiguous orgs like \"VP Agriculture& Natural Resour,VP Agriculture& Natural Resour\"\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"import { autoSelect } from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"diagonal = d3.linkHorizontal().x(d => d.y).y(d => d.x)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"tree = d3.tree().nodeSize([dx, dy])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":275,"value":"dx = 20","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"dy = width / 6","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":224,"value":"margin = ({ top: 40, right: 60, bottom: 40, left: 60 })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":519,"value":"width = window.innerWidth - margin.left - margin.right - 40","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":482,"value":"style = html`\n\n\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"d3 = require(\"d3@5\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 32:"$31:body"