1 DROP VIEW IF EXISTS planet_osm_line_de;
2 CREATE VIEW planet_osm_line_de AS
6 "addr:interpolation" as "addr:interpolation",
7 aerialway as "aerialway",
10 building as "building",
13 construction as "construction",
15 tags->'culvert' as "culvert",
16 tags->'disused' as "disused",
17 tags->'embankment' as "embankment",
20 historic as "historic",
22 tags->'intermittent' as "intermittent",
23 junction as "junction",
25 man_made as "man_made",
27 tags->'name:de' as "name:de",
28 tags->'int_name' as "int_name",
29 tags->'name:en' as "name:en",
30 "natural" as "natural",
32 tags->'operator' as "operator",
34 tags->'proposed' as "proposed",
40 tracktype as "tracktype",
42 waterway as "waterway",
43 tags->'width' as "width",
44 osm_tag2num(tags->'width') as "num_width",
48 osml10n_get_placename(name, tags->'name:de', tags->'int_name', tags->'name:en',true,false,' - ',way) as localized_name_second,
49 osml10n_get_placename(name, tags->'name:de', tags->'int_name', tags->'name:en',false,false,' - ',way) as localized_name_first,
50 osml10n_get_name_without_brackets(name, tags->'name:de', tags->'int_name', tags->'name:en',way) as localized_name_without_brackets,
51 osml10n_get_streetname(name, tags->'name:de', tags->'int_name', tags->'name:en',true,false,' - ', way) as localized_streetname,
52 COALESCE(tags->'name:hsb',tags->'name:dsb',name) as name_hrb,
57 GRANT select ON planet_osm_line_de to public;