terrain-classic.yml

# == Global project settings ===========================================

name:             'Terrain Classic'
description:      ''
attribution:      'Map Data © OpenStreetMap'
center:           [-122.41, 37.74, 7]
format:           png
interactivity:    false
minzoom:          0
maxzoom:          18
srs:              '+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over'
metatile:         1


# == Layer & Datasource defaults =======================================

_layer_default:   &layer
  'srs-name':     '3857'
  srs:            '+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over'

_pg_default:      &postgis
  type:           postgis
  dbname:         '{{PGDATABASE}}'
  host:           '{{PGHOST}}'
  user:           '{{PGUSER}}'
  password:       '{{PGPASSWORD}}'
  port:           '{{PGPORT}}'
  geometry_field: way
  srid:           3857
  extent:         '-20037508.34,-20037508.34,20037508.34,20037508.34'
  srs:            '+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over'
  max_async_connection: 4
  max_size: 100
  connect_timeout: 1
  twkb_encoding: true # also sets simplify_geometries

_shp_default:     &shapefile
  type:           shape
  estimate_extent: false
  extent:         '-20037508.34,-20037508.34,20037508.34,20037508.34'
  srs:            '+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over'

# == Stylesheets =======================================================

Stylesheet:
  - map.mss
  - labels.mss
  - terrain-classic.mss


# == Layers ============================================================

