LAYER
  NAME 'mv_routen_neu'
  TYPE LINE
  DUMP true
#hhhh
  TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 33085892.062600 5801127.840600 33475738.424200 6059362.322200
  INCLUDE "dbconnection.include"
  DATA 'the_geom FROM "route_35833" USING UNIQUE id USING srid=35833'
  METADATA
    'ows_title' 'mv_routen_neu'
    'WMS_EXTENT' '33085892.062600 5801127.840600 33475738.424200 6059362.322200'
    'WMS_SRS' 'EPSG:25833'
  END
  STATUS ON
  TRANSPARENCY 100
  PROJECTION
  ### "proj=tmerc"
  ### "lat_0=0"
  ### "lon_0=15"
  ### "k=0.9996"
  ### "x_0=33500000"
  ### "y_0=0"
  ### "ellps=GRS80"
  ### "units=m"
  ### "no_defs"
   "init=epsg:35833"
  END
  CLASS
    NAME 'WRRL-relevantes Gewässer'
    STYLE
      SYMBOL "circle"
       SIZE 2.0 
       COLOR 0 170 0
       OUTLINECOLOR 0 0 0
     END
  END
END


LAYER
  NAME 'land'
  GROUP 'klassen'
  TYPE LINE
  DUMP true
  MAXSCALEDENOM 44099
  SYMBOLSCALEDENOM 5000
  TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 33085892.062600 5801127.840600 33475738.424200 6059362.322200
  INCLUDE "dbconnection.include"
  DATA "the_geom from (Select id, ST_OffsetCurve(the_geom,25,'right', 'join=mitre mitre_limit=5.0') as the_geom, punktzahl_land AS punktzahl_gesamt FROM kartierabschnitt) as FOO USING UNIQUE id USING srid=35833"
  METADATA
    'ows_title' 'kartenabschnitte'
    'WMS_EXTENT' '33085892.062600 5801127.840600 33475738.424200 6059362.322200'
    'WMS_SRS' 'EPSG:25833'
    "gml_include_items" "all"
  END

  STATUS ON
  TRANSPARENCY 100
  PROJECTION
   "init=epsg:35833"
  END

  CLASSITEM 'punktzahl_gesamt'
  INCLUDE "gueteklassen.include"
END

LAYER
  NAME 'sohle'
  TYPE LINE
  GROUP 'klassen'
  DUMP true
  MAXSCALEDENOM 44099
  SYMBOLSCALEDENOM 5000
  TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 33085892.062600 5801127.840600 33475738.424200 6059362.322200
  INCLUDE "dbconnection.include"
  DATA "the_geom from (Select id, ST_OffsetCurve(ST_OffsetCurve(the_geom,21.5,'left', 'join=mitre mitre_limit=5.0'),the_geom,21.5,'left', 'join=mitre mitre_limit=5.0') as the_geom, punktzahl_sohle AS punktzahl_gesamt FROM kartierabschnitt) as FOO USING UNIQUE id USING srid=35833"
  METADATA
    'ows_title' 'kartenabschnitte'
    'WMS_EXTENT' '33085892.062600 5801127.840600 33475738.424200 6059362.322200'
    'WMS_SRS' 'EPSG:25833'
    "gml_include_items" "all"
  END

  STATUS ON
  TRANSPARENCY 100
  PROJECTION
   "init=epsg:35833"
  END

  CLASSITEM 'punktzahl_gesamt'
  INCLUDE "gueteklassen.include"
END

LAYER
  NAME 'ufer'
  TYPE LINE
  GROUP 'klassen'
  DUMP true
  MAXSCALEDENOM 44099
  SYMBOLSCALEDENOM 5000
  TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 33085892.062600 5801127.840600 33475738.424200 6059362.322200
  INCLUDE "dbconnection.include"
  DATA "the_geom from (Select id, ST_OffsetCurve(the_geom,20,'left', 'join=mitre mitre_limit=5.0') as the_geom, punktzahl_ufer AS punktzahl_gesamt FROM kartierabschnitt) as FOO USING UNIQUE id USING srid=35833"
  METADATA
    'ows_title' 'kartenabschnitte'
    'WMS_EXTENT' '33085892.062600 5801127.840600 33475738.424200 6059362.322200'
    'WMS_SRS' 'EPSG:25833'
    "gml_include_items" "all"
  END

  STATUS ON
  TRANSPARENCY 100
  PROJECTION
   "init=epsg:35833"
  END

  CLASSITEM 'punktzahl_gesamt'
  INCLUDE "gueteklassen.include"
