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",[],[116,125],"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",[],[116,134],["D",1775771913209],[144,145,146],[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":171,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_89":172,"_18":173},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":150,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_89":151,"_18":152},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":147,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_89":148,"_18":149},["D",1783710021831],[],[19,38],["D",1775771914185],[153,154],[19,61],{"_36":164,"_13":165,"_39":166,"_41":62,"_43":44,"_45":63,"_47":48,"_49":167,"_17":65,"_52":24,"_54":168,"_56":57,"_58":-5,"_89":169,"_18":170},{"_36":155,"_13":156,"_39":157,"_41":62,"_43":44,"_45":158,"_47":48,"_49":159,"_17":65,"_52":160,"_54":161,"_56":57,"_58":-5,"_89":162,"_18":163},"4372818d-0af8-4643-b7d8-746843909ba6","names.ts","99d75ce0-7c91-11f1-8601-1607ee4eb77e",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",[],[19,61,156],"40fb457a-345f-11f1-b301-42b51c65c3df","areas.ts","40fb4638-345f-11f1-b301-42b51c65c3df",["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",[],[19,61,165],["D",1775771913209],[174,175,176],[19,69],{"_36":193,"_13":194,"_39":195,"_41":70,"_43":44,"_45":196,"_47":48,"_49":197,"_17":103,"_52":24,"_54":198,"_56":57,"_58":-5,"_89":199,"_18":200},{"_36":185,"_13":186,"_39":187,"_41":70,"_43":44,"_45":188,"_47":48,"_49":189,"_17":103,"_52":160,"_54":190,"_56":57,"_58":-5,"_89":191,"_18":192},{"_36":177,"_13":178,"_39":179,"_41":70,"_43":44,"_45":180,"_47":48,"_49":181,"_17":103,"_52":24,"_54":182,"_56":57,"_58":-5,"_89":183,"_18":184},"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",[],[19,69,178],"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",[],[19,69,186],"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",[],[19,69,194],"2cdcfe20-3609-11f1-9d85-42b51c65c3df",".claude","2cdcff06-3609-11f1-9d85-42b51c65c3df",51,["D",1775954846037],[208],[202],{"_36":209,"_13":210,"_39":211,"_41":203,"_43":44,"_45":212,"_47":48,"_49":213,"_17":65,"_52":24,"_54":214,"_56":57,"_58":-5,"_89":215,"_18":216},"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",[],[202,210],"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,"_270":266},"org",{"_11":12,"_264":-5,"_265":266,"_227":228,"_267":268,"_269":57},"branch",{"_17":188,"_13":16,"_36":44,"_256":217,"_257":-5,"_258":-5,"_259":-5,"_260":-5,"_261":-5,"_262":14,"_263":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJodnpTUVJvUVI5QjVxV1ZEYm5sZVJoRmd1SyIsImluaXRpYWxzIjoiTUcifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":217,"_13":14,"_49":360,"_219":-5,"_220":57,"_221":222,"_223":222,"_224":225,"_226":-5,"_227":228,"_229":40,"_230":48,"_231":-5,"_232":-5,"_233":65,"_234":235,"_236":-5,"_237":-5,"_238":-5,"_239":-5,"_240":241,"_242":241,"_243":244,"_245":244,"_246":244,"_247":241,"_248":241,"_249":361,"_251":362,"_253":363,"_255":57},[306,308,317,320,322,323],"files",[306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323],"counts",{"_297":65,"_298":103,"_299":65,"_32":300,"_301":302},[291,292,293],{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":71,"_47":48,"_49":75,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":290},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":72,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":296},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_18":295},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":294},[19,38],[19,61],[19,69],"pulls","branches","forks",{"_303":103,"_305":65},"connections",{"_303":65,"_304":65},"count","unfilledCount","emptyCount",{"_36":201,"_13":202,"_39":203,"_41":-5,"_43":44,"_45":204,"_47":48,"_49":205,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_89":358,"_18":359},{"_36":209,"_13":210,"_39":211,"_41":203,"_43":44,"_45":212,"_47":48,"_49":213,"_17":65,"_52":24,"_54":214,"_56":57,"_58":-5,"_89":356,"_18":357},{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":71,"_47":48,"_49":141,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_89":354,"_18":355},{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":171,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_89":352,"_18":353},{"_36":193,"_13":194,"_39":195,"_41":70,"_43":44,"_45":196,"_47":48,"_49":197,"_17":103,"_52":24,"_54":198,"_56":57,"_58":-5,"_89":350,"_18":351},{"_36":185,"_13":186,"_39":187,"_41":70,"_43":44,"_45":188,"_47":48,"_49":189,"_17":103,"_52":160,"_54":190,"_56":57,"_58":-5,"_89":348,"_18":349},{"_36":177,"_13":178,"_39":179,"_41":70,"_43":44,"_45":180,"_47":48,"_49":181,"_17":103,"_52":24,"_54":182,"_56":57,"_58":-5,"_89":346,"_18":347},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":150,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_89":344,"_18":345},{"_36":164,"_13":165,"_39":166,"_41":62,"_43":44,"_45":63,"_47":48,"_49":167,"_17":65,"_52":24,"_54":168,"_56":57,"_58":-5,"_89":342,"_18":343},{"_36":155,"_13":156,"_39":157,"_41":62,"_43":44,"_45":158,"_47":48,"_49":159,"_17":65,"_52":160,"_54":161,"_56":57,"_58":-5,"_89":340,"_18":341},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":147,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_89":338,"_18":339},{"_36":115,"_13":116,"_39":117,"_41":-5,"_43":44,"_45":118,"_47":48,"_49":119,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_89":336,"_18":337},{"_36":133,"_13":134,"_39":135,"_41":117,"_43":44,"_45":136,"_47":48,"_49":137,"_17":65,"_52":24,"_54":138,"_56":57,"_58":-5,"_89":334,"_18":335},{"_36":124,"_13":125,"_39":126,"_41":117,"_43":44,"_45":127,"_47":48,"_49":128,"_17":129,"_52":24,"_54":130,"_56":57,"_58":-5,"_89":332,"_18":333},{"_36":100,"_13":101,"_39":102,"_41":-5,"_43":44,"_45":103,"_47":48,"_49":104,"_17":65,"_52":66,"_54":-5,"_56":57,"_58":-5,"_89":330,"_18":331},{"_36":108,"_13":109,"_39":110,"_41":102,"_43":44,"_45":103,"_47":48,"_49":111,"_17":65,"_52":24,"_54":112,"_56":57,"_58":-5,"_89":328,"_18":329},{"_36":92,"_13":93,"_39":94,"_41":-5,"_43":44,"_45":95,"_47":48,"_49":96,"_17":71,"_52":24,"_54":97,"_56":57,"_58":-5,"_89":326,"_18":327},{"_36":83,"_13":84,"_39":85,"_41":-5,"_43":44,"_45":86,"_47":48,"_49":87,"_17":65,"_52":24,"_54":88,"_56":57,"_58":-5,"_89":324,"_18":325},[],[84],[],[93],[],[101,109],[321],[101],[],[116,125],[],[116,134],[318,319],[116],[],[19,38],[],[19,61,156],[],[19,61,165],[314,315],[19,61],[],[19,69,178],[],[19,69,186],[],[19,69,194],[310,311,312],[19,69],[309,313,316],[19],[],[202,210],[307],[202],["D",1775771861289],{"_11":12,"_270":266},{"_11":12,"_264":-5,"_265":266,"_227":228,"_267":268,"_269":57},{"_17":188,"_13":16,"_36":44,"_256":217,"_257":-5,"_258":-5,"_259":-5,"_260":-5,"_261":-5,"_262":14,"_263":12},"ctx",{"_249":-5,"_287":397,"_398":399,"_400":401,"_402":57,"_403":57,"_404":57,"_405":48,"_406":-5,"_407":-7,"_408":-7,"_409":65,"_410":57,"_411":57,"_412":-5,"_413":57,"_414":57,"_415":57,"_416":-5},"ENV",{"_368":369,"_370":371,"_372":16,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396},"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