Is it possible to show two name labels on a road?

Question

I'm working on a project where on a road/highway segment, I want to show the name of the road in English as well as the name of the road in the native language. I'm working in XML (mapnik stylesheets) and I found the location where the labels are being added, but when I try to add multiple labels, only one of the labels displays. Is there a way to do this?

Accepted Answer

3

I was able to figure it out. On ingest, if you add an hstore column, it will add all the tags as key/value pairs. I was able to then edit the query slightly to include the native language name as well as the english name.

SQL query update:

select way,highway,name,(tags -> 'name:en') as my_column <-- Add this piece
   from &prefix;_line
   where waterway IS NULL
     and leisure IS NULL
     and landuse IS NULL
     and tags is not null //Also add this line
     and name is not null

Styling (TextSymbolizer):

<>size="9" fill="black" placement="line" fontset-name="book-fonts" halo-radius="1" halo-fill="#fed7a5">[name] + ' ' + [my_column]<>

permanent link

answered 01 Dec '15, 18:56

bddavidson
161●3●4●11
accept rate: 100%

2

Hope you don't mind me accepting your own answer for you as the help site won't let you do it yourself :)

(01 Dec '15, 18:58) SomeoneElse ♦

I was wondering about that. Thanks!

(01 Dec '15, 19:07) bddavidson

Answer 2

1

Have a first look in the OSM wiki about Map_internationalization ...

there is at least one example where names (of places) are displayed in native language and in English below.

Try to get in contact to the maintainer of those server.

permanent link

answered 29 Nov '15, 16:01

stephan75
12.6k●5●56●210
accept rate: 6%

Is it possible to show two name labels on a road?

Follow this question

Related questions