huishoudelijkafvalv2.map

#==============================================================================
#
# afval.map
# doel: serveren afval-containers en well locaties
#
# 165,0,38
# 215,48,39
# 244,109,67
# 253,174,97
# 254,224,139
# 217,239,139
# 166,217,106
# 102,189,99
# 26,152,80
# 0,104,55
#==============================================================================


MAP
  NAME                      "containers"
  INCLUDE                   "header.inc"
  DEBUG 5

  WEB
    METADATA
      "ows_title"           "afvalcontainers"
      "ows_abstract"        "Afvalcontainers Amsterdam"
      "ows_srs"             "EPSG:4326 EPSG:3857 EPSG:28992"
      "wms_extent"          "4.58565 52.03560  5.31360 52.48769"
      "wfs_extent"          "4.58565 52.03560  5.31360 52.48769"
      "gml_types"           "auto"
    END
  END

  LEGEND
    STATUS ON
    KEYSIZE 30 30
  END

  #-----------------------------------------------------------------------------


  LAYER
    NAME                    "gft_coordinaten"
    GROUP                   "afvalcontainers"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM public.huishoudelijkafval_container USING srid=28992 USING UNIQUE id"
    FILTER                  ([fractie_omschrijving] = 'GFT' AND [status] = 1)
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "gfe"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Afvalcontainer coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Gftafvalcontainer"
      "wms_enable_request"  "*"
      "wms_group_title"     "afvalcontainers"
      "wms_abstract"        "Afvalcontainer coordinaten Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "afvalcontainers_coordinaten"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id_nummer"

    CLASS
      NAME                  "Gftcontainer"
      STYLE
        SIZE                30
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'gfe'
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  4000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END


  #-----------------------------------------------------------------------------

  LAYER
    NAME                    "textiel_coordinaten"
    GROUP                   "afvalcontainers"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM public.huishoudelijkafval_container USING srid=28992 USING UNIQUE id"
    FILTER                  ([fractie_omschrijving] = 'Textiel' AND [status] = 1)
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "textiel"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Afvalcontainer coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Textielafvalcontainer"
      "wms_enable_request"  "*"
      "wms_group_title"     "afvalcontainers"
      "wms_abstract"        "Afvalcontainer coordinaten Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "afvalcontainers_coordinaten"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id_nummer"

    CLASS
      NAME                  "Textielcontainer"
      STYLE
        SIZE                30
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'textiel'
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  4000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END


  #-----------------------------------------------------------------------------

  LAYER
    NAME                    "papier_coordinaten"
    GROUP                   "afvalcontainers"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM public.huishoudelijkafval_container USING srid=28992 USING UNIQUE id"
    FILTER                  ([fractie_omschrijving] = 'Papier' AND [status] = 1)
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "papier"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Afvalcontainer coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Papierafvalcontainer"
      "wms_enable_request"  "*"
      "wms_group_title"     "afvalcontainers"
      "wms_abstract"        "Afvalcontainer coordinaten Amsterdam"
      "wms_srs"             "EPSG:28992"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_name"            "afvalcontainers_coordinaten"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id_nummer"

    CLASS
      NAME                  "Papiercontainer"
      STYLE
        SIZE                30
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'papier'
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  4000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END

  #-----------------------------------------------------------------------------

  LAYER
    NAME                    "glas_coordinaten"
    GROUP                   "afvalcontainers"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM public.huishoudelijkafval_container USING srid=28992 USING UNIQUE id"
    FILTER                  ([fractie_omschrijving] = 'Glas' AND [status] = 1)
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "glas"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Rest container coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Glasafvalcontainer"
      "wms_enable_request"  "*"
      "wms_group_title"     "afvalcontainers"
      "wms_abstract"        "Glas container coordinaten Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "afvalcontainers_coordinaten"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id_nummer"

    CLASS
      NAME                  "Glascontainer"
      STYLE
        SIZE                30
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'glas'
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  4000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
       POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END


  #-----------------------------------------------------------------------------

  LAYER
    NAME                    "rest_coordinaten"
    GROUP                   "afvalcontainers"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM public.huishoudelijkafval_container USING srid=28992 USING UNIQUE id"
    FILTER                  ([fractie_omschrijving] = 'Rest' AND [status] = 1)
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "rest"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Rest container coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Restafvalcontainer"
      "wms_enable_request"  "*"
      "wms_group_title"     "afvalcontainers"
      "wms_abstract"        "Afvalcontainer coordinaten Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "afvalcontainers_coordinaten"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id_nummer"

    CLASS
      NAME                  "Restcontainer"
      STYLE
        SIZE                30
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'rest'
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  4000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END
  
  #-----------------------------------------------------------------------------

  LAYER
    NAME                    "brood_coordinaten"
    GROUP                   "afvalcontainers"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM public.huishoudelijkafval_container USING srid=28992 USING UNIQUE id"
    FILTER                  ([fractie_omschrijving] = 'Brood' AND [status] = 1)
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "brood"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Afvalcontainer coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Broodafvalcontainer"
      "wms_enable_request"  "*"
      "wms_group_title"     "afvalcontainers"
      "wms_abstract"        "Afvalcontainer coordinaten Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "afvalcontainers_coordinaten"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id_nummer"

    CLASS
      NAME                  "Broodcontainer"
      STYLE
        SIZE                30
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'brood'
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  4000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END

