Transcript Document 7563493

TC/Ontario: CV Border Wait Time Measurement Project
CV Border Wait-Time
Measurement Project
Presentation to:
TBWG Data Workshop
Romulus, Michigan
(June3, 2008)
Coordination and Policy Branch
Transport Canada
Ontario Region
TC/Ontario: CV Border Wait Time Measurement Project
Project Research & Development Process
 Phase 1: Initial Research and Facilitation
 review/assessment of technology options,
 secure endorsement & support of related interests, including OTA & partner carriers
Conclusions:
 tractor logs are a rich/abundant source of empirical data on wait-times & delays throughout the entire O/D
trip, be it at border crossings, or shippers/receivers yards,
 such wait-time data can be accessed, processed and compiled in readily useable form.
 the capability to vary the frequency of the polling interval makes truck-mounted GPS units the technology
option best suited for measuring narrowly-defined border crossing intervals
Completed: May, 2003
 Phase 2: Formal Proof of Concept
 demonstrate practical ways and means to exploit the inherent, technical functionality of GPSbased, E-data recorders (i.e. hindcast simulations on archival data logs)
 assess the costs, and overall cost effectiveness, of advancing the project from concept to “livetime” implementation, with a broad-based and expanded sample size
Completed: October, 2004
 Phase 3: Implementation …… Operation
 RDG approval to proceed with implementation granted October, 2005
 project conceived as a two (2) year, or 26-month, research & demonstration effort. Project TEC,
$240,948.00, including acquisition and deployment of 86 GPS probe-units, plus data
management/service fees, to the end of ‘07/08 fiscal year
 contract formally awarded to Turnpike Global Technologies (TGT) Ltd. on January 20, 2006
TC/Ontario: CV Border Wait Time Measurement Project
CV BWT Measurement Project: Technology Mix
Data Logging
Data Transmission
[download logs]
Data Processing
[transmit logs]
INTERNET
[progrm’ng instructions]
[broadcast signal]
On-board GPS unit
Bluetooth Reader
TGT Ltd.
[geo-coordinates & time stamps]
[data access point]
[data m’gmt service provider]
 detailed digital fingerprint
 precise interval measure
Bluetooth ID’s
 instant transmission
 at $0 cost
 also reads
 purpose-built algorithms
 24/7 BWT data stream
 Web-based access
TC/Ontario: CV Border Wait Time Measurement Project
Site Layout: Data Access Points and Interior Geofences
Peace Bridge Canadian Plaza
Plaza Entry
Inset: U.S. Plaza
Duty Free
Overflow
Base Stn.
Reader
2nd’r
y
TC/Ontario: CV Border Wait Time Measurement Project
BWT Web Display Features
TC/Ontario: CV Border Wait Time Measurement Project
CV BWT Web Display
www.borderinformation.com
userID: peaceb
password: peaceb123
TC/Ontario: CV Border Wait Time Measurement Project
Partner Carriers’ “One View” Web Display
TC/Ontario: CV Border Wait Time Measurement Project
Growth & Distribution of the Data Set
TC/Ontario: CV Border Wait Time Measurement Project
The Distribution ……. and limits ……. of the BWT Crossings Data
 # of Participant Carriers:
 15 at outset, currently > 50
 Crossing observations to date: FY 2006/07 (97,000), FY 2007/08 (124,260)
 Probe Unit leverage …..30 test units prompted installation of > 1300 units by 3 “host” carriers
 Re: ……the Volume & Distribution of Crossings
 the data set will , , as Service Provider’s client base, or market share, ’s, ’s.
 the number & location of crossings ……. vary independently, as determined by carrier
operations
 the composition, or commodity mix, of carriers includes, food, auto-parts, automotive, TL &
LTL freight, but varies independently as determined by the fleet size and/or service lines of
(TGT) client carriers.
 sample carriers are predominantly CTPAT/FAST certified; however, the BWT crossing
observations are not fully differentiated by custom classification ….as yet !!!
 BWT data as % of Total Traffic Volume
 60-90 observations per weekday at P.Bridge and A.Bridge, >1% of annual CV traffic volume
at each respective crossing.
 daily observations at Q/L and BWB are appreciably less, 15-20/peak weekday
 the BlueTooth externality: 320-340 observations/day at DWT, equals 2%+ of total (’07) traffic
