Rattamaraton Live

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_156":157,"_158":159},"routes/_app.x.$handle.$name",{"_99":98,"_33":46,"_107":89,"_28":37,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":27,"_121":122,"_123":27,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":37,"_54":-5,"_18":55,"_56":57,"_58":25,"_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":27},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","main.ts","latestPath","fileId","f87da9ac-aa18-11f1-868b-1607ee4eb77e","name","fileType","script","content","","/**\n * Rattamaraton Live Tracker — Val Town HTTP val\n * =============================================\n *\n * One-file live GPS tracker: GPSLogger on Android sends points here via GET,\n * one viewer follows them on a Leaflet map. See rattamaraton-tracker-plan.md.\n *\n * SETUP\n * -----\n * 1. Create a new HTTP val on val.town and paste this entire file into it.\n * 2. In Val Town: Settings → Environment variables → add\n * WRITE_TOKEN = \n * 3. Pick a trip slug: human prefix + random chars, e.g. rattamaraton-a7f3k2x9qm\n * (lowercase letters, digits, dashes only). The slug IS the read capability —\n * only share the viewer link with your wife.\n * 4. Viewer link: https:///t/\n *\n * GPSLOGGER (F-Droid) CONFIGURATION — one profile per trip, profile name = trip name\n * ----------------------------------------------------------------------------------\n * Logging details → Log to custom URL → URL:\n *\n * https:///log/?key=&lat=%LAT&lon=%LON&ts=%TIME&acc=%ACC&spd=%SPD&batt=%BATT\n *\n * - HTTP Method: GET\n * - Logging interval: 60 seconds\n * - Also enable \"Log to GPX\" as a local backup\n * - Android Settings → Battery → GPSLogger → Unrestricted (battery optimisation\n * exemption). Verify with a 4-hour stationary test before the ride.\n *\n * %TIME is ISO 8601 UTC and is parsed server-side; %SPD is m/s (converted to\n * km/h on the map page); %BATT is battery percent.\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { createHash, timingSafeEqual } from \"node:crypto\";\n\n// Official Tartu Rattamaraton 123 km route, simplified to ~480 points\n// (\"lat,lon lat,lon ...\"), drawn as the grey course line on the map.\nconst ROUTE_POINTS =\n \"58.05000,26.50345 58.04882,26.50502 58.04822,26.50964 58.04635,26.51256 58.04612,26.50901 58.04561,26.50667 58.04401,26.50739 58.04001,26.50592 58.04069,26.50220 58.04043,26.49984 58.04055,26.49701 58.03980,26.49466 58.03759,26.49001 58.03589,26.49004 58.03457,26.48746 58.03329,26.48618 58.03277,26.48423 58.03224,26.47983 58.03020,26.47514 58.02896,26.47403 58.02694,26.47347 58.02471,26.47167 58.02151,26.46784 58.01944,26.46641 58.01759,26.46428 58.01709,26.46017 58.01770,26.45404 58.01722,26.45278 58.01550,26.45465 58.01510,26.45634 58.01398,26.45558 58.01293,26.45312 58.01011,26.45254 58.00928,26.45346 58.00856,26.45516 58.00769,26.45238 58.00692,26.45213 58.00643,26.45117 58.00673,26.44971 58.00656,26.44929 58.00577,26.44800 58.00385,26.44683 57.99989,26.45110 57.99778,26.45064 57.99270,26.45513 57.99204,26.46159 57.98987,26.46615 57.98359,26.46738 57.98115,26.46931 57.97919,26.47460 57.97641,26.47708 57.97553,26.47906 57.97342,26.47826 57.96997,26.48110 57.96844,26.48084 57.96789,26.48216 57.96593,26.48145 57.96530,26.48290 57.96218,26.48003 57.96048,26.48017 57.95980,26.47622 57.95748,26.47738 57.95675,26.47687 57.95438,26.46883 57.95170,26.46441 57.95192,26.46022 57.94988,26.45741 57.94470,26.46208 57.94423,26.46874 57.94378,26.47060 57.94112,26.47637 57.94069,26.47583 57.93999,26.47638 57.93825,26.47828 57.93762,26.47984 57.93486,26.48229 57.93494,26.48629 57.93573,26.48648 57.93902,26.49105 57.93943,26.49292 57.94289,26.49922 57.94375,26.50382 57.94460,26.50644 57.94492,26.50667 57.94530,26.50609 57.94627,26.50661 57.94663,26.50952 57.94652,26.51199 57.94744,26.51675 57.94570,26.52047 57.94533,26.52397 57.94659,26.53074 57.94767,26.53212 57.94779,26.53444 57.94857,26.53808 57.94836,26.54045 57.94943,26.54127 57.95271,26.54045 57.95517,26.54208 57.95738,26.54575 57.95854,26.54870 57.96090,26.55106 57.96171,26.54912 57.96365,26.54645 57.96651,26.54646 57.96885,26.54765 57.97083,26.54759 57.97240,26.54885 57.97296,26.55181 57.97437,26.55496 57.97656,26.55526 57.97905,26.55722 57.97751,26.55899 57.97544,26.56022 57.97202,26.56954 57.97073,26.57162 57.97006,26.57216 57.96935,26.56962 57.96795,26.57042 57.96408,26.57320 57.96285,26.57561 57.96004,26.57725 57.95878,26.57917 57.95678,26.58054 57.95434,26.58689 57.95397,26.59442 57.95731,26.59446 57.95784,26.59383 57.95924,26.59478 57.96017,26.59451 57.96110,26.59260 57.96274,26.59103 57.96452,26.58717 57.96778,26.58428 57.97030,26.58382 57.97458,26.58488 57.97543,26.58448 57.97812,26.57870 57.97950,26.57762 57.98032,26.57614 57.98240,26.57094 57.98326,26.56735 57.98420,26.56559 57.98375,26.56418 57.98691,26.56116 57.98869,26.55776 57.98966,26.55382 57.99079,26.55099 57.99180,26.54980 57.99204,26.54872 57.99157,26.54566 57.99291,26.54249 57.99444,26.53695 57.99373,26.53386 57.99406,26.53164 57.99300,26.52947 57.99175,26.52831 57.99095,26.52568 57.98950,26.52257 57.98821,26.52186 57.98719,26.51565 57.98613,26.51552 57.98537,26.51617 57.98343,26.52021 57.98262,26.52501 57.98162,26.52585 57.97952,26.52164 57.97849,26.52038 57.97733,26.51756 57.97314,26.51303 57.97222,26.51079 57.97032,26.50904 57.96950,26.50721 57.96661,26.50562 57.96763,26.50394 57.97114,26.50025 57.97082,26.49547 57.97362,26.48843 57.97581,26.48754 57.97823,26.48408 57.98037,26.48340 57.98283,26.47973 57.98622,26.47810 57.98675,26.47596 57.98888,26.47204 57.98902,26.47004 57.99028,26.46571 57.99193,26.46200 57.99270,26.45513 57.99778,26.45064 57.99989,26.45110 58.00334,26.44739 58.00109,26.44703 57.99945,26.44588 57.99807,26.44608 57.99687,26.44505 57.99396,26.44661 57.99377,26.44389 57.99459,26.44257 57.99476,26.44151 57.99365,26.44072 57.99250,26.44238 57.99147,26.44212 57.99016,26.43818 57.99170,26.43092 57.99286,26.42902 57.99365,26.42416 57.99474,26.42013 57.99252,26.41559 57.99223,26.41170 57.99259,26.41009 57.99255,26.40516 57.99157,26.39845 57.99167,26.39335 57.99124,26.39037 57.99121,26.38598 57.99380,26.38005 57.99496,26.37875 57.99279,26.37325 57.99160,26.37251 57.98862,26.36792 57.98815,26.36521 57.98900,26.36285 57.98989,26.35788 57.98866,26.35216 57.98715,26.34976 57.98620,26.34515 57.98524,26.34487 57.98344,26.34132 57.98311,26.34130 57.98261,26.34247 57.98194,26.34718 57.98471,26.35236 57.98415,26.35371 57.98412,26.35534 57.98369,26.35700 57.98341,26.35727 57.98223,26.35575 57.98065,26.35567 57.97982,26.35372 57.97693,26.35367 57.97605,26.35218 57.97436,26.35183 57.97345,26.35092 57.97244,26.34832 57.96356,26.34159 57.96055,26.33736 57.96154,26.33302 57.96290,26.33049 57.96704,26.32761 57.96842,26.32484 57.96941,26.32374 57.97283,26.32318 57.97460,26.32200 57.97653,26.31960 57.97768,26.31736 57.97875,26.31636 57.97892,26.31500 57.97859,26.30990 57.97771,26.30779 57.97612,26.30665 57.97570,26.30710 57.97556,26.30929 57.97484,26.31009 57.97387,26.31040 57.97268,26.30910 57.97139,26.30878 57.97017,26.30999 57.96850,26.30777 57.96574,26.30519 57.96465,26.30263 57.96403,26.30239 57.96274,26.30409 57.96151,26.30416 57.96082,26.29833 57.96021,26.28724 57.95958,26.28547 57.96183,26.28308 57.96375,26.28759 57.96728,26.28783 57.97032,26.28994 57.97115,26.28896 57.97478,26.29192 57.97536,26.29365 57.97864,26.29359 57.97953,26.29404 57.98139,26.29243 57.98321,26.28656 57.98349,26.28235 57.98416,26.27889 57.98364,26.27400 57.98552,26.26851 57.98854,26.27351 57.98874,26.27722 57.98829,26.28265 57.98849,26.28484 57.98944,26.28647 57.99166,26.28681 57.99207,26.28939 57.99480,26.29051 57.99622,26.29245 57.99904,26.28893 58.00049,26.28252 58.00242,26.27954 58.00300,26.28074 58.00378,26.28031 58.00742,26.28189 58.01105,26.28059 58.01176,26.27944 58.01336,26.27446 58.01639,26.27071 58.01799,26.26984 58.02012,26.26952 58.02164,26.26656 58.02338,26.26577 58.02467,26.26807 58.02663,26.27006 58.02945,26.27089 58.03169,26.26796 58.03341,26.26710 58.03377,26.26573 58.03374,26.26312 58.03400,26.26222 58.03688,26.26097 58.03830,26.25828 58.04289,26.25483 58.04451,26.25451 58.04597,26.25521 58.05100,26.25431 58.05258,26.25473 58.04916,26.26384 58.04754,26.27214 58.04695,26.27961 58.04465,26.28293 58.04373,26.28516 58.03968,26.28918 58.03399,26.29143 58.03401,26.29258 58.03597,26.29927 58.03974,26.31624 58.04063,26.31772 58.04439,26.32162 58.04480,26.32304 58.04462,26.32432 58.04861,26.32666 58.05069,26.32674 58.05264,26.32399 58.05357,26.32388 58.05480,26.32482 58.05811,26.32092 58.06177,26.32470 58.06442,26.32651 58.06501,26.32786 58.06541,26.33361 58.06732,26.34083 58.06919,26.34297 58.07132,26.34397 58.07159,26.34767 58.07287,26.34897 58.07333,26.35069 58.07409,26.35162 58.07390,26.35406 58.07419,26.35608 58.07253,26.35636 58.07167,26.35757 58.07098,26.35772 58.06823,26.36192 58.06697,26.36762 58.06297,26.37586 58.06156,26.37957 58.06165,26.38186 58.06521,26.38437 58.06553,26.38860 58.06482,26.39203 58.06476,26.39546 58.06540,26.39846 58.06443,26.40108 58.06581,26.40778 58.06675,26.41085 58.06772,26.41802 58.06842,26.41715 58.07000,26.41667 58.07410,26.41733 58.07593,26.41603 58.07728,26.41400 58.07816,26.41381 58.07925,26.41454 58.07955,26.41346 58.07899,26.41224 58.07901,26.40988 58.07845,26.40681 58.07857,26.40081 58.08033,26.39674 58.08111,26.39361 58.08233,26.39072 58.08351,26.38987 58.08372,26.38632 58.09248,26.39226 58.09696,26.39429 58.09568,26.39761 58.09877,26.40633 58.09884,26.40749 58.09584,26.41209 58.09399,26.41371 58.09185,26.41470 58.09047,26.41429 58.08805,26.41575 58.08668,26.41796 58.08487,26.42514 58.08400,26.42594 58.08235,26.42436 58.08279,26.42629 58.08343,26.43666 58.08471,26.43673 58.08569,26.43755 58.08583,26.42742 58.08870,26.42781 58.08940,26.42840 58.08992,26.42921 58.09024,26.43153 58.09074,26.43237 58.09410,26.43530 58.09678,26.43473 58.09758,26.43540 58.09755,26.43712 58.09946,26.43752 58.09964,26.43588 58.10046,26.43511 58.10018,26.43291 58.09958,26.43168 58.10037,26.42795 58.10125,26.42746 58.10174,26.42640 58.10705,26.42243 58.10849,26.41973 58.11010,26.41849 58.11150,26.41589 58.11295,26.41206 58.11497,26.40905 58.11516,26.41091 58.11601,26.41288 58.12392,26.42062 58.12813,26.42737 58.13569,26.43310 58.14042,26.42970 58.14124,26.42636 58.14363,26.42260 58.14407,26.42262 58.14461,26.42355 58.14639,26.42793 58.14875,26.43097 58.15032,26.42935 58.15119,26.42916 58.15216,26.42546 58.15221,26.42116 58.15642,26.42211 58.15691,26.42374 58.15731,26.42385 58.15893,26.42312 58.15966,26.42185 58.16173,26.42096 58.16490,26.42152 58.16765,26.42126 58.16902,26.41995 58.17111,26.42031 58.17118,26.42161 58.17204,26.42234 58.17244,26.42388 58.17581,26.42319 58.17753,26.41584 58.17761,26.41250 58.17835,26.41103 58.18047,26.41258 58.18583,26.41441 58.18873,26.41735 58.19058,26.41693 58.19147,26.41804 58.19620,26.41828 58.19782,26.42055 58.20020,26.42148 58.20202,26.42155 58.20321,26.42097\";\n\nconst MAX_POINTS_PER_TRIP = 5000;\nconst BBOX = { latMin: 57.5, latMax: 59.7, lonMin: 21.5, lonMax: 28.3 }; // loose Estonia box\nconst SLUG_RE = /^[a-z0-9][a-z0-9-]{4,63}$/;\n\nlet initPromise: Promise | undefined;\nfunction init(): Promise {\n if (!initPromise) {\n initPromise = (async () => {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS trips (\n slug TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS points (\n trip_slug TEXT NOT NULL,\n ts INTEGER NOT NULL,\n lat REAL NOT NULL,\n lon REAL NOT NULL,\n acc REAL,\n speed REAL,\n batt REAL,\n PRIMARY KEY (trip_slug, ts)\n )`);\n })();\n }\n return initPromise;\n}\n\nfunction tokenOk(given: string | null): boolean {\n const expected = Deno.env.get(\"WRITE_TOKEN\");\n if (!expected || !given) return false;\n // Hash both sides so timingSafeEqual gets equal-length buffers.\n const a = createHash(\"sha256\").update(given).digest();\n const b = createHash(\"sha256\").update(expected).digest();\n return timingSafeEqual(a, b);\n}\n\n// std/sqlite rows are documented as objects keyed by column name, but accept\n// positional arrays too in case the client library changes shape.\nfunction rowVal(row: unknown, key: string, idx: number): unknown {\n return Array.isArray(row) ? row[idx] : (row as Record)[key];\n}\n\nfunction numOrNull(v: string | null): number | null {\n if (v === null || v === \"\") return null;\n const n = Number(v);\n return Number.isFinite(n) ? n : null;\n}\n\nfunction bad(msg: string): Response {\n return new Response(msg, { status: 400 });\n}\n\nasync function handleLog(slug: string, url: URL): Promise {\n if (!tokenOk(url.searchParams.get(\"key\"))) {\n return new Response(\"unauthorized\", { status: 401 });\n }\n if (!SLUG_RE.test(slug)) return bad(\"bad slug\");\n\n const lat = Number(url.searchParams.get(\"lat\"));\n const lon = Number(url.searchParams.get(\"lon\"));\n if (\n url.searchParams.get(\"lat\") === null ||\n url.searchParams.get(\"lon\") === null ||\n !Number.isFinite(lat) || !Number.isFinite(lon)\n ) {\n return bad(\"lat/lon missing or not numeric\");\n }\n if (\n lat < BBOX.latMin || lat > BBOX.latMax || lon < BBOX.lonMin ||\n lon > BBOX.lonMax\n ) {\n return bad(\"outside expected area\");\n }\n\n const rawTs = url.searchParams.get(\"ts\");\n let tsMs = rawTs ? Date.parse(rawTs) : NaN;\n if (!Number.isFinite(tsMs)) tsMs = Date.now(); // GPSLogger always sends %TIME; fall back just in case\n if (tsMs > Date.now() + 5 * 60 * 1000) return bad(\"timestamp in the future\");\n const ts = Math.floor(tsMs / 1000);\n\n const count = await sqlite.execute({\n sql: `SELECT COUNT(*) AS c FROM points WHERE trip_slug = ?`,\n args: [slug],\n });\n if (Number(rowVal(count.rows[0], \"c\", 0)) >= MAX_POINTS_PER_TRIP) {\n return bad(\"trip point limit reached\");\n }\n\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO trips (slug, name, created_at) VALUES (?, ?, ?)`,\n args: [slug, slug, Math.floor(Date.now() / 1000)],\n });\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO points (trip_slug, ts, lat, lon, acc, speed, batt)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [\n slug,\n ts,\n lat,\n lon,\n numOrNull(url.searchParams.get(\"acc\")),\n numOrNull(url.searchParams.get(\"spd\")),\n numOrNull(url.searchParams.get(\"batt\")),\n ],\n });\n return new Response(\"ok\");\n}\n\nasync function handlePoints(slug: string, url: URL): Promise {\n if (!SLUG_RE.test(slug)) {\n return new Response(\"[]\", {\n headers: { \"content-type\": \"application/json\" },\n });\n }\n const since = Number(url.searchParams.get(\"since\")) || 0;\n const result = await sqlite.execute({\n sql: `SELECT ts, lat, lon, acc, speed, batt FROM points\n WHERE trip_slug = ? AND ts > ? ORDER BY ts ASC`,\n args: [slug, since],\n });\n const out = result.rows.map((r) => [\n rowVal(r, \"ts\", 0),\n rowVal(r, \"lat\", 1),\n rowVal(r, \"lon\", 2),\n rowVal(r, \"acc\", 3),\n rowVal(r, \"speed\", 4),\n rowVal(r, \"batt\", 5),\n ]);\n return new Response(JSON.stringify(out), {\n headers: {\n \"content-type\": \"application/json\",\n \"cache-control\": \"no-store\",\n },\n });\n}\n\nfunction handleMap(slug: string): Response {\n if (!SLUG_RE.test(slug)) return new Response(\"Not found\", { status: 404 });\n // slug is regex-validated ([a-z0-9-]) so it is safe to interpolate below.\n const html = `\n\n\n\n\nRattamaraton Live\n\n

Diff · v2