#-----------------------------------------------------------------------------

  LAYER
    NAME                    "onbekend_coordinaten"
    GROUP                   "afvalcontainers"
    INCLUDE                 "connection/dataservices.inc"
                            #Bij deze is een subquery gebruikt ipv filter omdat NULL niet als filter geldt binnen mapserver, alleen in subquery.
    DATA                    "geometrie FROM (select * FROM public.huishoudelijkafval_container where fractie_omschrijving is null and status = 1) as subquery USING srid=28992 USING UNIQUE id"
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "onbekend"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Afvalcontainer coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Onbekend"
      "wms_enable_request"  "*"
      "wms_group_title"     "afvalcontainers"
      "wms_abstract"        "Afvalcontainer coordinaten Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "afvalcontainers_coordinaten"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id_nummer"

    CLASS
      NAME                  "Onbekendcontainer"
      STYLE
        SIZE                30
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'onbekend'
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  4000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END
  
  #-----------------------------------------------------------------------------

  LAYER
    NAME                    "wegingen_rest"
    GROUP                   "kilogram"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM (
                                select * from
                                public.huishoudelijkafval_weging
                                where fractie_omschrijving = 'Rest'
                                AND datum_weging > (NOW() - INTERVAL '6 months')
                                ORDER BY datum_weging desc
                              ) as subquery USING srid=28992 USING UNIQUE id"
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "Rest kilogram wegingen"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Weging coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "rest_wegingen"
      "wms_enable_request"  "*"
      "wms_group_title"     "kilogram"
      "wms_abstract"        "Rest Wegingen Amsterdam"
      "wms_srs"             "EPSG:28992"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_name"            "Kilogram"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "< 50 kg"
      EXPRESSION ([netto_gewicht] < 50)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               0 104 55
      END
    END

    CLASS
      NAME                  "< 90 kg"
      EXPRESSION ([netto_gewicht] < 90)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               26 152 80
      END
    END

    CLASS
      NAME                  "< 130 kg"
      EXPRESSION ([netto_gewicht] < 130)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               102 189 99
      END
    END

    CLASS
      NAME                  "< 170 m"
      EXPRESSION ([netto_gewicht] < 170)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               166 217 106
      END
    END

    CLASS
      NAME                  "< 210 kg"
      EXPRESSION ([netto_gewicht] < 210)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               217 239 139
      END
    END

    CLASS
      NAME                  "< 260 kg"
      EXPRESSION ([netto_gewicht] < 260)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               254 224 139
      END
    END

    CLASS
      NAME                  "< 310 kg"
      EXPRESSION ([netto_gewicht] < 310)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               253 174 97
      END
    END

    CLASS
      NAME                  "< 390 kg"
      EXPRESSION ([netto_gewicht] < 390)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               244 109 67
      END
    END

    CLASS
      NAME                  "< 500 kg"
      EXPRESSION ([netto_gewicht] < 500)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               215 48 39
      END
    END

    CLASS
      NAME                  "> 500 kg"
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               165 0 38
      END
    END

    CLASS
      NAME                  "Weging"
      STYLE
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'stip'
        COLOR               255 255 255
        SIZE                8
        OUTLINECOLOR        0 0 0
        WIDTH               1
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END

#------------------------------------------------------------------------

  LAYER
    NAME                    "wegingen_glas"
    GROUP                   "kilogram"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM (
                                select * from
                                public.huishoudelijkafval_weging
                                where fractie_omschrijving = 'Glas'
                                AND datum_weging > (NOW() - INTERVAL '6 months')
                                ORDER BY datum_weging desc
				) as subquery USING srid=28992 USING UNIQUE id"
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "glas wegingen"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Weging coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "glas_wegingen"
      "wms_enable_request"  "*"
      "wms_group_title"     "kilogram"
      "wms_abstract"        "Glas Wegingen Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Kilogram"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "< 50 kg"
      EXPRESSION ([netto_gewicht] < 50)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               0 104 55
      END
    END

    CLASS
      NAME                  "< 90 kg"
      EXPRESSION ([netto_gewicht] < 90)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               26 152 80
      END
    END

    CLASS
      NAME                  "< 130 kg"
      EXPRESSION ([netto_gewicht] < 130)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               102 189 99
      END
    END

    CLASS
      NAME                  "< 170 m"
      EXPRESSION ([netto_gewicht] < 170)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               166 217 106
      END
    END

    CLASS
      NAME                  "< 210 kg"
      EXPRESSION ([netto_gewicht] < 210)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               217 239 139
      END
    END

    CLASS
      NAME                  "< 260 kg"
      EXPRESSION ([netto_gewicht] < 260)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               254 224 139
      END
    END

    CLASS
      NAME                  "< 310 kg"
      EXPRESSION ([netto_gewicht] < 310)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               253 174 97
      END
    END

    CLASS
      NAME                  "< 390 kg"
      EXPRESSION ([netto_gewicht] < 390)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               244 109 67
      END
    END

    CLASS
      NAME                  "< 500 kg"
      EXPRESSION ([netto_gewicht] < 500)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               215 48 39
      END
    END

    CLASS
      NAME                  "> 500 kg"
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               165 0 38
      END
    END

    CLASS
      NAME                  "Weging"
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'stip'
        COLOR               255 255 255
        SIZE                8
        OUTLINECOLOR        0 0 0
        WIDTH               1
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END

