Origin-destination data (and route patronage data)

[aldonius]

I discovered that TransLink published origin-destination data aggregated by month for February to October last year:

https://data.qld.gov.au/dataset/go-card-transaction-data

• Tweet

[ozbob]

Thanks.  Next question why has publication stopped?

• Tweet

[aldonius]

October coincides with the commencement of #RailFail...

• Tweet

[OzGamer]

Edit: I messed up the Excel. See post further below.

• Tweet

[OzGamer]

Edit: Please ignore - I messed up.    See post further below.

• Tweet

[STB]

Is that in terms of passenger loads?  I know from personal experience, the Bay Islands ferry does get full loads as it's the only way to/from the islands and the mainland and each ferry can carry quite a few seats and standees (can't remember how many off the top of my head but it's gotta be at least more than 60 seats I think?)

• Tweet

[aldonius]

With the October file, I got numbers that were what I was expecting: 12M trips for the month.

• Tweet

[#Metro]

And the top 20 "routes" according to the same data:

Hi, the data does not make a lot of sense. It is suggesting that route 184 carries more passengers than the second most popular bus route in Brisbane the route 199.

And apparently, route 125 is even busier? Difficult to believe!!

 

• Tweet

[techblitz]

Not so hard to believe metro if your a regular Ipswich rd user.
Even in competition with the 110,115,100,116....It regularly has standing loads evenings and on weekend afternoons...both days...its the all stops factor...lots of elderly use the route solely for that factor........both the 124 and the 125 get packed pm peak outbound......probably wont be long before we see the first 'sorry bus full' 125.....the Ipswich rd walkup patronage has gotten progressively busier since 2013 due to gentrification around westend,south brisbane,wooloongabba,buranda where a lot of low income earners have moved to places like Dutton park,annerley,moorvale etc.
The route is also carrying a lot between Gcity and Griffith uni...

• Tweet

[HappyTrainGuy]

306 ranked higher than a 330/333/340/345........

• Tweet

[aldonius]

I've got aggregate route data (from a pivot table). The route rankings are exactly what you'd expect. I'm not sure how OzGamer did their analysis.

View that here: https://docs.google.com/spreadsheets/d/1VDDw1mdV1Rp4czZ0h3pYVbNvn4JZu1Rxr_9SeetBJPk/edit?usp=sharing

• Tweet

[techblitz]

nice aldonius.......that list more accurately reflects the popularity of each route!

125/174/175 ahead of the bulimba routes 230/235.....I would have expected more from those 2 routes.....

buz the 314! 

• Tweet

[Cazza]

buz the 314! 

I'll second that!

• Tweet

[aldonius]

I've done March as well for comparison (March is usually the busiest time of year in Auckland and we're pretty similar).

And it was busier then - more like 14 million trips for the month.

https://docs.google.com/spreadsheets/d/1XNYWl2UI0_7uGYBfrn7BOV4wEaAJT5ZgPeuIvJK3Dis/edit?usp=sharing

• Tweet

[Cazza]

^What is route 64?

• Tweet

[techblitz]

306 ranked higher than a 330/333/340/345........

take a look at the numbers its getting vs number of services(frequency)...no wonder its up there....its performing better than the 110,230,235 and they have much higher frequency

• Tweet

[aldonius]

^What is route 64?

I have no idea; I don't think it's supposed to exist...

• Tweet

[techblitz]

march top 10 busiest rockets

p137
p206
p205
p217
p443
p141
p332
p129
p179
p119

• Tweet

[SurfRail]

^What is route 64?

I think it's a Noosa free bus route.

• Tweet

[Cazza]

^What is route 64?

I think it's a Noosa free bus route.

Ah that's right. Cheers

• Tweet

[OzGamer]

Apologies for my not looking at the data structure more carefully and causing confusion before. Nothing to say but that I was insufficiently careful - sorry! Here are the top twenty routes. Unfortunately the Go Card data can't separate train lines but it's here for interest. Good to see that the GCLR is much busier than any individual bus route.

Rail	3,544,817
GCLR	672,239
BCC Ferries	292,475
66	257,676
199	210,151
412	192,370
60	190,308
150	188,353
130	185,818
196	148,744
140	141,008
330	132,553
444	128,131
100	126,878
111	125,688
700	125,105
345	124,369
120	123,008
333	117,093
340	116,131

• Tweet

[techblitz]

^ concerning omission from that list is no old Cleveland rd routes. Clearly shows the cannibalisation/duplication issues.

• Tweet

[OzGamer]

^ concerning omission from that list is no old Cleveland rd routes. Clearly shows the cannibalisation/duplication issues.

They're pretty close behind:

222      103,400
200      92,988
204      71,462

• Tweet

[James]

I think what would be more interesting would be the routes ranked #21-40. This would tell us any good BUZ candidates as well as any BUZ routes which aren't pulling their weight.

• Tweet

[OzGamer]

21-40

Most of these are either already frequent routes or largely share corridors with frequent routes. The only quite separate ones that might be suitable for upgrading seem to be the 300 and the 174/175, although the latter are somewhat overlapping with the 170. The 170 itself is down on 28,894.

555	111,226
180	105,498
222	103,400
169	97,999
61	94,267
200	92,988
Bay Islands Transit	86,175
375	85,036
204	71,462
385	71,073
704	64,915
300	64,026
600	63,526
390	60,954
139	59,770
174	54,145
175	54,018
370	53,139
750	53,102
29	51,288

