MAP
OUTPUTFORMAT
    NAME agg
    DRIVER AGG/PNG
    IMAGEMODE RGB
    FORMATOPTION "INTERLACE=OFF"
    MIMETYPE "image/png"
END
OUTPUTFORMAT
    NAME svg
    MIMETYPE "image/svg+xml"
    DRIVER svg
    FORMATOPTION  "COMPRESSED_OUTPUT=FALSE"
    FORMATOPTION  "FULL_RESOLUTION=TRUE"
END


FONTSET "osmfonts.lst"
IMAGETYPE agg
MAXSIZE 4000
SIZE 800 800
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
CONFIG "PROJ_LIB" "/home/www/wms/osmutils"
PROJECTION
"init=epsg:900913"
END


SYMBOL
   NAME bridge
   TYPE SIMPLE
END

SYMBOL
   NAME tunnelstrichel
   TYPE SIMPLE
   PATTERN 8 12  END
END

SYMBOL
    NAME ganzlangkurz
    TYPE SIMPLE
   PATTERN 20 3  END
END

SYMBOL
    NAME kurzkurz
    TYPE SIMPLE
   PATTERN 2 1  END
END   

SYMBOL
    NAME langkurz
    TYPE SIMPLE
   PATTERN 8 3  END
END

SYMBOL
    NAME langlang
    TYPE SIMPLE
   PATTERN 8 8  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=osm user=osm password=X port=5432"
    DATA "way from (select way,osm_id ,landuse, CAST(area as float) as area, name from osm_polygon_view where landuse IN ('industrial', 'commercial', 'airport', 'brownfield', 'military', 'railway', '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 ([area] gt 1000000  and ('[landuse]'='airport' or '[landuse]'='military' or '[landuse]'='railway'))
        STYLE
            COLOR "#aaaaaa"
        END
        LABEL
        TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
        MAXSCALEDENOM 10000
            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')
        STYLE
            COLOR "#aaaaaa"
        END
    END
    CLASS
        EXPRESSION ('[landuse]'='residential')
        STYLE
            COLOR "#cccccc"
        END
    END
END

LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    GROUP "default"
    NAME "park"
    CONNECTIONTYPE postgis
    CONNECTION "host=localhost dbname=osm user=osm password=X 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 landuse='playground' or landuse='village_green' or landuse='cemetery' or amenity='grave_yard' or sport is not null) 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')
        STYLE
            COLOR "#AAAA88"
        END
        LABEL
        TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
        MAXSCALEDENOM 10000
            SIZE 7
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            PRIORITY 2
           WRAP ' '
           MAXLENGTH 6
            ALIGN CENTER
        END
 END
 CLASS
        EXPRESSION ('[leisure]'='garden' or '[leisure]'='playground')
        STYLE
            COLOR "#AAFFAA"
        END
 END

 CLASS
        EXPRESSION ([area] gt 100000)
        STYLE
            COLOR "#AADDAA"
        END
        LABEL
        TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
        MAXSCALEDENOM 30000
            SIZE 7
            COLOR "#447755"
            OUTLINECOLOR 255 255 255
            PRIORITY 2
            POSITION cc
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
        END
    END
 CLASS
        EXPRESSION ([area] gt 10000)
        STYLE
            COLOR "#AADDAA"
        END
        LABEL
        TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
        MAXSCALEDENOM 10000
            SIZE 7
            COLOR "#557755"
            OUTLINECOLOR 255 255 255
            PRIORITY 2
            POSITION cc
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
        END
    END
 CLASS
        STYLE
            COLOR "#AADDAA"
        END
        LABEL
        TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
        MAXSCALEDENOM 1000
            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=osm user=osm password=X 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
         LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
            MAXSCALEDENOM 10000
            SIZE 7
            COLOR 0 0 0
            OUTLINECOLOR 255 255 255
            PRIORITY 1
            WRAP ' '
            MAXLENGTH 6
            ALIGN CENTER
        END
    END
    CLASS
        EXPRESSION ("[amenity]"="parking" or "[aeroway]"="apron")
        STYLE
            COLOR "#cccccc"
        END
    END
    CLASS
        EXPRESSION ('[amenity]'='school' or '[amenity]'='college' or '[amenity]'='university' )
        STYLE
            COLOR "#DDAAAA"
        END
        LABEL
            TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
            MAXSCALEDENOM 12000
            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=osm user=osm password=X port=5432"
    DATA "way from (select way,osm_id ,CAST(area as float) as area,nature,landuse ,highway, name from osm_polygon_view where landuse is not null or nature='wood' or highway='pedestrian' or highway='residential') 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
        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
        EXPRESSION ('[nature]'='wood' or '[landuse]'="forest")
        STYLE
            COLOR "#88bb88"
            OUTLINEWIDTH 0.3
        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
        EXPRESSION ('[nature]'='marsh' or '[nature]'='wetland' or '[nature]'='swamp')
        STYLE
            COLOR "#8888AA"
            OUTLINEWIDTH 0.3
        END
    END
    CLASS
        EXPRESSION ('[nature]'='scrub')
        STYLE
            COLOR "#BB88AA"
            OUTLINEWIDTH 0.3
        END
    END
    CLASS
        EXPRESSION ('[nature]'='cliff' or or '[nature]'='rock')
        STYLE
            COLOR "#EEEEEE"
            OUTLINEWIDTH 0.3
        END
    END
    CLASS
        EXPRESSION ('[nature]'='glacier')
        STYLE
            COLOR "#EEEEFF"
            OUTLINEWIDTH 0.3
        END
    END

  CLASS
        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"
        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