#-------------------------------------------------------

  LAYER
    NAME                    "wegingen_papier"
    GROUP                   "kilogram"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM (
    			                      select * from
                                public.huishoudelijkafval_weging
                                where fractie_omschrijving = 'Papier'
                                AND datum_weging > (NOW() - INTERVAL '6 months')
                                ORDER BY datum_weging desc
				) as subquery USING srid=28992 USING UNIQUE id"
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "kilogram wegingen_papier"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Weging coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "papier_wegingen"
      "wms_enable_request"  "*"
      "wms_group_title"     "kilogram"
      "wms_abstract"        "Papier Wegingen Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Kilogram"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "< 50 kg"
      EXPRESSION ([netto_gewicht] < 50)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               0 104 55
      END
    END

    CLASS
      NAME                  "< 90 kg"
      EXPRESSION ([netto_gewicht] < 90)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               26 152 80
      END
    END

    CLASS
      NAME                  "< 130 kg"
      EXPRESSION ([netto_gewicht] < 130)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               102 189 99
      END
    END

    CLASS
      NAME                  "< 170 m"
      EXPRESSION ([netto_gewicht] < 170)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               166 217 106
      END
    END

    CLASS
      NAME                  "< 210 kg"
      EXPRESSION ([netto_gewicht] < 210)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               217 239 139
      END
    END

    CLASS
      NAME                  "< 260 kg"
      EXPRESSION ([netto_gewicht] < 260)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               254 224 139
      END
    END

    CLASS
      NAME                  "< 310 kg"
      EXPRESSION ([netto_gewicht] < 310)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               253 174 97
      END
    END

    CLASS
      NAME                  "< 390 kg"
      EXPRESSION ([netto_gewicht] < 390)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               244 109 67
      END
    END

    CLASS
      NAME                  "< 500 kg"
      EXPRESSION ([netto_gewicht] < 500)
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               215 48 39
      END
    END

    CLASS
      NAME                  "> 500 kg"
      STYLE
        SYMBOL              'stip'
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               165 0 38
      END
    END

    CLASS
      NAME                  "Weging"
      STYLE
        SIZE                6
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'stip'
        COLOR               255 255 255
        SIZE                8
        OUTLINECOLOR        0 0 0
        WIDTH               1
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END
#------------------------------------------------------------------------
  LAYER
    NAME                    "wegingen_plastic"
    GROUP                   "kilogram"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM (
                               select * from
                                public.huishoudelijkafval_weging
                                where fractie_omschrijving = 'Plastic'
                                AND datum_weging > (NOW() - INTERVAL '6 months')
                                ORDER BY datum_weging desc
				) as subquery USING srid=28992 USING UNIQUE id"
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "wegingen_plastic"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Weging coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "plastic_wegingen"
      "wms_enable_request"  "*"
      "wms_group_title"     "kilogram"
      "wms_abstract"        "Plastic Wegingen Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Kilogram"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "< 50 kg"
      EXPRESSION ([netto_gewicht] < 50)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               0 104 55
      END
    END

    CLASS
      NAME                  "< 90 kg"
      EXPRESSION ([netto_gewicht] < 90)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               26 152 80
      END
    END

    CLASS
      NAME                  "< 130 kg"
      EXPRESSION ([netto_gewicht] < 130)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               102 189 99
      END
    END

    CLASS
      NAME                  "< 170 m"
      EXPRESSION ([netto_gewicht] < 170)
      STYLE
        SYMBOL              'stip'
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               166 217 106
      END
    END

    CLASS
      NAME                  "< 210 kg"
      EXPRESSION ([netto_gewicht] < 210)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               217 239 139
      END
    END

    CLASS
      NAME                  "< 260 kg"
      EXPRESSION ([netto_gewicht] < 260)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               254 224 139
      END
    END

    CLASS
      NAME                  "< 310 kg"
      EXPRESSION ([netto_gewicht] < 310)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               253 174 97
      END
    END

    CLASS
      NAME                  "< 390 kg"
      EXPRESSION ([netto_gewicht] < 390)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               244 109 67
      END
    END

    CLASS
      NAME                  "< 500 kg"
      EXPRESSION ([netto_gewicht] < 500)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               215 48 39
      END
    END

    CLASS
      NAME                  "> 500 kg"
      STYLE
        MINSCALEDENOM       10
        SYMBOL              'stip'
        SIZE                4
        MAXSCALEDENOM       500001
        COLOR               165 0 38
      END
    END

    CLASS
      NAME                  "Weging"
      STYLE
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'stip'
        COLOR               255 255 255
        SIZE                8
        OUTLINECOLOR        0 0 0
        WIDTH               1
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END

