Flyering Map

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_312":313,"_314":315},"routes/_app.x.$handle.$name",{"_96":95,"_31":44,"_104":86,"_26":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",151,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/database/namesQueries.ts","latestPath","fileId","99ddcd5a-7c91-11f1-bc2d-1607ee4eb77e","name","namesQueries.ts","fileType","script","content","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","createdAt",["D",1783710021843],"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",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},"branch",{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"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",{"_42":43,"_31":44,"_37":308,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":309,"_80":310,"_82":311,"_84":24},"tree",[184,186,195,198,200,201],"files",[184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201],"counts",{"_174":62,"_175":153,"_176":62,"_177":178,"_179":180},"contents",[126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":168,"_31":169,"_29":170,"_135":-5,"_40":41,"_39":171,"_137":58,"_37":172,"_13":62,"_33":155,"_35":-5,"_23":24,"_140":-5,"_26":173},{"_42":163,"_31":164,"_29":165,"_135":-5,"_40":41,"_39":147,"_137":58,"_37":166,"_13":62,"_33":155,"_35":-5,"_23":24,"_140":-5,"_26":167},{"_42":157,"_31":158,"_29":159,"_135":-5,"_40":41,"_39":160,"_137":58,"_37":161,"_13":62,"_33":155,"_35":-5,"_23":24,"_140":-5,"_26":162},{"_42":150,"_31":151,"_29":152,"_135":-5,"_40":41,"_39":153,"_137":58,"_37":154,"_13":62,"_33":155,"_35":-5,"_23":24,"_140":-5,"_26":156},{"_42":142,"_31":143,"_29":144,"_135":-5,"_40":41,"_39":145,"_137":58,"_37":146,"_13":147,"_33":20,"_35":148,"_23":24,"_140":-5,"_26":149},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":58,"_37":138,"_13":62,"_33":20,"_35":139,"_23":24,"_140":-5,"_26":141},"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",[133],"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",[143],"3c4633d2-345f-11f1-a723-42b51c65c3df","shared","1cb08f9c-5556-40ad-90a4-cf9fb96068d6",1,["D",1775771906287],"directory",[151],"41852cc2-345f-11f1-be74-42b51c65c3df","frontend","d89eb0e6-4fa7-4142-b085-b782e9e01eb3",6,["D",1775771915084],[158],"40668c1e-345f-11f1-b0f6-42b51c65c3df","backend","8a8fec3e-9dd4-4c3a-8598-7c75407d063c",["D",1775771913209],[164],"2cdcfe20-3609-11f1-9d85-42b51c65c3df",".claude","2cdcff06-3609-11f1-9d85-42b51c65c3df",51,["D",1775954846037],[169],"pulls","branches","forks","envVars",{"_181":153,"_183":62},"connections",{"_181":62,"_182":62},"count","unfilledCount","emptyCount",{"_42":168,"_31":169,"_29":170,"_135":-5,"_40":41,"_39":171,"_137":58,"_37":305,"_13":62,"_33":155,"_35":-5,"_23":24,"_140":-5,"_203":306,"_26":307},{"_42":297,"_31":298,"_29":299,"_135":170,"_40":41,"_39":300,"_137":58,"_37":301,"_13":62,"_33":20,"_35":302,"_23":24,"_140":-5,"_203":303,"_26":304},{"_42":163,"_31":164,"_29":165,"_135":-5,"_40":41,"_39":147,"_137":58,"_37":294,"_13":62,"_33":155,"_35":-5,"_23":24,"_140":-5,"_203":295,"_26":296},{"_42":290,"_31":278,"_29":272,"_135":165,"_40":41,"_39":147,"_137":58,"_37":291,"_13":62,"_33":155,"_35":-5,"_23":24,"_140":-5,"_203":292,"_26":293},{"_42":283,"_31":284,"_29":285,"_135":272,"_40":41,"_39":147,"_137":24,"_37":286,"_13":62,"_33":20,"_35":287,"_23":24,"_140":-5,"_203":288,"_26":289},{"_42":279,"_31":32,"_29":30,"_135":272,"_40":41,"_39":14,"_137":24,"_37":280,"_13":62,"_33":34,"_35":36,"_23":24,"_140":-5,"_203":281,"_26":282},{"_42":269,"_31":270,"_29":271,"_135":272,"_40":41,"_39":273,"_137":58,"_37":274,"_13":153,"_33":20,"_35":275,"_23":24,"_140":-5,"_203":276,"_26":277},{"_42":265,"_31":256,"_29":250,"_135":165,"_40":41,"_39":260,"_137":58,"_37":266,"_13":62,"_33":155,"_35":-5,"_23":24,"_140":-5,"_203":267,"_26":268},{"_42":257,"_31":258,"_29":259,"_135":250,"_40":41,"_39":260,"_137":58,"_37":261,"_13":62,"_33":20,"_35":262,"_23":24,"_140":-5,"_203":263,"_26":264},{"_42":247,"_31":248,"_29":249,"_135":250,"_40":41,"_39":251,"_137":58,"_37":252,"_13":62,"_33":34,"_35":253,"_23":24,"_140":-5,"_203":254,"_26":255},{"_42":239,"_31":240,"_29":56,"_135":165,"_40":41,"_39":241,"_137":24,"_37":242,"_13":147,"_33":243,"_35":244,"_23":24,"_140":-5,"_203":245,"_26":246},{"_42":157,"_31":158,"_29":159,"_135":-5,"_40":41,"_39":160,"_137":58,"_37":236,"_13":62,"_33":155,"_35":-5,"_23":24,"_140":-5,"_203":237,"_26":238},{"_42":228,"_31":229,"_29":230,"_135":159,"_40":41,"_39":231,"_137":58,"_37":232,"_13":62,"_33":20,"_35":233,"_23":24,"_140":-5,"_203":234,"_26":235},{"_42":219,"_31":220,"_29":221,"_135":159,"_40":41,"_39":222,"_137":24,"_37":223,"_13":224,"_33":20,"_35":225,"_23":24,"_140":-5,"_203":226,"_26":227},{"_42":150,"_31":151,"_29":152,"_135":-5,"_40":41,"_39":153,"_137":58,"_37":216,"_13":62,"_33":155,"_35":-5,"_23":24,"_140":-5,"_203":217,"_26":218},{"_42":209,"_31":210,"_29":211,"_135":152,"_40":41,"_39":153,"_137":58,"_37":212,"_13":62,"_33":20,"_35":213,"_23":24,"_140":-5,"_203":214,"_26":215},{"_42":142,"_31":143,"_29":144,"_135":-5,"_40":41,"_39":145,"_137":58,"_37":206,"_13":147,"_33":20,"_35":148,"_23":24,"_140":-5,"_203":207,"_26":208},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":58,"_37":202,"_13":62,"_33":20,"_35":139,"_23":24,"_140":-5,"_203":204,"_26":205},["D",1775957679628],"children",[],[133],["D",1775957683174],[],[143],"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",[],[151,210],["D",1775771906287],[199],[151],"c1b43cc2-377e-11f1-9131-42b51c65c3df","index.html","4184ba58-345f-11f1-be74-42b51c65c3df",149,["D",1776115298018],133,"\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",[],[158,220],"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",[],[158,229],["D",1775771915084],[196,197],[158],"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",[],[164,240],"4372818d-0af8-4643-b7d8-746843909ba6","names.ts","99d75ce0-7c91-11f1-8601-1607ee4eb77e","d5b44a31-e9f9-4380-8aea-e1115adbbac1",150,["D",1783710021819],"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",[],[164,256,248],"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",[],[164,256,258],"40fb6802-345f-11f1-b301-42b51c65c3df",["D",1775771914185],[192,193],[164,256],"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",[],[164,278,270],"database","b8451400-57c3-46fc-91f1-e682cbd6a4b2",["D",1783710021843],[],[164,278,32],"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",[],[164,278,284],"40669042-345f-11f1-b0f6-42b51c65c3df",["D",1775771913209],[188,189,190],[164,278],["D",1775771913209],[187,191,194],[164],"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",[],[169,298],["D",1775954846037],[185],[169],["D",1775771861289],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_123":345,"_346":347,"_348":349,"_350":24,"_351":24,"_352":24,"_353":58,"_354":-5,"_355":-7,"_356":-7,"_357":62,"_358":24,"_359":24,"_360":-5,"_361":24,"_362":24,"_363":24,"_364":-5},"ENV",{"_316":317,"_318":319,"_320":86,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344},"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 · v151