volume (i.e., cars/trucks/bus)
TC/Ontario: CV Border Wait Time Measurement Project
Mean Crossing Time (minutes)
Jul-06
Aug-06
Sep-06
Oct-06
Nov-06
Dec-06
Jan-07
Feb-07
Mar-07
Apr-07
May-07
Jun-07
Jul-07
Aug-07
Sep-07
Oct-07
Nov-07
Dec-07
Jan-08
Feb-08
Mar-08
A. Bridge
Bluew ater
DWT
Peace B
Q/L Bridge
Can Bound US Bound Can Bound US Bound Can Bound US Bound Can Bound US Bound Can Bound US Bound
8.03
7.17
17.53
8.54
14.17
13.47
20.50
8.92
20.40
9.04
6.63
18.78
10.22
21.11
16.51
18.82
10.72
20.65
9.48
6.39
18.96
14.20
21.07
18.33
15.60
11.57
19.80
9.86
5.71
14.99
15.81
23.68
23.06
23.00
13.82
18.05
19.70
7.12
15.15
na
19.70
20.08
20.52
14.87
20.52
11.36
7.27
17.82
15.09
20.00
24.72
19.18
10.48
17.10
7.75
6.94
15.61
20.59
14.21
15.06
14.38
12.39
18.42
7.01
6.65
16.27
16.49
14.72
15.62
15.71
15.66
17.56
12.08
9.50
16.27
13.04
19.07
23.75
19.69
10.43
14.20
10.35
9.85
14.12
14.26
14.54
15.13
16.21
13.09
17.36
11.26
34.15
9.25
13.68
14.90
16.25
15.89
18.03
14.35
16.69
11.96
35.64
9.17
16.60
13.98
17.41
19.99
11.60
13.35
15.09
11.26
36.17
9.15
18.31
12.30
14.63
20.38
13.61
13.28
15.77
9.16
38.98
8.80
23.84
9.46
17.40
17.64
14.37
13.26
14.35
12.45
33.58
7.20
20.32
10.90
11.47
20.94
9.85
13.00
15.50
14.90
nil
8.10
21.30
14.53
13.40
19.70
9.84
14.33
16.24
12.80
36.70
7.71
22.20
14.60
13.60
nil
8.80
15.47
17.60
14.10
27.10
8.50
26.80
15.20
12.90
15.00
11.60
15.90
14.96
14.34
25.14
7.24
15.65
22.40
12.57
11.52
8.90
14.29
15.82
12.32
13.38
7.29
17.75
20.71
13.07
11.02
4.41
11.52
13.22
11.66
15.22
8.77
25.87
nil
10.44
11.24
3.62
# of Crossings
Jul-06
Aug-06
Sep-06
Oct-06
Nov-06
Dec-06
Jan-07
Feb-07
Mar-07
Apr-07
May-07
Jun-07
Jul-07
Aug-07
Sep-07
Oct-07
Nov-07
Dec-07
Jan-08
Feb-08
Mar-08
Total
A. Bridge
Blue w a te r
DWT
Pe a ce B
Q/L Bridge
Can Bound US Bound Can Bound US Bound Can Bound US Bound Can Bound US Bound Can Bound US Bound
237
1990
984
1069
1550
474
103
375
554
356
2106
1080
1412
1375
475
289
553
781
357
1531
780
1412
1288
388
272
786
1160
384
2432
1465
962
1480
401
396
1025
1515
415
2206
1219
na
1435
401
411
874
1272
376
3039
1625
14
1435
336
333
812
1353
423
3350
1897
27
1705
332
351
805
1498
430
3014
1783
14
1722
296
302
971
1544
476
3923
2156
218
1675
329
307
848
1685
462
3870
2242
850
1642
370
356
755
1517
529
172
4224
2404
1128
1682
421
384
918
1151
379
322
4019
2101
1018
1434
309
359
592
808
316
257
4666
2210
667
1109
309
275
824
1279
564
206
4599
2396
1003
1439
427
374
654
1173
453
137
863
287
645
1108
452
379
562
1407
391
nil
2511
1103
491
1390
156
353
598
1494
389
197
2340
1008
683
1296
nil
329
544
1069
318
274
2028
1143
621
1112
111
269
521
834
556
67
5844
3165
444
1429
366
178
455
33
600
21
5557
2772
108
1061
371
323
387
1112
791
144
596
315
nil
1111
358
281
13859
23239
9202
1797
64708
34135
12786
29478
7082
6624
TC/Ontario: CV Border Wait Time Measurement Project
TC/Ontario: CV Border Wait Time Measurement Project
TC/Ontario: CV Border Wait Time Measurement Project
PAX Vehicle BWT Measurement : Exploiting Bluetooth Functionality
Data Logging
Data Transmission
“ ….. here I am”
Data Processing
[ sends outbound message]
DIGITAL HANDSHAKE
INTERNET CONNECTION
“ …. who’s out there”
[programming instructions]
Bluetooth enabled device
Bluetooth Transceiver
TGT Ltd.
[handheld, or embedded]
[data access point]
[data m’gmt service provider]
 emits unique Bluetooth ID
 variable range (300/30/3)