#---------------------------------------------------------------

  LAYER
    NAME                    "wegingen_textiel"
    GROUP                   "kilogram"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM (
    			                      select * from
                                public.huishoudelijkafval_weging
                                where fractie_omschrijving = 'Textiel'
                                AND datum_weging > (NOW() - INTERVAL '6 months')
                                ORDER BY datum_weging desc
				) as subquery USING srid=28992 USING UNIQUE id"
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "Textiel kilogram wegingen"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Weging coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "textiel_wegingen"
      "wms_enable_request"  "*"
      "wms_group_title"     "kilogram"
      "wms_abstract"        "Textiel Wegingen Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Kilogram"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "< 50 kg"
      EXPRESSION ([netto_gewicht] < 50)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               0 104 55
      END
    END

    CLASS
      NAME                  "< 90 kg"
      EXPRESSION ([netto_gewicht] < 90)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               26 152 80
      END
    END

    CLASS
      NAME                  "< 130 kg"
      EXPRESSION ([netto_gewicht] < 130)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               102 189 99
      END
    END

    CLASS
      NAME                  "< 170 m"
      EXPRESSION ([netto_gewicht] < 170)
      STYLE
        SYMBOL              'stip'
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               166 217 106
      END
    END

    CLASS
      NAME                  "< 210 kg"
      EXPRESSION ([netto_gewicht] < 210)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               217 239 139
      END
    END

    CLASS
      NAME                  "< 260 kg"
      EXPRESSION ([netto_gewicht] < 260)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               254 224 139
      END
    END

    CLASS
      NAME                  "< 310 kg"
      EXPRESSION ([netto_gewicht] < 310)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               253 174 97
      END
    END

    CLASS
      NAME                  "< 390 kg"
      EXPRESSION ([netto_gewicht] < 390)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               244 109 67
      END
    END

    CLASS
      NAME                  "< 500 kg"
      EXPRESSION ([netto_gewicht] < 500)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               215 48 39
      END
    END

    CLASS
      NAME                  "> 500 kg"
      STYLE
        MINSCALEDENOM       10
        SYMBOL              'stip'
        SIZE                4
        MAXSCALEDENOM       500001
        COLOR               165 0 38
      END
    END

    CLASS
      NAME                  "Weging"
      STYLE
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'stip'
        COLOR               255 255 255
        SIZE                8
        OUTLINECOLOR        0 0 0
        WIDTH               1
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END

#---------------------------------------------------------------

  LAYER
    NAME                    "wegingen_grof"
    GROUP                   "kilogram"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM (
    			                      select * from
                                public.huishoudelijkafval_weging
                                where fractie_omschrijving = 'Grof'
                                AND datum_weging > (NOW() - INTERVAL '6 months')
                                ORDER BY datum_weging desc
				) as subquery USING srid=28992 USING UNIQUE id"
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "Grof kilogram wegingen"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Weging coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "grof_wegingen"
      "wms_enable_request"  "*"
      "wms_group_title"     "kilogram"
      "wms_abstract"        "Grof Wegingen Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Kilogram"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "< 50 kg"
      EXPRESSION ([netto_gewicht] < 50)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               0 104 55
      END
    END

    CLASS
      NAME                  "< 90 kg"
      EXPRESSION ([netto_gewicht] < 90)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               26 152 80
      END
    END

    CLASS
      NAME                  "< 130 kg"
      EXPRESSION ([netto_gewicht] < 130)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               102 189 99
      END
    END

    CLASS
      NAME                  "< 170 m"
      EXPRESSION ([netto_gewicht] < 170)
      STYLE
        SYMBOL              'stip'
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               166 217 106
      END
    END

    CLASS
      NAME                  "< 210 kg"
      EXPRESSION ([netto_gewicht] < 210)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               217 239 139
      END
    END

    CLASS
      NAME                  "< 260 kg"
      EXPRESSION ([netto_gewicht] < 260)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               254 224 139
      END
    END

    CLASS
      NAME                  "< 310 kg"
      EXPRESSION ([netto_gewicht] < 310)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               253 174 97
      END
    END

    CLASS
      NAME                  "< 390 kg"
      EXPRESSION ([netto_gewicht] < 390)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               244 109 67
      END
    END

    CLASS
      NAME                  "< 500 kg"
      EXPRESSION ([netto_gewicht] < 500)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               215 48 39
      END
    END

    CLASS
      NAME                  "> 500 kg"
      STYLE
        MINSCALEDENOM       10
        SYMBOL              'stip'
        SIZE                4
        MAXSCALEDENOM       500001
        COLOR               165 0 38
      END
    END

    CLASS
      NAME                  "Weging"
      STYLE
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'stip'
        COLOR               255 255 255
        SIZE                8
        OUTLINECOLOR        0 0 0
        WIDTH               1
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END

