Every bus stop, train station, ferry port and taxi rank in Britain mapped

-Chris-

http://www.guardian.co.uk/news/datablog/2010/sep/27/uk-transport-national-public-data-repository

UK transport mapped: Every bus stop, train station, ferry port and taxi rank in Britain. Welcome to the ultimate transport data

The National Public Transport Data Repository is the UK's largest transport dataset. It tells you where every bus stop, station and airport is - and how they're used. Find out which place has the fewest bus stops and help us go through the data

Heard of the National Public Transport Data Repository before? Unless you're the ultimate transport enthusiast, there's no reason why you should; hidden behind pre-registration and restrictions on commercial use it was not exactly easy to find.

But all that has changed, thanks to data.gov.uk. The Liberal-Conservative coalition always pledged to release Whitehall's largest databases to the world; this is one of the biggest.

Why's it such a big deal? The official description gives you some idea of how important it is:

A snapshot of every public transport journey in Great Britain for a selected week in October each year. The dataset is compiled with information from many sources, including local public transport information from each of the traveline regions, also coach services from the national coach services database and rail information from the Association of Train Operating Companies

So, every train, coach and bus journey is catalogued and recorded in a huge set of spreadsheets, divided up by every region in the country (excluding Northern Ireland, that is). The official blurb basically says you can't do anything with this data without the use of seriously heavy-duty databases and big old computers.

That's a bit "here's all the data but sod you if you want to actually do anything with it". When, in fact, there's quite a lot you can do with it. On an ordinary computer. Using excel.

We've copped out a bit and simply extracted the full list of every transport stop in the UK (stops.csv in the downloads). That's still some 406,458 records. Using Google Fusion tables, which is better at handling huge datasets than the Google spreadsheets we normally use, we put together the map above (thanks to Rebecca Shapley at Google NY for all her help). It takes a while to load and to get the full detail, you need to zoom in close to places.

Theoretically, you can use the data to map routes and use of the network, with the right tools.


UK transport database: London has one of the lowest rates of bus stops in the country. A bus passes the Bank of England in London. Photograph: Simon Dawson/Bloomberg via Getty Images

But that basic CSV file can tell you other things too. We wanted to know which place in Britain has the least bus stops - and which the most. That would mean finding out the number of stops in each area, comparing populations to the ONS population stats and working out a rate per 100,000 people.

Because this data is compiled by locality rather than local authority (a town centre is a locality, for instance), we needed yet another database to compare it to. And that database is the National Public Transport Gazetteer (NPTG) which is basically a list of every administrative boundary for transport in the UK.

Daithi O'Crualaoich helped put the two together and the result is below. It shows that London has one of the lowest rates for bus stops in the country - perhaps mitigated by extensive tube and overground rail network. At the top end are the Western Isles in Scotland and Gwynedd in Wales, which have low populations but lots of bus stops

But that leaves a wealth of data unexplored in folders of data which detail routes and services. Can you help us?

Jesus, this is some wealth of information. Could it be, or was it ever, done for Ireland?

What would you do with this information if you had it?

Cookie_Monster

Its a bit odd looking at the Islands seeing so many realativly speaking.

That is a fantastic amount of information and could be used very well IMO with a bit of decent analysis and raw computing power. Mapping the shift from year to year could help show changing usage patterns at a macro level and I'm sure it could be used to better stream and integrate all forms of transport.