30:T654,stats = function(route){ const validCities = _(route).map(name => citiesIdByName[name]).compact().value() const segments = [] const missingSegments = [] let distance = 0; for (let i = 1; i < validCities.length; i++) { const from = cities[validCities[i - 1]] const to = cities[validCities[i]] const od = ods[validCities[i - 1] + validCities[i]] || ods[validCities[i] + validCities[i - 1]] distance += haversine([from.longitude, from.latitude], [to.longitude, to.latitude]) if (od !== undefined) { segments.push(od) } } const thisODs = [] let airplane = 0 for (let i = 0; i < validCities.length; i++) { for (let j = i + 1; j < validCities.length; j++) { const od = ods[validCities[i] + validCities[j]] || ods[validCities[j] + validCities[i]] if (od === undefined) { missingSegments.push([cities[validCities[i]].City, cities[validCities[j]].City]) } else { thisODs.push(od) airplane += (od['airplane seats'] || 0) } } } const citiesData = _.map(validCities, city => cities[city]) return { citiesData, foundCities: validCities.length !== 0, missingCities: _.filter(route, city => citiesIdByName[city] === undefined), airplane, duration: _(segments).map(s => s.Duration).sum(), segments, missingSegments, distance, competition: _(thisODs).map('Competition').uniq().compact().value(), remarks: _(thisODs).map('Remarks').uniq().compact().value(), 'operational difficulties': _(thisODs).map('operational difficulties').uniq().compact().value(), } }31:T480,map = function(routes, localWidth){ if(localWidth === undefined) { localWidth = width } const height = localWidth * 0.7; const projection = d3.geoConicConformal() .parallels([35, 65]) .rotate([-5, 0]) .scale(localWidth * 1.3) .center([10, 50]) .translate([localWidth / 2, height / 2]) .clipExtent([[0, 0], [localWidth, height]]) .precision(0.2) const context = DOM.context2d(localWidth, height); const path = d3.geoPath(projection, context); const graticule = d3.geoGraticule10(); context.beginPath(), path(graticule), context.strokeStyle = "#ccc", context.stroke(); context.beginPath(), path(countries), context.strokeStyle = "#555", context.fillStyle = "rgba(0, 0, 0, .8)", context.fill(), context.stroke(); for (const [name, city] of Object.entries(cities)) { context.beginPath(), path({type: "Point", coordinates: [city.longitude, city.latitude]}), path.pointRadius(2), context.fillStyle = "#a55", context.fill(); } context.beginPath(), pathOfRoutes(routes, context, projection), context.strokeStyle = "#aaf", context.lineWidth = 2, context.stroke() return context.canvas; }32:[] 2e:{"title":"Midnight","cells":[{"id":0,"value":"md`# Midnight\n\nDes fonctions qui récupèrent les données et les mettent en forme`","pinned":true,"hidden":false,"mode":"ojs"},{"id":2,"value":"cities = await fetch(\"https://airtable-proxy.tristramg.now.sh/api/get-cities\").then(r => r.json())","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"ods = await fetch(\"https://airtable-proxy.tristramg.now.sh/api/get-ods\").then(r => r.json())","pinned":true,"hidden":false,"mode":"ojs"},{"id":30,"value":"$30","pinned":true,"hidden":false,"mode":"ojs"},{"id":121,"value":"statsWithBranches = function(routes) {\n const allStats = _.map(routes, stats)\n const citiesData = _(allStats).flatMap('citiesData').union().value()\n \n return {\n citiesData,\n missingCities: _(allStats).flatMap('missingCities').union().value(),\n cityPop: _(citiesData).map('Population').sum(),\n cityAreaPop: _(citiesData).map('Population urban area').sum(),\n airplane: _.sumBy(allStats, s => s.airplane),\n duration: _(allStats).map('duration').max(),\n distance: _(allStats).map('distance').max(),\n segments: _(allStats).flatMap('segments').union().uniq().value(),\n missingSegments: _(allStats).flatMap('missingSegments').union().uniq().value(),\n competition: _(allStats).flatMap('competition').union().value(),\n remarks: _(allStats).flatMap('remarks').union().value(),\n 'operational difficulties': _(allStats).flatMap('operational difficulties').union().value(),\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":131,"value":"statsWithBranches([['Paris', 'Bruxelles', 'Hannover', 'Berlin'],\n ['Paris', 'Bruxelles', 'Bremen', 'Hamburg', 'Flens']])","pinned":true,"hidden":false,"mode":"ojs"},{"id":31,"value":"citiesIdByName = _(cities).map((c, id) => [c.City, id]).fromPairs().value()","pinned":true,"hidden":false,"mode":"ojs"},{"id":53,"value":"summary = function(routes) {\n const stat = statsWithBranches(routes)\n return html`\n

Statistiques

Durée totale: ${stat.duration} heures
Population des villes: ${(stat.cityPop / 1e6).toFixed(2)} millions
Population des aires urbaines: ${(stat.cityAreaPop / 1e6).toFixed(2)} millions
Sièges d’avion proposés par semaine et par sens: ${stat.airplane}
Longueur (à vol d’oiseau): ${stat.distance.toFixed(0)} km

\n`\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":76,"value":"pathOfRoute = function(route, context, projection) {\n let first = true;\n for (const cityName of route) {\n const cityId = citiesIdByName[cityName]\n const city = cities[cityId]\n if (city !== undefined) {\n const point = projection([city.longitude, city.latitude])\n if (first) {\n context.moveTo(point[0], point[1])\n first = false\n } else {\n context.lineTo(point[0], point[1])\n }\n }\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":171,"value":"pathOfRoutes = function(routes, context, projection) {\n for (const route of routes) {\n pathOfRoute(route, context, projection)\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":36,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":89,"value":"ranking = function(routes) {\n const trainSize = 400\n const stat = statsWithBranches(routes)\n const airplane = 400 * 7 * 100 / stat.airplane \n const cityPop = 400 * 365 * 1000 / stat.cityPop\n const cityAreaPop = 400 * 365 * 1000 / stat.cityAreaPop\n \n return html`\n

Ranking

Tous les chiffres sont pour un départ par jour et par sens, pour un train long (14 voitures standard, soit 400m)

Équivalent en part de l’aérien: ${airplane.toFixed(2)} %
Part de la population des villes: ${cityPop.toFixed(2)} ‰
Part de la population des aires urbaines: ${cityAreaPop.toFixed(2)} ‰
Compétition: ${_.join(stat.competition, ', ')}
Difficultées opérationnelles: ${_.join(stat['operational difficulties'], ', ')}
Remarques: ${_.join(stat.remarks, ', ')}

\n`\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":58,"value":"debug = function(routes) {\n const stat = statsWithBranches(routes)\n let result = ''\n \n if (stat.missingCities.length > 0) {\n result += \"### Arrêts non retrouvés\\n\"\n for (const c of stat.missingCities) {\n result += `* ${c}\\n`\n }\n }\n \n if (stat.missingSegments.length > 0) {\n result += \"### Segments manquants\\n\"\n for (const s of stat.missingSegments) {\n result += `* ${s[0]} ⇌ ${s[1]}\\n`\n }\n }\n\n return md`${result}`\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":39,"value":"d3 = require(\"d3-fetch@1\", \"d3-geo@1\", \"d3-shape@1\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":42,"value":"topojson = require(\"topojson-client@3\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":45,"value":"world = d3.json(await require.resolve(\"world-atlas@1/world/50m.json\"))","pinned":false,"hidden":false,"mode":"ojs"},{"id":48,"value":"countries = topojson.feature(world, world.objects.countries)","pinned":true,"hidden":false,"mode":"ojs"},{"id":4,"value":"_ = require(\"lodash\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":100,"value":"haversine = function([lon1, lat1], [lon2, lat2]) {\n Number.prototype.toRad = function() {\n return this * Math.PI / 180;\n }\n\n const R = 6371; // km \n //has a problem with the .toRad() method below.\n const x1 = lat2-lat1;\n const dLat = x1.toRad(); \n const x2 = lon2-lon1;\n const dLon = x2.toRad(); \n const a = Math.sin(dLat/2) * Math.sin(dLat/2) + \n Math.cos(lat1.toRad()) * Math.cos(lat2.toRad()) * \n Math.sin(dLon/2) * Math.sin(dLon/2); \n const c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a)); \n return R * c; \n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":176,"value":"fiche = function(routes, start) {\n \n return html`\n${timetable(routes, start || 20)}\n${ranking(routes)}\n

${summary(routes)}

${map(routes, width/2)}

\n\n

Debug

\n${debug(routes)}\n`\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":182,"value":"timetable = function(routes, start) {\n function duration(origin, destination) {\n const o = citiesIdByName[origin]\n const d = citiesIdByName[destination]\n const od = ods[o + d] || ods[d + o]\n return od? od.Duration : 0\n }\n \n const stops = {}\n for (const route in routes) {\n let time = start\n let prev = undefined\n for (const stop of routes[route]) {\n if (prev) {\n time += duration(prev, stop)\n }\n prev = stop\n if (!stops[stop]) {\n stops[stop] = routes.map(x => '')\n }\n console.log(stop, stops[stop][0], time)\n if(stops[stop][0] != formatTime(time)) {\n stops[stop][route] = formatTime(time)\n }\n }\n }\n \n const tabStop = []\n for (const stop in stops) {\n tabStop.push([stop].concat(stops[stop]))\n }\n return html`\n\n ${routes.map(x=> html``)}\n\n${tabStop.map(x => html`${x.map(x => html``)}`)}\n`\n\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":197,"value":"timetable([['Paris', 'Bruxelles', 'Hannover', 'Berlin'],\n ['Paris', 'Bruxelles', 'Bremen', 'Hamburg']], 20)","pinned":true,"hidden":false,"mode":"ojs"},{"id":297,"value":"map([['Paris', 'Bruxelles', 'Hannover', 'Berlin']])","pinned":true,"hidden":false,"mode":"ojs"},{"id":183,"value":"formatTime = function(time) {\n const hours = Math.floor(time % 24)\n const mins = Math.floor((time * 60) % 60)\n return `${hours.toString().padStart(2, \"0\")}:${mins.toString().padStart(2, \"0\")}`\n}","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}

Départ
${x}