SpotSense — KFAT

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_116":-5,"_20":117,"_22":118,"_119":120,"_121":122,"_25":123,"_24":-5,"_124":-5,"_125":-5,"_126":53,"_127":128,"_129":44,"_130":-5,"_131":-5,"_132":133},"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","ezramevans","name","SpotSense","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":71,"_72":73,"_74":37,"_75":44,"_76":-5,"_77":-5,"_78":79,"_80":81,"_82":-5,"_83":-5,"_84":-5,"_85":-5,"_86":87,"_88":87,"_89":90,"_91":90,"_92":90,"_93":87,"_94":87,"_95":96,"_97":98,"_99":100,"_101":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","fe15853a-6ba4-4e75-9333-64263e7504da","main.ts","fileId","7fc58f9a-8383-11f1-99d9-1607ee4eb77e","parentId","branchId","024edaff-c089-40c7-b0c5-8f326d72c3ad","branchVersion",16,"latest",true,"createdAt",["D",1784594039344],15,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function (req: Request): Promise {\n // Your Spots. These are still placeholders near KFAT - swap in real\n // lat/lon once you've scouted, same as before. Add more by adding\n // more entries to this list.\n const SPOTS = [\n { id: 1, name: \"Spot 1 — North Perimeter\", note: \"Best for arrivals on 29R\", lat: 36.7860, lon: -119.7150 },\n { id: 2, name: \"Spot 2 — Overlook Rise\", note: \"Wide view, less shade\", lat: 36.7700, lon: -119.7300 },\n { id: 3, name: \"Spot 3 — East Fence Line\", note: \"Departures only right now\", lat: 36.7790, lon: -119.7050 },\n ];\n\n // Planes above this altitude are just cruising overhead, not doing\n // anything spotting-worthy near the airport - they're filtered out\n // completely, not just scored lower.\n const MAX_ALTITUDE_FT = 2000;\n\n // Planes farther than this from a Spot don't count as \"at\" that Spot,\n // even if they're low. Adjust this once you've tested in person and\n // know what actually feels visible/exciting from the ground.\n const MAX_DISTANCE_MI = 6;\n\n // If nothing's currently in range, we don't snap straight to 0 - we\n // fade the last real score down to 0 gradually over this many minutes,\n // like a dimmer switch instead of a light switch.\n const DECAY_WINDOW_MINUTES = 15;\n\n // Radius used just for tracking \"how busy is KFAT overall right now\"\n // history, separate from each Spot's own distance limit.\n const AIRPORT_RADIUS_MI = 10;\n\n // Center point used just to pull ONE list of nearby aircraft that\n // covers all your spots - each spot then grades itself independently\n // against that same shared list.\n const CENTER_LAT = 36.7762;\n const CENTER_LON = -119.7181;\n\n const COLORS = {\n bg: \"#0a0a0b\", panel: \"#18191c\", panelBorder: \"#2c2d32\",\n ink: \"#f2f2f3\", inkDim: \"#8b8c93\",\n green: \"#5fce8a\", amber: \"#e8a33d\", red: \"#e0616f\", blue: \"#5b9bd5\",\n };\n\n function scoreColor(score: number) {\n if (score >= 80) return COLORS.green;\n if (score >= 60) return COLORS.amber;\n return COLORS.red;\n }\n function scoreLabel(score: number) {\n if (score >= 95) return \"Legendary\";\n if (score >= 90) return \"Exceptional\";\n if (score >= 80) return \"Excellent\";\n if (score >= 60) return \"Very good\";\n return \"Poor\";\n }\n function milesBetween(lat1: number, lon1: number, lat2: number, lon2: number) {\n const latMiles = (lat1 - lat2) * 69;\n const lonMiles = (lon1 - lon2) * 54.6;\n return Math.sqrt(latMiles ** 2 + lonMiles ** 2);\n }\n function activityScore(n: number) {\n return Math.min(100, n * 20);\n }\n function proximityScore(miles: number) {\n return Math.max(0, Math.min(100, 100 - miles * 25));\n }\n function spotScore(a: number, p: number) {\n return (a * 0.3 + p * 0.35) / 0.65;\n }\n\n let aircraft: any[] = [];\n let fetchError = \"\";\n\n await sqlite.execute(\n \"CREATE TABLE IF NOT EXISTS spot_scores (spot_id INTEGER PRIMARY KEY, last_score REAL, last_seen_at INTEGER)\"\n );\n await sqlite.execute(\n \"CREATE TABLE IF NOT EXISTS airport_history (id INTEGER PRIMARY KEY AUTOINCREMENT, count INTEGER, ts INTEGER)\"\n );\n\n try {\n const url = `https://api.adsb.lol/v2/lat/${CENTER_LAT}/lon/${CENTER_LON}/dist/25`;\n const res = await fetch(url);\n const data = await res.json();\n const allAircraft = data.ac || [];\n\n // Cut out anything cruising above our altitude ceiling. Planes still\n // on the ground (alt_baro === \"ground\") always pass this check.\n aircraft = allAircraft.filter((pl: any) => {\n if (pl.alt_baro === \"ground\") return true;\n return typeof pl.alt_baro === \"number\" && pl.alt_baro <= MAX_ALTITUDE_FT;\n });\n } catch (err) {\n fetchError = String(err);\n }\n\n // Log \"how busy is KFAT right now overall\" and compare it to the\n // running historical average - this is what makes the score\n // airport-relative instead of just an absolute count.\n const now = Date.now();\n const totalNearAirport = aircraft.filter((pl: any) => {\n if (pl.lat == null || pl.lon == null) return false;\n return milesBetween(CENTER_LAT, CENTER_LON, pl.lat, pl.lon) <= AIRPORT_RADIUS_MI;\n }).length;\n\n // Seed with a rough real-world estimate the first time this ever runs,\n // based on FAA-reported 2024 movement data for KFAT (86,999\n // movements/year -> roughly 16/hour during active hours -> about 0.8\n // planes typically in our close-in zone at any given moment). This is\n // an estimate, not a direct measurement - it just gives the baseline a\n // sensible starting point instead of learning from total zero.\n const SEEDED_BASELINE = 0.8;\n const countRow = await sqlite.execute(\"SELECT COUNT(*) FROM airport_history\");\n const isFirstEverRun = ((countRow.rows[0]?.[0] as number) || 0) === 0;\n if (isFirstEverRun) {\n await sqlite.execute({\n sql: \"INSERT INTO airport_history (count, ts) VALUES (:count, :ts)\",\n args: { count: SEEDED_BASELINE, ts: now - 1 },\n });\n }\n\n await sqlite.execute({\n sql: \"INSERT INTO airport_history (count, ts) VALUES (:count, :ts)\",\n args: { count: totalNearAirport, ts: now },\n });\n\n const baselineResult = await sqlite.execute(\"SELECT AVG(count), COUNT(*) FROM airport_history\");\n const baselineRow = baselineResult.rows[0];\n const observationCount = (baselineRow?.[1] as number) || 0;\n const baseline = (baselineRow?.[0] as number) || SEEDED_BASELINE;\n\n function relativeActivityScore(spotCount: number) {\n const ratio = spotCount / Math.max(baseline, 0.5);\n return Math.max(0, Math.min(100, ratio * 50));\n }\n\n // Grade every spot independently against the same shared aircraft list.\n const graded = [];\n\n for (const spot of SPOTS) {\n const distances = aircraft\n .map((pl) => (pl.lat != null && pl.lon != null ? milesBetween(spot.lat, spot.lon, pl.lat, pl.lon) : null))\n .filter((d): d is number => d !== null)\n .filter((d) => d <= MAX_DISTANCE_MI); // too far away doesn't count at all\n\n const numNearby = distances.length;\n const closestDistance = distances.length ? Math.min(...distances) : null;\n\n const a = relativeActivityScore(numNearby);\n const p = closestDistance === null ? 0 : proximityScore(closestDistance);\n const rawFinal = numNearby === 0 && closestDistance === null ? 0 : spotScore(a, p);\n\n let displayFinal = rawFinal;\n let faded = false;\n\n if (rawFinal > 0) {\n // Something's actually here right now - save this moment as our\n // new baseline to fade from later.\n await sqlite.execute({\n sql: `INSERT INTO spot_scores (spot_id, last_score, last_seen_at) VALUES (:id, :score, :seen)\n ON CONFLICT(spot_id) DO UPDATE SET last_score = :score, last_seen_at = :seen`,\n args: { id: spot.id, score: rawFinal, seen: now },\n });\n } else {\n // Nothing here right now - check if we have a recent real score to\n // fade from instead of just showing 0.\n const result = await sqlite.execute({\n sql: \"SELECT last_score, last_seen_at FROM spot_scores WHERE spot_id = :id\",\n args: { id: spot.id },\n });\n const row = result.rows[0];\n if (row) {\n const lastScore = row[0] as number;\n const lastSeenAt = row[1] as number;\n const elapsedMinutes = (now - lastSeenAt) / 60000;\n const remaining = Math.max(0, 1 - elapsedMinutes / DECAY_WINDOW_MINUTES);\n displayFinal = lastScore * remaining;\n faded = displayFinal > 0;\n }\n }\n\n graded.push({ ...spot, numNearby, closestDistance, activity: a, proximity: p, final: displayFinal, faded });\n }\n\n graded.sort((x, y) => y.final - x.final);\n const best = graded[0];\n\n const gaugeSize = 200;\n const cx = gaugeSize / 2, cy = gaugeSize / 2, radius = gaugeSize / 2 - 16;\n const startAngle = -220, endAngle = 40, totalAngle = endAngle - startAngle;\n const angleForScore = (s: number) => startAngle + (Math.max(0, Math.min(100, s)) / 100) * totalAngle;\n const polar = (deg: number, r: number) => {\n const rad = (deg * Math.PI) / 180;\n return { x: cx + r * Math.cos(rad), y: cy + r * Math.sin(rad) };\n };\n const arcPath = (a0: number, a1: number, r: number) => {\n const p0 = polar(a0, r), p1 = polar(a1, r);\n const large = a1 - a0 > 180 ? 1 : 0;\n return `M ${p0.x} ${p0.y} A ${r} ${r} 0 ${large} 1 ${p1.x} ${p1.y}`;\n };\n const bestColor = scoreColor(best.final);\n\n const towerSvg = `\n \n `;\n const needleTip = polar(angleForScore(best.final), radius - 8);\n\n // Minimap: project each Spot's real lat/lon into a simple square view\n // centered on the airport, so their positions on the map genuinely\n // reflect where they are relative to each other and the field.\n const MAP_RADIUS_MI = 3;\n function projectToMap(lat: number, lon: number) {\n const latMiles = (lat - CENTER_LAT) * 69;\n const lonMiles = (lon - CENTER_LON) * 54.6;\n const x = 50 + (lonMiles / MAP_RADIUS_MI) * 46;\n const y = 50 - (latMiles / MAP_RADIUS_MI) * 46; // north is up, SVG y grows downward\n return { x: Math.max(4, Math.min(96, x)), y: Math.max(4, Math.min(96, y)) };\n }\n\n const spotPins = graded\n .map((s) => {\n const { x, y } = projectToMap(s.lat, s.lon);\n const c = scoreColor(s.final);\n const active = s.id === best.id;\n return `\n \n \n ${s.name.split(\"—\")[0].trim()}\n `;\n })\n .join(\"\");\n\n const minimapSvg = `\n \n `;\n\n const planeRows = aircraft\n .map((pl: any) => ({\n callsign: (pl.flight || pl.hex || \"unknown\").trim(),\n alt: typeof pl.alt_baro === \"number\" ? pl.alt_baro : null,\n dist: pl.lat != null && pl.lon != null ? milesBetween(CENTER_LAT, CENTER_LON, pl.lat, pl.lon) : null,\n }))\n .sort((a, b) => (a.dist ?? 999) - (b.dist ?? 999))\n .slice(0, 8)\n .map(\n (p) => `\n

\n ${p.callsign}\n ${p.alt !== null ? `${p.alt} ft` : \"on ground\"}${p.dist !== null ? ` · ${p.dist.toFixed(1)} mi` : \"\"}\n

`\n )\n .join(\"\");\n\n const spotRows = graded\n .map((s) => {\n const c = scoreColor(s.final);\n return `\n

${Math.round(s.final)}

${s.name}${s.id === best.id ? ' BEST NOW' : \"\"}${s.faded ? ' fading' : \"\"}

${s.note}

\n ${s.numNearby} nearby${s.closestDistance !== null ? `
${s.closestDistance.toFixed(1)} mi` : \"\"}\n

`;\n })\n .join(\"\");\n\n const html = `\n\n\n\n\n\nSpotSense — KFAT\n\n\n\n

${towerSvg}

SpotSense

KFAT · ${SPOTS.length} spots tracked · under ${MAX_ALTITUDE_FT.toLocaleString()} ft, within ${MAX_DISTANCE_MI} mi · auto-refreshes every 30s

Baseline: ${baseline.toFixed(2)} planes nearby on average (seeded from FAA data, refined by ${observationCount - 1} real check-in${observationCount - 1 === 1 ? \"\" : \"s\"})

\n\n ${fetchError ? `

Couldn't reach adsb.lol: ${fetchError}

` : \"\"}\n\n

RECOMMENDED SPOT: ${best.name.toUpperCase()}

\n \n

\n\n

Spot map

\n ${minimapSvg}\n

\n\n

All spots, ranked

\n ${spotRows}\n

\n\n

In the zone now

\n ${planeRows || `

Nothing under ${MAX_ALTITUDE_FT.toLocaleString()} ft nearby right now.

`}\n

\n\n \n

\n\n`;\n\n return new Response(html, {\n status: 200,\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",1784594039344],"children",[],[35],"74eeca31-1ac7-4e31-9346-e45838a1f1c5",["D",1784473623261],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Web based application to receive data used to rank planespotting","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/63536974-70c0-4613-adfb-076eea992b00/square512?exp=1789574399&sig=0ea01b4bfe223ce2581e6d937d862d6ec0a70e39fb01e18edffc50f7a4e52b68","userId","986e1d10-d8b7-45fe-8801-e634422987df","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f7add-8e3c-73d0-9264-fa1947fba670","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_115":19},"org",{"_11":12,"_110":19,"_111":19,"_72":73,"_112":113,"_114":53},"branch",{"_17":42,"_13":16,"_33":40,"_102":61,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":14,"_109":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":150,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":69,"_70":71,"_72":73,"_74":37,"_75":44,"_76":-5,"_77":-5,"_78":79,"_80":81,"_82":-5,"_83":-5,"_84":-5,"_85":-5,"_86":87,"_88":87,"_89":90,"_91":90,"_92":90,"_93":87,"_94":87,"_95":151,"_97":152,"_99":153,"_101":53},[147],"files",[147],"counts",{"_136":79,"_137":138,"_139":79,"_31":140,"_141":142},[134],"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":135},[35],"pulls","branches",1,"forks",{"_143":145,"_146":79},"connections",{"_143":79,"_144":79},"count","unfilledCount",2,"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":148,"_18":149},[],[35],["D",1784473623261],{"_11":12,"_115":19},{"_11":12,"_110":19,"_111":19,"_72":73,"_112":113,"_114":53},{"_17":42,"_13":16,"_33":40,"_102":61,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":14,"_109":12},"ctx",{"_95":-5,"_131":187,"_188":189,"_190":191,"_192":53,"_193":53,"_194":53,"_195":44,"_196":-5,"_197":-7,"_198":-7,"_199":79,"_200":53,"_201":53,"_202":-5,"_203":53,"_204":53,"_205":53,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":16,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"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"]

Code