generalizations.yml

---
# Since imposm isn't unifying values, we use tags ? 'key' AND tags -> 'key' != 'no'

# Aeroways
- name: aeroways
  materialized: false
  index_by: the_geom
  select: the_geom AS the_geom_webmercator, tags -> 'aeroway' AS type
  from: planet
  where: tags ? 'aeroway' AND tags -> 'aeroway' != 'no'

# admin-0 and admin-1 boundaries
- name: administrative
  materialized: true
  cluster_on: the_geom
  index_by: the_geom_webmercator
  select: tags, tags -> 'admin_level' AS admin_level, the_geom AS the_geom_webmercator
  from: planet
  where: tags -> 'boundary' = 'administrative'

# Buildings
- name: buildings_z14plus
  materialized: true
  cluster_on: the_geom
  index_by: the_geom_webmercator
  select: osm_id, tags -> 'building' building, tags -> 'height' height, ST_Area(the_geom)::bigint AS area, the_geom AS the_geom_webmercator
  from: planet
  where: tags ? 'building' AND tags -> 'building' != 'no'

- name: buildings_z13
  materialized: true
  cluster_on: the_geom_webmercator
  index_by: the_geom_webmercator
  select: osm_id, building, height, area, generalize(the_geom_webmercator,13) as the_geom_webmercator
  from: buildings_z14plus
  where: area > 10000

# Green Areas
# 1311+160+9
- name: green_areas_z14plus
  materialized: false
  index_by: the_geom
  select: tags -> 'name' AS name, ST_Area(the_geom)::bigint AS area, the_geom AS the_geom_webmercator
  from: planet
  where: tags -> 'leisure' IN ('park','water_park','marina','nature_reserve','playground',
         'garden','common','sports_centre','golf_course','stadium','track','pitch')
         OR tags -> 'amenity' IN ('graveyard')
         OR tags -> 'landuse' IN ('cemetery','recreation_ground','forest','wood')

- name: green_areas_z13
  materialized: true
  cluster_on: the_geom_webmercator
  index_by: the_geom_webmercator
  select: name, area, generalize(the_geom_webmercator,13) as the_geom_webmercator
  from: green_areas_z14plus
  where: area > 75000

- name: green_areas_z10
  materialized: true
  cluster_on: the_geom_webmercator
  index_by: the_geom_webmercator
  select: name, area, generalize(the_geom_webmercator,10) as the_geom_webmercator
  from: green_areas_z13
  where: area > 5000000

# Water Areas
- name: water_areas_z14plus
  materialized: false
  index_by: the_geom
  select: tags -> 'name' AS name, ST_Area(the_geom)::bigint AS area, COALESCE(tags -> 'natural', tags -> 'waterway', tags -> 'landuse') AS type, the_geom AS the_geom_webmercator
  from: planet
  where: tags -> 'natural' IN ('water','bay')
         OR tags -> 'waterway' IN ('riverbank','canal','river')
         OR tags -> 'landuse' IN ('reservoir')

- name: water_areas_z13
  materialized: true
  cluster_on: the_geom_webmercator
  index_by: the_geom_webmercator
  select: name, area, type, generalize(the_geom_webmercator,13) as the_geom_webmercator
  from: water_areas_z14plus
  where: area > 25000 OR type = 'riverbank'

- name: water_areas_z10
  materialized: true
  cluster_on: the_geom_webmercator
  index_by: the_geom_webmercator
  select: name, area, type, generalize(the_geom_webmercator,10) as the_geom_webmercator
  from: water_areas_z13
  where: area > 25000 OR type = 'riverbank'

# Roads
- name: highroad_z15plus
  materialized: true
  cluster_on: the_geom
  index_by: the_geom_webmercator
  select: the_geom AS the_geom_webmercator,  
          tags -> 'highway' as highway,
          tags -> 'railway' as railway,
          (CASE WHEN tags -> 'highway' IN ('motorway', 'motorway_link') THEN 'highway'
             WHEN tags -> 'highway' IN ('trunk', 'trunk_link', 'primary', 'primary_link', 'secondary', 'secondary_link', 'tertiary', 'tertiary_link') THEN 'major_road'
             WHEN tags -> 'highway' IN ('footpath', 'track', 'footway', 'steps', 'pedestrian', 'path', 'cycleway') THEN 'path'
             WHEN tags -> 'railway' IN ('rail', 'tram', 'light_rail', 'narrow_guage', 'monorail') THEN 'rail'
             ELSE 'minor_road' END) AS kind,
          (CASE WHEN tags -> 'highway' IN ('motorway_link','trunk_link','primary_link','secondary_link','tertiary_link') THEN 'yes'
             ELSE 'no' END) AS is_link,
          (CASE WHEN tags ? 'tunnel' AND tags -> 'tunnel' != 'no' THEN 'yes'
             ELSE 'no' END) AS is_tunnel,
          (CASE WHEN tags ? 'bridge' AND tags -> 'bridge' != 'no' THEN 'yes'
             ELSE 'no' END) AS is_bridge,
          wayzorder(tags) as z_order ,
          tags -> 'name' as name,
          tags -> 'ref' as ref
  from: planet
  where: tags -> 'highway' IN ('motorway', 'motorway_link')
           OR tags -> 'highway' IN ('trunk', 'trunk_link', 'primary', 'primary_link', 'secondary', 'secondary_link', 'tertiary', 'tertiary_link')
           OR tags -> 'highway' IN ('residential', 'unclassified', 'road', 'unclassified', 'service', 'minor')
           OR tags -> 'highway' IN ('footpath', 'track', 'footway', 'steps', 'pedestrian', 'path', 'cycleway')
           OR tags -> 'railway' IN ('rail', 'tram', 'light_rail', 'narrow_guage', 'monorail')

