Origin-destination data (and route patronage data)

[ozbob]

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

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

Thank you!  Marvellous and very much appreciated.   

[Whippa]

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

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

Thank you!  Marvellous and very much appreciated.   

All good, happy to help out your good cause in whatever way I can. I have also created another sheet with station by station boardings+disembarkings on the QR network using the dataset as was requested by a number of people.

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

[ozbob]

 ^ Thanks!  Marvellous.   

Some interesting data there ... 

[ozbob]

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

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

[ozbob]

From https://docs.google.com/spreadsheets/d/1ttkB_dwql3PXGxG4MKqiJTmClUobeIZWKZ4MUxEXM9g/edit#gid=1901651870

Station patronage for October 2017










Note typo. Yandina

[ozbob]

A couple of caveats with the data:

1. it is go card data, so paper tickets are not included.  This could be significant for the BNE line.

2. No measure of fare evasion of course, for example the actual patronage at Goodna could be many thousands higher!   

Nonetheless, the relative patronage is very interesting.

Goodna is still the busiest station west of Darra excluding Ipswich.

Darra is getting very busy.

Springfield line patronage impressive.

Kippa Ring line not so impressive.

Ferny Grove solid.

We need to go to Traveston more often ... 

[matlock]

Yeronga gets strong patronage, and yet still hasn't been redone to DDA compliance. Yet Fairfield is next up and Yerongpilly was done a few years back... 

[ozbob]

Yeronga gets strong patronage, and yet still hasn't been redone to DDA compliance. Yet Fairfield is next up and Yerongpilly was done a few years back... 

Yo.  The patronage was the main reason they chose to service Yeronga rather than Yeerongpilly for the Gold Coast Games express pattern.
It is not as though they don't know.  When I first arrived in Brisbane 1969, Yeronga was my station. Still is much the same in terms of access.

[not_available]

Kippa Ring line not so impressive.

The Mango Hill > Kallangur > Murrumba Downs doesn't surprise me at all. All those extra carparks @ Murrumba are empty. Not doings its job as well as some people would like.

[aldonius]

I wonder if there'd be demand for a weekend morning market in the Murrumba Downs carpark? (Like what happens at Ferny.)

[DayboroStation]

Interesting to see the high patronage at Toowong Station, despite terrible frequency during peak times.

[SurfRail]

Stations to be closed - Bindha, Holmview, Wynnum, Gailes.  All justified not only on patronage grounds but based on geography, pattern of settlement, DDA non-compliance, the availability of other nearby services and the only advantage of keeping them open being for parking (which can be expanded at adjacent stations).  Hemmant and the Sunshine Coast stations for instance do not belong on this list because it is the only meaningful public transport nearby.

You really have to wonder about keeping Traveston open at this point.

[tazzer9]

surprising how high indooroopilly is.  Also surprising is how low my local station keperra is compared to some of the other FG line stations

[red dragin]

Kallangur does well considering the small car park. Feeder buses, Kiss n ride and walk up patronage (only to the north really) doing most of the work there I'd say.

[Arnz]

I do wonder whether if extending the 632 from Cooran to Traveston (directly replacing Traveston station) is another alternative (twice daily return Mon-Sat and one return per day on Sunday/Public Hols)

Just ensure it is co-ordinated (which would mean the driver sitting around at Cooroy for 3-5 mins) and links up to the Gympie North trains to/from Cooroy to ensure the 2-3 people that actually use Traveston can actually use it. 

[Cazza]

First off, amazing job Whippa! All very much appreciated by myself and obviously others.

Few things I noticed:
-Varsity Lakes->Coomera does notably well. Could we see 15 min off-peak/weekend services on just this stretch in the short term?
-Ferny Grove does more than Northgate, only falls 8,000 short of Park Rd and 35,000 short of Bowen Hills!
-Outer Beenleigh Line stations slightly disappointing due to potential some have (understandable but nonetheless disappointing)
-Very strong patronage from Morningside (think about what the bus network reform can add to this too )
-Slightly surprised that Buranda wasn't higher up (hitting around the same number as Gaythorne, Lindum, Banyo).

Just a note for Rob, you forgot to add the Cleveland Line into the post above. Just another thing to add to the long list of suffering for them

[ozbob]

...

Just a note for Rob, you forgot to add the Cleveland Line into the post above. Just another thing to add to the long list of suffering for them

Fixed ... typo on image link

