[Tile-serving] [osm2pgsql] Allow Unsuperseeded Way Tag Updates (#230)

[Paul Norman]

> My use case is as follows. I want to make a database that contains information useful for routing. Most of this information is readily avialable on the way. One thing that isn't are the tags needed for shielding/naming for numbered routes as well as their direction. This information exists in the relation's name and it's members' roles when the relation has type=route for example. In this case it would be really handy to be able to "push" tag and roles information from the relation into additional tags on each of the member ways.

What you want to do is basically this, but pre-computed, right?
```sql
SELECT w.way, w.name, w.highway, w.ref, r.ref AS network_ref, r.network AS network_network
  FROM planet_osm_line w
    LEFT JOIN (SELECT * FROM planet_osm_line WHERE osm_id < 0) AS r
      ON (..non-trivial join to match ways and relations...)
```


---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/230#issuecomment-66462780
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20141210/3256e12b/attachment.html>