- name: highroad_z14
  materialized: true
  cluster_on: the_geom_webmercator
  index_by: the_geom_webmercator
  select: generalize(the_geom_webmercator, 14) AS the_geom_webmercator,
          highway,
          railway,
          (CASE WHEN highway IN ('motorway', 'motorway_link') THEN 'highway'
                WHEN highway IN ('trunk', 'trunk_link', 'primary', 'primary_link', 'secondary', 'secondary_link', 'tertiary', 'tertiary_link') THEN 'major_road'
                WHEN highway IN ('residential', 'unclassified', 'road', 'minor') THEN 'minor_road'
                WHEN railway IN ('rail') THEN 'rail'
                ELSE 'unknown' END) AS kind,
          is_link,
          is_tunnel,
          is_bridge,
          z_order,
          name,
          ref
  from: highroad_z15plus
  where: highway in ('motorway', 'motorway_link', 'trunk', 'trunk_link', 'primary', 
           'primary_link', 'secondary','secondary_link', 'tertiary',
           'tertiary_link','residential','unclassified','road','minor') 
         OR railway = 'rail'

- name: highroad_z13
  materialized: true
  cluster_on: the_geom_webmercator
  index_by: the_geom_webmercator
  select: generalize(the_geom_webmercator, 13) AS the_geom_webmercator,
          highway,
          railway,
          (CASE WHEN highway IN ('motorway', 'motorway_link') THEN 'highway'
                WHEN highway IN ('trunk', 'trunk_link', 'primary', 'primary_link', 'secondary', 'secondary_link', 'tertiary', 'tertiary_link') THEN 'major_road'
                ELSE 'minor_road' END) AS kind,
          is_link,
          is_tunnel,
          is_bridge,
          z_order,
          name,
          ref
  from: highroad_z14
  where: highway in ('motorway', 'motorway_link', 'trunk', 'trunk_link', 'primary', 'primary_link', 'secondary','secondary_link', 'tertiary','residential','unclassified','road')
         OR railway = 'rail'

- name: highroad_z12
  materialized: true
  cluster_on: the_geom_webmercator
  index_by: the_geom_webmercator
  select: generalize(the_geom_webmercator, 12) AS the_geom_webmercator,
          highway,
          railway,
          (CASE WHEN highway IN ('motorway') THEN 'highway'
                WHEN highway IN ('trunk', 'secondary', 'primary') THEN 'major_road'
                ELSE 'minor_road' END) AS kind,
          'no'::text AS is_link,
          is_tunnel,
          is_bridge,
          z_order,
          name,
          ref
  from: highroad_z13
  where: highway in ('motorway', 'trunk', 'primary', 'secondary','tertiary','residential','unclassified','road')

- name: highroad_z11
  materialized: true
  cluster_on: the_geom_webmercator
  index_by: the_geom_webmercator
  select: generalize(the_geom_webmercator, 11) AS the_geom_webmercator,
          highway,
          railway,
          (CASE WHEN highway IN ('motorway') THEN 'highway'
                WHEN highway IN ('trunk', 'primary') THEN 'major_road'
                ELSE 'minor_road' END) AS kind,
          'no'::text AS is_link,
          is_tunnel,
          is_bridge,
          z_order,
          name,
          ref
  from: highroad_z12
  where: highway in ('motorway', 'trunk', 'primary', 'secondary', 'tertiary')

- name: highroad_z10
  materialized: true
  cluster_on: the_geom_webmercator
  index_by: the_geom_webmercator
  select: generalize(the_geom_webmercator, 10) AS the_geom_webmercator,
         highway,
         railway,
         (CASE WHEN highway IN ('motorway') THEN 'highway'
               WHEN highway IN ('trunk', 'primary') THEN 'major_road'
               ELSE 'minor_road' END) AS kind,
         'no'::text AS is_link,
         is_tunnel,
         is_bridge,
         z_order,
         name,
         ref
  from: highroad_z11
  where: highway in ('motorway', 'trunk', 'primary', 'secondary')

- name: places
  materialized: false
  index_by: the_geom
  select: tags -> 'place' AS place,
          tags -> 'name' AS name,
          tags -> 'population' AS population,
          the_geom AS the_geom_webmercator
  from: planet
  where: tags -> 'place' IN ('city','town','village','hamlet','suburb','neighbourhood')