Visitor Map

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",5,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","46be5816-11b0-11f1-bf9c-42dde27851f2","name","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 var:\n * GEONAMES_USERNAME — your GeoNames account username. Improves geocoding\n * accuracy for Ireland and Canada. Falls back to\n * Nominatim if unset.\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\") ?? \"demo\";\n const url =\n `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\nasync function geocode(\n postalCode: string,\n countryCode: string,\n): Promise<[number, number] | null> {\n // For IE and CA, GeoNames gives better results than Nominatim.\n if (countryCode === \"IE\" || countryCode === \"CA\") {\n const result = await geocodeGeoNames(postalCode, countryCode);\n if (result) return result;\n }\n\n // Structured Nominatim search.\n let data = await nominatimSearch({\n postalcode: postalCode,\n countrycodes: countryCode,\n format: \"json\",\n limit: \"1\",\n });\n if (data.length > 0) {\n return [parseFloat(data[0].lat), parseFloat(data[0].lon)];\n }\n\n // Free-text fallback (still country-constrained).\n data = await nominatimSearch({\n q: `${postalCode}, ${countryCode}`,\n countrycodes: countryCode,\n format: \"json\",\n limit: \"1\",\n });\n if (data.length > 0) {\n return [parseFloat(data[0].lat), parseFloat(data[0].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

\n \n\n \n\n \n \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\n if (url.pathname === \"/api/pins\") {\n // GET /api/pins — return all stored pins\n if (req.method === \"GET\") {\n const result = await sqlite.execute(\n \"SELECT lat, lon, country_code, postal_code FROM pins ORDER BY id\",\n );\n const pins = result.rows.map(([lat, lon, country_code, postal_code]) => ({\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().toUpperCase();\n\n if (!postalCode || !countryCode) {\n return new Response(\n JSON.stringify({ error: \"postal_code and country_code are required\" }),\n { status: 400, 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: \"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 await sqlite.execute(\n \"INSERT INTO pins (lat, lon, country_code, postal_code) VALUES (?, ?, ?, ?)\",\n [lat, lon, countryCode, postalCode],\n );\n\n return new Response(\n JSON.stringify({ lat, lon, country_code: countryCode, postal_code: postalCode }),\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}","/**\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 var:\n * GEONAMES_USERNAME — your GeoNames account username. Improves geocoding\n * accuracy for Ireland and Canada. Falls back to\n * Nominatim if unset.\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\") ?? \"demo\";\n const url =\n `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\nasync function geocode(\n postalCode: string,\n countryCode: string,\n): Promise<[number, number] | null> {\n // For IE and CA, GeoNames gives better results than Nominatim.\n if (countryCode === \"IE\" || countryCode === \"CA\") {\n const result = await geocodeGeoNames(postalCode, countryCode);\n if (result) return result;\n }\n\n // Structured Nominatim search.\n let 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 // Free-text fallback (still country-constrained).\n data = await nominatimSearch({\n q: `${postalCode}, ${countryCode}`,\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

\n \n\n \n\n \n \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\n if (url.pathname === \"/api/pins\") {\n // GET /api/pins — return all stored pins\n if (req.method === \"GET\") {\n const result = await sqlite.execute(\n \"SELECT lat, lon, country_code, postal_code FROM pins ORDER BY id\",\n );\n const pins = result.rows.map(([lat, lon, country_code, postal_code]) => ({\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().toUpperCase();\n\n if (!postalCode || !countryCode) {\n return new Response(\n JSON.stringify({ error: \"postal_code and country_code are required\" }),\n { status: 400, 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: \"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: \"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 \"INSERT INTO pins (lat, lon, country_code, postal_code) VALUES (?, ?, ?, ?)\",\n [lat, lon, countryCode, postalCode],\n );\n\n return new Response(\n JSON.stringify({ lat, lon, country_code: countryCode, postal_code: postalCode }),\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}","createdAt",["D",1771958951078],"branchVersion","branchId","46bc4512-11b0-11f1-bf9c-42dde27851f2","id","46bbfe86-11b0-11f1-bf9c-42dde27851f2","untitled-1472",["D",1771958422380],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","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",1789447273596],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned",20,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","chriswmartin","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTBjN1NNRHdvcjN4SFo5UFVJckxsUmZXaFoifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":152,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":153,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":154,"_81":155,"_83":156,"_85":25},"tree",[147],"files",[147],"counts",{"_136":60,"_137":138,"_139":60,"_140":141,"_142":143},"contents",[128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":132,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_27":135},"81df5f20-11b1-11f1-8b6e-42dde27851f2","parentId","latest",["D",1771958951078],4,"label",[28],"pulls","branches",1,"forks","envVars",{"_144":138,"_146":60},"connections",{"_144":60,"_145":60},"count","unfilledCount","emptyCount",{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":148,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_149":150,"_27":151},["D",1771958951078],"children",[],[28],["D",1771958422380],["D",1789447273596],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_125":190,"_191":192,"_193":194,"_195":25,"_196":25,"_197":25,"_198":123,"_199":-5,"_200":-7,"_201":-7,"_202":60,"_203":25,"_204":25,"_205":-5,"_206":25,"_207":25,"_208":25,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":87,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"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?

Where are you from?

Diff · v5