Catskills Stream Conditions

[{"_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",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_150":-5,"_20":151,"_22":152,"_153":154,"_155":156,"_26":157,"_24":158,"_159":-5,"_160":-5,"_161":52,"_162":163,"_164":43,"_165":-5,"_166":-5,"_167":168},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","DOGBOX","name","stream-data-table","branchName","main","version","path","api.ts","project",{"_33":92,"_13":14,"_44":93,"_94":-5,"_95":52,"_96":97,"_98":97,"_99":100,"_101":-5,"_102":103,"_104":36,"_105":43,"_106":-5,"_107":-5,"_108":109,"_110":111,"_112":113,"_114":115,"_116":117,"_118":-5,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_128":129,"_130":131,"_132":133,"_134":52},"tree",[55,56,57,58],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":54},"contents",[],"upstream","pull","ahead","behind","envVars","id","63895f84-52aa-42b2-ad28-a2f087a5d3cc","fileId","246a3b70-b04f-11f1-8308-1607ee4eb77e","parentId","branchId","a56118ee-532f-46a8-9c77-65ce4ec303d0","branchVersion",31,"latest",true,"createdAt",["D",1789419821209],6,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const days = parseInt(url.searchParams.get(\"days\") || \"7\");\n const station = url.searchParams.get(\"station\") || null;\n\n let sql = `\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 timestamp >= datetime('now', '-' || ? || ' days')\n `;\n\n const args: any[] = [days];\n\n if (station) {\n sql += ` AND station_id = ?`;\n args.push(station);\n }\n\n sql += ` ORDER BY station_id, timestamp ASC`;\n\n const result = await sqlite.execute({ sql, args });\n\n return new Response(JSON.stringify(result.rows), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n}","deleted",false,"label",[19],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":89,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_66":90,"_18":91},{"_33":79,"_13":80,"_35":81,"_37":-5,"_38":39,"_40":82,"_42":43,"_44":83,"_17":84,"_47":85,"_49":86,"_51":52,"_53":-5,"_66":87,"_18":88},{"_33":69,"_13":70,"_35":71,"_37":-5,"_38":39,"_40":72,"_42":43,"_44":73,"_17":74,"_47":75,"_49":76,"_51":52,"_53":-5,"_66":77,"_18":78},{"_33":59,"_13":60,"_35":61,"_37":-5,"_38":39,"_40":62,"_42":43,"_44":63,"_17":64,"_47":48,"_49":65,"_51":52,"_53":-5,"_66":67,"_18":68},"a5822dec-da02-436c-9572-afbf16036de9","dashboard.ts","8a9276dc-b050-11f1-9e1c-1607ee4eb77e",36,["D",1789420105204],10,"export default async function (req: Request): Promise {\n const apiUrl = \"https://DOGBOX--246a3b70b04f11f183081607ee4eb77e.web.val.run\";\n\n const html =\n 'Catskills Stream Conditions