MAP
FONTSET "fonts.lst"
IMAGETYPE png
MAXSIZE 4000
SIZE 800 800
EXTENT -12166787.538553 4546474.4417774 -11288984.705885 4942723.9963367
UNITS meters
IMAGECOLOR 153 179 204
WEB
   METADATA
      "ows_enable_request" "*"
      "ows_srs" "EPSG:900913 EPSG:4326 EPSG:3857 EPSG:2154 EPSG:310642901 EPSG:4171 EPSG:310024802 EPSG:310915814 EPSG:310486805 EPSG:310702807 EPSG:310700806 EPSG:310547809 EPSG:310706808 EPSG:310642810 EPSG:310642801 EPSG:310642812 EPSG:310032811 EPSG:310642813 EPSG:2986"
      "labelcache_map_edge_buffer" "-10"
      "ows_title"               "MapServer benchmarking with OpenStreetMap data for Colorado"
      "ows_onlineresource"      "http://12.189.158.78:8081/cgi-bin/mapserv6?MAP=/benchmarking/wms/2011/mapserver/hill-google.map"
      "ows_abstract"            "This WMS is run with MapServer 6.0, accessing OSM dataset.  This was setup for the Web server benchmarking presentation at FOSS4G2011.  More info at: http://wiki.osgeo.org/wiki/Benchmarking_2011"
      "ows_contactperson"       "Jeff McKenna"
      "ows_contactorganization" "Gateway Geomatics" 
      "ows_contactposition"     "Director"
      "ows_contactelectronicmailaddress" "info@gatewaygeomatics.com"
      "ows_attribution_title"   "OSM dataset"
      "ows_attribution_onlineresource" "http://openstreetmap.org"
   END
   IMAGEPATH "/opt/mapserver/htdocs/tmp/"
   IMAGEURL "/tmp"
END
DEBUG 1
CONFIG "MS_ERRORFILE" "stderr"
CONFIG "PROJ_LIB" "/opt/mapserver/mapserver-utils-imposm-branch"
PROJECTION
   "init=epsg:3857"
END

LAYER
  NAME "hillshade"
  TYPE raster
  TILEINDEX "/benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int.shp"
  PROJECTION
       "+init=epsg:4326" 
  END
 # OPACITY 60
  PROCESSING "SCALE=1003,1800"
  CLASS
    STYLE
      COLORRANGE  46 154 88 251 255 128  # 242 239 233 0 0 255  #34  139  34   0 0  255
      DATARANGE   1003 1800
    END
  END
END


LAYER
  NAME "hillshade"
  TYPE raster
  TILEINDEX "/benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int.shp"
  PROJECTION
       "+init=epsg:4326"
  END
 # OPACITY 60
  PROCESSING "SCALE=1800,2800"
  CLASS
    STYLE
      COLORRANGE  251 255 128 224 108 31 
      DATARANGE   1800 2800
    END
  END
END

LAYER
  NAME "hillshade"
  TYPE raster
  TILEINDEX "/benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int.shp"
  PROJECTION
       "+init=epsg:4326"
  END
#  OPACITY 60
  PROCESSING "SCALE=2800,3500"
  CLASS
    STYLE
      COLORRANGE   224 108 31  200 55 55
      DATARANGE    2800 3500
    END
  END 
END


LAYER
  NAME "hillshade"
  TYPE raster
  TILEINDEX "/benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int.shp"
  PROJECTION
       "+init=epsg:4326"
  END
#  OPACITY 60
  PROCESSING "SCALE=3500,4397"
  CLASS
    STYLE
      COLORRANGE  200 55 55  215 244 244 
      DATARANGE   3500 4397
    END
  END
END




#LAYER
#  NAME "hillpoly"
#  TYPE polygon
#  DATA "/benchmarking/wms/2011/data/raster/DEM/bil_16int/dem_bil16int"
#  PROJECTION
#       "+init=epsg:4326"
#  END
#  CLASS
#    SYMBOL 0
#    OUTLINECOLOR 255 0 0 
#  END
#END



LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "default"
   NAME "land0"
   PROJECTION
       "+init=epsg:4326"
   END
   MINSCALEDENOM 332808204
   MAXSCALEDENOM 99999999999
   DATA "data/TM_WORLD_BORDERS-0.3.shp"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 99999999999
   MINSCALEDENOM 332808204
   TYPE LINE
   NAME "borders0"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 0.5
         COLOR "#CDCBC6"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places0"
   MINSCALEDENOM 332808204
   MAXSCALEDENOM 99999999999
   DATA "geometry from (select * from osm_places where type in ('country','continent') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'continents'
        LABEL
            FONT scb
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 100 100 100
            OUTLINECOLOR -1 -1 -1
            OUTLINEWIDTH 1
            BUFFER 4
            PARTIALS FALSE
            POSITION cc
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "default"
   DEBUG 1
   NAME "land1"
   PROJECTION
       "+init=epsg:4326"
   END
   MINSCALEDENOM 166404102
   MAXSCALEDENOM 332808204
   DATA "data/TM_WORLD_BORDERS-0.3.shp"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 332808204
   MINSCALEDENOM 166404102
   TYPE LINE
   NAME "borders1"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 0.5
         COLOR "#CDCBC6"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places1"
   MINSCALEDENOM 166404102
   MAXSCALEDENOM 332808204
   DATA "geometry from (select * from osm_places where type in ('country','continent') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'continents'
        LABEL
            FONT scb
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 100 100 100
            OUTLINECOLOR -1 -1 -1
            OUTLINEWIDTH 1
            BUFFER 4
            PARTIALS FALSE
            POSITION cc
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "default"
   DEBUG 1
   NAME "land2"
   PROJECTION
       "+init=epsg:4326"
   END
   MINSCALEDENOM 83202051
   MAXSCALEDENOM 166404102
   DATA "data/TM_WORLD_BORDERS-0.3.shp"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 166404102
   MINSCALEDENOM 83202051
   TYPE LINE
   NAME "borders2"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 0.5
         COLOR "#CDCBC6"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places2"
   MINSCALEDENOM 83202051
   MAXSCALEDENOM 166404102
   DATA "geometry from (select * from osm_places where type in ('country','continent') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'continents'
        LABEL
            FONT scb
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 100 100 100
            OUTLINECOLOR -1 -1 -1
            OUTLINEWIDTH 1
            BUFFER 4
            PARTIALS FALSE
            POSITION cc
        END
    END
    CLASS
        EXPRESSION 'country'
        LABEL
            FONT scb
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 100 100 100
            OUTLINECOLOR -1 -1 -1
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION cc
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "default"
   DEBUG 1
   NAME "land3"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 41601025
   MAXSCALEDENOM 83202051
   DATA "data/shoreline_300"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 83202051
   MINSCALEDENOM 41601025
   TYPE LINE
   NAME "borders3"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 0.5
         COLOR "#CDCBC6"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places3"
   MINSCALEDENOM 41601025
   MAXSCALEDENOM 83202051
   DATA "geometry from (select * from osm_places where type in ('country','continent','city') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'country'
        LABEL
            FONT scb
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 100 100 100
            OUTLINECOLOR -1 -1 -1
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION cc
        END
    END
    CLASS
        EXPRESSION 'city'
        STYLE
            SIZE 5
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 68 68 68
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "default"
   DEBUG 1
   NAME "land4"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 20800512
   MAXSCALEDENOM 41601025
   DATA "data/shoreline_300"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse4"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','residential')      order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 41601025
    MINSCALEDENOM 20800512
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas4"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 41601025
   MINSCALEDENOM 20800512
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea4"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 41601025
    MINSCALEDENOM 20800512
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 41601025
   MINSCALEDENOM 20800512
   TYPE LINE
   NAME "borders4"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 0.5
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places4"
   MINSCALEDENOM 20800512
   MAXSCALEDENOM 41601025
   DATA "geometry from (select * from osm_places where type in ('country','continent','city') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'country'
        LABEL
            FONT scb
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 100 100 100
            OUTLINECOLOR -1 -1 -1
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION cc
        END
    END
    CLASS
        EXPRESSION 'city'
        STYLE
            SIZE 5
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 68 68 68
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "default"
   DEBUG 1
   NAME "land5"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 10400256
   MAXSCALEDENOM 20800512
   DATA "data/shoreline_300"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse5"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','residential')      order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 20800512
    MINSCALEDENOM 10400256
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas5"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 20800512
   MINSCALEDENOM 10400256
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea5"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 20800512
    MINSCALEDENOM 10400256
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 10400256
    MAXSCALEDENOM 20800512
    NAME "roads5"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads_gen0 order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
            WIDTH 0.5
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
            WIDTH 0.5
            COLOR 255 195 69
        END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 20800512
   MINSCALEDENOM 10400256
   TYPE LINE
   NAME "borders5"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 0.5
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places5"
   MINSCALEDENOM 10400256
   MAXSCALEDENOM 20800512
   DATA "geometry from (select * from osm_places where type in ('country','continent','city') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'country'
        LABEL
            FONT scb
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 100 100 100
            OUTLINECOLOR -1 -1 -1
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION cc
        END
    END
    CLASS
        EXPRESSION 'city'
        STYLE
            SIZE 5
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 68 68 68
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
#   GROUP "default"
   DEBUG 1
   NAME "land6"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 5200128
   MAXSCALEDENOM 10400256
   DATA "data/shoreline_300"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse6"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','industrial','commercial','residential')      order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 10400256
    MINSCALEDENOM 5200128
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas6"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 10400256
   MINSCALEDENOM 5200128
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea6"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 10400256
    MINSCALEDENOM 5200128
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways6"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways where type='river') as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 10400256
    MINSCALEDENOM 5200128
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 0.15
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 0
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 0
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 5200128
    MAXSCALEDENOM 10400256
    NAME "roads6"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads_gen1 order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
            WIDTH 0.5
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
            WIDTH 0.5
            COLOR 255 195 69
        END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 10400256
   MINSCALEDENOM 5200128
   TYPE LINE
   NAME "borders6"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 0.5
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places6"
   MINSCALEDENOM 5200128
   MAXSCALEDENOM 10400256
   DATA "geometry from (select * from osm_places where type in ('country','continent','city') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'country'
        LABEL
            FONT scb
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 100 100 100
            OUTLINECOLOR -1 -1 -1
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION cc
        END
    END
    CLASS
        EXPRESSION 'city'
        STYLE
            SIZE 5
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 68 68 68
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land7"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 2600064
   MAXSCALEDENOM 5200128
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END

LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse7"
    OPACITY 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','industrial','commercial','residential')      order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 5200128
    MINSCALEDENOM 2600064
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas7"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 5200128
   MINSCALEDENOM 2600064
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea7"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 5200128
    MINSCALEDENOM 2600064
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways7"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways where type='river') as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 5200128
    MINSCALEDENOM 2600064
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 0.25
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 0
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 0
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 2600064
    MAXSCALEDENOM 5200128
    NAME "roads7"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads_gen1 order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 0.5
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 0.5
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 0.5
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 0.5
            COLOR 255 195 69
        END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 5200128
   MINSCALEDENOM 2600064
   TYPE LINE
   NAME "borders7"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places7"
   MINSCALEDENOM 2600064
   MAXSCALEDENOM 5200128
   DATA "geometry from (select * from osm_places where type in ('country','continent','city') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'country'
        LABEL
            FONT scb
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 100 100 100
            OUTLINECOLOR -1 -1 -1
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION cc
        END
    END
    CLASS
        EXPRESSION 'city'
        STYLE
            SIZE 5
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR 68 68 68
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land8"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 1300032
   MAXSCALEDENOM 2600064
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse8"
    OPACITY 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','industrial','commercial','residential')      order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 2600064
    MINSCALEDENOM 1300032
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas8"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 2600064
   MINSCALEDENOM 1300032
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea8"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 2600064
    MINSCALEDENOM 1300032
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways8"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways where type='river') as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 2600064
    MINSCALEDENOM 1300032
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 0.5
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 0
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 0
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 1300032
    MAXSCALEDENOM 2600064
    TYPE LINE
    NAME "railways8"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways_gen1 where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 0.5
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 0.5
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 1300032
    MAXSCALEDENOM 2600064
    NAME "roads8"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads_gen1 order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 1
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 1
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 1
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 1
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
            WIDTH 0.5
            COLOR 193 181 157
        END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 2600064
   MINSCALEDENOM 1300032
   TYPE LINE
   NAME "borders8"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places8"
   MINSCALEDENOM 1300032
   MAXSCALEDENOM 2600064
   DATA "geometry from (select * from osm_places where type in ('city','town') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'city'
        STYLE
            SIZE 6
            SYMBOL "citycircle"
            COLOR 255 255 255
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 9
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'town'
        STYLE
            SIZE 3
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR "#666666"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land9"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 650016
   MAXSCALEDENOM 1300032
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse9"
    opacity 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','pedestrian','cemetery','industrial','commercial',      'brownfield','residential','school','college','university',      'military','park','golf_course','hospital','parking','stadium','sports_center',      'pitch') order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 1300032
    MINSCALEDENOM 650016
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas9"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 1300032
   MINSCALEDENOM 650016
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea9"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 1300032
    MINSCALEDENOM 650016
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways9"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways where type='river') as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 1300032
    MINSCALEDENOM 650016
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 1
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 0
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 0
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 650016
    MAXSCALEDENOM 1300032
    TYPE LINE
    NAME "railways9"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways_gen1 where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 0.5
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 0.5
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 650016
    MAXSCALEDENOM 1300032
    NAME "roads9"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 2
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 2
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "motorway_link"
        STYLE
           WIDTH 0.75
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 0.75
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 2
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 2
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION "trunk_link"
        STYLE
           WIDTH 0.75
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 0.75
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
           WIDTH 0.75
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 0.75
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION /secondary/
        STYLE
            WIDTH 0.5
            COLOR 193 181 157
        END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 1300032
   MINSCALEDENOM 650016
   TYPE LINE
   NAME "borders9"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places9"
   MINSCALEDENOM 650016
   MAXSCALEDENOM 1300032
   DATA "geometry from (select * from osm_places where type in ('city','town') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'city'
        STYLE
            SIZE 6
            SYMBOL "citycircle"
            COLOR 255 255 255
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 9
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'town'
        STYLE
            SIZE 3
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR "#666666"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land10"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 325008
   MAXSCALEDENOM 650016
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse10"
    opacity 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','pedestrian','cemetery','industrial','commercial',      'brownfield','residential','school','college','university',      'military','park','golf_course','hospital','parking','stadium','sports_center',      'pitch') order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 650016
    MINSCALEDENOM 325008
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas10"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 650016
   MINSCALEDENOM 325008
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea10"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 650016
    MINSCALEDENOM 325008
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways10"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 650016
    MINSCALEDENOM 325008
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 1
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 0.5
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 0.5
        END
        LABEL
          TYPE TRUETYPE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
          PARTIALS FALSE
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 325008
    MAXSCALEDENOM 650016
    TYPE LINE
    NAME "railways10"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways_gen1 where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 325008
    MAXSCALEDENOM 650016
    NAME "roads10"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 3
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 3
            COLOR 253 146 58
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            PRIORITY 1
            FONT scb
            SIZE 8
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "motorway_link"
        STYLE
           WIDTH 1
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 1
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 3
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 3
            COLOR 255 195 69
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT scb
            SIZE 8
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "trunk_link"
        STYLE
           WIDTH 1
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 1
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
           WIDTH 1
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 1
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION /secondary/
        STYLE
           WIDTH 0.75
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 0.75
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION /tertiary/
        STYLE
            WIDTH 0.5
            COLOR 193 181 157
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    MINSCALEDENOM 325008
    MAXSCALEDENOM 650016
    TYPE LINE
    NAME "aeroways10"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type from osm_aeroways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    CLASS
      EXPRESSION "runway"
      STYLE
        COLOR 180 180 180
        WIDTH 1
        LINECAP BUTT
        LINEJOIN MITER
      END
      STYLE
        COLOR 80 80 80
        WIDTH 0
        PATTERN 2 2 END
        LINECAP BUTT
      END
    END
    CLASS
      EXPRESSION "taxiway"
      STYLE
        COLOR 180 180 180
        WIDTH 0.2
      END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 650016
   MINSCALEDENOM 325008
   TYPE LINE
   NAME "borders10"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places10"
   MINSCALEDENOM 325008
   MAXSCALEDENOM 650016
   DATA "geometry from (select * from osm_places where type in ('city','town') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'city'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 10
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 3
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'town'
        STYLE
            SIZE 5
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 9
            COLOR "#666666"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land11"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 162504
   MAXSCALEDENOM 325008
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse11"
    opacity 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','pedestrian','cemetery','industrial','commercial',      'brownfield','residential','school','college','university',      'military','park','golf_course','hospital','parking','stadium','sports_center',      'pitch') order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 325008
    MINSCALEDENOM 162504
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
     LABEL
       ENCODING "utf-8"
       TYPE TRUETYPE
       FONT sc
       SIZE 8
       COLOR 0 0 0
       OUTLINECOLOR 255 255 255
       OUTLINEWIDTH 2
       PRIORITY 2
       WRAP ' '
       MAXLENGTH 6
       ALIGN CENTER
       MINFEATURESIZE AUTO
       PARTIALS FALSE
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 2
          POSITION cc
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas11"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 325008
   MINSCALEDENOM 162504
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea11"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 325008
    MINSCALEDENOM 162504
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways11"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 325008
    MINSCALEDENOM 162504
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 2
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 0.5
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 0.5
        END
        LABEL
          TYPE TRUETYPE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
          PARTIALS FALSE
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 162504
    MAXSCALEDENOM 325008
    TYPE LINE
    NAME "railways11"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways_gen1 where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 162504
    MAXSCALEDENOM 325008
    NAME "roads11"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 3
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 3
            COLOR 253 146 58
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            PRIORITY 1
            FONT scb
            SIZE 8
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "motorway_link"
        STYLE
           WIDTH 1.5
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 1.5
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 3
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 3
            COLOR 255 195 69
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT scb
            SIZE 8
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "trunk_link"
        STYLE
           WIDTH 1.5
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 1.5
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
           WIDTH 1.5
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 1.5
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION /secondary/
        STYLE
           WIDTH 1
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 1
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION /tertiary/
        STYLE
            WIDTH 0.75
            COLOR 193 181 157
        END
    END
    CLASS
        EXPRESSION /unclassified|residential|service|road|living_street/
        STYLE
            WIDTH 0.5
            COLOR 193 181 157
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    MINSCALEDENOM 162504
    MAXSCALEDENOM 325008
    TYPE LINE
    NAME "aeroways11"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type from osm_aeroways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    CLASS
      EXPRESSION "runway"
      STYLE
        COLOR 180 180 180
        WIDTH 2
        LINECAP BUTT
        LINEJOIN MITER
      END
      STYLE
        COLOR 80 80 80
        WIDTH 0
        PATTERN 2 2 END
        LINECAP BUTT
      END
    END
    CLASS
      EXPRESSION "taxiway"
      STYLE
        COLOR 180 180 180
        WIDTH 0.2
      END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 325008
   MINSCALEDENOM 162504
   TYPE LINE
   NAME "borders11"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places11"
   MINSCALEDENOM 162504
   MAXSCALEDENOM 325008
   DATA "geometry from (select * from osm_places where type in ('city','town','village') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'city'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 11
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 3
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'town'
        STYLE
            SIZE 5
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 9
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'village'
        STYLE
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
            SIZE 3
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR "#444444"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            BUFFER 4
            POSITION AUTO
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land12"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 81252
   MAXSCALEDENOM 162504
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse12"
    opacity 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','pedestrian','cemetery','industrial','commercial',      'brownfield','residential','school','college','university',      'military','park','golf_course','hospital','parking','stadium','sports_center',      'pitch') order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 162504
    MINSCALEDENOM 81252
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 0
         COLOR "#333333"
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
     LABEL
       ENCODING "utf-8"
       TYPE TRUETYPE
       FONT sc
       SIZE 8
       COLOR 0 0 0
       OUTLINECOLOR 255 255 255
       OUTLINEWIDTH 2
       PRIORITY 2
       WRAP ' '
       MAXLENGTH 6
       ALIGN CENTER
       MINFEATURESIZE AUTO
       PARTIALS FALSE
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
       ENCODING "utf-8"
            SIZE 8
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            PRIORITY 2
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
            MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 2
          POSITION cc
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
         LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
      LABEL
        TYPE TRUETYPE
        PARTIALS FALSE
        FONT sc
        SIZE 8
        COLOR 0 0 0
        OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
        OUTLINEWIDTH 2
        PRIORITY 1
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
        MINFEATURESIZE AUTO
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas12"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 162504
   MINSCALEDENOM 81252
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea12"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 162504
    MINSCALEDENOM 81252
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways12"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 162504
    MINSCALEDENOM 81252
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 2
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 1
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
       ENCODING "utf-8"
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 1
        END
        LABEL
          TYPE TRUETYPE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
          PARTIALS FALSE
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 81252
    MAXSCALEDENOM 162504
    TYPE LINE
    NAME "railways12"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 81252
    MAXSCALEDENOM 162504
    NAME "roads12"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 4
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 4
            COLOR 253 146 58
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            PRIORITY 1
            FONT scb
            SIZE 8
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "motorway_link"
        STYLE
           WIDTH 2
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 2
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 4
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 4
            COLOR 255 195 69
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT scb
            SIZE 8
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "trunk_link"
        STYLE
           WIDTH 2
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 2
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
           WIDTH 2
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 2
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION /secondary/
        STYLE
           WIDTH 1.5
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 1.5
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION /tertiary/
        STYLE
           WIDTH 1
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 1
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION /unclassified|residential|service|road|living_street/
        STYLE
            WIDTH 0.5
            COLOR 193 181 157
        END
    END
    CLASS
        EXPRESSION "track"
        STYLE
            PATTERN 2 2 END
            WIDTH 0.75
            COLOR "#aaaaaa"
        END
    END
    CLASS
        EXPRESSION 'pedestrian'
        STYLE
            WIDTH 0.75
            COLOR 250 250 245
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    MINSCALEDENOM 81252
    MAXSCALEDENOM 162504
    TYPE LINE
    NAME "aeroways12"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type from osm_aeroways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    CLASS
      EXPRESSION "runway"
      STYLE
        COLOR 180 180 180
        WIDTH 3
        LINECAP BUTT
        LINEJOIN MITER
      END
      STYLE
        COLOR 80 80 80
        WIDTH 0
        PATTERN 2 2 END
        LINECAP BUTT
      END
    END
    CLASS
      EXPRESSION "taxiway"
      STYLE
        COLOR 180 180 180
        WIDTH 0.2
      END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 162504
   MINSCALEDENOM 81252
   TYPE LINE
   NAME "borders12"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places12"
   MINSCALEDENOM 81252
   MAXSCALEDENOM 162504
   DATA "geometry from (select * from osm_places where type in ('city','town','village') and name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'city'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 11
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 3
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'town'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 10
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'village'
        STYLE
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
            SIZE 3
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR "#444444"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            BUFFER 4
            POSITION AUTO
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land13"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 40626
   MAXSCALEDENOM 81252
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse13"
    opacity 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','pedestrian','cemetery','industrial','commercial',      'brownfield','residential','school','college','university',      'military','park','golf_course','hospital','parking','stadium','sports_center',      'pitch') order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 81252
    MINSCALEDENOM 40626
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 0
         COLOR "#333333"
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
     LABEL
       ENCODING "utf-8"
       TYPE TRUETYPE
       FONT sc
       SIZE 8
       COLOR 0 0 0
       OUTLINECOLOR 255 255 255
       OUTLINEWIDTH 2
       PRIORITY 2
       WRAP ' '
       MAXLENGTH 6
       ALIGN CENTER
       MINFEATURESIZE AUTO
       PARTIALS FALSE
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
       ENCODING "utf-8"
            SIZE 8
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            PRIORITY 2
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
            MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 2
          POSITION cc
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
         LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
      LABEL
        TYPE TRUETYPE
        PARTIALS FALSE
        FONT sc
        SIZE 8
        COLOR 0 0 0
        OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
        OUTLINEWIDTH 2
        PRIORITY 1
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
        MINFEATURESIZE AUTO
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas13"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 81252
   MINSCALEDENOM 40626
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea13"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 81252
    MINSCALEDENOM 40626
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways13"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 81252
    MINSCALEDENOM 40626
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 3
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 1
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
       ENCODING "utf-8"
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 1
        END
        LABEL
          TYPE TRUETYPE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
          PARTIALS FALSE
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 40626
    MAXSCALEDENOM 81252
    TYPE LINE
    NAME "railways13"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 40626
    MAXSCALEDENOM 81252
    NAME "roads13"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 4
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 4
            COLOR 253 146 58
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            PRIORITY 1
            FONT scb
            SIZE 8
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "motorway_link"
        STYLE
           WIDTH 2.5
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 2.5
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 4
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 4
            COLOR 255 195 69
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT scb
            SIZE 8
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "trunk_link"
        STYLE
           WIDTH 2.5
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 2.5
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
           WIDTH 2.5
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 2.5
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /secondary/
        STYLE
           WIDTH 2
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 2
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /tertiary/
        STYLE
           WIDTH 1.5
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 1.5
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION /unclassified|residential|service|road|living_street/
        STYLE
            WIDTH 0.5
            COLOR 193 181 157
        END
    END
    CLASS
        EXPRESSION "track"
        STYLE
            PATTERN 2 2 END
            WIDTH 0.75
            COLOR "#aaaaaa"
        END
    END
    CLASS
        EXPRESSION 'pedestrian'
        STYLE
           WIDTH 1
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 1
            COLOR 250 250 245
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    MINSCALEDENOM 40626
    MAXSCALEDENOM 81252
    TYPE LINE
    NAME "aeroways13"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type from osm_aeroways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    CLASS
      EXPRESSION "runway"
      STYLE
        COLOR 180 180 180
        WIDTH 5
        LINECAP BUTT
        LINEJOIN MITER
      END
      STYLE
        COLOR 80 80 80
        WIDTH 0
        PATTERN 2 2 END
        LINECAP BUTT
      END
    END
    CLASS
      EXPRESSION "taxiway"
      STYLE
        COLOR 180 180 180
        WIDTH 1
      END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 81252
   MINSCALEDENOM 40626
   TYPE LINE
   NAME "borders13"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places13"
   MINSCALEDENOM 40626
   MAXSCALEDENOM 81252
   DATA "geometry from (select * from osm_places where name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'city'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 12
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 3
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'town'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 10
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'village'
        STYLE
            SYMBOL "citycircle"
            COLOR 200 200 200
            OUTLINECOLOR 0 0 0
            SIZE 4
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 9
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            BUFFER 4
            POSITION AUTO
        END
    END
    CLASS
        EXPRESSION /suburb|hamlet|locality/
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR "#444444"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION AUTO
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land14"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 20313
   MAXSCALEDENOM 40626
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse14"
    opacity 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','pedestrian','cemetery','industrial','commercial',      'brownfield','residential','school','college','university',      'military','park','golf_course','hospital','parking','stadium','sports_center',      'pitch') order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 40626
    MINSCALEDENOM 20313
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 0
         COLOR "#333333"
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
     LABEL
       ENCODING "utf-8"
       TYPE TRUETYPE
       FONT sc
       SIZE 8
       COLOR 0 0 0
       OUTLINECOLOR 255 255 255
       OUTLINEWIDTH 2
       PRIORITY 2
       WRAP ' '
       MAXLENGTH 6
       ALIGN CENTER
       MINFEATURESIZE AUTO
       PARTIALS FALSE
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
       ENCODING "utf-8"
            SIZE 8
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            PRIORITY 2
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
            MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 2
          POSITION cc
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
         LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
      LABEL
        TYPE TRUETYPE
        PARTIALS FALSE
        FONT sc
        SIZE 8
        COLOR 0 0 0
        OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
        OUTLINEWIDTH 2
        PRIORITY 1
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
        MINFEATURESIZE AUTO
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas14"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 40626
   MINSCALEDENOM 20313
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea14"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 40626
    MINSCALEDENOM 20313
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways14"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 40626
    MINSCALEDENOM 20313
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 3
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 2
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
       ENCODING "utf-8"
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 2
        END
        LABEL
          TYPE TRUETYPE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
          PARTIALS FALSE
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 20313
    MAXSCALEDENOM 40626
    TYPE LINE
    NAME "railways14"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 20313
    MAXSCALEDENOM 40626
    NAME "roads14"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "motorway")
        STYLE
        END
        STYLE
            WIDTH 5
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 5
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "motorway_link")
        STYLE
        END
        STYLE
            WIDTH 3
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 3
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "trunk")
        STYLE
        END
        STYLE
            WIDTH 5
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 5
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "trunk_link")
        STYLE
        END
        STYLE
            WIDTH 3
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 3
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]" = "primary" or "[type]" = "primary_link"))
        STYLE
        END
        STYLE
            WIDTH 3
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 3
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]" = "secondary" or "[type]" = "secondary_link"))
        STYLE
        END
        STYLE
            WIDTH 2.5
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 2.5
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]"= "tertiary" or "[type]"="tertiary_link"))
        STYLE
        END
        STYLE
            WIDTH 2
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 2
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]"="classified" or "[type]"="residential" or "[type]"="service" or "[type]"="road" or "[type]"="living_street"))
        STYLE
        END
        STYLE
            WIDTH 2.5
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 2.5
            COLOR 255 255 255
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = 'pedestrian')
        STYLE
        END
        STYLE
            WIDTH 1.5
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 1.5
            COLOR 250 250 245
        END
    END
    CLASS
        EXPRESSION ("[type]"="motorway" and "[tunnel]"="1")
        STYLE
            WIDTH 5
            COLOR 253 146 58
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="motorway_link" and "[tunnel]"="1")
        STYLE
            WIDTH 3
            COLOR 253 146 58
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="trunk" and "[tunnel]"="1")
        STYLE
            WIDTH 5
            COLOR 255 195 69
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="trunk_link" and "[tunnel]"="1")
        STYLE
            WIDTH 3
            COLOR 255 195 69
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="primary" or "[type]"="primary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 3
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="secondary" or "[type]"="secondary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 2.5
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="tertiary" or "[type]"="tertiary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 2
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (('[type]'='unclassified' or '[type]'='residential' or '[type]'='service' or "[type]"="living_street") and "[tunnel]"="1")
        STYLE
            WIDTH 2.5
            COLOR 255 255 255
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 5
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 5
            COLOR 253 146 58
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            PRIORITY 1
            FONT scb
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "motorway_link"
        STYLE
           WIDTH 3
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 3
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 5
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 5
            COLOR 255 195 69
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT scb
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "trunk_link"
        STYLE
           WIDTH 3
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 3
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
           WIDTH 3
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 3
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /secondary/
        STYLE
           WIDTH 2.5
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 2.5
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /tertiary/
        STYLE
           WIDTH 2
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 2
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION /unclassified|residential|service|road|living_street/
        STYLE
           WIDTH 2.5
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 2.5
            COLOR 255 255 255
        END
    END
    CLASS
        EXPRESSION "track"
        STYLE
            PATTERN 2 2 END
            WIDTH 0.75
            COLOR "#aaaaaa"
        END
    END
    CLASS
        EXPRESSION 'pedestrian'
        STYLE
           WIDTH 1.5
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 1.5
            COLOR 250 250 245
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    MINSCALEDENOM 20313
    MAXSCALEDENOM 40626
    TYPE LINE
    NAME "aeroways14"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type from osm_aeroways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    CLASS
      EXPRESSION "runway"
      STYLE
        COLOR 180 180 180
        WIDTH 7
        LINECAP BUTT
        LINEJOIN MITER
      END
      STYLE
        COLOR 80 80 80
        WIDTH 0
        PATTERN 2 2 END
        LINECAP BUTT
      END
    END
    CLASS
      EXPRESSION "taxiway"
      STYLE
        COLOR 180 180 180
        WIDTH 1.5
      END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 40626
   MINSCALEDENOM 20313
   TYPE LINE
   NAME "borders14"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places14"
   MINSCALEDENOM 20313
   MAXSCALEDENOM 40626
   DATA "geometry from (select * from osm_places where name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'city'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 12
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 3
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'town'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 10
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'village'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 9
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            BUFFER 4
            POSITION AUTO
        END
    END
    CLASS
        EXPRESSION /suburb|hamlet|locality/
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 8
            COLOR "#444444"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION AUTO
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land15"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 10156
   MAXSCALEDENOM 20313
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse15"
    opacity 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','pedestrian','cemetery','industrial','commercial',      'brownfield','residential','school','college','university',      'military','park','golf_course','hospital','parking','stadium','sports_center',      'pitch') order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 20313
    MINSCALEDENOM 10156
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR "#333333"
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
     LABEL
       ENCODING "utf-8"
       TYPE TRUETYPE
       FONT sc
       SIZE 8
       COLOR 0 0 0
       OUTLINECOLOR 255 255 255
       OUTLINEWIDTH 2
       PRIORITY 2
       WRAP ' '
       MAXLENGTH 6
       ALIGN CENTER
       MINFEATURESIZE AUTO
       PARTIALS FALSE
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
       ENCODING "utf-8"
            SIZE 8
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            PRIORITY 2
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
            MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 2
          POSITION cc
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
         LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
      LABEL
        TYPE TRUETYPE
        PARTIALS FALSE
        FONT sc
        SIZE 8
        COLOR 0 0 0
        OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
        OUTLINEWIDTH 2
        PRIORITY 1
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
        MINFEATURESIZE AUTO
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas15"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 20313
   MINSCALEDENOM 10156
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea15"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 20313
    MINSCALEDENOM 10156
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways15"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 20313
    MINSCALEDENOM 10156
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 4
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 2
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
       ENCODING "utf-8"
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 4
        END
        LABEL
          TYPE TRUETYPE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
          PARTIALS FALSE
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 10156
    MAXSCALEDENOM 20313
    TYPE LINE
    NAME "railways15"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 10156
    MAXSCALEDENOM 20313
    NAME "roads15"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "motorway")
        STYLE
        END
        STYLE
            WIDTH 6
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 6
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "motorway_link")
        STYLE
        END
        STYLE
            WIDTH 4
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 4
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "trunk")
        STYLE
        END
        STYLE
            WIDTH 6
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 6
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "trunk_link")
        STYLE
        END
        STYLE
            WIDTH 4
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 4
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]" = "primary" or "[type]" = "primary_link"))
        STYLE
        END
        STYLE
            WIDTH 4
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 4
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]" = "secondary" or "[type]" = "secondary_link"))
        STYLE
        END
        STYLE
            WIDTH 3.5
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 3.5
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]"= "tertiary" or "[type]"="tertiary_link"))
        STYLE
        END
        STYLE
            WIDTH 2.5
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 2.5
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]"="classified" or "[type]"="residential" or "[type]"="service" or "[type]"="road" or "[type]"="living_street"))
        STYLE
        END
        STYLE
            WIDTH 4
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 4
            COLOR 255 255 255
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = 'pedestrian')
        STYLE
        END
        STYLE
            WIDTH 2
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 2
            COLOR 250 250 245
        END
    END
    CLASS
        EXPRESSION ("[type]"="motorway" and "[tunnel]"="1")
        STYLE
            WIDTH 6
            COLOR 253 146 58
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="motorway_link" and "[tunnel]"="1")
        STYLE
            WIDTH 4
            COLOR 253 146 58
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="trunk" and "[tunnel]"="1")
        STYLE
            WIDTH 6
            COLOR 255 195 69
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="trunk_link" and "[tunnel]"="1")
        STYLE
            WIDTH 4
            COLOR 255 195 69
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="primary" or "[type]"="primary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 4
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="secondary" or "[type]"="secondary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 3.5
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="tertiary" or "[type]"="tertiary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 2.5
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (('[type]'='unclassified' or '[type]'='residential' or '[type]'='service' or "[type]"="living_street") and "[tunnel]"="1")
        STYLE
            WIDTH 4
            COLOR 255 255 255
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 6
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 6
            COLOR 253 146 58
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            PRIORITY 1
            FONT scb
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "motorway_link"
        STYLE
           WIDTH 4
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 4
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 6
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 6
            COLOR 255 195 69
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT scb
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "trunk_link"
        STYLE
           WIDTH 4
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 4
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
           WIDTH 4
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 4
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /secondary/
        STYLE
           WIDTH 3.5
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 3.5
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 9
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /tertiary/
        STYLE
           WIDTH 2.5
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 2.5
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /unclassified|residential|service|road|living_street/
        STYLE
           WIDTH 4
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 4
            COLOR 255 255 255
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "track"
        STYLE
            PATTERN 2 3 END
            WIDTH 1
            COLOR "#ffffff"
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION 'footway'
        STYLE
            PATTERN 2 3 END
            WIDTH 1
            COLOR "#ffffff"
        END
    END
    CLASS
        EXPRESSION 'pedestrian'
        STYLE
           WIDTH 2
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 2
            COLOR 250 250 245
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    MINSCALEDENOM 10156
    MAXSCALEDENOM 20313
    TYPE LINE
    NAME "aeroways15"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type from osm_aeroways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    CLASS
      EXPRESSION "runway"
      STYLE
        COLOR 180 180 180
        WIDTH 11
        LINECAP BUTT
        LINEJOIN MITER
      END
      STYLE
        COLOR 80 80 80
        WIDTH 1
        PATTERN 2 2 END
        LINECAP BUTT
      END
    END
    CLASS
      EXPRESSION "taxiway"
      STYLE
        COLOR 180 180 180
        WIDTH 2
      END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 20313
   MINSCALEDENOM 10156
   TYPE LINE
   NAME "borders15"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places15"
   MINSCALEDENOM 10156
   MAXSCALEDENOM 20313
   DATA "geometry from (select * from osm_places where name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'city'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 13
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 3
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'town'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 11
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'village'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 10
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            BUFFER 4
            POSITION AUTO
        END
    END
    CLASS
        EXPRESSION /suburb|hamlet|locality/
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 9
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION AUTO
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land16"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 5078
   MAXSCALEDENOM 10156
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse16"
    opacity 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','pedestrian','cemetery','industrial','commercial',      'brownfield','residential','school','college','university',      'military','park','golf_course','hospital','parking','stadium','sports_center',      'pitch') order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 10156
    MINSCALEDENOM 5078
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR "#333333"
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
     LABEL
       ENCODING "utf-8"
       TYPE TRUETYPE
       FONT sc
       SIZE 8
       COLOR 0 0 0
       OUTLINECOLOR 255 255 255
       OUTLINEWIDTH 2
       PRIORITY 2
       WRAP ' '
       MAXLENGTH 6
       ALIGN CENTER
       MINFEATURESIZE AUTO
       PARTIALS FALSE
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
       ENCODING "utf-8"
            SIZE 8
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            PRIORITY 2
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
            MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 2
          POSITION cc
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
         LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
      LABEL
        TYPE TRUETYPE
        PARTIALS FALSE
        FONT sc
        SIZE 8
        COLOR 0 0 0
        OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
        OUTLINEWIDTH 2
        PRIORITY 1
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
        MINFEATURESIZE AUTO
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas16"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 10156
   MINSCALEDENOM 5078
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea16"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 10156
    MINSCALEDENOM 5078
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways16"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 10156
    MINSCALEDENOM 5078
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 5
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 2
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
       ENCODING "utf-8"
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 8
        END
        LABEL
          TYPE TRUETYPE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
          PARTIALS FALSE
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 5078
    MAXSCALEDENOM 10156
    TYPE LINE
    NAME "railways16"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 5078
    MAXSCALEDENOM 10156
    NAME "roads16"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "motorway")
        STYLE
        END
        STYLE
            WIDTH 8
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 8
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "motorway_link")
        STYLE
        END
        STYLE
            WIDTH 7
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 7
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "trunk")
        STYLE
        END
        STYLE
            WIDTH 8
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 8
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "trunk_link")
        STYLE
        END
        STYLE
            WIDTH 7
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 7
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]" = "primary" or "[type]" = "primary_link"))
        STYLE
        END
        STYLE
            WIDTH 7
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 7
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]" = "secondary" or "[type]" = "secondary_link"))
        STYLE
        END
        STYLE
            WIDTH 6
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 6
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]"= "tertiary" or "[type]"="tertiary_link"))
        STYLE
        END
        STYLE
            WIDTH 5
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 5
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]"="classified" or "[type]"="residential" or "[type]"="service" or "[type]"="road" or "[type]"="living_street"))
        STYLE
        END
        STYLE
            WIDTH 6
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 6
            COLOR 255 255 255
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = 'pedestrian')
        STYLE
        END
        STYLE
            WIDTH 2.5
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 2.5
            COLOR 250 250 245
        END
    END
    CLASS
        EXPRESSION ("[type]"="motorway" and "[tunnel]"="1")
        STYLE
            WIDTH 8
            COLOR 253 146 58
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="motorway_link" and "[tunnel]"="1")
        STYLE
            WIDTH 7
            COLOR 253 146 58
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="trunk" and "[tunnel]"="1")
        STYLE
            WIDTH 8
            COLOR 255 195 69
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="trunk_link" and "[tunnel]"="1")
        STYLE
            WIDTH 7
            COLOR 255 195 69
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="primary" or "[type]"="primary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 7
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="secondary" or "[type]"="secondary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 6
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="tertiary" or "[type]"="tertiary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 5
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (('[type]'='unclassified' or '[type]'='residential' or '[type]'='service' or "[type]"="living_street") and "[tunnel]"="1")
        STYLE
            WIDTH 6
            COLOR 255 255 255
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 8
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 8
            COLOR 253 146 58
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            PRIORITY 1
            FONT scb
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "motorway_link"
        STYLE
           WIDTH 7
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 7
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 8
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 8
            COLOR 255 195 69
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT scb
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "trunk_link"
        STYLE
           WIDTH 7
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 7
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
           WIDTH 7
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 7
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /secondary/
        STYLE
           WIDTH 6
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 6
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 9
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /tertiary/
        STYLE
           WIDTH 5
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 5
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /unclassified|residential|service|road|living_street/
        STYLE
           WIDTH 6
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 6
            COLOR 255 255 255
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "track"
        STYLE
            PATTERN 2 3 END
            WIDTH 1
            COLOR "#ffffff"
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION 'footway'
        STYLE
            PATTERN 2 3 END
            WIDTH 1
            COLOR "#ffffff"
        END
    END
    CLASS
        EXPRESSION 'pedestrian'
        STYLE
           WIDTH 2.5
           OUTLINEWIDTH 0.5
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 2.5
            COLOR 250 250 245
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    MINSCALEDENOM 5078
    MAXSCALEDENOM 10156
    TYPE LINE
    NAME "aeroways16"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type from osm_aeroways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    CLASS
      EXPRESSION "runway"
      STYLE
        COLOR 180 180 180
        WIDTH 15
        LINECAP BUTT
        LINEJOIN MITER
      END
      STYLE
        COLOR 80 80 80
        WIDTH 1
        PATTERN 2 2 END
        LINECAP BUTT
      END
    END
    CLASS
      EXPRESSION "taxiway"
      STYLE
        COLOR 180 180 180
        WIDTH 3
      END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 10156
   MINSCALEDENOM 5078
   TYPE LINE
   NAME "borders16"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places16"
   MINSCALEDENOM 5078
   MAXSCALEDENOM 10156
   DATA "geometry from (select * from osm_places where name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'town'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 11
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'village'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 10
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            BUFFER 4
            POSITION AUTO
        END
    END
    CLASS
        EXPRESSION /suburb|hamlet|locality/
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 9
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION AUTO
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land17"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 2539
   MAXSCALEDENOM 5078
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse17"
    opacity 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','pedestrian','cemetery','industrial','commercial',      'brownfield','residential','school','college','university',      'military','park','golf_course','hospital','parking','stadium','sports_center',      'pitch') order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 5078
    MINSCALEDENOM 2539
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR "#333333"
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
     LABEL
       ENCODING "utf-8"
       TYPE TRUETYPE
       FONT sc
       SIZE 8
       COLOR 0 0 0
       OUTLINECOLOR 255 255 255
       OUTLINEWIDTH 2
       PRIORITY 2
       WRAP ' '
       MAXLENGTH 6
       ALIGN CENTER
       MINFEATURESIZE AUTO
       PARTIALS FALSE
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
       ENCODING "utf-8"
            SIZE 8
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            PRIORITY 2
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
            MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 2
          POSITION cc
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
         LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
      LABEL
        TYPE TRUETYPE
        PARTIALS FALSE
        FONT sc
        SIZE 8
        COLOR 0 0 0
        OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
        OUTLINEWIDTH 2
        PRIORITY 1
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
        MINFEATURESIZE AUTO
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas17"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 5078
   MINSCALEDENOM 2539
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea17"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 5078
    MINSCALEDENOM 2539
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways17"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 5078
    MINSCALEDENOM 2539
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 6
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 2
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
       ENCODING "utf-8"
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 16
        END
        LABEL
          TYPE TRUETYPE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
          PARTIALS FALSE
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 2539
    MAXSCALEDENOM 5078
    TYPE LINE
    NAME "railways17"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 2539
    MAXSCALEDENOM 5078
    NAME "roads17"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "motorway")
        STYLE
        END
        STYLE
            WIDTH 9
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 9
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "motorway_link")
        STYLE
        END
        STYLE
            WIDTH 8
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 8
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "trunk")
        STYLE
        END
        STYLE
            WIDTH 9
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 9
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "trunk_link")
        STYLE
        END
        STYLE
            WIDTH 8
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 8
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]" = "primary" or "[type]" = "primary_link"))
        STYLE
        END
        STYLE
            WIDTH 8
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 8
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]" = "secondary" or "[type]" = "secondary_link"))
        STYLE
        END
        STYLE
            WIDTH 7
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 7
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]"= "tertiary" or "[type]"="tertiary_link"))
        STYLE
        END
        STYLE
            WIDTH 6
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 6
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]"="classified" or "[type]"="residential" or "[type]"="service" or "[type]"="road" or "[type]"="living_street"))
        STYLE
        END
        STYLE
            WIDTH 6
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 6
            COLOR 255 255 255
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = 'pedestrian')
        STYLE
        END
        STYLE
            WIDTH 3
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 3
            COLOR 250 250 245
        END
    END
    CLASS
        EXPRESSION ("[type]"="motorway" and "[tunnel]"="1")
        STYLE
            WIDTH 9
            COLOR 253 146 58
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="motorway_link" and "[tunnel]"="1")
        STYLE
            WIDTH 8
            COLOR 253 146 58
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="trunk" and "[tunnel]"="1")
        STYLE
            WIDTH 9
            COLOR 255 195 69
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="trunk_link" and "[tunnel]"="1")
        STYLE
            WIDTH 8
            COLOR 255 195 69
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="primary" or "[type]"="primary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 8
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="secondary" or "[type]"="secondary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 7
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="tertiary" or "[type]"="tertiary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 6
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (('[type]'='unclassified' or '[type]'='residential' or '[type]'='service' or "[type]"="living_street") and "[tunnel]"="1")
        STYLE
            WIDTH 6
            COLOR 255 255 255
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 9
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 9
            COLOR 253 146 58
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            PRIORITY 1
            FONT scb
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "motorway_link"
        STYLE
           WIDTH 8
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 8
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 9
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 9
            COLOR 255 195 69
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT scb
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "trunk_link"
        STYLE
           WIDTH 8
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 8
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
           WIDTH 8
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 8
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /secondary/
        STYLE
           WIDTH 7
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 7
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 9
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /tertiary/
        STYLE
           WIDTH 6
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 6
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /unclassified|residential|service|road|living_street/
        STYLE
           WIDTH 6
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 6
            COLOR 255 255 255
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "track"
        STYLE
            PATTERN 2 3 END
            WIDTH 1
            COLOR "#ffffff"
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION 'footway'
        STYLE
            PATTERN 2 3 END
            WIDTH 1
            COLOR "#ffffff"
        END
    END
    CLASS
        EXPRESSION 'pedestrian'
        STYLE
           WIDTH 3
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 3
            COLOR 250 250 245
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    MINSCALEDENOM 2539
    MAXSCALEDENOM 5078
    TYPE LINE
    NAME "aeroways17"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type from osm_aeroways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    CLASS
      EXPRESSION "runway"
      STYLE
        COLOR 180 180 180
        WIDTH 19
        LINECAP BUTT
        LINEJOIN MITER
      END
      STYLE
        COLOR 80 80 80
        WIDTH 1
        PATTERN 2 2 END
        LINECAP BUTT
      END
    END
    CLASS
      EXPRESSION "taxiway"
      STYLE
        COLOR 180 180 180
        WIDTH 4
      END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 5078
   MINSCALEDENOM 2539
   TYPE LINE
   NAME "borders17"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places17"
   MINSCALEDENOM 2539
   MAXSCALEDENOM 5078
   DATA "geometry from (select * from osm_places where name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'town'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 11
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'village'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 10
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            BUFFER 4
            POSITION AUTO
        END
    END
    CLASS
        EXPRESSION /suburb|hamlet|locality/
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 9
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION AUTO
        END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   GROUP "landdefault"
   DEBUG 1
   NAME "land18"
   PROJECTION
       "+init=epsg:900913"
   END
   MINSCALEDENOM 0
   MAXSCALEDENOM 2539
   DATA "data/processed_p"
   CLASS
       STYLE
           COLOR 242 239 233
       END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "landuse18"
    opacity 70
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry ,osm_id, type, name from osm_landusages       where type in ('forest','pedestrian','cemetery','industrial','commercial',      'brownfield','residential','school','college','university',      'military','park','golf_course','hospital','parking','stadium','sports_center',      'pitch') order by area desc) as foo using unique osm_id using srid=3857"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 2539
    MINSCALEDENOM 0
    CLASSITEM "type"
    LABELITEM "name"
    CLASS
       EXPRESSION /forest|wood/
       STYLE
          COLOR 203 216 195
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
    END
    CLASS
       EXPRESSION 'residential'
       STYLE
          COLOR 242 239 233
       END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR 0 0 0
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
      EXPRESSION 'pedestrian'
      STYLE
         COLOR 250 250 245
      END
      LABEL
         TYPE TRUETYPE
         FONT sc
         SIZE 8
         COLOR "#333333"
         OUTLINECOLOR 255 255 255
         OUTLINEWIDTH 2
         WRAP ' '
         MAXLENGTH 6
         ALIGN CENTER
         MINFEATURESIZE AUTO
         PARTIALS FALSE
      END
   END
   CLASS
     EXPRESSION /industrial|commercial|parking/
     STYLE
       COLOR 209 208 205
     END
     LABEL
       ENCODING "utf-8"
       TYPE TRUETYPE
       FONT sc
       SIZE 8
       COLOR 0 0 0
       OUTLINECOLOR 255 255 255
       OUTLINEWIDTH 2
       PRIORITY 2
       WRAP ' '
       MAXLENGTH 6
       ALIGN CENTER
       MINFEATURESIZE AUTO
       PARTIALS FALSE
     END
    END
    CLASS
        EXPRESSION 'cemetery'
        STYLE
          COLOR "#d1d1d1"
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
       ENCODING "utf-8"
            SIZE 8
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            PRIORITY 2
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
            MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /park|golf_course/
        STYLE
            COLOR 181 210 156
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 2
          POSITION cc
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION 'hospital'
        STYLE
            COLOR 229 198 195
        END
         LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
        EXPRESSION /school|college|university/
        STYLE
            COLOR 222 210 172
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          SIZE 8
       ENCODING "utf-8"
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          PRIORITY 1
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
    CLASS
      EXPRESSION /sports_center|stadium|pitch/
      STYLE
          COLOR "#DED1AB"
      END
      LABEL
        TYPE TRUETYPE
        PARTIALS FALSE
        FONT sc
        SIZE 8
        COLOR 0 0 0
        OUTLINECOLOR 255 255 255
       ENCODING "utf-8"
        OUTLINEWIDTH 2
        PRIORITY 1
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
        MINFEATURESIZE AUTO
      END
    END
