31:[{"id":"18ed848525e9ab60bca89d5bb7bfaff25d4c75ed8d017966fa58edb27b9826a7dc9205fd96afad29b858bba317e5d2f47f8fb07a51bb181b411b47a17ef4edd3","href":"https://static.observableusercontent.com/files/18ed848525e9ab60bca89d5bb7bfaff25d4c75ed8d017966fa58edb27b9826a7dc9205fd96afad29b858bba317e5d2f47f8fb07a51bb181b411b47a17ef4edd3","name":"ne_10m_time_zones.geojson","type":"application/geo+json","lastModified":1680271468532.714,"size":3533595},{"id":"19c64bfc206925fbbdbfbb5db0a61e5e7e4ddb6be6637e5946c1408c40e44664c58682a8051ea2858c3c04933d8d432d9a588d2400ad1afac269a4655aa7407e","href":"https://static.observableusercontent.com/files/19c64bfc206925fbbdbfbb5db0a61e5e7e4ddb6be6637e5946c1408c40e44664c58682a8051ea2858c3c04933d8d432d9a588d2400ad1afac269a4655aa7407e","name":"cities.csv","type":"text/csv","lastModified":1680277105355.482,"size":1980269},{"id":"2b913730356d19015e8a8b45559cc3192875374778021f21ff3d505e7a37b9126650965526d69bb9b4012cda0fe6a651a15b6511e35818b4b32f54abff92bf8b","href":"https://static.observableusercontent.com/files/2b913730356d19015e8a8b45559cc3192875374778021f21ff3d505e7a37b9126650965526d69bb9b4012cda0fe6a651a15b6511e35818b4b32f54abff92bf8b","name":"cities@1.csv","type":"text/csv","lastModified":1680528275243.395,"size":497211}] 2f:{"title":"C'est l'heure de l'apéro quelque part !","cells":[{"id":0,"value":"# C'est l'heure de l'apéro quelque part !","pinned":false,"hidden":false,"mode":"md"},{"id":323,"value":"geoplot = Plot.plot({\n width: width,\n projection: {\n type: projection,\n rotate: [0 - d3.mean(aperoCities.map((d) => d.lng)), 0]\n },\n marks: [\n Plot.sphere({ fill: \"#B9D9EB\" }),\n Plot.graticule(),\n Plot.geo(countries, {\n fill: \"#ececec\",\n stroke: \"#b0b0b0\",\n strokeWidth: 0.5\n }),\n Plot.geo(ne_10m_time_zones, {\n fill: (d) =>\n h19.has(d.properties.cartodb_id) ? \"rgba(0,0,0,0.25)\" : \"rgba(0,0,0,0)\",\n stroke: \"currentColor\",\n strokeWidth: 0.75\n }),\n Plot.geo(citiesGeoJSON, {\n radius: 5,\n fill: \"red\",\n stroke: \"black\"\n }),\n Plot.sphere({ fill: \"rgba(0,0,0,0)\", stroke: \"currentColor\" })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":217,"value":"## Il est 19h dans ces villes:","pinned":false,"hidden":false,"mode":"md"},{"id":210,"value":"md`| Ville | Pays | Heure |\n| --- | --- | --- |\n${aperoCities\n .map(\n (d) =>\n `|${d.city}|${d.country}| ${getTime(\n zoneTable.find((z) => +z.cartodb_id === +d.cartodb_id).name\n )\n .format(\"H:mm\")\n .split(\":\")\n .join(\"h\")} |`\n )\n .join(\"\\n\")}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":226,"value":"---\n\n

","pinned":false,"hidden":false,"mode":"md"},{"id":432,"value":"viewof projection = Inputs.select([\"equal-earth\", \"equirectangular\"], {\n label: \"Proj\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":65,"value":"getTime = (tz) => {\n return dayjs()\n .utc()\n .utcOffset(+tz);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":84,"value":"hour = {\n yield +dayjs().format(\"H\");\n while (true) {\n await Promises.delay(60000);\n yield +dayjs().format(\"H\");\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":104,"value":"h19 = new Set(\n ne_10m_time_zones.features\n .map((d) => {\n hour;\n const { cartodb_id, time_zone, name } = d.properties;\n return {\n cartodb_id,\n time_zone,\n hour: +getTime(+name).format(\"H\")\n };\n })\n .filter((d) => d.hour === 19)\n .map((d) => d.cartodb_id)\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":122,"value":"zones = turf.featureCollection(\n ne_10m_time_zones.features.map((d) => {\n d.properties.is19 = h19.has(d.properties.cartodb_id);\n return d;\n })\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":36,"value":"turf = require(\"@turf/turf@5\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"ne_10m_time_zones = FileAttachment(\"ne_10m_time_zones.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":148,"value":"zoneTable = zones.features.map((d) => d.properties)","pinned":true,"hidden":false,"mode":"ojs"},{"id":50,"value":"dayjs = {\n const dayjs = await require(\"dayjs\");\n const utc = await require(\"dayjs/plugin/utc\");\n const timezone = await require(\"dayjs/plugin/timezone\");\n dayjs.extend(utc);\n dayjs.extend(timezone);\n return dayjs;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":194,"value":"citiesGeoJSON = turf.featureCollection(\n aperoCities.map((d) => {\n const geometry = {\n type: \"Point\",\n coordinates: [d.lng, d.lat]\n };\n\n return turf.feature(geometry, d);\n })\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":253,"value":"currentCities = (await FileAttachment(\"cities@1.csv\").csv()).filter((d) =>\n h19.has(+d.cartodb_id)\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":261,"value":"currentCountries.has(\"India\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":256,"value":"currentCountries = new Set(currentCities.map((d) => d.country))","pinned":true,"hidden":false,"mode":"ojs"},{"id":258,"value":"aperoCities = {\n const cityList = [];\n\n for (const country of currentCountries) {\n const cities = currentCities\n .filter((d) => d.country === country)\n .sort((a, b) => +b.population - +a.population)\n .slice(0, 2);\n\n cityList.push(cities);\n }\n\n return cityList.flat().sort((a, b) => {\n return a.country.localeCompare(b.country) || +b.population - +a.population;\n });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":411,"value":"latmax = 85","pinned":false,"hidden":false,"mode":"ojs"},{"id":325,"value":"import { countries50m as countries } from \"@visionscarto/geo\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":438,"value":"cities1 = await FileAttachment(\"cities@1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}