MAP


OUTPUTFORMAT
    NAME agg
    DRIVER AGG/PNG8
    FORMATOPTION "INTERLACE=OFF"
    MIMETYPE "image/png"
END

OUTPUTFORMAT
 NAME svg
 DRIVER "CAIRO/SVG"
 MIMETYPE "image/svg+xml"
 IMAGEMODE RGB
 EXTENSION "svg"
END

OUTPUTFORMAT
  NAME pdf
  DRIVER "CAIRO/PDF"
  MIMETYPE "application/x-pdf"
  IMAGEMODE RGB
  EXTENSION "pdf"
END


FONTSET "osmfonts.lst"
MAXSIZE 10000
SIZE 800 800
EXTENT         -180 -85 180 85
# EXTENT        -179.999 -85 179.999 85
IMAGECOLOR     "#8888ff"
SHAPEPATH      "/home/www/wms/simple/"


WEB
    METADATA
      "ows_enable_request" "*"
       wms_srs "EPSG:900913 EPSG:4326 EPSG:3857"
        labelcache_map_edge_buffer "-10"
        wms_title "osm"
    END
   IMAGEPATH "/tmp/"
   IMAGEURL  "/"
END

PROJECTION
"init=epsg:900913"
END


SYMBOL
   NAME bridge
   TYPE SIMPLE
END

SYMBOL
    NAME "citycircle"
    TYPE ELLIPSE
    POINTS 1 1 END
    FILLED TRUE  
END


SYMBOL
 NAME "oneway"
 TYPE vector
 POINTS
  15  2
  20  2
  17  4
  -99 -99
  20  2
  17  0
 END
END

SYMBOL
 NAME "noaccess"
 TYPE vector
 POINTS
  0 0
  1 1
 END
END

SYMBOL
 NAME "treppe"
 TYPE vector
 POINTS
  0 0
  0 1
  -99 -99
  2 0
  2 1
 END
END     

SYMBOL
 NAME "tram"
 TYPE vector
 POINTS
  0  0
  0  4
  -99 -99
  0  2
  20 2
 END
END     

SYMBOL
 NAME "cliff"
 TYPE vector
 POINTS
    0  0
   50  0
  -99 -99
   2   0
   10   20
   20  0
 END
END     

SYMBOL
 NAME "ridge"
 TYPE vector
 POINTS
    0   20
   100  20
  -99 -99
    0   40
    0    0
 END
END     




########################################  WELT ###########################################################

LAYER 
   PROCESSING     "CLOSE_CONNECTION=DEFER"
   NAME           "welt"
   TYPE           POLYGON
   STATUS         ON
   GROUP          "default"
   DATA           "grenzen"
   MINSCALEDENOM  1500001
   PROJECTION
      "init=epsg:4326"
   END
   CLASS 
    STYLE 
     COLOR        "#EDEBE6"
     OUTLINECOLOR "#999999"
    END # of style
   END # of class
END # of layer

LAYER 
   PROCESSING     "CLOSE_CONNECTION=DEFER"
   NAME           "kleinewelt"
   TYPE           POLYGON
   STATUS         ON
   GROUP          "default"
   DATA           "grenzen"
   MAXSCALEDENOM  1500000
   PROJECTION
      "init=epsg:4326"
   END
   CLASS 
    STYLE 
     COLOR        "#EDEBE6"
     OUTLINECOLOR "#EDEBE6"
    END # of style
   END # of class
END # of layer


   


######################################### FLAECHEN #######################################################

LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    NAME "gewerbe"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way,osm_id ,landuse,highway, CAST(area as float) as area, name from osm_polygon_view where landuse IN ('industrial', 'commercial', 'airport', 'brownfield', 'military', 'railway', 'residential') or highway='residential') as foo using unique osm_id using srid=900913"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASSITEM "landuse"
    LABELITEM "name"
    MAXSCALEDENOM 1000010
    CLASS
        EXPRESSION (('[landuse]'='airport' or '[landuse]'='military' or '[landuse]'='railway'))
        STYLE
            COLOR "#aaaaaa"
        END
        LABEL
        TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
        MAXSCALEDENOM 15000
            SIZE 7
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            PRIORITY 1
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
        END
    END

    CLASS
        NAME "Gewerbe" 
        EXPRESSION (('[landuse]'='industrial' or '[landuse]'='commercial') and [area] gt 100000)
        STYLE
            COLOR "#aaaaaa"
        END
        LABEL
        TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
        MAXSCALEDENOM 15000
            SIZE 7
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            PRIORITY 1
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
        END
    END

    CLASS
        EXPRESSION (('[landuse]'='industrial' or '[landuse]'='commercial') and [area] lt 10000)
        STYLE
            COLOR "#aaaaaa"
        END
    END



    CLASS
        EXPRESSION ('[landuse]'='residential')
        STYLE
            COLOR "#cccccc"
        END
        LABEL
        TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
        MAXSCALEDENOM 15000
            SIZE 7
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            PRIORITY 1
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
        END
    END
END

LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    GROUP "default"
    NAME "park"
    CONNECTIONTYPE postgis
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way,osm_id ,leisure, amenity, CAST(area as float) as area, sport, landuse, name from osm_polygon_view where leisure='park' or leisure='garden' or leisure='golf_course' or landuse='recreation_ground' or leisure='playground' or landuse='playground' or landuse='village_green' or landuse='cemetery' or amenity='grave_yard' or sport is not null or leisure like 'sport%' or leisure='pitch' order by CAST(area as float) desc ) as foo using unique osm_id using srid=900913"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    MAXSCALEDENOM 100000
 CLASS
        EXPRESSION ('[landuse]'='cemetery' or '[amenity]'='grave_yard')
        NAME "Friedhof"
        STYLE
            COLOR "#AAAA88"
        END
        LABEL
        TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
        MAXSCALEDENOM 15000
            SIZE 7
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            PRIORITY 2
           WRAP ' '
           MAXLENGTH 6
            ALIGN CENTER
        END
 END
 CLASS
        NAME "Wiese"
        EXPRESSION ('[leisure]'='garden' or '[leisure]'='playground' or '[landuse]'='playground')
        STYLE
            COLOR "#AAFFAA"
        END
 END

 CLASS
        NAME "Sportplatz"
        EXPRESSION ('[leisure]' = 'pitch' or ('[sport]' != '' and '[leisure]' != 'sports_centre' ))
        STYLE
            COLOR "#AADDAA"
        END
    END


 CLASS
        EXPRESSION ([area] gt 10000)
        STYLE
            COLOR "#AADDAA"
        END
        LABEL
        TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
        MAXSCALEDENOM 15000
            SIZE 7
            COLOR "#557755"
            OUTLINECOLOR 255 255 255
            PRIORITY 2
            POSITION cc
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
        END
    END
END

LAYER
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    GROUP "default"
    NAME "schule"
    TYPE POLYGON
    CONNECTIONTYPE postgis
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way,osm_id,amenity,aeroway,building,name from osm_polygon where building is null and (aeroway='apron' or amenity IN ('hospital', 'parking', 'school', 'college', 'university'))) as foo using unique osm_id using srid=900913"
    LABELITEM "name"
    CLASSITEM "amenity"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 100000
    CLASS
        EXPRESSION "hospital"
        STYLE
            COLOR "#cccccc"
        END
    END
    CLASS
        EXPRESSION ("[amenity]"="parking" or "[aeroway]"="apron")
        STYLE
            COLOR "#cccccc"
        END
    END
    CLASS
        NAME "Schule"
        EXPRESSION ('[amenity]'='school' or '[amenity]'='college' or '[amenity]'='university' )
        STYLE
            COLOR "#DDAAAA"
        END
        LABEL
            TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
            MAXSCALEDENOM 15000
            SIZE 7
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            PRIORITY 3
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
        END
    END
END

LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    NAME "wald"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way,osm_id ,CAST(area as float) as area,nature,landuse, wood ,highway, railway, public_transport, name from osm_polygon_view where nature in ('wood','forest','sand','beach','wetland','marsh','crub','scrub','cliff','rock','glacier') or landuse in ('forest','farm','agriculture','allotments','field','farmland','grass','greenfield','meadow') or highway='pedestrian' or highway='residential' or railway='platform' or public_transport='platform') as foo using unique osm_id using srid=900913"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    CLASSITEM "landuse"
    MAXSCALEDENOM 1000000
    LABELITEM "name"
    CLASS
        MINSCALEDENOM 100001
        EXPRESSION ([area] gt 1000000 and ('[nature]'="wood" or '[landuse]'="forest"))
        STYLE
            COLOR "#88bb88" 
            OUTLINEWIDTH 0.3
        END  
        LABEL
            MAXSCALEDENOM 600000
            TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
            SIZE 7
            COLOR "#557755"
            OUTLINECOLOR 255 255 255
            PRIORITY 2
            WRAP ' '
            MINFEATURESIZE AUTO
            MAXLENGTH 8
            ALIGN CENTER
        END
    END
    CLASS
        MINSCALEDENOM 100001
        EXPRESSION ('[nature]'='wood' or '[landuse]'="forest")
        STYLE
            COLOR "#88bb88"
            OUTLINEWIDTH 0.3
        END
    END

    CLASS
        MAXSCALEDENOM 100000
        EXPRESSION ([area] gt 1000000 and '[wood]'='coniferous' and ('[nature]'='wood' or '[landuse]'="forest"))
        STYLE
            COLOR "#88bb88" 
            OUTLINEWIDTH 0.3
        END  
        STYLE
            SYMBOL ../icons/png/misc/nadelwald.png
        END
        LABEL
            MAXSCALEDENOM 600000
            TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
            SIZE 7
            COLOR "#557755"
            OUTLINECOLOR 255 255 255
            PRIORITY 2
            WRAP ' '
            MINFEATURESIZE AUTO
            MAXLENGTH 8
            ALIGN CENTER
        END
    END

    CLASS
        NAME "Wald"
        MAXSCALEDENOM 100000
        EXPRESSION ('[wood]'='coniferous' and ('[nature]'='wood' or '[landuse]'="forest"))
        STYLE
            COLOR "#88bb88"
            OUTLINEWIDTH 0.3
        END
        STYLE
            SYMBOL ../icons/png/misc/nadelwald.png
        END
    END

    CLASS
        MAXSCALEDENOM 100000
        EXPRESSION ([area] gt 1000000 and '[wood]'='deciduous' and ('[nature]'='wood' or '[landuse]'="forest"))
        STYLE
            COLOR "#88bb88" 
            OUTLINEWIDTH 0.3
        END  
        STYLE
            SYMBOL ../icons/png/misc/laubwald.png
        END
        LABEL
            MAXSCALEDENOM 600000
            TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
            SIZE 7
            COLOR "#557755"
            OUTLINECOLOR 255 255 255
            PRIORITY 2
            WRAP ' '
            MINFEATURESIZE AUTO
            MAXLENGTH 8
            ALIGN CENTER
        END
    END

    CLASS
        NAME "Wald"
        MAXSCALEDENOM 100000
        EXPRESSION ('[wood]'="deciduous" and ('[nature]'='wood' or '[landuse]'="forest"))
        STYLE
            COLOR "#88bb88"
            OUTLINEWIDTH 0.3
        END
        STYLE
            SYMBOL ../icons/png/misc/laubwald.png
        END
    END


    CLASS
        NAME "Wald"
        MAXSCALEDENOM 100000
        EXPRESSION ('[nature]'="wood" or '[landuse]'="forest")
        STYLE
            COLOR "#88bb88"
            OUTLINEWIDTH 0.3
        END
        STYLE
            SYMBOL ../icons/png/misc/wald.png
        END
    END

    CLASS
        MAXSCALEDENOM 100000
        EXPRESSION ([area] gt 1000000 and ('[nature]'='wood' or '[landuse]'="forest"))
        STYLE
            COLOR "#88bb88" 
            OUTLINEWIDTH 0.3
        END  
        STYLE
            SYMBOL ../icons/png/misc/wald.png
        END
        LABEL
            MAXSCALEDENOM 600000
            TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
            SIZE 7
            COLOR "#557755"
            OUTLINECOLOR 255 255 255
            PRIORITY 2
            WRAP ' '
            MINFEATURESIZE AUTO
            MAXLENGTH 8
            ALIGN CENTER
        END
    END

    CLASS
        NAME "Wald"
        MAXSCALEDENOM 100000
        EXPRESSION ('[nature]'='wood' or '[landuse]'="forest")
        STYLE
            COLOR "#88bb88"
            OUTLINEWIDTH 0.3
        END
        STYLE
            SYMBOL ../icons/png/misc/wald.png
        END
    END


    CLASS
        EXPRESSION ('[landuse]'='farm' or '[landuse]'='farmland' or '[nature]'='agriculture' or '[landuse]'='allotments' or '[landuse]'='field')
        STYLE
            COLOR "#b8CCAA"
            OUTLINEWIDTH 0.3
        END
    END
    CLASS
        EXPRESSION ('[landuse]'='grass' or '[landuse]'='greenfield' or  '[landuse]'='meadow')
        STYLE
            COLOR "#AACCAA"
            OUTLINEWIDTH 0.3
        END
    END

    CLASS
        EXPRESSION ('[nature]'='sand' or '[nature]'='beach')
        STYLE
            COLOR "#AACCCC"
            OUTLINEWIDTH 0.3
        END
    END



    CLASS
        MINSCALEDENOM 100001
        EXPRESSION ([area] gt 1000000 and ('[nature]'='marsh' or '[nature]'='wetland' or '[nature]'='swamp'))
        STYLE
            COLOR "#88cc99" 
            OUTLINEWIDTH 0.3
        END  
        LABEL
            MAXSCALEDENOM 600000
            TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
            SIZE 7
            COLOR "#557755"
            OUTLINECOLOR 255 255 255
            PRIORITY 2
            WRAP ' '
            MINFEATURESIZE AUTO
            MAXLENGTH 8
            ALIGN CENTER
        END
    END

    CLASS
        MINSCALEDENOM 100001
        EXPRESSION ('[nature]'='marsh' or '[nature]'='wetland' or '[nature]'='swamp')
        STYLE
            COLOR "#88cc99"
            OUTLINEWIDTH 0.3
        END
    END


    CLASS
        MAXSCALEDENOM 100000
        EXPRESSION ([area] gt 1000000 and ('[nature]'='marsh' or '[nature]'='wetland' or '[nature]'='swamp'))
        STYLE
            COLOR "#88cc99" 
            OUTLINEWIDTH 0.3
        END  
        STYLE
            SYMBOL ../icons/png/landuse_swamp.p.24.png
        END
        LABEL
            MAXSCALEDENOM 600000
            TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
            SIZE 7
            COLOR "#557755"
            OUTLINECOLOR 255 255 255
            PRIORITY 2
            WRAP ' '
            MINFEATURESIZE AUTO
            MAXLENGTH 8
            ALIGN CENTER
        END
    END

    CLASS
        name "Sumpf"
        MAXSCALEDENOM 100000
        EXPRESSION ('[nature]'='marsh' or '[nature]'='wetland' or '[nature]'='swamp')
        STYLE
            COLOR "#88cc99"
            OUTLINEWIDTH 0.3
        END
        STYLE
            SYMBOL ../icons/png/landuse_swamp.p.24.png
        END
    END



    CLASS
        NAME "Gebuesch"
        MINSCALEDENOM 100001
        EXPRESSION ('[nature]'='scrub')                     
        STYLE
            COLOR "#BFCC9D"
            OUTLINEWIDTH 0.3
        END
    END
    CLASS
        NAME "Gebuesch"
        MAXSCALEDENOM 100000
        EXPRESSION ('[nature]'='scrub')                     
        STYLE
            COLOR "#BFCC9D"
            OUTLINEWIDTH 0.3
        END
        STYLE
            SYMBOL ../icons/png/landuse_scrub.p.24.png
        END
    END


    CLASS
        EXPRESSION ('[nature]'='cliff' or or '[nature]'='rock')
        STYLE
            COLOR "#EEEEEE"
            OUTLINEWIDTH 0.3
        END
    END
    CLASS
        EXPRESSION ('[nature]'='glacier')
        STYLE
            COLOR "#ddeeFF"
            OUTLINEWIDTH 0.3
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          MAXSCALEDENOM 150000
          SIZE 7
          COLOR 0 0 100
          OUTLINECOLOR 255 255 255
          WRAP ' '   
          MAXLENGTH 6 
          ALIGN CENTER
        END
    END

  CLASS
        NAME "Fussgaengerzone"
        EXPRESSION ('[highway]'='pedestrian')
        STYLE
            COLOR "#888888"
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          MAXSCALEDENOM 10000
          SIZE 7
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
        END
    END

  CLASS
        EXPRESSION ('[highway]'='residential')
        STYLE
         COLOR "#eeeeee"
         OUTLINEWIDTH 0.3
         OUTLINECOLOR "#222222"
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          MAXSCALEDENOM 10000
          SIZE 7
          COLOR 0 0 0
          OUTLINECOLOR 255 255 255
          WRAP ' '
          MAXLENGTH 6
          ALIGN CENTER
        END
    END

  CLASS
        EXPRESSION ('[railway]'='platform' or '[public_transport]'='platform')
        STYLE
            COLOR "#808080"
        END
    END


END


LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    NAME "stehendeswasser"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way,osm_id ,nature ,CAST(area as float) as area, name from osm_polygon_view where nature ='water' or landuse='basin' or landuse='reservoir' or waterway='riverbank') as foo using unique osm_id using srid=900913"
    PROCESSING "LABEL_NO_CLIP=ON"
    MAXSCALEDENOM 2000000
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASS
        EXPRESSION ([area] gt 1000000)
        STYLE
            COLOR "#8888ff"
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          MAXSCALEDENOM 500000
          MINDISTANCE 400
          SIZE 7
          COLOR "#4444ff"
          OUTLINECOLOR 255 255 255
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
        END
    END
    CLASS
        EXPRESSION ([area] le 100000)
        STYLE
            COLOR "#8888ff"
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          MAXSCALEDENOM 10000
          MINDISTANCE 400
          SIZE 7
          COLOR "#4444ff"
          OUTLINECOLOR 255 255 255
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
        END
    END
    CLASS
        STYLE
            COLOR "#8888ff"
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          MAXSCALEDENOM 40000
          MINDISTANCE 400
          SIZE 7
          COLOR "#4444ff"
          OUTLINECOLOR 255 255 255
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
        END
    END
END




############################### FLUESSE ################################################

LAYER
    TYPE LINE
    NAME "fliessendeswasser"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way,name,waterway,osm_id from osm_line where tunnel is null and waterway IN ('river', 'stream', 'canal', 'drain')) as foo using unique osm_id using srid=900913"
    CLASSITEM "waterway"
    LABELITEM 'name'
    SIZEUNITS meters
    MAXSCALEDENOM 2000000
    CLASS
        EXPRESSION "river"
        STYLE
            COLOR "#8888ff"
            WIDTH 30
            MINWIDTH 0.5
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          ANGLE FOLLOW
          MAXSCALEDENOM 50000
          MINDISTANCE 400   
          SIZE 30
          MINSIZE 8
          MAXSIZE 12
          COLOR "#000033" 
          OUTLINEWIDTH 2
          OUTLINECOLOR 255 255 255
          ALIGN CENTER
        END
    END

    CLASS
        MAXSCALEDENOM 105000
        EXPRESSION "stream"
        STYLE
            COLOR "#8888ff"
            WIDTH 10
            MINWIDTH 0.5
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          ANGLE FOLLOW
          MAXSCALEDENOM 20000
          MINDISTANCE 400   
          SIZE 20
          MINSIZE 7
          MAXSIZE 12
          COLOR "#000033" 
          OUTLINEWIDTH 2
          OUTLINECOLOR 255 255 255
          ALIGN CENTER
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR "#8888ff"
            WIDTH 15
            MINWIDTH 0.5
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          ANGLE FOLLOW
          MAXSCALEDENOM 20000
          MINDISTANCE 400   
          SIZE 20
          MINSIZE 7
          MAXSIZE 12
          COLOR "#000033" 
          OUTLINEWIDTH 2
          OUTLINECOLOR 255 255 255
          ALIGN CENTER
        END
    END
    CLASS
        MAXSCALEDENOM 105000
        EXPRESSION "drain"
        STYLE
            COLOR "#8888ff"
            WIDTH 10
            MINWIDTH 0.5
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          ANGLE FOLLOW
          MAXSCALEDENOM 10000
          MINDISTANCE 400   
          SIZE 15
          MINSIZE 7
          MAXSIZE 12
          COLOR "#000033" 
          OUTLINEWIDTH 2
          OUTLINECOLOR 255 255 255
          ALIGN CENTER
        END
    END
END