END


LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    NAME "stehendeswasser"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=osm user=osm password=X 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=osm user=osm password=X port=5432"
    DATA "way from (select way,waterway,osm_id from osm_line where 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
            COLOR "#8888ff"
            WIDTH 30
            MINWIDTH 0.5
        END
    END
    CLASS
        MAXSCALEDENOM 105000
        EXPRESSION "stream"
        STYLE
            COLOR "#8888ff"
            WIDTH 5
            MINWIDTH 0.5
        END
    END
    CLASS
        EXPRESSION "canal"
        STYLE
            COLOR "#8888ff"
            WIDTH 10
            MINWIDTH 0.5
        END
    END
    CLASS
        MAXSCALEDENOM 105000
        EXPRESSION "drain"
        STYLE
            COLOR "#8888ff"
            WIDTH 10
            MINWIDTH 0.5
        END
    END
END

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

LAYER
    TYPE POLYGON
    STATUS ON
    PROJECTION
        "init=epsg:900913"
    END
    NAME "haeuser"
    GROUP "default"
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost dbname=osm user=osm password=X 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]'='school' or '[amenity]'='college' or '[amenity]'='university' or '[tourism]'='attraction' or '[amenity]'='townhall' or '[amenity]'='hospital')
        STYLE
            COLOR "#aa7777"
        END
        LABEL
          TYPE TRUETYPE FONT sc PARTIALS FALSE OUTLINEWIDTH 3
          MAXSCALEDENOM 12000
          MINDISTANCE 400
          SIZE 7
          COLOR "#333333"
          OUTLINECOLOR 255 255 255
          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=osm user=osm password=X port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "winzigestr"
    DATA "way from (select way,osm_id,highway from osm_line where highway = 'unclassified' or highway = 'residential' or highway = 'services' or highway = 'pedestrian' or highway = 'services' or highway = 'track' order by z_order) as foo using unique osm_id using srid=900913"
    CLASSITEM "highway"
    SIZEUNITS meters
    CLASS

    CLASS
        STYLE
         WIDTH 3
         MAXWIDTH 5
         COLOR "#888888"
        END
    END

END

LAYER
    MAXSCALEDENOM 2000000
    MINSCALEDENOM  250000  
    STATUS ON 
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=osm user=osm password=X 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=osm user=osm password=X 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 60
         MAXWIDTH 3
         COLOR "#333333"
        END
    END
END

