| 1 | DROP VIEW IF EXISTS planet_osm_line_de; |
| 2 | CREATE VIEW planet_osm_line_de AS |
| 3 | SELECT |
| 4 | osm_id, |
| 5 | access as "access", |
| 6 | "addr:interpolation" as "addr:interpolation", |
| 7 | aerialway as "aerialway", |
| 8 | aeroway as "aeroway", |
| 9 | barrier as "barrier", |
| 10 | building as "building", |
| 11 | bicycle as "bicycle", |
| 12 | bridge as "bridge", |
| 13 | construction as "construction", |
| 14 | covered as "covered", |
| 15 | tags->'culvert' as "culvert", |
| 16 | tags->'disused' as "disused", |
| 17 | tags->'embankment' as "embankment", |
| 18 | foot as "foot", |
| 19 | highway as "highway", |
| 20 | historic as "historic", |
| 21 | horse as "horse", |
| 22 | tags->'intermittent' as "intermittent", |
| 23 | junction as "junction", |
| 24 | "lock" as "lock", |
| 25 | man_made as "man_made", |
| 26 | name as "name", |
| 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", |
| 31 | oneway as "oneway", |
| 32 | tags->'operator' as "operator", |
| 33 | "power" as "power", |
| 34 | tags->'proposed' as "proposed", |
| 35 | railway as "railway", |
| 36 | ref as "ref", |
| 37 | route as "route", |
| 38 | service as "service", |
| 39 | surface as "surface", |
| 40 | tracktype as "tracktype", |
| 41 | tunnel as "tunnel", |
| 42 | waterway as "waterway", |
| 43 | tags->'width' as "width", |
| 44 | osm_tag2num(tags->'width') as "num_width", |
| 45 | way as "way", |
| 46 | way_area as way_area, |
| 47 | z_order as z_order, |
| 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, |
| 53 | layer as layer, |
| 54 | tags as tags |
| 55 | FROM planet_osm_line; |
| 56 | |
| 57 | GRANT select ON planet_osm_line_de to public; |