LAYER
    TYPE LINE
    NAME "fliessendeswasser"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way,waterway,osm_id from osm_line where tunnel is not null and waterway IN ('river', 'stream', 'canal', 'drain')) as foo using unique osm_id using srid=900913"
    CLASSITEM "waterway"
    SIZEUNITS meters
    MAXSCALEDENOM 2000000
    CLASS
        EXPRESSION "river"
        STYLE
            OPACITY 30
            COLOR "#8888ff"
            WIDTH 30
            MINWIDTH 0.5
        END
    END
    CLASS
        MAXSCALEDENOM 105000
        EXPRESSION "stream"
        STYLE
            OPACITY 30
            COLOR "#8888ff"
            WIDTH 5
            MINWIDTH 0.5
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            OPACITY 30
            COLOR "#8888ff"
            WIDTH 10
            MINWIDTH 0.5
        END
    END
    CLASS
        MAXSCALEDENOM 105000
        EXPRESSION "drain"
        STYLE
            OPACITY 30
            COLOR "#8888ff"
            WIDTH 10
            MINWIDTH 0.5
        END
    END
END

################### Schummerung

 
  LAYER
   MAXSCALEDENOM  2000000
   MINSCALEDENOM     5000
   NAME           "schummerung"
   STATUS         ON
   GROUP          "default"
   STATUS         OFF
   TYPE           RASTER
   OPACITY        20
   DATA           "/home/www/wms/schummerung/hillshade.tif"
   projection      "init=epsg:900913" end
  END # of layer 

############ CLIFF ##################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    MAXSCALEDENOM 100000
    NAME "CLIFF"
    DATA "way from (select way,osm_id,name,nature from osm_line_view where nature='cliff' or nature='ridge') as foo using unique osm_id using srid=900913"
    SIZEUNITS meters
    CLASSITEM 'nature'
    LABELITEM 'name'
    CLASS
        EXPRESSION 'cliff'
        STYLE
            WIDTH 10
            MINWIDTH 0.5
            MAXWIDTH 2
            COLOR "#999999"
            SYMBOL "cliff"
            OPACITY 60
        END
        LABEL
         MAXSCALEDENOM 10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
         MINDISTANCE 400
         SIZE 3
         MINSIZE 7
         MAXSIZE 9
         COLOR "#000000"
         WRAP ' '
         PRIORITY 1
         MAXLENGTH 5
         ALIGN CENTER
        END
    END

END



################### Hoehenlinien


LAYER
    TYPE LINE
    STATUS ON
    NAME "hoehenlinien"
    GROUP "default"
    MAXSCALEDENOM 100000
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=srtm user=xxx password=xxx port=5432"
    DATA "way from (select way,gid,height,typ from contours where height>699) as foo using unique gid using srid=900913"
    PROCESSING "LABEL_NO_CLIP=ON"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "height"
    CLASS
        EXPRESSION ('[typ]'='25')
        MAXSCALEDENOM 20000
        STYLE
         WIDTH 0.3
         COLOR "#FFaa77"
        END
    END
    CLASS
        MAXSCALEDENOM 30000 
        EXPRESSION ('[typ]'='50')
        STYLE
         WIDTH 0.5
         COLOR "#FFaa77"
        END
    END
    CLASS
        EXPRESSION ('[typ]'='100')
        STYLE
         WIDTH 0.8
         COLOR "#FFaa77"
        END
        LABEL
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 7
         COLOR "#FF7777"
        END     
    END

END




##########################  HAEUSER ################################################################

LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    NAME "haeuserboden"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way,osm_id ,amenity ,name, tourism from osm_polygon where building is not null) as foo using unique osm_id using srid=900913"
    PROCESSING "LABEL_NO_CLIP=ON"
    MAXSCALEDENOM 10000
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASS
        EXPRESSION ('[amenity]'='place_of_worship')
        STYLE
            COLOR "#775555"
            OFFSET 3 3
        END
    END
    CLASS
        EXPRESSION ('[amenity]'='hospital')
        STYLE
            COLOR "#885555"
            OFFSET 3 3
        END
    END
    CLASS
        EXPRESSION ('[amenity]'='school' or '[amenity]'='college' or '[amenity]'='university' or '[tourism]'='attraction' or '[amenity]'='townhall')
        STYLE
            COLOR "#885555"
            OFFSET 3 3
        END
    END
    CLASS
        STYLE
            COLOR "#886666"
            OFFSET 3 3
        END
    END

END

LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    NAME "haeuserdach"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way,osm_id ,amenity ,name, tourism from osm_polygon where building is not null) as foo using unique osm_id using srid=900913"
    PROCESSING "LABEL_NO_CLIP=ON"
    MAXSCALEDENOM 20000
    PROCESSING "CLOSE_CONNECTION=DEFER"
    LABELITEM "name"
    CLASS
        EXPRESSION ('[amenity]'='place_of_worship')
        STYLE
            COLOR "#997777"
        END
    END
    CLASS
        EXPRESSION ('[amenity]'='hospital')
        STYLE
            COLOR "#aa7777"
        END
    END
    CLASS
        EXPRESSION ('[amenity]'='school' or '[amenity]'='college' or '[amenity]'='university' or '[tourism]'='attraction' or '[amenity]'='townhall')
        STYLE
            COLOR "#aa7777"
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          MAXSCALEDENOM 15000
          MINDISTANCE 400
          SIZE 7
          COLOR "#333333"
          OUTLINECOLOR 255 255 255
          PRIORITY 2
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
        END
    END
    CLASS
        STYLE
            COLOR "#aa8888"
        END
    END

END



########################### STRASSEN ################################################################


LAYER
    MAXSCALEDENOM 250000
    MINSCALEDENOM  15001  
    STATUS ON 
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "winzigestr"
    DATA "way from (select way,osm_id,highway,tags->'sac_scale' as sac_scale from osm_line where highway = 'unclassified' or highway = 'residential' or highway = 'services' or highway = 'pedestrian' or highway = 'services' or highway = 'track' or highway = 'path' order by z_order) as foo using unique osm_id using srid=900913"
    CLASSITEM "sac_scale"
    SIZEUNITS meters
    CLASS

    CLASS
        EXPRESSION ('[sac_scale]'='demanding_mountain_hiking' or '[sac_scale]'='alpine_hiking')
        STYLE
         WIDTH 6
         MAXWIDTH 5
         PATTERN 50 50 END
         COLOR "#555555"
        END
    END


    CLASS
        EXPRESSION ('[sac_scale]'='demanding_alpine_hiking' or '[sac_scale]'='difficult_alpine_hiking')
        STYLE
         WIDTH 6
         MAXWIDTH 5
         PATTERN 20 80 END
         COLOR "#555555"
        END
    END


    CLASS
        STYLE
         WIDTH 6
         MAXWIDTH 5
         COLOR "#555555"
        END
    END

END

LAYER
    MAXSCALEDENOM 2000000
    MINSCALEDENOM  250000  
    STATUS ON 
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "riesigestr"
    DATA "way from (select way,osm_id,highway,ref,name,bridge,tunnel,railway from osm_line where highway like 'motorway%' or highway like 'trunk%' or highway like 'primary%' or highway like 'secondary%' or highway like 'tertiary%' or railway = 'rail' order by z_order) as foo using unique osm_id using srid=900913"
    CLASSITEM "highway"
    SIZEUNITS meters
    CLASS
        EXPRESSION 'secondary'
        STYLE
         WIDTH 300
         MAXWIDTH 3
         COLOR "#cccc00"
        END
    END
    CLASS
        EXPRESSION 'primary'
        STYLE
         WIDTH 400
         MAXWIDTH 3
         COLOR "#dd6600"
        END
    END
    CLASS
        EXPRESSION 'motorway'
        STYLE
         WIDTH 500
         MAXWIDTH 3
         COLOR "#cc0000"
        END
    END

END


#################### Flughafen ##################################################################

LAYER
    MAXSCALEDENOM 150000
    STATUS ON 
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "flughafen1"
    DATA "way from (select way,osm_id,highway,ref,aeroway from osm_line where aeroway = 'taxiway' order by z_order) as foo using unique osm_id using srid=900913"
    SIZEUNITS meters
    CLASS
        STYLE
         WIDTH 20
         MAXWIDTH 3
         COLOR "#555555"
        END
    END
END

LAYER
    MAXSCALEDENOM 2000000
    STATUS ON 
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "flughafen1"
    DATA "way from (select way,osm_id,highway,ref,aeroway from osm_line where aeroway = 'runway' order by z_order) as foo using unique osm_id using srid=900913"
    SIZEUNITS meters
    CLASS
        STYLE
         WIDTH 60
         MAXWIDTH 3
         COLOR "#555555"
        END
    END
END

LAYER
    MAXSCALEDENOM 2000000
    STATUS ON 
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POLYGON
    NAME "flughafen3"
    DATA "way from (select way,osm_id,highway,ref,aeroway from osm_polygon where aeroway = 'runway' order by z_order) as foo using unique osm_id using srid=900913"
    SIZEUNITS meters
    CLASS
        STYLE
         COLOR "#555555"
        END
    END
END






############### ############## KLEINER MASSTAB #####################################################