[tazzer9]

I think buranda station doesn't do that well due to the busway station.  The buses are far faster into the CBD and far more frequent. 

[Cazza]

I do know what you mean about Buranda. It's more of an interchange point than a commuter station. I guess I was just expecting a few more people to be transferring here than what it is.

[Whippa]

I do know what you mean about Buranda. It's more of an interchange point than a commuter station. I guess I was just expecting a few more people to be transferring here than what it is.

I'm guessing probably because most UQ students would transfer at Park Rd instead due to more options. The main transfers I envision happening at Buranda would be commuters for Mater, SE Busway south of Buranda and Eastern Busway towards Langlands etc. which I would imagine be not as plentiful as say UQ.

[aldonius]

Whippa's pretty much bang on regarding Buranda transfers IMHO.

If you're heading to/from UQ from/to the Cleveland line, Park Road is unambiguously better in terms of frequency (and probably faster overall just from the busway's extra station and twistier alignment).

SEB-south and EB-east to/from the Cleveland line are both radial-to-radial, which means counter-peak components. Probably mostly Griffith Uni students. Cleveland line to EB-east transfers are probably particularly weak; suburban to suburban trips which don't need to head anywhere near the city are very car-dominated.

Using the trip data is a little fraught, because it's measuring single legs of a journey. Nevertheless, using the February 2018 data (which would be a bit down for Uni trips; March would be better)

I get 3680 passengers in February 2018 boarding at Buranda busway (platform 1) and disembarking at Mater Hill (platform 1). For Buranda to PAH (platform 1), 1694 pax.

Comparing the last two with March 2017 data (because uni is out for at least half of Feb):

For Buranda to UQ Lakes (stop 1882: generic platform), 8644 pax Feb18 // 14933 pax March17

For Boggo Road P6 to UQ Lakes: 24838 pax Feb18 // 46707 pax March17

(Total March17 disembarkings at UQ Lakes: 225858.)

[Gazza]

A few thoughts:

-Landsborough is busier than all stations north of it.

-Doomben line is busier than Rosewood but gets less service!

[tazzer9]

A few thoughts:

-Landsborough is busier than all stations north of it.

-Doomben line is busier than Rosewood but gets less service!

Doomben doesn't really get that less service.   Most of the extra rosewood trains are not at great times, along with the doomben  line being in a built up area.   

[Arnz]

Landsborough alone carries more passengers than the entire Mooloolah to Gympie North stretch combined going by the go card data provided.

The entire Rosewood line is in the same situation as the stations north of Landsborough.  Basically almost all towns west of Ipswich or north of Landsborough (except Nambour) only have rail as the main mode of PT with limited bus services in the smaller towns.

Traveston is the only station out of both lines that is questionable whether it should remain open.

[OzGamer]

Springfield line patronage impressive.

Kippa Ring line not so impressive.

Interestingly, the Springfield line past Darra and the Redcliffe Peninsula line past Petrie are almost exactly the same in total patronage, but the latter is spread over twice as many stations. They probably should have built three or four further spaced stations.

[OzGamer]

Interesting that Roma Street and Fortitude Valley are apparently similar, but as it's go Card data it would miss transfers, which would be substantial at Roma Street and almost non-existent at Fortitude Valley.

[aldonius]

Interesting that Roma Street and Fortitude Valley are apparently similar, but as it's go Card data it would miss transfers, which would be substantial at Roma Street and almost non-existent at Fortitude Valley.

If it works the way I think it does, it would pick up rail/bus transfers, and bus/bus, but not rail/rail.

But the multi-stage rail/rail journeys should be there directly in the data.

[OzGamer]

Interesting that Roma Street and Fortitude Valley are apparently similar, but as it's go Card data it would miss transfers, which would be substantial at Roma Street and almost non-existent at Fortitude Valley.

If it works the way I think it does, it would pick up rail/bus transfers, and bus/bus, but not rail/rail.

But the multi-stage rail/rail journeys should be there directly in the data.

Yes, sorry - I meant rail/rail transfers. Rail/bus transfers would obviously be counted as they include touch off/on.

[aldonius]

Another thing to note - it appears all rail stations are coded by the same stop number, even though they have a different one for each platform. Usually it's P1, but Roma St seems to be P10 (of course at Roma St there is no rail P1).

[Whippa]

