31:T607,viewof paramsb = { const ctrls = [ { node: select({ title: "Variable 1", options: columns, value: columns[0] }) }, { node: select({ title: "Variable 2", options: columns, value: columns[1] }) } ]; const div = html`

${ctrls.map(d => d.node)}

`; let lastValue1, lastDisabled1 ; //la 1ère liste pilote le contenu de la seconde : on évite d'avoir 2 critères identiques ctrls[0].node.addEventListener('change', () => { let value0 = ctrls[0].node.value; const list1 = ctrls[1].node.querySelector("[name='input']") ; if (lastDisabled1) list1.querySelector(`option[value=${lastDisabled1}]`).removeAttribute('disabled'); lastDisabled1 = value0 ; list1.querySelector(`option[value=${value0}]`).setAttribute('disabled', 'disabled'); lastValue1 = lastValue1 && lastValue1 != value0 ? lastValue1 : columns.find(d => d != value0) ; list1.selectedIndex = columns.findIndex(d => d == lastValue1) ctrls[1].node.value = lastValue1 ; ctrls[1].node.dispatchEvent(new Event('change')); }); // La seconde liste dispatche les nouvelles clés ctrls[1].node.addEventListener('change', () => { div.value = { key1: ctrls[0].node.value, key2: ctrls[1].node.value } ; div.dispatchEvent(new CustomEvent('input')) ; }); ctrls[0].node.dispatchEvent(new Event('change')) ; // Initialisation return div ; }32:[] 2f:{"title":"Analyse du recensement des plateformes open data territoriales en France","cells":[{"id":0,"value":"md`# Analyse du recensement des plateformes open data territoriales en France\n\nCette étude porte sur deux bases descriptives des portails OD territoriaux (hors portails nationaux) :\n\n* [Le recueil de Loïc Haÿ](https://airtable.com/shrWxHPi2XjLu9xtM/tblwklJPsyayeH5lX)\n* [Le recueil de l'Observatoire open data des territoires](https://airtable.com/shrKrV6KY7BlhHDx7/tblc9HHRXShE0O8wT/viwyfbGjcd0LyUbjm)\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":488,"value":"viewof base = radio({\n title: 'Choix de la base plateformes open data territoriales :',\n description: null,\n options: [\n { label: 'Recensement Loïc Haÿ', value: 'hay' },\n { label: 'Suivi Observatoire open data des territoires (ODT)', value: 'odt' },\n\n ],\n value: urlParams.get('base') || 'hay'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":514,"value":"extrait_data = normalize_table_names(aq.from(opendata_france).select(aq.not(['image', 'value', 'fid']))).view(10)","pinned":false,"hidden":false,"mode":"ojs"},{"id":539,"value":"buttons0 = html`\n${DOM.download(new Blob([d3.csvFormat(opendata_france)], {type: \"text/csv\"}), \"opendata.csv\", \"Export CSV (\" + aq.from(opendata_france).numRows() +\" plateformes)\")}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":753,"value":"md `Voici de quoi croiser deux variables quelconques sous forme d'un graphique de type \"[Parallel Sets](https://observablehq.com/@ericmauviere/parallel-sets-2)\" :`","pinned":false,"hidden":false,"mode":"ojs"},{"id":890,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":626,"value":"t = md `Plateformes open data régionales : croisement des variables **${paramsb.key1}** et **${paramsb.key2}** :`","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"ps2 = chart","pinned":false,"hidden":false,"mode":"ojs"},{"id":636,"value":"s = md `*Source : ${base == 'hay' ? 'Recensement Loïc Haÿ' : 'Recensement ODT'}*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"buttons = html`\n${DOM.download(await rasterize(chart), \"opendata\", \"Export PNG\")}\n${DOM.download(await serialize(chart), \"opendata\", \"Export SVG\")}\n${DOM.download(new Blob([d3.csvFormat(data)], {type: \"text/csv\"}), \"opendata.csv\", \"Export CSV\")}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":856,"value":"md `### Liste de plateformes filtrée selon 1 à 2 critères`","pinned":false,"hidden":false,"mode":"ojs"},{"id":806,"value":"viewof params2 = {\n const ctrls = [\n {\n name: 'start',\n node: select({\n title: \"Critère 1\",\n options: columns,\n value: columns[0]\n})\n },\n {\n name: 'end',\n node: select({\n title: \"Critère 2\",\n options: [\"Choisissez...\"].concat(columns),\n value: columns[0]\n})\n }\n ];\n\n function getValue() {\n return {\n key1: ctrls[0].node.value,\n key2: ctrls[1].node.value\n };\n }\n \n const div = html`

`;\n\n ctrls.forEach((ctrl, index) => {\n ctrl.node.style.display = 'inline-block';\n if (index) ctrl.node.style.marginLeft = '1.5em';\n div.appendChild(ctrl.node);\n ctrl.node.addEventListener('change', () => {\n div.value = getValue();\n div.dispatchEvent(new CustomEvent('input'));\n });\n });\n\n div.value = getValue();\n return div;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":871,"value":"md `Extrait de **${liste_filtree.numRows()}** plateforme(s).` ","pinned":false,"hidden":false,"mode":"ojs"},{"id":812,"value":"viewof liste_filtree = {\n let filtercond = `d => d.${params2.key1} == '${params3.mod1}' & d.${params2.key2} == '${params3.mod2}'` ;\n if ( params2.key2 == 'Choisissez...') {\n filtercond = `d => d.${params2.key1} == '${params3.mod1}'` ;\n }\n return normalize_table_names(aq.from(opendata_france)).filter(filtercond).select(aq.not(['image', 'value', 'fid'])).view(100) ;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":860,"value":"buttons2 = html`\n${DOM.download(new Blob([d3.csvFormat(liste_filtree.objects())], {type: \"text/csv\"}), \"opendata.csv\", \"Export CSV\")}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":409,"value":"import {chart, d3}\nwith {data, keys, height, errMsg as errMsg}\nfrom \"@ericmauviere/parallel-sets-2\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":835,"value":"mods1 = normalize_table_names(aq.from(opendata_france)).groupby(params2.key1).count().columnAt(0).data.sort()","pinned":false,"hidden":false,"mode":"ojs"},{"id":838,"value":"mods2 = params2.key2 == \"Choisissez...\" ? [\"NA\"] : normalize_table_names(aq.from(opendata_france)).groupby(params2.key2).count().columnAt(0).data.sort()","pinned":false,"hidden":false,"mode":"ojs"},{"id":697,"value":"errMsg = \"Veuillez sélectionner deux variables différentes...\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"data = normalize_table_names(aq.from(opendata_france))\n .groupby(keys[0])\n .derive({ key1_count:op.count(d => d[keys[0]]) })\n .groupby(keys[1])\n .derive({ key2_count:op.count(d => d[keys[1]]) })\n .groupby(keys.concat(\"key1_count\",\"key2_count\"))\n .rollup({ value: d => op.count() })\n .orderby(aq.desc('key1_count'), aq.desc('key2_count'))\n .objects()","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"opendata_france = {\n let offset = 1, records = [], \n url = ( base == \"hay\" ?\n \"https://api.airtable.com/v0/appPh6C4Aim9RhpYJ/PTF%20territoriales%20de%20donn%C3%A9es\"\n : //\"https://api.airtable.com/v0/app1b8HcUuBxoI3iJ/Plateformes\" \n \"https://api.airtable.com/v0/appP2S7BUo2NG55DQ/Plateformes\"\n \n ) + \"?api_key=keyodJN9sAkwrdi2C\" ,\n airtable_url = url, f;\n \n while (offset) {\n if ( offset != 1 ) airtable_url = url + \"&offset=\" + offset ;\n f = await d3.json(airtable_url) ;\n offset = f.offset;\n records = records.concat(f.records) ;\n }\n \n let s = records.map(d => d.fields), n = 0 ;\n s.forEach( function(d) {d.value=1; d.fid=n++} ) ; //d.name=d.nom;\n return s ;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":743,"value":"md `## Test d'accès aux APis proposés par ces portails`","pinned":false,"hidden":false,"mode":"ojs"},{"id":776,"value":"md `Ce test scanne les API les unes après les autres, réagissant à d'éventuels blocages. Selon la lenteur de tel site à répondre, cela peut prendre un peu de temps...`","pinned":false,"hidden":false,"mode":"ojs"},{"id":322,"value":"viewof replay = {\n const b = html`