LAYER
    STATUS ON 
    MAXSCALEDENOM 250000
    MINSCALEDENOM  15001
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "strkl"
    DATA "way from (select way,osm_id,highway,ref,name,bridge,tunnel,layer,railway from osm_line where highway like 'motorway%' or highway like 'trunk%' or highway like 'primary%' or highway like 'secondary%' or highway like 'tertiary%' or railway = 'rail' or railway = 'narrow_gauge' order by z_order) as foo using unique osm_id using srid=900913"
    LABELITEM "ref"
    CLASSITEM "highway"
    SIZEUNITS meters

    CLASS
        EXPRESSION ('[highway]'='tertiary_link' and '[tunnel]'='yes')   
        STYLE
            WIDTH 10
            MAXWIDTH 12
            LINEJOIN NONE
            OUTLINEWIDTH 0.2
            COLOR "#eeeeee"
            OUTLINECOLOR "#cccccc"
            OPACITY 60
        END
    END

    CLASS
        EXPRESSION ('[highway]'='tertiary' and '[tunnel]'='yes')
        STYLE
         WIDTH 10
         MAXWIDTH 12 
         LINEJOIN NONE
         OUTLINEWIDTH 0.2
         COLOR "#ffffff"
         OUTLINECOLOR "#cccccc"
         OPACITY 60
        END
    END

    CLASS
        EXPRESSION ('[highway]'='secondary_link' and '[tunnel]'='yes')   
        STYLE
            WIDTH 10
            MAXWIDTH 12
            OUTLINEWIDTH 1
            COLOR "#FFFF00"
            OUTLINECOLOR "#bbbb00"
            OPACITY 60
        END
    END

    CLASS
        EXPRESSION ('[highway]'='secondary' and '[tunnel]'='yes')
        STYLE
            WIDTH 10
            MAXWIDTH 12
            OUTLINEWIDTH 1
            COLOR "#FFFF00"
            OUTLINECOLOR "#bbbb00"
            OPACITY 60
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk_link' or '[highway]'='primary_link') and '[tunnel]'='yes')   
        STYLE
            WIDTH 10
            MAXWIDTH 12    
            OUTLINEWIDTH 1
            COLOR "#FFB400"
            OUTLINECOLOR "#cc7700"
            OPACITY 60
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk' or '[highway]'='primary') and '[tunnel]'='yes')
        STYLE
            WIDTH 10
            MAXWIDTH 12
            OUTLINEWIDTH 1
            COLOR "#FFB400"
            OUTLINECOLOR "#DD8800"
            OPACITY 60
        END
    END

    CLASS
        EXPRESSION ('[highway]'='motorway_link' and '[tunnel]'='yes')   
        STYLE
            WIDTH 10
            MAXWIDTH 12
            OUTLINEWIDTH 2
            COLOR "#ff0000"
            OUTLINECOLOR "#bb0000"
            OPACITY 20
        END
    END

    CLASS
        EXPRESSION ('[highway]'='motorway' and '[tunnel]'='yes')
        STYLE
            WIDTH 10
            MAXWIDTH 12
            OUTLINEWIDTH 2
            COLOR "#ff0000"
            OUTLINECOLOR "#bb0000"
            OPACITY 20
        END
    END

    CLASS
        EXPRESSION ((('[railway]'='rail' or '[railway]'='narrow_gauge') and '[tunnel]'='yes') or '[railway]'='subway')   
        STYLE
            WIDTH 2
            MAXWIDTH 5
            COLOR "#111111"
            OPACITY 30
        END
    END



############## Weder TUNNEL noch BRUECKE ####################

    CLASS
        EXPRESSION ('[highway]'='tertiary_link' and '[tunnel]'!='yes' and '[bridge]'!='yes')   
        STYLE
            WIDTH 10
            MAXWIDTH 12
            LINEJOIN NONE
            OUTLINEWIDTH 0.2
            COLOR "#eeeeee"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
       EXPRESSION ('[highway]'='tertiary' and '[tunnel]'!='yes' and '[bridge]'!='yes')
        STYLE
         WIDTH 10
         MAXWIDTH 12 
         LINEJOIN NONE
         OUTLINEWIDTH 0.2
         COLOR "#eeeeee"
         OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='secondary_link' and '[tunnel]'!='yes' and '[bridge]'!='yes')   
        STYLE
            WIDTH 10
            MAXWIDTH 12
            LINEJOIN NONE
            OUTLINEWIDTH 1
            COLOR "#FFFF00"
            OUTLINECOLOR "#cccc00"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='secondary' and '[tunnel]'!='yes' and '[bridge]'!='yes')
        STYLE
         WIDTH 10
         MAXWIDTH 12 
         LINEJOIN NONE
         OUTLINEWIDTH 1
         COLOR "#FFFF00"
         OUTLINECOLOR "#cccc00"
        END
        LABEL
         MAXSCALEDENOM 150000
         ANGLE AUTO
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
         MINDISTANCE 400
         SIZE 30
         MINSIZE 7
         MAXSIZE 15
         COLOR "#333300"
         OUTLINECOLOR 255 255 255
         WRAP ' '
         MAXLENGTH 5
         ALIGN CENTER
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk_link' or '[highway]'='primary_link') and '[tunnel]'!='yes' and '[bridge]'!='yes')   
        STYLE
            WIDTH 10
            MAXWIDTH 12 
            LINEJOIN NONE
            OUTLINEWIDTH 2
            COLOR "#FFB400"
            OUTLINECOLOR "#dd6600"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk' or '[highway]'='primary') and '[tunnel]'!='yes' and '[bridge]'!='yes')
        STYLE
            WIDTH 10
            MAXWIDTH 12 
            LINEJOIN NONE
            OUTLINEWIDTH 2
            COLOR "#FFB400"
            OUTLINECOLOR "#dd6600"
        END
        LABEL
         MAXSCALEDENOM 5250000
         ANGLE AUTO
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
         MINDISTANCE 400
         SIZE 35
         MINSIZE 7
         MAXSIZE 18
         COLOR "#111100"
         OUTLINECOLOR 255 255 255
         WRAP ' '
         MAXLENGTH 5
         ALIGN CENTER
        END
    END

    CLASS
        EXPRESSION ('[highway]'='motorway_link' and '[tunnel]'!='yes' and '[bridge]'!='yes')   
        STYLE
            WIDTH 10
            MAXWIDTH 12 
            LINEJOIN NONE
            OUTLINEWIDTH 2
            COLOR "#ff0000"
            OUTLINECOLOR "#cc0000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='motorway' and '[tunnel]'!='yes' and '[bridge]'!='yes')
        STYLE
            WIDTH 10
            MAXWIDTH 12
            LINEJOIN NONE
            OUTLINEWIDTH 2
            COLOR "#ff0000"
            OUTLINECOLOR "#cc0000"
        END   
        LABEL
         MAXSCALEDENOM 1000000
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
         MINDISTANCE 400
         SIZE 40
         MINSIZE 9
         MAXSIZE 25
         COLOR "#4444ff"
         OUTLINECOLOR 255 255 255
         WRAP ' '
         MAXLENGTH 5
         ALIGN CENTER
        END
    END

    CLASS
        EXPRESSION (('[railway]'='rail' or '[railway]'='narrow_gauge') and '[tunnel]'!='yes' and '[bridge]'!='yes')   
        STYLE
            WIDTH 2
            MAXWIDTH 5
            COLOR "#111111"
        END
    END


END

############################# BRUECKEN


LAYER
    MAXSCALEDENOM 250000
    MINSCALEDENOM  15001
    STATUS ON 
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "strklbr"
    DATA "way from (select way,osm_id,highway,ref,name,bridge,tunnel,railway from osm_line where bridge = 'yes' and (highway like 'motorway%' or highway like 'trunk%' or highway like 'primary%' or highway like 'secondary%' or highway like 'tertiary%' or railway = 'rail' or railway = 'narrow_gauge' ) order by z_order) as foo using unique osm_id using srid=900913"
    LABELITEM "ref"
    CLASSITEM "highway"
    SIZEUNITS meters

    CLASS
        EXPRESSION ('[highway]'='tertiary_link' )   
        STYLE
            WIDTH 10
            MAXWIDTH 12
            LINECAP butt
            OUTLINEWIDTH 0.2
            COLOR "#eeeeee"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='tertiary' )
        STYLE
         WIDTH 10
         MAXWIDTH 12 
         LINECAP butt
         OUTLINEWIDTH 0.2
         COLOR "#eeeeee"
         OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='secondary_link' )   
        STYLE
            WIDTH 10
            MAXWIDTH 12
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#ffff00"
            OUTLINECOLOR "#bbbb00"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='secondary' )
        STYLE
            WIDTH 10
            MAXWIDTH 12
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#ffff00"
            OUTLINECOLOR "#bbbb00"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk_link' or '[highway]'='primary_link') )   
        STYLE
            WIDTH 10
            MAXWIDTH 12
            LINECAP butt
            OUTLINEWIDTH 2
            COLOR "#FFB400"
            OUTLINECOLOR "#cc7700"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk' or '[highway]'='primary') )
        STYLE
            WIDTH 10
            MAXWIDTH 12
            LINECAP butt
            OUTLINEWIDTH 2
            COLOR "#FFB400"
            OUTLINECOLOR "#cc7700"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='motorway_link' )   
        STYLE
            WIDTH 10
            MAXWIDTH 12
            LINECAP butt
            OUTLINEWIDTH 2
            COLOR "#ff0000"
            OUTLINECOLOR "#990000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='motorway' )

        STYLE
            WIDTH 10
            MAXWIDTH 12
            OUTLINEWIDTH 2
            LINECAP butt
            COLOR "#ff0000"
            OUTLINECOLOR "#990000"
        END
    END

    CLASS
        EXPRESSION ('[railway]'='rail' or '[railway]'='narrow_gauge' )   
        STYLE
            WIDTH 2
            MAXWIDTH 5
            COLOR "#111111"
        END
    END

END



############################# GROSSER MASSTAB #####################################################



################# TUNNEL GROSSER MASSTAB #####################################################



