[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_294":295,"_296":297},"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",22,"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// 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 WHERE is_active = 1\n ORDER BY created_at ASC\n `);\n\n return result.rows.map(row => ({\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// 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 return result.rows.map(row => ({\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// 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 return result.rows[0].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\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 if (!dateRange.rows[0].min_date) return;\n\n const minDate = new Date(dateRange.rows[0].min_date as string);\n const maxDate = new Date(dateRange.rows[0].max_date 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 await upsertSnapshot({\n snapshot_date: dateStr,\n total_count: totalResult.rows[0].total as number,\n new_count: newResult.rows[0].new_count 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\";\nimport type { Hotspot, DailySnapshot } from \"../shared/types.ts\";\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 1000\n `);\n\n return result.rows.map(row => ({\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// 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 return result.rows.map(row => ({\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// 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 return result.rows[0].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\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 if (!dateRange.rows[0].min_date) return;\n\n const minDate = new Date(dateRange.rows[0].min_date as string);\n const maxDate = new Date(dateRange.rows[0].max_date 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 await upsertSnapshot({\n snapshot_date: dateStr,\n total_count: totalResult.rows[0].total as number,\n new_count: newResult.rows[0].new_count as number,\n });\n }\n}\n","createdAt",["D",1769116313425],"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":289,"_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":290,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":291,"_85":292,"_87":293,"_89":25},"tree",[184,188,195,197,198],"files",[184,185,186,187,188,189,190,191,192,193,194,195,196,197,198],"counts",{"_174":153,"_175":64,"_176":153,"_177":178,"_179":180},"contents",[131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":168,"_32":169,"_30":170,"_138":-5,"_42":43,"_41":171,"_140":60,"_39":172,"_13":153,"_34":161,"_36":-5,"_24":25,"_145":-5,"_27":173},{"_44":163,"_32":164,"_30":165,"_138":-5,"_42":43,"_41":64,"_140":60,"_39":166,"_13":153,"_34":161,"_36":-5,"_24":25,"_145":-5,"_27":167},{"_44":156,"_32":157,"_30":158,"_138":-5,"_42":43,"_41":159,"_140":60,"_39":160,"_13":153,"_34":161,"_36":-5,"_24":25,"_145":-5,"_27":162},{"_44":148,"_32":149,"_30":150,"_138":-5,"_42":43,"_41":151,"_140":25,"_39":152,"_13":153,"_34":20,"_36":154,"_24":25,"_145":-5,"_27":155},{"_44":136,"_32":137,"_30":58,"_138":-5,"_42":43,"_41":139,"_140":25,"_39":141,"_13":142,"_34":143,"_36":144,"_24":25,"_145":146,"_27":147},"e7892806-f7d5-11f0-be53-42dde27851f2","index.ts","parentId",19,"latest",["D",1769115853300],2,"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\";\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// 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","label","dc-hotspot-growth",[137],"10469b94-f7d5-11f0-a6fb-42dde27851f2","README.md","10469c52-f7d5-11f0-a6fb-42dde27851f2",9,["D",1769115491998],0,"# 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.",[149],"e7310914-f7d5-11f0-8149-42dde27851f2","shared","e73109f0-f7d5-11f0-8149-42dde27851f2",12,["D",1769115852719],"directory",[157],"0fd734b6-f7d5-11f0-8b85-42dde27851f2","frontend","0fd73556-f7d5-11f0-8b85-42dde27851f2",["D",1769115491425],[164],"e70fa13e-f7d5-11f0-8269-42dde27851f2","backend","e70fa206-f7d5-11f0-8269-42dde27851f2",11,["D",1769115852504],[169],"pulls","branches","forks","envVars",{"_181":153,"_183":153},"connections",{"_181":153,"_182":153},"count","unfilledCount","emptyCount",{"_44":168,"_32":169,"_30":170,"_138":-5,"_42":43,"_41":171,"_140":60,"_39":286,"_13":153,"_34":161,"_36":-5,"_24":25,"_145":-5,"_200":287,"_27":288},{"_44":282,"_32":33,"_30":31,"_138":170,"_42":43,"_41":14,"_140":25,"_39":283,"_13":64,"_34":35,"_36":38,"_24":25,"_145":-5,"_200":284,"_27":285},{"_44":274,"_32":275,"_30":276,"_138":170,"_42":43,"_41":277,"_140":25,"_39":278,"_13":153,"_34":35,"_36":279,"_24":25,"_145":-5,"_200":280,"_27":281},{"_44":266,"_32":267,"_30":268,"_138":170,"_42":43,"_41":269,"_140":25,"_39":270,"_13":153,"_34":35,"_36":271,"_24":25,"_145":-5,"_200":272,"_27":273},{"_44":163,"_32":164,"_30":165,"_138":-5,"_42":43,"_41":64,"_140":60,"_39":263,"_13":153,"_34":161,"_36":-5,"_24":25,"_145":-5,"_200":264,"_27":265},{"_44":259,"_32":258,"_30":252,"_138":165,"_42":43,"_41":142,"_140":60,"_39":260,"_13":153,"_34":161,"_36":-5,"_24":25,"_145":-5,"_200":261,"_27":262},{"_44":249,"_32":250,"_30":251,"_138":252,"_42":43,"_41":253,"_140":25,"_39":254,"_13":142,"_34":35,"_36":255,"_24":25,"_145":-5,"_200":256,"_27":257},{"_44":241,"_32":242,"_30":243,"_138":165,"_42":43,"_41":244,"_140":60,"_39":245,"_13":153,"_34":20,"_36":246,"_24":25,"_145":-5,"_200":247,"_27":248},{"_44":233,"_32":234,"_30":235,"_138":165,"_42":43,"_41":236,"_140":25,"_39":237,"_13":64,"_34":20,"_36":238,"_24":25,"_145":-5,"_200":239,"_27":240},{"_44":225,"_32":226,"_30":227,"_138":165,"_42":43,"_41":228,"_140":60,"_39":229,"_13":153,"_34":35,"_36":230,"_24":25,"_145":-5,"_200":231,"_27":232},{"_44":217,"_32":218,"_30":219,"_138":165,"_42":43,"_41":220,"_140":25,"_39":221,"_13":64,"_34":20,"_36":222,"_24":25,"_145":-5,"_200":223,"_27":224},{"_44":156,"_32":157,"_30":158,"_138":-5,"_42":43,"_41":159,"_140":60,"_39":214,"_13":153,"_34":161,"_36":-5,"_24":25,"_145":-5,"_200":215,"_27":216},{"_44":206,"_32":207,"_30":208,"_138":158,"_42":43,"_41":209,"_140":60,"_39":210,"_13":153,"_34":35,"_36":211,"_24":25,"_145":-5,"_200":212,"_27":213},{"_44":148,"_32":149,"_30":150,"_138":-5,"_42":43,"_41":151,"_140":25,"_39":203,"_13":153,"_34":20,"_36":154,"_24":25,"_145":-5,"_200":204,"_27":205},{"_44":136,"_32":137,"_30":58,"_138":-5,"_42":43,"_41":139,"_140":25,"_39":199,"_13":142,"_34":143,"_36":144,"_24":25,"_145":146,"_200":201,"_27":202},["D",1769115853300],"children",[],[137],["D",1769115491998],[],[149],"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",[],[157,207],["D",1769115852719],[196],[157],"e7836718-f7d5-11f0-95ad-42dde27851f2","style.css","1010cadc-f7d5-11f0-913f-42dde27851f2",18,["D",1769115853221],"/* 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: linear-gradient(135deg, var(--bg-primary) 0%, #0a1628 100%);\n color: var(--text-primary);\n}\n\n.app {\n display: flex;\n flex-direction: column;\n height: 100vh;\n width: 100vw;\n position: relative;\n}\n\n/* Stats Panel */\n.stats-panel {\n position: absolute;\n top: 20px;\n left: 20px;\n z-index: 100;\n background: var(--bg-card);\n backdrop-filter: blur(15px);\n border: 1px solid var(--border-color);\n border-radius: 16px;\n padding: 24px;\n min-width: 280px;\n}\n\n.stats-panel h1 {\n font-size: 24px;\n font-weight: 700;\n margin-bottom: 8px;\n background: linear-gradient(135deg, var(--accent-cyan), var(--accent-purple));\n -webkit-background-clip: text;\n -webkit-text-fill-color: transparent;\n background-clip: text;\n}\n\n.stats-panel .tagline {\n font-size: 13px;\n color: var(--text-secondary);\n margin-bottom: 24px;\n}\n\n.stat-card {\n background: var(--bg-secondary);\n border-radius: 12px;\n padding: 16px;\n margin-bottom: 12px;\n}\n\n.stat-label {\n font-size: 11px;\n text-transform: uppercase;\n letter-spacing: 0.07em;\n color: var(--text-secondary);\n margin-bottom: 4px;\n}\n\n.stat-value {\n font-size: 48px;\n font-weight: 700;\n line-height: 1;\n color: var(--text-primary);\n}\n\n.stat-delta {\n font-size: 14px;\n font-weight: 600;\n color: var(--accent-green);\n margin-top: 8px;\n}\n\n.stat-delta.negative {\n color: #e74c3c;\n}\n\n.current-date {\n font-size: 14px;\n color: var(--text-secondary);\n margin-top: 16px;\n padding-top: 16px;\n border-top: 1px solid var(--border-color);\n}\n\n.current-date strong {\n color: var(--text-primary);\n}\n\n/* Map Container */\n.map-container {\n flex: 1;\n position: relative;\n width: 100%;\n height: 100%;\n}\n\n/* Timeline */\n.timeline {\n position: absolute;\n bottom: 0;\n left: 0;\n right: 0;\n z-index: 100;\n background: linear-gradient(to top, rgba(4, 8, 27, 0.95), transparent);\n padding: 40px 20px 20px;\n}\n\n.timeline-inner {\n display: flex;\n align-items: center;\n gap: 16px;\n max-width: 1200px;\n margin: 0 auto;\n}\n\n.play-button {\n width: 48px;\n height: 48px;\n border-radius: 50%;\n background: var(--accent-cyan);\n border: none;\n cursor: pointer;\n display: flex;\n align-items: center;\n justify-content: center;\n font-size: 20px;\n color: var(--bg-primary);\n transition: transform 0.2s, background 0.2s;\n flex-shrink: 0;\n}\n\n.play-button:hover {\n transform: scale(1.05);\n background: #6dd5fa;\n}\n\n.timeline-slider-container {\n flex: 1;\n display: flex;\n flex-direction: column;\n gap: 8px;\n}\n\n.timeline-slider {\n -webkit-appearance: none;\n appearance: none;\n width: 100%;\n height: 6px;\n background: rgba(255, 255, 255, 0.2);\n border-radius: 3px;\n cursor: pointer;\n}\n\n.timeline-slider::-webkit-slider-thumb {\n -webkit-appearance: none;\n appearance: none;\n width: 18px;\n height: 18px;\n border-radius: 50%;\n background: var(--accent-cyan);\n cursor: pointer;\n box-shadow: 0 2px 8px rgba(79, 195, 247, 0.4);\n transition: transform 0.2s;\n}\n\n.timeline-slider::-webkit-slider-thumb:hover {\n transform: scale(1.2);\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: 16px;\n font-weight: 600;\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/* Tooltip */\n.map-tooltip {\n background: var(--bg-card) !important;\n backdrop-filter: blur(15px);\n border: 1px solid var(--border-color) !important;\n border-radius: 8px !important;\n padding: 12px !important;\n color: var(--text-primary) !important;\n font-family: 'Figtree', sans-serif !important;\n}\n\n/* Legend */\n.legend {\n position: absolute;\n bottom: 100px;\n right: 20px;\n z-index: 100;\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.legend-title {\n font-size: 12px;\n text-transform: uppercase;\n letter-spacing: 0.07em;\n color: var(--text-secondary);\n margin-bottom: 12px;\n}\n\n.legend-item {\n display: flex;\n align-items: center;\n gap: 8px;\n font-size: 13px;\n margin-bottom: 8px;\n}\n\n.legend-item:last-child {\n margin-bottom: 0;\n}\n\n.legend-dot {\n width: 12px;\n height: 12px;\n border-radius: 50%;\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: #9b59b6;\n}\n\n.legend-dot.old {\n background: #95a5a6;\n}\n\n/* Responsive */\n@media (max-width: 768px) {\n .stats-panel {\n top: 10px;\n left: 10px;\n right: 10px;\n min-width: auto;\n padding: 16px;\n }\n\n .stat-value {\n font-size: 36px;\n }\n\n .legend {\n display: none;\n }\n}\n",[],[164,218],"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();",[],[164,226],"e76cf65e-f7d5-11f0-a744-42dde27851f2","index.html","10239040-f7d5-11f0-b4d4-42dde27851f2",15,["D",1769115853001],"\n\n \n \n \n DC Helium Mobile Hotspot Growth\n \n \n \n \n \n \n \n

\n \n \n \n\n",[],[164,234],"10309f92-f7d5-11f0-be9d-42dde27851f2","favicon.svg","1030a050-f7d5-11f0-be9d-42dde27851f2",7,["D",1769115492011],"\n",[],[164,242],"87fe5054-f7d6-11f0-b863-42dde27851f2","App.tsx","102e094e-f7d5-11f0-88c4-42dde27851f2","0ff6303c-f7d5-11f0-9712-42dde27851f2",21,["D",1769116122498],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useMemo, useCallback, useRef } from \"https://esm.sh/react@18.2.0\";\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\nconst DC_CENTER = { lat: 38.9072, lng: -77.0369 };\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// Get color based on hotspot age\nfunction getHotspotColor(createdAt: string, selectedDate: string): string {\n const age = daysBetween(createdAt, selectedDate);\n if (age < 7) return '#2ecc71'; // Green - new\n if (age < 30) return '#3498db'; // Blue - recent\n if (age < 90) return '#9b59b6'; // Purple - established\n return '#95a5a6'; // Gray - old\n}\n\nexport function App() {\n const [hotspots, setHotspots] = useState([]);\n const [snapshots, setSnapshots] = useState([]);\n const [selectedDate, setSelectedDate] = useState(new Date().toISOString().split('T')[0]);\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 mapRef = useRef(null);\n const mapInstanceRef = useRef(null);\n const markersRef = useRef([]);\n\n // Load Leaflet dynamically\n useEffect(() => {\n // Add Leaflet CSS\n if (!document.getElementById('leaflet-css')) {\n const link = document.createElement('link');\n link.id = 'leaflet-css';\n link.rel = 'stylesheet';\n link.href = 'https://unpkg.com/leaflet@1.9.4/dist/leaflet.css';\n document.head.appendChild(link);\n }\n\n // Load Leaflet JS\n const script = document.createElement('script');\n script.src = 'https://unpkg.com/leaflet@1.9.4/dist/leaflet.js';\n script.onload = () => {\n if (mapRef.current && !mapInstanceRef.current) {\n const L = (window as any).L;\n const map = L.map(mapRef.current).setView([DC_CENTER.lat, DC_CENTER.lng], 10);\n\n L.tileLayer('https://{s}.basemaps.cartocdn.com/dark_all/{z}/{x}/{y}{r}.png', {\n attribution: '© OpenStreetMap, © CARTO',\n maxZoom: 19\n }).addTo(map);\n\n mapInstanceRef.current = map;\n }\n };\n document.body.appendChild(script);\n\n return () => {\n if (mapInstanceRef.current) {\n mapInstanceRef.current.remove();\n mapInstanceRef.current = null;\n }\n };\n }, []);\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 // Set initial date to latest snapshot or today\n if (snapshotsData.length > 0) {\n setSelectedDate(snapshotsData[snapshotsData.length - 1].snapshot_date);\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 // Filter hotspots for selected date\n const visibleHotspots = useMemo(() => {\n return hotspots.filter(h => h.created_at <= selectedDate);\n }, [hotspots, selectedDate]);\n\n // Update markers when visible hotspots change\n useEffect(() => {\n const L = (window as any).L;\n if (!mapInstanceRef.current || !L) return;\n\n // Clear existing markers\n markersRef.current.forEach(marker => marker.remove());\n markersRef.current = [];\n\n // Add new markers\n visibleHotspots.forEach(hotspot => {\n const color = getHotspotColor(hotspot.created_at, selectedDate);\n const marker = L.circleMarker([hotspot.lat, hotspot.long], {\n radius: 6,\n fillColor: color,\n color: '#fff',\n weight: 1,\n opacity: 0.8,\n fillOpacity: 0.8\n });\n\n marker.bindPopup(`\n Hotspot
\n Created: ${hotspot.created_at}
\n ID: ${hotspot.entity_key_str.slice(0, 16)}...\n `);\n\n marker.addTo(mapInstanceRef.current);\n markersRef.current.push(marker);\n });\n }, [visibleHotspots, selectedDate]);\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\n useEffect(() => {\n if (!isPlaying || snapshots.length === 0) return;\n\n const interval = setInterval(() => {\n setSelectedDate(prev => {\n const currentIdx = snapshots.findIndex(s => s.snapshot_date === prev);\n if (currentIdx === -1 || currentIdx >= snapshots.length - 1) {\n setIsPlaying(false);\n return prev;\n }\n return snapshots[currentIdx + 1].snapshot_date;\n });\n }, 200); // 5 frames per second\n\n return () => clearInterval(interval);\n }, [isPlaying, snapshots]);\n\n // Handle slider change\n const handleSliderChange = useCallback((e: React.ChangeEvent) => {\n const idx = parseInt(e.target.value);\n if (snapshots[idx]) {\n setSelectedDate(snapshots[idx].snapshot_date);\n }\n }, [snapshots]);\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 // Reload data\n window.location.reload();\n } catch (e) {\n setError(String(e));\n } finally {\n setBackfilling(false);\n }\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 = snapshots.findIndex(s => s.snapshot_date === selectedDate);\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 */}\n

DC Hotspot Growth

Helium Mobile hotspots in the DC Metro area

\n\n

Total Hotspots

{currentStats.total_count.toLocaleString()}

\n {currentStats.new_count > 0 && (\n

+{currentStats.new_count} new

\n )}\n

\n\n

\n Showing: {selectedDate}\n

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

Hotspot Age

\n New (< 7 days)\n

\n Recent (< 30 days)\n

\n Established (< 90 days)\n

\n Mature (90+ days)\n

\n\n {/* Map */}\n

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

\n setIsPlaying(!isPlaying)}\n aria-label={isPlaying ? \"Pause\" : \"Play\"}\n >\n {isPlaying ? \"⏸\" : \"▶\"}\n \n\n

\n = 0 ? currentIdx : 0}\n onChange={handleSliderChange}\n />\n

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

\n )}\n

\n );\n}\n",[],[164,258,250],"components","0ff62f6a-f7d5-11f0-9712-42dde27851f2",["D",1769115491600],[190],[164,258],["D",1769115491425],[189,191,192,193,194],[164],"e78c45ea-f7d5-11f0-858d-42dde27851f2","scraper.ts","e78c46bc-f7d5-11f0-858d-42dde27851f2",20,["D",1769115853005],"// 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 errors: number;\n}\n\n// Run initial backfill of all DC area hotspots\nexport async function runBackfill(): Promise {\n await db.initDatabase();\n\n const result: BackfillResult = {\n processed: 0,\n dcHotspots: 0,\n errors: 0,\n };\n\n const today = new Date().toISOString().split('T')[0];\n\n console.log(\"Starting backfill of DC area hotspots...\");\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 console.log(`Found ${dcHotspots.length} hotspots in DC area. Fetching details...`);\n\n // Insert each DC hotspot\n for (const hotspot of dcHotspots) {\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.dcHotspots++;\n\n // Rate limit individual requests\n await helium.sleep(50);\n\n if (result.dcHotspots % 100 === 0) {\n console.log(`Inserted ${result.dcHotspots} 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\n console.log(\"Computing historical snapshots...\");\n await db.computeHistoricalSnapshots();\n\n console.log(`Backfill complete: ${result.dcHotspots} hotspots, ${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(50);\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 // 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",[],[169,267],"e7738cee-f7d5-11f0-b958-42dde27851f2","heliumApi.ts","e7738db6-f7d5-11f0-b958-42dde27851f2",16,["D",1769115853122],"// 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 return response.json();\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",[],[169,275],"f9ca8950-f7d6-11f0-abf1-42dde27851f2",["D",1769116313425],[],[169,33],["D",1769115852504],[185,186,187],[169],["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":327,"_328":329,"_330":331,"_332":25,"_333":25,"_334":25,"_335":60,"_336":-5,"_337":-7,"_338":-7,"_339":153,"_340":25,"_341":25,"_342":-5,"_343":25,"_344":25,"_345":25,"_346":-5},"ENV",{"_298":299,"_300":301,"_302":91,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326},"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"]

Diff · v22