[iRail] UK railway data

[Quentin Kaiser]

Hey !

I think I'll write some blog post about it because there is a lot of things
to describe and explain but here is some updates :

- train stations with TIPLOC (timing point location, specific id in their
system) and geolocation is up here :
http://data.quentinkaiser.be/NetworkRail/Stations.xml.  I have to update
geolocation because my coordinates transformation script wasn't doing so
well (I had to transform from northing/easting to latitude/longitude).
- I'm working on semi-static data (schedules). It's really BIG data (1.9Gb
of json) that we have to parse. Updates are provided daily via an archive
on amazon S3 containing around 5Mb of json. So if you want to provide
up-to-date informations via data.irail.be I can write a wget/parse/store
daily cronjob to get it done.
- As TheDatatank is mainly using MySQL I wrote a script to read data from
the 1.9Gb and insert it into tables, it's currently running and I don't
know exactly when it's going to finish :D
- they don't provide some kind of database scheme so I spent some time to
see what was going on into the raw json with mongo.

As soon as I get a working local database with schedules I'll push
everything in here : https://github.com/QKaiser/NetworkRailResource

Quentin




2012/8/19 Yeri Tiete <yeri at flatturtle.com>

> Hi Quentin,
>
> What's the status on this? Had any time to get it to work?
>
>
> --
> Kind regards,
> Yeri Tiete
> FlatTurtle <http://flatturtle.com/>
>
>  Avenue du port, 86c - 18, 1000 Brussels
>
> m: +32 (0) 474 61 0139
> t:   +32 (0) 2 669 1001
> f:   +32 (0) 2 669 1002
>
>
> On 09 Aug 2012, at 15:52, Yeri Tiete wrote:
>
> Cool. Many thanks Quentin :)
>
> --
> Kind regards,
> Yeri Tiete
> FlatTurtle.com
> Sent from my Nexus 7
>
> Quentin Kaiser <kaiserquentin at gmail.com> wrote:
>
> Hi all,
>
> I think I can do it ! Besides, it's a really interesting API
> (message-oriented with brokers and subscribers), take a look at this
> document [1] even if you don't want to develop something out of it. There
> is plenty of examples for different languages.
> I'll take a closer look on this tonight. I keep you posted ;-)
>
> Cheers !
>
> Quentin
>
> [1] :
> http://www.networkrail.co.uk/WorkArea/DownloadAsset.aspx?id=30064782140
>
> 2012/8/9 Yeri Tiete <yeri at flatturtle.com>
>
>> Dear All,
>>
>> We're looking for volunteers to implement Network Rail<https://datafeeds.networkrail.co.uk/ntrod/login;jsessionid=7236B850D06F4A23B99214DF3A261B5F> data
>> into our DataTank <http://data.irail.be/> interface.
>>
>> It requires a signup, but after that it's free to use.
>>
>> Who's up for it? *puppy eyes*
>>
>> --
>> Kind regards,
>> Yeri Tiete
>> FlatTurtle <http://flatturtle.com/>
>>
>>  Avenue du port, 86c - 18, 1000 Brussels
>>
>> m: +32 (0) 474 61 0139
>> t:   +32 (0) 2 669 1001
>> f:   +32 (0) 2 669 1002
>>
>>
>>
>> _______________________________________________
>> iRail mailing list
>> iRail at list.irail.be
>> http://lists.rootspirit.com/mailman/listinfo/irail
>>
>>
>
>
> --
> Quentin Kaiser
>
>
> _______________________________________________
> iRail mailing list
> iRail at list.irail.be
> http://lists.rootspirit.com/mailman/listinfo/irail
>
>
>
> _______________________________________________
> iRail mailing list
> iRail at list.irail.be
> http://lists.rootspirit.com/mailman/listinfo/irail
>
>


-- 
Quentin Kaiser
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/irail/attachments/20120821/36fdd43a/attachment-0003.html>