LAYER
    STATUS ON
    MAXSCALEDENOM  15000
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "strgrbr"
    DATA "way from (select way,osm_id,highway,ref,name,bridge,tunnel,railway,surface,layer,tracktype,public_transport from osm_line_view where (CAST(layer as float)<0 or tunnel = 'yes') and (highway is not null or railway is not null or public_transport='platform') order by z_order) as foo using unique osm_id using srid=900913"
    LABELITEM "name"
    CLASSITEM "highway"
    SIZEUNITS meters
    OPACITY   40    

    CLASS
        EXPRESSION ('[railway]'='platform' or '[public_transport]'='platform')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.1
            COLOR "#808080"
            OUTLINECOLOR "#000000"
        END
    END


    CLASS
        EXPRESSION ('[highway]'='pedestrian' )   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.1
            COLOR "#888888"
            OUTLINECOLOR "#000000"
        END
    END


    CLASS
        EXPRESSION ('[highway]'='cycleway')   
        STYLE
            WIDTH 3
            MAXWIDTH 8
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#bbbbbb" 
            OUTLINECOLOR "#444444"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='footway')   
        STYLE
            WIDTH 3
            MAXWIDTH 8
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#bbbbbb" 
            OUTLINECOLOR "#444444"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='path')   
        STYLE
            WIDTH 2
            MAXWIDTH 6
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#aaaaaa"
            OUTLINECOLOR "#888888"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='steps')
        STYLE
            WIDTH 2
            MAXWIDTH 6
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#aaaaaa"
            OUTLINECOLOR "#888888"
        END
        STYLE
            SYMBOL treppe
            COLOR "#888888"
            SIZE 2
            MAXSIZE 6
        END  
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade2')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#886622"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade3')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            PATTERN 20 3  END
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#886622"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade4')   
        STYLE
            WIDTH 4
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#886622"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='track' and ('[tracktype]' = 'grade5' or '[tracktype]' = '' and '[surface]' != 'paved' ) )   
        STYLE
            WIDTH 4
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#886622"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='living_street' or '[highway]'='service' or ('[highway]'='track' and ('[tracktype]'='grade1' or '[surface]'='paved'))))   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#eeeeee"
            OUTLINECOLOR "#333333"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='residential' or ('[highway]'='road')) )   
        STYLE
            WIDTH 16
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.1
            COLOR "#eeeeee"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='unclassified' or  ('[highway]'='services')) )   
        STYLE
            WIDTH 18
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.2
            COLOR "#aaaaaa"
            OUTLINECOLOR "#444444"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='tertiary_link' )   
        STYLE
            WIDTH 20
            MAXWIDTH 14
            LINECAP butt
            LINECAP butt
            OUTLINEWIDTH 0.3
            COLOR "#eeeeee"
            OUTLINECOLOR "#cccccc"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='tertiary' )
        STYLE
         WIDTH 20
         MAXWIDTH 14 
         LINECAP butt
         LINECAP butt
         OUTLINEWIDTH 0.2
         COLOR "#ffffff"
         OUTLINECOLOR "#cccccc"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='secondary_link' )   
        STYLE
            WIDTH 20
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#FFFF77"
            OUTLINECOLOR "#bbbb00"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='secondary' )
        STYLE
            WIDTH 20
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#FFFF77"
            OUTLINECOLOR "#bbbb00"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk_link' or '[highway]'='primary_link') )   
        STYLE
            WIDTH 20
            MAXWIDTH 14    
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#FFcc44" 
            OUTLINECOLOR "#dd6600"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk' or '[highway]'='primary') )
        STYLE
            WIDTH 20
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#FFcc44" 
            OUTLINECOLOR "#dd6600"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='motorway_link' )   
        STYLE
            WIDTH 21
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 2
            COLOR "#ee7777"
            OUTLINECOLOR "#bb0000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='motorway' )
        STYLE
            WIDTH 21
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 2
            COLOR "#ee7777"
            OUTLINECOLOR "#bb0000"
        END
    END

    CLASS
      EXPRESSION (('[railway]'='rail' or '[railway]'='narrow_gauge' or '[railway]'='subway'))   
       STYLE
        COLOR 200 200 200 
        WIDTH 2
        MAXSIZE 6  
        OUTLINEWIDTH 0.5
        OUTLINECOLOR 102 102 102
       END
       STYLE
        COLOR 102 102 102
        WIDTH 2
        MAXSIZE 6
        PATTERN 12 20 END
       END
    END  
END


############## Weder TUNNEL noch BRUECKE GROSSER MASSTAB #####################################################


LAYER
    STATUS ON 
    MAXSCALEDENOM  15000
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "strgr"
    DATA "way from (select way,osm_id,highway,ref,name,bridge,tunnel,railway,tracktype,surface,public_transport,man_made,sac_scale from osm_line_view where tunnel is null and bridge is null and (layer is null or CAST(layer as float)>=0) and (highway is not null or railway is not null or public_transport='platform' or man_made='pier') order by z_order) as foo using unique osm_id using srid=900913"
    LABELITEM "name"
    CLASSITEM "highway"
    SIZEUNITS meters


    CLASS
        EXPRESSION ('[railway]'='platform' or '[public_transport]'='platform')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            OUTLINEWIDTH 0.5
            COLOR "#808080"
        END
    END

    CLASS
        EXPRESSION ('[man_made]'='pier')
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            COLOR "#EDEBE6"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 8
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END



    CLASS
        EXPRESSION ('[highway]'='pedestrian' )   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            OUTLINEWIDTH 0.5
            COLOR "#888888"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION ('[highway]'='cycleway' )   
        STYLE
            WIDTH 3
            MAXWIDTH 8
            OUTLINEWIDTH 0.5
            COLOR "#bbbbbb"
            OUTLINECOLOR "#444444"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION ('[highway]'='footway' )   
        STYLE
            WIDTH 3
            MAXWIDTH 8
            OUTLINEWIDTH 0.5
            COLOR "#bbbbbb"
            OUTLINECOLOR "#444444"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION ('[highway]'='steps' )   
        STYLE
            WIDTH 2
            MAXWIDTH 6
            OUTLINEWIDTH 1
            COLOR "#aaaaaa"
            OUTLINECOLOR "#888888"
        END
         STYLE   
            SYMBOL treppe
            COLOR "#888888"
            SIZE 2
            MAXSIZE 6
        END
    END

    CLASS
        EXPRESSION ('[highway]'='path' and ('[sac_scale]'='demanding_mountain_hiking' or '[sac_scale]'='alpine_hiking'))   
        STYLE
            WIDTH 2
            MAXWIDTH 6
            OUTLINEWIDTH 1
            PATTERN 50 50 END
            COLOR "#aaaaaa"
            OUTLINECOLOR "#555555"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION ('[highway]'='path' and ('[sac_scale]'='demanding_alpine_hiking' or '[sac_scale]'='difficult_alpine_hiking'))   
        STYLE
            WIDTH 2
            MAXWIDTH 6
            PATTERN 25 75 END
            OUTLINEWIDTH 1
            COLOR "#aaaaaa"
            OUTLINECOLOR "#555555"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END


    CLASS
        EXPRESSION ('[highway]'='path' )   
        STYLE
            WIDTH 2
            MAXWIDTH 6
            OUTLINEWIDTH 1
            COLOR "#aaaaaa"
            OUTLINECOLOR "#555555"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade2' )   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#886622"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade3' )   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            PATTERN 20 3  END
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#886622"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade4' )   
        STYLE
            WIDTH 4
            PATTERN 8 8  END
            MAXWIDTH 14
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#886622"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION ('[highway]'='track' and ('[tracktype]' = 'grade5' or '[tracktype]' = '' and '[surface]' != 'paved' )  )   
        STYLE
            WIDTH 4
            PATTERN 8 8 2 8  END
            MAXWIDTH 14
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#886622"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION (('[highway]'='living_street' or '[highway]'='service' or ('[highway]'='track' and ('[tracktype]'='grade1' or '[surface]'='paved'))) )   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            OUTLINEWIDTH 0.5
            COLOR "#eeeeee"
            OUTLINECOLOR "#333333"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION (('[highway]'='residential' or ('[highway]'='road')) )   
        STYLE
            WIDTH 16
            MAXWIDTH 14
            OUTLINEWIDTH 0.5
            COLOR "#eeeeee"
            OUTLINECOLOR "#222222"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END
    END

    CLASS
        EXPRESSION (('[highway]'='unclassified' or  ('[highway]'='services')) )   
        STYLE
            WIDTH 18
            MAXWIDTH 14
            OUTLINEWIDTH 0.8
            COLOR "#eeeeee"
            OUTLINECOLOR "#111111"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 18
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION ('[highway]'='tertiary_link' )   
        STYLE
            WIDTH 20
            MAXWIDTH 14
            OUTLINEWIDTH 1
            COLOR "#eeeeee"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='tertiary' )
        STYLE
         WIDTH 20
         MAXWIDTH 14 
         OUTLINEWIDTH 1
         COLOR "#eeeeee"
         OUTLINECOLOR "#000000"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 20
         MAXSIZE 12
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION ('[highway]'='secondary_link' )   
        STYLE
            WIDTH 20
            MAXWIDTH 14
            OUTLINEWIDTH 1
            COLOR "#FFFF77"
            OUTLINECOLOR "#cccc00"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='secondary' )
        STYLE
         WIDTH 20
         MAXWIDTH 14 
         OUTLINEWIDTH 1
         COLOR "#FFFF77"
         OUTLINECOLOR "#cccc00"
        END
        LABEL
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 20
         MAXSIZE 12
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
        EXPRESSION (('[highway]'='trunk_link' or '[highway]'='primary_link') )   
        STYLE
            WIDTH 20
            MAXWIDTH 14 
            OUTLINEWIDTH 1
            COLOR "#FFcc44" 
            OUTLINECOLOR "#dd6600"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk' or '[highway]'='primary') )
        STYLE
           WIDTH 20
            MAXWIDTH 14 
            OUTLINEWIDTH 1
            COLOR "#FFcc44"
            OUTLINECOLOR "#dd6600"
        END
        LABEL
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 25
         MAXSIZE 12
         COLOR "#000000"
         ALIGN CENTER
        END
    END

    CLASS
        EXPRESSION ('[highway]'='motorway_link' )   
        STYLE
            WIDTH 21
            MAXWIDTH 14
            OUTLINEWIDTH 2
            COLOR "#ee9999"
            OUTLINECOLOR "#cc0000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='motorway' )
        STYLE
            WIDTH 21
            MAXWIDTH 14
            OUTLINEWIDTH 2
            COLOR "#ee9999"
            OUTLINECOLOR "#cc0000"
        END
        LABEL
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 25
         MAXSIZE 12
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
      EXPRESSION ('[railway]'='rail' or '[railway]'='narrow_gauge' or '[railway]'='subway')   
     STYLE
        COLOR 200 200 200
        WIDTH 3  
        OUTLINEWIDTH 0.5
        OUTLINECOLOR 102 102 102
      END
      STYLE
        COLOR 102 102 102
        WIDTH 3
        MAXSIZE 8
        PATTERN 12 20 END
      END
    END
END

############################# BRUECKEN GROSSER MASSTAB #####################################################