LAYER
    MAXSCALEDENOM 2000000
    STATUS ON 
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=osm user=osm password=X 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 "#333333"
        END
    END
END

LAYER
    MAXSCALEDENOM 2000000
    STATUS ON 
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=osm user=osm password=X 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 "#333333"
        END
    END
END






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

LAYER
    STATUS ON 
    MAXSCALEDENOM 250000
    MINSCALEDENOM  15001
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=osm user=osm password=X port=5432" 
    PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE LINE
    NAME "strkl"
    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"
    LABELITEM "ref"
    CLASSITEM "highway"
    SIZEUNITS meters
    CLASS
        EXPRESSION ('[highway]'='motorway' and '[tunnel]'='yes')
        STYLE
            WIDTH 10
            MAXWIDTH 12
            OUTLINEWIDTH 2
            COLOR "#ff0000"
            OUTLINECOLOR "#bb0000"
            OPACITY 20
        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]'='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]'='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]'='secondary' and '[tunnel]'='yes')
        STYLE
            WIDTH 10
            MAXWIDTH 12
            OUTLINEWIDTH 1
            COLOR "#FFFF00"
            OUTLINECOLOR "#bbbb00"
            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]'='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]'='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 ('[railway]'='rail' and '[tunnel]'='yes')   
        STYLE
            WIDTH 2
            MAXWIDTH 5
            COLOR "#111111"
            OPACITY 30
        END
    END




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

    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 ('[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]'='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]'='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]'='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]'='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]'='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]'='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 ('[railway]'='rail' 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=osm user=osm password=X 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' 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 10
            MAXWIDTH 12
            OUTLINEWIDTH 2
            SYMBOL "bridge"
            COLOR "#ff0000"
            OUTLINECOLOR "#990000"
        END
    END
    CLASS
        EXPRESSION ('[highway]'='motorway_link' )   
        STYLE
            WIDTH 10
            MAXWIDTH 12
            SYMBOL "bridge"
            OUTLINEWIDTH 2
            COLOR "#ff0000"
            OUTLINECOLOR "#990000"
        END
    END

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


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

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

    CLASS
        EXPRESSION ('[railway]'='rail' )   
        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=osm user=osm password=X 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 from osm_line where (CAST(layer as float)<0 or tunnel = '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 "name"
    CLASSITEM "highway"
    SIZEUNITS meters
    OPACITY   40    

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

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


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

    CLASS
        EXPRESSION ('[highway]'='tertiary' )
        STYLE
         WIDTH 20
         MAXWIDTH 14 
         SYMBOL "bridge"
         LINEJOIN NONE
         OUTLINEWIDTH 0.2
         COLOR "#ffffff"
         OUTLINECOLOR "#cccccc"
        END
    END
    CLASS
        EXPRESSION ('[highway]'='tertiary_link' )   
        STYLE
            WIDTH 20
            MAXWIDTH 14
            SYMBOL "bridge"
            LINEJOIN NONE
            OUTLINEWIDTH 0.3
            COLOR "#eeeeee"
            OUTLINECOLOR "#cccccc"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='unclassified' or  ('[highway]'='services')) )   
        STYLE
            WIDTH 18
            MAXWIDTH 14
            LINEJOIN NONE
            OUTLINEWIDTH 0.2
            COLOR "#eeeeee"
            OUTLINECOLOR "#cccccc"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='residential' or ('[highway]'='road')) )   
        STYLE
            WIDTH 16
            MAXWIDTH 14
            LINEJOIN NONE
            OUTLINEWIDTH 0.1
            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
            LINEJOIN NONE
            OUTLINEWIDTH 0.5
            COLOR "#eeeeee"
            OUTLINECOLOR "#333333"
        END
    END

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

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade3')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINEJOIN NONE
            SYMBOL ganzlangkurz
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#886622"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade4')   
        STYLE
            WIDTH 4
            MAXWIDTH 14
            LINEJOIN NONE
            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
            LINEJOIN NONE
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#886622"
        END
    END




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

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

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



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

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


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

END


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


