parkeervakken.map

#==============================================================================
#
# parkeervakken.map
# doel: serveren van parkeervakken en reserveringen
#
#==============================================================================
#
# naam                  datum         wijziging
# ------------------    ----------    -----------------------------------------
# Stephan Preeker       1-4-2014      schepping
#
#==============================================================================

MAP
  NAME "PARKEERVAKKEN"
  INCLUDE "header.inc"


  WEB
    METADATA
      "ows_title"    "PARKEERVAKKEN"
      "ows_abstract" "Parkeervakken met een geografische component, waarvan Amsterdam de bronhouder is"
    END
  END

  #=============================================================================
  # LAYERS PARKEERVAKKEN REGIMES
  # doel: tonen van 4 typen parkeervakken (de regimes: taxistandplaats, laden&lossen, kiss&ride en vrachtwagens) op basis van 4 standaardtijdvakken:
  #   00:00 - 06:59
  #   07:00 - 17:00
  #   17.01 - 23.59
  #   00:00 - 23:59
  # bijzonderheden: per locatie, afhankelijk van een tijdsperiode, kan een parkeervak een bepaald regime aannemen.
  #                 Bijvoorbeeld Osdorplein is van 00:00 t/m 07:59 vrij van regime, van 08:00 t/m 20:00 een laad & los plek, en van 20:01 t/m 23:59 vrij van regime.
  #
  #=============================================================================

  # Regime Taxistandplaats

  LAYER
    NAME            "parkeervakken_tijdvakken_taxistandplaats"
    GROUP           "regimes"
    INCLUDE         "connection/dataservices.inc"
    DATA            "geometry FROM public.parkeervakken_parkeervakken inner join (select begin_tijd, eind_tijd, parent_id, bord from parkeervakken_parkeervakken_regimes) pvr on ID = pvr.parent_id
                        inner join (
                              select '00:00:00_06:59:00' as tijdvak
                              union
                              select '07:00:00_17:00:00'
                              union
                              select '17:01:00_23:59:00'
                              union
                              select '00:00:00_23:59:00'
                              ) AS TV ON
                                cast(regexp_replace(tijdvak, '^([^_]+)_([^_]+)', '\1') as time)  < eind_tijd and cast(regexp_replace(tijdvak, '^([^_]+)_([^_]+)', '\2') as time)  > begin_tijd
                                and e_type = 'E5' and bord = 'Taxistandplaats'
                        USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    MINSCALEDENOM   100
    MAXSCALEDENOM   400000
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION      "init=epsg:28992"
    END

    VALIDATION
      # %tijdvak% substitutions can only digits, underscore and semicolons
      'default_tijdvak'  'all'
      'tijdvak'          '^[0-9_:]+$'

    END

    METADATA
      "wfs_title"           "parkeervakken_tijdvakken_taxistandplaats"
      "wfs_srs"             "EPSG:28992"
      "wfs_abstract"        "taxistandplaats Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "tijdvak"
      "gml_include_items"   "all"
      "wms_title"           "parkeervakken_tijdvakken_taxistandplaats"
      "wms_enable_request"  "*"
      "wms_group_title"     "regimes"
      "wms_abstract"        "taxistandplaats Amsterdam"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "parkeervakken_tijdvakken_taxistandplaats"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
      "wms_extent"          "100000 450000 150000 500000"
    END

    CLASS
      NAME "tijdvak_00:00_06:59"
      EXPRESSION ("[tijdvak]" eq "00:00:00_06:59:00" AND ( '%tijdvak%' eq '00:00:00_06:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 160 0 120 #A00078
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        160 0 120 #A00078
       OPACITY      70
       WIDTH        2
      END

    END

   CLASS
      NAME "tijdvak_07:00_17:00"
      EXPRESSION ("[tijdvak]" eq "07:00:00_17:00:00" AND ( '%tijdvak%' eq '07:00:00_17:00:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 229 0 130 #E50082
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        229 0 130 #E50082
       OPACITY      70
       WIDTH        2
      END

    END

    CLASS
      NAME "tijdvak_17:01_23:59"
      EXPRESSION ("[tijdvak]" eq "17:01:00_23:59:00" AND ( '%tijdvak%' eq '17:01:00_23:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 255 145 0 #FF9100
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        255 145 0 #FF9100
       OPACITY      70
       WIDTH        2
      END


    END

    CLASS
      NAME "tijdvak_00:00_23:59"
      EXPRESSION ("[tijdvak]" eq "00:00:00_23:59:00" AND ( '%tijdvak%' eq '00:00:00_23:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 255 230 0 #FFE600
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        255 230 0 #FFE600
       OPACITY      70
       WIDTH        2
      END

    END
  END

  # Regime Laden & Lossen

  LAYER
    NAME            "parkeervakken_tijdvakken_laden_lossen"
    GROUP           "regimes"
    INCLUDE         "connection/dataservices.inc"
    DATA            "geometry FROM public.parkeervakken_parkeervakken inner join (select begin_tijd, eind_tijd, parent_id, bord from parkeervakken_parkeervakken_regimes) pvr on ID = pvr.parent_id
                        inner join (
                              select '00:00:00_06:59:00' as tijdvak
                              union
                              select '07:00:00_17:00:00'
                              union
                              select '17:01:00_23:59:00'
                              union
                              select '00:00:00_23:59:00'
                              ) AS TV ON
                                cast(regexp_replace(tijdvak, '^([^_]+)_([^_]+)', '\1') as time)  < eind_tijd and cast(regexp_replace(tijdvak, '^([^_]+)_([^_]+)', '\2') as time)  > begin_tijd
                                and e_type = 'E7' and bord = 'Laden & Lossen'
                        USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    MINSCALEDENOM   100
    MAXSCALEDENOM   400000
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION      "init=epsg:28992"
    END

    VALIDATION
      # %tijdvak% substitutions can only digits, underscore and semicolons
      'default_tijdvak'  'all'
      'tijdvak'          '^[0-9_:]+$'
    END

    METADATA
      "wfs_title"          "parkeervakken_tijdvakken_laden_lossen"
      "wfs_srs"             "EPSG:28992"
      "wfs_abstract"        "Laden & Lossen Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "tijdvak"
      "gml_include_items"   "all"
      "wms_title"           "parkeervakken_tijdvakken_laden_lossen"
      "wms_enable_request"  "*"
      "wms_group_title"     "regimes"
      "wms_abstract"        "Laden & Lossen Amsterdam"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "parkeervakken_tijdvakken_laden_lossen"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
      "wms_extent"          "100000 450000 150000 500000"
    END

    CLASS
      NAME "tijdvak_00:00_06:59"
      EXPRESSION ("[tijdvak]" eq "00:00:00_06:59:00" AND ( '%tijdvak%' eq '00:00:00_06:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 179 139 104 #b38b68
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        179 139 104 #b38b68
       OPACITY      70
       WIDTH        2
      END

    END

   CLASS
      NAME "tijdvak_07:00_17:00"
      EXPRESSION ("[tijdvak]" eq "07:00:00_17:00:00" AND ( '%tijdvak%' eq '07:00:00_17:00:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 135 98 69 #876245
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        135 98 69 #876245
       OPACITY      70
       WIDTH        2
      END

    END

    CLASS
      NAME "tijdvak_17:01_23:59"
      EXPRESSION ("[tijdvak]" eq "17:01:00_23:59:00"  AND ( '%tijdvak%' eq '17:01:00_23:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 101 73 52 #654934
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        101 73 52 #654934
       OPACITY      70
       WIDTH        2
      END

    END

    CLASS
      NAME "tijdvak_00:00_23:59"
      EXPRESSION ("[tijdvak]" eq "00:00:00_23:59:00" AND ( '%tijdvak%' eq '00:00:00_23:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 179 139 104 #b38b6d
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        179 139 104 #b38b6d
       OPACITY      70
       WIDTH        2
      END

    END
  END

  # Regime Kiss & Ride

  LAYER
    NAME            "parkeervakken_tijdvakken_kiss_ride"
    GROUP           "regimes"
    INCLUDE         "connection/dataservices.inc"
    DATA            "geometry FROM public.parkeervakken_parkeervakken inner join (select begin_tijd, eind_tijd, parent_id, bord from parkeervakken_parkeervakken_regimes) pvr on ID = pvr.parent_id
                        inner join (
                              select '00:00:00_06:59:00' as tijdvak
                              union
                              select '07:00:00_17:00:00'
                              union
                              select '17:01:00_23:59:00'
                              union
                              select '00:00:00_23:59:00'
                              ) AS TV ON
                                cast(regexp_replace(tijdvak, '^([^_]+)_([^_]+)', '\1') as time)  < eind_tijd and cast(regexp_replace(tijdvak, '^([^_]+)_([^_]+)', '\2') as time)  > begin_tijd
                                and e_type = 'E9' and bord = 'Kiss & Ride'
                        USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    MINSCALEDENOM   100
    MAXSCALEDENOM   400000
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION      "init=epsg:28992"
    END

    VALIDATION
      # %tijdvak% substitutions can only digits, underscore and semicolons
      'default_tijdvak'  'all'
      'tijdvak'          '^[0-9_:]+$'
    END

    METADATA
      "wfs_title"           "parkeervakken_tijdvakken_kiss_ride"
      "wfs_srs"             "EPSG:28992"
      "wfs_abstract"        "Kiss & Ride Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "tijdvak"
      "gml_include_items"   "all"
      "wms_title"           "parkeervakken_tijdvakken_kiss_ride"
      "wms_enable_request"  "*"
      "wms_group_title"     "regimes"
      "wms_abstract"        "Kiss & Ride Amsterdam"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "parkeervakken_tijdvakken_kiss_ride"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
      "wms_extent"          "100000 450000 150000 500000"
    END

    CLASS
      NAME "tijdvak_00:00_06:59"
      EXPRESSION ("[tijdvak]" eq "00:00:00_06:59:00" AND ( '%tijdvak%' eq '00:00:00_06:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 0 70 153 #004699
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        0 70 153 #004699
       OPACITY      70
       WIDTH        2
      END

    END

   CLASS
      NAME "tijdvak_07:00_17:00"
      EXPRESSION ("[tijdvak]" eq "07:00:00_17:00:00" AND ( '%tijdvak%' eq '07:00:00_17:00:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 0 157 230 #009DE6
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        0 157 230 #009DE6
       OPACITY      70
       WIDTH        2
      END

    END

    CLASS
      NAME "tijdvak_17:01_23:59"
      EXPRESSION ("[tijdvak]" eq "17:01:00_23:59:00" AND ( '%tijdvak%' eq '17:01:00_23:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 190 210 0 #BED200
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        190 210 0 #BED200
       OPACITY      70
       WIDTH        2
      END

    END

    CLASS
      NAME "tijdvak_00:00_23:59"
      EXPRESSION ("[tijdvak]" eq "00:00:00_23:59:00" AND ( '%tijdvak%' eq '00:00:00_23:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 0 160 60 #00A03C
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        0 160 60 #00A03C
       OPACITY      70
       WIDTH        2
      END

    END
  END


 # Regime vrachtwagens

    LAYER
    NAME            "parkeervakken_tijdvakken_vrachtwagens"
    GROUP           "regimes"
    INCLUDE         "connection/dataservices.inc"
    DATA            "geometry FROM public.parkeervakken_parkeervakken inner join (select begin_tijd, eind_tijd, parent_id, bord from parkeervakken_parkeervakken_regimes) pvr on ID = pvr.parent_id
                        inner join (
                              select '00:00:00_06:59:00' as tijdvak
                              union
                              select '07:00:00_17:00:00'
                              union
                              select '17:01:00_23:59:00'
                              union
                              select '00:00:00_23:59:00'
                              ) AS TV ON
                                cast(regexp_replace(tijdvak, '^([^_]+)_([^_]+)', '\1') as time)  < eind_tijd and cast(regexp_replace(tijdvak, '^([^_]+)_([^_]+)', '\2') as time)  > begin_tijd
                                and e_type = 'E8' and bord = 'Vrachtwagens'
                    USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    MINSCALEDENOM   100
    MAXSCALEDENOM   400000
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION      "init=epsg:28992"
    END

    VALIDATION
      # %tijdvak% substitutions can only digits, underscore and semicolons
      'default_tijdvak'  'all'
      'tijdvak'          '^[0-9_:]+$'
    END

    METADATA
      "wfs_title"           "parkeervakken_tijdvakken_vrachtwagens"
      "wfs_srs"             "EPSG:28992"
      "wfs_abstract"        "Vrachtwagenparkeervakken Amsterdam"
      "wfs_enable_request"  "*"
      "gml_featureid"       "tijdvak"
      "gml_include_items"   "all"
      "wms_title"           "parkeervakken_tijdvakken_vrachtwagens"
      "wms_enable_request"  "*"
      "wms_group_title"     "regimes"
      "wms_abstract"        "Vrachtwagenparkeervakken Amsterdam"
      "wms_srs"             "EPSG:28992"
      "wms_name"            "parkeervakken_tijdvakken_vrachtwagens"
      "wms_format"          "image/png"
      "wms_server_version"  "1.1.1"
      "wms_extent"          "100000 450000 150000 500000"
    END

      CLASS
      NAME "tijdvak_00:00_06:59"
      EXPRESSION ("[tijdvak]" eq "00:00:00_06:59:00" AND ( '%tijdvak%' eq '00:00:00_06:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 0 70 153 #004699
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        0 70 153 #004699
       OPACITY      70
       WIDTH        2
      END

    END

   CLASS
      NAME "tijdvak_07:00_17:00"
      EXPRESSION ("[tijdvak]" eq "07:00:00_17:00:00" AND ( '%tijdvak%' eq '07:00:00_17:00:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 0 157 230 #009DE6
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        0 157 230 #009DE6
       OPACITY      70
       WIDTH        2
      END

    END

    CLASS
      NAME "tijdvak_17:01_23:59"
      EXPRESSION ("[tijdvak]" eq "17:01:00_23:59:00" AND ( '%tijdvak%' eq '17:01:00_23:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 190 210 0 #BED200
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        190 210 0 #BED200
       OPACITY      70
       WIDTH        2
      END

    END

    CLASS
      NAME "tijdvak_00:00_23:59"
      EXPRESSION ("[tijdvak]" eq "00:00:00_23:59:00" AND ( '%tijdvak%' eq '00:00:00_23:59:00'  OR '%tijdvak%' eq 'all' ))

      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 0 160 60 #00A03C
       OPACITY      100
       WIDTH        2
      END

      STYLE
       ANTIALIAS    true
       COLOR        0 160 60 #00A03C
       OPACITY      70
       WIDTH        2
      END

    END
  END

  #=============================================================================
  # LAYERS
  #=============================================================================

  LAYER
    NAME            "alle_parkeervakken"
    GROUP           "parkeervakken"
    INCLUDE         "connection/dataservices.inc"
    DATA            "geometry FROM public.parkeervakken_parkeervakken USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    MINSCALEDENOM   100
    MAXSCALEDENOM   425001
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION
    "init=epsg:28992"
    END

    METADATA
      "ows_title"           "alle_parkeervakken"
      "ows_group_title"     "parkeervakken"
      "ows_abstract"        "Parkeervakken in de gemeente Amsterdam"
      "gml_featureid"       "id"
      "gml_include_items"   "all"
      "gml_types"           "auto"
    END

    CLASS
      NAME "Fiscaal"
      EXPRESSION ("[soort]" eq "FISCAAL")
      STYLE
        ANTIALIAS      true
        OUTLINECOLOR   190 210 0
        WIDTH          2
      END
    END

    CLASS
      NAME          'Niet fiscaal'
      STYLE
       ANTIALIAS    true
       OUTLINECOLOR 255 145 0
       WIDTH        2
      END
    END

  END


  LAYER
    NAME            "parkeervakken_label"
    GROUP           "parkeervakken"
    INCLUDE         "connection/dataservices.inc"
    DATA            "geometry FROM public.parkeervakken_parkeervakken USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    MINSCALEDENOM   100
    MAXSCALEDENOM   401
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION
    "init=epsg:28992"
    END

    METADATA
      "ows_title"           "parkeervakken_label"
      "ows_group_title"     "parkeervakken"
      "ows_abstract"        "Labels van parkeervakken van de gemeente Amsterdam"
    END

    CLASS
      TEXT             '[id]'
      NAME             'Geo id'
      LABEL
        MINSCALEDENOM  100
        MAXSCALEDENOM  401
        COLOR          0 0 0
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
      END
    END

  END

  LAYER
    NAME            "parkeervakken_bord"
    GROUP           "parkeervakken"
    INCLUDE         "connection/dataservices.inc"
    DATA            "geometry FROM public.parkeervakken_parkeervakken
                              join (select parent_id, string_agg(bord, ',') as bord from parkeervakken_parkeervakken_regimes
                              where e_type <> 'E6b' and bord is not null and bord <> '' group by parent_id) pvr
                              on ID = pvr.parent_id USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    MINSCALEDENOM   10
    MAXSCALEDENOM   9001
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION
    "init=epsg:28992"
    END

    METADATA
      "ows_title"           "parkeervakken_bord"
      "ows_group_title"     "parkeervakken"
      "ows_abstract"        "Parkeervakken met labels van de gemeente Amsterdam"
    END

    PROCESSING 'NATIVE_FILTER=(NOT (bord IS NULL))'

    CLASS
      TEXT             '[bord]'
      NAME             'Bord'

      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        SIZE           10
        OUTLINECOLOR   0 0 0
        WIDTH          2
      END

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

  LAYER
    NAME            "parkeervakken_reservering"
    GROUP           "parkeervakken"
    INCLUDE         "connection/dataservices.inc"

    VALIDATION
       # %categorie% substitutions can only have letters, digits and underscore
       'default_categorie' 'all'
       'categorie'     '^[0-9a-z_,]{1,256}$'
    END

    DATA            "geometry FROM public.parkeervakken_parkeervakken pv
                              join (select parent_id
                                         , string_agg(nullif(opmerking, ''), ',') as opmerkingen
                                         , string_agg(nullif(bord, ''), ',') as bord
                              from parkeervakken_parkeervakken_regimes pvr
                              where (pvr.begin_datum is not null and current_date between pvr.begin_datum and pvr.eind_datum)
                              or (pvr.begin_datum is null and nullif(pvr.e_type,'') is not null)
                              group by parent_id) pvr1
                              on pv.id = pvr1.parent_id
                    USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    MINSCALEDENOM   100
    MAXSCALEDENOM   11001
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION
      "init=epsg:28992"
    END

    METADATA
      "ows_title"           "parkeervakken_reservering"
      "ows_group_title"     "parkeervakken"
      "ows_abstract"        "Parkeervakken in Amsterdam"
      "gml_featureid"       "ID"
      "gml_include_items"   "all"
    END

    CLASS
      NAME "Fiscaal"
      EXPRESSION (("[soort]" eq "FISCAAL") AND ('%categorie%' ~ 'fiscaal' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        SIZE           10
        OUTLINECOLOR   190 210 0
        COLOR          190 210 0
        OPACITY        50
        WIDTH          2
      END

      TEXT             '[opmerkingen]'
      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1001
        COLOR          0 0 0
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
      END
    END

    CLASS
      NAME "Parkeerverbod"
      EXPRESSION (("[e_type]" eq "E1")  AND ('%categorie%' ~ 'parkeerverbod' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        SIZE           10
        OUTLINECOLOR   236 0 0
        COLOR          255 255 255
        WIDTH          2
      END
    END


    CLASS
      NAME "Gehandicaptenplaats algemeen"
      EXPRESSION (("[e_type]" eq "E6a") AND ('%categorie%' ~ 'gehandicapten_algemeen' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        COLOR          0 157 230
        OPACITY        50
      END
    END

    CLASS
      NAME "Gehandicaptenplaats kenteken"
      EXPRESSION (("[e_type]" eq "E6b") AND ('%categorie%' ~ 'gehandicapten_kenteken' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        COLOR          0 157 230
        OUTLINECOLOR   0 157 230
        OPACITY        50
        WIDTH          2
      END
    END

    CLASS
      NAME "Laden lossen"
      EXPRESSION (("[e_type]" eq "E7") AND ('%categorie%' ~ 'laden_lossen' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        COLOR          179 139 104 #b38b68
        OUTLINECOLOR   179 139 104 #b38b68
        OPACITY        50
        WIDTH          2
      END

      TEXT             '[opmerkingen]'
      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1001
        COLOR          210 100 50
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
      END
    END

    CLASS
      NAME "Specifieke voertuigcategorie"
      EXPRESSION (("[e_type]" eq "E8") AND ('%categorie%' ~ 'specifiek_voertuig' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        SIZE           10
        OUTLINECOLOR   229 0 130
        COLOR          229 0 130
        OPACITY        50
        WIDTH          2
      END

      TEXT             '[opmerkingen]'
      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  1001
        COLOR          210 100 50
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
      END
    END

    CLASS
      NAME "Vergunninghouders"
      EXPRESSION (("[e_type]" eq "E9") AND ("[bord]" ne "Kiss & Ride") AND ('%categorie%' ~ 'vergunning_houders' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        SIZE           10
        OUTLINECOLOR   160 0 120
        COLOR          160 0 120
        OPACITY        50
        WIDTH          2
      END
    END

    CLASS
      NAME "Blauwe zone"
      EXPRESSION (("[e_type]" eq "E10") AND ('%categorie%' ~ 'blauwe_zone' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        SIZE           10
        OUTLINECOLOR   0 70 153
        COLOR          0 70 153
        OPACITY        50
        WIDTH          2
      END
    END


    CLASS
      NAME "Park & Ride"
      EXPRESSION (("[e_type]" eq "E12") AND ('%categorie%' ~ 'park_ride' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        SIZE           10
        OUTLINECOLOR   0 160 60
        COLOR          0 160 60
        OPACITY        50
        WIDTH          2
      END
    END

    CLASS
      NAME "Kiss & Ride"
      EXPRESSION (("[e_type]" eq "E9") AND ("[bord]" eq "Kiss & Ride") AND ('%categorie%' ~ 'kiss_ride' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        SIZE           10
        OUTLINECOLOR   0 160 60
        COLOR          0 160 60
        OPACITY        50
        WIDTH          2
      END
    END


    CLASS
      NAME "MULDER"
      EXPRESSION (("[soort]" eq "MULDER") AND ('%categorie%' ~ 'mulder' OR '%categorie%' eq 'all'))
      STYLE
        MINSCALEDENOM  10
        MAXSCALEDENOM  9001
        SIZE           10
        OUTLINECOLOR   155 245 150
        COLOR          255 245 250
        WIDTH          2
      END
    END

  END


  #=============================================================================
  # LAYERS FOR TVM
  #=============================================================================

  LAYER
    NAME            "fiscaal_parkeervakken"
    GROUP           "fiscaalparkeervakken"
    INCLUDE         "connection/dataservices.inc"
    DATA            "geometry FROM public.parkeervakken_parkeervakken USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION
    "init=epsg:28992"
    END

    METADATA
      "ows_title"           "fiscaal_parkeervakken"
      "ows_group_title"     "fiscale parkeervakken"
      "ows_abstract"        "Fiscale parkeervakken in de gemeente Amsterdam"
      "gml_featureid"       "id"
      "gml_include_items"   "all"
      "gml_types"           "auto"
    END

    CLASS
      NAME "Fiscaal - embed"
      EXPRESSION ("[soort]" eq "FISCAAL")
      STYLE
      MINSCALEDENOM  10
        MAXSCALEDENOM  800
        ANTIALIAS      true
        OUTLINECOLOR   0 0 0
        WIDTH          2
      END
      STYLE
      MINSCALEDENOM  800
        MAXSCALEDENOM  2000
        ANTIALIAS      true
        OUTLINECOLOR   0 0 0
        WIDTH          1.5
      END
      STYLE
      MINSCALEDENOM  2000
        MAXSCALEDENOM  40000
        ANTIALIAS      true
        OUTLINECOLOR   0 0 0
        WIDTH          1.0
      END
    END
  END

  LAYER
    NAME            "nietfiscaal_parkeervakken"
    GROUP           "nietfiscaalparkeervakken"
    INCLUDE         "connection/dataservices.inc"
    DATA            "geometry FROM public.parkeervakken_parkeervakken USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION
    "init=epsg:28992"
    END

    METADATA
      "ows_title"           "niet_fiscaal_parkeervakken"
      "ows_group_title"     "niet-fiscale parkeervakken"
      "ows_abstract"        "Niet-fiscale parkeervakken in de gemeente Amsterdam"
      "gml_featureid"       "id"
      "gml_include_items"   "all"
      "gml_types"           "auto"
    END

    CLASS
      NAME "Niet-fiscaal - embed"
      EXPRESSION ("[soort]" eq "NIET FISCAAL" || "[soort]" eq "NIET FISCA" || "[soort]" eq "MULDER")
      STYLE
      MINSCALEDENOM  10
        MAXSCALEDENOM  800
        ANTIALIAS      true
        OUTLINECOLOR   0 70 153
        WIDTH          2
      END
      STYLE
      MINSCALEDENOM  800
        MAXSCALEDENOM  2000
        ANTIALIAS      true
        OUTLINECOLOR   0 70 153
        WIDTH          1.5
      END
      STYLE
      MINSCALEDENOM  2000
        MAXSCALEDENOM  40000
        ANTIALIAS      true
        OUTLINECOLOR   0 70 153
        WIDTH          1.0
      END
    END
  END


  LAYER
    NAME            "embed_parkeervakken_label"
    GROUP           "embed_parkeervakken"
    INCLUDE         "connection/dataservices.inc"
    DATA            "geometry FROM public.parkeervakken_parkeervakken USING srid=28992 USING UNIQUE id"
    TYPE            POLYGON
    TEMPLATE        "fooOnlyForWMSGetFeatureInfo.html"
    PROJECTION
    "init=epsg:28992"
    END

    METADATA
      "ows_title"           "embed_parkeervakken_label"
      "ows_group_title"     "embed_parkeervakken"
      "ows_abstract"        "Labels van parkeervakken van de gemeente Amsterdam, voor embedkaart"
    END

    CLASS
      TEXT             '[id]'
      NAME             'Geo id - embed'
      LABEL
        MINSCALEDENOM  10
        MAXSCALEDENOM  400
        COLOR          0 0 0
        OUTLINECOLOR   255 255 255
        OUTLINEWIDTH   3
        FONT           "Ubuntu-M"
        TYPE           truetype
        SIZE           10
        POSITION       AUTO
        PARTIALS       FALSE
      END
    END
  END

#=============================================================================
END