LAYER
    STATUS ON 
    MAXSCALEDENOM  15000
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "strgrbr"
    DATA "way from (select way,osm_id,highway,ref,name,bridge,tunnel,railway,surface,tracktype,public_transport from osm_line_view where bridge = 'yes' and (highway is not null or railway is not null) order by z_order) as foo using unique osm_id using srid=900913"
    LABELITEM "ref"
    CLASSITEM "highway"
    SIZEUNITS meters

    CLASS
        EXPRESSION ('[highway]'='motorway')
        STYLE
             
            WIDTH 21
            MAXWIDTH 14
            OUTLINEWIDTH 2
            LINECAP butt
            COLOR "#ee9999"
            OUTLINECOLOR "#990000"
        END
    END
    CLASS
        EXPRESSION ('[highway]'='motorway_link')   
        STYLE
            
            WIDTH 21
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 2
            COLOR "#ee9999"
            OUTLINECOLOR "#990000"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk' or '[highway]'='primary'))
        STYLE
             
            WIDTH 20
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 2
            COLOR "#FFcc44" 
            OUTLINECOLOR "#dd6600"
        END
    END
    CLASS
        EXPRESSION (('[highway]'='trunk_link' or '[highway]'='primary_link'))   
        STYLE
            
            WIDTH 20
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 2
            COLOR "#FFcc44" 
            OUTLINECOLOR "#dd6600"
        END
    END


    CLASS
        EXPRESSION ('[highway]'='secondary')
        STYLE
            
            WIDTH 20
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 2
            COLOR "#ffff77"
            OUTLINECOLOR "#bbbb22"
        END
    END
    CLASS
        EXPRESSION ('[highway]'='secondary_link')   
        STYLE
            
            WIDTH 20
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 2
            COLOR "#ffff77"
            OUTLINECOLOR "#bbbb00"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='tertiary')
        STYLE
         WIDTH 20
         
         MAXWIDTH 14 
         LINECAP butt
         OUTLINEWIDTH 1
         COLOR "#eeeeee"
         OUTLINECOLOR "#000000"
        END
    END
    CLASS
        EXPRESSION ('[highway]'='tertiary_link')   
        STYLE
            
            WIDTH 20
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#eeeeee"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='unclassified' or  ('[highway]'='services')))   
        STYLE
            
            WIDTH 18
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.8
            COLOR "#eeeeee"
            OUTLINECOLOR "#000000"
        END
    END


    CLASS
        EXPRESSION (('[highway]'='residential' or ('[highway]'='road')))   
        STYLE
            WIDTH 16
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#eeeeee"
            OUTLINECOLOR "#000000"
        END
    END



    CLASS
        EXPRESSION (('[highway]'='living_street' or '[highway]'='service' or ('[highway]'='track' and ('[tracktype]'='grade1' or '[surface]'='paved'))))   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#eeeeee"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade2')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade3')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            PATTERN 20 3  END
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade4')   
        STYLE
            WIDTH 4
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='track' and ('[tracktype]' = 'grade5' or '[tracktype]' = '' and '[surface]' != 'paved' ))   
        STYLE
            WIDTH 4
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#000000"
        END
    END




    CLASS
        EXPRESSION ('[highway]'='cycleway')   
        STYLE
            WIDTH 4
            MAXWIDTH 8
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#bbbbbb"  
            OUTLINECOLOR "#444444"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='footway')   
        STYLE
            WIDTH 4
            MAXWIDTH 8
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#bbbbbb"  
            OUTLINECOLOR "#444444"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='path')   
        STYLE
            WIDTH 2
            MAXWIDTH 6
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#aaaaaa"
            OUTLINECOLOR "#000000"
        END
    END


    CLASS
        EXPRESSION ('[highway]'='steps')   
        STYLE
            WIDTH 2
            MAXWIDTH 6
            LINECAP butt
            OUTLINEWIDTH 1
            COLOR "#aaaaaa"
            OUTLINECOLOR "#888888"
        END
        STYLE
            SYMBOL treppe
            COLOR "#888888"
            SIZE 2
            MAXSIZE 6
        END  
    END


    CLASS
        EXPRESSION ('[railway]'='platform' or '[public_transport]'='platform')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#808080"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='pedestrian')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINECAP butt
            OUTLINEWIDTH 0.5
            COLOR "#888888"
            OUTLINECOLOR "#000000"
        END
        LABEL
         MAXSCALEDENOM  10000
         ANGLE FOLLOW
         TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 0
         MINDISTANCE 400
         SIZE 16
         MAXSIZE 11
         COLOR "#000000"
         ALIGN CENTER
        END   
    END

    CLASS
      EXPRESSION ('[railway]'='rail' or '[railway]'='narrow_gauge'  or '[railway]'='subway')   
     STYLE
        COLOR 200 200 200
         
        WIDTH 3   
        OUTLINEWIDTH 2
        OUTLINECOLOR 80 80 80
      END
      STYLE
        COLOR 102 102 102
         
        WIDTH 3
        MAXSIZE 8
        PATTERN 12 20 END
      END
    END
END

##################### Trambahn #######################################

LAYER
    STATUS ON 
    MAXSCALEDENOM  5000
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "strgr"
    DATA "way from (select way,osm_id,railway,name,ref,tunnel,bridge from osm_line_view where railway='tram') as foo using unique osm_id using srid=900913"
    LABELITEM "name"
    CLASSITEM "bridge"
    SIZEUNITS meters
    OPACITY 50

    CLASS
     EXPRESSION 'yes'
     STYLE
        COLOR "#eeeeee"
        OUTLINECOLOR "#888888"
        LINECAP butt
        OUTLINEWIDTH 1
        WIDTH 5
        MAXSIZE 12
      END
     STYLE
        COLOR "#333333"
        WIDTH 1
        MAXSIZE 12
        SYMBOL "tram"
      END
    END
    CLASS
     STYLE
        COLOR "#333333"
        WIDTH 1
        MAXSIZE 12
        SYMBOL "tram"
      END
    END
END


################## oneway und noway ####################################

LAYER
    TYPE LINE
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    GROUP "default"
    NAME "oneways"
    CONNECTIONTYPE postgis
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way, osm_id from osm_line where oneway='yes' and highway in ('residential','tertiary','secondary','secondary_link','primary','primary_link','service','unclassified') order by z_order) as foo using unique osm_id using srid=900913"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 10000
    OPACITY 30
    CLASS
        STYLE
            SYMBOL "oneway"
            SIZE 8
            COLOR 90 90 90
        END
    END
END

LAYER
    TYPE LINE
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    GROUP "default"
    NAME "noway"
    CONNECTIONTYPE postgis
    CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432"
    DATA "way from (select way, osm_id, highway,tracktype,surface from osm_line where (motorcar in ('private','no','permissive','destination') or access in('private','no','permissive','destination')) and highway in ('track','residential','service','unclassified') order by z_order) as foo using unique osm_id using srid=900913"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    MAXSCALEDENOM 10000
    SIZEUNITS meters
    OPACITY 50
    CLASS
        EXPRESSION ('[highway]'='track' and ('[tracktype]'='grade2' or '[tracktype]'='grade3' or '[tracktype]'='grade4' or '[tracktype]'='grade5' or ('[tracktype]'='' and '[surface]'!='paved')))
    END
    CLASS
        STYLE
            SYMBOL noaccess
            COLOR 90 90 255
            SIZE 8
            MAXSIZE 14
        END
    END
END






########## Lifte ##################################################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    MAXSCALEDENOM  100000
    TYPE LINE
    NAME "lifte"
    DATA "way from (select way,name,osm_id,aerialway from osm_line where aerialway in ('cable_car','chair_lift','gondola')) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'aerialway'
    SIZEUNITS meters
    
    CLASS
       STYLE
        COLOR "#000000"
        PATTERN 5 50 5  END
        WIDTH   15 
        MAXWIDTH 8
       END  
       STYLE
        COLOR "#000000"
        WIDTH   8 
        MAXWIDTH 2
       END  
    END 
END



############### Namen ##########################################################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    MINSCALEDENOM  1000001
    TYPE ANNOTATION
    NAME "orte2M"
    DATA "way from (select way,osm_id ,place ,name from osm_point where place = 'city' order by population) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'place'
    CLASS
        STYLE
         SIZE   9
         SYMBOL "citycircle"
         COLOR  "#ffffff"
         OUTLINECOLOR "#777777"
         OUTLINEWIDTH 3
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 9
            COLOR "#222222"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 8
            PARTIALS FALSE
            POSITION AUTO
        END
    END
END


LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    MAXSCALEDENOM 1000000
    MINSCALEDENOM  250001
    TYPE ANNOTATION
    NAME "orte1M"
    DATA "way from (select way,osm_id ,place ,name from osm_point where place = 'city' or place = 'town' order by population) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'place'
    CLASS
        EXPRESSION 'city'
        STYLE
         SIZE   9
         SYMBOL "citycircle"
         COLOR  "#ffffff"
         OUTLINECOLOR "#777777"
         OUTLINEWIDTH 3
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 9
            COLOR "#222222"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 8
            PARTIALS FALSE
            POSITION AUTO
        END
    END
    CLASS
        EXPRESSION 'town'
        STYLE
         SIZE   7
         SYMBOL "citycircle"
         COLOR  "#ffffff"
         OUTLINECOLOR "#777777"
         OUTLINEWIDTH 3
        END  
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#222222"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 8
            PARTIALS FALSE
            POSITION AUTO
        END
    END
END

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    MAXSCALEDENOM  250000
    MINSCALEDENOM  100001
    TYPE ANNOTATION
    NAME "orte100k"
    DATA "way from (select way,osm_id ,place ,name from osm_point where  place = 'city' or place = 'town' or place = 'village' or place = 'suburb' order by population) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'place'
    CLASS
        EXPRESSION 'city'
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 14
            COLOR "#222222"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 8
            PARTIALS FALSE
            BUFFER  20
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'town'
        STYLE
         SIZE   7
         SYMBOL "citycircle"
         COLOR  "#ffffff"
         OUTLINECOLOR "#777777"
         OUTLINEWIDTH 3
        END  
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 10
            COLOR "#222222"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 7
            PARTIALS FALSE
            BUFFER 15
            POSITION AUTO
        END
    END
    CLASS
        EXPRESSION 'village'
        STYLE
         SIZE   5
         SYMBOL "citycircle"
         COLOR  "#ffffff"
         OUTLINECOLOR "#777777"
         OUTLINEWIDTH 3
        END  
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#222222"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 6
            PARTIALS FALSE
            BUFFER 10
            POSITION AUTO
        END
    END
    CLASS
        EXPRESSION 'suburb'
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PARTIALS FALSE
            BUFFER 10
            POSITION cc
        END
    END

END

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    MAXSCALEDENOM  100001
    MINSCALEDENOM   15000
    TYPE ANNOTATION
    NAME "orte100k"
    DATA "way from (select way,osm_id ,place ,name from osm_point where  place = 'town' or place = 'village' or  place = 'suburb' or place = 'hamlet' order by population) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'place'
    CLASS
        EXPRESSION ('[place]'='town')
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 11
            COLOR "#777777"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 7
            PARTIALS FALSE
            BUFFER 15
            POSITION auto
        END
    END
    CLASS
        EXPRESSION ('[place]'='village' or '[place]'='suburb')
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 8
            COLOR "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 6
            PARTIALS FALSE
            BUFFER 10
            POSITION auto
        END
    END
    CLASS
        EXPRESSION ('[place]'='hamlet')
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#222222"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 5
            PARTIALS FALSE
            BUFFER 10
            POSITION auto
        END
    END
