[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_478":479,"_480":481},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",111,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backup2-dates.ts","latestPath","fileId","ca47fa66-ab9d-11f1-9edb-1607ee4eb77e","name","dates.ts","fileType","script","content","import { RIGHT_NOW_MODELS, TUBING_OPEN_LIVE_MODEL } from \"./models.ts\";\nimport { addDays, mountainCalendarDate } from \"./dates.ts\";\n\nexport function clamp(value: number, min: number, max: number): number {\n return Math.min(max, Math.max(min, value));\n}\n\nfunction runTree(tree: any, values: number[]): number {\n let node = 0;\n while (Number(tree.feature[node]) >= 0) {\n const featureIndex = Number(tree.feature[node]);\n node = values[featureIndex] <= Number(tree.threshold[node])\n ? Number(tree.left[node])\n : Number(tree.right[node]);\n }\n return Number(tree.value[node]);\n}\n\nexport function runRightNowModel(\n name: string,\n featureMap: Record,\n): number | null {\n const model: any = (RIGHT_NOW_MODELS as any)[name];\n if (!model) return null;\n const values = model.features.map((feature: string) =>\n Number(featureMap[feature])\n );\n if (values.some((value: number) => !Number.isFinite(value))) return null;\n if (model.type === \"gradient_boost\") {\n return Number(model.init) +\n model.trees.reduce(\n (sum: number, tree: any) =>\n sum + Number(model.learningRate) * runTree(tree, values),\n 0,\n );\n }\n let estimate = Number(model.intercept) || 0;\n for (let index = 0; index < model.features.length; index += 1) {\n const scale = Math.abs(Number(model.scale[index])) > 1e-9\n ? Number(model.scale[index])\n : 1;\n estimate += ((values[index] - Number(model.mean[index])) / scale) *\n Number(model.coef[index]);\n }\n return estimate;\n}\n\nexport function tubingOpeningForecast(\n features: Record,\n fromDate: Date,\n): Date {\n const model: any = TUBING_OPEN_LIVE_MODEL;\n let estimate = Number(model.intercept) || 0;\n for (let index = 0; index < model.features.length; index += 1) {\n const raw = Number(features[model.features[index]]);\n if (!Number.isFinite(raw)) {\n throw new Error(\n `Missing tubing-opening feature ${model.features[index]}`,\n );\n }\n const scale = Math.abs(Number(model.scale[index])) > 1e-9\n ? Number(model.scale[index])\n : 1;\n estimate += ((raw - Number(model.mean[index])) / scale) *\n Number(model.coef[index]);\n }\n return addDays(\n mountainCalendarDate(fromDate),\n Math.round(clamp(estimate, 0, 70)),\n );\n}","createdAt",["D",1788883225618],"branchVersion","branchId","70817041-1dfa-4778-885e-ac83be02b1d0","id","f84d0eeb-ceea-4772-8eb3-fa7a8cedbc13","black-hat-hydrology",["D",1788718960405],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","San Juan River seasonal prediction tracker","imageUrl","66be13f3-dd08-4f8a-aca1-8697006c9a46","pinnedFileId","0210c8ee-aa20-11f1-a516-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a077f2-9ad7-764c-8f6b-583a36c43414","tursoName","f84d0eebceea47728eb3fa7a8cedbc13","tursoHostname","f84d0eebceea47728eb3fa7a8cedbc13-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789575110896],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",268,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pagosaoutside","handle","displayName","Pagosa Outside","avatar","https://lh3.googleusercontent.com/a/ACg8ocLkPUw3N28PFDWb5so2_Azzb6wOyGiti-gB56AMhHTn6R7IXJA6Ug=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":473,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":474,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":475,"_84":476,"_86":477,"_88":25},"tree",[360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387],"files",[360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387],"counts",{"_350":63,"_351":233,"_352":63,"_353":354,"_355":356},"contents",[131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":344,"_32":345,"_30":346,"_162":-5,"_41":42,"_40":347,"_164":59,"_38":348,"_13":253,"_34":35,"_36":327,"_24":25,"_168":-5,"_27":349},{"_43":341,"_32":28,"_30":31,"_162":-5,"_41":42,"_40":14,"_164":59,"_38":342,"_13":253,"_34":35,"_36":37,"_24":25,"_168":-5,"_27":343},{"_43":335,"_32":336,"_30":337,"_162":-5,"_41":42,"_40":338,"_164":59,"_38":339,"_13":166,"_34":35,"_36":110,"_24":25,"_168":-5,"_27":340},{"_43":329,"_32":330,"_30":331,"_162":-5,"_41":42,"_40":332,"_164":59,"_38":333,"_13":253,"_34":35,"_36":167,"_24":25,"_168":-5,"_27":334},{"_43":322,"_32":323,"_30":324,"_162":-5,"_41":42,"_40":325,"_164":59,"_38":326,"_13":166,"_34":35,"_36":327,"_24":25,"_168":-5,"_27":328},{"_43":313,"_32":314,"_30":315,"_162":-5,"_41":42,"_40":316,"_164":25,"_38":317,"_13":318,"_34":319,"_36":320,"_24":25,"_168":-5,"_27":321},{"_43":306,"_32":307,"_30":308,"_162":-5,"_41":42,"_40":309,"_164":59,"_38":310,"_13":253,"_34":35,"_36":311,"_24":25,"_168":-5,"_27":312},{"_43":300,"_32":301,"_30":302,"_162":-5,"_41":42,"_40":303,"_164":59,"_38":304,"_13":212,"_34":35,"_36":298,"_24":25,"_168":-5,"_27":305},{"_43":293,"_32":294,"_30":295,"_162":-5,"_41":42,"_40":296,"_164":25,"_38":297,"_13":166,"_34":35,"_36":298,"_24":25,"_168":-5,"_27":299},{"_43":287,"_32":288,"_30":289,"_162":-5,"_41":42,"_40":290,"_164":25,"_38":291,"_13":233,"_34":35,"_36":110,"_24":25,"_168":-5,"_27":292},{"_43":281,"_32":282,"_30":283,"_162":-5,"_41":42,"_40":284,"_164":25,"_38":285,"_13":166,"_34":35,"_36":110,"_24":25,"_168":-5,"_27":286},{"_43":275,"_32":276,"_30":277,"_162":-5,"_41":42,"_40":278,"_164":25,"_38":279,"_13":233,"_34":35,"_36":110,"_24":25,"_168":-5,"_27":280},{"_43":269,"_32":270,"_30":271,"_162":-5,"_41":42,"_40":272,"_164":25,"_38":273,"_13":233,"_34":35,"_36":110,"_24":25,"_168":-5,"_27":274},{"_43":263,"_32":264,"_30":265,"_162":-5,"_41":42,"_40":266,"_164":25,"_38":267,"_13":233,"_34":35,"_36":110,"_24":25,"_168":-5,"_27":268},{"_43":257,"_32":258,"_30":259,"_162":-5,"_41":42,"_40":166,"_164":59,"_38":260,"_13":63,"_34":254,"_36":261,"_24":25,"_168":-5,"_27":262},{"_43":249,"_32":250,"_30":57,"_162":-5,"_41":42,"_40":251,"_164":25,"_38":252,"_13":253,"_34":254,"_36":255,"_24":25,"_168":-5,"_27":256},{"_43":242,"_32":243,"_30":244,"_162":-5,"_41":42,"_40":245,"_164":59,"_38":246,"_13":247,"_34":35,"_36":37,"_24":25,"_168":-5,"_27":248},{"_43":235,"_32":236,"_30":237,"_162":-5,"_41":42,"_40":238,"_164":25,"_38":239,"_13":166,"_34":35,"_36":240,"_24":25,"_168":-5,"_27":241},{"_43":228,"_32":229,"_30":230,"_162":-5,"_41":42,"_40":231,"_164":25,"_38":232,"_13":233,"_34":35,"_36":110,"_24":25,"_168":-5,"_27":234},{"_43":221,"_32":222,"_30":223,"_162":-5,"_41":42,"_40":224,"_164":59,"_38":225,"_13":212,"_34":35,"_36":226,"_24":25,"_168":-5,"_27":227},{"_43":215,"_32":216,"_30":217,"_162":-5,"_41":42,"_40":218,"_164":25,"_38":219,"_13":166,"_34":35,"_36":37,"_24":25,"_168":-5,"_27":220},{"_43":207,"_32":208,"_30":209,"_162":-5,"_41":42,"_40":210,"_164":59,"_38":211,"_13":212,"_34":35,"_36":213,"_24":25,"_168":-5,"_27":214},{"_43":200,"_32":201,"_30":202,"_162":-5,"_41":42,"_40":203,"_164":25,"_38":204,"_13":166,"_34":35,"_36":205,"_24":25,"_168":-5,"_27":206},{"_43":192,"_32":193,"_30":194,"_162":-5,"_41":42,"_40":195,"_164":59,"_38":196,"_13":197,"_34":35,"_36":198,"_24":25,"_168":-5,"_27":199},{"_43":185,"_32":186,"_30":187,"_162":-5,"_41":42,"_40":188,"_164":25,"_38":189,"_13":166,"_34":35,"_36":190,"_24":25,"_168":-5,"_27":191},{"_43":177,"_32":178,"_30":179,"_162":-5,"_41":42,"_40":180,"_164":59,"_38":181,"_13":182,"_34":35,"_36":183,"_24":25,"_168":-5,"_27":184},{"_43":170,"_32":171,"_30":172,"_162":-5,"_41":42,"_40":173,"_164":25,"_38":174,"_13":166,"_34":35,"_36":175,"_24":25,"_168":-5,"_27":176},{"_43":159,"_32":160,"_30":161,"_162":-5,"_41":42,"_40":163,"_164":59,"_38":165,"_13":166,"_34":35,"_36":167,"_24":25,"_168":-5,"_27":169},"752142de-63ba-40ff-92c7-26b4d01d0d9f","types.ts","656d2dcc-ab9e-11f1-b4be-1607ee4eb77e","parentId",110,"latest",["D",1788883223981],2,"export type FlowPoint = { date: Date; value: number };\nexport type SnowPoint = { date: Date; value: number; median?: number | null };\nexport type Snotel = Record>;\n\nexport type BasinSnapshot = {\n capturedAt: Date;\n cutoffAt: Date;\n current: FlowPoint;\n instantaneous: FlowPoint[];\n dailyFlow: FlowPoint[];\n snotel: Snotel;\n features: Record;\n milestones: Milestones;\n sourceStatus: Record;\n};\n\nexport type Milestones = {\n runoffYear: number;\n laborDay: Date;\n first400: FlowPoint | null;\n peakDaily: FlowPoint | null;\n peakInstant: FlowPoint | null;\n peakFlowLikelyPassed: boolean;\n tubingForecastTrigger: FlowPoint | null;\n tubingOpening: Date | null;\n counts: { p300: number; p600: number; p800: number; tubing: number };\n strength: number | null;\n persistentSnow: SnowPoint | null;\n peakSwe: SnowPoint | null;\n peakSweLikelyPassed: boolean;\n};\n\nexport type PredictionValue = Record;\n\nexport type QuestionDefinition = {\n number: number;\n key: string;\n title: string;\n issueKind: \"fixed\" | \"event\";\n issueMonth?: number;\n issueDay?: number;\n trigger?: (snapshot: BasinSnapshot) => Date | null;\n calculate: (snapshot: BasinSnapshot) => PredictionValue;\n actual: (snapshot: BasinSnapshot) => PredictionValue | null;\n final: (snapshot: BasinSnapshot) => boolean;\n score: (prediction: PredictionValue, actual: PredictionValue) => boolean;\n};","label",[160],"797b584d-8fe8-4a0e-97f0-88c8e515d645","storage.ts","e05769d6-ab9d-11f1-8b5e-1607ee4eb77e",88,["D",1788883011380],"import { CONFIG } from \"./config.ts\";\nimport {\n addDays,\n firstMondayOfSeptember,\n isoDay,\n mountainCalendarDate,\n waterYear,\n} from \"./dates.ts\";\nimport type { BasinSnapshot, FlowPoint, Milestones, Snotel } from \"./types.ts\";\n\nconst average = (values: unknown[]): number | null => {\n const valid = values.map(Number).filter(Number.isFinite);\n return valid.length\n ? valid.reduce((sum, value) => sum + value, 0) / valid.length\n : null;\n};\n\nasync function fetchJson(url: string, timeout = 20_000): Promise {\n const controller = new AbortController();\n const timer = setTimeout(() => controller.abort(), timeout);\n try {\n const response = await fetch(url, {\n signal: controller.signal,\n headers: { Accept: \"application/json\" },\n });\n if (!response.ok) {\n const parsed = new URL(url);\n throw new Error(\n `${parsed.hostname}${parsed.pathname} returned ${response.status}`,\n );\n }\n return await response.json();\n } finally {\n clearTimeout(timer);\n }\n}\n\nfunction parseUsgs(payload: any, cutoffAt: Date): FlowPoint[] {\n const series = payload?.value?.timeSeries?.[0]?.values?.[0]?.value || [];\n return series.map((item: any) => ({\n date: new Date(item.dateTime),\n value: Number(item.value),\n }))\n .filter((item: FlowPoint) =>\n !Number.isNaN(item.date.getTime()) && item.date <= cutoffAt &&\n Number.isFinite(item.value) && item.value >= 0\n )\n .sort((a: FlowPoint, b: FlowPoint) => a.date.getTime() - b.date.getTime());\n}\n\nfunction parseSnotel(payload: any, cutoffAt: Date): Snotel {\n const output: Snotel = {};\n for (const station of payload || []) {\n const stationId = String(station.stationTriplet);\n output[stationId] ||= {};\n for (const series of station.data || []) {\n const code = series.stationElement?.elementCode;\n if (!code) continue;\n output[stationId][code] = (series.values || []).map((item: any) => ({\n date: new Date(`${item.date}T12:00:00Z`),\n value: Number(item.value),\n median: item.median === null || item.median === undefined\n ? null\n : Number(item.median),\n })).filter((item: any) =>\n !Number.isNaN(item.date.getTime()) && item.date <= cutoffAt &&\n Number.isFinite(item.value)\n );\n }\n }\n return output;\n}\n\nfunction latestAtOrBefore(\n points: T[],\n date: Date,\n): T | null {\n const eligible = (points || []).filter((point) => point.date <= date);\n return eligible.length ? eligible[eligible.length - 1] : null;\n}\n\nfunction stationAverage(\n snotel: Snotel,\n element: string,\n date: Date,\n field: \"value\" | \"median\" = \"value\",\n): number | null {\n return average(\n Object.values(snotel).map((station) =>\n (latestAtOrBefore(station[element] || [], date) as any)?.[field]\n ),\n );\n}\n\nfunction waterYearDay(date: Date): number {\n const year = date.getUTCMonth() >= 9\n ? date.getUTCFullYear()\n : date.getUTCFullYear() - 1;\n return Math.round(\n (Date.UTC(date.getUTCFullYear(), date.getUTCMonth(), date.getUTCDate()) -\n Date.UTC(year, 9, 1)) / 86_400_000,\n );\n}\n\nfunction buildFeatures(\n flowDaily: FlowPoint[],\n currentFlow: number,\n snotel: Snotel,\n now: Date,\n): Record {\n const date7 = addDays(now, -7);\n const date30 = addDays(now, -30);\n const recent7 = flowDaily.filter((point) =>\n point.date >= date7 && point.date <= now\n ).map((point) => point.value);\n const recent30 = flowDaily.filter((point) =>\n point.date >= date30 && point.date <= now\n ).map((point) => point.value);\n const flow7Ago = latestAtOrBefore(flowDaily, date7)?.value ?? currentFlow;\n const flowMean7 = average(recent7) ?? currentFlow;\n const flowMean30 = average(recent30) ?? flowMean7;\n const swe = stationAverage(snotel, \"WTEQ\", now) ?? 0;\n const sweMedian = stationAverage(snotel, \"WTEQ\", now, \"median\") ?? 0;\n const swe7Ago = stationAverage(snotel, \"WTEQ\", date7) ?? swe;\n const sweRatio = sweMedian > 0.05\n ? Math.min(3, Math.max(0, swe / sweMedian))\n : swe <= 0.05\n ? 0\n : 3;\n const stationIds = Object.keys(snotel);\n const temperatures: number[] = [];\n for (const id of stationIds) {\n for (const point of snotel[id].TAVG || []) {\n if (point.date >= date7 && point.date <= now) {\n temperatures.push(point.value);\n }\n }\n }\n const temp7 = average(temperatures) ?? 32;\n const precipitationChange = (startDate: Date) =>\n average(stationIds.map((id) => {\n const current = latestAtOrBefore(snotel[id].PREC || [], now)?.value;\n const earlier = latestAtOrBefore(snotel[id].PREC || [], startDate)?.value;\n return Number.isFinite(current) && Number.isFinite(earlier)\n ? Math.max(0, Number(current) - Number(earlier))\n : null;\n })) ?? 0;\n const precip7 = precipitationChange(date7);\n const precip30 = precipitationChange(date30);\n const snowPresent = swe > 0.05 ? 1 : 0;\n const angle = 2 * Math.PI * waterYearDay(now) / 365.25;\n return {\n log_flow: Math.log1p(currentFlow),\n log_flow_mean_7d: Math.log1p(flowMean7),\n log_flow_mean_30d: Math.log1p(flowMean30),\n relative_flow_change_7d: (currentFlow - flow7Ago) /\n (Math.abs(flowMean7) + 30),\n swe_in: swe,\n swe_ratio: sweRatio,\n swe_change_7d: swe - swe7Ago,\n temperature_scaled: (temp7 - 32) / 20,\n prec_total_7d: precip7,\n prec_total_30d: precip30,\n snow_present: snowPresent,\n season_sin: Math.sin(angle),\n season_cos: Math.cos(angle),\n season_sin_2: Math.sin(2 * angle),\n season_cos_2: Math.cos(2 * angle),\n melt_pressure: swe * Math.max(temp7 - 32, 0) / 100,\n rain_without_snow: precip7 * (1 - snowPresent),\n current_flow: currentFlow,\n swe_median: sweMedian,\n temp_7d: temp7,\n precip_7d: precip7,\n };\n}\n\nasync function fetchInstantaneousPeak(\n dailyFlow: FlowPoint[],\n runoffYear: number,\n cutoffAt: Date,\n): Promise {\n const start = new Date(Date.UTC(runoffYear, 3, 1));\n const end = new Date(\n Math.min(cutoffAt.getTime(), Date.UTC(runoffYear, 6, 31, 23, 59)),\n );\n const candidate = dailyFlow.filter((item) =>\n item.date >= start && item.date <= end\n )\n .reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n if (!candidate) return null;\n const url =\n `https://waterservices.usgs.gov/nwis/iv/?format=json&sites=${CONFIG.usgsSite}&startDT=${\n isoDay(addDays(candidate.date, -1))\n }&endDT=${\n isoDay(addDays(candidate.date, 2))\n }¶meterCd=00060&siteStatus=all`;\n const values = parseUsgs(await fetchJson(url), cutoffAt);\n return values.reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n}\n\nfunction findTubingOpening(\n series: FlowPoint[],\n after: Date | null,\n): Date | null {\n if (!after) return null;\n const ordered = series.filter((item) => item.date > after).sort((a, b) =>\n a.date.getTime() - b.date.getTime()\n );\n for (let index = 0; index < ordered.length; index += 1) {\n const endPoint = ordered[index];\n const startTime = endPoint.date.getTime() - 24 * 3_600_000;\n const window = ordered.filter((item) =>\n item.date.getTime() >= startTime && item.date <= endPoint.date\n );\n if (window.length < 4) continue;\n if (\n window.at(-1)!.date.getTime() - window[0].date.getTime() < 23 * 3_600_000\n ) continue;\n if (window.every((item) => item.value >= 30 && item.value < 400)) {\n return endPoint.date;\n }\n }\n return null;\n}\n\nfunction deriveMilestones(\n dailyFlow: FlowPoint[],\n instantaneous: FlowPoint[],\n snotel: Snotel,\n current: FlowPoint,\n peakInstant: FlowPoint | null,\n): Milestones {\n const runoffYear = waterYear(current.date);\n const waterYearStart = new Date(Date.UTC(runoffYear - 1, 9, 1, 12));\n const springStart = new Date(Date.UTC(runoffYear, 2, 1, 12));\n const peakWindowStart = new Date(Date.UTC(runoffYear, 3, 1, 12));\n const peakWindowEnd = new Date(Date.UTC(runoffYear, 6, 31, 23, 59));\n const recreationStart = new Date(Date.UTC(runoffYear, 4, 1, 12));\n const laborDay = firstMondayOfSeptember(runoffYear);\n laborDay.setUTCHours(23, 59, 59, 999);\n const waterYearDaily = dailyFlow.filter((item) =>\n item.date >= waterYearStart && item.date <= current.date\n );\n const springDaily = waterYearDaily.filter((item) => item.date >= springStart);\n const first400 = springDaily.find((item) => item.value >= 400) || null;\n const peakDaily = springDaily.filter((item) =>\n item.date >= peakWindowStart && item.date <= peakWindowEnd\n )\n .reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n const daysSincePeak = peakDaily\n ? Math.floor(\n (current.date.getTime() - peakDaily.date.getTime()) / 86_400_000,\n )\n : 0;\n const dropFromPeak = peakDaily?.value\n ? 1 - current.value / peakDaily.value\n : 0;\n const peakFlowLikelyPassed = Boolean(\n peakDaily && daysSincePeak >= 6 && dropFromPeak >= 0.18,\n );\n let tubingForecastTrigger: FlowPoint | null = null;\n if (peakDaily) {\n const peakIndex = springDaily.findIndex((item) =>\n isoDay(item.date) === isoDay(peakDaily.date) &&\n item.value === peakDaily.value\n );\n for (\n let index = Math.max(2, peakIndex + 1);\n index < springDaily.length;\n index += 1\n ) {\n const item = springDaily[index];\n const fallingThreeDay = item.value < springDaily[index - 2].value;\n const eligible = peakDaily.value >= 800\n ? item.value < 800\n : peakFlowLikelyPassed;\n if (eligible && fallingThreeDay) {\n tubingForecastTrigger = item;\n break;\n }\n }\n }\n const dailyTubingFallback = peakDaily\n ? springDaily.find((item) =>\n item.date > peakDaily.date && item.value >= 30 && item.value < 400\n )?.date || null\n : null;\n const tubingOpening =\n findTubingOpening(instantaneous, peakDaily?.date || null) ||\n dailyTubingFallback;\n const seasonDaily = waterYearDaily.filter((item) =>\n item.date >= recreationStart && item.date <= laborDay &&\n item.date <= current.date\n );\n const counts = {\n p300: seasonDaily.filter((item) => item.value >= 300).length,\n p600: seasonDaily.filter((item) => item.value >= 600).length,\n p800: seasonDaily.filter((item) => item.value >= 800).length,\n tubing:\n seasonDaily.filter((item) => item.value >= 30 && item.value < 400).length,\n };\n const strengthDays = waterYearDaily.filter((item) =>\n item.date >= recreationStart &&\n item.date <= new Date(Date.UTC(runoffYear, 5, 30, 23, 59))\n );\n const strength = average(strengthDays.map((item) => item.value));\n const snowDates = [\n ...new Set(\n Object.values(snotel).flatMap((station) =>\n (station.WTEQ || []).map((item) => isoDay(item.date))\n ),\n ),\n ]\n .map((value) => new Date(`${value}T12:00:00Z`)).filter((date) =>\n date >= waterYearStart && date <= current.date\n ).sort((a, b) => a.getTime() - b.getTime());\n const snowSeries = snowDates.map((date) => ({\n date,\n value: stationAverage(snotel, \"WTEQ\", date),\n }))\n .filter((item): item is { date: Date; value: number } =>\n Number.isFinite(item.value)\n );\n let persistentSnow = null;\n for (let index = 0; index <= snowSeries.length - 7; index += 1) {\n const window = snowSeries.slice(index, index + 7);\n if (window[0].value >= 1 && window.every((item) => item.value >= 0.5)) {\n persistentSnow = window[0];\n break;\n }\n }\n const peakSwe = snowSeries.reduce<{ date: Date; value: number } | null>(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n const daysSincePeakSwe = peakSwe\n ? Math.floor((current.date.getTime() - peakSwe.date.getTime()) / 86_400_000)\n : 0;\n const currentSwe = snowSeries.at(-1)?.value || 0;\n const peakSweLikelyPassed = Boolean(\n peakSwe && peakSwe.value >= 1 && daysSincePeakSwe >= 14 &&\n currentSwe <= peakSwe.value * 0.7,\n );\n return {\n runoffYear,\n laborDay,\n first400,\n peakDaily,\n peakInstant,\n peakFlowLikelyPassed,\n tubingForecastTrigger,\n tubingOpening,\n counts,\n strength,\n persistentSnow,\n peakSwe,\n peakSweLikelyPassed,\n };\n}\n\nexport async function fetchBasinSnapshot(\n cutoffAt = new Date(),\n): Promise {\n const runoffYear = waterYear(cutoffAt);\n // Models use 7- and 30-day history. Starting 45 days before the water year\n // also prevents the October 1 lock from running with an empty daily series.\n const waterYearStart = new Date(Date.UTC(runoffYear - 1, 9, 1, 12));\n const start = isoDay(addDays(waterYearStart, -45));\n const end = isoDay(cutoffAt);\n const dailyUrl =\n `https://waterservices.usgs.gov/nwis/dv/?format=json&sites=${CONFIG.usgsSite}&startDT=${start}&endDT=${end}¶meterCd=00060&statCd=00003&siteStatus=all`;\n const instantUrl =\n `https://waterservices.usgs.gov/nwis/iv/?format=json&sites=${CONFIG.usgsSite}&period=P60D¶meterCd=00060&siteStatus=all`;\n const stationParam = encodeURIComponent(CONFIG.snotelStations.join(\",\"));\n const snotelUrl =\n `https://wcc.sc.egov.usda.gov/awdbRestApi/services/v1/data?stationTriplets=${stationParam}&elements=WTEQ%2CSNWD%2CPREC%2CTAVG&duration=DAILY&beginDate=${start}&endDate=${end}&periodRef=END¢ralTendencyType=MEDIAN&returnFlags=false&returnOriginalValues=false&returnSuspectData=false`;\n const [dailyPayload, instantPayload, snowPayload] = await Promise.all([\n fetchJson(dailyUrl),\n fetchJson(instantUrl),\n fetchJson(snotelUrl),\n ]);\n const dailyFlow = parseUsgs(dailyPayload, cutoffAt);\n const instantaneous = parseUsgs(instantPayload, cutoffAt);\n if (!dailyFlow.length || !instantaneous.length) {\n throw new Error(\"The Pagosa USGS gauge did not return enough data\");\n }\n const snotel = parseSnotel(snowPayload, cutoffAt);\n if (!Object.keys(snotel).length) {\n throw new Error(\"The headwater SNOTEL stations did not return enough data\");\n }\n const latestSnotelAt = Object.values(snotel)\n .flatMap((station) => Object.values(station).flat())\n .reduce(\n (latest, point) => !latest || point.date > latest ? point.date : latest,\n null,\n );\n const current = instantaneous.at(-1)!;\n const features = buildFeatures(\n dailyFlow,\n current.value,\n snotel,\n current.date,\n );\n const peakInstant = await fetchInstantaneousPeak(\n dailyFlow,\n runoffYear,\n cutoffAt,\n ).catch(() => null);\n const milestones = deriveMilestones(\n dailyFlow,\n instantaneous,\n snotel,\n current,\n peakInstant,\n );\n return {\n capturedAt: new Date(),\n cutoffAt,\n current,\n instantaneous,\n dailyFlow,\n snotel,\n features,\n milestones,\n sourceStatus: {\n usgs_site: CONFIG.usgsSite,\n usgs_latest_at: current.date.toISOString(),\n usgs_daily_points: dailyFlow.length,\n usgs_instant_points: instantaneous.length,\n snotel_stations: Object.keys(snotel),\n snotel_latest_day: latestSnotelAt ? isoDay(latestSnotelAt) : null,\n },\n };\n}\n// Val-scoped SQLite keeps this project's records isolated and returns rows as\n// named objects (the legacy account-global database returns arrays).\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type StoredPrediction = {\n water_year: number;\n question_number: number;\n question_key: string;\n title: string;\n mode: string;\n issue_kind: string;\n issue_due_at: string;\n locked_at: string;\n input_cutoff_at: string;\n model_version: string;\n model_hash: string;\n prediction_json: string;\n inputs_json: string;\n inputs_hash: string;\n source_status_json: string;\n status: string;\n actual_json: string | null;\n score: string | null;\n scored_at: string | null;\n};\n\nexport async function initDb(): Promise {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS bh_seasons (\n water_year INTEGER PRIMARY KEY,\n opened_at TEXT NOT NULL,\n state TEXT NOT NULL DEFAULT 'active',\n model_bundle_version TEXT NOT NULL,\n completed_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_predictions (\n water_year INTEGER NOT NULL,\n question_number INTEGER NOT NULL,\n question_key TEXT NOT NULL,\n title TEXT NOT NULL,\n mode TEXT NOT NULL CHECK(mode IN ('shadow','live')),\n issue_kind TEXT NOT NULL,\n issue_due_at TEXT NOT NULL,\n locked_at TEXT NOT NULL,\n input_cutoff_at TEXT NOT NULL,\n model_version TEXT NOT NULL,\n model_hash TEXT NOT NULL,\n prediction_json TEXT NOT NULL,\n inputs_json TEXT NOT NULL,\n inputs_hash TEXT NOT NULL,\n source_status_json TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'locked',\n actual_json TEXT,\n score TEXT CHECK(score IN ('hit','miss') OR score IS NULL),\n scored_at TEXT,\n PRIMARY KEY (water_year, question_number, mode)\n )`,\n `CREATE TABLE IF NOT EXISTS bh_runs (\n id TEXT PRIMARY KEY,\n ran_at TEXT NOT NULL,\n mode TEXT NOT NULL,\n success INTEGER NOT NULL,\n message TEXT NOT NULL,\n source_status_json TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n water_year INTEGER NOT NULL,\n question_number INTEGER,\n event_type TEXT NOT NULL,\n occurred_at TEXT NOT NULL,\n payload_json TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS bh_public_cache (\n cache_key TEXT PRIMARY KEY,\n value_json TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TRIGGER IF NOT EXISTS bh_locked_prediction_immutable\n BEFORE UPDATE OF issue_due_at, locked_at, input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash\n ON bh_predictions\n BEGIN SELECT RAISE(ABORT, 'Locked Black Hat prediction fields are immutable'); END`,\n ]);\n}\n\nexport async function ensureSeason(\n waterYear: number,\n modelVersion: string,\n openedAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO bh_seasons(water_year, opened_at, model_bundle_version) VALUES (?, ?, ?)`,\n args: [waterYear, openedAt.toISOString(), modelVersion],\n });\n}\n\nexport async function getPrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND question_number=? AND mode=?`,\n args: [waterYear, questionNumber, mode],\n });\n return (result.rows[0] as any) || null;\n}\n\nexport async function lockPrediction(row: StoredPrediction): Promise {\n const result = await sqlite.execute({\n sql: `INSERT OR IGNORE INTO bh_predictions(\n water_year, question_number, question_key, title, mode, issue_kind, issue_due_at, locked_at,\n input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash,\n source_status_json, status, actual_json, score, scored_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n row.water_year,\n row.question_number,\n row.question_key,\n row.title,\n row.mode,\n row.issue_kind,\n row.issue_due_at,\n row.locked_at,\n row.input_cutoff_at,\n row.model_version,\n row.model_hash,\n row.prediction_json,\n row.inputs_json,\n row.inputs_hash,\n row.source_status_json,\n row.status,\n row.actual_json,\n row.score,\n row.scored_at,\n ],\n });\n return Number(result.rowsAffected) === 1;\n}\n\nexport async function finalizePrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n actualJson: string,\n hit: boolean,\n scoredAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `UPDATE bh_predictions SET actual_json=?, score=?, status='scored', scored_at=?\n WHERE water_year=? AND question_number=? AND mode=? AND scored_at IS NULL`,\n args: [\n actualJson,\n hit ? \"hit\" : \"miss\",\n scoredAt.toISOString(),\n waterYear,\n questionNumber,\n mode,\n ],\n });\n}\n\nexport async function recordEvent(\n waterYear: number,\n questionNumber: number | null,\n eventType: string,\n occurredAt: Date,\n payload: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_events(water_year, question_number, event_type, occurred_at, payload_json) VALUES (?, ?, ?, ?, ?)`,\n args: [\n waterYear,\n questionNumber,\n eventType,\n occurredAt.toISOString(),\n JSON.stringify(payload),\n ],\n });\n}\n\nexport async function recordRun(\n success: boolean,\n mode: string,\n message: string,\n sourceStatus: unknown = null,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_runs(id, ran_at, mode, success, message, source_status_json) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n crypto.randomUUID(),\n new Date().toISOString(),\n mode,\n success ? 1 : 0,\n message,\n sourceStatus ? JSON.stringify(sourceStatus) : null,\n ],\n });\n}\n\nexport async function listPredictions(\n waterYear: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND mode=? ORDER BY question_number`,\n args: [waterYear, mode],\n });\n return result.rows as any;\n}\n\nexport async function recentRuns(limit = 10): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT ran_at, mode, success, message, source_status_json FROM bh_runs ORDER BY ran_at DESC LIMIT ?`,\n args: [limit],\n });\n return result.rows as any;\n}\n\nexport async function cachePublicFeed(\n key: string,\n value: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_public_cache(cache_key, value_json, updated_at) VALUES (?, ?, ?)\n ON CONFLICT(cache_key) DO UPDATE SET value_json=excluded.value_json, updated_at=excluded.updated_at`,\n args: [key, JSON.stringify(value), new Date().toISOString()],\n });\n}\n\nexport async function getPublicFeed(\n key: string,\n): Promise<{ value: any; updatedAt: string } | null> {\n const result = await sqlite.execute({\n sql: `SELECT value_json, updated_at FROM bh_public_cache WHERE cache_key=?`,\n args: [key],\n });\n const row: any = result.rows[0];\n return row\n ? {\n value: JSON.parse(String(row.value_json)),\n updatedAt: String(row.updated_at),\n }\n : null;\n}",[171],"1cee68bb-501e-42c3-b4e0-e9c6869d0c41","storage-old.ts","a3869a0c-ab9a-11f1-b55c-1607ee4eb77e",82,["D",1788882997593],4,"// Val-scoped SQLite keeps this project's records isolated and returns rows as\n// named objects (the legacy account-global database returns arrays).\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type StoredPrediction = {\n water_year: number;\n question_number: number;\n question_key: string;\n title: string;\n mode: string;\n issue_kind: string;\n issue_due_at: string;\n locked_at: string;\n input_cutoff_at: string;\n model_version: string;\n model_hash: string;\n prediction_json: string;\n inputs_json: string;\n inputs_hash: string;\n source_status_json: string;\n status: string;\n actual_json: string | null;\n score: string | null;\n scored_at: string | null;\n};\n\nexport async function initDb(): Promise {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS bh_seasons (\n water_year INTEGER PRIMARY KEY,\n opened_at TEXT NOT NULL,\n state TEXT NOT NULL DEFAULT 'active',\n model_bundle_version TEXT NOT NULL,\n completed_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_predictions (\n water_year INTEGER NOT NULL,\n question_number INTEGER NOT NULL,\n question_key TEXT NOT NULL,\n title TEXT NOT NULL,\n mode TEXT NOT NULL CHECK(mode IN ('shadow','live')),\n issue_kind TEXT NOT NULL,\n issue_due_at TEXT NOT NULL,\n locked_at TEXT NOT NULL,\n input_cutoff_at TEXT NOT NULL,\n model_version TEXT NOT NULL,\n model_hash TEXT NOT NULL,\n prediction_json TEXT NOT NULL,\n inputs_json TEXT NOT NULL,\n inputs_hash TEXT NOT NULL,\n source_status_json TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'locked',\n actual_json TEXT,\n score TEXT CHECK(score IN ('hit','miss') OR score IS NULL),\n scored_at TEXT,\n PRIMARY KEY (water_year, question_number, mode)\n )`,\n `CREATE TABLE IF NOT EXISTS bh_runs (\n id TEXT PRIMARY KEY,\n ran_at TEXT NOT NULL,\n mode TEXT NOT NULL,\n success INTEGER NOT NULL,\n message TEXT NOT NULL,\n source_status_json TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n water_year INTEGER NOT NULL,\n question_number INTEGER,\n event_type TEXT NOT NULL,\n occurred_at TEXT NOT NULL,\n payload_json TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS bh_public_cache (\n cache_key TEXT PRIMARY KEY,\n value_json TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TRIGGER IF NOT EXISTS bh_locked_prediction_immutable\n BEFORE UPDATE OF issue_due_at, locked_at, input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash\n ON bh_predictions\n BEGIN SELECT RAISE(ABORT, 'Locked Black Hat prediction fields are immutable'); END`,\n ]);\n}\n\nexport async function ensureSeason(\n waterYear: number,\n modelVersion: string,\n openedAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO bh_seasons(water_year, opened_at, model_bundle_version) VALUES (?, ?, ?)`,\n args: [waterYear, openedAt.toISOString(), modelVersion],\n });\n}\n\nexport async function getPrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND question_number=? AND mode=?`,\n args: [waterYear, questionNumber, mode],\n });\n return (result.rows[0] as any) || null;\n}\n\nexport async function lockPrediction(row: StoredPrediction): Promise {\n const result = await sqlite.execute({\n sql: `INSERT OR IGNORE INTO bh_predictions(\n water_year, question_number, question_key, title, mode, issue_kind, issue_due_at, locked_at,\n input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash,\n source_status_json, status, actual_json, score, scored_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n row.water_year,\n row.question_number,\n row.question_key,\n row.title,\n row.mode,\n row.issue_kind,\n row.issue_due_at,\n row.locked_at,\n row.input_cutoff_at,\n row.model_version,\n row.model_hash,\n row.prediction_json,\n row.inputs_json,\n row.inputs_hash,\n row.source_status_json,\n row.status,\n row.actual_json,\n row.score,\n row.scored_at,\n ],\n });\n return Number(result.rowsAffected) === 1;\n}\n\nexport async function finalizePrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n actualJson: string,\n hit: boolean,\n scoredAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `UPDATE bh_predictions SET actual_json=?, score=?, status='scored', scored_at=?\n WHERE water_year=? AND question_number=? AND mode=? AND scored_at IS NULL`,\n args: [\n actualJson,\n hit ? \"hit\" : \"miss\",\n scoredAt.toISOString(),\n waterYear,\n questionNumber,\n mode,\n ],\n });\n}\n\nexport async function recordEvent(\n waterYear: number,\n questionNumber: number | null,\n eventType: string,\n occurredAt: Date,\n payload: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_events(water_year, question_number, event_type, occurred_at, payload_json) VALUES (?, ?, ?, ?, ?)`,\n args: [\n waterYear,\n questionNumber,\n eventType,\n occurredAt.toISOString(),\n JSON.stringify(payload),\n ],\n });\n}\n\nexport async function recordRun(\n success: boolean,\n mode: string,\n message: string,\n sourceStatus: unknown = null,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_runs(id, ran_at, mode, success, message, source_status_json) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n crypto.randomUUID(),\n new Date().toISOString(),\n mode,\n success ? 1 : 0,\n message,\n sourceStatus ? JSON.stringify(sourceStatus) : null,\n ],\n });\n}\n\nexport async function listPredictions(\n waterYear: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND mode=? ORDER BY question_number`,\n args: [waterYear, mode],\n });\n return result.rows as any;\n}\n\nexport async function recentRuns(limit = 10): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT ran_at, mode, success, message, source_status_json FROM bh_runs ORDER BY ran_at DESC LIMIT ?`,\n args: [limit],\n });\n return result.rows as any;\n}\n\nexport async function cachePublicFeed(\n key: string,\n value: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_public_cache(cache_key, value_json, updated_at) VALUES (?, ?, ?)\n ON CONFLICT(cache_key) DO UPDATE SET value_json=excluded.value_json, updated_at=excluded.updated_at`,\n args: [key, JSON.stringify(value), new Date().toISOString()],\n });\n}\n\nexport async function getPublicFeed(\n key: string,\n): Promise<{ value: any; updatedAt: string } | null> {\n const result = await sqlite.execute({\n sql: `SELECT value_json, updated_at FROM bh_public_cache WHERE cache_key=?`,\n args: [key],\n });\n const row: any = result.rows[0];\n return row\n ? {\n value: JSON.parse(String(row.value_json)),\n updatedAt: String(row.updated_at),\n }\n : null;\n}\n\n// Val-scoped SQLite keeps this project's records isolated and returns rows as\n// named objects (the legacy account-global database returns arrays).\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type StoredPrediction = {\n water_year: number;\n question_number: number;\n question_key: string;\n title: string;\n mode: string;\n issue_kind: string;\n issue_due_at: string;\n locked_at: string;\n input_cutoff_at: string;\n model_version: string;\n model_hash: string;\n prediction_json: string;\n inputs_json: string;\n inputs_hash: string;\n source_status_json: string;\n status: string;\n actual_json: string | null;\n score: string | null;\n scored_at: string | null;\n};\n\nexport async function initDb(): Promise {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS bh_seasons (\n water_year INTEGER PRIMARY KEY,\n opened_at TEXT NOT NULL,\n state TEXT NOT NULL DEFAULT 'active',\n model_bundle_version TEXT NOT NULL,\n completed_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_predictions (\n water_year INTEGER NOT NULL,\n question_number INTEGER NOT NULL,\n question_key TEXT NOT NULL,\n title TEXT NOT NULL,\n mode TEXT NOT NULL CHECK(mode IN ('shadow','live')),\n issue_kind TEXT NOT NULL,\n issue_due_at TEXT NOT NULL,\n locked_at TEXT NOT NULL,\n input_cutoff_at TEXT NOT NULL,\n model_version TEXT NOT NULL,\n model_hash TEXT NOT NULL,\n prediction_json TEXT NOT NULL,\n inputs_json TEXT NOT NULL,\n inputs_hash TEXT NOT NULL,\n source_status_json TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'locked',\n actual_json TEXT,\n score TEXT CHECK(score IN ('hit','miss') OR score IS NULL),\n scored_at TEXT,\n PRIMARY KEY (water_year, question_number, mode)\n )`,\n `CREATE TABLE IF NOT EXISTS bh_runs (\n id TEXT PRIMARY KEY,\n ran_at TEXT NOT NULL,\n mode TEXT NOT NULL,\n success INTEGER NOT NULL,\n message TEXT NOT NULL,\n source_status_json TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n water_year INTEGER NOT NULL,\n question_number INTEGER,\n event_type TEXT NOT NULL,\n occurred_at TEXT NOT NULL,\n payload_json TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS bh_public_cache (\n cache_key TEXT PRIMARY KEY,\n value_json TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TRIGGER IF NOT EXISTS bh_locked_prediction_immutable\n BEFORE UPDATE OF issue_due_at, locked_at, input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash\n ON bh_predictions\n BEGIN SELECT RAISE(ABORT, 'Locked Black Hat prediction fields are immutable'); END`,\n ]);\n}\n\nexport async function ensureSeason(\n waterYear: number,\n modelVersion: string,\n openedAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO bh_seasons(water_year, opened_at, model_bundle_version) VALUES (?, ?, ?)`,\n args: [waterYear, openedAt.toISOString(), modelVersion],\n });\n}\n\nexport async function getPrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND question_number=? AND mode=?`,\n args: [waterYear, questionNumber, mode],\n });\n return (result.rows[0] as any) || null;\n}\n\nexport async function lockPrediction(row: StoredPrediction): Promise {\n const result = await sqlite.execute({\n sql: `INSERT OR IGNORE INTO bh_predictions(\n water_year, question_number, question_key, title, mode, issue_kind, issue_due_at, locked_at,\n input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash,\n source_status_json, status, actual_json, score, scored_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n row.water_year,\n row.question_number,\n row.question_key,\n row.title,\n row.mode,\n row.issue_kind,\n row.issue_due_at,\n row.locked_at,\n row.input_cutoff_at,\n row.model_version,\n row.model_hash,\n row.prediction_json,\n row.inputs_json,\n row.inputs_hash,\n row.source_status_json,\n row.status,\n row.actual_json,\n row.score,\n row.scored_at,\n ],\n });\n return Number(result.rowsAffected) === 1;\n}\n\nexport async function finalizePrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n actualJson: string,\n hit: boolean,\n scoredAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `UPDATE bh_predictions SET actual_json=?, score=?, status='scored', scored_at=?\n WHERE water_year=? AND question_number=? AND mode=? AND scored_at IS NULL`,\n args: [\n actualJson,\n hit ? \"hit\" : \"miss\",\n scoredAt.toISOString(),\n waterYear,\n questionNumber,\n mode,\n ],\n });\n}\n\nexport async function recordEvent(\n waterYear: number,\n questionNumber: number | null,\n eventType: string,\n occurredAt: Date,\n payload: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_events(water_year, question_number, event_type, occurred_at, payload_json) VALUES (?, ?, ?, ?, ?)`,\n args: [\n waterYear,\n questionNumber,\n eventType,\n occurredAt.toISOString(),\n JSON.stringify(payload),\n ],\n });\n}\n\nexport async function recordRun(\n success: boolean,\n mode: string,\n message: string,\n sourceStatus: unknown = null,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_runs(id, ran_at, mode, success, message, source_status_json) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n crypto.randomUUID(),\n new Date().toISOString(),\n mode,\n success ? 1 : 0,\n message,\n sourceStatus ? JSON.stringify(sourceStatus) : null,\n ],\n });\n}\n\nexport async function listPredictions(\n waterYear: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND mode=? ORDER BY question_number`,\n args: [waterYear, mode],\n });\n return result.rows as any;\n}\n\nexport async function recentRuns(limit = 10): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT ran_at, mode, success, message, source_status_json FROM bh_runs ORDER BY ran_at DESC LIMIT ?`,\n args: [limit],\n });\n return result.rows as any;\n}\n\nexport async function cachePublicFeed(\n key: string,\n value: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_public_cache(cache_key, value_json, updated_at) VALUES (?, ?, ?)\n ON CONFLICT(cache_key) DO UPDATE SET value_json=excluded.value_json, updated_at=excluded.updated_at`,\n args: [key, JSON.stringify(value), new Date().toISOString()],\n });\n}\n\nexport async function getPublicFeed(\n key: string,\n): Promise<{ value: any; updatedAt: string } | null> {\n const result = await sqlite.execute({\n sql: `SELECT value_json, updated_at FROM bh_public_cache WHERE cache_key=?`,\n args: [key],\n });\n const row: any = result.rows[0];\n return row\n ? {\n value: JSON.parse(String(row.value_json)),\n updatedAt: String(row.updated_at),\n }\n : null;\n}",[178],"d75683d6-04e3-4f03-b5ff-2a0f3a4d020d","sources.ts","e7307cca-ab9d-11f1-ba80-1607ee4eb77e",92,["D",1788883016977],"import { MODEL_BUNDLE } from \"./models.ts\";\nimport {\n addDays,\n daysBetween,\n firstMondayOfSeptember,\n mountainCalendarDate,\n mountainToUtc,\n} from \"./dates.ts\";\nimport {\n clamp,\n runRightNowModel,\n tubingOpeningForecast,\n} from \"./model-runtime.ts\";\nimport type {\n BasinSnapshot,\n PredictionValue,\n QuestionDefinition,\n} from \"./types.ts\";\n\nfunction context(snapshot: BasinSnapshot): Record {\n const m = snapshot.milestones;\n const today = mountainCalendarDate(snapshot.cutoffAt);\n const daysLeft = Math.max(\n 0,\n Math.ceil((m.laborDay.getTime() - today.getTime()) / 86_400_000),\n );\n return {\n ...snapshot.features,\n count300: m.counts.p300,\n count600: m.counts.p600,\n count800: m.counts.p800,\n countTubing: m.counts.tubing,\n daysLeft,\n };\n}\n\nfunction requiredModel(name: string, snapshot: BasinSnapshot): number {\n const value = runRightNowModel(name, context(snapshot));\n if (!Number.isFinite(value)) {\n throw new Error(`Model ${name} could not produce a prediction`);\n }\n return Number(value);\n}\n\nfunction predictionDate(\n snapshot: BasinSnapshot,\n model: string,\n maximumDays: number,\n): Date {\n const days = Math.round(\n clamp(requiredModel(model, snapshot), 0, maximumDays),\n );\n return addDays(mountainCalendarDate(snapshot.cutoffAt), days);\n}\n\nfunction countRemainingTubingDays(snapshot: BasinSnapshot): number | null {\n const opening = snapshot.milestones.tubingOpening;\n if (!opening) return null;\n const start = addDays(mountainCalendarDate(opening), 1);\n return snapshot.dailyFlow.filter((item) =>\n item.date >= start && item.date <= snapshot.milestones.laborDay &&\n item.value >= 30 && item.value < 400\n ).length;\n}\n\nconst dateActual = (date: Date | null, key = \"date\"): PredictionValue | null =>\n date ? { [key]: date.toISOString() } : null;\nconst dateHit = (\n prediction: PredictionValue,\n actual: PredictionValue,\n tolerance: number,\n key = \"date\",\n) =>\n Math.abs(\n daysBetween(\n new Date(String(prediction[key])),\n new Date(String(actual[key])),\n ),\n ) <= tolerance;\nconst numberHit = (\n prediction: PredictionValue,\n actual: PredictionValue,\n tolerance: (actual: number) => number,\n key = \"value\",\n) =>\n Math.abs(Number(prediction[key]) - Number(actual[key])) <=\n tolerance(Number(actual[key]));\n\nexport const QUESTIONS: QuestionDefinition[] = [\n {\n number: 1,\n key: \"persistent-snow\",\n title: \"First persistent headwater snowpack\",\n issueKind: \"fixed\",\n issueMonth: 10,\n issueDay: 1,\n calculate: (s) => ({\n date: predictionDate(s, \"persistent\", 100).toISOString(),\n }),\n actual: (s) => dateActual(s.milestones.persistentSnow?.date || null),\n final: (s) => Boolean(s.milestones.persistentSnow),\n score: (p, a) => dateHit(p, a, 14),\n },\n {\n number: 2,\n key: \"peak-swe\",\n title: \"Peak headwater snowpack\",\n issueKind: \"fixed\",\n issueMonth: 2,\n issueDay: 1,\n calculate: (s) => ({\n value:\n Math.round(\n Math.max(\n s.milestones.peakSwe?.value || 0,\n requiredModel(\"peak_swe\", s),\n ) * 10,\n ) / 10,\n unit: \"in\",\n }),\n actual: (s) =>\n s.milestones.peakSwe\n ? {\n value: s.milestones.peakSwe.value,\n date: s.milestones.peakSwe.date.toISOString(),\n unit: \"in\",\n }\n : null,\n final: (s) => s.milestones.peakSweLikelyPassed,\n score: (p, a) => numberHit(p, a, (value) => Math.max(2, value * 0.2)),\n },\n {\n number: 3,\n key: \"first-400\",\n title: \"First 400+ CFS day\",\n issueKind: \"fixed\",\n issueMonth: 3,\n issueDay: 1,\n calculate: (s) => ({\n date: predictionDate(s, \"first400\", 80).toISOString(),\n }),\n actual: (s) => dateActual(s.milestones.first400?.date || null),\n final: (s) => Boolean(s.milestones.first400),\n score: (p, a) => dateHit(p, a, 10),\n },\n {\n number: 4,\n key: \"season-strength\",\n title: \"May–June rafting-season strength\",\n issueKind: \"fixed\",\n issueMonth: 4,\n issueDay: 1,\n calculate: (s) => ({\n value: Math.max(0, Math.round(requiredModel(\"river_strength\", s))),\n unit: \"cfs_average\",\n }),\n actual: (s) =>\n Number.isFinite(s.milestones.strength)\n ? { value: s.milestones.strength, unit: \"cfs_average\" }\n : null,\n final: (s) => s.cutoffAt > mountainToUtc(s.milestones.runoffYear, 7, 1, 0),\n score: (p, a) => numberHit(p, a, (value) => Math.max(100, value * 0.3)),\n },\n {\n number: 5,\n key: \"spring-peak\",\n title: \"Spring peak flow\",\n issueKind: \"fixed\",\n issueMonth: 4,\n issueDay: 15,\n calculate: (s) => {\n const date = predictionDate(s, \"spring_peak_days\", 70);\n const minutes =\n Math.round(Number(MODEL_BUNDLE.seasonal_peak_time_minutes_p50) / 15) *\n 15;\n const minuteOfDay = ((minutes % 1440) + 1440) % 1440;\n const timestamp = mountainToUtc(\n date.getUTCFullYear(),\n date.getUTCMonth() + 1,\n date.getUTCDate(),\n Math.floor(minuteOfDay / 60),\n minuteOfDay % 60,\n );\n const flow = Math.round(\n Math.max(\n s.current.value,\n s.milestones.peakDaily?.value || 0,\n requiredModel(\"spring_peak_flow\", s),\n ),\n );\n return { timestamp: timestamp.toISOString(), value: flow, unit: \"cfs\" };\n },\n actual: (s) =>\n s.milestones.peakInstant\n ? {\n timestamp: s.milestones.peakInstant.date.toISOString(),\n value: s.milestones.peakInstant.value,\n unit: \"cfs\",\n }\n : null,\n final: (s) => s.cutoffAt > mountainToUtc(s.milestones.runoffYear, 8, 1, 0),\n score: (p, a) => {\n const hours =\n Math.abs(\n new Date(String(p.timestamp)).getTime() -\n new Date(String(a.timestamp)).getTime(),\n ) / 3_600_000;\n return hours <= 168 &&\n numberHit(p, a, (value) => Math.max(250, value * 0.3));\n },\n },\n {\n number: 6,\n key: \"rafting-days\",\n title: \"Rafting-flow days\",\n issueKind: \"fixed\",\n issueMonth: 5,\n issueDay: 1,\n calculate: (s) => ({\n p300: Math.round(\n clamp(\n Math.max(s.milestones.counts.p300, requiredModel(\"days_ge_300\", s)),\n s.milestones.counts.p300,\n 140,\n ),\n ),\n p600: Math.round(\n clamp(\n Math.max(s.milestones.counts.p600, requiredModel(\"days_ge_600\", s)),\n s.milestones.counts.p600,\n 140,\n ),\n ),\n p800: Math.round(\n clamp(\n Math.max(s.milestones.counts.p800, requiredModel(\"days_ge_800\", s)),\n s.milestones.counts.p800,\n 140,\n ),\n ),\n }),\n actual: (s) => ({ ...s.milestones.counts }),\n final: (s) =>\n s.cutoffAt > addDays(firstMondayOfSeptember(s.milestones.runoffYear), 1),\n score: (p, a) =>\n [\"p300\", \"p600\", \"p800\"].filter((key) =>\n Math.abs(Number(p[key]) - Number(a[key])) <= 10\n ).length >= 2,\n },\n {\n number: 7,\n key: \"tubing-opening\",\n title: \"Tubing Season Opening Day\",\n issueKind: \"event\",\n trigger: (s) => s.milestones.tubingForecastTrigger?.date || null,\n calculate: (s) => ({\n date: tubingOpeningForecast(s.features, s.cutoffAt).toISOString(),\n }),\n actual: (s) => dateActual(s.milestones.tubingOpening),\n final: (s) => Boolean(s.milestones.tubingOpening),\n score: (p, a) => dateHit(p, a, 7),\n },\n {\n number: 8,\n key: \"remaining-tubing-days\",\n title: \"Remaining tubing-range days\",\n issueKind: \"event\",\n trigger: (s) => s.milestones.tubingOpening,\n calculate: (s) => {\n const observed = countRemainingTubingDays(s) || 0;\n const preOpeningDays = Math.max(0, s.milestones.counts.tubing - observed);\n const allSeasonEstimate = Math.max(\n observed,\n requiredModel(\"tubing_days\", s) - preOpeningDays,\n );\n return {\n value: Math.round(\n clamp(allSeasonEstimate, observed, observed + context(s).daysLeft),\n ),\n unit: \"days\",\n };\n },\n actual: (s) => {\n const value = countRemainingTubingDays(s);\n return value === null ? null : { value, unit: \"days\" };\n },\n final: (s) =>\n s.cutoffAt > addDays(firstMondayOfSeptember(s.milestones.runoffYear), 1),\n score: (p, a) => Math.abs(Number(p.value) - Number(a.value)) <= 10,\n },\n];\nimport { CONFIG } from \"./config.ts\";\nimport {\n addDays,\n firstMondayOfSeptember,\n isoDay,\n mountainCalendarDate,\n waterYear,\n} from \"./dates.ts\";\nimport type { BasinSnapshot, FlowPoint, Milestones, Snotel } from \"./types.ts\";\n\nconst average = (values: unknown[]): number | null => {\n const valid = values.map(Number).filter(Number.isFinite);\n return valid.length\n ? valid.reduce((sum, value) => sum + value, 0) / valid.length\n : null;\n};\n\nasync function fetchJson(url: string, timeout = 20_000): Promise {\n const controller = new AbortController();\n const timer = setTimeout(() => controller.abort(), timeout);\n try {\n const response = await fetch(url, {\n signal: controller.signal,\n headers: { Accept: \"application/json\" },\n });\n if (!response.ok) {\n const parsed = new URL(url);\n throw new Error(\n `${parsed.hostname}${parsed.pathname} returned ${response.status}`,\n );\n }\n return await response.json();\n } finally {\n clearTimeout(timer);\n }\n}\n\nfunction parseUsgs(payload: any, cutoffAt: Date): FlowPoint[] {\n const series = payload?.value?.timeSeries?.[0]?.values?.[0]?.value || [];\n return series.map((item: any) => ({\n date: new Date(item.dateTime),\n value: Number(item.value),\n }))\n .filter((item: FlowPoint) =>\n !Number.isNaN(item.date.getTime()) && item.date <= cutoffAt &&\n Number.isFinite(item.value) && item.value >= 0\n )\n .sort((a: FlowPoint, b: FlowPoint) => a.date.getTime() - b.date.getTime());\n}\n\nfunction parseSnotel(payload: any, cutoffAt: Date): Snotel {\n const output: Snotel = {};\n for (const station of payload || []) {\n const stationId = String(station.stationTriplet);\n output[stationId] ||= {};\n for (const series of station.data || []) {\n const code = series.stationElement?.elementCode;\n if (!code) continue;\n output[stationId][code] = (series.values || []).map((item: any) => ({\n date: new Date(`${item.date}T12:00:00Z`),\n value: Number(item.value),\n median: item.median === null || item.median === undefined\n ? null\n : Number(item.median),\n })).filter((item: any) =>\n !Number.isNaN(item.date.getTime()) && item.date <= cutoffAt &&\n Number.isFinite(item.value)\n );\n }\n }\n return output;\n}\n\nfunction latestAtOrBefore(\n points: T[],\n date: Date,\n): T | null {\n const eligible = (points || []).filter((point) => point.date <= date);\n return eligible.length ? eligible[eligible.length - 1] : null;\n}\n\nfunction stationAverage(\n snotel: Snotel,\n element: string,\n date: Date,\n field: \"value\" | \"median\" = \"value\",\n): number | null {\n return average(\n Object.values(snotel).map((station) =>\n (latestAtOrBefore(station[element] || [], date) as any)?.[field]\n ),\n );\n}\n\nfunction waterYearDay(date: Date): number {\n const year = date.getUTCMonth() >= 9\n ? date.getUTCFullYear()\n : date.getUTCFullYear() - 1;\n return Math.round(\n (Date.UTC(date.getUTCFullYear(), date.getUTCMonth(), date.getUTCDate()) -\n Date.UTC(year, 9, 1)) / 86_400_000,\n );\n}\n\nfunction buildFeatures(\n flowDaily: FlowPoint[],\n currentFlow: number,\n snotel: Snotel,\n now: Date,\n): Record {\n const date7 = addDays(now, -7);\n const date30 = addDays(now, -30);\n const recent7 = flowDaily.filter((point) =>\n point.date >= date7 && point.date <= now\n ).map((point) => point.value);\n const recent30 = flowDaily.filter((point) =>\n point.date >= date30 && point.date <= now\n ).map((point) => point.value);\n const flow7Ago = latestAtOrBefore(flowDaily, date7)?.value ?? currentFlow;\n const flowMean7 = average(recent7) ?? currentFlow;\n const flowMean30 = average(recent30) ?? flowMean7;\n const swe = stationAverage(snotel, \"WTEQ\", now) ?? 0;\n const sweMedian = stationAverage(snotel, \"WTEQ\", now, \"median\") ?? 0;\n const swe7Ago = stationAverage(snotel, \"WTEQ\", date7) ?? swe;\n const sweRatio = sweMedian > 0.05\n ? Math.min(3, Math.max(0, swe / sweMedian))\n : swe <= 0.05\n ? 0\n : 3;\n const stationIds = Object.keys(snotel);\n const temperatures: number[] = [];\n for (const id of stationIds) {\n for (const point of snotel[id].TAVG || []) {\n if (point.date >= date7 && point.date <= now) {\n temperatures.push(point.value);\n }\n }\n }\n const temp7 = average(temperatures) ?? 32;\n const precipitationChange = (startDate: Date) =>\n average(stationIds.map((id) => {\n const current = latestAtOrBefore(snotel[id].PREC || [], now)?.value;\n const earlier = latestAtOrBefore(snotel[id].PREC || [], startDate)?.value;\n return Number.isFinite(current) && Number.isFinite(earlier)\n ? Math.max(0, Number(current) - Number(earlier))\n : null;\n })) ?? 0;\n const precip7 = precipitationChange(date7);\n const precip30 = precipitationChange(date30);\n const snowPresent = swe > 0.05 ? 1 : 0;\n const angle = 2 * Math.PI * waterYearDay(now) / 365.25;\n return {\n log_flow: Math.log1p(currentFlow),\n log_flow_mean_7d: Math.log1p(flowMean7),\n log_flow_mean_30d: Math.log1p(flowMean30),\n relative_flow_change_7d: (currentFlow - flow7Ago) /\n (Math.abs(flowMean7) + 30),\n swe_in: swe,\n swe_ratio: sweRatio,\n swe_change_7d: swe - swe7Ago,\n temperature_scaled: (temp7 - 32) / 20,\n prec_total_7d: precip7,\n prec_total_30d: precip30,\n snow_present: snowPresent,\n season_sin: Math.sin(angle),\n season_cos: Math.cos(angle),\n season_sin_2: Math.sin(2 * angle),\n season_cos_2: Math.cos(2 * angle),\n melt_pressure: swe * Math.max(temp7 - 32, 0) / 100,\n rain_without_snow: precip7 * (1 - snowPresent),\n current_flow: currentFlow,\n swe_median: sweMedian,\n temp_7d: temp7,\n precip_7d: precip7,\n };\n}\n\nasync function fetchInstantaneousPeak(\n dailyFlow: FlowPoint[],\n runoffYear: number,\n cutoffAt: Date,\n): Promise {\n const start = new Date(Date.UTC(runoffYear, 3, 1));\n const end = new Date(\n Math.min(cutoffAt.getTime(), Date.UTC(runoffYear, 6, 31, 23, 59)),\n );\n const candidate = dailyFlow.filter((item) =>\n item.date >= start && item.date <= end\n )\n .reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n if (!candidate) return null;\n const url =\n `https://waterservices.usgs.gov/nwis/iv/?format=json&sites=${CONFIG.usgsSite}&startDT=${\n isoDay(addDays(candidate.date, -1))\n }&endDT=${\n isoDay(addDays(candidate.date, 2))\n }¶meterCd=00060&siteStatus=all`;\n const values = parseUsgs(await fetchJson(url), cutoffAt);\n return values.reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n}\n\nfunction findTubingOpening(\n series: FlowPoint[],\n after: Date | null,\n): Date | null {\n if (!after) return null;\n const ordered = series.filter((item) => item.date > after).sort((a, b) =>\n a.date.getTime() - b.date.getTime()\n );\n for (let index = 0; index < ordered.length; index += 1) {\n const endPoint = ordered[index];\n const startTime = endPoint.date.getTime() - 24 * 3_600_000;\n const window = ordered.filter((item) =>\n item.date.getTime() >= startTime && item.date <= endPoint.date\n );\n if (window.length < 4) continue;\n if (\n window.at(-1)!.date.getTime() - window[0].date.getTime() < 23 * 3_600_000\n ) continue;\n if (window.every((item) => item.value >= 30 && item.value < 400)) {\n return endPoint.date;\n }\n }\n return null;\n}\n\nfunction deriveMilestones(\n dailyFlow: FlowPoint[],\n instantaneous: FlowPoint[],\n snotel: Snotel,\n current: FlowPoint,\n peakInstant: FlowPoint | null,\n): Milestones {\n const runoffYear = waterYear(current.date);\n const waterYearStart = new Date(Date.UTC(runoffYear - 1, 9, 1, 12));\n const springStart = new Date(Date.UTC(runoffYear, 2, 1, 12));\n const peakWindowStart = new Date(Date.UTC(runoffYear, 3, 1, 12));\n const peakWindowEnd = new Date(Date.UTC(runoffYear, 6, 31, 23, 59));\n const recreationStart = new Date(Date.UTC(runoffYear, 4, 1, 12));\n const laborDay = firstMondayOfSeptember(runoffYear);\n laborDay.setUTCHours(23, 59, 59, 999);\n const waterYearDaily = dailyFlow.filter((item) =>\n item.date >= waterYearStart && item.date <= current.date\n );\n const springDaily = waterYearDaily.filter((item) => item.date >= springStart);\n const first400 = springDaily.find((item) => item.value >= 400) || null;\n const peakDaily = springDaily.filter((item) =>\n item.date >= peakWindowStart && item.date <= peakWindowEnd\n )\n .reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n const daysSincePeak = peakDaily\n ? Math.floor(\n (current.date.getTime() - peakDaily.date.getTime()) / 86_400_000,\n )\n : 0;\n const dropFromPeak = peakDaily?.value\n ? 1 - current.value / peakDaily.value\n : 0;\n const peakFlowLikelyPassed = Boolean(\n peakDaily && daysSincePeak >= 6 && dropFromPeak >= 0.18,\n );\n let tubingForecastTrigger: FlowPoint | null = null;\n if (peakDaily) {\n const peakIndex = springDaily.findIndex((item) =>\n isoDay(item.date) === isoDay(peakDaily.date) &&\n item.value === peakDaily.value\n );\n for (\n let index = Math.max(2, peakIndex + 1);\n index < springDaily.length;\n index += 1\n ) {\n const item = springDaily[index];\n const fallingThreeDay = item.value < springDaily[index - 2].value;\n const eligible = peakDaily.value >= 800\n ? item.value < 800\n : peakFlowLikelyPassed;\n if (eligible && fallingThreeDay) {\n tubingForecastTrigger = item;\n break;\n }\n }\n }\n const dailyTubingFallback = peakDaily\n ? springDaily.find((item) =>\n item.date > peakDaily.date && item.value >= 30 && item.value < 400\n )?.date || null\n : null;\n const tubingOpening =\n findTubingOpening(instantaneous, peakDaily?.date || null) ||\n dailyTubingFallback;\n const seasonDaily = waterYearDaily.filter((item) =>\n item.date >= recreationStart && item.date <= laborDay &&\n item.date <= current.date\n );\n const counts = {\n p300: seasonDaily.filter((item) => item.value >= 300).length,\n p600: seasonDaily.filter((item) => item.value >= 600).length,\n p800: seasonDaily.filter((item) => item.value >= 800).length,\n tubing:\n seasonDaily.filter((item) => item.value >= 30 && item.value < 400).length,\n };\n const strengthDays = waterYearDaily.filter((item) =>\n item.date >= recreationStart &&\n item.date <= new Date(Date.UTC(runoffYear, 5, 30, 23, 59))\n );\n const strength = average(strengthDays.map((item) => item.value));\n const snowDates = [\n ...new Set(\n Object.values(snotel).flatMap((station) =>\n (station.WTEQ || []).map((item) => isoDay(item.date))\n ),\n ),\n ]\n .map((value) => new Date(`${value}T12:00:00Z`)).filter((date) =>\n date >= waterYearStart && date <= current.date\n ).sort((a, b) => a.getTime() - b.getTime());\n const snowSeries = snowDates.map((date) => ({\n date,\n value: stationAverage(snotel, \"WTEQ\", date),\n }))\n .filter((item): item is { date: Date; value: number } =>\n Number.isFinite(item.value)\n );\n let persistentSnow = null;\n for (let index = 0; index <= snowSeries.length - 7; index += 1) {\n const window = snowSeries.slice(index, index + 7);\n if (window[0].value >= 1 && window.every((item) => item.value >= 0.5)) {\n persistentSnow = window[0];\n break;\n }\n }\n const peakSwe = snowSeries.reduce<{ date: Date; value: number } | null>(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n const daysSincePeakSwe = peakSwe\n ? Math.floor((current.date.getTime() - peakSwe.date.getTime()) / 86_400_000)\n : 0;\n const currentSwe = snowSeries.at(-1)?.value || 0;\n const peakSweLikelyPassed = Boolean(\n peakSwe && peakSwe.value >= 1 && daysSincePeakSwe >= 14 &&\n currentSwe <= peakSwe.value * 0.7,\n );\n return {\n runoffYear,\n laborDay,\n first400,\n peakDaily,\n peakInstant,\n peakFlowLikelyPassed,\n tubingForecastTrigger,\n tubingOpening,\n counts,\n strength,\n persistentSnow,\n peakSwe,\n peakSweLikelyPassed,\n };\n}\n\nexport async function fetchBasinSnapshot(\n cutoffAt = new Date(),\n): Promise {\n const runoffYear = waterYear(cutoffAt);\n // Models use 7- and 30-day history. Starting 45 days before the water year\n // also prevents the October 1 lock from running with an empty daily series.\n const waterYearStart = new Date(Date.UTC(runoffYear - 1, 9, 1, 12));\n const start = isoDay(addDays(waterYearStart, -45));\n const end = isoDay(cutoffAt);\n const dailyUrl =\n `https://waterservices.usgs.gov/nwis/dv/?format=json&sites=${CONFIG.usgsSite}&startDT=${start}&endDT=${end}¶meterCd=00060&statCd=00003&siteStatus=all`;\n const instantUrl =\n `https://waterservices.usgs.gov/nwis/iv/?format=json&sites=${CONFIG.usgsSite}&period=P60D¶meterCd=00060&siteStatus=all`;\n const stationParam = encodeURIComponent(CONFIG.snotelStations.join(\",\"));\n const snotelUrl =\n `https://wcc.sc.egov.usda.gov/awdbRestApi/services/v1/data?stationTriplets=${stationParam}&elements=WTEQ%2CSNWD%2CPREC%2CTAVG&duration=DAILY&beginDate=${start}&endDate=${end}&periodRef=END¢ralTendencyType=MEDIAN&returnFlags=false&returnOriginalValues=false&returnSuspectData=false`;\n const [dailyPayload, instantPayload, snowPayload] = await Promise.all([\n fetchJson(dailyUrl),\n fetchJson(instantUrl),\n fetchJson(snotelUrl),\n ]);\n const dailyFlow = parseUsgs(dailyPayload, cutoffAt);\n const instantaneous = parseUsgs(instantPayload, cutoffAt);\n if (!dailyFlow.length || !instantaneous.length) {\n throw new Error(\"The Pagosa USGS gauge did not return enough data\");\n }\n const snotel = parseSnotel(snowPayload, cutoffAt);\n if (!Object.keys(snotel).length) {\n throw new Error(\"The headwater SNOTEL stations did not return enough data\");\n }\n const latestSnotelAt = Object.values(snotel)\n .flatMap((station) => Object.values(station).flat())\n .reduce(\n (latest, point) => !latest || point.date > latest ? point.date : latest,\n null,\n );\n const current = instantaneous.at(-1)!;\n const features = buildFeatures(\n dailyFlow,\n current.value,\n snotel,\n current.date,\n );\n const peakInstant = await fetchInstantaneousPeak(\n dailyFlow,\n runoffYear,\n cutoffAt,\n ).catch(() => null);\n const milestones = deriveMilestones(\n dailyFlow,\n instantaneous,\n snotel,\n current,\n peakInstant,\n );\n return {\n capturedAt: new Date(),\n cutoffAt,\n current,\n instantaneous,\n dailyFlow,\n snotel,\n features,\n milestones,\n sourceStatus: {\n usgs_site: CONFIG.usgsSite,\n usgs_latest_at: current.date.toISOString(),\n usgs_daily_points: dailyFlow.length,\n usgs_instant_points: instantaneous.length,\n snotel_stations: Object.keys(snotel),\n snotel_latest_day: latestSnotelAt ? isoDay(latestSnotelAt) : null,\n },\n };\n}\n// Val-scoped SQLite keeps this project's records isolated and returns rows as\n// named objects (the legacy account-global database returns arrays).\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type StoredPrediction = {\n water_year: number;\n question_number: number;\n question_key: string;\n title: string;\n mode: string;\n issue_kind: string;\n issue_due_at: string;\n locked_at: string;\n input_cutoff_at: string;\n model_version: string;\n model_hash: string;\n prediction_json: string;\n inputs_json: string;\n inputs_hash: string;\n source_status_json: string;\n status: string;\n actual_json: string | null;\n score: string | null;\n scored_at: string | null;\n};\n\nexport async function initDb(): Promise {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS bh_seasons (\n water_year INTEGER PRIMARY KEY,\n opened_at TEXT NOT NULL,\n state TEXT NOT NULL DEFAULT 'active',\n model_bundle_version TEXT NOT NULL,\n completed_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_predictions (\n water_year INTEGER NOT NULL,\n question_number INTEGER NOT NULL,\n question_key TEXT NOT NULL,\n title TEXT NOT NULL,\n mode TEXT NOT NULL CHECK(mode IN ('shadow','live')),\n issue_kind TEXT NOT NULL,\n issue_due_at TEXT NOT NULL,\n locked_at TEXT NOT NULL,\n input_cutoff_at TEXT NOT NULL,\n model_version TEXT NOT NULL,\n model_hash TEXT NOT NULL,\n prediction_json TEXT NOT NULL,\n inputs_json TEXT NOT NULL,\n inputs_hash TEXT NOT NULL,\n source_status_json TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'locked',\n actual_json TEXT,\n score TEXT CHECK(score IN ('hit','miss') OR score IS NULL),\n scored_at TEXT,\n PRIMARY KEY (water_year, question_number, mode)\n )`,\n `CREATE TABLE IF NOT EXISTS bh_runs (\n id TEXT PRIMARY KEY,\n ran_at TEXT NOT NULL,\n mode TEXT NOT NULL,\n success INTEGER NOT NULL,\n message TEXT NOT NULL,\n source_status_json TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n water_year INTEGER NOT NULL,\n question_number INTEGER,\n event_type TEXT NOT NULL,\n occurred_at TEXT NOT NULL,\n payload_json TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS bh_public_cache (\n cache_key TEXT PRIMARY KEY,\n value_json TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TRIGGER IF NOT EXISTS bh_locked_prediction_immutable\n BEFORE UPDATE OF issue_due_at, locked_at, input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash\n ON bh_predictions\n BEGIN SELECT RAISE(ABORT, 'Locked Black Hat prediction fields are immutable'); END`,\n ]);\n}\n\nexport async function ensureSeason(\n waterYear: number,\n modelVersion: string,\n openedAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO bh_seasons(water_year, opened_at, model_bundle_version) VALUES (?, ?, ?)`,\n args: [waterYear, openedAt.toISOString(), modelVersion],\n });\n}\n\nexport async function getPrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND question_number=? AND mode=?`,\n args: [waterYear, questionNumber, mode],\n });\n return (result.rows[0] as any) || null;\n}\n\nexport async function lockPrediction(row: StoredPrediction): Promise {\n const result = await sqlite.execute({\n sql: `INSERT OR IGNORE INTO bh_predictions(\n water_year, question_number, question_key, title, mode, issue_kind, issue_due_at, locked_at,\n input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash,\n source_status_json, status, actual_json, score, scored_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n row.water_year,\n row.question_number,\n row.question_key,\n row.title,\n row.mode,\n row.issue_kind,\n row.issue_due_at,\n row.locked_at,\n row.input_cutoff_at,\n row.model_version,\n row.model_hash,\n row.prediction_json,\n row.inputs_json,\n row.inputs_hash,\n row.source_status_json,\n row.status,\n row.actual_json,\n row.score,\n row.scored_at,\n ],\n });\n return Number(result.rowsAffected) === 1;\n}\n\nexport async function finalizePrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n actualJson: string,\n hit: boolean,\n scoredAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `UPDATE bh_predictions SET actual_json=?, score=?, status='scored', scored_at=?\n WHERE water_year=? AND question_number=? AND mode=? AND scored_at IS NULL`,\n args: [\n actualJson,\n hit ? \"hit\" : \"miss\",\n scoredAt.toISOString(),\n waterYear,\n questionNumber,\n mode,\n ],\n });\n}\n\nexport async function recordEvent(\n waterYear: number,\n questionNumber: number | null,\n eventType: string,\n occurredAt: Date,\n payload: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_events(water_year, question_number, event_type, occurred_at, payload_json) VALUES (?, ?, ?, ?, ?)`,\n args: [\n waterYear,\n questionNumber,\n eventType,\n occurredAt.toISOString(),\n JSON.stringify(payload),\n ],\n });\n}\n\nexport async function recordRun(\n success: boolean,\n mode: string,\n message: string,\n sourceStatus: unknown = null,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_runs(id, ran_at, mode, success, message, source_status_json) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n crypto.randomUUID(),\n new Date().toISOString(),\n mode,\n success ? 1 : 0,\n message,\n sourceStatus ? JSON.stringify(sourceStatus) : null,\n ],\n });\n}\n\nexport async function listPredictions(\n waterYear: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND mode=? ORDER BY question_number`,\n args: [waterYear, mode],\n });\n return result.rows as any;\n}\n\nexport async function recentRuns(limit = 10): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT ran_at, mode, success, message, source_status_json FROM bh_runs ORDER BY ran_at DESC LIMIT ?`,\n args: [limit],\n });\n return result.rows as any;\n}\n\nexport async function cachePublicFeed(\n key: string,\n value: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_public_cache(cache_key, value_json, updated_at) VALUES (?, ?, ?)\n ON CONFLICT(cache_key) DO UPDATE SET value_json=excluded.value_json, updated_at=excluded.updated_at`,\n args: [key, JSON.stringify(value), new Date().toISOString()],\n });\n}\n\nexport async function getPublicFeed(\n key: string,\n): Promise<{ value: any; updatedAt: string } | null> {\n const result = await sqlite.execute({\n sql: `SELECT value_json, updated_at FROM bh_public_cache WHERE cache_key=?`,\n args: [key],\n });\n const row: any = result.rows[0];\n return row\n ? {\n value: JSON.parse(String(row.value_json)),\n updatedAt: String(row.updated_at),\n }\n : null;\n}",[186],"1ee23f82-db4b-49ad-88bb-3f3080ab3ce9","sources-old.ts","9fe9133e-ab9a-11f1-b085-1607ee4eb77e",86,["D",1788883009046],7,"import { CONFIG } from \"./config.ts\";\nimport {\n addDays,\n firstMondayOfSeptember,\n isoDay,\n mountainCalendarDate,\n waterYear,\n} from \"./dates.ts\";\nimport type { BasinSnapshot, FlowPoint, Milestones, Snotel } from \"./types.ts\";\n\nconst average = (values: unknown[]): number | null => {\n const valid = values.map(Number).filter(Number.isFinite);\n return valid.length\n ? valid.reduce((sum, value) => sum + value, 0) / valid.length\n : null;\n};\n\nasync function fetchJson(url: string, timeout = 20_000): Promise {\n const controller = new AbortController();\n const timer = setTimeout(() => controller.abort(), timeout);\n try {\n const response = await fetch(url, {\n signal: controller.signal,\n headers: { Accept: \"application/json\" },\n });\n if (!response.ok) {\n const parsed = new URL(url);\n throw new Error(\n `${parsed.hostname}${parsed.pathname} returned ${response.status}`,\n );\n }\n return await response.json();\n } finally {\n clearTimeout(timer);\n }\n}\n\nfunction parseUsgs(payload: any, cutoffAt: Date): FlowPoint[] {\n const series = payload?.value?.timeSeries?.[0]?.values?.[0]?.value || [];\n return series.map((item: any) => ({\n date: new Date(item.dateTime),\n value: Number(item.value),\n }))\n .filter((item: FlowPoint) =>\n !Number.isNaN(item.date.getTime()) && item.date <= cutoffAt &&\n Number.isFinite(item.value) && item.value >= 0\n )\n .sort((a: FlowPoint, b: FlowPoint) => a.date.getTime() - b.date.getTime());\n}\n\nfunction parseSnotel(payload: any, cutoffAt: Date): Snotel {\n const output: Snotel = {};\n for (const station of payload || []) {\n const stationId = String(station.stationTriplet);\n output[stationId] ||= {};\n for (const series of station.data || []) {\n const code = series.stationElement?.elementCode;\n if (!code) continue;\n output[stationId][code] = (series.values || []).map((item: any) => ({\n date: new Date(`${item.date}T12:00:00Z`),\n value: Number(item.value),\n median: item.median === null || item.median === undefined\n ? null\n : Number(item.median),\n })).filter((item: any) =>\n !Number.isNaN(item.date.getTime()) && item.date <= cutoffAt &&\n Number.isFinite(item.value)\n );\n }\n }\n return output;\n}\n\nfunction latestAtOrBefore(\n points: T[],\n date: Date,\n): T | null {\n const eligible = (points || []).filter((point) => point.date <= date);\n return eligible.length ? eligible[eligible.length - 1] : null;\n}\n\nfunction stationAverage(\n snotel: Snotel,\n element: string,\n date: Date,\n field: \"value\" | \"median\" = \"value\",\n): number | null {\n return average(\n Object.values(snotel).map((station) =>\n (latestAtOrBefore(station[element] || [], date) as any)?.[field]\n ),\n );\n}\n\nfunction waterYearDay(date: Date): number {\n const year = date.getUTCMonth() >= 9\n ? date.getUTCFullYear()\n : date.getUTCFullYear() - 1;\n return Math.round(\n (Date.UTC(date.getUTCFullYear(), date.getUTCMonth(), date.getUTCDate()) -\n Date.UTC(year, 9, 1)) / 86_400_000,\n );\n}\n\nfunction buildFeatures(\n flowDaily: FlowPoint[],\n currentFlow: number,\n snotel: Snotel,\n now: Date,\n): Record {\n const date7 = addDays(now, -7);\n const date30 = addDays(now, -30);\n const recent7 = flowDaily.filter((point) =>\n point.date >= date7 && point.date <= now\n ).map((point) => point.value);\n const recent30 = flowDaily.filter((point) =>\n point.date >= date30 && point.date <= now\n ).map((point) => point.value);\n const flow7Ago = latestAtOrBefore(flowDaily, date7)?.value ?? currentFlow;\n const flowMean7 = average(recent7) ?? currentFlow;\n const flowMean30 = average(recent30) ?? flowMean7;\n const swe = stationAverage(snotel, \"WTEQ\", now) ?? 0;\n const sweMedian = stationAverage(snotel, \"WTEQ\", now, \"median\") ?? 0;\n const swe7Ago = stationAverage(snotel, \"WTEQ\", date7) ?? swe;\n const sweRatio = sweMedian > 0.05\n ? Math.min(3, Math.max(0, swe / sweMedian))\n : swe <= 0.05\n ? 0\n : 3;\n const stationIds = Object.keys(snotel);\n const temperatures: number[] = [];\n for (const id of stationIds) {\n for (const point of snotel[id].TAVG || []) {\n if (point.date >= date7 && point.date <= now) {\n temperatures.push(point.value);\n }\n }\n }\n const temp7 = average(temperatures) ?? 32;\n const precipitationChange = (startDate: Date) =>\n average(stationIds.map((id) => {\n const current = latestAtOrBefore(snotel[id].PREC || [], now)?.value;\n const earlier = latestAtOrBefore(snotel[id].PREC || [], startDate)?.value;\n return Number.isFinite(current) && Number.isFinite(earlier)\n ? Math.max(0, Number(current) - Number(earlier))\n : null;\n })) ?? 0;\n const precip7 = precipitationChange(date7);\n const precip30 = precipitationChange(date30);\n const snowPresent = swe > 0.05 ? 1 : 0;\n const angle = 2 * Math.PI * waterYearDay(now) / 365.25;\n return {\n log_flow: Math.log1p(currentFlow),\n log_flow_mean_7d: Math.log1p(flowMean7),\n log_flow_mean_30d: Math.log1p(flowMean30),\n relative_flow_change_7d: (currentFlow - flow7Ago) /\n (Math.abs(flowMean7) + 30),\n swe_in: swe,\n swe_ratio: sweRatio,\n swe_change_7d: swe - swe7Ago,\n temperature_scaled: (temp7 - 32) / 20,\n prec_total_7d: precip7,\n prec_total_30d: precip30,\n snow_present: snowPresent,\n season_sin: Math.sin(angle),\n season_cos: Math.cos(angle),\n season_sin_2: Math.sin(2 * angle),\n season_cos_2: Math.cos(2 * angle),\n melt_pressure: swe * Math.max(temp7 - 32, 0) / 100,\n rain_without_snow: precip7 * (1 - snowPresent),\n current_flow: currentFlow,\n swe_median: sweMedian,\n temp_7d: temp7,\n precip_7d: precip7,\n };\n}\n\nasync function fetchInstantaneousPeak(\n dailyFlow: FlowPoint[],\n runoffYear: number,\n cutoffAt: Date,\n): Promise {\n const start = new Date(Date.UTC(runoffYear, 3, 1));\n const end = new Date(\n Math.min(cutoffAt.getTime(), Date.UTC(runoffYear, 6, 31, 23, 59)),\n );\n const candidate = dailyFlow.filter((item) =>\n item.date >= start && item.date <= end\n )\n .reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n if (!candidate) return null;\n const url =\n `https://waterservices.usgs.gov/nwis/iv/?format=json&sites=${CONFIG.usgsSite}&startDT=${\n isoDay(addDays(candidate.date, -1))\n }&endDT=${\n isoDay(addDays(candidate.date, 2))\n }¶meterCd=00060&siteStatus=all`;\n const values = parseUsgs(await fetchJson(url), cutoffAt);\n return values.reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n}\n\nfunction findTubingOpening(\n series: FlowPoint[],\n after: Date | null,\n): Date | null {\n if (!after) return null;\n const ordered = series.filter((item) => item.date > after).sort((a, b) =>\n a.date.getTime() - b.date.getTime()\n );\n for (let index = 0; index < ordered.length; index += 1) {\n const endPoint = ordered[index];\n const startTime = endPoint.date.getTime() - 24 * 3_600_000;\n const window = ordered.filter((item) =>\n item.date.getTime() >= startTime && item.date <= endPoint.date\n );\n if (window.length < 4) continue;\n if (\n window.at(-1)!.date.getTime() - window[0].date.getTime() < 23 * 3_600_000\n ) continue;\n if (window.every((item) => item.value >= 30 && item.value < 400)) {\n return endPoint.date;\n }\n }\n return null;\n}\n\nfunction deriveMilestones(\n dailyFlow: FlowPoint[],\n instantaneous: FlowPoint[],\n snotel: Snotel,\n current: FlowPoint,\n peakInstant: FlowPoint | null,\n): Milestones {\n const runoffYear = waterYear(current.date);\n const waterYearStart = new Date(Date.UTC(runoffYear - 1, 9, 1, 12));\n const springStart = new Date(Date.UTC(runoffYear, 2, 1, 12));\n const peakWindowStart = new Date(Date.UTC(runoffYear, 3, 1, 12));\n const peakWindowEnd = new Date(Date.UTC(runoffYear, 6, 31, 23, 59));\n const recreationStart = new Date(Date.UTC(runoffYear, 4, 1, 12));\n const laborDay = firstMondayOfSeptember(runoffYear);\n laborDay.setUTCHours(23, 59, 59, 999);\n const waterYearDaily = dailyFlow.filter((item) =>\n item.date >= waterYearStart && item.date <= current.date\n );\n const springDaily = waterYearDaily.filter((item) => item.date >= springStart);\n const first400 = springDaily.find((item) => item.value >= 400) || null;\n const peakDaily = springDaily.filter((item) =>\n item.date >= peakWindowStart && item.date <= peakWindowEnd\n )\n .reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n const daysSincePeak = peakDaily\n ? Math.floor(\n (current.date.getTime() - peakDaily.date.getTime()) / 86_400_000,\n )\n : 0;\n const dropFromPeak = peakDaily?.value\n ? 1 - current.value / peakDaily.value\n : 0;\n const peakFlowLikelyPassed = Boolean(\n peakDaily && daysSincePeak >= 6 && dropFromPeak >= 0.18,\n );\n let tubingForecastTrigger: FlowPoint | null = null;\n if (peakDaily) {\n const peakIndex = springDaily.findIndex((item) =>\n isoDay(item.date) === isoDay(peakDaily.date) &&\n item.value === peakDaily.value\n );\n for (\n let index = Math.max(2, peakIndex + 1);\n index < springDaily.length;\n index += 1\n ) {\n const item = springDaily[index];\n const fallingThreeDay = item.value < springDaily[index - 2].value;\n const eligible = peakDaily.value >= 800\n ? item.value < 800\n : peakFlowLikelyPassed;\n if (eligible && fallingThreeDay) {\n tubingForecastTrigger = item;\n break;\n }\n }\n }\n const dailyTubingFallback = peakDaily\n ? springDaily.find((item) =>\n item.date > peakDaily.date && item.value >= 30 && item.value < 400\n )?.date || null\n : null;\n const tubingOpening =\n findTubingOpening(instantaneous, peakDaily?.date || null) ||\n dailyTubingFallback;\n const seasonDaily = waterYearDaily.filter((item) =>\n item.date >= recreationStart && item.date <= laborDay &&\n item.date <= current.date\n );\n const counts = {\n p300: seasonDaily.filter((item) => item.value >= 300).length,\n p600: seasonDaily.filter((item) => item.value >= 600).length,\n p800: seasonDaily.filter((item) => item.value >= 800).length,\n tubing:\n seasonDaily.filter((item) => item.value >= 30 && item.value < 400).length,\n };\n const strengthDays = waterYearDaily.filter((item) =>\n item.date >= recreationStart &&\n item.date <= new Date(Date.UTC(runoffYear, 5, 30, 23, 59))\n );\n const strength = average(strengthDays.map((item) => item.value));\n const snowDates = [\n ...new Set(\n Object.values(snotel).flatMap((station) =>\n (station.WTEQ || []).map((item) => isoDay(item.date))\n ),\n ),\n ]\n .map((value) => new Date(`${value}T12:00:00Z`)).filter((date) =>\n date >= waterYearStart && date <= current.date\n ).sort((a, b) => a.getTime() - b.getTime());\n const snowSeries = snowDates.map((date) => ({\n date,\n value: stationAverage(snotel, \"WTEQ\", date),\n }))\n .filter((item): item is { date: Date; value: number } =>\n Number.isFinite(item.value)\n );\n let persistentSnow = null;\n for (let index = 0; index <= snowSeries.length - 7; index += 1) {\n const window = snowSeries.slice(index, index + 7);\n if (window[0].value >= 1 && window.every((item) => item.value >= 0.5)) {\n persistentSnow = window[0];\n break;\n }\n }\n const peakSwe = snowSeries.reduce<{ date: Date; value: number } | null>(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n const daysSincePeakSwe = peakSwe\n ? Math.floor((current.date.getTime() - peakSwe.date.getTime()) / 86_400_000)\n : 0;\n const currentSwe = snowSeries.at(-1)?.value || 0;\n const peakSweLikelyPassed = Boolean(\n peakSwe && peakSwe.value >= 1 && daysSincePeakSwe >= 14 &&\n currentSwe <= peakSwe.value * 0.7,\n );\n return {\n runoffYear,\n laborDay,\n first400,\n peakDaily,\n peakInstant,\n peakFlowLikelyPassed,\n tubingForecastTrigger,\n tubingOpening,\n counts,\n strength,\n persistentSnow,\n peakSwe,\n peakSweLikelyPassed,\n };\n}\n\nexport async function fetchBasinSnapshot(\n cutoffAt = new Date(),\n): Promise {\n const runoffYear = waterYear(cutoffAt);\n // Models use 7- and 30-day history. Starting 45 days before the water year\n // also prevents the October 1 lock from running with an empty daily series.\n const waterYearStart = new Date(Date.UTC(runoffYear - 1, 9, 1, 12));\n const start = isoDay(addDays(waterYearStart, -45));\n const end = isoDay(cutoffAt);\n const dailyUrl =\n `https://waterservices.usgs.gov/nwis/dv/?format=json&sites=${CONFIG.usgsSite}&startDT=${start}&endDT=${end}¶meterCd=00060&statCd=00003&siteStatus=all`;\n const instantUrl =\n `https://waterservices.usgs.gov/nwis/iv/?format=json&sites=${CONFIG.usgsSite}&period=P60D¶meterCd=00060&siteStatus=all`;\n const stationParam = encodeURIComponent(CONFIG.snotelStations.join(\",\"));\n const snotelUrl =\n `https://wcc.sc.egov.usda.gov/awdbRestApi/services/v1/data?stationTriplets=${stationParam}&elements=WTEQ%2CSNWD%2CPREC%2CTAVG&duration=DAILY&beginDate=${start}&endDate=${end}&periodRef=END¢ralTendencyType=MEDIAN&returnFlags=false&returnOriginalValues=false&returnSuspectData=false`;\n const [dailyPayload, instantPayload, snowPayload] = await Promise.all([\n fetchJson(dailyUrl),\n fetchJson(instantUrl),\n fetchJson(snotelUrl),\n ]);\n const dailyFlow = parseUsgs(dailyPayload, cutoffAt);\n const instantaneous = parseUsgs(instantPayload, cutoffAt);\n if (!dailyFlow.length || !instantaneous.length) {\n throw new Error(\"The Pagosa USGS gauge did not return enough data\");\n }\n const snotel = parseSnotel(snowPayload, cutoffAt);\n if (!Object.keys(snotel).length) {\n throw new Error(\"The headwater SNOTEL stations did not return enough data\");\n }\n const latestSnotelAt = Object.values(snotel)\n .flatMap((station) => Object.values(station).flat())\n .reduce(\n (latest, point) => !latest || point.date > latest ? point.date : latest,\n null,\n );\n const current = instantaneous.at(-1)!;\n const features = buildFeatures(\n dailyFlow,\n current.value,\n snotel,\n current.date,\n );\n const peakInstant = await fetchInstantaneousPeak(\n dailyFlow,\n runoffYear,\n cutoffAt,\n ).catch(() => null);\n const milestones = deriveMilestones(\n dailyFlow,\n instantaneous,\n snotel,\n current,\n peakInstant,\n );\n return {\n capturedAt: new Date(),\n cutoffAt,\n current,\n instantaneous,\n dailyFlow,\n snotel,\n features,\n milestones,\n sourceStatus: {\n usgs_site: CONFIG.usgsSite,\n usgs_latest_at: current.date.toISOString(),\n usgs_daily_points: dailyFlow.length,\n usgs_instant_points: instantaneous.length,\n snotel_stations: Object.keys(snotel),\n snotel_latest_day: latestSnotelAt ? isoDay(latestSnotelAt) : null,\n },\n };\n}",[193],"7d02c656-1746-4ae3-a148-068e8b9da8cc","questions.ts","ea85e900-ab9d-11f1-bc76-1607ee4eb77e",96,["D",1788883028580],"import { CONFIG, IS_LIVE } from \"./config.ts\";\nimport { addDays, fixedIssueAt, mountainToUtc, waterYear } from \"./dates.ts\";\nimport { MODEL_BUNDLE } from \"./models.ts\";\nimport { QUESTIONS } from \"./questions.ts\";\nimport { fetchBasinSnapshot } from \"./sources.ts\";\nimport {\n cachePublicFeed,\n ensureSeason,\n finalizePrediction,\n getPrediction,\n initDb,\n listPredictions,\n lockPrediction,\n recentRuns,\n recordEvent,\n recordRun,\n} from \"./storage.ts\";\nimport type { BasinSnapshot, QuestionDefinition } from \"./types.ts\";\n\nfunction canonical(value: any): string {\n if (Array.isArray(value)) return `[${value.map(canonical).join(\",\")}]`;\n if (value && typeof value === \"object\") {\n return `{${\n Object.keys(value).sort().map((key) =>\n `${JSON.stringify(key)}:${canonical(value[key])}`\n ).join(\",\")\n }}`;\n }\n return JSON.stringify(value);\n}\n\nasync function sha256(value: string): Promise {\n const digest = await crypto.subtle.digest(\n \"SHA-256\",\n new TextEncoder().encode(value),\n );\n return [...new Uint8Array(digest)].map((byte) =>\n byte.toString(16).padStart(2, \"0\")\n ).join(\"\");\n}\n\nfunction inputRecord(snapshot: BasinSnapshot): Record {\n const m = snapshot.milestones;\n return {\n captured_at: snapshot.capturedAt.toISOString(),\n cutoff_at: snapshot.cutoffAt.toISOString(),\n current: {\n date: snapshot.current.date.toISOString(),\n value: snapshot.current.value,\n },\n features: snapshot.features,\n milestones: {\n runoff_year: m.runoffYear,\n first_400: m.first400 &&\n { date: m.first400.date.toISOString(), value: m.first400.value },\n peak_daily: m.peakDaily &&\n { date: m.peakDaily.date.toISOString(), value: m.peakDaily.value },\n peak_instant: m.peakInstant &&\n { date: m.peakInstant.date.toISOString(), value: m.peakInstant.value },\n tubing_trigger: m.tubingForecastTrigger &&\n {\n date: m.tubingForecastTrigger.date.toISOString(),\n value: m.tubingForecastTrigger.value,\n },\n tubing_opening: m.tubingOpening?.toISOString() || null,\n counts: m.counts,\n strength: m.strength,\n persistent_snow: m.persistentSnow &&\n {\n date: m.persistentSnow.date.toISOString(),\n value: m.persistentSnow.value,\n },\n peak_swe: m.peakSwe &&\n { date: m.peakSwe.date.toISOString(), value: m.peakSwe.value },\n },\n };\n}\n\nfunction dueAt(\n question: QuestionDefinition,\n runoffYear: number,\n snapshot: BasinSnapshot,\n): Date | null {\n if (question.issueKind === \"fixed\") {\n return fixedIssueAt(runoffYear, question.issueMonth!, question.issueDay!);\n }\n return question.trigger?.(snapshot) || null;\n}\n\nfunction publicPrediction(row: any): Record {\n return {\n number: Number(row.question_number),\n key: row.question_key,\n title: row.title,\n issue_kind: row.issue_kind,\n issue_due_at: row.issue_due_at,\n locked_at: row.locked_at,\n input_cutoff_at: row.input_cutoff_at,\n model_version: row.model_version,\n prediction: JSON.parse(row.prediction_json),\n status: row.status,\n actual: row.actual_json ? JSON.parse(row.actual_json) : null,\n score: row.score,\n scored_at: row.scored_at,\n };\n}\n\nasync function refreshPublicCache(runoffYear: number): Promise {\n const live = await listPredictions(runoffYear, \"live\");\n const shadow = await listPredictions(runoffYear, \"shadow\");\n const runs = await recentRuns(5);\n const feed = {\n schema_version: 1,\n water_year: runoffYear,\n game_state: live.length ? \"live\" : \"shadow-testing\",\n model: MODEL_BUNDLE,\n updated_at: new Date().toISOString(),\n predictions: live.map(publicPrediction),\n shadow_summary: {\n locked: shadow.length,\n scored: shadow.filter((row) => row.score).length,\n },\n health: runs.map((run) => ({\n ran_at: run.ran_at,\n mode: run.mode,\n success: Boolean(run.success),\n message: run.message,\n })),\n };\n await cachePublicFeed(`scoreboard-${runoffYear}`, feed);\n await cachePublicFeed(\"scoreboard-current\", feed);\n}\n\nexport async function runAutomation(\n now = new Date(),\n): Promise> {\n await initDb();\n const mode = IS_LIVE ? \"live\" : \"shadow\";\n const runoffYear = waterYear(now);\n if (runoffYear < CONFIG.firstAutomatedWaterYear) {\n // September is a preseason health check. It deliberately creates no locks,\n // but proves the official sources, models, database, cron and public cache work.\n try {\n const current = await fetchBasinSnapshot(now);\n const message =\n `Preseason ${mode} check passed. Water year ${CONFIG.firstAutomatedWaterYear} becomes eligible on October 1.`;\n await recordRun(true, mode, message, current.sourceStatus);\n await refreshPublicCache(CONFIG.firstAutomatedWaterYear);\n return {\n ok: true,\n mode,\n preseason: true,\n water_year: CONFIG.firstAutomatedWaterYear,\n message,\n source_status: current.sourceStatus,\n };\n } catch (error) {\n const message = error instanceof Error ? error.message : String(error);\n await recordRun(false, mode, `Preseason check failed: ${message}`);\n throw error;\n }\n }\n const openedAt = mountainToUtc(runoffYear - 1, 10, 1, 0);\n await ensureSeason(runoffYear, MODEL_BUNDLE.source_model_version, openedAt);\n let current: BasinSnapshot;\n try {\n current = await fetchBasinSnapshot(now);\n } catch (error) {\n const message = error instanceof Error ? error.message : String(error);\n await recordRun(false, mode, message);\n throw error;\n }\n\n const actions: string[] = [];\n const lockSnapshots = new Map();\n for (const question of QUESTIONS) {\n let stored = await getPrediction(runoffYear, question.number, mode);\n if (!stored) {\n const issueAt = dueAt(question, runoffYear, current);\n if (issueAt && now >= issueAt) {\n const ageHours = (now.getTime() - issueAt.getTime()) / 3_600_000;\n if (ageHours > CONFIG.fixedLockGraceHours) {\n actions.push(\n `P${question.number} needs review: issue window was missed`,\n );\n } else {\n const cacheKey = issueAt.toISOString();\n let lockSnapshot = lockSnapshots.get(cacheKey);\n if (!lockSnapshot) {\n lockSnapshot = await fetchBasinSnapshot(issueAt);\n lockSnapshots.set(cacheKey, lockSnapshot);\n }\n const prediction = question.calculate(lockSnapshot);\n const inputs = inputRecord(lockSnapshot);\n const predictionJson = canonical(prediction);\n const inputsJson = canonical(inputs);\n const inserted = await lockPrediction({\n water_year: runoffYear,\n question_number: question.number,\n question_key: question.key,\n title: question.title,\n mode,\n issue_kind: question.issueKind,\n issue_due_at: issueAt.toISOString(),\n locked_at: now.toISOString(),\n input_cutoff_at: issueAt.toISOString(),\n model_version: MODEL_BUNDLE.source_model_version,\n model_hash: MODEL_BUNDLE.sha256,\n prediction_json: predictionJson,\n inputs_json: inputsJson,\n inputs_hash: await sha256(inputsJson),\n source_status_json: canonical(lockSnapshot.sourceStatus),\n status: \"locked\",\n actual_json: null,\n score: null,\n scored_at: null,\n });\n if (inserted) {\n await recordEvent(\n runoffYear,\n question.number,\n `${mode}_lock_created`,\n now,\n { issue_at: issueAt.toISOString(), prediction },\n );\n actions.push(`P${question.number} ${mode} lock created`);\n stored = await getPrediction(runoffYear, question.number, mode);\n }\n }\n }\n }\n if (stored && !stored.scored_at && question.final(current)) {\n const actual = question.actual(current);\n if (actual) {\n const prediction = JSON.parse(stored.prediction_json);\n const hit = question.score(prediction, actual);\n await finalizePrediction(\n runoffYear,\n question.number,\n mode,\n canonical(actual),\n hit,\n now,\n );\n await recordEvent(\n runoffYear,\n question.number,\n `${mode}_score_finalized`,\n now,\n { actual, score: hit ? \"hit\" : \"miss\" },\n );\n actions.push(`P${question.number} scored ${hit ? \"HIT\" : \"MISS\"}`);\n }\n }\n }\n const message = actions.length\n ? actions.join(\"; \")\n : \"Data refreshed; no lock or score was due.\";\n await recordRun(true, mode, message, current.sourceStatus);\n await refreshPublicCache(runoffYear);\n return {\n ok: true,\n mode,\n water_year: runoffYear,\n actions,\n source_status: current.sourceStatus,\n };\n}\nimport { MODEL_BUNDLE } from \"./models.ts\";\nimport {\n addDays,\n daysBetween,\n firstMondayOfSeptember,\n mountainCalendarDate,\n mountainToUtc,\n} from \"./dates.ts\";\nimport {\n clamp,\n runRightNowModel,\n tubingOpeningForecast,\n} from \"./model-runtime.ts\";\nimport type {\n BasinSnapshot,\n PredictionValue,\n QuestionDefinition,\n} from \"./types.ts\";\n\nfunction context(snapshot: BasinSnapshot): Record {\n const m = snapshot.milestones;\n const today = mountainCalendarDate(snapshot.cutoffAt);\n const daysLeft = Math.max(\n 0,\n Math.ceil((m.laborDay.getTime() - today.getTime()) / 86_400_000),\n );\n return {\n ...snapshot.features,\n count300: m.counts.p300,\n count600: m.counts.p600,\n count800: m.counts.p800,\n countTubing: m.counts.tubing,\n daysLeft,\n };\n}\n\nfunction requiredModel(name: string, snapshot: BasinSnapshot): number {\n const value = runRightNowModel(name, context(snapshot));\n if (!Number.isFinite(value)) {\n throw new Error(`Model ${name} could not produce a prediction`);\n }\n return Number(value);\n}\n\nfunction predictionDate(\n snapshot: BasinSnapshot,\n model: string,\n maximumDays: number,\n): Date {\n const days = Math.round(\n clamp(requiredModel(model, snapshot), 0, maximumDays),\n );\n return addDays(mountainCalendarDate(snapshot.cutoffAt), days);\n}\n\nfunction countRemainingTubingDays(snapshot: BasinSnapshot): number | null {\n const opening = snapshot.milestones.tubingOpening;\n if (!opening) return null;\n const start = addDays(mountainCalendarDate(opening), 1);\n return snapshot.dailyFlow.filter((item) =>\n item.date >= start && item.date <= snapshot.milestones.laborDay &&\n item.value >= 30 && item.value < 400\n ).length;\n}\n\nconst dateActual = (date: Date | null, key = \"date\"): PredictionValue | null =>\n date ? { [key]: date.toISOString() } : null;\nconst dateHit = (\n prediction: PredictionValue,\n actual: PredictionValue,\n tolerance: number,\n key = \"date\",\n) =>\n Math.abs(\n daysBetween(\n new Date(String(prediction[key])),\n new Date(String(actual[key])),\n ),\n ) <= tolerance;\nconst numberHit = (\n prediction: PredictionValue,\n actual: PredictionValue,\n tolerance: (actual: number) => number,\n key = \"value\",\n) =>\n Math.abs(Number(prediction[key]) - Number(actual[key])) <=\n tolerance(Number(actual[key]));\n\nexport const QUESTIONS: QuestionDefinition[] = [\n {\n number: 1,\n key: \"persistent-snow\",\n title: \"First persistent headwater snowpack\",\n issueKind: \"fixed\",\n issueMonth: 10,\n issueDay: 1,\n calculate: (s) => ({\n date: predictionDate(s, \"persistent\", 100).toISOString(),\n }),\n actual: (s) => dateActual(s.milestones.persistentSnow?.date || null),\n final: (s) => Boolean(s.milestones.persistentSnow),\n score: (p, a) => dateHit(p, a, 14),\n },\n {\n number: 2,\n key: \"peak-swe\",\n title: \"Peak headwater snowpack\",\n issueKind: \"fixed\",\n issueMonth: 2,\n issueDay: 1,\n calculate: (s) => ({\n value: Math.round(\n Math.max(\n s.milestones.peakSwe?.value || 0,\n requiredModel(\"peak_swe\", s),\n ) * 10,\n ) / 10,\n unit: \"in\",\n }),\n actual: (s) =>\n s.milestones.peakSwe\n ? {\n value: s.milestones.peakSwe.value,\n date: s.milestones.peakSwe.date.toISOString(),\n unit: \"in\",\n }\n : null,\n final: (s) => s.milestones.peakSweLikelyPassed,\n score: (p, a) => numberHit(p, a, (value) => Math.max(2, value * 0.2)),\n },\n {\n number: 3,\n key: \"first-400\",\n title: \"First 400+ CFS day\",\n issueKind: \"fixed\",\n issueMonth: 3,\n issueDay: 1,\n calculate: (s) => ({\n date: predictionDate(s, \"first400\", 80).toISOString(),\n }),\n actual: (s) => dateActual(s.milestones.first400?.date || null),\n final: (s) => Boolean(s.milestones.first400),\n score: (p, a) => dateHit(p, a, 10),\n },\n {\n number: 4,\n key: \"season-strength\",\n title: \"May–June rafting-season strength\",\n issueKind: \"fixed\",\n issueMonth: 4,\n issueDay: 1,\n calculate: (s) => ({\n value: Math.max(0, Math.round(requiredModel(\"river_strength\", s))),\n unit: \"cfs_average\",\n }),\n actual: (s) =>\n Number.isFinite(s.milestones.strength)\n ? { value: s.milestones.strength, unit: \"cfs_average\" }\n : null,\n final: (s) => s.cutoffAt > mountainToUtc(s.milestones.runoffYear, 7, 1, 0),\n score: (p, a) => numberHit(p, a, (value) => Math.max(100, value * 0.3)),\n },\n {\n number: 5,\n key: \"spring-peak\",\n title: \"Spring peak flow\",\n issueKind: \"fixed\",\n issueMonth: 4,\n issueDay: 15,\n calculate: (s) => {\n const date = predictionDate(s, \"spring_peak_days\", 70);\n const minutes =\n Math.round(Number(MODEL_BUNDLE.seasonal_peak_time_minutes_p50) / 15) *\n 15;\n const minuteOfDay = ((minutes % 1440) + 1440) % 1440;\n const timestamp = mountainToUtc(\n date.getUTCFullYear(),\n date.getUTCMonth() + 1,\n date.getUTCDate(),\n Math.floor(minuteOfDay / 60),\n minuteOfDay % 60,\n );\n const flow = Math.round(\n Math.max(\n s.current.value,\n s.milestones.peakDaily?.value || 0,\n requiredModel(\"spring_peak_flow\", s),\n ),\n );\n return { timestamp: timestamp.toISOString(), value: flow, unit: \"cfs\" };\n },\n actual: (s) =>\n s.milestones.peakInstant\n ? {\n timestamp: s.milestones.peakInstant.date.toISOString(),\n value: s.milestones.peakInstant.value,\n unit: \"cfs\",\n }\n : null,\n final: (s) => s.cutoffAt > mountainToUtc(s.milestones.runoffYear, 8, 1, 0),\n score: (p, a) => {\n const hours = Math.abs(\n new Date(String(p.timestamp)).getTime() -\n new Date(String(a.timestamp)).getTime(),\n ) / 3_600_000;\n return hours <= 168 &&\n numberHit(p, a, (value) => Math.max(250, value * 0.3));\n },\n },\n {\n number: 6,\n key: \"rafting-days\",\n title: \"Rafting-flow days\",\n issueKind: \"fixed\",\n issueMonth: 5,\n issueDay: 1,\n calculate: (s) => ({\n p300: Math.round(\n clamp(\n Math.max(s.milestones.counts.p300, requiredModel(\"days_ge_300\", s)),\n s.milestones.counts.p300,\n 140,\n ),\n ),\n p600: Math.round(\n clamp(\n Math.max(s.milestones.counts.p600, requiredModel(\"days_ge_600\", s)),\n s.milestones.counts.p600,\n 140,\n ),\n ),\n p800: Math.round(\n clamp(\n Math.max(s.milestones.counts.p800, requiredModel(\"days_ge_800\", s)),\n s.milestones.counts.p800,\n 140,\n ),\n ),\n }),\n actual: (s) => ({ ...s.milestones.counts }),\n final: (s) =>\n s.cutoffAt > addDays(firstMondayOfSeptember(s.milestones.runoffYear), 1),\n score: (p, a) =>\n [\"p300\", \"p600\", \"p800\"].filter((key) =>\n Math.abs(Number(p[key]) - Number(a[key])) <= 10\n ).length >= 2,\n },\n {\n number: 7,\n key: \"tubing-opening\",\n title: \"Tubing Season Opening Day\",\n issueKind: \"event\",\n trigger: (s) => s.milestones.tubingForecastTrigger?.date || null,\n calculate: (s) => ({\n date: tubingOpeningForecast(s.features, s.cutoffAt).toISOString(),\n }),\n actual: (s) => dateActual(s.milestones.tubingOpening),\n final: (s) => Boolean(s.milestones.tubingOpening),\n score: (p, a) => dateHit(p, a, 7),\n },\n {\n number: 8,\n key: \"remaining-tubing-days\",\n title: \"Remaining tubing-range days\",\n issueKind: \"event\",\n trigger: (s) => s.milestones.tubingOpening,\n calculate: (s) => {\n const observed = countRemainingTubingDays(s) || 0;\n const preOpeningDays = Math.max(0, s.milestones.counts.tubing - observed);\n const allSeasonEstimate = Math.max(\n observed,\n requiredModel(\"tubing_days\", s) - preOpeningDays,\n );\n return {\n value: Math.round(\n clamp(allSeasonEstimate, observed, observed + context(s).daysLeft),\n ),\n unit: \"days\",\n };\n },\n actual: (s) => {\n const value = countRemainingTubingDays(s);\n return value === null ? null : { value, unit: \"days\" };\n },\n final: (s) =>\n s.cutoffAt > addDays(firstMondayOfSeptember(s.milestones.runoffYear), 1),\n score: (p, a) => Math.abs(Number(p.value) - Number(a.value)) <= 10,\n },\n];\nimport { CONFIG } from \"./config.ts\";\nimport {\n addDays,\n firstMondayOfSeptember,\n isoDay,\n mountainCalendarDate,\n waterYear,\n} from \"./dates.ts\";\nimport type { BasinSnapshot, FlowPoint, Milestones, Snotel } from \"./types.ts\";\n\nconst average = (values: unknown[]): number | null => {\n const valid = values.map(Number).filter(Number.isFinite);\n return valid.length\n ? valid.reduce((sum, value) => sum + value, 0) / valid.length\n : null;\n};\n\nasync function fetchJson(url: string, timeout = 20_000): Promise {\n const controller = new AbortController();\n const timer = setTimeout(() => controller.abort(), timeout);\n try {\n const response = await fetch(url, {\n signal: controller.signal,\n headers: { Accept: \"application/json\" },\n });\n if (!response.ok) {\n const parsed = new URL(url);\n throw new Error(\n `${parsed.hostname}${parsed.pathname} returned ${response.status}`,\n );\n }\n return await response.json();\n } finally {\n clearTimeout(timer);\n }\n}\n\nfunction parseUsgs(payload: any, cutoffAt: Date): FlowPoint[] {\n const series = payload?.value?.timeSeries?.[0]?.values?.[0]?.value || [];\n return series.map((item: any) => ({\n date: new Date(item.dateTime),\n value: Number(item.value),\n }))\n .filter((item: FlowPoint) =>\n !Number.isNaN(item.date.getTime()) && item.date <= cutoffAt &&\n Number.isFinite(item.value) && item.value >= 0\n )\n .sort((a: FlowPoint, b: FlowPoint) => a.date.getTime() - b.date.getTime());\n}\n\nfunction parseSnotel(payload: any, cutoffAt: Date): Snotel {\n const output: Snotel = {};\n for (const station of payload || []) {\n const stationId = String(station.stationTriplet);\n output[stationId] ||= {};\n for (const series of station.data || []) {\n const code = series.stationElement?.elementCode;\n if (!code) continue;\n output[stationId][code] = (series.values || []).map((item: any) => ({\n date: new Date(`${item.date}T12:00:00Z`),\n value: Number(item.value),\n median: item.median === null || item.median === undefined\n ? null\n : Number(item.median),\n })).filter((item: any) =>\n !Number.isNaN(item.date.getTime()) && item.date <= cutoffAt &&\n Number.isFinite(item.value)\n );\n }\n }\n return output;\n}\n\nfunction latestAtOrBefore(\n points: T[],\n date: Date,\n): T | null {\n const eligible = (points || []).filter((point) => point.date <= date);\n return eligible.length ? eligible[eligible.length - 1] : null;\n}\n\nfunction stationAverage(\n snotel: Snotel,\n element: string,\n date: Date,\n field: \"value\" | \"median\" = \"value\",\n): number | null {\n return average(\n Object.values(snotel).map((station) =>\n (latestAtOrBefore(station[element] || [], date) as any)?.[field]\n ),\n );\n}\n\nfunction waterYearDay(date: Date): number {\n const year = date.getUTCMonth() >= 9\n ? date.getUTCFullYear()\n : date.getUTCFullYear() - 1;\n return Math.round(\n (Date.UTC(date.getUTCFullYear(), date.getUTCMonth(), date.getUTCDate()) -\n Date.UTC(year, 9, 1)) / 86_400_000,\n );\n}\n\nfunction buildFeatures(\n flowDaily: FlowPoint[],\n currentFlow: number,\n snotel: Snotel,\n now: Date,\n): Record {\n const date7 = addDays(now, -7);\n const date30 = addDays(now, -30);\n const recent7 = flowDaily.filter((point) =>\n point.date >= date7 && point.date <= now\n ).map((point) => point.value);\n const recent30 = flowDaily.filter((point) =>\n point.date >= date30 && point.date <= now\n ).map((point) => point.value);\n const flow7Ago = latestAtOrBefore(flowDaily, date7)?.value ?? currentFlow;\n const flowMean7 = average(recent7) ?? currentFlow;\n const flowMean30 = average(recent30) ?? flowMean7;\n const swe = stationAverage(snotel, \"WTEQ\", now) ?? 0;\n const sweMedian = stationAverage(snotel, \"WTEQ\", now, \"median\") ?? 0;\n const swe7Ago = stationAverage(snotel, \"WTEQ\", date7) ?? swe;\n const sweRatio = sweMedian > 0.05\n ? Math.min(3, Math.max(0, swe / sweMedian))\n : swe <= 0.05\n ? 0\n : 3;\n const stationIds = Object.keys(snotel);\n const temperatures: number[] = [];\n for (const id of stationIds) {\n for (const point of snotel[id].TAVG || []) {\n if (point.date >= date7 && point.date <= now) {\n temperatures.push(point.value);\n }\n }\n }\n const temp7 = average(temperatures) ?? 32;\n const precipitationChange = (startDate: Date) =>\n average(stationIds.map((id) => {\n const current = latestAtOrBefore(snotel[id].PREC || [], now)?.value;\n const earlier = latestAtOrBefore(snotel[id].PREC || [], startDate)?.value;\n return Number.isFinite(current) && Number.isFinite(earlier)\n ? Math.max(0, Number(current) - Number(earlier))\n : null;\n })) ?? 0;\n const precip7 = precipitationChange(date7);\n const precip30 = precipitationChange(date30);\n const snowPresent = swe > 0.05 ? 1 : 0;\n const angle = 2 * Math.PI * waterYearDay(now) / 365.25;\n return {\n log_flow: Math.log1p(currentFlow),\n log_flow_mean_7d: Math.log1p(flowMean7),\n log_flow_mean_30d: Math.log1p(flowMean30),\n relative_flow_change_7d: (currentFlow - flow7Ago) /\n (Math.abs(flowMean7) + 30),\n swe_in: swe,\n swe_ratio: sweRatio,\n swe_change_7d: swe - swe7Ago,\n temperature_scaled: (temp7 - 32) / 20,\n prec_total_7d: precip7,\n prec_total_30d: precip30,\n snow_present: snowPresent,\n season_sin: Math.sin(angle),\n season_cos: Math.cos(angle),\n season_sin_2: Math.sin(2 * angle),\n season_cos_2: Math.cos(2 * angle),\n melt_pressure: swe * Math.max(temp7 - 32, 0) / 100,\n rain_without_snow: precip7 * (1 - snowPresent),\n current_flow: currentFlow,\n swe_median: sweMedian,\n temp_7d: temp7,\n precip_7d: precip7,\n };\n}\n\nasync function fetchInstantaneousPeak(\n dailyFlow: FlowPoint[],\n runoffYear: number,\n cutoffAt: Date,\n): Promise {\n const start = new Date(Date.UTC(runoffYear, 3, 1));\n const end = new Date(\n Math.min(cutoffAt.getTime(), Date.UTC(runoffYear, 6, 31, 23, 59)),\n );\n const candidate = dailyFlow.filter((item) =>\n item.date >= start && item.date <= end\n )\n .reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n if (!candidate) return null;\n const url =\n `https://waterservices.usgs.gov/nwis/iv/?format=json&sites=${CONFIG.usgsSite}&startDT=${\n isoDay(addDays(candidate.date, -1))\n }&endDT=${\n isoDay(addDays(candidate.date, 2))\n }¶meterCd=00060&siteStatus=all`;\n const values = parseUsgs(await fetchJson(url), cutoffAt);\n return values.reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n}\n\nfunction findTubingOpening(\n series: FlowPoint[],\n after: Date | null,\n): Date | null {\n if (!after) return null;\n const ordered = series.filter((item) => item.date > after).sort((a, b) =>\n a.date.getTime() - b.date.getTime()\n );\n for (let index = 0; index < ordered.length; index += 1) {\n const endPoint = ordered[index];\n const startTime = endPoint.date.getTime() - 24 * 3_600_000;\n const window = ordered.filter((item) =>\n item.date.getTime() >= startTime && item.date <= endPoint.date\n );\n if (window.length < 4) continue;\n if (\n window.at(-1)!.date.getTime() - window[0].date.getTime() < 23 * 3_600_000\n ) continue;\n if (window.every((item) => item.value >= 30 && item.value < 400)) {\n return endPoint.date;\n }\n }\n return null;\n}\n\nfunction deriveMilestones(\n dailyFlow: FlowPoint[],\n instantaneous: FlowPoint[],\n snotel: Snotel,\n current: FlowPoint,\n peakInstant: FlowPoint | null,\n): Milestones {\n const runoffYear = waterYear(current.date);\n const waterYearStart = new Date(Date.UTC(runoffYear - 1, 9, 1, 12));\n const springStart = new Date(Date.UTC(runoffYear, 2, 1, 12));\n const peakWindowStart = new Date(Date.UTC(runoffYear, 3, 1, 12));\n const peakWindowEnd = new Date(Date.UTC(runoffYear, 6, 31, 23, 59));\n const recreationStart = new Date(Date.UTC(runoffYear, 4, 1, 12));\n const laborDay = firstMondayOfSeptember(runoffYear);\n laborDay.setUTCHours(23, 59, 59, 999);\n const waterYearDaily = dailyFlow.filter((item) =>\n item.date >= waterYearStart && item.date <= current.date\n );\n const springDaily = waterYearDaily.filter((item) => item.date >= springStart);\n const first400 = springDaily.find((item) => item.value >= 400) || null;\n const peakDaily = springDaily.filter((item) =>\n item.date >= peakWindowStart && item.date <= peakWindowEnd\n )\n .reduce(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n const daysSincePeak = peakDaily\n ? Math.floor(\n (current.date.getTime() - peakDaily.date.getTime()) / 86_400_000,\n )\n : 0;\n const dropFromPeak = peakDaily?.value\n ? 1 - current.value / peakDaily.value\n : 0;\n const peakFlowLikelyPassed = Boolean(\n peakDaily && daysSincePeak >= 6 && dropFromPeak >= 0.18,\n );\n let tubingForecastTrigger: FlowPoint | null = null;\n if (peakDaily) {\n const peakIndex = springDaily.findIndex((item) =>\n isoDay(item.date) === isoDay(peakDaily.date) &&\n item.value === peakDaily.value\n );\n for (\n let index = Math.max(2, peakIndex + 1);\n index < springDaily.length;\n index += 1\n ) {\n const item = springDaily[index];\n const fallingThreeDay = item.value < springDaily[index - 2].value;\n const eligible = peakDaily.value >= 800\n ? item.value < 800\n : peakFlowLikelyPassed;\n if (eligible && fallingThreeDay) {\n tubingForecastTrigger = item;\n break;\n }\n }\n }\n const dailyTubingFallback = peakDaily\n ? springDaily.find((item) =>\n item.date > peakDaily.date && item.value >= 30 && item.value < 400\n )?.date || null\n : null;\n const tubingOpening =\n findTubingOpening(instantaneous, peakDaily?.date || null) ||\n dailyTubingFallback;\n const seasonDaily = waterYearDaily.filter((item) =>\n item.date >= recreationStart && item.date <= laborDay &&\n item.date <= current.date\n );\n const counts = {\n p300: seasonDaily.filter((item) => item.value >= 300).length,\n p600: seasonDaily.filter((item) => item.value >= 600).length,\n p800: seasonDaily.filter((item) => item.value >= 800).length,\n tubing:\n seasonDaily.filter((item) => item.value >= 30 && item.value < 400).length,\n };\n const strengthDays = waterYearDaily.filter((item) =>\n item.date >= recreationStart &&\n item.date <= new Date(Date.UTC(runoffYear, 5, 30, 23, 59))\n );\n const strength = average(strengthDays.map((item) => item.value));\n const snowDates = [\n ...new Set(\n Object.values(snotel).flatMap((station) =>\n (station.WTEQ || []).map((item) => isoDay(item.date))\n ),\n ),\n ]\n .map((value) => new Date(`${value}T12:00:00Z`)).filter((date) =>\n date >= waterYearStart && date <= current.date\n ).sort((a, b) => a.getTime() - b.getTime());\n const snowSeries = snowDates.map((date) => ({\n date,\n value: stationAverage(snotel, \"WTEQ\", date),\n }))\n .filter((item): item is { date: Date; value: number } =>\n Number.isFinite(item.value)\n );\n let persistentSnow = null;\n for (let index = 0; index <= snowSeries.length - 7; index += 1) {\n const window = snowSeries.slice(index, index + 7);\n if (window[0].value >= 1 && window.every((item) => item.value >= 0.5)) {\n persistentSnow = window[0];\n break;\n }\n }\n const peakSwe = snowSeries.reduce<{ date: Date; value: number } | null>(\n (best, item) => !best || item.value > best.value ? item : best,\n null,\n );\n const daysSincePeakSwe = peakSwe\n ? Math.floor((current.date.getTime() - peakSwe.date.getTime()) / 86_400_000)\n : 0;\n const currentSwe = snowSeries.at(-1)?.value || 0;\n const peakSweLikelyPassed = Boolean(\n peakSwe && peakSwe.value >= 1 && daysSincePeakSwe >= 14 &&\n currentSwe <= peakSwe.value * 0.7,\n );\n return {\n runoffYear,\n laborDay,\n first400,\n peakDaily,\n peakInstant,\n peakFlowLikelyPassed,\n tubingForecastTrigger,\n tubingOpening,\n counts,\n strength,\n persistentSnow,\n peakSwe,\n peakSweLikelyPassed,\n };\n}\n\nexport async function fetchBasinSnapshot(\n cutoffAt = new Date(),\n): Promise {\n const runoffYear = waterYear(cutoffAt);\n // Models use 7- and 30-day history. Starting 45 days before the water year\n // also prevents the October 1 lock from running with an empty daily series.\n const waterYearStart = new Date(Date.UTC(runoffYear - 1, 9, 1, 12));\n const start = isoDay(addDays(waterYearStart, -45));\n const end = isoDay(cutoffAt);\n const dailyUrl =\n `https://waterservices.usgs.gov/nwis/dv/?format=json&sites=${CONFIG.usgsSite}&startDT=${start}&endDT=${end}¶meterCd=00060&statCd=00003&siteStatus=all`;\n const instantUrl =\n `https://waterservices.usgs.gov/nwis/iv/?format=json&sites=${CONFIG.usgsSite}&period=P60D¶meterCd=00060&siteStatus=all`;\n const stationParam = encodeURIComponent(CONFIG.snotelStations.join(\",\"));\n const snotelUrl =\n `https://wcc.sc.egov.usda.gov/awdbRestApi/services/v1/data?stationTriplets=${stationParam}&elements=WTEQ%2CSNWD%2CPREC%2CTAVG&duration=DAILY&beginDate=${start}&endDate=${end}&periodRef=END¢ralTendencyType=MEDIAN&returnFlags=false&returnOriginalValues=false&returnSuspectData=false`;\n const [dailyPayload, instantPayload, snowPayload] = await Promise.all([\n fetchJson(dailyUrl),\n fetchJson(instantUrl),\n fetchJson(snotelUrl),\n ]);\n const dailyFlow = parseUsgs(dailyPayload, cutoffAt);\n const instantaneous = parseUsgs(instantPayload, cutoffAt);\n if (!dailyFlow.length || !instantaneous.length) {\n throw new Error(\"The Pagosa USGS gauge did not return enough data\");\n }\n const snotel = parseSnotel(snowPayload, cutoffAt);\n if (!Object.keys(snotel).length) {\n throw new Error(\"The headwater SNOTEL stations did not return enough data\");\n }\n const latestSnotelAt = Object.values(snotel)\n .flatMap((station) => Object.values(station).flat())\n .reduce(\n (latest, point) => !latest || point.date > latest ? point.date : latest,\n null,\n );\n const current = instantaneous.at(-1)!;\n const features = buildFeatures(\n dailyFlow,\n current.value,\n snotel,\n current.date,\n );\n const peakInstant = await fetchInstantaneousPeak(\n dailyFlow,\n runoffYear,\n cutoffAt,\n ).catch(() => null);\n const milestones = deriveMilestones(\n dailyFlow,\n instantaneous,\n snotel,\n current,\n peakInstant,\n );\n return {\n capturedAt: new Date(),\n cutoffAt,\n current,\n instantaneous,\n dailyFlow,\n snotel,\n features,\n milestones,\n sourceStatus: {\n usgs_site: CONFIG.usgsSite,\n usgs_latest_at: current.date.toISOString(),\n usgs_daily_points: dailyFlow.length,\n usgs_instant_points: instantaneous.length,\n snotel_stations: Object.keys(snotel),\n snotel_latest_day: latestSnotelAt ? isoDay(latestSnotelAt) : null,\n },\n };\n}\n// Val-scoped SQLite keeps this project's records isolated and returns rows as\n// named objects (the legacy account-global database returns arrays).\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type StoredPrediction = {\n water_year: number;\n question_number: number;\n question_key: string;\n title: string;\n mode: string;\n issue_kind: string;\n issue_due_at: string;\n locked_at: string;\n input_cutoff_at: string;\n model_version: string;\n model_hash: string;\n prediction_json: string;\n inputs_json: string;\n inputs_hash: string;\n source_status_json: string;\n status: string;\n actual_json: string | null;\n score: string | null;\n scored_at: string | null;\n};\n\nexport async function initDb(): Promise {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS bh_seasons (\n water_year INTEGER PRIMARY KEY,\n opened_at TEXT NOT NULL,\n state TEXT NOT NULL DEFAULT 'active',\n model_bundle_version TEXT NOT NULL,\n completed_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_predictions (\n water_year INTEGER NOT NULL,\n question_number INTEGER NOT NULL,\n question_key TEXT NOT NULL,\n title TEXT NOT NULL,\n mode TEXT NOT NULL CHECK(mode IN ('shadow','live')),\n issue_kind TEXT NOT NULL,\n issue_due_at TEXT NOT NULL,\n locked_at TEXT NOT NULL,\n input_cutoff_at TEXT NOT NULL,\n model_version TEXT NOT NULL,\n model_hash TEXT NOT NULL,\n prediction_json TEXT NOT NULL,\n inputs_json TEXT NOT NULL,\n inputs_hash TEXT NOT NULL,\n source_status_json TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'locked',\n actual_json TEXT,\n score TEXT CHECK(score IN ('hit','miss') OR score IS NULL),\n scored_at TEXT,\n PRIMARY KEY (water_year, question_number, mode)\n )`,\n `CREATE TABLE IF NOT EXISTS bh_runs (\n id TEXT PRIMARY KEY,\n ran_at TEXT NOT NULL,\n mode TEXT NOT NULL,\n success INTEGER NOT NULL,\n message TEXT NOT NULL,\n source_status_json TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n water_year INTEGER NOT NULL,\n question_number INTEGER,\n event_type TEXT NOT NULL,\n occurred_at TEXT NOT NULL,\n payload_json TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS bh_public_cache (\n cache_key TEXT PRIMARY KEY,\n value_json TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TRIGGER IF NOT EXISTS bh_locked_prediction_immutable\n BEFORE UPDATE OF issue_due_at, locked_at, input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash\n ON bh_predictions\n BEGIN SELECT RAISE(ABORT, 'Locked Black Hat prediction fields are immutable'); END`,\n ]);\n}\n\nexport async function ensureSeason(\n waterYear: number,\n modelVersion: string,\n openedAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO bh_seasons(water_year, opened_at, model_bundle_version) VALUES (?, ?, ?)`,\n args: [waterYear, openedAt.toISOString(), modelVersion],\n });\n}\n\nexport async function getPrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND question_number=? AND mode=?`,\n args: [waterYear, questionNumber, mode],\n });\n return (result.rows[0] as any) || null;\n}\n\nexport async function lockPrediction(row: StoredPrediction): Promise {\n const result = await sqlite.execute({\n sql: `INSERT OR IGNORE INTO bh_predictions(\n water_year, question_number, question_key, title, mode, issue_kind, issue_due_at, locked_at,\n input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash,\n source_status_json, status, actual_json, score, scored_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n row.water_year,\n row.question_number,\n row.question_key,\n row.title,\n row.mode,\n row.issue_kind,\n row.issue_due_at,\n row.locked_at,\n row.input_cutoff_at,\n row.model_version,\n row.model_hash,\n row.prediction_json,\n row.inputs_json,\n row.inputs_hash,\n row.source_status_json,\n row.status,\n row.actual_json,\n row.score,\n row.scored_at,\n ],\n });\n return Number(result.rowsAffected) === 1;\n}\n\nexport async function finalizePrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n actualJson: string,\n hit: boolean,\n scoredAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `UPDATE bh_predictions SET actual_json=?, score=?, status='scored', scored_at=?\n WHERE water_year=? AND question_number=? AND mode=? AND scored_at IS NULL`,\n args: [\n actualJson,\n hit ? \"hit\" : \"miss\",\n scoredAt.toISOString(),\n waterYear,\n questionNumber,\n mode,\n ],\n });\n}\n\nexport async function recordEvent(\n waterYear: number,\n questionNumber: number | null,\n eventType: string,\n occurredAt: Date,\n payload: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_events(water_year, question_number, event_type, occurred_at, payload_json) VALUES (?, ?, ?, ?, ?)`,\n args: [\n waterYear,\n questionNumber,\n eventType,\n occurredAt.toISOString(),\n JSON.stringify(payload),\n ],\n });\n}\n\nexport async function recordRun(\n success: boolean,\n mode: string,\n message: string,\n sourceStatus: unknown = null,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_runs(id, ran_at, mode, success, message, source_status_json) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n crypto.randomUUID(),\n new Date().toISOString(),\n mode,\n success ? 1 : 0,\n message,\n sourceStatus ? JSON.stringify(sourceStatus) : null,\n ],\n });\n}\n\nexport async function listPredictions(\n waterYear: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND mode=? ORDER BY question_number`,\n args: [waterYear, mode],\n });\n return result.rows as any;\n}\n\nexport async function recentRuns(limit = 10): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT ran_at, mode, success, message, source_status_json FROM bh_runs ORDER BY ran_at DESC LIMIT ?`,\n args: [limit],\n });\n return result.rows as any;\n}\n\nexport async function cachePublicFeed(\n key: string,\n value: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_public_cache(cache_key, value_json, updated_at) VALUES (?, ?, ?)\n ON CONFLICT(cache_key) DO UPDATE SET value_json=excluded.value_json, updated_at=excluded.updated_at`,\n args: [key, JSON.stringify(value), new Date().toISOString()],\n });\n}\n\nexport async function getPublicFeed(\n key: string,\n): Promise<{ value: any; updatedAt: string } | null> {\n const result = await sqlite.execute({\n sql: `SELECT value_json, updated_at FROM bh_public_cache WHERE cache_key=?`,\n args: [key],\n });\n const row: any = result.rows[0];\n return row\n ? {\n value: JSON.parse(String(row.value_json)),\n updatedAt: String(row.updated_at),\n }\n : null;\n}",[201],"9f38b5cc-9f34-480e-b8bb-e5988ca6b6ef","questions-old.ts","9c517f2c-ab9a-11f1-94dd-1607ee4eb77e",90,["D",1788883014695],6,"import { MODEL_BUNDLE } from \"./models.ts\";\nimport {\n addDays,\n daysBetween,\n firstMondayOfSeptember,\n mountainCalendarDate,\n mountainToUtc,\n} from \"./dates.ts\";\nimport {\n clamp,\n runRightNowModel,\n tubingOpeningForecast,\n} from \"./model-runtime.ts\";\nimport type {\n BasinSnapshot,\n PredictionValue,\n QuestionDefinition,\n} from \"./types.ts\";\n\nfunction context(snapshot: BasinSnapshot): Record {\n const m = snapshot.milestones;\n const today = mountainCalendarDate(snapshot.cutoffAt);\n const daysLeft = Math.max(\n 0,\n Math.ceil((m.laborDay.getTime() - today.getTime()) / 86_400_000),\n );\n return {\n ...snapshot.features,\n count300: m.counts.p300,\n count600: m.counts.p600,\n count800: m.counts.p800,\n countTubing: m.counts.tubing,\n daysLeft,\n };\n}\n\nfunction requiredModel(name: string, snapshot: BasinSnapshot): number {\n const value = runRightNowModel(name, context(snapshot));\n if (!Number.isFinite(value)) {\n throw new Error(`Model ${name} could not produce a prediction`);\n }\n return Number(value);\n}\n\nfunction predictionDate(\n snapshot: BasinSnapshot,\n model: string,\n maximumDays: number,\n): Date {\n const days = Math.round(\n clamp(requiredModel(model, snapshot), 0, maximumDays),\n );\n return addDays(mountainCalendarDate(snapshot.cutoffAt), days);\n}\n\nfunction countRemainingTubingDays(snapshot: BasinSnapshot): number | null {\n const opening = snapshot.milestones.tubingOpening;\n if (!opening) return null;\n const start = addDays(mountainCalendarDate(opening), 1);\n return snapshot.dailyFlow.filter((item) =>\n item.date >= start && item.date <= snapshot.milestones.laborDay &&\n item.value >= 30 && item.value < 400\n ).length;\n}\n\nconst dateActual = (date: Date | null, key = \"date\"): PredictionValue | null =>\n date ? { [key]: date.toISOString() } : null;\nconst dateHit = (\n prediction: PredictionValue,\n actual: PredictionValue,\n tolerance: number,\n key = \"date\",\n) =>\n Math.abs(\n daysBetween(\n new Date(String(prediction[key])),\n new Date(String(actual[key])),\n ),\n ) <= tolerance;\nconst numberHit = (\n prediction: PredictionValue,\n actual: PredictionValue,\n tolerance: (actual: number) => number,\n key = \"value\",\n) =>\n Math.abs(Number(prediction[key]) - Number(actual[key])) <=\n tolerance(Number(actual[key]));\n\nexport const QUESTIONS: QuestionDefinition[] = [\n {\n number: 1,\n key: \"persistent-snow\",\n title: \"First persistent headwater snowpack\",\n issueKind: \"fixed\",\n issueMonth: 10,\n issueDay: 1,\n calculate: (s) => ({\n date: predictionDate(s, \"persistent\", 100).toISOString(),\n }),\n actual: (s) => dateActual(s.milestones.persistentSnow?.date || null),\n final: (s) => Boolean(s.milestones.persistentSnow),\n score: (p, a) => dateHit(p, a, 14),\n },\n {\n number: 2,\n key: \"peak-swe\",\n title: \"Peak headwater snowpack\",\n issueKind: \"fixed\",\n issueMonth: 2,\n issueDay: 1,\n calculate: (s) => ({\n value:\n Math.round(\n Math.max(\n s.milestones.peakSwe?.value || 0,\n requiredModel(\"peak_swe\", s),\n ) * 10,\n ) / 10,\n unit: \"in\",\n }),\n actual: (s) =>\n s.milestones.peakSwe\n ? {\n value: s.milestones.peakSwe.value,\n date: s.milestones.peakSwe.date.toISOString(),\n unit: \"in\",\n }\n : null,\n final: (s) => s.milestones.peakSweLikelyPassed,\n score: (p, a) => numberHit(p, a, (value) => Math.max(2, value * 0.2)),\n },\n {\n number: 3,\n key: \"first-400\",\n title: \"First 400+ CFS day\",\n issueKind: \"fixed\",\n issueMonth: 3,\n issueDay: 1,\n calculate: (s) => ({\n date: predictionDate(s, \"first400\", 80).toISOString(),\n }),\n actual: (s) => dateActual(s.milestones.first400?.date || null),\n final: (s) => Boolean(s.milestones.first400),\n score: (p, a) => dateHit(p, a, 10),\n },\n {\n number: 4,\n key: \"season-strength\",\n title: \"May–June rafting-season strength\",\n issueKind: \"fixed\",\n issueMonth: 4,\n issueDay: 1,\n calculate: (s) => ({\n value: Math.max(0, Math.round(requiredModel(\"river_strength\", s))),\n unit: \"cfs_average\",\n }),\n actual: (s) =>\n Number.isFinite(s.milestones.strength)\n ? { value: s.milestones.strength, unit: \"cfs_average\" }\n : null,\n final: (s) => s.cutoffAt > mountainToUtc(s.milestones.runoffYear, 7, 1, 0),\n score: (p, a) => numberHit(p, a, (value) => Math.max(100, value * 0.3)),\n },\n {\n number: 5,\n key: \"spring-peak\",\n title: \"Spring peak flow\",\n issueKind: \"fixed\",\n issueMonth: 4,\n issueDay: 15,\n calculate: (s) => {\n const date = predictionDate(s, \"spring_peak_days\", 70);\n const minutes =\n Math.round(Number(MODEL_BUNDLE.seasonal_peak_time_minutes_p50) / 15) *\n 15;\n const minuteOfDay = ((minutes % 1440) + 1440) % 1440;\n const timestamp = mountainToUtc(\n date.getUTCFullYear(),\n date.getUTCMonth() + 1,\n date.getUTCDate(),\n Math.floor(minuteOfDay / 60),\n minuteOfDay % 60,\n );\n const flow = Math.round(\n Math.max(\n s.current.value,\n s.milestones.peakDaily?.value || 0,\n requiredModel(\"spring_peak_flow\", s),\n ),\n );\n return { timestamp: timestamp.toISOString(), value: flow, unit: \"cfs\" };\n },\n actual: (s) =>\n s.milestones.peakInstant\n ? {\n timestamp: s.milestones.peakInstant.date.toISOString(),\n value: s.milestones.peakInstant.value,\n unit: \"cfs\",\n }\n : null,\n final: (s) => s.cutoffAt > mountainToUtc(s.milestones.runoffYear, 8, 1, 0),\n score: (p, a) => {\n const hours =\n Math.abs(\n new Date(String(p.timestamp)).getTime() -\n new Date(String(a.timestamp)).getTime(),\n ) / 3_600_000;\n return hours <= 168 &&\n numberHit(p, a, (value) => Math.max(250, value * 0.3));\n },\n },\n {\n number: 6,\n key: \"rafting-days\",\n title: \"Rafting-flow days\",\n issueKind: \"fixed\",\n issueMonth: 5,\n issueDay: 1,\n calculate: (s) => ({\n p300: Math.round(\n clamp(\n Math.max(s.milestones.counts.p300, requiredModel(\"days_ge_300\", s)),\n s.milestones.counts.p300,\n 140,\n ),\n ),\n p600: Math.round(\n clamp(\n Math.max(s.milestones.counts.p600, requiredModel(\"days_ge_600\", s)),\n s.milestones.counts.p600,\n 140,\n ),\n ),\n p800: Math.round(\n clamp(\n Math.max(s.milestones.counts.p800, requiredModel(\"days_ge_800\", s)),\n s.milestones.counts.p800,\n 140,\n ),\n ),\n }),\n actual: (s) => ({ ...s.milestones.counts }),\n final: (s) =>\n s.cutoffAt > addDays(firstMondayOfSeptember(s.milestones.runoffYear), 1),\n score: (p, a) =>\n [\"p300\", \"p600\", \"p800\"].filter((key) =>\n Math.abs(Number(p[key]) - Number(a[key])) <= 10\n ).length >= 2,\n },\n {\n number: 7,\n key: \"tubing-opening\",\n title: \"Tubing Season Opening Day\",\n issueKind: \"event\",\n trigger: (s) => s.milestones.tubingForecastTrigger?.date || null,\n calculate: (s) => ({\n date: tubingOpeningForecast(s.features, s.cutoffAt).toISOString(),\n }),\n actual: (s) => dateActual(s.milestones.tubingOpening),\n final: (s) => Boolean(s.milestones.tubingOpening),\n score: (p, a) => dateHit(p, a, 7),\n },\n {\n number: 8,\n key: \"remaining-tubing-days\",\n title: \"Remaining tubing-range days\",\n issueKind: \"event\",\n trigger: (s) => s.milestones.tubingOpening,\n calculate: (s) => {\n const observed = countRemainingTubingDays(s) || 0;\n const preOpeningDays = Math.max(0, s.milestones.counts.tubing - observed);\n const allSeasonEstimate = Math.max(\n observed,\n requiredModel(\"tubing_days\", s) - preOpeningDays,\n );\n return {\n value: Math.round(\n clamp(allSeasonEstimate, observed, observed + context(s).daysLeft),\n ),\n unit: \"days\",\n };\n },\n actual: (s) => {\n const value = countRemainingTubingDays(s);\n return value === null ? null : { value, unit: \"days\" };\n },\n final: (s) =>\n s.cutoffAt > addDays(firstMondayOfSeptember(s.milestones.runoffYear), 1),\n score: (p, a) => Math.abs(Number(p.value) - Number(a.value)) <= 10,\n },\n];",[208],"fca2efcf-dd79-4048-b533-6008b36bf0dd","models.ts","5fc26ee2-ab9d-11f1-80fd-1607ee4eb77e",72,["D",1788882799219],[216],"e606d5c4-9c9d-4419-92de-0ee0d46dda2e","models-full-old.ts","c5f98036-ab9a-11f1-8a31-1607ee4eb77e",70,["D",1788882784046],"import {\n MODEL_BUNDLE,\n SMALL_RIGHT_NOW_MODELS,\n TUBING_OPEN_LIVE_MODEL,\n} from \"./models-core.ts\";\nimport { FIRST400_TREES_1 } from \"./first400-trees-1.ts\";\nimport { FIRST400_TREES_2 } from \"./first400-trees-2.ts\";\nimport { FIRST400_TREES_3 } from \"./first400-trees-3.ts\";\nimport { FIRST400_TREES_4 } from \"./first400-trees-4.ts\";\nimport { FIRST400_TREES_5 } from \"./first400-trees-5.ts\";\n\nexport { MODEL_BUNDLE, TUBING_OPEN_LIVE_MODEL };\nexport const RIGHT_NOW_MODELS = {\n ...SMALL_RIGHT_NOW_MODELS,\n first400: {\n ...{\n \"type\": \"extra_trees\",\n \"features\": [\n \"log_flow\",\n \"log_flow_mean_7d\",\n \"log_flow_mean_30d\",\n \"relative_flow_change_7d\",\n \"swe_in\",\n \"swe_ratio\",\n \"swe_change_7d\",\n \"temperature_scaled\",\n \"prec_total_7d\",\n \"prec_total_30d\",\n \"snow_present\",\n \"season_sin\",\n \"season_cos\",\n \"season_sin_2\",\n \"season_cos_2\",\n \"melt_pressure\",\n \"rain_without_snow\",\n ],\nimport { MODEL_BUNDLE, SMALL_RIGHT_NOW_MODELS, TUBING_OPEN_LIVE_MODEL } from \"./models-core.ts\";\nimport { FIRST400_TREES_1 } from \"./first400-trees-1.ts\";\nimport { FIRST400_TREES_2 } from \"./first400-trees-2.ts\";\nimport { FIRST400_TREES_3 } from \"./first400-trees-3.ts\";\nimport { FIRST400_TREES_4 } from \"./first400-trees-4.ts\";\nimport { FIRST400_TREES_5 } from \"./first400-trees-5.ts\";\n\nexport { MODEL_BUNDLE, TUBING_OPEN_LIVE_MODEL };\nexport const RIGHT_NOW_MODELS = {\n ...SMALL_RIGHT_NOW_MODELS,\n first400: { ...{\"type\":\"extra_trees\",\"features\":[\"log_flow\",\"log_flow_mean_7d\",\"log_flow_mean_30d\",\"relative_flow_change_7d\",\"swe_in\",\"swe_ratio\",\"swe_change_7d\",\"temperature_scaled\",\"prec_total_7d\",\"prec_total_30d\",\"snow_present\",\"season_sin\",\"season_cos\",\"season_sin_2\",\"season_cos_2\",\"melt_pressure\",\"rain_without_snow\"],\"audit\":{\"model\":\"extra_trees\",\"hit_rate\":0.8112244897959183,\"mae\":6.468764022471184,\"n\":196}}, trees: [...FIRST400_TREES_1, ...FIRST400_TREES_2, ...FIRST400_TREES_3, ...FIRST400_TREES_4, ...FIRST400_TREES_5] },\n} as const;\n \"audit\": { \"model\": \"extra_trees\", \"hit_rate\": 0.8112244897959183, \"mae\": 6.468764022471184,\n \"n\": 196,\n },\n },\n trees: [\n ...FIRST400_TREES_1,\n ...FIRST400_TREES_2,\n ...FIRST400_TREES_3,\n ...FIRST400_TREES_4,\n ...FIRST400_TREES_5,\n ],\n },\n} as const;",[222],"98a0163b-4643-4ce8-be3c-518473f83708","models-core.ts","3bf39924-ab9c-11f1-b3b0-1607ee4eb77e",37,["D",1788882295796],1,[229],"bf202416-840a-4802-9fd4-80fdad350078","model-runtime.ts","d95c128a-ab9d-11f1-8034-1607ee4eb77e",84,["D",1788882999788],"// Val-scoped SQLite keeps this project's records isolated and returns rows as\n// named objects (the legacy account-global database returns arrays).\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type StoredPrediction = {\n water_year: number;\n question_number: number;\n question_key: string;\n title: string;\n mode: string;\n issue_kind: string;\n issue_due_at: string;\n locked_at: string;\n input_cutoff_at: string;\n model_version: string;\n model_hash: string;\n prediction_json: string;\n inputs_json: string;\n inputs_hash: string;\n source_status_json: string;\n status: string;\n actual_json: string | null;\n score: string | null;\n scored_at: string | null;\n};\n\nexport async function initDb(): Promise {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS bh_seasons (\n water_year INTEGER PRIMARY KEY,\n opened_at TEXT NOT NULL,\n state TEXT NOT NULL DEFAULT 'active',\n model_bundle_version TEXT NOT NULL,\n completed_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_predictions (\n water_year INTEGER NOT NULL,\n question_number INTEGER NOT NULL,\n question_key TEXT NOT NULL,\n title TEXT NOT NULL,\n mode TEXT NOT NULL CHECK(mode IN ('shadow','live')),\n issue_kind TEXT NOT NULL,\n issue_due_at TEXT NOT NULL,\n locked_at TEXT NOT NULL,\n input_cutoff_at TEXT NOT NULL,\n model_version TEXT NOT NULL,\n model_hash TEXT NOT NULL,\n prediction_json TEXT NOT NULL,\n inputs_json TEXT NOT NULL,\n inputs_hash TEXT NOT NULL,\n source_status_json TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'locked',\n actual_json TEXT,\n score TEXT CHECK(score IN ('hit','miss') OR score IS NULL),\n scored_at TEXT,\n PRIMARY KEY (water_year, question_number, mode)\n )`,\n `CREATE TABLE IF NOT EXISTS bh_runs (\n id TEXT PRIMARY KEY,\n ran_at TEXT NOT NULL,\n mode TEXT NOT NULL,\n success INTEGER NOT NULL,\n message TEXT NOT NULL,\n source_status_json TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS bh_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n water_year INTEGER NOT NULL,\n question_number INTEGER,\n event_type TEXT NOT NULL,\n occurred_at TEXT NOT NULL,\n payload_json TEXT NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS bh_public_cache (\n cache_key TEXT PRIMARY KEY,\n value_json TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`,\n `CREATE TRIGGER IF NOT EXISTS bh_locked_prediction_immutable\n BEFORE UPDATE OF issue_due_at, locked_at, input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash\n ON bh_predictions\n BEGIN SELECT RAISE(ABORT, 'Locked Black Hat prediction fields are immutable'); END`,\n ]);\n}\n\nexport async function ensureSeason(\n waterYear: number,\n modelVersion: string,\n openedAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO bh_seasons(water_year, opened_at, model_bundle_version) VALUES (?, ?, ?)`,\n args: [waterYear, openedAt.toISOString(), modelVersion],\n });\n}\n\nexport async function getPrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND question_number=? AND mode=?`,\n args: [waterYear, questionNumber, mode],\n });\n return (result.rows[0] as any) || null;\n}\n\nexport async function lockPrediction(row: StoredPrediction): Promise {\n const result = await sqlite.execute({\n sql: `INSERT OR IGNORE INTO bh_predictions(\n water_year, question_number, question_key, title, mode, issue_kind, issue_due_at, locked_at,\n input_cutoff_at, model_version, model_hash, prediction_json, inputs_json, inputs_hash,\n source_status_json, status, actual_json, score, scored_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n row.water_year,\n row.question_number,\n row.question_key,\n row.title,\n row.mode,\n row.issue_kind,\n row.issue_due_at,\n row.locked_at,\n row.input_cutoff_at,\n row.model_version,\n row.model_hash,\n row.prediction_json,\n row.inputs_json,\n row.inputs_hash,\n row.source_status_json,\n row.status,\n row.actual_json,\n row.score,\n row.scored_at,\n ],\n });\n return Number(result.rowsAffected) === 1;\n}\n\nexport async function finalizePrediction(\n waterYear: number,\n questionNumber: number,\n mode: string,\n actualJson: string,\n hit: boolean,\n scoredAt: Date,\n): Promise {\n await sqlite.execute({\n sql:\n `UPDATE bh_predictions SET actual_json=?, score=?, status='scored', scored_at=?\n WHERE water_year=? AND question_number=? AND mode=? AND scored_at IS NULL`,\n args: [\n actualJson,\n hit ? \"hit\" : \"miss\",\n scoredAt.toISOString(),\n waterYear,\n questionNumber,\n mode,\n ],\n });\n}\n\nexport async function recordEvent(\n waterYear: number,\n questionNumber: number | null,\n eventType: string,\n occurredAt: Date,\n payload: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_events(water_year, question_number, event_type, occurred_at, payload_json) VALUES (?, ?, ?, ?, ?)`,\n args: [\n waterYear,\n questionNumber,\n eventType,\n occurredAt.toISOString(),\n JSON.stringify(payload),\n ],\n });\n}\n\nexport async function recordRun(\n success: boolean,\n mode: string,\n message: string,\n sourceStatus: unknown = null,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_runs(id, ran_at, mode, success, message, source_status_json) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n crypto.randomUUID(),\n new Date().toISOString(),\n mode,\n success ? 1 : 0,\n message,\n sourceStatus ? JSON.stringify(sourceStatus) : null,\n ],\n });\n}\n\nexport async function listPredictions(\n waterYear: number,\n mode: string,\n): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT * FROM bh_predictions WHERE water_year=? AND mode=? ORDER BY question_number`,\n args: [waterYear, mode],\n });\n return result.rows as any;\n}\n\nexport async function recentRuns(limit = 10): Promise {\n const result = await sqlite.execute({\n sql:\n `SELECT ran_at, mode, success, message, source_status_json FROM bh_runs ORDER BY ran_at DESC LIMIT ?`,\n args: [limit],\n });\n return result.rows as any;\n}\n\nexport async function cachePublicFeed(\n key: string,\n value: unknown,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO bh_public_cache(cache_key, value_json, updated_at) VALUES (?, ?, ?)\n ON CONFLICT(cache_key) DO UPDATE SET value_json=excluded.value_json, updated_at=excluded.updated_at`,\n args: [key, JSON.stringify(value), new Date().toISOString()],\n });\n}\n\nexport async function getPublicFeed(\n key: string,\n): Promise<{ value: any; updatedAt: string } | null> {\n const result = await sqlite.execute({\n sql: `SELECT value_json, updated_at FROM bh_public_cache WHERE cache_key=?`,\n args: [key],\n });\n const row: any = result.rows[0];\n return row\n ? {\n value: JSON.parse(String(row.value_json)),\n updatedAt: String(row.updated_at),\n }\n : null;\n}",[236],"3cf0fa99-c590-4138-8f42-0c3314a043cf","model-runtime-old.ts","9e38bf58-ab9a-11f1-9797-1607ee4eb77e",78,["D",1788882986481],5,[243],"71a8dd41-9d07-48a4-a2e5-49b174c0d3a7","main.ts",67,["D",1788882631456],3,"http","import { CONFIG } from \"./config.ts\";\nimport { getPublicFeed, initDb } from \"./storage.ts\";\n\nfunction cors(origin: string | null): HeadersInit {\n const headers: Record = {\n \"Access-Control-Allow-Methods\": \"GET, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n \"Cache-Control\": \"public, max-age=300, stale-while-revalidate=3600\",\n \"Content-Type\": \"application/json; charset=utf-8\",\n \"Vary\": \"Origin\",\n };\n if (origin && CONFIG.allowedOrigins.has(origin)) {\n headers[\"Access-Control-Allow-Origin\"] = origin;\n }\n return headers;\n}\n\nexport default async function (req: Request): Promise {\n const origin = req.headers.get(\"origin\");\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: cors(origin) });\n }\n if (req.method !== \"GET\") {\n return Response.json({ error: \"Read-only endpoint\" }, {\n status: 405,\n headers: cors(origin),\n });\n }\n await initDb();\n const url = new URL(req.url);\n const key = url.searchParams.get(\"year\")\n ? `scoreboard-${url.searchParams.get(\"year\")}`\n : \"scoreboard-current\";\n const cached = await getPublicFeed(key);\n if (!cached) {\n return Response.json({\n error: \"The scoreboard has not completed its first run yet.\",\n }, { status: 503, headers: cors(origin) });\n }\n return Response.json({\n ...cached.value,\n served_at: new Date().toISOString(),\n cache_updated_at: cached.updatedAt,\n }, { headers: cors(origin) });\n}",[250],"897ff7c2-3743-4e65-9376-bbd7003740f8","lab.ts","30c7c606-aa20-11f1-9651-1607ee4eb77e",["D",1788719065897],"/**\n * Black Hat Hydrology Lab — automated San Juan River seasonal prediction tracker.\n *\n * Automatic lifecycle, year after year:\n * 1. A new season opens on October 1 (\"2025-26\", \"2026-27\", ...).\n * 2. Each prediction is locked on a fixed issue date — once locked it is\n * immutable (inputs + model version preserved, cannot be overwritten).\n * 3. When the season provides the answer, the result is scored and stored\n * alongside the original forecast.\n * 4. The previous (now-finished) season remains available as the \"film room.\"\n * 5. The public page serves all records read-only.\n */\nimport { Database } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Project-scoped persistent SQLite store.\nexport const db = new Database(\"/blackhat.sqlite\");\ninit();\n\nfunction init() {\n db.exec(`\n CREATE TABLE IF NOT EXISTS predictions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n season TEXT NOT NULL,\n issue_date TEXT NOT NULL,\n locked INTEGER NOT NULL DEFAULT 0,\n forecast TEXT NOT NULL, -- JSON: { headline, inputs, model_version }\n result TEXT, -- JSON: actual observation\n score REAL,\n created_at TEXT NOT NULL,\n scored_at TEXT\n );\n CREATE INDEX IF NOT EXISTS idx_season ON predictions (season);\n `);\n}\n\n// ---- Helpers ---------------------------------------------------------------\n\n/** Season slug from a date: Oct 2025 -> \"2025-26\" (seasons start Oct 1, UTC). */\nfunction seasonSlug(date = new Date()): string {\n const y = date.getUTCFullYear();\n return date.getUTCMonth() >= 9 ? `${y}-${(y + 1) % 100}` : `${y - 1}-${y % 100}`;\n}\n\n/** Season currently in effect today. Oct 1 rolls this over automatically. */\nfunction currentSeason(): string {\n return seasonSlug(new Date());\n}\n\n/** Lock a prediction on its fixed issue date. Refuses to overwrite once locked. */\nexport function lockPrediction(p: {\n issueDate: string; // ISO date (UTC) the prediction is issued on\n headline: string;\n inputs: object;\n modelVersion: string;\n}): { ok: boolean; id?: number; error?: string } {\n const season = seasonSlug(new Date(p.issueDate));\n const existing = db\n .query(\"SELECT id, locked FROM predictions WHERE season = ? AND issue_date = ?\", [\n season,\n p.issueDate,\n ])\n .next();\n if (existing && existing[1] === 1) {\n return { ok: false, id: Number(existing[0]), error: \"Prediction already locked — immutable.\" };\n }\n const forecast = JSON.stringify({\n headline: p.headline,\n inputs: p.inputs,\n model_version: p.modelVersion,\n });\n if (existing) {\n db.exec(\"UPDATE predictions SET forecast = ?, locked = 1 WHERE id = ?\", [\n forecast,\n Number(existing[0]),\n ]);\n return { ok: true, id: Number(existing[0]) };\n }\n const id = db.exec(\n \"INSERT INTO predictions (season, issue_date, locked, forecast, created_at) VALUES (?, ?, 1, ?, ?)\",\n [season, p.issueDate, forecast, new Date(p.issueDate).toISOString()],\n );\n return { ok: true, id: Number(id) };\n}\n\n/** Score a locked prediction once the season provides the answer. */\nexport function scorePrediction(\n issueDate: string,\n actual: object,\n score: number,\n): { ok: boolean; id?: number; error?: string } {\n const existing = db\n .query(\"SELECT id, locked FROM predictions WHERE season = ? AND issue_date = ?\", [\n seasonSlug(new Date(issueDate)),\n issueDate,\n ])\n .next();\n if (!existing) return { ok: false, error: \"Prediction not found.\" };\n if (existing[1] !== 1) return { ok: false, error: \"Prediction is not locked.\" };\n const id = Number(existing[0]);\n db.exec(\"UPDATE predictions SET result = ?, score = ?, scored_at = ? WHERE id = ?\", [\n JSON.stringify(actual),\n score,\n new Date().toISOString(),\n id,\n ]);\n return { ok: true, id };\n}\n\n/** All records (newest last) with JSON fields parsed. */\nfunction allPredictions() {\n return [...db.query(\"SELECT * FROM predictions ORDER BY issue_date\")].map((r) => ({\n id: r[0],\n season: r[1],\n issue_date: r[2],\n locked: r[3],\n forecast: JSON.parse(r[4] as string),\n result: r[5] ? JSON.parse(r[5] as string) : null,\n score: r[6],\n created_at: r[7],\n scored_at: r[8],\n }));\n}\n\n// ---- HTTP ------------------------------------------------------------------\n\nfunction layout(body: string): string {\n return `\n\nBlack Hat Hydrology Lab\n${body}`;\n}\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n\n // ---- Admin POST endpoints (write-only; guarded by secret when set) -------\n if (req.method === \"POST\" && url.pathname === \"/api/predict\") {\n if (!authorized(req)) return new Response(\"Unauthorized\", { status: 401 });\n const out = lockPrediction(await req.json());\n return jsonResponse(out, out.ok ? 201 : 400);\n }\n if (req.method === \"POST\" && url.pathname === \"/api/score\") {\n if (!authorized(req)) return new Response(\"Unauthorized\", { status: 401 });\n const { issue_date, actual, score } = await req.json();\n const out = scorePrediction(issue_date, actual, score);\n return jsonResponse(out, out.ok ? 200 : 400);\n }\n\n // ---- Public read-only JSON feed ----\n if (url.pathname === \"/data\") {\n return jsonResponse({ current_season: currentSeason(), records: allPredictions() });\n }\n\n // ---- Public read-only page ----\n const current = currentSeason();\n const bySeason = new Map>>();\n for (const r of allPredictions()) {\n const list = bySeason.get(r.season as string) ?? [];\n list.push(r);\n bySeason.set(r.season as string, list);\n }\n\n let body = `

🖤 Black Hat Hydrology Lab

San Juan River forecast experiment · Current season ${current} ·\nraw JSON

`;\n\n // Film room first: all completed seasons, most recent first.\n const completed = [...bySeason.keys()].filter((s) => s !== current).sort().reverse();\n for (const season of completed) {\n body +=\n `

Film room — ${season}

${seasonTable(bySeason.get(season)!, season)}

`;\n }\n // Current / active season last.\n body +=\n `

Current season — ${current}

${seasonTable(bySeason.get(current) ?? [], current)}

`;\n\n return new Response(layout(body), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n\nfunction seasonTable(recs: Array>, season: string): string {\n if (!recs.length) return `

No predictions locked yet for ${season}.

`;\n const rows = recs\n .map((r) => {\n const f = r.forecast as { headline: string; model_version: string };\n const s = r.score == null\n ? \"—\"\n : `= 0 ? \"win\" : \"loss\"}\">${r.score}`;\n return `${r.issue_date}${f.headline}${f.model_version}${s}`;\n })\n .join(\"\");\n return `${rows}

Issue	Forecast	Model	Score

`;\n}\n\nfunction authorized(req: Request): boolean {\n const secret = Deno.env.get(\"BH_LAB_SECRET\");\n if (!secret) return true; // no secret set → allow while building\n return req.headers.get(\"x-lab-secret\") === secret;\n}\n\nfunction jsonResponse(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data, null, 2), {\n status,\n headers: { \"content-type\": \"application/json\" },\n });\n}\n",[258],"cd4e6e69-78bd-4cf6-b43c-911ea0c17652","first400-trees-5.ts","480a27d2-ab9c-11f1-9a57-1607ee4eb77e",47,["D",1788882319621],[264],"ff4cade3-377c-486f-8c32-07fb15d4b8f1","first400-trees-4.ts","443c880c-ab9c-11f1-abb3-1607ee4eb77e",45,["D",1788882312683],[270],"82ac7bdc-eb46-4a8d-87cd-70644e230d73","first400-trees-3.ts","420ad214-ab9c-11f1-8ed7-1607ee4eb77e",43,["D",1788882306326],[276],"00e5f497-a106-4771-925a-87050315d243","first400-trees-2.ts","3df70fa8-ab9c-11f1-a43c-1607ee4eb77e",41,["D",1788882302686],[282],"1830c816-3f3d-4665-81c8-75dff77b9f4a","first400-trees-1.ts","41098f18-ab9c-11f1-99ad-1607ee4eb77e",54,["D",1788882510486],[288],"87d6c8b2-0010-49e7-9ea1-8bc8300bb9c2","engine.ts","520ed0e6-ab9e-11f1-84ac-1607ee4eb77e",102,["D",1788883191905],"import { CONFIG, IS_LIVE } from \"./config.ts\";\nimport { addDays, fixedIssueAt, mountainToUtc, waterYear } from \"./dates.ts\";\nimport { MODEL_BUNDLE } from \"./models.ts\";\nimport { QUESTIONS } from \"./questions.ts\";\nimport { fetchBasinSnapshot } from \"./sources.ts\";\nimport {\n cachePublicFeed,\n ensureSeason,\n finalizePrediction,\n getPrediction,\n initDb,\n listPredictions,\n lockPrediction,\n recentRuns,\n recordEvent,\n recordRun,\n} from \"./storage.ts\";\nimport type { BasinSnapshot, QuestionDefinition } from \"./types.ts\";\n\nfunction canonical(value: any): string {\n if (Array.isArray(value)) return `[${value.map(canonical).join(\",\")}]`;\n if (value && typeof value === \"object\") {\n return `{${\n Object.keys(value).sort().map((key) =>\n `${JSON.stringify(key)}:${canonical(value[key])}`\n ).join(\",\")\n }}`;\n }\n return JSON.stringify(value);\n}\n\nasync function sha256(value: string): Promise {\n const digest = await crypto.subtle.digest(\n \"SHA-256\",\n new TextEncoder().encode(value),\n );\n return [...new Uint8Array(digest)].map((byte) =>\n byte.toString(16).padStart(2, \"0\")\n ).join(\"\");\n}\n\nfunction inputRecord(snapshot: BasinSnapshot): Record {\n const m = snapshot.milestones;\n return {\n captured_at: snapshot.capturedAt.toISOString(),\n cutoff_at: snapshot.cutoffAt.toISOString(),\n current: {\n date: snapshot.current.date.toISOString(),\n value: snapshot.current.value,\n },\n features: snapshot.features,\n milestones: {\n runoff_year: m.runoffYear,\n first_400: m.first400 &&\n { date: m.first400.date.toISOString(), value: m.first400.value },\n peak_daily: m.peakDaily &&\n { date: m.peakDaily.date.toISOString(), value: m.peakDaily.value },\n peak_instant: m.peakInstant &&\n { date: m.peakInstant.date.toISOString(), value: m.peakInstant.value },\n tubing_trigger: m.tubingForecastTrigger &&\n {\n date: m.tubingForecastTrigger.date.toISOString(),\n value: m.tubingForecastTrigger.value,\n },\n tubing_opening: m.tubingOpening?.toISOString() || null,\n counts: m.counts,\n strength: m.strength,\n persistent_snow: m.persistentSnow &&\n {\n date: m.persistentSnow.date.toISOString(),\n value: m.persistentSnow.value,\n },\n peak_swe: m.peakSwe &&\n { date: m.peakSwe.date.toISOString(), value: m.peakSwe.value },\n },\n };\n}\n\nfunction dueAt(\n question: QuestionDefinition,\n runoffYear: number,\n snapshot: BasinSnapshot,\n): Date | null {\n if (question.issueKind === \"fixed\") {\n return fixedIssueAt(runoffYear, question.issueMonth!, question.issueDay!);\n }\n return question.trigger?.(snapshot) || null;\n}\n\nfunction publicPrediction(row: any): Record {\n return {\n number: Number(row.question_number),\n key: row.question_key,\n title: row.title,\n issue_kind: row.issue_kind,\n issue_due_at: row.issue_due_at,\n locked_at: row.locked_at,\n input_cutoff_at: row.input_cutoff_at,\n model_version: row.model_version,\n prediction: JSON.parse(row.prediction_json),\n status: row.status,\n actual: row.actual_json ? JSON.parse(row.actual_json) : null,\n score: row.score,\n scored_at: row.scored_at,\n };\n}\n\nasync function refreshPublicCache(runoffYear: number): Promise {\n const live = await listPredictions(runoffYear, \"live\");\n const shadow = await listPredictions(runoffYear, \"shadow\");\n const runs = await recentRuns(5);\n const feed = {\n schema_version: 1,\n water_year: runoffYear,\n game_state: live.length ? \"live\" : \"shadow-testing\",\n model: MODEL_BUNDLE,\n updated_at: new Date().toISOString(),\n predictions: live.map(publicPrediction),\n shadow_summary: {\n locked: shadow.length,\n scored: shadow.filter((row) => row.score).length,\n },\n health: runs.map((run) => ({\n ran_at: run.ran_at,\n mode: run.mode,\n success: Boolean(run.success),\n message: run.message,\n })),\n };\n await cachePublicFeed(`scoreboard-${runoffYear}`, feed);\n await cachePublicFeed(\"scoreboard-current\", feed);\n}\n\nexport async function runAutomation(\n now = new Date(),\n): Promise> {\n await initDb();\n const mode = IS_LIVE ? \"live\" : \"shadow\";\n const runoffYear = waterYear(now);\n if (runoffYear < CONFIG.firstAutomatedWaterYear) {\n // September is a preseason health check. It deliberately creates no locks,\n // but proves the official sources, models, database, cron and public cache work.\n try {\n const current = await fetchBasinSnapshot(now);\n const message =\n `Preseason ${mode} check passed. Water year ${CONFIG.firstAutomatedWaterYear} becomes eligible on October 1.`;\n await recordRun(true, mode, message, current.sourceStatus);\n await refreshPublicCache(CONFIG.firstAutomatedWaterYear);\n return {\n ok: true,\n mode,\n preseason: true,\n water_year: CONFIG.firstAutomatedWaterYear,\n message,\n source_status: current.sourceStatus,\n };\n } catch (error) {\n const message = error instanceof Error ? error.message : String(error);\n await recordRun(false, mode, `Preseason check failed: ${message}`);\n throw error;\n }\n }\n const openedAt = mountainToUtc(runoffYear - 1, 10, 1, 0);\n await ensureSeason(runoffYear, MODEL_BUNDLE.source_model_version, openedAt);\n let current: BasinSnapshot;\n try {\n current = await fetchBasinSnapshot(now);\n } catch (error) {\n const message = error instanceof Error ? error.message : String(error);\n await recordRun(false, mode, message);\n throw error;\n }\n\n const actions: string[] = [];\n const lockSnapshots = new Map();\n for (const question of QUESTIONS) {\n let stored = await getPrediction(runoffYear, question.number, mode);\n if (!stored) {\n const issueAt = dueAt(question, runoffYear, current);\n if (issueAt && now >= issueAt) {\n const ageHours = (now.getTime() - issueAt.getTime()) / 3_600_000;\n if (ageHours > CONFIG.fixedLockGraceHours) {\n actions.push(\n `P${question.number} needs review: issue window was missed`,\n );\n } else {\n const cacheKey = issueAt.toISOString();\n let lockSnapshot = lockSnapshots.get(cacheKey);\n if (!lockSnapshot) {\n lockSnapshot = await fetchBasinSnapshot(issueAt);\n lockSnapshots.set(cacheKey, lockSnapshot);\n }\n const prediction = question.calculate(lockSnapshot);\n const inputs = inputRecord(lockSnapshot);\n const predictionJson = canonical(prediction);\n const inputsJson = canonical(inputs);\n const inserted = await lockPrediction({\n water_year: runoffYear,\n question_number: question.number,\n question_key: question.key,\n title: question.title,\n mode,\n issue_kind: question.issueKind,\n issue_due_at: issueAt.toISOString(),\n locked_at: now.toISOString(),\n input_cutoff_at: issueAt.toISOString(),\n model_version: MODEL_BUNDLE.source_model_version,\n model_hash: MODEL_BUNDLE.sha256,\n prediction_json: predictionJson,\n inputs_json: inputsJson,\n inputs_hash: await sha256(inputsJson),\n source_status_json: canonical(lockSnapshot.sourceStatus),\n status: \"locked\",\n actual_json: null,\n score: null,\n scored_at: null,\n });\n if (inserted) {\n await recordEvent(\n runoffYear,\n question.number,\n `${mode}_lock_created`,\n now,\n { issue_at: issueAt.toISOString(), prediction },\n );\n actions.push(`P${question.number} ${mode} lock created`);\n stored = await getPrediction(runoffYear, question.number, mode);\n }\n }\n }\n }\n if (stored && !stored.scored_at && question.final(current)) {\n const actual = question.actual(current);\n if (actual) {\n const prediction = JSON.parse(stored.prediction_json);\n const hit = question.score(prediction, actual);\n await finalizePrediction(\n runoffYear,\n question.number,\n mode,\n canonical(actual),\n hit,\n now,\n );\n await recordEvent(\n runoffYear,\n question.number,\n `${mode}_score_finalized`,\n now,\n { actual, score: hit ? \"hit\" : \"miss\" },\n );\n actions.push(`P${question.number} scored ${hit ? \"HIT\" : \"MISS\"}`);\n }\n }\n }\n const message = actions.length\n ? actions.join(\"; \")\n : \"Data refreshed; no lock or score was due.\";\n await recordRun(true, mode, message, current.sourceStatus);\n await refreshPublicCache(runoffYear);\n return {\n ok: true,\n mode,\n water_year: runoffYear,\n actions,\n source_status: current.sourceStatus,\n };\n}",[294],"62109e24-6ec6-45e4-9c7f-6c3eaaf8e9fb","engine-old.ts","a6362ff6-ab9a-11f1-9797-1607ee4eb77e",94,["D",1788883026203],[301],"5c5fb06d-0c56-490b-8d6c-f0b6e727cedf","dates-old.ts","8d25a690-ab9a-11f1-ade0-1607ee4eb77e",74,["D",1788882955145],"import { CONFIG } from \"./config.ts\";\n\nconst DAY = 86_400_000;\n\nexport function addDays(date: Date, days: number): Date {\n return new Date(date.getTime() + days * DAY);\n}\n\nexport function isoDay(date: Date): string {\n return date.toISOString().slice(0, 10);\n}\n\nexport function mountainParts(\n date: Date,\n): { year: number; month: number; day: number; hour: number } {\n const parts = new Intl.DateTimeFormat(\"en-US\", {\n timeZone: CONFIG.timeZone,\n year: \"numeric\",\n month: \"numeric\",\n day: \"numeric\",\n hour: \"numeric\",\n hourCycle: \"h23\",\n }).formatToParts(date);\n const values = Object.fromEntries(\n parts.filter((part) => part.type !== \"literal\").map((\n part,\n ) => [part.type, Number(part.value)]),\n );\n return values as { year: number; month: number; day: number; hour: number };\n}\n\n// Converts a wall-clock time in America/Denver to UTC without requiring a date library.\nexport function mountainToUtc(\n year: number,\n month: number,\n day: number,\n hour = 0,\n minute = 0,\n): Date {\n let guess = new Date(Date.UTC(year, month - 1, day, hour, minute));\n for (let attempt = 0; attempt < 3; attempt += 1) {\n const seen = mountainParts(guess);\n const wanted = Date.UTC(year, month - 1, day, hour, minute);\n const actual = Date.UTC(\n seen.year,\n seen.month - 1,\n seen.day,\n seen.hour,\n minute,\n );\n guess = new Date(guess.getTime() + wanted - actual);\n }\n return guess;\n}\n\nexport function mountainCalendarDate(date: Date): Date {\n const p = mountainParts(date);\n return new Date(Date.UTC(p.year, p.month - 1, p.day, 12));\n}\n\nexport function waterYear(date: Date): number {\n const p = mountainParts(date);\n return p.month >= 10 ? p.year + 1 : p.year;\n}\n\nexport function fixedIssueAt(\n runoffYear: number,\n month: number,\n day: number,\n): Date {\n const year = month >= 10 ? runoffYear - 1 : runoffYear;\n return mountainToUtc(year, month, day, CONFIG.lockHourMountain);\n}\n\nexport function firstMondayOfSeptember(year: number): Date {\n const first = new Date(Date.UTC(year, 8, 1, 12));\n const offset = (8 - first.getUTCDay()) % 7;\n return addDays(first, offset);\n}\n\nexport function daysBetween(a: Date, b: Date): number {\n return Math.round(\n (mountainCalendarDate(a).getTime() - mountainCalendarDate(b).getTime()) /\n DAY,\n );\n}\n\nexport function afterMountainDay(\n date: Date,\n year: number,\n month: number,\n day: number,\n): boolean {\n return mountainCalendarDate(date) >\n new Date(Date.UTC(year, month - 1, day, 23, 59, 59));\n}",[307],"25356f1b-d067-4cfa-813e-b15e7d267006","cron.ts","a7fd641c-ab9a-11f1-83fc-1607ee4eb77e",98,["D",1788883042782],9,"interval","import { runAutomation } from \"./engine.ts\";\n\nexport default async function (_interval: { lastRunAt?: Date }): Promise {\n const result = await runAutomation(new Date());\n console.log(JSON.stringify(result));\n}",[314],"2105a0ef-fb80-4e08-8cc6-64a92f17070e","config.ts","62a61c66-ab9e-11f1-997f-1607ee4eb77e",106,["D",1788883219504],"export const CONFIG = {\n username: \"pagosaoutside\",\n projectName: \"black-hat-hydrology\",\n timeZone: \"America/Denver\",\n lockHourMountain: 9,\n fixedLockGraceHours: 36,\n firstAutomatedWaterYear: 2027,\n // Leave this in shadow mode until the preseason checks have passed.\n mode: String(\n (globalThis as any).Deno?.env?.get?.(\"BLACK_HAT_MODE\") || \"shadow\",\n ).toLowerCase(),\n allowedOrigins: new Set([\n \"https://pagosaoutside.com\",\n \"https://www.pagosaoutside.com\",\n ]),\n usgsSite: \"09342500\",\n snotelStations: [\"840:CO:SNTL\", \"874:CO:SNTL\"],\n modelVersion: \"0.5.0-2027-game\",\n} as const;\n\nexport const IS_LIVE = CONFIG.mode === \"live\";",[323],"8bf1d3fe-d7d6-423b-9132-ebd97d5addd9","backup2-types.ts","9a8b01ea-ab9a-11f1-9797-1607ee4eb77e",107,["D",1788883221085],[330],"55592c97-1ccf-4492-9800-9a939536a0ee","backup2-engine.ts","f166b394-ab9d-11f1-a7c3-1607ee4eb77e",99,["D",1788883188786],[336],"48b03710-a87b-43f1-ae8e-1b02eba0288f",["D",1788883225618],[28],"804a629b-f45e-40ff-8de0-032427a2d5ce","backup2-config.ts","377dfa62-ab9a-11f1-ac1e-1607ee4eb77e",103,["D",1788883216481],[345],"pulls","branches","forks","envVars",{"_357":63,"_359":63},"connections",{"_357":63,"_358":63},"count","unfilledCount","emptyCount",{"_43":344,"_32":345,"_30":346,"_162":-5,"_41":42,"_40":347,"_164":59,"_38":470,"_13":253,"_34":35,"_36":327,"_24":25,"_168":-5,"_389":471,"_27":472},{"_43":341,"_32":28,"_30":31,"_162":-5,"_41":42,"_40":14,"_164":59,"_38":467,"_13":253,"_34":35,"_36":37,"_24":25,"_168":-5,"_389":468,"_27":469},{"_43":335,"_32":336,"_30":337,"_162":-5,"_41":42,"_40":338,"_164":59,"_38":464,"_13":166,"_34":35,"_36":110,"_24":25,"_168":-5,"_389":465,"_27":466},{"_43":329,"_32":330,"_30":331,"_162":-5,"_41":42,"_40":332,"_164":59,"_38":461,"_13":253,"_34":35,"_36":167,"_24":25,"_168":-5,"_389":462,"_27":463},{"_43":322,"_32":323,"_30":324,"_162":-5,"_41":42,"_40":325,"_164":59,"_38":458,"_13":166,"_34":35,"_36":327,"_24":25,"_168":-5,"_389":459,"_27":460},{"_43":313,"_32":314,"_30":315,"_162":-5,"_41":42,"_40":316,"_164":25,"_38":455,"_13":318,"_34":319,"_36":320,"_24":25,"_168":-5,"_389":456,"_27":457},{"_43":306,"_32":307,"_30":308,"_162":-5,"_41":42,"_40":309,"_164":59,"_38":452,"_13":253,"_34":35,"_36":311,"_24":25,"_168":-5,"_389":453,"_27":454},{"_43":300,"_32":301,"_30":302,"_162":-5,"_41":42,"_40":303,"_164":59,"_38":449,"_13":212,"_34":35,"_36":298,"_24":25,"_168":-5,"_389":450,"_27":451},{"_43":293,"_32":294,"_30":295,"_162":-5,"_41":42,"_40":296,"_164":25,"_38":446,"_13":166,"_34":35,"_36":298,"_24":25,"_168":-5,"_389":447,"_27":448},{"_43":287,"_32":288,"_30":289,"_162":-5,"_41":42,"_40":290,"_164":25,"_38":443,"_13":233,"_34":35,"_36":110,"_24":25,"_168":-5,"_389":444,"_27":445},{"_43":281,"_32":282,"_30":283,"_162":-5,"_41":42,"_40":284,"_164":25,"_38":440,"_13":166,"_34":35,"_36":110,"_24":25,"_168":-5,"_389":441,"_27":442},{"_43":275,"_32":276,"_30":277,"_162":-5,"_41":42,"_40":278,"_164":25,"_38":437,"_13":233,"_34":35,"_36":110,"_24":25,"_168":-5,"_389":438,"_27":439},{"_43":269,"_32":270,"_30":271,"_162":-5,"_41":42,"_40":272,"_164":25,"_38":434,"_13":233,"_34":35,"_36":110,"_24":25,"_168":-5,"_389":435,"_27":436},{"_43":263,"_32":264,"_30":265,"_162":-5,"_41":42,"_40":266,"_164":25,"_38":431,"_13":233,"_34":35,"_36":110,"_24":25,"_168":-5,"_389":432,"_27":433},{"_43":257,"_32":258,"_30":259,"_162":-5,"_41":42,"_40":166,"_164":59,"_38":428,"_13":63,"_34":254,"_36":261,"_24":25,"_168":-5,"_389":429,"_27":430},{"_43":249,"_32":250,"_30":57,"_162":-5,"_41":42,"_40":251,"_164":25,"_38":425,"_13":253,"_34":254,"_36":255,"_24":25,"_168":-5,"_389":426,"_27":427},{"_43":242,"_32":243,"_30":244,"_162":-5,"_41":42,"_40":245,"_164":59,"_38":422,"_13":247,"_34":35,"_36":37,"_24":25,"_168":-5,"_389":423,"_27":424},{"_43":235,"_32":236,"_30":237,"_162":-5,"_41":42,"_40":238,"_164":25,"_38":419,"_13":166,"_34":35,"_36":240,"_24":25,"_168":-5,"_389":420,"_27":421},{"_43":228,"_32":229,"_30":230,"_162":-5,"_41":42,"_40":231,"_164":25,"_38":416,"_13":233,"_34":35,"_36":110,"_24":25,"_168":-5,"_389":417,"_27":418},{"_43":221,"_32":222,"_30":223,"_162":-5,"_41":42,"_40":224,"_164":59,"_38":413,"_13":212,"_34":35,"_36":226,"_24":25,"_168":-5,"_389":414,"_27":415},{"_43":215,"_32":216,"_30":217,"_162":-5,"_41":42,"_40":218,"_164":25,"_38":410,"_13":166,"_34":35,"_36":37,"_24":25,"_168":-5,"_389":411,"_27":412},{"_43":207,"_32":208,"_30":209,"_162":-5,"_41":42,"_40":210,"_164":59,"_38":407,"_13":212,"_34":35,"_36":213,"_24":25,"_168":-5,"_389":408,"_27":409},{"_43":200,"_32":201,"_30":202,"_162":-5,"_41":42,"_40":203,"_164":25,"_38":404,"_13":166,"_34":35,"_36":205,"_24":25,"_168":-5,"_389":405,"_27":406},{"_43":192,"_32":193,"_30":194,"_162":-5,"_41":42,"_40":195,"_164":59,"_38":401,"_13":197,"_34":35,"_36":198,"_24":25,"_168":-5,"_389":402,"_27":403},{"_43":185,"_32":186,"_30":187,"_162":-5,"_41":42,"_40":188,"_164":25,"_38":398,"_13":166,"_34":35,"_36":190,"_24":25,"_168":-5,"_389":399,"_27":400},{"_43":177,"_32":178,"_30":179,"_162":-5,"_41":42,"_40":180,"_164":59,"_38":395,"_13":182,"_34":35,"_36":183,"_24":25,"_168":-5,"_389":396,"_27":397},{"_43":170,"_32":171,"_30":172,"_162":-5,"_41":42,"_40":173,"_164":25,"_38":392,"_13":166,"_34":35,"_36":175,"_24":25,"_168":-5,"_389":393,"_27":394},{"_43":159,"_32":160,"_30":161,"_162":-5,"_41":42,"_40":163,"_164":59,"_38":388,"_13":166,"_34":35,"_36":167,"_24":25,"_168":-5,"_389":390,"_27":391},["D",1788883223981],"children",[],[160],["D",1788883011380],[],[171],["D",1788882997593],[],[178],["D",1788883016977],[],[186],["D",1788883009046],[],[193],["D",1788883028580],[],[201],["D",1788883014695],[],[208],["D",1788882799219],[],[216],["D",1788882784046],[],[222],["D",1788882295796],[],[229],["D",1788882999788],[],[236],["D",1788882986481],[],[243],["D",1788882631456],[],[250],["D",1788719065897],[],[258],["D",1788882319621],[],[264],["D",1788882312683],[],[270],["D",1788882306326],[],[276],["D",1788882302686],[],[282],["D",1788882510486],[],[288],["D",1788883191905],[],[294],["D",1788883026203],[],[301],["D",1788882955145],[],[307],["D",1788883042782],[],[314],["D",1788883219504],[],[323],["D",1788883221085],[],[330],["D",1788883188786],[],[336],["D",1788883225618],[],[28],["D",1788883216481],[],[345],["D",1788718960405],["D",1789575110896],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_128":511,"_512":513,"_514":515,"_516":25,"_517":25,"_518":25,"_519":59,"_520":-5,"_521":-7,"_522":-7,"_523":63,"_524":25,"_525":25,"_526":-5,"_527":25,"_528":25,"_529":25,"_530":-5},"ENV",{"_482":483,"_484":485,"_486":90,"_487":488,"_489":490,"_491":492,"_493":494,"_495":496,"_497":498,"_499":500,"_501":502,"_503":504,"_505":506,"_507":508,"_509":510},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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"]

Diff · v111