LAYER
    STATUS ON 
    MAXSCALEDENOM  15000
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=osm user=osm password=X 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 from osm_line 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) order by z_order) as foo using unique osm_id using srid=900913"
    LABELITEM "name"
    CLASSITEM "highway"
    SIZEUNITS meters

    CLASS
        EXPRESSION ('[highway]'='motorway' )
        STYLE
            WIDTH 21
            MAXWIDTH 14
            LINEJOIN NONE
            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 ('[highway]'='motorway_link' )   
        STYLE
            WIDTH 21
            MAXWIDTH 14
            LINEJOIN NONE
            OUTLINEWIDTH 2
            COLOR "#ee9999"
            OUTLINECOLOR "#cc0000"
        END
    END

    CLASS
        EXPRESSION (('[highway]'='trunk' or '[highway]'='primary') )
        STYLE
           WIDTH 20
            MAXWIDTH 14 
            LINEJOIN NONE
            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]'='trunk_link' or '[highway]'='primary_link') )   
        STYLE
            WIDTH 20
            MAXWIDTH 14 
            LINEJOIN NONE
            OUTLINEWIDTH 1
            COLOR "#FFcc44" 
            OUTLINECOLOR "#dd6600"
        END
    END


    CLASS
        EXPRESSION ('[highway]'='secondary' )
        STYLE
         WIDTH 20
         MAXWIDTH 14 
         LINEJOIN NONE
         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]'='secondary_link' )   
        STYLE
            WIDTH 20
            MAXWIDTH 14
            SYMBOL "bridge"
            LINEJOIN NONE
            OUTLINEWIDTH 1
            COLOR "#FFFF77"
            OUTLINECOLOR "#cccc00"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='tertiary' )
        STYLE
         WIDTH 20
         MAXWIDTH 14 
         LINEJOIN NONE
         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]'='tertiary_link' )   
        STYLE
            WIDTH 20
            MAXWIDTH 14
            SYMBOL "bridge"
            LINEJOIN NONE
            OUTLINEWIDTH 1
            COLOR "#eeeeee"
            OUTLINECOLOR "#000000"
        END
    END


    CLASS
        EXPRESSION (('[highway]'='unclassified' or  ('[highway]'='services')) )   
        STYLE
            WIDTH 18
            MAXWIDTH 14
            LINEJOIN NONE
            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]'='residential' or ('[highway]'='road')) )   
        STYLE
            WIDTH 16
            MAXWIDTH 14
            LINEJOIN NONE
            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]'='living_street' or '[highway]'='service' or ('[highway]'='track' and ('[tracktype]'='grade1' or '[surface]'='paved'))) )   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINEJOIN NONE
            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]'='track' and '[tracktype]' = 'grade2' )   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINEJOIN NONE
            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
            LINEJOIN NONE
            SYMBOL ganzlangkurz
            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
            SYMBOL langkurz
            MAXWIDTH 14
            LINEJOIN NONE
            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
            SYMBOL langlang
            MAXWIDTH 14
            LINEJOIN NONE
            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]'='cycleway' )   
        STYLE
            WIDTH 3
            MAXWIDTH 8
            LINEJOIN NONE
            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
            LINEJOIN NONE
            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]'='path' )   
        STYLE
            WIDTH 2
            MAXWIDTH 6
            LINEJOIN NONE
            OUTLINEWIDTH 1
            COLOR "#aaaaaa"
            OUTLINECOLOR "#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]'='steps' )   
        STYLE
            WIDTH 2
            MAXWIDTH 6
            SYMBOL kurzkurz
            LINEJOIN NONE
            OUTLINEWIDTH 1
            COLOR "#aaaaaa"
            OUTLINECOLOR "#888888"
        END
    END




    CLASS
        EXPRESSION ('[highway]'='pedestrian' )   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINEJOIN NONE
            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 (('[railway]'='rail' or '[railway]'='xtram') )   
        STYLE
            WIDTH 2
            MAXWIDTH 5
            COLOR "#111111"
        END
    END


END

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