END

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    MAXSCALEDENOM   15000
    MINSCALEDENOM    5001
    TYPE ANNOTATION
    NAME "orte15k"
    DATA "way from (select way,osm_id ,place ,name from osm_point where place is not null order by population) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'place'
    CLASS
        EXPRESSION ('[place]'='town')
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 11
            COLOR "#777777"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 7
            PARTIALS FALSE
            BUFFER 15
            POSITION auto
        END
    END
    CLASS
        EXPRESSION ('[place]'='village' or '[place]'='suburb')
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 8
            COLOR "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 6
            PARTIALS FALSE
            BUFFER 10
            POSITION auto
        END
    END
    CLASS
        EXPRESSION ('[place]'='hamlet' or '[place]'='isolated_dwelling' or '[place]'='farm' or '[place]'='locality')
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#222222"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 5
            PARTIALS FALSE
            BUFFER 10
            POSITION auto
        END
    END
END

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    MAXSCALEDENOM   5000
    TYPE ANNOTATION
    NAME "orte5k"
    DATA "way from (select way,osm_id ,place ,name from osm_point where place is not null order by population) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'place'
    CLASS
        EXPRESSION ('[place]'='hamlet' or '[place]'='isolated_dwelling' or '[place]'='farm' or '[place]'='locality')
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 9
            COLOR "#222222"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 5
            PARTIALS FALSE
            BUFFER 10
            POSITION auto
        END
    END
END




######################### POIs ##########################################################################################


######### Schulen, Uni... (Beschriftung ohne Icon, Flaechen wurden schon oben erfasst) ###################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 10000
    NAME "iconloselabels"
    DATA "way from (select way,osm_id,place,name,amenity,religion,tourism from osm_point where (amenity IN ('school', 'college', 'university', 'townhall') or tourism='attraction') and not exists (select way from osm_polygon where osm_point.amenity=osm_polygon.amenity and ST_Contains(osm_polygon.way,osm_point.way))) as foo using unique osm_id using srid=900913"

    CLASSITEM 'amenity'
    LABELITEM "name"
    CLASS
        EXPRESSION ('[amenity]'='school' or '[amenity]'='college' or '[amenity]'='university' or '[tourism]'='attraction' or '[amenity]'='townhall')
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          MINDISTANCE 100
          SIZE 7
          PRIORITY 2
          COLOR "#333333"
          OUTLINECOLOR 255 255 255
          WRAP ' '
          MAXLENGTH 5
          ALIGN CENTER
        END
    END
END


################# Kirchen, Synagogen, Moscheen... ###############################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM  15000
    NAME "kirchen"
    DATA "way from (select way,osm_id ,place,name,amenity,religion from osm_point where amenity='place_of_worship' and not exists (select way from osm_polygon where amenity='place_of_worship' and ST_Contains(osm_polygon.way,osm_point.way))  union select centroid(way) as way,osm_id ,place,name,amenity,religion from osm_polygon  where amenity='place_of_worship') as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'religion'
    CLASS
        NAME "Kirche"
        EXPRESSION 'christian'
         SYMBOL ../icons/png/place_of_worship_christian3.p.16.png
    END
    CLASS
        EXPRESSION 'buddhist'
         SYMBOL ../icons/png/place_of_worship_buddhist3.p.16.png
    END
    CLASS
        NAME "Synagoge"
        EXPRESSION 'jewish'
         SYMBOL ../icons/png/place_of_worship_jewish3.p.16.png
    END
    CLASS
        NAME "Moschee"
        EXPRESSION 'muslim'
         SYMBOL ../icons/png/place_of_worship_islamic3.p.16.png
    END
    CLASS
        EXPRESSION 'sikh'
         SYMBOL ../icons/png/place_of_worship_sikh3.p.16.png
    END
    CLASS
         SYMBOL ../icons/png/place_of_worship_unknown3.p.16.png
    END
END


LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 10000
    NAME "kirchen"
    DATA "way from (select way,osm_id ,place,name,amenity,religion from osm_point where amenity='place_of_worship' and not exists (select way from osm_polygon where osm_point.amenity=osm_polygon.amenity and ST_Contains(osm_polygon.way,osm_point.way))  union select centroid(way) as way,osm_id ,place,name,amenity,religion from osm_polygon  where amenity='place_of_worship') as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'religion'
    CLASS
        EXPRESSION 'christian'
        STYLE
         SYMBOL ../icons/png/place_of_worship_christian3.p.16.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'buddhist'
        STYLE
         SYMBOL ../icons/png/place_of_worship_buddhist3.p.16.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'jewish'
        STYLE
         SYMBOL ../icons/png/place_of_worship_jewish3.p.16.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'muslim'
        STYLE
         SYMBOL ../icons/png/place_of_worship_islamic3.p.16.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 5
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'sikh'
        STYLE
         SYMBOL ../icons/png/place_of_worship_sikh3.p.16.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION AUTO
        END
    END
    CLASS
        STYLE
         SYMBOL ../icons/png/place_of_worship_unknown3.p.16.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            PARTIALS FALSE
            WRAP ' '
            POSITION auto
        END
    END
END

################# Krankenhaeuser, wieder erst icon, dann icon-text  ###############################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM  15000
    NAME "hospitaeler"
    DATA "way from (select way,osm_id,name,amenity from osm_point where amenity='hospital' and not exists (select way from osm_polygon where amenity='hospital' and ST_Contains(osm_polygon.way,osm_point.way))  union select centroid(way) as way,osm_id,name,amenity from osm_polygon  where amenity='hospital') as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'amenity'
    CLASS
         SYMBOL ../icons/png/health_hospital.n.12.png
    END
END


LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 10000
    NAME "hospitaeler"
    DATA "way from (select way,osm_id,name,amenity from osm_point where amenity='hospital' and not exists (select way from osm_polygon where osm_point.amenity=osm_polygon.amenity and ST_Contains(osm_polygon.way,osm_point.way))  union select centroid(way) as way,osm_id,name,amenity from osm_polygon  where amenity='hospital') as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'amenity'
    CLASS
        NAME "Krankenhaus"
        STYLE
         SYMBOL ../icons/png/health_hospital.n.12.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#cc2222"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 3
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
END


################# Spielplaetze  ###############################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM  10000
    NAME "playground"
    DATA "way from (select way,osm_id from osm_point where leisure='playground' and not exists (select way from osm_polygon where leisure='playground' and ST_Contains(osm_polygon.way,osm_point.way))  union select centroid(way) as way,osm_id from osm_polygon  where leisure='playground') as foo using unique osm_id using srid=900913"
    CLASS
         NAME "Spielplatz"
         SYMBOL ../icons/png/amenity_playground.glow.20.png
    END
END

################# Sport ####################################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM  10000
    NAME "playground"
    DATA "way from (select way,osm_id,sport,leisure from osm_point where (sport is not null or leisure='pitch') and not exists (select way from osm_polygon where (sport is not null or leisure='pitch') and ST_Contains(osm_polygon.way,osm_point.way))  union select centroid(way) as way,osm_id,sport,leisure from osm_polygon  where sport is not null or leisure='pitch') as foo using unique osm_id using srid=900913"
    CLASSITEM 'sport'
    CLASS
     EXPRESSION 'archery'
     SYMBOL ../icons/png/sport_archery.glow.20.png
    END
    CLASS
     EXPRESSION 'baseball'
     SYMBOL ../icons/png/sport_baseball.glow.20.png
    END
    CLASS
     EXPRESSION 'bogenschiessen'
     SYMBOL ../icons/png/sport_archery.glow.20.png
    END
    CLASS
     EXPRESSION 'canoe'
     SYMBOL ../icons/png/sport_canoe.glow.20.png
    END
    CLASS
     EXPRESSION 'climbing'
     SYMBOL ../icons/png/sport_hillclimbing.glow.20.png
    END
    CLASS
     EXPRESSION 'equestrian'
     SYMBOL ../icons/png/sport_horse_racing.glow.20.png
    END
    CLASS
     EXPRESSION 'golf'
     SYMBOL ../icons/png/sport_golf.glow.20.png
    END
    CLASS
     EXPRESSION 'gym'
     SYMBOL ../icons/png/sport_gym.glow.20.png
    END
    CLASS
     EXPRESSION 'gymnastics'
     SYMBOL ../icons/png/sport_gym.glow.20.png
    END
    CLASS
     EXPRESSION 'horse_racing'
     SYMBOL ../icons/png/sport_horse_racing.glow.20.png
    END
    CLASS
     EXPRESSION 'ice'
     SYMBOL ../icons/png/sport_iceskating.glow.20.png
    END
    CLASS
     EXPRESSION 'ice_hockey'
     SYMBOL ../icons/png/sport_iceskating.glow.20.png
    END
    CLASS
     EXPRESSION 'ice_skating'
     SYMBOL ../icons/png/sport_iceskating.glow.20.png
    END
    CLASS
     EXPRESSION 'inlinehockey'
     SYMBOL ../icons/png/sport_iceskating.glow.20.png
    END
    CLASS
     EXPRESSION 'miniature_golf'
     SYMBOL ../icons/png/sport_miniature_golf.glow.20.png
    END
    CLASS
     EXPRESSION 'motocross'
     SYMBOL ../icons/png/sport_motorracing.glow.20.png
    END
    CLASS
     EXPRESSION 'motor'
     SYMBOL ../icons/png/sport_motorracing.glow.20.png
    END
    CLASS
     EXPRESSION 'motorcycle'
     SYMBOL ../icons/png/sport_motorracing.glow.20.png
    END
    CLASS
     EXPRESSION 'polo'
     SYMBOL ../icons/png/sport_horse_racing.glow.20.png
    END
    CLASS
     EXPRESSION 'sailing'
     SYMBOL ../icons/png/sport_sailing.glow.20.png
    END
    CLASS
     EXPRESSION 'scuba_diving'
     SYMBOL ../icons/png/sport_diving.glow.20.png
    END
    CLASS
     EXPRESSION 'shooting'
     SYMBOL ../icons/png/sport_shooting.glow.20.png
    END
    CLASS
     EXPRESSION 'ski-jump'
     SYMBOL ../icons/png/sport_skiing_downhill.glow.20.png
    END
    CLASS
     EXPRESSION 'skiing'
     SYMBOL ../icons/png/sport_skiing_downhill.glow.20.png
    END
    CLASS
     EXPRESSION 'soccer'
     SYMBOL ../icons/png/sport_soccer.glow.16.png
    END
    CLASS
     EXPRESSION 'swimming'
     SYMBOL ../icons/png/sport_swimming_outdoor.glow.20.png
    END
    CLASS
     EXPRESSION 'swimming_pool'
     SYMBOL ../icons/png/sport_swimming_outdoor.glow.20.png
    END
    CLASS
     EXPRESSION 'tennis'
     SYMBOL ../icons/png/sport_tennis.glow.16.png
    END
   CLASS
     NAME "Sportplatz"
     EXPRESSION ('[leisure]'='pitch')
     SYMBOL ../icons/png/sport_soccer.glow.16.png
    END  
    CLASS
     SYMBOL ../icons/png/sport_leisure_centre.glow.16.png
    END