• Tweet

[Mr X]

Interesting seeing the AM and PM peak spreads in some routes, especially the rockets

136 AM 3645 PM 1930
153 AM 4410 PM 2076
156 AM 14532 PM 4718
162 AM 5112 PM 2757
P157 AM 2778 PM 5398

I assume city stop locations + fewer services would be why these routes are generally less used in PM peak.

• Tweet

[techblitz]

21-40

Most of these are either already frequent routes or largely share corridors with frequent routes. The only quite separate ones that might be suitable for upgrading seem to be the 300 and the 174/175, although the latter are somewhat overlapping with the 170. The 170 itself is down on 28,894.

555	111,226
180	105,498
222	103,400
169	97,999
61	94,267
200	92,988
Bay Islands Transit	86,175
375	85,036
204	71,462
385	71,073
704	64,915
300	64,026
600	63,526
390	60,954
139	59,770
174	54,145
175	54,018
370	53,139
750	53,102
29	51,288

and no inner waterworks rd routes on that list either. Clearly shows that the corridor isnt worthy of buz just yet for varying reasons from vehicle traffic flow to terrain.....there basically needs to be far more on-street development for it to get anywhere near buz patronage levels.And/or passing directly to a university.

• Tweet

[SurfRail]

^ Hardly.  You would need to look at corridors to make that kind of call.  It would be like me claiming the 700 is about as busy as the SEB because it carries around the same patronage as the 111.

• Tweet

[#Metro]

RBOT has a model of both the current BCC bus network and a proposed New Bus Network.

You can use the RBOT Model of the BCC bus network to see which buses are on which corridors

RBOT Model of BCC bus network: http://tiny.cc/checkyourbus

What I can see is that there is definitely room for a BulimbaGlider.

Using Aldonius data sheet (thank you, link in OP above) we can look at what the patronage would be if the 230 and 235 were combined.

230 Inbound - 24192

230 Outbound - 17772

235 Inbound - 14881

235 Outbound - 17963

Total: 74,808 (Assuming no growth)

Now we know that when we double the frequency, we essentially double the patronage.

BUZification would bring that patronage up to 149 616 (so essentially 150 000)

That would be comparable to what the BUZ 333 or 111 carries.

• Tweet

[Gazza]

Would it be possible to get a list of just the top twenty 700 series routes?

• Tweet

[aldonius]

Would it be possible to get a list of just the top twenty 700 series routes?

If you go to the 'Totals' tab of the spreadsheet at the link I posted a page ago, it should be filtered to only routes starting with a 7 and sorted by descending patronage.

• Tweet

[Gazza]

Sweet Awesome, thanks for the effort.
It has caught up to June 2017...how readily can you do full year performance?

Is there much involved with formatting the data?

Finally Bob, this thread totally deserves to be pinned at the top, its a very useful go-to.

• Tweet

[aldonius]

From memory, the initial data crunch is just a pivot table in libreoffice. Shouldn't be overly difficult

• Tweet

[Gazza]

No worries...I can sort of see how it works...each route has stop IDs, but you'd just combine all trips under a certain route number into one.
dont really know enough about data processing to do it properly though.

Is the data laid out consistently enough that you could do a merge of the twelve monthly sets into a 15-17 FY summary table?

This is gold!

• Tweet

[aldonius]

It should be laid out the same way each time. Why would they change it?

Summary table should be doable. Don't know when I'll have it done, though.

• Tweet

[ozbob]

TransLink Origin-Destination Trips

>> https://data.qld.gov.au/dataset/go-card-transaction-data

• Tweet

[techblitz]

Cheers ozbob.
Done a little digging on inala station stop 13044.
No avm machine....ridiculous amount of paper tickets being sold compared to other routes in seq.

Brisbane Transport   2018-02   100   Inbound   Weekday (8:30am-2:59:59pm)   Paper   13044   n/a   536
Brisbane Transport   2018-02   100   Inbound   Weekday (12:00am-8:29:59am)   Paper   13044   n/a   259
Brisbane Transport   2018-02   100   Inbound   Weekday (3:00pm-6:59:59pm)   Paper   13044   n/a   189
Brisbane Transport   2018-02   100   Inbound   Weekday (7:00pm-11:59:59pm)   Paper   13044   n/a   46


that's just the 100...the 110 is just as bad in terms of number of passengers to paper ticket sales.
This is inala factor and translink is cashing in BIGTIME by not installing an avm machine.
The sad thing is.... this paper tickets ripoff is happening right in the premiers own locality and in one of the poorest suburbs in Brisbane with a high number of new non-English speaking migrants who essentially don't know that gocards are cheaper.
Put a friggin machine there FFS so as to at least arouse their curiosity and hopefully transition them to gocards 

• Tweet

[ozbob]

 

Lots of information there even if a bit clumsy to get around.  When I have some more time will have a closer look.

• Tweet

[Cazza]

Lol, my laptop struggles to open to document, let alone look through it.

• Tweet

[Whippa]

I have done an analysis on updated data for Oct 2017.

https://docs.google.com/spreadsheets/d/12lLYMfavu5WIcVhbsHoBeFLR8915wGmFQZUoYORjD1E/edit?usp=sharing

• Tweet