2b:null 2c:["$","title",null,{"children":"Calendario de Calidad de Aire - PoluSens | juancortiz | Observable"}] 31:T1121,chart = { const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height * years.length]) .attr("font-family", "sans-serif") .attr("font-size", 10); const year = svg.selectAll("g") .data(years) .join("g") .attr("transform", function(d,i){ if(type == "calendar"){ return `translate(40.5,${height * i + cellSize * 1.5})` } else { return `translate(40.5,${height * i + cellSize * 8})` } }) .attr("id",d => d[0]) year.append("text") .attr("x", -5) .attr("y", -5) .attr("font-weight", "bold") .attr("text-anchor", "end") .text(([key]) => key); year.append("g") .attr("text-anchor", "end") .selectAll("text") .data((weekday === "weekday" ? d3.range(2, 7) : d3.range(7)).map(i => new Date(1995, 0, i))) .join("text") .attr("x", -5) .attr("y", d => (countDay(d) + 0.5) * cellSize) .attr("dy", "0.31em") .text((type === "calendar" ? formatDay : "")) year.append("g") .selectAll("rect") .data(weekday === "weekday" ? ([, values]) => values.filter(d => ![0, 6].includes(d.date.getUTCDay())) : ([, values]) => values) .enter().append("rect") .attr("width", function(d,i){ if(type == "calendar"){ return cellSize - 1 } else { return 1.7 } }) .attr("height", function(d){ if(type == "calendar"){ return cellSize - 1 } else { return d.value * (125/max) } }) .attr("x", function(d,i){ if(type == "calendar"){ return timeWeek.count(d3.utcYear(d.date), d.date) * cellSize + 0.5 } else { return i * 2.2 } }) .attr("y", function(d){ if(type == "calendar"){ return countDay(d.date) * cellSize + 0.5 } else { return d.value * -(125/max) } }) // .attr("fill", "#eee") .attr("fill", d => color(d.value)) .on("mouseover", d => getDays(d)) // .transition().duration(1000) // .attr("fill", d => color(d.value)) const month = year.append("g") .selectAll("g") .data(([, values]) => d3.utcMonths(d3.utcMonth(values[0].date), values[values.length - 1].date)) .join("g"); month.filter((d, i) => i).append("path") .attr("fill", "none") .attr("stroke", "#fff") .attr("stroke-width", 3) .attr("d", pathMonth); month.append("text") .attr("x", d => timeWeek.count(d3.utcYear(d), timeWeek.ceil(d)) * cellSize + 2) .attr("y", -5) .text(formatMonth); const day_2018 = svg.append("rect") .attr("width", cellSize - 1) .attr("height", cellSize - 1) .attr("x",-100) .attr("stroke", "#000") .attr("stroke-width", 2) .attr("fill", "none") const day_2019 = svg.append("rect") .attr("width", cellSize - 1) .attr("height", cellSize - 1) .attr("x",-100) .attr("stroke", "#000") .attr("stroke-width", 2) .attr("fill", "none") const day_2020 = svg.append("rect") .attr("width", cellSize - 1) .attr("height", cellSize - 1) .attr("x",-100) .attr("stroke", "#000") .attr("stroke-width", 2) .attr("fill", "none") function getDays(d){ var date = d.date, value = d.value if(type === "calendar"){ day_2018.attr("x", 40.5+(timeWeek.count(d3.utcYear(date), date) * cellSize + 0.5)) day_2018.attr("y", (height * 2 + cellSize * 1.5)+countDay(date) * cellSize + 0.5) day_2019.attr("x", 40.5+(timeWeek.count(d3.utcYear(date), date) * cellSize + 0.5)) day_2019.attr("y", (height * 1 + cellSize * 1.5)+countDay(date) * cellSize + 0.5) day_2020.attr("x", 40.5+(timeWeek.count(d3.utcYear(date), date) * cellSize + 0.5)) day_2020.attr("y", (height * 0 + cellSize * 1.5)+countDay(date) * cellSize + 0.5) } else { day_2018.attr("x", -100) day_2019.attr("x", -100) day_2020.attr("x", -100) } } // function updateBar(){ // //Update all rects // //console.log("update") // svg.selectAll("rect") // .data(data) // .transition() // .duration(2000) // .attr("fill", d => color(d.value)) // } // updateBar() return svg.node(); }32:[] 2f:{"id":"08ebcdb142457bed","slug":null,"title":"Calendario de Calidad de Aire - PoluSens","thumbnail":"e4023fec8a5fabc33f7c14393f6d8b86108778af8473c094f1bd95f64d414cda","access_level":"public","create_time":"$D2021-03-27T21:53:20.197Z","update_time":"$D2026-09-09T15:35:41.924Z","view_time":null,"first_public_time":"$D2021-03-28T01:29:21.979Z","has_unpublished_edits":null,"fork":{"id":"882dc51fe9df6f10","slug":"calendar-heatmap","title":"Calendar Heatmap","owner":{"id":"0a1b645245b71da7","login":"two-n","name":"TWO-N"}},"stars":1,"starred":false,"owner":{"type":"team","id":"cb229b373d89c41a","login":"juancortiz","name":"","avatar_url":"https://avatars-next.observableusercontent.com/240f3730193b9937c72b5def193cc06eb4a83f5e767700626996d804489367b0","tier":"starter_2024"},"version":573,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"bfeab4b26b603f6e","login":"juancortiz","name":"","avatar_url":"https://avatars-next.observableusercontent.com/240f3730193b9937c72b5def193cc06eb4a83f5e767700626996d804489367b0","tier":null}],"members":[{"type":"individual","id":"bfeab4b26b603f6e","login":"juancortiz","name":"","avatar_url":"https://avatars-next.observableusercontent.com/240f3730193b9937c72b5def193cc06eb4a83f5e767700626996d804489367b0","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Calendario de Calidad de Aire - PoluSens","cells":[{"id":0,"value":"md`# Calendario de Calidad de Aire - PoluSens`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":543,"value":"viewof red = Select(new Map(redes.map(d => [d.nombre_red, d.id_red])), {value: 'racimo_bmanga', label: null, sort: true, unique: true}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":447,"value":"viewof estacion = Select(new Map(estaciones.map(d => [d.nombre_estacion, d.id_estacion])), {value: 'clg_santander', label: null, sort: true, unique: true}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"viewof metric = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"key = legend({color, title: metric, tickFormat: \".0f\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":252,"value":"viewof type = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"viewof weekday = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"color = {\n const max = d3.quantile(data.map(d => Math.abs(d.value)).sort(d3.ascending), 0.9975);\n const min = d3.min(data, d => d.value)\n //const max = d3.max(data, d => d.value)\n return d3.scaleSequential(d3.interpolatePlasma).domain([max, min]);\n //return d3.scaleSequential(d3.interpolateYlOrRd).domain([min, max]);\n //return d3.scaleQuantile().domain([min, max]).range([\"green\", \"yellow\", \"red\"])\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"years = d3.groups(data, d => d.date.getUTCFullYear()).reverse()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"cellSize = 15","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"width = 1000","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"height = 150","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"timeWeek = weekday === \"sunday\" ? d3.utcSunday : d3.utcMonday","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"countDay = weekday === \"sunday\" ? d => d.getUTCDay() : d => (d.getUTCDay() + 6) % 7","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"function pathMonth(t) {\n const n = weekday === \"weekday\" ? 5 : 7;\n const d = Math.max(0, Math.min(n, countDay(t)));\n const w = timeWeek.count(d3.utcYear(t), t);\n return `${d === 0 ? `M${w * cellSize},0`\n : d === n ? `M${(w + 1) * cellSize},0`\n : `M${(w + 1) * cellSize},0V${d * cellSize}H${w * cellSize}`}V${n * cellSize}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"formatDate = d3.utcFormat(\"%x\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"formatDay = d => \"DLMXJVS\"[d.getUTCDay()]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"formatMonth = d3.utcFormat(\"%b\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"formatValue = d3.format(\"+.2%\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":538,"value":"redes = d3.json(\"https://racimo-api.mpsig.com/racimohub/v110prod/redes\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":442,"value":"estaciones = d3.json(\"https://racimo-api.mpsig.com/racimohub/v110prod/estaciones?filtro=id_red=\"+red)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":343,"value":"estMediciones = d3.json(\"https://racimo-api.mpsig.com/racimohub/v110prod/mediciones/\"+estacion+\"/pm25_a,pm10_a,t,h,p/2020-01-01/2025-12-31?mt=d\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":474,"value":"mediciones = estMediciones[0].mediciones","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"allData = {\n var med_arr = sql(\"select fecha_hora_med as fecha, id_parametro, [valor] from ? pivot ( max(valor) for id_parametro ) order by fecha asc\", [mediciones]);\n return med_arr; \n}\n ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"// allData____ = Object.assign(d3.csvParse(await FileAttachment(\"duration.csv\").text(), d3.autoType))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"// allData.columns","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"data = {\n var arr = []\n allData.forEach(function(d){ \n arr.push({date: new Date(d.fecha), value:Math.round( d[metric] )})\n })\n //chart.updateBar()\n return arr\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"max = d3.max(data, d => d.value)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"d3 = require(\"d3@5\", \"d3-array@2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"import {legend} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"moment = require('moment')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"sql = require(\"alasql\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":492,"value":"sql.options.cache = false","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":390,"value":"sql.fn.dia = function(d){return d.substring(0, 10)}; ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":444,"value":"import {Select} from \"@observablehq/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1"}} 30:"$2f:body"