Archivio Radiosondaggi Cameri

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_116":-5,"_20":117,"_22":118,"_119":120,"_121":122,"_25":123,"_24":-5,"_124":-5,"_125":-5,"_126":53,"_127":128,"_129":44,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","zebbe82","name","rs_consult","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","5cc70139-cc4d-472b-a892-8b0b155f8011","consult.ts","fileId","4e2f7714-77c3-11f1-a9c9-1607ee4eb77e","parentId","branchId","70023578-5bca-4a6e-8197-440b34109cae","branchVersion",23,"latest",true,"createdAt",["D",1788512348321],22,"fileType","http","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Riferimenti Storici Cameri (1991-2020)\nconst RS_STORICO = [\n {\n theta_e: 20.8,\n decadi: [{ t: 0.8, zt: 1763 }, { t: 0.3, zt: 1669 }, { t: 0.0, zt: 1577 }],\n },\n {\n theta_e: 20.5,\n decadi: [{ t: 0.5, zt: 1723 }, { t: 0.0, zt: 1631 }, { t: 0.3, zt: 1683 }],\n },\n {\n theta_e: 24.9,\n decadi: [{ t: 1.1, zt: 1727 }, { t: 3.5, zt: 2077 }, { t: 2.6, zt: 1944 }],\n },\n {\n theta_e: 30.3,\n decadi: [{ t: 4.1, zt: 2105 }, { t: 4.1, zt: 2084 }, { t: 6.2, zt: 2474 }],\n },\n {\n theta_e: 38.8,\n decadi: [{ t: 7.6, zt: 2664 }, { t: 8.7, zt: 2835 }, { t: 10.3, zt: 3121 }],\n },\n {\n theta_e: 47.9,\n decadi: [{ t: 11.5, zt: 3285 }, { t: 12.6, zt: 3448 }, {\n t: 14.0,\n zt: 3729,\n }],\n },\n {\n theta_e: 53.3,\n decadi: [{ t: 14.3, zt: 3761 }, { t: 14.7, zt: 3826 }, {\n t: 15.7,\n zt: 3959,\n }],\n },\n {\n theta_e: 53.9,\n decadi: [{ t: 15.8, zt: 4002 }, { t: 15.0, zt: 3913 }, {\n t: 14.4,\n zt: 3849,\n }],\n },\n {\n theta_e: 44.1,\n decadi: [{ t: 12.1, zt: 3524 }, { t: 11.1, zt: 3404 }, {\n t: 9.6,\n zt: 3230,\n }],\n },\n {\n theta_e: 36.1,\n decadi: [{ t: 8.6, zt: 3129 }, { t: 7.3, zt: 2943 }, { t: 6.7, zt: 2867 }],\n },\n {\n theta_e: 28.0,\n decadi: [{ t: 5.5, zt: 2583 }, { t: 3.3, zt: 2171 }, { t: 2.2, zt: 1984 }],\n },\n {\n theta_e: 22.2,\n decadi: [{ t: 1.4, zt: 1844 }, { t: 0.9, zt: 1782 }, { t: 0.7, zt: 1763 }],\n },\n];\n\nfunction calcRH(T: number | null, TD: number | null): number | null {\n if (T === null || TD === null || isNaN(T) || isNaN(TD)) return null;\n return (6.112 * Math.exp((17.67 * TD) / (TD + 243.5)) /\n (6.112 * Math.exp((17.67 * T) / (T + 243.5)))) * 100;\n}\nfunction calcWetBulb(T: number | null, RH: number | null): number | null {\n if (T === null || RH === null || isNaN(T) || isNaN(RH)) return null;\n return T * Math.atan(0.151977 * Math.pow(RH + 8.313659, 0.5)) +\n Math.atan(T + RH) - Math.atan(RH - 1.676331) +\n 0.00391838 * Math.pow(RH, 1.5) * Math.atan(0.023101 * RH) - 4.686035;\n}\nfunction nomeMese(yyyyMm: string) {\n const mesi = [\n \"Gennaio\",\n \"Febbraio\",\n \"Marzo\",\n \"Aprile\",\n \"Maggio\",\n \"Giugno\",\n \"Luglio\",\n \"Agosto\",\n \"Settembre\",\n \"Ottobre\",\n \"Novembre\",\n \"Dicembre\",\n ];\n const [anno, mese] = yyyyMm.split(\"-\");\n return `${mesi[parseInt(mese, 10) - 1]} ${anno}`;\n}\n\nexport default async function (req: Request): Promise {\n const u = new URL(req.url);\n const format = u.searchParams.get(\"format\") ?? \"html\";\n const viewMode = u.searchParams.get(\"view\") === \"charts\" ? \"charts\" : \"table\";\n const filter = u.searchParams.get(\"filter\") || \"days-30\";\n const start = u.searchParams.get(\"start\") || \"\";\n const end = u.searchParams.get(\"end\") || \"\";\n\n const mesiRes = await sqlite.execute(\n `SELECT DISTINCT substr(run, 1, 7) as meseVal FROM soundings ORDER BY meseVal DESC`,\n );\n const mesiDisponibili = mesiRes.rows.map((r) => String(r[0]));\n\n let sql =\n `SELECT run, temp850, dewpoint850, thte850, hght850, temp500, hght500, zeroTermico FROM soundings`;\n let args: any[] = [];\n let whereClauses: string[] = [];\n\n if (filter === \"custom\" && start && end) {\n whereClauses.push(`run >= ?`);\n args.push(`${start} 00:00:00`);\n whereClauses.push(`run <= ?`);\n args.push(`${end} 23:59:59`);\n } else if (filter.startsWith(\"month-\")) {\n const m = filter.replace(\"month-\", \"\");\n whereClauses.push(`run LIKE ?`);\n args.push(`${m}-%`);\n } else if (filter !== \"all\") {\n let d = parseInt(filter.replace(\"days-\", \"\"), 10);\n if (isNaN(d)) d = 30;\n const pastDate = new Date();\n pastDate.setDate(pastDate.getDate() - d);\n whereClauses.push(`run >= ?`);\n args.push(pastDate.toISOString().substring(0, 10) + \" 00:00:00\");\n }\n\n if (whereClauses.length > 0) sql += ` WHERE ` + whereClauses.join(\" AND \");\n sql += ` ORDER BY run DESC LIMIT 3000`;\n\n const res = await sqlite.execute({ sql, args });\n\n let sum = {\n t850: 0,\n rh850: 0,\n tw850: 0,\n thte: 0,\n gpt850: 0,\n t500: 0,\n gpt500: 0,\n zt: 0,\n };\n let count = {\n t850: 0,\n rh850: 0,\n tw850: 0,\n thte: 0,\n gpt850: 0,\n t500: 0,\n gpt500: 0,\n zt: 0,\n };\n let refSum = { t850: 0, thte: 0, zt: 0 };\n\n const rows = res.rows.map((r: any) => {\n const runStr = String(r[0]);\n const t = r[1] !== null ? Number(r[1]) : null;\n const td = r[2] !== null ? Number(r[2]) : null;\n const rh = calcRH(t, td);\n const tw = calcWetBulb(t, rh);\n const thte = r[3] !== null ? (Number(r[3]) - 273.15) : null;\n const hght850 = r[4] !== null ? Number(r[4]) : null;\n const t500 = r[5] !== null ? Number(r[5]) : null;\n const hght500 = r[6] !== null ? Number(r[6]) : null;\n const zt = r[7] !== null ? Number(r[7]) : null;\n\n const mIdx = parseInt(runStr.substring(5, 7), 10) - 1;\n const day = parseInt(runStr.substring(8, 10), 10);\n let decIdx = 0;\n if (day > 10 && day <= 20) decIdx = 1;\n else if (day > 20) decIdx = 2;\n const storicoRow = RS_STORICO[mIdx];\n const refT = storicoRow.decadi[decIdx].t,\n refZ = storicoRow.decadi[decIdx].zt,\n refTh = storicoRow.theta_e;\n\n if (t !== null) {\n sum.t850 += t;\n count.t850++;\n refSum.t850 += refT;\n }\n if (rh !== null) {\n sum.rh850 += rh;\n count.rh850++;\n }\n if (tw !== null) {\n sum.tw850 += tw;\n count.tw850++;\n }\n if (thte !== null) {\n sum.thte += thte;\n count.thte++;\n refSum.thte += refTh;\n }\n if (hght850 !== null) {\n sum.gpt850 += hght850;\n count.gpt850++;\n }\n if (t500 !== null) {\n sum.t500 += t500;\n count.t500++;\n }\n if (hght500 !== null) {\n sum.gpt500 += hght500;\n count.gpt500++;\n }\n if (zt !== null) {\n sum.zt += zt;\n count.zt++;\n refSum.zt += refZ;\n }\n\n return {\n run: runStr,\n temp850: t !== null ? t.toFixed(1) : null,\n rh850: rh !== null ? rh.toFixed(0) : null,\n wetbulb850: tw !== null ? tw.toFixed(1) : null,\n thte850_C: thte !== null ? thte.toFixed(1) : null,\n hght850: hght850 !== null ? Math.round(hght850) : null,\n temp500: t500 !== null ? t500.toFixed(1) : null,\n hght500: hght500 !== null ? Math.round(hght500) : null,\n zeroTermico: zt !== null ? Math.round(zt) : null,\n ref_t850: refT,\n ref_zt: refZ,\n ref_thte: refTh, // Aggiunti i ref per i grafici\n };\n });\n\n const getAnomHtml = (actualSum, refTotal, c, isZt = false) => {\n if (c === 0) return \"\";\n const diff = (actualSum / c) - (refTotal / c);\n const col = diff > 0 ? \"#e74c3c\" : \"#3498db\";\n return `
[${\n diff > 0 ? \"+\" : \"\"\n }${isZt ? Math.round(diff) : diff.toFixed(1)}]`;\n };\n\n const avg = {\n t850: count.t850 > 0\n ? (sum.t850 / count.t850).toFixed(1) +\n getAnomHtml(sum.t850, refSum.t850, count.t850)\n : \"-\",\n rh850: count.rh850 > 0 ? (sum.rh850 / count.rh850).toFixed(0) : \"-\",\n tw850: count.tw850 > 0 ? (sum.tw850 / count.tw850).toFixed(1) : \"-\",\n thte: count.thte > 0\n ? (sum.thte / count.thte).toFixed(1) +\n getAnomHtml(sum.thte, refSum.thte, count.thte)\n : \"-\",\n gpt850: count.gpt850 > 0 ? Math.round(sum.gpt850 / count.gpt850) : \"-\",\n t500: count.t500 > 0 ? (sum.t500 / count.t500).toFixed(1) : \"-\",\n gpt500: count.gpt500 > 0 ? Math.round(sum.gpt500 / count.gpt500) : \"-\",\n zt: count.zt > 0\n ? Math.round(sum.zt / count.zt) +\n getAnomHtml(sum.zt, refSum.zt, count.zt, true)\n : \"-\",\n };\n\n const queryParams = new URLSearchParams();\n if (filter) queryParams.set(\"filter\", filter);\n if (start) queryParams.set(\"start\", start);\n if (end) queryParams.set(\"end\", end);\n const baseQueryString = queryParams.toString()\n ? `&${queryParams.toString()}`\n : \"\";\n\n if (format === \"json\") {\n return new Response(JSON.stringify(rows), {\n headers: {\n \"content-type\": \"application/json\",\n \"access-control-allow-origin\": \"*\",\n },\n });\n }\n\n const toggleViewUrl = `?view=${\n viewMode === \"charts\" ? \"table\" : \"charts\"\n }${baseQueryString}`;\n const toggleText = viewMode === \"charts\"\n ? \"📄 Torna alla Tabella\"\n : \"📈 Visualizza Grafici\";\n\n const html = `\n\n\nArchivio Radiosondaggi Cameri\n\n\n\n\n

Archivio Radiosondaggi Cameri (16064)

\n \n

⬇️ CSV ⚙️ JSON

\n\n

\n ${toggleText}\n ${\n viewMode === \"charts\"\n ? ` Mostra Media Storica`\n : \"\"\n }\n

\n\n${\n viewMode === \"charts\"\n ? `\n

\n\n`\n : `\n\n \n \n \n \n \n \n \n \n${\n rows.map((r) =>\n ``\n ).join(\"\\n\")\n }\n \n \n \n \n

Run (UTC)	T 850 (°C)	UR 850 (%)	Tw 850 (°C)	Theta-e (°C)	Gpt 850 (m)	T 500 (°C)	Gpt 500 (m)	ZT (m)
${\n r.run.substring(0, 13)\n }Z	${r.temp850 ?? \"-\"}	${\n r.rh850 ?? \"-\"\n }	${r.wetbulb850 ?? \"-\"}	${\n r.thte850_C ?? \"-\"\n }	${r.hght850 ?? \"-\"}	${r.temp500 ?? \"-\"}	${\n r.hght500 ?? \"-\"\n }	${r.zeroTermico ?? \"-\"}
MEDIA (Anomalia)	${avg.t850}	${avg.rh850}	${avg.tw850}	${avg.thte}	${avg.gpt850}	${avg.t500}	${avg.gpt500}	${avg.zt}

\n\n`\n }\n\n`;\n return new Response(html, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1788512348321],"children",[],[35],"dafe763f-a002-4ac8-8d1f-07a85325463d",["D",1783181613898],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Consultazione","imageUrl","userId","019d070c-74a3-72bd-a233-2c24ee89845b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019d070c-74a3-72bd-a233-332526ef97cc","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_115":111},"org",{"_11":12,"_109":-5,"_110":111,"_71":72,"_112":113,"_114":53},"branch",{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zQkFsUXBvcE9jWGpDbGlvUmlMT1VHWUo5bHgifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":149,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":150,"_96":151,"_98":152,"_100":53},[146],"files",[146],"counts",{"_136":78,"_137":138,"_139":78,"_31":140,"_141":142},[134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":135},[35],"pulls","branches",1,"forks",{"_143":78,"_145":78},"connections",{"_143":78,"_144":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":147,"_18":148},[],[35],["D",1783181613898],{"_11":12,"_115":111},{"_11":12,"_109":-5,"_110":111,"_71":72,"_112":113,"_114":53},{"_17":42,"_13":16,"_33":40,"_101":61,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_94":-5,"_131":186,"_187":188,"_189":190,"_191":53,"_192":53,"_193":53,"_194":44,"_195":-5,"_196":-7,"_197":-7,"_198":78,"_199":53,"_200":53,"_201":-5,"_202":53,"_203":53,"_204":53,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":16,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Code