[OSM-newbies] Name in two languages

[Chris Jones]

H.S.Rai wrote:
> On Wed, Oct 29, 2008 at 8:20 AM, H. S. Rai <hardeep.rai at gmail.com> wrote:
>   
>> In JOSM, it showed correctly. That mean at present, rendering in Hindi
>> is on possible on OSM.
>>     
>
> Was able to render it to have hindi in svg format using:
>
> xmlstarlet tr osmarender.xsl osm-map-features-z17.xml > map.svg and
> http://wiki.openstreetmap.org/index.php/Osmarender/Howto
>
> I used name=हिंदी. If I use name:hi, then how to use above commands to
> get rendering using name:hi inplace of default
To render OpenStreetMap Cymraeg(1) I've made the following changes to 
the normal mapnik setup(2)

1 - http://sucs.org/~rollercow/cyosm/
2 - http://wiki.openstreetmap.org/index.php/Mapnik

Modify osm2pgsql to load name:cy into the postgis db

$ svn diff osm2pgsql
Index: osm2pgsql/default.style
===================================================================
--- osm2pgsql/default.style    (revision 11399)
+++ osm2pgsql/default.style    (working copy)
@@ -52,6 +52,7 @@
 node,way   military     text         polygon
 node,way   motorcar     text         linear
 node,way   name         text         linear
+node,way   name:cy         text         linear
 node,way   natural      text         polygon
 node,way   oneway       text         linear
 node       poi          text

Then update the name column with the name:cy value where it exists.

UPDATE planet_osm_line SET name = "name:cy" where "name:cy" is not null;
UPDATE planet_osm_point SET name = "name:cy" where "name:cy" is not null;
UPDATE planet_osm_polygon SET name = "name:cy" where "name:cy" is not null;
UPDATE planet_osm_roads SET name = "name:cy" where "name:cy" is not null;

-- 
Chris Jones, SUCS Admin
http://sucs.org