Origin-destination data (and route patronage data)

[techblitz]

varsity lakes to central

weekend

Queensland Rail   2018-02   Rail   Rail   Weekend   go card   600247   600018   197 << massive decrease
Queensland Rail   2016-09   Rail   Rail   Weekend   go card   600247   600018   366


weekday mornings

Queensland Rail   2016-09   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600247   600018   2613
Queensland Rail   2018-02   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600247   600018   2518

[techblitz]

goodna
Queensland Rail   2018-02   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600331   600018   4766
Queensland Rail   2016-09   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600331   600018   4294 << increase 


Nundah takes the cake.....so far...

Queensland Rail   2016-09   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600403   600018   11581
Queensland Rail   2018-02   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600403   600018   8814 << 25% decrease

[ozbob]

[techblitz]

a few more.....Toombul beats Nundah..

Decreases

Toombul -35%
Wooloowin -20%

Good increases...

Eagle junction + 28% << frequency is king
Carseldine +35% << surprise package

[300LA]

a few more.....Toombul beats Nundah..

Decreases

Toombul -35%
Wooloowin -20%

Good increases...

Eagle junction + 28% << frequency is king
Carseldine +35% << surprise package

Is it possible to do a total comparisson of Northgate + Nundah + Toombul + Eagle Junction?
Be interesting to see if pax are simply redistributing away from the lower frequency stations or if they've stopped showing up.

[STB]

It is telling that some people would rather sit in a bus for an hour in traffic than risk, in their minds rail.

yep.
I'm assuming the walkup patronage there @ toowong prefer the bus because of the increased risk of station skipping/overcrowding and mech issues on rail.
In the end it comes down to disruption risk/comfort vs frequency available. Bus is winning at the moment and its showing in the figures...

Actually when I was living in the area, I preferred the bus due to Toowong station being a pain to get into (the design of Toowong Village is incredibly annoying).

[aldonius]

Actually when I was living in the area, I preferred the bus due to Toowong station being a pain to get into (the design of Toowong Village is incredibly annoying).

Amen to that!

[James]

Actually when I was living in the area, I preferred the bus due to Toowong station being a pain to get into (the design of Toowong Village is incredibly annoying).

Depends where you are - I've never found it annoying to access from Benson St, that ramp to access the outbound stop is a pain though. Getting to the Park n Ride would be the biggest negative - I prefer to street park and walk access to it is that bad.

I guess if you are in the Lissner St area, access isn't that great.

[Whippa]

Did a Wharf by Wharf OCT17 analysis for the citycat.

Citycat: https://docs.google.com/spreadsheets/d/1ZVP_60SmEQNCqpMww_RJmRqDtpHIZplQJX-U9RsQ1aI/edit?usp=sharing

Also made a slighty more useful overall patronage summary for all SEQ routes and the % change on OCT16.
Bus: https://docs.google.com/spreadsheets/d/12lLYMfavu5WIcVhbsHoBeFLR8915wGmFQZUoYORjD1E/edit?usp=sharing

[SurfRail]

^ Your summary seems to include numerous Brisbane school routes in tyhe 7## range as if they are Gold Coast routes.

[ozbob]

Did a Wharf by Wharf OCT17 analysis for the citycat.

Citycat: https://docs.google.com/spreadsheets/d/1ZVP_60SmEQNCqpMww_RJmRqDtpHIZplQJX-U9RsQ1aI/edit?usp=sharing

Also made a slighty more useful overall patronage summary for all SEQ routes and the % change on OCT16.
Bus: https://docs.google.com/spreadsheets/d/12lLYMfavu5WIcVhbsHoBeFLR8915wGmFQZUoYORjD1E/edit?usp=sharing

Thanks Whippa!

[Cazza]

Slightly disappointing that all routes in the Ipswich region have had a decline in October patronage except the 506, 512 and 529.

[Fares_Fair]

February 2018 patronage.
It's a spreadsheet with over half-a-million lines (526,416)

It's hardly easy to access or correlate.
I don't know the origin number and destination number of every public transport locale in South East Queensland.

It needs to be made useful.

[ozbob]

https://twitter.com/Robert_Dow/status/1037866564001746946

[ozbob]

https://twitter.com/Robert_Dow/status/1039907129287749632

[henrus1]

Hi All

I'd like to share a small project I've created based on the origin-destination data across 30 months (February 2016 to July 2018).

In short, I've mapped every stop on the SEQ Translink network and calculated a total touch on, touch off and paper ticket figure for the stop.

Have a look and feel free to provide comments/feedback and I'll happily answer any questions that come up as well.

Head to
https://seqtransit.henrus1.com/stop-usage-maps
then select the Jul-18 Touch on Map.

It's obviously not perfect some stops are missing, some data hasn't correctly matched from stops file but it's a start and at least provides a nice snapshot of the last 30 months at specific stops.

[ozbob]

Welcome henrus1 !

Brilliant, thanks for sharing the information.

[techblitz]

nice work henrus 
This will be good for paper ticket purchases vs gocard scans at selected stops to see which stops are selling a high ratio of paper tickets.

[Cazza]

nice work henrus 
This will be good for paper ticket purchases vs gocard scans at selected stops to see which stops are selling a high ratio of paper tickets.

Check out the stop at Lone Pine: 6152 people touched on and 2154 paper tickets were purchased

Thats almost 40% of all boardings were paper tickets.

