1 DROP VIEW IF EXISTS planet_osm_roads_de;
2 CREATE VIEW planet_osm_roads_de AS
5 admin_level as "admin_level",
9 tags->'name:de' as "name:de",
10 tags->'int_name' as "int_name",
11 tags->'name:en' as "name:en",
17 aerialway as "aerialway",
18 "addr:housenumber" as "addr:housenumber",
22 boundary as "boundary",
23 building as "building",
24 historic as "historic",
26 man_made as "man_made",
30 waterway as "waterway",
31 tags->'width' as "width",
35 osml10n_get_placename(name, tags->'name:de', tags->'int_name', tags->'name:en',true,false,' - ',way) as localized_name_second,
36 osml10n_get_placename(name, tags->'name:de', tags->'int_name', tags->'name:en',false,false,' - ',way) as localized_name_first,
37 osml10n_get_name_without_brackets(name, tags->'name:de', tags->'int_name', tags->'name:en', way) as localized_name_without_brackets,
38 osml10n_get_streetname(name, tags->'name:de', tags->'int_name', tags->'name:en',true,false,' - ', way) as localized_streetname,
39 COALESCE(tags->'name:hsb',tags->'name:dsb',name) as name_hrb,
42 FROM planet_osm_roads;
44 GRANT select ON planet_osm_roads_de TO public;