LAYER
    STATUS ON 
    MAXSCALEDENOM  15000
    GROUP "default" 
    CONNECTIONTYPE postgis 
    CONNECTION "host=localhost dbname=osm user=osm password=X 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 from osm_line 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
            SYMBOL "bridge"
            COLOR "#ee9999"
            OUTLINECOLOR "#990000"
        END
    END
    CLASS
        EXPRESSION ('[highway]'='motorway_link')   
        STYLE
            WIDTH 21
            MAXWIDTH 14
            SYMBOL "bridge"
            OUTLINEWIDTH 2
            COLOR "#ee9999"
            OUTLINECOLOR "#990000"
        END
    END

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


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

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

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


    CLASS
        EXPRESSION (('[highway]'='residential' or ('[highway]'='road')))   
        STYLE
            WIDTH 16
            MAXWIDTH 14
            SYMBOL "bridge"
            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
            LINEJOIN NONE
            OUTLINEWIDTH 0.5
            COLOR "#eeeeee"
            OUTLINECOLOR "#000000"
        END
    END

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

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade3')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            LINEJOIN NONE
            SYMBOL ganzlangkurz
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#000000"
        END
    END

    CLASS
        EXPRESSION ('[highway]'='track' and '[tracktype]' = 'grade4')   
        STYLE
            WIDTH 4
            MAXWIDTH 14
            LINEJOIN NONE
            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
            LINEJOIN NONE
            OUTLINEWIDTH 0.5
            COLOR "#bb8844"
            OUTLINECOLOR "#000000"
        END
    END




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

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

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


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


    CLASS
        EXPRESSION ('[highway]'='pedestrian')   
        STYLE
            WIDTH 8
            MAXWIDTH 14
            SYMBOL "bridge"
            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'))
        STYLE
            WIDTH 2
            MAXWIDTH 7
            OUTLINEWIDTH 3
            COLOR "#111111"
            OUTLINECOLOR "#aaaaaa"
        END
    END

END








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

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=osm user=osm password=X 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 "#555555"
            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=osm user=osm password=X 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 "#555555"
            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 "#555555"
            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=osm user=osm password=X 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 "#777777"
            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 "#777777"
            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 "#555555"
            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=osm user=osm password=X 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 "#555555"
            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=osm user=osm password=X 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 "#555555"
            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=osm user=osm password=X 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 "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            ALIGN CENTER
            PRIORITY 5
            PARTIALS FALSE
            BUFFER 10
            POSITION auto
        END
    END
END



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


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

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=osm user=osm password=X port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM 15000
    MINSCALEDENOM  5001
    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))) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'religion'
    CLASS
        EXPRESSION 'christian'
         SYMBOL ../icons/png/place_of_worship_christian.p.16.png
    END
    CLASS
        EXPRESSION 'buddhist'
         SYMBOL ../icons/png/place_of_worship_buddhist.p.16.png
    END
    CLASS
        EXPRESSION 'jewish'
         SYMBOL ../icons/png/place_of_worship_jewish.p.16.png
    END
    CLASS
        EXPRESSION 'muslim'
         SYMBOL ../icons/png/place_of_worship_islamic.p.16.png
    END
    CLASS
        EXPRESSION 'sikh'
         SYMBOL ../icons/png/place_of_worship_sikh.p.16.png
    END
    CLASS
         SYMBOL ../icons/png/place_of_worship_unknown.p.16.png
    END
END

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=osm user=osm password=X port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM 15000
    MINSCALEDENOM  5001
    NAME "kirchen"
    DATA "way from (select centroid(way) as way,osm_id,place,name,amenity,religion from osm_polygon where building is not null and amenity='place_of_worship') as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'religion'
    CLASS
        EXPRESSION 'christian'
         SYMBOL ../icons/png/place_of_worship_christian.p.16.png
    END
    CLASS
        EXPRESSION 'buddhist'
         SYMBOL ../icons/png/place_of_worship_buddhist.p.16.png
    END
    CLASS
        EXPRESSION 'jewish'
         SYMBOL ../icons/png/place_of_worship_jewish.p.16.png
    END
    CLASS
        EXPRESSION 'muslim'
         SYMBOL ../icons/png/place_of_worship_islamic.p.16.png
    END
    CLASS
        EXPRESSION 'sikh'
         SYMBOL ../icons/png/place_of_worship_sikh.p.16.png
    END
    CLASS
         SYMBOL ../icons/png/place_of_worship_unknown.p.16.png
    END
