31:[] 2f:{"title":"GRAPH 3","cells":[{"id":0,"value":"md`# GRAPH 3 `","pinned":false,"hidden":false,"mode":"ojs"},{"id":1059,"value":"viewof dd2 = select({\n description: \"Altera o mapa\",\n options: [\"Escolha uma opção abaixo\",\"Matrículas por 100mil hab\", \"Taxa de alunos com acesso a Transporte Público\"],\n multiple: true\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2,"value":"buildvis = { \n let view = md`${container()}` \n \n dc.renderAll()\n return view\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1108,"value":"function container() { \n \n return `\n

teste

\n `\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":22,"value":"datamap = d3.json(\"https://bitbucket.org/DanielAraujoSouza/projetodatavis/raw/ec5cfa1a5e1d34d308d092e8b64788371021b226/public/data/CearaMunicipios.geojson\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":598,"value":"date = d3.dsv(\"|\",\"https://bitbucket.org/DanielAraujoSouza/projetodatavis/raw/ec5cfa1a5e1d34d308d092e8b64788371021b226/public/data/BAS_MATRICULA_CE_PREV.CSV\").then(function(data){\n \n data.forEach(function(d){\n d.Acessibilidade = d.IN_TRANSPORTE_PUBLICO !== \"0.0\" ? \"Sim\" : \"Não\" \n \n d.Dependencia = d.TP_DEPENDENCIA ===\"1\" ? \"Escola Pública\":(d.TP_DEPENDENCIA ===\"2\" ? \"Escola Pública\":(d.TP_DEPENDENCIA ===\"3\" ? \"Escola Pública\":(d.TP_DEPENDENCIA ===\"4\" ? \"Escola Privada\":\"\")))\n \n d.Acesso = d.Dependencia === \"Escola Privada\" ? \"Negado\" : (d.Acessibilidade === \"Sim\" ? \"ok\":\"negado\") \n }); \n \n return data;\n});\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"municipio = d3.dsv(\"|\",\"https://bitbucket.org/DanielAraujoSouza/projetodatavis/raw/ec5cfa1a5e1d34d308d092e8b64788371021b226/public/data/Municipios_CE.csv\").then(function(data) {\n let municipiosMap = new Map()\n let rateMat = 0.0\n let cod \n data.forEach(function(d) { \n \n municipiosMap.set(d.COD_MUNI,+d.POPULACAO)\n })\n return municipiosMap;\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":26,"value":"map = {\n buildvis;\n let mapInstance = L.map('mapid').setView([-5.49,-39.32],9)\n L.tileLayer('http://{s}.tile.osm.org/{z}/{x}/{y}.png',{\n attribution: '© OpenStreetMap contributors' ,\n maxZoom: 17\n }).addTo(mapInstance)\n return mapInstance\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"info = {\n // control that shows state info on hover\n\tlet infoControl = L.control()\n let taxa = \" \"\n \n \n if(dd2 == \"Matrículas por 100mil hab\"){\n taxa = valorMatbyMunicipioMap\n }else{\n taxa = totalAcessByMunicipioMap\n }\n\n\tinfoControl.onAdd = function (map) {\n\t\tthis._div = L.DomUtil.create('div', 'info');\n\t\tthis.update();\n\t\treturn this._div;\n\t}\n\n\tinfoControl.update = function (feat) { \n\t\t\tthis._div.innerHTML = dd2 +'
'+ (feat ?\n\t\t\t\t'' + feat.properties.description + '
' +\"Taxa de \" \n +(((taxa.get(feat.properties.id))*10000)/municipio.get(feat.properties.id)).toFixed(2)\n\t\t\t\t: 'Passe o mouse sobre uma Cidade');\n }\n\n\tinfoControl.addTo(map);\n return infoControl\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"legend = {\n let legendControl = L.control({position: 'bottomright'});\n let escalaCor = \"\" \n let cores = \"\"\n \n if(dd2 == \"Matrículas por 100mil hab\"){\n escalaCor = colorScaleMatriculas\n cores = greens\n }else{\n escalaCor = colorScaleTransporte\n cores = reds\n }\n \n\tlegendControl.onAdd = function (map) {\n\n\t\tlet div = L.DomUtil.create('div', 'info legend'),\n\t\t\tlabels = [],\n n = cores.length,\n\t\t\tfrom, to;\n\n\t\tfor (let i = 0; i < n; i++) {\n\t\t\tlet c = cores[i]\n let fromto = escalaCor.invertExtent(c);\n\t\t\tlabels.push(\n\t\t\t\t' ' +\n\t\t\t\td3.format(\"d\")(fromto[0]) + (d3.format(\"d\")(fromto[1]) ? '–' + d3.format(\"d\")(fromto[1]) : '+'));\n\t\t}\n\n\t\tdiv.innerHTML = labels.join('
')\n\t\treturn div\n\t}\n\n \tlegendControl.addTo(map)\n return legendControl\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":41,"value":"colorScaleMatriculas = d3.scaleQuantile()\n .domain([0,20,40,60,80,120,140,180,200])\n .range(greens)","pinned":true,"hidden":false,"mode":"ojs"},{"id":738,"value":"colorScaleTransporte = d3.scaleQuantile()\n .domain([0,10,25,50,70,120,130,180,200])\n .range(reds)","pinned":true,"hidden":false,"mode":"ojs"},{"id":43,"value":"function zoomToFeature(e) {\n\t\tmap.fitBounds(e.target.getBounds())\n\t}","pinned":false,"hidden":false,"mode":"ojs"},{"id":28,"value":"geojson = {\n function highlightFeature(e) {\n\t\tlet layer = e.target;\n console.log(e.target)\n\n\t\tlayer.setStyle({\n\t\t\t\t\tweight: 2,\n\t\t\t\t\tcolor: '#AAA',\n\t\t\t\t\tdashArray: '',\n\t\t\t\t\tfillOpacity: 0.7\n\t\t}).remove();\n\n\t\tif (!L.Browser.ie && !L.Browser.opera) {\n\t\t\tlayer.bringToFront();\n\t\t}\n\n\t\tinfo.update(layer.feature);\n\t}\n\tlet geoj;\n\n\tfunction resetHighlight(e) {\n\t\tgeoj.resetStyle(e.target);\n\t\tinfo.update();\n\t}\n\n\tfunction zoomToFeature(e) {\n\t\tmap.fitBounds(e.target.getBounds());\n\t}\n\n\tfunction onEachFeature(feature, layer) {\n\t\tlayer.on({\n\t\t\t\t\tmouseover: highlightFeature,\n\t\t\t\t\tmouseout: resetHighlight,\n\t\t\t\t\tclick: zoomToFeature\n\t\t\t\t});\n\t}\n geoj = L.geoJson(datamap, {\n\t\t\t\tstyle: style,\n\t\t\t\tonEachFeature: onEachFeature\n\t\t}).addTo(map)\n return geoj;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"function style(feature) {\n let escalaCor = \"\"\n let taxa = \"\"\n \n if(dd2 == \"Taxa de Matrículas\"){\n escalaCor = colorScaleMatriculas\n taxa = valorMatbyMunicipioMap\n }else{\n \n escalaCor = colorScaleTransporte\n taxa = totalAcessByMunicipioMap\n }\n\t\t return {\n\t\t\t\t\tweight: 1,\n\t\t\t\t\topacity: 1,\n\t\t\t\t\tcolor: 'white',\n\t\t\t\t\tdashArray: '3',\n\t\t\t\t\tfillOpacity: 0.6,\n\t\t\t\t\tfillColor: escalaCor((((taxa.get(feature.properties.id))*10000)/municipio.get(feature.properties.id)).toFixed(2))\n };\n\t}\n //((((valorMatbyMunicipio.get(feature.properties.id))*10000)/municipio.get(feature.properties.id)).toFixed(2)\n //((((mapByAcesso.get(feature.properties.id))*10000)/municipio.get(feature.properties.id)).toFixed(2))\n\t\t\t\t","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"$$ = require('jquery').then(jquery => {\n window.jquery = jquery;\n return require('popper@1.0.1/index.js').catch(() => jquery);\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"html`Esta célula contém os estilos da Visualização\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1022,"value":"reds = d3.schemeReds[9]","pinned":false,"hidden":false,"mode":"ojs"},{"id":35,"value":"greens = d3.schemeGreens[9]","pinned":false,"hidden":false,"mode":"ojs"},{"id":655,"value":"totalMatBymunicipio = facts.dimension(d=>d.CO_MUNICIPIO) // dimensão para contar matriculas dos municípios","pinned":true,"hidden":false,"mode":"ojs"},{"id":657,"value":"totalMatBymunicipioGroup = totalMatBymunicipio.group().reduceCount() // grupo para contar matriculas dos municípios","pinned":true,"hidden":false,"mode":"ojs"},{"id":842,"value":"totalMatBymunicipioGroup.top(200)","pinned":false,"hidden":false,"mode":"ojs"},{"id":659,"value":"// teste contagem das matrículas do município","pinned":true,"hidden":false,"mode":"ojs"},{"id":896,"value":"dimByUserTransp = facts.dimension(d=>d.CO_MUNICIPIO)","pinned":false,"hidden":false,"mode":"ojs"},{"id":898,"value":"dimByUserTranspGroup = dimByUserTransp.group().reduce(\n \n function (p,v){\n \n p.AcessoS1 += v.IN_TRANSPORTE_PUBLICO == \"1.0\" && v.TP_DEPENDENCIA != \"4\"; \n \n return p;\n },\n function (p,v){\n \n p.AcessoS1 += v.IN_TRANSPORTE_PUBLICO == \"1.0\" && v.TP_DEPENDENCIA != \"4\"; \n \n return p;\n },\n function(){\n return {\n AcessoS1 : 0,\n };\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":904,"value":"totalAcessByMunicipioMap = new Map(dimByUserTranspGroup.all().map(d=>[d.key,d.value.AcessoS1]))","pinned":true,"hidden":false,"mode":"ojs"},{"id":704,"value":"valorMatbyMunicipioMap = new Map(totalMatBymunicipioGroup.all().map(d=>[d.key,d.value])) // fazendo um map para calcular a quantidade de matrículas do município para ser usado nos tooltips","pinned":true,"hidden":false,"mode":"ojs"},{"id":750,"value":"totalMatWithAcessoGroup = totalMatBymunicipio.group().reduce(\n \n function (p,v){ \n p.AcessoSim += v.Acesso !== \"Negado\";\n //p.AcessoNao += v.Acessibilidade === \"Não\";\n return p;\n },\n \n function (p,v){\n p.AcessoSim -= v.Acesso !== \"Negado\";\n //p.AcessoNao -= v.Acessibilidade === \"Não\";\n return p;\n },\n \n function(){\n return {\n AcessoSim: 0,\n //AcessoNao: 0\n };\n }\n);","pinned":false,"hidden":false,"mode":"ojs"},{"id":211,"value":"facts = crossfilter(date)","pinned":true,"hidden":false,"mode":"ojs"},{"id":14,"value":"L = require(\"leaflet@1.6.0\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":12,"value":"d3 = require('d3')","pinned":true,"hidden":false,"mode":"ojs"},{"id":10,"value":"dc = require('dc')","pinned":true,"hidden":false,"mode":"ojs"},{"id":115,"value":"bootstrap = require('bootstrap')","pinned":true,"hidden":false,"mode":"ojs"},{"id":5,"value":"crossfilter = require('crossfilter2')","pinned":true,"hidden":false,"mode":"ojs"},{"id":105,"value":"topojson = require(\"topojson-client@3\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":497,"value":"j = require('jquery')","pinned":true,"hidden":false,"mode":"ojs"},{"id":1060,"value":"import {select} from \"@jashkenas/inputs\"\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":1105,"value":"html`css \n`","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}