[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_116":-5,"_20":117,"_22":118,"_119":120,"_121":122,"_25":123,"_24":-5,"_124":-5,"_125":-5,"_126":53,"_127":128,"_129":44,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","Petroleumjelliffe","name","Nearby-asp-rules","branchName","main","version","path","","project",{"_33":62,"_13":14,"_45":63,"_64":-5,"_65":53,"_66":67,"_68":67,"_69":19,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":53},"tree",[57],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_18":56},"id","82517826-a6c9-4c6c-9634-7c20fe9d2c5c","main.ts","fileId","14fc7ab4-86a0-11f1-b426-1607ee4eb77e","parentId","branchId","30b7e9c1-82af-4933-be0b-e1fac430343c","branchVersion",9,"latest",true,"createdAt",["D",1785378750455],8,"fileType","http","content","// Val Town HTTP val. Public read endpoint. Reads a precomputed, geohash-indexed\n// SQLite file hosted on GitHub Pages (built by `nyc_parking_signs.py ingest\n// --minimize`), loads it into an in-memory sql.js database once per container,\n// and scores a point:\n// https://nearby-asp-rules.val.run?lat=40.6435&lon=-74.0089&radius=200\n\nimport ngeohash from \"https://esm.sh/ngeohash@0.6.3\";\nimport initSqlJs from \"https://esm.sh/sql.js@1.13.0\";\n\n// Static dataset hosted on GitHub Pages (gzipped, ~3.4 MB). No Val Town SQLite.\nconst DB_URL =\n \"https://petroleumjelliffe.github.io/nearby-asp-rules/signs.sqlite.gz\";\n\n// Load the DB once and reuse it for the life of the container. The fetch +\n// gunzip + WASM init only happens on a cold start; subsequent requests hit the\n// in-memory copy. A container recycle is what picks up a re-published dataset.\nlet dbPromise: Promise | null = null;\nfunction getDb(): Promise {\n if (!dbPromise) dbPromise = loadDb();\n return dbPromise;\n}\nconst WASM_URL = \"https://cdn.jsdelivr.net/npm/sql.js@1.13.0/dist/sql-wasm.wasm\";\n\nasync function loadDb(): Promise {\n // Fetch the wasm bytes ourselves and hand them to initSqlJs directly. The\n // Deno build of sql.js otherwise tries to read the wasm from the filesystem\n // (locateFile is treated as a path, not a URL), which fails.\n const wasmBinary = await (await fetch(WASM_URL)).arrayBuffer();\n const SQL = await initSqlJs({ wasmBinary });\n const resp = await fetch(DB_URL);\n if (!resp.ok) throw new Error(`fetch ${DB_URL}: ${resp.status}`);\n // Pages serves the .gz as raw bytes (no content-encoding), so decompress it\n // ourselves rather than relying on fetch's automatic handling.\n const bytes = await new Response(\n resp.body!.pipeThrough(new DecompressionStream(\"gzip\")),\n ).arrayBuffer();\n return new SQL.Database(new Uint8Array(bytes));\n}\n\n// Schedules are parsed to typed fields once, at ingest (nyc_parking_signs.py),\n// not here — this val just reads the precomputed columns and compares. See the\n// \"Data model\" note in the design spec.\ninterface Candidate {\n lat: number;\n lon: number;\n on_street: string | null;\n side_of_street: string | null;\n days: string[]; // normalized full weekday names, e.g. [\"TUESDAY\", \"FRIDAY\"]\n start_min: number | null; // minutes since midnight (meridiem already resolved)\n end_min: number | null;\n raw: string; // original sign_description, for display\n}\n\n// Format minutes-since-midnight back to the display form the API returns\n// (e.g. 510 -> \"8:30AM\", 600 -> \"10AM\"). Round hours drop the \":00\".\nfunction minToDisplay(m: number | null): string | null {\n if (m === null) return null;\n const hour24 = Math.floor(m / 60);\n const minute = m % 60;\n const meridiem = hour24 < 12 ? \"AM\" : \"PM\";\n const hour12 = hour24 % 12 === 0 ? 12 : hour24 % 12;\n return minute === 0\n ? `${hour12}${meridiem}`\n : `${hour12}:${String(minute).padStart(2, \"0\")}${meridiem}`;\n}\n\n// Same buckets as before, now from typed fields instead of a per-request parse.\nfunction classify(sign: Candidate, ny: { weekday: string; minutes: number }) {\n if (sign.days.length === 0) return \"unparsed\"; // parse_status 'no_days'\n if (!sign.days.includes(ny.weekday)) return \"not_today\";\n if (sign.start_min === null || sign.end_min === null) return \"unparsed\"; // 'no_time'\n if (ny.minutes >= sign.start_min && ny.minutes <= sign.end_min) return \"active_now\";\n if (ny.minutes < sign.start_min) return \"later_today\";\n return \"passed_today\";\n}\n\nfunction haversineFt(lat1: number, lon1: number, lat2: number, lon2: number) {\n const R_ft = 20925721.0;\n const rad = (d: number) => (d * Math.PI) / 180;\n const dphi = rad(lat2 - lat1);\n const dlambda = rad(lon2 - lon1);\n const a = Math.sin(dphi / 2) ** 2 +\n Math.cos(rad(lat1)) * Math.cos(rad(lat2)) * Math.sin(dlambda / 2) ** 2;\n return 2 * R_ft * Math.atan2(Math.sqrt(a), Math.sqrt(1 - a));\n}\n\n// Geohash-6 cell for the query point plus its 8 neighbors. Guarantees coverage\n// out to ~2000 ft (the smaller cell dimension), which comfortably spans the\n// intended 1-2 avenue / 3-6 block query radius.\nexport function signCellKeys(lat: number, lon: number): string[] {\n const center = ngeohash.encode(lat, lon, 6);\n return [...new Set([center, ...ngeohash.neighbors(center)])];\n}\n\nexport function scoreCandidates(\n candidates: Candidate[],\n lat: number,\n lon: number,\n radiusFt: number,\n ny: { weekday: string; minutes: number },\n) {\n const buckets: Record = {\n active_now: 0, later_today: 0, passed_today: 0, not_today: 0, unparsed: 0,\n };\n const details: Record = {\n active_now: [], later_today: [], passed_today: [], not_today: [], unparsed: [],\n };\n let total = 0;\n for (const sign of candidates) {\n const d = haversineFt(lat, lon, sign.lat, sign.lon);\n if (d > radiusFt) continue;\n total++;\n const status = classify(sign, ny);\n buckets[status]++;\n details[status].push({\n distance_ft: Math.round(d * 10) / 10,\n on_street: sign.on_street,\n side_of_street: sign.side_of_street,\n schedule: {\n days: sign.days,\n start: minToDisplay(sign.start_min),\n end: minToDisplay(sign.end_min),\n raw: sign.raw,\n },\n });\n }\n const pct = (n: number) => (total ? Math.round((1000 * n) / total) / 10 : 0);\n return {\n radius_ft: radiusFt,\n total_signs: total,\n pct_active_now: pct(buckets.active_now),\n pct_later_today: pct(buckets.later_today),\n pct_no_restriction_today: pct(buckets.not_today + buckets.passed_today),\n counts: buckets,\n details,\n };\n}\n\n// Val Town's Deno runtime defaults to UTC, so Date.getHours()/getDay() do NOT\n// give NYC local time. This pulls the actual America/New_York wall-clock\n// time regardless of what timezone the server process is running in.\nfunction nyNow(now: Date): { weekday: string; minutes: number } {\n const fmt = new Intl.DateTimeFormat(\"en-US\", {\n timeZone: \"America/New_York\",\n weekday: \"long\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false,\n });\n const parts = fmt.formatToParts(now);\n const weekday = parts.find((p) => p.type === \"weekday\")!.value.toUpperCase();\n let hour = parseInt(parts.find((p) => p.type === \"hour\")!.value, 10);\n const minute = parseInt(parts.find((p) => p.type === \"minute\")!.value, 10);\n if (hour === 24) hour = 0; // midnight sometimes formats as \"24\" in en-US\n return { weekday, minutes: hour * 60 + minute };\n}\n\n// 2026 ASP suspension dates (legal + religious holidays where street cleaning\n// rules are suspended), keyed by NY-local calendar date \"YYYY-MM-DD\".\n// Source: NYC DOT's published 2026 ASP Suspension Calendar\n// (nyc.gov/html/dot/downloads/pdf/asp-calendar-2026.pdf). This needs to be\n// updated once a year, DOT doesn't expose it as a clean API, and the one\n// unofficial no-auth mirror I checked was returning server errors.\nconst ASP_SUSPENDED_2026: Record = {\n \"2026-01-01\": \"New Year's Day\",\n \"2026-01-06\": \"Three Kings' Day\",\n \"2026-01-19\": \"Martin Luther King Jr.'s Birthday\",\n \"2026-02-16\": \"Washington's Birthday (Presidents' Day)\",\n \"2026-03-19\": \"Purim\",\n \"2026-04-02\": \"Holy Thursday\",\n \"2026-04-03\": \"Good Friday\",\n \"2026-04-21\": \"Passover\",\n \"2026-04-22\": \"Passover\",\n \"2026-05-25\": \"Memorial Day\",\n \"2026-06-19\": \"Juneteenth\",\n \"2026-07-23\": \"Tisha B'Av\",\n \"2026-08-15\": \"Feast of the Assumption\",\n \"2026-09-07\": \"Labor Day\",\n \"2026-09-12\": \"Rosh Hashanah\",\n \"2026-09-13\": \"Rosh Hashanah\",\n \"2026-09-21\": \"Yom Kippur\",\n \"2026-09-26\": \"Succoth\",\n \"2026-09-27\": \"Succoth\",\n \"2026-10-03\": \"Shemini Atzereth\",\n \"2026-10-04\": \"Simchas Torah\",\n \"2026-10-08\": \"Diwali\",\n \"2026-10-12\": \"Italian Heritage Day / Indigenous Peoples' Day\",\n \"2026-11-01\": \"All Saints Day\",\n \"2026-11-03\": \"Election Day\",\n \"2026-11-11\": \"Veterans Day\",\n \"2026-11-26\": \"Thanksgiving Day\",\n \"2026-12-08\": \"Immaculate Conception\",\n \"2026-12-25\": \"Christmas Day\",\n};\n\nfunction nyDateKey(now: Date): string {\n const fmt = new Intl.DateTimeFormat(\"en-CA\", { timeZone: \"America/New_York\" }); // en-CA -> YYYY-MM-DD\n return fmt.format(now);\n}\n\n// Wraps Response.json with a CORS header so this can be called directly from\n// a browser (e.g. an artifact making a client-side fetch), not just from\n// server-side code where CORS doesn't apply.\nfunction corsJson(data: unknown, init: ResponseInit = {}): Response {\n const headers = new Headers(init.headers);\n headers.set(\"Access-Control-Allow-Origin\", \"*\");\n headers.set(\"Content-Type\", \"application/json\");\n return new Response(JSON.stringify(data), { ...init, headers });\n}\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") {\n return new Response(null, {\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, OPTIONS\",\n },\n });\n }\n\n const url = new URL(req.url);\n const lat = parseFloat(url.searchParams.get(\"lat\") || \"\");\n const lon = parseFloat(url.searchParams.get(\"lon\") || \"\");\n const radiusFt = parseFloat(url.searchParams.get(\"radius\") || \"200\");\n\n if (isNaN(lat) || isNaN(lon)) {\n return corsJson(\n { error: \"pass ?lat=..&lon=..&radius=.. (radius optional, default 200ft)\" },\n { status: 400 },\n );\n }\n\n const now = new Date();\n const ny = nyNow(now);\n const dateKey = nyDateKey(now);\n const suspensionReason = ASP_SUSPENDED_2026[dateKey];\n\n if (suspensionReason) {\n return corsJson({\n checked_at_utc: now.toISOString(),\n checked_at_nyc: now.toLocaleString(\"en-US\", { timeZone: \"America/New_York\" }),\n weekday: ny.weekday,\n asp_suspended_today: true,\n suspension_reason: suspensionReason,\n note: \"ASP is suspended citywide today, sign schedules below don't apply. \" +\n \"Meters and other non-cleaning regulations may still be in effect.\",\n });\n }\n\n const cellKeys = signCellKeys(lat, lon);\n const placeholders = cellKeys.map(() => \"?\").join(\", \");\n const db = await getDb();\n const stmt = db.prepare(\n `SELECT lat, lon, on_street, side_of_street, sign_description,\n days, start_min, end_min\n FROM parking_signs WHERE geohash6 IN (${placeholders})`,\n );\n stmt.bind(cellKeys);\n const candidates: Candidate[] = [];\n while (stmt.step()) {\n const r = stmt.getAsObject() as Record;\n candidates.push({\n lat: Number(r.lat),\n lon: Number(r.lon),\n on_street: (r.on_street as string) ?? null,\n side_of_street: (r.side_of_street as string) ?? null,\n days: r.days ? (r.days as string).split(\",\").filter(Boolean) : [],\n start_min: r.start_min == null ? null : Number(r.start_min),\n end_min: r.end_min == null ? null : Number(r.end_min),\n raw: (r.sign_description as string) ?? \"\",\n });\n }\n stmt.free();\n\n const scored = scoreCandidates(candidates, lat, lon, radiusFt, ny);\n return corsJson({\n checked_at_utc: now.toISOString(),\n checked_at_nyc: now.toLocaleString(\"en-US\", { timeZone: \"America/New_York\" }),\n weekday: ny.weekday,\n asp_suspended_today: false,\n ...scored,\n });\n}\n","deleted",false,"label","nearby-asp-rules",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":58,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_59":60,"_18":61},["D",1785378750455],"children",[],[35],"f1577497-18ff-4d38-85f0-c8d352b130a5",["D",1784815752964],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","b9236300-52f3-11f0-9a03-63f1102351a6","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","83b12659-85df-4d47-b69f-9508a7b319b2","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_115":111},"org",{"_11":12,"_109":-5,"_110":111,"_71":72,"_112":113,"_114":53},"branch",{"_17":42,"_13":16,"_33":40,"_101":62,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yejRPNmtZdU9uREpvS0Faa2hua09uSUp5TDQifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":62,"_13":14,"_45":149,"_64":-5,"_65":53,"_66":67,"_68":67,"_69":19,"_70":-5,"_71":72,"_73":37,"_74":44,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":150,"_96":151,"_98":152,"_100":53},[146],"files",[146],"counts",{"_136":78,"_137":138,"_139":78,"_31":140,"_141":142},[134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_18":135},[35],"pulls","branches",1,"forks",{"_143":78,"_145":78},"connections",{"_143":78,"_144":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":58,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_59":147,"_18":148},[],[35],["D",1784815752964],{"_11":12,"_115":111},{"_11":12,"_109":-5,"_110":111,"_71":72,"_112":113,"_114":53},{"_17":42,"_13":16,"_33":40,"_101":62,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_94":-5,"_131":186,"_187":188,"_189":190,"_191":53,"_192":53,"_193":53,"_194":44,"_195":-5,"_196":-7,"_197":-7,"_198":78,"_199":53,"_200":53,"_201":-5,"_202":53,"_203":53,"_204":53,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":16,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"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"]

Code