The HIGHWAY and FOOTWAY attributes
illustrate a common problem in database design. The categories are not
mutually exclusive and there is more than one real world attribute implied in
the categories. As I interpret it there are four real attributes involved:
function, permitted users, physical facility, and land use. Motorway
(better named limited_access), primary thru tertiary, footway_crossing,
footway_sidewalk, footway unspecified, service, and track belong as
categories in the function attribute. Pedestrian, motor vehicle, except
trucks, bicycle, wheelchair would be typical categories for the permitted users
attribute. Only pedestrian is actually available and it is mixed
with categories from other real attributes. One is forced to choose
whether function is the important feature and categorize a way as
footway-sidewalk or if user is the important feature and categorize it as
pedestrian. The physical facility attribute would be the place for
information about steps and curb ramps. Steps and path are available, but
again, they are mixed in with other types of categorization. Curiously,
there is only one land use category available, and that is residential. It
doesn't make sense to me without other categories such as commercial and
industrial. I think it would be better to remove this from the network
attributes. Land use is better as a thematic
overlay.
Cycleway is a unique problem. Some
judgment is needed to categorize a facility as part of a street or as a separate
way. In the same way that OSM has added "_link" to some street types it
may be good to add "_with_bike_lane" to some street types. This gets messy
if you want "secondary_ramp_with_bike_lane", etc. so it may be better to add
another attribute column. This allows WAY = secondary with BIKELANE =
paint_line and also WAY = bikeway with BIKELANE =
NA.
The real problem with all this is that it
isn't at all clear how to enter information about walkways. Some of this
is due to the nature of data entry by citizens who are not trained on well
documented standards. Some of it is due to the design of the OSM segment
attributes and categories. We can find most places with steps but it will
be difficult to turn this into a sidewalk or crosswalk that is weighted by the
existance of steps. Just because a way is categorized as "path" or
"pedestrian" or "footway" doesn't mean that it does not have steps. We
won't know if a walkway is a manually entered sidewalk that duplicates a
generated walkway of an off street path that needs to be added to the walkway
network. In the end we'll need to examine each way that is not definitely
a street and resolve it manually.
Scott