[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_197":198,"_199":200},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_107":89,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"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":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",30,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","api.ts","latestPath","fileId","246a3b70-b04f-11f1-8308-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function (req: Request): Promise {\n const result = await sqlite.execute(`\n SELECT station_id, station_name, timestamp, discharge_cfs, gage_height_ft, temp_f, turbidity_fnu\n FROM stream_gage_data\n WHERE timestamp = (\n SELECT MAX(timestamp) FROM stream_gage_data s2\n WHERE s2.station_id = stream_gage_data.station_id\n )\n ORDER BY station_id\n `);\n\n return new Response(JSON.stringify(result.rows), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n}","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function (req: Request): Promise {\n const result = await sqlite.execute(`\n SELECT station_id, station_name, timestamp, discharge_cfs,\n gage_height_ft,\n temp_f,\n CASE WHEN turbidity_fnu = -999999 THEN NULL ELSE turbidity_fnu END as turbidity_fnu\n FROM stream_gage_data\n WHERE id IN (\n SELECT id FROM stream_gage_data s2\n WHERE s2.station_id = stream_gage_data.station_id\n ORDER BY timestamp DESC\n LIMIT 1\n )\n ORDER BY station_id\n `);\n\n return new Response(JSON.stringify(result.rows), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n}","createdAt",["D",1789404749289],"branchVersion","branchId","a56118ee-532f-46a8-9c77-65ce4ec303d0","id","12c12bc5-78f8-4daf-a87e-fd1902248e92","stream-data-table",["D",1789392472476],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","SQLite table for holding USGS stream gage data","imageUrl","019c0137-bbaf-7392-a5a2-fbfbb90d5faf","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019c0137-bbaf-7392-a5a2-fe5a4405dccf","tursoName","12c12bc578f84dafa87efd1902248e92","tursoHostname","12c12bc578f84dafa87efd1902248e92-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789480235853],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",36,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","DOGBOX","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM4cjloQ2pmdTFQRExaMzgzUXQ2QUliYXZIcSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":192,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":193,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":194,"_83":195,"_85":196,"_87":25},"tree",[175,176,177,178],"files",[175,176,177,178],"counts",{"_164":62,"_165":166,"_167":62,"_168":169,"_170":171},"contents",[129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":161,"_32":28,"_30":31,"_136":-5,"_41":42,"_40":14,"_138":25,"_38":162,"_13":140,"_33":34,"_35":37,"_24":25,"_142":-5,"_27":163},{"_43":152,"_32":153,"_30":154,"_136":-5,"_41":42,"_40":155,"_138":58,"_38":156,"_13":157,"_33":158,"_35":159,"_24":25,"_142":-5,"_27":160},{"_43":144,"_32":145,"_30":146,"_136":-5,"_41":42,"_40":147,"_138":58,"_38":148,"_13":140,"_33":149,"_35":150,"_24":25,"_142":-5,"_27":151},{"_43":133,"_32":134,"_30":135,"_136":-5,"_41":42,"_40":137,"_138":25,"_38":139,"_13":140,"_33":34,"_35":141,"_24":25,"_142":-5,"_27":143},"1e2ef4ec-62b2-438f-bdfc-d29418e72315","dashboard.ts","8a9276dc-b050-11f1-9e1c-1607ee4eb77e","parentId",29,"latest",["D",1789399802456],5,"export default async function (req: Request): Promise {\n const apiUrl = \"https://DOGBOX--246a3b70b04f11f183081607ee4eb77e.web.val.run\";\n\n const html = `\n\n\n Catskills Stream Conditions\n \n\n\n

Catskills Stream Conditions

Esopus Creek — USGS real-time data

Current Conditions

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Station	Discharge (CFS)	Gage Height (ft)	Temp (°F)	Turbidity (FNU)	Timestamp
Loading...

\n \n\n`;\n\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}","label",[134],"61638b7d-3f31-4336-afda-50b61f71f94b","cron.ts","7339f200-b04e-11f1-bcd1-1607ee4eb77e",18,["D",1789398912658],"interval","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst STATIONS = {\n \"0136219503\": \"Big Indian\",\n \"01362200\": \"Allaben\",\n \"01362230\": \"Shandaken Tunnel\",\n \"01362500\": \"Coldbrook\",\n};\n\nconst url =\n \"https://waterservices.usgs.gov/nwis/iv/?format=json&sites=0136219503,01362198,01362200,01362230,01362500¶meterCd=00060,00065,00010,63680&siteStatus=active\";\n\nconst res = await fetch(url);\nconst data = await res.json();\n\nconst readings = {};\n\nfor (const series of data.value.timeSeries) {\n const siteNo = series.sourceInfo.siteCode[0].value;\n const paramCd = series.variable.variableCode[0].value;\n const latest = series.values[0].value[0];\n\n if (!readings[siteNo]) {\n readings[siteNo] = {\n station_id: siteNo,\n station_name: STATIONS[siteNo],\n timestamp: latest.dateTime,\n discharge_cfs: null,\n gage_height_ft: null,\n temp_f: null,\n turbidity_fnu: null,\n };\n }\n\n let value = parseFloat(latest.value);\n if (isNaN(value)) value = null;\n if (value === -999999) value = null;\n\n if (paramCd === \"00060\") readings[siteNo].discharge_cfs = value;\n if (paramCd === \"00065\") readings[siteNo].gage_height_ft = value;\n if (paramCd === \"00010\") {\n readings[siteNo].temp_f = value !== null ? (value * 9 / 5) + 32 : null;\n }\n if (paramCd === \"63680\") readings[siteNo].turbidity_fnu = value;\n}\n\nfor (const row of Object.values(readings)) {\n await sqlite.execute({\n sql:\n `INSERT INTO stream_gage_data (station_id, station_name, timestamp, discharge_cfs, gage_height_ft, temp_f, turbidity_fnu) VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [\n row.station_id,\n row.station_name,\n row.timestamp,\n row.discharge_cfs,\n row.gage_height_ft,\n row.temp_f,\n row.turbidity_fnu,\n ],\n });\n}\n\nawait sqlite.execute(\n `DELETE FROM stream_gage_data WHERE timestamp < datetime('now', '-13 months')`,\n);\n\nconsole.log(\"Done:\", Object.keys(readings).length, \"stations written.\");",[145],"a2f56e8c-80c7-4161-aa2c-74fe0ecbc165","create_stream_data_table.ts","16692f7c-b040-11f1-b9ff-1607ee4eb77e",12,["D",1789397849495],11,"script","import sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\nawait sqlite.execute(\n \"CREATE TABLE IF NOT EXISTS stream_gage_data (id INTEGER PRIMARY KEY AUTOINCREMENT, station_id TEXT NOT NULL, station_name TEXT NOT NULL, timestamp TEXT NOT NULL, discharge_cfs REAL, gage_height_ft REAL, temp_f REAL, turbidity_fnu REAL)\",\n);",[153],"71529238-074f-454a-b746-f6673c35555c",["D",1789404749289],[28],"pulls","branches",1,"forks","envVars",{"_172":62,"_174":62},"connections",{"_172":62,"_173":62},"count","unfilledCount","emptyCount",{"_43":161,"_32":28,"_30":31,"_136":-5,"_41":42,"_40":14,"_138":25,"_38":189,"_13":140,"_33":34,"_35":37,"_24":25,"_142":-5,"_180":190,"_27":191},{"_43":152,"_32":153,"_30":154,"_136":-5,"_41":42,"_40":155,"_138":58,"_38":186,"_13":157,"_33":158,"_35":159,"_24":25,"_142":-5,"_180":187,"_27":188},{"_43":144,"_32":145,"_30":146,"_136":-5,"_41":42,"_40":147,"_138":58,"_38":183,"_13":140,"_33":149,"_35":150,"_24":25,"_142":-5,"_180":184,"_27":185},{"_43":133,"_32":134,"_30":135,"_136":-5,"_41":42,"_40":137,"_138":25,"_38":179,"_13":140,"_33":34,"_35":141,"_24":25,"_142":-5,"_180":181,"_27":182},["D",1789399802456],"children",[],[134],["D",1789398912658],[],[145],["D",1789397849495],[],[153],["D",1789404749289],[],[28],["D",1789392472476],["D",1789480235853],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":230,"_231":232,"_233":234,"_235":25,"_236":25,"_237":25,"_238":58,"_239":-5,"_240":-7,"_241":-7,"_242":62,"_243":25,"_244":25,"_245":-5,"_246":25,"_247":25,"_248":25,"_249":-5},"ENV",{"_201":202,"_203":204,"_205":89,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v30