END


LAYER
  NAME 'gesamt_weit'
  GROUP 'klassen'
  TYPE LINE
  DUMP true
  MINSCALEDENOM 44100
  MAXSCALEDENOM 1594000

  TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 33085892.062600 5801127.840600 33475738.424200 6059362.322200
  INCLUDE "dbconnection.include"
  DATA "the_geom from (Select id, the_geom, punktzahl_gesamt FROM kartierabschnitt) as FOO USING UNIQUE id USING srid=35833"

  METADATA
    'ows_title' 'gesamt_weit'
    'WMS_EXTENT' '33085892.062600 5801127.840600 33475738.424200 6059362.322200'
    'WMS_SRS' 'EPSG:25833'
    "gml_include_items" "all"
    'OWS_HIDDEN_LAYER' 'TRUE'
  END

  STATUS ON
  TRANSPARENCY 100
  PROJECTION
   "init=epsg:35833"
  END

  CLASSITEM 'punktzahl_gesamt'
  CLASS
    NAME 'klasse1'
    EXPRESSION ([punktzahl_gesamt] <= 5 AND [punktzahl_gesamt] >= 4.5)
    STYLE
      SYMBOL "circle"
       SIZE 2.0
       COLOR 0 0 255
       OUTLINECOLOR 0 0 0
     END
  END

  CLASS
    NAME 'klasse2'
    EXPRESSION ([punktzahl_gesamt] < 4.5 AND [punktzahl_gesamt] >= 3.5)
    STYLE
      SYMBOL "circle"
       SIZE 2.0
       COLOR 0 153 0
       OUTLINECOLOR 0 0 0
     END
  END

    CLASS
    NAME 'klasse3'
    EXPRESSION ([punktzahl_gesamt] < 3.5 AND [punktzahl_gesamt] >= 2.5)
    STYLE
      SYMBOL "circle"
       SIZE 2.0
       COLOR 255 255 0
       OUTLINECOLOR 0 0 0
     END
  END

 CLASS
    NAME 'klasse4'
    EXPRESSION ([punktzahl_gesamt] < 2.5 AND [punktzahl_gesamt] >= 1.5)
    STYLE
      SYMBOL "circle"
       SIZE 2.0
       COLOR 255 153 0
       OUTLINECOLOR 0 0 0
     END
  END

 CLASS
    NAME 'klasse5'
     EXPRESSION ([punktzahl_gesamt] < 1.5)
    STYLE
      SYMBOL "circle"
       SIZE 2.0
       COLOR 255 0 0
       OUTLINECOLOR 0 0 0
     END
  END
END


LAYER
  NAME 'Gewaesserabschnitt_weit'
  GROUP "klassen"
  TYPE LINE
  DUMP true
  MINSCALEDENOM 44100
  MAXSCALEDENOM 1594000
  TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 33085892.062600 5801127.840600 33475738.424200 6059362.322200
  INCLUDE "dbconnection.include"
  DATA 'the_geom FROM "kartierabschnitt" USING UNIQUE id USING srid=35833'

  METADATA
    'ows_title' 'Gewaesserabschnitte'
    'WMS_EXTENT' '33085892.062600 5801127.840600 33475738.424200 6059362.322200'
    'WMS_SRS' 'EPSG:25833'
    "gml_include_items" "all"
    'OWS_HIDDEN_LAYER' 'TRUE'

  END

 STATUS ON
  TRANSPARENCY 100
  PROJECTION
   "init=epsg:35833"
  END

  CLASS
    NAME 'Gewaesser'
    STYLE
      SYMBOL "circle"
       SIZE 2.0
       COLOR 148 171 250
       OUTLINECOLOR 0 0 0
    END
  END
END


LAYER
  NAME 'Gewaesserabschnitt'
  GROUP 'gewaesserabschnitt'
  TYPE LINE
  DUMP true
  MAXSCALEDENOM 44099
  SYMBOLSCALEDENOM 5000
  TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 33085892.062600 5801127.840600 33475738.424200 6059362.322200
  INCLUDE "dbconnection.include"
  DATA 'the_geom FROM "kartierabschnitt" USING UNIQUE id USING srid=35833'

  METADATA
    'ows_title' 'Gewaesser'
    'WMS_EXTENT' '33085892.062600 5801127.840600 33475738.424200 6059362.322200'
    'WMS_SRS' 'EPSG:25833'
    "gml_include_items" "all"
  END

 STATUS ON
  TRANSPARENCY 100
  PROJECTION
   "init=epsg:35833"
  END

  CLASS
    NAME 'Gewaesser'
    STYLE
      SYMBOL "circle"
       SIZE 13
       SIZE 12.0
       COLOR 148 171 250
       OUTLINECOLOR 0 0 0
    END
    # Paint black markers at start- and end of each segment
    STYLE
      ANGLE AUTO
      SYMBOL "marker"
      SIZE 12
      COLOR 0 0 0
      GEOMTRANSFORM start
    END
    STYLE
      ANGLE AUTO
      SYMBOL "marker"
      SIZE 12
      COLOR 0 0 0
      GEOMTRANSFORM "end"
    END
  END
