How to Make a Map of Your Visited Stations!

Рет қаралды 11,898

2 ай бұрын

DOWNLOAD THE SPREADSHEET: www.everylaststation.co.uk/do...
And here's my own map if you're interested!: www.google.com/maps/d/viewer?...
Here is a tutorial on how to make your own map indicating your visited stations!
Follow on Twitter: @NickBadley
Subscribe!: / @nickbadley
Check out my merch here!: natts.art/collections/nick-ba...
=============================================================
Thank you to my Patrons and Channel Members!
801Rail, Albert Haigh, Alexander Kinney, Alexie, Andrew Thomas, A Nerd Travels, Angel Wedge, Anthony Clark, Antigod, AutoUnder, Brian Bukowski, BritainByRail, Bryan R, Buses Amand, Centros, Chris S, Christine L, CM Trains, Coastway Will, Daniel Geographic, Daniel Shurz, Dave Joey, David Bainbridge, David Collison, David Curtis, David Goodrum, David Hintze, Dean Sharpe, Emily Jules, Evan Smith, Ezra, FoxyButNew, Golf By Rail, Gordon Johnston, Gordon Webb, Grahams Diecast and Railways, Hugh Hillier, Ian B, Ian Mann, Ian Poole's Transport Travels, ItsMimic, JackAllStations, JacksRailwaySecrets, Jacob Edwin House, Jake Short, James BPG, Jan Hnilička, JenOnTheMove, Joe On The Trains, Joe Verity, John Walsh, Kai Kiefer, KD, Kodzo, Lil Cataracts, Louis On Air, Manic, Marcie Z, Marcus Love, Mark H, Mark Morton, Matthew Grint, Metrowake11, Mike Jones, MrMiningPlays, MrOscar323, Natt, Neil Spencer, Neil Ward, NexoPro, Paul Eade, Paul Harper, Paul Newton, Pete Denton, Peter Kates, Polkajuice, Quantum Pulsar, Rachel Quarrell, Rb1414, Reece's Trains, Rheilffordd, RhinosF1, Robert Allpress, RobertfromCologne, Rob K Carter Rudwick, Rolo the Rottweiler, SarahWithTheTrains, SimOnTrains, South Coast Dave, Steggs, Stuart S, SWTransport, TandGtv Vlogs, Temslink, Terry Nicol, TheSpaceGuy, Thomas Roell, Thornaby 37, Tom Lake, Tom Marshall, TommyG, Topher, TransportFan2003, Tyla, VexSG, West Midlands Transport Hub, Wez, William Mankelow, Winfel
You can become a Patron here! / nickbadley
=============================================================

Пікірлер: 66

@everylaststation 2 ай бұрын

Updated spreadsheet will be uploaded later this week with Leven & Cameron Bridge on it. Along with a few corrections

@actuallyneon 2 ай бұрын

Will it have station codes aswell? :p

@Trainspotting_Mayhem 2 ай бұрын

Might just be me, but just in case, I think Hayes and Harlington is in the wrong place and is where Hayes (Kent) is meant to be

@everylaststation 2 ай бұрын

@@Trainspotting_Mayhem Corrected 👍

@everylaststation 2 ай бұрын

@@actuallyneon I've not done it as I don't feel the need for it.

@rooneydonal21 2 ай бұрын

Can you update Northern Ireland too. like Yorkgate is now York Street, Londonderry waterside is now Derry~Londonderry, Belfast Central is now Lanyon place and Great Victoria Street is now closed

@tommarshall1660 2 ай бұрын

Well Nick that was very interesting, but as I am 77 years old I am now completely confused but in complete awe of your skill on the PC. Keep up the good work, holidays will be here soon.....

@sambrookes4497 2 ай бұрын

You can import the second spreadsheet into the same layer so you don’t have to do everything twice

@Sim0nTrains 2 ай бұрын

Very interesting video Nick, Thanks for this

@nigelkthomas9501 2 ай бұрын

Best video yet! Thank you so much, Nick! This is just what I’ve been looking for.

