2f:Tb94,map_electorates = { const container = yield htl.html`

`; const map = L.map(container).setView([-30, 135], 4); map.createPane('labels'); map.getPane('labels').style.zIndex = 650; map.getPane('labels').style.pointerEvents = 'none'; var positron = L.tileLayer('https://{s}.basemaps.cartocdn.com/rastertiles/voyager_nolabels/{z}/{x}/{y}.png', { attribution: '©OpenStreetMap, ©CartoDB' }).addTo(map); var positronLabels = L.tileLayer('https://{s}.basemaps.cartocdn.com/rastertiles/voyager_only_labels/{z}/{x}/{y}.png', { attribution: '©OpenStreetMap, ©CartoDB', pane: 'labels' }).addTo(map); var geojson; function style(feature) { return { fillColor: map_scale_electorates(feature.properties.places_per_student), weight: 1, opacity: 1, color: 'black', fillOpacity: 1 }; } function highlightFeature(e) { var layer = e.target; layer.setStyle({ weight: 1, color: 'black', fillOpacity: 0.5 }); layer.bringToFront(); info.update(layer.feature.properties); } function resetHighlight(e) { geojson.resetStyle(e.target); info.update(); } function zoomToFeature(e) { // map.fitBounds(e.target.getBounds()); } function onEachFeature(feature, layer) { layer.on({ mouseover: highlightFeature, mouseout: resetHighlight, click: zoomToFeature }); } geojson = L.geoJson(map_data_electorates, { style: style, onEachFeature: onEachFeature }).addTo(map); var info = L.control(); info.onAdd = function (map) { this._div = L.DomUtil.create('div', 'info'); // create a div with a class "info" this._div.setAttribute('style', 'padding: 6px 8px; font: 14px/16px Arial, Helvetica, sans-serif; background: white; background: rgba(255,255,255,0.8); box-shadow: 0 0 15px rgba(0,0,0,0.2); border-radius: 5px;'); this.update(); return this._div; }; const prominent_keys = ["name", "places_per_student", "rank"]; const small_keys = [ "primary_schools", "primary_school_students", "holiday_services", "holiday_service_places", "AREASQKM" ]; info.update = function (props) { if (!props) { this._div.innerHTML = '

Subsidised holiday care by electorate

Hover over an electorate'; return; } const prop_entries = Object.entries(props); const prominent_html = [ ...prominent_keys .map((key) => { const entry = prop_entries.find((e) => e[0] === key); return entry ? `${entry[0]}: ${entry[1]}` : null; }) .filter((e) => e !== null), ...small_keys .map((key) => { const entry = prop_entries.find((e) => e[0] === key); return entry ? `${entry[0]}: ${entry[1]}` : null; }) .filter((e) => e !== null) ].join(`
`); this._div.innerHTML = '

Subsidised holiday care by electorate

' + (props ? prominent_html : 'Hover over an electorate'); }; info.addTo(map); }30:Tb75,map_sa3s = { const container = yield htl.html`

`; const map = L.map(container).setView([-30, 135], 4); map.createPane('labels'); map.getPane('labels').style.zIndex = 650; map.getPane('labels').style.pointerEvents = 'none'; var positron = L.tileLayer('https://{s}.basemaps.cartocdn.com/rastertiles/voyager_nolabels/{z}/{x}/{y}.png', { attribution: '©OpenStreetMap, ©CartoDB' }).addTo(map); var positronLabels = L.tileLayer('https://{s}.basemaps.cartocdn.com/rastertiles/voyager_only_labels/{z}/{x}/{y}.png', { attribution: '©OpenStreetMap, ©CartoDB', pane: 'labels' }).addTo(map); var geojson; function style(feature) { return { fillColor: map_scale_sa3s(feature.properties.places_per_student), weight: 1, opacity: 1, color: 'black', fillOpacity: 1 }; } function highlightFeature(e) { var layer = e.target; layer.setStyle({ weight: 1, color: 'black', fillOpacity: 0.5 }); layer.bringToFront(); info.update(layer.feature.properties); } function resetHighlight(e) { geojson.resetStyle(e.target); info.update(); } function zoomToFeature(e) { // map.fitBounds(e.target.getBounds()); } function onEachFeature(feature, layer) { layer.on({ mouseover: highlightFeature, mouseout: resetHighlight, click: zoomToFeature }); } geojson = L.geoJson(map_data_sa3s, { style: style, onEachFeature: onEachFeature }).addTo(map); var info = L.control(); info.onAdd = function (map) { this._div = L.DomUtil.create('div', 'info'); // create a div with a class "info" this._div.setAttribute('style', 'padding: 6px 8px; font: 14px/16px Arial, Helvetica, sans-serif; background: white; background: rgba(255,255,255,0.8); box-shadow: 0 0 15px rgba(0,0,0,0.2); border-radius: 5px;'); this.update(); return this._div; }; const prominent_keys = ["name", "places_per_student", "rank"]; const small_keys = [ "primary_schools", "primary_school_students", "holiday_services", "holiday_service_places", "AREASQKM" ]; info.update = function (props) { if (!props) { this._div.innerHTML = '

Subsidised holiday care by SA3 region

Hover over a region'; return; } const prop_entries = Object.entries(props); const prominent_html = [ ...prominent_keys .map((key) => { const entry = prop_entries.find((e) => e[0] === key); return entry ? `${entry[0]}: ${entry[1]}` : null; }) .filter((e) => e !== null), ...small_keys .map((key) => { const entry = prop_entries.find((e) => e[0] === key); return entry ? `${entry[0]}: ${entry[1]}` : null; }) .filter((e) => e !== null) ].join(`
`); this._div.innerHTML = '

Subsidised holiday care by SA3 region

' + (props ? prominent_html : 'Hover over a region'); }; info.addTo(map); }31:T550,{ const keys = [ 'Long Day Care', 'Preschool/Kindergarten - Part of a School', 'Preschool/Kindergarten - Stand alone', 'Outside school Hours Care - After School', 'Outside school Hours Care - Before School', 'Outside school Hours Care - Vacation Care', 'Other' ]; /** @type {{a: string, b: string, count: number, pct?: string}[]} */ const service_type_pairs = []; for (const s of ecec_services) { keys.forEach((a) => { keys.forEach((b) => { if (s[a] == 'Yes' && s[b] == 'Yes') { const match = service_type_pairs.find((r) => r.a == a && r.b == b); if (match) { match.count++; } else { service_type_pairs.push({ a, b, count: 0 }); } } }); }); } service_type_pairs.forEach((r) => { r.pct = ((r.count / ecec_services.length) * 100).toFixed(2); }); return Plot.plot({ title: 'Pair-wise count of service types offered by each ECEC service', height: 700, width: 700, color: { scheme: "reds"}, marks: [ Plot.cell(service_type_pairs, { x: "a", y: "b", fill: "count" }), Plot.text(service_type_pairs, { x: "a", y: "b", text: (d) => `${d.count}\n(${d.pct}%)`, fill: (d) => Number.parseFloat(d.pct) > 35 ? 'white' : 'black' }), Plot.axisX({label: null, marginBottom: 200, tickRotate: -30}), Plot.axisY({label: null, marginLeft: 200, tickRotate: -30}), ] }) }32:[{"id":"475229c780fd705a6b8aa34cd8895f0afeec14de45e0db4ea2218d4b5b8d5cc71690ca7c9386936de41edf8e97eefd72120a6bc768e75ef1d6bdc969bfa47367","href":"https://static.observableusercontent.com/files/475229c780fd705a6b8aa34cd8895f0afeec14de45e0db4ea2218d4b5b8d5cc71690ca7c9386936de41edf8e97eefd72120a6bc768e75ef1d6bdc969bfa47367","name":"schools_with_primary_aged_students.json","type":"application/json","lastModified":1744695988394.258,"size":15978276},{"id":"bbf72dbc81c19fc4e75ebd06c57a90b4736c1c75c52cad8ad236fe53f5e6a046d739c84ca89d06839fda22bacb125d61d366288b21799ec2f3436f19c7a44105","href":"https://static.observableusercontent.com/files/bbf72dbc81c19fc4e75ebd06c57a90b4736c1c75c52cad8ad236fe53f5e6a046d739c84ca89d06839fda22bacb125d61d366288b21799ec2f3436f19c7a44105","name":"ecec_services.json","type":"application/json","lastModified":1744695988458.507,"size":21240272},{"id":"27d98fed7898c2968b980a777d3ea2703ffd06996923bcfc74aede490e9d10da0a9590238035adb93073f1cc2e72f0a144640386b3cc975d0075e65b322a2ea1","href":"https://static.observableusercontent.com/files/27d98fed7898c2968b980a777d3ea2703ffd06996923bcfc74aede490e9d10da0a9590238035adb93073f1cc2e72f0a144640386b3cc975d0075e65b322a2ea1","name":"CED_2024_AUST_GDA2020.json","type":"application/json","lastModified":1744698053856.258,"size":15068034},{"id":"25033138b73c2fb0d2fabf257660ffba056836a689744ac1778126b92426bd6283cc530675bc88a05260f5e0a683bf7021f25600ef80cde5b540c4a067503457","href":"https://static.observableusercontent.com/files/25033138b73c2fb0d2fabf257660ffba056836a689744ac1778126b92426bd6283cc530675bc88a05260f5e0a683bf7021f25600ef80cde5b540c4a067503457","name":"2025-04-15-ced_info_with_hex.csv","type":"text/csv","lastModified":1744698450083.72,"size":22178},{"id":"882a9cf43a49501ff2e4f05b5e98d4982d605b63f7ce3cbe5beb839dceaa9c57d5f4b5d2993c5f5abc6e529f1ed69b78db19042cacf2bdaed935329014375447","href":"https://static.observableusercontent.com/files/882a9cf43a49501ff2e4f05b5e98d4982d605b63f7ce3cbe5beb839dceaa9c57d5f4b5d2993c5f5abc6e529f1ed69b78db19042cacf2bdaed935329014375447","name":"SA3_2021_AUST_GDA2020@1.json","type":"application/json","lastModified":1744852322552.41,"size":16935017},{"id":"3550613e474aac39b434a20814efebda456961a6dc5f447f288b9c202f31369c6a82ef0206a3d3f8891169aa88114643b44bc61d731ca93caf4f506c070a3d6d","href":"https://static.observableusercontent.com/files/3550613e474aac39b434a20814efebda456961a6dc5f447f288b9c202f31369c6a82ef0206a3d3f8891169aa88114643b44bc61d731ca93caf4f506c070a3d6d","name":"SAL_2021_AUST_GDA2020.json","type":"application/json","lastModified":1744861499028.702,"size":47147551}] 2d:{"title":"Access to subsidised holiday care in Australia","cells":[{"id":0,"value":"# Access to subsidised holiday care in Australia\n\nGraphics accompanying the [April 2025 Beyond the Bell policy brief](https://www.sydney.edu.au/sydney-policy-lab/news-and-analysis/latest-news/2025/04/30/beyond-the-bell-identifies-holiday-care-shortage.html).","pinned":false,"hidden":false,"mode":"md"},{"id":84,"value":"## Federal electorates","pinned":false,"hidden":false,"mode":"md"},{"id":52,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":86,"value":"## SA3 regions","pinned":false,"hidden":false,"mode":"md"},{"id":88,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":101,"value":"Plot.plot({\n title: 'Access by SA3 region',\n height: 100,\n x: {\n domain: [0, 0.5]\n },\n color: {legend: true},\n marks: [\n Plot.dotX(sa3, Plot.dodgeY({\n x: \"places_per_student\",\n tip: true,\n title: \"name\", r: 1.5, fill: 'black', reverse: true\n })),\n // Plot.text(sa3, Plot.dodgeY({x: \"places_per_student\", text: (d) => `${d.name}`, dy: -5, reverse: true, anchor: \"top\", lineAnchor: \"top\"}))\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":106,"value":"Plot.plot({\n title: 'Access by federal electorate',\n subtitle: 'Red electorates are marginal',\n x: {\n domain: [0, 0.5]\n },\n color: {legend: true},\n marks: [\n Plot.dotX(electorates, Plot.dodgeY({\n x: \"places_per_student\",\n tip: true,\n title: \"name\", r: 1.5,\n fill: (d) => {\n return d.Margin < 4 ? 'red' : 'black'\n }\n })),\n // Plot.text(electorates, Plot.dodgeY({x: \"places_per_student\", text: (d) => `${d.name}`, dy: -5, reverse: true, lineAnchor: \"bottom\"}))\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":368,"value":"Plot.plot({\n title: 'Access by state',\n x: {\n domain: [0, 0.35]\n },\n marks: [\n Plot.dotX(states, Plot.dodgeY({\n x: \"places_per_student\",\n tip: true,\n title: \"name\", r: 1.5,\n })),\n // Plot.text(states, Plot.dodgeY({x: \"places_per_student\", text: (d) => `${d.name}`, dy: -5, reverse: true, lineAnchor: \"bottom\"}))\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":394,"value":"{\n const data = greater_capital_city.filter(g => g.name !== \"Other Territories\");\n \n return Plot.plot({\n title: 'Access by greater city',\n x: {\n domain: [0, 0.35],\n },\n y: {\n axis: null\n },\n marks: [\n Plot.dot(data, {\n x: \"places_per_student\",\n y: \"state\",\n tip: true,\n title: \"name\", r: 1.5,\n }),\n Plot.ruleY(data, Plot.groupY({x1: \"min\", x2: \"max\"}, {y: \"state\", x: \"places_per_student\", sort: {y: \"x2\"}})),\n Plot.text(data, Plot.selectFirst({x: \"places_per_student\", y: \"state\", z: \"state\", text: (d) => `${d.name}`, dx: 5, textAnchor: 'start' })),\n Plot.text(data, Plot.selectLast({x: \"places_per_student\", y: \"state\", z: \"state\", text: (d) => `${d.name}`, dx: -5, textAnchor: 'end' }))\n ]\n})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":49,"value":"---\n\n## Reference charts, data and calculations","pinned":false,"hidden":false,"mode":"md"},{"id":47,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":137,"value":"Plot.plot({\n title: 'Access by federal electorate - Static version',\n project: \"mercator\",\n color: {\n type: \"linear\",\n scheme: \"RdBu\", // reds\n label: \"Places per student\",\n legend: true\n },\n marks: [\n Plot.geo(map_data_sa3s, {\n fill: (d) => d.properties.places_per_student.toFixed(2),\n tip: true\n }),\n Plot.dot(sal_2021_aust_gda2020, Plot.centroid({filter: (d) => labelled_suburbs.includes(d.properties.SAL_NAME21), text: (d) => d.properties.name, r: 0.25, fill: \"currentColor\"})),\n Plot.text(sal_2021_aust_gda2020, Plot.centroid({filter: (d) => labelled_suburbs.includes(d.properties.SAL_NAME21), text: (d) => d.properties.SAL_NAME21, fill: \"currentColor\", textAnchor: \"middle\", lineAnchor: \"bottom\", fontSize: 0.5}))\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"ecec_services = FileAttachment(\"ecec_services.json\").json();","pinned":false,"hidden":false,"mode":"ojs"},{"id":7,"value":"holiday_services = ecec_services.map(s => {\n // Standardise state key between services and schools\n s[\"Statistical Area 3 Name\"] = s.sa3_name21;\n\n // Patch some bad government data entry\n const patches = [[\"SE-00001874\", \"QLD\"],\n [\"SE-40006655\", \"NSW\"],\n [\"SE-40001000\", \"TAS\"],\n [\"SE-00006815\", \"NSW\"],\n [\"SE-40002934\", \"TAS\"],\n [\"SE-40026035\", \"QLD\"],\n [\"SE-00007941\", \"NSW\"],\n [\"SE-00008373\", \"NSW\"]];\n \n if (s.State == null) s.State = patches.find(p => p[0] == s.ServiceApprovalNumber)[1];\n \n return s;\n}).filter(s => s[\"Outside school Hours Care - Vacation Care\"] == \"Yes\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":26,"value":"summarise_by_geography = (key) => {\n const records = [];\n \n for (const school of schools_with_primary_aged_students) {\n \tconst match = records.find((r) => r.name == school[key]);\n \n \tif (match) {\n \t\tmatch.primary_schools += 1;\n \t\tmatch.primary_school_students += school['primary_enrolments'];\n \t} else {\n \t\trecords.push({\n \t\t\tname: school[key],\n \t\t\tprimary_schools: 1,\n \t\t\tprimary_school_students: school['primary_enrolments'],\n \t\t\tholiday_services: 0,\n \t\t\tholiday_service_places: 0,\n state: school.State\n \t\t});\n \t}\n }\n \n for (const service of holiday_services) {\n \tconst match = records.find((c) => c.name == service[key]);\n\n \tif (!match) throw new Error(`Holiday service ${service.ServiceApprovalNumber} (${service.ServiceName}) has no value for ${key} `);\n \n \tmatch.holiday_services += 1;\n \tmatch.holiday_service_places += service.NumberOfApprovedPlaces;\n }\n \n return add_ratio_and_rank(records);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"schools_with_primary_aged_students = FileAttachment(\"schools_with_primary_aged_students.json\").json()","pinned":true,"hidden":false,"mode":"ojs"},{"id":13,"value":"sa3 = summarise_by_geography(\"Statistical Area 3 Name\");","pinned":true,"hidden":false,"mode":"ojs"},{"id":284,"value":"states = summarise_by_geography('State');","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"greater_capital_city = summarise_by_geography('gcc_name21');","pinned":true,"hidden":false,"mode":"ojs"},{"id":21,"value":"add_ratio_and_rank = (arr) => {\n return arr\n \t.map((d) => {\n \t\treturn {\n \t\t\t...d,\n \t\t\tplaces_per_student: d.holiday_service_places / d.primary_school_students\n \t\t};\n \t})\n \t.toSorted((a, b) => b.places_per_student - a.places_per_student)\n \t.map((d, i) => {\n \t\treturn {\n \t\t\trank: i + 1,\n \t\t\t...d\n \t\t};\n \t});\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":28,"value":"electorates = summarise_by_geography('ced_name24').map(ced => ({\n ...ced,\n ...ced_info_with_hex.find(d => d.Division == ced.name)\n}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":54,"value":"map_scale_electorates = {\n const access_values = map_data_electorates.features.filter(f => f.properties.AREASQKM > 0 && f.properties.places_per_student).map(f => Number.parseFloat(f.properties.places_per_student));\n const extent = d3.extent(access_values);\n \n return d3.scaleDiverging()\n .domain([extent[0], extent[1] / 2, extent[1]])\n .interpolator(d3.interpolateRdBu)\n .clamp(true);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":56,"value":"map_data_electorates = {\n const new_data = JSON.parse(JSON.stringify(ced_2024_aust_gda2020));\n \n new_data.features.forEach(f => {\n const ced = electorates.find(e => e.name === f.properties.CED_NAME24);\n\n if (!ced) return f;\n \n f.properties = {\n ...f.properties,\n ...ced\n }\n });\n \n return new_data;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":82,"value":"map_scale_sa3s = {\n const access_values = map_data_sa3s.features.map(f => Number.parseFloat(f.properties.places_per_student));\n const extent = d3.extent(access_values);\n \n return d3.scaleDiverging()\n .domain([extent[0], extent[1] / 2, extent[1]])\n .interpolator(d3.interpolateRdBu)\n .clamp(true);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":72,"value":"map_data_sa3s = {\n const geo_copy = JSON.parse(JSON.stringify(sa3_2021_aust_gda2020));\n const features = [];\n \n for (const s of sa3) {\n const f = geo_copy.features.find(f => f.properties.SA3_NAME21 == s.name);\n\n f.properties = {\n ...f.properties,\n ...s\n }\n\n features.push(f);\n }\n \n return {\n type: \"FeatureCollection\",\n features\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":73,"value":"sa3_2021_aust_gda2020 = FileAttachment(\"SA3_2021_AUST_GDA2020@1.json\").json()","pinned":true,"hidden":false,"mode":"ojs"},{"id":58,"value":"ced_2024_aust_gda2020 = FileAttachment(\"CED_2024_AUST_GDA2020.json\").json()","pinned":true,"hidden":false,"mode":"ojs"},{"id":60,"value":"ced_info_with_hex = await FileAttachment(\"2025-04-15-ced_info_with_hex.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":232,"value":"labelled_suburbs = [\n // Sydney\n \"Merrylands\",\n \"Manly\",\n \"Hornsby\",\n \"Cronulla\",\n \"Camden\",\n \"Picton\",\n \"Black Town\",\n \"Castle Hill\",\n \"Mona Vale\",\n \"Berowra\",\n \"Penrith, New South Wales\",\n \"Windsor (NSW)\",\n \"Hurstville\",\n // Brisbane\n \"Brisbane\",\n \"Ipswich\",\n \"Everton Park\",\n \"Oxley (Qld)\",\n \"Indooroopilly\",\n \"Carindale\",\n \"Logan Central\",\n \"Sunnybank\",\n \"Capalaba\",\n \"Mount Gravatt\",\n // Melbourne\n 'Geelong',\n 'Dandenong',\n 'Werribee',\n 'St Albans (Vic.)',\n 'Brunswick (Vic.)',\n 'St Kilda (Vic.)',\n 'Greenvale (Vic.)',\n 'Sunbury',\n 'Lara',\n 'Mornington (Vic.)',\n 'Belgrave',\n 'Boronia',\n // Other\n 'City', // Canberra\n 'Darwin',\n 'Adelaide',\n 'Perth',\n \"Sydney\",\n \"Hobart\",\n \"Broome\",\n \"Cairns\",\n \"Alice Springs\"\n];","pinned":false,"hidden":false,"mode":"ojs"},{"id":233,"value":"sal_2021_aust_gda2020 = FileAttachment(\"SAL_2021_AUST_GDA2020.json\").json()","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}