2c:null 2d:["$","title",null,{"children":"Philly mapping — COVID-19 Vaccinations POI View | Computational Social Science Lab | Observable"}] 32:T5d2c,viewof cbg_map = { lmc; let container = DOM.element("div", { class: "mainmap", style: `width:${width}px;height:${width * 0.7}px;` }); yield container; let map = L.map(container); esriLeaflet .tiledMapLayer({ url: "https://tiles.arcgis.com/tiles/fLeGjb7u4uXqeF9q/arcgis/rest/services/CityBasemap/MapServer?f=jsapi&cacheKey=8c0da44bee92edf8", maxZoom: 18 }) .addTo(map); esriLeaflet .tiledMapLayer({ url: "https://tiles.arcgis.com/tiles/fLeGjb7u4uXqeF9q/arcgis/rest/services/CityBasemap_Labels/MapServer?f=jsapi&cacheKey=b5e156f30610659b", maxZoom: 18 }) .addTo(map); map.on("load", (e) => { let target_num = "Total Visitors"; let blocks; let hoverDots; let clusterhoverblocks; let clusterblocks; let clusterselectedicon; let blockLines; let placeMarker; let originLatLng, originZoom, originCluster; let highlightedLayer; let highlightedMarker; let cluster_num_mean = 0; let cluster_num_max = 0, cluster_num_min = 0; let scaleSelect; let markerInfo; let clusterInfo; let exitInfo; let sitesToggle; let legendBar; let createLegendBar; const mean_places_num = aq_places .rollup({ mean: `d => op.mean(d['${target_num}']) ` }) .get("mean", 0); const getPlaces = (obj_table) => { return L.layerGroup( obj_table.map((p) => { let color = clusterColorFunction( logisticSize( 1, 0, p[target_num], mean_places_num, 2.0 / mean_places_num ) ); return L.marker([p.latitude, p.longitude], { title: p.location_name, place: p, icon: L.divIcon({ color: color, className: "default", iconAnchor: [8, 24], tooltipAnchor: [0, -22], popupAnchor: [0, -24], html: `${svg_marker}

` }) }).bindTooltip(p.location_name, { direction: "top" }); }) ); }; const places = getPlaces(aq_places.objects()); const vsites = L.layerGroup( vaccine_sites_aq.objects().map((v) => { return L.marker([v.lat, v.long], { title: v["Site_Name"], vsite: v }); }) ); //Leaflet Cluster Definitions const clusterIconCreateFunction = (size) => { return (cluster) => { let info = cluster.getAllChildMarkers().map((a) => { let a_num = a.options.place[target_num]; a_num = a_num || 0; return a_num; }); //.map(Number); let raw_num = info.reduce((a, b) => a + b, 0); //let size = clusterSize(raw_num, []); let short_num = raw_num > 1000 ? Math.round(raw_num / 1000) + "k" : Math.round(raw_num); return L.divIcon({ html: `

${short_num}

`, className: "cluster", iconSize: L.point(size, size) }); }; }; const clusterOptions = { animate: true, showCoverageOnHover: false, zoomToBoundsOnClick: true, disableClusteringAtZoom: 17, spiderfyOnMaxZoom: true, chunkedLoading: true, maxClusterRadius: 60, iconCreateFunction: clusterIconCreateFunction(32) }; let cluster = new L.markerClusterGroup(clusterOptions); const refreshClusterColor = () => { let num_arr = []; map.eachLayer((layer) => { if (layer.getChildCount) { let info = layer .getAllChildMarkers() .map((a) => { let a_num = a.options.place[target_num]; a_num = a_num || 0; return a_num; }) .map(Number); let num = info.reduce((a, b) => a + b, 0); num_arr.push(num); } }); if (num_arr.length != 0) { cluster_num_mean = num_arr.reduce((a, b) => a + b) / num_arr.length; cluster_num_max = Math.max(...num_arr); cluster_num_min = Math.min(...num_arr); } cluster.refreshClusters(); }; const getClusterCT = (markers) => { let geoid_info = aq .from( markers.map((a) => { return { info: a.options.place.origin_geoid_info }; }) ) .unroll("info") .derive({ origin_geoid: (d) => d.info.origin_geoid, target: `d => d.info['${target_num}']` }) .select(aq.not("info")) .dedupe("origin_geoid"); let raw_table = aq .from(geoid_info) .join_left(aq_tracts_alt, "origin_geoid") .select("type", "properties", "geometry", "target"); return [ raw_table.objects(), raw_table .rollup({ mean: (d) => op.average(d.target) }) .column("mean") .get(0) ]; }; //Leaflet Menus //bookmark createLegendBar = (data) => { L.Control.LegendBar = L.Control.extend({ onAdd: (map) => { let div = L.DomUtil.create("div"); let divbody = L.DomUtil.create("div"); let divtitle = L.DomUtil.create("h1"); div.className = "legend-bar"; divtitle.className = "legend-title"; divbody.className = "legend-body"; let cscale = L.DomUtil.create("div"); cscale.className = "legend-scale"; let topscale = L.DomUtil.create("h1"); let bottomscale = L.DomUtil.create("h1"); topscale.innerHTML = formatNum(cluster_num_max, 0); bottomscale.innerHTML = formatNum(cluster_num_min, 0); let rampcscale = L.DomUtil.create("div"); rampcscale.appendChild(vramp(colorFunction, 512, 150, true)); cscale.appendChild(topscale); cscale.appendChild(rampcscale); cscale.appendChild(bottomscale); divbody.appendChild(cscale); div.appendChild(divtitle); div.appendChild(divbody); return div; }, onRemove: (map) => {} }); L.control.legendBar = (opts) => { return new L.Control.LegendBar(opts); }; legendBar = L.control.legendBar({ position: "topleft" }); legendBar.addTo(map); }; const removeClusterMenu = (clearCluster = true) => { if (clusterInfo) clusterInfo.remove(); if (exitInfo) exitInfo.remove(); if (clearCluster) { cluster.clearLayers(); cluster.addLayers(places); } if (clusterblocks) clusterblocks.remove(); if (clusterselectedicon) clusterselectedicon.remove(); refreshClusterColor(); }; const removeMarkerMenu = () => { exitInfo.remove(); cluster.addTo(map); if (highlightedMarker) highlightedMarker.remove(); clusterblocks.addTo(map); clusterselectedicon.addTo(map); blocks.remove(); blockLines.remove(); placeMarker.remove(); markerInfo.remove(); map.flyTo(originLatLng, originZoom, { duration: 0.5 }); }; //Leaflet Controls const createSitesToggle = (data) => { L.Control.SitesToggle = L.Control.extend({ onAdd: (map) => { let div = L.DomUtil.create("div"); div.className = "sites-toggle"; div.innerHTML = "Hide Vaccination Sites"; L.DomEvent.on(div, "pointerdown", () => { if (map.hasLayer(vsites)) { div.innerHTML = "Show Vaccination Sites"; vsites.remove(); } else { div.innerHTML = "Hide Vaccination Sites"; vsites.addTo(map); } }); L.DomEvent.disableScrollPropagation(div); L.DomEvent.disableClickPropagation(div); return div; }, onRemove: (map) => {} }); L.control.sitesToggle = (opts) => { return new L.Control.SitesToggle(opts); }; sitesToggle = L.control.sitesToggle({ position: "topright" }); sitesToggle.addTo(map); }; const createExitInfo = (data) => { L.Control.ExitInfo = L.Control.extend({ onAdd: (map) => { let div = L.DomUtil.create("div"); let exit = L.DomUtil.create("div"); let web = L.DomUtil.create("div"); div.className = "exit-info"; exit.innerHTML = `Exit`; L.DomEvent.on(exit, "pointerdown", () => { removeMarkerMenu(); clusterInfo.addTo(map); clusterselectedicon.addTo(map); }); div.appendChild(exit); web.innerHTML = "Search on Google"; L.DomEvent.on(web, "pointerdown", () => { window.open( "http://google.com/search?q=" + data.location_name + "%20Philadelphia" ); }); div.appendChild(web); div.appendChild(exit); return div; }, onRemove: (map) => {} }); L.control.exitInfo = (opts) => { return new L.Control.ExitInfo(opts); }; exitInfo = L.control.exitInfo({ position: "bottomright" }); exitInfo.addTo(map); }; const createClusterInfo = (data) => { let show_table = aq .from(data.getAllChildMarkers().map((a) => a.options.place)) .derive({ "Lookup ID": (d) => d.safegraph_place_id + "_||_" + d.latitude + "_||_" + d.longitude }) .select( ["location_name", "top_category", "median_dwell"] .concat(POI_options) .concat(["Lookup ID"]) ) .rename({ location_name: "Name", top_category: "Category", median_dwell: "Median Dwell" }) .orderby(aq.desc(target_num)) .relocate([target_num], { after: "Category" }); let num = data .getAllChildMarkers() .map((a) => { let a_num = a.options.place[target_num]; a_num = a_num || 0; return a_num; }) .map(Number) .reduce((a, b) => a + b, 0); L.Control.ClusterInfo = L.Control.extend({ onAdd: (map) => { let div = L.DomUtil.create("div"); let infoBox = L.DomUtil.create("div"); let tableBox = L.DomUtil.create("div"); let titleBox = L.DomUtil.create("div"); let clusterExit = L.DomUtil.create("div"); div.id = "clusterInfo"; L.DomEvent.disableScrollPropagation(div); L.DomEvent.disableClickPropagation(div); titleBox.innerHTML = `

${data.getChildCount()} Markers Selected

${ num > 1000 ? Math.round(num / 100) / 10 + "k" : Math.round(num) } ${target_num}

`; tableBox.className = "cluster-table"; tableBox.innerHTML = show_table .toHTML({ limit: 100, maxdigits: 2 }) .replaceAll("", ``); let trs = Array.prototype.slice.call( tableBox.getElementsByTagName("table")[0].rows ); trs.shift(); trs.forEach((a) => { let split = a.lastChild.innerHTML.split("_||_"); const getDisplayMarkers = () => { let target_marker, hover_marker; cluster.eachLayer((l) => { if (l.options.place.safegraph_place_id == split[0]) { target_marker = l; hover_marker = L.marker(l._latlng, { zIndexOffset: 1000, icon: L.divIcon({ //iconSize: 24, iconAnchor: [12, 12], className: "default", html: `

` }) }); } }); return [target_marker, hover_marker]; }; L.DomEvent.on(a, "mouseover", (e) => { highlightedMarker = getDisplayMarkers()[1]; highlightedMarker.addTo(map); }); L.DomEvent.on(a, "mouseout", (e) => { if (highlightedMarker) highlightedMarker.remove(); }); L.DomEvent.on(a, "pointerdown", (e) => { getDisplayMarkers()[0].fire("click"); }); }); infoBox.className = "cluster-info"; infoBox.appendChild(titleBox); infoBox.appendChild(tableBox); clusterExit.className = "cluster-exit-info"; clusterExit.innerHTML = `

Exit

`; L.DomEvent.on(clusterExit, "pointerdown", () => { removeClusterMenu(); }); //bookmark div.appendChild(clusterExit); div.appendChild(infoBox); return div; }, onRemove: (map) => {} }); L.control.clusterInfo = (opts) => { return new L.Control.ClusterInfo(opts); }; clusterInfo = L.control.clusterInfo({ data: data, position: "bottomright" }); clusterInfo.addTo(map); }; const createMarkerInfo = (data) => { L.Control.MarkerInfo = L.Control.extend({ onAdd: (map) => { let div = L.DomUtil.create("div"); div.className = "marker-info"; div.innerHTML = `

${data.location_name}

${target_num}: ${Math.round( data[target_num] )} people

Median Dwell: ${Math.round( data.median_dwell )} minutes

${data.top_category}

`; return div; }, onRemove: (map) => {} }); L.control.markerInfo = (opts) => { return new L.Control.MarkerInfo(opts); }; markerInfo = L.control.markerInfo({ data: data, position: "bottomright" }); markerInfo.addTo(map); }; const refreshMenus = () => { if (clusterInfo._map) { let old_data = clusterInfo.options.data; clusterInfo.remove(); createClusterInfo(old_data); let old_markers = clusterblocks.options.markers; let [old_target_table, old_mean_num] = getClusterCT(old_markers); clusterblocks.remove(); clusterblocks = L.geoJson(old_target_table, { markers: old_markers, style: (f) => { return { fillColor: colorFunction( logisticSize(1, 0, f.target, old_mean_num, 2.0 / old_mean_num) ), color: "black", stroke: true, weight: 0.5, opacity: 0.4, fillOpacity: 0.2 }; } }).addTo(map); } if (markerInfo._map) { let old_data = markerInfo.options.data; markerInfo.remove(); exitInfo.remove(); createMarkerInfo(old_data); exitInfo.addTo(map); } }; const createScaleSelect = () => { L.Control.ScaleSelect = L.Control.extend({ onAdd: (map) => { let div = L.DomUtil.create("div"); div.className = "scale-select"; div.id = "scaleSelect"; div.innerHTML = ` `; L.DomEvent.on(div, "change", () => { target_num = div.lastChild.value; refreshClusterColor(); refreshMenus(); legendBar.remove(); createLegendBar(); }); return div; }, onRemove: (map) => {} }); L.control.scaleSelect = (opts) => { return new L.Control.ScaleSelect(opts); }; scaleSelect = L.control.scaleSelect({ position: "topright" }); scaleSelect.addTo(map); }; //Leaflet User Events cluster.on("clustermouseover", (a) => { let markers = a.layer.getAllChildMarkers(); let sorted_markers = aq.from(markers).sample(100).objects(); hoverDots = L.layerGroup( sorted_markers.map((m) => L.circle([m.options.place.latitude, m.options.place.longitude], { color: "purple", opacity: 0.5, radius: 1 }) ) ); hoverDots.addTo(map); let [target_table, mean_visits] = getClusterCT(markers); clusterhoverblocks = L.geoJson(target_table, { style: (f) => { return { fillColor: colorFunction( logisticSize(1, 0, f.target, mean_visits, 2.0 / mean_visits) ), color: "black", stroke: true, weight: 0.5, opacity: 0.3, fillOpacity: 0.2 }; } }).addTo(map); highlightedLayer = a.layer; a.layer.setOpacity(0.5); // } }); cluster.on("clustermouseout", (a) => { hoverDots.remove(); clusterhoverblocks.remove(); if (highlightedLayer) highlightedLayer.setOpacity(1); }); map.on("zoom layerremove", (e) => { if (map.hasLayer(clusterhoverblocks)) clusterhoverblocks.remove(); if (map.hasLayer(hoverDots)) hoverDots.remove(); }); cluster.on("animationend", (e) => { if (highlightedLayer) highlightedLayer.setOpacity(1); refreshClusterColor(); if (legendBar) { legendBar.remove(); createLegendBar(); } }); cluster.on("clusterclick", (e) => { removeClusterMenu(); createClusterInfo(e.layer); let markers = e.layer.getAllChildMarkers(); let [target_table, mean_visits] = getClusterCT(markers); clusterblocks = L.geoJson(target_table, { markers: markers, style: (f) => { return { fillColor: colorFunction( logisticSize(1, 0, f.target, mean_visits, 2.0 / mean_visits) ), color: "black", stroke: true, weight: 0.5, opacity: 0.4, fillOpacity: 0.2 }; } }).addTo(map); clusterselectedicon = e.layer; clusterselectedicon = L.marker(e.layer._latlng, { zIndexOffset: -1000, icon: L.divIcon({ html: e.layer._iconObj.options.html }) }); cluster.clearLayers(); cluster.addLayers(markers); clusterselectedicon.addTo(map); }); places.eachLayer((l) => { l.on("mouseover", (e) => { l.setTooltipContent( `` ); }); l.on("click", (e) => { clusterInfo.remove(); clusterselectedicon.remove(); if (map.hasLayer(clusterhoverblocks)) clusterhoverblocks.remove(); if (map.hasLayer(hoverDots)) hoverDots.remove(); console.log(highlightedMarker); if ( highlightedMarker == undefined || !map.hasLayer(highlightedMarker) ) { highlightedMarker = L.marker(l._latlng, { zIndexOffset: 1000, icon: L.divIcon({ //iconSize: 24, iconAnchor: [12, 12], className: "default", html: `

` }) }); } highlightedMarker.addTo(map); let raw_table = aq .from(l.options.place.origin_geoid_info) .join_left(aq_tracts_alt, "origin_geoid") .derive({ target: `d => d['${target_num}']` }) .select("type", "properties", "geometry", "target"); let mean_visits = raw_table .rollup({ mean: (d) => op.average(d.target) }) .column("mean") .get(0); let target_table = raw_table.objects(); let placeBlocks = L.geoJson(target_table, { style: (f) => { return { fillColor: colorFunction( logisticSize(1, 0, f.target, mean_visits, 1.0 / mean_visits) ), color: "black", stroke: true, weight: 1.5, opacity: 1, fillOpacity: 0.5 }; }, onEachFeature: (f, layer) => { layer.bindTooltip( Math.round(f.target * 100.0) / 100 + " avg visits", { direction: "top", sticky: true } ); } }); cluster.remove(); placeMarker = L.marker( [l.options.place.latitude, l.options.place.longitude], { zIndexOffset: 1000, title: l.options.place.location_name } ); placeMarker.addTo(map); blocks = placeBlocks; blockLines = L.layerGroup( target_table.map((b) => L.polyline( [ [l.options.place.latitude, l.options.place.longitude], [b.properties.INTPTLAT10, b.properties.INTPTLON10] ], { color: "black", weight: 1, opacity: 0.2 } ) ) ); blockLines.addTo(map); blocks.addTo(map); createMarkerInfo(l.options.place); createExitInfo(l.options.place); let selectLatLng = blocks.getBounds().extend(placeMarker.getLatLng()); originLatLng = map.getBounds().getCenter(); originZoom = map.getZoom(); map.flyToBounds(selectLatLng, { duration: 0.7 }); }); }); vsites.eachLayer((l) => { l.options.zIndexOffset = -500; l.bindTooltip( html``, { direction: "top" } ); l.options.icon = L.divIcon({ iconAnchor: [10, 10], iconSize: 20, html: `

`, className: "default" }); }); map.on("tooltipclose", (e) => { places.eachLayer((l) => { l.setOpacity(1); }); }); createScaleSelect(); createSitesToggle(); invalidation.then(() => { cluster.remove(); }); cluster.addLayers(places); cluster.addTo(map); refreshClusterColor(); createLegendBar(); vsites.addTo(map); }); map.setView([40, -75.12], 11); }33:Td91,html``34:T4bb,aq_tracts = aq_tracts_unroll .derive({ safegraph_place_info: d => { return { safegraph_place_id: d.safegraph_place_id, location_name: d.location_name, latitude: d.latitude, longitude: d.longitude, longitude: d.longitude, area: d.area_square_feet, category: d.top_category, geoid_visits: d.geoid_visits, median_dwell: d.median_dwell, total_visits: d.total_visits, total_sq_ft: d.place_total_sq_ft, p_vaccinated: d.percent_vaccinated_visits, p_nvaccinated: d.percent_not_vaccinated_visits, vaccinated: d.total_vaccinated_visits }; } }) .groupby("origin_geoid") .rollup({ type: op.any("type"), properties: op.any("properties"), geometry: op.any("geometry"), safegraph_place_info: op.array_agg("safegraph_place_info"), total_visits: op.sum("geoid_visits"), total_weighted_visits: op.sum("weighted_visits") }) .join(demographic_data_alt, ["origin_geoid", "GEOID"]) .join( clean_vaccination_data .rename({ census_tract_geoid: "origin_geoid" }) .select("origin_geoid", "vaccine_percent") ) .select(aq.not("GEOID"))35:Tc02,demographic_data_alt = demog_data .derive({ female: (d) => d[" female"], male: (d) => d[" male"], age_info: (d) => { return { "Under 20": op.parse_float(d[" <20"]), "20 to 34": op.parse_float(d[" 20-34"]), "35 to 54": op.parse_float(d[" 35-54"]), "55 to 75": op.parse_float(d[" 55-74"]), "Over 75": op.parse_float(d[" 75+"]) //'Over 65': op.parse_float(d[' 65+']) }; }, ethnicity_info: (d) => { return { "American Indian": op.parse_float( d[" American Indian and Alaska Native alone"] ), Asian: op.parse_float(d[" Asian alone"]), Black: op.parse_float(d[" Black or African American alone"]), White: op.parse_float(d[" White alone"]), "Pacific Islander": op.parse_float( d[" Native Hawaiian and Other Pacific Islander alone"] ), Other: op.parse_float(d[" Some other race alone"]), "Two or More": op.parse_float(d[" Two or more races:"]) }; }, income_info: (d) => { return { "Under $10k": op.parse_float(d["Less than $10,000"]), "$10k to $15k": op.parse_float(d["$10,000 to $14,999"]), "$15k to $20k": op.parse_float(d["$15,000 to $19,999"]), "$20k to $25k": op.parse_float(d["$20,000 to $24,999"]), "$25k to $30k": op.parse_float(d["$25,000 to $29,999"]), "$30k to $35k": op.parse_float(d["$30,000 to $34,999"]), "$35k to $40k": op.parse_float(d["$35,000 to $39,999"]), "$40k to $45k": op.parse_float(d["$40,000 to $44,999"]), "$45k to $50k": op.parse_float(d["$45,000 to $49,999"]), "$50k to $60k": op.parse_float(d["$50,000 to $59,999"]), "$60k to $75k": op.parse_float(d["$60,000 to $74,999"]), "$75k to $100k": op.parse_float(d["$75,000 to $99,999"]), "$100k to $130k": op.parse_float(d["$100,000 to $124,999"]), "$130k to $150k": op.parse_float(d["$125,000 to $149,999"]), "$150k to $200k": op.parse_float(d["$150,000 to $199,999"]), "$200k or more": op.parse_float(d["$200,000 or more"]) }; }, // poverty_info: (d) => { // return { // Above: op.parse_float(d["Less than $10,000"]), // Below: op.parse_float(d["Less than $10,000"]) // }; // }, family_info: (d) => { return { "Have Child": op.parse_float(d[" own child under18"]), "No Child": op.parse_float(d[" no child under18"]) }; } // transportation_info: (d) => { // return { // "Car/Truck": op.parse_float(d[" Car truck or van"]), // "Public Transportation": op.parse_float(d[" Public transportation"]), // Walking: op.parse_float(d[" walked"]), // "Taxi/Bike/Other": op.parse_float( // d[" Taxicab motorcycle bicycle or other means"] // ) // }; // } }) .select( "GEOID", "female", "male", "age_info", "ethnicity_info", "income_info", //"poverty_info", "family_info" //"transportation_info" )36:[{"id":"621d3de3e73f985a02641ff1b195fddbfe648bd7cb9704deada5a0b98aa202b6e8a6ebc704bd8aee62006a454394ed764dd9b9c1f12df263c6519bc0bd78d4dc","href":"https://static.observableusercontent.com/files/621d3de3e73f985a02641ff1b195fddbfe648bd7cb9704deada5a0b98aa202b6e8a6ebc704bd8aee62006a454394ed764dd9b9c1f12df263c6519bc0bd78d4dc","name":"ACSDP5Y2019.DP05_data_with_overlays_2021-06-28T173533.csv","type":"text/csv","lastModified":1624994732987.623,"size":866081},{"id":"449e620e7479e41a75d2150a5179d02ecc61aeb6e7cf7512770871c1493d67d9da92e5ad8175de33dba82799dbb58672b41e613a99b62a4f86b07d5a2d54ca9f","href":"https://static.observableusercontent.com/files/449e620e7479e41a75d2150a5179d02ecc61aeb6e7cf7512770871c1493d67d9da92e5ad8175de33dba82799dbb58672b41e613a99b62a4f86b07d5a2d54ca9f","name":"ACSDT5Y2019.B09001_data_with_overlays_2021-06-28T160411.csv","type":"text/csv","lastModified":1624994732987.623,"size":72655},{"id":"fb638891b1fe1acde7a23ef391f770835a67610a4ab95b7495c09a8c6f1f71717dd6d66f294325b3f3fd63ef6b40ec7e3e3b28cc6633e057b84bd803d88a6b61","href":"https://static.observableusercontent.com/files/fb638891b1fe1acde7a23ef391f770835a67610a4ab95b7495c09a8c6f1f71717dd6d66f294325b3f3fd63ef6b40ec7e3e3b28cc6633e057b84bd803d88a6b61","name":"Census_Block_Groups_2010.geojson","type":"application/geo+json","lastModified":1624994732987.623,"size":2482102},{"id":"db7e70eb2941ea9f69fd9fea947eadb638b9f622a7cbc0c399811f897f36c2088c8b1d45979c8402d181101a0c7b4b73f266d302dbdd424005662dc2a74611dc","href":"https://static.observableusercontent.com/files/db7e70eb2941ea9f69fd9fea947eadb638b9f622a7cbc0c399811f897f36c2088c8b1d45979c8402d181101a0c7b4b73f266d302dbdd424005662dc2a74611dc","name":"Census_Tracts_2010.geojson","type":"application/geo+json","lastModified":1624994732987.623,"size":1298632},{"id":"56aaee97d3327d111d242489d73959ec785007707f1a383bd3d595806405061364640044f5b9f2730b8f8f3b4da425010217e0d82b950982f986dea599494051","href":"https://static.observableusercontent.com/files/56aaee97d3327d111d242489d73959ec785007707f1a383bd3d595806405061364640044f5b9f2730b8f8f3b4da425010217e0d82b950982f986dea599494051","name":"cluster-teal@2.png","type":"image/png","lastModified":1624994732987.623,"size":7782},{"id":"1e73259a9ae7c756f70eae018e5de940b237eee54b0fbc2b2f3524349402144832061f7f2d41f7f8f6af9b72514fc11c4f8192eb72de07b16f161c8933d02222","href":"https://static.observableusercontent.com/files/1e73259a9ae7c756f70eae018e5de940b237eee54b0fbc2b2f3524349402144832061f7f2d41f7f8f6af9b72514fc11c4f8192eb72de07b16f161c8933d02222","name":"cluster-green.png","type":"image/png","lastModified":1624994732987.623,"size":7387},{"id":"c24f236f8d41b7ba6ec6c5397480eae55a086bd0235782ad8a771e3528ef5efa9b90380362d85e2da66ec8ae0de4d5fc75c86f888af500229956b7135bbf4c87","href":"https://static.observableusercontent.com/files/c24f236f8d41b7ba6ec6c5397480eae55a086bd0235782ad8a771e3528ef5efa9b90380362d85e2da66ec8ae0de4d5fc75c86f888af500229956b7135bbf4c87","name":"cluster-yellow.png","type":"image/png","lastModified":1624994732987.623,"size":7407},{"id":"c2c399b14abb2ecafcb73c7d73dd785122fff86e6ddcbcf4994cd09c42c04eca32cc8fdc300abcc7f1384345fae618fc0efb1bf64a6449238c4793c06cb36751","href":"https://static.observableusercontent.com/files/c2c399b14abb2ecafcb73c7d73dd785122fff86e6ddcbcf4994cd09c42c04eca32cc8fdc300abcc7f1384345fae618fc0efb1bf64a6449238c4793c06cb36751","name":"cluster-orange@2.png","type":"image/png","lastModified":1624994732987.623,"size":7981},{"id":"f48a4b4b32e7de96136e48e3a2e49c993571edcbed283800aad2a3dd701bced7bfc6e299acee90417352fd7a68cda5ab7ed802952bea05f851351b384c414d22","href":"https://static.observableusercontent.com/files/f48a4b4b32e7de96136e48e3a2e49c993571edcbed283800aad2a3dd701bced7bfc6e299acee90417352fd7a68cda5ab7ed802952bea05f851351b384c414d22","name":"cluster-red.png","type":"image/png","lastModified":1624994732987.623,"size":7258},{"id":"4b7abc566bf2e3804be16a86912c3861b47cd81941ecccef7f711bd82e271c3e71246f0d12874432e29bae0c9ecd877541a1392710648190ff3365668f8ed036","href":"https://static.observableusercontent.com/files/4b7abc566bf2e3804be16a86912c3861b47cd81941ecccef7f711bd82e271c3e71246f0d12874432e29bae0c9ecd877541a1392710648190ff3365668f8ed036","name":"Shot_0.png","type":"image/png","lastModified":1626400701766.822,"size":17372}] 30:{"id":"2c52d2f1f16fe7dc","slug":"philly-mapping-covid-19-vaccinations-poi-view","title":"Philly mapping — COVID-19 Vaccinations POI View","thumbnail":"3897141e2e992015184b996b9164a69083f4da7dbfe3a69aaa3059513ef76445","access_level":"public","create_time":"$D2021-06-29T19:25:32.987Z","update_time":"$D2022-07-29T06:02:56.605Z","view_time":null,"first_public_time":"$D2021-06-29T21:04:31.638Z","has_unpublished_edits":null,"fork":{"id":"cf6b9150c3461fc7","slug":"philly-mapping-covid-19-vaccinations","title":"Philly mapping — COVID-19 Vaccinations Tracts View","owner":{"id":"ecc432f62c173a15","login":"wattslab","name":"Computational Social Science Lab"}},"stars":0,"starred":false,"owner":{"type":"team","id":"ecc432f62c173a15","login":"wattslab","name":"Computational Social Science Lab","avatar_url":"https://avatars-next.observableusercontent.com/4cc949e746aa79aa4ecb9f0babaa098c3c5dbf10834c1e61e97aca8ee6aa5829","tier":"education_2026"},"version":10175,"publish_version":10175,"role":null,"authored":false,"authors":[{"type":"individual","id":"0375710557c1fa56","login":"markwhiting","name":"Mark Whiting","avatar_url":"https://avatars-next.observableusercontent.com/fd52664bcba9de06144ec65287fa2526a58b53368358d8111be9946ffa1ef66b","tier":null},{"type":"individual","id":"98d56a983fac65e1","login":"ghenry","name":"Henry Ge","avatar_url":"https://avatars-next.observableusercontent.com/61254385c8834287fc95d194b8416135cf35af836d15e78cafe4eaede11fea43","tier":null}],"members":[{"type":"individual","id":"98d56a983fac65e1","login":"ghenry","name":"Henry Ge","avatar_url":"https://avatars-next.observableusercontent.com/61254385c8834287fc95d194b8416135cf35af836d15e78cafe4eaede11fea43","tier":null,"role":"editor"},{"type":"team","id":"ecc432f62c173a15","login":"wattslab","name":"Computational Social Science Lab","avatar_url":"https://avatars-next.observableusercontent.com/4cc949e746aa79aa4ecb9f0babaa098c3c5dbf10834c1e61e97aca8ee6aa5829","tier":"education_2026","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"e47662e98f22dab4","slug":"covid-dashboards","title":"COVID Dashboards","owner":{"id":"ecc432f62c173a15","login":"wattslab","name":"Computational Social Science Lab"}},"type":"notebook","body":{"titling":"auto","title":"Philly mapping — COVID-19 Vaccinations POI View","cells":[{"id":0,"value":"md`# Philly mapping — COVID-19 Vaccinations POI View`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10043,"value":"Select clusters of places or places individually and see where visitors originated. Once a selection is made, see an ordered table of places that can be used to quickly navigate.\n\nLeave a selection use the **Exit** button in the bottom right of the view.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8830,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10076,"value":"md`*Note: Visit categories, such as unvaccinated visitors, are estimates. Certain businesses and areas may have different policies that could affect the number of visits per category. For example, a university could require vaccination, which would place real unvaccinated visits much lower than our estimates.*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2498,"value":"md`## Settings`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9557,"value":"viewof in_CT_color = Inputs.select(Object.keys(colorDictionary), {\n label: \"Census Tract Colors\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9347,"value":"clusterColorFunction = colorFunction //d3.interpolateHsl(\"rgb(52, 235, 159)\",\"rgb(235, 64, 52)\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9566,"value":"colorFunction = colorDictionary[in_CT_color]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3932,"value":"date = \"2021-06-14\"//\"2021-03-29\"\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9762,"value":"enrolled_Vaccination_Sites_PublicView = d3.json(\n \"https://services.arcgis.com/fLeGjb7u4uXqeF9q/ArcGIS/rest/services/Enrolled_Vaccination_Sites_PublicView/FeatureServer/0/query?where=State%3D%27PA%27&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&resultType=none&distance=0.0&units=esriSRUnit_Meter&returnGeodetic=false&outFields=*&returnGeometry=true&featureEncoding=esriDefault&multipatchOption=xyFootprint&maxAllowableOffset=&geometryPrecision=&outSR=&datumTransformation=&applyVCSProjection=false&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnQueryGeometry=false&returnDistinctValues=false&cacheHint=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&having=&resultOffset=&resultRecordCount=&returnZ=false&returnM=false&returnExceededLimitFeatures=true&quantizationParameters=&sqlFormat=none&f=pgeojson&token=\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1768,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10066,"value":"vsite_color = ({\n pharmacy: \"rgb(237, 100, 100)\",\n hospital: \"rgb(100, 180, 237)\",\n pdph: \"rgb(60, 199, 190)\",\n clinic: \"rgb(237, 207, 100)\",\n community: \"rgb(100, 237, 132)\",\n other: \"rgb(219, 219, 219)\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"md`## Resources`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10093,"value":"formatNum = (num, decimalplaces = 0) => {\n let decimalplacesfactor = Math.pow(10, decimalplaces);\n return num < 1\n ? Math.round((num * 100) / decimalplacesfactor) + '%'\n : num >= 1000\n ? Math.round((num / 1000) * decimalplacesfactor) / decimalplacesfactor + 'k'\n : Math.round(num * decimalplacesfactor) / decimalplacesfactor;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9560,"value":"colorDictionary = ({\n \"HSI RdYlGn\": d3.interpolateHsl(\"rgb(52, 235, 159)\", \"rgb(235, 64, 52)\"),\n Plasma: d3.interpolatePlasma,\n \"Red Yellow Green\": d3.interpolateRdYlGn,\n Magma: d3.interpolateMagma,\n \"Cube Helix Default\": d3.interpolateCubehelixDefault\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9624,"value":"svg_marker = ``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9351,"value":"getClusterColor = (x, c, k) =>\n clusterColorFunction(1 / (1 + Math.pow(Math.E, -k * (x - c))))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9357,"value":"getClusterColor(5, 10, 3.0 / 10)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7257,"value":"TVTractStyle = (x1, x2, m1, m2, max_opacity, min_opacity) => {\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6626,"value":"places_scale_focus = 'total_visits'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3021,"value":"tile_mode = 'light'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5819,"value":"clusterSize = (x, arr) => logisticSize(30, 15, x, 50, 1 / 50)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6013,"value":"tractsOpacity = (x, med, max, min) => logisticSize(max, min, x, med, 4.0 / med)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5999,"value":"logisticSize = (max, min, x, c, k) =>\n (max - min) / (1 + Math.pow(Math.E, -k * (x - c))) + min","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3320,"value":"md`## Tracts Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6653,"value":"aq_tracts_unroll = ct_data\n .join(poi_data, \"safegraph_place_id\")\n .join(aq_tracts_raw, [\"origin_geoid\", \"geoid\"])\n .join(vaccination_ct_data, \"safegraph_place_id\")\n .select(aq.not(\"geoid\")) //, 'type', 'geometry'\n .rename({\n estimated_visits_1: \"geoid_visits\",\n estimated_visits_2: \"place_total_visits\",\n visits_sq_ft_1: \"geoid_sq_ft\",\n visits_sq_ft_2: \"place_total_sq_ft\"\n })\n .derive({\n geoid_latitude: (d) => op.parse_float(d.properties.INTPTLAT10),\n geoid_longitude: (d) => op.parse_float(d.properties.INTPTLON10)\n })\n .derive({\n geoid_place_distance: (d) =>\n op.sqrt(\n op.pow(d.latitude - d.geoid_latitude, 2) +\n op.pow(d.longitude - d.geoid_longitude, 2)\n )\n })\n .derive({\n weighted_visits: (d) => d.geoid_visits * d.geoid_place_distance\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6668,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7307,"value":"aq_tracts_alt = aq_tracts\n .derive({\n \"CT Number\": (d) => \"CT\" + d.properties.NAME10\n })\n .select(\n aq.not(\n \"age_info\",\n \"ethnicity_info\",\n \"income_info\",\n //\"poverty_info\",\n \"family_info\"\n //\"transportation_info\"\n )\n )\n .join(aq_tracts_col, \"origin_geoid\")\n .relocate(\"CT Number\", { before: \"type\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9095,"value":"aq_tracts_col = aq_tracts\n .derive({\n \"Under 20\": (d) => d.age_info[\"Under 20\"],\n \"Over 65\": (d) => d.age_info[\"Over 65\"],\n \"Have Child\": (d) => d.family_info[\"Have Child\"],\n //\"In Poverty\": d => d.poverty_info[\"Below\"],\n \"% Vaccinated\": (d) => d.vaccine_percent\n })\n .select(\n \"origin_geoid\",\n \"Under 20\",\n \"Over 65\",\n \"Have Child\",\n //\"In Poverty\",\n \"% Vaccinated\"\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4297,"value":"aq_tracts_raw = aq\n .from((await FileAttachment(\"Census_Tracts_2010.geojson\").json()).features)\n .derive({\n geoid: x => x.properties.GEOID10\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"phillyCensusBlockGroups = await FileAttachment(\"Census_Block_Groups_2010.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3927,"value":"FIPS = 42101","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8850,"value":"md`## Places Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7686,"value":"POI_options = aq_places_col\n .columnNames()\n .filter(name => !['ct_index'].includes(name))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9162,"value":"aq_places_col.sample(20).view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9149,"value":"aq_places_col = aq_places_sum\n .derive({\n \"Total Visitors\": (d) => d.estimated_visits,\n \"# Visitors weighted by % Under 12\": (d) =>\n d[\"% under 12\"] * d.estimated_visits || 0,\n \"# Visitors weighted by % Under 20\": (d) =>\n d.age_info[\"Under 20\"] * d.estimated_visits,\n \"# Visitors weighted by % Unvaccinated\": (d) =>\n d.percent_not_vaccinated_visits * d.estimated_visits,\n \"# Visitors weighted by % Over 75\": (d) =>\n d.age_info[\"Over 75\"] * d.estimated_visits,\n \"# Visitors weighted by % With Children\": (d) =>\n d.family_info[\"Have Child\"] * d.estimated_visits\n // \"# Visitors weighted by % in Poverty\": (d) =>\n // d.poverty_info[\"Below\"] * d.estimated_visits,\n // \"# Visitors weighted by % with Cars\": (d) =>\n // d.transportation_info[\"Car/Truck\"] * d.estimated_visits\n })\n .select(aq.not(aq_places_sum.columnNames().filter((e) => e !== \"ct_index\")))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9170,"value":"aq_places_sum.view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9153,"value":"aq_places_sum = ct_data\n .join(demographic_data_alt.rename({ GEOID: 'origin_geoid' }), 'origin_geoid')\n .join(vaccination_ct_data, 'safegraph_place_id')\n .join(processed_under_18_table, 'origin_geoid')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9234,"value":"aq_places_collect.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9178,"value":"aq_places_collect = ct_data //.params({ POI_options })\n .join(aq_places_col, 'ct_index')\n .derive({\n origin_geoid_info: `d => ({${POI_collect}})`\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9247,"value":"aq_places_collect.get('origin_geoid_info', 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9205,"value":"POI_collect = {\n let obj = '';\n let arr = ['origin_geoid', 'estimated_visits', 'visits_sq_ft'].concat(\n POI_options\n );\n arr.forEach(option => {\n obj += `'${option}': d['${option}'], `;\n });\n return obj;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9256,"value":"POI_rollup = {\n let obj = {};\n let arr = ['origin_geoid_info'].concat(POI_options);\n arr.forEach(option => {\n option == 'origin_geoid_info'\n ? (obj[option] = `d => op.array_agg(d['${option}'])`)\n : (obj[option] = `d => op.sum(d['${option}'])`);\n });\n return obj;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8865,"value":"aq_places = aq_places_collect\n //.filter(`p => p.total_visits > ${places_filter}`)\n .params({ POI_rollup })\n .groupby(\"safegraph_place_id\")\n .rollup(POI_rollup)\n .join_left(poi_data, 'safegraph_place_id')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9272,"value":"aq_places.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9277,"value":"aq_places.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4233,"value":"ct_data = aq\n .from(await d3.csv(`${base_URL}networks_${FIPS}/bipartite_CT_${date}.csv`))\n .derive({ ct_index: (d) => d.safegraph_place_id + \"_\" + d.origin_geoid })\n .relocate(\"ct_index\", { before: \"safegraph_place_id\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4401,"value":"poi_data = aq.from(\n await d3.csv(`${base_URL}networks_${FIPS}/poi_summary_${date}.csv`)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8777,"value":"## Demographic Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6830,"value":"import { demographic_data } from \"@wattslab/covid-philly-census-tracts\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10147,"value":"demographic_data.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10159,"value":"demog_data.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6960,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8657,"value":"processed_under_18_table = raw_under_18_table\n .rename(\n raw_under_18_table\n .filter(r => r.geoid == \"id\")\n .select(aq.matches(\"B0900\"))\n .fold(aq.all())\n .filter(r => op.includes(r.value, \"Estimate\"))\n .derive({\n value: r =>\n op.replace(r.value, \"Estimate!!Total:!!In households:!!\", \"\")\n })\n .filter(r => !op.includes(r.value, \"Estimate\"))\n .pivot(\"key\", \"value\")\n .object()\n )\n .filter(r => r.geoid != \"id\")\n .select(aq.not(\"NAME\", aq.matches(\"B09001\")))\n .join(raw_population_data)\n .derive({\n \"Total under 12\": r =>\n op.parse_int(r[\"Under 3 years\"]) +\n op.parse_int(r[\"3 and 4 years\"]) +\n op.parse_int(r[\"5 years\"]) +\n op.parse_int(r[\"6 to 8 years\"]) +\n op.parse_int(r[\"9 to 11 years\"])\n })\n .derive({ \"% under 12\": r => r[\"Total under 12\"] / r.total_population })\n .select(\"geoid\", \"Total under 12\", \"% under 12\")\n .rename({ geoid: 'origin_geoid' })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8625,"value":"raw_under_18_table = aq\n .from(\n await FileAttachment(\n \"ACSDT5Y2019.B09001_data_with_overlays_2021-06-28T160411.csv\"\n ).csv()\n )\n .rename({ GEO_ID: \"geoid\" })\n .derive({ geoid: (r) => op.replace(r.geoid, \"1400000US\", \"\") })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8810,"value":"raw_population_data = aq\n .from(\n await FileAttachment(\n \"ACSDP5Y2019.DP05_data_with_overlays_2021-06-28T173533.csv\"\n ).csv()\n )\n .rename({ GEO_ID: \"geoid\", DP05_0001E: \"total_population\" })\n .filter((r) => r.geoid != \"id\")\n .derive({ geoid: (r) => op.replace(r.geoid, \"1400000US\", \"\") })\n .select(\"geoid\", \"total_population\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7478,"value":"md`## Vaccine Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10124,"value":"vaccine_sites_aq = aq\n .from(\n await d3.json(\n `https://data.cdc.gov/resource/5jp2-pgaw.json?loc_admin_city=Philadelphia`\n )\n )\n .rename({\n loc_admin_street1: \"Street_Address\",\n loc_name: \"Site_Name\",\n loc_admin_city: \"City\",\n loc_admin_state: \"State\",\n loc_admin_zip: \"ZIP_Code\",\n latitude: \"lat\",\n longitude: \"long\"\n })\n .derive({\n Type: d => \"Pharmacy\",\n ObjectId: d => op.row_number()\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7483,"value":"raw_vaccination_data = aq.from(\n (\n await d3.json(\n \"https://phl.carto.com/api/v2/sql?q=SELECT * FROM covid_vaccines_by_census_tract\"\n )\n ).rows\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7479,"value":"clean_vaccination_data = raw_vaccination_data\n .select(\"census_tract_geoid\", \"dose1_percent_range\", \"etl_timestamp\")\n .derive({\n vaccine_ordinal: (r) =>\n op.indexof(\n [\n null,\n \"<20%\",\n \"20-29%\",\n \"30-39%\",\n \"40-49%\",\n \"50-59%\",\n \"60-69%\",\n \"70%+\"\n ],\n r.dose1_percent_range\n ),\n vaccine_percent: (r) =>\n op.recode(r.dose1_percent_range, {\n null: 0,\n \"<20%\": 0.1,\n \"20-29%\": 0.25,\n \"30-39%\": 0.35,\n \"40-49%\": 0.45,\n \"50-59%\": 0.55,\n \"60-69%\": 0.65,\n \"70%+\": 0.85\n }),\n etl_timestamp: (r) => op.parse_date(r.etl_timestamp)\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7503,"value":"vaccination_ct_data = ct_data\n .join(\n clean_vaccination_data\n .rename({ census_tract_geoid: \"origin_geoid\" })\n .select(\"origin_geoid\", \"vaccine_percent\")\n )\n .join(\n demographic_data_alt\n .rename({ GEOID: \"origin_geoid\" })\n .derive({ under_20_percent: r => r.age_info[\"Under 20\"] })\n .select(\"origin_geoid\", \"under_20_percent\")\n )\n .derive({\n vaccine_weighted_visits: d => d.estimated_visits * d.vaccine_percent\n })\n .groupby(\"safegraph_place_id\")\n .rollup({\n percent_vaccinated_visits: r =>\n op.sum(r.vaccine_weighted_visits) / op.sum(r.estimated_visits),\n total_vaccinated_visits: r => op.sum(r.vaccine_weighted_visits),\n total_visits: r => op.sum(r.estimated_visits)\n })\n .derive({\n percent_not_vaccinated_visits: d => 1 - d.percent_vaccinated_visits\n })\n .ungroup()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10052,"value":"raw_vaccination_data.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10056,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3323,"value":"md`## Libraries and utilities`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10140,"value":"base_URL = \"https://upenn-seas-wattscovid19lab.s3.us-east-2.amazonaws.com/paco/stats/data/\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3806,"value":"sortTimes = (a, b) => a.getTime() - b.getTime()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"d3 = require('d3@5', 'd3-array@2', 'd3-regression@1')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":890,"value":"import { vl } from '@vega/vega-lite-api'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4039,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"L = require('leaflet')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10114,"value":"vramp(colorFunction, 512, 150, true)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10089,"value":"vramp = (color, n = 512, maxHeight = 150, reversed = false) => {\n const canvas = DOM.canvas(1, n);\n const context = canvas.getContext(\"2d\");\n canvas.style.maxHeight = maxHeight + \"px\";\n canvas.style.width = \"20px\";\n if (reversed) canvas.style.transform = 'scaleY(-1)';\n for (let i = 0; i < n; i++) {\n context.fillStyle = color(i / (n - 1));\n context.fillRect(0, i, 1, 1);\n }\n return canvas;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5513,"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","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10154,"value":"import { demog_data } from \"@wattslab/philadelphia-census-tract-data\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3725,"value":"scope = (value, min, max) =>\n value > min ? (max ? (value < max ? value : max) : value) : min","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3139,"value":"stats = require('simple-statistics')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2682,"value":"import { summarize, sigFigs, set } from \"@markwhiting/stats\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"import { radio, select, slider } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5308,"value":"import {\n Button,\n Checkbox,\n Toggle,\n Radio,\n Range,\n Select,\n Text,\n Textarea,\n Search,\n Table\n} from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":861,"value":"import { Scrubber } from \"@mbostock/scrubber\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3880,"value":"import { SiteList } from '@markwhiting/covid-philly'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3899,"value":"title = \"Mapping dashboard\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10058,"value":"leaflet_spin = require('leaflet-spin')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10062,"value":"esriLeaflet = require(\"https://unpkg.com/esri-leaflet@2.5.3/dist/esri-leaflet.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1"}} 31:"$30:body"