25:["$","title",null,{"children":"Richmond shootings | Andrew Witherspoon | Observable"}] 49:[{"id":"5457cbf64944debce90f3f621a1cf8bd4feb0953e25b6b4c223c7f687f3e7b2724e1d528bb04525304186933d5afaa9f2a0338539948a087c1c294a7471b2d06","href":"https://static.observableusercontent.com/files/5457cbf64944debce90f3f621a1cf8bd4feb0953e25b6b4c223c7f687f3e7b2724e1d528bb04525304186933d5afaa9f2a0338539948a087c1c294a7471b2d06","name":"el_cerrito.json","type":"application/json","lastModified":1684956579729.121,"size":22881},{"id":"59f1851b380678623d1f7bbf4ad3d9f027f86f6cb55b756f458e8b3b7c80e40f8b6d3012b10d28e43dd25f987eabf30e332d02241a45ff3c9693ba640aadf696","href":"https://static.observableusercontent.com/files/59f1851b380678623d1f7bbf4ad3d9f027f86f6cb55b756f458e8b3b7c80e40f8b6d3012b10d28e43dd25f987eabf30e332d02241a45ff3c9693ba640aadf696","name":"CrimeData.csv","type":"text/csv","lastModified":1680891904380.548,"size":460254},{"id":"99277761e2ef94f40e15891f155855f4b773918693a4c51c6d05a0388265d2ebf87739ef4467c069bdccf8b8b34e14b0bfaf305b3b31db54aaa57c1a6dda2314","href":"https://static.observableusercontent.com/files/99277761e2ef94f40e15891f155855f4b773918693a4c51c6d05a0388265d2ebf87739ef4467c069bdccf8b8b34e14b0bfaf305b3b31db54aaa57c1a6dda2314","name":"contaCostra-bg.json","type":"application/json","lastModified":1681834979368.974,"size":4554576},{"id":"8ef7d80b8d5872f1257adf9e6fac78e95c628a6c953616a4e4e2e1621b5547d4a52532706642dd87da91f3088271af54758c50f195ef730d5d8bb09206a7ea0f","href":"https://static.observableusercontent.com/files/8ef7d80b8d5872f1257adf9e6fac78e95c628a6c953616a4e4e2e1621b5547d4a52532706642dd87da91f3088271af54758c50f195ef730d5d8bb09206a7ea0f","name":"ACSDT5Y2021.B19013-Data.csv","type":"text/csv","lastModified":1681835096409.621,"size":89082},{"id":"062087bffbe5e7578aae6c9b5dbafd85985880e752b3773b949303308fc869294ec3fdfeb40ddc2d7bed014a7efefae95db46ed7b296091287e5a7dd51c97068","href":"https://static.observableusercontent.com/files/062087bffbe5e7578aae6c9b5dbafd85985880e752b3773b949303308fc869294ec3fdfeb40ddc2d7bed014a7efefae95db46ed7b296091287e5a7dd51c97068","name":"block-group-census-data - Sheet1.csv","type":"text/csv","lastModified":1681849760468.478,"size":7723},{"id":"f701edd38836e5799c36b7c70b065943cdf1fa18769ca2d0211e1257c579d4cd3f1159ffaf03daef9409f4a1ee198ae4d0bb3f753425a842aebcf5c8586dfff1","href":"https://static.observableusercontent.com/files/f701edd38836e5799c36b7c70b065943cdf1fa18769ca2d0211e1257c579d4cd3f1159ffaf03daef9409f4a1ee198ae4d0bb3f753425a842aebcf5c8586dfff1","name":"SchoolAddress - SchoolAddress@1.csv","type":"text/csv","lastModified":1685985952622.826,"size":3619},{"id":"2f1c351e256a53153fc35a783dc78f370bf5f7b61354d94d194c97b34de95bb27463aa3eb862b879c9e221354936e6b217996e6a9b840aae632bf7a76c5a9d84","href":"https://static.observableusercontent.com/files/2f1c351e256a53153fc35a783dc78f370bf5f7b61354d94d194c97b34de95bb27463aa3eb862b879c9e221354936e6b217996e6a9b840aae632bf7a76c5a9d84","name":"SchoolAddress.csv","type":"text/csv","lastModified":1680804726277.608,"size":3875},{"id":"aef526b8d1d116f33bcced40e04ecb3670c2d0db2c80c951990a9b3f3afea5eb72d2c4241bb0b4eda5f35029d890f517ac7ad4d8a987ca721a07aed5663ef9d6","href":"https://static.observableusercontent.com/files/aef526b8d1d116f33bcced40e04ecb3670c2d0db2c80c951990a9b3f3afea5eb72d2c4241bb0b4eda5f35029d890f517ac7ad4d8a987ca721a07aed5663ef9d6","name":"CrimeData@1.csv","type":"text/csv","lastModified":1680805196680.31,"size":462798},{"id":"445270541e981e44b5fa8852f781e5a248efd75b89e2789f18005501f105baee8bac45639f0b0e6b1a8bc77dc5fb004eb28015381720560e1003fee0bbb0195e","href":"https://static.observableusercontent.com/files/445270541e981e44b5fa8852f781e5a248efd75b89e2789f18005501f105baee8bac45639f0b0e6b1a8bc77dc5fb004eb28015381720560e1003fee0bbb0195e","name":"SchoolAddress@1.csv","type":"text/csv","lastModified":1680890229112.767,"size":3849},{"id":"b390d8cd24f86d5e7d255b5520f707711a79fea9cbb714e12a89c8b2b16e207cb19f572b868d8a767187ccf3884474a29b922fcd3f953db822961c609e4bf0a7","href":"https://static.observableusercontent.com/files/b390d8cd24f86d5e7d255b5520f707711a79fea9cbb714e12a89c8b2b16e207cb19f572b868d8a767187ccf3884474a29b922fcd3f953db822961c609e4bf0a7","name":"SchoolAddress - SchoolAddress.csv","type":"text/csv","lastModified":1681572396001.627,"size":3843}] 29:{"id":"1316d262b5490da7","slug":null,"title":"Richmond shootings","thumbnail":"371b85c43c0b6140696cda588f696ea4dff27074273574e3ebbb92315a017bcd","access_level":"public","create_time":"$D2023-04-06T18:09:54.898Z","update_time":"$D2023-06-05T17:35:43.345Z","view_time":null,"first_public_time":"$D2023-04-06T18:09:54.898Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"e9d0700f86f0bd9d","login":"andrewwitherspoon","name":"Andrew Witherspoon","avatar_url":"https://avatars-next.observableusercontent.com/8f490800810ce3ba1c52e327affe1547bdbad849dc781226bd105e2555362cd2","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":807,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"60290e9aa8cc207b","login":"andrewwitherspoon","name":"Andrew Witherspoon","avatar_url":"https://avatars-next.observableusercontent.com/8f490800810ce3ba1c52e327affe1547bdbad849dc781226bd105e2555362cd2","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"60290e9aa8cc207b","login":"andrewwitherspoon","name":"Andrew Witherspoon","avatar_url":"https://avatars-next.observableusercontent.com/8f490800810ce3ba1c52e327affe1547bdbad849dc781226bd105e2555362cd2","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Richmond shootings","cells":[{"id":0,"value":"# Richmond shootings\nGeospatial analysis of shooting data from the [Richmond Police Department](https://www.transparentrichmond.org/stories/s/Police-Department/i34v-j9ft)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":37,"value":"---\n## Analysis","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":259,"value":"There were ${formatNumber(crimeData.length)} shootings in Richmond from 2013 to the end of 2022. ${shootingNearSchoolsGeo.features.length} occured within 1/2 mile of the ${schoolData.length} schools analyzed. That's ${Math.round((shootingNearSchoolsGeo.features.length/crimeData.length)*100)}% of all shootings. ${Math.round((elemGeo.features.length/shootingNearSchoolsGeo.features.length)*100)}% of those shootings (${elemGeo.features.length}) where near elementary schools.\n\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":131,"value":"function compareGeos(arr1, arr2) {\n \n let newArr = [];\n \n arr1.forEach(a => {\n let obj = a.properties;\n obj.matches = []\n arr2.forEach(b=> {\n if (turfPointInPolygon.default(b, a)) {\n obj.matches.push(b)\n }\n })\n newArr.push(obj)\n })\n\n newArr.sort((a,b) => b.matches.length - a.matches.length)\n return newArr\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":314,"value":"function makeFlatGeo(arr) {\n let idArr = [];\n let finalArr = []\n \n arr.forEach(d=> {\n d.matches.forEach(m=> {\n idArr.push(m.properties.reportNumber)\n })\n })\n \n let ids = [...new Set(idArr.map(m=>m))];\n ids.forEach(d=> {\n let matching = crimeData.find(f=> f.reportNumber == d)\n finalArr.push(turf.point([parseFloat(matching.Longitude), parseFloat(matching.Latitude)], matching))\n })\n return turf.featureCollection(finalArr)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"shootingsNearSchools = compareGeos(schoolBuffer.features, crimeGeoData.features)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"shootingNearSchoolsGeo = makeFlatGeo(shootingsNearSchools)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"shootingsNearTop15Schools = compareGeos(top15Buffer.features, crimeGeoData.features)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"top15Geo = makeFlatGeo(shootingsNearTop15Schools)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":336,"value":"shootingsNearTop15Elems = compareGeos(topElemBuffer.features, crimeGeoData.features)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"topElemGeo = makeFlatGeo(shootingsNearTop15Elems)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":366,"value":"shootingsNearElems = compareGeos(elemBuffer.features, crimeGeoData.features)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":373,"value":"elemGeo = makeFlatGeo(shootingsNearElems)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"// flatSchoolData = shootingsNearSchools.map(d=> {\n// d.shootings = d.matches.length\n// delete d.matches\n// return d\n// }).flat()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"---\n## Demographic data\n- [2020 Census P2 race](https://data.census.gov/table?q=non-hispanic+white&t=White&g=050XX00US06013$1500000)\n- [2021 5-year ACS Median household income](https://data.census.gov/table?q=income&g=050XX00US06013$1500000&tid=ACSDT5Y2021.B19013)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":418,"value":"addIncomeToGeo = function (geoArr, dataArr) {\n \n geoArr.forEach(feature=> {\n \n dataArr.forEach(d=> {\n let income = dataArr.find(f=> feature.properties.GEOID20 == f.GEO_ID.split(\"1500000US\")[1]).B19013_001E\n if (income == \"250,000+\") {\n income = 250000\n } else if (income.length > 1) {\n income = parseInt(income)\n } else {\n income\n }\n feature.properties.income = income\n })\n \n feature.properties = {\n geoid: feature.properties.GEOID20,\n income: feature.properties.income\n }\n })\n return turf.featureCollection(geoArr)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":425,"value":"addIncomeToGeo(contraBG.features, contraIncome)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":463,"value":"formattedIncomeData = blockGroupsDemoData.map(d=> {\n return {\n ...d,\n population: parseInt(d.population),\n shootings: parseInt(d.shootings),\n shootingsPer10k: parseFloat(d.shootingsPer100k),\n income: parseInt(d.income),\n poc_share: parseFloat(d.poc_share)\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":483,"value":"incomeScale = d3.scaleQuantile()\n .domain(formattedIncomeData.map(d=> d.income))\n .range([1,2,3,4])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":485,"value":"quantiles = incomeScale.quantiles()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":557,"value":"incomeDomain = incomeScale.domain()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":563,"value":"incomeBrackets = [d3.min(incomeDomain, d=> d),quantiles[0], quantiles[1], quantiles[2], d3.max(incomeDomain, d=> d)]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":525,"value":"incomeQuantiles = function (arr, quantiles) {\n let finalData = [{}, {}, {}, {}];\n arr.forEach((d, i) => {\n if (i < arr.length - 1) {\n let range;\n if (i < 3) {\n range = formattedIncomeData\n .filter((f) => f.income >= d && f.income < arr[i + 1])\n .sort((a, b) => b.income - a.income);\n } else {\n range = formattedIncomeData\n .filter((f) => f.income >= d && f.income <= arr[i + 1])\n .sort((a, b) => b.income - a.income);\n }\n finalData[i].quartile = quantiles[i];\n finalData[i].averageShootingsPer1k =\n (d3.sum(range, (m) => m.shootings) /\n d3.sum(range, (m) => m.population)) *\n 1000;\n finalData[i].medianIncome = d3.median(range, (m) => m.income);\n finalData[i].data = range;\n }\n });\n return finalData;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"incomeBracketsData = incomeQuantiles(incomeBrackets, [\"1st\",\"2nd\",\"3rd\",\"4th\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":658,"value":"incomeBracketsData","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":654,"value":"Plot.plot({\n marks: [\n Plot.barY(incomeBracketsData, {x: \"quartile\", y: \"averageShootingsPer1k\", sort: {x: \"y\", reverse: true}}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":686,"value":"---\n## Shootings from 2018-2022","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":690,"value":"function getRecentShootings(arr) {\n let final = [];\n arr.forEach((d) => {\n let year = d[\"offenseDateUtc\"].split(\" \")[0].split(\"/\")[2];\n if (year >= 18 && year <= 22) {\n final.push(d);\n }\n });\n return final;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":718,"value":"function addYears(arr) {\n let final = [];\n arr.forEach((d) => {\n let year = d[\"offenseDateUtc\"].split(\" \")[0].split(\"/\")[2];\n d.year = parseInt(`20${year}`);\n final.push(d);\n });\n return final;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":721,"value":"richmondYears = addYears(\n crimeData.filter(\n (d) =>\n d[\"offenseCode\"] !=\n \"DISCHARGE BB DEVICE IN GROSSLY NEGLIGENT MANNER | 246.3 (B)\"\n )\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":753,"value":"crimeHistogram = {\n let final = [];\n let years = [2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022];\n\n years.forEach((y) => {\n let obj = {\n year: y,\n count: richmondYears.filter((f) => f.year == y).length\n };\n final.push(obj);\n });\n\n return final;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":764,"value":"Plot.plot({\n y: { domain: [0, 300], ticks: [0, 100, 200, 300] },\n marks: [\n Plot.barY(crimeHistogram, {\n x: \"year\",\n y: \"count\"\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":698,"value":"recentRichmond = getRecentShootings(\n crimeData.filter(\n (d) =>\n d[\"offenseCode\"] !=\n \"DISCHARGE BB DEVICE IN GROSSLY NEGLIGENT MANNER | 246.3 (B)\"\n )\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":704,"value":"recentRichmond","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":770,"value":"crimeData","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":772,"value":"crimeData.filter(\n (d) =>\n d[\"offenseCode\"] ==\n \"DISCHARGE BB DEVICE IN GROSSLY NEGLIGENT MANNER | 246.3 (B)\"\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"---\n## Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":461,"value":"blockGroupsDemoData = FileAttachment(\"block-group-census-data - Sheet1.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":408,"value":"contraBG = FileAttachment(\"contaCostra-bg.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":416,"value":"contraIncome = FileAttachment(\"ACSDT5Y2021.B19013-Data.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"crimeGeoData = turf.featureCollection(crimeData.map(d=> {\n return turf.point([parseFloat(d.Longitude), parseFloat(d.Latitude)], d)\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"schoolGeoData = turf.featureCollection(schoolData.map(d=> {\n return turf.point([parseFloat(d.Longitude), parseFloat(d.Latitude)], d)\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"schoolBuffer = turfBuffer.default(schoolGeoData, 0.25, {units: \"miles\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":302,"value":"top15GeoData = turf.featureCollection(shootingsNearSchools.slice(0,15).map(d=> {\n return turf.point([parseFloat(d.Longitude), parseFloat(d.Latitude)], d)\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":298,"value":"top15Buffer = turfBuffer.default(top15GeoData, 0.25, {units: \"miles\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":324,"value":"topElemGeoData = turf.featureCollection(shootingsNearSchools.slice(0,15).filter(f=>f[\"Grades Served\"].includes(\"K\")).map(d=> {\n return turf.point([parseFloat(d.Longitude), parseFloat(d.Latitude)], d)\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"topElemBuffer = turfBuffer.default(topElemGeoData, 0.25, {units: \"miles\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":358,"value":"elemGeoData = turf.featureCollection(shootingsNearSchools.filter(f=>f[\"Grades Served\"].includes(\"K\")).map(d=> {\n return turf.point([parseFloat(d.Longitude), parseFloat(d.Latitude)], d)\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":369,"value":"elemBuffer = turfBuffer.default(elemGeoData, 0.25, {units: \"miles\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"crimeData = FileAttachment(\"CrimeData.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"schoolData = FileAttachment(\"SchoolAddress - SchoolAddress@1.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":684,"value":"el_cerrito = FileAttachment(\"el_cerrito.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"---\n## Utilities","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":268,"value":"function formatNumber(x) {\n return x.toString().replace(/\\B(?=(\\d{3})+(?!\\d))/g, \",\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"turfPointInPolygon = import(\"https://cdn.skypack.dev/@turf/boolean-point-in-polygon\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"turfBuffer = import(\"https://cdn.skypack.dev/@turf/buffer\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"turfContains = import(\"https://cdn.skypack.dev/@turf/boolean-contains\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"turf = import(\"https://cdn.skypack.dev/turf\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 24:null