[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_156":157,"_158":159},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_118":-5,"_20":119,"_22":120,"_121":122,"_123":124,"_25":125,"_24":-5,"_126":-5,"_127":-5,"_128":53,"_129":130,"_131":44,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","chriswmartin","name","untitled-1472","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":85,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":97,"_98":99,"_100":101,"_102":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","f0eaefb2-11be-11f1-83c1-42dde27851f2","main.ts","fileId","46be5816-11b0-11f1-bf9c-42dde27851f2","parentId","branchId","46bc4512-11b0-11f1-bf9c-42dde27851f2","branchVersion",20,"latest",true,"createdAt",["D",1771964720829],19,"fileType","http","content","/**\n * Visitor Map — Val.Town HTTP Val\n *\n * Single-file deployment for Val.Town. Serves the interactive map frontend\n * and handles the /api/pins REST endpoint, backed by Val.Town SQLite.\n *\n * Optional env vars:\n * GEONAMES_USERNAME — your GeoNames account username. Improves geocoding\n * accuracy for Ireland and Canada. Falls back to\n * Nominatim if unset.\n * ADMIN_SECRET — password for the /admin panel (required to use admin)\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ---------------------------------------------------------------------------\n// Database setup\n// ---------------------------------------------------------------------------\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS pins (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n lat REAL NOT NULL,\n lon REAL NOT NULL,\n country_code TEXT NOT NULL,\n postal_code TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n`);\n\n// ---------------------------------------------------------------------------\n// Geocoding\n// ---------------------------------------------------------------------------\n\nasync function nominatimSearch(params: Record): Promise {\n const url = new URL(\"https://nominatim.openstreetmap.org/search\");\n for (const [k, v] of Object.entries(params)) url.searchParams.set(k, v);\n const resp = await fetch(url.toString(), {\n headers: { \"User-Agent\": \"ValTownMapExhibit/1.0\" },\n });\n if (!resp.ok) return [];\n return resp.json();\n}\n\nasync function geocodeGeoNames(\n postalCode: string,\n countryCode: string,\n): Promise<[number, number] | null> {\n const username = Deno.env.get(\"GEONAMES_USERNAME\") ?? \"chriswm\";\n const url = `https://secure.geonames.org/postalCodeSearchJSON` +\n `?postalcode=${encodeURIComponent(postalCode)}` +\n `&country=${encodeURIComponent(countryCode)}` +\n `&maxRows=1&username=${encodeURIComponent(username)}`;\n try {\n const resp = await fetch(url);\n if (!resp.ok) return null;\n const data = await resp.json();\n if (data.postalCodes?.length > 0) {\n const { lat, lng } = data.postalCodes[0];\n return [Number(lat), Number(lng)];\n }\n } catch {\n // fall through\n }\n return null;\n}\n\n// Countries where only the leading N characters of the postal code are\n// meaningful for geocoding (matching the local-server GeoNames cache logic).\nconst PREFIX_LENGTHS: Record = { IE: 3, CA: 3 };\n\n// Per-country postal code validation patterns.\n// Countries not listed fall back to DEFAULT_POSTAL_RE (min 3 alphanumeric chars).\nconst POSTAL_PATTERNS: Record = {\n US: /^\\d{5}(-\\d{4})?$/,\n CA: /^[A-Z]\\d[A-Z](\\s?\\d[A-Z]\\d)?$/i,\n GB: /^[A-Z]{1,2}\\d{1,2}[A-Z]?\\s*\\d[A-Z]{2}$/i,\n IE: /^[A-Z]\\d{2}(\\s?[A-Z0-9]{4})?$/i,\n AU: /^\\d{4}$/,\n NZ: /^\\d{4}$/,\n DE: /^\\d{5}$/,\n AT: /^\\d{4}$/,\n CH: /^\\d{4}$/,\n FR: /^\\d{5}$/,\n BE: /^\\d{4}$/,\n NL: /^\\d{4}\\s?[A-Z]{2}$/i,\n IT: /^\\d{5}$/,\n ES: /^\\d{5}$/,\n PT: /^\\d{4}(-\\d{3})?$/,\n SE: /^\\d{3}\\s?\\d{2}$/,\n NO: /^\\d{4}$/,\n DK: /^\\d{4}$/,\n FI: /^\\d{5}$/,\n PL: /^\\d{2}-\\d{3}$/,\n RU: /^\\d{6}$/,\n JP: /^\\d{3}-?\\d{4}$/,\n CN: /^\\d{6}$/,\n IN: /^\\d{6}$/,\n BR: /^\\d{5}-?\\d{3}$/,\n MX: /^\\d{5}$/,\n ZA: /^\\d{4}$/,\n SG: /^\\d{6}$/,\n KR: /^\\d{5}$/,\n};\nconst DEFAULT_POSTAL_RE = /^[A-Z0-9][A-Z0-9 \\-]{2,}$/i;\n\nfunction isValidPostalCode(postalCode: string, countryCode: string): boolean {\n const pattern = POSTAL_PATTERNS[countryCode] ?? DEFAULT_POSTAL_RE;\n return pattern.test(postalCode.trim());\n}\n\nasync function geocode(\n postalCode: string,\n countryCode: string,\n): Promise<[number, number] | null> {\n // For IE and CA, truncate to the routing prefix before any lookup.\n if (countryCode in PREFIX_LENGTHS) {\n const prefix = postalCode.replace(/\\s+/g, \"\").toUpperCase()\n .substring(0, PREFIX_LENGTHS[countryCode]);\n\n // GeoNames is most reliable for these countries.\n const result = await geocodeGeoNames(prefix, countryCode);\n if (result) return result;\n\n // Nominatim fallback with the truncated prefix.\n const data = await nominatimSearch({\n postalcode: prefix,\n countrycodes: countryCode,\n format: \"json\",\n limit: \"1\",\n });\n if (data.length > 0) {\n const lat = parseFloat(data[0].lat);\n const lon = parseFloat(data[0].lon);\n if (Number.isFinite(lat) && Number.isFinite(lon)) return [lat, lon];\n }\n\n return null;\n }\n\n // All other countries: structured Nominatim postal code search only.\n // (No free-text fallback — it matches place names, not postal codes.)\n const data = await nominatimSearch({\n postalcode: postalCode,\n countrycodes: countryCode,\n format: \"json\",\n limit: \"1\",\n });\n if (data.length > 0) {\n const lat = parseFloat(data[0].lat);\n const lon = parseFloat(data[0].lon);\n if (Number.isFinite(lat) && Number.isFinite(lon)) return [lat, lon];\n }\n\n return null;\n}\n\n// ---------------------------------------------------------------------------\n// Frontend HTML (all CSS and JS inlined)\n// ---------------------------------------------------------------------------\n\nfunction getHTML(): string {\n return `\n\n\n \n \n Visitor Map\n \n \n \n \n\n\n

Visitors from 0 countries

Furthest visitor: —

\n \n\n \n\n \n \n \n\n`;\n}\n\n// ---------------------------------------------------------------------------\n// Admin helpers\n// ---------------------------------------------------------------------------\n\nfunction escHtml(s: string): string {\n return String(s)\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\");\n}\n\nfunction getLoginHTML(showError: boolean): string {\n return `\n\n\n \n \n Admin Login — Visitor Map\n \n\n\n

Admin Login

\n ${showError ? '

Incorrect password. Try again.

' : \"\"}\n \n

\n\n`;\n}\n\ntype PinRow = {\n id: number;\n lat: number;\n lon: number;\n country_code: string;\n postal_code: string;\n created_at: string;\n};\n\nfunction getAdminHTML(secret: string, pins: PinRow[]): string {\n const rows = pins.map((p) => `\n \n ${p.id}\n ${escHtml(p.country_code)}\n ${escHtml(p.postal_code)}\n ${Number(p.lat).toFixed(4)}\n ${Number(p.lon).toFixed(4)}\n ${escHtml(String(p.created_at ?? \"\"))}\n \n `).join(\"\");\n\n return `\n\n\n \n \n Admin — Visitor Map\n \n\n\n

Admin — Visitor Map

\n ← Back to map\n

${pins.length} pin${\n pins.length !== 1 ? \"s\" : \"\"\n }

\n \n \n \n \n \n \n \n ${rows || ''}\n \n

ID	Country	Postal Code	Lat	Lon	Added
No pins yet.

\n \n\n`;\n}\n\n// ---------------------------------------------------------------------------\n// Request handler\n// ---------------------------------------------------------------------------\n\nconst JSON_HEADERS = { \"Content-Type\": \"application/json\" };\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n\n // Admin page\n if (path === \"/admin\") {\n const adminSecret = Deno.env.get(\"ADMIN_SECRET\") ?? \"\";\n if (!adminSecret) {\n return new Response(\n \"ADMIN_SECRET environment variable is not configured.\",\n {\n status: 500,\n headers: { \"Content-Type\": \"text/plain\" },\n },\n );\n }\n const provided = url.searchParams.get(\"secret\") ?? \"\";\n if (provided !== adminSecret) {\n const showError = url.searchParams.has(\"secret\");\n return new Response(getLoginHTML(showError), {\n status: showError ? 401 : 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n const result = await sqlite.execute(\n \"SELECT id, lat, lon, country_code, postal_code, created_at FROM pins ORDER BY id DESC\",\n );\n const pins: PinRow[] = result.rows.map(\n ([id, lat, lon, country_code, postal_code, created_at]) => ({\n id: Number(id),\n lat: Number(lat),\n lon: Number(lon),\n country_code: String(country_code),\n postal_code: String(postal_code),\n created_at: String(created_at ?? \"\"),\n }),\n );\n return new Response(getAdminHTML(adminSecret, pins), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n // DELETE /api/pins/:id — admin only\n const deleteMatch = path.match(/^\\/api\\/pins\\/(\\d+)$/);\n if (deleteMatch && req.method === \"DELETE\") {\n const adminSecret = Deno.env.get(\"ADMIN_SECRET\") ?? \"\";\n const provided = url.searchParams.get(\"secret\") ?? \"\";\n if (!adminSecret || provided !== adminSecret) {\n return new Response(JSON.stringify({ error: \"Unauthorized\" }), {\n status: 401,\n headers: JSON_HEADERS,\n });\n }\n const id = parseInt(deleteMatch[1], 10);\n await sqlite.execute({ sql: \"DELETE FROM pins WHERE id = ?\", args: [id] });\n return new Response(JSON.stringify({ ok: true }), {\n headers: JSON_HEADERS,\n });\n }\n\n if (path === \"/api/pins\") {\n // GET /api/pins — return all stored pins\n if (req.method === \"GET\") {\n const result = await sqlite.execute(\n \"SELECT id, lat, lon, country_code, postal_code FROM pins ORDER BY id\",\n );\n const pins = result.rows.map((\n [id, lat, lon, country_code, postal_code],\n ) => ({\n id,\n lat,\n lon,\n country_code,\n postal_code,\n }));\n return new Response(JSON.stringify(pins), { headers: JSON_HEADERS });\n }\n\n // POST /api/pins — geocode and store a new pin\n if (req.method === \"POST\") {\n let body: any;\n try {\n body = await req.json();\n } catch {\n return new Response(JSON.stringify({ error: \"Invalid JSON\" }), {\n status: 400,\n headers: JSON_HEADERS,\n });\n }\n\n const postalCode: string = (body.postal_code ?? \"\").trim();\n const countryCode: string = (body.country_code ?? \"\").trim()\n .toUpperCase();\n\n if (!postalCode || !countryCode) {\n return new Response(\n JSON.stringify({\n error: \"postal_code and country_code are required\",\n }),\n { status: 400, headers: JSON_HEADERS },\n );\n }\n\n if (!isValidPostalCode(postalCode, countryCode)) {\n return new Response(\n JSON.stringify({\n error:\n \"That doesn't look like a valid postal code for the selected country.\",\n }),\n { status: 422, headers: JSON_HEADERS },\n );\n }\n\n let coords: [number, number] | null = null;\n try {\n coords = await geocode(postalCode, countryCode);\n } catch {\n // coords stays null\n }\n\n if (!coords) {\n return new Response(\n JSON.stringify({\n error:\n \"Could not find that location. Please check your postal code.\",\n }),\n { status: 422, headers: JSON_HEADERS },\n );\n }\n\n const [lat, lon] = coords;\n if (!Number.isFinite(lat) || !Number.isFinite(lon)) {\n return new Response(\n JSON.stringify({\n error:\n \"Could not find that location. Please check your postal code.\",\n }),\n { status: 422, headers: JSON_HEADERS },\n );\n }\n\n await sqlite.execute({\n sql:\n \"INSERT INTO pins (lat, lon, country_code, postal_code) VALUES (?, ?, ?, ?)\",\n args: [lat, lon, countryCode, postalCode],\n });\n\n return new Response(\n JSON.stringify({\n lat,\n lon,\n country_code: countryCode,\n postal_code: postalCode,\n }),\n { status: 201, headers: JSON_HEADERS },\n );\n }\n\n return new Response(\"Method Not Allowed\", { status: 405 });\n }\n\n // All other paths → serve the frontend\n return new Response(getHTML(), {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1771964720829],"children",[],[35],"46bbfe86-11b0-11f1-bf9c-42dde27851f2",["D",1771958422380],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","d64c506a-4597-4bf9-ba45-8b6a781b5e0a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","f9ac693b-9e35-4e47-8d7a-2fbf852b3f25","tursoName","46bbfe8611b011f1bf9c42dde27851f2","tursoHostname","46bbfe8611b011f1bf9c42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789534231467],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_117":113},"org",{"_11":12,"_111":-5,"_112":113,"_70":71,"_114":115,"_116":53},"branch",{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTBjN1NNRHdvcjN4SFo5UFVJckxsUmZXaFoifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":151,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":152,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":153,"_98":154,"_100":155,"_102":53},[148],"files",[148],"counts",{"_138":77,"_139":140,"_141":77,"_31":142,"_143":144},[136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":137},[35],"pulls","branches",1,"forks",{"_145":140,"_147":77},"connections",{"_145":77,"_146":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":149,"_18":150},[],[35],["D",1771958422380],["D",1789534231467],{"_11":12,"_117":113},{"_11":12,"_111":-5,"_112":113,"_70":71,"_114":115,"_116":53},{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"ctx",{"_96":-5,"_133":189,"_190":191,"_192":193,"_194":53,"_195":53,"_196":53,"_197":44,"_198":-5,"_199":-7,"_200":-7,"_201":77,"_202":53,"_203":53,"_204":-5,"_205":53,"_206":53,"_207":53,"_208":-5},"ENV",{"_160":161,"_162":163,"_164":16,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188},"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"]

Where are you from?

Admin Login

Admin — Visitor Map