[Maposmatic-dev] Re: [OSM-dev] How to support name:* in MapOSMatic?

[Peter Körner]

On the toolserver we imported with this style [1] and so have the name, 
 name:de, name:fr, etc. columns. Then we used the script [2] to created 
one view for each language and for each table:

SELECT planet_osm_point.osm_id, planet_osm_point.access, 
planet_osm_point."addr:flats", planet_osm_point."addr:housenumber", 
planet_osm_point."addr:interpol
ation", planet_osm_point.admin_level, planet_osm_point.aerialway, 
planet_osm_point.aeroway, planet_osm_point.amenity, 
planet_osm_point.area, planet_osm_point
.barrier, planet_osm_point.bicycle, planet_osm_point.bridge, 
planet_osm_point.boundary, planet_osm_point.building, 
planet_osm_point.capital, planet_osm_point
.construction, planet_osm_point.cutting, planet_osm_point.disused, 
planet_osm_point.ele,
planet_osm_point.embankment, planet_osm_point.foot, 
planet_osm_point.highway, planet_osm_point.historic, 
planet_osm_point.horse, planet_osm_point.junction, 
planet_osm_point.landuse, planet_osm_point.layer, 
planet_osm_point.learning, planet_osm_point.leisure, 
planet_osm_point.lock, planet_osm_point.man_made, 
planet_osm_point.military, planet_osm_point.motorcar, 
planet_osm_point.cycleway, planet_osm_point.operator, 
planet_osm_point.surveillance, planet_osm_point.website, 
planet_osm_point.wikipedia, planet_osm_point.opening_hours, 
planet_osm_point.phone, planet_osm_point.fax, planet_osm_point.url, 
planet_osm_point.importance, planet_osm_point.fee, 
planet_osm_point.information, planet_osm_point.shop, 
planet_osm_point.path, planet_osm_point.tower, planet_osm_point.lit,
        CASE
            WHEN planet_osm_point."name:de" IS NOT NULL THEN
                planet_osm_point."name:de"
            ELSE
                planet_osm_point.name
        END AS name,
planet_osm_point."natural", planet_osm_point.oneway, 
planet_osm_point.poi, planet_osm_point.power, 
planet_osm_point.power_source, planet_osm_point.place, 
planet_osm_point.railway, planet_osm_point.ref, 
planet_osm_point.religion, planet_osm_point.residence, 
planet_osm_point.route, planet_osm_point.service, 
planet_osm_point.sport, planet_osm_point.tourism, 
planet_osm_point.tunnel, planet_osm_point.waterway, 
planet_osm_point.width, planet_osm_point.wood, planet_osm_point.z_order, 
planet_osm_point.way FROM planet_osm_point;


Maybe you can access them more easily.

Peter


[1]<https://svn.toolserver.org/svnroot/mazder/planet-import/wikimedia.style>