[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_198":199,"_200":201},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":90,"_27":36,"_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":59,"_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":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",26,"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","dashboard.ts","latestPath","fileId","8a9276dc-b050-11f1-9e1c-1607ee4eb77e","name","fileType","script","content","","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...

","createdAt",["D",1789399555102],"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","246a3b70-b04f-11f1-8308-1607ee4eb77e","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",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":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",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":193,"_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":194,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":195,"_84":196,"_86":197,"_88":25},"tree",[176,177,178,179],"files",[176,177,178,179],"counts",{"_165":63,"_166":167,"_168":63,"_169":170,"_171":172},"contents",[129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":157,"_32":158,"_30":57,"_134":-5,"_41":42,"_40":159,"_135":25,"_38":160,"_13":161,"_33":162,"_35":163,"_24":25,"_138":-5,"_27":164},{"_43":149,"_32":150,"_30":151,"_134":-5,"_41":42,"_40":152,"_135":59,"_38":153,"_13":154,"_33":34,"_35":155,"_24":25,"_138":-5,"_27":156},{"_43":140,"_32":141,"_30":142,"_134":-5,"_41":42,"_40":143,"_135":59,"_38":144,"_13":145,"_33":146,"_35":147,"_24":25,"_138":-5,"_27":148},{"_43":133,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_135":25,"_38":136,"_13":137,"_33":34,"_35":37,"_24":25,"_138":-5,"_27":139},"3f52010d-60e2-4f76-8e36-3840d4028dcf","parentId","latest",["D",1789399555102],2,"label",[28],"61638b7d-3f31-4336-afda-50b61f71f94b","cron.ts","7339f200-b04e-11f1-bcd1-1607ee4eb77e",18,["D",1789398912658],5,"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.\");",[141],"a2f56e8c-80c7-4161-aa2c-74fe0ecbc165","create_stream_data_table.ts","16692f7c-b040-11f1-b9ff-1607ee4eb77e",12,["D",1789397849495],11,"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);",[150],"97ddec92-f44b-43ee-bced-e18ec17c3ff3","api.ts",23,["D",1789399499196],4,"http","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}",[158],"pulls","branches",1,"forks","envVars",{"_173":63,"_175":63},"connections",{"_173":63,"_174":63},"count","unfilledCount","emptyCount",{"_43":157,"_32":158,"_30":57,"_134":-5,"_41":42,"_40":159,"_135":25,"_38":190,"_13":161,"_33":162,"_35":163,"_24":25,"_138":-5,"_181":191,"_27":192},{"_43":149,"_32":150,"_30":151,"_134":-5,"_41":42,"_40":152,"_135":59,"_38":187,"_13":154,"_33":34,"_35":155,"_24":25,"_138":-5,"_181":188,"_27":189},{"_43":140,"_32":141,"_30":142,"_134":-5,"_41":42,"_40":143,"_135":59,"_38":184,"_13":145,"_33":146,"_35":147,"_24":25,"_138":-5,"_181":185,"_27":186},{"_43":133,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_135":25,"_38":180,"_13":137,"_33":34,"_35":37,"_24":25,"_138":-5,"_181":182,"_27":183},["D",1789399555102],"children",[],[28],["D",1789398912658],[],[141],["D",1789397849495],[],[150],["D",1789399499196],[],[158],["D",1789392472476],["D",1789480235853],{"_100":99,"_107":103},{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":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,"_126":231,"_232":233,"_234":235,"_236":25,"_237":25,"_238":25,"_239":59,"_240":-5,"_241":-7,"_242":-7,"_243":63,"_244":25,"_245":25,"_246":-5,"_247":25,"_248":25,"_249":25,"_250":-5},"ENV",{"_202":203,"_204":205,"_206":90,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230},"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 · v26