2e:null 2f:["$","title",null,{"children":"#608 Vuelos oficiales-contexto | Civio | Observable"}] 34:T988,planeFullDatasetViz = { const plane01 = "Torrejón de Ardoz - Barcelona - Gando - Paraguay - Ezeiza - Gran Canaria - Torrejón de Ardoz"; const plane02 = "Torrejón de Ardoz - Uarzazat - Torrejón de Ardoz"; // Simple div with flexbox behaviour const div = d3 .create("div") .attr("id", "flights-context") .style("width", width) .style("display", "flex") .style("flex-direction", "row") .style("flex-wrap", "wrap") .style("justify-content", "center") .style("align-items", "center"); // Planes measures const airbusWidth = 46; const airbusHeight = 16; const falconWidth = 22; const falconHeight = 8; div .selectAll("div") .data(data) .join("div") .attr("class", "planeIcon") .attr("data-id", d => d.FECHA) .attr("data-plane", d => d.FLOTA) .style("width", d => d.FLOTA == "T18" || d.FLOTA == "x" ? `${falconWidth * scaleFactor}px` : `${airbusWidth * scaleFactor}px` ) .style("height", d => d.FLOTA == "T18" ? `${falconHeight * scaleFactor}px` : `${airbusHeight * scaleFactor}px` ) .style("transform", d => `rotate(${scaleAvionRotate(d.AVION)}deg)`) .style("margin", "5px") .style("display", "block") .style("box-sizing", "content-box") .style("padding", "3px 2px") .style("border-radius", "5px") .style("border", d => d.RUTA2 == plane01 || d.RUTA2 == plane02 ? `2px dashed ${colorPrimaryTDAS}` : "none" ) .append('img') .style("width", "100%") .style("height", "auto") .style("display", "inline-block") .style("margin", "auto") .style("vertical-align", "middle") .style("opacity", 0) .transition() .duration(800) .delay((d, i) => Math.random() * i * 10) .style("opacity", d => scaleAvionOpacity(d.AVION) || 1); // Icons dependending on plane model div .selectAll( ".planeIcon[data-plane=T18] > img, .planeIcon[data-plane=x] > img" ) .attr("src", await FileAttachment("icon-shadow_falcon@1.svg").url()); div .selectAll(".planeIcon[data-plane=T22] > img") .attr("src", await FileAttachment("icon-shadow_airbus@1.svg").url()); // Interactions div .selectAll(".planeIcon") .style("cursor", "pointer") .style("cursor", "pointer") .on("mouseover", onMouseOver) .on("mousemove", onMouseMove) .on("mouseout", onMouseOut); return div.node(); }35:[{"id":"7b29e14a1f079fdd6ce36f26fcd50ff29160c189259c5e69e8068526c2386408f720cd443855cf975a07a7040f3e13d0960422103e899d74c01fbb5744ebfe62","href":"https://static.observableusercontent.com/files/7b29e14a1f079fdd6ce36f26fcd50ff29160c189259c5e69e8068526c2386408f720cd443855cf975a07a7040f3e13d0960422103e899d74c01fbb5744ebfe62","name":"dataset@1.csv","type":"text/csv","lastModified":1622617542035.694,"size":8520},{"id":"4353ff8496b360221ea7109b13e38752974e0e440387c1432ccbeb65e3930167c97b3acc44b0a465e8ceed8d04cc718dc2505231b4237f32968d90895bcb5349","href":"https://static.observableusercontent.com/files/4353ff8496b360221ea7109b13e38752974e0e440387c1432ccbeb65e3930167c97b3acc44b0a465e8ceed8d04cc718dc2505231b4237f32968d90895bcb5349","name":"icon_airbus-svg.svg","type":"image/svg+xml","lastModified":1622618703934.454,"size":24234},{"id":"021d8a0573eaa7bb8cf9f397f9b481202260b36bcc0e404fe3d42d68266be6b15b66b68c0ad2120d48768eda705b1c86fa6469cfe9d36bd58e697126a70fadcb","href":"https://static.observableusercontent.com/files/021d8a0573eaa7bb8cf9f397f9b481202260b36bcc0e404fe3d42d68266be6b15b66b68c0ad2120d48768eda705b1c86fa6469cfe9d36bd58e697126a70fadcb","name":"icon_falcon-svg.svg","type":"image/svg+xml","lastModified":1622618703932.892,"size":10771},{"id":"205c5a493c9d553732711e274b4faabfd9a220d77a061ccce5250b3cf290d4a22ad32a99d2fb4483c0e16bf4ddc41d45df0d9a961883eb76db362a1ac8662654","href":"https://static.observableusercontent.com/files/205c5a493c9d553732711e274b4faabfd9a220d77a061ccce5250b3cf290d4a22ad32a99d2fb4483c0e16bf4ddc41d45df0d9a961883eb76db362a1ac8662654","name":"dataset-clean04.csv","type":"text/csv","lastModified":1622807701142.681,"size":20105},{"id":"29c3e3c2c8feb3c5308bae26fd419450a9a6507d990dba58211414c73292537e63ac4857796900b9fef41718e9dd6fc4922a52014e15151e71bcdbbdce81ca8d","href":"https://static.observableusercontent.com/files/29c3e3c2c8feb3c5308bae26fd419450a9a6507d990dba58211414c73292537e63ac4857796900b9fef41718e9dd6fc4922a52014e15151e71bcdbbdce81ca8d","name":"dataset-clean03@1.csv","type":"text/csv","lastModified":1622800688752.427,"size":16105},{"id":"d07143e34b37379242662dccb184d82c2f016cb35d6bf521dd9fe509e93afd27c9613a792fa7722efb595f8d7682b28737b7fd936e261a9c4157727e9bef04ed","href":"https://static.observableusercontent.com/files/d07143e34b37379242662dccb184d82c2f016cb35d6bf521dd9fe509e93afd27c9613a792fa7722efb595f8d7682b28737b7fd936e261a9c4157727e9bef04ed","name":"dataset-clean05@3.csv","type":"text/csv","lastModified":1622819789114.08,"size":27270},{"id":"f0d4e04630be015f60e5b8028f89386ab79fcf958196e2c19c716477124fe4d49d873191193d1e02ed8db3f56df09c8c7f7099a3a625708af607a86763be3aaa","href":"https://static.observableusercontent.com/files/f0d4e04630be015f60e5b8028f89386ab79fcf958196e2c19c716477124fe4d49d873191193d1e02ed8db3f56df09c8c7f7099a3a625708af607a86763be3aaa","name":"icon-shadow_airbus@1.svg","type":"image/svg+xml","lastModified":1622830274888.483,"size":26904},{"id":"db27950051bf54f0b53cde7686e220b589c15cd8139374a1213d21042448125ec833afbb1f8c6b604c9af1c12952de271920edc0271b8b878097b4ecb1bd9b30","href":"https://static.observableusercontent.com/files/db27950051bf54f0b53cde7686e220b589c15cd8139374a1213d21042448125ec833afbb1f8c6b604c9af1c12952de271920edc0271b8b878097b4ecb1bd9b30","name":"icon-shadow_falcon@1.svg","type":"image/svg+xml","lastModified":1622830274776.244,"size":12297}] 32:{"id":"7e381061861576d7","slug":"608-vuelos-oficiales-contexto","title":"#608 Vuelos oficiales-contexto","thumbnail":"79b55029104dbabeec4b94f02cc2f2546aa3c62ec8caa35d360bfd13a8cf1c30","access_level":"public","create_time":"$D2021-06-01T18:50:49.410Z","update_time":"$D2022-05-18T09:27:24.175Z","view_time":null,"first_public_time":"$D2021-06-08T07:22:44.516Z","has_unpublished_edits":null,"fork":false,"stars":3,"starred":false,"owner":{"type":"team","id":"2f498cc67cbf2e04","login":"civio","name":"Civio","avatar_url":"https://avatars-next.observableusercontent.com/97192929d85c6cd912ab5bcadf8b5870eab960dec55224ac3d0e2301e8ac13b8","tier":"starter_2024"},"version":393,"publish_version":393,"role":null,"authored":false,"authors":[{"type":"individual","id":"8b6befb4233b6103","login":"carmen-tm","name":"Carmen Torrecillas","avatar_url":"https://avatars-next.observableusercontent.com/6166cc1d0d1b54f27c95caecb76fb456af5de2933e87f457e55d4d06b1973062","tier":null}],"members":[{"type":"individual","id":"8b6befb4233b6103","login":"carmen-tm","name":"Carmen Torrecillas","avatar_url":"https://avatars-next.observableusercontent.com/6166cc1d0d1b54f27c95caecb76fb456af5de2933e87f457e55d4d06b1973062","tier":null,"role":"editor"},{"type":"team","id":"2f498cc67cbf2e04","login":"civio","name":"Civio","avatar_url":"https://avatars-next.observableusercontent.com/97192929d85c6cd912ab5bcadf8b5870eab960dec55224ac3d0e2301e8ac13b8","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"7893b88808ddf6b3","slug":"tu-derecho-a-saber-your-right-to-know","title":"Your right to know | Tu derecho a saber","owner":{"id":"2f498cc67cbf2e04","login":"civio","name":"Civio"}},"type":"notebook","body":{"title":"#608 Vuelos oficiales-contexto","cells":[{"id":0,"value":"md`# #608 Vuelos oficiales-contexto\n\n**Full article** published (ES)\n- https://civio.es/tu-derecho-a-saber/2021/06/08/defensa-informa-5-anos-despues-de-los-pasajeros-de-los-vuelos-oficiales/\n\nInspiration: this [Civio article](https://civio.es/tu-derecho-a-saber/2018/01/17/256-armas-guardia-civil-policia-nacional-han-desaparecido-ultima-decada/).\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":172,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"viewof scaleFactor = Inputs.range([0, 3], {\n label: \"Scale factor\",\n step: 0.1,\n value: 2.3\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":389,"value":"md`\nEn noviembre de 2015 preguntamos al Ministerio de Defensa quiénes eran los acompañantes de autoridades en los vuelos oficiales. ¿Se llevaban a sus familiares? ¿Qué empresarios les acompañaban?\n\nLos documentos remitidos ahora por Defensa contienen más de 180 solicitudes de transporte –de 2011 a 2016– con las que los distintos ministerios indican las fechas de los vuelos, destinos, escalas –si las hubiera–, los nombres de los pasajeros y necesidades de catering a bordo.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"md`### Interactions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"tooltip = d3\n .select(\"body\")\n .append(\"div\")\n .attr(\"class\", \"vuelos-tooltip\")\n .style(\"position\", \"absolute\")\n .style(\"visibility\", \"hidden\")\n .text(\"\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"function onMouseOver(event, d, i) {\n d3.select(this).style('fill-opacity', 1);\n let tooltipWidth = tooltip.node().offsetWidth;\n let tooltipHeight = tooltip.node().offsetHeight;\n\n tooltip\n .style(\"left\", event.pageX - tooltipWidth / 2 + 'px')\n .style(\"top\", event.pageY - tooltipHeight - 10 + 'px')\n .style('visibility', 'visible')\n .html(\n `

\n ${d.FECHA == \"x\" ? \"No disponible\" : formatDate(parseDate(d.FECHA))}\n

\n Delegación de ${d.MINISTRX} (${d.AUTORIDAD})\n

\n ${\n d.FLOTA == \"T18\"\n ? \"Falcon 900\"\n : d.FLOTA == \"T22\"\n ? \"Airbus 310\"\n : \"No disponible\"\n } | ${d.RUTA2 == \"x\" ? \"No disponible\" : d.RUTA2}\n

\n ${d.MOTIVO || \"\"}\n

\n `\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"function onMouseMove(event) {\n let tooltipWidth = tooltip.node().offsetWidth;\n let tooltipHeight = tooltip.node().offsetHeight;\n\n let xPosition =\n width < 500\n ? (width - tooltipHeight) / 2\n : (xPosition = event.pageX - tooltipWidth / 2);\n\n let yPosition = event.pageY + 10;\n\n return tooltip.style(\"left\", xPosition + 'px').style(\"top\", yPosition + 'px');\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"function onMouseOut() {\n d3.select(this).style('fill-opacity', 0.85);\n return tooltip.style(\"visibility\", \"hidden\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"md`### Handful functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":274,"value":"parseDate = d3.timeParse(\"%Y-%M-%d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"formatDate = d3.timeFormat(\"%d/%M%/%Y\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":335,"value":"md`Adding some variation (_opacity_ and small _angle_ of rotation) depending on the plane model, so it's a bit more dynamic:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":112,"value":"scaleAvionOpacity = d3\n .scaleOrdinal()\n .domain([\n \"40-42\",\n \"45-40\",\n \"45-41\",\n \"45-42\",\n \"45-43\",\n \"45-44\",\n \"45-50\",\n \"45-51\",\n \"x\"\n ])\n .range([0.8, 0.7, 1, 0.9, 0.6, 0.4, 1, 1, 0.2])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"scaleAvionRotate = d3\n .scaleOrdinal()\n .domain([\n \"40-42\",\n \"45-40\",\n \"45-41\",\n \"45-42\",\n \"45-43\",\n \"45-44\",\n \"45-50\",\n \"45-51\"\n ])\n .range([8, -5, -2, 6, -3, 4, 0, 0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"md`### Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"datasetRaw = await FileAttachment(\"dataset-clean05@3.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"data = datasetRaw","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"viewof datasetTable = Inputs.table(datasetRaw)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":140,"value":"viewof datasetSearch = Inputs.search(datasetRaw)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"datasetSearch","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"md`### Colors & styles`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"civioMainBlue = \"#002a6d\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":252,"value":"colorPrimaryTDAS = \"#d3514a\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":214,"value":"styles = html`\n \n \n\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 33:"$32:body"