depending on device
 operates in discovery mode
 sends outbound messages only
 microprocessor assigns
coordinates & timestamps
 purpose-built algorithms
 24/7 BWT data stream
 Web-based access
TC/Ontario: CV Border Wait Time Measurement Project
Special Events, Diagnostics
TC/Ontario: CV Border Wait Time Measurement Project
Peace Bridge (US Bound): ACE Roll-OUT Daily Diagnostic (Sept 21’06 – Oct 5’06)
Peace Bridge U.S. Bound
Average Crossing Time by Time of Day
ACE Roll Out (Week 2)
Day 9 (Friday, 29/09/06) - Day 16 (Friday 05/10/06)
90
80
70
50
40
30
20
10
Hour
ACT (Mar-Aug '06)
Mon 25/09
Fri 29/09
Sun 01/10
Tues 03/10
Wed 04/10
Thurs 05/10
Fri 06/10
Mon 02/10
23
22
21
20
19
18
17
16
15
14
13
12
11
10
9
8
7
6
5
4
3
2
1
0
0
Minutes
60
TC/Ontario: CV Border Wait Time Measurement Project
Peace Bridge (US Bound): CV Wait Time Data 3rd Quarter ‘07
Peace Bridge (US Bound)
Mean Crossing Time by Time of Day
Monthly Comparison (2007/08) - Third Quarter
30
25
Minutes
20
15
10
5
0
0
1
2
3
4
5
6
7
8
9
10 11 12 13 14 15 16 17 18 19 20 21 22 23
Baseline (17975 - Mar'07) 19.112.513.0 13.312.915.813.912.9 13.012.211.913.7 15.617.519.423.524.6 22.019.817.816.115.1 16.514.4
Oct '07 (1390)
25.18.578.75 9.1010.913.38.2213.6 14.08.3612.816.0 16.017.912.615.614.1 16.312.810.48.4211.0 8.089.41
Nov '07 (1296)
11.313.611.2 6.8419.115.810.612.0 11.612.813.314.5 15.214.216.013.216.6 13.111.712.514.013.9 8.7712.2
Dec '07 (1112)
8.9011.610.1 12.210.410.410.212.6 11.710.611.712.9 12.813.614.316.914.4 14.812.014.812.79.04 13.69.10
TC/Ontario: CV Border Wait Time Measurement Project
Bluewater Bridge (US Bound): Mean Crossing Time Q1 08/09 v. FY 07/08
Bluewater Bridge (US Bound)
Mean Crossing Time by Time of Day
FY 2007/08 v. April/May/June 2008
60
50
Minutes
40
30
20
10
0
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Q1 (494)
56.9 32.6 34.8 24.4 26.8 34.1 25.0 32.1 27.2 25.6 43.6 41.9 35.2 37.3 45.4 39.1 35.3 29.8 41.6 33.9 29.7 33.3 32.1 18.2
Q2 (600)
27.9 34.6 28.0 26.5 26.3 27.7 21.9 32.4 51.0 40.5 35.5 39.2 45.8 45.2 50.3 48.9 36.8 43.0 44.3 37.3 36.4 26.2 18.3 23.1
Q3 (471)
26.8 11.3 32.8 38.5 17.3 34.6 34.2 30.8 30.2 28.0 46.8 45.0 35.7 43.7 33.9 35.6 30.8 24.4 26.9 26.1 22.0 21.7 20.4 19.4
April '08 (110) 23.0
May '08 (98)
12.5 6.50 3.20
8.40
6.16 7.19 3.94 13.0 6.73 15.5 19.8 9.39 13.7 10.4 7.04 7.09 20.6 10.6 16.0 5.67 32.8 19.0 12.9
4.10 5.66 22.4 5.80 4.20 20.0 9.45 3.33 8.28 18.8 11.4 17.1 4.70 11.2 16.6 10.3 9.10 11.8 13.8 17.9
June '08 (274) 16.8 3.97 3.72 3.57 5.45 9.36 6.28 6.48 8.17 11.6 17.1 23.1 14.3 11.6 19.5 15.1 10.3 17.1 8.10 12.1 12.5 14.7 17.1 11.7
TC/Ontario: CV Border Wait Time Measurement Project
Peak Crossing
Time v. Peak
Traffic Volume
Amba ssa dor Bridge (US Bound)
Pe a k Crossing Time v. Pe a k Traffic Volume
40
1400
35
1200
30
1000
25
Minutes
800
20
600
Frequency
AMBASSADOR
BRIDGE
15
400
10
200
5
0
0
1
2
3
4
5
6
7
8
# X'ngs 07/08 (13561)
352
463
317
291
293
680
528
# X'ngs 06/07 (9677)
284
316
209
222
359
577
337
MCT 2007-08
15.0 13.5 12.2 10.4 12.1 18.2 13.6 13.4 14.0 15.0 17.6 19.8 18.4 18.7 18.0 15.9 16.4 17.2 15.1 14.8 13.4 12.6 15.4 16.3
MCT 2006-07
19.9 17.3 16.4 13.9 15.7 18.0 16.3 15.0 17.1 16.7 18.5 22.1 19.7 23.2 21.8 23.6 21.9 21.7 21.9 19.5 20.4 15.7 17.6 18.0
1213 716
869
411
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
792
770
653
751
635
433
421
450
466
513
716
573
673
482
380
660
519
494
581
409
462
335
290
264
398
461
324
329
284
283
Ambassador Bridge (Canada Bound)
Peak Crossing Time v. Peak Traffic Volume
AMBASSADOR
BRIDGE
25
Peak Crossing
Time v. Peak
Traffic Volume
0
600
500
20
400
Frequency
Minutes
15
300
10
200
5
0
100
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
#x "ngs 07/08 (7658)
198
240
116
122
# X'ngs 06/07 (6181)
170
205
114
98
88
87
140
171
259
362
488
555
454
527
466
433
532
451
457
402
344
324
246
196
84
110
119
187
216
307
369
405
478
337
317
287
401
380
390
323
267
241
197
MCT 2007-08
11.8 10.1 9.77 10.2 10.4 9.53 11.8 10.8 9.48 13.9 13.8 14.6 13.7 13.8 13.6 15.5 13.7 15.3 14.1 16.0 13.9 12.3 12.8 12.0
179
MCT 2006-07
12.4 11.5 11.7 9.30 8.69 13.4 15.5 12.8 10.4 12.9 14.5 13.4 11.9 12.4 12.7 16.0 12.1 13.6 12.4 14.4 13.6 11.4 11.2 11.3
0
TC/Ontario: CV Border Wait Time Measurement Project
Pe a ce Bridge (US Bound)
Pe a k Crossing Time v. Pe a k Tra ffic Volume
PEACE BRIDGE
30
Peak Crossing
Time v. Peak
Traffic Volume
1600
1400
25
1200
20
15
800
Frequency
Minutes
1000
600
10
400
5
200
0
0
1
2
3
4
5
6
7
8
9
# X'ngs 2007/08 (15814)
115
105
102
151
279
403
796
800
765
845
# X'ngs 2006/07 (17975)"
132
91
86
191
342
522
922
936
758
10
11
12
13
14
15
16
17
18
19
20
21
22
23
845
707
573
433
256
203
845 1055 1261 1333 1334 1413 1451 1218 1092 884
732
550
382
254
191
902 1142 1040 1141 1154 1109 1030 918
MCT 2007-08
14.4 14.9 12.0 10.8 13.2 13.4 10.9 11.7 11.8 9.81 11.6 13.0 13.6 16.9 16.0 18.3 18.6 16.6 15.4 13.7 13.4 13.0 10.6 11.6
MCT 2006-07
19.1 12.5 13.0 13.3 12.9 15.8 13.9 12.9 13.0 12.2 11.9 13.7 15.6 17.5 19.4 23.5 24.6 22.0 19.8 17.8 16.1 15.1 16.5 14.4
Pe a ce Bridge (Ca na da Bound)
Pe a k Crossing Time v. Pe a k Crossing Volume
PEACE BRIDGE
30
900
800
25
700
20
600
Minutes
500
15
400
10
300
200
5
100
0
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
# X'ngs 07-08 (7642)
121
92
71
76
120
104
106
142
222
344
430
474
512
604
608
522
473
479
466
458
385
343
275
215
# X'ngs 06-07 (10100)
191
140
94
80
102
93
107
143
356
373
501
505
587
679
767
756
745
748
758
638
607
498
375
257
MCT 2007-08
16.0 25.5 16.1 11.8 9.14 11.8 14.7 14.0 12.2 16.3 14.8 12.4 13.9 12.2 12.5 12.4 12.0 14.3 15.6 15.9 15.1 15.3 13.8 13.2
MCT 2006-07
12.9 11.7 9.19 9.24 8.45 9.68 9.99 12.3 10.3 10.6 10.8 9.72 8.74 9.47 9.43 9.13 9.40 9.36 11.4 10.3 10.5 10.5 10.8 11.3
0
Freuency
Peak Crossing
Time v. Peak
Traffic Volume
0
TC/Ontario: CV Border Wait Time Measurement Project
Perimeter Zones, Queuing
TC/Ontario: CV Border Wait Time Measurement Project
Ambassador Bridge (US Bound) Access & Queuing Patterns
Zone 2 + Zone 1:




Hwy 401 to A. Bridge Plaza
Queue length ………. @ 16 km
43.3% of recorded observations
Mean Transit Time
Zone 1 only:





ECR Parkway to A. Bridge Plaza
(access to Huron Church via ECR)
Queue length ……. @ 6km
32.9% of recorded observations
Mean Transit Time
NO Zone:
 access to Plaza via Wyandotte Street
 Queue length ……0 km
 23.8 % of recorded observations
 Mean Transit Time
TC/Ontario: CV Border Wait Time Measurement Project
Ambassador Bridge (US Bound)
Transit Zone Split Time Intervals by Time of Day
Ambassador Bridge (US Bound)
Transit Zone SPLIT Time Intervals by Time of Day
Test Data (October 1 - December 31'07)
40
35
35
30
30
25
25
Minutes
Minutes
Test Data (April - September 30'07)
40
20
20
15
15
10
10
5
5
0
0
0
1
2
3
4
Zone 2 (H401-ECR)
5
6
7
8
9
Zone 1(ECR-Plaza)
10
11
12
Z1+Z2
13
14
15
16
Plaza Thruput Time
17
18
19
20
21
22
23
Total Crossing Time
0
1
2
3
4
Zone 2 (H401-ECR)
5
6
7
8
9
Zone 1 (ECR-Plaza)
10
11
12
13
ZONE 1+2
14
15
16
Plaza Thruput Time
17
18
19
20
21
22
Total Crossing Time
Transit Zones
Zone 2
Zone1
Zone 1 ONLY
PTT/TCT
No Zone
Month
( Hwy 401-plaza)
(ECR X'wy-plaza)
i.e. Zone1-Zone2
i.e.# of Crossings
(via Wyandotte)
June
% of Total
July
% of Total
August
% of Total
September
% of Total
October
% of Total
November
% of Total
December
% of Total
TOTAL( June-Dec'07)
% OF TOTAL
163
50.46
473
59.13
558
43.8
463
39.61
608
43.34
563
37.68
432
40.42
3260
43.28%
308
95.35
733
91.53
1052
82.57
790
67.58
1040
74.13
1043
69.82
772
72.22
5738
76.18
145
44.9
260
32.5
494
38.77
327
27.98
432
30.79
480
32.14
340
31.8
2478
32.90%
323
15
4.65
67
8.47
222
17.43
379
32.42
363
25.87
451
30.18
297
27.78
1794
23.82%
800
1274
1169
1403
1494
1069
7532
100%
23
TC/Ontario: CV Border Wait Time Measurement Project
Conclusions
TC/Ontario: CV Border Wait Time Measurement Project
Apart from the data, remember three (3) fundamental, STRATEGIC,
aspects of this seminal R&D effort :
 This is not a SOLUTION, simply an analytical TOOL:
 a PERFORMANCE METRIC, with operational utility for local port & crossing officials, a variety of
government agencies, and
 those (partner) carriers, who can now routinely track & precisely measure their own day-day
border crossing activity
 This is industry-driven, industry-focused data, never previously available, clearly
demonstrating:
 the trucking industry’s willingness to partner with government to explore new, innovative
approaches to problems that affect their mutual interest,
 that industry itself is taking a direct hand, and now able to provide empirical data in response to
the concerns or “perceptions” of shippers, foreign investors, etc. regarding the Can/US border.
 This project, as a R&D initiative, has “opened the door” to further exploitation of an
increasingly abundant, and previously untapped, digital data resource:
 established the technical and economic viability of FARMING digital tractor logs,
 confirms “Bluetooth” functionality as a proxy for PAX TRAFFIC wait-times at Can/US border
crossings,
 the BWT application is simply a “special case” of the emerging interest in digital tractor logs as a
planning/analysis tool for trade corridors (MTO, TC/HQ) and urban corridor (MTO, UofT).
 Already we are seeing the emergence of a data resale, or procurement, market for 3rd-party,
derivative applications.