END

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=osm user=osm password=X port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM  5000
    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))) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'religion'
    CLASS
        EXPRESSION 'christian'
         SYMBOL ../icons/png/place_of_worship_christian.p.32.png
    END
    CLASS
        EXPRESSION 'buddhist'
         SYMBOL ../icons/png/place_of_worship_buddhist.p.32.png
    END
    CLASS
        EXPRESSION 'jewish'
         SYMBOL ../icons/png/place_of_worship_jewish.p.32.png
    END
    CLASS
        EXPRESSION 'muslim'
         SYMBOL ../icons/png/place_of_worship_islamic.p.32.png
    END
    CLASS
        EXPRESSION 'sikh'
         SYMBOL ../icons/png/place_of_worship_sikh.p.32.png
    END
    CLASS
         SYMBOL ../icons/png/place_of_worship_unknown.p.32.png
    END
END

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=osm user=osm password=X port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE POINT
    MAXSCALEDENOM 5000
    NAME "kirchen"
    DATA "way from (select centroid(way) as way,osm_id,place,name,amenity,religion from osm_polygon where building is not null and amenity='place_of_worship') as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'religion'
    CLASS
        EXPRESSION 'christian'
         SYMBOL ../icons/png/place_of_worship_christian.p.32.png
    END
    CLASS
        EXPRESSION 'buddhist'
         SYMBOL ../icons/png/place_of_worship_buddhist.p.32.png
    END
    CLASS
        EXPRESSION 'jewish'
         SYMBOL ../icons/png/place_of_worship_jewish.p.32.png
    END
    CLASS
        EXPRESSION 'muslim'
         SYMBOL ../icons/png/place_of_worship_islamic.p.32.png
    END
    CLASS
        EXPRESSION 'sikh'
         SYMBOL ../icons/png/place_of_worship_sikh.p.32.png
    END
    CLASS
         SYMBOL ../icons/png/place_of_worship_unknown.p.32.png
    END
END




LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=osm user=osm password=X port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 5000
    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))) as foo using unique osm_id using srid=900913"
    LABELITEM 'name'
    CLASSITEM 'religion'
    CLASS
        EXPRESSION 'christian'
        STYLE
         SYMBOL ../icons/png/place_of_worship_christian.p.32.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_buddhist.p.32.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_jewish.p.32.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_islamic.p.32.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_sikh.p.32.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_unknown.p.32.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

LAYER
    STATUS ON GROUP "default" PROJECTION "init=epsg:900913" END CONNECTIONTYPE postgis CONNECTION "host=localhost dbname=osm user=osm password=X port=5432" PROCESSING "CLOSE_CONNECTION=DEFER" 
    TYPE ANNOTATION
    MAXSCALEDENOM 5000
    NAME "kirchen"
    DATA "way from (select centroid(way) as way,osm_id,place,name,amenity,religion from osm_polygon where building is not null and 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_christian.p.32.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_buddhist.p.32.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_jewish.p.32.png
        END
        LABEL
            FONT sc
            TYPE TRUETYPE
            SIZE 7
            COLOR "#555555"
            OUTLINECOLOR "#ffffff"
            OUTLINEWIDTH 3
            BACKGROUNDSHADOWCOLOR 255 255 255
            ALIGN CENTER
            PRIORITY 2
            PARTIALS FALSE
            MAXLENGTH 8
            WRAP ' '
            POSITION auto
        END
    END
    CLASS
        EXPRESSION 'muslim'
        STYLE
         SYMBOL ../icons/png/place_of_worship_islamic.p.32.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 'sikh'
        STYLE
         SYMBOL ../icons/png/place_of_worship_sikh.p.32.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_unknown.p.32.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
END



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