2f:null 30:["$","title",null,{"children":"Accessing aggregated mobile data sets from Open Data on AWS | OpenAQ | Observable"}] 35:T434,map = { const container = yield html`

`; const map = (container.value = new maplibregl.Map({ container, style: "https://basemaps.cartocdn.com/gl/voyager-gl-style/style.json", scrollZoom: true })); map.fitBounds(boundingBox,{ padding: {top: 50, bottom:50, left: 50, right: 50}, animate: false, }); let colorvalues = fc.features.length < 7 ? [-2, "#dddddd", min,'#fed976']: [ -2, "#dddddd", min,'#fed976', second, '#feb24c', lowerQuartile, '#fd8d3c', median, '#fc4e2a', upperQuartile, '#e31a1c', ninetyEighth, '#bd0026', max,'#800026', ] map.on("load", function () { map.addSource("measurements", { type: "geojson", data: fc }); map.addLayer({ id: "measurements", type: "circle", source: "measurements", paint: { "circle-color": [ 'interpolate', ['linear'], ['number', ['get', 'value']], ...colorvalues ] } }); }); }36:T2a69,locationDates = { const locationDates = {"61484": ["2017-12-22"], "61488": ["2019-10-31"], "61489": ["2013-11-25", "2013-12-02", "2013-12-04", "2013-12-05", "2013-12-11", "2013-12-12", "2013-12-13", "2013-12-16", "2013-12-19", "2013-12-20", "2013-12-27", "2014-01-15", "2014-01-16", "2014-01-17", "2014-01-20", "2014-01-27", "2014-01-28", "2014-01-30", "2014-01-31", "2014-02-06", "2014-02-07", "2014-02-08", "2014-02-10", "2014-02-11", "2014-02-12", "2014-02-14", "2014-02-19", "2014-02-20", "2014-03-04", "2014-03-05", "2014-03-06", "2014-03-07", "2014-03-10", "2014-03-11", "2014-03-12", "2014-03-13", "2014-03-17", "2014-03-18", "2014-03-19", "2014-03-20", "2014-03-21", "2014-03-24", "2014-03-25", "2014-03-27", "2014-03-28", "2014-03-31", "2014-04-01", "2014-04-03", "2014-04-07", "2014-04-10", "2014-04-11", "2014-04-14"], "61490": ["2015-02-12", "2015-03-17", "2015-03-28", "2015-04-03", "2015-05-03", "2015-05-07", "2015-05-08", "2015-05-09", "2015-05-11", "2015-05-13", "2015-05-18", "2015-05-19", "2015-05-22", "2015-05-27", "2015-05-28", "2015-05-29", "2015-06-01", "2015-06-03", "2015-06-05", "2015-06-09", "2015-06-11"], "61491": ["2014-08-28", "2014-09-04", "2014-09-05", "2014-09-08", "2014-09-11", "2014-09-17", "2014-09-18", "2014-09-19", "2014-09-23", "2014-09-24", "2014-09-25", "2014-09-26", "2014-09-29", "2014-09-30", "2014-10-02", "2014-10-06", "2014-10-07", "2014-10-08", "2014-10-09", "2014-10-10", "2014-10-13", "2014-10-14", "2014-10-22", "2014-10-23", "2014-10-27", "2014-10-28", "2014-10-29", "2014-10-30", "2014-11-03", "2014-11-04", "2014-11-05", "2014-11-06", "2014-11-07", "2014-11-10", "2014-11-11", "2014-11-26", "2014-12-01", "2014-12-05", "2014-12-18", "2014-12-19", "2014-12-23", "2014-12-24", "2014-12-27", "2014-12-28", "2014-12-29", "2015-01-02", "2015-01-07", "2015-01-08", "2015-01-09", "2015-01-12", "2015-01-13", "2015-01-14", "2015-01-15", "2015-01-16", "2015-01-19", "2015-01-20", "2015-01-21", "2015-01-22", "2015-01-23", "2015-01-26", "2015-01-27", "2015-01-31", "2015-02-02", "2015-02-11", "2015-02-13", "2015-02-16", "2015-03-04", "2015-03-06", "2015-03-13", "2015-03-14", "2015-03-19", "2015-03-20", "2015-03-22", "2015-03-23", "2015-03-25", "2015-03-28", "2015-03-30", "2015-03-31", "2015-04-02", "2015-04-03", "2015-04-06", "2015-04-08", "2015-04-10", "2015-04-13", "2015-04-14", "2015-04-15", "2015-04-16", "2015-04-17", "2015-04-20", "2015-04-22", "2015-04-23", "2015-04-25", "2015-04-27", "2015-04-29", "2015-04-30", "2015-05-04", "2015-05-05", "2015-05-06", "2015-05-10", "2015-05-11"], "61492": ["2016-04-26", "2016-04-29", "2016-05-26", "2016-05-27", "2016-06-01", "2016-06-02", "2016-07-19", "2016-07-20", "2016-07-25", "2016-07-26", "2016-07-27", "2016-07-28", "2016-07-29", "2016-08-01", "2016-08-04", "2016-08-05", "2016-08-08", "2016-08-09", "2016-08-10", "2016-08-11", "2016-08-12", "2016-08-15", "2016-08-16", "2016-08-17", "2016-08-18", "2016-09-27", "2016-09-28", "2016-09-29", "2016-10-03", "2016-10-04", "2016-10-05", "2016-10-06", "2016-10-07", "2016-10-11", "2016-10-12", "2016-10-13", "2016-10-17", "2016-10-18", "2016-10-19", "2016-10-20", "2016-10-24", "2016-10-25", "2016-11-08"], "61493": ["2015-05-20", "2015-05-22", "2015-05-26", "2015-05-27", "2015-05-28", "2015-05-29", "2015-06-03", "2015-06-04", "2015-06-08", "2015-06-09", "2015-06-10", "2015-06-12", "2015-06-18", "2015-06-19", "2015-06-22", "2015-06-25", "2015-06-26", "2015-06-29", "2015-06-30", "2015-07-01", "2015-07-24", "2015-07-27", "2015-07-29", "2015-07-30", "2015-07-31", "2015-08-04", "2015-08-05", "2015-08-12", "2015-08-13", "2015-08-14", "2015-09-25", "2015-09-28", "2015-09-29", "2015-09-30", "2015-10-01", "2015-10-05", "2015-10-06", "2015-10-07", "2015-10-08", "2015-10-09", "2015-10-12", "2015-10-13", "2015-10-14", "2015-10-15", "2015-10-16", "2015-10-19", "2015-10-21", "2015-10-27", "2015-11-02", "2015-11-06", "2015-11-12", "2015-11-16", "2015-11-17", "2015-11-18", "2015-11-23", "2015-11-24"], "61494": ["2013-03-07", "2013-03-11", "2013-03-12", "2013-03-13", "2013-03-14", "2013-03-15", "2013-03-18", "2013-03-19", "2013-03-20", "2013-03-22", "2013-03-25", "2013-03-26", "2013-03-27", "2013-03-28", "2013-03-29", "2013-04-01", "2013-04-02", "2013-04-04", "2013-04-05", "2013-04-08", "2013-04-09", "2013-04-11", "2013-04-15", "2013-04-16", "2013-04-17", "2013-04-18", "2013-04-22", "2013-04-23", "2013-04-24", "2013-04-25", "2013-04-26", "2013-04-29", "2013-04-30", "2013-05-01", "2013-05-02", "2013-05-03", "2013-05-06", "2013-05-07", "2013-05-08", "2013-05-09", "2013-05-10", "2013-05-13", "2013-05-14", "2013-05-15", "2013-05-16", "2013-05-20", "2013-05-21", "2013-05-23", "2013-05-24", "2013-05-28", "2013-05-29", "2013-05-30", "2013-05-31", "2013-06-03", "2013-06-04", "2013-06-05", "2013-06-06", "2013-06-07", "2013-06-10", "2013-06-11", "2013-06-12", "2013-06-13", "2013-06-14", "2013-06-17", "2013-06-18", "2013-06-19", "2013-06-20", "2013-06-21", "2013-06-24", "2013-06-25", "2013-06-26"], "61495": ["2014-09-16", "2014-09-17", "2014-09-18", "2014-09-19", "2014-09-22", "2014-09-24", "2014-09-25", "2014-09-26", "2014-09-29", "2014-10-01", "2014-10-06", "2014-10-07", "2014-10-08", "2014-10-09", "2014-10-10", "2014-10-17", "2014-10-20", "2014-10-22", "2014-10-23", "2014-10-24", "2014-10-27", "2014-10-28", "2014-11-03", "2014-11-08", "2014-12-10", "2014-12-11", "2014-12-12", "2014-12-14", "2014-12-15", "2014-12-16", "2014-12-17", "2014-12-18", "2014-12-19", "2014-12-22", "2014-12-23", "2014-12-26", "2014-12-27"], "61496": ["2016-04-04"], "61497": ["2013-06-13", "2013-06-20", "2013-06-27"], "61498": ["2014-12-11", "2014-12-13", "2014-12-31", "2015-01-16", "2015-01-17", "2015-01-28", "2015-01-29", "2015-02-03", "2015-02-04", "2015-03-18", "2015-03-25", "2015-03-26", "2015-04-01", "2015-04-08", "2015-04-10", "2015-04-16", "2015-04-17", "2015-04-18", "2015-04-22", "2015-04-23", "2015-12-03", "2015-12-22", "2015-12-23", "2015-12-26", "2015-12-30", "2016-01-02", "2016-01-03", "2016-01-04", "2016-01-05", "2016-01-06", "2016-01-07", "2016-01-08", "2016-01-11", "2016-01-12", "2016-01-13", "2016-01-14", "2016-01-17", "2016-01-18", "2016-01-19", "2016-01-20", "2016-01-22", "2016-01-24", "2016-01-25", "2016-01-26", "2016-01-27", "2016-01-28", "2016-01-29", "2016-02-02", "2016-02-03", "2016-02-04", "2016-02-05"], "61499": ["2017-05-01", "2017-05-02", "2017-05-03", "2017-05-16", "2017-05-17", "2017-05-18", "2017-05-19", "2017-05-23", "2017-05-24", "2017-05-30", "2017-05-31", "2017-06-01", "2017-06-02", "2017-06-03", "2017-06-05", "2017-06-07", "2017-06-08", "2017-06-09", "2017-06-10", "2017-06-12", "2017-06-13", "2017-06-14", "2017-06-15", "2017-06-16", "2017-06-19", "2017-06-20", "2017-06-21", "2017-06-23", "2017-06-27", "2017-06-28", "2017-06-29", "2017-06-30", "2017-07-01", "2017-07-03", "2017-07-05", "2017-07-06", "2017-07-08", "2017-07-09", "2017-07-10", "2017-07-12", "2017-07-13", "2017-07-15", "2017-07-17", "2017-07-19", "2017-07-20", "2017-07-21", "2017-07-25", "2017-07-26", "2017-07-27", "2017-07-28", "2017-07-31", "2017-08-01", "2017-08-02", "2017-08-03", "2017-08-04", "2017-08-08", "2017-08-09", "2017-08-10", "2017-08-11", "2017-08-13", "2017-08-14", "2017-08-16", "2017-08-17", "2017-08-19", "2017-08-21", "2017-08-23", "2017-08-24", "2017-08-25", "2017-08-28", "2017-08-29", "2017-08-30", "2017-08-31", "2017-09-05", "2017-09-07", "2017-09-08", "2017-09-11", "2017-09-12", "2017-09-13", "2017-09-14", "2017-09-15", "2017-09-20", "2017-09-21", "2017-09-24", "2017-09-25", "2017-09-26", "2017-09-28", "2017-09-29", "2017-10-02", "2017-10-03", "2017-10-04", "2017-10-05", "2017-10-06", "2017-10-10", "2017-10-11", "2017-10-12", "2017-10-13", "2017-10-16", "2017-10-17", "2017-10-18", "2017-10-19", "2017-10-20", "2017-10-23", "2017-10-27", "2017-11-01", "2017-11-02", "2017-11-03", "2017-11-07", "2017-11-08", "2017-11-09", "2017-11-10", "2017-11-14", "2017-11-15", "2017-11-16", "2017-11-17", "2017-11-21", "2017-11-22", "2017-11-28", "2017-11-29", "2017-11-30", "2018-04-17", "2018-04-18", "2018-04-23", "2018-04-26", "2018-05-02", "2018-05-03", "2018-05-04", "2018-05-07", "2018-05-08", "2018-05-09", "2018-05-14", "2018-05-15", "2018-05-18", "2018-05-21", "2018-05-23", "2018-05-24", "2018-05-25", "2018-05-29", "2018-05-30", "2018-06-01", "2018-06-04", "2018-06-05", "2018-06-06", "2018-06-07", "2018-06-11", "2018-06-12", "2018-06-14", "2018-06-15", "2018-06-18", "2018-06-19", "2018-06-20", "2018-08-27", "2018-08-28", "2018-08-30", "2018-09-12", "2018-09-14", "2018-09-19", "2018-09-20", "2018-09-21", "2018-09-26", "2018-10-04", "2018-10-09", "2018-10-17", "2018-10-18", "2018-10-29", "2018-10-30", "2018-10-31", "2018-11-01", "2018-11-07", "2018-11-08", "2018-11-09", "2018-11-12", "2018-11-14", "2018-11-15", "2018-11-16", "2018-11-19", "2018-11-20", "2018-11-21", "2018-11-23", "2018-11-26"], "61500": ["2015-06-26", "2015-06-29", "2015-07-01", "2015-07-24", "2015-07-27", "2015-07-28", "2015-07-29", "2015-07-30", "2015-08-03", "2015-08-04", "2015-08-05", "2015-08-06", "2015-08-07", "2015-08-10", "2015-08-12", "2015-08-13", "2015-08-25", "2015-08-26", "2015-08-27", "2015-11-29", "2015-12-03", "2015-12-04", "2015-12-06", "2015-12-08", "2015-12-09", "2015-12-10", "2015-12-11", "2015-12-13", "2015-12-14", "2015-12-15", "2015-12-16", "2015-12-18", "2015-12-20", "2015-12-21", "2015-12-22", "2015-12-23", "2015-12-30", "2016-01-03", "2016-01-04", "2016-01-05", "2016-01-06", "2016-01-07", "2016-01-08", "2016-04-06", "2016-04-12"], "61501": ["2014-09-29", "2014-10-02", "2014-10-09", "2014-10-10", "2014-10-15"], "61502": ["2016-04-20", "2016-04-21", "2016-04-25", "2016-04-28", "2016-05-02", "2016-05-05", "2016-05-09", "2016-05-10", "2016-05-16", "2016-05-17", "2016-05-18", "2016-05-19", "2016-05-23", "2016-05-26", "2016-05-27", "2016-05-31", "2016-06-01", "2016-06-02", "2016-06-06", "2016-11-02", "2016-11-07", "2016-11-08", "2016-11-10", "2016-11-21", "2016-11-22", "2016-11-23", "2016-11-28", "2016-12-01", "2016-12-02", "2016-12-06", "2016-12-08", "2016-12-13", "2016-12-14", "2016-12-15", "2016-12-22"], "61503": ["2014-04-28", "2014-05-01", "2014-05-02", "2014-05-07", "2014-05-14", "2014-05-15", "2014-05-20", "2014-05-21", "2014-05-27", "2014-05-29", "2014-05-30", "2014-06-02", "2014-06-04", "2014-06-05", "2014-06-06", "2014-06-09", "2014-06-10", "2014-06-16", "2014-06-17", "2014-06-19", "2014-06-20", "2014-06-23", "2014-06-26", "2014-06-27", "2014-07-18", "2014-07-21", "2014-07-22", "2014-07-23", "2014-07-24", "2014-07-25", "2014-07-29", "2014-07-30", "2014-07-31"], "61504": ["2017-03-14", "2017-03-15", "2017-03-20", "2017-03-21", "2017-03-22", "2017-03-23", "2017-03-24", "2017-03-27", "2017-03-28", "2017-03-29", "2017-03-30", "2017-04-06", "2017-04-08", "2017-04-10", "2017-04-12", "2017-04-24", "2017-04-25", "2017-04-26", "2017-04-28", "2017-05-01", "2017-05-03"], "61509": ["2018-03-31"]} return locationDates }37:[] 33:{"id":"5867ddcf2ac7bfb5","slug":"accessing-aggregated-mobile-data-sets-from-open-data-on-aws","title":"Accessing aggregated mobile data sets from Open Data on AWS","thumbnail":"5672e1603c9163c8b894c57a8d40408a517f9b914e61dd0713274f571994ff7d","access_level":"public","create_time":"$D2023-11-17T17:34:21.409Z","update_time":"$D2023-11-20T15:11:58.392Z","view_time":null,"first_public_time":"$D2023-11-20T15:20:54.355Z","has_unpublished_edits":null,"fork":{"id":"4f4bfe29d2ca3194","slug":"openaq-open-data-on-aws","title":"OpenAQ Direct File Access from Open Data on AWS","owner":{"id":"1f8b49ddb281b956","login":"openaq","name":"OpenAQ"}},"stars":0,"starred":false,"owner":{"type":"team","id":"1f8b49ddb281b956","login":"openaq","name":"OpenAQ","avatar_url":"https://avatars-next.observableusercontent.com/74972890073630f6e976308e735e7c4300d84027710faa3b49c2e9c36a176e6e","tier":"starter_2024"},"version":825,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"a7bdcb7339765e3b","login":"openaq-russ","name":"","avatar_url":"https://avatars-next.observableusercontent.com/727b8f8d1b7a836462f95d96575087e82375b2f4be54d612b43806496b5ab102","tier":null}],"members":[{"type":"individual","id":"a7bdcb7339765e3b","login":"openaq-russ","name":"","avatar_url":"https://avatars-next.observableusercontent.com/727b8f8d1b7a836462f95d96575087e82375b2f4be54d612b43806496b5ab102","tier":null,"role":"editor"},{"type":"team","id":"1f8b49ddb281b956","login":"openaq","name":"OpenAQ","avatar_url":"https://avatars-next.observableusercontent.com/74972890073630f6e976308e735e7c4300d84027710faa3b49c2e9c36a176e6e","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Accessing aggregated mobile data sets from Open Data on AWS","cells":[{"id":0,"value":"# Accessing aggregated mobile data sets from Open Data on AWS","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":97,"value":"

ℹ️

This notebook picks up from our introductory notebook, [OpenAQ Direct File Access from Open Data on AWS](https://observablehq.com/@openaq/openaq-open-data-on-aws), which provides an overview of how files are organized in the Open Data on AWS bucket. If you have not read that notebook we recommend reading through that first to gain a general understand of the bucket.

\n\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":601,"value":"The aggregated mobile datasets available on OpenAQ are available from the following location IDs:\n\n| locations ID | Name |\n| ----------- | ----------- |\n| 61484 | Bay Area mobile analysis |\n| 61488 | London mobile analysis |\n| 61489 | Staten Island methane |\n| 61490 | Jacksonville methane |\n| 61491 | Los Angeles methane |\n| 61492 | New York methane |\n| 61493 | New Jersey methane |\n| 61494 | Boston methane |\n| 61495 | Chicago methane |\n| 61496 | Mesa methane |\n| 61497 | Indianapolis methane |\n| 61498 | Dallas methane |\n| 61499 | Long Island methane |\n| 61500 | Pittsburgh methane |\n| 61501 | Burlington methane |\n| 61502 | Elizabethtown methane |\n| 61503 | Syracuse methane |\n| 61504 | Birmingham methane |\n| 61509 | Houston mobile analysis |\n\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":599,"value":"## Choose a location","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":610,"value":"viewof locationId = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":100,"value":"## Choose a date","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":816,"value":"The mobile projects collected data on select days. Select the date from the dropdown to view the data for that day. Data from these mobile data sets are aggregate to the day and so all measurements share the same timestamp, which is not intended to represent the exact time of measurement, only the day in which the project ran.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":761,"value":"viewof date = html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"For this date: ${date1.getUTCFullYear()}-${monthPad}-${date1.getUTCDate()}, we will look in the __year=${date1.getUTCFullYear()}__ directory and __month=${monthPad}__ directory","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":540,"value":"Finally, the file is named in the format ```location-{location ID}-{year}{month}{day}.csv.gz``` or in this example ```location-${locationId}-${formatDate(date1)}.csv.gz```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":240,"value":"The URL for this file will be: ${url}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":233,"value":"This file includes the measurements for all parameters supported by the location. In the table below we can view the contents of the csv:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":230,"value":"Inputs.table(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":329,"value":"## Map view\n\nUnlike most data on OpenAQ these mobile projects do not have unique timestamps, so we cannot chart across time. Instead we can visualize on a map to show that values across space. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":662,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":500,"value":"To learn more about how to query data from the OpenAQ Open Data on AWS bucket read more at [https://docs.openaq.org](https://docs.openaq.org). If you have any questions or want to connect with others join our [Slack community](https://join.slack.com/t/openaq/shared_invite/zt-yzqlgsva-v6McumTjy2BZnegIK9XCVw)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":823,"value":"_N.B: The color values on the map are not intended to be interpreted with any analytical value. The color values are only provided to assist in visualizing the data._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":673,"value":"min = d3.min(series.map(o => o.value)) < 0 ? -1 : d3.min(series.map(o => o.value)) - 0.0001","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":733,"value":"second = d3.quantile(series.map(o => o.value), 0.02)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":725,"value":"lowerQuartile = d3.quantile(series.map(o => o.value), 0.25)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":718,"value":"median = d3.median(series.map(o => o.value))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":728,"value":"upperQuartile = d3.quantile(series.map(o => o.value), 0.75)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":731,"value":"ninetyEighth = d3.quantile(series.map(o => o.value), 0.98)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":693,"value":"max = d3.max(series.map(o => o.value))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":632,"value":"boundingBox = turf.bbox(fc)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":638,"value":"fc = turf.featureCollection(features)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":749,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":634,"value":"features = series.map(o => { return {\n \"type\": \"Feature\",\n \"properties\": { \"locationsId\": o.location_id, \"value\": o.value},\n \"geometry\": {\n \"coordinates\": [\n o.lon,\n o.lat\n ],\n \"type\": \"Point\"\n }\n }})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":223,"value":"series = data.map(o => {o.date = new Date(o.datetime); o.value = parseFloat(o.value); return o})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":320,"value":"parameters = [...new Set(data.map(x => x.parameter))].filter(e => e != null);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"data.map(o => {o.date = new Date(o.datetime); o.value = parseFloat(o.value); return o}).filter(o => o.measurand == \"o3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"data = {\n const bytes = new Uint8Array(await res.arrayBuffer());\n const text = new TextDecoder().decode(gunzip(bytes));\n return parseCsv(text);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"parseCsv = value => {\n const rows = value.split('\\n').map(o => o.split(','));\n rows.pop();\n const columns = rows.shift();\n let data = [];\n for (const row of rows) {\n let record = {}\n for (let i = 0; i < row.length; i++) {\n record[columns[i]] = row[i]\n } \n data.push(record);\n }\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"res = await fetch(url);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":464,"value":"url = `https://openaq-data-archive.s3.amazonaws.com/records/csv.gz/locationid%3D${locationId}/year%3D${date1.getUTCFullYear() }/month%3D${monthPad}/location-${locationId}-${formatDate(date1)}.csv.gz`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":544,"value":"monthPad = month.toString().padStart(2,\"0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":477,"value":"month = date1.getUTCMonth() + 1","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":619,"value":"inflateWasm.mem.grow(512); ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"import {inflateWasm,gunzip} from \"@mourner/wasm-gunzip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":630,"value":"turf = require(\"@turf/turf@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":770,"value":"date1 = new Date(date)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":642,"value":"maplibregl = require(\"maplibre-gl@2.1.9\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"function formatDate(date) {\n return [\n (date.getFullYear()).toString().padStart(4, \"0\"),\n (date.getMonth() + 1).toString().padStart(2, \"0\"),\n (date.getDate() + 1).toString().padStart(2, \"0\")\n ].join(\"\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":559,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":485,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W37","stdlib":"1","titling":"auto"}} 34:"$33:body"