[Talk-GB] TfL cycle data published - schema mapping
Martin - CycleStreets
list-osm-talk-gb at cyclestreets.net
Sat Sep 14 13:56:28 UTC 2019
> I will shortly be circulating a proposed mapping of CID -> OSM
> attributes, reflecting the published schema of the finalised version of
> the dataset, for comment.
A proposed mapping of the data is here:
I would very much welcome comments and thoughts!
This is also available as an Excel (and JSON) file at:
This reflects the final released data rather than earlier versions, with
the data viewable and filterable at at:
For each field, I've looked at the data and proposed what is shown as "OSM
tag(s)", and there is an associated "OSM comment" where relevant.
The TfL CID database is large (234,333 assets), but quite a number of the
aspects are not really relevant to OSM. Across the 9 asset types, there are
95 fields, but 23 of them I propose would be discarded (search for
"Discard" on the webpage).
Cycle parking data is in my view the most useful part of the database - it
seems to be more comprehensive than OSM has. The cycle lane data is also
excellent, in that it contains the actual start-stop locations, compared to
OSM's tendency sometimes just to have a single lane marked for the whole
length of a street even though it can come and go.
The data is high quality - I've very rarely come across errors, having now
spent quite a lot of time looking at it. There are two images of each
location so it is verifiable easily.
As an example of data that is likely to be unwanted, 118,893 (~50%) of
these assets are signs (the actual signage head or paint on the ground).
While OSM does have support for traffic_sign=*, in practice this are rarely
used, as the tagging on the Ways that the signage actually represents is
more important, and that data is in any case also represented in the CID as
For instance, a contraflow cycleway has both the line geometry with
clt_contra=TRUE but there are also signs for that contraflow. Only the line
geometry is really needed for OSM. There are a few cases where this doesn't
quite hold true (e.g. where a sign says "No cycling" but the path beyond it
isn't actually present, because that is not classed as cycle
I'll shortly e-mail again with more detailed commentary on various aspects
of what is shown, in particular cases where new tags are suggested.
Searching on the webpage for "Community" will find cases where there are
particular issues which as I say I'll e-mail about separately.
PS The webpage display, which reads from the JSON file, is a bit of a work
in progress - I'm aware the ID links aren't yet activated, and the Browse
map link isn't yet picking up the field (only the type). I'll fix these
Martin, ** CycleStreets - For Cyclists, By Cyclists
Developer, CycleStreets ** https://www.cyclestreets.net/
More information about the Talk-GB