@SimplyBurgerYT 2 ай бұрын

Thank you so much Nick! This is super helpful

@ArthurTK26 2 ай бұрын

Great video, never knew about most of these things, will try it all out soon!

@trainspotter586 2 ай бұрын

Keep up the great work nick badley

@mik99D 2 ай бұрын

Good spreadsheet use. Well done Nick. I may use some items for something else.

@matthillmedia 2 ай бұрын

Thank you Nick, very useful. I shall definitely be doing this.

@ElijahsTransport 2 ай бұрын

Great video! Now that you've done this can you please show us how you make your animations for when you move in your videos?

@Nooticus 2 ай бұрын

Very very clear tutorial!

@grassytramtracks Ай бұрын

I've been to a fair number of stations just by travelling to different places for whatever reason. I've been to (got on or off or changed): Avoncliff, Bath Spa, Bond Street, Bradford-on-Avon, Branksome, Brighton, Bristol Parkway, Bristol Temple Meads, Brockenhurst, Cambridge, Cardiff Central, Carmarthen, Chetnole, Clapham Junction, Clifton Down, Crewe, Custom House, Didcot Parkway, East Dulwich, Edinburgh, Filton Abbey Wood, Fratton, Freshford, Frome, Guildford, Haslemere, Heathrow Terminal 5, Imperial Wharf, Llandeilo, London Bridge, London Liverpool Street, London Paddington, London St Pancras, London Victoria, London Waterloo, Nailsea & Backwell, Newport (South Wales), Oxford, Peckham Rye, Plymouth, Port Talbot Parkway, Portsmouth Harbour, Reading, Redruth, Romsey, Ryde Esplanade, Shanklin, Southampton Airport Parkway, Southampton Central, Stansted Airport, Sugarloaf, Swindon, Taunton, Tottenham Court Road, Warminster, Westbury, Weston-Super-Mare and Willesden Junction.

@mrowl-the-dsm1304 Ай бұрын

Wow, Very Useful Nick, your additional vocation in life, Teaching Excel and Google My Maps, Thanks very much :-)

@TimEaston Ай бұрын

Thank you for this explaner video I have just created my own map.

@stephenhersee 2 ай бұрын

This would be even better if you made the spreadsheets for each line / train operator, and then used those to make each layer in my maps. It's probably more management, but I imagine it looks a a lot better to view than just 1-2000 and 2000+ on a Google map

@kareemsstuff5007 2 ай бұрын

On everylaststations's excel file, filter the TOC you want and only import that data.

@Olivers-trains 2 ай бұрын

I've done something similar with a similar spead sheet and all the stations incl heriatage on maps

@AndyTrainRock 2 ай бұрын

thanks for this tutorial nick! can you do how to create the graphics (the one with the route like liverpool - chester) please?

@paulharvey9149 2 ай бұрын

Fascinating. I don't promise to do it though - it'd take me weeks, as I'd have to keep checking back, I suspect!

@Djengland2010 2 ай бұрын

Your the best KZfaqr ever never forget that

@NameReveal-yy7qb 2 ай бұрын

thanks nice video could you please do exploring the scotrail express line

@JBFlytography 2 ай бұрын

Nick are planning on visiting Leven & Cameron Bridge when it opens?

@RichardOldroyd 2 ай бұрын

OMG I need this in my life being a map nerd.

@Steggs 2 ай бұрын

I think this is a sign I need to transfer the list of stations I've been to from my notepad app on my phone to this 😅

@lapiswake6583 2 ай бұрын

Just did this for my totals. And I discovered that I hadn't marked off that I'd dome Stratford, for some reason. Teesside Airport isn't listed. Which, on one hand it's had its service suspended since 2022, but on the other, it isn't officially closed. Doing this makes me realise how much I still have to do in the South East, which I should be able to do on day trips...

@everylaststation 2 ай бұрын

