Race start time set to: 2025-01-18 08:00:00
Participant categorization cutoff time set to: 2025-01-18 08:45:00
Start time filter set to: 2025-01-18 07:00:00
End time filter set to: 2025-01-18 13:00:00
First pass: Processing data for address categorization and path analysis...
Processed 10000 records...
Processed 20000 records...
Processed 30000 records...
Processed 40000 records...
Processed 50000 records...
Processed 60000 records...
Processed 70000 records...
Processed 80000 records...
Processed 90000 records...
Processed 100000 records...
Processed 110000 records...
Processed 120000 records...
Processed 130000 records...
Processed 140000 records...
Processed 150000 records...
Processed 160000 records...
Processed 170000 records...
Processed 180000 records...
Processed 190000 records...
Processed 200000 records...
Processed 210000 records...
Processed 220000 records...
Processed 230000 records...
Processed 240000 records...
Processed 250000 records...
Processed 260000 records...
Processed 270000 records...
Processed 280000 records...
Processed 290000 records...
Processed 300000 records...
Processed 310000 records...
Processed 320000 records...
Processed 330000 records...
Processed 340000 records...
Processed 350000 records...
Processed 360000 records...
Processed 370000 records...
Processed 380000 records...
Processed 390000 records...
Processed 400000 records...
Processed 410000 records...
Processed 420000 records...
Processed 430000 records...
Processed 440000 records...
Processed 450000 records...
Processed 460000 records...
Processed 470000 records...
Processed 480000 records...
Processed 490000 records...
Processed 500000 records...
Processed 510000 records...
Processed 520000 records...
Processed 530000 records...
Processed 540000 records...
Processed 550000 records...
Processed 560000 records...
Processed 570000 records...
Processed 580000 records...
Processed 590000 records...
Processed 600000 records...
Processed 610000 records...
Processed 620000 records...
Processed 630000 records...
Processed 640000 records...
Processed 650000 records...
Processed 660000 records...
Processed 670000 records...
Processed 680000 records...
Processed 690000 records...
Skipped 108338 records outside the time window in first pass.
Categorizing addresses as participants or spectators with dwell time filtering and cutoff time logic...
Analyzing finish-to-runfest movement patterns (after race start and cutoff time)...
Performing path analysis on 15-minute bins...
Analyzing bin 2025-01-18 07:00...
Analyzing bin 2025-01-18 08:45...
Analyzing bin 2025-01-18 09:00...
Analyzing bin 2025-01-18 07:15...
Analyzing bin 2025-01-18 08:30...
Analyzing bin 2025-01-18 10:15...
Analyzing bin 2025-01-18 12:45...
Analyzing bin 2025-01-18 08:00...
Analyzing bin 2025-01-18 09:45...
Analyzing bin 2025-01-18 11:45...
Analyzing bin 2025-01-18 11:30...
Analyzing bin 2025-01-18 09:15...
Analyzing bin 2025-01-18 07:30...
Analyzing bin 2025-01-18 08:15...
Analyzing bin 2025-01-18 07:45...
Analyzing bin 2025-01-18 10:00...
Analyzing bin 2025-01-18 09:30...
Analyzing bin 2025-01-18 11:00...
Analyzing bin 2025-01-18 11:15...
Analyzing bin 2025-01-18 10:45...
Analyzing bin 2025-01-18 12:15...
Analyzing bin 2025-01-18 10:30...
Analyzing bin 2025-01-18 12:30...
Analyzing bin 2025-01-18 12:00...
Path analysis data saved to /var/www/html/CrowdFlow/Houston/Houston5k_path_analysis_0700to1300_20250118.json
Summary statistics: {
    "Total Participants": 2483,
    "Total Spectators": 32506,
    "Finish Line to RunFest Movement": 786,
    "Percentage of Participants at RunFest": 31.655255739025375,
    "Dwell Time Filter Applied": "1 to 1440 minutes",
    "Race Start Time": "2025-01-18 08:00:00",
    "Time Window Filter Applied": "07:00:00 to 13:00:00",
    "Participant Categorization Cutoff Time": "2025-01-18 08:45:00"
}
Path analysis complete! Found 356 paths.