Rendering OpenStreetMap in MapServer 5.4 + PostgreSQL

Following the tutorial on http://latuviitta.org/documents/Super_easy_WMS_server.pdf , and loading the zipped map file from http://latuviitta.org/documents/osm_maps.zip, I managed to get mapserver 5.4 to render the OSM Australia data. Had to tweak a few things as the original map file contains new syntax that only Map Server 6.0 understands, such as INCLUDE within a LABEL.
 
 2 PostgreSQL Views must be created for this:
#1.
CREATE or replace VIEW forestBodies ( way, osm_id, nature, landuse, highway, name, waterway ) AS select way, osm_id ,"natural",landuse ,highway, name, waterway from planet_osm_polygon where "natural"='wood' or highway='pedestrian';
#2
CREATE or replace VIEW waterBodies (way, osm_id, nature, name) as select way,osm_id ,"natural", name from planet_osm_polygon where "natural"='water' or landuse='basin' or landuse='reservoir' or waterway='riverbank'
 
 
Example Map File to use with MapServer 5.4
MAP
  EXTENT 12890565.9626553 -3762297.63148717 12904434.5486696 -3753266.69377518
  FONTSET "C:\Program Files (x86)\MapManager15\templates\font.list"
  IMAGECOLOR 255 255 255
  IMAGETYPE aggpng24
  RESOLUTION 96.000000
  SYMBOLSET "C:\Program Files (x86)\MapManager15\templates\symbols.sym"
  SHAPEPATH ""
  SIZE 1400 912
  STATUS ON
  UNITS METERS
  NAME "MS"

  OUTPUTFORMAT
    NAME "aggpng24"
    MIMETYPE "image/png; mode=24bit"
    DRIVER "AGG/PNG"
    EXTENSION "png"
    IMAGEMODE "RGB"
    TRANSPARENT FALSE
  END

  OUTPUTFORMAT
    NAME "png24"
    MIMETYPE "image/png; mode=24bit"
    DRIVER "GD/PNG"
    EXTENSION "png"
    IMAGEMODE "RGB"
    TRANSPARENT FALSE
  END

  SYMBOL
    NAME "rail"
    TYPE SIMPLE
  END

  SYMBOL
    NAME "railfar"
    TYPE SIMPLE
    PATTERN
      5 5
    END
  END

  SYMBOL
    NAME "path"
    TYPE SIMPLE
    PATTERN
      1 1
    END
  END

  SYMBOL
    NAME "track"
    TYPE SIMPLE
    PATTERN
      5 5
    END
  END

  SYMBOL
    NAME "tunnel"
    TYPE SIMPLE
    PATTERN
      2 2
    END
  END

  SYMBOL
    NAME "citycircle"
    TYPE SIMPLE
    PATTERN
      2 2
    END
  END

  SYMBOL
    NAME "dash"
    TYPE SIMPLE
    PATTERN
      2 2
    END
  END

  SYMBOL
    NAME "butt"
    TYPE SIMPLE
  END

  PROJECTION
    "proj=merc"
    "a=6378137"
    "b=6378137"
    "lat_ts=0.0"
    "lon_0=0.0"
    "x_0=0.0"
    "y_0=0"
    "k=1.0"
    "units=m"
    "nadgrids=@null"
    "wktext"
    "no_defs"
  END
  LEGEND
    IMAGECOLOR 255 255 255
    KEYSIZE 20 10
    KEYSPACING 5 5
    LABEL
      SIZE MEDIUM
      TYPE BITMAP
      BUFFER 0
      COLOR 0 0 0
      FORCE FALSE
      MINDISTANCE -1
      MINFEATURESIZE -1
      OFFSET 0 0
      PARTIALS TRUE
    END
    POSITION LL
    STATUS OFF
  END

  QUERYMAP
    COLOR 255 255 0
    SIZE -1 -1
    STATUS OFF
    STYLE HILITE
  END

  SCALEBAR
    ALIGN CENTER
    COLOR 0 0 0
    INTERVALS 4
    LABEL
      SIZE MEDIUM
      TYPE BITMAP
      BUFFER 0
      COLOR 0 0 0
      FORCE FALSE
      MINDISTANCE -1
      MINFEATURESIZE -1
      OFFSET 0 0
      PARTIALS TRUE
    END
    POSITION LL
    SIZE 200 3
    STATUS OFF
    STYLE 0
    UNITS MILES
  END

  WEB
    IMAGEPATH ""
    IMAGEURL ""
    METADATA
      "distance_units"    "MS_METERS"
      "mapmanager_version"    "1.5.9.0"
      "coordsys_name"    "Popular Visualisation CRS / Mercator (deprecated)"
    END
    QUERYFORMAT text/html
    LEGENDFORMAT text/html
    BROWSEFORMAT text/html
  END

  LAYER
    CONNECTION "C:\work\data\STE11aAust.shp"
    CONNECTIONTYPE OGR
    METADATA
      "coordsys_name"    "Longitude-Latitude / GDA94"
    END
    NAME "STE11aAust"
    PROJECTION
      "proj=longlat"
      "ellps=GRS80"
      "towgs84=0,0,0,0,0,0,0"
      "no_defs"
    END
    STATUS OFF
    TEMPLATE "query.html"
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "Class (0)"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 8
        TYPE TRUETYPE
        BUFFER 0
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        PARTIALS TRUE
        POSITION CC
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        OUTLINECOLOR 0 0 0
        SIZE 8
        SYMBOL 0
        WIDTH 1
      END
      TEMPLATE "query.html"
    END
  END

  LAYER
    CLASSITEM "landuse"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,landuse, name from planet_osm_polygon where landuse is not null) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 1.00001e+006
    NAME "landuse_layer1_1000k"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE POLYGON
    UNITS METERS
    CLASS
      EXPRESSION ('[landuse]'='industrial' or '[landuse]'='commercial' or '[landuse]'='airport' or '[landuse]'='brownfield' or '[landuse]'='military' or '[landuse]'='railway')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 0
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        MAXSCALEDENOM 30000
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        PARTIALS TRUE
        POSITION CC
        PRIORITY 2
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 235 229 217
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION ('[landuse]'='residential')
      STYLE
        ANGLE 360
        COLOR 246 241 230
        SYMBOL 0
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "landuse"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,landuse, name from planet_osm_polygon where landuse is not null) as foo using unique osm_id using srid=900913"
    LABELITEM "name"
    MAXSCALEDENOM 1.00001e+006
    NAME "landuse_industrial_1000k"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE POLYGON
    UNITS METERS
    CLASS
      EXPRESSION ('[landuse]'='industrial' or '[landuse]'='commercial' or '[landuse]'='airport' or '[landuse]'='brownfield' or '[landuse]'='military' or '[landuse]'='railway')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 10
        TYPE TRUETYPE
        BUFFER 0
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION CC
        PRIORITY 2
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 235 229 217
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION ('[landuse]'='residential')
      STYLE
        ANGLE 360
        COLOR 246 241 230
        SYMBOL 0
        WIDTH 1
      END
    END
  END

  LAYER
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,leisure , landuse, name from planet_osm_polygon where leisure='park' or leisure='golf_course' or landuse='recreation_ground' or landuse='cemetery' )  as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 500000
    NAME "landuse_leisure_cemetery_500k"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE POLYGON
    UNITS METERS
    CLASS
      EXPRESSION ('[landuse]'='cemetery')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 0
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        MAXSCALEDENOM 30000
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        PARTIALS TRUE
        POSITION CC
        PRIORITY 2
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 235 229 217
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 0
        COLOR 61 96 53
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        MAXSCALEDENOM 30000
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        PARTIALS TRUE
        POSITION CC
        PRIORITY 2
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 220 220 180
        SYMBOL 0
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "landuse"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,nature, landuse ,highway, name from forestBodies) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 5.00001e+006
    NAME "landuse_forest_5000k"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE POLYGON
    UNITS METERS
    CLASS
      EXPRESSION ('[nature]'='wood' or '[landuse]'='forest')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 0
        COLOR 61 96 53
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE 20
        MAXSCALEDENOM 600000
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        PARTIALS TRUE
        POSITION CC
        PRIORITY 2
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 220 220 180
        OUTLINEWIDTH 0.3
        OUTLINECOLOR 220 220 180
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION ('[landuse]'='grass' or '[landuse]'='greenfield' or '[landuse]'='allotments' or '[landuse]'='meadow' or '[landuse]'='field')
      STYLE
        ANGLE 360
        COLOR 218 222 173
        OUTLINEWIDTH 0.3
        OUTLINECOLOR 218 222 173
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION ('[highway]'='pedestrian')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 0
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        MAXSCALEDENOM 11000
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        PARTIALS TRUE
        POSITION CC
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 250 250 245
        SYMBOL 0
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "waterway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,waterway,osm_id from planet_osm_line where waterway is not null) as foo using unique osm_id using srid=900913"
    GROUP "default"
    MAXSCALEDENOM 1.5e+006
    NAME "landuse_river"
    SIZEUNITS METERS
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION "river"
      STYLE
        ANGLE 360
        COLOR 179 198 212
        MINWIDTH 0.5
        SYMBOL 0
        WIDTH 30
      END
    END
    CLASS
      EXPRESSION "stream"
      MAXSCALEDENOM 105000
      STYLE
        ANGLE 360
        COLOR 179 198 212
        MINWIDTH 0.5
        SYMBOL 0
        WIDTH 5
      END
    END
    CLASS
      EXPRESSION "canal"
      STYLE
        ANGLE 360
        COLOR 179 198 212
        MINWIDTH 0.5
        SYMBOL 0
        WIDTH 10
      END
    END
  END

  LAYER
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,nature, name from waterBodies)  as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    NAME "landuse_waterbodies"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE POLYGON
    UNITS METERS
    CLASS
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 8
        TYPE TRUETYPE
        BUFFER 0
        COLOR 107 148 176
        FORCE FALSE
        MINDISTANCE 400
        MINFEATURESIZE -1
        MAXSCALEDENOM 110000
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        PARTIALS TRUE
        POSITION CC
        WRAP ' '
        MAXLENGTH 5
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 179 198 212
        OUTLINECOLOR 179 198 212
        SYMBOL 0
        WIDTH 0.5
      END
    END
  END

  LAYER
    CLASSITEM "amenity"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id,amenity,aeroway, name from planet_osm_polygon where amenity is not null or aeroway='apron') as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 110000
    NAME "landuse_hospital_amenity_110k"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE POLYGON
    UNITS METERS
    CLASS
      EXPRESSION "hospital"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 0
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        MAXSCALEDENOM 15000
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        PARTIALS TRUE
        POSITION CC
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 230 200 195
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION ("[amenity]"="parking" or "[aeroway]"="apron")
      STYLE
        ANGLE 360
        COLOR 235 229 217
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION ("[amenity]"="restaurant" or "[amenity]"="cafe")
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 0
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        MAXSCALEDENOM 15000
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        PARTIALS TRUE
        POSITION CC
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 200 200 200
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION ("[amenity]"="school" or "[amenity]"="college" or "[amenity]"="university" )
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 0
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        MAXSCALEDENOM 15000
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        PARTIALS TRUE
        POSITION CC
        WRAP ' '
        MAXLENGTH 6
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 222 209 171
        SYMBOL 0
        WIDTH 1
      END
    END
  END

  LAYER
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id from planet_osm_polygon where building is not null) as foo using unique osm_id using srid=900913"
    NAME "buildings"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE POLYGON
    UNITS METERS
    CLASS
      STYLE
        ANGLE 360
        COLOR 188 169 169
        SYMBOL 0
        WIDTH 1
      END
    END
  END

  LAYER
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,railway, name from planet_osm_line where railway='rail') as foo using unique osm_id using srid=900913"
    NAME "railways"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      STYLE
        ANGLE 360
        COLOR 255 255 255
        OUTLINEWIDTH 1
        OUTLINECOLOR 85 85 84
        SYMBOL 0
        WIDTH 2
      END
      STYLE
        ANGLE 360
        COLOR 85 85 84
        SIZE 5
        SYMBOL "rail"
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "place"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,place , name from planet_osm_point where place is not null) as foo using unique osm_id using srid=900913"
    LABELITEM "name"
    MAXSCALEDENOM 25010
    MINSCALEDENOM 10010
    NAME "places_25k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE ANNOTATION
    UNITS METERS
    CLASS
      EXPRESSION ('[place]'='suburb' or '[place]'='hamlet')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 6
        TYPE TRUETYPE
        BUFFER 4
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION CC
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
    END
  END

  LAYER
    CLASSITEM "place"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,place , name from planet_osm_point where place is not null) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 50010
    MINSCALEDENOM 25010
    NAME "places_50k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE ANNOTATION
    UNITS METERS
    CLASS
      EXPRESSION ('[place]'='village')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
    END
    CLASS
      EXPRESSION ('[place]'='suburb' or '[place]'='hamlet')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 8
        TYPE TRUETYPE
        BUFFER 4
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION CC
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
    END
  END

  LAYER
    CLASSITEM "place"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,place , name from planet_osm_point where place is not null) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 100010
    MINSCALEDENOM 50010
    NAME "places_100k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE ANNOTATION
    UNITS METERS
    CLASS
      EXPRESSION "town"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 8
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
    END
    CLASS
      EXPRESSION ('[place]'='village')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 8
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
    END
    CLASS
      EXPRESSION ('[place]'='suburb' or '[place]'='hamlet')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 4
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION CC
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
    END
  END

  LAYER
    CLASSITEM "place"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,place , name, capital from planet_osm_point where place is not null) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 250010
    MINSCALEDENOM 100010
    NAME "places_250k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE ANNOTATION
    UNITS METERS
    CLASS
      EXPRESSION ("[place]"="city" and "[capital]"="yes")
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 10
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 103 103
        OUTLINECOLOR 0 0 0
        SIZE 5
        SYMBOL "citycircle"
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 0 0 0
        SIZE 2
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "city"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 9
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 187 0
        OUTLINECOLOR 0 0 0
        SIZE 5
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "town"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 8
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        OUTLINECOLOR 0 0 0
        SIZE 4
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION ('[place]'='village')
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        OUTLINECOLOR 0 0 0
        SIZE 3
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "place"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,capital,place , name from planet_osm_point where place is not null) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 500010
    MINSCALEDENOM 250010
    NAME "places_500k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE ANNOTATION
    UNITS METERS
    CLASS
      EXPRESSION ("[place]"="city" and "[capital]"="yes")
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 10
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 103 103
        OUTLINECOLOR 0 0 0
        SIZE 6
        SYMBOL "citycircle"
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 0 0 0
        SIZE 2
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "city"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 9
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 187 0
        OUTLINECOLOR 0 0 0
        SIZE 5
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "town"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 8
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        OUTLINECOLOR 0 0 0
        SIZE 4
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "place"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,place, capital, name from planet_osm_point where place in ('town','city'))  as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 1.00001e+006
    MINSCALEDENOM 500010
    NAME "places_1000k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE ANNOTATION
    UNITS METERS
    CLASS
      EXPRESSION ("[place]"="city" and "[capital]"="yes")
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 10
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 103 103
        OUTLINECOLOR 0 0 0
        SIZE 6
        SYMBOL "citycircle"
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 0 0 0
        SIZE 2
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "city"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 9
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 187 0
        OUTLINECOLOR 0 0 0
        SIZE 5
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "town"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 8
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        OUTLINECOLOR 0 0 0
        SIZE 4
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "place"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,place ,capital, name from planet_osm_point where place in ('town','city')) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 2.50001e+006
    MINSCALEDENOM 1.00001e+006
    NAME "places_2500k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE ANNOTATION
    UNITS METERS
    CLASS
      EXPRESSION ("[place]"="city" and "[capital]"="yes")
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 10
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 10
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 103 103
        OUTLINECOLOR 0 0 0
        SIZE 6
        SYMBOL "citycircle"
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 0 0 0
        SIZE 2
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "city"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 9
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 187 0
        OUTLINECOLOR 0 0 0
        SIZE 5
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "town"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 3
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 8
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        OUTLINECOLOR 0 0 0
        SIZE 3
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "place"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,place ,capital, name from planet_osm_point where place in ('town','city')) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 5.00001e+006
    MINSCALEDENOM 2.50001e+006
    NAME "places_5000k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE ANNOTATION
    UNITS METERS
    CLASS
      EXPRESSION ("[place]"="city" and "[capital]"="yes")
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 10
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 103 103
        OUTLINECOLOR 0 0 0
        SIZE 7
        SYMBOL "citycircle"
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 0 0 0
        SIZE 2
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "city"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 8
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 9
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 187 0
        OUTLINECOLOR 0 0 0
        SIZE 5
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "place"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way,osm_id ,place ,capital, name from planet_osm_point where place in ('town','city')) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 1e+008
    MINSCALEDENOM 5.00001e+006
    NAME "places_10kk"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE ANNOTATION
    UNITS METERS
    CLASS
      EXPRESSION ("[place]"="city" and "[capital]"="yes")
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 10
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 103 103
        OUTLINECOLOR 0 0 0
        SIZE 7
        SYMBOL "citycircle"
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 0 0 0
        SIZE 2
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "city"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 8
        TYPE TRUETYPE
        BUFFER 10
        COLOR 0 0 0
        FORCE FALSE
        MINDISTANCE -1
        MINFEATURESIZE -1
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 4
        PARTIALS FALSE
        POSITION AUTO
        PRIORITY 9
        WRAP ' '
        MAXLENGTH 8
        ALIGN CENTER
      END
      STYLE
        ANGLE 360
        COLOR 255 187 0
        OUTLINECOLOR 0 0 0
        SIZE 5
        SYMBOL "citycircle"
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref, name, tunnel from planet_osm_line where highway is not null order by z_order) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 5010
    MINSCALEDENOM 0
    NAME "roads_5k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION ("[highway]"="motorway" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL "tunnel"
        WIDTH 15
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 15
      END
    END
    CLASS
      EXPRESSION ("[highway]"="motorway_link" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL "tunnel"
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION ("[highway]"="trunk" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 15
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 15
      END
    END
    CLASS
      EXPRESSION ("[highway]"="trunk_link" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION ("[highway]"="primary_link" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION ("[highway]"="primary" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 13
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 13
      END
    END
    CLASS
      EXPRESSION ("[highway]"="secondary_link" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION ("[highway]"="secondary" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 12
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 12
      END
    END
    CLASS
      EXPRESSION ("[highway]"="tertiary" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 183 172 154
        SYMBOL "tunnel"
        WIDTH 11
      END
      STYLE
        ANGLE 360
        COLOR 250 250 250
        SYMBOL 0
        WIDTH 11
      END
    END
    CLASS
      EXPRESSION (('[highway]'='unclassified' or '[highway]'='residential' or '[highway]'='service') and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 183 172 154
        SYMBOL "tunnel"
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 250 250 250
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "motorway"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 9
        TYPE TRUETYPE
        BUFFER 0
        COLOR 255 255 255
        FORCE FALSE
        MINDISTANCE 150
        MINFEATURESIZE -1
        OFFSET 0 0
        PARTIALS TRUE
        POSITION CC
        MAXLENGTH 6
      END
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 15
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 15
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "motorway_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "trunk"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 15
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 15
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "trunk_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "primary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 13
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 13
      END
    END
    CLASS
      EXPRESSION "secondary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "secondary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 12
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 12
      END
    END
    CLASS
      EXPRESSION "tertiary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 11
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 11
      END
    END
    CLASS
      EXPRESSION ('[highway]'='unclassified' or '[highway]'='residential' or '[highway]'='service' or '[highway]'='road')
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "track"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1.5
        OUTLINECOLOR 206 193 173
        SYMBOL 0
        WIDTH 3
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL "track"
        WIDTH 3
      END
    END
    CLASS
      EXPRESSION "footway"
      STYLE
        ANGLE 360
        COLOR 127 127 127
        SYMBOL "path"
        WIDTH 2
      END
    END
    CLASS
      EXPRESSION "pedestrian"
      STYLE
        ANGLE 360
        COLOR 250 250 245
        SYMBOL 0
        WIDTH 8
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref, name, tunnel from planet_osm_line where highway is not null order by z_order) as foo using unique osm_id using srid=900913"
    LABELITEM "name"
    MAXSCALEDENOM 10010
    MINSCALEDENOM 5010
    NAME "roads_10k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION ("[highway]"="motorway" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL "tunnel"
        WIDTH 15
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 15
      END
    END
    CLASS
      EXPRESSION ("[highway]"="motorway_link" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL "tunnel"
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION ("[highway]"="trunk" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 15
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 15
      END
    END
    CLASS
      EXPRESSION ("[highway]"="trunk_link" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION ("[highway]"="primary_link" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION ("[highway]"="primary" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 13
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 13
      END
    END
    CLASS
      EXPRESSION ("[highway]"="secondary_link" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION ("[highway]"="secondary" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINECOLOR 158 77 31
        SYMBOL "tunnel"
        WIDTH 12
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 12
      END
    END
    CLASS
      EXPRESSION ("[highway]"="tertiary" and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 183 172 154
        SYMBOL "tunnel"
        WIDTH 11
      END
      STYLE
        ANGLE 360
        COLOR 250 250 250
        SYMBOL 0
        WIDTH 11
      END
    END
    CLASS
      EXPRESSION (('[highway]'='unclassified' or '[highway]'='residential' or '[highway]'='service') and "[tunnel]"="yes")
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 183 172 154
        SYMBOL "tunnel"
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 250 250 250
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "motorway_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "motorway"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 15
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 15
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "trunk"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 15
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 15
      END
    END
    CLASS
      EXPRESSION "trunk_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "primary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 13
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 13
      END
    END
    CLASS
      EXPRESSION "secondary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "secondary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 12
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 12
      END
    END
    CLASS
      EXPRESSION "tertiary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 11
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 11
      END
    END
    CLASS
      EXPRESSION ('[highway]'='unclassified' or '[highway]'='residential' or '[highway]'='service' or '[highway]'='road')
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 10
      END
    END
    CLASS
      EXPRESSION "track"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1.5
        OUTLINECOLOR 206 193 173
        SYMBOL 0
        WIDTH 3
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL "track"
        WIDTH 3
      END
    END
    CLASS
      EXPRESSION "footway"
      STYLE
        ANGLE 360
        COLOR 127 127 127
        SYMBOL "path"
        WIDTH 2
      END
    END
    CLASS
      EXPRESSION "pedestrian"
      STYLE
        ANGLE 360
        COLOR 250 250 245
        SYMBOL 0
        WIDTH 8
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref, name, tunnel from planet_osm_line where highway is not null ) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 25010
    MINSCALEDENOM 10010
    NAME "roads_25k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION "motorway"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 10
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "motorway_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 6
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 6
      END
    END
    CLASS
      EXPRESSION "trunk"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 10
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 10
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "trunk_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 6
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 6
      END
    END
    CLASS
      EXPRESSION "primary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 7
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 7
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 8
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 8
      END
    END
    CLASS
      EXPRESSION "secondary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 6
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 6
      END
    END
    CLASS
      EXPRESSION "secondary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 7
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 7
      END
    END
    CLASS
      EXPRESSION "tertiary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 6
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 6
      END
    END
    CLASS
      EXPRESSION ('[highway]'='unclassified' or '[highway]'='residential' or '[highway]'='service' or '[highway]'='road')
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 4
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 4
      END
    END
    CLASS
      EXPRESSION "track"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1.5
        OUTLINECOLOR 206 193 173
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL "track"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "footway"
      STYLE
        ANGLE 360
        COLOR 127 127 127
        SYMBOL "path"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "pedestrian"
      STYLE
        ANGLE 360
        COLOR 151 140 122
        SYMBOL 0
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref, name, tunnel from planet_osm_line where highway is not null ) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 50010
    MINSCALEDENOM 25010
    NAME "roads_50k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION "motorway"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 8
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 8
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "motorway_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 4
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 4
      END
    END
    CLASS
      EXPRESSION "trunk"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 8
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 8
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "trunk_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 4
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 4
      END
    END
    CLASS
      EXPRESSION "primary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 7
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 7
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 6
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 6
      END
    END
    CLASS
      EXPRESSION "secondary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 6
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 6
      END
    END
    CLASS
      EXPRESSION "secondary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 5
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 5
      END
    END
    CLASS
      EXPRESSION "tertiary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 4
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 4
      END
    END
    CLASS
      EXPRESSION ('[highway]'='unclassified' or '[highway]'='residential' or '[highway]'='service' or '[highway]'='road')
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 2
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 2
      END
    END
    CLASS
      EXPRESSION "track"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1.5
        OUTLINECOLOR 206 193 173
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL "track"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "footway"
      STYLE
        ANGLE 360
        COLOR 127 127 127
        SYMBOL "path"
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "pedestrian"
      STYLE
        ANGLE 360
        COLOR 151 140 122
        SYMBOL 0
        WIDTH 0.5
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref, name, tunnel from planet_osm_line where highway is not null) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 100010
    MINSCALEDENOM 50010
    NAME "roads_100k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION "motorway"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 6
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 6
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "motorway_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 2
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 2
      END
    END
    CLASS
      EXPRESSION "trunk"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 6
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 6
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "trunk_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 2
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 2
      END
    END
    CLASS
      EXPRESSION "primary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 3
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 3
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 4
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 4
      END
    END
    CLASS
      EXPRESSION "secondary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 2
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 2
      END
    END
    CLASS
      EXPRESSION "secondary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 3
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 3
      END
    END
    CLASS
      EXPRESSION "tertiary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 2
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 2
      END
    END
    CLASS
      EXPRESSION ('[highway]'='unclassified' or '[highway]'='residential' or '[highway]'='service' or '[highway]'='road')
      STYLE
        ANGLE 360
        COLOR 119 119 119
        SYMBOL 0
        WIDTH 0.8
      END
    END
    CLASS
      EXPRESSION "track"
      STYLE
        ANGLE 360
        COLOR 206 193 173
        SYMBOL "track"
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref, name, tunnel from planet_osm_line where highway is not null ) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 250010
    MINSCALEDENOM 100010
    NAME "roads_250k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION "motorway"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 3
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 3
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "motorway_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "trunk"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 3
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 3
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "trunk_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "primary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 2
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 2
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 2
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 2
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "secondary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "secondary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "tertiary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 0.8
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 0.8
      END
    END
    CLASS
      EXPRESSION ('[highway]'='unclassified' or '[highway]'='residential' or '[highway]'='service' or '[highway]'='road')
      STYLE
        ANGLE 360
        COLOR 119 119 119
        SYMBOL 0
        WIDTH 0.5
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref, name, tunnel from planet_osm_line where highway is not null) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 500010
    MINSCALEDENOM 250010
    NAME "roads_500k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION "motorway"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 1.5
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 1.5
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "motorway_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "trunk"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 1.5
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 1.5
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "trunk_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "primary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 1.5
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 1.5
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "secondary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 0.8
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 0.8
      END
    END
    CLASS
      EXPRESSION "secondary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 0.8
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 0.8
      END
    END
    CLASS
      EXPRESSION "tertiary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 151 140 122
        SYMBOL 0
        WIDTH 0.5
      END
      STYLE
        ANGLE 360
        COLOR 255 255 255
        SYMBOL 0
        WIDTH 0.5
      END
    END
    CLASS
      EXPRESSION ('[highway]'='unclassified' or '[highway]'='residential' or '[highway]'='service' or '[highway]'='road')
      STYLE
        ANGLE 360
        COLOR 119 119 119
        SYMBOL 0
        WIDTH 0.3
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref, name, tunnel from planet_osm_line where highway is not null) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "name"
    MAXSCALEDENOM 1.00001e+006
    MINSCALEDENOM 500010
    NAME "roads_1000k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION "motorway"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 1
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "motorway_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 36 39 122
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "trunk"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 1
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "trunk_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 1
      END
      STYLE
        ANGLE 360
        COLOR 251 128 114
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "primary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 0.8
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 0.8
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 0.8
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 0.8
      END
      TEXT ([ref])
    END
    CLASS
      EXPRESSION "secondary_link"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 0.5
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 0.5
      END
    END
    CLASS
      EXPRESSION "secondary"
      STYLE
        ANGLE 360
        OUTLINEWIDTH 1
        OUTLINECOLOR 158 77 31
        SYMBOL 0
        WIDTH 0.5
      END
      STYLE
        ANGLE 360
        COLOR 252 252 204
        SYMBOL 0
        WIDTH 0.5
      END
    END
    CLASS
      EXPRESSION "tertiary"
      STYLE
        ANGLE 360
        COLOR 119 119 119
        SYMBOL 0
        WIDTH 0.5
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref from planet_osm_line where highway in ('motorway','trunk','primary') ) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "ref"
    MAXSCALEDENOM 2.50001e+006
    MINSCALEDENOM 1.00001e+006
    NAME "roads_2500k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION "motorway"
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "trunk"
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        COLOR 158 77 31
        SYMBOL 0
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref from planet_osm_line where highway in ('motorway','trunk','primary') ) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "ref"
    MAXSCALEDENOM 5.00001e+006
    MINSCALEDENOM 2.50001e+006
    NAME "roads_5000k"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION "motorway"
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "trunk"
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 1
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        COLOR 158 77 31
        SYMBOL 0
        WIDTH 1
      END
    END
  END

  LAYER
    CLASSITEM "highway"
    CONNECTION "user=postgres password=mypassword dbname=gis host=localhost"
    CONNECTIONTYPE POSTGIS
    DATA "way from (select way, osm_id ,highway,ref from planet_osm_line where highway in ('motorway','trunk','primary') ) as foo using unique osm_id using srid=900913"
    GROUP "default"
    LABELITEM "ref"
    MAXSCALEDENOM 1e+007
    MINSCALEDENOM 5.00001e+006
    NAME "roads_10kk"
    PROJECTION
      "init=epsg:3857"
    END
    STATUS ON
    TYPE LINE
    UNITS METERS
    CLASS
      EXPRESSION "motorway"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 7
        TYPE TRUETYPE
        BUFFER 15
        COLOR 255 255 255
        FORCE FALSE
        MINDISTANCE 150
        MINFEATURESIZE -1
        OFFSET 0 0
        PARTIALS TRUE
        POSITION CC
        MAXLENGTH 6
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 0.8
      END
    END
    CLASS
      EXPRESSION "trunk"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "arial"
        MAXSIZE 256
        MINSIZE 4
        SIZE 6
        TYPE TRUETYPE
        BUFFER 15
        COLOR 255 255 255
        FORCE FALSE
        MINDISTANCE 150
        MINFEATURESIZE -1
        OFFSET 0 0
        PARTIALS TRUE
        POSITION CC
        MAXLENGTH 6
      END
      STYLE
        ANGLE 360
        COLOR 79 113 157
        SYMBOL 0
        WIDTH 0.8
      END
    END
    CLASS
      EXPRESSION "primary"
      STYLE
        ANGLE 360
        COLOR 158 77 31
        SYMBOL 0
        WIDTH 0.8
      END
    END
  END

END
 

location: 
urlphoto: