1 DROP VIEW IF EXISTS planet_osm_point_de;
2 CREATE VIEW planet_osm_point_de AS
6 "addr:housename" as "addr:housename",
7 "addr:housenumber" as "addr:housenumber",
8 admin_level as "admin_level",
9 aerialway as "aerialway",
13 boundary as "boundary",
14 building as "building",
15 tags->'capital' as "capital",
16 tags->'denomination' as "denomination",
18 osm_tag2num(tags->'ele') as "num_ele",
19 tags->'generator:source' as "generator:source",
21 historic as "historic",
22 tags->'iata' as "iata",
23 junction as "junction",
26 man_made as "man_made",
27 military as "military",
29 tags->'name:de' as "name:de",
30 tags->'int_name' as "int_name",
31 tags->'name:en' as "name:en",
32 "natural" as "natural",
33 tags->'operator' as "operator",
35 tags->'population' as "population",
37 tags->'power_source' as "power_source",
40 religion as "religion",
41 tags->'ruins' as "ruins",
42 tags->'service' as "service",
44 tags->'sport' as "sport",
46 waterway as "waterway",
47 tags->'wetland' as "wetland",
48 osm_tag2num(tags->'width') as "num_width",
50 tags->'z_order' as z_order,
51 osml10n_get_placename(name, tags->'name:de', tags->'int_name', tags->'name:en',true,false,chr(10),way) as localized_name_second,
52 osml10n_get_placename(name, tags->'name:de', tags->'int_name', tags->'name:en',false,false,chr(10),way) as localized_name_first,
53 osml10n_get_name_without_brackets(name, tags->'name:de', tags->'int_name', tags->'name:en',way) as localized_name_without_brackets,
54 osml10n_get_streetname(name, tags->'name:de', tags->'int_name', tags->'name:en',true,false,chr(10), way) as localized_streetname,
55 COALESCE(tags->'name:hsb',tags->'name:dsb',name) as name_hrb,
58 FROM planet_osm_point;
60 GRANT select ON planet_osm_point_de TO public;