How to get the street new name and old name and add the same id to each
I need to get the street new name and old name and street name in other language and have conexion between its in form:
+---------+-----------------+------------------+
+---------+----------------------------+------------------+
| city | street name | street_id |
+---------+-----------------+------------------+
+---------+----------------------------+------------------+
| NewYork | new street name | 7 |
+---------+-----------------+------------------+
+---------+----------------------------+------------------+
| NewYork | old street name | 7 (the same id) |
+---------+-----------------+------------------+
+---------+----------------------------+------------------+
| NewYork | other language street name | 7 (the same id) |
+---------+----------------------------+------------------+
I get streets and city with
select * from planet_osm_line
where (
planet_osm_line.highway='living_street' or planet_osm_line.highway='motorway' or planet_osm_line.highway='primary' or planet_osm_line.highway='proposed'
or planet_osm_line.highway='raceway' or planet_osm_line.highway='residential'
or planet_osm_line.highway='road' or planet_osm_line.highway='secondary' or planet_osm_line.highway='tertiary' or planet_osm_line.highway='track'
or planet_osm_line.highway='trunk' or planet_osm_line.highway='unclassified' or planet_osm_line.route='road'
or planet_osm_line.highway='service' or planet_osm_line.highway='cycleway'
)
order by planet_osm_line.osm_id;
And whe i seach street by id i get old and new street name!