Layer:

  - <<: *layer
    name: land
    id:   land
    properties:
      minzoom: 8
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: >
        (
          SELECT
            ST_ClipByBox2D(geom, !bbox!) geom
          FROM land_polygons
          WHERE geom && !bbox!
        ) AS _

  - <<: *layer
    name: lc500mMODIS_high
    id:   lc500mMODIS_high
    properties:
      minzoom: 0
      maxzoom: 15
    geometry: raster
    srs: '+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over'
    Datasource:
      type: gdal
      file: landcover/LCType_z9.vrt
      # file: landcover/LCType_z9_s3.vrt

  - <<: *layer
    name: lc500mMODIS_urban
    id:   lc500mMODIS_urban
    properties:
      minzoom: 9
    geometry: raster
    srs: '+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over'
    Datasource:
      type: gdal
      file: landcover/LCType_z9-urban-only.vrt
      # file: landcover/LCType_z9_s3-urban-only.vrt

  - <<: *layer
    name: ne_10m_rivers_lake_centerlines_scale_rank
    id:   ne_10m_rivers_lake_centerlines_scale_rank
    properties:
      minzoom: 4
      maxzoom: 8
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_10m_rivers_lake_centerlines_scale_rank
      encoding: "ISO-8859-1"

  - <<: *layer
    name: ne_50m_lakes
    id:   ne_50m_lakes
    properties:
      minzoom: 2
      maxzoom: 5
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_50m_lakes
      encoding: "ISO-8859-1"

  - <<: *layer
    name: ne_10m_lakes
    id:   ne_10m_lakes
    properties:
      minzoom: 6
      maxzoom: 8
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_10m_lakes
      encoding: "ISO-8859-1"

  - <<: *layer
    name: ne_10m_ocean
    id:   ne_10m_ocean
    properties:
      minzoom: 0
      maxzoom: 7
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_10m_ocean
      encoding: "ISO-8859-1"

  - <<: *layer
    name: ne_50m_ocean
    id:   ne_50m_ocean
    properties:
      minzoom: 0
      maxzoom: 7
    Datasource:
      <<: *postgis
      geometry_field: geom
      encoding: "ISO-8859-1"
      table: >
        (
          SELECT
            ST_ClipByBox2D(geom, !bbox!) geom
          FROM ne_50m_ocean
          WHERE geom && !bbox!
        ) AS _

  - <<: *layer
    name: ne_110m_geography_marine_polys
    id:   ne_110m_geography_marine_polys
    properties:
      minzoom: 2
      maxzoom: 3
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_110m_geography_marine_polys
      encoding: "ISO-8859-1"

  - <<: *layer
    name: ne_50m_geography_marine_polys
    id:   ne_50m_geography_marine_polys
    properties:
      minzoom: 4
      maxzoom: 5
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_50m_geography_marine_polys
      encoding: "ISO-8859-1"

  - <<: *layer
    name: ne_10m_geography_marine_polys
    id:   ne_10m_geography_marine_polys
    properties:
      minzoom: 6
      maxzoom: 8
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_10m_geography_marine_polys
      encoding: "ISO-8859-1"

  - <<: *layer
    name: nullisland
    id:   nullisland
    class: land
    properties:
      minzoom: 12
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: nullisland

  - <<: *layer
    name: country-shapes-50m
    id:   country-shapes-50m
    class: shore
    properties:
      minzoom: 2
      maxzoom: 3
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_50m_admin_0_countries_lakes

  - <<: *layer
    name: country-shapes-10m
    id:   country-shapes-10m
    class: shore
    properties:
      minzoom: 4
      maxzoom: 7
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: >
        (
          SELECT
            ST_ClipByBox2D(geom, !bbox!) geom
          FROM ne_10m_admin_0_countries_lakes
          WHERE geom && !bbox!
        ) AS _

  - <<: *layer
    name: admin0-map-units-10m
    id:   admin0-map-units-10m
    properties:
      minzoom: 4
      maxzoom: 9
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_10m_admin_0_boundary_lines_map_units

  - <<: *layer
    name: admin1-lines-10m
    id:   admin1-lines-10m
    properties:
      minzoom: 4
      maxzoom: 9
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_10m_admin_1_states_provinces_lines

  - <<: *layer
    name: ne_50m_admin_0_boundary_lines_land
    id:   ne_50m_admin_0_boundary_lines_land
    class: country-boundary
    properties:
      minzoom: 3
      maxzoom: 4
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_50m_admin_0_boundary_lines_land

  - <<: *layer
    name: ne_10m_admin_0_boundary_lines_land
    id:   ne_10m_admin_0_boundary_lines_land
    class: country-boundary-10m
    properties:
      minzoom: 5
      maxzoom: 9
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_10m_admin_0_boundary_lines_land

  - <<: *layer
    name: admin1-lines-osm
    id:   admin1-lines-osm
    properties:
      minzoom: 10
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            ST_ClipByBox2D(geometry, !bbox!) geometry,
            name,
            area_km2
          FROM osm_admin
          WHERE geometry && !bbox!
            AND type = 'administrative'
            AND admin_level = 4
        ) AS _

  - <<: *layer
    name: urban-landuse-high
    id:   urban-landuse-high
    class: urban-landuse
    properties:
      minzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            geometry,
            type,
            area
          FROM osm_urban_areas
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: urban-landuse-med
    id:   urban-landuse-med
    class: urban-landuse
    properties:
      minzoom: 11
      maxzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            geometry,
            type,
            area
          FROM osm_urban_areas_z13
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: urban-landuse-low
    id:   urban-landuse-low
    class: urban-landuse
    properties:
      minzoom: 9
      maxzoom: 11
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            geometry,
            type,
            area
          FROM osm_urban_areas_z10
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: aerodromes
    id:   aerodromes
    properties:
      minzoom: 12
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry
          FROM osm_aeroways
          WHERE type='aerodrome' and geometry && !bbox!
        ) AS _

  - <<: *layer
    name: green-areas-high
    id:   green-areas-high
    properties:
      minzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            geometry,
            type,
            area
          FROM osm_green_areas
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: green-areas-med
    id:   green-areas-med
    properties:
      minzoom: 11
      maxzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_green_areas_z13
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: green-areas-low
    id:   green-areas-low
    properties:
      minzoom: 10
      maxzoom: 10
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_green_areas_z10
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: landcover-high
    id:   landcover-high
    class: landcover
    properties:
      minzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            geometry,
            type,
            area
          FROM osm_landcover
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: landcover-med
    id:   landcover-med
    class: landcover
    properties:
      minzoom: 11
      maxzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            geometry,
            type,
            area
          FROM osm_landcover_z13
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: landcover-low
    id:   landcover-low
    class: landcover
    properties:
      minzoom: 9
      maxzoom: 11
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            geometry,
            type,
            area
          FROM osm_landcover_z10
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: water
    id:   water
    properties:
      minzoom: 8
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: water_polygons

  - <<: *layer
    name: water-bodies-high
    id:   water-bodies-high
    properties:
      minzoom: 14
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_water_areas
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: water-bodies-med
    id:   water-bodies-med
    properties:
      minzoom: 11
      maxzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_water_areas_z13
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: water-bodies-low
    id:   water-bodies-low
    properties:
      minzoom: 8
      maxzoom: 10
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_water_areas_z10
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: brown-areas-high
    id:   brown-areas-high
    properties:
      minzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            geometry,
            type,
            area
          FROM osm_brown_areas
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: brown-areas-med
    id:   brown-areas-med
    properties:
      minzoom: 11
      maxzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_brown_areas_z13
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: brown-areas-low
    id:   brown-areas-low
    properties:
      minzoom: 10
      maxzoom: 10
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_brown_areas_z10
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: ne-roads
    id:   ne-roads
    properties:
      minzoom: 7
      maxzoom: 8
      cache-features: on
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_10m_roads

  - <<: *layer
    name: aeroways
    id:   aeroways
    properties:
      minzoom: 12
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry
          FROM osm_aeroways
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: tunnels
    id:   tunnels
    class: tunnels
    properties:
      minzoom: 14
      cache-features: on
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT *
          FROM high_road(!scale_denominator!, !bbox!, 'is_tunnel=''yes''')
        ) AS _

  - <<: *layer
    name: roads
    id:   roads
    class: roads
    properties:
      minzoom: 14
      cache-features: on
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT *
          FROM high_road(!scale_denominator!, !bbox!)
        ) AS _

  - <<: *layer
    name: roads_med
    id:   roads_med
    properties:
      minzoom: 9
      maxzoom: 13
      cache-features: on
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT *
          FROM high_road(!scale_denominator!, !bbox!, 'kind!=''highway''')
        ) AS _

  - <<: *layer
    name: highways_med
    id:   highways_med
    properties:
      minzoom: 9
      maxzoom: 13
      cache-features: on
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT *
          FROM high_road(!scale_denominator!, !bbox!, 'kind=''highway''')
        ) AS _

  - <<: *layer
    name: bridges
    id:   bridges
    class: bridges
    properties:
      minzoom: 13
      cache-features: on
      group-by: explicit_layer
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT *
          FROM high_road(!scale_denominator!, !bbox!, 'is_bridge=''yes''')
        ) AS _

  - <<: *layer
    name: buildings-high
    id:   buildings-high
    properties:
      minzoom: 14
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            osm_id,
            name,
            type,
            geometry,
            area
          FROM osm_buildings
          WHERE geometry && !bbox!
        ) AS _

