Flyering Map

\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",[],[113,122],"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",[],[113,131],"40668c1e-345f-11f1-b0f6-42b51c65c3df",["D",1775771913209],[142,143,144],[59],{"_35":166,"_13":167,"_38":168,"_40":69,"_42":43,"_44":93,"_46":47,"_48":169,"_17":50,"_51":71,"_53":-5,"_55":56,"_57":-5,"_85":170,"_18":171},{"_35":68,"_13":60,"_38":41,"_40":69,"_42":43,"_44":64,"_46":47,"_48":155,"_17":50,"_51":71,"_53":-5,"_55":56,"_57":-5,"_85":156,"_18":157},{"_35":145,"_13":146,"_38":147,"_40":69,"_42":43,"_44":148,"_46":47,"_48":149,"_17":150,"_51":151,"_53":152,"_55":56,"_57":-5,"_85":153,"_18":154},"15f4247f-7db3-4c7f-af3f-0482943a8208","index.ts","41415df8-345f-11f1-aca4-42b51c65c3df",153,["D",1783710021831],3,"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 { 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",[],[59,146],["D",1775771914185],[158,159],[59,60],{"_35":61,"_13":62,"_38":63,"_40":41,"_42":43,"_44":64,"_46":47,"_48":163,"_17":50,"_51":24,"_53":66,"_55":56,"_57":-5,"_85":164,"_18":165},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":160,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_85":161,"_18":162},["D",1783710021819],[],[59,60,37],["D",1775771914185],[],[59,60,62],"40669042-345f-11f1-b0f6-42b51c65c3df","database","3cfd4d51-4a25-43e0-8a26-72e42656c75c",["D",1775771913209],[172,173,174],[59,167],{"_35":191,"_13":192,"_38":193,"_40":168,"_42":43,"_44":194,"_46":47,"_48":195,"_17":100,"_51":24,"_53":196,"_55":56,"_57":-5,"_85":197,"_18":198},{"_35":183,"_13":184,"_38":185,"_40":168,"_42":43,"_44":186,"_46":47,"_48":187,"_17":100,"_51":52,"_53":188,"_55":56,"_57":-5,"_85":189,"_18":190},{"_35":175,"_13":176,"_38":177,"_40":168,"_42":43,"_44":178,"_46":47,"_48":179,"_17":100,"_51":24,"_53":180,"_55":56,"_57":-5,"_85":181,"_18":182},"2257799c-3769-11f1-ae77-42b51c65c3df","queries.ts","40afa034-345f-11f1-8d06-42b51c65c3df",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",[],[59,167,176],"629e43de-e91f-460a-b026-aa2b0072d785","namesQueries.ts","99ddcd5a-7c91-11f1-bc2d-1607ee4eb77e",155,["D",1783710443531],"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 = 24 * 60 * 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",[],[59,167,184],"0082d58a-6aa5-46bd-97fb-0c0c03b765e4","migrations.ts","406666bc-345f-11f1-b0f6-42b51c65c3df",154,["D",1783710022026],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite/main.tsx\";\n\nconst TABLE_NAME = \"flyermap_areas_1\";\nconst NAMES_TABLE_NAME = \"flyermap_names_1\";\nconst NAMES_SYNC_META_TABLE_NAME = \"flyermap_names_sync_meta_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 await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${NAMES_TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL UNIQUE,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Single-row table tracking when the names list was last pulled from the sheet\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${NAMES_SYNC_META_TABLE_NAME} (\n id INTEGER PRIMARY KEY CHECK (id = 1),\n synced_at DATETIME NOT NULL\n )`);\n}\n\nexport { TABLE_NAME, NAMES_TABLE_NAME, NAMES_SYNC_META_TABLE_NAME };\n",[],[59,167,192],"2cdcfe20-3609-11f1-9d85-42b51c65c3df",".claude","2cdcff06-3609-11f1-9d85-42b51c65c3df",51,["D",1775954846037],[206],[200],{"_35":207,"_13":208,"_38":209,"_40":201,"_42":43,"_44":210,"_46":47,"_48":211,"_17":50,"_51":24,"_53":212,"_55":56,"_57":-5,"_85":213,"_18":214},"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",[],[200,208],"2173f47c-345f-11f1-967e-42b51c65c3df",["D",1775771861289],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Track where flyers have been placed on a map","imageUrl","userId","9c30ae6f-cb96-4a42-8870-9ee54e43392d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","e57d2528-cd45-49b9-ae4b-fcfd7aaee32e","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_268":264},"org",{"_11":12,"_262":-5,"_263":264,"_225":226,"_265":266,"_267":56},"branch",{"_17":186,"_13":16,"_35":43,"_254":215,"_255":-5,"_256":-5,"_257":-5,"_258":-5,"_259":-5,"_260":14,"_261":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJodnpTUVJvUVI5QjVxV1ZEYm5sZVJoRmd1SyIsImluaXRpYWxzIjoiTUcifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":215,"_13":14,"_48":356,"_217":-5,"_218":56,"_219":220,"_221":220,"_222":223,"_224":-5,"_225":226,"_227":147,"_228":47,"_229":-5,"_230":-5,"_231":50,"_232":233,"_234":-5,"_235":-5,"_236":-5,"_237":-5,"_238":239,"_240":239,"_241":242,"_243":242,"_244":242,"_245":239,"_246":239,"_247":357,"_249":358,"_251":359,"_253":56},[302,304,313,316,318,319],"files",[302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319],"counts",{"_293":50,"_294":100,"_295":50,"_32":296,"_297":298},[289,290],{"_35":68,"_13":60,"_38":41,"_40":69,"_42":43,"_44":64,"_46":47,"_48":70,"_17":50,"_51":71,"_53":-5,"_55":56,"_57":-5,"_18":288},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[59,60],{"_35":61,"_13":62,"_38":63,"_40":41,"_42":43,"_44":64,"_46":47,"_48":65,"_17":50,"_51":24,"_53":66,"_55":56,"_57":-5,"_18":292},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":291},[59,60,37],[59,60,62],"pulls","branches","forks",{"_299":100,"_301":50},"connections",{"_299":50,"_300":50},"count","unfilledCount","emptyCount",{"_35":199,"_13":200,"_38":201,"_40":-5,"_42":43,"_44":202,"_46":47,"_48":203,"_17":50,"_51":71,"_53":-5,"_55":56,"_57":-5,"_85":354,"_18":355},{"_35":207,"_13":208,"_38":209,"_40":201,"_42":43,"_44":210,"_46":47,"_48":211,"_17":50,"_51":24,"_53":212,"_55":56,"_57":-5,"_85":352,"_18":353},{"_35":138,"_13":59,"_38":69,"_40":-5,"_42":43,"_44":93,"_46":47,"_48":139,"_17":50,"_51":71,"_53":-5,"_55":56,"_57":-5,"_85":350,"_18":351},{"_35":166,"_13":167,"_38":168,"_40":69,"_42":43,"_44":93,"_46":47,"_48":169,"_17":50,"_51":71,"_53":-5,"_55":56,"_57":-5,"_85":348,"_18":349},{"_35":191,"_13":192,"_38":193,"_40":168,"_42":43,"_44":194,"_46":47,"_48":195,"_17":100,"_51":24,"_53":196,"_55":56,"_57":-5,"_85":346,"_18":347},{"_35":183,"_13":184,"_38":185,"_40":168,"_42":43,"_44":186,"_46":47,"_48":187,"_17":100,"_51":52,"_53":188,"_55":56,"_57":-5,"_85":344,"_18":345},{"_35":175,"_13":176,"_38":177,"_40":168,"_42":43,"_44":178,"_46":47,"_48":179,"_17":100,"_51":24,"_53":180,"_55":56,"_57":-5,"_85":342,"_18":343},{"_35":68,"_13":60,"_38":41,"_40":69,"_42":43,"_44":64,"_46":47,"_48":155,"_17":50,"_51":71,"_53":-5,"_55":56,"_57":-5,"_85":340,"_18":341},{"_35":61,"_13":62,"_38":63,"_40":41,"_42":43,"_44":64,"_46":47,"_48":163,"_17":50,"_51":24,"_53":66,"_55":56,"_57":-5,"_85":338,"_18":339},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":160,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_85":336,"_18":337},{"_35":145,"_13":146,"_38":147,"_40":69,"_42":43,"_44":148,"_46":47,"_48":149,"_17":150,"_51":151,"_53":152,"_55":56,"_57":-5,"_85":334,"_18":335},{"_35":112,"_13":113,"_38":114,"_40":-5,"_42":43,"_44":115,"_46":47,"_48":116,"_17":50,"_51":71,"_53":-5,"_55":56,"_57":-5,"_85":332,"_18":333},{"_35":130,"_13":131,"_38":132,"_40":114,"_42":43,"_44":133,"_46":47,"_48":134,"_17":50,"_51":24,"_53":135,"_55":56,"_57":-5,"_85":330,"_18":331},{"_35":121,"_13":122,"_38":123,"_40":114,"_42":43,"_44":124,"_46":47,"_48":125,"_17":126,"_51":24,"_53":127,"_55":56,"_57":-5,"_85":328,"_18":329},{"_35":97,"_13":98,"_38":99,"_40":-5,"_42":43,"_44":100,"_46":47,"_48":101,"_17":50,"_51":71,"_53":-5,"_55":56,"_57":-5,"_85":326,"_18":327},{"_35":105,"_13":106,"_38":107,"_40":99,"_42":43,"_44":100,"_46":47,"_48":108,"_17":50,"_51":24,"_53":109,"_55":56,"_57":-5,"_85":324,"_18":325},{"_35":88,"_13":89,"_38":90,"_40":-5,"_42":43,"_44":91,"_46":47,"_48":92,"_17":93,"_51":24,"_53":94,"_55":56,"_57":-5,"_85":322,"_18":323},{"_35":79,"_13":80,"_38":81,"_40":-5,"_42":43,"_44":82,"_46":47,"_48":83,"_17":50,"_51":24,"_53":84,"_55":56,"_57":-5,"_85":320,"_18":321},[],[80],[],[89],[],[98,106],[317],[98],[],[113,122],[],[113,131],[314,315],[113],[],[59,146],[],[59,60,37],[],[59,60,62],[310,311],[59,60],[],[59,167,176],[],[59,167,184],[],[59,167,192],[306,307,308],[59,167],[305,309,312],[59],[],[200,208],[303],[200],["D",1775771861289],{"_11":12,"_268":264},{"_11":12,"_262":-5,"_263":264,"_225":226,"_265":266,"_267":56},{"_17":186,"_13":16,"_35":43,"_254":215,"_255":-5,"_256":-5,"_257":-5,"_258":-5,"_259":-5,"_260":14,"_261":12},"ctx",{"_247":-5,"_285":393,"_394":395,"_396":397,"_398":56,"_399":56,"_400":56,"_401":47,"_402":-5,"_403":-7,"_404":-7,"_405":50,"_406":56,"_407":56,"_408":-5,"_409":56,"_410":56,"_411":56,"_412":-5},"ENV",{"_364":365,"_366":367,"_368":16,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392},"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