Teesside Airport station is closed. Officially or not, you can't board a train there, or even gain access to the platforms. Only included stations on the spreadsheet that you can actually visit. (Except Altnabrek which will be removed from the spreadsheet in due course.)

@JayROwen 2 ай бұрын

Really interesting. It would be good to be able to add the colour the rail lines onto it too

@tramographyMCR 2 ай бұрын

You can, but it might have to be done manually

@Liminal_space1 2 ай бұрын

Nice video! Can you do All the Stations on the Tyne and Wear Metro please!

@everylaststation 2 ай бұрын

I have a link on the downloads page for the Tyne & Wear metro. Click on "Metro Stop Visiting Logs"

@mario_master1 Ай бұрын

question douse this include heritige lines. if not could you add them???

@Thornaby37 2 ай бұрын

I still do this the old fashioned way, with the rail atlas by S K Baker

@tomedy_official 2 ай бұрын

Good with the west Highland line, it will take you months

@jackthetrainspotter9727 2 ай бұрын

The closest I’ve got is a hand drawn map of the rail lines I’ve been on. However, I’ve been on every passenger rail line in Britain bar 4 😃

@QuantumPulsar 2 ай бұрын

This is a great idea! But I don't have many visited stations so my map is mostly red 😭

@mrpasta6961 Ай бұрын

can you make one for belgium pls

@JoshHodginsTrains 2 ай бұрын

Cheers

@LongHaulPilot 2 ай бұрын

can someone please do this for airports

@AlexFrew-kv2vg 2 ай бұрын

Would you ever consider visiting stations in Northern Ireland as well as Ireland. Asking for a friend. Never forget your awesome.

@Lewisjma21 2 ай бұрын

Do Chesterfield to Nottingham to Derby to chesterfield (all EMR)

@muru6027 2 ай бұрын

Do you count stations you have actually gotten off at or just been through without getting off?

@InkItOut 2 ай бұрын

The definition of "visiting a station" we use is to board or alight a train at the station, and this can't be getting of the train and back on the same one unless it's a different headcode.

@walkingtheboogie Ай бұрын

I am surprised 2,000 rows of data are seen as a lot by Google Maps. It's nothing compared to the amount of data Google holds. I'm also surprised that one can only upload 2,000 rows at a time. If it was 200,000 rows of data, that would be something else. Very interesting video, and I say this as someone who is a professional cartographer and now works at maintaining address and street gazetteers for a couple of local authorities.

@paultidd9332 2 ай бұрын

Can you do this in an Apple world? I never really trust Google with my data!

@SeanMidlandstransporthub 2 ай бұрын

Yet you literally are commenting this on a Google account with your name and face 🤣🤣

@raantaaro Ай бұрын

bro said sporlding (sorry i giggled)

@LynseyMcKee-dd7wg 2 ай бұрын

Hav u benn to hairmyres station😊

@trainlover16 2 ай бұрын

Does this include stations your train has stopped at or only stations you've alighted at?

@NickBadley 2 ай бұрын

Depends on what definition of "Visit" you use! I personally do board and/or alight at a station. You could even make 2 maps, one for stopped and one for boarded/alighted!

@trainlover16 2 ай бұрын

@@NickBadley I’m just gonna do all the ones I’ve stopped at.

@boozytortoise 2 ай бұрын

I've always wondered this too. Geoff visited every station..but went by definition of train stopped at due to time restraints. But I know a lot don't count that as having visited them

@andyt2510 2 ай бұрын

Seems a lot easier than what I did - all stations as normal, then up to 4 people can have their own tally, of either passed through, boarded or alighted at the station, or only passed by on a Rail replacement bus. That isn't hard, what took the time was the second sheet which has the map of the UK! All cells sized and coloured in manually, with stations linked by red lines and includes closed stations, closed lines in grey, proposed and under construction stations and lines in purple and heritage lines and stations in green, though open stations are on the map by their 3 letter code, though a note will tell you what they are. London is very crowded though! Other tabs have the countries Metro systems. I'm glad I'm not the only one who has a spreadsheet to keep track though!