# Start Labels
  - <<: *layer
    name: admin0-labels-z3
    id:   admin0-labels-z3
    properties:
      minzoom: 3
      maxzoom: 3
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: admin_0_countries_110m_points

  - <<: *layer
    name: admin0-labels-z4
    id:   admin0-labels-z4
    properties:
      minzoom: 4
      maxzoom: 4
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: admin_0_labels_z4

  - <<: *layer
    name: admin0-labels-z5
    id:   admin0-labels-z5
    properties:
      minzoom: 5
      maxzoom: 5
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: admin_0_labels_z5

  - <<: *layer
    name: admin0-labels-z6
    id:   admin0-labels-z6
    properties:
      minzoom: 6
      maxzoom: 6
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: admin_0_labels_z6

  # ---- Mountain Peaks -----------------
  - <<: *layer
    name: mountain_peaks_ne
    id: mountain_peaks_ne
    properties:
      minzoom: 6
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: >
        (
          SELECT
            (CASE
            WHEN name = 'Haleakal?' THEN 'Haleakalā'
            WHEN name = 'Volca?n Villarrica' THEN 'Villarrica'
            WHEN name = 'Sn?ka' THEN 'Sněžka'
            WHEN name = 'Qurnat as Sawd?' THEN 'Qurnat as Sawdā’'
            WHEN name = 'Sabalon K?h' THEN 'Sabalan'
            WHEN name = 'Jabal Sawd?' THEN 'Jabal Sawda'
            WHEN name = 'Jabal an-Nab? Shuaib' THEN 'Jabal an-Nabi Shu’aib'
            WHEN name = 'K?h-e Haji Ebrahim' THEN 'Kuhe Haji Ebrahim'
            WHEN name = 'Mt. Dam?vand' THEN 'Mt. Damavand'
            WHEN name = 'K?h-e Jang Qal''eh' THEN 'Kuh-e Jang Qal’eh'
            WHEN name = 'Tirich M?r' THEN 'Tirich Mir'
            WHEN name = 'Alada? Tepe' THEN ''
            WHEN name = 'K?h-e Nay Band' THEN ''
            WHEN name = 'K?h-e Hez?r' THEN ''
            WHEN name = 'K?h-e Taftan' THEN ''
            WHEN name = 'K?h-e R?zeh' THEN ''
            ELSE name
            END) AS name,
            name_alt,
            elevation,
            comment,
            geom,
            featurecla
          FROM ne_10m_geography_regions_elevation_points
          WHERE geom && !bbox!
        ) AS _

