2a:null 2b:["$","title",null,{"children":"MBPO Capital Funding | Zhi Keng He | Observable"}] 31:T6ae,chart = { if (l.length === 0) return md``; const data = Object.entries(_(l).groupBy('year')).map(([name, values]) => { return { name, value: values.reduce((p, v) => p + +v.funding_c, 0) }; }); const years = [14, 15, 16, 17, 18, 19, 20, 21]; //from https://observablehq.com/@d3/bar-chart const color = "steelblue"; const height = 300; const margin = { top: 30, right: 0, bottom: 30, left: 60 }; const x = d3 .scaleBand() .domain(years) .range([margin.left, width - margin.right]) .padding(0.1); const y = d3 .scaleLinear() .domain([0, d3.max(data, d => d.value)]) .nice() .range([height - margin.bottom, margin.top]); const xAxis = g => g.attr("transform", `translate(0,${height - margin.bottom})`).call( d3 .axisBottom(x) .tickFormat(i => `FY${i}`) .tickSizeOuter(0) ); const yAxis = g => g .attr("transform", `translate(${margin.left},0)`) .call(d3.axisLeft(y).ticks(null, data.format)) .call(g => g.select(".domain").remove()) .call(g => g .append("text") .attr("x", -margin.left) .attr("y", 10) .attr("fill", "currentColor") .attr("text-anchor", "start") .text(data.y) ); const svg = d3.create("svg").attr("viewBox", [0, 0, width, height]); svg .append("g") .attr("fill", color) .selectAll("rect") .data(data) .join("rect") .attr("x", (d, i) => x(d.name)) .attr("y", d => y(d.value)) .attr("height", d => y(0) - y(d.value)) .attr("width", x.bandwidth()); svg.append("g").call(xAxis); svg.append("g").call(yAxis); return svg.node(); }32:[{"id":"a67320492501b255c65fb9fe56b3553932411cb94022f6fcbe4817ba8dcad363bfdbc81cbf6ed2acb7b9de613e59edaa2974e9cb1f637e1dd28ee8b565a69784","href":"https://static.observableusercontent.com/files/a67320492501b255c65fb9fe56b3553932411cb94022f6fcbe4817ba8dcad363bfdbc81cbf6ed2acb7b9de613e59edaa2974e9cb1f637e1dd28ee8b565a69784","name":"Imported table 2-Grid view(1)@2.csv","type":"text/csv","lastModified":1616442427319.033,"size":224589}] 2e:{"id":"401ebd4cf066bbb1","slug":"mbpo-capital-funding","title":"MBPO Capital Funding","thumbnail":"e3a7e9df764e689fdd7e8e0497421e6994158a07d4b92db719881c765297c564","access_level":"public","create_time":"$D2021-03-12T15:33:44.518Z","update_time":"$D2021-03-22T19:47:07.496Z","view_time":null,"first_public_time":"$D2021-03-12T17:45:51.528Z","fork":false,"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":414,"publish_version":414,"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":"MBPO Capital Funding","cells":[{"id":0,"value":"md`# MBPO Capital Funding`","pinned":false,"hidden":false,"mode":"ojs"},{"id":48,"value":"viewof searchItems = Search(searchTerms, {\n placeholder: \"Search an org name or dbn\",\n columns: [\"name\", \"dbn\"]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":81,"value":"viewof selectedItems = Table(searchItems, { rows: 10 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":134,"value":"{\n const text = l.map(i => `- ${i.name}`);\n\n return md`## Details for:\n${_.uniq(text).join('\\n')}\n `;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":175,"value":"md`### Projects`","pinned":false,"hidden":false,"mode":"ojs"},{"id":158,"value":"viewof lTable = Table(l, {\n columns: ['year', 'project_title', 'project_type', 'funding_c'],\n sort: 'year'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":310,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":281,"value":"mapContainer = {\n if (l.length === 0) return md``;\n\n let mapContainer = DOM.element('div', { style: `height:400px;` });\n yield mapContainer;\n const settings = {\n maxZoom: 17,\n minZoom: 11\n };\n\n const map = L.map(mapContainer, { ...settings }).setView(\n [40.777383, -73.9693549],\n 11\n );\n\n L.tileLayer(\n 'https://cartodb-basemaps-{s}.global.ssl.fastly.net/rastertiles/voyager_labels_under/{z}/{x}/{y}{r}.png',\n {\n ...settings,\n attribution:\n 'Carto | © OSM contributors'\n }\n ).addTo(map);\n\n const markers = L.markerClusterGroup();\n\n let layer = L.geoJSON(geojson, {\n onEachFeature: (feature, layer) => {\n layer.bindPopup(feature.properties.label, {\n closeButton: false,\n autoPan: false,\n offset: L.point(0, 0)\n });\n }\n });\n\n markers.addLayer(layer);\n map.addLayer(markers);\n\n map.fitBounds(layer.getBounds(), { padding: [30, 30] });\n\n invalidation.then(() => map.remove());\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":261,"value":"md`### Other projects in the most recent building or lot\n\n*(Note: Only be relevant for co-located schools)*\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":264,"value":"{\n if (bblsSort.length) return md`**${bblsSort[0].organization_address}**`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":209,"value":"viewof sTable = Table(s, {\n columns: [\n 'year',\n 'link',\n 'name',\n 'project_title',\n 'project_type',\n 'funding_c'\n ],\n sort: 'year'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":147,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":376,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"md`### Import data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":297,"value":"geojson = {\n const fc = {\n type: \"FeatureCollection\",\n features: []\n };\n\n fc.features = l\n .filter(i => i.lng && i.lat)\n .map(i => ({\n type: \"Feature\",\n properties: {\n label: `${i.project_title}
FY: ${i.year}
Funding Amt: ${i.funding_c}`\n },\n geometry: {\n type: \"Point\",\n coordinates: [+i.lng, +i.lat]\n }\n }));\n\n return fc;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":102,"value":"l = {\n if (searchItems.length > 1 && searchItems.length === selectedItems.length) {\n return [];\n } else {\n //lookup\n const lookup = data.filter(row =>\n selectedItems.map(i => i.name).includes(row.name.trim())\n );\n\n //find if there are linked projects\n const lookup2 = data.filter(row =>\n lookup\n .filter(i => i.link)\n .map(i => i.link)\n .includes(row.link)\n );\n\n return lookup2.length ? lookup2 : lookup;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":249,"value":"bblsSort = {\n return l.sort((a, b) => b.year - a.year);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":205,"value":"s = {\n const bblMostCurrent = bblsSort.length ? bblsSort[0].bbl : null;\n const links = l.map(i => i.link);\n\n //find if there are projects are in the same building but not the same school\n const lookup = data.filter(\n row =>\n bblMostCurrent &&\n row.bbl === bblMostCurrent &&\n row.link &&\n !links.includes(row.link)\n );\n\n return lookup;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":52,"value":"searchTerms = _.uniq(\n data.map(({ name, dbn }) => ({ name: name.trim(), dbn })),\n false,\n i => JSON.stringify(i)\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"d = await FileAttachment(\"Imported table 2-Grid view(1)@2.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":119,"value":"data = d.map(i => ({\n ...i,\n name: `${i.name.trim()} ${i.dbn ? '( ' + i.link + ' )' : ''}`\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"md`### Import Libraries`","pinned":false,"hidden":false,"mode":"ojs"},{"id":276,"value":"L = {\n const L = await require(\"leaflet@1/dist/leaflet.js\");\n if (!L._style) {\n const href = await require.resolve(\"leaflet@1/dist/leaflet.css\");\n document.head.appendChild(\n (L._style = html``)\n );\n }\n return L;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":391,"value":"lmc = {\n L;\n const leafletmarkercluster = await require('leaflet.markercluster@1');\n if (!leafletmarkercluster._style) {\n const href = await require.resolve(\n \"leaflet.markercluster@1/dist/MarkerCluster.css\"\n );\n const href2 = await require.resolve(\n \"leaflet.markercluster@1/dist/MarkerCluster.Default.css\"\n );\n document.head.appendChild(\n (leafletmarkercluster._style = html``)\n );\n }\n return leafletmarkercluster;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs"},{"id":58,"value":"_ = (await import(\"https://unpkg.com/underscore@1.10.1/modules/index-all.js\"))\n .default","pinned":false,"hidden":false,"mode":"ojs"},{"id":28,"value":"import { Search, Table } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}} 2f:"$2e:body"