[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Maposmatic-dev] Re: [OSM-dev] How to support name:* in MapOSMatic?
From: |
Peter Körner |
Subject: |
[Maposmatic-dev] Re: [OSM-dev] How to support name:* in MapOSMatic? |
Date: |
Fri, 08 Jan 2010 22:51:32 +0100 |
User-agent: |
Thunderbird 2.0.0.23 (X11/20090817) |
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>