END


LAYER
  NAME 'Gewaesserwerte'
  GROUP'gewaesserabschnitt'
  TYPE LINE
  DUMP true
  MAXSCALEDENOM 44099
  SYMBOLSCALEDENOM 5000
  EXTENT 33085892.062600 5801127.840600 33475738.424200 6059362.322200
  INCLUDE "dbconnection.include"
  DATA "the_geom from (Select id, the_geom, gewaesser_abschnitt FROM kartierabschnitt) as FOO USING UNIQUE id USING srid=35833"


  METADATA
    'ows_title' 'Gewaesserwerte'
    'WMS_EXTENT' '33085892.062600 5801127.840600 33475738.424200 6059362.322200'
    'WMS_SRS' 'EPSG:25833'
    'OWS_HIDDEN_LAYER' 'TRUE'

  END

 STATUS ON
  TRANSPARENCY 100
  PROJECTION
  "init=epsg:35833"
 END

 LABELITEM "gewaesser_abschnitt"
  CLASS
    LABEL
      TYPE TRUETYPE
      FONT "FreeSans"
      MINSIZE 10
      MAXSIZE 10
      ANGLE auto
      COLOR  000 000 000
      OUTLINECOLOR 255 255 255
      OUTLINEWIDTH 5
      POSITION cc
      PARTIALS TRUE
      MINDISTANCE 1
    END
  END
END

LAYER
  NAME 'gesamt_versetzt'
  TYPE LINE
  GROUP 'klassen'
  DUMP true
  MAXSCALEDENOM 44099
  SYMBOLSCALEDENOM 5000
  TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 33085892.062600 5801127.840600 33475738.424200 6059362.322200
  INCLUDE "dbconnection.include"
  # +++ Workarround +++
  # the following DATA-statement calculates a double-Offset because too
  # far away Offsets result in a segfault of the PostgreSQL-Server. It
  # seems like a deeper laying bug in GEOS > 3.2.2 though. Since this is
  # not fixed we stick to the resulting geometriess calculated by the
  # following code.
  DATA "the_geom from (Select id, ST_OffsetCurve(ST_OffsetCurve(the_geom,25,'left', 'join=mitre mitre_limit=5.0'),the_geom,25,'left', 'join=mitre mitre_limit=5.0') as the_geom, punktzahl_sohle AS punktzahl_gesamt FROM kartierabschnitt) as FOO USING UNIQUE id USING srid=35833"

  METADATA
    'ows_title' 'kartenabschnitte'
    'WMS_EXTENT' '33085892.062600 5801127.840600 33475738.424200 6059362.322200'
    'WMS_SRS' 'EPSG:25833'
    "gml_include_items" "all"
  END

  STATUS ON
  TRANSPARENCY 100
  PROJECTION
   "init=epsg:35833"
  END

  CLASSITEM 'punktzahl_gesamt'
  INCLUDE "gueteklassen.include"
END

LAYER
  NAME 'gesamt'
  TYPE LINE
  DUMP true
  MAXSCALEDENOM 44099
  SYMBOLSCALEDENOM 5000
  TEMPLATE fooOnlyForWMSGetFeatureInfo
  EXTENT 33085892.062600 5801127.840600 33475738.424200 6059362.322200
  INCLUDE "dbconnection.include"
  DATA "the_geom from (Select id, the_geom, punktzahl_gesamt FROM kartierabschnitt) as FOO USING UNIQUE id USING srid=35833"

  METADATA
    'ows_title' 'kartenabschnitte'
    'WMS_EXTENT' '33085892.062600 5801127.840600 33475738.424200 6059362.322200'
    'WMS_SRS' 'EPSG:25833'
    "gml_include_items" "all"
  END

  STATUS ON
  TRANSPARENCY 100
  PROJECTION
   "init=epsg:35833"
  END

  CLASSITEM 'punktzahl_gesamt'
  INCLUDE "gueteklassen.include"
END


END # End of Mapfile