3e:null 3f:["$","title",null,{"children":"SISAM - Heatmap - Embed | Renato Mauro | Observable"}] 45:T28b0,vis= { //const slider=slider_snap(0,1046) const marginLeft=20, innerWidth=width-marginLeft, marginBottom=40, marginTop=20, vLineSize=20 const svg = d3.select(DOM.svg(width, height+marginBottom+marginTop+height/13)) let border=new Set() svg.append("defs") .append("pattern") .attr("id","hachura") .attr("patternUnits","userSpaceOnUse") .attr("width",4) .attr("height",10) .attr("patternTransform","rotate(60)") .append("line") .attr("x1","0") .attr("y1","0") .attr("x2","0") .attr("y2","10") .style("stroke","gray") .style("stroke-opacity",0.5) .style("stroke-width",3) arrowDefs(svg) //células let squares= svg.selectAll("rect") .data(data) .join("rect") .attr("x", d => marginLeft+(d.ano-anoinicial)*innerWidth/(anofinal-anoinicial+1)+(d.semana-1)%4*(innerWidth/(anofinal-anoinicial+1))/4) .attr("y", d => marginTop+~~((d.semana-1)/4)*height/13) .attr("width", (innerWidth/(anofinal-anoinicial+1))/4) .attr("height", height/13) .attr("stroke","gray") .attr("stroke-width",1.5) .attr("stroke-opacity",0.5) .attr("fill",d => color(d.valor,d.temperatura_c_media)) .attr("opacity",d=>d.ano==2019&&d.semana>11?0.5:1) .on("click",e=>{ e.stopPropagation() //nao selecionar semana que esteja a menos de 42 semanas do fim do grafico if (d3.select(e.target).data()[0].ano==2019&&d3.select(e.target).data()[0].semana>11) return //seleciona nova célula se for diferente da já selecionada let dadoSel=d3.select(e.target).data()[0], semanaSel=semanas_epidemiologicas.find(d=>d.ano==dadoSel.ano&&d.semana==dadoSel.semana), storage={inicio:semanaSel.inicio,termino:semanaSel.termino,uf:UF,municipio:municipio} //if (JSON.stringify(storage)!=window.localStorage.getItem("gridSelection")){ if (JSON.stringify(storage)!=JSON.stringify(mutable selectionHeatmap)){ //limpa seleção svg.selectAll("rect").transition("a").attr("stroke-width",1.5).attr("stroke","gray").attr("stroke-opacity",0.5) lines.raise() d3.select(e.target).raise() d3.select(e.target).transition("c").attr("stroke-width",3).attr("stroke","black").attr("stroke-opacity",1) //draw outline border=new Set() let idxInicio=semanas_epidemiologicas.indexOf(semanaSel), idxFim=idxInicio+41 for (let i=idxInicio;i<=idxFim;i++) addOutline(border,squares .filter(d=>d.ano==semanas_epidemiologicas[i].ano&&d.semana==semanas_epidemiologicas[i].semana)) svg.select("#outline").remove() let outline=svg.append("g").attr("id","outline") for (let l of border){ l=JSON.parse(l) outline.append("line").attr("class","outline").attr("x1",l.x1).attr("x2",l.x2).attr("y1",l.y1).attr("y2",l.y2) .attr("stroke","#151472") .attr("stroke-width",3) } // //window.localStorage.setItem("gridSelection",JSON.stringify(storage)) mutable selectionHeatmap=JSON.parse(JSON.stringify(storage)) //chama atualização do slider disp.call("atualiza_slider",this,{ano:dadoSel.ano,semana:dadoSel.semana}) let squareSel=squares.filter(d=>d.ano==semanaSel.ano&&d.semana==semanaSel.semana), xSel=+squareSel.attr("x")+innerWidth/(20*4*2) vLine.transition() .attr("x1",xSel) .attr("x2",xSel) .attr("y2",squareSel.attr("y")) vLine.raise() let delta=(semanaSel.ano<2010)?vLineSize:0 vLine2.transition() .attr("x1",xSel-vLineSize+delta) .attr("x2",xSel+delta) textoData.transition() .attr("x",xSel-vLineSize+delta*2.5) .attr("text-anchor",delta?"start":"end") .text(semanaSel.inicio.toDateString()+" to "+semanaSel.termino.toDateString()) vLineBottom.transition() .attr("x1",xSel) .attr("x2",xSel) .attr("y2",+squareSel.attr("y")+height/13) vLineBottom.raise() let idxSemana=semanas_epidemiologicas.indexOf(semanaSel) vLineBottom2.transition() .attr("x1",xSel) .attr("x2",xBarra(idxSemana)+marginLeft) vLineBottom3.transition() .attr("x1",xBarra(idxSemana)+marginLeft) .attr("x2",xBarra(idxSemana)+marginLeft) mutable numeroSemanaSel=semanas_epidemiologicas.indexOf(semanaSel) } }) squares .append('title') .text(d => `${t("ANO")}: ${d.ano}\n${t("SEMANA")}: ${d.semana}\n${t("VALOR")}: ${d.valor.toFixed(2)}`) //legenda X svg.append("g").selectAll("text") .data(d3.range(anoinicial,anofinal+1)) .join("text") .attr("font-family","sans-serif") .attr("font-size",12) .attr("x",d=>marginLeft+(d-anoinicial)*innerWidth/(anofinal-anoinicial+1)+(innerWidth/(anofinal-anoinicial+1))/2) .attr("y",marginTop+height+height/13+2) .attr("text-anchor","middle") .attr("alignment-baseline","hanging") .style("user-select","none") .text(d=>d) //legenda y svg.append("g").selectAll("text") .data(d3.range(1,13,11)) .join("text") .attr("font-family","sans-serif") .attr("font-size",11) .attr("x",0) .attr("y",d=>marginTop+(d-1)*height/12+(height/12)/2+2) .attr("alignment-baseline","middle") .style("user-select","none") .text(d=>t(meses[d-1])) //linhas divisórias dos anos let lines= svg.append("g") lines.selectAll("line") .data(d3.range(anoinicial+1,anofinal+1)) .join("line") .attr("x1",d=>marginLeft+(d-anoinicial)*innerWidth/(anofinal-anoinicial+1)) .attr("y1",marginTop) .attr("x2",d=>marginLeft+(d-anoinicial)*innerWidth/(anofinal-anoinicial+1)) .attr("y2",marginTop+height+height/13) .attr("stroke","black") .attr("stroke-width",1.5) //pontilhados let vLine=svg.append("line") .attr("x1",0) .attr("x2",0) .attr("y1",marginTop/2) .attr("y2",height/2) .attr("stroke",paleta[4]) .attr("stroke-width",3) .attr("stroke-dasharray",3) let vLine2=svg.append("line") .attr("x1",-20) .attr("x2",0) .attr("y1",marginTop/2) .attr("y2",marginTop/2) .attr("stroke",paleta[4]) .attr("stroke-width",3) .attr("stroke-dasharray",3) let textoData=svg.append("text") .attr("x",-20) .attr("y",marginTop/2) .attr("dx",-5) .attr("alignment-baseline","middle") .attr("text-anchor","end") .attr("font-size",10) .style("user-select","none") let vLineBottom=svg.append("line") .attr("x1",0) .attr("x2",0) .attr("y1",height+marginBottom+marginTop-10) .attr("y2",height/2) .attr("stroke",paleta[4]) .attr("stroke-width",3) .attr("stroke-dasharray",3) let vLineBottom2=svg.append("line") .attr("x1",-20) .attr("x2",0) .attr("y1",height+marginBottom+marginTop-10) .attr("y2",height+marginBottom+marginTop-10) .attr("stroke",paleta[4]) .attr("stroke-width",3) .attr("stroke-dasharray",3) let vLineBottom3=svg.append("line") .attr("x1",-20) .attr("x2",-20) .attr("y1",height+marginBottom+marginTop-10) .attr("y2",height+marginBottom+marginTop+height/13) .attr("stroke",paleta[4]) .attr("stroke-width",3) .attr("stroke-dasharray",3) .attr("marker-end", "url(#pointer-heatmap)") //window.localStorage.removeItem("gridSelection") //limpa storage ao carregar pela primeira vez let e = document.createEvent('UIEvents') e.initUIEvent('click', true, true, /* ... */) squares.filter(d=>d.ano==2015&&d.semana==26).node().dispatchEvent(e) //chamada ao mover slider disp.on("atualiza_heatmap",param=>{ let semanaSel=semanas_epidemiologicas[param[0]], storage={inicio:semanaSel.inicio,termino:semanaSel.termino,uf:UF,municipio:municipio} //if (JSON.stringify(storage)!=window.localStorage.getItem("gridSelection")){ if (JSON.stringify(storage)!=JSON.stringify(mutable selectionHeatmap)){ svg.selectAll("rect").transition("a").attr("stroke-width",1.5).attr("stroke","gray").attr("stroke-opacity",0.5) lines.raise() let squareSel=squares.filter(d=>d.ano==semanaSel.ano&&d.semana==semanaSel.semana) squareSel.raise() squareSel.transition("c").attr("stroke-width",3).attr("stroke","black").attr("stroke-opacity",1) //draw outline border=new Set() let idxInicio=param[0], idxFim=idxInicio+41 for (let i=idxInicio;i<=idxFim;i++) addOutline(border,squares .filter(d=>d.ano==semanas_epidemiologicas[i].ano&&d.semana==semanas_epidemiologicas[i].semana)) svg.select("#outline").remove() let outline=svg.append("g").attr("id","outline") for (let l of border){ l=JSON.parse(l) outline.append("line").attr("class","outline").attr("x1",l.x1).attr("x2",l.x2).attr("y1",l.y1).attr("y2",l.y2) .attr("stroke","#151472") .attr("stroke-width",3) } // //window.localStorage.setItem("gridSelection",JSON.stringify(storage)) mutable selectionHeatmap=JSON.parse(JSON.stringify(storage)) let xSel=+squareSel.attr("x")+innerWidth/(20*4*2) vLine.transition() .attr("x1",xSel) .attr("x2",xSel) .attr("y2",squareSel.attr("y")) vLine.raise() let delta=(semanaSel.ano<2010)?vLineSize:0 vLine2.transition() .attr("x1",xSel-vLineSize+delta) .attr("x2",xSel+delta) textoData.transition() .attr("x",xSel-vLineSize+delta*2.5) .attr("text-anchor",delta?"start":"end") .text(semanaSel.inicio.toDateString()+" to "+semanaSel.termino.toDateString()) vLineBottom.transition() .attr("x1",xSel) .attr("x2",xSel) .attr("y2",+squareSel.attr("y")+height/13) vLineBottom.raise() vLineBottom2.transition() .attr("x1",xSel) .attr("x2",xBarra(param[0])+marginLeft) vLineBottom3.transition() .attr("x1",xBarra(param[0])+marginLeft) .attr("x2",xBarra(param[0])+marginLeft) mutable numeroSemanaSel=semanas_epidemiologicas.indexOf(semanaSel) } }) //mutable display=svg.node() return svg.node() //return html`

${svg.node()}${slider}

` }46:T473,function addOutline (border, square) { let x=+square.attr("x"), y=+square.attr("y"), width=+square.attr("width"), height=+square.attr("height"), top=JSON.stringify({x1:x, x2:x+width, y1:y, y2:y}), left=JSON.stringify({x1:x, x2:x, y1:y, y2:y+height}), bottom=JSON.stringify({x1:x, x2:x+width, y1:y+height, y2:y+height}), right=JSON.stringify({x1:x+width, x2:x+width, y1:y, y2:y+height}) if (setFind(border,top)!=-1) border.delete(setFind(border,top)) else border.add(top) if (setFind(border,left)!=-1) border.delete(setFind(border,left)) else border.add(left) if (setFind(border,bottom)!=-1) border.delete(setFind(border,bottom)) else border.add(bottom) if (setFind(border,right)!=-1) border.delete(setFind(border,right)) else border.add(right) }47:T446,color = (valor,temperatura) => { if (!valor) return "url(#hachura)" switch (indicador){ case "pm25_ugm3": case "so2_ugm3": return padroes[indicador].findIndex(d=>d>valor)!=-1?paleta[padroes[indicador].findIndex(d=>d>valor)]:paleta[4] //return paleta.at(padroes[indicador].findIndex(d=>d>valor)) case "no2_ppb": case "o3_ppb": let fator=massa_mol[indicador]/volume_mol(temperatura) return padroes[indicador].findIndex(d=>d>valor*fator)!=-1?paleta[padroes[indicador].findIndex(d=>d>valor*fator)]:paleta[4] //return paleta.at(padroes[indicador].findIndex(d=>d>valor*fator)) case "co_ppb": if (valor/1000d.valor) if (valor{ let dict={} resp.columns.map(d=>d.name).forEach((column,i)=>{ dict[column]=row[i] }) if (dict.anoanofinal) //faz recorte de anos return //convert to epidemiological week let date=new Date(Date.UTC(dict.ano,dict.mes-1,dict.dia)) //utc month starts at 0 for (let i of semanas_epidemiologicas) { if (date>=new Date(i.inicio)&&date<=new Date(i.termino)){ dict["semana"]=+i.semana break } } if (dict.mes==1&&dict.semana==53){ dict.ano-=1 dict.mes=12 } ret.push(dict) }) //grouping by ano and semana let ret2=[] for (let i of ret){ let f=ret2.find(d=>d.ano==i.ano&&d.semana==i.semana) if (f){ f.valor+=i.valor //if (f.valor{d.valor/=d.cont; d.temperatura_c_media/=d.cont; delete d.cont; return d;}).filter(d=>d.semana) //ret2=ret2.map(d=>{d.temperatura_c_media/=d.cont; delete d.cont; return d;}).filter(d=>d.semana) return ret2 }49:T49f,//data={ let ret=[] resp.forEach(dict=>{ if (dict.anoanofinal) //faz recorte de anos return //convert to epidemiological week let date=new Date(Date.UTC(dict.ano,dict.mes-1,dict.dia)) //utc month starts at 0 for (let i of semanas_epidemiologicas) { if (date>=new Date(i.inicio)&&date<=new Date(i.termino)){ dict["semana"]=+i.semana break } } if (dict.mes==1&&dict.semana==53){ dict.ano-=1 dict.mes=12 } ret.push(dict) }) //grouping by ano and semana let ret2=[] for (let i of ret){ let f=ret2.find(d=>d.ano==i.ano&&d.semana==i.semana) if (f){ f.valor+=i.valor //if (f.valor{d.valor/=d.cont; d.temperatura_c_media/=d.cont; delete d.cont; return d;}).filter(d=>d.semana) //ret2=ret2.map(d=>{d.temperatura_c_media/=d.cont; delete d.cont; return d;}).filter(d=>d.semana) return ret2 }4a:Td02,//inspired by https://observablehq.com/@sarah37/snapping-range-slider-with-d3-brush slider_snap = function(min, max) { var range = [min, max] // set width and height of svg var w = slider_width var h = 30 var margin = {top: 0, bottom: 0, left: slider_left_margin, right: 0} // dimensions of slider bar var innerwidth = w - margin.left - margin.right; var height = h - margin.top - margin.bottom; // create x scale var x = d3_5.scaleLinear() .domain(range) // data space .range([0, innerwidth]); // display space let nasc_x = d3_5.scaleLinear().domain([d3_5.min(nasc_data.map(d=>d.data_nasc)),d3_5.max(nasc_data.map(d=>d.data_nasc))]).range([0,innerwidth]); let nasc_y = d3_5.scaleLinear().domain([0,d3_5.max(nasc_data.map(d=>d.TOTAL))]).range([height,0]); let nasc_line = d3.line().x(d=>nasc_x(d.data_nasc)+margin.left).y(d=>nasc_y(d.TOTAL)); // create svg and translated g var svg = d3_5.select(DOM.svg(w,h)) const g = svg.append('g').attr('transform', `translate(${margin.left}, ${margin.top})`) svg.append("path").datum(nasc_data).attr("fill", "steelblue").attr("d", nasc_line) .attr("fill", "none") .attr("stroke", "grey") .attr("stroke-width", 0.5) .attr("opacity", 0.3) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round"); let inicios_anos=[] semanas_epidemiologicas.forEach((d,i)=>{ if (d.semana==1) inicios_anos.push(i) }) // draw background lines g.append('g').selectAll('line') .data(inicios_anos) .enter() .append('line') .attr('x1', d => x(d)).attr('x2', d => x(d)) .attr('y1', 0).attr('y2', height/4) .style('stroke', '#505050') // define brush var brush = d3_5.brushX() .extent([[0,0], [innerwidth, height]]) .on('brush', function() { var s = d3_5.event.selection; // update view // if the view should only be updated after brushing is over, // move these two lines into the on('end') part below svg.node().value = s.map(d => Math.round(x.invert(d))); svg.node().dispatchEvent(new CustomEvent("input")); }) .on('end', function() { if (!d3_5.event.sourceEvent) return; var d0 = d3_5.event.selection.map(x.invert); var d1 = d0.map(Math.round) d3_5.select(this).transition().call(d3_5.event.target.move, d1.map(x)) //chama atualizacao do heatmap disp.call("atualiza_heatmap",this,d1) line.transition().attr("x1",x(d1[0])).attr("x2",x(d1[0])) }) // append brush to g var gBrush = g.append("g") .attr("class", "brush") .call(brush) //override default behaviour when clicking outside the brush gBrush.selectAll(".overlay") .each(function(d) { d.type = "selection"; }) .on("mousedown touchstart", d => {}) let line=gBrush.append("line") .attr("y1",0) .attr("y2",h) .attr("x1",x(808)) .attr("x2",x(808)) .attr("stroke",paleta[4]) .attr("stroke-width",3) // select range gBrush.call(brush.move, [x(808),x(808+42)]) //chamada ao clicar no heatmap disp.on("atualiza_slider",e=>{ let sel=semanas_epidemiologicas.findIndex(d=>d.ano==e.ano&&d.semana==e.semana) gBrush.transition().call(brush.move,[x(sel),x(sel+42)]) line.transition().attr("x1",x(sel)).attr("x2",x(sel)) }) return svg.node() }4b:[{"id":"8aec337cfc77f3dd98588037826eb7af00523b4261ed1e843380d75ceb84cfc628ac6683f22839b3653536c3a1b7089e26f378b1b206ac5f290904c9a1176998","href":"https://static.observableusercontent.com/files/8aec337cfc77f3dd98588037826eb7af00523b4261ed1e843380d75ceb84cfc628ac6683f22839b3653536c3a1b7089e26f378b1b206ac5f290904c9a1176998","name":"Municipios_SISAM@3.csv","type":"text/csv","lastModified":1676903596930.863,"size":174482},{"id":"f2201770123f4b364781aee7ac3512db444637a3ad42ef096c62d05e6637e8d48b4875ec59b514f9f028ae6c85b557a5d74de4b1e2d1c18d62c5114c6c9c27fa","href":"https://static.observableusercontent.com/files/f2201770123f4b364781aee7ac3512db444637a3ad42ef096c62d05e6637e8d48b4875ec59b514f9f028ae6c85b557a5d74de4b1e2d1c18d62c5114c6c9c27fa","name":"semanas_epidemiologicas_estendido.csv","type":"text/csv","lastModified":1676903596930.863,"size":35417},{"id":"f635e7dd41ca56ecac4829069efc3743abcb63e3332d89a163752974b516fa7900014bee97263dd907714fb55d5b244763bb40e9459d93e258ddb65dcf07c675","href":"https://static.observableusercontent.com/files/f635e7dd41ca56ecac4829069efc3743abcb63e3332d89a163752974b516fa7900014bee97263dd907714fb55d5b244763bb40e9459d93e258ddb65dcf07c675","name":"sisam@2.zip","type":"application/zip","lastModified":1676903596930.863,"size":22225054}] 43:{"id":"1638ec041e7fc8e6","slug":null,"title":"SISAM - Heatmap - Embed","thumbnail":"b9d1f697e2388ff8920f6f910e44909597cbb75d0d0026598bc13b545b031f64","access_level":"public","create_time":"$D2023-02-20T14:33:16.930Z","update_time":"$D2023-02-20T14:33:16.930Z","view_time":null,"first_public_time":"$D2023-02-20T14:33:16.930Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"a194530ebf4bcd45","login":"rmauro","name":"Renato Mauro","avatar_url":"https://avatars-next.observableusercontent.com/384a790421646f649e2ea216b245cdf691e67c27a943cfe9e09dd7d3485efaf3","tier":"starter_2024","bio":"","following":false},"version":2126,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"3230060d1b16358d","login":"rmauro","name":"Renato Mauro","avatar_url":"https://avatars-next.observableusercontent.com/384a790421646f649e2ea216b245cdf691e67c27a943cfe9e09dd7d3485efaf3","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"3230060d1b16358d","login":"rmauro","name":"Renato Mauro","avatar_url":"https://avatars-next.observableusercontent.com/384a790421646f649e2ea216b245cdf691e67c27a943cfe9e09dd7d3485efaf3","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"SISAM - Heatmap - Embed","cells":[{"id":0,"value":"# SISAM - Heatmap - Embed","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1307,"value":"viewof slider = slider_snap(0, 1043)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":404,"value":"viewof UF = Inputs.select([... new Set(municipios.map(d=>d.UF))].sort(Intl.Collator().compare), {label: \"UF\", value: \"RIO DE JANEIRO\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":421,"value":"viewof municipio = Inputs.select(municipios.filter(d=>d.UF==UF).map(d=>d.municipio).sort(Intl.Collator().compare), {label: \"Município\", value: capitais[UF]})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":359,"value":"viewof indicador = \n Inputs.select([\"co_ppb\",\"no2_ppb\",\"o3_ppb\",\"pm25_ugm3\",\"precipitacao_mmdia\",\"so2_ugm3\",\"temperatura_c\",\"umidade_relativa_percentual\",\"vento_direcao_grau\",\"vento_velocidade_ms\"], {label: \"Indicador\",value: \"pm25_ugm3\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1959,"value":"setFind = (set,elem) => {\n let find=-1\n elem=JSON.parse(elem)\n for (let i of set){\n i=JSON.parse(i)\n let equal=true\n for (let j of Object.keys(i))\n if (Math.abs(i[j]-elem[j])>0.05)\n equal=false\n if (equal)\n find=i\n }\n return JSON.stringify(find)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1908,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1242,"value":"volume_mol = (temperatura) => {\n //pV=nRT\n let R=0.08206 // (atm L) / (mol K)\n return R*(temperatura+293.15) //converte C para K\n} //considera que p = 1 atm (1013.25 hPa)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1237,"value":"massa_mol=({\n no2_ppb: 46.0055,\n o3_ppb: 48,\n co_ppb: 28.01\n}) // g/mol","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1184,"value":"padroes=({\n pm25_ugm3:[25,37,50,60], //ADEQUADO, PF, MI3, MI2, MI1\n so2_ugm3:[20,30,40,60],\n no2_ppb:[200,220,240,260],\n o3_ppb:[100,120,130,140],\n co_ppb:[9]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1152,"value":"paleta=[\"#FFFFFF\",\"#FFC0B6\",\"#FA7E70\",\"#C34F45\",\"#8D1D1D\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"height=12*(width-30)/(20*4) //100 //200","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":337,"value":"anofinal=2019","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"anoinicial=2000","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"meses=[\"JAN\",\"FEV\",\"MAR\",\"ABR\",\"MAI\",\"JUN\",\"JUL\",\"AGO\",\"SET\",\"OUT\",\"NOV\",\"DEZ\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":595,"value":"mutable loading = true","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":770,"value":"capitais=({\"ACRE\":\"RIO BRANCO\", \"ALAGOAS\":\"MACEIÓ\", \"AMAPÁ\":\"MACAPÁ\", \"AMAZONAS\":\"MANAUS\", \"BAHIA\":\"SALVADOR\", \"CEARÁ\":\"FORTALEZA\", \"DISTRITO FEDERAL\":\"BRASÍLIA\", \"ESPÍRITO SANTO\":\"VITÓRIA\", \"GOIÁS\":\"GOIÂNIA\", \"MARANHÃO\":\"SÃO LUÍS\", \"MATO GROSSO\":\"CUIABÁ\", \"MATO GROSSO DO SUL\":\"CAMPO GRANDE\", \"MINAS GERAIS\":\"BELO HORIZONTE\", \"PARÁ\":\"BELÉM\", \"PARAÍBA\":\"JOÃO PESSOA\", \"PARANÁ\":\"CURITIBA\", \"PERNAMBUCO\":\"RECIFE\", \"PIAUÍ\":\"TERESINA\", \"RIO DE JANEIRO\":\"RIO DE JANEIRO\", \"RIO GRANDE DO NORTE\":\"NATAL\", \"RIO GRANDE DO SUL\":\"PORTO ALEGRE\", \"RONDÔNIA\":\"PORTO VELHO\", \"RORAIMA\":\"BOA VISTA\", \"SANTA CATARINA\":\"FLORIANÓPOLIS\", \"SÃO PAULO\":\"SÃO PAULO\", \"SERGIPE\":\"ARACAJU\", \"TOCANTINS\":\"PALMAS\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1102,"value":"language=\"pt\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1106,"value":"en=({\n \"JAN\":\"JAN\",\n \"DEZ\":\"DEC\",\n \"ANO\":\"YEAR\",\n \"SEMANA\":\"WEEK\",\n \"VALOR\":\"VALUE\",\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1098,"value":"function t (s) {\n if (language==\"en\")\n return en[s]\n else\n return s\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1201,"value":"amplitude=[d3.min(data.map(d=>d.valor).filter(d=>~~d)).toFixed(2),d3.max(data.map(d=>d.valor).filter(d=>~~d)).toFixed(2)]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":293,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1534,"value":"resp = sql`\n select \n year(datahora) as ano,\n month(datahora) as mes,\n day(datahora) as dia,\n max(${indicador}) as valor,\n avg(temperatura_c) as temperatura_c_media\n from \n \"amplia-sisam\"\n where\n mun_geocodsdv=${municipios.find(d=>d.municipio==municipio).codigo_sdv}\n group by\n 1,2,3\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"//resp_old = sql`\n// select \n// year(datahora) as ano,\n// month(datahora) as mes,\n// day(datahora) as dia,\n// max(${indicador}) as valor,\n// avg(temperatura_c) as temperatura_c_media\n// from \n// \"amplia-sisam\"\n// where\n// ${municipio==\"TODA A UF\"?\n// \"mun_uf_nome='\"+UF+\"'\":\n// \"mun_geocodsdv=\"+municipios.find(d=>d.municipio==municipio).codigo_sdv}\n// group by\n// 1,2,3\n//`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"sql = function(strings, ...values)\n{ \n let resp = [];\n let i;\n for(i=0; i{\n fetch(url,{method:\"POST\",body:JSON.stringify(body)})\n .then(response => {mutable loading = false; return response.json();})\n .then(resolve)\n .catch(reject);\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":408,"value":"municipios=FileAttachment(\"Municipios_SISAM@3.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":827,"value":"semanas_epidemiologicas=FileAttachment(\"semanas_epidemiologicas_estendido.csv\").csv().then(d=>d.map(s=>{\n s.inicio=new Date(Date.UTC(+s.inicio.substr(0,4),+s.inicio.substr(5,2)-1,+s.inicio.substr(8,2)));\n s.termino=new Date(Date.UTC(+s.termino.substr(0,4),+s.termino.substr(5,2)-1,+s.termino.substr(8,2)));\n return s;\n})) //contagem de meses comeca em zero","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":347,"value":"[localStorage manipulation for this notebook](https://observablehq.com/d/029b2a1da2d5975b)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1048,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1709,"value":"mutable selectionHeatmap=({inicio: \"2015-06-14T00:00:00.000Z\", termino: \"2015-06-20T00:00:00.000Z\", uf: \"RIO DE JANEIRO\", municipio: \"RIO DE JANEIRO\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1744,"value":"function arrowDefs(parent)\n{\n const defs = parent.append(\"defs\");\n\n const marker = defs.append(\"marker\")\n .attr(\"id\",\"pointer-heatmap\")\n .attr(\"markerWidth\",\"12\")\n .attr(\"markerHeight\",\"20\")\n .attr(\"refX\",\"12\")\n .attr(\"refY\",\"10\")\n .attr(\"markerUnits\",\"userSpaceOnUse\")\n .attr(\"orient\",\"90\")\n ;\n\n marker.append(\"polyline\")\n .attr(\"points\",\"0 0,12 10,0 20\")\n .attr(\"fill\",\"none\")\n .attr(\"stroke\",paleta[4])\n .attr(\"stroke-width\",\"3\")\n ; \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1786,"value":"mutable numeroSemanaSel=808","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1816,"value":"## From file","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1834,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1850,"value":"//resp=db.query(query)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1838,"value":"query=`select \\\n strftime('%Y',datahora) as ano, \\\n strftime('%m',datahora) as mes, \\\n strftime('%d',datahora) as dia, \\\n max(${indicador}) as valor, \\\n avg(temperatura_c) as temperatura_c_media \\\n from \\\n \"amplia-sisam\" \\\n where \\\n mun_geocodsdv=${municipios.find(d=>d.municipio==municipio).codigo_sdv} \\\n group by \\\n 1,2,3`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1827,"value":"db=zip.file(\"sisam.db\").sqlite()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1823,"value":"zip=FileAttachment(\"sisam@2.zip\").zip()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1298,"value":"## Barra","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1621,"value":"xBarra = d3_5.scaleLinear()\n .domain([0,1046]) // data space\n .range([0, slider_width-slider_left_margin]); // display space","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1507,"value":"slider_left_margin=20","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1513,"value":"slider_width=width","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1458,"value":"//coordena chamadas entre heatmap e slider, dando acesso a variaveis nos escopos internos\ndisp=d3.dispatch(\"atualiza_slider\",\"atualiza_heatmap\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2112,"value":"SEM_GRAVIDADE = sql`\n select\n data_nasc, count(*) as TOTAL\n from \n \"datasus-sinasc\" \n where \n res_NOME_UF = '${UF}'\n AND res_MUNNOMEX = '${municipio}'\n AND data_nasc >= '2000-01-01T00:00:00.000Z'\n AND data_nasc <= '2019-12-31T00:00:00.000Z'\n group by \n 1\n order by\n 1\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2071,"value":"MARCADOR_GRAVIDADE = sql`\n select\n data_nasc, count(*) as TOTAL\n from \n \"datasus-sinasc\" \n where \n (APGAR5='01' or APGAR5='02' or APGAR5='03' OR PESO < 1500 OR SEMAGESTAC < 37 OR IDANOMAL = 1 OR GESTACAO < 5)\n AND res_NOME_UF = '${UF}'\n AND res_MUNNOMEX = '${municipio}'\n AND data_nasc >= '2000-01-01T00:00:00.000Z'\n AND data_nasc <= '2019-12-31T00:00:00.000Z'\n group by \n 1\n order by\n 1\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2015,"value":"nasc_data={\n let ret=[]\n MARCADOR_GRAVIDADE.rows.forEach(row=>{\n let dict={}\n MARCADOR_GRAVIDADE.columns.map(d=>d.name).forEach((column,i)=>{\n dict[column]=row[i]\n })\n\n dict.data_nasc=new Date(dict.data_nasc)\n dict.TOTAL/=SEM_GRAVIDADE.rows.find(d=>(new Date(d[0])).getTime()==dict.data_nasc.getTime())[1]\n \n ret.push(dict)\n })\n\n return ret\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1304,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1310,"value":"slider_style=\nhtml`\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1319,"value":"d3_5 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4b","stdlib":"1"}} 44:"$43:body"