32:T777,md`In this visualization, every dot is an street intersection. Dot colour represents the walking time to the nearest food bank open during the time of the COVID-19 pandemic. The census tract's median income is represented by the blue coloured areas of the graph. Lighter coloured areas have lower median incomes. Lighter coloured dots represent shorter walking distaces to food banks. A mismatch may indicate a longer travel time for a poorer area. The list of Windsor food banks and whether they are currently open or closed was retrieved from Windsor Essex County Food Bank Association (WEFBA) website: http://wefba.ca/?p=210 Data was retrieved on April 18, 2020. An archived version of the site taken on that day can be found here: https://web.archive.org/web/20200418210935/http://wefba.ca/?p=210 The food bank list was later supplemented by Ontario 211 listings and from a flyer published by the Welcome Centre for women and families. Still later, a list of Essex County and Leamington food banks was provided by Katie Omstead (https://twitter.com/KatieOmstead). The West End Food Hub described by Mayor Dilkens in this tweet was included: https://twitter.com/drewdilkens/status/1250864093210251264. A full list of food banks in this visualization is located below the map. If you know of a food bank located withing Windsor that is open during COVID-19 but not included feel free to tweet me @JLHaldeman (https://twitter.com/JLHaldeman). Before you go to a food bank, call ahead to confirm they are still open and confirm hours and who they are currently providing services for. Also note that some food banks such as the Downtown Mission are providing delivery services during the pandemic. Special thanks to Doug Sartori (https://twitter.com/doug_sartori) for his suggestions on a possible source of information for Essex County interesections. Hover or tap for income or intersection details. `33:[{"id":"b1ad35ab7b079171b5126fc92d9bd10afe5dbcfc108794ae62557ef0ccf3bf9f8bc9e2f5c1ba800c4213465cba855798eb7d51436ec4c9764c7e60ae9fb39dd8","href":"https://static.observableusercontent.com/files/b1ad35ab7b079171b5126fc92d9bd10afe5dbcfc108794ae62557ef0ccf3bf9f8bc9e2f5c1ba800c4213465cba855798eb7d51436ec4c9764c7e60ae9fb39dd8","name":"WindsorWalktime@2.json","type":"application/json","lastModified":1588388104863.028,"size":2156890},{"id":"54360f0cb718405378577f255212305b9983b669a66cc365c531333876e3c857381b9b88309e2ac394b7bece3a97d6b9ee9e30cf6f507708b55213784e0269b7","href":"https://static.observableusercontent.com/files/54360f0cb718405378577f255212305b9983b669a66cc365c531333876e3c857381b9b88309e2ac394b7bece3a97d6b9ee9e30cf6f507708b55213784e0269b7","name":"FoodBanks@2.csv","type":"text/csv","lastModified":1588388997159.885,"size":1332},{"id":"da1aa022677906c3770c4158d72f5435610ca9de5e7c7a3cc8f9b634276f29c45dd21bbbf395998e1f295c7a9a36f419dfc34e146ef519638b164f351fa971b2","href":"https://static.observableusercontent.com/files/da1aa022677906c3770c4158d72f5435610ca9de5e7c7a3cc8f9b634276f29c45dd21bbbf395998e1f295c7a9a36f419dfc34e146ef519638b164f351fa971b2","name":"WindsorWalktime.json","type":"application/json","lastModified":1587208729971.971,"size":997380},{"id":"9e663c7b8d463e52e6faed462cb551e2c9ebd17fae2f1b1404c04252987aa7a540fbb6ce01386923570dc9555c5a58d8d318da37b1d0102d68d3abe0d200b27f","href":"https://static.observableusercontent.com/files/9e663c7b8d463e52e6faed462cb551e2c9ebd17fae2f1b1404c04252987aa7a540fbb6ce01386923570dc9555c5a58d8d318da37b1d0102d68d3abe0d200b27f","name":"WindsorWalktime@1.json","type":"application/json","lastModified":1587639684389.279,"size":1023367},{"id":"736017608dc0291042147200a6351897386b8063d751fe409660eda176877619132b67559183135a2f19df56cf8ec913ec20749326c3cc745e37ba62d9579a6f","href":"https://static.observableusercontent.com/files/736017608dc0291042147200a6351897386b8063d751fe409660eda176877619132b67559183135a2f19df56cf8ec913ec20749326c3cc745e37ba62d9579a6f","name":"FoodBanks@1.csv","type":"text/csv","lastModified":1587640335754.914,"size":537}] 30:{"title":"Windsor-Essex Walk Times to Food Banks Open During COVID-19 Outbreak","cells":[{"id":0,"value":"md`# Windsor-Essex Walk Times to Food Banks Open During COVID-19 Outbreak`","pinned":false,"hidden":false,"mode":"ojs"},{"id":212,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"container = {\n let container = html`

`;\n return container;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":151,"value":"html`\n ${getPointLegend()}\n ${getAreaLegend()}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":236,"value":"md`## List of Foodbanks Included\nThe food bank list on WEFBA's site was supplemented by Ontario 211 listings and from a flyer published by the Welcome Centre for women and families. When information about whether a food bank was open was not available, a phone call was made to enquire. If you know of a food bank located withing Essex County that is open during the COVID-19 crisis but not included feel free to tweet me @JLHaldeman (https://twitter.com/JLHaldeman).\n${foodbanks.map(d => '* ' + d[\"Food Bank\"] + '\\n').sort()}\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":252,"value":"md``","pinned":false,"hidden":false,"mode":"ojs"},{"id":241,"value":"md`## Code`","pinned":false,"hidden":false,"mode":"ojs"},{"id":44,"value":"getPointLegend = () => {\n return legend({\n color: d3.scaleSequential([0, 60], d3.interpolateInferno),\n title: \"Walk Time to Nearest Food Bank From Street Intersection (Dots)\",\n ticks: 6,\n tickFormat: d => {\n if (d == 60) {\n return \"60min+\";\n }\n return d + \"min\";\n },\n invert: true,\n inline: true\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":108,"value":"getAreaLegend = () =>\n legend({\n color: d3\n .scaleSequential(\n [incomeminmax.min, incomeminmax.max],\n d3.interpolateBlues\n )\n .nice(),\n tickFormat: \"$,.0f\",\n title: \"Median Income - 2016 Census (Areas)\",\n invert: false,\n inline: true\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":52,"value":"censuslayer = new deck.GeoJsonLayer({\n id: 'geojson',\n data: censusdata,\n opacity: 0.7,\n stroked: false,\n filled: true,\n extruded: true,\n wireframe: true,\n getElevation: 0,\n getFillColor: d => areaColorScale(d.properties.median_total_income),\n getLineColor: [100, 100, 100],\n pickable: true,\n autoHighlight: true\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"deckgl = {\n let zoom = 4.5;\n return new deck.DeckGL({\n container,\n map: mapboxgl,\n mapboxAccessToken: '',\n mapboxApiAccessToken: token,\n mapStyle: 'mapbox://styles/mapbox/light-v10',\n layers: [censuslayer, pointLayer],\n initialViewState: {\n longitude: -82.7806,\n latitude: 42.1555,\n zoom: 9.8,\n minZoom: 3,\n maxZoom: 15,\n pitch: 0\n },\n controller: true,\n getTooltip,\n autoHighlight: true\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":32,"value":"pointLayer = new deck.ScatterplotLayer({\n id: 'scatterplot-parks',\n data: points,\n opacity: 1,\n stroked: false,\n filled: true,\n getPosition: d => d.coord,\n getRadius: 50,\n radiusMinPixels: 1.2,\n getColor: d => getColorScale(3600, 0)(d.nearestFoodBank.walkTime),\n pickable: true,\n autoHighlight: true\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"getColorScale = (min, max) => d => {\n let func = d3\n .scaleSequential()\n .domain([min, max])\n .interpolator(d3.interpolateInferno);\n\n let col = d3.color(func(d));\n return [col.r, col.g, col.b];\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":70,"value":"areaColorScale = getAreaColorScale(incomeminmax.min, incomeminmax.max)","pinned":false,"hidden":false,"mode":"ojs"},{"id":61,"value":"getAreaColorScale = (min, max) => d => {\n if (d === null) {\n return [20, 20, 20];\n }\n let func = d3\n .scaleSequential()\n .domain([min, max])\n .interpolator(d3.interpolateBlues)\n .nice();\n\n let col = d3.color(func(d));\n return [col.r, col.g, col.b];\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":22,"value":"getTooltip = {\n return ({ object }) => {\n if (object === undefined) {\n return;\n } else if (object.type === \"Feature\") {\n return (\n \"Census Tract Median Income: \" +\n d3.format(\"$,.0f\")(object.properties.median_total_income)\n );\n } else if (object.names !== undefined) {\n return (\n \"Streets at this Intersection: \" +\n object.names.join(\", \") +\n \"\\n\" +\n \"Nearest Food Bank: \" +\n object.nearestFoodBank[\"Food Bank\"] +\n \"\\n\" +\n \"Walk Time: \" +\n d3.format(\".0f\")(object.nearestFoodBank.walkTime / 60) +\n \" min\"\n );\n } else {\n return;\n }\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"incomeminmax = censusdata.features.reduce(\n (accum, d) => {\n if (d.properties.median_total_income === null) {\n return accum;\n }\n if (accum.min > d.properties.median_total_income) {\n accum.min = d.properties.median_total_income;\n }\n if (accum.max < d.properties.median_total_income) {\n accum.max = d.properties.median_total_income;\n }\n return accum;\n },\n { min: 99999999, max: 0 }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"points = await FileAttachment(\"WindsorWalktime@2.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":48,"value":"censusdata = await d3.json(\n \"https://raw.githubusercontent.com/johnhaldeman/WindsorCensusMaps/master/src/parsed.json\"\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":231,"value":"foodbanks = d3.csvParse(await FileAttachment(\"FoodBanks@2.csv\").text())","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"token = {\n // Don't use this token. It will be rotated frequently. Get your own at https://mapbox.com\n return 'pk.eyJ1Ijoiam9obmhhbGRlbWFuIiwiYSI6ImNrMjIxNnBrdTAxN3Mzb3BmbWFzbnV6OGoifQ.HrfAiASrw9EQetZn13xAPg';\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"deck = require.alias({\n // optional dependencjei\n h3: {},\n s2Geometry: {}\n})('deck.gl@~8.0.0/dist.min.js')","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"mapboxgl = require('mapbox-gl@^1.4.1/dist/mapbox-gl.js')","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":2,"value":"import { legend } from \"@johnhaldeman/color-legend-invertable\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}