Re: [OSM-dev] Force rendering of names/places to English only

2011-06-22 Thread John Smith
On 22 June 2011 16:26, Haseeb Anwar Ul Haq fast...@gmail.com wrote: Hi, I have built my own openstreetmap server (Ubuntu 10.04) and rendering tiles using mapnik and mod_tile.It works perfectly.Now I want to force rendering of all names (roads,places etc) to english language only (not in

Re: [OSM-dev] Force rendering of names/places to English only

2011-06-22 Thread Peter Körner
Am 22.06.2011 08:30, schrieb John Smith: On 22 June 2011 16:26, Haseeb Anwar Ul Haqfast...@gmail.com wrote: Hi, I have built my own openstreetmap server (Ubuntu 10.04) and rendering tiles using mapnik and mod_tile.It works perfectly.Now I want to force rendering of all names

Re: [OSM-dev] Force rendering of names/places to English only

2011-06-22 Thread M∡rtin Koppenhoefer
2011/6/22 Peter Körner osm-li...@mazdermind.de: (CASE WHEN name:en IS NOT NULL THEN name:en ELSE name END) AS name Simpler: COALESCE(name:en, name) COALESCE selects the first none-null value from a chain. thank you for this Peter. Can anyone tell how much this influences the speed? Is it

Re: [OSM-dev] Force rendering of names/places to English only

2011-06-22 Thread Jukka Rahkonen
Hi, It is rather hard say how it would influence the speed in your environment. Explain (http://www.evolane.com/support/manuals/shared/manuals/postgresql/html/sql-explain.html) should give you some numbers to compare and http://developer.postgresql.org/pgdocs/postgres/planner-optimizer.html some