30:T7f4,{ let dateCutoff = firstDateForPlot; let endDate = lastDateForPlot; let offenseGroup = "violent"; //let offenseGroup = "property"; let offense = ""; let x = selectX ; //let x = "reportDateTime"; //let x = "startDateTime"; //let x = "endDateTime"; let timePeriodString = selectFirstDayOfWeek == "Day" ? "daily" : "weekly"; let xKeyDescriptions = { reportDate: "by date reported", endDate: "by end date of crime", startDate: "by start date of crime", } let xKeyDestription = xKeyDescriptions[selectX]; //let data = violentCrimesMapped.filter(d=>d.timeExtentDays < 7); //let data = violentCrimesMapped.filter(d=>d[x] >= dateCutoff && d[x] <= endDate && d.offensegroup == offenseGroup); let data = allCrimesAllMonthsMapped.filter(d=>d[x] >= dateCutoff && d[x] <= endDate && violentOffenses[d.OFFENSE]); data = d3.sort(data, d=>-d.OFFENSE.length); // I just want robbery to be last and ADW first let maxY = 17; let rectY = Plot.rectY( data, Plot.binX({ y: "count" }, { x, tip: true, fill:d=>d.OFFENSE, thresholds:d3["utc" + selectFirstDayOfWeek], inset: 0 }) ); //console.log("rectY",rectY); return Plot.plot({ title: "Violent crime reported in DC, " + timePeriodString + " " + xKeyDestription, //subtitle: "Subtitle", caption: html`Data from https://crimecards.dc.gov/ · Chart from: https://observablehq.com/@andy-bloch/dc-crime`, width, marginBottom: 40, color: { //domain: colorDomain, domain: ["assault w/dangerous weapon","homicide","sex abuse","robbery"], legend: true, }, x: { grid: true }, y: { grid: true }, marks: [ //Plot.areaY(nationalsSchedule.filter(d=>d.date && d.Win),{x:d=>d.date, y1: 0, y2:d=>d.homeGame?maxY:0, fill: "#fdd", curve:"step-after"}), Plot.rectY( data, Plot.binX({ y: "count" }, { x, tip: true, fill:d=>d.OFFENSE, thresholds:d3["utc" + selectFirstDayOfWeek], inset: 0 }) ), Plot.ruleY([0]), ] }); }31:T121d,function plotAllCrimes(dataIn, title="All crime reported in DC", colorKey = selectColorKey) { if (!dataIn.length) { return md`#### No data`; } let dateCutoff = firstDateForPlot; let offenseGroup = "violent"; //let offenseGroup = "property"; let offense = ""; function y(d) { return 1; } //let colorDomain = ["motor vehicle theft", "theft/other", "theft f/auto", "sex abuse", "assault w/dangerous weapon", "robbery", "burglary", "homicide", "arson"]; //:d=>d.OFFENSE + " " + (d.reportDelayEndDays < 1? 1 : 0) let offenseCounts = d3.flatRollup(dataIn, v=>v.length, d=>d.OFFENSE); let offensesInData = offenseCounts.filter(d=>d[1]).map(d=>d[0]); console.log("offenseCounts",offenseCounts); let colorKeyMap = { "By offense": "OFFENSE", "By reporting delay days" : "reportDelayEndDays", }; colorKey = colorKeyMap[colorKey] || colorKey; let colorSortOffense = { "theft/other": 0, "motor vehicle theft": 1, "theft f/auto": 2, "burglary": 3, "robbery": 4, "sex abuse": 5, "assault w/dangerous weapon":6, "homicide": 7, "arson":8}; let colorDomainOffense = offensesInData; //Object.keys(colorSort); let colorDomainInt = d3.range(0,rangeDelayDaysMax+1); let colorRanges = { reportDelayEndDays: colorScheme, OFFENSE: offensesInData.map(d=>colorScheme[colorSortOffense[d]]), }; let colorRange = colorRanges[colorKey] || colorScheme; console.log({colorRanges, colorRange}); colorDomainInt = [0, 1, 2, rangeDelayDaysMax]; let colorDomains = { reportDelayEndDays: colorDomainInt, OFFENSE: colorDomainOffense, }; let colorDomain = colorDomains[colorKey] || undefined; let colorSortFunctions = { OFFENSE: d=>colorSort[d.OFFENSE], } let getDate = d=> d && (d.endDate || d.startDate || d.reportDate); let x = d=>d[selectX] || d.endDate || d.startDate || d.reportDate ; //let x = "reportDateTime"; //let x = "startDateTime"; //let x = "endDateTime"; let timePeriodString = selectFirstDayOfWeek == "Day" ? "daily" : "weekly"; if (selectFirstDayOfWeek == "Month") { timePeriodString = "monthly"; } //let data = violentCrimesMapped.filter(d=>d.timeExtentDays < 7); let lastDate = d3.max(dataIn, getDate); //console.log("lastDate",lastDate) if (!lastDate) { console.log("No last date",dataIn); } let cutoffDate = new Date(lastDate.valueOf() - new Date().valueOf() + dateCutoff.valueOf() ) let data = dataIn.filter(d=>x(d) > cutoffDate && d.endDate.valueOf() <= d.reportDate.valueOf()); //let data = dataIn ; let maxY = 17; function fillByKey(d) { return d[colorKey]; } function fillByKeyRounded(d) { let days = Math.min(rangeDelayDaysMax,Math.round(d[colorKey]+rangeHoursToAddBeforeRounding/24)); if (days > 2 && days < rangeDelayDaysMax) { days = 2; } return days; } let fill = colorKey == "reportDelayEndDays" ? fillByKeyRounded : fillByKey; let colorSortFunction = colorSortFunctions[colorKey] || fill; data = d3.sort(data, colorSortFunction); let rectY = Plot.rectY( data, Plot.binX({ y: "count" }, { x, tip: true, fill:d=>d.OFFENSE, thresholds:d3["utc" + selectFirstDayOfWeek], inset: 0 }) ); //console.log("rectY",rectY); let nationalGuardDate = new Date("August 12, 2025") ; let offensesString = offenseCounts.length < 9 ? "Offense types: " + offenseCounts.map(d=>d[0]).join(", ") + ", " : ""; return Plot.plot({ title: title + ", " + timePeriodString, subtitle: offensesString + "by " + selectX, caption: html`Data from https://crimecards.dc.gov/ · Chart from: https://observablehq.com/@andy-bloch/dc-crime`, width, marginBottom: 40, color: { range: colorRange, domain: colorDomain, legend: true, }, x: { grid: true, label: selectX }, y: { grid: true }, marks: [ //Plot.areaY(nationalsSchedule.filter(d=>d.date && d.Win),{x:d=>d.date, y1: 0, y2:d=>d.homeGame?maxY:0, fill: "#fdd", curve:"step-after"}), Plot.rectY( data, //Plot.binX({ y: "sum" }, { x, y, tip: true, fill:d=>d.OFFENSE, z: d=>d.OFFENSE + " " + (d.endDate == d.reportDate ? 1 : 0), thresholds:d3["utc" + selectFirstDayOfWeek], inset: 0 }), Plot.binX({ y: "sum" }, { x, y, tip: true, fill, thresholds:d3["utc" + selectFirstDayOfWeek], inset: 0 }) ), Plot.ruleY([0]), (lastDate < nationalGuardDate) ? null : [ Plot.ruleX([nationalGuardDate]), Plot.text([{date: nationalGuardDate, text:"Jan 12, 2025"}],{x:d=>d.date, y:"top", textAnchor:"start", text: d=>d.text}), ], ] }); }32:T4f1,function compareObjects(o1,o2, ignoreKeys={}) { if ((!o1 || !o2) && o1 !== o2) { return { d1 : o1, d2 : o2, changes: 1, }; } if (typeof(o1) !== "object" || typeof(o2) !== "object") { if (o1 === o2) { return { d1:{}, d2:{}, changes: 0 }; } return { d1: o1, d2: o2, changes: 1, }; } let d1 = {}; let d2 = {}; let changes = 0; Object.keys(o1).forEach(k=>{ if (k in ignoreKeys) { return; } if (k in o2) { if (o1[k] === o2[k]) { return ; } if (typeof(o1[k])== "object" && o1[k] && typeof(o2[k])== "object" && o2[k]) { let c = compareObjects(o1[k],o2[k], ignoreKeys); if (Object.keys(c.d1).length) { d1[k] = c.d1; } if (Object.keys(c.d2).length) { d2[k] = c.d2; } changes += c.changes; return; } else { changes ++; } d1[k] = o1[k]; d2[k] = o2[k] } else { changes ++; d1[k] = o1[k]; } }); Object.keys(o2).forEach(k=>{ if (k in ignoreKeys) { return; } if (!(k in o1)) { changes ++; d2[k] = o2[k]; } }); return {d1,d2, changes}; } 33:T696,function processCrimeData(data) { let dayMs = 24*60*60*1000; let tzOffset = 4 * 60*1000; let deleteKeys = ["XBLOCK","OCTO_RECORD_ID", "BID", "sector", "BLOCK", "PSA", "BLOCK_GROUP", "NEIGHBORHOOD_CLUSTER", "VOTING_PRECINCT", "location", "CENSUS_TRACT", "ucr-rank", "CCN", "ANC", "YBLOCK", "_id", "_cursor"]; data.forEach(d=>{ d.startDateTime = new Date(d.START_DATE); d.endDateTime = d.END_DATE ? new Date(d.END_DATE) : d.startDateTime; d.timeExtent = d.endDateTime.valueOf() - d.startDateTime.valueOf() ; d.timeExtentDays = d.timeExtent / dayMs ; d.reportDateTime = new Date(d.REPORT_DAT); d.reportDelayEnd = d.reportDateTime.valueOf() - d.endDateTime.valueOf() ; d.reportDelayStart = d.reportDateTime.valueOf() - d.startDateTime.valueOf() ; if (d.reportDelayStart < 0) { d.startDateTime = d.reportDateTime ; d.reportDelayStart = 0 ; } if (d.reportDelayEnd < 0) { // Assuming end date is bad if after report date, changing to start date d.endDateTime = d.startDateTime ; d.reportDelayEnd = d.reportDelayStart; } d.midDateTime = new Date((d.endDateTime.valueOf() + d.startDateTime.valueOf())/2); d.reportDate = getDateInTimezoneExact(d.reportDateTime); d.startDate = getDateInTimezoneExact(d.startDateTime); d.endDate = getDateInTimezoneExact(d.endDateTime); d.midDate = getDateInTimezoneExact(d.midDateTime); d.reportDelayStartDays = d.reportDelayStart / dayMs ; d.reportDelayEndDays = d.reportDelayEnd / dayMs ; if (d.reportDelayEndDays > 30) { d.reportDelayEndDays = null; } deleteKeys.forEach(k=> delete d[k]); }); return data; }34:Tded,async function addCrimesToMap(priorCrimesFirst = true) { let crimes = recentCrimes; let radius = 150; let opacity = 0.5; let offenses = Object.fromEntries(checkboxOffensesMap.map(d=>[d,1])); //let offenses = {"theft f/auto":1,"motor vehicle theft":1}; //let offenses = {"theft f/auto":0,"motor vehicle theft":1}; //let offenses = violentOffenses; crimes = crimes.filter(d=>offenses[d.OFFENSE]); let yearOfInterest = 2025; let d2024fallStart = getDateInTimezoneExact(new Date(`2024/09/03`)); let d2025summerStart = getDateInTimezoneExact(new Date("2025/06/01")); // Before deployment v. after let d1 = getDateInTimezoneExact(new Date(`${yearOfInterest}/06/24`)); let d2 = getDateInTimezoneExact(new Date(`${yearOfInterest}/08/12`)); let d3 = getDateInTimezoneExact(new Date(`${yearOfInterest}/09/30`)); let lastDate = d3; // Before deployment //let d1 = getDateInTimezoneExact(new Date(`${yearOfInterest}/07/16`)); //let d2 = getDateInTimezoneExact(new Date(`${yearOfInterest}/07/29`)); //let d3 = getDateInTimezoneExact(new Date(`${yearOfInterest}/08/11`)); // After deployment changes //let d1 = getDateInTimezoneExact(new Date(`${yearOfInterest}/08/13`)); //let d2 = getDateInTimezoneExact(new Date(`${yearOfInterest}/08/26`)); //let d3 = getDateInTimezoneExact(new Date(`${yearOfInterest}/09/08`)); //let recentCrimesRed = crimes.filter(d=>d.reportDelayEndDays > 2 && d.reportDelayEndDays < 7); //let recentCrimesGreen = crimes.filter(d=>d.reportDelayEndDays <= 2); //let recentCrimesBlue = crimes.filter(d=>d.reportDelayEndDays >= 7); //let dateKey = "reportDateTime"; let dateKey = "endDateTime"; //let recentCrimesDarkRed = crimes.filter(d=> d2024fallStart <= d[dateKey] && d[dateKey] <= d2025summerStart); //let recentCrimesRed = crimes.filter(d=> d2025summerStart < d[dateKey] && d[dateKey] < d1 || d[dateKey] < d2024fallStart); let showRed = false ; if (showRed) { let recentCrimesDarkRed = crimes.filter(d=> d[dateKey] <= d2025summerStart); let recentCrimesRed = crimes.filter(d=> d2025summerStart < d[dateKey] && d[dateKey] < lastDate); let layerDarkRed = addCircles(recentCrimesDarkRed,[150,0,0,0.05], radius); let layerRed = addCircles(recentCrimesRed,[255,0,0,0.1], radius); } let recentCrimesGreen = crimes.filter(d=>d[dateKey] >= d1 && d[dateKey] < d2 ); let recentCrimesBlue = crimes.filter(d=>d[dateKey] >= d2 && d[dateKey] < d3 ); let context = (viewof map).getElementsByTagName("canvas")[0].getContext("2d"); let originalBlendMode = context.globalCompositeOperation ; let layerBlue = addCircles(recentCrimesBlue,[0,0,255,opacity],radius, null); let layerGreen = addCircles(recentCrimesGreen,[0,128,0,opacity], radius, null); globals.layerBlue = layerBlue; globals.layerGreen = layerGreen; if (priorCrimesFirst) { layerBlue.setZIndex(100); layerGreen.setZIndex(200); //addCircles(recentCrimesBlue,[0,0,255,0.5],radius, layerGreen); //addCircles(recentCrimesGreen,[0,255,0,1],radius, null, "lighter"); //context.globalCompositeOperation = originalBlendMode; //addCircles(recentCrimesGreen,[0,255,0,0.25]); //addCircles(recentCrimesBlue,[0,0,255,0.1]); } else { layerBlue.setZIndex(200); layerGreen.setZIndex(100); //let layer = addCircles(recentCrimesGreen,[0,255,0,1], 150, null); //addCircles(recentCrimesBlue,[0,0,255,1],150, layer); //layer = addCircles(recentCrimesGreen,[0,255,0,0.5], 150, layer); } }35:T7fa,addCircles = { //return ()=>{}; // Adapted from https://observablehq.com/@tmshv/tomsk-instagram-analysis // and https://openlayers.org/en/v3.20.1/examples/blend-modes.html var resetBlendMode = function(evt) { evt.context.globalCompositeOperation = 'source-over'; }; function addCircles(data, color="blue", radius, layer, blendMode) { console.log("Adding circles",{data,color,radius, layer, blendMode}); var setBlendMode = function(evt) { evt.context.globalCompositeOperation = blendMode; }; let vectorSource ; if (!layer) { vectorSource= new ol.source.Vector(); layer = new ol.layer.Vector({ source: vectorSource, zIndex: 20 }); map.addLayer(layer); circleLayers.push(layer); if (blendMode) { layer.on('precompose', setBlendMode); layer.on('postcompose', resetBlendMode); } } else { console.log("Reusing layer",layer); vectorSource = layer.getSource(); } data.forEach(d => { const radius1 = radius || 150 ; const radius2 = 15 ; //console.log("Adding",d); const coord = ol.proj.fromLonLat([d.LONGITUDE || d.longitude, d.LATITUDE || d.latitude]); //console.log("Adding",{radius1,coord}); let circleFeature = new ol.Feature(new ol.geom.Circle(coord, radius1)); let circleFeature2 = new ol.Feature(new ol.geom.Circle(coord, radius2)); circleFeature.setStyle(new ol.style.Style({ fill: new ol.style.Fill({ color, // Set fill color for the circle }), })); vectorSource.addFeature(circleFeature); let smallCircles = false; if (smallCircles) { circleFeature2.setStyle(new ol.style.Style({ stroke: new ol.style.Stroke({ color, // Set stroke color for the line width: 2, }), })); vectorSource.addFeature(circleFeature2); } //console.log("Added",{radius,coord}); }); return layer; } return addCircles; }36:[{"id":"a9b5ec2afbb35fa596fe3380333a308ba57472f891c1609909e0b0e925d72dbc919fa35addf43960d515e4a7cf76a227158dc24e2a865c6aebdd673ec7f4b004","href":"https://static.observableusercontent.com/files/a9b5ec2afbb35fa596fe3380333a308ba57472f891c1609909e0b0e925d72dbc919fa35addf43960d515e4a7cf76a227158dc24e2a865c6aebdd673ec7f4b004","name":"troops-in-the-distrct-washingtonpost.png","type":"image/png","lastModified":1757110363906.108,"size":1103526},{"id":"9e8bfcf91b7c85ebfb059f61115c07f8b77cd956860f04933aa7d568253a4a22f0bd4d26caf3306e6068457b8ef16b3efa6b92584624ac76e3b0b2f820ad6820","href":"https://static.observableusercontent.com/files/9e8bfcf91b7c85ebfb059f61115c07f8b77cd956860f04933aa7d568253a4a22f0bd4d26caf3306e6068457b8ef16b3efa6b92584624ac76e3b0b2f820ad6820","name":"Screenshot 2025-09-05 at 3.59.41 PM.png","type":"image/png","lastModified":1757113209937.102,"size":1067712},{"id":"3206e56370e4d18a2016f4299346ea08367cdbaef4433d03b9cc41458d89efb42d56d45312d89b36693baa0b7f02bc1afd11f185d4845629aeb9e32b6333d4ca","href":"https://static.observableusercontent.com/files/3206e56370e4d18a2016f4299346ea08367cdbaef4433d03b9cc41458d89efb42d56d45312d89b36693baa0b7f02bc1afd11f185d4845629aeb9e32b6333d4ca","name":"dc_guard_locations_2025_aug-sep.csv","type":"text/csv","lastModified":1757129943526.744,"size":4554},{"id":"7eba3fbadd4d0d8dba905215b3ee3021e51df33a2f5c137ecc7fdd0b835b91c025a0b25a3c45bdde1354f8fef24ba858a4f1a9681c5a9c489562456d34a7db4b","href":"https://static.observableusercontent.com/files/7eba3fbadd4d0d8dba905215b3ee3021e51df33a2f5c137ecc7fdd0b835b91c025a0b25a3c45bdde1354f8fef24ba858a4f1a9681c5a9c489562456d34a7db4b","name":"2025-Nationals-schedule.csv","type":"text/csv","lastModified":1756513832756.623,"size":14707}] 2e:{"title":"DC Crime","cells":[{"id":0,"value":"# DC Crime","pinned":false,"hidden":false,"mode":"md"},{"id":116,"value":"https://crimecards.dc.gov/\n\n\nhttps://x.com/DCPoliceUnion/status/1957435067258577173\n\nhttps://mpdc.dc.gov/dailycrime","pinned":false,"hidden":false,"mode":"md"},{"id":1014,"value":"Is reported crime reduced because more crime is being handled by federal forces instead of MPD?","pinned":false,"hidden":false,"mode":"md"},{"id":1004,"value":"delayedReportData.filter(d=>d.date > new Date(\"2025-07-01\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":422,"value":"dateExtent ? md`### Violent crimes loaded, report dates between ${dateExtent[0]?.slice(0,10)} and ${dateExtent[1].slice(0,10)} ${dateExtent[1].slice(11,16)}` : `loading data...`","pinned":false,"hidden":false,"mode":"ojs"},{"id":435,"value":"viewof firstYear = Inputs.range([2011, 2025], {label: \"Load crimes beginning with year\", step: 1, value: 2024})","pinned":false,"hidden":false,"mode":"ojs"},{"id":186,"value":"viewof selectX = Inputs.select(plotXkeys, {label: \"Select x key\", value:\"reportDate\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":261,"value":"viewof selectFirstDayOfWeek = Inputs.select([...daysOfWeek,\"Day\",\"Month\"], {label: \"First day of week or every day or monthly\", value:daysOfWeek[new Date().getDay()]})","pinned":false,"hidden":false,"mode":"ojs"},{"id":357,"value":"viewof firstDateForPlot = Inputs.date({label: \"First date for plot\", value: new Date(\"2024-01-01\")})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1277,"value":"viewof lastDateForPlot = Inputs.date({label: \"Last date for plot\", value: new Date(Date.now())})","pinned":false,"hidden":false,"mode":"ojs"},{"id":63,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":1624,"value":"debug = ({})","pinned":true,"hidden":false,"mode":"ojs"},{"id":595,"value":"plotAllCrimes(allCrimesSelected, \"Crimes reported in DC\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":1570,"value":"viewof checkboxOffenses = Inputs.checkbox(offenses, {label: \"Select offenses\", value: offenses})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1723,"value":"viewof checkboxWards = Inputs.checkbox(d3.range(1,9), {label: \"Select wards\", value: d3.range(1,9)})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1684,"value":"html`

${viewof colorSchemeID}

${viewof reverseMapColors}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":671,"value":"viewof selectColorKey = Inputs.select([\"By offense\", \"By reporting delay days\", ...keys], {label: \"Select color grouping\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":724,"value":"// plotAllCrimes(allCrimesSelected.filter(d=>d.reportDelayEndDays <= 2), \"Crimes reported in DC up to 48 hours afterwards\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":694,"value":"// plotAllCrimes(allCrimesSelected.filter(d=>d.reportDelayEndDays > 2 && d.reportDelayEndDays < 7), \"All crimes reported in DC 48 hours to 7 days afterwards\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":703,"value":"// plotAllCrimes(allCrimesSelected.filter(d=>d.reportDelayEndDays >= 7), \"All crimes reported in DC 7 or more days afterwards\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":665,"value":"viewof rangeDelayDaysMax = Inputs.range([2, 100], {label: \"Max days delay for plot\", step: 1, value: 8})","pinned":false,"hidden":false,"mode":"ojs"},{"id":686,"value":"viewof rangeHoursToAddBeforeRounding = Inputs.range([-12, 12], {label: \"Hours to add before rounding days\", step: 1, value: 0})","pinned":true,"hidden":false,"mode":"ojs"},{"id":597,"value":"//plotAllCrimes(allCrimesLastYearSelected, \"Crime reported in DC one year ago\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":701,"value":"//plotAllCrimes(allCrimesLastYearSelected.filter(d=>d.reportDelayEndDays > 2 && d.reportDelayEndDays < 7), \"All crime reported in DC 48 hours to 7 days after the crime, one year ago\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":705,"value":"//plotAllCrimes(allCrimesLastYearSelected.filter(d=>d.reportDelayEndDays >= 7), \"All crime reported in DC 7 or more days after the crime, one year ago\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":627,"value":"plotXkeys = [\"startDate\",\"midDate\",\"endDate\",\"reportDate\"] || Object.keys(violentCrimesMapped[0])","pinned":true,"hidden":false,"mode":"ojs"},{"id":639,"value":"violentCrimesMapped.filter(d=>d.endDate !== d.reportDate)","pinned":true,"hidden":false,"mode":"ojs"},{"id":551,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":621,"value":"colorSort = ({\n \"theft/other\": 0,\n \"motor vehicle theft\": 1, \n \"theft f/auto\": 2,\n \"burglary\": 3,\n \"robbery\": 4,\n \"sex abuse\": 5,\n \"assault w/dangerous weapon\":6,\n \"homicide\": 7,\n \"arson\":8})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1616,"value":"violentOffenses = ({\n //\"theft/other\": 0,\n //\"motor vehicle theft\": 1, \n //\"theft f/auto\": 2,\n //\"burglary\": 3,\n \"robbery\": 4,\n \"sex abuse\": 5,\n \"assault w/dangerous weapon\":6,\n \"homicide\": 7,\n \"arson\":8})","pinned":true,"hidden":false,"mode":"ojs"},{"id":623,"value":"colorDomain = Object.keys(colorSort);\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":561,"value":"offenseCounts = d3.flatRollup(allCrimesMapped,v=>v.length,d=>d.OFFENSE)","pinned":true,"hidden":false,"mode":"ojs"},{"id":565,"value":"offenses = offenseCounts.map(d=>d[0])","pinned":true,"hidden":false,"mode":"ojs"},{"id":1614,"value":"offenses","pinned":true,"hidden":false,"mode":"ojs"},{"id":463,"value":"nationalsScheduleIn = FileAttachment(\"2025-Nationals-schedule.csv\").csv(d3.autoType)","pinned":true,"hidden":false,"mode":"ojs"},{"id":491,"value":"d3.extent(nationalsSchedule,d=>d.date)","pinned":true,"hidden":false,"mode":"ojs"},{"id":459,"value":"nationalsSchedule = {\n return nationalsScheduleIn.map(d=>{\n return {\n date: new Date(d.Date.split(\"(\")[0] + \", 2025\"),\n homeGame: d[\"\"] == \"\",\n ...d\n };\n });\n return nationalsScheduleIn;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1753,"value":"d3.flatGroup(violentCrimesMapped, d=>d.METHOD)","pinned":true,"hidden":false,"mode":"ojs"},{"id":296,"value":"homicideData = {\n let dateCutoff = new Date(\"2025-01-01\");\n let data = violentCrimesMapped.filter(d=>d.OFFENSE == \"homicide\" && d.startDateTime > dateCutoff);\n return data;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":420,"value":"dateExtent = d3.extent(violentCrimesMapped, d=>d.REPORT_DAT)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1592,"value":"dateExtentAll = d3.extent(allCrimesAllMonthsMapped, d=>d.REPORT_DAT)","pinned":true,"hidden":false,"mode":"ojs"},{"id":300,"value":"Plot.plot({\n width: width,\n x: {\n grid: true\n },\n y: {\n grid: true\n },\n marks: [\n Plot.auto(homicideData, {x: \"startDateTime\", y: \"DISTRICT\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":371,"value":"{\n let dateCutoff = new Date(\"2025-08-19\");\n let data = violentCrimesMapped.filter(d=>d.OFFENSE == \"robbery\" && d.startDateTime > dateCutoff);\n return data;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":5,"value":"\"https://datagate.dc.gov/search/open/crimes?daterange=1year%20to%20date&searchtype=records&details=true&limit=10&sort=date:desc\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":727,"value":"dateStringForURL(new Date())","pinned":true,"hidden":false,"mode":"ojs"},{"id":776,"value":"crimesByReportYearMonth = ({ \n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1380,"value":"function delay(ms) {\n return new Promise(resolve => setTimeout(resolve, ms));\n}\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1448,"value":"viewof buttonGetCrimes202410 = Inputs.button(\"Get 2024-10 crimes\", {reduce: ()=> {\n crimesByReportYearMonth[202410] = null;\n return getCrimesByMonth(2024, 10);\n}})\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":784,"value":"async function getAllCrimesByMonth(firstYear, firstMonth, lastYear, lastMonth) {\n console.log(\"Starting getAllCrimesByMonth\",{firstYear, firstMonth, lastYear, lastMonth});\n let retries = 2;\n while (firstYear < lastYear || firstYear == lastYear && firstMonth <= lastMonth ) {\n try {\n console.log(\"Getting month\",{lastYear, lastMonth});\n await getCrimesByMonth(lastYear, lastMonth); \n }\n catch (e) {\n console.warn(\"Error fetching \" + lastYear + \"-\" + lastMonth,e);\n if (!retries) {\n console.error(\"No more retries\");\n break; \n }\n console.log(\"Retrying in 1 second\");\n await delay(1000);\n retries --;\n continue;\n }\n retries = 2;\n lastMonth -- ;\n if (lastMonth == 0) {\n lastMonth = 12 ;\n lastYear -- ;\n }\n }\n return crimesByReportYearMonth;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1630,"value":"allCrimesByMonth[202401].results.data","pinned":true,"hidden":false,"mode":"ojs"},{"id":1670,"value":"currentYear = new Date().getFullYear()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1672,"value":"currentMonth = new Date().getMonth() + 1","pinned":true,"hidden":false,"mode":"ojs"},{"id":793,"value":"allCrimesByMonth = getAllCrimesByMonth(firstYear,1,currentYear,currentMonth)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1010,"value":"allCrimesByMonth[202509].results.data","pinned":true,"hidden":false,"mode":"ojs"},{"id":1704,"value":"keys = Object.keys(allCrimesAllMonthsMapped[0])","pinned":true,"hidden":false,"mode":"ojs"},{"id":796,"value":"allCrimesAllMonthsMapped = processCrimeData ( [].concat(...Object.values(allCrimesByMonth).map(d=>d.results.data)));\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1720,"value":"checkboxOffensesMapped = Object.fromEntries(checkboxOffenses.map(d=>[d,1]))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1574,"value":"allCrimesSelected = allCrimesAllMonthsMapped.filter(d=> checkboxOffensesMapped[d.OFFENSE] && checkboxWardsMapped[d.WARD])","pinned":true,"hidden":false,"mode":"ojs"},{"id":1725,"value":"checkboxWardsMapped = Object.fromEntries(checkboxWards.map(d=>[d,1]))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1586,"value":"allCrimesLastYearSelected = allCrimesSelected.filter(d=> new Date(d.REPORT_DAT).valueOf() <= Date.now()-365*24*60*60*1000 )","pinned":true,"hidden":false,"mode":"ojs"},{"id":821,"value":"allCrimesAllMonthsMappedWithFrequency = {\n let data = d3.sort(allCrimesAllMonthsMapped.filter(d=>d.reportDelayEndDays >= 2 && d.reportDelayEndDays <=7), d=>d.reportDateTime);\n data.forEach((d,i,a)=>{\n if (!i) {\n return;\n }\n let d2 = a[i-1];\n d.secondsSinceLastReport = (d.reportDateTime.valueOf() - d2.reportDateTime.valueOf())/1000;\n d.frequencySinceLastReport = 1/(d.secondsSinceLastReport || 1);\n if (i<2) {\n return;\n }\n let d3 = a[i-2];\n d.secondsSinceLastReport2 = (d.reportDateTime.valueOf() - d3.reportDateTime.valueOf())/1000;\n d.frequencySinceLastReport2 = 1/(d.secondsSinceLastReport2 || 1);\n });\n return data; \n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":826,"value":"Plot.plot({\n width: width,\n x: {\n grid: true\n },\n y: {\n grid: true\n },\n color: {\n legend: true\n },\n marks: [\n Plot.auto(allCrimesAllMonthsMappedWithFrequency, {x: \"reportDate\", y: \"frequencySinceLastReport2\", color: \"frequencySinceLastReport\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":798,"value":"delayedReportData = d3.sort(d3.flatRollup(allCrimesSelected, v=> ({\n all:v.length,\n delayed27: v.filter(d=>d.reportDelayEndDays >= 2 && d.reportDelayEndDays <=7).length,\n}), d=>d.reportDate), d=>-d[1].delayed27).map(d=>({date:d[0],...d[1], fraction: d[1].delayed27/d[1].all}))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1001,"value":"delayedReportData.filter(d=>d.date > new Date(\"2025-07-01\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":808,"value":"Plot.plot({\n width: width,\n x: {\n grid: true\n },\n y: {\n grid: true\n },\n color: {\n legend: true\n },\n marks: [\n Plot.auto(delayedReportData, {x: \"date\", y: \"delayed27\", color: \"fraction\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":779,"value":"function getCrimesByMonthKey(year,month,type=\"all\") {\n if (type == \"all\") {\n return year*100 + month;\n }\n return type + (year*100 + month);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":729,"value":"async function getCrimesByMonth(year, month, type = \"all\", limit=10000) {\n let k = getCrimesByMonthKey(year, month, type);\n if (crimesByReportYearMonth[k]) {\n return crimesByReportYearMonth[k]; \n }\n let date1s = \"\" + month + \"-01-\" + year;\n let nextMonth = month + 1;\n let nextYear = year;\n if (nextMonth > 12) {\n nextYear++;\n nextMonth -= 12;\n }\n let date2s = \"\" + nextMonth + \"-01-\" + nextYear;\n\n let url;\n if (type == \"violent\") {\n let urlViolent = `https://datagate.dc.gov/search/open/crimes/violent?daterange=${date1s},${date2s}&searchtype=records&details=true&limit=${limit}&sort=date:desc`;\n url = urlViolent;\n }\n else {\n url = `https://datagate.dc.gov/search/open/crimes?daterange=${date1s},${date2s}&searchtype=records&details=true&limit=${limit}&sort=date:desc`;\n }\n console.log(\"Fetching\",url);\n url = getProxyURL(url, 0, 1);\n\n let json = await d3.json(url);\n crimesByReportYearMonth[k] = json ; \n return crimesByReportYearMonth[k];\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1339,"value":"crimesByReportYearMonth[202509]","pinned":true,"hidden":false,"mode":"ojs"},{"id":1336,"value":"d3.extent(crimesByReportYearMonth[202509].results.data, d=>d.REPORT_DAT)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1215,"value":"viewof buttonGetCrimes202509 = Inputs.button(\"Get 2025-09 crimes\", {reduce: ()=> {\n crimesByReportYearMonth[202509] = null;\n return getCrimesByMonth(2025, 9);\n}})\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1322,"value":"viewof buttonGetCrimes202508 = Inputs.button(\"Get 2025-08 crimes\", {reduce: ()=> {\n crimesByReportYearMonth[202508] = null;\n return getCrimesByMonth(2025, 8);\n}})\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1317,"value":"crimesByReportYearMonth[202509]","pinned":true,"hidden":false,"mode":"ojs"},{"id":1320,"value":"crimesByReportYearMonth[202508]","pinned":true,"hidden":false,"mode":"ojs"},{"id":1212,"value":"crimesHistory202509 = (await getCrimesByMonthHistory(2025, 9)).results.map(d=>d.text && JSON.parse(d.text))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1267,"value":"crimesHistory202508 = (await getCrimesByMonthHistory(2025, 8)).results.map(d=>d.text && JSON.parse(d.text))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1251,"value":"d3.rollup(recentHistoryComparison.onlyLeft, v=>v.length, d=>d.REPORT_DAT.slice(0,10))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1331,"value":"d3.rollup(recentHistoryComparison.onlyRight, v=>v.length, d=>d.REPORT_DAT.slice(0,10))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1261,"value":"d3.extent(recentHistoryComparison.onlyLeft, d=>d.REPORT_DAT)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1257,"value":"d3.rollup(recentHistoryComparison.right, v=>v.length, d=>d.REPORT_DAT.slice(0,10))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1263,"value":"d3.extent(recentHistoryComparison.right, d=>d.REPORT_DAT)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1232,"value":"recentHistoryComparison = compareCrimes(crimesHistory202509[0].results.data, crimesHistory202509[1].results.data )","pinned":true,"hidden":false,"mode":"ojs"},{"id":1270,"value":"recentHistoryComparison202508 = compareCrimes(crimesHistory202508[0].results.data, crimesHistory202508[1].results.data )","pinned":true,"hidden":false,"mode":"ojs"},{"id":1245,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":1230,"value":"function compareCrimes(a,b) {\n let id = d=>d.CCN\n let o = Object.fromEntries(a.map(d=>[id(d), d]));\n let p = Object.fromEntries(b.map(d=>[id(d), d]));\n let onlyLeft = [];\n let onlyRight = [];\n let diffs = [];\n a.forEach(d=> {\n let r = p[id(d)] ;\n if (!r) {\n onlyLeft.push(d);\n }\n else {\n let comparison = compareObjects(d,r, {_id:1, _cursor:1});\n if (comparison.changes) {\n diffs.push(comparison);\n }\n }\n });\n b.forEach(d=> {\n if (!o[id(d)]) {\n onlyRight.push(d);\n }\n });\n return {\n left: a,\n right: b,\n onlyLeft,\n onlyRight,\n diffs,\n };\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1209,"value":"async function getCrimesByMonthHistory(year, month, type = \"all\", limit=10000) {\n let date1s = \"\" + month + \"-01-\" + year;\n let nextMonth = month + 1;\n let nextYear = year;\n if (nextMonth > 12) {\n nextYear++;\n nextMonth -= 12;\n }\n let date2s = \"\" + nextMonth + \"-01-\" + nextYear;\n\n let url;\n if (type == \"violent\") {\n let urlViolent = `https://datagate.dc.gov/search/open/crimes/violent?daterange=${date1s},${date2s}&searchtype=records&details=true&limit=${limit}&sort=date:desc`;\n url = urlViolent;\n }\n else {\n url = `https://datagate.dc.gov/search/open/crimes?daterange=${date1s},${date2s}&searchtype=records&details=true&limit=${limit}&sort=date:desc`;\n }\n console.log(\"Getting history for URL\",url);\n return getURLhistory(url);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":7,"value":"function getCrimes(date1=new Date(\"1-01-2024\"),date2=new Date(), type=\"violent\", limit=10000) {\n let date1s = dateStringForURL(date1);\n let date2s = dateStringForURL(date2);\n\n if (type == \"violent\") {\n let urlViolent = `https://datagate.dc.gov/search/open/crimes/violent?daterange=${date1s},${date2s}&searchtype=records&details=true&limit=${limit}&sort=date:desc`;\n return d3.json(urlViolent); \n }\n let urlAll = `https://datagate.dc.gov/search/open/crimes?daterange=${date1s},${date2s}&searchtype=records&details=true&limit=${limit}&sort=date:desc`;\n return d3.json(urlAll); \n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":383,"value":"function getStolenAutos(date1=new Date(\"01-01-2025\"), date2=new Date(), limit=10000) {\n let date1s = dateStringForURL(date1);\n let date2s = dateStringForURL(date2);\n let url = `https://datagate.dc.gov/search/open/crimes/stolen-autos?daterange=${date1s},${date2s}&searchtype=records&geo=true&details=true&limit=10000&sort=date:desc`;\n return d3.json(url);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":441,"value":"{\n let url = `https://datagate.dc.gov/search/open/crimes?daterange=1year%20to%20date&details=true&format=csv`\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":389,"value":"dataAutosResponse = getStolenAutos()","pinned":true,"hidden":false,"mode":"ojs"},{"id":446,"value":"dataAutos = dataAutosResponse.results.data.features.map(d=>d.properties)","pinned":true,"hidden":false,"mode":"ojs"},{"id":393,"value":"autoMethods = d3.rollup(dataAutos, v=>v.length, d=>d.METHOD)","pinned":true,"hidden":false,"mode":"ojs"},{"id":377,"value":"d3.flatGroup(violentCrimesMapped.filter(d=> d.CCN > \"2512\"),d=>d.CCN).filter(d=>d[1].length>1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":328,"value":"crimesByReportYear = ({ \n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1443,"value":"response = fetch(\"https://cors1.lvab.workers.dev/?t=1&u=https%3A%2F%2Fdatagate.dc.gov%2Fsearch%2Fopen%2Fcrimes%3Fdaterange%3D10-01-2024%2C11-01-2024%26searchtype%3Drecords%26details%3Dtrue%26limit%3D10000%26sort%3Ddate%3Adesc\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":1446,"value":"response.text()","pinned":true,"hidden":false,"mode":"ojs"},{"id":330,"value":"async function getYearCrimes(year) {\n crimesByReportYear[year] = await getCrimes(new Date(\"1-01-\"+year),new Date(\"1-01-\"+(year+1))); \n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":333,"value":"crimesByReportYearFetched = {\n for (let year= 2026 ; year >= firstYear; year--) {\n if (!crimesByReportYear[year]) {\n yield crimesByReportYear;\n await getYearCrimes(year);\n }\n }\n yield crimesByReportYear;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":318,"value":"//getCrimes(new Date(\"1-01-2020\"), new Date(\"1-01-2021\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":250,"value":"function dateStringForURL(date) {\n let y = date.getFullYear();\n let m = date.getMonth() + 1;\n let d = date.getDate();\n return \"\" + m + \"-\" + String(d).padStart(2,0) + \"-\" + y;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":10,"value":"allCrimes = \n getCrimes(new Date(Date.now() - 17* 7*24*60*60*1000), new Date(), \"all\");\n //getCrimes(new Date(\"11-01-2019\"), new Date(\"1-01-2022\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":587,"value":"allCrimesLastYear = \n getCrimes(new Date(\"2024-01-01\"), new Date(Date.now() - (364)*24*60*60*1000), \"all\");\n //getCrimes(new Date(\"11-01-2019\"), new Date(\"1-01-2022\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1594,"value":"d3.extent(allCrimesLastYear.results.data, d=>d.REPORT_DAT)","pinned":true,"hidden":false,"mode":"ojs"},{"id":134,"value":"allCrimes.results.data","pinned":true,"hidden":false,"mode":"ojs"},{"id":36,"value":"violentCrimesMapped.filter(d=>!d.START_DATE)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1626,"value":"allCrimesAllMonthsMapped.filter(d=>!d.START_DATE)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1628,"value":"allCrimesAllMonthsMapped.filter(d=>d.CCN == \"24021001\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":172,"value":"d3.extent(violentCrimesMapped, d=>d.REPORT_DAT)","pinned":true,"hidden":false,"mode":"ojs"},{"id":17,"value":"violentCrimesMapped = processCrimeData ( [].concat(...Object.values(crimesByReportYearFetched).map(d=>d.results.data)));\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":557,"value":"allCrimesMapped = processCrimeData (allCrimes.results.data);\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":592,"value":"allCrimesLastYearMapped = processCrimeData (allCrimesLastYear.results.data);\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":553,"value":"$33","pinned":true,"hidden":false,"mode":"ojs"},{"id":90,"value":"jan1 = new Date(\"2025-01-01T00:00:00.000Z\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":87,"value":"violentCrimesMappedFiltered = violentCrimesMapped.filter(d=>d.startDateTime > jan1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":26,"value":"Plot.plot({\n title: \"Title\",\n subtitle: \"Subtitle\",\n caption: \"Caption\",\n width: width,\n x: {\n grid: true\n },\n y: {\n grid: true\n },\n marks: [\n Plot.auto(violentCrimesMappedFiltered, {x: \"reportDelayStartDays\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":78,"value":"d3.rollup(violentCrimesMappedFiltered, v=>({reportDelayStart: d3.mean(v, d=>d.reportDelayStartDays), reportDelayEnd: d3.mean(v, d=>d.reportDelayEndDays)}), d=>d.offensegroup)","pinned":true,"hidden":false,"mode":"ojs"},{"id":82,"value":"d3.rollup(violentCrimesMappedFiltered, v=>d3.mean(v, d=>d.reportDelayStartDays), d=>d.offensekey)","pinned":true,"hidden":false,"mode":"ojs"},{"id":84,"value":"d3.rollup(violentCrimesMappedFiltered, v=>d3.mean(v, d=>d.reportDelayStartDays), d=>d.offensekey)","pinned":true,"hidden":false,"mode":"ojs"},{"id":160,"value":"d3.rollup(violentCrimesMapped, v=>v.length, d=>d.offensekey, d=>d.reportDate)","pinned":true,"hidden":false,"mode":"ojs"},{"id":178,"value":"function getDateInTimezoneExact(date, timeZone = \"America/New_York\") {\n // This is slow. If using repeatedly on same times, memoize results\n // This is tricky to get right. sv is sweden which uses ISO format\n if (!date) {\n date = new Date();\n }\n let dateString = date.toLocaleString(\"sv\",{timeZoneName: 'longOffset', timeZone});\n let dateO = new Date(dateString.slice(0,10));\n return dateO;\n return Number(dateString.slice(0,4) + dateString.slice(5,7) + dateString.slice(8,10));\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":193,"value":"getDateInTimezoneExact(new Date(Date.now()-2*60*60*1000))","pinned":true,"hidden":false,"mode":"ojs"},{"id":290,"value":"daysOfWeek = [\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\"]","pinned":true,"hidden":false,"mode":"ojs"},{"id":871,"value":"ol = {\n const ol = await require(\"ol@7.1.0/dist/ol.js\").catch(() => window.ol);\n if (!ol._style) ol._style = document.head.appendChild(html``);\n return ol;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":741,"value":"dataToPlot1 = allCrimesAllMonthsMappedWithFrequency.filter(d=>d.reportDelayEndDays > 2 && d.reportDelayEndDays < 7 && d.reportDateTime >= dateToCheck2023 && d.reportDateTime <= new Date(dateToCheck2023.valueOf() + 24*60*60*1000))","pinned":true,"hidden":false,"mode":"ojs"},{"id":935,"value":"dataToPlot2 = allCrimesAllMonthsMappedWithFrequency.filter(d=>d.reportDelayEndDays > 2 && d.reportDelayEndDays < 7 && d.reportDateTime >= dateToCheck2025 && d.reportDateTime <= new Date(dateToCheck2025.valueOf() + 24*60*60*1000))","pinned":true,"hidden":false,"mode":"ojs"},{"id":844,"value":"dataToPlot1","pinned":true,"hidden":false,"mode":"ojs"},{"id":749,"value":"dateToCheck2023 = getDateInTimezoneExact(new Date(\"2025/07/31\") || new Date(\"2023/11/30\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":929,"value":"dateToCheck2025 = getDateInTimezoneExact(new Date(\"2025/08/08\") || new Date(\"2025/08/13\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":905,"value":"viewof button = Inputs.button(\"Add circles\", {reduce: ()=>{\n addCircles(dataToPlot1, \"green\");\n addCircles(dataToPlot2,\"orange\");\n}})","pinned":true,"hidden":false,"mode":"ojs"},{"id":950,"value":"recentCrimes = allCrimesAllMonthsMapped.filter(d=> d.reportDateTime >= getDateInTimezoneExact(new Date(\"2024/06/01\")))","pinned":true,"hidden":false,"mode":"ojs"},{"id":955,"value":"recentCrimes.filter(d=>d.reportDelayEndDays <= 2)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1041,"value":"map.getAllLayers()[2].setOpacity(rangeOverlayOpacity)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1163,"value":"map.getAllLayers()[1].setOpacity(rangeImageOpacity)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1567,"value":"map.getAllLayers()[1].setZIndex(400)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1071,"value":"viewof button2 = Inputs.button(\"Fit image overlay\", {reduce: ()=>{\n map.getView().fit(imageExtent, { padding: [1, 1, 1, 1], duration: 500 });\n}})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1186,"value":"troopLocations = FileAttachment(\"dc_guard_locations_2025_aug-sep.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1185,"value":"dc_guard_locations_2025_augSep = await FileAttachment(\"dc_guard_locations_2025_aug-sep.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1189,"value":"viewof buttonTroopLocations = Inputs.button(\"Add troop locations\", {reduce: ()=>{\n let data = troopLocations.filter(d=>d.name == \"Smithsonian Metro Station\");\n addCircles(data,[255,128,0,0.9], 300);\n}})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1056,"value":"imageExtentLatLong = [\n -77.076, 38.9670,\n -76.93, 38.83,\n]; \n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1492,"value":"d3.flatRollup(recentCrimes, v=>v.length, d=>d.OFFENSE)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1346,"value":"$34","pinned":true,"hidden":false,"mode":"ojs"},{"id":1405,"value":"{\n let context = (viewof map).getElementsByTagName(\"canvas\")[0]?.getContext(\"2d\");\n return context?.globalCompositeOperation ;\n //context.globalCompositeOperation = \"source-over\";\n context.globalCompositeOperation = \"lighten\";\n // normal | multiply | screen | overlay | darken |\n//lighten | color-dodge | color-burn | hard-light | soft-light | difference | exclusion | \n//hue | saturation | color | luminosity\n\n}\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1526,"value":"function toggleCrimes() {\n globals.crimesToggle = (Date.now() / 20 % 1) >= 0.5 ;\n if (globals.crimesToggle) {\n globals.layerGreen.setZIndex(100);\n globals.layerBlue.setZIndex(200);\n } else {\n globals.layerGreen.setZIndex(200);\n globals.layerBlue.setZIndex(100);\n }\n return globals.crimesToggle;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1521,"value":"{\n while (cycleCrimes) {\n toggleCrimes();\n yield \"toggling\";\n }\n yield \"not toggling\";\n \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1046,"value":"viewof rangeImageOpacity = Inputs.range([0, 1], {label: \"Image opacity\", step: 0.1, value:0})","pinned":false,"hidden":false,"mode":"ojs"},{"id":946,"value":"viewof button1 = Inputs.button(\"Add prior crimes to map, in green\", {reduce: d=>addCrimesToMap(true)})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1366,"value":"viewof button3 = Inputs.button(\"Add recent crimes to map, in blue\", {reduce: ()=>addCrimesToMap(false)})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1505,"value":"viewof addCrimesToggle = Inputs.button(\"Toggle\", {reduce: toggleCrimes})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1503,"value":"viewof cycleCrimes = Inputs.toggle({label: \"Cycle crimes\", value: false})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1370,"value":"viewof redrawMap = Inputs.button(\"Reset map\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":1157,"value":"viewof rangeOverlayOpacity = Inputs.range([0, 1], {label: \"Crime dots opacity\", step: 0.1, value:0.9})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1662,"value":"viewof checkboxOffensesMap = Inputs.checkbox(offenses, {label: \"Select offenses\", value: offenses})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1657,"value":"* Green: before National Guard\n* Blue: after National Guard","pinned":false,"hidden":false,"mode":"md"},{"id":873,"value":"viewof map = {\n redrawMap;\n const target = html`

`;\n yield target; // Give the container dimensions.\n const map = target.value = new ol.Map({\n layers: [\n new ol.layer.Tile({\n source: new ol.source.OSM()\n }),\n imageLayer\n ],\n target,\n view: new ol.View({\n //center: ol.extent.getCenter(imageExtent),\n center: ol.proj.fromLonLat([-77.009056, 38.902]),\n zoom: 11.7\n })\n });\n invalidation.then(() => map.dispose());\n yield target;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1064,"value":"imageExtent = ol.proj.transformExtent(\n imageExtentLatLong,\n 'EPSG:4326',\n 'EPSG:3857'\n );\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1050,"value":"imageLayer = new ol.layer.Image({\n source: new ol.source.ImageStatic({\n url: await FileAttachment(\"Screenshot 2025-09-05 at 3.59.41 PM.png\").url(), // replace with your image\n //url: `blob:https://andy-bloch.static.observableusercontent.com/86efbb9a-0189-4d80-9c6a-4baad553c047`,\n imageExtent: imageExtent,\n projection: 'EPSG:3857', // same projection as the map\n crossOrigin: 'anonymous', // helpful if you later export the map canvas\n }),\n opacity: 0.95, // tweak as you like\n zIndex: 10\n });","pinned":true,"hidden":false,"mode":"ojs"},{"id":1076,"value":"https://www.washingtonpost.com/dc-md-va/2025/08/15/dc-police-national-guard-map-trump/","pinned":false,"hidden":false,"mode":"md"},{"id":1054,"value":"troopsInTheDistrctWashingtonpost = FileAttachment(\"Screenshot 2025-09-05 at 3.59.41 PM.png\").image()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1151,"value":" FileAttachment(\"Screenshot 2025-09-05 at 3.59.41 PM.png\").url()","pinned":true,"hidden":false,"mode":"ojs"},{"id":1030,"value":"map","pinned":true,"hidden":false,"mode":"ojs"},{"id":1507,"value":"circleLayers = {\n redrawMap;\n removeLayers();\n return [];\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1514,"value":"globals =({})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1516,"value":"globals.circleLayers = circleLayers;","pinned":true,"hidden":false,"mode":"ojs"},{"id":1511,"value":"function removeLayers(){\n if (globals.circleLayers) {\n globals.circleLayers.forEach(layer=>map.removeLayer(layer));\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":887,"value":"$35","pinned":true,"hidden":false,"mode":"ojs"},{"id":1203,"value":"import {getProxyURL, getURLhistory} from \"@labvegas/cors\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1686,"value":"viewof reverseMapColors = Inputs.toggle({label: \"Reverse Colors\", value: false})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1688,"value":"viewof colorSchemeID = Inputs.select([\"schemeCustom\",...Object.keys(d3).filter(k => k.startsWith(\"scheme\") && (d3[k][10] || d3[k][9]) && !d3[k][0])], {label: \"Color scheme\", value: \"schemeSpectral\", format: k => k.slice(6), width: 90})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1692,"value":"colorScheme = {\n let colorScheme;\n if (colorSchemeID === \"schemeCustom\") {\n //colorScheme = [...myScheme];\n }\n else {\n colorScheme = [...(d3[colorSchemeID][10] || d3[colorSchemeID][9] || d3[colorSchemeID][0])] ; \n }\n if (!reverseMapColors) {\n colorScheme.reverse();\n }\n return colorScheme;\n}\n","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W36","stdlib":"1","titling":"auto"}