===== HALL TO CORRAL TRANSITION ANALYSIS =====
Focus: Pre-race movement from convention halls to corrals A, B, and C

Processing data for hall-to-corral transitions...
  Processing hour 05:00...
    Found 246995 records

Analyzing hall-to-corral transitions...

===== ANALYSIS COMPLETE =====
Summary saved to: /var/www/html/CrowdFlow/Houston/hallToCorralAnalysis.json
Detailed data saved to: /var/www/html/CrowdFlow/Houston/hallToCorralDetailed.json

=== KEY FINDINGS ===
Total hall-to-corral journeys tracked: 46

=== CORRAL COMPARISON ===

Corral_B:
  Total runners: 43
  Average journey time: 38.8 minutes
  Journey time range: 6.9 - 55.5 minutes
  Median journey time: 46.4 minutes
  Peak arrival hour: 05:00

Corral_A:
  Total runners: 3
  Average journey time: 48.4 minutes
  Journey time range: 40.3 - 52.7 minutes
  Median journey time: 52.3 minutes
  Peak arrival hour: 05:00

Corral_C:
  Total runners: 
  Average journey time: 40.3 minutes
  Journey time range: 40.3 - 40.3 minutes
  Median journey time: 40.3 minutes
  Peak arrival hour: 

=== TOP HALL-TO-CORRAL ROUTES ===
Medical_Check -> Corral_B               :    2 runners, avg  14.0 min
Half_Marathon_Gear_Check -> Corral_B    :    2 runners, avg  29.6 min
Runner_Staging_BC -> Corral_B           :    2 runners, avg  33.0 min
Runner_Staging_B -> Corral_B            :   14 runners, avg  38.1 min
Main_Entrance -> Corral_B               :    3 runners, avg  41.0 min
Main_Entrance -> Corral_A               :    1 runners, avg  40.3 min
Runner_Staging_A -> Corral_B            :   19 runners, avg  42.8 min
Marathon_Gear_Check -> Corral_B         :    1 runners, avg  46.4 min
Runner_Staging_A -> Corral_A            :    2 runners, avg  52.5 min

=== HALL PERFORMANCE ===

Runner_Staging_A:
  Total transitions: 21
  Average journey time: 43.7 minutes
  Corral distribution:
    Corral_B: 19 (90.5%)
    Corral_A: 2 (9.5%)

Runner_Staging_B:
  Total transitions: 14
  Average journey time: 38.1 minutes
  Corral distribution:
    Corral_B: 14 (100%)

Main_Entrance:
  Total transitions: 4
  Average journey time: 40.8 minutes
  Corral distribution:
    Corral_B: 3 (75%)
    Corral_A: 1 (25%)

Runner_Staging_BC:
  Total transitions: 2
  Average journey time: 33 minutes
  Corral distribution:
    Corral_B: 2 (100%)

Half_Marathon_Gear_Check:
  Total transitions: 2
  Average journey time: 29.6 minutes
  Corral distribution:
    Corral_B: 2 (100%)

Medical_Check:
  Total transitions: 2
  Average journey time: 14 minutes
  Corral distribution:
    Corral_B: 2 (100%)

Marathon_Gear_Check:
  Total transitions: 2
  Average journey time: 14 minutes
  Corral distribution:
    Corral_B: 2 (100%)