END
LAYER
   TYPE POLYGON
   STATUS ON
   PROJECTION
       "init=epsg:3857"
   END
   NAME "transport_areas18"
   GROUP "default"
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   DATA "geometry from osm_transport_areas using unique osm_id using srid=3857"
   PROCESSING "CLOSE_CONNECTION=DEFER"
   MAXSCALEDENOM 2539
   MINSCALEDENOM 0
   LABELITEM "name"
   CLASS
      STYLE
         COLOR 200 200 200
      END
   END
END
LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:3857"
    END
    NAME "waterarea18"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry,osm_id ,name,type from osm_waterareas) as foo using unique osm_id using srid=3857"
    MAXSCALEDENOM 2539
    MINSCALEDENOM 0
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
      EXPRESSION "riverbank"
        STYLE
            COLOR 153 179 204
        END
    END
    CLASS
        STYLE
            COLOR 153 179 204
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
          MINFEATURESIZE AUTO
        END
    END
END
LAYER
    TYPE LINE
    STATUS ON
    NAME "waterways18"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type, name from osm_waterways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    MAXSCALEDENOM 2539
    MINSCALEDENOM 0
    LABELITEM "name"
    PROJECTION
        "init=epsg:3857"
    END
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR 153 179 204
            WIDTH 7
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
       ENCODING "utf-8"
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "stream"
        STYLE
            COLOR 153 179 204
            WIDTH 2
        END
        LABEL
          TYPE TRUETYPE
          PARTIALS FALSE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
       ENCODING "utf-8"
          ANGLE FOLLOW
          BUFFER 3
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR 153 179 204
            WIDTH 30
        END
        LABEL
          TYPE TRUETYPE
          FONT sc
          MINDISTANCE 400
          SIZE 8
          COLOR "#6B94B0"
       ENCODING "utf-8"
          OUTLINECOLOR 255 255 255
          OUTLINEWIDTH 2
          MINFEATURESIZE AUTO
          ANGLE FOLLOW
          BUFFER 3
          PARTIALS FALSE
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    MINSCALEDENOM 0
    MAXSCALEDENOM 2539
    TYPE LINE
    NAME "railways18"
    DATA "geometry from (select geometry, osm_id, tunnel from osm_railways where type='rail') as foo using unique osm_id using srid=3857"
    CLASS
      EXPRESSION ([tunnel]=0)
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         LINECAP BUTT
        END
    END
    CLASS
        STYLE
         WIDTH 1
         COLOR "#777777"
         PATTERN 2 2 END
         OPACITY 40
         LINECAP BUTT
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    TYPE LINE
    MINSCALEDENOM 0
    MAXSCALEDENOM 2539
    NAME "roads18"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select osm_id,geometry,name,ref,type,tunnel,bridge from osm_roads order by z_order asc, st_length(geometry) asc) as foo using unique osm_id using srid=3857"
    LABELITEM "name"
    CLASSITEM "type"
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "motorway")
        STYLE
        END
        STYLE
            WIDTH 10
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 10
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "motorway_link")
        STYLE
        END
        STYLE
            WIDTH 9
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 9
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "trunk")
        STYLE
        END
        STYLE
            WIDTH 10
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 10
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = "trunk_link")
        STYLE
        END
        STYLE
            WIDTH 9
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 9
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]" = "primary" or "[type]" = "primary_link"))
        STYLE
        END
        STYLE
            WIDTH 9
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 9
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]" = "secondary" or "[type]" = "secondary_link"))
        STYLE
        END
        STYLE
            WIDTH 8
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 8
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]"= "tertiary" or "[type]"="tertiary_link"))
        STYLE
        END
        STYLE
            WIDTH 7
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 7
            COLOR 255 253 139
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and ("[type]"="classified" or "[type]"="residential" or "[type]"="service" or "[type]"="road" or "[type]"="living_street"))
        STYLE
        END
        STYLE
            WIDTH 6
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 6
            COLOR 255 255 255
        END
    END
    CLASS
        EXPRESSION ("[bridge]"="1" and "[type]" = 'pedestrian')
        STYLE
        END
        STYLE
            WIDTH 3.5
            OUTLINECOLOR 136 136 136
            OUTLINEWIDTH 1
            LINECAP BUTT
        END
        STYLE
            WIDTH 3.5
            COLOR 250 250 245
        END
    END
    CLASS
        EXPRESSION ("[type]"="motorway" and "[tunnel]"="1")
        STYLE
            WIDTH 10
            COLOR 253 146 58
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="motorway_link" and "[tunnel]"="1")
        STYLE
            WIDTH 9
            COLOR 253 146 58
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="trunk" and "[tunnel]"="1")
        STYLE
            WIDTH 10
            COLOR 255 195 69
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION ("[type]"="trunk_link" and "[tunnel]"="1")
        STYLE
            WIDTH 9
            COLOR 255 195 69
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="primary" or "[type]"="primary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 9
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="secondary" or "[type]"="secondary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 8
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (("[type]"="tertiary" or "[type]"="tertiary_link") and "[tunnel]"="1")
        STYLE
            WIDTH 7
            COLOR 255 253 139
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION (('[type]'='unclassified' or '[type]'='residential' or '[type]'='service' or "[type]"="living_street") and "[tunnel]"="1")
        STYLE
            WIDTH 6
            COLOR 255 255 255
            OPACITY 40
        END
    END
    CLASS
        EXPRESSION "motorway"
        TEXT ("[ref]")
        STYLE
           WIDTH 10
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 10
            COLOR 253 146 58
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            PRIORITY 1
            FONT scb
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "motorway_link"
        STYLE
           WIDTH 9
           OUTLINEWIDTH 1
           OUTLINECOLOR 186 110 39
        END
        STYLE
            WIDTH 9
            COLOR 253 146 58
        END
    END
    CLASS
        EXPRESSION "trunk"
        TEXT ("[ref]")
        STYLE
           WIDTH 10
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 10
            COLOR 255 195 69
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT scb
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#555555"
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "trunk_link"
        STYLE
           WIDTH 9
           OUTLINEWIDTH 1
           OUTLINECOLOR 221 159 17
        END
        STYLE
            WIDTH 9
            COLOR 255 195 69
        END
    END
    CLASS
        EXPRESSION /primary/
        STYLE
           WIDTH 9
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 9
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 9
            MINDISTANCE 400
            MINFEATURESIZE AUTO
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            ANGLE FOLLOW
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /secondary/
        STYLE
           WIDTH 8
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 8
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 9
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /tertiary/
        STYLE
           WIDTH 7
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 7
            COLOR 255 253 139
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION /unclassified|residential|service|road|living_street/
        STYLE
           WIDTH 6
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 6
            COLOR 255 255 255
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION "track"
        STYLE
            PATTERN 2 3 END
            WIDTH 1
            COLOR "#ffffff"
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
    CLASS
        EXPRESSION 'footway'
        STYLE
            PATTERN 2 3 END
            WIDTH 1
            COLOR "#ffffff"
        END
    END
    CLASS
        EXPRESSION 'pedestrian'
        STYLE
           WIDTH 3.5
           OUTLINEWIDTH 1
           OUTLINECOLOR 193 181 157
        END
        STYLE
            WIDTH 3.5
            COLOR 250 250 245
        END
        LABEL
            TYPE TRUETYPE
            PARTIALS FALSE
            FONT sc
            SIZE 8
            MINDISTANCE 400
            ANGLE FOLLOW
            COLOR "#333333"
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            MINFEATURESIZE AUTO
            BUFFER 3
        END
    END
