2c:null 2d:["$","title",null,{"children":"COVID-19 Relief - Grants and Loans in Manhattan | Zhi Keng He | Observable"}] 32:T481,viewof ppp_options = form(html``)33:T464,viewof rrf_options = form(html``)34:T487,viewof continuity_options = form(html``)35:T137a,function generateMap(prefix = "ppp_", column = "sum") { const container = html`

`; const height = 400; const svg = d3 .select(container) .append("svg") .attr("viewBox", [0, 0, width, height]); //map and projection const projection = d3 .geoMercator() .rotate([0, -65, 0]) .fitExtent( [ [20, 20], [width, height] ], manhattan ); const path = d3.geoPath(projection); const g = svg.append("g"); //scale const values = new Map( data .filter((row) => row[prefix + column]) .map((row) => [row.ZCTA_, +row[prefix + column]]) ); const scale = d3 .scaleSequentialQuantile(d3.interpolateReds) .domain(Array.from(values.values())); //legend svg .append("g") .attr("transform", "translate(20,20)") .append(() => Legend(scale, { ticks: 4, tickFormat: column === "count" ? ",.0f" : "$,.0f" }) ); //zipcode and hover overs const zips = g .selectAll(".p-base") .data(zcta.features) .enter() .append("path") .classed("p-base", true) .attr("d", path) .attr("stroke", "white") .attr("stroke-width", 0.4) .attr("fill", (d) => { const key = d.properties.ZCTA5CE20; const value = values.get(key); if (value) return scale(value); return "#E9E9E9"; }); const div = d3.select(container).append("div").classed("tooltip", true); const tooltip = new Tooltip(div); function tooltipContents(d) { const key = d.properties.ZCTA5CE20; const find = data.find((row) => row.ZCTA_ === key); const text = `

Count of loans/grants:

${d3.format(".0f")( find[prefix + "count"] )}

Total amount:

${d3.format("$,.2f")( find[prefix + "sum"] )}

Average amount:

${d3.format("$,.2f")( find[prefix + "avg"] )}

`; const text2 = `

Count of loans/grants:

${d3.format(".0f")( find[prefix + "count"] )}

Total approved amount:

${d3.format("$,.2f")( find[prefix + "approval_sum"] )}

Average approved amount:

${d3.format("$,.2f")( find[prefix + "approval_avg"] )}

Total forgiveness amount:

${d3.format("$,.2f")( find[prefix + "forgive_sum"] )}

Average forgiveness amount:

${d3.format("$,.2f")( find[prefix + "forgive_avg"] )}

`; return `

${key}

${prefix === "ppp_" ? text2 : text}`; } const tooltip_zips = g .selectAll(".p-inter") .data( zcta.features.filter((d) => { //only show joined features const key = d.properties.ZCTA5CE20; const value = values.get(key); return value; }) ) .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); }); //community district and labels const districts = g .append("path") .datum(nycd) .attr("fill", "none") .attr("stroke", "grey") .attr("stroke-opacity", 0.7) .attr("stroke-dasharray", "2 1") .attr("stroke-width", 0.9) .attr("d", path); const text = g .selectAll(".labels") .data(nycd.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.cd; }); }) .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; }36: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] ] } }; }37:[{"id":"2d68b5ceae53afc21753e8af8d621fd151b30e52317a16d5b7a1feb8b89a007cccdd6dffcd3701a9be6c12b3a3bcc7af46e2d2e0bbbf689e4a44f490d2a14c8a","href":"https://static.observableusercontent.com/files/2d68b5ceae53afc21753e8af8d621fd151b30e52317a16d5b7a1feb8b89a007cccdd6dffcd3701a9be6c12b3a3bcc7af46e2d2e0bbbf689e4a44f490d2a14c8a","name":"totals.csv","type":"text/csv","lastModified":1650471437276.501,"size":8539},{"id":"1b36cd46d02066c80797c5d495bf4a38a8ce6e1f34471c808928c8dbb2ecf02287c78bc501ec874f7d23986aea644fb5d80fe38e671d979f6328134b0893ffce","href":"https://static.observableusercontent.com/files/1b36cd46d02066c80797c5d495bf4a38a8ce6e1f34471c808928c8dbb2ecf02287c78bc501ec874f7d23986aea644fb5d80fe38e671d979f6328134b0893ffce","name":"totals@2.csv","type":"text/csv","lastModified":1650482277526.051,"size":8022},{"id":"0dcf0cc90899c0676c2f4c15d5dc9c44a6e9f71f1031394494b146217af75911921b8f440867eb1e87a86abc7537b79966ff23b0c3d827da7c63a64e2ea124fb","href":"https://static.observableusercontent.com/files/0dcf0cc90899c0676c2f4c15d5dc9c44a6e9f71f1031394494b146217af75911921b8f440867eb1e87a86abc7537b79966ff23b0c3d827da7c63a64e2ea124fb","name":"manhattan-3.geojson","type":"application/geo+json","lastModified":1650472255074.921,"size":26457},{"id":"ed31c6010c18e225644299500e8ff58fe002e5fe4a17adda069b864d7f1670cddb3b0e78700d40e152edbb2d8bcca7c05b5c7c5c58cc0015bf25dc6baa80eb04","href":"https://static.observableusercontent.com/files/ed31c6010c18e225644299500e8ff58fe002e5fe4a17adda069b864d7f1670cddb3b0e78700d40e152edbb2d8bcca7c05b5c7c5c58cc0015bf25dc6baa80eb04","name":"nycd@1.geojson","type":"application/geo+json","lastModified":1650472382118.234,"size":72646},{"id":"a1f23ba759dc86273176167015724681d5b3eb2007efca147b422bb659e569b95d87605b4fd47035f5d6f37cc3a7f1578f8b75a12d03edc177f83ff6f0ebe01d","href":"https://static.observableusercontent.com/files/a1f23ba759dc86273176167015724681d5b3eb2007efca147b422bb659e569b95d87605b4fd47035f5d6f37cc3a7f1578f8b75a12d03edc177f83ff6f0ebe01d","name":"zcta_1.geojson","type":"application/geo+json","lastModified":1650472438334.852,"size":773218}] 30:{"id":"34eafafe20ffa2f7","slug":"covid-19-relief-grants-and-loans","title":"COVID-19 Relief - Grants and Loans in Manhattan","thumbnail":"50d616066371becb04fa673f401ef2cccd64da6a3c04b525b5c4f6dba8a59849","access_level":"public","create_time":"$D2022-04-20T16:14:14.026Z","update_time":"$D2022-04-21T13:13:07.341Z","view_time":null,"first_public_time":"$D2022-04-20T18:56:49.648Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"16506c8d98fe0d4f","login":"zhik","name":"Zhi Keng He","avatar_url":"https://avatars-next.observableusercontent.com/1921c3cb8ffa82cde953aa4417dc8b601dbd05384629c1f8ecf0544be068a204","tier":"starter_2024","bio":""},"version":170,"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,"bio":""}],"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,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"COVID-19 Relief - Grants and Loans in Manhattan","cells":[{"id":0,"value":"# COVID-19 Relief - Grants and Loans in Manhattan\n\n- [Paycheck Protection Program (PPP)](https://data.sba.gov/dataset/ppp-foia)\n- [Restaurant Revitalization Fund (RRF)](https://data.sba.gov/dataset/rrf-foia)\n- [NYC Small Business Continuity Loan Program](https://data.cityofnewyork.us/City-Government/COVID-19-Loan-Grant-Report/buv4-at34)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":109,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"generateMap(\"ppp_\", ppp_options.column)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":140,"value":"generateMap(\"rrf_\", rrf_options.column)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"generateMap(\"sbs_continuity_\", continuity_options.column)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":29,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"d3 = require(\"d3@6\", \"d3-geo-projection@2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"import { Tooltip } from \"@clhenrick/tooltip-component\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"import { Legend } from \"@d3/color-legend\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"data = FileAttachment(\"totals@2.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"nycd = (await FileAttachment(\"nycd@1.geojson\")).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"zcta = (await FileAttachment(\"zcta_1.geojson\")).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"manhattan = (await FileAttachment(\"manhattan-3.geojson\")).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":112,"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W37","stdlib":"1"}} 31:"$30:body"