Another thing to note - it appears all rail stations are coded by the same stop number, even though they have a different one for each platform. Usually it's P1, but Roma St seems to be P10 (of course at Roma St there is no rail P1).

Yeah, likely because the ID's are a unique identifier and a convenient primary key for a database of sorts as we like to avoid words for numerous reasons mainly storage, and to avoid accidental uniqueness clashes (in this case esp. with bus stops). Using more than 1 platform ID just creates more problems than it solves, both in terms of interpreting the data, how you'd allocate to platform numbers, as complicating the database unnecessarily .

Interesting that Roma Street and Fortitude Valley are apparently similar, but as it's go Card data it would miss transfers, which would be substantial at Roma Street and almost non-existent at Fortitude Valley.

If it works the way I think it does, it would pick up rail/bus transfers, and bus/bus, but not rail/rail.

But the multi-stage rail/rail journeys should be there directly in the data.

Yes, sorry - I meant rail/rail transfers. Rail/bus transfers would obviously be counted as they include touch off/on.

Yeah correct. Think about it as counting the number of people entering and leaving the station. I can do an analysis of SE Lines/SW Lines transfer numbers (which would occur at Roma Street), should only take 20 mins or so.

[tazzer9]

Now if only we had patronage data for the regional trains.  But thats unlikely considering some stations would end up making traveston look like a hub of activity. 

[ozbob]

February 2018 data set is now available.

> https://data.qld.gov.au/dataset/go-card-transaction-data/resource/f84da1ed-e102-467c-ab54-bac24e35841f

Can someone please look at that one and do an analysis please?  Thanks in advance.

[techblitz]

2016-09   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600287   600018   5226
2018-02   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600287   600018   5234

600287 = toowong
600018 = central


so in that space of time its an increase of 8 passengers per month..

[techblitz]

Brisbane Transport   2016-09   444   Inbound   Weekday (12:00am-8:29:59am)   go card   1886   10780   153
Brisbane Transport   2018-02   444   Inbound   Weekday (12:00am-8:29:59am)   go card   1886   10780   184

1886 == high st toowong
10780 == kgbs

Increase fairly decent compared to rail...

[ozbob]

Thanks TB.  I have heard some rail patronage figures.  From memory 2017-18 was 51 million thereabouts.  I think they are forecasting around 52.6 million trips for 2018-19.

Rail patronage was higher in 2008!  (some patronage inflated due to paper ticket estimates but bit of a worry).

Rail patronage is essentially flat line at present.  Clearly rail fail and the consequent reduce services have had an impact.

I would expect this will be examined in estimates next week.

If the Government thinks they can carry on with the failed structures and attitude, they have it seriously wrong.

It is time for a major reform process for public transport.   

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

[techblitz]

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

[ozbob]

For interest:

2015-16 52.44 million passengers travelled on the Citytrain network, up 1.65 per cent from 2014-15 (QR AR)

2016-17 51.01 million passengers on Citytrain network  (TMR AR)

2017-18  ?

Transperth also has had a fall in recent times but the total rail is still 60.1 million 2016-17 (PTA WA AR).

[ozbob]

Transperth is about 181 Km (2016-17 60.1 million passenger trips http://www.pta.wa.gov.au/annualreport2017)

QR Citytrain is about 689 Km (2016-17 51.2 million passenger trips https://www.queenslandrail.com.au/about%20us/Documents/QueenslandRail_AnnualFinancialReport_2016-17_LR.pdf)

Hence the moves to cut down initial routes for training.

I am uncertain if that happened. Might be able to find out this coming week.

[  Sydney Trains is about 815 Km

Melbourne trains 372 Km

Adelaide trains 126 Km ]

Queensland Rail network has much latent capacity. 

Patronage shows that Transperth (frequency with good bus/rail) is a true gold performer.  Embarrassing ...

[techblitz]

Zillmere to central is a concerning decrease 

Queensland Rail   2016-09   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600446   600018   6887
Queensland Rail   2018-02   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600446   600018   6124

[techblitz]

quick comparison for landsborough and gympie north stations to central in the morning

Queensland Rail   2016-09   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600487   600018   2550
Queensland Rail   2018-02   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600487   600018   3434

Queensland Rail   2016-09   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600500   600018   58
Queensland Rail   2018-02   Rail   Rail   Weekday (12:00am-8:29:59am)   go card   600500   600018   49

600487 = landsborough
600500 = gympie north
600018 = central