END
LAYER
    GROUP "default"
    STATUS ON
    MINSCALEDENOM 0
    MAXSCALEDENOM 2539
    TYPE LINE
    NAME "aeroways18"
    CONNECTIONTYPE postgis
    CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
    DATA "geometry from (select geometry, osm_id, type from osm_aeroways) as foo using unique osm_id using srid=3857"
    CLASSITEM "type"
    CLASS
      EXPRESSION "runway"
      STYLE
        COLOR 180 180 180
        WIDTH 23
        LINECAP BUTT
        LINEJOIN MITER
      END
      STYLE
        COLOR 80 80 80
        WIDTH 1
        PATTERN 2 2 END
        LINECAP BUTT
      END
    END
    CLASS
      EXPRESSION "taxiway"
      STYLE
        COLOR 180 180 180
        WIDTH 5
      END
    END
END
LAYER
   GROUP "default"
   STATUS ON
   MAXSCALEDENOM 2539
   MINSCALEDENOM 0
   TYPE LINE
   NAME "borders18"
   PROJECTION
     "+init=epsg:4326"
   END
   DATA "data/boundaries.shp"
   CLASS
      STYLE
         WIDTH 5
         COLOR "#CDCBC6"
         OPACITY 50
      END
      STYLE
         WIDTH 1
         COLOR "#8d8b8d"
      END
   END
END
LAYER
   STATUS ON
   GROUP "default"
   TYPE ANNOTATION
   CONNECTIONTYPE postgis
   CONNECTION "host=linux_db_bm dbname=osm user=postgres password=postgres port=5432"
   NAME "places18"
   MINSCALEDENOM 0
   MAXSCALEDENOM 2539
   DATA "geometry from (select * from osm_places where name is not NULL order by population asc nulls first) as foo using unique osm_id using srid=3857"
   LABELITEM 'name'
   CLASSITEM 'type'
    CLASS
        EXPRESSION 'town'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 11
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            POSITION AUTO
            BUFFER 4
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'village'
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 10
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            PARTIALS FALSE
            BUFFER 4
            POSITION AUTO
        END
    END
    CLASS
        EXPRESSION /suburb|hamlet|locality/
        LABEL
            FONT sc
            TYPE TRUETYPE
            ENCODING "utf-8"
            SIZE 9
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            OUTLINEWIDTH 2
            WRAP ' '
            MAXLENGTH 8
            ALIGN CENTER
            BUFFER 4
            PARTIALS FALSE
            POSITION AUTO
        END
    END
END
SYMBOL
 name "citycircle"
 type ellipse
 points 1 1 end
 filled true
END
END