[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_406":407,"_408":409},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_304":-5,"_20":305,"_22":306,"_307":308,"_309":310,"_26":311,"_24":312,"_313":-5,"_314":-5,"_315":55,"_316":317,"_318":46,"_319":-5,"_320":-5,"_321":322},"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","fgeierst","name","muenchen-plantscht-v2","branchName","main","version","path","db","project",{"_34":247,"_13":14,"_47":248,"_249":-5,"_250":55,"_251":252,"_253":252,"_254":255,"_256":-5,"_257":258,"_259":71,"_260":46,"_261":-5,"_262":-5,"_263":61,"_264":265,"_266":267,"_268":269,"_270":271,"_272":-5,"_273":274,"_275":274,"_276":277,"_278":277,"_279":277,"_280":274,"_281":274,"_282":283,"_284":285,"_286":287,"_288":55},"tree",[64,65,66,67,68],"file",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":60,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_18":63},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","c00dc9e1-a3d0-4af2-a91c-3413043f2d77","schema.ts","fileId","0c3d430c-820b-11f1-b505-1607ee4eb77e","parentId","caca4203-217f-44e5-9a2c-341ad96c7be7","branchId","97a9ba24-d203-4a34-a697-e13cd7bccf7e","branchVersion",29,"latest",true,"createdAt",["D",1784481924665],4,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/**\n * Create all tables + indexes. Idempotent: safe to run on every deploy.\n * All timestamps are ISO-8601 UTC strings, e.g. \"2024-06-01T18:00:00Z\".\n */\nexport async function migrate() {\n await sqlite.batch([\n // --- Water temperatures (lakes, rivers, feringasee) ---\n `CREATE TABLE IF NOT EXISTS water_temperatures (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n category_id INTEGER NOT NULL, -- 0 = lakes, 1 = rivers\n measurement_site TEXT NOT NULL,\n body_of_water TEXT NOT NULL,\n measured_at TEXT NOT NULL, -- ISO-8601 UTC\n water_temperature REAL NOT NULL,\n updated_at TEXT NOT NULL -- ISO-8601 UTC\n )`,\n // Upsert key: one reading per site+body+time.\n `CREATE UNIQUE INDEX IF NOT EXISTS idx_water_temperatures_unique\n ON water_temperatures (category_id, measurement_site, body_of_water, measured_at)`,\n // Read path: latest readings per body of water within a category.\n `CREATE INDEX IF NOT EXISTS idx_water_temperatures_read\n ON water_temperatures (category_id, body_of_water, measured_at)`,\n\n // --- Bodies of water catalog (presentation metadata for the UI) ---\n // Auto-populated by the water-temperature scraper (INSERT OR IGNORE by\n // category_id + name). `geopath` is curated by hand afterwards.\n `CREATE TABLE IF NOT EXISTS bodies_of_water (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n category_id INTEGER NOT NULL, -- 0 = lakes, 1 = rivers\n name TEXT NOT NULL, -- matches water_temperatures.body_of_water\n slug TEXT NOT NULL, -- generated from name\n geopath TEXT, -- optional frontend asset, e.g. \"isar.svg\"\n created_at TEXT NOT NULL -- ISO-8601 UTC\n )`,\n `CREATE UNIQUE INDEX IF NOT EXISTS idx_bodies_of_water_unique\n ON bodies_of_water (category_id, name)`,\n `CREATE INDEX IF NOT EXISTS idx_bodies_of_water_slug\n ON bodies_of_water (category_id, slug)`,\n\n // --- Bath areas catalog (SWM pool occupancy) ---\n // Roster comes from the SWM visitorCount feed itself (locations -> areas),\n // so this is auto-populated by the pools cron, not hand-seeded. Each area\n // (Hallenbad / Freibad / Sauna / ...) belongs to a location.\n `CREATE TABLE IF NOT EXISTS bath_areas (\n area_id INTEGER PRIMARY KEY, -- SWM area_id\n area_name TEXT NOT NULL,\n location_id INTEGER NOT NULL, -- SWM location_id\n location_name TEXT NOT NULL,\n active INTEGER NOT NULL DEFAULT 1, -- hide areas without deleting history\n updated_at TEXT NOT NULL -- ISO-8601 UTC\n )`,\n `CREATE INDEX IF NOT EXISTS idx_bath_areas_location\n ON bath_areas (location_id)`,\n\n // --- Pool occupancy history (area-level time series) ---\n `CREATE TABLE IF NOT EXISTS occupancy_log (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n area_id INTEGER NOT NULL, -- -> bath_areas.area_id\n customer_amount INTEGER NOT NULL, -- current occupancy\n customer_amount_max INTEGER NOT NULL, -- capacity\n recorded_at TEXT NOT NULL -- ISO-8601 UTC\n )`,\n `CREATE INDEX IF NOT EXISTS idx_occupancy_log_read\n ON occupancy_log (area_id, recorded_at)`,\n ]);\n}\n\n/**\n * Slugify a body-of-water name. Ported verbatim from v1 src/lib/slugify.js so\n * generated slugs match the frontend's expectations (ä→ae, ö→oe, ü→ue, spaces→-).\n */\nexport function slugify(text: string): string {\n const replacements: Record = { \"ä\": \"ae\", \"ö\": \"oe\", \"ü\": \"ue\" };\n text = text.toLowerCase();\n for (const [umlaut, replacement] of Object.entries(replacements)) {\n text = text.split(umlaut).join(replacement);\n }\n return text.replace(/\\s+/g, \"-\");\n}\n\n/**\n * Register any newly-seen bodies of water in the catalog. Called by the water\n * scraper with the (category_id, name) pairs it just observed. INSERT OR IGNORE\n * keeps existing rows (and their curated `geopath`) untouched.\n */\nexport async function upsertBodiesOfWater(\n bodies: { category_id: number; name: string }[],\n): Promise {\n if (bodies.length === 0) return;\n // De-dupe within this batch so we don't issue redundant inserts.\n const seen = new Set();\n const unique = bodies.filter((b) => {\n const key = `${b.category_id}\\u0000${b.name}`;\n if (seen.has(key)) return false;\n seen.add(key);\n return true;\n });\n const now = new Date().toISOString();\n await sqlite.batch(\n unique.map((b) => ({\n sql: `INSERT OR IGNORE INTO bodies_of_water (category_id, name, slug, created_at)\n VALUES (?, ?, ?, ?)`,\n args: [b.category_id, b.name, slugify(b.name), now],\n })),\n );\n}\n\n/**\n * Upsert water-temperature readings. On conflict (same category+site+body+time),\n * update the temperature and `updated_at` timestamp so re-scraping is idempotent.\n * Mirrors the upsertBathAreas pattern.\n */\nexport async function upsertWaterTemperatures(\n readings: {\n category_id: number;\n measurement_site: string;\n body_of_water: string;\n measured_at: string;\n water_temperature: number;\n }[],\n): Promise {\n if (readings.length === 0) return;\n const now = new Date().toISOString();\n await sqlite.batch(\n readings.map((r) => ({\n sql: `INSERT INTO water_temperatures\n (category_id, measurement_site, body_of_water, measured_at, water_temperature, updated_at)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(category_id, measurement_site, body_of_water, measured_at) DO UPDATE SET\n water_temperature = excluded.water_temperature,\n updated_at = excluded.updated_at`,\n args: [r.category_id, r.measurement_site, r.body_of_water, r.measured_at, r.water_temperature, now],\n })),\n );\n}\n\n/**\n * Keep the bath_areas roster in sync with the SWM feed. Upserts area/location\n * names by area_id (so renames propagate) without touching the `active` flag\n * once a row exists — you can deactivate areas by hand and it will stick.\n */\nexport async function upsertBathAreas(\n areas: { area_id: number; area_name: string; location_id: number; location_name: string }[],\n): Promise {\n if (areas.length === 0) return;\n const now = new Date().toISOString();\n await sqlite.batch(\n areas.map((a) => ({\n sql: `INSERT INTO bath_areas (area_id, area_name, location_id, location_name, active, updated_at)\n VALUES (?, ?, ?, ?, 1, ?)\n ON CONFLICT(area_id) DO UPDATE SET\n area_name = excluded.area_name,\n location_id = excluded.location_id,\n location_name = excluded.location_name,\n updated_at = excluded.updated_at`,\n args: [a.area_id, a.area_name, a.location_id, a.location_name, now],\n })),\n );\n}\n","deleted",false,"label",[19,36],"976a6e28-b4f0-46ab-825c-6a3aaea2870a",2,["D",1784311938655],0,"directory",[19],{"_34":219,"_13":220,"_37":221,"_39":-5,"_41":42,"_43":222,"_45":46,"_47":223,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_76":224,"_18":225},{"_34":186,"_13":187,"_37":188,"_39":-5,"_41":42,"_43":189,"_45":46,"_47":190,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_76":191,"_18":192},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":179,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_76":180,"_18":181},{"_34":79,"_13":80,"_37":81,"_39":-5,"_41":42,"_43":82,"_45":46,"_47":83,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_76":84,"_18":85},{"_34":69,"_13":70,"_37":71,"_39":-5,"_41":42,"_43":72,"_45":46,"_47":73,"_17":61,"_50":74,"_52":75,"_54":55,"_56":-5,"_76":77,"_18":78},"4e46ea67-aee0-40a8-9624-92b6f726de3f","main.ts","0bb3022e-820a-11f1-8221-1607ee4eb77e",1,["D",1784311508261],"http","export default async function (req: Request): Promise {\n return Response.json({ ok: true, service: \"muenchen-plantscht-v2\" });\n}\n","children",[],[70],"b6b73857-61aa-45b6-8e94-b812c6db2676","lib","611051dd-f6b0-4259-b11a-ebf7ac5e3ea0",15,["D",1784312705542],[86,87,88,89,90,91,92,93,94,95,96],[80],{"_34":172,"_13":173,"_37":174,"_39":81,"_41":42,"_43":82,"_45":46,"_47":175,"_17":61,"_50":51,"_52":176,"_54":55,"_56":-5,"_76":177,"_18":178},{"_34":165,"_13":166,"_37":167,"_39":81,"_41":42,"_43":44,"_45":46,"_47":168,"_17":61,"_50":51,"_52":169,"_54":55,"_56":-5,"_76":170,"_18":171},{"_34":158,"_13":159,"_37":160,"_39":81,"_41":42,"_43":44,"_45":46,"_47":161,"_17":61,"_50":51,"_52":162,"_54":55,"_56":-5,"_76":163,"_18":164},{"_34":151,"_13":152,"_37":153,"_39":81,"_41":42,"_43":44,"_45":46,"_47":154,"_17":61,"_50":51,"_52":155,"_54":55,"_56":-5,"_76":156,"_18":157},{"_34":144,"_13":145,"_37":146,"_39":81,"_41":42,"_43":44,"_45":46,"_47":147,"_17":61,"_50":51,"_52":148,"_54":55,"_56":-5,"_76":149,"_18":150},{"_34":136,"_13":137,"_37":138,"_39":81,"_41":42,"_43":139,"_45":46,"_47":140,"_17":61,"_50":51,"_52":141,"_54":55,"_56":-5,"_76":142,"_18":143},{"_34":128,"_13":129,"_37":130,"_39":81,"_41":42,"_43":131,"_45":46,"_47":132,"_17":61,"_50":51,"_52":133,"_54":55,"_56":-5,"_76":134,"_18":135},{"_34":120,"_13":121,"_37":122,"_39":81,"_41":42,"_43":123,"_45":46,"_47":124,"_17":59,"_50":51,"_52":125,"_54":55,"_56":-5,"_76":126,"_18":127},{"_34":112,"_13":113,"_37":114,"_39":81,"_41":42,"_43":115,"_45":46,"_47":116,"_17":61,"_50":51,"_52":117,"_54":55,"_56":-5,"_76":118,"_18":119},{"_34":105,"_13":106,"_37":107,"_39":81,"_41":42,"_43":100,"_45":46,"_47":108,"_17":61,"_50":51,"_52":109,"_54":55,"_56":-5,"_76":110,"_18":111},{"_34":97,"_13":98,"_37":99,"_39":81,"_41":42,"_43":100,"_45":46,"_47":101,"_17":61,"_50":51,"_52":102,"_54":55,"_56":-5,"_76":103,"_18":104},"b7c01dde-3d7c-49a3-a469-91e70428f239","week-time-value.ts","e0009a84-8398-11f1-a07b-1607ee4eb77e",30,["D",1784482804148],"const WEEK_MS = 7 * 24 * 60 * 60 * 1000;\nconst CANVAS_WIDTH = 200;\n\n/**\n * Map an ISO timestamp to an x-coordinate in [0, 200] over a trailing 7-day\n * window ending at `now`. `now - 7 days` → 0, `now` → 200.\n * Timestamps outside the window are clamped to the nearest edge.\n *\n * Used by api/water-temperatures.ts to generate the SVG sparkline x-coordinates\n * for the last week of water-temperature readings.\n */\nexport function weekTimeValue(iso: string, now: Date = new Date()): number {\n const windowEnd = now.getTime();\n const windowStart = windowEnd - WEEK_MS;\n const t = new Date(iso).getTime();\n const clamped = Math.max(windowStart, Math.min(windowEnd, t));\n return Math.round(((clamped - windowStart) / WEEK_MS) * CANVAS_WIDTH);\n}\n",[],[80,98],"b92e0886-bcc2-4ce5-9b50-e1f4620d5b14","week-time-value.test.ts","e0008cb0-8398-11f1-a07b-1607ee4eb77e",["D",1784482804148],"import { weekTimeValue } from \"./week-time-value.ts\";\n\nfunction assertEqual(actual: unknown, expected: unknown, label: string): void {\n const a = JSON.stringify(actual);\n const e = JSON.stringify(expected);\n if (a !== e) {\n throw new Error(`FAIL: ${label}\\n expected: ${e}\\n actual: ${a}`);\n }\n console.log(`PASS: ${label} → ${a}`);\n}\n\n// Fixed \"now\" for deterministic tests: 2026-07-19T17:00:00Z\nconst now = new Date(\"2026-07-19T17:00:00.000Z\");\n\n// \"now\" itself → x = 200 (right edge)\nassertEqual(weekTimeValue(\"2026-07-19T17:00:00.000Z\", now), 200, \"now → 200\");\n\n// Exactly 7 days ago → x = 0 (left edge)\nassertEqual(weekTimeValue(\"2026-07-12T17:00:00.000Z\", now), 0, \"7 days ago → 0\");\n\n// 3.5 days ago → x = 100 (midpoint)\nassertEqual(weekTimeValue(\"2026-07-16T05:00:00.000Z\", now), 100, \"3.5 days ago → 100\");\n\n// 1 day ago → x = 171 (6/7 of the way across)\nassertEqual(weekTimeValue(\"2026-07-18T17:00:00.000Z\", now), 171, \"1 day ago → 171\");\n\n// 10 days ago (outside window) → clamped to 0\nassertEqual(weekTimeValue(\"2026-07-09T17:00:00.000Z\", now), 0, \"10 days ago clamps to 0\");\n\n// 1 day in the future (outside window) → clamped to 200\nassertEqual(weekTimeValue(\"2026-07-20T17:00:00.000Z\", now), 200, \"future clamps to 200\");\n\nconsole.log(\"\\nAll tests passed.\");\n",[],[80,106],"35e4deb0-4c22-414a-b2d6-41e5f4f674a1","time-value.ts","788dc908-82d5-11f1-9d51-1607ee4eb77e",23,["D",1784398878706],"/**\n * Business-hours window in Berlin local time. Matches the cron guard in\n * lib/business-hours.ts (isGermanBusinessHours: hours >= 7 && hours < 23).\n */\nexport const BUSINESS_HOURS_START_HOUR = 7;\nexport const BUSINESS_HOURS_END_HOUR = 23;\n\nconst SECONDS_PER_HOUR = 3600;\nconst CANVAS_WIDTH = 200;\n\nconst windowStartSeconds =\n\tBUSINESS_HOURS_START_HOUR * SECONDS_PER_HOUR; // 25200\nconst windowEndSeconds =\n\tBUSINESS_HOURS_END_HOUR * SECONDS_PER_HOUR; // 82800\nconst windowDurationSeconds = windowEndSeconds - windowStartSeconds; // 57600\n\n/**\n * Map an ISO timestamp to an x-coordinate in [0, CANVAS_WIDTH] (0–200),\n * where 07:00 Europe/Berlin → 0 and 23:00 Europe/Berlin → 200.\n *\n * Timestamps outside the business-hours window are clamped to the nearest\n * edge so a stray overnight point never produces a negative or >200 x.\n *\n * The Berlin timezone is resolved from the timestamp itself via\n * toLocaleTimeString(\"de-DE\", { timeZone: \"Europe/Berlin\" }), so DST is\n * handled correctly — no fixed UTC offset assumption.\n */\nexport function timeValue(iso: string): number {\n\tconst time = new Date(iso).toLocaleTimeString(\"de-DE\", {\n\t\ttimeZone: \"Europe/Berlin\",\n\t});\n\tconst [hours, minutes] = time.split(\":\");\n\tconst totalSeconds =\n\t\tparseInt(hours) * SECONDS_PER_HOUR + parseInt(minutes) * 60;\n\tconst clamped = Math.max(windowStartSeconds, Math.min(windowEndSeconds, totalSeconds));\n\treturn Math.round(((clamped - windowStartSeconds) / windowDurationSeconds) * CANVAS_WIDTH);\n}\n",[],[80,113],"9075054f-40cd-452d-8405-e2f4b0a2cfe2","time-value.test.ts","7a0ab3ea-82d5-11f1-93fa-1607ee4eb77e",28,["D",1784399079539],"import { timeValue, BUSINESS_HOURS_START_HOUR, BUSINESS_HOURS_END_HOUR } from \"./time-value.ts\";\n\nfunction assertEqual(actual: unknown, expected: unknown, label: string): void {\n\tconst a = JSON.stringify(actual);\n\tconst e = JSON.stringify(expected);\n\tif (a !== e) {\n\t\tthrow new Error(`FAIL: ${label}\\n expected: ${e}\\n actual: ${a}`);\n\t}\n\tconsole.log(`PASS: ${label} → ${a}`);\n}\n\n// Constants\nassertEqual(BUSINESS_HOURS_START_HOUR, 7, \"start hour is 7\");\nassertEqual(BUSINESS_HOURS_END_HOUR, 23, \"end hour is 23\");\n\n// 07:00 Berlin (summer, UTC+2) → x = 0\n// 2026-07-18T05:00:00.000Z is 07:00 CEST\nassertEqual(timeValue(\"2026-07-18T05:00:00.000Z\"), 0, \"07:00 CEST maps to 0\");\n\n// 07:00 Berlin (winter, UTC+1) → x = 0\n// 2026-01-15T06:00:00.000Z is 07:00 CET\nassertEqual(timeValue(\"2026-01-15T06:00:00.000Z\"), 0, \"07:00 CET maps to 0\");\n\n// 15:00 Berlin (summer) → x = 100 (midpoint of 7–23h window)\n// 2026-07-18T13:00:00.000Z is 15:00 CEST\nassertEqual(timeValue(\"2026-07-18T13:00:00.000Z\"), 100, \"15:00 CEST maps to 100\");\n\n// 23:00 Berlin (summer) → x = 200\n// 2026-07-18T21:00:00.000Z is 23:00 CEST\nassertEqual(timeValue(\"2026-07-18T21:00:00.000Z\"), 200, \"23:00 CEST maps to 200\");\n\n// 22:59 Berlin (summer) → x = 200 (rounds up from 199.79)\n// 2026-07-18T20:59:00.000Z is 22:59 CEST\nassertEqual(timeValue(\"2026-07-18T20:59:00.000Z\"), 200, \"22:59 CEST maps to 200\");\n\n// Overnight point (03:00 Berlin) is clamped to x = 0 (left edge)\n// 2026-07-18T01:00:00.000Z is 03:00 CEST\nassertEqual(timeValue(\"2026-07-18T01:00:00.000Z\"), 0, \"03:00 CEST clamps to 0\");\n\n// Midnight Berlin → clamped to 0\n// 2026-07-17T22:00:00.000Z is 00:00 CEST on 2026-07-18\nassertEqual(timeValue(\"2026-07-17T22:00:00.000Z\"), 0, \"00:00 CEST clamps to 0\");\n\n// 23:30 Berlin (after window) clamps to right edge → 200\n// 2026-07-18T21:30:00.000Z is 23:30 CEST\nassertEqual(timeValue(\"2026-07-18T21:30:00.000Z\"), 200, \"23:30 CEST clamps to 200\");\n\n// 06:59 Berlin (just before window) clamps to left edge → 0\n// 2026-07-18T04:59:00.000Z is 06:59 CEST\nassertEqual(timeValue(\"2026-07-18T04:59:00.000Z\"), 0, \"06:59 CEST clamps to 0\");\n\nconsole.log(\"\\nAll tests passed.\");\n",[],[80,121],"0acb05ac-15fc-40fb-bb52-da67cd752afc","sparkline-alt-text.ts","f82863fe-88d3-11f1-b9d1-1607ee4eb77e",38,["D",1785057940796],"export interface SparklineDataPoint {\n timestamp: string;\n value: number;\n}\n\nconst NOISE_THRESHOLD = 5;\n\nconst timeFormatter = new Intl.DateTimeFormat(\"de-DE\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n timeZone: \"Europe/Berlin\",\n});\n\nfunction formatTime(timestamp: string): string {\n return timeFormatter.format(new Date(timestamp));\n}\n\nfunction round(value: number): number {\n return Math.round(value);\n}\n\nfunction countSlopeInversions(points: SparklineDataPoint[]): number {\n if (points.length < 2) return 0;\n\n let direction: \"up\" | \"down\" | null = null;\n let inversions = 0;\n\n for (let i = 1; i < points.length; i++) {\n const diff = points[i].value - points[i - 1].value;\n if (Math.abs(diff) < NOISE_THRESHOLD) continue;\n\n const newDirection = diff > 0 ? \"up\" : \"down\";\n if (direction !== null && newDirection !== direction) {\n inversions++;\n }\n direction = newDirection;\n }\n\n return inversions;\n}\n\nfunction findExtremum(\n points: SparklineDataPoint[],\n type: \"min\" | \"max\",\n): { value: number; timestamp: string } {\n let extremum = points[0];\n for (let i = 1; i < points.length; i++) {\n if (type === \"min\" ? points[i].value < extremum.value : points[i].value > extremum.value) {\n extremum = points[i];\n }\n }\n return extremum;\n}\n\nexport function sparklineAltText(\n data: SparklineDataPoint[],\n currentValue: number | null,\n unit: string,\n): string {\n if (data.length === 0) {\n return \"No trend data available.\";\n }\n\n const current = currentValue ?? data[data.length - 1].value;\n\n if (data.length === 1) {\n return `Currently at ${round(current)}${unit}.`;\n }\n\n const values = data.map((d) => d.value);\n const min = Math.min(...values);\n const max = Math.max(...values);\n const range = max - min;\n\n if (range < NOISE_THRESHOLD) {\n return `Nearly constant at ${round(current)}${unit}.`;\n }\n\n const k = countSlopeInversions(data);\n const first = data[0].value;\n const last = data[data.length - 1].value;\n\n if (k === 0) {\n if (last > first) {\n return `Steadily increased from ${round(first)}${unit} to ${round(last)}${unit}.`;\n }\n return `Steadily decreased from ${round(first)}${unit} to ${round(last)}${unit}.`;\n }\n\n if (k === 1) {\n const isHill = max !== first && max !== last;\n if (isHill) {\n const peak = findExtremum(data, \"max\");\n return `Rose to a peak of ${round(peak.value)}${unit} at ${formatTime(peak.timestamp)}, now at ${round(current)}${unit}.`;\n }\n const trough = findExtremum(data, \"min\");\n return `Dropped to a low of ${round(trough.value)}${unit} at ${formatTime(trough.timestamp)}, now at ${round(current)}${unit}.`;\n }\n\n return `Fluctuated between ${round(min)}${unit} and ${round(max)}${unit}, currently at ${round(current)}${unit}.`;\n}\n",[],[80,129],"710d2ca1-0341-4cfb-bff1-51d3c04b732e","sparkline-alt-text.test.ts","1a465b6c-88d4-11f1-9dec-1607ee4eb77e",39,["D",1785057998038],"import { sparklineAltText, type SparklineDataPoint } from \"./sparkline-alt-text.ts\";\n\nfunction assertEqual(actual: unknown, expected: unknown, label: string): void {\n const a = JSON.stringify(actual);\n const e = JSON.stringify(expected);\n if (a !== e) {\n throw new Error(`FAIL: ${label}\\n expected: ${e}\\n actual: ${a}`);\n }\n console.log(`PASS: ${label} → ${a}`);\n}\n\nfunction berlinTime(iso: string): string {\n return new Intl.DateTimeFormat(\"de-DE\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n timeZone: \"Europe/Berlin\",\n }).format(new Date(iso));\n}\n\nfunction ts(hour: number): string {\n return `2026-07-18T${String(hour).padStart(2, \"0\")}:00:00.000Z`;\n}\n\n// Edge cases\nassertEqual(sparklineAltText([], null, \"% free\"), \"No trend data available.\", \"empty array\");\nassertEqual(\n sparklineAltText([{ timestamp: ts(10), value: 75 }], 75, \"% free\"),\n \"Currently at 75% free.\",\n \"single point\",\n);\nassertEqual(\n sparklineAltText([{ timestamp: ts(10), value: 75 }], null, \"% free\"),\n \"Currently at 75% free.\",\n \"null currentValue falls back to last point\",\n);\n\n// Flat\nassertEqual(\n sparklineAltText(\n [\n { timestamp: ts(7), value: 100 },\n { timestamp: ts(12), value: 100 },\n { timestamp: ts(18), value: 100 },\n ],\n 100,\n \"% free\",\n ),\n \"Nearly constant at 100% free.\",\n \"flat identical\",\n);\nassertEqual(\n sparklineAltText(\n [\n { timestamp: ts(7), value: 98 },\n { timestamp: ts(12), value: 99 },\n { timestamp: ts(18), value: 97 },\n ],\n 98,\n \"% free\",\n ),\n \"Nearly constant at 98% free.\",\n \"flat below noise threshold\",\n);\n\n// Linear\nassertEqual(\n sparklineAltText(\n [\n { timestamp: ts(7), value: 100 },\n { timestamp: ts(12), value: 80 },\n { timestamp: ts(18), value: 60 },\n ],\n 60,\n \"% free\",\n ),\n \"Steadily decreased from 100% free to 60% free.\",\n \"linear decrease\",\n);\nassertEqual(\n sparklineAltText(\n [\n { timestamp: ts(7), value: 60 },\n { timestamp: ts(12), value: 80 },\n { timestamp: ts(18), value: 100 },\n ],\n 100,\n \"% free\",\n ),\n \"Steadily increased from 60% free to 100% free.\",\n \"linear increase\",\n);\n\n// Hill\n{\n const points: SparklineDataPoint[] = [\n { timestamp: ts(7), value: 50 },\n { timestamp: ts(11), value: 90 },\n { timestamp: ts(15), value: 60 },\n ];\n assertEqual(\n sparklineAltText(points, 60, \"% free\"),\n `Rose to a peak of 90% free at ${berlinTime(ts(11))}, now at 60% free.`,\n \"hill archetype\",\n );\n}\n\n// Dip\n{\n const points: SparklineDataPoint[] = [\n { timestamp: ts(7), value: 100 },\n { timestamp: ts(11), value: 40 },\n { timestamp: ts(15), value: 80 },\n ];\n assertEqual(\n sparklineAltText(points, 80, \"% free\"),\n `Dropped to a low of 40% free at ${berlinTime(ts(11))}, now at 80% free.`,\n \"dip archetype\",\n );\n}\n\n// Wave\nassertEqual(\n sparklineAltText(\n [\n { timestamp: ts(7), value: 100 },\n { timestamp: ts(9), value: 40 },\n { timestamp: ts(11), value: 90 },\n { timestamp: ts(13), value: 30 },\n { timestamp: ts(15), value: 80 },\n ],\n 80,\n \"% free\",\n ),\n \"Fluctuated between 30% free and 100% free, currently at 80% free.\",\n \"wave archetype\",\n);\n\nconsole.log(\"\\nAll tests passed.\");\n",[],[80,137],"10ed35ee-18e7-42d9-84d8-da132c4a8bcf","parse-water-temperatures.ts","d3cc490e-8396-11f1-b1dd-1607ee4eb77e",["D",1784481924665],"import { parse } from \"npm:node-html-parser\";\n\nexport interface WaterTemperatureReading {\n category_id: number;\n measurement_site: string;\n body_of_water: string;\n measured_at: string;\n water_temperature: number;\n}\n\n/**\n * Parse the gkd.bayern.de water temperature HTML table into reading records.\n * Works for both lakes (category_id=0) and rivers (category_id=1) — the table\n * structure is identical on both pages.\n *\n * Table columns: [0]=Measurement site, [1]=Body of water, [2]=County,\n * [3]=Date (DD.MM.YYYY HH:MM), [4]=Water temperature [°C].\n *\n * Rows with \"--\" for date or temperature are skipped (no measurement available).\n * `dateConverter` is injected so this function is pure and testable without\n * timezone dependencies — the cron passes `germanDateToUtcIso`.\n */\nexport function parseWaterTemperatures(\n html: string,\n categoryId: number,\n dateConverter: (s: string) => string,\n): WaterTemperatureReading[] {\n const root = parse(html);\n const rows = root.querySelectorAll(\"#karteTabellen tr:not(:first-child)\");\n const readings: WaterTemperatureReading[] = [];\n for (const row of rows) {\n const cells = row.querySelectorAll(\"td\");\n if (cells.length < 5) continue;\n const measurement_site = cells[0].textContent.trim();\n const body_of_water = cells[1].textContent.trim();\n const dateStr = cells[3].textContent.trim();\n const tempStr = cells[4].textContent.trim();\n if (dateStr === \"--\" || tempStr === \"--\") continue;\n const temp = parseFloat(tempStr.replace(\",\", \".\"));\n if (Number.isNaN(temp)) continue;\n readings.push({\n category_id: categoryId,\n measurement_site,\n body_of_water,\n measured_at: dateConverter(dateStr),\n water_temperature: temp,\n });\n }\n return readings;\n}\n",[],[80,145],"3c2c1bec-f2d1-4bf5-863d-3ec74d445a50","parse-water-temperatures.test.ts","d3cc3dc4-8396-11f1-b1dd-1607ee4eb77e",["D",1784481924665],"import { parseWaterTemperatures, type WaterTemperatureReading } from \"./parse-water-temperatures.ts\";\n\nfunction assertEqual(actual: unknown, expected: unknown, label: string): void {\n const a = JSON.stringify(actual);\n const e = JSON.stringify(expected);\n if (a !== e) {\n throw new Error(`FAIL: ${label}\\n expected: ${e}\\n actual: ${a}`);\n }\n console.log(`PASS: ${label} → ${a}`);\n}\n\n// Minimal HTML matching the gkd.bayern.de table structure:\n// columns = [Measurement site, Body of water, County, Date, Water temperature]\n// One valid row, one row with \"--\" (skipped), one row with missing cells (skipped).\nconst html = `\n\n \n \n \n \n

Measurement site	Body of water	County	Date	Water temperature [°C]
Starnberg	StarnbergerSee	STA	19.07.2026 19:00	22.9
Ammerseeboje	Ammersee	LL	--	--
BadRow

`;\n\n// Mock date converter: returns the input unchanged so assertions are stable.\nconst mockConvert = (s: string) => s;\n\nconst readings = parseWaterTemperatures(html, 0, mockConvert);\n\nassertEqual(readings.length, 1, \"only the valid row is parsed\");\n\nassertEqual(\n readings[0] satisfies WaterTemperatureReading,\n {\n category_id: 0,\n measurement_site: \"Starnberg\",\n body_of_water: \"StarnbergerSee\",\n measured_at: \"19.07.2026 19:00\",\n water_temperature: 22.9,\n },\n \"valid row has correct fields\",\n);\n\n// Verify categoryId flows through for rivers (category_id=1).\nconst riverReadings = parseWaterTemperatures(html, 1, mockConvert);\nassertEqual(riverReadings[0].category_id, 1, \"rivers use category_id=1\");\n\nconsole.log(\"\\nAll tests passed.\");\n",[],[80,152],"41f2d670-1e36-4dee-b8ee-1f0b02714605","german-date.ts","d3cc2e9c-8396-11f1-b1dd-1607ee4eb77e",["D",1784481924665],"/**\n * Parse a German-format date string (\"24.05.2023 20:00\") as Berlin local time\n * and return the corresponding UTC ISO-8601 timestamp.\n *\n * Berlin observes CET (UTC+1) in winter and CEST (UTC+2) in summer. The offset\n * is resolved for the specific date via Intl timezone formatting, so DST\n * boundaries are handled correctly — no fixed UTC offset assumption.\n *\n * Used to convert gkd.bayern.de measurement timestamps (which are Berlin\n * wall-clock) into the UTC `measured_at` column stored in SQLite.\n */\nexport function germanDateToUtcIso(dateStr: string): string {\n const [day, month, year, hour, minute] = dateStr.split(/[.: ]/).map(Number);\n // Treat the components as if they were UTC to get a reference instant.\n const guess = new Date(Date.UTC(year, month - 1, day, hour, minute));\n // Determine Berlin's UTC offset (minutes) at that instant, then shift back.\n const offsetMin = berlinOffsetMinutes(guess);\n return new Date(guess.getTime() - offsetMin * 60000).toISOString();\n}\n\n/**\n * Return Berlin's UTC offset (in minutes) at the given instant. Positive means\n * Berlin is ahead of UTC (CEST = +120, CET = +60).\n *\n * Uses the same Intl trick as api/pools.ts's berlinDayUtcBounds: format the\n * instant as Berlin wall-clock, parse back as if UTC, and diff.\n */\nfunction berlinOffsetMinutes(at: Date): number {\n const s = at.toLocaleString(\"en-US\", {\n timeZone: \"Europe/Berlin\",\n hour12: false,\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n second: \"2-digit\",\n });\n // s like \"07/17/2026, 20:38:04\"\n const [d, t] = s.split(\", \");\n const [mo, da, yr] = d.split(\"/\").map(Number);\n const [h, mi, se] = t.split(\":\").map(Number);\n const asUtc = Date.UTC(yr, mo - 1, da, h, mi, se);\n return Math.round((asUtc - at.getTime()) / 60000);\n}\n",[],[80,159],"eab32498-06b9-4217-b196-00cee9e5ff83","german-date.test.ts","d3cc25d2-8396-11f1-b1dd-1607ee4eb77e",["D",1784481924665],"import { germanDateToUtcIso } from \"./german-date.ts\";\n\nfunction assertEqual(actual: unknown, expected: unknown, label: string): void {\n const a = JSON.stringify(actual);\n const e = JSON.stringify(expected);\n if (a !== e) {\n throw new Error(`FAIL: ${label}\\n expected: ${e}\\n actual: ${a}`);\n }\n console.log(`PASS: ${label} → ${a}`);\n}\n\n// Summer (CEST, UTC+2): 20:00 Berlin → 18:00 UTC\nassertEqual(\n germanDateToUtcIso(\"24.05.2023 20:00\"),\n \"2023-05-24T18:00:00.000Z\",\n \"summer CEST 20:00 Berlin → 18:00 UTC\",\n);\n\n// Winter (CET, UTC+1): 18:00 Berlin → 17:00 UTC\nassertEqual(\n germanDateToUtcIso(\"15.01.2023 18:00\"),\n \"2023-01-15T17:00:00.000Z\",\n \"winter CET 18:00 Berlin → 17:00 UTC\",\n);\n\n// Midnight Berlin → previous day 22:00 UTC (summer)\nassertEqual(\n germanDateToUtcIso(\"19.07.2026 00:00\"),\n \"2026-07-18T22:00:00.000Z\",\n \"midnight CEST → previous day 22:00 UTC\",\n);\n\n// Noon Berlin → 10:00 UTC (summer)\nassertEqual(\n germanDateToUtcIso(\"19.07.2026 12:00\"),\n \"2026-07-19T10:00:00.000Z\",\n \"noon CEST → 10:00 UTC\",\n);\n\n// DST transition spring: 26.03.2023 03:00 (just after spring-forward)\nassertEqual(\n germanDateToUtcIso(\"26.03.2023 03:00\"),\n \"2023-03-26T01:00:00.000Z\",\n \"after spring-forward 03:00 CEST → 01:00 UTC\",\n);\n\nconsole.log(\"\\nAll tests passed.\");\n",[],[80,166],"63212832-fac2-415b-9ff5-cddef63210d0","business-hours.ts","d556390a-820c-11f1-8a02-1607ee4eb77e",["D",1784312705542],"/**\n * Munich / German business-hours guard, ported from v1 cron/german-business-hours.js.\n * Returns true between 07:00 and 23:00 Europe/Berlin time. Used to skip pool\n * occupancy logging overnight when the baths are closed.\n */\nexport function isGermanBusinessHours(now: Date = new Date()): boolean {\n const germanTime = now.toLocaleString(\"en-US\", { timeZone: \"Europe/Berlin\" });\n const hours = new Date(germanTime).getHours();\n return hours >= 7 && hours < 23;\n}\n",[],[80,173],["D",1784311938655],[182],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":183,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_76":184,"_18":185},["D",1784481924665],[],[19,36],"7eb4bc66-14c6-4aa3-a9b9-5469b6fab177","cron","d0f4549d-bbf6-4e80-b297-f7fc8a3e7f9c",16,["D",1784312720344],[193,194,195],[187],{"_34":211,"_13":212,"_37":213,"_39":188,"_41":42,"_43":214,"_45":46,"_47":215,"_17":72,"_50":200,"_52":216,"_54":55,"_56":-5,"_76":217,"_18":218},{"_34":204,"_13":205,"_37":206,"_39":188,"_41":42,"_43":189,"_45":46,"_47":207,"_17":61,"_50":200,"_52":208,"_54":55,"_56":-5,"_76":209,"_18":210},{"_34":196,"_13":197,"_37":198,"_39":188,"_41":42,"_43":44,"_45":46,"_47":199,"_17":61,"_50":200,"_52":201,"_54":55,"_56":-5,"_76":202,"_18":203},"755c2c95-93fd-423d-ada2-9d7f8d33e54b","water-temperatures.ts","d3cc1614-8396-11f1-b1dd-1607ee4eb77e",["D",1784481924665],"interval","import { fetch as stdFetch } from \"https://esm.town/v/std/fetch\";\nimport { migrate, upsertBodiesOfWater, upsertWaterTemperatures } from \"../db/schema.ts\";\nimport { parseWaterTemperatures } from \"../lib/parse-water-temperatures.ts\";\nimport { germanDateToUtcIso } from \"../lib/german-date.ts\";\n\nconst SOURCES = [\n { category_id: 0, url: \"https://www.gkd.bayern.de/en/lakes/watertemperature/tables\" },\n { category_id: 1, url: \"https://www.gkd.bayern.de/en/rivers/watertemperature/tables\" },\n] as const;\n\nasync function fetchHtml(url: string): Promise {\n const res = await stdFetch(url, {\n headers: { accept: \"text/html\", \"user-agent\": \"Mozilla/5.0\" },\n });\n if (!res.ok) throw new Error(`HTTP ${res.status} for ${url}`);\n return await res.text();\n}\n\n/**\n * One cron pass: fetch both lakes and rivers tables from gkd.bayern.de, parse\n * them into readings, register any newly-seen bodies of water in the catalog\n * (slug auto-generated), and upsert the readings. Idempotent — re-scraping the\n * same measurement just refreshes `updated_at`.\n */\nexport async function recordWaterTemperatures(): Promise<{\n lakes: number;\n rivers: number;\n}> {\n await migrate();\n const counts: Record = {};\n for (const source of SOURCES) {\n const html = await fetchHtml(source.url);\n const readings = parseWaterTemperatures(html, source.category_id, germanDateToUtcIso);\n const bodies = readings.map((r) => ({ category_id: r.category_id, name: r.body_of_water }));\n await upsertBodiesOfWater(bodies);\n await upsertWaterTemperatures(readings);\n counts[source.category_id] = readings.length;\n }\n return { lakes: counts[0] ?? 0, rivers: counts[1] ?? 0 };\n}\n\nexport default async function (interval: Interval) {\n const result = await recordWaterTemperatures();\n console.log(\n `Scraped ${result.lakes} lake readings and ${result.rivers} river readings.`,\n );\n}\n",[],[187,197],"6d8aef11-7bc2-48fe-bff3-d7c9f3c1dfa3","pools-capacity.ts","de2a3e3c-820c-11f1-aaf3-1607ee4eb77e",["D",1784312720344],"import { fetch as stdFetch } from \"https://esm.town/v/std/fetch\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { migrate, upsertBathAreas } from \"../db/schema.ts\";\nimport { isGermanBusinessHours } from \"../lib/business-hours.ts\";\n\nconst VISITOR_COUNT_URL = \"https://www.swm.de/.rest/bath/visitorCount\";\n\ninterface SwmArea {\n area_id: number;\n area_name: string;\n customer_amount: number;\n customer_amount_max: number;\n}\ninterface SwmLocation {\n location_id: number;\n location_name: string;\n area_list: SwmArea[];\n}\ninterface SwmResponse {\n return_code: string;\n data: SwmLocation[];\n}\n\n/**\n * Fetch the full SWM bath occupancy feed. A single request (no query params)\n * returns every location with its nested areas and live counts.\n */\nasync function fetchVisitorCounts(): Promise {\n const res = await stdFetch(VISITOR_COUNT_URL, {\n headers: { accept: \"*/*\", \"user-agent\": \"Mozilla/5.0\" },\n });\n if (!res.ok) throw new Error(`SWM visitorCount HTTP ${res.status}`);\n const json = (await res.json()) as SwmResponse;\n if (json.return_code !== \"success\" || !Array.isArray(json.data)) {\n throw new Error(`SWM visitorCount unexpected response: ${JSON.stringify(json).slice(0, 200)}`);\n }\n return json.data;\n}\n\n/**\n * One cron pass: fetch the feed, sync the area roster, and log area-level\n * occupancy. Skips logging outside Munich business hours (baths closed), but\n * still refreshes the roster so new areas are discovered even overnight.\n */\nexport async function recordOccupancy(now: Date = new Date()): Promise<{\n skipped: boolean;\n areas: number;\n rows: number;\n}> {\n await migrate();\n\n const locations = await fetchVisitorCounts();\n\n // Flatten locations -> areas, carrying the parent location metadata.\n const flat = locations.flatMap((loc) =>\n loc.area_list.map((a) => ({\n area_id: a.area_id,\n area_name: a.area_name,\n location_id: loc.location_id,\n location_name: loc.location_name,\n customer_amount: a.customer_amount,\n customer_amount_max: a.customer_amount_max,\n }))\n );\n\n // Keep the roster fresh regardless of the hour.\n await upsertBathAreas(flat);\n\n if (!isGermanBusinessHours(now)) {\n return { skipped: true, areas: flat.length, rows: 0 };\n }\n\n const recorded_at = now.toISOString();\n await sqlite.batch(\n flat.map((a) => ({\n sql: `INSERT INTO occupancy_log (area_id, customer_amount, customer_amount_max, recorded_at)\n VALUES (?, ?, ?, ?)`,\n args: [a.area_id, a.customer_amount, a.customer_amount_max, recorded_at],\n })),\n );\n\n return { skipped: false, areas: flat.length, rows: flat.length };\n}\n\nexport default async function (interval: Interval) {\n const result = await recordOccupancy();\n console.log(\n result.skipped\n ? `Outside business hours — refreshed ${result.areas} areas, logged 0 rows.`\n : `Logged ${result.rows} occupancy rows across ${result.areas} areas.`,\n );\n}\n",[],[187,205],"1c4f882b-7bd1-41a6-a7b8-c77844d91d66","feringasee.ts","bc7812fe-83a2-11f1-a9b7-1607ee4eb77e",32,["D",1784487378812],"import { fetch as stdFetch } from \"https://esm.town/v/std/fetch\";\nimport {\n migrate,\n upsertBodiesOfWater,\n upsertWaterTemperatures,\n} from \"../db/schema.ts\";\nimport { germanDateToUtcIso } from \"../lib/german-date.ts\";\n\nconst URL = \"https://xn--wasserwacht-unterfhring-plc.de/aktuelles-wetter/\";\n\n// \"vom 19.07.2026 20:10: 25.80 Grad Celius im Wasser und 24.40 Grad Celsius an der Luft.\"\n// \"Celius\" (sic) is a typo in the source's water-temperature wording — preserved verbatim.\nconst READING_REGEX =\n /vom (\\d{2}\\.\\d{2}\\.\\d{4}\\s\\d{2}:\\d{2}):\\s([\\d.]+) Grad Celius im Wasser und ([\\d.]+) Grad Celsius an der Luft\\./;\n\nasync function fetchHtml(url: string): Promise {\n const res = await stdFetch(url, {\n headers: { accept: \"text/html\", \"user-agent\": \"Mozilla/5.0\" },\n });\n if (!res.ok) throw new Error(`HTTP ${res.status} for ${url}`);\n return await res.text();\n}\n\n/**\n * One cron pass: fetch the Wasserwacht Unterföhring Feringasee weather page,\n * extract the latest water+air temperature reading, register Feringasee in the\n * bodies-of-water catalog if new, and upsert the reading. Idempotent —\n * re-scraping the same measurement just refreshes `updated_at`.\n *\n * Returns null when no reading is found on the page (sensors down, page\n * restructured, etc.), otherwise the parsed reading.\n */\nexport async function recordFeringasee(): Promise<{\n water_temperature: number;\n air_temperature: number;\n measured_at: string;\n} | null> {\n await migrate();\n const html = await fetchHtml(URL);\n // The page wraps the temperature values in tags (e.g. \"25.80 Grad\n // Celius\"). Strip all tags so the regex sees plain text, matching the\n // original v1 scraper's use of node-html-parser's .textContent.\n const text = html.replace(/<[^>]+>/g, \"\");\n const match = text.match(READING_REGEX);\n if (!match) return null;\n\n const measured_at = germanDateToUtcIso(match[1]);\n const water_temperature = parseFloat(match[2]);\n const air_temperature = parseFloat(match[3]);\n\n await upsertBodiesOfWater([{ category_id: 0, name: \"Feringasee\" }]);\n await upsertWaterTemperatures([\n {\n category_id: 0,\n measurement_site: \"Feringasee\",\n body_of_water: \"Feringasee\",\n measured_at,\n water_temperature,\n },\n ]);\n\n return { water_temperature, air_temperature, measured_at };\n}\n\nexport default async function (interval: Interval) {\n const result = await recordFeringasee();\n if (!result) {\n console.log(\"No Feringasee reading found on the page.\");\n return;\n }\n console.log(\n `Feringasee: ${result.water_temperature}°C water, ${result.air_temperature}°C air at ${result.measured_at}.`,\n );\n}\n",[],[187,212],"5ed2bc11-5bb2-4e1a-9f83-852a4c175573","api","5dee9817-c87b-4937-82db-c075261bbdf5",20,["D",1784313509669],[226,227],[220],{"_34":237,"_13":238,"_37":239,"_39":221,"_41":42,"_43":240,"_45":46,"_47":241,"_17":242,"_50":74,"_52":243,"_54":55,"_56":244,"_76":245,"_18":246},{"_34":228,"_13":197,"_37":229,"_39":221,"_41":42,"_43":230,"_45":46,"_47":231,"_17":232,"_50":74,"_52":233,"_54":55,"_56":234,"_76":235,"_18":236},"c44215fc-edd8-4463-badf-bede58c65dcf","d3cbe34c-8396-11f1-b1dd-1607ee4eb77e",49,["D",1785062610268],14,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { line, curveNatural } from \"https://esm.sh/d3-shape@3\";\nimport { weekTimeValue } from \"../lib/week-time-value.ts\";\nimport { sparklineAltText } from \"../lib/sparkline-alt-text.ts\";\nimport { slugify } from \"../db/schema.ts\";\n\n/**\n * GET /?category=lakes|rivers\n *\n * Returns the latest water-temperature reading per body of water / measurement\n * site pair within the requested category, plus a 7-day time series and a\n * precomputed d3 SVG path (y = temperature mapped to 0–35 °C range). `category` defaults to \"lakes\".\n *\n * The SVG viewBox is 0 0 200 110 (matching AreaCard.svelte). X-axis: 7-day\n * window → [0, 200]. Y-axis: 0 °C → y=100, 35 °C → y=0.\n *\n * Public + CORS-friendly. Cached for 10 minutes.\n */\n\ninterface Row {\n body_of_water: string;\n slug: string;\n measurement_site: string;\n water_temperature: number;\n measured_at: string;\n}\n\ninterface WaterDataPoint {\n measured_at: string;\n water_temperature: number;\n}\n\ninterface WaterBody {\n body_of_water: string;\n slug: string;\n measurement_site: string;\n water_temperature: number;\n measured_at: string;\n path: string;\n trend_text: string;\n}\n\nconst CATEGORIES: Record = { lakes: 0, rivers: 1 };\n\nconst MAX_TEMP = 35;\nconst WEEK_MS = 7 * 24 * 60 * 60 * 1000;\n\nfunction tempToY(temp: number): number {\n return 100 - (temp / MAX_TEMP) * 100;\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const categoryParam = url.searchParams.get(\"category\") ?? \"lakes\";\n const categoryId = CATEGORIES[categoryParam];\n if (categoryId === undefined) {\n return Response.json(\n { error: `Invalid category '${categoryParam}'. Use 'lakes' or 'rivers'.` },\n { status: 400 },\n );\n }\n\n const now = new Date();\n const weekAgo = new Date(now.getTime() - WEEK_MS).toISOString();\n\n const { rows } = (await sqlite.execute({\n sql: `\n SELECT w.body_of_water, b.slug, w.measurement_site, w.water_temperature, w.measured_at\n FROM water_temperatures w\n JOIN bodies_of_water b\n ON b.category_id = w.category_id AND b.name = w.body_of_water\n WHERE w.category_id = ?\n AND w.measured_at >= ?\n ORDER BY w.body_of_water ASC, w.measurement_site ASC, w.measured_at ASC\n `,\n args: [categoryId, weekAgo],\n })) as unknown as { rows: Row[] };\n\n // Group rows by body_of_water + measurement_site, preserving ASC time order for path generation.\n const bodyMap = new Map();\n for (const r of rows) {\n const key = `${r.body_of_water}\\u0000${r.measurement_site}`;\n let body = bodyMap.get(key);\n if (!body) {\n body = { row: r, data: [] };\n bodyMap.set(key, body);\n }\n body.data.push({\n measured_at: r.measured_at,\n water_temperature: r.water_temperature,\n });\n // Keep the latest reading as the \"current\" reading.\n body.row = r;\n }\n\n const pathGen = line<[number, number]>()\n .x((d) => d[0])\n .y((d) => d[1])\n .curve(curveNatural);\n\n const bodies: WaterBody[] = [...bodyMap.values()].map(({ row, data }) => {\n const points: [number, number][] = data.map((d) => [\n weekTimeValue(d.measured_at, now),\n tempToY(d.water_temperature),\n ]);\n return {\n body_of_water: row.body_of_water,\n slug: `${row.slug}-${slugify(row.measurement_site)}`,\n measurement_site: row.measurement_site,\n water_temperature: row.water_temperature,\n measured_at: row.measured_at,\n path: pathGen(points) ?? \"\",\n trend_text: sparklineAltText(\n data.map((d) => ({ timestamp: d.measured_at, value: d.water_temperature })),\n row.water_temperature,\n \"°\",\n ),\n };\n });\n\n return Response.json(\n { category: categoryParam, bodies },\n { headers: { \"Cache-Control\": \"public, max-age=600\" } },\n );\n}\n","muenchen-plantscht-water",[],[220,197],"72f25944-6d05-4c97-b13a-e3d32598547b","pools.ts","b4a36988-820e-11f1-b7fc-1607ee4eb77e",44,["D",1785058040952],6,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { line, curveNatural } from \"https://esm.sh/d3-shape@3\";\nimport { timeValue } from \"../lib/time-value.ts\";\nimport { sparklineAltText } from \"../lib/sparkline-alt-text.ts\";\n\n/**\n * GET /?date=YYYY-MM-DD (date optional, defaults to today in Europe/Berlin)\n *\n * Returns pool occupancy for a single day, grouped location -> areas. Each area\n * carries its intraday series, a `latest` snapshot, and a precomputed d3 SVG\n * path (y = % free) so a dumb client/widget can render it directly.\n *\n * Public + CORS-friendly (Val Town adds Access-Control-Allow-Origin: * by\n * default as long as we don't set CORS headers ourselves).\n */\n\ninterface Row {\n area_id: number;\n area_name: string;\n location_id: number;\n location_name: string;\n customer_amount: number;\n customer_amount_max: number;\n recorded_at: string;\n}\n\n/** % free, v1's metric: 100 - occupancy%. Clamped to [0,100]. */\nfunction capacityFreePct(count: number, max: number): number {\n if (!max || max <= 0) return 0;\n const pct = 100 - Math.round((count / max) * 100);\n return Math.max(0, Math.min(100, pct));\n}\n\n/** Today's date (YYYY-MM-DD) in Europe/Berlin. */\nfunction todayBerlin(): string {\n // en-CA gives YYYY-MM-DD\n return new Date().toLocaleDateString(\"en-CA\", { timeZone: \"Europe/Berlin\" });\n}\n\nfunction isValidDate(s: string): boolean {\n return /^\\d{4}-\\d{2}-\\d{2}$/.test(s);\n}\n\n/**\n * Given a Berlin calendar day (YYYY-MM-DD), return the UTC instant bounds\n * [startUtc, endUtc) that cover it. DST-correct: derives Berlin's offset for\n * that specific date instead of assuming a fixed +1/+2.\n */\nfunction berlinDayUtcBounds(date: string): { start: string; end: string } {\n // Offset (minutes) that Berlin is ahead of UTC at a given instant.\n const berlinOffsetMinutes = (at: Date): number => {\n // Format the same instant as Berlin wall-clock, parse back as if UTC,\n // and diff — yields the zone offset for that instant (handles DST).\n const s = at.toLocaleString(\"en-US\", {\n timeZone: \"Europe/Berlin\",\n hour12: false,\n year: \"numeric\",\n month: \"2-digit\",\n day: \"2-digit\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n second: \"2-digit\",\n });\n // s like \"07/17/2026, 20:38:04\"\n const [d, t] = s.split(\", \");\n const [mo, da, yr] = d.split(\"/\").map(Number);\n const [h, mi, se] = t.split(\":\").map(Number);\n const asUtc = Date.UTC(yr, mo - 1, da, h, mi, se);\n return Math.round((asUtc - at.getTime()) / 60000);\n };\n\n // Berlin local midnight of `date`, expressed as a first-guess UTC instant,\n // then corrected by that instant's actual offset.\n const [y, m, d] = date.split(\"-\").map(Number);\n const guess = Date.UTC(y, m - 1, d, 0, 0, 0);\n const offset = berlinOffsetMinutes(new Date(guess));\n const startUtc = guess - offset * 60000;\n const endUtc = startUtc + 24 * 60 * 60 * 1000;\n return { start: new Date(startUtc).toISOString(), end: new Date(endUtc).toISOString() };\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const dateParam = url.searchParams.get(\"date\");\n const date = dateParam && isValidDate(dateParam) ? dateParam : todayBerlin();\n\n // Select the day's rows for active areas. `recorded_at` is stored UTC; the\n // \"day\" is a Berlin calendar day, so filter by that day's UTC bounds\n // (DST-correct, no fixed offset).\n const { start, end } = berlinDayUtcBounds(date);\n const { rows } = (await sqlite.execute({\n sql: `\n SELECT o.area_id, b.area_name, b.location_id, b.location_name,\n o.customer_amount, o.customer_amount_max, o.recorded_at\n FROM occupancy_log o\n JOIN bath_areas b ON b.area_id = o.area_id\n WHERE b.active = 1\n AND o.recorded_at >= ?\n AND o.recorded_at < ?\n ORDER BY b.location_name, b.area_name, o.recorded_at ASC\n `,\n args: [start, end],\n })) as unknown as { rows: Row[] };\n\n // Group location -> area -> series.\n const locMap = new Map;\n }>();\n\n for (const r of rows) {\n let loc = locMap.get(r.location_id);\n if (!loc) {\n loc = { location_id: r.location_id, location_name: r.location_name, areas: new Map() };\n locMap.set(r.location_id, loc);\n }\n let area = loc.areas.get(r.area_id);\n if (!area) {\n area = { area_id: r.area_id, area_name: r.area_name, data: [] };\n loc.areas.set(r.area_id, area);\n }\n area.data.push({\n recorded_at: r.recorded_at,\n customer_amount: r.customer_amount,\n customer_amount_max: r.customer_amount_max,\n capacity_free_pct: capacityFreePct(r.customer_amount, r.customer_amount_max),\n });\n }\n\n const pathGen = line<[number, number]>()\n .x((d) => d[0])\n .y((d) => d[1])\n .curve(curveNatural);\n\n const locations = [...locMap.values()]\n .map((loc) => ({\n location_id: loc.location_id,\n location_name: loc.location_name,\n areas: [...loc.areas.values()].map((a) => {\n const points: [number, number][] = a.data.map((d) => [\n timeValue(d.recorded_at),\n d.capacity_free_pct,\n ]);\n const last = a.data[a.data.length - 1];\n return {\n area_id: a.area_id,\n area_name: a.area_name,\n latest: last\n ? {\n recorded_at: last.recorded_at,\n customer_amount: last.customer_amount,\n customer_amount_max: last.customer_amount_max,\n capacity_free_pct: last.capacity_free_pct,\n }\n : null,\n trend_text: sparklineAltText(\n a.data.map((d) => ({ timestamp: d.recorded_at, value: d.capacity_free_pct })),\n last?.capacity_free_pct ?? null,\n \"% free\",\n ),\n path: pathGen(points) ?? \"\",\n };\n }),\n }))\n .sort((a, b) => a.location_name.localeCompare(b.location_name, \"de\"));\n\n return Response.json(\n { date, locations },\n { headers: { \"Cache-Control\": \"public, max-age=600\" } },\n );\n}\n","muenchen-plantscht-pools",[],[220,238],"d8bfb0f0-1676-42ac-a1a4-4ef765725e9b",["D",1784311508215],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Munich water temps & pool capacity: backend, DB, crons","imageUrl","userId","a57118a1-fd01-4461-99a5-f9521a5efd88","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","ec9fe592-5d96-4ef4-9e64-c821b2a08c4a","tursoName","d8bfb0f0167642aca1a44ef765725e9b","tursoHostname","d8bfb0f0167642aca1a44ef765725e9b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789559472742],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_303":299},"org",{"_11":12,"_297":-5,"_298":299,"_257":258,"_300":301,"_302":55},"branch",{"_17":230,"_13":16,"_34":42,"_289":247,"_290":-5,"_291":-5,"_292":-5,"_293":-5,"_294":-5,"_295":14,"_296":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJrNmY5SkJXSVo3QmpSejQxUmJiOFNKSlRuQiJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":247,"_13":14,"_47":401,"_249":-5,"_250":55,"_251":252,"_253":252,"_254":255,"_256":-5,"_257":258,"_259":71,"_260":46,"_261":-5,"_262":-5,"_263":61,"_264":265,"_266":267,"_268":269,"_270":402,"_272":-5,"_273":274,"_275":274,"_276":277,"_278":277,"_279":277,"_280":274,"_281":274,"_282":403,"_284":404,"_286":405,"_288":55},[335,338,342,344,356],"files",[335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356],"counts",{"_326":61,"_327":72,"_328":61,"_32":329,"_330":331},[324],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":60,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_18":323},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":325},[19,36],"pulls","branches","forks",{"_332":61,"_334":61},"connections",{"_332":61,"_333":61},"count","unfilledCount","emptyCount",{"_34":219,"_13":220,"_37":221,"_39":-5,"_41":42,"_43":222,"_45":46,"_47":223,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_76":399,"_18":400},{"_34":237,"_13":238,"_37":239,"_39":221,"_41":42,"_43":240,"_45":46,"_47":241,"_17":242,"_50":74,"_52":243,"_54":55,"_56":244,"_76":397,"_18":398},{"_34":228,"_13":197,"_37":229,"_39":221,"_41":42,"_43":230,"_45":46,"_47":231,"_17":232,"_50":74,"_52":233,"_54":55,"_56":234,"_76":395,"_18":396},{"_34":186,"_13":187,"_37":188,"_39":-5,"_41":42,"_43":189,"_45":46,"_47":190,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_76":393,"_18":394},{"_34":211,"_13":212,"_37":213,"_39":188,"_41":42,"_43":214,"_45":46,"_47":215,"_17":72,"_50":200,"_52":216,"_54":55,"_56":-5,"_76":391,"_18":392},{"_34":204,"_13":205,"_37":206,"_39":188,"_41":42,"_43":189,"_45":46,"_47":207,"_17":61,"_50":200,"_52":208,"_54":55,"_56":-5,"_76":389,"_18":390},{"_34":196,"_13":197,"_37":198,"_39":188,"_41":42,"_43":44,"_45":46,"_47":199,"_17":61,"_50":200,"_52":201,"_54":55,"_56":-5,"_76":387,"_18":388},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":59,"_45":46,"_47":179,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_76":385,"_18":386},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":183,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_76":383,"_18":384},{"_34":79,"_13":80,"_37":81,"_39":-5,"_41":42,"_43":82,"_45":46,"_47":83,"_17":61,"_50":62,"_52":-5,"_54":55,"_56":-5,"_76":381,"_18":382},{"_34":172,"_13":173,"_37":174,"_39":81,"_41":42,"_43":82,"_45":46,"_47":175,"_17":61,"_50":51,"_52":176,"_54":55,"_56":-5,"_76":379,"_18":380},{"_34":165,"_13":166,"_37":167,"_39":81,"_41":42,"_43":44,"_45":46,"_47":168,"_17":61,"_50":51,"_52":169,"_54":55,"_56":-5,"_76":377,"_18":378},{"_34":158,"_13":159,"_37":160,"_39":81,"_41":42,"_43":44,"_45":46,"_47":161,"_17":61,"_50":51,"_52":162,"_54":55,"_56":-5,"_76":375,"_18":376},{"_34":151,"_13":152,"_37":153,"_39":81,"_41":42,"_43":44,"_45":46,"_47":154,"_17":61,"_50":51,"_52":155,"_54":55,"_56":-5,"_76":373,"_18":374},{"_34":144,"_13":145,"_37":146,"_39":81,"_41":42,"_43":44,"_45":46,"_47":147,"_17":61,"_50":51,"_52":148,"_54":55,"_56":-5,"_76":371,"_18":372},{"_34":136,"_13":137,"_37":138,"_39":81,"_41":42,"_43":139,"_45":46,"_47":140,"_17":61,"_50":51,"_52":141,"_54":55,"_56":-5,"_76":369,"_18":370},{"_34":128,"_13":129,"_37":130,"_39":81,"_41":42,"_43":131,"_45":46,"_47":132,"_17":61,"_50":51,"_52":133,"_54":55,"_56":-5,"_76":367,"_18":368},{"_34":120,"_13":121,"_37":122,"_39":81,"_41":42,"_43":123,"_45":46,"_47":124,"_17":59,"_50":51,"_52":125,"_54":55,"_56":-5,"_76":365,"_18":366},{"_34":112,"_13":113,"_37":114,"_39":81,"_41":42,"_43":115,"_45":46,"_47":116,"_17":61,"_50":51,"_52":117,"_54":55,"_56":-5,"_76":363,"_18":364},{"_34":105,"_13":106,"_37":107,"_39":81,"_41":42,"_43":100,"_45":46,"_47":108,"_17":61,"_50":51,"_52":109,"_54":55,"_56":-5,"_76":361,"_18":362},{"_34":97,"_13":98,"_37":99,"_39":81,"_41":42,"_43":100,"_45":46,"_47":101,"_17":61,"_50":51,"_52":102,"_54":55,"_56":-5,"_76":359,"_18":360},{"_34":69,"_13":70,"_37":71,"_39":-5,"_41":42,"_43":72,"_45":46,"_47":73,"_17":61,"_50":74,"_52":75,"_54":55,"_56":-5,"_76":357,"_18":358},[],[70],[],[80,98],[],[80,106],[],[80,113],[],[80,121],[],[80,129],[],[80,137],[],[80,145],[],[80,152],[],[80,159],[],[80,166],[],[80,173],[345,346,347,348,349,350,351,352,353,354,355],[80],[],[19,36],[343],[19],[],[187,197],[],[187,205],[],[187,212],[339,340,341],[187],[],[220,197],[],[220,238],[336,337],[220],["D",1784311508215],["D",1789559472742],{"_11":12,"_303":299},{"_11":12,"_297":-5,"_298":299,"_257":258,"_300":301,"_302":55},{"_17":230,"_13":16,"_34":42,"_289":247,"_290":-5,"_291":-5,"_292":-5,"_293":-5,"_294":-5,"_295":14,"_296":12},"ctx",{"_282":-5,"_320":439,"_440":441,"_442":443,"_444":55,"_445":55,"_446":55,"_447":46,"_448":-5,"_449":-7,"_450":-7,"_451":61,"_452":55,"_453":55,"_454":-5,"_455":55,"_456":55,"_457":55,"_458":-5},"ENV",{"_410":411,"_412":413,"_414":16,"_415":416,"_417":418,"_419":420,"_421":422,"_423":424,"_425":426,"_427":428,"_429":430,"_431":432,"_433":434,"_435":436,"_437":438},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]