Flyering Map

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_245":246,"_247":248},"routes/_app.x.$handle.$name",{"_102":101,"_38":51,"_110":92,"_33":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_26":-5,"_122":-5,"_123":-5,"_124":31,"_125":126,"_127":64,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":31},"version",7,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","c5b147c5-4376-4e23-b98a-1343d810e4e7","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":43,"_41":42,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":39,"_40":26,"_41":42},"deleted",false,"deletedHere","path","backend/index.ts","latestPath","fileId","41415df8-345f-11f1-aca4-42b51c65c3df","name","index.ts","fileType","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 return c.html(html);\n});\n\nexport default app.fetch;\n","http","createdAt",["D",1775772431600],"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",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_19":61,"_106":107,"_108":31},"branch",{"_13":91,"_38":92,"_49":48,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"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",{"_49":50,"_38":51,"_44":241,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":242,"_86":243,"_88":244,"_90":31},"tree",[167,174,176],"files",[167,168,169,170,171,172,173,174,175,176,177],"counts",{"_157":68,"_158":139,"_159":68,"_160":161,"_162":163},"contents",[132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":151,"_38":152,"_36":153,"_138":-5,"_47":48,"_46":154,"_140":64,"_44":155,"_13":68,"_40":142,"_41":-5,"_30":31,"_143":-5,"_33":156},{"_49":145,"_38":146,"_36":147,"_138":-5,"_47":48,"_46":148,"_140":64,"_44":149,"_13":68,"_40":142,"_41":-5,"_30":31,"_143":-5,"_33":150},{"_49":135,"_38":136,"_36":137,"_138":-5,"_47":48,"_46":139,"_140":64,"_44":141,"_13":68,"_40":142,"_41":-5,"_30":31,"_143":-5,"_33":144},"3c4633d2-345f-11f1-a723-42b51c65c3df","shared","1cb08f9c-5556-40ad-90a4-cf9fb96068d6","parentId",1,"latest",["D",1775771906287],"directory","label",[136],"41852cc2-345f-11f1-be74-42b51c65c3df","frontend","d89eb0e6-4fa7-4142-b085-b782e9e01eb3",6,["D",1775771915084],[146],"40668c1e-345f-11f1-b0f6-42b51c65c3df","backend","8a8fec3e-9dd4-4c3a-8598-7c75407d063c",2,["D",1775771913209],[152],"pulls","branches","forks","envVars",{"_164":139,"_166":68},"connections",{"_164":68,"_165":68},"count","unfilledCount","emptyCount",{"_49":151,"_38":152,"_36":153,"_138":-5,"_47":48,"_46":154,"_140":64,"_44":238,"_13":68,"_40":142,"_41":-5,"_30":31,"_143":-5,"_183":239,"_33":240},{"_49":234,"_38":226,"_36":220,"_138":153,"_47":48,"_46":154,"_140":64,"_44":235,"_13":68,"_40":142,"_41":-5,"_30":31,"_143":-5,"_183":236,"_33":237},{"_49":227,"_38":228,"_36":229,"_138":220,"_47":48,"_46":154,"_140":31,"_44":230,"_13":68,"_40":26,"_41":231,"_30":31,"_143":-5,"_183":232,"_33":233},{"_49":217,"_38":218,"_36":219,"_138":220,"_47":48,"_46":221,"_140":31,"_44":222,"_13":68,"_40":26,"_41":223,"_30":31,"_143":-5,"_183":224,"_33":225},{"_49":213,"_38":212,"_36":206,"_138":153,"_47":48,"_46":207,"_140":64,"_44":214,"_13":68,"_40":142,"_41":-5,"_30":31,"_143":-5,"_183":215,"_33":216},{"_49":203,"_38":204,"_36":205,"_138":206,"_47":48,"_46":207,"_140":64,"_44":208,"_13":68,"_40":26,"_41":209,"_30":31,"_143":-5,"_183":210,"_33":211},{"_49":199,"_38":39,"_36":37,"_138":153,"_47":48,"_46":14,"_140":31,"_44":200,"_13":139,"_40":43,"_41":42,"_30":31,"_143":-5,"_183":201,"_33":202},{"_49":145,"_38":146,"_36":147,"_138":-5,"_47":48,"_46":148,"_140":64,"_44":196,"_13":68,"_40":142,"_41":-5,"_30":31,"_143":-5,"_183":197,"_33":198},{"_49":189,"_38":190,"_36":191,"_138":147,"_47":48,"_46":148,"_140":31,"_44":192,"_13":68,"_40":26,"_41":193,"_30":31,"_143":-5,"_183":194,"_33":195},{"_49":135,"_38":136,"_36":137,"_138":-5,"_47":48,"_46":139,"_140":64,"_44":186,"_13":68,"_40":142,"_41":-5,"_30":31,"_143":-5,"_183":187,"_33":188},{"_49":178,"_38":179,"_36":180,"_138":137,"_47":48,"_46":139,"_140":64,"_44":181,"_13":68,"_40":26,"_41":182,"_30":31,"_143":-5,"_183":184,"_33":185},"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","children",[],[136,179],["D",1775771906287],[177],[136],"4184b97c-345f-11f1-be74-42b51c65c3df","index.html","4184ba58-345f-11f1-be74-42b51c65c3df",["D",1775771915084],"\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\n\n",[],[146,190],["D",1775771915084],[175],[146],"7563be22-3460-11f1-bf6e-42b51c65c3df",["D",1775772431600],[],[152,39],"40fb457a-345f-11f1-b301-42b51c65c3df","areas.ts","40fb4638-345f-11f1-b301-42b51c65c3df","d5b44a31-e9f9-4380-8aea-e1115adbbac1",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",[],[152,212,204],"routes","40fb6802-345f-11f1-b301-42b51c65c3df",["D",1775771914185],[172],[152,212],"40af9f58-345f-11f1-8d06-42b51c65c3df","queries.ts","40afa034-345f-11f1-8d06-42b51c65c3df","3cfd4d51-4a25-43e0-8a26-72e42656c75c",3,["D",1775771913691],"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(`SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC`);\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",[],[152,226,218],"database","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",[],[152,226,228],"40669042-345f-11f1-b0f6-42b51c65c3df",["D",1775771913209],[169,170],[152,226],["D",1775771913209],[168,171,173],[152],["D",1775771861289],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_19":61,"_106":107,"_108":31},{"_13":91,"_38":92,"_49":48,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":278,"_279":280,"_281":282,"_283":31,"_284":31,"_285":31,"_286":64,"_287":-5,"_288":-7,"_289":-7,"_290":68,"_291":31,"_292":31,"_293":-5,"_294":31,"_295":31,"_296":31,"_297":-5},"ENV",{"_249":250,"_251":252,"_253":92,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277},"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"]

📜 Flyering Map

Name this area

Flyered Areas

Diff · v7