[osmrrze.git] / styles / osm-carto-de / views / view-roads.sql

DROP VIEW IF EXISTS planet_osm_roads_de;
CREATE VIEW planet_osm_roads_de AS
SELECT
osm_id,
admin_level as "admin_level",
covered as "covered",
highway as "highway",
name as "name",
tags->'name:de' as "name:de",
tags->'int_name' as "int_name",
tags->'name:en' as "name:en",
railway as "railway",
ref as "ref",
service as "service",
surface as "surface",
tunnel as "tunnel",
aerialway as "aerialway",
"addr:housenumber" as "addr:housenumber",
aeroway as "aeroway",
amenity as "amenity",
barrier as "barrier",
boundary as "boundary",
building as "building",
historic as "historic",
lock as "lock",
man_made as "man_made",
power as "power",
route as "route",
shop as "shop",
waterway as "waterway",
tags->'width' as "width",
way as way,
way_area as way_area,
z_order as z_order,
osml10n_get_placename(name, tags->'name:de', tags->'int_name', tags->'name:en',true,false,' - ',way) as localized_name_second,
osml10n_get_placename(name, tags->'name:de', tags->'int_name', tags->'name:en',false,false,' - ',way) as localized_name_first,
osml10n_get_name_without_brackets(name, tags->'name:de', tags->'int_name', tags->'name:en', way) as localized_name_without_brackets,
osml10n_get_streetname(name, tags->'name:de', tags->'int_name', tags->'name:en',true,false,' - ', way) as localized_streetname,
COALESCE(tags->'name:hsb',tags->'name:dsb',name) as name_hrb,
layer as layer,
tags as "tags"
FROM planet_osm_roads;

GRANT select ON planet_osm_roads_de TO public;
Commit	Line	Data
d301d873 UO	1	DROP VIEW IF EXISTS planet_osm_roads_de;
	2	CREATE VIEW planet_osm_roads_de AS
	3	SELECT
	4	osm_id,
	5	admin_level as "admin_level",
	6	covered as "covered",
	7	highway as "highway",
	8	name as "name",
	9	tags->'name:de' as "name:de",
	10	tags->'int_name' as "int_name",
	11	tags->'name:en' as "name:en",
	12	railway as "railway",
	13	ref as "ref",
	14	service as "service",
	15	surface as "surface",
	16	tunnel as "tunnel",
	17	aerialway as "aerialway",
	18	"addr:housenumber" as "addr:housenumber",
	19	aeroway as "aeroway",
	20	amenity as "amenity",
	21	barrier as "barrier",
	22	boundary as "boundary",
	23	building as "building",
	24	historic as "historic",
	25	lock as "lock",
	26	man_made as "man_made",
	27	power as "power",
	28	route as "route",
	29	shop as "shop",
	30	waterway as "waterway",
	31	tags->'width' as "width",
	32	way as way,
	33	way_area as way_area,
	34	z_order as z_order,
	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,
	40	layer as layer,
	41	tags as "tags"
	42	FROM planet_osm_roads;
	43
	44	GRANT select ON planet_osm_roads_de TO public;