3e:null 3f:["$","title",null,{"children":"SLO County and Cities Government Employee Salary Data 2025 | Alexiah Olsen | Observable"}] 45:T53e,Plot.plot({ width: 900, // Adjust this number (e.g., 800, 1200) to change how wide it stretches height: 600, // Adjust this number to change how tall the chart is // 2. Increase the left margin to stop the numbers from being cut off marginLeft: 100, marginBottom: 150, // 2. Added a bottom margin so the rotated names don't get cut off x: { tickRotate: -45, // 3. Rotates the names 45 degrees so they slant cleanly! }, y: { tickFormat: (d) => d.toLocaleString("en-US", { style: "currency", currency: "USD", maximumFractionDigits: 0 }) }, marks: [ Plot.barY( AG_final_data.sort((a, b) => b["Annual Regular Pay"] - a["Annual Regular Pay"]) .slice(0, 10) // 1. Create a combined "Full Name" property for each row .map(d => ({ ...d, "Full Name and Title": `${d["First Name"]} ${d["Last Name"]}\n${d["Job Title"]}` })), { x: "Full Name and Title", y: "Annual Regular Pay", sort: {x: "y", reverse: true}, tip: true, fill: "red", channels: { "Annual Regular Pay": (d) => d["Annual Regular Pay"].toLocaleString("en-US", { style: "currency", currency: "USD", maximumFractionDigits: 0 }) } } ), Plot.ruleY([0]) ] })46:Te03,top10SalaryChart = { // We wrap the internal code logic so Observable evaluates it correctly const renderChart = () => { // 1. Safety check if (!Pay_per_position || Pay_per_position.length === 0) { return html`

Waiting for data... Please ensure that your Pay_per_position dataset has been loaded and executed in another cell above this one.

`; } // 2. Auto-detect keys to prevent silent casing mismatches const firstRow = Pay_per_position[0]; const datasetKeys = Object.keys(firstRow); const findMatchingKey = (targetName) => { const cleanTarget = targetName.toLowerCase().replace(/[^a-z0-9]/g, ""); const found = datasetKeys.find(k => k.toLowerCase().replace(/[^a-z0-9]/g, "") === cleanTarget); return found || targetName; }; const classificationKey = findMatchingKey("classification title"); const payKey = findMatchingKey("annual salary maximum"); // 3. GROUP, FIND MAX, AND SLICE TO TOP 10 OVERALL CLASSIFICATIONS const classificationGroups = {}; Pay_per_position.forEach((row) => { if (!row) return; const cls = row[classificationKey] || "Unknown"; const payVal = Number(row[payKey]) || 0; if (!classificationGroups[cls] || payVal > (Number(classificationGroups[cls][payKey]) || 0)) { classificationGroups[cls] = row; } }); const uniqueClassifications = Object.values(classificationGroups); uniqueClassifications.sort((a, b) => (Number(b[payKey]) || 0) - (Number(a[a => payKey]) || 0)); const top10Classifications = uniqueClassifications.slice(0, 10); // 3b. CALCULATE BOUNDS FOR HIGH-CONTRAST VISUAL SCALING const salaryValues = top10Classifications.map(d => Number(d[payKey]) || 0); const minSalary = Math.min(...salaryValues); const maxSalary = Math.max(...salaryValues); // 4. Render the Circle Packing Chart const chart = Pack(top10Classifications, { path: (d) => d ? `Total/${d[classificationKey] || "Unknown"}` : "", label: (d) => d?.[classificationKey] || "", group: (d) => d?.[classificationKey] || "Unknown", value: (d) => { const pay = Number(d?.[payKey]) || 0; if (pay === 0) return 0; const normalized = (pay - minSalary) / (maxSalary - minSalary || 1); return Math.pow(normalized, 3) * 99 + 1; }, title: (d, n) => { if (!d) return "Group"; const payFormatted = (Number(d[payKey]) || 0).toLocaleString("en-US", { style: "currency", currency: "USD", maximumFractionDigits: 0 }); const empName = d["employee name"] || d["Employee Name"] || d["name"] || d["Name"] || "Employee"; return `${empName}\nClassification: ${d[classificationKey] || "N/A"}\nAnnual Salary Maximum: ${payFormatted}`; }, width, height: 600 }); // 5. POST-PROCESSING if (chart) { const rootCircle = chart.querySelector("circle"); if (rootCircle) { rootCircle.setAttribute("fill", "none"); rootCircle.setAttribute("stroke", "none"); } const texts = chart.querySelectorAll("text"); for (const text of texts) { if (text.textContent === "Total") { text.style.display = "none"; } } } return chart; }; // Execute the chart renderer immediately return renderChart(); } 47:Ta0e,chart = { // Color scale based on the departments (depth === 1) const color = d3.scaleOrdinal(d3.quantize(d3.interpolateRainbow, data.children.length + 1)); const radius = 928 / 2; // Prepare the layout. const partition = data => d3.partition() .size([2 * Math.PI, radius]) (d3.hierarchy(data) .sum(d => d.value) .sort((a, b) => b.value - a.value)); const arc = d3.arc() .startAngle(d => d.x0) .endAngle(d => d.x1) .padAngle(d => Math.min((d.x1 - d.x0) / 2, 0.005)) .padRadius(radius / 2) .innerRadius(d => d.y0) .outerRadius(d => d.y1 - 1); const root = partition(data); // Create the SVG container. const svg = d3.create("svg"); // Add an arc for ALL elements (including root) const format = d3.format(",d"); svg.append("g") .attr("fill-opacity", 0.6) .selectAll("path") .data(root.descendants()) // Removed .filter(d => d.depth) so the root renders .join("path") .attr("fill", d => { if (d.depth === 0) return "#ccc"; // Color for the central "San Luis Obispo city employees" circle while (d.depth > 1) d = d.parent; return color(d.data.name); }) .attr("d", arc) .append("title") .text(d => `${d.ancestors().map(d => d.data.name).reverse().join("/")}\n${format(d.value)}`); // Add a label for elements (including root if it fits) svg.append("g") .attr("pointer-events", "none") .attr("text-anchor", "middle") .attr("font-size", 10) .attr("font-family", "sans-serif") .selectAll("text") // Keep root node, but still filter out text that is too small to fit in its slice .data(root.descendants().filter(d => d.depth === 0 || (d.y0 + d.y1) / 2 * (d.x1 - d.x0) > 10)) .join("text") .attr("transform", function(d) { // Special case for the central root node so its text isn't rotated sideways if (d.depth === 0) return "translate(0,0)"; const x = (d.x0 + d.x1) / 2 * 180 / Math.PI; const y = (d.y0 + d.y1) / 2; return `rotate(${x - 90}) translate(${y},0) rotate(${x < 180 ? 0 : 180})`; }) .attr("dy", "0.35em") .text(d => d.data.name); // The autoBox function adjusts the SVG’s viewBox to the dimensions of its contents. function autoBox() { document.body.appendChild(this); const {x, y, width, height} = this.getBBox(); document.body.removeChild(this); return [x, y, width, height]; } // 2. The autoBox function will now work perfectly here: return svg.attr("viewBox", autoBox).node(); }48:T4ec,Plot.plot({ x: { type: "linear" }, y: { type: "linear" }, marginRight: 72, insetRight: 0, marginLeft: 63, marginBottom: 34, marginTop: 34, width: 737, color: { legend: true }, height: 400, title: "Employees with the highest salaries and overtime pay", subtitle: "Comparison of SLO County and cities where the employees have made the most money by annual salary and overtime pay", marks: [ Plot.frame({ strokeOpacity: 0.1 }), Plot.dot(overtime_v_aunnual_data, { fy: "City", x: "SCO Overtime Pay", y: "ANNUALIZED_SALARY", stroke: "City", r: "SCO Overtime Pay", channels: { Name: "NAME", Position: "POSITION NAME" }, // 2. Configure the interactive tooltip layout and formatting tip: { format: { x: d => `$${d3.format(",.2f")(d)}`, // Formats Overtime Pay cleanly as currency (e.g., $15,000.00) y: d => `$${d3.format(",.2f")(d)}`, // Formats Annual Salary cleanly as currency Name: true, Position: true, // Displays the worker's name channel fy: false // Hides the "City" label if it feels repetitive in the row } } }) ] })49:[{"id":"3ab5e601d649381d26e42281cac21dddc87a7ef66899e85cce78c4a1cdb97974da181614f74a89dbb68bea1ad427875a703404b1b34ee896c0dd2197d29ee9c8","href":"https://static.observableusercontent.com/files/3ab5e601d649381d26e42281cac21dddc87a7ef66899e85cce78c4a1cdb97974da181614f74a89dbb68bea1ad427875a703404b1b34ee896c0dd2197d29ee9c8","name":"COMBINED EMPLOYEE DATA1 - .data.csv","type":"text/csv","lastModified":1781331451305.686,"size":16425},{"id":"901bc6b0b9fa81f7a61ce2da1e882ada3048a3a82eb9578dca60c018a40e01619d7b78e853294dc1b02aa13f75a640147ce97fe5a9c121d2bd54999a9924afbc","href":"https://static.observableusercontent.com/files/901bc6b0b9fa81f7a61ce2da1e882ada3048a3a82eb9578dca60c018a40e01619d7b78e853294dc1b02aa13f75a640147ce97fe5a9c121d2bd54999a9924afbc","name":"COMBINED EMPLOYEE DATA - All employee salaries (no names)@1.csv","type":"text/csv","lastModified":1781424539046.991,"size":14418},{"id":"0c395def0b6146169b05cf54d255b84c5f000c3fd75a8c1897921fe747a55933e1130a844576615731c0393c12233d49c06b5aa1aa75d8c2e5f76c71b8d6bd74","href":"https://static.observableusercontent.com/files/0c395def0b6146169b05cf54d255b84c5f000c3fd75a8c1897921fe747a55933e1130a844576615731c0393c12233d49c06b5aa1aa75d8c2e5f76c71b8d6bd74","name":"all cities data - Sheet1.csv","type":"text/csv","lastModified":1781900672235.103,"size":12327},{"id":"d2f5a9a8ef0e0d98d329e3855bc2437882440065b5bbba49b9e2fb5a6d5fe35207df127682492666ad2d3d5d14802cbf53d6fb406ad29e88409250bb3cb6691a","href":"https://static.observableusercontent.com/files/d2f5a9a8ef0e0d98d329e3855bc2437882440065b5bbba49b9e2fb5a6d5fe35207df127682492666ad2d3d5d14802cbf53d6fb406ad29e88409250bb3cb6691a","name":"all cities data - county_city.top.50.csv","type":"text/csv","lastModified":1781901208628.669,"size":12033},{"id":"6481cad9cc829ea3071cad6fa4dda7cc348111f66cf41ab15865d9be81b9203a66722c2b797a141a3f4b192bfa65274be9d915d0b48391f50850cfa89ea220f8","href":"https://static.observableusercontent.com/files/6481cad9cc829ea3071cad6fa4dda7cc348111f66cf41ab15865d9be81b9203a66722c2b797a141a3f4b192bfa65274be9d915d0b48391f50850cfa89ea220f8","name":"SLO 2025 top 50 salaries - top.50.salaries.csv","type":"text/csv","lastModified":1781887652025.7,"size":7599},{"id":"bb291652ee8e0447291767d18deb7d38b0dd6dce0c1f2561fc7c225ae0f138d03acd66d077ba05ca14b1da58bb0cf4b2947dc9fc912d89c3aacd9481ff05b6f5","href":"https://static.observableusercontent.com/files/bb291652ee8e0447291767d18deb7d38b0dd6dce0c1f2561fc7c225ae0f138d03acd66d077ba05ca14b1da58bb0cf4b2947dc9fc912d89c3aacd9481ff05b6f5","name":"Untitled spreadsheet - Sheet1 (1)@1.csv","type":"text/csv","lastModified":1781890013578.52,"size":9171}] 43:{"id":"676835b32bde92f5","slug":null,"title":"SLO County and Cities Government Employee Salary Data 2025","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2026-06-13T05:56:14.839Z","update_time":"$D2026-06-19T20:52:08.009Z","view_time":null,"first_public_time":"$D2026-06-13T05:56:14.839Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"33333e7f200bdbdc","login":"alexiah-olsenn","name":"Alexiah Olsen","avatar_url":"https://avatars-next.observableusercontent.com/1f16310472144633a1f73283a5e093b3d5b7a2baf680c78d911be32bdd50bffb","tier":"free_2026","bio":"","following":false},"version":1421,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b83e6a13c50f2e5c","login":"alexiah-olsenn","name":"Alexiah Olsen","avatar_url":"https://avatars-next.observableusercontent.com/1f16310472144633a1f73283a5e093b3d5b7a2baf680c78d911be32bdd50bffb","tier":null,"bio":"Service journalism reporter for the San Luis Obispo Tribune","following":false}],"members":[{"type":"team","id":"33333e7f200bdbdc","login":"alexiah-olsenn","name":"Alexiah Olsen","avatar_url":"https://avatars-next.observableusercontent.com/1f16310472144633a1f73283a5e093b3d5b7a2baf680c78d911be32bdd50bffb","tier":"free_2026","role":"editor"},{"type":"individual","id":"b83e6a13c50f2e5c","login":"alexiah-olsenn","name":"Alexiah Olsen","avatar_url":"https://avatars-next.observableusercontent.com/1f16310472144633a1f73283a5e093b3d5b7a2baf680c78d911be32bdd50bffb","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"SLO County and Cities Government Employee Salary Data 2025","cells":[{"id":0,"value":"# SLO County and Cities Government Employee Salary Data 2025","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":47,"value":"combinedEmployeeData1Data = await FileAttachment(\"COMBINED EMPLOYEE DATA1 - .data.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"combinedEmployeeData1Data","database":"$undefined"},{"id":29,"value":"AG_final_data = FileAttachment(\"COMBINED EMPLOYEE DATA1 - .data.csv\").csv({typed: true})","pinned":false,"hidden":true,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":190,"value":"combinedEmployeeDataAllEmployeeSalariesNoNa = await FileAttachment(\"COMBINED EMPLOYEE DATA - All employee salaries (no names)@1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"combinedEmployeeDataAllEmployeeSalariesNoNa","database":"$undefined"},{"id":200,"value":"Pay_per_position = FileAttachment(\"COMBINED EMPLOYEE DATA - All employee salaries (no names)@1.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":" totalSalarySpent = {\n const sum = AG_final_data.reduce((accumulator, row) => {\n const pay = Number(row[\"Annual Regular Pay\"]) || 0;\n return accumulator + pay;\n }, 0);\n\n return sum.toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\",\n maximumFractionDigits: 0\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"md`**Total amount spent on employee salaries:** ${totalSalarySpent}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"In 2025, Arroyo Grande spent more than $10.1 million on governmental employee's salaries. ","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":117,"value":"md`**Total of Top 10 Salaries:** ${\n (() => {\n const sum = AG_final_data.sort((a, b) => b[\"Annual Regular Pay\"] - a[\"Annual Regular Pay\"])\n .slice(0, 10)\n .reduce((accumulator, row) => {\n const pay = Number(row[\"Annual Regular Pay\"]) || 0;\n return accumulator + pay;\n }, 0);\n\n // 2. Format the sum immediately as currency\n return sum.toLocaleString(\"en-US\", {\n style: \"currency\",\n currency: \"USD\",\n maximumFractionDigits: 0\n });\n })()\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"percentageTopTen = {\n const rawTotal = AG_final_data.reduce((sum, row) => sum + (Number(row[\"Annual Regular Pay\"]) || 0), 0);\n const rawTopTen = AG_final_data.sort((a, b) => b[\"Annual Regular Pay\"] - a[\"Annual Regular Pay\"])\n .slice(0, 10)\n .reduce((sum, row) => sum + (Number(row[\"Annual Regular Pay\"]) || 0), 0);\n const ratio = rawTotal > 0 ? (rawTopTen / rawTotal) : 0;\n \n return ratio.toLocaleString(\"en-US\", {\n style: \"percent\",\n minimumFractionDigits: 1,\n maximumFractionDigits: 1\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":126,"value":"md`**Percentage of highest paid employees:** ${percentageTopTen}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"

\n \n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":217,"value":"import {Pack} from \"@d3/circle-packing\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":288,"value":"**SAN LUIS OBISPO EMPLOYEE SALARY DATA**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":295,"value":"slo2025Top50SalariesTop50Salaries = await FileAttachment(\"SLO 2025 top 50 salaries - top.50.salaries.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"slo2025Top50SalariesTop50Salaries","database":"$undefined"},{"id":296,"value":"SLO_final_data = FileAttachment(\"SLO 2025 top 50 salaries - top.50.salaries.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":303,"value":"data = {\n // Use d3.rollups to nest DEPARTMENT NAME -> POSITION NAME\n const rolled = d3.rollups(\n SLO_final_data,\n v => v.length, // Change this to `d3.sum(v, d => d.SALARY)` if you want to sum a specific metric instead of counting rows\n d => d[\"DEPARTMENT NAME\"],\n d => d[\"POSITION NAME\"]\n );\n\n // Map the rolled data into the exact { name, children } format D3 hierarchy expects\n return {\n name: \"San Luis Obispo city employees\",\n children: rolled.map(([dept, positions]) => ({\n name: dept,\n children: positions.map(([pos, value]) => ({\n name: pos,\n value: value\n }))\n }))\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":306,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":321,"value":"untitledSpreadsheetSheet111 = await FileAttachment(\"Untitled spreadsheet - Sheet1 (1)@1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"untitledSpreadsheetSheet111","database":"$undefined"},{"id":537,"value":"overtime_v_aunnual_data = FileAttachment(\"all cities data - county_city.top.50.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1412,"value":"$48","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 44:"$43:body"