#---------------------------------------------------------------

  LAYER
    NAME                    "wegingen_PMD"
    GROUP                   "kilogram"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM (
    			                      select * from
                                public.huishoudelijkafval_weging
                                where fractie_omschrijving = 'PMD'
                                AND datum_weging > (NOW() - INTERVAL '6 months')
                                ORDER BY datum_weging desc
				) as subquery USING srid=28992 USING UNIQUE id"
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "PMD kilogram wegingen"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Weging coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "PMD_wegingen"
      "wms_enable_request"  "*"
      "wms_group_title"     "kilogram"
      "wms_abstract"        "PMD Wegingen Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Kilogram"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "< 50 kg"
      EXPRESSION ([netto_gewicht] < 50)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               0 104 55
      END
    END

    CLASS
      NAME                  "< 90 kg"
      EXPRESSION ([netto_gewicht] < 90)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               26 152 80
      END
    END

    CLASS
      NAME                  "< 130 kg"
      EXPRESSION ([netto_gewicht] < 130)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               102 189 99
      END
    END

    CLASS
      NAME                  "< 170 m"
      EXPRESSION ([netto_gewicht] < 170)
      STYLE
        SYMBOL              'stip'
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               166 217 106
      END
    END

    CLASS
      NAME                  "< 210 kg"
      EXPRESSION ([netto_gewicht] < 210)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               217 239 139
      END
    END

    CLASS
      NAME                  "< 260 kg"
      EXPRESSION ([netto_gewicht] < 260)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               254 224 139
      END
    END

    CLASS
      NAME                  "< 310 kg"
      EXPRESSION ([netto_gewicht] < 310)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               253 174 97
      END
    END

    CLASS
      NAME                  "< 390 kg"
      EXPRESSION ([netto_gewicht] < 390)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               244 109 67
      END
    END

    CLASS
      NAME                  "< 500 kg"
      EXPRESSION ([netto_gewicht] < 500)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               215 48 39
      END
    END

    CLASS
      NAME                  "> 500 kg"
      STYLE
        MINSCALEDENOM       10
        SYMBOL              'stip'
        SIZE                4
        MAXSCALEDENOM       500001
        COLOR               165 0 38
      END
    END

    CLASS
      NAME                  "Weging"
      STYLE
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'stip'
        COLOR               255 255 255
        SIZE                8
        OUTLINECOLOR        0 0 0
        WIDTH               1
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END


#---------------------------------------------------------------

  LAYER
    NAME                    "wegingen_brood"
    GROUP                   "kilogram"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM (
    			                      select * from
                                public.huishoudelijkafval_weging
                                where fractie_omschrijving = 'Brood'
                                AND datum_weging > (NOW() - INTERVAL '6 months')
                                ORDER BY datum_weging desc
				) as subquery USING srid=28992 USING UNIQUE id"
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "Brood kilogram wegingen"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Weging coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "brood_wegingen"
      "wms_enable_request"  "*"
      "wms_group_title"     "kilogram"
      "wms_abstract"        "Brood Wegingen Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Kilogram"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "< 50 kg"
      EXPRESSION ([netto_gewicht] < 50)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               0 104 55
      END
    END

    CLASS
      NAME                  "< 90 kg"
      EXPRESSION ([netto_gewicht] < 90)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               26 152 80
      END
    END

    CLASS
      NAME                  "< 130 kg"
      EXPRESSION ([netto_gewicht] < 130)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               102 189 99
      END
    END

    CLASS
      NAME                  "< 170 m"
      EXPRESSION ([netto_gewicht] < 170)
      STYLE
        SYMBOL              'stip'
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               166 217 106
      END
    END

    CLASS
      NAME                  "< 210 kg"
      EXPRESSION ([netto_gewicht] < 210)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               217 239 139
      END
    END

    CLASS
      NAME                  "< 260 kg"
      EXPRESSION ([netto_gewicht] < 260)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               254 224 139
      END
    END

    CLASS
      NAME                  "< 310 kg"
      EXPRESSION ([netto_gewicht] < 310)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               253 174 97
      END
    END

    CLASS
      NAME                  "< 390 kg"
      EXPRESSION ([netto_gewicht] < 390)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               244 109 67
      END
    END

    CLASS
      NAME                  "< 500 kg"
      EXPRESSION ([netto_gewicht] < 500)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               215 48 39
      END
    END

    CLASS
      NAME                  "> 500 kg"
      STYLE
        MINSCALEDENOM       10
        SYMBOL              'stip'
        SIZE                4
        MAXSCALEDENOM       500001
        COLOR               165 0 38
      END
    END

    CLASS
      NAME                  "Weging"
      STYLE
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'stip'
        COLOR               255 255 255
        SIZE                8
        OUTLINECOLOR        0 0 0
        WIDTH               1
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END


