3e:null 3f:["$","title",null,{"children":"Pismo Beach, Grover Beach and Arroyo Grande government annual pay | Alexiah Olsen | Observable"}] 45:T524,{ const chart = Plot.plot({ width: 1100, height: 700, margin: 50, margintop: 1000, marginbottom: 20, marginLeft: 160, x: { domain: [0, 400000], label: "Total Annual Salary", tickFormat: "$,d", }, y: { // 1. Turns off the automatic axis layout so it doesn't double-render axis: null, padding: 0.45 }, marks: [ // 2. Explicitly add the axis as a mark to unlock layout controls Plot.axisY({ // Wrap lines when a word goes past ~15 characters (measured in ems) lineWidth: 10, // Forces the stacked text blocks to align nicely against the axis line textAnchor: "end", fontSize: 16 }), Plot.axisX({ frontsize: 2000 }), Plot.barX(PB_top_10_salaries, { x: (d) => Number(d["Total Annual Salary:"]), y: "Job Title", sort: {y: "x", reverse: true}, fill: "#0047AB", }), Plot.ruleX([0]), ] }); return html`

Top 10 Highest paid employees in Pismo Beach

This data comes from 2025 employment data.

${chart}

`; }46:T5d4,Plot.plot({ width: 800, height: 400, marginBottom: 80, marginLeft: 70, title: html`

Top 10 overtime pay per Pismo Beach employee

`, subtitle: html`

This data comes from 2025 employment records

`, x: { axis: null, padding: 0.20 }, y: { domain: [0, 180000], tickFormat: "$,d" }, marks: [ Plot.axisX({ lineWidth: 5, textAnchor: "center", fontSize: 10, lineHeight: 1.2, tickFormat: (name) => { const row = PB_top_10_overtime.find(d => d["Name"] === name); const flippedName = name ? name.split(",").reverse().map(n => n.trim()).join(" ") : ""; const rawTitle = row ? row["Job Title"] : ""; const words = rawTitle.split(" "); if (words.length > 1) words.shift(); let shortTitle = words.join(" "); return `${flippedName}\n(${shortTitle})`; } }), Plot.barY(PB_top_10_overtime, { x: "Name", y: (d) => Number(d["Total Annual Salary"]), fill: "#0047AB", width: 25, title: (row) => d3.format("$,.0f")(row["Total Annual Salary"]) }), Plot.barY(PB_top_10_overtime, { x: "Name", y: (d) => Number(d["Overtime Pay"]), sort: {x: "y", reverse: false}, fill: "orange", width: 15, title: (row) => d3.format("$,.0f")(row["Overtime Pay"]) }) ] })47:T4b0,Plot.plot({ width: 800, height: 400, marginBottom: 80, marginLeft: 70, title: html`

Top 10 overtime pay per Grover Beach employee

`, subtitle: html`

This data comes from 2025 employment records

`, x: { axis: null, padding: 0.20 }, y: { domain: [0, 200000], tickFormat: "$,d" }, marks: [ Plot.axisX({ lineWidth: 5, textAnchor: "center", fontSize: 10, lineHeight: 1.2, tickFormat: (i) => { const row = GB_top_overtime[i]; return row ? row["Position"] : ""; } }), Plot.barY(GB_top_overtime, { x: (d, i) => i, y: (d) => Number(d["TotalWages"]), fill: "#0047AB", width: 25, title: (row) => `Annual Pay: ${d3.format("$,.0f")(row["TotalWages"])}` }), Plot.barY(GB_top_overtime, { x: (d, i) => i, y: (d) => Number(d["OvertimePay"]), sort: {x: "y", reverse: false}, fill: "orange", width: 15, title: (row) => `Overtime Pay: ${d3.format("$,.0f")(row["OvertimePay"])}` }) ] })48:T4c1,Plot.plot({ width: 800, height: 400, marginBottom: 80, marginLeft: 70, title: html`

Top 10 overtime pay per Arroyo Grande employee

`, subtitle: html`

This data comes from 2025 employment records

`, x: { axis: null, padding: 0.20 }, y: { domain: [0, 400000], tickFormat: "$,d" }, marks: [ Plot.axisX({ lineWidth: 5, textAnchor: "center", fontSize: 10, lineHeight: 1.2, tickFormat: (i) => { const row = AG_top_overtime[i]; return row ? row["Position"] : ""; } }), Plot.barY(AG_top_overtime, { x: (d, i) => i, y: (d) => Number(d["Total Wages"]), fill: "#0047AB", width: 25, title: (row) => `Annual Pay: ${d3.format("$,.0f")(row["Total Wages"])}` }), Plot.barY(AG_top_overtime, { x: (d, i) => i, y: (d) => Number(d["Total Overtime Pay"]), sort: {x: "y", reverse: false}, fill: "orange", width: 15, title: (row) => `Overtime Pay: ${d3.format("$,.0f")(row["Total Overtime Pay"])}` }) ] })49:T54a,TwoCities = { return Plot.plot({ x: { type: "linear", domain: [0, 250000], tickFormat: "$,d" }, y: { type: "linear", domain: [0, 400000], tickFormat: "$,d" }, marginRight: 72, insetRight: 0, marginLeft: 70, marginRight: 125, marginBottom: 34, marginTop: 34, width: 950, height: 500, title: "Employees with the highest salaries and overtime pay in Pismo Beach, Arroyo Grande and Grover Beach", subtitle: "This data comes from 2025 employment records", marks: [ Plot.axisFy({lineWidth: 10, dy: 20}), Plot.frame({ strokeOpacity: 0.1 }), Plot.dot(three_cities_OT, { fy: "City ", x: "Overtime Pay", y: "Total Salary", stroke: "City ", r: "Overtime Pay", channels: { Position: "Classification Title" }, // 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 } } }) ] }) }4a:[{"id":"6ea0703b0e801fc5e0d29aabecc604f6e9d4c9c9affa9c6dd0c4243b72400b22bae32dae33bc81b7d9f9320aa90791f0ed4c53b5230e7b4b6a2df00467943aed","href":"https://static.observableusercontent.com/files/6ea0703b0e801fc5e0d29aabecc604f6e9d4c9c9affa9c6dd0c4243b72400b22bae32dae33bc81b7d9f9320aa90791f0ed4c53b5230e7b4b6a2df00467943aed","name":"AG COMBINED EMPLOYEE DATA - top.departments.csv","type":"text/csv","lastModified":1783961923897.911,"size":151},{"id":"986e426c37412d6e75d2c0c8ce7bce7212688fd52dbe583b470fb54d47687d1b4d538837be9690c17d8cf61f7d5ac110a7e54ab68ba531dbdd5cee307811278c","href":"https://static.observableusercontent.com/files/986e426c37412d6e75d2c0c8ce7bce7212688fd52dbe583b470fb54d47687d1b4d538837be9690c17d8cf61f7d5ac110a7e54ab68ba531dbdd5cee307811278c","name":"AG COMBINED EMPLOYEE DATA - top@1.10.overtime.csv","type":"text/csv","lastModified":1783966446164.207,"size":465},{"id":"e417b31ef8395bc516e745cf1039982d5105e7209d6d63ccd1c3f482533016c1891c2977f2e38d8f21932d380eb71525898958d3175ed23642c8a57b4e244dd3","href":"https://static.observableusercontent.com/files/e417b31ef8395bc516e745cf1039982d5105e7209d6d63ccd1c3f482533016c1891c2977f2e38d8f21932d380eb71525898958d3175ed23642c8a57b4e244dd3","name":"2025 Grover Beach salaries - top.10.ot.csv","type":"text/csv","lastModified":1784131325456.762,"size":506},{"id":"59fdbf2d466049b922a57e9d8d7841bcd6d7b997a04068a08e550f6c3117f4b9693cb1e96c78bff742520767968bd7fc2357dfad6e06c558b918e3ec1c71b5a8","href":"https://static.observableusercontent.com/files/59fdbf2d466049b922a57e9d8d7841bcd6d7b997a04068a08e550f6c3117f4b9693cb1e96c78bff742520767968bd7fc2357dfad6e06c558b918e3ec1c71b5a8","name":"2025 Grover Beach employment compensation - departments.csv","type":"text/csv","lastModified":1784582515271.65,"size":195},{"id":"779b7c67ff8cb78aea0ff2310a2ed27d48ae5457d4526aeea254c9d3cdf9512f5e7227396e7e680a19c5d1bba8da17fddf6261d3b05ef723d7a5f798605e6561","href":"https://static.observableusercontent.com/files/779b7c67ff8cb78aea0ff2310a2ed27d48ae5457d4526aeea254c9d3cdf9512f5e7227396e7e680a19c5d1bba8da17fddf6261d3b05ef723d7a5f798605e6561","name":"Pismo, Grover and AG OT pay - all.data (3).csv","type":"text/csv","lastModified":1784663715888.037,"size":18998},{"id":"6a5f628cca6ebe52392719ea81a5df0ffb68447a5e4bcada375a57f193bec94df1ea105bc34c9b3c1883b3e41cd5136075c2e82cf3903eb77bd928676c78b4dc","href":"https://static.observableusercontent.com/files/6a5f628cca6ebe52392719ea81a5df0ffb68447a5e4bcada375a57f193bec94df1ea105bc34c9b3c1883b3e41cd5136075c2e82cf3903eb77bd928676c78b4dc","name":"Pismo, Grover and AG OT pay - all.data (4).csv","type":"text/csv","lastModified":1784846122683.768,"size":15210},{"id":"54baa1042672ee7945f250a869580c5b5e7c0658573b63f22396d1dcf6633cfd32c9c99dc5265cb5f5889a24436f45bde564ee2505d3e6de8c6cd2ef19c60e6f","href":"https://static.observableusercontent.com/files/54baa1042672ee7945f250a869580c5b5e7c0658573b63f22396d1dcf6633cfd32c9c99dc5265cb5f5889a24436f45bde564ee2505d3e6de8c6cd2ef19c60e6f","name":"Pismo Beach 2025 Salaries - top.departments.csv","type":"text/csv","lastModified":1783636976743.527,"size":229},{"id":"e53b3e9dde9c718142b0ef21583e89a5afabc290622e70edbbb1864556f9a6522fae01439e1de1179f682dc28a654afc05d91577d84dd943399bc79a7504fb51","href":"https://static.observableusercontent.com/files/e53b3e9dde9c718142b0ef21583e89a5afabc290622e70edbbb1864556f9a6522fae01439e1de1179f682dc28a654afc05d91577d84dd943399bc79a7504fb51","name":"Pismo Beach 2025 Salaries - top@1.10.salaries.csv","type":"text/csv","lastModified":1783638730060.988,"size":503},{"id":"3293437b671bd7be8c2b7ff3a22e365e195852a9fdc69435b5407b98b074356377a7fb7a8f697b578bc442b14ba67dab2e943d2c2d4e8fffb109d0022c08aa2e","href":"https://static.observableusercontent.com/files/3293437b671bd7be8c2b7ff3a22e365e195852a9fdc69435b5407b98b074356377a7fb7a8f697b578bc442b14ba67dab2e943d2c2d4e8fffb109d0022c08aa2e","name":"Pismo Beach 2025 Salaries - top.10.overtime.pay.csv","type":"text/csv","lastModified":1783711393514.816,"size":594}] 43:{"id":"7c7e52daa493095d","slug":null,"title":"Pismo Beach, Grover Beach and Arroyo Grande government annual pay","thumbnail":"cf7fc90ab8ef8598ce436588047f790e77f8db77283089df35d9eeba31654442","access_level":"public","create_time":"$D2026-07-09T22:42:07.710Z","update_time":"$D2026-07-28T22:49:41.042Z","view_time":null,"first_public_time":"$D2026-07-21T21:01:14.577Z","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":503,"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":"individual","id":"b83e6a13c50f2e5c","login":"alexiah-olsenn","name":"Alexiah Olsen","avatar_url":"https://avatars-next.observableusercontent.com/1f16310472144633a1f73283a5e093b3d5b7a2baf680c78d911be32bdd50bffb","tier":null,"role":"editor"},{"type":"team","id":"33333e7f200bdbdc","login":"alexiah-olsenn","name":"Alexiah Olsen","avatar_url":"https://avatars-next.observableusercontent.com/1f16310472144633a1f73283a5e093b3d5b7a2baf680c78d911be32bdd50bffb","tier":"free_2026","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Pismo Beach, Grover Beach and Arroyo Grande government annual pay","cells":[{"id":0,"value":"# Pismo Beach, Grover Beach and Arroyo Grande government annual pay","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":293,"value":"## Pismo Beach ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"PB_top_departments = FileAttachment(\"Pismo Beach 2025 Salaries - top.departments.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"PB_top_10_salaries = FileAttachment(\"Pismo Beach 2025 Salaries - top@1.10.salaries.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":126,"value":"PB_top_10_overtime = FileAttachment(\"Pismo Beach 2025 Salaries - top.10.overtime.pay.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"PismoBeachDepartments = {\nreturn Plot.plot({\n axis: null,\n label: null,\n height: 260,\n marginTop: 20,\n marginBottom: 70,\n title: \"Pismo Beach top departments\",\n subtitle: \"Top 50 highest paid employees came from these departments\",\n marks: [\n Plot.axisFx({lineWidth: 10, anchor: \"bottom\", dy: 20}),\n Plot.waffleY({length: 1}, {y: 50, fillOpacity: 0.4, rx: \"100%\"}),\n Plot.waffleY(PB_top_departments, {\n fx: \"DEPARTMENT NAME\",\n y: \"COUNTA of POSITION NAME\",\n rx: \"100%\",\n fill: \"#0047AB\",\n sort: {\n fx: \"y\", // Sorts based on the y-value\n reduce: \"first\",\n order: \"descending\" // \"ascending\" for smallest to greatest\n }}),\n Plot.text(PB_top_departments, {\n fx: \"DEPARTMENT NAME\", \n text: \"COUNTA of POSITION NAME\", // Directly use the column name here\n frameAnchor: \"bottom\", \n lineAnchor: \"top\", \n dy: 6, \n fill: \"orange\", \n fontSize: 24, \n fontWeight: \"bold\"\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":19,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":130,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":289,"value":"

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":296,"value":"## Grover Beach ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":298,"value":"GB_top_departments = FileAttachment(\"2025 Grover Beach employment compensation - departments.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"GB_top_overtime = FileAttachment(\"2025 Grover Beach salaries - top.10.ot.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"GBDepartments = {\nreturn Plot.plot({\n axis: null,\n label: null,\n height: 250,\n marginTop: 20,\n marginBottom: 70,\n title: \"Grover Beach top departments\",\n subtitle: \"Top 50 highest paid employees came from these departments\",\n fx: {\n padding: -1\n },\n marks: [\n Plot.axisFx({lineWidth: 10, anchor: \"bottom\", dy: 20}),\n Plot.waffleY({length: 1}, {y: 50, fillOpacity: 0.4, multiple: 5, rx: \"100%\"}),\n Plot.waffleY(GB_top_departments, {\n fx: \"DepartmentOrSubdivision\",\n y: \"Count\",\n multiple: 5,\n rx: \"100%\",\n fill: \"#0047AB\",\n sort: {\n fx: \"y\", // Sorts based on the y-value\n reduce: \"first\",\n order: \"descending\" // \"ascending\" for smallest to greatest\n }}),\n Plot.text(GB_top_departments, {\n fx: \"DepartmentOrSubdivision\", \n text: \"Count\", // Directly use the column name here\n frameAnchor: \"bottom\", \n lineAnchor: \"top\", \n dy: 6, \n fill: \"orange\", \n fontSize: 24, \n fontWeight: \"bold\"\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":320,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":338,"value":"## Arroyo Grande","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":357,"value":"AG_top_departments = FileAttachment(\"AG COMBINED EMPLOYEE DATA - top.departments.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"AG_top_overtime = FileAttachment(\"AG COMBINED EMPLOYEE DATA - top@1.10.overtime.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":360,"value":"AGDepartments = {\nreturn Plot.plot({\n axis: null,\n label: null,\n height: 250,\n marginTop: 20,\n marginBottom: 70,\n title: \"Arroyo Grande top departments\",\n subtitle: \"Top 50 highest paid employees came from these departments\",\n fx: {\n padding: -1\n },\n marks: [\n Plot.axisFx({lineWidth: 10, anchor: \"bottom\", dy: 20}),\n Plot.waffleY({length: 1}, {y: 50, fillOpacity: 0.4, multiple: 5, rx: \"100%\"}),\n Plot.waffleY(AG_top_departments, {\n fx: \"Department\",\n y: \"Count\",\n multiple: 5,\n rx: \"100%\",\n fill: \"#0047AB\",\n sort: {\n fx: \"y\", // Sorts based on the y-value\n reduce: \"first\",\n order: \"descending\" // \"ascending\" for smallest to greatest\n }}),\n Plot.text(AG_top_departments, {\n fx: \"Department\", \n text: \"Count\", // Directly use the column name here\n frameAnchor: \"bottom\", \n lineAnchor: \"top\", \n dy: 6, \n fill: \"orange\", \n fontSize: 24, \n fontWeight: \"bold\"\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":370,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":413,"value":"