Folks,
I have a technical question about import/export of this data set.
For context, the story so far is:
As per UK legislative requirements, Northern Ireland’s public transport operator, Translink, publishes a list of its bus stops as open data, here: Translink Bus Stop List - data.gov.uk
It’s not a particularly rich data set: for each stop, it just gives the NaPTAN ATCO code (unique identifier), the bus stop name, and location data (expressed as both latitude and longitude to 4 decimal places, and an easting & northing grid reference).
Unfortunately, the data quality is flippin’ awful, to the point where I really couldn’t recommend it being imported into OSM: the problem is with the location data, which is typically about 100 metres out. This might not sound like much, but in practical terms usually (in urban settings) places the bus stop on the wrong side of a street junction or (in rural areas) in the middle of a bloody field somewhere.
In Translink’s own smartphone app (which actually uses OSM as its mapping layer!) this positional error not infrequently causes their routing algorithm to go doolally and draw bizarre suggestions for where the bus goes (like, careering off a flyover bridge and making a 5 mile detour along a motorway and back to get to the next stop).
That being the case, I think manually mapping NI bus stops from personal knowledge, site visits and street/satellite imagery is the only practical way to go about it, and many thousands have indeed been mapped by OSM editors. (There are 17,080 in the Translink data set).
Realistically, I don’t see Translink improving the positional accuracy of their dataset any time soon. They completed a ‘review’ of all their stops in 2023 (which was their stock answer to me before then which I queried any data errors), but whilst they did revise a lot of bus stop names, I haven’t seen a single instance of them correcting the positional data.
So - my technical question:
Is it technically possible for the OSM community to effectively correct Translink’s data for them, by (once a sufficient number of stops have been accurately mapped by OSM editors), to export the OSM data in the same CSV format (Atco code, Name, Lat, Long, Easting, Northing) and just hand it back to Translink for them to use henceforth?
Am I right that would be fairly straightforward, technically? (I don’t actually know how to do it myself, but it’s a bread and butter database query, right?)