[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_348":349,"_350":351},"routes/_app.x.$handle.$name",{"_101":100,"_32":46,"_109":91,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":60,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",121,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/db.ts","latestPath","fileId","e75c8c60-f7d5-11f0-84f8-42dde27851f2","name","db.ts","fileType","script","content","// Database schema and query functions for DC Hotspot Growth Map\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport type { Hotspot, DailySnapshot } from \"../shared/types.ts\";\n\n// Clear all data from database\nexport async function clearDatabase() {\n await sqlite.execute(`DELETE FROM hotspots`);\n await sqlite.execute(`DELETE FROM hotspot_locations`);\n await sqlite.execute(`DELETE FROM daily_snapshots`);\n}\n\n// Initialize database schema\nexport async function initDatabase() {\n // Hotspot records\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS hotspots (\n id INTEGER PRIMARY KEY,\n entity_key_str TEXT UNIQUE NOT NULL,\n key_to_asset_key TEXT NOT NULL,\n lat REAL NOT NULL,\n long REAL NOT NULL,\n created_at TEXT NOT NULL,\n first_seen_at TEXT NOT NULL,\n is_active INTEGER DEFAULT 1\n )\n `);\n\n // Location change history\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS hotspot_locations (\n id INTEGER PRIMARY KEY,\n entity_key_str TEXT NOT NULL,\n lat REAL NOT NULL,\n long REAL NOT NULL,\n observed_at TEXT NOT NULL\n )\n `);\n\n // Pre-computed daily stats\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS daily_snapshots (\n snapshot_date TEXT PRIMARY KEY,\n total_count INTEGER NOT NULL,\n new_count INTEGER NOT NULL\n )\n `);\n\n // Create indexes\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_hotspots_created ON hotspots(created_at)\n `);\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_snapshots_date ON daily_snapshots(snapshot_date)\n `);\n}\n\n// Get all active hotspots\nexport async function getAllHotspots(): Promise {\n const result = await sqlite.execute(`\n SELECT entity_key_str, key_to_asset_key, lat, long, created_at, first_seen_at, is_active\n FROM hotspots\n ORDER BY created_at ASC\n LIMIT 10000\n `);\n\n // Val Town SQLite returns rows as arrays, access by column index\n const columns = result.columns || [];\n return result.rows.map((row: any) => {\n // If row is an array, convert to object using column names\n if (Array.isArray(row)) {\n const obj: any = {};\n columns.forEach((col: string, i: number) => {\n obj[col] = row[i];\n });\n return {\n entity_key_str: obj.entity_key_str as string,\n key_to_asset_key: obj.key_to_asset_key as string,\n lat: obj.lat as number,\n long: obj.long as number,\n created_at: obj.created_at as string,\n first_seen_at: obj.first_seen_at as string,\n is_active: Boolean(obj.is_active),\n };\n }\n // Otherwise assume it's already an object\n return {\n entity_key_str: row.entity_key_str as string,\n key_to_asset_key: row.key_to_asset_key as string,\n lat: row.lat as number,\n long: row.long as number,\n created_at: row.created_at as string,\n first_seen_at: row.first_seen_at as string,\n is_active: Boolean(row.is_active),\n };\n });\n}\n\n// Get all daily snapshots\nexport async function getAllSnapshots(): Promise {\n const result = await sqlite.execute(`\n SELECT snapshot_date, total_count, new_count\n FROM daily_snapshots\n ORDER BY snapshot_date ASC\n `);\n\n // Val Town SQLite returns rows as arrays\n const columns = result.columns || [];\n return result.rows.map((row: any) => {\n if (Array.isArray(row)) {\n const obj: any = {};\n columns.forEach((col: string, i: number) => {\n obj[col] = row[i];\n });\n return {\n snapshot_date: obj.snapshot_date as string,\n total_count: obj.total_count as number,\n new_count: obj.new_count as number,\n };\n }\n return {\n snapshot_date: row.snapshot_date as string,\n total_count: row.total_count as number,\n new_count: row.new_count as number,\n };\n });\n}\n\n// Insert or update a hotspot\nexport async function upsertHotspot(hotspot: {\n entity_key_str: string;\n key_to_asset_key: string;\n lat: number;\n long: number;\n created_at: string;\n first_seen_at: string;\n is_active: boolean;\n}) {\n await sqlite.execute({\n sql: `\n INSERT INTO hotspots (entity_key_str, key_to_asset_key, lat, long, created_at, first_seen_at, is_active)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(entity_key_str) DO UPDATE SET\n lat = excluded.lat,\n long = excluded.long,\n is_active = excluded.is_active\n `,\n args: [\n hotspot.entity_key_str,\n hotspot.key_to_asset_key,\n hotspot.lat,\n hotspot.long,\n hotspot.created_at,\n hotspot.first_seen_at,\n hotspot.is_active ? 1 : 0,\n ],\n });\n}\n\n// Insert a daily snapshot\nexport async function upsertSnapshot(snapshot: DailySnapshot) {\n await sqlite.execute({\n sql: `\n INSERT INTO daily_snapshots (snapshot_date, total_count, new_count)\n VALUES (?, ?, ?)\n ON CONFLICT(snapshot_date) DO UPDATE SET\n total_count = excluded.total_count,\n new_count = excluded.new_count\n `,\n args: [snapshot.snapshot_date, snapshot.total_count, snapshot.new_count],\n });\n}\n\n// Get hotspot count\nexport async function getHotspotCount(): Promise {\n const result = await sqlite.execute(`SELECT COUNT(*) as count FROM hotspots WHERE is_active = 1`);\n const row = result.rows[0];\n return (Array.isArray(row) ? row[0] : row.count) as number;\n}\n\n// Check if a hotspot exists\nexport async function getHotspot(entity_key_str: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM hotspots WHERE entity_key_str = ?`,\n args: [entity_key_str],\n });\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n entity_key_str: row.entity_key_str as string,\n key_to_asset_key: row.key_to_asset_key as string,\n lat: row.lat as number,\n long: row.long as number,\n created_at: row.created_at as string,\n first_seen_at: row.first_seen_at as string,\n is_active: Boolean(row.is_active),\n };\n}\n\n// Record location change\nexport async function recordLocationChange(entity_key_str: string, lat: number, long: number, observed_at: string) {\n await sqlite.execute({\n sql: `INSERT INTO hotspot_locations (entity_key_str, lat, long, observed_at) VALUES (?, ?, ?, ?)`,\n args: [entity_key_str, lat, long, observed_at],\n });\n}\n\n// Compute historical snapshots from hotspot created_at dates\nexport async function computeHistoricalSnapshots() {\n // Get date range - Val Town SQLite returns arrays, so access by index\n const dateRange = await sqlite.execute(`\n SELECT MIN(DATE(created_at)) as min_date, MAX(DATE(created_at)) as max_date\n FROM hotspots\n `);\n\n // Access by index (0 = min_date, 1 = max_date)\n const row = dateRange.rows[0];\n const minDateStr = Array.isArray(row) ? row[0] : row.min_date;\n const maxDateStr = Array.isArray(row) ? row[1] : row.max_date;\n\n if (!minDateStr) return;\n\n const minDate = new Date(minDateStr as string);\n const maxDate = new Date(maxDateStr as string);\n\n // Compute snapshot for each day\n for (let d = new Date(minDate); d <= maxDate; d.setDate(d.getDate() + 1)) {\n const dateStr = d.toISOString().split('T')[0];\n\n const totalResult = await sqlite.execute({\n sql: `SELECT COUNT(*) as total FROM hotspots WHERE DATE(created_at) <= ?`,\n args: [dateStr],\n });\n\n const newResult = await sqlite.execute({\n sql: `SELECT COUNT(*) as new_count FROM hotspots WHERE DATE(created_at) = ?`,\n args: [dateStr],\n });\n\n // Access counts by index as well\n const totalRow = totalResult.rows[0];\n const newRow = newResult.rows[0];\n const total = Array.isArray(totalRow) ? totalRow[0] : totalRow.total;\n const newCount = Array.isArray(newRow) ? newRow[0] : newRow.new_count;\n\n await upsertSnapshot({\n snapshot_date: dateStr,\n total_count: total as number,\n new_count: newCount as number,\n });\n }\n}\n","// Database schema and query functions for DC Hotspot Growth Map\nimport sqlite from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\nimport type { Hotspot, DailySnapshot } from \"../shared/types.ts\";\n\n// Clear all data from database\nexport async function clearDatabase() {\n await sqlite.execute(`DELETE FROM hotspots`);\n await sqlite.execute(`DELETE FROM hotspot_locations`);\n await sqlite.execute(`DELETE FROM daily_snapshots`);\n}\n\n// Initialize database schema\nexport async function initDatabase() {\n // Hotspot records\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS hotspots (\n id INTEGER PRIMARY KEY,\n entity_key_str TEXT UNIQUE NOT NULL,\n key_to_asset_key TEXT NOT NULL,\n lat REAL NOT NULL,\n long REAL NOT NULL,\n created_at TEXT NOT NULL,\n first_seen_at TEXT NOT NULL,\n is_active INTEGER DEFAULT 1\n )\n `);\n\n // Location change history\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS hotspot_locations (\n id INTEGER PRIMARY KEY,\n entity_key_str TEXT NOT NULL,\n lat REAL NOT NULL,\n long REAL NOT NULL,\n observed_at TEXT NOT NULL\n )\n `);\n\n // Pre-computed daily stats\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS daily_snapshots (\n snapshot_date TEXT PRIMARY KEY,\n total_count INTEGER NOT NULL,\n new_count INTEGER NOT NULL\n )\n `);\n\n // Create indexes\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_hotspots_created ON hotspots(created_at)\n `);\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_snapshots_date ON daily_snapshots(snapshot_date)\n `);\n}\n\n// Get all active hotspots\nexport async function getAllHotspots(): Promise {\n const result = await sqlite.execute(`\n SELECT entity_key_str, key_to_asset_key, lat, long, created_at, first_seen_at, is_active\n FROM hotspots\n ORDER BY created_at ASC\n LIMIT 10000\n `);\n\n // Val Town SQLite returns rows as arrays, access by column index\n const columns = result.columns || [];\n return result.rows.map((row: any) => {\n // If row is an array, convert to object using column names\n if (Array.isArray(row)) {\n const obj: any = {};\n columns.forEach((col: string, i: number) => {\n obj[col] = row[i];\n });\n return {\n entity_key_str: obj.entity_key_str as string,\n key_to_asset_key: obj.key_to_asset_key as string,\n lat: obj.lat as number,\n long: obj.long as number,\n created_at: obj.created_at as string,\n first_seen_at: obj.first_seen_at as string,\n is_active: Boolean(obj.is_active),\n };\n }\n // Otherwise assume it's already an object\n return {\n entity_key_str: row.entity_key_str as string,\n key_to_asset_key: row.key_to_asset_key as string,\n lat: row.lat as number,\n long: row.long as number,\n created_at: row.created_at as string,\n first_seen_at: row.first_seen_at as string,\n is_active: Boolean(row.is_active),\n };\n });\n}\n\n// Get all daily snapshots\nexport async function getAllSnapshots(): Promise {\n const result = await sqlite.execute(`\n SELECT snapshot_date, total_count, new_count\n FROM daily_snapshots\n ORDER BY snapshot_date ASC\n `);\n\n // Val Town SQLite returns rows as arrays\n const columns = result.columns || [];\n return result.rows.map((row: any) => {\n if (Array.isArray(row)) {\n const obj: any = {};\n columns.forEach((col: string, i: number) => {\n obj[col] = row[i];\n });\n return {\n snapshot_date: obj.snapshot_date as string,\n total_count: obj.total_count as number,\n new_count: obj.new_count as number,\n };\n }\n return {\n snapshot_date: row.snapshot_date as string,\n total_count: row.total_count as number,\n new_count: row.new_count as number,\n };\n });\n}\n\n// Insert or update a hotspot\nexport async function upsertHotspot(hotspot: {\n entity_key_str: string;\n key_to_asset_key: string;\n lat: number;\n long: number;\n created_at: string;\n first_seen_at: string;\n is_active: boolean;\n}) {\n await sqlite.execute({\n sql: `\n INSERT INTO hotspots (entity_key_str, key_to_asset_key, lat, long, created_at, first_seen_at, is_active)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(entity_key_str) DO UPDATE SET\n lat = excluded.lat,\n long = excluded.long,\n is_active = excluded.is_active\n `,\n args: [\n hotspot.entity_key_str,\n hotspot.key_to_asset_key,\n hotspot.lat,\n hotspot.long,\n hotspot.created_at,\n hotspot.first_seen_at,\n hotspot.is_active ? 1 : 0,\n ],\n });\n}\n\n// Insert a daily snapshot\nexport async function upsertSnapshot(snapshot: DailySnapshot) {\n await sqlite.execute({\n sql: `\n INSERT INTO daily_snapshots (snapshot_date, total_count, new_count)\n VALUES (?, ?, ?)\n ON CONFLICT(snapshot_date) DO UPDATE SET\n total_count = excluded.total_count,\n new_count = excluded.new_count\n `,\n args: [snapshot.snapshot_date, snapshot.total_count, snapshot.new_count],\n });\n}\n\n// Get hotspot count\nexport async function getHotspotCount(): Promise {\n const result = await sqlite.execute(`SELECT COUNT(*) as count FROM hotspots WHERE is_active = 1`);\n const row = result.rows[0];\n return (Array.isArray(row) ? row[0] : row.count) as number;\n}\n\n// Check if a hotspot exists\nexport async function getHotspot(entity_key_str: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM hotspots WHERE entity_key_str = ?`,\n args: [entity_key_str],\n });\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n entity_key_str: row.entity_key_str as string,\n key_to_asset_key: row.key_to_asset_key as string,\n lat: row.lat as number,\n long: row.long as number,\n created_at: row.created_at as string,\n first_seen_at: row.first_seen_at as string,\n is_active: Boolean(row.is_active),\n };\n}\n\n// Record location change\nexport async function recordLocationChange(entity_key_str: string, lat: number, long: number, observed_at: string) {\n await sqlite.execute({\n sql: `INSERT INTO hotspot_locations (entity_key_str, lat, long, observed_at) VALUES (?, ?, ?, ?)`,\n args: [entity_key_str, lat, long, observed_at],\n });\n}\n\n// Compute historical snapshots from hotspot created_at dates\nexport async function computeHistoricalSnapshots() {\n // Get date range - Val Town SQLite returns arrays, so access by index\n const dateRange = await sqlite.execute(`\n SELECT MIN(DATE(created_at)) as min_date, MAX(DATE(created_at)) as max_date\n FROM hotspots\n `);\n\n // Access by index (0 = min_date, 1 = max_date)\n const row = dateRange.rows[0];\n const minDateStr = Array.isArray(row) ? row[0] : row.min_date;\n const maxDateStr = Array.isArray(row) ? row[1] : row.max_date;\n\n if (!minDateStr) return;\n\n const minDate = new Date(minDateStr as string);\n const maxDate = new Date(maxDateStr as string);\n\n // Compute snapshot for each day\n for (let d = new Date(minDate); d <= maxDate; d.setDate(d.getDate() + 1)) {\n const dateStr = d.toISOString().split('T')[0];\n\n const totalResult = await sqlite.execute({\n sql: `SELECT COUNT(*) as total FROM hotspots WHERE DATE(created_at) <= ?`,\n args: [dateStr],\n });\n\n const newResult = await sqlite.execute({\n sql: `SELECT COUNT(*) as new_count FROM hotspots WHERE DATE(created_at) = ?`,\n args: [dateStr],\n });\n\n // Access counts by index as well\n const totalRow = totalResult.rows[0];\n const newRow = newResult.rows[0];\n const total = Array.isArray(totalRow) ? totalRow[0] : totalRow.total;\n const newCount = Array.isArray(newRow) ? newRow[0] : newRow.new_count;\n\n await upsertSnapshot({\n snapshot_date: dateStr,\n total_count: total as number,\n new_count: newCount as number,\n });\n }\n}\n","createdAt",["D",1769213540536],"branchVersion","branchId","0f63dbe2-f7d5-11f0-81ce-42dde27851f2","id","0f63583e-f7d5-11f0-81ce-42dde27851f2","dc-hotspot-map",["D",1769115490645],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Map tracking Helium Hotspot growth around Washington DC","imageUrl","d251f9a0-ef29-11ef-b0ef-a9e402d41f57","pinnedFileId","10367c64-f7d5-11f0-990e-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","7dc0a550-a6a9-426f-8cc0-c1e24f3e9522","tursoName","0f63583ef7d511f081ce42dde27851f2","tursoHostname","0f63583ef7d511f081ce42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789542098478],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_108":104},"org",{"_101":100,"_102":-5,"_103":104,"_18":56,"_105":106,"_107":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"isOwned",135,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jhiller","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydEhoSjBDdW5lY3JwdWh5SVdiN0Z6dFRLcXIifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":343,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":344,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":345,"_85":346,"_87":347,"_89":25},"tree",[202,207,216,218,219,220,221],"files",[202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221],"counts",{"_192":155,"_193":64,"_194":155,"_195":196,"_197":198},"contents",[131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":186,"_32":187,"_30":188,"_140":-5,"_42":43,"_41":189,"_142":60,"_39":190,"_13":155,"_34":179,"_36":-5,"_24":25,"_147":-5,"_27":191},{"_44":181,"_32":182,"_30":183,"_140":-5,"_42":43,"_41":64,"_142":60,"_39":184,"_13":155,"_34":179,"_36":-5,"_24":25,"_147":-5,"_27":185},{"_44":174,"_32":175,"_30":176,"_140":-5,"_42":43,"_41":177,"_142":60,"_39":178,"_13":155,"_34":179,"_36":-5,"_24":25,"_147":-5,"_27":180},{"_44":166,"_32":167,"_30":168,"_140":-5,"_42":43,"_41":169,"_142":25,"_39":170,"_13":171,"_34":20,"_36":172,"_24":25,"_147":-5,"_27":173},{"_44":159,"_32":160,"_30":161,"_140":-5,"_42":43,"_41":162,"_142":25,"_39":163,"_13":155,"_34":20,"_36":164,"_24":25,"_147":-5,"_27":165},{"_44":150,"_32":151,"_30":152,"_140":-5,"_42":43,"_41":153,"_142":25,"_39":154,"_13":155,"_34":156,"_36":157,"_24":25,"_147":-5,"_27":158},{"_44":138,"_32":139,"_30":58,"_140":-5,"_42":43,"_41":141,"_142":25,"_39":143,"_13":144,"_34":145,"_36":146,"_24":25,"_147":148,"_27":149},"19c9f37a-f8b9-11f0-b59a-42dde27851f2","index.ts","parentId",120,"latest",["D",1769213433354],7,"http","// DC Hotspot Growth Map - Main HTTP Server\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport * as db from \"./backend/db.ts\";\nimport { runBackfill, runDailyScrape } from \"./backend/scraper.ts\";\nimport { runMigration } from \"./backend/migrate.ts\";\n\nconst app = new Hono();\n\n// Initialize database on startup\ndb.initDatabase().catch(console.error);\n\n// Serve index.html at the root\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// API: Get all hotspots\napp.get(\"/api/hotspots\", async (c) => {\n try {\n const hotspots = await db.getAllHotspots();\n return c.json(hotspots);\n } catch (e) {\n console.error(\"Error fetching Hotspots:\", e);\n return c.json({ error: \"Failed to fetch Hotspots\" }, 500);\n }\n});\n\n// API: Get all daily snapshots\napp.get(\"/api/snapshots\", async (c) => {\n try {\n const snapshots = await db.getAllSnapshots();\n return c.json(snapshots);\n } catch (e) {\n console.error(\"Error fetching snapshots:\", e);\n return c.json({ error: \"Failed to fetch snapshots\" }, 500);\n }\n});\n\n// API: Get hotspot count\napp.get(\"/api/stats\", async (c) => {\n try {\n const count = await db.getHotspotCount();\n const snapshots = await db.getAllSnapshots();\n const latest = snapshots.length > 0 ? snapshots[snapshots.length - 1] : null;\n return c.json({\n total: count,\n latest_snapshot: latest,\n });\n } catch (e) {\n console.error(\"Error fetching stats:\", e);\n return c.json({ error: \"Failed to fetch stats\" }, 500);\n }\n});\n\n// Admin API: Trigger backfill (protected - check for API key in production)\napp.post(\"/api/admin/backfill\", async (c) => {\n try {\n console.log(\"Starting backfill...\");\n const result = await runBackfill();\n return c.json(result);\n } catch (e) {\n console.error(\"Backfill error:\", e);\n return c.json({ error: String(e) }, 500);\n }\n});\n\n// Admin API: Trigger daily scrape\napp.post(\"/api/admin/scrape\", async (c) => {\n try {\n console.log(\"Starting daily scrape...\");\n const result = await runDailyScrape();\n return c.json(result);\n } catch (e) {\n console.error(\"Scrape error:\", e);\n return c.json({ error: String(e) }, 500);\n }\n});\n\n// Admin API: Compute historical snapshots from created_at dates\napp.post(\"/api/admin/compute-snapshots\", async (c) => {\n try {\n console.log(\"Computing historical snapshots...\");\n await db.computeHistoricalSnapshots();\n const snapshots = await db.getAllSnapshots();\n return c.json({ success: true, count: snapshots.length });\n } catch (e) {\n console.error(\"Compute snapshots error:\", e);\n return c.json({ error: String(e) }, 500);\n }\n});\n\n// Admin API: Clear all data and re-backfill\napp.post(\"/api/admin/clear-and-backfill\", async (c) => {\n try {\n console.log(\"Clearing database...\");\n await db.clearDatabase();\n console.log(\"Starting fresh backfill...\");\n const result = await runBackfill();\n return c.json(result);\n } catch (e) {\n console.error(\"Clear and backfill error:\", e);\n return c.json({ error: String(e) }, 500);\n }\n});\n\n// Admin API: Migrate data from old sqlite to new Turso sqlite\napp.post(\"/api/admin/migrate\", async (c) => {\n try {\n console.log(\"Starting database migration...\");\n const result = await runMigration();\n return c.json(result);\n } catch (e) {\n console.error(\"Migration error:\", e);\n return c.json({ error: String(e) }, 500);\n }\n});\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\nexport default app.fetch;\n\n","label","dc-hotspot-growth",[139],"f59bec9c-f7eb-11f0-b3bc-42dde27851f2","cron.ts","f59bed6e-f7eb-11f0-b3bc-42dde27851f2",77,["D",1769125325840],0,"interval","// Daily scraper cron job for DC Hotspot Growth Map\n// Runs at 6 AM UTC daily to fetch new hotspots\nimport { runDailyScrape } from \"./backend/scraper.ts\";\n\nexport default async function() {\n console.log(\"Starting scheduled daily scrape...\");\n\n try {\n const result = await runDailyScrape();\n console.log(\"Daily scrape completed:\", result);\n return result;\n } catch (error) {\n console.error(\"Daily scrape failed:\", error);\n throw error;\n }\n}\n",[151],"10469b94-f7d5-11f0-a6fb-42dde27851f2","README.md","10469c52-f7d5-11f0-a6fb-42dde27851f2",9,["D",1769115491998],"# React Hono Starter\n\nThis app is a starter template for client-side React and server-side Hono.\n\n## Getting started\n\nGet a copy of this starter template by clicking the **Remix** button in the\ntop-right.\n\n## How it works\n\n- The **entrypoint** is [`index.ts`](index.ts). That's the backend HTTP server,\n which also serves the all the frontend assets.\n\n- The **client-side entrypoint** is\n [`/frontend/index.html`](/frontend/index.html)\n - which in turn imports [`/frontend/index.tsx`](/frontend/index.tsx)\n - which in turn imports the React app from\n [`/frontend/components/App.tsx`](/frontend/components/App.tsx).\n\nSo if you wanted to get a sense of how this app comes together, we suggest\nreading the files in this order:\n\n[`index.ts`](index.ts) -> [`/frontend/index.html`](/frontend/index.html) ->\n[`/frontend/index.tsx`](/frontend/index.tsx) ->\n[`/frontend/components/App.tsx`](/frontend/components/App.tsx)\n\n## Further resources\n\n- [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a\n bigger example project, with a SQLite database table, queries, client-side\n CSS, a favicon, and shared code that runs on both client and server.",[160],"2c5fa2ea-f88d-11f0-a658-42dde27851f2","CLAUDE.md","5d98d982-f7eb-11f0-ae1a-42dde27851f2",115,["D",1769194566686],6,"# DC Hotspot Growth Map\n\n## Project Overview\nA Val Town app that visualizes Helium Mobile hotspot growth in the DC Metro area over time, featuring an interactive deck.gl map with H3-based clustering (rendered as scaled circles) and timeline scrubbing.\n\n## Deployment\n- **Live URL**: https://jhiller--10367c64f7d511f0990e42dde27851f2.web.val.run\n\n## Tech Stack\n- **Platform**: Val Town (Deno runtime)\n- **Backend**: Hono HTTP framework\n- **Database**: Val Town SQLite\n- **Frontend**: React + deck.gl (WebGL)\n- **Clustering**: Uber H3 (resolution 8) for grouping\n- **Map Tiles**: CartoDB dark-matter (via TileLayer)\n- **Styling**: Helium-inspired dark theme\n\n## Key Files\n- `index.ts` - Main Hono server with API routes\n- `backend/db.ts` - SQLite schema and queries\n- `backend/heliumApi.ts` - Helium Entity API client\n- `backend/scraper.ts` - Backfill and daily scrape logic\n- `cron.ts` - Daily scraper cron job (6 AM UTC)\n- `frontend/components/App.tsx` - Main React component with map, timeline, and clustering\n- `frontend/utils/animalHash.ts` - Animal name generator (angry-purple-tiger algorithm)\n- `frontend/style.css` - Helium-inspired dark theme styles\n\n## Val Town CLI\n- Push changes: `~/.deno/bin/vt push`\n- Open in browser: `~/.deno/bin/vt browse`\n- Configure cron schedule in Val Town web interface\n\n## Design Decisions\n\n### deck.gl Visualization\n- Load via CDN: ``\n- Access as global `deck` object (esm.sh imports have luma.gl compatibility issues)\n- Using ScatterplotLayer with `radiusUnits: \"pixels\"`, `stroked: false`\n- Circles scaled by count using **sqrt easing curve**: `radius = 8 + 27 * (sqrt(count-1) / sqrt(69))`\n- Min radius: 8px (count=1), Max radius: 35px (count=70)\n- Easing makes 1→2 dramatic but 67→70 nearly imperceptible\n- Built-in transitions: `transitions: { getRadius: { duration: 150 }, getFillColor: { duration: 150 } }`\n- TextLayer for count labels: `fontFamily: \"Figtree, sans-serif\"`, `fontWeight: 300`\n- TileLayer for CartoDB dark basemap: `https://basemaps.cartocdn.com/dark_all/{z}/{x}/{y}@2x.png`\n\n### Animal Names (animalHash.ts)\n- Uses exact angry-purple-tiger algorithm with blueimp-md5\n- Critical: ADJECTIVES array must include duplicate \"skinny\" at index 85 (after \"shallow\")\n- Display names in Title Case (e.g., \"Angry Purple Tiger\"), not kebab-case\n\n### Timeline/Histogram\n- **Interactive scrubber**: Click or drag anywhere on histogram (no separate slider)\n- Histogram bars: `flex: 1 1 0`, `min-width: 0` (allows fractional pixel widths)\n- Critical: `min-width: 0` prevents overflow on narrow viewports with many bars\n- Histogram height: 50px desktop, 40px mobile\n- Histogram capped at 10 new hotspots to prevent outliers from flattening\n- Playback at 15ms interval (~67 fps)\n- When at end of timeline and user presses play, reset to beginning\n- **Playhead positioning**: Center on each bar using `calc(12px + (100% - 24px) * ${(currentIdx + 0.5) / snapshots.length})`\n- Playhead has `transform: translateX(-50%)` to center the 2px line on calculated position\n- Touch support: `onTouchStart`, `onTouchMove`, `onTouchEnd` handlers mirror mouse events\n\n### iOS Safari Viewport Fix\n- Use `height: 100dvh` (dynamic viewport height) instead of `100vh`\n- Add `viewport-fit=cover` to viewport meta tag\n- Use `env(safe-area-inset-bottom)` for timeline padding\n\n### Visual Design (Helium-inspired)\n- Dark theme with `--bg-primary: #04081b`\n- Accent colors: cyan (#4FC3F7), green (#00d97d), purple (#5e25fd)\n- Avoid bold fonts - use font-weight 400-500\n- Circle fill opacity: 0.5 for established (grey), 0.7 for new/recent\n- **Glass pane effect**: `background: var(--bg-card)`, `backdrop-filter: blur(15px)`, `border: 1px solid var(--border-color)`, `border-radius: 12px`\n- Two floating panels only: stats panel (top-left with integrated legend) and timeline (bottom)\n- Play button: white background, optical alignment with `padding-left: 3px` for triangle (reset to 0 for pause icon)\n\n### Color Coding (Hotspot Age)\n- Green (#2ecc71): New (< 7 days)\n- Blue (#3498db): Recent (< 30 days)\n- Grey (#a0a0a0): Established (30+ days)\n\n### Mobile Responsive (max-width: 768px)\n- Timeline: 10px margins, 12px padding\n- Histogram height: 40px with 6px 10px padding\n- Play button: 36x36px\n- Legend integrated into stats panel (always visible)\n\n## API Endpoints\n- `GET /api/hotspots` - All active hotspots\n- `GET /api/snapshots` - Daily snapshot stats\n- `GET /api/stats` - Current count and latest snapshot\n- `POST /api/admin/backfill` - Trigger data backfill\n- `POST /api/admin/scrape` - Trigger daily scrape\n\n## DC Metro Bounding Box\n```typescript\nconst DC_BOUNDS = {\n minLat: 38.5, maxLat: 39.3,\n minLong: -77.5, maxLong: -76.7\n};\n```\n",[167],"e7310914-f7d5-11f0-8149-42dde27851f2","shared","e73109f0-f7d5-11f0-8149-42dde27851f2",12,["D",1769115852719],"directory",[175],"0fd734b6-f7d5-11f0-8b85-42dde27851f2","frontend","0fd73556-f7d5-11f0-8b85-42dde27851f2",["D",1769115491425],[182],"e70fa13e-f7d5-11f0-8269-42dde27851f2","backend","e70fa206-f7d5-11f0-8269-42dde27851f2",11,["D",1769115852504],[187],"pulls","branches","forks","envVars",{"_199":155,"_201":155},"connections",{"_199":155,"_200":155},"count","unfilledCount","emptyCount",{"_44":186,"_32":187,"_30":188,"_140":-5,"_42":43,"_41":189,"_142":60,"_39":340,"_13":155,"_34":179,"_36":-5,"_24":25,"_147":-5,"_223":341,"_27":342},{"_44":335,"_32":33,"_30":31,"_140":188,"_42":43,"_41":14,"_142":60,"_39":336,"_13":337,"_34":35,"_36":38,"_24":25,"_147":-5,"_223":338,"_27":339},{"_44":328,"_32":329,"_30":330,"_140":188,"_42":43,"_41":251,"_142":60,"_39":331,"_13":64,"_34":35,"_36":332,"_24":25,"_147":-5,"_223":333,"_27":334},{"_44":320,"_32":321,"_30":322,"_140":188,"_42":43,"_41":323,"_142":60,"_39":324,"_13":155,"_34":35,"_36":325,"_24":25,"_147":-5,"_223":326,"_27":327},{"_44":313,"_32":314,"_30":315,"_140":188,"_42":43,"_41":300,"_142":60,"_39":316,"_13":268,"_34":35,"_36":317,"_24":25,"_147":-5,"_223":318,"_27":319},{"_44":181,"_32":182,"_30":183,"_140":-5,"_42":43,"_41":64,"_142":60,"_39":310,"_13":155,"_34":179,"_36":-5,"_24":25,"_147":-5,"_223":311,"_27":312},{"_44":305,"_32":304,"_30":297,"_140":183,"_42":43,"_41":306,"_142":60,"_39":307,"_13":155,"_34":179,"_36":-5,"_24":25,"_147":-5,"_223":308,"_27":309},{"_44":294,"_32":295,"_30":296,"_140":297,"_42":43,"_41":298,"_142":25,"_39":299,"_13":300,"_34":35,"_36":301,"_24":25,"_147":-5,"_223":302,"_27":303},{"_44":289,"_32":288,"_30":282,"_140":183,"_42":43,"_41":290,"_142":60,"_39":291,"_13":155,"_34":179,"_36":-5,"_24":25,"_147":-5,"_223":292,"_27":293},{"_44":279,"_32":280,"_30":281,"_140":282,"_42":43,"_41":283,"_142":60,"_39":284,"_13":268,"_34":35,"_36":285,"_24":25,"_147":-5,"_223":286,"_27":287},{"_44":272,"_32":273,"_30":274,"_140":183,"_42":43,"_41":144,"_142":60,"_39":275,"_13":155,"_34":20,"_36":276,"_24":25,"_147":-5,"_223":277,"_27":278},{"_44":263,"_32":264,"_30":265,"_140":183,"_42":43,"_41":266,"_142":60,"_39":267,"_13":268,"_34":20,"_36":269,"_24":25,"_147":-5,"_223":270,"_27":271},{"_44":255,"_32":256,"_30":257,"_140":183,"_42":43,"_41":258,"_142":60,"_39":259,"_13":155,"_34":35,"_36":260,"_24":25,"_147":-5,"_223":261,"_27":262},{"_44":246,"_32":247,"_30":248,"_140":183,"_42":43,"_41":249,"_142":60,"_39":250,"_13":251,"_34":20,"_36":252,"_24":25,"_147":-5,"_223":253,"_27":254},{"_44":174,"_32":175,"_30":176,"_140":-5,"_42":43,"_41":177,"_142":60,"_39":243,"_13":155,"_34":179,"_36":-5,"_24":25,"_147":-5,"_223":244,"_27":245},{"_44":235,"_32":236,"_30":237,"_140":176,"_42":43,"_41":238,"_142":60,"_39":239,"_13":155,"_34":35,"_36":240,"_24":25,"_147":-5,"_223":241,"_27":242},{"_44":166,"_32":167,"_30":168,"_140":-5,"_42":43,"_41":169,"_142":25,"_39":232,"_13":171,"_34":20,"_36":172,"_24":25,"_147":-5,"_223":233,"_27":234},{"_44":159,"_32":160,"_30":161,"_140":-5,"_42":43,"_41":162,"_142":25,"_39":229,"_13":155,"_34":20,"_36":164,"_24":25,"_147":-5,"_223":230,"_27":231},{"_44":150,"_32":151,"_30":152,"_140":-5,"_42":43,"_41":153,"_142":25,"_39":226,"_13":155,"_34":156,"_36":157,"_24":25,"_147":-5,"_223":227,"_27":228},{"_44":138,"_32":139,"_30":58,"_140":-5,"_42":43,"_41":141,"_142":25,"_39":222,"_13":144,"_34":145,"_36":146,"_24":25,"_147":148,"_223":224,"_27":225},["D",1769213433354],"children",[],[139],["D",1769125325840],[],[151],["D",1769115491998],[],[160],["D",1769194566686],[],[167],"e75fb62e-f7d5-11f0-900b-42dde27851f2","types.ts","e75fb6ec-f7d5-11f0-900b-42dde27851f2",14,["D",1769115853001],"// Shared TypeScript interfaces for DC Hotspot Growth Map\n\nexport interface Hotspot {\n entity_key_str: string;\n key_to_asset_key: string;\n lat: number;\n long: number;\n created_at: string; // ISO date string\n first_seen_at: string;\n is_active: boolean;\n}\n\nexport interface DailySnapshot {\n snapshot_date: string; // YYYY-MM-DD\n total_count: number;\n new_count: number;\n}\n\nexport interface HeliumHotspotListItem {\n key_to_asset_key: string;\n entity_key_str: string;\n is_active: boolean;\n lat: number | null;\n long: number | null;\n}\n\nexport interface HeliumApiResponse {\n cursor: string | null;\n items: HeliumHotspotListItem[];\n}\n\n// DC Metro bounding box (~50 mile radius from center)\nexport const DC_BOUNDS = {\n minLat: 38.5,\n maxLat: 39.3,\n minLong: -77.5,\n maxLong: -76.7,\n};\n\nexport const DC_CENTER = {\n lat: 38.9072,\n long: -77.0369,\n};\n\nexport const HELIUM_API_BASE = \"https://entities.nft.helium.io/v2\";\n",[],[175,236],["D",1769115852719],[217],[175],"75917208-f81b-11f0-b8dd-42dde27851f2","style.css","1010cadc-f7d5-11f0-913f-42dde27851f2",114,["D",1769145726858],28,"/* DC Hotspot Growth Map - Helium-inspired dark theme */\n\n:root {\n --bg-primary: #04081b;\n --bg-secondary: rgba(255, 255, 255, 0.05);\n --bg-card: rgba(255, 255, 255, 0.08);\n --text-primary: #f7f7f7;\n --text-secondary: #7d7d7d;\n --accent-cyan: #4FC3F7;\n --accent-green: #00d97d;\n --accent-purple: #5e25fd;\n --border-color: rgba(255, 255, 255, 0.1);\n}\n\n* {\n box-sizing: border-box;\n margin: 0;\n padding: 0;\n}\n\nhtml, body, #root {\n height: 100%;\n width: 100%;\n overflow: hidden;\n}\n\nbody {\n font-family: 'Figtree', -apple-system, BlinkMacSystemFont, sans-serif;\n background: var(--bg-primary);\n color: var(--text-primary);\n}\n\n.app {\n display: flex;\n flex-direction: column;\n height: 100vh;\n height: 100dvh;\n width: 100vw;\n position: relative;\n}\n\n/* Stats Panel */\n.stats-panel {\n position: absolute;\n top: 16px;\n left: 16px;\n z-index: 1000;\n background: var(--bg-card);\n backdrop-filter: blur(15px);\n border: 1px solid var(--border-color);\n border-radius: 12px;\n padding: 16px;\n}\n\n.stats-panel h1 {\n font-size: 16px;\n font-weight: 500;\n margin-bottom: 2px;\n color: var(--accent-cyan);\n}\n\n.stats-panel .tagline {\n font-size: 11px;\n color: var(--text-secondary);\n margin-bottom: 12px;\n}\n\n.stat-card {\n display: flex;\n align-items: baseline;\n gap: 8px;\n flex-wrap: wrap;\n}\n\n.stat-label {\n font-size: 10px;\n text-transform: uppercase;\n letter-spacing: 0.05em;\n color: var(--text-secondary);\n font-weight: 400;\n}\n\n.stat-value {\n font-size: 28px;\n font-weight: 500;\n line-height: 1;\n color: var(--text-primary);\n}\n\n.stat-delta {\n font-size: 12px;\n font-weight: 400;\n color: var(--accent-green);\n transition: opacity 0.2s;\n}\n\n.stat-delta.hidden {\n display: none;\n}\n\n.stat-delta.negative {\n color: #e74c3c;\n}\n\n.current-date {\n font-size: 11px;\n color: var(--text-secondary);\n margin-top: 10px;\n padding-top: 10px;\n border-top: 1px solid var(--border-color);\n}\n\n.current-date strong {\n color: var(--text-primary);\n font-weight: 500;\n}\n\n/* Timeline Histogram - Interactive Scrubber */\n.timeline-histogram {\n display: flex;\n align-items: flex-end;\n gap: 0;\n height: 50px;\n margin-bottom: 8px;\n padding: 8px 12px;\n width: 100%;\n box-sizing: border-box;\n overflow: hidden;\n cursor: ew-resize;\n user-select: none;\n -webkit-user-select: none;\n touch-action: none;\n position: relative;\n background: rgba(0, 0, 0, 0.2);\n border-radius: 6px;\n}\n\n.histogram-bar {\n flex: 1 1 0;\n min-width: 0;\n background: var(--accent-purple);\n border-radius: 1px 1px 0 0;\n pointer-events: none;\n transition: opacity 0.1s;\n opacity: 0.5;\n}\n\n.timeline-histogram:hover .histogram-bar {\n opacity: 0.7;\n}\n\n.histogram-bar.capped {\n background: linear-gradient(to top, var(--accent-purple), var(--accent-green));\n}\n\n/* Playhead indicator */\n.histogram-playhead {\n position: absolute;\n top: 4px;\n bottom: 4px;\n width: 2px;\n background: var(--accent-cyan);\n pointer-events: none;\n box-shadow: 0 0 8px rgba(79, 195, 247, 0.6);\n transition: left 0.05s ease-out;\n transform: translateX(-50%);\n}\n\n.histogram-playhead::before {\n content: '';\n position: absolute;\n top: -3px;\n left: 50%;\n transform: translateX(-50%);\n width: 6px;\n height: 6px;\n background: var(--accent-cyan);\n border-radius: 50%;\n box-shadow: 0 0 6px rgba(79, 195, 247, 0.8);\n}\n\n/* Map Container */\n.map-container {\n flex: 1;\n position: relative;\n width: 100%;\n height: 100%;\n}\n\n/* Timeline - Floating Glass Pane */\n.timeline {\n position: absolute;\n bottom: 20px;\n left: 20px;\n right: 20px;\n bottom: calc(20px + env(safe-area-inset-bottom, 0px));\n z-index: 1000;\n background: var(--bg-card);\n backdrop-filter: blur(15px);\n border: 1px solid var(--border-color);\n border-radius: 12px;\n padding: 14px 16px;\n box-sizing: border-box;\n overflow: visible;\n}\n\n.timeline-inner {\n display: flex;\n align-items: center;\n gap: 16px;\n width: 100%;\n max-width: 100%;\n box-sizing: border-box;\n}\n\n.play-button {\n width: 48px;\n height: 48px;\n border-radius: 50%;\n background: var(--text-primary);\n border: none;\n cursor: pointer;\n display: flex;\n align-items: center;\n justify-content: center;\n font-size: 18px;\n color: var(--bg-primary);\n transition: transform 0.2s, background 0.2s;\n flex-shrink: 0;\n padding-left: 3px; /* Optical alignment for play triangle */\n}\n\n.play-button.playing {\n padding-left: 0; /* Reset for pause icon */\n}\n\n.play-button:hover {\n transform: scale(1.05);\n background: #e0e0e0;\n}\n\n.timeline-slider-container {\n flex: 1;\n min-width: 0;\n display: flex;\n flex-direction: column;\n gap: 6px;\n overflow: hidden;\n}\n\n.timeline-labels {\n display: flex;\n justify-content: space-between;\n font-size: 12px;\n color: var(--text-secondary);\n}\n\n/* Loading State */\n.loading {\n display: flex;\n flex-direction: column;\n align-items: center;\n justify-content: center;\n height: 100vh;\n gap: 16px;\n}\n\n.loading-spinner {\n width: 48px;\n height: 48px;\n border: 3px solid var(--border-color);\n border-top-color: var(--accent-cyan);\n border-radius: 50%;\n animation: spin 1s linear infinite;\n}\n\n@keyframes spin {\n to { transform: rotate(360deg); }\n}\n\n.loading-text {\n font-size: 16px;\n color: var(--text-secondary);\n}\n\n/* Empty State */\n.empty-state {\n display: flex;\n flex-direction: column;\n align-items: center;\n justify-content: center;\n height: 100vh;\n text-align: center;\n padding: 20px;\n}\n\n.empty-state h2 {\n font-size: 24px;\n margin-bottom: 16px;\n}\n\n.empty-state p {\n color: var(--text-secondary);\n margin-bottom: 24px;\n max-width: 400px;\n}\n\n.backfill-button {\n background: var(--accent-purple);\n color: white;\n border: none;\n padding: 12px 24px;\n border-radius: 8px;\n font-size: 14px;\n font-weight: 400;\n cursor: pointer;\n transition: background 0.2s;\n}\n\n.backfill-button:hover {\n background: #7b3ff2;\n}\n\n.backfill-button:disabled {\n background: var(--text-secondary);\n cursor: not-allowed;\n}\n\n/* Popup Container */\n.cluster-popup-container {\n pointer-events: auto;\n}\n\n/* Integrated Legend in Stats Panel */\n.legend-section {\n margin-top: 12px;\n padding-top: 12px;\n border-top: 1px solid var(--border-color);\n}\n\n.legend-items {\n display: flex;\n gap: 12px;\n}\n\n.legend-item {\n display: flex;\n align-items: center;\n gap: 5px;\n font-size: 11px;\n color: var(--text-secondary);\n}\n\n.legend-dot {\n width: 8px;\n height: 8px;\n border-radius: 50%;\n flex-shrink: 0;\n}\n\n.legend-dot.new {\n background: #2ecc71;\n}\n\n.legend-dot.recent {\n background: #3498db;\n}\n\n.legend-dot.established {\n background: #a0a0a0;\n}\n\n/* Cluster Popup Styling */\n.cluster-popup {\n font-size: 13px;\n line-height: 1.5;\n max-width: 280px;\n background: rgba(4, 8, 27, 0.95);\n backdrop-filter: blur(15px);\n border: 1px solid var(--border-color);\n border-radius: 8px;\n padding: 12px;\n color: var(--text-primary);\n font-family: 'Figtree', sans-serif;\n}\n\n.cluster-popup .cluster-count {\n font-size: 14px;\n font-weight: 500;\n color: var(--accent-cyan);\n margin-bottom: 10px;\n padding-bottom: 8px;\n border-bottom: 1px solid var(--border-color);\n}\n\n.cluster-popup .hotspot-list {\n list-style: none;\n padding: 0;\n margin: 0;\n max-height: 200px;\n overflow-y: auto;\n}\n\n.cluster-popup .hotspot-list li {\n padding: 4px 0;\n border-bottom: 1px solid rgba(255, 255, 255, 0.05);\n}\n\n.cluster-popup .hotspot-list li:last-child {\n border-bottom: none;\n}\n\n.cluster-popup .hotspot-list a {\n color: var(--accent-cyan);\n text-decoration: none;\n font-weight: 500;\n}\n\n.cluster-popup .hotspot-list a:hover {\n text-decoration: underline;\n}\n\n.cluster-popup .popup-more {\n margin-top: 8px;\n padding-top: 8px;\n border-top: 1px solid var(--border-color);\n color: var(--text-secondary);\n font-size: 12px;\n font-style: italic;\n}\n\n.cluster-popup .created-date {\n color: var(--text-secondary);\n font-size: 12px;\n}\n\n/* Responsive */\n@media (max-width: 768px) {\n .stats-panel {\n top: 10px;\n left: 10px;\n right: auto;\n min-width: auto;\n padding: 12px;\n }\n\n .stat-value {\n font-size: 24px;\n }\n\n .legend-items {\n gap: 8px;\n }\n\n .legend-item {\n font-size: 10px;\n }\n\n .timeline {\n left: 10px;\n right: 10px;\n bottom: calc(10px + env(safe-area-inset-bottom, 0px));\n padding: 12px;\n }\n\n .timeline-inner {\n gap: 10px;\n }\n\n .timeline-histogram {\n height: 40px;\n padding: 6px 10px;\n }\n\n .play-button {\n width: 36px;\n height: 36px;\n font-size: 14px;\n padding-left: 2px;\n }\n\n .play-button.playing {\n padding-left: 0;\n }\n\n .timeline-slider-container {\n gap: 4px;\n }\n\n .timeline-labels {\n font-size: 10px;\n }\n}\n",[],[182,247],"101773a0-f7d5-11f0-800a-42dde27851f2","index.tsx","1017744a-f7d5-11f0-800a-42dde27851f2",4,["D",1769115491804],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[182,256],"86b66d62-f817-11f0-ac3d-42dde27851f2","index.html","10239040-f7d5-11f0-b4d4-42dde27851f2",98,["D",1769144037644],3,"\n\n \n \n \n DC Helium Mobile Hotspot Growth\n \n \n \n \n \n \n \n

\n \n \n \n \n\n",[],[182,264],"10309f92-f7d5-11f0-be9d-42dde27851f2","favicon.svg","1030a050-f7d5-11f0-be9d-42dde27851f2",["D",1769115492011],"\n",[],[182,273],"34515420-f7e4-11f0-a6f6-42dde27851f2","animalHash.ts","f4ca8372-f7e2-11f0-b095-42dde27851f2","f4aa6a42-f7e2-11f0-94ff-42dde27851f2",49,["D",1769121995073],"// Exact implementation of angry-purple-tiger\n// https://github.com/helium/angry-purple-tiger\n// Using blueimp-md5 for correct MD5 hashing\n\nimport md5 from \"https://esm.sh/blueimp-md5@2.19.0\";\n\n// Word lists from the original library (exact order matters!)\nconst ADJECTIVES = [\n \"attractive\", \"bald\", \"beautiful\", \"rare\", \"clean\", \"dazzling\", \"lucky\", \"elegant\",\n \"fancy\", \"fit\", \"fantastic\", \"glamorous\", \"gorgeous\", \"handsome\", \"long\", \"magnificent\",\n \"muscular\", \"plain\", \"able\", \"quaint\", \"scruffy\", \"innocent\", \"short\", \"skinny\",\n \"acrobatic\", \"tall\", \"proper\", \"alert\", \"lone\", \"agreeable\", \"ambitious\", \"brave\",\n \"calm\", \"delightful\", \"eager\", \"faithful\", \"gentle\", \"happy\", \"jolly\", \"kind\",\n \"lively\", \"nice\", \"obedient\", \"polite\", \"proud\", \"silly\", \"thankful\", \"winning\",\n \"witty\", \"wonderful\", \"zealous\", \"expert\", \"amateur\", \"clumsy\", \"amusing\", \"vast\",\n \"fierce\", \"real\", \"helpful\", \"itchy\", \"atomic\", \"basic\", \"mysterious\", \"blurry\",\n \"perfect\", \"best\", \"powerful\", \"interesting\", \"decent\", \"wild\", \"jovial\", \"genuine\",\n \"broad\", \"brisk\", \"brilliant\", \"curved\", \"deep\", \"flat\", \"high\", \"hollow\", \"low\",\n \"narrow\", \"refined\", \"round\", \"shallow\", \"skinny\", \"square\", \"steep\", \"straight\", \"wide\",\n \"big\", \"colossal\", \"clever\", \"gigantic\", \"great\", \"huge\", \"immense\", \"large\",\n \"little\", \"mammoth\", \"massive\", \"micro\", \"mini\", \"petite\", \"puny\", \"scrawny\",\n \"small\", \"polished\", \"teeny\", \"tiny\", \"crazy\", \"dancing\", \"custom\", \"faint\",\n \"harsh\", \"formal\", \"howling\", \"loud\", \"melodic\", \"noisy\", \"upbeat\", \"quiet\",\n \"dandy\", \"raspy\", \"rhythmic\", \"daring\", \"zany\", \"digital\", \"dizzy\", \"exotic\",\n \"fun\", \"furry\", \"hidden\", \"ancient\", \"brief\", \"early\", \"fast\", \"future\", \"late\",\n \"modern\", \"old\", \"prehistoric\", \"zesty\", \"rapid\", \"slow\", \"swift\", \"young\",\n \"acidic\", \"bitter\", \"cool\", \"creamy\", \"keen\", \"tricky\", \"fresh\", \"special\",\n \"unique\", \"hot\", \"magic\", \"main\", \"nutty\", \"pet\", \"mythical\", \"ripe\", \"wobbly\",\n \"salty\", \"savory\", \"sour\", \"spicy\", \"bright\", \"stale\", \"sweet\", \"tangy\", \"tart\",\n \"rich\", \"rural\", \"urban\", \"breezy\", \"bumpy\", \"chilly\", \"cold\", \"cuddly\", \"damaged\",\n \"damp\", \"restless\", \"dry\", \"flaky\", \"fluffy\", \"virtual\", \"merry\", \"icy\", \"shiny\",\n \"melted\", \"joyous\", \"rough\", \"shaggy\", \"sharp\", \"radiant\", \"sticky\", \"strong\",\n \"soft\", \"uneven\", \"warm\", \"feisty\", \"cheery\", \"energetic\", \"abundant\", \"macho\",\n \"glorious\", \"mean\", \"quick\", \"precise\", \"stable\", \"spare\", \"sunny\", \"trendy\",\n \"shambolic\", \"striped\", \"boxy\", \"generous\", \"tame\", \"joyful\", \"festive\", \"bubbly\",\n \"soaring\", \"orbiting\", \"sparkly\", \"smooth\", \"docile\", \"original\", \"electric\",\n \"funny\", \"passive\", \"active\", \"cheesy\", \"blunt\", \"dapper\", \"bent\", \"curly\",\n \"oblong\", \"sneaky\", \"overt\", \"careful\", \"jumpy\", \"bouncy\", \"recumbent\", \"cheerful\",\n \"droll\", \"odd\", \"suave\", \"sleepy\",\n];\n\nconst COLORS = [\n \"white\", \"pearl\", \"alabaster\", \"snowy\", \"ivory\", \"cream\", \"cotton\", \"chiffon\",\n \"lace\", \"coconut\", \"linen\", \"bone\", \"daisy\", \"powder\", \"frost\", \"porcelain\",\n \"parchment\", \"velvet\", \"tan\", \"beige\", \"macaroon\", \"hazel\", \"felt\", \"metal\",\n \"gingham\", \"sand\", \"sepia\", \"latte\", \"vinyl\", \"glass\", \"hazelnut\", \"canvas\",\n \"wool\", \"yellow\", \"golden\", \"daffodil\", \"flaxen\", \"butter\", \"lemon\", \"mustard\",\n \"tartan\", \"blue\", \"cloth\", \"fiery\", \"banana\", \"plastic\", \"dijon\", \"honey\",\n \"blonde\", \"pineapple\", \"orange\", \"tangerine\", \"marigold\", \"cider\", \"rusty\",\n \"ginger\", \"tiger\", \"bronze\", \"fuzzy\", \"opaque\", \"clay\", \"carrot\", \"corduroy\",\n \"ceramic\", \"marmalade\", \"amber\", \"sandstone\", \"concrete\", \"red\", \"cherry\",\n \"hemp\", \"merlot\", \"garnet\", \"crimson\", \"ruby\", \"scarlet\", \"burlap\", \"brick\",\n \"bamboo\", \"mahogany\", \"blood\", \"sangria\", \"berry\", \"currant\", \"blush\", \"candy\",\n \"lipstick\", \"pink\", \"rose\", \"fuchsia\", \"punch\", \"watermelon\", \"rouge\", \"coral\",\n \"peach\", \"strawberry\", \"rosewood\", \"lemonade\", \"taffy\", \"bubblegum\", \"crepe\",\n \"hotpink\", \"purple\", \"mauve\", \"violet\", \"boysenberry\", \"lavender\", \"plum\",\n \"magenta\", \"lilac\", \"grape\", \"eggplant\", \"eggshell\", \"iris\", \"heather\", \"amethyst\",\n \"raisin\", \"orchid\", \"mulberry\", \"carbon\", \"slate\", \"sky\", \"navy\", \"indigo\",\n \"cobalt\", \"cedar\", \"ocean\", \"azure\", \"cerulean\", \"spruce\", \"stone\", \"aegean\",\n \"denim\", \"admiral\", \"sapphire\", \"arctic\", \"green\", \"chartreuse\", \"juniper\",\n \"sage\", \"lime\", \"fern\", \"olive\", \"emerald\", \"pear\", \"mossy\", \"shamrock\",\n \"seafoam\", \"pine\", \"mint\", \"seaweed\", \"pickle\", \"pistachio\", \"basil\", \"brown\",\n \"coffee\", \"chrome\", \"peanut\", \"carob\", \"hickory\", \"wooden\", \"pecan\", \"walnut\",\n \"caramel\", \"gingerbread\", \"syrup\", \"chocolate\", \"tortilla\", \"umber\", \"tawny\",\n \"brunette\", \"cinnamon\", \"glossy\", \"teal\", \"grey\", \"shadow\", \"graphite\", \"iron\",\n \"pewter\", \"cloud\", \"silver\", \"smoke\", \"gauze\", \"ash\", \"foggy\", \"flint\",\n \"charcoal\", \"pebble\", \"lead\", \"tin\", \"fossilized\", \"black\", \"ebony\", \"midnight\",\n \"inky\", \"oily\", \"satin\", \"onyx\", \"nylon\", \"fleece\", \"sable\", \"jetblack\", \"coal\",\n \"mocha\", \"obsidian\", \"jade\", \"cyan\", \"leather\", \"maroon\", \"carmine\", \"aqua\",\n \"chambray\", \"holographic\", \"laurel\", \"licorice\", \"khaki\", \"goldenrod\", \"malachite\",\n \"mandarin\", \"mango\", \"taupe\", \"aquamarine\", \"turquoise\", \"vermilion\", \"saffron\",\n \"cinnabar\", \"myrtle\", \"neon\", \"burgundy\", \"tangelo\", \"topaz\", \"wintergreen\",\n \"viridian\", \"vanilla\", \"paisley\", \"raspberry\", \"tweed\", \"pastel\", \"opal\",\n \"menthol\", \"champagne\", \"gunmetal\", \"infrared\", \"ultraviolet\", \"rainbow\",\n \"mercurial\", \"clear\", \"misty\", \"steel\", \"zinc\", \"citron\", \"cornflower\", \"lava\",\n \"quartz\", \"honeysuckle\", \"chili\",\n];\n\nconst ANIMALS = [\n \"alligator\", \"bee\", \"bird\", \"camel\", \"cat\", \"cheetah\", \"chicken\", \"cow\", \"dog\",\n \"corgi\", \"eagle\", \"elephant\", \"fish\", \"fox\", \"toad\", \"giraffe\", \"hippo\",\n \"kangaroo\", \"kitten\", \"lobster\", \"monkey\", \"octopus\", \"pig\", \"puppy\", \"rabbit\",\n \"rat\", \"scorpion\", \"seal\", \"sheep\", \"snail\", \"spider\", \"tiger\", \"turtle\", \"newt\",\n \"tadpole\", \"frog\", \"tarantula\", \"albatross\", \"blackbird\", \"canary\", \"crow\",\n \"cuckoo\", \"dove\", \"pigeon\", \"falcon\", \"finch\", \"flamingo\", \"goose\", \"seagull\",\n \"hawk\", \"jay\", \"mockingbird\", \"kestrel\", \"kookaburra\", \"mallard\", \"nightingale\",\n \"nuthatch\", \"ostrich\", \"owl\", \"parakeet\", \"parrot\", \"peacock\", \"pelican\",\n \"penguin\", \"pheasant\", \"piranha\", \"raven\", \"robin\", \"rooster\", \"sparrow\",\n \"stork\", \"swallow\", \"swan\", \"swift\", \"turkey\", \"vulture\", \"woodpecker\", \"wren\",\n \"butterfly\", \"barbel\", \"carp\", \"cod\", \"crab\", \"eel\", \"goldfish\", \"haddock\",\n \"halibut\", \"jellyfish\", \"perch\", \"pike\", \"mantaray\", \"salmon\", \"sawfish\",\n \"scallop\", \"shark\", \"shell\", \"shrimp\", \"trout\", \"ant\", \"aphid\", \"beetle\",\n \"caterpillar\", \"dragonfly\", \"cricket\", \"fly\", \"grasshopper\", \"ladybug\",\n \"millipede\", \"moth\", \"wasp\", \"anteater\", \"antelope\", \"armadillo\", \"badger\",\n \"bat\", \"beaver\", \"bull\", \"chimpanzee\", \"dachshund\", \"deer\", \"dolphin\", \"elk\",\n \"moose\", \"gazelle\", \"gerbil\", \"goat\", \"bear\", \"hamster\", \"hare\", \"hedgehog\",\n \"horse\", \"hyena\", \"lion\", \"llama\", \"lynx\", \"mammoth\", \"marmot\", \"mink\", \"mole\",\n \"mongoose\", \"mouse\", \"mule\", \"otter\", \"panda\", \"platypus\", \"pony\", \"porcupine\",\n \"puma\", \"raccoon\", \"reindeer\", \"rhino\", \"skunk\", \"sloth\", \"squirrel\", \"weasel\",\n \"snake\", \"wolf\", \"zebra\", \"boa\", \"chameleon\", \"copperhead\", \"cottonmouth\",\n \"crocodile\", \"rattlesnake\", \"gecko\", \"iguana\", \"lizard\", \"python\", \"salamander\",\n \"sidewinder\", \"whale\", \"tortoise\", \"lemur\", \"rook\", \"koala\", \"donkey\", \"ferret\",\n \"tardigrade\", \"orca\", \"okapi\", \"liger\", \"unicorn\", \"dragon\", \"squid\", \"ape\",\n \"gorilla\", \"baboon\", \"cormorant\", \"mantis\", \"tapir\", \"capybara\", \"pangolin\",\n \"opossum\", \"wombat\", \"aardvark\", \"starfish\", \"shetland\", \"narwhal\", \"worm\",\n \"hornet\", \"viper\", \"stallion\", \"jaguar\", \"panther\", \"bobcat\", \"leopard\",\n \"osprey\", \"cougar\", \"dalmatian\", \"terrier\", \"duck\", \"sealion\", \"chipmunk\",\n \"loris\", \"poodle\", \"orangutan\", \"gibbon\", \"meerkat\", \"huskie\", \"barracuda\",\n \"bison\", \"caribou\", \"chinchilla\", \"coyote\", \"crane\", \"dinosaur\", \"lark\",\n \"griffin\", \"yeti\", \"troll\", \"seahorse\", \"walrus\", \"yak\", \"wolverine\", \"boar\",\n \"alpaca\", \"porpoise\", \"manatee\", \"guppy\", \"condor\", \"cyborg\", \"cobra\", \"locust\",\n \"mandrill\", \"oyster\", \"urchin\", \"quail\", \"sardine\", \"ram\", \"starling\", \"wallaby\",\n \"buffalo\", \"goblin\", \"tuna\", \"mustang\",\n];\n\n// Compress bytes to target length using XOR (exact algorithm from library)\nfunction compress(bytes: number[], target: number): number[] {\n const length = bytes.length;\n const segSize = Math.floor(length / target);\n const segments: number[][] = [];\n\n for (let i = 0; i < segSize * target; i += segSize) {\n segments.push(bytes.slice(i, i + segSize));\n }\n\n // Add remaining bytes to last segment\n const lastSeg = segments[segments.length - 1];\n segments[segments.length - 1] = lastSeg.concat(bytes.slice(target * segSize));\n\n // XOR each segment to get checksums\n return segments.map(seg => seg.reduce((acc, curr) => acc ^ curr, 0));\n}\n\n// Convert hex string to byte array\nfunction hexToBytes(hex: string): number[] {\n const bytes: number[] = [];\n for (let i = 0; i < hex.length; i += 2) {\n bytes.push(parseInt(hex.substring(i, i + 2), 16));\n }\n return bytes;\n}\n\n// Generate animal name from input string (exact angry-purple-tiger algorithm)\nexport function animalHash(input: string): string {\n const hexDigest = md5(input);\n const bytes = hexToBytes(hexDigest);\n const compressed = compress(bytes, 3);\n\n const adjective = ADJECTIVES[compressed[0] % ADJECTIVES.length];\n const color = COLORS[compressed[1] % COLORS.length];\n const animal = ANIMALS[compressed[2] % ANIMALS.length];\n\n return `${adjective}-${color}-${animal}`;\n}\n",[],[182,288,280],"utils","f4aa697a-f7e2-11f0-94ff-42dde27851f2",41,["D",1769121458791],[211],[182,288],"7005387c-f890-11f0-94bf-42dde27851f2","App.tsx","102e094e-f7d5-11f0-88c4-42dde27851f2","0ff6303c-f7d5-11f0-9712-42dde27851f2",116,["D",1769195968672],42,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useMemo, useCallback, useRef } from \"https://esm.sh/react@18.2.0\";\nimport * as h3 from \"https://esm.sh/h3-js@4.1.0\";\nimport { animalHash } from \"../utils/animalHash.ts\";\n\n// deck.gl types (loaded from CDN script)\ndeclare const deck: any;\n\n// Types\ninterface Hotspot {\n entity_key_str: string;\n lat: number;\n long: number;\n created_at: string;\n first_seen_at: string;\n}\n\ninterface DailySnapshot {\n snapshot_date: string;\n total_count: number;\n new_count: number;\n}\n\ninterface H3Cluster {\n h3Index: string;\n hotspots: Hotspot[];\n center: [number, number];\n newestDate: string;\n count: number;\n}\n\nconst DC_CENTER = { lat: 38.9072, lng: -77.0369 };\nconst H3_RESOLUTION = 8;\n\n// Calculate days between two dates\nfunction daysBetween(date1: string, date2: string): number {\n const d1 = new Date(date1);\n const d2 = new Date(date2);\n return Math.floor((d2.getTime() - d1.getTime()) / (1000 * 60 * 60 * 24));\n}\n\n// Convert kebab-case to Title Case\nfunction toTitleCase(str: string): string {\n return str.split(\"-\").map(word => word.charAt(0).toUpperCase() + word.slice(1)).join(\" \");\n}\n\n// Get color based on hotspot age [R, G, B, A]\nfunction getHotspotColor(createdAt: string, selectedDate: string, isEstablished: boolean): [number, number, number, number] {\n const age = daysBetween(createdAt, selectedDate);\n const alpha = isEstablished ? 128 : 179; // 0.5 or 0.7 * 255\n if (age < 7) return [46, 204, 113, alpha]; // Green - new\n if (age < 30) return [52, 152, 219, alpha]; // Blue - recent\n return [160, 160, 160, alpha]; // Grey - established\n}\n\n// Group hotspots into H3 clusters\nfunction clusterHotspots(hotspots: Hotspot[]): H3Cluster[] {\n const clusters = new Map();\n\n for (const hotspot of hotspots) {\n const h3Index = h3.latLngToCell(hotspot.lat, hotspot.long, H3_RESOLUTION);\n if (!clusters.has(h3Index)) {\n clusters.set(h3Index, []);\n }\n clusters.get(h3Index)!.push(hotspot);\n }\n\n const result: H3Cluster[] = [];\n for (const [h3Index, clusterHotspots] of clusters) {\n const center = h3.cellToLatLng(h3Index) as [number, number];\n const newestDate = clusterHotspots.reduce((newest, h) =>\n h.created_at > newest ? h.created_at : newest,\n clusterHotspots[0].created_at\n );\n\n result.push({\n h3Index,\n hotspots: clusterHotspots,\n center,\n newestDate,\n count: clusterHotspots.length,\n });\n }\n\n return result;\n}\n\n// Calculate circle radius with sqrt easing\nfunction getClusterRadius(count: number): number {\n const minRadius = 8;\n const maxRadius = 35;\n const maxCount = 70;\n\n if (count <= 1) return minRadius;\n if (count >= maxCount) return maxRadius;\n\n const normalizedCount = Math.sqrt(count - 1) / Math.sqrt(maxCount - 1);\n return minRadius + (maxRadius - minRadius) * normalizedCount;\n}\n\nexport function App() {\n const [hotspots, setHotspots] = useState([]);\n const [snapshots, setSnapshots] = useState([]);\n // Use index instead of date string for faster playback\n const [selectedIdx, setSelectedIdx] = useState(-1);\n const [isPlaying, setIsPlaying] = useState(false);\n const [loading, setLoading] = useState(true);\n const [backfilling, setBackfilling] = useState(false);\n const [error, setError] = useState(null);\n const [tooltip, setTooltip] = useState<{ x: number; y: number; cluster: H3Cluster } | null>(null);\n\n const mapContainerRef = useRef(null);\n const deckRef = useRef(null);\n const canvasRef = useRef(null);\n const histogramRef = useRef(null);\n const [isDragging, setIsDragging] = useState(false);\n const animationRef = useRef(null);\n const lastFrameTimeRef = useRef(0);\n\n // Load data on mount\n useEffect(() => {\n async function loadData() {\n try {\n const [hotspotsRes, snapshotsRes] = await Promise.all([\n fetch(\"/api/hotspots\"),\n fetch(\"/api/snapshots\"),\n ]);\n\n if (!hotspotsRes.ok || !snapshotsRes.ok) {\n throw new Error(\"Failed to fetch data\");\n }\n\n const hotspotsData = await hotspotsRes.json();\n const snapshotsData = await snapshotsRes.json();\n\n setHotspots(hotspotsData);\n setSnapshots(snapshotsData);\n\n if (snapshotsData.length > 0) {\n setSelectedIdx(snapshotsData.length - 1);\n }\n } catch (e) {\n console.error(\"Error loading data:\", e);\n setError(String(e));\n } finally {\n setLoading(false);\n }\n }\n loadData();\n }, []);\n\n // Derive selectedDate from index\n const selectedDate = useMemo(() => {\n if (selectedIdx >= 0 && selectedIdx < snapshots.length) {\n return snapshots[selectedIdx].snapshot_date;\n }\n return new Date().toISOString().split(\"T\")[0];\n }, [selectedIdx, snapshots]);\n\n // Pre-compute clusters for all dates (memoized once when data loads)\n // This avoids expensive H3 clustering on every playback frame\n const clustersByDate = useMemo(() => {\n if (hotspots.length === 0 || snapshots.length === 0) return new Map();\n\n const result = new Map();\n\n // Sort hotspots by created_at for efficient incremental building\n const sortedHotspots = [...hotspots].sort((a, b) => a.created_at.localeCompare(b.created_at));\n\n let currentHotspots: Hotspot[] = [];\n let hotspotIdx = 0;\n\n for (const snapshot of snapshots) {\n const date = snapshot.snapshot_date;\n\n // Add hotspots created on or before this date\n while (hotspotIdx < sortedHotspots.length && sortedHotspots[hotspotIdx].created_at <= date) {\n currentHotspots.push(sortedHotspots[hotspotIdx]);\n hotspotIdx++;\n }\n\n // Cluster the current set of hotspots\n result.set(date, clusterHotspots([...currentHotspots]));\n }\n\n return result;\n }, [hotspots, snapshots]);\n\n // Get clusters for current date (O(1) lookup instead of O(n) computation)\n const clusters = useMemo(() => {\n return clustersByDate.get(selectedDate) || [];\n }, [clustersByDate, selectedDate]);\n\n // Filter hotspots for selected date (only needed for stats, not rendering)\n const visibleHotspots = useMemo(() => {\n return hotspots.filter(h => h.created_at <= selectedDate);\n }, [hotspots, selectedDate]);\n\n // Initialize deck.gl\n useEffect(() => {\n if (!mapContainerRef.current || deckRef.current) return;\n\n // Create canvas for deck.gl\n const canvas = document.createElement(\"canvas\");\n canvas.style.position = \"absolute\";\n canvas.style.top = \"0\";\n canvas.style.left = \"0\";\n canvas.style.width = \"100%\";\n canvas.style.height = \"100%\";\n mapContainerRef.current.appendChild(canvas);\n canvasRef.current = canvas;\n\n const deckInstance = new deck.Deck({\n canvas,\n initialViewState: {\n longitude: DC_CENTER.lng,\n latitude: DC_CENTER.lat,\n zoom: 11,\n pitch: 0,\n bearing: 0,\n },\n controller: true,\n layers: [],\n getTooltip: null,\n });\n\n deckRef.current = deckInstance;\n\n // Handle resize\n const resizeObserver = new ResizeObserver(() => {\n if (deckRef.current && mapContainerRef.current) {\n const { width, height } = mapContainerRef.current.getBoundingClientRect();\n canvas.width = width * window.devicePixelRatio;\n canvas.height = height * window.devicePixelRatio;\n canvas.style.width = `${width}px`;\n canvas.style.height = `${height}px`;\n deckRef.current.setProps({ width, height });\n }\n });\n resizeObserver.observe(mapContainerRef.current);\n\n return () => {\n resizeObserver.disconnect();\n if (deckRef.current) {\n deckRef.current.finalize();\n deckRef.current = null;\n }\n if (canvasRef.current) {\n canvasRef.current.remove();\n canvasRef.current = null;\n }\n };\n }, [loading]);\n\n // Update deck.gl layers when clusters change\n useEffect(() => {\n if (!deckRef.current) return;\n\n // Base map tile layer (CartoDB dark)\n const tileLayer = new deck.TileLayer({\n id: \"base-map\",\n data: \"https://basemaps.cartocdn.com/dark_all/{z}/{x}/{y}@2x.png\",\n minZoom: 0,\n maxZoom: 19,\n tileSize: 256,\n renderSubLayers: (props: any) => {\n const { boundingBox } = props.tile;\n return new deck.BitmapLayer(props, {\n data: null,\n image: props.data,\n bounds: [boundingBox[0][0], boundingBox[0][1], boundingBox[1][0], boundingBox[1][1]],\n });\n },\n });\n\n // During playback, use shorter transitions for snappier updates\n const transitionDuration = isPlaying ? 0 : 150;\n\n const scatterLayer = new deck.ScatterplotLayer({\n id: \"hotspot-clusters\",\n data: clusters,\n pickable: true,\n stroked: false,\n filled: true,\n radiusUnits: \"pixels\",\n getPosition: (d: H3Cluster) => [d.center[1], d.center[0]],\n getRadius: (d: H3Cluster) => getClusterRadius(d.count),\n getFillColor: (d: H3Cluster) => {\n const age = daysBetween(d.newestDate, selectedDate);\n const isEstablished = age >= 30;\n return getHotspotColor(d.newestDate, selectedDate, isEstablished);\n },\n // Disable transitions during playback for snappier animation\n transitions: transitionDuration > 0 ? {\n getRadius: { duration: transitionDuration, easing: (t: number) => t },\n getFillColor: { duration: transitionDuration },\n } : undefined,\n onClick: ({ object, x, y }: { object: H3Cluster; x: number; y: number }) => {\n if (object) {\n setTooltip({ x, y, cluster: object });\n }\n },\n updateTriggers: {\n getRadius: [selectedDate],\n getFillColor: [selectedDate],\n },\n });\n\n // Text layer for cluster count labels\n const textLayer = new deck.TextLayer({\n id: \"cluster-labels\",\n data: clusters.filter((c: H3Cluster) => c.count > 1), // Only show labels for count > 1\n pickable: false,\n getPosition: (d: H3Cluster) => [d.center[1], d.center[0]],\n getText: (d: H3Cluster) => String(d.count),\n getSize: 12,\n getColor: [255, 255, 255, 230],\n getTextAnchor: \"middle\",\n getAlignmentBaseline: \"center\",\n fontFamily: \"Figtree, sans-serif\",\n fontWeight: 300,\n outlineWidth: 0,\n outlineColor: [0, 0, 0, 150],\n billboard: false,\n sizeUnits: \"pixels\",\n updateTriggers: {\n getText: [selectedDate],\n },\n });\n\n deckRef.current.setProps({ layers: [tileLayer, scatterLayer, textLayer] });\n }, [clusters, selectedDate, isPlaying]);\n\n // Get stats for selected date\n const currentStats = useMemo(() => {\n const snapshot = snapshots.find(s => s.snapshot_date === selectedDate);\n return snapshot || { total_count: visibleHotspots.length, new_count: 0 };\n }, [snapshots, selectedDate, visibleHotspots]);\n\n // Timeline playback using requestAnimationFrame for smooth animation\n useEffect(() => {\n if (!isPlaying || snapshots.length === 0) return;\n\n const FRAME_INTERVAL = 33; // ~30fps for smooth playback (faster than this looks rushed)\n\n const animate = (timestamp: number) => {\n if (timestamp - lastFrameTimeRef.current >= FRAME_INTERVAL) {\n lastFrameTimeRef.current = timestamp;\n\n setSelectedIdx(prev => {\n if (prev >= snapshots.length - 1) {\n setIsPlaying(false);\n return prev;\n }\n return prev + 1;\n });\n }\n\n animationRef.current = requestAnimationFrame(animate);\n };\n\n lastFrameTimeRef.current = performance.now();\n animationRef.current = requestAnimationFrame(animate);\n\n return () => {\n if (animationRef.current !== null) {\n cancelAnimationFrame(animationRef.current);\n animationRef.current = null;\n }\n };\n }, [isPlaying, snapshots.length]);\n\n // Handle histogram scrub/click - calculate which snapshot index based on mouse position\n const getSnapshotIdxFromMouseEvent = useCallback((clientX: number): number => {\n if (!histogramRef.current || snapshots.length === 0) return -1;\n\n const rect = histogramRef.current.getBoundingClientRect();\n const padding = 12; // Match CSS padding\n const x = clientX - rect.left - padding;\n const contentWidth = rect.width - (padding * 2);\n const percentage = Math.max(0, Math.min(1, x / contentWidth));\n return Math.round(percentage * (snapshots.length - 1));\n }, [snapshots.length]);\n\n const handleHistogramMouseDown = useCallback((e: React.MouseEvent) => {\n setIsDragging(true);\n const idx = getSnapshotIdxFromMouseEvent(e.clientX);\n if (idx >= 0) {\n setSelectedIdx(idx);\n setIsPlaying(false);\n }\n }, [getSnapshotIdxFromMouseEvent]);\n\n const handleHistogramMouseMove = useCallback((e: React.MouseEvent) => {\n if (!isDragging) return;\n const idx = getSnapshotIdxFromMouseEvent(e.clientX);\n if (idx >= 0) {\n setSelectedIdx(idx);\n }\n }, [isDragging, getSnapshotIdxFromMouseEvent]);\n\n const handleHistogramMouseUp = useCallback(() => {\n setIsDragging(false);\n }, []);\n\n const handleHistogramMouseLeave = useCallback(() => {\n setIsDragging(false);\n }, []);\n\n // Touch support for mobile\n const handleHistogramTouchStart = useCallback((e: React.TouchEvent) => {\n setIsDragging(true);\n const idx = getSnapshotIdxFromMouseEvent(e.touches[0].clientX);\n if (idx >= 0) {\n setSelectedIdx(idx);\n setIsPlaying(false);\n }\n }, [getSnapshotIdxFromMouseEvent]);\n\n const handleHistogramTouchMove = useCallback((e: React.TouchEvent) => {\n if (!isDragging) return;\n const idx = getSnapshotIdxFromMouseEvent(e.touches[0].clientX);\n if (idx >= 0) {\n setSelectedIdx(idx);\n }\n }, [isDragging, getSnapshotIdxFromMouseEvent]);\n\n const handleHistogramTouchEnd = useCallback(() => {\n setIsDragging(false);\n }, []);\n\n // Handle play button\n const handlePlayClick = useCallback(() => {\n if (isPlaying) {\n setIsPlaying(false);\n } else {\n // Reset to beginning if at end\n if (selectedIdx >= snapshots.length - 1 && snapshots.length > 0) {\n setSelectedIdx(0);\n }\n setIsPlaying(true);\n }\n }, [isPlaying, snapshots.length, selectedIdx]);\n\n // Handle backfill\n const handleBackfill = async () => {\n setBackfilling(true);\n try {\n const res = await fetch(\"/api/admin/backfill\", { method: \"POST\" });\n if (!res.ok) throw new Error(\"Backfill failed\");\n window.location.reload();\n } catch (e) {\n setError(String(e));\n } finally {\n setBackfilling(false);\n }\n };\n\n // Close tooltip when clicking outside\n const handleMapClick = useCallback((e: React.MouseEvent) => {\n if ((e.target as HTMLElement).closest(\".cluster-popup\")) return;\n setTooltip(null);\n }, []);\n\n if (loading) {\n return (\n

Loading Hotspot data...

\n );\n }\n\n if (hotspots.length === 0) {\n return (\n

No Hotspot Data

\n No Hotspots have been loaded yet. Click the button below to fetch\n DC area Hotspots from the Helium API.\n

\n \n {backfilling ? \"Loading Hotspots...\" : \"Load DC Hotspots\"}\n \n {error &&

{error}

}\n

\n );\n }\n\n const currentIdx = selectedIdx >= 0 ? selectedIdx : 0;\n const minDate = snapshots.length > 0 ? snapshots[0].snapshot_date : selectedDate;\n const maxDate = snapshots.length > 0 ? snapshots[snapshots.length - 1].snapshot_date : selectedDate;\n\n return (\n

\n {/* Stats Panel with Legend */}\n

DC Hotspot Growth

Helium Mobile Hotspots in the DC Metro area

\n\n

Total Hotspots

{currentStats.total_count.toLocaleString()}

\n +{currentStats.new_count} new\n

\n\n

\n Showing: {selectedDate}\n

\n\n {/* Integrated Legend */}\n

\n < 7d\n

\n < 30d\n

\n 30d+\n

\n\n {/* Map Container */}\n \n {/* Tooltip/Popup */}\n {tooltip && (\n \n

\n {tooltip.cluster.count} Hotspot{tooltip.cluster.count !== 1 ? \"s\" : \"\"}\n

\n {name}\n ({h.created_at})\n

\n {tooltip.cluster.count > 10 && (\n

...and {tooltip.cluster.count - 10} more

\n )}\n

\n )}\n \n\n {/* Timeline with Histogram */}\n {snapshots.length > 0 && (\n

\n \n {isPlaying ? \"⏸\" : \"▶\"}\n \n\n

\n {/* Interactive Histogram */}\n \n {(() => {\n const cappedMax = 10;\n return snapshots.map((snapshot) => {\n const cappedCount = Math.min(snapshot.new_count, cappedMax);\n const height = (cappedCount / cappedMax) * 100;\n const isCapped = snapshot.new_count > cappedMax;\n return (\n \n );\n });\n })()}\n {/* Playhead indicator - centered on each bar, accounting for padding */}\n \n

\n {minDate}\n {maxDate}\n

\n \n )}\n \n );\n}\n",[],[182,304,295],"components","0ff62f6a-f7d5-11f0-9712-42dde27851f2",2,["D",1769115491600],[209],[182,304],["D",1769115491425],[208,210,212,213,214,215],[182],"f4c69ab4-f7e2-11f0-94ff-42dde27851f2","scraper.ts","e78c46bc-f7d5-11f0-858d-42dde27851f2",["D",1769121458973],"// Backfill and daily scraper for DC Hotspot Growth Map\nimport * as db from \"./db.ts\";\nimport * as helium from \"./heliumApi.ts\";\n\ninterface BackfillResult {\n processed: number;\n dcHotspots: number;\n newHotspots: number;\n skipped: number;\n errors: number;\n}\n\n// Run incremental backfill - only adds hotspots not already in database\nexport async function runBackfill(): Promise {\n await db.initDatabase();\n\n const result: BackfillResult = {\n processed: 0,\n dcHotspots: 0,\n newHotspots: 0,\n skipped: 0,\n errors: 0,\n };\n\n const today = new Date().toISOString().split(\"T\")[0];\n\n console.log(\"Starting incremental backfill of DC area Hotspots...\");\n\n // Get existing hotspots to skip\n const existing = await db.getAllHotspots();\n const existingKeys = new Set(existing.map(h => h.entity_key_str));\n console.log(`Found ${existingKeys.size} existing Hotspots in database`);\n\n // Fetch all DC hotspots\n const dcHotspots = await helium.fetchAllDCHotspots((processed, dcCount, cursor) => {\n if (processed % 1000 === 0) {\n console.log(`Processed ${processed} Hotspots, found ${dcCount} in DC area`);\n }\n result.processed = processed;\n });\n\n result.dcHotspots = dcHotspots.length;\n console.log(`Found ${dcHotspots.length} Hotspots in DC area. Fetching details for new ones...`);\n\n // Insert each new DC hotspot\n for (const hotspot of dcHotspots) {\n // Skip if already exists\n if (existingKeys.has(hotspot.entity_key_str)) {\n result.skipped++;\n continue;\n }\n\n try {\n // Try to get created_at from individual endpoint\n let created_at = today;\n try {\n const details = await helium.fetchHotspotDetails(hotspot.key_to_asset_key);\n if (details.created_at) {\n created_at = details.created_at.split(\"T\")[0]; // Extract date part\n }\n } catch (e) {\n // Use today as fallback\n }\n\n await db.upsertHotspot({\n entity_key_str: hotspot.entity_key_str,\n key_to_asset_key: hotspot.key_to_asset_key,\n lat: hotspot.lat!,\n long: hotspot.long!,\n created_at,\n first_seen_at: today,\n is_active: true,\n });\n\n result.newHotspots++;\n\n // Reduced rate limit for faster processing\n await helium.sleep(25);\n\n if (result.newHotspots % 50 === 0) {\n console.log(`Inserted ${result.newHotspots} new DC Hotspots`);\n }\n } catch (e) {\n console.error(`Error processing Hotspot ${hotspot.entity_key_str}:`, e);\n result.errors++;\n }\n }\n\n // Compute historical snapshots if we added new hotspots\n if (result.newHotspots > 0) {\n console.log(\"Computing historical snapshots...\");\n await db.computeHistoricalSnapshots();\n }\n\n console.log(`Backfill complete: ${result.newHotspots} new Hotspots, ${result.skipped} skipped, ${result.errors} errors`);\n return result;\n}\n\n// Run daily incremental scrape\nexport async function runDailyScrape(): Promise<{\n newHotspots: number;\n updated: number;\n removed: number;\n}> {\n await db.initDatabase();\n\n const today = new Date().toISOString().split(\"T\")[0];\n const stats = { newHotspots: 0, updated: 0, removed: 0 };\n\n console.log(`Starting daily scrape for ${today}...`);\n\n // Get existing hotspots for comparison\n const existing = await db.getAllHotspots();\n const existingMap = new Map(existing.map(h => [h.entity_key_str, h]));\n const seenKeys = new Set();\n\n // Fetch all DC hotspots\n const dcHotspots = await helium.fetchAllDCHotspots();\n\n for (const hotspot of dcHotspots) {\n if (!hotspot.lat || !hotspot.long) continue;\n\n seenKeys.add(hotspot.entity_key_str);\n const existingHotspot = existingMap.get(hotspot.entity_key_str);\n\n if (!existingHotspot) {\n // New hotspot\n let created_at = today;\n try {\n const details = await helium.fetchHotspotDetails(hotspot.key_to_asset_key);\n if (details.created_at) {\n created_at = details.created_at.split(\"T\")[0];\n }\n } catch (e) {\n // Use today as fallback\n }\n\n await db.upsertHotspot({\n entity_key_str: hotspot.entity_key_str,\n key_to_asset_key: hotspot.key_to_asset_key,\n lat: hotspot.lat,\n long: hotspot.long,\n created_at,\n first_seen_at: today,\n is_active: true,\n });\n\n stats.newHotspots++;\n await helium.sleep(25);\n } else {\n // Check for location change\n const threshold = 0.0001; // ~11 meters\n if (\n Math.abs(existingHotspot.lat - hotspot.lat) > threshold ||\n Math.abs(existingHotspot.long - hotspot.long) > threshold\n ) {\n await db.recordLocationChange(hotspot.entity_key_str, hotspot.lat, hotspot.long, today);\n await db.upsertHotspot({\n ...existingHotspot,\n lat: hotspot.lat,\n long: hotspot.long,\n });\n stats.updated++;\n }\n }\n }\n\n // Compute historical snapshots to update with any new dates\n await db.computeHistoricalSnapshots();\n\n // Create daily snapshot\n const totalCount = await db.getHotspotCount();\n await db.upsertSnapshot({\n snapshot_date: today,\n total_count: totalCount,\n new_count: stats.newHotspots,\n });\n\n console.log(`Daily scrape complete: ${stats.newHotspots} new, ${stats.updated} updated`);\n return stats;\n}\n",[],[187,314],"19c58cea-f8b9-11f0-801d-42dde27851f2","migrate.ts","19c58d8a-f8b9-11f0-801d-42dde27851f2",119,["D",1769213433340],"// Migration script to copy data from old sqlite to new Turso sqlite\nimport { sqlite as oldSqlite } from \"https://esm.town/v/std/sqlite\";\nimport newSqlite from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\nimport type { Hotspot, DailySnapshot } from \"../shared/types.ts\";\n\n// Read all hotspots from old database\nasync function getOldHotspots(): Promise {\n const result = await oldSqlite.execute(`\n SELECT entity_key_str, key_to_asset_key, lat, long, created_at, first_seen_at, is_active\n FROM hotspots\n ORDER BY created_at ASC\n LIMIT 10000\n `);\n\n const columns = result.columns || [];\n return result.rows.map((row: any) => {\n if (Array.isArray(row)) {\n const obj: any = {};\n columns.forEach((col: string, i: number) => {\n obj[col] = row[i];\n });\n return {\n entity_key_str: obj.entity_key_str as string,\n key_to_asset_key: obj.key_to_asset_key as string,\n lat: obj.lat as number,\n long: obj.long as number,\n created_at: obj.created_at as string,\n first_seen_at: obj.first_seen_at as string,\n is_active: Boolean(obj.is_active),\n };\n }\n return {\n entity_key_str: row.entity_key_str as string,\n key_to_asset_key: row.key_to_asset_key as string,\n lat: row.lat as number,\n long: row.long as number,\n created_at: row.created_at as string,\n first_seen_at: row.first_seen_at as string,\n is_active: Boolean(row.is_active),\n };\n });\n}\n\n// Read all snapshots from old database\nasync function getOldSnapshots(): Promise {\n const result = await oldSqlite.execute(`\n SELECT snapshot_date, total_count, new_count\n FROM daily_snapshots\n ORDER BY snapshot_date ASC\n `);\n\n const columns = result.columns || [];\n return result.rows.map((row: any) => {\n if (Array.isArray(row)) {\n const obj: any = {};\n columns.forEach((col: string, i: number) => {\n obj[col] = row[i];\n });\n return {\n snapshot_date: obj.snapshot_date as string,\n total_count: obj.total_count as number,\n new_count: obj.new_count as number,\n };\n }\n return {\n snapshot_date: row.snapshot_date as string,\n total_count: row.total_count as number,\n new_count: row.new_count as number,\n };\n });\n}\n\n// Initialize new database schema\nasync function initNewDatabase() {\n await newSqlite.execute(`\n CREATE TABLE IF NOT EXISTS hotspots (\n id INTEGER PRIMARY KEY,\n entity_key_str TEXT UNIQUE NOT NULL,\n key_to_asset_key TEXT NOT NULL,\n lat REAL NOT NULL,\n long REAL NOT NULL,\n created_at TEXT NOT NULL,\n first_seen_at TEXT NOT NULL,\n is_active INTEGER DEFAULT 1\n )\n `);\n\n await newSqlite.execute(`\n CREATE TABLE IF NOT EXISTS hotspot_locations (\n id INTEGER PRIMARY KEY,\n entity_key_str TEXT NOT NULL,\n lat REAL NOT NULL,\n long REAL NOT NULL,\n observed_at TEXT NOT NULL\n )\n `);\n\n await newSqlite.execute(`\n CREATE TABLE IF NOT EXISTS daily_snapshots (\n snapshot_date TEXT PRIMARY KEY,\n total_count INTEGER NOT NULL,\n new_count INTEGER NOT NULL\n )\n `);\n\n await newSqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_hotspots_created ON hotspots(created_at)\n `);\n await newSqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_snapshots_date ON daily_snapshots(snapshot_date)\n `);\n}\n\n// Insert hotspots into new database\nasync function insertHotspotsToNew(hotspots: Hotspot[]) {\n for (const hotspot of hotspots) {\n await newSqlite.execute({\n sql: `\n INSERT INTO hotspots (entity_key_str, key_to_asset_key, lat, long, created_at, first_seen_at, is_active)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(entity_key_str) DO UPDATE SET\n lat = excluded.lat,\n long = excluded.long,\n is_active = excluded.is_active\n `,\n args: [\n hotspot.entity_key_str,\n hotspot.key_to_asset_key,\n hotspot.lat,\n hotspot.long,\n hotspot.created_at,\n hotspot.first_seen_at,\n hotspot.is_active ? 1 : 0,\n ],\n });\n }\n}\n\n// Insert snapshots into new database\nasync function insertSnapshotsToNew(snapshots: DailySnapshot[]) {\n for (const snapshot of snapshots) {\n await newSqlite.execute({\n sql: `\n INSERT INTO daily_snapshots (snapshot_date, total_count, new_count)\n VALUES (?, ?, ?)\n ON CONFLICT(snapshot_date) DO UPDATE SET\n total_count = excluded.total_count,\n new_count = excluded.new_count\n `,\n args: [snapshot.snapshot_date, snapshot.total_count, snapshot.new_count],\n });\n }\n}\n\n// Get counts from new database to verify\nasync function getNewCounts(): Promise<{ hotspots: number; snapshots: number }> {\n const hotspotsResult = await newSqlite.execute(`SELECT COUNT(*) as count FROM hotspots`);\n const snapshotsResult = await newSqlite.execute(`SELECT COUNT(*) as count FROM daily_snapshots`);\n\n const hotspotRow = hotspotsResult.rows[0];\n const snapshotRow = snapshotsResult.rows[0];\n\n return {\n hotspots: (Array.isArray(hotspotRow) ? hotspotRow[0] : hotspotRow.count) as number,\n snapshots: (Array.isArray(snapshotRow) ? snapshotRow[0] : snapshotRow.count) as number,\n };\n}\n\n// Run the full migration\nexport async function runMigration() {\n console.log(\"Starting migration from old sqlite to new Turso sqlite...\");\n\n // Step 1: Read from old database\n console.log(\"Reading hotspots from old database...\");\n const hotspots = await getOldHotspots();\n console.log(`Found ${hotspots.length} hotspots in old database`);\n\n console.log(\"Reading snapshots from old database...\");\n const snapshots = await getOldSnapshots();\n console.log(`Found ${snapshots.length} snapshots in old database`);\n\n // Step 2: Initialize new database schema\n console.log(\"Initializing new database schema...\");\n await initNewDatabase();\n\n // Step 3: Insert data into new database\n console.log(\"Inserting hotspots into new database...\");\n await insertHotspotsToNew(hotspots);\n\n console.log(\"Inserting snapshots into new database...\");\n await insertSnapshotsToNew(snapshots);\n\n // Step 4: Verify counts\n console.log(\"Verifying migration...\");\n const newCounts = await getNewCounts();\n\n console.log(\"Migration complete!\");\n return {\n success: true,\n old: {\n hotspots: hotspots.length,\n snapshots: snapshots.length,\n },\n new: newCounts,\n verified: newCounts.hotspots === hotspots.length && newCounts.snapshots === snapshots.length,\n };\n}\n",[],[187,321],"0ff3587c-f7d9-11f0-b918-42dde27851f2","heliumApi.ts","e7738db6-f7d5-11f0-b958-42dde27851f2",["D",1769117209587],"// Helium Entity API client\nimport { HELIUM_API_BASE, DC_BOUNDS, type HeliumApiResponse, type HeliumHotspotListItem } from \"../shared/types.ts\";\n\nconst RATE_LIMIT_MS = 100; // 10 requests per second max\n\n// Fetch paginated mobile hotspots\nexport async function fetchMobileHotspots(cursor?: string | null): Promise {\n const url = new URL(`${HELIUM_API_BASE}/hotspots`);\n url.searchParams.set(\"subnetwork\", \"mobile\");\n if (cursor) {\n url.searchParams.set(\"cursor\", cursor);\n }\n\n const response = await fetch(url.toString());\n if (!response.ok) {\n throw new Error(`Helium API error: ${response.status} ${response.statusText}`);\n }\n\n return response.json();\n}\n\n// Fetch individual hotspot details\nexport async function fetchHotspotDetails(keyToAssetKey: string): Promise<{ created_at?: string; info?: any }> {\n const url = `${HELIUM_API_BASE}/hotspot/${keyToAssetKey}`;\n\n const response = await fetch(url);\n if (!response.ok) {\n if (response.status === 404) {\n return {}; // Hotspot details not available\n }\n throw new Error(`Helium API error: ${response.status}`);\n }\n\n const data = await response.json();\n\n // Extract created_at from hotspot_infos.mobile if available\n const mobileInfo = data.hotspot_infos?.mobile;\n if (mobileInfo?.created_at) {\n return { created_at: mobileInfo.created_at, info: data };\n }\n\n return { info: data };\n}\n\n// Check if coordinates are within DC Metro area\nexport function isInDCArea(lat: number | null, long: number | null): boolean {\n if (lat === null || long === null) return false;\n return (\n lat >= DC_BOUNDS.minLat &&\n lat <= DC_BOUNDS.maxLat &&\n long >= DC_BOUNDS.minLong &&\n long <= DC_BOUNDS.maxLong\n );\n}\n\n// Filter hotspots to DC area\nexport function filterDCHotspots(hotspots: HeliumHotspotListItem[]): HeliumHotspotListItem[] {\n return hotspots.filter(h => isInDCArea(h.lat, h.long));\n}\n\n// Sleep utility for rate limiting\nexport function sleep(ms: number): Promise {\n return new Promise(resolve => setTimeout(resolve, ms));\n}\n\n// Fetch all DC area hotspots with pagination\nexport async function fetchAllDCHotspots(\n onProgress?: (processed: number, dcCount: number, cursor: string | null) => void\n): Promise {\n const dcHotspots: HeliumHotspotListItem[] = [];\n let cursor: string | null = null;\n let processed = 0;\n\n while (true) {\n const response = await fetchMobileHotspots(cursor);\n\n for (const hotspot of response.items) {\n processed++;\n if (isInDCArea(hotspot.lat, hotspot.long)) {\n dcHotspots.push(hotspot);\n }\n }\n\n if (onProgress) {\n onProgress(processed, dcHotspots.length, response.cursor);\n }\n\n if (!response.cursor) break;\n cursor = response.cursor;\n\n // Rate limiting\n await sleep(RATE_LIMIT_MS);\n }\n\n return dcHotspots;\n}\n",[],[187,329],"59aad018-f8b9-11f0-ae34-42dde27851f2",["D",1769213540536],8,[],[187,33],["D",1769115852504],[203,204,205,206],[187],["D",1769115490645],["D",1789542098478],{"_101":100,"_108":104},{"_101":100,"_102":-5,"_103":104,"_18":56,"_105":106,"_107":25},{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"ctx",{"_83":-5,"_128":381,"_382":383,"_384":385,"_386":25,"_387":25,"_388":25,"_389":60,"_390":-5,"_391":-7,"_392":-7,"_393":155,"_394":25,"_395":25,"_396":-5,"_397":25,"_398":25,"_399":25,"_400":-5},"ENV",{"_352":353,"_354":355,"_356":91,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

Diff · v121