28:null 29:["$","title",null,{"children":"Manhattan - Zipcode: Evictions and COVID | Zhi Keng He | Observable"}] 2f:Te21,evi_chart = { const container = html`

`; const height = 400; const svg = d3 .select(container) .append("svg") .attr("viewBox", [0, 0, width, height]); const max = d3.max(Array.from(evi_data.values()).map((i) => i.per10k)); const scale = d3.scaleSequential(d3.interpolateReds).domain([0, max]); svg .append("g") .attr("transform", "translate(20,20)") .append(() => Legend(scale, { // title: `2021 Eviction filings per 10,000 rental units by zipcode`, title: `Eviction filings per 10k between ${evi_sliderDates[0].toLocaleDateString()} and ${evi_sliderDates[1].toLocaleDateString()} by zipcode`, ticks: 5, tickFormat: ".0f" }) ); const div = d3.select(container).append("div").classed("tooltip", true); const tooltip = new Tooltip(div); function tooltipContents(d) { const zip = d.properties.MODZCTA.toString(); const value = evi_data.get(zip); if (!value) return `

${zip}

${modzcta_lookup.get( zip )}

No filings during this date range.

`; const percent = d3.format(".2f")(value.per10k), filings = value.filings, unitsrental = d3.format(",")(value.unitsrental); return `

${zip}

${modzcta_lookup.get( zip )}

${percent} filings per 10,000 units or ${filings} filings among ${unitsrental} rental units.

`; } const projection = d3 .geoMercator() .rotate([0, -65, 0]) .fitExtent( [ [20, 20], [width, height] ], manhattan ); const path = d3.geoPath(projection); const g = svg.append("g"); const zips = g .selectAll(".p-base") .data(modzcta.features) .enter() .append("path") .classed("p-base", true) .attr("d", path) .attr("stroke", "white") .attr("stroke-width", 0.4) .attr("fill", (d) => { const zip = d.properties.MODZCTA.toString(); if (zip === "99999") return "#cccccc"; if (mn_zctas.includes(zip)) { //lookup values const value = evi_data.get(zip); return value ? scale(value.per10k) : "#ccc"; } return "#E9E9E9"; //default return }); const tooltip_zips = g .selectAll(".p-inter") .data( modzcta.features.filter((d) => mn_zctas.includes(d.properties.MODZCTA.toString()) ) ) .enter() .append("path") .classed("p-inter", true) .attr("d", path) .attr("fill", "rgba(0,0,0,0)") .attr("stroke", "black") .attr("stroke-width", 0) .on("mouseover", function (event, d) { tooltip.display(d, tooltipContents); d3.select(this).style("stroke", "black").style("stroke-width", 1.5); }) .on("mouseout", function () { tooltip.hide(); d3.select(this).style("stroke", "black").style("stroke-width", 0); }) .on("mousemove", (event) => { tooltip.move(event); }); g.append("path") .datum(marble_hill) .attr("fill", "none") .attr("stroke", "white") .attr("stroke-alignment", "outside") .attr("stroke-width", 1.4) .attr("d", path); return container; }30:T1679,covid_chart = { const container = html`

`; const height = 400; const svg = d3 .select(container) .append("svg") .attr("viewBox", [0, 0, width, height]); svg .append("defs") .append("pattern") .attr("id", "diagonalHatch") .attr("patternUnits", "userSpaceOnUse") .attr("width", 3) .attr("height", 3) .append("path") .attr("d", "M-1,1 l2,-2 M0,4 l4,-4 M3,5 l2,-2") .attr("stroke", "rgba(0,0,0,0.5)") .attr("stroke-width", 0.6); svg .append("defs") .append("pattern") .attr("id", "diagonalHatchDark") .attr("patternUnits", "userSpaceOnUse") .attr("width", 3) .attr("height", 3) .append("path") .attr("d", "M-1,1 l2,-2 M0,4 l4,-4 M3,5 l2,-2") .attr("stroke", "rgba(255,255,255,0.7)") .attr("stroke-width", 0.6); svg .append("g") .attr("transform", "translate(20,20)") .append(() => Legend(covid_scale, { title: covid_options.date === "last7days" ? "COVID positivity percentage by zipcode" : "Cumulative total deaths per 100k (confirmed)", ticks: 4, tickFormat: ".1f" }) ); const div = d3.select(container).append("div").classed("tooltip", true); const tooltip = new Tooltip(div); function tooltipContents(d) { const zip = d.properties.MODZCTA.toString(); const format = covid_options.date === "last7days" ? d3.format("") : d3.format(","); const number = format(covid_data.get(zip)); const text = covid_options.date === "last7days" ? `

${number}% of people with a molecular test tested positive

` : `

${number} cases per 100k people

`; return `

${zip}

${modzcta_lookup.get(zip)}

${text}`; } const projection = d3 .geoMercator() .rotate([0, -65, 0]) .fitExtent( [ [20, 20], [width, height] ], manhattan ); const path = d3.geoPath(projection); const g = svg.append("g"); const zips = g .selectAll(".p-base") .data(modzcta.features) .enter() .append("path") .classed("p-base", true) .attr("d", path) .attr("stroke", "white") .attr("stroke-width", 0.4) .attr("fill", (d) => { const zip = d.properties.MODZCTA.toString(); if (zip === "99999") return "#cccccc"; if (mn_zctas.includes(zip)) { //lookup values return covid_scale(+covid_data.get(zip)); } return "#E9E9E9"; //default return }); const tooltip_zips = g .selectAll(".p-inter") .data( modzcta.features.filter((d) => mn_zctas.includes(d.properties.MODZCTA.toString()) ) ) .enter() .append("path") .classed("p-inter", true) .attr("d", path) .attr("fill", (d) => { const zip = d.properties.MODZCTA.toString(); const find = covid_last7days.find((i) => i.modzcta === zip); if (find && find.adequately_tested === "No") { const color = covid_scale(+covid_data.get(zip)); return color === "rgb(117, 3, 15)" ? "url(#diagonalHatchDark)" : "url(#diagonalHatch)"; } return "rgba(0,0,0,0)"; }) .attr("stroke", (d) => { const zip = d.properties.MODZCTA.toString(); const find = covid_last7days.find((i) => i.modzcta === zip); if (find && find.adequately_tested === "No") { return "white"; } return "white"; }) .attr("stroke-width", (d) => { const zip = d.properties.MODZCTA.toString(); const find = covid_last7days.find((i) => i.modzcta === zip); if (find && find.adequately_tested === "No") { return 1; } return 0; }) .on("mouseover", function (event, d) { tooltip.display(d, tooltipContents); //d3.select(this).style("stroke", "black").style("stroke-width", 1.5); }) .on("mouseout", function () { tooltip.hide(); //d3.select(this).style("stroke", "black").style("stroke-width", 0); }) .on("mousemove", (event) => { tooltip.move(event); }); // const schoolDist = g // .append("path") // .datum(nysd) // .attr("fill", "none") // .attr("stroke", "grey") // .attr("stroke-opacity", 0.7) // .attr("stroke-dasharray", "2 1") // .attr("stroke-width", 1) // .attr("d", path); // const text = g // .selectAll(".labels") // .data(nysd.features) // .enter() // .append("g") // .attr("transform", (d) => { // const [x, y] = path.centroid(d); // return `translate(${x},${y})`; // }) // .call((g) => { // g.append("text") // .attr("text-anchor", "middle") // .attr("font-size", "12px") // .text((d, i) => { // return d.properties.dist; // }); // }) // .call((g) => // g // .selectAll("text") // .clone(true) // .lower() // .attr("fill", "none") // .attr("stroke-width", 4) // .attr("stroke-linejoin", "round") // .attr("stroke", "white") // ); g.append("path") .datum(marble_hill) .attr("fill", "none") .attr("stroke", "white") .attr("stroke-alignment", "outside") .attr("stroke-width", 1.4) .attr("d", path); return container; }31:T4bb,marble_hill = { return { type: "Feature", properties: {}, geometry: { type: "LineString", coordinates: [ [-73.918367528576368, 40.875867239164897], [-73.917001510708317, 40.876850975913165], [-73.917541801357615, 40.8773402957465], [-73.916614132506908, 40.877890780558999], [-73.916073841857596, 40.877982528027744], [-73.91506461970134, 40.877997819272537], [-73.913963650076354, 40.878344420821144], [-73.913097146204819, 40.87887451730726], [-73.911078701892322, 40.880332282644062], [-73.91056899373261, 40.880424030112806], [-73.910252974673554, 40.879965292769057], [-73.909325305822861, 40.87922111885586], [-73.90806122958675, 40.878354614984332], [-73.907235502367996, 40.87751869360239], [-73.906797153350652, 40.876825490505162], [-73.906277251027731, 40.876509471446134], [-73.906146001176594, 40.874907713554258], [-73.90670540588188, 40.873400251671832], [-73.906618755494733, 40.87335437793746], [-73.907459773958294, 40.871407292767344], [-73.908734044357615, 40.871789573887142] ] } }; }32:T44d,evi_data = { const _unitsrental = await FileAttachment("filings_since_032320.csv").csv(); const _modzcta = await FileAttachment("ZCTA-to-MODZCTA.csv").csv(); const zcta_to_modzcta = new Map(_modzcta.map((i) => [i.ZCTA, i.MODZCTA])); const modzcta_unitsrental = d3.rollup( _unitsrental, (xs) => d3.sum(xs, (x) => +x.unitsrental), (d) => zcta_to_modzcta.get(d.zipcode) ); //filter for dates between const range_rows = (await FileAttachment("tabe.csv").csv()).filter( (i) => new Date(i.fdate) >= evi_sliderDates[0] && new Date(i.fdate) <= evi_sliderDates[1] ); //rollup data by modzcta const range_rollup = d3 .rollups( range_rows, (xs) => d3.sum(xs, (x) => +x.filings_since_032320), (d) => zcta_to_modzcta.get(d.zipcode) ) .map(([k, v]) => { const unitsrental = modzcta_unitsrental.get(k); return { zipcode: k, filings: v, unitsrental, per10k: unitsrental > 0 ? (v / unitsrental) * 10000 : 0 }; }); return new Map(range_rollup.map((i) => [i.zipcode, { ...i }])); }33:[{"id":"ed5f274702a6bb44dee6940a67e8db152cf6f9402ab7545c1e0c8c8c64a0d2ebc3505f97ec275dabbc2666c98c7d6cc880a435f332d65850a7a9144aa13812ed","href":"https://static.observableusercontent.com/files/ed5f274702a6bb44dee6940a67e8db152cf6f9402ab7545c1e0c8c8c64a0d2ebc3505f97ec275dabbc2666c98c7d6cc880a435f332d65850a7a9144aa13812ed","name":"filings_since_032320.csv","type":"text/csv","lastModified":1644597246889.164,"size":8288},{"id":"0dcf0cc90899c0676c2f4c15d5dc9c44a6e9f71f1031394494b146217af75911921b8f440867eb1e87a86abc7537b79966ff23b0c3d827da7c63a64e2ea124fb","href":"https://static.observableusercontent.com/files/0dcf0cc90899c0676c2f4c15d5dc9c44a6e9f71f1031394494b146217af75911921b8f440867eb1e87a86abc7537b79966ff23b0c3d827da7c63a64e2ea124fb","name":"manhattan@3.geojson","type":"application/geo+json","lastModified":1644597246889.164,"size":26457},{"id":"87dde080fd82e162ea8b11a298a190db3546871c380cc58c7310c73e91d8a0e8528e087ae1bcccb10c2f2475e134ccc26e5d182a673fed48461e7ae7f69053a8","href":"https://static.observableusercontent.com/files/87dde080fd82e162ea8b11a298a190db3546871c380cc58c7310c73e91d8a0e8528e087ae1bcccb10c2f2475e134ccc26e5d182a673fed48461e7ae7f69053a8","name":"nysd_mn@4.geojson","type":"application/geo+json","lastModified":1644598450721.086,"size":180484},{"id":"e6f82c32f0e9ecd78d5340d23662c59bb090bcb741aae500c512a8f4ebf692c620ecc7d39602933f7e6b82a56eb51cdf345ea28a07d12af05d4f3d8e3a67985c","href":"https://static.observableusercontent.com/files/e6f82c32f0e9ecd78d5340d23662c59bb090bcb741aae500c512a8f4ebf692c620ecc7d39602933f7e6b82a56eb51cdf345ea28a07d12af05d4f3d8e3a67985c","name":"tabe.csv","type":"text/csv","lastModified":1650911553782.521,"size":414509},{"id":"c234ed7733af42093723ff4c207161eeef8a74dedd2d799027d2c329a3d8ae6a67cb9b63d6132dd44cb1a492fcf81d3e3833c421eb064ae1f88a434e4a4005ce","href":"https://static.observableusercontent.com/files/c234ed7733af42093723ff4c207161eeef8a74dedd2d799027d2c329a3d8ae6a67cb9b63d6132dd44cb1a492fcf81d3e3833c421eb064ae1f88a434e4a4005ce","name":"ZCTA-to-MODZCTA.csv","type":"text/csv","lastModified":1644597246889.164,"size":3457}] 2c:{"id":"4cf06719ca1977c1","slug":null,"title":"Manhattan - Zipcode: Evictions and COVID","thumbnail":"b792958945b66eb3801a95fe77f53457e3af4594bca3865b42e5238185a20039","access_level":"public","create_time":"$D2022-02-11T16:34:06.889Z","update_time":"$D2022-07-22T15:42:43.310Z","view_time":null,"first_public_time":"$D2022-05-02T18:10:11.001Z","fork":{"id":"71e3198b25cc5a29","slug":"manhattan-zipcode-evictions-and-covid-cases","title":"Manhattan - Zipcode: Evictions and COVID Cases","owner":{"id":"16506c8d98fe0d4f","login":"zhik","name":"Zhi Keng He"}},"stars":0,"starred":false,"owner":{"type":"team","id":"16506c8d98fe0d4f","login":"zhik","name":"Zhi Keng He","avatar_url":"https://avatars-next.observableusercontent.com/1921c3cb8ffa82cde953aa4417dc8b601dbd05384629c1f8ecf0544be068a204","tier":"starter_2024"},"version":1057,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"215e59083f0e53f8","login":"zhik","name":"Zhi Keng He","avatar_url":"https://avatars-next.observableusercontent.com/1921c3cb8ffa82cde953aa4417dc8b601dbd05384629c1f8ecf0544be068a204","tier":null}],"members":[{"type":"individual","id":"215e59083f0e53f8","login":"zhik","name":"Zhi Keng He","avatar_url":"https://avatars-next.observableusercontent.com/1921c3cb8ffa82cde953aa4417dc8b601dbd05384629c1f8ecf0544be068a204","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Manhattan - Zipcode: Evictions and COVID","cells":[{"id":0,"value":"# Manhattan - Zipcode: Evictions and COVID","pinned":false,"hidden":false,"mode":"md"},{"id":854,"value":"

Data from NYS Office of Court Administration (OCA) via HDC, and and PLUTO19v2.
*Numbers of total units per zip code exclude single-unit properties to approximate the number of rental units.
\nHover for details.

","pinned":false,"hidden":false,"mode":"html"},{"id":1041,"value":"evi_data","pinned":false,"hidden":false,"mode":"ojs"},{"id":7,"value":"viewof evi_slider = rangeSlider({\n min: 0,\n max: d3.timeDay.count(evi_start, evi_end),\n step: 1,\n value: this\n ? this.value\n : [evi_scale(new Date(2017, 0, 1)), evi_scale(new Date(2022, 11, 31))],\n format: (d) => formatDate(d3.timeDay.offset(evi_start, d)),\n title: \"Eviction cases in 2021\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":800,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":99,"value":"viewof covid_options = form(html`

COVID cases

\n \n 7-day percent positive \n \n \n\n Cases since the start of outbreak\n\n

\n\n

Data from NYC Department of Health and Mental Hygiene. 7-day data is from ${covid_last7days[0].daterange}.
\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":237,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":1024,"value":"FileAttachment(\"tabe.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs"},{"id":62,"value":"## Appendix ","pinned":false,"hidden":false,"mode":"md"},{"id":877,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":120,"value":"#### Data imports: covid from [nychealth](https://github.com/nychealth/coronavirus-data/blob/master/totals/data-by-modzcta.csv?utm_source=pocket_mylist) and eviction court filings from [housing data coalition](https://github.com/housing-data-coalition/oca).","pinned":false,"hidden":false,"mode":"md"},{"id":296,"value":"modzcta = topojson.feature(\n MODZCTA_2010_WGS1984,\n MODZCTA_2010_WGS1984.objects.collection\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":352,"value":"manhattan = await (await FileAttachment(\"manhattan@3.geojson\")).json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":904,"value":"nysd = await (await FileAttachment(\"nysd_mn@4.geojson\")).json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":314,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":333,"value":"mn_zctas = [\n \"10001\",\n \"10002\",\n \"10003\",\n \"10004\",\n \"10005\",\n \"10006\",\n \"10007\",\n \"10009\",\n \"10010\",\n \"10011\",\n \"10012\",\n \"10013\",\n \"10014\",\n \"10016\",\n \"10017\",\n \"10018\",\n \"10019\",\n \"10021\",\n \"10022\",\n \"10023\",\n \"10024\",\n \"10025\",\n \"10026\",\n \"10027\",\n \"10028\",\n \"10029\",\n \"10030\",\n \"10031\",\n \"10032\",\n \"10033\",\n \"10034\",\n \"10035\",\n \"10036\",\n \"10037\",\n \"10038\",\n \"10039\",\n \"10040\",\n \"10044\",\n \"10065\",\n \"10069\",\n \"10075\",\n \"10128\",\n \"10280\",\n \"10282\",\n \"10463\"\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":228,"value":"MODZCTA_2010_WGS1984 = await (\n await fetch(\n \"https://raw.githubusercontent.com/nychealth/coronavirus-data/master/Geography-resources/MODZCTA_2010_WGS1984.topo.json\"\n )\n).json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":198,"value":"covid_last7days = {\n const file = await fetch(\n \"https://raw.githubusercontent.com/nychealth/coronavirus-data/master/latest/last7days-by-modzcta.csv\"\n );\n\n return d3.csvParse(await file.text());\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":217,"value":"covid_totalsince = {\n const file = await fetch(\n \"https://raw.githubusercontent.com/nychealth/coronavirus-data/master/totals/data-by-modzcta.csv\"\n );\n\n return (await d3.csvParse(await file.text())).map((d) => {\n d.modzcta = d.MODIFIED_ZCTA;\n return d;\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":475,"value":"covid_data = {\n if (covid_options.date === \"last7days\") {\n return new Map(\n covid_last7days.map((i) => [i.modzcta, +i.percentpositivity_7day])\n );\n }\n\n if (covid_options.date === \"totalsince\") {\n return new Map(\n covid_totalsince.map((i) => [i.modzcta, +i.COVID_CONFIRMED_DEATH_RATE])\n );\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":494,"value":"modzcta_lookup = new Map(\n covid_last7days.map((i) => [i.modzcta, i.modzcta_name])\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":519,"value":"covid_scale = d3\n .scaleSequentialQuantile(d3.interpolateReds)\n .domain(Array.from(covid_data.values()))","pinned":false,"hidden":false,"mode":"ojs"},{"id":725,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":59,"value":"#### Slider code adapted from [azureuse](https://observablehq.com/@azureuse/slider-time)","pinned":false,"hidden":false,"mode":"md"},{"id":36,"value":"evi_sliderDates = evi_slider.map((d) => d3.timeDay.offset(evi_start, d))","pinned":false,"hidden":false,"mode":"ojs"},{"id":52,"value":"evi_scale = d3\n .scaleTime()\n .domain([evi_start, evi_end])\n .range([0, d3.timeDay.count(evi_start, evi_end)])","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"formatDate = d3.timeFormat(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"evi_start = new Date(2017, 0, 1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":11,"value":"evi_end = new Date(2022, 11, 31)","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"import {rangeSlider} from \"@mootari/range-slider\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":102,"value":"#### Other imports and logic","pinned":false,"hidden":false,"mode":"md"},{"id":115,"value":"function formValue(form) {\n const object = {};\n for (const input of form.elements) {\n if (input.disabled || !input.hasAttribute(\"name\")) continue;\n let value = input.value;\n switch (input.type) {\n case \"range\":\n case \"number\": {\n value = input.valueAsNumber;\n break;\n }\n case \"date\": {\n value = input.valueAsDate;\n break;\n }\n case \"radio\": {\n if (!input.checked) continue;\n break;\n }\n case \"checkbox\": {\n if (input.checked) value = true;\n else if (input.name in object) continue;\n else value = false;\n break;\n }\n case \"file\": {\n value = input.multiple ? input.files : input.files[0];\n break;\n }\n case \"select-multiple\": {\n value = Array.from(input.selectedOptions, (option) => option.value);\n break;\n }\n }\n object[input.name] = value;\n }\n return object;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":156,"value":"function form(form) {\n const container = html`

${form}`;\n form.addEventListener(\"submit\", (event) => event.preventDefault());\n form.addEventListener(\"change\", () => {\n container.dispatchEvent(new CustomEvent(\"input\"));\n });\n form.addEventListener(\"input\", () => (container.value = formValue(form)));\n container.value = formValue(form);\n return container;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":275,"value":"topojson = require(\"topojson\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":284,"value":"d3 = require(\"d3\", \"d3-geo-projection@2\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":515,"value":"import { Legend } from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":596,"value":"import { Tooltip } from \"@clhenrick/tooltip-component\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}} 2d:"$2c:body"