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>
_______________________________________________
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev
