Flyering Map

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_315":316,"_317":318},"routes/_app.x.$handle.$name",{"_97":96,"_32":46,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":59,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":31,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",153,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/index.ts","latestPath","fileId","41415df8-345f-11f1-aca4-42b51c65c3df","name","index.ts","fileType","http","content","import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport areas from \"./routes/areas.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Run migrations on startup\nawait runMigrations();\n\n// API routes\napp.route(\"/api/areas\", areas);\n\n// Serve frontend files\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve index page with initial data\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n const mapboxToken = Deno.env.get(\"MAPBOX_TOKEN\") ?? \"\";\n const injected = ``;\n html = html.replace(\"\", `${injected}`);\n return c.html(html);\n});\n\nexport default app.fetch;\n","import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { syncNamesIfStale } from \"./database/namesQueries.ts\";\nimport areas from \"./routes/areas.ts\";\nimport names from \"./routes/names.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err) => Promise.reject(err));\n\n// Run migrations on startup\nawait runMigrations();\n\n// Prime the names cache on cold start\nawait syncNamesIfStale();\n\n// API routes\napp.route(\"/api/areas\", areas);\napp.route(\"/api/names\", names);\n\n// Serve frontend files\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve index page with initial data\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n const mapboxToken = Deno.env.get(\"MAPBOX_TOKEN\") ?? \"\";\n const injected = ``;\n html = html.replace(\"\", `${injected}`);\n return c.html(html);\n});\n\nexport default app.fetch;\n","createdAt",["D",1783710021831],"branchVersion","branchId","217492f6-345f-11f1-967e-42b51c65c3df","id","2173f47c-345f-11f1-967e-42b51c65c3df","flyermap",["D",1775771861289],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Track where flyers have been placed on a map","imageUrl","9c30ae6f-cb96-4a42-8870-9ee54e43392d","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e57d2528-cd45-49b9-ae4b-fcfd7aaee32e","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":56,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"isOwned",155,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","mackey","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJodnpTUVJvUVI5QjVxV1ZEYm5sZVJoRmd1SyIsImluaXRpYWxzIjoiTUcifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":311,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":31,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":312,"_81":313,"_83":314,"_85":25},"tree",[185,187,196,199,201,202],"files",[185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202],"counts",{"_175":63,"_176":154,"_177":63,"_178":179,"_180":181},"contents",[127,128,129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":169,"_32":170,"_30":171,"_136":-5,"_42":43,"_41":172,"_138":59,"_39":173,"_13":63,"_34":156,"_36":-5,"_24":25,"_141":-5,"_27":174},{"_44":164,"_32":165,"_30":166,"_136":-5,"_42":43,"_41":148,"_138":59,"_39":167,"_13":63,"_34":156,"_36":-5,"_24":25,"_141":-5,"_27":168},{"_44":158,"_32":159,"_30":160,"_136":-5,"_42":43,"_41":161,"_138":59,"_39":162,"_13":63,"_34":156,"_36":-5,"_24":25,"_141":-5,"_27":163},{"_44":151,"_32":152,"_30":153,"_136":-5,"_42":43,"_41":154,"_138":59,"_39":155,"_13":63,"_34":156,"_36":-5,"_24":25,"_141":-5,"_27":157},{"_44":143,"_32":144,"_30":145,"_136":-5,"_42":43,"_41":146,"_138":59,"_39":147,"_13":148,"_34":20,"_36":149,"_24":25,"_141":-5,"_27":150},{"_44":133,"_32":134,"_30":135,"_136":-5,"_42":43,"_41":137,"_138":59,"_39":139,"_13":63,"_34":20,"_36":140,"_24":25,"_141":-5,"_27":142},"c5d0f3ce-360f-11f1-867d-42b51c65c3df","VAL_TOWN_SYNC.md","c5d0f482-360f-11f1-867d-42b51c65c3df","parentId",93,"latest",["D",1775957679628],"# Val Town auto-sync setup\n\nThis project auto-syncs to Val Town via the `vt` CLI. Two long-running\nbackground processes keep local and remote in lockstep:\n\n| Process | Purpose |\n|-------------|----------------------------------------------|\n| `vt watch` | Pushes local file saves to Val Town |\n| `vt tail` | Streams server logs from Val Town to console |\n\n## Prereqs\n\n- `vt` CLI installed (this machine has it at `/Users/mackey/.deno/bin/vt`,\n installed via `deno install -Arf jsr:@valtown/vt`).\n- `.env` at repo root contains `VALTOWN_TOKEN=vtwn_...`.\n- `.vt/state.json` links this directory to a Val Town project\n (`val.id` + `branch.id` + `branch.version`). If missing, recreate by\n cloning the project once: `vt clone /tmp/x && cp -r /tmp/x/.vt .`.\n- `.vtignore` excludes files that must not upload (`.env`, `CLAUDE.md`,\n `coverage.kmz`, `VAL_TOWN_SYNC.md`, …).\n\n## Start the sync processes\n\nThe `vt` CLI reads its token from `VAL_TOWN_API_KEY`, so source `.env` and\nremap the var name inline:\n\n```sh\nsource .env && VAL_TOWN_API_KEY=$VALTOWN_TOKEN vt watch # run in background\nsource .env && VAL_TOWN_API_KEY=$VALTOWN_TOKEN vt tail # run in background\n```\n\nFrom Claude Code, launch each with `run_in_background: true` so they stream\ninto background task output instead of blocking the chat.\n\n## Verifying a deploy\n\nThe live URL is **not** `-.web.val.run`. It's keyed off the\nentry file ID. To look it up:\n\n```sh\ncurl -s -H \"Authorization: Bearer $VALTOWN_TOKEN\" \\\n \"https://api.val.town/v1/projects/$(jq -r .val.id .vt/state.json)/files\" \\\n | jq -r '.data[] | select(.type==\"http\") | .links.endpoint'\n```\n\n## Things that are NOT synced\n\n- **Environment variables** — the Val Town API does not expose env var\n writes. Set `MAPBOX_TOKEN` and friends in the Val Town **web UI**\n (project → Settings → Environment Variables). The local `.env` is only\n used for the `vt` CLI token; Val Town never reads it.\n- Anything matched by `.vtignore`.\n\n## Restart / recovery\n\n- If `vt watch` dies, just relaunch with the command above — it\n reconciles from `.vt/state.json`.\n- If local `.vt/` gets wiped, re-clone the project to a temp dir and copy\n its `.vt/` back in (do not run `vt init` — it can overwrite files).\n- If a push rejects with a version mismatch, run `vt pull` once to\n resync the branch version then relaunch `vt watch`.\n","label",[134],"c7ee19de-360f-11f1-aa5a-42b51c65c3df",".vtignore","296c3ed0-3605-11f1-916b-42b51c65c3df",94,["D",1775957683174],2,"CLAUDE.md\n.env\n.env.*\ncoverage.kmz\nVAL_TOWN_SYNC.md\n",[144],"3c4633d2-345f-11f1-a723-42b51c65c3df","shared","1cb08f9c-5556-40ad-90a4-cf9fb96068d6",1,["D",1775771906287],"directory",[152],"41852cc2-345f-11f1-be74-42b51c65c3df","frontend","d89eb0e6-4fa7-4142-b085-b782e9e01eb3",6,["D",1775771915084],[159],"40668c1e-345f-11f1-b0f6-42b51c65c3df","backend","8a8fec3e-9dd4-4c3a-8598-7c75407d063c",["D",1775771913209],[165],"2cdcfe20-3609-11f1-9d85-42b51c65c3df",".claude","2cdcff06-3609-11f1-9d85-42b51c65c3df",51,["D",1775954846037],[170],"pulls","branches","forks","envVars",{"_182":154,"_184":63},"connections",{"_182":63,"_183":63},"count","unfilledCount","emptyCount",{"_44":169,"_32":170,"_30":171,"_136":-5,"_42":43,"_41":172,"_138":59,"_39":308,"_13":63,"_34":156,"_36":-5,"_24":25,"_141":-5,"_204":309,"_27":310},{"_44":300,"_32":301,"_30":302,"_136":171,"_42":43,"_41":303,"_138":59,"_39":304,"_13":63,"_34":20,"_36":305,"_24":25,"_141":-5,"_204":306,"_27":307},{"_44":164,"_32":165,"_30":166,"_136":-5,"_42":43,"_41":148,"_138":59,"_39":297,"_13":63,"_34":156,"_36":-5,"_24":25,"_141":-5,"_204":298,"_27":299},{"_44":293,"_32":277,"_30":271,"_136":166,"_42":43,"_41":148,"_138":59,"_39":294,"_13":63,"_34":156,"_36":-5,"_24":25,"_141":-5,"_204":295,"_27":296},{"_44":286,"_32":287,"_30":288,"_136":271,"_42":43,"_41":148,"_138":25,"_39":289,"_13":63,"_34":20,"_36":290,"_24":25,"_141":-5,"_204":291,"_27":292},{"_44":278,"_32":279,"_30":280,"_136":271,"_42":43,"_41":281,"_138":25,"_39":282,"_13":63,"_34":251,"_36":283,"_24":25,"_141":-5,"_204":284,"_27":285},{"_44":268,"_32":269,"_30":270,"_136":271,"_42":43,"_41":272,"_138":59,"_39":273,"_13":154,"_34":20,"_36":274,"_24":25,"_141":-5,"_204":275,"_27":276},{"_44":264,"_32":255,"_30":248,"_136":166,"_42":43,"_41":259,"_138":59,"_39":265,"_13":63,"_34":156,"_36":-5,"_24":25,"_141":-5,"_204":266,"_27":267},{"_44":256,"_32":257,"_30":258,"_136":248,"_42":43,"_41":259,"_138":59,"_39":260,"_13":63,"_34":20,"_36":261,"_24":25,"_141":-5,"_204":262,"_27":263},{"_44":245,"_32":246,"_30":247,"_136":248,"_42":43,"_41":249,"_138":59,"_39":250,"_13":63,"_34":251,"_36":252,"_24":25,"_141":-5,"_204":253,"_27":254},{"_44":240,"_32":33,"_30":31,"_136":166,"_42":43,"_41":14,"_138":59,"_39":241,"_13":242,"_34":35,"_36":38,"_24":25,"_141":-5,"_204":243,"_27":244},{"_44":158,"_32":159,"_30":160,"_136":-5,"_42":43,"_41":161,"_138":59,"_39":237,"_13":63,"_34":156,"_36":-5,"_24":25,"_141":-5,"_204":238,"_27":239},{"_44":229,"_32":230,"_30":231,"_136":160,"_42":43,"_41":232,"_138":59,"_39":233,"_13":63,"_34":20,"_36":234,"_24":25,"_141":-5,"_204":235,"_27":236},{"_44":220,"_32":221,"_30":222,"_136":160,"_42":43,"_41":223,"_138":59,"_39":224,"_13":225,"_34":20,"_36":226,"_24":25,"_141":-5,"_204":227,"_27":228},{"_44":151,"_32":152,"_30":153,"_136":-5,"_42":43,"_41":154,"_138":59,"_39":217,"_13":63,"_34":156,"_36":-5,"_24":25,"_141":-5,"_204":218,"_27":219},{"_44":210,"_32":211,"_30":212,"_136":153,"_42":43,"_41":154,"_138":59,"_39":213,"_13":63,"_34":20,"_36":214,"_24":25,"_141":-5,"_204":215,"_27":216},{"_44":143,"_32":144,"_30":145,"_136":-5,"_42":43,"_41":146,"_138":59,"_39":207,"_13":148,"_34":20,"_36":149,"_24":25,"_141":-5,"_204":208,"_27":209},{"_44":133,"_32":134,"_30":135,"_136":-5,"_42":43,"_41":137,"_138":59,"_39":203,"_13":63,"_34":20,"_36":140,"_24":25,"_141":-5,"_204":205,"_27":206},["D",1775957679628],"children",[],[134],["D",1775957683174],[],[144],"3c460c0e-345f-11f1-a723-42b51c65c3df","types.ts","3c460cf4-345f-11f1-a723-42b51c65c3df",["D",1775771906287],"export interface FlyerArea {\n id: number;\n user_name: string;\n area_name: string;\n geojson: string; // GeoJSON polygon\n color: string;\n created_at: string;\n}\n\nexport interface CreateFlyerAreaRequest {\n user_name: string;\n area_name: string;\n geojson: object;\n color: string;\n}\n",[],[152,211],["D",1775771906287],[200],[152],"52d8ed49-918f-407c-8f22-a5d4b95e7d2a","index.html","4184ba58-345f-11f1-be74-42b51c65c3df",152,["D",1783710021833],134,"\n\n\n \n \n \n \n \n Flyering Map\n \n \n \n \n \n\n\n\n \n

\n \n

\n\n \n

\n \n

\n\n \n \n\n \n

\n Brush\n \n

\n\n \n

\n \n \n

\n\n \n \n\n

🖌️ Drag to paint — tap ✓ to save

\n\n \n\n\n",[],[159,221],"645cfa3a-360e-11f1-ae05-42b51c65c3df","coverage.geojson","645cfb0c-360e-11f1-ae05-42b51c65c3df",84,["D",1775957086630],"{\n \"type\": \"FeatureCollection\",\n \"features\": [\n {\n \"type\": \"Feature\",\n \"properties\": {\n \"name\": \"Speedys Service Area\",\n \"updated\": \"2025-06\"\n },\n \"geometry\": {\n \"type\": \"Polygon\",\n \"coordinates\": [[\n [-122.3848664, 47.8165284],\n [-122.4020325, 47.8049999],\n [-122.406613, 47.7800734],\n [-122.3966567, 47.7505347],\n [-122.4015726, 47.7191852],\n [-122.4543349, 47.6699104],\n [-122.4378554, 47.6412345],\n [-122.397, 47.619023],\n [-122.4000899, 47.6067564],\n [-122.4384247, 47.5799149],\n [-122.4100463, 47.509911],\n [-122.3688475, 47.4867157],\n [-122.3891036, 47.4716332],\n [-122.3884169, 47.4458671],\n [-122.2964064, 47.4519035],\n [-122.2637908, 47.4507427],\n [-122.1844832, 47.4595642],\n [-122.1841399, 47.4785949],\n [-122.1381346, 47.5036492],\n [-122.1398513, 47.5129256],\n [-122.1474044, 47.5215048],\n [-122.1487777, 47.5328642],\n [-122.1546141, 47.5407448],\n [-122.1553008, 47.5463069],\n [-122.1329848, 47.5419036],\n [-122.1189086, 47.5405131],\n [-122.1103255, 47.5467704],\n [-122.0921294, 47.5486243],\n [-122.071756, 47.5618476],\n [-122.095102, 47.5910302],\n [-122.0779358, 47.611402],\n [-122.081369, 47.6303777],\n [-122.1015085, 47.6526218],\n [-122.0916687, 47.6576721],\n [-122.0724426, 47.6558221],\n [-122.0635163, 47.6609095],\n [-122.0628296, 47.6886501],\n [-122.0751892, 47.7173],\n [-122.1317209, 47.7108694],\n [-122.1377913, 47.7292934],\n [-122.1523203, 47.7494342],\n [-122.1569, 47.7643994],\n [-122.1524932, 47.7786262],\n [-122.1431671, 47.7823967],\n [-122.1438225, 47.7903919],\n [-122.2919432, 47.7916074],\n [-122.2919432, 47.8065978],\n [-122.3070494, 47.8065978],\n [-122.3671309, 47.8215838],\n [-122.376744, 47.8218143],\n [-122.3848664, 47.8165284]\n ]]\n }\n }\n ]\n}\n",[],[159,230],["D",1775771915084],[197,198],[159],"15f4247f-7db3-4c7f-af3f-0482943a8208",["D",1783710021831],3,[],[165,33],"4372818d-0af8-4643-b7d8-746843909ba6","names.ts","99d75ce0-7c91-11f1-8601-1607ee4eb77e","d5b44a31-e9f9-4380-8aea-e1115adbbac1",150,["D",1783710021819],"script","import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { getAllNames, syncNamesIfStale } from \"../database/namesQueries.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", async (c) => {\n await syncNamesIfStale();\n const names = await getAllNames();\n return c.json(names);\n});\n\nexport default app;\n",[],[165,255,246],"routes","40fb457a-345f-11f1-b301-42b51c65c3df","areas.ts","40fb4638-345f-11f1-b301-42b51c65c3df",4,["D",1775771914185],"import { Hono } from \"https://esm.sh/hono@4.4.2\";\nimport { getAllAreas, createArea, deleteArea } from \"../database/queries.ts\";\nimport type { CreateFlyerAreaRequest } from \"../../shared/types.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", async (c) => {\n const areas = await getAllAreas();\n return c.json(areas);\n});\n\napp.post(\"/\", async (c) => {\n const body: CreateFlyerAreaRequest = await c.req.json();\n if (!body.user_name || !body.area_name || !body.geojson) {\n return c.json({ error: \"user_name, area_name, and geojson are required\" }, 400);\n }\n const area = await createArea(body);\n return c.json(area, 201);\n});\n\napp.delete(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n await deleteArea(id);\n return c.json({ ok: true });\n});\n\nexport default app;\n",[],[165,255,257],"40fb6802-345f-11f1-b301-42b51c65c3df",["D",1775771914185],[193,194],[165,255],"2257799c-3769-11f1-ae77-42b51c65c3df","queries.ts","40afa034-345f-11f1-8d06-42b51c65c3df","3cfd4d51-4a25-43e0-8a26-72e42656c75c",108,["D",1776106011224],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { TABLE_NAME } from \"./migrations.ts\";\nimport type { FlyerArea, CreateFlyerAreaRequest } from \"../../shared/types.ts\";\n\nexport async function getAllAreas(): Promise {\n const { rows } = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE created_at >= datetime('now', '-28 days') ORDER BY created_at DESC`\n );\n return rows as unknown as FlyerArea[];\n}\n\nexport async function createArea(req: CreateFlyerAreaRequest): Promise {\n const { rows } = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (user_name, area_name, geojson, color) VALUES (?, ?, ?, ?) RETURNING *`,\n [req.user_name, req.area_name, JSON.stringify(req.geojson), req.color]\n );\n return (rows as unknown as FlyerArea[])[0];\n}\n\nexport async function deleteArea(id: number): Promise {\n await sqlite.execute(`DELETE FROM ${TABLE_NAME} WHERE id = ?`, [id]);\n}\n",[],[165,277,269],"database","b8451400-57c3-46fc-91f1-e682cbd6a4b2","namesQueries.ts","99ddcd5a-7c91-11f1-bc2d-1607ee4eb77e",151,["D",1783710021843],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\nimport { NAMES_TABLE_NAME, NAMES_SYNC_META_TABLE_NAME } from \"./migrations.ts\";\n\n// Public \"Name\" column, published as CSV\nconst NAMES_SHEET_CSV_URL =\n \"https://docs.google.com/spreadsheets/d/13iuYjJ83K0sxAqFvvkAExaRrNhbDKAb3hF-C8zY4iKI/export?format=csv\";\n\n// Re-pull the sheet at most this often; otherwise serve the cached DB list\nconst SYNC_INTERVAL_MS = 5 * 60 * 1000;\n\nexport async function getAllNames(): Promise {\n const { rows } = await sqlite.execute(`SELECT name FROM ${NAMES_TABLE_NAME} ORDER BY name ASC`);\n return (rows as unknown as { name: string }[]).map((r) => r.name);\n}\n\nasync function getLastSyncedAt(): Promise {\n const { rows } = await sqlite.execute(`SELECT synced_at FROM ${NAMES_SYNC_META_TABLE_NAME} WHERE id = 1`);\n const row = (rows as unknown as { synced_at: string }[])[0];\n return row ? new Date(row.synced_at) : null;\n}\n\nfunction parseNamesCsv(csv: string): string[] {\n return csv\n .split(/\\r?\\n/)\n .slice(1) // drop \"Name\" header\n .map((line) => line.trim().replace(/^\"|\"$/g, \"\"))\n .filter(Boolean);\n}\n\nasync function fetchNamesFromSheet(): Promise {\n const res = await fetch(NAMES_SHEET_CSV_URL);\n if (!res.ok) throw new Error(`Failed to fetch names sheet: ${res.status}`);\n return parseNamesCsv(await res.text());\n}\n\nasync function replaceAllNames(names: string[]): Promise {\n await sqlite.execute(`DELETE FROM ${NAMES_TABLE_NAME}`);\n for (const name of names) {\n await sqlite.execute(`INSERT OR IGNORE INTO ${NAMES_TABLE_NAME} (name) VALUES (?)`, [name]);\n }\n await sqlite.execute(\n `INSERT INTO ${NAMES_SYNC_META_TABLE_NAME} (id, synced_at) VALUES (1, CURRENT_TIMESTAMP)\n ON CONFLICT(id) DO UPDATE SET synced_at = CURRENT_TIMESTAMP`\n );\n}\n\n// Refreshes the names table from the Google Sheet if the cache is stale.\n// Falls back silently to whatever is already in the DB if the sheet fetch fails.\nexport async function syncNamesIfStale(): Promise {\n const lastSynced = await getLastSyncedAt();\n if (lastSynced && Date.now() - lastSynced.getTime() < SYNC_INTERVAL_MS) return;\n\n try {\n const names = await fetchNamesFromSheet();\n await replaceAllNames(names);\n } catch (err) {\n console.error(\"Names sheet sync failed, serving cached names:\", err);\n }\n}\n",[],[165,277,279],"40666612-345f-11f1-b0f6-42b51c65c3df","migrations.ts","406666bc-345f-11f1-b0f6-42b51c65c3df",["D",1775771913209],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nconst TABLE_NAME = \"flyermap_areas_1\";\n\nexport async function runMigrations() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_name TEXT NOT NULL,\n area_name TEXT NOT NULL,\n geojson TEXT NOT NULL,\n color TEXT NOT NULL DEFAULT '#3388ff',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport { TABLE_NAME };\n",[],[165,277,287],"40669042-345f-11f1-b0f6-42b51c65c3df",["D",1775771913209],[189,190,191],[165,277],["D",1775771913209],[188,192,195],[165],"2cf5a218-3609-11f1-9d85-42b51c65c3df","settings.local.json","2cf5a2ae-3609-11f1-9d85-42b51c65c3df",52,["D",1775954846202],"{\n \"permissions\": {\n \"allow\": [\n \"WebFetch(domain:docs.val.town)\"\n ]\n }\n}\n",[],[170,301],["D",1775954846037],[186],[170],["D",1775771861289],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":56,"_101":102,"_103":25},{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_124":348,"_349":350,"_351":352,"_353":25,"_354":25,"_355":25,"_356":59,"_357":-5,"_358":-7,"_359":-7,"_360":63,"_361":25,"_362":25,"_363":-5,"_364":25,"_365":25,"_366":25,"_367":-5},"ENV",{"_319":320,"_321":322,"_323":87,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347},"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"]

Finding your location…

Flyering Map

Diff · v153