# ---- admin 1 labels ----------------------------------------------------

  - <<: *layer
    name: admin1-labels-50m-z4
    id:   admin1-labels-50m-z4
    properties:
      minzoom: 4
      maxzoom: 4
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: admin_1_labels_z4

  - <<: *layer
    name: admin1-labels-50m-z5
    id:   admin1-labels-50m-z5
    properties:
      minzoom: 5
      maxzoom: 5
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: admin_1_labels_z5

  - <<: *layer
    name: admin1-labels
    id:   admin1-labels
    properties:
      minzoom: 5
      maxzoom: 7
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            admin,
            geometry,
            scalerank
          FROM ne_10m_admin_1_states_provinces_labels
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: water-bodies-labels-high
    id:   water-bodies-labels-high
    properties:
      minzoom: 14
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_water_areas
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: water-bodies-labels-med
    id:   water-bodies-labels-med
    properties:
      minzoom: 11
      maxzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_water_areas_z13
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: water-bodies-labels-low
    id:   water-bodies-labels-low
    properties:
      minzoom: 8
      maxzoom: 10
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_water_areas_z10
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: green-areas-labels-high
    id:   green-areas-labels-high
    properties:
      minzoom: 14
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_green_areas
          WHERE geometry && !bbox!
          ORDER BY area DESC
        ) AS _

  - <<: *layer
    name: green-areas-labels-med
    id:   green-areas-labels-med
    properties:
      minzoom: 11
      maxzoom: 13
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_green_areas_z13
          WHERE geometry && !bbox!
          ORDER BY area DESC
        ) AS _

  - <<: *layer
    name: green-areas-labels-low
    id:   green-areas-labels-low
    properties:
      minzoom: 8
      maxzoom: 10
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            name,
            type,
            geometry,
            area
          FROM osm_green_areas_z10
          WHERE geometry && !bbox!
          ORDER BY area DESC
        ) AS _

  - <<: *layer
    name: major_road_labels
    id:   major_road_labels
    properties:
      minzoom: 12
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (SELECT geometry,
            (CASE WHEN highway = 'motorway'
                  THEN ''
                  ELSE replace(name, ' ', '   ')
                  END) AS name,
            (CASE WHEN highway = 'motorway' AND CHAR_LENGTH(ref) BETWEEN 2 AND 15
                  THEN REGEXP_REPLACE(ref, E'\s*;\s*', E' / ', 'g')
                  ELSE ''
                  END) AS ref,
            (CASE WHEN highway = 'motorway' AND CHAR_LENGTH(ref) BETWEEN 2 AND 15
                  THEN CHAR_LENGTH(ref)
                  ELSE 0
                  END) AS ref_length,
            highway,
            ST_Length(geometry) AS length,
            (CASE WHEN highway IN ('motorway', 'motorway_link') THEN 0
                  WHEN highway IN ('footpath', 'track', 'footway', 'steps', 'pedestrian', 'path', 'cycleway') THEN 1
                  WHEN railway IN ('rail', 'spur', 'subway', 'light_rail', 'tram', 'abandoned', 'disused', 'monorail') THEN 2
                  WHEN highway IN ('trunk', 'trunk_link', 'primary', 'primary_link') THEN 3
                  WHEN highway = 'secondary' THEN 4
                  WHEN highway = 'tertiary' THEN 5
                  ELSE 9 END) AS priority,
            (CASE WHEN highway IN ('secondary', 'trunk', 'trunk_link', 'primary', 'primary_link', 'motorway', 'motorway_link') THEN 'major_road'
                  WHEN highway IN ('residential', 'unclassified', 'service', 'minor', 'road', 'tertiary') THEN 'minor_road'
                  WHEN railway IN ('rail', 'spur', 'subway', 'light_rail', 'tram', 'abandoned', 'disused', 'monorail') THEN 'rail'
                  WHEN highway IN ('footpath', 'track', 'footway', 'steps', 'pedestrian', 'path', 'cycleway') THEN 'path'
                  ELSE '' END) AS kind,
            (CASE WHEN tunnel = 1 THEN 'yes'
                  ELSE 'no' END) AS is_tunnel,
            (CASE WHEN bridge = 1 THEN 'yes'
                  ELSE 'no' END) AS is_bridge
         FROM osm_roads
         WHERE geometry && !bbox!
           AND highway IN ('secondary', 'trunk', 'trunk_link', 'primary', 'primary_link', 'motorway', 'motorway_link')
         ORDER BY priority ASC, length DESC)
         AS _

  - <<: *layer
    name: minor_road_labels
    id:   minor_road_labels
    properties:
      minzoom: 14
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (SELECT geometry,
                replace(name, ' ', '   ') AS name,
                highway,
                ST_Length(geometry) AS length,
                (CASE WHEN highway IN ('motorway', 'motorway_link') THEN 0
                      WHEN highway IN ('footpath', 'track', 'footway', 'steps', 'pedestrian', 'path', 'cycleway') THEN 1
                      WHEN railway IN ('rail', 'spur', 'subway', 'light_rail', 'tram', 'abandoned', 'disused', 'monorail') THEN 2
                      WHEN highway IN ('trunk', 'trunk_link', 'primary', 'primary_link') THEN 3
                      WHEN highway = 'secondary' THEN 4
                      WHEN highway = 'tertiary' THEN 5
                      ELSE 9 END) AS priority,
                (CASE WHEN highway IN ('secondary', 'trunk', 'trunk_link', 'primary', 'primary_link', 'motorway', 'motorway_link') THEN 'major_road'
                      WHEN highway IN ('residential', 'unclassified', 'service', 'minor', 'road', 'tertiary') THEN 'minor_road'
                      WHEN railway IN ('rail', 'spur', 'subway', 'light_rail', 'tram', 'abandoned', 'disused', 'monorail') THEN 'rail'
                      WHEN highway IN ('footpath', 'track', 'footway', 'steps', 'pedestrian', 'path', 'cycleway') THEN 'path'
                      ELSE '' END) AS kind,
                (CASE WHEN tunnel = 1 THEN 'yes'
                      ELSE 'no' END) AS is_tunnel,
                (CASE WHEN bridge = 1 THEN 'yes'
                      ELSE 'no' END) AS is_bridge
         FROM osm_roads
         WHERE geometry && !bbox!
           AND highway IN ('residential', 'unclassified', 'service', 'minor', 'road', 'tertiary')
         ORDER BY priority ASC, length DESC
         LIMIT 25)
         AS _

  # ---- Highway Shields ----------------------------------------------------
  - <<: *layer
    name: highway_shields
    id:   highway_shields
    properties:
      minzoom: 11
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
            ref,
            CHAR_LENGTH(ref) as ref_length,
            priority,
            highway,
            geometry
          FROM highway_shields
          WHERE geometry && !bbox!
        ) AS _

  - <<: *layer
    name: continents
    id:   continents
    properties:
      minzoom: 1
      maxzoom: 2
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: continents

# ---- Aries Places ----------------------------------------------------

  - <<: *layer
    name: aries-places-labels
    id:   aries-places-labels
    properties:
      minzoom: 4
      maxzoom: 16
    Datasource:
      <<: *postgis
      geometry_field: geometry
      table: >
        (
          SELECT
          name,
          zoom scalerank,
          population,
          geometry
          FROM aries
          WHERE geometry && !bbox!
          ORDER BY population DESC, name
        ) AS _

  - <<: *layer
    name: airports
    id:   airports
    properties:
      minzoom: 12
    Datasource:
      <<: *postgis
      geometry_field: geom
      table: ne_10m_airports