END



LAYER
    STATUS OFF 
    GROUP "notdefault" 
    PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM  1000000
    NAME "hydranten"
    DATA "way from (select way,osm_id from osm_point where  amenity like '%hydra%' or tags->'emergency' like '%hydra%' ) as foo using unique osm_id using srid=900913"
    CLASS
     NAME "Hydrant"
     SYMBOL ../icons/png/poi_tower_water.n.12.png
    END
END








################# Flughaefen  ###############################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM  150000
    NAME "aerodrome"
    DATA "way from (select way,osm_id,name,amenity from osm_point where aeroway='aerodrome' and not exists (select way from osm_polygon where aeroway='aerodrome' and ST_Contains(osm_polygon.way,osm_point.way))  union select centroid(way) as way,osm_id,name,amenity from osm_polygon  where aeroway='aerodrome') as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'amenity'
    CLASS
         SYMBOL ../icons/png/transport_airport.n.12.png
    END
END


LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 30000
    NAME "aerodrome"
    DATA "way from (select way,osm_id,name,amenity from osm_point where aeroway='aerodrome' and not exists (select way from osm_polygon where aeroway='aerodrome' and ST_Contains(osm_polygon.way,osm_point.way))  union select centroid(way) as way,osm_id,name,amenity from osm_polygon  where aeroway='aerodrome') as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'amenity'
    CLASS
        STYLE
         SYMBOL ../icons/png/transport_airport.n.12.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#2222ff"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 3
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
END


################# Bahnhof, wieder erst icon, dann icon-text  ###############################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM  30000
    MINSCALEDENOM  15001
    NAME "bahnhoefe"
    DATA "way from (select way,osm_id,name,service,amenity,railway from osm_point where railway='station' or railway='tram_stop' union select centroid(way) as way,osm_id,name,service,amenity,railway from osm_polygon where railway='station' and not exists (select way from osm_point where railway='station' and ST_Contains(osm_polygon.way,osm_point.way))) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'service'
    CLASS
     EXPRESSION 'ubahn'   
       NAME "U-Bahnhof"
       STYLE
         SYMBOL ../icons/png/transport_u-bahn.p.10.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#2222cc"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            BUFFER  4
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
    CLASS
     EXPRESSION 'sbahn'
       NAME "S-Bahnhof"   
       STYLE
         SYMBOL ../icons/png/transport_s-bahn.p.10.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#2222cc"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            BUFFER  4
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
    CLASS
       NAME "Bahnhof"
       STYLE
         SIZE   7
         SYMBOL "citycircle"
         COLOR  "#2222cc"
         OUTLINECOLOR "#777777"
         OUTLINEWIDTH 1
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#2222cc"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            BUFFER  4
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END

END

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM  15000
    NAME "bahnhoefe"
    DATA "way from (select way,osm_id,name,service,amenity,railway from osm_point where railway='station' or railway='tram_stop' union select centroid(way) as way,osm_id,name,service,amenity,railway from osm_polygon where railway='station' and not exists (select way from osm_point where railway='station' and ST_Contains(osm_polygon.way,osm_point.way))) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'service'
    CLASS
     EXPRESSION 'ubahn'
      NAME "U-Bahnhof"
      SYMBOL ../icons/png/transport_u-bahn.p.16.png
    END
    CLASS
     EXPRESSION 'sbahn'
      NAME "S-Bahnhof"
      SYMBOL ../icons/png/transport_s-bahn.p.16.png
    END
    CLASS
      NAME "Bahnhof"
      EXPRESSION ('[railway]'='station')
     SYMBOL ../icons/png/transport_train_station2.n.16.png
    END
    CLASS
     MAXSCALEDENOM 10000
     NAME "Trambahnstation" 
     EXPRESSION ('[railway]'='tram_stop')
     SYMBOL ../icons/png/transport_tram_stop.n.16.png
    END
    
END


LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 15000
    NAME "bahnhoefe"
    DATA "way from (select way,osm_id,name,service,amenity,railway from osm_point where railway='station' or railway='tram_stop' union select centroid(way) as way,osm_id,name,service,amenity,railway from osm_polygon where railway='station' and not exists (select way from osm_point where railway='station' and ST_Contains(osm_polygon.way,osm_point.way))) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'service'
    CLASS
     EXPRESSION 'ubahn'
        STYLE
         SYMBOL ../icons/png/transport_u-bahn.p.16.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#2222cc"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
    CLASS
     EXPRESSION 'sbahn'
        STYLE
         SYMBOL ../icons/png/transport_s-bahn.p.16.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#2222cc"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
    CLASS
        EXPRESSION ('[railway]'='station')
        STYLE
         SYMBOL ../icons/png/transport_train_station2.n.16.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#2222cc"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
    CLASS
        EXPRESSION ('[railway]'='tram_stop')
        MAXSCALEDENOM 5000
        STYLE
         SYMBOL ../icons/png/transport_tram_stop.n.16.png 
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#2222cc"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 2
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
END





########################### Hausnummern ########################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 5000
    NAME "hausnummern"
    DATA "way from (select way,osm_id,housenumber from  osm_addr_view) as foo using unique osm_id using srid=900913"
    LABELITEM 'housenumber'
    CLASS
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 6
            COLOR "#111111"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 1
            ALIGN CENTER
            PRIORITY 1
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
END

########################### Gipfel ########################################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 1000000
    MINSCALEDENOM 250001
    NAME "GIPFEL"
    DATA "way from (select way,osm_id,ele,name,elename,isolation from osm_peak_view where nature='peak' and name is not null and cast(isolation as integer)>5000 and cast(ele as integer)>1500 order by cast(isolation as integer)) as foo using unique osm_id using srid=900913"
    LABELITEM 'elename'
    CLASS
        STYLE
         SYMBOL ../icons/png/poi_peak.p.9.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#000000"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 1
            ALIGN CENTER
            PRIORITY 2
            BUFFER 10
            PARTIALS FALSE
            MAXLENGTH 2
            WRAP '|'
            POSITION lc
        END
    END
END


LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 250000
    MINSCALEDENOM 100001
    NAME "GIPFEL"
    DATA "way from (select way,osm_id,ele,name,elename,isolation from osm_peak_view where nature='peak' and name is not null and cast(isolation as integer)>500 order by cast(isolation as integer)) as foo using unique osm_id using srid=900913"
    LABELITEM 'elename'
    CLASS
        STYLE
         SYMBOL ../icons/png/poi_peak.p.9.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#000000"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 1
            ALIGN CENTER
            PRIORITY 2
            BUFFER 10
            PARTIALS FALSE
            MAXLENGTH 2
            WRAP '|'
            POSITION lc
        END
    END
END

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 100000
    NAME "GIPFEL"
    DATA "way from (select way,osm_id,ele,name,elename,isolation,nature,mountain_pass from osm_peak_view where nature='peak' or mountain_pass='yes' order by cast(isolation as integer)) as foo using unique osm_id using srid=900913"
    LABELITEM 'elename'
    CLASSITEM 'nature'
    CLASS
        EXPRESSION 'peak'
        STYLE
         SYMBOL ../icons/png/poi_peak.p.9.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#000000"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 1
            ALIGN CENTER
            PRIORITY 2
            BUFFER 10
            PARTIALS FALSE
            MAXLENGTH 2
            WRAP '|'
            POSITION lc
        END
    END
       CLASS
        EXPRESSION ('[mountain_pass]'='yes')
        STYLE
         SIZE   5
         SYMBOL "citycircle"
         COLOR  "#000000"
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#333333"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 1
            ALIGN CENTER
            PRIORITY 1
            BUFFER 5
            PARTIALS FALSE
            MAXLENGTH 2
            WRAP '|'
            POSITION lc
        END
    END
    
END





########## Huetten ###############################

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=xxx user=xxx password=xxx port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM  30000
    NAME "huette"
    DATA "way from (select way,osm_id,tourism,name,ele,name||'|'||ele as elename from osm_point where tourism='alpine_hut' and not exists (select way from osm_polygon where tourism='alpine_hut' and ST_Contains(osm_polygon.way,osm_point.way))  union select centroid(way) as way,osm_id,tourism,name,'' as ele,name as elename from osm_polygon where tourism='alpine_hut') as foo using unique osm_id using srid=900913"
    LABELITEM 'elename'
    CLASSITEM 'tourism'   
    CLASS
         MINSCALEDENOM  15001
         NAME "huette"
         style
          SYMBOL ../icons/png/house.red.14.png
         END
    END
    CLASS
         MAXSCALEDENOM  15000
         NAME "huette"
         style
          SYMBOL ../icons/png/house.red.16.png
         END
         LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 8
            COLOR "#aa0000"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 1
            ALIGN LEFT
            PRIORITY 1
            BUFFER 5
            PARTIALS FALSE
            MAXLENGTH 2
            WRAP '|'
            POSITION cr
        END
    END
END


######### Copyright ##############################

LAYER 
  NAME "CR"
  STATUS OFF
  TYPE annotation
  TRANSFORM ll
  UNITS PIXELS

  FEATURE
    POINTS
       1 -11
    END
    TEXT "Daten von OpenStreetMap und openDEM, CC-BY-SA"
  END
  CLASS
    LABEL
      STYLE
       GEOMTRANSFORM 'labelpoly'
       COLOR "#EDEBE6"
       OFFSET 0 0
      END
      FONT sc
      TYPE TRUETYPE
      SIZE 8   
      BUFFER 4
      ANGLE 0
      POSITION lr
      COLOR "#000000"
      ANTIALIAS TRUE
      OUTLINECOLOR "#ffffff"
      FORCE TRUE
    END
  END
END

SCALEBAR
  UNITS kilometers
  INTERVALS 2
  STATUS OFF
  POSITION lr
  TRANSPARENT OFF
  STYLE 0
  IMAGECOLOR "#EDEBE6"
  LABEL
    POSITION ul
    TYPE TRUETYPE
    FONT sc
    SIZE 8
    COLOR 1 1 1 
  END
  SIZE 280 8
  COLOR 235 235 235
  BACKGROUNDCOLOR 100 100 100
  OUTLINECOLOR 0 0 0
END

LEGEND
 KEYSIZE 30 10
 IMAGECOLOR "#777777"
 KEYSPACING 10 10
 STATUS OFF
 POSITION UR
END



#################################################################################################
END # of MAP