#---------------------------------------------------------------

  LAYER
    NAME                    "wegingen_onbekend"
    GROUP                   "kilogram"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM (
    			                      select * from
                                public.huishoudelijkafval_weging
                                where fractie_omschrijving is null
                                AND datum_weging > (NOW() - INTERVAL '6 months')
                                ORDER BY datum_weging desc
				) as subquery USING srid=28992 USING UNIQUE id"
    TYPE                    POINT
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "onbekend kilogram wegingen"
      "wfs_srs"             "EPSG:28992"
      "wfs_adstract"        "Weging coordinaten Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "onbekend_wegingen"
      "wms_enable_request"  "*"
      "wms_group_title"     "kilogram"
      "wms_abstract"        "onbekend Wegingen Amsterdam"
      "wms_extent"			    "100000 450000 150000 500000"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Kilogram"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "< 50 kg"
      EXPRESSION ([netto_gewicht] < 50)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               0 104 55
      END
    END

    CLASS
      NAME                  "< 90 kg"
      EXPRESSION ([netto_gewicht] < 90)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        COLOR               26 152 80
      END
    END

    CLASS
      NAME                  "< 130 kg"
      EXPRESSION ([netto_gewicht] < 130)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               102 189 99
      END
    END

    CLASS
      NAME                  "< 170 m"
      EXPRESSION ([netto_gewicht] < 170)
      STYLE
        SYMBOL              'stip'
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               166 217 106
      END
    END

    CLASS
      NAME                  "< 210 kg"
      EXPRESSION ([netto_gewicht] < 210)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               217 239 139
      END
    END

    CLASS
      NAME                  "< 260 kg"
      EXPRESSION ([netto_gewicht] < 260)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               254 224 139
      END
    END

    CLASS
      NAME                  "< 310 kg"
      EXPRESSION ([netto_gewicht] < 310)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               253 174 97
      END
    END

    CLASS
      NAME                  "< 390 kg"
      EXPRESSION ([netto_gewicht] < 390)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               244 109 67
      END
    END

    CLASS
      NAME                  "< 500 kg"
      EXPRESSION ([netto_gewicht] < 500)
      STYLE
        SYMBOL              'stip'
        SIZE                4
        MINSCALEDENOM       10
        MAXSCALEDENOM       50001
        COLOR               215 48 39
      END
    END

    CLASS
      NAME                  "> 500 kg"
      STYLE
        MINSCALEDENOM       10
        SYMBOL              'stip'
        SIZE                4
        MAXSCALEDENOM       500001
        COLOR               165 0 38
      END
    END

    CLASS
      NAME                  "Weging"
      STYLE
        MINSCALEDENOM       10
        MAXSCALEDENOM       500001
        SYMBOL              'stip'
        COLOR               255 255 255
        SIZE                8
        OUTLINECOLOR        0 0 0
        WIDTH               1
      END

      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1000
        COLOR          102 102 102
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
        OFFSET         -60 10
      END

    END
  END

