Sorry but there was a few errors in the data I posted last year, where:
- Most trip that differs between school day/non-school day were missing
- Error in data for trip begin/end at non-major stop. ie. the 130 that begins at Deer Lake Parkway, most trolly routes, etc.
- A few short-turn trips were missing all-together
- The 3:56AM trip of the 403 was missing.. I didn't know it start this early...
- Missing Friday-only trip.. my new data cannot distinguish these from the others, so I have to add them in
The effect were about 60 missing trips, 50 missing hours, max vehicle undercount by 10, and the average trip length off by 6 seconds.. Apparently, the number "1003" is actually the peak vehicles this year.. I'm good at predicting the future, eh?
I had corrected the post above. In fact, there might be still some error within, but I'm doing this so it will be consistent with the data below, and any data in the future if I'm still doing this.
Now... the data for September this year, lets see how the "funding stabilization" do to our transit system...
10 Earliest starts:
Code:
403N 3:56a
701W 4:10a
351N 4:11a
601N 4:21a
041E 4:22a
010E 4:25a
791W 4:25a
403N 4:29a
502W 4:32a
301W 4:35a
The 351 trips now depart later, and the 791 depart earlier. Apart from this, the list is essentially unchanged.
10 Latest Finishes:
Code:
N10S 4:01x
N19E 4:03x
N10S 4:20x
N10N 4:27x
N19E 4:28x
N9E 4:29x
N10S 4:50x
N10N 4:57x
N10S 5:20x
N10N 5:27x
Apart from 1 N10 trip running slower than last year, nothing else changed.
Longest trips, there are
27 (-2) trips that's are longer than
1.5 hr:
Code:
1:55 997W [9:27a, 10:27a]
1:42 997E [12:55p, 1:25p, 7:00p, 7:30p, 8:00p]
1:37 502E [3:00p]
1:35 017E [2:16p, 2:28p, 2:39p, 2:49p]
1:34 160E [4:12p]
1:33 017E [2:59p, 3:09p, 3:19p, 3:29p, 3:39p, 3:47p, 3:55p, 4:03p, 4:11p]
1:33 160E [4:42p]
1:31 017E [4:19p, 4:27p, 4:35p]
1:30 017E [2:04p]
The trip for eastbound 17 between 1:30p and 2:00p were running about 2-4 min faster, hence dropped out of the list
Shortest trip is only
3 min, and there are
19 of them:
Code:
028N [5:47a]
C36S [5:33p]
C87W [all 17 trips]
And there are
9 (+1) trips that are only
4 min long:
Code:
228S [12:39x, 1:09x]
239W [11:14p, 1:56x, 2:01x]
403N [1:08x, 1:38x, 2:08x]
C37E [7:25a] *new*
On a regular day, there are
12343 hr and 38 min (-0.6%) of scheduled trips. The top 25 routes with the most services are:
Code:
#1 996 368 hr 26 min
#2 999 348 hr 49 min
#3 99 289 hr 53 min
#4 (+2) 10 283 hr 23 min
#5 (-1) 17 275 hr 31 min
#6 (-1) 9 272 hr 12 min
#7 22 259 hr 24 min
#8 41 250 hr 26 min
#9 20 250 hr 00 min
#10 25 239 hr 32 min
#11 135 233 hr 18 min
#12 (+1) 980 219 hr 14 min
#13 (+1) 16 211 hr 42 min
#14 (+1) 410 211 hr 01 min
#15 (+1) 3 197 hr 01 min
#16 (-4) 8 196 hr 26 min
#17 49 182 hr 55 min
#18 19 173 hr 21 min
#19 7 165 hr 26 min
#20 321 155 hr 58 min
#21 502 154 hr 22 min
#23 (+1) 106 144 hr 37 min
#22 (-1) 351 138 hr 13 min
#24 4 137 hr 24 min
#25 97 128 hr 04 min
Honorable mentions:
Code:
#28 239 121 hr 38 min Top Northshore route
#30 (+1) 701 116 hr 22 min Top Ridge Meadows route
#38 (-3) 160 100 hr 20 min Top Tri-cities route (non B-Line)[/color]
#47 C38 81 hr 35 min Top community shuttle route
#51 (-7) 601 77 hr 33 min Top South Delta route
#68 (-2) C23 52 hr 37 min Second place community shuttle route
#121 (+1) 998 25 hr 36 min SeaBus
#126 (-1) 997 24 hr 30 min Westcoast Express
#175 N10 10 hr 20 min Top nightbus route
Distribution of the top 50 routes, cut-off point is
79 hr 28 min (+40 min):
Code:
3 SkyTrain
2 B-Line
44 conventional
1 community shuttle
21 Vancouver
6 Burnaby/New West [135, 106, 130, 144, 129, 123]
2 Tri-Cities [97, 160, C38]
5 Northshore [239, 250, 240, 246, 210]
5 (+1) Surrey [321, 351, 320, 319, 341]
4 Richmond [410, 480, 401, 403]
1 Langley [502]
0 (-1) South Delta
1 Ridge Meadows [701]
The 601 is out of the list, and the 341 is in.. That's the only difference, apart from the change in the order within Northshore
The non-NightBus and school special route with the least service:
Code:
#216 (-1) 259 2 hr 1 minute
#217 (-1) 608 1 hour 54 min
#218 (-1) 242 1 hour 52 min
#220 (-1) 292 1 hour 22 min
#229 (-1) C90 0 hour 36 min
And new stat this time:
Code:
200-hours club 14 routes [-2.. the #3 and #8 are out of the list]
100-hours club 38 routes [+0.. #15 is out but #250 is in]
50-hours club 71 routes [-1.. #405, #C21 are out; #143 is in]
25-hours club 122 routes [-2]
There are a total of
21839 (+1.0%) scheduled trips per day in Metro Vancouver. The top 25 routes with most scheduled trips are:
Code:
#1 999 547 trips
#2 980 536 trips
#3 99 442 trips
#4 996 404 trips
#5 9 403 trips
#6T (+2) 20 332 trips
#6T (+1) 41 332 trips
#8 (-2) 8 317 trips
#9 5 303 trips
#10 6 299 trips
#11 (+2) 10 295 trips
#12 (-1) 135 286 trips
#13 (-1) 3 280 trips
#14 321 269 trips
#15T 130 263 trips
#15T 145 263 trips
#17 22 248 trips
#18 (+1) 17 240 trips
#19 (-1) 25 238 trips
#20 97 233 trips
#21 49 230 trips
#22 (+10) C21 220 trips
#23 (+13) C23 218 trips
#24 (-2) 246 216 trips
#25 (-2) 106 212 trips
#C21 and #C23 had squeezed #C38 and #320 out of the list.
Again, honorable mentions:
Code:
#29 (-3) 410 200 trips Top Richmond route
#38 (+1) 502 177 trips Top Langley route
#45 701 145 trips Top Ridge Meadows route
#46 351 144 trips Top Hwy99 route.. I suppose..
#57T (-1) 998 128 trips SeaBus
#64 (-1) 601 116 trips Top South Delta route
#191T 997 17 trips West Coast Express
#197T N10 13 trips Top Nightbus route
The distribution of top 50. Cut-off is
138 trips (+5 trips):
Code:
3 SkyTrain
2 B-Line
41 conventional
4 community shuttle
23 (-1) Vancouver
7 Burnaby/New West [135, 130, 145, 106, C8, 123, 144]
3 Tri-Cities [97, C38, 169]
4 (+1) Northshore [246, 239, 240, 250]
4 Surrey [321, 320, 319, 351]
4 Richmond [410, 403, 401, 402]
1 Langley [502]
0 South Delta
1 Ridge Meadows [701]
#27 and #112 are out of the list; #250 and the new route #C8 are in.
The routes that have the least numbers of runs is
#292 [2 trips], follows by #242, #C90, #N24 [4 trips each], and #259 [5 trips]. This is the same as last year.
Code:
300-trips club 9 routes [+0.. same as last year]
200-trips club 29 routes [+3.. #239, #C21, and #C23 are in]
100-trips club 74 routes [+1.. #C3, #C8 are the new members; #C26 is out]
50-trips club 147 routes [+1]
The average trip time system-wide is
33 min and 55 seconds (-1.8%). The longest and shortest routes:
Code:
#1 997 1:26:28
#2 N9 1:17:00
#3 (+1) 341 1:11:28
#4 16 1:11:22
#5 (+2) 17 1:08:53
#6 160 1:08:25
#7 (+2) 590 1:07:17
#8 (+2) 7 1:06:37
#9 (-4) 354 1:04:33
#10 (+3) N19 1:03:27
#11 410 1:03:18
#12 22 1:02:45
#13 (+2) 388 1:02:08
#14 (+2) 25 1:00:23
... ...
#224 (+1) C88 0:09:00
#225 (+1) C90 0:09:00
#226 (+1) C22 0:09:00
#227 (-4) C2 0:08:45
#229 C6 0:07:37
#230 C40 0:07:36
#231 C20 0:07:30
#232 C86 0:07:30
#233 C87 0:05:25
#234 C8 0:05:00
There's now a domination of community shuttle for the 10 shortest route in Metro Vancouver. Note there are currently
14 (-2) routes longer than 1 hour.
The peak number of vehicles in service, which are actually carrying people, not including "not in service" or layover, are
1003 (-10), occurs at
4:51pm. This is the exactly same time as last year.
The routes with the most vehicles:
Code:
Veh Routes
=== =====
31 999
28 22
26 99
25 10, 25
24 9
22 17, 41, 135, 996
20 49, 20
19 16, 410
16 8, 502
14 3, 7, 43, 980
13 19, 980
12 4, 106, 130, 321, 351, 401
11 97, 701
10 129, 144, 210, 239, 240, 246, 320, 403
The top community shuttle is #C38, with 8 vehicles, follows by #C27 and #C28, both with 6. The top Nightbus route is #N10 and #N19, with 4 vehicles each.
The following routes have 1 bus running at the most, consider yourself lucky when you see them:
179, 256, 259, 391, 606, C2, C6, C8, C10, C12, C19, C20, C22, C48, C49, C52, C60, C61, C64, C84, C88, C89, C90, C99, N6
The biggest winners and losers compared to last year, in term of absolute hours:
Code:
#1 250 +20 hr 31 min +36 trips, improve from every 30 to 15 min mid-day
#2 C8 +15 hr 00 min +180 trips, new route created with hr from C4
#3 10 +12 hr 17 min +14 trips
#4 791 +7 hr 30 min construction re-route
#5 20 +6 hr 23 min +2 trips, plus traffic
#6 130 +6 hr 19 min traffic
#7 177 +6 hr 14 min construction re-route
#8 33 +5 hr 20 min traffic
#9 100 +4 hr 36 min traffic
#10 C92 +4 hr 16 min -2 trips, but bigger bus = slower boarding = more service hr!
#11 99 +3 hr 41 min traffic
#12 43 +2 hr 24 min traffic
#13 620 +2 hr 05 min +8 trips, the unscheduled trips seem to become "scheduled" in trip planner only
#14 129 +2 hr 01 min traffic
... ...
#224 311 -7 hr 14 min -5 trip, this is probably one of the worst cut.. no one taking this?
#225 49 -8 hr 51 min +10 trips, but lighter traffic
#226 3 -10 hr 38 min -2 trips, trip cut short in downtown
#227 601 -11 hr 28 min -2 trips, lighter traffic
#228 C26 -12 hr 15 min -58 trips, end of construction
#229 351 -12 hr 35 min lighter traffic
#230 C4 -14 hr 46 min -14 trips, route cut short to create C8
#231 480 -19 hr 13 min -5 trips, but many trips short-turned
#232 15 -23 hr 32 min -24 trips, cut
#233 8 -24 hr 16 min -40 trips, cut after 60ft bus introduced
The biggest winners and losers compared to last year, in term of relative hours, with +100% means doubling the service and -100% means complete elmination. See above for explanation:
Code:
#1 C8 +INF +180 trips, new route, restructure
#2 C92 +35.9% -2 trips, well.. i checked my calculation for this one
#3 250 +25.7% +36 trips, improvement
#4 C41 +16.5% extension to Bonson South
#6 258 +15.3% +3 trips, more am peak trips, but pm peak trip cut short at downtown (becomes 250)
#7 791 +15.0% construction
#8 177 +14.4% construction
#9 C84 +10.8% traffic... in Tsawwassen!?
#10 C89 +9.2% traffic, same as above
#11 620 +9.2% +8 trips, restructure
#12 C12 +8.8% extension to Brunswick
... ...
#221 8 -11.0% -40 trips, cuts
#222 C45 -11.9% -5 trips, end of construction
#223 604 -12.2% +1 trip, lighter traffic
#224 601 -12.9% lighter traffic
#225 C46 -14.5% -5 trips, end of construction
#226 480 -15.2% -5 trips, cuts
#227 602 -15.5% lighter traffic
#228 352 -18.8% lighter traffic
#229 15 -21.6% -24 trips, cuts
#230 311 -29.8% -5 trips, cuts
#231 C26 -33.0% -58 trips, end of construction
#232 125 -34.3% -8 trips, cuts
#233 C4 -43.8% -14 trips, restructure
The biggest winners and losers compared to last year, in term of absolute numbers of trips:
Code:
#1 C8 +180 new route, restructure
#2 C23 +39 improvement, restructure
#3 C3 +38 improvement, restructure
#4T 250 +36 improvement
#4T C21 +36 restructure
#6 239 +20 bus coming from North Van depot run as 239 instead of NIS
#7 10 +14 improvement
#8 49 +10 improvement
#9 620 +8 restructure
#10 258 +3 improvement
... ...
#224T 311 -5 cuts
#224T 480 -5 cuts
#224T C45 -5 end of construction
#224T C46 -5 end of construction
#228 97 -6 cuts, reduced frequency during evening
#229 125 -8 cuts
#230 C4 -14 restructure
#231 15 -24 cuts
#232 8 -40 cuts
#233 C26 -58 end of construction
The biggest winners and losers compared to last year, in term of relative numbers of trips:
Code:
#1 C8 +INF new route, restructure
#2 C3 +58.5% improvement, restructure
#3 258 +42.9% improvement
#4 250 +34.3% improvement
#5 620 +23.5% restructure
#6 C23 +21.8% improvement, restructure
#7 C21 +19.6% restructure
#8 10 +5.0% improvement
#9 49 +4.5% improvement
#10 604 +4.0% restructure
#11 C96 +2.5% improvement
#12 253 +2.2% improvement
... ...
#222 97 -2.5% cuts
#223 C92 -2.9% restructure
#224 603 -3.3% restructure
#225 480 -3.8% cuts
#226 8 -11.2% cuts
#227 15 -12.2% cuts
#228 C45 -12.5% end of construction
#229 311 -15.2% cuts
#230 C46 -16.1% end of construction
#231 C4 -16.3% restructure
#232 125 -23.5% cuts
#233 C26 -50.4% end of construction
Note:
980 = Canada Line
996 = Millennium Line
997 = West Coast Express
998 = SeaBus
999 = Expo Line
Source of the data is from Translink's GTFS feed.
The spreadsheet file with all the data can be downloaded
Here.