meldingen_indicatoren.map

MAP
  NAME                      "meldingen_indicatoren"
  INCLUDE                   "header.inc"

  WEB
    METADATA
      "ows_title"           "Meldingen Indicatoren Buurt"
      "ows_abstract"        "Parkeerzones uitzonderingen Amsterdam"
      "wms_extent"          "100000 450000 150000 500000"
    END
  END

  LAYER
    NAME                    "aantal_meldingen"
    PROJECTION
      "init=epsg:28992"
    END

    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM 
    (select distinct indicatoren_buurt.gbd_buurt_id, indicatoren_buurt.gbd_buurt_naam, indicatoren_buurt.ind_noemer::int as totaal_meldingen, gebieden_buurten.geometrie 
    from indicatoren_buurt
    LEFT JOIN gebieden_buurten ON indicatoren_buurt.gbd_buurt_id = gebieden_buurten.identificatie 
    where indicatoren_buurt.ind_naam  like 'Aantal meldingen in het % jaar%'
    and indicatoren_buurt.ind_temp_jaar = extract(year from current_date)) 
    as subquery USING srid=28992 USING UNIQUE gbd_buurt_id"
    TYPE                    POLYGON

    METADATA
      "ows_title"           "Meldingen Indicatoren Buurt"
      "ows_abstract"        "Meldingen Indicatoren Buurt"
      "wms_enable_request"  "* !GetFeatureInfo"
    END

    LABELITEM               "totaal_meldingen"

    CLASS
      NAME          "Meldingen Indicatoren Buurt"


      STYLE
        RANGEITEM   "totaal_meldingen"
        COLORRANGE  "#e0f3db" "#43a2ca"
        DATARANGE   0.0 5000
        OPACITY     80
      END
      STYLE
        OUTLINECOLOR        "#a0a0a0"
        WIDTH             1
        OPACITY           80
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  6001
        COLOR          0 0 0
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-MI"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
      END

      LABEL
        MINSCALEDENOM  6001
        MAXSCALEDENOM  8001
        COLOR          0 0 0
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-MI"
        TYPE           truetype
        SIZE           8
        POSITION       AUTO
        PARTIALS       FALSE
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  6001
        TEXT          '[gbd_buurt_naam]'
        COLOR          0 0 0
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         0 -20
      END

      LABEL
        MINSCALEDENOM  6001
        MAXSCALEDENOM  8001
        TEXT          '[gbd_buurt_naam]'
        COLOR          0 0 0
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           8
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         0 -20
      END
    END
  END
END