Will Deakin @wnd@fosstodon.org Profile Banner
Will Deakin @wnd@fosstodon.org Profile
Will Deakin @[email protected]

@WillDeakin1

838
Followers
372
Following
134
Media
1,392
Statuses

I do governance for British railway IT plus European regulation I believe data makes rail passengers lives better. Ask me how! #Physicist #OpenData #DataScience

UK
Joined January 2020
Don't wanna be here? Send us removal request.
@WillDeakin1
Will Deakin @[email protected]
10 months
For those interested in such things, here are cuts of the @railandroad 2021/22 passenger travel data projected onto a shortest-path network using the centre-line track-model with log and linear colour gradient and line width Thanks to @undertheraedar @poggs #rail #DataVis
Tweet media one
Tweet media two
Tweet media three
Tweet media four
10
30
131
@WillDeakin1
Will Deakin @[email protected]
8 months
For those interested in such things based on the ORR Great Britain passenger origin-destination matrix, here is a short animation showing the change aggregated rail passenger flow in FY2019/20-2021/22 #DataVisualization #rail #PassengerTransport #ChangeInDemand
Tweet media one
Tweet media two
Tweet media three
Tweet media four
1
6
19
@WillDeakin1
Will Deakin @[email protected]
10 months
Update: the 2 657 images showing the ORR 2021/22 passenger travel data for each of the active mainline railway stations here . The main code still needs work and will be posted on GitHub here
0
2
17
@WillDeakin1
Will Deakin @[email protected]
10 months
For those interested in such things, here are 2 657 images showing the ORR 2021/22 passenger travel data projected onto a shortest-path network for each of the active mainline railway stations #DataVisualization #Rail #PassengerData #ORR #2021 1/2
2
0
15
@WillDeakin1
Will Deakin @[email protected]
10 months
@DanielPhilips1 @railandroad @undertheraedar @poggs FWIW I excluded the LDS to LDS (and other zero distance) point data from the original dataset. Here is the Leeds railway station data at a slightly different scale
Tweet media one
2
2
13
For those interested in such things, here is a theoretical rail-network based on applying a minimum spanning tree to a series of scaled hexagon population distributions geographies #RailNetwork #DataVisualisation #Census2021
Tweet media one
Tweet media two
Tweet media three
Tweet media four
2
0
12
@WillDeakin1
Will Deakin @[email protected]
8 months
For those interested in such things, a per station animation of the FY2018-2022 #ORR Origin Destination Matrix ( #ODM ) dataset for 2 579 rail stations in Britain Details here #DataScience #DataVisualization #rail #RailPassenger
Tweet media one
0
3
8
@WillDeakin1
Will Deakin @[email protected]
10 months
Update: the site should be back here Given the popularity I'm going to look at an alternative hosting solution but hopefully this will work for a bit. Please shout if it isn't* * As if you wouldn't
0
1
7
I would like to thank all the staff at @YorkTeachingNHS in York A&E and Day Admissions today for the kindness and care given to an anxious bloke with chest pains, and the reassurance it was skeletomuscular brought on by to stress at work rather than an acute coronary event
0
0
7
@undertheraedar The fix is in, with 202 country files, 17 regions with 19,752MB of zip'd GeoPackage files for the 47.8M km of repackaged Microsoft road data Code here (14 of 17 processed regions data are also hosted) Any further questions shout
1
2
7
For those interested in such things here is a draft set of UK rail planning (TIPLOC) and operations (STANOX) locations snapped to the centre-line track-model, or OpenStreetMap data where require Code and data is here #DataVisualisation #rail 1/2
Tweet media one
Tweet media two
Tweet media three
1
0
7
@WillDeakin1
Will Deakin @[email protected]
8 months
@SwissKrono_JH @Coneee @BloombergUK No. It's GB not UK by design The Irish dataset is not available otherwise I would have visualised that For the absence of doubt, I did ask and told this is not available either for NI or elsewhere
0
0
6
@WillDeakin1
Will Deakin @[email protected]
10 months
For those that are interested in such things, I've published some details about the implementation, data, licensing and a cut of the code. However it is "beta" at best and is also quite slow. So I'll run it overnight and see what the morning brings
1
0
6
@undertheraedar For those interested in such things I've posted the code to GitHub here The scripts are still running as the data is big and my computer is slow. I will update with addition countrries and regions as they become available Any questions shout
2
3
6
For those who are interested in such things here is an animated GIF of maximum population hexagons based on Census 2021 across 10 edge lengths (484km, 183km, 69km, 26km, 9.9km, 3.7km, 1.4km, 532m, 201m and 76m) clipped to the GB network based on
1
3
5
Having put it off for ages, I've just joined @youngrailpro despite arguably failing at least two of their criteria. How could this go wrong?
1
0
4
For those interested in such things, here is an update to the TIPLOC (Timing Point LOCation) visualisations at York and Doncaster Code, data and QGIS file here #QGIS #DataVisualization #rail
Tweet media one
Tweet media two
1
0
5
@undertheraedar Try this which has the Carribbean Islands and European data as GeoPKG files split by country using the three-alpha code Basic data here is and I'll tidy up and post the @python code over the weekend
0
1
5
@WillDeakin1
Will Deakin @[email protected]
10 months
@undertheraedar @railandroad @poggs Kudos to Alasdair. I merely took what Alasdair had done here and blinged it with some centre-line track-model shenanigans (Corrected for spelling)
1
0
5
As requested @LUCYLucyprior a picture of the almost-complete #1Daughter birthday cake
Tweet media one
2
0
5
@undertheraedar This might be interesting here () is a script that downloads Open Street Map (OSM) tagged "railway" data within Great Britain using the OverPass API (), the OSMNX () 1/2
1
0
4
@undertheraedar I'm downloading the Europe dataset now and'll convert to GPKG using @geopandas . I'll post the code once it's working
2
0
5
@GarethDennis @ChristianSpence Apropos nothing, this is what a 24 track terminus with a six track SBahn underneath #HbF
Tweet media one
2
0
5
@GarethDennis SMH. I was surprised and taken aback by the vitriol. Small children are a tough gig and I have been there and done exactly the same as this myself when my two were small* * as I used to live in Scarborough in almost exactly the same circumstances It takes a village...
0
0
4
@WillDeakin1
Will Deakin @[email protected]
9 months
For those interested in such things here is a beta #python module "parenx" ("pare" + "nx") for linear (road and rail) network simplification, using buffering and image skeletonization or Voronoi polygons to identify a centre-line, and available via #pip
0
1
4
Tweet media one
1
0
4
The slides for my talk on timetabling and rail-freight are now available This includes an online version and a PDF containing links and references to the material used The video edit will be published shortly on YouTube @ShefDigiFest
Tweet media one
0
2
4
@Pixelfish @crstry Hence the Adora Belle Dearheart/Moist von Lipwig quote. The passage finishes: "That had been a good day, Moist thought. At least, up until now it had been a good day...You weren’t supposed ever to meet the people afterwards. Gods damn Mr Pump and his actuarial concept of murder!"
0
1
4
@undertheraedar The back-garden at 8 this morning
Tweet media one
0
0
4
If you are interested in UK rail timetabling, want to find about modal-shift or how rail-freight could help combat climate change, and have an hour free this may help Slides are available here @ShefDigiFest #railway #RailFreight
Tweet media one
0
2
4
@25kV I don't know if it helps but there are those who are inspired by your work and are following in your footsteps. Although probably rather too literally in this case
Tweet media one
1
0
3
For those interested in such things, here is a map of "European" rail electrification based on @openstreetmap tagged data Developed in @ThePSF using @gboeing #OSMnx to wrangle the data and @qgis to visualise the map #ElectrifyAllThings #DataVisualization #rail #Europe
Tweet media one
0
0
3
@WillDeakin1
Will Deakin @[email protected]
10 months
Apologies but as the bandwidth limit hosting has been exceeded Until I can sort out an alternative hosting that's all for now
1
0
4
@25kV @GarethDennis @MrMappy As a counterpoint to this, I wish I had a picture to hand of the OLE sidings visible on the S-Bahn between Wien-Mitte and the airport, that is a truly gibbering delight of freight electrification (PS: I'll see if one of my ÖBB colleague has this...)
1
0
4
@KevinHuckfield @joncstone @burridge_d The LNER trial details are here
0
0
4
@MarcGra95162166 @thomasforth While heavy rail is different, other than inconveniencing drivers why would you need to demolish any housing or infrastructure to accommodate a light-rail infrastructure? Also what is a tram station? If you are still worried about impact you can always tunnel. See CrossRail
2
0
4
@RAIL @MelHorrocks19 Virginia Train All the Young Dwell Times Devil Gauge Drive John I'm Only Validating This RT3793 Form
0
1
4
Why this may be of interest to the #railway #data community is that the two examples chosen are the #OpenData CIF (Common Interface File) working timetable and TPS (Train Planning System) planning model datasets
1
0
4
For those interest in such things, here () is a script that downloads Open Street Map (OSM) tagged "railway" data within Great Britain using the OverPass API (), the OSMNX () python library and @geopandas 1/2
1
1
4
The visualised data is in the GeoPKG (tiploc-location.gpkg) sx layer with ELR and approximate track offset based using centre-line data combined with OpenStreetMap GeoPKG ox layer is snapped to the OSM network #WhereIsMyTrain
0
0
4
@martinfleis @undertheraedar Update. Thank you for the suggestion as the 0.5.0 'pyogrio' fix is in and it is significantly faster than the base Fionas engine. The Caribbean Islands gives a 258% speed increase
0
0
4
@WillDeakin1
Will Deakin @[email protected]
10 months
@GarethDennis Is the data kicking around? If you had it hand I would now be able to tell you how many metres of usable platform this corresponds to...
0
0
2
@WillDeakin1
Will Deakin @[email protected]
10 months
@quantinghome @undertheraedar Yup. It's a naïve shortest-path routing using the centre-line track-model. I'm writing up the code now and'll get it on GitHub. Any code improvements would be welcome
1
0
3
@PeterMy53679910 @RailwayHeritage @PermWayInstit @GarethDennis @RAIL [*] Magyar Államvasutak, Hungarian State Railway [**] Me: "What do you mean by saying that a track can have more that line gauge?" Lazlo: "Yes, see this" Me: "..." (Sadly I don't have the picture) I also understand it happens in Finland at the Russian border... 2/2
0
0
3
@therailalliance @bcrre I know about operations data (capacity planning, path allocation and traffic management) data #WhereIsMyTrain #WhereShouldMyTrainBe #WhatIsMyTrain and #WhereWasMyTrain #raildigital2020
0
0
3
@GarethDennis The Offa Line
0
0
3
@WillDeakin1
Will Deakin @[email protected]
10 months
@saduncan1998 @undertheraedar There is but involves a dataset for actual route taken rather than shortest path between two location on the network. Which I don't think exists Also as some folk will go direct route you need to also say "85% went this way and 15% that." Which is hard Happy to be proven wrong
0
0
3
@WillDeakin1
Will Deakin @[email protected]
8 months
@undertheraedar It's almost a Sesame Street "One of These Things (Is Not Like the Others)" situation
0
0
3
@WillDeakin1
Will Deakin @[email protected]
11 months
@NoelDolphin That OLE is stunning
1
0
3
I now deliver IT projects that will give HS2 a timetable to work with, LNER an easier way to divert a HST via Gainsborough when the powers out at Doncaster, spot a wobbly wagon that could derail at Fleet, or passengers at Brighton the train is 5 minutes early #RailHumanLibrary
0
1
2
@undertheraedar I wonder where the 50% line for England, Wales and Scotland would be. Unfortunately I have the 2021 Census data that could answer that question...
2
0
3
I just ran my first 5km #ParkRun at Harrogate park run in memory of my Sensei and friend Lance Saxby "Those that the gods love die young" He was a good man
0
0
2
@kooky_uk @crstry @b0rk We had to reboot the whole of our corporate Windows estate and had complaints for months from corporate partners. Power off/power on was the fix. The power of the caching... 2/2
0
0
3
@version3point1 Thomas's Bakers* It's a regional thing
2
0
2
@WillDeakin1
Will Deakin @[email protected]
10 months
For those interested in such things, I've scraped the 2024 Timetable Planning Rules PDF from to text and (where possible) TSV, and gathered the platform-length data into a spreadsheet #DataAnalytics #PlatformLength #TimeTable
0
0
2
@SimonZev Unlike Gare St Lazare, Aachen, Wien Westbahnhof, Bordeaux St Jean et al, the GB national system of record CORPUS does not have a timing-point for Barcelona Where CORPUS holds all records since its inception in the '80s/'90s
1
0
2
@25kV I'm a wow at parties
1
0
3
@mikeqfu it was a really interesting talk today on the use of data science to answer problems about the railway. Thanks to @robinlovelace for the invite to @ITSLeeds
0
1
3
@GarethDennis Go Italiano "Regio TransAppenine Espresso"
1
0
3
@PhilSV4 @RailDeliveryGrp If it helps, yes, a mass programme of OLE is the right solution
0
0
2
@philatrail I thought single-tender government contracts must pass a number of tests before they are let, which in my experience is quite a high bar It would be interesting to see the assessment and guidance that led to this decision, especially given recent NAO criticism of HMG procurement
1
1
3
@WillDeakin1
Will Deakin @[email protected]
10 months
@GarethDennis Who needs TOPS if it's a painted on certainty?
0
0
2
@WillDeakin1
Will Deakin @[email protected]
10 months
@rlonguk @undertheraedar Ah! You got me. The OpenRailData centre-line track-model doesn't have a path for the IoW to Portsmouth Harbour. While the ORR has ticket information I couldn't route the journey. As I didn't want to make stuff up I excluded it from the results Happy to take suggestions
1
0
3
@undertheraedar It's Danelaw all over again
0
0
3
I have my next blog blog post about #railway things that interest me, here is my take on what a #digitalrail #TMS is about Comments or questions more than welcome
0
1
3
@Garret_Beggan @RedFoxglove @_lucymellor I think this has already been addressed elsewhere. But to reiterate, as a shopping centre it's now quite good, as a functioning railway station less so
1
0
3
@WillDeakin1
Will Deakin @[email protected]
10 months
@AdamLBrown3 @railandroad @undertheraedar @poggs Here a cut of the ORR 2021/22 data for the individual stations Cambridge (CBG) and King's Cross (KGX). With an exaggerated linear scale using `matplotlib` hence the slightly messy lines The other graphs were combined and rendered in `QGIS`
Tweet media one
Tweet media two
1
0
3
@WillDeakin1
Will Deakin @[email protected]
8 months
For those interested in such things, here is the per station animation of the FY2018-2022 #ORR Origin Destination Matrix dataset for 2 579 rail stations in Britain Details here #DataScience #DataVisualization #GB #RailPassenger
1
1
3
Re-post alert: For those interested in such things let’s think about how to make an East Coast Main Line digital with European Train Control System (ETCS) * Mostly because @poggs ** told me "This a really cool video" ** which made me happy #LeedDigi22
0
1
3
@JenWilliamsMEN 50% true at least, if you believe the BBC
1
0
2
@WillDeakin1
Will Deakin @[email protected]
11 months
@NoelDolphin This epiphany induced an unrelated divergence of meaning
0
0
3
@Pixelfish @crstry "[Miss Dearheart] ‘I used to work in a bank in Sto Lat. The Cabbage Growers’ Co-operative’ ‘Oh, the one on the town square? With the carved cabbage over the door?’ said Moist, before he could stop himself. ‘You know it?’ she said. ‘Well, yes. I went past it once...'"
1
1
3
For those interested in such things I give you European Rail Traffic Management System (ERTMS), ETCS, lights-on-sticks, in-cab signalling, ATO, Driver Advisory Systems all with an East Coast Main Line upgrade spin #LeedsDigi22
0
1
3
@GarethDennis @anisotropi4 Good morning. Just to maladroitly slide into the subtweets here is the equivalent visualization of DfT car numbers #DataVisualization
Tweet media one
0
0
3
@kooky_uk @crstry @b0rk 20 year's ago for a rebrand for a large UK website we needed a DNS change. We reduce the TTL, tested and went live to discover an interesting Windows server feature where MS "interpreted" the DNS RFC in a uniquely way where the cache would only refresh on reboot 1/2
1
0
3
For those interested in such things, here is a visualisation of @openstreetmap rail electrification data, and an overlay on centre-line track-model , with the #FizzyKnitting colour scheme Scripts and data are here #rail #DataViz
Tweet media one
Tweet media two
0
0
3
Putting the passenger first #raildigital2020 Is train maintenance a major cause of train failure? Or is it issues with train consist and fleet dispatch at depot? So, do passengers care about how much it costs to maintain stock? @therailalliance @BCCRE @digi_rail
0
0
2
@WillDeakin1
Will Deakin @[email protected]
8 months
@thomasforth There is not "one" operating system and it varies between subsystem, manufacturer and age
0
0
2
@GarethDennis There would appear many people in coaches on a hard-shoulder on a motorway in Kent who may be currently reappraising their transportation choices. Albeit in an inexplicable way.
0
0
1
@GarethDennis @YorkRail Thanks for hosting and passing over the detail. Whereas I, having finally dialed in, made like a seagull...;)
0
0
2
@GarethDennis As someone who spent a chunk of my life on the Heart-of-Wales line which is arguably the most rural in Britain[*], I never saw a Pacer or on the rural Scarborough-Beverley Rather it was semi-urban York-Harrogate-Leeds, or West-Yorkshire bus-on-rails [*] top-five at least
0
0
1
@LUCYLucyprior Good question and one I will answer after I have had my tea. Having just back home from Manchester, talking rail data for service recovery for the SE and data needed to modelthe rail network in the North to achieve zero-carbon by 2050
2
0
2
A big thanks to @ovus00 for hosting my talk on rail #DataVisualization to the Information Management MSc students at @sheffielduni #InformationSchool Showing the importance of communication and narrative, and how to have fun making things that look good #rail #STEMeducation
0
0
2
I'm about to test out the Peterborough recontrol on the Hull Trains to KGX. No overspeed please
0
0
2
@WillDeakin1
Will Deakin @[email protected]
10 months
@ajcdeane @undertheraedar I need to work on my GitHub UX markdown skill
0
0
2
Unbidden advice for successful project delivery: Start with a plan Stick to the plan until you have executed the plan Or the plan has failed If the plan fails, stop and come up with a new plan But stop Repeat from the top 1/2
1
0
1
Heading to Edgbaston ahead of the #DestinationDigitalisation event by @bcrre and Rail Alliance tomorrow
0
0
2
@GarethDennis Despite being ETCS level 2, Caersws says "hold my coat"
Tweet media one
0
1
2
My fringe #SheffDigiFest talk on the 9 May 2022 is intended to provide a general albeit nerd adjacent audience with an overview of the current rail-freight timetable and processes Details here Free tickets are on Eventbrite and will be virtual on Teams
2
2
2
It's quite Leeds focussed but kudos @mgleadow if you can spot the three Sheffield easter-eggs
0
0
2
@GarethDennis @PWInstitution You have had some truly great speakers at the PWI York meetings...
0
0
2
@cynicalkind @GarethDennis @ChristianSpence Surprisingly I also think Frankfurt is right. In part because I took the photo when I was there yesterday...
1
0
2
@WillDeakin1
Will Deakin @[email protected]
9 months
@AdamLBrown3 @lorenzo_hermoso @undertheraedar I have never made any statements about accuracy, that is your projection. Rather this shows passenger flow where some places it will be better than others. The caveats are in plain sight. Please build a better model with the data at hand, as I would be very happy to see that.
0
0
0
@SimonZev @GarethDennis @Captain_Deltic @RMTunion @MarkMiddleton37 Thanks. As I was about to log on and check the latest numbers Revenue figures have continued to increase since at least Christmas. Despite the TPE meltdown, Avanti and Northern issues and ongoing industrial disputes. Passenger number more so
0
0
2
@tomhiskey @petewht @BethanVincent I would echo @tomhiskey sentiment and add that York sounds cool
0
0
2