HarnessTube Broadcast System Architecture

System Purpose

HarnessTube uses an automated pipeline to import harness racing race cards and generate broadcast graphics for live streams.

Data Pipeline

USTA Race Card ↓ CTRL + U HTML copy ↓ USTA Import Tool ↓ Race data parsed ↓ Google Sheets database ↓ Published CSV ↓ import_sheet.php parser ↓ Overlay Dashboard ↓ JSON files written ↓ Overlay graphics update

Core Components

USTA Import Tool Parses race card HTML and extracts race data.
Google Sheets Database Stores race cards by track tab.
Overlay Dashboard Loads race data and controls broadcast graphics.
JSON Data Files Provide live data to overlay graphics.
Overlay Graphics Display race information during broadcast.

Google Sheets Structure

Each track is stored in its own sheet tab. Race blocks contain metadata, horses, and analyst selections.

Operational Workflow

Entries posted ~3 days before race
Race cards imported via USTA Import Tool
Programs verified against printed program
Track tab published and mapped in PHP
Broadcast operator loads race in dashboard