#-----------------------------------------------------------------------------

  LAYER
    NAME                    "pand loopafstand rest"
    GROUP                   "pand_loopafstand"
    INCLUDE                 "connection/dataservices.inc"
    #where 1=1 weghalen
    DATA                    "geometrie FROM ( 
                            SELECT bol.id
                            , bol.geometrie
                            , lac.loopafstand_categorie_omschrijving
                            FROM public.huishoudelijkafval_bag_object_loopafstand_v2 bol
                            INNER JOIN public.huishoudelijkafval_loopafstand_categorie_v2 lac
                            ON bol.loopafstand_categorie_id = lac.id
                            
                            WHERE 1=1 
                            AND bol.fractie_omschrijving = 'Rest'
                            ) rest USING srid=28992 USING UNIQUE id"
    TYPE                    POLYGON
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "pand loopafstand tot dichtsbijzijnde container in meters"
      "wfs_srs"             "EPSG:28992"
      "wfs_abstract"        "pand loopafstand tot dichtsbijzijnde container in meters"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Loopafstand tot restafvalcontainer"
      "wms_enable_request"  "*"
      "wms_group_title"     "loopafstand (per pand)"
      "wms_abstract"        "pand loopafstand tot dichtsbijzijnde container in meters"
      "wms_srs"             "EPSG:28992"
      #"wms_extent"			"100000 450000 150000 500000"
      "wms_name"            "Rest container"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

      CLASS
      NAME                  "<= 30 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "0 - 30 M")
      STYLE
            ANTIALIAS    true
            COLOR        50 114 48
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "30 - 90 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "30 - 90 M")
      STYLE
            ANTIALIAS    true
            COLOR        77 175 74
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "90 - 120 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "90 - 120 M")
      STYLE
            ANTIALIAS    true
            COLOR        157 175 157
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "120 - 150 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "120 - 150 M")
      STYLE
            ANTIALIAS    true
            COLOR        255 127 0
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  128 62 0
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "150 - 210 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "150 - 210 M")
      STYLE
            ANTIALIAS    true
            COLOR        255 75 0
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  209 59 0
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "210 - 1000 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "210 - 1000 M")
      STYLE
            ANTIALIAS    true
            COLOR        110 110 110
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  200 200 200
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "vanaf 1000 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "meer dan 1000 M")
      STYLE
        ANTIALIAS    true
        COLOR        204 204 204
        OPACITY      100
    END
    STYLE
        OUTLINECOLOR  194 194 194
        OPACITY      100
        WIDTH        1
    END
    END

  END

  #-----------------------------------------------------------------------------

  LAYER
    NAME                    "pand loopafstand papier"
    GROUP                   "pand_loopafstand"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM ( 
                            SELECT bol.id
                            , bol.geometrie
                            , lac.loopafstand_categorie_omschrijving
                            FROM public.huishoudelijkafval_bag_object_loopafstand_v2 bol
                            INNER JOIN public.huishoudelijkafval_loopafstand_categorie_v2 lac
                            ON bol.loopafstand_categorie_id = lac.id
                            WHERE 1=1 
                            AND bol.fractie_omschrijving = 'Papier'
                            ) rest USING srid=28992 USING UNIQUE id"
    TYPE                    POLYGON
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "pand loopafstand tot dichtsbijzijnde container in meters"
      "wfs_srs"             "EPSG:28992"
      "wfs_abstract"        "pand loopafstand tot dichtsbijzijnde container in meters"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Loopafstand tot papierafvalcontainer"
      "wms_enable_request"  "*"
      #"wms_extent"			"100000 450000 150000 500000"
      "wms_group_title"     "loopafstand (per pand)"
      "wms_abstract"        "pand loopafstand tot dichtsbijzijnde container in meters"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Papier container"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "<= 30 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "0 - 30 M")
      STYLE
            ANTIALIAS    true
            COLOR        50 114 48
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "30 - 90 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "30 - 90 M")
      STYLE
            ANTIALIAS    true
            COLOR        77 175 74
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "90 - 120 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "90 - 120 M")
      STYLE
            ANTIALIAS    true
            COLOR        157 175 157
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "120 - 150 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "120 - 150 M")
      STYLE
            ANTIALIAS    true
            COLOR        255 127 0
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  128 62 0
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "150 - 210 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "150 - 210 M")
      STYLE
            ANTIALIAS    true
            COLOR        255 75 0
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  209 59 0
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "210 - 1000 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "210 - 1000 M")
      STYLE
            ANTIALIAS    true
            COLOR        110 110 110
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  200 200 200
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "vanaf 1000 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "meer dan 1000 M")
      STYLE
        ANTIALIAS    true
        COLOR        204 204 204
        OPACITY      100
    END
    STYLE
        OUTLINECOLOR  194 194 194
        OPACITY      100
        WIDTH        1
    END
    END

  END

  #-----------------------------------------------------------------------------

  LAYER
    NAME                    "pand loopafstand glas"
    GROUP                   "pand_loopafstand"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM ( 
                            SELECT bol.id
                            , bol.geometrie
                            , lac.loopafstand_categorie_omschrijving
                            FROM public.huishoudelijkafval_bag_object_loopafstand_v2 bol
                            INNER JOIN public.huishoudelijkafval_loopafstand_categorie_v2 lac
                            ON bol.loopafstand_categorie_id = lac.id
                            WHERE 1=1 
                            AND bol.fractie_omschrijving = 'Glas'
                            ) rest USING srid=28992 USING UNIQUE id"
    TYPE                    POLYGON
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "pand loopafstand tot dichtsbijzijnde container in meters"
      "wfs_srs"             "EPSG:28992"
      "wfs_abstract"        "pand loopafstand tot dichtsbijzijnde container in meters"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Loopafstand tot glasafvalcontainer"
      "wms_enable_request"  "*"
      #"wms_extent"					"100000 450000 150000 500000"
      "wms_group_title"     "loopafstand (per pand)"
      "wms_abstract"        "pand loopafstand tot dichtsbijzijnde container in meters"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Glas container"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

    CLASS
      NAME                  "<= 30 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "0 - 30 M")
      STYLE
            ANTIALIAS    true
            COLOR        50 114 48
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "30 - 90 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "30 - 90 M")
      STYLE
            ANTIALIAS    true
            COLOR        77 175 74
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "90 - 120 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "90 - 120 M")
      STYLE
            ANTIALIAS    true
            COLOR        157 175 157
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "120 - 150 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "120 - 150 M")
      STYLE
            ANTIALIAS    true
            COLOR        255 127 0
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  128 62 0
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "150 - 210 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "150 - 210 M")
      STYLE
            ANTIALIAS    true
            COLOR        255 75 0
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  209 59 0
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "210 - 1000 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "210 - 1000 M")
      STYLE
            ANTIALIAS    true
            COLOR        110 110 110
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  200 200 200
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "vanaf 1000 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "meer dan 1000 M")
      STYLE
        ANTIALIAS    true
        COLOR        204 204 204
        OPACITY      100
    END
    STYLE
        OUTLINECOLOR  194 194 194
        OPACITY      100
        WIDTH        1
    END
    END
  END

 #-----------------------------------------------------------------------------

  LAYER
    NAME                    "pand loopafstand GFT"
    GROUP                   "pand_loopafstand"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM ( 
                            SELECT bol.id
                            , bol.geometrie
                            , lac.loopafstand_categorie_omschrijving
                            FROM public.huishoudelijkafval_bag_object_loopafstand_v2 bol
                            INNER JOIN public.huishoudelijkafval_loopafstand_categorie_v2 lac
                            ON bol.loopafstand_categorie_id = lac.id
                            WHERE 1=1 
                            AND bol.fractie_omschrijving = 'GFT'
                            ) rest USING srid=28992 USING UNIQUE id"
    TYPE                    POLYGON
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "pand loopafstand tot dichtsbijzijnde container in meters"
      "wfs_srs"             "EPSG:28992"
      "wfs_abstract"        "pand loopafstand tot dichtsbijzijnde container in meters"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Loopafstand tot gftafvalcontainer"
      "wms_enable_request"  "*"
      #"wms_extent"			"100000 450000 150000 500000"
      "wms_group_title"     "loopafstand (per pand)"
      "wms_abstract"        "pand loopafstand tot dichtsbijzijnde container in meters"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "GFT container"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

      CLASS
      NAME                  "<= 30 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "0 - 30 M")
      STYLE
            ANTIALIAS    true
            COLOR        50 114 48
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "30 - 90 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "30 - 90 M")
      STYLE
            ANTIALIAS    true
            COLOR        77 175 74
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "90 - 120 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "90 - 120 M")
      STYLE
            ANTIALIAS    true
            COLOR        157 175 157
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "120 - 150 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "120 - 150 M")
      STYLE
            ANTIALIAS    true
            COLOR        255 127 0
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  128 62 0
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "150 - 210 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "150 - 210 M")
      STYLE
            ANTIALIAS    true
            COLOR        255 75 0
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  209 59 0
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "210 - 1000 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "210 - 1000 M")
      STYLE
            ANTIALIAS    true
            COLOR        110 110 110
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  200 200 200
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "vanaf 1000 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "meer dan 1000 M")
      STYLE
        ANTIALIAS    true
        COLOR        204 204 204
        OPACITY      100
    END
    STYLE
        OUTLINECOLOR  194 194 194
        OPACITY      100
        WIDTH        1
    END
    END

  END

