Raw arrival time data for number 13 buses at bus stop 5520 (or later stop)
Michael Fincham made this Official Information request to Wellington Regional Council
This request has an unknown status. We're waiting for Michael Fincham to read recent responses and update the status.
From: Michael Fincham
Hi GW,
I am seeking a copy of the last 12 months of raw data showing the dates and times at which buses travelling on the number 13 route from Brandon Street to Mairangi arrived at (or departed from) their first scheduled stop, which is stop 5520. If this information is unavailable due to limitations of GW's bus tracking system then I would like the data pertaining to the arrival of these buses at the second stop in their journey, which is stop 5012.
As much as possible the data should not be summarised, processed or modified in any way. I am a computer scientist and for my purposes would like access to the raw data.
As there have been approximately 250 working days in the last 12 months, and there are five scheduled number 13 services per day, the data should constitute a table of approximately 1250 rows. If 12 months of this data isn't held by Metlink then I would like the maximum number of data points of this type which are held for this service, and an explanation of any specific retention times that are applied to this data collection.
Any reasonable text-oriented format for the data is fine - an SQL dump or CSV file would be ideal. Any reasonable time format is fine, e.g. UNIX timestamps, ISO8601 etc
Even just a list of the "start timestamps" when buses clocked in to the number 13 route would be fine, for instance data that looked like this:
...
Wed Feb 5 16:18:24 NZDT 2020
Wed Feb 5 16:40:55 NZDT 2020
Wed Feb 5 17:03:31 NZDT 2020
...
Would be great. There should be approximately five data points for every date included in the dataset, representing each of the five departures on that day. Further metadata such as a unique per-trip identifier, or what the 'lateness value' of the bus was at that particular point would be appreciated but is not necessary - I should be able to match up which departures correspond to which scheduled trip myself if necessary.
If this specific data is already published or made available through a public API then information on where to obtain it myself would be appreciated.
If it would be easier to discuss the particulars of e.g. the format of the data or how to deliver it then feel free to call me, you should have my phone number from previous conversations.
Thanks,
-Michael
From: Sam Horsefield
Wellington Regional Council
Dear Michael,
Acknowledgement of Request for Information under the Local Government
Official Information and Meetings Act 1987
Thank you for your email dated 5 February 2020, requesting information
regarding raw arrival time data for number 13 buses at bus stop 5520 (or
later stop).
Your request is being followed-up and a reply will be sent to you within
20 working days of the request being received.
Yours sincerely,
Sam Horsefield
for
Luke Troy
General
Manager
Strategy
Greater Wellington Regional Council
ATTENTION: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action
in reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions
expressed are solely those of the author, and do not represent those of
the organisation.
From: Daniela Theodorou
Wellington Regional Council
Dear Mr Fincham,
I hope my email finds you well.
Please see attached the response to OIA 2020-015.
Thank you.
Yours sincerely
Daniela Theodorou |
Kaiāwhina Matua ki te Kaiwhakahaere Matua Waka
Executive Assistant to General Manager Public Transport
GREATER WELLINGTON REGIONAL COUNCIL
Te Pane Matua Taiao
Level 2, 15 Walter Street,Te Aro, Wellington 6011
PO Box 11646, Manners St, Wellington 6142
T: 04 830 4309 | M: +64 277 599 670
[1]www.gw.govt.nz | [2]www.metlink.org.nz
ATTENTION: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action
in reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions
expressed are solely those of the author, and do not represent those of
the organisation.
References
Visible links
1. http://www.gw.govt.nz/
2. http://www.metlink.org.nz/
Things to do with this request
- Add an annotation (to help the requester or others)
- Download a zip file of all correspondence