2e:null 2f:["$","title",null,{"children":"Staypoint Data Exploration | Targomo | Observable"}] 34:T5d2,viewof map = { let container = html`

`; // Give the container dimensions. yield container; // Create the "map" object with the maplibre.Map constructor, referencing // the container div const mapRef = (container.value = new maplibre.Map({ container, center: { lat: city.center[0], lng: city.center[1] }, zoom: city.zoom, pitch: city.pitch, style: tgmCoreClient("westcentraleurope").basemaps.getGLStyleURL(mode.name), attributionControl: true })); await new Promise((resolve, reject) => { mapRef.on("load", async () => { mapRef.addSource("h3_src", { type: "geojson", data: geoParquet, attribution: "© Targomo" }); mapRef.addLayer({ id: "h3_polygons", type: "fill-extrusion", source: "h3_src", layout: {}, filter: [">", ["get", "0_00"], 0], paint: { "fill-extrusion-height": buildHeightDef("0_00"), "fill-extrusion-color": buildColorDef("0_00", mode.interpolator), "fill-extrusion-opacity": 0.6, "fill-extrusion-height-transition": { duration: framerate }, "fill-extrusion-color-transition": { duration: framerate } } }); resolve(); }); }); invalidation.then(() => mapRef.remove()); yield container; }35:Tb70,function Scrubber( values, { format = (value) => value, initial = 0, delay = null, autoplay = true, loop = true, loopDelay = null, alternate = false } = {} ) { values = Array.from(values); const form = html``; let frame = null; let timer = null; let interval = null; let direction = 1; function start() { form.b.textContent = "Pause"; if (delay === null) frame = requestAnimationFrame(tick); else interval = setInterval(tick, delay); } function stop() { form.b.textContent = "Play"; if (frame !== null) cancelAnimationFrame(frame), (frame = null); if (timer !== null) clearTimeout(timer), (timer = null); if (interval !== null) clearInterval(interval), (interval = null); } function running() { return frame !== null || timer !== null || interval !== null; } function tick() { if ( form.i.valueAsNumber === (direction > 0 ? values.length - 1 : direction < 0 ? 0 : NaN) ) { if (!loop) return stop(); if (alternate) direction = -direction; if (loopDelay !== null) { if (frame !== null) cancelAnimationFrame(frame), (frame = null); if (interval !== null) clearInterval(interval), (interval = null); timer = setTimeout(() => (step(), start()), loopDelay); return; } } if (delay === null) frame = requestAnimationFrame(tick); step(); } function step() { form.i.valueAsNumber = (form.i.valueAsNumber + direction + values.length) % values.length; form.i.dispatchEvent(new CustomEvent("input", { bubbles: true })); } form.i.oninput = (event) => { if (event && event.isTrusted && running()) stop(); form.value = values[form.i.valueAsNumber]; form.o.value = format(form.value, form.i.valueAsNumber, values); }; form.b.onclick = () => { if (running()) return stop(); direction = alternate && form.i.valueAsNumber === values.length - 1 ? -1 : 1; form.i.valueAsNumber = (form.i.valueAsNumber + direction) % values.length; form.i.dispatchEvent(new CustomEvent("input", { bubbles: true })); start(); }; form.update = (value) => { form.value = value; form.o.value = format(form.value, value, values); form.i.value = values.indexOf(value); form.dispatchEvent(new CustomEvent("input", { bubbles: true })); }; form.i.oninput(); if (autoplay) start(); else stop(); Inputs.disposal(form).then(stop); return form; }36:[{"id":"5b101c360fb494ded3a5855af2eeb6d4edbc8da1a82cfd724320e6eea5b29d4d811adae88b75418957efbf6fda50689c10fef6f38ea8459cc7d532c434cc2d9d","href":"https://static.observableusercontent.com/files/5b101c360fb494ded3a5855af2eeb6d4edbc8da1a82cfd724320e6eea5b29d4d811adae88b75418957efbf6fda50689c10fef6f38ea8459cc7d532c434cc2d9d","name":"london_res10.parq","type":"application/octet-stream","lastModified":1666019839452.175,"size":1954704},{"id":"74472a7aa58f84779616aba129d311fa3406ac4f223f2ceb41d120ad329c11b837306553977731e266d6f45882651067caa345240b8909dfeffc803e323addfe","href":"https://static.observableusercontent.com/files/74472a7aa58f84779616aba129d311fa3406ac4f223f2ceb41d120ad329c11b837306553977731e266d6f45882651067caa345240b8909dfeffc803e323addfe","name":"london_res9.parquet","type":"application/octet-stream","lastModified":1666165625826.493,"size":849356},{"id":"5b101c360fb494ded3a5855af2eeb6d4edbc8da1a82cfd724320e6eea5b29d4d811adae88b75418957efbf6fda50689c10fef6f38ea8459cc7d532c434cc2d9d","href":"https://static.observableusercontent.com/files/5b101c360fb494ded3a5855af2eeb6d4edbc8da1a82cfd724320e6eea5b29d4d811adae88b75418957efbf6fda50689c10fef6f38ea8459cc7d532c434cc2d9d","name":"london_res10.parquet","type":"application/octet-stream","lastModified":1666165625843.346,"size":1954704}] 32:{"id":"d6da4c9ae785ed76","slug":"staypoint-exploration","title":"Staypoint Data Exploration","thumbnail":"86a31364ca0c980c73b3b959c9ae1e517ccf104b83c178f89ee72c273db949b1","access_level":"public","create_time":"$D2022-10-17T15:15:16.203Z","update_time":"$D2023-01-24T10:50:04.720Z","view_time":null,"first_public_time":"$D2022-10-18T10:27:35.307Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"b873ed05f5a7d959","login":"targomo","name":"Targomo","avatar_url":"https://avatars-next.observableusercontent.com/39645f1242d4403a667e1c0e54a0d6755d36418f30088e89a9c65e6f84f9a3bf","tier":"starter_2024"},"version":730,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"a217b68901b4272f","login":"targomo","name":"Targomo","avatar_url":"https://avatars-next.observableusercontent.com/39645f1242d4403a667e1c0e54a0d6755d36418f30088e89a9c65e6f84f9a3bf","tier":null},{"type":"individual","id":"59ca7144f8ccf1d1","login":"abenrob","name":"Adam Roberts","avatar_url":"https://avatars-next.observableusercontent.com/35b4f71c800d4e6c9e2cfa93d55a4f89515f41428620d3050060df33504db2e1","tier":null}],"members":[{"type":"individual","id":"a217b68901b4272f","login":"targomo","name":"Targomo","avatar_url":"https://avatars-next.observableusercontent.com/39645f1242d4403a667e1c0e54a0d6755d36418f30088e89a9c65e6f84f9a3bf","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"432f8dea9d7805c0","slug":"data-exploration","title":"Data Exploration","owner":{"id":"b873ed05f5a7d959","login":"targomo","name":"Targomo"}},"type":"notebook","body":{"title":"Staypoint Data Exploration","cells":[{"id":0,"value":"# Staypoint Data Exploration\nAt [Targomo](https://www.targomo.com/), we deal with location data.\n\nOne of the best sources of insight is population movement data. We take this mobility data and isolate \"staypoints\", which are locations where the user stayed for a given period of time. \n\nWe want to be able to ascertain where people are at a given time-of-day/day-of-week, so we can determine potential visitors within a walkshed. e.g. _\"how many people are within a 15-minute walk of your restaurant(s) on weekdays at noon?\"_ You can read a bit more about our data processing [here](https://targomo.medium.com/how-we-learned-to-love-dask-and-achieved-a-40x-speedup-aa14e72d99c0).\n\n## Where are people in London?\nWe create staypoint data for many markets - here we are aggregating our staypoint data to h3 hexagons for London, and we can see where people are during the course of the day, for each day of the week. \n\nFor example, notice how fewer people are out Thursday evening as compared to Friday evening.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":640,"value":"html`

${viewof thursday18h} vs ${viewof friday18h}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":652,"value":"Or notice how few folks are out Monday 6am as compared to Monday 10am when they are at work. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":669,"value":"html`

${viewof monday6h} vs ${viewof monday10h}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":491,"value":"viewof frame = Scrubber(\n Array.from({ length: 7 }, (d, di) =>\n Array.from({ length: 24 }, (h, hi) => di + \"_\" + (hi < 10 ? \"0\" + hi : hi))\n ).flat(),\n {\n // loop: false,\n autoplay: false,\n delay: framerate,\n format: (d) => {\n const [day, hour] = d.split(\"_\");\n return `${parseDay(+day)}, ${+hour}h`;\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":537,"value":"viewof framerate = Inputs.select([50, 100, 150, 200, 250, 300], {\n label: \"Select framerate\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"viewof mode = Inputs.select(\n [\n { name: \"Light\", interpolator: d3.interpolateReds },\n { name: \"Dark\", interpolator: d3.interpolateViridis }\n ],\n { label: \"Select mode\", format: (d) => d.name }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":706,"value":"

\n### map styling","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":128,"value":"{\n map.setFilter(\"h3_polygons\", [\">\", [\"get\", frame], 0]);\n map.setPaintProperty(\n \"h3_polygons\",\n \"fill-extrusion-color\",\n buildColorDef(frame, mode.interpolator)\n );\n map.setPaintProperty(\n \"h3_polygons\",\n \"fill-extrusion-height\",\n buildHeightDef(frame)\n );\n return md`_change color and height based on frame..._`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":125,"value":"{\n if (map) {\n const [_d, _h] = frame.split(\"_\");\n const ctrlDiv = document.querySelector(\".maplibregl-ctrl-bottom-left\");\n ctrlDiv.innerHTML = `

${city.name}, ${parseDay(\n +_d\n )}, ${+_h}h

`;\n }\n return md`_set frame details block..._`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"function buildColorDef(dayhour, interpolator) {\n const scale = scaleCluster()\n .domain(breaks)\n .range(Array.from({ length: 9 }).map((d, i) => interpolator(i / (9 - 1))));\n\n const matchExpression = [\"interpolate\", [\"linear\"], [\"get\", dayhour]];\n // Calculate color values for each country based on 'hdi' value\n for (const b of breaks) {\n const color = scale(b);\n matchExpression.push(b, color);\n }\n\n return matchExpression;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"function buildHeightDef(dayhour) {\n const scale = scaleCluster()\n .domain(breaks)\n .range(Array.from({ length: 9 }).map((d, i) => 4000 * (i / (9 - 1))));\n\n const matchExpression = [\"interpolate\", [\"linear\"], [\"get\", dayhour]];\n // Calculate color values for each country based on 'hdi' value\n for (const b of breaks) {\n const height = scale(b);\n matchExpression.push(b, height);\n }\n\n return matchExpression;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":693,"value":"### data building","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":60,"value":"geoParquet = {\n return {\n type: \"FeatureCollection\",\n features: dt.array(\"h3_ind\").map((h) => {\n return {\n type: \"Feature\",\n geometry: {\n type: \"Polygon\",\n coordinates: [h3.h3ToGeoBoundary(h, true)]\n },\n properties: dt\n .params({ h: h })\n .filter((d) => d.h3_ind === h)\n .object()\n };\n })\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"london = FileAttachment(\"london_res9.parquet\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"dt = getDataTable(london)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":300,"value":"breaks = {\n const fullValues = Array.from({ length: 7 })\n .map((d, di) =>\n Array.from({ length: 24 })\n .map((h, hi) => dt.array(`${di}_${hi < 10 ? \"0\" + hi : hi}`))\n .flat()\n )\n .flat();\n const sample = ss.sample(fullValues, 200000);\n const breaks = ss.ckmeans(sample, 9).map((d) => ss.max(d));\n breaks[breaks.length - 1] = ss.max(fullValues);\n return breaks;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":695,"value":"### settings and functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":66,"value":"city = ({\n name: \"London\",\n center: [51.482, -0.0812],\n zoom: 11.1,\n pitch: 45\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"function parseDay(day) {\n switch (day) {\n case 0:\n return \"Monday\";\n case 1:\n return \"Tuesday\";\n case 2:\n return \"Wednesday\";\n case 3:\n return \"Thursday\";\n case 4:\n return \"Friday\";\n case 5:\n return \"Saturday\";\n case 6:\n return \"Sunday\";\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"async function getDataTable(file) {\n await init();\n const arrayBuffer = await file.arrayBuffer();\n const arr = new Uint8Array(arrayBuffer);\n const arrowIPC = readParquet(arr);\n const dt = aq.fromArrow(arrowIPC);\n return dt;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"readParquet = parquetWasm.readParquet","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"init = parquetWasm.default","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":697,"value":"### imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4,"value":"parquetWasm = import(\"https://cdn.jsdelivr.net/npm/parquet-wasm@0.1.1/web.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"import {\n tgmCoreClient,\n tgmNotice,\n targomoKey,\n tgmIntro,\n codeStyle\n} from \"@targomo/re-usable-targomo-resources\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"import { Scrubber as Scroober } from \"@mbostock/scrubber\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"h3 = require(\"h3-js@3.7\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"maplibre = {\n const gl = await require(\"maplibre-gl@2.4.0\");\n const href = await require.resolve(\"maplibre-gl@2.4.0/dist/maplibre-gl.css\");\n document.head.appendChild(html``);\n return gl;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"ss = require(\"simple-statistics\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"scaleCluster = require(\"d3-scale-cluster\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":465,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":704,"value":"### buttons and actions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":616,"value":"viewof friday18h = Inputs.button(\"Friday, 18h\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":571,"value":"viewof thursday18h = Inputs.button(\"Thursday, 18h\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":657,"value":"viewof monday6h = Inputs.button(\"Monday, 6h\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":660,"value":"viewof monday10h = Inputs.button(\"Monday, 10h\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":662,"value":"{\n if (monday6h > 0) viewof frame.update(\"0_06\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":664,"value":"{\n if (monday10h > 0) viewof frame.update(\"0_10\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":598,"value":"{\n if (thursday18h > 0) viewof frame.update(\"3_18\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":622,"value":"{\n if (friday18h > 0) viewof frame.update(\"4_18\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":700,"value":"### styles","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":39,"value":"codeStyle","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":676,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 33:"$32:body"