Queensland UTC +10
Terms of use Privacy About us Media Contact

Links

Author Topic: Origin-destination data (and route patronage data)  (Read 3589 times)

Offline aldonius

  • Member
  • *****
  • Posts: 1160
Origin-destination data (and route patronage data)
« on: June 26, 2017, 12:10:14 AM »
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
« Last Edit: June 26, 2017, 09:48:16 PM by aldonius »

Online ozbob

  • Administrator
  • Member
  • *****
  • Posts: 78679
    • RAIL Back On Track
Re: Origin-destination data (and route patronage data)
« Reply #1 on: June 26, 2017, 03:41:58 AM »
Thanks.  Next question why has publication stopped?
Half baked projects, have long term consequences ...
  Bob's Blog

Offline aldonius

  • Member
  • *****
  • Posts: 1160
Re: Origin-destination data (and route patronage data)
« Reply #2 on: June 26, 2017, 02:18:00 PM »
October coincides with the commencement of #RailFail...

Offline OzGamer

  • Member
  • *****
  • Posts: 158
Re: Origin-destination data (and route patronage data)
« Reply #3 on: June 26, 2017, 04:07:40 PM »
Edit: I messed up the Excel. :-[ See post further below.
« Last Edit: June 27, 2017, 10:33:23 AM by OzGamer »

Offline OzGamer

  • Member
  • *****
  • Posts: 158
Re: Origin-destination data (and route patronage data)
« Reply #4 on: June 26, 2017, 04:11:47 PM »
Edit: Please ignore - I messed up.  :-[  See post further below.
« Last Edit: June 27, 2017, 10:34:02 AM by OzGamer »

Offline STB

  • Member
  • *****
  • Posts: 565
Re: Origin-destination data (and route patronage data)
« Reply #5 on: June 26, 2017, 05:27:10 PM »
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?)

Offline aldonius

  • Member
  • *****
  • Posts: 1160
Re: Origin-destination data (and route patronage data)
« Reply #6 on: June 26, 2017, 05:28:41 PM »
With the October file, I got numbers that were what I was expecting: 12M trips for the month.

Offline #Metro

  • Member
  • *****
  • Posts: 19490
  • DON'T SIGN! DON'T RENEW!!
Re: Origin-destination data (and route patronage data)
« Reply #7 on: June 26, 2017, 06:24:29 PM »
Quote
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!!

 :is-
Negative people... have a problem for every solution.
Posts are commentary and are not necessarily endorsed by RAIL Back on Track or its members. Not affiliated with, paid by or in conspiracy with MTR/Metro.

Offline techblitz

  • Member
  • *****
  • Posts: 2177
Re: Origin-destination data (and route patronage data)
« Reply #8 on: June 26, 2017, 06:36:09 PM »
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...
« Last Edit: June 26, 2017, 06:54:15 PM by techblitz »

Offline HappyTrainGuy

  • Member
  • *****
  • Posts: 4565
  • My train... My people... My money!
Re: Origin-destination data (and route patronage data)
« Reply #9 on: June 26, 2017, 07:27:50 PM »
306 ranked higher than a 330/333/340/345........
"What housing crisis?? There are plenty of free mobile apartments rolling around on the rails every day"

Offline aldonius

  • Member
  • *****
  • Posts: 1160
Re: Origin-destination data (and route patronage data)
« Reply #10 on: June 26, 2017, 08:27:12 PM »
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


Offline techblitz

  • Member
  • *****
  • Posts: 2177
Re: Origin-destination data (and route patronage data)
« Reply #11 on: June 26, 2017, 08:59:14 PM »
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!  8) 8)
« Last Edit: June 26, 2017, 09:05:07 PM by techblitz »

Online Cazza

  • Member
  • *****
  • Posts: 486
Re: Origin-destination data (and route patronage data)
« Reply #12 on: June 26, 2017, 09:45:34 PM »

buz the 314!  8) 8)

I'll second that!

Offline aldonius

  • Member
  • *****
  • Posts: 1160
Re: Origin-destination data (and route patronage data)
« Reply #13 on: June 26, 2017, 09:47:47 PM »
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

Online Cazza

  • Member
  • *****
  • Posts: 486
Re: Origin-destination data (and route patronage data)
« Reply #14 on: June 26, 2017, 10:11:29 PM »
^What is route 64?

Offline techblitz

  • Member
  • *****
  • Posts: 2177
Re: Origin-destination data (and route patronage data)
« Reply #15 on: June 26, 2017, 10:26:24 PM »
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

Offline aldonius

  • Member
  • *****
  • Posts: 1160
Re: Origin-destination data (and route patronage data)
« Reply #16 on: June 26, 2017, 10:36:31 PM »
^What is route 64?

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

Offline techblitz

  • Member
  • *****
  • Posts: 2177
Re: Origin-destination data (and route patronage data)
« Reply #17 on: June 26, 2017, 10:49:21 PM »
march top 10 busiest rockets

p137
p206
p205
p217
p443
p141
p332
p129
p179
p119

Offline SurfRail

  • Global Moderator
  • Member
  • *****
  • Posts: 7198
Re: Origin-destination data (and route patronage data)
« Reply #18 on: June 27, 2017, 06:27:10 AM »
^What is route 64?

I think it's a Noosa free bus route.

Online Cazza

  • Member
  • *****
  • Posts: 486
Re: Origin-destination data (and route patronage data)
« Reply #19 on: June 27, 2017, 09:26:12 AM »
^What is route 64?

