terrain-classic-labels.yml

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

name:             'Terrain Classic'
description:      ''
attribution:      'Map Data © OpenStreetMap'
center:           [0, 0, 2]
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:         2


# == 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-labels.mss


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

Layer:

# 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: 4
      maxzoom: 9
    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