projects / osmrrze.git / blame
| Commit | Line | Data |
|---|---|---|
| d301d873 UO |
1 | DROP VIEW IF EXISTS planet_osm_polygon_de; |
| 2 | CREATE VIEW planet_osm_polygon_de AS | |
| 3 | SELECT | |
| 4 | osm_id, | |
| 5 | "access" as "access", | |
| 6 | "addr:housename" as "addr:housename", | |
| 7 | "addr:housenumber" as "addr:housenumber", | |
| 8 | admin_level as "admin_level", | |
| 9 | aerialway as "aerialway", | |
| 10 | aeroway as "aeroway", | |
| 11 | amenity as "amenity", | |
| 12 | barrier as "barrier", | |
| 13 | bicycle as "bicycle", | |
| 14 | boundary as "boundary", | |
| 15 | bridge as "bridge", | |
| 16 | building as "building", | |
| 17 | tags->'denomination' as "denomination", | |
| 18 | tags->'generator:source' as "generator:source", | |
| 19 | highway as "highway", | |
| 20 | historic as "historic", | |
| 21 | tags->'iata' as "iata", | |
| 22 | junction as "junction", | |
| 23 | landuse as "landuse", | |
| 24 | tags->'leaf_type' as "leaf_type", | |
| 25 | leisure as "leisure", | |
| 26 | man_made as "man_made", | |
| 27 | military as "military", | |
| 28 | name as "name", | |
| 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", | |
| 34 | place as "place", | |
| 35 | power as "power", | |
| 36 | tags->'power_source' as "power_source", | |
| 37 | railway as "railway", | |
| 38 | ref as "ref", | |
| 39 | religion as "religion", | |
| 40 | tags->'ruins' as "ruins", | |
| 41 | shop as "shop", | |
| 42 | tags->'sport' as "sport", | |
| 43 | surface as "surface", | |
| 44 | tourism as "tourism", | |
| 45 | waterway as "waterway", | |
| 46 | tags->'wetland' as "wetland", | |
| 47 | osm_tag2num(tags->'width') as "num_width", | |
| 48 | way as "way", | |
| 49 | way_area as way_area, | |
| 50 | 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 | osml10n_get_country_name(tags,chr(10),'de') as country_name, | |
| 56 | COALESCE(tags->'name:hsb',tags->'name:dsb',name) as name_hrb, | |
| 57 | layer as layer, | |
| 58 | tags as "tags" | |
| 59 | FROM planet_osm_polygon; | |
| 60 | ||
| 61 | GRANT select ON planet_osm_polygon_de TO public; |