I think it's a Noosa free bus route.

Ah that's right. Cheers

Offline OzGamer

  • Member
  • *****
  • Posts: 158
Re: Origin-destination data (and route patronage data)
« Reply #20 on: June 27, 2017, 10:41:16 AM »
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 

Offline techblitz

  • Member
  • *****
  • Posts: 2177
Re: Origin-destination data (and route patronage data)
« Reply #21 on: June 27, 2017, 10:56:28 AM »
^ concerning omission from that list is no old Cleveland rd routes. Clearly shows the cannibalisation/duplication issues.

Offline OzGamer

  • Member
  • *****
  • Posts: 158
Re: Origin-destination data (and route patronage data)
« Reply #22 on: June 27, 2017, 11:04:48 AM »
^ 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

Offline James

  • Member
  • *****
  • Posts: 2058
Re: Origin-destination data (and route patronage data)
« Reply #23 on: June 27, 2017, 02:24:25 PM »
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.
Is it really that hard to run frequent, reliable public transport?

Offline OzGamer

  • Member
  • *****
  • Posts: 158
Re: Origin-destination data (and route patronage data)
« Reply #24 on: June 27, 2017, 02:42:49 PM »
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

Offline Mr X

  • Member
  • *****
  • Posts: 1451
Re: Origin-destination data (and route patronage data)
« Reply #25 on: June 27, 2017, 03:48:17 PM »
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.
The user once known as Happy Bus User (HBU)
The opinions contained within my posts and profile are my own and don't necessarily reflect those of the greater Rail Back on Track community.

Offline techblitz

  • Member
  • *****
  • Posts: 2177
Re: Origin-destination data (and route patronage data)
« Reply #26 on: July 21, 2017, 12:03:17 PM »
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.

Offline SurfRail

  • Global Moderator
  • Member
  • *****
  • Posts: 7198
Re: Origin-destination data (and route patronage data)
« Reply #27 on: July 21, 2017, 03:43:55 PM »
^ 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.

Offline #Metro

  • Member
  • *****
  • Posts: 19490
  • DON'T SIGN! DON'T RENEW!!
Re: Origin-destination data (and route patronage data)
« Reply #28 on: July 21, 2017, 04:04:57 PM »

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.
Negative people... have a problem for every solution.
Posts are commentary and are not necessarily endorsed by RAIL Back on Track or its members. Not affiliated with, paid by or in conspiracy with MTR/Metro.

Offline Gazza

  • Member
  • *****
  • Posts: 4690
Re: Origin-destination data (and route patronage data)
« Reply #29 on: August 30, 2017, 04:29:35 PM »
Would it be possible to get a list of just the top twenty 700 series routes?

Offline aldonius

  • Member
  • *****
  • Posts: 1160
Re: Origin-destination data (and route patronage data)
« Reply #30 on: August 30, 2017, 05:29:27 PM »
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.

Offline Gazza

  • Member
  • *****
  • Posts: 4690
Re: Origin-destination data (and route patronage data)
« Reply #31 on: August 30, 2017, 10:59:16 PM »
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.
« Last Edit: August 31, 2017, 12:40:30 AM by Gazza »

Offline aldonius

  • Member
  • *****
  • Posts: 1160
Re: Origin-destination data (and route patronage data)
« Reply #32 on: August 31, 2017, 12:51:26 AM »
From memory, the initial data crunch is just a pivot table in libreoffice. Shouldn't be overly difficult

Offline Gazza

  • Member
  • *****
  • Posts: 4690
Re: Origin-destination data (and route patronage data)
« Reply #33 on: August 31, 2017, 01:07:57 AM »
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!



Offline aldonius

  • Member
  • *****
  • Posts: 1160
Re: Origin-destination data (and route patronage data)
« Reply #34 on: August 31, 2017, 01:41:52 AM »
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.

Online ozbob

  • Administrator
  • Member
  • *****
  • Posts: 78679
    • RAIL Back On Track
Re: Origin-destination data (and route patronage data)
« Reply #35 on: May 31, 2018, 06:52:59 PM »
TransLink Origin-Destination Trips

>> https://data.qld.gov.au/dataset/go-card-transaction-data
Half baked projects, have long term consequences ...
  Bob's Blog

Offline techblitz

  • Member
  • *****
  • Posts: 2177
Re: Origin-destination data (and route patronage data)
« Reply #36 on: June 01, 2018, 09:23:22 AM »
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  :thsdo :thsdo


Online ozbob

  • Administrator
  • Member
  • *****
  • Posts: 78679
    • RAIL Back On Track
Re: Origin-destination data (and route patronage data)
« Reply #37 on: June 01, 2018, 10:15:34 AM »
 :-c :-t

Lots of information there even if a bit clumsy to get around.  When I have some more time will have a closer look.
Half baked projects, have long term consequences ...
  Bob's Blog

Online Cazza

  • Member
  • *****
  • Posts: 486
Re: Origin-destination data (and route patronage data)
« Reply #38 on: June 01, 2018, 05:44:23 PM »
Lol, my laptop struggles to open to document, let alone look through it.

Offline Whippa

  • Member
  • *
  • Posts: 13
Re: Origin-destination data (and route patronage data)
« Reply #39 on: June 24, 2018, 04:33:29 PM »
I have done an analysis on updated data for Oct 2017.

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

 

Sitemap 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 


“You can't understand a city without using its public transportation system.” -- Erol Ozan