Should there be a GoCard machine there or even give Lone Pine the licence to sell GoCards? I would assume most passengers come from Indro so I'm surprised they haven't used the machines or newsagents there.

[Cazza]

https://docs.google.com/spreadsheets/d/12lLYMfavu5WIcVhbsHoBeFLR8915wGmFQZUoYORjD1E/edit#gid=2091638815

On another note, the P206 had better patronage than the 359, 310 and 220.

I caught the 7:30am inbound P206 on Tues and it showed up 1 minute late to the first stop (right outside Carina Depot- not sure how that happens) and by the time it got to Carina Shops, it was about 5 mins late so it leapfrogged the short runner from Carina into the City. It was a TAG and by the time we left Stones Corner, it was not quite standing room only (maybe 40-45 people).

[techblitz]

https://docs.google.com/spreadsheets/d/12lLYMfavu5WIcVhbsHoBeFLR8915wGmFQZUoYORjD1E/edit#gid=2091638815

On another note, the P206 had better patronage than the 359, 310 and 220.

I caught the 7:30am inbound P206 on Tues and it showed up 1 minute late to the first stop (right outside Carina Depot- not sure how that happens) and by the time it got to Carina Shops, it was about 5 mins late so it leapfrogged the short runner from Carina into the City. It was a TAG and by the time we left Stones Corner, it was not quite standing room only (maybe 40-45 people).

Its the sheer convenience of the route alignment which makes it a success.
In the time that it takes you to walk from the far east/north-east side of the cbd  to Adelaide st/kgbs/qsbs and wait for one of the core frequent buses there your already at stones corner/coorparoo junction..
I put that rocket in as one of the most convenient..

[aldonius]

They're a bit behind on updating this one. I guess it was nice while it lasted.

Edit: I contacted them and hopefully it will be updated soon. Apparently updates to this are more of a couple-of-times-a-year thing now.

[techblitz]

Finally updated 

Oct 2018 - april 2019

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

[techblitz]

Random assortment of routes passengers per service average....for April 2019..
Note that the o-d-d doesn't include fare evasion so will be slightly different..
Most efficient route on that list I would give to the 411...

abbrev:

spm - services per month
pps - passengers per service


110 >>1460 spm && 31799 == 21.78 pps

302 >> 198 spm && 4284 == 21.63 pps

322 >> 1084 spm && 22268 == 20.54 pps

232 >> 796 spm && 14798 == 18.60 pps

411 >> 2010 spm && 36862 == 18.33 pps

325 >> 1504 spm && 26242 == 17.45 pps

750 >> 2921 spm && 46250 == 15.83 pps

123 >> 644 spm && 9309 == 14.45 pps

615 >> 1032 spm && 14491 == 14.04 pps

640 >> 894 spm && 11354 == 12.70 pps

224 >> 328 spm && 3514 == 10.71 pps

753 >> 718 spm &&  6959 == 9.69 pps

369 >> 1792 spm && 17184 == 9.58 pps

223 >> 296 spm && 2728 == 9.21 pps

765 >> 3454 spm && 30183 == 8.73 pps

754 >> 704 spm && 5918 == 8.4 pps

522 >> 1480 spm && 12155 == 8.21 pps

534 >> 836 spm && 6092 == 7.28 pps

735 >> 1836 spm && 13237 == 7.20 pps

307 >> 218 spm && 1483 == 6.8 pps

757 >> 628 spm && 3862 == 6.14 pps

691 >> 1298 spm && 7466 == 5.75 pps

752  >> 568 spm && 3217 == 5.66 pps

751 >> 658 spm && 3464 == 5.26 pps

758 >> 416 spm && 859 == 2.06 pps

304 >> 440 spm && 497 == 1.12 pps

[Cazza]

Nice work!

A few routes that stick out include the 325 (KG kids probably boost that number a fair bit), 123 (probably a similar story here probably with other school kids), 232 and 322. It should be noted that although these routes don't necessarily run at a high frequency (which can explain these slightly higher passenger numbers/service), it's because they have more than one major trip generator along the route (usually at either end).

Having routes stop at or terminate at these other trip generators (aside from the CBD) such as shopping centres/major interchanges and uni's for example, provide these routes with more than one type of travel pattern that commuters onboard these routes have. It's what makes them successful as people are regularly getting on and off the bus.

Re. the 411, would it be worth looking at sending it up Mt Coot-tha instead of to the City? It provides a direct connection for uni students up the hill, whilst servicing Toowong Station for a transfer onto other western suburbs routes (like what has been suggested in the past). It then allows the 471 to still continue to the city at the same frequency, whilst providing more off-peak, weekend and night-time services to the summit (on the 411) for pretty much the same amount of resources than it going to the City (I would assume based on current travel times).

[techblitz]

thnx cazza 

Some time in the next couple of days I will add on to those routes an approx. average trip time per service..
eg: 110 (55mins tt) or the 411(27mins tt)
Will give a slightly more accurate picture of a routes efficiency.....we need to sort out the bad eggs from the good and pressure the bad eggs to be extended/cut/merged or whatever...

[ozbob]

A correspondent on RBoT Facebook has commented that Translink's Origin-Destination Data does not include trips taken on bank cards etc.

> https://www.facebook.com/RAILBackOnTrack/posts/981818543985001?comment_id=554405780641418&reply_comment_id=8436775043086588

[aldonius]

Oh that's a bit frustrating. It probably doesn't include Odin Pass either which would probably be pretty distortionary on UQ routes.