Office of Operations Freight Management and Operations

Evaluation of Travel Time Methods to Support Mobility Performance Monitoring:
Blue Water Bridge (Page 2 of 3)

Data Collection Details

Both the Michigan Department of Transportation and the Blue Water Bridge Authority provided border crossing statistical data. This data was evaluated for an assessment of the variability in travel conditions at the Blue Water Bridge. The goal of this analysis process was to obtain statistically useful data with as few data collection days as possible. In order to customize the data collection activities to the Blue Water Bridge, the following steps were conducted:

  • Define significant "seasonal" variations,
  • Define significantly different days of the week,
  • Identify traffic streams that experience significantly different conditions, and
  • Estimate the number of days needed for the data collection survey.

As shown in Table 3, there is some variation in the commercial traffic by month, which was most pronounced in 2000. Due to project constraints, data collection needed to occur between late May and early September 2001. From Table 3, the two months with the greatest average volumes during this data collection window were June and August.

Table 3. Monthly Traffic Distribution of Commercial Vehicles
Month 1998 1999 2000 1998-2000 Average
January 105,313 111,071 122,961 113,115
February 105,919 114,652 126,796 115,789
March 117,456 132,440 144,109 131,335
April 115,129 124,457 127,224 122,270
May 114,844 126,057 143,081 127,994
June 111,183 132,783 148,134 130,700
July 91,459 105,845 111,411 102,905
August 113,546 130,042 144,027 129,205
September 119,176 133,327 132,295 128,266
October 124,852 134,384 140,891 133,376
November 121,358 133,504 132,846 129,236
December 110,625 116,763 103,064 110,151
Total 1,350,860 1,495,325 1,576,839 1,474,341

Source: Texas Transportation Institute

Tables 4 and 5 show that there is a significant difference in commercial traffic between weekdays and weekends and, further, there is a significant difference between Monday and Friday and the three mid-week days. Weekend traffic is 39 percent of typical weekday traffic and Monday/Friday traffic is 85 percent of typical Tuesday/Wednesday/Thursday traffic. In general, it was noted that outbound traffic increased from Tuesday through Thursday and inbound traffic decreased from Tuesday through Thursday. It was determined that collecting three days of data, from Tuesday through Thursday, would provide an adequate number of data samples to represent "typical" conditions.

Table 4. Sample Month – Daily Traffic Distribution of Commercial Vehicles for June 2000
Day Day of Week Outbound Inbound
1 Thursday 3290 3230
2 Friday 3074 2638
3 Saturday 1327 1347
4 Sunday 879 1887
5 Monday 2616 3438
6 Tuesday 3014 3536
7 Wednesday 3158 3485
8 Thursday 3234 3231
9 Friday 2759 2491
10 Saturday 1031 1177
11 Sunday 788 1441
12 Monday 2408 3109
13 Tuesday 2996 3267
14 Wednesday 3003 3365
15 Thursday 3170 3148
16 Friday 2785 2426
17 Saturday 970 1111
18 Sunday 805 1398
19 Monday 2442 3177
20 Tuesday 2878 3375
21 Wednesday 2883 3321
22 Thursday 3103 3104
23 Friday 2670 2401
24 Saturday 964 1113
25 Sunday 824 1386
26 Monday 2426 2999
27 Tuesday 2856 3164
28 Wednesday 2994 3225
29 Thursday 2754 2886
30 Friday 2278 1879
Total empty cell 70,379 77,755

Source: Michigan Department of Transportation, Blue Water Bridge

Table 5. Averages for Sample Month – Daily Traffic Distribution of Export Commercial Vehicles for June 2000
Day of Week Week 1 Week 2 Week 3 Week 4 Week 5 Average
Sunday empty cell 2766 2229 2203 2210 2352
Monday empty cell 6054 5517 5619 5425 5654
Tuesday empty cell 6550 6263 6253 6020 6272
Wednesday empty cell 6643 6368 6204 6219 6359
Thursday 6520 6465 6318 6207 5640 6230
Friday 5712 5250 5211 5071 4157 5080
Saturday 2674 2208 2081 2077 empty cell 2260

