• Welcome to RAIL - Back On Track Forum.
 

Origin-destination data (and route patronage data)

Started by aldonius, June 26, 2017, 00:10:14 AM

Previous topic - Next topic

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

ozbob

Thanks.  Next question why has publication stopped?
Half baked projects, have long term consequences ...
Ozbob's Gallery Forum   Facebook  X  Threads  Mastodon  BlueSky

aldonius

October coincides with the commencement of #RailFail...

OzGamer

#3
Edit: I messed up the Excel. :-[ See post further below.

OzGamer

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

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?)

aldonius

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

#Metro

QuoteAnd 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.

techblitz

#8
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...

HappyTrainGuy

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

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


techblitz

#11
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)


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


techblitz

Quote from: HappyTrainGuy on June 26, 2017, 19:27:50 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

aldonius


techblitz

march top 10 busiest rockets

p137
p206
p205
p217
p443
p141
p332
p129
p179
p119

SurfRail

Ride the G:


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 

techblitz

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

OzGamer

Quote from: techblitz 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.

They're pretty close behind:

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

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.
Is it really that hard to run frequent, reliable public transport?

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

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.
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.

techblitz

Quote from: OzGamer on June 27, 2017, 14: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
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.

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.
Ride the G:

#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.
Negative people... have a problem for every solution. Posts are commentary and are not necessarily endorsed by RAIL Back on Track or its members.

Gazza

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

aldonius

Quote from: Gazza on August 30, 2017, 16:29:35 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.

Gazza

#31
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.

aldonius

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

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!



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.

ozbob

Half baked projects, have long term consequences ...
Ozbob's Gallery Forum   Facebook  X  Threads  Mastodon  BlueSky

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  :thsdo :thsdo


ozbob

 :-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 ...
Ozbob's Gallery Forum   Facebook  X  Threads  Mastodon  BlueSky

Cazza

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


🡱 🡳