2b:null 2c:["$","title",null,{"children":"Projeto Credos da Cidade - Dados da Receita | Alexandre R. Cajazeira Ramos | Observable"}] 31:Tf5f,mapDiv = { const container = html`

`; yield container; const map = L.map(container).setView(centro_map, mapZoom) L.tileLayer("https://cartodb-basemaps-{s}.global.ssl.fastly.net/light_all/{z}/{x}/{y}.png", { attribution: `© OpenStreetMap, Map tiles by © CARTO`, maxZoom: 18 }).addTo(map); map.scrollWheelZoom.disable(); let info = L.control();let legend = L.control({position: 'bottomleft'}); const geoj = L.geoJson(bairrosFortaleza, { style: style, onEachFeature: onEachFeature }); function zoomToFeature(e) { map.fitBounds(e.target.getBounds()); } function highlightFeature(e) { let layer = e.target; layer.setStyle({ weight: 3, color: 'black', dashArray: '', fillOpacity: 1 }); info.update(layer.feature); }; function resetHighlight(e) { geoj.resetStyle(e.target); info.update(); } function onEachFeature(feature, layer) { layer.on({ mouseover: highlightFeature, mouseout: resetHighlight, click: zoomToFeature // click: view }); } function style(feature) { return { weight: 0.7, opacity: 1, color: 'gray', dashArray: '3', fillOpacity: 0.8, fillColor: colorScale(feature.taxa_templos), }; } if(title_vis == 'bairros'){ geoj.addTo(map); legend.onAdd = function (map) { return Legend(colorScale, { title: "Taxa de templos p/ 100 mil hab.", tickFormat: "d", marginRight: 0, }); }; legend.addTo(map); }else{ legend.onAdd = function (map) { var lista_html = ""; sortedSitucao.forEach(d => { const qtd = situcao_count.get(d), total = filteredPoints.length; lista_html += `

${legenda_situacao(d)} (${qtd} templos | ${Math.round(qtd/total*100,2)}%)

` }); const div = html`

${lista_html}

` return div; }; legend.addTo(map); dots.addTo(map); dots.on('mouseover', function (e) { // console.log(e.layer); // let layer = e.target; info.update(e.layer); }); dots.on('mouseout', function () { info.update(); }); } info.onAdd = function (map) { this._div = L.DomUtil.create('div', 'info'); this.update(); return this._div; }; info.update = function (feat) { if(feat){ if(title_vis == 'bairros'){ this._div.innerHTML = '

'+feat.properties.NOME+'

' +''+bairros_count.get(feat.properties.NOME)+' templo(s); ' +'
'+feat.properties.TOTAL+' habitante(s);' +'
'+Math.round(feat.taxa_templos)+' templos/cem mil hab.' ; }else{ console.log(feat); let templo = feat.options.data; this._div.innerHTML = '

'+templo.razao_social+'

' +'CNPJ: ' + templo.cnpj +'
Nº de estabelecimentos: ' + contribuintes_count.get(templo.razao_social) +'
Início da Atividade: ' + d3.timeFormat("%d/%m/%Y")(templo.dtg) +'
Endrerço: ' + templo.End_comp ; } }else{ this._div.innerHTML = '

Templos Religiosos em Fortaleza

' + 'Passe o mouse sobre um bairro ou templo religioso'; } } info.addTo(map); }32:T69f,// fonte = md`*Fonte: Levantamento DATADOC com base na Lei de Acesso à Informação*` fonte = { const fonte = htl.html` Fonte: Levantamento DATADOC ` return fonte; }33:T8cb, // Source: https://observablehq.com/@john-guerra/multi-auto-select // just call list "options2": function multiAutoSelect2(config = {}) { const { value, title, description, disabled, autocomplete = "off", placeholder, size, options2, list = "options2" } = Array.isArray(config) ? { options2: config } : config; const optionsSet = new Set(options2); const form = input({ type: "text", title, description, attributes: { disabled }, action: fm => { const addSelectedOption = d => { const ele = html`${d} `; ele.querySelector("button").addEventListener("click", b => { console.log("delete", d); fm.value.splice(fm.value.indexOf(d), 1); renderSelection(); fm.dispatchEvent(new CustomEvent("input")); fm.input.focus(); }); return ele; }; function renderSelection() { fm.output.innerHTML = ""; for (let o of fm.value) { fm.output.appendChild(addSelectedOption(o)); } } fm.input.value = ""; fm.value = value || []; fm.onsubmit = e => e.preventDefault(); fm.input.oninput = function(e) { e.stopPropagation(); if ( optionsSet.has(fm.input.value) && fm.value.indexOf(fm.input.value) === -1 ) { fm.value.push(fm.input.value); renderSelection(); fm.input.value = ""; fm.dispatchEvent(new CustomEvent("input")); } }; renderSelection(); }, form: html` ` }); form.output.style["margin-left"] = "0px"; console.log(form) return form; }34:[{"id":"05b6c3cf350594c65eaf10d93d0a02a64e49a6cd2b9ec59a97d07e0833dbdfc0bdc1cbc364371a38f35c4217b2c5783bcf667555dc4c60be62dc09081b477b68","href":"https://static.observableusercontent.com/files/05b6c3cf350594c65eaf10d93d0a02a64e49a6cd2b9ec59a97d07e0833dbdfc0bdc1cbc364371a38f35c4217b2c5783bcf667555dc4c60be62dc09081b477b68","name":"bairrosFortaleza.geojson","type":"application/geo+json","lastModified":1640892456696.686,"size":1494344},{"id":"32d6b21deead4fbdf63446bf0f84cdbb81e62f7e5e3bd7b30be545522d9d3fa18701edb4208dfb908060a0c49ed23ff4f0a3582f4f3076226ef98b8c004b09d3","href":"https://static.observableusercontent.com/files/32d6b21deead4fbdf63446bf0f84cdbb81e62f7e5e3bd7b30be545522d9d3fa18701edb4208dfb908060a0c49ed23ff4f0a3582f4f3076226ef98b8c004b09d3","name":"dfReceita_bairros.csv","type":"text/csv","lastModified":1640897967887.354,"size":1192907}] 2f:{"id":"801a12b95634512a","slug":null,"title":"Projeto Credos da Cidade - Dados da Receita","thumbnail":"6c7902d142f99b4bcefbdf5d12ba9481f6788a26423acd936edb77bfbc7574dc","access_level":"public","create_time":"$D2021-12-30T19:26:56.437Z","update_time":"$D2023-01-22T19:53:27.980Z","view_time":null,"first_public_time":"$D2023-01-22T19:52:56.874Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"8e753d8464d231a8","login":"cajazeiraramos","name":"Alexandre R. Cajazeira Ramos","avatar_url":"https://avatars-next.observableusercontent.com/24092c234c1e156d4478bb8314522bb1b37a8ec8ee43d8a161f6931e7d8e6bed","tier":"starter_2024"},"version":851,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"273de8807df2d5cc","login":"cajazeiraramos","name":"Alexandre R. Cajazeira Ramos","avatar_url":"https://avatars-next.observableusercontent.com/b3a734ec21bf9f0bb7a0ecaacac5767f34267e9be1b061f79faf1fb9146aa44d","tier":null}],"members":[{"type":"individual","id":"273de8807df2d5cc","login":"cajazeiraramos","name":"Alexandre R. Cajazeira Ramos","avatar_url":"https://avatars-next.observableusercontent.com/b3a734ec21bf9f0bb7a0ecaacac5767f34267e9be1b061f79faf1fb9146aa44d","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":{"id":"6ad1142fbeacff4b","slug":"datadoc","title":"DATADOC / OPOVO","owner":{"id":"8e753d8464d231a8","login":"cajazeiraramos","name":"Alexandre R. Cajazeira Ramos"}},"type":"notebook","body":{"title":"Projeto Credos da Cidade - Dados da Receita","cells":[{"id":0,"value":"# Projeto Credos da Cidade - Dados da Receita","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":749,"value":"title = md`# Dados da Receita Federal (outro título)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":236,"value":"viewof selecao_situacao = checkbox({\n title: 'Situação cadastral do Estabelecimento',\n // description: 'Selecione as categorias',\n options: [\n { value: \"2\", label: 'Ativa' },\n { value: '4', label: 'Inapta' },\n { value: '8', label: 'Baixada' },\n { value: '3', label: 'Suspensa' },\n { value: '1', label: 'Nula' },\n ],\n value: [\"2\"]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"viewof title_vis = radio({\n title: 'Selecione uma das opções de visualização:',\n // description: 'Selecione uma das opções de visualização',\n options: [\n { label: 'Bairros', value: 'bairros' },\n { label: 'Templos', value: 'pontos' },\n ],\n value: 'bairros'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":670,"value":"viewof selected_contribuinte = autoSelect({\n options: uniq_contribuintes,\n placeholder: \"Pesquise por Razão Social. . .\",\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":722,"value":"viewof selected_bairros = multiAutoSelect2({\n options2: bairrosFortaleza.features.map(d => d.properties.bairro),\n placeholder: \"Escolha um ou mais Bairos . . .\"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"centro_map = [-3.77,-38.52];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"height = width/1.5;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"mapZoom = height>=500?12:11;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":86,"value":"mutable mapHeight = height;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"bairrosFortaleza = FileAttachment(\"bairrosFortaleza.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":303,"value":"taxa_templos = {\n var map = new Map();\n bairrosFortaleza.features.forEach(d => {\n d.taxa_templos = bairros_count.get(d.properties.NOME)?((bairros_count.get(d.properties.NOME)*100000)/d.properties.TOTAL):0;\n map.set(d.properties.NOME, d.taxa_templos);\n })\n return map;\n}\n\n// d3.map(bairrosFortaleza.features, d=> d.properties.TOTAL);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":380,"value":"sorted_bairros_taxa_templos = Array.from(taxa_templos).sort((a, b) => d3.descending(a[1], b[1])).map(d => d[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"idCNPJ = new Map();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":249,"value":"dataPoints = {\n\n const formatTime = d3.timeParse(\"%Y%m%d\");\n \n \n const dataRaw = d3.csvParse(await FileAttachment(\"dfReceita_bairros.csv\").text())\n\n dataRaw.forEach((d,i) => \n {\n d.data = +d['Data início_atividade'];\n d.dtg = formatTime(+d['Data início_atividade']);\n d.sit = +d['Situação Cadastral'];\n d.cnpj= d.CNPJ_basico;\n d.razao_social= d.razao_social;\n d.bairro = d.bairro_name;\n d.lat= +d.lat; \n d.lng= +d.lng;\n\n if (idCNPJ.has(d.cnpj)) {\n d.count = idCNPJ.get(d.cnpj) + 1;\n idCNPJ.set(d.cnpj, d.count);\n } else {\n d.count = 1; \n idCNPJ.set(d.cnpj, 1);\n }\n d.y1 = (d.cnpj)\n\n });\n \n return dataRaw;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":284,"value":"filteredPoints = dataPoints.filter(d=> (selecao_situacao.indexOf(d.sit.toString()) > -1) && (selected_bairros == \"\" || selected_bairros.indexOf(d.bairro) > -1))\n// selected_bairros","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":688,"value":"contribuintes = filteredPoints.map(d=> d.razao_social);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":691,"value":"uniq_contribuintes = [...new Set(contribuintes)]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":695,"value":"contribuintes_count = d3.rollup(contribuintes, v => v.length, d => d)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":843,"value":"sortedContribuintes = Array.from(contribuintes_count).sort((a, b) => d3.descending(a[1], b[1])).map(d => d)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"bairros = filteredPoints.map(d => d.bairro)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"bairros_count = d3.rollup(bairros, v => v.length, d => d)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"sortedBairros = Array.from(bairros_count).sort((a, b) => d3.descending(a[1], b[1])).map(d => d[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"dots = {\n const dotsLayerGroup = L.featureGroup();\n filteredPoints.forEach( function(d) {\n let dot = L.circle([d.lat, d.lng], 5, { data: d,\n // color: '#f03b20',\n color: temploColorScale(d.sit.toString()),\n weight: 2,\n fillColor: 'red',\n fillOpacity: 0.5\n });\n // dot.bindPopup(\"CNPJ: \"+(d.CNPJ_basico)+\"
Razão Social: \"+d.razao_social);\n if(selected_contribuinte== \"\" || selected_contribuinte.indexOf(d.razao_social) != -1)\n dotsLayerGroup.addLayer(dot) \n })\n return dotsLayerGroup;\n // .toGeoJSON();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":289,"value":"colorScale = d3.scaleLinear()\n .domain([0,taxa_templos.get(sorted_bairros_taxa_templos[0])])\n // .range(['#fff7bc','#cc4c02'])\n .range(['#fcfbfd','#4a1486'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":760,"value":"temploColorScale = d3.scaleOrdinal()\n .domain([\"2\", \"8\", \"4\", \"1\", \"3\"])\n .range(['#386cb0','#beaed4','#fdc086','#ffff99','#a6d854'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":778,"value":"situcao = filteredPoints.map(d=> d.sit.toString())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":780,"value":"situcao_count = d3.rollup(situcao, v => v.length, d => d)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":785,"value":"sortedSitucao = Array.from(situcao_count).sort((a, b) => d3.descending(a[1], b[1])).map(d => d[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":801,"value":"legenda_situacao = d3.scaleOrdinal()\n .domain([\"2\", \"8\", \"4\", \"1\", \"3\"])\n .range(['Ativa','Baixada','Inapta','Nula','Suspensa'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":243,"value":"## Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":813,"value":"teste = {\n var t = false;\n dataPoints.forEach(d=> {\n if(d.CNPJ_basico.includes('10483076'))\n t=1;\n \n \n });\n return t;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":819,"value":"dataPoints[0].CNPJ_basico.includes('413')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"L = {\n const L = await require(\"leaflet@1.6/dist/leaflet.js\");\n if (!L._style) {\n const href = await require.resolve(\"leaflet@1/dist/leaflet.css\");\n document.head.appendChild(L._style = html``);\n }\n return L;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"import {radio} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":239,"value":"import {checkbox} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"import {Legend} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":672,"value":"import {autoSelect} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":703,"value":"import {multiAutoSelect} from \"@john-guerra/multi-auto-select\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":735,"value":"import { input } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":733,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 30:"$2f:body"