Flyering Map

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_314":315,"_316":317},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_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",152,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":20,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":20,"_35":36},"deleted",false,"deletedHere","path","frontend/index.html","latestPath","fileId","4184ba58-345f-11f1-be74-42b51c65c3df","name","index.html","fileType","content","\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","\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","createdAt",["D",1783710021833],"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","41415df8-345f-11f1-aca4-42b51c65c3df","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":55,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_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",{"_43":44,"_32":45,"_38":310,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_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":311,"_81":312,"_83":313,"_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",{},{"_43":169,"_32":170,"_30":171,"_136":-5,"_41":42,"_40":172,"_138":59,"_38":173,"_13":63,"_34":156,"_35":-5,"_24":25,"_141":-5,"_27":174},{"_43":164,"_32":165,"_30":166,"_136":-5,"_41":42,"_40":148,"_138":59,"_38":167,"_13":63,"_34":156,"_35":-5,"_24":25,"_141":-5,"_27":168},{"_43":158,"_32":159,"_30":160,"_136":-5,"_41":42,"_40":161,"_138":59,"_38":162,"_13":63,"_34":156,"_35":-5,"_24":25,"_141":-5,"_27":163},{"_43":151,"_32":152,"_30":153,"_136":-5,"_41":42,"_40":154,"_138":59,"_38":155,"_13":63,"_34":156,"_35":-5,"_24":25,"_141":-5,"_27":157},{"_43":143,"_32":144,"_30":145,"_136":-5,"_41":42,"_40":146,"_138":59,"_38":147,"_13":148,"_34":20,"_35":149,"_24":25,"_141":-5,"_27":150},{"_43":133,"_32":134,"_30":135,"_136":-5,"_41":42,"_40":137,"_138":59,"_38":139,"_13":63,"_34":20,"_35":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",{"_43":169,"_32":170,"_30":171,"_136":-5,"_41":42,"_40":172,"_138":59,"_38":307,"_13":63,"_34":156,"_35":-5,"_24":25,"_141":-5,"_204":308,"_27":309},{"_43":299,"_32":300,"_30":301,"_136":171,"_41":42,"_40":302,"_138":59,"_38":303,"_13":63,"_34":20,"_35":304,"_24":25,"_141":-5,"_204":305,"_27":306},{"_43":164,"_32":165,"_30":166,"_136":-5,"_41":42,"_40":148,"_138":59,"_38":296,"_13":63,"_34":156,"_35":-5,"_24":25,"_141":-5,"_204":297,"_27":298},{"_43":292,"_32":276,"_30":270,"_136":166,"_41":42,"_40":148,"_138":59,"_38":293,"_13":63,"_34":156,"_35":-5,"_24":25,"_141":-5,"_204":294,"_27":295},{"_43":285,"_32":286,"_30":287,"_136":270,"_41":42,"_40":148,"_138":25,"_38":288,"_13":63,"_34":20,"_35":289,"_24":25,"_141":-5,"_204":290,"_27":291},{"_43":277,"_32":278,"_30":279,"_136":270,"_41":42,"_40":280,"_138":25,"_38":281,"_13":63,"_34":250,"_35":282,"_24":25,"_141":-5,"_204":283,"_27":284},{"_43":267,"_32":268,"_30":269,"_136":270,"_41":42,"_40":271,"_138":59,"_38":272,"_13":154,"_34":20,"_35":273,"_24":25,"_141":-5,"_204":274,"_27":275},{"_43":263,"_32":254,"_30":247,"_136":166,"_41":42,"_40":258,"_138":59,"_38":264,"_13":63,"_34":156,"_35":-5,"_24":25,"_141":-5,"_204":265,"_27":266},{"_43":255,"_32":256,"_30":257,"_136":247,"_41":42,"_40":258,"_138":59,"_38":259,"_13":63,"_34":20,"_35":260,"_24":25,"_141":-5,"_204":261,"_27":262},{"_43":244,"_32":245,"_30":246,"_136":247,"_41":42,"_40":248,"_138":59,"_38":249,"_13":63,"_34":250,"_35":251,"_24":25,"_141":-5,"_204":252,"_27":253},{"_43":236,"_32":237,"_30":57,"_136":166,"_41":42,"_40":238,"_138":25,"_38":239,"_13":148,"_34":240,"_35":241,"_24":25,"_141":-5,"_204":242,"_27":243},{"_43":158,"_32":159,"_30":160,"_136":-5,"_41":42,"_40":161,"_138":59,"_38":233,"_13":63,"_34":156,"_35":-5,"_24":25,"_141":-5,"_204":234,"_27":235},{"_43":225,"_32":226,"_30":227,"_136":160,"_41":42,"_40":228,"_138":59,"_38":229,"_13":63,"_34":20,"_35":230,"_24":25,"_141":-5,"_204":231,"_27":232},{"_43":220,"_32":33,"_30":31,"_136":160,"_41":42,"_40":14,"_138":59,"_38":221,"_13":222,"_34":20,"_35":37,"_24":25,"_141":-5,"_204":223,"_27":224},{"_43":151,"_32":152,"_30":153,"_136":-5,"_41":42,"_40":154,"_138":59,"_38":217,"_13":63,"_34":156,"_35":-5,"_24":25,"_141":-5,"_204":218,"_27":219},{"_43":210,"_32":211,"_30":212,"_136":153,"_41":42,"_40":154,"_138":59,"_38":213,"_13":63,"_34":20,"_35":214,"_24":25,"_141":-5,"_204":215,"_27":216},{"_43":143,"_32":144,"_30":145,"_136":-5,"_41":42,"_40":146,"_138":59,"_38":207,"_13":148,"_34":20,"_35":149,"_24":25,"_141":-5,"_204":208,"_27":209},{"_43":133,"_32":134,"_30":135,"_136":-5,"_41":42,"_40":137,"_138":59,"_38":203,"_13":63,"_34":20,"_35":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",["D",1783710021833],134,[],[159,33],"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,226],["D",1775771915084],[197,198],[159],"3efdff6e-3609-11f1-843c-42b51c65c3df","index.ts",53,["D",1775954876440],"http","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",[],[165,237],"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,254,245],"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,254,256],"40fb6802-345f-11f1-b301-42b51c65c3df",["D",1775771914185],[193,194],[165,254],"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,276,268],"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,276,278],"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,276,286],"40669042-345f-11f1-b0f6-42b51c65c3df",["D",1775771913209],[189,190,191],[165,276],["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,300],["D",1775954846037],[186],[170],["D",1775771861289],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_124":347,"_348":349,"_350":351,"_352":25,"_353":25,"_354":25,"_355":59,"_356":-5,"_357":-7,"_358":-7,"_359":63,"_360":25,"_361":25,"_362":-5,"_363":25,"_364":25,"_365":25,"_366":-5},"ENV",{"_318":319,"_320":321,"_322":87,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346},"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

Finding your location…

Flyering Map

Diff · v152