#-----------------------------------------------------------------------------

  LAYER
    NAME                    "pand loopafstand textiel"
    GROUP                   "pand_loopafstand"
    INCLUDE                 "connection/dataservices.inc"
    DATA                    "geometrie FROM ( 
                            SELECT bol.id
                            , bol.geometrie
                            , lac.loopafstand_categorie_omschrijving
                            FROM public.huishoudelijkafval_bag_object_loopafstand_v2 bol
                            INNER JOIN public.huishoudelijkafval_loopafstand_categorie_v2 lac
                            ON bol.loopafstand_categorie_id = lac.id
                            WHERE 1=1 
                            AND bol.fractie_omschrijving = 'Textiel'
                            ) rest USING srid=28992 USING UNIQUE id"
    TYPE                    POLYGON
    MINSCALEDENOM           10
    MAXSCALEDENOM           400000

    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "wfs_title"           "pand loopafstand tot dichtsbijzijnde container in meters"
      "wfs_srs"             "EPSG:28992"
      "wfs_abstract"        "pand loopafstand tot dichtsbijzijnde container in meters"
      "wfs_enable_request"  "*"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
      "gml_types"           "auto"
      "wms_title"           "Loopafstand tot textielafvalcontainer"
      "wms_enable_request"  "*"
      "wms_extent"			"100000 450000 150000 500000"
      "wms_group_title"     "loopafstand (per pand)"
      "wms_abstract"        "pand loopafstand tot dichtsbijzijnde container in meters"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "Textiel container"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
    END

    LABELITEM               "id"

      CLASS
      NAME                  "<= 90 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "0 - 90 M")
      STYLE
            ANTIALIAS    true
            COLOR        50 114 48
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "90 - 180 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "90 - 180 M")
      STYLE
            ANTIALIAS    true
            COLOR        77 175 74
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "180 - 350 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "180 - 350 M")
      STYLE
            ANTIALIAS    true
            COLOR        157 175 157
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  56 128 54
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "350 - 370 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "350 - 370 M")
      STYLE
            ANTIALIAS    true
            COLOR        253 191 111         
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR 253 170 111
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "370 - 480 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "370 - 480 M")
      STYLE
            ANTIALIAS    true
            COLOR        255 75 0
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  209 59 0
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "480 - 1500 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "480 - 1500 M")
      STYLE
            ANTIALIAS    true
            COLOR        110 110 110
            OPACITY      100
        END
        STYLE
            OUTLINECOLOR  200 200 200
            OPACITY      100
            WIDTH        1
        END
    END

    CLASS
      NAME                  "vanaf 1500 m"
      EXPRESSION ("[loopafstand_categorie_omschrijving]" eq "Vanaf 1500 M")
      STYLE
        ANTIALIAS    true
        COLOR        204 204 204
        OPACITY      100
    END
    STYLE
        OUTLINECOLOR  194 194 194
        OPACITY      100
        WIDTH        1
    END
    END

  END

END