GMPTE Bus data API for this weekend's Lovely Data Hack Day

[Ric Roberts]

We (me and Bill from Swirrl) are going to the Lovely Data MDDA Hack Day on Saturday (http://lovelydata01.eventbrite.com/) and as preparation for the event, we're converting the GMPTE bus timetable data to Linked Data. 

This means that the data will be available via an API for people to make apps with on the day. We're planning to make something ourselves using this data at the event, and we'll be there to help out others who want to use our API.

We're blogging about our progress as we work with the data. The first two instalments are available here:

http://blog.swirrl.com/articles/manchester-buses-linked-data-diary-day-1

http://blog.swirrl.com/articles/manchester-buses-linked-data-diary-day-2

... and we'll be adding more posts as we continue. Please let us know via comments on the blog articles if you have any feedback or questions regarding how we're going about it.

Looking forward to the Hack Day. Hopefully see you there!

[Julian Tait]

Wow that is smart. Hopefully we'll have more data available

Cheers

Julian

Julian Tait
Open Data Cities and Social Sensing

M: 44 (0)7802 851 394
Skype: Julianlstar

FutureEverything - Innovation Lab and award winning global festival of art, music and ideas.

FutureEverything 2011
11-14 May, Manchester UK

http://www.futureeverything.org

Twitter: @FuturEverything
Tag: #futr

[aph]

Good to see someone else playing with this data :-)

I have finally managed to get all of the GTFS data, the Naptan data
for all
of the bus stops in Greater Manchester and all of the fares
data loaded into a (growing) MySQL database - it has taken sometime
and
there are over 4.6M records now. I have written a (badly hacked!) Java
program to
do all the formatting and parsing of the data into suitable database
queries to
insert the data. I am sure it could be easily used to output the data
in a different
format if required.

I am now starting to construct interesting (?) queries to see what I
can do with all
of this lovely data :-)

Some sample queries (not all are working yet)

1/ Get time ordered list of all buses leaving a particular bus stop
2/ Find the location of all the buses at a particular time
3/ Produce a fares table
4/



I ultimately want to link this data to

I have also got some web pages which all for each data item to be
viewed, edited
and updated.





Unfortunately I can't come to the hack day on Saturday

Regards

Anthony

BTW I have produced a sample set of GTFS fare files for one route
(that correctly parsed) but couldn't see how they work

On Apr 5, 10:10 am, Ric Roberts <r...@swirrl.com> wrote:
> We (me and Bill from Swirrl) are going to the Lovely Data MDDA Hack Day on
> Saturday (http://lovelydata01.eventbrite.com/) and as preparation for the
> event, we're converting the GMPTE bus timetable data to Linked Data.
>
> This means that the data will be available via an API for people to make
> apps with on the day. We're planning to make something ourselves using this
> data at the event, and we'll be there to help out others who want to use our
> API.
>
> We're blogging about our progress as we work with the data. The first two

> instalments are available here:http://blog.swirrl.com/articles/manchester-buses-linked-data-diary-day-1http://blog.swirrl.com/articles/manchester-buses-linked-data-diary-day-2