Source: Michigan Department of Transportation, Blue Water Bridge

From discussions with the Michigan Department of Transportation and the Blue Water Bridge Authority, it was learned that backups typically did not occur on the U.S. side and, when they did, they did not grow very long. However, on the Canadian side, backups occurred on a regular basis and could stretch for many miles along Highway 402. On the Canadian side, the backups could occur as early as 8 am.

Data Collection Procedures

The data collection stations selected for the crossing were chosen because of the particular actions that occur at each site. Segments defined by the data collection stations were used to determine the commercial vehicle travel times and freight delay. As illustrated in Figures 3 through 8, the data collection sites were located at:

  • An advance station located upstream of the commercial vehicle queue – OB-1 and IB-1.
  • The import station (primary inspection booths before detailed, or secondary, inspection) – OB-2 and IB-2.

Data collection was conducted by recording commercial vehicle license plates as vehicles crossed fixed points within the data collection sites. Survey individuals or teams, were placed at each of the four data collection sites to record commercial vehicle license plate data. Figures 3 and 4 contain diagrams of the facilities on both sides of the border, including station locations and major points of inspection.

Collectors at these locations would record the last five characters of the front, lower-left license plate of as many trucks as possible that passed their location. When trucking firms register many vehicles at once, they often get assigned sequential license plate numbers. Using the last five characters helps to ensure that as different trucks operated by the same firm travel across the bridge that they are uniquely identified. License plate information was entered into Handspring Visor PDAs (handheld computers) with a special application designed for this project. Each entry was time-stamped with the current date and time. Prior to each day's collection, all PDAs were synchronized to the same time. Prior experience indicated that recording the entire license plate was too time consuming and that entering only the last four characters did not provide adequate distinction between different vehicles, so the project team chose to record the last five characters.

Typically, the queue of trucks crossing the border would not extend beyond the bridge plaza. However, on occasion the queue would extend onto the highway system. When this occurred, the data collector at the #1 location would have to move further from the bridge to a point beyond the end of the queue. In this way, they could continue to record trucks before they began their wait at the end of the line. When this or any other event of interest occurred, the collectors would use an "EVENT" feature of the PDA software to record it.

For each #1 location, the supervisor would record the distance from any data collection point other than the original position (which would be in the bridge plaza). During post-processing, the data from all locations nearer to the bridge than the farthest location would be adjusted to include the additional travel time from the farthest location to the original location. The travel time would be computed at free-flow speeds, since there would have been no queue at the times that the data were collected at these closer locations. In this way, the data all would appear to be collected from the same location, the one most distant from the bridge.

The data collection team used both cell phones and hand-held, two-way radios to maintain in touch with each other. This was particularly important when the queues lengthened such that a collector had to move farther upstream. The supervisor could be kept informed without repeated trips to each data collection location. This was also useful at the end of the day when the #1 collectors would inform the #2 collectors of the last truck they recorded, so the #2 collectors would know when to stop. While interference and cell tower locations created some problems with reception, each collector was usually able to use either their radio or cell phone to reach whomever they needed to speak with.

Data Collection Sample Size

Sample sizes are typically not a concern with videotape or handheld data entry devices, because the data collection includes a large number of vehicles. However, minimum sample sizes should be verified with variability values from field data. Early research found that sample sizes from 25 to 100 license matches were necessary for a given roadway segment and time period (Turner, et. al.). In all but one case at the beginning of a day of collection, there were sufficient records each day to meet this requirement.

Data Collection Equipment

As outlined in the "Data Collection Procedures" section above, Handspring Visor PDAs were used as the data entry device and proved adequate to the task. Low-end models with 2MB of storage capacity were selected as the application and data size were projected to be well below this limit. The Handspring Visors use the Palm OS (operating system) and have faster processing speeds (at least in side-by-side comparison with this application) and larger screen sizes than comparable models from Palm Computing.

