[OSM-dev] RCN routes with osm2pgsql and TileMill

[Steve Bennett]

Hi all,
  I'm learning TileMill. I'd like to show LCN/RCN cycling route
relations, but the OSM2PGSQL default.style imports them in a weird
way: it creates a table, planet_osm_rels with rows like:

members: {134234, 23423...}
tags: {type,route,route,bicycle,rcn_ref,"EastLink
Trail",network,rcn,name,"EastLink
Trail",Department_of_Transport,"Metropolitan Trail Network"}

Is it possible to style this kind of data in TileMill? Or is there
some kind of intermediate transformation to apply?

Basically what I'd like to end up with would be some of those relation
tags applied directly to the ways:

rel_name:Eastlink Trail
rel_type:route
rel_network:rcn
rel_route:bicycle
etc

(Multiple relations applied to a single way is obviously an issue but
not a big problem here...)

Thanks in advance,
Steve