25:["$","title",null,{"children":"Oregon Schools Data | Brianna Wilson | Observable"}] 4b:Tac9,viewof params = Inputs.form({ dataYear: Inputs.range( [2022, 2025], { label: "Year", value: 2025, step: 1 } ), metric: Inputs.select( [ { label: "— Student Demographics —", disabled: true }, { label: "Student enrollment", value: "Student Enrollment" }, { label: "Students experiencing poverty (% - 2024-5 only)", value: "Students Experiencing Poverty" }, { label: "Free/reduced price lunch (% - 2022-3 only)", value: "Free/Reduced Priced Lunch" }, { label: "Regular attenders (% - K-2 only for 2022)", value: "Regular Attenders" }, { label: "Students with disabilities (%)", value: "Students with Disabilities" }, { label: "Ever English learners (%)", value: "Ever English Learners" }, { label: "Mobile students (%)", value: "Mobile Students" }, { label: "— Outcomes —", disabled: true }, { label: "3rd grade students meeting ELA standards (%)", value: "Grade 3 ELA" }, { label: "8th grade students meeting mathematics standards (%)", value: "Grade 8 Mathematics" }, { label: "— Staff —", disabled: true }, { label: "Teachers", value: "Teachers" }, { label: "Students per teacher", value: "Students per Teacher" }, { label: "Licensed librarians", value: "Licensed Librarians" }, { label: "Students per librarian", value: "Students per Librarian" }, ], { value: "Student Enrollment", label: "Metric", format: d => d.label || d, disabled: d => d.disabled, valueof: d => d.value } ), visualizationMode: Inputs.radio( ["districts", "circles"], { label: "", value: "districts" } ), // Additional params section showCityLabels: Inputs.toggle({ label: "Show city labels", value: true }), gradeLevel: Inputs.radio( ["all", "lower", "upper"], { value: "lower", format: x => x === "all" ? "All grades" : x === "lower" ? "Districts with elementary grades (K-8)" : "Districts with secondary grades (9-12)" } ), minDistrictSize: Inputs.range( [0, 500], { value: 0, step: 10, label: "Minimum district size" } ) }, { template: (inputs) => htl.html`

${inputs.dataYear} ${inputs.metric} ${inputs.visualizationMode}

Additional Filters

${inputs.showCityLabels} ${inputs.gradeLevel} ${inputs.minDistrictSize}

` })4c:T630,mapContainer = { const svg = d3.create("svg") .attr("width", dims.width) .attr("height", dims.height) .style("display", "block"); const g = svg.append("g").attr("id", "main-map-group"); // Set up zoom behavior const zoom = d3.zoom() .scaleExtent([1, 8]) .on("zoom", (event) => { g.attr("transform", event.transform); }); svg.call(zoom); // Add reset zoom button const resetButton = svg.append("g") .attr("class", "reset-zoom") .attr("transform", "translate(10, 10)") .style("cursor", "pointer") .on("click", function() { svg.transition() .duration(500) .call(zoom.transform, d3.zoomIdentity); }); resetButton.append("rect") .attr("width", 80) .attr("height", 30) .attr("rx", 4) .attr("fill", "white") .attr("stroke", "#666") .attr("stroke-width", 1); resetButton.append("text") .attr("x", 40) .attr("y", 20) .attr("text-anchor", "middle") .attr("font-size", "12px") .attr("fill", "#333") .text("Reset Zoom"); // Create tooltip div const tooltip = d3.select("body") .selectAll(".map-tooltip") .data([0]) .join("div") .attr("class", "map-tooltip") .style("position", "absolute") .style("background", "rgba(0, 0, 0, 0.8)") .style("color", "white") .style("padding", "8px 12px") .style("border-radius", "4px") .style("font-family", "Arial, sans-serif") .style("font-size", "14px") .style("pointer-events", "none") .style("opacity", 0) .style("z-index", 1000); return svg.node(); }4d:Tfd5,legend = { const width = 320; const height = 60; const marginTop = 18; const marginRight = 10; const marginBottom = 25; const marginLeft = 10; const svg = d3.create("svg") .attr("width", width) .attr("height", height) .attr("viewBox", [0, 0, width, height]) .style("display", "block") .style("margin", "0 0 20px 0"); // Create gradient for legend const defs = svg.append("defs"); const linearGradient = defs.append("linearGradient") .attr("id", "legend-gradient"); // Create color stops const numStops = 10; for (let i = 0; i <= numStops; i++) { const offset = i / numStops; let value; if (selectedMetric === "Student Enrollment") { // Use log scale interpolation for student enrollment const logMin = Math.log10(metricExtent[0] + 1); const logMax = Math.log10(metricExtent[1] + 1); const logValue = logMin + offset * (logMax - logMin); value = Math.pow(10, logValue) - 1; } else { value = metricExtent[0] + offset * (metricExtent[1] - metricExtent[0]); } linearGradient.append("stop") .attr("offset", `${offset * 100}%`) .attr("stop-color", metricColorScale(value)); } // Draw the gradient rectangle const legendWidth = width - marginLeft - marginRight; const legendHeight = 20; svg.append("rect") .attr("x", marginLeft) .attr("y", marginTop) .attr("width", legendWidth) .attr("height", legendHeight) .style("fill", "url(#legend-gradient)") .style("stroke", "#ccc") .style("stroke-width", 0.5); // Add axis for the scale let legendScale; let legendAxis; if (selectedMetric === "Student Enrollment") { // Use log scale for the axis legendScale = d3.scaleLog() .domain([metricExtent[0] + 1, metricExtent[1] + 1]) .range([marginLeft, width - marginRight]); // Create custom tick values for log scale (powers of 10 plus some intermediates) const logMin = Math.floor(Math.log10(metricExtent[0] + 1)); const logMax = Math.ceil(Math.log10(metricExtent[1] + 1)); let tickValues = []; // Add major ticks (powers of 10) and one intermediate for (let i = logMin; i <= logMax; i++) { tickValues.push(Math.pow(10, i)); if (i < logMax) { // Add one intermediate value (5 * 10^i) tickValues.push(5 * Math.pow(10, i)); } } // Filter to only include values within the actual domain tickValues = tickValues.filter(v => v >= metricExtent[0] && v <= metricExtent[1]); // Limit to max 5 tick marks if (tickValues.length > 5) { // Keep first, last, and evenly spaced middle values const step = Math.floor(tickValues.length / 4); tickValues = [ tickValues[0], tickValues[step], tickValues[step * 2], tickValues[step * 3], tickValues[tickValues.length - 1] ]; } const config = metricConfig[selectedMetric]; legendAxis = d3.axisBottom(legendScale) .tickValues(tickValues.map(v => v + 1)) // Adjust for the +1 offset .tickSize(4) .tickFormat(d => config.format(d - 1)); } else { legendScale = d3.scaleLinear() .domain(metricExtent) .range([marginLeft, width - marginRight]); const config = metricConfig[selectedMetric]; legendAxis = d3.axisBottom(legendScale) .ticks(5) .tickSize(4) .tickFormat(d => config.format(d)); } svg.append("g") .attr("transform", `translate(0, ${marginTop + legendHeight})`) .call(legendAxis) .call(g => g.select(".domain").remove()) .call(g => g.selectAll(".tick line") .attr("stroke", "#999")) .call(g => g.selectAll(".tick text") .attr("font-size", "11px") .attr("fill", "#666")); // Add title (use the label from config) svg.append("text") .attr("x", marginLeft) .attr("y", 12) .attr("font-size", "12px") .attr("font-weight", "600") .attr("fill", "#333") .text(metricConfig[selectedMetric].label); return svg.node(); }4e:T2aaf,map = { // Force cell re-run when these change selectedYear; selectedMetric; visualizationMode; selectedDistrictId; // Get references to existing elements const svg = d3.select(mapContainer); const g = svg.select("#main-map-group"); const tooltip = d3.select(".map-tooltip"); const config = metricConfig[selectedMetric]; const isBubbleMode = visualizationMode === "circles"; // Helper function to get fill color const getFillColor = (d) => { const enrollment = d.properties["Student Enrollment"]; // Check if district is below minimum size threshold if (enrollment != null && enrollment < params.minDistrictSize) { return "#e0e0e0"; // Light gray for filtered districts } if (isBubbleMode) return "#e0e0e0"; return d.properties[selectedMetric] != null ? metricColorScale(d.properties[selectedMetric]) : "#e0e0e0"; }; // Remove any existing hover outline group g.select(".hover-outline-group").remove(); // Remove any existing selected district outline group g.select(".selected-district-group").remove(); // Draw district shapes with transitions const districtPaths = g.selectAll(".district") .data(data, d => d.properties["Institution ID"]) .join( enter => enter.append("path") .attr("class", "district") .attr("data-institution-id", d => d.properties["Institution ID"]) .attr("d", pathGenerator) .attr("fill", getFillColor) .attr("stroke", "#ffffff") .attr("stroke-width", 0.5) .style("vector-effect", "non-scaling-stroke") .style("cursor", isBubbleMode ? "default" : "pointer"), update => update .transition() .duration(300) .ease(d3.easeCubicInOut) .attr("fill", getFillColor) .style("cursor", isBubbleMode ? "default" : "pointer"), exit => exit.remove() ); // Handle bubbles if in bubble mode if (isBubbleMode) { const nodes = data .filter(d => d.properties[selectedMetric] != null && d.geometry && d.properties['Student Enrollment'] >= params.minDistrictSize ) .map(district => { const centroid = pathGenerator.centroid(district); return { x: centroid[0], y: centroid[1], r: rScale(district.properties['Student Enrollment'] || 0), district: district, value: district.properties[selectedMetric] }; }) .filter(node => !isNaN(node.x) && !isNaN(node.y)); const simulation = d3.forceSimulation(nodes) .force('collision', d3.forceCollide().radius(d => d.r + 1.6).strength(0.8)) .force('x', d3.forceX(d => d.x).strength(0.1)) .force('y', d3.forceY(d => d.y).strength(0.1)) .stop(); for (let i = 0; i < 120; ++i) simulation.tick(); // Remove old bubble groups if they exist g.selectAll(".bubble-background").remove(); g.selectAll(".bubble").remove(); // Create white background circles first (all in one group for efficiency) g.selectAll(".bubble-background") .data(nodes, d => d.district.properties["Institution ID"]) .join("circle") .attr("class", "bubble-background") .attr("cx", d => d.x) .attr("cy", d => d.y) .attr("r", d => d.r + 1.5) // 1.5px larger radius for white outline .attr("fill", "white") .style("pointer-events", "none"); // Don't interfere with hover events // Create colored bubbles on top const bubbles = g.selectAll(".bubble") .data(nodes, d => d.district.properties["Institution ID"]) .join( enter => enter.append("circle") .attr("class", "bubble") .attr("cx", d => d.x) .attr("cy", d => d.y) .attr("r", d => d.r) .attr("fill", d => metricColorScale(d.value)) .style("cursor", "pointer") .style("opacity", 1), update => update .transition() .duration(300) .ease(d3.easeCubicInOut) .attr("fill", d => metricColorScale(d.value)) .attr("r", d => d.r), exit => exit.remove() ); } else { // Remove bubbles and backgrounds if switching from bubble mode to choropleth g.selectAll(".bubble-background").remove(); g.selectAll(".bubble").remove(); } // remove existing city labels first g.selectAll(".city-labels").remove() // Add city labels if enabled if (params.showCityLabels) { const cityGroup = g.append("g").attr("class", "city-labels"); majorCities.forEach(city => { const [x, y] = projection([city.lon, city.lat]); cityGroup.append("circle") .attr("cx", x) .attr("cy", y) .attr("r", 3) .attr("fill", "white") .attr("stroke", "#333") .attr("stroke-width", 1); const labelWidth = city.name.length * 6 + 10; cityGroup.append("rect") .attr("x", x + 6) .attr("y", y - 11.5) .attr("width", labelWidth) .attr("height", 16) .attr("rx", 4) .attr("fill", "white") .attr("opacity", 0.8); cityGroup.append("text") .attr("x", x + 10) .attr("y", y) .attr("font-size", "11px") .attr("fill", "#333") .attr("font-style", "italic") .text(city.name); }); } // Create selected district outline group (before hover group so hover is on top) const selectedDistrictGroup = g.append("g").attr("class", "selected-district-group"); // Add selected district outline if a district is selected if (selectedDistrictId && selectedDistrictId !== "") { const selectedDistrict = data.find(d => d.properties.GEOID === selectedDistrictId); if (selectedDistrict) { selectedDistrictGroup.append("path") .datum(selectedDistrict) .attr("d", pathGenerator) .attr("fill", "none") .attr("stroke", "#FF6B35") .attr("stroke-width", 2) .style("vector-effect", "non-scaling-stroke") .style("pointer-events", "none"); } } // Create hover outline group as the LAST element so it's always on top const hoverOutlineGroup = g.append("g").attr("class", "hover-outline-group"); // NOW set up the hover interactions after everything else is drawn districtPaths .on("mouseover", function(event, d) { if (isBubbleMode) return; const districtName = d.properties["Institution Name"]; const metricValue = d.properties[selectedMetric]; const originalValue = d.properties[`${selectedMetric}_original`]; const studentCount = d.properties["Student Enrollment"]; let metricText; if (metricValue == null) { metricText = "No data"; } else if (originalValue) { metricText = originalValue; } else { metricText = config.format(metricValue); } // Build tooltip with student count first let tooltipContent = `${districtName}`; // Always show student count first (unless it's the selected metric) if (selectedMetric !== "Student Enrollment") { tooltipContent += `
Total # students: ${studentCount ? studentCount.toLocaleString() : "No data"}`; } // Then show the selected metric tooltipContent += `
${config.label}: ${metricText}`; tooltip .html(tooltipContent) .style("opacity", 0.9); hoverOutlineGroup.selectAll("path").remove(); hoverOutlineGroup.append("path") .datum(d) .attr("d", pathGenerator) .attr("fill", "none") .attr("stroke", "#FF6B35") .attr("stroke-width", 1) .style("vector-effect", "non-scaling-stroke") .style("pointer-events", "none"); }) .on("mousemove", function(event) { if (isBubbleMode) return; tooltip .style("left", (event.pageX + 10) + "px") .style("top", (event.pageY - 10) + "px"); }) .on("mouseout", function() { if (isBubbleMode) return; tooltip.style("opacity", 0); hoverOutlineGroup.selectAll("path").remove(); }); // Set up bubble hover interactions if in bubble mode if (isBubbleMode) { const bubbles = g.selectAll(".bubble"); const bubbleBackgrounds = g.selectAll(".bubble-background"); bubbles .on("mouseover", function(event, d) { // Fade all bubbles except the hovered one bubbles.transition() .duration(200) .style("opacity", 0.3); d3.select(this).transition() .duration(200) .style("opacity", 1); // Fade all white backgrounds to 0 opacity bubbleBackgrounds.transition() .duration(200) .style("opacity", 0); // Keep the white background for the hovered bubble visible const hoveredDistrictId = d.district.properties["Institution ID"]; bubbleBackgrounds .filter(bg => bg.district.properties["Institution ID"] === hoveredDistrictId) .transition() .duration(200) .style("opacity", 1); const districtID = d.district.properties["Institution ID"]; districtPaths.filter(dist => dist.properties["Institution ID"] === districtID) .attr("fill", "#FF6B35"); const districtName = d.district.properties["Institution Name"] || `District ${d.district.properties["Institution ID"]}`; const metricValue = d.value; const originalValue = d.district.properties[`${selectedMetric}_original`]; const studentCount = d.district.properties['Student Enrollment']; let metricText; if (originalValue) { metricText = originalValue; } else { metricText = config.format(metricValue); } tooltip .html(`${districtName}
${config.label}: ${metricText}
Students: ${studentCount.toLocaleString()}`) .style("opacity", 1); }) .on("mousemove", function(event) { tooltip .style("left", (event.pageX + 10) + "px") .style("top", (event.pageY - 10) + "px"); }) .on("mouseout", function(event, d) { // Restore all bubbles to full opacity bubbles.transition() .duration(200) .style("opacity", 1); // Restore all white backgrounds to full opacity bubbleBackgrounds.transition() .duration(200) .style("opacity", 1); const districtID = d.district.properties["Institution ID"] districtPaths.filter(dist => dist.properties["Institution ID"] === districtID) .attr("fill", "#e0e0e0"); tooltip.style("opacity", 0); }); } return mapContainer; }4f:T5cf,metricConfig = { // Helper to create config objects const createConfig = (label, type = 'number') => { const formatters = { 'percentage': d => d.toFixed(1) + "%", 'count': d => d.toLocaleString(), 'number': d => d.toFixed(1), 'ratio': d => d.toFixed(1) + ":1" }; return { label, format: formatters[type], isPercentage: type === 'percentage' }; }; return { "Student Enrollment": createConfig("Student enrollment", "count"), "Students Experiencing Poverty": createConfig("Students experiencing poverty", "percentage"), "Free/Reduced Priced Lunch": createConfig("Free/reduced price lunch", "percentage"), "Regular Attenders": createConfig("Regular attenders", "percentage"), "Grade 3 ELA": createConfig("3rd grade students meeting ELA standards", "percentage"), "Grade 8 Mathematics": createConfig("8th grade students meeting mathematics standards", "percentage"), "Students with Disabilities": createConfig("Students with disabilities", "percentage"), "Ever English Learners": createConfig("Ever English learners", "percentage"), "Mobile Students": createConfig("Mobile students", "percentage"), "Teachers": createConfig("Teachers", "count"), "Students per Teacher": createConfig("Students per teacher", "ratio"), "Licensed Librarians": createConfig("Licensed librarians", "count"), "Students per Librarian": createConfig("Students per librarian", "ratio") }; }50:Tbc5,allYearsData = { const processFile = async (fileAttachment, year) => { const text = await fileAttachment.text(); const parsed = d3.csvParse(text, d3.autoType); const rows = []; // Define which fields should NOT be cleaned (text fields) const textFields = ['Institution Name', 'District Name', 'Superintendent', 'County', 'City']; parsed.forEach(row => { const districtId = getDistrictId(row); if (districtId) { const cleanedRow = {}; // Process each field Object.keys(row).forEach(key => { const value = row[key]; // Keep text fields as-is if (textFields.includes(key)) { cleanedRow[key] = value; return; } // Store original threshold values BEFORE any processing if (typeof value === 'string') { // Check if it's a threshold value (with or without %) const trimmed = value.trim(); if (trimmed.startsWith('<') || trimmed.startsWith('>') || trimmed === '*') { // Store the original string exactly as it appears cleanedRow[`${key}_original`] = trimmed; } } // Store cleaned value cleanedRow[key] = cleanValue(value); }); // Add metadata cleanedRow.year = year; cleanedRow.districtId = districtId; // Calculate student-to-staff ratios if (cleanedRow["Student Enrollment"] != null && cleanedRow["Teachers"] != null && cleanedRow["Teachers"] > 0) { cleanedRow["Students per Teacher"] = cleanedRow["Student Enrollment"] / cleanedRow["Teachers"]; } if (cleanedRow["Student Enrollment"] != null && cleanedRow["Licensed Librarians"] != null && cleanedRow["Licensed Librarians"] > 0) { cleanedRow["Students per Librarian"] = cleanedRow["Student Enrollment"] / cleanedRow["Licensed Librarians"]; } rows.push(cleanedRow); } }); return rows; }; // Load all files with literal FileAttachment calls const files2022 = await Promise.all([ processFile(FileAttachment("AAGmediaDistrictsAggregate22.csv"), 2022), processFile(FileAttachment("SpEdMediaDistrict22.csv"), 2022) ]); const files2023 = await Promise.all([ processFile(FileAttachment("AAGmediaDistrictsAggregate23.csv"), 2023), processFile(FileAttachment("SpEdMediaDistrict23.csv"), 2023) ]); const files2024 = await Promise.all([ processFile(FileAttachment("AAGmediaDistrictsAggregate24.csv"), 2024), processFile(FileAttachment("SpEdMediaDistrict24.csv"), 2024) ]); const files2025 = await Promise.all([ processFile(FileAttachment("AAGmediaDistrictsAggregate25.csv"), 2025) //processFile(FileAttachment("SpEdMediaDistrict25.csv"), 2025) // data not available yet ]); return [...files2022, ...files2023, ...files2024, ...files2025].flat(); }51:Tdf6,data = { if (!rawData) return []; const geojsonData = topojson.feature(rawData, rawData.objects["OR_SDs_merged_24"]); // Define which fields should NOT be cleaned (text fields) const textFields = ['Institution Name', 'District Name', 'Superintendent', 'County', 'City']; let features = geojsonData.features.map(district => { const props = district.properties; // Store original values before cleaning const originalValues = {}; Object.keys(props).forEach(key => { // Skip text fields if (textFields.includes(key)) return; if (typeof props[key] === 'string') { const trimmed = props[key].trim(); if (trimmed.startsWith('<') || trimmed.startsWith('>') || trimmed === '*') { // Store the exact original string originalValues[`${key}_original`] = trimmed; } } }); // Clean only numeric/percentage property values Object.keys(props).forEach(key => { // Skip text fields if (textFields.includes(key)) return; const cleaned = cleanValue(props[key]); if (cleaned !== props[key]) { props[key] = cleaned; } }); // Add back original values Object.assign(props, originalValues); // Merge current year data if (currentYearData?.has(props["Institution ID"])) { const yearData = currentYearData.get(props["Institution ID"]); const excludeKeys = ['District ID', 'DistrictID', 'District Name', 'Institution Name', 'Superintendent', 'year', 'districtId']; Object.entries(yearData) .filter(([key]) => !excludeKeys.includes(key) && !textFields.includes(key)) .forEach(([key, value]) => { // Store original if it's a threshold value (preserve from yearData if it exists) if (yearData[`${key}_original`]) { props[`${key}_original`] = yearData[`${key}_original`]; } else if (typeof value === 'string') { const trimmed = value.trim(); if (trimmed.startsWith('<') || trimmed.startsWith('>') || trimmed === '*') { props[`${key}_original`] = trimmed; } } props[key] = cleanValue(value); }); // Map year-specific metric keys to standard metric names // Handle "Regular Attenders" mapping if (selectedYear === 2022 && yearData["K-2 Regular Attenders"] !== undefined) { props["Regular Attenders"] = cleanValue(yearData["K-2 Regular Attenders"]); if (yearData["K-2 Regular Attenders_original"]) { props["Regular Attenders_original"] = yearData["K-2 Regular Attenders_original"]; } } } return district; }); // Apply grade level filter const gradeLevel = params.gradeLevel; let filteredFeatures; if (gradeLevel === "all") { filteredFeatures = features; } else { filteredFeatures = features.filter(d => { const props = d.properties; if (gradeLevel === "lower") { // Lower grades: ELSDLEA or UNSDLEA must have a numeric value return (props.ELSDLEA != null && !isNaN(props.ELSDLEA)) || (props.UNSDLEA != null && !isNaN(props.UNSDLEA)); } else if (gradeLevel === "upper") { // Upper grades: SCSDLEA or UNSDLEA must have a numeric value return (props.SCSDLEA != null && !isNaN(props.SCSDLEA)) || (props.UNSDLEA != null && !isNaN(props.UNSDLEA)); } return true; }); } // Return the filtered features return filteredFeatures; }52:T40f,majorCities = [ { name: "Portland", lon: -122.6784, lat: 45.5152 }, { name: "Salem", lon: -123.0351, lat: 44.9429 }, { name: "Eugene", lon: -123.0868, lat: 44.0521 }, { name: "Bend", lon: -121.3153, lat: 44.0582 }, { name: "Medford", lon: -122.8756, lat: 42.3265 }, { name: "Astoria", lon: -123.8313, lat: 46.1879 }, { name: "Tillamook", lon: -123.8440, lat: 45.4562 }, { name: "Newport", lon: -124.0534, lat: 44.6368 }, { name: "Coos Bay", lon: -124.2179, lat: 43.3665 }, { name: "Corvallis", lon: -123.2620, lat: 44.5646 }, { name: "Roseburg", lon: -123.3417, lat: 43.2165 }, { name: "Grants Pass", lon: -123.3314, lat: 42.4390 }, { name: "Klamath Falls", lon: -121.7817, lat: 42.2249 }, { name: "Redmond", lon: -121.1739, lat: 44.2726 }, { name: "Pendleton", lon: -118.7886, lat: 45.6721 }, { name: "La Grande", lon: -118.0877, lat: 45.3246 }, { name: "Baker City", lon: -117.8344, lat: 44.7749 }, { name: "Ontario", lon: -116.9629, lat: 44.0266 }, { name: "Burns", lon: -119.0541, lat: 43.5863 } ]53:[{"id":"9be01d5b3efbc58b06e39a3c25b3077ae6369d6cf828ffa96bce72635013a2aae2a44ab8c3bdb57a0ef12f643e06cad82ad1da3732b9f38a13b783873564aaf0","href":"https://static.observableusercontent.com/files/9be01d5b3efbc58b06e39a3c25b3077ae6369d6cf828ffa96bce72635013a2aae2a44ab8c3bdb57a0ef12f643e06cad82ad1da3732b9f38a13b783873564aaf0","name":"AAGmediaDistrictsAggregate25.csv","type":"text/csv","lastModified":1763829406347.518,"size":41662},{"id":"f44a37169fc7a06510d66d8abdae422b913e2939b42681696e9b7fa84eb41924599908b87e32d83113cf5ae74804f709ee6bfde59bf0d344ed41fd32bf7cf5a5","href":"https://static.observableusercontent.com/files/f44a37169fc7a06510d66d8abdae422b913e2939b42681696e9b7fa84eb41924599908b87e32d83113cf5ae74804f709ee6bfde59bf0d344ed41fd32bf7cf5a5","name":"AAGmediaDistrictsAggregate22.csv","type":"text/csv","lastModified":1760647256252.527,"size":24822},{"id":"d75390830793cc40cce41667e59f5d90fe5a3afd4d221315a1f6cfd9452f31d4d081097e949b9c17515754abaa1a86cab8a91a932bc77767fe77cdb81d22dea3","href":"https://static.observableusercontent.com/files/d75390830793cc40cce41667e59f5d90fe5a3afd4d221315a1f6cfd9452f31d4d081097e949b9c17515754abaa1a86cab8a91a932bc77767fe77cdb81d22dea3","name":"AAGmediaDistrictsAggregate23.csv","type":"text/csv","lastModified":1760647254172.758,"size":41792},{"id":"94f4078d8a6f079bc869bdbada951cb8ed224e5016521af2451ba6b0f6962d2337e4afba65e617028c51ef7b85614267a51ba824c19c61b656427d02c653d3bb","href":"https://static.observableusercontent.com/files/94f4078d8a6f079bc869bdbada951cb8ed224e5016521af2451ba6b0f6962d2337e4afba65e617028c51ef7b85614267a51ba824c19c61b656427d02c653d3bb","name":"AAGmediaDistrictsAggregate24.csv","type":"text/csv","lastModified":1760647251929.115,"size":41767},{"id":"d5414a9d8b76935757a9cec19dca32db0eaf8f327b6d456a3fdd93ae2862f0e21e84d5601809c57af962990f43f39357a4c8eeb19ff6487cc84979f63d42dd25","href":"https://static.observableusercontent.com/files/d5414a9d8b76935757a9cec19dca32db0eaf8f327b6d456a3fdd93ae2862f0e21e84d5601809c57af962990f43f39357a4c8eeb19ff6487cc84979f63d42dd25","name":"SpEdMediaDistrict22.csv","type":"text/csv","lastModified":1760647249552.146,"size":104654},{"id":"56d38b60f42e70039a764ed74ad92b7f80475b4cfd0824481fadf0e83c1a83da2a172634483c8dc381ed1706ecae1ee7c332d1cd63bf1f6102cf4eefdd64e481","href":"https://static.observableusercontent.com/files/56d38b60f42e70039a764ed74ad92b7f80475b4cfd0824481fadf0e83c1a83da2a172634483c8dc381ed1706ecae1ee7c332d1cd63bf1f6102cf4eefdd64e481","name":"SpEdMediaDistrict23.csv","type":"text/csv","lastModified":1760647247586.997,"size":90581},{"id":"c5b574fe83091a0348cac23c37aa105d301621bc2b5442695f8c86c8a0e63e04ee3a18acae941b4bf08728c001b033840a2e3be73b34f383baa594edae7ced86","href":"https://static.observableusercontent.com/files/c5b574fe83091a0348cac23c37aa105d301621bc2b5442695f8c86c8a0e63e04ee3a18acae941b4bf08728c001b033840a2e3be73b34f383baa594edae7ced86","name":"SpEdMediaDistrict24.csv","type":"text/csv","lastModified":1760647245483.076,"size":90666}] 47:{"id":"78ecd22022d58945","slug":"oregon-schools-data","title":"Oregon Schools Data","thumbnail":"5c10b4a7373dfdd655dea4e0bef469df3f2b576a1c583584465608ea696a6c0e","access_level":"public","create_time":"$D2025-10-16T20:08:06.603Z","update_time":"$D2025-11-26T00:09:16.180Z","view_time":null,"first_public_time":"$D2025-11-26T00:15:57.696Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"bdd5b15ae58c174e","login":"bronna","name":"Brianna Wilson","avatar_url":"https://avatars-next.observableusercontent.com/e8378cd926f2998bd803d1651f90f4c1442c923062ce42676a4fc5460cf815fc","tier":"starter_2024","bio":"data journalist, gardener, engineer","followed_by_you":false,"follows_you":false},"version":513,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"dc0841074bf3ab25","login":"briannawilson","name":"Brianna Wilson","avatar_url":"https://avatars-next.observableusercontent.com/eee1750230ba4eac2ba9c81f461a7c2cb3c2448d6fd4b00a8f3f13a73e80c37c","tier":null,"bio":"Visualizing, writing about design + data. Former product design engineer at Apple and Stanford 🌲. Down syndrome mom 💛💙, Oregon 🌲🌲","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"dc0841074bf3ab25","login":"briannawilson","name":"Brianna Wilson","avatar_url":"https://avatars-next.observableusercontent.com/eee1750230ba4eac2ba9c81f461a7c2cb3c2448d6fd4b00a8f3f13a73e80c37c","tier":null,"role":"editor"},{"type":"team","id":"bdd5b15ae58c174e","login":"bronna","name":"Brianna Wilson","avatar_url":"https://avatars-next.observableusercontent.com/e8378cd926f2998bd803d1651f90f4c1442c923062ce42676a4fc5460cf815fc","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Oregon Schools Data","cells":[{"id":0,"value":"# Oregon Schools Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":306,"value":"viewof selectedDistrictId = Inputs.select(\n data && data.length > 0 \n ? new Map([\n [\"None\", \"\"],\n ...data.filter(d => \n d.properties.GEOID !== \"999999\" && \n d.properties[\"Institution Name\"] && \n d.properties[\"Institution Name\"].trim() !== \"\" &&\n !(/^\\d+$/.test(d.properties[\"Institution Name\"])) // Filter out pure numbers\n )\n .sort((a, b) => {\n // Sort alphabetically by institution name\n const nameA = a.properties[\"Institution Name\"].toLowerCase();\n const nameB = b.properties[\"Institution Name\"].toLowerCase();\n return nameA < nameB ? -1 : nameA > nameB ? 1 : 0;\n })\n .map(d => [d.properties[\"Institution Name\"], d.properties.GEOID])\n ])\n : new Map([[\"None\", \"\"]]), // Fallback when data is not ready\n {\n label: \"Find a district\",\n value: \"\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"### Chart configuration","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":129,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"$4f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"metricColorScale = {\n if (selectedMetric === \"Student Enrollment\") {\n // Use log scale for student enrollment\n // Add 1 to avoid log(0) issues\n const logExtent = [\n Math.log10(metricExtent[0] + 1),\n Math.log10(metricExtent[1] + 1)\n ];\n \n return (value) => {\n if (value == null || value === 0) return \"#DBD7D7\";\n const logValue = Math.log10(value + 1);\n const normalized = (logValue - logExtent[0]) / (logExtent[1] - logExtent[0]);\n return d3.interpolateGnBu(normalized);\n };\n } else if (selectedMetric === \"Students with Disabilities\") {\n // return d3.scaleDiverging(d3.interpolateBrBG)\n // .domain([0, 11, 25]) \n // .clamp(true);\n return d3.scaleSequential(d3.interpolateGnBu)\n .domain([0, 25])\n .clamp(true);\n } else {\n // Use linear scale for all other metrics\n return d3.scaleSequential(d3.interpolateGnBu)\n .domain(metricExtent);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"metricExtent = {\n const largeDistricts = allYearsData.filter(d => d[\"Student Enrollment\"] >= minDistrictSize)\n \n const filteredValues = (largeDistricts || [])\n .filter(row => {\n const actualKey = getMetricKey(selectedMetric, row.year);\n return row[actualKey] != null;\n })\n .map(row => {\n const actualKey = getMetricKey(selectedMetric, row.year);\n return row[actualKey];\n });\n\n return d3.extent(filteredValues);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":446,"value":"minDistrictSize = params.minDistrictSize","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"rScale = {\n return d3.scaleSqrt()\n .domain(enrollmentExtent)\n .range([1, 30]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":344,"value":"enrollmentExtent = {\n const largeDistricts = allYearsData.filter(d => \n d[\"Student Enrollment\"] && d[\"Student Enrollment\"] >= params.minDistrictSize\n );\n \n const filteredValues = (largeDistricts || [])\n .filter(row => row[\"Student Enrollment\"] != null)\n .map(row => row[\"Student Enrollment\"]);\n \n return d3.extent(filteredValues);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"pathGenerator = projection ? d3.geoPath(projection) : null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"projection = {\n if (!data || data.length === 0) return null;\n \n const centralLat = 43.9;\n const centralLong = -120.5;\n \n const featureCollection = {\n type: \"FeatureCollection\",\n features: data\n };\n\n return d3.geoTransverseMercator()\n .rotate([-centralLong, -centralLat])\n .fitSize([dims.width, dims.height], featureCollection);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"dims = ({ width: 830, height: 600 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"bounds = {\n if (!data || data.length === 0) return { minLng: 0, minLat: 0, maxLng: 0, maxLat: 0 };\n \n let minLng = Infinity, minLat = Infinity, maxLng = -Infinity, maxLat = -Infinity;\n \n data.forEach(feature => {\n if (feature.geometry) {\n const [[featureMinLng, featureMinLat], [featureMaxLng, featureMaxLat]] = d3.geoBounds(feature);\n minLng = Math.min(minLng, featureMinLng);\n minLat = Math.min(minLat, featureMinLat);\n maxLng = Math.max(maxLng, featureMaxLng);\n maxLat = Math.max(maxLat, featureMaxLat);\n }\n });\n \n return { minLng, minLat, maxLng, maxLat };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":286,"value":"selectedYear = params.dataYear","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":289,"value":"selectedMetric = params.metric","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"visualizationMode = params.visualizationMode","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"### Data load & processing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":61,"value":"currentYearData = {\n const yearData = new Map();\n \n allYearsData\n .filter(row => row.year === selectedYear && row.districtId)\n .forEach(row => {\n const id = Number(row.districtId);\n if (yearData.has(id)) {\n Object.assign(yearData.get(id), row);\n } else {\n yearData.set(id, {...row});\n }\n });\n \n return yearData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"$50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"$51","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"getMetricKey = {\n const yearSpecificKeys = {\n \"Regular Attenders\": {\n 2022: \"K-2 Regular Attenders\",\n 2023: \"Regular Attenders\",\n 2024: \"Regular Attenders\"\n }\n };\n \n return (metric, year) => {\n if (yearSpecificKeys[metric] && yearSpecificKeys[metric][year]) {\n return yearSpecificKeys[metric][year];\n }\n return metric;\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"rawData = d3.json(\"https://raw.githubusercontent.com/bronna/iepdata/refs/heads/main/src/lib/data/oregon_data_24.json\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"$52","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"### Imports & utilities","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":28,"value":"cleanValue = (value) => {\n if (value == null || value === undefined) return null;\n if (typeof value !== 'string') return value;\n \n // Handle masked data\n if (value === '*') return null;\n \n // Remove % sign first if present\n const cleanedValue = value.replace('%', '').trim();\n \n // Handle threshold values\n if (cleanedValue.startsWith('<')) {\n const threshold = parseFloat(cleanedValue.substring(1));\n return threshold / 2; // <5 becomes 2.5\n }\n if (cleanedValue.startsWith('>')) {\n const threshold = parseFloat(cleanedValue.substring(1));\n return threshold + 2.5; // >95 becomes 97.5\n }\n \n const num = parseFloat(cleanedValue);\n return isNaN(num) ? null : num;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"getOriginalValue = (value) => {\n if (typeof value !== 'string') return null;\n if (value === '*' || value.startsWith('<') || value.startsWith('>')) {\n return value;\n }\n return null;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"calculateWeightedInclusion = (props) => {\n // TODO: add in disability categories\n if (!props[\"Total Student Count\"] || props[\"LRE Students >80%\"] == null) {\n return null;\n }\n \n const weights = { inclusive: 0.9, semiInclusive: 0.6, nonInclusive: 0.2, separate: 0 };\n const total = props[\"Total Student Count\"];\n \n return (\n ((props[\"LRE Students >80%\"] / 100) * total) * weights.inclusive +\n ((props[\"LRE Students >40% <80%\"] / 100) * total) * weights.semiInclusive +\n ((props[\"LRE Students <40%\"] / 100) * total) * weights.nonInclusive +\n ((props[\"LRE Students Separate Settings\"] / 100) * total) * weights.separate\n ) / total * 100;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"getDistrictId = (row) => {\n return row['Institution ID'] || row['District ID'] || \n row.InstitutionID || row.DistrictID || \n row.institution_id || row.district_id;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"d3 = require(\"d3@7\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"topojson = require(\"topojson-client@3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W53","stdlib":"1"}} 24:null