A custom application was developed for the Palm OS that allowed the data collectors to identify their locations (e.g., OB-1, IB-2), the number of open booths (primarily used for the customs inspection booths), special events or other comments, and license plate information. A screen shot of the application interface is shown in Figure 9.

Photo of Handspring Visor PDA data collection device and software application
Figure 9. Data Collection Device and Software Application

The data were downloaded via a serial cable directly from the application into a text file on the field laptop computer, which was a Dell Latitude CPx H running with a 500 MHz Pentium III processor.

Data Collection Summary

Table 6 shows the number of commercial vehicle license plates recorded for each of the stations on each of the data collection days. Table 7 shows the average daily traffic volume as recorded by the Blue Water Bridge Authority (inbound direction) and the Michigan Department of Transportation (outbound direction). Hourly volumes are used in the calculation of delay; those are shown with the delay calculations in Tables 8 through 19.

Table 6. Number of Commercial Vehicle License Plates Collected
Station 6/12/01 6/13/01 6/14/01 8/14/01 8/15/01 8/16/01
OB-1 1470 1712 1695 1334 1592 1656
OB-2 1545 1858 1841 1445 1669 1655
IB-1 1396 1745 1550 1469 1623 1461
IB-4 1679 1800 1695 1584 1787 1556
Total 6090 7115 6781 5832 6671 6328

Table 7. Average Daily Traffic at the Blue Water Bridge
Direction 6/12/01 6/13/01 6/14/01 8/14/01 8/15/01 8/16/01
Inbound 3335 3305 3029 3056 3041 2771
Outbound 2626 2981 2973 2668 2768 2844
Total 5961 6286 6002 5724 5809 5615

Data Quality Steps

At the end of each day of data collection, the supervisor would collect the PDAs and download the data into the field laptop computer where it was stored on the hard drive. The data would be examined for any anomalies and transferred across the Internet to a secondary location for backup purposes. The OB-1 and OB-2 data would be merged together and license plates from the two locations would be "matched" using a spreadsheet developed in Microsoft Excel. As it is easy to mistake certain characters, particularly letters that looked like numbers, the license plate data was pre-processed. All 'I's were replaced with '1's; all 'O's, 'D's, and 'Q's were replaced with '0's; all 'S's were replaced with '5's; and all 'Z's were replaced with '2's. In addition, the data collectors were instructed to always use '1's for 'I's and '0's for 'O's (i.e., to use the digit, rather than the letter).

Occasionally, collectors would be unsure about a license plate and would append "QQQ" to their entry. This would typically occur when several trucks passed the collector in rapid succession or if one truck blocked the license plate of another and he or she could only manage a quick glimpse. This would allow the supervisor to search the downloaded data for a potential match by using the travel times of other trucks that were recorded in the same general time frame. During this process, the supervisor could also identify the few records in which the data collector forgot to press "ENTER" after recording a license plate before recording the next one. These ten-character entries could be split into two and the time for the first interpolated from the adjacent entries if they were less than a minute or so apart.

Data post-processing also included a step to identify any anomalies in the data, including outliers. Outliers, records that indicated travel times significantly greater than typical for that time period, were most often caused by recording the license plate of a vehicle only some of the time as it made repeated trips across the border during a single day. This is because the matching algorithm uses the most recent time at the #1 position when matching to a record from a #2 location. For example, if the vehicle was recorded as it headed from Canada to the U.S. early in the morning, later returned to Canada, was missed as it re-entered the U.S. later in the day, and then recorded on its subsequent return to Canada, the #1 time from its first trip would be matched with it #1 time from the first trip (for a valid travel time) an also matched to the #2 time from its second trip (an invalid travel time). This invalid travel time would be easily identified by manual inspection of the data, aided by highlighting those travel times above a specific, but variable, threshold.

previous | next
Office of Operations